Recurrent problem

Actuarial work involves calculating the present value of future liabilities.  In the case of pension funds and annuity portfolios, this means valuing future pension payments. This typically involves calculating a lot of annuity factors, often using spreadsheets.

One approach is to calculate the survival curve, then to apply a discount factor to calculate the present value of payments at each age.  Summing these discounted future values gives the annuity factor at the outset age of the survival curve.  However, if annuity factors have to be calculated en masse, it is sometimes much more effective to make use of the recurrence relations between successive annuity factors, as shown in Figure 1.

null
Figure 1. Recurrence relations between single-life annuity factors.

where i is the interest rate and qx is the mortality rate at age x.  These recurrence relations are particularly useful when having to calculate an annuity factor which includes allowance for benefits paid to a surviving spouse.  For this we need not only the single-life annuity factors for the first and second life, but also the factor for a joint-life annuity, i.e. one which terminates on the first death.  These are shown in Figure 2:

null
Figure 2. Recurrence relations between joint-life annuity factors.

where y is the spouse's age. Finally, we just need the formulae for calculating annuity factors where f is the proportion of the main benefit paid to the spouse after death of the main life, as shown in Figure 3:

null
Figure 3. Formulae for annuity factors for main life x and contingent spouse's annuity to y of proportion f of main benefit.

The recurrence relations in Figure 1, 2 and 3 can be very useful when one has to calculate a large number of annuity factors, and they are especially useful when spouses' benefits are involved.

Written by: Stephen Richards
Publication Date:
Last Updated:

Annuity calculation en masse

Users of Longevitas or the Projections Toolkit can calculate annuity factors en masse using the relevant menu item at the top of both tools ("Explore bases").  In addition, a spreadsheet version can be downloaded for integrating into your own applications (accessed by clicking on the "Annuity" icon).  The annuity factors can either be for a single life only or with a proportion of benefit paid to a surviving spouse. 

Previous posts

Risk and models under Solvency II

Insurers need to have internal models for their major risks. Indeed, both the Individual Capital Assessment (ICA) regime in the UK and the pending Solvency II rules in the EU demand that insurers have good models for their risks.
Tags: Filter information matrix by tag: ICA, Filter information matrix by tag: Solvency II, Filter information matrix by tag: model risk, Filter information matrix by tag: basis risk, Filter information matrix by tag: concentration risk, Filter information matrix by tag: model points

Everything counts in large amounts

Models for projecting mortality are typically built using information on lives with deaths by age and gender. However, this ignores an important risk factor for longevity, namely socio-economic group. For annuity and pension reserving, therefore, it would be helpful to use such information when building stochastic projection models.

Tags: Filter information matrix by tag: basis risk, Filter information matrix by tag: piggyback model, Filter information matrix by tag: amounts-weighted mortality

Add new comment

Restricted HTML

  • Allowed HTML tags: <a href hreflang> <em> <strong> <cite> <blockquote cite> <code> <ul type> <ol start type> <li> <dl> <dt> <dd> <h2 id> <h3 id> <h4 id> <h5 id> <h6 id>
  • Lines and paragraphs break automatically.
  • Web page addresses and email addresses turn into links automatically.