Mortgage calculator

Mortgage payments using the semi-annual compounding convention required in Canada.

$
%

As quoted — compounded semi-annually.

25 years

Monthly repayment

$3,133.40

41% of everything you repay is interest

Total interest
$390,018
Total repaid
$940,018
Paid off in
25 years
Balance owing: $550,000Balance owing: $538,231Balance owing: $525,892Balance owing: $512,955Balance owing: $499,391Balance owing: $485,169Balance owing: $470,258Balance owing: $454,624Balance owing: $438,232Balance owing: $421,046Balance owing: $403,027Balance owing: $384,134Balance owing: $364,325Balance owing: $343,556Balance owing: $321,781Balance owing: $298,949Balance owing: $275,012Balance owing: $249,913Balance owing: $223,598Balance owing: $196,008Balance owing: $167,080Balance owing: $136,750Balance owing: $104,950Balance owing: $71,608Balance owing: $36,650
Principal and interest by year
Breakdown of Monthly repayment
Amount borrowed$550,000
Interest$390,018
Total repaid$940,018

A 4.79% rate compounded semi-annually gives a monthly periodic rate of about 0.3946%, not the 0.3992% that dividing by 12 produces.

Export your real numbers to Sheetsmortgage

Over the life of it

How this is calculated

Compounding frequency changes the payment

Canadian fixed-rate mortgages compound semi-annually by statute, so the monthly rate is the sixth root of the half-yearly rate. At 4.79% that is 0.3946% rather than 0.3992%.

monthly rate = (1 + annual ÷ 2)^(1/6) − 1

Small rate differences compound

The gap between 0.3946% and 0.3992% a month looks negligible but runs for 300 payments. On $550,000 over 25 years it is worth several thousand dollars.

A fixed term is not the full loan

In Canada the rate is typically fixed for 5 years while the loan amortises over 25, so the rate resets four times before the mortgage clears.

Worked example: $550,000 at 4.79% over 25 years
Inputs
Mortgage$550,000
Rate4.79%
Result
Monthly periodic rate0.3946%
Payments300

Compounding conventions differ by country. Pick a country above for the one your lender is required to use.

What this assumes
  • A fixed rate for the full period.
  • Semi-annual compounding.
  • No insurance premium added to the balance.
  • No property tax or fees included.
Where this commonly goes wrong
  • Where a rate is fixed for a shorter term than the amortisation, the payment shown applies only until renewal.
  • Default insurance on a low deposit is usually added to the balance, so interest is charged on the premium too.
  • Breaking a fixed-rate mortgage early commonly triggers a penalty based on the rate movement, not a flat fee.

Questions

What is semi-annual compounding?

Interest compounded twice a year rather than monthly. Canadian law requires it on fixed-rate mortgages, making the monthly rate the sixth root of the half-yearly rate — 0.3946% from a 4.79% quote.

Does the compounding convention change my payment?

Yes, slightly per payment and materially over the loan. On $550,000 over 25 years the difference between the correct rate and a naive divide-by-12 is worth several thousand dollars of interest.

Is the rate fixed for the whole mortgage?

In Canada, usually not. A 5-year term inside a 25-year amortisation means four renewals at unknown future rates, which is a different risk profile from a fully fixed long-term loan.

How do bi-weekly payments shorten a mortgage?

Accelerated bi-weekly means half the monthly payment every two weeks, which is 26 payments a year rather than 24 — one extra monthly payment annually. On a 25-year amortisation that typically removes around three years and tens of thousands of interest.

What happens if I need to break the mortgage early?

A fixed-rate mortgage broken before the term ends usually triggers the greater of three months of interest and an interest rate differential. On a large balance with a big rate movement that penalty can run into tens of thousands of dollars.

Related tools

Sources

This calculator does arithmetic on the figures you enter. It does not account for tax, fees, or your personal circumstances.

T0