What is the difference between sensitivity analysis vs scenario analysis?

Sensitivity analysis evaluates how changes to a single input impact model outputs. Scenario analysis assesses outcomes when multiple inputs are changed at once under different scenarios.

When should I use sensitivity analysis?

Use sensitivity analysis when you want to understand the impact of changes in individual inputs on model outputs.

When should I use scenario analysis?

Use scenario analysis when you want to stress test models and strategies under different realistic scenarios with various combinations of factors.

Sensitivity analysis vs scenario analysis

Both techniques are valuable for analyzing the potential effects of uncertainty in financial models.

But when does sensitivity analysis make sense, and when is scenario analysis the better choice?

Find out in this article, where we explore the main differences between the two, and when you should use one over the other.

What is sensitivity analysis?

Sensitivity analysis is a financial modeling technique that measures how changes in one input variable affect your model's outcome while holding all other variables constant.

You might test how a 10% increase in interest rates impacts your NPV, or how different sales volumes affect profitability.

This one variable at a time approach helps you identify which variables have the most influence on your results.

It's particularly valuable for risk assessment, model validation, and communicating key drivers to stakeholders.

Think of it like a financial magnifying glass that lets you examine each factor's individual impact.

Benefits of sensitivity analysis

Some benefits of sensitivity analysis include:

1. Enhanced business communication

Sensitivity analysis breaks complex model outputs into understandable insights. This means you can clearly show key stakeholders how your strategic plans can affect the broader business and budget.

2. Verifies model integrity

A financial model should mirror your business's reality. Sensitivity analysis helps cross-check this reflection. You can use it to confirm if the key drivers you based your model on genuinely have the most impact on business outcomes.

This gives your models extra reassurance that they're as accurate and effective as possible.

3. Identifying risks and improving scenario analysis

By revealing how a small adjustment in one variable can impact the outcome, you get a head start on managing those risks. Not only that, but sensitivity analysis helps you focus your scenario analysis on what matters.

This targeted approach saves you from creating models around different scenarios that might not be relevant to your decision-making process.

How sensitivity analysis works

Sensitivity analysis follows a systematic process: identify your key variables, establish a base case, then test each variable across a reasonable range while keeping others constant.

Most analysts use data tables in Excel or specialized software to automate these calculations.

Here's how you'd run sensitivity analysis in your financial model:

Choose your base case: Start with your most likely scenario using realistic assumptions
Select key input variables: Focus on the factors that could significantly impact your outcome
Test a range of values: Vary each input by ±10%, ±20%, or whatever range makes sense for your analysis
Review the output: Create sensitivity tables showing how your results change with each input

Tornado charts often help visualize which variables have the greatest impact, making it easier to prioritize your focus areas.

Example: Interest rate sensitivity in portfolio management

Consider a $10 million bond portfolio with a five-year duration. Your base case assumes current rates at 4%. Testing sensitivity to rate changes:

Rates at 3% (-1%): Portfolio value increases to $10.5 million (+5%)
Rates at 5% (+1%): Portfolio value decreases to $9.5 million (-5%)

This 1:5 sensitivity ratio tells you that for every 1% change in rates, your portfolio value moves 5% in the opposite direction. Armed with this insight, you can better hedge your interest rate risk.

Example: Sales volume impact on profitability

A manufacturing company forecasts 100,000 units sold at $50 each, with variable costs of $30 per unit and fixed costs of $1 million. Testing sales volume sensitivity:

80,000 units (-20%): Profit drops from $1 million to $600,000 (-40%)
120,000 units (+20%): Profit increases to $1.4 million (+40%)

This 2:1 sensitivity shows that profit changes twice as fast as sales volume. This high operating leverage means that learning how to improve sales forecast accuracy is critical for this business.

What is scenario analysis?

Scenario analysis assesses multiple inputs simultaneously to model different realistic situations. With this approach, you can stress test for plausible scenarios as well as unlikely, but high-impact cases.

Developing a range of possible scenarios facilitates contingency planning for your business.

Scenario analysis is particularly useful for strategic planning, risk management, and capital budgeting.

It helps visualize different paths a business could take under varying circumstances, helping it to prepare for multiple possible outcomes.

Benefits of scenario analysis

1. Improves strategic thinking

Scenario analysis creates a multifaceted perspective and allows decision-makers to anticipate both promising opportunities and potential pitfalls linked to certain policies and strategies.

2. Promotes effective resource allocation

Scenario analysis is rooted in forecasting future events and trends. This forward-thinking approach helps business leaders understand external conditions that could impact their operations.

Armed with these insights, they can distribute resources more strategically, mitigating risks and harnessing opportunities more effectively.

3. Strengthens risk management

By presenting multiple possible futures, scenario analysis allows for better risk assessment and management.

It provides a safety net for businesses, helping them be better prepared for unforeseen circumstances and volatile market conditions.

How scenario analysis works

Scenario analysis is a technique that assesses the combined impact of changes in all input variables simultaneously.

To do this, an analyst conceives various potential events that could realistically occur down the line.

It typically involves crafting three distinctive narratives:

1. Base-case scenario: This scenario represents business-as-usual or the expected situation.

2. Worst-case scenario: The most challenging outcome that could transpire if things don't go according to plan.

3. Best-case scenario: The best possible and most desired projected outcome.

Now, let’s dive into some examples of how finance teams might employ scenario analysis:

Example 1: Revenue forecasting

Picture yourself as a CFO trying to figure out how to create a revenue plan for the next fiscal year.

A lot depends on your forecast: budget allocations, strategic decisions, investment planning.

To make an informed forecast, you need to consider several variables: unit price, unit cost, and sales volume, among others.

