Excel Application for Insurance Reserves

Presenter Information

Brian Robertson

Document Type

Oral Presentation

Campus where you would like to present

SURC Ballroom C/D

Start Date

16-5-2013

End Date

16-5-2013

Abstract

Insurance reserves represent a financial liability for an institution that has issued contingent contracts to protect people from financial loss. Since it is a long-term liability and important to fulfill, I have created a spreadsheet calculator to compute the net level premium under input policy parameters and then determine the terminal reserves. By knowing the actuarial amount of the policy liabilities that insurance company assumes. You can get an idea of the financial status and strength of a funding arrangement. Actuarial notations that are necessary to define and compute benefit reserves will be presented. A Microsoft Excel program coded to process the contract parameters for calculating the terminal benefit reserves for a variety of insurance product types will be demonstrated.

Poster Number

23

Faculty Mentor(s)

Yvonne Chueh

Additional Mentoring Department

Actuarial Science

This document is currently not available here.

Share

COinS
 
May 16th, 11:30 AM May 16th, 2:00 PM

Excel Application for Insurance Reserves

SURC Ballroom C/D

Insurance reserves represent a financial liability for an institution that has issued contingent contracts to protect people from financial loss. Since it is a long-term liability and important to fulfill, I have created a spreadsheet calculator to compute the net level premium under input policy parameters and then determine the terminal reserves. By knowing the actuarial amount of the policy liabilities that insurance company assumes. You can get an idea of the financial status and strength of a funding arrangement. Actuarial notations that are necessary to define and compute benefit reserves will be presented. A Microsoft Excel program coded to process the contract parameters for calculating the terminal benefit reserves for a variety of insurance product types will be demonstrated.