Measuring leverage (overall ability to pay debts): Calculate the debt ratio and the times interest
earned ratio for the latest year presented. How easily can the company meet its long-term
obligations? Which company is better at meeting its long-term obligations?
Company 1 Year 2017 Year 2016
Debt ratio 0.56 0.60
Times interest earned 3.96 11.26
Company 2 Year 2017 Year 2016
Debt ratio 0.26 0.27
Times interest earned ? ?
I am having a hard time calculating the times interest earned for company 2. I attached my spreadsheets with the data.
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 +``festive ( On ` )| File Home Insert Page Layout Formulas Data Review View Help ` Tell me what you want to do ( ? ) 80% Help Contact Feedback Show What's Community `Blog Suggest Support Training New Site a Feature Help Community G 23 X V ${\\ = ' Data Sheet " ! G 38 / 1 (' Data Sheet " ! G 28 + ' Data Sheet " ! H 28 ) / 2) \\D G As you enter numbers on the Data Sheet , H the division errors will disappear . DO NOT CHANGE THE FORMULAS ! ! !` Company 1 Year 2017 Company 2 Year 2016\\ Year 2015 Year 2017 Year 2016 Year 2015 4 Liquidity and Efficiency :" 5\\ Current ratio 0 . 64 6\\ Acid - Test ratio 0. 59| \\IN / A 1. 65 1.91 0 . 34 0 . 40 N / A N / A 0. 98 7\\ Accounts Receivable turnover 1. 26 17.57 N / A 8 Inventory turnover 9.91 \\N / A 26.17 10.50 25.61 N / A 0 . 70 9 Days' sales uncollected \\N / A 19 . 73 8.01 8.20 N / A 44.55 10 Days' sales in inventory N / A 13.36 34 . 73 13.82 796.52 \\N / A N / A 1 1 Total asset turnover 44. 75 0 . 45 42.89 N / A N / A 12\\ 0. 30 1.55 1.54 N / A 13 Solvency :" 14| Debt ratio 0. 56 15\\ Equity ratio 0. 60 N / A 0 . 26 0 . 44\\ 0. 27 N / A 0. 39 16 Debt - to - equity ratio N / A 0. 74 0 . 73 1.27 17\\ Times interest earned 1.55 N / A N / A 0 . 34 0 . 38 3.96 N / A 18\\ 11. 26* N / A # DIV / 0 !' # DIV / 0 !' N / A 19 Profitability :` 20| Profit margin ratio 21 Gross margin ratio 10. 50 % 30. 21% \\N / A 10 . 75% 53.85% 95. 88% 9.01 % N / A 22| Return on total assets* N / A 4. 75% 55 . 18% 9. 20% 53.89 %) N / A 23\\ Return on common stockholder's equity N / A 16 . 71% 24\\ 11. 48% 21.59% 13.85% 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 28\\ 0 . 75% 0 . 78% N / A 0 . 00 N / A 0 . 00% 0 . 00 % N / A 29 Ratio Analysis 30 Ratios to measure ability to pay current liabilities :" \\3 1 Current ratio* 32 Acid test ratio* 0 . 64 `` N / A` N / A 1. 65 3 3\\ 0 . 34 N / A N / A N / A N / A 0. 58 N / A N / A \\3/ 4 Ratios to measure turnover and cash conversion cycle :" 135\\ Days' sales uncollected*\\ 36 Davs' inventory outstanding** 19 . 78\\ \\N / A` \\N / A \\Data Sheet Ratios* 8.4 . 76\\ 13.36 N / A N / A VIN NLA 45. 57\\ N/A N/A ^\\ O Type here to search (@ )
