Excel List

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

Join Australia's most dynamic and respected property investment community
Page 1 of 6
  1. devank

    devank Well-Known Member

    Joined:
    18th Jun, 2015
    Posts:
    1,669
    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
    devank, 22nd Jun, 2015
    #1
    Matt L, Ash11, Bread and 55 others like this.
  2. wombat777

    wombat777 Well-Known Member

    Joined:
    18th Jun, 2015
    Posts:
    3,565
    Location:
    On a Capital and Income Growth Safari
    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.
     
    wombat777, 22nd Jun, 2015
    #2
    crusstopher likes this.
  3. devank

    devank Well-Known Member

    Joined:
    18th Jun, 2015
    Posts:
    1,669
    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
    devank, 22nd Jun, 2015
    #3
    Gypsyblood likes this.
  4. Jamie Moore

    Jamie Moore MORTGAGE BROKER - AUSTRALIA WIDE Business Member

    Joined:
    18th Jun, 2015
    Posts:
    3,979
    Location:
    Canberra, Brisbane and Sunshine Coast
    Legend - great work devank!
     
    Jamie Moore, 22nd Jun, 2015
    #4
    Gypsyblood and devank like this.
  5. wombat777

    wombat777 Well-Known Member

    Joined:
    18th Jun, 2015
    Posts:
    3,565
    Location:
    On a Capital and Income Growth Safari
    Thanks - appreciated!
     
    wombat777, 22nd Jun, 2015
    #5
    devank likes this.
  6. Arnel

    Arnel Well-Known Member

    Joined:
    21st Jun, 2015
    Posts:
    173
    Location:
    Perth
    Great. Top stuff!
     
    Arnel, 23rd Jun, 2015
    #6
    devank likes this.
  7. el caballo

    el caballo Well-Known Member

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

    Very commendable - I'll be reviewing.
     
    el caballo, 23rd Jun, 2015
    #7
    devank likes this.
  8. Art Vandelay

    Art Vandelay Well-Known Member

    Joined:
    18th Jun, 2015
    Posts:
    146
    Location:
    Australia
    Thanks devank - lots of food for thought.
     
    Art Vandelay, 24th Jun, 2015
    #8
    devank likes this.
  9. Tekoz

    Tekoz Well-Known Member

    Joined:
    23rd Jun, 2015
    Posts:
    1,374
    Location:
    Sydney
    many thanks for sharing thiscool stuff @devank !
     
    Tekoz, 30th Jun, 2015
    #9
    devank likes this.
  10. Ko Ko Naing

    Ko Ko Naing Well-Known Member

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

    Azazel Well-Known Member

    Joined:
    18th Jun, 2015
    Posts:
    8,091
    Location:
    Brisbane
    Good stuff @devank , thanks!
     
    Azazel, 11th Aug, 2015
    #11
    devank likes this.
  12. Tony Fleming

    Tony Fleming Well-Known Member

    Joined:
    18th Jun, 2015
    Posts:
    717
    Location:
    Sydney
    Legend thanks Devank
     
    Tony Fleming, 11th Aug, 2015
    #12
    devank likes this.
  13. bonanzawealth

    bonanzawealth Well-Known Member

    Joined:
    23rd Jun, 2015
    Posts:
    58
    Location:
    Sydney NSW
    This web page is not available :(
     
    bonanzawealth, 17th Aug, 2015
    #13
  14. Coota9

    Coota9 Well-Known Member

    Joined:
    18th Jun, 2015
    Posts:
    1,286
    Location:
    Melbourne
    Coota9, 17th Aug, 2015
    #14
    devank likes this.
  15. Raydar

    Raydar Well-Known Member

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

    Azazel Well-Known Member

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

    Alfiesausagedog Well-Known Member

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

    TadhgMor Well-Known Member

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

    Colin Rice Mortgage Broker Business Member

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

    Cheers devank :)
     
    Colin Rice, 21st Sep, 2016
    #19
    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
     
    BLTN, 27th Oct, 2016
    #20
Page 1 of 6
Buy Property Interstate WITHOUT Buyers Agents!

Buy Property Interstate WITHOUT Dropping $15k On Buyers Agents Each Time! Helping People Achieve PASSIVE INCOME Using Our Unique Data-Driven System, So You Can Confidently Buy Top 5% Growth & Cashflow Property, Anywhere In Australia