Retirement Calculator

Find out how much money you need to retire and what level of post-tax income you can expect to enjoy in retirement using a retirement calculator spreadsheet set up for UK tax and pension rules. Model your wealth according to ISAs, pensions, general savings and rental properties both whilst you are working and in retirement.

  • efficiently plan your taxes to save precious £££
  • create an effective robust plan quickly and easily (I initially populate the model for you)
  • achieve your retirement goals and lead an exciting life after work


Model your wealth according to ISAs, state and private pensions, general savings and rental properties both whilst you are working and in retirement.

Wealth

Model the income of you and your spouse over time including state pension, defined benefit / defined contribution pensions, isas, rental property income and any other income such as side hustles. 

This chart also helps to visualise the order of drawdown in retirement, including an “isa bridge” (in yellow) that is used to cover the period between retirement commencing and the availability of private pensions (in green).

The retirement calculator can set different phases of retirement (such as an initial “bucket list” phase)  with differing expenditure levels and then model the percentage of your wealth being taken each year compared to a target such as the 4% rule. By allowing for things like the state pension and tax free cash, it can be possible to squeeze more out of your pension.

A version of the retirement calculator is here (with some formulas removed so it is view only). https://docs.google.com/spreadsheets/d/1IUFCIxUgo76QX8uJTGvXRHqnJUefzYoAth7Co4vPGfo/edit?usp=sharing


Tax planning in retirement is an important way to make your finances go further. A UK retirement calculator spreadsheet is a great way to achieve tax optimisation in retirement.

Analyse your taxes in retirement to see if / when you pay the 40% tax bracket and what you can do to avoid it such as taking money from an isa instead of a sipp or looking at the split of income between yourself and your partner.

Compare scenarios

Easily compare different scenarios such as retiring a year early or having different levels of expenditure in retirement..

The price is £150 for the spreadsheet (lifetime access) as well a 40 minute zoom call to explain everything and make sure that you get the most out of it. I also populate the retirement calculator for you. This is about one tenth the price of a similar service from a wealth planner.  

A series of videos explaining how the retirement calculator works is here https://www.youtube.com/playlist?list=PLvzQbOJosBkQuTsiCzkfQg47TFwUNuICh

If you are interested, put your details in the “contact me” box at the bottom of the page.

Video Demonstrating the Retirement Calculator

Testimonials (as posted on ebay account ianshad)

Ian’s tool is brilliant and easy to use. He gives great support in helping in its use. Highly recommended – thanks ! Make sure you take him up on the offer to have a follow up Zoom call and look for his YouTube channel for direct access

 

Really great product from Ian, has a lot of variables that other tools dont have (like historic performance of FTSE) to help with predicting how your savings may perform. Ian has also been very helpful and did an online meeting with me to walk me through the Calculator. Really recommend it,

 

I have purchased some of Ian’s googlesheets previous and always found them to be very useful. The Retirement Planner is very comprehensive and Ian has been very helpful in setting it up and also making some changes to fit my circumstances. It’s a great tool if you want to understand how things are calculated and to try some what if scenarios before making some decisions or to prepare for a discussion with a financial adviser.

 

A great financial modelling tool that clearly showed me my status and future view, with scenario functionality as well. Exceptional value for money as it also included two 30 minute coaching sessions from Ian once I had utilised the tool. If you want to understand your current and future financial positions this is the tool you need.

 

Ian was very helpful in coaching us via zoom through his spreadsheets to construct a financial model personalised to our requirements. Highly recommended. His retirement calculator is an excellent tool to create our financial life plan to forecast how much our capital would last during retirement.

 

Very comprehensive spreadsheet and model which was very helpful in modelling our retirement expenditure plans. The 2 half hour coaching sessions were very valuable. I like that Ian has taken early retirement himself so knows what he is talking about!

 

Ian is very knowledgeable and practical. The two personal online sessions are really helpful and he was very patient with me, working through all my personal specific circumstances. Accordingly I highly recommend this coaching service to others. I only wish I had found Ian earlier. His YouTube channel is also fantastic.

 

Worth it for the spreadsheet alone – to give you the answer to “when can I retire?”. Ian was great – easy to talk to and nice to have someone impartial to bounce things off

Retirement Calculator Process

Explained in this short video