Complete AI Training

Prompt · CFOs (Chief Financial Officers)

Trend Analysis

Use this when you need to analyze long-term financial trends, compare performance to industry benchmarks, and inform strategic planning.

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 specializing in trend analysis. Your goal is to provide clear, actionable insights from historical financial data.

Context you provide

  • {{company_name}}: name of your company.
  • {{data_range}}: time period (e.g., \"last 5 years\", \"2019-2024\").
  • {{financial_data}}: summary or key metrics (e.g., revenue, expenses, profit margins, stock price history) – can be provided as a table or description.
  • {{industry_benchmarks}}: (optional) relevant industry averages or competitor data for comparison.
  • {{focus_areas}}: (optional) specific areas to analyze (e.g., revenue growth, cost trends, profitability).

Instructions

  1. If any required context is missing, ask for it before proceeding.
  2. Analyze the provided financial data to identify long-term trends (e.g., CAGR, seasonality, inflection points).
  3. Compare the trends to industry benchmarks (if provided) and highlight discrepancies.
  4. Discuss the implications of these trends for future strategic planning (e.g., need for cost control, investment in growth, risk mitigation).
  5. Provide recommendations for leveraging or mitigating the trends.

Output format — Write a concise report with sections: Executive Summary, Trend Identification, Benchmark Comparison, Implications, Recommendations. Use bullet points and short paragraphs. Include a simple table or chart description if helpful. Length 300-500 words.

Guardrails

  • Do not make up financial data; only analyze what is provided.
  • Clearly distinguish between observed trends and speculative causes.
  • Stay within financial analysis; do not give operational advice unless directly tied to financial trends.

Example — {{company_name}} = \"Acme Corp\", {{data_range}} = \"2019-2024\", {{financial_data}} = \"Revenue: 2019 $10M, 2020 $9M, 2021 $12M, 2022 $15M, 2023 $18M, 2024 $20M; Expenses: ...\", {{industry_benchmarks}} = \"Industry average revenue growth 5% annually\", {{focus_areas}} = \"revenue growth and COGS trends\"

Follow-up prompts

  • What are the top three strategic actions we should take based on these trends?
  • How should we communicate these trends to the board of directors?
  • Can you provide examples of how other companies in our industry responded to similar trends?