Last active
November 20, 2016 10:56
-
-
Save pauldwhitman/5f69b5505d5f9638ed61bbbd9bd72d89 to your computer and use it in GitHub Desktop.
Microsoft Excel formula for calculating stamp duty in Tasmania (TAS), Australia. This formula follows the letter of the law. The output of this formula doesn't match the official calculator, because their calculator only "rounds" the input to the nearest $100. I cannot tell from the Tasmanian SRO website whether they do this when calculating act…
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| = | |
| IF(A1 > 725000, 27810 + 0.045 * (A1 - 725000), | |
| IF(A1 > 375000, 12935 + 0.0425 * (A1 - 375000), | |
| IF(A1 > 200000, 5935 + 0.04 * (A1 - 200000), | |
| IF(A1 > 75000, 1560 + 0.035 * (A1 - 75000), | |
| IF(A1 > 25000, 435 + 0.0225 * (A1 - 25000), | |
| IF(A1 > 3000, 50 + 0.0175 * (A1 - 3000), | |
| 50) | |
| ))))) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment