Excel Application for Insurance Reserves
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.
Recommended Citation
Robertson, Brian, "Excel Application for Insurance Reserves" (2013). Symposium Of University Research and Creative Expression (SOURCE). 50.
https://digitalcommons.cwu.edu/source/2013/posters/50
Poster Number
23
Additional Mentoring Department
Actuarial Science
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.
Faculty Mentor(s)
Yvonne Chueh