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.

Your Two Offers
Loan Structure
Loan Structure
Test a Scenario
Until you sell, refinance or repay. Most loans are repaid well before maturity. 5 years
+1.750% to 8.00%
Year 3

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%.

Fixed Saves
$15,000
Over 5 years
Fixed Cost
$350,000
Interest
Floating Cost
$365,000
Interest
Break-Even, Year 3 If the floating rate jumps in this year and stays there, below this rate floating still costs less.
7.50%
+1.25% over today
Floating Payment After Rise
$6,667
From $5,208 a month
Max Floating Rate at 1.25x The highest floating rate at which the property’s NOI still covers the payment 1.25 times.
—
Enter NOI

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.

Break-even floating rate by the year rates rise
Rates jump inBreak-evenOver today
Year 17.00%+0.75%
Year 27.19%+0.94%
Year 37.50%+1.25%
Year 48.13%+1.88%
Year 510.00%+3.75%
Fixed at 7.00%; floating at 6.25% today.

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.

Key Deal Takeaway Fixed wins by $15,000

Frequently asked questions

Is a floating rate better than a fixed rate?
It depends on how far rates rise and how soon. A floating rate usually starts lower, so it banks savings for as long as rates stay put, and the later rates rise the more room it has. On a $1,000,000 interest-only loan at 7.00% fixed or 6.25% floating, held 5 years, floating stays cheaper if rates jump right away but stay below 7.00%, or jump in year 3 and stay below 7.50%. The break-even line on this page shows that limit for every year.
Should I fix or float a commercial loan?
Fix when the deal cannot absorb a higher payment, when you plan to hold the loan most of its term, or when the fixed rate is close to the floating rate. Float when you expect to sell or refinance within a few years, when the fixed loan carries a heavy prepayment penalty, or when the gap between the two is wide. Floating-rate lenders often require a rate cap, which limits how high your rate can go for a fee paid upfront.
How does a prepayment penalty change the answer?
It moves every break-even point up, because floating loans are usually prepayable at par and the fixed loan is not. On the example above, a 2% penalty on the fixed loan at exit costs $20,000 and raises the year-1 break-even from 7.00% to 7.40%. If you are likely to sell or refinance before the fixed loan’s penalty runs off, enter it.
What is a break-even interest rate?
The floating rate at which floating and fixed would cost the same over your hold. Below it, floating saves money; above it, fixed would have been cheaper. It depends on when rates rise: a jump in year 1 only has to stay below the fixed rate, while a jump late in the hold can go much higher, because floating has been saving money in the years before it.

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.

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).