1. Calculate the Expected (Average) Return from 2010 - 2019 for the Risk Free Rate, Market, Coca Cola, and Pepsi 2. Calculate the Average Dividend Yield from 2010 - 2019 for Coca Cola and Pepsi 3. Calculate the Average Dividend Growth from 2010 - 2019 for Coca Cola and Pepsi 4. Calculate Geometric Mean Return from 2010 - 2019 for the Market, Coca Cola and Pepsi 5. Calculate Cumulative Wealth Index from 2010 - 2019 for the Market, Coca Cola and Pepsi 6. Calculate the value of $5,000 invested in 2010 at the end of 2019 for the Market, Coca Cola and Pepsi 7. Calculate Standard Deviation from 2010 - 2019 for the Market, Coca Cola and Pepsi (please note for the standard deviation, this is a sample of the data) 8. Calculate Beta from 2010 - 2019 for the Market, Coca Cola and Pepsi 9. Calculate CAPM Required Rate of Return for the Market, Coca Cola and Pepsi 10. Calculate the Coefficient of Determination (R2) for the Market, Coca Cola and Pepsi \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|} \hline 4 & A & \multicolumn{2}{|c|}{ B } & \multicolumn{4}{|c|}{ D } & \multicolumn{2}{|r|}{ E } & \multicolumn{2}{|c|}{F} \\ \hline 1 & & & & & & & & & & & \\ \hline 2 & Year & \multicolumn{2}{|c|}{ Risk Free Rate } & & & & & & & & \\ \hline 3 & 2010 & \multicolumn{2}{|c|}{3.22%} & & & & & & & & \\ \hline 4 & 2011 & \multicolumn{2}{|c|}{2.78%} & & & & & & & & \\ \hline 5 & 2012 & \multicolumn{2}{|c|}{1.80%} & & & & & & & & \\ \hline 6 & 2013 & \multicolumn{2}{|c|}{2.35%} & & & & & & & & \\ \hline 7 & 2014 & \multicolumn{2}{|c|}{2.54%} & & & & & & & & \\ \hline 8 & 2015 & \multicolumn{2}{|c|}{2.14%} & & & & & & & & \\ \hline 9 & 2016 & \multicolumn{2}{|c|}{1.84%} & & & & & & & & \\ \hline 10 & 2017 & \multicolumn{2}{|c|}{2.33%} & & & & & & & & \\ \hline 11 & 2018 & \multicolumn{2}{|c|}{2.91%} & & & & & & & & \\ \hline 12 & 2019 & \multicolumn{2}{|c|}{2.14%} & & & & & & & & \\ \hline 14 & \multirow{2}{*}{ Date } & \multirow{2}{*}{\multicolumn{2}{|c|}{\begin{tabular}{c} Market (58P 500) \\ Close \end{tabular}}} & \multicolumn{4}{|c|}{ Coca Cola } & \multicolumn{4}{|c|}{ Pepsi } \\ \hline 15 & & & & & & Di & idend & Ad & Jj Close & Di & ridend \\ \hline 16 & 12/31/09 & $ & 1,115.10 & $ & 18.95 & $ & 1.64 & $ & 43.96 & $ & 1.78 \\ \hline 17 & 12/31/10 & $ & 1,257.64 & $ & 23.27 & $ & 1.76 & $ & 49.02 & $ & 2.37 \\ \hline 18 & 12/30/11 & $ & 1,257.60 & $ & 26.21 & $ & 1.88 & $ & 51.36 & $ & 2.03 \\ \hline 19 & 12/31/12 & $ & 1,426.19 & $ & 28.33 & $ & 1.53 & $ & 54.64 & $ & 2.13 \\ \hline 20 & 12/31/13 & $ & 1,848.36 & $ & 33.21 & $ & 1.12 & $ & 68.11 & $ & 2.24 \\ \hline 21 & 12/31/14 & $ & 2,058.90 & $ & 34.96 & $ & 1.22 & $ & 79.87 & $ & 2.53 \\ \hline 22 & 12/31/15 & $ & 2,043.94 & $ & 36.75 & $ & 1.32 & $ & 86.86 & $ & 2.76 \\ \hline 23 & 12/30/16 & $ & 2,238.83 & $ & 36.62 & $ & 1.40 & $ & 93.63 & $ & 2.96 \\ \hline 24 & 12/29/17 & $ & 2,673.61 & $ & 41.89 & $ & 1.48 & $ & 110.31 & $ & 3.17 \\ \hline 25 & 12/31/18 & $ & 2,506.85 & $ & 44.73 & $ & 1.56 & $ & 105.00 & $ & 3.59 \\ \hline 26 & 12/30/19 & $ & 3,221.29 & $ & 53.86 & $ & 1.60 & $ & 133.88 & $ & 3.79 \\ \hline \end{tabular}