Planning for retirement in the UK means managing your workplace pension, ISAs, and State Pension while accounting for inflation and lifestyle goals. To make this easier, we’ve created a UK Retirement Planning Excel Template that helps estimate your savings, future income, and retirement readiness.
Disclaimer: This guide is for educational purposes only and not financial advice. I am not a financial advisor. Please consult a qualified professional before making financial decisions.
What’s Inside the UK Retirement Template?
- Inputs: Age, savings, contributions, growth rates, inflation, desired income.
- Accounts: Tracks Workplace Pension and ISA separately.
- State Pension: Includes the UK State Pension estimate (up to ~£11,500/year in 2025).
- Summary: Nest egg estimate, 4% rule check, and income gap calculation.
📂 Download UK Retirement Planning Template
How to Use the Template
- Enter your current age and planned retirement age (typically 67 in the UK).
- Add your Workplace Pension balance and yearly contributions.
- Include your ISA balance and planned yearly contributions.
- Adjust expected returns and inflation rate.
- Enter your State Pension estimate (check gov.uk for personalised forecast).
- Review the Summary tab to see whether you’ll have a surplus or shortfall.
Key UK Retirement Factors
- Workplace Pension: Most employers auto-enrol staff. Contributions and employer match are vital.
- ISA: Tax-free growth and withdrawals. Annual allowance is £20,000 (2025).
- UK State Pension: Requires at least 35 qualifying years of NI contributions for full entitlement.
- Inflation: Keep assumptions realistic to avoid shortfalls later.
Tip: Many UK retirees combine State Pension + Workplace Pension + ISA withdrawals for a flexible, tax-efficient retirement income.
Example Scenario
Suppose you’re 35 with £40,000 in your workplace pension and £20,000 in ISA savings. You contribute £8,000/year to your pension and £5,000/year to ISA. With 6% returns before retirement, by age 67 you could have:
- Workplace Pension: ~£600,000
- ISA Savings: ~£250,000
- State Pension: ~£11,500/year
Total income: ~£31,000/year — close to the £30,000 target.
Frequently Asked Questions
How do I get my State Pension forecast?
Visit gov.uk Check State Pension.
Can I include a private pension or SIPP?
Yes, add the balance and contributions under “Other Pension/Benefits.”
Does this template include tax?
No, figures are pre-tax. Actual retirement income will depend on your tax situation.
Can I extend the projection beyond age 90?
Yes, just add rows in the Projection sheet.