Profit margin and markup calculator
A spreadsheet that works out how much you earn on each product. Enter the cost and selling price and it gives the profit, the margin and the markup, the average and lowest margin across your range, how many products fall below your target and the price each needs to reach it. Download it as Excel, OpenDocument, PDF or CSV.
Margins
Margin and markup calculator
List your products with cost and selling price. Margin, markup and profit are worked out for each. Set a target margin to see the price it needs.
Business Corner Coffee Roasters
Target margin (%) 40
| Product | Cost price | Selling price | Profit | Margin | Markup | Price for target margin |
|---|---|---|---|---|---|---|
| House blend 250 g | 3.60 | 7.90 | 4.30 | 54.4% | 119.4% | 6.00 |
| Single origin 250 g | 5.40 | 9.50 | 4.10 | 43.2% | 75.9% | 9.00 |
| Decaf 250 g | 4.10 | 7.50 | 3.40 | 45.3% | 82.9% | 6.83 |
| Cold brew bottle | 1.90 | 4.20 | 2.30 | 54.8% | 121.1% | 3.17 |
| Ceramic mug | 3.20 | 8.00 | 4.80 | 60.0% | 150.0% | 5.33 |
| Products | 5 | |||||
| Average margin | 51.5% | |||||
| Lowest margin | 43.2% | |||||
| Highest margin | 60.0% | |||||
| Products below the target margin | 0 |
