Build an annual property ledger

Gross yield, net yield and cash flow answer different questions

Gross rental yield divides scheduled annual rent by the purchase price. Scheduled rent is weekly rent multiplied by 52. This quick market measure makes listings easier to compare, but it assumes a full year’s rent and ignores every expense.

The calculator’s effective net operating yield is more demanding. It subtracts vacant weeks from rent, deducts management and entered property operating costs, and divides the resulting net operating income by purchase price plus buying costs. It excludes finance so two buyers can compare the property’s operations before their different deposits and loans.

Cash flow before tax takes the next step by subtracting annual loan payments from net operating income. For an interest-only scenario, debt service equals loan balance multiplied by the entered annual rate. For principal and interest, it uses an amortising monthly payment over the remaining term.

Principal repayment reduces debt and may build equity, so cash flow and profit are not identical. The entire principal-and-interest payment still has to leave the household bank account, which is why it belongs in a cash-flow test. Tax treatment is separate and is not inferred from these accounting labels.

Model vacancy as a recurring risk, not a rare surprise

A property advertised at $650 per week does not automatically collect $33,800 each year. Tenant changeovers, repairs, marketing, deliberate rent-free periods and arrears can reduce receipts. Three vacant weeks changes scheduled rent to 49 paid weeks before fees.

Use local, property-type evidence instead of a national vacancy guess. Compare multiple reputable rental reports, recent listings and actual days on market. Ask a property manager for an evidence-based rent appraisal and how often comparable properties turn over.

Vacancy and achievable rent interact. A high asking price can increase unoccupied time, while a modest reduction can sometimes improve annual collected rent. Test lower rent with fewer vacant weeks and higher rent with more vacancy rather than assuming the most favourable combination.

Short-stay accommodation needs a different model. Nightly rates, platform fees, cleaning, utilities, furnishing, seasonal occupancy, regulation and active management are not represented by a standard weekly tenancy. Use verified monthly occupancy and all incremental costs.

Include costs that do not appear in the listing

Buying costs reduce return even though many are paid only once. Enter transfer duty, conveyancing, searches, reports and acquisition fees actually expected. Sale costs are excluded from the annual yield but matter to the total investment return and minimum holding period.

Do not enter deductible amounts net of an assumed tax refund. Expenses must be paid in cash, and deductibility, timing and ownership depend on current law and facts. Keep the operating model pre-tax so the property itself remains visible.

Test the finance structure independently from property yield

A property can have the same gross and net operating yield for two owners but very different cash flow because one borrows more. The cash-invested output equals purchase price plus buying costs minus the entered loan. Cash-on-cash return divides pre-tax annual cash flow by that amount when it is positive.

If the loan exceeds acquisition cost, cash-on-cash is not shown because the simple acquisition interpretation breaks down. Refinancing, equity release and cross-collateralisation need a whole-portfolio model. The property may also secure debt used for another purpose, which changes tax and risk analysis.

An interest-only choice lowers current required payments because principal is not repaid. Moneysmart warns that the interest-only period ends, after which repayments increase to cover principal and interest. Model the later remaining term and a higher rate before relying on early cash flow.

Interest rates can rise while rent remains flat or a property is vacant. Rerun the calculator at several higher rates. Also reduce rent and add a major repair in the same scenario; isolated stress tests can understate the effect of several problems occurring together.

Why this calculator does not estimate rental property tax

The Australian Taxation Office requires rental and rental-related income to be declared according to ownership. Deduction treatment varies: some expenses may be immediately deductible, some may be claimed over time, some form part of the cost base, and private or capital amounts can be excluded or apportioned.

Loan interest treatment follows use of borrowed funds, not simply which property secures the loan. Principal repayments are not interest deductions. Repairs can be treated differently from improvements or initial repairs. Depreciating assets and capital works have separate rules and eligibility.

Negative cash flow is not a tax result. Principal repayment, non-deductible costs, depreciation, income allocation and an owner’s marginal circumstances all create differences. A “tax refund” should not be added to rent without a current calculation based on complete facts.

The ATO says a property must be rented or genuinely available for rent for related expense deductions, subject to the detailed rules. Non-commercial arrangements, private use and periods unavailable can affect claims. Use current ATO guidance and a registered tax agent when appropriate.

Keep leases, agent statements, bank records, invoices, loan documents and evidence of property availability. Record income gross before expenses withheld by the property manager. Retain acquisition, improvement and sale records needed for future capital gains calculations.

Investigate the asset behind the spreadsheet

Yield is not a substitute for due diligence. Research title, zoning, planning changes, building condition, flood, bushfire, coastal, contamination and insurance availability. Review strata records, defect reports, litigation and planned capital works for apartments.

Compare the proposed rent with genuinely similar properties by location, bedrooms, parking, condition and amenities. A vendor’s rental guarantee may be funded through an inflated price or expire before the market supports it. Value the property and rent independently of a promoter.

Consider concentration risk. A household already exposed to Australian residential property through its home, employment and mortgage may gain less diversification from another nearby property than the asset label suggests. Property is illiquid; a bedroom cannot be sold to fund an urgent bill.

Capital growth is deliberately absent from the calculator. Future value is uncertain, local and sensitive to holding period and transaction costs. If testing growth, run a range that includes falls, and subtract selling fees, legal costs and relevant tax before comparing alternatives.

Use four scenarios before making an offer

Start with a base case using a conservative rent appraisal, normal vacancy, actual management quote, ownership notices and inspected maintenance allowance. Then create a vacancy case with no rent for a longer period plus reletting costs.

Create an interest-rate case using the expected later principal-and-interest payment and a higher rate. Finally, create a repair case with a realistic one-off building, appliance or strata cost. Save inputs and outputs for each scenario rather than remembering only the best yield.

Compare the monthly cash contribution with household income after other commitments. Maintain an emergency reserve for the property and personal needs. Insurance can transfer selected risks but policies have limits, exclusions, waiting periods and excesses.

After purchase, replace assumptions with actual figures every month. Reconcile gross rent, fees and bills, then review rolling twelve-month yield. A lower result may identify excessive vacancy, deferred maintenance or a budget error early enough to respond.

Understand the break-even weekly rent output

The break-even output estimates the weekly asking rent required for collected rent after vacancy and percentage management fees to cover entered operating costs and debt service. It divides those costs by occupied weeks and by one minus the management rate.

This is a mathematical threshold, not evidence that the market will pay that amount. If break-even rent is well above comparable properties, the investment depends on household contributions, lower costs, lower debt or an uncertain future change. Do not simply replace market rent with break-even rent.

The output excludes tax, capital spending beyond the repair allowance and sale costs. It also assumes every occupied week is paid. Use it to expose the gap between market income and the chosen finance structure.