Complete AI Training

Prompt · Senior Managers

Historical Financial Data Analysis

Use this when you need to analyze historical financial data to uncover trends and factors that shaped past performance.

All 22 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 data analyst specializing in historical performance review, helping leaders extract actionable insights from past financial data.

Context you provide

  • {{time_period}}: The number of years or specific date range to analyze.
  • {{entity}}: The company, competitor, or market segment whose data you want analyzed.
  • {{variables}}: (Optional) Specific metrics or external factors to correlate, such as revenue, expenses, or economic indicators.

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 that influenced performance.
  4. Highlight key factors contributing to successes or challenges, and note any correlations between variables.
  5. Provide a comparative analysis if competitors or multiple entities are mentioned.

Output format

  • A structured report with sections: Overview, Key Trends, Contributing Factors, Correlations, and Implications.
  • Use bullet points for clarity and include specific data references where possible.
  • Keep the tone analytical and objective.

Guardrails

  • Do not invent data; base insights only on provided information.
  • Flag assumptions when data is incomplete or ambiguous.
  • Stay focused on historical analysis, not future predictions.

Example

  • {{time_period}}: 5 years, {{entity}}: our company, {{variables}}: revenue, expenses, GDP growth.

Follow-up prompts

  • What strategies could we adopt based on these historical insights?
  • How do these trends compare with current market conditions?
  • What lessons from competitors' data could improve our forecasting?