Free Excel Retirement Planning Template for Germany

Retirement planning in Germany blends public benefits with workplace and private retirement vehicles. This free Excel Retirement Planning Template (Germany) helps you estimate how statutory pension (gesetzliche Rente), Betriebsrente (company pension), and private savings (Riester/Rürup/ETFs) combine to meet your retirement income goals.

📂 Download Retirement Planning Template (Germany)

Table of Contents

What’s Included in the Template

Inputs sheet: Current age, retirement age, life expectancy, current balances for statutory, company, and private pensions, annual contributions, expected returns, and inflation.
Projection sheet: Year-by-year projection of contributions, returns, withdrawals, and portfolio balances.
Summary sheet: Projected nest egg at retirement, 4% rule check, estimated statutory pension, other incomes, and surplus/gap analysis.

Works in Excel & Google Sheets: Upload the file to Google Sheets if you want browser-based access (some formulas/formatting may differ).

Key German Retirement Concepts in the Template

Statutory Pension (Gesetzliche Rente)

The template lets you enter an estimate for your statutory pension. Official forecasts are based on your contribution record — use your Deutsche Rentenversicherung statement for an estimate.

Company Pension (Betriebsrente)

Many employers provide a Betriebsrente. Include your current company pension balance and annual contributions (employee + employer).

Private Pension & Investments (Riester, Rürup, ETFs)

Track private retirement accounts — Riester or Rürup pension plans, taxable investment accounts, and ETFs. TFSAs/ISAs don’t apply in Germany, so private savings are taxed differently.

Inflation, Returns, and Withdrawal

Set realistic return assumptions (e.g., 4–6% pre-retirement, 2.5–4% after retirement).
Adjust inflation (default set to ~2%).
The Summary tab shows a 4% rule benchmark so you can gauge sustainability (heuristic only).

How to Use the Template (Quick Start)

Download and open the spreadsheet.
Go to the Inputs sheet and fill in your age, retirement age, life expectancy, balances, and annual contributions.
Set expected returns and inflation rates according to your risk tolerance.
Enter an estimate for statutory pension (or leave blank and use your pension statement to update later).
Check the Summary to see projected nest egg, expected pension income, and any income gap.
Use the Projection sheet for a year-by-year view and to test “what-if” scenarios (higher contributions, later retirement, etc.).

Example Scenario

For example, a 35-year-old with €20,000 in private savings, €40,000 in company pension, and expecting a statutory pension of €18,000/year who contributes €6,000/year to private savings and €5,000/year to company pension can test whether their combined income at retirement meets a target (e.g., €40,000/year).

Frequently Asked Questions

How do I estimate my statutory pension?
Use your annual statement from Deutsche Rentenversicherung or the online portal for a personalized projection, then enter the number in the template.

Does the template calculate taxes?
No — the template focuses on gross/income-level planning. Pension taxation in Germany depends on the specific pension type and year of retirement; consult a tax advisor for net-income projections.

Can I model property income or rentals?
Yes — add expected net rental income under “Other Income” in Inputs to include it in your retirement calculations.

Disclaimer: This template and article are provided for educational and guidance purposes only. They are not a substitute for professional financial, tax, or legal advice. I am not a financial advisor. Please consult a qualified financial planner or tax specialist for personalised retirement planning.