Cash Flow Scenario Planning for Best and Worst Case Quarters

Most UK business owners plan for exactly one version of the future: the one where their current sales pipeline converts perfectly and every client pays within 30 days. In reality, the future is a spectrum of probabilities.

Cash flow scenario planning (also known as "What-If Analysis") is the process of mathematically modeling different outcomes to see how they impact your 13-week runway. It turns anxiety into a set of actionable numbers.

Modeling the Worst Case (The Doomsday Scenario)

Every agency or service business has a breaking point. Your goal is to find yours before HMRC does. In a Doomsday scenario, you should model three variables simultaneously:

1. The Churn Event: Your top revenue-generating client cancels their contract without notice.
2. The Liquidity Gap: Your remaining clients shift their payment behavior from 30 days to 60 days.
3. The Tax Spike: A surprise HMRC tax liability lands in the same month as a major payroll run.

By plugging these into a 13-week liquidity model, you can identify exactly which week your bank balance hits £0. This number tells you your "Absolute Buffer"—the minimum amount of cash you must keep in your holding account at all times.

The Best Case Scenario (The Growth Trap)

It sounds counterintuitive, but rapid growth can bankrupt a company faster than a slow decline. This is known as the Growth Trap.

If you close three massive deals this month, you likely need to hire new staff or buy new equipment immediately. You incur the OPEX (Operating Expense) today, but you won't see the revenue for 60 to 90 days. If your bank account can't bridge that 90-day gap, your "Best Case" sales month becomes your "Worst Case" liquidity event.

Effective cash flow scenario planning for growth allows you to see if you have the "Dry Powder" required to fulfill the new contracts without collapsing your baseline operations.

How to Build a Scenarios Matrix

You don't need complex FP&A software to do this. In fact, most SaaS forecasting tools are too rigid for scenario planning. A master-level spreadsheet is superior because you can "duplicate and destroy."

• Duplicate Your Base Forecast: Create a separate tab for each scenario.
• Adjust Timing, Not Totals: Often, the "Total Revenue" is fine, but the *timing* is the killer. Move a £20k payment three weeks later and watch the ripples.
• Identify Trigger Points: Define "If/Then" actions. (e.g., "If the Worst Case lands, we pause all director drawings until Week 10.")

Scenario Planning FAQ