Tutorials › VEE Accounting and Finance › Floating-Rate Debt And Resetting Costs

VEE Accounting and Finance · Cost of Debt and Preferred Equity · Tutorial 607 of 996

Floating-Rate Debt And Resetting Costs

Estimate the cost of floating-rate debt by applying each reset-date benchmark and contractual spread to the correct balance and accrual period.

Intermediate 10 min read

What You'll Learn

  • Calculate a floating borrowing rate from its reference rate and contractual spread.
  • Distinguish the rate currently in force from rates projected for future reset dates.
  • Compute interest across reset periods using the applicable day-count fraction and balance.
  • Annualize a multi-period borrowing cost using principal-time exposure.
  • Identify common errors involving reset dates, percentage points, and annual rates.

How a Floating-Rate Debt Cost Is Set

A floating-rate loan does not have one fixed interest rate for its entire term. Its rate is linked to a reference rate, such as a specified market benchmark, plus or minus a contractual spread. At each reset date, the benchmark is observed or otherwise determined under the agreement; the resulting rate then applies to the next interest-accrual period. Estimating the borrowing cost therefore requires attention to both which rate applies and for how long.

For a current cost estimate, use the benchmark that is in force under the contract at the relevant reset date. For a projected cost, use an explicit set of benchmark assumptions or forecasts for future reset dates. A present benchmark observation alone does not establish the rates that will apply at later resets.

Definition: A floating-rate borrowing rate for reset period \(j\) is the reference rate determined for that period, \(R_j\), plus the contractual spread, \(s\). Thus \(r_j=R_j+s\). The spread is usually stated as a fixed number of percentage points while the reference rate changes. This basic formula assumes no contractual floor, cap, or other adjustment; if the agreement contains one, apply its terms to the benchmark-plus-spread rate.

The quoted rate \(r_j\) is ordinarily an annual rate. To calculate interest for a fraction of a year, multiply it by the outstanding principal and the contract’s day-count fraction. If \(B_j\) is the balance during period \(j\), and \(\alpha_j\) is the year fraction specified by the applicable day-count convention, simple interest for that period is \(B_jr_j\alpha_j\). For example, under a 90/360 convention, a 90-day period has \(\alpha_j=90/360=0.25\).

Interest for one reset period: If the balance and annual rate remain constant during period \(j\), the interest accrued is \(I_j=B_j(R_j+s)\alpha_j\). This is a simple-interest accrual calculation, not a yield-to-maturity calculation. It assumes the stated balance remains outstanding for the period and does not incorporate fees or other financing cash flows.

From Reset Schedule to Borrowing Cost

For a loan with several reset periods, calculate interest period by period. The applicable benchmark can differ across periods, and the principal can also change. The total interest is the sum of the period amounts. If the question asks for a single annualized rate for the full interval, divide total interest by total principal-time exposure, using year fractions consistent with the interest calculations.

$$ I_{\mathrm{total}}=\sum_{j=1}^{n} B_j(R_j+s)\alpha_j, \qquad r_{\mathrm{weighted}}= \frac{I_{\mathrm{total}}}{\sum_{j=1}^{n}B_j\alpha_j}. $$

The denominator is measured in dollar-years when balances are in dollars and \(\alpha_j\) is in years. The resulting \(r_{\mathrm{weighted}}\) is an annualized simple rate over the periods included. If the balance is constant throughout, this becomes a time-weighted average of the applicable annual rates. When balances vary, periods with larger principal-time exposure receive more weight.

Worked Example: Finding the Current Rate and Period Interest

A hypothetical company has $6,000,000 outstanding on a floating-rate loan. The contract resets every 60 days. At the current reset, the reference rate is 4.20% and the contractual spread is 1.15 percentage points. The next 60-day accrual uses a 60/360 day-count fraction. Find the annual rate currently in force and the interest for that period.

Method. First add the spread to the benchmark in percentage points. Then convert the accrual period into a year fraction and apply simple interest.

The current annual rate is \(4.20\%+1.15\%=5.35\%\), or \(0.0535\) in decimal form. The year fraction is \(60/360=1/6\). Therefore:

$$ I=6{,}000{,}000(0.0535)\left(\frac{60}{360}\right) =6{,}000{,}000(0.0535)\left(\frac{1}{6}\right) =53{,}500. $$

The loan’s current annual borrowing rate is 5.35%, and interest for the 60-day period is $53,500. Check: at a 5.35% annual rate, a full year’s simple interest on $6,000,000 would be $321,000; one sixth of that is $53,500. This calculation avoids treating the annual rate as though it were the rate charged for the whole 60-day period.

