Quick answer: Gross profit margin = (sales − direct costs) ÷ sales × 100. Net profit margin = net profit ÷ sales × 100. This free Excel calculator works out both, plus your operating margin, break-even sales and the price you need to charge to hit a target margin.
**Download the free Profit Margin Calculator (Excel)**
What it works out
| You enter | It calculates |
|---|---|
| Sales, direct costs, overheads, interest and tax (all excluding VAT) | Gross profit and margin, operating profit and margin, net profit and margin |
| Your overheads | Break-even sales: overheads ÷ gross margin |
| The cost of one item or job and a target margin | The price to charge, the same price as a markup, and the price including VAT |
Worked example
Sales £100,000, direct costs £55,000, overheads £30,000, interest £1,000 and tax £3,000: - Gross profit margin: £45,000 ÷ £100,000 = 45% - Operating margin: £15,000 ÷ £100,000 = 15% - Net profit margin: £11,000 ÷ £100,000 = 11% - Break-even sales: £30,000 ÷ 45% = £66,667
Margin is not markup
To make a 40% margin on an item costing £20, charge £20 ÷ (1 − 0.40) = £33.33. That's a 66.67% markup on cost. Adding 40% to cost (£28) gives only a 28.6% margin, which is one of the most common pricing mistakes.
Frequently asked questions
How do I calculate net profit margin? Net profit (after all costs, interest and tax) ÷ sales × 100.
What's the difference between gross and net profit margin? Gross margin only takes off direct costs. Net margin takes off everything, including overheads, interest and tax.
Should I include VAT? No. If you're VAT-registered, work out margins on figures excluding VAT, because the VAT isn't your money.
What is a good profit margin for a small business? It depends on the industry, so compare yourself with businesses like yours, and with your own figures month by month.
Related
- How to calculate your true profit margin
- Margin & Price-Increase Audit
- Business management systems: track your margin every month for £15