PLEASE ANSWER CORRECTLY

Required:

This is my second time posting this. Indicate the formulas that was used here. Use the same format required. Show the steps on how to do this on excel with formulas and what to input on solver. If not followed or if not shown using excel, i will just downvote.

Section 8.5

A D F. G H I J K B E Beating the Market (Evolutionary Solver) 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 Quarter Q4 03 Q2 Q1 Q4 Q3 Q2 Q1 04 Q3 Q2 Q1 Q4 Q3 02 Q1 04 Q3 Q2 Q1 Q4 Q3 Q2 Q1 Year 2016 2016 2016 2016 2015 2015 2015 2015 2014 2014 2014 2014 2013 2013 2013 2013 2012 2012 2012 2012 2011 2011 2011 2011 DIS 13.10% -4.38% -1.50% -5.49% 3.47% -9.94% 8.82% 11.37% 7.14% 3.83% 7.08% 4.81% 19.93% 2.12% 11.18% 14.07% -3.29% 7.78% 10.80% 16.74% 26.43% -22.76% -9.39% 14.87% BA 19.08% 2.28% 3.14% - 11.39% 11.10% -4.99% -6.98% 16.18% 2.63% 0.72% 1.96% - 7.54% 16.59% 15.23% 19.93% 14.66% 8.94% -5.76% 0.49% 1.99% 21.99% - 17.60% 0.54% 13.94% GE 7.47% -5.17% -0.23% 2.87% 24.46% -4.25% 8.03% -0.94% -0.42% -1.67% 2.30% -6.83% 18.33% 3.80% 1.08% 11.06% -6.74% 9.81% 5.01% 13.05% 18.83% -18.56% -5.13% 10.39% PG -5.59% 1.32% 9.35% 4.55% 11.37% -7.30% -3.75% -9.41% 9.61% 7.41% - 1.71% -0.25% 8.53% -1.08% 0.65% 14.42% -1.31% 14.22% -8.10% 1.56% 6.45% 0.19% 4.07% -3.55% MCD 6.34% -3.39% -3.55% 7.19% 20.84% 4.55% -1.58% 4.90% -0.30% -5.07% 3.59% 1.89% 1.70% -2.04% 0.09% 13.92% -2.99% 4.46% -9.05% -1.53% 15.11% 4.84% 11.64% -0.06% Return 8.08% -1.87% 1.44% -0.45% 14.25% -4.39% 0.91% 4.42% 3.73% 1.05% 2.64% -1.58% 13.02% 3.61% 6.59% 13.63% -1.08% 6.10% -0.17% 6.36% 17.76% 10.78% 0.35% 7.12% Beat Market? Yes No No No Yes Yes Yes Yes Yes Yes No No Yes No Yes Yes No Yes Yes No Yes Yes Yes Yes Market (NYSE) 3.13% 2.21% 2.77% 0.63% 3.51% -9.31% -0.86% 0.55% 1.27% -2.52% 4.29% 1.23% 8.10% 5.58% 0.06% 7.86% 2.33% 5.76% -4.94% 9.76% 10.09% -18.36% -1.02% 5.54% 0% 0% 0% 0%