Fill in Starting Principal, Interest Rate and Monthly Payments
and the spreadsheet will calculate the portion of each payment that will
be interest, the protion that will be applied to the principal, and the
remaining principal for each month.
This amortization covers 5 years (60 months). To go further, save the
month, year, and starting principal on the last line of the spreadsheet.
Clear the form and enter the values you saved in the first row along with
interest rate and monthly payments. The spreadsheet will calculate the
next 5 years of the loan. |