Valuing Coca-Cola: Download the MONTHLY dividend data from Coca-Cola (ticker: KO) over the past 5 years (Yahoo! Finance). Calculate the growth rate. Download S&P500 (ticker: ^GSPC) MONTHLY index return (historical prices) data over the past 5 years. Calculate the average market return. Download the return data from Coca-Cola. Find Coca-Cola’s beta. Determine the risk-free rate (US Treasury average from the yield curve; most experts use the rate around the 10-year mark). Find the value of Coca-Cola using the CAPM and the Gordon Growth model. Place all data, ratios, calculations, findings, etc. in the first Excel sheet with references to the information in other sheets.

Answer rating: 100% (QA)

1 Downloading Monthly Dividend Data for CocaCola KO Visit Yahoo Finance or a similar financial data provider Search for CocaCola KO and navigate to th... View the full answer