Stock Analysis on Net

PepsiCo Inc. (NASDAQ:PEP)

Analysis of Short-term (Operating) Activity Ratios 
Quarterly Data

Microsoft Excel

Short-term Activity Ratios (Summary)

PepsiCo Inc., short-term (operating) activity ratios (quarterly data)

Microsoft Excel
Mar 22, 2025 Dec 28, 2024 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
Turnover Ratios
Inventory turnover 7.32 7.87 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
Receivables turnover 8.47 8.89 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
Working capital turnover
Average No. Days
Average inventory processing period 50 46 49 51 48 46 48 52 51 47 47 50 46 43 45 54 51 48
Add: Average receivable collection period 43 41 48 47 43 43 47 46 43 43 47 47 43 40 45 48 45 44
Operating cycle 93 87 97 98 91 89 95 98 94 90 94 97 89 83 90 102 96 92

Based on: 10-Q (reporting date: 2025-03-22), 10-K (reporting date: 2024-12-28), 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).

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 improved from Q3 2024 to Q4 2024 but then deteriorated significantly from Q4 2024 to Q1 2025.
Receivables turnover An activity ratio equal to revenue divided by receivables. PepsiCo Inc. receivables turnover ratio improved from Q3 2024 to Q4 2024 but then slightly deteriorated from Q4 2024 to Q1 2025.

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 improved from Q3 2024 to Q4 2024 but then deteriorated significantly from Q4 2024 to Q1 2025.
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 improved from Q3 2024 to Q4 2024 but then slightly deteriorated from Q4 2024 to Q1 2025.
Operating cycle Equal to average inventory processing period plus average receivables collection period. PepsiCo Inc. operating cycle improved from Q3 2024 to Q4 2024 but then slightly deteriorated from Q4 2024 to Q1 2025 not reaching Q3 2024 level.

Inventory Turnover

PepsiCo Inc., inventory turnover calculation (quarterly data)

Microsoft Excel
Mar 22, 2025 Dec 28, 2024 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
Selected Financial Data (US$ in millions)
Cost of sales 7,926 13,181 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
Inventories 5,660 5,306 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
Short-term Activity Ratio
Inventory turnover1 7.32 7.87 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
Benchmarks
Inventory Turnover, Competitors2
Coca-Cola Co. 3.58 3.88 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
Mondelēz International Inc. 5.76 5.80 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
Philip Morris International Inc. 1.30 1.41 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

Based on: 10-Q (reporting date: 2025-03-22), 10-K (reporting date: 2024-12-28), 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).

1 Q1 2025 Calculation
Inventory turnover = (Cost of salesQ1 2025 + Cost of salesQ4 2024 + Cost of salesQ3 2024 + Cost of salesQ2 2024) ÷ Inventories
= (7,926 + 13,181 + 10,396 + 9,919) ÷ 5,660 = 7.32

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 improved from Q3 2024 to Q4 2024 but then deteriorated significantly from Q4 2024 to Q1 2025.

Receivables Turnover

PepsiCo Inc., receivables turnover calculation (quarterly data)

Microsoft Excel
Mar 22, 2025 Dec 28, 2024 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
Selected Financial Data (US$ in millions)
Net revenue 17,919 27,784 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
Accounts and notes receivable, less allowance 10,800 10,333 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
Short-term Activity Ratio
Receivables turnover1 8.47 8.89 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
Benchmarks
Receivables Turnover, Competitors2
Coca-Cola Co. 11.46 13.19 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
Mondelēz International Inc. 8.44 9.41 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
Philip Morris International Inc. 7.87 10.00 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

Based on: 10-Q (reporting date: 2025-03-22), 10-K (reporting date: 2024-12-28), 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).

1 Q1 2025 Calculation
Receivables turnover = (Net revenueQ1 2025 + Net revenueQ4 2024 + Net revenueQ3 2024 + Net revenueQ2 2024) ÷ Accounts and notes receivable, less allowance
= (17,919 + 27,784 + 23,319 + 22,501) ÷ 10,800 = 8.47

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 improved from Q3 2024 to Q4 2024 but then slightly deteriorated from Q4 2024 to Q1 2025.

Working Capital Turnover

PepsiCo Inc., working capital turnover calculation (quarterly data)

