Stock Analysis on Net

Keurig Dr Pepper Inc. (NASDAQ:KDP)

$22.49

This company has been moved to the archive! The financial data has not been updated since July 28, 2022.

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

Microsoft Excel

Paying user area

The data is hidden behind: . Unhide it.

This is a one-time payment. There is no automatic renewal.


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

Keurig Dr Pepper Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = ROA × Financial Leverage
Jun 30, 2022 = ×
Mar 31, 2022 = ×
Dec 31, 2021 = ×
Sep 30, 2021 = ×
Jun 30, 2021 = ×
Mar 31, 2021 = ×
Dec 31, 2020 = ×
Sep 30, 2020 = ×
Jun 30, 2020 = ×
Mar 31, 2020 = ×
Dec 31, 2019 = ×
Sep 30, 2019 = ×
Jun 30, 2019 = ×
Mar 31, 2019 = ×

Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).


The analysis of the quarterly financial data reveals several notable trends regarding profitability and leverage metrics over the observed periods from early 2019 to mid-2022.

Return on Assets (ROA)
ROA data is unavailable before March 31, 2020. From this point, it shows a relatively stable but gradual increase with minor fluctuations. The ROA started at 2.53% in March 2020, slightly declining to 2.37% by September 2020, followed by a consistent upward trend reaching a peak of 4.70% in June 2022. The general trend indicates an improvement in asset efficiency, as the company appears to generate higher returns on its asset base over time.
Financial Leverage
The financial leverage ratio demonstrates a gradual decline throughout the entire period, starting from 2.17 in early 2019 and decreasing steadily to 2.01 by March 2022, before a slight uptick to 2.03 in June 2022. This trend suggests a modest reduction in reliance on debt financing relative to equity, indicating a conservative approach to leverage or improving equity base over time.
Return on Equity (ROE)
ROE values, available from March 2020 onwards, follow a pattern similar to ROA but with a higher magnitude due to the leverage effect. It began at 5.39% in March 2020, exhibiting a small decline up to September 2020, before increasing steadily to reach 9.43% in June 2022. Despite a slight decrease in the final quarter to 8.57%, the overall trajectory signifies enhanced profitability from the shareholders’ perspective.

In summary, the company exhibits improving profitability metrics, both on assets and equity, alongside a slowly decreasing but relatively stable financial leverage ratio. This combination suggests an enhanced ability to generate returns while maintaining prudent leverage levels, reflecting positively on operational efficiency and financial management over the reviewed periods.


Three-Component Disaggregation of ROE

Keurig Dr Pepper Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Jun 30, 2022 = × ×
Mar 31, 2022 = × ×
Dec 31, 2021 = × ×
Sep 30, 2021 = × ×
Jun 30, 2021 = × ×
Mar 31, 2021 = × ×
Dec 31, 2020 = × ×
Sep 30, 2020 = × ×
Jun 30, 2020 = × ×
Mar 31, 2020 = × ×
Dec 31, 2019 = × ×
Sep 30, 2019 = × ×
Jun 30, 2019 = × ×
Mar 31, 2019 = × ×

Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).


Net Profit Margin
The net profit margin exhibits a clear upward trend from March 31, 2020, starting at 11.28%, and progressively increasing to a peak of 18.71% by June 30, 2022. This indicates improving profitability over the observed quarters, with only a slight dip to 16.39% in the final reported period, suggesting sustained efficiency in cost management and revenue generation.
Asset Turnover
The asset turnover ratio shows a gradual but steady increase from 0.22 in March 31, 2020, to 0.26 by June 30, 2022. This implies an improvement in the company's efficiency in using its assets to generate sales over time, reflecting better operational performance and asset utilization.
Financial Leverage
Financial leverage declines moderately from 2.17 in the early periods of 2019 to a low of 2.01 by March 31, 2022, before slightly increasing to 2.03 in June 30, 2022. This trend suggests a gradual reduction in reliance on debt financing relative to equity, which may indicate a lower financial risk profile or a strategic adjustment in capital structure.
Return on Equity (ROE)
The return on equity follows an increasing trajectory, starting from 5.39% in March 31, 2020, and reaching a high of 9.43% by June 30, 2022. This growth demonstrates enhanced shareholder value creation and improved profitability relative to equity invested, supported by the combined effects of higher net profit margins and slightly improved asset turnover, despite decreasing financial leverage.

Five-Component Disaggregation of ROE

