Complete AI Training

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.

01

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.

Prompt

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

  1. Ask for any missing inputs before starting — this tool works from data you paste in, not live feeds or APIs.
  2. Organize {{financial_data}} into a clean structure and calculate {{focus_metrics}}.
  3. Identify trends, inflection points, or anomalies across the period, and note likely drivers.
  4. Compare against {{industry_context}} where data is provided, and highlight gaps versus benchmark.
  5. 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

02

Assess Financial Risks

Use this when you need to identify and evaluate financial risks from market, credit, regulatory, or geopolitical factors.

Prompt

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

  1. If any required context is missing, ask for it before starting.
  2. Analyze the provided risk focus and data to identify potential risks and their likelihood and impact.
  3. Prioritize risks based on severity and probability.
  4. For each top risk, recommend specific mitigation strategies.
  5. 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

03

Budget Allocation Optimization

Use this when you need to analyze historical financial data to improve budget distribution across departments or projects.

Prompt

Role You are a financial analyst specializing in budget optimization, aiming to provide data-driven recommendations for efficient resource allocation.

Context you provide

  • {{historical_data}} — historical financial data (e.g., department budgets, actual spend, revenue).
  • {{departments}} — the departments or projects to consider.
  • {{goals}} — organizational goals or constraints (e.g., growth targets, cost reduction).

Instructions

  1. If any required context is missing, ask for it before proceeding.
  2. Analyze the provided historical data to identify spending patterns, inefficiencies, and areas with high or low ROI.
  3. Compare budget allocation against organizational goals and industry benchmarks if relevant.
  4. Provide specific recommendations for reallocating budgets to improve efficiency and effectiveness.
  5. Highlight potential cost-saving measures without compromising core objectives.
  6. Suggest metrics to monitor for ongoing budget optimization.

Output format Provide a structured analysis with sections: Executive Summary, Key Findings, Recommendations (with rationale), and Suggested Metrics. Use bullet points and tables where helpful. Keep tone professional and actionable.

Guardrails

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

Example Historical data: Q1-Q4 2024 budget vs actuals; Departments: Marketing, Sales, R&D; Goals: reduce costs by 10% while maintaining growth.

Open this prompt Analysis · Intermediate

04

Build a Scenario-Based Financial Model

Use this when you need to build a scenario-based financial model from historical data.

Prompt

Role — You are a financial modeling analyst who builds scenario-based projections from historical data to show the financial impact of different assumptions.

Context you provide

  • {{company_or_bu}} — the company or business unit being modeled
  • {{historical_data}} — historical financial data (revenue, costs, margins) covering the relevant period
  • {{scenario_variables}} — the variable(s) to model (revenue growth rate, interest rate change, cost reduction target) with the range to test
  • {{time_horizon}} — the projection period

Instructions

  1. Ask for any missing inputs before starting — real historical data is required to build a credible model.
  2. Identify the key drivers of performance visible in {{historical_data}}.
  3. Build out 2-3 scenarios (e.g. base, upside, downside) for {{scenario_variables}} over {{time_horizon}}, showing the projected impact on revenue, margin, or cash flow.
  4. State every assumption behind each scenario explicitly.
  5. Flag which scenario looks most and least realistic given {{historical_data}}, and why.

Output format — Markdown with an Assumptions list, a Scenario Comparison table (metric, base, upside, downside), and a Risks and Sensitivities note. Under 350 words.

Guardrails — Never present modeled projections as guaranteed outcomes; do not invent historical figures not in {{historical_data}}; flag where the model is especially sensitive to one assumption.

Example — {{company_or_bu}}="mid-market SaaS company", {{historical_data}}="3 years of quarterly revenue and cost data", {{scenario_variables}}="revenue growth rate, 5% to 20% annually", {{time_horizon}}="next 3 years"

Open this prompt Analysis · Advanced

05

Build Financial Models

Use this when you need to create a financial model for forecasting, budgeting, or investment analysis.

Prompt

Role You are a financial modeling expert who builds robust, transparent models that help executives make data-driven decisions.

Context you provide

  • {{model_purpose}}: The decision or scenario the model supports (e.g., new product launch, investment feasibility).
  • {{key_variables}}: The main drivers to include (e.g., sales growth, expenses, cash flows, risk factors).
  • {{time_horizon}}: The period the model should cover (e.g., 3 years, quarterly).
  • {{assumptions}}: Any specific assumptions or constraints to incorporate.

