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)
PepsiCo Inc., long-term (investment) activity ratios (quarterly data)
Based on: 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 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. | PepsiCo Inc. total asset turnover ratio deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023. |
| Equity turnover | An activity ratio calculated as total revenue divided by shareholders’ equity. | PepsiCo Inc. equity turnover ratio deteriorated from Q2 2023 to Q3 2023 but then slightly improved from Q3 2023 to Q4 2023. |
Net Fixed Asset Turnover
PepsiCo Inc., net fixed asset turnover calculation (quarterly data)
| 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 | 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,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.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.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.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 | — | — | — | ||||||
| Mondelēz International Inc. | 3.72 | 3.87 | 3.67 | 3.60 | 3.49 | 3.53 | 3.41 | 3.24 | 3.32 | 3.27 | 3.14 | 3.09 | 2.94 | 3.07 | 3.09 | 3.23 | 2.96 | — | — | — | ||||||
Based on: 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 Q4 2023 Calculation
Net fixed asset turnover
= (Net revenueQ4 2023
+ Net revenueQ3 2023
+ Net revenueQ2 2023
+ Net revenueQ1 2023)
÷ Property, plant and equipment, net
= (27,850 + 23,453 + 22,322 + 17,846)
÷ 27,039 = 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 improved from Q2 2023 to Q3 2023 but then deteriorated significantly from Q3 2023 to Q4 2023. |
Total Asset Turnover
PepsiCo Inc., total asset turnover calculation (quarterly data)
| 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 | 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,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.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.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.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 | — | — | — | ||||||
| Mondelēz International Inc. | 0.50 | 0.50 | 0.47 | 0.45 | 0.44 | 0.45 | 0.45 | 0.43 | 0.43 | 0.42 | 0.42 | 0.41 | 0.39 | 0.40 | 0.40 | 0.41 | 0.40 | — | — | — | ||||||
Based on: 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 Q4 2023 Calculation
Total asset turnover
= (Net revenueQ4 2023
+ Net revenueQ3 2023
+ Net revenueQ2 2023
+ Net revenueQ1 2023)
÷ Total assets
= (27,850 + 23,453 + 22,322 + 17,846)
÷ 100,495 = 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 deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023. |
Equity Turnover
PepsiCo Inc., equity turnover calculation (quarterly data)
| 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 | 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 | 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.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.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 | — | — | — | ||||||
| Mondelēz International Inc. | 1.27 | 1.24 | 1.19 | 1.17 | 1.17 | 1.14 | 1.09 | 1.04 | 1.02 | 1.02 | 1.01 | 1.00 | 0.96 | 0.97 | 0.99 | 1.01 | 0.95 | — | — | — | ||||||
Based on: 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 Q4 2023 Calculation
Equity turnover
= (Net revenueQ4 2023
+ Net revenueQ3 2023
+ Net revenueQ2 2023
+ Net revenueQ1 2023)
÷ Total PepsiCo common shareholders’ equity
= (27,850 + 23,453 + 22,322 + 17,846)
÷ 18,503 = 4.94
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 Q2 2023 to Q3 2023 but then slightly improved from Q3 2023 to Q4 2023. |