← Back to blog

How to Model Retirement in Australia, Step by Step

Australian man mapping retirement cash flow

To model retirement in Australia, build a year-by-year projection of your assets, income and spending from today to about age 95. Then change one assumption at a time and watch what moves. A good model tells you three things: the age you can stop work, the income you can draw, and how much your net worth is exposed to a bad run of returns, inflation or policy change.

This guide walks through the process in order. It covers the inputs, the Australian rules that make our models different from overseas ones, and the tests that separate a plan from a hopeful guess.

Aerowealth
See How Your Retirement Choices Compare
Model Australian retirement income, super, property and mortgages, then compare scenarios and stress-test how different decisions affect your future.
Explore retirement modelling

TL;DR

  • Build a yearly cash flow from now to about age 95. Include super, investments, property, debt, the Age Pension and tax in one plan, not in separate calculators.
  • Australian rules drive the result: preservation age (60 if you were born from 1 July 1964), Age Pension age (67), and the Age Pension income and assets tests.
  • Run what-if scenarios side by side, then stress-test returns, inflation, retirement age and spending. Sensitivity tells you which assumption matters most.
  • Treat minimum super drawdown rates as a legal floor, not a spending plan.
  • Revisit the model every year. If your situation is complex, take the result to a licensed adviser.

Table of Contents

What a retirement model actually is

A retirement model is a simulation of your money over time. Each year it adds income and growth, subtracts spending, tax and debt repayments, and carries the balance forward. The output is a line: your net worth, year by year, and the age at which it runs out or settles.

That is different from a retirement calculator that tells you one “number you need”. A calculator answers one question once. A model lets you ask the next question: what if I retire at 58, not 62? What if the investment property is sold at 65? What if returns are weak for the first five years?

It helps to split the job into two halves:

  1. Accumulation: how much you will have at the date you stop work.
  2. Decumulation: how that money turns into income, and how long it lasts.

Most people spend their effort on the first half. The second half is where Australian rules get interesting, and where the Treasury’s Retirement Income Review points to a common problem: retirees are often overly cautious about spending their super, treating it as a nest egg to preserve instead of a resource to use.

Step 1: Gather the inputs

You cannot model what you have not listed. Start with a plain inventory:

  • Super: balance, fund, investment option, your contributions and your employer’s.
  • Outside super: shares, ETFs, cash and term deposits.
  • Property: your home, plus any investment property with its value, loan, rent, and running costs.
  • Debts: mortgage balance, rate, repayment and any offset account.
  • Income: salary now, expected change, partner’s income.
  • Spending: what you spend today, split into essentials and discretionary.

Spending is the input people get wrong most often. Use real bank and card data for the last twelve months, not a guess. Then adjust for retirement: commuting and work clothes fall away, while health and travel may rise. Our guide to budgeting in retirement covers how to build that number.

For a sanity check, the Moneysmart booklet Financial Decisions at Retirement quotes the ASFA Retirement Standard. As of March 2018, a single homeowner needed $42,764 a year for a comfortable lifestyle and a couple $60,264. Those figures are dated and inflation has pushed today’s numbers well above them, so use them only to see the shape of the gap between modest and comfortable, then find the current ASFA update before you set a target.

Step 2: Set your modelling assumptions

Assumptions are the engine of any projection. Write each one down, and give it a base case, a bad case and a good case.

Assumption Why it matters Test range to try
Investment return (after fees and tax) Compounds over decades Base case, 1 to 2 points lower, and a poor first five years
Inflation Erodes spending power Base case and a higher case
Retirement age Changes both savings years and drawdown years Your target, two years earlier, two years later
Spending in retirement Largest driver of drawdown Essentials only, and full lifestyle
Longevity The plan must outlast you Model to 90, 95 and 100
Property growth and rent Drives net worth if you invest in property Flat, base, strong
Policy and tax settings Rules change Current law, plus announced changes

