Markup and margin answer different pricing questions, so confusing them can leave a product underpriced even when the markup looks healthy. This guide shows how to build a repeatable markup vs margin calculator using cost, target margin, discounts, and VAT, with worked examples and an editable price ladder you can reuse whenever your inputs change.
Overview
Start with one distinction: markup is calculated from cost, while gross margin is calculated from selling price. Both measure gross profit, but they use different denominators.
- Gross profit = Selling price excluding VAT − Cost
- Markup percentage = Gross profit ÷ Cost × 100
- Gross margin percentage = Gross profit ÷ Selling price excluding VAT × 100
For example, if a product costs 60 and sells for 100 before VAT, gross profit is 40. The markup is 40 ÷ 60 = 66.67%, while the gross margin is 40 ÷ 100 = 40%. Neither result is wrong; they simply describe the same transaction from different bases.
A pricing calculator should therefore keep these stages separate:
- Determine the fully loaded unit cost.
- Choose a target margin or markup.
- Calculate the net selling price before VAT.
- Apply discounts to the correct price.
- Add VAT, where applicable, to show the customer-facing total.
Keeping VAT outside the profitability calculation is usually clearer because VAT collected from a customer is generally treated separately from the seller's revenue. The correct treatment depends on the business, transaction, and applicable rules, so use the relevant tax guidance for your situation.
How to estimate
1. Calculate the required selling price from a target margin
If you know your unit cost and target gross margin, use this formula:
Price before VAT = Cost ÷ (1 − Target margin)
Use the margin as a decimal. A 40% target margin becomes 0.40. If cost is 60 and the target margin is 40%:
60 ÷ (1 − 0.40) = 100
The resulting price is 100 before VAT, producing 40 of gross profit and a 40% gross margin.
2. Calculate the required selling price from a target markup
If your pricing policy uses markup, use:
Price before VAT = Cost × (1 + Markup)
With a cost of 60 and a target markup of 66.67%:
60 × (1 + 0.6667) ≈ 100
To convert a markup into its equivalent margin, use:
Margin = Markup ÷ (1 + Markup)
For example, a 50% markup produces a margin of 50% ÷ 1.50 = 33.33%. To convert margin into markup, use:
Markup = Margin ÷ (1 − Margin)
3. Apply a discount
The discount percentage formula is:
Discount amount = List price × Discount percentage
Discounted price = List price × (1 − Discount percentage)
If the list price is 100 and the discount is 15%, the discounted price is 85 before VAT. The important check is whether the discounted price still produces an acceptable margin:
Discounted margin = (Discounted price − Cost) ÷ Discounted price
With a cost of 60, the result is 25 ÷ 85 = 29.41%. A list price that appeared to offer a 40% margin now produces less after the promotion.
4. Add VAT to show the final price
When the applicable VAT rate is represented by r as a decimal:
VAT amount = Net price × r
VAT-inclusive price = Net price × (1 + r)
If the net price is 85 and the assumed VAT rate is 20%, the VAT-inclusive price is 85 × 1.20 = 102. The VAT-inclusive total is useful for customer communication, but the net price is the figure to use when assessing product margin in this simplified model.
To reverse the calculation:
Net price = VAT-inclusive price ÷ (1 + r)
Inputs and assumptions
A useful markup calculator is only as reliable as its inputs. Record each assumption so another person, or your future self, can understand how the price was produced.
Unit cost
Include the costs that vary with each sale, such as purchase cost, packaging, transaction fees, per-order fulfillment, and shipping subsidies. If a product requires labor, allocate a reasonable per-unit labor cost. A product cost based only on the supplier invoice may overstate profitability.
Fixed-cost allocation
Rent, software, salaries, and other fixed expenses are not normally included in a simple gross margin calculation. However, they still affect the price the business needs to sustain. For a broader decision, use a contribution margin or unit economics model, then compare total contribution with fixed costs.
Target margin or markup
Choose one primary method and label it clearly. Do not enter 40 in a spreadsheet when the formula expects 40%; use 0.40 or format the cell as a percentage. Check that a target margin is below 100%, because the formula becomes invalid at 100%.
Discount rules
State whether the discount applies to the list price, a bundle price, shipping, or a particular customer segment. Also test stacked discounts separately. A 10% discount followed by another 10% discount reduces the original price by 19%, not 20%.
VAT treatment
Enter the applicable rate as an input rather than hard-coding it into a reusable spreadsheet. Show net price, VAT amount, and gross price in separate cells. Do not assume every sale has the same tax treatment; product type, customer location, registration status, and transaction structure may matter.
Worked examples
Example 1: Target margin with a promotional discount
Assume the fully loaded unit cost is 60 and the target margin before promotions is 40%.
- Required list price before VAT: 60 ÷ 0.60 = 100
- 15% discount: 100 × 0.85 = 85
- Gross profit after discount: 85 − 60 = 25
- Margin after discount: 25 ÷ 85 = 29.41%
The calculator reveals that a 15% discount reduces the margin from 40% to about 29.41%. If 40% is a minimum acceptable margin, the seller must either reduce the discount, lower the cost, or set a higher list price.
Example 2: Building a price ladder
A price ladder helps compare several target margins without rebuilding the model. For a unit cost of 60:
- 30% margin: 60 ÷ 0.70 = 85.71
- 40% margin: 60 ÷ 0.60 = 100.00
- 50% margin: 60 ÷ 0.50 = 120.00
Add columns for discount percentage, discounted net price, margin after discount, VAT amount, and VAT-inclusive price. This makes it easy to compare standard, promotional, and premium positioning. Round only the displayed customer price; keep full precision in the calculation cells to reduce cumulative rounding differences.
Example 3: Markup and margin comparison
With a cost of 80 and a 50% markup:
- Price before VAT: 80 × 1.50 = 120
- Gross profit: 120 − 80 = 40
- Markup: 40 ÷ 80 = 50%
- Margin: 40 ÷ 120 = 33.33%
This is why a pricing brief should say either target markup or target margin, not simply target percentage. If a team interprets a 50% target as a margin when it meant markup, the resulting price will be materially different.
When to recalculate
Revisit the calculator whenever a pricing input changes, not only when you are preparing a new product. Recalculate after supplier cost changes, packaging or shipping changes, payment-fee changes, exchange-rate movements, or a change in the labor time required per unit.
Run the model before launching a sale, coupon, bundle, or marketplace promotion. Measure the margin after every discount rather than assuming the list-price margin will remain representative. If customers see VAT-inclusive prices, review the displayed totals after any VAT-rate or tax-treatment update that applies to your transactions.
Review the model periodically against actual results. Compare the assumed unit cost and discount rate with invoices, order data, returns, refunds, and fulfillment costs. If your business sells multiple products, maintain a separate row for each SKU and identify products whose margin falls below the chosen threshold.
For a broader planning view, connect this pricing model to a business spreadsheet template or a contribution-margin analysis. If a price change is part of a larger investment decision, compare its expected profit impact with a business case ROI model. The practical workflow is simple: update cost and tax inputs, test the price ladder, apply realistic discounts, and confirm that the resulting margin supports the wider business plan.
