Skip to content
Spryhand

Small Business

Pricing & Profit Margin Calculator

Set a price from cost and target margin, or check what margin an existing price actually earns.

Delivery
Instant download
Purchase
One-time payment
Format
  • Google Sheets
  • Excel
Updated
August 2026
$5.90Buy on Etsy
Sample preview — illustrative data

Margin on a $24.00 price

23.3%

Priced below cost

1 of 7

ItemValue
  • Total cost$18.40
  • Target margin45%
  • Price you need to charge$33.45
  • Markup this equals81.8%

Sample data preview of the Pricing & Profit Margin Calculator spreadsheet, shown for illustration only.

What this spreadsheet does

Prices set by guessing or matching competitors often don't cover real costs, so the business earns less margin than it thinks.

What you can do with it

  • Set a new price that actually hits your target margin
  • Find the product whose price stopped covering its cost
  • Reprice a whole range against its own targets

What's included

Sheet tabs

  • Instructions
  • Price Calculator
  • Product Pricing Table

Features

  • Cost entered as three parts — materials, labour and overhead share
  • Price from a target margin, with the markup equivalent beside it
  • The reverse: enter a price you already charge and see the margin it really earns
  • A whole product line priced at once, with the price each item needs to hit its own target
  • Anything priced below cost flagged and named
  • Extra profit you would make if every price met its target

How it works

  1. 1Enter materials, labour and overhead for one product or service
  2. 2Set a target margin to get a price, or enter a price to check its margin
  3. 3Use the Product Pricing Table for a whole range at once

Who it's for

Small business owners and freelancers setting or checking product/service pricing.

Frequently asked questions

Does it work for services, not just products?

Yes. Enter labour and a share of overhead per service the same way you would a product's materials.

Can I price multiple products at once?

Yes, the Product Pricing Table takes a whole line, gives each item its own target margin, and tells you what extra profit meeting all of them would produce.

What is the difference between margin and markup?

Margin divides profit by price; markup divides profit by cost. A 45% margin is an 82% markup. The sheet shows both in both directions so they never get swapped.

What if I sell something at or below cost on purpose?

That is fine and the sheet does not treat it as an error — it shows a margin near zero or negative and names the item, so the decision stays visible rather than being forgotten.

Complete the setup

The rest of the tools this one was built to sit beside.

Similar tools

The same kind of tool, for a different job.