How do you compare floating rate loan floors?

The quick read: Compare floating rate floors by identifying whether the minimum applies to the benchmark or the total coupon, then calculate each offer under identical benchmark scenarios. A smaller spread can still produce a higher payment when its floor binds. Read the signed formula, not just the rate shown on the quote.

For an investor deciding between property loan offers, the relevant question is what the property must pay when the benchmark moves. A quote that looks inexpensive at closing may stop getting cheaper before another offer does. That difference affects operating cash, distributions and the cash available for an eventual refinance.

The comparison below is a worksheet method, not a forecast of rates or an offer of credit. All numerical examples are invented assumptions for arithmetic. Replace every input with the lender's written language and ask the lender to confirm the calculation before treating the result as a financing decision.

What is the difference between an index floor and a coupon floor?

An index floor sets the minimum benchmark used before adding the spread, while a coupon floor sets the minimum total contractual interest rate after calculation. These formulas can look alike when benchmarks are high but produce different payments as benchmarks fall. The lender's definitions determine which formula applies.

Write the two formulas separately. An index-floor structure can be represented as the greater of actual index or index floor, plus spread. A coupon-floor structure can be represented as the greater of index plus spread or total-rate floor. Do not insert a floor into both places unless the documents actually impose both tests.

Fannie Mae's current SARM term sheet describes a product-specific minimum interest rate equal to the margin. That is one documented structure, not a rule that applies to all commercial lenders.

A floor is also different from an underwriting rate. A lender may size the loan using a stressed payment while the borrower pays a different contractual coupon. Ask for the payment formula and the sizing formula on separate lines. Confusing them can make a loan appear to have more falling-rate benefit than its note permits.

How should you organize the lender comparison worksheet?

Organize a floor comparison around the exact benchmark definition, margin, floor location, reset mechanics and funded balance so every offer uses matching assumptions. The starting coupon belongs in the worksheet, but it cannot substitute for those inputs. Record the document section beside each input and identify unresolved language explicitly.

Use a single dated benchmark assumption across both offers. If one quote references a different SOFR measure, do not call the inputs equivalent simply because both labels contain SOFR. A forward-looking term measure and a backward-looking average can move differently within a month. Ask each lender to identify its published series and fixing convention.

Comparison table: floor clauses to reconcile before selecting an offer.

An unsigned term sheet may omit details that appear in the note. Keep the comparison provisional until those gaps close. Save the lender's written answer with the offer version so a later change is visible rather than lost in an email thread.

What does a falling benchmark example reveal?

A falling benchmark example reveals where each loan stops passing lower benchmark values through to the investor's payment and whether the cheaper initial offer remains cheaper. Use equal balances and equal accrual assumptions so the floor is the only changing term. Treat the result as a sensitivity test, not a predicted outcome.

Illustrative example: an investor compares two hypothetical interest-only loans on a $2,400,000 funded balance. Offer A has a 2.40% spread and a 3.00% index floor. Offer B has a 2.70% spread and a 4.80% total coupon floor. For simplicity, this example uses annual interest divided by twelve rather than actual-day accrual.

At a 4.00% benchmark, A costs 6.40%, or $12,800 per month; B costs 6.70%, or $13,400. At a 2.00% benchmark, A costs 5.40%, or $10,800; B reaches its 4.80% minimum, or $9,600. The lower spread begins cheaper but becomes more expensive after the index falls sufficiently.

The point is not that B is preferable. If the investor exits before a floor binds, A's initial saving may matter more. If the property is held longer, the minimum payment deserves greater weight. Add both cases to the business plan, then compare exit costs, reserves and recourse separately.

How do reset dates change the floor comparison?

Reset dates change the floor comparison because a loan applies its formula to a contractually selected benchmark observation rather than to the number an investor sees today. A floor may already bind in one period and remain irrelevant in another. Confirm the fixing date, applicable period and business-day rule before reproducing a payment.

