What is a profit margin calculator?
A tool that estimates how much of your revenue remains as profit after selected costs, expressed as a percentage. This one calculates gross, contribution, operating, and net margin, plus markup, target price, discount impact, break-even, scenarios, SKU comparison, and a downloadable XLSX workbook.
How do I calculate profit margin?
Subtract costs from revenue to get profit, then divide profit by revenue and multiply by 100. With 10,000 revenue and 6,000 cost: profit 4,000, margin 4,000 ÷ 10,000 = 40%.
What is the difference between gross margin and net margin?
Gross margin subtracts only direct costs (COGS). Net margin subtracts everything — direct costs, variable fees, operating expenses, interest, and estimated tax. The gap between them shows how much the cost of running the business consumes.
What is contribution margin?
Profit after every cost that scales with a sale — direct costs plus variable fees like payment processing, marketplace commission, shipping, and ad cost per order — divided by revenue. It is the margin that volume decisions, discounts, and break-even calculations depend on.
What is operating margin?
Profit after direct costs, variable fees, and operating expenses (rent, salaries, software, insurance), divided by revenue — but before interest and tax. It measures how efficiently the whole operation converts revenue into profit.
What is the difference between margin and markup?
Margin divides profit by the selling price; markup divides the same profit by the cost. A 40 profit on a 100 sale with 60 cost is a 40% margin but a 66.7% markup. They are never the same number except at zero.
How do I calculate selling price from a target margin?
Price = Cost ÷ (1 − target margin as a decimal). For a 40% margin on a 60 cost: 60 ÷ 0.60 = 100. The calculator also applies optional price rounding (.99, nearest 5 or 10) and shows the margin after rounding.
How do I calculate markup from margin?
Markup = Margin ÷ (1 − Margin). A 33.3% margin equals a 50% markup; a 50% margin equals a 100% markup. The reverse is Margin = Markup ÷ (1 + Markup).
Why is my gross margin high but my net margin low?
Costs below the gross line are absorbing it: payment and platform fees, shipping, ad spend, refunds, overhead, interest, and tax. The profit waterfall and the diagnosis cards identify which step takes the most.
Should GST/VAT/sales tax be included in revenue?
Generally no — tax collected from customers is a pass-through liability owed to the tax authority, not income. If your selling price includes GST/VAT, use the "tax included" option and the calculator carves it out: net revenue = gross ÷ (1 + rate).
What costs should I include in COGS?
Costs tied directly to what you sold: product or material cost, direct labour, packaging, inbound freight, landed cost. The test: would this cost grow if you sold one more unit?
What costs should I include in operating expenses?
Overhead that exists regardless of any single sale: rent, admin salaries, software subscriptions, utilities, marketing overhead, accounting, legal, and insurance.
How does a discount affect margin?
The full discount comes out of profit because cost does not move. A 10% discount on a 100-price, 60-cost product cuts the price to 90 but the profit from 40 to 30 — margin falls from 40% to 33.3%.
How many more units do I need to sell after a discount?
Required units = original total profit ÷ discounted profit per unit. In the example above, keeping 4,000 of profit needs 4,000 ÷ 30 ≈ 133 units instead of 100 — one-third more volume. If the discounted profit is zero or negative, no volume recovers it.
How do I calculate break-even units?
Break-even units = fixed costs ÷ contribution profit per unit. With 100,000 fixed costs, a 1,000 price and 600 variable cost (400 contribution), break-even is 250 units — 250,000 of revenue.
What is a good profit margin?
It depends on the business model. As soft planning bands: under 5% net is very thin, 5–10% thin, 10–20% moderate, 20–35% healthy, above 35% high. But a 4% net margin can be normal for retail and weak for consulting — use the business-type selector for context, and treat all bands as orientation, not verdicts.
Why does a good margin vary by industry?
Cost structure and volume differ. High-volume businesses (retail, wholesale) survive on thin margins; project and software businesses need wide margins to cover unbilled time and acquisition costs. Location, pricing power, and accounting treatment shift the bands further.
Can profit margin be negative?
Yes — whenever costs exceed revenue at the level being measured. A negative contribution margin is the most serious case: every additional sale increases the loss.
Is this calculator suitable for ecommerce?
Yes — the Ecommerce mode is built for Shopify, Amazon, Etsy, and D2C sellers: discounts, coupons, gateway and marketplace fees, platform and app allocations, ad cost per order, return rate with refund-loss share, RTO cost, monthly fixed costs, break-even orders, and fee/return diagnostics.
Is this calculator suitable for services and freelancers?
Yes — the Service/Project mode prices quotes from labour hours, contractor and tool costs, revenue-based fees, and overhead allocation, computes effective hourly profit, and warns when "profit" depends on unpaid owner time. It also solves the minimum quote for a target margin, correctly handling fees that scale with the quote.
Is this calculator suitable for SaaS?
Yes — the SaaS mode covers MRR, churn, hosting/support costs, payment fees, CAC, gross/contribution/net margin, profit per customer, a simple LTV estimate, CAC payback months, and the MRR needed for a target profit. LTV and payback use a steady-state churn shortcut, not a cohort model.
Can I export the result to XLSX?
Yes — the workbook has 17 sheets generated from your current inputs: README, Summary, Inputs, Profit Breakdown, Margin Formulas, Target Price, Discount Impact, Break-Even, Scenario Analysis, Sensitivity Table, SKU Comparison, Ecommerce/Service/SaaS sheets, Monthly-Annual Plan, Charts Data, and Assumptions. Input cells are editable and the formulas recalculate in Excel, Google Sheets, or Numbers. No sign-in, no macros.
Is this calculator accounting or tax advice?
No. It is an educational planning tool. Estimated tax is a simplified input, not a filing calculation, and the results are not a substitute for bookkeeping or professional advice. Verify decisions against your actual books with a qualified professional.
Why can profit differ from cash flow?
Profit recognises revenue and costs when they are earned or incurred; cash moves when money actually changes hands. Inventory purchases, receivables, loan principal payments, GST/VAT remittances, and tax instalments all move cash without appearing in margin.
How often should a business review margins?
At minimum monthly, and immediately after any supplier price change, platform fee change, shipping rate change, or new discount policy. Margins drift quietly — the businesses that catch it early re-price or re-cost before the damage compounds.