Loan Amortization Excel - Free Download
4.1,
3069
votes
Please vote for this template if it helps you.
Mortgage Amortization
Year Month
Beginning
Balance
Payment Principal Interest
Cumulative
Principal
Cumulative
Interest
0 Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Year
Beginning
Balance
Payment Principal Interest
Cumulative
Principal
Cumulative
Interest
Ending
Balance
Loan period in years
Base year of loan
Yearly Schedule of Balances and Payments
Payments in First 12 Months
Key Figures
Inputs
Base month of loan
Annual loan payments
Monthly payments
Interest in first calendar year
Interest over term of loan
Sum of all payments
Loan principal amount
Annual interest rate
