Prepare an amortization schedule for a 3-year loan of $40,000. The interest rate is 11 percent per year and the loan calls for equal annual payments. How much interest is paid in the third year? How much total interest is paid over the life of the loan?© BrainMass Inc. brainmass.com February 24, 2021, 2:06 pm ad1c9bdddf
In this solution I have provided an excel sheet with embedded formulas. I have shown loan amortization schedule for a three year loan with equal installments. I have also calculated the interest paid in the last year as well as the total interest paid. A good example of how loan amortization works.