Stock Analysis on Net

Home Depot Inc. (NYSE:HD)

$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 Google Pay
Visa Secure Mastercard Identity Check American Express SafeKey

Two-Component Disaggregation of ROE

Home Depot Inc., decomposition of ROE

Microsoft Excel
ROE = ROA × Financial Leverage
Feb 1, 2026 = ×
Feb 2, 2025 = ×
Jan 28, 2024 = ×
Jan 29, 2023 = ×
Jan 30, 2022 = ×
Jan 31, 2021 = ×

Based on: 10-K (reporting date: 2026-02-01), 10-K (reporting date: 2025-02-02), 10-K (reporting date: 2024-01-28), 10-K (reporting date: 2023-01-29), 10-K (reporting date: 2022-01-30), 10-K (reporting date: 2021-01-31).


The period under review demonstrates significant fluctuations in Return on Assets (ROA), Financial Leverage, and Return on Equity (ROE). A notable pattern emerges when examining the interplay between these metrics, particularly concerning the drivers of ROE.

Return on Assets (ROA)
ROA exhibited an initial increase from 18.23% in 2021 to 22.86% in 2022, followed by a slight decrease to 22.38% in 2023. A more pronounced decline is then observed, with ROA falling to 19.79% in 2024, 15.40% in 2025, and further to 13.47% in 2026. This indicates a consistent weakening in the company’s ability to generate profit from its assets over the analyzed timeframe.
Financial Leverage
Financial Leverage experienced substantial volatility. The value for 2022 is missing. A significant increase is observed from 48.94 in 2023 to 73.30 in 2024, suggesting a considerable increase in the use of debt financing. Subsequently, Financial Leverage decreased sharply to 14.48 in 2025 and continued to decline to 8.20 in 2026. This suggests a deliberate reduction in debt utilization in the later years of the period.
Return on Equity (ROE)
ROE displayed the most dramatic fluctuations. It rose sharply from a value of 390.00 in 2021 to 1,095.07 in 2023, coinciding with the increase in Financial Leverage. ROE peaked at 1,450.48 in 2024, driven by both high ROA and high Financial Leverage. Following this peak, ROE decreased substantially to 222.98 in 2025 and further to 110.48 in 2026, mirroring the declines in both ROA and Financial Leverage. The substantial changes in ROE are directly attributable to the combined effects of changes in ROA and Financial Leverage.

The analysis reveals a strong correlation between Financial Leverage and ROE. The peak in ROE in 2024 was largely a result of amplified returns due to increased leverage. However, the subsequent decline in ROE, despite a continued decrease in leverage, indicates that the primary driver of the downturn was the diminishing ROA. The company’s ability to generate profits from its asset base is becoming increasingly challenged, and this is overshadowing the impact of leverage adjustments on overall equity returns.

The significant volatility in these ratios warrants further investigation into the underlying operational and financial decisions driving these trends. The decreasing ROA, in particular, requires attention to identify potential areas for improvement in asset utilization and profitability.


Three-Component Disaggregation of ROE

Home Depot Inc., decomposition of ROE

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Feb 1, 2026 = × ×
Feb 2, 2025 = × ×
Jan 28, 2024 = × ×
Jan 29, 2023 = × ×
Jan 30, 2022 = × ×
Jan 31, 2021 = × ×

Based on: 10-K (reporting date: 2026-02-01), 10-K (reporting date: 2025-02-02), 10-K (reporting date: 2024-01-28), 10-K (reporting date: 2023-01-29), 10-K (reporting date: 2022-01-30), 10-K (reporting date: 2021-01-31).


The three-component DuPont analysis reveals significant fluctuations in the company’s Return on Equity (ROE) over the observed period. These fluctuations are driven by changes in Net Profit Margin, Asset Turnover, and Financial Leverage. A substantial increase in ROE is evident between 2023 and 2024, followed by a considerable decline in subsequent years.

