Sensitivity Analysis

Listed here are financial models with sensitivity analysis which allow to conduct sensitivity analysis in order to understand the effect on the company’s valuation or investment IRR by changing some of the main key assumptions of the company’s business plan.

The Private Equity Oil and Gas Financial Model evaluates the financial feasibility and investor returns when investing in a portfolio…

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

If you dream to start a security business, the template is the first step in making your dream into reality.…

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

If you dream to start a health club business, the template is the first step in making your dream into…

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

Deploy vending machines over a 60 month period and see what the resulting margins and cash flow look like. Highly…

Price: $45.00
Add to wish list
$45.00 – Purchase Excluding 7.7% tax

The model easy to use, you need to fill the green cells in the green tabs, clear to read and…

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

A bottom-up financial model to create a 5-year forecast, find minimum equity required, and pricing feasibility.

Price: $45.00
Add to wish list
$45.00 – Purchase Excluding 7.7% tax

Core principles of building financial models

Starting at: $0.00
Add to wish list
Purchase

If you dream to start or develop a construction & mining machinery dealership business, the template is the first step…

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

This Metal Mining model is used to provide a forecast and valuation of a metal mining project. This has 3…

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

The Renewable Energy Project Finance model is used to provide a forecast and profitability analysis of a renewable energy project.…

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

The Venture Capital Returns Model is used to provide an analysis of an investment return for a VC fund. This…

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

In summary, the model easy to use, 100% customizable, no hidden formulas, clear to read and understand the reports and…

Price: $59.00
Add to wish list
$59.00 – Purchase Excluding 7.7% tax

This is an equity only (joint venture capable) financial model for building / acquiring self storage property for some time…

Price: $45.00
Add to wish list
$45.00 – Purchase Excluding 7.7% tax

If you dream to start a heavy machinery rental business, the template is the first step in making your dream…

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

If you dream to start a boat touring business, the template is the first step in making your dream into…

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

This is a learning financial Model for students and beginners. 3-statement interlinked financial with complete working and authenticated formulas and…

Price: $5.00
Add to wish list
$5.00 – Purchase Excluding 7.7% tax

This is a 5-year startup model for the rental business. There is specific logic to show the projections and cash…

Price: $45.00
Add to wish list
$45.00 – Purchase Excluding 7.7% tax

Dynamic financial model presenting a potential acquisition of a Multi-family Apartment Complex.

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

Operating Company Model consists of an Excel model which allows the user to generate forecast financial statements based on historical…

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

The global concrete industry market is expected to significantly grow in the 10 coming years. If you dream to start…

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

If you dream to start an FMCG Distribution business, the template is the first step in making your dream into…

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

This is a bundle of all the most useful and efficient google sheet templates I have built over the years.…

Price: $369.00
Add to wish list
$369.00 – Purchase Excluding 7.7% tax

Produce a DCF Analysis for single or multiple scenarios and up to 6 discount rates. Includes unique visual analysis.

Price: $45.00
Add to wish list
$45.00 – Purchase Excluding 7.7% tax

An Excel utility to draw indifference curves for two inputs of a model

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

6 different Financial Model Tests with one coming with a solution. The Models are focused on Infrastructure Assets.

Starting at: $30.00
Add to wish list
Purchase Excluding 7.7% tax

Advanced financial model presenting a potential Hotel acquisition.

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

Advanced Financial Model presenting a potential acquisition of a public or private company using a significant amount of borrowed funds.

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

Average rating:

A self-made Modeling Test with a solution for Onshore Wind Turbines plant. The case study is in Chile assuming a…

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

Advanced Financial Model presenting a potential Merger & Acquisition (M&A) transaction between two companies.

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

The template provides the reader a brief financial report, clear, and expresses the main finding or conclusions, it can save…

Starting at: $0.00
Add to wish list
Purchase Excluding 7.7% tax

Financial Planning and Analysis


