Stock Analysis on Net

PepsiCo Inc. (NASDAQ:PEP)

Analysis of Profitability Ratios
Quarterly Data

Microsoft Excel

Profitability Ratios (Summary)

PepsiCo Inc., profitability ratios (quarterly data)

Microsoft Excel
Dec 30, 2023 Sep 9, 2023 Jun 17, 2023 Mar 25, 2023 Dec 31, 2022 Sep 3, 2022 Jun 11, 2022 Mar 19, 2022 Dec 25, 2021 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
Return on Sales
Gross profit margin 54.21% 53.93% 53.58% 53.28% 53.03% 53.03% 53.13% 53.20% 53.35% 53.87% 54.23% 54.65% 54.82% 55.19% 55.28% 55.15% 55.13%
Operating profit margin 13.10% 12.14% 11.60% 10.08% 13.33% 15.85% 15.96% 17.46% 14.04% 14.90% 15.12% 14.68% 14.32% 14.52% 14.48% 14.98% 15.32%
Net profit margin 9.92% 9.05% 8.76% 7.48% 10.31% 11.61% 11.28% 12.57% 9.59% 10.62% 11.01% 10.51% 10.12% 10.27% 10.13% 10.62% 10.89%
Return on Investment
Return on equity (ROE) 49.04% 44.08% 44.67% 38.62% 51.96% 51.19% 49.78% 55.85% 47.48% 51.29% 53.65% 53.75% 52.92% 52.22% 54.84% 53.76% 49.47%
Return on assets (ROA) 9.03% 8.29% 8.24% 7.07% 9.67% 10.28% 9.92% 10.93% 8.25% 8.73% 8.88% 8.22% 7.66% 7.65% 7.65% 8.51% 9.31%

Based on: 10-K (reporting date: 2023-12-30), 10-Q (reporting date: 2023-09-09), 10-Q (reporting date: 2023-06-17), 10-Q (reporting date: 2023-03-25), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-03), 10-Q (reporting date: 2022-06-11), 10-Q (reporting date: 2022-03-19), 10-K (reporting date: 2021-12-25), 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).

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. gross profit margin ratio improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.
Operating profit margin A profitability ratio calculated as operating income divided by revenue. PepsiCo Inc. operating profit margin ratio improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.
Net profit margin An indicator of profitability, calculated as net income divided by revenue. PepsiCo Inc. net profit margin ratio improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Profitability ratio Description The company
ROE A profitability ratio calculated as net income divided by shareholders’ equity. PepsiCo Inc. ROE deteriorated from Q2 2023 to Q3 2023 but then improved from Q3 2023 to Q4 2023 exceeding Q2 2023 level.
ROA A profitability ratio calculated as net income divided by total assets. PepsiCo Inc. ROA improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Gross Profit Margin

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

Microsoft Excel
Dec 30, 2023 Sep 9, 2023 Jun 17, 2023 Mar 25, 2023 Dec 31, 2022 Sep 3, 2022 Jun 11, 2022 Mar 19, 2022 Dec 25, 2021 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
Selected Financial Data (US$ in millions)
Gross profit 14,753 12,778 12,201 9,858 14,576 11,663 10,810 8,767 13,118 10,795 10,337 8,149 12,029 9,935 8,857 7,754 11,294 9,494 9,045 7,196
Net revenue 27,850 23,453 22,322 17,846 27,996 21,971 20,225 16,200 25,248 20,189 19,217 14,820 22,455 18,091 15,945 13,881 20,640 17,188 16,449 12,884
Profitability Ratio
Gross profit margin1 54.21% 53.93% 53.58% 53.28% 53.03% 53.03% 53.13% 53.20% 53.35% 53.87% 54.23% 54.65% 54.82% 55.19% 55.28% 55.15% 55.13%
Benchmarks
Gross Profit Margin, Competitors2
Coca-Cola Co. 59.52% 59.14% 58.52% 58.09% 58.14% 58.49% 58.89% 60.27% 60.27% 60.72% 60.61% 59.42% 59.31% 59.90% 60.04% 60.66% 60.77%
Mondelēz International Inc. 38.22% 37.77% 36.59% 35.79% 35.92% 36.34% 37.76% 38.54% 39.19% 39.82% 40.44% 40.43% 39.30% 39.44% 38.85% 39.16% 39.96%

Based on: 10-K (reporting date: 2023-12-30), 10-Q (reporting date: 2023-09-09), 10-Q (reporting date: 2023-06-17), 10-Q (reporting date: 2023-03-25), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-03), 10-Q (reporting date: 2022-06-11), 10-Q (reporting date: 2022-03-19), 10-K (reporting date: 2021-12-25), 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).

1 Q4 2023 Calculation
Gross profit margin = 100 × (Gross profitQ4 2023 + Gross profitQ3 2023 + Gross profitQ2 2023 + Gross profitQ1 2023) ÷ (Net revenueQ4 2023 + Net revenueQ3 2023 + Net revenueQ2 2023 + Net revenueQ1 2023)
= 100 × (14,753 + 12,778 + 12,201 + 9,858) ÷ (27,850 + 23,453 + 22,322 + 17,846) = 54.21%

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. gross profit margin ratio improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Operating Profit Margin

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

