Thank Bruce for your time. This is great.
Its so easy to use and easy understand.
Hi Rex,
Thank Peter Noake too....."Pete" from Perth, as he orginally built it and I have modified it heavily.
Please only use it as a yardstick. Software such as PIA put out by the Somers is kept up to date and detailed.
I regularly update the speadsheet, so make sure you pull the latest copy down if doing serious stuff.
Things that I haven't checked for being up to date for a year include stamp and mortgage duty tables for all states apart from Qld. I only have the duty tables in for PPOR or first home buyers in Qld.
The tax calculation uses FY07 tables, and includes medicare levy and surcharge if income is high enough.
Modelling with the graphs seems to confuse most ppl, but if you read the two boxes, it is reasonably straight forward how to adjust the three variables (rent, interest, growth) to simulate changing economic climate.
There's no password but it is in protected mode when you download it, just so you don't inadvertently mess up a formula.
Let me know if you think it can be improved.