Hello tutor, I need assistance with creating an excel spreadsheet for the Loan below and to answer the following questions.

Loan Amount 3,150,000,

original annual interest rate 6.12%,

Loan Term 10 years,

Loan Amortization 20 years,

Monthly Payment $22,786.19

Loan prepayment calculation. What is the difference in interest payments due between the interest due based on original annual interest rate of 6.12% and the interest due based on the new interest rate of 5.15%, then discount the monthly differences in interest rate payments from the date of prepayment to the maturity date for the advance utilizing a net present value analysis, using the new interest rate as the discount rate. The monthly Principle Due payment schedule should not change.

Questions:

1. Please calculate the prepayment penalty that would apply to this loan at a new interest rate of 5.15% assuming the loan is prepaid immediately after closing.

2. How does the prepayment penalty change if the loan is prepaid in Month 60?