Stock Analysis on Net

PepsiCo Inc. (NASDAQ:PEP)

Analysis of Liquidity Ratios

Microsoft Excel

Liquidity Ratios (Summary)

PepsiCo Inc., liquidity ratios

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Current ratio 0.85 0.80 0.83 0.98 0.86
Quick ratio 0.66 0.58 0.56 0.77 0.66
Cash ratio 0.32 0.20 0.23 0.41 0.28

Based on: 10-K (reporting date: 2023-12-30), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-25), 10-K (reporting date: 2020-12-26), 10-K (reporting date: 2019-12-28).

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. PepsiCo Inc. current ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 exceeding 2021 level.
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. PepsiCo Inc. quick ratio improved from 2021 to 2022 and from 2022 to 2023.
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. PepsiCo Inc. cash ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 exceeding 2021 level.

Current Ratio

PepsiCo Inc., current ratio calculation, comparison to benchmarks

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Selected Financial Data (US$ in millions)
Current assets 26,950 21,539 21,783 23,001 17,645
Current liabilities 31,647 26,785 26,220 23,372 20,461
Liquidity Ratio
Current ratio1 0.85 0.80 0.83 0.98 0.86
Benchmarks
Current Ratio, Competitors2
Altria Group Inc. 0.49 0.84 0.71 0.79 0.59
Coca-Cola Co. 1.13 1.15 1.13 1.32 0.76
Mondelēz International Inc. 0.62 0.60 0.74 0.66 0.50
Current Ratio, Sector
Food, Beverage & Tobacco 0.83 0.86 0.88 0.95 0.71
Current Ratio, Industry
Consumer Staples 0.84 0.89 0.92 0.90 0.79

Based on: 10-K (reporting date: 2023-12-30), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-25), 10-K (reporting date: 2020-12-26), 10-K (reporting date: 2019-12-28).

1 2023 Calculation
Current ratio = Current assets ÷ Current liabilities
= 26,950 ÷ 31,647 = 0.85

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. PepsiCo Inc. current ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 exceeding 2021 level.

Quick Ratio

PepsiCo Inc., quick ratio calculation, comparison to benchmarks

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Selected Financial Data (US$ in millions)
Cash and cash equivalents 9,711 4,954 5,596 8,185 5,509
Short-term investments 292 394 392 1,366 229
Accounts and notes receivable, net 10,815 10,163 8,680 8,404 7,822
Total quick assets 20,818 15,511 14,668 17,955 13,560
 
Current liabilities 31,647 26,785 26,220 23,372 20,461
Liquidity Ratio
Quick ratio1 0.66 0.58 0.56 0.77 0.66
Benchmarks
Quick Ratio, Competitors2
Altria Group Inc. 0.33 0.67 0.54 0.56 0.28
Coca-Cola Co. 0.72 0.77 0.81 0.96 0.56
Mondelēz International Inc. 0.33 0.35 0.48 0.43 0.28
Quick Ratio, Sector
Food, Beverage & Tobacco 0.56 0.59 0.61 0.70 0.50
Quick Ratio, Industry
Consumer Staples 0.37 0.40 0.43 0.46 0.36

Based on: 10-K (reporting date: 2023-12-30), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-25), 10-K (reporting date: 2020-12-26), 10-K (reporting date: 2019-12-28).

1 2023 Calculation
Quick ratio = Total quick assets ÷ Current liabilities
= 20,818 ÷ 31,647 = 0.66

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. PepsiCo Inc. quick ratio improved from 2021 to 2022 and from 2022 to 2023.

Cash Ratio

PepsiCo Inc., cash ratio calculation, comparison to benchmarks

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Selected Financial Data (US$ in millions)
Cash and cash equivalents 9,711 4,954 5,596 8,185 5,509
Short-term investments 292 394 392 1,366 229
Total cash assets 10,003 5,348 5,988 9,551 5,738
 
Current liabilities 31,647 26,785 26,220 23,372 20,461
Liquidity Ratio
Cash ratio1 0.32 0.20 0.23 0.41 0.28
Benchmarks
Cash Ratio, Competitors2
Altria Group Inc. 0.33 0.47 0.53 0.55 0.26
Coca-Cola Co. 0.58 0.59 0.63 0.75 0.41
Mondelēz International Inc. 0.10 0.11 0.25 0.24 0.08
Cash Ratio, Sector
Food, Beverage & Tobacco 0.34 0.32 0.39 0.47 0.29
Cash Ratio, Industry
Consumer Staples 0.24 0.25 0.31 0.33 0.23

Based on: 10-K (reporting date: 2023-12-30), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-25), 10-K (reporting date: 2020-12-26), 10-K (reporting date: 2019-12-28).

1 2023 Calculation
Cash ratio = Total cash assets ÷ Current liabilities
= 10,003 ÷ 31,647 = 0.32

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. PepsiCo Inc. cash ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 exceeding 2021 level.