Profit Margin Calculator: Gross Margin, Net Margin and the Margin Your Price Implies

How do you calculate profit margin?

Subtract costs from revenue to get profit, divide the profit by revenue, and multiply by 100. Which costs you subtract decides which margin you have: gross, operating or net.

Direct costs (also called cost of goods sold, or COGS) are what you spend only because the work happened: materials, subcontractors, and the wages of the people doing the job. Operating expenses are the bills that arrive anyway: rent, insurance, software, the phone, the truck payment.

Most online margin calculators ask for one cost and one price. That answers the question for a product on a shelf. A service business has two layers of cost, so it has two margins, and the gap between them is where the money goes. I build spreadsheet maths; I am not an accountant, and this is not tax advice.

Profit margin calculator (free, no signup)

Type revenue, direct costs and operating expenses for a month, a quarter or a single job. The calculator returns gross profit, gross margin, operating profit and operating margin. It starts on the example month used in this guide.

To use it as a gross margin calculator only, leave operating expenses at 0. The gross and operating figures will then match. For net margin after tax, subtract your tax reserve from operating profit and divide by revenue. Nothing you type leaves your browser.

Worked example: gross margin and net margin for one month

On $24,000.00 of revenue, $9,600.00 of direct costs and $10,800.00 of operating expenses, the month has a 60% gross margin and a 15% net margin before tax. Every input is an assumption; replace each one with your own books.

Read the two numbers together. The work itself keeps 60 cents of every sales dollar. Overhead then takes 45 cents ($10,800.00 / $24,000.00), which leaves 15 cents. A gross margin calculator alone would have reported 60% and stopped there.

Tax moves the net figure again. If you set aside 25% of operating profit as a reserve (an assumed rate, not advice; yours depends on your structure and income), the reserve is $900, net profit is $2,700 and net margin is 11.25%.

The same two rows also give the sales you need before any profit appears. Break-even revenue is operating expenses divided by gross margin: $10,800.00 / 0.60 = $18,000. This month cleared it by $6,000. The break-even calculator guide turns that into jobs per month.

Gross margin vs net margin on a single job

A job has both margins too. Gross margin counts only the job's labour and materials. Net margin also counts the job's share of overhead. Quote from the net figure, because overhead is paid whether or not you remember it.

The job costs $260.00 of loaded labour and $180.00 of materials, so its direct cost is $440.00. Its overhead share is $66.00 (8 hours at $8.25 per sellable hour). Full cost is $506.00. Priced at $778.46, here is the same job as a three-line profit check:

The job shows a 43.48% gross margin and a 35% net margin. If you only tracked direct costs you would believe you kept 43 cents on the dollar. You kept 35. The 8.48 points between them is the overhead share ($66.00 / $778.46).

Two inputs carry most of the risk. The labour figure must be the loaded rate, not the wage; the labor burden calculator guide builds it line by line. The overhead share comes from dividing a year of overhead by the hours you can sell; the overhead and profit calculator guide shows that division.

What profit margin does your price imply?

Take the price, subtract the full cost, and divide by the price. On a full cost of $506.00, a $650 price implies a 22.15% margin and a $700 price implies 27.71%. This is the check to run on a price you were about to send.

The curve is not a straight line. Going from $600 to $700 adds 12.04 points of margin. Going from $850 to $1,000, a bigger price rise, adds 8.93 points. Each extra dollar of price is pure profit, but it is divided by a larger price.

It also shows what a discount costs. Knock $78.46 off the $778.46 price to land on a round $700 and profit falls from $272.46 to $194.00. That is a 10.08% price cut and a 28.80% profit cut.

How do I calculate a 20%, 30% or 40% profit margin?

Divide the full cost by one minus the margin. For a 20% margin divide by 0.80, for 30% by 0.70, for 40% by 0.60. Multiplying the cost by 1.20, 1.30 or 1.40 is a markup and always gives a lower price.

