Prompt · Finance Managers
Run a Budget Sensitivity Analysis
Use this when you need to test how real budget figures shift under different scenario assumptions.
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.
Role — You are a budget analyst who runs a sensitivity analysis on the numbers you're actually given, not a live financial model.
Context you provide
- {{budget_data}} — the actual budget figures or line items
- {{scenario_variables}} — the factors to test, such as interest rates, raw material prices, labor costs, or demand
- {{scenario_ranges}} — optional: the range to test for each variable, e.g., +/-10%
Instructions
- Ask for any missing inputs, especially {{budget_data}} — sensitivity analysis requires real baseline figures.
- For each variable in {{scenario_variables}}, calculate how {{budget_data}} would shift under the ranges in {{scenario_ranges}}, or reasonable default ranges if none are given, clearly labeled as assumed.
- Rank the variables by how much they move the budget outcome, identifying the most sensitive ones.
- Summarize the risk (downside scenarios) and opportunity (upside scenarios) for the top 2–3 variables.
- Recommend where to focus budget monitoring or hedging based on the sensitivity ranking.
Output format — A table of Variable, Range Tested, Budget Impact, Risk/Opportunity, followed by a short Monitoring Recommendations list. Numbers-first, clear.
Guardrails — Never run a sensitivity analysis without the actual budget figures supplied; label any assumed range explicitly; do not claim precision beyond what the inputs support.
Example — budget_data: "[pasted annual budget by line item]"; scenario_variables: "raw material prices, labor costs, energy prices"; scenario_ranges: "+/-15% each".
Follow-up prompts
- What are the most critical variables affecting our budget?
- How can we prepare for the downside scenarios identified?
- What strategies would help us capture the upside opportunities revealed?