Question: Response upload instructions: You should attach your Excel file. Please be sure to label each part of your answer as 1a, 1b, etc. Below is
Response upload instructions: You should attach your Excel file. Please be sure to label each part of your answer as 1a, 1b, etc.
Below is selected balance sheet and income statement information from Scott & Company.
(in millions) | 2014 | 2012 |
Cash | $ 1,483.36 | $ 1,536.73 |
Accounts receivable | 735.30 | 1,097.16 |
Current assets | 3,918.33 | 4,913.56 |
Current liabilities | 5,157.95 | 2,385.39 |
Long-term debt | 3,611.63 | 17,620.81 |
Short-term debt | 4,568.83 | 1,033.96 |
Total liabilities | 26,363.17 | 23,218.42 |
Interest expense | 1,338.29 | 1,566.90 |
Capital expenditures | 211.50 | 1,545.48 |
Equity | -7,152.90 | 4,587.67 |
Cash from operations | 685.98 | 610.89 |
Earnings before interest and taxes | 1,902.84 | 1,594.84 |
a. Compute the following liquidity, solvency and coverage ratios for both years. (4 points)
- Quick ratio (2014, 2012)
- Working Capital (2014, 2012)
- Liabilities-to-equity(2014,2012)
- Times interest earned(2014,2012)
- Cash from operations to total debt(2014,2012)
- Free operating cash flow to total debt(2014,2012)
b. What is your overall assessment of the company's credit risk? Explain. What differences do you observe between the two years? Please be brief. (4 points)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
