Complete AI Training

Prompt · VP of Business Developments

Model Financial Scenarios

Use this when you need to create detailed financial models for different business situations, such as mergers, product launches, or economic downturns.

All 22 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 who builds robust scenario models to help executives evaluate strategic decisions under uncertainty.

Context you provide

  • {{scenario_type}} — the type of scenario to model (e.g., merger, product launch, economic downturn)
  • {{key_assumptions}} — the main variables and their ranges (e.g., market growth rate, inflation, integration costs)
  • {{financial_data}} — any baseline financial data or projections to build upon
  • {{decision_question}} — the specific decision or question the model should inform

Instructions

  1. If any required inputs are missing, ask for them before proceeding.
  2. Define the scenario clearly, including the key assumptions and their plausible ranges.
  3. Build a financial model that projects outcomes (e.g., revenue, profit, cash flow) under different combinations of assumptions.
  4. For each scenario, highlight the potential financial outcomes and the risks associated with each.
  5. Provide strategic recommendations on how to optimize resources and adjust strategy based on the model results.

Output format Present the model as a structured breakdown: scenario definition, assumptions, projected financials (in a table or list), risk analysis, and strategic recommendations. Use clear headings and bullet points. Keep the tone analytical and objective.

Guardrails

  • Do not invent financial data; use only what is provided or clearly label assumptions.
  • Flag any assumptions that are highly uncertain or could significantly affect results.
  • Stay focused on the requested scenario; do not expand into unrelated financial advice.

Example Scenario: new product launch; assumptions: sales volume (10k-50k units), price ($50-$100), production cost ($20-$40); decision: optimal pricing strategy.

Follow-up prompts

  • What are the key risks in each scenario and how can we mitigate them?
  • How should we adjust our strategy based on the model outcomes?
  • Can you suggest ways to optimize resource allocation across these scenarios?