A quick post of how to calculate the Stamp Duty of a property with Excel, in my example I am using the Western Australia Residential Rate Dutiable value.
Stamp Duty Cutoff [$] Rate [%] Duty [$] Formula 0 1.9 0 0 120000 2.85 2280 =C3+(A4-A3)*B3/100 150000 3.8 3135 =C4+(A5-A4)*B4/100 360000 4.75 11115 =C5+(A6-A5)*B5/100 725000 5.15 28452.5 =C6+(A7-A6)*B6/100 Property Value 500000 Duty 17765 =VLOOKUP(C9,A:C,3,TRUE) + (C9-VLOOKUP(C9,A:C,1,TRUE))*VLOOKUP(C9,A:C,2,TRUE)/100
Update, next day
This also works for Individual income tax rates;
Tax Rates
Cutoff [$] Rate [%] Tax [$] Formula
0 0 0 0
6000 15 0 =C3+(A4-A3)*B3/100
37000 30 4650 =C4+(A5-A4)*B4/100
80000 37 17550 =C5+(A6-A5)*B5/100
180000 45 54550 =C6+(A7-A6)*B6/100
Income 100000
Tax 24950 =VLOOKUP(C9,A:C,3,TRUE) + (C9-VLOOKUP(C9,A:C,1,TRUE))*VLOOKUP(C9,A:C,2,TRUE)/100
Leave a Reply