Financial planning is one of the most crucial tasks whether when it comes to running a business, planning to start a business, or simply for personal circumstances, as to help to make sensible decisions about financing that can help reach the determined goals or objectives. Basically, by creating a financial plan, one can project or predict unknown variables that could affect the future key variables. These projected variables are then analyzed to determine what changes will happen to such results after considering different assumptions.

Financial planning and analysis is actually regarded as the budgeting, forecasting, and analytical processes that support an organizations’ financial health and business strategy. It depends heavily upon the analysis to measure and plan the business operations as well as forecasting their financial impact while considering a different set of assumptions.

Financial planning and analysis or FP&A experts are likely to monitor, analyze, and help manage the financing needed to meet certain obligations, tracking and analyzing cash flow, analyzing the financial statements along with other financial and operational data that are important and might be affected to certain changes in scenarios.

 

Identifying the Differences between Types of Analysis


Scenario analysis, sensitivity analysis, and what-if analysis are all very similar to each other. In fact, they’re really only slight variations of the same thing. Here’s a breakdown:

  • What-if analysis: What-if analysis is the process of testing to see “what would happen if” you change something in the model.

  • Sensitivity analysis: Sensitivity analysis is the process of tweaking one key input or driver in a financial model and seeing how sensitive the model output (e.g. the NPV or the IRR) is to the change in that variable.

  • Scenario analysis: Scenario analysis is the process of tweaking a whole series of inputs or drivers in a financial model and seeing what happens with the models result.


In most cases, financial modelers consider building a sensitivity analysis better to determine and evaluate the extent to which changes in assumptions and inputs affect various outputs of interest, such as revenues, net income, free cash flows, and many more value key drivers. Here, we will focus on discussing more regarding Sensitivity Analysis and how to build a model that allows you to conduct a sensitivity analysis.

 

What is Sensitivity Analysis


Sensitivity analysis is a very useful tool to analyze the impact of any changes in key assumptions on the key output of the model, such as the NPV and IRR. It is also known as the “what-if” analysis since you have to go through a series of what-ifs to run different simulations and determine the impact of each assumption. By running a variable through different scenarios or circumstances, you’ll be able to determine how sensitive the output is and also find out how to keep the inputs constant. In other words, sensitivity analysis is the task of calculating the uncertainty of a financial model while considering different sources of inputs.

Once you have a working financial model, choosing the key value drivers as well as a series of inputs or outputs to use as the variables to conduct sensitivity analysis is an important challenge. It is so easy to do these in Excel that the tendency is to drown management with numbers. Instead of taking that easy way out, you need to devote some time to decide which sensitivity analysis will be most informative to look at.

In this case, the problem already specifies the tables to prepare. Data Table is the ideal tool for doing this analysis. Remember that it is easiest to create data tables in the same sheet that has the independent and dependent variables.

For example, we’ll use the Sensitivity Analysis Model of a Gas Station to check how a sensitivity analysis work:

Sensitivity Table
Sensitivity Table


Here, we are checking what will happen to the Unlevered Internal Rate of Return (IRR) by either increasing or decreasing the price.

Normally, the IRR should go up if you increase the prices but in this case, it’s not because this model is built on a different logic of a constant profit margin per gallon which means, that the percentage profit margin per gallon in relation to the gasoline sales price gets lower if the gasoline prices increases.

Now, it depends if reality is indeed is like this, if not, you will have to change the logic of your model. So, this sensitivity analysis can be a very useful tool to check if your model is working the way it should.

Sensitivity Analysis Tables
Sensitivity Analysis Tables


We then extended the sensitivity analysis instead of checking only two assumptions to ensure wider coverage. Meaning, we are checking the changes in 10 main assumptions for the effects on the key outputs which in this case is the unlevered IRR. As usual, each of these tables has 5 scenarios for two different key assumptions each (either increasing or decreasing).

Key chart of the sensitivity analysis
Tornado Diagram with the results of the Sensitivity Analysis


