Jump to content

excel formula for new stamp duty


Recommended Posts

In my calculations I've used the following in Google Spreadsheets. I hope it work for multiple spreadsheet types

Stamp duty for fist time buyers:

=IF(B2>1500000,(B2-1500000)*0.12,0)+IF(B2>925000,MIN(1500000-925000,B2-925000)*0.1,0)+IF(B2>250000,MIN(925000-250000,B2-250000)*0.05,0)+IF(B2>125000,MIN(250000-125000,B2-125000)*0.03,0)

Additional rate stamp duty for second home buyers and company buyers

=IF(B2>39999,B2*0.03,0)

Resulting in this for companies

=IF(B2>1500000,(B2-1500000)*0.12,0)+IF(B2>925000,MIN(1500000-925000,B2-925000)*0.1,0)+IF(B2>250000,MIN(925000-250000,B2-250000)*0.05,0)+IF(B2>125000,MIN(250000-125000,B2-125000)*0.02,0)+IF(B2>39999,B2*0.03,0)

 

Link to post
  • 1 year later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...