BBM011,2 Pensions

$\require{enclose}$
Live Lecture Materials

Pensions Overview

Notes

Pensions come in many different forms

Defined benefit and defined contribution are the main two groups. Hybrid schemes also exist such as money purchase underpin.

Defined benefit are divided into final salary

and career average revalued earnings

Defined contribution pensions are also split into company money purchase schemes (under trust)

Personal pensions (managed by an insurance company)

Group personal pensions

There are many aspects to defined benefit pensions but employer bearing the contribution risk is the main one.

With DC pensions the employee (the individual) bears the risk through the pension that will eventually be received.

Over the last 30 years there has been a large move away from DB to DC

Defined Contribution

Notes

A money or defined contribution scheme is effectively just a savings scheme

into which contributions are paid (usually) by the employer,

the employee (often)

and the taxman - although this is a matter of perspective as it is simply tax advantaged to put money in a pension

The value of the savings in the pot will then go up and down with investment return

at retirement the individual can then decide whether to take the money out as he/she wants or buy an annuity.

Drivers of Pension Levels

The spreadsheet pensions.xlsm is a simple model that allows us to understand the different factors that drive pension amounts.

Inflation is important because it erodes what the pension will buy and we would expect pay rises to target keeping up with it.

Historically average earnings are expected to exceed inflation by 1% or 2%, although for many lower paid jobs this has not been the case for many years.

Promotional additions are important especially because they make FS schemes even more advantageous to higher earners.

Investment return is clearly critical to the benefits a member receives from a defined contribution pension.

Investment return needs to be considered alongside volatility though to understand the trade-offs in DC pensions.

'pen con roll up' simply allows us to compare the value of the benefits received with the cost of paying for them.

By changing 'starting age' you can see how important saving early for your pension is.

We need to be careful with 'ret age' though as early retirement would cause a reduced pension in most schemes - this is not modelled here.

The annuity is based on the very simple 'rule of thumb': 94 - age

The accrual of 60 and max years of 40 are the typical values for how pensions work

Investigations

We can use this spreadsheet to investigate many questions about pensions.

Here are a few:

How much does a decent pension of say two thirds of final salary really cost?

How risky is investing in equities for 40 years?

How do 'Final Salary' and 'CARE' compare in terms of redistribution?

How critical is investment return to the value of a DC pension?

Final Salary Scheme Funding

Notes

In a final salary scheme, then pension is typically years service * final salary / accrual rate

Each year an extra year's service is accrued

but usually the member will get a pay rise each year as well

This continues as long as the member remains in the scheme

Final salaries are often much higher than starting salaries

There are different ways of funding such schemes. The main ones are

Predict the final salary and fund each year's accrual accordingly (Projected Unit Method)

Take the actual salary each year and then contribute for the extra years accrual and the increase in salary each year

Duration of Liabilities

Notes

As people stay in a pension scheme they will accrue more pensions.

This means that the liabilities in a pension scheme are weighted to the older members

Can you see how the 46.7 figure is calculated

The formal calculation to show the 46.7 figure is below:

Can you see how, what is effectively a weighted average calculation is set up.

Duration of Liabilities (pensioners)

For pensioner members this effectively works in reverse as the greatest liabilities are is respect of the younger members with more time left to receive their pension.

The spreadsheet: pensioner duration.xlsx illustrates this calculation by doing an accurate and then a rule of thumb calculation for the present value of the pensioner members of a scheme where everyone retires at 60 and dies at 80.

You can see that using a discount rate with a time of $\frac{life expectancy}{3}$ gives a very accurate approximation.

BUT to calculate the undiscovered valuation you need to use $\frac{members \times life expectancy}{2}$ - as this is just a triangle of numbers.

Life Annuity Approximations

This will depend on the actuarial tables we use, but the one we will start our model on will show the following calculation work well. See Rules of Thumb.xlsx

Male lives have a life expectancy of about 20 at age 64 and this then decreases by about 0.8 years per year for the years around 64.

