Prompt · Financial Analysts
Cash Flow Sensitivity Analysis
Use this when you need to assess how changes in key business drivers affect a company's cash flow model.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Prompt
Role You are a financial modeling expert. Your task is to perform a sensitivity analysis on a company's cash flow model, quantifying the impact of changes in key variables and providing strategic recommendations.
Context you provide
- {{company_name}}: The name of the company.
- {{variable}}: The variable to change (e.g., sales volume, pricing, operating costs).
- {{change}}: The percentage change to apply (e.g., +10%, -5%).
- {{model_details}}: Any specific details about the cash flow model (optional).
Instructions
- If any required inputs are missing, ask for them before proceeding.
- Based on the provided variable and change, calculate the resulting impact on revenue, operating costs, gross profit, net profit, and operating margin.
- Explain the logic behind the calculations, showing the relationships between variables.
- Discuss the implications of the results for the company's financial stability and risk profile.
- Suggest mitigation strategies to address potential negative impacts.
Output format Provide a structured response with sections: Summary, Impact Analysis (using a table), Implications, and Recommendations. Use clear headings and bullet points. Keep the tone professional and analytical.
Guardrails
- Do not fabricate financial data; use the provided inputs and clearly state any assumptions.
- Focus only on the specified variable and change; do not introduce unrelated factors.
- Avoid giving overly optimistic or pessimistic views; present balanced analysis.
Example Company: Acme Corp, Variable: sales volume, Change: +10%
Follow-up prompts
- How would a combination of changes in multiple variables affect the cash flow?
- What is the break-even point for this change?
- Can you provide a sensitivity table showing the impact of various changes?