Skip to content
The title slide and first slides of the Big Purchase Planner template

Big Purchase Planner

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

A big purchase goes better with a plan than with a sale banner. The Wishlist tab holds every item along with a price, how many years you expect to use it, the amount saved and what you set aside each month. From those it calculates the amount still needed, the months until you can pay in cash and the cost for each year of use, which helps when a pricey item outlasts a cheap one.

The Savings Plan tab totals the price, savings and monthly contributions by priority with a chart. The Decision tab adds a cooling-off date and three ticks: you can pay without debt, you compared three options and you read reviews. The verdict reads Ready to buy only when all four are true. Sample items include a washer and dryer, a mattress and a laptop.

Useful for

  • Save for an appliance without using a credit card
  • Compare the yearly cost of a durable item and a cheaper one
  • Add a waiting period to stop impulse purchases

What's included

  • 4 tabs: Wishlist, Savings Plan, Decision, How to use
  • Wishlist: a table
  • Savings Plan: a dashboard with 4 summary figures
  • Decision: 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 Wishlist 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 calculate months to save for a purchase?

Take the price, remove the amount already saved, divide the remainder by your monthly contribution and round up. The Months to save column does this for every item.

What is cost per year of use?

It is the price divided by the number of years you expect to use the item. It makes it easier to compare a costly item that lasts with a cheap one you would replace.

What waiting period suits a large purchase?

Many people wait a few days for small buys and a few weeks for large ones. Set your own date on the Decision tab; the verdict stays on Keep waiting until it passes.

  • #budget
  • #big-purchase-planner
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More budget templates

See all 61

Also in Finance

All finance templates
Get this template

Preparing your template…