Skip to main content

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.

Comments

Post a Comment

*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
Click here to save

Popular posts from this blog

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

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

Budgeting

Key to understanding what you can save, is what your budget is. You can do your budget in a number of ways, from using software/apps, to writing them down manually in a Spreadsheet. Apps like "MoneyDashboard" are great but they only give a very limited breakdown, for example your current account. What about other savings accounts, your mortgage, or pensions, any other salary sacrifice schemes you're in? If you're a visual kind of person like me, it is much better to create a visualisation of how much money you have coming in, and where it ends up. Below I have used a "Sankey" chart which shows me weighted columns of where each pot ends up. Build your own here:  http://sankeymatic.com/build/ My current budget Wage - I am lucky to have a very generous wage for the area of the country I live in Mortgage - My mortgage is low (thanks to overpaying at least 10% every year for the past 8 years!) Childcare - The biggest expenditure is Ch...
1 comment
Read more

Investment Platform Fee Comparison Tool

Choosing the right investment platform can have a big impact on your returns. Even small annual fees can erode thousands from your investments when compounded over time. Use the interactive chart below to see how different platform fees stack up — and how much more of your money you can keep (and invest!). Given the chart detail, this page is best viewed on a desktop or if you're on a mobile, either turn it to landscape or select the desktop version of the page. Thanks! ISA & SIPP Fees ISA Fees SIPP Fees Up to £200k Up to £1M Data sourced from Interactive Investor, Vanguard, AJ Bell, Fidelity and Hargreaves Lansdown (and accurate as of 29/05/2025). Calculations are bassed on Funds rather than Shares, which in some cases may be cheaper. For "ISA and SIPP" fees, 50% allocation into eac...
Post a Comment
Read more

Unpaid Parental Leave: Unheard, Underused and Undervalued

. " Unpaid Parental Leave? What's that?" This is the response that I've got 90% of the time in the past few months when I've mentioned it to friends and family. Heck, I was in a similar position about 6 months ago. In this post, I'll be covering: What exactly Unpaid Parental Leave (UPL) is The benefits A comparison of UPL against Part time work Case study of UPL vs Part time for an average family/salary, and which option is best Why people aren't taking Unpaid Parental Leave I actually write this after taking the previous week off as Unpaid Parental Leave, the first time I've done it. In total, I'm taking 8 weeks off this year to spend more time with my children. I've always done things a bit differently, so I'm reversing the age-old societal arrangement of swapping your time for money, a move that seems to be extremely rare for a father and provider in his late 30s! I also see this as taking my first baby steps into FIRE-life, buying back...
Post a Comment
Read more