sharpfokus
  • Asjmp
  • English
  • ABMM
  • ADMF
  • AVIA
  • BBTN
  • BISI
  • BLTZ
  • BNII
  • BNLI
  • BRMS
  • BUKK
  • BVIC
  • CMNP
  • CMNT
  • DLTA
  • DRMA
  • DVLA
  • DYAN
  • EAST
  • FASW
  • GOTO
  • HEXA
  • INTD
  • IPPE
  • ITMG
  • JIHD
  • KDSI
  • KIJA
  • MEGA
  • MERK
  • MMLP
  • MPMX
  • MTDL
  • MTEL
  • NFCX
  • NISP
  • OKAS
  • SLIS
  • STAA
  • STTP
  • TGKA
  • VICI
  • WEHA
  • WIRG
  • WOMF
  • Home
  • BERK
  • CVX
  • CVX
  • FB
  • GOLD
  • INTC
  • MAR
  • PEP
  • PG
  • TSN
  • TWTR
  • TXN
  • Presents
  • Kenny
  • Ranks
  • Palmweekly
  • Stockbit
  • TIRA
  • Meeting
  • MBAP
  • HTUFS
  • 7Steps
  • INTA
  • Model
  • MCOL
  • ESTI
  • Intern
  • Stockbitapp
  • SONA
  • Model1
  • Pdf
  • OBMD
  • PSKT
  • DGIK
  • Data
  • Above
  • IATA
  • mm
  • Untitled
  • Capital
Picture
Other stocks here

HD looking sharp with a 3% yield forecast

HD Current 269 Target 461 + 71%

Jun 23, 2022
1 minute read

Sales grew 9%
Last 5 quarters
16% 10% -10% -3% 9%
  • Sales grew 9% in the first quarter to 38,908 million dollars -2% below our 39,692 million dollars forecast.
  • This brings the average to 1% growth.
  • We predict faster average growth of 3% in this next 12 months to bring sales to 42,864 million dollars in the first quarter 2023.

Costs down profit up
Last 5 quarters
-87% -86% -87% -89% -87%
  • The cash cost ratio went from -89% to -87% profit from 3,352 to 4,231 million dollars in the first quarter.
  • The average cost ratio is at -87% now.
  • We use the average -87% cost ratio to predict a higher 4,623 million dollars profit in the first quarter 2023.

Cashflow higher
Last 5 quarters million dollars
5,782, 2,707, 2,765, 2,348, 3,088
  • Free cashflow went from 2,348 to 3,088 million dollars in the first quarter with -701 million dollars investment spending.
  • Average quarterly Cashflow is at 2,727 million dollars now.
  • We assume the same -701 million dollars investment spending which with higher sales gives a record 4,840 million dollars Cashflow in the first quarter 2023.

Balance sheet net cash worsened
Last 5 quarters million dollars
-64,171 -64,134 -66,929 -71,229 -75,432
  • Cash increased 2,343 to 2,844 million dollars in the first quarter.
  • Liabilities increased 73,572 to 78,276 million dollars so net cash worsened -71,229 to -75,432 million dollars .
  • With our forecast cashflow & a -9,055 million dollars equity payout -9,923 million dollars liabilities payment net cash will be -65,509 million dollars in 12 months time.
​
Capital paid improved , a 71% higher target price
Last 5 quarters million dollars
42,141, 46,905, 49,180, 54,191, 56,770
  • HD 21 quarter capital paid improved 54,191 to 56,770 million dollars in the first quarter with + 1,868 million dollars liabilities -4,265 million dollars equity & will be 75,748 million dollars in12 months time.
  • At the current market value of 276,899 million dollars based on our forecasts it’s at 3.66 X assets with a 4 years payback & a 3% yield.
  • Our cashflow forecast is 18,978 million dollars which means a 15 X valuation. A 25 X valuation gives a 71% higher target price 461 dollars.
MODEL & CHARTS
  • Asjmp
  • English
  • ABMM
  • ADMF
  • AVIA
  • BBTN
  • BISI
  • BLTZ
  • BNII
  • BNLI
  • BRMS
  • BUKK
  • BVIC
  • CMNP
  • CMNT
  • DLTA
  • DRMA
  • DVLA
  • DYAN
  • EAST
  • FASW
  • GOTO
  • HEXA
  • INTD
  • IPPE
  • ITMG
  • JIHD
  • KDSI
  • KIJA
  • MEGA
  • MERK
  • MMLP
  • MPMX
  • MTDL
  • MTEL
  • NFCX
  • NISP
  • OKAS
  • SLIS
  • STAA
  • STTP
  • TGKA
  • VICI
  • WEHA
  • WIRG
  • WOMF
  • Home
  • BERK
  • CVX
  • CVX
  • FB
  • GOLD
  • INTC
  • MAR
  • PEP
  • PG
  • TSN
  • TWTR
  • TXN
  • Presents
  • Kenny
  • Ranks
  • Palmweekly
  • Stockbit
  • TIRA
  • Meeting
  • MBAP
  • HTUFS
  • 7Steps
  • INTA
  • Model
  • MCOL
  • ESTI
  • Intern
  • Stockbitapp
  • SONA
  • Model1
  • Pdf
  • OBMD
  • PSKT
  • DGIK
  • Data
  • Above
  • IATA
  • mm
  • Untitled
  • Capital