How do banks test a borrower's financial forecast?

The first test is not applied to the forecast at all — it is applied to the last one. A credit desk looks for what the same management projected two and three years ago and what actually arrived, because forecast accuracy is a property of the forecaster before it is a property of the spreadsheet. After that the reading is line by line: the revenue increase separated into volume and price, gross margin held against what the business has ever achieved, fixed costs that step rather than scale, working capital assumptions that must move with the sales being forecast, capex split between maintaining the asset base and growing it, then tax, distributions and debt service. Finally the whole thing is run downward.

What makes a bank reject a forecast outright?

Three patterns, none of which is about ambition. A revenue line that grows while the working capital lines do not, because more sales on the same terms mechanically absorb more cash and a forecast that has not funded its own growth is not finished. A margin that improves at the same time as volume, with nothing named that would cause it. And a forecast that does not reconcile to a balance sheet and a cash flow — because a profit projection alone cannot show whether the money exists in the month the payment is due. A bank rarely argues with the assumptions before it has checked that the three statements agree.

What is reverse stress testing in commercial lending?

Instead of asking what happens if revenue falls by a set percentage, it asks the more useful question in reverse: how much has to go wrong before this facility cannot be serviced? The answer is a single number a borrower can hold — the fall in sales, or the margin compression, or the delay in collection that consumes the headroom entirely. It is more informative than a standard downside case because it does not depend on choosing the right shock in advance, and it changes the conversation from whether the forecast is right to how much room there is if it is not.

Should a borrower present a conservative forecast or an ambitious one?

Present the one you will beat, and say why it is conservative. A forecast is not only a projection; it is evidence about the person who made it, and it is remembered. Beating a modest forecast builds the single strongest signal a borrower can build with a lender, and it compounds across reviews. Missing an ambitious one costs more than the shortfall, because the next forecast is discounted before it is read. If the ambitious case matters to you, show both: the base the facility is sized against, and the upside you are working toward, clearly labelled as such.

// FOR BORROWERS AND BANKERSTHE FORECAST, READ AS EVIDENCE

How Banks Test Borrower Forecasts

The first test is not applied to this forecast. It is applied to the last one.

BY MICHAEL SHANG · SIXTEEN YEARS IN COMMERCIAL BANKING · UPDATED 2026-09-05

// THE SHORT ANSWER

The first test is not applied to this forecast but to the last one: what the same management projected two years ago against what arrived, because accuracy is a property of the forecaster before it is a property of the spreadsheet. Then six lines in order — revenue split into volume and price, margin against what this business has achieved, overheads that step rather than scale, working capital days applied to the forecast sales, capex separated into maintenance and growth, then tax, distributions and debt service. Finally the question in reverse: how far would sales have to fall before the facility cannot be serviced?

BASIS Practitioner judgment from sixteen years in commercial banking, set out in How Bankers Think (Highbank Press, 2026). Every borrower on this site is a composite constructed for teaching, not a client. The market is mid-market commercial lending as practised in New Zealand and Australia; where a convention differs elsewhere, the page says so.

// 01 — START WITH THE FORECASTER

Before a single assumption is examined, an experienced desk looks for what this management projected two and three years ago, and what actually arrived. Forecast accuracy is a property of the forecaster before it is a property of the spreadsheet, and it is the one input that cannot be produced for the occasion.

The reading is about direction more than size. A business that missed a year because a customer failed has a story. A business that has been optimistic by a similar margin in the same direction every year has a habit, and the habit is the information — every individual explanation can be reasonable while the pattern remains the most reliable predictor in the file. This is the same evidence the desk uses to read management quality, which is not a coincidence.

For a first-time borrower with no track record, the substitute is corroboration outside the forecast: contracts, an order book, capacity that already exists, terms already agreed. A number with a document behind it survives; a number with a rationale behind it is discounted.

// 02 — SIX LINES, READ IN ORDER

The reading below is not a search for errors. It is a search for the assumptions that were made without being noticed, which is where forecasts usually fail.

01
Revenue
Split into volume and price before anything else. Growth from volume needs capacity, people and working capital behind it; growth from price needs a reason the market accepts. A single percentage hides which one is being claimed.
02
Gross margin
Held against what this business has actually achieved, not against the sector. A margin that improves while volume grows is the assumption most often made and least often explained.
03
Overheads
Fixed costs step; they do not scale smoothly. A forecast that grows revenue by a third on the same overhead line is asserting that nobody is hired, nothing is leased and no system is bought.
04
Working capital
Debtor, stock and creditor days applied to the forecast sales. If the days are held flat while sales rise, the cash absorbed by that growth has to appear somewhere — and if it does not, the forecast has not funded itself.
05
Capital expenditure
Separated into maintaining the asset base and expanding it. A forecast that grows output while capex sits at maintenance is asking the existing plant to do more than it has ever done.
06
Below the line
Tax on the profits being forecast, distributions at the rate the owners have actually taken, and debt service on both existing facilities and the one being requested.

