EE 17-44.215 Show Me How PE 17-4B Accounts receivable analysis OBJ. 3 A company reports the following: Sales $4,000,000 Average accounts receivable Inet) 200.000 Determine (a) the accounts receivable turnover and (b) the number of days' sales in receivables. Round to one decimal place. FEYE- IP E F G H K M 1 2 3 4 Problem 17-4B Name: Section: For use with Accounting, 25e and Financial Accounting, 13e by Warren/Reeve/Duchac 5 6 Score: 0% 7 Key Code Key code orel 8 Instructions 9 Answers are entered in the cels with gray backgrounds. 10 Cells with non-gray backgrounds are protected and cannot be edited. 11 An asterisk (*) will appear to the right of an incorrect entry. 12 13 Current Assets Current Uabilities 1. Working capitat Calculated Value Ratio Numerator + Denominator Calculated Value 2. 17 18 19 20 21 22 Current ratio Quick ratio 4. Accounts receivable tumover 5. 27 28 Number of days' sales in receivables 6. Inventory tumover 7. UITTUTTO II UTILIT III Number of days sales in inventory 30 31 32 33 34 35 36 37 38 39 40 41 8. Ratio of Fixed assets to long-term liabilities 9. Ratio of liabilities to stockholders' equity 10. Number of times interest charges eamed Pr. 17-4B B C D E F G H 11. Number of times preferred dividends eamed 12. Ratio of net sales to assets 13. Rate eamed on total assets 14. Rate eamed on stock- holders' equity 15. IIIIIIIII Rate eamed on common stockholders' equity IIIIIIIII 16. Eamings per share on common stock 17. Price-eamings ratio III 18. Dividends per share of common stock 19. Dividend yield