Stock Analysis on Net

PepsiCo Inc. (NASDAQ:PEP)

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

Microsoft Excel

Long-term Activity Ratios (Summary)

PepsiCo Inc., long-term (investment) activity ratios (quarterly data)

Microsoft Excel
Sep 7, 2024 Jun 15, 2024 Mar 23, 2024 Dec 30, 2023 Sep 9, 2023 Jun 17, 2023 Mar 25, 2023 Dec 31, 2022 Sep 3, 2022 Jun 11, 2022 Mar 19, 2022 Dec 25, 2021 Sep 4, 2021 Jun 12, 2021 Mar 20, 2021 Dec 26, 2020 Sep 5, 2020 Jun 13, 2020 Mar 21, 2020 Dec 28, 2019 Sep 7, 2019 Jun 15, 2019 Mar 23, 2019
Net fixed asset turnover 3.38 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
Total asset turnover 0.91 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
Equity turnover 4.73 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

Based on: 10-Q (reporting date: 2024-09-07), 10-Q (reporting date: 2024-06-15), 10-Q (reporting date: 2024-03-23), 10-K (reporting date: 2023-12-30), 10-Q (reporting date: 2023-09-09), 10-Q (reporting date: 2023-06-17), 10-Q (reporting date: 2023-03-25), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-03), 10-Q (reporting date: 2022-06-11), 10-Q (reporting date: 2022-03-19), 10-K (reporting date: 2021-12-25), 10-Q (reporting date: 2021-09-04), 10-Q (reporting date: 2021-06-12), 10-Q (reporting date: 2021-03-20), 10-K (reporting date: 2020-12-26), 10-Q (reporting date: 2020-09-05), 10-Q (reporting date: 2020-06-13), 10-Q (reporting date: 2020-03-21), 10-K (reporting date: 2019-12-28), 10-Q (reporting date: 2019-09-07), 10-Q (reporting date: 2019-06-15), 10-Q (reporting date: 2019-03-23).

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. PepsiCo Inc. net fixed asset turnover ratio deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. PepsiCo Inc. total asset turnover ratio improved from Q1 2024 to Q2 2024 but then deteriorated significantly from Q2 2024 to Q3 2024.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. PepsiCo Inc. equity turnover ratio deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.

Net Fixed Asset Turnover

PepsiCo Inc., net fixed asset turnover calculation (quarterly data)

Microsoft Excel
Sep 7, 2024 Jun 15, 2024 Mar 23, 2024 Dec 30, 2023 Sep 9, 2023 Jun 17, 2023 Mar 25, 2023 Dec 31, 2022 Sep 3, 2022 Jun 11, 2022 Mar 19, 2022 Dec 25, 2021 Sep 4, 2021 Jun 12, 2021 Mar 20, 2021 Dec 26, 2020 Sep 5, 2020 Jun 13, 2020 Mar 21, 2020 Dec 28, 2019 Sep 7, 2019 Jun 15, 2019 Mar 23, 2019
Selected Financial Data (US$ in millions)
Net revenue 23,319 22,501 18,250 27,850 23,453 22,322 17,846 27,996 21,971 20,225 16,200 25,248 20,189 19,217 14,820 22,455 18,091 15,945 13,881 20,640 17,188 16,449 12,884
Property, plant and equipment, net 27,188 27,042 26,792 27,039 24,853 24,500 24,228 24,291 22,800 22,694 22,017 22,407 21,257 21,619 21,249 21,369 19,726 19,187 18,980 19,305 17,586 17,442 17,550
Long-term Activity Ratio
Net fixed asset turnover1 3.38 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
Benchmarks
Net Fixed Asset Turnover, Competitors2
Altria Group Inc. 14.84 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
Coca-Cola Co. 4.70 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
Philip Morris International Inc. 4.93 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-09-07), 10-Q (reporting date: 2024-06-15), 10-Q (reporting date: 2024-03-23), 10-K (reporting date: 2023-12-30), 10-Q (reporting date: 2023-09-09), 10-Q (reporting date: 2023-06-17), 10-Q (reporting date: 2023-03-25), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-03), 10-Q (reporting date: 2022-06-11), 10-Q (reporting date: 2022-03-19), 10-K (reporting date: 2021-12-25), 10-Q (reporting date: 2021-09-04), 10-Q (reporting date: 2021-06-12), 10-Q (reporting date: 2021-03-20), 10-K (reporting date: 2020-12-26), 10-Q (reporting date: 2020-09-05), 10-Q (reporting date: 2020-06-13), 10-Q (reporting date: 2020-03-21), 10-K (reporting date: 2019-12-28), 10-Q (reporting date: 2019-09-07), 10-Q (reporting date: 2019-06-15), 10-Q (reporting date: 2019-03-23).

1 Q3 2024 Calculation
Net fixed asset turnover = (Net revenueQ3 2024 + Net revenueQ2 2024 + Net revenueQ1 2024 + Net revenueQ4 2023) ÷ Property, plant and equipment, net
= (23,319 + 22,501 + 18,250 + 27,850) ÷ 27,188 = 3.38

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. PepsiCo Inc. net fixed asset turnover ratio deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.

Total Asset Turnover

PepsiCo Inc., total asset turnover calculation (quarterly data)

