Compute the Coca-Cola's enterprise value in 2019 using the discounted cash flow approach in Chapter 2 and the Coca-Cola's free cash flow in 2019. Assume that (1) the Coca-Cola's short term growth rate from 2020 to 2024 is 4%, (2) the Coca-Cola's long term growth rate after 2024 is 2%, (3) the Coca-Cola's WACC is 7%, and (4) the mid-year rather than end-year discounting is applied. (Submit the number in million dollars. For example, submit 12,345 if the enterprise value is $12,345,000.)
A B D E F G H I J L 1 COCA-COLA BALANCE SHEET 2019 IN MILLION DOLLARS 2 Cash, Cash Equivalents & Short Term Investments 11,175 Current Liabilities 26,973 3 Receivables 3,971 Total Non Current Liabilities Net Minority Interest 38,310 4 Inventory 3,379 Total Liabilities Net Minority Interest 65,283 5 Prepaid Assets 1,886 6 Current Assets 20,411 Stockholders' Equity 18,981 7 Minority Interest 2,117 8 Total non-current assets 65,970 Total Equity Gross Minority Interest 21,098 9 10 Total Assets 86,381 Total liabilities and equity 86,381 11 12 Coca-Cola share price ($) 50 13 Coca-Cola number of outstanding shares (millions) 4,314 14 15 16 17 18 19 COCA-COLA CASH FLOW STATEMENT 2019 20 Cash flows from operating activities 10,471 21 22 Investments in property, plant and equipment -2,054 23 Acquisitions, net -5,542 24 Purchases of investments -4,704 25 Sales/Maturities of investments 6,973 26 Other investing activites -56 27 Net cash used for investing activites -3,976 28 Cash flows from investing activities -3,976 29 30 Cash flows from financing activities -9,004 31 COCA-COLA VALUATION Free cash flow in 2019 FCF growth rate until 2024 FCF growth rate after 2024 Weighted average cost of capital 2019 2020 2021 2022 2023 2024 FCF Terminal value Total Enterprise value A B D E F G H I J L 1 COCA-COLA BALANCE SHEET 2019 IN MILLION DOLLARS 2 Cash, Cash Equivalents & Short Term Investments 11,175 Current Liabilities 26,973 3 Receivables 3,971 Total Non Current Liabilities Net Minority Interest 38,310 4 Inventory 3,379 Total Liabilities Net Minority Interest 65,283 5 Prepaid Assets 1,886 6 Current Assets 20,411 Stockholders' Equity 18,981 7 Minority Interest 2,117 8 Total non-current assets 65,970 Total Equity Gross Minority Interest 21,098 9 10 Total Assets 86,381 Total liabilities and equity 86,381 11 12 Coca-Cola share price ($) 50 13 Coca-Cola number of outstanding shares (millions) 4,314 14 15 16 17 18 19 COCA-COLA CASH FLOW STATEMENT 2019 20 Cash flows from operating activities 10,471 21 22 Investments in property, plant and equipment -2,054 23 Acquisitions, net -5,542 24 Purchases of investments -4,704 25 Sales/Maturities of investments 6,973 26 Other investing activites -56 27 Net cash used for investing activites -3,976 28 Cash flows from investing activities -3,976 29 30 Cash flows from financing activities -9,004 31 COCA-COLA VALUATION Free cash flow in 2019 FCF growth rate until 2024 FCF growth rate after 2024 Weighted average cost of capital 2019 2020 2021 2022 2023 2024 FCF Terminal value Total Enterprise value
