Please or to access all these features

AIBU?

Share your dilemmas and get honest opinions from other Mumsnetters.

Or have I completely misunderstood how pensions work

104 replies

supersuds · 08/08/2021 11:35

Just reading my annual pension statement. Appreciate I am lucky to have one.

It gives a figure which I could expect to have annually if I keep saving and retire at 60 as an annuity. When I look at how this is calculated it's based on a statutory definition from the financial reporting counsel.

The problem is the amount it says I could have in an annuity, is less than the actual amount ie if I divide the amount it says I could have as an annual annuity by my projected total savings, just drawing down the amount from the total savings, would last until I was well over 100

Ie if I have a projected pot of 250k, it says I can have an annuity if 5k a year. Even if I took the 25k tax free it would last until I was 105 if I just drew down the same amount annually from the pot.

Are these calculations/ annuities a crock of shit? Or have I misunderstood.

OP posts:
New posts on this thread. Refresh page
Rainbowshit · 13/08/2021 14:46

This thread has been interesting. I've learnt a couple of things.

Firstly xlookup is coming which I'm looking forward to.

But mostly that people actually read The Actuary and don't just flick to the jobs page?!?!😂😂

bungaloid · 12/08/2021 12:10

I bamboozle people with Power Query now to keep my wizard status.

Merryoldgoat · 12/08/2021 12:05

@bungaloid

Stop living in the past everyone, XLOOKUP is the place to be now.
Been desperate to try it but we haven’t got the latest version at work yet.

I suppose it will get rid of the need for INDEX(MATCH) which is a shame as when I use it at work people think I’m a wizard.

titchy · 12/08/2021 10:25

@bungaloid

Stop living in the past everyone, XLOOKUP is the place to be now.
Ooh nice! Thank you!
Shedbuilder · 12/08/2021 09:53

Good examples above but you also need to bear in mind that after 20 years your annual payment of £4971 in 1) is likely only to be worth £2000-2,500ish. That's because of inflation. Prices go up and up, your annuity payment stays the same.

FudgeSundae · 12/08/2021 06:53

@jcyclops

A typical annuity best buy table (real figures as at August 2021) looks like this:

Annual annuity income from a £100,000 pension, age 65, non-smoker.

  1. £4,971 Single life, level, no guarantee

  2. £4,943 Single life, level, 5 year guarantee

  3. £2,724 Single life, RPI, 5 year guarantee

  4. £3,285 Single life, 3% escalation, 5 year guarantee

  5. £4,323 Joint life 50%, level, no guarantee

  6. £2,750 Joint life 50%, 3% escalation, no guarantee

  7. You get this amount each year unchanged until you die. If you die after 2 years you have paid £100,000 and receive just £9,942 back.

  8. You get this amount each year unchanged until you die but are guaranteed to receive 5 years worth (£24,715) even if you die in the first year.

  9. You receive this amount in the first year and it increases by RPI each year until you die (with 5 years guaranteed).

  10. as (3) but it increases by 3% each year.

  11. and 6) introduce "Joint Life 50%" which means your spouse will continue to receive 50% of the payments after you die until they die. (technically, these amounts are based on a spouse who is 3 years younger than you).

You can work out that with scenario 1) after 20 years, when you are 85 you will have been paid £99,420 and will be about to "break even"

Thank you for this, I know a bit about pensions but I’ve never seen annuity rates laid out like this before. Makes perfect sense.
soupforbrains · 12/08/2021 00:24

Thought I understood pensions fairly well.

Read this thread.

Am now confused to fuck. 😂

MistySkiesAfterRain · 12/08/2021 00:23

There is an Aviva Pension Planner tool that lets you play around with 2 pensions.

PigletJohn · 12/08/2021 00:19

You can work out that with scenario 1) after 20 years, when you are 85 you will have been paid £99,420 and will be about to "break even"

I can't help noticing that if you had invested £100,000 for 20 years (like the Life Office did) then you would have amassed considerably more, even allowing for the income dribbled out of it.

MistySkiesAfterRain · 12/08/2021 00:18

@Amima

Honestly I don’t understand how pensions work. Unless you live for a ridiculously long time you end up getting less out than you put in!
You get tax relief while you are paying into it.

Essentially for every £100 I save in my pension, I get £20 in tax relief, which I could have now in my pay packet, or add it to my pension pot for later.

So if I save £100k in a pension, I could have £120k, with the extra £20k being 'free'. Plus whatever % interest it made while it was invested in stocks and shares, usually around 5% growth a year. If you take off 2% for inflation that's still 3% growth a year which beats other savings accounts.

Having a mix of money in a pension and equity in property is good. You can always move somewhere cheaper to free up cash.

jcyclops · 11/08/2021 23:31

