Question

Hello need help with this problem.

******Ignore vi.operating profit margin*****

Please find below the financial data for the Collins Company as of December 31, 2019: Inventory Long-term debt Interest expense Accumulated depreciation Cash Net sales (all credit) Common stock Accounts receivable Operating expense (incl. depr. exp. and taxes) Notes payable-current Cost of goods sold Plant and equipment Accounts payable Marketable securities Accrued wages Retained earnings $300,000 500,000 25,000 450,000 280,000 1.800.000 900,000 325,000 625.000 200,000 1.100.000 1,400,000 180,000 80,000 45,000 110,000 1) With the information for the Collins Company that was presented in the above table, please calculate the following ratios: i. current ratio ii. acid test ratio 111. average collection period 1V. inventory turnover V. gross profit margin vi. operating profit margin vii. net profit margin viii. total asset turnover

Answer 1

Current assets = inventory + cash + accounts receivable + marketable securities

= $300000 + $280000 + $325000 + $80000

= $985000

current liabilities = Notes payable current + accounts payable

= $200000 + $180000

= $380000

(1)

Current ratio = current assets/current liabilities

= $985000/$380000

= 2.59 times

(2)

acid test ratio = (cash + accounts receivable + marketable securities)/current liabilities

= ($280000 + $325000 + $80000)/$380000

= 1.80 times

(3)

average collection period = (average accounts receivable/net credit sales) x 365

= ($325000/$1800000) x 365

= 65.90 or 66 days

note: in the absence beginning accounts receivable, given closing accounts receivable is assumed as average accounts receivable

(4)

inventory turnover = cost of goods sold/average inventory

= $1100000/$300000

= 3.67 times

note: in the absence beginning inventory, given closing inventory is assumed as average inventory.

(5)

Gross profit = net sales - cost of goods sold

= $1800000 - $1100000 = $700000

gross profit margin = gross profit/net sales

= $700000/$1800000

= 38.89%

(7)

net profit = gross profit - operating expenses - interest expense

= $700000 - $625000 - $25000 = $50000

net profit margin = net profit/net sales

= $50000/$1800000

= 2.78%

(8)

total assets = inventory + cash + accounts receivable + plant and equipment - accumulated depreciation + marketable securities

= $300000 + $280000 + $325000 + $1400000 - $450000 + $80000

= $1935000

total asset turnover = net sales/average total assets

= $1800000/$1935000

= 0.93 times