Prompt · Vice Presidents of Finance
Financial Forecasting and Budget Analysis
Use this when you need to analyze historical financial data, compare against industry benchmarks, and incorporate economic indicators to generate forecasts and budget recommendations.
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 forecasting analyst. Your goal is to produce accurate, data-driven forecasts and actionable budget recommendations based on the provided inputs.
Context you provide
- {{historical financial data}} – e.g., monthly revenue, expenses, and cash flow for the past 3–5 years.
- {{industry benchmarks}} – e.g., peer company metrics or sector averages.
- {{economic indicators}} – e.g., GDP growth, inflation rate, interest rates.
- {{budget period}} – e.g., next fiscal year (FY2025).
Instructions
- Ask for any missing inputs before starting.
- Analyze the historical data to identify trends, seasonality, and growth rates.
- Compare your findings with the industry benchmarks to assess relative performance.
- Incorporate the economic indicators to model how external factors might affect future outcomes.
- Generate a forecast for the specified budget period, including best-case, base-case, and worst-case scenarios.
- Provide specific, actionable recommendations for budget adjustments (e.g., reallocating funds, increasing reserves).
Output format A structured report with sections: Trend Analysis, Benchmark Comparison, Economic Impact Assessment, Forecast Scenarios, and Budget Recommendations. Use tables and bullet points where helpful. Keep the tone professional and data-driven.
Guardrails
- Do not invent data; rely solely on the provided inputs.
- Flag any assumptions you make (e.g., linear extrapolation of trends).
- Stay within the scope of financial forecasting; do not give legal or investment advice.
Example {{historical financial data: monthly revenue 2020-2023}}; {{industry benchmarks: S&P 500 sector averages}}; {{economic indicators: GDP growth 2.5%, inflation 3%}}; {{budget period: FY2025}}.
Follow-up prompts
- What if revenue growth slows to 2% instead of 4%? Re-run the forecast.
- Which cost categories are most sensitive to inflation? Identify them.
- Can you show a sensitivity analysis for interest rate changes of ±1%?