SOLUTION:
| 1) | Ratios | Formula | Sied Co. | Zip Co. | |
| Current Ratio: | Current Assets/Current liabilities | 2.18 | 2.23 | ||
| Current Assets(except plant & equipment) | 122080 | 178400 | |||
| Current Liabilites | 56000 | 80000 | |||
| Acid test Ratio | Quick Assets/Quick liabilities | 1.1 | 1.09 | ||
| Quick Assets=Current Assets-Inventory-prepraid expenses | 61600 | 87200 | |||
| Quick Liabilites=Current liabilities-bank OD-CC | 56000 | 80000 | |||
| Inventory Turnover ratio | COGS/Average stock | 6.39 | 5.43 | times | |
| COGS(given) | 528080 | 699840 | |||
| Average stock(given) | 82600 | 128960 | |||
| Days sales uncollected | Accounts receivable/Net annual credit sales*365 | 26.99 | 27.87 | days | |
| Accounts receivable | 49700 | 67200 | |||
| Net annual credit sales | 672000 | 880000 | |||
| Analysis | Sied Co. is better in all respects as per its days sales uncollected and Inventory T/O | ||||
| Also, there is no idle current assets as per its ratios | |||||
| 2) | Return on total assets | EBIT/Average ofTotal Assets | 28.75 | 28.11 | |
| EBIT=Net income+Interest+tax | 27573 | 34496 | |||
| Average Total Assets(Opening+closing/2) | 350000 | 448000 | |||
| Return on stock holder equity | Net Income/Equity | 37.38 | 36.02 | ||
| Net Income | 23373 | 28896 | |||
| Equity | 228200 | 292800 | |||
| As per above calculations, the ROE of Sied Co. is higher and its book value is also higher. | |||||
| So it is a better for investment | |||||
Ctio IT-Uw 11, -- Following are data from the statements of two companies selling similar products:...
Summary information from the financial statements of two companies competing in the same industry follows. Problem 13-5A Comparative ratio analysis A1P3 T Barco Company Kyan Company Barco Сотрату Kyan Сотрату Sales Data from the current year-end balance sheets Assets Cash ... $19,500 Accounts receivable, net 37.400 Current notes receivable (trade).... 9.100 Merchandise inventory.......... 84.440 Prepaid expenses 5.000 Plant assets, net... 290,000 Total assets.. $445,440 $ 34,000 57.400 7.200 132.500 6.950 304,400 $542.450 Data from the current year's income statement $770,000...
Summary information from the financial statements of two companies competing in the same industry follows. Barco Kyan Company Company Data from the current year and balance sheets Assets Cash $ 21,000 $31.000 Accounts receivable, et 37.400 54,400 Current notes receivable (trade) 9,800 3.200 Merchandise inventory 84,840 134,500 Prepaid expenses 6,200 2,850 Plant annets, net 290,000 306,400 Total assets $449,240 $542,350 Barco Kyan Company Coepany Data from the current year's income statement Sales $800,000 $920,200 cost of goods sold 587,100 634.500...
Summary information from the financial statements of two companies competing in the same industry follows. Kyan Company Barco Company Data from the current year-end balance sheets Assets $ 22,500 Accounts receivable, net 40. 400 Current notes receivable (trade) 10,100 Merchandise Inventory 84,340 Prepaid expenses 5.400 Plant annet.net 290.000 Total assets $452.740 $ 33,000 54.400 ,000 136,500 7,850 105.400 $546,150 Barco Ryan Company Company Data from the current year'Income statement sales $780,000 $898,200 cost of goods sold 585,100 634,500 Interest expense...
Summary information from the financial statements of two companies competing in the same industry follows. Barco Company Kyan Company Barco Company Kyan Company Data from the current year-end balance sheets Data from the current year’s income statement Assets Sales $ 770,000 $ 880,200 Cash $ 19,500 $ 34,000 Cost of goods sold 585,100 632,500 Accounts receivable, net 46,500 64,600 Interest expense 7,900 13,000 Merchandise inventory 84,440 132,500 Income tax expense 14,800 24,300 Prepaid expenses 5,000 6,950 Net income 162,200...
Summary information from the financial statements of two companies competing in the same industry follows. Barco Кyan Company Company Data from the current year-end balance sheets Assets Cash 22,000 $ 35,000 Accounts receivable, net 33,400 54,400 Current notes receivable (trade) Merchandise inventory 9,900 8,800 84,640 142,500 Prepaid expenses 7,600 5,700 Plant assets, net 360,000 307,400 Total assets 515,640 $ 555,700 Liabilities and Equity Current 1iabilities 62,340 $ 101,300 Long-term notes payable Common stock, $5 par value Retained earnings 80,800 103,000...
Summary information from the financial statements of two companies competing in the same industry follows. Barco Kyan Company Company Data from the current year-end balance sheets Assets $ 19,500 $ 34,000 Accounts receivable, net 37.400 57,400 Current notes receivable (trade) 9. 1097 .209 Merchandise Inventory 84,449 132.500 Prepaid expenses 5.900 0.959 plant assets.net 299,000 304,400 Total assets 5465, 4405542,450 Barco kyan. Company Company Data from the current year's income statement Sales $770,000 $880, 200 Cost of goods sold 585, 109...
Presented below are condensed financial statements adapted from those of two actual companies competing in the pharmaceutical industry—Johnson and Johnson (J&J) and Pfizer, Inc. ($ in millions, except per share amounts). Balance Sheets ($ in millions, except per share data) J&J Pfizer Assets: Cash $ 16,779 $ 11,244 Short-term investments 6,144 12,400 Accounts receivable (net) 8,894 11,095 Inventories 5,744 9,603 Other current assets 5,790 5,655 Current assets 43,351 49,997 Property, plant, and equipment (net) 15,542 23,983 Intangibles and other assets...
Presented below are condensed financial statements adapted from those of two actual companies competing in the pharmaceutical industry—Johnson and Johnson (J&J) and Pfizer, Inc. ($ in millions, except per share amounts). Balance Sheets ($ in millions, except per share data) J&J Pfizer Assets: Cash $ 10,641 $ 5,801 Short-term investments 5,037 11,293 Accounts receivable (net) 7,589 9,790 Inventories 4,520 7,459 Other current assets 4,395 4,260 Current assets 32,182 38,603 Property, plant, and equipment (net) 12,338 20,779 Intangibles and other assets...
Profitability Ratios The following selected data were taken from the financial statements of Vidahill Inc. for December 31, 2017, 2016, and 20Y5: December 31 2017 2016 2015 Total assets $244,000 $220,000 $196,000 Notes payable (8% interest) 80,000 80,000 80,000 Common stock 32,000 32,000 32,000 Preferred 6% stock, $100 par 16,000 16,000 16,000 (no change during year) Retained earnings 83,360 59,840 48,000 The 2017 net income was $24,480, and the 2016 net income was $12,800. No dividends on common stock were...
Presented below are condensed financial statements adapted from those of two actual companies competing in the pharmaceutical industry, Johnson and Johnson (J&J) and Pfizer, Inc. ($ in millions, except per share amounts). Balance Sheets ($ in millions, except per share data) J&J Pfizer Assets: Cash $ 9,959 $ 5,184 Short-term investments 4,914 11,170 Accounts receivable (net) 7,444 9,645 Inventories 4,384 7,233 Other current assets 4,240 4,105 Current assets 30,941 37,337 Property, plant, and equipment (net) 11,982 20.423 Intangibles and other...