Please complete Problem9-4from the attached doc from in the text using the attached Excel template.

Problem 9-4 Name: Section: Score: 0% Key Code: 2 Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. A red asterisk (*) will appear in the row immediately beneath an incorrect answer. 1. - Working capital: Ratio Numerator = Denominator 2. Current ratio = 3. Quick ratio = 4. Accounts receivable turnover = 5. Number of days' sales in receivables = 6. Inventory turnover = 7. Number of days' sales in inventory = 8. Ratio of fixed assets to long-term liabilities = 9. Ratio of liabilities to stockholders' equity = 10. Number of times interest charges earned = 11. Number of times preferred dividends earned = 12. Ratio of net sales to assets = 13. Rate earned on total assets = 14. Rate earned on stockholders' equity = 15. Rate earned on common stockholders' equity = 16. Earnings per share on common stock = 17. Price-earnings ratio = 18. Dividends per share of common stock = 19. Dividend yield = Calculated Value