Fixed vs Floating Rate Calculator
Should you fix or float? Enter both offers and see, for every year rates could rise, how high the floating rate can go before fixed would have been cheaper.
Fixed wins by $15,000. For a rise at the start of year 3, floating stays cheaper as long as the new rate is below 7.50%.
How High Can Rates Go Before Fixed Wins?
For each year, the floating rate at which both options cost the same if rates jump that year and stay there. Your scenario is the dot: above the line, fixed wins; below it, floating wins.
| Rates jump in | Break-even | Over today |
|---|---|---|
| Year 1 | 7.00% | +0.75% |
| Year 2 | 7.19% | +0.94% |
| Year 3 | 7.50% | +1.25% |
| Year 4 | 8.13% | +1.88% |
| Year 5 | 10.00% | +3.75% |
How it is calculated
Cost = Interest paid until exit + Prepayment penalty
Each option is charged the interest it would accrue, month by month, from closing until you sell, refinance or repay, plus any prepayment penalty owed at that point. Fixed loans usually carry one; floating loans are usually prepayable at par. The floating rate is held at today’s rate until the year you choose, then at the new rate until exit. The break-even for a year is the new rate at which the two costs are exactly equal.
- Floating rate
- The all-in rate today: the index, usually SOFR, plus the lender’s spread.
- Hold
- The years until the loan is repaid, which is usually a sale or refinance rather than maturity.
- Prepayment penalty
- What the fixed loan charges to repay early, as a percentage of the balance then: yield maintenance, defeasance or a step-down such as 5-4-3-2-1.
- Break-even
- For a rise in a given year, the floating rate at which both options cost the same over the hold.
A worked deal example
A $1,000,000 loan interest-only, held 5 years: fixed at 7.00% or floating at 6.25% today and rising 1.75% to 8.00% at the start of year 3.
- Fixed cost
- $350,000
- Floating cost
- $365,000
- Break-even, year 3
- 7.50%
- Hold
- 5 years
Over the hold the fixed loan costs $350,000 in interest and the floating loan $365,000. Fixed comes out ahead by $15,000. For a jump at the start of year 3, floating stays cheaper as long as the new rate is below 7.50%, which is the break-even for that year. The later rates rise, the longer floating banks its lower rate, so the break-even climbs year by year.
Frequently asked questions
Is a floating rate better than a fixed rate?
Should I fix or float a commercial loan?
How does a prepayment penalty change the answer?
What is a break-even interest rate?
Reading the break-even line
The line starts at the fixed rate: if rates jump on day one, floating only wins while it stays below fixed. Every year rates hold off, floating banks the gap between the two, so the rate it can later absorb climbs. On the default offers the gap is 0.75% a year, and a jump in year 5 can reach 10.00% before fixed comes out ahead.
Read it against your own view of rates rather than as a forecast. If the dot for the rise you think plausible sits well below the line, floating has room to be wrong. If it sits near the line, the choice is close and the certainty of fixed may be worth more than the savings.
What this comparison leaves out
Fees that differ between the two offers, such as origination or exit fees, are not included; add them to your view of each option. Interest is accrued monthly at one-twelfth of the annual rate on both loans; a lender charging Actual/360 collects slightly more on each, which barely moves the comparison. Rates are tested as one step up or down and held there, which is the clearest way to read a break-even. Floating-rate lenders often require a rate cap, which limits how high the rate can go for an upfront fee and changes the floating side of the comparison. For the payment and balloon on either loan, use the Commercial Mortgage & Balloon Calculator; to check coverage at a given rate, the DSCR Solver.
Related calculators
Estimates only. This calculator is an educational tool, not financial advice, a loan offer, or a commitment to lend. Actual payments, loan sizing and closing costs depend on your lender's underwriting, the day-count convention in your loan documents, and fees not modeled here. Confirm any figure with your lender or advisor before acting on it. For an official reference, see Commercial Real Estate Lending (Comptroller’s Handbook, Office of the Comptroller of the Currency).