Life Library Update 2026.02: VM-20 Templates, Automation Examples, Waterfall Chart Example, US STAT Exhibit Improvements, and More

This release adds VM-20 workbook and templates along with a published Github repository containing end-to-end automation examples leveraging the SLOPE API. Updates also include a new waterfall visualization example workbook, multiple asset enhancements and fixes, and improvements to the US STAT Exhibits workbook.

New VM-20 Templates and Workbook

Added VM-20 projection templates to help users understand how to set up VM-20 projections and the asset collar solve for starting assets:

VM-20 Stochastic Reserve containing an example stochastic reserve run under VM-20
VM-20 Asset Collar Solver Template which is paired with the previous template as part of a broader starting asset solver workflow to satisfy the asset collar test. This workflow is automated using Python scripts in a newly published Github repository (see further below) that interacts with the SLOPE API

Results can be reviewed in workbook VM-20 Reserves (found in folder Slope System / US STAT). This workbook covers:

Summary of reserve results, including the CTE(70) stochastic reserve result
Stochastic Reserve details by scenario
Stochastic Exclusion Test details
Asset Collar test details
VM-20 starting asset automation inputs for the iterative solver script contained in the published GIthub repository (see next section)

Published Github Repository With Example End-to-End Automation Workflows

Published a Github repository that contains a number of end-to-end workflow examples in Python leveraging the SLOPE API. This complements our existing published Github repository which focuses on smaller example code snippets across multiple programming languages. The recently published repository currently contains:

A VM-20 starting asset automation workflow to produce the final VM-20 reserves that satisfies the asset collar requirements.
A Bermuda SBA BEL iterative solver for specified time points in a projection.
SLOPE API wrapper functions to make it easier for users to authenticate and call the SLOPE API as part of these automation workflows.

New Waterfall Visualization Example Workbook

Added a waterfall workbook example which provides a reference for building waterfall visuals. See workbook Workbook Visualization & Element Examples in Slope System / Training & Onboarding)

Bonds & Other Asset Updates

Enhancements

Created separate spread input source parameterization for inforce/starting assets vs. assets purchased after projection start for non-callable bonds. See variable Spread Input Method.
Added an option for non-callable bonds to read spreads from a scenario table providing a template for more sophisticated spread assumptions (e.g. varying by yield curve tenor and time index).
Adjusted Spread goal seek settings when using the solve option on the bond products, which makes the solver converge more reliably.
Added a Time of Processing Start variable (Max(Time of Issue, 0)) for the non-callable bond products, which simplifies triggering calculation logic at projection start for starting assets model points or at time of issue for bonds purchased after time zero.
Adjusted Always Calculated and Output Variable properties on the bond products to align with workbook output requirements and for consistency between products

Fixes

Fixed Spread solve behavior at time 0 for inforce/starting non-callable bond assets to properly initiate the goal seek when the solve for spread option is used.
Set the Spread model point file input to Optional for products with this input field, which avoids requiring spread inputs when the model does not need them (e.g. when solving for spread).
Fixed non-callable bond model point record #2 in several projection templates containing this product since the record matured before projection start date on those templates. The record was adjusted by postponing the issue year to 2016 from 2006.
Turned off Always Calculate on the Spread variable for all bond and commercial mortgage products, which reduces the chance of Spread being evaluated when it is not required (e.g. past maturity date).
Fixed PSA Prepayments variable on the structured asset products (Asset Backed Security, Collateralized Loan Obligation, Mortgage Backed Security) to reflect the intended formula for the prepayment assumption.

US STAT Exhibits Workbook

Enhancements

Updated workbook with a ReadMe tab and usage guidance (e.g. use of US STAT Exhibits product output grouping).
Added an Exhibit 6 summary bar to help users more easily validate aggregate amounts.

Fixes

Fixed variable US STAT Valuation Basis to properly reference variable US STAT Mortality Table Name to both produce the correct groupings for the US STAT Exhibit groupings and to improve debugging of US STAT mortality assumptions
Updated workbook by removing unused outdated tables and fields, reducing potential confusion for users.

General Updates

Enhancements / Changes

