Stock Analysis on Net

PepsiCo Inc. (NASDAQ:PEP)

Analysis of Reportable Segments

Microsoft Excel

Segment Profit Margin

PepsiCo Inc., profit margin by reportable segment

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Frito-Lay North America (FLNA) 27.11% 26.34% 28.73% 29.36% 30.79%
Quaker Foods North America (QFNA) 15.87% 19.11% 21.01% 24.40% 21.92%
PepsiCo Beverages North America (PBNA) 9.35% 20.70% 9.66% 8.59% 10.03%
Latin America (LatAm) 19.32% 16.64% 16.88% 14.88% 15.07%
Europe 5.80% -10.85% 9.91% 11.35% 11.31%
Africa, Middle East and South Asia (AMESA) 13.15% 10.34% 14.12% 13.12% 18.38%
Asia Pacific, Australia and New Zealand and China Region (APAC) 14.84% 11.22% 14.58% 17.13% 16.34%

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).

Segment profitability ratio Reportable segment The company
Segment profit margin Frito-Lay North America (FLNA) Frito-Lay North America (FLNA) segment profit margin ratio deteriorated from 2021 to 2022 but then slightly improved from 2022 to 2023.
Quaker Foods North America (QFNA) Quaker Foods North America (QFNA) segment profit margin ratio deteriorated from 2021 to 2022 and from 2022 to 2023.
PepsiCo Beverages North America (PBNA) PepsiCo Beverages North America (PBNA) segment profit margin ratio improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.
Latin America (LatAm) Latin America (LatAm) segment profit margin ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 exceeding 2021 level.
Europe Europe segment profit margin ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 not reaching 2021 level.
Africa, Middle East and South Asia (AMESA) Africa, Middle East and South Asia (AMESA) segment profit margin ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 not reaching 2021 level.
Asia Pacific, Australia and New Zealand and China Region (APAC) Asia Pacific, Australia and New Zealand and China Region (APAC) segment profit margin ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 exceeding 2021 level.

Segment Profit Margin: Frito-Lay North America (FLNA)

PepsiCo Inc.; Frito-Lay North America (FLNA); segment profit margin calculation

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Selected Financial Data (US$ in millions)
Operating profit (loss) 6,755 6,135 5,633 5,340 5,258
Net revenue 24,914 23,291 19,608 18,189 17,078
Segment Profitability Ratio
Segment profit margin1 27.11% 26.34% 28.73% 29.36% 30.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
Segment profit margin = 100 × Operating profit (loss) ÷ Net revenue
= 100 × 6,755 ÷ 24,914 = 27.11%

Segment profitability ratio Reportable segment The company
Segment profit margin Frito-Lay North America (FLNA) Frito-Lay North America (FLNA) segment profit margin ratio deteriorated from 2021 to 2022 but then slightly improved from 2022 to 2023.

Segment Profit Margin: Quaker Foods North America (QFNA)

PepsiCo Inc.; Quaker Foods North America (QFNA); segment profit margin calculation

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Selected Financial Data (US$ in millions)
Operating profit (loss) 492 604 578 669 544
Net revenue 3,101 3,160 2,751 2,742 2,482
Segment Profitability Ratio
Segment profit margin1 15.87% 19.11% 21.01% 24.40% 21.92%

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
Segment profit margin = 100 × Operating profit (loss) ÷ Net revenue
= 100 × 492 ÷ 3,101 = 15.87%

Segment profitability ratio Reportable segment The company
Segment profit margin Quaker Foods North America (QFNA) Quaker Foods North America (QFNA) segment profit margin ratio deteriorated from 2021 to 2022 and from 2022 to 2023.

Segment Profit Margin: PepsiCo Beverages North America (PBNA)

PepsiCo Inc.; PepsiCo Beverages North America (PBNA); segment profit margin calculation

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Selected Financial Data (US$ in millions)
Operating profit (loss) 2,584 5,426 2,442 1,937 2,179
Net revenue 27,626 26,213 25,276 22,559 21,730
Segment Profitability Ratio
Segment profit margin1 9.35% 20.70% 9.66% 8.59% 10.03%

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
Segment profit margin = 100 × Operating profit (loss) ÷ Net revenue
= 100 × 2,584 ÷ 27,626 = 9.35%

