Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceFinancial PlanningRetirement Income and Withdrawal Planner

SpreadsheetFinancial PlanningFree

Retirement Income and Withdrawal Planner

A year-by-year drawdown plan: spending with inflation, Social Security and pension, tax on withdrawals, growth and whether the money lasts.

Shown with sample data

Colour

Retirement Income and Withdrawal Planner

A year-by-year drawdown plan: spending with inflation, Social Security and pension, tax on withdrawals, growth and whether the money lasts.

Money lasts to
Age 93
First-year withdrawal rate
6.9%
Balance at the last age
$0
Years with a high withdrawal rate
24
Total withdrawn from the portfolio
$2,546,665
Portfolio balance by age
6592

Latest: $104,651

Withdrawal rate by age
6593

Latest: 113.7%

How to use it

  1. 1On Inputs, type your retirement age, portfolio at retirement and the spending you need in the first year (after tax).
  2. 2Enter Social Security and any pension: start ages and yearly amounts in first-year dollars.
  3. 3Set inflation, an average portfolio return and the tax rate on withdrawals.
  4. 4Read the Plan sheet: Status shows Sustainable, High withdrawal or Runs out for every year.
  5. 5Test a market shock in year one (for example −0.20) and a later Social Security claiming age to see the effect.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Saving for retirement is half the job; spending it safely is the other half. Enter your portfolio, spending need, Social Security and pension; the planner inflates spending each year, subtracts guaranteed income, grosses up withdrawals for tax, grows the remaining balance and shows the withdrawal rate and balance every year to age 95, flags high withdrawal rates and tells you the age the money runs out, with a first-year market shock test for sequence-of-returns risk.

Who it’s for

  • Deciding when you can afford to retire
  • Choosing when to claim Social Security
  • Stress-testing a plan against a bad first year in the markets

What’s included

  • Plan sheet: Spending, income, withdrawals and balance for every year of retirement.
  • Inputs sheet: Your portfolio, spending, income sources and assumptions.

How to use it

  1. 1On Inputs, type your retirement age, portfolio at retirement and the spending you need in the first year (after tax).
  2. 2Enter Social Security and any pension: start ages and yearly amounts in first-year dollars.
  3. 3Set inflation, an average portfolio return and the tax rate on withdrawals.
  4. 4Read the Plan sheet: Status shows Sustainable, High withdrawal or Runs out for every year.
  5. 5Test a market shock in year one (for example −0.20) and a later Social Security claiming age to see the effect.

Tips

  • A first-year withdrawal rate around 4% has historically lasted 30 years in most markets; above 5% needs flexibility or guaranteed income.
  • Delaying Social Security from 62 to 70 raises the benefit by roughly 75% and inflation-protects more of your income.
  • Keep one to two years of spending in cash so you are not forced to sell investments after a market fall.

Questions

How much can I withdraw from retirement savings each year?

The 4% rule suggests withdrawing 4% of the starting balance, then adjusting for inflation. Your safe rate depends on retirement length, investments, flexibility and other income; this planner shows the rate each year so you can see the pressure points.

Why are withdrawals grossed up for tax?

Withdrawals from traditional IRAs and 401(k)s are taxed as income, so to spend $60,000 you might need to withdraw about $68,000. Use a lower tax rate if part of your savings is in Roth or taxable accounts.

What is sequence-of-returns risk?

Poor returns early in retirement do more damage than the same returns later, because you are selling investments while prices are low. The first-year shock input lets you test this.

Does this include required minimum distributions?

No. RMDs set a minimum withdrawal from traditional accounts from age 73 or 75 (depending on birth year in the US); if they exceed your planned withdrawal, the extra can be reinvested.

Related searchesretirement withdrawal calculatorretirement income plannerwill my money last in retirementretirement drawdown spreadsheetsafe withdrawal rateretirement paycheck

Details

Format
Spreadsheet
Category
Financial Planning
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetFinancial PlanningFree

Retirement Income and Withdrawal Planner

A year-by-year drawdown plan: spending with inflation, Social Security and pension, tax on withdrawals, growth and whether the money lasts.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Financial Planning
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More financial planning templates

View all
FIRE Early Retirement Planner3 sheets

FI number

$1,250,000

Savings rate

43%

Years to FI

15

ABC
1ResultValueWhat it means
2Annual savings40,000Take-home income minus spending
3Savings rate0.43The single biggest driver of how fast you reach FI
4FI number1,250,000Retirement spending ÷ safe withdrawal rate
5Progress to FI0.15Invested assets as a share of your FI number
Results
SpreadsheetFinancial Planning

FIRE Early Retirement Planner

Your FI number, savings rate, years to financial independence, Coast FI and a year-by-year path to retiring early.

10 min setupPreview
College Financial Aid Comparison3 sheets

Lowest 4-year net price

$46,650

Highest 4-year net price

$229,199

Difference

$182,549

ABCD
1CollegeNet price, year 14-year net price4-year borrowing
2State University (in-state)$21,300$92,052$22,000
3Lakeside College (private)$32,200$148,073$54,000
4Bayview University (merit scholarship)$30,200$137,609$22,000
5Northern Tech Institute$24,800$107,530$38,000
Compare
SpreadsheetFinancial Planning

College Financial Aid Comparison

Compare aid offers on what college will really cost: cost of attendance minus grants, loans kept separate, four-year totals and the payment after graduation.

10 min setupPreview
Personal Net Worth Statement3 sheets

Net worth

$223,150

Change since last review

$17,850

Liquid net worth

$15,900

Assets by type
74%
  • Property
  • Retirement
  • Investments
  • Cash
SpreadsheetFinancial Planning

Personal Net Worth Statement

Assets, debts and net worth with a quarterly history, allocation by type and debt-to-asset ratio.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