Skip to main content
Free template · Excel and Google Sheets

Free retirement projection template for Excel

This free Excel template answers one question: at what age can you live off your wealth, and how long does it last? You fill in your assumptions — age, spending, pension, savings, return, inflation — and the workbook computes your capital year by year. Direct download, no sign-up; the assumptions then load into Patrice with nothing to retype.

Updated · by Patrice

Better than a spreadsheet

Load these assumptions into Patrice

The workbook applies one return, with no tax and no property. Patrice starts from your real accounts and properties, withdrawal tax included, for free and with no card.

Or just take the Excel file:

Download the retirement projection template (.xlsx)Excel template · 4 tabs · 31 KB · no sign-up
2027 version

Get the 2027 version of the template

One email in January when the template is updated, then Patrice's monthly newsletter.

By subscribing, you agree to receive Patrice news and updates by email. Unsubscribe in one click anytime.

What the workbook holds: four tabs

An Excel workbook with no macros, for one person or a couple, over sixty years of projection.

Assumptions

Nineteen settings, one row each: your age, the age you stop working, the planning horizon, yearly spending in retirement, the net pension and the age it starts, yearly savings until then, the return on investments and on savings accounts, inflation, your marginal tax rate. Only the gold column gets filled in.

Trajectory

One row per year: your age, capital on 1 January, the pension received, the year's spending, what has to come out of capital, and what is left on 31 December. The row where capital goes below zero is the year it no longer holds.

Read me

The manual in one page, and above all what the workbook ignores: withdrawal taxes, the order in which you empty your accounts, your properties and their loans, market swings. Those four things are exactly what moves the retirement age by several years.

Patrice

Two columns side by side: what the workbook does, and what the app does on top. Plus the two technical columns “key” and “code” on the Assumptions sheet, the ones Patrice reads your file back through.

The calculation: from today's capital to the year it runs out

Each year starts from the previous year's closing capital, to which the return on investments is added. Before the age you stop working, the year's savings are added too; after it, the year's spending comes due, the pension covers part of it from the age it starts, and the rest is taken out of capital. The year the balance goes below zero is the answer.

Amounts are in today's money: spending, pension and capital follow the same inflation, so there is no need to subtract it from the return by hand. The workbook does not know your wealth — it starts at zero in the first year and you enter your starting capital; the app, by contrast, starts from your real accounts and properties.

It is deliberately a simple calculation: one return on one pot of capital, no tax on withdrawals, no property, a single future. It gives the order of magnitude and the direction, not the date you retire.

Run your projection in five minutes

  1. 1

    Open the “Assumptions” tab and replace the example values in the gold column with yours. Leave the “key” and “code” columns alone: they are how Patrice reads the file back.

  2. 2

    Enter your starting capital in the first row of the “Capital on 1 January” column of the “Trajectory” tab.

  3. 3

    Read the “Capital on 31 December” column: the year it goes below zero is the age your capital no longer suffices.

  4. 4

    Change one assumption at a time — two more years of work, €200 less spending a month — and watch the year move.

  5. 5

    For Google Sheets: drop the file into Google Drive, then “Open with › Google Sheets”.

From the workbook to Patrice, without retyping your assumptions

This template loads into Patrice: Project › Retirement › “Load a scenario (Excel)”. Your nineteen assumptions are taken over as they are — the reading goes through the “key” and “code” columns, never through the labels, which leaves the file translatable without breaking the import. Your accounts and properties do not come from the spreadsheet: they come from your wealth, where they already are.

What the app adds is exactly what the workbook cannot do: a return per account (savings account, share plan, life insurance, pension plan, brokerage), the tax on each withdrawal by account type and age, withdrawal orders compared on capital net of latent tax, your properties with their rent, their loans and the net proceeds of a sale, 500 market draws for a probability rather than a promise, and the whole household: two pensions, two ages, survivor benefits, the first death.

The other free Excel templates

  • Net worth spreadsheet template

    Your net worth month after month, in a free Excel spreadsheet. No sign-up.

  • Monthly budget spreadsheet

    Income, spending, what is left and your savings rate, month by month. No sign-up.

  • Loan amortization schedule

    Monthly payment, total cost and balance remaining on your loan, payment by payment.

  • Rental property spreadsheet

    Yields, cash flow and rent month by month, with late payments spotted. No sign-up.

FAQ

Frequently asked questions

Yes. The download is direct, with no sign-up, no email address and nothing in return. The file is yours to use: change it, add rows, keep it next to your pension statement. It is provided for information and is neither investment advice nor a personalised recommendation.

By projecting capital year by year: capital at the start of the year, plus the return, plus the year's savings before retirement, minus whatever spending asks for beyond the pension. The year capital goes below zero is the answer. That is what the “Trajectory” tab does, over sixty years, from your assumptions.

The file's example takes 4% return on investments, 2% on savings accounts and 2% inflation, in today's money. These are assumptions, not forecasts: change them and look at the gap. One point less of return moves the age your capital runs out by several years — which is exactly why the calculation is worth redoing.

Yes: Project › Retirement › “Load a scenario (Excel)”. Patrice reads your assumptions by their technical keys and tells you what it kept. Accounts, properties and loans do not import from here: they come from your wealth, so that there is only one register of your assets.

The file is a standard Excel file (.xlsx), with no macro and no script, using ordinary formulas (IF, MAX, YEAR, TODAY). In Google Sheets, drop it into Google Drive then open it with Google Sheets. LibreOffice and Numbers read this format too.

A projection is only worth redoing.

Explore Patrice with sample data, no account and no card, then load your assumptions from this workbook.