Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please show work, thank you Calculate the following ratios for the period ending June 30, 2019 [only] Use the Income Statement for the 12 months
please show work, thank you
Calculate the following ratios for the period 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. 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.93 Times, 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 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 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 2 INCOME STATEMENTS - USD ($) shares in Millions, $ in 3 Millions 4 Revenue 5 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 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) $ 5.11 $ 5.06 (3) 7,673 7,753 22 23 MSFT.Ratios Ready B Jun 30, 2019 $ 11,356 122,463 133,819 29,524 2,063 10,146 175,552 36,477 24 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 30 $411 and $377 31 Inventories 32 Other 33 Total current assets Property and equipment, net of accumulated depreciation of 34 $35,330 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 41 Current liabilities: 42 Accounts payable 43 Current portion of long-term debt 44 Accrued compensation 45 Short-term income taxes 46 Short-term unearned revenue 47 Other 48 Total current liabilities 49 Long-term debt 50 Long-term income taxes 7,379 2,649 42,026 7,750 14,723 286,556 + 9,382 5,516 6,830 5,665 32,676 9,351 69,420 66,662 29,612 MSFT.Ratios 9 TOOS Read 14,723 286,556 40 Total assets 41 Current liabilities: 42 Accounts payable 43 Current portion of long-term debt 44 Accrued compensation 45 Short-term income taxes 46 Short-term unearned revenue 47 Other 48 Total current liabilities 49 Long-term debt 50 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 78,520 24,150 (340) 102,330 $ 286,556 63 64 Stock price $ 135.68 MSFT.RatiosStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started