5.3 Compute the expected return of your portfolio using the annual average return. (Note: Calculate the annual average return of an individual asset using the formula given in Q2, Part I.( i have attached the formula and i have attached screenshots of the data in the portfolio in the excel spread sheets below) Each interval is to be July in Year t to July in Year t+1.)[7 marks]

2. Calculate the monthly realised returns for your stock and market index. [5 marks] Instructions! a. We learnt in Lecture 4 that realised return at t can be calculated as R. = Pt-Pt-1 + Divt Pt-1A B C D E F 1 Date Close (P) Dividend (D) Close price for the market index (m) Monthly realised return for Stock Monthly realised return for market index 1/7/15 101.260002 5699.200195 1/8/15 100.699997 207 0.55% -8.64% 1/9/15 87.379997 0.3 5021.600098 12.93% -3.56% 1/10/15 87 5239.399902 0.43% 4.34% 1/11/15 88.449997 5166.5 1.60%% 1.39% 1/12/15 88.690002 0.3 5295.899902 0.61 2.50% 1/1/16 83.68 5005.5 -5.65% -5.48% 1/2/16 90.160004 4880.899902 7.74% -2.49%% 1/3/16 19.5 0.3 5082.799805 10.69% 4.14% 1/4/16 101.900002 5252.200195 2.40% 3.33% 1/5/16 103.82 5378.600098 1.88% 2.41%% 1/6/16 105.68 0.3 5233.399902 2.08% -2.70% 14 1/7/16 103.290001 6562.299805 -2.26 6.28% 15 1/8/16 104.860001 5433 1.52% -2.32%% 16 1/9/16 102.57 0.35 5435.899902 -1.85% 0.05% 17 1/10/16 104.849998 5317.700195 2.22% 2.17% 18 1/11/16 112.169998 5440.5 6.98% 2.31% 19 1/12/16 110.290001 0.35 5665.799805 -1.36% 4.14% 20 1/1/17 109.110001 5620.899902 -1.06% -0.79% 21 1/2/17 103.300003 5712.200195 -5.32% 1.62% 22 1/3/17 106.410004 0.35 5864.899902 3.35% 2.67% 23 1/4/17 101.389999 5924.100098 4.72% 1.01% 24 1/5/17 101.330002 5724.600098 -0.06% -3.37% 25 1/6/17 95.400002 0.35 5721.5 -5.51% 0.05% 26 1/7/17 97.589996 5720.600098 2.30% -0.02%% 27 1/8/17 94.690002 5714.5 -2.97% -0.11% 28 1/9/17 100.290001 0.37 5681.600098 6.30% 0.58% 29 1/10/17 109.830002 5909 9.50% 4.00% 30 1/11/17 114.970001 5969.899902 4.68% 1.03% 31 1/12/17 113.650002 0.37 6065.100098 0.83% 1.59% 32 1/1/18 114.209999 6037.700195 0.49% -0.45% 33 1/2/18 102.910004 5016 9.89 0.36% 34 1/3/18 104.410004 0.37 5759.399902 1.82% 4.27%% 35 1/4/18 107.730003 5982.700195 3.18% 3.88% 36 1/5/18 107.389999 6011.899902 0.32% 0.49% 37 1/6/18 108.309998 0.37 6194.600098 1.20% 3.04% 38 1/7/18 122.839996 6280.200195 13.42% 1.38% 39 1/8/18 126.809998 6319.5 3.23% 0.63%% 40 1/9/18 121.800003 0.4 6207.600098 -3.64% -1.77% 1/10/18 96.589996 5830.299805 -20.70% -6.08% 42 1/11/18 105.519997 5667.200195 9.25% -2.80%% 1/12/18 100.519997 0.4 5646.399902 -4.36% -0.37%A B C D E F 32 1/1/18 114.209999 6037.700195 D.49% 0.45%% 33 1/2/18 102.910004 6016 -9.89% 0.36% 34 1/3/18 104.410004 0.37 5759.399902 1.82% -4.27% 35 1/4/18 107.730003 5982.700195 3.18% 3.88% 36 1/5/18 107.389999 6011.899902 -0.32% 0.49% 37 1/6/18 108.309998 0.37 6194.600098 1.20% 3.04% 38 1/7/18 122.839996 6280.200195 13.42% 1.38% 39 1/8/18 126.809998 6319.5 3.23% 0.63% 40 1/9/18 121.800003 D.4 6207.600098 -3.64% 1.77 1/10/18 96.589996 5830.299805 -20.70% -6.08% 1/11/18 105.519997 5667.200195 9.25% -2.80% 43 1/12/18 100.519997 0.4 5646.399902 -4.36% -0.37 44 1/1/19 107.730003 5864.700195 7.17% 3.87% 45 1/2/19 123.080002 6169 14.25% 5.19% 46 1/3/19 122.620003 0.4 6180.700195 -0.05% 0.19% 1/4/19 141.419998 6325.5 15.33% 2.34%% 48 1/5/19 133.309998 6396.899902 -5.73% 1.13% 49 1/6/19 140.410004 0.4 6618.799805 5.63% 3.47% 50 1/7/19 144.210007 6812.600098 2.71% 2.93% 1/8/19 144.960007 6604.200195 0.52% -3.06% 1/9/19 145.539993 0.5 6688.299805 0.75% 1.27%% 1/10/19 152.270004 6663.399902 4.62%% 0.37% 54 1/11/19 155.979996 6846 2.44% 2.74% 55 1/12/19 161.839996 D.5 6684.100098 4.08% -2.36% 56 1/1/20 156.229996 7017.200195 -3.47% 4.98% 1/2/20 145.289993 6441.200195 -7.00% -8.20% 58 1/3/20 125.279999 0.5 5076.799805 -13.43% -21.18% 59 1/4/20 120.959999 5522.399902 -3.45% 8.78% 60 1/5/20 119.860001 5755.700195 0.90% 4.22% 1/6/20 119.669998 0.5 5897.899902 0.26% 2.47% 62 1/7/20 119.080002 5927.799805 0.49% 0.51% 63 Average 0.59% 0.17% 64 Variance D.004078468 0.001921737 65 Standard Deviation 0.063862886 0.043837616 66 Covariance 0.001207118 67 Correlation Coefficient .431175819 68 Beta step 1 0.628139367 Beta Step 2 70 leta Step 3 Regression Analysis is on Sheet 2 0.628139367