Microsoft Corp. DCF Valuation: Is The Stock Undervalued?

As part of a new series, each week we typically conduct a DCF on one of the companies in our screens. This week we thought we’d take a look at one of the stocks that is not currently in our screens, Microsoft Corp (MSFT).
 

Profile

Microsoft develops and licenses consumer and enterprise software. It is known for its Windows operating systems and Office productivity suite. The company is organized into three equally sized broad segments: productivity and business processes (legacy Microsoft Office, cloud-based Office 365, Exchange, SharePoint, Skype, LinkedIn, Dynamics), intelligence cloud (infrastructure- and platform-as-a-service offerings Azure, Windows Server OS, SQL Server), and more personal computing (Windows Client, Xbox, Bing search, display advertising, and Surface laptops, tablets, and desktops).
 

Recent Performance

Over the past twelve months the share price is up 47.84%.

MSFT Chart

MSFT data by YCharts

Inputs

  • Discount Rate: 8%
  • Terminal Growth Rate: 2%
  • WACC: 8%

Forecasted Free Cash Flows (FCFs)

Year FCF (billions) PV(billions)
2024 75.5 69.91
2025 86.2 73.90
2026 99 78.59
2027 113 83.06
2028 129 87.80

Terminal Value

Terminal Value = FCF * (1 + g) / (r – g) = 2193.00 billion

Present Value of Terminal Value

PV of Terminal Value = Terminal Value / (1 + WACC)^5 = 1492.52 billion

Present Value of Free Cash Flows

Present Value of FCFs = ∑ (FCF / (1 + r)^n) = 393.25 billion

Enterprise Value

Enterprise Value = Present Value of FCFs + Present Value of Terminal Value = 1885.77 billion

Net Debt

Net Debt = Total Debt – Total Cash = 56.92 billion

Equity Value

Equity Value = Enterprise Value – Net Debt = 1828.85 billion

Per-Share DCF Value

Per-Share DCF Value = Enterprise Value / Number of Shares Outstanding = $246.08
 

Conclusion

DCF Value Current Price Margin of Safety
$246.08 $427.84 -73.86%

Based on the DCF valuation, the stock is overvalued. The DCF value of $246.08 per share is lower than the current market price of $427.84. The Margin of Safety is -73.86%


More By This Author:

Tesla Inc. DCF Valuation: Is The Stock Undervalued?
Large-Cap Stocks In Trouble: Here Are The 10 Worst Performers Over The Past 12 Months
10 Big-Name Stocks Near 52 Week Lows: Are They A Buy?

Disclosure: None.

How did you like this article? Let us know so we can better customize your reading experience.

Comments

Leave a comment to automatically be entered into our contest to win a free Echo Show.