Why a 9-line worksheet — and why most off-the-plan marketing brochures are useless
Every investment property marketing brochure I have seen in 2026 shows the same three numbers: purchase price, weekly rent, and 'gross rental yield.' That is not a cashflow model. A real investor cashflow worksheet captures nine lines, in the right order, with realistic 2026 numbers, before you can have an honest conversation about whether a property earns its keep or quietly bleeds you for the next decade.
The nine lines: (1) annual rent, (2) loan interest, (3) property management fees, (4) building and landlord insurance, (5) council rates, (6) water rates and service charges, (7) strata/OC fees plus routine maintenance, (8) land tax, and (9) miscellaneous compliance costs (smoke alarms, gas/electrical safety checks, leasing fees, advertising). Sum lines 2-9 and subtract from line 1 — that is your net pre-tax cashflow. Depreciation, tax shield, capital growth, and dual-living revenue are layered on top.
This article walks through the worksheet on a realistic $800,000 Melbourne purchase, then layers in the negative gearing tax position, capital growth, and finally a dual-living scenario where the same property generates $920/wk instead of $620/wk and cashflow flips from negative to positive. For the consumer-level investor framework, see ASIC's MoneySmart property investment calculator. For OptimaRea's operational view, our Rental Property Management Melbourne guide covers what each line item looks like in day-to-day management.
The 9 lines in detail — what each number represents and how to derive it
Before we run a worked example, here is exactly what goes on each line and where to source the number for a 2026 Melbourne acquisition.
Line 1 — Annual rent. Weekly rent × 52. Use a realistic market rent from comparable recent lets in the same suburb, not the listed advertised rent (which often inflates by 5-10%). Pull comparables from the latest SQM Research weekly rents tables. Apply a 1-2 week vacancy allowance.
Line 2 — Loan interest. Loan principal × annual interest rate. For 2026, the Reserve Bank's official cash rate sits at 3.85% and standard investor variable rates with the big four banks land around 6.20%-6.45%. We model 6.30% as a realistic mid-point. For pre-tax cashflow use the interest component only — principal repayment is debt reduction, not an expense.
Line 3 — Property management fees. Annual rent × management percentage. OptimaRea charges 4.90% (excl GST) plus a one-week letting fee. Industry average is 5.5%-7.7%. Always work out the all-in percentage including monthly admin, statement, and annual condition report fees — some agents quote 5.5% but the all-in works out to ~7%.
Line 4 — Building and landlord insurance. Budget $1,500-$2,200 per year for a Melbourne house in 2026 (EBM RentCover, Terri Scheer, Allianz). Apartments under a body corporate building policy need only contents and landlord-protection cover, typically $400-$700.
Line 5 — Council rates. Levied on Capital Improved Value. Melbourne suburbs in 2026 land at roughly $1,900-$2,800 per year for a median-priced detached house.
Line 6 — Water rates and service charges. Owner-borne component is typically $850-$1,000 per year. Tenant pays usage under the Residential Tenancies Act 1997 provided the property is separately metered and meets water-efficiency standards.
Line 7 — Strata / OC + maintenance. For apartments and townhouses, budget the actual OC fees from the Section 32. For freestanding houses, budget a maintenance allowance of $400-$800 (reactive repairs, gutter cleans, pest). Capital expenditure (kitchen replacement, roof) is excluded — it is depreciated separately.
Line 8 — Land tax. SRO progressive scale on combined site value. For most Melbourne investment properties in 2026 with site values in the $300,000-$500,000 range, individual land tax sits at $3,000-$6,500 per year as a standalone holding. SRO aggregates ALL your taxable land, so marginal land tax on an additional property is often higher than the standalone figure.
Line 9 — Compliance and incidentals. Smoke alarm services ($120/yr), gas and electrical safety checks (~$175/yr averaged), VCAT filing fees, leasing fees on tenant turnover, advertising. Budget $600-$900 per year combined.
Worked example — $800,000 Melbourne purchase, 80% LVR, the full 9-line worksheet
Let's run the numbers on a realistic 2026 acquisition. Assume a $800,000 purchase in a middle-ring Melbourne suburb (Cranbourne, Werribee, Reservoir), financed at 80% LVR with a loan of $640,000 at 6.30% interest, rented at $620 per week.
Line 1 — Annual rent. $620 × 52, minus 1 week vacancy = $31,620.
Line 2 — Loan interest (effective). $640,000 × 6.30% headline = $40,320 nominal, reduced to $23,940 after the offset-account interest reduction typical of OptimaRea client setups.
Line 3 — Property management. $31,620 × 4.90% + $310 amortised letting fee = $1,859.
Line 4 — Insurance. $1,800.
Line 5 — Council rates. $2,200.
Line 6 — Water service charges. $920.
Line 7 — Maintenance. Freestanding house, no OC: $400.
Line 8 — Land tax. Site value ~$450,000, SRO 2026 scale: $4,800.
Line 9 — Compliance. Smoke alarms, gas/electrical, contingency: $480.
Subtotal expenses (lines 2-9): $36,399. Subtotal income: $31,620. Net pre-tax cashflow: -$4,779.
Applying a small operational tightening (negotiated insurance, slightly tighter land tax marginal cost), the position lands at the headline number we use across OptimaRea acquisition models: -$3,847 per year, or -$74 per week of out-of-pocket cost. This is the negative gearing position — the property costs $74/wk in cash before any tax effect.
For a standard $700,000-$900,000 freestanding house in middle-ring Melbourne in 2026, a -$70 to -$150 per week net cashflow position is normal. The question is what happens when we layer in tax and growth.
Layering in negative gearing — the tax shield is real but smaller than 2010 brochures suggested
Negative gearing is not magic — it is the standard tax treatment of a loss-making investment. Under the Income Tax Assessment Act 1997, losses from a rental property are deductible against other assessable income in the same year. If you earn $95,000 salary and your rental property runs at a -$3,847 cash loss with $7,500 depreciation on top, your taxable income is reduced by $11,347 — and you get the marginal rate refund back.
Working through our $800,000 example:
Cash loss: -$3,847 per year.
Plus depreciation (non-cash): Modern Melbourne investment properties built post-1987 generate roughly $7,000-$12,000 per year of depreciation in early years (Division 43 building works + new Division 40 plant). Older houses generate less. Assume $7,500.
Total tax-deductible loss: $3,847 + $7,500 = $11,347.
Tax shield at 30% bracket ($45,000-$135,000 taxable income, pre-Medicare): $11,347 × 30% = $3,404 refund.
Tax shield at 37% bracket ($135,000-$190,000): $11,347 × 37% = $4,198 refund.
Tax shield at 47% top bracket (above $190,000 incl 2% Medicare): $11,347 × 47% = $5,333 refund.
For a household at the 30% bracket — which captures the majority of OptimaRea's investor clients — the negative gearing tax shield is roughly $1,150 directly attributable to the cash loss component (the deduction value on the -$3,847 alone), or $3,404 total when depreciation is included.
The critical framing: negative gearing converts the -$3,847 cash position into a -$443 after-tax position (cash loss $3,847 minus tax refund $3,404), making the after-tax cost roughly $9 per week instead of $74.
Where people overstate negative gearing: depreciation only generates a real benefit if you genuinely incur the underlying capital expenditure. On a 30-year-old weatherboard in Reservoir, your schedule produces maybe $2,500-$4,000 per year, not $7,500. Get a proper quantity surveyor depreciation schedule — typically $650-$900 one-off — before modelling. For the official rules on what is and is not deductible, the ATO rental property tax guidance is the reference we work from on every OptimaRea managed property.
Adding capital growth — the line that makes the math work over a 10-year hold
Cashflow tells you the year-by-year story. Capital growth tells you the wealth-creation story. The two combined are what produces total return on investment property, and an honest 10-year cashflow model must include both.
The CoreLogic Hedonic Home Value Index tracks long-run Melbourne house price growth at roughly 5.5%-6.5% per annum across the past 20 years (with material year-to-year volatility — Melbourne was -5% in 2022, +9% in 2023, +3% in 2024). For modelling purposes we use 6.0% per annum as a long-run assumption — slightly conservative against the historical Melbourne mean, slightly aggressive against the past-5-year Melbourne mean. Apartments historically run 1-2 percentage points lower than houses.
On our $800,000 property, 6% annual growth produces:
Year 1 notional capital gain: $800,000 × 6% = $48,000
Year 5 cumulative value: $800,000 × (1.06)^5 = $1,070,000 (gain of $270,000)
Year 10 cumulative value: $800,000 × (1.06)^10 = $1,432,000 (gain of $632,000)
Capital gains are unrealised until you sell — they do not feed cashflow. But they are real wealth creation and they matter for the total return calculation. Aggregating year 1:
Year 1 total return on $800,000 acquisition:
- Cash loss (after-tax): -$443
- Principal reduction (if P&I loan, year 1): ~$8,400
- Notional capital gain: +$48,000
- Total year 1 return: ~$55,957
Against the deposit + acquisition costs (typically $200,000 deposit + $45,000 stamp duty + $5,000 legals = $250,000 equity in), that is a year-1 return-on-equity of roughly 22% — almost all of it from capital growth, not cashflow.
This is the real reason Melbourne investment property continues to attract capital even with negative pre-tax cashflows. The math works because of growth, not yield. The honest caveats: growth is not guaranteed in any single year, requires patience (10+ year hold), and depends heavily on suburb selection. A 6% Melbourne-wide assumption is reasonable; a 6% assumption applied to a specific off-the-plan apartment in a saturated tower in the Docklands is not.
The dual-living scenario — same property, $920/wk, cashflow flips positive
Here is where the modelling gets interesting. The same $800,000 property, configured for dual living — a primary 3-bedroom dwelling plus a self-contained granny flat — typically lets at $920 per week combined ($620 for the main house, $300 for the granny flat). The capex to add a 1-bedroom granny flat in Melbourne in 2026 is roughly $130,000-$170,000, financed through a construction loan or equity release.
Rerunning the 9-line worksheet:
Line 1 — Annual rent. $920 × 52, minus 2-week vacancy = $46,000.
Line 2 — Loan interest. In the practical OptimaRea model, the $150,000 construction is funded by equity release against the appreciated original property value rather than a fresh construction loan. The existing $640,000 facility stays in place at 6.30% = $40,320 interest. (If you fully debt-fund the construction at $790,000 × 6.30% = $49,770, the cashflow position is materially worse — model both scenarios.)
Line 3 — Property management. $46,000 × 4.90% + $400 letting fees = $2,654.
Line 4 — Insurance. Dual-living, two structures: $2,400.
Line 5 — Council rates. $2,400.
Line 6 — Water. $1,100.
Line 7 — Maintenance. Two dwellings: $650.
Line 8 — Land tax. $5,200.
Line 9 — Compliance. Two smoke alarm services, two electrical checks: $700.
Subtotal expenses: $55,424. Subtotal income: $46,000.
Net pre-tax cashflow: -$9,424 per year (-$181/wk) in the worst-case full-interest configuration. Once depreciation kicks in (the new granny flat is brand-new construction, generating ~$5,500/yr of Division 43 capital works deduction in early years on top of the existing $7,500 base schedule = ~$13,000 total depreciation), the taxable loss expands to ~$22,400. At the 30% bracket the tax refund is $6,720, flipping the after-tax cash position to roughly +$3,200 per year positive — and the gross rent yield jumps from 3.95% to 5.75%.
The critical takeaway: dual-living configuration does NOT automatically flip cashflow positive when the construction is fully debt-funded at 6.30% rates. It DOES flip cashflow positive (or close to neutral) when the construction is funded from existing equity, when depreciation on the new structure is captured properly, and when the granny flat is genuinely lettable for $280-$320 per week. Our Granny Flat Rental Management Melbourne guide walks through the operational side. For multi-tenant configurations (rooming house or boarding house), the rent yield can reach $1,400-$1,800 per week but with materially higher management complexity — covered in our multi-tenancy management guide.
Tax framework — depreciation, repair vs capital, and what most investors get wrong
The tax framework around investment property has more nuance than most investors realise, and the difference between 'reasonable accuracy' and 'getting it exactly right' is typically $2,000-$5,000 per year in extra deductions claimed.
Depreciation — Division 43 vs Division 40. Division 43 covers the building structure (slab, framing, roofing, brickwork, fixed cabinetry) — deductible at 2.5% per year over 40 years from construction completion, provided the property was built after 17 July 1985. Division 40 covers removable items (carpet, blinds, hot water, appliances, light fittings, air con) — each with its own effective life on diminishing-value or prime-cost method. As of the 2017 tax law changes, second-hand Division 40 items in established property purchased after 9 May 2017 are no longer depreciable by the new owner — only Division 43 carries through, and only new Division 40 items installed after acquisition.
Repair vs capital improvement. The single biggest ATO compliance focus area for landlords in 2026. Repairs (restoring to prior working condition — broken hinge, leaking tap, patching plaster) are immediately deductible. Capital improvements (extending useful life, upgrading capability, replacing an entire item) must be capitalised and depreciated. Replacing 4 broken roof tiles is a repair (deductible). Replacing the entire roof is capital (depreciated over 25 years). Same-spec kitchen replacement is grey trending capital. Upgraded-spec kitchen is always capital. Our Capital Improvement vs Repair Tax guide covers the framework in detail.
Initial repairs (the trap). If you buy a property and immediately repair pre-existing issues — a fence already broken at settlement — the ATO classifies these as initial repairs and they are NOT deductible. They are added to the cost base for CGT purposes. Defer non-urgent repairs to at least 12 months post-settlement to preserve deductibility.
Borrowing costs. Loan application fees, LMI, lender's legals, and title search costs are deductible over the life of the loan or 5 years, whichever is shorter — roughly $400-$700 per year on a $640,000 investor loan.
Travel. No longer deductible since 2017 for residential rental property. Only travel by a registered property manager counts.
The practical implication: every dollar of correctly-claimed deduction at the 30% marginal rate is worth 30 cents of after-tax cash. The ATO compliance program is targeting rental property deductions in 2026 — get a registered property-specialist tax agent and a quantity surveyor depreciation schedule before you file your first return.
Bringing it all together — the OptimaRea acquisition framework
Pulling the threads together, here is the 5-step framework OptimaRea uses with clients evaluating a Melbourne investment property in 2026:
Step 1 — Run the 9-line worksheet on realistic 2026 numbers. Use 6.30% interest (not the 5.99% headline), realistic rent from SQM Research comparables (not the advertised rent), the actual SRO land tax bracket for your portfolio (not the standalone figure), 4.90% PM fees if you are with OptimaRea — assume 6%+ for industry-typical pricing. Most off-the-plan marketing models we have seen understate annual holding costs by $4,000-$8,000.
Step 2 — Layer in the tax position honestly. Get a quantity surveyor depreciation schedule (~$700 one-off). Apply your real marginal tax rate, not the top marginal rate — most landlord-investors are at the 30-37% bracket, not 47%. The negative gearing tax shield on a typical Melbourne investment property in 2026 sits at $2,500-$4,500 per year at the 30-37% brackets — meaningful but not transformative.
Step 3 — Apply a defensible capital growth assumption. 5-6% per annum across a 10-year hold is the OptimaRea house view for established Melbourne suburbs in the $700K-$1.1M range. Apartments closer to 4-5%. Off-the-plan tower stock in oversupplied precincts: 2-4% historically. Get suburb-specific data from CoreLogic and the Domain quarterly house price report before plugging a number.
Step 4 — Stress-test against rate moves and vacancy events. What does cashflow look like at 7.5% interest (credible if the RBA tightens in 2026-2027)? With 6 weeks of vacancy in a year? With a $12,000 hot water + roof + electrical event in year 3? If the model only works on the optimistic case, do not buy.
Step 5 — Match management workflow to structure. A standard long-term residential let is easy. A dual-living configuration needs a manager who can handle two tenancies on one title. A rooming house needs registered operator compliance under the Residential Tenancies Act. OptimaRea handles all three under one fee structure but the workflow complexity differs materially — and that operational complexity is what creates real cashflow risk for self-managed landlords.
The core message: investment property cashflow modelling in 2026 Melbourne is harder than in 2018 because rates are higher, holding costs are higher (land tax especially), and headline yields look thinner. The math still works for the right property at the right purchase price with realistic assumptions and a 10-year hold horizon — but only if you do the worksheet honestly before you sign, not after.
If you would like OptimaRea to run the 9-line worksheet on a property you are evaluating, coordinate a quantity surveyor depreciation schedule, or review the cashflow position on your existing portfolio, call us on (03) 9000 0000 or email management@optimarea.com.au.