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. 

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.