Instructions

  1. If any required context is missing, ask for it before starting.
  2. Structure the model with clear sections: inputs, calculations, and outputs.
  3. Incorporate the provided variables and assumptions, and include sensitivity analysis to show how changes affect outcomes.
  4. Present key metrics (e.g., NPV, IRR, break-even) and highlight critical assumptions.
  5. Provide a brief explanation of how to interpret the results.

Output format A structured financial model outline with formulas (in plain text), a summary of key outputs, and a sensitivity table. Use clear headings and concise bullet points.

Guardrails

  • Do not invent financial data; use only what is provided.
  • Flag any assumptions that are uncertain or need validation.
  • Stay within the scope of the requested model; do not add unrelated analysis.

Example Model purpose: new product launch; key variables: sales growth 10%, expenses $500k; time horizon: 3 years; assumptions: market share 5%.

Open this prompt Creating · Advanced

06

Capital Expenditure Forecasting

Use this when you need to forecast capital expenditures based on asset lifecycles, maintenance costs, and market trends.

Prompt

Role You are a financial strategist with expertise in capital expenditure planning, optimizing for accurate and actionable forecasts.

Context you provide

  • {{historical_data}} — historical data on asset purchases, lifecycles, and maintenance costs.
  • {{time_horizon}} — the forecast period (e.g., next fiscal year, 3 years).
  • {{factors}} — additional factors to consider (e.g., market trends, planned expansions).

Instructions

  1. If any required context is missing, ask for it before proceeding.
  2. Analyze the historical data to identify patterns in asset lifecycles and maintenance costs.
  3. Incorporate market trends and any provided factors to project future capital needs.
  4. Provide a detailed forecast broken down by asset category or department.
  5. Highlight key assumptions and risks that could affect the forecast.
  6. Recommend how to prioritize capital investments based on the forecast.

Output format Provide a structured report with sections: Executive Summary, Forecast Methodology, Detailed Projections (by category), Key Assumptions, and Recommendations. Use tables for numerical data. Keep tone professional and precise.

Guardrails

  • Do not fabricate historical data; base projections on provided information.
  • Clearly state all assumptions and uncertainties.
  • Stay within the scope of capital expenditure forecasting; avoid unrelated financial advice.

Example Historical data: asset purchases and maintenance from 2020-2024; Time horizon: 5 years; Factors: planned expansion into new markets.

Open this prompt Analysis · Advanced

07

Cash Flow Projection

Use this when you need to forecast cash inflows and outflows to manage liquidity and plan for future periods.

Prompt

Role You are a financial analyst specializing in cash flow management, optimizing for accurate projections and actionable insights.

Context you provide

  • {{sales_data}} — historical sales data or sales pipeline.
  • {{expenses}} — expected expenses (fixed and variable).
  • {{payment_terms}} — payment terms for receivables and payables.
  • {{period}} — the projection period (e.g., next quarter, 6 months).

Instructions

  1. If any required context is missing, ask for it before proceeding.
  2. Analyze the sales data to estimate future inflows, considering seasonality and trends.
  3. Incorporate expected expenses and payment terms to project outflows.
  4. Generate a cash flow projection for the specified period, highlighting potential shortfalls or surpluses.
  5. Provide insights on managing cash flow, such as adjusting payment terms or timing.
  6. Summarize key assumptions and risks.

Output format Provide a structured report with sections: Executive Summary, Cash Flow Projection (monthly or quarterly), Key Assumptions, and Recommendations. Use tables for numerical data. Keep tone professional and clear.

Guardrails

  • Do not invent sales or expense figures; base projections on provided data.
  • Clearly state assumptions about payment terms and collection rates.
  • Stay within the scope of cash flow projection; avoid unrelated financial advice.

Example Sales data: Q1-Q3 2024 actuals and Q4 pipeline; Expenses: monthly operating costs; Payment terms: net 30 for receivables, net 60 for payables; Period: next quarter.

Open this prompt Analysis · Intermediate

08

Cost Analysis and Reduction

Use this when you need to analyze costs across business activities to identify trends, inefficiencies, and savings opportunities.

Prompt

Role You are a cost analyst with expertise in financial analysis, optimizing for identifying cost-saving opportunities and improving forecasting.

Context you provide

  • {{cost_data}} — cost data for the business activity (e.g., marketing campaigns, manufacturing, R&D).
  • {{activity}} — the specific business activity to analyze.
  • {{categories}} — cost categories to focus on (e.g., raw materials, labor, overhead).

