A company is negotiating loan terms with a bank. The company would like to purchase a property for $2.5 million. The property is projected to produce a first-year NOI of $180,000. Loan: The bank is willing to allow the loan to negatively amortize; however, the loan will need to be paid back at the end of the four-year period. Because of the risky nature of such loan, the bank will allow a 65 percent LTV loan on the property at the time of its purchase. It also requires a DCR in the first year of at 1.30. The contract (or the accrual) rate of interest on the loan is 12 percent. All loan payments are to be made monthly.

a. Show the loan amortization schedule for the next four years: Year 1, Year 2, Year 3 and Year 4, no months. Show and explain all calculations.

b. If the property value does not change, what will the loan-to-value ratio be at the end of the four-year period? Calculate. Show and explain all calculations.

c. Since the loan balance will be due in four years, lets say the bank would like to make sure that the LTV at that time does not exceed 70 percent. To make this happen, how should the company counter-offer the asking price? Calculate the counter-offer price. Show and explain all calculations.