Segment profitability ratio Reportable segment The company
Segment profit margin PepsiCo Beverages North America (PBNA) PepsiCo Beverages North America (PBNA) segment profit margin ratio improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.

Segment Profit Margin: Latin America (LatAm)

PepsiCo Inc.; Latin America (LatAm); segment profit margin calculation

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Selected Financial Data (US$ in millions)
Operating profit (loss) 2,252 1,627 1,369 1,033 1,141
Net revenue 11,654 9,779 8,108 6,942 7,573
Segment Profitability Ratio
Segment profit margin1 19.32% 16.64% 16.88% 14.88% 15.07%

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
Segment profit margin = 100 × Operating profit (loss) ÷ Net revenue
= 100 × 2,252 ÷ 11,654 = 19.32%

Segment profitability ratio Reportable segment The company
Segment profit margin Latin America (LatAm) Latin America (LatAm) segment profit margin ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 exceeding 2021 level.

Segment Profit Margin: Europe

PepsiCo Inc.; Europe; segment profit margin calculation

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Selected Financial Data (US$ in millions)
Operating profit (loss) 767 (1,380) 1,292 1,353 1,327
Net revenue 13,234 12,724 13,038 11,922 11,728
Segment Profitability Ratio
Segment profit margin1 5.80% -10.85% 9.91% 11.35% 11.31%

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
Segment profit margin = 100 × Operating profit (loss) ÷ Net revenue
= 100 × 767 ÷ 13,234 = 5.80%

Segment profitability ratio Reportable segment The company
Segment profit margin Europe Europe segment profit margin ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 not reaching 2021 level.

Segment Profit Margin: Africa, Middle East and South Asia (AMESA)

PepsiCo Inc.; Africa, Middle East and South Asia (AMESA); segment profit margin calculation

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Selected Financial Data (US$ in millions)
Operating profit (loss) 807 666 858 600 671
Net revenue 6,139 6,438 6,078 4,573 3,651
Segment Profitability Ratio
Segment profit margin1 13.15% 10.34% 14.12% 13.12% 18.38%

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
Segment profit margin = 100 × Operating profit (loss) ÷ Net revenue
= 100 × 807 ÷ 6,139 = 13.15%

Segment profitability ratio Reportable segment The company
Segment profit margin Africa, Middle East and South Asia (AMESA) Africa, Middle East and South Asia (AMESA) segment profit margin ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 not reaching 2021 level.

Segment Profit Margin: Asia Pacific, Australia and New Zealand and China Region (APAC)

PepsiCo Inc.; Asia Pacific, Australia and New Zealand and China Region (APAC); segment profit margin calculation

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Selected Financial Data (US$ in millions)
Operating profit (loss) 713 537 673 590 477
Net revenue 4,803 4,787 4,615 3,445 2,919
Segment Profitability Ratio
Segment profit margin1 14.84% 11.22% 14.58% 17.13% 16.34%

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
Segment profit margin = 100 × Operating profit (loss) ÷ Net revenue
= 100 × 713 ÷ 4,803 = 14.84%

Segment profitability ratio Reportable segment The company
Segment profit margin Asia Pacific, Australia and New Zealand and China Region (APAC) Asia Pacific, Australia and New Zealand and China Region (APAC) segment profit margin ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 exceeding 2021 level.

Segment Return on Assets (Segment ROA)

PepsiCo Inc., ROA by reportable segment

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Frito-Lay North America (FLNA) 55.48% 55.56% 57.70% 61.17% 69.93%
Quaker Foods North America (QFNA) 41.03% 48.51% 52.50% 65.52% 57.81%
PepsiCo Beverages North America (PBNA) 6.25% 13.47% 6.46% 5.22% 6.93%
Latin America (LatAm) 24.26% 20.63% 18.83% 14.81% 16.28%
Europe 4.91% -8.50% 6.99% 7.55% 7.45%
Africa, Middle East and South Asia (AMESA) 12.63% 10.84% 14.01% 10.10% 18.27%
Asia Pacific, Australia and New Zealand and China Region (APAC) 12.66% 9.85% 11.90% 10.23% 11.60%

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).

