Detailed Holding Costs Excel File

Hey guys,

just thought id share this with you all.

Runs through holding costs for year 1-15 for IPs.

Majority formula based so use the front page for most of the cals.l If you want to add something particular in go to the IP Calulations Page and put it in under the year and correct spot. It will automatically calculate the value for the following year, so you will need to delete all the cells after that in the row if you want. Otherwise on the front page there is a once off expense which will only go for the year

Using 06-07 tax rates and works out the tax liability for cgt in discount method.

Only works for IO currently, thinking of the best way to do P&I

PERSONAL USE ONLY. IF YOU WANT TO USE IT IN A BUSINESS/PERSONAL DISTRIBUTION PLEASE PM ME

Any questions/quaries/mistakes pm me but its pretty straight forward. But some feedback would be great.

Thanks to MichaelWhyte and Mark C (from SS) for the initial concepts.

Attached Files

IP Holding Costs v12 final.zip (89.4 KB, 228 views)

DaveA - thank you so much for making this available. For those of us just starting out it certainly makes life a lot easier. Excellent stuff.

im one of those myself, so thats why i would to hear peoples opinions on it or what additional could be included....

as thus far it has not had a professional run through with real figures... they have all been my own made up ones...

new updated version...

had an issue with the mortgage stamp duty so all fixed now...

Attached Files

IP Holding Costs v13 final.zip (89.6 KB, 124 views)

hey guys, ive updated this spreadsheet again after i found a few bugs in it over the last year after i stress tested it buying a property... hopefully all the bugs should be ironed out now but if anyone has any issues then please let me know...

ive also put this years tax rates changes into it and in time i will put up a version which will be relevant from July 1 2008....

Attached Files

IP Holding Costs v15.xls (414.0 KB, 150 views)

Thanks Dave - you're a star!

Thanks Dave

btw, after June, Mortgage stamp duty will be removed in NSW

Stamp Duty Fees

Exemption - Investment Housing
The second exemption (from 1 July 2008) is an exemption for mortgages that are made in connection with investment housing. Mortgage duty will not be chargeable in respect of a mortgage if the mortgage secures an advance or advances made, from 1 July 2008, for the purpose of investment housing and no other advances. If the mortgage does secure an advance made for another purpose, mortgage duty will not be chargeable in respect of the advance made for the purpose of investment housing.
An advance is made for the purpose of investment housing if it is to be applied wholly or predominantly for one or more of the following purposes:
€ financing the acquisition of investment housing,
€ financing the construction of investment housing,
€ financing alterations or additions to investment housing,
€ repaying another advance, if the advance to be repaid was made for the purpose of investment housing.

no worries, ill incorporate that into v16....

if anyone has any other law changes then please let me know, as i have time to update it but not go and search to see if any of the stamp duties have changed....

thanks

This is awesome Dave. Thanks heaps

Does anyone have access to a spreadsheet for paying off an investment property?

Cheers

Nice 1 Dave