Skip to content

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.

Gross margin(Price − Cost) ÷ Price
Markup(Price − Cost) ÷ Cost
Price from marginCost ÷ (1 − Margin)
Download30-line Excel price list
Gross margin · markup · selling price · discount impact

Margin and Markup Calculator

Gross margin40%Profit $40.00 per unit
Markup on cost66.67%Profit ÷ cost
Selling price$100.00Cost $60.00
Margin after a 10% discount33.33%Sell 33.33% more units to earn the same profit

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 costGross marginPrice 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% marginMargin after discountExtra 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).

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