UPDATE: Now available:
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 download the Tax Calculators (2013, 2014 and 2015) subscribe to our newsletter. You are welcome to unsubscribe if we can’t help you but we guarantee that the Excel tips and tricks we provide will save you hours in your normal workday
Please fill in your details below to receive the free monthly Audit Excel newsletter which covers free Excel tips tricks and shortcuts.
Please fill in your details below to get regular Excel tips and tricks and a free Quick Reference Download!
Sum only visible cells, put m2 into a cell, changing away from R1C1 format If we have helped you before with some of our tips and tricks, please forward this link to your friends and suggest they subscribe. If we have … Continue reading
Summing, Counting, or Averaging visible cells only in Excel Often when you use tools like filter, grouping or hiding rows in Excel you want to be able to do the summing, counting or averaging of the visible cells only. Alternatively … 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