1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 A B Problem 17-4B Name: Section: Score: 0% Key Code: [Key code here] Instructions 1. Working capital: 2. C Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. An asterisk (") will appear to the right of an incorrect entry. 3. Quick ratio Ratio 4. Accounts receivable turnover 6. Current ratio 5. Number of days 8. sales in receivables Inventory turnover 7. Number of days' sales in inventory 9. Ratio of Fixed assets to long-term liabilities Ratio of liabilities to stockholders' equity 10. Times interest earned 11. Asset turnover 12. Return on total assets 13. Return on stockholders' equity 14. Return on common stockholders' equity 15. Earnings per share on common stock 16. Price-earnings ratio 17. Dividends per share of common stock D 18. Dividend yield E Current Assets Numerator Pr. 17-4B 5 8+ @ F G Current Liabilities Denominator H I Calculated Value = Calculated Value d K : L + M

PR 17-4B Measures of liquidity, solvency and profitability OBJ. 3,4,5 9. Ratio of liabilities to stockholders equity, 0.4 The comparative financial statements of Stargel Inc. are as follows. The market price of Stargel common stock was $119.70 on December 31, 20Y2. Excel Stareel lac. Stargelise. Comparative linceme stutement For the Yean Ended December 31, 20rzand 20Y, Stargetinc. Comparative Balance Sheet December 31, zora and 20Y. Assets Current assets: Cash Marketable recurities Accounts receivable inet) Irventoties Prepaid experies Total current assets Long-term investments Property, plant and equipment (net) Total assets Liabilities 20%2 20r1 Current labilities. 3. 900000800000 Long-term liabilites: Mortgage note payable, 10w Bonds payable, 10% Total Iong term liablaties Total fubilities Steckhelders' Equity Preferred 50.90 stock, 510 par Common stock, 55 par Retained earnings Total steckholder' equity Total liabilities and itockholden' equity Instructions Determine the following aseasures for 20Y2, rounding to one decimal place including percentages, except for per-share amosents 1. Working capital 2. Current ratio 3. Quick ratio 1. Accounts receivable turnower 5. Number of days' sales in receivables (Confinied)