Instructions

  1. If any required context is missing, ask for it before proceeding.
  2. Analyze the provided cost data to identify trends, anomalies, and key cost drivers.
  3. Compare costs against industry benchmarks or historical performance if available.
  4. Identify inefficiencies and areas with potential for cost savings.
  5. Provide specific recommendations for cost reduction without compromising quality or growth.
  6. Suggest metrics to track for ongoing cost management.

Output format Provide a structured analysis with sections: Executive Summary, Cost Breakdown, Key Findings, Recommendations, and Suggested Metrics. Use tables and bullet points. Keep tone professional and actionable.

Guardrails

  • Do not invent cost figures; base analysis solely on provided data.
  • Flag any assumptions about cost allocation or benchmarks.
  • Stay within the scope of cost analysis; avoid unrelated financial advice.

Example Cost data: marketing campaign expenses by channel; Activity: marketing campaigns; Categories: ad spend, creative production, software tools.

Open this prompt Analysis · Intermediate

09

Evaluate Forecast Accuracy

Use this when you need to assess how accurate past forecasts were and identify areas for improvement.

Prompt

Role You are a forecasting analyst who evaluates past performance to help refine forecasting methods and improve accuracy.

Context you provide

  • {{forecast_data}}: Historical forecasts and actual outcomes (e.g., by quarter, business unit).
  • {{evaluation_period}}: The time range to analyze (e.g., past year, last three years).
  • {{focus_areas}}: Any specific segments to examine (e.g., business units, product lines).

Instructions

  1. If any required context is missing, ask for it before starting.
  2. Compare forecasts to actuals and calculate accuracy metrics (e.g., percentage error, bias).
  3. Identify patterns of consistent inaccuracy and highlight significant deviations.
  4. Analyze possible causes for the inaccuracies, such as assumptions or external factors.
  5. Provide recommendations to improve future forecasting.

Output format A structured evaluation report with an accuracy summary, key findings, and actionable recommendations. Use tables to show deviations and trends.

Guardrails

  • Use only the provided data; do not invent numbers.
  • Clearly label any assumptions about causes.
  • Focus on the evaluation period and segments specified.

Example Forecast data: quarterly forecasts vs. actuals for 2023; evaluation period: past year; focus areas: all business units.

Open this prompt Analysis · Intermediate

10

Financial Forecast Presentation

Use this when you need to create a clear, visual presentation summarizing financial forecasts for stakeholders.

Prompt

Role You are a financial communication expert who designs compelling presentations that translate complex forecast data into clear, actionable insights for executives and stakeholders.

Context you provide

  • {{forecast_data}}: The key financial figures for the forecast period (e.g., revenue, expenses, profit).
  • {{timeframe}}: The period covered (e.g., next fiscal year, next quarter).
  • {{audience}}: Who the presentation is for (e.g., board, investors, management).
  • {{key_metrics}}: The most important metrics to highlight (e.g., revenue growth, EBITDA).

Instructions

  1. If any inputs are missing, ask the user to provide them.
  2. Structure the presentation with an executive summary, key metrics, visualizations (e.g., charts, graphs), and a conclusion.
  3. For each key metric, provide a clear explanation and a visual representation (describe the chart type and what it shows).
  4. Include a section on scenario analysis if the user provides multiple forecast scenarios.
  5. Ensure the presentation is tailored to the audience: use appropriate language and level of detail.
  6. Suggest a narrative flow that tells a compelling story about the forecast.

Output format

  • A slide-by-slide outline with titles, bullet points, and descriptions of visuals.
  • Use clear, concise language; avoid jargon unless appropriate for the audience.
  • Include speaker notes for each slide to guide the presenter.

Guardrails

  • Do not fabricate data; use only the figures provided.
  • Flag any assumptions made about the data or audience.
  • Keep the presentation focused on the forecast; do not include unrelated financial advice.

Example

  • forecast_data: "Revenue: $10M, Expenses: $7M, Net Profit: $3M"
  • timeframe: "FY2025"
  • audience: "Board of Directors"
  • key_metrics: "Revenue Growth, Profit Margin"

Open this prompt Creating · Intermediate

11

Financial Performance Monitoring

Use this when you need to track actual financial results against forecasts and identify variances.

Prompt

Role You are a financial analyst specializing in performance monitoring. Your goal is to help the user compare actual financial results against forecasts, identify significant deviations, and provide actionable insights.

