Problem 17-5A Comparative ratio analysis LO P3
Skip to 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 Company |
|||||||||||
Data from the current year-end balance sheets | Data from the current year’s income statement | |||||||||||||
Assets | Sales | $ | 770,000 | $ | 897,200 | |||||||||
Cash | $ | 19,000 | $ | 30,000 | Cost of goods sold | 594,100 | 642,500 | |||||||
34,400 | 57,400 | Interest expense | 8,100 | 18,000 | ||||||||||
Merchandise inventory | 84,740 | 140,500 | Income tax expense | 14,800 | 24,769 | |||||||||
Prepaid expenses | 5,900 | 7,150 | Net income | 153,000 | 211,931 | |||||||||
Plant assets, net | 310,000 | 305,400 | Basic earnings per share | 4.50 | 5.41 | |||||||||
Total assets | $ | 454,040 | $ | 540,450 | Cash dividends per share | 3.82 | 3.93 | |||||||
Liabilities and Equity | Beginning-of-year |
|||||||||||||
Current liabilities | $ | 67,340 | $ | 93,300 | Accounts receivable, net | $ | 31,800 | $ | 56,200 | |||||
Long-term notes payable | 79,800 | 107,000 | Merchandise inventory | 57,600 | 115,400 | |||||||||
Common stock, $5 par value | 170,000 | 196,000 | Total assets | 438,000 | 362,500 | |||||||||
136,900 | 144,150 | Common stock, $5 par value | 170,000 | 196,000 | ||||||||||
Total liabilities and equity | $ | 454,040 | $ | 540,450 | Retained earnings | 113,780 | 86,275 | |||||||
rev: 11_27_2019_QC_CS-192168
Problem 17-5A Part 2
2a. For both companies compute the (a) profit margin ratio, (b) total asset turnover, (c) return on total assets, and (d) return on common
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 Turn
- 2A Ret on Tot Assets
- 2A Ret On Com Stock
- 2A Price Earn Ratio
- 2A Div Yield
- Req 2B
Assuming that each company’s stock can be purchased at $80 per share, compute their dividend yields.
|
|
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps with 1 images
- Required Information Problem 12-6B Use ratios to analyze risk and profitability (LO12-3, 12-4) (The following information applies to the questions displayed below.] Income statement and balance sheet data for The Athletic Attic are provided below. THE ATHLETIC ATTIC Incone Statements For the years ended December 31 2022 $12, see, eee 8, 150,eee 4,350,000 2021 Net sales Cost of goods sold Gross profit Expenses: Operating expenses bepreciation expense Interest expense Income tax expense Total expenses $11,0se,000 6,900,000 4,150,000 1,750,eee 200,000 55,000 58e,e00 2,585,000 $ 1,765,000 1,700,000 200, e00 55,000 500,000 2,455,e00 $ 1,695,000 Net incone THE ATHLETIC ATTIC Balance Sheets December 31 2022 2021 2020 Assets Current assets: Cash Accounts receivable Inventory Supplics Long term assets: Equipnent Less: Accumulated depreciation $ 240,000 1,005,000 1,740,000 145,800 170,000 755,000 1,370,000 115,000 234,000 775,00e 1,048,eee 90,000 1,700,000 (75e,00e) 1,700,000 (S5e,000)…arrow_forwardProblem 19-4 Per-Share Ratios (LO3, CFA6) You are given the following information for Smashville, Inc. Cost of goods sold: $249,000 Investment income: $2,900 Net sales: $394,000 Operating expense: $92,000 Interest expense: $7,400 Dividends: $13,000 Tax rate: 21 % Current liabilities: $22,000 Cash: $21,000 Long-term debt: $9,000 Other assets: $37,000 Fixed assets: $139,000 Other liabilities: $5,000 Investments: $13,000 Operating assets: $49,000 During the year, Smashville, Inc., had 17,000 shares of stock outstanding and depreciation expense of $15,000. Calculate the book value per share, earnings per share, and cash flow per share. (Do not round intermediate calculations. Round your answers to 2 decimal places.)arrow_forwardQuestion 13 The extract disclosed below relates to JohNicho Limited for the year ended December 31, 2021 JohNicho Limited Statement of Comprehensive Income for the year ended 31st December: Net Sales Cost of goods sold SG&A Other costs Operating Income (EBIT) Interest Extraordinary income EBT Taxes Net Income Non-current assets Property, Plant & Equipment Motor vehicles Furniture Total non-current assets Current assets Trade Receivables Other Current Assets Inventories Total Current Assets Total assets Current liabilities Accounts payable Other current liabilities Total Current Liabilities JohLex Limited Statement of Financial Position as at 31st December: 2020 GHC Long-term Debt Debenture Total non-current liabilities 10 Shareholders' equity Total Liabilities and Equity GHC 6,386 18,472 6,759 8,461 25,265 19,811 20,753 Required to calculate: (a) Inventory turnover period (in days) (b) Receivable collection period (in days) (c) Payable collection period (in days) (d) Working capital…arrow_forward
- sanjuarrow_forward1:27 AA HWCH 24 Fee revenue Divisional Income Statements and Return on Investment Analysis E.F. Lynch Company is a diversified investment company with three operating divisions organized as investment centers. Condensed data taken from the records of the three divisions for the year ended June 30, 20Y8, are as follows: Operating expenses Invested assets Fee revenue Operating expenses Income from operations v2.cengagenow.com Division Mutual Fund Division Electronic Brokerage Division Investment Banking Division Mutual Fund Division The management of E.F. Lynch Company is evaluating each division as a basis for planning a future expansion of operations. Required: Check My Work $1,260,000 680,400 4,600,000 1. Prepare condensed divisional income statements for the three divisions, assuming that there were no service department cost allocations. E.F. Lynch Company Divisional Income Statements For the Year Ended June 30, 20Y8 Assignment Score: 0.0% く Electronic Brokerage Division $1,300,000…arrow_forwardQuestion 1 The following are financial statements of Crane Company. Crane CompanyIncome StatementFor the Year Ended December 31, 2022 Net sales $2,192,500 Cost of goods sold 1,010,500 Selling and administrative expenses 900,500 Interest expense 78,000 Income tax expense 62,500 Net income $ 141,000 Crane CompanyBalance SheetDecember 31, 2022 Assets Current assets Cash $ 55,100 Debt investments 89,000 Accounts receivable (net) 168,400 Inventory 236,500 Total current assets 549,000 Plant assets (net) 572,500 Total assets $ 1,121,500 Liabilities and Stockholders’ Equity Current liabilities Accounts payable $ 152,000 Income taxes payable 31,000 Total current liabilities 183,000 Bonds payable 220,740 Total liabilities 403,740 Stockholders’ equity Common stock 345,000 Retained earnings 372,760…arrow_forward
- Vertical analysis Two income statements for Cornea Company follow: Cornea Company Income Statements For the Years Ended December 31 20Υ9 20Y8 Fees earned $1,640,000 $1,300,000 Expenses (869,200) (715,000) Net income $770,800 $585,000 Required: a. Prepare a vertical analysis of Cornea Company's income statements. Cornea Company Income Statements For the Years Ended December 31 20Y9 20Y8 Amount Percent Amount Percent Fees earned $1,640,000 % $1,300,000 % Expenses (869,200) % (715,000) Operating income $770,800 % $585,000 % b. Does the vertical analysis indicate a favorable or an unfavorable trend? Favorable varrow_forwardCompany Comparison Tesla GM Ford Toyota Current Ratio 1.24 1.07 1.16 1.04 Total asset 0.77 0.60 0.60 0.59 turnover ratio Debt ratio 0.80 0.81 1.92 4.83 Gross profit 16.55% 10.18% 13.60% 10.01% margin P/E ratio N/A 8.15 N/A 7.81 The company with the best debt ratio, P/E ratio, and total asset turnover ratio is: Select one: O a. GM O b. Ford ○ c. Toyota O d. Teslaarrow_forwardQuestion 71 Using Financial Statements for 2018-2019, net earnings per share of common stock for 2019 is $67.74. TRUE OR FALSE?arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education