Question

elected data from Munoz Company follow: Balance Sheets As of December 31 Year 3 Year 2 Accounts receivable $ 403,000 $ 377,000 Allowance for doubtful accounts (20,150 ) (15,080 ) Net accounts receivable $ 382,850 $ 361,920 Inventories, lower of cost or market $ 477,500 $ 443,000 Income Statement For the Years Ended December 31 Year 3 Year 2 Net credit sales $ 2,007,000 $ 1,756,000 Net cash sales 415,000 300,000 Net sales 2,422,000 2,056,000 Cost of goods sold 1,592,000 1,440,000 Selling, general, and administrative expenses 240,300 214,100 Other expenses 39,700 23,100 Total operating expenses $ 1,872,000 $ 1,677,200 Required 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. (For all requirements, round your answers to 2 decimal places.)

Answer 1

Solution :

a). Account $\text{receivable}$ turnover for year $3$

$=\frac{\text{net credit sales}}{\text{average accounts receivable }}$

$=\frac{ 2,007,000}{(382,850 + 361,920)/2}$

$=\frac{ 2,007,000}{372385}$

= 0.538 times

b). The $\text{inventory turnover}$ for Year $3$

$=\frac{\text{cost of goods sold }}{\text{average inventory }}$

$=\frac{1,592,000}{(477,500 + 443,000)/2}$

$=\frac{1,592,000}{460250}$

= 3.45 times

c).  The $\text{net margin}$ for Year $2$.

$={\text{net sales } - \text{total operating expenses}$

= 2,056,000 - 1,677,200

= $ 378800

$=\frac{\text{net margin }}{\text{net revenue }}$

$=\frac{378800}{2056000}$

= 0.1842

= 18.42%