what if analysis
What‑if analysis is a decision‑making technique where you change key inputs in a model (like prices, growth rates, or costs) to see how those changes alter the outcome, so you can plan for best, base, and worst cases.
What is what‑if analysis?
What‑if analysis starts with a baseline model that links inputs (assumptions) to outputs (results such as profit, cash flow, or performance metrics). You then ask questions like “what if sales drop 20%?” or “what if our costs increase by 10%?” and recalculate the outcome. This turns a single forecast into a range of possible futures and helps you understand risk, upside, and trade‑offs instead of betting on one rigid plan.
Core steps (simple workflow)
- Clarify the question
- Example: “What if demand falls in Q4?” or “What do we need to hit a 15% margin?”
- Build or identify the model
- Use any structure where outputs depend on inputs: a spreadsheet, planning tool, or analytical model.
- Choose key variables
- Pick the small set of drivers that really matter (sales volume, price, unit cost, headcount, etc.).
- Change inputs, one or many
- Adjust the variables you picked, either individually or in combinations, and recalculate the model.
- Compare scenarios and interpret
- Look at how outputs move, identify which drivers have the largest impact, and note tipping points or danger zones.
- Decide what to do
- Use the insights to set guardrails, create contingency plans, or choose between strategies.
Main types of what‑if analysis
Many guides group what‑if analysis into three practical categories.
| Type | What it does | Typical question |
|---|---|---|
| Scenario analysis | Changes several variables together to represent distinct futures (e.g., “recession”, “strong growth”). | [7][1][3][5]“What happens to revenue, profit, and cash if demand drops 15% and prices fall 5%?” | [9][1][5]
| Sensitivity analysis | Changes one variable at a time to see how sensitive the result is to that driver. | [1][3]“If salary costs change 1%, how much does total expense change?” | [3][1]
| Goal seek style analysis | Works backwards from a target to the input needed to reach it. | [10][1][3]“What sales volume do we need to hit a 20% profit margin?” | [10][1][3]
Where it’s used today
What‑if analysis is widely used across business, technology, and data work.
- Business and finance
- Budgeting and forecasting (revenue, expenses, cash flow).
* Risk and contingency planning (supply shocks, demand drops, price changes).
* Strategic choices (market entry, pricing strategies, hiring plans).
- Spreadsheet and planning tools
- Built‑in features such as scenario managers, data tables, and goal‑seeking functions are common ways to implement what‑if analysis in everyday work.
- Computer science and data science
- Software architecture: testing “what if we change this component or move this service?” to see resilience and trade‑offs.
* Machine learning: examining how predictions shift when you tweak input features for a specific case, often visualized via partial dependence or individual conditional expectation plots.
Why it matters (and a quick mental example)
What‑if analysis is valuable because it makes uncertainty explicit and shows how much your results depend on the assumptions you quietly make. Instead of asking “Is our forecast right?”, you ask “How wrong can this forecast be before we get into trouble?” and “Which lever should we pull first if conditions change?”.
Imagine a small online store that currently earns 10,000 in monthly revenue with a 20% margin.
- It tests a best case (traffic up 30%, conversion stable), base case (current trends), and worst case (traffic flat, ads 15% more expensive).
- By comparing these, the owner sees that ad costs are the most sensitive driver and decides to cap bids if cost per click rises beyond a threshold.
If you tell me where you want to apply what‑if analysis (e.g., personal finance, a project, or a business plan), I can outline a tailored step‑by‑step setup and concrete scenarios for that case.
Information gathered from public forums or data available on the internet and portrayed here.