What lenders really look for in a cash flow forecast

A strong cash flow forecast can decide a funding application before the lender even reaches the business plan. The numbers are only half of it, the structure, the assumptions and the realism behind them carry just as much weight.

Why the cash flow forecast carries the weight

A funding decision rarely comes down to one document. But when a lender or investor wants to know whether you can service the borrowing, the cash flow forecast is what they reach for first. It tells them what you actually expect to happen, month by month, in numbers you have committed to.

This matters more than the profit and loss statement, and most owners get this the wrong way round. The P&L tells a lender what the business looks like on paper. The cash flow tells them whether the business can pay them back. A perfectly profitable company can go bust waiting for invoices to clear. A modestly profitable one with disciplined cash management is a much better bet, and lenders know it.

The forecast is also the document that gets the most scrutiny. Numbers can be checked. Assumptions can be questioned. Patterns can be compared to your historical data. There is nowhere to hide.

The four things checked first

In most reviews, four questions get answered before anything else. Get these right and the conversation moves on to the strategic side. Get them wrong and the application stalls.

1. Is it realistic? Lenders will compare your growth rate to the last two years of actual trading. A forecast that suddenly grows 40 percent year-on-year after three years of flat trading needs a very good explanation. Conversion rates, win rates and average order values should match what your business has historically achieved. If you have changed something material, a new sales channel, a hire, a product launch, say so explicitly.
2. Does it match the rest of the application? The cash flow forecast must agree with the business plan, the sales forecast and any pipeline data you have submitted. A bank that finds the same revenue figure presented three different ways will start asking which one is the truth. The answer should be the same number, every time, in every document.
3. What happens if it slips? Every credible forecast comes with a downside scenario. What does cash look like if revenue lands at seventy percent of forecast? Eighty? What about a six-month delay to a major contract? Lenders are not looking for optimism. They are looking for a borrower who has thought through what could go wrong and how the business would absorb it.
4. Where is the cash actually coming from? Customer concentration matters. If sixty percent of forecast revenue comes from two clients, that is a different risk profile than fifty smaller customers. Payment terms matter too, revenue booked in March that does not arrive in the bank until July is a working capital issue, not just a profit number.

Common mistakes that sink an application

Most rejected applications fail on avoidable errors. The four below come up again and again.

Overstated revenue ramps. Sales forecasts that grow in a smooth diagonal line. Real businesses do not grow that way. Seasonality, sales cycles, holiday gaps, conversion lag, the line should look messy because real trading is messy. A perfectly smooth growth curve signals the forecast was built top-down rather than bottom-up.

Missing tax timings. Corporation tax, PAYE and VAT all hit cash on specific dates, not when the underlying transactions happen. A forecast that shows VAT-inclusive revenue without modelling the quarterly VAT payment is missing a chunk of cash outflow. Same for the corporation tax payment nine months after year-end. These are not surprises, they are scheduled.

Treating invoiced as paid. Booking revenue on the date you invoice rather than the date you actually receive payment is the most common forecast error in service businesses. If your average debtor day count is forty-five, every pound of revenue in March is really a pound of cash in May. Build that in.

No headroom for seasonality. Businesses that have a quiet quarter need to build that into the forecast openly, not hide it. A forecast that pretends the quiet quarter does not exist will fall apart at the first review.

Assumptions are everything

Every forecast is a set of assumptions wearing a spreadsheet. The strongest forecasts make those assumptions visible, sales conversion rates, average order value, payment days, churn, the lot. You want a lender to be able to see the assumption, agree or disagree, and understand the impact. You do not want them digging for it.

I tend to put assumptions on their own page or tab in the forecast model, with clear labels. That single change can make the difference between an application that gets approved and one that gets sent back for clarification.

What good headroom looks like

Rule of thumb: model a base case, a stretch case and a downside. The downside should show what happens if revenue lands at seventy to eighty percent of forecast and one major cost increases by ten percent. If the business can still service the borrowing in that scenario, you have built in real headroom. If it cannot, the borrowing is the wrong size or the wrong shape.

Putting it together

A forecast that wins funding is one where every number can be defended in plain English. The numbers are the easy bit. The clarity behind them is the work.

If you are preparing an application and want a second pair of eyes on the figures, that is exactly the kind of work we do. The cost of getting an application right the first time is usually small compared to the cost of getting it wrong, whether that is a rejection, a worse interest rate, or simply a delay that derails what you were trying to fund in the first place.