Hmmm_老虎社区_美港股上老虎

Huann
2021-08-06

Hmmm

Calm, Deep, And Versatile Look At Microsoft Valuation

Summary Microsoft continues to grow. Moreover, it is accelerating. By and large, the company's most

Calm, Deep, And Versatile Look At Microsoft Valuation

免责声明：上述内容仅代表发帖人个人观点，不构成本平台的任何投资建议。

推荐
最新

暂无评论

热议股票

{"i18n":{"language":"zh_CN"},"data":{"magic":2,"id":893391578,"tweetId":"893391578","gmtCreate":1628236256494,"gmtModify":1633752353141,"author":{"id":3561975876669218,"idStr":"3561975876669218","authorId":3561975876669218,"authorIdStr":"3561975876669218","name":"Huann","avatar":"https://static.tigerbbs.com/2ef3c08440569f5574b7f45ae2018c92","vip":1,"userType":1,"introduction":"","boolIsFan":false,"boolIsHead":false,"crmLevel":11,"crmLevelSwitch":0,"individualDisplayBadges":[],"fanSize":1,"starInvestorFlag":false},"themes":[],"images":[],"coverImages":[],"extraTitle":"","html":"<html><head></head><body>Hmmm</body></html>","htmlText":"<html><head></head><body>Hmmm</body></html>","text":"Hmmm","highlighted":1,"essential":1,"paper":1,"likeSize":4,"commentSize":1,"repostSize":0,"favoriteSize":0,"link":"https://laohu8.com/post/893391578","repostId":1172440547,"repostType":4,"repost":{"id":"1172440547","kind":"news","pubTimestamp":1628233708,"share":"https://www.laohu8.com/m/news/1172440547?lang=&edition=full","pubTime":"2021-08-06 15:08","market":"us","language":"en","title":"Calm, Deep, And Versatile Look At Microsoft Valuation","url":"https://stock-news.laohu8.com/highlight/detail?id=1172440547","media":"seekingalpha","summary":"Summary\n\nMicrosoft continues to grow. Moreover, it is accelerating.\nBy and large, the company's most","content":"Summary\n<ul>\n <li>Microsoft continues to grow. Moreover, it is accelerating.</li>\n <li>By and large, the company's most recent quarterly report was reflected in the company's price in advance.</li>\n <li>Technically, the company's share price has hit the ceiling now. This means that a sideways trend is quite likely in the near future, despite the excellent quarterly results.</li>\n</ul>\n<img src=\"https://static.tigerbbs.com/bd13176456827fe134fc15a4ce7b3d61\" tg-width=\"1536\" tg-height=\"864\" width=\"100%\" height=\"auto\">HJBC/iStock Editorial via Getty Images\nIntro\nThis article provides a comprehensive look at Microsoft's (MSFT)\n#1 First impression of quarterly results\nMicrosoft's quarterly net income rose by 47% YoY and revenue by 21.35%, beating analysts' expectations for the tenth straight quarter. But the most surprising thing is that the company has grown in almost all directions.\nLinkedIn revenue grew 46% due to 97% growth in LinkedIn Marketing Solutions. Revenue from server products and cloud services increased by 34% due to the growth of Azure by 51%. Revenue from sales of Dynamics products increased by 33%, Intelligent Cloud by 30% and by 25% Productivity and Business Processes. Revenue from commercial products Office and Windows increased by 20%:\n<img src=\"https://static.tigerbbs.com/2466fb5bb0bcbc5d36c348c80b29c90d\" tg-width=\"1280\" tg-height=\"561\" width=\"100%\" height=\"auto\">Source: Microsoft\nRevenue from devices of the Surface family fell by 20%. But this is probably due to a general deficiency of components.\nAll this led to the fact that the company's revenue turned out to be higher than its long-term trend, which is a sign ofaccelerating growth:\n<img src=\"https://static.tigerbbs.com/0bb7b9f7eb1cd9c05b38fba154eb5937\" tg-width=\"640\" tg-height=\"396\" width=\"100%\" height=\"auto\">Source: VisualizedAnalytics.com\n#2 Price vs. Growth\nConsidering Microsoft's capitalization as a function in which revenue is the independent variable, we get a model that indicates a slightly overvalued company present price:\n<img src=\"https://static.tigerbbs.com/f05c77cc215e2c37c59910671b49cebc\" tg-width=\"640\" tg-height=\"396\" width=\"100%\" height=\"auto\">Source: VisualizedAnalytics.com\nWe get the same result by considering EPS as the independent variable:\n<img src=\"https://static.tigerbbs.com/e54a36ec5fc53c984fb0db1e802bd900\" tg-width=\"640\" tg-height=\"396\" width=\"100%\" height=\"auto\">Source: VisualizedAnalytics.com\nHowever, the most qualitative model (R^2=0.98) in this case is built on the basis of Free Cash Flow. And this model indicates an almost perfect balanced state of the company's capitalization:\n<img src=\"https://static.tigerbbs.com/82c02d926d626494b75b6ee0e4d9d5d6\" tg-width=\"640\" tg-height=\"396\" width=\"100%\" height=\"auto\">Source: VisualizedAnalytics.com\nInterestingly enough, the EV/FCF multiple has responded well to Microsoft's Free Cash Flow growth rate over the past six years. And, as the following graph shows, the current growth rate of this indicatorperfectly justifies Microsoft's capitalization:\n<img src=\"https://static.tigerbbs.com/7e75b0d8abc1a4911b76450a76011b11\" tg-width=\"640\" tg-height=\"396\" width=\"100%\" height=\"auto\">Source: VisualizedAnalytics.com\nI understand that this is a very simplified view of the company's valuation, but in this context, Microsoft's capitalization is now balanced. In other words, the market has already reflected the company's quarterly results in price.Digging deeper...\n#3 Comparative Valuation\nIn the context of the comparative analysis, I only trust forward multiples and, ideally, adjusted for the expected growth rate. This is because the market is always focused on the future and companies are best compared at the same point in their life cycle. One of the solutions to this problem is the use of forward multiples, which are adjusted for the expected growth rate of the basic indicator.\nSo, this is what we get analyzing the forward P/S to growth (next FY) multiple:\n<img src=\"https://static.tigerbbs.com/37a65905afed4c1bbbd94d389a290605\" tg-width=\"640\" tg-height=\"396\" width=\"100%\" height=\"auto\">\n<img src=\"https://static.tigerbbs.com/9ed8dcb7352d7178668392ff949df60b\" tg-width=\"640\" tg-height=\"396\" width=\"100%\" height=\"auto\">Source: VisualizedAnalytics.com\nAnd this is what we get analyzing the forward P/E (next FY) multiple:\n<img src=\"https://static.tigerbbs.com/4edfc59bd30dc9a219c894d057f94dd6\" tg-width=\"640\" tg-height=\"396\" width=\"100%\" height=\"auto\">\n<img src=\"https://static.tigerbbs.com/b407508ae95e7b072fd09517db4e3931\" tg-width=\"640\" tg-height=\"396\" width=\"100%\" height=\"auto\">Source: VisualizedAnalytics.com\nIn both cases, comparing Microsoft to a broad sample of American technology companies, we get a result close to the company's current share price. Again, we draw a conclusion about the balanced state of the current price.\n#4 Discounted Cash Flow Model\nWhen predicting Microsoft's revenue for the next decade, I proceeded from the average expectations of&nbsp;analysts. But, even in the historical context, I consider it adequate to expect that the average annual growth rate of the company's revenue in the next 10 years will be about 12%.\n<img src=\"https://static.tigerbbs.com/aad53456538717d62c367fd15d74ffd7\" tg-width=\"635\" tg-height=\"371\" width=\"100%\" height=\"auto\">Data by YCharts\nThe operating margin of MSFT is relatively very high now:\n<img src=\"https://static.tigerbbs.com/a01c0a53deb1508eec2241f6d35ec762\" tg-width=\"635\" tg-height=\"371\" width=\"100%\" height=\"auto\">Data by YCharts\nBut I find it wrong to assume that Microsoft's operating margins will continue to grow in the future. First, because the dynamics of this indicator is cyclical in nature. Secondly, where there is a high margin, competition inevitably grows. Therefore, the model includes a forecast of a gradual decrease in the operating margin to a more adequate 33%.\nHere is the calculation of the Weighted Average Cost of Capital:\n<img src=\"https://static.tigerbbs.com/0e8d89ca266026af026dcf4cc69ae9bf\" tg-width=\"415\" tg-height=\"373\" width=\"100%\" height=\"auto\">Source: Author\nSome notes on the WACC calculation:\n<ul>\n <li>In order to calculate the market rate of return, I used values of equity&nbsp;risk</li>\n <li>I used the current&nbsp;value</li>\n <li>To calculate the Cost of Debt, I used the interest expense for 2020 and 2021 divided by the debt value for the same years.</li>\n</ul>\nOther important parameters of the model are as follows:\n<ul>\n <li>The relative size of CAPEX is assumed to be 10.7%, which is close to the long-term average.</li>\n <li>The tax rate is assumed to be 26%, which is close to the world&nbsp;average.</li>\n</ul>\nFinally, here is the model itself:\n<img src=\"https://static.tigerbbs.com/150b2e6192363e51dcf7b6db50a60d42\" tg-width=\"640\" tg-height=\"500\" width=\"100%\" height=\"auto\">Source: Author\nThe model shows Microsoft is undervalued by 8%. In fact, we once again state the balanced level of the company's capitalization.\n#5 Dividend Discount Model\nAs a basis for Microsoft's Dividend Discount Model, I took the average expectations of&nbsp;analysts&nbsp;regarding the company's EPS in the next decade. But this is not enough to predict the net income, because it is still necessary to predict the number of shares.\nThe number of Microsoft's diluted shares has been declining since 2012. Although the rate of decline has slowed down over the past two years:\n<img src=\"https://static.tigerbbs.com/a94c5cbb5d3e066b4b6ae92a103c7f85\" tg-width=\"635\" tg-height=\"371\" width=\"100%\" height=\"auto\">Data by YCharts\nI proceed from the assumption that the dynamics of the last two years will continue, and by the terminal year, the number of diluted shares will be reduced to 7.2 billion.\nAmong the other parameters, I want to highlight the following:\n<ul>\n <li>In the model, I assume that the payout ratio will remain at the average level of the last three years (35%).</li>\n <li>In the terminal year, I assume an increase in dividends of 3.5% (GDP growth of 2% and inflation of 1.5%).</li>\n</ul>\nHere is the model:\n<img src=\"https://static.tigerbbs.com/84bd13ccd121cc971801cc247b1e975e\" tg-width=\"640\" tg-height=\"283\" width=\"100%\" height=\"auto\">Source: Author\nThe DDM-based target price is 23% less than current levels. But, as long as the company has the potential for free cash flow growth, I think dividends are not the key motivation for investors. Therefore, in this case, this is a very strong result. For example, in the&nbsp;case&nbsp;of Apple (AAPL), things are much worse.\n#6 Technical picture\nMicrosoft stock has been following an exponential trend over the past decade:\n<img src=\"https://static.tigerbbs.com/0378e41b0b4020eb0425bb0470747f48\" tg-width=\"941\" tg-height=\"597\" width=\"100%\" height=\"auto\">Source: TradingView.com, Author\nIn this case, in order to highlight the usual linear channels, one should consider the graph with the logarithmic Y-axis:\n<img src=\"https://static.tigerbbs.com/019f435ae39ceee2cb122098609d9072\" tg-width=\"941\" tg-height=\"597\" width=\"100%\" height=\"auto\">Source: TradingView.com, Author\nIn this case, we are clearly fixing the movement in the ascending channel. Moreover, the price is now at the upper border of this channel. In fact, this means a strong zone of resistance.In such cases, it is appropriate to expect a sideways trend or even a correction:\n<img src=\"https://static.tigerbbs.com/369d216317a2215986670a5e6a16862b\" tg-width=\"941\" tg-height=\"597\" width=\"100%\" height=\"auto\">Source: TradingView.com, Author\nBottom line\nSo, I tried to look as versatile as possible at Microsoft in the light of the latest quarterly report and summarize the following:\n<ol>\n <li>The company continues to grow. Moreover, it is accelerating. In my opinion, this is the main condition for expecting capitalization growth.</li>\n <li>Fundamentally, the company is not undervalued. This means that, by and large, the company's most recent quarterly report was reflected in the company's price in advance.</li>\n <li>Technically, the company's share price has hit the ceiling now. This means that we need to calmly accept the fact that a sideways trend is quite likely in the near future, despite the excellent quarterly results. At the same time, the long-term upward trend remains relevant.</li>\n <li>I would also like to note the fact that given the current cost of capital, the present value of all potential Microsoft dividends assumes a fair price of the company at $220. And this is anexcellent result, considering that the company continues to grow in quantitative terms. This is a kind of bonus that a long-term investor will receive in addition to the likely increase in the share price.</li>\n</ol>","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>Calm, Deep, And Versatile Look At Microsoft Valuation</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\">\nCalm, Deep, And Versatile Look At Microsoft Valuation\n</h2>\n\n<h4 class=\"meta\">\n\n\n2021-08-06 15:08 GMT+8&nbsp;&nbsp;&nbsp;<a href=https://seekingalpha.com/article/4445689-calm-deep-and-versatile-look-at-microsoft-valuation>seekingalpha</a>\n\n\n</h4>\n\n</header>\n<article>\n<div>\nSummary\n\nMicrosoft continues to grow. Moreover, it is accelerating.\nBy and large, the company's most recent quarterly report was reflected in the company's price in advance.\nTechnically, the company's...\n\n<a href=\"https://seekingalpha.com/article/4445689-calm-deep-and-versatile-look-at-microsoft-valuation\">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/4445689-calm-deep-and-versatile-look-at-microsoft-valuation","is_english":true,"share_image_url":"https://static.laohu8.com/e9f99090a1c2ed51c021029395664489","article_id":"1172440547","content_text":"Summary\n\nMicrosoft continues to grow. Moreover, it is accelerating.\nBy and large, the company's most recent quarterly report was reflected in the company's price in advance.\nTechnically, the company's share price has hit the ceiling now. This means that a sideways trend is quite likely in the near future, despite the excellent quarterly results.\n\nHJBC/iStock Editorial via Getty Images\nIntro\nThis article provides a comprehensive look at Microsoft's (MSFT)\n#1 First impression of quarterly results\nMicrosoft's quarterly net income rose by 47% YoY and revenue by 21.35%, beating analysts' expectations for the tenth straight quarter. But the most surprising thing is that the company has grown in almost all directions.\nLinkedIn revenue grew 46% due to 97% growth in LinkedIn Marketing Solutions. Revenue from server products and cloud services increased by 34% due to the growth of Azure by 51%. Revenue from sales of Dynamics products increased by 33%, Intelligent Cloud by 30% and by 25% Productivity and Business Processes. Revenue from commercial products Office and Windows increased by 20%:\nSource: Microsoft\nRevenue from devices of the Surface family fell by 20%. But this is probably due to a general deficiency of components.\nAll this led to the fact that the company's revenue turned out to be higher than its long-term trend, which is a sign ofaccelerating growth:\nSource: VisualizedAnalytics.com\n#2 Price vs. Growth\nConsidering Microsoft's capitalization as a function in which revenue is the independent variable, we get a model that indicates a slightly overvalued company present price:\nSource: VisualizedAnalytics.com\nWe get the same result by considering EPS as the independent variable:\nSource: VisualizedAnalytics.com\nHowever, the most qualitative model (R^2=0.98) in this case is built on the basis of Free Cash Flow. And this model indicates an almost perfect balanced state of the company's capitalization:\nSource: VisualizedAnalytics.com\nInterestingly enough, the EV/FCF multiple has responded well to Microsoft's Free Cash Flow growth rate over the past six years. And, as the following graph shows, the current growth rate of this indicatorperfectly justifies Microsoft's capitalization:\nSource: VisualizedAnalytics.com\nI understand that this is a very simplified view of the company's valuation, but in this context, Microsoft's capitalization is now balanced. In other words, the market has already reflected the company's quarterly results in price.Digging deeper...\n#3 Comparative Valuation\nIn the context of the comparative analysis, I only trust forward multiples and, ideally, adjusted for the expected growth rate. This is because the market is always focused on the future and companies are best compared at the same point in their life cycle. One of the solutions to this problem is the use of forward multiples, which are adjusted for the expected growth rate of the basic indicator.\nSo, this is what we get analyzing the forward P/S to growth (next FY) multiple:\n\nSource: VisualizedAnalytics.com\nAnd this is what we get analyzing the forward P/E (next FY) multiple:\n\nSource: VisualizedAnalytics.com\nIn both cases, comparing Microsoft to a broad sample of American technology companies, we get a result close to the company's current share price. Again, we draw a conclusion about the balanced state of the current price.\n#4 Discounted Cash Flow Model\nWhen predicting Microsoft's revenue for the next decade, I proceeded from the average expectations of analysts. But, even in the historical context, I consider it adequate to expect that the average annual growth rate of the company's revenue in the next 10 years will be about 12%.\nData by YCharts\nThe operating margin of MSFT is relatively very high now:\nData by YCharts\nBut I find it wrong to assume that Microsoft's operating margins will continue to grow in the future. First, because the dynamics of this indicator is cyclical in nature. Secondly, where there is a high margin, competition inevitably grows. Therefore, the model includes a forecast of a gradual decrease in the operating margin to a more adequate 33%.\nHere is the calculation of the Weighted Average Cost of Capital:\nSource: Author\nSome notes on the WACC calculation:\n\nIn order to calculate the market rate of return, I used values of equity risk\nI used the current value\nTo calculate the Cost of Debt, I used the interest expense for 2020 and 2021 divided by the debt value for the same years.\n\nOther important parameters of the model are as follows:\n\nThe relative size of CAPEX is assumed to be 10.7%, which is close to the long-term average.\nThe tax rate is assumed to be 26%, which is close to the world average.\n\nFinally, here is the model itself:\nSource: Author\nThe model shows Microsoft is undervalued by 8%. In fact, we once again state the balanced level of the company's capitalization.\n#5 Dividend Discount Model\nAs a basis for Microsoft's Dividend Discount Model, I took the average expectations of analysts regarding the company's EPS in the next decade. But this is not enough to predict the net income, because it is still necessary to predict the number of shares.\nThe number of Microsoft's diluted shares has been declining since 2012. Although the rate of decline has slowed down over the past two years:\nData by YCharts\nI proceed from the assumption that the dynamics of the last two years will continue, and by the terminal year, the number of diluted shares will be reduced to 7.2 billion.\nAmong the other parameters, I want to highlight the following:\n\nIn the model, I assume that the payout ratio will remain at the average level of the last three years (35%).\nIn the terminal year, I assume an increase in dividends of 3.5% (GDP growth of 2% and inflation of 1.5%).\n\nHere is the model:\nSource: Author\nThe DDM-based target price is 23% less than current levels. But, as long as the company has the potential for free cash flow growth, I think dividends are not the key motivation for investors. Therefore, in this case, this is a very strong result. For example, in the case of Apple (AAPL), things are much worse.\n#6 Technical picture\nMicrosoft stock has been following an exponential trend over the past decade:\nSource: TradingView.com, Author\nIn this case, in order to highlight the usual linear channels, one should consider the graph with the logarithmic Y-axis:\nSource: TradingView.com, Author\nIn this case, we are clearly fixing the movement in the ascending channel. Moreover, the price is now at the upper border of this channel. In fact, this means a strong zone of resistance.In such cases, it is appropriate to expect a sideways trend or even a correction:\nSource: TradingView.com, Author\nBottom line\nSo, I tried to look as versatile as possible at Microsoft in the light of the latest quarterly report and summarize the following:\n\nThe company continues to grow. Moreover, it is accelerating. In my opinion, this is the main condition for expecting capitalization growth.\nFundamentally, the company is not undervalued. This means that, by and large, the company's most recent quarterly report was reflected in the company's price in advance.\nTechnically, the company's share price has hit the ceiling now. This means that we need to calmly accept the fact that a sideways trend is quite likely in the near future, despite the excellent quarterly results. At the same time, the long-term upward trend remains relevant.\nI would also like to note the fact that given the current cost of capital, the present value of all potential Microsoft dividends assumes a fair price of the company at $220. And this is anexcellent result, considering that the company continues to grow in quantitative terms. This is a kind of bonus that a long-term investor will receive in addition to the likely increase in the share price.","news_type":1,"symbols_score_info":{"MSFT":0.9}},"isVote":1,"tweetType":1,"viewCount":747,"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":4,"xxTargetLangEnum":"ORIG"},"commentList":[],"hasMoreComment":false,"orderType":2}

Calm, Deep, And Versatile Look At Microsoft Valuation

评论（1）

热议股票