A spread quote is incomplete until the benchmark convention, observation date and floor position are known. Reproduce the clause before forecasting payments.
A floating-rate coupon is the output of a contractual calculation. Reading “SOFR plus 300 basis points” does not establish the amount due if the documents also contain a floor, an adjustment, a different observation date or a fallback. Convert the operative provisions into a short formula with defined inputs before comparing quotes or approving the first debt-service payment.
The decision is whether the loan’s response to changing rates matches the investment plan. A borrower expecting relief from lower benchmarks may receive none until a floor stops binding. Conversely, two loans that cost the same today can diverge sharply after a reset. Neither result requires the lender to change the quoted spread.
Identify the benchmark before using a number
The New York Fed’s reference-rate methodology distinguishes daily SOFR, compounded averages and the SOFR Index. These are not interchangeable inputs. A loan using another specified SOFR convention needs that exact source and observation procedure; today’s overnight release is not automatically the correct reset.
Make a rate record with six fields: benchmark name, administrator or publication, observation date, applicable interest period, stated adjustment and spread. Add the fallback provision and amendment reference. If the rate is missing on a publication date, follow the documented rule rather than inventing an interpolation. Save the retrieved value and its timestamp so another person can reproduce the billing calculation later.
Express percentages consistently. A 275-basis-point spread is 2.75 percentage points. It is not 2.75% of the benchmark. If an index is 4%, adding that spread produces 6.75% before any other adjustment or floor. Store the unrounded number as well as the displayed percentage when the contract specifies rounding.
Worked exhibit: the position of the floor changes the result
The following are invented term formulations, not quotations from a lender. Assume a constant $4 million interest-only principal balance. The index values are hypothetical and are not current rates. Ignore fees, compounding, hedges and calendar differences in this annualized comparison.
- Clause A: coupon equals the greater of the index and 3%, plus a 2.75% spread.
- Clause B: coupon equals the greater of index plus 2.75%, and a 5% all-in minimum.
- Clause C: coupon equals the greater of index plus a 0.10% adjustment and 3%, plus 2.75%.
| Hypothetical index | A: index floor | B: all-in floor | C: adjusted index floor |
|---|---|---|---|
| 2.00% | 5.75% | 5.00% | 5.75% |
| 3.00% | 5.75% | 5.75% | 5.85% |
| 4.00% | 6.75% | 6.75% | 6.85% |
At the 2% index, Clause A costs $230,000 annually and Clause B costs $200,000: a $30,000 difference despite the same spread. At a 4% index they converge. Clause C’s adjustment sits inside the floor calculation; moving it outside the maximum would change the low-rate result. The punctuation and defined terms therefore have economic consequences.
The crossover also matters for forecasts. Clause A begins responding to an index increase above 3%. Clause B begins responding above 2.25%, because 2.25% plus 2.75% equals its 5% minimum. A model that floors all three structures at the same benchmark level produces an incorrect sensitivity grid.
Turn the formula into a billing control
Assume Clause A applies to a 31-day period on an actual/360 basis and the applicable index is 2%. Interest is $4,000,000 × 5.75% × 31 ÷ 360 = $19,805.56, rounded once at the end. Dividing annual interest by twelve instead produces $19,166.67. The $638.89 difference is a calendar convention difference, not evidence that the spread changed.
Before disputing an invoice, reconcile the balance as well. A funded reserve, additional advance or prior principal curtailment can alter interest independently of the rate. Use the balance effective on each day if the documents require it. Keep unpaid fees and escrow deposits outside the coupon calculation unless the agreement explicitly makes them interest-bearing obligations.
A useful reconciliation has separate columns for contractual rate, daily balance, accrual days, calculated interest, billed interest and unexplained difference. Assign each exception a reason rather than forcing the calculation to the invoice. Small differences may reflect permitted rounding; a persistent difference may reveal a wrong reset date or floor location.
Read the fallback and hedge beside the rate clause
A benchmark replacement can change the applicable index and adjustment. Identify who determines a replacement, whether notice is required and what changes can follow without a new negotiated amendment. This is a document-review question for counsel, not a reason to assume the original spreadsheet formula remains valid forever.
A separate purchased cap is another contract. Its receipts may reduce net cash cost without reducing the lender’s gross coupon. Confirm index, notional, strike, dates and receipt timing before subtracting a cap benefit. Do not insert the cap strike into the loan’s floor formula unless the loan itself has a contractual rate ceiling.
For a decision-ready comparison, retain the three-rate exhibit, the exact clause references and one reproduced invoice period. Ask the lender to resolve any remaining ambiguity in writing before execution. The resulting record explains both the current coupon and the specific conditions under which it changes; a headline spread alone cannot do that.
Sources and evidence
- New York Fed — reference-rate methodologySOFR Averages and Index methodology · Checked 2026-10-21 · Source-specific context; numerical examples and decision workflow are original hypothetical analysis.
Source dates and applicability matter. Report an error or a changed source.