Net Profit Margin
The Net Profit Margin exhibited an initial increase from 9.74% in 2021 to 10.87% in 2022, remaining stable in 2023. A gradual decline is then observed, decreasing to 9.28% in 2025 and further to 8.60% in 2026. This suggests a weakening ability to translate sales into profits over time.
Asset Turnover
Asset Turnover increased from 1.87 in 2021 to 2.10 in 2022, indicating improved efficiency in utilizing assets to generate sales. While remaining relatively high at 2.06 in 2023, it decreased to 1.99 in 2024 and continued to decline to 1.66 in 2025 and 1.57 in 2026. This indicates a diminishing efficiency in asset utilization.
Financial Leverage
Financial Leverage experienced a dramatic increase from 21.39 in 2021 to 48.94 in 2023, peaking at 73.30 in 2024. This signifies a substantial increase in the use of debt financing. Subsequently, Financial Leverage decreased significantly to 14.48 in 2025 and further to 8.20 in 2026, suggesting a reduction in debt financing. The missing value for 2022 prevents a complete understanding of the leverage trend during that year.
Return on Equity (ROE)
ROE demonstrated a remarkable surge from 390.00% in 2021 to 1,095.07% in 2023, largely attributable to the increase in Financial Leverage. The ROE peaked at 1,450.48% in 2024, coinciding with the highest level of Financial Leverage. A substantial decline followed, with ROE decreasing to 222.98% in 2025 and 110.48% in 2026, mirroring the reduction in Financial Leverage and the declining Net Profit Margin and Asset Turnover. The missing value for 2022 prevents a complete understanding of the ROE trend during that year.

The analysis indicates that changes in Financial Leverage were the primary driver of ROE fluctuations during the period. While Net Profit Margin and Asset Turnover also contribute to ROE, their impact was less pronounced than that of Financial Leverage. The recent declines in all three components suggest potential challenges to maintaining profitability and efficient asset utilization in the future.


Five-Component Disaggregation of ROE

Home Depot Inc., decomposition of ROE

Microsoft Excel
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Financial Leverage
Feb 1, 2026 = × × × ×
Feb 2, 2025 = × × × ×
Jan 28, 2024 = × × × ×
Jan 29, 2023 = × × × ×
Jan 30, 2022 = × × × ×
Jan 31, 2021 = × × × ×

Based on: 10-K (reporting date: 2026-02-01), 10-K (reporting date: 2025-02-02), 10-K (reporting date: 2024-01-28), 10-K (reporting date: 2023-01-29), 10-K (reporting date: 2022-01-30), 10-K (reporting date: 2021-01-31).


The five-component DuPont analysis reveals significant fluctuations in the drivers of Return on Equity (ROE) over the observed period. While the Tax Burden remained consistently at 0.76, substantial changes occurred in Interest Burden, EBIT Margin, Asset Turnover, and particularly, Financial Leverage, leading to dramatic shifts in overall ROE.

Return on Equity (ROE)
ROE experienced considerable volatility. It began at 390.00 in 2021, increased dramatically to 1,095.07 in 2023, peaked at 1,450.48 in 2024, and then declined sharply to 222.98 in 2025 and further to 110.48 in 2026. This pattern suggests a strong sensitivity to changes in the underlying components, especially Financial Leverage.
Profitability (EBIT Margin)
EBIT Margin demonstrated an initial increase from 13.87 in 2021 to 15.27 in 2022 and 15.31 in 2023. However, a downward trend commenced in 2024, falling to 14.32, and continued through 2026, reaching 12.76. This indicates a gradual erosion of core profitability over the latter part of the period.
Efficiency (Asset Turnover)
Asset Turnover rose from 1.87 in 2021 to 2.10 in 2022, then decreased to 2.06 in 2023 and 1.99 in 2024. A more pronounced decline occurred in 2025 and 2026, falling to 1.66 and 1.57 respectively. This suggests a decreasing ability to generate sales from its asset base.
Leverage (Financial Leverage)
Financial Leverage exhibited the most significant fluctuations. It increased substantially from 21.39 in 2021 to 48.94 in 2023 and peaked at 73.30 in 2024. Subsequently, it experienced a dramatic decrease to 14.48 in 2025 and further to 8.20 in 2026. This suggests a strategic shift in capital structure, with a significant increase in debt followed by a substantial deleveraging. The changes in Financial Leverage appear to be the primary driver of the ROE fluctuations.
Interest Burden
Interest Burden remained relatively stable, increasing slightly from 0.93 in 2021 to 0.94 in 2022, decreasing to 0.93 in 2023, and then declining further to 0.91 in 2024 and 0.89 in both 2025 and 2026. This indicates consistent management of interest expenses relative to earnings before interest and taxes.

