Resources
Margin vs. markup: formulas, charts, and common mistakes (August 2026)
No items found.

Margin vs. markup: formulas, charts, and common mistakes (August 2026)

The Puzzle Team
8.5.26
In article:

If you've ever set a price using a markup percentage and assumed your gross margin percentage would match, this is for you. The margin versus markup calculation works differently depending on which number sits in the denominator, and confusing the two is how founders quietly underprice products by double digits. We're going to cover the markup vs margin formula, a margin versus markup chart, real examples, conversion tables, and how to build a margin vs markup calculator in Excel so the math stops being a guessing game.

TLDR:

  • Margin divides profit by revenue; markup divides profit by cost. Same $40 profit reads as 40% margin or 67% markup.
  • Applying a 40% markup when you want 40% margin leaves you with only 28.6% margin, quietly eroding your runway.
  • Use markup to set prices, use margin to measure results and report to investors.
  • A 30% margin equals 42.9% markup; a 25% markup equals 20% margin. These are the two most common conversion mistakes founders make.
  • Puzzle keeps your gross margin current daily so pricing decisions never rely on stale numbers.

What profit margin means

Profit margin tells you how much of each revenue dollar survives after covering the cost of what you sold. The formula:

Profit Margin = (Revenue - Cost) / Revenue × 100

Take a product that sells for $100 with a $60 cost. The math: ($100 - $60) / $100 × 100 = 40%.

The denominator is what defines margin. Revenue sits at the bottom, so margin always measures profit as a share of what came in. A 40% margin means 40 cents of every dollar earned is profit. That framing, anchored to revenue, is what separates margin from every other way of expressing profitability.

What markup means

Markup also starts from the gap between revenue and cost, but the denominator changes. The formula:

Markup = (Revenue - Cost) / Cost × 100

Same example: a $100 product with a $60 cost. The math: ($100 - $60) / $60 × 100 = 66.7%.

Cost sits at the bottom now. Markup measures profit as a share of what you spent, not what you earned. Where margin asks how much of each incoming dollar you kept, markup asks how much above cost you charged. A 66.7% markup means the price is 66.7% higher than the cost basis.

That shift in denominator is why the same $40 profit looks so different depending on which figure you use.

The core difference between margin and markup

Both terms measure profitability, but they start from different places in the math.

Margin is calculated as a percentage of the selling price. Markup is calculated as a percentage of the cost. Same dollar profit, two completely different percentages, and that gap is where founders consistently make mistakes.

Here is the clearest way to see it:

The formulas behind those numbers:

  • Margin (%) = (Selling Price minus Cost) divided by Selling Price, multiplied by 100
  • Markup (%) = (Selling Price minus Cost) divided by Cost, multiplied by 100

Because markup divides by a smaller number (cost), it always produces a higher percentage than margin for the same transaction. A 40% margin is not the same as a 40% markup, and confusing the two can mean you are pricing products below what you actually need to stay solvent.

Why the starting point matters

Margin works backward from revenue, which is why it maps cleanly onto your income statement and the gross margin line your investors will examine closely. Markup works forward from cost, which makes it useful for setting prices at the point of purchase or in wholesale contexts.

Neither is wrong. They answer different questions: margin tells you what percentage of each dollar of revenue you kept, while markup tells you how much you added on top of what you paid.

Margin and markup formulas

Two formulas do all the heavy lifting here. Knowing them cold means you can price on the fly without second-guessing yourself.

Margin formula

Margin = (Selling Price - Cost) / Selling Price

A $100 product that costs you $60 to make carries a 40% gross margin: ($100 - $60) / $100 = 0.40.

Markup formula

Markup = (Selling Price - Cost) / Cost

That same product carries a 67% markup: ($100 - $60) / $60 = 0.667.

Same dollars of profit, two very different percentages because the denominator flips between the two calculations.

The gap between the two numbers widens as your margins get thinner, which is exactly why mixing them up in a pricing conversation can mean quoting a deal that loses money.

Margin vs. markup conversion chart

The quickest way to move between margin and markup without a formula is a reference table. Here are the most common conversions founders and operators actually use:

