Business & Spreadsheet Calculators

Business & Spreadsheet currently holds one live calculator: the Markup Calculator, which converts between cost, selling price, markup percentage, and margin percentage in either direction. That's a narrower scope than the category name might suggest, and rather than pad this page with tools that don't exist yet, it focuses on one calculation done well, plus the pricing math around it — because markup and margin are two of the most commonly confused numbers in small-business pricing.

The confusion isn't really about arithmetic; it's about which number a formula divides by. Markup measures profit against what you paid — the cost. Margin measures the identical profit against what the customer paid — the selling price. Both are legitimate, both describe the same sale, and neither is wrong on its own. The trouble starts when someone has a margin target in mind but reaches for a markup formula, or the reverse, without realizing the two produce different selling prices.

A 50% markup is not a 50% margin, even though both describe the exact same sale. Take a $40 item marked up 50%: it sells for $60 (40 × 1.50), and the $20 of profit is 50% of the $40 cost — that's the markup. But that same $20 is only 33.33% of the $60 selling price, so the margin on that sale is 33.33%, not 50%. One sale, one profit figure, two correct but different percentages depending on the denominator.

The two percentages convert cleanly with a small formula pair: margin equals markup divided by (1 plus markup), and markup equals margin divided by (1 minus margin), both worked as decimals. A 25% markup converts to a 20% margin; a 50% markup converts to 33.33% margin; a 100% markup converts to exactly 50% margin. Margin is always the smaller of the two numbers on a profitable sale, and the gap between them widens as the percentage climbs higher.

Markup is the more natural tool for pricing a single item, because it's applied directly to a number you already know: cost. A retailer buying stock at $40 a unit and wanting a 50% markup simply multiplies by 1.50 to land on $60. That's why markup shows up so often in point-of-sale systems, wholesale price lists, and quick per-item pricing decisions — it starts from a known input and produces a price in one step.

Margin matters more once the question shifts from "what do I charge for this item" to "is the business actually profitable." Margin percentage funds everything that isn't the direct cost of goods — rent, payroll, marketing. A business that prices every item off a markup target without checking the resulting margin can end up with sales that look fine individually while overall profitability quietly erodes as overhead grows. The two numbers answer different questions, and a pricing decision that only checks one is incomplete.

Break-even doesn't need its own calculator — it's a two-input formula built on the same subtraction the Markup Calculator already does. Take a product selling for $25 with $16 of variable cost per unit. Subtract the two and you get $9 of contribution margin per unit, or 36% of the selling price. If the business carries $8,400 a month in fixed costs — rent, salaried staff, insurance — dividing that by $9 gives a break-even point of 934 units a month, or $23,350 in revenue. Sell fewer than that and the month runs at a loss; sell more and every extra unit contributes $9 straight to profit.

The formula only works if the subtracted cost is variable cost per unit, not the fully loaded cost — folding rent into a per-unit figure before finding contribution margin understates how many units are actually needed.

That 36% is also where contribution margin and the margin percentage in the Markup Calculator quietly diverge, even though both divide by the same $25 selling price. Contribution margin subtracts only variable cost, because it exists to answer a volume question — how many units cover fixed costs. Margin, as most people use the Markup Calculator, subtracts the fully loaded cost, overhead included. Add $4 of allocated overhead to that same product and total cost becomes $20, dropping the margin to 20% — 16 points lower than the 36% contribution margin, on the identical sale. Neither figure is wrong; they just answer different questions, and running a break-even count off the loaded-cost margin instead of contribution margin will understate how many units are actually needed.