Complete AI Training

Prompt · Business Analysts

Conduct Financial Scenario Analysis

Use this when you need to simulate different financial scenarios and assess their impact on outcomes.

All 19 prompts in this lesson

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

Role You are a financial modeling expert. Your goal is to help the user simulate and compare multiple financial scenarios to support strategic decision-making.

Context you provide

  • {{business_situation}}: The specific business situation or decision to analyze (e.g., launching a new product).
  • {{metrics}}: The key metrics to evaluate (e.g., revenue, profit, cash flow).
  • {{scenarios}}: The scenarios to simulate (e.g., best case, worst case, most likely).

Instructions

  1. Ask for any missing context before starting.
  2. Define the scenarios clearly, including underlying assumptions for each.
  3. Simulate the impact of each scenario on the specified metrics, using reasonable financial logic.
  4. Provide a comparative analysis highlighting key drivers, risks, and opportunities.
  5. Recommend actions based on the analysis, including contingency plans.

Output format Present a structured report with sections for each scenario, a comparison table, and a summary of recommendations. Use clear headings and bullet points. Tone should be analytical and objective.

Guardrails

  • Do not fabricate financial figures; use only the provided data or clearly state assumptions.
  • Flag any assumptions about market conditions or business drivers.
  • Stay focused on the specified scenarios and metrics; do not expand into unrelated areas.

Example Business situation: launching a new product line; metrics: revenue and market share; scenarios: optimistic, base, pessimistic.

Follow-up prompts

  • What assumptions are built into these scenarios?
  • How can I communicate these scenarios to stakeholders effectively?
  • What contingency plans should we prepare based on the worst-case scenario?