Description: This is an Excel workbook that can be used as a tool for health insurance companies to model their potential risk exposure from an influenza pandemic. It is based on a model developed for a Society of Actuaries study examining the potential implications of a pandemic on the U.S. health insurance industry. The spreadsheet is saved with many of the same assumptions used in this research and reproduces the results of the exhibits contained in the June 2010 report, 'Potential Impact of Pandemic Influenza on the U.S. Health Insurance Industry.'

Description: Actuarial appraisals are performed using discounted cash-flow models. Using local market insurance accounting standards, an appraisal model typically assumes annual after-tax distributable earnings that are repatriated to the investor. The various lines of business are modeled and validated individually and presented in separate sections of the appraisal report before being aggregated into a total company model. From Actuarial Considerations in Insurance Mergers and Acquisitions, M-FI03-1.

Description: Attempts to Quantify Potential Impact of Pandemic Influenza on the U.S. Life Insurance Industry