Keurig Dr Pepper Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Financial Leverage
Jun 30, 2022 = × × × ×
Mar 31, 2022 = × × × ×
Dec 31, 2021 = × × × ×
Sep 30, 2021 = × × × ×
Jun 30, 2021 = × × × ×
Mar 31, 2021 = × × × ×
Dec 31, 2020 = × × × ×
Sep 30, 2020 = × × × ×
Jun 30, 2020 = × × × ×
Mar 31, 2020 = × × × ×
Dec 31, 2019 = × × × ×
Sep 30, 2019 = × × × ×
Jun 30, 2019 = × × × ×
Mar 31, 2019 = × × × ×

Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).


Tax Burden
The tax burden ratio shows a relatively stable trend with marginal increases over the observed periods, moving from 0.74 in early 2020 to 0.79 by mid-2022. This suggests a slight rise in the proportion of earnings retained after taxes.
Interest Burden
Interest burden ratios initially decreased slightly from 0.72 to 0.71 in early 2020 but generally increased thereafter, reaching a peak of 0.85 in early 2022 before a small decline to 0.82. This indicates gradual improvement in managing interest expenses against earnings before interest and taxes.
EBIT Margin
The EBIT margin experienced fluctuations but a clear upward trend is evident starting from 19.79% in the second quarter of 2020 to a peak of 28.88% in the first quarter of 2022, followed by a slight decline to 25.34% in mid-2022. This trend reflects enhanced operational efficiency or pricing power over the period.
Asset Turnover
Asset turnover remained relatively stable and demonstrated a slow, consistent increase from 0.22 in early 2020 to 0.26 by mid-2022. This gradual improvement suggests more effective utilization of assets in generating revenue.
Financial Leverage
Financial leverage ratios showed a slow but steady decline from 2.17 in early 2019 to approximately 2.01-2.03 in mid-2022. The decrease indicates a modest reduction in the company's reliance on debt financing relative to equity.
Return on Equity (ROE)
ROE trended upward overall, starting at 5.39% in the first quarter of 2020 and reaching a high of 9.43% in the first quarter of 2022 before a slight decrease to 8.57% by mid-2022. Improvement in ROE is consistent with the enhancements in operational performance and slightly decreased financial leverage.

Two-Component Disaggregation of ROA

Keurig Dr Pepper Inc., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Jun 30, 2022 = ×
Mar 31, 2022 = ×
Dec 31, 2021 = ×
Sep 30, 2021 = ×
Jun 30, 2021 = ×
Mar 31, 2021 = ×
Dec 31, 2020 = ×
Sep 30, 2020 = ×
Jun 30, 2020 = ×
Mar 31, 2020 = ×
Dec 31, 2019 = ×
Sep 30, 2019 = ×
Jun 30, 2019 = ×
Mar 31, 2019 = ×

Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).


Net Profit Margin
The net profit margin demonstrates a consistent upward trend from March 31, 2020, through June 30, 2022. Beginning at 11.28%, it experienced a slight decline to 10.32% by September 30, 2020, before recovering and steadily increasing to reach a peak of 18.71% in March 31, 2022. Thereafter, there was a moderate decrease to 16.39% by June 30, 2022. Overall, this indicates improving profitability efficiency over the periods analyzed.
Asset Turnover
The asset turnover ratio shows a gradual but steady increase starting from 0.22 in March 31, 2020, progressing consistently each quarter, and reaching 0.26 by June 30, 2022. This suggests an improving ability to generate sales from assets over time, reflecting enhanced operational efficiency in asset utilization.
Return on Assets (ROA)
Return on assets follows a positive upward trajectory throughout the examined timeframe. It starts at 2.53% in March 31, 2020, experiences minor fluctuations in the initial periods, and then steadily rises to peak at 4.7% as of March 31, 2022. By June 30, 2022, ROA slightly decreased to 4.23%, but remains significantly higher than at the onset of the period. This trend indicates an overall improvement in the company's ability to generate earnings relative to its asset base.

Four-Component Disaggregation of ROA

Keurig Dr Pepper Inc., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
Jun 30, 2022 = × × ×
Mar 31, 2022 = × × ×
Dec 31, 2021 = × × ×
Sep 30, 2021 = × × ×
Jun 30, 2021 = × × ×
Mar 31, 2021 = × × ×
Dec 31, 2020 = × × ×
Sep 30, 2020 = × × ×
Jun 30, 2020 = × × ×
Mar 31, 2020 = × × ×
Dec 31, 2019 = × × ×
Sep 30, 2019 = × × ×
Jun 30, 2019 = × × ×
Mar 31, 2019 = × × ×

Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).


