Sensitivity Analysis Template

Demonstrate the effects of changes in variables on the final outcome

Patrick Curtis

Reviewed by

Patrick Curtis

Expertise: Private Equity | Investment Banking


January 31, 2022

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.

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:

A screenshot below shows a sneak peek of the template.

Sensitivity Analysis Template

Elite Modeling Package

Everything You Need To Master Financial Modeling

To Help you Thrive in the Most Prestigious Jobs on Wall Street.

Learn More

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:

Attachment Size
Sensitivity Analysis Template.xlsx 143.3 KB 143.3 KB