please answer using excel formulas

Punction Defined Formula Library Names Auditing Options Calculation F16 Prepare an amortization schedule for a five-year loan of $67,500. The interest rate is 7 percent per year, and the loan calls for equal annual payments. How much total interest is paid over the life of the loan? 67,500 Loan amount $ Interest rate Loan term 11 Complete the following analysis. Do not hard code values in your calculations. All answers should be positive, 13 Loan payment 1$ 67,500.00 S 4.725.00 Totatinterest nad