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 Calculator

Most 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 future

The spreadsheet includes links to some short videos explaining its functions and how to correctly use it.

Enjoy, and feel free to give feedback.