Microsoft Excel LibreOffice Calc

Bristol-Myers Squibb Co. (BMY)


Analysis of Short-term (Operating) Activity Ratios

Beginner level


Short-term Activity Ratios (Summary)

Bristol-Myers Squibb Co., short-term (operating) activity ratios

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Turnover Ratios
Inventory turnover 5.48 5.20 3.99 3.20 2.52
Receivables turnover 4.66 4.43 4.69 4.76 5.55
Payables turnover 3.46 2.70 2.97 2.50 1.58
Working capital turnover 3.32 3.64 3.64 5.86 1.90
Average No. Days
Average inventory processing period 67 70 92 114 145
Add: Average receivable collection period 78 82 78 77 66
Operating cycle 145 152 170 191 211
Less: Average payables payment period 105 135 123 146 231
Cash conversion cycle 40 17 47 45 -20

Based on: 10-K (filing date: 2019-02-25), 10-K (filing date: 2018-02-13), 10-K (filing date: 2017-02-21), 10-K (filing date: 2016-02-12), 10-K (filing date: 2015-02-13).

Short-term activity ratio Description The company
Inventory turnover An activity ratio calculated as cost of goods sold divided by inventory. Bristol-Myers Squibb Co.’s inventory turnover ratio improved from 2016 to 2017 and from 2017 to 2018.
Receivables turnover An activity ratio equal to revenue divided by receivables. Bristol-Myers Squibb Co.’s receivables turnover ratio deteriorated from 2016 to 2017 but then improved from 2017 to 2018 not reaching 2016 level.
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Bristol-Myers Squibb Co.’s payables turnover ratio decreased from 2016 to 2017 but then increased from 2017 to 2018 exceeding 2016 level.
Working capital turnover An activity ratio calculated as revenue divided by working capital. Bristol-Myers Squibb Co.’s working capital turnover ratio deteriorated from 2016 to 2017 and from 2017 to 2018.

Short-term activity ratio Description The company
Average inventory processing period An activity ratio equal to the number of days in the period divided by inventory turnover over the period. Bristol-Myers Squibb Co.’s number of days of inventory outstanding improved from 2016 to 2017 and from 2017 to 2018.
Average receivable collection period An activity ratio equal to the number of days in the period divided by receivables turnover.
Operating cycle Equal to average inventory processing period plus average receivables collection period. Bristol-Myers Squibb Co.’s operating cycle improved from 2016 to 2017 and from 2017 to 2018.
Average payables payment period An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. Bristol-Myers Squibb Co.’s number of days of payables outstanding increased from 2016 to 2017 but then decreased significantly from 2017 to 2018.
Cash conversion cycle A financial metric that measures the length of time required for a company to convert cash invested in its operations to cash received as a result of its operations; equal to average inventory processing period plus average receivables collection period minus average payables payment period. Bristol-Myers Squibb Co.’s cash conversion cycle improved from 2016 to 2017 but then slightly deteriorated from 2017 to 2018 not reaching 2016 level.

Inventory Turnover

Bristol-Myers Squibb Co., inventory turnover calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (US$ in millions)
Cost of products sold 6,547  6,066  4,946  3,909  3,932 
Inventories 1,195  1,166  1,241  1,221  1,560 
Short-term Activity Ratio
Inventory turnover1 5.48 5.20 3.99 3.20 2.52
Benchmarks
Inventory Turnover, Competitors2
Abbott Laboratories 3.35 3.43 3.71 3.37 3.49
AbbVie Inc. 4.81 4.39 4.04 2.62 3.94
Allergan PLC 2.59 2.40 2.59 4.76 3.04
Amgen Inc. 1.39 1.44 1.52 1.74 1.67
Biogen Inc. 1.95 1.81 1.48 1.39 1.46
Eli Lilly & Co. 1.56 1.36 1.59 1.46 1.80
Gilead Sciences Inc. 5.96 5.46 2.68 2.05 2.73
Johnson & Johnson 3.15 2.89 2.66 2.67 2.78
Merck & Co. Inc. 2.48 2.51 2.85 3.18 3.01
Pfizer Inc. 1.50 1.48 1.82 1.28 1.69
Regeneron Pharmaceuticals Inc. 0.16 0.28 0.49 1.01 1.00
Vertex Pharmaceuticals Inc. 3.29 2.46 2.71 2.18 1.98
Zoetis Inc. 1.37 1.24 1.11 1.18 1.33
Inventory Turnover, Sector
Pharmaceuticals & Biotechnology 2.49 2.39 2.39 2.27
Inventory Turnover, Industry
Health Care 5.79 5.48 5.55 4.88