Segment profitability ratio Reportable segment The company
Segment ROA Frito-Lay North America (FLNA) Frito-Lay North America (FLNA) segment ROA deteriorated from 2021 to 2022 and from 2022 to 2023.
Quaker Foods North America (QFNA) Quaker Foods North America (QFNA) segment ROA deteriorated from 2021 to 2022 and from 2022 to 2023.
PepsiCo Beverages North America (PBNA) PepsiCo Beverages North America (PBNA) segment ROA improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.
Latin America (LatAm) Latin America (LatAm) segment ROA improved from 2021 to 2022 and from 2022 to 2023.
Europe Europe segment ROA deteriorated from 2021 to 2022 but then improved from 2022 to 2023 not reaching 2021 level.
Africa, Middle East and South Asia (AMESA) Africa, Middle East and South Asia (AMESA) segment ROA deteriorated from 2021 to 2022 but then improved from 2022 to 2023 not reaching 2021 level.
Asia Pacific, Australia and New Zealand and China Region (APAC) Asia Pacific, Australia and New Zealand and China Region (APAC) segment ROA deteriorated from 2021 to 2022 but then improved from 2022 to 2023 exceeding 2021 level.

Segment ROA: Frito-Lay North America (FLNA)

PepsiCo Inc.; Frito-Lay North America (FLNA); segment ROA calculation

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Selected Financial Data (US$ in millions)
Operating profit (loss) 6,755 6,135 5,633 5,340 5,258
Total assets 12,176 11,042 9,763 8,730 7,519
Segment Profitability Ratio
Segment ROA1 55.48% 55.56% 57.70% 61.17% 69.93%

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
Segment ROA = 100 × Operating profit (loss) ÷ Total assets
= 100 × 6,755 ÷ 12,176 = 55.48%

Segment profitability ratio Reportable segment The company
Segment ROA Frito-Lay North America (FLNA) Frito-Lay North America (FLNA) segment ROA deteriorated from 2021 to 2022 and from 2022 to 2023.

Segment ROA: Quaker Foods North America (QFNA)

PepsiCo Inc.; Quaker Foods North America (QFNA); segment ROA calculation

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Selected Financial Data (US$ in millions)
Operating profit (loss) 492 604 578 669 544
Total assets 1,199 1,245 1,101 1,021 941
Segment Profitability Ratio
Segment ROA1 41.03% 48.51% 52.50% 65.52% 57.81%

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
Segment ROA = 100 × Operating profit (loss) ÷ Total assets
= 100 × 492 ÷ 1,199 = 41.03%

Segment profitability ratio Reportable segment The company
Segment ROA Quaker Foods North America (QFNA) Quaker Foods North America (QFNA) segment ROA deteriorated from 2021 to 2022 and from 2022 to 2023.

Segment ROA: PepsiCo Beverages North America (PBNA)

PepsiCo Inc.; PepsiCo Beverages North America (PBNA); segment ROA calculation

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Selected Financial Data (US$ in millions)
Operating profit (loss) 2,584 5,426 2,442 1,937 2,179
Total assets 41,355 40,286 37,801 37,079 31,449
Segment Profitability Ratio
Segment ROA1 6.25% 13.47% 6.46% 5.22% 6.93%

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
Segment ROA = 100 × Operating profit (loss) ÷ Total assets
= 100 × 2,584 ÷ 41,355 = 6.25%

Segment profitability ratio Reportable segment The company
Segment ROA PepsiCo Beverages North America (PBNA) PepsiCo Beverages North America (PBNA) segment ROA improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.

Segment ROA: Latin America (LatAm)

PepsiCo Inc.; Latin America (LatAm); segment ROA calculation

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Selected Financial Data (US$ in millions)
Operating profit (loss) 2,252 1,627 1,369 1,033 1,141
Total assets 9,281 7,886 7,272 6,977 7,007
Segment Profitability Ratio
Segment ROA1 24.26% 20.63% 18.83% 14.81% 16.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).

1 2023 Calculation
Segment ROA = 100 × Operating profit (loss) ÷ Total assets
= 100 × 2,252 ÷ 9,281 = 24.26%

