Analysis of Long-term (Investment) Activity Ratios
Quarterly Data
Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.
Long-term Activity Ratios (Summary)
Merck & Co. Inc., long-term (investment) activity ratios (quarterly data)
Based on: 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 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).
| Long-term activity ratio | Description | The company |
|---|---|---|
| Net fixed asset turnover | An activity ratio calculated as total revenue divided by net fixed assets. | Merck & Co. Inc. net fixed asset turnover ratio improved from Q2 2023 to Q3 2023 but then deteriorated significantly from Q3 2023 to Q4 2023. |
| Total asset turnover | An activity ratio calculated as total revenue divided by total assets. | Merck & Co. Inc. total asset turnover ratio deteriorated from Q2 2023 to Q3 2023 but then improved from Q3 2023 to Q4 2023 exceeding Q2 2023 level. |
| Equity turnover | An activity ratio calculated as total revenue divided by shareholders’ equity. | Merck & Co. Inc. equity turnover ratio deteriorated from Q2 2023 to Q3 2023 but then improved from Q3 2023 to Q4 2023 exceeding Q2 2023 level. |
Net Fixed Asset Turnover
Merck & Co. Inc., net fixed asset turnover calculation (quarterly data)
| Dec 31, 2023 | Sep 30, 2023 | Jun 30, 2023 | Mar 31, 2023 | Dec 31, 2022 | Sep 30, 2022 | 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 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||||||||||||||||||||||
| Sales | 14,631) | 15,962) | 15,035) | 14,487) | 13,830) | 14,959) | 14,593) | 15,901) | 13,521) | 13,154) | 11,402) | 10,627) | 12,514) | 12,551) | 10,872) | 12,057) | 11,867) | 12,397) | 11,760) | 10,816) | ||||||
| Property, plant and equipment, at cost, net of accumulated depreciation | 23,051) | 22,526) | 22,231) | 21,758) | 21,422) | 20,424) | 20,059) | 19,747) | 19,279) | 18,565) | 18,064) | 18,295) | 17,986) | 16,919) | 15,789) | 15,269) | 15,053) | 14,287) | 13,862) | 13,506) | ||||||
| Long-term Activity Ratio | ||||||||||||||||||||||||||
| Net fixed asset turnover1 | 2.61 | 2.63 | 2.62 | 2.66 | 2.77 | 2.89 | 2.85 | 2.73 | 2.53 | 2.57 | 2.61 | 2.55 | 2.67 | 2.80 | 2.99 | 3.15 | 3.11 | — | — | — | ||||||
| Benchmarks | ||||||||||||||||||||||||||
| Net Fixed Asset Turnover, Competitors2 | ||||||||||||||||||||||||||
| AbbVie Inc. | 10.89 | 11.18 | 11.33 | 11.51 | 11.76 | 11.82 | 11.57 | 11.18 | 11.00 | 10.75 | 10.41 | 9.67 | 8.73 | 8.15 | 7.38 | 11.50 | 11.23 | — | — | — | ||||||
| Amgen Inc. | 4.53 | 4.61 | 4.58 | 4.56 | 4.57 | 4.73 | 4.77 | 4.75 | 4.69 | 4.89 | 4.92 | 4.93 | 4.96 | 4.94 | 4.78 | 4.68 | 4.51 | — | — | — | ||||||
| Bristol-Myers Squibb Co. | 6.77 | 6.93 | 7.11 | 7.30 | 7.38 | 7.74 | 7.90 | 7.77 | 7.67 | 7.75 | 7.66 | 7.43 | 7.22 | 6.86 | 6.03 | 5.07 | 4.18 | — | — | — | ||||||
| Eli Lilly & Co. | 2.64 | 2.70 | 2.62 | 2.63 | 2.81 | 3.14 | 3.18 | 3.22 | 3.15 | 3.11 | 3.02 | 2.95 | 2.83 | 2.80 | 2.88 | 2.92 | 2.83 | — | — | — | ||||||
| Gilead Sciences Inc. | 5.07 | 4.88 | 4.91 | 4.88 | 4.93 | 5.01 | 5.13 | 5.18 | 5.27 | 5.40 | 5.27 | 5.06 | 4.90 | 4.74 | 4.70 | 4.90 | 4.91 | — | — | — | ||||||
| Johnson & Johnson | 4.28 | 5.07 | 4.75 | 4.77 | 4.79 | 5.29 | 5.21 | 5.07 | 4.95 | 4.95 | 4.79 | 4.59 | 4.40 | 4.53 | 4.57 | 4.75 | 4.65 | — | — | — | ||||||
| Pfizer Inc. | 3.09 | 3.84 | 4.46 | 5.45 | 6.17 | 6.47 | 6.64 | 6.12 | 5.46 | 4.79 | 3.89 | 3.31 | 3.01 | 2.98 | 3.21 | 3.47 | 3.71 | — | — | — | ||||||
| Regeneron Pharmaceuticals Inc. | 3.16 | 3.27 | 3.23 | 3.19 | 3.23 | 3.70 | 3.91 | 4.64 | 4.62 | 3.99 | 3.69 | 2.82 | 2.64 | 2.63 | 2.64 | 2.71 | 2.72 | — | — | — | ||||||
| Thermo Fisher Scientific Inc. | 4.54 | 4.74 | 4.68 | 4.68 | 4.84 | 5.12 | 5.02 | 4.87 | 4.71 | 5.54 | 5.83 | 5.85 | 5.45 | 5.50 | 5.37 | 5.42 | 5.38 | — | — | — | ||||||
Based on: 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 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).
1 Q4 2023 Calculation
Net fixed asset turnover
= (SalesQ4 2023
+ SalesQ3 2023
+ SalesQ2 2023
+ SalesQ1 2023)
÷ Property, plant and equipment, at cost, net of accumulated depreciation
= (14,631 + 15,962 + 15,035 + 14,487)
÷ 23,051 = 2.61
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. | Merck & Co. Inc. net fixed asset turnover ratio improved from Q2 2023 to Q3 2023 but then deteriorated significantly from Q3 2023 to Q4 2023. |
Total Asset Turnover
Merck & Co. Inc., total asset turnover calculation (quarterly data)
| Dec 31, 2023 | Sep 30, 2023 | Jun 30, 2023 | Mar 31, 2023 | Dec 31, 2022 | Sep 30, 2022 | 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 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||||||||||||||||||||||
| Sales | 14,631) | 15,962) | 15,035) | 14,487) | 13,830) | 14,959) | 14,593) | 15,901) | 13,521) | 13,154) | 11,402) | 10,627) | 12,514) | 12,551) | 10,872) | 12,057) | 11,867) | 12,397) | 11,760) | 10,816) | ||||||
| Total assets | 106,675) | 106,727) | 104,469) | 107,796) | 109,160) | 107,081) | 107,095) | 106,668) | 105,694) | 93,494) | 90,688) | 90,847) | 91,588) | 89,800) | 90,615) | 84,913) | 84,397) | 83,331) | 83,965) | 82,354) | ||||||
| Long-term Activity Ratio | ||||||||||||||||||||||||||
| Total asset turnover1 | 0.56 | 0.56 | 0.56 | 0.54 | 0.54 | 0.55 | 0.53 | 0.51 | 0.46 | 0.51 | 0.52 | 0.51 | 0.52 | 0.53 | 0.52 | 0.57 | 0.55 | — | — | — | ||||||
| Benchmarks | ||||||||||||||||||||||||||
| Total Asset Turnover, Competitors2 | ||||||||||||||||||||||||||
| AbbVie Inc. | 0.40 | 0.40 | 0.41 | 0.42 | 0.42 | 0.41 | 0.40 | 0.40 | 0.38 | 0.37 | 0.36 | 0.33 | 0.30 | 0.27 | 0.24 | 0.37 | 0.37 | — | — | — | ||||||
| Amgen Inc. | 0.28 | 0.28 | 0.28 | 0.28 | 0.38 | 0.38 | 0.41 | 0.41 | 0.40 | 0.37 | 0.40 | 0.38 | 0.39 | 0.37 | 0.36 | 0.37 | 0.37 | — | — | — | ||||||
| Bristol-Myers Squibb Co. | 0.47 | 0.49 | 0.48 | 0.49 | 0.48 | 0.48 | 0.47 | 0.46 | 0.42 | 0.41 | 0.40 | 0.38 | 0.36 | 0.31 | 0.27 | 0.24 | 0.20 | — | — | — | ||||||
| Eli Lilly & Co. | 0.53 | 0.55 | 0.54 | 0.52 | 0.58 | 0.62 | 0.62 | 0.62 | 0.58 | 0.58 | 0.56 | 0.54 | 0.53 | 0.53 | 0.55 | 0.56 | 0.57 | — | — | — | ||||||
| Gilead Sciences Inc. | 0.43 | 0.44 | 0.44 | 0.43 | 0.43 | 0.43 | 0.43 | 0.43 | 0.40 | 0.41 | 0.39 | 0.37 | 0.36 | 0.37 | 0.39 | 0.37 | 0.36 | — | — | — | ||||||
| Johnson & Johnson | 0.51 | 0.57 | 0.51 | 0.49 | 0.51 | 0.55 | 0.54 | 0.53 | 0.52 | 0.51 | 0.51 | 0.49 | 0.47 | 0.47 | 0.51 | 0.53 | 0.52 | — | — | — | ||||||
| Pfizer Inc. | 0.26 | 0.32 | 0.35 | 0.48 | 0.51 | 0.51 | 0.52 | 0.50 | 0.45 | 0.39 | 0.33 | 0.29 | 0.27 | 0.24 | 0.25 | 0.29 | 0.31 | — | — | — | ||||||
| Regeneron Pharmaceuticals Inc. | 0.40 | 0.41 | 0.41 | 0.41 | 0.42 | 0.50 | 0.52 | 0.63 | 0.63 | 0.57 | 0.58 | 0.52 | 0.50 | 0.51 | 0.55 | 0.51 | 0.53 | — | — | — | ||||||
| Thermo Fisher Scientific Inc. | 0.43 | 0.45 | 0.46 | 0.46 | 0.46 | 0.49 | 0.47 | 0.44 | 0.41 | 0.53 | 0.57 | 0.54 | 0.47 | 0.44 | 0.43 | 0.44 | 0.44 | — | — | — | ||||||
Based on: 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 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).
1 Q4 2023 Calculation
Total asset turnover
= (SalesQ4 2023
+ SalesQ3 2023
+ SalesQ2 2023
+ SalesQ1 2023)
÷ Total assets
= (14,631 + 15,962 + 15,035 + 14,487)
÷ 106,675 = 0.56
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. | Merck & Co. Inc. total asset turnover ratio deteriorated from Q2 2023 to Q3 2023 but then improved from Q3 2023 to Q4 2023 exceeding Q2 2023 level. |
Equity Turnover
Merck & Co. Inc., equity turnover calculation (quarterly data)
| Dec 31, 2023 | Sep 30, 2023 | Jun 30, 2023 | Mar 31, 2023 | Dec 31, 2022 | Sep 30, 2022 | 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 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||||||||||||||||||||||
| Sales | 14,631) | 15,962) | 15,035) | 14,487) | 13,830) | 14,959) | 14,593) | 15,901) | 13,521) | 13,154) | 11,402) | 10,627) | 12,514) | 12,551) | 10,872) | 12,057) | 11,867) | 12,397) | 11,760) | 10,816) | ||||||
| Total Merck & Co., Inc. stockholders’ equity | 37,581) | 41,246) | 38,693) | 46,834) | 45,991) | 44,458) | 43,243) | 40,883) | 38,184) | 35,794) | 33,294) | 26,945) | 25,317) | 29,186) | 27,642) | 26,205) | 25,907) | 26,838) | 27,635) | 27,539) | ||||||
| Long-term Activity Ratio | ||||||||||||||||||||||||||
| Equity turnover1 | 1.60 | 1.44 | 1.51 | 1.24 | 1.29 | 1.33 | 1.32 | 1.32 | 1.28 | 1.33 | 1.41 | 1.73 | 1.90 | 1.62 | 1.71 | 1.83 | 1.81 | — | — | — | ||||||
| Benchmarks | ||||||||||||||||||||||||||
| Equity Turnover, Competitors2 | ||||||||||||||||||||||||||
| AbbVie Inc. | 5.24 | 4.56 | 4.35 | 4.27 | 3.36 | 3.62 | 3.91 | 3.48 | 3.65 | 4.07 | 4.27 | 3.66 | 3.50 | 2.66 | 2.46 | — | — | — | — | — | ||||||
| Amgen Inc. | 4.32 | 3.35 | 3.73 | 4.66 | 6.77 | 6.71 | 10.17 | 26.68 | 3.63 | 2.96 | 2.93 | 2.56 | 2.58 | 2.17 | 2.17 | 2.41 | 2.30 | — | — | — | ||||||
| Bristol-Myers Squibb Co. | 1.53 | 1.55 | 1.41 | 1.44 | 1.49 | 1.43 | 1.45 | 1.49 | 1.29 | 1.22 | 1.21 | 1.14 | 1.12 | 0.79 | 0.71 | 0.62 | 0.51 | — | — | — | ||||||
| Eli Lilly & Co. | 3.17 | 2.86 | 2.67 | 2.47 | 2.68 | 2.90 | 3.40 | 3.14 | 3.15 | 3.58 | 4.15 | 3.69 | 4.35 | 4.81 | 5.61 | 7.50 | 8.56 | — | — | — | ||||||
| Gilead Sciences Inc. | 1.18 | 1.22 | 1.28 | 1.27 | 1.27 | 1.27 | 1.34 | 1.37 | 1.28 | 1.27 | 1.34 | 1.33 | 1.34 | 1.31 | 1.21 | 1.01 | 0.98 | — | — | — | ||||||
| Johnson & Johnson | 1.24 | 1.34 | 1.30 | 1.36 | 1.24 | 1.29 | 1.25 | 1.27 | 1.27 | 1.30 | 1.28 | 1.28 | 1.31 | 1.25 | 1.28 | 1.35 | 1.38 | — | — | — | ||||||
| Pfizer Inc. | 0.66 | 0.71 | 0.79 | 0.92 | 1.05 | 1.08 | 1.16 | 1.12 | 1.05 | 0.91 | 0.79 | 0.68 | 0.66 | 0.66 | 0.70 | 0.75 | 0.82 | — | — | — | ||||||
| Regeneron Pharmaceuticals Inc. | 0.51 | 0.53 | 0.53 | 0.53 | 0.54 | 0.64 | 0.69 | 0.83 | 0.86 | 0.78 | 0.82 | 0.77 | 0.77 | 0.81 | 0.88 | 0.66 | 0.71 | — | — | — | ||||||
| Thermo Fisher Scientific Inc. | 0.92 | 0.96 | 0.99 | 1.04 | 1.02 | 1.01 | 1.01 | 1.00 | 0.96 | 1.01 | 1.04 | 1.02 | 0.93 | 0.90 | 0.88 | 0.90 | 0.86 | — | — | — | ||||||
Based on: 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 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).
1 Q4 2023 Calculation
Equity turnover
= (SalesQ4 2023
+ SalesQ3 2023
+ SalesQ2 2023
+ SalesQ1 2023)
÷ Total Merck & Co., Inc. stockholders’ equity
= (14,631 + 15,962 + 15,035 + 14,487)
÷ 37,581 = 1.60
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. | Merck & Co. Inc. equity turnover ratio deteriorated from Q2 2023 to Q3 2023 but then improved from Q3 2023 to Q4 2023 exceeding Q2 2023 level. |