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.
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:
An Excel workbook with no macros, for one person or a couple, over sixty years of projection.
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.
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.
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.
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.
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.
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.
Enter your starting capital in the first row of the “Capital on 1 January” column of the “Trajectory” tab.
Read the “Capital on 31 December” column: the year it goes below zero is the age your capital no longer suffices.
Change one assumption at a time — two more years of work, €200 less spending a month — and watch the year move.
For Google Sheets: drop the file into Google Drive, then “Open with › Google Sheets”.
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.
Your net worth month after month, in a free Excel spreadsheet. No sign-up.
Income, spending, what is left and your savings rate, month by month. No sign-up.
Monthly payment, total cost and balance remaining on your loan, payment by payment.
Yields, cash flow and rent month by month, with late payments spotted. No sign-up.
Explore Patrice with sample data, no account and no card, then load your assumptions from this workbook.