EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 250+ Courses All in One Bundle
  • Login

Sensitivity Analysis

By Madhuri ThakurMadhuri Thakur

Home » Finance » Blog » Corporate Finance Basics » Sensitivity Analysis

sensitive-analysis

What is Sensitivity Analysis?

It is a situation similar to “what-if” analysis or the use of simulation analysis. It is used to predict the outcome of a decision based on a certain range of variables. It is especially very useful in cases where investors and stake-holders are evaluating the projects and proposals from the same industry or from different industries but driven by similar factors.

Uses of Sensitivity Analysis

Here we discuss the uses of sensitivity analysis:

Start Your Free Investment Banking Course

Download Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others

  1. Developing Recommendations for the Decision-makers
  2. Feasibility testing of an optimal solution
  3. Identifying the sensitive variables
  4. Identifying critical values and break-even point where the optimal strategy changes
  5. Assessing the degree of risk involved in strategy or scenario
  6. Communication
  7. Allows the decision-makers to make assumptions
  8. Making recommendations
  9. Quantifying the parameters
  10. Developing a hypothesis for testing different scenarios
  11. Estimating the requirements of the input and output variables
  12. Understanding the relationship between input variables and the outcome

Forms of Outcomes in Sensitivity Analysis:

  1. Pessimistic
  2. Expected or the Original
  3. Optimistic

Examples of Sensitivity Analysis (With Excel Template)

Let’s take an example to understand the calculation of Sensitivity Analysis in a better manner.

You can download this Sensitivity Analysis Excel Template here – Sensitivity Analysis Excel Template

Sensitivity Analysis – Example #1

The expected Cash Flow forecast for the next 12 years is provided (see below). The cost of capital is 8 %, assuming the variables remain constant and determine the project’s Net Present Value (NPV). More details of the calculation are in the attached excel sheet.

Example #1

Explanation

Sensitivity Analysis is used to know and ascertain the impact of a change in the outcome with the inputs’ various projected changes.

  1. Develop the forecasted income statement
  2. Determine the fixed costs and the variable costs on analyzing all the costs involved in the process
  3. Determine the range of Sales Factors percentages
  4. Increase and decrease the sales volume based on the various Sales Percentage factors
  5. Increase and decrease the Variable costs based on the various Sales Percentage factors
  6. The Fixed costs remain constant irrespective of the sales volume and changes to it.
  7. Determine the Net Income Before Taxes for the various sales volume. This can be arrived at by simply reducing the sales by variable and fixed costs aligned to it.
  8. Determine the Net Income After Taxes by applying the Tax Rate as applicable

Sensitivity Analysis – Example #2

Example of J&B Inc. The original or expected Sales Volume is $582,401 arising out of 7882 units and at the rate of $73.89.To conduct the sensitivity analysis – J&B Inc conducted two models with different input variables for the Pessimistic Model and the Optimistic Model, as seen highlighted below:

Sensitivity Analysis -1.2

Based on these pessimistic and optimistic values of the sales and variable costs, the net income after taxes can be seen as varying. Hence, on creating the two models, we aim to arrive at a conclusion or analysis of the input factors to reach the desired Net Income figures.

Popular Course in this category
Business Valuation Training (14 Courses)14 Online Courses | 70+ Hours | Verifiable Certificate of Completion | Lifetime Access
4.5 (5,925 ratings)
Course Price

View Course

Related Courses
Equity Research Training (15 Courses)Project Finance Training (8 Courses with Case Studies)

Sensitivity Analysis -1.5

The estimation of sales and, therefore, the variable costs helps decide and has a great impact on the NPV of given projects. The fixed costs and any changes to it become insignificant but remain constant across different levels of sales volume.

Relevance and Use

As per the requirement of the decision-making area, the variables and their types would differ. Accordingly, the parameters are decided, and the sensitivity analysis is conducted. Sensitivity Analysis, among other models, is put much more to use as a decision support model than merely a tool to reach one optimal solution. However, this form of analysis becomes ambiguous when the terms “pessimistic” and “optimistic” become subjective to the user and the levels considered are set as per the user.

The uncertainty of the output due to the different sources of inputs and their uncertainty results to uncertain analysis. This, in turn, leads to the quantification of uncertainty and therefore, the need to run the sensitivity analysis comes to the picture. This is a method, again, to re-calculate the output based on different alternative assumptions. The common areas of application of the models of sensitivity analysis are:

  • Business: In resource allocation, guide the future data flows, identify critical assumptions
  • Environmental: Impact of water purifying plant, global climate models
  • Social Sciences: Econometric Models
  • Engineering: Testing designs
  • Chemistry: Measurement positions
  • Meta-Analysis: To check whether the results are sensitive to the restrictions included Time-critical decision making.
  • Multiple: Criteria decision making – Selecting the best alternative from the pool of the available different alternatives

Recommended Articles

This is a guide to Sensitivity Analysis. Here we discuss how to calculate sensitivity analysis along with practical examples. we also provide a downloadable excel template. You may also look at the following articles to learn more –

  1. Discounted Cash Flow Analysis
  2. What is the Cost-Benefit Analysis?
  3. Difference Between Hard Cost vs Soft Cost
  4. Examples of Cost of Goods Manufactured

All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)

