Sensitivity analysis
Learning outcome statements
The learning outcome statements relevant for this section are:
- define sensitivity analysis and identify when it would be the appropriate tool to use
- identify the benefits and limitations of sensitivity analysis
Definition of sensitivity analysis
By systematically changing key inputs, analysts can identify which factors have the most significant impact on outcomes, allowing for better risk management and decision-making.
Example: Which input matters most?
Base-case operating income: 10,000 units × ($50 price − $30 variable cost) − $120,000 fixed costs = $80,000.
Flexing sales volume ±10% (9,000 to 11,000 units), while holding price, variable cost, and fixed costs constant, moves income from $60,000 to $100,000 - a swing of ±$20,000, or ±25%.
Flexing unit variable cost ±10% ($27 to $33) instead, while holding volume, price, and fixed costs constant, moves income from $110,000 to $50,000 - a swing of ±$30,000, or ±37.5%.
Answer: Unit variable cost causes the bigger swing (±37.5% vs. ±25% for volume), making it the more sensitive input in this model.
This method is particularly useful in financial modeling, project management, and economic forecasting. For example, in capital budgeting, sensitivity analysis can evaluate how changes in interest rates or projected revenues impact a company’s net present value (NPV). Similarly, in supply chain management, it can determine how fluctuations in raw material prices affect overall production costs.
When to use sensitivity analysis
Sensitivity analysis is a decision-making tool that tests how changes in key assumptions or input variables affect outcomes. It is particularly useful in environments of uncertainty, where managers need to understand the range of possible results and the degree of risk associated with different scenarios. By highlighting which variables have the greatest impact, sensitivity analysis helps organizations validate models, improve financial forecasts, strengthen risk management, and support operational planning. Common situations include:
- Uncertain inputs: testing how fluctuating variables affect results, such as an energy company modeling how oil prices affect projected revenues.
- Validating a model: checking whether small changes in assumptions cause outsized swings in output, such as a bank testing how default rate changes affect loan portfolio performance.
- Financial forecasting: assessing how interest rates, inflation, or demand affect investment decisions, such as a company modeling expected revenue under different economic conditions.
- Risk management: identifying which risk factors most affect financial stability, such as a manufacturer analyzing how supply chain disruptions affect operations.
- Operational planning: evaluating how labor costs, fuel prices, or exchange rates affect profitability, such as an airline testing how fuel price swings affect its hedging strategy.
Benefits and limitations of sensitivity analysis
Benefits
- Improved decision-making: Sensitivity analysis helps organizations assess the impact of various factors on their business outcomes, enabling them to make more informed strategic decisions.
- Resource optimization: Organizations can allocate resources more effectively by understanding how changes in costs, demand, or other variables affect profitability and efficiency.
- Model validation: It helps validate the robustness of predictive models by identifying how sensitive the outcomes are to changes in input variables.
Limitations
- Data dependence: The accuracy of sensitivity analysis depends on the quality and reliability of input data. Inaccurate assumptions can lead to misleading results.
- One variable at a time: Inputs are typically varied one at a time while holding all others constant (a “ceteris paribus” approach), which ignores correlations and interactions between variables in real-world scenarios.
- No probabilities: It shows how much an outcome would change, but not how likely that change is. Monte Carlo simulation, covered later in this course, assigns probabilities to a range of outcomes.
- Time-consuming for large models: Testing many variables across a complex model can require significant computational effort, though a quick spreadsheet what-if test on a single input is fast.
- Does not provide definitive answers: Sensitivity analysis highlights how outcomes change under different conditions but does not prescribe the best course of action.
- Potential for oversimplification: Some models may overlook external factors that significantly influence business outcomes, leading to incomplete assessments.
Despite these limitations, sensitivity analysis remains a valuable tool for businesses seeking to evaluate uncertainty, refine models, and enhance decision-making processes.