Sensitivity tables show up in almost every serious financial model, and almost every business owner's first reaction to one is to skip past it. That's a mistake — it's usually the single most useful page in the model, once you know what you're looking at.
What a Sensitivity Table Is Actually Doing
A sensitivity table takes one output you care about — profit, cash flow, ROI — and shows how it changes as you adjust one or two key assumptions, like sales volume or price. Instead of a single forecast number, you get a grid showing the range of outcomes depending on which assumptions turn out to be right.
Why a Single Forecast Number Is Misleading on Its Own
Every financial projection is built on assumptions that could be wrong in either direction. A single “best guess” forecast hides how sensitive the outcome actually is to those assumptions. A business where profit barely moves even if sales come in 20% lower than expected is in a fundamentally different risk position than one where the same shortfall wipes out profitability entirely — even if both show the same base-case forecast.
How to Read the Grid
Most sensitivity tables are laid out with one variable across the top (say, sales volume at different levels) and another down the side (say, price or cost per unit), with the resulting outcome — profit, for example — filled into each cell. Reading it is simply a matter of finding your expected case in the middle, then looking at how far the numbers move as you scan outward toward the more pessimistic and more optimistic cells.
What to Actually Look For
The two things worth focusing on: how much the outcome changes for a realistic swing in the input (not an extreme one), and whether the numbers stay positive across a reasonable range of “things go somewhat wrong” scenarios. A model that only works in the best case isn't a plan — it's a hope.
Why This Matters to Whoever's Reading Your Numbers
Lenders and investors read sensitivity tables specifically to understand downside risk, and a business owner who can walk through their own table confidently — explaining what happens if a key assumption doesn't hold — comes across as someone who genuinely understands their business, not just someone who built a spreadsheet.