Use the Income Statement for the 12 months ending 6/30/2019 and the Balance Sheet as of 6/30/2019 [shown in green].
For each ratio, show the numerator, denominator, and the ratio. For the ratio, use two digits to the right of the decimal.
For example, for the "Cash Ratio", Total Cash = $133,819. Current Liabilities = $69,420. Cash Ratio = 1.92 Times.
5.
I. Liquidity Ratios |
1. Current Ratio |
2. Quick Ratio |
3. Cash Ratio |
II. Financial Risk |
4. Liabilities/Equity Ratio |
5. Equity Multiplier |
6. Debt/Assets Ratio |
|
III. Activity Ratios |
7. Inventory Turnover Ratio |
8. Inventory Days Sales Outstanding (DSO) |
9. Accounts Receivable Turns |
10, Days Sales in Receivables |
11. Total Asset Turnover Ratio |
|
IV. Profitability |
|
12, Profit Margin |
13. Return on Assets |
14, Return on Equity |
|
V. Market Value Ratios |
15. Price Earnings Ratio |
16. Price/Book Ratio |
Microsoft Corporation INCOME STATEMENTS - USD ($) shares in Millions, $ in Millions Revenue Cost of revenue Gross margin Research and development Sales and marketing General and administrative Restructuring Operating income Other income, net Income before income taxes Provision for income taxes Net income Earnings per share: Basic Diluted Weighted average shares outstanding: Basic Diluted Jun. 30, 2019 $ 125,843 42,910 82,933 16,876 18,213 4,885 0 42,959 729 43,688 4,448 $ 39,240 [1] 12 Months Ended Jun. 30, 2018 $ 110,360 38,353 72,007 14,726 17,469 4,754 0 35,058 1,416 36,474 19,903 $ 16,571 [2] Jun. 30, 2017 $ 96,571 34,261 62,310 13,037 15,461 4,481 306 29,025 876 29,901 4,412 $ 25,489 $ 5.11 $ 5.06 [3] $ 2.15 $ 2.13 [4] $ 3.29 $ 3.25 7,673 7,753 7,700 7,794 7,746 7,832 Jun. 30, 2019 Jun. 30, 2018 $ 11,356 122,463 133,819 29,524 $ 11,946 121,822 133,768 26,481 2.063 10,146 175,552 36,477 2,662 6,751 169,662 29,460 BALANCE SHEETS - USD ($) $ in Millions Current assets: Cash and cash equivalents Short-term investments Total cash, cash equivalents, and short-term investments Accounts receivable, net of allowance for doubtful accounts of $411 and $377 Inventories Other Total current assets Property and equipment, net of accumulated depreciation of $35,330 and $29,223 Operating lease right-of-use assets Equity investments Goodwill Intangible assets, net Other long-term assets Total assets Current liabilities: Accounts payable Current portion of long-term debt Accrued compensation Short-term income taxes Short-term unearned revenue Other Total current liabilities Long-term debt 7,379 2,649 42,026 7,750 14,723 286,556 6,686 1,862 35,683 8,053 7,442 258,848 9,382 5,516 6,830 5,665 32,676 9,351 69,420 66,662 8,617 3,998 6,103 2,121 28,905 8,744 58,488 72,242 29,612 4,530 233 6,188 7,581 184,226 30,265 3,815 541 5,568 5,211 176,130 Long-term income taxes Long-term unearned revenue Deferred income taxes Operating lease liabilities Other long-term liabilities Total liabilities Commitments and contingencies Stockholders' equity: Common stock and paid-in capital shares authorized 24,000; outstanding 7,643 and 7,677 Retained earnings Accumulated other comprehensive loss Total stockholders' equity Total liabilities and stockholders' equity 78,520 71,223 24,150 (340) 102,330 $ 286,556 13,682 (2,187) 82,718 $ 258,848 Stock price on June 30, 2019 $ 135.68