Scenario tables contain the data defined in the Economic Scenarios definition (a template is available for download, if needed). A scenario table contains properties for the scenario start date, which is used for informational purposes only for users. The table itself will contain values for each time index, starting at time 0 which represents the projection start date and going forward in time for all time periods needed.
NOTE: It is not necessary to provide every time period if the data has not changed. It is assumed that the previous time period will carry forward until the next available time period in the scenario file. This would also apply to any time periods after the end of the scenario file. The last time in the scenario file will continue to be used for all future time periods (if applicable).
Scenario tables can also contain records for time periods prior to the start of the projection as well. To specify this, use a negative time index on the scenario file. The record still must contain a record that covers time 0 (the beginning of the projection) in order to be valid.
Each record in the scenario file must contain necessary values for the fixed yield curve and each variable rate that have been defined in the scenario definition.
Example scenario file in Excel format
Economic Scenario Generators
Economic Scenarios can now be created in Slope using the industry standard New York 7, Academy Interest Rate and C3 Phase I Interest Rate Generators. To generate an economic scenario table, navigate to Define > Scenario Tables > Generate button.
Select the generator to use, add a description, add a name and a file path to store results, and set a start date.
Older versions of Slope Life Library (prior to 2021.8) do not have the appropriate Yield Curve Points configured by default. If you are using an older version, an error similar to the image below may be displayed. The error can be resolved by defining the necessary Yield Curve Points, using the edit button (top right corner of Yield Curve Rates).
You can automatically pull rates from the US Treasury using the Fetch Rates button or manually enter them. For the Academy Interest Rate generator, you will need to specify a few additional parameters: the number of scenarios, years to project and time steps. Please note that these parameters impact the time it takes to generate your scenario file.
Next, you’ll select your rate type and enter the yield curve rates (if you did not use the Fetch Rates feature). Finally, you’ll configure your variable rates. For the NY 7 generator, enter desired values for each. For the Academy generator, map your configured variable rates on your Economic Scenario Structure to the desired Academy rate. Clicking generate will create your scenario table which you can begin using in your model or download from the Economic Scenario Tables list.