Check any row by working backwards: ($843.33 - $506.00) / $843.33 = 40.00%. The last column is the reason people underprice. Adding 35% to $506.00 gives $683.10, which keeps 25.93%, not 35%. I keep this section short on purpose; the markup vs margin calculator guide has the full conversion chart.

Profit margin formula in Excel and Google Sheets

Put revenue, direct costs and operating expenses in three cells and let four formulas do the rest. The same syntax works in Excel and Google Sheets. Format the margin cells as percentages.

Wrap each division in IFERROR so an empty month shows 0% instead of an error. For a year-to-date margin, divide the year-to-date profit by the year-to-date revenue. Never average the monthly percentages: a big month and a small month do not carry equal weight.

Common profit margin mistakes

The usual error is dividing by the wrong number. Margin divides by revenue. Divide by cost and you have a markup, which reads higher and makes a thin job look healthy.

• Calling gross margin "profit margin". The example month has a 60% gross margin and a 15% net margin. Say which one you mean, especially when comparing with a published figure.
• Leaving your own labour out of direct costs. If the owner does the work and no wage is counted, gross margin is overstated by the whole value of those hours.
• Using the wage instead of the loaded rate. In the example job a $25.00 wage costs $32.50 an hour once the assumed 30% burden is added.
• Treating a loan repayment or an owner draw as an expense. Interest is an expense. Principal and draws are cash going out, not costs of the month. Ask your accountant how your entity handles owner pay.
• Averaging percentages. Divide totals by totals.

Is a 40% profit margin high?

It depends on which margin. A 40% gross margin can leave nothing if overhead takes 40% of revenue. A 40% net margin means 40 cents of every sales dollar is left after every cost, so all costs together must stay under 60% of revenue. There is no single good number.

I will not quote an industry average here, because a small firm's figures are not comparable with published ones and the ranges are wide. If you want to see how wide, NYU Stern's margins by sector table lists gross and net margins for US industry groups. Those are large listed companies, so read it as context, not as a target.

A more useful test uses your own numbers. Your gross margin has to be larger than overhead as a share of revenue. In the example month overhead is 45% of revenue, so any gross margin under 45% is a loss. At 60% the month keeps the 15 points in between.

Calculator, spreadsheet or P&L template: which do you need?

For one number, the calculator on this page is enough and you do not need to buy anything. A spreadsheet earns its place when you want the same check every month, with the break-even line and the bank balance beside it.

The monthly P&L template is $14.99 one-time for Excel and Google Sheets. You enter one month of revenue and costs and it returns gross profit, gross margin, net profit, net margin and break-even revenue. Its Cash Flow tab then carries opening cash, cash in, cash out and closing cash across 12 months. It does not connect to a bank or produce tax reports. The profit and loss template guide shows how to build the same layout yourself for free.

What to put in your margin sheet: revenue; direct costs with labour at the loaded rate; gross profit and gross margin; operating expenses; operating profit and margin; a tax reserve if you keep one; and break-even revenue. If you would rather start from a finished file, the profit and loss spreadsheet has those rows built.

Step-by-step: Profit Margin Calculator: Gross Margin, Net Margin and the Margin Your Price Implies

1. Total the revenue. Add up what you invoiced or were paid for the period, or take the price of the single job you are checking.
2. Total the direct costs. Add materials, subcontractors and labour at the loaded rate. These are costs you only have because the work happened.
3. Calculate gross margin. Subtract direct costs from revenue and divide by revenue. Example: ($24,000.00 - $9,600.00) / $24,000.00 = 60%.
4. Subtract operating expenses. Take rent, insurance, software, vehicles and admin off gross profit. For a single job, subtract its overhead share instead.
5. Calculate net margin. Divide what is left by revenue. Example: $3,600.00 / $24,000.00 = 15% before tax. Subtract a tax reserve first if you keep one.
6. Compare with your target. If the margin is below target, find the price that hits it: full cost divided by one minus the target margin.

Related guides