I revisited my retirement plan the other day. I’ve got a really geeky spreadsheet that I can play with to work out whether I’d be on track to retire under different scenarios. Anyway, I realised that I’d forgotten to include my stocks and shares ISA into the mix, even though I plan to use that money for retirement.
Guess what I discovered.
If I maintain my current contributions (increasing them only with inflation) I’ll be able to retire a full 10 years earlier than I originally expected, providing that my annual investment return is about 4% above inflation. Of course I intend to ramp up my contributions rather than keep them relatively level as I put half of every pay rise into investments.
To me, this is quite exciting news, especially as the new possible retirement date is actually about the time that I’ll have paid off the house. And of course, my definition of rich is not having to work for a living.
I know that some of you are also spreadsheet fans, so if you’d like to have a play with my retirement calculator then why not download it?
It’s all zipped up for you and works in both Excel and also the free Open Office spreadsheet program. If you spot any bugs or flaws please let me know.
You can tweak quite a few variables to come up with different scenarios, I hope you like it
I get a page saying ‘Download does not exist!’ from that link.
@Keiron:
That should be fixed now. Goes to show that you can’t check things enough.
Plonkee - send me the spreadsheet that shows how I can assure myself annual returns averaging 4% above the inflation rate!
Seriously, thanks for this. I will check it out.
@Keiron:
You get that if you try to download it from an RSS reader. For some reason the readers replace the ‘_’ with a ‘%20′
To get the file download directly from this page
@Mr. ToughMoneyLove:
Yeah, when I find it, I’ll let you all know.
Thanks! Over the next few weeks, I need to start figuring out retirement plans for my husband and me. This will be a nice start.
I have no clue how you figure out when you can retire so I’m going to make use of your calculator, thank you!
Hi plonkee, very useful calculator, thank you
I have a final salary scheme with work, which got frozen June 30th. Is there any way of finding out the cash value of final salary schemes?
It pays out £4,600 pa at 65
-Laura
What a great tool, I love spreadsheets. Thanks Plonkee!
Gotta love this! I’m going to check this out.
Thanks for the tool.
Sam
Thanks for putting this together Plonkee. Very useful tool to use.
It seems like personal spreadsheets usually make a lot of sense to the creator, but generally take some time for other people to get acquainted to the way that they work. This one seems like a good starting point for me though, seems pretty straight forward. Thanks for the spreadsheet.
I think your link to download the spreadsheet isn’t working again. I got a “it’s not here” type of message. Help!
Thx!