The financial data reveals several notable trends over the observed periods. Starting with the tax burden ratio, it remained fairly stable initially, maintaining a value around 0.74 until a gradual upward trend began in late 2020. By mid-2022, the tax burden had increased to approximately 0.79, indicating a rising proportion of income allocated to taxes over time.

The interest burden ratio exhibits a consistent increase from the first recorded value in early 2020 at 0.72 to a peak of around 0.85 by early 2022. This suggests that the company has been managing to reduce its interest expenses relative to its earnings before interest and taxes (EBIT), improving its interest coverage capability during this period.

The EBIT margin percentage shows a fluctuating but generally positive trend. Beginning near 21.12% in early 2020, the margin experiences some decline in mid-2020 but then steadily increases, reaching its highest level of approximately 28.88% by the first quarter of 2022. A modest decline to 25.34% follows in mid-2022, implying strong profitability with some recent pressure on margins.

Asset turnover, a measure of efficiency in using assets to generate sales, maintains a slow but steady rise throughout the periods, moving from 0.22 in early 2020 to 0.26 by mid-2022. This gradual improvement suggests enhanced operational efficiency, with assets being utilized more effectively to produce revenue.

The return on assets (ROA) reflects an overall upward trajectory, beginning at 2.53% and increasing consistently to reach a peak near 4.7% in early 2022, before a slight decrease to 4.23% in mid-2022. This rise in ROA coincides with improvements in both EBIT margin and asset turnover, indicating increased profitability relative to the company's asset base.

Tax Burden
Shows a gradual increase over the periods, indicating a rising tax expense as a proportion of income.
Interest Burden
Demonstrates improvement with a steady rise, suggesting more efficient interest expense management.
EBIT Margin
Reveals growth in profitability margins with some fluctuation, peaking in early 2022 before a minor decline.
Asset Turnover
Exhibits a slow but steady increase, pointing to improved asset utilization efficiency.
Return on Assets (ROA)
Displays an overall positive trend, reflecting enhanced profitability relative to assets, with slight recent softness.

Disaggregation of Net Profit Margin

Keurig Dr Pepper Inc., decomposition of net profit margin ratio (quarterly data)

Microsoft Excel
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
Jun 30, 2022 = × ×
Mar 31, 2022 = × ×
Dec 31, 2021 = × ×
Sep 30, 2021 = × ×
Jun 30, 2021 = × ×
Mar 31, 2021 = × ×
Dec 31, 2020 = × ×
Sep 30, 2020 = × ×
Jun 30, 2020 = × ×
Mar 31, 2020 = × ×
Dec 31, 2019 = × ×
Sep 30, 2019 = × ×
Jun 30, 2019 = × ×
Mar 31, 2019 = × ×

Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).


The analysis of the quarterly financial ratios reveals several noteworthy trends and patterns over the observed periods.

Tax Burden
The tax burden ratio remained relatively stable from March 2020 onward, with values hovering around 0.74 to 0.79. Starting at 0.74 in March 2020, there is a gradual increase to 0.79 by June 2022, indicating a slight rise in the proportion of income retained after taxes.
Interest Burden
The interest burden ratio shows a noticeable upward trend, beginning at 0.72 in March 2020 and increasing to a peak of 0.85 in March and June 2022, before slightly declining to 0.82 in the last reported quarter. This indicates an improvement in managing interest obligations relative to earnings before interest and taxes.
EBIT Margin
The EBIT margin exhibits a positive trend with some fluctuations. Starting at 21.12% in March 2020, it slightly decreased to a low of 19.49% in September 2020, then steadily increased to reach a peak of 28.88% in March 2022, before dropping back to 25.34% in June 2022. This reflects enhanced operational efficiency and profitability over the period with minor recent moderation.
Net Profit Margin
The net profit margin follows a similar upward trajectory. From 11.28% in March 2020, it dips slightly to 10.32% in September 2020, then consistently rises to a high of 18.71% in March 2022, followed by a slight decrease to 16.39% in June 2022. This pattern suggests improved overall profitability despite some recent contractions.

In summary, the data reveals a general improvement in profitability metrics, represented by increasing EBIT and net profit margins, alongside enhanced management of tax and interest expenses. However, the slight declines in the most recent quarter may warrant continued monitoring to assess whether these represent temporary fluctuations or the beginning of new trends.