Sensitivity Analysis Table - Model Template

Download WSO's free Sensitivity Analysis Table model template below! 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 financial model.

IMPORTANT UPDATE: New WSO Financial Modeling Courses Now Available Here.

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, LBO or other corporate action. Some examples are:
  • Merger Model - how is accretion / dilution affected?
  • DCF Valuation - what happens if TV or discount rate change?
  • LBO Model - how is IRR affected if leverage and/or purchase price changes?"

A screenshot below shows a sneak peak of the template.

WSO Sensitivity Analysis Table Template

Start Discussion

Total Avg Compensation

September 2021 Investment Banking

  • Director/MD (10) $853
  • Vice President (38) $367
  • Associates (217) $232
  • 2nd Year Analyst (129) $151
  • 3rd+ Year Analyst (30) $147
  • Intern/Summer Associate (102) $144
  • 1st Year Analyst (475) $135
  • Intern/Summer Analyst (374) $82