Welcome to SpreadsheetZONE, Login or Register

    

V2.0 Loan or Mortgage Calc [refinance, extra Pmts, schedules]

+Like us on Facebook
+Like us on Twitter
     
Title:
V2.0 Loan or Mortgage Calc [refinance, extra Pmts, schedules]
Author:
Ed Chuhta
Downloads:
1955
Rating:
Language:
English


Overview:
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