How to build a 13-week cash flow forecast for uncertain times

By Dr Lewis Haydon · From the Mentor Business Podcast, episode 128

A 13-week cash flow forecast is a week-by-week view of the next quarter: what’s coming in and what’s going out, like a mini P&L for every week. It’s the simplest tool an owner has for staying calm when taxes, costs or the economy change, because it turns “what if?” into numbers you can act on.

On the Mentor Business Podcast, business owner and mentor Dr Lewis Haydon makes the point that the owners who come through uncertain times aren’t the ones who guessed right. They’re the ones who had their numbers ready. Here’s his method.

Why use a 13-week cash flow?

Thirteen weeks is one quarter. It’s long enough to see trouble coming and short enough to act on. It also lines up with the 90-day plan Dr Lewis Haydon builds with every client each quarter, alongside a 12-month plan once a year, so your cash view and your plan run on the same clock.

It matters most when the outlook is uncertain. When there’s uncertainty, decisions don’t get made, and money stops flowing from larger companies down to the small businesses that supply them. A weekly cash view lets you see that coming instead of feeling it when payroll is due.

How do you build a 13-week cash flow forecast?

Build three versions, not one: the good, the bad and the ugly. Use a simple spreadsheet, put in what you expect to come in and go out each week, then change the assumptions for each version. The ugly one is the one that matters most: are you still okay if the worst happens?

  • The good: things go better than expected, and you can actually flourish.
  • The bad: things are tougher, but not a disaster.
  • The ugly: your worst realistic case. If you can still cover payroll and suppliers here, you can make decisions with confidence.

AI tools such as ChatGPT, Perplexity and Claude can help you set the sheet up and talk through the assumptions. They’ll give you good advice. What they won’t give you is the time to do it.

How often should you update it?

Every week. A cash flow forecast you build once and never open again is just a document. Put a recurring slot in your diary to revisit all three versions, so it becomes a system rather than a one-off reaction to bad news.

Dr Lewis Haydon is blunt about why this matters: most owners get pulled into the “tornado” of the week, with the loudest customer, the suppliers to pay and the next payroll. The diary slot is what protects the planning time. None of it works unless your behaviour changes.

What should you do with the ugly version?

Use it to make the decision you’ve been putting off. If the ugly version still works, the waiting is costing you more than the risk. If it doesn’t, you know exactly what has to change before you commit.

This is where scenario planning pays off. Dr Lewis Haydon plans for scenario A and scenario B with every client: this is what great looks like, this is what good looks like, and are we still okay if the worst happens? He pairs it with a SWOT analysis every 90 days, because the threats and opportunities keep changing.

Why does your mood matter as much as your numbers?

Because a leader’s emotions spread through the team. Dr Lewis Haydon points to Barbara Fredrickson’s broaden-and-build theory: the more negative emotion there is, the narrower the range of thoughts and actions people see, and the fewer decisions get made. A steady leader with a clear forecast keeps the team, and customers, making decisions.

Your next step

This week, build or update your 13-week cash flow in three versions, run the ugly one, and make the decision you’ve been holding off.


For the owner’s version of this, written for UK business owners around the Budget, read Dr Lewis Haydon’s article on lewishaydon.com. To go deeper on running and growing your business, watch Dr Lewis Haydon’s shows on MentorBusiness.com. And if you’d like to talk it through with him, book a virtual coffee.

Follow me