Home Depot

Visual Financials
Company Name: The Home Depot Inc
Ticker Symbol: HD
CIK Number: 0000354950
WWW Address: http://www.homedepot.com
CEO: Craig A. Menear
No. of Employees: 406,000
Common Issue Type: CS
Business Description:Home Depot, Inc., is a home improvement retailer. Its stores sell an assortment of building materials, home improvement and lawn and garden products and provide a number of services.

 
Industry Information: RETAIL - Home Improvement Stores [more like this]
 Price  Day Change  Bid  Ask  Open  High  Low  Volume 
 147.71 Down -0.28 - -  148.52 147.01 4735361
 Market Cap (mil) Shares Outstanding (mil) Beta EPS DPS P/E Yield 52-Wks-Range
 177,683.0 1,202.9 0.00 6.47 3.56 22.9 2.0 149.99 - 119.20
KEY FIGURES (Latest Twelve Months - LTM)
Yesterday's Close147.77$
PE Ratio - LTM22.9
Market Capitalisation177,683.0mil
Latest Shares Outstanding1,202.9mil
Earnings pS (EPS)6.47$
Dividend pS (DPS)3.56¢
Dividend Yield2.0%
Dividend Payout Ratio%
Revenue per Employee232,993$
Effective Tax Rate0.4%
Float1,249.6mil
Float as % of Shares Outstanding1.0%
Foreign Sales8,000mil
Domestic Sales86,600mil
Selling, General & Adm/tive (SG&A) as % of Revenue0.20%
Research & Devlopment (R&D) as % of Revenue0.00%
Gross Profit Margin34.2%
EBITDA Margin16.3%
Pre-Tax Profit Margin13.2%
Assets Turnover221.2%
Return on Assets (ROA)18.6%
Return on Equity (ROE)149.4%
Return on Capital Invested (ROCI)30.8%
Current Ratio1.3
Leverage Ratio (Assets/Equity)9.9
Interest Cover13.9
Total Debt/Equity (Gearing Ratio)5.45
LT Debt/Total Capital84.0%
Working Capital pS2.99$
Cash pS0.00$
Book-Value pS3.60$
Tangible Book-Value pS1.86$
Cash Flow pS7.93$
Free Cash Flow pS6.61$
KEY FIGURES (LTM): Price info
Price/Book Ratio40.98
Price/Tangible Book Ratio0.00
Price/Cash Flow18.6
Price/Free Cash Flow22.3
P/E as % of Industry Group105.0%
P/E as % of Sector Segment97.0%
 
Balance Sheet (at a glance) in Millions
DIVIDEND INFO
Type of PaymentCash Payment
Dividend Rate3.56
Current Dividend Yield2.0
5-Y Average Dividend Yield2.8
Payout Ratio0.0
5-Y Average Payout Ratio50.0
Share price performance previous 3 years

Share price performance intraday

 
PRICE/VOLUMEHighLowClose% Price Chg% Price Chg vs. Mkt.Avg. Daily VolTotal Vol
1 Week----1.23,410,32016,767,089
4 Weeks149.99144.47145.891.423,362,02470,602,506
13 Weeks149.99133.05135.029.663,396,831210,603,548
26 Weeks149.99119.20127.8115.884,110,428517,913,973
52 Weeks149.99119.20131.0912.9-24,055,2601,021,925,520
YTD149.99133.05-10.263,471,636197,883,284
Moving Average5-Days10-Days10-Weeks30-Weeks200-DaysBeta (60-Mnth)Beta (36-Mnth)
147.51147.87142.44133.94133.730.000.00
 
GROWTH RATES5-Year
Growh
R² of 5-Year Growth3-Year
Growth
Revenue0.060.20.06
Income0.150.30.14
Dividend0.220.40.21
Capital Spending0.08NA0.09
R&D0.00NA0.00
Normalized Inc.13.95NA20.16
 
CHANGESYTD vs.
Last YTD
Curr Qtr vs.
Qtr 1-Yr ago
Annual vs.
Last Annual
Revenue %7.47.46.2
Earnings %18.518.516.8
EPS %22.122.121.5
EPS $0.150.150.53
 
