Loading...

Microsoft Corp (NASDAQ:MSFT)

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

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%.

MSFT DCF Value
Base Case
170.4 USD
Overvaluation 30%
DCF Value
Price
Worst Case
Base Case
Best Case
170.4
DCF Value
Worst Case
Base Case
Best Case
Hide
DCF Value: 170.4 USD
Microsoft Corp Competitors:
DCF Valuation
CHKP
Check Point Software Technologies Ltd
SYZ
Sylogist Ltd
PATH
UiPath Inc
KNBE
Knowbe4 Inc
4258
Amiya Corp
SUSE
Suse SA
AVST
Avast PLC
DARK
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
Alex
Updated on Sep 24, 2022
Set As Default
Create My Valuation Model
Model Settings
Discount Rate
9.14%
Forecast Period
5 Years
Terminal Growth
0%
Discount Rate
9.14%
Terminal Growth
0%
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

Revenue
225B 382B
Operating Income
92.7B 146B
FCFF
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.