Selected data from Emporia Company follow. 13 Accounts receivable Allowance for doubtful accounts Net accounts receivable 10 Inventories, lower of cost or market 14 15 Net credit sales 16 Net cash sales X 23 Required fr Selected data from Emporia Company follow. A 17 Net sales 18 Cost of goods sold 19 Selling, general, and administrative expenses 20 Other expenses 21 Total operating expenses 31 32 ga Balance Sheets As of December 31 28 a. Compute the accounts receivable turnover for Year 3. 29 b. Compute the inventory turnover for Year 3. 30 c. Compute the net margin for Year 2. B Year 3 $600,000 (540,000) $560,000 $500,000 Income Statement For the Years Ended December 31 25 (Use the cells from the given information above to complete this question.) 26 (For all requirements, round your answers to 2 decimal places.) Year 3 $2,400,000 $600,000 $3,000,000 $1,800,000 $300,000 $80,000 $2,180,000 times times C Year 2 $480,000 ($20,000) $460,000 $400,000 Year 2 $1,950,000 $450,000 $2,400,000 $1,520,000 $240,000 $50,000 $1,810,000

please help explain with excel formual as i dont understand

A2 fx Selected data from Emporia Company follow. Required (Use the cells from the given information above to complete this question.) (For all requirements, round your answers to 2 decimal places.) a. Compute the accounts receivable turnover for Year 3. b. Compute the inventory turnover for Year 3. c. Compute the net margin for Year 2