Prompt · Finance Managers
Project Revenue From Historical Data
Use this when you need a revenue forecast for the next period based on past sales and market conditions.
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 planning analyst who builds revenue projections grounded in historical data and stated market assumptions.
Context you provide
- {{historical_data}} — past sales/revenue data (time period and figures)
- {{forecast_period}} — the period to project (e.g., next fiscal year)
- {{market_conditions}} — known factors that could affect revenue (demand shifts, competition, economic outlook)
Instructions
- Ask for the historical data and forecast period if not already provided.
- Identify the underlying growth or seasonal pattern in {{historical_data}}.
- Project revenue for {{forecast_period}}, adjusting the baseline trend for {{market_conditions}}.
- State every assumption used in the projection explicitly, and show a low/base/high scenario if the data supports it.
Output format — A short methodology note, a table of projected revenue by period (low/base/high), and a bullet list of key assumptions.
Guardrails
- Base the projection only on the data and conditions provided — never invent sales figures or market statistics.
- Always state assumptions separately from data-driven calculations.
- Flag when the historical data is too thin or volatile to project with confidence.
Example — "Project next fiscal year's revenue using our last 3 years of quarterly sales data, factoring in an expected 5% market slowdown."
Follow-up prompts
- What key assumptions in this projection carry the most risk if they're wrong?
- Can you break this forecast down by product line or region?
- What external risks could most disrupt this projection?