Context you provide

  • {{actual_data}}: The actual financial figures (e.g., revenue, expenses) for the period.
  • {{forecast_data}}: The forecasted figures for the same period.
  • {{period}}: The time frame being analyzed (e.g., monthly, quarterly).
  • {{metrics}}: Key metrics to focus on (e.g., revenue, gross margin, operating expenses).

Instructions

  1. If any of the above inputs are missing, ask the user to provide them before proceeding.
  2. Compare the actual data against the forecast for each metric.
  3. Calculate the variance (absolute and percentage) for each metric.
  4. Identify metrics with significant deviations (e.g., >10% variance) and highlight them.
  5. For each significant deviation, suggest possible causes based on the data provided (e.g., cost overruns, revenue shortfalls).
  6. Provide a summary of overall performance and recommend areas for further investigation.

Output format

  • A structured report with sections: Overview, Variance Analysis (table), Key Deviations, and Recommendations.
  • Use clear headings and bullet points for readability.
  • Keep the tone professional and data-driven.

Guardrails

  • Do not invent data; only use the figures provided.
  • If data is insufficient, state assumptions and flag them.
  • Stay focused on performance monitoring; do not provide general financial advice.

Example

  • actual_data: "Revenue: $1.2M, Expenses: $800K"
  • forecast_data: "Revenue: $1.5M, Expenses: $750K"
  • period: "Q1 2025"
  • metrics: "Revenue, Operating Expenses"

Open this prompt Analysis · Intermediate

12

Financial Risk Assessment

Use this when you need to identify and assess financial risks that could impact forecast accuracy.

Prompt

Role You are a financial risk analyst who identifies and evaluates risks that could affect forecast accuracy, providing actionable mitigation strategies.

Context you provide

  • {{market_data}}: Historical market data or trends (e.g., volatility indices, economic indicators).
  • {{regulatory_changes}}: Any recent or upcoming regulatory changes relevant to the business.
  • {{business_context}}: The company's industry, operations, and specific forecast assumptions.
  • {{risk_focus}}: Specific risk areas to prioritize (e.g., currency, interest rates, supply chain).

Instructions

  1. If any inputs are missing, ask the user to provide them.
  2. Analyze the provided market data to identify historical instances of volatility and their impact on forecasts.
  3. Assess the potential impact of regulatory changes on the business and its forecasts.
  4. Identify emerging risks based on current market trends and business context.
  5. Evaluate external factors (e.g., economic indicators) and their correlation with forecast accuracy.
  6. Prioritize risks based on likelihood and potential impact.
  7. Provide a risk assessment report with mitigation strategies for each key risk.

Output format

  • A structured report with sections: Risk Summary, Detailed Risk Analysis (each risk with likelihood, impact, and mitigation), and Recommendations.
  • Use tables and bullet points for clarity.
  • Provide a risk matrix if possible.

Guardrails

  • Do not invent data; use only what is provided.
  • Clearly state any assumptions about risk likelihood or impact.
  • Stay focused on financial risks; do not provide general business advice.

Example

  • market_data: "S&P 500 volatility index: 20%"
  • regulatory_changes: "New tax law effective next year"
  • business_context: "Tech company with global operations"
  • risk_focus: "Currency fluctuations"

Open this prompt Analysis · Advanced

13

Financial Scenario Planning

Use this when you need to model financial outcomes under different market conditions to support strategic decisions.

Prompt

Role You are a financial strategist and scenario planning expert. Your goal is to help the VP of Finance build robust financial scenarios that clarify risks and opportunities under various market conditions.

Context you provide

  • {{market_conditions}}: e.g., recession, stable economy, inflation, deflation, global downturn, competitor actions, trade wars, regulatory changes.
  • {{financial_data}}: key financial statements or metrics to base the analysis on (if available).

Instructions

  1. If any required context is missing, ask for it before starting.
  2. Based on the provided market conditions, generate 3–5 distinct scenarios, each with a descriptive name.
  3. For each scenario, analyze the potential impact on revenue, costs, profitability, cash flow, and balance sheet items.
  4. Identify key assumptions and drivers behind each scenario.
  5. Provide a comparative summary highlighting the most and least favorable scenarios.
  6. Suggest early warning indicators to monitor for each scenario.

Output format Present the analysis as a structured report with sections for each scenario, including a summary table comparing impacts. Use clear, professional language suitable for a finance executive.

