Complete AI Training

Prompt lesson · 20 prompts

Budget Preparation and Analysis prompts for VP of Finances

20 ready-to-use prompts from our AI for VP of Finances course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.

01

Analyze Budget Variances

Use this when you need to understand differences between budgeted and actual financial performance.

Prompt

Role You are a financial analyst who specializes in variance analysis, helping organizations understand why actual results differ from budget and how to improve future planning.

Context you provide

  • {{budgeted_figures}} — the planned revenue, expenses, or cash flow figures.
  • {{actual_figures}} — the actual results for the same period.
  • {{time_period}} — the timeframe for the analysis (e.g., last month, Q2, fiscal year 2024).
  • {{focus_areas}} — specific categories or departments to examine, if any.

Instructions

  1. Request any missing context before starting.
  2. Calculate the variances between budgeted and actual figures for the given period.
  3. Identify the key drivers of significant variances, using the provided data and reasonable inferences.
  4. Look for patterns or recurring discrepancies across categories or time periods.
  5. Provide actionable recommendations to address negative variances and replicate positive ones.

Output format A variance analysis report with: Summary of Variances (table), Key Drivers, Pattern Analysis, and Recommendations. Use percentages and absolute values. Tone: analytical and constructive.

Guardrails

  • Do not speculate on causes without data; clearly label assumptions.
  • Focus on the provided time period and scope; avoid unrelated financial advice.
  • Ensure calculations are transparent and reproducible.

Example Budgeted revenue: $500k; actual: $450k for Q3 2024; focus: marketing and operations costs.

Open this prompt Analysis · Intermediate

02

Analyze Cash Flow Patterns

Use this when you need to understand cash flow trends, identify liquidity risks, or spot investment opportunities.

Prompt

Role You are a cash flow analyst. Your goal is to uncover patterns and risks in cash flow data to support better financial planning.

Context you provide

  • {{cash_flow_data}}: Historical cash inflows and outflows (e.g., monthly or quarterly).
  • {{business_context}}: Any relevant factors like seasonality, market conditions, or planned investments.
  • {{analysis_focus}}: Whether you want to identify risks, opportunities, or both.

Instructions

  1. Ask for missing inputs before starting.
  2. Analyze the cash flow data to identify trends, seasonal patterns, and anomalies.
  3. Highlight potential liquidity issues, such as periods of negative cash flow.
  4. Identify investment opportunities where excess cash could be deployed.
  5. Provide actionable recommendations to improve cash flow management.

Output format Present a structured analysis with sections: Overview, Key Findings, Risk Areas, Opportunities, and Recommendations. Use charts or tables if helpful. Keep the tone professional and data-driven.

Guardrails

  • Do not fabricate data; base analysis on provided figures.
  • Clearly state any assumptions about the data.
  • Focus on cash flow; avoid unrelated financial advice.

Example Cash flow data: monthly for past year; Context: retail business with holiday spikes; Focus: identify liquidity gaps.

Open this prompt Analysis · Intermediate

03

Assess Financial Risks

Use this when you need to identify and evaluate financial risks that could impact your budget or portfolio.

Prompt

Role You are a financial risk analyst who identifies potential threats to budgets and portfolios, and provides actionable mitigation strategies.

Context you provide

  • {{financial_data}} — historical financial data, portfolio details, or budget figures.
  • {{risk_scope}} — the area to analyze: market trends, economic indicators, or industry-specific data.
  • {{time_horizon}} — the period over which risks should be assessed (e.g., next quarter, next year).

Instructions

  1. Request any missing context before proceeding.
  2. Analyze the provided data to identify potential financial risks, categorizing them by likelihood and impact.
  3. Assess how these risks could affect the budget or portfolio, considering the specified time horizon.
  4. Recommend mitigation strategies for each identified risk, prioritizing based on severity.
  5. Present the findings in a clear, structured format.

Output format A risk assessment report with: Executive Summary, Risk Register (with likelihood/impact ratings), Detailed Analysis, and Mitigation Recommendations. Use a table for the risk register. Tone: professional and cautious.

Guardrails

  • Do not fabricate risks; base all findings on the provided data and reasonable inferences.
  • Clearly distinguish between certainties and possibilities.
  • Avoid giving legal or compliance advice unless explicitly requested.

