Stock Analysis on Net

Home Depot Inc. (NYSE:HD)

$24.99

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

Home Depot Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = ROA × Financial Leverage
May 3, 2026 = ×
Feb 1, 2026 = ×
Nov 2, 2025 = ×
Aug 3, 2025 = ×
May 4, 2025 = ×
Feb 2, 2025 = ×
Oct 27, 2024 = ×
Jul 28, 2024 = ×
Apr 28, 2024 = ×
Jan 28, 2024 = ×
Oct 29, 2023 = ×
Jul 30, 2023 = ×
Apr 30, 2023 = ×
Jan 29, 2023 = ×
Oct 30, 2022 = ×
Jul 31, 2022 = ×
May 1, 2022 = ×
Jan 30, 2022 = ×
Oct 31, 2021 = ×
Aug 1, 2021 = ×
May 2, 2021 = ×

Based on: 10-Q (reporting date: 2026-05-03), 10-K (reporting date: 2026-02-01), 10-Q (reporting date: 2025-11-02), 10-Q (reporting date: 2025-08-03), 10-Q (reporting date: 2025-05-04), 10-K (reporting date: 2025-02-02), 10-Q (reporting date: 2024-10-27), 10-Q (reporting date: 2024-07-28), 10-Q (reporting date: 2024-04-28), 10-K (reporting date: 2024-01-28), 10-Q (reporting date: 2023-10-29), 10-Q (reporting date: 2023-07-30), 10-Q (reporting date: 2023-04-30), 10-K (reporting date: 2023-01-29), 10-Q (reporting date: 2022-10-30), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-05-01), 10-K (reporting date: 2022-01-30), 10-Q (reporting date: 2021-10-31), 10-Q (reporting date: 2021-08-01), 10-Q (reporting date: 2021-05-02).


The overall trajectory of Return on Equity (ROE) exhibits a significant downward trend over the analyzed period, driven by a dual contraction in both asset productivity and financial leverage. While ROE reached extreme peaks in 2022 and 2023, it has since declined substantially, reflecting a fundamental shift in the company's capital structure and operational efficiency.

Return on Assets (ROA)
Asset efficiency remained relatively stable and strong from May 2021 through late 2023, fluctuating within a narrow band between 20.35% and 22.86%. However, a consistent decline began in early 2024, with ROA dropping from 19.79% in January 2024 to 12.99% by May 2026. This indicates a steady erosion in the ability of the company's assets to generate net earnings over the latter half of the period.
Financial Leverage
The financial leverage ratio is characterized by extreme volatility followed by a sharp, sustained reduction. Significant spikes occurred in July 2022 (319.94) and April 2023 (211.01), suggesting periods of aggressive debt utilization or a significant reduction in equity. From October 2023 onward, a systematic deleveraging process is evident, with the ratio falling from 73.30 to a period low of 7.78 by May 2026. This represents a transition toward a much more conservative capital structure.
Return on Equity (ROE)
ROE fluctuated violently in the first half of the analysis, reaching an apex of 7,124.47% in July 2022, a result of the interaction between stable ROA and peaked financial leverage. As the company aggressively reduced its leverage and experienced declining asset returns, ROE entered a steep descent. By May 2026, ROE settled at 100.99%, demonstrating that the collapse in the leverage multiplier had a more profound impact on equity returns than the decline in operational profitability.

Three-Component Disaggregation of ROE

Home Depot Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
May 3, 2026 = × ×
Feb 1, 2026 = × ×
Nov 2, 2025 = × ×
Aug 3, 2025 = × ×
May 4, 2025 = × ×
Feb 2, 2025 = × ×
Oct 27, 2024 = × ×
Jul 28, 2024 = × ×
Apr 28, 2024 = × ×
Jan 28, 2024 = × ×
Oct 29, 2023 = × ×
Jul 30, 2023 = × ×
Apr 30, 2023 = × ×
Jan 29, 2023 = × ×
Oct 30, 2022 = × ×
Jul 31, 2022 = × ×
May 1, 2022 = × ×
Jan 30, 2022 = × ×
Oct 31, 2021 = × ×
Aug 1, 2021 = × ×
May 2, 2021 = × ×

