Skip to content
The title slide and first slides of the Childcare Cost Comparison template

Childcare Cost Comparison

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

Childcare options charge in different ways: a nanny by the hour, a daycare center by the week, an in-home provider by the month. The Options tab records each provider, its type, how the rate is charged and any one-time fee. The Hours tab adds the hours per week and weeks per year you would use it, and converts every option into a weekly cost, a yearly cost and a cost per hour.

The Compare tab shows the lowest and highest yearly cost, the gap between them plus a bar chart that ranks the options by yearly cost. The five sample providers range from an after-school program to a full-time nanny. Replace them with the options you are weighing, and add the extra costs such as meals, payroll tax or late pickup in the Notes column.

Useful for

  • Compare full-time daycare with a nanny share
  • Budget for after-school care during the school year
  • Show a partner the yearly difference between options

What's included

  • 4 tabs: Compare, Options, Hours, How to use
  • Compare: a dashboard with 4 summary figures
  • Options: a table
  • Hours: a table
  • 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 Options 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 do I compare daycare and a nanny?

Convert both to the same period. Enter the daycare weekly rate and the nanny hourly rate with your hours, and the sheet shows the weekly, yearly and hourly cost for each.

Does the cost include registration fees?

Yes. The one-time fee is added to the yearly cost. Hourly cost spreads the yearly total over the hours you use.

Can I include tax credits or employer benefits?

This sheet does not calculate them because limits change each year. Check the IRS or CRA site or ask a tax adviser and note the result.

  • #financial-calculator
  • #childcare-cost-comparison
  • #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…