Valuing Coca-Cola Using Discounted Cash Flow Analysis

Zihan Wen

doi:10.54691/bcpbm.v37i.3583

Authors

Zihan Wen

DOI:

https://doi.org/10.54691/bcpbm.v37i.3583

Keywords:

Firm Valuation, DCF Analysis, Coca-Cola

Abstract

Coca-Cola experienced a constant revenue decline from 2013 to 2018 due to the structural change of the company, and then COVID-19 impacted the world economy. However, in such an era filled with uncertainties, the market cap of Coca-Cola has barely fallen yet had a constant increase yearly. Thus, this paper uses DCF analysis to investigate the ‘intrinsic’ value of Coca-Cola and hence evaluate the rationality of the current market value of Coca-Cola. The future free cash flow is forecasted based on the historical free cash flows of Coca-Cola, and reasonable assumptions are made to discount the sum of the future free cash flow and give an answer of valuation. By conducting the analysis, the rationality of the current market value of Coca-Cola is justified, and it is realized that there is further potential for Coca-Cola to grow in the future by considering a wider range of financial metrics. It is suggested that Coca-Cola’s stock is a good choice for long-term investment.

Downloads

Download data is not yet available.

References

Team, T. (n.d.). Why We Should Look Beyond Coca-Cola’s Declining Revenue. [online] Forbes. Available at: https://www.forbes.com/sites/greatspeculations/2017/01/12/why-we-should-look-beyond-coca-colas-declining-revenue/?sh=37a633ce3fbc [Accessed 13 Sep. 2022].

Finance.yahoo.com. (n.d.). Coca-Cola Company (The) (KO) Stock Price, Quote, History & News - Yahoo Finance. [online] Available at: https://finance.yahoo.com/quote/KO/.

Matthias Meitner (2006). The Market Approach to Comparable Company Valuation. Heidelberg: Physica-Verlag Gmbh & Co.

Welch, I. (2017). Valuation from Multiples and Financial Ratios, Corporate finance. California: Ivo Welch.

Meitner, M. (2003). Option-Style Multi-Factor Comparable Company Valuation for Practical Use. SSRN Electronic Journal. doi:10.2139/ssrn.485563.

BRACKENBOROUGH, S., MCLEAN, T. and OLDROYD, D. (2001). THE EMERGENCE OF DISCOUNTED CASH FLOW ANALYSIS IN THE TYNESIDE COAL INDUSTRY c.1700–1820. The British Accounting Review, 33(2), pp.137–155. doi:10.1006/bare.2001.0158.

John Burr Williams (2014). The Theory of investment value. Miami, Fla.: Bn Publishing.

Thavamani Thevy Arumugam (2007). An analysis of discounted cash flow (DCF) approach to business valuation in Sri Lanka. [online] Available at: http://www.stclements.edu/grad/gradarum.pdf.

Hayes, A. (2021). What Free Cash Flow to the Firm Tells Us. [online] Investopedia. Available at: https://www.investopedia.com/terms/f/freecashflowfirm.asp.

Investopedia. (n.d.). Weighted Average Cost of Capital (WACC) Explained with Formula and Example. [online] Available at: https://www.investopedia.com/terms/w/wacc.asp#:~:text=Weighted%20average%20cost%20of%20capital%20(WACC)%20represents%20a%20firm [Accessed 14 Sep. 2022].

Ganti, A. (n.d.). Terminal Value (TV) Definition. [online] Investopedia. Available at: https://www.investopedia.com/terms/t/terminalvalue.asp#:~:text=The%20perpetual%20growth%20method%20assumes.

Fernando, J. (2021). Understanding the Compound Annual Growth Rate – CAGR. [online] Investopedia. Available at: https://www.investopedia.com/terms/c/cagr.asp

US Department of the Treasury. (n.d.). Resource Center. [online] Available at: https://home.treasury.gov/resource-center/data-chart-center/interest-rates/TextView?type=daily_treasury_bill_rates&field_tdr_date_value_month=202209 [Accessed 14 Sep. 2022].

Statista. (n.d.). Average market risk premium in the US 2011-2020. [online] Available at: https://www.statista.com/statistics/664840/average-market-risk-premium-usa/#:~:text=The%20average%20market%20risk%20premium.

ycharts.com. (n.d.). US Inflation Rate. [online] Available at: https://ycharts.com/indicators/us_inflation_rate#:~:text=US%20Inflation%20Rate%20is%20at.