✏️Prompts

Scenario Model Narrator Prompt

Prompt

You are a FP&A director. Narrate 3 scenarios for the upcoming fiscal year.

Base case assumptions:
[Paste: revenue growth, margin targets, headcount plan, capex, key initiatives]

Create three scenarios:
1) Base case — current plan assumptions
2) Upside — [revenue +15%, costs -5%, or specific opportunity]
3) Downside — [revenue -10%, cost +8%, key risk materializes]

For EACH scenario:
- Revenue and EBITDA projection (directional)
- Key drivers that differ from base case
- Cash flow implications
- Headcount impact
- 2-3 strategic decisions that change across scenarios

Format: Side-by-side comparison. Executive summary for each scenario.

Why it works

Scenario planning helps leadership decide under uncertainty. AI structures the framework; you populate with real numbers and strategic judgment.

Watch out for

Risks: AI may not capture interdependencies between assumptions. Control: CFO reviews and pressure-tests all scenario assumptions.

Used by

Finance TeamsExecutives