Concept explainers
The Coca-Cola Company is a global soft drink beverage company (ticker: KO) that is a primary and direct competitor with PepsiCo. The data in Chapter 12’s Exhibits 12.14, 12.15, and 12.16 (pages 943–946) include the actual amounts for 2010, 2011, and 2012 and projected amounts for Year +1 to Year +6 for the income statements, balance sheets, and statements of cash flows, respectively, for Coca-Cola. The market equity beta for Coca-Cola at the end of 2012 is 0.75. Assume that the risk-free interest rate is 3.0% and the market risk premium is 6.0%. Coca-Cola had 4,469 million shares outstanding at the end of 2012, when Coca-Cola’s share price was $35.48.
REQUIRED
Part I—Computing Coca-Cola’s Share Value Using the Residual Income Valuation Approach
- a. Use the
CAPM to compute the requiredrate of return on common equity capital for Coca-Cola. - b. Derive the projected residual income for Coca-Cola for Years +1 through +6 based on the projected financial statements. The financial statement
forecasts for Year +6 assume that Coca-Cola will experience a steady-state, long-run growth rate of 3% in Year +6 and beyond. - c. Using the required rate of return on common equity from Requirement a as a discount rate, compute the sum of the present value of residual income for Coca-Cola for Years +1 through +5.
- d. Using the required rate of return on common equity from Requirement a as a discount rate and the long-run growth rate from Requirement b, compute the continuing value of Coca-Cola as of the start of Year +6 based on Coca-Cola’s continuing residual income in Year +6 and beyond. After computing continuing value as of the start of Year +6, discount it to present value at the start of Year +1.
- e. Compute the value of a share of Coca-Cola common stock.
- (1) Compute the total sum of the present value of all residual income (from Requirements c and d).
- (2) Add the book value of equity as of the beginning of the valuation (that is, as of the end of 2012, or the start of Year+1).
- (3) Adjust the total sum of the present value of residual income plus book value of common equity using the midyear discounting adjustment factor.
- (4) Compute the per-share value estimate.
Part II—Sensitivity Analysis and Recommendation
- f. Using the residual income valuation approach, recompute the value of Coca-Cola shares under two alternative scenarios.
Scenario 1: Assume that Coca-Cola’s long-run growth will be 2%, not 3% as above, and that Coca-Cola’s required rate of
return on equity is 1% higher than that calculated in Requirement a.Scenario 2: Assume that Coca-Cola’s long-run growth will be 4%, not 3% as above, and that Coca-Cola’s required rate of return on equity is 1% lower than that calculated in Requirement a.
To quantify the sensitivity of your share value estimate for Coca-Cola to these variations in growth and discount rates, compare (in percentage terms) your value estimates under these two scenarios with your value estimate from Requirement e.
- g. Using these data at the end of 2012, what reasonable range of share values would you have expected for Coca-Cola common stock? At that time, what was the market price for Coca-Cola shares relative to this range? What would you have recommended?
- h. If you completed Problem 12.16 in Chapter 12, compare the value estimate you obtained in Requirement e of that problem (using the
free cash flows to common equity shareholders valuation approach) with the value estimate you obtain here using the residual income valuation approach. The value estimates should be the same. If you have not completed Problem 12.16, you would benefit from doing so now.
Trending nowThis is a popular solution!
Chapter 13 Solutions
Financial Reporting, Financial Statement Analysis and Valuation
- Analyze and compare Zynga, Electronic Arts, and Take-Two Data (in millions) from recent financial statements of Zynga Inc. (ZNGA), Electronic Arts Inc. (EA), and Take-Two Interactive Software, Inc. (TTWO) are as follows: a. Compute the working capital for Year 2 and Year 1 for each company. b. Which company has the largest working capital? c. Compute the current ratio for Year 2 and Year 1 for each company. Round to one decimal place. d. For Year 2, rank the companies from most liquid to least liquid based upon the current ratio.arrow_forwardYou are provided with the Income Statement and the Balance Sheet of HTS software, Inc. for 2011. Required: (b) Analyze the current financial position for the company from a time series and cross section viewpoint. (c) Break your analysis into an evaluation of the firm’s liquidity, activity, debt, profitability and market ratios. Historical and Industry Average Ratios HTS Software , Inc. Ratio 2010 2011 Industry2011 Current Ratio 2.6 2.08 2.7 Quick Ratio 1.8 1.32 1.75 Inventory Turnover 4.5 6 4.7 Average Collection Period 40days 9.125 42 days Total Asset Turnover 1.2 1.69 1 Debt Ratio 20% 28.2% 21% Times Interest Earned 9 5.9% 8.9 Gross Profit Margin 43% 42.8% 44% Operating Profit Margin 30% 25.5% 32% Net Profit Margin 20% 17% 21% Return on total assets 12% 4.11% 13% Return on Equity Price/Earnings Ratio 15% 7.3 19% 4.4 16% 8…arrow_forwardA Comparison of Firm Performance 1 2 2013 Financials 3 Net operating revenues 4 Cost of goods sold 5 Gross profit 6 Selling, general, and administrative expense 7 Other costs 8 Operating income 9 Interest expense 10 Other income (loss) - net 11 Income before income taxes 12 Income taxes 13 Net income 14 Assets 15 Cash and cash equivalents 16 Net receivables 17 Inventories 18 Prepaid expenses and other 19 Total current assets 20 Property, plant and equipment 21 Goodwill 22 Other assets 23 Total assets 24 Liabilities and Stockholder Equity 25 Accounts payable 26 Short-term debt 27 Total current liability 28 Long-term debt 29 Other liabilities 30 Total liabilities 31 Stockholder equity 32 B Walmart 469,162 352,488 116,674 88,873 27,801 2,251 187 25,737 7,981 17,756 7,781 6,768 43,803 1,588 59,940 116,681 20,497 5,987 203,105 59,099 12,719 71,818 41,417 113,235 89,870 C Macy's 27,931 16,725 11,206 8,440 88 2,678 388 (134) 2,156 767 1,389 1,836 371 5,308 361 7,876 8,196 3,743 1,176 20,991…arrow_forward
- PlDiscuss the relations between net income and cash flow from operations and among cash flows from operating, investing, and financing activities for the firm over the three-year period. Iden-tify characteristics of Coca-Cola's cash flows that you would expect for a mature company.arrow_forwardSelected financial data for Amberjack Corporation follows. Year 1 ($ thousands) 277,161 Year 2 ($ thousands) 465,381 347,324 (404,109) (21,383) 269,622 Sales 255,211 (161,064) (59,635) 341,780 342,506 21,737 Cost of goods sold Net income Cash flow from operations Cash Marketable securities 37,500 36,048 72,706 415,876 Accounts receivable Inventories 6,551 Total current assets 712,574 Accounts payable 29,508 45,054 74,562 23,358 125,451 148,809 Accrued liabilities Total current liabilities a. Calculate the current and quick ratio at the end of each year. Note: Round your answers to 1 decimal place. b. Assuming a 365-day year for all calculations, compute the following: i. The collection period each year based on sales. ii. The inventory turnover and the payables period each year based on cost of goods sold. iii. The days' sales in cash each year. iv. The gross margin and profit margin each year. Note: Round your answers to 1 decimal place. Negative answers should be indicated by…arrow_forwardYou are provided with the Income Statement and the Balance Sheet of HTS software, Inc. for 2011. Required: (b) Analyze the current financial position for the company from a time series and cross section viewpoint. (c) Break your analysis into an evaluation of the firm’s liquidity, activity, debt, profitability and market ratios. Historical and Industry Average Ratios HTS Software , Inc. Ratio 2010 2011 Industry2011 Current Ratio 2.6 — 2.7 Quick Ratio 1.8 — 1.75 Inventory Turnover 4.5 — 4.7 Average Collection Period 40days — 42 days Total Asset Turnover 1.2 — 1 Debt Ratio 20% — 21% Times Interest Earned 9 — 8.9 Gross Profit Margin 43% — 44% Operating Profit Margin 30% — 32% Net Profit Margin 20% — 21% Return on total assets 12% — 13% Return on Equity Price/Earnings Ratio 15% 7.3 — — 16% 8 Balance SheetHTS Software, Inc.December 31,…arrow_forward
- 1. Calculate the following values for the company for the year ending in 20x9. Present evidence of all your calculations.a. NOPAT - Net Operating Profit after Taxesb. OCF - Operating Cash Flowc. FCF - Free Cash Flow2. Discuss what meaning each of the measures calculated in the previous question has, both for management and for investors and creditors, among other constituents.3. What is the main cause of the differences that exist between the company's earnings and the cash flows of the same evaluated period?arrow_forwardDuPont system of analysis Use the following financial information for AT&T and Verizon to conduct a DuPont system of analysis for each company. Sales Earnings available for common stockholders Total assets Stockholders' equity a. Which company has the higher net profit margin? Higher asset turnover? b. Which company has the higher ROA? The higher ROE? c. Which company has the higher financial leverage multiplier? a. Net profit margin (Round to three decimal places.) AT&T Net profit margin AT&T $164,000 13,333 403,921 201,934 Verizon Verizon $126,280 13,608 244,280 24,232arrow_forwardListed below is the income statement for Tom and Sue Travels, Incorporated. TOM AND SUE TRAVELS, INCORPORATED Income Statement for Year End (in millions of dollars) Net sales. Less: Cost of goods sold Gross profits Less: Other operating expenses Earnings before interest, taxes, depreciation, and amortization (EBITDA) Less: Depreciation Earnings before interest and taxes (EBIT) Less: Interest Earnings before taxes (EBT) Less: Taxes Net income The CEO of Tom and Sue's wants the company to earn a net income of $3.200 million. Cot of goods sold is expected to be 60 percent of net sales, depreciation and other operating expenses are not expected to change, interest expense is expected to increase to $1.306 million, and the firm's tax rate will be 21 percent. Calculate the net sales needed to produce net income of $3.200 million. Note: Enter your answer in millions of dollars rounded to 3 decimal places. (i.e., Enter 5,500,000 as 5.500.) Net sales $19.600 9.000 $ 10.600 4.150 $6.450 3.800 $…arrow_forward
- Consider the balance sheets and selected data from the income statement of Keith Corporation that follow (attached) a. Calculate the firm's net operating profit after taxes (NOPAT) for the year ended December 31, 2015. b. Calculate the firm's operating cash flow (OCF) for the year ended December 31, 2015. c. Calculate the firm's free cash flow (FCF) for the year ended December 31, 2015. d. Interpret, compare and contrast your cash flow estimate in parts (b) and (c).arrow_forwardThe Coca-Cola Company is organized geographically and defines reportable operating segments as regions of the world. The following information was extracted from Note 19 Operating Segments in the Coca-Cola Company 2014 Annual Report:Required 1. Calculate the following measures for each of Coca-Cola's operating segments (excluding Bottling Investments and Corporate):Percentage of total net revenues, 2013 and 2014. Percentage change in total net revenues, 2012 to 2013 and 2013 to 2014. Operating income as a percentage of total net revenues (profit margin), 2013 and 2014.2. Determine whether you believe Coca.Cola should attempt to expand its operations in a particular region of the world to increase operating revenues and operating income. 3. List any additional information you would like to have to conduct your analysis.arrow_forwardRequired information [The following information applies to the questions displayed below.] Consider the following balance sheet and income statement for Mmm Good Foods Incorporated (the company that operates Tasty Fried Chicken and Pizza Party), in condensed form, including some information from the cash flow statement: (amounts are millions) Balance Sheet Cash and short-term investments Accounts receivable Inventory Other current assets Long-lived assets Total assets Current liabilities Total liabilities Shareholders' equity Total liabilities and equity Income Statement Sales Cost of sales Gross margin Earnings before interest and taxes Interest Taxes Net income Share price Earnings per share Number of outstanding shares (millions) Cash Flows Cash flow from operations Capital expenditures Dividends Mmm Good Foods Incorporated 2019 2018 $743 623 $ 443 597 161 3,704 $ 5,231 $ 1,541 13, 247 (8,016) $ 5,231 $ 5,597 1,235 $ 4,362 $ 1,859 486 79 $ 1,294 $ 102 4.23 300 $ 1,315 196 511 167…arrow_forward
- Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Financial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage Learning