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


discount formula in excelowners equity is increased byannuities due calculatorpresent value of a perpetuity calculatorpresent value of annuity pdfcalculate paybackpractise balancing equationsfuture value of an annuity excelcash flow statement calculatoropening entry in general journaldebt cushion ratiostraight line depreciation in excelannuity factors tablepayroll exam questionswhat is difference between account payable and bills payabledepreciation using the declining balance methodhow to extract a trial balancepv table annuity duecalculate gross margin percentage formuladirect labor journal entrycalculating debtor daysformula for mirrcapital turnoverexamples of other comprehensive incomenoninterest bearing notecalculating pmtwip in productionprepayment journal entriesformula for reorder pointgarnishee definitioncommon size analysis income statementdirect material cost formulafuture value of ordinary annuity calculatorhow to record allowance for doubtful accountscalculate fv in excelprofit margin formula excelhow to write a general ledgerweighted average process costing formulaformula for annuity dueexample of stockholders equityblank inventory templatefactoring receivables definitiondefine deferred incomeis deferred revenue the same as unearned revenuequick ration formulaaccounting entry for accrued interestamortization calculation excelconvertible bond accountinghow to compute quick ratiotvm tablesconsignee agent meaningformula for manufacturing overheadjournal entry for uncollectible accountssales chart excel templateincreasing annuity immediate formulatemplates for spreadsheetscoupon bond price formulahow to closing entriesfixed asset turn over ratiofob factory definitioncalculate discount excelhow to calculate gross profit using percentage of completion methodaccounting journal entries templatecalculate markup formulacontra note sampleexpenses voucher formatcorrecting entries accountingfuture value of an ordinary annuity calculator10 steps of the accounting cycleexample of a cashbookaccrual entries in accountingdefine sundry debtorspv factor of annuitydeferred revenue entrydividend debit or creditbad debt provision double entrybond calculator present valuecalculating irr on exceladvantages and disadvantages of zero based budgeting