Want to Calculate Fair Value?
Enter Stock | Calculate Fair Value

Stock: HD
Book Value Per Share: $8.0
EPS: $14.98
Diluted EPS TTM: $14.72
Dividend Per Share: 6.8
Dividend Yield: 1.92 %
Dividend Payout Ratio: 45%
Price To Sales Ratio TTM: 2.247
Price To Book Ratio: 46.02
PEG Ratio: 4.308
EV To EBITDA: 16.6
P/E Ratio: 25.0
Forward P/E Ratio: 24.57
Ex Dividend Date: 2025-06-05
Dividend Date: 2025-06-18
Current Price: $354.66
Previous Close: $363.16
52 Week Low: $318.27
52 Week High: $434.31
Earning Date (within 30 days): N/A
50 Day MA: $361.57
200 Day MA: $387.43
Link to Yahoo (Financial): HD
 
* Note: Prices are in Million (M) USD.
Description:
Home Depot Inc (HD) ▼
The Home Depot, Inc., commonly known as Home Depot, is the largest home improvement retailer in the United States, supplying tools, construction products, and services. The company is headquartered in incorporated Cobb County, Georgia, with an Atlanta mailing address.
These criteria used Company’s Cash, EBITDA and Debt balance to determines its fair value:
Cash : $1,659 M
Debt : $48,485 M
EBITDA : $25,498 M
Net Debt (Debt - Cash): $46,826 M

Since Net Debt is covered by EBITDA within 2 years, 2 points assigned.
This criteria used industry in which company operates:
Sector: Consumer Cyclical
Industry: Home Improvement Stores

Based on industry, 3 points assigned.
This criteria used Company’s Price To Earning (P/E) Ratio to determines its fair value:
Forward PE Ratio: 23.68

Since Forward PE Ratio is between 20 - 25, 2 points assigned.
This criteria used Company's ability to convert Sales into free cash flow to determine fair value:
Average Free Cash Flow: $8,415 M
Average Revenue: $100,880 M
Free Cash Flow to Revenue : 8 %

Since Free Cash Flow (FCF) to Revenue percentage is less than 15, 1 point assigned.
This criteria used company's growth potential to calculate its fair value:
Latest Revenue (2025-01-31): $159,514 M
Revenue 4 Years Ago (2021-01-31): $132,110 M
Last 5 Years Average Revenue Growth: 4%

Since Revenue Growth is between 0 - 5, 1 point assigned.
This criteria used Company's ability to buy back its own share:
Latest Share Count (2025-01-31): $993 M
Share Count 5 Years Ago (2021-01-31): $1,078 M

Company is buying back its own shares, 3 points assigned.
This criteria used Company's dividend payout ratio to determine its fair value:
Earnings Per Share (EPS): $14.98
Dividend Per Share (DPS): $7
Payout Ratio: 45%
Dividend Yield: 3%

Since company Payout Ratio is less than 50, 2 points assigned.

Since Dividend Yield is greater than 2, 2 points assigned.
This criteria used Company's Return On Equity (ROE%) to determine its fair value:
Average ROE: 254%

Since Average ROE is greater than 20, 5 points assigned.
This criteria used Company's current price to its 52 week low price to determines its fair value:
Current Price: $355
52-Week Low: $318
Threshold Price (15% Above 52-Week Low): $366

Since Current price is within 15% threshold, 5 points assigned.
This criteria used Company's Market Cap to determines its fair value:
Market Capitalization: $366,094 M

Since Market Cap is between 100B - 500B, 3 points assigned.
% Exposure to Total Portfolio
Based on the calculated score, we recommend do not exceed 4% exposure of Total Portfolio.
Value-Trade has assigned 29 points to above Home Depot Inc (HD) stock.
Twenty Years Avg PE 22, Fair Value PE 15, Industry Based PE is 20 and Growth based PE is 10. Based on these all values average assigned is 16.75.
Value-Trades has assined P/E value 16.75. Since current year earning per share is $14.98.
The fair value of Home Depot Inc (HD) stock should be (16.75 x $14.98) = $250.92

Share this valuation:


Advertisement