Amortization Schedule
Walk the loan year by year.
Generate a full amortization schedule for any CMHC-insured loan. See the interest-to-principal split, cumulative totals, balance at renewal, and visualize how each year's payment is allocated.
Non-monthly frequencies are approximated by dividing the annual payment evenly across periods.
Period payment (monthly)
$49,887
Monthly P+I: $49,887 · Annual debt service: $598,644
Balance at end of term (Y10)
$9,034,172
Principal paid through term: $965,828 · Interest paid: $5,020,616
Total over full amortization
$13,945,776
Interest paid · Principal: $10,000,000
Principal ■ · Interest ■
Y1
$598,644
Y2
$598,644
Y3
$598,644
Y4
$598,644
Y5
$598,644
Y6
$598,644
Y7
$598,644
Y8
$598,644
Y9
$598,644
Y10
$598,644
Y11
$598,644
Y12
$598,644
Y13
$598,644
Y14
$598,644
Y15
$598,644
Y16
$598,644
Y17
$598,644
Y18
$598,644
Y19
$598,644
Y20
$598,644
Y21
$598,644
Y22
$598,644
Y23
$598,644
Y24
$598,644
Y25
$598,644
Y26
$598,644
Y27
$598,644
Y28
$598,644
Y29
$598,644
Y30
$598,644
Y31
$598,644
Y32
$598,644
Y33
$598,644
Y34
$598,644
Y35
$598,644
Y36
$598,644
Y37
$598,644
Y38
$598,644
Y39
$598,644
Y40
$598,644
| Year | Interest | Principal | Debt service | Ending balance | % paid down |
|---|---|---|---|---|---|
| 1 | $523,202 | $75,443 | $598,644 | $9,924,557 | 0.8% |
| 2 | $519,144 | $79,500 | $598,644 | $9,845,057 | 1.5% |
| 3 | $514,869 | $83,776 | $598,644 | $9,761,282 | 2.4% |
| 4 | $510,363 | $88,281 | $598,644 | $9,673,000 | 3.3% |
| 5 | $505,615 | $93,029 | $598,644 | $9,579,971 | 4.2% |
| 6 | $500,612 | $98,033 | $598,644 | $9,481,939 | 5.2% |
| 7 | $495,340 | $103,305 | $598,644 | $9,378,634 | 6.2% |
| 8 | $489,784 | $108,861 | $598,644 | $9,269,773 | 7.3% |
| 9 | $483,929 | $114,716 | $598,644 | $9,155,057 | 8.4% |
| 10 (term end) | $477,759 | $120,885 | $598,644 | $9,034,172 | 9.7% |
| 11 | $471,258 | $127,387 | $598,644 | $8,906,786 | 10.9% |
| 12 | $464,407 | $134,238 | $598,644 | $8,772,548 | 12.3% |
| 13 | $457,187 | $141,457 | $598,644 | $8,631,091 | 13.7% |
| 14 | $449,579 | $149,065 | $598,644 | $8,482,026 | 15.2% |
| 15 | $441,562 | $157,082 | $598,644 | $8,324,944 | 16.8% |
| 16 | $433,114 | $165,530 | $598,644 | $8,159,413 | 18.4% |
| 17 | $424,212 | $174,433 | $598,644 | $7,984,980 | 20.2% |
| 18 | $414,830 | $183,814 | $598,644 | $7,801,166 | 22.0% |
| 19 | $404,944 | $193,700 | $598,644 | $7,607,466 | 23.9% |
| 20 | $394,527 | $204,118 | $598,644 | $7,403,349 | 26.0% |
| 21 | $383,549 | $215,095 | $598,644 | $7,188,253 | 28.1% |
| 22 | $371,981 | $226,664 | $598,644 | $6,961,590 | 30.4% |
| 23 | $359,790 | $238,854 | $598,644 | $6,722,736 | 32.8% |
| 24 | $346,944 | $251,700 | $598,644 | $6,471,036 | 35.3% |
| 25 | $333,407 | $265,237 | $598,644 | $6,205,799 | 37.9% |
| 26 | $319,143 | $279,502 | $598,644 | $5,926,297 | 40.7% |
| 27 | $304,110 | $294,534 | $598,644 | $5,631,763 | 43.7% |
| 28 | $288,270 | $310,375 | $598,644 | $5,321,388 | 46.8% |
| 29 | $271,577 | $327,067 | $598,644 | $4,994,321 | 50.1% |
| 30 | $253,987 | $344,657 | $598,644 | $4,649,664 | 53.5% |
| 31 | $235,451 | $363,194 | $598,644 | $4,286,470 | 57.1% |
| 32 | $215,917 | $382,727 | $598,644 | $3,903,743 | 61.0% |
| 33 | $195,334 | $403,311 | $598,644 | $3,500,432 | 65.0% |
| 34 | $173,643 | $425,002 | $598,644 | $3,075,431 | 69.2% |
| 35 | $150,785 | $447,859 | $598,644 | $2,627,572 | 73.7% |
| 36 | $126,699 | $471,946 | $598,644 | $2,155,626 | 78.4% |
| 37 | $101,317 | $497,328 | $598,644 | $1,658,298 | 83.4% |
| 38 | $74,569 | $524,075 | $598,644 | $1,134,223 | 88.7% |
| 39 | $46,384 | $552,261 | $598,644 | $581,962 | 94.2% |
| 40 | $16,682 | $581,962 | $598,644 | $0 | 100.0% |