Knowee
Questions
Features
Study Tools

[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 CompanyData from the current year-end balance sheets     Data from the current year’s income statement    Assets     Sales $ 780,000 $ 907,200Cash $ 19,500 $ 33,000 Cost of goods sold 590,100 630,500Accounts receivable, net 36,400 59,400 Interest expense 8,000 13,000Merchandise inventory 84,240 130,500 Income tax expense 14,992 25,045Prepaid expenses 5,600 7,500 Net income 166,908 238,655Plant assets, net 320,000 305,400 Basic earnings per share 4.17 5.79Total assets $ 465,740 $ 535,800 Cash dividends per share 3.74 4.03Liabilities and Equity     Beginning-of-year balance sheet data    Current liabilities $ 71,340 $ 103,300 Accounts receivable, net $ 30,800 $ 55,200Long-term notes payable 78,800 105,000 Merchandise inventory 63,600 105,400Common stock, $5 par value 200,000 206,000 Total assets 448,000 392,500Retained earnings 115,600 121,500 Common stock, $5 par value 200,000 206,000Total liabilities and equity $ 465,740 $ 535,800 Retained earnings 98,292 48,8812a. 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 $90 per share, compute their (e) price-earnings ratios and (f) dividend yields.2b. Identify which company’s stock you would recommend as the better investment.

Question

[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 CompanyData from the current year-end balance sheets     Data from the current year’s income statement    Assets     Sales 780,000 780,000 907,200Cash 19,500 19,500 33,000 Cost of goods sold 590,100 630,500Accounts receivable, net 36,400 59,400 Interest expense 8,000 13,000Merchandise inventory 84,240 130,500 Income tax expense 14,992 25,045Prepaid expenses 5,600 7,500 Net income 166,908 238,655Plant assets, net 320,000 305,400 Basic earnings per share 4.17 5.79Total assets 465,740 465,740 535,800 Cash dividends per share 3.74 4.03Liabilities and Equity     Beginning-of-year balance sheet data    Current liabilities 71,340 71,340 103,300 Accounts receivable, net 30,800 30,800 55,200Long-term notes payable 78,800 105,000 Merchandise inventory 63,600 105,400Common stock, 5parvalue200,000206,000Totalassets448,000392,500Retainedearnings115,600121,500Commonstock,5 par value 200,000 206,000 Total assets 448,000 392,500Retained earnings 115,600 121,500 Common stock, 5 par value 200,000 206,000Total liabilities and equity 465,740 465,740 535,800 Retained earnings 98,292 48,8812a. 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 $90 per share, compute their (e) price-earnings ratios and (f) dividend yields.2b. Identify which company’s stock you would recommend as the better investment.

...expand
🧐 Not the exact question you are looking for?Go ask a question

Solution

2a. To compute the required ratios for both companies, we will use the following formulas:

(a) Profit Margin Ratio = (Net Income / Sales) * 100 (b) Total Asset Turnover = Sales / Total Assets (c) Return on Total Assets (ROA) = (Net Income / Total Assets) * 100 (d) Return on Equity (ROE) = (Net Income / Average Equity) * 100 (e) Price-Earnings Ratio (P/E) = Market Price per Share / Earnings per Share (f) Dividend Yield = (Cash Dividends per Share / Market Price per Share) * 100

Let's calculate each ratio step by step for both Barco Company and Kyan Company.

Barco Company

(a) Profit Margin Ratio: Profit Margin Ratio=($166,908$780,000)×100=21.4% \text{Profit Margin Ratio} = \left( \frac{\$166,908}{\$780,000} \right) \times 100 = 21.4\%

(b) Total Asset Turnover: Total Asset Turnover=$780,000$465,740=1.675 \text{Total Asset Turnover} = \frac{\$780,000}{\$465,740} = 1.675

(c) Return on Total Assets (ROA): ROA=($166,908$465,740)×100=35.8% \text{ROA} = \left( \frac{\$166,908}{\$465,740} \right) \times 100 = 35.8\%

(d) Return on Equity (ROE): First, calculate the average equity: Average Equity=($200,000+$115,600)+($200,000+$98,292)2=$306,946 \text{Average Equity} = \frac{(\$200,000 + \$115,600) + (\$200,000 + \$98,292)}{2} = \$306,946 ROE=($166,908$306,946)×100=54.4% \text{ROE} = \left( \frac{\$166,908}{\$306,946} \right) \times 100 = 54.4\%

(e) Price-Earnings Ratio (P/E): P/E Ratio=$90$4.17=21.6 \text{P/E Ratio} = \frac{\$90}{\$4.17} = 21.6

(f) Dividend Yield: Dividend Yield=($3.74$90)×100=4.2% \text{Dividend Yield} = \left( \frac{\$3.74}{\$90} \right) \times 100 = 4.2\%

Kyan Company

(a) Profit Margin Ratio: Profit Margin Ratio=($238,655$907,200)×100=26.3% \text{Profit Margin Ratio} = \left( \frac{\$238,655}{\$907,200} \right) \times 100 = 26.3\%

(b) Total Asset Turnover: Total Asset Turnover=$907,200$535,800=1.693 \text{Total Asset Turnover} = \frac{\$907,200}{\$535,800} = 1.693

(c) Return on Total Assets (ROA): ROA=($238,655$535,800)×100=44.5% \text{ROA} = \left( \frac{\$238,655}{\$535,800} \right) \times 100 = 44.5\%

(d) Return on Equity (ROE): First, calculate the average equity: Average Equity=($206,000+$121,500)+($206,000+$48,881)2=$291,191 \text{Average Equity} = \frac{(\$206,000 + \$121,500) + (\$206,000 + \$48,881)}{2} = \$291,191 ROE=($238,655$291,191)×100=82.0% \text{ROE} = \left( \frac{\$238,655}{\$291,191} \right) \times 100 = 82.0\%

(e) Price-Earnings Ratio (P/E): P/E Ratio=$90$5.79=15.5 \text{P/E Ratio} = \frac{\$90}{\$5.79} = 15.5

(f) Dividend Yield: Dividend Yield=($4.03$90)×100=4.5% \text{Dividend Yield} = \left( \frac{\$4.03}{\$90} \right) \times 100 = 4.5\%

2b. Recommendation: Based on the calculated ratios, Kyan Company shows a higher return on equity (82.0% vs. 54.4%) and a higher return on total assets (44.5% vs. 35.8%). Additionally, Kyan Company has a lower price-earnings ratio (15.5 vs. 21.6), indicating that its stock may be undervalued compared to Barco Company. The dividend yield is also slightly higher for Kyan Company (4.5% vs. 4.2%).

Therefore, I would recommend Kyan Company as the better investment.

This problem has been solved

Similar Questions

The following tables provide information regarding two companies. Metrics Company A (in $ million) Company B (in $ million)Sales revenue 4 25Cost of goods sold 0.9 3.2Operating working capital 0.25 4 Company A (all figures in $ million)Fixed assets2.5Owners equity3Cash2.25Short-term debt0.5Accounts receivable0.5Long-term debt1.5Inventory0.75Accounts payable1 Company B (all figures in $ million)Fixed assets11Owners equity13Cash4Short-term debt2.5Accounts receivable2Long-term debt3.5Inventory3Accounts payable1 Assume 360 operating days in a year.Question 2/2MandatoryInterpreting Activity RatiosDetermine which of the following statement is true? (Note: More than one option may be correct.)For company A, accounts receivable of $0.5 million represents 45 days of sales revenue outstanding Both the company pay their supplier 300 days after deliveryCompany B’s days inventory outstanding (DIO) is greater than company A’s DIOFor company B, accounts receivable of $2 million represents 45 days of sales outstanding

Following are comparative balance sheets spanning 3 years. Express the balance sheets in common-size percentages for each year.Comparative Balance SheetsFor Years Ended December 31  Current Year 1 Year Ago 2 Years AgoCash $ 640 $ 525 $ 552Accounts receivable, net 960 1,200 1,104Merchandise inventory 2,000 1,650 1,242Plant assets, net 4,400 4,125 4,002Total assets $ 8,000 $ 7,500 $ 6,900Accounts payable $ 1,600 $ 825 $ 966Long-term notes payable 1,760 1,875 1,518Common stock 3,440 3,675 3,450Retained earnings 1,200 1,125 966Total liabilities and equity $ 8,000 $ 7,500 $ 6,900

Link Between Financial StatementsThe following information is available for a company.  Income Statement (In ₹ million)Sales revenue2Operating expenses0.45 Operating profit 1.55 Interest expenses 0.22Taxes 0.28Net profit? Cash Flow Statement (In ₹ million)Cash in the beginning 0.75 Cash generated during the year?Cash at the end 1.52   Balance SheetAssetAmount (in ₹ million)Liability and equityAmount (in ₹ million)Fixed assets6Share capital5Cash? Profit for the year?Inventory2.53Owner’s equity?    Long-term debt4 Total assets?Total liabilities and equity ? What is the total assets and owner’s equity? Total assets: ₹ 10.05 million; owner’s equity: ₹ 6.05 millionTotal assets: ₹ 15.52 million; owner’s equity: ₹ 6.52 millionTotal assets: ₹ 9.05 million; owner’s equity: ₹ 5.05 million

The statement below is likely from which of the following business (type of business and form of organisation):Balance Sheet As of 30th June 2021Assets  Cash$50,000 Accounts Receivables90,000  Land270,000  Buildings (net)220,700Total assets$630,700Liabilities  Accounts payable280,000Net Assets$350,700Shareholders' Equity Share capital$225,000Retained earnings  125,700Total stockholders' equity$350,700Question 2Answera.a merchandising partnershipb.a merchandising companyc.a merchandising sole-proprietorshipd.a service sole-proprietorshipe.a service company

The following financial statement data are available for a company:Metric $ thousandsOperating income 3,390Net income 2,210Operating assets 3,850Change in cash and cash equivalents 1,010Change in cash from operating activities 1,750Free cash flow to the firm 2,240The company’s cash-to-income ratio is closest to:A.0.79.B.0.66.C.0.52.

1/3

Upgrade your grade with Knowee

Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.