Microsoft Financial Statements Trends

MSFT -- USA Stock  

USD 141.07  3.26  2.37%

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 28.4 B, Consolidated Income of 7 B or Cost of Revenue of 7.1 B, but also many exotic indicators such as Interest Coverage of 238, Long Term Debt to Equity of 0.5737 or Calculated Tax Rate of 36.1526. 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 B40.9 B
Decreasing
Very volatile
Cash and Equivalents133.8 B2.6 B24.2 B
Increasing
Very volatile
Investments4.4 B607.5 M1.1 B
Increasing
Stable
Investments Non Current4.4 B607.5 M1.1 B
Increasing
Stable
Deferred Revenue7.9 B62.1 M3.4 B
Decreasing
Slightly volatile
Property Plant and Equipment Net4.8 B997 M4.1 B
Decreasing
Slightly volatile
Inventory791.5 M146.1 M395.2 M
Decreasing
Slightly volatile
Tax Assets1.9 B1.3 B1.5 B
Decreasing
Very volatile
Trade and Non Trade Receivables5.7 B388.7 M3 B
Decreasing
Slightly volatile
Trade and Non Trade Payables2.3 B274.9 M1.1 B
Decreasing
Slightly volatile
Goodwill and Intangible Assets10 B2.2 B6.1 B
Decreasing
Slightly volatile
Total Liabilities25 B647.5 M17.2 B
Decreasing
Slightly volatile
Shareholders Equity29 B3.7 B12 B
Decreasing
Stable
Accumulated Retained Earnings Deficit2.1 B1.9 B3.1 B
Decreasing
Slightly volatile
Accumulated Other Comprehensive Income1.2 B1.3 B191.8 M
Increasing
Slightly volatile
Current Assets139.7 B3.3 B28.2 B
Decreasing
Very volatile
Assets Non Current17.2 B1.1 B9.7 B
Decreasing
Slightly volatile
Current Liabilities59.4 B647.5 M10.3 B
Increasing
Very volatile
Liabilities Non Current13.7 B609.5 M11.4 B
Decreasing
Slightly volatile
Tax Liabilities2.2 B146.1 M3 B
Decreasing
Slightly volatile
Total Debt86.5 B6.6 B18.9 B
Increasing
Very volatile
Debt Current4 B2.3 B2.4 B
Increasing
Very volatile
Debt Non Current19.2 B4.3 B11.3 B
Decreasing
Slightly volatile
Shareholders Equity USD29 B3.7 B12 B
Decreasing
Stable
Cash and Equivalents USD28.2 B2.6 B15.4 B
Decreasing
Slightly volatile
Total Debt USD22.9 B6.6 B13.6 B
Decreasing
Slightly volatile
Accounts Payable6.5 B7.8 B6 B
Increasing
Slightly volatile
Receivables19.9 B23.8 B18.2 B
Increasing
Slightly volatile
Inventories2 B2.4 B1.9 B
Increasing
Slightly volatile

Microsoft Income Statement

Current ValueLast YearHistorical Average 10 Year Trend
Revenues125.8 B3.2 B22 B
Increasing
Very volatile
Cost of Revenue7.1 B537 M4.2 B
Decreasing
Slightly volatile
Selling General and Administrative Expense7.3 B1.1 B3.3 B
Decreasing
Slightly volatile
Research and Development Expense4 B404.8 M1.9 B
Decreasing
Slightly volatile
Operating Expenses11.7 B1.5 B5.2 B
Decreasing
Slightly volatile
Income Tax Expense2.8 B382.9 M2.2 B
Decreasing
Slightly volatile
Consolidated Income7 B814.2 M2.6 B
Decreasing
Stable
Net Income39.2 B814.2 M5.2 B
Increasing
Stable
Net Income Common Stock7 B814.2 M2.6 B
Decreasing
Stable
Weighted Average Shares7.6 B8.5 B9 B
Decreasing
Stable
Weighted Average Shares Diluted8.5 B8.5 B9.1 B
Decreasing
Very volatile
Earning Before Interest and Taxes EBIT9.8 B1.2 B4.7 B
Decreasing
Slightly volatile
Revenues USD28.1 B3.2 B13.9 B
Decreasing
Slightly volatile
Net Income Common Stock USD7 B814.2 M2.6 B
Decreasing
Stable
Earning Before Interest and Taxes USD9.8 B1.2 B4.7 B
Decreasing
Slightly volatile
Gross Profit82.9 B2.6 B14.9 B
Increasing
Very volatile
Operating Income9.4 B1.1 B4.5 B
Decreasing
Slightly volatile
Direct Expenses28.4 B34.5 B25.5 B
Increasing
Slightly volatile

Microsoft Cash Flow Statement

