Description: A divisive confrontation over health care pricing is almost inevitable over the next few years. What will ultimately happen is a political decision, not an actuarial one—but it will have major consequences for the trend in health care costs and the divergence between public and private insurance premiums.

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: Supporting Excel file for Getzen Model 2022.

Description: This is the databook for the "Health Care Cost - From Birth to Death". This study used commercial data held by the Health Care Cost Institute (HCCI) and Medicare fee-for-service data to analyze health care cost differences by age and their contribution to overall health care cost change. The commercial data includes claims from 2002 through 2010 and the Medicare data includes claims from 2006 through 2010.

Description: This is an Excel workbook that can be used as a tool for health insurance companies to model their potential risk exposure from an influenza pandemic. It is based on a model developed for a Society of Actuaries study examining the potential implications of a pandemic on the U.S. health insurance industry. The spreadsheet is saved with many of the same assumptions used in this research and reproduces the results of the exhibits contained in the June 2010 report, 'Potential Impact of Pandemic Influenza on the U.S. Health Insurance Industry.'

Description: Dataset to accompany Fifty States, Fifty Stories: A Decade of Health Care Reform Under the Affordable Care Act - Technical Report

Description: The MACRA/QPP Payer Revenue Model is designed to provide Health Plans an estimate of the expected claim cost increase/decrease due to MACRA.

Description: The Society of Actuaries and LIMRA have sponsored a U.S. Individual Disability Income Persistency Study. The report, authored by Cathy Ho and Steve Elek, presents the results of a study of individual disability income (“IDI”) lapse experience in the United States between observation years 2000 and 2007. This is the first report in a two-part series that will present results of a study conducted jointly by LIMRA and the Society of Actuaries (SOA) and based on data provided by 12 individual disability income insurance writers.

Description: Data file for Commercial Health Care Cost and Utilization Trends From 2009–2015 research report.