Microsoft Corp

Find Ratings Reports
MSFT : NASDAQ : Technology
$72.49 | %
Today's Range: 71.93 - 72.84
Avg. Daily Volume: 2.43867E7
08/18/17 - 4:00 PM ET

Financial Analysis


MICROSOFT CORP's gross profit margin for the fourth quarter of its fiscal year 2017 is essentially unchanged when compared to the same period a year ago. The company has grown its sales and net income during the past quarter when compared with the same quarter a year ago, and although its growth in net income has outpaced the industry average, its revenue growth has not. MICROSOFT CORP is extremely liquid. Currently, the Quick Ratio is 2.37 which clearly shows the ability to cover any short-term cash needs. MSFT managed to increase the liquidity from the same period a year ago, despite already having very strong liquidity to begin with. This would indicate improved cash flow.

During the same period, stockholders' equity ("net worth") has remained unchanged from the same quarter last year. Overall, the key liquidity measurements indicate that the company is very unlikely to face financial difficulties in the near future.

STOCKS TO BUY: TheStreet Quant Ratings has identified a handful of stocks that can potentially TRIPLE in the next 12-months. To learn more visit www.TheStreetRatings.com.



Income Statement Q4 FY17 Q4 FY16
Net Sales ($mil)23317.020614.0
EBITDA ($mil)7979.06100.0
EBIT ($mil)5636.04190.0
Net Income ($mil)6513.03122.0


Balance Sheet Q4 FY17 Q4 FY16
Cash & Equiv. ($mil)132981.0113240.0
Total Assets ($mil)241086.0193694.0
Total Debt ($mil)88707.053687.0
Equity ($mil)72394.071997.0


Profitability Q4 FY17 Q4 FY16
Gross Profit Margin73.7870.56
EBITDA Margin34.2129.59
Operating Margin24.1720.33
Sales Turnover0.370.44
Return on Assets8.798.67
Return on Equity29.2823.33
Debt Q4 FY17 Q4 FY16
Current Ratio2.482.35
Debt/Capital0.550.43
Interest Expense655.0345.0
Interest Coverage8.612.14


Share Data Q4 FY17 Q4 FY16
Shares outstanding (mil)7708.07808.0
Div / share0.390.36
EPS0.830.39
Book value / share9.399.22
Institutional Own % n/a n/a
Avg Daily Volume2.4883448E72.1839382E7

Valuation


BUY. This stock's P/E ratio indicates a significant discount compared to an average of 57.91 for the Software industry and a premium compared to the S&P 500 average of 24.31. For additional comparison, its price-to-book ratio of 7.60 indicates a significant premium versus the S&P 500 average of 3.03 and a discount versus the industry average of 8.42. The price-to-sales ratio is well above the S&P 500 average, but well below the industry average. Upon assessment of these and other key valuation criteria, MICROSOFT CORP proves to trade at a discount to investment alternatives within the industry.


Price/Earnings
1 2 3 4 5
premium   discount
  Price/Cash Flow
1 2 3 4 5
premium   discount
MSFT 26.45 Peers 57.91   MSFT 13.93 Peers 36.42

Discount. A lower P/E ratio than its peers can signify a less expensive stock or lower growth expectations.

MSFT is trading at a significant discount to its peers.

 

Discount. The P/CF ratio, a stock’s price divided by the company's cash flow from operations, is useful for comparing companies with different capital requirements or financing structures.

MSFT is trading at a significant discount to its peers.

 
Price/Projected
Earnings
1 2 3 4 5
premium   discount
  Price to
Earnings/Growth
1 2 3 4 5
premium   discount
MSFT 19.73 Peers 38.13   MSFT 1.49 Peers 1.10

Discount. A lower price-to-projected earnings ratio than its peers can signify a less expensive stock or lower future growth expectations.

MSFT is trading at a significant discount to its peers.

 

Premium. The PEG ratio is the stock’s P/E divided by the consensus estimate of long-term earnings growth. Faster growth can justify higher price multiples.

MSFT trades at a significant premium to its peers.

 
Price/Book
1 2 3 4 5
premium   discount
  Earnings Growth
1 2 3 4 5
lower   higher
MSFT 7.60 Peers 8.42   MSFT 29.18 Peers 87.98

Average. A lower price-to-book ratio makes a stock more attractive to investors seeking stocks with lower market values per dollar of equity on the balance sheet.

MSFT is trading at a valuation on par with its peers.

 

Lower. Elevated earnings growth rates can lead to capital appreciation and justify higher price-to-earnings ratios.

However, MSFT is expected to significantly trail its peers on the basis of its earnings growth rate.

 
Price/Sales
1 2 3 4 5
premium   discount
  Sales Growth
1 2 3 4 5
premium   discount
MSFT 6.12 Peers 6.83   MSFT 5.42 Peers 11.94

Discount. In the absence of P/E and P/B multiples, the price-to-sales ratio can display the value investors are placing on each dollar of sales.

MSFT is trading at a discount to its industry on this measurement.

 

Lower. A sales growth rate that trails the industry implies that a company is losing market share.

MSFT significantly trails its peers on the basis of sales growth

 

 

Latest Stock Upgrades/Downgrades