Payment-level mortgage analysis

Amortization Schedule Generator Canada

Generate annual and payment-by-payment Canadian mortgage schedules with six payment frequencies, recurring extra payments, term totals, and full CSV and PDF export.

Payment-level scheduleAnnual summariesSix frequenciesRecurring extras

Calculation inputs

Generate a full Canadian amortization schedule

Create payment-by-payment and annual schedules with principal, interest, balance, payment frequency, and optional recurring extras.

$
%
years
years
$

How the calculation works

Understand the formula before relying on the result

Canadian rate conversion

The nominal annual rate is converted from semi-annual compounding to an equivalent rate for the selected payment frequency.

Level payment

The scheduled payment is calculated over the entered amortization, with accelerated weekly and biweekly payments based on the monthly payment convention.

Sequential allocation

For every period, interest is calculated on opening balance, scheduled principal is applied, then any recurring extra reduces principal.

Annual summaries

Payment-level records are grouped by payment year to show opening balance, total payments, principal, interest, and closing balance.

Interpret the result

Early payments are interest-heavy

At the beginning of a long amortization, a larger share of each level payment typically services interest.

The balance at term drives renewal

The remaining principal—not the original mortgage amount—becomes the starting point for the next mortgage term.

Frequency changes annual payment

Accelerated frequencies increase the amount paid annually and can shorten amortization compared with ordinary frequency conversions.

A schedule is an estimate

Exact lender schedules can differ because of dates, rounding, payment history, interest adjustment, fees, and product conventions.

Common mistakes

  • Confusing mortgage term with amortization.
  • Assuming the current rate lasts until payoff.
  • Comparing accelerated and ordinary frequencies only by payment size.
  • Ignoring the balance at renewal.
  • Using a generic schedule instead of the lender statement for legal payout.

What lenders review

  • Nominal rate and compounding convention.
  • Payment frequency and acceleration method.
  • Term, amortization, and remaining amortization.
  • Prepayment privileges and how extras are applied.
  • Rounding, payment dates, skipped payments, and product-specific adjustments.

Planning tips

  • Export the schedule and review each renewal-year balance.
  • Test an adverse renewal rate separately.
  • Use annual summaries for budgeting and net-worth planning.
  • Add recurring extras only when contract privileges allow.
  • Compare the schedule with the lender statement after funding.

Connected HopeWell knowledge

Connect the amortization schedule generator to the mortgage decision

Use the result alongside HopeWell's guide chapters, glossary definitions, real underwriting case studies, service pages, and related calculators.

Calculation pathway

Continue into qualification, purchase costs, equity, refinancing, HELOC planning, and mortgage comparison using the connected calculators below.

View calculator platform

Frequently asked questions

Questions about this calculation

What is an amortization schedule?

It is a table showing how each mortgage payment is divided between interest and principal and how the balance changes over time.

What is the difference between term and amortization?

The term is the contract period before renewal or maturity. Amortization is the longer planned period to repay the mortgage in full.

Why does the interest portion change?

Interest is calculated on the remaining balance, so it generally declines as principal is repaid when the rate is constant.

Why might my lender schedule differ?

Exact dates, rounding, compounding, first-payment timing, payment changes, fees, and lender systems can create differences.

Can I export the schedule?

Yes. The calculator exports the full payment-level schedule as either a branded PDF report or a CSV data file while displaying annual summaries and one selected year at a time.