Two habits keep assumptions honest. First, work in real (today’s) dollars so you can read the result against your current budget. Second, never use one return figure for every year. A fixed average hides sequence risk, which is the danger of poor returns arriving just as you start drawing down.

Step 3: Map your cash flow year by year

Retirement cash flow modelling means tracking where each dollar of income comes from, and which pot pays for each dollar of spending, every year.

A simple order of operations for each year:

  1. Start with opening balances for each asset.
  2. Add income: salary until you stop, then super pension payments, rent, dividends, interest and any Age Pension.
  3. Subtract spending, debt repayments, and tax.
  4. Apply growth to each asset.
  5. Record closing balances and carry them forward.

A spreadsheet can do this, but it gets fragile fast. Once you add a second property, an offset account, a partner and two tax regimes (inside and outside super), one wrong cell reference quietly breaks the plan. That is the reason we built Aerowealth to keep super, property, ETFs, mortgages and contributions in one plan.

Step 4: Get the Australian rules into the model

Overseas retirement calculators miss the rules that shape most Australian outcomes. Four matter most.

Preservation age and the bridge years

You generally cannot touch super until you meet a condition of release. The ATO says preservation age is 60 for anyone born from 1 July 1964. Reaching it and retiring is one route, and turning 65 is another. Age Pension age is currently 67.

If you want to stop work before 60, you have a bridge: the years where you must fund life from money outside super, such as shares, ETFs, offset savings or rent. Model it explicitly. The question is whether your outside-super assets can carry you to preservation age without being drained, and what your super is worth by then. We cover the rules in more depth in what Australians approaching 60 need to know about preservation age.

Timeline of super access and pension ages

The Age Pension tests

The Age Pension is means tested, so it is not a guaranteed top-up. Services Australia applies an income test and an assets test, and you are paid under whichever gives the lower result. Per its assets test page, as of 20 September 2026 the full-pension asset limit for a single homeowner is $333,000 and for a couple combined $499,000. Payments cancel entirely at $745,750 for a single homeowner and $1,121,000 for a couple.

These thresholds are reviewed several times a year, so check the current page rather than hard-coding a number. Our explainers on the assets test and the income test show how each one bites.

The modelling lesson: spending down assets can raise your pension. If you draw super hard in your early sixties to fund the gap years, your assessable assets at 67 are lower, and the pension you qualify for may be higher. Moneysmart’s guidance on super and the Age Pension makes the same point: balance early super use against its effect on later assessments.

Drawdown rules

Once super moves into an account-based pension, a minimum amount must be paid out each year. Moneysmart explains that these minimum drawdown rates are a regulatory threshold, not advice, and you can take more. Many retirees default to the minimum and live below the standard they could afford. Model a few spending levels, not just the minimum.

Tax, including property changes

Tax inside and outside super differs, so the same dollar of growth ends up in different places. If you hold an investment property, rules are changing. The ATO states that from 1 July 2027 the 50% CGT discount is replaced by cost base indexation with a 30% minimum tax rate on capital gains, and the measures are now law. If your plan includes selling a property in retirement, run it under both sets of rules and compare the after-tax proceeds. Build realistic running costs into the property too, such as rental maintenance costs, because a rent figure without upkeep flatters the result.

Step 5: Run what-if scenarios

A what-if analysis changes a decision, not just a number. Build each scenario as a named copy of your base plan and change only what the decision changes.

Useful scenarios for Australians:

  • Retire at 58, 60 or 63: how much does each extra working year add to super and subtract from drawdown years?
  • Extra super contributions now versus paying down the mortgage: which leaves you better off at retirement?
  • Keep or sell the investment property at 65: compare rental income against sale proceeds invested elsewhere, after CGT.
  • Offset account strategy: hold savings in offset, or invest the difference?
  • Downsize at 70: how much cash is released and what does it do to Age Pension eligibility?

