Stock Analysis on Net
Stock Analysis on Net
Microsoft Excel LibreOffice Calc

PepsiCo Inc. (NASDAQ:PEP)

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

Beginner level

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 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 Dec 26, 2015 Sep 5, 2015 Jun 13, 2015 Mar 21, 2015
Net fixed asset turnover 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 3.79 3.83 3.89 3.86 — — —
Total asset turnover 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 0.84 0.86 0.90 0.91 — — —
Equity turnover 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 4.91 5.08 5.64 5.29 — — —

Based on: 10-Q (filing date: 2020-10-01), 10-Q (filing date: 2020-07-13), 10-Q (filing date: 2020-04-28), 10-K (filing date: 2020-02-13), 10-Q (filing date: 2019-10-03), 10-Q (filing date: 2019-07-09), 10-Q (filing date: 2019-04-17), 10-K (filing date: 2019-02-15), 10-Q (filing date: 2018-10-02), 10-Q (filing date: 2018-07-10), 10-Q (filing date: 2018-04-26), 10-K (filing date: 2018-02-13), 10-Q (filing date: 2017-10-04), 10-Q (filing date: 2017-07-11), 10-Q (filing date: 2017-04-26), 10-K (filing date: 2017-02-15), 10-Q (filing date: 2016-09-29), 10-Q (filing date: 2016-07-07), 10-Q (filing date: 2016-04-18), 10-K (filing date: 2016-02-11), 10-Q (filing date: 2015-10-06), 10-Q (filing date: 2015-07-09), 10-Q (filing date: 2015-04-23).

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.’s net fixed asset turnover ratio deteriorated from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. PepsiCo Inc.’s total asset turnover ratio deteriorated from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. PepsiCo Inc.’s equity turnover ratio improved from Q1 2020 to Q2 2020 but then slightly deteriorated from Q2 2020 to Q3 2020 not reaching Q1 2020 level.

Net Fixed Asset Turnover

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

Microsoft Excel LibreOffice Calc
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 Dec 26, 2015 Sep 5, 2015 Jun 13, 2015 Mar 21, 2015
Selected Financial Data (US$ in millions)
Net revenue 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  18,585  16,331  15,923  12,217 
Property, plant and equipment, net 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  16,317  16,131  16,736  16,678 
Long-term Activity Ratio
Net fixed asset turnover1 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 3.79 3.83 3.89 3.86 — — —
Benchmarks
Net Fixed Asset Turnover, Competitors2
Coca-Cola Co. 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 3.80 3.42 3.48 3.52 — — —

Based on: 10-Q (filing date: 2020-10-01), 10-Q (filing date: 2020-07-13), 10-Q (filing date: 2020-04-28), 10-K (filing date: 2020-02-13), 10-Q (filing date: 2019-10-03), 10-Q (filing date: 2019-07-09), 10-Q (filing date: 2019-04-17), 10-K (filing date: 2019-02-15), 10-Q (filing date: 2018-10-02), 10-Q (filing date: 2018-07-10), 10-Q (filing date: 2018-04-26), 10-K (filing date: 2018-02-13), 10-Q (filing date: 2017-10-04), 10-Q (filing date: 2017-07-11), 10-Q (filing date: 2017-04-26), 10-K (filing date: 2017-02-15), 10-Q (filing date: 2016-09-29), 10-Q (filing date: 2016-07-07), 10-Q (filing date: 2016-04-18), 10-K (filing date: 2016-02-11), 10-Q (filing date: 2015-10-06), 10-Q (filing date: 2015-07-09), 10-Q (filing date: 2015-04-23).

1 Q3 2020 Calculation
Net fixed asset turnover = (Net revenueQ3 2020 + Net revenueQ2 2020 + Net revenueQ1 2020 + Net revenueQ4 2019) ÷ Property, plant and equipment, net
= (18,091 + 15,945 + 13,881 + 20,640) ÷ 19,726 = 3.48

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.’s net fixed asset turnover ratio deteriorated from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.

Total Asset Turnover

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

