UPDATE: Now available the South African Tax Spreadsheet Calculator for 2014/ 2015 at 2014/ 2015 South Africa tax table page.
We have released a free copy of the South African Tax Spreadsheet Calculator 2013/ 2014.
Using the new tax tables (see adjacent) we have provided the ability to enter your age category and salary and the spreadsheet will automatically calculate your taxes and the appropriate rebates based on your age.
As an added extra we have also included a comparative section to show the impact of declaring company profits as a salary/ bonus or as a dividend given the various company taxes. Makes for interesting analysis.
It seems the sweet spot is at about a salary of R 500 000 which means that the rate on salary and effective tax rate is about the same.
To get your free copy of the South African Tax Tables for 2013/ 2014- spreadsheet calculator please click here to
Below some of the other calculators we have:
Where is my calculated field in PowerPivot If you create a calculated field (DAX measue) in PowerPivot you may discover that you can’t find it when you try and use it in a Pivot Table. I have often asked myself … Continue reading
Vlookup counts hidden columns If you are familiar with the VLOOKUP command in Excel you may be interested to know that Vlookup counts hidden columns as well as the visible columns when deciding which columns information to bring back. In the … Continue reading
We have used AuditExcel over the last 5 years to develop large scale property modelling developments. All the templates are still in use and allow for intricate sensitivity analysis. As a result we are better able to assess projects and choose the optimal ones. Their response times also make it easy to rely on them for new developments.– Property Modelling- Basil Read