Microsoft Financial Statements Trends

Microsoft Corporation -- USA Stock  

USD 86.96  2.27  2.68%

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 15.3 B, Cost of Revenue of 34.6 B or Earning Before Interest and Taxes EBIT of 20.1 B, but also many exotic indicators such as Interest Coverage of 668, Long Term Debt to Equity of 0.4809 or Calculated Tax Rate of 25.8252. 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
Accumulated Other Comprehensive Income2.1 B1.5 B2 B
Increasing
Stable
Total Assets193.5 B174.5 B132.9 B
Increasing
Slightly volatile
Current Assets139.7 B122.8 B92.1 B
Increasing
Slightly volatile
Assets Non Current55.5 B53.8 B41 B
Increasing
Slightly volatile
Cash and Equivalents133.6 B113.2 B71.6 B
Increasing
Slightly volatile
Cash and Equivalents USD110.4 B113.2 B69.6 B
Increasing
Slightly volatile
Total Debt89 B53.5 B26.4 B
Increasing
Slightly volatile
Debt Current10.7 B12.9 B4.9 B
Increasing
Slightly volatile
Debt Non Current36 B40.6 B18.1 B
Increasing
Slightly volatile
Total Debt USD46.7 B53.5 B22.9 B
Increasing
Slightly volatile
Deferred Revenue31.2 B33.9 B21.6 B
Increasing
Slightly volatile
Shareholders Equity80 B72 B63.8 B
Increasing
Slightly volatile
Shareholders Equity USD80 B72 B63.8 B
Increasing
Slightly volatile
Goodwill and Intangible Assets22.8 B21.6 B17.2 B
Increasing
Slightly volatile
Inventory2.7 B2.3 B1.7 B
Increasing
Slightly volatile
Investments11.8 B10.4 B10.4 B
Increasing
Slightly volatile
Investments Non Current11.8 B10.4 B10.4 B
Increasing
Slightly volatile
Total Liabilities113.6 B121.5 B69.2 B
Increasing
Slightly volatile
Current Liabilities59.4 B49.6 B38.7 B
Increasing
Slightly volatile
Liabilities Non Current56.2 B62.1 B30.6 B
Increasing
Slightly volatile
Trade and Non Trade Payables7.3 B7.2 B5.8 B
Increasing
Slightly volatile
Property Plant and Equipment Net17.4 B18.4 B11 B
Increasing
Slightly volatile
Trade and Non Trade Receivables19 B18.3 B15.2 B
Increasing
Slightly volatile
Accumulated Retained Earnings Deficit6 B2.3 B(592 M)
Increasing
Slightly volatile
Tax Assets2.3 B1.9 B2.1 B
Decreasing
Stable
Tax Liabilities2.1 B2.1 B2.1 B
Increasing
Stable

Income Statement

Current ValueLast YearHistorical Average 10 Year Trend
Consolidated Income15.3 B16.8 B17 B
Increasing
Stable
Cost of Revenue34.6 B32.8 B21.1 B
Increasing
Slightly volatile
Earning Before Interest and Taxes EBIT20.1 B19.8 B21.9 B
Increasing
Very volatile
Earning Before Interest and Taxes USD20.1 B19.8 B21.9 B
Increasing
Very volatile
Gross Profit55.7 B52.5 B51.3 B
Increasing
Slightly volatile
Net Income22.1 B16.8 B17.5 B
Increasing
Slightly volatile
Net Income Common Stock15.3 B16.8 B17 B
Increasing
Stable
Net Income Common Stock USD15.3 B16.8 B17 B
Increasing
Stable
Operating Expenses39.3 B32.4 B29.9 B
Increasing
Slightly volatile
Operating Income20.2 B20.2 B21.7 B
Increasing
Stable
Revenues92.6 B85.3 B72.6 B
Increasing
Slightly volatile
Revenues USD94.2 B85.3 B72.8 B
Increasing
Slightly volatile
Research and Development Expense12.6 B12 B10 B
Increasing
Slightly volatile
Selling General and Administrative Expense20.8 B19.3 B17.9 B
Increasing
Slightly volatile
Weighted Average Shares7.7 B7.9 B8.6 B
Decreasing
Slightly volatile
Weighted Average Shares Diluted8.6 B8 B8.8 B
Decreasing
Slightly volatile
Income Tax Expense4.9 B3 B5 B
Decreasing
Stable