Why the Weighted Annualized Rate Works

Each period contributes interest equal to its annual rate multiplied by its own principal-time exposure. In symbols, period \(j\) contributes \(I_j=r_jB_j\alpha_j\). Summing these contributions gives total interest. Dividing that total by the sum of all principal-time exposures produces the single annual rate that would generate the same total interest across the same balances and year fractions.

1
Find the period rates.
For each reset period, add its applicable reference rate to the contractual spread, following any stated contractual floor, cap, or adjustment.
2
Find each year fraction and balance.
Use the contract’s day-count convention and the principal actually outstanding during that accrual period.
3
Calculate and add interest.
For each period, multiply balance by annual rate by year fraction, then sum the period amounts.
4
Annualize if requested.
Divide total interest by the sum of balance times year fraction. Do not divide by principal alone unless the total exposure represents exactly one year at that principal.

To verify the weighted-rate formula, define \(r_{\mathrm{weighted}}\) as the constant annual rate that would produce the observed total interest on the actual sequence of balances and accrual periods. Under simple interest, that rate must satisfy

$$ r_{\mathrm{weighted}}\sum_{j=1}^{n}B_j\alpha_j=I_{\mathrm{total}}. $$

Solving for \(r_{\mathrm{weighted}}\) gives \(I_{\mathrm{total}}/\sum_jB_j\alpha_j\), as stated. This is a principal-time-weighted average, not necessarily a simple average of the reset rates. The derivation depends on simple accrual over each period; it does not assert that interest-on-interest has been compounded.

Worked Example: Combining Two Reset Periods and a Principal Reduction

A hypothetical borrower has $3,000,000 outstanding for a 90-day period and then repays $600,000 at the reset date. The remaining $2,400,000 is outstanding for the next 90 days. The spread is 0.80 percentage point throughout. The reference rate is 3.60% for the first period and 4.40% for the second. Both periods use 90/360 accrual. Find total interest and the annualized weighted cost over the two periods.

Method. Calculate each reset-period rate and interest separately. Then divide total interest by the combined dollar-year exposure; the repayment changes the balance weight for the second period.

The first-period annual rate is \(3.60\%+0.80\%=4.40\%=0.044\). The year fraction is \(90/360=0.25\), so:

$$ I_1=3{,}000{,}000(0.044)(0.25)=33{,}000. $$

The second-period annual rate is \(4.40\%+0.80\%=5.20\%=0.052\). After the repayment, the balance is $2,400,000, so:

$$ I_2=2{,}400{,}000(0.052)(0.25)=31{,}200. $$

Total interest is \(I_{\mathrm{total}}=33{,}000+31{,}200=\$64{,}200\). The combined principal-time exposure is

$$ 3{,}000{,}000(0.25)+2{,}400{,}000(0.25) =750{,}000+600{,}000 =1{,}350{,}000\text{ dollar-years}. $$

Thus the annualized weighted cost is \(64{,}200/1{,}350{,}000=0.047555\ldots\), or 4.756% to three decimal places. Check: the rate lies between 4.40% and 5.20%, as a weighted average of those two rates should. The common mistake avoided here is averaging the two rates equally despite the different balances.

Projecting Costs When Benchmarks May Change

A projected cost requires a benchmark assumption for each future reset date. Those assumptions are forecasts, not contractual certainties. Once the rate assumptions and balance schedule are specified, the same period-by-period method applies. A projected annualized cost summarizes that particular scenario; it should not be presented as a guaranteed future rate.

Worked Example: Projecting a Full Year of Quarterly Resets

A hypothetical firm expects to keep $5,000,000 outstanding for one year on a loan that resets every 90 days. Assume 90/360 accrual, a fixed spread of 1.00 percentage point, and projected reference rates of 3.80%, 4.10%, 4.70%, and 4.30% at the four successive resets. Estimate the total interest and the annualized weighted cost under these assumptions.

Method. Treat each projected reference rate as applying only to its corresponding quarter. Add the fixed spread, calculate each quarter’s interest, and sum the results.

The four annual rates are respectively \(3.80\%+1.00\%=4.80\%\), \(4.10\%+1.00\%=5.10\%\), \(4.70\%+1.00\%=5.70\%\), and \(4.30\%+1.00\%=5.30\%\). Each quarter has a year fraction of \(90/360=0.25\). The interest amounts are:

