Donate to Remove ads

Got a credit card? use our Credit Card & Finance Calculators

Thanks to johnstevens77,Bhoddhisatva,scotia,Anonymous,Cornytiv34, for Donating to support the site

Planning it out!

Including Financial Independence and Retiring Early (FIRE)
monabri
Lemon Half
Posts: 8396
Joined: January 7th, 2017, 9:56 am
Has thanked: 1539 times
Been thanked: 3428 times

Planning it out!

#21810

Postby monabri » January 10th, 2017, 10:40 am

I decided (many years ago) to set up a spreadsheet that would help me plan my financial requirements until the age of 90. At the top of the spreadsheet I have the years laid out horizontally. Somewhat schematically, it is laid out like this (i won't draw the vertical lines in!) :-

2017 2018 2019 2020 2021 2022 etc etc
-------------------------------------------------------------------------------------------------------------------------------------------------
Pension 1
Pension 2
State Pension 1
State Pension 2
-------------------------------------------------------------------------------------------------------------------------------------------------
Initial Savings amount
Income from savings
Income from "other" (eg BTL)
-------------------------------------------------------------------------------------------------------------------------------------------------
Drawdown - Person 1 this is personal spending money [these sums reduce the balance]
Drawdown - Person 2
-------------------------------------------------------------------------------------------------------------------------------------------------
Treat money - holidays/new car/whatever you want [these sums reduce the balance]
------------------------------------------------------------------------------------------------------------------------------------------------
House running costs including food (calculated in a separate sheet with the number fed through to this sheet)
-------------------------------------------------------------------------------------------------------------------------------------------------
Tax allowance
Tax due -Person 1
Tax due Person 2
--------------------------------------------------------------------------------------------------------------------------------------------------
Net Balance to take forward to the top of the next column.
-------------------------------------------------------------------------------------------------------------------------------------------------

I also have included that facility to increase any of these lines by an inflationary amount. This provided me with a discipline which I have have held to for the last 15 years.

The planning tool then allows you to say "what happens if inflation reaches x %", "I buy a new car in year X", I spend £ x thousands on holidays etc. It allows you to model different scenarios to ensure you don't run out of money but - just as important for me - we don't die leaving loads of money in IHT.

Ok, I might not live to 90 (none of my parents have) but my wife has a better chance. Of course, you could also include the injection of lump sums into your spreadsheet for unexpected/expected windfalls (inheritance perhaps).

I think it is important to plan it out so you have some idea of what is possible - there is no point working until 70 to discover that you might have had sufficient funds 5 years earlier.

StepOne
Lemon Slice
Posts: 668
Joined: November 4th, 2016, 9:17 am
Has thanked: 195 times
Been thanked: 185 times

Re: Planning it out!

#21848

Postby StepOne » January 10th, 2017, 1:12 pm

This looks great monabri.

As I approach 50 it's the sort of thing I have been doing now and again in temporary spreadsheets, but I like the look of yours and am excited about the thought of setting up something similar (that's how sad my life is!)

I did something very roughly a couple of weeks ago which kind of implied I might not need to be saving as much as I am. This could be a bit liberating for me, as I do prefer to do things such as save, and overpay the mortgage, instead of spending it on things like expensive holidays with my family. My wife keeps reminding me that these kids are only young once. Of course I remind her that I never went further than Glasgow on a Summer holiday, and even then we stayed with my Dad's cousins rather than fork out for accommodation! This line of reasoning has yet to win her over. Perhaps another spreadsheet in my armoury might convince me she's been right all along!

Cheers
StepOne

monabri
Lemon Half
Posts: 8396
Joined: January 7th, 2017, 9:56 am
Has thanked: 1539 times
Been thanked: 3428 times

Re: Planning it out!

#21876

Postby monabri » January 10th, 2017, 3:31 pm

That's another way of looking at it (saving too much). I also used it for ensuring that I paid the minimum tax when it comes to taking pensions but that's fine tweaking.

I would suggest adding a graph (x-axis = year : Y axis = fund balance) so you can tweak things (like how much you will drawdown to spend each year) and visually see what the effect is. You could then model different scenarios (what if inflation is x%) etc.

