Lender lends $10,000,000 to an investor that uses the proceeds to finance, the acquisition of a $15,000,000 investment property. Investor is required to make monthly payments based on an interest rate of 5.25% for 5 years, at which point the loan matures. The mortgage payments are to be established with an amortization period of 25 years.

1. What would the monthly payments be on the loan from the local bank?

2. How much is still owed on this loan after 50 monthly payments?

Please utilize excel