01Free Online Calculator + Excel Workbook
Margin Calculator: Gross Margin, Markup & Selling Price
Free margin calculator: find gross margin, markup and selling price from cost, and see what a discount does to your profit. Excel price list included.
Margin and Markup Calculator
Margin vs. Markup: Same Profit, Two Percentages
Margin and markup describe the same dollars of profit against different bases. Margin is profit as a share of the selling price; markup is profit as a share of cost. An item that costs $60 and sells for $100 earns $40: a 40% margin and a 66.7% markup.
| Markup on cost | Gross margin | Price for a $60 cost |
|---|---|---|
| 25% | 20.0% | $75.00 |
| 33.3% | 25.0% | $80.00 |
| 50% | 33.3% | $90.00 |
| 66.7% | 40.0% | $100.00 |
| 100% | 50.0% | $120.00 |
The classic pricing mistake is to add the target margin to the cost. Adding 40% to $60 gives $84 and a margin of only 28.6%. To earn a 40% margin, divide: $60 ÷ (1 − 0.40) = $100.
What a Discount Really Costs
A discount comes straight out of profit, because the cost does not move. On the $100 item with a 40% margin, a 10% discount leaves $30 of profit instead of $40. To earn the same gross profit you now need to sell 33% more units.
| Discount on a 40% margin | Margin after discount | Extra units needed for the same profit |
|---|---|---|
| 5% | 36.8% | +14% |
| 10% | 33.3% | +33% |
| 15% | 29.4% | +60% |
| 20% | 25.0% | +100% |
The Excel price list applies the same math to 30 items at once: enter costs and a target margin, compare with your current prices and test a discount across the whole list. In Draivix, every line of a quote or sales order is priced from the product catalog and price lists, so the person quoting works from current costs and agreed prices instead of last year's spreadsheet.
02Frequently Asked Questions
How do I calculate selling price from cost and margin?
Divide the cost by 1 minus the margin. For a $60 cost and a 40% target margin: 60 ÷ (1 − 0.40) = $100. Multiplying the cost by 1.40 gives $84, which is a 40% markup but only a 28.6% margin.
What is the difference between margin and markup?
Both measure the same profit. Margin divides it by the selling price, markup divides it by the cost. A 50% markup equals a 33.3% margin; a 100% markup equals a 50% margin.
Can margin be more than 100%?
No. As long as the cost is above zero, gross margin stays below 100%, because profit can never exceed the price. Markup has no upper limit: selling a $60 item for $180 is a 200% markup and a 66.7% margin.
How do I convert markup to margin?
Margin = markup ÷ (1 + markup). A 25% markup is 0.25 ÷ 1.25 = 20% margin. The other way round, markup = margin ÷ (1 − margin).
03More Free Tools
Related Templates & Calculators
- PTO Accrual Calculator: Per Pay Period & Balance (Free)Free PTO accrual calculator: hours earned per pay period and per hour worked, balance today and at year end. Excel tracker for the whole team included.Open
- Timesheet Template: Weekly, Biweekly, Monthly (Excel, PDF)Free timesheet template in Excel and printable PDF: weekly, biweekly and monthly sheets with lunch breaks, automatic hours and overtime after 40 hours.Open
- Employee Schedule Template: Weekly Work Schedule (Excel)Free weekly employee schedule template in Excel and PDF: shifts for 12 employees, hours per person, staff per day and a flag for weeks over 40 hours.Open
- Invoice Template: Free Excel & Printable PDF (US)Free invoice template in Excel and PDF for US businesses: line items, sales tax rate, shipping, Net 30 due date and automatic totals. No sign-up.Open
Let’s start together
Tell us how your business works.
We will show you what a system that takes over part of that work could look like.
Book a consultation