Stock Analysis on Net

Home Depot Inc. (NYSE:HD)

Enterprise Value to FCFF (EV/FCFF) 

Microsoft Excel

Free Cash Flow to The Firm (FCFF)

Home Depot Inc., FCFF calculation

US$ in millions

Microsoft Excel
12 months ended: Feb 1, 2026 Feb 2, 2025 Jan 28, 2024 Jan 29, 2023 Jan 30, 2022 Jan 31, 2021
Net earnings 14,156 14,806 15,143 17,105 16,433 12,866
Net noncash charges 4,643 4,203 3,627 3,341 3,261 2,829
Changes in assets and liabilities, net of acquisition effects (2,474) 801 2,402 (5,831) (3,123) 3,144
Net cash provided by operating activities 16,325 19,810 21,172 14,615 16,571 18,839
Cash paid for interest, net of interest capitalized, net of tax1 1,830 1,678 1,375 1,103 959 941
Capital expenditures (3,679) (3,485) (3,226) (3,119) (2,566) (2,463)
Non-cash capital expenditures (272) (250) (364) (351) (421) (274)
Free cash flow to the firm (FCFF) 14,204 17,753 18,957 12,248 14,543 17,043

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 information reveals trends in net cash provided by operating activities and free cash flow to the firm (FCFF) over a six-year period. Both metrics experienced fluctuations during the observed timeframe.

Net Cash from Operations
Net cash provided by operating activities decreased from US$18,839 million in 2021 to US$16,571 million in 2022, representing a decline of approximately 13.6%. A further decrease was noted in 2023, falling to US$14,615 million. However, a substantial increase occurred in 2024, reaching US$21,172 million. This upward momentum continued into 2025 with a value of US$19,810 million, before decreasing again to US$16,325 million in 2026.
Free Cash Flow to the Firm (FCFF)
FCFF mirrored the trend observed in net cash from operations, though the magnitude of change differed. FCFF decreased from US$17,043 million in 2021 to US$14,543 million in 2022, a decrease of roughly 14.7%. The decline continued in 2023, reaching US$12,248 million. A significant recovery was observed in 2024, with FCFF increasing to US$18,957 million. This positive trend continued into 2025, with FCFF at US$17,753 million, before decreasing to US$14,204 million in 2026.

The correlation between net cash from operations and FCFF is strong, suggesting that changes in operating cash flow directly influence the amount of free cash flow available to the firm. The substantial increases observed in both metrics in 2024 indicate a period of strong operational performance. The subsequent declines in 2025 and 2026 warrant further investigation to determine the underlying causes and potential implications for future financial performance.

Comparative Analysis
The difference between net cash from operations and FCFF remained relatively consistent throughout the period, suggesting that the factors impacting the difference, such as capital expenditures, were stable. The largest absolute difference between the two metrics occurred in 2024, coinciding with the peak in net cash from operations and FCFF.

Overall, the period demonstrates cyclical behavior in both operating cash flow and FCFF, with peaks in 2021 and 2024, and troughs in 2023 and 2026. Continued monitoring of these trends is recommended to assess the firm’s long-term financial health and sustainability.

AI Ask an analyst for more


Interest Paid, Net of Tax

Home Depot Inc., interest paid, net of tax calculation

US$ in millions

Microsoft Excel
12 months ended: Feb 1, 2026 Feb 2, 2025 Jan 28, 2024 Jan 29, 2023 Jan 30, 2022 Jan 31, 2021
Effective Income Tax Rate (EITR)
EITR1 23.90% 23.70% 24.00% 23.90% 24.40% 24.20%
Interest Paid, Net of Tax
Cash paid for interest, net of interest capitalized, before tax 2,405 2,199 1,809 1,449 1,269 1,241
Less: Cash paid for interest, net of interest capitalized, tax2 575 521 434 346 310 300
Cash paid for interest, net of interest capitalized, net of tax 1,830 1,678 1,375 1,103 959 941

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).

1 See details »

2 2026 Calculation
Cash paid for interest, net of interest capitalized, tax = Cash paid for interest, net of interest capitalized × EITR
= 2,405 × 23.90% = 575


The analysis reveals a consistent upward trend in cash paid for interest, net of interest capitalized, net of tax, over the observed period. Simultaneously, the effective income tax rate demonstrates relative stability with minor fluctuations.

Cash Paid for Interest
Cash paid for interest, net of interest capitalized, net of tax, increased steadily from US$941 million in January 2021 to US$1,830 million in February 2026. This represents a cumulative increase of approximately 94.5% over the six-year period. The growth rate appears to be accelerating, with larger absolute increases observed in more recent years. Specifically, the increase from January 2023 to February 2025 was US$575 million, while the increase from January 2022 to January 2023 was US$144 million. This suggests a potential rise in debt levels, increased borrowing costs, or a combination of both.
Effective Income Tax Rate
The effective income tax rate exhibited minimal variation throughout the period, fluctuating between 23.70% and 24.40%. The rate began at 24.20% in January 2021, decreased to 23.90% in January 2023, and then rose slightly to 23.90% in February 2026. These fluctuations are relatively small and do not indicate a significant change in the company’s tax position or applicable tax laws.

