Month: January 2023

Enhancements

Debug Tab : Variable Properties, Last Updated Date & Sharing

Users can now view a variable’s properties and settings on the Debug tab for faster trouble shooting. The settings on the debug view are view only with a link to navigate to the variable and edit as needed.

On the right hand side of the variable properties and settings panel, Slope will display a last updated date. If the variable has been updated since the projection was run, a warning icon will display. When a variable has been updated after a projection was run, the values displayed are from the projection results but the properties and formula reflect the current state of the model. This warning should alert users to potential discrepancies.

The Debug tab also has a new ‘Share’ button in the top right corner so that you can share a url with the selected projection and other filter values currently set. This is helpful when sharing results with a colleague or Slope’s support team.

API Enhancements:

The Workbook ID and Element ID needed to download projection results via the API has been added to the url when you click the desired workbook table within the Slope application. For more information on downloading results via the Slope API visit our Support site.

Workbook Enhancements:

Two new functions are now available for use in workbooks: FirstNonNull and LastNonNull. FirstNonNull repeats the first non-null value of a given column for every row in a column. LastNonNull repeats the last non-null value of a given column for every row in a column.

Conditional formatting column selection now allows the user to select multiple columns without the drop down menu closing with each selection to allow for more efficient configuration.

Fixes

• Resolved an error that occurs when an out of date data table version is merged into another model.
• Data tables for deleted table structures will no longer show up in the copy confirmation modal.
• Improved error messaging to provide informative descriptions in place of more generic errors when a product is missing on a projection and when a template name is a duplicate.
• Library models will consistently load when selected in the Model Development module.
• Resolved an intermittent file upload issue with large model point files.

New Model

A new Claim Reserve/IBNR model can be used to calculate claim reserves and/or IBNR using traditional claim triangles and the chain-ladder method. This model is now available in the Library Models tab alongside the Slope Life Library.

Updates

Long Term Care Product

• Now supports a 3rd benefit path for Assisted Living in addition to the 2 existing options
• Significant changes to the array structures of benefit projections to improve performance
• The LTC-2015 study tables from the SOA are now available as part of the Library and input structures have been updated to support this

Term Life Product

A correction was made to the XXX reserve calculations on the Term life product to fix an issue where the expense allowance was not being properly calculated in some cases.

Liability Products

New variables have been added to liability products for US STAT Valuation Basis and US STAT Line of Business. These new variables, combined with the US STAT Exhibits product output grouping will allow for the population of Exhibit 5 & 6 reports.

Valuation Method inputs for UL, Term, and Whole Life were converted to drop-down list items to allow for easier selection of values.

The Commissions table structure was updated to add Issue Age and Premium Payment term as available columns by default. All liability products that use this table were updated to reflect this.

The Lapses table structure was updated to add Premium Payment term as an available column by default. All liability products that use this table were updated to reflect this.

All Liability products were updated to allow either Date of Birth or Issue Age to be provided. Only 1 of the inputs must be provided. DOB will always be used instead of Issue Age if both are provided.

Asset Products

AVR Line Number is no longer required on assets and the default data type has been changed to string.

When missing, the AVR Line number will now be looked up based on the NAIC SVO Rating or default to a medium risk category depending on the asset type.

New Workbooks

• Long Term Care workbook which provides detailed information for a single LTC policy for analysis purposes.

• ‘US STAT Exhibits’ workbook populates values for Exhibit 5 & 6.

• Claim Reserve Summary (IBNR) workbook is now available to display the resets from the new Claim Reserve/IBNR model.

• Term Life Workbook which provides a US STAT Reserve Summary, Cash Flow, US STAT XXX Basic Reserve and US STAT XXX Min Reserve worksheet.

Note: New workbooks can be found in the Slope System workspace folder which can be accessed via the folder icon in the lower left corner of the Execute and Analyze modules. The Long Term Care and Term Life workbooks can be found in the Liability Products subfolder.