Following formula for Stamp Duty in New South Wales.
Given Stamp duty is calculated at (please verify if following is correct at time of reading before applying this formula):
- 3% of the market value up to $45,000
- 5% on the value over $45,000.
Full formula:
case(int(({DutyValue}+99.99)/100),x>450,x*5-900,x*3)
Simplified formula (assumes you never sell bikes above $45k)
int(({DutyValue}+99.99)/100)*3