First Property Playbook — Property Investment Calculator

The spreadsheet every Australian property investor needs — but nobody tells you exists.

Before you make an offer on any investment property, you need to know four things: what it actually costs you each month, whether the suburb stacks up against alternatives, what your portfolio looks like at a glance, and how much you can actually borrow.

This calculator does all four — automatically.

What's inside — 4 tabs:

Tab 1 — Property Analyser Enter your purchase price, deposit, interest rate and expected rent. It calculates gross yield, net yield, monthly cashflow, your annual tax benefit from negative gearing, and your true monthly out-of-pocket cost after tax. The one number that tells you whether you can actually afford the property.

Tab 2 — Suburb Comparison Compare up to 5 suburbs side by side. Vacancy rate, rental yield, days on market, owner-occupier ratio, infrastructure score, price growth. Auto-scoring ranks each suburb out of 40 so the best options are obvious at a glance.

Tab 3 — Portfolio Tracker Track all your properties in one place. Current value, loan balance, equity, rental income, expenses, net cashflow. Updates annually to show your total portfolio value, total equity and overall performance.

Tab 4 — Borrowing Capacity Estimator Enter your salary, existing debts, credit card limits and living expenses. Applies the standard APRA 3% assessment buffer Australian banks use. Outputs your estimated borrowing capacity and maximum property price — so you walk into every broker conversation already knowing your numbers.

How it works: Download → Upload to Google Drive → File → Make a Copy → Start entering your numbers. Blue cells are yours to edit. Everything else calculates automatically.

Built for the Australian market. Australian tax rates, APRA assessment buffers, Australian expense benchmarks.

$37 AUD · Instant access · Works in Google Sheets and Excel