Here are some sample widgets you could interact with from this dashboard:
(1) Revenues expected to be slightly ahead of consensus estimates
Trefis estimates MSFT's FQ4 2021 revenues to be $42.6 Bil, slightly ahead of the consensus estimate of $41.0 Bil
Estimated Revenues - 2021Q4(E)
Trefis Estimates for Microsoft Revenues:
Expected Change (YoY): 12.1%
The chart to the right highlights trends in Microsoft's Revenues over the last four quarters along with our forecast for FQ4 2021.
Quarterly Revenue Trend
(2) EPS likely to miss consensus estimates
MSFT's FQ4 2021 earnings per share (EPS) expected to be $1.25 per Trefis analysis, missing the consensus estimate of $1.77 by 29%
Estimated EPS- 2021Q4(E)
Trefis Estimates for Microsoft EPS:
Expected Change (YoY): -15.5%
The chart to the right highlights trends in MSFT's EPS over the last four quarters along with our forecast for FQ4 2021.
Quarterly EPS Trend
(3) Stock price estimate 4.5% higher than current market price
Trefis maintains a fair value of $292 for MSFT's stock as opposed to the current market price of roughly $279.
MSFT Stock Price
The Trefis Price Estimate for Microsoft stock represents the fair value for the company's stock over a one-year horizon.
Details about the chances of a rise in MSFT stock in the near term can be found in a separate interactive dashboard.
The chart to the right highlights trends in MSFT's stock price at the end of each of the last four quarters as well as the current stock price.
Stock Price (Quarter End)
#1. Estimating Microsoft's Total Revenues:
Microsoft's Revenues have seen a significant increase of 29.6% from around $110 Bil in FY2018 to $143 Bil in FY2020 and we expect it to increase to $165 Bil in FY2021
A Separate Interactive Dashboard Analysis On Microsoft's Revenues Details How The Company Makes Money.
#2. Deriving Microsoft's Net Income:
Microsoft's Net Income has increased from around $17 Bil in FY2018 to $44 Bil in FY2020 and we expect it to increase to $55 Bil in FY2021
This change is likely to be led by higher revenues and improved margins.
A Separate Interactive Dashboard Analysis On Microsoft's Margins Highlights The Company's Various Expenses Components In Detail.
Net Income [AxB]
Net Income Margin [A]
Total Revenue [B]
#3. Determining Microsoft's EPS:
Microsoft's EPS has increased from $2.13 in FY2018 to $5.76 in FY2020 and we expect it to increase to $7.19 in FY2021
The change in EPS can be attributed to an increase in net income and a lower expected share count due to stock repurchases.
Net Income [A]
Shares Outstanding [B]
#4. Estimating Microsoft's Share Price:
Our Price Estimate of $292 For Microsoft's Stock is based on our Detailed Valuation Model, and implies a 40.6x P/E Multiple on expected FY2021 EPS of $7.19
Trefis Price Estimate [AxB]
P/E Multiple [B]