Microsoft Excel
Mar 22, 2025 Dec 28, 2024 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
Selected Financial Data (US$ in millions)
Current assets 26,288 25,826 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
Less: Current liabilities 31,511 31,536 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
Working capital (5,223) (5,710) (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
 
Net revenue 17,919 27,784 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
Short-term Activity Ratio
Working capital turnover1
Benchmarks
Working Capital Turnover, Competitors2
Coca-Cola Co. 19.78 62.92 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
Mondelēz International Inc.
Philip Morris International Inc. 10.52 10.81 15.29

Based on: 10-Q (reporting date: 2025-03-22), 10-K (reporting date: 2024-12-28), 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).

1 Q1 2025 Calculation
Working capital turnover = (Net revenueQ1 2025 + Net revenueQ4 2024 + Net revenueQ3 2024 + Net revenueQ2 2024) ÷ Working capital
= (17,919 + 27,784 + 23,319 + 22,501) ÷ -5,223 =

2 Click competitor name to see calculations.


Average Inventory Processing Period

PepsiCo Inc., average inventory processing period calculation (quarterly data)

Microsoft Excel
Mar 22, 2025 Dec 28, 2024 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
Selected Financial Data
Inventory turnover 7.32 7.87 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
Short-term Activity Ratio (no. days)
Average inventory processing period1 50 46 49 51 48 46 48 52 51 47 47 50 46 43 45 54 51 48
Benchmarks (no. days)
Average Inventory Processing Period, Competitors2
Coca-Cola Co. 102 94 94 95 98 87 84 93 95 86 77 78 86 81 78 84 90 89
Mondelēz International Inc. 63 63 70 68 62 59 63 65 63 61 64 60 58 57 62 64 60 60
Philip Morris International Inc. 281 259 255 260 279 305 278 291 330 316 237 259 306 317 305 330 349 366

Based on: 10-Q (reporting date: 2025-03-22), 10-K (reporting date: 2024-12-28), 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).

1 Q1 2025 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 7.32 = 50

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 improved from Q3 2024 to Q4 2024 but then deteriorated significantly from Q4 2024 to Q1 2025.

Average Receivable Collection Period

PepsiCo Inc., average receivable collection period calculation (quarterly data)

Microsoft Excel
Mar 22, 2025 Dec 28, 2024 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
Selected Financial Data
Receivables turnover 8.47 8.89 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
Short-term Activity Ratio (no. days)
Average receivable collection period1 43 41 48 47 43 43 47 46 43 43 47 47 43 40 45 48 45 44
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
Coca-Cola Co. 32 28 33 36 34 27 28 33 39 30 34 40 42 33 38 40 41 35
Mondelēz International Inc. 43 39 38 32 40 37 36 31 39 36 34 30 37 30 34 29 36 32
Philip Morris International Inc. 46 37 42 42 43 36 41 45 41 44 44 44 42 36 40 43 41 37

Based on: 10-Q (reporting date: 2025-03-22), 10-K (reporting date: 2024-12-28), 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).

1 Q1 2025 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 8.47 = 43

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 improved from Q3 2024 to Q4 2024 but then slightly deteriorated from Q4 2024 to Q1 2025.

Operating Cycle

PepsiCo Inc., operating cycle calculation (quarterly data)

No. days

Microsoft Excel
Mar 22, 2025 Dec 28, 2024 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
Selected Financial Data
Average inventory processing period 50 46 49 51 48 46 48 52 51 47 47 50 46 43 45 54 51 48
Average receivable collection period 43 41 48 47 43 43 47 46 43 43 47 47 43 40 45 48 45 44
Short-term Activity Ratio
Operating cycle1 93 87 97 98 91 89 95 98 94 90 94 97 89 83 90 102 96 92
Benchmarks
Operating Cycle, Competitors2
Coca-Cola Co. 134 122 127 131 132 114 112 126 134 116 111 118 128 114 116 124 131 124
Mondelēz International Inc. 106 102 108 100 102 96 99 96 102 97 98 90 95 87 96 93 96 92
Philip Morris International Inc. 327 296 297 302 322 341 319 336 371 360 281 303 348 353 345 373 390 403

Based on: 10-Q (reporting date: 2025-03-22), 10-K (reporting date: 2024-12-28), 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).

1 Q1 2025 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 50 + 43 = 93

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 improved from Q3 2024 to Q4 2024 but then slightly deteriorated from Q4 2024 to Q1 2025 not reaching Q3 2024 level.