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.

Work it out with a free toolRunway calculatorMonths of cash left under three scenariosOpen the tool

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

  1. Choose four or five drivers that matter most.
  2. Set three values for each on the assumptions sheet.
  3. Add one switch cell that selects the scenario.
  4. Have every formula read the selected value.
  5. 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.

See where your deck stands before an investor does

Deck Score checks your PDF in your own browser and tells you what to fix first. It is free and nothing is uploaded.