Sensitivity Analysis Calculator guide
Sensitivity analysis changes selected assumptions while holding others constant to identify the variables that matter most.
The preserved calculator includes one- and two-variable tables, elasticity, NPV, tornado analysis, charts, and exports.
How to use the sensitivity analysis calculator
- Enter current amounts: Use current, documented values from the same relevant period.
- Enter assumptions: Use realistic rates, percentages, periods, and costs where applicable.
- Review the full result: Review the primary estimate together with its supporting measures.
- Stress-test risk: Model less favorable timing, value, cost, or rate assumptions.
Formula and variables
The estimate applies the entered values and assumptions to the stated formula.
Sensitivity impact = modeled result under changed input − base result- Inputs — Entered values
- The amounts, percentages, or periods supplied to the calculator.
- Result — Calculated output
- The estimate produced by applying the formula to the entered values.
Worked example: sensitivity analysis calculator
A user enters a representative set of values and assumptions.
- Key inputs
- Amounts, percentages, periods, and costs
- Apply the stated formula.
- Include all relevant entered values and constraints.
- Compare the result with an alternative scenario.
Result: Changed profit, NPV, margins, elasticities, tables, and ranked value drivers.
Use the estimate as a planning input and verify important decisions with current records or qualified guidance.
Understanding your results
Primary estimate
Changed profit, NPV, margins, elasticities, tables, and ranked value drivers.
Risk measures
Use supporting payment, leverage, cost, and cash figures together.
Assumptions
- Entered rates and costs remain constant.
- Payments and cash flows occur on schedule.
Limitations
- Taxes, legal terms, accounting treatment, and transaction-specific costs may differ.
- Future values, timing, and rates are uncertain.
Common mistakes
- Reviewing only the headline result.
- Ignoring relevant costs, timing, or supporting measures.
- Using optimistic timing or value assumptions.
- Treating an estimate as a guaranteed outcome.
Practical use cases
Compare scenarios consistently
Change one assumption at a time or enter each alternative using the same basis.
Plan cash requirements
Estimate funds needed before committing.
Planning and decision guide
Stress-test the assumptions
One-variable analysis can miss interactions.
Review the important risks
Use realistic ranges.
Verify the source values
Pair sensitivity tests with coherent scenarios.
Frequently asked questions
What is sensitivity analysis?
Testing how output changes when one or more inputs change.
What is a tornado chart?
A ranking of inputs by their modeled impact.
How is it different from scenarios?
Sensitivity often isolates variables; scenarios change several assumptions together.
Sources and review
- Plan your business — U.S. Small Business Administration. Accessed 2026-07-10.
Reviewed 2026-07-10.