Loading...

Microsoft Corp (NASDAQ:MSFT)

291.54 USD -1.67 USD ( -0.57% )
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 Aug 17, 2022.

Estimated DCF Value of one MSFT stock is 187.77 USD. Compared to the current market price of 291.54 USD, the stock is Overvalued by 36%.

MSFT DCF Value
Base Case
187.77 USD
Overvaluation 36%
DCF Value
Price
Worst Case
Base Case
Best Case
187.77
DCF Value
Worst Case
Base Case
Best Case
Microsoft Corp Competitors:
DCF Valuation
FROG
Jfrog Ltd
600271
Aisino Co Ltd
PING
Ping Identity Holding Corp
VRNS
Varonis Systems Inc
4493
Cyber Security Cloud Inc
3040
Soliton Systems KK
688023
DBAPPSecurity Co Ltd
EXL
Exasol AG

Valuation Settings

Available Valuations
DCF Valuation Models

You can view valuation models created by the Alpha Spread algorithm, as well as models created by other investors.

1 valuation model available
Alpha Spread
Updated on Aug 17, 2022
Default Valuation
Other investors haven't shared any valuation models for Microsoft Corp. There is only Alpha Spread valuation model.

Valuation Settings
Alpha Spread's Valuation Model

You can change any inputs, such as future revenue growth, margins, etc. using our Present Value Calculation block.

Discount Rate
8.13%
Terminal Growth
0%
Growth Period
5 Years
Discount Rate
8.13%
Terminal Growth
0%
Growth Period
5 Years
Reset
Save as My Model

DCF Value Calculation

Capital Structure
From Present Value to DCF Value

Present Value 1.4T USD
+ Cash & Equivalents 13.9B USD
+ Investments 97.7B USD
Firm Value 1.5T USD
- Debt 60.9B USD
Equity Value 1.4T USD
/ Shares Outstanding 7.5B
MSFT DCF Value 187.77 USD
Overvalued by 36%

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

Present Value Calculation

Operating Model
Discounted Cash Flow Model

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 Model Financials
Financials used in the DCF Model

Sensitivity Analysis

Sensitivity Analysis
DCF Value Sensitivity Analysis

Analyze the possible values of MSFT stock DCF Value given various model inputs such as Revenue Growth, Operating Margin, and Discount Rate.

See Also

Similar Stocks

MSFT Stock DCF Valuation FAQ

What is the DCF value of one MSFT stock?

Estimated DCF Value of one MSFT stock is 187.77 USD. Compared to the current market price of 291.54 USD, the stock is Overvalued by 36%.

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.4T 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 187.77 USD per one MSFT share.