Anwer the following questions based on the table above.

1. Based on NOI projection for the first year, estimate the mortgage loan that will be available if the lender requires a debt-coverage ratio of not less than 1.20. Anticipated loan terms are interest at 8.5% per annum, and level monthly payments to amortize the loan over 20 years. No discount points or loan origination fee is anticipated.
2. Round your mortgage loan estimate from Assignment 1, to the nearest $100,000. Modify the St. George Apartments projection to derive a seven-year projection of before-tax cash flow, based on this loan.
3. Using the mortgage loan from Assignment 2, develop a seven-year amortization schedule for the St. George Apartments. Include an anticipated remaining mortgage balance at the end of seven years. Using the forecasted future market value developed in Assignment 3 of the Case Problem for Part Two (rounded to the nearest $100,000), estimate before-tax cash flow from disposal, assuming the following: a. The property is sold at the end of the seventh year (i.e., before the first debt-service payment falls due for the eighth year) b.Transaction costs (brokerage, legal and accounting fees, and so forth) equal 8% of the selling price.

PLEASE USE EXCEL!!!

The St. George Apartments Reconstructed Operating Statement The St. George Apartments Reconstructed Operating Statement