CALCULATING AN AMORTIZATION SCHEDULE

b) The spreadsheet will display the effective interest rate of this loan. Because the payment amounts vary, the effective interest rate is calculated with the internal rate of return function in the spreadsheet. … ................
................