Microsoft Financial Statements Trends

MSFT -- USA Stock  

Trending

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 34.1 B, Consolidated Income of 32.8 B or Cost of Revenue of 37.7 B, but also many exotic indicators such as Interest Coverage of 238, Long Term Debt to Equity of 0.5263 or Calculated Tax Rate of 14.9691. 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 B286.6 B180 B
Increasing
Slightly volatile
Cash and Equivalents133.8 B133.8 B95.8 B
Increasing
Slightly volatile
Investments4.9 B2.6 B8.1 B
Decreasing
Slightly volatile
Investments Non Current4.9 B2.6 B8.1 B
Decreasing
Slightly volatile
Deferred Revenue33.8 B37.2 B26.2 B
Increasing
Slightly volatile
Property Plant and Equipment Net33.5 B43.9 B20.3 B
Increasing
Slightly volatile
Inventory2.2 B2.1 BB
Increasing
Slightly volatile
Tax Assets1.8 B1.7 BB
Decreasing
Slightly volatile
Trade and Non Trade Receivables26.4 B29.5 B20 B
Increasing
Slightly volatile
Trade and Non Trade Payables8.7 B9.4 BB
Increasing
Slightly volatile
Goodwill and Intangible Assets41.2 B49.8 B28.4 B
Increasing
Slightly volatile
Total Liabilities153.3 B184.2 B107.5 B
Increasing
Slightly volatile
Shareholders Equity96.1 B102.3 B77.5 B
Increasing
Slightly volatile
Accumulated Retained Earnings Deficit15.2 B24.1 B7.3 B
Increasing
Slightly volatile
Accumulated Other Comprehensive Income296.4 M(340 M)1.1 B
Decreasing
Slightly volatile
Current Assets139.7 B175.6 B121.4 B
Increasing
Slightly volatile
Assets Non Current91.1 B111 B62 B
Increasing
Slightly volatile
Current Liabilities59.4 B69.4 B47.6 B
Increasing
Slightly volatile
Liabilities Non Current90.9 B114.8 B59.7 B
Increasing
Slightly volatile
Tax Liabilities24.2 B35.5 B11.6 B
Increasing
Slightly volatile
Total Debt86.5 B78.4 B45 B
Increasing
Slightly volatile
Debt Current5.8 B5.5 BB
Increasing
Slightly volatile
Debt Non Current57.6 B72.8 B38 B
Increasing
Slightly volatile
Shareholders Equity USD96.1 B102.3 B77.5 B
Increasing
Slightly volatile
Cash and Equivalents USD120.8 B133.8 B94.6 B
Increasing
Slightly volatile
Total Debt USD63 B78.4 B42.9 B
Increasing
Slightly volatile
Accounts Payable7.6 B9.4 B6.5 B
Increasing
Slightly volatile
Receivables23.7 B29.5 B19.7 B
Increasing
Slightly volatile
Inventories1.9 B2.1 BB
Increasing
Slightly volatile

Microsoft Income Statement

Current ValueLast YearHistorical Average 10 Year Trend
Revenues125.8 B125.8 B91.8 B
Increasing
Slightly volatile
Cost of Revenue37.7 B42.9 B28.3 B
Increasing
Slightly volatile
Selling General and Administrative Expense23.5 B23.1 B20.2 B
Increasing
Slightly volatile
Research and Development Expense15.6 B16.9 B12.2 B
Increasing
Slightly volatile
Operating Expenses40 B40 B34.1 B
Increasing
Slightly volatile
Income Tax Expense6.2 B4.4 B6.6 B
Increasing
Stable
Consolidated Income32.8 B39.2 B22.3 B
Increasing
Slightly volatile
Net Income39.2 B16.6 B22.9 B
Increasing
Slightly volatile
Net Income Common Stock32.8 B39.2 B22.3 B
Increasing
Slightly volatile
Weighted Average Shares7.6 B7.7 B8.1 B
Decreasing
Slightly volatile
Weighted Average Shares Diluted7.6 B7.8 B8.2 B
Decreasing
Slightly volatile
Earning Before Interest and Taxes EBIT39 B43.7 B28.9 B
Increasing
Slightly volatile
Revenues USD116.1 B125.8 B90.9 B
Increasing
Slightly volatile
Net Income Common Stock USD32.8 B39.2 B22.3 B
Increasing
Slightly volatile
Earning Before Interest and Taxes USD39 B43.7 B28.9 B
Increasing
Slightly volatile
Gross Profit82.9 B82.9 B63 B
Increasing
Slightly volatile
Operating Income38.4 B43 B28.5 B
Increasing
Slightly volatile
Direct Expenses34.1 B42.9 B28 B
Increasing
Slightly volatile

Microsoft Cash Flow Statement

