Sensitivity Analysis Template Using Data Table

Description
In this manual you will learn in step by step and easy approach, how to insert the Sensitivity template into your own financial models and set it up with Data Table to run sensitivity analysis.

All the steps are explained in details with snapshots of steps to take in order to make it easy to follow.

It doesn’t cover the important step in conducting a sensitivity analysis which is how to identify the outputs and inputs of the sensitivity analysis.

If you want to know more about how to identify your key performance indicators and sensitivity parameters check “Season 2, Episode 8” of the Financial Model Detective book.

Here are two important notes:

- Data Tables will slow down calculations in your workbook.
- If you need to run another macro for example a copy and paste or a Goal Seek while running sensitivities, you cannot do this using Excel’s built in Data Table function. You need to then use VBA code instead of data tables.

Once you’ve had a chance to use the sensitivity template, I would love to hear from you. please share your thoughts and ideas directly in the comments.

In the meantime, stay $locked$ and happy modelling.

Hedieh