Mortgage rate-lock extension break-even · Calculation guide

Compare a rate-lock extension fee with the monthly payment advantage over the alternative quote.

Calculation guide

Same principal and remaining term. Simple monthly payment recovery excludes differences in principal repaid and time value. No break-even when the extended quote is not cheaper.

Break-even months = extension fee / [PMT(alternative rate) − PMT(locked rate)].

Inputs

Principal outstanding

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

Locked annual rate

Example entry 5 %. Allowed range 0 to 100.

Alternative annual rate

Example entry 5.5 %. Allowed range 0 to 100.

Months remaining

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

Contract fee

Example entry 600 (in the selected currency).

Worked example

InputValue
Principal outstanding200,000
Locked annual rate5%
Alternative annual rate5.5%
Months remaining240
Contract fee600
ResultValue
Payment-savings recovery period10.740535 months
Monthly payment reduction55.863137

Calculation steps

Payment-savings recovery period = (Contract fee ÷ (payment(Principal outstanding, Alternative annual rate, Months remaining) − payment(Principal outstanding, Locked annual rate, Months remaining)))

(600 ÷ (payment(200,000, 5.5, 240) − payment(200,000, 5, 240))) = 10.740535 months

Monthly payment reduction = (payment(Principal outstanding, Alternative annual rate, Months remaining) − payment(Principal outstanding, Locked annual rate, Months remaining))

(payment(200,000, 5.5, 240) − payment(200,000, 5, 240)) = 55.863137

How each input affects this example

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

InputOriginal inputNew inputAffected resultOriginal resultNew result
Principal outstanding200,000220,000Payment-savings recovery period10.740535 months9.764123 months
Locked annual rate5%4%Payment-savings recovery period10.740535 months3.662692 months
Alternative annual rate5.5%6.5%Payment-savings recovery period10.740535 months3.503961 months
Months remaining240264Payment-savings recovery period10.740535 months10.501129 months
Contract fee600660Payment-savings recovery period10.740535 months11.814589 months
Mortgage rate-lock extension break-even →

Sources