Microsoft Excel formula for calculating stamp duty in New South Wales (NSW), Australia. Long form edition without "magic numbers".

excelStampDutyNewSouthWalesAustralia-LongForm

=ROUND(IF(A1>3000000,(0.0125*14000)+(0.015*(30000-14000))+(0.0175*(80000-30000)+(0.035*(300000-80000)+(0.045*(1000000-300000))))+(0.055*(3000000-1000000))+0.07*(A1-3000000),IF(A1>1000000,(0.0125*14000)+(0.015*(30000-14000))+(0.0175*(80000-30000)+(0.035*(300000-80000)+(0.045*(1000000-300000))))+0.055*(A1-1000000),IF(A1>300000,(0.0125*14000)+(0.015*(30000-14000))+(0.0175*(80000-30000)+(0.035*(300000-80000)))+0.045*(A1-300000),IF(A1>80000,(0.0125*14000)+(0.015*(30000-14000))+(0.0175*(80000-30000))+0.035*(A1-80000),IF(A1>30000,(0.0125*14000)+(0.015*(30000-14000))+0.0175*(A1-30000),IF(A1>14000,(0.0125*14000)+0.015*(A1-14000),A1*0.0125)))))),)

July 2024 Update

=ROUNDDOWN(IF($B$2>3636000,(0.0125*17000)+(0.015*(36000-17000))+(0.0175*(97000-36000)+(0.035*(364000-97000)+(0.045*(1212000-364000))))+(0.055*(3268000-1212000))+0.07*($B$2-3268000),IF($B$2>1212000,(0.0125*17000)+(0.015*(36000-17000))+(0.0175*(97000-36000)+(0.035*(364000-97000)+(0.045*(1212000-364000))))+0.055*($B$2-1212000),IF($B$2>364000,(0.0125*17000)+(0.015*(36000-17000))+(0.0175*(97000-36000)+(0.035*(364000-97000)))+0.045*($B$2-364000),IF($B$2>97000,(0.0125*17000)+(0.015*(36000-17000))+(0.0175*(97000-36000))+0.035*($B$2-97000),IF($B$2>36000,(0.0125*17000)+(0.015*(36000-17000))+0.0175*($B$2-36000),IF($B$2>17000,(0.0125*17000)+0.015*($B$2-17000),$B$2*0.0125)))))),)

anyone have onefor the concessecions for NSW? i can not seem to fnd a pattern in the concessions for FHBers?