Stock Market

Hey everyone! It’s my first post here. I wanted to share what we can expect for this next quarter on MSFT. : stocks


MSFT Q1 2023 Guidance

MSFT Q1 2023 excel

So essentially, MSFT does an amazing job of giving us very detailed guidance as you can see in the first picture. I can basically plug and chug that data into an excel spreadsheet and make a income statement. From that income statement I then have to make assumptions like what their diluted shares might be based off of previous reports. I can then calculate an eps and calculate PE with forward numbers.

We’re calculating YOY changes from q1 2022 to q1 2023 and their intelligent cloud revenue segment is looking to be the best with about 20% revenue growth.

Total revenue growth is looking to be around 8-11%

EPS calculation is about 2.28 to 2.36 but if we’re going conservative we should be using the smaller of the two.

4 quarters of eps gives us a trailing 12 month eps of 9.21 and share price is 242.12 giving us a current PE of 26.29 which is below average from what we’ve been seeing last 5 years. Keep in mind that rates are putting pressure on equity multiples because we can essentially get rather risk free yields from treasuries and we can also get decent yields from Aaa corporate bonds.



Source link

/u/Nearby-Ad-2058
/u/Nearby-Ad-2058

Related articles

Landbridge completes acquisition of 46,000 acres in Delaware basin

LandBridge has closed its beforehand introduced acquisition of roughly 46,000 largely contiguous floor...

ADA Faces Retest Of $0.8119 As Technical Indicators Flip Bearish

Cardano (ADA) is dealing with rising bearish momentum, with its worth nearing a crucial help stage at $0.8119. This potential retest alerts a pivotal second for the cryptocurrency as market situations flip unfavorable.  Current...

Redfin’s 2025 Housing Market Predictions

