Financial model and numbers
Scenario analysis: base, downside and upside
Short answer
Build three scenarios by changing a small set of drivers together: growth, retention, acquisition cost and hiring. The base case is what you plan for; the downside shows you survive if growth halves; the upside shows what more capital could do. Present the cash position and runway under each.
What each scenario is for
| Scenario | Purpose | Typical changes |
|---|---|---|
| Base | The plan you commit to | Your best evidence-based assumptions |
| Downside | Shows you survive | Growth halved, churn higher, costs up 10%, funding delayed |
| Upside | Shows what more capital does | Growth 50% faster, hiring brought forward |
How to build them
- Choose four or five drivers that matter most.
- Set three values for each on the assumptions sheet.
- Add one switch cell that selects the scenario.
- Have every formula read the selected value.
- Compare outputs: revenue, burn, lowest cash point and runway.
What to look at
- Lowest cash point and when it occurs. In the downside, does cash go negative before the next raise?
- Runway. How many months each scenario gives you.
- Break-even month. When, or whether, each reaches it.
- Capital needed. How much more the downside would require.
Plan your response
A downside case is useful only if you know what you would do. Write it down: "If new customers are 30% below plan for three months, we freeze hiring and cut the second city launch." Investors are reassured by founders who have a trigger and a response.
Presenting to investors
- Lead with the base case.
- Say in one line what the downside is and that you survive it: "If growth halves, we still have 14 months."
- Use the upside to explain what a larger round would buy.
Mistakes to avoid
- A downside that is only slightly worse than the base
- Changing revenue without changing the costs that depend on it
- Ten scenarios nobody can keep straight
- An upside presented as the plan
The runway calculator runs a quick three-case view from a few inputs.
Quick answers
How bad should the downside be?
Bad enough to be plausible: growth at half the base rate and costs 10% higher is a reasonable start.
Do I show all three in the deck?
Show the base case in the deck and mention the downside runway. Keep the full scenarios in the model.
Is a scenario the same as a sensitivity?
No. A sensitivity changes one input. A scenario changes several together to describe a different future.