Finance template
Retirement savings projection
Project retirement savings year by year with growing contributions, an employer match and separate returns before and after retiring. See the nest egg, the income it supports and how long it lasts.
- Free
- No account needed to try
- Download as .xlsx
What's inside
Everything is a normal workbook once you open it: change the numbers, rename the sheets and make it yours.
1 sheet
- Projection
501 formulasTotals, lookups and checks are already worked out, so the sheet updates as you type. 539 filled cells in all.
Built in
- Charts
- Conditional formatting
- Named ranges
- Live dates
- Frozen headers
- 1 chart
A look at the Projection sheet
The top left of the first sheet, calculated by SheetsBat. Open the template to see all of it.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Retirement savings projection | |||||||
| 2 | Change the assumptions on the right. Amounts are nominal unless marked in today's dollars. | |||||||
| 3 | ||||||||
| 4 | BALANCE AT RETIREMENT | IN TODAY'S DOLLARS | LASTS UNTIL AGE | INCOME IT SUPPORTS | ||||
| 5 | $2,272,981 | $1,006,256 | 95+ | $144,382 | ||||
| 6 | ||||||||
| 7 | Quick check with level contributions (FV): | $1,673,940 | ||||||
| 8 | ||||||||
| 9 | Age | Year | Start balance | Contributions | Withdrawals | Growth | End balance | Today's dollars |
| 10 | 34 | 2026 | $48,000 | $12,000 | $0 | $3,510 | $63,510 | $61,961 |
| 11 | 35 | 2027 | $63,510 | $12,360 | $0 | $4,530 | $80,400 | $76,526 |
| 12 | 36 | 2028 | $80,400 | $12,731 | $0 | $5,640 | $98,770 | $91,718 |
- retirement
- savings
- investing
- projection
More finance templates
FinancePersonal monthly budgetPlan income and spending for the month and see what is left at a glance. Compare planned and actual amounts by category with a chart.
FinanceInvoice trackerTrack every invoice you send, what has been paid and what is overdue today. An aging summary groups open balances by how late they are.
FinanceBreak-even analysisFind how many units you need to sell to cover fixed costs, and what it takes to hit a profit goal. A chart shows revenue crossing total cost.
FinanceCap tableModel ownership through seed and Series A rounds with share prices worked out from each pre-money valuation. See fully diluted ownership and a simple payout at an exit value.
Start your retirement savings projection now
It opens in your browser in a second. Create a free account to save it, share it and open it anywhere.