How to use this tool
Check the units, enter your values, and run the tool. Results follow the assumptions and method below.
Calculation method
first == 1 ? (price <= 500000 ? max(0,price-300000)*0.05 : (min(max((price)-0,0),125000)*0+min(max((price)-125000,0),125000)*0.02+min(max((price)-250000,0),675000)*0.05+min(max((price)-925000,0),575000)*0.1+max((price)-1500000,0)*0.12)) : (min(max((price)-0,0),125000)*0+min(max((price)-125000,0),125000)*0.02+min(max((price)-250000,0),675000)*0.05+min(max((price)-925000,0),575000)*0.1+max((price)-1500000,0)*0.12)