TOOLS CLUB TEMPLATE

Scenario Planning Template

"What happens if revenue drops 20%?" or "What if we win that big contract?" are exactly the questions a single-scenario budget can’t answer. This template models best case, base case, and worst case outcomes together, so you can see the real range of what’s possible before it happens.

Join the Tools Club — $7/mo Already a Member? Log In

Included in the $7/mo Tools Club · Works in Excel or Google Sheets · Includes a built-in AI prompt

Who this is for

Business owners preparing for genuine uncertainty ahead
Anyone deciding whether a big bet (hiring, expansion, a new product) is affordable across different outcomes
Businesses preparing scenario analysis for an investor or board
Owners wanting to know their downside risk, not just their upside potential

What's included

Best case, base case, and worst case columns for revenue and expenses
Automatic net income and cash impact per scenario
Space to document the specific assumptions driving each scenario
Built-in AI prompt to identify your biggest scenario-to-scenario risk factor

Why use a template instead of starting from scratch?

Planning around a single projected outcome means you’re unprepared the moment reality lands somewhere else — which it almost always does. Modeling multiple scenarios side by side shows you the real range of outcomes and, critically, whether your worst case is something the business could actually survive.

How to Use This Template

Download and open in Excel or Google Sheets

Requires a Tools Club membership — log in first to access the file.

Build your base case using realistic, grounded assumptions

This is your most-likely-outcome scenario, same as a standard forecast.

Build a best case scenario

What would need to happen, and what would the financial result look like?

Build a worst case scenario

What’s a realistic downside, and could the business survive it?

Run the built-in AI prompt across all three scenarios

Attach the saved file to ChatGPT or Claude and ask which single factor drives the biggest difference between your scenarios.

Built-in AI prompt

Once you've filled this template in, it includes a ready-to-use prompt at the bottom of the sheet. Attach your saved file to ChatGPT, Claude, or any AI chat tool and paste it in — you'll get plain-English feedback on which single assumption or factor drives the biggest difference between your best and worst case scenarios, and whether the worst case is survivable, no accounting background required.

Common Mistakes to Avoid

Making the worst case unrealistically mild

A worst case that isn’t actually challenging defeats the purpose — it should represent a genuine, uncomfortable but plausible downside.

Making the best case pure fantasy

The best case should still be grounded in something plausible (a specific known opportunity), not just an aspirational number.

Only building the scenarios once and never revisiting

As circumstances change, the scenarios should be updated — a worst case built a year ago may no longer reflect the actual current risks.

Not acting on what the worst case reveals

If the worst case scenario shows the business couldn’t survive it, that’s information meant to drive a decision — building a cash reserve, securing a credit line — not just a number to file away.

Frequently Asked Questions

How is scenario planning different from a regular forecast?

A regular forecast typically models one expected outcome. Scenario planning deliberately models multiple distinct outcomes — best, base, and worst case — to understand the real range of what could happen.

How many scenarios should I model?

Three (best, base, worst) is a common, manageable standard — more scenarios can add value for very complex decisions but also add complexity to maintain.

What should trigger building a new scenario analysis?

A major decision under uncertainty — a big hire, a new market, a large investment — or simply a regular planning cadence (like annually) are both good triggers.

Is this included in the free plan?

No, this is a Tools Club template. iLuvAccounting also has a free Break-Even Calculator, useful input for building your worst case revenue assumptions.

What should I do if my worst case scenario shows the business couldn’t survive?

Treat that as a genuine warning sign — it usually points toward building a larger cash reserve, securing a credit line in advance, or reconsidering a planned expense before committing to it.

Should scenario planning include cash flow, not just profit?

Yes — a scenario can look survivable on the P&L but still create a cash crunch depending on timing, so modeling the cash impact of each scenario matters as much as net income.

How often should scenarios be revisited?

At least annually, and any time a major assumption underlying them changes significantly.

Related Templates

Related Resources

Want the Full Template Library?

70+ editable templates, each with a built-in AI prompt. $7/month, cancel anytime.

Join the Tools Club