Mortgage portability and rate blend · Calculation guide

Compare the rate and payment when a portable mortgage is topped up.

Calculation guide

End-of-month payments and a fixed nominal annual rate divided by twelve. No fees or early settlement charges.

Blended rate = (old × old rate + extra × new rate)/(old + extra); payment = sum of each tranche’s payment at its own rate and remaining term.

Inputs

Existing principal

Example entry 150000 (in the selected currency). Minimum 0.01.

Existing annual rate

Example entry 3 %. Allowed range 0 to 100.

Remaining months on ported loan

Example entry 180. Allowed range 1 to 600. Use whole numbers.

Additional borrowing

Example entry 50000 (in the selected currency).

New annual rate

Example entry 6 %. Allowed range 0 to 100.

Months on top-up

Example entry 240. Allowed range 1 to 600. Use whole numbers.

Worked example

InputValue
Existing principal150,000
Existing annual rate3%
Remaining months on ported loan180
Additional borrowing50,000
New annual rate6%
Months on top-up240
ResultValue
Principal-weighted rate3.75%
Combined monthly payment1,394.08799
Combined principal200,000

Calculation steps

Principal-weighted rate = (((Existing principal × Existing annual rate) + (Additional borrowing × New annual rate)) ÷ (Existing principal + Additional borrowing))

(((150,000 × 3) + (50,000 × 6)) ÷ (150,000 + 50,000)) = 3.75%

Combined monthly payment = (payment(Existing principal, Existing annual rate, Remaining months on ported loan) + payment(Additional borrowing, New annual rate, Months on top-up))

(payment(150,000, 3, 180) + payment(50,000, 6, 240)) = 1,394.08799

Combined principal = (Existing principal + Additional borrowing)

(150,000 + 50,000) = 200,000

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Existing principal150,000165,000Principal-weighted rate3.75%3.697674%
Existing annual rate3%4%Principal-weighted rate3.75%4.5%
Remaining months on ported loan180198Combined monthly payment1,394.087991,319.624738
Additional borrowing50,00055,000Principal-weighted rate3.75%3.804878%
New annual rate6%7%Principal-weighted rate3.75%4%
Months on top-up240264Combined monthly payment1,394.087991,377.409685
Mortgage portability and rate blend →

Sources