|
|
|
|
|
|
|
|
|
|
| |
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
|
| |
Year
|
Month
|
Beginning Balance
|
Payment
|
Principal
|
Interest
|
Cumulative Principal
|
Cumulative Interest
|
Ending Balance
|
|
|
Jan
|
|
|
|
|
|
$20,625.00
|
$4,993,936.50
|
|
|
Feb
|
|
|
|
|
|
$41,224.99
|
$4,987,847.99
|
|
|
Mar
|
|
|
|
|
|
$61,799.86
|
$4,981,734.36
|
|
|
Apr
|
|
|
|
|
|
$82,349.51
|
$4,975,595.51
|
|
|
May
|
|
|
|
|
|
$102,873.84
|
$4,969,431.34
|
|
|
Jun
|
|
|
|
|
|
$123,372.74
|
$4,963,241.74
|
|
|
Jul
|
|
|
|
|
|
$143,846.11
|
$4,957,026.61
|
|
|
Aug
|
|
|
|
|
|
$164,293.84
|
$4,950,785.84
|
|
|
Sep
|
|
|
|
|
|
$184,715.83
|
$4,944,519.33
|
|
|
Oct
|
|
|
|
|
|
$205,111.97
|
$4,938,226.97
|
|
|
Nov
|
|
|
|
|
|
$225,482.16
|
$4,931,908.66
|
|
|
Dec
|
|
|
|
|
|
$245,826.28
|
$4,925,564.28
|
|
|
|
|
|
|
|
|
|
|
| |
Yearly Schedule of Balances and Payments
|
|
| |
Year
|
Beginning Balance
|
Payment
|
Principal
|
Interest
|
Cumulative Principal
|
Cumulative Interest
|
Ending Balance
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|