Welcome to SpreadsheetZONE, Login or Register

    

Loan or Mortgage Calc [schedules, extra Pmts]

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


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