Microsoft Corp (NASDAQ:MSFT)

244.32 USD -4.56 USD ( -1.83% )
Watchlist Manager
Microsoft Corp Logo
Microsoft Corp

DCF Value

This DCF valuation model was created by Alpha Spread and was last updated on Oct 4, 2022.

Estimated DCF Value of one MSFT stock is 170.4 USD. Compared to the current market price of 244.32 USD, the stock is Overvalued by 30%.

Base Case
170.4 USD
Overvaluation 30%
DCF Value
Worst Case
Base Case
Best Case
DCF Value
Worst Case
Base Case
Best Case
DCF Value: 170.4 USD
Microsoft Corp Competitors:
DCF Valuation
Check Point Software Technologies Ltd
Sylogist Ltd
UiPath Inc
Knowbe4 Inc
Amiya Corp
Suse SA
Avast PLC
Darktrace PLC

Present Value Calculation

The first step in the DCF calculation process is to estimate the company's future free cash flow. Once free cash flow is forecasted, it is discounted at a risk-appropriate discount rate. The resulting value is the present value of the company's free cash flow. You can change any model inputs below.

Available Valuation Models
2 valuation models available
Alpha Spread
Updated on Oct 4, 2022
Default Valuation
Updated on Sep 24, 2022
Set As Default
Create My Valuation Model
Model Settings
Discount Rate
Forecast Period
5 Years
Terminal Growth
Discount Rate
Terminal Growth
Growth Period
5 Years
Copy as My Model

DCF Model
Base Case Scenario

Rotate your device for better experience.

To view the process of deriving the DCF Value of one share from the estimated Present Value, see the DCF Value Calculation block.

DCF Value Calculation

Depending on which type of operating model is chosen (equity or whole firm valuation model), the resulting value is either the value of equity or the value of the entire firm. In the case of the latter, to move from the value of the firm to the value of equity, liabilities are subtracted and assets are added.

Capital Structure
From Present Value to DCF Value

Present Value 1.2T USD
+ Cash & Equivalents 13.9B USD
+ Investments 97.7B USD
Firm Value 1.3T USD
- Debt 60.9B USD
Equity Value 1.3T USD
/ Shares Outstanding 7.5B
MSFT DCF Value 170.4 USD
Overvalued by 30%

To view the process of calculating the Present Value of Microsoft Corp' future free cash flow, see the Present Value Calculation block.

Valuation Analysis

After the valuation process, in order to gain a deeper understanding of the relationship between risk and opportunity, it is useful to study the dynamic of company's valuation under various inputs to the DCF model in use.

DCF Financials
Financials used in DCF Calculation

225B 382B
Operating Income
92.7B 146B
85B 118B

Sensitivity Analysis
DCF Value Sensitivity Analysis

See Also

Similar Stocks
What is the DCF value of one MSFT stock?

Estimated DCF Value of one MSFT stock is 170.4 USD. Compared to the current market price of 244.32 USD, the stock is Overvalued by 30%.

The true DCF Value lies somewhere between the worst-case and best-case scenario values. This is because the future is not predetermined, and the stock's DCF Value is based almost entirely on the future of the company. Knowing the full range of possible stock DCF values gives a complete picture of the investment risks and opportunities.

How was the DCF Value calculated?

1. Present Value Calculation. Using the DCF Operating Model we project Microsoft Corp's future free cash flow and discount it at a selected discount rate to calculate its Present Value (1.2T USD).

2. DCF Value Calculation. We use the company's capital structure to calculate the total Equity Value based on the previously computed Present Value of the free cash flow. Dividing the Equity Value by the number of shares outstanding gives us the DCF Value of 170.4 USD per one MSFT share.