With interest rates trending higher, interest deductibility being phased out and Landlord costs generally rising, doing your homework and crunching the numbers has never been more crucial for sound property investing.

Here is a spreadsheet that we created to do just that. It works just as well for one property, as it does for 10… or 20! Its also super useful to analyse a property you might be thinking about buying.

All you need to do is fill out the light grey cells and Excel will do the rest!

If you’d like to run through a live example then Olly has put together a 13 minute video that does just that.

We hope you find this resource helpful. Please reach out to oliver@wre.co.nz with any feedback or questions. He’d love to hear from you!

Please enter your details below to download the spreadsheet

Disclaimer: Waikato Real Estate Ltd is not a financial adviser. You should consider seeking independent legal, financial, taxation or other advice to check how the information in this spreadsheet relates to your unique circumstances.

The calculators and tools in this spreadsheet are provided for your information and to illustrate scenarios. The results should not be taken as a substitute for professional advice.

All reasonable care has been taken in preparing and designing the calculators and tools; however, Waikato Real Estate Ltd provides no warranties and makes no representation that the information provided by the calculators and tools is appropriate for your particular circumstances or indicates you should follow a particular course of action.

Disclaimer: Waikato Real Estate Ltd is not a financial adviser. You should consider seeking independent legal, financial, taxation or other advice to check how the information in this spreadsheet relates to your unique circumstances.

The calculators and tools in this spreadsheet are provided for your information and to illustrate scenarios. The results should not be taken as a substitute for professional advice.

All reasonable care has been taken in preparing and designing the calculators and tools; however, Waikato Real Estate Ltd provides no warranties and makes no representation that the information provided by the calculators and tools is appropriate for your particular circumstances or indicates you should follow a particular course of action.