Description: US GAAP for Life Insurers chapter 12 spreadsheet showing annuitization liability for pension plans and the DAC amortization schedule for Guaranteed Investment Contracts GICs. Please see the book US GAAP for Life Insurers for more details on US GAAP accounting.

Description: US GAAP for Life Insurers chapter 14 spreadsheet showing a DAC and shadow DAC calculation with shareholder equity adjustment. Please see the book US GAAP for Life Insurers for further details on US GAAP accounting.

Description: Spreadsheets that define the examples shown in Chapter 8 of the US GAAP 2nd Edition Textbook

Description: Download the papers from the Society of Actuaries 50th Anniversary monograph.

Description: Download the papers from the 2009 Enterprise Risk Management Symposium.

Description: 3 R’s and Predictive Modeling Boot Camp software package.

Description: This is a excel spreadsheeet showing mortality data from report on intercompany mortality experience by amount of insurance under standard individually underwritten issues. This study includes policy years 2005-07. Please see the SOA website experience studies for the full report and other related tables.

Description: This workbook shows the Sugarscape model. It accompanies the report Complexity Science - an introduction (and invitation) for actuaries, and supports the material in Chapter six: Cellular automata.

Description: Healthcare costs have been rising faster than general inflation for many years. Early models that predicted this past pattern projected healthcare expenditure growth that continued to outpace total expenditure growth leading to the fallacious position that the whole of the US economy would ultimately be consumed by healthcare. 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 that includes capacity constraints to ensure the long-term projection is rational. 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 is a zip file containing the following: 1. A background paper on the creation of the health trend model, 2. The model, programmed in Microsoft Excel [xls format], that projects per-person expenditures and growth rates through 2099 using baseline assumptions, but also permits the flexibility for user–inputted alternative assumptions, and 3. Technical documentation providing transparency and support for the ultimate results.