You are an employee of University Consultants, Ltd and have been given the following information. You are to present an investment analysis of a new small income-producing property for sale to a potential investor. The asking price for the property is $8.5 million. You determine that the building was worth $7.225 million and could be depreciated over 39 years (use 1/39 per year). NOIs are estimated to be $901,375 for year 1, $900,681 for year 2, $899,962 for year 3, $943,700 for year 4, $961,855 for year 5 and expected to increase by 3.16% thereafter. A fully amortizing 70 percent loan can be obtained at 10 percent interest for 20 years (total annual payments will be monthly payments *12). The property is expected to be sold for $9,360,805 after 5 years. Capital gains from price appreciation will be taxed at 15 percent and depreciation recapture will be taxed at 25 percent. Your ordinary income will be taxed at 35 percent. Assume that there is no selling cost and the equity discount rate is 13%.

1a. What is the mortgage loan balance by the end of year 5?

1b. What is the debt service for year 4?

1c. What is the first-year debt coverage ratio?

1d. What is the first-year equity dividend rate?

1e. What is the annual interest dollar amount in year 2?