The substantial changes in Financial Leverage appear to be the dominant factor influencing ROE. While profitability and efficiency metrics experienced moderate shifts, the dramatic increase and subsequent decrease in leverage had a disproportionate impact on overall returns. The observed decline in Asset Turnover and EBIT Margin towards the end of the period, coupled with the deleveraging, suggests a potential shift in strategic priorities or a response to changing market conditions.


Two-Component Disaggregation of ROA

Home Depot Inc., decomposition of ROA

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Feb 1, 2026 = ×
Feb 2, 2025 = ×
Jan 28, 2024 = ×
Jan 29, 2023 = ×
Jan 30, 2022 = ×
Jan 31, 2021 = ×

Based on: 10-K (reporting date: 2026-02-01), 10-K (reporting date: 2025-02-02), 10-K (reporting date: 2024-01-28), 10-K (reporting date: 2023-01-29), 10-K (reporting date: 2022-01-30), 10-K (reporting date: 2021-01-31).


The financial performance, as indicated by the two-component disaggregation of Return on Assets (ROA), reveals a shifting trend over the observed period. Initially, strong performance is evident, followed by a gradual decline in profitability and efficiency. The ROA peaked in 2022 before experiencing a consistent decrease through the projected period of 2026.

Net Profit Margin
The Net Profit Margin demonstrated an increase from 9.74% in 2021 to 10.87% in 2022, indicating improved profitability. This margin remained stable in 2023. However, a consistent downward trend is observed from 2023 onwards, decreasing to 9.92% in 2024, 9.28% in 2025, and further to 8.60% in 2026. This suggests increasing cost pressures or decreasing pricing power.
Asset Turnover
Asset Turnover exhibited an upward trend from 1.87 in 2021 to 2.10 in 2022, signifying improved efficiency in utilizing assets to generate sales. While remaining relatively high at 2.06 in 2023, the ratio began a decline, reaching 1.99 in 2024, 1.66 in 2025, and 1.57 in 2026. This indicates a decreasing ability to generate sales from the same level of assets, potentially due to inventory build-up or underutilized capacity.
Return on Assets (ROA)
The ROA followed the combined influence of the Net Profit Margin and Asset Turnover. It rose from 18.23% in 2021 to a peak of 22.86% in 2022, driven by improvements in both profitability and efficiency. The ROA remained strong at 22.38% in 2023, but then began a consistent decline, falling to 19.79% in 2024, 15.40% in 2025, and 13.47% in 2026. This decline is attributable to the concurrent decreases in both Net Profit Margin and Asset Turnover, suggesting a weakening overall financial performance.

The observed trends suggest that while the entity initially benefited from both higher profitability and efficient asset utilization, these advantages have eroded over time. The projected declines in both Net Profit Margin and Asset Turnover warrant further investigation to identify the underlying causes and potential mitigation strategies.


Four-Component Disaggregation of ROA

Home Depot Inc., decomposition of ROA

Microsoft Excel
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
Feb 1, 2026 = × × ×
Feb 2, 2025 = × × ×
Jan 28, 2024 = × × ×
Jan 29, 2023 = × × ×
Jan 30, 2022 = × × ×
Jan 31, 2021 = × × ×

Based on: 10-K (reporting date: 2026-02-01), 10-K (reporting date: 2025-02-02), 10-K (reporting date: 2024-01-28), 10-K (reporting date: 2023-01-29), 10-K (reporting date: 2022-01-30), 10-K (reporting date: 2021-01-31).


The period under review demonstrates fluctuations in key financial ratios impacting overall Return on Assets (ROA). A consistent tax burden is observed across all periods, while the interest burden exhibits a slight, but steady, decline. The most significant drivers of change in ROA appear to be variations in EBIT Margin and Asset Turnover.

