1. Calculate the Total Return for each year 2010 - 2019 for the Market, Coca Cola and Pepsi
2. Calculate the Dividend Yield for each year 2010 - 2019 for Coca Cola and Pepsi
3. Calculate the Dividend Growth for each year 2010 - 2019 for Coca Cola and Pepsi
4. Calculate the Return Relative for each year 2010 - 2019 for the Market, Coca Cola and Pepsi

Year Risk Free Rate 2010 3.22% 2011 2.78% 2012 1.80% 2013 2.35% 2014 2.54% 2015 2.14% 2016 1.84% 2017 2.33% 2018 2.91% 2019 2.14% 13 14 Market (S&P 500) Coca Cola Pepsi Date 15 Close Adj Close Dividend Adj Close | Dividend 12/31/09 $ 1,115.10 $ 18.95 $ 1.64 $ 43.96 $ 1.78 12/31/10 1,257.64 S 23.27 1.76 49.02 S 2.37 12/30/11 1,257.60 26.21 $ 1.88 S 51.36 2.03 12/31/12 1,426.19 28.33 1.53 S 54.64 2.13 12/31/13 1,848.36 $ 33.21 $ 1.12 68.11 $ 2.24 12/31/14 2,058.90 $ 34.96 1.22 $ 79.87 2.53 12/31/15 2,043.94 36.75 S 1.32 $ 86.86 2.76 12/30/16 2,238.83 36.62 S 1.40 $ 93.63 2.96 12/29/17 2,673.61 41.89 1.48 $ 110.31 3.17 12/31/18 2,506.85 S 44.73 S 1.56 $ 105.00 S 3.59 26 12/30/19 3,221.29 S 53.86 S 1.60 S 133.88 S 3.79 27