**Magic numbers:**

**1050.**This is 1.5% of $70,000. Why $70,000? It's the difference between $70,000 (upper bounds of second dutiable range) and $5,000 (lower bounds of the second dutiable range).**17325.**This is $1050 plus 3.5% of $465,000. Why $465,000? It's the difference between $540,000 (upper bounds of third dutiable range) and $75,000 (lower bounds of the third dutiable range).**38025.**This is $17,325 plus plus 4.5% of $460,000. Why $460,000? It's the difference between $1,000,000 (upper bounds of fourth dutiable range) and $540,000 (lower bounds of the fourth dutiable range).

**Other numbers:**

**0.015**is 1.5%**0.035**is 3.5%**0.045**is 4.5%**0.0575**is 5.75%

For the mathematical purists, I've also written a long form edition that doesn't contain magic numbers.

- In the long form,
**1050**is expressed as**(75000-5000)*0.015** - In the long form,
**17325**is expressed as**(75000-5000)*0.015+(540000-75000)*0.035** - In the long form,
**38025**is expressed as**(75000-5000)*0.015+(540000-75000)*0.035+(1000000-540000)*0.045**

**The sauce:**

- Transfer duty rates from the Queensland Office of State Revenue.

**The disclaimer:**

- If you use an internet stranger's Excel formula without rigorous testing against the official Queensland OSR transfer duty calculator, you're awfully trustworthy and I have a tiger repellant rock to sell you.

Nice work - only seems to marry up with the Qld gov calculator on vacant land when compared though:

ReplyDeletehttps://www.qld.gov.au/housing/buying-owning-home/advice-buying-home/transfer-duty/how-much-you-will-pay/calculating-transfer-duty/estimate-transfer-duty

Or investment property sorry, so I guess there's some sort of dicount when it's your own home?

ReplyDelete