uryjm
Posts: 30
Joined: November 23rd, 2016, 9:38 pm
Has thanked: 1 time
Been thanked: 7 times

Re: Planning it out!

#22207

Postby uryjm » January 11th, 2017, 3:57 pm

Hi Monabri
I like the look of your plan!
I'd love a copy of the spreadsheet - not with your personal details of course! - but just to give me an idea how it works. No doubt my wife and I have relatively simple pensions, but they're a mixture of DB and DCs, some we can take at 55, some at 60, some at 62 and then the state pension.....plus you can take a lump sum, or all of it as a plain monthly income....
I have two years until I hit 55 and am relatively well provided for (I think!). I am struggling with they myriad of options though. What did you find best as a starting point? Was it to decide a target annual income? Or the maximum tax efficient you could take?
Anyway, I love planning and you have inspired me to do a bit more :D

genou
Lemon Quarter
Posts: 1070
Joined: November 4th, 2016, 1:12 pm
Has thanked: 177 times
Been thanked: 370 times

Re: Planning it out!

#22226

Postby genou » January 11th, 2017, 5:32 pm

uryjm wrote:Hi Monabri
I like the look of your plan!
I'd love a copy of the spreadsheet - not with your personal details of course! - but just to give me an idea how it works. No doubt my wife and I have relatively simple pensions, but they're a mixture of DB and DCs, some we can take at 55, some at 60, some at 62 and then the state pension.....plus you can take a lump sum, or all of it as a plain monthly income....



If you are running Windows on your machine, you might want to take a look at the sunset version of MS Money ( which is free ) from here
http://money.mvps.org/downloads/files/2 ... K-QFE2.exe

It has an inbuilt Lifetime Planner / Budget and portfolio manager. The planner allows for "what if I did this....."

monabri
Lemon Half
Posts: 8396
Joined: January 7th, 2017, 9:56 am
Has thanked: 1539 times
Been thanked: 3428 times

Re: Planning it out!

#23003

Postby monabri » January 14th, 2017, 10:22 am

Hi uryjm, I've sent you an email - if you reply with your email address I will send you a "clean" copy. You will need EXCEL to play around with it.

staffordian
Lemon Quarter
Posts: 2298
Joined: November 4th, 2016, 4:20 pm
Has thanked: 1887 times
Been thanked: 869 times

Re: Planning it out!

#23032

Postby staffordian » January 14th, 2017, 1:51 pm

monabri wrote:Hi uryjm, I've sent you an email - if you reply with your email address I will send you a "clean" copy. You will need EXCEL to play around with it.


It sounds very much as though you have created something which many here might find useful. In fact after your initial post I had a bash at concocting something similar, which even in it's very crude state is better than I had before, so many thanks for the post!

It's very presumptuous of me, but if it's something you would consider sharing, I wonder if Itsallaguess and kiloran might add it to the software available from their weebly site?

http://lemonfoolfinancialsoftware.weebly.com

Staffordian

monabri
Lemon Half
Posts: 8396
Joined: January 7th, 2017, 9:56 am
Has thanked: 1539 times
Been thanked: 3428 times

Re: Planning it out!

#23034

Postby monabri » January 14th, 2017, 1:56 pm

Of course I'd share it....no problem. I'll send you a private msg with my email so you can have a shufty!

staffordian
Lemon Quarter
Posts: 2298
Joined: November 4th, 2016, 4:20 pm
Has thanked: 1887 times
Been thanked: 869 times

Re: Planning it out!

#23036

Postby staffordian » January 14th, 2017, 1:58 pm

monabri wrote:Of course I'd share it....no problem. I'll send you a private msg with my email so you can have a shufty!


Much appreciated!

Staffordian

Fromdusktildawn
Posts: 3
Joined: November 4th, 2016, 12:46 pm

Re: Planning it out!

#39649

Postby Fromdusktildawn » March 19th, 2017, 4:29 pm

Monabri
This looks really useful, thank you for sharing. May I have a copy ? Liz

FanciThat
Posts: 36
Joined: November 4th, 2016, 1:58 pm
Has thanked: 140 times
Been thanked: 44 times

