Skip to content
The title slide and first slides of the Product Pricing Calculator template

Product Pricing Calculator

Spreadsheet template for Google Sheets and Excel

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

Every slide (3)

Overview

A pricing calculator for makers, retailers and small product businesses. The Products tab adds up materials, labour and overhead share for each product, applies your target margin to suggest a price, and compares that price with a competitor's. The Dashboard shows averages by product line and how many products sit below competitor prices.

It comes with sample data for a small home-goods range. Make a copy and replace the sample products. The suggested prices, comparisons and charts update on their own.

Useful for

  • Setting prices for a new product line
  • Checking whether existing prices still cover costs
  • Comparing your prices with competitors before a sale

What's included

  • 3 tabs: Dashboard, Products, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Products: 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 Products 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

Is this Product Pricing Calculator template free?

Yes. Download the template and use it at no cost for your own pricing.

Does it work in Excel?

Yes. Download the .xlsx file and open it in Excel. The formulas, dropdowns and charts all work there.

How is the suggested price worked out?

It is the total cost divided by one minus the target margin. A cost of 20 with a 50% margin gives a suggested price of 40.

  • #financial-calculator
  • #pricing-calculator
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More financial calculator templates

See all 3

Also in Finance

All finance templates
Get this template

Preparing your template…