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