Skip to content
The title slide and first slides of the Pension Income Estimator template

Pension Income Estimator

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

Many public and union pensions follow one idea: years of service times a percentage times final average pay. The Inputs tab takes those pieces from your benefit statement, along with a survivor option reduction and a yearly cost-of-living raise, and returns a yearly and monthly pension at your planned retirement date. Every factor is a cell you can change because plans differ.

The Years tab lists the same estimate for zero through twelve more years of work, with the share of final pay each would replace. The Estimate tab shows what one more year adds and what the pension becomes after ten raises, with a chart by extra years. Sample numbers describe 18 years worked and 9 to go at a 2 percent factor.

Useful for

  • Compare retiring now with working three more years
  • See how a survivor option changes the monthly check
  • Check what share of final pay a pension replaces

What's included

  • 4 tabs: Inputs, Years, Estimate, How to use
  • Inputs: a table
  • Years: a table
  • Estimate: a dashboard with 6 summary figures
  • 1 chart that update as you type
  • 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 Inputs 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 is a pension calculated?

Most defined benefit plans multiply years of service by a percentage factor and by a pay figure, often an average of the last few years. Your plan booklet states the factor and how pay is defined.

How much does one more year of work add to a pension?

With a simple factor, each extra year adds the factor times your average pay. The Years tab shows the dollar difference for each extra year using the figures you enter.

What is a survivor option on a pension?

It lowers the monthly amount so a spouse keeps receiving payments after you die. The size of the reduction depends on the plan and ages, so enter the percentage from your plan statement.

  • #investment-tracker
  • #pension-income-estimator
  • #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…