Segment profitability ratio Reportable segment The company
Segment ROA Latin America (LatAm) Latin America (LatAm) segment ROA improved from 2021 to 2022 and from 2022 to 2023.

Segment ROA: Europe

PepsiCo Inc.; Europe; segment ROA calculation

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Selected Financial Data (US$ in millions)
Operating profit (loss) 767 (1,380) 1,292 1,353 1,327
Total assets 15,615 16,230 18,472 17,917 17,814
Segment Profitability Ratio
Segment ROA1 4.91% -8.50% 6.99% 7.55% 7.45%

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
Segment ROA = 100 × Operating profit (loss) ÷ Total assets
= 100 × 767 ÷ 15,615 = 4.91%

Segment profitability ratio Reportable segment The company
Segment ROA Europe Europe segment ROA deteriorated from 2021 to 2022 but then improved from 2022 to 2023 not reaching 2021 level.

Segment ROA: Africa, Middle East and South Asia (AMESA)

PepsiCo Inc.; Africa, Middle East and South Asia (AMESA); segment ROA calculation

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Selected Financial Data (US$ in millions)
Operating profit (loss) 807 666 858 600 671
Total assets 6,389 6,143 6,125 5,942 3,672
Segment Profitability Ratio
Segment ROA1 12.63% 10.84% 14.01% 10.10% 18.27%

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
Segment ROA = 100 × Operating profit (loss) ÷ Total assets
= 100 × 807 ÷ 6,389 = 12.63%

Segment profitability ratio Reportable segment The company
Segment ROA Africa, Middle East and South Asia (AMESA) Africa, Middle East and South Asia (AMESA) segment ROA deteriorated from 2021 to 2022 but then improved from 2022 to 2023 not reaching 2021 level.

Segment ROA: Asia Pacific, Australia and New Zealand and China Region (APAC)

PepsiCo Inc.; Asia Pacific, Australia and New Zealand and China Region (APAC); segment ROA calculation

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Selected Financial Data (US$ in millions)
Operating profit (loss) 713 537 673 590 477
Total assets 5,630 5,452 5,654 5,770 4,113
Segment Profitability Ratio
Segment ROA1 12.66% 9.85% 11.90% 10.23% 11.60%

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
Segment ROA = 100 × Operating profit (loss) ÷ Total assets
= 100 × 713 ÷ 5,630 = 12.66%

Segment profitability ratio Reportable segment The company
Segment ROA Asia Pacific, Australia and New Zealand and China Region (APAC) Asia Pacific, Australia and New Zealand and China Region (APAC) segment ROA deteriorated from 2021 to 2022 but then improved from 2022 to 2023 exceeding 2021 level.

Segment Asset Turnover

PepsiCo Inc., asset turnover by reportable segment

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Frito-Lay North America (FLNA) 2.05 2.11 2.01 2.08 2.27
Quaker Foods North America (QFNA) 2.59 2.54 2.50 2.69 2.64
PepsiCo Beverages North America (PBNA) 0.67 0.65 0.67 0.61 0.69
Latin America (LatAm) 1.26 1.24 1.11 0.99 1.08
Europe 0.85 0.78 0.71 0.67 0.66
Africa, Middle East and South Asia (AMESA) 0.96 1.05 0.99 0.77 0.99
Asia Pacific, Australia and New Zealand and China Region (APAC) 0.85 0.88 0.82 0.60 0.71

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).

Segment activity ratio Reportable segment The company
Segment asset turnover Frito-Lay North America (FLNA) Frito-Lay North America (FLNA) segment asset turnover ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023 not reaching 2021 level.
Quaker Foods North America (QFNA) Quaker Foods North America (QFNA) segment asset turnover ratio improved from 2021 to 2022 and from 2022 to 2023.
PepsiCo Beverages North America (PBNA) PepsiCo Beverages North America (PBNA) segment asset turnover ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 not reaching 2021 level.
Latin America (LatAm) Latin America (LatAm) segment asset turnover ratio improved from 2021 to 2022 and from 2022 to 2023.
Europe Europe segment asset turnover ratio improved from 2021 to 2022 and from 2022 to 2023.
Africa, Middle East and South Asia (AMESA) Africa, Middle East and South Asia (AMESA) segment asset turnover ratio improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.
Asia Pacific, Australia and New Zealand and China Region (APAC) Asia Pacific, Australia and New Zealand and China Region (APAC) segment asset turnover ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023.