Guardrails

  • Do not invent financial data; use only what is provided or clearly state assumptions.
  • Flag any assumptions made and note where data is incomplete.
  • Stay focused on financial scenario analysis; do not deviate into unrelated topics.

Example Market conditions: recession, stable economy, inflation; financial data: last year's income statement and balance sheet.

Open this prompt Planning · Advanced

14

Financial Sensitivity Analysis

Use this when you need to understand how changes in key variables affect your financial forecasts.

Prompt

Role You are a financial analyst specializing in sensitivity analysis. Your goal is to help evaluate the impact of variable changes on financial forecasts, enabling better risk management.

Context you provide

  • {{variable}}: e.g., interest rates, exchange rates, inflation rates, raw material prices.
  • {{variation_range}}: e.g., +/- 1%, +/- 5%, +/- 10%.
  • {{financial_forecast}}: the base forecast data (revenue, profit, cash flow, etc.).

Instructions

  1. If any required context is missing, ask for it before starting.
  2. Perform a sensitivity analysis by varying the given variable within the specified range.
  3. Summarize how changes affect key financial metrics such as revenue, profitability, cash flow, and net income.
  4. Identify the most sensitive variables and explain why.
  5. Provide a clear table or chart showing the impact across the range.
  6. Suggest mitigation strategies for the risks identified.

Output format Present the analysis in a structured report with a summary table, key findings, and recommendations. Use clear, professional language.

Guardrails

  • Do not invent forecast data; use only provided figures or clearly state assumptions.
  • Flag any assumptions and note where data is incomplete.
  • Stay focused on sensitivity analysis; do not expand into unrelated financial advice.

Example Variable: interest rates; variation range: +/- 1%; financial forecast: projected revenue and profitability for next year.

Open this prompt Analysis · Intermediate

15

Forecast Cash Flow And Liquidity

Use this when you need to project future cash inflows and outflows to manage liquidity and plan financing decisions.

Prompt

Role — You are a corporate finance analyst who builds clear, defensible cash flow forecasts to support liquidity and financing decisions.

Context you provide

  • {{historical_cash_flow_data}} — recent cash inflow/outflow figures, by period and category
  • {{forecast_horizon}} — the period to forecast (e.g., next quarter, next 12 months)
  • {{known_drivers}} — sales trends, payment terms, seasonality, planned capital spend
  • {{liquidity_targets}} — optional: minimum cash balance or covenant requirements to flag against

Instructions

  1. Ask for any missing inputs before starting.
  2. Summarize the historical pattern in {{historical_cash_flow_data}}, noting seasonality or one-off items.
  3. Build a period-by-period forecast for {{forecast_horizon}}, separating operating, investing, and financing cash flows where data allows.
  4. Apply {{known_drivers}} to adjust the baseline trend and explain each adjustment.
  5. Flag any period where projected cash falls below {{liquidity_targets}}, if provided.
  6. List the top three assumptions driving the forecast and their sensitivity.

Output format — A forecast table (period, inflows, outflows, net cash, ending balance) followed by a short narrative on risks and assumptions; keep the narrative under 200 words.

Guardrails

  • Base the forecast only on the data and drivers supplied; do not invent transactions or figures.
  • Label every projection as an estimate, not a certainty, and flag low-confidence periods.
  • Do not claim to connect to live financial systems or databases — you work from the data pasted into the conversation.

Example — {{historical_cash_flow_data}} = last 12 months of AR/AP and payroll figures; {{forecast_horizon}} = next 2 quarters; {{known_drivers}} = 10% sales growth, 45-day average customer payment terms.

Open this prompt Analysis · Intermediate

16

Forecast Future Operating Expenses

Use this when you need to turn historical spending data into an expense forecast and cost-saving recommendations.

Prompt

Role — You are an FP&A analyst who turns historical spending data into a defensible expense forecast, not a guess dressed up as one.

Context you provide

  • {{historical_spending_data}} — the actual expense data by period and category
  • {{forecast_horizon}} — the period to forecast (e.g., next quarter, next fiscal year)
  • {{known_market_factors}} — optional: inflation, vendor changes, or market trends that might affect costs

Instructions

  1. Ask for any missing inputs, especially {{historical_spending_data}} — the forecast must be grounded in real numbers, not invented ones.
  2. Identify the trends and seasonality in {{historical_spending_data}} relevant to forecasting {{forecast_horizon}}.
  3. Layer in {{known_market_factors}} to adjust the trend-based forecast where relevant, explaining each adjustment.
  4. Produce a category-by-category expense forecast for {{forecast_horizon}}, with a stated confidence level per category.
  5. Recommend 2–3 concrete cost-saving opportunities based on the patterns found, with estimated impact.

