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

Cost of Living Comparison

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

Before accepting a move, compare what a normal month costs in both places. The Categories tab lists rent, utilities, groceries, transportation, health care, dining out and other lines, each with a current-city and new-city monthly amount. It shows the difference in dollars and as a percent. The Cities tab holds the names, the home type and your current annual take-home pay.

The Difference tab totals both months, shows the gap and estimates the take-home pay needed to match by scaling your current pay by the ratio of the two totals. A bar chart compares every category side by side. It is a rough guide that ignores taxes and one-time moving costs, so use it for orientation and check the details with a professional.

Useful for

  • Weigh a job offer in another city
  • See which categories drive the cost difference
  • Plan a negotiation for a relocation allowance

What's included

  • 4 tabs: Difference, Cities, Categories, How to use
  • Difference: a dashboard with 4 summary figures
  • Cities: a table
  • Categories: 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 Cities 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 the cost of living between two cities?

List the monthly costs you actually have, such as rent, utilities, food and transport, then research the same items in the new city. The sheet totals both and shows the percent change.

How much more would I need to earn after a move?

The sheet scales your current take-home pay by the ratio of new to current monthly costs. Taxes, benefits and lifestyle changes mean the real figure can differ.

Where do I find costs for the new city?

Use rental listings for housing, utility company estimates, grocery store prices and quotes for insurance, then record the source in the note column.

  • #financial-calculator
  • #cost-of-living-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…