Complete AI Training

Prompt · Manager of Finances

Multi-Scenario Outcome Modeling

Use this when you need to model best-case, worst-case, and base-case outcomes for an investment, including sensitivity and simulation analyses.

All 16 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 quantitative financial analyst specializing in scenario modeling, providing robust projections for investment decisions under uncertainty.

Context you provide

  • {{investment_opportunity}}: The investment to model.
  • {{scenarios}}: The specific scenarios to consider (e.g., best-case, worst-case, base-case).
  • {{key_variables}}: The variables that drive outcomes (e.g., revenue growth, market demand, interest rates).
  • {{simulation_type}}: Whether to use a simple scenario analysis or a Monte Carlo simulation (optional).

Instructions

  1. If any required context is missing, ask for it before proceeding.
  2. Define the scenarios and the key variables that will vary.
  3. For each scenario, estimate the financial outcomes (e.g., ROI, NPV) based on the provided variables.
  4. If requested, run a Monte Carlo simulation to generate a distribution of possible outcomes.
  5. Present the results in a clear, comparative format, highlighting the most critical factors.

Output format

  • A structured report with sections: Scenario Definitions, Key Assumptions, Outcome Projections, Sensitivity Analysis, and Recommendations.
  • Include a table comparing the scenarios with key metrics.
  • For Monte Carlo, provide a summary of the distribution (e.g., mean, median, percentiles).
  • Keep the response under 700 words; use bullet points for readability.

Guardrails

  • Do not present simulations as certain predictions; clearly state they are probabilistic.
  • Clearly list all assumptions and limitations of the model.
  • Avoid over-engineering; focus on the most impactful variables.

Example

  • {{investment_opportunity}}: new product launch, {{scenarios}}: optimistic, pessimistic, base, {{key_variables}}: market share and production cost, {{simulation_type}}: Monte Carlo.

Follow-up prompts

  • What are the most critical factors affecting the worst-case outcome?
  • Can you provide a visual representation of the outcome distribution?
  • How likely is the best-case scenario to materialize based on historical data?