Description: The American Academy of Actuaries and the Society of Actuaries have joined resources to maintain this Economic Scenario Generators Excel Workbook tool for use in regulatory reserve and capital calculations. Please see the SOA website research pages for further information on this tool and how to use it.

Description: This is an Excel spreadsheet that lists the 2001 CSO and 2001 VBT tables for various combinations of super preferred, preferred, and residual standard, for females and males, for smokers and non-smokers, and for ANB and ALB.

Description: ILEC 2005-09 All Companies A/E Mortality Ratios.

Description: ILEC 2008-09 Preferred Data All Companies A/E Mortality Ratios

Description: The Joint Academy of Actuaries’ Life Experience Committee and Society of Actuaries’ Preferred Mortality Oversight Group’s Guaranteed Issue/Simplified Issue/Preneed Working Group has developed a set of basic mortality tables for Preneed business. Select and ultimate tables for male, female and unisex were developed. All rates in the tables are on a unismoke (or composite) and age-last birthday basis. See the links below for the report and tables in Excel format.

Description: A set of improvement factors that vary by gender and attained age to be used in conjunction with the 2014 Valuation Basic table.

Description: This report contains a set of basic mortality tables for Preneed business.

Description: The Health Section Research Team is pleased to make available the following research study and Excel model that provide a framework for estimating the financial impact of health plan provider network risk. The research was conducted by the Denver office of Milliman, Inc. The Excel workbook allows the user to assess cost implications of aspects of network risk under various assumptions. The assumptions in the workbook can be altered by the user and be applied to test a range of scenarios.