Microsoft Financial Statements Trends

MSFT -- USA Stock  

USD 104.91  0.52  0.49%

This module enables investors to look at Microsoft various fundamental indicators over time in order to gain insight into the company future performance. Macroaxis historical fundamental analysis tools allow evaluation of not only typical financial statement drivers such as Consolidated Income of 19.8 B, Cost of Revenue of 38.6 B or Earning Before Interest and Taxes EBIT of 23.2 B, but also many exotic indicators such as Interest Coverage of 69.8339, Long Term Debt to Equity of 0.6664 or Calculated Tax Rate of 17.5896. This module is a perfect complement to use when analyzing Microsoft Valuation or Volatility. It can also complement various Microsoft Technical models. Please see also analysis of Microsoft Correlation with competitors.

Balance Sheet

Current ValueLast YearHistorical Average 10 Year Trend
Total Assets193.5 B193.5 B143 B
Increasing
Slightly volatile
Cash and Equivalents132.3 B113.2 B78.9 B
Increasing
Slightly volatile
Investments12.3 B10.4 B10.7 B
Increasing
Stable
Investments Non Current12.3 B10.4 B10.7 B
Increasing
Stable
Deferred Revenue39.9 B33.9 B23.9 B
Increasing
Slightly volatile
Inventory2.6 B2.3 B1.8 B
Increasing
Slightly volatile
Tax Assets2.3 B1.9 B2 B
Decreasing
Very volatile
Trade and Non Trade Receivables21.5 B18.3 B15.8 B
Increasing
Slightly volatile
Trade and Non Trade Payables8.5 B7.2 B5.9 B
Increasing
Slightly volatile
Goodwill and Intangible Assets25.4 B21.6 B18 B
Increasing
Slightly volatile
Total Liabilities142.9 B121.5 B78.7 B
Increasing
Slightly volatile
Shareholders Equity84.7 B72 B67.2 B
Increasing
Slightly volatile
Accumulated Retained Earnings Deficit2.7 B2.3 B1.5 B
Increasing
Stable
Accumulated Other Comprehensive Income1.8 B1.5 B1.9 B
Increasing
Very volatile
Current Assets139.7 B139.7 B100.1 B
Increasing
Slightly volatile
Assets Non Current63.3 B53.8 B43.7 B
Increasing
Slightly volatile
Current Liabilities59.4 B59.4 B41.2 B
Increasing
Slightly volatile
Liabilities Non Current73.1 B62.1 B36.6 B
Increasing
Slightly volatile
Tax Liabilities2.4 B2.1 B2.1 B
Increasing
Slightly volatile
Total Debt88.6 B53.5 B30.3 B
Increasing
Slightly volatile
Debt Current15.2 B12.9 B6.2 B
Increasing
Slightly volatile
Debt Non Current47.7 B40.6 B22.1 B
Increasing
Slightly volatile
Shareholders Equity USD84.7 B72 B67.2 B
Increasing
Slightly volatile
Cash and Equivalents USD133.2 B113.2 B79 B
Increasing
Slightly volatile
Total Debt USD62.9 B53.5 B28.2 B
Increasing
Slightly volatile

Income Statement

Current ValueLast YearHistorical Average 10 Year Trend
Revenues99.3 B85.3 B75.3 B
Increasing
Slightly volatile
Cost of Revenue38.6 B32.8 B23.2 B
Increasing
Slightly volatile
Research and Development Expense14.1 B12 B10.4 B
Increasing
Slightly volatile
Operating Expenses38.1 B32.4 B30.3 B
Increasing
Slightly volatile
Income Tax Expense3.5 B3 B4.6 B
Decreasing
Slightly volatile
Consolidated Income19.8 B16.8 B17.3 B
Increasing
Stable
Net Income11.5 B16.8 B16.6 B
Increasing
Very volatile
Net Income Common Stock19.8 B16.8 B17.3 B
Increasing
Stable
Weighted Average Shares7.7 B7.9 B8.5 B
Decreasing
Slightly volatile
Weighted Average Shares Diluted9.4 B8 B8.7 B
Decreasing
Slightly volatile
Earning Before Interest and Taxes EBIT23.2 B19.8 B21.8 B
Increasing
Very volatile
Revenues USD100.4 B85.3 B75.4 B
Increasing
Slightly volatile
Net Income Common Stock USD19.8 B16.8 B17.3 B
Increasing
Stable
Earning Before Interest and Taxes USD23.2 B19.8 B21.8 B
Increasing
Very volatile
Gross Profit55.7 B52.5 B51.7 B
Increasing
Slightly volatile
Operating Income23.7 B20.2 B21.8 B
Increasing
Stable

Cash Flow Statement