Based on: 10-K (filing date: 2019-02-25), 10-K (filing date: 2018-02-13), 10-K (filing date: 2017-02-21), 10-K (filing date: 2016-02-12), 10-K (filing date: 2015-02-13).

1 2018 Calculation
Inventory turnover = Cost of products sold ÷ Inventories
= 6,547 ÷ 1,195 = 5.48

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Inventory turnover An activity ratio calculated as cost of goods sold divided by inventory. Bristol-Myers Squibb Co.’s inventory turnover ratio improved from 2016 to 2017 and from 2017 to 2018.

Receivables Turnover

Bristol-Myers Squibb Co., receivables turnover calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (US$ in millions)
Net product sales 21,581  19,258  17,702  14,045  11,660 
Net trade receivables 4,636  4,347  3,774  2,948  2,100 
Short-term Activity Ratio
Receivables turnover1 4.66 4.43 4.69 4.76 5.55
Benchmarks
Receivables Turnover, Competitors2
Abbott Laboratories 5.90 5.22 6.42 5.97 5.65
AbbVie Inc. 6.08 5.55 5.39 4.83 5.34
Allergan PLC 5.50 5.50 5.76 6.28 5.51
Amgen Inc. 6.29 6.73 6.92 6.99 7.59
Biogen Inc. 5.56 5.79 6.81 7.49 6.35
Eli Lilly & Co. 4.68 5.03 5.27 5.68 6.06
Gilead Sciences Inc. 6.52 6.66 6.64 5.49 5.28
Johnson & Johnson 5.79 5.67 6.14 6.53 6.77
Merck & Co. Inc. 5.98 5.84 5.67 6.09 6.37
Pfizer Inc. 6.68 6.39 6.42 5.97 5.72
Regeneron Pharmaceuticals Inc. 2.38 2.42 2.49 2.33 2.37
Vertex Pharmaceuticals Inc. 7.44 8.85 8.47 5.81 7.64
Zoetis Inc. 5.62 5.32 5.35 5.09 4.88
Receivables Turnover, Sector
Pharmaceuticals & Biotechnology 5.75 5.64 5.91 5.87
Receivables Turnover, Industry
Health Care 7.45 7.31 7.61 7.38

Based on: 10-K (filing date: 2019-02-25), 10-K (filing date: 2018-02-13), 10-K (filing date: 2017-02-21), 10-K (filing date: 2016-02-12), 10-K (filing date: 2015-02-13).

1 2018 Calculation
Receivables turnover = Net product sales ÷ Net trade receivables
= 21,581 ÷ 4,636 = 4.66

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Receivables turnover An activity ratio equal to revenue divided by receivables. Bristol-Myers Squibb Co.’s receivables turnover ratio deteriorated from 2016 to 2017 but then improved from 2017 to 2018 not reaching 2016 level.

Payables Turnover

