StockRover

[Pages:8]Home Depot (HD)

Consumer Cyclical / Home Improvement Retail

StockRover

Stock Report | January 08, 2022

$393.61 -$12.15 (-2.99%) as of Friday's

close

52wk Range $246.59

$420.61

Cap ($M USD) P/E

$411,022 26.3

EPS (1Y)

29.4%

Dividend

$6.60

Sales ($M)

147,699

Forward P/E Sales (1Y)

24.3

17.6%

Div. Yield

1.7%

Last Filing

10/31/21

Next Earnings

02/22/22

Dividend Adjusted Return Jan 7, 2021 - Jan 7, 2022 HD 393.61 (+50.2%) Consumer Cyclical 330.60 (+19.8%)

S&P 500 4677.03 (+26.5%)

HD has outperformed the S&P 500 by 23.7% in the past year.

HD has outperformed its sector by 30.4% in the past year.

The Consumer Cyclical sector has underperformed the market by -6.6% in the past year.

ANALYST CONSENSUS

Buy

The consensus rating is unchanged from 1 month ago.

Strong

Buy

Buy

Hold

Sell

Strong

Sell

Strong Buy

11

Buy

3

Hold

7

Sell 0

Strong Sell 0

QUANTITATIVE SCORES

Fair Value

$357.61

Margin of Safety

-9%

The Margin of Safety is the difference between a company's Fair Value and the current price. See more on page 8.

1 warning Details on Page 8

Value Score

72

Value Score: Our value score looks at EV/EBITDA, P/E, P/S, P/TB (Price/Tangible Book) and EPS Predictability. P/S and P/TB are compared within a sector. Other metrics are compared across all stocks

Quality Score

86

Quality Score: Our quality score compares profitability and balance sheet metrics to find high quality companies using ROIC, Net Margin, Gross Margin, Interest Coverage, and Debt / Equity metrics.

Growth Score

95

Growth Score: Our growth score looks at the 5 year history and the forward estimates for EBITDA, Sales, and EPS growth, ranking the best companies across all stocks.

Sentiment Sentiment Score: Our sentiment score finds stocks

Score in favor by analyzing Short Interest, returns in key

periods over the last year, Price vs. 52-wk High,

40

Days Since 52-wk High and MACD signals.

BUSINESS SUMMARY

Home Depot is the world's largest home improvement specialty retailer, operating more than 2,300 warehouse-format stores offering more than 30,000 products in store and 1 million products online in the United States, Canada, and Mexico. Its stores offer numerous building materials, home improvement products, lawn and garden products, and decor products and provide various services, including home improvement installation services and tool and equipment rentals. The acquisition of distributor Interline Brands in 2015 allowed Home Depot to enter the maintenance, repair, and operations business, which has been expanded through the tie-up with HD Supply (2020). The addition of the Company Store brought textile exposure to Home Depot's lineup.

Employees 504,800

Homepage

Headquarters Atlanta, GA

? 2022 Stock Rover

Page 1 of 8

Home Depot (HD)

Consumer Cyclical / Home Improvement Retail

StockRover

Stock Report | January 08, 2022

VALUATION SUMMARY

Value Score Price / Earnings Price / Sales Price / Free Cash Flow Price / Book Price / Tangible Book EV / EBITDA EPS Predict. Pctl. Piotroski F Score

5Year P/E Range 5Year P/B Range 5Year P/S Range

HD

72 26.3

2.8 34.7 100+

18.0 100

5

15.1 24.5

1.5

Industry

69 24.4

2.3 29.7 30.1

17.2

65 5

S&P 500

73 28.2

3.2 30.6

5.0 100+ 22.6

70 8

29.8 3.0

Price / Earnings 26.3

Price / Sales 2.8

GROWTH SUMMARY

Growth Score

