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: 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.