Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please answer all parts. If not possible, answer parts E, F, G, H, I and J and how to solve. Thank you! Free-Cash-Flows-Based Valuation. The
Please answer all parts. If not possible, answer parts E, F, G, H, I and J and how to solve. Thank you!
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 $4 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 2015 Year +1 Year +2 Year +3 Year 4 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) (1,410) $ 9,633 623 1910) 663 0 $10,009 (2,402) $ 7,607 $48,401 (19,118) $ 29,283 (17,908) (1,452) $ 9,922 642 (951) 696 0 $10,309 (2,474) $ 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 Source for Actuals: The Coca-Cola Company, Form 10-K for the Fiscal Year Ended December 31, 2015. 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 (9,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 14,315 9,167 $105,518 $ 2,044 $ 2,106 7.283 7,502 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 $ 25,429 13,816 2,817 465 0 $ 26,425 14,429 2,942 481 0 $ 27,459 $ 2.169 7.727 15,047 3,068 497 0 $ 28,507 $ 2,234 7,958 15,671 3,195 512 0 $ 29,571 $ 2,301 8,197 16,141 3,291 528 0 $ 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 4,986 5,334 $ 73,798 34,924 5,136 5,494 $ 76,012 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 17,939 74,779 (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 Source for Actuals: The Coca-Cola Company, Form 10-K for the Fiscal Year Ended December 31, 2015. 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 +1 Year +2 Year +3 Year +4 Year +5 Year +6 $ 7,374 1,829 (434) $ 8,315 2,681 (143) (208) (102) (83) 3.900 (797) 206 118 (1,133) (16) 129 Net Income Add back depreciation expense (net)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started