The divergence between the increasing interest expense and the stable effective income tax rate suggests that changes in financing activities are the primary driver of the observed trends. Further investigation into the company’s debt structure and borrowing activities would be necessary to fully understand the reasons behind the escalating interest payments.

AI Ask an analyst for more


Enterprise Value to FCFF Ratio, Current

Home Depot Inc., current EV/FCFF calculation, comparison to benchmarks

Microsoft Excel
Selected Financial Data (US$ in millions)
Enterprise value (EV) 373,854
Free cash flow to the firm (FCFF) 14,204
Valuation Ratio
EV/FCFF 26.32
Benchmarks
EV/FCFF, Competitors1
Amazon.com Inc. 219.52
Lowe’s Cos. Inc. 18.06
TJX Cos. Inc. 39.87
EV/FCFF, Sector
Consumer Discretionary Distribution & Retail 70.21
EV/FCFF, Industry
Consumer Discretionary 45.27

Based on: 10-K (reporting date: 2026-02-01).

1 Click competitor name to see calculations.

If the company EV/FCFF is lower then the EV/FCFF of benchmark then company is relatively undervalued.
Otherwise, if the company EV/FCFF is higher then the EV/FCFF of benchmark then company is relatively overvalued.


Enterprise Value to FCFF Ratio, Historical

Home Depot Inc., historical EV/FCFF calculation, comparison to benchmarks

Microsoft Excel
Feb 1, 2026 Feb 2, 2025 Jan 28, 2024 Jan 29, 2023 Jan 30, 2022 Jan 31, 2021
Selected Financial Data (US$ in millions)
Enterprise value (EV)1 383,993 400,778 415,936 332,713 365,367 344,655
Free cash flow to the firm (FCFF)2 14,204 17,753 18,957 12,248 14,543 17,043
Valuation Ratio
EV/FCFF3 27.03 22.58 21.94 27.17 25.12 20.22
Benchmarks
EV/FCFF, Competitors4
Amazon.com Inc. 224.92 60.78 45.92
Lowe’s Cos. Inc. 18.55 24.69 19.56 19.56 14.88
TJX Cos. Inc. 32.22 24.44 31.93 33.03 18.30
EV/FCFF, Sector
Consumer Discretionary Distribution & Retail 71.55 44.15 38.32 111.04 130.00
EV/FCFF, Industry
Consumer Discretionary 107.94 41.98 33.07 51.09 60.31

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).

1 See details »

2 See details »

3 2026 Calculation
EV/FCFF = EV ÷ FCFF
= 383,993 ÷ 14,204 = 27.03

4 Click competitor name to see calculations.


The Enterprise Value to Free Cash Flow to the Firm (EV/FCFF) ratio exhibits fluctuations over the observed period. Initially, the ratio increased from 20.22 in 2021 to 27.17 in 2023, before decreasing to 21.94 in 2024. Subsequent projections indicate a rise to 22.58 in 2025, followed by an increase to 27.03 in 2026.

Enterprise Value (EV)
Enterprise Value demonstrated an initial increase from US$344,655 million in 2021 to US$365,367 million in 2022. A subsequent decline to US$332,713 million was observed in 2023, followed by a substantial increase to US$415,936 million in 2024. Projections suggest a decrease to US$400,778 million in 2025 and a further decrease to US$383,993 million in 2026.
Free Cash Flow to the Firm (FCFF)
Free Cash Flow to the Firm decreased from US$17,043 million in 2021 to US$14,543 million in 2022, and continued to decline to US$12,248 million in 2023. An increase to US$18,957 million was recorded in 2024. Projections indicate a slight decrease to US$17,753 million in 2025, followed by a further decrease to US$14,204 million in 2026.
EV/FCFF Ratio – Trend Analysis
The initial increase in the EV/FCFF ratio between 2021 and 2023 suggests that the enterprise value was growing at a faster rate than the free cash flow generated by the firm. The subsequent decrease in 2024 indicates that free cash flow growth began to outpace the growth in enterprise value. The projected increases in 2025 and 2026 suggest a potential reversion to a period where enterprise value growth exceeds free cash flow growth, although the ratio remains within a relatively narrow range compared to the values observed in 2022 and 2023.

The interplay between Enterprise Value and Free Cash Flow to the Firm results in a dynamic EV/FCFF ratio. The projected values for 2025 and 2026 suggest a potential shift in the relationship between these two financial metrics.

AI Ask an analyst for more