Share your opinion about this

1
Comment
Favorite

Share your opinion about this news…

Microsoft: Currently Overvalued, But It's Set To Be A Potential Outperformer Throughout 2033

Since Microsoft has too many segments, I will focus on the ones providing the most revenue: Cloud, Office Products and Licenses, and Windows OS. In the PaaS and IaaS cloud markets, Microsoft boasts a 24% market share, which puts Microsoft in second place behind Amazon.com, Inc. which holds 31%. However, what sets Microsoft apart is that its market share increased by 4% since 2020 when it was 20%. Meanwhile, Amazon's market share lost 1%. Statista Statista On the other ha

Microsoft: Currently Overvalued, But It's Set To Be A Potential Outperformer Throughout 2033

Disclaimer: Investing carries risk. This is not financial advice. The above content should not be regarded as an offer, recommendation, or solicitation on acquiring or disposing of any financial products, any associated discussions, comments, or posts by author or other users should not be considered as such either. It is solely for general information purpose only, which does not consider your own investment objectives, financial situations or needs. TTM assumes no responsibility or warranty for the accuracy and completeness of the information, investors should do their own research and may seek professional advice before investing.

Report

Comment

Top
Latest

No comments yet

Most Discussed

Terms and Conditions·Privacy Policy

Company: TTMF Limited. Tech supported by Xiangshang Yixin.

Email：uservice@ttm.financial

