Can someone help with this problem? Also attached picture. ThanksPrepare an amortization schedule for a five-year loan of $59,000. Assume the loan agreement calls for a principal reduction of $11,800 every year. The interest rate is 7 percent per year. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16. Leave no cells blank - be certain to enter "0" wherever required.) Year BeginningBalance TotalPayment InterestPayment PrincipalPayment EndingBalance1 $ $ $ $ $ 2 3 4 5 How much total interest is paid over the life of the loan? (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) Total interest paid $

6:18 II'I "5" E} Done ezto.mheducation.com C value. 4.00 points Prepare an amortization schedule for a five-year loan of $59,000. Assume the loan agreement calls for a principal reduction of $11,800 every year. The interest rate is 7 percent per year. (Do not round intermediate calculations and round your answers to 2 decimal placesI e.g., 32.16. Leave no cells blank - be certain to enter "0" wherever required.) Beginning Total Interest Principal Balance Payment Payment Payment Ending Ba la nae $- $- Year 1 $- s $ DDDDI DEBUG DEBUG DDDDI DDDDI How much total interest is paid over the life of the loan? (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) Total interest paid $ C] References eBook & Resources Worksheet Learning Objective: 06-03 How loans are amortized or paid off. Difficulty: Section: 6.4 Loan Types and Intermediate Loan Amortization Qheck my work