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.
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
| Input | Value |
|---|---|
| Average outstanding principal | 200,000 |
| Fixed annual rate | 5% |
| Months remaining | 24 |
| Fixed-option fees in period | 1,000 |
| Floating-option fees in period | 500 |
| Result | Value |
|---|---|
| Break-even average floating rate | 5.125% |
| Fixed-option interest and fees | 21,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.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Average outstanding principal | 200,000 | 220,000 | Break-even average floating rate | 5.125% | 5.113636% |
| Fixed annual rate | 5% | 6% | Break-even average floating rate | 5.125% | 6.125% |
| Months remaining | 24 | 26 | Break-even average floating rate | 5.125% | 5.115385% |
| Fixed-option fees in period | 1,000 | 1,100 | Break-even average floating rate | 5.125% | 5.15% |
| Floating-option fees in period | 500 | 550 | Break-even average floating rate | 5.125% | 5.1125% |
