Question: I am looking for a spreadsheet that will assist me with calculations needed for this assignment. See the attachment. Thank you! Long-term debt ratio Times

 I am looking for a spreadsheet that will assist me with

I am looking for a spreadsheet that will assist me with calculations needed for this assignment. See the attachment. Thank you!

calculations needed for this assignment. See the attachment. Thank you! Long-term debt

Long-term debt ratio Times interest earned Current ratio Quick ratio Cash ratio Inventory turnover Average collection period 0.1 8.0 1.2 1.0 0.6 3.0 73 days Use the above information from the tables to work out the following missing entries, and then calculate the company's return on equity. Note: Turnover and the average collection period are calculated using start-of-year, not average, values. (Enter your answers in millions. Round intermediate calculations and final answers to 2 decimal places.) INCOME STATEMENT (Figures in $ millions) $ Net sales Cost of goods sold Selling, general, and administrative expenses Depreciation Earnings before interest and taxes (EBIT) 29.00 39.00 $ Interest expense $ Income before tax Tax (35% of income before tax) Net income $ BALANCE SHEET (Figures in $ millions) This Year Assets Last Year Cash and marketable securities $ $ 39 53 Accounts receivable 45 Inventories Total current assets $ $ 137 44 $ $181 Net property, plant, and equipment Total assets Liabilities and shareholders' equity Accounts payable Notes payable $35.00 45.00 Total current liabilities 80 16 Long-term debt 85 Shareholders' equity Total liabilities and shareholders' equity $ 30 50 $250.00 $181

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!