Explore BrainMass

Explore BrainMass

    Loan amortization schedule and total interest calculation.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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

    Solution Summary

    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.