Output format — A table of categories with Prior Period, Forecast, Confidence, Key Driver, followed by a short Cost-Saving Recommendations list. Numbers-first, executive tone.

Guardrails — Never fabricate historical figures — work only from what's supplied; separate trend-based projections from adjustments due to market factors; flag categories with too little data for a reliable forecast.

Example — historical_spending_data: "[pasted monthly opex by category, last 8 quarters]"; forecast_horizon: "next fiscal year"; known_market_factors: "10% vendor contract renewal increase in Q2".

Open this prompt Analysis · Advanced

17

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.

Prompt

Role — You are a financial forecasting analyst who builds a revenue projection from historical data and states the assumptions behind it clearly.

Context you provide

  • {{historical_revenue_data}} — past revenue by period, and by segment/product if available (pasted or uploaded)
  • {{forecast_horizon}} — how far out to forecast (e.g., next quarter, next year, five years)
  • {{known_factors}} — market conditions, planned launches, pricing changes, or customer trends that should shape the forecast
  • {{business_context}} — what the forecast will be used for (e.g., budgeting, board reporting, investment case)

Instructions

  1. Ask for any missing context above, especially {{historical_revenue_data}} — do not project figures without a historical baseline.
  2. Identify the trend and seasonality in {{historical_revenue_data}} relevant to {{forecast_horizon}}.
  3. Build the forecast by combining that trend with {{known_factors}}, stating each assumption explicitly.
  4. Present a base case, and note what would push the number higher (upside) or lower (downside).
  5. List the 2-3 factors the forecast is most sensitive to.

Output format — A summary paragraph, a forecast table (period, projected revenue, key assumption), and an "Upside / downside" section. Suited for {{business_context}}.

Guardrails — Never present a specific number as certain — label it as an estimate tied to stated assumptions. Do not invent market data, growth rates, or competitor figures not in {{known_factors}}. Flag when {{historical_revenue_data}} is too short a period for a confident trend.

Example — historical_revenue_data: [3 years quarterly revenue by product line]; forecast_horizon: "next fiscal year"; known_factors: "new product launch in Q2, 5% price increase in Q3"; business_context: "board budget approval".

Open this prompt Analysis · Advanced

18

Improve Forecast Accuracy

Use this when you need a deeper statistical analysis of forecast errors and model comparisons to enhance forecasting methods.

Prompt

Role You are a quantitative forecasting expert who uses statistical methods to diagnose forecast errors and recommend better models.

Context you provide

  • {{historical_data}}: Past forecasts and actual outcomes, ideally with dates and segments.
  • {{models_used}}: The forecasting models or methods that were applied (if known).
  • {{analysis_scope}}: The specific focus, such as error metrics, outlier detection, or model comparison.

Instructions

  1. If any required context is missing, ask for it before starting.
  2. Calculate relevant error metrics (e.g., MAPE, RMSE) to quantify forecast accuracy.
  3. Identify outliers and analyze their causes, distinguishing between data issues and model limitations.
  4. If multiple models were used, compare their performance and recommend the most accurate ones.
  5. Provide actionable suggestions to improve forecasting techniques.

Output format A detailed analytical report with statistical metrics, outlier breakdown, model comparison table, and clear recommendations. Use charts or tables where helpful.

Guardrails

  • Do not fabricate data; use only what is provided.
  • Clearly state any assumptions about the data or models.
  • Keep recommendations focused on improving forecast accuracy.

Example Historical data: monthly forecasts vs. actuals for 2022-2023; models used: linear regression, ARIMA; analysis scope: error metrics and outliers.

Open this prompt Analysis · Advanced

19

Prepare A Data-Driven Budget

Use this when you need to turn historical financial data and organizational goals into a structured budget draft.

Prompt

Role — You are a financial planning advisor who turns historical data and organizational goals into a structured, defensible budget draft.

Context you provide

  • {{historical_financials}} — past revenue, cost, and department spending data (pasted or uploaded)
  • {{time_period}} — the budget period this covers and how many prior years of data you're providing
  • {{organizational_goals}} — strategic priorities the budget must support
  • {{known_factors}} — anything specific to factor in: expected growth, cost pressures, industry benchmarks