For female lives the equivalent age is 67.

You will be able to see these calculations when you have done the first week of the coursework.

Life expectancy is often quoted at birth but this is not what matters to a pensions actuary. What is important is the life expectancy once people are retired. Other forms of mortality obviously matter more for life assurance.

Spouse's Pension

See the supporting spreadsheet: Rules of Thumb - spouse

Very approximately we add about 10% for a spouse's pension of 50% of member pension.

take a male member aged 65 and a female spouse aged 62. (on average female spouse's are 3 years younger).

Also on average women live 3 years longer than men and 90% of people get married

Let's assume 4% interest

Value of male pension is (20 - 0.8 * (65-64)) * 0.96 ^ (19.2 / 2) = 13

female should on average outlive male by 6 years (3 years younger and live 3 years longer)

So 50% pension payable to spouse from 19.2 to 25.5 years into the future (but only 90% of the time)

value of this is 0.9 * 0.5 * 6 * 0.96 ^ 22 =approx 2.7 * 0.99^70 * 0.99^18 =approx 2.7 * 0.5 * 0.84 = 1.13

So in this case a bit less than 10% of main member pension

WARNING - this is one of the weaker rules of thumb but as we are calculating a fraction of the main member pension then the accuracy is less important anyway

WARNING 2 - be careful over young spouse's etc where it can be much more expensive

Mortality evolution

This spreadsheet: males lives.xlsx show how mortality has evolved over the period from 1982 to 2019 in the UK. Recent years have not yet been posted on the ONS website

Practice questions

Question 51

Calculate the value of an annuity, payable for life from the age of 65 to a female currently aged 40. The discount rate is 1%, the increases in deferment are 2% and the increases in payment are 2%

Approx Solution

28

Exact Solution (for comparison)

28.6172446571296

Notes

base annuity 21.6 (i.e. annuity at age 65 with no discounting) net discount rate of -1% (as increases are 2% and discount rate is 1% - so future payments get more expensive by 1% each year) so add 10% to the base of 21.6 gives us 23.7 (this is the value of the annuity with increases and discounting at age 65) but the annuity starts 25 years in future at net -1% (2% increases and 1% discounting) adds bit over 1/4 (multiply by 1.01^25) so becomes 30. then chance of survival is 1-25*q52 = 1 - 25 *(1/400) = 15/16 so final value approx 30 * 15/16 approx 28

Question 52

Calculate the value of pension accruing to a male aged 40 with a salary of £30,000, in a pension scheme with an NRA of 65 and 60ths accrual. Assume inflation is 2% and interest rates are 1% and that pensions are increased in deferment and payment and salary increases 2% above inflation. (state other assumptions you have made)

Approx Solution

17500

Exact Solution (for comparison)

Notes

fwl = 12 (this is a standard assumption in the absence of other information), 30000/60 = 500 (amount of actual annual pension accrued) then calculate 500 * 1.03^12 (increases in salary for fwl net of interest rates) * 1.01^13 (increases in deferment net of interest rates) * 1.01^9 (increases in payment for half of term net of interest rates) * 19.2 (base annuity age 65) = 17.5k (approx)

Question 53

Calculate the value of pension accruing to a male aged 40 with a salary of £30,000, in a pension scheme with an NRA of 65 and 60ths accrual. Assume inflation is 2% and interest rates are 4% and that pensions are increased in deferment and payment and salary increases 2% above inflation. (state other assumptions you have made)

Approx Solution

6400

Exact Solution (for comparison)

Notes

fwl = 12, 30000/60 = 500 then * 1.00^12 * 0.98^13 * 0.98^9 * 19.2 = 6,400

Question 54

(Note: this question cannot be attempted until we have covered the life assurance chapter.) Calculate the additional annual cost of increasing the DiS benefit from 2x to 4x (for the scheme from Q53)

Approx Solution

100

Exact Solution (for comparison)

96.3489207343755

Notes

Age 40 prob of death 1/600. additional cost of benefit 2 * 30000 = 60000. so actuarial cost of benefit is 60000 / 600 = 100. NOTE: DiS benefit is calculated year on year as an on-going benefit just like year on year car insurance. There is no build up of asset share or accrued liability so you just work off the average age for one year.

Question 55

The active members of a pension scheme have a total liability of £100m. The service weighted age of the active members is 46 and the NRA is 65. The valuation has been performed with a discount rate of 2%. What would happen to the valuation if the discount rate was changed to 1.5%

Approx Solution

115000000

Exact Solution (for comparison)

Notes

Assume life expectancy of 19.2 then average at at receipt of pension is about 65 + 9.6 approx 74: duration 74 - 46 = 28, 1.005^28 approx. 1.15

Question 56

If you save £1000 per year for 30 years and get a return of 5% per year how much would you expect to have at the end of the 30 years

Approx Solution

61800

Exact Solution (for comparison)

Notes

1000 * 30 * 1.05^15 = 30000 * 2.06

Question 57

How much would the above be worth in real terms if inflation was 2% over that period.

Approx Solution

34000

Exact Solution (for comparison)

Notes

61800 / 1.02^30 = 61800 / 1.8 = 10300 / 0.3

Question 58

If annuities were priced at their pure premium how much annual income would this buy for a 65 years old woman – if it was non-increasing and discount rates were 2%

Approx Solution

1920

Exact Solution (for comparison)

Notes

annuity 21.6 *0.98 ^ 11 = 21.6 * 0.8 = 17.6, 34000/17.6 = 4% less than 2000 = 1920

Question 59

If you have a pension scheme with a duration of 20 years and a valuation of £1bn when discounted at 1% and you also have £400m of bonds with a duration of 7 years. What happens to the funding position when the interest rate increases to 2%

Approx Solution

162

Exact Solution (for comparison)

Notes

liabilities: 0.99^20=0.81 so 810m. Assets 0.93 * 400 = 372, funding position improves by 162m

Question 60

Give a typical job turnover rate for 20 to 24 year olds

Approx Solution

0.25

Exact Solution (for comparison)

Notes

Question 61

(See the 'overly hard' example question for this.)Give a typical job turnover rate for 40 to 44 year olds.

Approx Solution

0.1

Exact Solution (for comparison)

Notes

Question 62

A pension scheme which pays pension increasing with inflation from the age of 65 changes its commutation factor from 9 to 15 and allows the commutation of quarter of the pension. If everyone takes the commutation what will the financial impact on the liabilities be. (use sensible assumptions)

Approx Solution

9% increase

Exact Solution (for comparison)

Notes

mix of male and female such that LE = 20 so PV of pension = 20 (inflation = interest rates), . Consider each £4 p.a. of pension. This has value of £80 with no commutation. With 9 commutation 4 p.a. pension and commute 1/4 we get £3 p.a. pension and the £1 commutes to a £9 lump sum, so the total cost will be 3 * 20 + 9. Whereas with a 15 cf you get £15 lump sum so total cost is 20 * 3 + 15 so cost of pension goes from 69 to 75 increase of 9%

Exam type questions

New Course Logic

Notes

There are three levels we need to think of:

Full professional advice

The kind if skills you need to adapt advice in a client meeting

The skills that are tested in an exam

Building a full model office to give fully comprehensive professional advice is a huge undertaking

Meeting advice in practice will require detailed knowledge of the pension scheme or insurance company you are advising on

Actuarial exams especially CP1 often reduce to remembering a list of bullet points

The ability to write fully professional reports is something that will develop once you have the full modelling skills

The model office we build in this course will help your skills develop towards the ability to give full professional advice

The 'Rule of Thumb' calculations we develop will help you with live meeting advice skills

The old course was really centered on the traditional exam model without preparing you for giving proper actuarial advice

The new course will equip you much better for life as a professional actuary

On reflection this question is way too hard for an exam and I have changed it to give a lot of information like service of active and deferred members etc. However reading this through will still be a useful 'think like an actuary' exercise

Exam type question. (Overly Hard)

You are the scheme actuary for a company final salary scheme, which closed to new members, 10 years ago, but is still open for future accrual.

The company which sponsors it is a car manufacturer which is based in the North East of England. Many of the employees are skilled manual workers who have worked there all their lives, with many families having had multiple generations having worked at the same factory.

The defined benefit scheme is very standard with 60ths accrual, NRA of 65, spouse's pension of 50% and increases in deferment and payment which are linked to inflation but capped at 5%. There are 400 members in the final salary scheme (120 of these are active, 150 are deferred and 130 are retired). The new joiners go straight into a defined contribution scheme which has an employer contribution of 5% and an employee contribution of 5%.

The average past service for each group: active deferred and pensioners is 12 years

The average wages at present are £500 per week

a) Stating all your assumptions

