Next Live Training Date:

12-16 May 2014

Retirement Calculator

View the Retirement Calculator >>

Retirement is one of the most uncertain times in a persons life when it comes to finances. For this reason, proper retirement planning is needed long in advance. Below is a spreadsheet (give it a chance to load) where you can determine whether your current level of savings will be sufficient to last you during your retirement.

To complete the spreadsheet fill in the light blue cells (if you are not sure what is required, look lower down for instructions). Look at the summarized results and scroll across to see the detailed calculations. To see what happens when you change some of the key inputs and compare the results as you change the inputs. Inputs that are useful to vary are your planned retirement age and the percentage of income that goes into savings.

Legend to the inputs

  1. Annual Income- The amount of money you currently earn PER YEAR after tax.
  2. Money already saved at current age- The amount of money you have already saved. Do not include the house you live in or any other must have assets (e.g. cars). Include investments etc
  3. Inflation – The inflation percentage in your country. Do a search in Google if you are unsure (search term could be “inflation” followed by your countries name).
  4. Real return over inflation- An economic measure. We would enter 5%. Do another search for your countries real return.
  5. Current Age – Your current age. Roundup if you are close to your next birthday.
  6. Age of retirement – The age at which you are planning to go on retirement. Try your ideal retirement age and then change it to see the effect.
  7. Age of death – Not nice to think about but it is critical. Start on 100 as a worst (or is it best) scenario.
  8. Percent of working income required in retirement- Most people need less money when going on retirement. Try and work it out. If you want it all then enter 100%.
  9. Percent of annual income saved- What percentage of your current annual income are you saving annually? Once you have entered the real number, change this number to see how much you need to save in order to retire comfortably.

Look at the results to see whether you will have enough saved for your retirement. If you are short, increase your retirement age and/ or the savings % until the savings are adequate.

Retirement Planning Tips

Some general tips about saving and planning for retirement.

Firstly, it is critical that you know what is required. The spreadsheet above is a high level view and cannot be relied upon. Get your investment advisor to perform a more detailed calculation.

Secondly, once you know what is required, make a plan. Get investment advice and make sure that you are putting enough away in the correct investment products. Do not deviate from this plan and make sure that as your income increases, your saving does to!

Thirdly, you should never be in a position to just walk into a shop and buy something. Force yourself to always think whether you actually need it/ can afford it. The best way to achieve this is to work out a budget for yourself and anything left over is taken out of your account into savings AT THE BEGINNING OF THE MONTH!

That way the temptation is gone and any deviation from your budget will need careful consideration.

Stick to this plan and let the power of compounding investment returns make sure you retire with enough money to maintain your lifestyle.

Handy Tips & Tricks

Compare 3 variables in excel

Compare 3 variables in excel A common requirement from training delegates is to compare 3 variables in excel. With use of the correct formula this is fairly easy. The first option is using the IF function (watch the IF function … Continue reading

Text footer excel

Text footer excel A number of clients have queried the text footer excel limits on the number of characters allowed. For example, if you want to include some terms and conditions as a footer to all printed pages you will … Continue reading

“Data accuracy and consistency has improved dramatically across Absa Capital, so much so that it has become compulsory within certain areas for all staff to complete Adrian’s Data Analyses Spreadsheet Techniques course.”

– Absa Capital

Video Library & Tutorials //

View Entire Video Gallery ››

Solver Excel 2013

Solver Excel 2013

Offset Excel 2013

Offset Excel 2013

Vlookup Approximate Match

Vlookup Approximate Match

Vlookup Exact Match

Vlookup Exact Match

Some of our Featured Clients