Building a 12-Month Cash Flow Forecast That Survives Reality

A common shortcut in early-stage forecasting is applying one growth rate — say, 24% annually — evenly across every aging bucket of receivables. It's fast to build and easy to explain in a pitch deck. It's also quietly misleading, because it assumes something that almost never holds true in practice: that collection efficiency stays constant while revenue grows.

What uniform growth actually assumes

When you grow every aging bracket — current, 30-day, 60-day, 90-day, and beyond — by the same percentage, you're implicitly holding your Days Sales Outstanding (DSO) and collection efficiency fixed. In reality, as a business scales, collections often get slower before they get faster: more customers, more invoices, more edge cases, and often a lag before collections processes catch up with growth.

Where this shows up first

The distortion is usually invisible for the first two or three months of a forecast, then compounds. A forecast that assumes flat DSO can overstate near-term cash on hand by a meaningful margin by month nine or ten — exactly when a business is most likely to be relying on that forecast for a hiring decision or a funding conversation.

A more honest approach

Instead of one blended growth rate, we'd suggest:

• Modelling each aging bucket with its own transition probability — the likelihood that a current invoice becomes 30 days late, and so on — rather than assuming static proportions.
• Building in a deliberate DSO drift assumption for growth periods, even a conservative one, rather than assuming collections scale perfectly with revenue.
• Stress-testing the forecast against a slower-collections scenario specifically, so the range of outcomes — not just the base case — is visible to whoever is reading it.

None of this makes a forecast pessimistic. It makes it defensible — which matters far more the moment a lender or investor starts asking how the numbers were built.

← Back to all articles