NZ Investment Property
Analyser v1.0
Analyse any NZ residential investment property in minutes. Cashflow, yield, LVR, equity, and long-term returns — all in one comprehensive Excel model.
What Does This Model Do?
The NZ Investment Property Analyser v1.0 is a comprehensive Excel model built specifically for New Zealand residential property investors. Enter the key numbers for any property and instantly see whether it stacks up — before you commit.
The model covers everything a NZ property investor needs: purchase price, mortgage structure, rental income, vacancy allowance, operating expenses, and capital growth assumptions. It outputs clear cashflow projections, gross and net yield, LVR, equity position, and 10-year return estimates.
Property & Finance Setup
Enter purchase price, deposit, mortgage rate, term, and rental income. Full LVR and equity calculation.
Cashflow Analysis
Weekly and annual cashflow breakdown. Gross and net yield. Vacancy, rates, insurance, and management fees.
10-Year Projections
Capital growth, equity build-up, and cumulative return on investment over a 10-year holding period.
What’s Included
- NZ Investment Property Analyser v1.0 Excel file (.xlsx)
- Pre-built formulas — no Excel expertise required
- NZ-specific expense categories (rates, insurance, property management)
- Cashflow, yield, LVR, equity, and 10-year return outputs
- Clean data entry interface — plug in your numbers and go
- Compatible with Excel 2016+, Microsoft 365, and Google Sheets
- PDF quick-start guide included
Requirements
- Excel 2016 or later — Windows or Mac
- Microsoft 365 — fully supported
- Google Sheets — supported (some formatting may differ)
- No macros, no add-ins, no Power BI required
- No internet connection needed after download
This is a standalone Excel model. It does not require Power BI Desktop or any BI SmartStudio subscription to use.
