Sensitivity Analysis Template
Flex one or two inputs and watch the output move in a data table — the classic what-if grid, built for you.
Prefer the spreadsheet? Portfolio Efficient Frontier · Tornado Sensitivity Analysis · Price Elasticity & Profit-Optimal Price · Scenario Planner Template · Sensitivity Analysis Template · Weighted Decision Matrix (AHP) · Markdown Planner Template — free with an account, 3 free downloads.
See inside before you download: Portfolio Efficient Frontier · Tornado Sensitivity Analysis · Price Elasticity & Profit-Optimal Price · Scenario Planner Template · Sensitivity Analysis Template · Weighted Decision Matrix (AHP) · Markdown Planner Template
| Price \ Volume | 8k | 10k | 12k |
|---|---|---|---|
| £40 | £160,000 | £200,000 | £240,000 |
| £45 | £200,000 | £250,000 | £300,000 |
| £50 | £240,000 | £300,000 | £360,000 |
What's inside this template
How it works
It loads with realistic sample data so you see a finished result immediately — nothing to set up.
Type over the sample values, or upload your own file and map the columns in a couple of clicks.
The What-If tool recalculates instantly. Export to Excel or send a live link.
Related templates
Common questions
What is sensitivity analysis for?
Finding which assumption your answer actually depends on. Flex each input in turn and the one that moves the output most is the one worth researching properly — the rest can stay estimates.
What's the difference between one-way and two-way?
One-way flexes a single input and reports the output. Two-way flexes a pair and produces a grid, which shows how the two interact rather than just their separate effects.
How is this different from scenario planning?
Sensitivity moves one thing at a time to isolate what matters. Scenarios move a coherent set together — 'recession' changes volume, price and collection timing at once — to describe a plausible world.
Start from the Sensitivity / what-if template
Open it with sample data, swap in your own, and export in seconds — no formulas, no blank page.
Use this template free →