New in version 2: Refinance calculator + many enhancements.

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. Also creates a Summary of Payments with interest and principle broken out by year.

Click a checkbox to switch modes so you can enter customized payments to see their effect on the total payment and the number of payments.

A new tab holds a copy of one loan schedule, and summarizes differences compared to a second loan schedule, including the break-even date.

A Help tab explains the features. Excel 2003 with VBA macros. Upward compatible.

You must sign-in or register to comment on templates

    SpreadsheetZone

    Creating Document...