Sales template
Pricing calculator
Set prices from your costs with a target margin, then compare markup, margin and competitor prices per product. A quick converter turns markup into margin and back.
- Free
- No account needed to try
- Download as .xlsx
What's inside
Everything is a normal workbook once you open it: change the numbers, rename the sheets and make it yours.
1 sheet
- Pricing
53 formulasTotals, lookups and checks are already worked out, so the sheet updates as you type. 128 filled cells in all.
Built in
- Charts
- Conditional formatting
- Frozen headers
- 1 chart
- 3 conditional format rules
- 1 validation rule
A look at the Pricing sheet
The top left of the first sheet, calculated by SheetsBat. Open the template to see all of it.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Pricing calculator | |||||||
| 2 | Wickwood Candle Co. Price = total cost / (1 minus target margin), rounded to end in .99 | |||||||
| 3 | Quick converter | |||||||
| 4 | Unit cost | $12.40 | Price with that markup | $19.84 | ||||
| 5 | Markup | 60% | Margin at that price | 37.5% | ||||
| 6 | Target margin | 45% | Price for target margin | $22.55 | ||||
| 7 | Equivalent markup | 81.8% | ||||||
| 8 | ||||||||
| 9 | ||||||||
| 10 | Product | Materials | Labor | Overhead | Total cost | Target margin | Price | List price |
| 11 | Soy candle, 8 oz | $3.10 | $2.25 | $0.90 | $6.25 | 62% | $16.45 | $16.99 |
| 12 | Soy candle, 14 oz | $4.60 | $2.40 | $1.10 | $8.10 | 64% | $22.50 | $22.99 |
- pricing
- margin
- markup
- cost plus
More sales templates
SalesSales quoteSend a professional quote with line discounts, optional items you can switch on or off, tax and a deposit. It shows how many days the quote stays valid.
SalesSales dashboardA year to date sales dashboard with revenue, orders and average order value, monthly trend, region split and top products. Add orders to the Data sheet and everything updates.
SalesCRM sales pipelineTrack deals by stage with a probability for each stage and a weighted forecast by close month. Late deals and contacts going cold are flagged automatically.
SalesSales commission calculatorPay commission by quota attainment tier, either as one rate on all sales or as progressive tiers. Includes an accelerator bonus and a payout chart by rep.
Start your pricing calculator now
It opens in your browser in a second. Create a free account to save it, share it and open it anywhere.