Stock Analysis on Net

PepsiCo Inc. (NASDAQ:PEP)

Analysis of Geographic Areas

Microsoft Excel

Area Asset Turnover

PepsiCo Inc., asset turnover by geographic area

Microsoft Excel
Dec 28, 2024 Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020
United States 1.24 1.27 1.29 1.23 1.11
Mexico 2.98 2.79 2.83 2.66 2.30
Russia 2.33 1.80 1.62 0.91 0.83
Canada 1.40 1.32 1.32 1.20 1.07
China 1.76 1.79 1.81 1.54 1.05
United Kingdom 2.37 2.24 2.18 2.32 2.15
South Africa 1.43 1.31 1.38 1.45 0.86
Brazil 3.55 3.10 3.63
All other countries 1.52 1.50 1.27 1.25 1.10

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

Area activity ratio Geographic area The company
Area asset turnover United States United States area asset turnover ratio deteriorated from 2022 to 2023 and from 2023 to 2024.
Mexico Mexico area asset turnover ratio deteriorated from 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.
Russia Russia area asset turnover ratio improved from 2022 to 2023 and from 2023 to 2024.
Canada Canada area asset turnover ratio improved from 2022 to 2023 and from 2023 to 2024.
China China area asset turnover ratio deteriorated from 2022 to 2023 and from 2023 to 2024.
United Kingdom United Kingdom area asset turnover ratio improved from 2022 to 2023 and from 2023 to 2024.
South Africa South Africa area asset turnover ratio deteriorated from 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.
Brazil Brazil area asset turnover ratio deteriorated from 2022 to 2023 but then improved from 2023 to 2024 not reaching 2022 level.
All other countries All other countries area asset turnover ratio improved from 2022 to 2023 and from 2023 to 2024.

Area Asset Turnover: United States

PepsiCo Inc.; United States; area asset turnover calculation

Microsoft Excel
Dec 28, 2024 Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020
Selected Financial Data (US$ in millions)
Net revenue 51,668 52,165 49,390 44,545 40,800
Long-lived assets 41,547 41,234 38,240 36,324 36,657
Area Activity Ratio
Area asset turnover1 1.24 1.27 1.29 1.23 1.11

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

1 2024 Calculation
Area asset turnover = Net revenue ÷ Long-lived assets
= 51,668 ÷ 41,547 = 1.24

Area activity ratio Geographic area The company
Area asset turnover United States United States area asset turnover ratio deteriorated from 2022 to 2023 and from 2023 to 2024.

Area Asset Turnover: Mexico

PepsiCo Inc.; Mexico; area asset turnover calculation

Microsoft Excel
Dec 28, 2024 Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020
Selected Financial Data (US$ in millions)
Net revenue 7,123 7,011 5,472 4,580 3,924
Long-lived assets 2,392 2,509 1,933 1,720 1,708
Area Activity Ratio
Area asset turnover1 2.98 2.79 2.83 2.66 2.30

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

1 2024 Calculation
Area asset turnover = Net revenue ÷ Long-lived assets
= 7,123 ÷ 2,392 = 2.98

Area activity ratio Geographic area The company
Area asset turnover Mexico Mexico area asset turnover ratio deteriorated from 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.

Area Asset Turnover: Russia

PepsiCo Inc.; Russia; area asset turnover calculation

Microsoft Excel
Dec 28, 2024 Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020
Selected Financial Data (US$ in millions)
Net revenue 3,880 3,566 4,118 3,426 3,009
Long-lived assets 1,667 1,986 2,538 3,751 3,644
Area Activity Ratio
Area asset turnover1 2.33 1.80 1.62 0.91 0.83

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

1 2024 Calculation
Area asset turnover = Net revenue ÷ Long-lived assets
= 3,880 ÷ 1,667 = 2.33

Area activity ratio Geographic area The company
Area asset turnover Russia Russia area asset turnover ratio improved from 2022 to 2023 and from 2023 to 2024.

Area Asset Turnover: Canada

PepsiCo Inc.; Canada; area asset turnover calculation

Microsoft Excel
Dec 28, 2024 Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020
Selected Financial Data (US$ in millions)
Net revenue 3,764 3,722 3,536 3,405 2,989
Long-lived assets 2,681 2,815 2,678 2,846 2,794
Area Activity Ratio
Area asset turnover1 1.40 1.32 1.32 1.20 1.07

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

1 2024 Calculation
Area asset turnover = Net revenue ÷ Long-lived assets
= 3,764 ÷ 2,681 = 1.40

Area activity ratio Geographic area The company
Area asset turnover Canada Canada area asset turnover ratio improved from 2022 to 2023 and from 2023 to 2024.

Area Asset Turnover: China

PepsiCo Inc.; China; area asset turnover calculation

