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.
