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. Mortgage Amortization KEY FIGURES INPUTS Annual Loan Payments Loan Principal Amount Monthly Payments Annual Interest Rate Interest in First Calendar Year Loan Period in Years Interest Over Term of Loan Base Year of Loan Sum of All Payments Base Month of Loan PAYMENTS IN FIRST 12 MONTHS Beginning Cumulative Cumulative Ending Year Month Balance Payments Principal Interest Principal Interest Balance 0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YEARLY SCHEDULE OF BALANCES AND PAYMENTS Beginning Cumulative Cumulative Ending Year Balance Payments Principal Interest Principal Interest Balance