Prompt lesson · 26 prompts
Financial Forecasting prompts for Directors of Finances
26 ready-to-use prompts from our AI for Directors of Finances course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Analyze Budget Variance And Recommend Fixes
Use this when you need to explain why actual spending deviated from the budget and recommend corrective action.
Role — You are a budget analyst who optimizes for clear explanations of variance and specific, actionable fixes, not generic financial commentary.
Context you provide
- {{budget_data}} — the budgeted vs. actual figures by category (paste the data or a summary)
- {{period}} — the fiscal period the budget covers
- {{context}} — optional: known reasons behind certain deviations (e.g., a one-time expense, delayed hire)
Instructions
- Ask for the actual budget vs. actual figures if not provided — variance analysis requires real numbers.
- Calculate the variance (amount and percentage) for each category in {{budget_data}}.
- Flag the categories with the largest or most concerning deviations.
- Suggest likely drivers behind each significant variance, using {{context}} where given and flagging inferences elsewhere.
- Recommend 2-3 specific corrective actions or budget adjustments for the next period.
Output format — A table of category, budgeted amount, actual amount, variance ($ and %), followed by a short narrative on the top 2-3 variances and a closing list of recommendations.
Guardrails
- Only calculate from the figures in {{budget_data}}; do not invent numbers or assume unstated causes.
- Clearly separate confirmed reasons (from {{context}}) from inferred possibilities.
- Flag categories where more information is needed to explain the variance.
Example — {{budget_data}} = "marketing: budgeted $50K, actual $68K; travel: budgeted $20K, actual $12K," {{period}} = "Q2," {{context}} = "marketing overspend tied to an unplanned trade show."
Open this prompt Analysis · Intermediate
Assess Forecast vs. Actuals
Use this when you need to compare forecasts against actual results and identify discrepancies or trends.
Role You are a financial analyst who helps finance leaders evaluate forecast accuracy by comparing forecasts with actual results.
Context you provide
- {{forecast-data}}: The forecasted figures (e.g., revenue, expenses) for a specific period.
- {{actual-data}}: The actual results for the same period.
- {{time-period}}: The period to analyze (e.g., past quarter, current year).
- {{focus-area}}: Any specific area to focus on (e.g., revenue, expenses, product lines).
Instructions
- If any required context is missing, ask for it before proceeding.
- Compare the forecasted figures with actual results for the specified period.
- Identify significant discrepancies and categorize them (e.g., overestimation, underestimation).
- Analyze trends or patterns in the discrepancies (e.g., seasonal effects, market shifts).
- Provide recommendations for improving forecast accuracy based on the findings.
Output format Provide a clear comparison report with tables showing forecast vs. actual, a list of key discrepancies, and a summary of trends. Include actionable recommendations.
Guardrails
- Do not alter the data; use only what is provided.
- Flag any assumptions about the causes of discrepancies.
- Stay focused on forecast evaluation; do not provide broader financial advice.
Example
- {{forecast-data}}: Q1 2024 revenue forecast of $1.2M, {{actual-data}}: Q1 2024 actual revenue of $1.1M, {{time-period}}: Q1 2024, {{focus-area}}: Revenue.
Open this prompt Analysis · Intermediate
Budget Allocation Optimization
Use this when you need to optimize budget allocation across departments or projects based on historical data and market conditions.
Open this prompt Planning · Intermediate
Cash Flow Projection
Use this when you need to generate accurate cash flow projections for a specific period based on historical data, expenses, and payment terms.
Open this prompt Planning · Beginner
Comprehensive Financial Reporting
Use this when you need to generate detailed financial reports summarizing forecasts, assumptions, and key findings for stakeholders.
Open this prompt Writing · Intermediate
Cost Structure Optimization
Use this when you need to analyze cost structures, identify savings opportunities, and benchmark against industry standards.
Open this prompt Analysis · Intermediate
Evaluate Forecast Accuracy
Use this when you need to assess the accuracy of past forecasts and identify ways to improve future forecasting.
Open this prompt Analysis · Intermediate
Financial Compliance Review
Use this when you need to ensure financial forecasts and statements comply with accounting standards and regulations.
Open this prompt Analysis · Advanced
Financial Forecast Presentation
Use this when you need to communicate financial forecasts clearly to stakeholders through presentations, reports, or dashboards.
Open this prompt Communication · Intermediate
Financial Model Development
Use this when you need to build financial models for forecasting, investment analysis, scenario planning, or capital raising.
Open this prompt Creating · Advanced
Financial Risk Assessment
Use this when you need to identify and evaluate financial risks and develop mitigation strategies.
Open this prompt Analysis · Intermediate
Financial Scenario Model Builder
Use this when you need to design and build a financial model that simulates different business scenarios to evaluate their potential impact.
Open this prompt Creating · Advanced
Financial Scenario Sensitivity Analysis
Use this when you need to assess how changes in key variables affect your financial forecasts and identify the most impactful risks and opportunities.
Open this prompt Analysis · Intermediate
Forecast Cash Flow With Risk Alerts
Use this when you need a cash flow forecast that also flags potential shortfalls and payment risks so you can act before they happen.
Open this prompt Analysis · Intermediate
Forecast Future Expenses By Category
Use this when you need to estimate future expenses from historical spending patterns to support budget planning.
Open this prompt Analysis · Intermediate
Forecast Future Revenue Streams
Use this when you need to project future revenue based on historical data and market conditions to support strategic planning.
Open this prompt Analysis · Intermediate
Forecast Risk Evaluation
Use this when you need to assess risks that could impact the accuracy of your financial forecasts.
Open this prompt Analysis · Advanced
Forecast Sensitivity Variable Analysis
Use this when you need to understand how changes in specific cost or revenue drivers will impact your financial forecasts and investment decisions.
Open this prompt Analysis · Intermediate
Generate Accurate Financial Reports
Use this when you need to create or validate income statements, balance sheets, or cash flow statements in line with accounting standards.
Open this prompt Creating · Intermediate
Monitor Financial Performance
Use this when you need to track key financial metrics and generate performance reports with insights for improvement.
Open this prompt Analysis · Intermediate
Organize Financial Data For Forecasting
Use this when you need to structure financial data you've gathered from reports or filings into a form ready for forecasting.
Open this prompt Research · Intermediate
Performance Monitoring System
Use this when you need to track actual financial performance against forecasts and identify deviations.
Open this prompt Analysis · Intermediate
Revenue Forecasting Analysis
Use this when you need to forecast revenue based on historical data, market conditions, and business factors.
Open this prompt Analysis · Intermediate
Review and Adjust Forecasts
Use this when you need to review existing financial forecasts and adjust them based on market trends or internal changes.
Open this prompt Planning · Intermediate
Scenario-Based Financial Simulation
Use this when you need to simulate the financial impact of different market conditions, pricing strategies, mergers, or capital structures.
Open this prompt Analysis · Advanced
Uncover Trends Across Business Data
Use this when you need to find patterns, correlations, or seasonal trends across financial, sales, or cost data to support forecasting or a strategy report.
Open this prompt Analysis · Intermediate