Please refer to the financial statements for Microsoft. It is an Excel spreadsheet next to this test. Calculate the following ratios for the periods ending June 30, 2019 [only]. 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. 1. 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 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 1 2 INCOME STATEMENTS - USD ($) shares in Millions, $ in Millions 3 4 Revenue s Cost of revenue 6 Gross margin 7 Research and development 8 Sales and marketing 9 General and administrative 10 Restructuring 11 Operating income 12 Other income, net 13 Income before income taxes 14 Provision for income taxes 15 Net Income 16 Earnings per share: 17 Basic 18 Diluted 19 Weighted average shares outstanding: 20 Basic 21 Diluted 22 23 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 $ 5.11 $5.06 (3) $ 2.15 $ 2.13 7,673 7,753 7,700 7,794 24 B D Jun 30, 2019 Jun 30, 2018 $ 11,356 122,463 133,819 29,524 $ 11,946 121,822 133,768 26,481 25 BALANCE SHEETS - USD ($) $ in Millions 26 Current assets: 27 Cash and cash equivalents 28 Short-term investments 29 Total cash, cash equivalents, and short-term investments Accounts receivable, net of allowance for doubtful accounts of $411 and 30 $377 31 Inventories 32 Other 33 Total current assets Property and equipment, net of accumulated depreciation of $35,330 34 and $29,223 35 Operating lease right-of-use assets 36 Equity investments 37 Goodwill 38 Intangible assets, net 39 Other long-term assets 40 Total assets 2,063 10,146 175,552 36,477 2,662 6,751 169,662 29,460 7,379 2,649 42,026 7,750 14,723 286,556 6,686 1,862 35,683 8,053 7,442 258,848 D B Current liabilities: Accounts payable 3 Current portion of long-term debt Accrued compensation s Short-term income taxes 6 Short-term unearned revenue 7 Other 8 Total current liabilities -9 Long-term debt o Long-term income taxes 51 Long-term unearned revenue 52 Deferred income taxes 53 Operating lease liabilities 54 Other long-term liabilities 55 Total liabilities 56 Commitments and contingencies 57 Stockholders' equity: Common stock and paid-in capital - shares authorized 24,000; 58 Outstanding 7,643 and 7,677 59 Retained earnings 60 Accumulated other comprehensive loss 61 Total stockholders' equity 62 Total liabilities and stockholders' equity 9,382 5,516 6,830 5,665 32,676 9,351 69,420 66,662 29,612 4,530 233 6,188 7,581 184,226 8,617 3,998 6,103 2,121 28,905 8,744 58,488 72,242 30,265 3,815 541 5,568 5,211 176,130 78,520 71,223 24,150 (340) 102,330 $ 286,556 13,682 (2,187) 82,718 $ 258,848 63 $ $ 135.68 64 Stock price on June 30, 2019 65