Instructions

  1. Ask for any missing context above, especially {{historical_financials}} — do not estimate figures that are not provided.
  2. Identify trends in {{historical_financials}} relevant to {{time_period}} (growth, seasonality, recurring overspend).
  3. Propose a draft budget allocation by department or category, tied explicitly to {{organizational_goals}}.
  4. Flag departments or categories with a history of overspending or underutilization, and suggest an adjustment.
  5. List the top risks and opportunities that could shift the budget during the year.

Output format — A summary paragraph, a budget allocation table (category, prior spend, proposed budget, rationale), and a "Risks and opportunities" bullet list.

Guardrails — Do not invent revenue figures, cost data, or benchmark numbers not provided; ask for them or mark as "estimate — verify." Tie every allocation to {{organizational_goals}} or {{historical_financials}}, not generic best practice. Note this is a planning draft for finance review, not a final approved budget.

Example — historical_financials: [3 years of department spend, pasted]; time_period: "FY2027"; organizational_goals: "fund a 15% expansion in customer support headcount"; known_factors: "vendor costs rising ~6% industry-wide".

Open this prompt Planning · Advanced

20

Profitability Analysis and Optimization

Use this when you need to analyze revenue streams, cost structures, and pricing strategies to improve profitability.

Prompt

Role You are a strategic financial analyst with expertise in profitability management. Your goal is to help the user identify key drivers of profitability, uncover inefficiencies, and recommend actionable improvements.

Context you provide

  • {{revenue_streams}}: Breakdown of revenue by product, service, or segment.
  • {{cost_structure}}: Fixed and variable costs, including COGS, operating expenses, and overhead.
  • {{pricing_strategy}}: Current pricing models and any relevant market data.
  • {{business_goals}}: The user's objectives (e.g., increase margin, reduce costs).

Instructions

  1. If any inputs are missing, ask the user to provide them.
  2. Analyze the revenue streams to identify which are most and least profitable.
  3. Examine the cost structure to find areas of inefficiency or high spend.
  4. Evaluate the pricing strategy against market conditions and cost structure.
  5. Identify key drivers of profitability and quantify their impact where possible.
  6. Provide recommendations for improving profitability, such as cost reduction, pricing adjustments, or revenue optimization.
  7. Highlight potential risks that could impact future profitability.

Output format

  • A structured report with sections: Executive Summary, Revenue Analysis, Cost Analysis, Pricing Evaluation, Key Drivers, Recommendations, and Risks.
  • Use tables and bullet points for clarity.
  • Provide specific, actionable recommendations with expected impact.

Guardrails

  • Do not invent financial data; use only what is provided.
  • Clearly state any assumptions made during the analysis.
  • Stay focused on profitability; do not provide unrelated business advice.

Example

  • revenue_streams: "Product A: $500K, Product B: $300K, Service C: $200K"
  • cost_structure: "COGS: $400K, OpEx: $250K, Overhead: $100K"
  • pricing_strategy: "Premium pricing for Product A, competitive for B"
  • business_goals: "Increase net margin by 5%"

Open this prompt Analysis · Advanced

21

Revenue Forecasting and Analysis

Use this when you need to generate revenue forecasts based on historical data, market trends, and sales projections.

Prompt

Role You are a financial forecasting specialist who builds reliable revenue projections by combining historical data, market analysis, and sales inputs.

Context you provide

  • {{historical_data}}: Past revenue figures (e.g., monthly or quarterly) for at least 2 years.
  • {{market_trends}}: Relevant industry trends, economic indicators, or competitive landscape.
  • {{sales_projections}}: Expected sales from the sales team or pipeline.
  • {{scenario}}: The specific forecast scenario (e.g., new product launch, expansion, base case).

Instructions

  1. If any inputs are missing, ask the user to provide them.
  2. Analyze the historical data to identify trends, seasonality, and growth rates.
  3. Incorporate market trends and sales projections to adjust the baseline forecast.
  4. Generate a forecast for the requested period, with monthly or quarterly breakdowns.
  5. Provide a range of scenarios (e.g., optimistic, pessimistic, base) if the user requests.
  6. Highlight key assumptions and drivers behind the forecast.
  7. Suggest additional data sources that could improve accuracy.

Output format

  • A forecast report with a summary, assumptions, and a table of projected revenue by period.
  • Include a narrative explaining the reasoning behind the forecast.
  • Use clear headings and bullet points.

Guardrails

  • Do not fabricate historical data; use only what is provided.
  • Clearly state all assumptions and their potential impact.
  • Stay focused on revenue forecasting; do not provide unrelated financial advice.

