Sensitivity and Scenario Analysis Excel Template with VBA
  • Sensitivity and Scenario Analysis Excel Template with VBA
Originally published: 08/11/2019 11:29
Last version published: 08/11/2019 15:53
Publication number: ELQ-43059-2
View all versions & Certificate
certified

Sensitivity and Scenario Analysis Excel Template with VBA

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

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

The accompanying user manual outlines the steps on how to insert the sensitivity template and the code into your own financial models.

You don't need any prior knowledge of VBA to use this template. The code is provided to you. The steps on how to go to the VBA editor and copy and paste the code is provided in the guide.

If you need to run another macro while running sensitivities like a copy and paste to avoid circular reference or a goal seek, you can slightly modify the code. The steps on how to do this is explained in the manual and in the video.

The template allows for:

- up to 10 Input sensitivity parameters
- up to 10 Output sensitivity parameters
- up to 10 scenarios

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.

If you want to use data Table instead of VBA, you can refer to my "Sensitivity analysis using Data table" tool.

https://www.eloquens.com/tool/QkrkFG2G/finance/sensitivity-analysis-excel-templates-and-methods/sensitivity-analysis-template-using-data-table

This Best Practice includes
1 Excel template, 1 PDF manual and a video

FinExMod offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Further information

To easily integrate sensitivity and scenario analysis in financial models

You have a financial model and you want to include a sheet dedicated to sensitivity and scenario analysis
You want the model to automatically run sensitivities by pressing a button
You need to run another macro while running sensitivities

Reviews


keyboard_arrow_leftkeyboard_arrow_right

Any questions on Sensitivity And Scenario Analysis Excel Template With VBA?

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


5.0 / 5 (4 votes)

please wait...