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. Use this for "k" or "r". Find the value of Coca-Cola using the Gordon Growth model. Be sure you calculate what next year's dividend will be and use that instead of this year's dividend in the final stock price calculation. Once you have your answer, go back to Yahoo! and compare your intrinsic value (price) with what the market price currently is. Compare the two and state whether Coca-Cola is a buy, sell, or hold (if the two are within a few pennies of each other).

Below is the dividends for KO

Date	Dividends
14-Sep-20	0.41
12-Jun-20	0.41
13-Mar-20	0.41
29-Nov-19	0.4
13-Sep-19	0.4
13-Jun-19	0.4
14-Mar-19	0.4
29-Nov-18	0.39
13-Sep-18	0.39
14-Jun-18	0.39
14-Mar-18	0.39
30-Nov-17	0.37
14-Sep-17	0.37
13-Jun-17	0.37
13-Mar-17	0.37
29-Nov-16	0.35
13-Sep-16	0.35
13-Jun-16	0.35
11-Mar-16	0.35
27-Nov-15	0.33