Margin and markup conversion table

Margin %Markup %
10%11.1%
20%25.0%
25%33.3%
30%42.9%
40%66.7%
50%100.0%

A few patterns worth noticing as you read this table:

  • Markup is always a higher number than the equivalent margin, which is why quoting markup to someone expecting margin will always make your profitability look better than it is.
  • At a 50% margin, markup hits 100%. That is the point where you have doubled your cost.
  • The gap between the two numbers widens as profitability increases, so the higher your margins, the more misleading it becomes to conflate the two figures.

If you are working backward from a specific target, the most common scenarios founders ask about are 30% margin to markup (42.9%) and 25% markup to margin (20%). Bookmark those two, and you will cover most real-world pricing conversations.

Real-world margin vs. markup examples

Three numbers that show how this plays out in practice:

  • A coffee shop prices a latte at $5 with a $2 cost. Markup is 150%, but the margin is only 60%. A new owner assuming 150% markup means 150% margin would wildly misread profitability.
  • A SaaS founder prices a $99/month plan with $33 in hosting and support costs. That's a 200% markup, but a 67% gross margin. Investors asking about margins want the 67% figure.
  • A retailer adds 25% markup to a $80 wholesale item, selling it for $100. Their margin is 20%, not 25%.

In each case, the markup is higher than the margin. That gap is where pricing mistakes happen.

When to use markup vs. margin

Markup works better when you're thinking from cost outward: you know what something costs, you want to apply a standard multiplier, and you're pricing on the fly. Retail, wholesale, and manufacturing businesses often default to markup for this reason.

Margin is the right lens when you're working backward from revenue: tracking gross profit, modeling unit economics, or reporting to investors. Most financial statements, SaaS benchmarks, and fundraising conversations run on margin.

A practical rule: use markup to set prices, use margin to measure results.

Common margin vs. markup mistakes founders make

Confusing margin and markup costs founders real money, and the errors tend to cluster around a few predictable patterns. Strategic CFO on markup vs. margin pricing covers why consistent use of one metric matters across your product lines.

  • Pricing backward from markup when your target is a margin: if you want 40% gross margin and you apply a 40% markup instead, you end up with only 28.6% margin. That gap quietly erodes your runway.
  • Using markup to report profitability to investors: investors and lenders read financials using margin percentages, not markup. Presenting a 67% markup as your "profit" creates confusion and undermines credibility in fundraising conversations.
  • Applying different metrics inconsistently across product lines: mixing margin on some SKUs and markup on others makes it nearly impossible to compare profitability across your catalog or spot where you're actually losing money.
  • Forgetting that margin has a ceiling of 100% while markup does not: founders sometimes set markup targets above 100% without realizing the implied margin is already well above what the market will bear.

The root cause is almost always that the two numbers feel interchangeable until they aren't. At low price points the gap is small enough to ignore. At scale, or when a single pricing decision touches thousands of units, the compounding difference between a 50% markup (33.3% margin) and a genuine 50% margin becomes a material line on your P&L.

How to build a margin vs. markup calculator in Excel

Four columns cover everything you need: cost, selling price, margin, and markup. Here is a simple setup that auto-calculates both figures from a single cost and price input.

Excel formula layout

Start with these column headers in row 1: Cost (A), Selling Price (B), Gross Profit (C), Margin % (D), Markup % (E).

  • Column C (Gross Profit): =B2-A2
  • Column D (Margin %): =C2/B2
  • Column E (Markup %): =C2/A2

Format columns D and E as percentages. Every row you add will auto-calculate both metrics instantly.

Converting between margin and markup

Add two utility cells anywhere on the sheet:

  • Margin to markup: =D2/(1-D2)
  • Markup to margin: =E2/(1+E2)

These let you toggle between the two without rebuilding anything. If a vendor quotes you a 30% markup, paste that into the markup cell and the margin cell will show you the real 23.1% margin automatically.

A note on what the calculator will tell you

The math is simple, but having it live in a spreadsheet removes the mental overhead so you stop defaulting to whichever number feels right in the moment.

