Docstoc

Mortgage amortization schedule Template

Document Sample
Mortgage amortization schedule Template Powered By Docstoc
					Mortgage Amortization
Inputs                                                      Key Figures
Loan principal amount                                       Annual loan payments
Annual interest rate                                        Monthly payments
Loan period in years                                        Interest in first calendar year
Base year of loan                                           Interest over term of loan
Base month of loan                                          Sum of all payments

Payments in First 12 Months
                        Beginning                                          Cumulative         Cumulative
Year   Month                        Payment     Principal   Interest                                       Ending Balance
                        Balance                                            Principal          Interest
0      Jan
       Feb
       Mar
       Apr
       May
       Jun
       Jul
       Aug
       Sep
       Oct
       Nov
       Dec

Yearly Schedule of Balances and Payments
       Beginning                                            Cumulative     Cumulative         Ending
Year                    Payment     Principal   Interest
       Balance                                              Principal      Interest           Balance

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