Stock Analysis on Net

Coca-Cola Co. (NYSE:KO)

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

Microsoft Excel

Long-term Activity Ratios (Summary)

Coca-Cola Co., long-term (investment) activity ratios (quarterly data)

Microsoft Excel
Jun 28, 2024 Mar 29, 2024 Dec 31, 2023 Sep 29, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jul 1, 2022 Apr 1, 2022 Dec 31, 2021 Oct 1, 2021 Jul 2, 2021 Apr 2, 2021 Dec 31, 2020 Sep 25, 2020 Jun 26, 2020 Mar 27, 2020 Dec 31, 2019 Sep 27, 2019 Jun 28, 2019 Mar 29, 2019
Net fixed asset turnover 4.89 4.95 4.95 5.08 4.55 4.42 4.37 4.58 4.37 4.10 3.90 3.76 3.45 3.13 3.06 3.14 3.21 3.38 3.44
Total asset turnover 0.46 0.46 0.47 0.46 0.45 0.45 0.46 0.46 0.44 0.43 0.41 0.42 0.40 0.37 0.38 0.34 0.36 0.40 0.43
Equity turnover 1.80 1.74 1.76 1.71 1.70 1.72 1.78 1.86 1.80 1.62 1.68 1.70 1.64 1.64 1.71 1.80 1.96 2.05 1.96

Based on: 10-Q (reporting date: 2024-06-28), 10-Q (reporting date: 2024-03-29), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-29), 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-07-01), 10-Q (reporting date: 2022-04-01), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-10-01), 10-Q (reporting date: 2021-07-02), 10-Q (reporting date: 2021-04-02), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-25), 10-Q (reporting date: 2020-06-26), 10-Q (reporting date: 2020-03-27), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-27), 10-Q (reporting date: 2019-06-28), 10-Q (reporting date: 2019-03-29).

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Coca-Cola Co. net fixed asset turnover ratio deteriorated from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Coca-Cola Co. total asset turnover ratio deteriorated from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Coca-Cola Co. equity turnover ratio deteriorated from Q4 2023 to Q1 2024 but then improved from Q1 2024 to Q2 2024 exceeding Q4 2023 level.

Net Fixed Asset Turnover

Coca-Cola Co., net fixed asset turnover calculation (quarterly data)

Microsoft Excel
Jun 28, 2024 Mar 29, 2024 Dec 31, 2023 Sep 29, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jul 1, 2022 Apr 1, 2022 Dec 31, 2021 Oct 1, 2021 Jul 2, 2021 Apr 2, 2021 Dec 31, 2020 Sep 25, 2020 Jun 26, 2020 Mar 27, 2020 Dec 31, 2019 Sep 27, 2019 Jun 28, 2019 Mar 29, 2019
Selected Financial Data (US$ in millions)
Net operating revenues 12,363 11,300 10,849 11,953 11,972 10,980 10,125 11,063 11,325 10,491 9,464 10,042 10,129 9,020 8,611 8,652 7,150 8,601 9,068 9,507 9,997 8,694
Property, plant and equipment, less accumulated depreciation 9,508 9,306 9,236 8,860 9,706 9,848 9,841 9,243 9,462 9,784 9,920 10,058 10,547 10,673 10,777 10,667 10,695 10,993 10,838 10,217 10,254 8,866
Long-term Activity Ratio
Net fixed asset turnover1 4.89 4.95 4.95 5.08 4.55 4.42 4.37 4.58 4.37 4.10 3.90 3.76 3.45 3.13 3.06 3.14 3.21 3.38 3.44
Benchmarks
Net Fixed Asset Turnover, Competitors2
Altria Group Inc. 14.84 14.99 14.82 15.11 15.31 15.65 15.61 15.90 16.36 16.72 16.75 17.17 13.66 13.03 13.00 12.87 12.78 12.94 12.56
PepsiCo Inc. 3.40 3.43 3.38 3.69 3.68 3.63 3.56 3.67 3.61 3.67 3.55 3.61 3.45 3.36 3.29 3.48 3.53 3.59 3.48
Philip Morris International Inc. 5.02 4.99 4.68 4.98 4.74 4.72 4.73 5.65 5.33 5.26 5.09 5.07 5.03 4.89 4.51 4.72 4.72 4.95 4.49

Based on: 10-Q (reporting date: 2024-06-28), 10-Q (reporting date: 2024-03-29), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-29), 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-07-01), 10-Q (reporting date: 2022-04-01), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-10-01), 10-Q (reporting date: 2021-07-02), 10-Q (reporting date: 2021-04-02), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-25), 10-Q (reporting date: 2020-06-26), 10-Q (reporting date: 2020-03-27), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-27), 10-Q (reporting date: 2019-06-28), 10-Q (reporting date: 2019-03-29).

1 Q2 2024 Calculation
Net fixed asset turnover = (Net operating revenuesQ2 2024 + Net operating revenuesQ1 2024 + Net operating revenuesQ4 2023 + Net operating revenuesQ3 2023) ÷ Property, plant and equipment, less accumulated depreciation
= (12,363 + 11,300 + 10,849 + 11,953) ÷ 9,508 = 4.89

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. Coca-Cola Co. net fixed asset turnover ratio deteriorated from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024.

Total Asset Turnover

Coca-Cola Co., total asset turnover calculation (quarterly data)

