Fixed versus floating mortgage break-even rate · Calculation guide

Find the average floating rate that matches fixed interest and fees during the comparison period.

Calculation guide

Interest-only or constant average principal approximation; enter the expected average balance. No discounting. A negative crossover means even a zero floating rate costs more.

Floating break-even = fixed rate + (fixed fees − floating fees) × 1200 /(average balance × months).

Inputs

Average outstanding principal

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

Fixed annual rate

Example entry 5 %. Allowed range 0 to 100.

Months remaining

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

Fixed-option fees in period

Example entry 1000 (in the selected currency).

Floating-option fees in period

Example entry 500 (in the selected currency).

Worked example

InputValue
Average outstanding principal200,000
Fixed annual rate5%
Months remaining24
Fixed-option fees in period1,000
Floating-option fees in period500
ResultValue
Break-even average floating rate5.125%
Fixed-option interest and fees21,000

Calculation steps

Break-even average floating rate = (Fixed annual rate + (((Fixed-option fees in period − Floating-option fees in period) × 1,200) ÷ (Average outstanding principal × Months remaining)))

(5 + (((1,000 − 500) × 1,200) ÷ (200,000 × 24))) = 5.125%

Fixed-option interest and fees = ((((Average outstanding principal × Fixed annual rate) ÷ 1,200) × Months remaining) + Fixed-option fees in period)

((((200,000 × 5) ÷ 1,200) × 24) + 1,000) = 21,000

How each input affects this example

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

InputOriginal inputNew inputAffected resultOriginal resultNew result
Average outstanding principal200,000220,000Break-even average floating rate5.125%5.113636%
Fixed annual rate5%6%Break-even average floating rate5.125%6.125%
Months remaining2426Break-even average floating rate5.125%5.115385%
Fixed-option fees in period1,0001,100Break-even average floating rate5.125%5.15%
Floating-option fees in period500550Break-even average floating rate5.125%5.1125%
Fixed versus floating mortgage break-even rate →

Sources