Cash Flow excel speadseet

Discussion in 'Property Information Resources & Tools' started by Malcolm Myers, 21st Aug, 2017.

Join Australia's most dynamic and respected property investment community
Tags:
  1. Malcolm Myers

    Malcolm Myers Member

    Joined:
    20th Jul, 2017
    Posts:
    13
    Location:
    Vic
    Hi does anyone have a good excel investment property cash flow spreadsheet they are happy to share? Im looking for one the takes in
    1. A variable P & I loan
    2. depreciation


    Spreadsheets that include these seem to be hard to find.

    Thanks in advance

    Malcolm
     
    Malcolm Myers, 21st Aug, 2017
    #1
    SamanthaKet likes this.
  2. Paul@PAS

    Paul@PAS Tax, Accounting + SMSF + All things Property Tax Business Plus Member

    Joined:
    18th Jun, 2015
    Posts:
    23,504
    Location:
    Sydney
    I have one only for analysis of a proposed purchase
     

    Attached Files:

    Paul@PAS, 22nd Aug, 2017
    #2
    Perthguy, CK_Invest, Archaon and 2 others like this.
  3. bread_boy

    bread_boy Well-Known Member

    Joined:
    20th Jul, 2015
    Posts:
    311
    Location:
    Floater
    bread_boy, 23rd Aug, 2017
    #3
    Curoch likes this.
  4. FrivolousPanda

    FrivolousPanda Well-Known Member

    Joined:
    21st Sep, 2016
    Posts:
    256
    Location:
    Sydney
    If OP is still looking for a cashflow worksheet, I have created one which is posted in this thread <Link>.
     
    FrivolousPanda, 8th Dec, 2017
    #4
    Curoch and Perthguy like this.
  5. Annie33rd

    Annie33rd Well-Known Member

    Joined:
    4th Mar, 2022
    Posts:
    58
    Location:
    Sydney
    Hi Paul,
    I have come across your spreadsheet and understand about 80% of it. Would really appreciate if I could ask you a couple of questions about it?

    Thanks
    Anna
     
    Annie33rd, 26th Mar, 2022
    #5
  6. Annie33rd

    Annie33rd Well-Known Member

    Joined:
    4th Mar, 2022
    Posts:
    58
    Location:
    Sydney
    Hi,
    Can i ask you a question re your spreadsheet? How did you get to the CF @ 9% IO after NG benefit number in cells H13?
     
    Annie33rd, 27th Mar, 2022
    #6
  7. FrivolousPanda

    FrivolousPanda Well-Known Member

    Joined:
    21st Sep, 2016
    Posts:
    256
    Location:
    Sydney
    Sorry @Annie33rd, which worksheet are you referring to?
     
    FrivolousPanda, 28th Mar, 2022
    #7
  8. Annie33rd

    Annie33rd Well-Known Member

    Joined:
    4th Mar, 2022
    Posts:
    58
    Location:
    Sydney
    Oh so sorry, you were not the OP of the one I was asking about however I have seen you have a few posted as well. Can I ask what the difference is between Cashflow_Sanitised and new calc_sanitised? Which is better to use?
     
    Annie33rd, 28th Mar, 2022
    #8
  9. FrivolousPanda

    FrivolousPanda Well-Known Member

    Joined:
    21st Sep, 2016
    Posts:
    256
    Location:
    Sydney
    I developed Cashflow_Sanitised for my use and Athikalaka developed new calc_sanitised for their use. Both of us probably shared the models, in case it is a useful starting point for someone. You will have to do a detailed comparison to see what the differences are and also if it's appropriate for you and if there are any errors.

    I think you are best placed to say which is better for you. I'm going to say mine and I'm sure Athikalaka will say theirs. Both of us are probably wrong.

    Happy to answer questions on my model or give suggestions if you are trying to do something it doesn't do
     
    FrivolousPanda, 29th Mar, 2022
    #9
  10. Annie33rd

    Annie33rd Well-Known Member

    Joined:
    4th Mar, 2022
    Posts:
    58
    Location:
    Sydney
    Hi
    Hi Paul,

    Can i please ask you some questions about your sheet? If you could DM me that would be super.
    Thanks
     
    Annie33rd, 1st Apr, 2022
    #10
Buy High Growth Property WITHOUT Buyers Agents!