FUND OF FIN ACCT W/CONNECT (LL)>CUSTOM
5th Edition
ISBN: 9781259684654
Author: PHILLIPS
Publisher: MCG CUSTOM
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 13, Problem 13.5PA
Interpreting Profitability, Liquidity, Solvency, and P/E Ratios
Coke and Pepsi are well-known international brands. Coca-Cola sells more than $46 billion worth of beverages each year while annual sales of Pepsi products exceed $66 billion. Compare the two companies as a potential investment based on the following ratios:
| Ratio | Coca-Cola | PepsiCo | |
| Gross profit percentage | 60.7% | 53.2% | |
| Net profit margin | 18.4% | 10.2% | |
| EPS | $1.90 | $4.32 | |
| Inventory turnover ratio | 5.3 | 8.2 | |
| 1.13 | 1.24 | ||
| Debt-to-assets | 0.41 | 0.38 | |
| P/E ratio | 20.4 | 19.3 | |
Required:
- 1. Which company appears more profitable? Describe the ratio(s) that you used to reach this decision.
- 2. Which company appears more liquid? Describe the ratio(s) that you used to reach this decision.
- 3. Which company appears more solvent? Describe the ratio(s) that you used to reach this decision.
- 4. Are the conclusions from your analyses in requirements 1–3 consistent with the value of the two companies, as suggested by their P/E ratios? If not, offer one explanation for any apparent inconsistency.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Leverage Ratios
Grammatico Company has just completed its third year of operations. The income statement is as follows:
Sales $ 2,460,000Less: Cost of goods sold 1,410,000Gross profit margin $ 1,050,000Less: Selling and administrative expenses 710,000Operating income $ 340,000Less: Interest expense 140,000Income before taxes $ 200,000Less: Income taxes 68,000Net income $ 132,000Selected information from the balance sheet is as follows:
Current liabilities $1,000,000Long-term liabilities 1,500,000Total liabilities $2,500,000Common stock $4,000,000Retained earnings 750,000Total stockholders' equity $4,750,000Required:
Note: Round answers to two decimal places.
1. Compute the times-interest-earned ratio.fill in the blank 12. Compute the debt ratio.fill in the blank 23. CONCEPTUAL CONNECTION Assume that the lower quartile, median, and upper quartile values for debt and times-interest-earned ratios in Grammatico’s industry are as…
Solvency and Profitability Trend Analysis
Crosby Company has provided the following comparative information:
20Y8
20Y7
20Y6
20Y5
20Y4
Net income
$5,571,720
$3,714,480
$2,772,000
$1,848,000
$1,400,000
Interest expense
1,052,060
891,576
768,600
610,000
500,000
Income tax expense
1,225,572
845,222
640,320
441,600
320,000
Total assets (ending balance)
29,378,491
22,598,839
17,120,333
12,588,480
10,152,000
Total stockholders’ equity (ending balance)
18,706,200
13,134,480
9,420,000
6,648,000
4,800,000
Average total assets
25,988,665
19,859,586
14,854,406
11,370,240
8,676,000
Average total stockholders' equity
15,920,340
11,277,240
8,034,000
5,724,000
4,100,000
You have been asked to evaluate the historical performance of the company over the last five years.
Selected industry ratios have remained relatively steady at the following levels for the last five years:
20Y4–20Y8…
Adenta Ltd (Adenta) assembles telecommunication equipment and sells to wholesalers and retailers. The following ratios relate to the average figures for Adenta’s industry for the year ended 31 December, 2018:
Return on capital employed 20.10% Gross profit margin 32% Net profit (before tax) margin 12.50% Current ratio 1.6:1
Acid-test ratio 0.9:1
Inventory turnover period 46 days Trade receivable collection period 45 days Debt-to-equity ratio 40%
Dividen yield 6% Dividendcover 3 times
Adenta’s financial statements for the year to 31 December, 2018 are set out below:
Statement of Profit or Loss for the year ended 31 December, 2018
Sales
48,500
Cost of…
Chapter 13 Solutions
FUND OF FIN ACCT W/CONNECT (LL)>CUSTOM
Ch. 13 - What is the general goal of trend analysis?Ch. 13 - Prob. 2QCh. 13 - What is ratio analysis? Why is it useful?Ch. 13 - What benchmarks are commonly used for interpreting...Ch. 13 - Prob. 5QCh. 13 - Prob. 6QCh. 13 - Slow Cellars current ratio increased from 1.2 to...Ch. 13 - From last year to this year, Colossal Companys...Ch. 13 - From last year to this year, Berry Bam reported...Ch. 13 - Explain whether the following situations, taken...
Ch. 13 - What are the two essential characteristics of...Ch. 13 - Prob. 12QCh. 13 - Prob. 13QCh. 13 - Prob. 14QCh. 13 - Prob. 15QCh. 13 - Prob. 16QCh. 13 - 1. Which of the following ratios is not used to...Ch. 13 - Prob. 2MCCh. 13 - Prob. 3MCCh. 13 - Analysts use ratios to a. Compare different...Ch. 13 - Which of the following ratios incorporates stock...Ch. 13 - Prob. 6MCCh. 13 - Prob. 7MCCh. 13 - A bank is least likely to use which of the...Ch. 13 - Prob. 9MCCh. 13 - (Supplement 13A) Which of the following items is...Ch. 13 - Calculations for Horizontal Analyses Using the...Ch. 13 - Calculations for Vertical Analyses Refer to M13-1....Ch. 13 - Interpreting Horizontal Analyses Refer to the...Ch. 13 - Interpreting Vertical Analyses Refer to the...Ch. 13 - Prob. 13.5MECh. 13 - Prob. 13.6MECh. 13 - Prob. 13.7MECh. 13 - Analyzing the Inventory Turnover Ratio A...Ch. 13 - Inferring Financial Information Using the Current...Ch. 13 - Prob. 13.10MECh. 13 - Identifying Relevant Ratios Identify the ratio...Ch. 13 - Prob. 13.12MECh. 13 - Analyzing the Impact of Accounting Alternatives...Ch. 13 - Describing the Effect of Accounting Decisions on...Ch. 13 - Prob. 13.1ECh. 13 - Prob. 13.2ECh. 13 - Prob. 13.3ECh. 13 - Computing Profitability Ratios Use the information...Ch. 13 - Prob. 13.5ECh. 13 - Matching Each Ratio with Its Computational Formula...Ch. 13 - Computing and Interpreting Selected Liquidity...Ch. 13 - Prob. 13.8ECh. 13 - Prob. 13.9ECh. 13 - Prob. 13.10ECh. 13 - Prob. 13.11ECh. 13 - Prob. 13.12ECh. 13 - Prob. 13.13ECh. 13 - Prob. 13.14ECh. 13 - Analyzing the Impact of Alternative Inventory...Ch. 13 - Prob. 13.1CPCh. 13 - Analyzing Comparative Financial Statements Using...Ch. 13 - Prob. 13.3CPCh. 13 - Prob. 13.4CPCh. 13 - Prob. 13.5CPCh. 13 - Prob. 13.6CPCh. 13 - Prob. 13.7CPCh. 13 - Prob. 13.1PACh. 13 - Analyzing Comparative Financial Statements Using...Ch. 13 - Prob. 13.3PACh. 13 - Prob. 13.4PACh. 13 - Interpreting Profitability, Liquidity, Solvency,...Ch. 13 - Using Ratios to Compare Loan Requests from Two...Ch. 13 - Prob. 13.7PACh. 13 - Prob. 13.1PBCh. 13 - Prob. 13.2PBCh. 13 - Prob. 13.3PBCh. 13 - Prob. 13.4PBCh. 13 - Interpreting Profitability, Liquidity, Solvency,...Ch. 13 - Using Ratios to Compare Loan Requests from Two...Ch. 13 - Prob. 13.7PBCh. 13 - Prob. 13.1SDCCh. 13 - Prob. 13.2SDCCh. 13 - Prob. 13.5SDCCh. 13 - Prob. 13.6SDCCh. 13 - Prob. 13.7SDCCh. 13 - Prob. 13.1CC
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Profit Margin, Investment Turnover, and ROI Snodgrass Company has income from operations of $232,800, invested assets of $970,000, and sales of $3,880,000. Use the DuPont formula to compute the return on investment and show (a) the profit margin, (b) the investment turnover, and (c) the return on investment. Round your answers to one decimal place. a. Profit margin b. Investment turnover c. Return on investment %arrow_forwardEfficiency Ratio: Lambda Corporation has current liabilities of $450,000, a quick ratio of 1.8, inventory turnover of 5.0, and a current ratio of 3.5. What is the cost of goods sold for Lambda Corporation?arrow_forwardThe most recent financial statements for Mandy Company are shown here: Income Statement Balance Sheet Sales $ 16,400 Current assets $ 11,200 Debt $ 13,600 Costs 11,200 Fixed assets 24,300 Equity 21,900 Taxable income $ 5,200 Total $ 35,500 Total $ 35,500 Taxes (21%) 1,092 Net income $ 4,108 Assets and costs are proportional to sales. Debt and equity are not. The company maintains a constant 30 percent dividend payout ratio. What is the sustainable growth rate?arrow_forward
- The most recent financial statements for Bello Co. are shown here: Income Statement Balance Sheet Sales $ 19,400 Current assets $ 11,800 Debt $ 16,000 Costs 13,200 Fixed assets 28,350 Equity 24,150 Taxable income $ 6,200 Total $ 40,150 Total $ 40,150 Taxes (22%) 1,364 Net income $ 4,836 Assets and costs are proportional to sales. Debt and equity are not. The company maintains a constant 55 percent dividend payout ratio. What is the sustainable growth rate? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)arrow_forwardThe most recent financial statements for Mandy Company are shown here: Income Statement Balance Sheet Sales $ 19,200 Current assets $ 11,760 Debt $ 15,880 Costs 13,050 Fixed assets 27,450 Equity 23,330 Taxable income $ 6,150 Total $ 39,210 Total $ 39,210 Taxes (24%) 1,476 Net income $ 4,674 Assets and costs are proportional to sales. Debt and equity are not. The company maintains a constant 45 percent dividend payout ratio. What is the internal growth rate? (Do not round intermediate calculations and enter your answer as a percent rounded 2 decimal places, e.g., 32.16.)arrow_forwardProfitability ratios Your boss has asked you to calculate the profitability ratios of Triptych Food Corp. and make comments on its second-year performance as compared with its first-year performance. The following shows Triptych Food Corp.’s income statement for the last two years. The company had assets of $7,050 million in the first year and $11,278 million in the second year. Common equity was equal to $3,750 million in the first year, and the company distributed 100% of its earnings out as dividends during the first and the second years. In addition, the firm did not issue new stock during either year. Triptych Food Corp. Income Statement For the Year Ending on December 31 (Millions of dollars) Year 2 Year 1 Net Sales 3,810 3,000 Operating costs except depreciation and amortization 1,365 1,268 Depreciation and amortization 191 120 Total Operating Costs 1,556 1,388 Operating Income (or EBIT) 2,254 1,612 Less: Interest 304 169 Earnings before…arrow_forward
- (DuPont analysis) Dearborn Supplies has total sales of $199 million, assets of $98 million, a return on equity of 33 percent, and a net profit margin of 7.9 percent. What is the firm's debt ratio? The company's debt ratio is nothing%. (Round to one decimal place.)arrow_forwardThe most recent financial statements for Bello Co. are shown here: Income Statement Balance Sheet Sales $ 18,900 Current assets $ 11,700 Debt $ 15,700 Costs 12,800 Fixed assets 26,500 Equity 22,500 Taxable income $ 6,100 Total $ 38,200 Total $ 38,200 Taxes (21%) 1,281 Net income $ 4,819 Assets and costs are proportional to sales. Debt and equity are not. The company maintains a constant 30 percent dividend payout ratio. What is the sustainable growth rate?arrow_forwardKeller Cosmetics maintains an operating profit margin of 9.00% and a sales-to-assets ratio of 3.90. It has assets of $700,000 and equity of $500,000. Assume that interest payments are $50,000 and the tax rate is 30%. a. What is the return on assets? (Enter your answer as a percent rounded to 2 decimal places.) b. What is the return on equity? (Enter your answer as a percent rounded to 2 decimal places.) Sara Togas sells all its output to Federal Stores. The following table shows selected financial data, in millions, for the two firms: Sales Interest Payment Net Income Assets at Start of Year Federal Stores $117 $21 $27 $67 Sara Togas 37 18 21 28.5 Assume tax rate is 35%. a. Calculate the sales-to-assets ratio, the operating profit margin, and the return on assets for the two firms. (Do not round intermediate calculations. Round the sales-to-assets ratio answers to 2 decimal places. Enter the operating profit margin and return on assets answers as a percent rounded to 2 decimal…arrow_forward
- Estimating the Weighted Average Cost of Capital Kellogg Company manufactures cereal and other convenience food under its many well-known brands such as Kellogg’s®, Keebler®, and Cheez-It®. The company, with over $13.5 billion in annual sales worldwide, partially finances its operation through the issuance of debt. At the beginning of its 2018 fiscal year, it had $8.25 billion in total debt. At the end of fiscal year 2018, its total debt had increased to $8.72 billion. Its fiscal 2018 interest expense was $287 million, and its assumed statutory tax rate was 21%. Kellogg Company has an estimated market beta of 0.85. Assume that the expected risk-free rate is 2.1% and the expected market premium is 5%. Kellogg’s stock closed at $57.01 on December 31, 2018. On that same date, the company had 420,666,780 shares issued, of which 76,801,314 shares were in treasury. a. What is Kellogg’s total market capitalization as of December 31, 2018? Enter answer in billions, rounding to one decimal…arrow_forward[EXCEL] Efficiency ratio: Bummel and Strand Corp. has a gross profit margin of 33.7 percent, sales of $47,112,365, and inventory of $14,595,435. What is its inventory turnover ratio?arrow_forwardPro forma income statement The marketing department of Metroline Manufacturing estimates that its sales next year will be $1.68 million. Interest expense is expected to remain unchanged at $35,000,and the firm plans to pay $74,000 in cash dividends. Metroline Manufacturing's income statement for the previous year is given along with a breakdown of the firm's cost of goods sold and operating expenses into their fixed and variable components. a. Use the percent-of-sales method to prepare a pro forma income statement for next year. b. Use fixed and variable cost data to develop a pro forma income statement for next year. c. Compare and contrast the statements developed in parts a. and b. Which statement probably provides the better estimate of income? Explain why.arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT
Profitability index; Author: The Finance Storyteller;https://www.youtube.com/watch?v=Md5ocNqKHq8;License: Standard Youtube License