Free-Cash-Flows-Based Valuation. The Coca-Cola Company is a global soft drink beverage company (ticker symbol = KO) that is a primary and direct competitor with Starbucks. The data in Exhibits 12.14, 12.15, and 12.16 include the actual amounts for fiscal 2015 and projected amounts for Year +1 to Year +6 for the income statements, balance sheets, and statements of cash flows for Coca- Cola (in millions). 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 has 4,324 million shares outstanding at the end of 2015, when the share price was $42.96. Exhibit 12.14 The Coca-Cola Company Income Statements for 2015 (Actual) and Year +1 through Year +6 (Projected) (amounts in millions; allow for rounding) (Problem 12.16) Actual Forecasts Year +3 Year +4 2015 Year +1 Year +2 Year +5 Year +6 INCOME STATEMENT Revenues Cost of goods sold Gross Profit Selling, general, and administrative expenses Other operating expenses Operating Profit Interest income Interest expense Income from equity affiliates Other gains (losses) Income before Tax Income tax expense Net Income Net income attributable to noncontrolling interests Net Income attributable to common shareholders Other comprehensive income items Comprehensive Income $ 44,294 (17.482) $ 26,812 (16,427) (1.657 $ 8,728 613 (856) 489 631 $ 9,605 (2,239) $ 7,366 $ 45,623 (18,021) $ 27,602 (16,880) (1.369) $ 9,353 606 (887) 631 0 $ 9,702 (2,329) $ 7,374 $ 46,992 (18,562) $28.430 (17,387) (1410) $ 9,633 623 (910) 663 0 $ 10,009 (2,402) $ 7,607 $ 48,401 (19,118) $ 29,283 (17,908) (1452) $ 9,922 642 (951) 696 0 $ 10,309 (2A74 $ 7,835 $ 49,853 (19,692) $ 30,161 (18,446) (1.496) $ 10,220 661 (993) 731 0 $ 10,619 (2,549) $ 8,071 $ 51,349 (20.283) $ 31,066 (18.999) (1.540) $ 10,527 681 (1.034) 767 0 $ 10,940 (2,626) $ 8.315 $ 52,889 (20,891) $ 31,998 (19,569) (1.587 $ 10,842 701 (1,065) 790 0 $11,269 (2,704) $ 8.564 (15) (32) (32) (32) (32) (32) (32) $ 7,351 (4.412) $ 2.954 $ 7,342 0 $ 7,342 $ 7,575 0 $ 7.575 $ 7,803 0 $ 7,803 $ 8,039 0 $ 8,039 $ 8,283 0 $ 8,283 $ 8,532 0 $ 8,532 Exhibit 12.15 The Coca-Cola Company Balance Sheets for 2015 (Actual) and Year +1 through Year +6 (Projected) (amounts in millions; allow for rounding) (Problem 12.16) Actual Forecasts 2015 Year +1 Year +2 Year +3 Year +4 Year +5 Year +6 ASSETS Cash and cash equivalents Marketable securities Accounts and notes receivable-net Inventories Prepaid expenses and other current assets Assets held for sale Current Assets Investments in noncontrolled affiliates Property, plant and equipment-at cost Accumulated depreciation Amortizable intangible assets (net) Goodwill Other nonamortizable intangible assets Other assets Total Assets $ 7,309 12,591 3,941 2,902 2,752 3.900 $33,395 12,318 22,354 19,783) 854 11,289 11,989 7,677 $ 90,093 $ 7,500 12,969 4,375 3,110 2,835 0 $ 30,788 12,934 25,091 (11,612) 705 11,628 12,349 7,907 $ 89,790 $ 7.725 13.358 4,506 3,204 2,920 0 $31,712 13,581 27,887 (13,644) 592 11,977 12,719 8,145 $92,968 $ 7,956 13,759 4,641 3,300 3,007 0 $32.663 14,260 30,767 (15,887) 532 12,336 13,101 8,389 $ 96,161 $ 8,195 14,171 4,780 3,399 3,097 0 $ 33,643 14,973 33,734 (18,345) 475 12,706 13,494 8,641 $ 99,320 $ 8.441 14,596 4,924 3.501 3,190 0 $ 34,652 15.721 36,789 (21,026) 423 13,087 13,899 8.900 $102,445 $ 8,694 15,034 5,072 3,606 3.286 0 $ 35,692 16,193 37893 (21.657) 436 13,480 14315 9,167 $105518 LIABILITIES Accounts payable Current accrued expenses Notes payable and short-term debt Current maturities of long-term debt Income taxes payable Liabilities held for sale Current Liabilities $ 2,795 6,865 13,129 2,677 331 1,133 $ 26,930 $ 1,998 7,071 13,216 2,695 449 0 $ 25429 $ 2,044 7,283 13,816 2,817 465 0 $ 26,425 $ 2,106 7,502 14,429 2,942 481 0 $ 27,459 $ 2,169 7,727 15,047 3,068 497 0 0 $ 28,507 $ 2,234 $2,301 7,958 8,197 15,671 16,141 3,195 3.291 512 528 0 0 $ 29,571 $ 30,458 Long-term debt obligations Long-term accrued liabilities Deferred tax liabilities-noncurrent Total Liabilities 28.407 4.301 4.691 $ 64,329 28.596 4,430 4.675 $ 63,130 29,894 4,563 4,841 $ 65,723 31,219 4,700 5,007 $ 68,385 32,557 4,841 5,171 $ 71,076 33.907 34924 4,986 5,136 5,334 5.494 $ 73,798 $ 76,012 17,939 74,779 SHAREHOLDERS' EQUITY Common stock + Additional paid-in capital Retained earnings Accum. other comprehensive income (loss) Treasury stock Total Common Shareholders' Equity Noncontrolling interests Total Equity Total Liabilities and Equities 15,776 65,018 (10,174) (45,066) $ 25,554 210 $ 25,764 $ 90,093 15.723 66,854 (10,174) (45,952) $ 26,451 210 $ 26,661 $ 89,790 16.279 68,747 (10,174) (47 818) $ 27,035 210 $ 27.245 $92,968 16,839 70,698 (10,174) (49.797) $ 27,566 210 $ 27,776 $ 96,161 17,392 72,708 (10,174) (51,892) $ 28,033 210 $ 28,243 $ 99,320 (10,174) (54,107) $ 28,437 210 $ 28,647 $102,445 18.477 77,022 (10,174) (56,035 $ 29,290 216 $ 29,506 $ 105,518 Exhibit 12.16 The Coca-Cola Company Projected Implied Statements of Cash Flows for Year +1 through Year +6 (amounts in millions; allow for rounding) (Problem 12.16) Forecasts Year +3 Year +4 Year +1 Year +2 Year +5 Year +6 $ 8,071 2,459 (139) 199) 1901 Net Income Add back depreciation expense (net Decrease in receivables-net Decrease in inventories Decrease in prepaid expenses Decrease in other current assets Increase Decrease in property, plant, & equip, at cost Decrease in marketable securities Decrease in investment securities Decrease in amortizable intangible assets (net) Decrease in goodwill and nonamort. intangibles Decrease in other noncurrent assets Net Cash Flows from Investing Activities Increase Decrease in short-term debt Increase Decrease in receivables-net Decrease in inventories Decrease in prepaid expenses Decrease in other current assets Increase Decrease in property, plant, & equip, at cost Decrease in marketable securities Decrease in investment securities Decrease in amortizable intangible assets (net) Decrease in goodwill and nonamort. intangibles Decrease in other noncurrent assets Net Cash Flows from Investing Activities Increase Decrease in short-term debt Increase