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, 2016

Related pages

receivables accounting entriesformula for owners equityfixed cost formula accountingexample of adjusting entryfixed asset turnover ratio interpretationexcel monthly payment functionroce ratio definitionsimple bookkeeping excel templatewhat is degree of operating leverage9 steps of the accounting cycleeffective interest rate amortization calculatorreceived advance payment journal entrybank reconciliation excel templatecalculate gearing ratio from balance sheetinventory sale journal entrybook keeping definationmargin vs markup calculationmargin vs markuphow to calculate direct materials purchasedlifo reserve journal entrytrade payables definitionaccrued salaries and wagesaccounts payable is a debit or creditmonthly depreciation formulablank accounting journalbreakage accountingproperty plant and equipment journal entrieshow to calculate vertical analysis percentagesamortization chart exceldouble entry for prepaymenthow to calculate prepaid insurance accountingjournal entries for variancesnrv accountingamortization of bond premium journal entrysmall business general ledgeraccounting rate of return methodjob order costing entriesreplenishing petty cashannuity factor calculationfreight on board fobdiscounting perpetuitywhat is the difference between gross margin and markupdepreciation residual value calculationgoods on consignment accountingcontra revenue accountobsolete inventory write offdiminishing balance formulaexcel margin calculatoronline amortization table generatorexcel margin calculatorcalculate gross margin percentage formulaperpetuity modeljournal entry accumulated depreciationaccounts receivable write offaccounting aptitude test questions and answerswhat is nperdepreciation schedule calculatorsample chart of accounts for personal financeemployee timesheet templatetotal cost of goods manufacturedjournal entry for depreciation expensepetty cash imprest system templateformula for inventory turnover ratiolump sum purchase accountingfactoring accounts receivable with recoursemonthly accounts excel templateamortisation exampleannuity tablesin a bank reconciliation a nsf check iseffective monthly rate calculatordefine deferred revenue expenditurehow to calculate present value of cash flows in excelhow to find variable cost formulaaccounts receivables factoringmethods of inventory valuation with examples