Description: Excel spreadsheet example of GAAP calculations for a Universal life plan showing reserves and DAC under FAS97 . Also shown is an unlocking example from this session of the 2010 U.S GAAP & IFRS conference in New York.

Description: The Preferred Mortality Valuation Table Team prepared this presentation for the June 2008 NAIC LHATF Meeting. The Adobe Acrobat file on the SOA website for experience studies contains the presentation.This Excel workbook is a tool the valuation table team is using to develop values relating to margins for the new valuation mortality table. The purpose of the workbook is to evaluate different margin formulas and valuation tables. Also used for analysis of mortality margins on Valuation Basic Tables.

Description: 2010 CLICE expense study worksheet

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: This is an Excel spreadsheet, provided by the Society of Actuaries Pension Section, containing the interest rates and Consumer Price Index figures needed for calculating Canadian pension plan Transfer Values.