Hagle Corporation has provided the following financial data:Balance SheetDecember 31, Year 2 and Year 1AssetsYear 2Year 1Current assets: Cash$279,000 $170,000 Accounts receivable, net 136,000 150,000 Inventory 141,000 150,000 Prepaid expenses 69,000 60,000 Total current assets 625,000 530,000 Plant and equipment, net 789,000 870,000 Total assets$1,414,000 $1,400,000 Liabilities and Stockholders' Equity Current liabilities: Accounts payable$186,000 $190,000 Accrued liabilities 29,000 30,000 Notes payable, short term 74,000 70,000 Total current liabilities 289,000 290,000 Bonds payable 130,000 130,000 Total liabilities 419,000 420,000 Stockholders' equity: Common stock, $4 par

Question

value 200,000  200,000 Additional paid-in capital 90,000  90,000 Retained earnings 705,000  690,000 Total stockholders' equity 995,000  980,000 Total liabilities & stockholders' equity$1,414,000 $1,400,000 Income StatementFor the Year Ended December 31, Year 2Sales (all on account)$1,280,000 Cost of goods sold 750,000 Gross margin 530,000 Operating expenses 489,429 Net operating income 40,571 Interest expense 12,000 Net income before taxes 28,571 Income taxes (30%) 8,571 Net income$20,000 Required:a. What is the company's accounts receivable turnover for Year 2?b. What is the company's average collection period for Year 2?c. What is the company's inventory turnover for Year 2?d. What is the company's average sale period for Year 2?e. What is the company's operating cycle for Year 2?f. What is the company's total asset turnover for Year 2?

What will be an ideal response?

Answer 1

a.

Accounts receivable turnover = Sales on account ÷ Average accounts receivable*

= $1,280,000 ÷ $143,000 = 8.95 (rounded)

*Average accounts receivable = ($136,000 + $150,000) ÷ 2 = $143,000

 

b.

Average collection period = 365 days ÷ Accounts receivable turnover

= 365 days ÷ 8.95 = 40.8 days (rounded)

 

c.

Inventory turnover = Cost of goods sold ÷ Average inventory*

= $750,000 ÷ $145,500 = 5.15 (rounded)

*Average inventory = ($141,000 + $150,000) ÷ 2 = $145,500

 

d.

Average sale period = 365 days ÷ Inventory turnover

= 365 days ÷ 5.15 = 70.9 days (rounded)

 

e.

Operating cycle = Average sale period + Average collection period

= 70.9 days + 40.8 days = 111.7 days

 

f.

Total asset turnover = Sales ÷ Average total assets*

= $1,280,000 ÷ $1,407,000 = 0.91 (rounded)

*Average total assets = ($1,414,000 + $1,400,000) ÷ 2 = $1,407,000