Construction markup vs margin calculator and worked examples

What markup and margin measure

Markup measures the amount added as a percentage of the cost basis. Margin measures the amount above that cost as a percentage of the selling price. Both use the same difference between cost and price, but divide it by different numbers.

For a £4,000 cost and £5,000 price, the difference is £1,000. Divide £1,000 by £4,000 to get 25% markup. Divide it by £5,000 to get 20% margin. These are two descriptions of the same offer, not two different profits.

Always name the denominator when comparing figures. A supplier, colleague or spreadsheet may say "20%" without specifying whether it means markup or margin. Ask which basis applies before using the figure in a proposal or assuming the job meets your target.

How to use the calculator

Open the attached workbook in Excel or a compatible spreadsheet editor. Enter the cost in pounds in the yellow cells, then type the percentage as a whole number, such as 20 for 20%. The target-margin and markup columns calculate selling prices, the amount above cost and both percentage measures side by side.

The starting example uses £4,000 cost and 20% in both columns. The target-margin column gives £5,000 while the markup column gives £4,800. Keep the same cost and percentage in both columns when comparing methods, or enter different assumptions to explore their effect. The worked-examples tab supplies reference figures.

Save your own copy of the Excel file for each estimate so the inputs remain available for review. Leave the formula cells intact and edit the yellow inputs. The print layout is set up for the calculation and notes, so you can print the worksheet or export a PDF from your spreadsheet application when sharing the result.

The workbook validates normal input entry and shows "Check inputs" for invalid cost or percentage values. A zero or negative cost and a margin of 100% or more do not produce a useful finite price under this formula. Displayed currency rounds to pennies, while formulas retain unrounded values. Pasting over a formula cell removes that calculation, so start from a clean copy if needed.

The formulas behind the result

To calculate a price from markup, multiply cost by one plus the markup expressed as a decimal. With £4,000 and 20%, the calculation is £4,000 × 1.20 = £4,800. The added amount is £800.

To calculate a price from target margin, divide cost by one minus the margin expressed as a decimal. With £4,000 and 20%, the calculation is £4,000 ÷ 0.80 = £5,000. The added amount is £1,000.

Convert markup to margin by dividing markup by 100 plus markup, then multiplying by 100. A 25% markup gives 25 ÷ 125 × 100 = 20% margin. To convert margin to markup, divide margin by 100 minus margin and multiply by 100.

The percentages diverge further as they rise. A 50% markup corresponds to a 33.33% margin. A 50% target margin requires a 100% markup. Do not substitute one column for the other simply because both contain a percentage sign.

Build the cost basis before choosing the percentage

Suppose you are pricing a small joinery package with £1,800 labour, £1,500 materials, £300 hired equipment and £400 other allocated project costs. Those inputs total £4,000. The calculator does not inspect the completeness of those categories; it prices whatever cost you enter.

Decide whether the basis includes only direct job costs or also an allocation for business overheads. Keep the distinction visible in the estimate. If you enter direct costs alone, the amount above them still has to contribute to overheads before it can describe a net business result.

Avoid including an overhead allowance in both the cost input and another percentage without understanding the intended model. Equally, do not assume markup automatically covers an omitted category. Review what the figure includes with the person responsible for your estimating method.

Use current relevant inputs and explicit assumptions. A material price from a different package or a labour allowance that excludes preparation can produce precise arithmetic around the wrong estimate. The formula cannot correct that mismatch.

Compare three pricing choices on the same job

At £4,000 cost, a 10% markup gives £4,400 price and £400 above cost. The corresponding margin is 9.09%. This can be checked by dividing £400 by £4,400, rather than describing the result as a 10% margin.

A 20% markup gives £4,800 price and £800 above cost, with 16.67% margin. A 20% target margin gives £5,000 price and £1,000 above cost, with 25% markup. The choice changes the offer by £200 on this example.

These figures are comparisons, not advice about which price a contractor should charge. Your scope, cost reliability, commercial context and business requirements determine the decision. The tool makes the numerical effect visible so you can choose deliberately.

Test a cost change before treating the target as achieved

Now suppose the £5,000 offer is accepted, but the same scoped work ultimately costs £4,400. The difference is £600 and the realised margin on that cost basis is 12%. The original target remains 20%; actual costs tell a different story.

If you had known the £4,400 cost before offering and still wanted 20% margin, the formula would produce £5,500. That does not give permission to change an accepted customer price afterwards. It shows what the estimate would have required at the pricing stage.

Separate a costing variance from a customer-requested scope change. An underestimated quantity affects your cost review. Additional agreed work has its own commercial proposal and response. Do not treat the calculator as authority to bill the customer for every cost increase.

Use rounded figures consistently

A £3,275 cost at 22% target margin produces an unrounded price of £4,198.717948…. The display is £4,198.72. Keep the underlying calculation available rather than rounding each intermediate percentage or cost conversion repeatedly.

If you choose a different commercial selling amount, calculate its margin against the same basis. Rounding a price down to a convenient total changes the achieved percentage slightly. Record the chosen selling amount in the actual offer rather than assuming the target and final price are identical.

Check the treatment of VAT consistently in the estimate and price comparison. The calculator uses before-VAT values and makes no tax decision. Mixing a cost including tax with a price excluding it can distort the ratio even when the formula itself is correct.

Make the calculation repeatable

Choose one estimate and identify the cost categories behind its total. Run that basis through both calculator modes and note the price difference. Confirm which percentage method your business intended to use before carrying the amount into a Quote.

Keep the estimate assumptions and final commercial price with the work. After delivery, compare recorded costs on the same basis so the review measures a meaningful variance. This calculation is most useful when it connects an explicit estimate with a price you can explain.