Kaloi Corporation has provided the following financial data:Balance SheetDecember 31, Year 2 and Year 1AssetsYear 2Year 1Current assets: Cash$205,000 $190,000 Accounts receivable, net 192,000 200,000 Inventory 118,000 130,000 Prepaid expenses 41,000 40,000 Total current assets 556,000 560,000 Plant and equipment, net 813,000 770,000 Total assets$1,369,000 $1,330,000 Liabilities and Stockholders' Equity Current liabilities: Accounts payable$115,000 $100,000 Accrued liabilities 27,000 30,000 Notes payable, short term 55,000 60,000 Total current liabilities 197,000 190,000 Bonds payable 130,000 130,000 Total liabilities 327,000 320,000 Stockholders' equity: Common stock, $2 par

Question

value 100,000  100,000 Additional paid-in capital 60,000  60,000 Retained earnings 882,000  850,000 Total stockholders' equity 1,042,000  1,010,000 Total liabilities & stockholders' equity$1,369,000 $1,330,000 Income StatementFor the Year Ended December 31, Year 2Sales (all on account)$1,370,000 Cost of goods sold 830,000 Gross margin 540,000 Operating expenses 478,286 Net operating income 61,714 Interest expense 11,000 Net income before taxes 50,714 Income taxes (30%) 15,214 Net income$35,500 Dividends on common stock during Year 2 totaled $3,500. The market price of common stock at the end of Year 2 was $7.46 per share.Required:a. What is the company's working capital at the end of Year 2?b. What is the company's current ratio at the end of Year 2?c. What is the company's acid-test (quick) ratio at the end of Year 2?d. What is the company's accounts receivable turnover for Year 2?e. What is the company's average collection period for Year 2?f. What is the company's inventory turnover for Year 2?g. What is the company's average sale period for Year 2?h. What is the company's operating cycle for Year 2?i. What is the company's total asset turnover for Year 2?j. What is the company's times interest earned ratio for Year 2?k. What is the company's debt-to-equity ratio at the end of Year 2?l. What is the company's equity multiplier at the end of Year 2?m. What is the company's net profit margin percentage for Year 2?n. What is the company's gross margin percentage for Year 2?o. What is the company's return on total assets for Year 2?p. What is the company's return on equity for Year 2?

What will be an ideal response?

Answer 1

a.

Working capital = Current assets - Current liabilities

= $556,000 - $197,000 = $359,000

 

b.

Current ratio = Current assets ÷ Current liabilities

= $556,000 ÷ $197,000 = 2.82 (rounded)

 

c.

Acid-test (quick) ratio = Quick assets* ÷ Current liabilities

= $397,000 ÷ $197,000 = 2.02 (rounded)

*Quick assets = Cash + Marketable securities + Current receivables

= $205,000 + $0 + $192,000 = $397,000

 

d.

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

= $1,370,000 ÷ $196,000 = 6.99 (rounded)

*Average accounts receivable = ($192,000 + $200,000) ÷ 2 = $196,000

 

e.

Average collection period = 365 days ÷ Accounts receivable turnover

= 365 days ÷ 6.99 = 52.2 days (rounded)

 

f.

Inventory turnover = Cost of goods sold ÷ Average inventory*

= $830,000 ÷ $124,000 = 6.69 (rounded)

*Average inventory = ($118,000 + $130,000) ÷ 2 = $124,000

 

g.

Average sale period = 365 days ÷ Inventory turnover

= 365 days ÷ 6.69 = 54.6 days (rounded)

 

h.

Operating cycle = Average sale period + Average collection period

= 54.6 days + 52.2 days = 106.8 days

 

i.

Total asset turnover = Sales ÷ Average total assets*

= $1,370,000 ÷ $1,349,500 = 1.02 (rounded)

*Average total assets = ($1,369,000 + $1,330,000) ÷ 2 = $1,349,500

 

j.

Times interest earned ratio = Earnings before interest expense and income taxes ÷ Interest expense

= $61,714 ÷ $11,000 = 5.61 (rounded)

 

k.

Debt-to-equity ratio = Total liabilities ÷ Stockholders' equity

= $327,000 ÷ $1,042,000 = 0.31 (rounded)

 

l.

Equity multiplier = Average total assets* ÷ Average stockholders' equity*

= $1,349,500 ÷ $1,026,000 = 1.32 (rounded)

*Average total assets = ($1,369,000 + $1,330,000) ÷ 2 = $1,349,500

**Average stockholders' equity = ($1,042,000 + $1,010,000) ÷ 2 = $1,026,000

 

m.

Net profit margin percentage = Net income ÷ Sales

= $35,500 ÷ $1,370,000 = 2.6% (rounded)

 

n.

Gross margin percentage = Gross margin ÷ Sales

= $540,000 ÷ $1,370,000 = 39.4% (rounded)

 

o.

Return on total assets = Adjusted net income* ÷ Average total assets**

= $43,200 ÷ $1,349,500 = 3.20% (rounded)

*Adjusted net income = Net income + [Interest expense × (1 - Tax rate)]

= $35,500 + [$11,000 × (1 - 0.30)] = $43,200

**Average total assets = ($1,369,000 + $1,330,000) ÷ 2 = $1,349,500

 

p.

Return on equity = Net income ÷ Average stockholders' equity*

= $35,500 ÷ $1,026,000 = 3.46% (rounded)

*Average stockholders' equity = ($1,042,000 + $1,010,000) ÷ 2 = $1,026,000