iA) Reasonableness check the scheme demographics

Suggested solution
Scheme demographics

Look at the graph below:

Younger workers tend to have much higher turnover, but this is not largely relevant for this pension scheme, as the scheme is closed to new members and we can see the length of employment tends to be longer.

For this membership we are probably looking at around 8% turnover. so 12 years past service seems reasonable.

It is tempting to think that deferred members will have more service as they have now left but deferred members are skewed towards those that have left, whereas active members are skewed towards those that have stayed.

Also active members must have been there since the DB scheme closed (we are not told when this was) but would most probably be at least five years ago. It seems reasonable therefore to suggest that all three groups active, deferred and pensioners may have accrued 12 years service on average.

For a factory with skilled workers salaries will be close to the UK average of £29,600 per year. £500 per week therefore seems quite reasonable. See spreadsheet for more detailed breakdown

iB) Estimate the liabilities of the final salary scheme.

Suggested solution
Demographics Assumptions

We would also estimate the future working lifetime (for salary increase purposes) of the active members as 12 years, given turnover appears to be about 8%

We will assume a mainly male workforce (for very approximate calculations this is probably appropriate given the type of work).

The North East of England will experience higher mortality that the rest of the UK see spreadsheet. The ratio of the north east mortality 1220 to the UK mortality 1096 = 1.1 gives us an idea of the extent of this.

