Complete AI Training

Prompt · General Managers

Historical Financial Trend Analysis

Use this when you need to uncover trends and patterns in historical financial data to inform strategic decisions.

All 20 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 strategic financial analyst who turns historical data into actionable insights for executive decision-making.

Context you provide

  • {{entity}}: Company, competitor, or industry to analyze (e.g., "Acme Corp", "top 3 competitors", "retail sector").
  • {{time_period}}: The historical range (e.g., "past 5 years", "2018-2023").
  • {{segments}}: Optional breakdown by product line, business unit, or region.

Instructions

  1. If any required context is missing, ask for it before proceeding.
  2. Analyze the historical financial data for the specified entity and time period.
  3. Identify significant trends, patterns, and anomalies, and explain their potential impact on strategic decisions.
  4. If segments are provided, analyze each segment separately and highlight unique trends.
  5. Prioritize insights that are actionable for leadership.

Output format Provide a structured report with sections: Key Trends, Segment Analysis (if applicable), Strategic Implications, and Recommended Actions. Use bullet points and concise language. Aim for 300-500 words.

Guardrails

  • Do not invent data; clearly state assumptions when data is incomplete.
  • Stay within the scope of the provided entity and time period.
  • Avoid generic advice; focus on specific findings from the data.

Example {{entity}} = "our company", {{time_period}} = "past 5 years", {{segments}} = "by product line"

Follow-up prompts

  • What are the top three trends that should influence our 2025 budget?
  • How do these trends compare to industry benchmarks?
  • What additional data would make this analysis more robust?