A developer wants to finance a project costing $1.6 million with a 70 percent, 20-year loan at an interest rate of 5.0 percent. The projects NOI is expected to be $100,000 during year 1 and the NOI, as well as its value, is expected to increase at an annual rate of 2.5 percent thereafter. The lender will require an initial debt coverage ratio of at least 1.20. A. Would the lender be likely to make the loan to the developer? Support your answer with a cash flow statement for a five-year period. What would be the developers before-tax yield on equity (BTIRR)? B. Based on the projection in (a), what would be the maximum loan amount that the lender would make if the debt coverage ratio was 1.20 for year 1? What would be the loan-to-value ratio?

*Please include excel formulas