10% higher mortality reduces life expectancy for someone with a life expectancy of 20 years by about 2 years.

We can adjust our rule of 20 life exp at 64 to 18 years at 64 and given retirement age is 65 then we get a life expectancy at retirement of 17. We could make a further adjustment for manual work so lets say we reduce it to 16 in this case. (very crude - but shows the examiner you are aware of the issue).

The average age of our active members weighted by accrual will be higher than the middle of 18 to 65 (41.5) given scheme is closed (add say 5 years) and the triangular effect of increasing accrual (add say another 5 years). Let us assume that the average accrual weighted age of the active members is 50.

We should expect the average accrual weighted age of the deferreds to be a bit higher given they have left but the closer workers get to retirement the less they tend to change jobs so this will not be much higher say 52. The average age of the pensioners will be about 16/2 + 65 = 73.

Financial Assumptions

Fundamentally pensions are bond like so we tend to follow the yield curve of government bonds to guide our discount rate assumptions

Consider the following graph from the BoE website(of nominal yield curve from 2024):

Given the average age at death will be about 73, the duration of the active liabilities will be about 73-50 = 23 years.

The duration of the deferred liabilities will be about 73-52 = 21 years

The life expectancy of the pensioner members will be about 1/2 * 16 = 8, which is the reverse effect from building up accrual as an active member. However the duration will be about 5 years (i.e. approx 1/3 of 16, which is the reverse effect from building up accrual as an active member)