Microsoft Excel LibreOffice Calc
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 Dec 26, 2015 Sep 5, 2015 Jun 13, 2015 Mar 21, 2015
Selected Financial Data (US$ in millions)
Net revenue 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  18,585  16,331  15,923  12,217 
Total assets 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  69,667  69,902  72,262  69,625 
Long-term Activity Ratio
Total asset turnover1 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 0.84 0.86 0.90 0.91 — — —
Benchmarks
Total Asset Turnover, Competitors2
Coca-Cola Co. 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 0.45 0.46 0.48 0.49 — — —

Based on: 10-Q (filing date: 2020-10-01), 10-Q (filing date: 2020-07-13), 10-Q (filing date: 2020-04-28), 10-K (filing date: 2020-02-13), 10-Q (filing date: 2019-10-03), 10-Q (filing date: 2019-07-09), 10-Q (filing date: 2019-04-17), 10-K (filing date: 2019-02-15), 10-Q (filing date: 2018-10-02), 10-Q (filing date: 2018-07-10), 10-Q (filing date: 2018-04-26), 10-K (filing date: 2018-02-13), 10-Q (filing date: 2017-10-04), 10-Q (filing date: 2017-07-11), 10-Q (filing date: 2017-04-26), 10-K (filing date: 2017-02-15), 10-Q (filing date: 2016-09-29), 10-Q (filing date: 2016-07-07), 10-Q (filing date: 2016-04-18), 10-K (filing date: 2016-02-11), 10-Q (filing date: 2015-10-06), 10-Q (filing date: 2015-07-09), 10-Q (filing date: 2015-04-23).

1 Q3 2020 Calculation
Total asset turnover = (Net revenueQ3 2020 + Net revenueQ2 2020 + Net revenueQ1 2020 + Net revenueQ4 2019) ÷ Total assets
= (18,091 + 15,945 + 13,881 + 20,640) ÷ 92,041 = 0.74

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.’s total asset turnover ratio deteriorated from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.

Equity Turnover

PepsiCo Inc., equity turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Dec 26, 2015 Sep 5, 2015 Jun 13, 2015 Mar 21, 2015
Selected Financial Data (US$ in millions)
Net revenue 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  18,585  16,331  15,923  12,217 
Total PepsiCo shareholders’ equity 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  11,923  13,461  16,332  15,869 
Long-term Activity Ratio
Equity turnover1 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 4.91 5.08 5.64 5.29 — — —
Benchmarks
Equity Turnover, Competitors2
Coca-Cola Co. 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 1.63 1.62 1.76 1.73 — — —

Based on: 10-Q (filing date: 2020-10-01), 10-Q (filing date: 2020-07-13), 10-Q (filing date: 2020-04-28), 10-K (filing date: 2020-02-13), 10-Q (filing date: 2019-10-03), 10-Q (filing date: 2019-07-09), 10-Q (filing date: 2019-04-17), 10-K (filing date: 2019-02-15), 10-Q (filing date: 2018-10-02), 10-Q (filing date: 2018-07-10), 10-Q (filing date: 2018-04-26), 10-K (filing date: 2018-02-13), 10-Q (filing date: 2017-10-04), 10-Q (filing date: 2017-07-11), 10-Q (filing date: 2017-04-26), 10-K (filing date: 2017-02-15), 10-Q (filing date: 2016-09-29), 10-Q (filing date: 2016-07-07), 10-Q (filing date: 2016-04-18), 10-K (filing date: 2016-02-11), 10-Q (filing date: 2015-10-06), 10-Q (filing date: 2015-07-09), 10-Q (filing date: 2015-04-23).

1 Q3 2020 Calculation
Equity turnover = (Net revenueQ3 2020 + Net revenueQ2 2020 + Net revenueQ1 2020 + Net revenueQ4 2019) ÷ Total PepsiCo shareholders’ equity
= (18,091 + 15,945 + 13,881 + 20,640) ÷ 13,483 = 5.08

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.’s equity turnover ratio improved from Q1 2020 to Q2 2020 but then slightly deteriorated from Q2 2020 to Q3 2020 not reaching Q1 2020 level.