Sensitivity and Scenario Analysis Excel Template with 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