Stock Analysis on Net
Stock Analysis on Net

PepsiCo Inc. (NASDAQ:PEP)

Analysis of Long-term (Investment) Activity Ratios
Quarterly Data

Microsoft Excel LibreOffice Calc

Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.

Long-term Activity Ratios (Summary)

PepsiCo Inc., long-term (investment) activity ratios (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 4, 2021 Jun 12, 2021 Mar 20, 2021 Dec 26, 2020 Sep 5, 2020 Jun 13, 2020 Mar 21, 2020 Dec 28, 2019 Sep 7, 2019 Jun 15, 2019 Mar 23, 2019 Dec 29, 2018 Sep 8, 2018 Jun 16, 2018 Mar 24, 2018 Dec 30, 2017 Sep 9, 2017 Jun 17, 2017 Mar 25, 2017 Dec 31, 2016 Sep 3, 2016 Jun 11, 2016 Mar 19, 2016
Net fixed asset turnover 3.61 3.45 3.36 3.29 3.48 3.53 3.59 3.48 3.76 3.75 3.70 3.68 3.91 3.84 3.74 3.68 3.74 3.78 3.78 3.79 — — —
Total asset turnover 0.82 0.81 0.78 0.76 0.74 0.76 0.80 0.86 0.85 0.87 0.86 0.83 0.88 0.82 0.78 0.80 0.81 0.82 0.84 0.85 — — —
Equity turnover 4.83 4.88 5.11 5.23 5.08 5.42 5.06 4.54 4.67 4.68 4.58 4.45 6.29 6.37 5.88 5.83 4.78 5.10 5.44 5.66 — — —

Based on: 10-Q (reporting date: 2021-09-04), 10-Q (reporting date: 2021-06-12), 10-Q (reporting date: 2021-03-20), 10-K (reporting date: 2020-12-26), 10-Q (reporting date: 2020-09-05), 10-Q (reporting date: 2020-06-13), 10-Q (reporting date: 2020-03-21), 10-K (reporting date: 2019-12-28), 10-Q (reporting date: 2019-09-07), 10-Q (reporting date: 2019-06-15), 10-Q (reporting date: 2019-03-23), 10-K (reporting date: 2018-12-29), 10-Q (reporting date: 2018-09-08), 10-Q (reporting date: 2018-06-16), 10-Q (reporting date: 2018-03-24), 10-K (reporting date: 2017-12-30), 10-Q (reporting date: 2017-09-09), 10-Q (reporting date: 2017-06-17), 10-Q (reporting date: 2017-03-25), 10-K (reporting date: 2016-12-31), 10-Q (reporting date: 2016-09-03), 10-Q (reporting date: 2016-06-11), 10-Q (reporting date: 2016-03-19).

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. PepsiCo Inc. net fixed asset turnover ratio improved from Q1 2021 to Q2 2021 and from Q2 2021 to Q3 2021.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. PepsiCo Inc. total asset turnover ratio improved from Q1 2021 to Q2 2021 and from Q2 2021 to Q3 2021.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. PepsiCo Inc. equity turnover ratio deteriorated from Q1 2021 to Q2 2021 and from Q2 2021 to Q3 2021.

Net Fixed Asset Turnover

PepsiCo Inc., net fixed asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 4, 2021 Jun 12, 2021 Mar 20, 2021 Dec 26, 2020 Sep 5, 2020 Jun 13, 2020 Mar 21, 2020 Dec 28, 2019 Sep 7, 2019 Jun 15, 2019 Mar 23, 2019 Dec 29, 2018 Sep 8, 2018 Jun 16, 2018 Mar 24, 2018 Dec 30, 2017 Sep 9, 2017 Jun 17, 2017 Mar 25, 2017 Dec 31, 2016 Sep 3, 2016 Jun 11, 2016 Mar 19, 2016
Selected Financial Data (US$ in millions)
Net revenue 20,189  19,217  14,820  22,455  18,091  15,945  13,881  20,640  17,188  16,449  12,884  19,524  16,485  16,090  12,562  19,526  16,240  15,710  12,049  19,515  16,027  15,395  11,862 
Property, plant and equipment, net 21,257  21,619  21,249  21,369  19,726  19,187  18,980  19,305  17,586  17,442  17,550  17,589  16,541  16,762  17,141  17,240  16,960  16,742  16,649  16,591  16,305  16,219  16,105 
Long-term Activity Ratio
Net fixed asset turnover1 3.61 3.45 3.36 3.29 3.48 3.53 3.59 3.48 3.76 3.75 3.70 3.68 3.91 3.84 3.74 3.68 3.74 3.78 3.78 3.79 — — —
Benchmarks
Net Fixed Asset Turnover, Competitors2
Altria Group Inc. 17.17 13.66 13.03 13.00 12.87 12.78 12.94 12.56 12.85 13.14 12.95 13.09 13.41 13.44 13.54 13.36 13.49 13.63 13.40 13.15 — — —
Coca-Cola Co. 3.76 3.45 3.13 3.06 3.14 3.21 3.38 3.44 3.45 3.32 3.71 3.87 4.36 4.31 4.25 4.32 4.49 4.48 4.18 3.94 — — —
Mondelēz International Inc. 3.27 3.14 3.09 2.94 3.07 3.09 3.23 2.96 3.09 3.00 3.02 3.06 3.11 3.15 2.99 2.98 3.01 3.03 3.09 3.15 — — —
Philip Morris International Inc. 13.35 13.35 12.96 11.95 12.45 12.34 12.85 11.75 11.74 11.27 11.47 11.08 11.42 11.49 10.72 10.74 11.04 11.31 11.93 12.36 — — —

Based on: 10-Q (reporting date: 2021-09-04), 10-Q (reporting date: 2021-06-12), 10-Q (reporting date: 2021-03-20), 10-K (reporting date: 2020-12-26), 10-Q (reporting date: 2020-09-05), 10-Q (reporting date: 2020-06-13), 10-Q (reporting date: 2020-03-21), 10-K (reporting date: 2019-12-28), 10-Q (reporting date: 2019-09-07), 10-Q (reporting date: 2019-06-15), 10-Q (reporting date: 2019-03-23), 10-K (reporting date: 2018-12-29), 10-Q (reporting date: 2018-09-08), 10-Q (reporting date: 2018-06-16), 10-Q (reporting date: 2018-03-24), 10-K (reporting date: 2017-12-30), 10-Q (reporting date: 2017-09-09), 10-Q (reporting date: 2017-06-17), 10-Q (reporting date: 2017-03-25), 10-K (reporting date: 2016-12-31), 10-Q (reporting date: 2016-09-03), 10-Q (reporting date: 2016-06-11), 10-Q (reporting date: 2016-03-19).

1 Q3 2021 Calculation
Net fixed asset turnover = (Net revenueQ3 2021 + Net revenueQ2 2021 + Net revenueQ1 2021 + Net revenueQ4 2020) ÷ Property, plant and equipment, net
= (20,189 + 19,217 + 14,820 + 22,455) ÷ 21,257 = 3.61

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. PepsiCo Inc. net fixed asset turnover ratio improved from Q1 2021 to Q2 2021 and from Q2 2021 to Q3 2021.

Total Asset Turnover

PepsiCo Inc., total asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 4, 2021 Jun 12, 2021 Mar 20, 2021 Dec 26, 2020 Sep 5, 2020 Jun 13, 2020 Mar 21, 2020 Dec 28, 2019 Sep 7, 2019 Jun 15, 2019 Mar 23, 2019 Dec 29, 2018 Sep 8, 2018 Jun 16, 2018 Mar 24, 2018 Dec 30, 2017 Sep 9, 2017 Jun 17, 2017 Mar 25, 2017 Dec 31, 2016 Sep 3, 2016 Jun 11, 2016 Mar 19, 2016
Selected Financial Data (US$ in millions)
Net revenue 20,189  19,217  14,820  22,455  18,091  15,945  13,881  20,640  17,188  16,449  12,884  19,524  16,485  16,090  12,562  19,526  16,240  15,710  12,049  19,515  16,027  15,395  11,862 
Total assets 93,254  92,385  91,224  92,918  92,041  89,525  85,062  78,547  77,444  75,084  75,466  77,648  73,632  78,731  81,887  79,804  78,463  76,943  74,622  74,129  73,897  72,711  70,019 
Long-term Activity Ratio
Total asset turnover1 0.82 0.81 0.78 0.76 0.74 0.76 0.80 0.86 0.85 0.87 0.86 0.83 0.88 0.82 0.78 0.80 0.81 0.82 0.84 0.85 — — —
Benchmarks
Total Asset Turnover, Competitors2
Altria Group Inc. 0.66 0.59 0.53 0.55 0.55 0.51 0.49 0.51 0.48 0.44 0.42 0.46 0.58 0.58 0.58 0.59 0.58 0.59 0.56 0.56 — — —
Coca-Cola Co. 0.42 0.40 0.37 0.38 0.34 0.36 0.40 0.43 0.40 0.38 0.37 0.38 0.37 0.37 0.36 0.40 0.41 0.43 0.45 0.48 — — —
Mondelēz International Inc. 0.42 0.42 0.41 0.39 0.40 0.40 0.41 0.40 0.40 0.40 0.40 0.41 0.41 0.42 0.41 0.41 0.41 0.41 0.42 0.42 — — —
Philip Morris International Inc. 1.95 1.96 1.94 1.70 1.95 1.95 2.09 1.82 1.88 1.95 2.08 2.01 2.07 2.01 1.86 1.82 1.80 1.94 2.04 2.03 — — —

Based on: 10-Q (reporting date: 2021-09-04), 10-Q (reporting date: 2021-06-12), 10-Q (reporting date: 2021-03-20), 10-K (reporting date: 2020-12-26), 10-Q (reporting date: 2020-09-05), 10-Q (reporting date: 2020-06-13), 10-Q (reporting date: 2020-03-21), 10-K (reporting date: 2019-12-28), 10-Q (reporting date: 2019-09-07), 10-Q (reporting date: 2019-06-15), 10-Q (reporting date: 2019-03-23), 10-K (reporting date: 2018-12-29), 10-Q (reporting date: 2018-09-08), 10-Q (reporting date: 2018-06-16), 10-Q (reporting date: 2018-03-24), 10-K (reporting date: 2017-12-30), 10-Q (reporting date: 2017-09-09), 10-Q (reporting date: 2017-06-17), 10-Q (reporting date: 2017-03-25), 10-K (reporting date: 2016-12-31), 10-Q (reporting date: 2016-09-03), 10-Q (reporting date: 2016-06-11), 10-Q (reporting date: 2016-03-19).

1 Q3 2021 Calculation
Total asset turnover = (Net revenueQ3 2021 + Net revenueQ2 2021 + Net revenueQ1 2021 + Net revenueQ4 2020) ÷ Total assets
= (20,189 + 19,217 + 14,820 + 22,455) ÷ 93,254 = 0.82

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. PepsiCo Inc. total asset turnover ratio improved from Q1 2021 to Q2 2021 and from Q2 2021 to Q3 2021.

Equity Turnover

PepsiCo Inc., equity turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 4, 2021 Jun 12, 2021 Mar 20, 2021 Dec 26, 2020 Sep 5, 2020 Jun 13, 2020 Mar 21, 2020 Dec 28, 2019 Sep 7, 2019 Jun 15, 2019 Mar 23, 2019 Dec 29, 2018 Sep 8, 2018 Jun 16, 2018 Mar 24, 2018 Dec 30, 2017 Sep 9, 2017 Jun 17, 2017 Mar 25, 2017 Dec 31, 2016 Sep 3, 2016 Jun 11, 2016 Mar 19, 2016
Selected Financial Data (US$ in millions)
Net revenue 20,189  19,217  14,820  22,455  18,091  15,945  13,881  20,640  17,188  16,449  12,884  19,524  16,485  16,090  12,562  19,526  16,240  15,710  12,049  19,515  16,027  15,395  11,862 
Total PepsiCo shareholders’ equity 15,872  15,299  13,947  13,454  13,483  12,491  13,465  14,786  14,129  13,952  14,202  14,518  10,286  10,111  10,883  10,889  13,295  12,404  11,569  11,095  12,602  12,248  11,111 
Long-term Activity Ratio
Equity turnover1 4.83 4.88 5.11 5.23 5.08 5.42 5.06 4.54 4.67 4.68 4.58 4.45 6.29 6.37 5.88 5.83 4.78 5.10 5.44 5.66 — — —
Benchmarks
Equity Turnover, Competitors2
Altria Group Inc. — 8.11 8.87 9.21 8.24 4.50 3.95 4.04 2.39 1.74 1.77 1.72 1.64 1.60 1.66 1.66 2.11 2.09 2.10 2.02 — — —
Coca-Cola Co. 1.70 1.64 1.64 1.71 1.80 1.96 2.05 1.96 1.88 1.87 1.86 1.88 1.77 1.81 1.73 2.07 1.69 1.77 1.78 1.82 — — —
Mondelēz International Inc. 1.02 1.01 1.00 0.96 0.97 0.99 1.01 0.95 0.96 0.98 1.00 1.01 1.03 1.05 0.99 0.99 0.99 0.99 1.01 1.03 — — —
Philip Morris International Inc. — — — — — — — — — — — — — — — — — — — — — — —

Based on: 10-Q (reporting date: 2021-09-04), 10-Q (reporting date: 2021-06-12), 10-Q (reporting date: 2021-03-20), 10-K (reporting date: 2020-12-26), 10-Q (reporting date: 2020-09-05), 10-Q (reporting date: 2020-06-13), 10-Q (reporting date: 2020-03-21), 10-K (reporting date: 2019-12-28), 10-Q (reporting date: 2019-09-07), 10-Q (reporting date: 2019-06-15), 10-Q (reporting date: 2019-03-23), 10-K (reporting date: 2018-12-29), 10-Q (reporting date: 2018-09-08), 10-Q (reporting date: 2018-06-16), 10-Q (reporting date: 2018-03-24), 10-K (reporting date: 2017-12-30), 10-Q (reporting date: 2017-09-09), 10-Q (reporting date: 2017-06-17), 10-Q (reporting date: 2017-03-25), 10-K (reporting date: 2016-12-31), 10-Q (reporting date: 2016-09-03), 10-Q (reporting date: 2016-06-11), 10-Q (reporting date: 2016-03-19).

1 Q3 2021 Calculation
Equity turnover = (Net revenueQ3 2021 + Net revenueQ2 2021 + Net revenueQ1 2021 + Net revenueQ4 2020) ÷ Total PepsiCo shareholders’ equity
= (20,189 + 19,217 + 14,820 + 22,455) ÷ 15,872 = 4.83

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. PepsiCo Inc. equity turnover ratio deteriorated from Q1 2021 to Q2 2021 and from Q2 2021 to Q3 2021.