• We are pleased to announce that the winner of our Feedback Prize Draw for the Winter 2024-25 session and winning £150 of gift vouchers is Zhao Liang Tay. Congratulations to Zhao Liang. If you fancy winning £150 worth of gift vouchers (from a major UK store) for the Summer 2025 exam sitting for just a few minutes of your time throughout the session, please see our website at https://www.acted.co.uk/further-info.html?pat=feedback#feedback-prize for more information on how you can make sure your name is included in the draw at the end of the session.
  • Please be advised that the SP1, SP5 and SP7 X1 deadline is the 14th July and not the 17th June as first stated. Please accept out apologies for any confusion caused.

Parents retiring - online resources?

R

RachelH

Member
One of my parents is close to retiring & has been sent some options by the pension company for annual income and lump sum payments. Can anyone point me to a good spreadsheet online that would let them play around with the options, life expectancy & income they could get on their lump sum? It doesn't look to me as if one option is much better than the other, but they are struggling to make a decision and I think seeing it all laid out on a spreadsheet may help. Thanks all.
 
Professional advice may be best.
Being an actuary (or trainee) does not necessarily mean that one is authorised to provide financial advice.
 
One of my parents is close to retiring & has been sent some options by the pension company for annual income and lump sum payments. Can anyone point me to a good spreadsheet online that would let them play around with the options, life expectancy & income they could get on their lump sum? It doesn't look to me as if one option is much better than the other, but they are struggling to make a decision and I think seeing it all laid out on a spreadsheet may help. Thanks all.

You've also got to consider the tax impact. Most people take the lump sum simply because it's tax efficient (you pay income tax on pension received but not on the lump sum, up to a maximum).

The above poster is correct though, they should seek professional advice. I thought that the Government set up either on online or telephone service for this purpose?
 
One of my parents is close to retiring & has been sent some options by the pension company for annual income and lump sum payments. Can anyone point me to a good spreadsheet online that would let them play around with the options, life expectancy & income they could get on their lump sum? It doesn't look to me as if one option is much better than the other, but they are struggling to make a decision and I think seeing it all laid out on a spreadsheet may help. Thanks all.

The other key thing to consider is that you should not be considering life expectancy tables at all. The tables are based on the average experience across a large population and therefore are only really appropriate to use if you are looking for average behavior. It is unlikely that your parents will live the average lifetime etc. Make sure they get quotes from loads of companies and don't forget the value in inflation guarantees.
 
Back
Top