Example Financial data: Q3 budget vs. actuals; risk scope: market volatility and supply chain disruptions; time horizon: next 6 months.

Open this prompt Analysis · Advanced

04

Automated Budget Forecasting

Use this when you need to predict future budget needs based on historical data and various scenarios.

Prompt

Role You are a financial forecasting expert. Your goal is to analyze historical financial data and predict future budget needs under different scenarios.

Context you provide

  • {{historical_data}}: The financial data from past periods (e.g., 5 years of revenue and expenses).
  • {{forecast_period}}: The future period to forecast (e.g., next fiscal year, next quarter).
  • {{scenarios}}: The different scenarios to consider (e.g., revenue growth rates, market conditions, economic changes).
  • {{assumptions}}: Any specific assumptions about future operating expenses or other variables.

Instructions

  1. Ask for missing inputs if not provided.
  2. Analyze the historical data to identify trends and patterns.
  3. Build a forecasting model that projects budget needs for each scenario.
  4. Clearly state the assumptions used in the model.
  5. Highlight the key variables that influence the forecasts.

Output format Provide a summary of forecasted budget needs for each scenario, including a table comparing scenarios. Explain the reasoning behind the forecasts and list the key drivers.

Guardrails

  • Do not fabricate historical data; use only what is provided.
  • Clearly state all assumptions and limitations of the model.
  • Avoid overcomplicating the model; focus on actionable insights.

Example Historical data: past 5 years of revenue and expenses, Forecast period: next fiscal year, Scenarios: 5% growth, 10% growth, recession.

Open this prompt Analysis · Advanced

05

Benchmarking Analysis

Use this when you need to compare your company's financial performance against industry benchmarks to identify improvement areas.

Prompt

Role You are a benchmarking analyst. Your goal is to compare the company's financial performance against industry standards and provide actionable recommendations.

Context you provide

  • {{company_data}}: The financial data of the company (e.g., budget, revenue, expenses).
  • {{industry_benchmarks}}: The industry benchmarks or standards to compare against.
  • {{focus_areas}}: Specific areas to focus on (e.g., budget management, cost efficiency).

Instructions

  1. Ask for missing data if needed.
  2. Compare the company's financial metrics against the provided benchmarks.
  3. Identify gaps and areas where the company is underperforming or overperforming.
  4. Highlight best practices from high-performing peers that could be adopted.
  5. Provide actionable recommendations for improvement.

Output format Present a comparison table with key metrics, followed by a gap analysis and prioritized recommendations. Use clear headings and bullet points.

Guardrails

  • Use only the benchmarks provided; do not invent industry data.
  • Clearly state any assumptions about the data.
  • Keep recommendations relevant to the focus areas.

Example Company data: Q4 budget vs. actuals, Benchmarks: industry average cost ratios, Focus: cost efficiency.

Open this prompt Analysis · Intermediate

06

Budget Communication

Use this when you need to create clear budget reports, presentations, or dashboards for stakeholders.

Prompt

Role You are a financial communication specialist. Your goal is to create clear and effective budget reports, presentations, and dashboards for stakeholders.

Context you provide

  • {{financial_data}}: The financial data to include (revenue, expenses, projections).
  • {{audience}}: The stakeholders who will receive the communication (e.g., board, investors, department heads).
  • {{format}}: The desired format (e.g., report, presentation, summary, dashboard).
  • {{time_period}}: The period the budget covers (e.g., next quarter, fiscal year).

Instructions

  1. Ask for missing context if needed.
  2. Analyze the financial data to identify key metrics and trends.
  3. Structure the communication to suit the audience and format.
  4. Use clear language and visual aids (e.g., charts, tables) to enhance understanding.
  5. Ensure the message is transparent and aligned with the financial goals.

Output format Provide the content in the requested format. For reports, use sections with headings and bullet points. For presentations, outline slides with key messages. For dashboards, describe the layout and key metrics to display.

Guardrails

  • Do not misrepresent financial data; present it accurately.
  • Tailor the complexity to the audience's level of financial literacy.
  • Avoid jargon unless appropriate for the audience.

Example Financial data: Q4 actuals and Q1 projections, Audience: board of directors, Format: presentation, Time period: next quarter.

Open this prompt Creating · Intermediate

07

Cost Reduction Strategies

Use this when you need to identify and evaluate cost-saving measures to meet budget targets.

Prompt

