Measuring profitability:
-Calculate the following ratios for the latest year presented: Gross margin ratio, operating
income ratio, and earnings per share. How profitable are the companies?
-Calculate return on total assets for the two most recent years. What is the trend?
Help Community F37 X 115675 A A B PINK means that the information should be used in your paper E G H Ln YELLOW means that the information might be used in your paper (Only enter information in green, pink or yellow cells) Company name Company 1 Most recent year end date Company 1 Company 2 10 1 year prior year end date Year 2017 Company 2 Year 2016 Year 2017 11 2 years prior year end date Year 2015 Year 2016 12 Are dollars in thousands, millions or billions? Year 2015 13 Millons Thousands 14 Balances from balance sheet: 15 Cash and cash equivalents Year 2017 Year 2016 Year 2015 Year 2017 16 Receivables, net 419 0 Year 2016 Year 2015 451 728 805 531 65,637 91,035 94,193 17 Allowance for doubtful accounts 17,70 526 33, 749 36,694 18 Marketable securities 11.30 38,984 9.50 19 Inventory 20 Other current assets, if any 592 593 179 50,651 52,499 21 Total current assets 682 56,462 2, 188 2,170 383 22 PP&E 10,695 8,731 23 Total assets AHAH B 4 674 7 4,507 168,348 193,887 24 F 30,247 29,342 2 1 384,280 408,4 13,980 569,624 615,946 25 Accounts payable 645,400 26 Total current liabilities 2,680 2,468 27 Total liabilities 3,399 38, 141 40,585 3,158 16,812 101, 758 17,720 101,519 28 Stockholders' equity 13,226 11,419 7,043 146, 101 169,364 29 Common stock outstanding 2.0 423,523 446,582 2.0 461,221 30 Common stock authorized 500 12,035 12,533.0 31 32 33 Totals from income statement: 34 Revenues/Sales Year 2017 Year 2016 Year 2015 13,472 Year 2017 6,597 Year 2016 Year 2015 35 Cost of goods sold 5,127 6,21 921,736 968,994 36 Interest expense 272 2,132 1,024,040 349 413,091 37 Operating income before interest and taxes (EBIT) 272 446, 776 458,317 38 Net income 1,382 3,057 1,993 115,675 39 Earnings per share 1,414 137,659 40 215.40 99,049 212.00 87,349 8.18 6.93 41 Data Sheet Ratios +File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do ? Help Contact Feedback Show POR What's Community Blog Suggest Support Training New Site a Feature Help Community G23 fx ='Data Sheet'!G38/(('Data Sheet'!G28+'Data Sheet'!H28)/2) B C D E F G As you enter numbers on the Data Sheet, H the division errors will disappear. DO NOT CHANGE THE FORMULAS!!! Company 1 Company 2 N Year 2017 Year 2016 Year 2015 3 Year 2017 Year 2016 Year 2015 4 Liquidity and Efficiency: 5 Current ratio 0.64 0.69 6 Acid-Test ratio N/A 1.65 1.91 0.34 N/A 0.40 N/A 7 Accounts Receivable turnover 0.98 1.26 17.57 8 Inventory turnover 9.91 N/A N/A 26.17 25.61 10.50 N/A 9 Days' sales uncollected 0.70 N/A 8.01 8.20 10 Days' sales in inventory 19.73 44.55 N/A N/A 13.36 13.82 34.73 N/A 796.52 11 Total asset turnover N/A 44.75 42.89 0.45 N/A 12 0.30 N/A 1.55 1.54 N/A 13 Solvency: 14 Debt ratio 15 Equity ratio 0.56 0.60 N/A 0.26 0.44 0.39 0.27 N/A 16 Debt-to-equity ratio N/A 0.74 1.27 0.73 1.55 N/A 17 Times interest earned N/A 0.34 3.96 0.38 18 11.26 N/A N/A #DIV/0! #DIV/O! N/A 19 Profitability: 20 Profit margin ratio 10.50% 30.21% 21 Gross margin ratio N/A 53.85% 10.75% 9.01% N/A 22 Return on total assets 95.88% N/A 55.18% 4.75% 53.89% 9.20% N/A 23 Return on common stockholder's equity N/A 11.48% 16.71% 13.85% 24 21.59% N/A N/A 22.77% 19.24% N/A 25 Market Prospects: 26 Price-earning ratio 27 Dividend yield 1.00 1.00 N/A 0.00 0.76% 0.00 0.78% N/A 28 N/A 0.00% 0.00%) N/A 29 Ratio Analysis 30 Ratios to measure ability to pay current liabilities: 31 Current ratio 32 Acid test ratio 0.64 N/A N/A 1.65 0.34 N/A N/A N/A V/N 0.98 N/A N/A 34 Ratios to measure turnover and cash conversion cycle: 35 Days' sales uncollected 19.73 Davs' inventory outstanding N/A N/A 34.76 N/A 13.36 N/A N/A Data Sheet Ratios NZA 45.57 N/A N/A
