Sensitivity Analysis Template
Demonstrate the effects of changes in variables on the final outcome
Download WSO'sfreeSensitivity Analysis Tablemodel templatebelow!
This template allows you to build your own table todemonstrate the effect of various variable changes on the final outcome.
The template isplug-and-play, and you can enter your own numbers or formulas toauto-populateoutput numbers. The template also includesother tabs for other elementsof a financial model.
According to theWSO Dictionary,
"In investment banking and private equity, sensitivity tables are used to assess the likely impact of changes in specific variables on the outcome of amerger,LBOor other corporate action. Some examples are:
- Merger Model- how isaccretion/dilutionaffected?
- DCF Valuation- what happens if TV ordiscount ratechange?
- LBO Model- how isIRR affected ifleverageand/or purchase price changes?"
A screenshot below shows a sneak peek of the template.
Everything You Need To Master Financial Modeling
To Help you Thrive in the Most Prestigious Jobs on Wall Street.
More Resources:
We hope this template helps you excel at your job! Please check out the following additional resources to help you advance your career:
or Want toSign upwith your social account?