Industry benchmarks for margin and markup

Margins vary widely by industry, so knowing where your business sits helps you price with confidence and avoid guessing. NYU Stern's margin data by sector is a reliable reference for checking where your industry typically lands.

Typical margin and markup ranges by sector

Here are common gross margin benchmarks across industries, with the implied markup at each level:

The same product with a 50% markup yields a 33% margin. Whether that's healthy or thin depends entirely on your sector.

  • SaaS founders often see high gross margins but burn through them quickly on sales and R&D, so tracking net margin separately matters.
  • Retail businesses running below 30% margin leave almost no room to absorb freight, returns, or shrinkage without going negative.
  • Service businesses tend to confuse labor cost recovery with profit, which is where the margin versus markup mix-up causes the most damage.

Use these ranges as a gut-check when setting prices. If your margin falls well below your industry's floor, your markup formula may be the culprit.

How Puzzle gives founders real-time margin visibility

Knowing the right formulas is half the problem. Having accurate, current numbers to apply them is the other half.

Puzzle automates up to 98% of transaction categorization and cuts reconciliation time by up to 96% (2 hours down to 5 minutes), so your P&L updates daily. Your gross margin is never three weeks stale when a burn rate or pricing call needs it.

Puzzle also maintains simultaneous cash and accrual books, which matters because investors want accrual-basis gross margin, and having both versions live removes ambiguity during burn rate and runway conversations.

For accounting firms supporting startup clients, Puzzle's AI agents cut month-end close time by up to 50%, with accurate client financials ready by the 4th business day of each month.

Final thoughts on margin vs. markup for founders

Confusing margin and markup feels minor until it isn't. A 40% markup is not a 40% margin, and at scale that gap shows up as a real number on your P&L. Now that you know the formulas, the conversion table, and when each metric applies, you can price and report with confidence. Book a demo to see how Puzzle keeps your gross margin accurate and up to date so the right number is always there when you need it.

FAQ

What's the difference between margin vs. markup formula calculations?

Both use the same numerator (selling price minus cost), but the denominator is what separates them: margin divides by selling price, markup divides by cost. On a $100 product with a $60 cost, that produces a 40% margin versus a 66.7% markup. Same $40 profit, two very different percentages that will not behave interchangeably in pricing or investor conversations.

I want 40% gross margin on my product. What markup percentage do I apply?

A 40% margin requires a 66.7% markup, not a 40% markup. Applying a 40% markup when your target is a 40% margin leaves you with only 28.6% margin instead, a gap that compounds fast across thousands of units. Use the conversion formula: markup equals margin divided by (1 minus margin), or keep the markup vs. margin chart in this post bookmarked for quick reference.

When should I use markup vs. margin for my startup's pricing and reporting?

Use markup to set prices when you know your costs and need a quick multiplier at the point of purchase. Use margin to measure results: for your income statement, unit economics modeling, and any conversation with investors, who read financials in margin terms, not markup. A practical rule: markup sets the price, margin tells you whether the business is working.

How do I build a margin vs. markup calculator in Excel without starting from scratch?

Four columns cover everything: Cost (A), Selling Price (B), Gross Profit (C = B minus A), Margin % (D = C divided by B), Markup % (E = C divided by A). Format D and E as percentages and every row auto-calculates both figures. Add two utility cells for conversion: margin to markup uses the formula D divided by (1 minus D), and markup to margin uses E divided by (1 plus E). That covers the full markup vs. margin formula calculator workflow without any manual math.

Can Puzzle show me my gross margin in real time instead of waiting for month-end close?

Yes. Puzzle automates up to 98% of transaction categorization and cuts reconciliation time by up to 96%, so your P&L updates daily instead of sitting three weeks stale when a pricing decision needs it. Puzzle also maintains simultaneous cash and accrual books, which means your accrual-basis gross margin (the number investors will ask for) is always current alongside your daily cash position.

Let us help you solve your financial puzzles.

Thank you for being part of our Puzzle community. Stay tuned!
Oops! Something went wrong while submitting the form.
You can unsubscribe at any anytime.

Newsroom

No items found.