Microsoft Financial Statements Trends

MSFT -- USA Stock  

Quarterly Earning Report: October 23, 2019  

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 Direct Expenses of 33.5 B, Consolidated Income of 7.6 B or Cost of Revenue of 7.7 B, but also many exotic indicators such as Interest Coverage of 238, Long Term Debt to Equity of 0.5132 or Calculated Tax Rate of 15.1165. 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.
Revenues

Microsoft Balance Sheet

Current ValueLast YearHistorical Average 10 Year Trend
Total Assets193.5 B4.4 B43.2 B
Decreasing
Stable
Cash and Equivalents133.8 B2.6 B24.2 B
Increasing
Very volatile
Investments4.2 B607.5 M1.1 B
Increasing
Stable
Investments Non Current4.2 B607.5 M1.1 B
Increasing
Stable
Deferred Revenue8.4 B62.1 M3.8 B
Decreasing
Slightly volatile
Property Plant and Equipment Net5.5 B997 M4.8 B
Decreasing
Slightly volatile
Inventory814.3 M146.1 M347.2 M
Decreasing
Stable
Tax Assets1.9 B1.3 B1.5 B
Decreasing
Very volatile
Trade and Non Trade Receivables6.2 B388.7 M3.3 B
Decreasing
Slightly volatile
Trade and Non Trade Payables2.4 B274.9 M1.2 B
Decreasing
Slightly volatile
Goodwill and Intangible Assets11 B2.2 B6.7 B
Decreasing
Slightly volatile
Total Liabilities28 B647.5 M18.2 B
Decreasing
Slightly volatile
Shareholders Equity30.2 B3.7 B13.8 B
Decreasing
Slightly volatile
Accumulated Retained Earnings Deficit3.3 B2.5 B4.1 B
Decreasing
Slightly volatile
Accumulated Other Comprehensive Income1.1 B1.3 B800.1 M
Increasing
Slightly volatile
Current Assets139.7 B3.3 B28.7 B
Decreasing
Very volatile
Assets Non Current19 B1.1 B11.6 B
Decreasing
Slightly volatile
Current Liabilities59.4 B647.5 M11.2 B
Decreasing
Very volatile
Liabilities Non Current16 B609.5 M11.3 B
Decreasing
Slightly volatile
Tax Liabilities2.9 B146.1 M3.3 B
Decreasing
Slightly volatile
Total Debt86.5 B6.6 B18.6 B
Increasing
Very volatile
Debt Current4.1 B2.3 B2.5 B
Decreasing
Stable
Debt Non Current21.5 B4.3 B11 B
Decreasing
Slightly volatile
Shareholders Equity USD30.2 B3.7 B13.8 B
Decreasing
Slightly volatile
Cash and Equivalents USD30.1 B2.6 B15.6 B
Decreasing
Slightly volatile
Total Debt USD25.3 B6.6 B13.5 B
Decreasing
Slightly volatile
Accounts Payable7.5 B9.4 B6.2 B
Increasing
Slightly volatile
Receivables23.3 B29.5 B18.9 B
Increasing
Slightly volatile
Inventories1.9 B2.1 B1.9 B
Increasing
Slightly volatile

Microsoft Income Statement

