Prompt lesson · 24 prompts
Industry analysis prompts for Vice Presidents of Finance
24 ready-to-use prompts from our AI for Vice Presidents of Finance course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Analyze Financial Data For Forecasting
Use this when you need to turn financial statements, market data, or expert input into clear trends and forecasting-ready insights.
Role — You are a financial analyst who structures raw financial data into trends, ratios, and forecasting-ready insights for executive review.
Context you provide
- {{financial_data}} — the figures you're providing (statements, reports, exported metrics) and the period they cover
- {{focus_metrics}} — what to calculate or track (revenue, margins, growth rates, specific ratios)
- {{industry_context}} — the industry or benchmark to compare against, if relevant
- {{forecasting_goal}} — what the analysis needs to support (a budget, a board update, an investment case)
Instructions
- Ask for any missing inputs before starting — this tool works from data you paste in, not live feeds or APIs.
- Organize {{financial_data}} into a clean structure and calculate {{focus_metrics}}.
- Identify trends, inflection points, or anomalies across the period, and note likely drivers.
- Compare against {{industry_context}} where data is provided, and highlight gaps versus benchmark.
- Summarize what the trends imply for {{forecasting_goal}}, flagging any assumption that needs validation.
Output format — A metrics table, a short narrative of key trends (3–5 bullets), and a closing paragraph on implications for {{forecasting_goal}}.
Guardrails
- Never fabricate financial figures, benchmarks, or real-time market data; work only from what's provided.
- Show the calculation method for any ratio or growth rate, not just the result.
- Flag any conclusion resting on a single data point as low-confidence.
Example — {{financial_data}} = three years of income statements; {{focus_metrics}} = gross margin trend and revenue growth rate; {{forecasting_goal}} = next year's budget.
Open this prompt Analysis · Intermediate
Assess Financial Risks
Use this when you need to identify and evaluate financial risks from market, credit, regulatory, or geopolitical factors.
Role You are a financial risk analyst who identifies key risks and provides actionable mitigation strategies to protect financial stability.
Context you provide
- {{risk_focus}}: The specific area to assess (e.g., market volatility, credit risk, regulatory changes, geopolitical events).
- {{financial_data}}: Any relevant data such as portfolio composition, receivables, or operational exposure.
- {{time_period}}: The timeframe for the risk assessment (e.g., next quarter, next year).
Instructions
- If any required context is missing, ask for it before starting.
- Analyze the provided risk focus and data to identify potential risks and their likelihood and impact.
- Prioritize risks based on severity and probability.
- For each top risk, recommend specific mitigation strategies.
- Summarize the overall risk outlook and key monitoring indicators.
Output format A risk assessment report with a prioritized risk matrix, detailed analysis of top risks, and clear mitigation recommendations. Use tables or bullet points for clarity.
Guardrails
- Do not fabricate risk data; base analysis on provided information.
- Clearly distinguish between facts and assumptions.
- Keep recommendations practical and within the scope of the identified risks.
Example Risk focus: market volatility; financial data: portfolio with 60% equities; time period: next year.
Open this prompt Analysis · Advanced
Budget Allocation Optimization
Use this when you need to analyze historical financial data to improve budget distribution across departments or projects.
Open this prompt Analysis · Intermediate
Build a Scenario-Based Financial Model
Use this when you need to build a scenario-based financial model from historical data.
Open this prompt Analysis · Advanced
Build Financial Models
Use this when you need to create a financial model for forecasting, budgeting, or investment analysis.
Open this prompt Creating · Advanced
Capital Expenditure Forecasting
Use this when you need to forecast capital expenditures based on asset lifecycles, maintenance costs, and market trends.
Open this prompt Analysis · Advanced
Cash Flow Projection
Use this when you need to forecast cash inflows and outflows to manage liquidity and plan for future periods.
Open this prompt Analysis · Intermediate
Cost Analysis and Reduction
Use this when you need to analyze costs across business activities to identify trends, inefficiencies, and savings opportunities.
Open this prompt Analysis · Intermediate
Evaluate Forecast Accuracy
Use this when you need to assess how accurate past forecasts were and identify areas for improvement.
Open this prompt Analysis · Intermediate
Financial Forecast Presentation
Use this when you need to create a clear, visual presentation summarizing financial forecasts for stakeholders.
Open this prompt Creating · Intermediate
Financial Performance Monitoring
Use this when you need to track actual financial results against forecasts and identify variances.
Open this prompt Analysis · Intermediate
Financial Risk Assessment
Use this when you need to identify and assess financial risks that could impact forecast accuracy.
Open this prompt Analysis · Advanced
Financial Scenario Planning
Use this when you need to model financial outcomes under different market conditions to support strategic decisions.
Open this prompt Planning · Advanced
Financial Sensitivity Analysis
Use this when you need to understand how changes in key variables affect your financial forecasts.
Open this prompt Analysis · Intermediate
Forecast Cash Flow And Liquidity
Use this when you need to project future cash inflows and outflows to manage liquidity and plan financing decisions.
Open this prompt Analysis · Intermediate
Forecast Future Operating Expenses
Use this when you need to turn historical spending data into an expense forecast and cost-saving recommendations.
Open this prompt Analysis · Advanced
Forecast Revenue From Historical Data
Use this when you have historical sales and market data and need a revenue forecast with key drivers and risks called out.
Open this prompt Analysis · Advanced
Improve Forecast Accuracy
Use this when you need a deeper statistical analysis of forecast errors and model comparisons to enhance forecasting methods.
Open this prompt Analysis · Advanced
Prepare A Data-Driven Budget
Use this when you need to turn historical financial data and organizational goals into a structured budget draft.
Open this prompt Planning · Advanced
Profitability Analysis and Optimization
Use this when you need to analyze revenue streams, cost structures, and pricing strategies to improve profitability.
Open this prompt Analysis · Advanced
Revenue Forecasting and Analysis
Use this when you need to generate revenue forecasts based on historical data, market trends, and sales projections.
Open this prompt Analysis · Intermediate
Strategic Scenario Development
Use this when you need to explore alternative business strategies and their potential outcomes and risks.
Open this prompt Planning · Advanced
Support Investor Relations
Use this when you need to prepare financial communications, forecasts, or responses for investors and stakeholders.
Open this prompt Communication · Intermediate
Working Capital Optimization
Use this when you need to analyze and improve your company's working capital management.
Open this prompt Analysis · Intermediate