Bristol-Myers Squibb Co., payables turnover calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (US$ in millions)
Cost of products sold 6,547  6,066  4,946  3,909  3,932 
Accounts payable 1,892  2,248  1,664  1,565  2,487 
Short-term Activity Ratio
Payables turnover1 3.46 2.70 2.97 2.50 1.58
Benchmarks
Payables Turnover, Competitors2
Abbott Laboratories 4.27 5.14 7.66 8.09 8.66
AbbVie Inc. 4.99 4.78 4.15 2.82 3.16
Allergan PLC 6.26 6.68 8.27 13.02 9.78
Amgen Inc. 3.40 3.01 4.54 4.38 3.65
Biogen Inc. 4.90 4.12 5.28 4.64 5.11
Eli Lilly & Co. 4.55 4.30 4.19 3.76 4.37
Gilead Sciences Inc. 6.14 5.37 3.53 3.40 3.97
Johnson & Johnson 3.59 3.47 3.13 3.23 2.98
Merck & Co. Inc. 4.07 4.12 4.95 5.90 6.39
Pfizer Inc. 2.41 2.41 2.72 2.67 2.98
Regeneron Pharmaceuticals Inc. 0.82 1.14 1.44 1.71 1.30
Vertex Pharmaceuticals Inc. 3.69 3.72 3.42 1.66 0.86
Zoetis Inc. 6.11 6.80 6.29 5.93 5.92
Payables Turnover, Sector
Pharmaceuticals & Biotechnology 3.77 3.67 3.80 3.90
Payables Turnover, Industry
Health Care 6.01 5.81 5.99 5.84

Based on: 10-K (filing date: 2019-02-25), 10-K (filing date: 2018-02-13), 10-K (filing date: 2017-02-21), 10-K (filing date: 2016-02-12), 10-K (filing date: 2015-02-13).

1 2018 Calculation
Payables turnover = Cost of products sold ÷ Accounts payable
= 6,547 ÷ 1,892 = 3.46

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Bristol-Myers Squibb Co.’s payables turnover ratio decreased from 2016 to 2017 but then increased from 2017 to 2018 exceeding 2016 level.

Working Capital Turnover

Bristol-Myers Squibb Co., working capital turnover calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (US$ in millions)
Current assets 17,160  14,854  13,704  10,415  14,608 
Less: Current liabilities 10,654  9,563  8,841  8,017  8,461 
Working capital 6,506  5,291  4,863  2,398  6,147 
 
Net product sales 21,581  19,258  17,702  14,045  11,660 
Short-term Activity Ratio
Working capital turnover1 3.32 3.64 3.64 5.86 1.90
Benchmarks
Working Capital Turnover, Competitors2
Abbott Laboratories 5.44 2.44 1.04 4.11 4.28
AbbVie Inc. 6.16 4.00 4.22 4.26
Allergan PLC 21.12 10.43 1.46 52.49 7.01
Amgen Inc. 0.93 0.54 0.63 0.70 0.70
Biogen Inc. 2.51 2.30 1.85 2.23 3.34
Eli Lilly & Co. 2.84 4.90 5.16 4.59 20.17
Gilead Sciences Inc. 0.86 1.27 2.67 2.16 2.05
Johnson & Johnson 5.51 6.09 1.86 2.16 2.17
Merck & Co. Inc. 11.53 6.52 2.97 3.74 2.93
Pfizer Inc. 2.97 4.90 6.74 3.39 1.38
Regeneron Pharmaceuticals Inc. 0.82 1.16 1.72 1.28 1.16
Vertex Pharmaceuticals Inc. 1.12 1.35 1.64 1.15 0.49
Zoetis Inc. 1.83 1.70 2.15 2.33 2.01
Working Capital Turnover, Sector
Pharmaceuticals & Biotechnology 3.03 2.71 2.07 2.50
Working Capital Turnover, Industry
Health Care 5.23 4.27 3.46 3.64

Based on: 10-K (filing date: 2019-02-25), 10-K (filing date: 2018-02-13), 10-K (filing date: 2017-02-21), 10-K (filing date: 2016-02-12), 10-K (filing date: 2015-02-13).

1 2018 Calculation
Working capital turnover = Net product sales ÷ Working capital
= 21,581 ÷ 6,506 = 3.32

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Working capital turnover An activity ratio calculated as revenue divided by working capital. Bristol-Myers Squibb Co.’s working capital turnover ratio deteriorated from 2016 to 2017 and from 2017 to 2018.

Average Inventory Processing Period