Current ValueLast YearHistorical Average 10 Year Trend
Revenues125.8 B3.2 B23.3 B
Increasing
Very volatile
Cost of Revenue7.7 B537 M4.6 B
Decreasing
Slightly volatile
Selling General and Administrative Expense7.6 B1.1 B3.4 B
Decreasing
Slightly volatile
Research and Development Expense4.2 B404.8 M2.1 B
Decreasing
Slightly volatile
Operating Expenses12.2 B1.5 B5.4 B
Decreasing
Slightly volatile
Income Tax Expense2.8 B382.9 M885.6 M
Decreasing
Stable
Consolidated Income7.6 B814.2 M4.5 B
Decreasing
Slightly volatile
Net Income39.2 B814.2 M7.1 B
Increasing
Very volatile
Net Income Common Stock7.6 B814.2 M4.5 B
Decreasing
Slightly volatile
Weighted Average Shares7.6 B8.5 BB
Decreasing
Stable
Weighted Average Shares Diluted8.5 B8.5 B9.1 B
Decreasing
Very volatile
Earning Before Interest and Taxes EBIT10.4 B1.2 B5.4 B
Decreasing
Slightly volatile
Revenues USD29.8 B3.2 B15.3 B
Decreasing
Slightly volatile
Net Income Common Stock USD7.6 B814.2 M4.5 B
Decreasing
Slightly volatile
Earning Before Interest and Taxes USD10.4 B1.2 B5.4 B
Decreasing
Slightly volatile
Gross Profit82.9 B2.6 B15.8 B
Increasing
Very volatile
Operating Income9.9 B1.1 B5.2 B
Decreasing
Slightly volatile
Direct Expenses33.5 B42.9 B26.6 B
Increasing
Slightly volatile

Microsoft Cash Flow Statement

Trends Matrix
Current ValueLast YearHistorical Average 10 Year Trend
Capital Expenditure(1.4 B)(285.3 M)(1.5 B)
Increasing
Slightly volatile
Net Cash Flow Business Acquisitions and Disposals(1.6 B)(171 M)(488.9 M)
Increasing
Stable
Net Cash Flow Investment Acquisitions and Disposals(1.9 B)(255.6 M)(349.9 M)
Decreasing
Slightly volatile
Net Cash Flow from Financing(3.8 B)117 M(3.3 B)
Increasing
Slightly volatile
Issuance Repayment of Debt Securities 7.6 B6.6 B5.2 B
Increasing
Slightly volatile
Issuance Purchase of Equity Shares(2.9 B)(18.9 M)(1.8 B)
Increasing
Slightly volatile
Payment of Dividends and Other Cash Distributions (4 B)(771.3 M)(2.2 B)
Increasing
Slightly volatile
Net Cash Flow from Investing(4.3 B)(577.8 M)(2.2 B)
Increasing
Slightly volatile
Net Cash Flow from Operations30.9 BB7.7 B
Decreasing
Stable
Effect of Exchange Rate Changes on Cash (7.6 M)(9 M)(18.5 M)
Increasing
Slightly volatile
Net Cash Flow or Change in Cash and Cash Equivalents474.4 M441.6 M315.2 M
Increasing
Slightly volatile
Share Based CompensationB1.4 B1.8 B
Decreasing
Slightly volatile
Depreciation Amortization and Accretion1.7 B128.8 M1.2 B
Decreasing
Slightly volatile

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Earnings per Basic Share0.87040.08620.5618
Decreasing
Slightly volatile
Earnings per Diluted Share5.060.08620.9068
Increasing
Very volatile
Earnings per Basic Share USD0.87040.08620.5618
Decreasing
Slightly volatile
Dividends per Basic Common Share0.61550.0920.269
Decreasing
Stable
Return on Average Equity0.00350.34270.2872
Decreasing
Slightly volatile
Return on Average Assets0.00190.2250.2187
Decreasing
Stable
Return on Invested Capital1.60151.73341.7561
Increasing
Slightly volatile
Gross Margin0.7240.74790.8008
Decreasing
Very volatile
Profit Margin0.00230.23130.2382
Decreasing
Slightly volatile
EBITDA Margin0.37850.37620.4131
Decreasing
Slightly volatile
Return on Sales0.33790.33930.3681
Decreasing
Slightly volatile
Asset Turnover0.75220.91260.9386
Increasing
Stable
Payout Ratio0.27360.10260.1462
Decreasing
Stable
Enterprise Value over EBITDA13.212.2213.7647
Decreasing
Slightly volatile
Enterprise Value over EBIT14.813.515.4417
Decreasing
Slightly volatile
Price to Earnings Ratio27.8826.2528.5707
Decreasing
Very volatile
Sales per Share3.42470.3371.9
Decreasing
Slightly volatile
Price to Sales Ratio8.636.717.5533
Decreasing
Very volatile
Price to Book Value10.546.017.2266
Decreasing
Very volatile
Debt to Equity Ratio84.40.20017.3305
Increasing
Slightly volatile
Dividend Yield0.01220.00270.0046
Decreasing
Very volatile
Current Ratio2.534.564.5981
Decreasing
Very volatile
Free Cash Flow per Share17.530.07131.9288
Increasing
Slightly volatile
Book Value per Share3.38460.38071.676
Decreasing
Slightly volatile
Tangible Assets Book Value per Share5.92490.44743.4004
Decreasing
Slightly volatile
Total Assets Per Share28.669837.492621.8391
Increasing
Slightly volatile
Cash Flow Per Share5.30946.82784.1795
Increasing
Slightly volatile
Return on Investment30.813225.765129.8861
Decreasing
Slightly volatile
Operating Margin43.3634.13732.1049
Decreasing
Very volatile
Calculated Tax Rate15.116510.181322.4959
Decreasing
Very volatile
Receivables Turnover5.13894.4944.8211
Decreasing
Stable
Inventory Turnover15.643718.16314.5514
Increasing
Stable
PPandE Turnover5.94063.81716.7232
Decreasing
Slightly volatile
Cash and Equivalents Turnover10.521610.80111.41
Increasing
Slightly volatile
Accounts Payable Turnover16.054413.983315.1088
Decreasing
Slightly volatile
Accrued Expenses Turnover21.147819.460819.0331
Decreasing
Stable
Interest Coverage23877.68745
Decreasing
Slightly volatile
Long Term Debt to Equity0.51320.65140.4137
Increasing
Slightly volatile
Quick Ratio2.19742.3532.2708
Increasing
Slightly volatile
Net Current Assets as percentage of Total Assets36.20937.037139.4128
Increasing
Stable
Revenue to Assets0.54630.43920.5445
Decreasing
Slightly volatile

