2013 2012 1000000 1200000 450000 600000 550000 600000 600000 450000 -50000 150000 2013 2012 380000 376000 -20000 -16000 360000 360000 480000 440000 3400000 3080000 1600000 1440000 780000 680000 Problem 1 Problem 2 Sales Cost of goods sold Gross margin Operating expenses Net income % Sales Comments Accounts receivable Inventory Allowance for doubtful accounts Net accounts receivable Required: Compute (1) accounts receivable turnover for 2013, (2) the inventory turnover for 2013, and (3) the net margin for 2012.
2013 2012 1000000 1200000 450000 600000 550000 600000 600000 450000 -50000 150000 2013 2012 380000 376000 -20000 -16000 360000 360000 480000 440000 3400000 3080000 1600000 1440000 780000 680000 Problem 1 Problem 2 Sales Cost of goods sold Gross margin Operating expenses Net income % Sales Comments Accounts receivable Inventory Allowance for doubtful accounts Net accounts receivable Required: Compute (1) accounts receivable turnover for 2013, (2) the inventory turnover for 2013, and (3) the net margin for 2012. Balance sheet items Income statement items Required: Express each income statement component as a percentage of sales, and comment on the trends in each line from 2012 to 2013. ???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????
Attachments:
2.xlsx