In a scenario analysis approach, you'd create different scenarios, altering multiple variables at once. For example:

1. The base-case scenario: You might use the current unit price, cost, and expected sales volume based on the company's performance and market trends.

2. The best-case scenario: You would use the highest feasible unit price (without significantly impacting sales volume), the lowest realistic unit cost (perhaps through supplier negotiations or process efficiencies), and a sales volume that takes into account potential market growth or successful marketing campaigns.

3. The worst-case scenario: You could consider a situation with a lower unit price (due to increased competition), a higher unit cost (due to rising raw material prices), and a reduced sales volume (perhaps because of an economic downturn or increased competition).

This analysis can give you a range of possible revenues for the next fiscal year, which can guide your strategic planning and decision-making.

Example 2: Investment

For this example, let's assume you're the head of a finance team, and your company is considering a significant investment like opening a new factory.

This decision depends on a host of variables: projected sales, operational costs, and market growth, to name a few.

In scenario analysis, you'd simultaneously alter these variables across different scenarios:

1. The base-case scenario: You might base this on conservative estimates of market trends and projected sales, alongside the current operational cost structure.

2. The best-case scenario: This could assume strong market growth leading to higher than average sales, along with successful cost optimization efforts reducing operational costs.

3. The worst-case scenario: This could consider a challenging market scenario leading to lower sales, coupled with increased operational costs due to unexpected price hikes in raw materials or labor costs.

This scenario analysis allows you to view the possible outcomes for the investment holistically, providing a risk-reward assessment that could steer the final investment decision.

What is the difference between scenario analysis and sensitivity analysis?

While both techniques help you understand risk and uncertainty in your financial models, they work differently and serve distinct purposes.

Sensitivity analysis changes one variable at a time while keeping everything else constant. It's like testing individual ingredients in a recipe; you adjust the salt, then the pepper, then the cooking time, each separately.

This helps you identify which factors have the biggest impact on your results.

Scenario analysis changes multiple variables simultaneously to create realistic business situations.

Instead of tweaking one ingredient, you're creating entirely different recipes; maybe a "recession scenario" where revenue drops, costs rise, and interest rates increase all at once.

When comparing scenario analysis vs sensitivity analysis, think of sensitivity as a microscope and scenarios as a wide-angle lens. Both are valuable, but they give you different perspectives on the same underlying risks.

Some analysts also use simulation analysis (like Monte Carlo methods), which runs thousands of scenarios with random variable combinations based on probability distributions.

This provides a statistical view of potential outcomes but requires more sophisticated modeling.

While scenario analysis vs sensitivity analysis covers most practical needs, simulation analysis can be useful when you need probability-based insights for complex decisions.

When to use sensitivity analysis vs scenario analysis

Choosing between these methods depends on your specific analytical needs and the complexity of the relationships you're examining. Here's when each approach works best:

When to use sensitivity analysis:

Impact assessment: Test how individual variables affect outcomes, like examining how discount rates impact NPV in a DCF model. Essential for understanding which assumptions matter most.
Model validation: Verify your model's logic by checking if outputs respond appropriately to input changes. If revenue doesn't increase with higher prices, you've found a formula error.
Risk prioritization: Identify which variables need the most attention in your analysis. A 1% change in gross margin might matter more than a 10% change in marketing spend.
Data precision planning: Determine where you need better estimates. If your model is highly sensitive to customer churn rates, invest time in refining that assumption.
Communication: Sensitivity tables and tornado charts clearly show stakeholders which factors drive results. Perfect for board presentations and investment committees.

When to use scenario analysis:

Strategic planning: Evaluate major decisions under different future states. Test whether an acquisition makes sense in both growing and declining markets.
Stress testing: Examine worst-case scenarios where multiple things go wrong simultaneously. What if rates rise, sales drop, and costs increase all at once?
Market condition modeling: Assess performance under different economic environments. Model recession, recovery, and boom scenarios with appropriate variable combinations.
Investment evaluation: Test project viability across different scenarios. A real estate development might face different combinations of construction costs, rental rates, and financing terms.
Risk management: Prepare contingency plans for various futures. If competitor entry coincides with regulatory changes, what's your response?

Blending both methods for comprehensive analysis

The most robust financial models use both techniques. Start with sensitivity analysis to identify critical variables, then build scenarios around different combinations of those key drivers.

This two-step approach ensures you focus scenario planning on what actually matters.

For example, if sensitivity analysis reveals that occupancy rates and rental prices most impact your real estate model, create scenarios combining different levels of both.

Your bear case might assume 75% occupancy with declining rents, while your bull case models 95% occupancy with rental growth.

Whether you're building DCF models, preparing budgets, or evaluating investments, these twin analytical techniques will provide you with invaluable insights to make confident, data-driven decisions.

FAQs: Scenario analysis vs sensitivity analysis

What advantage does scenario analysis have over sensitivity analysis?

Scenario analysis allows evaluating the combined effect of multiple factors changing simultaneously. Sensitivity analysis only looks at one variable at a time.

What are the two types of sensitivity analysis?

One-at-a-time sensitivity analysis varies one input while holding others constant. Probabilistic sensitivity analysis assigns probability distributions to inputs and evaluates using Monte Carlo simulation.

What is the use of sensitivity and scenario analysis?

They help validate models, identify key variables, stress test strategies, and prepare contingency plans by understanding potential outcomes.

Can I use both techniques together?

Yes! Using both sensitivity and scenario analysis provides comprehensive model validation. Sensitivity analysis identifies key value drivers, while scenario analysis tests performance under various conditions.

Trying to decide when to use sensitivity analysis vs scenario analysis?