Segment Asset Turnover: Frito-Lay North America (FLNA)

PepsiCo Inc.; Frito-Lay North America (FLNA); segment asset turnover calculation

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Selected Financial Data (US$ in millions)
Net revenue 24,914 23,291 19,608 18,189 17,078
Total assets 12,176 11,042 9,763 8,730 7,519
Segment Activity Ratio
Segment asset turnover1 2.05 2.11 2.01 2.08 2.27

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
Segment asset turnover = Net revenue ÷ Total assets
= 24,914 ÷ 12,176 = 2.05

Segment activity ratio Reportable segment The company
Segment asset turnover Frito-Lay North America (FLNA) Frito-Lay North America (FLNA) segment asset turnover ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023 not reaching 2021 level.

Segment Asset Turnover: Quaker Foods North America (QFNA)

PepsiCo Inc.; Quaker Foods North America (QFNA); segment asset turnover calculation

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Selected Financial Data (US$ in millions)
Net revenue 3,101 3,160 2,751 2,742 2,482
Total assets 1,199 1,245 1,101 1,021 941
Segment Activity Ratio
Segment asset turnover1 2.59 2.54 2.50 2.69 2.64

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
Segment asset turnover = Net revenue ÷ Total assets
= 3,101 ÷ 1,199 = 2.59

Segment activity ratio Reportable segment The company
Segment asset turnover Quaker Foods North America (QFNA) Quaker Foods North America (QFNA) segment asset turnover ratio improved from 2021 to 2022 and from 2022 to 2023.

Segment Asset Turnover: PepsiCo Beverages North America (PBNA)

PepsiCo Inc.; PepsiCo Beverages North America (PBNA); segment asset turnover calculation

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Selected Financial Data (US$ in millions)
Net revenue 27,626 26,213 25,276 22,559 21,730
Total assets 41,355 40,286 37,801 37,079 31,449
Segment Activity Ratio
Segment asset turnover1 0.67 0.65 0.67 0.61 0.69

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
Segment asset turnover = Net revenue ÷ Total assets
= 27,626 ÷ 41,355 = 0.67

Segment activity ratio Reportable segment The company
Segment asset turnover PepsiCo Beverages North America (PBNA) PepsiCo Beverages North America (PBNA) segment asset turnover ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 not reaching 2021 level.

Segment Asset Turnover: Latin America (LatAm)

PepsiCo Inc.; Latin America (LatAm); segment asset turnover calculation

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Selected Financial Data (US$ in millions)
Net revenue 11,654 9,779 8,108 6,942 7,573
Total assets 9,281 7,886 7,272 6,977 7,007
Segment Activity Ratio
Segment asset turnover1 1.26 1.24 1.11 0.99 1.08

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
Segment asset turnover = Net revenue ÷ Total assets
= 11,654 ÷ 9,281 = 1.26

Segment activity ratio Reportable segment The company
Segment asset turnover Latin America (LatAm) Latin America (LatAm) segment asset turnover ratio improved from 2021 to 2022 and from 2022 to 2023.

Segment Asset Turnover: Europe

PepsiCo Inc.; Europe; segment asset turnover calculation

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Selected Financial Data (US$ in millions)
Net revenue 13,234 12,724 13,038 11,922 11,728
Total assets 15,615 16,230 18,472 17,917 17,814
Segment Activity Ratio
Segment asset turnover1 0.85 0.78 0.71 0.67 0.66

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
Segment asset turnover = Net revenue ÷ Total assets
= 13,234 ÷ 15,615 = 0.85

Segment activity ratio Reportable segment The company
Segment asset turnover Europe Europe segment asset turnover ratio improved from 2021 to 2022 and from 2022 to 2023.

Segment Asset Turnover: Africa, Middle East and South Asia (AMESA)

PepsiCo Inc.; Africa, Middle East and South Asia (AMESA); segment asset turnover calculation

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Selected Financial Data (US$ in millions)
Net revenue 6,139 6,438 6,078 4,573 3,651
Total assets 6,389 6,143 6,125 5,942 3,672
Segment Activity Ratio
Segment asset turnover1 0.96 1.05 0.99 0.77 0.99

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
Segment asset turnover = Net revenue ÷ Total assets
= 6,139 ÷ 6,389 = 0.96

