Skip to content
The title slide and first slides of the CD Ladder Tracker template

CD Ladder Tracker

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

A CD ladder spreads money across certificates with different terms, so something matures every few months instead of everything at once. Tracking the rungs is where most people lose the thread. This tracker gives each rung a row with the bank, the amount, the APY, the term and the open date, then calculates the maturity date, the interest at maturity and the days left.

You choose how many days of warning you want. When a certificate enters that window its row turns amber and the reminder reads Decide on rollover, and the Maturity tab counts how many are waiting. Charts show how much principal and interest comes due each year and which rung earns the most. The sample ladder holds $25,000 across terms from 6 to 36 months; type your own certificates over it.

Useful for

  • Know which certificate matures next and when to shop for a new rate
  • See how much cash comes due in each year
  • Compare the interest on short and long rungs of a ladder

What's included

  • 4 tabs: Maturity, Certificates, Interest, How to use
  • Maturity: a dashboard with 5 summary figures
  • Certificates: a table
  • Interest: a dashboard with 4 summary figures
  • 2 charts 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 Certificates 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

What is a CD ladder?

It is a set of certificates of deposit with different terms, such as 6, 12, 18, 24 and 36 months, so one matures regularly and the money can be reinvested or used.

How is the interest at maturity calculated?

The sheet applies the APY over the term in years to the amount. Type the APY from your agreement; it assumes you leave the money in until the maturity date.

How do I get a reminder before a CD matures?

Set the number of days on each row. Once the days left drop below it, the row turns amber and the reminder column says Decide on rollover.

  • #savings-tracker
  • #cd-ladder-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More savings tracker templates

See all 22

Also in Finance

All finance templates
Get this template

Preparing your template…