Stock Analysis on Net

Home Depot Inc. (NYSE:HD)

$24.99

Price to FCFE (P/FCFE)

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

Free Cash Flow to Equity (FCFE)

Home Depot Inc., FCFE calculation

US$ in millions

Microsoft Excel
12 months ended: Feb 2, 2025 Jan 28, 2024 Jan 29, 2023 Jan 30, 2022 Jan 31, 2021 Feb 2, 2020
Net earnings
Net noncash charges
Changes in assets and liabilities, net of acquisition effects
Net cash provided by operating activities
Capital expenditures
Proceeds from (repayments of) short-term debt, net
Proceeds from long-term debt, net of discounts
Repayments of long-term debt
Free cash flow to equity (FCFE)

Based on: 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), 10-K (reporting date: 2020-02-02).


Net Cash Provided by Operating Activities
The net cash provided by operating activities exhibited a fluctuating trend over the examined periods. Starting at $13,723 million in February 2020, the figure increased significantly to $18,839 million in January 2021, marking a strong upward movement. However, this was followed by a decline to $16,571 million in January 2022 and continued decreases to $14,615 million in January 2023. A notable recovery occurred in January 2024 with the cash flow rising sharply to $21,172 million, the highest value in the data set. The most recent figure in February 2025, $19,810 million, reflects a slight decrease compared to the previous year but remains elevated relative to most earlier periods.
Free Cash Flow to Equity (FCFE)
The FCFE similarly showed variability with an overall positive trajectory across the span of years. Beginning at $13,030 million in February 2020, the cash flow increased markedly to a peak of $20,463 million in January 2021. A subsequent decline followed, reaching $16,487 million in January 2022 and further dropping to $14,912 million in January 2023. In the next year, January 2024, the FCFE rebounded to $18,670 million. The most recent measurement in February 2025 showed a substantial increase to $25,115 million, representing the highest recorded value in the dataset, and a significant rise compared to the previous periods.
Overall Analysis
Both net cash provided by operations and free cash flow to equity demonstrated a cyclical pattern with periods of growth followed by declines and subsequent recoveries. The data suggests overall improvement in free cash flow to equity in the most recent years, with a particularly strong increase noted in the last reporting period. This could indicate effective capital management and potentially improved profitability or operational efficiency. The rise in free cash flow to equity toward the end of the series also suggests enhanced capacity for distributed returns to equity holders or reinvestment, despite the moderate dip in operating cash flow in the final period.

Price to FCFE Ratio, Current

Home Depot Inc., current P/FCFE calculation, comparison to benchmarks

Microsoft Excel
No. shares of common stock outstanding
Selected Financial Data (US$)
Free cash flow to equity (FCFE) (in millions)
FCFE per share
Current share price (P)
Valuation Ratio
P/FCFE
Benchmarks
P/FCFE, Competitors1
Amazon.com Inc.
Lowe’s Cos. Inc.
TJX Cos. Inc.
P/FCFE, Sector
Consumer Discretionary Distribution & Retail
P/FCFE, Industry
Consumer Discretionary

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

1 Click competitor name to see calculations.

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


Price to FCFE Ratio, Historical

Home Depot Inc., historical P/FCFE calculation, comparison to benchmarks

Microsoft Excel
Feb 2, 2025 Jan 28, 2024 Jan 29, 2023 Jan 30, 2022 Jan 31, 2021 Feb 2, 2020
No. shares of common stock outstanding1
Selected Financial Data (US$)
Free cash flow to equity (FCFE) (in millions)2
FCFE per share3
Share price1, 4
Valuation Ratio
P/FCFE5
Benchmarks
P/FCFE, Competitors6
Amazon.com Inc.
Lowe’s Cos. Inc.
TJX Cos. Inc.
P/FCFE, Sector
Consumer Discretionary Distribution & Retail
P/FCFE, Industry
Consumer Discretionary

Based on: 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), 10-K (reporting date: 2020-02-02).

1 Data adjusted for splits and stock dividends.

2 See details »

3 2025 Calculation
FCFE per share = FCFE ÷ No. shares of common stock outstanding
= ÷ =

4 Closing price as at the filing date of Home Depot Inc. Annual Report.

5 2025 Calculation
P/FCFE = Share price ÷ FCFE per share
= ÷ =

6 Click competitor name to see calculations.


Share Price Trend
The share price exhibited a significant upward trend from $181.76 in early 2020 to a peak of $378.99 in early 2024. However, in the subsequent year, the share price declined to $351.15, indicating some volatility but still maintaining a level considerably higher than the starting point.
Free Cash Flow to Equity (FCFE) per Share
FCFE per share showed overall growth over the given period, starting at $12.12 in 2020 and ending at $25.27 in 2025. Despite fluctuations, including a noticeable dip in 2022 and 2023, the value rebounded strongly in the last year, suggesting improved cash generation capacity available to equity holders.
Price-to-FCFE (P/FCFE) Ratio
The P/FCFE ratio began at 14.99 in 2020, increased steadily to a maximum of 20.12 in 2024, then declined sharply to 13.9 in 2025. This pattern indicates changing market valuations relative to cash flow per share, with the company being more expensively valued around 2023-2024 and then becoming more attractively priced relative to cash flow in 2025.
Overall Insights
The financial data suggests that while the company’s share price and underlying free cash flows have generally increased over the six-year period, market valuations have fluctuated. The recent decrease in the price-to-FCFE ratio combined with a rise in FCFE per share could imply improved value for investors in the latest period. The decline in share price after 2024 might reflect market adjustments or external factors affecting investor sentiment, despite solid cash flow fundamentals.