Segment activity ratio Reportable segment The company
Segment asset turnover Africa, Middle East and South Asia (AMESA) Africa, Middle East and South Asia (AMESA) segment asset turnover ratio improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.

Segment Asset Turnover: Asia Pacific, Australia and New Zealand and China Region (APAC)

PepsiCo Inc.; Asia Pacific, Australia and New Zealand and China Region (APAC); segment asset turnover calculation

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Selected Financial Data (US$ in millions)
Net revenue 4,803 4,787 4,615 3,445 2,919
Total assets 5,630 5,452 5,654 5,770 4,113
Segment Activity Ratio
Segment asset turnover1 0.85 0.88 0.82 0.60 0.71

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
Segment asset turnover = Net revenue ÷ Total assets
= 4,803 ÷ 5,630 = 0.85

Segment activity ratio Reportable segment The company
Segment asset turnover Asia Pacific, Australia and New Zealand and China Region (APAC) Asia Pacific, Australia and New Zealand and China Region (APAC) segment asset turnover ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023.

Segment Capital Expenditures to Depreciation

PepsiCo Inc., capital expenditures to depreciation by reportable segment

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Frito-Lay North America (FLNA) 1.82 2.24 2.38 2.16 2.49
Quaker Foods North America (QFNA) 2.02 1.98 2.00 2.07 2.36
PepsiCo Beverages North America (PBNA) 1.72 1.84 1.38 1.38 1.23
Latin America (LatAm) 2.26 1.90 1.63 1.55 2.06
Europe 1.59 1.87 2.07 2.09 1.80
Africa, Middle East and South Asia (AMESA) 2.34 1.72 1.80 1.69 2.30
Asia Pacific, Australia and New Zealand and China Region (APAC) 2.87 2.62 1.99 2.53 2.57

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).

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Frito-Lay North America (FLNA) Frito-Lay North America (FLNA) segment capital expenditures to depreciation ratio deteriorated from 2021 to 2022 and from 2022 to 2023.
Quaker Foods North America (QFNA) Quaker Foods North America (QFNA) segment capital expenditures to depreciation ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 exceeding 2021 level.
PepsiCo Beverages North America (PBNA) PepsiCo Beverages North America (PBNA) segment capital expenditures to depreciation ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023.
Latin America (LatAm) Latin America (LatAm) segment capital expenditures to depreciation ratio improved from 2021 to 2022 and from 2022 to 2023.
Europe Europe segment capital expenditures to depreciation ratio deteriorated from 2021 to 2022 and from 2022 to 2023.
Africa, Middle East and South Asia (AMESA) Africa, Middle East and South Asia (AMESA) segment capital expenditures to depreciation ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 exceeding 2021 level.
Asia Pacific, Australia and New Zealand and China Region (APAC) Asia Pacific, Australia and New Zealand and China Region (APAC) segment capital expenditures to depreciation ratio improved from 2021 to 2022 and from 2022 to 2023.

Segment Capital Expenditures to Depreciation: Frito-Lay North America (FLNA)

PepsiCo Inc.; Frito-Lay North America (FLNA); segment capital expenditures to depreciation calculation

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Selected Financial Data (US$ in millions)
Capital spending 1,341 1,464 1,411 1,189 1,227
Depreciation and other amortization 736 653 594 550 492
Segment Financial Ratio
Segment capital expenditures to depreciation1 1.82 2.24 2.38 2.16 2.49

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
Segment capital expenditures to depreciation = Capital spending ÷ Depreciation and other amortization
= 1,341 ÷ 736 = 1.82

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Frito-Lay North America (FLNA) Frito-Lay North America (FLNA) segment capital expenditures to depreciation ratio deteriorated from 2021 to 2022 and from 2022 to 2023.

Segment Capital Expenditures to Depreciation: Quaker Foods North America (QFNA)