Centralized Initial Asset Scaling inputs into a single table structure Initial Asset Scaling instead of being split between separate Portfolio Parameters table structure to enable a more intuitive setup for users.
Added various new initial asset scaling features (e.g. scaling based on US STAT Reported Value instead of Market Value), making different setups easier to configure
Replaced the standard Level Single Scenario to start from time index -9999 instead of -240, which supports calculations that require older historical yield curves.
Added missing Input tags and updated product variable documentation for various products, which improves usability and ease of onboarding.

Fixes

Fixed an issue causing GMWB account value to double every month in the Fixed/Indexed Annuity product’s interest crediting logic in variable GMWB Interest Credited Per Policy.
Fixed an issue in the Fixed/Indexed Annuity product where GMWB variables were inadvertently calculated for policies without a GMWB rider or during ineligible periods for the GMWB.
Corrected Term product’s Cash Flows – Liabilities variable to include surrenders and reinsurance cash flows.
Fixed US STAT Assets Before Investment in the Assumed Reinsurance portfolio to include Cash Before Investment, now consistent with the Inforce Portfolio. This sets the variable to reflect a total asset position for determining surplus positions in VM-20 and VM-22 calculations
Set the Term Life product’s Initial Premium model point file field to Optional, which supports cases where that field is not used to determine premiums.

February 13, 2026

Pension (Governmental) Library Update 2025.11 – Additional Flexibility, Enhanced Controls for Entry Age Accrual Methods, Output of Substatus, and Performance

This release introduces significant improvements to runtime performance, granular controls around the Entry Age accruals, and a stream of annual expected benefit payments, giving actuaries more precision and flexibility in pension valuations and projections. New features also include several updates to standard reporting/workbooks.

Enhancements

The library model has several enhancements that provide additional options and features:

The ability to remove compensation limits from average compensation when calculating benefit amounts
Additional granular controls for use with Entry Age accrual method related to accrual period, interest timing, timing of salary increases.
A new product variable, Participant Substatus, is captured in results representing the model point field that determines status. This will allow tracking of results separately between substatus. For instance Active Employees, and Active Employees currently in the DROP.
For Active and Vested Terminated records, users now have more flexibility for defining temporary annuity payment forms.

Option to Remove Compensation Limits in Average Compensation

The library model now contains a toggle switch to remove compensation limits when calculating an Average Compensation. See toggle in column Remove Compensation Limits? in table structure Plan Structure – Final Average Earnings Plan.

More Granular Entry Age Accrual controls

Users can now use newly created table structure Entry Age Parameters to adjust the timing by a fraction of a year for interest discounting, salary increases, and decrements used when measuring Present Value of Future Benefits at Entry and the Present Value of Future Compensation at Entry. In addition, this new table structure provides for two accrual period options using the Entry Age method, the first is from First Funding Age to Ultimate Retirement Age, the second option is from First Funding Age to last age with a future benefit. This table structure is nested within the top level table Adjustments for Annual Valuation Systems in column Entry Age Parameters.

Additional Result Splits by New Participant Substatus

The value of the model point field that determines participant status is now captured in the product variable results of a projection. This enables the separation of results into different categories of the same status. For instance, separating results for Active employees and Active employees who have entered a DROP.

Additional Parameterization for Temporary Annuity Forms of Payments

A new table structure Annuity Temporary Table adds support for annuity temporary periods defined via tables (not only integer ages), which expands flexibility for payment form definitions. This new table structure is nested within table structure Annuity Form Details.

New Workbook

Pension Trace Life New Entrant

Published new standard workbook Pension Trace Life New Entrant that is compatible with multi-year projections with new entrants. The new workbook allows users to trace individual new entrant lives and compare outcomes across entry timing scenarios, which improves validation of new entrant assumptions.

Changes and Fixes

