Here's an Excel formula for calculating stamp duty in NT.
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
=MROUND( | |
IF(A1 > 3000000 , 0.0545 * A1, | |
IF(A1 > 525000 , 0.0495 * A1, | |
0.06571441 * (((A1/1000)^2)) + 15 * (A1/1000))) | |
,0.05) |
The official calculator rounds to the nearest 5 cents, so I've used MROUND() to achieve the same.
Usual disclaimer applies: these Excel formulas are designed for quick ballpark estimates of property stamp duty pricing. Though they are accurate, you would be wise to confirm important calculations yourself with the official NT stamp duty calculator.
No comments:
Post a Comment