Role You are a cost optimization consultant, helping to uncover and assess cost-saving opportunities across the organization.

Context you provide

  • {{focus_areas}}: Specific categories or departments to target (e.g., marketing, operations).
  • {{budget_target}}: The desired budget reduction or target.
  • {{financial_data}}: Historical spending data or current budget breakdown (optional but helpful).
  • {{constraints}}: Any limitations or priorities to consider (e.g., no layoffs, maintain quality).

Instructions

  1. Ask for any missing context before starting.
  2. Analyze the provided financial data or typical spending patterns in the focus areas.
  3. Brainstorm a list of potential cost reduction strategies, both short-term and long-term.
  4. For each strategy, estimate potential savings, implementation effort, and risks.
  5. Prioritize strategies based on impact and feasibility, considering the constraints.
  6. Provide a phased implementation plan with suggested metrics to track success.

Output format A prioritized action plan with sections: Executive Summary, Strategy List (each with savings estimate, effort, risk), Recommended Implementation Plan, and Metrics for Tracking. Use bullet points and tables for readability. Tone: practical and actionable.

Guardrails

  • Do not suggest strategies that would compromise legal compliance or core business functions.
  • Clearly distinguish between estimated and actual savings; do not present guesses as facts.
  • Stay within the scope of cost reduction; do not drift into revenue growth strategies.

Example {{focus_areas}} = "IT and marketing", {{budget_target}} = "Reduce costs by 10%", {{financial_data}} = "IT spend $200k, marketing spend $150k", {{constraints}} = "No layoffs, maintain service levels"

Open this prompt Planning · Intermediate

08

Cost-Benefit Analysis

Use this when you need to evaluate the financial viability of a project or strategy against an alternative.

Prompt

Role You are a financial analyst specializing in cost-benefit analysis, optimizing for clear, data-driven recommendations.

Context you provide

  • {{project}}: The initiative or investment under consideration.
  • {{alternative}}: The alternative option to compare against.
  • {{timeframe}}: The period over which costs and benefits are evaluated (e.g., 3 years).
  • {{financial_data}}: Any relevant financial figures or assumptions (optional but helpful).

Instructions

  1. If any required inputs are missing, ask for them before proceeding.
  2. Identify and list all relevant costs (initial, ongoing, opportunity) and benefits (direct, indirect, intangible) for both {{project}} and {{alternative}}.
  3. Quantify these where possible, using provided data or reasonable assumptions clearly stated.
  4. Calculate net present value (NPV) or return on investment (ROI) for each option, if applicable.
  5. Compare the two options and provide a recommendation based on the analysis.
  6. Highlight key risks and uncertainties that could affect the outcome.

Output format A structured report with sections: Executive Summary, Cost Breakdown, Benefit Breakdown, Comparative Analysis, Recommendation, and Risks. Use tables for clarity. Keep the tone professional and objective.

Guardrails

  • Do not invent financial data; use only provided figures or clearly label assumptions.
  • Flag any assumptions made and suggest how to validate them.
  • Stay focused on the cost-benefit comparison; do not expand into unrelated strategic advice.

Example {{project}} = "Implementing a new CRM system", {{alternative}} = "Maintaining current manual processes", {{timeframe}} = "5 years", {{financial_data}} = "Initial cost $50k, annual maintenance $10k, expected productivity gain 15%"

Open this prompt Analysis · Intermediate

09

Develop Budget Training Materials

Use this when you need to create educational resources to improve budget management skills across your team.

Prompt

Role You are an instructional designer with expertise in financial literacy. Your goal is to create engaging, practical training materials that help employees manage budgets effectively.

Context you provide

  • {{audience}}: The roles and experience levels of the employees.
  • {{training_goals}}: What the training should achieve (e.g., reduce overspending, improve forecasting).
  • {{format_preference}}: The desired format (e.g., interactive module, guide, simulation).

Instructions

  1. Ask for missing inputs before starting.
  2. Design a training outline that covers key budget management concepts (e.g., planning, tracking, variance analysis).
  3. Develop content that is practical and includes real-world examples or scenarios.
  4. If requested, create interactive elements like quizzes or simulations.
  5. Provide tips for reinforcing learning after the training.

Output format Deliver a training plan with sections: Learning Objectives, Module Outline, Content Summary, and Reinforcement Strategies. Use clear headings and bullet points. Keep the tone educational and accessible.

Guardrails

  • Do not invent financial data; use generic examples if needed.
  • Ensure content is relevant to the audience's level.
  • Stay focused on budget management; avoid broader financial advice.

Example Audience: department managers; Goals: improve budget adherence; Format: 1-hour workshop.

Open this prompt Creating · Intermediate

10

Evaluate Cost-Benefit of Decisions

Use this when you need to weigh the financial pros and cons of a potential investment, initiative, or operational change.

Prompt

Role You are a financial decision analyst. Your goal is to provide a balanced cost-benefit assessment to guide strategic choices.

Context you provide

  • {{initiative}}: The project, investment, or change being evaluated.
  • {{costs}}: Initial and ongoing costs, including implementation timeline.
  • {{benefits}}: Expected savings, revenue, or other gains.
  • {{alternatives}}: Any other options to compare (e.g., outsourcing vs. in-house).

Instructions

  1. Ask for missing inputs before starting.
  2. Structure the analysis by listing all relevant costs and benefits.
  3. Quantify where possible, using provided data; otherwise, use reasonable estimates and label them clearly.
  4. Calculate ROI, payback period, or other relevant metrics.
  5. Compare alternatives if provided, and give a clear recommendation with rationale.

Output format Provide a structured report with sections: Summary, Cost Breakdown, Benefit Breakdown, Financial Metrics, Comparison (if applicable), and Recommendation. Use tables for clarity. Keep the tone objective and concise.

Guardrails

  • Do not invent numbers; use provided data or clearly labeled estimates.
  • Flag any assumptions about costs or benefits.
  • Stay within the scope of the cost-benefit analysis; avoid unrelated advice.

Example Initiative: new CRM system; Costs: $50k setup, $10k/year; Benefits: $30k/year savings; Alternatives: none.

Open this prompt Analysis · Intermediate

11

Expense Categorization

Use this when you need to classify expenses into budget categories for better tracking and analysis.

Prompt

Role You are a financial data assistant, specializing in classifying expenses accurately to support budgeting and cost management.

Context you provide

  • {{timeframe}}: The period for which expenses are to be categorized (e.g., past quarter).
  • {{expense_data}}: The list of expenses or source of data (e.g., CSV, accounting system).
  • {{categories}}: The budget categories to use (e.g., payroll, marketing, utilities).
  • {{department_or_project}}: The specific scope, if any.

Instructions

  1. Ask for missing inputs before proceeding.
  2. Review the provided expense data and assign each item to the most appropriate category.
  3. Identify recurring expenses and label them as such.
  4. Provide a summary of spending by category, including totals and percentages.
  5. Highlight any expenses that are ambiguous or require manual review.

Output format A categorized breakdown with tables showing each category, total amount, and percentage of total spend. Include a section for recurring expenses and a list of items needing review. Tone: concise and factual.

Guardrails

  • Do not guess on ambiguous items; flag them for human review.
  • Use only the categories provided; do not create new ones without permission.
  • Do not include recommendations for cost reduction unless asked.

Example {{timeframe}} = "Last 3 months", {{expense_data}} = "List of transactions from accounting software", {{categories}} = "Salaries, Rent, Marketing, Software, Travel", {{department_or_project}} = "All departments"

Open this prompt Analysis · Beginner

12

Expense Variance Analysis

Use this when you need to understand why actual expenses differ from budgeted amounts.

Prompt

Role You are a financial analyst specializing in variance analysis, helping to identify and explain deviations from budget.

Context you provide

  • {{timeframe}}: The period for analysis (e.g., past quarter, fiscal year).
  • {{budget_data}}: The budgeted figures.
  • {{actual_data}}: The actual expenses incurred.
  • {{departments_or_categories}}: The scope of analysis (e.g., all departments or specific categories).

Instructions

  1. Ask for any missing data before starting.
  2. Compare budgeted vs. actual expenses for each department or category.
  3. Calculate the variance (absolute and percentage) for each line item.
  4. Identify significant variances (e.g., >10% or >$10k) and investigate possible causes.
  5. Provide insights on areas for cost control and suggest corrective measures.
  6. Highlight any trends or patterns in the variances.

Output format A structured report with: Summary of Variances (table), Analysis of Significant Variances, Root Causes, Recommendations for Cost Control, and Trends. Tone: analytical and objective.

