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 |
b. | Current ratio = Current assets ÷ Current liabilities |
c. | Acid-test (quick) ratio = Quick assets* ÷ Current liabilities |
*Quick assets = Cash + Marketable securities + Current receivables
= $190,000 + $0 + $197,000 = $387,000
d. | Accounts receivable turnover = Sales on account ÷ Average accounts receivable* |
*Average accounts receivable = ($197,000 + $200,000) ÷ 2 = $198,500
e. | Average collection period = 365 days ÷ Accounts receivable turnover |
f. | Inventory turnover = Cost of goods sold ÷ Average inventory* |
*Average inventory = ($232,000 + $200,000) ÷ 2 = $216,000
g. | Average sale period = 365 days ÷ Inventory turnover |
h. | Operating cycle = Average sale period + Average collection period |
i. | Total asset turnover = Sales ÷ Average total assets* |
*Average total assets = ($1,323,000 + $1,300,000) ÷ 2 = $1,311,500
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.
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)
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%
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