Skip to main content

Mortgage Amortization Schedule Generator Canada

Updated

Mortgage Amortization Calculator

$
%
Payment Amount$3,052
Total Payments$915,600
Total Interest$415,600
Interest Ratio83%

Amortization Schedule (First 5 Years)

Year Principal Paid Interest Paid Remaining Balance

Sample Amortization Schedule

$500,000 Mortgage at 5.5% over 25 Years (Monthly)

Year Principal Paid Interest Paid Balance Cumulative Interest
1 $9,680 $26,944 $490,320 $26,944
2 $10,228 $26,396 $480,092 $53,340
3 $10,807 $25,817 $469,285 $79,157
4 $11,418 $25,206 $457,867 $104,363
5 $12,064 $24,560 $445,803 $128,923
10 $15,540 $21,084 $377,058 $243,683
15 $20,022 $16,602 $285,115 $333,220
20 $25,797 $10,827 $164,022 $393,197
25 $33,233 $3,391 $0 $415,580

Key insight: In year 1, 74% of payments go to interest. By year 25, only 9% goes to interest.

How Amortization Works

Principal vs Interest Over Time

Phase Years Principal % Interest %
Early 1-5 26-33% 67-74%
Middle 10-15 42-55% 45-58%
Late 20-25 75-91% 9-25%

Why Interest Decreases

Factor Explanation
Interest calculated on balance Lower balance = less interest
Payment stays fixed Less interest = more to principal
Snowball effect Principal reduction accelerates

Impact of Interest Rate on Amortization

$500,000 Mortgage, 25-Year Amortization

Interest Rate Monthly Payment Total Interest % of Principal
4.0% $2,634 $290,181 58%
5.0% $2,908 $372,400 74%
5.5% $3,052 $415,600 83%
6.0% $3,200 $459,955 92%
6.5% $3,352 $505,450 101%
7.0% $3,509 $552,700 111%

At 7%, you pay more in interest than the original loan amount!

Impact of Amortization Period

$500,000 Mortgage at 5.5%

Amortization Payment Total Interest Interest Savings
30 years $2,839 $522,040
25 years $3,052 $415,600 $106,440
20 years $3,437 $324,880 $197,160
15 years $4,089 $236,020 $286,020

Shorter amortization = higher payments but massive interest savings.

Accelerating Your Amortization

Strategy 1: Increase Payment Frequency

Frequency Payments/Year Annual Total Interest Saved (25yr, $500k)
Monthly 12 $36,624
Bi-weekly 26 $39,520 $45,000
Accelerated bi-weekly 26 $39,676 $52,000
Weekly 52 $39,572 $48,000

Accelerated bi-weekly: Take monthly payment ÷ 2, pay 26 times = 13 monthly payments/year.

Strategy 2: Lump Sum Payments

Lump Sum When Interest Saved Years Saved
$10,000 Year 1 $18,500 1.1 years
$10,000 Year 5 $14,200 0.9 years
$10,000 Year 10 $9,800 0.6 years
$25,000 Year 1 $46,200 2.8 years

Earlier lump sums save more because they compound longer.

Strategy 3: Increase Monthly Payment

Extra Amount Interest Saved Years Saved
$100/month $42,000 2.5 years
$200/month $73,000 4.5 years
$500/month $131,000 8 years

Even $100/month makes a significant difference.

Payment Breakdown Visualization

Year 1 Monthly Payment: $3,052

Component Amount %
Interest $2,292 75%
Principal $760 25%

Year 25 Monthly Payment: $3,052

Component Amount %
Interest $282 9%
Principal $2,770 91%

Using Prepayment Privileges

Most mortgages allow extra payments:

Privilege Typical Limit Example
Lump sum 15-20% of original principal $75,000-100,000 annually
Payment increase 15-20% $3,052 → $3,662
Double-up 100% of regular payment $3,052 extra occasionally

Use these to accelerate your amortization without penalty.

Renewal Considerations

At each renewal (typically every 5 years):

Option Impact on Amortization
Keep same amortization Original payoff date maintained
Extend amortization Lower payments, more interest
Shorten amortization Higher payments, less interest
Re-amortize for 25 years Reset, lose progress

Tip: At renewal, consider maintaining the same payment even if rates drop. This accelerates payoff.