So we can use gilt rates of 5% for active members, 5% for deferred members and 4% for pension members. (crudely reading off graph in this case.

We could reduce these rates (especially active and deferred) as you will notice they happen to coincide with the higher interest rates on the curve, and in practice the liabilities will be spread either side of these durations.

The real yield curve shows modest but positive real yields at the moment

and consequently the implied inflation rate is high:

Although historically inflation has been lower, averaging roughly 2% over the first part of the 21st century up until the pandemic- so ONS data

Although historically we think of pay as exceeding inflation by about 2% per year the last few years data suggest this has not been true for some time.

It is a matter of debate amongst economists whether the long term wage growth will exceed price rises in the future.

Overall it is reasonable to assume that pay and prices have been quite closely aligned over the last 10 years if not longer and that deferred pensions and pensions in payment will reflect this.

So we will assume pay increases of 3% nominal and inflation of 2% nominal, but a higher inflation increase assumption would not be unreasonable given the BoE data.

Valuation Calculations

So looking at each cohort:

Actives

Fundamentally we are doing this: $PV \approx members\times \frac{FS \times N}{acc} \times \frac{(1+sal\_inc)^{fwl} (1+inf)^{NRA-age-fwl}}{(1+i)^{NRA-age}} \times a_{NRA}^{@i-inf\%} \times _{NRA-age}p_{age}$

So our calculation is: $120 \times \frac{26000 \times 12}{60} \frac{1.03^{12} \times 1.02^3}{1.05^{15}}\times 16 \times \frac{1.02^8}{1.05^8} \times 0.9$

So sort this out: $\approx 9m \times (1.01)^{36+6-75+16-40} \approx 9m \times 0.5 \times 1.01^13 \approx 4.5m \times (1.13) \approx 5.1m$

Note: 12/60 = 1/5, 1/5 * 120 = 24, 24 * 26 = 624 (difference of two squares), 625 (almost 624) * 16 = 10000 (as 1/16=0.0625) then times 0.9 so whole thing before discounting is 9m approx

Deferreds

Now we are doing this: $PV \approx members\times \frac{FS \times N}{acc} \times \frac{(1+inf)^{NRA-age}}{(1+i)^{NRA-age}} \times a_{NRA}^{@i-inf\%} \times _{NRA-age}p_{age}$

So our calculation is: $150 \times \frac{26000 \times 12}{60} \frac{1.02^{13}}{1.05^{13}}\times 16 \times \frac{1.02^8}{1.05^8} \times 0.9$

$\approx 27 \times 16 \times 26000 \times 0.99^{63} \approx 6.0m$

We should note here that the use of £500 for the final salary is potentially problematic as they will have left some time ago when the salaries were lower, but those deferred benefits will have been increased with inflation so if salary rises and inflation have been in line over recent years then this assumption will be fine

Pensioners:

We are now looking at typically liability-weighted average age of pensioners being a third of he way through retirement and the duration of the average pension being about one third of the total average pensions span.

Again we will work with the £500 figure as their historic final salaries would have been revalued up to this point

So now we are doing this: $PV \approx members\times \frac{FS \times N}{acc} \times a_{WAA}^{@i-inf\%} $

So this is $\approx 130 \times \frac{26000 \times 12}{60} \times 10.7 \times \frac{1.02^{5.3}}{1.05^{5.3}} \approx 6.2m$

Remainder of question using old financial data - update to follow shortly

ii) Estimate how much the liabilities would change if the long term interest rate were to increase by 1%

Suggested Solution

To answer this we need to consider the overall duration of the liabilities. This means calculating the weighted average duration of the liabilities.

We have:

GroupmembersTotal Liabilities (m)Duration
Active1205.123
deferred1505.721
Pensioner1306.26

So the weighted average duration is (6.2*5.3+5.7*21+5.1*23) / (6.2+5.7+5.1) = 16 approx.

Therefore a 1% change in interest rates will change the liabilities by about 16%.

So a 1% increase in interest rates would make the liabilities about 0.85 * 17m = £14.5

