Stock Analysis on Net

PepsiCo Inc. (NASDAQ:PEP)

Analysis of Geographic Areas 

Microsoft Excel

PepsiCo Inc. operates in 9 regions: United States; Mexico; Canada; Russia; China; United Kingdom; Brazil; South Africa; and All other countries.


Area Asset Turnover

PepsiCo Inc., asset turnover by geographic area

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
United States 1.27 1.29 1.23 1.11 1.26
Mexico 2.79 2.83 2.66 2.30 2.52
Canada 1.32 1.32 1.20 1.07 1.05
Russia 1.80 1.62 0.91 0.83 0.76
China 1.79 1.81 1.54 1.05 1.84
United Kingdom 2.24 2.18 2.32 2.15 2.08
Brazil 3.10 3.63
South Africa 1.31 1.38 1.45 0.86 2.96
All other countries 1.50 1.27 1.25 1.10 1.18

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

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

Area Asset Turnover: United States

PepsiCo Inc.; United States; area 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 52,165 49,390 44,545 40,800 38,644
Long-lived assets 41,234 38,240 36,324 36,657 30,601
Area Activity Ratio
Area asset turnover1 1.27 1.29 1.23 1.11 1.26

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
Area asset turnover = Net revenue ÷ Long-lived assets
= 52,165 ÷ 41,234 = 1.27

Area activity ratio Geographic area The company
Area asset turnover United States United States area asset turnover ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023.

Area Asset Turnover: Mexico

PepsiCo Inc.; Mexico; area 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 7,011 5,472 4,580 3,924 4,190
Long-lived assets 2,509 1,933 1,720 1,708 1,666
Area Activity Ratio
Area asset turnover1 2.79 2.83 2.66 2.30 2.52

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
Area asset turnover = Net revenue ÷ Long-lived assets
= 7,011 ÷ 2,509 = 2.79

Area activity ratio Geographic area The company
Area asset turnover Mexico Mexico area asset turnover ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023.

Area Asset Turnover: Canada

PepsiCo Inc.; Canada; area 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,722 3,536 3,405 2,989 2,831
Long-lived assets 2,815 2,678 2,846 2,794 2,695
Area Activity Ratio
Area asset turnover1 1.32 1.32 1.20 1.07 1.05

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
Area asset turnover = Net revenue ÷ Long-lived assets
= 3,722 ÷ 2,815 = 1.32

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

Area Asset Turnover: Russia

PepsiCo Inc.; Russia; area 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,566 4,118 3,426 3,009 3,263
Long-lived assets 1,986 2,538 3,751 3,644 4,314
Area Activity Ratio
Area asset turnover1 1.80 1.62 0.91 0.83 0.76

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
Area asset turnover = Net revenue ÷ Long-lived assets
= 3,566 ÷ 1,986 = 1.80

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

Area Asset Turnover: China

PepsiCo Inc.; China; area 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 2,703 2,752 2,679 1,732 1,300
Long-lived assets 1,510 1,517 1,745 1,649 705
Area Activity Ratio
Area asset turnover1 1.79 1.81 1.54 1.05 1.84

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
Area asset turnover = Net revenue ÷ Long-lived assets
= 2,703 ÷ 1,510 = 1.79

Area activity ratio Geographic area The company
Area asset turnover China China area asset turnover ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023.

Area Asset Turnover: United Kingdom

PepsiCo Inc.; United Kingdom; area 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 1,946 1,844 2,102 1,882 1,723
Long-lived assets 868 847 906 874 827
Area Activity Ratio
Area asset turnover1 2.24 2.18 2.32 2.15 2.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
Area asset turnover = Net revenue ÷ Long-lived assets
= 1,946 ÷ 868 = 2.24

Area activity ratio Geographic area The company
Area asset turnover United Kingdom United Kingdom area asset turnover ratio deteriorated from 2021 to 2022 but then slightly improved from 2022 to 2023.

Area Asset Turnover: Brazil

PepsiCo Inc.; Brazil; area 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 1,779 1,617
Long-lived assets 573 446
Area Activity Ratio
Area asset turnover1 3.10 3.63

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
Area asset turnover = Net revenue ÷ Long-lived assets
= 1,779 ÷ 573 = 3.10

Area activity ratio Geographic area The company
Area asset turnover Brazil Brazil area asset turnover ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023.

Area Asset Turnover: South Africa

PepsiCo Inc.; South Africa; area 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 1,707 1,837 2,008 1,282 405
Long-lived assets 1,305 1,327 1,389 1,484 137
Area Activity Ratio
Area asset turnover1 1.31 1.38 1.45 0.86 2.96

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
Area asset turnover = Net revenue ÷ Long-lived assets
= 1,707 ÷ 1,305 = 1.31

Area activity ratio Geographic area The company
Area asset turnover South Africa South Africa area asset turnover ratio deteriorated from 2021 to 2022 and from 2022 to 2023.

Area Asset Turnover: All other countries

PepsiCo Inc.; All other countries; area 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 16,872 15,826 16,729 14,754 14,805
Long-lived assets 11,226 12,439 13,399 13,423 12,587
Area Activity Ratio
Area asset turnover1 1.50 1.27 1.25 1.10 1.18

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
Area asset turnover = Net revenue ÷ Long-lived assets
= 16,872 ÷ 11,226 = 1.50

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

Net revenue

PepsiCo Inc., net revenue by geographic area

US$ in millions

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
United States 52,165 49,390 44,545 40,800 38,644
Mexico 7,011 5,472 4,580 3,924 4,190
Canada 3,722 3,536 3,405 2,989 2,831
Russia 3,566 4,118 3,426 3,009 3,263
China 2,703 2,752 2,679 1,732 1,300
United Kingdom 1,946 1,844 2,102 1,882 1,723
Brazil 1,779 1,617
South Africa 1,707 1,837 2,008 1,282 405
All other countries 16,872 15,826 16,729 14,754 14,805
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).


Long-lived assets

PepsiCo Inc., long-lived assets by geographic area

US$ in millions

Microsoft Excel
Dec 30, 2023 Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019
United States 41,234 38,240 36,324 36,657 30,601
Mexico 2,509 1,933 1,720 1,708 1,666
Canada 2,815 2,678 2,846 2,794 2,695
Russia 1,986 2,538 3,751 3,644 4,314
China 1,510 1,517 1,745 1,649 705
United Kingdom 868 847 906 874 827
Brazil 573 446
South Africa 1,305 1,327 1,389 1,484 137
All other countries 11,226 12,439 13,399 13,423 12,587
Total 64,026 61,965 62,080 62,233 53,532

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