Stock Analysis on Net

Bristol-Myers Squibb Co. (NYSE:BMY)

Analysis of Long-term (Investment) Activity Ratios 
Quarterly Data

Microsoft Excel

Long-term Activity Ratios (Summary)

Bristol-Myers Squibb Co., long-term (investment) activity ratios (quarterly data)

Microsoft Excel
Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017
Net fixed asset turnover 7.90 7.77 7.67 7.75 7.66 7.43 7.22 6.86 6.03 5.07 4.18 5.00 4.92 4.67 4.49 4.33 4.25 4.16 4.15
Total asset turnover 0.47 0.46 0.42 0.41 0.40 0.38 0.36 0.31 0.27 0.24 0.20 0.42 0.43 0.67 0.64 0.65 0.66 0.64 0.62
Equity turnover 1.45 1.49 1.29 1.22 1.21 1.14 1.12 0.79 0.71 0.62 0.51 1.37 1.49 1.53 1.61 1.62 1.75 1.64 1.77

Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Bristol-Myers Squibb Co. net fixed asset turnover ratio improved from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Bristol-Myers Squibb Co. total asset turnover ratio improved from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Bristol-Myers Squibb Co. equity turnover ratio improved from Q4 2021 to Q1 2022 but then slightly deteriorated from Q1 2022 to Q2 2022.

Net Fixed Asset Turnover

Bristol-Myers Squibb Co., net fixed asset turnover calculation (quarterly data)

Microsoft Excel
Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017
Selected Financial Data (US$ in millions)
Revenues 11,887  11,648  11,985  11,624  11,703  11,073  11,068  10,540  10,129  10,781  7,945  6,007  6,273  5,920  5,973  5,691  5,704  5,193  5,449  5,254  5,144  4,929 
Property, plant and equipment 5,970  6,047  6,049  5,868  5,795  5,763  5,886  5,740  5,777  6,112  6,252  4,830  4,849  4,985  5,027  5,092  5,080  5,060  5,001  5,014  4,944  5,020 
Long-term Activity Ratio
Net fixed asset turnover1 7.90 7.77 7.67 7.75 7.66 7.43 7.22 6.86 6.03 5.07 4.18 5.00 4.92 4.67 4.49 4.33 4.25 4.16 4.15
Benchmarks
Net Fixed Asset Turnover, Competitors2
Abbott Laboratories 5.17 5.00 4.81 4.79 4.56 4.23 3.83 3.74 3.77 4.06 3.97 4.01 3.95 4.03 4.04 4.08 3.98 3.71 3.60
Cigna Corp. 48.61 47.95 46.73 41.42 40.56 39.29 37.85 37.05 36.02 35.37 34.45
CVS Health Corp. 24.05 23.26 22.56 22.24 21.90 21.42 21.25 21.48 21.52 21.49 21.24 20.88 19.69 18.47 17.09 18.05 18.24 18.33 17.95
Danaher Corp. 8.12 7.94 7.77 7.71 7.84 7.59 6.83 6.68 6.35 6.03 7.78 7.31 7.43 7.75 7.92 7.97 7.74 7.60 7.47
Elevance Health Inc. 36.17 35.81 34.94 34.54 34.17 34.94 34.69 34.61 32.74 32.30 32.92 34.00 33.79 33.36 33.40 34.91 37.46 39.81 40.95
Humana Inc. 28.64 27.05 26.97 27.83 29.47 31.04 32.05 32.90 33.07 33.20 32.93 33.43 33.58 33.22 32.51 32.89 33.52 33.76 33.69
Intuitive Surgical Inc. 2.83 3.00 3.04 3.16 3.13 2.86 2.76 2.85 3.00 3.36 3.52 3.74 3.91 4.12 4.59 4.78 5.02 4.99 5.10
Medtronic PLC 6.13 6.12 5.77 5.56 5.64 5.72 5.99 6.52 6.50 6.51 6.54 6.65 6.70 6.62 6.51 6.58 6.67 6.82 6.81
UnitedHealth Group Inc. 32.33 32.16 31.81 31.77 30.94 30.76 29.64 30.80 30.30 29.91 27.60 27.98 26.97 27.93 26.59 27.18 26.87 25.36 28.54

Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).

1 Q2 2022 Calculation
Net fixed asset turnover = (RevenuesQ2 2022 + RevenuesQ1 2022 + RevenuesQ4 2021 + RevenuesQ3 2021) ÷ Property, plant and equipment
= (11,887 + 11,648 + 11,985 + 11,624) ÷ 5,970 = 7.90

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Bristol-Myers Squibb Co. net fixed asset turnover ratio improved from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022.

Total Asset Turnover

Bristol-Myers Squibb Co., total asset turnover calculation (quarterly data)

