sharpfokus
  • Files1
  • ADMF
  • AVIA
  • BBTN
  • BNII
  • ITMG
  • MEGA
  • MPMX
  • MTEL
  • NISP
  • VICI
  • WOMF4
  • Home
  • CVX
  • FB
  • MAR
  • TSN
  • TWTR
  • Presents
  • Kenny
  • Ranks
  • Palmweekly
  • WEHA
  • stockbit
  • TIRA
Picture
Other stocks here

HD, a 16% higher target price
Current 411 Target 478 +16%

December 30th 2021
1 minute read

Sales declined seasonally -10%
  • Sales declined seasonally -10% in the third quarter to 36,820 million dollars vs our 36,595 million dollars forecast.
  • This brings the quarterly average to 3% growth.
  • We predict average growth of 3% in this next 12 months to bring sales to 40,605 million dollars in the third quarter of 2022.
​
Costs flat, profit down on higher non cash costs
  • The cash cost ratio went from -86% to -87% profit from 4,807 to 4,129 million dollars in the third quarter from higher non cash costs.
  • The average cost ratio is at -87% now.
  • We use the latest -87% cost ratio to predict a higher 4,385 million dollars profit in the third quarter of 2022.
​
Cashflow lower on working capital
  • Free cashflow went from 3,116 to 2,744 million dollars in the third quarter with -695 million dollars investment Cashflow & negative working capital.
  • Average quarterly Cashflow is at 3,028 million dollars now.
  • We assume -695 million dollars investment spending which with higher sales, flat working capital gives a higher 4,531 million dollars Cashflow in the third quarter of 2022.
​
Balance sheet higher leverage
  • Cash increased 4,566 to 5,067 million dollars in the third quarter.
  • Liabilities increased 68,700 to 71,996 million dollars so net cash worsened -64,134 to -66,929 million dollars.
  • With our forecast cashflow & a -13,355 million dollars equity payout -12,649 million dollars liabilities payment net cash will be -54,280 million dollars in 12 months time.
​
Valuation, revised up to a 16% higher target price
  • HD capital from the last 19 quarters improved 46,905 to 49,180 million dollars in the third quarter with 2,909 million dollars new liabilities, a -5,184 million dollars equity payout & will be higher 67,000 million dollars in12 months time.
  • At the current market value of 429,000 million dollars based on our forecasts it’s at 5.92 X assets with a 3.8 years payback & a 1.2% yield.
  • Our cashflow forecast is 17,820 million dollars which means an 24 X valuation. A 28 X valuation gives a 16% higher target price of 478 dollars.
Data, model & charts
  • Files1
  • ADMF
  • AVIA
  • BBTN
  • BNII
  • ITMG
  • MEGA
  • MPMX
  • MTEL
  • NISP
  • VICI
  • WOMF4
  • Home
  • CVX
  • FB
  • MAR
  • TSN
  • TWTR
  • Presents
  • Kenny
  • Ranks
  • Palmweekly
  • WEHA
  • stockbit
  • TIRA