Bristol-Myers Squibb Co., average inventory processing period calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data
Inventory turnover 5.48 5.20 3.99 3.20 2.52
Short-term Activity Ratio (no. days)
Average inventory processing period1 67 70 92 114 145
Benchmarks (no. days)
Average Inventory Processing Period, Competitors2
Abbott Laboratories 109 107 98 108 105
AbbVie Inc. 76 83 90 139 93
Allergan PLC 141 152 141 77 120
Amgen Inc. 262 254 241 210 218
Biogen Inc. 187 202 247 263 251
Eli Lilly & Co. 233 268 230 250 203
Gilead Sciences Inc. 61 67 136 178 134
Johnson & Johnson 116 126 137 136 131
Merck & Co. Inc. 147 146 128 115 121
Pfizer Inc. 244 246 201 284 216
Regeneron Pharmaceuticals Inc. 2,334 1,309 749 360 365
Vertex Pharmaceuticals Inc. 111 148 135 168 185
Zoetis Inc. 266 293 329 308 274
Average Inventory Processing Period, Sector
Pharmaceuticals & Biotechnology 147 153 153 161
Average Inventory Processing Period, Industry
Health Care 63 67 66 75

Based on: 10-K (filing date: 2019-02-25), 10-K (filing date: 2018-02-13), 10-K (filing date: 2017-02-21), 10-K (filing date: 2016-02-12), 10-K (filing date: 2015-02-13).

1 2018 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 5.48 = 67

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Average inventory processing period An activity ratio equal to the number of days in the period divided by inventory turnover over the period. Bristol-Myers Squibb Co.’s number of days of inventory outstanding improved from 2016 to 2017 and from 2017 to 2018.

Average Receivable Collection Period

Bristol-Myers Squibb Co., average receivable collection period calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data
Receivables turnover 4.66 4.43 4.69 4.76 5.55
Short-term Activity Ratio (no. days)
Average receivable collection period1 78 82 78 77 66
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
Abbott Laboratories 62 70 57 61 65
AbbVie Inc. 60 66 68 76 68
Allergan PLC 66 66 63 58 66
Amgen Inc. 58 54 53 52 48
Biogen Inc. 66 63 54 49 58
Eli Lilly & Co. 78 73 69 64 60
Gilead Sciences Inc. 56 55 55 66 69
Johnson & Johnson 63 64 59 56 54
Merck & Co. Inc. 61 63 64 60 57
Pfizer Inc. 55 57 57 61 64
Regeneron Pharmaceuticals Inc. 153 151 147 156 154
Vertex Pharmaceuticals Inc. 49 41 43 63 48
Zoetis Inc. 65 69 68 72 75
Average Receivable Collection Period, Sector
Pharmaceuticals & Biotechnology 64 65 62 62
Average Receivable Collection Period, Industry
Health Care 49 50 48 49

Based on: 10-K (filing date: 2019-02-25), 10-K (filing date: 2018-02-13), 10-K (filing date: 2017-02-21), 10-K (filing date: 2016-02-12), 10-K (filing date: 2015-02-13).

1 2018 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 4.66 = 78

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Average receivable collection period An activity ratio equal to the number of days in the period divided by receivables turnover.

Operating Cycle

Bristol-Myers Squibb Co., operating cycle calculation, comparison to benchmarks

No. days

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data
Average inventory processing period 67 70 92 114 145
Average receivable collection period 78 82 78 77 66
Short-term Activity Ratio
Operating cycle1 145 152 170 191 211
Benchmarks
Operating Cycle, Competitors2
Abbott Laboratories 171 177 155 169 170
AbbVie Inc. 136 149 158 215 161
Allergan PLC 207 218 204 135 186
Amgen Inc. 320 308 294 262 266
Biogen Inc. 253 265 301 312 309
Eli Lilly & Co. 311 341 299 314 263
Gilead Sciences Inc. 117 122 191 244 203
Johnson & Johnson 179 190 196 192 185
Merck & Co. Inc. 208 209 192 175 178
Pfizer Inc. 299 303 258 345 280
Regeneron Pharmaceuticals Inc. 2,487 1,460 896 516 519
Vertex Pharmaceuticals Inc. 160 189 178 231 233
Zoetis Inc. 331 362 397 380 349
Operating Cycle, Sector
Pharmaceuticals & Biotechnology 211 218 215 223
Operating Cycle, Industry
Health Care 112 117 114 124

