Cash flow & planningScenario Planning for Small Business: Best Case, Worst Case and the One You Actually Plan For

A text arrives from your biggest client at 4:52 p.m. on a Thursday: "Got a few minutes to talk next week?"

That's it. No emoji, no context. Within about ninety seconds, your brain has run a full financial model. They're leaving. You'll have to cut two people. The office lease was a mistake. By dinner you've lived through a recession that may not exist.

That's scenario planning, sort of. It's just being done at the worst possible time, with no spreadsheet and only one scenario. This article shows the calmer version: how to build a few cases on paper, what to change in each, and how to turn them into decisions you make before the text arrives.

What scenario planning finance actually looks like

In practice, scenario planning finance for a small business is a forecast with a few switches on it. You start from your best current estimate of the next 12 months, then flip a handful of assumptions to see what happens to profit and cash.

Most owners need three cases:

• Base case: what you actually expect. This is the one you plan around.
• Downside: a realistic bad outcome, not a meteor strike. Lose your largest customer, or see sales drop 15%.
• Upside: a realistic good outcome, such as winning the big contract you're bidding on.

The base case usually comes from your rolling forecast, which keeps a 12-month outlook current every month. Scenarios are variations on that file, not a separate project.

Pick drivers, not line items

A what if analysis for a business only works if you change the things that actually move the numbers. Three to five drivers is plenty:

1. Revenue from your top one or two customers
2. Average price or average job size
3. Gross margin (revenue minus direct costs, as a share of revenue)
4. Headcount and timing of hires
5. How fast customers pay

Changing the office supplies line in your downside case is like rearranging the spice rack while the kitchen floods. Find the few drivers that carry the weight and leave the rest alone.

A worked example: a 12-person agency and one big client

Take a hypothetical 12-person marketing agency. Here's its base case, monthly:

• Revenue: $150,000, of which $45,000 comes from one client
• Freelancer costs: $15,000, about $6,000 of it on that big client's work
• Payroll: $85,000
• Rent, software and other overhead: $30,000
• Monthly profit: $20,000
• Cash in the bank: $140,000

Downside: the big client leaves with 60 days' notice. Revenue drops to $105,000. The agency stops the $6,000 of freelance work tied to that client, so costs fall to $124,000. Monthly result: a loss of $19,000. With $140,000 in the bank, that's about seven months before cash runs out, with no other changes.

Seven months is enough time to act calmly, but only if the owner starts in month one. The plan might be: pause one open hire, push new-business outreach, and set a rule that if a replacement client isn't signed within 90 days, one role is reduced.

Upside: the agency wins a $30,000-per-month retainer. Sounds simple. But it needs two new hires at roughly $9,000 a month each (salary, employer taxes, benefits), and they start a month before the first invoice gets paid. Month one is an $18,000 cash outflow with no new revenue. Growth spends cash before it brings any in. The upside case puts that on paper, which is handy, because an excited owner tends to skip that part.

To see how far revenue can fall before the agency stops covering its fixed costs, a break-even analysis for small business gives you that floor in one number.

Turn scenarios into triggers

A scenario without a decision attached is just a scary spreadsheet. For each downside, write down:

• The early warning sign (a client's purchase orders slow down, or the sales pipeline drops below a set amount)
• The trigger point (pipeline under $200,000 for two months running)
• The action you'll take (pause hiring, delay a planned equipment purchase, draw on a line of credit)

Deciding this in a calm planning meeting is much easier than deciding it in a parking lot after a bad phone call.

Financial scenario analysis for small business: check the cash side

Profit scenarios tell you whether the year works. Cash scenarios tell you whether the next few months do. A downside that's fine on an annual P&L can still produce one very tight payroll week if a large receivable is late.

For that reason, financial scenario analysis for a small business should include a short-term cash view. The 13-week cash flow forecast is built for exactly this: run your downside through it and look for the lowest balance and the week it happens.

How often to revisit your scenarios

Quarterly is enough for most owners, plus any time something big changes: a large client signs or leaves, a lease comes up, interest rates on your line of credit move. Keep the files simple so updating them is a 30-minute job.

And keep the base case realistic. If the base case assumes everything goes right, your downside is really just your base case, and your upside is a daydream. When decisions start riding on these models (hiring, financing, buying a building), it helps to have someone build and pressure-test them with you. That's a big part of what our fractional CFO services do.