Retirement Income Drawdown Planner (Australia) – How Long Will My Super Last? Excel
NEW: Google Sheets edition included.
How long will your super last, and what will you live on each year until 100?
Enter your ages, super and other assets, then choose two ways to draw your super. The workbook shows, year by year until age 100:
- your super balance;
- your drawdown;
- your Age Pension;
- your total income;
- the age each plan runs short (or "lasts past 100").
It then compares the two plans side by side and sums them up in plain English.
What makes it Australian
- Minimum drawdowns: the legal minimum each year, by age (4% under 65 up to 14% from 95), rounded to the nearest $10 the way the ATO describes.
- Three ways to draw: the minimum only, a fixed amount, or a target income that tops up your Age Pension and other income.
- Age Pension every year: at the rates from 20 September 2026 and the limits from 1 July 2026. Both the income test (with deeming and the $300 Work Bonus) and the assets test are worked out, and the lower one is paid. As your super falls, your Age Pension rises.
- Access rules: super opens at 65, or from 60 if you've retired.
- Tax: earnings are tax-free in an account-based pension and taxed at 15% in accumulation.
- Transfer balance cap: the $2.1 million general cap (2026-27) applies. Anything over your cap space stays in accumulation, and there's a note on proportional indexation of personal caps.
- Division 296: any year with a balance over $3 million is flagged. This is law from 2026-27; the tax is flagged, not calculated.
- Couples: each person has their own account, age and minimum.
What's inside
Tabs: Home, Dashboard, Your Details, Strategies, Super Rules, Year by Year, Compare, Checks (17 checks, including the published DSS cut-offs), Rates & Rules (every rate with its date and official source), and Notes & Sources. An example couple is filled in. Everything is shown in today's dollars.
Built and checked by a CPA. Every formula tested against a separate calculation. The workbook was compared with an independent model over 418 scenarios to age 100, with 0 differences. Works in Excel and LibreOffice.
Designed by Plain Numbers Co with the help of AI tools. Listing images are designed previews of the actual file.
30-DAY MONEY-BACK GUARANTEE: if it doesn't work for your situation, message us within 30 days. We'll fix it, or refund you in full if you'd rather. This is in addition to your rights under the Australian Consumer Law, which are not excluded.
General information only, not financial, tax or legal advice. It does not consider your objectives, financial situation or needs. Results are estimates: Services Australia decides your Age Pension and your super fund pays your pension. Consider getting advice from a licensed financial adviser before acting.