$$ \begin{aligned} I_1&=5{,}000{,}000(0.048)(0.25)=60{,}000,\\ I_2&=5{,}000{,}000(0.051)(0.25)=63{,}750,\\ I_3&=5{,}000{,}000(0.057)(0.25)=71{,}250,\\ I_4&=5{,}000{,}000(0.053)(0.25)=66{,}250. \end{aligned} $$

Total projected interest is \(60{,}000+63{,}750+71{,}250+66{,}250=\$261{,}250\). The exposure is \(5{,}000{,}000(4\times0.25)=\$5{,}000{,}000\) dollar-years. Therefore the annualized weighted cost is \(261{,}250/5{,}000{,}000=0.05225\), or 5.225%. Check: the equal-balance, equal-length quarterly rates average to \((4.80+5.10+5.70+5.30)/4=5.225\%\), which matches the computed annualized rate. That shortcut works here because every balance and accrual period is equal; it would not generally work with unequal exposures.

Common Mistakes and Practical Interpretation

A floating-rate cost estimate is only as sound as its reset schedule, balance schedule, and day-count assumptions. In practice, confirm the contract’s reset frequency, the date on which the benchmark is fixed, the spread, any applicable floor or cap, and the convention used to count accrual days. A rate observed on one date may govern a period that begins after that date; use the contract’s specified timing rather than assuming the benchmark changes daily.

  • Using today’s benchmark for every future period. That silently assumes the benchmark does not change. For a projection, state the assumed benchmark at each reset or explicitly state that a constant benchmark is being assumed.
  • Misreading the spread. A spread of 0.90 percentage point added to a 4.00% reference rate gives 4.90%, not \(4.00\%\times1.009\).
  • Using the annual rate as a period rate. A quoted 5% annual rate over a quarter with 90/360 accrual produces a 1.25% simple accrual on the balance, because \(0.05(90/360)=0.0125\).
  • Ignoring a changing balance. A repayment or borrowing during the schedule changes principal-time exposure and therefore affects both interest and the annualized weighted cost.
  • Confusing an annualized rate with total interest. The annualized rate is a rate measure; the dollar interest depends on principal and time. State which quantity is being requested.

For instance, if a borrower has $4,000,000 outstanding for two 90-day quarters, with a 0.90 percentage-point spread and reference rates of 4.00% and 4.60%, the period rates are 4.90% and 5.50%. At 90/360, the interest amounts are \(4{,}000{,}000(0.049)(0.25)=\$49{,}000\) and \(4{,}000{,}000(0.055)(0.25)=\$55{,}000\). Total interest is $104,000, not $98,000. The exposure is \(4{,}000{,}000(0.50)=\$2{,}000{,}000\) dollar-years, so the annualized weighted cost is \(104{,}000/2{,}000{,}000=\)5.20%. Reusing the first period’s rate for the second would miss the effect of the reset.

Key takeaway: At each reset, determine the rate that the contract makes applicable to the next accrual period. Multiply that annual rate by the balance and the correct year fraction to obtain interest; use total principal-time exposure to calculate a multi-period annualized weighted cost.

Check Your Understanding

For each problem, use the stated simple-interest convention and round only the final amount or rate as requested.

  1. A hypothetical $2,500,000 loan resets for a 45-day period. The reference rate at reset is 4.70%, the spread is 1.10 percentage points, and accrual is 45/360. Find the annual rate and period interest. (Answer: 5.80%; $18,125.00)
  2. A borrower keeps $1,800,000 outstanding for two successive 60-day periods. The reference rates are 3.20% and 3.80%, the spread is 0.75 percentage point, and each period uses 60/360 accrual. Find total interest and the annualized weighted cost. (Answer: $25,500.00; 4.250%)
  3. A hypothetical borrower has $4,000,000 outstanding for 90 days at a 5.00% reference rate, then $3,000,000 outstanding for the next 90 days at a 4.50% reference rate. The spread is 1.25 percentage points, with 90/360 accrual in both periods. Find total interest and the annualized weighted cost to three decimal places. (Answer: $105,625.00; 6.036%)
  4. A firm projects that a $1,200,000 balance will remain constant for four 90-day periods. Projected reference rates are 2.80%, 3.00%, 3.60%, and 3.20%; the fixed spread is 1.40 percentage points. Under 90/360 accrual, find projected total annual interest and the annualized weighted cost. (Answer: $54,600.00; 4.550%)
  5. A $1,000,000 balance is outstanding for 50 days at an annual rate of 5.00%, then remains outstanding for 70 days at an annual rate of 5.60%. Use ACT/360 for both periods. Calculate total interest and the annualized weighted cost over the 120 days. (Answer: $17,833.33; 5.350%)
Clinical Biostats