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.

Download Excel template (.xlsx) 69 KB · no macros · Excel 2016+ and Google Sheets · v1.0, 31 Oct 2026

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.

Preview: the Example tab (fictional data). Age 35, retiring at 65, planning to age 95. $60,000 saved, $700 a month rising 3% a year, $75,000 salary with a 50% match up to 6% of salary. Returns 6.5% before and 4.5% in retirement, inflation 2.5%. Wants $60,000 a year in today's money; other income (a made-up Social Security figure) $22,000 a year in today's money from 67. Blue rows: retired. Red rows: the money cannot pay the full need.
$1,670,938projected savings at 65
$1,923,676savings needed at 65
$243.84/moextra saving that closes the $252,738 gap
Age 89money runs out (plan is to age 95)
AgePhaseStart balanceContributions + matchIncome needOther incomeWithdrawal paidUnpaidBalance, today's money
35Saving$60,000$10,650––––$60,000
36Saving$74,550$10,970––––$72,732
40Saving$146,352$12,346––––$129,354
45Saving$274,880$14,313––––$214,736
50Saving$462,818$16,592––––$319,560
55Saving$734,040$19,235––––$447,963
60Saving$1,121,555$22,299––––$604,956
64Saving$1,545,390$25,097––––$755,172
65Retired$1,670,938–$125,854$0$125,854$0$796,607
66Retired$1,614,613–$129,000$0$129,000$0$750,980
67Retired$1,552,465–$132,225$48,483$83,743$0$704,463
70Retired$1,490,379–$142,392$52,211$90,182$0$628,003
75Retired$1,316,469–$161,104$59,071$102,032$0$490,294
80Retired$1,028,679–$182,274$66,834$115,440$0$338,615
85Retired$589,635–$206,227$75,616$130,610$0$171,550
88Retired$234,231–$222,083$81,431$140,653$0$63,282
89Retired$97,789–$227,635$83,466$97,789$46,380$25,775
90Retired$0–$233,326$85,553$0$147,773$0
95Plan-to age$0–––––$0
Example tab: start-of-year balance by age 35 to 95. It grows from $60,000 at 35 to $1,670,938 at 65 ($796,607 in today's money), then falls as withdrawals rise with inflation and reaches $0 during age 89.$0$300k$600k$900k$1,200k$1,500k$1,800k35404550556065707580859095Retire at 65Runs out at 89AgeBalance, future dollarsBalance, today's money

Chart: start-of-year balance from the same tab. The workbook's Summary tab draws this as a native chart for whichever tab you choose.

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.

QuestionRetirement planner (this page)FIRE calculator
Starting pointA retirement age you chooseA spending target and withdrawal rate
Employer match and 2026 IRS limitsYesNo
Social Security or pensionYes, from the age it startsNo
Withdrawal phaseYear by year to your plan-to ageNot modelled
Main answersShortfall, extra monthly saving, age money runs outFIRE number, years to FIRE, Coast FIRE age

What's inside the spreadsheet

TabWhat you typeWhat it calculates
Start hereNothingSteps, how the math works, colour key, limits, disclaimer
Planner15 inputs in B4:B18Results 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)
ExampleAlready filledThe same layout with fictional numbers, so you can see every formula working
SummaryB3: Auto, Planner or ExampleKey numbers, a snapshot at today, retirement, +10, +20 years and the plan-to age, and a native chart of the balance by age
Chart dataNothingFeeds the chart. It shows #N/A after the plan-to age on purpose, because charts skip #N/A cells

The inputs

CellInputWhat it does
B4, B5, B6Current age, retirement age, plan to ageThe table runs from B4 to B6. Saving years are B4 to B5 − 1; retirement years are B5 to B6 − 1.
B7Current retirement savingsThe starting balance.
B8, B9Monthly contribution, yearly raiseYour contributions in year t = 12 × B8 × (1 + B9)^(t − 1). The salary for the match limit grows by B9 too.
B10, B11, B12Salary, match rate, match limitMatch = B11 × the smaller of your contributions and B12 × salary. Leave B10 blank to match every dollar.
B13, B14Return before and in retirementNominal yearly returns (before inflation).
B15InflationTurns today's-money amounts into future dollars, and back again for the "today's money" columns.
B16Retirement income wantedPer year, in today's money. Include the tax you expect to pay on withdrawals.
B17, B18Other income, start ageYour Social Security estimate or a pension, in today's money, from the age in B18.

How to use it

  1. Open the Example tab and change a few yellow cells to see how the results move. All its data is fictional.
  2. 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.
  3. Open Planner and fill B4:B18. Type rates as percentages: 6.5%, not 6.5.
  4. 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).
  5. Check I11: it compares your year-1 contributions with the 2026 401(k) employee limit for your age.
  6. 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:

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 2026AmountIRS 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.

FieldFormula
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

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

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.