Stock Analysis on Net

Merck & Co. Inc. (NYSE:MRK)

$24.99

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

Microsoft Excel

Paying user area


We accept:

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

Two-Component Disaggregation of ROE

Merck & Co. Inc., decomposition of ROE

Microsoft Excel
ROE = ROA × Financial Leverage
Dec 31, 2024 = ×
Dec 31, 2023 = ×
Dec 31, 2022 = ×
Dec 31, 2021 = ×
Dec 31, 2020 = ×

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).


Return on Assets (ROA)
The ROA demonstrates an overall increasing trend from 7.72% in 2020 to 14.62% in 2024, indicating improved efficiency in utilizing assets to generate profit. However, there is a notable decline to 0.34% in 2023, which represents a significant deviation from the otherwise upward trajectory. This dip suggests a temporary reduction in asset profitability during that year, followed by a recovery to a higher level in 2024.
Financial Leverage
Financial leverage exhibits a declining trend from 3.62 in 2020 to 2.53 in 2024, with a slight increase in 2023 to 2.84. The overall decrease in leverage indicates a gradual reduction in the use of debt relative to equity financing. The small uptick in 2023 contrasts with the general downward movement, possibly reflecting a strategic adjustment in capital structure during that period.
Return on Equity (ROE)
ROE increases from 27.91% in 2020 to 36.96% in 2024, showing enhanced profitability for shareholders. Similar to ROA, a pronounced drop occurs in 2023 to 0.97%, representing an anomaly within the otherwise positive performance trend. The rebound in 2024 to the highest recorded value suggests recovery and improved equity profitability post the 2023 setback.

Three-Component Disaggregation of ROE

Merck & Co. Inc., decomposition of ROE

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Dec 31, 2024 = × ×
Dec 31, 2023 = × ×
Dec 31, 2022 = × ×
Dec 31, 2021 = × ×
Dec 31, 2020 = × ×

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).


The financial data reveals several notable trends over the five-year period.

Net Profit Margin
The net profit margin experienced significant fluctuation. It increased sharply from 14.72% in 2020 to 26.79% in 2021 and then slightly decreased to 24.49% in 2022. In 2023, there was a dramatic decline to 0.61%, followed by a strong recovery to 26.68% in 2024. This pattern indicates potential exceptional events or operational challenges in 2023 that temporarily impacted profitability, with a swift rebound afterward.
Asset Turnover
Asset turnover showed a generally stable and slightly improving trend. Starting at 0.52 in 2020, it decreased to 0.46 in 2021 but then gradually increased to 0.54 in 2022, 0.56 in 2023, and slightly adjusted to 0.55 in 2024. This suggests incremental improvement in the efficiency of asset utilization over time, despite the temporary dip in 2021.
Financial Leverage
Financial leverage exhibited a declining trend from 3.62 in 2020 to 2.37 in 2022, suggesting a reduction in reliance on debt relative to equity during this period. It increased again to 2.84 in 2023 before decreasing slightly to 2.53 in 2024. These fluctuations could indicate adjustments in capital structure or financing strategies, potentially linked to the volatility observed in other metrics during the same years.
Return on Equity (ROE)
ROE mirrored the pattern seen in net profit margin, highlighting its sensitivity to profitability changes. ROE increased from 27.91% in 2020 to 34.17% in 2021, then decreased to 31.57% in 2022. A sharp drop to 0.97% occurred in 2023, followed by a robust increase to 36.96% in 2024. This indicates that shareholders’ returns were significantly impacted in 2023 but recovered strongly the following year, consistent with the patterns observed in profitability and leverage measures.

Five-Component Disaggregation of ROE

Merck & Co. Inc., decomposition of ROE

Microsoft Excel
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Financial Leverage
Dec 31, 2024 = × × × ×
Dec 31, 2023 = × × × ×
Dec 31, 2022 = × × × ×
Dec 31, 2021 = × × × ×
Dec 31, 2020 = × × × ×

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).


