Skip to content
The title slide and first slides of the Cost per Wear Calculator template

Cost per Wear Calculator

Spreadsheet template for Google Sheets and Excel

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

Every slide (12)

Overview

Cost per wear is price divided by how often you wear a piece, and it falls every time you put it on. The Items tab covers each piece, with its category, price, any wears from before you started and a target cost per wear. The Wears tab is a plain list of dates and items. The sheet counts the log, adds the earlier wears and shows a verdict: Yes when the cost per wear is at or under your target, Not yet when it is above and Not worn when the piece is still unworn.

The Cost per Wear tab compares categories such as outerwear, shoes and dresses, with a chart. It also shows total wardrobe spend, total wears and how many pieces have never been worn. A formal dress worn twice shows why the number can be high, while a winter coat worn all season drops quickly.

Useful for

  • Decide whether a pricey coat was worth it
  • Find clothes you bought and never wore
  • Set a target before buying a new pair of boots

What's included

  • 4 tabs: Items, Wears, Cost per Wear, How to use
  • Items: a table
  • Wears: a table
  • Cost per Wear: 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 Items 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 the formula for cost per wear?

Divide the price by the number of times you have worn the item. A $240 coat worn 28 times costs about $8.57 per wear and keeps dropping with each wear.

Which cost per wear counts as low?

It depends on the piece. Everyday shoes can reasonably aim for a few dollars; an occasion dress may never get low. Set a target for each item before you buy.

Must every wearing be logged?

Logging gives the best figure, but you can enter an estimate of earlier wears and log only the rest. The total is earlier wears plus logged wears.

  • #tracker
  • #cost-per-wear-calculator
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More tracker templates

See all 33

Also in Finance

All finance templates
Get this template

Preparing your template…