Edition:
United States

Home Depot Inc (HD.N)

HD.N on New York Stock Exchange

172.86USD
21 Nov 2017
Change (% chg)

$2.41 (+1.41%)
Prev Close
$170.45
Open
$170.53
Day's High
$172.86
Day's Low
$170.15
Volume
1,986,716
Avg. Vol
1,307,641
52-wk High
$172.86
52-wk Low
$127.42

Revenue & Earnings Per Share

    Revenue* Earnings Per Share**
FY 2018 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
FY 2015 Feb '15 19,162.00 1.048
Nov 20,516.00 1.152
Aug 23,811.00 1.515
May 19,687.00 1.002
 
*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 Jan-17 25 21,810.70 22,182.60 21,627.00 --
Quarter Ending Apr-18 17 25,209.20 25,488.40 24,890.00 24,560.70
Year Ending Jan-17 29 94,197.60 94,570.60 94,011.70 --
Year Ending Jan-18 27 100,818.00 107,215.00 99,791.00 98,323.70
Year Ending Jan-19 29 106,239.00 108,500.00 104,438.00 102,912.00
Earnings (per share)
Quarter Ending Jan-17 27 1.34 1.38 1.31 --
Quarter Ending Apr-18 19 1.88 1.98 1.83 1.81
Year Ending Jan-17 33 6.35 6.41 6.32 --
Year Ending Jan-18 26 7.42 8.38 7.31 7.16
Year Ending Jan-19 33 8.40 9.19 8.15 8.11
LT Growth Rate (%) 6 12.93 16.00 10.70 13.66
Sales and Profit Figures in US Dollar (USD);

Valuation Ratios

  Company industry sector
P/E Ratio (TTM) 23.99 26.17 19.49
P/E High - Last 5 Yrs. 23.02 26.50 33.70
P/E Low - Last 5 Yrs. 20.46 14.88 12.90
Beta 1.10 0.86 1.26
Price to Sales (TTM) 2.05 1.24 3,010.22
Price to Book (MRQ) 79.39 18.65 2.43
Price to Tangible Book (MRQ) 625.06 120.93 2.97
Price to Cash Flow (TTM) 19.17 13.51 157,799.54
% Owned Institutions 71.61 18.76 0.21

Dividends

  Company industry sector
Dividend Yield 2.06 1.75 2.08
Dividend Yield - 5 Year Avg 1.90 1.63 2.12
Dividend 5 Year Growth Rate 21.56 12.37 8.11
Payout Ratio(TTM) 46.38 49.99 20.64

Growth Rates

  Company industry sector
Sales (MRQ) vs Qtr. 1 Yr. Ago 8.09 3.41 16.27
Sales (TTM) vs TTM 1 Yr. Ago 6.28 2.80 18.81
Sales - 5 Yr. Growth Rate 6.09 4.92 4.01
EPS (MRQ) vs Qtr. 1 Yr. Ago 15.10 105.81 -795.43
EPS (TTM) vs TTM 1 Yr. Ago 16.66 -- --
EPS - 5 Yr. Growth Rate 21.12 8.68 1.76
Capital Spending - 5 Yr. Growth Rate 5.83 4.24 1.14

Financial Strength

  Company industry sector
Quick Ratio (MRQ) 0.39 0.56 1.16
Current Ratio (MRQ) 1.23 1.34 1.44
LT Debt to Equity (MRQ) 954.23 224.71 35.00
Total Debt to Equity (MRQ) 1,006.25 251.05 69.88
Interest Coverage (TTM) 13.93 24.48 7.90

Profitability Ratios

  Company industry sector
Gross Margin (TTM) 34.08 29.39 23.51
Gross Margin - 5 Yr. Avg. 34.23 29.88 22.60
EBITD Margin (TTM) 16.58 -- --
EBITD - 5 Yr. Avg 14.69 10.07 40.09
Operating Margin (TTM) 14.53 7.37 14.86
Operating Margin - 5 Yr. Avg. 12.53 7.28 45.52
Pre-Tax Margin (TTM) 13.55 7.21 16.96
Pre-Tax Margin - 5 Yr. Avg. 11.71 7.02 48.00
Net Profit Margin (TTM) 8.66 4.98 14.47
Net Profit Margin - 5 Yr. Avg. 7.44 4.67 44.66
Effective Tax Rate (TTM) 36.08 28.85 20.96
Effective Tax Rate - 5 Yr. Avg. 36.49 35.47 22.27

Efficiency

  Company industry sector
Revenue/Employee (TTM) 244,404 34,168,046 792,726,639
Net Income/Employee (TTM) 21,170 1,119,706 88,938,258
Receivable Turnover (TTM) 47.69 100.52 14.84
Inventory Turnover (TTM) 4.91 3.88 11.17
Asset Turnover (TTM) 2.22 1.28 0.74

Management Effectiveness

  Company industry sector
Return on Assets (TTM) 19.20 7.65 -11.03
Return on Assets - 5 Yr. Avg. 15.22 7.02 7.76
Return on Investment (TTM) 29.09 11.72 -65.61
Return on Investment - 5 Yr. Avg. 21.17 10.72 12.60
Return on Equity (TTM) 210.53 50.93 -64.12
Return on Equity - 5 Yr. Avg. 54.74 20.04 16.57
  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.47 2.78 99 55
13 Week 14.24 7.44 99 79
26 Week 9.29 1.33 99 74
52 Week 32.82 12.23 99 35
YTD 27.13 10.22 99 34
Note:: Rank is a percentile that ranges from 0 to 99, with 99 = best.

Institutional Holders

% Shares Owned: 71.59%
# of Holders: 2,391
Total Shares Held: 843,867,961
3 Mo. Net Change: -20,481,532
# New Positions: 104
# Closed Positions: 83
# Increased Positions: 985
# Reduced Positions: 878
# Net Buyers: 107
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.