Cash Flow Statement

Trends Matrix
Current ValueLast YearHistorical Average 10 Year Trend
Capital Expenditure(7.5 B)(8.3 B)(4.5 B)
Decreasing
Slightly volatile
Depreciation Amortization and Accretion6.6 B6.6 B4.1 B
Increasing
Slightly volatile
Net Cash Flow or Change in Cash and Cash Equivalents(1.1 B)915 M(60 M)
Decreasing
Very volatile
Net Cash Flow Business Acquisitions and Disposals(2.7 B)(1.4 B)(3.1 B)
Increasing
Very volatile
Issuance Purchase of Equity Shares(15.3 B)(15.3 B)(9.5 B)
Decreasing
Slightly volatile
Issuance Repayment of Debt Securities 16.8 B18.3 B8.7 B
Increasing
Slightly volatile
Payment of Dividends and Other Cash Distributions (11 B)(11 B)(7.1 B)
Decreasing
Slightly volatile
Net Cash Flow from Financing(9.5 B)(8.4 B)(9.2 B)
Increasing
Very volatile
Net Cash Flow from Investing(24.7 B)(23.9 B)(18.2 B)
Decreasing
Slightly volatile
Net Cash Flow Investment Acquisitions and Disposals(14.4 B)(14.4 B)(10.5 B)
Decreasing
Slightly volatile
Net Cash Flow from Operations40.4 B33.3 B27.9 B
Increasing
Slightly volatile
Effect of Exchange Rate Changes on Cash (73.7 M)(67 M)(35.3 M)
Decreasing
Slightly volatile
Share Based Compensation2.8 B2.7 B2.2 B
Increasing
Slightly volatile
Cash Beginning of Year7.5 B5.6 B6.9 B
Decreasing
Stable
Cash End of Year6.4 B6.5 B6.8 B
Decreasing
Stable

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Asset Turnover0.530.4690.6173
Decreasing
Slightly volatile
Book Value per Share10.05849.1797.6196
Increasing
Slightly volatile
Current Ratio3.122.3532.5298
Increasing
Very volatile
Debt to Equity Ratio99.21.6879.191
Increasing
Slightly volatile
Share Dilution Ratio1.06131.0081.0132
Increasing
Slightly volatile
Dividend Yield0.03180.0270.023
Increasing
Slightly volatile
Dividends per Basic Common Share1.36841.390.8515
Increasing
Slightly volatile
EBITDA Margin0.30.3090.3745
Decreasing
Slightly volatile
Earnings per Basic Share1.92.122.0
Increasing
Slightly volatile
Earnings per Diluted Share2.832.12.055
Increasing
Slightly volatile
EPS Diluted Growth(0.2696)(0.4274)(0.0218)
Decreasing
Slightly volatile
EPS Growth(0.2675)(0.424)(0.0196)
Decreasing
Slightly volatile
Earnings per Basic Share USD1.92.122.0
Increasing
Slightly volatile
Enterprise Value over EBIT16.842117.012.9035
Increasing
Very volatile
Enterprise Value over EBITDA13.162613.00811.0965
Decreasing
Stable
Free Cash Flow per Share17.323.1523.877
Increasing
Slightly volatile
Gross Margin0.66470.6160.7311
Decreasing
Slightly volatile
Financial Leverage1.17651.01.0147
Increasing
Slightly volatile
Leverage Ratio2.13112.17571.8936
Increasing
Slightly volatile
NCFO Growth0.0488(0.0535)0.0733
Decreasing
Stable
Net Income Growth(0.2854)(0.4482)(0.0445)
Decreasing
Slightly volatile
Profit Margin0.23890.1970.2492
Decreasing
Slightly volatile
Payout Ratio0.77260.6560.4275
Increasing
Slightly volatile
Price to Book Value7.255.5875.2643
Decreasing
Stable
Price to Earnings Ratio29.7524.13721.1667
Increasing
Very volatile
Price to Sales Ratio7.014.7535.105
Decreasing
Stable
Revenue Growth0.033(0.0575)0.0692
Decreasing
Slightly volatile
Return on Average Assets0.0640.0920.1522
Decreasing
Slightly volatile
Return on Average Equity0.27640.2230.301
Decreasing
Slightly volatile
Return on Invested Capital0.45320.3821.1465
Decreasing
Slightly volatile
Return on Sales0.22580.2310.3191
Decreasing
Slightly volatile
Weighted Average Share Growth(0.0231)(0.0321)(0.0208)
Decreasing
Very volatile
Sales per Share11.689510.7668.6592
Increasing
Slightly volatile
Tax Efficiency0.77110.70730.7517
Increasing
Stable
Tangible Assets Book Value per Share21.498921.9113.9907
Increasing
Slightly volatile
Total Assets Per Share24.61124.807116.2517
Increasing
Slightly volatile
Cash Flow Per Share4.15314.26813.3213
Increasing
Slightly volatile
Return on Investment17.204716.744434.7506
Decreasing
Slightly volatile
Operating Margin25.5223.654531.1509
Decreasing
Slightly volatile
Calculated Tax Rate25.825214.951123.1868
Decreasing
Slightly volatile
Receivables Turnover5.10544.70294.8598
Decreasing
Very volatile
Inventory Turnover12.948712.722712.8645
Increasing
Very volatile
PPandE Turnover6.25775.14328.2586
Decreasing
Slightly volatile
Cash and Equivalents Turnover14.304914.058111.2758
Increasing
Slightly volatile
Accounts Payable Turnover13.664412.615715.3607
Decreasing
Slightly volatile
Accrued Expenses Turnover18.602416.42619.5808
Decreasing
Slightly volatile
Interest Coverage66859.3588974
Decreasing
Slightly volatile
Long Term Debt to Equity0.48090.56650.2593
Increasing
Slightly volatile
Quick Ratio2.37422.21572.0742
Increasing
Slightly volatile
Net Current Assets as percentage of Total Assets44.176641.458737.2654
Increasing
Slightly volatile
Revenue to Assets0.51130.44050.6117
Decreasing
Slightly volatile

Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Average Assets187.4 B182.1 B125.5 B
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization EBITDA32.1 B26.4 B26.5 B
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization USD26.8 B26.4 B26 B
Increasing
Slightly volatile
Earnings before Tax20.1 B19.8 B21.9 B
Increasing
Very volatile
Average Equity86 B75.3 B63.6 B
Increasing
Slightly volatile
Enterprise Value591.7 B343.1 B284.8 B
Increasing
Slightly volatile
Free Cash Flow25.6 B25 B22.8 B
Increasing
Slightly volatile
Invested Capital49.2 B57.2 B29.9 B
Increasing
Slightly volatile
Invested Capital Average47.5 B51.7 B28.5 B
Increasing
Slightly volatile
Market Capitalization649.3 B402.2 B331.9 B
Increasing
Slightly volatile
Tangible Asset Value170.8 B171.9 B115.9 B
Increasing
Slightly volatile
Working Capital80.3 B73.2 B53.4 B
Increasing
Slightly volatile
Revenue Per Employee810.2 K746.4 K730 K
Increasing
Slightly volatile
Net Income Per Employee131.7 K146.9 K174.9 K
Decreasing
Slightly volatile