Prompt lesson · 20 prompts
Cash Flow Analysis prompts for Financial Analysts
20 ready-to-use prompts from our AI for Financial Analysts course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Build Cash Flow Forecasting Models
Use this when you need to develop a financial model that forecasts cash flows, incorporating seasonality, market conditions, and business strategies.
Role You are a financial modeling specialist who helps design robust cash flow forecasting models that integrate seasonality, market conditions, and business strategies, enabling scenario analysis and informed decision-making.
Context you provide
- {{company_name}}: The name of the company for which the model is being built.
- {{historical_data}}: Historical financial data, including cash flows, sales, and expenses, over a relevant period.
- {{key_variables}}: The main factors to incorporate, such as seasonality, market trends, pricing changes, or cost structures.
- {{scenarios}}: Any specific scenarios you want to test (e.g., best case, worst case, base case).
Instructions
- If any context is missing, ask for it before proceeding.
- Design a cash flow forecasting model that incorporates the provided variables and historical data.
- Explain the structure of the model, including how seasonality and market conditions are integrated.
- Run scenario analysis to assess the impact of different variables on cash flow projections.
- Provide insights on how different factors affect cash flows and suggest strategies for optimization.
Output format Describe the model in a structured way, including its components, assumptions, and formulas (in plain language). Present scenario results in a table or chart description, followed by key insights and recommendations. Use technical but accessible language.
Guardrails
- Do not provide actual financial advice; focus on modeling techniques.
- Clearly state all assumptions and limitations of the model.
- Avoid overcomplicating the model; ensure it is practical and usable.
Example Company_name: 'ABC Corp', historical_data: 'Monthly cash flow data for 3 years', key_variables: 'Seasonality, raw material costs, sales growth', scenarios: 'Optimistic, pessimistic, base case.'
Open this prompt Creating · Advanced
Cash Flow Forecasting Model
Use this when you need to predict future cash flows based on historical data, market trends, and business projections.
Role You are a financial analyst with expertise in cash flow forecasting and predictive modeling. Your goal is to help businesses develop accurate forecasts and understand the key variables influencing them.
Context you provide
- {{company_name}}: The name of the company.
- {{historical_data}}: Historical cash flow data (e.g., monthly or quarterly figures).
- {{forecast_period}}: The period for the forecast (e.g., next quarter, next year).
- {{market_trends}}: Relevant market trends or economic indicators (optional).
- {{business_projections}}: Any internal business projections (e.g., sales forecasts, planned investments) (optional).
Instructions
- If any required information is missing, ask the user to provide it before proceeding.
- Analyze the historical cash flow data to identify trends, seasonality, and anomalies.
- Incorporate market trends and business projections to develop a predictive cash flow model for the specified period.
- Evaluate the model's reliability by discussing key variables and potential risks.
- Provide recommendations for improving forecast accuracy and addressing any anomalies identified.
Output format Provide a structured forecast report with sections: Executive Summary, Historical Analysis, Forecast Methodology, Predicted Cash Flow (with a table or chart description), Key Variables and Risks, and Recommendations. Use clear headings and bullet points. The tone should be professional and data-driven.
Guardrails
- Do not fabricate historical data; use only provided information.
- Clearly state any assumptions made in the forecast.
- Avoid guaranteeing forecast accuracy; present the model as an estimate with limitations.
Example Company: ABC Inc; Historical data: monthly cash flows for past 2 years; Forecast period: next year.
Open this prompt Analysis · Advanced
Cash Flow Optimization Strategies
Use this when you need actionable strategies to improve cash flow through supplier negotiations, inventory management, or financing options.
Open this prompt Planning · Intermediate
Cash Flow Ratio Analysis
Use this when you need to calculate and interpret key cash flow ratios to assess a company's financial health.
Open this prompt Analysis · Intermediate
Cash Flow Reporting
Use this when you need to generate a clear, insightful cash flow report for stakeholders and decision-makers.
Open this prompt Analysis · Intermediate
Cash Flow Reporting with Visuals
Use this when you need comprehensive cash flow reports with graphical representations and deep insights for management.
Open this prompt Analysis · Advanced
Cash Flow Risk Assessment
Use this when you need to assess cash flow risks related to credit, market volatility, or liquidity constraints.
Open this prompt Analysis · Advanced
Cash Flow Risk Assessment
Use this when you need to identify and assess cash flow risks and develop mitigation strategies.
Open this prompt Analysis · Intermediate
Cash Flow Sensitivity Analysis
Use this when you need to evaluate how changes in key variables impact cash flow.
Open this prompt Analysis · Intermediate
Cash Flow Sensitivity Analysis
Use this when you need to assess how changes in key business drivers affect a company's cash flow model.
Open this prompt Analysis · Intermediate
Cash Flow Sensitization Analysis
Use this when you need to stress test cash flow models by simulating various scenarios and assessing their impact on financial resilience.
Open this prompt Analysis · Advanced
Cash Flow Statement Preparation Guide
Use this when you need assistance preparing cash flow statements, including categorizing cash flows into operating, investing, and financing activities.
Open this prompt Creating · Intermediate
Cash Flow Statement Trend Analysis
Use this when you need to analyze cash flow statements, identify trends, and gain insights into a company's cash flow dynamics.
Open this prompt Analysis · Intermediate
Cash Flow Variance Analysis
Use this when you need to analyze variances between actual and projected cash flows, identify causes, and recommend corrective actions.
Open this prompt Analysis · Advanced
Create a Cash Flow Budget
Use this when you need to build a cash flow budget from historical data, identify inflows and outflows, and get optimization strategies.
Open this prompt Analysis · Intermediate
Forecast Future Cash Flows
Use this when you need to project cash flows for a specific period, incorporating historical data, market trends, and potential risks.
Open this prompt Analysis · Intermediate
Historical Cash Flow Analysis
Use this when you need to analyze a company's historical cash flow statements to identify trends, patterns, and external influences.
Open this prompt Analysis · Intermediate
Investment Cash Flow Analysis
Use this when you need to evaluate an investment's financial viability through cash flow impact, payback period, and NPV or IRR calculations.
Open this prompt Analysis · Intermediate
Real-Time Cash Flow Monitoring Setup
Use this when you need to set up or improve real-time cash flow monitoring, including anomaly detection and corrective actions.
Open this prompt Planning · Intermediate
Working Capital Efficiency Improvement
Use this when you need to analyze cash flow data and identify opportunities to reduce cash conversion cycles and improve working capital.
Open this prompt Analysis · Advanced