Levered Forecast

Most owners who present a forecast to a bank present one case, and it is usually a good one. Revenue grows, margins hold, and the debt is paid down comfortably. The credit analyst reads it, thanks the owner, and builds a downside of their own, with revenue lower, costs stickier and rates higher, chosen to protect the bank. The facility is then sized on the analyst's downside, which the owner never sees and cannot argue with.

The alternative is for the business to build the downside itself, before anyone knows the answer, and to show a record that its forecasts can be trusted. That is what Levered Forecast does. A credit committee sizes debt on the stressed case, so the driver shows a lender how much debt cash flow available for debt service carries in a downside, and the debt offered is then sized to the business's evidence instead of the analyst's private pessimism.

Thirty-six months, two cases

The forecast covers levered cash flow month by month for thirty-six months, in a base case and a downside case, with every covenant test shown month by month and met in the downside. The downside is stated in exact terms, set by the framework: revenue well below the base case, and interest rates well above what the market currently expects.

It is built from the enterprise forecast inspected at the start of the bridge. That model, with its driver inputs, its back-test and its independent review, is the base, and debt service for each candidate structure is layered on top of it. Built that way, the enterprise view and the levered view cannot disagree, because they are the same model with and without the lender.

The rule that matters most here concerns timing. The owner writes down and approves the downside assumptions before the model is run. That sounds procedural, but everything else depends on it. A downside chosen after seeing the results can always be tuned to pass, by softening the revenue fall a little or assuming costs come down faster. A downside fixed in advance is a test the business might fail, and that is why a credit committee believes it when it passes. The lender is shown a bad year the business has already planned for and does not have to invent one, which removes the discount for certainty that an analyst's private downside would otherwise apply.

A record of being right

The second requirement is a track record. Over the latest year, levered cash flow has to have landed close to what was forecast for those months, with every variance explained in writing.

Two habits build the record. Forecast is compared with actual every month on a page in the lender pack, with the cause of each material variance named. And the forecast is redone every quarter, with every version kept and none overwritten, so the record can be inspected and does not have to be taken on trust. A business that keeps only its latest forecast cannot show how good its earlier ones were.

The framework treats this record the way it treated the budget record. Twelve monthly observations are one year of one business, and the pack says so. The record earns the business's own variance assumptions some weight against the lender's standard downside, more as the record lengthens and less where it has swung, and the pack shows the weight and how it was set. The downside narrows only as far as the record has earned. A year of good forecasts shows the process works; it says nothing about whether next year can go wrong.

Rates as a stress

The forecast also has to show debt service coverage with interest rates sharply higher, and a written policy has to state how much of the debt is hedged, for how long, with which instruments and on whose authority.

The stress is run on every candidate structure, floating, fixed and mixed. A floating-rate facility is usually cheaper on the day it is signed and more dangerous in the year rates rise. A fixed-rate facility costs more up front and removes the risk. Which is better depends on the business, and the stress on each structure shows which one this cash flow can afford, so the policy is chosen against that evidence.

The policy is one page, drafted by the finance lead and approved by the owner before any facility is signed. It says what share of the debt will be fixed, swapped or capped, for how long, using which instruments, and who may execute them. What it buys is a decision made once and deliberately, before the first term sheet arrives and makes it by default. With the policy in place, the cash flow's sensitivity to rates is known and bounded before the debt is drawn.

What the owner can decide with it

A levered forecast with an honest downside is a lender's document, and it is also the owner's best tool for deciding how to borrow. Until it exists, the questions about debt are answered by whoever is offering it. Once it does, the owner can answer them.

How much to borrow becomes a reading from the downside. Which structure to choose becomes a comparison of the rate stress on each. Whether the business can afford an acquisition, a new site or a large hire in the second year of the facility comes down to whether the downside still clears its covenants with that spending in it. And the quarter in which the downside comes closest to the coverage floor becomes the quarter the owner knows to watch, with a list of actions ready if the actual results start to follow the downside.

That last use keeps paying long after the facility is signed. A business that knows which quarter is tightest, and why, rarely breaches in it, because it starts acting months before the test.

What it does to value

Levered Forecast ranks fourth on the bridge. It sizes the tax shield without earning it, and the shield is counted once, on Facility Sizing. Its own value is distress avoided. A facility sized to a downside the business has tested is less likely to breach than one sized to the base case, and the fall in that probability, multiplied by what a breach would cost the owners in fees, forced sales and abandoned growth, is what the framework counts.

A credit committee may offer a larger facility because the record has earned its trust. That is a price effect and is recorded as one. It feels like value to an owner who wanted to borrow more, but more debt is worth only its tax shield, and being trusted does not create a shield.

What has to be in place first

The forecast depends on three things. It needs the budget accuracy inspected at the start of the bridge, because a levered forecast built on budgets that have missed inherits the miss. It needs the lender's figure reconciled under Lender Reporting, because the forecast and the pack must use the same definition or the track record compares unlike numbers. And it needs a finance lead who can build and maintain the model, either in the seat or with outside modelling support budgeted until the seat can do it.

Knowing that it works

The forecast's credibility is built in months: the history of forecast against actual is counted in months toward the year the record needs, and the forecast variance on levered cash flow each month should stay small. The lowest monthly debt service coverage in the downside case is the first number a credit committee reads, and it should stay above the coverage floor.

Without opening the model, the owner should be able to name the first covenant to break in the downside, with the month and the revenue level at which it breaks. An owner who can do that understands where the business's risk sits. Presenting the forecast to someone who will challenge it, the outside accountant or a lender the business is not borrowing from, before a credit committee sees it shows whether it holds up under questions.

Why it slips, and what holds it

Leverage creeps past capacity as the business borrows a little more for this and a little more for that, each addition small and the total large. And a covenant is breached, usually because nobody saw it coming.

Both are caught by looking ahead. A rolling forecast always shows a year of covenant headroom ahead, so a squeeze shows a year before it arrives, while there is still time to act. And a quarterly reforecast on a fixed date in the finance calendar puts a covenant at risk in front of the owner before it appears in a compliance certificate.