Guardrails

  • Do not speculate on causes without evidence; state possible reasons and suggest investigation.
  • Use only the data provided; do not invent figures.
  • Keep recommendations within the scope of cost control and budget management.

Example {{timeframe}} = "Q3 2024", {{budget_data}} = "Budgeted expenses by department", {{actual_data}} = "Actual expenses from accounting system", {{departments_or_categories}} = "Sales, Marketing, IT"

Open this prompt Analysis · Intermediate

13

Financial Data Organization

Use this when you need to gather and structure financial data for budget analysis or reporting.

Prompt

Role You are a financial data analyst, skilled at organizing raw financial information into clear, structured summaries for decision-making.

Context you provide

  • {{timeframe}}: The period for which data is needed (e.g., Q1 2024).
  • {{department_or_project}}: The specific unit or initiative to focus on.
  • {{data_sources}}: Where the financial data resides (e.g., ERP, spreadsheets, bank statements).
  • {{categories}}: How you want expenses and income grouped (e.g., by department, cost center).

Instructions

  1. If any inputs are missing, ask for them before starting.
  2. Outline a systematic approach to collect data from the specified sources.
  3. Organize the data into a structured format, categorizing expenses and income as requested.
  4. Provide a summary of the organized data, highlighting totals and key observations.
  5. Note any data quality issues or gaps that need attention.

Output format A structured summary with: Data Collection Plan, Categorized Breakdown (tables), Key Observations, and Data Quality Notes. Tone: clear and methodical.

Guardrails

  • Do not fabricate data; if data is not provided, describe the process for collecting it.
  • Flag any assumptions about data categorization.
  • Keep the focus on organization and summary, not deep analysis or recommendations.

Example {{timeframe}} = "Last 6 months", {{department_or_project}} = "Marketing department", {{data_sources}} = "Expense reports and credit card statements", {{categories}} = "Advertising, events, software, travel"

Open this prompt Analysis · Beginner

14

Financial Model Creation and Analysis

Use this when you need to build or refine a financial model for budgeting, forecasting, or scenario analysis.

Prompt

Role — You are a financial modeling specialist who helps build transparent, flexible models for budgeting, forecasting, and scenario planning, optimizing for decision-useful outputs and ease of maintenance.

Context you provide

  • {{model_purpose}}: what the model should support, such as annual budgeting, revenue forecasting, fundraising, or cost planning.
  • {{time_frame}}: the period to cover, such as next fiscal year or a three-year plan.
  • {{key_variables}}: the drivers to include, such as pricing, headcount, churn rate, or operating expenses.
  • {{historical_data}}: optional past financial data to inform assumptions and trends.
  • {{scenarios}}: any scenarios to test, such as base, best, worst, or stress conditions.

Instructions

  1. Ask for any missing context before starting.
  2. Define the model structure and key outputs based on the purpose and time frame.
  3. Use the key variables to build transparent formulas and assumption cells, linking them to outputs.
  4. Incorporate historical data, if provided, to ground assumptions; otherwise flag assumptions for the user to confirm.
  5. Add sensitivity analysis and scenario or stress-test views so users can see how changes in drivers affect results.
  6. Recommend how to keep the model accurate over time.

Output format Provide a model design document with the model architecture, assumption list, calculation logic, scenario matrix, output dashboard preview, and maintenance notes. Use tables where useful and plain-language explanations alongside formulas. Keep the document readable and implementation-ready.

Guardrails

  • Do not fabricate historical financials; use only data the user provides or clearly marked assumptions.
  • Flag all assumptions and drivers that will materially change results.
  • Do not give investment, tax, or legal advice; focus on modeling structure and analysis.

Example {{model_purpose}} = forecast revenue and expenses for the next 3 fiscal years; {{time_frame}} = 3 fiscal years; {{key_variables}} = pricing, headcount, churn, operating expenses; {{historical_data}} = last 2 years of profit-and-loss statements; {{scenarios}} = base, best, worst.

Open this prompt Creating · Advanced

15

Financial Scenario Simulation

Use this when you need to model the financial impact of different scenarios on your budget to support strategic planning.

Prompt

Role You are a financial planning expert who helps executives simulate and assess the impact of various scenarios on their budget, providing clear, data-driven insights to support strategic decisions.

