Search results

I appreciate what you are asking, but wonder how much utilitarian value it would have. Keep in mind when a xls is running one annual figure for each year, it is impossible to represent intra year interest rate and rent changes accurately. I think you can spend a lot of time trying to analyse...

Can you clarify how you want an xls to help?

ShareTracker. enter multiple share buy and sell details, hit analyse, and latest available closing price is fetched from MSN to update your portfolio value. has ability to account for commission. doesn't do leverage like cfd's. I can't be sure this xls can handle various bugs and...

If you want further assistance, PM me...though I am not a tax or legal professional. I am only giving you my opinion, which you should follow up with a professional. And the same goes for any opinion from anyone on this forum. Keep in mind all tax professionals aren't equally informed about this...

Everything seems complex to a simple mind Rixter

Hi Tess. I cannot remove spreadsheets from Somersoft. If you are having trouble with older copies it may be because you do not have an excel add in or you may not have iterations set properly in options. I started putting newer spreadsheets on an external site to somersoft because there is a...

A ssheet to compare IP performance under various economic climates. Adjusts growth, cpi, rates, rent.... Uses NPV of cash flows+growth, discounted by prevailing interest rate.

OK, didn't realise you wanted to hold....5 years should see you free to sell without attracting GST....but I believe builders who have held for 6 have still got caught........best to clear it with an acct who does a lot of dev't.....I have spoken to three who just don't get this stuff..

Bazza, anyone who did that duplex project would be up for gst. Read this

These are updates for some of the spreadsheet resources I have put up before. They are too big to meet Somersoft's criteria for spreadsheets, and storing them offsite will allow me to update them without having to post multiple copies to this thread. IP1.xls IP purchase analysis with Graphical...

an update for FHBs This is an update for the FHB rent vs buy simulator. New features include slider controls for the growth function of property and equity growth. This gives a more intuitive feel for comparing property and equities growth. I've also revised the formulae and...

How much has my property grown in value? Here's a spreadsheet that determines nominal and real growth rates of Australian property, based on cpi figures back to 1950. Mark_B put it on the forum somewhere a while back. Kudos to him as it is an excellent resource which I use frequently.

Rent Vs Buy Will review the budget planner spreadsheet. have spotted a couple of small bugs.....though nothing serious. Here's an evolved spreadsheet that looks at the ubiquitous question many potential first home buyers ask: Should I rent or buy? I have checked it quite thoroughly, but...

Mark, I spreadsheeted the benefits of a working partner (no kids) sometime ago..... a very good investment......especially if they are investment savvy rather then suffering from shoephilia... :) You should get one........ I am meeting a growing number of smart highly paid people (many of...

Here's an update of the above spreadsheet analysing the conversion of a PPR to an IP. Have added graphs and uncluttered the data entry area. Once again, this analysis is best applied using Solver Addin, which is free and on most distributions of MS Office Pro. I'd just update the...

Here's a comparison of turning one's PPR into an IP. It includes comparing a P&I with a IO loan. If you install the excel solver addin, you can mess with various variables. As it is, I used solver to calculate how much rent one would pay elsewhere to breakeven after disposal of the house 15...

Here's an update to the budget planner. And an analysis I did recently on the ownership costs of a car. When there are asset bubbles boiling away, it would seem sensible to channel as much of one's income into acquiring appreciating assets, whether property or shares. This analysis shows...

Here's a simple pretty Budget Planner with pie chart. Allows 'what if' messing with tax deductible investment expenditure.

First Home or IP? Here's a spreadsheet that analyses buying one's first property as a first home or IP (uses Qld stamp duty). Seems at the end of the first year, one is better off buying as a PPR. If you want to turn it into an IP, better to do so after 12 mths as PPR. Note that all levels...