SOLVENCY RATIOS
SHORT-TERM SOLVENCY RATIOS (LIQUIDITY)
Net Working Capital Ratio8.36
Current Ratio1.3
Quick Ratio (Acid Test)0.3
Liquidity Ratio (Cash)0.36
Receivables Turnover48.3
Average Collection Period7
Working Capital/Equity82.9
Working Capital pS2.99
Cash-Flow pS7.93
Free Cash-Flow pS6.61
FINANCIAL STRUCTURE RATIOS
Altman's Z-Score Ratio6.46
Financial Leverage Ratio (Assets/Equity)5.4
Debt Ratio54.9
Total Debt/Equity (Gearing Ratio)5.45
LT Debt/Equity5.16
LT Debt/Capital Invested87.7
LT Debt/Total Liabilities94.7
Interest Cover13.9
Interest/Capital Invested3.37
 
VALUATION RATIOS
MULTIPLES
PQ Ratio0.00
Tobin's Q Ratio4.14
Current P/E Ratio - LTM22.90
Enterprise Value (EV)/EBITDA13.68
Enterprise Value (EV)/Free Cash Flow32.74
Dividend Yield2.0
Price/Tangible Book Ratio - LTM0.00
Price/Book Ratio - LTM40.98
Price/Cash Flow Ratio18.6
Price/Free Cash Flow Ratio - LTM22.3
Price/Sales Ratio0.00
P/E Ratio (1 month ago) - LTM24.3
P/E Ratio (26 weeks ago) - LTM22.0
P/E Ratio (52 weeks ago) - LTM19.6
5-Y High P/E Ratio23.3
5-Y Low P/E Ratio7.2
5-Y Average P/E Ratio18.5
Current P/E Ratio as % of 5-Y Average P/E50
P/E as % of Industry Group105.0
P/E as % of Sector Segment97.0
Current 12 Month Normalized P/E Ratio - LTM24.3
PER SHARE FIGURES
LT Debt pS17.88
Current Liabilities pS11.31
Tangible Book Value pS - LTM1.86
Book Value pS - LTM3.60
Capital Invested pS23.22
Cash pS - LTM0.00
Cash Flow pS - LTM7.93
Free Cash Flow pS - LTM6.61
Earnings pS (EPS)6.47
 
OPERATING RATIOS
PROFITABILITY RATIOS
Free Cash Flow Margin8.63
Free Cash Flow Margin 5YEAR AVG7.73
Net Profit Margin0.1
Net Profit Margin - 5YEAR AVRG.0.1
Equity Productivity21.83
Return on Equity (ROE)1.5
Return on Equity (ROE) - 5YEAR AVRG.0.7
Capital Invested Productivity3.39
Return on Capital Invested (ROCI)0.2
Return on Capital Invested (ROCI) - 5YEAR AVRG.0.2
Assets Productivity2.20
Return on Assets (ROA)0.2
Return on Assets (ROA) - 5YEAR AVRG.0.2
Gross Profit Margin34.2
Gross Profit Margin - 5YEAR AVRG.0.3
EBITDA Margin - LTM16.3
EBIT Margin - LTM14.2
Pre-Tax Profit Margin0.1
Pre-Tax Profit Margin - 5YEAR AVRG.0.1
Effective Tax Rate0.2
Effective Tax Rate - 5YEAR AVRG.7.6
EFFICIENCY RATIOS
Cash Conversion Cycle268,356,497
Revenue per Employee232,993
Net Income per Employee19,599
Average Collection Period268,356,497
Receivables Turnover48.3
Day's Inventory Turnover Ratio
Inventory Turnover5.1
Inventory/Sales13.3
Accounts Payble/Sales7.40
Assets/Revenue0.45
Net Working Capital Turnover26.34
Fixed Assets Turnover3.75
Total Assets Turnover2.2
Revenue per $ Cash37.27
Revenue per $ Plant4.32
Revenue per $ Common Equity21.83
Revenue per $ Capital Invested3.39
Selling, General & Adm/tive (SG&A) as % of Revenue18.1
SG&A Expense as % of Revenue - 5YEAR AVRG.1.0
Research & Devlopment (R&D) as % of Revenue0.0
R&D Expense as % of Revenue - 5YEAR AVRG.0.0

  
Your Recent History
LSE
GKP
Gulf Keyst..
LSE
QPP
Quindell
FTSE
UKX
FTSE 100
LSE
IOF
Iofina
FX
GBPUSD
UK Sterlin..
Stocks you've viewed will appear in this box, letting you easily return to quotes you've seen previously.

Register now to create your own custom streaming stock watchlist.

NYSE, AMEX, and ASX quotes are delayed by at least 20 minutes.
All other quotes are delayed by at least 15 minutes unless otherwise stated.

By accessing the services available at ADVFN you are agreeing to be bound by ADVFN's Terms & Conditions

P:34 V:us D:20170326 20:50:21