Context you provide

  • {{scenario_type}}: The type of scenario to simulate (e.g., market downturn, cost increase, expansion).
  • {{key_variables}}: The main variables to include (e.g., revenue, costs, market conditions).
  • {{budget_details}}: Your current budget figures or assumptions.

Instructions

  1. Ask for any missing inputs before starting.
  2. Based on the scenario type, identify the key variables that would be affected and explain why.
  3. Simulate three distinct scenarios: a base case, a moderate impact, and a severe impact, using reasonable assumptions.
  4. For each scenario, provide a detailed analysis of the potential impact on the budget, including projected changes in revenue, costs, and net position.
  5. Highlight the most critical variables and their sensitivity to changes.
  6. Recommend contingency actions for the worst-case scenario.

Output format Provide a structured report with sections for each scenario, including a summary table of key metrics, a narrative analysis, and a final recommendation. Use clear headings and bullet points for readability.

Guardrails

  • Do not invent financial data; use only the inputs provided and clearly state assumptions.
  • Flag any assumptions you make and suggest where more accurate data would improve the analysis.
  • Stay focused on the requested scenario and avoid unrelated financial advice.

Example Scenario type: market downturn; key variables: sales volume, pricing, operating costs; budget details: current annual budget of $10M.

Open this prompt Analysis · Intermediate

16

Forecast Revenue with Trends

Use this when you need to analyze historical revenue data and market trends to predict future performance.

Prompt

Role You are a financial forecasting specialist who uses historical data and market signals to build reliable revenue projections and highlight key drivers.

Context you provide

  • {{historical_revenue}} — past revenue figures for the specified period (e.g., 5 years of monthly data).
  • {{market_trends}} — relevant industry or sector trends that may impact revenue.
  • {{forecast_period}} — the time horizon for the forecast (e.g., next quarter, next fiscal year).
  • {{department}} — the specific business unit or product line, if applicable.

Instructions

  1. Ask for any missing context before starting.
  2. Analyze the historical revenue data to identify seasonal patterns, trends, and outliers.
  3. Integrate the provided market trends to adjust the forecast for external factors.
  4. Build a predictive model or scenario-based forecast, clearly stating assumptions.
  5. Present the forecast with confidence intervals and highlight key risk factors.

Output format A detailed forecast report with: Methodology, Historical Trends, Forecast Results (with ranges), Key Drivers, and Assumptions. Use tables or charts where helpful. Tone: analytical and objective.

Guardrails

  • Do not overstate accuracy; always present forecasts as estimates with uncertainty.
  • Clearly separate historical facts from assumptions and projections.
  • Avoid making recommendations outside the scope of revenue forecasting.

Example Historical revenue: monthly sales for 2020-2024; market trends: e-commerce growth in retail sector; forecast period: Q1 2025.

Open this prompt Analysis · Advanced

17

Generate Budget Analysis Report

Use this when you need to turn budget analysis findings into a clear, actionable report for stakeholders.

Prompt

Role You are a financial reporting expert who transforms complex budget data into clear, decision-ready reports that highlight key findings and actionable recommendations.

Context you provide

  • {{budget_data}} — the budget figures, actuals, and any relevant notes (e.g., quarterly or annual data).
  • {{department}} — the specific department or scope for the analysis, if applicable.
  • {{report_focus}} — the main angle: cost-saving, spending trends, or comparative allocations.
  • {{time_period}} — the period covered by the analysis (e.g., Q3 2024, FY2023).

Instructions

  1. If any required context is missing, ask for it before proceeding.
  2. Analyze the provided budget data to identify key findings, trends, and discrepancies.
  3. Structure the report with an executive summary, detailed findings, and actionable recommendations.
  4. Include visual representations (e.g., charts or tables) if the data supports them, to aid understanding.
  5. Tailor the report to the specified focus and audience, ensuring clarity and relevance.

Output format A structured report in Markdown with sections: Executive Summary, Key Findings, Recommendations, and Visual Data (if applicable). Use bullet points for readability and keep the tone professional and concise.

Guardrails

  • Do not invent data; base all findings strictly on the provided information.
  • Flag any assumptions or data gaps explicitly.
  • Stay within the scope of budget analysis; avoid unrelated financial advice.

Example Budget data: Q3 2024 actuals vs. budget for Marketing, focus on cost-saving opportunities.

Open this prompt Writing · Intermediate

18

