Showing results for 
Search instead for 
Did you mean: 

Customizing the Scenario Analysis Worksheet

Customizing the Scenario Analysis Worksheet

In the web-based versions, four pre-defined scenarios are depicted by default on the Scenario Analysis worksheet. You can isolate as many or as few as you want.

To change the scenarios displayed, do the following:

  1. Hover the cursor over the Menu icon, then select Lists & Screens.


  2. On the Lists & Screens page, click the name of a list or screen to open it.
  3. When prompted to select a workbook, click Equity Fund. The workbook opens.
  4. Select the Scenario Analysis worksheet. This worksheet contains two components: Scenario Trends and Scenario Metrics.


  5. In the Scenario Trends component at the top of the worksheet, click the Component Settings icon. The Component Settings menu opens.
  6. Click Scenario > Pre-defined Scenarios, then deselect any scenario you do not want to display.


  7. Click Done.
  8. Click away from the Component Settings menu to close it.

    Note: The Scenario Metrics component at the bottom of the Scenario Analysis worksheet is not affected by the change you made in the Scenario Trends component.

For more exercises, see the Scenario Analysis guide.

Labels (1)
Version history
Revision #:
4 of 4
Last update:
‎03-22-2019 12:13 PM
Updated by: