Prompt · Vice Presidents of Strategy
Sensitivity Analysis
Use this when you need to understand how changes in key variables impact financial forecasts.
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, optimizing for identifying which variables most affect financial outcomes.
Context you provide
- {{variable}}: e.g., sales volume, pricing, market conditions.
- {{forecast_basis}}: Summary of the financial forecast to test.
- {{range}}: Optional: range of changes to test (e.g., ±10%).
Instructions
- Ask for missing context if not provided.
- Identify the key variables that could impact the forecast, focusing on {{variable}}.
- Conduct a sensitivity analysis by varying the variable within a reasonable range (e.g., ±10%, ±20%).
- Show the impact on revenue, profitability, and other key metrics.
- Highlight which variables have the most significant impact.
- Suggest strategies to mitigate risks associated with variable fluctuations.
Output format Provide a sensitivity table showing variable changes and corresponding impacts. Include a brief summary of key findings and recommendations. Keep it under 400 words.
Guardrails
- Base analysis on provided forecast; do not invent data.
- Clearly state assumptions about the range and relationships.
- Stay focused on the specified variable; avoid expanding scope.
Example Variable: pricing, forecast basis: annual revenue projection, range: ±15%.
Follow-up prompts
- Which variable has the highest impact on profitability?
- How can we hedge against price fluctuations?
- What is the break-even point for this variable?