Based on: 10-Q (reporting date: 2026-05-03), 10-K (reporting date: 2026-02-01), 10-Q (reporting date: 2025-11-02), 10-Q (reporting date: 2025-08-03), 10-Q (reporting date: 2025-05-04), 10-K (reporting date: 2025-02-02), 10-Q (reporting date: 2024-10-27), 10-Q (reporting date: 2024-07-28), 10-Q (reporting date: 2024-04-28), 10-K (reporting date: 2024-01-28), 10-Q (reporting date: 2023-10-29), 10-Q (reporting date: 2023-07-30), 10-Q (reporting date: 2023-04-30), 10-K (reporting date: 2023-01-29), 10-Q (reporting date: 2022-10-30), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-05-01), 10-K (reporting date: 2022-01-30), 10-Q (reporting date: 2021-10-31), 10-Q (reporting date: 2021-08-01), 10-Q (reporting date: 2021-05-02).


The Return on Equity (ROE) exhibits extreme volatility followed by a sustained and significant downward trajectory over the analyzed period. While the metric reached exceptional peaks in 2022 and 2023, it has steadily contracted to 100.99% by May 2026. This decline is the result of a simultaneous reduction in profit margins, asset efficiency, and a dramatic contraction in financial leverage.

Net Profit Margin
A gradual and persistent contraction in profitability is observed. The margin remained relatively stable, peaking at 10.88% between May 2021 and January 2023. From April 2023 onward, a consistent decline began, with the margin falling to 8.41% by May 2026, indicating a steady compression of net income relative to revenue.
Asset Turnover
Operational efficiency showed stability for the first several years, maintaining a ratio around 2.0. However, a marked decrease occurred starting in April 2024, where the ratio dropped to 1.57 and remained within the 1.5 to 1.6 range through May 2026. This trend suggests a diminished capacity to generate sales from the existing asset base.
Financial Leverage
Financial leverage acted as the primary driver of the extreme fluctuations in ROE. The ratio experienced severe volatility, including a peak of 319.94 in July 2022 and 211.01 in April 2023. Following these spikes, a decisive deleveraging trend emerged; the ratio fell from 43.53 in January 2024 to 7.78 by May 2026, representing a fundamental shift toward a less leveraged capital structure.

The overall decline in ROE is characterized by the convergence of all three DuPont components. The extraordinary ROE figures observed in previous years were primarily supported by extreme financial leverage rather than operational performance. As the company aggressively reduced its leverage while simultaneously experiencing margin erosion and lower asset turnover, the ROE normalized significantly.


Five-Component Disaggregation of ROE

Home Depot Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Financial Leverage
May 3, 2026 = × × × ×
Feb 1, 2026 = × × × ×
Nov 2, 2025 = × × × ×
Aug 3, 2025 = × × × ×
May 4, 2025 = × × × ×
Feb 2, 2025 = × × × ×
Oct 27, 2024 = × × × ×
Jul 28, 2024 = × × × ×
Apr 28, 2024 = × × × ×
Jan 28, 2024 = × × × ×
Oct 29, 2023 = × × × ×
Jul 30, 2023 = × × × ×
Apr 30, 2023 = × × × ×
Jan 29, 2023 = × × × ×
Oct 30, 2022 = × × × ×
Jul 31, 2022 = × × × ×
May 1, 2022 = × × × ×
Jan 30, 2022 = × × × ×
Oct 31, 2021 = × × × ×
Aug 1, 2021 = × × × ×
May 2, 2021 = × × × ×