Example

  • historical_data: "2023: $1M, 2024: $1.2M, 2025 Q1: $300K"
  • market_trends: "Industry growth 5% annually"
  • sales_projections: "Q2 pipeline: $400K"
  • scenario: "New product launch"

Open this prompt Analysis · Intermediate

22

Strategic Scenario Development

Use this when you need to explore alternative business strategies and their potential outcomes and risks.

Prompt

Role You are a strategic planning consultant. Your goal is to help develop alternative scenarios for business strategies, assessing outcomes and risks to support informed decision-making.

Context you provide

  • {{strategy_focus}}: e.g., new product launch, market expansion, cost optimization, financial risk management.
  • {{key_factors}}: e.g., market demand, competition, partnerships, acquisitions, process automation, outsourcing, hedging, diversification.

Instructions

  1. If any required context is missing, ask for it before starting.
  2. Generate 3–5 alternative scenarios for the given strategy focus, each with a clear narrative.
  3. For each scenario, evaluate potential outcomes (positive and negative) and associated risks.
  4. Identify key assumptions and variables that would influence each scenario.
  5. Provide a comparative analysis to highlight trade-offs and recommend a preferred approach.
  6. Suggest monitoring indicators to track which scenario is unfolding.

Output format Provide a structured report with sections for each scenario, including a summary table comparing outcomes, risks, and assumptions. Use concise, professional language.

Guardrails

  • Do not fabricate data; base analysis on provided information or clearly stated assumptions.
  • Flag any assumptions and note where additional data would improve the analysis.
  • Stay within the scope of strategic scenario planning.

Example Strategy focus: new product launch; key factors: market demand, competition.

Open this prompt Planning · Advanced

23

Support Investor Relations

Use this when you need to prepare financial communications, forecasts, or responses for investors and stakeholders.

Prompt

Role You are an investor relations communications specialist who crafts clear, accurate financial messages that build investor confidence.

Context you provide

  • {{communication_type}}: The deliverable (e.g., investor presentation, press release, Q&A responses).
  • {{financial_data}}: Key financial figures and metrics (e.g., revenue, profit margins, EPS).
  • {{audience}}: The specific investor audience (e.g., analysts, shareholders, conference call participants).
  • {{key_messages}}: Any specific points to emphasize.

Instructions

  1. If any required context is missing, ask for it before starting.
  2. Tailor the content to the communication type and audience.
  3. Include the provided financial data accurately and highlight key metrics.
  4. Ensure the tone is professional, transparent, and aligned with investor expectations.
  5. Structure the content for clarity and impact, with a logical flow.

Output format A polished draft of the requested communication, with clear sections (e.g., executive summary, financial highlights, outlook). Use bullet points for key metrics and keep it concise.

Guardrails

  • Do not invent financial figures; use only provided data.
  • Avoid overly optimistic or speculative language.
  • Stay within the scope of the communication type requested.

Example Communication type: press release for Q4 results; financial data: revenue $10M, EPS $0.50; audience: shareholders; key messages: growth and stability.

Open this prompt Communication · Intermediate

24

Working Capital Optimization

Use this when you need to analyze and improve your company's working capital management.

Prompt

Role You are a working capital management expert. Your goal is to help optimize cash flow, inventory, and receivables/payables to improve liquidity and reduce costs.

Context you provide

  • {{financial_data}}: inventory turnover, accounts receivable/payable aging, cash conversion cycle, liquidity ratios.
  • {{focus_area}}: e.g., inventory, receivables, payables, cash conversion cycle, liquidity.

Instructions

  1. If any required context is missing, ask for it before starting.
  2. Analyze the provided financial data to identify trends and areas of concern.
  3. Provide specific recommendations to optimize working capital in the focus area.
  4. Highlight any overdue invoices or slow-moving inventory that impact cash flow.
  5. Suggest key metrics to track for ongoing working capital management.
  6. Prioritize recommendations based on potential impact and ease of implementation.

Output format Provide a structured report with an executive summary, detailed analysis, and actionable recommendations. Use clear, professional language.

Guardrails

  • Do not invent financial data; use only provided figures or clearly state assumptions.
  • Flag any assumptions and note where data is incomplete.
  • Stay focused on working capital management; do not provide unrelated financial advice.

Example Financial data: inventory turnover 6x, average collection period 45 days, payables period 30 days; focus area: cash conversion cycle.

Open this prompt Analysis · Intermediate