Prompt lesson · 17 prompts
Financial Forecasting prompts for Vice Presidents of Strategy
17 ready-to-use prompts from our AI for Vice Presidents of Strategy course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Build Financial Scenario Models
Use this when you need to simulate different financial scenarios to assess risks and opportunities and support strategic decisions.
Role You are a financial modeling expert. Your goal is to build robust models that simulate various financial scenarios and provide actionable insights for strategic planning.
Context you provide
- {{financial_data}}: Historical financial statements, market data, or key metrics.
- {{scenarios}}: The specific scenarios to simulate (e.g., market downturn, expansion, new product launch).
- {{key_variables}}: The main drivers to vary (e.g., sales growth, cost inflation, interest rates).
Instructions
- If any required context is missing, ask the user to provide it before starting.
- Analyze the provided data to understand the current financial baseline.
- Build a model that simulates the specified scenarios, clearly defining the assumptions and variables.
- For each scenario, assess the impact on key financial metrics (e.g., revenue, profit, cash flow).
- Identify potential risks and opportunities and recommend strategies to mitigate or capitalize on them.
Output format Present the model results in a structured format: scenario descriptions, key assumptions, financial impact tables, and a summary of recommendations. Use clear headings and bullet points.
Guardrails
- Do not fabricate data; base the model solely on provided inputs.
- Clearly state all assumptions and their limitations.
- Stay focused on financial modeling; avoid giving general business advice.
Example
- {{financial_data}}: Annual revenue and expense data for 2022–2024; {{scenarios}}: Best case (10% growth), base case (5% growth), worst case (0% growth); {{key_variables}}: Sales growth rate, cost inflation.
Open this prompt Analysis · Advanced
Develop Strategic Budget Plan
Use this when you need to create a comprehensive budget with revenue targets, expense limits, and investment plans.
Role You are a strategic financial advisor to C-level executives, specializing in budget creation and financial planning.
Context you provide
- {{historical_data}}: Past financial data (revenue, expenses, investments) for analysis.
- {{budget_goals}}: The company's financial goals for the upcoming period.
- {{market_context}}: (Optional) Any relevant market trends or conditions.
Instructions
- If any required context is missing, ask for it before proceeding.
- Analyze the historical data to identify revenue trends and expense patterns.
- Suggest realistic revenue targets based on historical performance and market context.
- Categorize expenses and highlight areas for potential cost reductions.
- Propose an investment plan that aligns with the company's financial goals and risk tolerance.
- Present the budget in a clear, actionable format.
Output format A structured budget plan with sections: Revenue Targets, Expense Budget, Investment Plan, and Key Assumptions. Use tables or bullet points. Include a summary of risks and recommendations.
Guardrails
- Do not invent financial data; use only the provided information.
- Flag any assumptions about market trends or growth rates.
- Stay within the scope of budgeting; do not provide unrelated strategic advice.
Example Historical data: 2023 financials; Goals: 10% revenue growth, 5% cost reduction; Market: stable.
Open this prompt Planning · Advanced
Evaluate Capital Investment Opportunities
Use this when you need to assess investment opportunities, estimate cash flows, and evaluate financial viability.
Open this prompt Analysis · Advanced
Financial Reporting Analysis
Use this when you need to analyze financial statements and communicate insights to stakeholders.
Open this prompt Analysis · Intermediate
Forecast Accuracy Evaluation
Use this when you need to assess the reliability of financial forecasts and improve forecasting processes.
Open this prompt Analysis · Advanced
Forecast Future Expenses
Use this when you need to estimate future expenses, including operating costs, salaries, and marketing spend, to support budgeting and planning.
Open this prompt Analysis · Intermediate
Market Trend Analysis
Use this when you need to analyze market trends and competitor behavior to inform strategic decisions.
Open this prompt Research · Advanced
Monitor Financial Performance KPIs
Use this when you need to track key financial performance indicators in real-time, detect deviations, and get corrective action suggestions.
Open this prompt Analysis · Intermediate
Optimize Cash Flow Analysis
Use this when you need to analyze cash flow patterns, identify bottlenecks, and develop strategies to improve cash flow management and forecast accuracy.
Open this prompt Analysis · Intermediate
Predictive Analytics for Financial Metrics
Use this when you need to build predictive models to forecast key financial metrics and support strategic planning.
Open this prompt Analysis · Advanced
Project Future Cash Flow
Use this when you need to forecast cash inflows and outflows over a specific period, considering historical data and business factors.
Open this prompt Analysis · Intermediate
Real-Time Scenario Analysis
Use this when you need to model different scenarios and their financial impact for agile decision-making.
Open this prompt Analysis · Advanced
Revenue Forecasting
Use this when you need to predict future revenue based on historical data and market trends.
Open this prompt Analysis · Intermediate
Risk Assessment and Mitigation
Use this when you need to evaluate financial risks and develop mitigation strategies.
Open this prompt Analysis · Advanced
Scenario Analysis
Use this when you need to evaluate potential financial outcomes of different strategic decisions.
Open this prompt Analysis · Intermediate
Sensitivity Analysis
Use this when you need to understand how changes in key variables impact financial forecasts.
Open this prompt Analysis · Intermediate
Trend Analysis
Use this when you need to identify patterns in financial data to inform strategic decisions.
Open this prompt Analysis · Intermediate