Sensitivity Analysis Template
Demonstrate the effects of changes in variables on the final outcome
Download WSO's freebelow!
This template allows you to build your own table to demonstrate the effect of various variable changes on the final outcome.
The template is plug-and-play, and you can enter your own numbers or formulas to auto-populate output numbers. The template also includes other tabs for other elements of a.
According to the WSO 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 a merger,or other corporate action. Some examples are:
- Merger Model - how is accretion / dilution affected?
- Valuation - what happens if TV or discount rate change?
- - how is leverage and/or purchase price changes?"
A screenshot below shows a sneak peek of the template.
We hope this template helps you excel at your job! Please check out the following additional resources to help you advance your career: