Retirement - Template 61
Retirement Income & Drawdown Planner
See what you can draw, what the tax costs and when the money runs out.
Microsoft Excel◆Google Sheets◆.xlsx file
A UK retirement income planner built around the one thing most retirement spreadsheets skip: the tax. Enter your pots, your other income and what you want retirement to cost, and the workbook works out what you can draw each year, what the taxman takes, and the age your pot runs out. It applies the personal allowance, the taper above £100,000 and the basic, higher and additional rate bands properly, and it knows a pension is not an ISA - your 25 per cent tax free cash and your already tax free savings are tracked as separate pools and drawn in the order that costs you least. Change your budget and watch the age the money runs out move.
What's inside · 20 tabs
- Retirement Dashboard - the whole plan on one page - pot at retirement, net income, tax and the age it lasts to
- Drawdown Projection - every year from retirement onwards, with opening pot, income, tax and closing balance
- Tax Dashboard - the income tax you pay, year by year and band by band, on 2026/27 rates
- Withdrawal Order - what taking tax free cash first is actually worth, in tax, against spreading it out
- Pot Longevity - how long the money lasts at seven different spending levels
- Scenario Lab - seven real what ifs - retire earlier, live to 100, lower growth - each a full projection
- Pension Pots & Contributions - every pot, its balance, its type, its access age and what you are still paying in
- Retirement Budget - essential, comfort and luxury split out, plus the one off costs a yearly budget misses
- State Pension & Milestones - what a full record is worth, and every dated event from pension access to age 75
- Settings - your ages, growth and inflation assumptions, the tax bands and any currency
Pairs Beautifully With