Based on: 10-Q (reporting date: 2026-05-03), 10-K (reporting date: 2026-02-01), 10-Q (reporting date: 2025-11-02), 10-Q (reporting date: 2025-08-03), 10-Q (reporting date: 2025-05-04), 10-K (reporting date: 2025-02-02), 10-Q (reporting date: 2024-10-27), 10-Q (reporting date: 2024-07-28), 10-Q (reporting date: 2024-04-28), 10-K (reporting date: 2024-01-28), 10-Q (reporting date: 2023-10-29), 10-Q (reporting date: 2023-07-30), 10-Q (reporting date: 2023-04-30), 10-K (reporting date: 2023-01-29), 10-Q (reporting date: 2022-10-30), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-05-01), 10-K (reporting date: 2022-01-30), 10-Q (reporting date: 2021-10-31), 10-Q (reporting date: 2021-08-01), 10-Q (reporting date: 2021-05-02).


The Return on Equity (ROE) exhibits extreme volatility in the early periods, reaching peaks above 7,000%, before entering a consistent and significant downward trajectory. This decline is the result of simultaneous contractions across operating efficiency, asset utilization, and financial leverage.

Tax and Interest Burden
The tax burden remains completely static at 0.76 throughout the entire period, indicating a constant effective tax rate. The interest burden shows a gradual, marginal decline from 0.93 to 0.88, suggesting a slight increase in the proportion of operating profit consumed by interest expenses over time.
Operating Profitability and Efficiency
The EBIT margin peaked at 15.35% in October 2022 before initiating a steady decline to 12.51% by May 2026. This contraction reflects a narrowing of operating margins. Similarly, asset turnover remained stable around 2.0 until early 2023, followed by a notable drop to a range between 1.54 and 1.66 starting in April 2024, indicating a reduction in the efficiency of asset utilization to generate revenue.
Financial Leverage and Capital Structure
Financial leverage is the most volatile component and the primary driver of the ROE fluctuations. After experiencing extreme spikes—most notably in July 2022—a systemic deleveraging process began. Leverage dropped precipitously from a peak of 319.94 down to 7.78 by May 2026. This aggressive reduction in leverage has fundamentally shifted the ROE from hyper-inflated levels to a more stabilized, albeit significantly lower, percentage.

In summary, the collapse in ROE is primarily attributed to a massive reduction in financial leverage, which amplified the negative impact of declining EBIT margins and weakened asset turnover. While the early periods were characterized by extreme leverage-driven returns, the later periods reflect a transition toward a more conservative capital structure and diminished operational efficiency.


Two-Component Disaggregation of ROA

Home Depot Inc., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
May 3, 2026 = ×
Feb 1, 2026 = ×
Nov 2, 2025 = ×
Aug 3, 2025 = ×
May 4, 2025 = ×
Feb 2, 2025 = ×
Oct 27, 2024 = ×
Jul 28, 2024 = ×
Apr 28, 2024 = ×
Jan 28, 2024 = ×
Oct 29, 2023 = ×
Jul 30, 2023 = ×
Apr 30, 2023 = ×
Jan 29, 2023 = ×
Oct 30, 2022 = ×
Jul 31, 2022 = ×
May 1, 2022 = ×
Jan 30, 2022 = ×
Oct 31, 2021 = ×
Aug 1, 2021 = ×
May 2, 2021 = ×

Based on: 10-Q (reporting date: 2026-05-03), 10-K (reporting date: 2026-02-01), 10-Q (reporting date: 2025-11-02), 10-Q (reporting date: 2025-08-03), 10-Q (reporting date: 2025-05-04), 10-K (reporting date: 2025-02-02), 10-Q (reporting date: 2024-10-27), 10-Q (reporting date: 2024-07-28), 10-Q (reporting date: 2024-04-28), 10-K (reporting date: 2024-01-28), 10-Q (reporting date: 2023-10-29), 10-Q (reporting date: 2023-07-30), 10-Q (reporting date: 2023-04-30), 10-K (reporting date: 2023-01-29), 10-Q (reporting date: 2022-10-30), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-05-01), 10-K (reporting date: 2022-01-30), 10-Q (reporting date: 2021-10-31), 10-Q (reporting date: 2021-08-01), 10-Q (reporting date: 2021-05-02).


The analysis of the two-component disaggregation of Return on Assets (ROA) reveals a cyclical trajectory, characterized by an initial period of expansion followed by a sustained and significant contraction in profitability and operational efficiency.

