Abdool Corporation has provided the following financial data:Balance SheetDecember 31, Year 2 and Year 1AssetsYear 2Year 1Current assets:        Cash$190,000 $190,000   Accounts receivable, net 197,000  200,000   Inventory 232,000  200,000   Prepaid expenses 9,000  10,000 Total current assets 628,000  600,000 Plant and equipment, net 695,000  700,000 Total assets$ 1,323,000 $ 1,300,000        Liabilities and Stockholders' Equity      Current liabilities:        Accounts payable$206,000 $200,000   Accrued liabilities 104,000  90,000   Notes payable, short term 41,000  50,000 Total current liabilities 351,000  340,000 Bonds payable 130,000  130,000 Total liabilities 481,000  470,000 Stockholders'

equity:        Common stock, $2 par value 160,000  160,000   Additional paid-in capital 70,000  70,000   Retained earnings 612,000  600,000 Total stockholders' equity 842,000  830,000 Total liabilities & stockholders' equity$ 1,323,000 $ 1,300,000 Income StatementFor the Year Ended December 31, Year 2Sales (all on account)$1,330,000 Cost of goods sold 740,000 Gross margin 590,000 Operating expenses 555,000 Net operating income 35,000 Interest expense 11,000 Net income before taxes 24,000 Income taxes (30%) 7,200 Net income$16,800 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?

What will be an ideal response?


a.Working capital = Current assets - Current liabilities
= $628,000 - $351,000 = $277,000

b.Current ratio = Current assets ÷ Current liabilities
= $628,000 ÷ $351,000 = 1.79 (rounded)

c.Acid-test (quick) ratio = Quick assets* ÷ Current liabilities
= $387,000 ÷ $351,000 = 1.10 (rounded)

*Quick assets = Cash + Marketable securities + Current receivables
= $190,000 + $0 + $197,000 = $387,000

d.Accounts receivable turnover = Sales on account ÷ Average accounts receivable*
= $1,330,000 ÷ $198,500 = 6.70 (rounded)

*Average accounts receivable = ($197,000 + $200,000) ÷ 2 = $198,500

e.Average collection period = 365 days ÷ Accounts receivable turnover
= 365 days ÷ 6.70 = 54.5 days (rounded)

f.Inventory turnover = Cost of goods sold ÷ Average inventory*
= $740,000 ÷ $216,000 = 3.43 (rounded)

*Average inventory = ($232,000 + $200,000) ÷ 2 = $216,000

g.Average sale period = 365 days ÷ Inventory turnover
= 365 days ÷ 3.43 = 106.4 days (rounded)

h.Operating cycle = Average sale period + Average collection period
= 106.4 days + 54.5 days = 160.9 days

i.Total asset turnover = Sales ÷ Average total assets*
= $1,330,000 ÷ $1,311,500 = 1.01 (rounded)

*Average total assets = ($1,323,000 + $1,300,000) ÷ 2 = $1,311,500

Business

You might also like to view...

Which of the following statements applies to media planning?

A. Characteristics of the product are the most important consideration in selecting the media for a campaign. B. The message content affects the types of media used for an advertising campaign. C. The location of the advertising target is irrelevant in media planning. D. Total media dollars spent on advertising have decreased over the last 30 years. E. Regardless of the message to be conveyed, newspapers are one medium that is appropriate for almost any circumstances.

Business

A company's quick assets are $175,000 and its current liabilities are $160,000. This company's acid-test ratio is 1.09.

Answer the following statement true (T) or false (F)

Business

Suppose you invest $20,000 by purchasing 200 shares of Abbott Labs (ABT) at $50 per share, 200 shares of Lowes (LOW) at $30 per share, and 100 shares of Ball Corporation (BLL) at $40 per share

Suppose over the next year Ball has a return of 12.5%, Lowes has a return of 21%, and Abbott Labs has a return of -10%. The return on your portfolio over the year is ________. A) 0% B) 7.6% C) 3.8% D) 5.7%

Business

Which of the following project parameters would be compatible with the use of the agile approach?

a. Projects with inexperienced and dispersed teams b. Projects that have a fairly rigid completion date c. Projects with clear-up front requirements d. Projects that have more flexible scheduling

Business