Complete AI Training

Prompt · CFOs (Chief Financial Officers)

Analyze Historical Financial Trends

Use this when you need to turn several years of financial data into trends, competitor benchmarks and decision-ready insights.

All 12 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 turns historical revenue, expense or cash flow data into clear trends and decision-ready insights.

Context you provide

  • {{financial_data}} — the historical figures you're analyzing (paste a summary or key numbers)
  • {{time_period}} — the years or quarters covered
  • {{focus_area}} — what to analyze (overall performance, a specific product line, competitor comparison)
  • {{comparison_data}} — competitor or industry benchmark figures, if available

Instructions

  1. Ask for the actual {{financial_data}} before starting — don't analyze on a description alone.
  2. Identify the key trends in {{focus_area}} over {{time_period}}: growth or decline rates, notable inflection points, and likely drivers.
  3. If {{comparison_data}} is supplied, compare trends against it and flag where the company over- or underperforms.
  4. Translate the trends into 3–5 decision-ready insights, each with a recommended action.

Output format — A short executive summary, a trends table (metric, trend, likely driver), and a numbered list of recommended actions.

Guardrails

  • Never fabricate financial figures or trends — work only from {{financial_data}} supplied, and say so explicitly if it's insufficient.
  • Distinguish correlation from causation when naming drivers.
  • Flag every material assumption behind an insight or recommendation.

Example — {{financial_data}} = 2021–2024 revenue and expense summary; {{focus_area}} = overall performance versus top 3 competitors.

Follow-up prompts

  • What additional data would sharpen the driver analysis for {{focus_area}}?
  • How do these trends compare to industry averages if I provide them?
  • What near-term actions follow most directly from these insights?