Home › Templates › Retirement planner spreadsheet
Retirement Planner Spreadsheet
A free retirement planner spreadsheet and retirement calculator for Excel and Google Sheets: enter your age, savings, monthly contribution, employer match, returns, inflation, the income you want and your Social Security estimate, and it shows your savings at retirement, the savings you need, the shortfall, the extra monthly saving that closes it, and the age your money runs out.
Use it in Google Sheets: choose File → Import → Upload in Sheets and pick the .xlsx, or upload it to Google Drive and open it with Google Sheets. No sign-up, no add-on, no linked accounts.
| Age | Phase | Start balance | Contributions + match | Income need | Other income | Withdrawal paid | Unpaid | Balance, today's money |
|---|---|---|---|---|---|---|---|---|
| 35 | Saving | $60,000 | $10,650 | – | – | – | – | $60,000 |
| 36 | Saving | $74,550 | $10,970 | – | – | – | – | $72,732 |
| 40 | Saving | $146,352 | $12,346 | – | – | – | – | $129,354 |
| 45 | Saving | $274,880 | $14,313 | – | – | – | – | $214,736 |
| 50 | Saving | $462,818 | $16,592 | – | – | – | – | $319,560 |
| 55 | Saving | $734,040 | $19,235 | – | – | – | – | $447,963 |
| 60 | Saving | $1,121,555 | $22,299 | – | – | – | – | $604,956 |
| 64 | Saving | $1,545,390 | $25,097 | – | – | – | – | $755,172 |
| 65 | Retired | $1,670,938 | – | $125,854 | $0 | $125,854 | $0 | $796,607 |
| 66 | Retired | $1,614,613 | – | $129,000 | $0 | $129,000 | $0 | $750,980 |
| 67 | Retired | $1,552,465 | – | $132,225 | $48,483 | $83,743 | $0 | $704,463 |
| 70 | Retired | $1,490,379 | – | $142,392 | $52,211 | $90,182 | $0 | $628,003 |
| 75 | Retired | $1,316,469 | – | $161,104 | $59,071 | $102,032 | $0 | $490,294 |
| 80 | Retired | $1,028,679 | – | $182,274 | $66,834 | $115,440 | $0 | $338,615 |
| 85 | Retired | $589,635 | – | $206,227 | $75,616 | $130,610 | $0 | $171,550 |
| 88 | Retired | $234,231 | – | $222,083 | $81,431 | $140,653 | $0 | $63,282 |
| 89 | Retired | $97,789 | – | $227,635 | $83,466 | $97,789 | $46,380 | $25,775 |
| 90 | Retired | $0 | – | $233,326 | $85,553 | $0 | $147,773 | $0 |
| 95 | Plan-to age | $0 | – | – | – | – | – | $0 |
Retirement planner or FIRE calculator?
This sheet plans a traditional retirement: you pick the age you stop working, and it checks whether your savings, employer match and other income such as Social Security will pay the income you want until the age you plan to. If your question is instead "how soon could I stop working?", the FIRE calculator spreadsheet answers that with a withdrawal-rate target and years to financial independence.
| Question | Retirement planner (this page) | FIRE calculator |
|---|---|---|
| Starting point | A retirement age you choose | A spending target and withdrawal rate |
| Employer match and 2026 IRS limits | Yes | No |
| Social Security or pension | Yes, from the age it starts | No |
| Withdrawal phase | Year by year to your plan-to age | Not modelled |
| Main answers | Shortfall, extra monthly saving, age money runs out | FIRE number, years to FIRE, Coast FIRE age |
What's inside the spreadsheet
| Tab | What you type | What it calculates |
|---|---|---|
| Start here | Nothing | Steps, how the math works, colour key, limits, disclaimer |
| Planner | 15 inputs in B4:B18 | Results in F4:F18, a 2026 401(k) limit check in I9:I11, and a year-by-year table from row 22 (up to 100 years) |
| Example | Already filled | The same layout with fictional numbers, so you can see every formula working |
| Summary | B3: Auto, Planner or Example | Key numbers, a snapshot at today, retirement, +10, +20 years and the plan-to age, and a native chart of the balance by age |
| Chart data | Nothing | Feeds the chart. It shows #N/A after the plan-to age on purpose, because charts skip #N/A cells |
The inputs
| Cell | Input | What it does |
|---|---|---|
| B4, B5, B6 | Current age, retirement age, plan to age | The table runs from B4 to B6. Saving years are B4 to B5 − 1; retirement years are B5 to B6 − 1. |
| B7 | Current retirement savings | The starting balance. |
| B8, B9 | Monthly contribution, yearly raise | Your contributions in year t = 12 × B8 × (1 + B9)^(t − 1). The salary for the match limit grows by B9 too. |
| B10, B11, B12 | Salary, match rate, match limit | Match = B11 × the smaller of your contributions and B12 × salary. Leave B10 blank to match every dollar. |
| B13, B14 | Return before and in retirement | Nominal yearly returns (before inflation). |
| B15 | Inflation | Turns today's-money amounts into future dollars, and back again for the "today's money" columns. |
| B16 | Retirement income wanted | Per year, in today's money. Include the tax you expect to pay on withdrawals. |
| B17, B18 | Other income, start age | Your Social Security estimate or a pension, in today's money, from the age in B18. |
How to use it
- Open the Example tab and change a few yellow cells to see how the results move. All its data is fictional.
- Get your own Social Security estimate from the Social Security Administration (see below). Write it down in today's dollars with the age you plan to claim.
- Open Planner and fill B4:B18. Type rates as percentages: 6.5%, not 6.5.
- Check that F4 says OK. Read projected savings (F7), savings needed (F9), the shortfall (F11), the extra monthly saving (F13, F14) and the age the money runs out (F15).
- Check I11: it compares your year-1 contributions with the 2026 401(k) employee limit for your age.
- Open Summary for the key numbers and the chart. Then test cautious assumptions: lower returns, higher inflation, a later plan-to age.
Social Security: use SSA's own numbers
The sheet does not estimate Social Security. Benefit rules depend on your earnings record and claiming age, so take the figure from the Social Security Administration. Its benefit calculators page lists, among others:
- my Social Security Retirement Calculator: compares estimates for claiming at 62, at your full retirement age (FRA) and at 70, based on your own earnings record.
- Quick Calculator: a rough estimate in today's dollars or future dollars. SSA notes that it does not access your earnings record. Use the today's-dollars figure in B17.
- Retirement Age Calculator: shows your FRA, the age when you can get unreduced retirement benefits.
- Life Expectancy Calculator: an average estimate based on sex and date of birth, which helps you choose a plan-to age in B6.
The sheet grows other income with your inflation input. Real benefit adjustments follow their own rules, so treat that as an approximation and re-check your estimate every year.
2026 IRS contribution limits
From IRS news release IR-2025-111 (13 Nov 2025):
| Limit for 2026 | Amount | IRS wording |
|---|---|---|
| 401(k), 403(b), governmental 457, Thrift Savings Plan: employee contributions | $24,500 | "is increased to $24,500, up from $23,500 for 2025" |
| Catch-up for those plans, age 50 and over | $8,000 | "is increased to $8,000, up from $7,500 for 2025" |
| Higher catch-up, ages 60, 61, 62 and 63 | $11,250 | "For 2026, this higher catch-up contribution limit remains $11,250 instead of the $8,000 noted above." |
| IRA | $7,500 | "The limit on annual contributions to an IRA is increased to $7,500 from $7,000." |
| IRA catch-up, age 50 and over | $1,100 | "is increased to $1,100, up from $1,000 for 2025" |
The release adds that participants aged 50 and older "generally can contribute up to $32,500 each year, starting in 2026." The Planner adds the right catch-up to $24,500 based on the current age you enter (I9). Limits are set each year, so the sheet only checks year 1.
How the employer match works in the sheet
The IRS 401(k) plan overview explains: "If the plan document permits, the employer can make matching contributions for an employee who contributes elective deferrals to the 401(k) plan. For example, a 401(k) plan might provide that the employer will contribute 50 cents for each dollar that participating employees choose to defer under the plan." It also notes that matching contributions can be subject to a vesting schedule. The sheet assumes the match is fully yours; if you might leave before you are vested, lower the match rate.
The example uses a 50% match up to 6% of salary. With a $75,000 salary the match applies to the first $4,500 a year of contributions (6% × $75,000), so the employer adds $2,250 in year 1, even though the example saves $8,400.
The formulas, explained
Exact formulas from the Example tab (row 52, the year starting at age 65, and the results block). Inputs: B4 current age, B5 retirement age, B6 plan-to age, B8 monthly contribution, B9 raise, B10 salary, B11 match rate, B12 match limit, B13/B14 returns, B15 inflation, B16 income wanted, B17/B18 other income.
| Field | Formula |
|---|---|
| Age (A) | =IF($F$4<>"OK","",IF($B$4+30>$B$6,"",$B$4+30)) |
| Phase (B) | =IF(A52="","",IF(A52=$B$6,"Plan-to age",IF(A52<$B$5,"Saving","Retired"))) |
| Your contributions (D) | =IF(A52="","",IF(B52="Saving",12*N($B$8)*(1+N($B$9))^(A52-$B$4),0)) |
| Employer match (E) | =IF(A52="","",IF(B52="Saving",N($B$11)*IF(N($B$10)>0,MIN(D52,N($B$12)*N($B$10)*(1+N($B$9))^(A52-$B$4)),D52),0)) |
| Investment growth (F) | =IF(A52="","",IF(B52="Saving",C52*N($B$13),IF(B52="Retired",(C52-J52)*N($B$14),0))) |
| Income need, future dollars (G) | =IF(A52="","",IF(B52="Retired",N($B$16)*(1+N($B$15))^(A52-$B$4),0)) |
| Other income (H) | =IF(A52="","",IF(AND(B52="Retired",A52>=N($B$18)),N($B$17)*(1+N($B$15))^(A52-$B$4),0)) |
| Withdrawal needed (I) | =IF(A52="","",MAX(0,G52-H52)) |
| Withdrawal paid (J) | =IF(A52="","",MIN(I52,MAX(0,C52))) |
| End balance (L) | =IF(A52="","",C52+D52+E52-J52+F52) |
| Need discounted to retirement (N) | =IF(A52="","",IF(B52="Retired",I52/(1+N($B$14))^(A52-$B$5),0)) |
| Projected savings at retirement (F7) | =IF(F4<>"OK","",SUMIF($A$22:$A$121,B5,$C$22:$C$121)) |
| Savings needed at retirement (F9) | =IF(F4<>"OK","",SUM($N$22:$N$121)) |
| Shortfall (F11) | =IF(F4<>"OK","",MAX(0,F9-F7)) |
| Extra saving per month, flat (F13) | =IF(F4<>"OK","",IF(F11=0,0,IF(F5=0,"Already at retirement age",PMT(N(B13),F5,0,-F11)/12))) |
| Extra per month if raised each year (F14) | =IF(F4<>"OK","",IF(F11=0,0,IF(F5=0,"Already at retirement age",IF(ABS(N(B13)-N(B9))<0.0000001,F11/(12*F5*(1+N(B13))^(F5-1)),F11*(N(B13)-N(B9))/(12*((1+N(B13))^F5-(1+N(B9))^F5)))))) |
| Money runs out at age (F15) | =IF(F4<>"OK","",IF(COUNT($O$22:$O$121)=0,"Lasts to age "&B6,MIN($O$22:$O$121))) |
| Your 2026 401(k) employee limit (I9) | =IF(N(B4)=0,"",I4+IF(AND(B4>=60,B4<=63),I6,IF(B4>=50,I5,0))) |
N() turns a blank input into 0, so an empty cell never breaks the sheet. Contributions are added at the end of each saving year, and withdrawals are taken at the start of each retirement year. That timing is why the needed-savings figure discounts year k of retirement by (1 + B14)^(k − 1), and why the flat extra saving is a plain PMT with yearly compounding.
Worked example from the sample data
Year 1 (age 35)
Start balance $60,000 grows 6.5% = $3,900. You add 12 × $700 = $8,400 and the employer adds 50% × $4,500 = $2,250. End balance: $60,000 + $3,900 + $8,400 + $2,250 = $74,550.
At retirement (age 65)
Thirty saving years later the projected balance is $1,670,937.81 ($796,607 in today's money). The $60,000 income wanted in today's money is $60,000 × 1.025^30 = $125,854.05 in the first retirement year. Social Security has not started yet, so all of it comes from savings. At 67 the made-up $22,000 of other income is worth $48,482.65 in future dollars, and the withdrawal drops to $83,742.76.
Needed, shortfall and extra saving
Discounting each of the 30 withdrawal needs back to age 65 at 4.5% and adding them up gives $1,923,676.14 needed at 65. The projected $1,670,937.81 covers 86.9% of it, a shortfall of $252,738.33.
Closing that gap over 30 years at 6.5%: =PMT(6.5%, 30, 0, -252738.33) / 12 = $243.84 a month, kept flat. If you add the extra to B8 instead, so it rises 3% a year with the rest of your saving, the first-year amount is $176.05 a month (F14). Typing $876.06 in B8 (that is $700 + $176.06) brings the shortfall to $0 and the money then lasts to 95.
Without the extra saving
The balance pays the full need until age 88. At the start of age 89 it holds $97,788.78 against a need of $144,169.15, so it pays what is left and falls $46,380.36 short that year. From 90 on only the other income remains. F15 shows 89.
Common mistakes
- Mixing today's money and future dollars. Type the income wanted and Social Security in today's money. The table and results are in future dollars except the columns and cells marked "today's money".
- Typing rates as whole numbers. Enter 6.5% (or 0.065), not 6.5. Validation stops rates outside −50% to 50%.
- Forgetting tax on withdrawals. The sheet has no tax. If withdrawals from a traditional 401(k) or IRA will be taxed, raise B16 to cover it.
- A plan-to age that is too short. An average life expectancy is not a maximum; many people live longer. Test a later age in B6.
- Counting an unvested match. If you may leave before the match vests, lower B11.
- Using one optimistic return. Returns are held constant every year. Try lower returns in B13 and B14 and see how far the money-runs-out age moves.
FAQ
How do I make a retirement planner in Excel?
List your inputs (ages, savings, monthly contribution, returns, inflation, the income you want), then build one row per year of age. While working, each row adds growth, your contributions and any employer match. In retirement, each row takes out the income need minus other income and grows the rest. Sum the needs discounted back to the retirement date to get the savings you need, and use PMT on the gap to get the extra monthly saving. This template has all of that built with plain formulas, so you only fill the yellow cells.
How much do I need to retire?
It depends on the income you want, other income such as Social Security, how long the money must last, returns and inflation. The sheet adds up each retirement year's withdrawal need, discounted to your retirement date. When other income starts at retirement this equals =PV(real return, years in retirement, -yearly income need, 0, 1) in today's money. In the fictional example the answer is $1,923,676 at age 65, or $917,099 in today's money.
How do I include Social Security in a retirement calculator?
Get your own estimate from the Social Security Administration (my Social Security, or the Quick Calculator on ssa.gov) and type it in today's dollars as other income, with the age you plan to claim. The sheet subtracts it from your income need from that age on and grows it with inflation. It does not estimate benefits itself.
What are the 401(k) and IRA contribution limits for 2026?
IRS news release IR-2025-111 says the 401(k), 403(b), governmental 457 and Thrift Savings Plan employee limit "is increased to $24,500, up from $23,500 for 2025", and "The limit on annual contributions to an IRA is increased to $7,500 from $7,000." The age-50-and-over catch-up is $8,000 for those plans and $1,100 for IRAs, and a higher catch-up of $11,250 applies at ages 60, 61, 62 and 63. The Planner tab checks your year-1 contributions against the 401(k) limit for your age.
What does it mean if my money runs out before my plan-to age?
The balance cannot pay the full income need in some year. The sheet shows that age, marks the rows red and shows the unpaid amount. To close the gap you can save more (F13 or F14 shows how much), retire later, plan for less income, or test different return and inflation assumptions.
Can I use this retirement planner spreadsheet in Google Sheets?
Yes. In Google Sheets choose File → Import → Upload and pick the .xlsx, or upload it to Google Drive and open it with Google Sheets. It uses IF, N, MIN, MAX, SUM, SUMIF, COUNT, INDEX, MATCH, PMT and NA, which work in Excel 2016+, Google Sheets and LibreOffice. No macros, no array formulas.
Related tools and templates
- FIRE calculator spreadsheetYears to financial independence
- Compound interest spreadsheetGrowth with regular contributions
- Net worth trackerTrack assets and debts over time
- Budget spreadsheetFind the money to save each month
- Emergency fund trackerCash before long-term saving
- Investment policy statementWrite down your plan and rules
- CAGR calculatorCheck a return assumption
- All templatesFree spreadsheets
Educational template only, not financial, tax, legal or investment advice. Results are arithmetic on your own assumptions, not forecasts; returns and inflation will not be constant. Example data is fictional, including the salary, balances, match and the Social Security figure. IRS and SSA material was retrieved on 31 October 2026; check irs.gov and ssa.gov for current figures.