Scenario Analysis - Adding Master Scenario Page to Any Model

Description
This tool contains 9 Excel files that show you how to a add master scenario page to any model. It also comes with an accompanying video to help explain things further.

The tools included are the following:
- Exercise files for construction of basic scenario analysis:
> Data tables and Auto open
> Data tables and Save
> Data tables without macros
> Basic scenario analysis
> Basic sensitivity analysis
> Basic custom scenario analysis
- Files associated with the video:
> Scenario reporter
> Kalitta Corporate Finance Model
> CDO Exercise

To make a master scenario page that has a base case, upside case and downside case, you can use the INDEX function combined with the DATA TABLE tool of excel. To do this, you should understand how a data table works and how the INDEX function can be used with a code number. The steps in this process include:

1. Set-up of a Separate Master Scenario page in Basic Model
2. Objective of Scenario Page
3. Understanding Data Tables for Scenario Analysis
4. Use of Code Number and INDEX or CHOOSE Functions
5. Presentation of Cash Flow Data with SUMIF
6. Putting together Scenario Analysis

These files also come with an accompanying video tutorial to assist the user.