Skip to content
The title slide and first slides of the Kids College Cost Projector template

Kids College Cost Projector

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

College prices rise faster than most household budgets, so today's price is a poor guide for a child who enrolls in a decade. This projector grows the cost for you. The Costs tab holds one year of tuition, room and board, books, transportation and personal costs in today's dollars, each with its own yearly increase. On the Child tab you list each child with an age, the age at enrollment, the years of study, the amount saved so far, a monthly deposit and a return.

The Projection tab prices each year of study at the time it will be paid, adds the four years, projects your savings to the enrollment date and shows the amount still to find and the share covered. A chart compares cost and savings child by child. The sample family has three children at ages seven, four and one, so the gap is wider for the youngest, who enrolls later and has had less time to save.

Useful for

  • Setting a monthly savings target for each child
  • Seeing how much a higher yearly cost increase adds
  • Comparing a public and a private school budget

What's included

  • 4 tabs: Child, Costs, Projection, How to use
  • Child: a table
  • Costs: a table
  • Projection: a dashboard with 4 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 Child 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 much will college cost in the future?

Nobody knows. The sheet takes today's costs and grows each cost line by the yearly increase you choose, so you can test a range of what the price might be when your child enrolls.

What monthly amount should go toward college?

It depends on the cost you expect, the time left and the share you want to cover. Change the monthly amount on the Child tab until the share covered reaches your goal.

Does the projection include financial aid?

No. Aid and scholarships are unknown until a child applies, so the sheet shows the full cost. Subtract any expected aid from the cost lines if you want a net figure.

  • #financial-calculator
  • #kids-college-cost-projector
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More financial calculator templates

See all 29

Also in Finance

All finance templates
Get this template

Preparing your template…