Tax Burden
The tax burden exhibited fluctuations over the observed periods, starting at 0.81 in 2020 and rising to a peak of 0.90 in 2021. Following this, a slight decrease occurred in 2022 to 0.88, with a notable drop to 0.19 in 2023, before recovering to 0.86 in 2024. The significant dip in 2023 suggests an unusual tax event or benefit that reduced the effective tax rate substantially for that year.
Interest Burden
Interest burden values mostly remained stable, with a slight upward trend from 0.91 in 2020 to 0.95 in 2021 and 0.94 in 2022. A considerable decline to 0.62 was observed in 2023, indicating increased interest expenses or lower earnings before interest and taxes during that year, followed by a return to 0.94 in 2024.
EBIT Margin
The EBIT margin demonstrated considerable variability, increasing markedly from 20.02% in 2020 to 31.57% in 2021, before slightly decreasing to 29.35% in 2022. A sharp decline to 5.03% occurred in 2023, reflecting a significant contraction in operating profitability. This was followed by a strong recovery to 33.02% in 2024, reaching the highest level within the analyzed timeframe.
Asset Turnover
Asset turnover ratios showed modest fluctuations, generally maintaining a range between 0.46 and 0.56. It decreased from 0.52 in 2020 to 0.46 in 2021, but then saw gradual increases to 0.54 in 2022, 0.56 in 2023, and a slight decrease to 0.55 in 2024. This trend indicates relatively stable efficiency in utilizing assets to generate revenue, with a slight improvement after 2021.
Financial Leverage
Financial leverage exhibited a declining trend from 3.62 in 2020 to 2.37 in 2022, suggesting a reduction in reliance on debt financing or equity structure adjustments. It increased again to 2.84 in 2023 before decreasing to 2.53 in 2024. Overall, the company appears to have moderated its financial leverage over the period, with some variation in the middle years.
Return on Equity (ROE)
Return on equity reflected a generally strong performance, increasing from 27.91% in 2020 to 34.17% in 2021, followed by a moderate drop to 31.57% in 2022. A significant decline to 0.97% in 2023 coincided with reductions in EBIT margin and tax burden anomalies, indicating a challenging year for profitability. ROE rebounded sharply to 36.96% in 2024, reaching the highest level of the period, signaling a robust recovery in shareholder returns.

Two-Component Disaggregation of ROA

Merck & Co. Inc., decomposition of ROA

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Dec 31, 2024 = ×
Dec 31, 2023 = ×
Dec 31, 2022 = ×
Dec 31, 2021 = ×
Dec 31, 2020 = ×

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).


Net Profit Margin
The net profit margin shows a fluctuating trend over the five-year period. It increased significantly from 14.72% in 2020 to a peak of 26.79% in 2021, followed by a slight decline to 24.49% in 2022. The margin then experienced a sharp drop to 0.61% in 2023, indicating a notable decrease in profitability during that year. However, it rebounded strongly to 26.68% in 2024, nearly restoring its previous high level.
Asset Turnover
The asset turnover ratio demonstrates a moderate level of stability with slight variations. It started at 0.52 in 2020, decreased to 0.46 in 2021, then increased steadily to 0.54 in 2022 and maintained an upward trajectory to 0.56 in 2023 before a minor decrease to 0.55 in 2024. This suggests relatively consistent efficiency in asset utilization with minor fluctuations.
Return on Assets (ROA)
The return on assets follows a pattern similar to that of the net profit margin. ROA improved notably from 7.72% in 2020 to 12.35% in 2021 and further to 13.3% in 2022. A dramatic decline occurred in 2023, with ROA dropping to 0.34%, reflecting a substantial downturn in asset profitability. A strong recovery is observed in 2024, with ROA rising sharply to 14.62%, surpassing previous peak values within the observed period.

Four-Component Disaggregation of ROA

Merck & Co. Inc., decomposition of ROA

Microsoft Excel
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
Dec 31, 2024 = × × ×
Dec 31, 2023 = × × ×
Dec 31, 2022 = × × ×
Dec 31, 2021 = × × ×
Dec 31, 2020 = × × ×

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).


