Description: US GAAP for Life Insurers chapter 7 spreadsheets. Spreadsheets demonstrate cashflows for single premium deferred annuity under SFAS91. Please see the book US GAAP for Life Insurers for full detail on US GAAP.

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.

Description: US GAAP for Life Insurers chapter 9 spreadsheets showing examples of payout annuities. Please see the book US GAAP for Life Insurers for more details on US GAAP accounting.

Description: US GAAP for Life Insurers chapter 5 spreadsheet. This spreadsheet shows various tables and figures illustrating the development of expected gross margins, dividends, and DAC amortization for a participating 10 year endowment policy. Please see the book US GAAP for Life Insurers for full details on US GAAP accounting.

Description: US GAAP for Life Insurers chapter 6 spreadsheets. Various spreadsheets illustrate a Universal Life product and the various accounting needs under SFAS97 including DAC and Unearned Revenue Reserve amortization and assumption unlocking. Please see the book US GAAP for Life Insurers for full details on US GAAP accounting.

Description: US GAAP for Life Insurers chapter 17 spreadsheets showing various examples of GAAP for reinsurance transactions. Examples shown include reinsurance for disability insurance, YRT, Modco and coinsurance on a 10 year endowment reinsurance on Universal Life. Also shown is an example for DIG36, Total Return Swap with Floating Return Leg. Please see the book US GAAP for Life Insurers for further details on US GAAP accounting.