{"i18n":{"language":"en_US"},"data":{"magic":2,"id":322801896198232,"tweetId":"322801896198232","gmtCreate":1719839291536,"gmtModify":1719842608258,"author":{"id":3584669030797731,"idStr":"3584669030797731","authorId":3584669030797731,"authorIdStr":"3584669030797731","name":"Elaiyaraja","avatar":"https://community-static.tradeup.com/news/6eb7cde86fb1c4f53b4d68adbae339d2","vip":1,"userType":1,"introduction":"","boolIsFan":false,"boolIsHead":false,"crmLevel":7,"crmLevelSwitch":1,"currentWearingBadge":{"badgeId":"1026c425416b44e0aac28c11a0848493-2","templateUuid":"1026c425416b44e0aac28c11a0848493","name":"Senior Tiger","description":"Join the tiger community for 1000 days","bigImgUrl":"https://static.tigerbbs.com/0063fb68ea29c9ae6858c58630e182d5","smallImgUrl":"https://static.tigerbbs.com/96c699a93be4214d4b49aea6a5a5d1a4","grayImgUrl":"https://static.tigerbbs.com/35b0e542a9ff77046ed69ef602bc105d","redirectLinkEnabled":0,"hasAllocated":1,"isWearing":1,"stampPosition":0,"hasStamp":0,"allocationCount":1,"allocatedDate":"2024.02.16","individualDisplayEnabled":0},"individualDisplayBadges":[],"fanSize":1,"starInvestorFlag":false},"themes":[],"images":[],"coverImages":[],"html":"<html><head></head><body>Share your opinion about this news…</body></html>","htmlText":"<html><head></head><body>Share your opinion about this news…</body></html>","text":"Share your opinion about this news…","highlighted":1,"essential":1,"paper":1,"likeSize":1,"commentSize":0,"repostSize":0,"favoriteSize":0,"link":"https://ttm.financial/post/322801896198232","repostId":2447608276,"repostType":2,"repost":{"id":"2447608276","pubTimestamp":1719813642,"share":"https://www.laohu8.com/m/news/2447608276?lang=&edition=full","pubTime":"2024-07-01 14:00","market":"sh","language":"en","title":"Microsoft: Currently Overvalued, But It's Set To Be A Potential Outperformer Throughout 2033","url":"https://stock-news.laohu8.com/highlight/detail?id=2447608276","media":"seekingalpha","summary":"Since Microsoft has too many segments, I will focus on the ones providing the most revenue: Cloud, Office Products and Licenses, and Windows OS. In the PaaS and IaaS cloud markets, Microsoft boasts a 24% market share, which puts Microsoft in second place behind Amazon.com, Inc. which holds 31%. However, what sets Microsoft apart is that its market share increased by 4% since 2020 when it was 20%. Meanwhile, Amazon's market share lost 1%. Statista Statista On the other ha","content":"<html><head></head><body><ul style=\"\"><li>Microsoft&#39;s valuation is upgraded from &#34;hold&#34; to &#34;buy&#34; with a near-term target of $417.30 and a 2033 target of $1,099.90, implying 14.6% annual returns.</li><li>The Company&#39;s growth is driven by its cloud business (Azure), and acquisitions like Activision-Blizzard.</li><li>MSFT holds a 24% cloud market share (second to Amazon&#39;s 31%) and dominates with a 72.17% share in the PC OS market.</li><li>Microsoft&#39;s TAM is expected to grow from $754.1B in 2024 to $1.70T by 2029, with the cloud segment driving most of the growth.</li><li>The valuation (which uses a DCF model) suggests 14.6% annual returns throughout 2033 (and could be higher if Azure grows faster than expected).</li></ul><img src=\"https://community-static.tradeup.com/news/993d2dbd835b83c14174232aa462c917\" tg-width=\"750\" tg-height=\"538\"/>InnaFelker<h2 id=\"id_1050932963\">Thesis</h2>In my previous article on Microsoft Corporation (NASDAQ:MSFT), I downgraded the stock from &#34;buy&#34; to &#34;hold&#34;, explaining that according to my models, Microsoft had reached a fair valuation when it was trading at $425.52 (which was 6.6% higher than my fair stock price estimate of $397.49). Furthermore, I suggested that the stock could reach a price of $701.68, translating into 10.50% annual returns throughout 2024-2029.Microsoft released Q3 2024 earnings on April 25. For that quarter, Microsoft reported an EPS of $2.94 (3.8% higher than estimated) and revenues of $61.9B (1.65% higher than estimated).After revising my valuation on Microsoft, I arrived at a near-term stock price target of $417.30, and a 2033 target of $1,099.90. The first number implies a 6.5% downside from the current stock price of $446.34, and the former, is 14.6% annual returns throughout 2024-2033 (which already sets Microsoft as an outperformer), furthermore, if Azure grows faster than the growth rate I used, Microsoft could become undervalued. Because of these reasons, I upgrade the stock from &#34;hold&#34; to &#34;buy&#34;.<h2 id=\"id_2779944536\">Overview</h2><h4 id=\"id_747025263\">Growth Plan</h4>Microsoft&#39;s recent growth primarily comes from its cloud business Azure. Microsoft has been doting Azure of AI capabilities by establishing new Data Centers, for instance, Microsoft is one of Nvidia Corporation&#39;s (NVDA) major clients.Microsoft also acquires businesses related to its already established segments, such as when it bought Activision Blizzard, which owns games such as the Call of Duty franchise, Diablo, and Overwatch 2. This acquisition brought up a lot of scrutiny from regulators (particularly from the UK) since it helped Microsoft to create a network effect with its Xbox platform (which dominates the gaming consoles market along with the PlayStation and the Nintendo Switch).<h4 id=\"id_661735772\">How does Microsoft Compare Against Peers?</h4>Since Microsoft has too many segments, I will focus on the ones providing the most revenue: Cloud, Office Products and Licenses, and Windows OS.In the PaaS and IaaS cloud markets, Microsoft boasts a 24% market share, which puts Microsoft in second place behind Amazon.com, Inc. (AMZN) which holds 31%. However, what sets Microsoft apart is that its market share increased by 4% since 2020 when it was 20%. Meanwhile, Amazon&#39;s market share lost 1%.<img src=\"https://community-static.tradeup.com/news/8ffaaa09600ecd94158b7f3d669e06f9\" tg-width=\"1200\" tg-height=\"1200\"/>Statista<img src=\"https://community-static.tradeup.com/news/c4cce7f5e06bcaeb53b641bc7ad3f71e\" tg-width=\"1280\" tg-height=\"720\"/>StatistaOn the other hand, Microsoft Office holds a 30% market share, which is behind Alphabet, Inc. (GOOG)(GOOGL), which has 44%. This is because Google&#39;s Office version is free and enough for casual users such as students. However, Google Sheets (Google&#39;s version of Excel) lacks some crucial capabilities that Excel has.Lastly, Windows continues to dominate the PC OS market, holding an impressive 72.17% market share. In second place, it&#39;s Apple (AAPL) with a 15.42% market share.<h4 id=\"id_166055940\">Industry Outlook &amp; Addressable Market</h4>The productivity &amp; business processes segment, comprises Office 365, on-premise office licenses, LinkedIn, and Dynamics 365 intelligent cloud. The business productivity market is expected to reach a $59.37B valuation in 2024 and $120.52B in 2029. This shows an annual CAGR of 15.29%.Meanwhile, the Worldwide Public Cloud market is expected to have a market volume of $282.2B in 2024, which should increase to $1.06T in 2028, thus showcasing an annual growth rate of 11.37%. This is the market in which Microsoft&#39;s intelligent cloud segment is. This segment offers Azure, SQL servers, Windows Server, Visual Studio, System Center, and related licenses.Lastly, the &#34;More Personal Computing&#34; segment, agglomerates very diverse products such as the Windows OS, Microsoft Surface devices, HoloLens, XBOX, Microsoft Edge, Bing search engine, and PC accessories such as mice and keyboards.The worldwide gaming console market is expected to reach a $26.43B valuation for 2024 and $43.12B for 2029, translating into an 8.50% CAGR throughout that period.Then, the global PC Accessories market is expected to reach a $27.58B valuation in 2024 and $48.9B in 2029, which is a 12.13% CAGR.Then, I calculated Bing &amp; Microsoft Edge TAM to estimate the expected total internet users. For 2024TTM, Google Search Engine has $188.85B in revenues, which divided by the total users of 4.29K, yields a result of $43.99 per user. For 2024, the total number of internet users is estimated to be 5.25B. For 2029, that number should increase to 6.58 B. Therefore, what I did is that I assumed that Microsoft (to compete) will maintain the same revenue per user as Google. This means that Bing&#39;s TAM for 2024 would stand at around $231.12B, and will increase to $289.45B by 2029. Which showcases a 4.21% CAGR throughout that period.With all these segments, Microsoft&#39;s current TAM is at $754.1B, and for 2029, the TAM should increase to $1.70T, which is a 21.11% annual growth. However, as was already expected, most of that TAM growth, comes from the Cloud because realistically, Microsoft Surface devices will have it difficult to grow, as well as PC accessories, and XBOX. After all, these three markets have what I will call &#34;an untouchable competitor&#34;.In the case of PCs, if a programmer wants to program for Apple devices, he needs to do it in an Apple device (like a Mac), therefore entering the PC market for programmers is nearly impossible.Meanwhile, in the case of accessories, there are gamer brands, and Microsoft does not make gaming keyboards and mice.Lastly, for Xbox, the only way Microsoft would be able to concentrate the market is if Nintendo Co., Ltd. (OTCPK:NTDOY) licenses its content to Microsoft, and that will never happen, since Nintendo knows that this exclusivity is its moat.<table style=\"border-collapse:collapse;\"><colgroup><col/><col/><col/><col/></colgroup><tbody><tr><td style=\"text-align:left;\">Segments</td><td style=\"text-align:left;\">TAM 2024</td><td style=\"text-align:left;\">TAM 2029</td><td style=\"text-align:left;\">CAGR %</td></tr><tr><td style=\"text-align:left;\">Productivity &amp; Business Processes</td><td style=\"text-align:left;\">59,270.0</td><td style=\"text-align:left;\">120,520.0</td><td style=\"text-align:left;\">15.25%</td></tr><tr><td style=\"text-align:left;\">Intelligent Cloud</td><td style=\"text-align:left;\">282,200.0</td><td style=\"text-align:left;\">1,060,000.0</td><td style=\"text-align:left;\">15.66%</td></tr><tr><td style=\"text-align:left;\">Xbox</td><td style=\"text-align:left;\">26,430.6</td><td style=\"text-align:left;\">43,120.7</td><td style=\"text-align:left;\"></td></tr><tr><td style=\"text-align:left;\">PC Accessories</td><td style=\"text-align:left;\">27,580.0</td><td style=\"text-align:left;\">48,900.0</td><td style=\"text-align:left;\">12.13%</td></tr><tr><td style=\"text-align:left;\">Bing &amp; Microsoft Edge</td><td style=\"text-align:left;\">231,123.5</td><td style=\"text-align:left;\">289,454.2</td><td style=\"text-align:left;\">4.21%</td></tr><tr><td style=\"text-align:left;\">Microsoft Surface Devices</td><td style=\"text-align:left;\">127,500.0</td><td style=\"text-align:left;\">147,386.5</td><td style=\"text-align:left;\">3.69%</td></tr><tr><td style=\"text-align:left;\">Total</td><td style=\"text-align:left;\">754,104.1</td><td style=\"text-align:left;\">1,709,381.3</td><td style=\"text-align:left;\">21.11%</td></tr><tr><td style=\"text-align:left;\">CAGR%</td><td style=\"text-align:left;\"></td><td style=\"text-align:left;\">21.11%</td><td style=\"text-align:left;\"></td></tr></tbody></table>Click to enlarge<h2 id=\"id_2883581705\">Valuation</h2>I will value Microsoft through a DCF model. The first thing to be calculated will be the WACC, which I calculated with the already-known formula (and you can find a more detailed formula in the DCF model). The result was 11.35%.Then, the D&amp;A margin will be projected with a margin tied to revenue, which came out at 6.52%.Lastly, the CapEx margin throughout the projection will remain constant at 16.72%.<table style=\"border-collapse:collapse;\"><colgroup><col/><col/></colgroup><tbody><tr><td colspan=\"2\" style=\"text-align:left;\">TABLE OF ASSUMPTIONS</td></tr><tr><td style=\"text-align:left;\">Equity Market Price</td><td style=\"text-align:left;\">3,317,645.22</td></tr><tr><td style=\"text-align:left;\">Debt Value</td><td style=\"text-align:left;\">106,229.00</td></tr><tr><td style=\"text-align:left;\">Cost of Debt</td><td style=\"text-align:left;\">2.60%</td></tr><tr><td style=\"text-align:left;\">Tax Rate</td><td style=\"text-align:left;\">18.13%</td></tr><tr><td style=\"text-align:left;\">10y Treasury</td><td style=\"text-align:left;\">4.219%</td></tr><tr><td style=\"text-align:left;\">Beta</td><td style=\"text-align:left;\">1.18</td></tr><tr><td style=\"text-align:left;\">Market Return</td><td style=\"text-align:left;\">10.50%</td></tr><tr><td style=\"text-align:left;\">Cost of Equity</td><td style=\"text-align:left;\">11.63%</td></tr><tr><td style=\"text-align:left;\">CapEx</td><td style=\"text-align:left;\">39,547.00</td></tr><tr><td style=\"text-align:left;\">Capex Margin</td><td style=\"text-align:left;\">16.72%</td></tr><tr><td style=\"text-align:left;\">Net Income</td><td style=\"text-align:left;\">86,181.00</td></tr><tr><td style=\"text-align:left;\">Interest</td><td style=\"text-align:left;\">2,762.00</td></tr><tr><td style=\"text-align:left;\">Tax</td><td style=\"text-align:left;\">19,082.00</td></tr><tr><td style=\"text-align:left;\">D&amp;A</td><td style=\"text-align:left;\">15,420.00</td></tr><tr><td style=\"text-align:left;\">EBITDA</td><td style=\"text-align:left;\">123,445.00</td></tr><tr><td style=\"text-align:left;\">D&amp;A Margin</td><td style=\"text-align:left;\">6.52%</td></tr><tr><td style=\"text-align:left;\">Revenue</td><td style=\"text-align:left;\">236,584.0</td></tr><tr><td style=\"text-align:left;\">R&amp;D Expense Margin</td><td style=\"text-align:left;\">17.05%</td></tr></tbody></table>Click to enlargeThe first thing is to calculate revenues, and the first segment I will calculate is Activision-Blizzard. For 2023, the now-acquired company generated $8.7B in revenues. Now, the problem is that it&#39;s impossible to predict which games are going to be a success and which not. Therefore, I will assume a conservative growth rate of 5.20%.Then, the productivity &amp; business Processes, and Intelligent Cloud will grow in line with its market, by 15.25% and 15.66% respectively.<table style=\"border-collapse:collapse;\"><colgroup><col/><col/></colgroup><tbody><tr><td style=\"text-align:left;\"></td><td style=\"text-align:left;\">Revenue of Activision</td><td style=\"text-align:left;\">Productivity &amp; Business Processes</td><td style=\"text-align:left;\">Intelligent Cloud</td></tr><tr><td style=\"text-align:left;\">2023</td><td style=\"text-align:left;\">8,706.0</td><td style=\"text-align:left;\">69,275.0</td><td style=\"text-align:left;\">87,902.3</td></tr><tr><td style=\"text-align:left;\">2024</td><td style=\"text-align:left;\">9,158.7</td><td style=\"text-align:left;\">79,839.4</td><td style=\"text-align:left;\">101,667.8</td></tr><tr><td style=\"text-align:left;\">2025</td><td style=\"text-align:left;\">9,635.0</td><td style=\"text-align:left;\">92,015.0</td><td style=\"text-align:left;\">117,589.0</td></tr><tr><td style=\"text-align:left;\">2026</td><td style=\"text-align:left;\">10,136.0</td><td style=\"text-align:left;\">106,047.2</td><td style=\"text-align:left;\">136,003.4</td></tr><tr><td style=\"text-align:left;\">2027</td><td style=\"text-align:left;\">10,663.1</td><td style=\"text-align:left;\">122,219.4</td><td style=\"text-align:left;\">157,301.5</td></tr><tr><td style=\"text-align:left;\">2028</td><td style=\"text-align:left;\">11,217.5</td><td style=\"text-align:left;\">140,857.9</td><td style=\"text-align:left;\">181,935.0</td></tr><tr><td style=\"text-align:left;\">2029</td><td style=\"text-align:left;\">11,800.8</td><td style=\"text-align:left;\">162,338.7</td><td style=\"text-align:left;\">210,426.0</td></tr><tr><td style=\"text-align:left;\">2030</td><td style=\"text-align:left;\">13,480.1</td><td style=\"text-align:left;\">187,095.4</td><td style=\"text-align:left;\">243,378.7</td></tr><tr><td style=\"text-align:left;\">2031</td><td style=\"text-align:left;\">15,398.3</td><td style=\"text-align:left;\">215,627.4</td><td style=\"text-align:left;\">281,491.8</td></tr><tr><td style=\"text-align:left;\">2032</td><td style=\"text-align:left;\">16,493.1</td><td style=\"text-align:left;\">248,510.6</td><td style=\"text-align:left;\">325,573.4</td></tr><tr><td style=\"text-align:left;\">2033</td><td style=\"text-align:left;\">17,665.8</td><td style=\"text-align:left;\">286,408.5</td><td style=\"text-align:left;\">376,558.2</td></tr><tr><td style=\"text-align:left;\">Growth Rate %</td><td style=\"text-align:left;\">5.20%</td><td style=\"text-align:left;\">15.25%</td><td style=\"text-align:left;\">15.66%</td></tr></tbody></table>Click to enlargeNow, starting with the &#34;More Personal Computing&#34; segment I found that Xbox sales totaled $15.46B for 2023. This segment will also grow in line with its market, 8.50%.On the other hand, Bing had a market share of around 10.53% in 2023 (which multiplied by the total amount of internet users in that year, means that Bing had around 543.13M users). After dividing the estimated $12.21B in revenue generated by Bing in 2023, I got that this division could be generating around $22.48 per user (which is lower than Google&#39;s $36.29). Then, I multiply that $22.48 in revenues per user by the estimated internet users to get the revenue estimates. This also yields a growth rate of 4.59% for 2023-2029 which I will use to project revenue for 2030-2033.<table style=\"border-collapse:collapse;\"><colgroup><col/><col/></colgroup><tbody><tr><td style=\"text-align:left;\"></td><td style=\"text-align:left;\">Internet Users</td><td style=\"text-align:left;\">Bing&#39;s Share</td></tr><tr><td style=\"text-align:left;\">2024</td><td style=\"text-align:left;\">5,254.00</td><td style=\"text-align:left;\">553.25</td></tr><tr><td style=\"text-align:left;\">2025</td><td style=\"text-align:left;\">5,470.00</td><td style=\"text-align:left;\">575.99</td></tr><tr><td style=\"text-align:left;\">2026</td><td style=\"text-align:left;\">5,690.00</td><td style=\"text-align:left;\">599.16</td></tr><tr><td style=\"text-align:left;\">2027</td><td style=\"text-align:left;\">5,910.00</td><td style=\"text-align:left;\">622.32</td></tr><tr><td style=\"text-align:left;\">2028</td><td style=\"text-align:left;\">6,350.00</td><td style=\"text-align:left;\">668.66</td></tr><tr><td style=\"text-align:left;\">2029</td><td style=\"text-align:left;\">6,580.00</td><td style=\"text-align:left;\">692.87</td></tr></tbody></table>Click to enlargeMeanwhile, it&#39;s estimated that Microsoft Surface devices&#39; sales tanked by 30% for 2023, which generated losses of up to $1.8B. By doing the rule of three, I found that Microsoft would have generated $6B in revenues for 2023. This segment will grow in line with the worldwide laptop market at 3.69%.Lastly, Windows operating system revenue is speculated to have been around $24.61B in 2023. This was calculated via the rule of three, since in 2023, Windows revenue fell by $3.2B which was 13%. Therefore, I calculated the 100% with that information. This segment will grow in line with the worldwide PC market at 1.13%.However, these calculations for 2023 say that Microsoft generated $63.35B for the &#34;More Personal Computing&#34; segment, which is substantially more than the reported $54.73B. Therefore, I will divide the $19.3B difference by the 5 subsegments, and then subtract the $3.806B result from each of them, so I can be able to correct the difference from the resulting segment result with the actual segment result.<table style=\"border-collapse:collapse;\"><colgroup><col/><col/></colgroup><tbody><tr><td style=\"text-align:left;\"></td><td style=\"text-align:left;\">Xbox</td><td style=\"text-align:left;\">PC Accessories</td><td style=\"text-align:left;\">Bing &amp; Microsoft Edge</td><td style=\"text-align:left;\">Microsoft Surface Devices</td><td style=\"text-align:left;\">Windows Os</td></tr><tr><td style=\"text-align:left;\">2023</td><td style=\"text-align:left;\">11,659.52</td><td style=\"text-align:left;\">11,672.52</td><td style=\"text-align:left;\">8,403.52</td><td style=\"text-align:left;\">2,193.52</td><td style=\"text-align:left;\">20,808.52</td></tr><tr><td style=\"text-align:left;\">2024</td><td style=\"text-align:left;\">12,650.58</td><td style=\"text-align:left;\">13,088.40</td><td style=\"text-align:left;\">12,436.97</td><td style=\"text-align:left;\">2,274.46</td><td style=\"text-align:left;\">21,043.66</td></tr><tr><td style=\"text-align:left;\">2025</td><td style=\"text-align:left;\">13,725.88</td><td style=\"text-align:left;\">14,676.02</td><td style=\"text-align:left;\">12,948.28</td><td style=\"text-align:left;\">2,358.39</td><td style=\"text-align:left;\">21,281.45</td></tr><tr><td style=\"text-align:left;\">2026</td><td style=\"text-align:left;\">14,892.58</td><td style=\"text-align:left;\">16,456.22</td><td style=\"text-align:left;\">13,469.05</td><td style=\"text-align:left;\">2,445.41</td><td style=\"text-align:left;\">21,521.93</td></tr><tr><td style=\"text-align:left;\">2027</td><td style=\"text-align:left;\">16,158.45</td><td style=\"text-align:left;\">18,452.36</td><td style=\"text-align:left;\">13,989.82</td><td style=\"text-align:left;\">2,535.65</td><td style=\"text-align:left;\">21,765.13</td></tr><tr><td style=\"text-align:left;\">2028</td><td style=\"text-align:left;\">17,531.92</td><td style=\"text-align:left;\">20,690.63</td><td style=\"text-align:left;\">15,031.36</td><td style=\"text-align:left;\">2,629.21</td><td style=\"text-align:left;\">22,011.07</td></tr><tr><td style=\"text-align:left;\">2029</td><td style=\"text-align:left;\">19,022.13</td><td style=\"text-align:left;\">23,200.40</td><td style=\"text-align:left;\">15,575.81</td><td style=\"text-align:left;\">2,726.23</td><td style=\"text-align:left;\">22,259.80</td></tr><tr><td style=\"text-align:left;\">2030</td><td style=\"text-align:left;\">20,639.01</td><td style=\"text-align:left;\">26,014.61</td><td style=\"text-align:left;\">17,791.43</td><td style=\"text-align:left;\">2,826.83</td><td style=\"text-align:left;\">22,511.33</td></tr><tr><td style=\"text-align:left;\">2031</td><td style=\"text-align:left;\">22,393.32</td><td style=\"text-align:left;\">29,170.19</td><td style=\"text-align:left;\">20,322.22</td><td style=\"text-align:left;\">2,931.14</td><td style=\"text-align:left;\">22,765.71</td></tr><tr><td style=\"text-align:left;\">2032</td><td style=\"text-align:left;\">24,296.76</td><td style=\"text-align:left;\">32,708.53</td><td style=\"text-align:left;\">23,213.01</td><td style=\"text-align:left;\">3,039.30</td><td style=\"text-align:left;\">23,022.97</td></tr><tr><td style=\"text-align:left;\">2033</td><td style=\"text-align:left;\">26,361.98</td><td style=\"text-align:left;\">36,676.07</td><td style=\"text-align:left;\">26,515.01</td><td style=\"text-align:left;\">3,151.45</td><td style=\"text-align:left;\">23,283.12</td></tr><tr><td style=\"text-align:left;\">Growth Rate %</td><td style=\"text-align:left;\">8.50%</td><td style=\"text-align:left;\">12.13%</td><td style=\"text-align:left;\">14.22%</td><td style=\"text-align:left;\">3.69%</td><td style=\"text-align:left;\">1.13%</td></tr></tbody></table>Click to enlargeThen, I will calculate net income. The first step is gross income, which I will maintain the current gross margin of 69.89%. Meanwhile, general expenses will be tied to full-time employees. In 2023 general expenses were $27.19B, which was divided by the number of employees at that time of 221K. This resulted in an expense per employee of $120K (this is also an indication that Microsoft pays goods). Then I will assume that Microsoft will hire 19.33K new workers annually, in line with 2021-2023.On the other hand, R&amp;D expenses will be calculated with a margin tied to gross income, which currently stands at 17.05%.Then it&#39;s the time to calculate short &amp; long-term debt and interest income &amp; expenses. Short &amp; long-term debt will have annual changes in line with their 2018-20222 performance of 26.4%, and -8.7% respectively. Meanwhile, marketable securities will be growing at a 4.2% annual rate.Then, I found that in 2019, when interest rates were lower than now, Microsoft paid a 3.11% interest on debt and received a 2.26% annual return on its marketable securities.However, for 2024TTM (when interest rates are high) Microsoft has paid a 2.60% interest on debt (yes, lower than when interest rates were lower) and has received a 5.67% return on marketable securities.So with this information, I will assume an interest on a debt payment of 2.60% throughout the project. Then I will assume that for 2024 and 2027 Microsoft will receive a 5.67% return on its marketable securities and for the other years, it will receive 2.26%. This is because I am expecting that for 2024 and 2027, interest rates will increase again. If you want to read the full explanation, you can check the valuation section of my article on JPMorgan Chase &amp; Co. (JPM).Nevertheless, for 2030-2033, I will use the average marketable securities annual return of 3.96% (the average of 5.67% and 2.26%) since I have not made an interest rates projection for the years beyond 2029.<img src=\"https://community-static.tradeup.com/news/a3392d113dc4ba4877f8acbef1242006\" tg-width=\"640\" tg-height=\"204\"/>Author&#39;s Calculations<table style=\"border-collapse:collapse;\"><colgroup><col/><col/></colgroup><tbody><tr><td style=\"text-align:left;\"></td><td style=\"text-align:left;\">Revenue</td><td style=\"text-align:left;\">Net Income</td><td style=\"text-align:left;\">Plus Taxes</td><td style=\"text-align:left;\">Plus D&amp;A</td><td style=\"text-align:left;\">Plus Interest</td></tr><tr><td style=\"text-align:left;\">2024</td><td style=\"text-align:left;\">$252,160.0</td><td style=\"text-align:left;\">$96,208.66</td><td style=\"text-align:left;\">$121,411.75</td><td style=\"text-align:left;\">$137,846.96</td><td style=\"text-align:left;\">$140,091.07</td></tr><tr><td style=\"text-align:left;\">2025</td><td style=\"text-align:left;\">$284,228.9</td><td style=\"text-align:left;\">$106,918.84</td><td style=\"text-align:left;\">$134,927.57</td><td style=\"text-align:left;\">$151,362.78</td><td style=\"text-align:left;\">$153,846.25</td></tr><tr><td style=\"text-align:left;\">2026</td><td style=\"text-align:left;\">$320,971.8</td><td style=\"text-align:left;\">$121,768.87</td><td style=\"text-align:left;\">$153,667.72</td><td style=\"text-align:left;\">$174,587.92</td><td style=\"text-align:left;\">$177,522.65</td></tr><tr><td style=\"text-align:left;\">2027</td><td style=\"text-align:left;\">$363,085.4</td><td style=\"text-align:left;\">$141,490.60</td><td style=\"text-align:left;\">$178,555.78</td><td style=\"text-align:left;\">$202,220.85</td><td style=\"text-align:left;\">$205,652.88</td></tr><tr><td style=\"text-align:left;\">2028</td><td style=\"text-align:left;\">$411,904.6</td><td style=\"text-align:left;\">$159,289.99</td><td style=\"text-align:left;\">$201,017.91</td><td style=\"text-align:left;\">$227,864.90</td><td style=\"text-align:left;\">$231,956.74</td></tr><tr><td style=\"text-align:left;\">2029</td><td style=\"text-align:left;\">$467,349.9</td><td style=\"text-align:left;\">$182,609.20</td><td style=\"text-align:left;\">$230,228.11</td><td style=\"text-align:left;\">$260,688.91</td><td style=\"text-align:left;\">$265,614.55</td></tr><tr><td style=\"text-align:left;\">2030</td><td style=\"text-align:left;\">$533,737.4</td><td style=\"text-align:left;\">$211,816.29</td><td style=\"text-align:left;\">$267,304.04</td><td style=\"text-align:left;\">$302,091.82</td><td style=\"text-align:left;\">$308,071.13</td></tr><tr><td style=\"text-align:left;\">2031</td><td style=\"text-align:left;\">$610,100.1</td><td style=\"text-align:left;\">$244,241.04</td><td style=\"text-align:left;\">$308,222.81</td><td style=\"text-align:left;\">$347,987.73</td><td style=\"text-align:left;\">$355,298.55</td></tr><tr><td style=\"text-align:left;\">2032</td><td style=\"text-align:left;\">$696,857.7</td><td style=\"text-align:left;\">$281,168.43</td><td style=\"text-align:left;\">$354,823.73</td><td style=\"text-align:left;\">$400,243.31</td><td style=\"text-align:left;\">$409,236.74</td></tr><tr><td style=\"text-align:left;\">2033</td><td style=\"text-align:left;\">$796,620.1</td><td style=\"text-align:left;\">$323,724.30</td><td style=\"text-align:left;\">$408,527.57</td><td style=\"text-align:left;\">$460,449.44</td><td style=\"text-align:left;\">$471,569.18</td></tr><tr><td style=\"text-align:left;\"></td><td style=\"text-align:left;\"></td><td style=\"text-align:left;\"></td><td style=\"text-align:left;\"></td><td style=\"text-align:left;\"></td><td style=\"text-align:left;\">^Final EBITA^</td></tr></tbody></table>Click to enlargeThen, I assume that current assets will grow at 1.72%, thus mirroring the performance during 2018-2022. Then, with this, I use the undiscounted cash flows highlighted in green and add the future equity value, which is composed of the future short &amp; long-term debt, current assets, and marketable securities.Lastly, the perpetuity growth rate in the model is 1.82%. This number was calculated by dividing the resulting free cash flow growth rate from the projection (25.07%) and dividing it by the difference between it and the WACC of 11.35% (25.07%/(25.07%-11.35%)=1.82%).<img src=\"https://community-static.tradeup.com/news/bf10435f50c20656579b988a32525d88\" tg-width=\"640\" tg-height=\"505\"/>Author&#39;s CalculationsAs you can see, the model suggests that the stock (today) should be trading at $417.30, which is 6.5% below the current stock price of $446.34. For the future, the model suggests that the stock could be trading at $1,099.90 in 2033. Yes, that&#39;s a 146.4% upside from the current stock price, however when dividing that by the 10 years until the end of 2033, you get 14.6% annual returns.<h4 id=\"id_2386006103\">What if Azure could grow at 20-25% annually?</h4>If I increase Azure revenue growth from 15.66% to 20%, then the present fair price of Microsoft would be $484.22 (which is 8.5% above the current stock price), and a 2033 stock price target of $1,287.45 (which suggests 18.8% annual returns).Then, If I increase that 20% revenue growth to 25%, the present fair price increases to $600.74 and the future price to $1,617.07. The first number indicates a 34.6% undervaluation of Microsoft&#39;s stock, and the future price indicates 26.2% annual returns throughout 2033.<h4 id=\"id_4161173946\">But, is that possible?</h4>Since 2015, Intelligent Cloud has only surpassed the 30% growth rate in 2021. The average revenue growth rate of this segment has been 17.74%, which is slightly lower than the first 20% hypothetical scenario, and 7.26% lower than the second 25% hypothetical scenario.<table style=\"border-collapse:collapse;\"><colgroup><col/><col/><col/></colgroup><tbody><tr><td style=\"text-align:left;\"></td><td style=\"text-align:left;\">Annual Revenue of Microsoft&#39;s Intelligent Cloud</td><td style=\"text-align:left;\">Change %</td></tr><tr><td style=\"text-align:left;\">2015</td><td style=\"text-align:left;\">23684</td><td style=\"text-align:left;\"></td></tr><tr><td style=\"text-align:left;\">2016</td><td style=\"text-align:left;\">25040</td><td style=\"text-align:left;\">5.73%</td></tr><tr><td style=\"text-align:left;\">2017</td><td style=\"text-align:left;\">27400</td><td style=\"text-align:left;\">9.42%</td></tr><tr><td style=\"text-align:left;\">2018</td><td style=\"text-align:left;\">32230</td><td style=\"text-align:left;\">17.63%</td></tr><tr><td style=\"text-align:left;\">2019</td><td style=\"text-align:left;\">38990</td><td style=\"text-align:left;\">20.97%</td></tr><tr><td style=\"text-align:left;\">2020</td><td style=\"text-align:left;\">44450</td><td style=\"text-align:left;\">14.00%</td></tr><tr><td style=\"text-align:left;\">2021</td><td style=\"text-align:left;\">60000</td><td style=\"text-align:left;\">34.98%</td></tr><tr><td style=\"text-align:left;\">2022</td><td style=\"text-align:left;\">74700</td><td style=\"text-align:left;\">24.50%</td></tr><tr><td style=\"text-align:left;\">2023</td><td style=\"text-align:left;\">86930</td><td style=\"text-align:left;\">16.37%</td></tr><tr><td style=\"text-align:left;\">2024 TTM</td><td style=\"text-align:left;\">100850</td><td style=\"text-align:left;\">16.01%</td></tr></tbody></table>Click to enlargeIt&#39;s also worth noting that if I take out 2015 and 2016, the average Azure annual growth rate increases to 20.64%. However, the problem is that, in the past, when the cloud market was growing faster, Azure just achieved a growth rate of over 20% in 2019, 2021, and 2022. Thus, there&#39;s more probability that Azure will grow below the required 20% (which would make Microsoft undervalued by a mere 8.5%)Nevertheless, it&#39;s good that even with the 15.66% originally used in this projection, the suggested annual return of 14.6% is still above the historic 10.50% annual returns of the market, which sets Microsoft to be an outperformer, even if the stock price decreased by 6.5% to adjust to my fair stock price estimate of $417.30.<h2 id=\"id_88032998\">Risks to Thesis</h2>The main risk for my thesis is that Microsoft suddenly can achieve that high 30% growth rate that is required for a fair stock price of $496.21. This may be the reason why Microsoft&#39;s stock has been increasing past my fair stock price estimates because the optimism on Azure has passed the logical boundary.However, I think that there are more risks related to Microsoft than to my thesis, for example, Microsoft would have it very difficult to perform any big-scale acquisition such as the Activision one.Then, there is also the risk that Microsoft is more prone to lose market share than to gain it, yes Azure has grown its market share by 4% since 2020. However, that will be very difficult for Windows, or Microsoft Office. At best, what Microsoft could do is to boost the sales of Surface devices, however, the problem with that is the differentiation factor. What happened with <a href=\"https://laohu8.com/S/IBM\">IBM</a> is that its PCs were made by third-party components to which the competition could also access, and then its computers lost ground to cheaper alternatives, and the same thing happens today.<h2 id=\"id_2019918090\">Evolution of My Fair Price Estimates</h2>Since my first coverage on Microsoft, my fair price estimate has increased by 12.29%. Concerning my previous coverage, the reason for the increase from $397.49 to the present $417.30, the model I did in this article, covers 10 years, and not 6 as the previous one did. The main effect is that the total amount of cash flows increases in the model, which ultimately leads to an increased fair stock price.<img src=\"https://community-static.tradeup.com/news/d985bec6886950475008be2ad5790621\" tg-width=\"640\" tg-height=\"417\"/>Author&#39;s Calculations<h2 id=\"id_1324337767\">Conclusion</h2>In conclusion, Microsoft continues to be overvalued, however, Microsoft&#39;s current valuation (despite a 6.5% overvaluation) is a good point to enter (in my opinion) and wait for Azure to deliver higher returns than the 15.66% used for my estimates. The suggested annual returns in my base model are 14.6% (which already sets Microsoft as an outperformer against the market&#39;s 10.50% annual return average).Lastly, I assigned a near-term target for Microsoft&#39;s stock at $417.30, which is 6.5% below the current stock price of $446.34, and a 2033 stock price target at $1,099.90, which implies a 14.6% annual return throughout the 10 years.</body></html>","source":"seekingalpha","collect":0,"html":"<!DOCTYPE html>\n<html>\n<head>\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" />\n<meta name=\"viewport\" content=\"width=device-width,initial-scale=1.0,minimum-scale=1.0,maximum-scale=1.0,user-scalable=no\"/>\n<meta name=\"format-detection\" content=\"telephone=no,email=no,address=no\" />\n<title>Microsoft: Currently Overvalued, But It's Set To Be A Potential Outperformer Throughout 2033</title>\n<style type=\"text/css\">\na,abbr,acronym,address,applet,article,aside,audio,b,big,blockquote,body,canvas,caption,center,cite,code,dd,del,details,dfn,div,dl,dt,\nem,embed,fieldset,figcaption,figure,footer,form,h1,h2,h3,h4,h5,h6,header,hgroup,html,i,iframe,img,ins,kbd,label,legend,li,mark,menu,nav,\nobject,ol,output,p,pre,q,ruby,s,samp,section,small,span,strike,strong,sub,summary,sup,table,tbody,td,tfoot,th,thead,time,tr,tt,u,ul,var,video{ font:inherit;margin:0;padding:0;vertical-align:baseline;border:0 }\nbody{ font-size:16px; line-height:1.5; color:#999; background:transparent; }\n.wrapper{ overflow:hidden;word-break:break-all;padding:10px; }\nh1,h2{ font-weight:normal; line-height:1.35; margin-bottom:.6em; }\nh3,h4,h5,h6{ line-height:1.35; margin-bottom:1em; }\nh1{ font-size:24px; }\nh2{ font-size:20px; }\nh3{ font-size:18px; }\nh4{ font-size:16px; }\nh5{ font-size:14px; }\nh6{ font-size:12px; }\np,ul,ol,blockquote,dl,table{ margin:1.2em 0; }\nul,ol{ margin-left:2em; }\nul{ list-style:disc; }\nol{ list-style:decimal; }\nli,li p{ margin:10px 0;}\nimg{ max-width:100%;display:block;margin:0 auto 1em; }\nblockquote{ color:#B5B2B1; border-left:3px solid #aaa; padding:1em; }\nstrong,b{font-weight:bold;}\nem,i{font-style:italic;}\ntable{ width:100%;border-collapse:collapse;border-spacing:1px;margin:1em 0;font-size:.9em; }\nth,td{ padding:5px;text-align:left;border:1px solid #aaa; }\nth{ font-weight:bold;background:#5d5d5d; }\n.symbol-link{font-weight:bold;}\n/* header{ border-bottom:1px solid #494756; } */\n.title{ margin:0 0 8px;line-height:1.3;color:#ddd; }\n.meta {color:#5e5c6d;font-size:13px;margin:0 0 .5em; }\na{text-decoration:none; color:#2a4b87;}\n.meta .head { display: inline-block; overflow: hidden}\n.head .h-thumb { width: 30px; height: 30px; margin: 0; padding: 0; border-radius: 50%; float: left;}\n.head .h-content { margin: 0; padding: 0 0 0 9px; float: left;}\n.head .h-name {font-size: 13px; color: #eee; margin: 0;}\n.head .h-time {font-size: 11px; color: #7E829C; margin: 0;line-height: 11px;}\n.small {font-size: 12.5px; display: inline-block; transform: scale(0.9); -webkit-transform: scale(0.9); transform-origin: left; -webkit-transform-origin: left;}\n.smaller {font-size: 12.5px; display: inline-block; transform: scale(0.8); -webkit-transform: scale(0.8); transform-origin: left; -webkit-transform-origin: left;}\n.bt-text {font-size: 12px;margin: 1.5em 0 0 0}\n.bt-text p {margin: 0}\n</style>\n</head>\n<body>\n<div class=\"wrapper\">\n<header>\n<h2 class=\"title\">\nMicrosoft: Currently Overvalued, But It's Set To Be A Potential Outperformer Throughout 2033\n</h2>\n\n<h4 class=\"meta\">\n\n\n2024-07-01 14:00 GMT+8&nbsp;&nbsp;&nbsp;<a href=https://seekingalpha.com/article/4701692-microsoft-currently-overvalued-but-its-set-to-be-a-potential-outperformer-throughout-2033>seekingalpha</a>\n\n\n</h4>\n\n</header>\n<article>\n<div>\nMicrosoft's valuation is upgraded from \"hold\" to \"buy\" with a near-term target of $417.30 and a 2033 target of $1,099.90, implying 14.6% annual returns.The Company's growth is driven by its cloud ...\n\n<a href=\"https://seekingalpha.com/article/4701692-microsoft-currently-overvalued-but-its-set-to-be-a-potential-outperformer-throughout-2033\">Web Link</a>\n\n</div>\n\n\n</article>\n</div>\n</body>\n</html>\n","type":0,"thumbnail":"","relate_stocks":{"MSFT":"微软"},"source_url":"https://seekingalpha.com/article/4701692-microsoft-currently-overvalued-but-its-set-to-be-a-potential-outperformer-throughout-2033","is_english":true,"share_image_url":"https://static.laohu8.com/5a36db9d73b4222bc376d24ccc48c8a4","article_id":"2447608276","content_text":"Microsoft's valuation is upgraded from \"hold\" to \"buy\" with a near-term target of $417.30 and a 2033 target of $1,099.90, implying 14.6% annual returns.The Company's growth is driven by its cloud business (Azure), and acquisitions like Activision-Blizzard.MSFT holds a 24% cloud market share (second to Amazon's 31%) and dominates with a 72.17% share in the PC OS market.Microsoft's TAM is expected to grow from $754.1B in 2024 to $1.70T by 2029, with the cloud segment driving most of the growth.The valuation (which uses a DCF model) suggests 14.6% annual returns throughout 2033 (and could be higher if Azure grows faster than expected).InnaFelkerThesisIn my previous article on Microsoft Corporation (NASDAQ:MSFT), I downgraded the stock from \"buy\" to \"hold\", explaining that according to my models, Microsoft had reached a fair valuation when it was trading at $425.52 (which was 6.6% higher than my fair stock price estimate of $397.49). Furthermore, I suggested that the stock could reach a price of $701.68, translating into 10.50% annual returns throughout 2024-2029.Microsoft released Q3 2024 earnings on April 25. For that quarter, Microsoft reported an EPS of $2.94 (3.8% higher than estimated) and revenues of $61.9B (1.65% higher than estimated).After revising my valuation on Microsoft, I arrived at a near-term stock price target of $417.30, and a 2033 target of $1,099.90. The first number implies a 6.5% downside from the current stock price of $446.34, and the former, is 14.6% annual returns throughout 2024-2033 (which already sets Microsoft as an outperformer), furthermore, if Azure grows faster than the growth rate I used, Microsoft could become undervalued. Because of these reasons, I upgrade the stock from \"hold\" to \"buy\".OverviewGrowth PlanMicrosoft's recent growth primarily comes from its cloud business Azure. Microsoft has been doting Azure of AI capabilities by establishing new Data Centers, for instance, Microsoft is one of Nvidia Corporation's (NVDA) major clients.Microsoft also acquires businesses related to its already established segments, such as when it bought Activision Blizzard, which owns games such as the Call of Duty franchise, Diablo, and Overwatch 2. This acquisition brought up a lot of scrutiny from regulators (particularly from the UK) since it helped Microsoft to create a network effect with its Xbox platform (which dominates the gaming consoles market along with the PlayStation and the Nintendo Switch).How does Microsoft Compare Against Peers?Since Microsoft has too many segments, I will focus on the ones providing the most revenue: Cloud, Office Products and Licenses, and Windows OS.In the PaaS and IaaS cloud markets, Microsoft boasts a 24% market share, which puts Microsoft in second place behind Amazon.com, Inc. (AMZN) which holds 31%. However, what sets Microsoft apart is that its market share increased by 4% since 2020 when it was 20%. Meanwhile, Amazon's market share lost 1%.StatistaStatistaOn the other hand, Microsoft Office holds a 30% market share, which is behind Alphabet, Inc. (GOOG)(GOOGL), which has 44%. This is because Google's Office version is free and enough for casual users such as students. However, Google Sheets (Google's version of Excel) lacks some crucial capabilities that Excel has.Lastly, Windows continues to dominate the PC OS market, holding an impressive 72.17% market share. In second place, it's Apple (AAPL) with a 15.42% market share.Industry Outlook & Addressable MarketThe productivity & business processes segment, comprises Office 365, on-premise office licenses, LinkedIn, and Dynamics 365 intelligent cloud. The business productivity market is expected to reach a $59.37B valuation in 2024 and $120.52B in 2029. This shows an annual CAGR of 15.29%.Meanwhile, the Worldwide Public Cloud market is expected to have a market volume of $282.2B in 2024, which should increase to $1.06T in 2028, thus showcasing an annual growth rate of 11.37%. This is the market in which Microsoft's intelligent cloud segment is. This segment offers Azure, SQL servers, Windows Server, Visual Studio, System Center, and related licenses.Lastly, the \"More Personal Computing\" segment, agglomerates very diverse products such as the Windows OS, Microsoft Surface devices, HoloLens, XBOX, Microsoft Edge, Bing search engine, and PC accessories such as mice and keyboards.The worldwide gaming console market is expected to reach a $26.43B valuation for 2024 and $43.12B for 2029, translating into an 8.50% CAGR throughout that period.Then, the global PC Accessories market is expected to reach a $27.58B valuation in 2024 and $48.9B in 2029, which is a 12.13% CAGR.Then, I calculated Bing & Microsoft Edge TAM to estimate the expected total internet users. For 2024TTM, Google Search Engine has $188.85B in revenues, which divided by the total users of 4.29K, yields a result of $43.99 per user. For 2024, the total number of internet users is estimated to be 5.25B. For 2029, that number should increase to 6.58 B. Therefore, what I did is that I assumed that Microsoft (to compete) will maintain the same revenue per user as Google. This means that Bing's TAM for 2024 would stand at around $231.12B, and will increase to $289.45B by 2029. Which showcases a 4.21% CAGR throughout that period.With all these segments, Microsoft's current TAM is at $754.1B, and for 2029, the TAM should increase to $1.70T, which is a 21.11% annual growth. However, as was already expected, most of that TAM growth, comes from the Cloud because realistically, Microsoft Surface devices will have it difficult to grow, as well as PC accessories, and XBOX. After all, these three markets have what I will call \"an untouchable competitor\".In the case of PCs, if a programmer wants to program for Apple devices, he needs to do it in an Apple device (like a Mac), therefore entering the PC market for programmers is nearly impossible.Meanwhile, in the case of accessories, there are gamer brands, and Microsoft does not make gaming keyboards and mice.Lastly, for Xbox, the only way Microsoft would be able to concentrate the market is if Nintendo Co., Ltd. (OTCPK:NTDOY) licenses its content to Microsoft, and that will never happen, since Nintendo knows that this exclusivity is its moat.SegmentsTAM 2024TAM 2029CAGR %Productivity & Business Processes59,270.0120,520.015.25%Intelligent Cloud282,200.01,060,000.015.66%Xbox26,430.643,120.7PC Accessories27,580.048,900.012.13%Bing & Microsoft Edge231,123.5289,454.24.21%Microsoft Surface Devices127,500.0147,386.53.69%Total754,104.11,709,381.321.11%CAGR%21.11%Click to enlargeValuationI will value Microsoft through a DCF model. The first thing to be calculated will be the WACC, which I calculated with the already-known formula (and you can find a more detailed formula in the DCF model). The result was 11.35%.Then, the D&A margin will be projected with a margin tied to revenue, which came out at 6.52%.Lastly, the CapEx margin throughout the projection will remain constant at 16.72%.TABLE OF ASSUMPTIONSEquity Market Price3,317,645.22Debt Value106,229.00Cost of Debt2.60%Tax Rate18.13%10y Treasury4.219%Beta1.18Market Return10.50%Cost of Equity11.63%CapEx39,547.00Capex Margin16.72%Net Income86,181.00Interest2,762.00Tax19,082.00D&A15,420.00EBITDA123,445.00D&A Margin6.52%Revenue236,584.0R&D Expense Margin17.05%Click to enlargeThe first thing is to calculate revenues, and the first segment I will calculate is Activision-Blizzard. For 2023, the now-acquired company generated $8.7B in revenues. Now, the problem is that it's impossible to predict which games are going to be a success and which not. Therefore, I will assume a conservative growth rate of 5.20%.Then, the productivity & business Processes, and Intelligent Cloud will grow in line with its market, by 15.25% and 15.66% respectively.Revenue of ActivisionProductivity & Business ProcessesIntelligent Cloud20238,706.069,275.087,902.320249,158.779,839.4101,667.820259,635.092,015.0117,589.0202610,136.0106,047.2136,003.4202710,663.1122,219.4157,301.5202811,217.5140,857.9181,935.0202911,800.8162,338.7210,426.0203013,480.1187,095.4243,378.7203115,398.3215,627.4281,491.8203216,493.1248,510.6325,573.4203317,665.8286,408.5376,558.2Growth Rate %5.20%15.25%15.66%Click to enlargeNow, starting with the \"More Personal Computing\" segment I found that Xbox sales totaled $15.46B for 2023. This segment will also grow in line with its market, 8.50%.On the other hand, Bing had a market share of around 10.53% in 2023 (which multiplied by the total amount of internet users in that year, means that Bing had around 543.13M users). After dividing the estimated $12.21B in revenue generated by Bing in 2023, I got that this division could be generating around $22.48 per user (which is lower than Google's $36.29). Then, I multiply that $22.48 in revenues per user by the estimated internet users to get the revenue estimates. This also yields a growth rate of 4.59% for 2023-2029 which I will use to project revenue for 2030-2033.Internet UsersBing's Share20245,254.00553.2520255,470.00575.9920265,690.00599.1620275,910.00622.3220286,350.00668.6620296,580.00692.87Click to enlargeMeanwhile, it's estimated that Microsoft Surface devices' sales tanked by 30% for 2023, which generated losses of up to $1.8B. By doing the rule of three, I found that Microsoft would have generated $6B in revenues for 2023. This segment will grow in line with the worldwide laptop market at 3.69%.Lastly, Windows operating system revenue is speculated to have been around $24.61B in 2023. This was calculated via the rule of three, since in 2023, Windows revenue fell by $3.2B which was 13%. Therefore, I calculated the 100% with that information. This segment will grow in line with the worldwide PC market at 1.13%.However, these calculations for 2023 say that Microsoft generated $63.35B for the \"More Personal Computing\" segment, which is substantially more than the reported $54.73B. Therefore, I will divide the $19.3B difference by the 5 subsegments, and then subtract the $3.806B result from each of them, so I can be able to correct the difference from the resulting segment result with the actual segment result.XboxPC AccessoriesBing & Microsoft EdgeMicrosoft Surface DevicesWindows Os202311,659.5211,672.528,403.522,193.5220,808.52202412,650.5813,088.4012,436.972,274.4621,043.66202513,725.8814,676.0212,948.282,358.3921,281.45202614,892.5816,456.2213,469.052,445.4121,521.93202716,158.4518,452.3613,989.822,535.6521,765.13202817,531.9220,690.6315,031.362,629.2122,011.07202919,022.1323,200.4015,575.812,726.2322,259.80203020,639.0126,014.6117,791.432,826.8322,511.33203122,393.3229,170.1920,322.222,931.1422,765.71203224,296.7632,708.5323,213.013,039.3023,022.97203326,361.9836,676.0726,515.013,151.4523,283.12Growth Rate %8.50%12.13%14.22%3.69%1.13%Click to enlargeThen, I will calculate net income. The first step is gross income, which I will maintain the current gross margin of 69.89%. Meanwhile, general expenses will be tied to full-time employees. In 2023 general expenses were $27.19B, which was divided by the number of employees at that time of 221K. This resulted in an expense per employee of $120K (this is also an indication that Microsoft pays goods). Then I will assume that Microsoft will hire 19.33K new workers annually, in line with 2021-2023.On the other hand, R&D expenses will be calculated with a margin tied to gross income, which currently stands at 17.05%.Then it's the time to calculate short & long-term debt and interest income & expenses. Short & long-term debt will have annual changes in line with their 2018-20222 performance of 26.4%, and -8.7% respectively. Meanwhile, marketable securities will be growing at a 4.2% annual rate.Then, I found that in 2019, when interest rates were lower than now, Microsoft paid a 3.11% interest on debt and received a 2.26% annual return on its marketable securities.However, for 2024TTM (when interest rates are high) Microsoft has paid a 2.60% interest on debt (yes, lower than when interest rates were lower) and has received a 5.67% return on marketable securities.So with this information, I will assume an interest on a debt payment of 2.60% throughout the project. Then I will assume that for 2024 and 2027 Microsoft will receive a 5.67% return on its marketable securities and for the other years, it will receive 2.26%. This is because I am expecting that for 2024 and 2027, interest rates will increase again. If you want to read the full explanation, you can check the valuation section of my article on JPMorgan Chase & Co. (JPM).Nevertheless, for 2030-2033, I will use the average marketable securities annual return of 3.96% (the average of 5.67% and 2.26%) since I have not made an interest rates projection for the years beyond 2029.Author's CalculationsRevenueNet IncomePlus TaxesPlus D&APlus Interest2024$252,160.0$96,208.66$121,411.75$137,846.96$140,091.072025$284,228.9$106,918.84$134,927.57$151,362.78$153,846.252026$320,971.8$121,768.87$153,667.72$174,587.92$177,522.652027$363,085.4$141,490.60$178,555.78$202,220.85$205,652.882028$411,904.6$159,289.99$201,017.91$227,864.90$231,956.742029$467,349.9$182,609.20$230,228.11$260,688.91$265,614.552030$533,737.4$211,816.29$267,304.04$302,091.82$308,071.132031$610,100.1$244,241.04$308,222.81$347,987.73$355,298.552032$696,857.7$281,168.43$354,823.73$400,243.31$409,236.742033$796,620.1$323,724.30$408,527.57$460,449.44$471,569.18^Final EBITA^Click to enlargeThen, I assume that current assets will grow at 1.72%, thus mirroring the performance during 2018-2022. Then, with this, I use the undiscounted cash flows highlighted in green and add the future equity value, which is composed of the future short & long-term debt, current assets, and marketable securities.Lastly, the perpetuity growth rate in the model is 1.82%. This number was calculated by dividing the resulting free cash flow growth rate from the projection (25.07%) and dividing it by the difference between it and the WACC of 11.35% (25.07%/(25.07%-11.35%)=1.82%).Author's CalculationsAs you can see, the model suggests that the stock (today) should be trading at $417.30, which is 6.5% below the current stock price of $446.34. For the future, the model suggests that the stock could be trading at $1,099.90 in 2033. Yes, that's a 146.4% upside from the current stock price, however when dividing that by the 10 years until the end of 2033, you get 14.6% annual returns.What if Azure could grow at 20-25% annually?If I increase Azure revenue growth from 15.66% to 20%, then the present fair price of Microsoft would be $484.22 (which is 8.5% above the current stock price), and a 2033 stock price target of $1,287.45 (which suggests 18.8% annual returns).Then, If I increase that 20% revenue growth to 25%, the present fair price increases to $600.74 and the future price to $1,617.07. The first number indicates a 34.6% undervaluation of Microsoft's stock, and the future price indicates 26.2% annual returns throughout 2033.But, is that possible?Since 2015, Intelligent Cloud has only surpassed the 30% growth rate in 2021. The average revenue growth rate of this segment has been 17.74%, which is slightly lower than the first 20% hypothetical scenario, and 7.26% lower than the second 25% hypothetical scenario.Annual Revenue of Microsoft's Intelligent CloudChange %2015236842016250405.73%2017274009.42%20183223017.63%20193899020.97%20204445014.00%20216000034.98%20227470024.50%20238693016.37%2024 TTM10085016.01%Click to enlargeIt's also worth noting that if I take out 2015 and 2016, the average Azure annual growth rate increases to 20.64%. However, the problem is that, in the past, when the cloud market was growing faster, Azure just achieved a growth rate of over 20% in 2019, 2021, and 2022. Thus, there's more probability that Azure will grow below the required 20% (which would make Microsoft undervalued by a mere 8.5%)Nevertheless, it's good that even with the 15.66% originally used in this projection, the suggested annual return of 14.6% is still above the historic 10.50% annual returns of the market, which sets Microsoft to be an outperformer, even if the stock price decreased by 6.5% to adjust to my fair stock price estimate of $417.30.Risks to ThesisThe main risk for my thesis is that Microsoft suddenly can achieve that high 30% growth rate that is required for a fair stock price of $496.21. This may be the reason why Microsoft's stock has been increasing past my fair stock price estimates because the optimism on Azure has passed the logical boundary.However, I think that there are more risks related to Microsoft than to my thesis, for example, Microsoft would have it very difficult to perform any big-scale acquisition such as the Activision one.Then, there is also the risk that Microsoft is more prone to lose market share than to gain it, yes Azure has grown its market share by 4% since 2020. However, that will be very difficult for Windows, or Microsoft Office. At best, what Microsoft could do is to boost the sales of Surface devices, however, the problem with that is the differentiation factor. What happened with IBM is that its PCs were made by third-party components to which the competition could also access, and then its computers lost ground to cheaper alternatives, and the same thing happens today.Evolution of My Fair Price EstimatesSince my first coverage on Microsoft, my fair price estimate has increased by 12.29%. Concerning my previous coverage, the reason for the increase from $397.49 to the present $417.30, the model I did in this article, covers 10 years, and not 6 as the previous one did. The main effect is that the total amount of cash flows increases in the model, which ultimately leads to an increased fair stock price.Author's CalculationsConclusionIn conclusion, Microsoft continues to be overvalued, however, Microsoft's current valuation (despite a 6.5% overvaluation) is a good point to enter (in my opinion) and wait for Azure to deliver higher returns than the 15.66% used for my estimates. The suggested annual returns in my base model are 14.6% (which already sets Microsoft as an outperformer against the market's 10.50% annual return average).Lastly, I assigned a near-term target for Microsoft's stock at $417.30, which is 6.5% below the current stock price of $446.34, and a 2033 stock price target at $1,099.90, which implies a 14.6% annual return throughout the 10 years.","news_type":1},"isVote":1,"tweetType":1,"viewCount":73,"commentLimit":10,"likeStatus":false,"favoriteStatus":false,"reportStatus":false,"symbols":[],"verified":2,"subType":0,"readableState":1,"langContent":"EN","currentLanguage":"EN","warmUpFlag":false,"orderFlag":false,"shareable":true,"causeOfNotShareable":"","featuresForAnalytics":[],"commentAndTweetFlag":false,"andRepostAutoSelectedFlag":false,"upFlag":false,"length":30,"xxTargetLangEnum":"ORIG"},"commentList":[],"hasMoreComment":false,"orderType":2}