Place scenarios side by side. Seeing three plans on one screen, with retirement age, income and net worth in each, beats toggling between tabs and trusting your memory.

If a mortgage will follow you past your last pay day, see our walkthrough of three ways to model a mortgage in retirement.

Step 6: Stress-test and run sensitivity analysis

A what-if compares choices. A sensitivity analysis tests assumptions. Both are needed.

For sensitivity, move one input at a time and record the change in your outcome, such as the age your money runs out or your net worth at 85. A typical result looks like this: a one-point drop in returns hurts more than a two-year delay in retirement, but spending 10% less hurts less than either. Your own ranking will differ, and the ranking is the useful part. It tells you where to spend your attention.

For stress tests, combine bad things at once:

  • Weak markets in the first five years of retirement.
  • Higher inflation for a decade.
  • Spending that creeps up for health or aged care.
  • A property that is vacant for six months or sells below expectations.
  • A rule change that reduces a benefit you were counting on.

The Treasury’s modelling background stresses that Australian outcomes depend on the interaction of super drawdown, the pension tests and the bridge years before 67. Test those interactions together, not alone. A plan that survives a hard stress test is one you can follow when markets are frightening.

Step 7: Read the result and decide

Look at four outputs:

  1. Earliest sustainable retirement age under the base case.
  2. Retirement income each year, split by source.
  3. Net worth over time, including the bridge years.
  4. How the plan behaves under stress: does it bend or break?

If the plan fails, the levers are few: work longer, spend less, contribute more, change how assets are held, or accept a lower safety margin. Change one lever at a time in the model and see how much each buys.

Then put a date in your calendar. Retirement models go stale. Update balances, rules and assumptions at least once a year.

Our perspective: models should show trade-offs, not promise answers

We built Aerowealth because we saw how Australians were modelling retirement: a super calculator here, a property spreadsheet there, a mortgage tool somewhere else, with no view of how the pieces affect each other. The decisions that matter most sit between the pieces. Do you draw super or sell ETFs in the bridge years? Does the offset account beat extra contributions? What does retiring two years earlier really cost?

Our perspective: models should show trade-offs, not promise answers — overview diagram

We think the right output is not a single verdict, but a set of side-by-side futures with the assumptions visible, so you can see why a plan works and what would break it. That is why we focus on scenario comparison, stress testing, bridge-year modelling for early retirement, and tax and CGT impacts under Australian rules, with an AI assistant that explains the projections in plain language.

A model is a decision aid. It does not know your health, your family or your appetite for risk. For advice on your specific circumstances, speak to a licensed financial adviser.

— Aerowealth Team

Try the model yourself

If you want to build this plan without wrestling a spreadsheet, Aerowealth lets you model super, investment property, ETFs, mortgages and contributions together and compare scenarios side by side. There is a free plan to start with, and Pro is 7 AUD per month for expanded scenario planning, bridge mode for early retirement, advanced mortgage features and a higher AI assistant quota. See both on the pricing page.

FAQ

How much do I need to retire in Australia?

It depends on the lifestyle you choose and whether you own your home. The ASFA Retirement Standard sets benchmarks for modest and comfortable lifestyles, and Moneysmart’s booklet reproduces the 2018 figures. Those are dated, so check the latest ASFA update and then test your own spending in a model.

Can I retire before preservation age?

Yes, but you need to fund the years before you can access super from money held outside it. Preservation age is 60 for anyone born from 1 July 1964, per the ATO. Model those bridge years separately and check that your outside-super assets last.

Will I get the Age Pension?

Maybe. Eligibility depends on both the income and assets tests, and the lower result applies. Run your numbers against the current Services Australia thresholds and re-run them when thresholds update.

Is a spreadsheet good enough to model retirement?

For a simple plan, yes. Once you add property, a mortgage, a partner and tax inside and outside super, errors become easy and scenario comparison gets slow. Purpose-built software handles those interactions in one place.

Sources

← Back to blog