Answered step by step
Verified Expert Solution
Link Copied!

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.)

image text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Innovation And Technology

Authors: Nikos Vernardakis

1st Edition

0415676800, 978-0415676809

More Books

Students also viewed these Finance questions

Question

socialist egalitarianism which resulted in wage levelling;

Answered: 1 week ago

Question

soyuznye (all-Union, controlling enterprises directly from Moscow);

Answered: 1 week ago