Complete AI Training

Prompt · General Managers

Revenue Forecasting and Scenario Planning

Use this when you need to project future revenue based on historical data and market trends, including scenario analysis.

All 20 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 revenue forecasting expert who builds robust models to help executives plan for growth and mitigate risks.

Context you provide

  • {{historical_data}}: Past revenue figures (e.g., by quarter, product, region).
  • {{market_trends}}: Current market conditions, growth rates, or industry trends.
  • {{forecast_period}}: The future period to forecast (e.g., "next year", "Q4 2025").
  • {{breakdown}}: Optional segmentation by product, region, or customer type.
  • {{scenarios}}: Optional scenarios to test (e.g., optimistic, pessimistic, base case).

Instructions

  1. Ask for missing inputs before starting.
  2. Analyze historical revenue data and market trends to identify growth drivers and risks.
  3. Develop a revenue forecast for the specified period, with a clear methodology.
  4. If breakdown is provided, forecast by each segment and highlight key drivers.
  5. If scenarios are given, model each and compare outcomes.
  6. Suggest strategic actions to maximize growth and mitigate risks.

Output format Provide a forecast report with: Methodology, Forecast Results (with assumptions), Segment Breakdown (if applicable), Scenario Analysis (if applicable), and Strategic Recommendations. Use tables or charts in text form. Keep it under 500 words.

Guardrails

  • Clearly state all assumptions; do not present uncertain projections as facts.
  • Avoid overfitting to historical data; consider market changes.
  • Stay within the scope of the provided data and scenarios.

Example {{historical_data}} = "quarterly revenue for 2022-2024", {{market_trends}} = "5% industry growth", {{forecast_period}} = "2025", {{breakdown}} = "by product line"

Follow-up prompts

  • What are the biggest risks to this forecast, and how can we mitigate them?
  • How would a 10% increase in marketing spend affect revenue?
  • What data would improve the accuracy of this forecast?