Edition:
United Kingdom

Home Depot Inc (HD.N)

HD.N on New York Stock Exchange

186.67USD
23 May 2018
Change (% chg)

$-0.20 (-0.11%)
Prev Close
$186.87
Open
$186.97
Day's High
$187.24
Day's Low
$184.99
Volume
1,901,378
Avg. Vol
1,363,602
52-wk High
$207.60
52-wk Low
$144.26

Revenue & Earnings Per Share

    Revenue* Earnings Per Share**
FY 2019 Apr 24,947.00 2.076
FY 2018 Jan '18 23,883.00 1.869
Oct 25,026.00 1.844
Jul 28,108.00 2.247
Apr 23,887.00 1.673
FY 2017 Jan '17 22,207.00 1.441
Oct 23,154.00 1.602
Jul 26,472.00 1.969
May 22,762.00 1.440
FY 2016 Jan '16 20,980.00 1.166
Nov 21,819.00 1.354
Aug 24,829.00 1.733
May 20,891.00 1.210
 
*Note: Units in Millions ofU.S. Dollars
**Note: Units in U.S. Dollars

Consensus Estimates Analysis

  # of Estimates Mean High Low 1 Year Ago
SALES (in millions)
Quarter Ending Jul-18 24 29,982.10 30,333.00 29,446.50 29,084.30
Quarter Ending Oct-18 23 26,225.00 26,624.00 25,943.00 25,453.90
Year Ending Jan-18 31 100,675.00 101,000.00 100,361.00 --
Year Ending Jan-19 29 107,845.00 109,160.00 107,255.00 104,452.00
Year Ending Jan-20 30 112,110.00 114,188.00 110,482.00 107,892.00
Earnings (per share)
Quarter Ending Jul-18 28 2.84 2.91 2.76 2.48
Quarter Ending Oct-18 28 2.31 2.42 2.23 2.01
Year Ending Jan-18 31 7.37 7.53 7.19 --
Year Ending Jan-19 33 9.44 9.65 9.26 8.19
Year Ending Jan-20 33 10.18 10.50 9.85 8.92
LT Growth Rate (%) 6 15.18 17.40 10.00 11.72
Sales and Profit Figures in US Dollar (USD);

Valuation Ratios

  Company industry sector
P/E Ratio (TTM) 23.82 24.60 19.28
P/E High - Last 5 Yrs. 23.02 25.11 34.78
P/E Low - Last 5 Yrs. 20.46 15.45 13.05
Beta 1.09 0.90 1.27
Price to Sales (TTM) 2.01 34.51 4,094.27
Price to Book (MRQ) 55.11 20.36 2.31
Price to Tangible Book (MRQ) 148.22 48.67 2.91
Price to Cash Flow (TTM) 18.78 13.74 457,977.90
% Owned Institutions 73.25 29.83 0.40

Dividends

  Company industry sector
Dividend Yield 2.15 1.83 2.13
Dividend Yield - 5 Year Avg 1.90 1.64 2.25
Dividend 5 Year Growth Rate 21.56 14.05 8.37
Payout Ratio(TTM) 45.10 43.63 43.02

Growth Rates

  Company industry sector
Sales (MRQ) vs Qtr. 1 Yr. Ago 6.18 1.40 7.34
Sales (TTM) vs TTM 1 Yr. Ago 5.78 1.71 4.77
Sales - 5 Yr. Growth Rate 6.09 3.79 3.99
EPS (MRQ) vs Qtr. 1 Yr. Ago 14.16 10.76 32.63
EPS (TTM) vs TTM 1 Yr. Ago 17.46 -- --
EPS - 5 Yr. Growth Rate 21.12 11.30 1.78
Capital Spending - 5 Yr. Growth Rate 5.83 7.35 1.14

Financial Strength

  Company industry sector
Quick Ratio (MRQ) 0.48 0.68 1.15
Current Ratio (MRQ) 1.30 1.43 1.39
LT Debt to Equity (MRQ) 687.17 253.36 34.71
Total Debt to Equity (MRQ) 702.50 269.41 70.35
Interest Coverage (TTM) 13.51 20.28 5.21

Profitability Ratios

  Company industry sector
Gross Margin (TTM) 34.11 28.31 23.51
Gross Margin - 5 Yr. Avg. 34.23 30.40 22.69
EBITD Margin (TTM) 16.51 -- --
EBITD - 5 Yr. Avg 14.69 10.58 36.37
Operating Margin (TTM) 14.44 5.38 14.02
Operating Margin - 5 Yr. Avg. 12.53 7.96 40.47
Pre-Tax Margin (TTM) 13.45 4.58 16.37
Pre-Tax Margin - 5 Yr. Avg. 11.71 7.49 43.04
Net Profit Margin (TTM) 8.63 1.91 13.86
Net Profit Margin - 5 Yr. Avg. 7.44 4.84 39.79
Effective Tax Rate (TTM) 35.88 30.22 20.90
Effective Tax Rate - 5 Yr. Avg. 36.49 36.17 22.21

Efficiency

  Company industry sector
Revenue/Employee (TTM) 239,793 31,927,176 756,874,938
Net Income/Employee (TTM) 20,687 1,126,665 84,907,564
Receivable Turnover (TTM) 46.56 95.34 13.21
Inventory Turnover (TTM) 5.09 3.99 10.51
Asset Turnover (TTM) 2.16 1.39 0.70

Management Effectiveness

  Company industry sector
Return on Assets (TTM) 18.62 8.85 6.30
Return on Assets - 5 Yr. Avg. 15.22 8.04 7.74
Return on Investment (TTM) 28.06 13.35 10.59
Return on Investment - 5 Yr. Avg. 21.17 11.89 12.56
Return on Equity (TTM) 164.51 59.13 12.72
Return on Equity - 5 Yr. Avg. 54.74 24.58 16.71
  1 Year 3 Year 5 Year
Sales % 6.86 6.27 6.09
EPS (TTM) % 18.03 19.75 21.12
Dividend % 16.95 20.95 21.56
Note: Units in Millions of US Dollars

Performance for Home Depot Inc

Period %
Actual
% vs.
S&P 500
Rank In
Industry
Industry
Rank
4 Week 3.88 0.30 99 70
13 Week 8.95 3.64 99 85
26 Week 12.72 4.15 99 98
52 Week 27.39 7.97 99 94
YTD 23.69 8.63 99 98
Note:: Rank is a percentile that ranges from 0 to 99, with 99 = best.

Institutional Holders

% Shares Owned: 71.28%
# of Holders: 2,582
Total Shares Held: 822,238,759
3 Mo. Net Change: -15,989,879
# New Positions: 125
# Closed Positions: 125
# Increased Positions: 1,018
# Reduced Positions: 1,132
# Net Buyers: -114
NYSE and AMEX quotes delayed by at least 20 minutes. NASDAQ delayed by at least 15 minutes. For a complete list of exchanges and delays, please click here.