HW6-FIN358 (Fall 2020) Chpt 11 - Risk Adjusted Required Rates of Return & the Discounted Dividend Valuation Model Problem 11.14 Dividends-Based Valuation of Common Equity. The Coca-Cola Company is a global soft drink beverage company (ticker: KO) that is a primary and direct competitor with Starbucks. The following data for Coca-Cola include the actual amounts for 2015 and the projected amounts for Years +1 through +5 for comprehensive income and common shareholders' equity (amounts in millions). Actual 2015 Projected Year +3 Year +1 Year +2 Year +4 Year +5 $ 2954 $ 7,342 $ 7.575 $ 7,803 $ 8,039 $ 8,283 Comprehensive income Common shareholders' equity: Paid-in Capital Retained Earnings Treasury Stock Accumulated Other Comprehensive Income Total Common Equity $ 15,776 65,018 (45,066) $ 15723 66,854 (45,952) $ 16,279 68,747 147,818) $ 16,839 70,698 (49,797) $ 17,392 72,708 (51,892) $ 17,939 74.779 (54,107) (10,174) $ 25,554 (10,174) $ 26451 (10,174) $ 27,035 (10,174) $ 27,566 (10,174) $ 28,033 (10,174) $ 28437 The market equity beta (B:) for Coca-Cola at the end of 2015 is 0.75. Assume that the risk-free interest rate (Re) is 3.0% and the market risk premium (E[Rakel - Rp) is 6.0%. Coca-Cola had 4,324 million shares outstanding at the end of 2015, when the share price was $42.96. Required a. Use the CAPM to compute the required rate of return on common equity capital for Coca-Cola. E[Re:] = R$+B (E[Rmke] - Rp) b. Compute the weighted average cost of capital for Coca-Cola as of the start of Year +1. At the end of 2015, Coca-Cola had $44,213 million in outstanding interest-bearing debt on the balance sheet and no preferred stock. Assume that the balance sheet value of Coca-Cola's debt is approximately equal to the market value of the debt. Assume that at the start of Year +1, it will incur interest expense of 2.0% on debt capital (hint: interest expense as a percentage can be used as the pretax cost of debt capital) and that its average tax rate will be 24.0%. Coca-Cola also had $210 million in equity capital from noncontrolling interests. Assume that this equity capital carries a 15.0% required rate of return. (For our forecasts, we assume noncontrolling interests receive dividends equal to the required rate of return each year.) c. Use the clean surplus accounting approach to derive the projected dividends for common shareholders for Years +1 through +5 based on the projected comprehensive income and shareholders' equity amounts. (Hint: The clean surplus method should give you the same amount for yearly dividends (D) as the direct method.) (Throughout this problem, you can ignore dividends to noncontrolling interests.) D. = CI, + BV-1 - BV, d. Use the clean surplus accounting approach to project the continuing dividend (DT+1) to common shareholders in Year +6. Assume that the steady-state long-run growth rate (g) will be 3% in Years +6 and beyond. Dr+1 = C1+1+BV - BV741 Dr+1 = Cly(1+g) + BV - BV (1+g) Vy Dit Re-g e. Using the required rate of return on common equity (Re) from Requirement a as a discount rate, compute the sum of the present value of dividends to common shareholders for Coca-Cola for Years +1 through +5. PV(D) - La Press f. Using the required rate of return on common equity (R.) from Requirement a as a discount rate and the long-run growth rate (g) from Requirement d. compute the continuing value (Vr) of Coca-Cola as of the beginning of Year +6 based on its continuing dividends in Years +6 and beyond. After computing continuing value, bring continuing value back to present value (PV. (V))at the start of Year +1. Dr+1 Re-9 PV.CV,) = Dr. IR.-- Dr+1 1 x (1 + R.)" R.- g (1 + R.)" g. Compute the value of a share of Coca-Cola common stock, as follows: 1. Compute the sum of the present value of dividends including the present value of continuing value. 2. Adjust the sum of the present value using the midyear discounting adjustment factor 3. Compute the per-share value. h. Using the same set of forecast assumptions as before, recompute the value of Coca-Cola shares under two alternative scenarios. 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 g. Scenario 1: Assume that Coca-Cola's long-run growth will be 2%, not 3% as before, and assume that its required rate of return on equity is 1 percentage point higher than the rate you computed using the CAPM in Requirement a. Scenario 2: Assume that Coca-Cola's long-run growth will be 4%, not 3% as before, and assume that its required rate of return on equity is 1 percentage point lower than the rate you computed using the CAPM in Requirement a. i. What reasonable range of share values would you expect for Coca-Cola common stock? Where is the current price for Coca-Cola shares relative to this range? What do you recommend (Buy, Sell, or Hold the stock at the current market price)? HW6-FIN358 (Fall 2020) Chpt 11 - Risk Adjusted Required Rates of Return & the Discounted Dividend Valuation Model Problem 11.14 Dividends-Based Valuation of Common Equity. The Coca-Cola Company is a global soft drink beverage company (ticker: KO) that is a primary and direct competitor with Starbucks. The following data for Coca-Cola include the actual amounts for 2015 and the projected amounts for Years +1 through +5 for comprehensive income and common shareholders' equity (amounts in millions). Actual 2015 Projected Year +3 Year +1 Year +2 Year +4 Year +5 $ 2954 $ 7,342 $ 7.575 $ 7,803 $ 8,039 $ 8,283 Comprehensive income Common shareholders' equity: Paid-in Capital Retained Earnings Treasury Stock Accumulated Other Comprehensive Income Total Common Equity $ 15,776 65,018 (45,066) $ 15723 66,854 (45,952) $ 16,279 68,747 147,818) $ 16,839 70,698 (49,797) $ 17,392 72,708 (51,892) $ 17,939 74.779 (54,107) (10,174) $ 25,554 (10,174) $ 26451 (10,174) $ 27,035 (10,174) $ 27,566 (10,174) $ 28,033 (10,174) $ 28437 The market equity beta (B:) for Coca-Cola at the end of 2015 is 0.75. Assume that the risk-free interest rate (Re) is 3.0% and the market risk premium (E[Rakel - Rp) is 6.0%. Coca-Cola had 4,324 million shares outstanding at the end of 2015, when the share price was $42.96. Required a. Use the CAPM to compute the required rate of return on common equity capital for Coca-Cola. E[Re:] = R$+B (E[Rmke] - Rp) b. Compute the weighted average cost of capital for Coca-Cola as of the start of Year +1. At the end of 2015, Coca-Cola had $44,213 million in outstanding interest-bearing debt on the balance sheet and no preferred stock. Assume that the balance sheet value of Coca-Cola's debt is approximately equal to the market value of the debt. Assume that at the start of Year +1, it will incur interest expense of 2.0% on debt capital (hint: interest expense as a percentage can be used as the pretax cost of debt capital) and that its average tax rate will be 24.0%. Coca-Cola also had $210 million in equity capital from noncontrolling interests. Assume that this equity capital carries a 15.0% required rate of return. (For our forecasts, we assume noncontrolling interests receive dividends equal to the required rate of return each year.) c. Use the clean surplus accounting approach to derive the projected dividends for common shareholders for Years +1 through +5 based on the projected comprehensive income and shareholders' equity amounts. (Hint: The clean surplus method should give you the same amount for yearly dividends (D) as the direct method.) (Throughout this problem, you can ignore dividends to noncontrolling interests.) D. = CI, + BV-1 - BV, d. Use the clean surplus accounting approach to project the continuing dividend (DT+1) to common shareholders in Year +6. Assume that the steady-state long-run growth rate (g) will be 3% in Years +6 and beyond. Dr+1 = C1+1+BV - BV741 Dr+1 = Cly(1+g) + BV - BV (1+g) Vy Dit Re-g e. Using the required rate of return on common equity (Re) from Requirement a as a discount rate, compute the sum of the present value of dividends to common shareholders for Coca-Cola for Years +1 through +5. PV(D) - La Press f. Using the required rate of return on common equity (R.) from Requirement a as a discount rate and the long-run growth rate (g) from Requirement d. compute the continuing value (Vr) of Coca-Cola as of the beginning of Year +6 based on its continuing dividends in Years +6 and beyond. After computing continuing value, bring continuing value back to present value (PV. (V))at the start of Year +1. Dr+1 Re-9 PV.CV,) = Dr. IR.-- Dr+1 1 x (1 + R.)" R.- g (1 + R.)" g. Compute the value of a share of Coca-Cola common stock, as follows: 1. Compute the sum of the present value of dividends including the present value of continuing value. 2. Adjust the sum of the present value using the midyear discounting adjustment factor 3. Compute the per-share value. h. Using the same set of forecast assumptions as before, recompute the value of Coca-Cola shares under two alternative scenarios. 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 g. Scenario 1: Assume that Coca-Cola's long-run growth will be 2%, not 3% as before, and assume that its required rate of return on equity is 1 percentage point higher than the rate you computed using the CAPM in Requirement a. Scenario 2: Assume that Coca-Cola's long-run growth will be 4%, not 3% as before, and assume that its required rate of return on equity is 1 percentage point lower than the rate you computed using the CAPM in Requirement a. i. What reasonable range of share values would you expect for Coca-Cola common stock? Where is the current price for Coca-Cola shares relative to this range? What do you recommend (Buy, Sell, or Hold the stock at the current market price)