Tax Burden
The tax burden ratio exhibits significant variability over the analyzed periods. It remained relatively stable and high during 2020 to 2022 (ranging from 0.81 to 0.90), experienced a sharp decline in 2023 to 0.19, and then rebounded to 0.86 in 2024. This fluctuation suggests a notable one-year deviation in tax expenses or tax strategy in 2023 before returning to previous levels.
Interest Burden
The interest burden ratio shows a stable trend around the mid-90% region from 2020 through 2022, slightly dipping in 2023 to 0.62, and returning close to previous levels at 0.94 in 2024. The dip in 2023 implies a temporary increase in interest expense or financial costs relative to operating income, which normalized in the subsequent year.
EBIT Margin
The EBIT margin demonstrates considerable fluctuations. It increased sharply from 20.02% in 2020 to over 31% in 2021, then slightly decreased to 29.35% in 2022. In 2023, the margin plunged markedly to 5.03%, followed by a strong recovery to 33.02% in 2024. These changes reflect variability in operational profitability, with 2023 showing a significant profitability challenge that was quickly reversed by 2024.
Asset Turnover
Asset turnover ratio remained relatively stable across all periods, ranging narrowly between 0.46 and 0.56. This stability indicates consistent efficiency in using assets to generate revenues without major fluctuations.
Return on Assets (ROA)
The ROA shows a pattern that mirrors the EBIT margin and burden ratios to some extent. It increased steadily from 7.72% in 2020 to 13.3% in 2022, then sharply decreased to 0.34% in 2023, followed by a strong resurgence to 14.62% in 2024. This volatility aligns with changes in profitability and expense burdens, highlighting 2023 as an outlier year with significantly reduced asset profitability.

Disaggregation of Net Profit Margin

Merck & Co. Inc., decomposition of net profit margin ratio

Microsoft Excel
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
Dec 31, 2024 = × ×
Dec 31, 2023 = × ×
Dec 31, 2022 = × ×
Dec 31, 2021 = × ×
Dec 31, 2020 = × ×

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).


The financial data reveals notable volatility across several key profitability and burden ratios over the reported periods.

Tax Burden
The tax burden ratio exhibits significant fluctuation, beginning at 0.81 in 2020, rising steadily to 0.9 in 2021, and slightly decreasing to 0.88 in 2022. A sharp decline to 0.19 is observed in 2023, followed by a recovery to 0.86 in 2024. This irregular pattern suggests an unusual tax event or adjustments affecting the tax expenses during 2023.
Interest Burden
The interest burden ratio remains relatively stable from 2020 to 2022, ranging between 0.91 and 0.95, indicating consistent interest expense relative to earnings before interest and taxes (EBIT). However, a marked decrease to 0.62 occurs in 2023, suggesting a significant increase in interest expenses or lower EBIT that year. The ratio rebounds to 0.94 in 2024, indicating normalization.
EBIT Margin
The EBIT margin shows strong performance with an increase from 20.02% in 2020 to a peak of 31.57% in 2021, followed by a slight decrease to 29.35% in 2022. A drastic drop to 5.03% in 2023 corresponds with the anomalies observed in tax and interest burdens, indicating a challenging year for operational profitability. The margin recovers sharply to 33.02% in 2024, surpassing previous highs.
Net Profit Margin
The net profit margin trend closely mirrors that of the EBIT margin. It rises from 14.72% in 2020 to 26.79% in 2021 and slightly falls to 24.49% in 2022. A steep decline to 0.61% in 2023 is observed, suggesting minimal net profitability during that year. The margin rebounds to 26.68% in 2024, near the high levels seen in 2021.

Overall, the company experienced a significant operational and financial disruption in 2023, as reflected by drastic drops in tax and interest burdens, EBIT margin, and net profit margin. The following year shows recovery to or above prior period performance, indicating a resilient rebound from the challenges encountered during 2023.