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.
Cheers,
RobertHi 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.
Cheers
Yours in Finance
Richard Taylor | Australia's leading private lender
This is obviously a few years late… but I’ll post it here in case anyone else comes looking for an updated spreadsheet that serves this purpose.
This is a free spreadsheet/calculator that I have created that includes all the calculators you will need to analyse your investment purchases, cashflows, future growth and more.
Download it here: https://www.kingfisherfinancegroup.com.au/calculator-download
The calculators it includes are:
– Funding Calculator
– Mortgage Calculator
– Refinance Calculator
– Cashflow Calculator
– Equity Calculator
– ROI Calculator
– Sale CalculatorMost of the calculators are linked, so you can run scenarios from start to finish. This allows you to plan:
– the funds needed to make the purchase
– the mortgage
– the cashflows & holding costs
– the properties capital and rental growth
– the accessible equity over time
– the total ROI of the property
– the total funds available after selling the property in the futureThe spreadsheet includes links to some short videos explaining its functions and how to correctly use it.
Enjoy, and feel free to give feedback.
Nik Allan | Kingfisher Finance Group
https://www.kingfisherfinancegroup.com.au
Email Me | Phone MeI’ve had a fair few downloads of this spreadsheet so thought I would share a new updated one I have available. This one allows you to plan up to 10 properties and get 20 year projections on cashflow and performance. If this is something that you are interested in you can download here:
https://subscribepage.io/freespreadsheet
Nik Allan | Kingfisher Finance Group
https://www.kingfisherfinancegroup.com.au
Email Me | Phone Me
You must be logged in to reply to this topic. If you don't have an account, you can register here.
