Question: help asap! Required information Problem 13-5A (Algo) Comparative ratio analysis LO P3 (The following information applies to the questions displayed below) Summary information from the












Required information Problem 13-5A (Algo) Comparative ratio analysis LO P3 (The following information applies to the questions displayed below) 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 Assets Cash Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total assets Liabilities and Equity Current liabilities Long-term notes payable Connon stock, 55 par value Retained earnings Total liabilities and equity $ 20,000 40,400 84,940 6,100 350,000 $ 501,440 $ 30,000 53,400 132,500 6,950 305 409 $ 528,250 Data from the current year's incone statement Sales Cost of goods sold Interest expense Income tax expense Net income Basic earnings per share Cash dividends per share Beginning-of-year balance sheet data Accounts receivable, net Merchandise Inventory Total assets Common stock, 35 par value Retained earnings $ 790,000 584,100 8.900 15,185 181,815 5.35 3.81 $ 884,20 636,500 15,000 24,410 208,290 4.82 3.97 5 26,800 57,600 453,000 $ 62,340 34,800 170.000 184,300 $ 501,440 $ 100,300 101,000 216.000 110,950 $ 528,250 $ 52,200 117,400 392,500 216,000 74,164 1707000 132,025 Problem 13-5A (Algo) Part 1 Required: 1o. For both companies compute the (a) current ratio, (b) acid-test ratio. Id accounts receivable turnover (ch inventory turnover (e) days' sales in inventory, and (6 days' sales uncollected. (Do not round intermediate calculations.) 1b. Identify the company you consider to be the better short-term credit risk. CE Problem 13-5A (Algo) Part 1 Required: 1o. For both companies compute the (a) current ratio. (c) acid-test ratio, ( accounts receivable turnover (inventory turnover, (e) days sales in inventory, and (6 days' sales uncollected. (Do not found intermediate calculations.) 1b. Identify the company you consider to be the better short-term credit risk. Complete this question by entering your answers in the tabs below. 1A Current Ratio 1A Acid Test Ratio 1A Acct Rec Turn 1A Invent Turnover 1B short term 1A Days Salin 1A Days Sal Inv Uncol For both companies compute the current ratio. Current Ratio Denominator: Company Numerator: Current Ratio Current ratio to 1 to 1 4 Barco Kyan 1A Acid Test Ratio > Long-term notes payable Common stock, 55 par value Retained earning Total liabilities and equity 84,500 170,000 184, 100 $ 501.440 101,600 Merchandise Inventory 216,000 Total assets 110,950 Common stock, 55 par value $ 528,250 Retained earnings 57,600 458,00 170,000 132.025 117,400 192,500 216.000 74,164 Problem 13-5A (Algo) Part 1 Required: 1o. For both companies compute the (a) current ratio. (b) acid-test ratio. (c) accounts receivable turnover. (d) inventory turnover (c) days sales in inventory, and (days' sales uncollected (Do not round intermediate calculations.) 1b. Identify the company you consider to be the better short-term credit risk Complete this question by entering your answers in the tabs below. 1A Current Ratio 1A Acid Test Ratio 1A Acct Rec Turn 1A Invent Turnover 1A Days Salin 1A Days Sal Iny Uncol 1 short term For both companies compute the add-test ratio. Acid Test Ratio 10) Company Numerator: Denominator: Acid Test Ratio Acid-test ratio to 1 Barco Kyan .. to 1 Long term notes payable Common stock, 55 par value Retained earnings Total liabilities and equity 84,800 170,000 184,300 $ 501.440 101,000 Merchandise inventory 216,eee Total assets 110,950 Common stock, 35 par value $ 520,250 Retained earnings 57,600 450,000 170,000 132,025 117,400 392,500 216,000 74, 16A Problem 13-5A (Algo) Part 1 Required: 1o. For both companies compute the (@) current ratio. (b) acid-test ratio. ( accounts receivable turnover. (d) inventory turnover. (e) days sales in inventory, and (1 days' sales uncollected (Do not round intermediate calculations.) 1b. Identify the company you consider to be the better short-term credit risk Complete this question by entering your answers in the tabs below. 18 short term 1A Current 1A Acid Test 1A Ace Roc 1A Invent 1A Days Sal in 1A Days Sal Ratio Ratio Tur 1A Acct Rec Turn Inv Uncol For both companies compute the accounts (including notes) receivable turnover (c) Company Accounts Receivable Turnover Denominator: Numerator Accounts Receivable Tumover Accounts receivable turnover times Barco times Kyan Long-term notes payable Common stock, 35 par value Retained earnings Total liabilities and equity 54.100 170,000 184,360 $501,440 101,000 Merchandise inventory 216,000 Total assets 110,950 Common stock, $5 par value $ 528,250 Retained earnings 57,600 458,00 170,000 132,025 117,460 392,500 216,000 74,164 Problem 13-5A (Algo) Part 1 Required: 1o. For both companies compute the (a) current ratio, (b) acid-test ratio, ( accounts receivable turnover. (dinventory turnover. (e) days' sales in inventory, and (7 days' sales uncollected (Do not round intermediate calculations.) 15. Identify the company you consider to be the better short-term credit risk Complete this question by entering your answers in the tabs below. 1A Current Ratio 1A Acid Test Ratio 1A Acct Rec Turn IA INvent Turnover IA Days Salin A Days Sal Inv Uncol 18 short term For both companies compute the inventory turnover. (d) Company Inventory Turnover Denominator: Numerator: Inventory Tumover Inventory turnover times Barco 1 Kyan times Long-term notes payable Common stock, 35 par value Retained earnings Total liabilities and equity 84,800 170,000 184,30 $ 501.440 101,000 216,000 110 950 $ 528,250 Merchandise inventory Total assets Common stock, 55 par value Retained earnings 57,60 458,000 170,000 132,025 117,400 392,500 216,000 74,164 Problem 13-5A (Algo) Part 1 Required: 10. For both companies compute the (a) current ratio, (b) acid test ratio. ( accounts receivable turnover. () inventory turnover. (e) days' sales in inventory, and (7 days' sales uncollected (Do not round intermediate calculations.) 1b. Identify the company you consider to be the better short-term credit risk Complete this question by entering your answers in the tabs below. 1B short term 1A Current 1A Adid Test 1A Acct Rec 1A Invent 1A Days Salin 1A Days Sal Ratio Ratio Turn Turnover Inv Uncol For both companies compute the days' sales in inventory le) Days Soles in Inventory Company Numerator: Denominator: Days Days' Sales In Inventory Days' sales in inventory days days Barco Kyan ### * Long-term notes payable Common stock, $5 par value Retained earnings Total liabilities and equity 84,800 170,000 184,300 $501,440 101.000 216,000 110,950 $ 528,250 Merchandise inventory Total assets Common stock, 35 par value Retained earnings 57,60 458,000 170,000 132,025 117,460 392,500 216.000 74,164 Problem 13-5A (Algo) Part 1 Required: 1a. For both companies compute the (a) current ratio. (b) acid-test ratio, id accounts receivable turnover (inventory turnover. (e) days' sales in inventory, and (days' sales uncollected. (Do not round intermediate calculations.) 1b. Identify the company you consider to be the better short-term credit risk. Complete this question by entering your answers in the tabs below. 1A Current Ratio 1A Acid Test Ratio 1A Acct Rec Turn 1A Invent Turnover 1A Days Salin 1A Days Sal Inv 18 short term Uncol For both companies compute the days' sales uncollected. 10 Company Days Sales Uncollected Denominator: Numerator: Days Days' Sales Uncollected Days' sales uncollected days days Barco Kyan 132,025 74,164 $ 501.440 $ 520,250 retained earnings Total Habilities and equity Problem 13-5A (Algo) Part 2 20. For both companies compute the (a) profit margin ratio, (b) total asset turnover (c) return on total assets, and (d) return on equity Assuming that each company's stock can be purchased at $85 per share, compute their (el price earnings ratios and ( dividend yields 2b. Identify which company's stock you would recommend as the better investment. Complete this question by entering your answers in the tabs below. ZA Prof Mar Ratio 2A Ret On Equity 2A Div Yield ZA Tot Asset 2A Ret on Tot Turn Assets 2A Price Earn Ratio Reg 28 For both companies compute the profit margin ratio. (a) Company Profit Margin Ratio Denominator Numerator: - Profit margin ratio Profit margin ratio Barco Kyan 2A Tot Asset Tum > Problem 13-5A (Algo) Part 2 20. For both companies compute the (a) profit margin ratio. (b) total asset turnover. ( return on total assets, and (d) return on equity. Assuming that each company's stock can be purchased at $85 per share, compute their (el price earnings ratios and dividend yields 2b. Identify which company's stock you would recommend as the better investment Complete this question by entering your answers in the tabs below. ZA Prof Mar Ratio 2A Ret On Equity 2A Tot Asset 2A Ret on Tot TUTT Assets 2A Price Earn Ratio 2A Div Yield Req 2B For both companies compute the total asset turnover (b) Company Total Asset Turnover Denominator Numerator: Total Asset Turnover Total asset turnover times times Barco Kyan -- S Total liabilities and equity $501,440 $ 528,250 Retained earnings 132,025 74.164 Problem 13-5A (Algo) Part 2 20. For both companies compute the (a) profit margin ratio. (b) total asset tumover. ( return on total assets, and (dreturn on equity Assuming that each company's stock can be purchased at $85 per share, compute their (eprice-earnings ratios and dividend ylelds 2b. Identify which company's stock you would recommend as the better investment Complete this question by entering your answers in the tabs below. 2A Prof Mar Ratio 2A Tot Asset 2A Reton Tot Turn Assets 2A Ret On Equity 2A Price Earn Ratio ZA Div Yield Req 2B For both companies compute the return on total assets. (c Company Return on Total Assets Denominator Numerator Return on Total Assets Return on total assets % Barco Kyan (2A Tot Asset Turn 2A Ret On Equity > Problem 13-5A (Algo) Part 2 2n. For both companies compute the (a profit margin ratio, (total asset turnover to return on total assets, and (c) return on equity Assuming that each company's stock can be purchased at $85 per share, compute their fe price earnings ratios and (dividend yields 2b. Identity which company's stock you would recommend as the better investment Complete this question by entering your answers in the tabs below. 2A Prof Mar Ratio 2A Tot Asset 2A Ret on Tot Turn Assets Dret on 2A Price Earn Ratio 2A Dly Yield Equity Reg 2B For both companies compute the return on equity. 10) Company Return On Equity Denominato Numerator Return On Equity Return On equity Barco Kyan % (2A Reton Tot Assets 2A Price Earn Ratio > Problem 13-5A (Algo) Part 2 2n. For both companies compute the (a) profit margin ratio. (b) total asset turnover, la return on total assets, and return on equity Assuming that each company's stock can be purchased at $85 per share, compute their (e) price earnings ratios and ( dividend yields 2b. Identify which company's stock you would recommend as the better investment Complete this question by entering your answers in the tabs below. 2A Prof Mar 2A Tot Asset 2A Ret on Tot Turn Assets Ratio 2A Ret On Equity 2A Price Earn Ratio 2A Div Yield Reg 28 Assuming that share and each company's stock can be purchased at $85 per share, compute their price earnings ratios. Company Numerator Price Earnings Ratio Denominator Price Earnings Ratio Price earnings ratio times 1 Barco Kyan times Problem 13-5A (Algo) Part 2 2n. For both companies compute the (a) profit margin ratio. (b) total asset turnover. (return on total assets, and (d) return on equity. Assuming that each company's stock can be purchased at $85 per share, compute their (e price earnings ratios and ( dividend yields. 2b. Identify which company's stock you would recommend as the better investment. Complete this question by entering your answers in the tabs below. 2A Prof Mar Ratio 2A Tot Asset 2A Ret on Tot Turn Assets 2A Ret On Equity 2A Price Earn Ratio 2A ch Yield Reg 28 Assuming that each company's stock can be purchased at sas per share, compute their dividend yields. 0 Dividend Yield Company Numerator Denominator Dividend Yield Dividend yield Barco Kyan
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
