Analysis of Short-term (Operating) 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.
Short-term Activity Ratios (Summary)
PepsiCo Inc., short-term (operating) activity ratios (quarterly data)
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).
| Short-term activity ratio | Description | The company |
|---|---|---|
| Inventory turnover | An activity ratio calculated as cost of goods sold divided by inventory. | PepsiCo Inc. inventory turnover ratio deteriorated from Q1 2024 to Q2 2024 but then improved from Q2 2024 to Q3 2024 not reaching Q1 2024 level. |
| Receivables turnover | An activity ratio equal to revenue divided by receivables. | PepsiCo Inc. receivables turnover ratio deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024. |
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average inventory processing period | An activity ratio equal to the number of days in the period divided by inventory turnover over the period. | PepsiCo Inc. number of days of inventory outstanding deteriorated from Q1 2024 to Q2 2024 but then improved from Q2 2024 to Q3 2024 not reaching Q1 2024 level. |
| Average receivable collection period | An activity ratio equal to the number of days in the period divided by receivables turnover. | PepsiCo Inc. number of days of receivables outstanding deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024. |
| Operating cycle | Equal to average inventory processing period plus average receivables collection period. | PepsiCo Inc. operating cycle deteriorated from Q1 2024 to Q2 2024 but then slightly improved from Q2 2024 to Q3 2024. |
Inventory Turnover
PepsiCo Inc., inventory turnover calculation (quarterly data)
| 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) | ||||||||||||||||||||||||||||||
| Cost of sales | 10,396) | 9,919) | 8,248) | 13,097) | 10,675) | 10,121) | 7,988) | 13,420) | 10,308) | 9,415) | 7,433) | 12,130) | 9,394) | 8,880) | 6,671) | 10,426) | 8,156) | 7,088) | 6,127) | 9,346) | 7,694) | 7,404) | 5,688) | |||||||
| Inventories | 5,644) | 5,887) | 5,569) | 5,334) | 5,558) | 5,969) | 5,697) | 5,222) | 5,019) | 5,287) | 4,762) | 4,347) | 4,364) | 5,006) | 4,556) | 4,172) | 4,135) | 4,314) | 3,600) | 3,338) | 3,667) | 3,988) | 3,554) | |||||||
| Short-term Activity Ratio | ||||||||||||||||||||||||||||||
| Inventory turnover1 | 7.38 | 7.12 | 7.57 | 7.85 | 7.59 | 7.01 | 7.22 | 7.77 | 7.83 | 7.26 | 7.95 | 8.53 | 8.11 | 6.82 | 7.10 | 7.62 | 7.43 | 7.01 | 8.49 | 9.03 | — | — | — | |||||||
| Benchmarks | ||||||||||||||||||||||||||||||
| Inventory Turnover, Competitors2 | ||||||||||||||||||||||||||||||
| Altria Group Inc. | 5.54 | 5.23 | 5.01 | 5.12 | 5.34 | 5.38 | 5.14 | 5.46 | 6.00 | 5.93 | 5.73 | 5.96 | 6.41 | 4.10 | 3.72 | 3.98 | 4.10 | 3.96 | 3.83 | 3.09 | — | — | — | |||||||
| Coca-Cola Co. | 3.89 | 3.85 | 3.72 | 4.19 | 4.33 | 3.94 | 3.86 | 4.25 | 4.74 | 4.69 | 4.26 | 4.50 | 4.67 | 4.37 | 4.04 | 4.11 | 4.11 | 3.92 | 4.11 | 4.33 | — | — | — | |||||||
| Mondelēz International Inc. | 5.18 | 5.35 | 5.92 | 6.16 | 5.78 | 5.66 | 5.82 | 5.97 | 5.71 | 6.12 | 6.33 | 6.45 | 5.84 | 5.67 | 6.13 | 6.10 | 5.59 | 5.84 | 6.49 | 6.10 | — | — | — | |||||||
| Philip Morris International Inc. | 1.43 | 1.40 | 1.31 | 1.20 | 1.31 | 1.25 | 1.10 | 1.15 | 1.54 | 1.41 | 1.19 | 1.15 | 1.20 | 1.11 | 1.05 | 1.00 | 1.20 | 1.11 | 1.16 | 1.14 | — | — | — | |||||||
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
Inventory turnover
= (Cost of salesQ3 2024
+ Cost of salesQ2 2024
+ Cost of salesQ1 2024
+ Cost of salesQ4 2023)
÷ Inventories
= (10,396 + 9,919 + 8,248 + 13,097)
÷ 5,644 = 7.38
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Inventory turnover | An activity ratio calculated as cost of goods sold divided by inventory. | PepsiCo Inc. inventory turnover ratio deteriorated from Q1 2024 to Q2 2024 but then improved from Q2 2024 to Q3 2024 not reaching Q1 2024 level. |
Receivables Turnover
PepsiCo Inc., receivables turnover calculation (quarterly data)
| 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) | |||||||
| Accounts and notes receivable, less allowance | 12,088) | 11,942) | 10,938) | 10,815) | 11,782) | 11,456) | 10,469) | 10,163) | 10,739) | 10,498) | 9,424) | 8,680) | 9,545) | 9,722) | 8,885) | 8,404) | 9,295) | 8,780) | 8,477) | 7,822) | 8,735) | 8,502) | 7,604) | |||||||
| Short-term Activity Ratio | ||||||||||||||||||||||||||||||
| Receivables turnover1 | 7.60 | 7.71 | 8.40 | 8.46 | 7.78 | 7.87 | 8.41 | 8.50 | 7.79 | 7.80 | 8.58 | 9.16 | 8.03 | 7.67 | 8.03 | 8.37 | 7.38 | 7.71 | 8.04 | 8.59 | — | — | — | |||||||
| Benchmarks | ||||||||||||||||||||||||||||||
| Receivables Turnover, Competitors2 | ||||||||||||||||||||||||||||||
| Altria Group Inc. | 276.08 | 333.90 | 316.10 | 344.83 | 431.91 | 395.05 | 429.71 | 522.83 | 485.38 | 592.47 | 562.37 | 553.47 | 723.94 | 199.99 | 181.90 | 190.90 | 171.23 | 182.78 | 175.79 | 165.20 | — | — | — | |||||||
| Coca-Cola Co. | 10.95 | 10.22 | 10.86 | 13.42 | 12.88 | 11.12 | 9.46 | 12.33 | 10.60 | 9.19 | 8.65 | 11.01 | 9.72 | 9.02 | 8.89 | 10.50 | 8.75 | 8.92 | 8.39 | 9.38 | — | — | — | |||||||
| Mondelēz International Inc. | 9.51 | 11.37 | 9.04 | 9.91 | 10.12 | 11.63 | 9.39 | 10.20 | 10.80 | 12.11 | 9.94 | 12.29 | 10.61 | 12.51 | 10.21 | 11.57 | 10.52 | 13.08 | 9.91 | 11.69 | — | — | — | |||||||
| Philip Morris International Inc. | 8.78 | 8.60 | 8.58 | 10.16 | 8.81 | 8.07 | 8.80 | 8.25 | 8.21 | 8.32 | 8.65 | 10.06 | 9.10 | 8.50 | 8.82 | 9.88 | 9.40 | 8.72 | 10.85 | 9.68 | — | — | — | |||||||
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
Receivables turnover
= (Net revenueQ3 2024
+ Net revenueQ2 2024
+ Net revenueQ1 2024
+ Net revenueQ4 2023)
÷ Accounts and notes receivable, less allowance
= (23,319 + 22,501 + 18,250 + 27,850)
÷ 12,088 = 7.60
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Receivables turnover | An activity ratio equal to revenue divided by receivables. | PepsiCo Inc. receivables turnover ratio deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024. |
Working Capital Turnover
PepsiCo Inc., working capital turnover calculation (quarterly data)
| 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) | ||||||||||||||||||||||||||||||
| Current assets | 26,852) | 25,703) | 26,005) | 26,950) | 28,649) | 24,954) | 22,427) | 21,539) | 23,543) | 22,633) | 22,342) | 21,783) | 23,710) | 21,597) | 21,196) | 23,001) | 24,060) | 23,189) | 24,268) | 17,645) | 19,198) | 17,212) | 17,917) | |||||||
| Less: Current liabilities | 30,315) | 31,148) | 30,234) | 31,647) | 32,660) | 29,618) | 25,837) | 26,785) | 25,653) | 27,223) | 25,824) | 26,220) | 25,077) | 23,623) | 22,693) | 23,372) | 26,009) | 23,827) | 22,078) | 20,461) | 20,131) | 19,928) | 19,090) | |||||||
| Working capital | (3,463) | (5,445) | (4,229) | (4,697) | (4,011) | (4,664) | (3,410) | (5,246) | (2,110) | (4,590) | (3,482) | (4,437) | (1,367) | (2,026) | (1,497) | (371) | (1,949) | (638) | 2,190) | (2,816) | (933) | (2,716) | (1,173) | |||||||
| 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) | |||||||
| Short-term Activity Ratio | ||||||||||||||||||||||||||||||
| Working capital turnover1 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | 31.12 | — | — | — | — | |||||||
| Benchmarks | ||||||||||||||||||||||||||||||
| Working Capital Turnover, Competitors2 | ||||||||||||||||||||||||||||||
| Altria Group Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Coca-Cola Co. | 26.97 | 19.89 | 41.66 | 14.47 | 13.02 | 12.70 | 12.35 | 15.00 | 15.68 | 15.83 | 11.91 | 14.90 | 4.58 | 5.07 | 6.14 | 7.12 | 9.51 | 13.61 | — | — | — | — | — | |||||||
| Mondelēz International Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Philip Morris International Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | 10.52 | 10.81 | 15.29 | 15.02 | 14.70 | 109.05 | 17.73 | — | — | — | |||||||
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
Working capital turnover
= (Net revenueQ3 2024
+ Net revenueQ2 2024
+ Net revenueQ1 2024
+ Net revenueQ4 2023)
÷ Working capital
= (23,319 + 22,501 + 18,250 + 27,850)
÷ -3,463 = —
2 Click competitor name to see calculations.
Average Inventory Processing Period
PepsiCo Inc., average inventory processing period calculation (quarterly data)
| 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 | ||||||||||||||||||||||||||||||
| Inventory turnover | 7.38 | 7.12 | 7.57 | 7.85 | 7.59 | 7.01 | 7.22 | 7.77 | 7.83 | 7.26 | 7.95 | 8.53 | 8.11 | 6.82 | 7.10 | 7.62 | 7.43 | 7.01 | 8.49 | 9.03 | — | — | — | |||||||
| Short-term Activity Ratio (no. days) | ||||||||||||||||||||||||||||||
| Average inventory processing period1 | 49 | 51 | 48 | 46 | 48 | 52 | 51 | 47 | 47 | 50 | 46 | 43 | 45 | 54 | 51 | 48 | 49 | 52 | 43 | 40 | — | — | — | |||||||
| Benchmarks (no. days) | ||||||||||||||||||||||||||||||
| Average Inventory Processing Period, Competitors2 | ||||||||||||||||||||||||||||||
| Altria Group Inc. | 66 | 70 | 73 | 71 | 68 | 68 | 71 | 67 | 61 | 62 | 64 | 61 | 57 | 89 | 98 | 92 | 89 | 92 | 95 | 118 | — | — | — | |||||||
| Coca-Cola Co. | 94 | 95 | 98 | 87 | 84 | 93 | 95 | 86 | 77 | 78 | 86 | 81 | 78 | 84 | 90 | 89 | 89 | 93 | 89 | 84 | — | — | — | |||||||
| Mondelēz International Inc. | 70 | 68 | 62 | 59 | 63 | 65 | 63 | 61 | 64 | 60 | 58 | 57 | 62 | 64 | 60 | 60 | 65 | 62 | 56 | 60 | — | — | — | |||||||
| Philip Morris International Inc. | 255 | 260 | 279 | 305 | 278 | 291 | 330 | 316 | 237 | 259 | 306 | 317 | 305 | 330 | 349 | 366 | 305 | 329 | 316 | 321 | — | — | — | |||||||
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
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 7.38 = 49
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average inventory processing period | An activity ratio equal to the number of days in the period divided by inventory turnover over the period. | PepsiCo Inc. number of days of inventory outstanding deteriorated from Q1 2024 to Q2 2024 but then improved from Q2 2024 to Q3 2024 not reaching Q1 2024 level. |
Average Receivable Collection Period
PepsiCo Inc., average receivable collection period calculation (quarterly data)
| 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 | ||||||||||||||||||||||||||||||
| Receivables turnover | 7.60 | 7.71 | 8.40 | 8.46 | 7.78 | 7.87 | 8.41 | 8.50 | 7.79 | 7.80 | 8.58 | 9.16 | 8.03 | 7.67 | 8.03 | 8.37 | 7.38 | 7.71 | 8.04 | 8.59 | — | — | — | |||||||
| Short-term Activity Ratio (no. days) | ||||||||||||||||||||||||||||||
| Average receivable collection period1 | 48 | 47 | 43 | 43 | 47 | 46 | 43 | 43 | 47 | 47 | 43 | 40 | 45 | 48 | 45 | 44 | 49 | 47 | 45 | 43 | — | — | — | |||||||
| Benchmarks (no. days) | ||||||||||||||||||||||||||||||
| Average Receivable Collection Period, Competitors2 | ||||||||||||||||||||||||||||||
| Altria Group Inc. | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | — | — | — | |||||||
| Coca-Cola Co. | 33 | 36 | 34 | 27 | 28 | 33 | 39 | 30 | 34 | 40 | 42 | 33 | 38 | 40 | 41 | 35 | 42 | 41 | 43 | 39 | — | — | — | |||||||
| Mondelēz International Inc. | 38 | 32 | 40 | 37 | 36 | 31 | 39 | 36 | 34 | 30 | 37 | 30 | 34 | 29 | 36 | 32 | 35 | 28 | 37 | 31 | — | — | — | |||||||
| Philip Morris International Inc. | 42 | 42 | 43 | 36 | 41 | 45 | 41 | 44 | 44 | 44 | 42 | 36 | 40 | 43 | 41 | 37 | 39 | 42 | 34 | 38 | — | — | — | |||||||
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
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 7.60 = 48
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average receivable collection period | An activity ratio equal to the number of days in the period divided by receivables turnover. | PepsiCo Inc. number of days of receivables outstanding deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024. |
Operating Cycle
PepsiCo Inc., operating cycle calculation (quarterly data)
No. days
| 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 | ||||||||||||||||||||||||||||||
| Average inventory processing period | 49 | 51 | 48 | 46 | 48 | 52 | 51 | 47 | 47 | 50 | 46 | 43 | 45 | 54 | 51 | 48 | 49 | 52 | 43 | 40 | — | — | — | |||||||
| Average receivable collection period | 48 | 47 | 43 | 43 | 47 | 46 | 43 | 43 | 47 | 47 | 43 | 40 | 45 | 48 | 45 | 44 | 49 | 47 | 45 | 43 | — | — | — | |||||||
| Short-term Activity Ratio | ||||||||||||||||||||||||||||||
| Operating cycle1 | 97 | 98 | 91 | 89 | 95 | 98 | 94 | 90 | 94 | 97 | 89 | 83 | 90 | 102 | 96 | 92 | 98 | 99 | 88 | 83 | — | — | — | |||||||
| Benchmarks | ||||||||||||||||||||||||||||||
| Operating Cycle, Competitors2 | ||||||||||||||||||||||||||||||
| Altria Group Inc. | 67 | 71 | 74 | 72 | 69 | 69 | 72 | 68 | 62 | 63 | 65 | 62 | 58 | 91 | 100 | 94 | 91 | 94 | 97 | 120 | — | — | — | |||||||
| Coca-Cola Co. | 127 | 131 | 132 | 114 | 112 | 126 | 134 | 116 | 111 | 118 | 128 | 114 | 116 | 124 | 131 | 124 | 131 | 134 | 132 | 123 | — | — | — | |||||||
| Mondelēz International Inc. | 108 | 100 | 102 | 96 | 99 | 96 | 102 | 97 | 98 | 90 | 95 | 87 | 96 | 93 | 96 | 92 | 100 | 90 | 93 | 91 | — | — | — | |||||||
| Philip Morris International Inc. | 297 | 302 | 322 | 341 | 319 | 336 | 371 | 360 | 281 | 303 | 348 | 353 | 345 | 373 | 390 | 403 | 344 | 371 | 350 | 359 | — | — | — | |||||||
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
Operating cycle = Average inventory processing period + Average receivable collection period
= 49 + 48 = 97
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Operating cycle | Equal to average inventory processing period plus average receivables collection period. | PepsiCo Inc. operating cycle deteriorated from Q1 2024 to Q2 2024 but then slightly improved from Q2 2024 to Q3 2024. |