Fundamental Analysis of Home Depot Inc - Growth / Value Index
HD - Valuation Highlights
Valuation Analysis
Undervalued - Price to Intrinsic Value of 0.522
Tsr Value Index - Poor Score of 25.00
Price to Book Ratio of 332.35 suggesting that it is very expensive
Valuation Key Ratios
| Ratio | TTM | Latest FY | Yoy Change | MRQ |
|---|---|---|---|---|
| Price to Earning | 23.00 | 22.99 | 10.42 % | |
| Price to Book | 336.80 | 333.46 | 46.26 % | 330.80 |
| Price to Sales | 2.28 | 2.28 | 0.787 % | |
| Enterprise Value to EBITDA Multiple | 16.40 | 15.87 | 8.09 % |
HD - Profitability Highlights
Profitability Analysis
Over the last 3 years, the company has achieved Incredible Return on Assets
Strong Return On Capital Employed of 33.54
Company Earning excess return
During the past twelve months, the company has given a strong Return On Equity of 1320.69%
Piotroski F Score - Stable Value of 5.0
Tsr Profitability Index - Poor Score of 34.38
Low Earning Yield of 4.41 %
EPS decline for last four quarters
Profitability Key Ratios
| Ratio | TTM | Latest FY | Yoy Change | MRQ |
|---|---|---|---|---|
| Return On Equity | 1320.69 | 1450.48 | 32.46 % | 268.30 |
| Return On Asset | 19.89 | 19.79 | -11.57 % | 3.66 |
| Net Profit Margin | 9.92 | 9.92 | -8.73 % | 8.05 |
| Operating Profit Margin | 14.23 | 14.21 | -6.98 % | 11.91 |
| EBITDA Margin | 15.41 | 16.07 | -6.53 % | 14.04 |
Highlights
| Market Cap | 344323 M |
| Enterprise Value | 385724 M |
| Price/Book TTM | 336.80 |
| Outstanding Share | 991030 K |
| Float/ Outstanding Share | 99.80% |
| Dividend Yield | 2.66 % |
Share Holding
Guru Numbers
| Price/Graham No | 18.46 |
| Peter Lynch Ratio | -0.409 |
| Piotroski F Score | 5.00 |
| Altman Z Score | 7.30 |
| Sloan Ratio | -0.079 |
| Peter Lynch Fair Value | 100.93 |
HD - Growth Highlights
Growth Analysis
Steady increase in Total Assets for last 3 Years
Tsr Growth Index - Very Poor Score of 17.66
Growth Key Fields
| Field | TTM | YoY Growth | QoQ Growth |
|---|---|---|---|
| Revenue | 152669 M | 3.01 % | 7.75 % |
| Gross Profit | 50960.00 M | 3.44 % | 9.66 % |
| EBITDA | 23526.00 M | 9.34 % | 4.68 % |
| Net Profit | 15143.00 M | 11.47 % | 26.48 % |
| EPS | 15.10 | 9.44 % | NA |
HD - Stability Highlights
Stability Analysis
Altman Z Score of 7.27 suggests good Stability
Tsr Stability Index - Poor Score of 26.56
Company has high debt burden
Stability Key Ratios
| Ratio | Latest FY | Yoy Change | MRQ |
|---|---|---|---|
| Debt to Equity Ratio | 43.26 | 53.08 % | 43.26 |
| Cash Ratio | 0.171 | 43.16 % | |
| Quick Ratio | 0.400 | 21.78 % | 0.400 |
| Shareholders Equity | 1.36 | -33.24 % | |
| Debt to EBITDA | 1.84 | 12.86 % |
Historical Valuation Ratios of Home Depot Inc
Historical Valuation Ratios
Loading ...
Historical Profitability Ratios of Home Depot Inc
Historical Profitability Ratios
Loading ...
Historical Efficiency Ratios of Home Depot Inc
Historical Efficiency Ratios
Loading ...
Historical Solvency Ratios of Home Depot Inc
Historical Solvency Ratios
Loading ...
Note : All Data Generated at the End of Trading Hours (EOD Data)