Pricing of a dataset of an actual life-risk insurance portfolio

Pricing on seven pricing bases (PB1 to PB7) for a whole life book of a commercial life insurer in Spain, original dataset found at:

https://www.openicpsr.org/openicpsr/project/178881/version/V1/view

Policies are valued as at inception date, with a minimum age of 17 years.  The maximum age is 108.

AM92 mortality, constant premium and constant sum assured were assumed.

No surrenders were assumed.  

All premiums are the monthly premium payable upfront.  Contained in the DATA worksheet.

ID = unique identifier per original DOI 

Age = actuarial age per original DOI

Sum Assured = death benefit per original DOI

Term_if = term since contract started per original DOI

PB1 - PB7 = Monthly premium

META, BASES, SUMMARY worksheets contain more details.