PLEASE HELP ME . Thanks in advance

F G H J 1 Problem # 2: 2 A real estate investor is considering purchasing a small warehouse. Analysis has resulted in the following facts: 3 The asking price is $750,000. There are 22,000 sq. ft of leasable area. The expected rent is $3.75/sq ft per year; 4 rents are expected to increase at 1.5% for first two years, 2% for the next two years and 3.5% in the final two years. 5 Since the property is leased to an AAA-grade tenant for 25 more years, no vacancy factor is deducted. 6 The tenant will pay all operating expenses except property taxes and insurance. These two expenses will be equal 7 to 18% of EGI each year. 8 The investor can borrow 75% of the total cost for 20 years at an interest rate of 7.75% with monthly payments and up-front financing costs equal to 3.5% of the amount borrowed. 0 80% of the total acquisition cost is depreciable over the useful life of 39 years using straight-line depreciation method. 1 The investor expects to sell the investment at the end of the year 6 and investor's ordinary income tax rate is 35% 2 No capital expenditures have been made since acquisition. 3 4 Compute the after-tax cash flows from the annual rental operations over the six year period. 5 6 7 8 9 1 F G H J 1 Problem # 2: 2 A real estate investor is considering purchasing a small warehouse. Analysis has resulted in the following facts: 3 The asking price is $750,000. There are 22,000 sq. ft of leasable area. The expected rent is $3.75/sq ft per year; 4 rents are expected to increase at 1.5% for first two years, 2% for the next two years and 3.5% in the final two years. 5 Since the property is leased to an AAA-grade tenant for 25 more years, no vacancy factor is deducted. 6 The tenant will pay all operating expenses except property taxes and insurance. These two expenses will be equal 7 to 18% of EGI each year. 8 The investor can borrow 75% of the total cost for 20 years at an interest rate of 7.75% with monthly payments and up-front financing costs equal to 3.5% of the amount borrowed. 0 80% of the total acquisition cost is depreciable over the useful life of 39 years using straight-line depreciation method. 1 The investor expects to sell the investment at the end of the year 6 and investor's ordinary income tax rate is 35% 2 No capital expenditures have been made since acquisition. 3 4 Compute the after-tax cash flows from the annual rental operations over the six year period. 5 6 7 8 9 1