Using the tables’ data, we then built a Tornado Diagram to have an easier and understandable view to check what happens to the unlevered IRR if we change each assumption by 20% up or by 20% down. Basically, which assumption has the most effect, ergo, which is the most important assumption driving the value of your model, in the above case, surprisingly, the most important assumption is the related to the non-gas revenues since a gasoline station today makes its money by selling non-gas items and not by selling only gasoline anymore.

 

Steps Used to Conduct a Sensitivity Analysis


To analyze how sensitive the output is, you will need to run it through a sensitivity analysis which can be complex depending on what you’re trying to make a study out of. When planning to conduct a sensitivity analysis, one needs to note down these parameters:

  • Basic structure – includes a combination of assumptions that are to be varied, ensuring which and how many assumptions are needed at a period, assigning values before the simulation, analyzing the correlations of the values, etc.

  • What to vary – set of different assumptions that can be chosen to vary in the model, such as the number of activities, objective in relation to the risk assumed and the projected profits, technical ratios, number of constraints and limits, etc.

  • What to observe – include the value of the variable as per the regular business plan, the value of the decision variables, and value of the variable after going through between two different strategies applied


To better understand the above-mentioned parameters applied in a model, here are the steps used to conduct a sensitivity analysis:

  1. Input the base case output to be put under sensitivity analysis. (e.g. V1)

  2. Calculate the new value of the input by measuring through the sensitivity test while all other inputs in the model are kept constant. (e.g. V2)

  3. Calculate the percentage change in the output and input respectively.

  4. The sensitivity is then calculated by dividing the percentage change in output by the percentage change in input.


The process is repeated to the rest of the inputs until the sensitivity figure for each of the inputs is fulfilled. Therefore, if you arrive at a higher sensitivity figure, the more sensitive your output is to any change that might occur in your business cycle. The same also applies vice versa.

 

Uses of a Sensitivity Analysis


One of the best uses for sensitivity analysis is for building a model for economic decision making. All the data provided will be a great reference to come up with the best decision and also can be fully utilized repeatedly to conduct a sensitivity analysis. The model will help the user to understand the risks and benefits, uncertainties, limitations, and scope of the model. Since most of all the decisions aren’t definite, to conduct a sensitivity analysis will be a great tool to test various assumptions in different simulations, arriving at the most optimal solution or answer about the uncertainties in decision making.

There are many more uses that a sensitivity analysis is built for, such as:

  • Indicating the sensitivity of simulation to assumptions of the input values in a model

  • Predicting the effects of different scenarios and decisions

  • Testing the robustness of the values

  • Assessing the risks of a strategy or the business plan

  • Determining if the optimal value criteria are reached or still have space to grow

  • Identifying the dependency of the outputs to certain inputs, whether it is helpful or risky

  • Acting as an error checker of the model

  • Building informed and appropriate decisions or strategy

  • Removing redundancy in the model structure

  • Representing as a tool to communicate between entities

  • Etc.


 

Sensitivity Analysis Example Models


Building a sensitivity analysis model isn’t as simple as it sounds. It takes skill, experience, and the equivalent know-how to be able to fully utilize the usefulness of the model. If you are looking for sensitivity analysis example models, you can check out our list of financial model templates which included sensitivity analysis example models above. You will be able to see how they function and you will also learn how to build one for yourself. By using the template as your base model, you will be able to build a working financial model with a sensitivity analysis section included.

These financial model templates which included Sensitivity Analysis are ready-made by expert financial modelers that have substantial financial modeling experience and industry know-how, so you don’t have to hire a professional to build a fully customized model for you.

If you are in need of financial model templates for different use cases, you can simply go through our list of use cases which contains several financial model templates according to their uses. These templates are also downloaded by users from all over the globe such as the USA, Canada, Japan, France, Singapore, and many more who are in need of help when it comes to their financial modeling tasks.