Stock Analysis on Net

PepsiCo Inc. (NASDAQ:PEP)

$24.99

DuPont Analysis: Disaggregation of ROE, ROA, and Net Profit Margin
Quarterly Data

Microsoft Excel

Paying user area


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Google Pay
Visa Secure Mastercard Identity Check American Express SafeKey

Two-Component Disaggregation of ROE

PepsiCo Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = ROA × Financial Leverage
Jun 14, 2025 = ×
Mar 22, 2025 = ×
Dec 28, 2024 = ×
Sep 7, 2024 = ×
Jun 15, 2024 = ×
Mar 23, 2024 = ×
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 = ×

Based on: 10-Q (reporting date: 2025-06-14), 10-Q (reporting date: 2025-03-22), 10-K (reporting date: 2024-12-28), 10-Q (reporting date: 2024-09-07), 10-Q (reporting date: 2024-06-15), 10-Q (reporting date: 2024-03-23), 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).


The analyzed financial data reveals notable trends in key performance ratios over the observed quarterly periods.

Return on Assets (ROA)
ROA values exhibit an overall fluctuating pattern. Initially, from March 2020 through December 2020, data is unavailable. Beginning in March 2021, ROA starts at 7.66%, rising to a peak of 10.93% by June 2022, indicating enhanced asset profitability during this timeframe. Subsequently, it demonstrates a variable downward and upward movement, with values oscillating between approximately 7.07% and 9.63% through the end of the recorded period in June 2025. This suggests some volatility in asset efficiency but remains predominantly in a moderate to strong performance range.
Financial Leverage
The financial leverage ratio shows a general decline from early 2020 to around mid-2022, dropping from 6.32 to below 5.0, suggesting a gradual reduction in reliance on debt financing relative to equity. After mid-2022, leverage ratios experience slight fluctuations but maintain a level around 5.0 to 5.7 toward the end of the period. This stabilization denotes a balanced capital structure with moderate leverage.
Return on Equity (ROE)
ROE mirrors trends seen in ROA but with greater volatility. Starting in March 2021 at around 52.92%, it peaks near 55.85% in June 2022, before sharply dipping to a nadir of 38.62% by March 2023. Following this trough, ROE somewhat recovers and stabilizes in the 44% to 53% range thereafter, with a moderate decrease observed toward the final periods. Such movements reflect fluctuating profitability relative to shareholder equity, influenced likely by both operational performance and changing leverage.

In summary, the data indicates a period of improving asset efficiency and equity returns up until mid-2022, followed by increased variability in profitability metrics. The reduction and subsequent stabilization in financial leverage suggest prudent financial management aimed at balancing growth and risk. The overall pattern underscores cycles of performance, with the company maintaining relatively strong returns on assets and equity despite some fluctuations toward the latter quarters.


Three-Component Disaggregation of ROE

PepsiCo Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Jun 14, 2025 = × ×
Mar 22, 2025 = × ×
Dec 28, 2024 = × ×
Sep 7, 2024 = × ×
Jun 15, 2024 = × ×
Mar 23, 2024 = × ×
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 = × ×

Based on: 10-Q (reporting date: 2025-06-14), 10-Q (reporting date: 2025-03-22), 10-K (reporting date: 2024-12-28), 10-Q (reporting date: 2024-09-07), 10-Q (reporting date: 2024-06-15), 10-Q (reporting date: 2024-03-23), 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).


The analysis of the quarterly financial data reveals several notable trends concerning profitability, efficiency, leverage, and overall equity returns.

Net Profit Margin
The net profit margin began being reported from March 2020, showing a generally positive trend with fluctuations. It increased from 10.12% in March 2020 to a peak around 12.57% in June 2022, indicating improved profitability during that period. However, post mid-2022, it experienced a downward adjustment, dropping to approximately 8.23% by June 2025. This suggests some challenges affecting profit margins in the more recent periods.
Asset Turnover
Asset turnover exhibited a gradual upward trend starting around March 2020, rising from 0.76 to a high near 0.95 by mid-2023, reflecting an increasing efficiency in using assets to generate revenue. From that point, a slight decline is observed, dipping to near 0.87 by June 2025, which could imply a marginal decrease in operational efficiency.
Financial Leverage
Financial leverage started high at 6.32 in early 2020, peaking around 7.17 shortly thereafter, before steadily decreasing to levels near 5.0 by late 2022. Since then, leverage has slightly increased again, rising to approximately 5.72 by mid-2025. This indicates a reduction in dependence on debt financing during the middle part of the period analyzed, followed by a somewhat increased leverage in recent quarters.
Return on Equity (ROE)
ROE followed a pattern similar to net profit margin and leverage, with a high of over 53% in mid-2020 and mid-2021, followed by a noticeable decline reaching roughly 38.6% by March 2023. Subsequently, ROE recovered to levels around 50-53% intermittently before slightly decreasing again to about 41% by mid-2025. This fluctuation in ROE reflects the combined impact of changes in profitability, asset utilization, and financial leverage over time.

Overall, the financial ratios indicate a period of improvement in profitability and efficiency in the early part of the period analyzed, coupled with a strategic deleveraging. However, recent quarters show signs of decreased profit margins, slight declines in asset efficiency, and a modest increase in leverage, which collectively have contributed to a reduction in return on equity compared to earlier peaks. These dynamics suggest evolving operational challenges and financial management decisions impacting the company's financial performance in the most recent periods.


Two-Component Disaggregation of ROA

PepsiCo Inc., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Jun 14, 2025 = ×
Mar 22, 2025 = ×
Dec 28, 2024 = ×
Sep 7, 2024 = ×
Jun 15, 2024 = ×
Mar 23, 2024 = ×
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 = ×

Based on: 10-Q (reporting date: 2025-06-14), 10-Q (reporting date: 2025-03-22), 10-K (reporting date: 2024-12-28), 10-Q (reporting date: 2024-09-07), 10-Q (reporting date: 2024-06-15), 10-Q (reporting date: 2024-03-23), 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).


The financial data reveals notable trends in key performance indicators over multiple quarterly periods.

Net Profit Margin (%)
The net profit margin exhibits variability with a general range between approximately 7.5% and 12.6%. Initially, margins increased steadily from 10.12% in early 2020 to a peak of 12.57% around mid-2022, indicating periods of strong profitability. Subsequently, the margin experienced a decline, reaching as low as 7.48% in early 2023, followed by a recovery phase fluctuating near the 9-10% mark. Towards the latest periods, the margin showed a mixed trend with another decline to 8.23% by mid-2025, suggesting some pressure on profitability.
Asset Turnover (ratio)
Asset turnover demonstrated a generally positive trajectory across the periods presented. Starting at 0.76, the ratio increased steadily and peaked close to 0.95 in early 2023, reflecting improved efficiency in using assets to generate revenue. After this peak, the turnover showed a slight downward trend, fluctuating around 0.9, but remained substantially higher than initial values, indicating sustained operational efficiency.
Return on Assets (ROA) (%)
Return on assets mirrored some characteristics of the net profit margin, with values initially rising from 7.66% to peaks above 10% during mid-to-late 2022. This increase corresponds with improved profitability and asset utilization. Post-peak, ROA declined to around 7.07% before recovering somewhat and stabilizing near 9-9.5%. Recent quarters suggest a modest downward trend towards 7.17%, aligning with the slight decline observed in profitability and asset turnover.

Overall, the data indicates a phase of growth in operational efficiency and profitability up to around early 2023, followed by a period of stabilization with some fluctuations and declines in key financial ratios. These trends imply challenges in maintaining peak profitability and efficiency levels in more recent quarters, warranting further investigation into underlying operational or market factors.