I want to be able to calculate the UK Stamp Duty on land purchases using an Excel formula. Shown below is the current rates.
<thead style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "> </thead><tbody style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">
</tbody>As you can see there are various rates, which are applicable to the whole value. i.e.
If the land is worth £270,000 the stamp duty would be 3% which would need to be shown. This would then be calculated. C1 "3%" and D1 "£90,000"
I am sure this can be done but is beyond my basic knowledge.
Any help would be appreciated.
Purchase price/lease premium or transfer value | SDLT rate |
---|---|
Up to £125,000 | Zero |
Over £125,000 to £250,000 | 1% |
Over £250,000 to £500,000 | 3% |
Over £500,000 to £1 million | 4% |
Over £1 million to £2 million | 5% |
Over £2 million | 7% |
<thead style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; "> </thead><tbody style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; ">
</tbody>
If the land is worth £270,000 the stamp duty would be 3% which would need to be shown. This would then be calculated. C1 "3%" and D1 "£90,000"
I am sure this can be done but is beyond my basic knowledge.
Any help would be appreciated.