Percentages, Markup, and Margins the Easy Way
Okay. This is the lesson where a lot of people's eyes glaze over, because "percentages" sounds like eighth grade math and nobody wants that back.
But stick with me. This is maybe the single most useful thing in this whole class if you sell anything. And I promise it's less scary than it sounds once you see it in the sheet instead of in your head.
First, let's get the words straight
People mix these up constantly, so let's be clear before we build anything.
Markup is how much you add to your cost to get your selling price. If something costs you $10 and you sell it for $15, you marked it up 50%.
Margin is how much of your final sale price is actually profit. Same $10 item selling for $15 has a margin of about 33%, not 50%.
I know. Same numbers, different answer, and it trips up smart people all the time. It tripped me up. If your margin and your markup number look identical in your head, one of them's wrong.
Building the formulas
Set up three columns. I'm keeping the names boring on purpose because boring names are easier to trust later.
- Column A: Cost (what you paid)
- Column B: Price (what you're charging)
- Column C: Markup %
- Column D: Margin %
For Markup %, the formula is:
`` =(B2-A2)/A2 ``
That's your price minus your cost, divided by your cost. Format that cell as a percent (Format menu, Number, Percent) and you're done.
For Margin %, it's:
`` =(B2-A2)/B2 ``
Same top part, price minus cost. But you divide by the price this time, not the cost. That one little swap is the whole difference between markup and margin. I'd love to give you some deep mathematical reason why that swap matters so much, but honestly, I just know it works. That's one of those things where I trust the formula more than I can explain it 🙈.
Sooo, quick gut check before you move on: pick one row, do the math on your phone calculator, and see if it matches your sheet. Every time. A spreadsheet will tell you a wrong answer with total confidence and never blink. Trust it, but check it against something real first.
Working backward from a target price
Here's the part people actually came for. Say you know you want a 40% margin, and you know your cost. What should you charge?
`` =A2/(1-0.4) ``
Cost divided by one minus your target margin. So if something costs you $12 and you want a 40% margin:
`` =A2/(1-0.4) ``
That gives you $20. Check it: $20 minus $12 is $8, and $8 divided by $20 is 40%. There it is.
Put that formula in your Price column instead of typing prices by hand, and now you've got a pricing sheet that does the annoying math part for you. You just plug in cost, and it tells you what to charge to hit your number.
A quick real-world story
My son Blake asked me to help with a school project a while back. Some kind of report that needed a chart. And normally when Blake wants my help with anything, it's a five-minute thing where he mostly wants me gone.
This time he actually wanted me to sit there with him for the whole hour. So I did. I didn't turn it into a lesson, didn't over-explain every step, just sat next to him and helped where he got stuck. Small thing. But I've thought about it a lot since.
I bring that up because that's kind of how I want you approaching this lesson too. Don't turn percentages into a whole production in your head. Sit down, do the columns, check one row by hand, move on. It doesn't need to be a big deal to be worth doing right.
A word of caution on rounding
Sheets will show you a rounded percent, like 40%, when the real number underneath is 39.6% or 40.4%. If you're pricing tight-margin stuff, click into the cell and check the actual number, not just what's displayed. I've seen people round their way into losing money five cents at a time across hundreds of units. It adds up quiet.
Try this at home
Take five things you sell, or five things you're thinking about selling. Build the four columns. Put in real costs and real prices, or your target margin if you're still figuring out pricing. See what the sheet tells you.
If a margin number surprises you, in either direction, that's not the sheet being wrong. That's the sheet telling you something you didn't know yet. Which, honestly, is the whole point of building one of these in the first place.
Before next time: bring your actual product costs if you've got them. Real numbers make this way more useful than made-up ones, and next lesson we're going to start making this sheet flag stuff automatically.