Trends Matrix
Current ValueLast YearHistorical Average 10 Year Trend
Capital Expenditure(1.2 B)(285.3 M)(1.3 B)
Increasing
Slightly volatile
Net Cash Flow Business Acquisitions and Disposals(1.6 B)(171 M)(366.4 M)
Decreasing
Stable
Net Cash Flow Investment Acquisitions and Disposals(2 B)(255.6 M)145.3 M
Decreasing
Slightly volatile
Net Cash Flow from Financing(3.4 B)117 M(3 B)
Increasing
Slightly volatile
Issuance Repayment of Debt Securities 8.3 B6.6 B4.7 B
Increasing
Slightly volatile
Issuance Purchase of Equity Shares(2.7 B)(18.9 M)(1.1 B)
Increasing
Slightly volatile
Payment of Dividends and Other Cash Distributions (3.9 B)(771.3 M)(2.1 B)
Increasing
Slightly volatile
Net Cash Flow from Investing(4.2 B)(577.8 M)(1.4 B)
Increasing
Stable
Net Cash Flow from Operations30.9 B1 B7 B
Decreasing
Very volatile
Effect of Exchange Rate Changes on Cash (5.9 M)(9 M)(4.6 M)
Decreasing
Slightly volatile
Net Cash Flow or Change in Cash and Cash Equivalents496 M441.6 M723 M
Decreasing
Slightly volatile
Share Based Compensation2 B1.4 B1.8 B
Decreasing
Slightly volatile
Depreciation Amortization and Accretion1.5 B128.8 M1.1 B
Decreasing
Slightly volatile

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Earnings per Basic Share0.79140.08620.3086
Decreasing
Stable
Earnings per Diluted Share5.060.08620.6626
Increasing
Stable
Earnings per Basic Share USD0.79140.08620.3086
Decreasing
Stable
Dividends per Basic Common Share0.58570.0920.254
Decreasing
Stable
Return on Average Equity0.42410.34270.3041
Increasing
Slightly volatile
Return on Average Assets0.09850.2250.22
Increasing
Very volatile
Return on Invested Capital1.62221.73341.753
Increasing
Slightly volatile
Gross Margin0.72590.74790.8004
Increasing
Very volatile
Profit Margin0.31180.23130.2505
Increasing
Slightly volatile
EBITDA Margin0.37840.37620.4116
Decreasing
Slightly volatile
Return on Sales0.33840.33930.3668
Decreasing
Stable
Asset Turnover0.75510.91260.9359
Increasing
Stable
Payout Ratio0.27810.10260.1811
Decreasing
Slightly volatile
Enterprise Value over EBITDA13.173712.2213.5596
Decreasing
Slightly volatile
Enterprise Value over EBIT14.736813.515.1864
Decreasing
Slightly volatile
Price to Earnings Ratio27.8826.2530.2082
Decreasing
Slightly volatile
Sales per Share3.19310.3371.7083
Decreasing
Slightly volatile
Price to Sales Ratio8.636.717.4459
Increasing
Slightly volatile
Price to Book Value10.546.017.1539
Increasing
Very volatile
Debt to Equity Ratio84.40.20017.3579
Increasing
Slightly volatile
Dividend Yield0.01260.00270.0049
Decreasing
Stable
Current Ratio2.534.564.6291
Decreasing
Very volatile
Free Cash Flow per Share17.530.07131.8624
Increasing
Slightly volatile
Book Value per Share3.21090.38071.4449
Decreasing
Slightly volatile
Tangible Assets Book Value per Share5.45120.44743.1168
Decreasing
Slightly volatile
Total Assets Per Share24.221130.3520.8732
Increasing
Slightly volatile
Cash Flow Per Share4.30535.143.9552
Increasing
Slightly volatile
Return on Investment30.852625.3929.8581
Decreasing
Slightly volatile
Operating Margin43.3636.5332.3043
Decreasing
Very volatile
Calculated Tax Rate36.152649.1127.493
Increasing
Slightly volatile
Receivables Turnover5.67895.494.9491
Increasing
Slightly volatile
Inventory Turnover17.736818.2114.7297
Increasing
Slightly volatile
PPandE Turnover6.61584.776.8589
Decreasing
Slightly volatile
Cash and Equivalents Turnover10.210.1311.3273
Increasing
Stable
Accounts Payable Turnover17.105315.8615.3527
Decreasing
Slightly volatile
Accrued Expenses Turnover22.078921.2919.2631
Increasing
Very volatile
Interest Coverage23877.68745
Decreasing
Slightly volatile
Long Term Debt to Equity0.57370.7860.4299
Increasing
Slightly volatile
Quick Ratio2.25362.46592.2849
Increasing
Slightly volatile
Net Current Assets as percentage of Total Assets37.173738.6539.6276
Increasing
Stable
Revenue to Assets0.57930.49030.5515
Decreasing
Slightly volatile

Microsoft Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Earnings before Tax9.8 B1.2 B4.7 B
Decreasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization EBITDA54.6 B1.3 B9.4 B
Increasing
Very volatile
Earnings Before Interest Taxes and Depreciation Amortization USD11.4 B1.3 B5.8 B
Decreasing
Slightly volatile
Market Capitalization1090 B34.2 B179.1 B
Increasing
Stable
Enterprise Value1010 B30.6 B165.7 B
Increasing
Stable
Invested Capital13.5 B1.1 B10.7 B
Decreasing
Slightly volatile
Average Equity29.4 B4.4 B12.6 B
Decreasing
Stable
Average Assets53.4 B5.3 B29.4 B
Decreasing
Slightly volatile
Invested Capital Average12.8 B1 B10.6 B
Decreasing
Slightly volatile
Tangible Asset Value47.8 B4.4 B25.1 B
Decreasing
Slightly volatile
Free Cash Flow9.2 B665.9 M3.9 B
Decreasing
Slightly volatile
Working Capital80.3 B2.6 B17.9 B
Decreasing
Very volatile
Revenue Per Employee862.3 K1 M802.6 K
Increasing
Slightly volatile
Net Income Per Employee206.4 K195.4 K182.6 K
Decreasing
Stable

Microsoft Fundamental Market Drivers

Short Percent Of Float0.65%
Forward Price Earnings23.75
Shares Short Prior Month49.7M
Average Daily Volume Last 10 Day23.54M
Average Daily Volume In Three Month24.36M
Date Short InterestAugust 15, 2019
Fifty Day Average136.75
Two Hundred Day Average129.44

Microsoft Upcoming Events

Upcoming Quarterly Earning ReportJuly 18, 2019
Next Earnings ReportOctober 23, 2019
Next Fiscal Quarter EndJune 30, 2019
Next Fiscal Year EndJuly 18, 2019
Last Quarter Report DateMarch 31, 2019
Last Earning Anouncement DateJune 30, 2018
Search macroaxis.com