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:
PowerPivot refusing to switch screens We have come across situations with PowerPivot refusing to switch screens and beeping each time we try and click on either a PowerPivot or Excel screen. So far the main reason for this is that we … Continue reading
PowerPivot Format Percentage for DAX Measure One of the most useful features of the new DAX measures in PowerPivot is the ability to specify a set format for the measure so that every time you use it in a pivot … Continue reading
Practical examples of how the various tools & functions can be used in different contexts make it quite easy to grasp the concepts and see the benefits of using these functions. The course is very practical and allows you to engage with the various exercises, make mistakes and learn....– Corporate financial modelling in excel Feedback