Stock Analysis on Net
Stock Analysis on Net

PepsiCo Inc. (NASDAQ:PEP)

Analysis of Profitability Ratios
Quarterly Data

Beginner level


Profitability Ratios (Summary)

PepsiCo Inc., profitability ratios (quarterly data)

Microsoft Excel LibreOffice Calc
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
Return on Sales
Gross profit margin 55.28% 55.15% 55.13% 55.00% 54.77% 54.74% 54.56% 54.34% 54.42% 54.47% 54.69% 54.89% 54.87% 55.00% 55.08% 55.32% 55.36% 55.20% 54.99%
Operating profit margin 14.48% 14.98% 15.32% 15.18% 15.32% 15.87% 15.64% 15.89% 16.18% 16.21% 16.54% 16.21% 16.00% 16.03% 15.58% 15.59% 13.25% 13.04% 13.25%
Net profit margin 10.13% 10.62% 10.89% 18.78% 19.59% 19.37% 19.35% 7.66% 7.14% 7.62% 7.65% 10.97% 10.77% 10.66% 10.08% 10.74% 8.34% 8.23% 8.65%
Return on Investment
Return on equity (ROE) 54.84% 53.76% 49.47% 87.78% 91.74% 88.61% 86.20% 48.13% 45.47% 44.86% 44.60% 52.41% 54.95% 58.05% 57.04% 52.74% 42.35% 46.46% 45.73%
Return on assets (ROA) 7.65% 8.51% 9.31% 16.01% 17.05% 16.68% 16.12% 6.72% 5.84% 5.96% 6.09% 8.88% 8.86% 9.00% 8.54% 8.99% 7.13% 7.37% 7.83%

Based on: 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).

Profitability ratio Description The company
Gross profit margin Gross profit margin indicates the percentage of revenue available to cover operating and other expenditures. PepsiCo Inc.’s gross profit margin ratio improved from Q4 2019 to Q1 2020 and from Q1 2020 to Q2 2020.
Operating profit margin A profitability ratio calculated as operating income divided by revenue. PepsiCo Inc.’s operating profit margin ratio deteriorated from Q4 2019 to Q1 2020 and from Q1 2020 to Q2 2020.
Net profit margin An indicator of profitability, calculated as net income divided by revenue. PepsiCo Inc.’s net profit margin ratio deteriorated from Q4 2019 to Q1 2020 and from Q1 2020 to Q2 2020.

Profitability ratio Description The company
ROE A profitability ratio calculated as net income divided by shareholders’ equity. PepsiCo Inc.’s ROE improved from Q4 2019 to Q1 2020 and from Q1 2020 to Q2 2020.
ROA A profitability ratio calculated as net income divided by total assets. PepsiCo Inc.’s ROA deteriorated from Q4 2019 to Q1 2020 and from Q1 2020 to Q2 2020.

Gross Profit Margin

PepsiCo Inc., gross profit margin calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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)
Gross profit 8,857  7,754  11,294  9,494  9,045  7,196  10,588  8,958  8,827  6,907  10,449  8,874  8,654  6,763  10,571  8,743  8,565  6,711  10,205  8,936  8,756  6,775 
Net revenue 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 
Profitability Ratio
Gross profit margin1 55.28% 55.15% 55.13% 55.00% 54.77% 54.74% 54.56% 54.34% 54.42% 54.47% 54.69% 54.89% 54.87% 55.00% 55.08% 55.32% 55.36% 55.20% 54.99%
Benchmarks
Gross Profit Margin, Competitors2
Coca-Cola Co. 60.04% 60.66% 60.77% 60.93% 61.56% 62.35% 63.05% 63.67% 63.57% 63.20% 62.56% 61.51% 61.15% 60.91% 60.67% 60.60% 60.30% 60.22% 60.53%

Based on: 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 Q2 2020 Calculation
Gross profit margin = 100 × (Gross profitQ2 2020 + Gross profitQ1 2020 + Gross profitQ4 2019 + Gross profitQ3 2019) ÷ (Net revenueQ2 2020 + Net revenueQ1 2020 + Net revenueQ4 2019 + Net revenueQ3 2019)
= 100 × (8,857 + 7,754 + 11,294 + 9,494) ÷ (15,945 + 13,881 + 20,640 + 17,188) = 55.28%

2 Click competitor name to see calculations.

Profitability ratio Description The company
Gross profit margin Gross profit margin indicates the percentage of revenue available to cover operating and other expenditures. PepsiCo Inc.’s gross profit margin ratio improved from Q4 2019 to Q1 2020 and from Q1 2020 to Q2 2020.

Operating Profit Margin

PepsiCo Inc., operating profit margin calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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)
Operating profit 2,319  1,924  2,699  2,855  2,729  2,008  2,431  2,844  3,028  1,807  2,593  2,993  2,990  1,933  2,381  2,821  2,964  1,619  2,240  1,416  2,900  1,797 
Net revenue 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 
Profitability Ratio
Operating profit margin1 14.48% 14.98% 15.32% 15.18% 15.32% 15.87% 15.64% 15.89% 16.18% 16.21% 16.54% 16.21% 16.00% 16.03% 15.58% 15.59% 13.25% 13.04% 13.25%
Benchmarks
Operating Profit Margin, Competitors2
Coca-Cola Co. 26.29% 26.98% 27.06% 27.11% 28.20% 28.32% 27.31% 25.95% 24.07% 21.61% 21.18% 20.20% 19.78% 20.80% 20.61% 20.70% 20.57% 19.54% 19.70%

