sharpfokus
  • Asjmp
  • English
  • ABMM
  • ADMF
  • AVIA
  • BBTN
  • BISI
  • BLTZ
  • BNII
  • BNLI
  • BRMS
  • BUKK
  • BVIC
  • CMNP
  • CMNT
  • DLTA
  • DRMA
  • DVLA
  • DYAN
  • EAST
  • FASW
  • GOTO
  • HEXA
  • IKBI
  • INTD
  • IPPE
  • ITMG
  • JIHD
  • KDSI
  • KIJA
  • MEGA
  • MERK
  • MMLP
  • MPMX
  • MTDL
  • MTEL
  • NFCX
  • NISP
  • OKAS
  • RIGS
  • SLIS
  • STAA
  • STTP
  • TGKA
  • VICI
  • WEHA
  • WIRG
  • WOMF
  • Home
  • BERK
  • CL
  • CVX
  • CVX
  • FB
  • GOLD
  • INTC
  • IP
  • MAR
  • PG
  • PEP
  • T
  • TSN
  • TWTR
  • TXN
  • V
  • 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
  • Subscribe
  • SharpfokUS
Picture
Other stocks here

GOOG less sharp as sales growth slows

GOOG Current 108 Target 123 + 14%

Jul 27, 2022
1 minute read

Sales declined -9%
Last 5 quarters million dollars
61,880 65,118 75,325 68,011 61,680
  • Sales declined -9% in the second quarter to 61,680 million dollars -4% below our 64,147 million dollars forecast.
  • This brings the average to 0% growth.
  • We predict average growth of 3% in this next 12 months to bring sales to 18,902 million dollars in the second quarter 2023.

Costs down profit up
Last 5 quarters
-62% -69% -61% -66% -62%
  • The cash cost ratio went from -66% to -62% profit from 16,436 to 18,525 million dollars in the second quarter.
  • The average cost ratio is at -64% now.
  • We use an average -64% cost ratio to predict a 18,902 million dollars profit in the second quarter 2023.

Cashflow lower
Last 5 quarters million dollars
12,816 15,489 13,918 16,055 12,816
  • Free cashflow went from 16,055 to 12,816 million dollars in the second quarter with -9,074 million dollars investment cashflow.
  • Average quarterly Cashflow is at 14,570 million dollars now.
  • We assume the same -9,074 million dollars investment spending which with lower sales gives 14,961 million dollars average Cashflow in the next 12 months.
​
Balance sheet net cash worsened
Last 5 quarters million dollars
-74,192 -79,117 -76,127 -82,206 -86,688
  • Cash increased 20,886 to 20,945 million dollars in the second quarter.
  • Liabilities increased 103,092 to 107,633 million dollars so net cash worsened -82,206 to -86,688 million dollars .
  • With our forecast cashflow & a -66,437 million dollars equity payout 6,591 million dollars liabilities payment net cash will be -93,279 million dollars in 12 months time.
​
Capital paid improved , a 14% higher target price
Last 5 quarters million dollars
107,023 122,277 138,788 155,004 171,295
  • GOOG 26 quarter capital paid improved 155,004 to 171,295 million dollars in the second quarter with + 1,042 million dollars from liabilities + 15,249 million dollars from equity & will be 231,141 million dollars in12 months time.
  • At the current market value of 1,420,289 million dollars based on our forecasts it’s at 3.8 X assets with a 6 years payback & a 5% yield.
  • Our cashflow forecast is 59,846 million dollars which means a 24 X valuation. A 27 X valuation gives a 14% higher target price 123 dollars.
Picture
  • Asjmp
  • English
  • ABMM
  • ADMF
  • AVIA
  • BBTN
  • BISI
  • BLTZ
  • BNII
  • BNLI
  • BRMS
  • BUKK
  • BVIC
  • CMNP
  • CMNT
  • DLTA
  • DRMA
  • DVLA
  • DYAN
  • EAST
  • FASW
  • GOTO
  • HEXA
  • IKBI
  • INTD
  • IPPE
  • ITMG
  • JIHD
  • KDSI
  • KIJA
  • MEGA
  • MERK
  • MMLP
  • MPMX
  • MTDL
  • MTEL
  • NFCX
  • NISP
  • OKAS
  • RIGS
  • SLIS
  • STAA
  • STTP
  • TGKA
  • VICI
  • WEHA
  • WIRG
  • WOMF
  • Home
  • BERK
  • CL
  • CVX
  • CVX
  • FB
  • GOLD
  • INTC
  • IP
  • MAR
  • PG
  • PEP
  • T
  • TSN
  • TWTR
  • TXN
  • V
  • 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
  • Subscribe
  • SharpfokUS