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


sales journal formatwhat is meant by journal voucherhow to reduce gearing ratiodouble entry for deferred taxcapital gearing meaningexamples of accounts payablefob shipping point definitiondirect labor cost definitionpresent value of an annuity due tablejournal entry for bad debtslifo reserve accountpresent annuity tablehow to record fixed assets in quickbooksfinding cost of goods sold on income statementwhat is nsf checkfob pointsunearned income liabilityamortization in income statementfifo vs lifo accountingwhere to find marketable securities on balance sheetpresent value of an ordinary annuity calculatorcheque payment receipt format in wordinventories turnoverledger balance templateaccounting perpetual inventory systemtrial balance adjustments exampleirrevocable lcdividend declaration journal entryexamples of journallifo examplean example of a contra account isbank reconciliation statement samplecash dividend declaredaccounting for insurance recoveriesshare repurchase journal entryfixed assets turnover ratio formulafirst step in the accounting cyclewhat is a journal vouchervertical analysis of financial statementscoupon bond price calculatoraccrued expenses cash flowdownload amortization schedulemeaning of fob destinationusing irr in excelwhat are debits and credits accountingmanufacturing overhead journal entrystockholder equity calculatorsales return ratiobond discount journal entryaccrual to cash basis conversionexample of marketable securitiesinterest rate excel formulaloan amortization ukhow to determine manufacturing overheadprepaid expense in balance sheetliquidation of partnership accountingexplain pmt function in excelin which journal are adjusting entries recordedcapacity utilization calculation formulanet present value perpetuitystraight line amortization examplejournal entry for receiving payment on accountstandard costing and variance analysis formulashow to record prepaid rent journal entryretained earnings journal entryreducing balance method calculatorexamples of lifoprintable ledger formsaccounting rate of return calculatorreturns outwardscalculate factory overheadperpetuity growthcogs normal balance