Skip to content
The title slide and first slides of the Retirement Withdrawal Planner template

Retirement Withdrawal Planner

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
7
Difficulty
Beginner
Updated
November 16, 2026

Every slide (7)

Overview

Start by listing the accounts you plan to draw from, with their balances and a return you expect from each. The Withdrawals tab takes the first-year withdrawal, how much it rises each year and the return to use, and shows the withdrawal rate that results. Years Left then builds a table of 35 years with the withdrawal and a year-end balance in every row, and flags the first year the money runs out.

The sample plan starts with about $753,000 and withdraws $36,000 rising 3 percent a year at a 5 percent return, which empties the pot after 28 years. Changing the return or the withdrawal and watching the funded years move is the main use. Taxes, Social Security and required withdrawals are not modeled.

Useful for

  • Test how long a savings pot lasts at different withdrawal amounts
  • See the effect of a lower return on the last funded year
  • Find the balance left at 10 and 20 years of retirement

What's included

  • 4 tabs: Accounts, Withdrawals, Years Left, How to use
  • Accounts: a table with 2 summary figures
  • Withdrawals: a table
  • Years Left: a table with 5 summary figures
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Accounts tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How long will my retirement savings last?

It depends on the balance, how much you withdraw, how withdrawals rise and the return you earn. Enter those into the Withdrawals tab and the Years Left table shows the first year the balance reaches zero.

What is a withdrawal rate?

It is the first-year withdrawal divided by the starting balance. The sheet calculates it for you. There is no safe number for everyone, so test several returns and amounts.

Does this sheet include taxes or Social Security?

No. It only runs the arithmetic of balance, return and withdrawals. Taxes, other income and required withdrawal rules change real outcomes, so ask a professional for a full plan.

  • #investment-tracker
  • #retirement-withdrawal-planner
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More investment tracker templates

See all 14

Also in Finance

All finance templates
Get this template

Preparing your template…