Tax Burden
The tax burden remains constant at 0.76 throughout the analyzed timeframe, indicating no discernible change in the company’s effective tax rate.
Interest Burden
The interest burden shows a minor decreasing trend, moving from 0.93 in 2021 to 0.89 in both 2025 and 2026. This suggests a gradual improvement in the company’s ability to cover its interest expense, potentially due to debt reduction or refinancing at lower rates.
EBIT Margin
The EBIT Margin initially increased from 13.87 in 2021 to a peak of 15.31 in 2023, before declining to 12.76 in 2026. This indicates a period of improving profitability followed by a contraction in operating efficiency or increased cost pressures. The decline from 14.32 in 2024 to 12.76 in 2026 is particularly notable.
Asset Turnover
Asset Turnover rose from 1.87 in 2021 to 2.10 in 2022, then decreased to 1.57 in 2026. This suggests an initial improvement in the efficiency with which assets are used to generate sales, followed by a decline in asset utilization. The most substantial decrease occurs between 2024 (1.99) and 2026 (1.57).
Return on Assets (ROA)
ROA mirrored the trends in its component ratios. It increased from 18.23 in 2021 to 22.86 in 2022, then decreased to 13.47 in 2026. The decline in ROA from 19.79 in 2024 to 13.47 in 2026 is directly attributable to the combined effect of decreasing EBIT Margin and Asset Turnover. The consistent tax and slightly decreasing interest burdens partially offset these declines, but were insufficient to maintain ROA levels.

The analysis suggests that while the company maintains a stable tax position and is gradually improving its interest coverage, its profitability and asset utilization are key areas requiring attention. The observed declines in EBIT Margin and Asset Turnover are the primary drivers of the decreasing ROA, indicating potential challenges in maintaining operational efficiency and generating sales from its asset base.


Disaggregation of Net Profit Margin

Home Depot Inc., decomposition of net profit margin ratio

Microsoft Excel
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
Feb 1, 2026 = × ×
Feb 2, 2025 = × ×
Jan 28, 2024 = × ×
Jan 29, 2023 = × ×
Jan 30, 2022 = × ×
Jan 31, 2021 = × ×

Based on: 10-K (reporting date: 2026-02-01), 10-K (reporting date: 2025-02-02), 10-K (reporting date: 2024-01-28), 10-K (reporting date: 2023-01-29), 10-K (reporting date: 2022-01-30), 10-K (reporting date: 2021-01-31).


An examination of the provided financial metrics reveals trends in profitability and associated burdens over a six-year period. The net profit margin demonstrates a general decline, while the components influencing it – EBIT margin, tax burden, and interest burden – exhibit more nuanced movements.

Net Profit Margin
The net profit margin experienced initial growth, increasing from 9.74% in 2021 to 10.87% in both 2022 and 2023. However, a subsequent downward trend is apparent, with the margin decreasing to 9.92% in 2024, 9.28% in 2025, and further to 8.60% in 2026. This suggests increasing pressure on overall profitability despite initial gains.
EBIT Margin
The EBIT margin initially increased from 13.87% in 2021 to 15.27% in 2022 and peaked at 15.31% in 2023. Following this peak, the EBIT margin began to decline, reaching 14.32% in 2024, 13.62% in 2025, and 12.76% in 2026. This decline in operating profitability is a significant contributor to the overall decrease in net profit margin.
Tax Burden
The tax burden remained consistently at 0.76 across the entire period. This indicates that changes in the effective tax rate did not contribute to the observed fluctuations in net profit margin. The stability of this ratio simplifies the analysis by isolating other factors as primary drivers of profitability changes.
Interest Burden
The interest burden exhibited a slight increase from 0.93 in 2021 to 0.94 in 2022, followed by a decrease to 0.93 in 2023. A more pronounced downward trend is observed in the later years, with the burden decreasing to 0.91 in 2024, 0.89 in 2025, and remaining at 0.89 in 2026. While the interest burden decreased, its impact on the net profit margin was not sufficient to offset the decline in the EBIT margin.

In summary, the decline in net profit margin appears primarily driven by the decreasing EBIT margin, despite a relatively stable tax burden and a slight reduction in the interest burden. Further investigation into the factors affecting operating profitability would be warranted.