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 calculations needed for this assignment. See the attachment. Thank you!

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
Get step-by-step solutions from verified subject matter experts
