RSS Feed c9 logo Australia's best motorcycle shop retail software

Formula for WA which implements the following from this website:

https://www.finance.wa.gov.au/cms/State_Revenue/Duties/Rates/Rates_of_Duty.aspx

Vehicle licence duty – Vehicle mass less than 4.5 tonne

$           0 – $25,000 2.75% of dutiable value (DV)
$  25,001 – $50,000 [2.75 + (DV - 25,000)] % (rounded to 2 decimal places) of dutiable value
6,666.66
$  50,000 and upwards 6.5% of dutiable value

Formula in C9 is:

int({DutyValue}*case({DutyValue},x<=25000,275,x>=50000,650,275+int((x-25000)/66.6666+0.5))/500)/20