Advertisement

Mortgage comparison calculator

Compare two mortgage offers for the same borrowing need, including different rates, amortizations and extra payments.

Calculator

Offer A planned payment
$2,326.42
Offer B planned payment
$2,574.78
Offer B minus A payment
$248.36
Offer A interest
$297,925.98
Offer B interest
$217,948.02
Offer A payments and fees
$697,925.98
Offer B payments and fees
$620,948.02
Lifetime saving with B
$76,977.96
Offer A payoff years
25.0000
Offer B payoff years
20.0000
Offer A payoff date
2051-10-01
Offer B payoff date
2046-10-01
Annual mortgage balance comparison
Payment yearA closing balance ($)B closing balance ($)A paid that year ($)B paid that year ($)
1.00391,690.97387,653.3427,917.0430,897.40
2.00382,961.30374,713.2627,917.0430,897.40
3.00373,789.69361,151.2127,917.0430,897.40
4.00364,153.77346,937.3327,917.0430,897.40
5.00354,030.03332,040.2627,917.0430,897.40
6.00343,393.77316,427.1827,917.0430,897.40
7.00332,219.06300,063.6827,917.0430,897.40
8.00320,478.62282,913.6827,917.0430,897.40
9.00308,143.82264,939.3827,917.0430,897.40
10.00295,184.58246,101.1627,917.0430,897.40
11.00281,569.27226,357.5027,917.0430,897.40
12.00267,264.69205,664.8727,917.0430,897.40
13.00252,235.94183,977.6827,917.0430,897.40
14.00236,446.36161,248.1127,917.0430,897.40
15.00219,857.43137,426.0727,917.0430,897.40
16.00202,428.68112,459.0527,917.0430,897.40
17.00184,117.6186,292.0027,917.0430,897.40
18.00164,879.5458,867.2627,917.0430,897.40
19.00144,667.5430,124.3827,917.0430,897.40
20.00123,432.310.0027,917.0430,897.40
21.00101,122.040.0027,917.040.00
22.0077,682.320.0027,917.040.00
23.0053,055.960.0027,917.040.00
24.0027,182.890.0027,917.040.00
25.000.000.0027,917.040.00

Advertisement

How this calculator works

Both offers start with the same borrowed principal. Each can have a different nominal rate, compounding convention, amortization, upfront fees and extra payment. Compare the payment alongside total cost: a lower payment can come from a longer amortization and produce more interest. Fees are paid in cash and are not added to the balance. The annual table uses payment years, and all rates are held constant through repayment.

Formula

For each offer, i = (1 + r/c)^(c/f) - 1 and regular payment = P × i / (1 - (1 + i)^(-Nf/12)). Total offer cost = actual payments + upfront fees. Lifetime saving with B = A total cost - B total cost. Payment difference = B planned periodic payment - A planned periodic payment.

Worked example

At 0%, a $1,200 mortgage over 120 months costs $10 monthly, while a 60-month offer costs $20 monthly. With no fees they repay the same $1,200. If B charges a $100 upfront fee, its lifetime cost is $1,300 and its saving relative to A is negative $100.

Advertisement

Frequently asked questions

Does the cheaper lifetime offer always suit me?

No. Monthly cash flow, your expected holding period, renewal risk and prepayment flexibility also matter.

Can I compare a Canadian and US convention?

Yes. Each offer has its own compounding selector. The tool does not convert currencies, so use one currency consistently.

Are early-sale balances considered?

The annual table shows remaining balances. The lifetime saving figure assumes each loan is held until fully repaid and does not discount cash flows.

Sources

Advertisement