Prompt lesson · 29 prompts
Financial Forecasting prompts for Executive Directors
29 ready-to-use prompts from our AI for Executive Directors course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Analyze Historical Financial Trends
Use this when you need to find and explain trends or patterns in a company's past financial performance.
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%.
Open this prompt Analysis · Intermediate
Analyze Investment Opportunities
Use this when you need to evaluate potential investments, compare options, or assess financial viability.
Role You are an investment analyst, providing rigorous evaluation of opportunities to support strategic decision-making.
Context you provide
- {{investment_target}}: The company, project, or sector to analyze (e.g., Company X, a new product line, the renewable energy sector).
- {{analysis_type}}: The type of analysis needed (e.g., financial statement analysis, ratio comparison, industry analysis, project evaluation).
- {{time_period}}: The relevant time frame (e.g., past 3 years, next 5 years).
Instructions
- Request the investment target, analysis type, and time period if not specified.
- Gather and analyze relevant financial data (e.g., revenue growth, profitability, liquidity, solvency) for the target.
- For comparative analysis, benchmark against peers or industry averages.
- Assess market trends, growth potential, and risks.
- Provide a clear recommendation with supporting rationale.
- Highlight any data gaps or limitations in the analysis.
Output format Provide an investment analysis report with: Executive Summary, Financial Analysis, Market/Industry Assessment, Risk Evaluation, and Recommendation. Use tables for financial metrics and bullet points for key findings. Tone: objective and evidence-based.
Guardrails
- Do not fabricate financial data; use only provided or publicly available information.
- Clearly state any assumptions made about future performance.
- Do not provide personalized investment advice; focus on analysis.
Example Investment target: Tesla Inc.; analysis type: financial statement analysis; time period: past 3 years.
Open this prompt Analysis · Advanced
Assess Risks To Financial Forecasts
Use this when you need to identify and evaluate the risks that could throw off a financial forecast.
Open this prompt Analysis · Advanced
Build A Budget From Financial Forecasts
Use this when you need to turn financial forecasts and historical spending into a structured budget for the next period.
Open this prompt Planning · Intermediate
Capital Investment Evaluation and Timing
Use this when you need to evaluate the financial impact of a major capital investment and determine the optimal timing for the expenditure.
Open this prompt Analysis · Advanced
Cash Flow Analysis and Forecasting
Use this when you need to analyze current cash flow, project future liquidity, and improve cash management strategies.
Open this prompt Analysis · Intermediate
Cash Flow Forecasting and Visualization
Use this when you need to project future cash inflows and outflows, analyze historical patterns, and gain insights into liquidity management.
Open this prompt Analysis · Intermediate
Cost Reduction and Profitability Analysis
Use this when you need to analyze cost structures, identify cost drivers, and find ways to reduce expenses and improve profitability.
Open this prompt Analysis · Intermediate
Cost Structure Analysis and Optimization
Use this when you need to analyze costs in a specific business area to support financial forecasting and identify optimization opportunities.
Open this prompt Analysis · Intermediate
Develop Long-term Financial Plan
Use this when you need to create a strategic financial roadmap for the future, considering risks, opportunities, and growth scenarios.
Open this prompt Planning · Advanced
Dynamic Financial Modeling
Use this when you need to build flexible financial models that incorporate various variables and scenarios for forecasting.
Open this prompt Creating · Advanced
Evaluate Forecast Accuracy
Use this when you need to compare actual financial results against forecasts, identify discrepancies, and improve future forecasting precision.
Open this prompt Analysis · Intermediate
Expense Forecasting
Use this when you need to project future expenses based on historical data, market trends, and planned activities.
Open this prompt Analysis · Advanced
Finance Team Collaboration for Forecasts
Use this when you need to improve financial forecast accuracy through better collaboration with your finance team.
Open this prompt Analysis · Intermediate
Financial Decision Support
Use this when you need financial insights and recommendations to support strategic executive decisions.
Open this prompt Analysis · Advanced
Financial Performance Monitoring
Use this when you need to track key financial metrics, generate performance reports, and identify areas for improvement.
Open this prompt Analysis · Intermediate
Financial Performance Variance Analysis
Use this when you need to track actual financial performance against forecasts and identify variances.
Open this prompt Analysis · Intermediate
Financial Reporting and Presentation
Use this when you need to prepare reports and presentations that communicate financial forecasts and performance to stakeholders.
Open this prompt Communication · Intermediate
Financial Risk Assessment and Mitigation
Use this when you need to identify and assess financial risks and develop mitigation strategies.
Open this prompt Analysis · Intermediate
Improve Financial Forecasting Processes
Use this when you want to identify weaknesses in your forecasting process and implement enhancements for better accuracy and efficiency.
Open this prompt Analysis · Advanced
Market Research Brief For Forecasting
Use this when you need a summary of industry trends and market conditions to feed into your financial projections.
Open this prompt Research · Intermediate
Model Financial Scenario Outcomes
Use this when you need to model how a business scenario would affect financial outcomes.
Open this prompt Analysis · Advanced
Revenue Forecasting and Strategy
Use this when you need to forecast future revenue based on historical data, market conditions, and business strategies.
Open this prompt Analysis · Intermediate
Revenue Forecasting and Strategy
Use this when you need to forecast future revenue based on sales data, market trends, and business strategies.
Open this prompt Analysis · Intermediate
Revise Financial Forecasts
Use this when you need to update financial forecasts based on new information, market changes, or internal developments.
Open this prompt Planning · Intermediate
Sensitivity Analysis for Financial Forecasts
Use this when you need to assess how changes in key variables impact your financial forecasts and identify the most critical drivers of performance.
Open this prompt Analysis · Intermediate
Sensitivity Analysis for Financial Forecasts
Use this when you need to understand how changes in key variables impact your financial forecasts.
Open this prompt Analysis · Intermediate
Structure A Financial Forecast Model
Use this when you need to structure a spreadsheet-ready financial model to forecast an outcome from a set of stated assumptions.
Open this prompt Planning · Advanced
Support Investor Communications
Use this when you need to prepare clear, credible communications about financial forecasts and strategy for investors.
Open this prompt Communication · Intermediate