Stock Analysis on Net

Johnson & Johnson (NYSE:JNJ)

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

Microsoft Excel

Long-term Activity Ratios (Summary)

Johnson & Johnson, long-term (investment) activity ratios (quarterly data)

Microsoft Excel
Dec 31, 2023 Oct 1, 2023 Jul 2, 2023 Apr 2, 2023 Dec 31, 2022 Oct 2, 2022 Jul 3, 2022 Apr 3, 2022 Dec 31, 2021 Oct 3, 2021 Jul 4, 2021 Apr 4, 2021 Dec 31, 2020 Sep 27, 2020 Jun 28, 2020 Mar 29, 2020 Dec 29, 2019 Sep 29, 2019 Jun 30, 2019 Mar 31, 2019
Net fixed asset turnover 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
Total asset turnover 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
Equity turnover 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

Based on: 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-10-01), 10-Q (reporting date: 2023-07-02), 10-Q (reporting date: 2023-04-02), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-10-02), 10-Q (reporting date: 2022-07-03), 10-Q (reporting date: 2022-04-03), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-10-03), 10-Q (reporting date: 2021-07-04), 10-Q (reporting date: 2021-04-04), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-27), 10-Q (reporting date: 2020-06-28), 10-Q (reporting date: 2020-03-29), 10-K (reporting date: 2019-12-29), 10-Q (reporting date: 2019-09-29), 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. Johnson & Johnson 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. Johnson & Johnson total asset turnover ratio improved from Q2 2023 to Q3 2023 but then deteriorated significantly from Q3 2023 to Q4 2023.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Johnson & Johnson equity turnover ratio improved from Q2 2023 to Q3 2023 but then deteriorated significantly from Q3 2023 to Q4 2023.

Net Fixed Asset Turnover

Johnson & Johnson, net fixed asset turnover calculation (quarterly data)

Microsoft Excel
Dec 31, 2023 Oct 1, 2023 Jul 2, 2023 Apr 2, 2023 Dec 31, 2022 Oct 2, 2022 Jul 3, 2022 Apr 3, 2022 Dec 31, 2021 Oct 3, 2021 Jul 4, 2021 Apr 4, 2021 Dec 31, 2020 Sep 27, 2020 Jun 28, 2020 Mar 29, 2020 Dec 29, 2019 Sep 29, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data (US$ in millions)
Sales to customers 13,532 21,351 25,530 24,746 23,706 23,791 24,020 23,426 24,804 23,338 23,312 22,321 22,475 21,082 18,336 20,691 20,747 20,729 20,562 20,021
Property, plant and equipment, net 19,898 18,821 20,576 20,174 19,803 18,152 18,354 18,701 18,962 18,478 18,632 18,367 18,766 17,855 17,598 17,401 17,658 17,048 17,248 17,000
Long-term Activity Ratio
Net fixed asset turnover1 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
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
Danaher Corp. 5.25 6.59 6.98 7.31 7.96 8.40 8.12 7.94 7.77 7.71 7.84 7.59 6.83 6.68 6.35 6.03 7.78
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
Merck & Co. Inc. 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
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
Zoetis Inc. 2.67 2.71 2.73 2.78 2.93 3.05 3.12 3.17 3.21 3.26 3.24 3.15 3.03 3.12 3.15 3.21 3.23

Based on: 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-10-01), 10-Q (reporting date: 2023-07-02), 10-Q (reporting date: 2023-04-02), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-10-02), 10-Q (reporting date: 2022-07-03), 10-Q (reporting date: 2022-04-03), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-10-03), 10-Q (reporting date: 2021-07-04), 10-Q (reporting date: 2021-04-04), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-27), 10-Q (reporting date: 2020-06-28), 10-Q (reporting date: 2020-03-29), 10-K (reporting date: 2019-12-29), 10-Q (reporting date: 2019-09-29), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q4 2023 Calculation
Net fixed asset turnover = (Sales to customersQ4 2023 + Sales to customersQ3 2023 + Sales to customersQ2 2023 + Sales to customersQ1 2023) ÷ Property, plant and equipment, net
= (13,532 + 21,351 + 25,530 + 24,746) ÷ 19,898 = 4.28

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. Johnson & Johnson 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

Johnson & Johnson, total asset turnover calculation (quarterly data)

