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 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019 Dec 29, 2018
United States 1.29 1.23 1.11 1.26 1.27
Mexico 2.83 2.66 2.30 2.52 2.76
Russia 1.62 0.91 0.83 0.76 0.81
Canada 1.32 1.20 1.07 1.05 1.07
China 1.81 1.54 1.05 1.84 2.29
United Kingdom 2.18 2.32 2.15 2.08 2.30
South Africa 1.38 1.45 0.86 2.96

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

Area activity ratio Geographic area The company
Area asset turnover United States United States area asset turnover ratio improved from 2020 to 2021 and from 2021 to 2022.
Mexico Mexico area asset turnover ratio improved from 2020 to 2021 and from 2021 to 2022.
Russia Russia area asset turnover ratio improved from 2020 to 2021 and from 2021 to 2022.
Canada Canada area asset turnover ratio improved from 2020 to 2021 and from 2021 to 2022.
China China area asset turnover ratio improved from 2020 to 2021 and from 2021 to 2022.
United Kingdom United Kingdom area asset turnover ratio improved from 2020 to 2021 but then slightly deteriorated from 2021 to 2022 not reaching 2020 level.
South Africa South Africa area asset turnover ratio improved from 2020 to 2021 but then slightly deteriorated from 2021 to 2022.

Area Asset Turnover: United States

PepsiCo Inc.; United States; area asset turnover calculation

Microsoft Excel
Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019 Dec 29, 2018
Selected Financial Data (US$ in millions)
Net revenue 49,390 44,545 40,800 38,644 37,148
Long-lived assets 38,240 36,324 36,657 30,601 29,169
Area Activity Ratio
Area asset turnover1 1.29 1.23 1.11 1.26 1.27

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

1 2022 Calculation
Area asset turnover = Net revenue ÷ Long-lived assets
= 49,390 ÷ 38,240 = 1.29

Area activity ratio Geographic area The company
Area asset turnover United States United States area asset turnover ratio improved from 2020 to 2021 and from 2021 to 2022.

Area Asset Turnover: Mexico

PepsiCo Inc.; Mexico; area asset turnover calculation

Microsoft Excel
Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019 Dec 29, 2018
Selected Financial Data (US$ in millions)
Net revenue 5,472 4,580 3,924 4,190 3,878
Long-lived assets 1,933 1,720 1,708 1,666 1,404
Area Activity Ratio
Area asset turnover1 2.83 2.66 2.30 2.52 2.76

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

1 2022 Calculation
Area asset turnover = Net revenue ÷ Long-lived assets
= 5,472 ÷ 1,933 = 2.83

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

Area Asset Turnover: Russia

PepsiCo Inc.; Russia; area asset turnover calculation

Microsoft Excel
Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019 Dec 29, 2018
Selected Financial Data (US$ in millions)
Net revenue 4,118 3,426 3,009 3,263 3,191
Long-lived assets 2,538 3,751 3,644 4,314 3,926
Area Activity Ratio
Area asset turnover1 1.62 0.91 0.83 0.76 0.81

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

1 2022 Calculation
Area asset turnover = Net revenue ÷ Long-lived assets
= 4,118 ÷ 2,538 = 1.62

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

Area Asset Turnover: Canada

PepsiCo Inc.; Canada; area asset turnover calculation

Microsoft Excel
Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019 Dec 29, 2018
Selected Financial Data (US$ in millions)
Net revenue 3,536 3,405 2,989 2,831 2,736
Long-lived assets 2,678 2,846 2,794 2,695 2,565
Area Activity Ratio
Area asset turnover1 1.32 1.20 1.07 1.05 1.07

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

1 2022 Calculation
Area asset turnover = Net revenue ÷ Long-lived assets
= 3,536 ÷ 2,678 = 1.32

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

Area Asset Turnover: China

PepsiCo Inc.; China; area asset turnover calculation

Microsoft Excel
Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019 Dec 29, 2018
Selected Financial Data (US$ in millions)
Net revenue 2,752 2,679 1,732 1,300 1,164
Long-lived assets 1,517 1,745 1,649 705 509
Area Activity Ratio
Area asset turnover1 1.81 1.54 1.05 1.84 2.29

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

1 2022 Calculation
Area asset turnover = Net revenue ÷ Long-lived assets
= 2,752 ÷ 1,517 = 1.81

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

Area Asset Turnover: United Kingdom

PepsiCo Inc.; United Kingdom; area asset turnover calculation

Microsoft Excel
Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019 Dec 29, 2018
Selected Financial Data (US$ in millions)
Net revenue 1,844 2,102 1,882 1,723 1,743
Long-lived assets 847 906 874 827 759
Area Activity Ratio
Area asset turnover1 2.18 2.32 2.15 2.08 2.30

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

1 2022 Calculation
Area asset turnover = Net revenue ÷ Long-lived assets
= 1,844 ÷ 847 = 2.18

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

Area Asset Turnover: South Africa

PepsiCo Inc.; South Africa; area asset turnover calculation

Microsoft Excel
Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019 Dec 29, 2018
Selected Financial Data (US$ in millions)
Net revenue 1,837 2,008 1,282 405
Long-lived assets 1,327 1,389 1,484 137
Area Activity Ratio
Area asset turnover1 1.38 1.45 0.86 2.96

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

1 2022 Calculation
Area asset turnover = Net revenue ÷ Long-lived assets
= 1,837 ÷ 1,327 = 1.38

Area activity ratio Geographic area The company
Area asset turnover South Africa South Africa area asset turnover ratio improved from 2020 to 2021 but then slightly deteriorated from 2021 to 2022.

Net revenue

PepsiCo Inc., net revenue by geographic area

US$ in millions

Microsoft Excel
Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019 Dec 29, 2018
United States 49,390 44,545 40,800 38,644 37,148
Mexico 5,472 4,580 3,924 4,190 3,878
Russia 4,118 3,426 3,009 3,263 3,191
Canada 3,536 3,405 2,989 2,831 2,736
China 2,752 2,679 1,732 1,300 1,164
United Kingdom 1,844 2,102 1,882 1,723 1,743
South Africa 1,837 2,008 1,282 405
All other countries 17,443 16,729 14,754 14,805 14,801
Total 86,392 79,474 70,372 67,161 64,661

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


Long-lived assets

PepsiCo Inc., long-lived assets by geographic area

US$ in millions

Microsoft Excel
Dec 31, 2022 Dec 25, 2021 Dec 26, 2020 Dec 28, 2019 Dec 29, 2018
United States 38,240 36,324 36,657 30,601 29,169
Mexico 1,933 1,720 1,708 1,666 1,404
Russia 2,538 3,751 3,644 4,314 3,926
Canada 2,678 2,846 2,794 2,695 2,565
China 1,517 1,745 1,649 705 509
United Kingdom 847 906 874 827 759
South Africa 1,327 1,389 1,484 137
All other countries 12,885 13,399 13,423 12,587 12,299
Total 61,965 62,080 62,233 53,532 50,631

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