Queensland only
SMSF commercial property acquisition calculator
Estimate the cash required to buy a Queensland commercial property and explore its cash flow under different borrowing, cost and vacancy assumptions.
A general property cash flow illustration. It does not assess investment suitability, SMSF eligibility or loan approval, and it is not financial, tax or legal advice.
Results withheld
Some inputs are blank or invalid. Correct the highlighted fields to see results. Figures are withheld rather than calculated on assumed values.
Cash required at settlement
Provisional: excludes any purchase GST
SMSF cash at settlement
$0
Price, GST, duty and upfront costs, less the loan.
Funding at settlement
Year one cash flow, before income tax
Before income tax. Excludes depreciation, capital gains tax, growth and any sale. Principal repayments and capital expenditure are not treated as tax deductions.
Annual cash flow: first 10 years
Twelve-month periods from acquisition, before income tax, based on the current inputs. Bracketed figures are cash paid out.
| Year | Rent collected | Holding costs | Interest | Principal | Cash flow before contributions | Cash flow after contributions and outflows | Loan balance at year end |
|---|
Save your scenario
Print or save a PDF with your inputs, results, 10-year cash flow, date and sources. Your figures stay in this browser. They are not stored, added to the page address or sent to analytics. The enquiry form below does not include them; your contact details are sent only if you submit it.
How this is calculated
Queensland transfer duty
General rates on the higher of the price plus any purchase GST, or the higher dutiable value entered: nil to $5,000; $1.50 per $100 or part above $5,000 to $75,000; $1,050 plus $3.50 per $100 or part above $75,000 to $540,000; $17,325 plus $4.50 per $100 or part above $540,000 to $1,000,000; and $38,025 plus $5.75 per $100 or part above $1,000,000. No residential or other concession is applied. While GST is not yet confirmed, duty excludes GST and is provisional. A manual override replaces the automatic figure everywhere.
Loan and settlement cash
Loan = LVR × the lower of the price excluding GST and the valuation. Settlement cash = price + purchase GST + duty + upfront costs − loan. Cash left = available liquid cash − settlement cash, shown as a negative where the fund is short. Reserve shortfall = the reserve less cash left, where positive. Any later GST refund is conditional future cash and is never used to fund settlement.
Income
Rent collected = base rent × (1 − vacancy months ÷ 12). Net operating income = rent collected − owner costs − extra vacancy costs, which apply only when vacancy is above 0. Net yield = net operating income ÷ price, adjusted for vacancy, before finance, fund costs and capital expenditure.
Debt service
The term in months is the term in years × 12, rounded to the nearest whole month, with a minimum of one month. Principal and interest uses a fixed monthly payment at the annual rate ÷ 12; at 0% the payment is the loan ÷ months. The final payment is capped at the exact outstanding principal plus interest, and the balance carries continuously across all 120 months, so the loan never goes below zero and there are no payments after maturity. Interest only charges monthly interest on the full principal, which is repaid in full in the maturity month. No refinance or extension is assumed. Year one figures are the first 12 months of this schedule.
Cash flow
Before contributions = net operating income − debt service − SMSF admin and audit − capital expenditure allowance. After contributions = that figure + net contributions − allocated outflows. All figures are before income tax.
Ten-year cash flow
Each year is a 12-month period from acquisition. Rent collected = base rent × (1 + rent growth)year − 1 × (1 − vacancy months ÷ 12). Holding costs = (owner costs after recoveries + extra vacancy costs, where vacancy is above 0 + SMSF admin and audit + capital expenditure allowance) × (1 + holding cost growth)year − 1. Cash flow before contributions = rent collected − holding costs − interest − principal. After contributions adds net contributions and deducts allocated outflows. Vacancy months, the interest rate, contributions and outflows stay constant in every year. Purchase price, GST, duty, upfront costs and any later GST refund are excluded. The figures are not a total investment return or a whole-fund balance, and the 10-year total does not include loan balances.
Not modelled
- Income tax, depreciation, capital gains tax, growth and sale.
- Business real property status, the fund’s investment strategy, related-party rules, contribution caps or eligibility, and lender approval.
- Financing of GST or costs, lender fees beyond those entered, and any concession, exemption, surcharge or landholder duty.
Sources, checked 16 October 2026
- Queensland Revenue Office, transfer duty rates: qro.qld.gov.au/duties/transfer-duty/calculate/rates/
- Queensland Revenue Office, how to calculate transfer duty: qro.qld.gov.au/duties/transfer-duty/calculate/how-to-calculate/
- Australian Taxation Office, changes to limited recourse borrowing arrangements: ato.gov.au, changes to limited recourse borrowing arrangements
- ASIC Moneysmart, SMSFs and property: moneysmart.gov.au/property-investment/smsfs-and-property
- Australian Taxation Office, selling commercial premises (GST): ato.gov.au, selling commercial premises
What happens next?
Nick will discuss your property requirements, timing and how Represent Commercial can help with the search, commercial assessment and negotiation. Before you decide to appoint, you will understand the proposed scope and fees.
Nick will respond within one business day.
Your SMSF structure, tax position and borrowing arrangements should be confirmed with your accountant, licensed financial adviser and lender.
This calculator is a general property cash flow illustration for Queensland commercial property only. It does not assess investment suitability, SMSF compliance, business real property status, contribution eligibility or loan approval, and it is not financial, tax, legal or credit advice. Figures depend entirely on the assumptions entered. Transfer duty uses Queensland general rates without concessions and should be confirmed with your solicitor or the Queensland Revenue Office. Seek advice from a licensed financial adviser, an SMSF accountant, a solicitor and your lender before committing. Represent Commercial. Real Estate Agent Licence 4949809.