Forums / Property Investing / Help Needed! / Property Evaluation Spreadsheets

Viewing 2 posts - 1 through 2 (of 2 total)
  • Profile photo of Robert KingRobert King
    Join Date: 2016
    Post Count: 13

    Hello P.I’s,
    Budding investor, 37yo, have 3 properties and have set goal for 2-3 more within the next FY.
    ….also, first time posting.
    What I am really after today is suggestions or offerings of spreadsheets/software that is clean and easy to use and will assist in the evaluation of a property before purchasing.

    I currently use my own excel but it is not as functional as I would like. With the right input it will tell me a properties Net Return but I need more….more I tell you!

    For example it does not run options such as changes in interest rate or change in Interest only or Principle & interest payment options
    Nor does it have the ability to automatically calculate Stamp Duty(per state) or LMI estimate (if low deposit)

    I have looked at the Somersoft PIA but I am not sure how to use it and it looks too sophisticated for my current status.

    Happily, I welcome all suggestions and also I would like to meet with any investors(Melb,Syd,GC,Bris) for coffee/chats/education :)
    Mainly because I am the only investor in my small circle so really need to build a more relate-able network.

    Profile photo of Richard TaylorRichard Taylor
    Join Date: 2003
    Post Count: 12,018

    Hi Robert

    To be able to incorporate a stamp duty calculator or LMI estimator into Excel shouldn’t be particularly difficulty.

    Just get the figures from the OSR State you are looking and copy in the formula.

    For LMI just run off Gemworths calculator. Whilst each lenders scale will be different at least this will give you a useful guide.

    You should also be able to work out Depreciation, Capital Allowance etc at the same time.


    Yours in Finance

    Richard Taylor | Mortgage Broker helping investors build their wealth thru property
    Email Me | Phone Me

    0-40 Properties in a decade with a unencumbered portfolio value in excess of $40M. Ask me for a copy of my API Interview.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.