Microsoft Excel
Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017
Selected Financial Data (US$ in millions)
Revenues 11,887  11,648  11,985  11,624  11,703  11,073  11,068  10,540  10,129  10,781  7,945  6,007  6,273  5,920  5,973  5,691  5,704  5,193  5,449  5,254  5,144  4,929 
Total assets 100,357  103,034  109,314  110,893  110,797  112,435  118,481  125,536  128,076  129,285  129,944  57,433  55,163  34,834  34,986  33,734  32,641  33,083  33,551  33,977  33,409  32,937 
Long-term Activity Ratio
Total asset turnover1 0.47 0.46 0.42 0.41 0.40 0.38 0.36 0.31 0.27 0.24 0.20 0.42 0.43 0.67 0.64 0.65 0.66 0.64 0.62
Benchmarks
Total Asset Turnover, Competitors2
Abbott Laboratories 0.61 0.60 0.57 0.57 0.55 0.51 0.48 0.47 0.46 0.48 0.47 0.46 0.45 0.45 0.46 0.42 0.43 0.40 0.36
Cigna Corp. 1.17 1.15 1.11 1.09 1.07 1.06 1.02 0.97 0.96 0.99 0.98
CVS Health Corp. 1.33 1.28 1.25 1.21 1.20 1.18 1.16 1.14 1.12 1.13 1.15 1.11 1.03 0.95 0.99 1.43 1.40 1.38 1.94
Danaher Corp. 0.38 0.36 0.35 0.34 0.34 0.33 0.29 0.28 0.27 0.26 0.29 0.30 0.35 0.38 0.42 0.41 0.40 0.40 0.39
Elevance Health Inc. 1.47 1.42 1.41 1.35 1.33 1.29 1.39 1.34 1.28 1.31 1.33 1.28 1.26 1.25 1.28 1.22 1.20 1.22 1.26
Humana Inc. 1.91 1.86 1.87 1.78 2.08 2.08 2.17 1.90 1.82 1.94 2.21 2.14 2.09 2.06 2.22 2.02 1.59 1.61 1.96
Intuitive Surgical Inc. 0.44 0.43 0.42 0.42 0.42 0.39 0.39 0.41 0.43 0.47 0.46 0.47 0.47 0.47 0.47 0.49 0.50 0.51 0.54
Medtronic PLC 0.35 0.34 0.32 0.29 0.29 0.30 0.32 0.33 0.34 0.34 0.34 0.34 0.34 0.33 0.33 0.31 0.31 0.30 0.30
UnitedHealth Group Inc. 1.32 1.33 1.34 1.30 1.29 1.27 1.30 1.31 1.28 1.29 1.38 1.37 1.40 1.43 1.48 1.45 1.37 1.33 1.44

Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).

1 Q2 2022 Calculation
Total asset turnover = (RevenuesQ2 2022 + RevenuesQ1 2022 + RevenuesQ4 2021 + RevenuesQ3 2021) ÷ Total assets
= (11,887 + 11,648 + 11,985 + 11,624) ÷ 100,357 = 0.47

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Bristol-Myers Squibb Co. total asset turnover ratio improved from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022.

Equity Turnover

Bristol-Myers Squibb Co., equity turnover calculation (quarterly data)

Microsoft Excel
Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017
Selected Financial Data (US$ in millions)
Revenues 11,887  11,648  11,985  11,624  11,703  11,073  11,068  10,540  10,129  10,781  7,945  6,007  6,273  5,920  5,973  5,691  5,704  5,193  5,449  5,254  5,144  4,929 
Total Bristol-Myers Squibb Company shareholders’ equity 32,600  31,580  35,946  37,213  36,808  37,605  37,822  50,158  49,094  49,911  51,598  17,648  16,049  15,218  14,031  13,640  12,317  12,793  11,741  14,783  14,699  14,416 
Long-term Activity Ratio
Equity turnover1 1.45 1.49 1.29 1.22 1.21 1.14 1.12 0.79 0.71 0.62 0.51 1.37 1.49 1.53 1.61 1.62 1.75 1.64 1.77
Benchmarks
Equity Turnover, Competitors2
Abbott Laboratories 1.25 1.26 1.20 1.23 1.19 1.11 1.06 1.03 1.03 1.06 1.03 0.99 0.98 0.99 1.00 0.99 0.97 0.91 0.89
Cigna Corp. 3.88 3.81 3.66 3.56 3.40 3.36 3.16 3.24 3.24 3.39 3.36
CVS Health Corp. 4.08 4.05 3.87 3.82 3.79 3.81 3.86 3.86 3.87 4.01 4.00 3.89 3.69 3.51 3.33 5.14 5.25 4.81 4.90
Danaher Corp. 0.66 0.65 0.65 0.65 0.62 0.61 0.56 0.54 0.52 0.58 0.59 0.57 0.59 0.62 0.71 0.71 0.71 0.69 0.70
Elevance Health Inc. 4.13 3.97 3.80 3.71 3.65 3.65 3.64 3.43 3.26 3.41 3.25 3.17 3.11 3.11 3.20 3.11 3.12 3.30 3.36
Humana Inc. 5.77 5.63 5.15 4.96 5.34 5.48 5.54 4.65 4.86 5.44 5.35 5.37 5.08 5.37 5.55 5.23 5.34 5.34 5.42
Intuitive Surgical Inc. 0.50 0.49 0.48 0.48 0.48 0.45 0.45 0.47 0.50 0.54 0.54 0.55 0.56 0.55 0.56 0.57 0.59 0.60 0.66
Medtronic PLC 0.61 0.61 0.59 0.55 0.56 0.56 0.57 0.60 0.61 0.61 0.61 0.61 0.61 0.60 0.59 0.59 0.58 0.59 0.59
UnitedHealth Group Inc. 4.18 4.06 3.98 3.95 3.92 3.94 3.90 3.85 3.87 4.29 4.17 4.33 4.41 4.44 4.35 4.37 4.40 4.34 4.19

Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).

1 Q2 2022 Calculation
Equity turnover = (RevenuesQ2 2022 + RevenuesQ1 2022 + RevenuesQ4 2021 + RevenuesQ3 2021) ÷ Total Bristol-Myers Squibb Company shareholders’ equity
= (11,887 + 11,648 + 11,985 + 11,624) ÷ 32,600 = 1.45

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Bristol-Myers Squibb Co. equity turnover ratio improved from Q4 2021 to Q1 2022 but then slightly deteriorated from Q1 2022 to Q2 2022.