NYSE: HD - Home Depot

Yield per half year: -9%
Dividend yield: +2.38%
Sector: Consumer Staples

Reporting Home Depot

Reports

IFRS
Reporting Annual Quarterly
2016 2017 2018 2019 2020 2021 2022 2023
Финансовый отчет link link link link link link link link


Capitalization

IFRS
Reporting Annual Quarterly
2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 LTM 5 year average CAGR 5
Капитализация, млрд $
141.29 169.68 165.45 224.4 196.39 245.66 290.86 393.66 331.3 329.13 291.57 11.02
Выручка, млрд $
88.52 94.6 100.9 108.2 110.23 132.11 151.16 157.4 152.67 152.67 140.71 6.73
Чистая прибыль, млрд $
7.01 7.96 8.63 11.12 11.24 12.87 16.43 17.11 15.14 15.14 14.56 6.14
EV, млрд $
188.68 185.98 247.84 238.16 285.47 340.17 432.19 369.7 404.89 404.89 366.48 7.24
EBIT, млрд $
11.94 13.46 14.76 15.53 15.84 18.28 23.08 24.09 21.69 21.69 20.60 6.49
EBITDA, млрд $
13.63 15.44 16.82 17.76 18.21 20.84 25.95 27.07 24.94 24.94 23.40 6.49
Баланс стоимость, млрд $
30.97 35.52 39.94 -1.88 -3.12 3.3 -1.7 1.56 1.04 1.04 0.2160 -180.27
FCF, млрд $
7.87 8.16 10.13 10.6 11.05 16.38 14.01 11.5 17.95 17.95 14.18 10.19
Операционный денежный поток, млрд $
9.78 12.03 13.04 13.04 13.72 18.84 16.57 14.62 21.17 21.17 16.98 9.06
Операционная прибыль, млрд $
11.77 13.43 14.68 15.53 15.84 18.28 23.04 24.04 21.69 21.69 20.58 6.49
Операционные расходы, млрд $
18.49 18.89 19.68 21.38 21.73 26.58 27.79 28.74 29.27 29.27 26.82 6.14
CAPEX, млрд $
1.5 1.62 1.9 2.44 2.68 2.46 2.57 3.12 3.23 3.23 2.81 3.80


Balance sheet

IFRS
Reporting Annual Quarterly
2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 LTM 5 year average CAGR 5
Наличность, млрд $
2.22 2.54 3.6 1.78 2.13 7.9 2.34 2.76 3.76 3.76 3.78 12.04
Short Term Investments $
0.026 1.66 0.014 0.014 0.012 0.006 0.006 0.272 0.34 0.459 0.2166 138.09
Long term investments $
0.033 0.139 0.0860 105.23
Total Receivables $
1.89 2.03 1.95 1.94 2.11 2.99 3.43 3.32 3.33 3.33 3.04 9.56
Total Current Assets $
16.99 17.72 18.93 18.53 19.81 28.48 29.06 32.47 29.78 29.78 27.92 8.49
Чистые активы, млрд $
9.32 6.32 4.33 1.45 18.53 19.81 28.48 31.17 32.57 32.57 26.11 11.94
Активы, млрд $
42.55 42.97 44.53 44 51.24 70.58 71.88 76.45 76.53 76.53 69.34 8.35
Short Term Debt $
3.4 1.25 2.76 2.4 3.64 2.24 5.14 3.12 2.42 2.42 3.31 -7.84
Long Term Debt $
20.79 22.35 24.27 26.81 28.67 35.82 36.6 41.96 42.74 42.74 37.16 8.31
Задолженность, млрд $
36.23 38.63 43.08 45.88 54.35 67.28 73.57 74.88 75.49 75.49 69.11 6.79
Чистый долг, млрд $
19 20.52 23.43 27.42 35.24 35.53 43.93 47.61 48.48 48.48 42.16 6.59
Долг, млрд $
21.22 23.06 27.03 29.2 37.38 43.42 46.27 50.36 52.24 52.24 45.93 6.92
Interest income $
0.753 0.036 0.074 0.093 0.073 0.047 0.044 0.055 0.0624 -9.97
Расходы на обслуживание долга $
0.919 0.972 1.05 1.05 1.2 1.35 1.35 1.62 1.94 1.94 1.49 10.08
Чист. проц. доходы, млрд $
-0.936 0.074 0.093 0.073 0.047 0.044 0.055 0.178 0.055 0.0794 19.51
Goodwill $
1.29 1.35 2.1 2.09 2.28 2.25 2.25 7.13 7.45 7.44 5.30 27.02
Амортизация, млрд $
1.86 1.97 2.06 2.15 2.37 2.57 2.86 2.98 3.25 3.25 2.81 6.52
Себестоимость, млрд $
62.28 66.55 71.04 72.65 72.65 87.26 100.33 104.63 101.71 101.71 93.32 6.96
Товарно материальные запасы $
11.81 12.55 12.75 13.93 14.53 16.63 22.07 24.89 20.98 20.98 19.82 7.62


Share

IFRS
Reporting Annual Quarterly
2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 LTM 5 year average CAGR 5
EPS 5.46 6.45 7.29 9.73 10.25 11.94 15.53 16.69 15.11 15.11 13.90 8.07
Цена акции ао 134.08 189.53 171.82 218.38 265.62 299.31 346.55 388.99 360.99 360.99 332.29 6.33
Число акций ао, млн 1283 1234 1184 1143 1097 1078 1058 1025 1002 1002 1052.00 -1.80
FCF/акцию 6.13 6.61 8.56 9.27 10.07 15.19 13.24 11.22 17.91 17.91 13.53 12.21


