Resources·for portfolio companies
Three-statement forecasting from a budget spreadsheet
How this works when it's built by hand, where the manual version breaks down, and what a properly linked model gives you that a single-tab budget can't.
Most SMEs start forecasting with a P&L budget, covering revenue lines, cost lines, and a projected EBITDA. It's the natural starting point, and for a while it's enough. The moment a fund, a bank, or your own board asks a question about cash, "what happens to our cash balance if we hire two more engineers in Q3," a P&L-only budget has no answer, because cash was never actually modelled. It was assumed.
A three-statement model closes that gap by linking the P&L to the balance sheet and the cash flow statement, so a change anywhere flows through everywhere. Here's what that means in practice, and why it's harder to maintain by hand than it looks.
What "three-statement" actually means
The three statements aren't three separate forecasts. They're one model, viewed three ways, with the outputs of each feeding the others.
drives everything
P&L
Revenue and cost assumptions. Net profit here flows into retained earnings on the balance sheet and into the starting point of the cash flow statement.
the constraint
Balance sheet
Receivables, payables, inventory, and debt balances. These drive the working capital movements that determine how much of your P&L profit actually shows up as cash.
the answer
Cash flow
Derived from the other two: operating cash flow from the P&L adjusted for working capital movements, then financing and investing activity, to arrive at the actual closing cash balance.
How it's usually done by hand
Most budget spreadsheets stop at the P&L tab. Cash, if it's modelled at all, is usually a simplified addition: "profit plus depreciation minus capex," with working capital movements ignored or estimated as a flat percentage. The balance sheet, if one exists, is often built after the fact to reconcile to a cash number that was itself estimated, the reverse of how a proper model works.
This is a reasonable shortcut for a business with simple, stable working capital. It stops being reasonable the moment payment terms, inventory, or growth rate become material enough that the gap between "profit" and "cash" is the actual question being asked.
Where the manual version breaks first
manual spreadsheet
One assumption, one rebuild
Change a hiring assumption and the payroll line updates. But cash, tax, and the balance sheet don't automatically follow unless every downstream formula was built to catch it. In practice, most weren't, so testing a new scenario means partially rebuilding the sheet.
linked model
One assumption, everything follows
The same hiring assumption flows through payroll, cash, working capital, and the balance sheet automatically, because the statements are structurally linked rather than each rebuilt by hand for every scenario.
The balance sheet doesn't balance
Without a genuine link between the three statements, the balance sheet is often forced to balance with a manual plug, which means it's no longer actually testing whether the underlying numbers are consistent.
No fast way to run a scenario
Showing a fund a Base, Conservative, and Aggressive case, three internally consistent versions of the same model, is close to impossible to maintain by hand across three separate tabs without them quietly drifting apart. This is exactly the kind of question a GP raises when a covenant is already close to its threshold. See reading a portco's numbers before the board meeting for what that escalation looks like from their side.
Working capital is guessed, not modelled
A flat percentage assumption for receivables and payables works until growth accelerates or payment terms shift, at which point the cash forecast is wrong in exactly the period it matters most.
What a linked model gives you
The practical payoff isn't precision for its own sake. It's speed when the question changes. A GP asking, ahead of a board meeting, "what does runway look like if revenue is 15% below plan" should be a same-day answer, not a rebuild. A genuinely linked three-statement model, with P&L, balance sheet, and cash flow moving together under Base, Conservative, and Aggressive assumptions, turns that into changing one input and reading the result, rather than reconstructing half the spreadsheet.
Assumption: hire 2 engineers at €6,500/month each, starting Q3
P&L
Payroll +€13,000/month from Q3 onward. EBITDA falls by the same amount. No other assumption changed.
Balance sheet
No new receivables or payables from this alone. The hires don't change AR/AP terms, so working capital is unaffected.
Cash flow
Cash balance falls by the same €13,000/month as the P&L hit, compounding each month. By Q4, cash is down roughly €39,000 against the base case, all else held equal.
The same mechanism is what lets you forecast covenant headroom before a certificate is due, rather than only calculating it after the quarter closes. Seepreparing your first covenant certificatefor the calculation itself.
AHQ Financials builds the linked model for you
Upload your historical financials and AHQ Financials generates a full three-statement budget, covering P&L, balance sheet, and cash flow, with Base, Conservative, and Aggressive scenarios already linked. Change an assumption and every statement updates with it.