Question

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 7,700 15,000 Tncome tax expense 14,992 24.1797 Net Income 172,208 221,903 Basie earnings per share 4.31 4.74 Cash dividende per share 3.76 3.94 Liabilities and Equity Current liabilities Long-term notes payable Common stock, $5 par value Retained earnings Total liabilities and equity $61.340 85,800 200.000 103.600 $452,740 99,300 105,000 236,000 105,50 $546, 150 Beginning-of-year balance sheet data Accounts receivable, net Current notes receivable (trade) Merchandise Inventory Total assets Common stock, 35 par value Retained earnings $ 29,800 $ 54,200 0 55,600 115.400 398,000 402.500 200,000 236.000 83,792 67,915 Required: la. For both companies compute the (a) current ratio. (b) acid-test ratio, ( accounts (including notes) receivable turnover. (d) inventory urnover, (e) days' sales in inventory, and (days' sales uncollected. (Do not round Intermediate calculations.) Ib. Identify the company you consider to be better short-term credit risk. Complete this question by entering your answers in the tabs below. A Days Salin 1A Current Ratio LA Acid Test Ratio 1A Acct Rec Tum 1A Invent Turnover A Days Sal Uncol Reg 1B th Identify the company you consider to be the better short-term credit risk. Better short-term credit risk < 1A Days Sal Uncol

Answer 1

Current Ratio Company Choose Numerator / Choose Denominato Current Ratio Current assets Current liabilities Current Ratio Barco $ 162,740 & 61,340 = 2165 to 1 kyan $ 239,750 $ 99,300 EL 2.41 to 1 Calculation: Current assets / Cash & Accounts Receivable, net & Current notes receivable & Merchandise Inventory & Prepaid expenses) Barcos Current assets: 22,500 + $ 40,400 + $ 10, 100+ $84,340 + $5,400) Ryan: = $ 162,740 Current assets = ($33,000 + $ 54,400 + $8,000 + $ 136,500 + $ 7,850) $ 239,750 b Acid - Test Ratio Choose Acid - test Company Choose Numerator Denominator Ratio Short Current Current Auid- Test Cash + term it receivables / liabilities = Ratio Tinvestment Barco $22,500 + $0 + $50,500 / $ 61, 340 = 1 1.19 to 1 Kyan $33,000 + $0 $ 62,400 / & 99,300/= 0.96 to1 Calculation: Current receivables = (Accounts Receivable, net t current nates receivable) Barco: Current receivable = ($ 40,400 + $ 10,100) = $50, Soo Kyan: Current receivable = ($54,400 + $ 8,000) = $62,400

(0) Accounts Receivable Turnover Company Choose Numerator Choose Accounts Receivable Denominator =1 Turnover Net Sales Average accounts Accounts Receivable breceivable, net Turnover Barco $ 780,000 2 $ 40,150 19.43 times Ryan $ 898,200 $ 58,300 = 15:41 times Calculation: Average Accounts Receivable net = ( Beginning accounts receivable & Ending accounts receivable + Beginning current notes receivable + Ending current notes receivable) =2) or (Beginning accounts receivable + Beginning current notes receivable + Ending Accounts Receivable + Ending current notes receivable) Barco: Average Accounts Receivable, net =[ $ 29,800 + $40,400 + $0 + $ 10,100) 42) = $ 80,300 + 2 = $ 40,150 Ryan Average Accounts Receivable, net = ($54,200 + & 54,400 + $0+ $8,000) = 2] - $116, 600 2 2 = $ 58,300

ve (d) Inventary turnover Company Choose Numerator / Choose Denomin- Invertory Turnover autor Cost of goods sold / Average Inventory Inventory turnover Barco & 585,100 $ 69,970 = 8.36 times Kyan & 634, Soo $ 125,950 5.04 times Calculations Average Inventory = (Beginning inventory & Ending Inventory = 2 Barco Average Inventory = ($ 55,600 + $ 84,34042 - $ 139,94032 $ 69,970 Ryan Average Inventory = ($ 115,400 + $ 136,500) = 2 = 251,900 -2 - $ 125,950 Donnminestoy Days sales in Inventory Choose non Corupany choose Numerator / Merchandise Cost of Inventory Barco $ 84,340 / $585,100 x 365 = & 634,500 x 365 $ 136,500 kyan Days sales en inventory Days sales in Inventory = goods sold X 365 52.61 days 78.52 days Company Cho Numerator Current receiv- ables, net S So, sob $ 62,400 Days' sales Oncollected Choose Denominator X Days = Il Net sales 1, ! 365 = 1 / $ 700,000 X 365 = $ 898, 200 X 365 = days sales, uncollected Days sales uncollected 23.63 T . RoxLO days 25. 36 days Kyan for above Current are calculated receivables, net ou le r Better short-term credit risk Barco company