Description: The Society of Actuaries' Pension Section and Health Section Research teams commissioned Professor Thomas E. Getzen of Temple University to construct a resource model for the projection of long term healthcare cost trends. The motivation for creation of the model was driven by its potential usage as a resource for the estimation of reportable liabilities for retiree healthcare benefits as specified under FAS 106 and GASB 45 accounting statements. This model, programmed in Microsoft Excel [xlsx format], projects per-person expenditures and growth rates through 2099 using a set of equations and assumptions developed by Professor Getzen with assistance from the Society of Actuaries Project Oversight Group appointed to oversee the effort. The model includes baseline assumptions as well as flexibility for user–inputted alternative assumptions.

Description: Excel file from Health Pricing Boot Camp Session 1: Basic Trend Forecasting Model Case Study

Description: The 2013 Individual Disability Income Valuation Table (2013 IDIVT) approved by the NAIC as the new statutory minimum reserve morbidity basis.

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.

Description: Excel file containing extracts of utilization and costs for chiropractic and acupunture - all members combined. From a research project examining the utility of standard eligibility and claims extracts for complementary and alternative medical therapies - CAM analysis.