A typical annuity best buy table (real figures as at August 2021) looks like this:

Annual annuity income from a £100,000 pension, age 65, non-smoker.

  1. £4,971 Single life, level, no guarantee

  2. £4,943 Single life, level, 5 year guarantee

  3. £2,724 Single life, RPI, 5 year guarantee

  4. £3,285 Single life, 3% escalation, 5 year guarantee

  5. £4,323 Joint life 50%, level, no guarantee

  6. £2,750 Joint life 50%, 3% escalation, no guarantee

  7. You get this amount each year unchanged until you die. If you die after 2 years you have paid £100,000 and receive just £9,942 back.

  8. You get this amount each year unchanged until you die but are guaranteed to receive 5 years worth (£24,715) even if you die in the first year.

  9. You receive this amount in the first year and it increases by RPI each year until you die (with 5 years guaranteed).

  10. as (3) but it increases by 3% each year.

  11. and 6) introduce "Joint Life 50%" which means your spouse will continue to receive 50% of the payments after you die until they die. (technically, these amounts are based on a spouse who is 3 years younger than you).

You can work out that with scenario 1) after 20 years, when you are 85 you will have been paid £99,420 and will be about to "break even"

Firstwelive · 11/08/2021 23:25

@titchy

Christ! Misread thread title as '....how PENISES work' Shock

Must get new glasses.Blush

Those too produce an annuity in the form of children, whose annual cost of living rises well above inflation rate and taxes you till you die.
Donotgogentle · 11/08/2021 23:14

You actuary types must be a right laugh down the pub with your excel functionality Grin.

Feelingoktoday · 11/08/2021 22:00

[quote SafeMove]@DadDadDad it isn't just you actuaries who are partial to a SUMIFS. My fellow research folk and I love it too!

Is there anyway of looking at your forecast if you have different pension pots? I have a local authority pension from 2004 - 2020 (approx 12 years contributions in total because of Mat Leave) and will have an NHS pension from 2020-retirement at 65 hopefully (24 years contributions in total ). Is there a generic calculator to let me look at what financial shape I will be in when I retire? Thanks all. Fascinating thread.[/quote]
I have two different public sector pensions. Both have online portals where you can mess around with retirement age, lump sums etc.

Feelingoktoday · 11/08/2021 21:53

@Amima

You also take the risk that you live a lot longer than assumed in your calculations Not likely though is it. Retirement age is going up to 70 and I only know about two people who have lived past 85.
It’s also about quality of life too. My family don’t survive beyond 75 and I don’t know anyone in their 80s who needs a lot of money because they are out and about all of the time.
bungaloid · 11/08/2021 21:51

Stop living in the past everyone, XLOOKUP is the place to be now.

StatisticallyChallenged · 11/08/2021 21:45

I do love a good Index(match) too. I think I'm sentimental about vlookup, probably the first proper excel function I learned

Merryoldgoat · 11/08/2021 21:22

Thank you so much for this thread - extremely informative and a bit scary but good to get thinking about planning properly.

And my favourite Excel function is INDEX(MATCH) but also love a bog-standard VLOOKUP wrapped with an IFERROR.

StatisticallyChallenged · 11/08/2021 21:05
Shedbuilder · 11/08/2021 21:05

Look for one who offers you the option of paying a fee for their advice. Don't know if it still goes on but there was one where I used to live who offered people free advice and took a percentage of every penny they made — which could be many thousands over several years.

Allergictoironing · 11/08/2021 20:47

@HappyAsASandboy

This is a slightly different, but related enough (I hope), question .....

If I wanted to get advice on pensions and long term investment of significant inherited capital, who should I be looking to talk to?

I feel educated enough to know I need advice but not educated enough to find it Grin I am fairly financially astute, and can wield a spreadsheet in anger to model inflation and interest, but I really would like to talk to someone well regarded who can offer proper advice.

Have a look at Citizen's Advice for guidance on finding a good Financial Advisor, or ask friends and family if they have used a good one.

Always ensure they are registered with the FCA!

Herhereherhere · 11/08/2021 20:38

Waves back at @Rainbowshit

Rainbowshit · 11/08/2021 20:34

I'm also an actuary. although I do some work with annuities and our legacy life book I work in GI.

MinnieMountain · 11/08/2021 20:27

Sorry Amima I thought you were deliberately misunderstanding DadDadDad’s very clear explanations.

I agree it should be taught as part of PHSE or whatever it’s called these days.

Amima · 11/08/2021 20:21

Thank you Amima for making this thread so amusing
You find it amusing that there are people who don’t know how pensions work? If anything you should be concerned that this information isn’t readily available. It should be being taught in schools.

Swipe left for the next trending thread