Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Go to sheet assignment1 in the Chapter 2 Excel file. Compute the Coca-Cola's free cash flow in 2019 using the Coca-Cola's cash flow statement in
Go to sheet assignment1 in the Chapter 2 Excel file. Compute the Coca-Cola's free cash flow in 2019 using the Coca-Cola's cash flow statement in 2019. Assume that (1) only "Investments in property, plant and equipment" item in the investing activities section is operating-related, and (2) the net interest is zero, i.e., there is no tax shield. (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 valueStep 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