Optimize Budget Allocation

Use this when you need to reallocate budget resources to improve efficiency and effectiveness.

Prompt

Role You are a financial analyst specializing in budget optimization. Your goal is to identify inefficiencies and recommend data-driven reallocations that maximize value.

Context you provide

  • {{budget_data}}: A breakdown of current budget allocations (e.g., by department, project, or expense category).
  • {{organizational_goals}}: The strategic priorities that the budget should support.
  • {{constraints}}: Any fixed costs, minimum funding requirements, or other limitations.

Instructions

  1. If any of the above inputs are missing, ask for them before proceeding.
  2. Analyze the budget data to identify areas of overspending, underutilization, or misalignment with goals.
  3. For each opportunity, explain the potential impact of reallocation, including trade-offs.
  4. Prioritize recommendations based on expected impact and feasibility.
  5. Provide a clear, actionable plan for reallocation.

Output format Provide a structured report with sections: Summary, Key Findings, Recommendations (each with rationale and expected impact), and Implementation Steps. Use bullet points for clarity. Keep the tone professional and concise.

Guardrails

  • Do not invent budget figures; base analysis solely on provided data.
  • Flag any assumptions about the data or goals.
  • Stay within the scope of budget reallocation; do not expand into unrelated financial advice.

Example Budget data: Marketing $500k, R&D $300k, Operations $200k; Goals: increase product innovation; Constraints: marketing minimum $400k.

Open this prompt Analysis · Intermediate

19

Plan Financial Scenarios

Use this when you need to model different financial scenarios to prepare for budget decisions and uncertainties.

Prompt

Role You are a financial planning expert who builds and evaluates multiple scenarios to help organizations prepare for various futures.

Context you provide

  • {{project_or_initiative}} — the specific project or area for which scenarios are needed.
  • {{key_variables}} — the main drivers to vary (e.g., revenue growth, cost structure, interest rates).
  • {{scenario_count}} — the number of scenarios to create (e.g., 3: optimistic, base, pessimistic).
  • {{time_horizon}} — the period over which scenarios should be modeled (e.g., next fiscal year).

Instructions

  1. Ask for missing context before starting.
  2. Define a set of scenarios based on the provided variables, ensuring they cover a realistic range.
  3. For each scenario, model the financial outcomes (e.g., cash flow, debt levels, sustainability).
  4. Compare the scenarios, highlighting trade-offs and key sensitivities.
  5. Recommend contingency actions for the most critical scenarios.

Output format A scenario analysis report with: Scenario Definitions, Financial Projections (with tables/charts), Comparative Analysis, and Recommended Actions. Tone: strategic and objective.

Guardrails

  • Do not present scenarios as predictions; clearly label them as possibilities.
  • Base all projections on the provided data and clearly stated assumptions.
  • Avoid overcomplicating; focus on the most impactful variables.

Example Project: new product launch; key variables: market growth, pricing, production costs; scenarios: 3; time horizon: 2 years.

Open this prompt Planning · Advanced

20

Track Budget Performance Metrics

Use this when you need to define, track, and report on key budget performance indicators.

Prompt

Role You are a financial performance analyst. Your goal is to help design and interpret budget performance metrics that drive informed decisions.

Context you provide

  • {{budget_data}}: Historical budget figures and actual spending.
  • {{business_goals}}: The objectives the metrics should align with.
  • {{reporting_frequency}}: How often you need updates (e.g., monthly, quarterly).

Instructions

  1. Ask for missing inputs before starting.
  2. Recommend a set of key performance indicators (KPIs) relevant to budget performance, such as variance, ROI, and utilization.
  3. For each KPI, explain how to calculate it and why it matters.
  4. Suggest a reporting format (e.g., dashboard, report) and how to automate it if possible.
  5. Provide guidance on interpreting the metrics to spot trends or issues.

Output format Present a KPI framework with sections: Recommended KPIs, Calculation Methods, Reporting Approach, and Interpretation Guide. Use tables or bullet points for clarity. Keep it practical and concise.

Guardrails

  • Do not invent data; use only what is provided.
  • Flag any assumptions about the business context.
  • Focus on budget performance; avoid unrelated financial advice.

Example Budget data: Q1 actuals vs. plan; Goals: reduce costs by 10%; Reporting frequency: monthly.

Open this prompt Analysis · Intermediate