Microsoft Excel
Sep 7, 2024 Jun 15, 2024 Mar 23, 2024 Dec 30, 2023 Sep 9, 2023 Jun 17, 2023 Mar 25, 2023 Dec 31, 2022 Sep 3, 2022 Jun 11, 2022 Mar 19, 2022 Dec 25, 2021 Sep 4, 2021 Jun 12, 2021 Mar 20, 2021 Dec 26, 2020 Sep 5, 2020 Jun 13, 2020 Mar 21, 2020 Dec 28, 2019 Sep 7, 2019 Jun 15, 2019 Mar 23, 2019
Selected Financial Data (US$ in millions)
Net revenue 23,319 22,501 18,250 27,850 23,453 22,322 17,846 27,996 21,971 20,225 16,200 25,248 20,189 19,217 14,820 22,455 18,091 15,945 13,881 20,640 17,188 16,449 12,884
Total assets 100,513 99,533 100,040 100,495 99,953 95,906 93,042 92,187 94,461 93,103 92,962 92,377 93,254 92,385 91,224 92,918 92,041 89,525 85,062 78,547 77,444 75,084 75,466
Long-term Activity Ratio
Total asset turnover1 0.91 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
Benchmarks
Total Asset Turnover, Competitors2
Altria Group Inc. 0.70 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
Coca-Cola Co. 0.44 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
Philip Morris International Inc. 0.56 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-09-07), 10-Q (reporting date: 2024-06-15), 10-Q (reporting date: 2024-03-23), 10-K (reporting date: 2023-12-30), 10-Q (reporting date: 2023-09-09), 10-Q (reporting date: 2023-06-17), 10-Q (reporting date: 2023-03-25), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-03), 10-Q (reporting date: 2022-06-11), 10-Q (reporting date: 2022-03-19), 10-K (reporting date: 2021-12-25), 10-Q (reporting date: 2021-09-04), 10-Q (reporting date: 2021-06-12), 10-Q (reporting date: 2021-03-20), 10-K (reporting date: 2020-12-26), 10-Q (reporting date: 2020-09-05), 10-Q (reporting date: 2020-06-13), 10-Q (reporting date: 2020-03-21), 10-K (reporting date: 2019-12-28), 10-Q (reporting date: 2019-09-07), 10-Q (reporting date: 2019-06-15), 10-Q (reporting date: 2019-03-23).

1 Q3 2024 Calculation
Total asset turnover = (Net revenueQ3 2024 + Net revenueQ2 2024 + Net revenueQ1 2024 + Net revenueQ4 2023) ÷ Total assets
= (23,319 + 22,501 + 18,250 + 27,850) ÷ 100,513 = 0.91

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. PepsiCo Inc. total asset turnover ratio improved from Q1 2024 to Q2 2024 but then deteriorated significantly from Q2 2024 to Q3 2024.

Equity Turnover

PepsiCo Inc., equity turnover calculation (quarterly data)

Microsoft Excel
Sep 7, 2024 Jun 15, 2024 Mar 23, 2024 Dec 30, 2023 Sep 9, 2023 Jun 17, 2023 Mar 25, 2023 Dec 31, 2022 Sep 3, 2022 Jun 11, 2022 Mar 19, 2022 Dec 25, 2021 Sep 4, 2021 Jun 12, 2021 Mar 20, 2021 Dec 26, 2020 Sep 5, 2020 Jun 13, 2020 Mar 21, 2020 Dec 28, 2019 Sep 7, 2019 Jun 15, 2019 Mar 23, 2019
Selected Financial Data (US$ in millions)
Net revenue 23,319 22,501 18,250 27,850 23,453 22,322 17,846 27,996 21,971 20,225 16,200 25,248 20,189 19,217 14,820 22,455 18,091 15,945 13,881 20,640 17,188 16,449 12,884
Total PepsiCo common shareholders’ equity 19,453 19,446 19,047 18,503 18,806 17,685 17,042 17,149 18,977 18,553 18,202 16,043 15,872 15,299 13,947 13,454 13,483 12,491 13,465 14,786 14,129 13,952 14,202
Long-term Activity Ratio
Equity turnover1 4.73 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
Benchmarks
Equity Turnover, Competitors2
Altria Group Inc. 8.11 8.87 9.21 8.24 4.50 3.95 4.04
Coca-Cola Co. 1.75 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
Philip Morris International Inc.

Based on: 10-Q (reporting date: 2024-09-07), 10-Q (reporting date: 2024-06-15), 10-Q (reporting date: 2024-03-23), 10-K (reporting date: 2023-12-30), 10-Q (reporting date: 2023-09-09), 10-Q (reporting date: 2023-06-17), 10-Q (reporting date: 2023-03-25), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-03), 10-Q (reporting date: 2022-06-11), 10-Q (reporting date: 2022-03-19), 10-K (reporting date: 2021-12-25), 10-Q (reporting date: 2021-09-04), 10-Q (reporting date: 2021-06-12), 10-Q (reporting date: 2021-03-20), 10-K (reporting date: 2020-12-26), 10-Q (reporting date: 2020-09-05), 10-Q (reporting date: 2020-06-13), 10-Q (reporting date: 2020-03-21), 10-K (reporting date: 2019-12-28), 10-Q (reporting date: 2019-09-07), 10-Q (reporting date: 2019-06-15), 10-Q (reporting date: 2019-03-23).

1 Q3 2024 Calculation
Equity turnover = (Net revenueQ3 2024 + Net revenueQ2 2024 + Net revenueQ1 2024 + Net revenueQ4 2023) ÷ Total PepsiCo common shareholders’ equity
= (23,319 + 22,501 + 18,250 + 27,850) ÷ 19,453 = 4.73

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. PepsiCo Inc. equity turnover ratio deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.