This worksheet shows how to work out gross margin by hand, with the percentage formula, a markup-to-margin conversion table and worked examples for a coffee bar, a salon's retail shelf and services, and a job shop quoting a part. It explains how to read the result before a funding request and the mistakes that distort it. All figures are invented.
Gross Margin Calculator Percentage: The Formula in One Line
Gross margin percentage = (price minus direct cost) divided by price, times 100. Direct cost means the cost of the goods or materials in the sale itself: beans and cups, a bottle of shampoo, bar stock and outside finishing. Rent, wages for front-of-house staff and insurance come later, below the gross margin line.
- Write down the selling price.
- Write down the direct cost of what was sold.
- Subtract cost from price to get gross profit in dollars.
- Divide gross profit by price.
- Multiply by 100 for a percentage.
Gross Margin Calculator Formula Worked for a Coffee Bar
Illustration only, invented figures: a latte sells for $5.50, and its espresso, milk, cup and lid cost $1.32. Gross profit is $4.18, and gross margin is 76% (our arithmetic). The same drink has a markup of 317% on cost (our arithmetic), a much larger number for the same dollars, which is why the two terms should never be mixed up.
Snack and nonalcoholic beverage bars, the Census group that includes coffee shops, counted 136 employer establishments in Larimer County, CO in 2023 (Census County Business Patterns 2023). The coffee shop page covers equipment funding.
Markup vs Margin: The Same Dollars, Two Percentages
| Gross margin | Equivalent markup on cost (our arithmetic) |
|---|---|
| 20% | 25% |
| 25% | 33% |
| 33.3% | 50% |
| 40% | 67% |
| 50% | 100% |
| 60% | 150% |
To price for a target margin, divide cost by (1 minus the margin). Illustration only, invented figures: an item costing $18.00 priced for a 40% margin sells at $30.00 (our arithmetic). Pricing with an invented 40% markup instead would give $25.20 (our arithmetic), and the margin would fall short of the target.
Gross Margin for a Salon's Retail Shelf and Services
Illustration only, invented figures: a shampoo that costs the salon $16.00 sells for $32.00, a 50% gross margin (our arithmetic). Services work differently: if a month's color services bring in $8,200 and the stylist commissions and color product for them cost $4,920, the gross margin on services is 40% (our arithmetic).
Larimer County, CO counted 132 beauty salons with paid employees in 2023 (Census County Business Patterns 2023). The salon page covers equipment and buyouts.
Gross Margin for a Job Shop Quoting a Part
Illustration only, invented figures: a part needs $182.00 in material, outside finishing and machine time at cost, and the shop quotes $260.00. Gross margin on the part is 30% (our arithmetic). Whether machine time belongs in direct cost is a choice; making it the same way on every quote is what keeps margins comparable.
The machine shop page covers CNC financing.
Reading the Result Before a Funding Request
Gross margin shows how much of each sale is left to pay rent, wages and any new loan payment. A partner reading a request may compare the margin with the payment the request would add: a store with thin margins on a large stock order has less room for interest than one with wide margins. Working out margin by product line before a request shows which lines can carry new costs and which cannot.
The inventory financing page works a boutique order with margin and interest side by side.
Mistakes That Distort Gross Margin: Freight, Shrink and Discounts
- Leaving inbound freight out of cost, which overstates margin.
- Ignoring shrink: spoiled, damaged or stolen goods.
- Calculating on list price when discounted sales are common.
- Mixing markup and margin in the same report.
- Counting a supplier rebate in the month it arrives rather than against the goods it relates to.
Gross Margin for a Grocery Department
Illustration only, invented figures: a grocery's produce department sells $42,000 in a month and buys $29,400 of produce, but $2,100 is lost to spoilage. Without counting the loss, gross margin looks like 30%; counting it as part of cost, the margin is 25% (our arithmetic). The difference is why shrink belongs in the calculation for any department with perishable stock. The grocery store page covers coolers and stock.
Gross Margin Across a Year's Statements
A single sale's margin is useful for pricing; the margin across a year's profit and loss statement is what a partner reads. Divide total gross profit by total sales for the year, then compare it with prior years. A falling margin with rising sales can mean discounts or cost increases are eating the growth, which matters before adding a payment.
By Rowanrun Business Loans · Updated