PepsiCo Inc.; Quaker Foods North America (QFNA); segment capital expenditures to depreciation calculation

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Selected Financial Data (US$ in millions)
Capital spending 103 93 92 85 104
Depreciation and other amortization 51 47 46 41 44
Segment Financial Ratio
Segment capital expenditures to depreciation1 2.02 1.98 2.00 2.07 2.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
Segment capital expenditures to depreciation = Capital spending ÷ Depreciation and other amortization
= 103 ÷ 51 = 2.02

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Quaker Foods North America (QFNA) Quaker Foods North America (QFNA) segment capital expenditures to depreciation ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 exceeding 2021 level.

Segment Capital Expenditures to Depreciation: PepsiCo Beverages North America (PBNA)

PepsiCo Inc.; PepsiCo Beverages North America (PBNA); segment capital expenditures to depreciation calculation

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Selected Financial Data (US$ in millions)
Capital spending 1,723 1,714 1,275 1,245 1,053
Depreciation and other amortization 1,003 930 926 899 857
Segment Financial Ratio
Segment capital expenditures to depreciation1 1.72 1.84 1.38 1.38 1.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
Segment capital expenditures to depreciation = Capital spending ÷ Depreciation and other amortization
= 1,723 ÷ 1,003 = 1.72

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation PepsiCo Beverages North America (PBNA) PepsiCo Beverages North America (PBNA) segment capital expenditures to depreciation ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023.

Segment Capital Expenditures to Depreciation: Latin America (LatAm)

PepsiCo Inc.; Latin America (LatAm); segment capital expenditures to depreciation calculation

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Selected Financial Data (US$ in millions)
Capital spending 841 581 461 390 557
Depreciation and other amortization 372 306 283 251 270
Segment Financial Ratio
Segment capital expenditures to depreciation1 2.26 1.90 1.63 1.55 2.06

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
Segment capital expenditures to depreciation = Capital spending ÷ Depreciation and other amortization
= 841 ÷ 372 = 2.26

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Latin America (LatAm) Latin America (LatAm) segment capital expenditures to depreciation ratio improved from 2021 to 2022 and from 2022 to 2023.

Segment Capital Expenditures to Depreciation: Europe

PepsiCo Inc.; Europe; segment capital expenditures to depreciation calculation

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Selected Financial Data (US$ in millions)
Capital spending 551 668 752 730 613
Depreciation and other amortization 347 357 364 350 341
Segment Financial Ratio
Segment capital expenditures to depreciation1 1.59 1.87 2.07 2.09 1.80

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
Segment capital expenditures to depreciation = Capital spending ÷ Depreciation and other amortization
= 551 ÷ 347 = 1.59

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Europe Europe segment capital expenditures to depreciation ratio deteriorated from 2021 to 2022 and from 2022 to 2023.

Segment Capital Expenditures to Depreciation: Africa, Middle East and South Asia (AMESA)

PepsiCo Inc.; Africa, Middle East and South Asia (AMESA); segment capital expenditures to depreciation calculation

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Selected Financial Data (US$ in millions)
Capital spending 391 307 325 252 267
Depreciation and other amortization 167 179 181 149 116
Segment Financial Ratio
Segment capital expenditures to depreciation1 2.34 1.72 1.80 1.69 2.30

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
Segment capital expenditures to depreciation = Capital spending ÷ Depreciation and other amortization
= 391 ÷ 167 = 2.34

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Africa, Middle East and South Asia (AMESA) Africa, Middle East and South Asia (AMESA) segment capital expenditures to depreciation ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 exceeding 2021 level.

Segment Capital Expenditures to Depreciation: Asia Pacific, Australia and New Zealand and China Region (APAC)

PepsiCo Inc.; Asia Pacific, Australia and New Zealand and China Region (APAC); segment capital expenditures to depreciation calculation

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Selected Financial Data (US$ in millions)
Capital spending 284 241 203 230 195
Depreciation and other amortization 99 92 102 91 76
Segment Financial Ratio
Segment capital expenditures to depreciation1 2.87 2.62 1.99 2.53 2.57

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
Segment capital expenditures to depreciation = Capital spending ÷ Depreciation and other amortization
= 284 ÷ 99 = 2.87

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Asia Pacific, Australia and New Zealand and China Region (APAC) Asia Pacific, Australia and New Zealand and China Region (APAC) segment capital expenditures to depreciation ratio improved from 2021 to 2022 and from 2022 to 2023.

