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

Sensitivity Analysis Template Using Data Table

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

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

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

Discuss

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

Reviews

keyboard_arrow_downShow all


keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from FinExMod

See all
keyboard_arrow_leftkeyboard_arrow_right

Discussion feed for Sensitivity Analysis Template Using Data Table

The user community and author are here to help. Go ahead!

  • Hedieh Kianyfard
    Thanks for downloading the Sensitivity Analysis template.

    Once you’ve had a chance to use the sensitivity template, I would love to hear from you.

    1. Did you find this tool useful?
    2. Could you easily follow the steps described in the video and manual?
    3. Would you like to have more tools like this?

    Please share your thoughts and ideas directly in the comments.

    Thank you so much for downloading, commenting and sharing.

    Best regards,

    Hedieh
    arrow_drop_uparrow_drop_downReply reply
    • Arif Arafat Zahari
      Hi thank you for the template, I'm Arif and a student. I couldn't understand the step 3. How when we link the senstivity to FM and then the price of capex change? What J66 refferring like in video?
      arrow_drop_uparrow_drop_downReply reply
      • FinExMod
        Hi Arif, that's where you need to link the sensitivity parameters to your calculations. For EPC sensitivity, you go to your EPC line, and multiply that cell by (1 + EPC sensitivity parameter 10%). In my case EPC sensitivity factor in base case is 0%. You can define your sensitivity parameter in base case as 100% and simply multiply EPC by sensitivity parameter this time 100%. So for 10% increase you need to define sensitivity factor as 110% and for 10% decrease in EPC you should define the sensitivity parameter as 90%. This is just about cosmetics. Let me know if this answers your questions.
        arrow_drop_uparrow_drop_downReply reply
      • Hedieh Kianyfard
        Hi there,
        By now I hope you’ve had a chance to use the sensitivity template in your own models.

        I uploaded a revised version of the same template but this time using VBA so you don’t have all the inconveniences of DataTable.
        Here’s where you can get the tool:

        https://www.eloquens.com/tool/aAJEF2nD/finance/sensitivity-analysis-excel-templates-and-methods/sensitivity-and-scenario-analysis-excel-template-with-vba

        Of course, if you have questions or comments — just hit reply and I’ll be happy to hear from you.

        Thank you so much for downloading, commenting and sharing.

        Best regards,

        Hedieh
        arrow_drop_uparrow_drop_downReply reply


        4.8 / 5 (16 votes)

        please wait...