Re: Planning it out!

#39803

Postby FanciThat » March 20th, 2017, 12:08 pm

monabri wrote:I decided (many years ago) to set up a spreadsheet that would help me plan my financial requirements until the age of 90. At the top of the spreadsheet I have the years laid out horizontally. Somewhat schematically, it is laid out like this (i won't draw the vertical lines in!) :-

2017 2018 2019 2020 2021 2022 etc etc
-------------------------------------------------------------------------------------------------------------------------------------------------
Pension 1
Pension 2
State Pension 1
State Pension 2
-------------------------------------------------------------------------------------------------------------------------------------------------
Initial Savings amount
Income from savings
Income from "other" (eg BTL)
-------------------------------------------------------------------------------------------------------------------------------------------------
Drawdown - Person 1 this is personal spending money [these sums reduce the balance]
Drawdown - Person 2
-------------------------------------------------------------------------------------------------------------------------------------------------
Treat money - holidays/new car/whatever you want [these sums reduce the balance]
------------------------------------------------------------------------------------------------------------------------------------------------
House running costs including food (calculated in a separate sheet with the number fed through to this sheet)
-------------------------------------------------------------------------------------------------------------------------------------------------
Tax allowance
Tax due -Person 1
Tax due Person 2
--------------------------------------------------------------------------------------------------------------------------------------------------
Net Balance to take forward to the top of the next column.
-------------------------------------------------------------------------------------------------------------------------------------------------

I also have included that facility to increase any of these lines by an inflationary amount. This provided me with a discipline which I have have held to for the last 15 years.

The planning tool then allows you to say "what happens if inflation reaches x %", "I buy a new car in year X", I spend £ x thousands on holidays etc. It allows you to model different scenarios to ensure you don't run out of money but - just as important for me - we don't die leaving loads of money in IHT.

Ok, I might not live to 90 (none of my parents have) but my wife has a better chance. Of course, you could also include the injection of lump sums into your spreadsheet for unexpected/expected windfalls (inheritance perhaps).

I think it is important to plan it out so you have some idea of what is possible - there is no point working until 70 to discover that you might have had sufficient funds 5 years earlier.


Your spreadsheet is eerily close to mine! I guess that's because all those lines are exactly what you need to model the incomes and outgoings for retirement. This is what I used to confirm that I could indeed retire 3 years early (from my NRD of 60 to receive my company pension) though I did have additional versions to enable modelling of different 'what if' scenarios (eg. getting CETV instead of FS, buying additional NI years, etc). Based on my modelling I stop work in 2 weeks time :-)

Cheers, FT

JMN2
Lemon Quarter
Posts: 2156
Joined: November 4th, 2016, 11:21 am
Has thanked: 288 times
Been thanked: 282 times

Re: Planning it out!

#39851

Postby JMN2 » March 20th, 2017, 3:03 pm

I've been constructing a SS too, a slightly simpler though, in it I don't go into the spending too much, just wanted to see how much to take out every year, and then with that cash drawn out I plan the expenses elsewhere in another SS.

The following are the columns from which the numbers go into the next row for next year and so on.

ISA pot (formula : (ISA pot Previous year + drawdown isa + subscr isa )* return
SIPP pot ( formula : similar as above)
Total pot
Age
Tax Year
Drawdown ISA
Drawdown SIPP
Drawdown Total
Return (4%)
Subscription ISA
Subsription SIPP
Subsription SIPP TAX

I could do each row semi-annual, basically raid the pot twice a year and plan expenses.

monabri
Lemon Half
Posts: 8396
Joined: January 7th, 2017, 9:56 am
Has thanked: 1539 times
Been thanked: 3428 times

Re: Planning it out!

#39923

Postby monabri » March 20th, 2017, 7:04 pm

FT
Have a good and long retirement :D !!!!!!! feet up , G&Ts in the summer, throw away the alarm clock ...chillax!!!

The one thing I will say is that time goes REALLY quickly and you'll wonder how the heck you fitted the 9-5pm "W" word in.

monabri


Return to “Retirement Investing (inc FIRE)”

Who is online

Users browsing this forum: Salvelinus and 9 guests