Net revenue

PepsiCo Inc., net revenue by reportable segment

US$ in millions

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Frito-Lay North America (FLNA) 24,914 23,291 19,608 18,189 17,078
Quaker Foods North America (QFNA) 3,101 3,160 2,751 2,742 2,482
PepsiCo Beverages North America (PBNA) 27,626 26,213 25,276 22,559 21,730
Latin America (LatAm) 11,654 9,779 8,108 6,942 7,573
Europe 13,234 12,724 13,038 11,922 11,728
Africa, Middle East and South Asia (AMESA) 6,139 6,438 6,078 4,573 3,651
Asia Pacific, Australia and New Zealand and China Region (APAC) 4,803 4,787 4,615 3,445 2,919
Total division 91,471 86,392 79,474 70,372 67,161
Total 91,471 86,392 79,474 70,372 67,161

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).


Operating profit (loss)

PepsiCo Inc., operating profit (loss) by reportable segment

US$ in millions

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Frito-Lay North America (FLNA) 6,755 6,135 5,633 5,340 5,258
Quaker Foods North America (QFNA) 492 604 578 669 544
PepsiCo Beverages North America (PBNA) 2,584 5,426 2,442 1,937 2,179
Latin America (LatAm) 2,252 1,627 1,369 1,033 1,141
Europe 767 (1,380) 1,292 1,353 1,327
Africa, Middle East and South Asia (AMESA) 807 666 858 600 671
Asia Pacific, Australia and New Zealand and China Region (APAC) 713 537 673 590 477
Total division 14,370 13,615 12,845 11,522 11,597
Corporate (2,384) (2,103) (1,683) (1,442) (1,306)
Total 11,986 11,512 11,162 10,080 10,291

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).


Total assets

PepsiCo Inc., total assets by reportable segment

US$ in millions

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Frito-Lay North America (FLNA) 12,176 11,042 9,763 8,730 7,519
Quaker Foods North America (QFNA) 1,199 1,245 1,101 1,021 941
PepsiCo Beverages North America (PBNA) 41,355 40,286 37,801 37,079 31,449
Latin America (LatAm) 9,281 7,886 7,272 6,977 7,007
Europe 15,615 16,230 18,472 17,917 17,814
Africa, Middle East and South Asia (AMESA) 6,389 6,143 6,125 5,942 3,672
Asia Pacific, Australia and New Zealand and China Region (APAC) 5,630 5,452 5,654 5,770 4,113
Total division 91,645 88,284 86,188 83,436 72,515
Corporate 8,850 3,903 6,189 9,482 6,032
Total 100,495 92,187 92,377 92,918 78,547

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).


Capital spending

PepsiCo Inc., capital spending by reportable segment

US$ in millions

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Frito-Lay North America (FLNA) 1,341 1,464 1,411 1,189 1,227
Quaker Foods North America (QFNA) 103 93 92 85 104
PepsiCo Beverages North America (PBNA) 1,723 1,714 1,275 1,245 1,053
Latin America (LatAm) 841 581 461 390 557
Europe 551 668 752 730 613
Africa, Middle East and South Asia (AMESA) 391 307 325 252 267
Asia Pacific, Australia and New Zealand and China Region (APAC) 284 241 203 230 195
Total division 5,234 5,068 4,519 4,121 4,016
Corporate 284 139 106 119 216
Total 5,518 5,207 4,625 4,240 4,232

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).


Depreciation and other amortization

PepsiCo Inc., depreciation and other amortization by reportable segment

US$ in millions

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
Frito-Lay North America (FLNA) 736 653 594 550 492
Quaker Foods North America (QFNA) 51 47 46 41 44
PepsiCo Beverages North America (PBNA) 1,003 930 926 899 857
Latin America (LatAm) 372 306 283 251 270
Europe 347 357 364 350 341
Africa, Middle East and South Asia (AMESA) 167 179 181 149 116
Asia Pacific, Australia and New Zealand and China Region (APAC) 99 92 102 91 76
Total division 2,775 2,564 2,496 2,331 2,196
Corporate 98 121 123 127 155
Total 2,873 2,685 2,619 2,458 2,351

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).