Scenario Analysis - Adding Master Scenario Page to Any Model
  • Scenario Analysis - Adding Master Scenario Page to Any Model
  • Scenario Analysis - Adding Master Scenario Page to Any Model
  • Scenario Analysis - Adding Master Scenario Page to Any Model
  • Scenario Analysis - Adding Master Scenario Page to Any Model
  • Scenario Analysis - Adding Master Scenario Page to Any Model
  • Scenario Analysis - Adding Master Scenario Page to Any Model
  • Scenario Analysis - Adding Master Scenario Page to Any Model
  • Scenario Analysis - Adding Master Scenario Page to Any Model
  • Scenario Analysis - Adding Master Scenario Page to Any Model
  • Scenario Analysis - Adding Master Scenario Page to Any Model
  • Scenario Analysis - Adding Master Scenario Page to Any Model
  • Scenario Analysis - Adding Master Scenario Page to Any Model
  • Scenario Analysis - Adding Master Scenario Page to Any Model
  • Scenario Analysis - Adding Master Scenario Page to Any Model
  • Scenario Analysis - Adding Master Scenario Page to Any Model
  • Scenario Analysis - Adding Master Scenario Page to Any Model
  • Scenario Analysis - Adding Master Scenario Page to Any Model
  • Scenario Analysis - Adding Master Scenario Page to Any Model
  • Scenario Analysis - Adding Master Scenario Page to Any Model
  • Scenario Analysis - Adding Master Scenario Page to Any Model
Originally published: 30/04/2018 13:27
Last version published: 16/10/2018 09:19
Publication number: ELQ-50043-2
View all versions & Certificate
certified

Scenario Analysis - Adding Master Scenario Page to Any Model

9 Excel files that show you how to ad a master scenario page to any model.

scenarioscenario analysis

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.

This business tool includes
9 Excel Files

Prof. Ed Bodmer offers you this business tool for free!

download for free

Add to bookmarks

Discuss

Reviews

  • VVik(last updated: 31/10/2018 12:02)
  • Karabo(last updated: 25/06/2018 18:44)

keyboard_arrow_leftkeyboard_arrow_right

More tools from Prof. Ed Bodmer

See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on Scenario Analysis - Adding Master Scenario Page To Any Model?

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

please wait...