ATO Tax calculations in Excel

Posted on April 29, 2015 by Jeff Turner

Some possibly useful excel functions and macros.

save this function in a macro enables excel documnet (xlsm) and then you can use the formula =taxpayable(a1) and it will calculate the tax payable for that gross income.

ATO Tax scales

Australian Tax department “sliding” scales calculation

Function taxpayable(income)
'Stop
If income < 6000 Then
    taxp = 0
    ElseIf income < 35000 Then
        taxp  = 0.15 * (income - 6000)
    ElseIf income < 80000 Then
        taxp  = 4350 + 0.3 * (income - 35000)
    ElseIf income < 180000 Then
        taxp = 17850 + 0.38 * (income - 80000)
    Else
        taxp = 55850 + 0.45 * (income - 180000)

End If
taxpayable=taxp
End Function

About Jeff Turner

Technical director of Nano Tera Network Solutions.
This entry was posted in Hints and Tips. Bookmark the permalink.