Stock Analysis on Net
Stock Analysis on Net

PepsiCo Inc. (NASDAQ:PEP)

Common-Size Income Statement
Quarterly Data

PepsiCo Inc., common-size consolidated income statement (quarterly data)

Microsoft Excel
3 months ended: 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
Net revenue 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00
Cost of sales -47.03 -45.52 -45.34 -44.76 -47.94 -46.92 -46.55 -45.88 -48.04 -46.53 -46.21 -45.01 -46.43 -45.08 -44.45 -44.14 -45.28 -44.76 -45.01 -44.15
Gross profit 52.97% 54.48% 54.66% 55.24% 52.06% 53.08% 53.45% 54.12% 51.96% 53.47% 53.79% 54.99% 53.57% 54.92% 55.55% 55.86% 54.72% 55.24% 54.99% 55.85%
Selling, general and administrative expenses -43.62 -37.34 -38.27 -40.51 -43.57 -37.75 -36.52 -40.62 -41.81 -37.82 -37.51 -39.39 -40.98 -38.27 -41.00 -42.00 -41.64 -38.63 -38.40 -40.27
Gain associated with the Juice Transaction 0.00 0.00 0.00 0.00 0.00 -0.06 0.06 20.51 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Impairment of intangible assets -3.31 -0.03 0.00 0.00 -5.59 0.00 -6.72 -1.49 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Operating profit 6.04% 17.12% 16.39% 14.73% 2.91% 15.26% 10.27% 32.51% 10.15% 15.65% 16.28% 15.60% 12.59% 16.64% 14.54% 13.86% 13.08% 16.61% 16.59% 15.59%
Other pension and retiree medical benefits income (expense) 0.24 0.26 0.27 0.34 -0.13 0.16 -0.01 0.83 0.63 0.58 0.66 0.81 -0.58 0.48 0.53 0.55 -1.00 0.22 0.37 0.50
Net interest expense and other -0.78 -0.86 -0.90 -1.12 -0.98 -0.86 -1.17 -1.48 -4.48 -1.15 -1.25 -1.74 -1.51 -1.46 -1.47 -2.09 -1.38 -1.30 -1.36 -1.58
Income before income taxes 5.50% 16.53% 15.76% 13.95% 1.81% 14.56% 9.09% 31.86% 6.29% 15.08% 15.68% 14.67% 10.50% 15.66% 13.60% 12.33% 10.70% 15.53% 15.61% 14.50%
Provision for income taxes -0.75 -3.24 -3.35 -3.06 0.10 -2.16 -1.94 -5.48 -0.98 -3.97 -3.34 -3.04 -2.22 -2.91 -3.20 -2.59 -2.08 -3.25 -3.19 -3.46
Net income 4.75% 13.29% 12.41% 10.89% 1.91% 12.40% 7.15% 26.38% 5.31% 11.11% 12.34% 11.63% 8.28% 12.75% 10.40% 9.73% 8.61% 12.28% 12.42% 11.04%
Net income attributable to noncontrolling interests -0.08 -0.10 -0.10 -0.07 -0.06 -0.10 -0.08 -0.07 -0.08 -0.09 -0.07 -0.06 -0.06 -0.09 -0.08 -0.09 -0.06 -0.06 -0.05 -0.07
Net income attributable to PepsiCo 4.68% 13.18% 12.31% 10.83% 1.85% 12.30% 7.07% 26.30% 5.24% 11.02% 12.27% 11.57% 8.22% 12.66% 10.32% 9.64% 8.56% 12.22% 12.37% 10.97%

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).

Income statement item Description The company
Operating profit The net result for the period of deducting operating expenses from operating revenues. PepsiCo Inc. operating profit as a percentage of net revenue increased from Q2 2023 to Q3 2023 but then decreased significantly from Q3 2023 to Q4 2023.
Income before income taxes Amount of income (loss) from continuing operations, including income (loss) from equity method investments, before deduction of income tax expense (benefit), and income (loss) attributable to noncontrolling interest. PepsiCo Inc. income before income taxes as a percentage of net revenue increased from Q2 2023 to Q3 2023 but then decreased significantly from Q3 2023 to Q4 2023.
Net income attributable to PepsiCo The portion of profit or loss for the period, net of income taxes, which is attributable to the parent. PepsiCo Inc. net income attributable to PepsiCo as a percentage of net revenue increased from Q2 2023 to Q3 2023 but then decreased significantly from Q3 2023 to Q4 2023.