Microsoft Excel
Dec 28, 2024 Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020
Selected Financial Data (US$ in millions)
Net revenue 2,709 2,703 2,752 2,679 1,732
Long-lived assets 1,538 1,510 1,517 1,745 1,649
Area Activity Ratio
Area asset turnover1 1.76 1.79 1.81 1.54 1.05

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

1 2024 Calculation
Area asset turnover = Net revenue ÷ Long-lived assets
= 2,709 ÷ 1,538 = 1.76

Area activity ratio Geographic area The company
Area asset turnover China China area asset turnover ratio deteriorated from 2022 to 2023 and from 2023 to 2024.

Area Asset Turnover: United Kingdom

PepsiCo Inc.; United Kingdom; area asset turnover calculation

Microsoft Excel
Dec 28, 2024 Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020
Selected Financial Data (US$ in millions)
Net revenue 2,063 1,946 1,844 2,102 1,882
Long-lived assets 871 868 847 906 874
Area Activity Ratio
Area asset turnover1 2.37 2.24 2.18 2.32 2.15

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

1 2024 Calculation
Area asset turnover = Net revenue ÷ Long-lived assets
= 2,063 ÷ 871 = 2.37

Area activity ratio Geographic area The company
Area asset turnover United Kingdom United Kingdom area asset turnover ratio improved from 2022 to 2023 and from 2023 to 2024.

Area Asset Turnover: South Africa

PepsiCo Inc.; South Africa; area asset turnover calculation

Microsoft Excel
Dec 28, 2024 Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020
Selected Financial Data (US$ in millions)
Net revenue 1,859 1,707 1,837 2,008 1,282
Long-lived assets 1,302 1,305 1,327 1,389 1,484
Area Activity Ratio
Area asset turnover1 1.43 1.31 1.38 1.45 0.86

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

1 2024 Calculation
Area asset turnover = Net revenue ÷ Long-lived assets
= 1,859 ÷ 1,302 = 1.43

Area activity ratio Geographic area The company
Area asset turnover South Africa South Africa area asset turnover ratio deteriorated from 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.

Area Asset Turnover: Brazil

PepsiCo Inc.; Brazil; area asset turnover calculation

Microsoft Excel
Dec 28, 2024 Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020
Selected Financial Data (US$ in millions)
Net revenue 1,765 1,779 1,617
Long-lived assets 497 573 446
Area Activity Ratio
Area asset turnover1 3.55 3.10 3.63

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

1 2024 Calculation
Area asset turnover = Net revenue ÷ Long-lived assets
= 1,765 ÷ 497 = 3.55

Area activity ratio Geographic area The company
Area asset turnover Brazil Brazil area asset turnover ratio deteriorated from 2022 to 2023 but then improved from 2023 to 2024 not reaching 2022 level.

Area Asset Turnover: All other countries

PepsiCo Inc.; All other countries; area asset turnover calculation

Microsoft Excel
Dec 28, 2024 Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020
Selected Financial Data (US$ in millions)
Net revenue 17,023 16,872 15,826 16,729 14,754
Long-lived assets 11,179 11,226 12,439 13,399 13,423
Area Activity Ratio
Area asset turnover1 1.52 1.50 1.27 1.25 1.10

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

1 2024 Calculation
Area asset turnover = Net revenue ÷ Long-lived assets
= 17,023 ÷ 11,179 = 1.52

Area activity ratio Geographic area The company
Area asset turnover All other countries All other countries area asset turnover ratio improved from 2022 to 2023 and from 2023 to 2024.

Net revenue

PepsiCo Inc., net revenue by geographic area

US$ in millions

Microsoft Excel
Dec 28, 2024 Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020
United States 51,668 52,165 49,390 44,545 40,800
Mexico 7,123 7,011 5,472 4,580 3,924
Russia 3,880 3,566 4,118 3,426 3,009
Canada 3,764 3,722 3,536 3,405 2,989
China 2,709 2,703 2,752 2,679 1,732
United Kingdom 2,063 1,946 1,844 2,102 1,882
South Africa 1,859 1,707 1,837 2,008 1,282
Brazil 1,765 1,779 1,617
All other countries 17,023 16,872 15,826 16,729 14,754
Total 91,854 91,471 86,392 79,474 70,372

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


Long-lived assets

PepsiCo Inc., long-lived assets by geographic area

US$ in millions

Microsoft Excel
Dec 28, 2024 Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020
United States 41,547 41,234 38,240 36,324 36,657
Mexico 2,392 2,509 1,933 1,720 1,708
Russia 1,667 1,986 2,538 3,751 3,644
Canada 2,681 2,815 2,678 2,846 2,794
China 1,538 1,510 1,517 1,745 1,649
United Kingdom 871 868 847 906 874
South Africa 1,302 1,305 1,327 1,389 1,484
Brazil 497 573 446
All other countries 11,179 11,226 12,439 13,399 13,423
Total 63,674 64,026 61,965 62,080 62,233

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