Publication number: ELQ-22874-1
View all versions & Certificate
How to do Sensitivity Analysis in Excel: One & Two Variable Data Table
Looking at Sensitivity Analysis in Excel for professionally modeling Discounted Cash Flow.
- Step n°1 |
One-Variable Data Table Sensitivity Analysis in Excel
- Step n°2 |
- Step n°3 |
Using One Variable Data Table
- Step n°4 |
CREATE THE TABLE IN A STANDARD FORMAT
- Step n°5 |
LINK THE REFERENCE INPUT AND OUTPUT AS GIVEN THE THE SNAPSHOT BELOW.
- Step n°6 |
SELECT THE WHAT-IF ANALYSIS TOOL TO PERFORM SENSITIVITY ANALYSIS IN EXCEL
Write a review
People using this Best Practice also downloaded
Loan Amortization Schedule CalculatorSimple and effective tool for debt scheduling and loan amortization500add_shopping_cart
Box IPO (Initial Public Offering)Indepth analysis of BOX IPO with DCF and relative valuation751add_shopping_cart
Comparable Company AnalysisArrive at the right multiple (EV/Sales, P/E etc.) to prepare the comparable comps.1,867add_shopping_cart
Valuation Waterfall GraphShow your audience how the share price of a target company can be broken up in its sub-components1,469add_shopping_cart
Beta Calculation WorksheetCompute the Beta needed for your CAPM as to calculate the expected return of a company's share1,153add_shopping_cart
Private Equity Chart TemplateVisualize the Valuation multiple of Stock or Index over a period of time.910add_shopping_cart
Scenario Graph TemplateVisualize the different options a stock price can take according to a number of variables3,427add_shopping_cart
Private Equity Band Chart TemplateCompute the Price to Earnings (or other PE ratios) Band Chart for your target stock or index927add_shopping_cart
Football Field GraphRepresenting the spread of key PE ratios in floating columns/bars.429add_shopping_cart
Alibaba IPO Financial ModelA full IPO financial model ready to be adapted and tweaked to any other company1,564add_shopping_cart
Colgate Financial Model (Unsolved & Solved Versions)A full financial model ready to be adapted to any other company + a blank template1,709add_shopping_cart
Free Cash Flow (FCFF) TemplateCompute the FCFF for a firm through three different methods (EBIT, EBITDA and Net Income)711add_shopping_cart
Any questions on How To Do Sensitivity Analysis In Excel: One & Two Variable Data Table?
The user community and author are here to help. Go ahead!