Sensitivity Analysis Template

Download WSO'sfreeSensitivity Analysis Table modeltemplatebelow!

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 includes其他选项卡其他元素of afinancial model.

According to theWSO Dictionary,

"In investment banking and private equity,sensitivity tablesare 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 is accretion / dilution affected?
• DCFValuation- what happens ifTV or discount ratechange?
• LBO Model- how isIRR affected ifleverage and/or purchase price changes?"

A screenshot below shows a sneak peek of the template.

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:

• Debt Schedule Template
• Plant, Property, and Equipment (PPE) Schedule Template
• Leveraged Buyout (LBO) Model Template
• Private Equity Distribution Waterfall Template
• Accretion Calculation Model Template