1.) An investor is planning to purchase a new apartment property for $1.5 million. He can obtain an 80% loan for 30 years at 10%. NOI is expected to be $500,000 in the first year and grow at a rate of 2% for the next three years along with the underlying value of the building. The building and improvements represent 80% of value and are depreciated over a 27.5 useful life for an annual depreciation allowance of $43,636. The project is expected to sell after three years, and the investors are subject to a 30% tax rate. Create pro forma cash flow statements to solve the following problems.

a. Find the BTIRR and ATIRR.

b. Find the unlevered BTIRR and ATIRR

c. Computer the Break-even interest rate (BEIR).

2. Consider the pro forma cash flow statement created in part A of problem 2. You could pay $30,000 today for a renovation that would cause the NOI and overall value to increase by 3% annually rather than 2%. If an equivalent risk investment earns a 12% rate of return, should you renovate the property?