Net Profit Margin
A period of marginal growth is observed from May 2021 through January 2022, where the margin increased from 10.45% to a peak of 10.87%. This level remained remarkably stable through January 2023. However, starting in April 2023, a consistent downward trend emerged, with the margin eroding steadily to 8.41% by May 2026. This suggests a gradual compression of profitability per dollar of revenue over the latter half of the period.
Asset Turnover
Asset utilization remained robust between May 2021 and January 2023, fluctuating within a tight range between 1.95 and 2.10. A transition occurred in early 2024, marked by a sharp decline from 1.92 in January 2024 to 1.57 in July 2024. Following this drop, the ratio stabilized at a lower plateau, ending the period at 1.54 in May 2026. This indicates a reduction in the efficiency with which assets are being deployed to generate sales.
Return on Assets (ROA)
The overall ROA reflects the combined impact of the margin and turnover trends. ROA peaked in January 2022 at 22.86%, supported by simultaneous strengths in both profit margins and asset turnover. A decelerating trend began in 2023, accelerating into a sharp contraction between April 2024 (18.77%) and July 2024 (15.25%), which correlates directly with the decline in asset turnover. The period concludes with ROA reaching its lowest point of 12.99% in May 2026.

The decline in ROA is the result of a dual deterioration in financial performance. While the steady erosion of the net profit margin contributed to the downward pressure, the more abrupt decrease in asset turnover served as the primary catalyst for the significant drop in asset productivity observed throughout 2024 and 2025.


Four-Component Disaggregation of ROA

Home Depot Inc., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
May 3, 2026 = × × ×
Feb 1, 2026 = × × ×
Nov 2, 2025 = × × ×
Aug 3, 2025 = × × ×
May 4, 2025 = × × ×
Feb 2, 2025 = × × ×
Oct 27, 2024 = × × ×
Jul 28, 2024 = × × ×
Apr 28, 2024 = × × ×
Jan 28, 2024 = × × ×
Oct 29, 2023 = × × ×
Jul 30, 2023 = × × ×
Apr 30, 2023 = × × ×
Jan 29, 2023 = × × ×
Oct 30, 2022 = × × ×
Jul 31, 2022 = × × ×
May 1, 2022 = × × ×
Jan 30, 2022 = × × ×
Oct 31, 2021 = × × ×
Aug 1, 2021 = × × ×
May 2, 2021 = × × ×

Based on: 10-Q (reporting date: 2026-05-03), 10-K (reporting date: 2026-02-01), 10-Q (reporting date: 2025-11-02), 10-Q (reporting date: 2025-08-03), 10-Q (reporting date: 2025-05-04), 10-K (reporting date: 2025-02-02), 10-Q (reporting date: 2024-10-27), 10-Q (reporting date: 2024-07-28), 10-Q (reporting date: 2024-04-28), 10-K (reporting date: 2024-01-28), 10-Q (reporting date: 2023-10-29), 10-Q (reporting date: 2023-07-30), 10-Q (reporting date: 2023-04-30), 10-K (reporting date: 2023-01-29), 10-Q (reporting date: 2022-10-30), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-05-01), 10-K (reporting date: 2022-01-30), 10-Q (reporting date: 2021-10-31), 10-Q (reporting date: 2021-08-01), 10-Q (reporting date: 2021-05-02).


The Return on Assets (ROA) exhibited a cyclical trajectory over the analyzed period, peaking in early 2022 before entering a sustained period of decline. After reaching a maximum of 22.86% on January 30, 2022, the ROA remained relatively stable above 20% until late 2023, after which a significant downward trend emerged, concluding at 12.99% by May 3, 2026.