Microsoft Excel
Dec 30, 2023 Sep 9, 2023 Jun 17, 2023 Mar 25, 2023 Dec 31, 2022 Sep 3, 2022 Jun 11, 2022 Mar 19, 2022 Dec 25, 2021 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
Selected Financial Data (US$ in millions)
Operating profit 1,683 4,015 3,659 2,629 815 3,353 2,077 5,267 2,562 3,159 3,129 2,312 2,826 3,011 2,319 1,924 2,699 2,855 2,729 2,008
Net revenue 27,850 23,453 22,322 17,846 27,996 21,971 20,225 16,200 25,248 20,189 19,217 14,820 22,455 18,091 15,945 13,881 20,640 17,188 16,449 12,884
Profitability Ratio
Operating profit margin1 13.10% 12.14% 11.60% 10.08% 13.33% 15.85% 15.96% 17.46% 14.04% 14.90% 15.12% 14.68% 14.32% 14.52% 14.48% 14.98% 15.32%
Benchmarks
Operating Profit Margin, Competitors2
Coca-Cola Co. 24.72% 24.68% 24.76% 24.99% 25.37% 24.81% 24.96% 27.39% 26.67% 29.03% 28.49% 27.93% 27.25% 26.36% 26.29% 26.98% 27.06%
Mondelēz International Inc. 15.28% 14.53% 13.02% 11.99% 11.22% 12.82% 15.12% 15.26% 16.20% 16.21% 15.94% 15.79% 14.50% 13.78% 12.95% 14.07% 14.86%

Based on: 10-K (reporting date: 2023-12-30), 10-Q (reporting date: 2023-09-09), 10-Q (reporting date: 2023-06-17), 10-Q (reporting date: 2023-03-25), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-03), 10-Q (reporting date: 2022-06-11), 10-Q (reporting date: 2022-03-19), 10-K (reporting date: 2021-12-25), 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).

1 Q4 2023 Calculation
Operating profit margin = 100 × (Operating profitQ4 2023 + Operating profitQ3 2023 + Operating profitQ2 2023 + Operating profitQ1 2023) ÷ (Net revenueQ4 2023 + Net revenueQ3 2023 + Net revenueQ2 2023 + Net revenueQ1 2023)
= 100 × (1,683 + 4,015 + 3,659 + 2,629) ÷ (27,850 + 23,453 + 22,322 + 17,846) = 13.10%

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. operating profit margin ratio improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Net Profit Margin

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

Microsoft Excel
Dec 30, 2023 Sep 9, 2023 Jun 17, 2023 Mar 25, 2023 Dec 31, 2022 Sep 3, 2022 Jun 11, 2022 Mar 19, 2022 Dec 25, 2021 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
Selected Financial Data (US$ in millions)
Net income attributable to PepsiCo 1,302 3,092 2,748 1,932 518 2,702 1,429 4,261 1,322 2,224 2,358 1,714 1,845 2,291 1,646 1,338 1,766 2,100 2,035 1,413
Net revenue 27,850 23,453 22,322 17,846 27,996 21,971 20,225 16,200 25,248 20,189 19,217 14,820 22,455 18,091 15,945 13,881 20,640 17,188 16,449 12,884
Profitability Ratio
Net profit margin1 9.92% 9.05% 8.76% 7.48% 10.31% 11.61% 11.28% 12.57% 9.59% 10.62% 11.01% 10.51% 10.12% 10.27% 10.13% 10.62% 10.89%
Benchmarks
Net Profit Margin, Competitors2
Coca-Cola Co. 23.42% 23.92% 23.81% 22.69% 22.19% 23.44% 23.16% 25.69% 25.28% 23.31% 22.19% 21.59% 23.47% 24.90% 26.77% 26.95% 23.94%
Mondelēz International Inc. 13.77% 12.97% 12.13% 11.99% 8.63% 10.30% 12.93% 14.34% 14.97% 15.70% 15.49% 13.94% 13.37% 11.93% 13.25% 14.18% 14.96%

Based on: 10-K (reporting date: 2023-12-30), 10-Q (reporting date: 2023-09-09), 10-Q (reporting date: 2023-06-17), 10-Q (reporting date: 2023-03-25), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-03), 10-Q (reporting date: 2022-06-11), 10-Q (reporting date: 2022-03-19), 10-K (reporting date: 2021-12-25), 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).

1 Q4 2023 Calculation
Net profit margin = 100 × (Net income attributable to PepsiCoQ4 2023 + Net income attributable to PepsiCoQ3 2023 + Net income attributable to PepsiCoQ2 2023 + Net income attributable to PepsiCoQ1 2023) ÷ (Net revenueQ4 2023 + Net revenueQ3 2023 + Net revenueQ2 2023 + Net revenueQ1 2023)
= 100 × (1,302 + 3,092 + 2,748 + 1,932) ÷ (27,850 + 23,453 + 22,322 + 17,846) = 9.92%

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. net profit margin ratio improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Return on Equity (ROE)

