stamp duty

  1. N

    Formula to calculate stamp duty payable on commercial property in the UK (post 2016)

    Detailed calculation This is a breakdown of how the total amount of SDLT was calculated based on the rules from 17 March 2016 Purchase price bands (£) Percentage rate (%) SDLT due (£) Up to 150,000 0 0 Above 150,000 and up to 250,000 2 2,000 Above 250,000+ 5 3,750 Total SDLT due...
    • Nikork
    • Thread
    • commercial property stamp duty uk property
    • Replies: 17
    • Forum: Excel Questions
  2. D

    Stamp Duty Formula URGENT

    Hi guys, im just making a simple spread sheet and need to work out a formula for NSW stamp duty: on sheet 1 i have the house value in cell B3, and on sheet 2 i have the stamp duty amounts so i can have them separate/not visible from sheet 1: <tbody> $0 - $14,000 $1.25 for every $100 or part...
    • drmj00
    • Thread
    • calculator excel formula spreadsheet stamp duty
    • Replies: 1
    • Forum: Excel Questions
  3. N

    Formula for Calculating Car Stamp Duty

    I am trying to find out an excel formula that will automatically calculate car stamp duty for NSW. Stamp duty is 3% up to 45,000 and 5% above that. It is calculated on the next $100 though. So if it is $23,204 then the stamp duty is actually calculated on $23300. Can anyone help me with this?

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top