Accounting: What the Numbers Mean
11th Edition
ISBN: 9781259535314
Author: David Marshall, Wayne William McManus, Daniel Viele
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 11, Problem 11.14P
Problem 11.14
Ratio analysis-comprehensive problem, 2014 data This problem is based on the 2014 annual report of Campbell Soup Company in the appendix.
Required:
- Compute the following profitability measures for the year ended August 3, 2014:
Return on investment , based on net earnings (perform a DuPont analysis).- Return on equity7, based on net earnings and total equity.
- Price/earnings ratio. Use $41.96 as the year-end market price.
- Dividend yield.
- Dividend payout ratio.
- Compute the following liquidity measures at August 3, 2014:
Working capital .Current ratio .- Acid-test ratio.
- Compute the following activity measures for the year ended August 3, 2014:
- Number of days" sales in accounts receivable, based on a 365-day year.
- Number of days’ sales in inventory, based on a 365-day year.
- Accounts receivable turnover.
- Inventory turnover.
- Turnover of net property, plant, and equipment.
- Compute the following financial leverage measures at August 3, 2014:
- Debt ratio.
- Debt/equity ratio.
- Compute the following physical measures of Campbell’s profitability at August 3, 2014:
- Net sales per employee.
- Operating income per employee. (Note: In a page not reproduced in the appendix, Campbell’s 2014 annual report disclosed that on August 3, 2014, the company had approximately 19,400 employees.)
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Calculate profitability measures The following information was available for the year ended December 31, 2016:Sales $ 400,000Net income 60,000Average total assets 1,000,000Average total stockholders' equity 600,000Dividends per share 2.40Earnings per share 6.00Market price per share at year-end 96.00Required:Calculate margin, turnover, and ROI for the year ended December 31, 2016.Calculate ROE for the year ended December 31, 2016.Calculate the price/earnings ratio for 2016.Calculate the dividend payout ratio for 2016.Calculate the dividend yield for 2016.
GIVE THE COMPARATIVE INCOME STATEMENT VERTICAL ANALYSIS FROM THE FOLLOWING INCOME STATEMENT BELOW
JOLLIBEE INCOME STATEMENT
ITEM
2016
2017
2018
2019
2020
Sales/Revenue
113.81B
133.61B
161.17B
179.63B
129.31B
Sales Growth
-
17.40%
20.62%
11.45%
-28.01%
Cost of Goods Sold (COGS) incl. D&A
-
-
132.96B
150.88B
115.39B
COGS Growth
-
-
-
13.47%
-23.52%
COGS excluding D&A
89.27B
105.39B
121.08B
137.38B
100.82B
Depreciation & Amortization Expense
4B
4.75B
11.89B
13.5B
14.57B
Depreciation
3.93B
4.66B
11.73B
13.34B
14.32B
Amortization of Intangibles
68.99M
78.95M
151.82M
145.42M
245.23M
Gross Income
20.54B
23.48B
28.21B
28.75B
13.92B
Gross Income Growth
-
14.30%
20.12%
1.93%
-51.57%
Gross Profit Margin
-
-
-
-
10.77%
SG&A Expense
-
-
17.64B
20.21B
20.42B
SGA Growth
-
-
-
14.57%
1.02%…
GIVE THE COMPARATIVE INCOME STATEMENT HORIZONTAL ANALYSIS FROM THE FOLLOWING INCOME STATEMENT BELOW
JOLLIBEE INCOME STATEMENT
ITEM
2016
2017
2018
2019
2020
Sales/Revenue
113.81B
133.61B
161.17B
179.63B
129.31B
Sales Growth
-
17.40%
20.62%
11.45%
-28.01%
Cost of Goods Sold (COGS) incl. D&A
-
-
132.96B
150.88B
115.39B
COGS Growth
-
-
-
13.47%
-23.52%
COGS excluding D&A
89.27B
105.39B
121.08B
137.38B
100.82B
Depreciation & Amortization Expense
4B
4.75B
11.89B
13.5B
14.57B
Depreciation
3.93B
4.66B
11.73B
13.34B
14.32B
Amortization of Intangibles
68.99M
78.95M
151.82M
145.42M
245.23M
Gross Income
20.54B
23.48B
28.21B
28.75B
13.92B
Gross Income Growth
-
14.30%
20.12%
1.93%
-51.57%
Gross Profit Margin
-
-
-
-
10.77%
SG&A Expense
-
-
17.64B
20.21B
20.42B
SGA Growth
-
-
-
14.57%
1.02%…
Chapter 11 Solutions
Accounting: What the Numbers Mean
Ch. 11 - Prob. 11.1MECh. 11 - Calculate activity measures The following...Ch. 11 - Prob. 11.3MECh. 11 - Prob. 11.4MECh. 11 - Prob. 11.5ECh. 11 - Exercise 11.6 Obtain an annual report and discuss...Ch. 11 - Exercise 11.7 Effect of transactions on various...Ch. 11 - Prob. 11.8ECh. 11 - Prob. 11.9PCh. 11 - Problem 11.10 LQ 9 Prepare a common size balance...
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
- Ratio Analysis Consider the following information taken from the stockholders equity section: How do you interpret the companys payout and profitability performance? Required: 1. Calculate the following for 2020. (Note. Round answers to two decimal places.) 2. CONCEPTUAL CONNECTION Assume 2019 ratios were: and the current year industry averages are: How do you interpret the companys payout and profitability performance?arrow_forward5. Profitability ratios Profitability ratios help in the analysis of the combined impact of liquidity ratios, asset management ratios, and debt management ratios on the operating performance of a firm. Your boss has asked you to calculate the profitability ratios of Diusitech Inc. and make comments on its second-year performance as compared with its first-year performance. The following shows Diusitech Inc.'s income statement for the last two years. The company had assets of $4,700 million in the first year and $7,518 million in the second year. Common equity was equal to $2,500 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. Diusitech Inc. Income Statement For the Year Ending on December 31 (Millions of dollars) Year 2 Year 1 2,540 2,000 1,610 1,495 127 80 1,737 803 80 723 181 542 Net Sales Operating costs except depreciation and…arrow_forwardEstimating Share Value Using the ROPI Model The following are forecasts of Abercrombie & Fitch's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of January 29, 2011. Refer to the information in the table to answer the following requirements. Reported Horizon Period (In millions) 2011 2012 2013 2014 2015 Terminal Period Sales $ 3,469 $ 3,989 $ 4,587 $ 5,275 $ 6,066 $ 6,187 NOPAT 152 319 367 422 485 495 NOA 1,032 1,173 1,349 1,551 1,784 1,820 Answer the following requirements assuming a discount rate (WACC) of 10%, a terminal period growth rate of 2%, common shares outstanding of 87.2 million, and net nonoperating obligations (NNO) of $(858) million. (Negative NNO reflects net nonoperating assests such as investments rather than net obligations)(a) Estimate the value of a share of Abercrombie & Fitch common stock using the residual operating income (ROPI) model as of January 29, 2011. Rounding instructions: Round answers to…arrow_forward
- DIRECTION: Compute the following PROFITABILITY RATIOS Gross Margin= Gross Profit/Net Sales Net Profit Margin= Net Profit/ Net Sales Return on Equity= Profit/Shareholder's Equity Return on Asset= Profit/Total Asset TREND ANALYSIS Net Income Growth Rate Total Assets Growth Rate And also compute the percentage beside the columns December 31, December 31, PERCENTAGE 2021 2020 USD USD Assets Current assets Cash and cash equivalents 34,115,412 25,681,845 Short-term financial instruments 71,417,748 80,798,680 Short-term financial assets at amortized cost 2,944,705 2,409,853 Short-term financial assets at fair value through profit or loss 35,624 62,452 Trade receivables 35,585,565 27,065,012 Non-trade receivables 3,930,828 3,150,548 Prepaid expenses 2,042,001 1,980,685 Inventories 36,172,043 28,007,314 Other current assets 4,441,629 3,281,589 Assets held-for-sale - 812,370 Total Current Assets…arrow_forwardFinancial Accounting CMulford: Financial Statement Analysis: 13 Using Return on Assets and Return on Equity to Compare Performance Across Companies Thiokol Corp. and Wyman-Gordon, Inc. In a recent fiscal year, Thiokol Corp. reported sales of $889.5 million and net income of $51.4 million. For the same year, Wyman-Gordon, reported sales of $499.6 million and net income of $25.2 million, about half the income of Thiokol. Both companies are in the same industry, aerospace and defense. Use the data provided below to compare financial performance for the two companies (amounts in millions). Thiokol $ 889.5 $ 51.4 $ 818.3 $ 447.9 Wyman-Gordon $ 499.6 $ 25.2 $ 375.9 $ 109.9 Sales Net income Total assets Shareholders' equity Calculate: Return on assets Return on equity Why is Return on equity so different for the two companies?arrow_forwardQuestion content area top Part 1 (Solving a comprehensive problem) Use the end-of-year stock price data in the popup window, LOADING... , to answer the following questions for the Harris and Pinwheel companies. a. Compute the annual rates of return for each time period and for both firms. b. Calculate both the arithmetic and the geometric mean rates of return for the entire three-year period using your annual rates of return from part a. (Note: you may assume that neither firm pays any dividends.) c. Compute a three-year rate of return spanning the entire period (i.e., using the ending price for period 1 and ending price for period 4). d. Since the rate of return calculated in part c is a three-year rate of return, convert it to an annual rate of return by using the following equation: 1+ Three-Year Rate of Return =1+ 3 e. How is the annual rate of return calculated in part d related to the geometric rate of return? When you are…arrow_forward
- Question content area top Part 1 (Solving a comprehensive problem) Use the end-of-year stock price data in the popup window, LOADING... , to answer the following questions for the Harris and Pinwheel companies. a. Compute the annual rates of return for each time period and for both firms. b. Calculate both the arithmetic and the geometric mean rates of return for the entire three-year period using your annual rates of return from part a. (Note: you may assume that neither firm pays any dividends.) c. Compute a three-year rate of return spanning the entire period (i.e., using the ending price for period 1 and ending price for period 4). d. Since the rate of return calculated in part c is a three-year rate of return, convert it to an annual rate of return by using the following equation: 1+ Three-Year Rate of Return =1+ Annual Rate of Return 3 e. How is the annual rate of return calculated in part d related to the geometric rate of return? When you…arrow_forwardThe _________ is the internal rate of return a firm must earn on its investment in order to maintain the market value of its stock. a. gross profit margin b. IRR c. Cost of Capital d. net profit margin A snapshot from Violet Flowers Ltd.'s financial information reveals the following for years 2018 and 2019: Item 2018 2019 Long Term Debt $4,600,000 $4,900,000 Interest expense $600,500 $870,000 Dividends $400,000 $590,000 Common Stock $1,740,000 $1,815,000 Additional paid-in surplus $4,200,000 $4,500,000 Violet Flowers' FCF for 2019 was: a. $300,000 b. $515,000 c. $785,000 d. $270,000arrow_forwardGIVE THE COMPARATIVE INCOME STATEMENT HORIZONTAL AND VERTICAL ANALYSIS FROM THE FOLLOWING INCOME STATEMENT BELOW JOLLIBEE INCOME STATEMENT ITEM 2016 2017 2018 2019 2020 Sales/Revenue 113.81B 133.61B 161.17B 179.63B 129.31B Sales Growth - 17.40% 20.62% 11.45% -28.01% Cost of Goods Sold (COGS) incl. D&A - - 132.96B 150.88B 115.39B COGS Growth - - - 13.47% -23.52% COGS excluding D&A 89.27B 105.39B 121.08B 137.38B 100.82B Depreciation & Amortization Expense 4B 4.75B 11.89B 13.5B 14.57B Depreciation 3.93B 4.66B 11.73B 13.34B 14.32B Amortization of Intangibles 68.99M 78.95M 151.82M 145.42M 245.23M Gross Income 20.54B 23.48B 28.21B 28.75B 13.92B Gross Income Growth - 14.30% 20.12% 1.93% -51.57% Gross Profit Margin - - - - 10.77% SG&A Expense - - 17.64B 20.21B 20.42B SGA Growth - - -…arrow_forward
- Profitability and Asset Management Ratios You are thinking of investing in Nikki T's, Inc. You have only the following information on the firm at year-end 2015: net income is $250,000, total debt is $2.5 million, and debt ratio is 55 percent. What is Nikki T's ROE for 2015?arrow_forwardComputing and Interpreting Financial Statement Ratios Following are selected ratios of Norfolk Southern for 2018 and 2017. Return on Assets (ROA) Component 2018 2017 Profitability (Net income/Sales) 25.3% 53.2% Productivity (Sales/Average assets) 0.338 0.319 a. Was the company profitable in 2018?Answer b. Was the company more profitable in 2018 or 2017?Answer c. Is the change in productivity a positive or negative development?Answer d. Compute the company’s ROA for 2018 and for 2017. Note: Round answers to one decimal places (example: 10.4%). ROA 2018 Answer 2017 Answer e. From the information provided, which of the following best explains the change in ROA during 2018? Answerarrow_forwardTHE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF INCOME (In millions except per share data) Year Ended December 31, Net Operating Revenues Cost of goods sold Gross Profit Selling, general and administrative expenses 2019 2018 2017 37,266 S 34,300 S 36,212 14,619 13,067 13,721 22,647 21,233 22,491 12,103 11,002 12,834 458 1,079 1,902 Other operating charges 10,086 9,152 7,755 Operating Income Interest income 563 689 679 946 950 853 Interest expense Equity income (loss)-net 1,049 1,008 1,072 34 (1,674) (1,763) Other income (loss)- net 10,786 8,225 6,890 Income Before Income Taxes 1,801 1,749 5,607 Income taxes 8,985 6,476 1,283 Consolidated Net Income 42 35 Less: Net income (loss) attributable to noncontrolling interests Net Income Attributable to Shareowners of The Coca-Cola Company 65 8,920 S 6,434 S 1,248 2.09 S 1.51 $ 0.29 Basic Net Income Per Share 2.07 S 1.50 $ 0.29 Diluted Net Income Per Shard 4,276 4,259 4,272 Average Shares Outstanding- Basic 38 40 52 Effect of…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Financial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage Learning
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningSurvey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningFundamentals Of Financial Management, Concise Edi...FinanceISBN:9781337902571Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning
Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
Fundamentals Of Financial Management, Concise Edi...
Finance
ISBN:9781337902571
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
How To Analyze an Income Statement; Author: Daniel Pronk;https://www.youtube.com/watch?v=uVHGgSXtQmE;License: Standard Youtube License