Efficiency

IFRS
Reporting Annual Quarterly
2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 LTM Industry average 5 year average CAGR 5
ROE, % 89.64 149.44 298.25 -5245.75 -450.22 14061.2 2050.28 -25529.85 1162.16 1162.16 84.18 -1741.2860 -220.88
ROA, % 16.99 18.61 19.73 25.12 23.61 21.12 23.07 23.06 19.8 19.8 9.56 22.13 -3.46
ROIC, % 24.77 27.66 30.76 32.79 47.6 47.37 34.21 54.34 49.09 55.77 16.49 46.52 0.62
ROS, % 14.23 14.62 14.42 14.44 14.44 10.87 10.87 9.92 9.92 9.92 13.93 11.20 -7.23
ROCE, % 310.71 1014.79 56.91 48.21 38.55 53.46 45.17 39.79 2077.49 2077.49 136.91 450.89 121.97
Ebit margin, % 14.37 13.87 15.27 15.31 14.21 14.21 14.21 14.57 0.49
Рентаб EBITDA, % 16.32 16.67 16.41 16.52 15.78 17.16 17.2 16.33 16.33 16.33 25.32 16.56 0.69
Чистая рентаб, % 13.3 14.2 14.5 10.28 10.2 9.74 10.87 10.87 9.92 9.92 13.94 10.32 -0.56
Operation Margin, % 14.19 14.55 14.35 14.37 14.37 15.24 15.27 14.21 14.21 14.21 20.84 14.66 -0.22
Чистая процентная маржа, % 6.83 7.63 7.92 8.41 8.55 10.28 10.2 9.74 10.87 10.83 14.20 9.93 4.92
Доходность FCF, % 5.28 4.81 4.64 4.93 4.52 4.67 4.12 4.77 4.41 3.73 4.34 -4.40


Coefficients

IFRS
Reporting Annual Quarterly
2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 LTM Industry average 5 year average CAGR 5
P/E
21.7 26.3 18.8 18.95 22.26 23.68 23.63 18.83 23.54 23.54 77.90 22.39 1.12
P/BV
29.1 87 147.1 -112.21 -80.3 92.34 -228.93 206.21 341.39 341.39 33.47 66.14 -233.57
P/S
1.8 2.3 1.9 1.95 2.27 2.31 2.57 2.05 2.33 2.33 8.22 2.31 0.52
P/FCF
22.56 16.84 21.03 25.12 39.19 22.67 28.62 18.34 18.34 18.34 19.81 25.43 -14.09
E/P
0.0436 0.0401 0.049 0.0419 0.0374 0.0518 0.0555 0.046 0.046 0.046 0.09 0.0473 4.23
EV/EBIT
18.02 17.87 18.72 15.34 18.67 18.67 18.67 17.85 0.88
EV/EBITDA
13.84 12.05 14.74 13.41 15.67 16.32 16.66 13.66 16.24 16.24 48.63 15.71 0.72
EV/S
2.15 2.37 2.35 2.71 2.83 2.86 2.35 2.65 2.65 2.65 8.76 2.67 -1.31
EV/FCF
24.92 23.57 23.99 27.02 22.82 30.86 32.16 22.56 22.56 22.56 168.72 26.19 -0.23
Debt/EBITDA
1.49 1.61 1.64 2.05 2.08 1.78 1.86 2.1 2.1 2.1 2.73 1.98 0.19
Netdebt/Ebitda
1.42 1.49 1.64 1.77 1.77 1.69 1.76 1.94 1.94 1.94 1.90 1.82 1.85
Debt/Ratio
0.9 0.97 1.04 1.06 1.06 0.6437 0.6588 0.6826 0.6826 0.6826 0.43 0.7455 -8.43
Debt/Equity
8.92 29.63 -24.43 -17.44 -17.44 -27.28 32.24 50.04 1.6 1.6 3.07 7.83 -162.02
Debt/Net Income
2.97 3.13 2.63 2.87 2.96 2.82 2.94 3.45 3.45 3.45 6.67 3.12 3.11
peg
-42.4 -42.4 -42.4000 0.00
Бета
1.02 1.02 0.94 1.09 1.1 1.73 1.73 -0.29 1.18 11.14
Индекс Альтмана
7.35 7.07 8.07 7.69 10.64 8.8 8.73 8.62 8.62 8.62 4.18 9.08 -4.12


Dividends

IFRS
Reporting Annual Quarterly
2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 LTM Industry average 5 year average CAGR 5
Див.выплата, млрд
2.53 3.03 4.21 4.7 5.96 6.45 6.99 7.79 8.38 8.38 7.11 7.05
Дивиденд
2.76 3.56 4.12 5.44 6 6.6 7.6 8.36 11.3 11.3 7.97 13.50
Див доход, ао, %
2.13 1.97 2.28 2.32 2.12 1.65 2.32 2.62 2.51 2.38 3.39 2.24 3.44
Дивиденды / прибыль, %
41.9 43.1 46.6 42.3 53 50.14 42.51 45.54 55.36 55.36 77.00 49.31 0.88


Pay for your subscription

More functionality and data for company and portfolio analysis is available by subscription

Subscribe

Other

IFRS
Reporting Annual Quarterly
2016 2017 2018 2019 2020 2021 2022 2023 2024 LTM CAGR 5
НИОКР, млрд
0 0 0 0 0 0 0 0 0
Всего задолженность
16.19 16.72 18.38 23.17 23.17 9.38
Персонал, чел
500000 500000 471600 463100 -1.90