The Coca-Cola Company is a global soft drink beverage company (ticker: KO) that is a primary and direct competitor with Starbucks. The data in Chapter 12's Exhibits 12.14, 12.15, and 12.16 include the actual amounts for 2013, 2014, and 2015 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 2015 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,324 million shares outstanding at the end of 2015, when Coca-Cola's share price was $42.96.

REQUIREDPart I?Computing Coca-Cola's Share Value Using the Residual Income Valuation Approacha. Use the CAPM to compute the required rate 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 2015, 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 Recommendationf. Using the residual income valuation approach, compute 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 2015, 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 obtained 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.

Transcribed Image Text:

Ex hibit 12.14 The Coca-Cola Company Income Statements for 2015 (Actual) and Year +1 through Year +6 (Projected) (amounts in millions; allow for round ing) (Problem 12.16) Actual Foecasts 2015 Year +1 Year +2 Year +3 Year +4 Year +5 Year 16 INCOME STATEMENT $ 45,623 (1802 1) $ 27,602 $ 46,992 (18,562) $ 51,349 (20, 283) $ 31,066 Revenues $44,294 $48 A01 $49,853 $52889 (19,118) Cost of goods sold Gross Profit (17482) $26812 (16,427) (1657) (19692) $30,161 (20,891) $31998 $ 28,430 (17,387) (1,410) $29283 Selling genenl, and administative expenses Other operating expenses Operating Profit (16880) (1369) (17,908) (1,452) (18446) (1496) (19,569) (1,587) (18,999) (1,540) $ 10,527 $ 8,728 $ 9,353 $ 9,633 $ 9,922 $10,220 $10842 Interest income 613 606 623 642 661 681 701 (993) Interest expernse Income from equity affilates Other gains (losses) (856) (887) (910) (951) (1,034) (1,065) 489 631 663 696 731 767 790 631 $10,619 (2,549) $ 8,071 Income before Tax $ 10,940 $11269 $ 9,605 (2239) $ 9,702 (23 29) $ 7,374 $ 10,009 $10,309 Income tax expense Net Income (2,402) $ 7,607 (2,474) (2,626) (2,704) $ 7,366 $ 7,835 $ 8315 $ 8564 Net income attributable to noncontroling interests (15) (32) (32) (32) (32 (32) (32) Net Income attributable to common shareholders $ 7,351 $ 7,342 $ 7,575 $ 7,803 $ 8,039 $ 8,283 $ 8,532 (4412) $ 2,954 Other comprehensive income items Comprehensive Income $ 7,342 7,575 $ 7,803 8,039 8,283 $ 8,532