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

MSFT, Cashflow jumps towards 20 billion dollars
​Current 288 Target 342 +18%

WATCH THE VIDEO
January 26 2022
1 minute read

Sales jumped 14%
  • Sales jumped 14% in the fourth quarter to 51,728 million dollars vs our 50,767 million dollars forecast.
  • This brings the quarterly average to 5% growth.
  • We predict average growth of 4% in this next 12 months to bring sales to 59,494 million dollars in the fourth quarter of 2022.
​
Costs down profit down on higher non cash costs
  • The cash cost ratio went from -58% to -54% but profit from 20,505 to 18,765 million dollars on higher non cash costs in the fourth quarter.
  • The average cost ratio is at -55% now.
  • We use a higher average -56% cost ratio to predict a 21,946 million dollars profit in the fourth quarter of 2022.
​
Cashflow jumps higher
  • Free cashflow went from 13,275 to 18,169 million dollars in the fourth quarter with a better -1,161 million dollars investment Cashflow.
  • Average quarterly Cashflow is at 15,076 million dollars now.
  • We assume higher -5,865 million dollars investment spending which with higher sales gives a 20,546 million dollars Cashflow in the fourth quarter of 2022.
​
Balance sheet lower leverage
  • Cash increased 19,165 to 20,604 million dollars in the fourth quarter.
  • Liabilities declined 183,440 to 180,379 million dollars so net cash improved -164,275 to -159,775 million dollars
  • With our forecast cashflow & a -63,118 million dollars equity payout -10,180 million dollars liabilities payment net cash will be -149,595 million dollars in 12 months time.
​
Valuation, a 18% higher target price
  • MSFT capital paid from the last 27 quarters improved 169,007 to 180,993 million dollars in the fourth quarter. with a -11,986 million dollars equity payout & will be 254,291 million dollars in12 months time.
  • At the current market value of 2,166,000 million dollars based on our forecasts it’s at 6 X assets with a 4 years payback & a 2.9% yield.
  • Our cashflow forecast is 73,298 million dollars which means an 30 X valuation. A 35 X valuation gives a 18% higher target price of 342 dollars.
MODEL, DATA & 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