Enter Amount of Loan, Period (months), Annual Rate %, and Date of Closing. Click Recalculate and the spreadsheet will clear and create a month-by-month 7-column schedule including interest, principal, and balance. At the bottom, a Summary of Payments (year, interest, principal) is included.
Click the checkbox to switch modes so you can enter customized payments to see their effect on the total amount of interest you will pay, and the number of payments.
A Help tab explains the features. Excel 2003 with VBA macros.

You must sign-in or register to comment on templates


    Creating Document...