An Investors Guide to Pension Plan Analysis - Visualising Actuarial Assumptions

Tuesday, May 10 2016 by
An Investors Guide to Pension Plan Analysis  Visualising Actuarial Assumptions

Following from a previous article, I’ll be looking a little further at the impact of some actuarial assumptions.  It can be difficult to get your head around some of the ideas the actuaries talk about so a super simplified and visual example is a great way to get a better feel for it all.  As such we’re going to be doing some easy present value liability analysis for ‘Company X’, which is in a very unique position.

It only has a few employees, they’re all going to live for precisely 25 years after retiring and the rate of inflation will be precisely 2% from now to eternity.  Further, they’re all going retire at exactly the same time and will all receive exactly the same benefit as each other.  The accountants have decided to use a discount rate of around 3%, in line with the requirements of IAS 19.

An investor in Company X is unsure about this and wants to know what the impact might be should the number prove to be inappropriate.  As such they’ve hired us to do some sensitivity analysis on their pension fund in order to see how varying the discount rate, number of employees and benefit due to employees will affect the present value of their liabilities.

This is, of course, a completely unrealistic scenario and in reality things are much more complex, but it suffices for learning purposes and helps us to isolate a couple of effects.

Varying the Discount Rate…


First up, a brief explanation of what the chart is showing (this will be the same for all of the charts).  Let’s take the left hand side of the chart where ‘Number of Years’ = 0 on the y-axis.  Each of the different colour lines shows us the present value of the liabilities at a given discount rate (inclusive of the effect of inflation, legend on the right).

The value on the y-axis shows me the present value of the benefits due from that date to the end of the 25 years on a cumulative basis.  In other words, it adds up all the present values of individual cash flows at that point to arrive at the total still due.  As we progress to the right of the chart, the figures fall as the cumulative amount still due falls - this is simply because we’ve paid off some of…

Unlock this article instantly by logging into your account

Don’t have an account? Register for free and we’ll get out your way


As per our Terms of Use, Stockopedia is a financial news & data site, discussion forum and content aggregator. Our site should be used for educational & informational purposes only. We do not provide investment advice, recommendations or views as to whether an investment or strategy is suited to the investment needs of a specific individual. You should make your own decisions and seek independent professional advice before doing so. The author may own shares in any companies discussed, all opinions are his/her own & are general/impersonal. Remember: Shares can go down as well as up. Past performance is not a guide to future performance & investors may not get back the amount invested.

Do you like this Post?
12 thumbs up
0 thumbs down
Share this post with friends

2 Comments on this Article show/hide all

Mohammed Amin 18th Nov '18 1 of 2

The mathematics of this article are trivial for someone who is familiar with financial mathematics.

However most people are not in that position. For them, this is an excellent simple introduction to the vital importance of discount rates in computing pension fund liabilities.

| Link | Share
EssexBoy 29th Nov '18 2 of 2

An informative clearly explained exposition.

So, the largest risk is applying too high a discount rate; and of itself this can cause a deficit in the capital value of the fund.

If we add to this an existing large deficit (e.g. BT) then the capital deficit is nmagnified - as the existing deficit becomes magnified.

This suggests we should be very wary of buying shares in a company with a large existing deficit: large as in Deficit/ Net Asset Value of the company? When looking at the Stockopedia Stock Report, always I look for the Pension Deficit figure.

| Link | Share

Please subscribe to submit a comment

Stock Picking Tutorial Centre

Let’s get you setup so you get the most out of our service
Done, Let's add some stocks
Brilliant - You've created a folio! Now let's add some stocks to it.

  • Apple (AAPL)

  • Shell (RDSA)

  • Twitter (TWTR)

  • Volkswagon AG (VOK)

  • McDonalds (MCD)

  • Vodafone (VOD)

  • Barratt Homes (BDEV)

  • Microsoft (MSFT)

  • Tesco (TSCO)
Save and show me my analysis