0.85 rather than 0.84 as at 16% second order quadratic effects are starting to kick in a little

Question updated down to here with update 2024 figures.

iii) Estimate how much pension you believe a typical DC member will receive if they work at the factory from age 25 to age 65.

Suggested Solution

Over this long a period it probably makes sense to assume that wages will exceed prices and use long term assumptions rather than market conditions. So we could say we expect prices to rise at 2% and wages at 3%. Often long term assumptions are that wages rise at 2% faster than prices but choosing 1% is sensible, although it is not conservative as it may under-estimate the liabilities if salary growth turns out to be higher.

It would also make sense to do the calculation in real terms so that we produce numbers that look realistic. We are not told what the investments are or what their returns are so we will initially assume a bond like investment that returns 1% nominal and so -1% real.

The real salary growth means that half way through the 40 year period that salary will be about 20% higher i.e. £600 per week or £31,000 per year. 10% of this effectively means putting £3,100 into your pension each year, but the average payment will be in the pension for 20 years and will lose about 20% of its value due to negative real interest rates.

So the total pension pot is looking like being 40 * 3,100 * (0.8) =(approx) £100,000.

You may hope for an annuity of 17 at retirement given our earlier calculations, but this ignores improving mortality, risk margins, profits, equalisation between men and women. In reality typical annuity rates (for index linked annuities) would be about 94 - age = 29.

So you could expect a pension of about £3,500 per year.

The investment assumption was critical here. If instead of assuming gilts yields we assumed that equities were used and that they returned a dividend yield of 3% on top of real economic growth then the calculation "40*3,100*0.8" becomes 40 * 3,100 * 1.03 ^ 20 = approx 40 * 3,100 * 2 (rough rule of 70) =(approx) 240,000, giving a pension of over £8,000.

You could also leave your pension invested in the stock market and receive say 3% dividends of about £7,200 per year while retaining the capital invested.

The investment strategy is currently 70% equities, and 20% fixed interest corporate bonds and 10% long dated government gilts.

The funding level is currently 85% on a gilt basis

iv) Estimate how much the company should fund the scheme by each year in order to restore the scheme to 100% funding over a 10 year period.

Suggested Solution

The are two reasons for putting more money into a pension scheme: One is to deal with underfunding. The other is to fund ongoing accrual. Ongoing accrual only applies to active members.

If (a big if) we assume the basis is government gilts then the liabilities are 39,000,000 and so 85% funded means the assets are approx 33,000,000. so we need to put an extra £600,000 in each year to deal with historic underfunding.

the ongoing accrual is for 1 years accrual where the value of 12 years accrual is £119,000 so one years accrual will be about £10,000 and across 120 members this becomes £1,200,000 per year. So the ongoing funding requirement is £1,800,000.

v) Outline the financial impacts of the investment strategy giving illustrative financial projections of different investment circumstances.

Suggested solution

We have already seen that a 1% swing in interest rates will mean a £7,000,000 swing in liabilities. However 30% of the assets of £33,000,000 are bonds so these will move in the same direction. You would hope that the government gilts would be of the appropriate duration but the corporate bonds will probably not be.

Corporate bonds are more likely to be of around 7 years duration at most, and therefore have roughly 1/3 of the interest rate sensitivity.

So if we have £6,600,000 of gilts with duration 20 years and £3,300,000 of corporate bonds with duration 7 years then a 1% increase in interest rates will decrease the value of the portfolio by 20% of £6,600,000 + 7% of £3,300,000 =(approx) £1,500,000.

So we can see that overall a 1% change in interest rates will change the funding level by about £5,500,000.

What about the equities. We have about £23,000,000 in equities and equity markets experience annual volatility of about 20% per year. so a 1 in 20 event would be about 1.96 times this i.e 40%. This equates to a fall in your portfolio of £9,200,000. So you can see this is a very material risk.

Background Reading

Prior Course Reading

Moodle Course Reading - 02. Introduction to Pension Schemes