Blog · Finance metrics and formulas · Finance and FP&A teams
Separate a supplied corporate borrowing rate into its reference rate and contractual spread. Work through a debt schedule, calculate weighted borrowing cost and compare the interest effect of clearly stated rate scenarios.
Cost of debt risk premium commonly means the extra borrowing cost above a suitable reference rate. For a corporate finance team, the practical task is to separate the supplied benchmark, contractual spread, balances and fees, then calculate what each contributes to interest. A change in the total borrowing rate does not, by itself, prove that the company's credit risk changed.
For a straightforward floating-rate facility without a binding floor or other adjustment:
Borrowing rate = Applicable reference rate + Contractual spread
Contractual spread = Borrowing rate - Applicable reference rate
Annualized interest = Outstanding principal × Borrowing rate
The reference rate needs a name, observation date and calculation convention. The New York Fed describes SOFR as a broad measure of overnight borrowing costs secured by Treasury securities. An agreement referencing a term rate or a compounded average does not necessarily use that day's published overnight SOFR.
Use the rate specified in the supplied agreement or approved debt schedule. Keep any benchmark adjustment, floor and contractual spread in separate columns where they apply. Subtracting a convenient market rate from a loan rate produces a difference, but it may not reproduce the agreement's spread.
There is also a terminology limit. New York Fed research on corporate bond yields distinguishes the maturity-matched risk-free rate, expected default losses and a risk premium; the latter two together constitute the credit spread in that analysis. A contractual loan margin is a supplied pricing term, so this article reports it as a spread rather than claiming to isolate a pure economic risk premium.
Use one row per facility, currency and relevant rate period. Include the drawn principal, fixed or floating status, applicable reference rate, spread, reset dates, maturity and fees. Identify whether principal is a closing balance, an average balance or an assumed constant scenario balance.
Compare like with like. A secured floating-rate revolver and a fixed-rate term loan can both contribute to the company's interest budget, but their quoted rates do not isolate differences in credit quality. Their terms and exposures differ.
Treasury owns the approved terms and rate inputs. The controller owns reconciliation to recorded interest, and FP&A owns the comparison with the supplied operating and cash plan. The separate cost of equity measure answers a different capital-cost question; it does not replace the borrowing schedule.
An illustrative US distributor supplies the following annualized scenario. All facilities are in USD, principal stays constant for a full year, floating rates do not reset during the illustration, and there are no fees, floors, hedges or capitalized interest. The rates are assumptions for the example, not current market observations.
| Facility | Principal (USD) | Applicable reference rate | Contractual spread | Borrowing rate | Annualized interest (USD) |
|---|---|---|---|---|---|
| Floating revolver A | 3,000,000 | 4.00% | 2.00% | 6.00% | 180,000 |
| Floating term loan B | 2,000,000 | 4.00% | 3.00% | 7.00% | 140,000 |
| Fixed term loan C | 1,000,000 | Not applicable | Not separated | 6.50% | 65,000 |
| Total | 6,000,000 | 385,000 |
For revolver A, 4.00% + 2.00% = 6.00%, and 3,000,000 × 6.00% = $180,000. For term loan B, 2,000,000 × 7.00% = $140,000. Fixed loan C contributes 1,000,000 × 6.50% = $65,000.
If principal is column B and borrowing rate is column E, the interest formula in F2 is =B2*E2, copied down. The weighted borrowing rate is:
=SUM(F2:F4)/SUM(B2:B4)
That gives 385,000 / 6,000,000 = 6.42%, rounded to two decimal places. Calculate from unrounded rates and round only the displayed result. A simple average of facility rates gives equal weight to unequal balances, so it is not the schedule's weighted cost.
This is a before-tax annualized stated-interest measure. It is not an accounting effective interest rate, an offer from a lender or a forecast of what rates will be.
The floating facilities have $5,000,000 of combined principal. Their reference-rate contribution is 5,000,000 × 4.00% = $200,000. Their spread contribution is:
| Interest component | Calculation | Annualized amount (USD) |
|---|---|---|
| Floating reference rate | 5,000,000 × 4.00% | 200,000 |
| Revolver A spread | 3,000,000 × 2.00% | 60,000 |
| Term loan B spread | 2,000,000 × 3.00% | 60,000 |
| Fixed loan C | 1,000,000 × 6.50% | 65,000 |
| Total | 200,000 + 60,000 + 60,000 + 65,000 | 385,000 |
The component sum must equal the facility-interest total. Also tie the $6,000,000 of principal to the supplied borrowing balances, allowing for documented differences between principal and accounting carrying values.
For actual expense, reconcile each rate period using its outstanding principal and contractual day-count convention. A closing balance multiplied by a year-end rate is a run-rate calculation; it cannot explain a whole year's ledger expense when balances and rates changed during the year.
First change only the reference rate, from 4.00% to 5.00%, holding principal and spreads constant. That is a one-percentage-point increase, or 100 basis points. Each basis point is 0.01 percentage point.
| Facility | Base interest (USD) | Reference-rate scenario interest (USD) | Change (USD) |
|---|---|---|---|
| Revolver A: rate becomes 7.00% | 180,000 | 210,000 | 30,000 |
| Term loan B: rate becomes 8.00% | 140,000 | 160,000 | 20,000 |
| Fixed loan C: rate stays 6.50% | 65,000 | 65,000 | 0 |
| Total | 385,000 | 435,000 | 50,000 |
The check is 5,000,000 × 1.00% = $50,000. The weighted rate becomes 435,000 / 6,000,000 = 7.25%. No contractual spread changed, so the increase is entirely the supplied reference-rate assumption.
Now add a separate assumption: loan B's spread increases from 3.00% to 3.50%, while the higher reference rate remains. Its rate becomes 8.50%, generating $170,000 of annualized interest. The additional spread effect is 2,000,000 × 0.50% = $10,000, bringing total interest to $445,000 and the weighted rate to 7.42%, rounded.
These comparisons quantify sensitivity. They do not predict a lender's pricing or recommend a borrowing decision. Put the supplied interest assumptions into the cash flow forecast, and read the resulting expense alongside coverage and liquidity ratios. The working-capital loan balance-sheet review separately addresses classification and liquidity presentation.
Upload the facility balances, supplied reference rates, contractual spreads and approved scenario assumptions. Covirage maps the columns; its tools compute and check the figures, and the external AI model explains the interest-cost comparisons with every figure traced to its rows. Create a free Covirage account and bring a sample of your own export.
See FP&A reporting in Covirage for the reporting context.
Not exactly. A quoted spread is observable against a specified reference rate. A pure risk premium is the compensation for bearing risk beyond expected losses, which requires additional assumptions to estimate. For management reporting, label the supplied contractual spread and avoid presenting it as a separately measured pure premium.
Yes. A floating-rate facility can become more expensive when its reference rate increases, even with the same contractual spread. Interest expense can also rise because the drawn balance increases. Separate reference-rate, spread and balance changes before attributing the movement to the company's credit position.
Include its interest cost and balance when calculating the schedule's weighted borrowing rate. Keep the fixed rate separate from floating reference rates. A supplied reference-rate change does not alter the fixed contractual rate unless another supplied agreement or hedge changes the company's interest exposure.
It may differ. A simple schedule weights stated rates by principal, while reported interest expense can include amortized fees, discounts, changing balances and other items. Reconcile those differences before comparing the schedule with the ledger, and state whether the measure is before tax.