I need the solutions in excel sheet please Problem 1: Plastics


Question Description:

30

Feb 01, 2016. I need the solutions in excel sheet please Problem 1: Plastics Inc. is a company that operates in four different divisions. The following information relating to each segment is available for 2013. Sales revenue Cost of goods sold Operating expenses Total expenses Operating profit (loss) Identifiable assets Bottles $ 65,000 $  26,000 $8,000 $ 34,000 $31,000 $ 66,000 Containers $ 95,000 $ 62,000 $ 48,000 $ 110,000 $ (15,000) $  80,000 Dollhouses $ 620,000 $ 353,000 $140,000 $ 493,000 $ 127,000 $ 640,000 Silverware $18,000 $  8,000 $ 6,500 $14,500 $3,500 $36,000 Sales of segments Containers and Dollhouses included intersegment sales of $30,000 and $150,000, respectively. Required: Determine which of the segments are reportable based on the following: Revenue Test Operating profit (loss) test Identifiable assets test Problem 2: The following information pertains to Walrus Inc. Cash $60,000 Accounts receivable 170,000 Inventory 100,000 Plant assets (net) 582,000 Total assets $912,000 Accounts payable $110,000 Accrued taxes and expenses payable 42,000 Long-term debt 120,000 Common stock ($10 par) 260,000 Paid-in capital in excess of par 50,000 Retained earnings 330,000 Total equities $912,000 Net sales (all on credit) $2,000,000 Cost of goods sold 1,400,000 Net income 120,000 Required: Compute the following: (ignore Avg for balance sheet accounts) (a) Current ratio (b) Inventory turnover (c) Receivables turnover (d) Book value per share (e) Earnings per share (f) Debt to total assets (g) Profit margin on sales (h) Return on common stock equity ATTACHMENT PREVIEW Download attachment 2 pages ACCT557_W7_HW_Questions.docx Homework – Week 7 – Chapter 24 Problem 1: Plastics Inc. is a company that operates in four different divisions. The following information relating to each segment is available for 2013. Bottles Containers Dollhouses Silverware Sales revenue $ 65,000 $ 95,000 $ 620,000 $18,000 Cost of goods sold $ 26,000 $ 62,000 $ 353,000 $ 8,000 Operating expenses $8,000 $ 48,000 $140,000 $ 6,500 Total expenses $ 34,000 $ 110,000 $ 493,000 $14,500 Operating profit (loss) $31,000 $ (15,000) $ 127,000 $3,500 Identifiable assets $ 66,000 $ 80,000 $ 640,000 $36,000 Sales of segments Containers and Dollhouses included intersegment sales of $30,000 and $150,000, respectively. Required: Determine which of the segments are reportable based on the following: Revenue Test Operating profit (loss) test Identifiable assets test Problem 2: The following information pertains to Walrus Inc. Cash Accounts receivable Inventory Plant assets (net) Total assets $60,000 170,000 100,000 582,000 $912,000 Accounts payable Accrued taxes and expenses payable Long-term debt Common stock ($10 par) Paid-in capital in excess of par Retained earnings Total equities $110,000 42,000 120,000 260,000 50,000 330,000 $912,000 Net sales (all on credit) Cost of goods sold Net income Required: Compute the following: (ignore Avg for balance sheet accounts) (a) Current ratio (b) Inventory turnover (c) Receivables turnover (d) Book value per share $2,000,000 1,400,000 120,000 Homework – Week 7 – Chapter 24 (e) (f) (g) (h) Earnings per share Debt to total assets Profit margin on sales Return on common stock equity Read more ElderDangerDonkey1415
posted a question · Feb 01, 2016 at 8:06pm

Answer

30