By FileToolsHub Editorial · Published 2026-09-27 · Business
How to Calculate Profit Margin
Gross and net margin from revenue and costs, using spreadsheet math or FileToolsHub's profit margin calculator.
Profit margin expresses how much of each revenue dollar you keep after costs — as a percentage. Founders, freelancers, and ecommerce sellers use it to price products, spot inefficiency, and explain performance to partners without sharing raw ledgers. Investors compare gross margin across quarters to see whether pricing or COGS moved; net margin tells whether rent and payroll stayed under control.
Gross margin
Gross profit = Revenue − Cost of Goods Sold (COGS). Gross margin % = (Gross profit / Revenue) × 100. COGS includes direct materials, manufacturing labor, and shipping inbound — not office rent or ads. If you sell a $50 item that costs $20 to make and ship, gross profit is $30 and gross margin is 60%.
Net margin
Net profit subtracts operating expenses, taxes, and interest. Net margin % = (Net profit / Revenue) × 100. This aligns closer to bottom-line profitability but swings with one-time charges. Compare gross vs net to see whether overhead or COGS is the problem. Freelancers quoting day rates should back into margin after software, insurance, and unpaid admin time — revenue alone overstates take-home.
Spreadsheet setup
Two columns: Revenue and each cost bucket. Sum COGS for gross; sum all expenses for net. Format result cells as percentage. Keep periods consistent — monthly vs quarterly mixes mislead.
FileToolsHub calculator
/tool/profit-margin-calculator accepts revenue and cost inputs and returns margin percentages. Use it when reviewing a single SKU, a campaign, or a draft price change. Convert between markup and margin with /tool/markup-calculator — markup on cost is not the same as margin on price. Commission-only sales still carry COGS on physical goods — subtract product cost before celebrating revenue.
Pricing decisions
Target margin backs into price: Price = Cost / (1 desired margin) for margin on price. Know which definition your retailer contract uses. Watch discount stacks — /tool/discount-stack-calculator shows effective price after layered promos.
Present margins to stakeholders
Label charts gross versus net so finance and sales meetings do not talk past each other. When margin drops, split the story: did COGS rise (supplier, freight), did price fall (discounts), or did overhead swell (new hires)? /tool/profit-margin-calculator gives quick what-if on a SKU; your accounting system remains the authority for tax and audit. If you use /tool/markup-calculator, remember markup is on cost while margin is on price — quoting the wrong one erodes trust in pricing negotiations.
Channel mix distorts company margin: marketplace fees belong in COGS or a separate line but must be consistent quarter to quarter. Shipping subsidies you absorb shrink net margin even when gross looks healthy. Compare margin before and after returns and chargebacks if your platform provides net payment reports. SaaS founders should watch gross margin after hosting and payment processing before celebrating ARR. When giving discounts, compute margin on the discounted price, not the list price on the tag. Board slides often show gross margin trend and net margin trend on separate axes to avoid one masking the other.
Wholesale and retail price lists should document whether MSRP is pre-tax or VAT-inclusive so margin math matches cash collected. When outsourcing production, include freight-in and duty in COGS instead of burying them in overhead if you want SKU-level accuracy. Seasonal write-downs of inventory are accounting events separate from everyday gross margin — do not mix clearance pricing into the standard calculator without relabeling the scenario.
Wholesale and retail price lists should document whether MSRP is pre-tax or VAT-inclusive so margin math matches cash collected. When outsourcing production, include freight-in and duty in COGS instead of burying them in overhead if you want SKU-level accuracy. Seasonal write-downs of inventory are accounting events separate from everyday gross margin — do not mix clearance pricing into the standard calculator without relabeling the scenario.
FAQ
Which margin do investors ask for? Depends on stage and sector; SaaS often emphasizes gross margin, mature retail net.
Can margin exceed 100%? Not on price-based margin; markup formulas can confuse — stick to (profit/revenue).
Are taxes in net margin? Yes for accounting net; operational EBITDA excludes some items — be consistent in conversations.
Does the calculator replace bookkeeping? No — it quick-checks arithmetic; your ledger remains source of truth.