Free Profit Margin Calculator (Excel)

Last updated: 15 November 2026

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 enterIt calculates
Sales, direct costs, overheads, interest and tax (all excluding VAT)Gross profit and margin, operating profit and margin, net profit and margin
Your overheadsBreak-even sales: overheads ÷ gross margin
The cost of one item or job and a target marginThe 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