Stamp Duty Calculator/Spreadsheet

From: Joanna K


I hope someone can help...

I'm absolutely hopeless with Excel...I tried to create a stamp duty calculator/spreadsheet in excel this afternoon and it turned in to a complete disaster, not to mention a waste of time.

Does anyone have one they've designed and willing to post up?

Or maybe, if I post up the parametres, someone could design one??

I just want to be able to enter in the purchase price, and voila...stamp duty is calculated.

Would be appreciated!

Thankyou in advance.

Kind regards
THE RENTAL SPECIALISTS

JOANNA KARAVASILIS
Principal

rentals@rentalspecialists.com.au
www.rentalspecialists.com.au
 
Last edited by a moderator:
Reply: 1.1.1
From: Joanna K


thank you for the responses, however, I was after something I can stick on my pocketpc so I have it readily available.


Kind regards
THE RENTAL SPECIALISTS

JOANNA KARAVASILIS
Principal

rentals@rentalspecialists.com.au
www.rentalspecialists.com.au
 
Last edited by a moderator:
W

WebBoard

Guest
Reply: 1.1.2
From: Ctrader .


Joanna,
This is a formula for WA stamp duty. This will give you a starting point. Just change to suit the state.

=IF(C4<=80000,C4*0.0195,IF(C4<=100000,1560+((C4-80000)*0.0285),IF(C4<=250000,2130+((C4-100000)*0.037),IF(C4<=500000,7680+((C4-250000)*0.0455),19055+((C4-500000)*0.0485)))))


Ctrader
 
Last edited by a moderator:
Reply: 1.1.2.1
From: Ross V


Hi Joanna,

Try this for NSW stamp duty



ross-v
 
Last edited by a moderator:
Reply: 1.1.2.1.1
From: Joanna K


Ctrader and Ross,

THANKYOU!! Both these formulas were exactly what I was trying to figure out.

Thanks alot.


Kind regards
THE RENTAL SPECIALISTS

JOANNA KARAVASILIS
Principal

rentals@rentalspecialists.com.au
www.rentalspecialists.com.au
 
Last edited by a moderator:
W

WebBoard

Guest
Reply: 2.1
From: David Simon


On 4/30/02 10:57:00 PM, Pierre . wrote:
>Try Pierre's IP calculator on
>his website. It does lots more
>than just calculate the SD too
>!!
>
>http://members.ozemail.com.au/
>~catbiz/
>
>Pierre


This is a fabbo and very comprehensive calculator. Does anyone know of any similar ones on the web that let you link several properties?

Regards David.
 
Last edited by a moderator:
Top