Followers | 681 |
Posts | 141463 |
Boards Moderated | 35 |
Alias Born | 03/10/2004 |
Monday, December 11, 2023 12:23:20 PM
By: Barchart | December 11, 2023
Microsoft Corp (MSFT) stock is still undervalued based on its free cash flow upside in the next year. MSFT stock could be worth 39% more or $518 per share based on $96 billion in FCF estimates next year. This is also based on a potential 2.5% FCF yield valuation.
I show how this works out in this article below. I also show a cheap way for existing shareholders to play this for extra income by shorting out-of-the-money (OTM) put options.
I already discussed this in my prior Barchart article on Nov. 14, but now I am updating this projection. Since then, MSFT stock has risen to $374.23 as of Friday, Dec. 8.
FCF Estimates Close To $100 Billion In The Next 12 Months
My target price is based on its free cash flow (FCF) and where it could rise in the next 12 months (NTM). For example, it made $20.7 billion in FCF in its latest quarter ending Sept. 30, according to page 5 of its shareholder deck. That was up 22% YoY.
Microsoft shareholder deck FY 2024 Q1 ending Sept. 30, 2023 - page 5
More importantly, this represented 36.6% of the total revenue of $56.5 billion for the quarter. That 37% FCF margin implies that if sales reach $243 billion this fiscal year (ending June 30, based on analysts' estimates for 2024) free cash flow could rise to $90 billion. That is seen by multiplying $243 billion by 0.37.
And for the year ending June 2025, analysts forecast $276.75 billion, FCF could rise to $102.4 billion. That implies that the average FCF estimate over the NTM is $96.2 billion.
That is close to $100 billion in FCF projections sometime in the next 2 years. How will the market value this?
MSFT Stock Could Be Worth $518 Per Share
Here is how I think the market will value MSFT stock. In the last 12 months (LTM) Microsoft has generated $95.967 billion in cash flow from operations (CFFO). After deducting $31.741 billion in capex spending, its LTM FCF was $63.226 billion. These figures can be seen in Seeking Alpha's cash flow statements page for the LTM ending Sept. 30.
Now since Microsoft presently has a market capitalization of $2,773 billion, that means that the market values the company with a 2.28% FCF metric. This is seen by dividing its $63.2 billion by its market cap (i.e., $63.22b / $2,773b = 0.0228).
So, we can use that FCF yield metric to value its NTM FCF, i.e., $96.2 billion. For example, if we use a more conservative FCF yield of 2.5% we get a market value estimate of $3,848 billion (i.e., $96.2b/.025 = $3,848 billion).
That market value estimate is 38.8% over today's market cap of $2,773 billion. In other words, MSFT stock is worth 39% more. That puts its price target at $518 per share (i.e., 1.39 x $374.23 per share).
So how can existing shareholders play this?
Shorting OTM Puts For Extra Income
One way for investors in MSFT stock to make money while they wait for the stock to hit this price target is to sell short out-of-the-money (OTM) put options. It's best to focus on puts that expire in near-term expiration periods like the Dec. 29 period, for example. That is just 3 weeks away.
For example, the $357.50 strike price put trades for $1.95 on the bid side. That play is 3% out-of-the-money (i.e., below today's price) and yields 0.545% (i.e., $1.95 / $357.50).
A more conservative play is the $350 strike price which trades for 99 cents. That is 5% OTM and yields 0.282% to the short seller of these puts.
MSFT put options expiring Dec. 29 - Barchart - As of Dec. 11, 2023
In any case, the annualized returns for both are still attractive. For example, the $357.50 strike price put yield works out to an annualized expected return (ER) of 9.27% (i.e., 0.545% x 17). This assumes the same trade can be repeated 17 times a year. Obviously, that won't always happen, but the ER calculation highlights the potential return at this rate.
The $350 strike price put yield works out to an annualized ER of 4.80% (i.e., 0.283% x 17). This has less of a chance of ever getting exercised since the strike price is 5% below today's price. But even if that happens the investor's obligation is simply to buy 100 MSFT shares at $350 per share. That would be done by the $35,000 that the investor has to secure with the brokerage firm at the time of entering the order to “Sell to Open” 1 put contract at $350 per share for expiration on Dec. 29.
The bottom line is the MSFT is worth almost 40% more. Existing investors can get paid by shorting OTM strike prices in near-term expiration periods.
Read Full Story »»»
DiscoverGold
Information posted to this board is not meant to suggest any specific action, but to point out the technical signs that can help our readers make their own specific decisions. Caveat emptor!
• DiscoverGold
Recent MSFT News
- CalPERS to Oppose Exxon Mobil Directors; Microsoft Unveils Copilot+ PCs with AI Focus, and More News • IH Market News • 05/21/2024 11:18:35 AM
- Coursera Announces Four New Entry-Level Certificates from Microsoft to Help Learners Pursue High-demand Jobs • Business Wire • 05/20/2024 12:30:00 PM
- Li Auto Stocks Drop Post Earnings; Calhoun Re-elected to Boeing Board, and More News • IH Market News • 05/20/2024 11:03:22 AM
- OpenAI’s Reddit Partnership Boosts Shares by 14%, Microsoft Embraces AMD Chips for AI, and More News • IH Market News • 05/17/2024 11:36:28 AM
- Chubb Stock Soars 9% with Berkshire Acquisition, AST SpaceMobile jumps 37% on AT&T deal, and More News • IH Market News • 05/16/2024 11:27:07 AM
- Buterin Proposes New Ethereum Fee Model, Unofficial Gamestop Memecoin Soars, and More Crypto News • IH Market News • 05/14/2024 06:56:21 PM
- Arm Sets 2025 Target for AI Chip Development, Amazon and Microsoft Commit Billions to French Investments, and More • IH Market News • 05/13/2024 11:16:03 AM
- Novavax Surges 57% Post $1.4 Billion Sanofi Deal; Apple Boosts Data Centers with AI and Internal Chips, and More News • IH Market News • 05/10/2024 12:02:56 PM
- Microsoft announces $3.3 billion investment in Wisconsin to spur artificial intelligence innovation and economic growth • PR Newswire (US) • 05/08/2024 01:45:00 PM
- Meta Platforms Expands AI Ads, Apple Boosts iPhone Shipments, and More Highlights • IH Market News • 05/08/2024 12:27:48 PM
- Microsoft and LinkedIn release the 2024 Work Trend Index on the state of AI at work • PR Newswire (US) • 05/08/2024 12:00:00 PM
- Tesla’s April Sales Down 18% in China, Amazon’s Multi-Billion Dollar Cloud Expansion in Singapore, and More News • IH Market News • 05/07/2024 11:44:00 AM
- Form EFFECT - Notice of Effectiveness • Edgar (US Regulatory) • 05/07/2024 04:15:33 AM
- Form 424B3 - Prospectus [Rule 424(b)(3)] • Edgar (US Regulatory) • 05/06/2024 08:20:48 PM
- Brookfield and Microsoft Collaborating to Deliver Over 10.5 GW of New Renewable Power Capacity Globally • GlobeNewswire Inc. • 05/01/2024 10:30:00 AM
- Alphabet CEO’s Billion-Dollar Wealth, Microsoft’s $1.7B Indonesia Investment, and More News • IH Market News • 04/30/2024 11:58:40 AM
- Axel Springer et Microsoft élargissent leur partenariat dans les domaines de la publicité, de l'IA, du contenu et des services de Microsoft Azure • PR Newswire (Canada) • 04/29/2024 03:00:00 PM
- Axel Springer and Microsoft expand partnership across advertising, AI, content and Azure services • PR Newswire (Canada) • 04/29/2024 03:00:00 PM
- Axel Springer and Microsoft expand partnership across advertising, AI, content and Azure services • PR Newswire (US) • 04/29/2024 03:00:00 PM
- U.S. Stocks May See Further Upside In Early Trading • IH Market News • 04/29/2024 01:05:53 PM
- Conduent Collaborates with Microsoft on Generative AI to Drive Innovation in Business Process Solutions • Business Wire • 04/29/2024 12:43:00 PM
- U.S. Futures Rise in Pre-Market Trading Amid Key Federal Reserve Meeting and Earnings Week Ahead • IH Market News • 04/29/2024 11:12:54 AM
- Philips Stocks Soar 47% Following US Deal, Tesla Bolsters Presence in China, and More News • IH Market News • 04/29/2024 11:11:24 AM
- U.S. Stocks Rally On Upbeat Tech Earnings • IH Market News • 04/26/2024 08:30:27 PM
- Exxon Mobil Net Profit Drops 28% to $8.22 Billion, Atlassian Surprises with Revenue Boost and Co-CEO Exit, and More in Earnings • IH Market News • 04/26/2024 11:47:51 AM
"Defo's Morning Briefing" Set to Debut for "GreenliteTV" • GRNL • May 21, 2024 2:28 PM
North Bay Resources Announces 50/50 JV at Fran Gold Project, British Columbia; Initiates NI 43-101 Resources Estimate and Bulk Sample • NBRI • May 21, 2024 9:07 AM
Greenlite Ventures Inks Deal to Acquire No Limit Technology • GRNL • May 17, 2024 3:00 PM
Music Licensing, Inc. (OTC: SONG) Subsidiary Pro Music Rights Secures Final Judgment of $114,081.30 USD, Demonstrating Strength of Licensing Agreements • SONGD • May 17, 2024 11:00 AM
VPR Brands (VPRB) Reports First Quarter 2024 Financial Results • VPRB • May 17, 2024 8:04 AM
ILUS Provides a First Quarter Filing Update • ILUS • May 16, 2024 11:26 AM