Sensitivity Analysis Template Using Data Table
Originally published: 30/10/2019 09:51
Publication number: ELQ-44248-1
View all versions & Certificate

Sensitivity Analysis Template Using Data Table

This workbook and this manual are designed to help you build a sensitivity analysis into your models.

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.


This Best Practice includes
1 Microsoft Excel, 1 PDF, Step by step Video tutorial

FinExMod offers you this Best Practice for free!

download for free

Add to bookmarks


Further information

Facilitate building sensitivity analysis in financial models

You already have a financial model and you want to integrate sensitivities into your model.
You don't need to run any macros before running sensitivities.
You do not have any circular reference in your financial model

4.8 / 5 (34 votes)

please wait...