The 13-Week Cash Flow Forecast: Building One Your Investors and Lenders Trust
A 13-week cash forecast is only useful if people believe it. How to build, review and evidence a rolling forecast that holds up under investor and lender scrutiny.
When trading tightens or a covenant test approaches, the first thing a private equity sponsor asks for is a 13-week cash flow forecast. Many finance teams produce one for the first time under pressure, and it shows.
A good short term cash forecast is not a spreadsheet exercise. It is a control. It tells the board how much headroom exists, when pressure points arrive and whether management actually understands the cash cycle of the business.
Build it from receipts and payments, not profit
The most common mistake is deriving cash from the profit and loss account. A direct forecast starts from the aged debtors ledger, the purchase ledger, the payroll calendar, VAT and PAYE dates, rent and debt service. Each line should be traceable to a source someone can check.
Weekly granularity matters. Monthly forecasts hide the fact that payroll and the quarterly VAT payment can fall in the same week.
Variance analysis is the real test
A forecast earns credibility through comparison. Every week, compare last week's forecast with actual cash movements and explain the material differences. Over a few weeks the pattern of variances shows where assumptions are weak.
Keep the variance log. Lenders and auditors assessing going concern will want to see that forecasts have historically been reliable, and the log is the evidence.
Agree ownership and review
Name an owner for each major input. Sales leaders should stand behind collection timing, operations behind supplier payments. The Finance Director reviews and signs off the consolidated version before it goes to the board.
Version control matters too. Store each weekly forecast rather than overwriting the file, so you can show what was known and when.
Link it to decisions
The forecast should drive action: chasing specific debtors, phasing capital spend, or opening a conversation with the lender early. A forecast that nobody acts on is a reporting burden. One that shapes decisions is a governance asset that supports your going concern assessment at year end.