Join Australia's most dynamic and respected property investment community

Excel List

Discussion in 'Information Resources & Tools' started by devank, 22nd Jun, 2015.

  1. devank

    devank Look, lets just get on with this, ok? Premium Member

    Joined:
    18th Jun, 2015
    Posts:
    728
    Location:
    Inner West - Sydney
    Here is a list of few Excel files some might find it useful.
    I got most of them from SS. I tried to keep the original author and their explanation if useful. These usernames are from SS.

    Link to Dropbox folder lists all these files. I thought this might be a easier way to update these files. Please email or let me know if you find any other useful files.

    IP HOLDING
    11 IP Calculator.xlsx
    12 IP20HoldingCostsv15.xls
    13 property Portfolio Tracker.xls
    14 IPs_Etax_Sample.xls (added on 22/06/15)
    I have added a E-Tax friendly summary sheet It is matter copy & paste from E-tax point of view. You need to create different sheets for each IP as input can be different. It would be easier once you develop your own system. Next year even the inputs can be copy & paste from a RE agent's statement.

    15 2015 Tax Summary v1
    This is taken from another post

    BUYING
    21 Investment Viability.xls
    22 Purchase_Inspection_Analysis.xlsx
    The PDF was created by 'Property Investor Network'. I created an Excel version out of it.

    23 Real estate investment model (Nov08) HC.xls
    24 NRAS Cash Flow Analysis V2.xls

    DEVELOPING
    31 DevelopmentScenarios.xls
    32 duplexConcept.xlsx
    This is a little strange one. People with a little imagination might find it useful.
    I created this excel to come up with a duplex concept design given multiple restrictions.


    STRATEGY
    41 Required_Asset_to_Retire.xlsx
    42 _20YearPlanV6.xlsx
    I have removed the info from the sheets S.M.A.R.T. (Specific, Measurable, Achievable, Relevant and Time-bound) goal for each category with a column to monitor them to as it is a bit personal.


    OTHER
    51 Personal + SMSF Property Holdings.xls
    52 DomainAuctionResults.zip
    Remember: Everything is prone to human error!
     
    Last edited: 25th Jun, 2015
  2. wombat777

    wombat777 Well-Known Member Premium Member

    Joined:
    18th Jun, 2015
    Posts:
    1,449
    Location:
    33°41'24.7"S 150°55'34.3"E
    Can anyone recommend useful spreadsheets for capturing IP purchase and holding costs / expenses?

    I need to start recording the expenses and organise receipts in a manner that will make it easy for my accountant.
     
    crusstopher likes this.
  3. devank

    devank Look, lets just get on with this, ok? Premium Member

    Joined:
    18th Jun, 2015
    Posts:
    728
    Location:
    Inner West - Sydney
    I have added a E-Tax friendly summary sheet '14 IPs_Etax_Sample.xls' . It is matter copy & paste from E-tax point of view.

    You need to create different sheets for each IP as input can be different. It would be easier once you develop your own system. Next year even the inputs can be copy & paste from RE agent's statement.
     
    Last edited: 22nd Jun, 2015
  4. Jamie Moore

    Jamie Moore MORTGAGE BROKER - AUSTRALIA WIDE Business Member

    Joined:
    18th Jun, 2015
    Posts:
    2,159
    Location:
    Canberra and Sydney
    Legend - great work devank!
     
    devank likes this.
  5. wombat777

    wombat777 Well-Known Member Premium Member

    Joined:
    18th Jun, 2015
    Posts:
    1,449
    Location:
    33°41'24.7"S 150°55'34.3"E
    Thanks - appreciated!
     
    devank likes this.
  6. Arnel

    Arnel Well-Known Member

    Joined:
    21st Jun, 2015
    Posts:
    130
    Location:
    Perth
    Great. Top stuff!
     
    devank likes this.
  7. el caballo

    el caballo Well-Known Member

    Joined:
    21st Jun, 2015
    Posts:
    111
    Location:
    Australia
    Devan

    Very commendable - I'll be reviewing.
     
    devank likes this.
  8. Art Vandelay

    Art Vandelay Well-Known Member

    Joined:
    18th Jun, 2015
    Posts:
    77
    Location:
    Australia
    Thanks devank - lots of food for thought.
     
    devank likes this.
  9. Tekoz

    Tekoz Well-Known Member

    Joined:
    24th Jun, 2015
    Posts:
    1,244
    Location:
    Sydney
    many thanks for sharing thiscool stuff @devank !
     
    devank likes this.
  10. cherubym

    cherubym Well-Known Member

    Joined:
    10th Aug, 2015
    Posts:
    267
    Location:
    Melbourne
    Wow, this list is a treasure for me! Thanks, @devank !!!
     
    devank likes this.
  11. Azazel

    Azazel Well-Known Member

    Joined:
    18th Jun, 2015
    Posts:
    8,113
    Location:
    Brisbane
    Good stuff @devank , thanks!
     
    devank likes this.
  12. Tony Fleming

    Tony Fleming Well-Known Member Business Member

    Joined:
    18th Jun, 2015
    Posts:
    546
    Location:
    Sydney
    Legend thanks Devank
     
    devank likes this.
  13. bonanzawealth

    bonanzawealth Well-Known Member

    Joined:
    23rd Jun, 2015
    Posts:
    58
    Location:
    Sydney NSW
    This web page is not available :(
     
  14. Coota9

    Coota9 Well-Known Member Premium Member

    Joined:
    18th Jun, 2015
    Posts:
    970
    Location:
    Melbourne
    devank likes this.
  15. Raydar

    Raydar Well-Known Member

    Joined:
    6th Jul, 2015
    Posts:
    306
    Location:
    Newcastle NSW
    Wowsers! Defo be reviewing these files. I was in the process of making my own.
     
    devank likes this.
  16. Azazel

    Azazel Well-Known Member

    Joined:
    18th Jun, 2015
    Posts:
    8,113
    Location:
    Brisbane
    Same here, was able to download the lot as a .zip.
     
    devank likes this.
  17. Alfiesausagedog

    Alfiesausagedog Active Member

    Joined:
    16th Sep, 2016
    Posts:
    30
    Location:
    Brisbane
    Just stumbled across this thread, absolute goldmine. Thanks to everyone who assisted in creating this fantastic library of helpful spreadsheets.
     
    devank likes this.
  18. TadhgMor

    TadhgMor Well-Known Member

    Joined:
    5th Sep, 2016
    Posts:
    77
    Location:
    Penrith NSW
    +1 to all who have contribute - as a n00b this was a gold find today :)
     
    devank likes this.
  19. Colin Rice

    Colin Rice Mortgage Broker Australia Wide Business Member

    Joined:
    9th Jul, 2015
    Posts:
    1,083
    Location:
    Perth
    This Zip folder us going into my "resource and education" file

    Cheers devank :)
     
    devank likes this.
  20. BLTN

    BLTN Member

    Joined:
    12th Oct, 2016
    Posts:
    13
    Location:
    Melbourne
    I may be doing something wrong but I get a password request for the "42 _20YearPlanV6.xlsx" file. There's no mention of a password in the original thread, here, or in Dropbox.

    What am I missing?

    Thanks