Trends Matrix
Current ValueLast YearHistorical Average 10 Year Trend
Capital Expenditure(9.8 B)(8.3 B)(5.1 B)
Decreasing
Slightly volatile
Net Cash Flow Business Acquisitions and Disposals(1.6 B)(1.4 B)(2.5 B)
Decreasing
Very volatile
Net Cash Flow Investment Acquisitions and Disposals(17 B)(14.4 B)(12.5 B)
Decreasing
Slightly volatile
Net Cash Flow from Financing(9.9 B)(8.4 B)(8.8 B)
Decreasing
Stable
Issuance Repayment of Debt Securities 21.5 B18.3 B10.1 B
Increasing
Slightly volatile
Issuance Purchase of Equity Shares(18 B)(15.3 B)(10.3 B)
Decreasing
Slightly volatile
Payment of Dividends and Other Cash Distributions (12.9 B)(11 B)(7.8 B)
Decreasing
Slightly volatile
Net Cash Flow from Investing(28.2 B)(23.9 B)(20.1 B)
Decreasing
Slightly volatile
Net Cash Flow from Operations14.9 B33.3 B26.8 B
Increasing
Slightly volatile
Effect of Exchange Rate Changes on Cash (78.8 M)(67 M)(52.7 M)
Decreasing
Slightly volatile
Net Cash Flow or Change in Cash and Cash Equivalents1.1 B915 M(151.7 M)
Increasing
Stable
Share Based Compensation3.1 B2.7 B2.4 B
Increasing
Slightly volatile

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Earnings per Basic Share2.49412.122.0678
Increasing
Slightly volatile
Earnings per Diluted Share1.482.11.9617
Increasing
Stable
Earnings per Basic Share USD2.49412.122.0678
Increasing
Slightly volatile
Dividends per Basic Common Share1.63531.390.9538
Increasing
Slightly volatile
Return on Average Equity0.15410.2230.2673
Decreasing
Slightly volatile
Return on Average Assets0.0690.0920.1389
Decreasing
Slightly volatile
Return on Invested Capital0.44940.3820.9315
Decreasing
Slightly volatile
Gross Margin0.72470.6160.7201
Decreasing
Slightly volatile
Profit Margin0.11570.1970.231
Decreasing
Slightly volatile
EBITDA Margin0.36350.3090.3699
Decreasing
Slightly volatile
Return on Sales0.27180.2310.3094
Decreasing
Slightly volatile
Asset Turnover0.55180.4690.5854
Decreasing
Slightly volatile
Payout Ratio0.77180.6560.4632
Increasing
Slightly volatile
Enterprise Value over EBITDA15.303513.00811.6185
Decreasing
Very volatile
Enterprise Value over EBIT20.017.013.8333
Increasing
Stable
Price to Earnings Ratio70.4524.13725.3632
Increasing
Slightly volatile
Sales per Share12.665910.7669.098
Increasing
Slightly volatile
Price to Sales Ratio8.064.7535.2347
Decreasing
Stable
Price to Book Value10.115.5875.3798
Increasing
Stable
Debt to Equity Ratio1121.68710.2977
Increasing
Slightly volatile
Dividend Yield0.03180.0270.0239
Increasing
Slightly volatile
Current Ratio3.42.3532.6287
Decreasing
Very volatile
Free Cash Flow per Share17.223.1523.9667
Increasing
Slightly volatile
Book Value per Share10.79889.1798.1199
Increasing
Slightly volatile
Tangible Assets Book Value per Share25.776521.9115.6449
Increasing
Slightly volatile
Total Assets Per Share29.184824.807118.0372
Increasing
Slightly volatile
Cash Flow Per Share5.02124.26813.5525
Increasing
Slightly volatile
Return on Investment19.699416.744430.7907
Decreasing
Slightly volatile
Operating Margin35.3423.654530.8382
Decreasing
Slightly volatile
Calculated Tax Rate17.589614.951121.6003
Decreasing
Slightly volatile
Receivables Turnover5.53284.70294.8844
Increasing
Very volatile
Inventory Turnover14.967912.722713.1778
Increasing
Very volatile
PPandE Turnover6.05085.14327.7219
Decreasing
Slightly volatile
Cash and Equivalents Turnover16.53914.058112.023
Increasing
Slightly volatile
Accounts Payable Turnover14.842112.615715.1308
Decreasing
Slightly volatile
Accrued Expenses Turnover19.324816.42619.1003
Decreasing
Slightly volatile
Interest Coverage69.833959.3588828
Decreasing
Slightly volatile
Long Term Debt to Equity0.66640.56650.3141
Increasing
Slightly volatile
Quick Ratio2.60672.21572.1744
Increasing
Slightly volatile
Net Current Assets as percentage of Total Assets48.774941.458739.5745
Increasing
Slightly volatile
Revenue to Assets0.51820.44050.5798
Decreasing
Slightly volatile

Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Earnings before Tax23.2 B19.8 B21.8 B
Increasing
Very volatile
Market Capitalization800.5 B402.2 B356.6 B
Increasing
Slightly volatile
Enterprise Value738.9 B343.1 B306.5 B
Increasing
Slightly volatile
Invested Capital67.3 B57.2 B35.2 B
Increasing
Slightly volatile
Average Equity88.5 B75.3 B67.2 B
Increasing
Slightly volatile
Average Assets214.2 B182.1 B137.2 B
Increasing
Slightly volatile
Invested Capital Average60.8 B51.7 B33.3 B
Increasing
Slightly volatile
Tangible Asset Value202.2 B171.9 B128 B
Increasing
Slightly volatile
Free Cash Flow29.4 B25 B23.7 B
Increasing
Slightly volatile
Working Capital80.3 B80.3 B58.9 B
Increasing
Slightly volatile
Revenue Per Employee878.1 K746.4 K742.7 K
Increasing
Slightly volatile
Net Income Per Employee172.9 K146.9 K174.4 K
Decreasing
Slightly volatile

Thematic Opportunities

Explore Investment Opportunities
Build portfolios using Macroaxis predefined set of investing ideas. Many of Macroaxis investing ideas can easily outperform a given market. Ideas can also be optimized per your risk profile before portfolio origination is invoked.
Explore Thematic Ideas
Explore Investing Ideas  

Microsoft Upcoming Company Events

Upcoming Quarterly ReportApril 20, 2017
Next Earnings ReportJuly 18, 2017
Please see also analysis of Microsoft Correlation with competitors. Please also try Equity Valuation module to check real value of public entities based on technical and fundamental data.