Join our investing community

Detailed Holding Costs Excel File 2016-09-15

Detailed Holding Costs Excel File

  1. DaveA

    DaveA Well-Known Member

    Joined:
    19th Feb, 2007
    Posts:
    617
    Location:
    Sydney, NSW
    DaveA submitted a new resource:

    Detailed Holding Costs Excel File - Detailed Holding Costs Excel File

    Read more about this resource...
     
    Last edited by a moderator: 15th Sep, 2016
  2. islandgirl

    islandgirl Well-Known Member

    Joined:
    18th Sep, 2006
    Posts:
    118
    Location:
    Middle of beautiful Moreton Bay, Qld
    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.
     
  3. DaveA

    DaveA Well-Known Member

    Joined:
    19th Feb, 2007
    Posts:
    617
    Location:
    Sydney, NSW
    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...
     
  4. DaveA

    DaveA Well-Known Member

    Joined:
    19th Feb, 2007
    Posts:
    617
    Location:
    Sydney, NSW
    new updated version...

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

    Attached Files:

  5. DaveA

    DaveA Well-Known Member

    Joined:
    19th Feb, 2007
    Posts:
    617
    Location:
    Sydney, NSW
    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:

  6. Nigel Ward

    Nigel Ward Team InvestEd

    Joined:
    10th Jun, 2005
    Posts:
    1,172
    Thanks Dave - you're a star!
     
  7. Billv

    Billv Getting there

    Joined:
    15th Jul, 2007
    Posts:
    1,796
    Location:
    Sydney, NSW
    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.
     
  8. DaveA

    DaveA Well-Known Member

    Joined:
    19th Feb, 2007
    Posts:
    617
    Location:
    Sydney, NSW
    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
     
  9. Cobberd

    Cobberd New Member

    Joined:
    12th Jun, 2008
    Posts:
    1
    Location:
    Melbourne
    This is awesome Dave. Thanks heaps

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

    Cheers
     
  10. DexterJambles

    DexterJambles Member

    Joined:
    30th Mar, 2008
    Posts:
    19
    Location:
    Melbourne, VIC
    Nice 1 Dave :)
     
  11. DaveA

    DaveA Well-Known Member

    Joined:
    19th Feb, 2007
    Posts:
    617
    Location:
    Sydney, NSW
    No Worries, glad i could help with it....

    havent had chance to get the next one up with the new tax rates but i will hopefully soon... let me know if anyone is desperatly hanging out for it...
     
  12. Billv

    Billv Getting there

    Joined:
    15th Jul, 2007
    Posts:
    1,796
    Location:
    Sydney, NSW
    Dave

    I've got a question for you, I was looking through the overview sheet
    and I can't understand why the available equity is not increasing after year 11.
    It's stuck on $432,358

    Any ideas?
    Also, what's rental reality value?


    cheers
     
    Last edited by a moderator: 15th Nov, 2008
  13. Billv

    Billv Getting there

    Joined:
    15th Jul, 2007
    Posts:
    1,796
    Location:
    Sydney, NSW
    Dave,

    I worked it out, the "original input "sheet had the property sold date set to 2017.
    I've changed it so it's ok now.

    I've also found a link to rental reality value so all is ok

    cheers
     
    Last edited by a moderator: 16th Nov, 2008
  14. dconno1x

    dconno1x New Member

    Joined:
    4th Jul, 2008
    Posts:
    1
    Location:
    wa
    does anyone have 2008 version of IP Holding calculator

    Hi All

    Does anyone have new version of the calculator with 08/09 tax rates?:
     
  15. Billv

    Billv Getting there

    Joined:
    15th Jul, 2007
    Posts:
    1,796
    Location:
    Sydney, NSW
    Here is an updated version.
    If you want to change the taxable income do it on the first sheet (original input B29 and B30)

    cheers
     

    Attached Files:

  16. michael123

    michael123 New Member

    Joined:
    25th Dec, 2009
    Posts:
    1
    Location:
    Sydney, NSW
    Thank you

    Thank you so much...:)
     
  17. dev

    dev New Member

    Joined:
    20th Mar, 2010
    Posts:
    1
    Location:
    Balmain, NSW
    Combining IP Holding Costs calculator for multiple properties

    Hi Bill,

    I've just checked out your property calculator. It's pretty awesome.

    I have several properties and I purchased them over in different years.

    I am wondering, how to use your spreadsheet (which works great for one property) to combine the calculations for multiple properties into a consolidated cashflow view.

    Have you done that?
     
  18. Billv

    Billv Getting there

    Joined:
    15th Jul, 2007
    Posts:
    1,796
    Location:
    Sydney, NSW
    This is actually Dave's spreadsheet.
    It would be good if he could expand it to include more IP's,
    I haven't got the patience and the time to do this myself :D
     
  19. nthd_nthd

    nthd_nthd New Member

    Joined:
    14th Jul, 2014
    Posts:
    1
    Location:
    Smithfield
    Has anyone still looking at this

    I just started on this path and interesting in any updated version of doing research/analysis on IPs. Your help would be greatly appreciated. :)