AUTOHOTIVE SOLUTIONS INC. The comparative financial statements of Automotive Solutions Inc. are as follows. The market price of Automotive Solutions Inc. common stock was $119.70 on December 31, 20Y8. Comparatve Baance Shest December 31. 201B and 20Y Calculate the twenty metrics of Equidity, solvency, and profitability for 20n Dec. 31, 20Y8 Dec. 31, 20Y7 f the calculation needs the 2017 year beginning number, use the 2017 year ending number assuming there is no change for year 20 Asscts .The market price of the firm's common stock was $12050 on Dec 31 2017 (in Excel. - Requirements: (round all numbers to 2 decimal place) 500,000 1,010,000 400,000 1,000,000 Accounts recavable (nat) 11.Time interest carned 12. Times preferred dividend earned 13. Asset turnover 14. Return on total assets 15. Return on stockholders' equity 16. Return on common stockholderse 17. Earnines per share on common stock 18. Price-earnings ratio 19. Dividends per share of common stodk 20. Dividend yield 1. Working capital 2. Current ratio 1.190.000 250,000 3.650,000 2,350,000 3.740,000 950,000 Prepaid expenses Tocal current a 069,000 2,300,000 3.366,00D 735,000 4. Accounts receivable tunover 5. Days' sales in receivables 6. Inventory turnover 7. Doys sales in inventory 8. Debt ratio 9. Ratio of liabilites to stockholders equity 10. Ratio of fixed assets to lone-term liabilities 2 Property. plant, and equipment (net) Total assets Current Eabilities 900,000 Mortgage note payable, 10% Bonds payable, 10% 1-700,000 $1,500,000 Total liabilities Comparatie Income Statemen: For the ears Ended December 31, 20NB and 20V7 Stockholders' Equity Preferred $0.90 stock $10 par Common stock, $5 par Retained earmings Total stockholders' equity Total lEabilities and stockholders equity 500,000 6,180,000 7,190,000 59,780,000 $10,000.000 9,400,000 375900 Gross proft 8,755,000 1.500.000 1.150.000 150,000 140,000 230,000 Net income AUTOMOTIVE SOLUTIONS INC For the Yoars Ended December 31, 20VS and Preferred Comnvon Retained Preferred Common Retained Stock Earnings 000 S 0,00 34.546.000 925,000 Stock Balances, Jan. 1 $500.000 8500,000 35,375,000 900,000 (45,000) Balances, Dac. 31$500,000 $500,000 $0,180,000 Preferred stock 0,000 5500,000