Australian Couples Retirement Planner Spreadsheet | Super, Age Pension, Division 296 Calculator | Excel and Google Sheets 2026-27

Plan retirement as a couple, the Australian way. One workbook models two people's super year by year for 40 years, with the Age Pension means tests, Division 296 tax on large balances, spending, contributions and market risk, all using the rules from 1 July 2026.

WHAT YOU GET

• Planner: Example (filled in for a sample couple) and Planner: Blank (ready for you)
• Excel workbook (.xlsx), no macros
• A Google Sheets copy link, so you can also use it in Google Sheets
• Start Here guide, Rates sheet with every figure, source and date

WHAT IT DOES

• Two people: salaries, super balances, stop-work ages, pension start ages
• Super guarantee and salary sacrifice within the concessional cap (with Division 293 tax), after-tax contributions, spouse contribution splitting
• Minimum pension drawdowns, spending in retirement, and withdrawals shared between the two accounts
• Age Pension: assets test, income test and deeming at the 20 September 2026 Services Australia rates, homeowner or non-homeowner
• Division 296 tax by the ATO method, including the extra 10% above $10m and indexed thresholds
• Compare three plans side by side (retire earlier, work longer, spend more or less)
• Risk sheet: 200 market scenarios show the share of runs where your super lasts to each age (no macros)
• Contributions planner: cap room, unused cap carry-forward, tax saved, after-tax cap and bring-forward
• Age Pension checker for today

CHECKED

Division 296 tax matches the ATO worked examples, and the Age Pension matches Services Australia's limits. The year-by-year workings were also tested against an independent model in six different scenarios. The Check sheet shows every test.

UPDATE EACH YEAR

Every government figure sits on the Rates sheet with its source and date. Update it each July (and March and September for the Age Pension) and the whole workbook follows.

WHAT IT LEAVES OUT

Defined benefit pensions (enter as other income), tax outside super, Rent Assistance, aged care costs, death benefits tax and the timing of Division 296 payment. Rates are for 2026-27.

COMPATIBILITY

Built in Excel format (.xlsx) and checked in LibreOffice and Google Sheets. In Google Sheets, set File > Settings > Locale to your country so dates show in your style.

GOOD TO KNOW

• Digital download only. No physical item will be posted.
• General information and planning tool only. This is NOT financial advice and does not consider your objectives, situation or needs. LifePlanLabs is not a financial adviser. Speak to a licensed adviser before you act. Projections are not predictions.
• For personal use only. Please do not resell, share or upload the files.
• Designed by LifePlanLabs. Created with the help of AI tools.