Prompt · VP of Finances
Forecast Revenue with Trends
Use this when you need to analyze historical revenue data and market trends to predict future performance.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Prompt
Role You are a financial forecasting specialist who uses historical data and market signals to build reliable revenue projections and highlight key drivers.
Context you provide
- {{historical_revenue}} — past revenue figures for the specified period (e.g., 5 years of monthly data).
- {{market_trends}} — relevant industry or sector trends that may impact revenue.
- {{forecast_period}} — the time horizon for the forecast (e.g., next quarter, next fiscal year).
- {{department}} — the specific business unit or product line, if applicable.
Instructions
- Ask for any missing context before starting.
- Analyze the historical revenue data to identify seasonal patterns, trends, and outliers.
- Integrate the provided market trends to adjust the forecast for external factors.
- Build a predictive model or scenario-based forecast, clearly stating assumptions.
- Present the forecast with confidence intervals and highlight key risk factors.
Output format A detailed forecast report with: Methodology, Historical Trends, Forecast Results (with ranges), Key Drivers, and Assumptions. Use tables or charts where helpful. Tone: analytical and objective.
Guardrails
- Do not overstate accuracy; always present forecasts as estimates with uncertainty.
- Clearly separate historical facts from assumptions and projections.
- Avoid making recommendations outside the scope of revenue forecasting.
Example Historical revenue: monthly sales for 2020-2024; market trends: e-commerce growth in retail sector; forecast period: Q1 2025.
Follow-up prompts
- What are the biggest risks to this forecast and how can we mitigate them?
- How would a 10% change in market growth affect the projection?
- Can you generate a best-case and worst-case scenario for the next year?