Is Microsoft a good stock to buy at a market capitalization of $3.5 billion?

Ziggma stock scorecard showing Microsoft's current score of 89

Which factors have driven up Microsoft’s share price to a $3.5T marketcap?

Microsoft’s stock price has appreciated significantly over the past one to five years. It’s up by 40% over the past year and by 238% over the past five years. Understanding the drivers behind this surge requires a closer look at the company’s financial and strategic decisions as well as the market context. This analysis is a crucial element to answering the question is Microsoft a good stock to buy.

The Boom in artificial intelligence

Cloud services

Gaming

Microsoft’s attractive growth prospects

Two charts showing Microsoft's annual revenue and earnings per share respectively.

Strong but stagnating profitability

Although the company is massively profitable, it has been struggling to improve its profitability. EBITDA margin have barely improved over the past five years. And return on assets is hitting a ceiling at around 20%. Consequently, growth in margins is not a contributing factor to earnings growth.

2 charts show Microsoft's return on assets and EBITDA margin over 5 years respectively.

Still, Microsoft is an absolute cash machine. Having generated $81.5B in operating cashflow during the first three quarters of its current fiscal year, it is highly likely that Microsoft will surpass the $100B mark in net operating cashflow. Considering that R&D expenses are no more than a third of net free cashflow, that leaves a lot of spare cash.

A very rich valuation

Microsoft’s valuation stands at all-time by several measures. It’s long-term trailing PE ratio – a measure dear to famous value investor Benjamin Graham – stands at 45x. The 2024 forward PE ratio is at 39.5x. By a different measure, Price-to-Sales, Microsoft’s valuation is also at an all-time high at 15x.

One chart depicting Microsoft's long-term PE ratio and another stock depicting its long-term price to sales ratio.

Our assessment of the question is Microsoft a good stock to buy

It’s a hold at best. When carrying out a data-centric, fundamental analysis of Microsoft, the verdict is clear. The stock is very expensive. Though the company grows fast given its size, revenue and earnings growth in the mid-teens cannot justify such a rich valuation.

Buying Microsoft stock at a PE ratio of 40x is equivalent to an earnings yield of just 2.5%. That’s not a particularly attractive return for a stock, even if its name is Microsoft. You can earn 3x this yield by investing in stable and safe fixed income ETFs.

Does Microsoft’s stock price have room to run? Bull markets – both in general and in specific stocks – can continue for much longer than most investors would expect. So, it’s certainly possible that Microsoft’s stock price can go higher still. We can’t just find a good way to justify it through the numbers.