Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 $181Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started