Margin vs Markup Tables

Margin vs Markup tables

The margin vs markup tables below act as a quick reference to help you calculate markup and cost multiplier values from a known margin. The tables are based on the margin vs markup formula as follows:

Markup = Margin / (1 – Margin)

How to Calculate Markup

As an example of using the margin vs markup tables, suppose a business has a product which has a margin of 20%. using the table it can see that the corresponding markup is 25% and the cost multiplier is 1.25.

So if the selling price, say 90 is known, the profit would be calculated using the margin
Profit = 20% x 90 = 18

If the cost price of 72 is known, then the profit would be calculated using the markup
Profit = 25% x 72 = 18 as before.

The multiplier of 1.25 can be applied to the cost price to give a corresponding selling price. In this example the selling price would be 1.25 x 72 = 90

Our tutorial on markup vs margin gives full details about how to convert from markup to margin and the use of the cost multiplier.

Margin vs Markup Tables Guide and Key

  1. Margin % : Each row represents a margin % from 1 to 99.
  2. Markup % : Each row represents the markup %.
  3. Multiplier: Each row represents the cost multiplier.
Margin vs Markup Tables
Margin % Markup % Multiplier
1.0% 1.0% 1.01
2.0% 2.0% 1.02
3.0% 3.1% 1.03
4.0% 4.2% 1.04
5.0% 5.3% 1.05
6.0% 6.4% 1.06
7.0% 7.5% 1.08
8.0% 8.7% 1.09
9.0% 9.9% 1.10
10.0% 11.1% 1.11
11.0% 12.4% 1.12
12.0% 13.6% 1.14
13.0% 14.9% 1.15
14.0% 16.3% 1.16
15.0% 17.6% 1.18
16.0% 19.0% 1.19
17.0% 20.5% 1.20
18.0% 22.0% 1.22
19.0% 23.5% 1.23
20.0% 25.0% 1.25
21.0% 26.6% 1.27
22.0% 28.2% 1.28
23.0% 29.9% 1.30
24.0% 31.6% 1.32
25.0% 33.3% 1.33
26.0% 35.1% 1.35
27.0% 37.0% 1.37
28.0% 38.9% 1.39
29.0% 40.8% 1.41
30.0% 42.9% 1.43
31.0% 44.9% 1.45
32.0% 47.1% 1.47
33.0% 49.3% 1.49
34.0% 51.5% 1.52
35.0% 53.8% 1.54
36.0% 56.3% 1.56
37.0% 58.7% 1.59
38.0% 61.3% 1.61
39.0% 63.9% 1.64
40.0% 66.7% 1.67
41.0% 69.5% 1.69
42.0% 72.4% 1.72
43.0% 75.4% 1.75
44.0% 78.6% 1.79
45.0% 81.8% 1.82
46.0% 85.2% 1.85
47.0% 88.7% 1.89
48.0% 92.3% 1.92
49.0% 96.1% 1.96
50.0% 100.0% 2.00
51.0% 104.1% 2.04
52.0% 108.3% 2.08
53.0% 112.8% 2.13
54.0% 117.4% 2.17
55.0% 122.2% 2.22
56.0% 127.3% 2.27
57.0% 132.6% 2.33
58.0% 138.1% 2.38
59.0% 143.9% 2.44
60.0% 150.0% 2.50
61.0% 156.4% 2.56
62.0% 163.2% 2.63
63.0% 170.3% 2.70
64.0% 177.8% 2.78
65.0% 185.7% 2.86
66.0% 194.1% 2.94
67.0% 203.0% 3.03
68.0% 212.5% 3.13
69.0% 222.6% 3.23
70.0% 233.3% 3.33
71.0% 244.8% 3.45
72.0% 257.1% 3.57
73.0% 270.4% 3.70
74.0% 284.6% 3.85
75.0% 300.0% 4.00
76.0% 316.7% 4.17
77.0% 334.8% 4.35
78.0% 354.5% 4.55
79.0% 376.2% 4.76
80.0% 400.0% 5.00
81.0% 426.3% 5.26
82.0% 455.6% 5.56
83.0% 488.2% 5.88
84.0% 525.0% 6.25
85.0% 566.7% 6.67
86.0% 614.3% 7.14
87.0% 669.2% 7.69
88.0% 733.3% 8.33
89.0% 809.1% 9.09
90.0% 900.0% 10.00
91.0% 1011.1% 11.11
92.0% 1150.0% 12.50
93.0% 1328.6% 14.29
94.0% 1566.7% 16.67
95.0% 1900.0% 20.00
96.0% 2400.0% 25.00
97.0% 3233.3% 33.33
98.0% 4900.0% 50.00
99.0% 9900.0% 100.00
Margin vs Markup Tables November 6th, 2016Team

You May Also Like


Related pages


diminishing balance method calculatoris unearned revenue a liabilityimprestshow to calculate gross margin per unitwhat are outstanding chequesscrap value in accountingdebit note and credit note journal entryfob shipping point journal entryoperating cash flow calculatorbank reconciliation solved examplescash float sheetunderstanding debits and credits for dummiesquick ratio formula calculatoraccrued expense payablepurpose of preparing bank reconciliation statementjournal entry for accrued revenuestandard cost per unit formulacredit debit cheat sheetprepaid expense is an assetdirect materials used formulaprovision for obsolete inventoryformula to calculate pvdividends payable journal entrybalance sheet from trial balance examplesintangibles assetsliquidity ratios formulaexpanded accounting equationprepayment accounting entryaccounts receivable with recoursepresent value of a lump sum calculatorleased assets on balance sheetinventory shrinkage definitiondebt equity ratio significanceten column worksheet accounting examplepayback period calculation examplesexcel calculate interest rateannuity factor formulahow to calculate fixed cost and variable costhow to record closing entriesprofit margin vs markupblank income statement and balance sheetperpetuity growthpayback analysis calculatorjournaling accountingexamples of revenue expenditure and capital expenditureincome statement cost of goods manufacturedpmt on excelcreditors control account definitionadvance payment to suppliers accounting entryfinancial gearing definitionsample chart of accounts for rental propertymarkup based on cost calculatorhow to calculate npv in excelredeemable convertible preferred stocktvm formulashipping terms foblifo reserve journal entryaccounts receivable entriesaccounting for partnership dissolutionprepaid revenue journal entrypmt function exceltemplate for time sheetmarkup percent calculatorlong term debt to equity ratio calculatordeferral accounting definitionactivity ratios measurejournal entry worksheet accountingprepaid insurance normal balancepurchased merchandise on account journal entrydefine creditors in accountingpv of annuity due calculatorordinary annuity formula calculatordirect materials and indirect materialsformula for reducing balance methodytm definitionaccounting merchandise inventory journal entry