PepsiCo Inc., ROE calculation (quarterly data)

Microsoft Excel
Dec 30, 2023 Sep 9, 2023 Jun 17, 2023 Mar 25, 2023 Dec 31, 2022 Sep 3, 2022 Jun 11, 2022 Mar 19, 2022 Dec 25, 2021 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
Selected Financial Data (US$ in millions)
Net income attributable to PepsiCo 1,302 3,092 2,748 1,932 518 2,702 1,429 4,261 1,322 2,224 2,358 1,714 1,845 2,291 1,646 1,338 1,766 2,100 2,035 1,413
Total PepsiCo common shareholders’ equity 18,503 18,806 17,685 17,042 17,149 18,977 18,553 18,202 16,043 15,872 15,299 13,947 13,454 13,483 12,491 13,465 14,786 14,129 13,952 14,202
Profitability Ratio
ROE1 49.04% 44.08% 44.67% 38.62% 51.96% 51.19% 49.78% 55.85% 47.48% 51.29% 53.65% 53.75% 52.92% 52.22% 54.84% 53.76% 49.47%
Benchmarks
ROE, Competitors2
Coca-Cola Co. 41.30% 40.92% 40.40% 39.13% 39.59% 43.52% 41.60% 41.49% 42.48% 39.74% 36.31% 35.46% 40.14% 44.78% 52.56% 55.17% 46.99%
Mondelēz International Inc. 17.50% 16.09% 14.45% 13.97% 10.11% 11.78% 14.04% 14.89% 15.21% 16.08% 15.66% 13.96% 12.89% 11.60% 13.18% 14.38% 14.19%

Based on: 10-K (reporting date: 2023-12-30), 10-Q (reporting date: 2023-09-09), 10-Q (reporting date: 2023-06-17), 10-Q (reporting date: 2023-03-25), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-03), 10-Q (reporting date: 2022-06-11), 10-Q (reporting date: 2022-03-19), 10-K (reporting date: 2021-12-25), 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).

1 Q4 2023 Calculation
ROE = 100 × (Net income attributable to PepsiCoQ4 2023 + Net income attributable to PepsiCoQ3 2023 + Net income attributable to PepsiCoQ2 2023 + Net income attributable to PepsiCoQ1 2023) ÷ Total PepsiCo common shareholders’ equity
= 100 × (1,302 + 3,092 + 2,748 + 1,932) ÷ 18,503 = 49.04%

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. ROE deteriorated from Q2 2023 to Q3 2023 but then improved from Q3 2023 to Q4 2023 exceeding Q2 2023 level.

Return on Assets (ROA)

PepsiCo Inc., ROA calculation (quarterly data)

Microsoft Excel
Dec 30, 2023 Sep 9, 2023 Jun 17, 2023 Mar 25, 2023 Dec 31, 2022 Sep 3, 2022 Jun 11, 2022 Mar 19, 2022 Dec 25, 2021 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
Selected Financial Data (US$ in millions)
Net income attributable to PepsiCo 1,302 3,092 2,748 1,932 518 2,702 1,429 4,261 1,322 2,224 2,358 1,714 1,845 2,291 1,646 1,338 1,766 2,100 2,035 1,413
Total assets 100,495 99,953 95,906 93,042 92,187 94,461 93,103 92,962 92,377 93,254 92,385 91,224 92,918 92,041 89,525 85,062 78,547 77,444 75,084 75,466
Profitability Ratio
ROA1 9.03% 8.29% 8.24% 7.07% 9.67% 10.28% 9.92% 10.93% 8.25% 8.73% 8.88% 8.22% 7.66% 7.65% 7.65% 8.51% 9.31%
Benchmarks
ROA, Competitors2
Coca-Cola Co. 10.97% 11.04% 10.67% 10.13% 10.29% 10.73% 10.27% 10.96% 10.36% 9.73% 8.96% 8.02% 8.87% 8.57% 9.70% 10.65% 10.33%
Mondelēz International Inc. 6.95% 6.48% 5.75% 5.42% 3.82% 4.61% 5.85% 6.17% 6.41% 6.61% 6.49% 5.70% 5.24% 4.72% 5.34% 5.81% 6.00%

Based on: 10-K (reporting date: 2023-12-30), 10-Q (reporting date: 2023-09-09), 10-Q (reporting date: 2023-06-17), 10-Q (reporting date: 2023-03-25), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-03), 10-Q (reporting date: 2022-06-11), 10-Q (reporting date: 2022-03-19), 10-K (reporting date: 2021-12-25), 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).

1 Q4 2023 Calculation
ROA = 100 × (Net income attributable to PepsiCoQ4 2023 + Net income attributable to PepsiCoQ3 2023 + Net income attributable to PepsiCoQ2 2023 + Net income attributable to PepsiCoQ1 2023) ÷ Total assets
= 100 × (1,302 + 3,092 + 2,748 + 1,932) ÷ 100,495 = 9.03%

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. ROA improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.