Docstoc

Mortgage Amortization

Document Sample
Mortgage Amortization Powered By Docstoc
					Mortgage Amortization
This template creates a loan amortization schedule. All figures are based on the following five inputs: Principal, Interest Rate, Loan Period (years), the Base Year and the Base Month of the loan. The Amortization Schedule is in two parts--a monthly table for the first 12 months and an annual schedule for the remaining life of the loan. The template also calculates several key figures, including Annual Loan Payments, Monthly Payments, Interest Paid in the First Calendar year, Interest Paid over the Term of the Loan, and the Sum of All Payments over the Term of the Loan. To view the template, click the worksheet tab labeled Template at the bottom of the screen or press Ctrl-PgDn. With the exception of data entry cells, all cells are protected. Use the Tab key to move from one unprotected cell to the next.
Copyright © KMT Software, Inc. All Rights Reserved.

Mortgage Amortization
KEY FIGURES
Annual Loan Payments Monthly Payments Interest in First Calendar Year Interest Over Term of Loan Sum of All Payments

INPUTS
Loan Principal Amount Annual Interest Rate Loan Period in Years Base Year of Loan Base Month of Loan

PAYMENTS IN FIRST 12 MONTHS
Year 0 Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Beginning Balance Payments Principal Interest Cumulative Principal Cumulative Interest Ending Balance

YEARLY SCHEDULE OF BALANCES AND PAYMENTS
Year Beginning Balance Payments Principal Interest Cumulative Principal Cumulative Interest Ending Balance


				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:197
posted:1/8/2008
language:English
pages:2