Sensitivity Analysis Template

Demonstrate the effects of changes in variables on the final outcome

Author: Kevin Henderson
Kevin Henderson
Kevin Henderson
Private Equity | Corporate Finance

Kevin is currently the Head of Execution and a Vice President at Ion Pacific, a merchant bank and asset manager based Hong Kong that invests in the technology sector globally. Prior to joining Ion Pacific, Kevin was a Vice President at Accordion Partners, a consulting firm that works with management teams at portfolio companies of leading private equity firms.

Previously, he was an Associate in the Power, Energy, and Infrastructure Investment Banking group at Lazard in New York where he completed numerous M&A transactions and advised corporate clients on a range of financial and strategic issues. Kevin began his career in corporate finance roles at Enbridge Inc. in Canada. During his time at Enbridge Kevin worked across the finance function gaining experience in treasury, corporate planning, and investor relations.

Kevin holds an MBA from Harvard Business School, a Bachelor of Commerce Degree from Queen's University and is a CFA Charterholder.

Reviewed By: Patrick Curtis
Patrick Curtis
Patrick Curtis
Private Equity | Investment Banking

Prior to becoming our CEO & Founder at Wall Street Oasis, Patrick spent three years as a Private Equity Associate for Tailwind Capital in New York and two years as an Investment Banking Analyst at Rothschild.

Patrick has an MBA in Entrepreneurial Management from The Wharton School and a BA in Economics from Williams College.

Last Updated: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

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