Microsoft Excel
Dec 31, 2023 Oct 1, 2023 Jul 2, 2023 Apr 2, 2023 Dec 31, 2022 Oct 2, 2022 Jul 3, 2022 Apr 3, 2022 Dec 31, 2021 Oct 3, 2021 Jul 4, 2021 Apr 4, 2021 Dec 31, 2020 Sep 27, 2020 Jun 28, 2020 Mar 29, 2020 Dec 29, 2019 Sep 29, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data (US$ in millions)
Sales to customers 13,532 21,351 25,530 24,746 23,706 23,791 24,020 23,426 24,804 23,338 23,312 22,321 22,475 21,082 18,336 20,691 20,747 20,729 20,562 20,021
Total assets 167,558 166,061 191,686 195,969 187,378 175,124 177,724 178,355 182,018 179,228 176,440 172,557 174,894 170,693 158,380 155,017 157,728 155,521 155,117 150,027
Long-term Activity Ratio
Total asset turnover1 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
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
Danaher Corp. 0.28 0.32 0.34 0.35 0.37 0.39 0.38 0.36 0.35 0.34 0.34 0.33 0.29 0.28 0.27 0.26 0.29
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
Merck & Co. Inc. 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
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
Zoetis Inc. 0.60 0.59 0.60 0.59 0.54 0.59 0.58 0.57 0.56 0.56 0.53 0.51 0.49 0.48 0.49 0.55 0.54

Based on: 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-10-01), 10-Q (reporting date: 2023-07-02), 10-Q (reporting date: 2023-04-02), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-10-02), 10-Q (reporting date: 2022-07-03), 10-Q (reporting date: 2022-04-03), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-10-03), 10-Q (reporting date: 2021-07-04), 10-Q (reporting date: 2021-04-04), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-27), 10-Q (reporting date: 2020-06-28), 10-Q (reporting date: 2020-03-29), 10-K (reporting date: 2019-12-29), 10-Q (reporting date: 2019-09-29), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q4 2023 Calculation
Total asset turnover = (Sales to customersQ4 2023 + Sales to customersQ3 2023 + Sales to customersQ2 2023 + Sales to customersQ1 2023) ÷ Total assets
= (13,532 + 21,351 + 25,530 + 24,746) ÷ 167,558 = 0.51

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. Johnson & Johnson total asset turnover ratio improved from Q2 2023 to Q3 2023 but then deteriorated significantly from Q3 2023 to Q4 2023.

Equity Turnover

Johnson & Johnson, equity turnover calculation (quarterly data)

Microsoft Excel
Dec 31, 2023 Oct 1, 2023 Jul 2, 2023 Apr 2, 2023 Dec 31, 2022 Oct 2, 2022 Jul 3, 2022 Apr 3, 2022 Dec 31, 2021 Oct 3, 2021 Jul 4, 2021 Apr 4, 2021 Dec 31, 2020 Sep 27, 2020 Jun 28, 2020 Mar 29, 2020 Dec 29, 2019 Sep 29, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data (US$ in millions)
Sales to customers 13,532 21,351 25,530 24,746 23,706 23,791 24,020 23,426 24,804 23,338 23,312 22,321 22,475 21,082 18,336 20,691 20,747 20,729 20,562 20,021
Total Johnson & Johnson shareholders’ equity 68,774 71,228 75,149 70,869 76,804 74,599 76,357 74,709 74,023 70,272 69,580 65,834 63,278 64,473 62,978 61,294 59,471 58,210 60,785 58,955
Long-term Activity Ratio
Equity turnover1 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
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
Danaher Corp. 0.45 0.54 0.56 0.58 0.63 0.67 0.66 0.65 0.65 0.65 0.62 0.61 0.56 0.54 0.52 0.58 0.59
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
Merck & Co. Inc. 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
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
Zoetis Inc. 1.71 1.65 1.78 1.80 1.83 1.72 1.75 1.69 1.71 1.63 1.70 1.71 1.77 1.82 2.13 2.30 2.31

Based on: 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-10-01), 10-Q (reporting date: 2023-07-02), 10-Q (reporting date: 2023-04-02), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-10-02), 10-Q (reporting date: 2022-07-03), 10-Q (reporting date: 2022-04-03), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-10-03), 10-Q (reporting date: 2021-07-04), 10-Q (reporting date: 2021-04-04), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-27), 10-Q (reporting date: 2020-06-28), 10-Q (reporting date: 2020-03-29), 10-K (reporting date: 2019-12-29), 10-Q (reporting date: 2019-09-29), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q4 2023 Calculation
Equity turnover = (Sales to customersQ4 2023 + Sales to customersQ3 2023 + Sales to customersQ2 2023 + Sales to customersQ1 2023) ÷ Total Johnson & Johnson shareholders’ equity
= (13,532 + 21,351 + 25,530 + 24,746) ÷ 68,774 = 1.24

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. Johnson & Johnson equity turnover ratio improved from Q2 2023 to Q3 2023 but then deteriorated significantly from Q3 2023 to Q4 2023.