Profit Margin vs. Markup Calculator Guide for Small Businesses
business calculatorspricingsmall businessprofitabilitytemplates

Profit Margin vs. Markup Calculator Guide for Small Businesses

LLifehackers Editorial Team
2026-11-16
5 min read

Learn the difference between profit margin and markup, with formulas, worked examples, and a pricing worksheet approach for small businesses.

A profit margin calculator and markup calculator answer related but different pricing questions. This guide explains the formulas, shows how to build a repeatable product pricing worksheet, and helps you set a selling price that accounts for direct cost, overhead, discounts, taxes, and target profit.

Overview

Margin and markup are often confused because both describe the difference between what something costs and what you charge. The calculation starts from a different number, however:

  • Profit is selling price minus cost.
  • Profit margin is profit expressed as a percentage of selling price.
  • Markup is profit expressed as a percentage of cost.

For example, if a service costs $50 to deliver and sells for $70, the profit is $20. The markup is $20 divided by $50, or 40%. The margin is $20 divided by $70, or about 28.6%. Both percentages are correct; they simply use different denominators.

This distinction matters when you compare prices, set a target selling price, or review profitability across products. A business that says it wants a 40% markup has not necessarily chosen a 40% margin. In fact, a 40% markup produces a margin of about 28.6% before other costs.

Margin versus markup formula table

What you want to calculateFormula
ProfitSelling price − total cost
Profit marginProfit ÷ selling price × 100
MarkupProfit ÷ cost × 100
Selling price from markupCost × (1 + markup rate)
Selling price from target marginCost ÷ (1 − target margin rate)

How to estimate

Start with a product pricing calculator or spreadsheet that separates costs rather than entering one vague cost estimate. A useful worksheet can contain these columns:

  1. Item or service name
  2. Direct materials, contractor, or delivery cost
  3. Labor time and labor cost
  4. Allocated overhead
  5. Total cost
  6. Target markup or target margin
  7. Base selling price
  8. Expected discount
  9. Net selling price
  10. Profit and realized margin

For a markup-based calculation, add the markup to one. A total cost of $50 with a 40% markup gives: $50 × 1.40 = $70.

For a margin-based calculation, divide cost by one minus the target margin. A total cost of $50 with a 30% target margin gives: $50 ÷ 0.70 = $71.43. The resulting profit is $21.43, which is 30% of the $71.43 selling price.

If you offer discounts, calculate the required list price from the amount you need to receive after the discount. For a required net price of $71.43 and a planned 10% discount, use $71.43 ÷ 0.90 = $79.37. This prevents a discount from quietly reducing the intended margin.

Spreadsheet formulas can make this repeatable. If total cost is in cell B2 and target margin is in C2, the price formula is =B2/(1-C2). If the target markup is in C2, use =B2*(1+C2). Format percentage inputs consistently as decimals or percentage values so the formulas do not mix units.

Inputs and assumptions

The quality of a margin estimate depends on the costs included. Direct cost is usually the easiest starting point, but it may not be the full economic cost of producing or delivering an item.

Include the costs that pricing decisions need

  • Direct costs: materials, packaging, payment processing, shipping paid by the business, and labor directly tied to the sale.
  • Overhead: software, rent, insurance, equipment, administration, and other operating expenses. Allocate these carefully rather than assigning an arbitrary amount to every item.
  • Variable selling costs: commissions, marketplace fees, refunds, and promotional expenses that increase with sales.
  • Capacity and time: for services, include realistic delivery hours and non-billable work such as revisions, preparation, scheduling, and support.

Keep taxes separate from profit whenever possible. Sales tax, VAT, or similar consumption taxes may be collected from the customer and remitted rather than treated as business revenue, but treatment depends on the transaction, jurisdiction, registration status, and accounting method. Use the applicable local rules or confirm the treatment with a qualified adviser. Your worksheet should show whether a price is tax-inclusive or tax-exclusive so the comparison is clear.

Also document assumptions beside the calculation: expected volume, discount rate, payment terms, currency, return rate, and whether labor is valued at an internal hourly rate. A calculator is more useful when another person can understand and update it without guessing what each number means.

Worked examples

Example 1: comparing markup and margin

Suppose a creator sells a packaged service. Direct delivery cost is $35 and allocated overhead is $15, producing a total cost of $50.

  • At a 40% markup: $50 × 1.40 = $70 selling price.
  • Profit: $70 − $50 = $20.
  • Margin: $20 ÷ $70 = 28.6%.

If the goal is a 40% margin instead, the selling price is $50 ÷ 0.60 = $83.33. Profit is $33.33, and $33.33 ÷ $83.33 equals 40%. This is why a business should state whether its target is margin or markup before setting prices.

Example 2: accounting for a planned discount

Using the same $50 total cost and a 30% target margin, the required net price is $71.43. If customers are expected to receive a 15% discount, calculate the list price as $71.43 ÷ 0.85 = $84.04. A 15% discount from $84.04 leaves approximately $71.43 before any applicable tax, preserving the planned margin under this simplified assumption.

These examples do not predict demand or guarantee profitability. They show the arithmetic needed to test a price. You can add scenarios for lower volume, higher labor time, supplier cost increases, refunds, or different discount levels to see how sensitive the result is.

When to recalculate

Revisit your profit margin calculator whenever a pricing input changes, not only at year-end. Recalculate when a supplier changes rates, software or payment fees increase, delivery time expands, exchange rates affect costs, or your discount policy changes. Service providers should also recalculate when a project consistently takes longer than estimated.

A practical review rhythm is to check high-volume or low-margin products regularly, then review the full pricing worksheet during a quarterly planning session. Compare estimated costs with actual costs and record the date of each revision. If a price increase is under consideration, test several scenarios: the current price, the proposed price, a likely discount, and a higher-cost case.

Before publishing a new price, confirm three things: the worksheet uses the correct tax treatment, the target is clearly labeled as margin or markup, and the final price reflects the time and overhead required to deliver the offer. Save a clean copy of the template so you can reuse it for the next product, service, price increase, or quarterly profitability review.

Related Topics

#business calculators#pricing#small business#profitability#templates
L

Lifehackers Editorial Team

Business Tools Editor

Senior editor and content strategist. Writing about technology, design, and the future of digital media. Follow along for deep dives into the industry's moving parts.