Microsoft Excel
Jun 28, 2024 Mar 29, 2024 Dec 31, 2023 Sep 29, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jul 1, 2022 Apr 1, 2022 Dec 31, 2021 Oct 1, 2021 Jul 2, 2021 Apr 2, 2021 Dec 31, 2020 Sep 25, 2020 Jun 26, 2020 Mar 27, 2020 Dec 31, 2019 Sep 27, 2019 Jun 28, 2019 Mar 29, 2019
Selected Financial Data (US$ in millions)
Net operating revenues 12,363 11,300 10,849 11,953 11,972 10,980 10,125 11,063 11,325 10,491 9,464 10,042 10,129 9,020 8,611 8,652 7,150 8,601 9,068 9,507 9,997 8,694
Total assets 101,202 99,392 97,703 97,578 98,456 97,404 92,763 92,471 93,169 94,064 94,354 90,606 90,194 89,993 87,296 97,184 94,689 94,013 86,381 87,433 89,996 88,347
Long-term Activity Ratio
Total asset turnover1 0.46 0.46 0.47 0.46 0.45 0.45 0.46 0.46 0.44 0.43 0.41 0.42 0.40 0.37 0.38 0.34 0.36 0.40 0.43
Benchmarks
Total Asset Turnover, Competitors2
Altria Group Inc. 0.70 0.67 0.63 0.68 0.67 0.68 0.68 0.74 0.69 0.64 0.66 0.66 0.59 0.53 0.55 0.55 0.51 0.49 0.51
PepsiCo Inc. 0.92 0.92 0.91 0.92 0.94 0.95 0.94 0.89 0.88 0.87 0.86 0.82 0.81 0.78 0.76 0.74 0.76 0.80 0.86
Philip Morris International Inc. 0.55 0.55 0.54 0.54 0.54 0.52 0.51 0.78 0.78 0.76 0.76 0.74 0.74 0.73 0.64 0.74 0.74 0.81 0.70

Based on: 10-Q (reporting date: 2024-06-28), 10-Q (reporting date: 2024-03-29), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-29), 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-07-01), 10-Q (reporting date: 2022-04-01), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-10-01), 10-Q (reporting date: 2021-07-02), 10-Q (reporting date: 2021-04-02), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-25), 10-Q (reporting date: 2020-06-26), 10-Q (reporting date: 2020-03-27), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-27), 10-Q (reporting date: 2019-06-28), 10-Q (reporting date: 2019-03-29).

1 Q2 2024 Calculation
Total asset turnover = (Net operating revenuesQ2 2024 + Net operating revenuesQ1 2024 + Net operating revenuesQ4 2023 + Net operating revenuesQ3 2023) ÷ Total assets
= (12,363 + 11,300 + 10,849 + 11,953) ÷ 101,202 = 0.46

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. Coca-Cola Co. total asset turnover ratio deteriorated from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024.

Equity Turnover

Coca-Cola Co., equity turnover calculation (quarterly data)

Microsoft Excel
Jun 28, 2024 Mar 29, 2024 Dec 31, 2023 Sep 29, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jul 1, 2022 Apr 1, 2022 Dec 31, 2021 Oct 1, 2021 Jul 2, 2021 Apr 2, 2021 Dec 31, 2020 Sep 25, 2020 Jun 26, 2020 Mar 27, 2020 Dec 31, 2019 Sep 27, 2019 Jun 28, 2019 Mar 29, 2019
Selected Financial Data (US$ in millions)
Net operating revenues 12,363 11,300 10,849 11,953 11,972 10,980 10,125 11,063 11,325 10,491 9,464 10,042 10,129 9,020 8,611 8,652 7,150 8,601 9,068 9,507 9,997 8,694
Equity attributable to shareowners of The Coca-Cola Company 25,853 26,429 25,941 26,325 26,013 25,217 24,105 22,805 23,005 24,845 22,999 22,179 22,249 20,355 19,299 18,607 17,484 18,158 18,981 18,713 18,181 17,735
Long-term Activity Ratio
Equity turnover1 1.80 1.74 1.76 1.71 1.70 1.72 1.78 1.86 1.80 1.62 1.68 1.70 1.64 1.64 1.71 1.80 1.96 2.05 1.96
Benchmarks
Equity Turnover, Competitors2
Altria Group Inc. 8.11 8.87 9.21 8.24 4.50 3.95 4.04
PepsiCo Inc. 4.73 4.82 4.94 4.87 5.10 5.17 5.04 4.41 4.41 4.44 4.95 4.83 4.88 5.11 5.23 5.08 5.42 5.06 4.54
Philip Morris International Inc.

Based on: 10-Q (reporting date: 2024-06-28), 10-Q (reporting date: 2024-03-29), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-29), 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-07-01), 10-Q (reporting date: 2022-04-01), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-10-01), 10-Q (reporting date: 2021-07-02), 10-Q (reporting date: 2021-04-02), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-25), 10-Q (reporting date: 2020-06-26), 10-Q (reporting date: 2020-03-27), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-27), 10-Q (reporting date: 2019-06-28), 10-Q (reporting date: 2019-03-29).

1 Q2 2024 Calculation
Equity turnover = (Net operating revenuesQ2 2024 + Net operating revenuesQ1 2024 + Net operating revenuesQ4 2023 + Net operating revenuesQ3 2023) ÷ Equity attributable to shareowners of The Coca-Cola Company
= (12,363 + 11,300 + 10,849 + 11,953) ÷ 25,853 = 1.80

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. Coca-Cola Co. equity turnover ratio deteriorated from Q4 2023 to Q1 2024 but then improved from Q1 2024 to Q2 2024 exceeding Q4 2023 level.