Please answer all parts based on info given in the first picture. Thank you very much!!

Complete this question by entering your answers in the tabs below. What would be the maximum loan amount that the lender would make if the debt coverage ratio was 120 for year 17 . What would be the loan-to-value ratio? (Do not round intermediate calculations. Round "Loan-to-value ratio" to 2 decimal places.) Complete this question by entering your answers in the tabs below. Support your answer with a cash flow statement. (Do not round intermediste calculations. Round "OCR" to 2 decimal places.) Complete this question by entering your answers in the tabs below. Support your answer with a cash flow statement for a five-year period. (Do not round intermediate calculations. Round to 2 decimal places.) A developer wants to finance a project costing $1.5 million with a 70 percent, 20 -year loan at an interest rate of 4.5 percent. The project's NOF is expected to be $100,000 during year 1 and the NOl, as well as its value, is expected to increase at an annual rate of 2 percent thereafter. The lender will require an initial debt coverage ratio of at least 1.20 Required a-1. Would the lender be likely to make the loan to the developer? a-2. Support your answer with a cash flow statement for a five-year period a-3. What would be the developer's before-tax yjeld on equily (BTiRR)? b. What would be the maximum loan amount that the lender would make if the debt coverage ratio was 1.20 for year t? What would be the loan-to value ratio? c. Assuming conditions in part (o), suppose that mortgage interest rates suddenly increase from 4.5 percent to 6.5 percent. NOI and value will now increase at a rate of 5 percent. o-1 If the desired DCR is 1.20 , will the lender be as willing to make a conventional loan now? e.2. Support your answer with a cash flow statement. Complete this question by entering your answers in the tabs bolow. Wovid the lender be fikely to make the loan to the develaper? Complete this question by entering your answers in the tabs below. What would be the developer's before-tax yleld on equity (BTIRR)? (Do not round intermediate calculations. Round your final answer to 2 decimal placesi)