Mortgage Amortization Schedule Calculator

The full schedule of a mortgage: what each payment pays in interest and in principal, and the balance it leaves, from the first payment to the last. See it by year or payment by payment, and download it as a spreadsheet.

The rate starts at the average on new uninsured 5-year mortgages in August 2026, from the Bank of Canada (all mortgage rates).

$
%
$

Optional prepayment

Monthly payment

$3,347.57

300 payments, the last in Nov 2051.

Total interest

$404,272

Total paid

$1,004,272

Paid off

25.0 years

Principal passes interest

Sep 2036

One rate for the whole amortization, compounded semi-annually like every Canadian mortgage. In practice the rate is reset at each renewal: the payment calculator shows what one term does.

Year by Year

YearPeriodInterestPrincipalBalance
1Dec 2026 to Nov 2027$26,949$13,222$586,778
2Dec 2027 to Nov 2028$26,336$13,835$572,943
3Dec 2028 to Nov 2029$25,695$14,476$558,468
4Dec 2029 to Nov 2030$25,025$15,146$543,321
5Dec 2030 to Nov 2031$24,323$15,848$527,474
6Dec 2031 to Nov 2032$23,589$16,582$510,892
7Dec 2032 to Nov 2033$22,821$17,350$493,542
8Dec 2033 to Nov 2034$22,017$18,154$475,388
9Dec 2034 to Nov 2035$21,176$18,995$456,393
10Dec 2035 to Nov 2036$20,296$19,875$436,518
11Dec 2036 to Nov 2037$19,376$20,795$415,723
12Dec 2037 to Nov 2038$18,412$21,759$393,964
13Dec 2038 to Nov 2039$17,404$22,767$371,198
14Dec 2039 to Nov 2040$16,350$23,821$347,376
15Dec 2040 to Nov 2041$15,246$24,925$322,451
16Dec 2041 to Nov 2042$14,091$26,079$296,372
17Dec 2042 to Nov 2043$12,883$27,288$269,084
18Dec 2043 to Nov 2044$11,619$28,552$240,533
19Dec 2044 to Nov 2045$10,297$29,874$210,659
20Dec 2045 to Nov 2046$8,913$31,258$179,400
21Dec 2046 to Nov 2047$7,465$32,706$146,694
22Dec 2047 to Nov 2048$5,950$34,221$112,473
23Dec 2048 to Nov 2049$4,364$35,807$76,666
24Dec 2049 to Nov 2050$2,706$37,465$39,201
25Dec 2050 to Nov 2051$970$39,201$0
Total$404,272$600,000

How to Read an Amortization Schedule

Every payment is the same, but what it buys changes. Interest is charged on the balance still owed, so the first payments on a large balance are mostly interest and move the balance little; as the balance falls, the interest in each payment falls with it and the rest goes to principal. The schedule marks the payment where principal first exceeds interest: at today's rates that comes about ten years into a 25-year amortization, and later still on a 30-year one. It also shows why the first renewal matters so much: after five years the balance is still most of what you borrowed, so the rate you renew at applies to nearly the whole mortgage.

What Shortens It

Anything that pays principal sooner cuts the interest on every payment after it. Accelerated bi-weekly payments, half the monthly payment every two weeks, make the equivalent of one extra monthly payment a year and take two to three years off a 25-year amortization. A fixed extra amount on each payment, entered above, does the same in proportion. A lump sum once a year does it in one go: our prepayment calculator shows the saving on each, and the payment frequency calculator compares the frequencies side by side. Most lenders allow 10% to 20% of the original mortgage in prepayments each year without penalty.

Amortization and Term

The amortization is how long the whole mortgage takes to pay off at the current payment, 25 years at most on an insured mortgage, or 30 for a first-time buyer or a new build, and 30 or more without insurance. The term is how long the rate is set for, usually five years. The schedule above assumes one rate from start to finish; at each renewal the rate changes and the lender recomputes the payment over the amortization left, so the real schedule is a chain of these, one per term. The mortgage payment calculator shows the interest and principal of a single term.

Today's Mortgage Rates from Lenders

This calculator works with whatever rate you enter. Compare it with the rates lenders are offering right now, fixed and variable, by term. Change the price, down payment or location to match your purchase.

Ratehub.ca is a mortgage brokerage and comparison site. HousingPortal.ca may be paid when you follow this link; it costs you nothing and we see none of your details. How we're paid

Advertisement

Related guides & tools

The information presented on HousingPortal.ca is intended for general illustrative purposes only. While the information is believed to be reliable, it cannot be guaranteed for accuracy, completeness, or currency. Neither HousingPortal.ca and its employees, nor any other party identified in this guide/report, assumes any liability for the information provided. The views and opinions expressed by the analysts at HousingPortal.ca are their own and should not be considered as investment advice. It is recommended that you seek the advice of a licensed real estate professional before making any decisions regarding real estate investments.