Sales Growth Sales Growth Next Year Sales 1Year Chg (%) Sales 3Year Avg (%) Sales 5Year Avg (%) EPS Growth Next Yr. Growth Est. EPS 1Year Chg (%) EPS 3Year Avg (%) EPS 5Year Avg (%)

HD 95

2.5% 17.6% 11.8%

9.6%

4.7% 29.4% 17.8% 19.4%

Industry 75

2.2% 19.8% 10.7%

9.0%

5.5% 40.9% 20.6% 22.8%

S&P 500 79

9.9% 17.4% 14.2% 13.0%

9.3% 57.1% 22.2% 24.1%

Sales EPS Price

PEERS ANALYSIS SUMMARY

Ticker

Company

Cap ($M USD

HD Home Depot

BABA Alibaba Group Hol...

LOW Lowe's Companies

JD



TJX TJX Companies

CPNG Coupang

ROST Ross Stores

BBY Best Buy Co

GPC Genuine Parts

M

Macy's

KSS Kohl's

VIPS Vipshop Holdings

$411,022 $361,958 $169,171 $106,928

$88,726 $45,484 $37,096 $24,657 $19,788

$7,888 $6,707 $6,043

P/E

26.3 18.3 21.7 26.1 34.0

23.4

9.9 24.7

9.8 7.5 6.9

Div. Yield

1.7% -

1.3% -

1.4% -

1.1% 2.7% 2.4% 2.3% 2.1%

-

1M Return

-5.4% 3.4% -2.3% -12.6% 0.4% -5.1% -7.2% -3.3% 3.8% -4.7% -7.5% -10.8%

1Y

Margin of Value

Return Safety Score

50.9%

-9% 72

-42.8%

36% 80

55.6%

-8% 75

-22.4%

1% 75

8.0%

9% 69

-

- 29

-13.1%

22% 76

-2.4%

3% 92

37.6%

8% 83

118.9%

20% 93

18.1%

35% 99

-69.3%

- 99

Growth Quality Score Score

95

86

98

92

93

80

81

81

95

80

- 32

96

84

59

88

89

82

52

74

69

75

93

93

? 2022 Stock Rover

Page 2 of 8

Home Depot (HD)

Consumer Cyclical / Home Improvement Retail

PROFITABILITY SUMMARY

Quality Score

Gross Margin Operating Margin Net Margin Return on Assets Return on Equity ROIC

HD

86 33.7% 15.1% 10.8% 21.8% 1539.9% 37.3%

Industry

76 34.6% 13.1%

9.2% 20.3% 1306.4% 32.6%

S&P 500

76 30.4% 14.3% 11.5%

8.2% 33.9% 19.3%

Net Margin 11.2 Gross Margin 34.1

StockRover

Stock Report | January 08, 2022

RETURNS SUMMARY

Sentiment Score

5Day Return 1Month Return YTD Return 1Year Return 3Year Return 5Year Return Beta 1Year

HD

40 -5.2% -5.4% -5.2% 50.9% 138.7% 231.0%

0.83

Industry

52 -2.9% -2.9% -2.9% 44.8% 141.4% 196.8%

0.80

S&P 500

64 -1.9% 0.1% -1.9% 24.6% 93.0% 124.5%

0.99

Dividend Adjusted Return Jan 7, 2021 - Jan 7, 2022 HD 404.09 (+52.9%)

EMA 50 396.98 (+50.2%) EMA 150 362.32 (+37.1%)

DIVIDEND

Dividend Yield Payout Ratio TTM Yield Dividend Per Share Div. 1Y Chg (%) Div. 3Y Avg (%) Div. 5Y Avg (%) Cons. Growth Years Div. Coverage Ratio

HD 1.7% 43.0% 1.7% $6.60 10.0% 17.0% 19.0%

10+ 2.3

Industry 1.7%

38.8% -

$4.75 20.0% 16.9% 18.3%

10+ 2.6

DEBT & EQUITY

Current Ratio Quick Ratio Price Net Cash Per Share Equity Per Share Debt / Equity Solvency Ratio Interest Coverage Short % of Float Altman ZScore

1.1 0.4 $393.61 -$37.84 $0.99 43.7 27% 16.6 1.1% 7.8

Debt / Equity 43.73

ANALYST REVISIONS

Current Quarter EPS

# Up Last 30 days

1.00

# Down Last 30 days

0.00

Mean Estimate

3.66

% Change (30 Days) -0.27%

Next Quarter EPS

# Up Last 30 days

1.00

# Down Last 30 days

0.00

Mean Estimate

3.17

% Change (30 Days) -0.31%

MEAN ESTIMATE TREND

Latest 30 Days Ago 90 Days Ago % Change (90 Days)

Cur Qtr $3.17 $3.18 $2.83 12.0%

Next Qtr $3.66 $3.67 $3.42 7.0%

Cur Year $15.46 $15.46 $14.57 6.1%

Next Year $16.19 $16.23 $15.23 6.3%

? 2022 Stock Rover

Page 3 of 8

Home Depot (HD)

Consumer Cyclical / Home Improvement Retail

EARNINGS SURPRISES

Earnings surprise is the difference between a company's announced earnings and the average analyst estimated value. Surprises typically causes the stock price to jump and are often followed by more of the same surprise type.

Surprise Summary (Last 12 Quarters)

Surprise Type Positive Quarters (> 2%) Negative Quarters (< 2%) In-Line Quarters (within 2%)

Amount 10 1 1

Percent 83.3% 8.3% 8.3%

Surprise Type Positive Positive Positive Positive Positive Positive

StockRover

Stock Report | January 08, 2022

Surprise Detail (Last 6 Quarters)

Announce Date

11/16/21 08/17/21 05/18/21 02/23/21 11/17/20 08/18/20

Period End Date

10/31/21 07/31/21 04/30/21 01/31/21

-

Actual EPS

$3.92 $4.53 $3.86 $2.74 $3.18 $4.02

Est. EPS $3.41 $4.43 $3.04 $2.63 $3.08 $3.78

Surprise (%)

15.0% 2.3%

27.0% 4.2% 3.2% 6.3%

RISK

Best Monthly Return (5Y) Worst Monthly Return (5Y) Beta 1Year Volatility 1Year Volatility 1Y Pctl. Max Drawdown 1Year Max Drawdown 3Year Max Drawdown 5Year

HD 23.1% -18.8%

0.83 0.20

17 -12.0% -38.4% -38.4%

Industry 21.7% -19.4% 0.80 0.17 -13.5% -40.6% -41.0%

S&P 500 17.9% -16.4% 0.99 0.13 -5.2% -33.9% -33.9%

HD Volatility 1Year 0.19

SEASONALITY

Ten-Year Seasonal Performance vs the S&P 500

5-YEAR RELATIVE PERFORMANCE VS S&P 500

Relative to the S&P 500 baseline, HD has outperformed the S&P 500 by 104.8% in the past 5 Years.

Dividend Adjusted Return Jan 6, 2017 - Jan 7, 2022 HD 393.61 (+104.8%) Consumer Cyclical 330.60 (+44.7%)

HD has outperformed its sector by 60.1% in the past 5 Years.

The Consumer Cyclical sector has outperformed the market by 44.7% in the past 5 Years.

S&P 500 4677.03 (0.0%)

? 2022 Stock Rover

Page 4 of 8

Home Depot (HD)

Consumer Cyclical / Home Improvement Retail

StockRover

Stock Report | January 08, 2022

Overall Rating

vs. Peers

61

Ratings scores are relative to industry groups. They compare key metrics to rank stocks vs. their competitors. For example, higher growth than peers will score high even when the absolute growth is below the market average.

Growth vs Peers

Ticker

Company

Growth Ratings Score

HD

Home Depot

73

LOW

Lowe's Companies

65

BBY

Best Buy Co

63

BABA

Alibaba Group Holding

54

JD



51

Sales

Eps

QoQ Chg. QoQ Chg.

9.8%

23.3%

2.7% 200.0%

0.5%

35.1%

29.4%

-80.9%

25.5%

-

Sales Growth Next Y. 2.5% 1.3% -1.8% 17.7% 22.0%

Sales 1Y Chg (%)

17.6% 11.6% 15.0% 26.5% 20.7%

Sales 3Y Avg (%)

11.8% 10.2%

6.4% 33.1% 24.9%

Sales 5Y Avg (%)

9.6% 8.8% 5.8% 41.4% 28.3%

Valuation vs Peers

Ticker

Company

BBY

Best Buy Co

Valuation Ratings Score

84

BABA

Alibaba Group Holding

75

LOW

Lowe's Companies

56

JD



38

HD

Home Depot

24

P/E

Forward

PEG

P/E

Trailing

9.9

11.1

0.4

18.3

13.4

0.7

21.7

19.5

0.7

26.1

32.7

-

26.3

24.3

1.4

P/S

0.5 2.8 1.9 0.8 2.8

P/B

5.8 2.3

3.1 100+

5Y P/E Range

9.1

24.5

15.8

72.2

17.1

39.8

12.1

-

15.1

29.8

Efficiency vs Peers

Ticker

Company

Efficiency Gross Operating Net Ratings Score Margin Margin Margin

5Y ROE Range

HD

Home Depot

100

33.7%

15.1% 10.8% -2856.8%

1539.9%

BBY

Best Buy Co

99

22.7%

6.4% 5.1% 26.1%

61.8%

JD



94

13.7%

0.7% 2.9% -7.5%

27.5%

LOW

Lowe's Companies

91

33.1%

12.4% 8.6% -3988.6%

1525.8%

BABA

Alibaba Group Ho...

88

38.6%

10.7% 15.3% 12.9%

25.3%

5Y ROA Range

18.2% 7.3% -1.3% 5.5% 7.2%

25.3% 13.6% 12.5% 16.6% 13.2%

Financial Strength vs Peers

Ticker

Company

JD BABA BBY HD LOW

Alibaba Group Holding Best Buy Co Home Depot Lowe's Companies

Financial Strength Ratings Score 94 92 74 26 16

Debt / Equity

0.2 0.2 0.9 43.7

-

Interest Coverage

Quick Ratio

Intangibles % Solvency Ratio

25.9

1.1

6.6%

11%

29.0

1.7

20.9%

24%

117.7

0.4

6.1%

23%

16.6

0.4

10.2%

27%

13.5

0.4

1.7%

21%

Short % of Float

4.7% 1.1% 1.2%

Dividends vs Peers

Ticker

Company

Dividends Div. Yield Ratings Score

BBY

Best Buy Co

67

2.7%

LOW

Lowe's Companies

49

1.3%

HD

Home Depot

33

1.7%

BABA

Alibaba Group Holding

-

-

JD



-

-

TTM Yield

2.7% 1.1% 1.7%

-

Price

Div.

Consecutive Div.

Per Share

Growth Years

$102.50

$2.80

10+

$251.09

$3.20

10+

$393.61

$6.60

10+

$129.81

-

0

$68.24

-

0

Payout Ratio

25.4% 24.2% 43.0%

-

Momentum vs Peers

Ticker

Company

Momentum Ratings Score

LOW

Lowe's Companies

92

HD

Home Depot

87

BBY

Best Buy Co

32

BABA

Alibaba Group Holding

17

JD

JD

16

? 2022 Stock Rover

1M

3M

6M

YTD

1Y

Beta Volatility

Price vs

Return Return Return Return Return 1Y

1Y 52wk High (%)

-2.3% 21.2% 29.2% -2.9% 55.6% 0.90

0.24

95.4%

-5.4% 17.1% 22.8% -5.2% 50.9% 0.83

0.20

93.6%

-3.3% -4.1% -5.4% 0.9% -2.4% 1.07

0.33

72.2%

3.4% -16.8% -37.6% 9.3% -42.8% 0.74

0.43

47.3%

12 6% 10 6% 6 1% 2 6% 22 4% 1 00

0 46

63 0% Page 5 of 8

Home Depot (HD)

Consumer Cyclical / Home Improvement Retail

DIVIDEND DETAIL

StockRover

Stock Report | January 08, 2022

CALENDAR YEAR DIVIDEND HISTORY

Year

Date

Pay Date

2021 Dividends

12/01/21

12/16/21

09/01/21

09/16/21

06/02/21

06/17/21

03/10/21

03/25/21

2020 Dividends

12/02/20

12/17/20

09/02/20

09/17/20

06/03/20

06/18/20

03/11/20

03/26/20

2019 Dividends

12/04/19

12/19/19

09/04/19

09/19/19

06/05/19

06/20/19

03/13/19

03/28/19

2018 Dividends

11/28/18

12/13/18

08/29/18

09/13/18

05/30/18

06/14/18

03/07/18

03/22/18

2017 Dividends

11/29/17

12/14/17

08/29/17

09/14/17

05/30/17

06/15/17

? 2022 Stock Rover

Text

Regular Regular Regular Regular

Regular Regular Regular Regular

Regular Regular Regular Regular

Regular Regular Regular Regular

Regular Regular Regular

Amount $6.60 $1.65 $1.65 $1.65 $1.65 $6.00 $1.50 $1.50 $1.50 $1.50 $5.44 $1.36 $1.36 $1.36 $1.36 $4.12 $1.03 $1.03 $1.03 $1.03 $3.56 $0.89 $0.89 $0.89

UPCOMING DIVIDEND

Ex-Dividend Date Payment Date Amount Type

DIVIDEND RATE

Regular Dividend Annual Dividend Rate Annual Dividend Yield Trailing 12 Months Dividends Trailing 12 Months Yield

STATISTICS

Payout Ratio Dividend Coverage Ratio Consecutive Growth Years 3 Year Growth Rate 5 Year Growth Rate 10 Year Growth Rate

12/01/21 12/16/21

$1.65 Regular

$1.65 $6.60 1.7% $6.60 1.7%

43.0% 232.7%

10+ 17.0% 19.0% 19.0%

Page 6 of 8

Home Depot (HD)

Consumer Cyclical / Home Improvement Retail

StockRover

Stock Report | January 08, 2022

FINANCIAL STATEMENT SUMMARY

USD in Millions

Income Statement

Revenue Operating Income Net income Earnings per share diluted Average shares diluted P/E Ratio

Chart

Balance Sheet

Cash Current assets Net Property, Plant and Eq... Working Capital Net Debt Stockholders' Equity

Cash Flow

Operating Cash Flow Cap Ex Free Cash Flow Free Cash Flow per share

Profitability

Operating Margin Return on Assets Return on Equity Return on Invested Capital

Dividends

2016

93,368 13,049

7,684 $6.17 1,247

22.7

3,589 19,348 21,840

4,917 19,292

5,622

9,926 -1,565 8,361 $6.70

14.0% 17.3% 136.7% 30.4%

2017

99,228 14,419

8,595 $7.21 1,195

27.2

3,549 19,682 21,960

3,680 22,040

2,543

11,605 -1,830 9,775 $8.18

14.5% 19.1% 338.0% 34.2%

2018

2019

105,595 15,341 10,556 $9.16 1,154 20.2

110,934 16,065 11,105 $10.06

1,106 21.8

1,764 19,809 22,054

1,613 24,020

1,320

2,193 21,174 28,110

1,609 32,858 -1,082

12,326 -2,254 10,072 $8.73

13,666 -2,622 11,044 $9.99

14.5% 23.4% 799.7% 42.8%

14.5% 21.2% -1026.3% 36.1%

2020

TTM

CAGR

125,631 17,598 12,490 $11.57 1,081 23.0

147,699 22,298 15,938 $14.97 1,067 26.3

12.1% 14.3% 19.9% 24.7% -3.8%

3.8%

14,652 34,505 29,281

9,110 26,392

1,535

5,067 30,466 30,838

3,563 40,198

1,035

9.0% 12.0%

9.0% -7.7% 20.0% -34.4%

20,345 -2,290 18,055 $16.71

14,810 -2,697 12,113 $11.36

10.5% 14.5%

9.7% 14.0%

14.0% 18.7% 813.7% 32.4%

15.1% 21.8% 1539.9% 37.3%

1.9% 6.0% 82.7% 5.3%

VALUATION & PROFITABILITY HISTORY

Date

TTM

1 Yr 2 Yrs. 3 Yrs. 4 Yrs. Ago Ago Ago Ago

Price / Earnings Price / Cash Flow Price / Book Price / Tangible B... Price / Sales EV / EBITDA Dividend Yield Shareholder Yield Gross Margin Net Margin Return on Assets Return on Equity ROIC

26.3

23.0

21.8

20.8

27.7

28.3

14.1

17.9

17.0

21.6

100+ 100+

-

99.7

63.1

-

-

-

-

100+

2.8

2.3

2.2

2.0

2.4

18.0

16.0

15.6

13.6

16.2

1.7% 2.3% 2.5% 2.3% 1.9%

4.1% 3.5% 5.7% 5.7% 5.2%

33.7% 34.0% 34.1% 34.3% 34.1%

10.8% 9.9% 10.0% 10.0% 8.7%

21.8% 18.7% 21.2% 23.4% 19.1%

1539.... 813.7% -1026... 799.7% 338.0%

37.3% 32.4% 36.1% 42.8% 34.2%

? 2022 Stock Rover

Page 7 of 8

Home Depot (HD)

Consumer Cyclical / Home Improvement Retail

StockRover

Stock Report | January 08, 2022

WARNINGS

Name MACD Crossover

Severity Low

Details MACD Crossover Days: 2; MACD Divergence: -1.13

The MACD indicator has turned negative in the past week. This is a bearish signal among technical traders.

REPORT TIPS

Metric Definitions

Metric descriptions are available at help/metrics/metric-overview Quantitative Scores

Our scores analytics is to offer our concise analysis of a stock in powerful, but easy to digest format. Each of the composite score metrics are designed to use the best available accounting practices as well as source data from SEC filings. The scores are computed for a company vs. the market as a whole. Fair Value

Fair value performs a forecasted discounted cash flow analysis of a company to determine the company's intrinsic value based on the expected future cash flows the company will produce. It basically determines what a company is worth based on how much cash flow it is expected to generate for you in the future, taking into account the time value of money and the predictability of those forecasted cash flows. Peers

Peer ratings are computed from raking companies in the same

? 2022 Stock Rover

DISCLAIMER

Premium Plus users have unlimited access to reports during the introductory period. Afterwards reports will be offered as an add on to subscriptions.

Financial Statements and Historical Prices Provided by Morningstar. ? 2022 Morningstar, Inc. All Rights Reserved. The information contained herein: (1) is proprietary to Stock Rover and/or its content providers; (2) may not be copied or distributed; and (3) is not warranted to be accurate, complete or timely.

The information provided does not constitute investment advice, nor does it constitute a recommendation to buy or sell any security. Stock Rover LLC and its content providers are not responsible for any losses resulting from trading decisions arising from any use of this information. Past performance is no guarantee of future results.

The information provided is as of the date written and is subject to change without notice Additional data provided by Zacks, Intrinio, Quandl, Yodlee, IEX Cloud

Page 8 of 8

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download