How do I forecast our interest cost for next year's budget?

Forecast next year’s interest off the forward curve for your debt’s benchmark, at the facility’s own reset tenor, not last year’s average. The Excel add-in puts a projected fixing against every payment date in the model and refreshes it daily. Today the 2027 SONIA forwards sit 66bp above the rest-of-2026 forward, which a flat budget misses.

No card needed · 14-day free trial
Excel budget for a GBP 100m facility: 3M SONIA forwards by 2027 quarter, interest and a column chart
  • +66bpwhere 2027 SONIA forwards average above the rest-of-2026 forward
  • Dailyrefresh, so the forecast tracks the market
  • 1M to 12Mreset tenors, each with its own forward curve

Today, and with BlueGamma

How it usually gets done

  • Last year's average rate, rolled forward into every year of the plan.
  • Hovering over a free chart to pick off data points, because the download is locked.
  • The bank's emailed projections, which stop at about two years.

With BlueGamma

  • The forward curve for your debt's benchmark, at the facility's own reset tenor.
  • Monthly or quarterly points that line up with each payment date.
  • Excel formulas that refresh daily, and an API for the ERP when you are ready.

Not the right fit if your debt is fully fixed for the budget year. The forecast only matters for the floating part.

How it works

  1. 01

    Pick the benchmark and the reset tenor

    EURIBOR, SONIA or SOFR, then the tenor from the facility agreement: 1M, 3M, 6M or 12M. Each has its own curve, and they diverge before you have assumed anything. It works the same way for BBSW, CORRA and the other currencies in the group.

    Excel budget for a EUR 100m facility: 6M EURIBOR forwards for each 2027 half-year, interest and a column chart
  2. 02

    Put a fixing against every payment date

    A quarterly-paying facility needs a projected fixing for every reset, not an annual tenor. In the Excel add-in, one formula per period returns the forward; add the margin and apply it to the notional outstanding, and that is the interest line.

  3. 03

    Let it refresh, and re-run after big moves

    The formulas re-pull daily, so every reforecast reads the live curve, and a locked valuation date reproduces the curve the budget was approved on. Ready to automate? Feed the ERP from the API.

In their words

“Every year we have to make plans and we have to make assumptions on… what the [EURIBOR] is going to be the following years. The problem is we use a static forecast which limits our ability to provide good forecasts.”
Corporate finance team, European transport group
“My issue with [the terminal] is it's only annually. I like this option to just pull the forward curve monthly or quarterly going out. So don't get rid of that feature.”
Debt capital markets lead, real estate investment firm

Your options, compared

Last year's average looks backwards and free sources stop at past fixings. BlueGamma gives you the forward curve, on your payment dates, straight into the model.

CriterionBlueGammaLast year's average rateFree websites and central banksYour bank's projections
Does it look forward?Yes, the full forward curveNo, it only looks backMostly past fixings, not forecastsYes
How far ahead does it go?Decades, beyond 2050One year, repeatedAbout 10 years, then flatAbout 2 years
Does it cover 1, 3, 6 and 12-month rates?Yes, all four for each benchmarkNo, one blended numberPast fixings onlyOnly what the bank sends
Can you get monthly or quarterly points?Yes, on your payment datesNoNoNo
How does it get into your model?Excel formulas or the APITyped in by handRead off a chartRe-typed from an email

Questions teams ask

Put next year's budget on the curve

Pull the EURIBOR, SONIA or SOFR forward curve into your model this afternoon, and stop rolling last year's average forward.

Forecast your interest cost
No card needed · 14-day free trial