The fourth is where most forecasts break, and it is the one borrowers least expect. Growth absorbs cash arithmetically: every extra dollar of revenue carries its share of the cash cycle. A forecast that grows sales while holding the working capital lines flat has quietly assumed that customers will pay faster or suppliers will wait longer, and has not said so.

// 03 — THE THREE STATEMENTS HAVE TO AGREE

A profit forecast on its own cannot be tested, because it cannot show whether the money exists in the month the payment falls due. What a desk wants is the projection reconciled across all three statements, month by month for at least the first year: the profit and loss, the balance sheet it implies, and the cash flow that connects them.

Monthly matters more than it sounds. An annual forecast can be comfortably serviceable and still contain a month where the facility is exhausted — a seasonal build, a tax payment, an insurance renewal landing in the same fortnight as a large stock purchase. Facilities are sized against peaks, not averages, and the peak is invisible in an annual view.

This is also the point where a forecast meets the question of whether the earnings behind it were real. A forecast that projects forward a profit which never converted to cash in the past is projecting the conversion problem forward with it. Issue 07 is the published file where that gap decides the answer.

// 04 — THE DOWNSIDE, AND THE BETTER QUESTION

The conventional next step is a downside case: revenue falls, margin compresses, collection slows, and the desk checks whether the facility is still serviced and the covenants still hold. It is worth doing, and it has one weakness — it requires choosing the right shock in advance, which is the thing nobody can do.

The more useful question runs in reverse. Rather than asking what happens if sales fall by some chosen amount, ask how far they would have to fall before this facility cannot be serviced. The answer is a single figure the borrower can hold in their head, and it converts an argument about whose forecast is right into a shared understanding of how much room there is if neither is.

It also changes what covenant headroom means. Headroom is not a negotiating concession; it is the distance between the forecast and the point at which the bank has to act. A borrower who understands that number negotiates for the right thing.

// 05 — WHAT TO SEND, IF YOU ARE THE BORROWER

A forecast that survives this reading has four things attached. The prior forecast next to what actually happened, including the misses, with a sentence on each. The revenue line separated into volume and price. Working capital assumptions stated as days, so the reader can see they move with the sales. And a monthly view for the first year, so the peak is visible rather than discovered.

Sending those four is not extra work for the bank's benefit. It is the difference between a forecast that is questioned and one that is used, and it usually shortens the approval more than any argument about the assumptions would. Cash flow analysis for business lending sets out the historical half of the same reading.

// QUESTIONS PEOPLE ASK

How do banks test a borrower's financial forecast?: The first test is not applied to the forecast at all — it is applied to the last one. A credit desk looks for what the same management projected two and three years ago and what actually arrived, because forecast accuracy is a property of the forecaster before it is a property of the spreadsheet. After that the reading is line by line: the revenue increase separated into volume and price, gross margin held against what the business has ever achieved, fixed costs that step rather than scale, working capital assumptions that must move with the sales being forecast, capex split between maintaining the asset base and growing it, then tax, distributions and debt service. Finally the whole thing is run downward.
What makes a bank reject a forecast outright?: Three patterns, none of which is about ambition. A revenue line that grows while the working capital lines do not, because more sales on the same terms mechanically absorb more cash and a forecast that has not funded its own growth is not finished. A margin that improves at the same time as volume, with nothing named that would cause it. And a forecast that does not reconcile to a balance sheet and a cash flow — because a profit projection alone cannot show whether the money exists in the month the payment is due. A bank rarely argues with the assumptions before it has checked that the three statements agree.
What is reverse stress testing in commercial lending?: Instead of asking what happens if revenue falls by a set percentage, it asks the more useful question in reverse: how much has to go wrong before this facility cannot be serviced? The answer is a single number a borrower can hold — the fall in sales, or the margin compression, or the delay in collection that consumes the headroom entirely. It is more informative than a standard downside case because it does not depend on choosing the right shock in advance, and it changes the conversation from whether the forecast is right to how much room there is if it is not.
Should a borrower present a conservative forecast or an ambitious one?: Present the one you will beat, and say why it is conservative. A forecast is not only a projection; it is evidence about the person who made it, and it is remembered. Beating a modest forecast builds the single strongest signal a borrower can build with a lender, and it compounds across reviews. Missing an ambitious one costs more than the shortfall, because the next forecast is discounted before it is read. If the ambitious case matters to you, show both: the base the facility is sized against, and the upside you are working toward, clearly labelled as such.

// WHEN THE PROFIT NEVER BECAME CASH

A listed retailer reports profit up nine per cent while operating cash flow falls thirty-one, and asks the bank club to consent to a bigger dividend. Four options, then the senior banker's reading — free, no signup.

Read Issue 07 →