<div id="web page" x-data="sidebarAds(24percent7C&utm_source=Biggerpercent20Pockets&utm_term=Biggerpercent20Pockets","linkTitle":"Schedule a Name At the moment","id":"65d4be7b89ca4","impressionCount":"599813","dailyImpressionCount":"771","impressionLimit":"878328","dailyImpressionLimit":"2780","r720x90":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/08/REI-Nation-X-BP-Weblog-Advert-720x90-1.png","r300x250":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/08/REI-Nation-X-BP-Weblog-Advert-300x250-1.png","r300x600":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/08/REI-Nation-X-BP-Weblog-Advert-300x600-1.png","r320x50":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/08/REI-Nation-X-BP-Weblog-Advert-320x50-1.png","r720x90Alt":"","r300x250Alt":"","r300x600Alt":"","r320x50Alt":""},{"sponsor":"Heart Avenue Lending","description":"","imageURL":null,"imageAlt":null,"title":"","physique":"","linkURL":"https://centerstreetlending.com/bp/","linkTitle":"","id":"664ce210d4154","impressionCount":"328805","dailyImpressionCount":"713","impressionLimit":"600000","dailyImpressionLimit":"2655","r720x90":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/05/CSL_Blog-Ad_720x90-1.png","r300x250":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/05/CSL_Blog-Ad_300x250-2.png","r300x600":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/05/CSL_Blog-Ad_300x600-2.png","r320x50":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/05/CSL_Blog-Ad_320x50.png","r720x90Alt":"","r300x250Alt":"","r300x600Alt":"","r320x50Alt":""},{"sponsor":"CV3 Monetary","description":"","imageURL":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/07/Brand-512x512-1.png","imageAlt":"","title":"","physique":"","linkURL":"https://cv3financial.com/financing-biggerpockets/?utm_source=biggerpockets&utm_medium=web site&utm_campaign=august&utm_term=bridge&utm_content=banner","linkTitle":"","id":"66a7f395244ed","impressionCount":"144069","dailyImpressionCount":"579","impressionLimit":"636364","dailyImpressionLimit":"4187","r720x90":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/07/CV3-720x90-1.png","r300x250":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/07/CV3-300x250-1.png","r300x600":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/07/CV3-300x600-1.png","r320x50":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/07/CV3-320x50-1.png","r720x90Alt":"","r300x250Alt":"","r300x600Alt":"","r320x50Alt":""},{"sponsor":"Baselane","description":"Advert copy A","imageURL":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/09/SquareLogo-MidnightOnWhite-1.png","imageAlt":"","title":"","physique":"","linkURL":"https://www.baselane.com/lp/bigger-pockets?utm_source=partner_biggerpockets&utm_medium=Content material&utm_campaign=bp_blog_ad&utm_term=rebranded_v3","linkTitle":"","id":"66b39df6e6623","impressionCount":"125335","dailyImpressionCount":"526","impressionLimit":"250000","dailyImpressionLimit":"1713","r720x90":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/11/720x90.png","r300x250":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/11/300x250.png","r300x600":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/11/300x600.png","r320x50":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/11/grow_business_not_to_do_320x50.png","r720x90Alt":"","r300x250Alt":"","r300x600Alt":"","r320x50Alt":""},{"sponsor":"Baselane","description":"Advert copy B","imageURL":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/09/SquareLogo-MidnightOnWhite-1.png","imageAlt":"","title":"","physique":"","linkURL":"https://www.baselane.com/lp/bigger-pockets?utm_source=partner_biggerpockets&utm_medium=Content material&utm_campaign=bp_blog_ad&utm_term=rebranded_v4","linkTitle":"","id":"66b39df70adac","impressionCount":"136179","dailyImpressionCount":"503","impressionLimit":"250000","dailyImpressionLimit":"1713","r720x90":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/11/Copy-of-720x90-1.png","r300x250":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/11/Copy-of-300x250-1.png","r300x600":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/11/Copy-of-300x600-1.png","r320x50":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/11/Copy-of-320x50-1.png","r720x90Alt":"","r300x250Alt":"","r300x600Alt":"","r320x50Alt":""},{"sponsor":"","description":"","imageURL":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/08/REI-Nation-Brand.png","imageAlt":"","title":"","physique":"","linkURL":"https://hubs.ly/Q02LzKH60","linkTitle":"","id":"66c3686d52445","impressionCount":"148591","dailyImpressionCount":"559","impressionLimit":"500000","dailyImpressionLimit":"6173","r720x90":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/08/REI-Nation-X-BP-Weblog-Advert-720x90-1.png","r300x250":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/08/REI-Nation-X-BP-Weblog-Advert-300x250-1.png","r300x600":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/08/REI-Nation-X-BP-Weblog-Advert-300x600-1.png","r320x50":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/08/REI-Nation-X-BP-Weblog-Advert-320x50-1.png","r720x90Alt":"","r300x250Alt":"","r300x600Alt":"","r320x50Alt":""},{"sponsor":"1-800 Accountant","description":"","imageURL":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/12/Logo_Square_No-Model-Identify.png","imageAlt":"","title":"","physique":"","linkURL":"https://1800accountant.com/lp/biggerpockets?utm_source=biggerpockets&utm_medium=cpc&utm_campaign=tof&utm_content=banner_V1","linkTitle":"","id":"67572ea6e4db7","impressionCount":"8576","dailyImpressionCount":"584","impressionLimit":"66667","dailyImpressionLimit":"3031","r720x90":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/12/V1-720x90-1.png","r300x250":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/12/V1-300x250-1.png","r300x600":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/12/V1-300x600-1.png","r320x50":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/12/V1_320x50.png","r720x90Alt":"","r300x250Alt":"","r300x600Alt":"","r320x50Alt":""},{"sponsor":"1-800 Accountant","description":"","imageURL":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/12/Logo_Square_No-Model-Identify.png","imageAlt":"","title":"","physique":"","linkURL":"https://1800accountant.com/lp/biggerpockets?utm_source=biggerpockets&utm_medium=cpc&utm_campaign=tof&utm_content=banner_V2","linkTitle":"","id":"67572ea706256","impressionCount":"8643","dailyImpressionCount":"563","impressionLimit":"66667","dailyImpressionLimit":"3031","r720x90":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/12/V2_720x90.png","r300x250":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/12/v2_320x250.png","r300x600":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/12/V2-300x600-1.png","r320x50":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/12/V2_320x50.png","r720x90Alt":"","r300x250Alt":"","r300x600Alt":"","r320x50Alt":""},{"sponsor":"1-800 Accountant","description":"","imageURL":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/12/Logo_Square_No-Model-Identify.png","imageAlt":"","title":"","physique":"","linkURL":"https://1800accountant.com/lp/biggerpockets?utm_source=biggerpockets&utm_medium=cpc&utm_campaign=tof&utm_content=banner_V3","linkTitle":"","id":"67572ea71c568","impressionCount":"9610","dailyImpressionCount":"672","impressionLimit":"66667","dailyImpressionLimit":"3031","r720x90":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/12/V3_720x90.png","r300x250":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/12/V3_300x250.png","r300x600":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/12/V3-300x600-1.png","r320x50":"https://www.biggerpockets.com/weblog/wp-content/uploads/2024/12/V3_320x50.png","r720x90Alt":"","r300x250Alt":"","r300x600Alt":"","r320x50Alt":""}])"> ...

Study a brand new language in your phrases — Lifetime entry to Babbel is at your fingertips

TL;DR: A lifetime subscription to Babbel offers you entry to 14 languages with on-demand classes for simply $129.97—by December 31. The stress of conventional language courses will be overwhelming for many who dislike talking English...

Shares Week Forward: Treasury Auctions May Drive Additional Bear Steepening

Will probably be a holiday-shortened buying and selling week as a result of Christmas vacation. Markets within the US will shut early on Christmas Eve, December twenty fourth, at 1 PM Jap and...
spot_img

Latest articles

LEAVE A REPLY

Please enter your comment!
Please enter your name here

© Copyright - Premium Alpha

WP2Social Auto Publish Powered By : XYZScripts.com