Skip to main content

*Interactive Investor Offer: No platform fee for 1 year*


How much do you pay for your investment platform? Fancy a free one?
Simply click the link below, open up an ISA/SIPP/GIA then either fund £5k or transfer in from existing provider and you'll get the platform free for a year, saving potentially £360
https://ii.co.uk/recommend-ii?ii_referrer=13iio6o6r2279-8930g46kttxm

Contact

Email Me

FIRE Calculator

Like most FIRE people, I'm a bit of an Excel geek. I work extensively with the platform and I also track my finances every month on it.

I've designed a spreadsheet which lets you understand when you can FIRE. As you will not be able to take a private pension until aged 57, if you decide to retire before this date you will need a "bridge" account. I recommend a S&S ISA on a platform like Vanguard, but obviously do your own research on what works for you.

You can access it on GoogleSheets here


How to use:

The only cells you need to alter are in bright yellow, you can then play around with the fire date to see how much more you need in your "bridge" account.

1. Enter you year of birth in cell G1
2. Enter the expected growth in cell G2 (rule of thumb historically is 7%



3. Enter how much money you will need to live off during your "bridge" period in cell G6. This is between when you FIRE and when you can take your private pension (57). Factor in whether you will have any mortgage costs by then and childcare etc

4. Enter your current "bridge" pot in cell G9. Include how much you currently have in long term savings, and any other assets.



5. Enter your current pension pot (cell G15) and how much you plan on contributing per year (G17)
The number in red under "needed" indicates that I am going to fall short of my target. I either need to lower my "estimate per year", increase my current pot, or alter my "Age FIRE".



6. To alter your "Age FIRE", click the drop down (G7) and choose a new age to FIRE.
Below, I have chosen 51 rather than 50, as this is the soonest I can FIRE using the current pot and estimate per year required figures. However, you may notice that by altering this, my pension has breached the £1m limit (due to me having an extra year before I FIRE, contributing to my pension).



6. To alter your pension, so it doesn't breach the lifetime allowance. Reduce the contributions per year (G17)





Overall, this spreadsheet is very flexible and gives you a good indication about what is possible given your current situation, savings & pension pots, as well as expectations about what kind of income to expect later on in life.

Any feedback just let me know! There are a few niggles like assuming the overall pension pot is spread over 24 years whereas in real life there will be a 25% tax free element, the Pension Lifetime Allowance will likely increase in the future also the pension age may well change in the future also.

Labels

Labels:

Comments

Post a Comment

Popular posts from this blog

All about me

I'm a 38 year old father of 2 young children. I  currently live with my wife and kids in Wakefield, West Yorkshire and work  in Cyber Security.  I've always been obsessed with frugality, optimising time and money and discovered the FIRE movement (Financial Independence Retire Early) in the mid 2010s. Over the past few years,  I have pursued a heavy savings rate and have directed this into savings, investments and overpaying the mortgage. Twitter Account:  https://twitter.com/Dad_on_FIRE Key milestones: 2022 - Mortgage free!  10 years after buying our 1st house. 2023 - Coast FIRE In 2023 I had enough in my pension that it would coast up to a figure I would be happy with at age 55 (circa £1m) 2024 - Hit  £1m net worth 2025 - Took 8 weeks off work (through Unpaid Parental Leave) My Net Worth journey: Most people pursuing people have a figure, an overall number to achieve. My FIRE aims however, are currently not set in stone, largely down to having...
2 comments
Read more

March 2024 update - Millionaire!

  In this update we have: Reached Millionaire status on my net worth Harvesting gains from Crypto Platform Incentives Holiday plans Overview: (click to enlarge) (click to enlarge) Net worth update:  Current net worth: £1,030,167 Up £28k from last month, and up a massive £70k from 2 months ago!!  My last blog post was probably a bit premature as a couple of days after it, I breached the millionaire net worth figure!  When I started out on this journey less than 10 years ago with a rough net worth of just over £100k I didn't think I'd be saying that as a 37 year old with two small kids that I'd be a millionaire! Also I'm not sure whether it is mainly due to "millionaire" status not being the same as it was when I was young (thanks inflation/money printing! #BitcoinSolvesThis ), or whether it is testament to our concerted saving and investing over the past few years, probably a mix of both. Either way I'm extremely proud of what me and wife have achieved, and...
6 comments
Read more

FIRE Bridge Calculator

The 4% rule is all well and good, but I've never really got to grips with this as a tangible model for calculating FIRE mainly because of the complications when working out the restrictions on when you can access the pots at different ages (predominantly pensions). Instead I prefer to break down FIRE strategy and planning into two distinct sections: Pension provisions . Including overall pot, what this might work out to be in retirement, and what age you can access. Bridge Pot . This will get you from your FIRE age to your above Pension pot access (above) In the past I've developed a pension calculator for the former , and here is my calculator for the latter aspect. What I've developed here is an Excel sheet which works out what you need between your desired FIRE age and your pension pot access age, aka your "FIRE Bridge pot". This has helped me to visualise when I could 'push the button' on FIRE, how much I could live off in the 'Bridge years' an...
3 comments
Read more