Working with interest in an amortization schedule with equal payments. Attachments in Excel.

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?

© SolutionLibrary Inc. solutionlibary.com 9836dcf9d7 https://solutionlibrary.com/business/finance/working-with-interest-in-an-amortization-schedule-with-equal-payments-attachments-in-excel-2a5