Complete AI Training

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.

All 10 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 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

  1. Ask for the historical data and forecast period if not already provided.
  2. Identify the underlying growth or seasonal pattern in {{historical_data}}.
  3. Project revenue for {{forecast_period}}, adjusting the baseline trend for {{market_conditions}}.
  4. 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?