Markup vs Margin

Markup and margin are two ways of looking at the same thing depending on whether your starting point is cost or selling price for a product.

For any product, the gross profit formula is used to calculate gross profit. Gross profit, sometimes referred to as gross margin, is the difference between the selling price and the cost price of a product.

Markup vs Margin: Analysis of Gross Profit
Selling price
Cost price Profit

The gross profit formula for a product is written as:

Profit (P) = Selling price (S) – Cost price (C)

Whats this got to do with Markup vs Margin?

Quite simply, markup is profit divided by the cost price, and margin is profit divided by the selling price.

Markup Formula:

Markup = Profit / Cost price = P / C

Margin Formula:

Margin = Profit / Selling price = P / S

An Example or Markup vs Margin

Suppose the selling price is 60, and the cost price is 40, then the profit is given as follows:

Profit = Selling price - Cost price
Profit = 60 - 40 = 20
Markup = Profit / Cost price
Markup = 20 / 40 = 0.5
Margin = Profit / Selling price
Margin = 20 / 60 = 0.3333

Margin and Markup Percentage Formula

Instead of expressing the markup and margin as decimals, as shown in the above example, it’s normal to express them as percentages. This is done by multiplying the decimal value by 100%. Using the numbers in the above example, we can use either

Markup = 0.5 or Markup Percentage = 0.5 x 100% = 50% and,

Margin = 0.33 or Margin percentage = 0.3333 x 100% = 33.33%

When to use Markup vs Margin

The decision to use markup vs margin will depend on what information is available to the business. Depending on the circumstances a business will either know is cost price or selling price, and its markup or margin.

Selling Price and Margin Known

If you know the selling price, then it’s easier to use the margin to calculate the profit and the cost price. This often arises when retailers for example, need to meet a given selling price point, and knowing that and the margin they want to achieve, need to work out what cost price they have to buy at.

If your margin percentage is 33.33% and your selling price is 90, then you can easily work out the profit as follows:

Profit = Margin x Selling price
Profit = 33.33% x 90 = 30
Cost price = Selling price - Profit
Cost price = 90 - 30 = 60

Notice that the cost price is also given by

Cost price = (1 - Margin) x Selling price
Cost price = (1 - 33.33%) x 90
Cost price = 66.67% x 90 = 60 as before.

Cost Price and Markup Known

If however you know the cost price, then its easier to use markup to calculate the selling price and the profit. This can occur when a business knows its product costings and needs to calculate the required selling price to achieve a given markup.

If the markup percentage is 50% and your cost price is 60, then the profit is

Profit = Markup x Cost price
Profit = 50% x 60 = 30
Selling price = Cost price + Profit
Selling price = 60 + 30 = 90

Notice that the selling price is also given by

Selling price = (1 + Markup) x Cost price
Selling price = (1 + 50%) x 60
Selling price = 150% x 60 = 90 as before. 

A Word on Cost Multipliers

As we have seen above, the markup is used to calculate the profit on a product when we know its cost. Quite often a business will be trying to calculate the selling price when it knows the cost and the required markup. To do this quickly the business will use a multiplier on cost, this multiplier is given by

Cost multiplier = 1 + Markup

For example if for a retailer the retail markup is 50% or 0.5, then the cost multiplier is given as follows:

Cost multiplier = 1 + Markup
Cost multiplier = 1 + 0.5 = 1.5

So if the cost price is 60, we can quickly calculate the selling price as

Selling price = Cost multiplier x cost price
Selling price = 1.5 x 60 = 90.

Convert Margin to Markup

If the margin is known the markup can be calculated with the following formula:

Markup = Margin / (1 – Margin)

So for example if the margin is 33.33% or 0.3333 them the markup is given as follows:

Markup = Margin / (1 - Margin)
Markup = 0.3333 / 1 - 0.3333
Markup = 0.3333 / 0.6667 = 0.50 

Convert Markup to Margin

If the markup is known the margin can be calculated with the following formula:

Margin = Markup / (1 + Markup)

So for example if the markup is 50% or 0.5 then the margin is given by

Margin = Markup / (1 + Markup)
Margin = 0.5 / (1 + 0.5)
Margin = 0.5 / 1.5 = 0.3333 or 33.33%

A margin markup converter calculator is available for download in Excel format by following this link Margin Markup Calculator and Converter or you can use our handy reference table to convert margins from 1 to 99% to the corresponding markup and cost multiplier by following this link Margin vs Markup Tables.

Markup vs Margin Calculator Download

We have seen that the markup and margin can be used in numerous ways depending on the information available. We have produced a markup vs margin calculator to enable a business to calculate selling price, cost price, profit, margin, markup, and cost multiplier on entering any two of the values.

The markup vs margin calculator is available for download in Excel format by following the link below.

Markup vs Margin November 6th, 2016Team

You May Also Like


Related pages


rate implicit in the leaseaccounting spreadsheet excelwhat is manufacturing overhead costdelivery term fobcash sheet template excelaccounting cogsfuture value of a perpetuity formulamargin multiplierdepletion of natural resources accountingasset turnover ratio calculatorobsolete inventory write offsemi annual amortization scheduleentry for unearned revenuebill of discountingmarkup on selling price calculatorfuture value of annuity in excelaccounting t chartsclosing retained earningsaccounting spreadsheet templatecalculate days sales in receivablesfreight on board originchart of accounts for a restaurantremittance in accountingincome statement spreadsheetcontra receivableaccrual accounting basicsgross margin percentage formulaincreasing annuityhorizontal analysis of balance sheet examplereturn on capital employed definitioneom accountingpv tables annuityfunctional format income statementwhat is retained incomedividend payout formulahow to calculate lifo liquidation profitterm loan double entryaccounting liquidity ratiosprepare a vertical analysis of the income statementyield to maturity formula excelaccelerated method of depreciationadvantage of payback periodchange in nwc formulascrap disposal formataccrual journal entrycalculate payback period exceljournal entry for deferred expenseshow to solve for variable costsample spreadsheet for small businessrestaurant bookkeeping templateshow to calculate discount factor in excelcalculate mark up percentagehire purchase journal entryaccounting credit memo journal entryworksheet of accountingnormal balance for accounts payablechart of accounts restaurant examplepetty cash liquidationcash flow statement equationbank account reconciliation templatedeferred tax asset journalyear end accounting entriesprepayment double entryaccounting for rental depositsreducing balance depreciation methodsaccounting ajecalculating gross profit margin percentagenote payable calculatorstandard costing in cost accountingtally journal entrymarkup margin formulachart of accounts for restaurantjournal entries for accrued expensesrate variance formulasubsidiary ledger accountsreturn on capital employed calculatorhow to calculate interest expense on a loanaverage investment in accounts receivable formula