Life Insurance model

This is a simple life insurance model with death benefit calculations. You can create an instance of this project in your workspace as the following: create a new project, select the “Life Insurance” sample project, click create.

The model includes the following group of formulas:

• create genderless Lx and Commutation tables from mortality table (optional)
• calculate frequency premium for a contract
• calculate premium reserve for a contract

You can also navigate (left menu):

• to Tests to see testing features
• to API to see how a web service API can be created from you Calculation Model.

Note

In order to continue you need to login to your workspace and create a new project using the “Life insurance” sample as template

Create the genderless L table

This task shows you how to use the formulas to (re)create the genderless mortality table from a fictitious statistics including both genders. The blended mortality is calculated with 75% of male and 25% of female weights.

Note

The Genderless L table is already created for you, you can skip this task if you want.

This process takes the LwG (L with Gender) table as input and produces the L (genderless table) table as the output. Before starting you can delete this result parameter table from the Commutation numbers module as this will be the output of this process.

Evaluate the L table generation formula

The formula that generates the table is the following:

${\mathit{L}}_{\mathsf{blended}}=⟨\left({\left(\mathit{l}\right)}_{\mathsf{age}},{\left(\mathit{l}\right)}_{\mathsf{male}}\cdot \mathrm{0.75}+{\left(\mathit{l}\right)}_{\mathsf{female}}\cdot \mathrm{0.25}\right)|\mathit{l}\in \mathsfit{LwG}⟩$

In order to run the formula we need an evaluation configuration.

Create a new Evaluation context with these modules:

• Basic calculations
• Commutation numbers

Variables to use:

• Add $\mathit{i}$ the technical interest rate input variable (set it to some value e.g. 0 if you have no preference)
• Add ${\mathit{L}}_{\mathsf{blendedSorted}}$ output variable

Calculation output:

• Following calculations, inspect the output of the ${\mathit{L}}_{\mathsf{blendedSorted}}$ variable and download it’s contents as a CSV file.

Note

You can preview and download the contents of a variable by clicking the “eye” icon.

Age;Count

Upload the CSV file

1. Create the new L table in the Commutation numbers module.
2. Set first row as header
3. Browse to the CSV file and load it
4. Set the Domains:
• age: %N
• count: %R
1. At this point you should be able to preview the contents of the table. If all seems ok to the import.

Create the commutation table - C

This task shows you how to recreate the commutation (C) table. This table includes some intermediate variables for each age to make premium calculations more efficient.

$\mathit{CN}=⟨\left(\mathit{x},{\mathit{l}}_{\mathit{x}},{\mathit{d}}_{\mathit{x}},{\mathit{C}}_{\mathit{x}},{\mathit{D}}_{\mathit{x}},{\mathit{M}}_{\mathit{x}},{\mathit{N}}_{\mathit{x}}\right)|\mathit{x}=\mathrm{0},\mathrm{\dots },\mathrm{card}\mathsfit{L}-\mathrm{1}⟩$

The variables ${\mathit{l}}_{\mathit{x}},{\mathit{d}}_{\mathit{x}},{\mathit{C}}_{\mathit{x}},{\mathit{D}}_{\mathit{x}},{\mathit{M}}_{\mathit{x}},{\mathit{N}}_{\mathit{x}}$ refer to indexed functions, you can find them in the sample project’s Commutation Numbers module. The modules begin with the lookup of the L table at age x:

${\mathit{l}}_{\mathit{x}}≔\left({\left(\mathit{lx}\right)}_{\mathsf{count}}|\mathit{lx}\in \mathsfit{L}\wedge {\left(\mathit{lx}\right)}_{\mathsf{age}}=\mathit{x}\right):\mathit{x}\in \mathbb{N}$

and the formula source for the above lookup function is below:

l_x := ((lx)_'count | lx (- @L /\ (lx)_'age = x) : x (- %N

This process assumes that you already have L, the genderless L table (see previous section)

Evaluate the Commutation sequence generation formula

Create a new Evaluation context with these modules:

• Basic calculations
• Commutation numbers

Variables to use:

• Add i the technical interest rate input variable
• Add CN output variable, commutation numbers

Download CN contents as a CSV file.

Note

You can do this as previously clicking on the “eye” icon on the CN output variable after calculating it’s value in the Evaluation dialog.

age;lx;dx;Cx;Dx;Mx;Nx

Upload the CSV file

Create the new C table in the Commutation numbers module.

Set first row as header.

Browse to the CSV file and load it.

Set the Domains:
• age: %N
• lx: %R
• dx: %R
• Cx: %R
• Dx: %R
• Mx: %R
• Nx: %R

At this point you should be able to preview the contents of the table. If all seems fine, do the import.

The modules “Basic Actuarial Calculations” and “Premium Calculation” do the actual calculations based on the Commutation Numbers table (prepared above).

A quick preview of the calculations shown below:

1. The net premium formula

${\mathit{P}}_{\mathit{x},\mathit{n},\mathit{SA}}≔\mathit{SA}\cdot \frac{{\mathit{A}}_{\mathit{x},\mathit{n}}}{{\mathit{a}}_{\mathit{x},\mathit{n}}}:\mathit{x}\in \mathbb{N};\mathit{n}\in \mathbb{N};\mathit{SA}\in \mathbb{R}$

1. The formula definitions for ${\mathit{A}}_{\mathit{x},\mathit{n}}$ and ${\mathit{a}}_{\mathit{x},\mathit{n}}$ variables

The variables below refer to the indexed commutation number lookup formulas ${\mathit{N}}_{\mathit{x}},{\mathit{D}}_{\mathit{x}},{\mathit{M}}_{\mathit{x}}$ References to indexes can also be expressions like this one ${\mathit{M}}_{\mathit{x}+\mathit{n}}$

Fixed term annuity:

${\mathit{a}}_{\mathit{x},\mathit{n}}≔\frac{{\mathit{N}}_{\mathit{x}}-{\mathit{N}}_{\mathit{x}+\mathit{n}}}{{\mathit{D}}_{\mathit{x}}}:\mathit{x}\in \mathbb{N};\mathit{n}\in \mathbb{N}$

Whole life for one unit of SA:

${\mathit{A}}_{\mathit{x},\mathit{n}}≔\frac{{\mathit{M}}_{\mathit{x}}-{\mathit{M}}_{\mathit{x}+\mathit{n}}}{{\mathit{D}}_{\mathit{x}}}:\mathit{x}\in \mathbb{N};\mathit{n}\in \mathbb{N}$

Calculations can be evaluated by creating an evaluation configuration with the following modules:

• “Basic actuarial calculations” 