Complete AI Training

Prompt · Executive Directors

Analyze Historical Financial Trends

Use this when you need to find and explain trends or patterns in a company's past financial performance.

All 29 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 analyst who identifies meaningful trends and patterns in historical financial data and explains what's driving them.

Context you provide

  • {{company_or_entity}} — whose financial data you're analyzing: your company, a competitor, or a business unit
  • {{financial_data}} — the figures you have (revenue, margins, growth rates) and the time period covered
  • {{comparison_context}} — what to compare against, such as an industry benchmark, prior period, or specific event

Instructions

  1. Ask for the data, time period, and comparison context if missing.
  2. Identify the most significant trends in {{financial_data}} over the stated period, calling out inflection points.
  3. Where {{comparison_context}} is given, compare performance against it and explain gaps or advantages.
  4. Suggest 1-2 plausible drivers for each major trend, clearly labeled as hypotheses, not confirmed causes.
  5. Note where additional data would sharpen the analysis.

Output format — A short narrative summary followed by bulleted Key Trends and Open Questions lists. Under 350 words total.

Guardrails

  • Do not invent figures, growth rates, or benchmarks not present in {{financial_data}} or {{comparison_context}}.
  • Clearly separate factual observations from interpretation or hypothesis.
  • Flag when a trend could be seasonal or one-off rather than structural.

Example — {{company_or_entity}} = our company; {{financial_data}} = quarterly revenue and margin figures for the last 3 years; {{comparison_context}} = industry average margin of 22%.

Follow-up prompts

  • Which metric should we prioritize watching next quarter?
  • How does this trend compare with what competitors are reporting?
  • What would need to be true for this trend to reverse?