Mortgage Amortization Calculator — Full Payment Schedule

What Is a Mortgage Amortization Calculator?

A mortgage amortization calculator shows the full payment schedule for a mortgage — every payment from the first month to the last, with each payment broken into its principal and interest components and the remaining balance after each payment. This is different from a mortgage payment calculator, which only tells you the payment amount. The amortization table is the tool used to understand how much of your mortgage you have paid off at any point in time.

Amortization Schedule vs. Mortgage Payment Calculator

The mortgage payment calculator tells you what your regular payment amount will be. The amortization calculator goes further — it shows the full schedule: every payment from month one to the last, how much of each payment is interest versus principal, and the remaining balance after each payment. The amortization table is what you use to find your crossover point, project your balance at any future date, and plan prepayments strategically.

Monthly View and Annual Summary — How to Read the Table

The calculator supports both a monthly view — showing every individual payment over the full amortization — and an annual summary, which collapses the schedule into one row per year showing totals for interest paid, principal paid, and closing balance. For a 25-year amortization, the monthly view produces 300 rows; the annual summary produces 25. The annual summary is particularly useful for planning at renewal dates: look up the balance at year 5 and year 10 to see exactly how much principal you have repaid at each term boundary. This covers both “amortization calculator in months” and “amortization calculator annual payments” use cases.

Want to recreate this amortization schedule in your own spreadsheet? Our guide to building a Canadian mortgage calculator in Excel walks through the formulas.

How Amortization Works in Canada

In a standard Canadian mortgage, each payment covers the interest accrued since the last payment plus a portion of the principal. Early in the amortization, most of each payment goes toward interest — on a $500,000 mortgage at 5.00% in year one, approximately 70% of each payment ($2,062 of $2,908) is interest. By year 20, the proportion reverses: more than 60% of each payment goes toward principal. Canadian mortgage interest compounds semi-annually by law, which is the basis for all amortization calculations on this page.

Principal vs. Interest — Why Early Payments Are Mostly Interest

On a $500,000 Canadian mortgage at 5.00% over 25 years, approximately 70% of the first year's payments go toward interest — only $10,386 of the $34,896 paid in year one reduces the actual loan balance. This interest-heavy early period is a natural consequence of how amortization math works: interest is calculated on the full outstanding balance, which is highest in the early years. As principal is repaid month by month, the interest portion of each payment shrinks and the principal portion grows — slowly at first, then accelerating as the balance falls.

Canadian Semi-Annual Compounding Explained

Canadian mortgage interest compounds semi-annually by law — not monthly as in the United States — making Canadian amortization calculations slightly different from US mortgage calculators at the same nominal rate. The effective monthly rate formula required by the Interest Act is: (1 + annual rate ÷ 2)^(1/6) − 1. At a stated rate of 5.00%, this yields an effective monthly rate of approximately 0.4124%, versus 0.4167% for monthly compounding. The difference compounds across 300 payments.

Monthly payment baseline: $2,908. Annual payments = $2,908 × 12 = $34,896. Canadian semi-annual compounding applied throughout. All figures verified.

Amortization Period vs. Mortgage Term

The amortization period is the total length of time to pay off the full mortgage — typically 25 or 30 years in Canada. The mortgage term is the period for which your interest rate is locked in — typically 1 to 5 years. At the end of each term, you renew at the current rate. Your amortization period continues across multiple terms. A 25-year amortization may involve five 5-year terms at different interest rates — the amortization schedule reflects the full journey, not just the current term.

Why Your Term Ends Before Your Mortgage Does

Most Canadian homeowners take a 5-year fixed-rate term on a 25-year amortization. When the term expires after 5 years, the mortgage is far from paid off — a large balance remains. The homeowner then renews at whatever the current market rate is. The amortization schedule reflects the full journey across all terms, but the rate in subsequent terms is unknown at origination. This calculator models the current rate across the full schedule; for renewal planning, use the mortgage renewal calculator.

What Happens to Your Amortization at Renewal

At the end of a 5-year term on a $500,000 mortgage with 25-year amortization at 5%, the outstanding balance is approximately $442,500 — only $57,462 of the $174,482 paid over five years went to principal; the rest was interest. At renewal, if rates have changed, the new payment amount will differ from the original, but the remaining amortization continues from the current balance. A higher rate at renewal means more of each payment goes to interest and less to principal, slowing equity building.

Comparing Amortization Periods — 15, 20, 25, and 30 Years

Choosing a longer amortization period lowers your monthly payment but increases total interest paid. On a $500,000 mortgage at 5.00%: a 25-year amortization produces a monthly payment of approximately $2,908 and total interest of approximately $372,000. A 30-year amortization reduces the monthly payment to approximately $2,668 — saving $240 per month — but increases total interest by roughly $88,000. A 15-year amortization raises the monthly payment to approximately $3,941 but cuts total interest to approximately $209,000.

“vs. 30-Year” column shows total interest savings relative to the 30-year baseline. Assumes constant 5.00% rate throughout; actual total interest varies with renewal rates.

Is a 30-Year Amortization Worth It?

Choosing a 30-year amortization over 25 years on a $500,000 mortgage at 5% saves approximately $240 per month but costs approximately $88,000 more in total interest over the life of the loan. Whether this trade-off is worthwhile depends on cash flow and what you do with the monthly saving. For buyers prioritizing equity building and minimizing lifetime interest cost, the 25-year amortization wins clearly. A 15-year amortization on a $500,000 mortgage at 5% increases the monthly payment by approximately $1,033 compared to a 25-year term — but reduces total interest paid by approximately $163,000.

How to Use the Amortization Schedule to Plan Prepayments

The amortization schedule reveals your mortgage's crossover point — the month when your principal repayment finally exceeds your interest payment. On a $500,000 mortgage at 5.00% over 25 years, that crossover occurs around year 11 (month 133). Identifying your balance at any future date lets you plan lump sum prepayments strategically — for example, knowing your balance at year 5 tells you exactly how much of a $50,000 prepayment would be applied to principal versus what remains. Use the schedule alongside the prepayment calculator for full planning.

Finding Your Crossover Point — When Principal Exceeds Interest

The crossover point — when principal repayment in a single payment finally exceeds interest — occurs around year 11 on a $500,000 mortgage at 5.00% over 25 years; making extra payments moves this crossover earlier. To find your crossover, scroll down the monthly schedule until the “Principal” column first exceeds the “Interest” column. At higher interest rates, the crossover comes later; at lower rates, it comes sooner. Making even modest extra payments each year accelerates the crossover by compressing the amortization schedule and reducing the balance on which future interest accrues.

Projecting Your Balance at Any Future Date

The amortization table is the most precise tool for projecting your outstanding balance at any future date — critical for planning refinancing, renewals, or lump sum prepayments. Read the balance at your term renewal date (e.g., year 5) to know exactly how much principal remains. At the end of a 5-year term at 5%, approximately $442,500 of a $500,000 mortgage remains outstanding — confirming that the early years of a mortgage are dominated by interest, not equity. Use this balance alongside the prepayment calculator to model the effect of a lump sum at renewal.

Sources

1. Government of Canada — Interest Act — semi-annual compounding requirement
2. Canada Mortgage and Housing Corporation (CMHC) — CMHC insured mortgage amortization rules
3. Financial Consumer Agency of Canada (FCAC) — FCAC mortgage terms and amortization guide
4. Bank of Canada — Current Canadian interest rates