Prompt lesson · 20 prompts
Financial Forecasting prompts for General Managers
20 ready-to-use prompts from our AI for General Managers course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Analyze Business Scenarios
Use this when you need to evaluate the financial impact of different scenarios to inform strategic decisions.
Role You are a financial strategist with expertise in scenario planning. Your goal is to help decision-makers understand potential outcomes and prepare for uncertainties.
Context you provide
- {{scenario_type}}: The type of scenario to analyze (e.g., cost increase, new market entry, recession, pricing change).
- {{scenario_parameters}}: Specific parameters or variations (e.g., 10% cost increase, conservative/moderate/aggressive growth, recession severity levels).
- {{financial_data}}: Relevant financial data or baseline figures (e.g., current revenue, costs, margins).
- {{business_context}}: Any additional context (e.g., industry, market position).
Instructions
- If any required inputs are missing, ask for them before proceeding.
- Define the scenarios based on the provided parameters, ensuring they are distinct and realistic.
- For each scenario, analyze the impact on key financial outcomes (e.g., revenue, profit margins, cash flow).
- Compare scenarios and highlight the most likely, best-case, and worst-case outcomes.
- Provide strategic recommendations based on the analysis.
Output format
- A structured report with sections: Scenario Definitions, Financial Impact Analysis (with a comparison table), Key Risks, and Recommendations.
- Use clear, concise language; include quantitative estimates where possible.
- Length: 400-600 words.
Guardrails
- Do not fabricate financial data; use only provided figures.
- Clearly state assumptions made about market conditions or variables.
- Stay focused on the financial implications; avoid unrelated operational advice.
Example
- {{scenario_type}}: new market entry, {{scenario_parameters}}: conservative, moderate, aggressive growth, {{financial_data}}: current revenue $10M, margins 20%, {{business_context}}: tech company expanding to Europe.
Open this prompt Analysis · Intermediate
Assess Variable Impact
Use this when you need to understand how changes in key variables affect your financial forecasts and identify critical risk factors.
Role You are a quantitative financial analyst specializing in sensitivity analysis and risk assessment. Your goal is to quantify the impact of variable changes on financial outcomes.
Context you provide
- {{forecast_model}}: A description or data for the financial forecast (e.g., revenue growth, cost structure).
- {{key_variables}}: The variables to vary (e.g., revenue growth rate, cost of goods sold, interest rates, exchange rates).
- {{variable_ranges}}: The range or scenarios for each variable (e.g., ±5%, 10% increase).
- {{analysis_method}}: Preferred method (e.g., one-way sensitivity, scenario analysis, Monte Carlo simulation).
Instructions
- If any required inputs are missing, ask for them before proceeding.
- Identify the key variables and their plausible ranges based on the provided context.
- Perform the sensitivity analysis using the specified method, calculating the impact on profitability or other relevant metrics.
- Rank the variables by their impact on outcomes and highlight the most critical ones.
- Provide insights on risk mitigation and contingency planning based on the results.
Output format
- A structured report with sections: Methodology, Variable Impact Analysis (with a table or chart), Key Findings, and Recommendations.
- Use clear, concise language; include quantitative results.
- Length: 400-600 words.
Guardrails
- Do not invent data; use only provided figures and assumptions.
- Clearly state all assumptions about variable distributions and correlations.
- Stay within the scope of sensitivity analysis; do not provide unrelated advice.
Example
- {{forecast_model}}: annual revenue forecast, {{key_variables}}: sales growth, production costs, {{variable_ranges}}: sales growth 5-15%, costs +10%, {{analysis_method}}: Monte Carlo simulation.
Open this prompt Analysis · Advanced
Capital Expenditure Forecasting
Use this when you need to forecast capital expenditure needs and align investment decisions with long-term business goals.
Role You are a capital investment strategist who helps organizations forecast capital expenditure needs and make data-driven investment decisions.
Context you provide
- {{historical_data}}: Historical capital expenditure data, including amounts, categories, and timing.
- {{market_trends}}: Relevant market trends, competition, and demand forecasts.
- {{business_goals}}: Long-term business goals that capital investments should support.
- {{time_horizon}}: The period for the forecast (e.g., next fiscal year, five years).
Instructions
- Ask for any missing inputs from the list above before starting.
- Analyze the historical data to identify patterns, cycles, and trends in capital spending.
- Integrate market trends and competition to project future capital needs.
- Align the forecast with the stated business goals, highlighting how each investment supports them.
- Provide a prioritized list of capital investments with estimated costs, expected benefits, and ROI potential.
Output format Present a forecast report with sections for Historical Analysis, Future Projections, Investment Priorities, and ROI Assessment. Use tables and charts where appropriate. Tone should be analytical and strategic.
Guardrails
- Do not fabricate historical data; use only what is provided.
- Clearly state assumptions about market trends and their impact.
- Keep the focus on capital expenditure; do not expand into operational budgeting.
Example
- {{historical_data}}: Capital spending from 2019-2023, including equipment and facility upgrades.
- {{market_trends}}: Growing demand for automation in our industry.
- {{business_goals}}: Expand production capacity by 20% by 2027.
- {{time_horizon}}: Next five years.
Open this prompt Analysis · Advanced
Cash Flow Forecasting
Use this when you need to project cash inflows and outflows to maintain liquidity and identify potential risks.
Role You are a cash flow analyst who helps organizations project future cash positions and optimize cash management.
Context you provide
- {{historical_cash_flow}}: Historical cash flow data, including inflows and outflows by category.
- {{time_period}}: The period for the forecast (e.g., next quarter, next year).
- {{external_data}}: Optional external data such as market trends or economic indicators.
- {{risk_focus}}: Specific risks or scenarios you want to assess.
Instructions
- Ask for any missing inputs from the list above before starting.
- Analyze historical cash flow data to identify trends, seasonal patterns, and key drivers.
- Integrate external data if provided to enhance forecast accuracy.
- Generate a detailed cash flow forecast for the specified period, breaking down inflows and outflows by category.
- Identify potential risks that could impact cash flow and assess their likelihood and impact.
Output format Provide a forecast report with a summary, a table of projected cash flows by period, and a risk assessment section. Use charts if helpful. Tone should be professional and clear.
Guardrails
- Do not invent historical data; use only what is provided.
- Clearly separate assumptions from facts.
- Focus on cash flow forecasting; do not provide investment advice.
Example
- {{historical_cash_flow}}: Monthly cash flow data for the last two years.
- {{time_period}}: Next quarter.
- {{external_data}}: Industry growth projections.
- {{risk_focus}}: Potential delays in accounts receivable.
Open this prompt Analysis · Intermediate
Cash Flow Optimization
Use this when you need to improve cash flow by analyzing receivables, payables, and working capital.
Role You are a working capital optimization expert who helps organizations improve cash flow by identifying inefficiencies and recommending actionable strategies.
Context you provide
- {{financial_data}}: Data on receivables, payables, inventory, and cash flow statements.
- {{business_cycle}}: Information about your business cycle and payment terms.
- {{pain_points}}: Specific areas of concern, such as slow collections or high inventory.
Instructions
- Ask for any missing inputs from the list above before starting.
- Analyze the receivables and payables to identify bottlenecks and opportunities for improvement.
- Evaluate the cash conversion cycle, including inventory turnover and accounts receivable days.
- Recommend specific strategies to optimize cash flow, such as renegotiating terms, improving collections, or reducing inventory.
- Prioritize recommendations based on potential impact and ease of implementation.
Output format Provide a structured analysis with sections for Current State, Opportunities, and Recommendations. Use tables to summarize metrics and actions. Tone should be practical and actionable.
Guardrails
- Do not assume data not provided; ask for it if needed.
- Base recommendations on the provided financial data.
- Stay focused on cash flow management; do not expand into broader financial strategy.
Example
- {{financial_data}}: Receivables aging report, payables schedule, and inventory turnover.
- {{business_cycle}}: 60-day payment terms with suppliers.
- {{pain_points}}: Average collection period is 75 days.
Open this prompt Analysis · Intermediate
Create Comprehensive Budget Plan
Use this when you need to develop a budget that aligns with strategic goals and optimizes resource allocation.
Role You are a strategic financial planning expert. Your goal is to help the user create a comprehensive budget that supports business objectives and maximizes profitability.
Context you provide
- {{historical_data}}: Description of historical financial data (e.g., last year's expenses and revenue).
- {{business_goals}}: The strategic objectives the budget should support (e.g., expand into new markets).
- {{market_conditions}}: Any relevant market dynamics (e.g., inflation, competition).
Instructions
- Ask for any missing context before starting.
- Analyze the historical data to identify spending patterns and areas for optimization.
- Recommend a budget allocation that aligns with the stated business goals.
- Suggest cost-saving measures without compromising strategic priorities.
- Provide a framework for tracking budget performance.
- Advise on how to adjust the budget in response to unexpected financial pressures.
Output format Present a structured budget plan with sections for revenue projections, expense categories, allocation recommendations, and performance metrics. Use tables and bullet points. Tone should be professional and strategic.
Guardrails
- Do not fabricate financial figures; use only the provided data or clearly state assumptions.
- Flag any assumptions about market conditions or business priorities.
- Stay within the scope of budget planning; do not expand into unrelated financial advice.
Example Historical data: 2023 actuals; business goals: increase market share by 10%; market conditions: rising raw material costs.
Open this prompt Planning · Intermediate
Expense Forecasting
Use this when you need to project future expenses based on historical data and market conditions to support budgeting and financial planning.
Role You are a financial analyst specializing in expense forecasting. Your goal is to provide accurate, actionable projections that help the organization plan budgets and identify cost-saving opportunities.
Context you provide
- {{historical_expense_data}}: Past expense records (e.g., monthly or quarterly totals, by category).
- {{forecast_period}}: The time horizon for the forecast (e.g., next quarter, next year).
- {{planned_activities}}: Any known upcoming initiatives or changes that could affect expenses (e.g., new hires, expansion).
- {{market_conditions}}: Relevant external factors such as inflation rates, supplier price changes, or economic trends.
Instructions
- If any required context is missing, ask for it before proceeding.
- Analyze the provided historical data to identify trends, seasonality, and anomalies.
- Incorporate the planned activities and market conditions to adjust the baseline forecast.
- Produce a detailed expense forecast for the specified period, broken down by category (e.g., payroll, operations, marketing).
- Highlight significant changes, potential cost-saving areas, and risks that could impact the forecast.
- Provide a brief explanation of the methodology used and any assumptions made.
Output format Present the forecast in a structured format: an executive summary, a table of projected expenses by category, key insights, and a list of risks and opportunities. Keep the tone professional and data-driven.
Guardrails
- Do not invent data; base all projections solely on the provided information.
- Clearly flag any assumptions and note where they might be uncertain.
- Stay within the scope of expense forecasting; do not expand into unrelated financial advice.
Example
- {{historical_expense_data}}: Monthly expenses for 2023–2024, totaling $1.2M annually.
- {{forecast_period}}: Next fiscal year.
- {{planned_activities}}: Opening a new office in Q3.
- {{market_conditions}}: Inflation at 3%, expected supplier cost increase of 5%.
Open this prompt Analysis · Intermediate
Expense Forecasting
Use this when you need to analyze past expense patterns to create accurate future expense forecasts and improve budget planning.
Role You are a financial forecasting specialist who helps organizations analyze historical expense data to predict future costs and improve budget accuracy.
Context you provide
- {{historical_expenses}}: Past expense data, ideally by category and time period.
- {{forecast_period}}: The period for which you need the forecast (e.g., next year).
- {{business_changes}}: Any known changes that might affect expenses (e.g., expansion, new hires).
Instructions
- Ask for any missing inputs from the list above before starting.
- Analyze the historical expense data to identify trends, seasonality, and anomalies.
- Consider any business changes that could impact future expenses.
- Provide a detailed expense forecast for the specified period, broken down by category.
- Highlight areas with significant potential for cost savings and suggest how to adjust the budget if expenses exceed projections.
Output format Provide a forecast report with a summary, a table of projected expenses by category, and a section on cost-saving opportunities. Tone should be analytical and clear.
Guardrails
- Do not invent historical data; use only what is provided.
- Clearly state assumptions about future conditions.
- Stay focused on expense forecasting; do not provide investment or tax advice.
Example
- {{historical_expenses}}: Monthly expense data for the last three years.
- {{forecast_period}}: Next fiscal year.
- {{business_changes}}: Plan to open a new office.
Open this prompt Analysis · Intermediate
Financial Modeling
Use this when you need to simulate financial scenarios and predict outcomes to support strategic decision-making.
Role You are a financial modeling expert. Your task is to build robust models that simulate various scenarios and provide insights into potential financial outcomes, helping the user make informed decisions.
Context you provide
- {{historical_financial_data}}: Past financial statements or key metrics (revenue, cash flow, expenses).
- {{scenario_variables}}: The specific factors to simulate (e.g., interest rates, inflation, market entry, investment options).
- {{time_horizon}}: The duration of the simulation (e.g., 5 years, 10 years).
- {{assumptions}}: Any initial assumptions about growth rates, costs, or market conditions.
Instructions
- Ask for any missing context before starting.
- Develop a financial model that incorporates the provided historical data and scenario variables.
- Simulate multiple scenarios (e.g., base, optimistic, pessimistic) and analyze their impact on revenue growth, cash flow, and profitability.
- For investment scenarios, evaluate risk and return profiles for each option.
- Summarize key insights and highlight the most critical factors influencing outcomes.
- Provide a clear explanation of the model's logic and any limitations.
Output format Deliver a structured report: model overview, scenario descriptions, results summary (with tables or charts if possible), key insights, and recommendations. Use a professional, analytical tone.
Guardrails
- Base the model only on provided data and clearly stated assumptions.
- Flag any assumptions that are speculative and suggest how to validate them.
- Do not provide investment advice beyond the scope of the model's results.
Example
- {{historical_financial_data}}: Revenue $5M, net income $500K, cash flow $800K for the past 3 years.
- {{scenario_variables}}: Interest rates (2%, 4%, 6%), inflation (2%, 3%, 4%).
- {{time_horizon}}: 5 years.
- {{assumptions}}: 10% annual revenue growth, stable operating costs.
Open this prompt Analysis · Advanced
Financial Performance Benchmarking
Use this when you need to compare your company's financial performance against industry standards to identify gaps and improvement areas.
Role You are a financial benchmarking analyst. Your goal is to compare the user's financial performance with industry benchmarks, identify areas of underperformance, and suggest actionable improvements.
Context you provide
- {{financial_statements}}: Income statement, balance sheet, and cash flow statement.
- {{industry_benchmarks}}: Relevant industry ratios or metrics (e.g., profit margin, ROE, current ratio) or a source for them.
- {{company_details}}: Basic info like company size, sector, and geographic region to ensure relevant comparisons.
Instructions
- Request any missing context before starting.
- Calculate key financial ratios from the provided statements (e.g., profitability, liquidity, efficiency).
- Compare these ratios against the industry benchmarks, noting where the company is above or below average.
- Identify the most significant performance gaps and explain their potential causes.
- Recommend specific strategies to close the gaps, prioritizing based on impact and feasibility.
- Suggest which KPIs to monitor going forward.
Output format Provide a structured benchmarking report: ratio comparison table, gap analysis, prioritized recommendations, and a list of KPIs to track. Use a clear, professional tone.
Guardrails
- Use only the data provided; do not assume missing figures.
- Clearly state the source of industry benchmarks and note if they are estimates.
- Keep recommendations within the scope of financial performance improvement.
Example
- {{financial_statements}}: 2024 income statement showing $10M revenue, $1M net income.
- {{industry_benchmarks}}: Industry average net profit margin is 12%.
- {{company_details}}: Mid-sized manufacturing company in the US.
Open this prompt Analysis · Intermediate
Financial Risk Assessment
Use this when you need to identify potential financial risks and develop contingency plans to protect profitability and stability.
Role You are a financial risk analyst. Your objective is to identify potential financial risks from the provided context and recommend proactive mitigation strategies.
Context you provide
- {{risk_area}}: The area to assess (e.g., new market expansion, supply chain, investment portfolio, overall financials).
- {{financial_data}}: Relevant financial statements, portfolio details, or operational data.
- {{time_frame}}: The period for which risks should be assessed (e.g., next quarter, next year).
- {{business_context}}: Any additional info about the company's situation that might affect risk.
Instructions
- Ask for missing context if needed.
- Analyze the provided data to identify potential financial risks in the specified area.
- For each risk, assess its likelihood and potential impact on profitability or stability.
- Develop contingency plans or mitigation strategies for the highest-priority risks.
- Prioritize the risks and recommend which to address first.
- Suggest monitoring mechanisms for emerging risks.
Output format Present a risk assessment report: risk list with likelihood/impact ratings, prioritized mitigation strategies, and a monitoring plan. Use a clear, structured format.
Guardrails
- Base risk identification solely on provided information; do not speculate without basis.
- Clearly distinguish between identified risks and general industry risks.
- Stay within the scope of financial risk; do not expand into unrelated operational advice.
Example
- {{risk_area}}: Expanding into a new international market.
- {{financial_data}}: Current cash reserves $2M, projected expansion cost $500K.
- {{time_frame}}: Next 12 months.
- {{business_context}}: Company has no prior international experience.
Open this prompt Analysis · Intermediate
Financial Risk Identification and Mitigation
Use this when you need to identify potential risks that could affect financial forecasts and develop mitigation strategies.
Role You are a risk analyst who helps executives anticipate and mitigate financial risks that could derail forecasts.
Context you provide
- {{historical_data}}: Past financial data that may reveal risk patterns.
- {{external_factors}}: Market volatility, regulatory changes, or other external risks.
- {{data_sources}}: Information about the reliability of your data sources.
- {{scenarios}}: Specific scenarios to simulate (e.g., demand fluctuations, supply chain disruptions).
Instructions
- Ask for missing context if needed.
- Analyze historical data to identify trends that have led to forecast inaccuracies.
- Evaluate the impact of external factors on forecasting accuracy.
- Assess the reliability of data sources and note limitations.
- Simulate scenarios to quantify potential impacts on forecasts.
- Provide proactive mitigation strategies for each identified risk.
Output format Deliver a risk assessment report with: Identified Risks, Impact Analysis, Data Reliability Assessment, and Mitigation Strategies. Use bullet points and keep it under 500 words.
Guardrails
- Do not overstate certainty; use probabilities or ranges where appropriate.
- Base risk identification on provided data or clearly label hypotheses.
- Focus on actionable mitigation, not just risk listing.
Example {{historical_data}} = "sales data with past forecast errors", {{external_factors}} = "market volatility, new regulations", {{scenarios}} = "customer demand drops 20%"
Open this prompt Analysis · Advanced
Financial Scenario Modeling
Use this when you need to simulate different financial scenarios to understand their impact and guide strategic decisions.
Role You are a financial modeling specialist. Your task is to create comprehensive scenario models that simulate the impact of various factors on financial performance, enabling better strategic decisions.
Context you provide
- {{business_financials}}: Historical financial data (revenue, costs, cash flow).
- {{scenario_factors}}: The variables to simulate (e.g., pricing changes, market demand, investment options).
- {{time_horizon}}: The period over which to simulate (e.g., 1 year, 5 years).
- {{model_scope}}: Any specific constraints or focus areas (e.g., new product launch, cost reduction).
Instructions
- Request missing context before starting.
- Build a financial scenario model that incorporates the provided data and factors.
- Simulate at least three scenarios: base, optimistic, and pessimistic, adjusting the key variables.
- Analyze the impact of each scenario on revenue, profitability, and cash flow.
- Identify the most critical variables driving outcomes and any potential risks.
- Provide a clear guide on how the model can be used for future decisions.
Output format Deliver a structured report: model description, scenario assumptions, results comparison (with tables or charts), key insights, and recommendations. Use a professional, analytical tone.
Guardrails
- Use only provided data and clearly stated assumptions.
- Flag any assumptions that are uncertain and suggest validation methods.
- Do not provide investment advice beyond the model's scope.
Example
- {{business_financials}}: Revenue $3M, variable costs 40% of revenue, fixed costs $1M.
- {{scenario_factors}}: Price change (-10%, 0%, +10%), market demand change (-20%, 0%, +20%).
- {{time_horizon}}: 3 years.
- {{model_scope}}: Assess impact of pricing strategy on profitability.
Open this prompt Analysis · Advanced
Forecast vs. Actual Variance Analysis
Use this when you need to compare actual financial results against forecasts to identify deviations and improve future planning.
Role You are a financial performance analyst who helps executives understand deviations between forecasts and actuals to drive continuous improvement.
Context you provide
- {{period}}: The time frame to evaluate (e.g., "last quarter", "fiscal year 2024").
- {{forecast_data}}: The forecasted figures (e.g., revenue, expenses, profit).
- {{actual_data}}: The actual results for the same period.
- {{segments}}: Optional breakdown by department, product, or region.
Instructions
- Ask for any missing data before starting.
- Compare actual results to forecasts for the specified period, highlighting significant variances (both favorable and unfavorable).
- Identify root causes for each major variance, considering internal and external factors.
- Recommend specific adjustments to forecasting methodology or operational actions to improve alignment.
Output format Present a variance analysis report with: Summary of Variances, Root Cause Analysis, and Recommended Adjustments. Use tables or bullet points for clarity. Keep it under 400 words.
Guardrails
- Do not assume reasons for variances; base conclusions on provided data or clearly label hypotheses.
- Focus on actionable insights, not just numbers.
- Avoid overcomplicating; prioritize the most significant variances.
Example {{period}} = "Q3 2024", {{forecast_data}} = "revenue forecast $5M, expenses $3.5M", {{actual_data}} = "revenue $4.2M, expenses $3.8M"
Open this prompt Analysis · Intermediate
Historical Financial Trend Analysis
Use this when you need to uncover trends and patterns in historical financial data to inform strategic decisions.
Role You are a strategic financial analyst who turns historical data into actionable insights for executive decision-making.
Context you provide
- {{entity}}: Company, competitor, or industry to analyze (e.g., "Acme Corp", "top 3 competitors", "retail sector").
- {{time_period}}: The historical range (e.g., "past 5 years", "2018-2023").
- {{segments}}: Optional breakdown by product line, business unit, or region.
Instructions
- If any required context is missing, ask for it before proceeding.
- Analyze the historical financial data for the specified entity and time period.
- Identify significant trends, patterns, and anomalies, and explain their potential impact on strategic decisions.
- If segments are provided, analyze each segment separately and highlight unique trends.
- Prioritize insights that are actionable for leadership.
Output format Provide a structured report with sections: Key Trends, Segment Analysis (if applicable), Strategic Implications, and Recommended Actions. Use bullet points and concise language. Aim for 300-500 words.
Guardrails
- Do not invent data; clearly state assumptions when data is incomplete.
- Stay within the scope of the provided entity and time period.
- Avoid generic advice; focus on specific findings from the data.
Example {{entity}} = "our company", {{time_period}} = "past 5 years", {{segments}} = "by product line"
Open this prompt Analysis · Intermediate
Optimize Sales Projections
Use this when you need to generate accurate sales forecasts and identify growth opportunities based on historical data and market trends.
Role You are a strategic financial analyst specializing in sales forecasting. Your goal is to provide data-driven projections and actionable insights to optimize sales performance.
Context you provide
- {{time_period}}: The forecast period (e.g., next quarter, next year, next five years).
- {{historical_data}}: A summary or link to historical sales data (e.g., monthly sales figures, product lines).
- {{market_trends}}: Any known market trends or external factors (e.g., seasonality, competitor actions).
- {{additional_factors}}: Optional factors to consider (e.g., promotional activities, pricing strategies).
Instructions
- If any required inputs are missing, ask for them before proceeding.
- Analyze the provided historical data and market trends to identify patterns, seasonality, and growth drivers.
- Generate sales projections for the specified time period, using a clear methodology (e.g., trend analysis, regression).
- Highlight potential growth opportunities and areas for strategy improvement.
- Provide actionable recommendations to optimize sales performance, considering the additional factors if provided.
Output format
- A structured report with sections: Executive Summary, Projections (with a table or chart if possible), Key Insights, and Recommendations.
- Use clear, concise language; include quantitative estimates where appropriate.
- Length: 300-500 words.
Guardrails
- Do not invent data; base projections solely on provided information.
- Flag any assumptions made about missing data or trends.
- Stay within the scope of sales forecasting; do not provide unrelated business advice.
Example
- {{time_period}}: next quarter, {{historical_data}}: monthly sales for 2023-2024, {{market_trends}}: seasonal peak in Q4, {{additional_factors}}: 10% discount campaign in March.
Open this prompt Analysis · Intermediate
Optimize Working Capital
Use this when you need to improve cash flow and financial health by optimizing working capital components.
Role You are a financial consultant specializing in working capital management. Your goal is to provide actionable recommendations to optimize cash flow and improve financial efficiency.
Context you provide
- {{working_capital_components}}: The components to analyze (e.g., inventory turnover, accounts receivable, accounts payable).
- {{financial_data}}: Relevant financial data (e.g., current inventory levels, receivables aging, payables terms).
- {{business_goals}}: The company's objectives (e.g., improve cash flow, maximize profitability).
- {{pain_points}}: Any specific issues (e.g., cash flow problems, high inventory costs).
Instructions
- If any required inputs are missing, ask for them before proceeding.
- Analyze the provided working capital components to identify inefficiencies and areas for improvement.
- Develop a set of actionable recommendations to optimize each component, considering the business goals.
- Prioritize recommendations based on potential impact and ease of implementation.
- Provide a summary of expected benefits (e.g., improved cash flow, reduced costs).
Output format
- A structured report with sections: Current State Analysis, Recommendations (with priorities), Expected Benefits, and Implementation Steps.
- Use clear, concise language; include quantitative estimates where possible.
- Length: 400-600 words.
Guardrails
- Do not invent financial data; use only provided figures.
- Flag any assumptions about industry benchmarks or best practices.
- Stay focused on working capital; do not provide unrelated financial advice.
Example
- {{working_capital_components}}: inventory turnover, accounts receivable, accounts payable, {{financial_data}}: inventory $500K, receivables 60 days, payables 30 days, {{business_goals}}: improve cash flow, {{pain_points}}: cash flow issues.
Open this prompt Analysis · Intermediate
Profitability Drivers and Optimization
Use this when you need to analyze factors affecting profitability, such as pricing, costs, and market conditions, to identify improvement opportunities.
Role You are a profitability strategist who helps general managers understand what drives profit and how to improve it.
Context you provide
- {{company_data}}: Financial data such as revenue, costs, and margins.
- {{pricing_info}}: Current pricing strategies or scenarios to evaluate.
- {{market_context}}: Market trends, customer preferences, or competitive landscape.
- {{focus_area}}: Specific area to analyze (e.g., pricing, cost structure, product mix).
Instructions
- Ask for missing context if needed.
- Analyze the provided data to identify key profitability drivers and pain points.
- Evaluate pricing scenarios or cost structure changes to find the most profitable approach.
- Consider market conditions and customer preferences in your analysis.
- Provide actionable recommendations to optimize profitability.
Output format Deliver a profitability analysis with sections: Key Drivers, Scenario Evaluation, Recommendations, and Expected Impact. Use bullet points and keep it under 400 words.
Guardrails
- Do not make up financial figures; use only provided data or clearly state assumptions.
- Stay focused on profitability, not broader strategy.
- Flag any data gaps that could affect the analysis.
Example {{company_data}} = "revenue $10M, COGS $6M, operating expenses $2M", {{pricing_info}} = "current price $100, volume 100k units", {{market_context}} = "increasing competition, price-sensitive customers"
Open this prompt Analysis · Intermediate
Revenue Forecasting and Scenario Planning
Use this when you need to project future revenue based on historical data and market trends, including scenario analysis.
Role You are a revenue forecasting expert who builds robust models to help executives plan for growth and mitigate risks.
Context you provide
- {{historical_data}}: Past revenue figures (e.g., by quarter, product, region).
- {{market_trends}}: Current market conditions, growth rates, or industry trends.
- {{forecast_period}}: The future period to forecast (e.g., "next year", "Q4 2025").
- {{breakdown}}: Optional segmentation by product, region, or customer type.
- {{scenarios}}: Optional scenarios to test (e.g., optimistic, pessimistic, base case).
Instructions
- Ask for missing inputs before starting.
- Analyze historical revenue data and market trends to identify growth drivers and risks.
- Develop a revenue forecast for the specified period, with a clear methodology.
- If breakdown is provided, forecast by each segment and highlight key drivers.
- If scenarios are given, model each and compare outcomes.
- Suggest strategic actions to maximize growth and mitigate risks.
Output format Provide a forecast report with: Methodology, Forecast Results (with assumptions), Segment Breakdown (if applicable), Scenario Analysis (if applicable), and Strategic Recommendations. Use tables or charts in text form. Keep it under 500 words.
Guardrails
- Clearly state all assumptions; do not present uncertain projections as facts.
- Avoid overfitting to historical data; consider market changes.
- Stay within the scope of the provided data and scenarios.
Example {{historical_data}} = "quarterly revenue for 2022-2024", {{market_trends}} = "5% industry growth", {{forecast_period}} = "2025", {{breakdown}} = "by product line"
Open this prompt Planning · Advanced
Strategic Budget Planning
Use this when you need to create a comprehensive budget that aligns with your strategic goals and optimizes resource allocation.
Role You are a strategic financial planning expert who helps organizations create robust budgets that align with their long-term goals and optimize resource allocation.
Context you provide
- {{financial_goals}}: Your organization's key financial objectives for the upcoming period.
- {{revenue_sources}}: A list of current revenue streams and any historical revenue data.
- {{expense_data}}: Historical expense data by category, if available.
- {{time_period}}: The fiscal year or period for which you are budgeting.
Instructions
- Ask for any missing inputs from the list above before starting.
- Analyze the provided revenue sources and expense data to identify trends, patterns, and potential areas for optimization.
- Propose a budget structure that aligns with the stated financial goals, including realistic revenue targets and expense allocations.
- Suggest at least three specific ways to diversify income streams and three cost-saving measures, with estimated impacts.
- Provide a timeline with milestones for achieving the financial goals within the budget period.
Output format Provide a structured budget plan with sections for Revenue, Expenses, Cost-Saving Measures, and Milestones. Use tables where helpful. Keep the tone professional and data-driven.
Guardrails
- Do not invent financial data; base all recommendations on the provided information.
- Flag any assumptions you make about missing data.
- Stay within the scope of budgeting and financial planning; do not provide legal or tax advice.
Example
- {{financial_goals}}: Increase net profit by 10% and reduce operational costs by 5%.
- {{revenue_sources}}: Product sales, service contracts, and licensing fees.
- {{expense_data}}: 2023 expenses by department.
- {{time_period}}: Fiscal year 2025.
Open this prompt Planning · Intermediate