Sensitivity Analysis Table - Excel Model Template
Originally published: 20/06/2019 13:27
Last version published: 04/02/2020 15:01
Publication number: ELQ-80994-2
View all versions & Certificate
certified

Sensitivity Analysis Table - Excel Model Template

This is an Excel template of the Sensitivity Analysis Table

Description
This model allows you to generate a table in order to determine how the final outcome is influenced by various variable changes.

The advantage of this model is that you can insert your own data (numbers and formulas) to auto-generate output numbers.

The template consists of ten different tabs which include:
- Assumptions;
- Income Statement;
- Balance Sheet;
- Cash Flow Statement;
- Property Plan and Equipment (PPE) Schedule;
- Debt Schedule;
- Discounted Cash Flow (DCF);
- Leveraged Buyout (LBO) Modeling;
- Free Cash Flow to Equity (FCFE) Valuation;
- Private Equity's (PE) Returns Analysis;
- Weighed Average Cost of Capital (WACC) Calculation.

The model is perfectly laid out for a simple and straightforward use.

If you have any questions and / or comments about the tool, please do not hesitate to get in touch with the Author via private message or start a discussion below!

For more financial templates such as the Income Statement, Balance Sheet, Cash Flow Statement, Debt Schedule, Interest Payments, Not Operating Loss Carryforward, Multiples Analysis
Excel models etc., please visit our Eloquens channel.

We also offer a great amount of resources to help you create your resumes for different fields (Investment Banking, Private Equity, Consulting, Hedge Fund etc.) and for different levels (Experienced or Graduate).

This Best Practice includes
1 Excel file

Wall Street Oasis offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss


4.8 / 5 (14 votes)

please wait...