Introduction: why AU cashflow modelling differs from NZ
Australian investors often inherit frameworks from generic property calculators or from New Zealand/US content that does not map neatly to local lending and tax realities. The biggest differences are practical: rent is usually discussed weekly, tax outcomes can materially shift apparent affordability through negative gearing, and serviceability is assessed under APRA-influenced stress assumptions that are deliberately above your contract rate. A property that appears neutral at the contract repayment can still be a strain in lender assessment models.
Another key difference is cost heterogeneity by state. Land tax, transfer duties, insurance costs, and management norms vary enough between NSW, QLD, VIC, and other states that “national average” assumptions can be misleading for first-year cashflow. Good modelling therefore requires a localised lens: one set of assumptions for Brisbane is not automatically valid for Sydney, Melbourne, or Perth.
In this guide, we model from first principles: gross rent, vacancy allowance, operating expenses, finance costs, tax interactions, and stress-rate checks. The goal is not to produce one perfect number. The goal is to produce a robust range that survives uncertainty and lets you decide whether a purchase improves or weakens your portfolio trajectory.
The core components of property cashflow
Start with gross rental income. In Australia this is typically quoted weekly, so annual gross rent is weekly rent multiplied by 52. Then deduct vacancy provisioning. Even in tight rental markets, a non-zero vacancy assumption is prudent because turnover, reletting lag, and maintenance periods happen. Many investors model 2% to 4% vacancy, then test a downside case at 5% or higher.
Next deduct operating costs: property management fees, council rates, landlord insurance, repairs and maintenance, water charges where relevant, and strata/body corporate for units. For first-year models, include one-off setup or compliance costs separately so you do not blur ongoing operating performance with acquisition friction.
Financing cost is usually the largest single line item. Model interest using your actual loan structure (P&I or IO), then build a stress-rate version that is at least 3% above contract as a serviceability proxy. Do not treat this as “just for the bank.” If the stress case is deeply negative, your resilience to refinancing or rate volatility is weak even if today’s headline rate looks manageable.
Finally, consider depreciation and tax treatment for after-tax analysis. Depreciation is non-cash but can alter taxable income, which affects net household cash outcomes. Keep pre-tax and after-tax cashflow side by side so you do not accidentally treat a tax benefit as operating profitability.
Negative gearing explained: pre-tax vs after-tax reality
Negative gearing means deductible property expenses (including interest and allowable deductions) exceed rental income, creating a tax loss that can offset other taxable income. This can improve after-tax household cashflow even when the property is pre-tax cashflow negative. The mechanics matter because many investors either overstate or understate the effect.
Suppose a property is pre-tax negative by A$9,000 annually and the investor’s marginal tax rate (including Medicare implications where relevant) implies an effective relief rate around 34.5%. The tax effect might recover roughly A$3,105, leaving after-tax negative cashflow of around A$5,895. That is still negative, but materially less so than pre-tax cashflow alone suggests.
The risk is narrative drift: “it’s negatively geared” is not a strategy by itself. You still need to carry the net cash burn, and tax outcomes are received through returns/timing rather than monthly rent cycles. If your household buffer is thin, tax relief can be too delayed to solve short-term cash stress. This is why pre-tax and after-tax views must be tracked in parallel rather than replacing one with the other.
For portfolio-level decisions, negative gearing can be reasonable when it buys durable long-term growth at acceptable risk and when your cash reserves can absorb downside cases. It is dangerous when used to justify fragile debt loads, optimistic rent assumptions, or speculative capital growth dependencies.
APRA's 3% serviceability buffer and borrowing capacity
APRA guidance has reinforced that lenders should assess serviceability with a meaningful buffer over contract rates, commonly around 3 percentage points. If your loan rate is 6.1%, the assessment rate may be around 9.1%. This can materially compress borrowing capacity even when your current cashflow appears healthy.
In practice, lenders combine this with income shading and expense assumptions to produce a conservative repayment capacity estimate. Investors often experience this as a disconnect: “the property pays for itself at current rates, but the bank still says no.” That is not inconsistency; it is deliberate policy design aimed at resilience through rate cycles.
For planning, build three repayment views: current rate, +2%, and +3%. The +3% case aligns closely with bank-style stress assumptions and gives you a realistic risk envelope. If a purchase only survives at current rate and fails badly under +3%, your execution risk is high even before considering vacancy or unexpected capex.
A useful worked serviceability shortcut is to model the loan as if it had to carry itself at the assessment rate. On a A$600,000 loan, moving from a 6.1% interest assumption to a 9.1% assessment assumption adds roughly A$18,000 per year of interest-only burden before any principal component is considered. That does not mean you will pay that amount today, but it shows why lender capacity can fall sharply when assessment rates rise. Investors who only test the contract rate often interpret the bank's answer as conservative; in reality, the bank is asking whether the household could still carry the portfolio through a rate shock.
This is also why income quality matters. PAYG salary is usually easier to evidence than casual, commission, trust, or self-employed income. Rent is normally shaded. Credit card limits and personal loans can reduce capacity even if the monthly balance looks harmless. A complete cashflow model should therefore include two lenses: actual household cashflow after the purchase, and lender-style serviceability pressure. The deal needs to make sense under both, not just one.
Worked example: Brisbane 3-bed house at A$720k
Assume purchase price A$720,000, deposit 20%, loan A$576,000. Gross rent A$730/week (A$37,960 annually). Vacancy allowance 3% reduces effective rent to roughly A$36,821. Management at 7% of collected rent is about A$2,578. Add rates (A$2,400), insurance (A$1,400), maintenance reserve (A$2,000), and miscellaneous compliance (A$900). Operating costs before finance total around A$9,278.
Net operating income before interest is therefore about A$27,543. At a contract interest assumption near 6.2% interest-only, annual interest is roughly A$35,712, giving pre-tax cashflow around negative A$8,169 before depreciation and tax effects. At a stress-rate scenario near 9.2%, annual interest equivalent would be far higher, pushing pre-tax negativity deeper and potentially affecting serviceability confidence.
If depreciation and deductible expenses support tax relief, after-tax outcome may improve but still likely remain negative. The decision then becomes strategic: is the expected growth profile and portfolio fit worth the carry cost? If yes, ensure liquidity buffer can absorb downside cases (higher vacancy, rent softness, maintenance spikes) without forcing distressed decisions.
This example is intentionally conservative. If your rent is stronger, costs lower, or debt smaller, the profile improves. The critical point is methodology: annualise everything, include non-obvious costs, run stress-rate checks, then decide with both pre-tax and after-tax views visible.
Worked example: Sydney 2-bed unit at A$850k
Assume purchase price A$850,000, deposit 20%, loan A$680,000. Rent A$930/week (A$48,360 annually). Vacancy allowance 2.5% gives effective rent around A$47,151. Management at 6.5% is about A$3,065. Add strata/body corporate (A$6,800), council/water (A$2,800), insurance (A$1,100), maintenance reserve (A$1,500), and incidental recurring costs (A$1,000). Non-finance costs total roughly A$16,265.
NOI before interest is then around A$30,886. At 6.2% interest-only, annual interest is about A$42,160, creating pre-tax cashflow near negative A$11,274. Sydney unit economics often hinge on strata depth and purchase basis; if strata rises or rent weakens, negative carry can widen quickly.
Under a +3% stress lens, the financing burden increases materially, and serviceability buffers tighten further. This does not mean the deal is automatically poor. It means your decision should explicitly recognise that income carry and balance-sheet resilience, not just headline yield, determine whether the asset is manageable across rate cycles.
Comparing this to the Brisbane scenario shows why identical modelling templates cannot be copied blindly between states or property types. The structure of recurring costs and rent-to-price ratio changes the quality of cashflow even before tax treatment is considered.
State-by-state notes: land tax, stamp duty, first-year drag
State settings can dominate first-year economics. NSW and VIC have distinct duty and land-tax frameworks versus QLD, SA, and WA. Investors should treat acquisition costs as capital deployment realities, not background noise. A property with slightly better ongoing yield can still underperform if acquisition friction is substantially higher and pushes effective entry basis up.
Land tax thresholds and aggregation rules vary, so portfolio-level holdings can trigger liabilities that a single-property calculation misses. The implication is simple: model at portfolio level where possible, not deal-by-deal in isolation. A “good” standalone purchase can become a weaker portfolio move when state tax interactions are accounted for.
Insurance and compliance costs also vary by geography and asset class. Flood, strata defects, and building-specific issues can materially alter annual run-rate assumptions. Build a first-year conservative estimate, then a normalized-year estimate, and compare both.
Queensland investors should pay close attention to insurance, council rates, and flood-related risk at suburb level. A Brisbane house can look attractive on land content and rent growth, but insurance variance between postcodes can change annual cashflow materially. New South Wales buyers often need to model higher entry friction and strata depth carefully, especially for apartments where special levies can be lumpy. Victorian investors should be especially deliberate with land-tax assumptions because policy changes have made portfolio-level carrying costs more visible. Western Australia and South Australia may offer different yield profiles, but investors still need to test vacancy and maintenance rather than assuming stronger gross yield flows straight to net cashflow.
For first-year planning, separate acquisition costs from recurring performance. Stamp duty, conveyancing, inspections, buyer's agent fees, and initial repairs should sit in a “cash required to settle and stabilise” bucket. Recurring rent, vacancy, management, rates, insurance, repairs, land tax, strata, and interest should sit in the operating model. Mixing these together makes the property look worse in year one and then artificially better in later years. Separating them gives you a cleaner answer to two different questions: “Can I afford to buy it?” and “Can I afford to hold it?”
Why stress-testing rates is non-negotiable
APRA-style stress assumptions exist because rate regimes change. Investors who model only at headline rates are effectively underwriting the deal to one point in time. A robust investment case should still be manageable if refinancing is less favourable, fixed terms roll off into higher variable rates, or rental growth pauses.
A practical method is to run three scenarios in your model: base, moderate stress (+2%), and APRA-aligned stress (+3%). For each scenario, track pre-tax cashflow, after-tax cashflow estimate, and liquidity runway. If any scenario implies untenable negative carry without clear mitigation, adjust price, debt, or timing before committing.
Stress-testing should also include time, not just rate. A six-month vacancy or repair period is a different risk from a permanent interest-rate rise, but both draw from the same household buffer. Add a simple liquidity runway line: available offset/cash divided by monthly negative cashflow in the downside case. If the answer is only a few months, the investment may be too brittle even if the long-run spreadsheet looks fine.
How to model this in Stackhold
Start with the cashflow calculator to validate assumptions quickly. Then move the deal into Stackhold when you want portfolio-level context: borrowing constraints, existing assets, personal income/expenses, and next-purchase timing in one model. This keeps your decision framework consistent across properties instead of creating isolated spreadsheets that drift over time.
FAQ
Should I model rent weekly or monthly?
Use weekly as input if that is how your market quotes rent, then annualise for consistency across costs and financing.
Is negative gearing enough to justify negative cashflow?
No. It can reduce after-tax drag but does not remove risk. Always assess your ability to carry the property in downside scenarios.
Do I need to include depreciation in every model?
For investment decisions, yes: include it in after-tax views, but keep pre-tax cashflow visible so operating performance is clear.
How conservative should vacancy assumptions be?
At least 2% to 4% for baseline planning, with a downside case higher than that for risk testing.
What is the biggest modelling mistake?
Comparing properties on headline yield without normalising for full costs, tax treatment timing, and stress-rate resilience.
Should principal repayments count as an expense?
For household cashflow, yes, because the money leaves your bank account. For investment performance, separate principal from interest because principal reduction builds equity while interest is a true financing cost. Keeping both views avoids confusing cash pressure with economic return.
How much buffer should I keep after settlement?
There is no universal number, but many investors model at least three to six months of downside cashflow plus a repair allowance. Larger or older portfolios usually need more because multiple small problems can overlap.