Every business owner has asked the question. Usually at eleven o’clock at night, looking at a spreadsheet, trying to figure out what happens to the business if the biggest client does not renew. Or if the new product launch is delayed by six months. Or if interest rates move against them.
The problem is that most businesses do not have a structured way to answer it. The owner either has a rough mental model, which may or may not be calibrated to reality, or they commission a financial model that takes two weeks to build, produces ninety tabs of analysis, and is immediately too complicated to use when the assumptions need updating.
Scenario planning does not have to be either of those things. Done well, it is a simple, repeatable process that answers the “what if” question clearly enough to make better decisions, without requiring a finance doctorate or a team of analysts.
This article explains how to build three practical scenarios, base, optimistic, and pessimistic, in a straightforward Excel model, and how to connect them to the decisions that actually matter.
Why Three Scenarios and Not One
The instinct in most business planning is to produce a single forecast: the base case, the most likely outcome, the plan. This is natural and understandable. Decisions are made against a single plan, and multiple scenarios can feel like an admission that you do not know what is going to happen.
But that is exactly the point. You do not know what is going to happen. Neither does anyone else. A single-point forecast disguises uncertainty rather than quantifying it, which means the business has no framework for understanding how robust its financial position is to variation in outcomes.
Three scenarios make the uncertainty explicit and useful. The base case represents the most likely outcome given current information. The optimistic case represents a materially better outcome, not the best conceivable outcome, but a realistic good case. The pessimistic case represents a materially worse outcome, not a disaster scenario, but a realistic bad case that the business could actually face.
The gap between the optimistic and pessimistic cases is the range of outcomes the business needs to be prepared for. If the business can sustain the pessimistic case without a liquidity crisis, the financial position is robust. If the pessimistic case produces a cash shortfall, the business needs either a financial cushion or a contingency plan, and knowing that in advance is significantly more valuable than discovering it when the pessimistic case becomes reality.
The Architecture of a Simple Scenario Model
A well-designed scenario model has three components: an assumptions section, a calculation engine, and an outputs section. Keeping these three elements separate is the most important structural decision you can make, because it determines whether the model can be updated quickly and reliably, or whether every assumption change requires hunting through formulas across multiple tabs.
The assumptions section contains only the input variables: the numbers that change between scenarios and that drive the financial outputs. Everything else in the model should be a formula that references these inputs, never a hardcoded number. If you find yourself typing a revenue figure directly into a P&L row, you have broken the model architecture.
The calculation engine translates the assumptions into financial outputs using formulas. The P&L, balance sheet, and cash flow all live here. Nothing in this section should be changed manually. It should update automatically when the assumptions change.
The outputs section presents the key results in a format that is readable by non-finance stakeholders. A one-page summary showing the three scenarios side by side, with the key metrics highlighted, is more useful in a management discussion than a detailed three-statement model.
Step 1: Identify Your Key Assumptions
The first task in building a scenario model is identifying the three to four assumptions that have the most impact on the financial outcome. In most businesses, a small number of variables drive the vast majority of the P&L variance. Identifying those variables correctly is more important than building a comprehensive model.
For a typical Swiss SME, the high-impact assumptions are usually:
Revenue volume or growth rate. How many units are sold, how many projects are completed, or what percentage growth is achieved relative to the prior year. This is almost always the single largest driver of outcome variation.
Gross margin percentage. What percentage of revenue remains after direct costs. A margin compression of two percentage points on a CHF 10M business is CHF 200K of EBITDA impact. Margin is sensitive to pricing decisions, input cost changes, and product or client mix.
Key cost line that is variable or uncertain. This might be personnel costs if headcount plans are uncertain, or a major supplier contract if pricing is under negotiation, or marketing spend if the investment level has not been finalised.
A specific business event with binary or probabilistic outcomes. A contract renewal, a product launch, a market entry, a regulatory change. These are the events that most obviously warrant scenario analysis because their outcome is genuinely uncertain and their financial impact is material.
For most businesses, modelling these three to four variables across three scenarios captures eighty to ninety percent of the meaningful outcome variation. Adding more variables beyond that rarely changes the conclusion and significantly increases the complexity of maintaining the model.
Step 2: Define the Three Scenarios
With the key assumptions identified, define the values for each scenario. Be specific. Vague scenarios, such as “things go well” or “conditions worsen”, are not useful for financial planning. Specific scenarios are.
Base case: The most likely outcome based on current information and recent trends. Not optimistic, not pessimistic. The best current estimate of where the business will land if nothing unusually good or bad happens. Revenue growth in line with recent performance, margins at their current run rate, costs as budgeted, key events playing out as currently expected.
Optimistic case: A realistically good outcome, not a fantasy. What does the business look like if the key contract renews at a good rate, the new product gains traction faster than expected, and margins benefit from a mix shift toward higher-value business? Define each assumption specifically: revenue growth rate, margin percentage, headcount. Avoid the temptation to make everything better simultaneously, because that produces an unrealistic scenario. Pick the two or three things that would most plausibly go well and model those.
Pessimistic case: A realistically bad outcome. What does the business look like if the key contract is lost, the product launch is delayed, and one major cost line runs over budget? Again, be specific and be realistic. The pessimistic case should be something that could actually happen, not the worst case from a movie. It should also be survivable, because if it is not, the scenario analysis will immediately shift from planning to crisis management and the model loses its utility as a planning tool.
Step 3: Build the P&L and Cash Flow for Each Scenario
With the assumptions defined, translate them into financial outputs for each scenario. The model should produce, at minimum, a P&L and a monthly cash flow for each of the three cases.
The P&L translation follows the same logic as the budget build. Revenue is calculated from the scenario revenue assumption. Gross margin is applied to revenue. Personnel costs are calculated from the headcount assumption. Other operating costs are held at budget unless a specific assumption says otherwise. EBITDA, depreciation, and net profit follow.
The cash flow is where the scenario analysis often produces its most important insights. A business can be profitable in all three scenarios but cash-negative in the pessimistic case, because the lower revenue produces a working capital compression or because investment commitments made in the base case cannot be deferred. Seeing that cash outcome clearly and in advance is the primary practical value of scenario planning for most businesses.
The cash flow model for each scenario should show the monthly closing cash position throughout the projection period. If any month in the pessimistic case shows a negative cash position or a position below a minimum operating buffer, that is the key finding of the scenario analysis. It means the business has a specific vulnerability that needs a specific response: either a financing arrangement, a cost reduction plan, or a contingency trigger that is agreed in advance.
Step 4: Use the Scenarios to Make Decisions
Scenario models that sit in a folder and are reviewed once a year are not scenario planning. They are scenario documentation. The purpose of the model is to inform decisions, and that purpose is only fulfilled if the scenarios are actively used.
The practical applications are straightforward.
When evaluating a significant investment (new equipment, a new hire, a market expansion), run it through the model in all three scenarios. Does it make financial sense in the base case? Does it still make sense in the pessimistic case, or does it tip the cash position into difficulty? The answer shapes not just whether to make the investment but how and when.
When a major assumption changes (a contract outcome becomes clear, a market shift emerges), update the relevant scenario and produce a new cash flow projection. How has the range of outcomes changed? Does the pessimistic case now require a response it did not require before?
When presenting to the board or a bank, present the three scenarios rather than a single forecast. This is more credible, not less: it demonstrates that the management team has thought through the range of possible outcomes and has a plan for each one. Banks in particular respond well to scenario analysis because it shows the borrower has considered their exposure under adverse conditions.
Keeping the Model Alive
The most common failure in scenario planning is building the model once and never updating it. A scenario model that was built in October and has not been touched since January is not a planning tool. It is a historical document.
The update discipline is simple. Once per quarter, review the key assumptions in each scenario against what has actually happened and what the current outlook suggests. Update the assumptions where the evidence has changed. Update the output projections. Review the gap between the base case and the pessimistic case. Bring the updated view to the quarterly management discussion.
The model does not need to be rebuilt quarterly. It needs to be recalibrated. If the model architecture is correct, this is an hour of work, not a week.
Need help building or improving your budget process? Book a free 30-minute call to discuss your situation.
Alessandro Ratzenberger is a fractional CFO and business controller based in Zurich, with 15 years of operational finance experience at Dufry Group and Bomi (UPS Group).