Trends Matrix
Current ValueLast YearHistorical Average 10 Year Trend
Capital Expenditure(9.9 B)(13.9 B)(6.9 B)
Decreasing
Slightly volatile
Net Cash Flow Business Acquisitions and Disposals(3.3 B)(2.4 B)(5.1 B)
Decreasing
Stable
Net Cash Flow Investment Acquisitions and Disposals(5.1 B)540 M(9 B)
Increasing
Slightly volatile
Net Cash Flow from Financing(24.6 B)(36.9 B)(13.3 B)
Decreasing
Slightly volatile
Issuance Repayment of Debt Securities B(4 B)B
Decreasing
Very volatile
Issuance Purchase of Equity Shares(13.9 B)(18.4 B)(10.4 B)
Decreasing
Slightly volatile
Payment of Dividends and Other Cash Distributions (11 B)(13.8 B)(9.3 B)
Decreasing
Slightly volatile
Net Cash Flow from Investing(16.9 B)(15.8 B)(20.9 B)
Decreasing
Very volatile
Net Cash Flow from Operations30.9 B52.2 B33.5 B
Increasing
Slightly volatile
Effect of Exchange Rate Changes on Cash (77.4 M)(115 M)(43.5 M)
Decreasing
Stable
Net Cash Flow or Change in Cash and Cash Equivalents(257 M)(590 M)121 M
Increasing
Stable
Share Based CompensationB4.7 B2.9 B
Increasing
Slightly volatile
Depreciation Amortization and Accretion9.5 B11.7 B6.4 B
Increasing
Slightly volatile

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Earnings per Basic Share4.18425.112.7695
Increasing
Slightly volatile
Earnings per Diluted Share5.062.132.8236
Increasing
Slightly volatile
Earnings per Basic Share USD4.18425.112.7695
Increasing
Slightly volatile
Dividends per Basic Common Share1.57371.81.1803
Increasing
Slightly volatile
Return on Average Equity0.00320.4180.2767
Decreasing
Slightly volatile
Return on Average Assets0.00160.1470.1282
Decreasing
Slightly volatile
Return on Invested Capital0.61970.4040.8301
Decreasing
Slightly volatile
Gross Margin0.64550.6590.695
Decreasing
Slightly volatile
Profit Margin0.00220.3120.2207
Decreasing
Slightly volatile
EBITDA Margin0.39480.440.3833
Increasing
Stable
Return on Sales0.31950.3470.3178
Decreasing
Stable
Asset Turnover0.49580.4720.5647
Decreasing
Slightly volatile
Payout Ratio0.43930.3520.4565
Increasing
Slightly volatile
Enterprise Value over EBITDA15.178917.5911.0594
Increasing
Slightly volatile
Enterprise Value over EBIT18.684222.013.3349
Increasing
Slightly volatile
Price to Earnings Ratio27.8826.21521.6785
Increasing
Slightly volatile
Sales per Share14.768916.40111.2932
Increasing
Slightly volatile
Price to Sales Ratio8.638.1685.0448
Increasing
Slightly volatile
Price to Book Value10.5410.0316.036
Increasing
Slightly volatile
Debt to Equity Ratio84.41.88.8612
Increasing
Slightly volatile
Dividend Yield0.01640.0130.0221
Decreasing
Slightly volatile
Current Ratio2.532.5292.541
Increasing
Slightly volatile
Free Cash Flow per Share17.534.9864.652
Increasing
Slightly volatile
Book Value per Share12.218913.3369.6177
Increasing
Slightly volatile
Tangible Assets Book Value per Share26.615330.85919.5866
Increasing
Slightly volatile
Total Assets Per Share29.196137.492623.0775
Increasing
Slightly volatile
Cash Flow Per Share5.39366.82784.3729
Increasing
Slightly volatile
Return on Investment29.650125.765127.9595
Decreasing
Slightly volatile
Operating Margin43.3634.13731.8557
Decreasing
Very volatile
Calculated Tax Rate14.969110.181322.1187
Decreasing
Very volatile
Receivables Turnover5.14424.4944.8311
Decreasing
Stable
Inventory Turnover15.654218.16314.5767
Increasing
Stable
PPandE Turnover5.84583.81716.5546
Decreasing
Slightly volatile
Cash and Equivalents Turnover10.705810.80111.8168
Increasing
Stable
Accounts Payable Turnover16.00713.983315.034
Decreasing
Slightly volatile
Accrued Expenses Turnover21.13219.460819.0173
Decreasing
Stable
Interest Coverage23877.68703
Decreasing
Slightly volatile
Long Term Debt to Equity0.52630.65140.4439
Increasing
Slightly volatile
Quick Ratio2.22792.3532.3366
Increasing
Stable
Net Current Assets as percentage of Total Assets36.682737.037140.4423
Decreasing
Stable
Revenue to Assets0.53430.43920.5247
Decreasing
Slightly volatile

Microsoft Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Earnings before Tax39 B43.7 B28.9 B
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization EBITDA54.6 B55.4 B35.9 B
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization USD48.5 B55.4 B35.3 B
Increasing
Slightly volatile
Market Capitalization1090 B1026.5 B498.8 B
Increasing
Slightly volatile
Enterprise Value1010 B974 B445.9 B
Increasing
Slightly volatile
Invested Capital88.1 B111.9 B57 B
Increasing
Slightly volatile
Average Equity89.9 B93.8 B74.2 B
Increasing
Slightly volatile
Average Assets232.8 B266.6 B173.3 B
Increasing
Slightly volatile
Invested Capital Average83.8 B108.1 B53.1 B
Increasing
Slightly volatile
Tangible Asset Value208.2 B236.8 B156.7 B
Increasing
Slightly volatile
Free Cash Flow35.6 B38.3 B28 B
Increasing
Slightly volatile
Working Capital80.3 B106.1 B73.8 B
Increasing
Slightly volatile
Revenue Per Employee796.6 K873.9 K799.4 K
Increasing
Slightly volatile
Net Income Per Employee253.7 K272.5 K196.3 K
Increasing
Very volatile

Microsoft Fundamental Market Drivers

Short Percent Of Float0.83%
Forward Price Earnings24.98
Shares Short Prior Month57.15M
Average Daily Volume Last 10 Day19.22M
Average Daily Volume In Three Month22.41M
Date Short InterestNovember 15, 2019
Fifty Day Average146.47
Two Hundred Day Average138.47

Microsoft Upcoming Events

Upcoming Quarterly Earning ReportJanuary 29, 2020
Next Earnings ReportApril 22, 2020
Next Fiscal Quarter EndDecember 31, 2019
Next Fiscal Year EndJuly 16, 2020
Last Quarter Report DateSeptember 30, 2019
Last Earning Anouncement DateDecember 31, 2018
Search macroaxis.com