Spreadsheet to monitor pensions

ScreamingLordCrutch

Long time lurker here.

I'm now 54 and have a DC pension I have contributed to for over 20 years, plus a couple of small others - one DC and one DB. Can someone point me in the direction of a spreadsheet where I can plug in my numbers to hopefully monitor what I could potentially receive in total when I am different ages? Ideally it would also bring in the state pension once I'm at retirement age. I have all the figures and was about to make my own but it occurred to me someone has almost certainly done one much better than anything I would knock up.

many thanks

Vespaboy

ohhhh  and me please - I too have it on my list to try and create something but I have no doubt one of you very clever people have done something already! I am not great with spreadsheets (read no idea how to create one!)

BTW - long time lurker so hello to all and Happy New Year  and all that

marlot

I gradually built my own.  Initially to be able to model different scenarios and check I wasn't being foolish in retiring early.  Now that I'm retired I use it to monitor pension performance, monthly spend etc.

It's not really suitable for distributing, alas.  I'd have to spend a lot of time making it more universal and documenting it.

foofi22

marlot said:

I gradually built my own.  Initially to be able to model different scenarios and check I wasn't being foolish in retiring early.  Now that I'm retired I use it to monitor pension performance, monthly spend etc.

It's not really suitable for distributing, alas.  I'd have to spend a lot of time making it more universal and documenting it.

Boris?         

ScreamingLordCrutch

I've found this one:
https://whatapalaver.co.uk/retirement-planning-couples

I think I'll give it a go.

Marcon

I'm sure someone here has - 'Snowman' rings a bell but I can't find it! Please could anyone else help where my search abilities have failed?

westv

Marcon said:

I'm sure someone here has - 'Snowman' rings a bell but I can't find it! Please could anyone else help where my search abilities have failed?

Not sure about others, but I find the search facility on here a bit pants since the new forum.

[Deleted User]

https://forums.moneysavingexpert.com/discussion/5583030/coolly-comparing-investment-platform-charges-snowmans-spreadsheet/p1
But that's only for charge comparison between platforms
(I used google rather than the search here)

[Deleted User]

Spreadsheet does whatever you tell it to. You have not specified the method you plan to use for estimating your income. 

The following link has a spreadsheet which does what you want in $s, including accounting for State Pension. It is based on the Variable Percentage Withdrawal method.  

https://www.finiki.org/wiki/Variable_percentage_withdrawal

cfw1994

ScreamingLordCrutch said:

Long time lurker here.

I'm now 54 and have a DC pension I have contributed to for over 20 years, plus a couple of small others - one DC and one DB. Can someone point me in the direction of a spreadsheet where I can plug in my numbers to hopefully monitor what I could potentially receive in total when I am different ages? Ideally it would also bring in the state pension once I'm at retirement age. I have all the figures and was about to make my own but it occurred to me someone has almost certainly done one much better than anything I would knock up.
many thanks

You are pretty well exactly where I was 2 years ago.
I have one I’ve built myself....happen to love a good spreadsheet!
A year per row, income streams (different pots, state pension/s) in columns, then some guesswork jiggery-pokery to try to estimate where you sit on the grey wedge of death (rich, penniless or dead!!).
If interested, message me: I have a “sanitised” version I have shared a few times with people on this forum (& with some workmates).  If you want to include any numbers (age/ages, target income, DC pot/s, etc), I can try to edit them in as a kick starter, but it is pretty self explanatory really, & I understand not wanting to share too much detail to a stranger on the internet!
I do ask for comments back - still trying to figure out what I have missed, mere months before I jack the work income stream in!

ScreamingLordCrutch said:

I've found this one:
https://whatapalaver.co.uk/retirement-planning-couples

I think I'll give it a go.

That looks pretty interesting, btw - I haven’t seen that one before: I will take a look myself later, thanks!

shinytop

https://www.vertex42.com/ExcelTemplates/retirement-planning-spreadsheet.html
I used one from here and adapted it.  There are ads on the site but you can download the sheets.