Required information Problem 13-5A Comparative ratio analysis LO A1, 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 Data from the current year's income statement Kyan pany Data from the current year-end balance sheets Assets Cash $780,000 $905, 200 644,500 17,000 24,990 218,710 4.84 Sales $ 19,500 $ 37,000 55,400 8,000 132,500 7,650 304,400 $468,640 $544,950 Cost of goods sold Interest expense Income tax expense Net income Basic earnings per share Cash dividenda per share 585,100 8,100 Accounts receivable, net Current notes receivable (trade) Merchandise inventory Prepaid expenses Plant assets, net 39,400 9,800 84,640 14,992 171,808 5.05 5,300 310,000 3.73 4.00 Total assets Beginning-of-year balance sheet data Accounts receivable, net Current notes receivable (trade) Merchandise inventory Total assets Liabilities and Equity $ 28,800 $ 56,200 $ 69,340 $ 95,300 103,000 226,000 120,650 Current liabilities Long-term notes payable Common stock, $5 par value Retained earnings 61,600 418,000 170,000 113,400 372,500 226,000 82,800 170,000 146,500 Common stock, $5 par value Total liabilities and equity $468,640 $544,950 Retained earnings 101,512 82,740 Problem 13-5 Part 2 2a. For both companies compute the (a) profit margin ratio, (b) total asset turnover, () return on total assets, and (d) return on common stockholders' equity. Assuming that share and each company's stock can be purchased at $100 per share, compute their (e) price- earnings ratios and () dividend yields. (Do not round intermediate calculations. Round your answers to 2 decimal places.) 2h. Identifv which comnanv's stock vnu wnuld rerommend as the hetter invectment Problem 13-5 Part 2 2a. For both companies compute the (a) profit margin ratio, (b) total asset turnover, (g return on total assets, and (d) return on common stockholders' equity. Assuming that share and each company's stock can be purchased at $100 per share, compute their (e) price- earnings ratios and (A dividend yields. (Do not round intermediate calculations. Round your answers to 2 decimal places.) 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 Ret On 2A Pro Marg Ratio 2A Tot Asset 2A Ret on Tot 2A Price Earn Turn Assets Com Stock 2A Div Yield Reg 28 Ratio Equity For both companies compute the profit margin ratio. (a) Profit Margin Ratio CompanyChoose Numerator: I Choose Denominator: ofit margin ratio %3D Profit margin ratio %3D Barco %3D Kyan ) Telumi on total ass i LOMpany's stock can be purchased at $100 per sham Cumngs Patios and (5 dividend yields. (Do not round intermediate calculations. Round your answers to 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 Pro Marg Ratio 2A Tot Asset Turn 2A Ret on Tot Assets 2A Ret On Com Stock Equity 2A Price Earn 2A Div Yield Req 2B Ratio For both companies compute the total asset turnover (b) Total Asset Turnover Company Choose Numerator: I Choose Denominator: = Total Asset Turnover = Total asset turnover %3D times Barco times %3D Kyan 2A Ret on Tot Assets 2A Pro Marg Ratio Next> 5. earnings Patios and (h dividend ylelds. (Do not round intermediate calculations. Round your an 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 Ret On 2A Pro Marg 2A Tot Asset 2A Rt on Tot 2A Price Earn Ratio Com Stock 2A Div Yield Req 2B Ratio Turn Assets Equity For both companies compute the return on total assets. (c) Return on Total Assets Company Choose Numerator: | Choose Denominator: = Return on Total Assets %3D Return on total assets Barco %3! Kyan 2A Tot Asset Turn 2A Ret On Com Stock Equity > a. For both companies compute the (a) profit margin ratio, (b) total asset turnover, () return on total assets, and (d) return on c cockholders' equity. Assuming that share and each company's stock can be purchased at $100 per share, compute their (e) pri arnings ratios and (6 dividend yields. (Do not round intermediate calculations. Round your answers to 2 decimal places.) b. Identify which company's stock you would recommend as the better investment. Complete this question by entering your answers in the tabs below. 2A Pro Marg Ratio 2A Tot Asset Turn 2A Ret on Tot Assets 2A Pet On Com-stock 2A Price Earn Ratio 2A Div Yield Req 28 Equity For both companies compute the return on common stockholders' equity. (d) Return On Common Stockholders' Equity Return On Common Stockholders' Equity - Return On common stockholders' equity Company Choose Numerator: Choose Denominator Barco %3D Kyan %3D Complete this question by entering your answers in the tabs below. 2A Pro Marg Ratio 2A Tot Asset Turn 2A Ret on Tot Assets 2A Ret On Com Stock Equity 2A Price Earn 2A Div Yield Req 28 Ratio Assuming that share and each company's stock can be purchased at $100 per share, compute their price-ea (e) Price-Earnings Ratio Company Choose Numerator: Choose Denominator: = Price-Earnings Ratio = Price-earnings ratio Barco times %3D Kyan times 2A Ret On Com Stock Equity 2A Div Yield > 5. %3D Complete this question by entering your answers in the tabs below. 2A Pro Marg Ratio 2A Tot Asset Turn 2A Ret On Com Stock Equity 2A Ret on Tot 2A Price Earn Assets Ratio 2A Div Yield Req 2B Assuming that share and each company's stock can be purchased at $100 per share, compute thein (1) Dividend Yield Company Choose Numerator: 7 Choose Denominator: Dividend Yield %3D Dividend yield Barco %3D Kyan