Small Business Scenario Planning Spreadsheet

Most small business forecasting stops at one number: "we think revenue will be around $X next year." That single figure feels precise, but it's really a guess dressed up as a plan, and it gives you nothing to compare against when reality lands somewhere else — which it almost always does. Scenario planning replaces the single guess with a small, deliberate set of named cases — typically conservative, base, and growth — each built from the same starting numbers and the same formula, just with different assumptions about the handful of things that actually move your profit.

The point isn't to predict the future more accurately. It's to know, before a slow quarter or a strong one actually happens, roughly what your numbers would look like either way — so the decisions that depend on those numbers get made in advance, not in a scramble.

Best, base, and worst case — what each one is actually for

Three scenarios cover most small businesses well:

• Base case. Your best honest estimate of what actually happens if nothing unusual occurs — typically your trailing actuals, projected forward with no adjustment. This is your working assumption, not a hope.
• Conservative case. Revenue softer than base, costs a little higher — the scenario that answers "can I still operate if things get harder than expected." This is the one that matters most for any decision involving a new fixed cost, because it's the floor you're actually committing to cover.
• Growth case. Revenue stronger than base, usually with a deliberate cost added on top — a new hire, new equipment, more marketing spend — because growth rarely arrives for free. This scenario answers "if this goes well, what does it actually cost me to capture it."

More than three or four scenarios tends to blur together and stop being useful — the value comes from being able to hold all of them in your head at once and compare them side by side, not from modeling every possible combination of inputs.

Which drivers actually deserve a scenario

Not every input needs to vary between scenarios — most of your cost base is genuinely stable, and treating every line item as uncertain just adds noise. Focus on drivers that are both meaningfully uncertain and meaningfully large:

Everything else — your existing rent, your existing software subscriptions, costs that don't change meaningfully between scenarios — stays as-is in every case. Scenario planning works best when it isolates the few things that are genuinely uncertain, not when it re-litigates your entire cost structure three times over.

A worked example

Say a business has $180,000 in trailing 12-month revenue and $130,000 in trailing 12-month expenses. Three scenarios, each applying its own revenue change, expense change, new recurring cost, and one-off investment to that same baseline:

Every figure in that table follows from the same formula, run three times: projected revenue is trailing revenue times one plus the revenue change; projected expenses is trailing expenses times one plus the expense change, plus twelve months of any new recurring cost, plus any one-off investment; profit is projected revenue minus projected expenses; margin is profit divided by revenue; and break-even monthly revenue is projected annual expenses divided by twelve. Nothing in that chain is a guess — it's the same arithmetic three times over with three different sets of inputs.

Notice what the table actually shows, beyond the headline profit numbers. Margin barely moves between base and growth — 27.8% down to 27.3% — because the new recurring cost and one-off investment eat into most of the extra revenue's advantage. That's a real finding, not a coincidence: it's exactly the kind of thing a single forecast would never surface, because a single forecast doesn't have anything to compare itself against.

How a scenario actually changes a decision

The number itself isn't the point — what you do differently because of it is. A few concrete examples:

• Hiring. If a new hire's fully loaded cost still leaves your conservative case profitable, that's a real answer to "can I afford this," grounded in your worst realistic case rather than your best hoped-for one. If it only works in the growth case, you know the hire is a bet on growth actually happening, not a safe move regardless.
• Pricing. If your conservative case shows a break-even point that your base-case revenue barely clears, that's a signal a price increase or a cost cut needs to happen independent of which scenario plays out — the margin is too thin even in the case where nothing goes wrong.
• Runway. If your conservative case still covers fixed costs for the year, you have real breathing room. If it doesn't, you know exactly how much cash cushion or revenue growth you need before it does — a specific number to work toward, not a general sense of "we should probably grow."

In each case, the scenario turns a decision that would otherwise ride on optimism into one grounded in the range you already worked out. That's the entire value of building three cases instead of one: by the time the actual decision arrives, you're checking it against a number you already have, not producing one under pressure.

How this differs from a budget or a cash flow forecast

A budget commits to a single plan for the year, phased by month, and gets compared to actuals as the year plays out — see our guide on annual budget planning for that process. A cash flow forecast projects your actual bank balance based on when money is expected to move, usually rolling forward across the next 12 months — our cash flow forecast guide covers building one. Scenario planning does neither of those jobs. It doesn't commit to a plan and it doesn't track timing — it compares two or three deliberately different versions of the same year so you know the range you're planning inside of. A business making real decisions benefits from having all three, ideally built from the same underlying trailing numbers so they don't quietly drift apart from each other.

If you're still working out what to actually charge before you can model revenue scenarios with any confidence, the freelance rate calculator is a starting point for putting a real number on the income side.

What good scenario planning looks like

A scenario plan worth trusting starts from real trailing revenue and expenses, not a guess. It varies a small number of drivers that are genuinely uncertain and genuinely large, rather than re-modeling every cost line three times. It's limited to three or four named cases you can actually hold in your head at once. And it exists to answer a specific decision — a hire, a price change, a purchase — not to produce a number for its own sake. None of that requires anything exotic; it requires the same profit formula, run a handful of times, with inputs you can actually defend.