Australian Superannuation Free Calculator – Compare Super Funds
I have created a free tool through Google Sheets that lets you change and compare superannuation funds in Australia.
I found the online tools to be quite clunky and was hard to compare a lot of superfunds at the same time. I made my own and it is still in early phases but it seems to work pretty well for me at least. Always open to changing/adjusting it so others can use it too.
If you need to enter a value with a percent sign, be sure to type % on the end otherwise it may come up with an error.
How To Use The Free Tool
Firstly, check the date last updated and the version. This may change over time, I have included a log sheet to keep track of changes.
Figure 1 – General Information for the Calculator
Enter in your information in the section shown as below, Figure 2. This will include your wage, your current super value and percentage (automatically set at 9.5%), contribution and how many years left until you expect to retire. All these figures are just generic and you can change to what your current status is.
On the right hand side of Figure 2 you can see the Custom Super Comparison section. Change this section to what your current Super is sitting at or at the one you wish to compare with. For example, I have entered in the Admin Fees and Investment Fees for an ING Living Super. All this information can be found on your companies site or you can get it from websites like Rate City.
Figure 2 – Your Current Information and Super Comparison Input
In this section I have included some examples of Super Funds and what their current fees are. These are just examples taken from Rate City. I have no affiliation with any super fund and I currently have my super in ANZ Smart Choice but looking to change if I find a better option due to their performance not being fantastic.
In section 3 you can change the performance, the other sections are locked as this information comes from Rate City. If you want to play with their performance then feel free to change the last section on the right. The Custom Super takes information from the section 2, so these cells should be locked too.
Figure 3 – Superannuation Information
Section 4 has the end result. What your super balance will look like at the end of how many years you entered in Section 2. Please note this will only go up to 50 years. If you see any errors in this then please let me know. As you can see as the Admin Fees and Investment Fees are quite similar the end result does not have a huge difference but the ultimate factor is the Super’s performance over how many years you entered in.
Figure 4 – Your Results
Section 5 shows the end result as a graph. This graph is dynamic and will change depending on what you enter in the Section 2.
Figure 5 – Graphical Representation of Performance over years entered in Section 2.
- Currently there is no allowance for wage inflation.
- Comparison to stock market.
- More examples of other Super funds.
- Simplicity improvements.
If you get a chance to use the tool then please feel free to give me some constructive criticism on how to improve the tool in the future.