Calculator Margin Net: How to Find It

This calculator works out your net profit margin percentage: you enter your revenue and total costs, and it returns the percentage of each sales dollar that remains as profit after all expenses. It also shows your gross profit and cost-to-revenue ratio so you can see the full picture at a glance.

Formula

Net profit margin = ((Revenue − Total costs) / Revenue) × 100

Where:

• Revenue is the total money you receive from sales, in dollars.
• Total costs include everything spent to generate that revenue—materials, labor, overhead, taxes, interest—in dollars.
• Net profit margin is the result, expressed as a percentage.

The same logic works in any currency; just keep both inputs in the same units.

Worked Example

Using the default values from the calculator:

1. Revenue = $1,000
2. Total costs = $700
3. Net profit = $1,000 − $700 = $300
4. Net profit margin = ($300 / $1,000) × 100 = 30.00%

The calculator shows a margin of 30.00%, a profit of $300.00, and a cost-to-revenue ratio of 70.00%.

Why Net Margin Matters More Than Gross Margin

Gross margin only subtracts the direct cost of goods sold (COGS). Net margin goes further—it subtracts every operating expense, interest, and tax. A business can have a healthy gross margin of 60% yet a net margin of just 5% after rent, salaries, marketing, and loan payments. Net margin is the number that tells you whether the business actually keeps money after all obligations. It’s the figure investors and lenders look at first because it reflects overall efficiency, not just production efficiency.

How to Read the Result

A net margin of 10% means you keep $0.10 of every dollar of revenue. There is no single “good� number—it varies wildly by industry. Grocery stores often operate on margins of 1–3%, while software companies can exceed 20%. Compare your result to your own past performance and to industry benchmarks, not to a universal ideal. A negative margin means you’re losing money on each sale; a margin above 0% but below your cost of capital might still be unsustainable in the long run.

Common Mistakes and Misconceptions

• Confusing margin with markup. A 30% margin is not the same as a 30% markup. Markup = (price − cost) / cost × 100. If you buy for $70 and sell for $100, your markup is 42.86%, but your margin is 30%. Using the wrong one overstates profitability.
• Forgetting to include all costs. Many people only deduct COGS and forget overhead, taxes, and interest. That gives you gross margin, not net margin.
• Using inconsistent time periods. If revenue is monthly, costs must be monthly too. Mixing quarterly costs with monthly revenue distorts the result.
• Rounding too early. Round only the final percentage. If you round intermediate steps, you can shift the result by a full point or more.

Limits of the Formula

This formula is a snapshot of a single period. It doesn’t account for cash flow timing—a sale booked in one month might be paid 60 days later. It also ignores the cost of capital: two businesses with the same net margin can have very different economic value if one requires far more capital to generate that profit. For decision-making, pair net margin with cash flow statements and return on equity. Also, the formula assumes revenue is positive; if you have zero revenue but costs, the margin is undefined (division by zero).

Frequently Asked Questions

What is the difference between net margin and gross margin?

Gross margin subtracts only the direct cost of goods sold from revenue. Net margin subtracts all expenses—operating costs, interest, taxes, and everything else. Net margin is always lower than gross margin unless you have no other expenses, which is rare. For example, a bakery with $10,000 revenue and $4,000 in flour and ingredients has a gross margin of 60%, but after rent, wages, and utilities of $4,500, the net margin is only 15%.

Can net margin be negative?

Yes. If total costs exceed revenue, the margin is negative. That means the business is losing money on every sale. A negative margin is common for startups and during expansions, but it’s not sustainable indefinitely. For example, revenue of $500 and costs of $600 gives a net margin of −20%.

How do I calculate net margin in Excel?

Put revenue in cell A1 and total costs in cell B1. In C1, enter the formula: =(A1-B1)/A1*100. Format C1 as a number with two decimal places. That returns the net margin percentage. If you want it as a decimal, remove the *100 and format as a percentage.

What is a good net profit margin?

It depends on the industry. According to general financial reporting, the average net margin across all industries is around 7–10%, but it ranges from under 2% in grocery retail to over 20% in software and pharmaceuticals. Compare your margin to companies in your own sector and to your own historical trend, not to a universal benchmark.

Does net margin include taxes?

Yes, net margin is calculated after taxes. If you want a margin that excludes taxes, you’d use operating margin or pre-tax margin. The net margin is the “bottom line� after all deductions, including income tax. If you’re comparing companies in different tax jurisdictions, pre-tax margin might be more useful.

How often should I calculate net margin?

Monthly is typical for operational monitoring, and quarterly or annually for reporting to investors. More frequent calculation helps spot trends early, but be careful with seasonal businesses—a single month might not be representative. Always compare the same month year-over-year to account for seasonality.

Related

• Builders Margin Calculator: How to Price Work
• Blended Margin Calculator: How to Use It
• Bill Rate Pay Rate Markup Calculator

in r | Revenue | $ | 1000 | 0
in c | Total costs | $ | 700 | 0
out margin | Net profit margin | % | (r - c) / r * 100 | 2
out profit | Net profit | $ | r - c | 2
out ratio | Cost-to-revenue | % | c / r * 100 | 2