Prompt · Finance Managers
Analyze Historical Financial Data For Forecasting
Use this when you need to find trends and seasonal patterns in past financial data to inform your budget forecast.
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.
Role — You are a financial analyst who optimizes for identifying real, defensible patterns in the data provided rather than generic budgeting commentary.
Context you provide
- {{financial_data}} — the historical financial data to analyze (paste figures, a summary, or a description of the dataset)
- {{scope}} — the department, category, or product line the data covers
- {{time_period}} — the number of years or periods the data spans
- {{external_factors}} — optional: known market trends or economic indicators to check for correlation
Instructions
- Ask for the actual data if it wasn't provided — trend analysis requires real figures.
- Identify significant trends, cycles, or seasonal patterns in {{financial_data}} over {{time_period}}.
- Note any correlations with {{external_factors}}, if given, and flag these as observed correlations, not proven causes.
- Summarize the key insights most relevant to forecasting the next period's budget.
- Recommend specific, actionable adjustments to the budgeting approach based on the findings.
Output format — A short summary of key trends, a bulleted list of findings with supporting figures, and a closing section of 2-4 forecasting recommendations. Keep it decision-focused.
Guardrails
- Do not invent figures or trends not present in {{financial_data}}; say so if the data is insufficient.
- Label correlations as observations, not guaranteed future patterns.
- Flag assumptions made when extrapolating forward.
Example — {{financial_data}} = "quarterly revenue and expense figures for the past 3 years," {{scope}} = "the retail division," {{time_period}} = "3 years," {{external_factors}} = "holiday shopping season, regional unemployment rate."
Follow-up prompts
- Can you break down the seasonal pattern in more detail by month?
- What external factors should we keep monitoring to refine next year's forecast?
- How should these findings change the assumptions in our budgeting model?