A publicly filed credit agreement's interest provisions calculate Term SOFR interest for an applicable interest period and specify an actual-day accrual basis. It illustrates why the definition and period must accompany the quoted margin; it is not a commercial mortgage offer to the reader.

Request a sample statement showing the benchmark observation, any adjustment, the floor test, the margin and the daily accrual calculation. Ask whether a payment due at the beginning of a month covers interest earned during the previous month. A cash flow model using the current index for all dates can produce a false discrepancy with an accurate servicer statement.

Keep benchmark timing separate from floor economics. First calculate the coupon using the document's observation. Then calculate interest using the document's day count. Finally place the payment in the month it is due. That sequence prevents a floor discussion from masking a timing or accrual error.

What should you test beyond the lowest possible payment?

Test the floor alongside higher benchmark payments, property cash flow and exit debt because a lower minimum coupon does not establish that the entire loan is affordable. Investors should evaluate both adverse-rate resilience and falling-rate benefit. A cap, amortization requirement or reserve obligation can change the amount of cash actually available.

The OCC commercial real estate lending handbook treats repayment capacity, collateral and loan structure as underwriting considerations. Its supervisory scope concerns banks; it does not set a universal acceptable floor for an investor's deal.

Use the underwriting calculator to compare consistent income and debt assumptions, then preserve the lender's own method alongside your analysis. Do not label an investor calculation as lender-approved. If amortization begins during the hold, add the changed principal payment rather than continuing the interest-only formula throughout.

Also check whether an interest rate hedge covers the same benchmark and notional balance. A hedge can limit some rising-rate exposure while the note floor still restricts falling-rate benefit. Avoid combining the cap strike and margin into a guaranteed maximum payment without examining the hedge settlement and loan terms.

What should your deal team confirm before you accept the floor?

Your deal team should confirm the binding floor formula, the affected benchmark series and each circumstance that can change the coupon before you accept a floating rate offer. Ask for written explanations of inconsistent terms and review them with counsel. A verbal assurance that the rate will float down is insufficient documentation.

Practical deal checklist:

• Obtain the proposed note's index, margin and floor definitions.
• Mark whether the floor applies to the index, adjusted index or total coupon.
• Reconcile the quoted starting coupon with the fixing date used by the lender.
• Identify any extension-period margin or floor changes.
• Separate ordinary interest from default interest and late charges.
• Run declining, flat and rising benchmark cases on the same funded balance.
• Check amortization, hedge and reserve effects on cash available to the property.
• Record every lender clarification with a date and document version.

Floor location: contractual formula, not the marketing label.

Scenario status: illustrative assumptions, not market pricing or a rate forecast.

Decision output: a payment sensitivity schedule with unresolved clauses flagged.

For the broad side-by-side offer process, use the existing commercial loan comparison guide. This worksheet adds the narrower floor test to that framework rather than replacing the rest of it.

How do you get a floor comparison reviewed for your financing request?

Submit the actual property facts, requested proceeds and unresolved documentation questions for brokerage review so the financing discussion addresses your supported investment decision. YieldStack is a commercial mortgage brokerage. Identify the decision that needs written lender clarification before selecting terms.

Every credit decision is made by the lender; YieldStack arranges the introductions and negotiates on the borrower's side, and no loan, rate, or closing is guaranteed.

For a useful review, provide the actual offer versions rather than only screenshots of rates. Include the acquisition or refinance purpose, current debt, desired closing date and the cash the property must retain after closing. Explain which assumption matters most: payment resilience, lower falling-rate cost, flexible exit or available proceeds.

Submit the property and floor clauses for financing review.

The bottom line

The meaningful floor comparison is a formula comparison. Determine where the minimum applies, use the correct benchmark observation and calculate matching scenarios before selecting the offer. A smaller margin may win at closing and lose later. The right choice depends on the property's cash needs and hold period, together with the remaining loan terms. Have the written structure reviewed before treating a favorable sensitivity result as an executable financing plan.