250+ Online Courses

40+ Projects

1000+ Hours

Verifiable Certificates

Lifetime Access

Learn More

0 Shares
Share
Tweet
Share
Primary Sidebar
Finance Blog
  • Corporate Finance Basics
    • Capital Intensive
    • Voided Check
    • Negotiable Instruments
    • Portfolio Optimization
    • 401k Plan
    • Non-Marketable Securities
    • Stock Certificate
    • Treasury Stock
    • Appropriate Retained Earnings
    • Stockholder
    • Share Vesting
    • Shares Issued
    • Preferred Shares
    • Share Buyback
    • Shareholder Types
    • Tax Loss Harvesting
    • Statutory Audit
    • Audit Risk
    • Fund of Funds
    • Accredited Investor
    • Cost Centre
    • Lessee
    • Golden Handcuffs
    • Ordinary Shares
    • Restricted Stock Units
    • Goodwill Valuation
    • Share Classes
    • Lessor
    • Preferred Dividends
    • LIFO Liquidation
    • Dilutive Securities
    • Restructuring Cost
    • Non-Cumulative Preference Shares
    • Pass Through Entity
    • Management Discussion and Analysis
    • Premium on Stock
    • Leveraged Loans
    • Dividend
    • Dividend Policy
    • Financial Reporting Objectives
    • Financial Reporting
    • Internal Controls
    • Capital Investment
    • Debt to Equity Ratio
    • Dividend Growth Rate
    • Market Capitalization
    • Deal Origination
    • Importance of Working Capital
    • SWOT Analysis
    • White Knight
    • Root Cause Analysis
    • Realized Gain
    • Return on Operating Assets
    • Offshore Investments
    • Transfer Price
    • Times Interest Earned Ratio
    • Debt Coverage Ratio
    • Dividend Discount Model
    • Combined Ratio
    • Merger Arbitrage
    • Gordon Growth Model
    • Advantages of Joint Venture
    • Interest Coverage Ratio
    • Reserve Requirements
    • Asset Turnover Ratio
    • Price to Rent Ratio
    • Ratio Analysis Types
    • Debt Ratio
    • Business Risk
    • Financial Leverage
    • Dividend Payout Ratio
    • Mistakes in DCF
    • Risk/Reward Ratio
    • Full Form of FIPB
    • Financial Risk
    • CAPE Ratio
    • Overcapitalization
    • Systematic Risk
    • Hedge Ratio
    • Full Form of NHB
    • Sensitivity Analysis
    • Current Ratio
    • Corporation Examples
    • Asset to Sales Ratio
    • Balance Sheet Ratios
    • List of Financial Ratios
    • Coverage Ratio
    • Forward PE Ratio
    • Interpretation of Debt to Equity Ratio
    • Capitalization Ratio
    • Importance of Ratio Analysis
    • Quick Ratio Interpretation
    • Corporate Finance Basics
    • PEG Ratio
    • Corporate Finance Interview Questions
    • Price to Earnings Ratio
    • Structured Note
    • Limitations of Ratio Analysis
    • NPV vs IRR
    • IRR vs ROI
    • Imputed Interest
    • Full Form of HR
    • Shareholders Agreement
    • Earnings Per Share
    • Capital Structure
    • Corporate Finance Jobs
    • About Corporate Finance
    • Corporate Finance Theory & Practices
    • Career in Corporate Finance
    • Simple Interest Rate vs Compound Interest Rate
    • Stocks vs Shares
    • Bonds vs Debenture
    • Bull Market vs Bear Market
    • Mortgagee vs Mortgagor
    • Horizontal Integration vs Vertical Integration
    • Money Market vs Capital Market
    • Leveraged vs Unleveraged
    • Dividends vs Capital Gains
    • Present Value vs Net Present Value
    • Qualified vs Ordinary Dividends
    • ROE vs ROA
    • Bond vs Loan
    • Stock Dividend vs Stock Split
    • Audit vs Assurance
    • Coupon Rate vs Interest Rate
    • Growth Stock vs Value Stock
  • Accounting fundamentals (485+)
  • Asset Management Tutorial (140+)
  • Banking (43+)
  • Credit Research Fundamentals (6+)
  • Economics (44+)
  • Finance Formula (372+)
  • Financial Modeling in Excel (13+)
  • Investment Banking Basics (60+)
  • Investment Banking Careers (26+)
  • Trading for dummies (66+)
  • valuation basics (25+)
Finance Blog Courses
  • Online Business Valuation Training
  • Equity Research Certification
  • Project Finance Course
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Investment Banking Jobs Offer
  • Finance Formula
  • All Tutorials
Certification Courses
  • All Courses
  • Financial Analyst All in One Bundle
  • Investment Banking Training
  • Financial Modeling Course
  • Equity Research Course
  • Private Equity Training Course
  • Business Valuation Course
  • Mergers and Acquisitions Course

© 2020 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA Login

Forgot Password?

EDUCBA
Free Investment Banking Course

Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others

*Please provide your correct email id. Login details for this Free course will be emailed to you
Book Your One Instructor : One Learner Free Class

Let’s Get Started

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

EDUCBA

Download Sensitivity Analysis Excel Template

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Investment Banking Course

Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

Special Offer - Online Business Valuation Training Learn More