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)))))),)

@tommytico That figure should be updated now to $3,636,000:

https://www.revenue.nsw.gov.au/taxes-duties-levies-royalties/transfer-duty#accordion__target-1194549-1

Hello @steve-keep, ive updated the formula to 3,636,000 but it looks like I'm $646 off what the NSW duty calculator says. My purchase price is $11m. Are you able to help?

My total duty is calculating at (using your formula): 698515
NSW duty calculator is calculating at: 697869

I'm using your formula:

=ROUNDDOWN(IF(I6>3636000,(0.012516000)+(0.015(35000-16000))+(0.0175*(93000-35000)+(0.035*(351000-93000)+(0.045*(1168000-351000))))+(0.055*(3636000-1168000))+0.07*(I6-3636000),IF(I6>1168000,(0.012516000)+(0.015(35000-16000))+(0.0175*(93000-35000)+(0.035*(351000-93000)+(0.045*(1168000-351000))))+0.055*(I6-1168000),IF(I6>351000,(0.012516000)+(0.015(35000-16000))+(0.0175*(93000-35000)+(0.035*(351000-93000)))+0.045*(I6-351000),IF(I6>93000,(0.012516000)+(0.015(35000-16000))+(0.0175*(93000-35000))+0.035*(I6-93000),IF(I6>35000,(0.012516000)+(0.015(35000-16000))+0.0175*(I6-35000),IF(I6>16000,(0.012516000)+0.015(I6-16000),I6*0.0125)))))),)

Also, Do you also have another formula for surcharge duty?