Microsoft Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Earnings before Tax10.4 B1.2 B5.4 B
Decreasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization EBITDA54.6 B1.3 B10.1 B
Decreasing
Very volatile
Earnings Before Interest Taxes and Depreciation Amortization USD12.1 B1.3 B6.6 B
Decreasing
Slightly volatile
Market Capitalization1090 B34.2 B201.5 B
Increasing
Very volatile
Enterprise Value1010 B30.6 B187.8 B
Increasing
Very volatile
Invested Capital15.4 B1.1 B11.4 B
Decreasing
Slightly volatile
Average Equity30.5 B4.4 B13.6 B
Decreasing
Slightly volatile
Average Assets57.3 B5.3 B30.9 B
Decreasing
Slightly volatile
Invested Capital Average14.8 BB11 B
Decreasing
Slightly volatile
Tangible Asset Value51.2 B4.4 B27.2 B
Decreasing
Slightly volatile
Free Cash Flow9.7 B665.9 M4.5 B
Decreasing
Slightly volatile
Working Capital80.3 B2.6 B17.5 B
Decreasing
Very volatile
Revenue Per Employee790.1 K873.9 K784.6 K
Increasing
Slightly volatile
Net Income Per Employee251.9 K272.5 K192.8 K
Increasing
Stable

Microsoft Fundamental Market Drivers

Short Percent Of Float0.65%
Forward Price Earnings23.38
Shares Short Prior Month49.7M
Average Daily Volume Last 10 Day22.11M
Average Daily Volume In Three Month24.53M
Date Short InterestAugust 15, 2019
Fifty Day Average137.49
Two Hundred Day Average131.97

Microsoft Upcoming Events

Upcoming Quarterly Earning ReportOctober 23, 2019
Next Earnings ReportJanuary 29, 2020
Next Fiscal Quarter EndSeptember 30, 2019
Next Fiscal Year EndJuly 16, 2020
Last Quarter Report DateJune 30, 2019
Last Earning Anouncement DateSeptember 30, 2018
Search macroaxis.com