Description: The Required Minimum Distribution RMD working group of the Taxation Section has completed research in determining the actuarial present value of additional benefits for computing RMD under deferred annuity contracts. This is Appendix G spreadsheet for the Determining the Actuarial Present Value of Certain Additional Benefits for a two tiered fixed annuity benefit Under Treas. Reg. Section 1.401a9–6, Q&A–12 research project. Please see the SOA website research section for the full report and other appendices spreadsheets.

Description: The Required Minimum Distribution RMD working group of the Taxation Section has completed research in determining the actuarial present value of additional benefits for computing RMD under deferrred annuity contracts. This is Appendix B Example 2 spreadsheet for GMDB for this research project. Please see the SOA website research section for the full report and excel spreadsheet for the other appendices.

Description: The Required Minimum Distribution [RMD] working group of the Taxation Section has completed research in determing the actuarial present value of additional benefits for computing RMD under deferred annuity contracts. This Appendix E spreadsheet is for the Guaranteed Minimum Withdrawal Benefit [GMWB] calculation. See the SOA website research section for the complete report and excel spreadsheet for the other appendices.

Description: 2011 SOA IFRS Seminar, Hong Kong. This is an Excel spreadsheet associated with Session 15 - 'Cash Flows Workshop' at the 2011 SOA IFRS Seminar held in Hong Kong. This spreadsheet facilitated the sessions objective of calculating the beginning liability values for the Statement of Financial Position.

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 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: 2011 SOA International Financial Reporting for Insurers Seminar, Hong Kong. This is a spreadsheet associated with Session 26 – 'Presentation Workshop' held at the 2011 SOA International Financial Reporting for Insurers Seminar in Hong Kong. This spreadsheet facilitated the objectives of the workshop which focused on building the statement of comprehensive income using the exposure draft approach.

Description: Excel spreadsheet showing immediate annuity example of GAAP benefit reserves and Unearned Revenue Liability calculation from the U.S. GAAP & IFRS: Today and Tomorrow conference in New York in September of 2010.

Description: Recognizing an opportunity to help serve its members in this age of increased financial oversight, the Health Section of the Society of Actuaries commissioned a series of guides on the use of statistical techniques specifically geared for the work of health actuaries. The first guide in the series titled, 'Statistical Methods for Health Actuaries - IBNR Estimates: An Introduction,' is about the calculation of incurred but not reported [IBNR] health claims reserves. In particular, the guide focuses on the development of confidence intervals around IBNR estimates. This is an Excel workbook created to demonstrate the techniques discussed in the guide.

Description: Authored by a MIB Solutions team of Tom Rhodes, Stuart Klugman, Marianne Purushotham and Stacy Gill, the report summarizes the results of a study on the application and adoption of credibility theory within the life insurance and annuity industry. This excel spreadsheet is a numerical example relating to the application of Credibility for lapses. Please see the SOA website research section for the complete research report on Credibility Theory Practices.