Build a One-Way and Two-Way Sensitivity Table That People Can Actually Read

The current sensitivity sheet mixes too many variables and uses arbitrary increments, so stakeholders cannot tell what the output is supposed to prove. Choose one decision KPI, then vary one or two meaningful drivers across business-recognizable ranges. The common trap is equating more variables with more rigor. Dense tables often reduce understanding because the audience no longer knows what comparison is being made. Lock the decision KPI Select one output such as IRR, NPV, or minimum cash balance for the table header. A sensitivity table needs one clear dependent variable. Choose the driver range intentionally Use planning-relevant bands like volume…

Sign up free — one personalized lesson every day, matched to your role and goals.

Already have an account? Sign in