How to use the profit margin calculator
The Profit & margins tool follows a profit and loss statement line by line. Use one period throughout; a full year avoids seasonal swings.
- Revenue. Net sales after returns, refunds and discounts.
- Cost of goods sold (COGS). The direct cost of what you sold: inventory, materials, production labor and inbound freight.
- Operating expenses. Enter one total, or switch to Itemized to enter salaries, rent, marketing and other costs separately. Leave out depreciation here, because it has its own field.
- Depreciation and amortization. The yearly write-down of equipment, vehicles and other long-lived assets, as shown in your accounts.
- Interest and tax. Interest on business debt, and the tax rate on pre-tax profit. The default 21% is the US federal corporate rate; S corporations, partnerships and sole proprietors are taxed at the owner level, so enter 0 for them.
The chart traces revenue down to net profit, and the table shows every line as a share of revenue. The Price for a target margin tool returns the price for a unit cost and the gross margin you want.
How profit and margins are calculated
Each level of profit subtracts one more group of costs:
Operating profit (EBIT) = Gross profit − Operating expenses − Depreciation & amortization
Pre-tax profit = Operating profit − Interest expense
Net profit = Pre-tax profit − Income taxIncome tax = Pre-tax profit × tax rate, and zero when pre-tax profit is negative. EBITDA, also shown, is operating profit before depreciation and amortization.
Each margin divides one of those profits by revenue:
Operating margin = Operating profit ÷ Revenue
Net margin = Net profit ÷ RevenueAll three divide by the same revenue, and each step only subtracts costs, so gross margin is always the highest of the three and net margin the lowest.
For the second tool, the price that delivers a target gross margin is:
A worked example
Company A, a small wholesaler, had $1,200,000 of sales last year. The goods it sold cost $720,000, leaving a gross profit of $480,000, a gross margin of 40.0%.
Running the business cost $300,000 in salaries, rent, marketing and other overheads, plus $30,000 of depreciation. That leaves an operating profit of $150,000 and an operating margin of 12.5%.
After $15,000 of interest, pre-tax profit is $135,000. Tax at 21% takes $28,350, so the net profit is $106,650: a net margin of 8.9%.
Put another way, 60.0% of every sales dollar pays for the goods and 27.5% covers operating costs and depreciation. If Company A were a pass-through business and you set the tax rate to 0, net profit would be $135,000 before the owners pay their own income tax.
Gross, operating and net margin: what each one tells you
Looking at only one margin can hide a problem.
- Gross margin measures pricing and purchasing. When it falls, costs are rising faster than prices or the sales mix has shifted toward cheaper products.
- Operating margin adds the cost of running the business and shows whether overheads are in proportion to sales. Two firms with the same gross margin can differ widely here if one carries a large office or sales team.
- Net margin is what is left for the owners after lenders and tax. It depends on financing and tax status, so it is the weakest measure of operations, but it is the profit that funds growth and payouts.
Margins vary widely by industry. A grocery store, a restaurant, a manufacturer and a software company can all be well run with completely different margins, because their costs sit in different places. Compare your margins with your own history and with businesses that sell in the same way, not with a general target.
What moves net profit most
Small changes near the top of the income statement have large effects at the bottom, because fixed overheads do not change with them. Each line changes one thing from the example:
| Change | Net profit | Net margin |
|---|---|---|
| The example | $106,650 | 8.9% |
| Prices up 5%, same volume | $154,050 | 12.2% |
| Volume up 10%, same prices and overheads | $144,570 | 11.0% |
| Cost of goods 5% lower | $135,090 | 11.3% |
| Operating expenses 10% lower | $130,350 | 10.9% |
A 5% price rise adds more net profit than selling 10% more units, because the extra volume brings its own cost of goods, while a price rise drops straight to the bottom line if customers stay. That is the reason pricing deserves as much attention as cost cutting. The catch is that customers may buy less at the higher price, which this table does not model; the break-even calculator shows how far volume could fall before a price change stops paying off.
Pricing for a target margin
The second tool answers a common pricing question: what must I charge to keep a given share of each sale? With a $60 unit cost, a 40% gross margin needs a price of $100.00, which is a markup of 66.7% on cost.
Adding 40% to the cost instead would give $84.00, a margin of only 28.6%; the markup vs margin calculator explains that common error. The price climbs quickly as the target rises: a 30% margin on the same cost needs $85.71, a 60% margin $150.00.
What this calculator does not include
The calculator applies one flat tax rate to positive pre-tax profit. Real tax bills depend on deductions, credits, state taxes, losses carried forward and, for pass-through businesses, the owners’ personal brackets. There is no line for other income or expenses, such as investment income or a one-off write-off; add other expenses to the interest figure, or subtract other income from it, to include them.
It also measures profit, not cash. Profit counts sales when they are made and equipment as it wears out, while cash moves when customers pay and when you buy assets, so a profitable business can still run short of cash. Finally, the margins do not show whether the business earns enough on the money invested in it.