Please show me the answer with the excel formula. Thanks!

Question 6 - Loan Amortization Schedules Answer all question parts below. Use blank spaces to perform any necessary calculations. CELL REFERENCE AND USE EXCEL FUNCTIONS APPROPRIATELY. Format appropriately. Prepare an amortization schedule for a 9 year loan of $77,000. The interest rate is 6.5% per year, and the loan calls for equal annual payments. Amortization Schedule: Year Beg. Bal PMT Interest Principal End. Bal How much interest is paid in year 6? How much total interest is paid over the life of the loan