Based on: 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 Q2 2020 Calculation
Operating profit margin = 100 × (Operating profitQ2 2020 + Operating profitQ1 2020 + Operating profitQ4 2019 + Operating profitQ3 2019) ÷ (Net revenueQ2 2020 + Net revenueQ1 2020 + Net revenueQ4 2019 + Net revenueQ3 2019)
= 100 × (2,319 + 1,924 + 2,699 + 2,855) ÷ (15,945 + 13,881 + 20,640 + 17,188) = 14.48%

2 Click competitor name to see calculations.

Profitability ratio Description The company
Operating profit margin A profitability ratio calculated as operating income divided by revenue. PepsiCo Inc.’s operating profit margin ratio deteriorated from Q4 2019 to Q1 2020 and from Q1 2020 to Q2 2020.

Net Profit Margin

PepsiCo Inc., net profit margin calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 income attributable to PepsiCo 1,646  1,338  1,766  2,100  2,035  1,413  6,854  2,498  1,820  1,343  (710) 2,144  2,105  1,318  1,401  1,992  2,005  931  1,718  533  1,980  1,221 
Net revenue 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 
Profitability Ratio
Net profit margin1 10.13% 10.62% 10.89% 18.78% 19.59% 19.37% 19.35% 7.66% 7.14% 7.62% 7.65% 10.97% 10.77% 10.66% 10.08% 10.74% 8.34% 8.23% 8.65%
Benchmarks
Net Profit Margin, Competitors2
Coca-Cola Co. 26.77% 26.95% 23.94% 21.98% 20.69% 20.48% 20.20% 8.70% 7.18% 4.23% 3.52% 12.20% 10.68% 15.30% 15.59% 16.99% 17.61% 16.59% 16.60%

Based on: 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 Q2 2020 Calculation
Net profit margin = 100 × (Net income attributable to PepsiCoQ2 2020 + Net income attributable to PepsiCoQ1 2020 + Net income attributable to PepsiCoQ4 2019 + Net income attributable to PepsiCoQ3 2019) ÷ (Net revenueQ2 2020 + Net revenueQ1 2020 + Net revenueQ4 2019 + Net revenueQ3 2019)
= 100 × (1,646 + 1,338 + 1,766 + 2,100) ÷ (15,945 + 13,881 + 20,640 + 17,188) = 10.13%

2 Click competitor name to see calculations.

Profitability ratio Description The company
Net profit margin An indicator of profitability, calculated as net income divided by revenue. PepsiCo Inc.’s net profit margin ratio deteriorated from Q4 2019 to Q1 2020 and from Q1 2020 to Q2 2020.

Return on Equity (ROE)

PepsiCo Inc., ROE calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 income attributable to PepsiCo 1,646  1,338  1,766  2,100  2,035  1,413  6,854  2,498  1,820  1,343  (710) 2,144  2,105  1,318  1,401  1,992  2,005  931  1,718  533  1,980  1,221 
Total PepsiCo shareholders’ equity 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 
Profitability Ratio
ROE1 54.84% 53.76% 49.47% 87.78% 91.74% 88.61% 86.20% 48.13% 45.47% 44.86% 44.60% 52.41% 54.95% 58.05% 57.04% 52.74% 42.35% 46.46% 45.73%
Benchmarks
ROE, Competitors2
Coca-Cola Co. 52.56% 55.17% 46.99% 41.40% 38.69% 38.03% 37.89% 15.40% 12.98% 7.31% 7.31% 20.57% 18.86% 27.22% 28.30% 27.67% 28.60% 29.21% 28.77%

Based on: 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 Q2 2020 Calculation
ROE = 100 × (Net income attributable to PepsiCoQ2 2020 + Net income attributable to PepsiCoQ1 2020 + Net income attributable to PepsiCoQ4 2019 + Net income attributable to PepsiCoQ3 2019) ÷ Total PepsiCo shareholders’ equity
= 100 × (1,646 + 1,338 + 1,766 + 2,100) ÷ 12,491 = 54.84%

2 Click competitor name to see calculations.

Profitability ratio Description The company
ROE A profitability ratio calculated as net income divided by shareholders’ equity. PepsiCo Inc.’s ROE improved from Q4 2019 to Q1 2020 and from Q1 2020 to Q2 2020.

Return on Assets (ROA)

PepsiCo Inc., ROA calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 income attributable to PepsiCo 1,646  1,338  1,766  2,100  2,035  1,413  6,854  2,498  1,820  1,343  (710) 2,144  2,105  1,318  1,401  1,992  2,005  931  1,718  533  1,980  1,221 
Total assets 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 
Profitability Ratio
ROA1 7.65% 8.51% 9.31% 16.01% 17.05% 16.68% 16.12% 6.72% 5.84% 5.96% 6.09% 8.88% 8.86% 9.00% 8.54% 8.99% 7.13% 7.37% 7.83%
Benchmarks
ROA, Competitors2
Coca-Cola Co. 9.70% 10.65% 10.33% 8.86% 7.82% 7.63% 7.73% 3.24% 2.66% 1.54% 1.42% 5.03% 4.55% 6.83% 7.48% 7.68% 8.10% 7.97% 8.16%

Based on: 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 Q2 2020 Calculation
ROA = 100 × (Net income attributable to PepsiCoQ2 2020 + Net income attributable to PepsiCoQ1 2020 + Net income attributable to PepsiCoQ4 2019 + Net income attributable to PepsiCoQ3 2019) ÷ Total assets
= 100 × (1,646 + 1,338 + 1,766 + 2,100) ÷ 89,525 = 7.65%

2 Click competitor name to see calculations.

Profitability ratio Description The company
ROA A profitability ratio calculated as net income divided by total assets. PepsiCo Inc.’s ROA deteriorated from Q4 2019 to Q1 2020 and from Q1 2020 to Q2 2020.