Separated the standard 100-year expected benefit payment stream from other calculations so it can be produced from a standard 1-year valuation run, which simplifies generation of this common review output. Expected benefit payment stream is reported by benefit definition.
Modified Product variable Decrements to be compatible with:
- 100% rates of decrement prior to ultimate retirement age.
- 100% rates of decrement and a retirement date provided by a model point field.
Streamlined payment form factor calculation chains for:
- Post-decrement death annuities to provide a factor based on annual payments. See variables beginning with “Post Decrement Death Annuity”.
- Life insurance forms to provide a factor based on annual payments. See variables beginning with “Life Insurance”.
Product variables Expected Benefit Payment stream to match PVFB for Actives or VTs – Lump Sum and Expected Benefit Payment stream to match PVFB for Actives or VTs have been modified to resolve an issue when using mid-year decrement timing to produce lump sums payments deferred to a specific age.
Fixed product variable Compensation Participant History Interpolated to return correct interpolated compensation amounts between reported annual compensation amounts
Modified multiple product variables associated with the benefit formula component “Alternate Salary” to be compatible with future new entrants in a multi-year projection of an open employee group.
Modified product variable Age Beneficiary (Unrounded) to be more efficient and to prevent errors when there are significant age differences between participant and beneficiary.
Fixed product variable Annuity 70 PV Expected Stream of Unit Benefits to correct for potential errors at assumed ultimate retirement age when using mid-year decrement timing to produce the returned payment form factor.
Corrected product variable Average Compensation Lookback period for potential errors when current years of service is less than the averaging period in the average compensation calculation.
Modified the product variables associated with the Present Value Factor benefit formula component. The revisions increase efficiency and align results with prior benchmarks. See variables beginning with “PV Factor”.
Modified product variables associated with Cash Balance Plan benefit formula components. The revisions increase efficiency and align results with prior benchmarks.
Fixed product variable Benefit Definition Eligibility to properly handle mid-year decrements and benefit eligibility in the assumed year of ultimate retirement.
Modified product variable In Pay Record 91 – Expected Benefit Stream to include lump sum payments to retirees.
Corrected an issue with multi-year projections using mid-year decrements and deferred annuities in producing expected benefit payment streams. See product variable Multi Year 02 VT Expected Benefit Payment | t .
Updated the Pension Liabilities by Benefit Definitions dashboard to exclude vested terminated compensation from the “Rate of Pay at Valuation Date” field, which improves reported values for affected plans.

February 5, 2026February 6, 2026

January 2026: NAIC GOES Scenario Generator, Warning in HPM Run Logs, Direct Links to Error Variables

This release introduces built-in NAIC GOES scenario table generation, removing the need for external setup and delivering faster, more consistent regulatory and scenario analysis. Projection visibility and diagnostics are also significantly improved, with warnings now clearly separated from errors, a new Completed with Warnings status, and warning counts surfaced in projection results. Direct links from warnings and errors to the relevant variables—including one-click access to Debug View—make issue resolution quicker and more intuitive, while new API support allows projection names, folders, and tags to be updated even after a run has started or completed, helping teams stay organized as work evolves.

New Features

NAIC GOES Scenario Table Generation

You can now generate NAIC GOES scenario tables directly within the platform. This streamlines regulatory and scenario-based analysis by removing the need for external preparation and ensuring consistent, standardized scenario inputs.

Enhancements

Warnings in HPM Run Logs

Warnings that occur during HPM and Debug Mode projections are now clearly separated from errors in projection run logs. This helps distinguish between issues that require action and informational messages that do not block a run. Projections that finish successfully but encounter warnings now display a dedicated “Completed with Warnings” status and show the warning count alongside the error count in the Run Summary workbook.

Warning Count in Projection Run Summary Workbook

Direct Links to Error Variables

When warnings or errors reference a specific variable, you can now navigate directly to that variable from the error message. This significantly reduces the time spent tracking down the source of issues.

A new “Error Messages w/Debug Link” column links directly to the Error Variable in Debug View

Edit Projection Details via API for Running and Completed Projections

Projection details can now be updated after a projection has started running or completed via the PATCH /api/v1/Projections/{projectionId} endpoint. Editable fields include the projection name, folder location, and tags. This makes it easier to keep work organized as projects evolve, without needing to recreate projections.

Fixes

Fixed an issue where projections could fail to start if a model point file contained formula errors on an unused worksheet, improving reliability when launching runs.
Ensured force recalculation results in the debug view display values at the correct Time of Result, making outputs easier to review and interpret.
Resolved a failure that occurred when projections encountered empty string values during numeric conversions, preventing unexpected run failures.
Fixed an issue where models with invalid table column configurations could fail without clear feedback, improving stability and diagnostics.
Addressed an error that caused the Patch Projection API endpoint to return a server error in certain update scenarios where a model point field was changed after the file was processed, improving API reliability.
Fixed an issue where debug runs could fail due to Excel model point file parsing problems
Resolved failures in large multi-scenario and high-volume runs, improving performance and reliability for complex workloads.