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.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- 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
- Ask for the data, time period, and comparison context if missing.
- Identify the most significant trends in {{financial_data}} over the stated period, calling out inflection points.
- Where {{comparison_context}} is given, compare performance against it and explain gaps or advantages.
- Suggest 1-2 plausible drivers for each major trend, clearly labeled as hypotheses, not confirmed causes.
- 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?