Financial Planning & Analysis

Scenario Analysis and Sensitivity Analysis in Financial Forecasting

Whether the business environment is firing on all cylinders or there is economic turmoil, a successful business responds to any type of change. Financial forecasting is critical when times change. This article offers examples of Sensitivity and Scenario Analysis, explanations of each type, when it should be used, and the advantages of each. It is critical to have a linked 3-Statement Financial Model (Income Statement, Balance Sheet, and Cash Flow) in Excel before beginning either type of analysis. A linked model will dynamically show how your assumptions affect your financial statements.

What is Scenario Analysis?

Scenario Analysis is the method of predicting the future value of an investment based on changes that may occur to existing variables. It requires one to explore the impact of different market conditions on the project or investment as a whole. This type of analysis is often used to estimate changes in cash flow or business value. (If you’re looking for more detail, you can also read our post that offers a more comprehensive example of scenario analysis.)

Characteristics of Scenario Analysis

Multiple Inputs Changing at One Time

Typically, Scenario Analysis involves examining multiple inputs. For example, the user may consider accelerating growth through changes in production, price changes, additional financing, and capital expenditures.

Tries to Tell a “Story” About the Future

Scenario Analysis is not about changing one variable (e.g., if interest rate increases 1% or the cost of raw materials increase by 10%). In scenario analyses, lay out the likely outcomes for wholesale changes in the business whether they are plans for expansion or planning for some type of disaster which results in dramatic slowdown to the business.

Presents Several Business Cases

At a minimum, one should consider a base case (current state), an upside case (best-case scenario) and a downside case (worst-case scenario). Additional cases can and should be considered, but an excess number of cases can cause confusion.

Benefits of Performing Scenario Analysis

Planning for the Future

Scenario Analysis allows investors to have any understanding of expected returns when planning for future investments. Before investing in any business, one should understand their forecasts and the assumptions used to generate those forecasts.


A company can avoid or limit losses that result from uncontrollable factors by analyzing events and situations that may lead to negative outcomes and incorporating aggressive preventive measures during worst-case scenarios.

Avoiding Risk and Failure

Scenario Analysis allows businesses or independent investors to assess investment prospects in order to avoid bad investment decisions. Scenario Analysis takes the best and worst probabilities into account, so investors or potential investors can make better informed decisions.

Learn how to adjust your forecast to economic conditions in this selection from our cash flow management and forecast Q&A:

What is Sensitivity Analysis?

Sensitivity Analysis is a technique used to show how the different values of independent variables affect dependent variables under certain specific conditions. The use of Sensitivity Analysis extends beyond financial forecasting. It is used in a wide range of fields, ranging from biology to economics and engineering and food preparation.

Characteristics of Sensitivity Analysis

One Assumption at a Time

One of the simplest and most common approaches is that of changing one factor at a time. Whether the assumption is about the change in a borrowing rate or a change in the working capital metrics (Days Sales, Days Payable, or Day of Inventory), one can change each assumption individually to see the outcome on working capital, profitability or loan covenants.

No Story About Why Inputs Go Up or Down

Unlike Scenario Analysis, where multiple variables are used to outline detailed settings of both positive or negative, Sensitivity Analysis looks at only one variable at a time. It is less of a story and more of a what if. What if sales decline by “x” percent or what if the costs of raw materials increases by X. These can be looked at one at time but don’t provide a complete picture.

Used to Determine Which Assumptions Matter Most

Sensitivity Analysis changes variables/assumptions one at a time, which makes it possible to see which variables/assumptions will have the greatest impact on a business. For example, the borrowing rate can be changed by one basis point at time, or the gross margin percentage can change by specific increments. The results of one could be drastically different than the other and lead to different causes of action.

Benefits of Performing Sensitivity Analysis

Deeper Analysis

When Sensitivity Analysis is performed, each independent variable and its effect on the dependent variable is analyzed. Their movements are studied, and the results are compared. This in-depth analysis will aid in providing a more accurate forecast.

Quality Check

Sensitivity Analysis provides management with an understanding of which variables have a high impact on success or failure to a project. For example, in a Sensitivity Analysis of a company, management may discover that a certain raw material used in their product affects the costs by up to 20%. Therefore, management can concentrate on sourcing this material from other vendors or look for alternatives to improve profitability.

Strengthen “Weak Spots”

As Sensitivity Analysis assesses each variable independently, it can identify critical variables that may act as a weakness. For example – it may be discovered that raw materials are extremely volatile to changes in currency. Measures can be taken to reduce the impact, say by hedging. Thus, it can be said – weak spot is identified and strengthened.

Excel Tools to Assist in Performing Sensitivity and Scenario Analysis

Choose Function

The CHOOSE function is very useful when creating scenarios in financial models. By using the CHOOSE formula, an analyst is able to select between 5 different scenarios that can flow through the entire model.

Goal Seek Function

The Goal Seek Excel tool is for what-if analysis that tells us what value an assumption needs to be in order to reach a desired output or result. It is a form of reverse engineering, where the user starts with the outcome and answer that they want and Excel works backward to find the solution.

Data Table

Data tables are used to display a range of outputs given a range of different inputs. They are commonly used to assess a range of different possibilities for a company, given uncertainty about what will happen in the future.

Learn more.

If you’re interested in learning more about Scenario Analysis, we invite you to read these related posts:

You can also explore how we’ve worked with companies to improve their cash flow forecasts by downloading our explainer below. It offers an overview of the consulting work we do with clients in this space:

cash flow forecasting services

Thanks for reading!

Categorized in: ,

similar articles

Learn to think and approach problems like our financial consultants.

Financial Planning & Analysis

3 Stages of Effective Cost Savings Initiatives

Cost cutting – it’s a goal that nearly every company aspires to achieve. However, unlike other areas of business improvement, there is no public playbook on how to accomplish these desired targets. Whether a firm is undergoing a full restructuring plan mandated by a Chapter 11 filing, maximizing the profit and loss statement prior to… View Article

May 31, 2023Aniv Nayar

Financial Planning & Analysis

FP&A Strategies for Food & Beverage Manufacturing: Maximizing Growth and Profitability

The food and beverage industry is mammoth and a thriving part of the world economy. Globally, in 2021, the food and beverage manufacturing market totaled $5.8 trillion, $6.8 trillion in 2022 and is expected to reach around $7.2 trillion in 2023. The compound annual growth rate (CAGR) is 8.7%, which will result in expected growth… View Article

May 24, 2023Azar Benabou

Financial Planning & Analysis

Recommendations for Aligning Forecasts and Targets Across Functions

While Finance teams own annual budgets and quarterly forecasts, other functional teams such as Sales, Marketing and Operations will often have separate finance-related forecasts, targets and goals for their respective needs. This can occasionally cause confusion to observers as to the “true” finance forecast when different teams provide different responses. Since Finance teams should be… View Article

May 11, 2023Marco Moreno

See All

Back to Insights