What Is Scenario Analysis in Business Planning?
Scenario analysis is a way of testing a plan against several possible futures, such as a good case, an expected case and a poor case, to see how each would change profit and cash. It helps you decide before the outcome is known, rather than react after.
What is scenario analysis in finance?
In finance, a scenario is a consistent story about what might happen, turned into numbers. You change a small set of key assumptions, such as sales volume, prices, a customer loss or a cost increase, and recalculate your forecast to see the result. The set of results shows the range you might face.
It is not prediction. It does not say which scenario will happen. It shows how exposed the business is if one does.
Scenario analysis vs forecasting
| Item | Forecast | Scenario analysis |
|---|---|---|
| Question | What do we expect to happen? | What happens if X changes? |
| Number of outcomes | One main view | Several linked views |
| Use | Plan and track | Test decisions and risk |
| Update | Monthly or weekly | When a decision or risk appears |
The two work together. The base case of your scenarios is usually your forecast. For building the forecast first, see how to build a financial forecast.
How do you run a scenario analysis?
- Start from a forecast you trust, built on current records.
- Pick the few assumptions that matter most. Often that is sales, customer payment timing, a major cost, or a hire.
- Define scenarios. Keep to three at first: base, better and worse.
- Change only the chosen assumptions and let everything else flow through the model.
- Record the results, especially closing cash and profit.
- Decide on triggers. For example, "if sales fall below this level for two months, you pause that purchase."
Scenario analysis example
The figures below are invented to show the method.
Example (illustrative numbers only):
| Item | Worse | Base | Better |
|---|---|---|---|
| Monthly sales | $34,000 | $40,000 | $44,000 |
| Monthly costs | $36,000 | $36,000 | $37,000 |
| Monthly profit | minus $2,000 | $4,000 | $7,000 |
| Opening cash | $10,000 | $10,000 | $10,000 |
| Customers pay in | Six weeks | Four weeks | Four weeks |
| Cash after six months, if cash moves with profit | minus $2,000 | $34,000 | $52,000 |
Even in this made-up case, the useful result is seeing how a loss drains cash. The worse case loses money every month, and over six months that loss is larger than the opening cash, so cash ends below zero. Slower customer payment would push cash lower still. That tells you what to protect.
How is scenario analysis different from sensitivity analysis?
Sensitivity analysis changes one assumption at a time to see how much the result moves, for example sales up or down a little. Scenario analysis changes several assumptions together into a connected story, such as "a big customer leaves and the remaining ones pay slower". Sensitivity tells you which assumption matters most. Scenarios tell you what a realistic bad (or good) period would feel like. Businesses can use both, starting with sensitivity to find the key drivers and then building scenarios around them.
Where does scenario analysis help a small business?
- Hiring: can the business carry the new salary if sales are flat?
- Pricing: what if a price rise loses some customers?
- Large purchase: does cash stay above your minimum if a customer pays late?
- Seasonal swings: how thin does the slow season get?
- Lender conversations: showing you have thought about the poor case can be part of funding readiness.
Cash is often a useful thing to scenario test. Pair it with the cash flow forecast template or the weekly thirteen-week cash flow forecast.
What about scenario analysis in capital budgeting?
In larger organizations, scenario analysis is also used to test investment projects: you estimate returns under different assumptions and see how sensitive the result is. The same idea applies at small scale, for example to a new vehicle or a second location. This page covers the general concept only and does not advise on any particular investment.
Who should be in the room?
Scenarios are most useful when the person who knows the sales pipeline, the person who knows the costs and whoever owns the numbers agree on the assumptions together. In a small business that may be one owner and a bookkeeper. Write the assumptions down and date them, so that later you can see which ones turned out to be wrong.
What are the limits of scenario analysis?
- The scenarios are only as good as the assumptions. Records that are out of date give out-of-date answers.
- Too many scenarios create noise. Three is usually enough.
- It cannot foresee surprises you did not think of.
- It takes time to maintain. If it is never updated, it stops being useful.
When it is not worth doing
If the business is simple, steady and has a large cushion, a basic forecast may be enough. If your numbers are not reliable, fix the records before modeling alternatives. See how to improve cash flow for simpler steps.
Where English Oak Financial fits
Forecasting and scenario planning are part of our fractional CFO service, under forecasting and cash flow planning. It depends on accurate monthly records, which our bookkeeping service covers. See what we do, pricing and how to manage cash flow in a small business.
English Oak Financial does not prepare tax returns, audit accounts or give investment advice. This page is general information, not tax or investment advice.
Need this done for you? See our Fractional CFO & Advisory service, or pricing. English Oak Financial does not prepare tax returns, perform audits or give investment advice. This guide is general information, not tax, legal or investment advice.
Related pages
Common questions
What is scenario analysis?
It is testing a plan under several possible outcomes, such as better, expected and worse, to see the effect on profit and cash.
What is the difference between scenario analysis and forecasting?
A forecast gives your main expectation. Scenario analysis asks what happens if key assumptions change.
How many scenarios should I use?
Start with three: base, better and worse. More than that usually adds confusion rather than insight.
What is scenario analysis in finance used for?
Testing decisions and risk, such as hiring, pricing, large purchases and funding needs, before committing.
Can I do scenario analysis in Excel?
Yes. Keep your assumptions in one block, copy the forecast for each scenario, and change only the assumptions you are testing.
Talk it through with us
Schedule a free introductory consultation. No surprise bills. No unnecessary services.
Schedule Consultation