Operational Profitability
The EBIT Margin demonstrated strength through 2021 and 2022, peaking at 15.35% in October 2022. However, a consistent contraction in operating margins is observed from early 2023 onward. This margin compression accelerated throughout 2024 and 2025, ultimately falling to 12.51% by May 2026, indicating a reduction in operating efficiency or increased cost pressures over time.
Asset Utilization
Asset Turnover remained robust and stable between 1.95 and 2.10 from May 2021 through January 2023. A notable shift occurred starting in April 2024, where the ratio dropped sharply to 1.57 and remained depressed in the 1.54 to 1.66 range for the remainder of the period. This decline suggests a decrease in the company's ability to generate revenue relative to its asset base.
Financial and Tax Burdens
The Tax Burden remained completely static at 0.76 throughout the entire duration, exerting no influence on the volatility of the ROA. The Interest Burden showed a gradual, slight decline from a peak of 0.94 in 2021-2022 to 0.88 by May 2026. This downward movement indicates a marginal increase in the proportion of operating profit consumed by interest expenses.
Primary Drivers of ROA Decline
The overall reduction in ROA is primarily attributed to the simultaneous deterioration of the EBIT Margin and Asset Turnover. While the interest burden provided a minor negative contribution, the loss of operational margin and the sharp decrease in asset efficiency since early 2024 are the dominant factors driving the decline in overall asset productivity.

Disaggregation of Net Profit Margin

Home Depot Inc., decomposition of net profit margin ratio (quarterly data)

Microsoft Excel
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
May 3, 2026 = × ×
Feb 1, 2026 = × ×
Nov 2, 2025 = × ×
Aug 3, 2025 = × ×
May 4, 2025 = × ×
Feb 2, 2025 = × ×
Oct 27, 2024 = × ×
Jul 28, 2024 = × ×
Apr 28, 2024 = × ×
Jan 28, 2024 = × ×
Oct 29, 2023 = × ×
Jul 30, 2023 = × ×
Apr 30, 2023 = × ×
Jan 29, 2023 = × ×
Oct 30, 2022 = × ×
Jul 31, 2022 = × ×
May 1, 2022 = × ×
Jan 30, 2022 = × ×
Oct 31, 2021 = × ×
Aug 1, 2021 = × ×
May 2, 2021 = × ×

Based on: 10-Q (reporting date: 2026-05-03), 10-K (reporting date: 2026-02-01), 10-Q (reporting date: 2025-11-02), 10-Q (reporting date: 2025-08-03), 10-Q (reporting date: 2025-05-04), 10-K (reporting date: 2025-02-02), 10-Q (reporting date: 2024-10-27), 10-Q (reporting date: 2024-07-28), 10-Q (reporting date: 2024-04-28), 10-K (reporting date: 2024-01-28), 10-Q (reporting date: 2023-10-29), 10-Q (reporting date: 2023-07-30), 10-Q (reporting date: 2023-04-30), 10-K (reporting date: 2023-01-29), 10-Q (reporting date: 2022-10-30), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-05-01), 10-K (reporting date: 2022-01-30), 10-Q (reporting date: 2021-10-31), 10-Q (reporting date: 2021-08-01), 10-Q (reporting date: 2021-05-02).


The net profit margin exhibits a trajectory of initial stability and modest growth followed by a sustained period of contraction. From May 2021 to January 2023, the margin remained relatively stable, peaking at 10.88% in July 2022. However, a consistent downward trend emerged thereafter, with the margin declining to 8.41% by May 2026.

Tax Burden
The tax burden remained constant at a ratio of 0.76 throughout the entire observed period. This indicates that the effective tax rate had no impact on the volatility or the overall decline of the net profit margin.
Interest Burden
A gradual decline in the interest burden is observed, moving from a peak of 0.94 in 2021 to 0.88 by May 2026. This downward trajectory suggests an increasing proportion of operating income is being consumed by interest expenses, thereby exerting incremental downward pressure on the bottom line.
EBIT Margin
The EBIT margin initially trended upward, reaching a peak of 15.35% in October 2022. Subsequent to this peak, a persistent and steady decline is evident, with the margin falling to 12.51% by May 2026. This contraction in operating profitability serves as the primary driver for the overall reduction in the net profit margin.
Net Profit Margin Synthesis
The erosion of the net profit margin is the result of a compounding effect between deteriorating operating efficiency and rising financing costs. While the tax burden remained neutral, the simultaneous decline in both the EBIT margin and the interest burden accelerated the margin compression observed from 2023 through the first half of 2026.