MSFT Q1 2023 Steering
MSFT Q1 2023 excel
So basically, MSFT does a tremendous job of giving us very detailed steering as you possibly can see within the first image. I can principally plug and chug that knowledge into an excel spreadsheet and make a revenue assertion. From that revenue assertion I then should make assumptions like what their diluted shares is likely to be based mostly off of earlier stories. I can then calculate an eps and calculate PE with ahead numbers.
We’re calculating YOY modifications from q1 2022 to q1 2023 and their clever cloud income section is trying to be the perfect with about 20% income progress.
Complete income progress is trying to be round 8-11%
EPS calculation is about 2.28 to 2.36 but when we’re going conservative we needs to be utilizing the smaller of the 2.
4 quarters of eps provides us a trailing 12 month eps of 9.21 and share worth is 242.12 giving us a present PE of 26.29 which is under common from what we have been seeing final 5 years. Remember that charges are placing strain on fairness multiples as a result of we are able to basically get fairly threat free yields from treasuries and we are able to additionally get respectable yields from Aaa company bonds.