Based on: 10-K (filing date: 2019-02-25), 10-K (filing date: 2018-02-13), 10-K (filing date: 2017-02-21), 10-K (filing date: 2016-02-12), 10-K (filing date: 2015-02-13).

1 2018 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 67 + 78 = 145

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Operating cycle Equal to average inventory processing period plus average receivables collection period. Bristol-Myers Squibb Co.’s operating cycle improved from 2016 to 2017 and from 2017 to 2018.

Average Payables Payment Period

Bristol-Myers Squibb Co., average payables payment period calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data
Payables turnover 3.46 2.70 2.97 2.50 1.58
Short-term Activity Ratio (no. days)
Average payables payment period1 105 135 123 146 231
Benchmarks (no. days)
Average Payables Payment Period, Competitors2
Abbott Laboratories 85 71 48 45 42
AbbVie Inc. 73 76 88 130 116
Allergan PLC 58 55 44 28 37
Amgen Inc. 107 121 80 83 100
Biogen Inc. 74 89 69 79 71
Eli Lilly & Co. 80 85 87 97 83
Gilead Sciences Inc. 59 68 103 107 92
Johnson & Johnson 102 105 116 113 122
Merck & Co. Inc. 90 89 74 62 57
Pfizer Inc. 152 151 134 137 122
Regeneron Pharmaceuticals Inc. 442 321 253 213 281
Vertex Pharmaceuticals Inc. 99 98 107 220 426
Zoetis Inc. 60 54 58 62 62
Average Payables Payment Period, Sector
Pharmaceuticals & Biotechnology 97 100 96 93
Average Payables Payment Period, Industry
Health Care 61 63 61 62

Based on: 10-K (filing date: 2019-02-25), 10-K (filing date: 2018-02-13), 10-K (filing date: 2017-02-21), 10-K (filing date: 2016-02-12), 10-K (filing date: 2015-02-13).

1 2018 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 3.46 = 105

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Average payables payment period An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. Bristol-Myers Squibb Co.’s number of days of payables outstanding increased from 2016 to 2017 but then decreased significantly from 2017 to 2018.

Cash Conversion Cycle

Bristol-Myers Squibb Co., cash conversion cycle calculation, comparison to benchmarks

No. days

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data
Average inventory processing period 67 70 92 114 145
Average receivable collection period 78 82 78 77 66
Average payables payment period 105 135 123 146 231
Short-term Activity Ratio
Cash conversion cycle1 40 17 47 45 -20
Benchmarks
Cash Conversion Cycle, Competitors2
Abbott Laboratories 86 106 107 124 128
AbbVie Inc. 63 73 70 85 45
Allergan PLC 149 163 160 107 149
Amgen Inc. 213 187 214 179 166
Biogen Inc. 179 176 232 233 238
Eli Lilly & Co. 231 256 212 217 180
Gilead Sciences Inc. 58 54 88 137 111
Johnson & Johnson 77 85 80 79 63
Merck & Co. Inc. 118 120 118 113 121
Pfizer Inc. 147 152 124 208 158
Regeneron Pharmaceuticals Inc. 2,045 1,139 643 303 238
Vertex Pharmaceuticals Inc. 61 91 71 11 -193
Zoetis Inc. 271 308 339 318 287
Cash Conversion Cycle, Sector
Pharmaceuticals & Biotechnology 114 118 119 130
Cash Conversion Cycle, Industry
Health Care 51 54 53 62

Based on: 10-K (filing date: 2019-02-25), 10-K (filing date: 2018-02-13), 10-K (filing date: 2017-02-21), 10-K (filing date: 2016-02-12), 10-K (filing date: 2015-02-13).

1 2018 Calculation
Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 67 + 78105 = 40

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Cash conversion cycle A financial metric that measures the length of time required for a company to convert cash invested in its operations to cash received as a result of its operations; equal to average inventory processing period plus average receivables collection period minus average payables payment period. Bristol-Myers Squibb Co.’s cash conversion cycle improved from 2016 to 2017 but then slightly deteriorated from 2017 to 2018 not reaching 2016 level.