pricing calculator spreadsheet
Pricing calculator for cost, markup and margin
Set prices from cost and target margin, and see markup and profit per unit. Useful for products, services and quotes.
Opening the template uses no credits. Building from a prompt uses credits; the Free plan includes 25.
Markup and margin are easy to confuse, and that leads to underpricing. A calculator that shows both side by side avoids the mistake.
What the spreadsheet looks like
| Row | A | B |
|---|---|---|
| 1 | Input | Value |
| 2 | Unit cost | 120 |
| 3 | Target margin | 0.4 |
| 4 | VAT | 0.25 |
| 5 | Price excl. VAT | =B2/(1-B3) |
| 6 | Price incl. VAT | =B5*(1+B4) |
| 7 | Profit per unit | =B5-B2 |
This is the real first sheet of the Pricing Calculator template. Every total is a formula.
Who it's for
- Shops and e-commerce sellers
- Service businesses quoting work
- Makers and manufacturers
What you get
- Cost, price, margin and markup
- Price from target margin as a formula
- Profit per unit
- Excel download
How it works
- 1
Enter costs
Include every variable cost per unit.
- 2
Set target margin
Price = cost ÷ (1 − margin).
- 3
Compare
Ask for scenarios or competitor prices.
Prompts to try
Tips from practice
- Margin = profit ÷ price; markup = profit ÷ cost.
- Include payment and shipping fees in unit cost.
- Round prices after calculating, not before.
Good to know: Market prices and demand are up to you; the sheet shows the math.
Formulas used here: ROUND, Percentage change, IF