● SALE  60% off every template in the Etsy shop, for a limited time Pinterest Instagram Threads Facebook TikTok Tumblr
Shop on Etsy
Home›Savings Investing & Retirement›Retirement Planner Spreadsheet
Retirement Planner Spreadsheet main view of the retirement workbook
SAVINGS INVESTING & RETIREMENT

Retirement Planner Spreadsheet

Retire on a number, not on a guess. This retirement planner spreadsheet projects your balance year by year to age 95, lines your retirement income up against your spending, and tells you plainly whether you are on track.

$3.00$7.5060% OFF

Sale price in our Etsy shop right now. Checkout, payment and instant delivery are handled by Etsy.

Instant DownloadExcel + Google SheetsPDF Guide Included

The biggest money question, answered in plain words

Most retirement worry comes down to two questions: when can you afford to stop working, and will the money last when you do? This planner turns both into a plan you can read. Enter your age, your accounts and what you save each month, and it projects your balance year by year all the way to age 95. If the money ever runs out, the year is named in plain words.

It is built for US retirement saving. The Accounts tab holds a 401(k) with employer match, Traditional and Roth IRAs, pension income, brokerage and savings accounts, each with its balance, monthly contribution, match and yearly increase. The Social Security tab takes the estimate from your own statement and compares claiming at every age from 62 to 70 using the standard claiming factors, with your planned age highlighted.

The Retirement Income tab sets Social Security, pension and other income against your spending target for every year, showing the surplus or the gap. Scenarios puts three paths side by side, retiring five years early, on plan or five years later, with the nest egg and monthly saving each path needs. The Dashboard then gives the verdict: total saved today, projected nest egg, your target from the 4% rule, and an On Track answer.

Inside the workbook: 10 tabs

What you receive

  • Google Sheets Access PDF, one click makes your own Google Sheets copy
  • EXAMPLE Excel workbook, a filled in sample plan, age 42 retiring at 65
  • BLANK Excel workbook, the clean planner for your own numbers
  • Quick Start Guide PDF, the one page setup guide
  • Four separate files, no ZIP to unpack

Good to know

  • Runs in Microsoft Excel 2021 and Microsoft 365
  • Also runs in Google Sheets with a free Google account
  • No macros, no add-ons and no subscription
  • Built for US accounts: 401(k), Traditional and Roth IRA, pension
  • Every figure is a planning estimate, not financial advice

Questions about this template

The things buyers ask us most.

Where do I get my Social Security estimate?

Create a free account at ssa.gov and open your Social Security statement. It shows your estimated monthly benefit at your full retirement age. Type that one number into the Social Security tab and the claiming age table builds itself, showing monthly and yearly benefits at every age from 62 to 70 with your planned age highlighted.

I am already retired. Is this still useful?

Yes. Set your retirement age to your current age and the planner becomes a drawdown tracker instead. It lines your income, Social Security, pension and other sources, against your spending year by year, and shows the year your money would run out, if it ever does. Many people use it just to check their withdrawal pace once a year.

Is this financial advice?

No. It is a planning tool that works in estimates. It shows you what your own numbers add up to under the return and inflation assumptions you set, so you can have a better conversation with an adviser or make calmer decisions yourself. Real returns will not move in straight lines, so revisit the plan as your numbers change.

Do I need Excel, or will Google Sheets do?

Either one. The access PDF gives you a Google Sheets copy in one click, and the two Excel files cover the example and blank versions. Every formula works the same in both apps. The six account rows and twelve budget categories are yours to rename, and every total follows the names you use.

More in Savings Investing & Retirement

All templates in this category →

Three more workbooks from the same shelf.

Investment Portfolio Tracker Spreadsheet

Every holding, gain and dividend in one file, with no bank logins ever needed.

$7.50 $3.00
View on Etsy
Retirement Budget Planner for Retirees

A monthly budget built around pension and fixed income you receive.

$7.50 $3.00
View on Etsy
Savings Goal Tracker

Set targets for every savings goal, log deposits, and watch progress and milestones grow.

$22.50 $9.00
View on Etsy
View on Etsy · $3.00