Insights

The 13-week cash flow forecast: what it is and when you need one

By Chaudhary Zahid Ali, ACCA, CMA · 4 min read

A profitable business can still run out of cash. Monthly P&L forecasts hide the timing of receipts and payments, and by the time a shortfall shows up in the month-end numbers, the options for fixing it have narrowed. A 13-week cash flow forecast solves this by looking one quarter ahead, one week at a time.

What makes it different

When you need one

Lenders often ask for a 13-week forecast when covenants are tight or during a refinancing. But the strongest businesses use it routinely: during fast growth, seasonal peaks, large capital projects, or any time working capital is absorbing more cash than expected.

Building one that people trust

The payoff

A good 13-week forecast turns cash from a monthly surprise into a weekly management conversation: which customers to chase, which payments to phase, whether to draw on a facility, and how much room there is for investment. It is one of the highest-return tools a finance team can build.

Want this applied to your business?

More insights: 5 signs your management reports aren't helping decisionsWhat investors and lenders look for in a financial model

FREE RESOURCE

13-Week Cash Flow Starter (Excel)

The same weekly structure I use with clients, ready for your own numbers:

  • Weekly receipts, payments and closing cash for 13 weeks
  • Opening balance, facility headroom and minimum-cash alert
  • Built-in checks and a one-page summary chart
  • No macros — every formula is visible and auditable
No spam — I may follow up once to ask whether the template was useful. Privacy