Today is December 31, 2017, and you have just started your new job with a financial planning firm. In addition to studying for all your licensing exams, you have been asked to review a portion of a clients stock portfolio to determine the risk-return profiles of 12 stocks in the portfolio. Unfortunately, your small firm cannot afford the expensive databases that would provide all this information with a few simple keystrokes, but thats why they hired you. Specifically, you have been asked to determine the monthly average returns and standard deviations for the 12 stocks for the past five years.

The stocks (with their symbols in parentheses) are as follows:

• The Allstate Corporation (ALL)
• Cabot Oil & Gas Corporation (COG)
• CenterPoint Energy, Inc. (CNP)
• Dollar Tree, Inc. (DLTR)
• Host Hotels & Resorts, Inc. (HST)
• Johnson and Johnson (JNJ)
• JPMorgan Chase & Co. (JPM)
• McDonalds Corporation (MCD)
• NRG Energy, Inc. (NRG)
• The Southern Company (SO)
• The TJX Companies, Inc. (TJX)
• Verizon Communications Inc. (VZ)

1. Collect price information for each stock from Yahoo! Finance (finance.yahoo.com) as follows:
   1. Enter the stock symbol. On the page for that stock, click Historical Data.
   2. Under Time Period, enter the start date as December 1, 2012, and the end date as December 31, 2017, in order to have enough data to cover the five-year period. Make sure you choose Monthly next to Frequency.
   3. After hitting Apply, click Download Data.
   4. Open the downloaded file in Excel, and delete all the columns except the date and the adjusted close (the first and next-to-last) columns. When you save the file, select Save As from the File pull-down menu and then choose Excel Workbook.
   5. Keep the Excel file open and go back to the Yahoo! Finance webpage. In the address bar of your browser you will see something similar to this web address: https://finance.yahoo.com/quote/ADM/history?period1=1354345200&period2=1514703600&interval=1mo&filter=history&frequency=1mo
   6. In the browsers address bar, find the symbol for The Allstate Corporation (ALL) and replace it with the symbol for the next company (COG, for Cabot Oil & Gas Corporation). Hit Enter and the page for Cabot Oil & Gas will appear. Click Download Data to download the file with Cabot Oil & Gas historical prices and open it in Excel. Copy the next-to-last column, Adj. Close, and paste it into the original Excel file that already has ALLs data. In order to keep track of each stock, change Adj. Close at the top of each column to the stock symbol. Make sure that the first and last prices are in the same rows as they are for the first stock. [Note that editing the information in the address bar of your browser is the fastest and least error prone method to find the data, but you could also repeat steps (a.), (b.), and (c.) for Cabot Oil & Gas instead.]
   7. Repeat these steps for the remaining 10 stocks, pasting each adjusted closing price right next to those of the other stocks, again making sure that the correct prices on the correct dates all appear on the same rows.
2. Convert these prices to monthly returns by calculating the percentage change in the monthly prices. (Hint: Create a separate worksheet within the Excel file.) Note that to compute a return for each month, you need a beginning and ending price, so you will be able to compute 60 monthly returns from the 61 closing prices that you have collected. (The adjusted close series from Yahoo! Finance already incorporates dividends, so we may compute returns based on the percentage change in monthly adjusted prices: there is no need to calculate returns using prices and dividends as we had done when we used the equation for realized returns earlier.)
3. Compute the mean monthly returns and standard deviations for the monthly returns of each of the stocks. Convert the monthly statistics to annual statistics for easier interpretation (multiply the mean monthly return by 12, and multiply the monthly standard deviation by 12).
4. Add a column in your Excel worksheet with the average return across stocks for each month: start with the average return for January 2013 and finish with the average return for December 2017. When you are done, you will have a 13th column of returns: this is the monthly return series of an equally weighted portfolio of these 12 stocks. Compute the mean and standard deviation of monthly returns for the equally weighted portfolio. Since you already calculated the average return of all of the individual stocks, you can also calculate the average of those 12 averages: this should be equal to the average return on the equally weighted portfolio. Convert the monthly statistics for the equally weighted portfolio to annual statistics (as described in step 3) for ease of interpretation.
5. Using the annual statistics, create an Excel chart with standard deviation (volatility) on the x-axis and average return on the y-axis as follows:
   1. Create three columns on your spreadsheet with the statistics you created in Questions 3 and 4 for each of the individual stocks and the equally weighted portfolio. The first column will contain the 13 ticker symbols (you can use EWP for the equally weighted portfolio). The second and the third columns will have the annual standard deviation and annual average return for each of the 13 investments. In the end, you will have 13 rows of data, from ALL to EWP.
   2. Highlight the data in the last two columns (standard deviation and mean), choose > Insert > Chart > XY Scatter Plot. Complete the chart wizard to finish the plot.
6. What do you notice about the average of the volatilities (standard deviations) of the individual stocks, compared to the volatility of the equally weighted portfolio?

PLEASE ANSWER QUESTION 6 ONLY USING THE FOLLOWING SPREADSHEET:

Date 04 ALL 12/1/2012 5.29 487 6.306 31 - 1095 1.39% 4. 3 2.97% 2/1/2013 31/2013 4/1/2013 5/1/2013 1/2013 11/2013 W/1/2013 91/2013 10/01/2013 11/1/2013 12/1/2013 1/1/2014 2/1/2014 31/2014 4/1/2014 S/1/2014 544999 0.0 2.50% 3. 2 2 2319 0.29% 1.47% 3105 -0.0994 339 -1.48% 2415 00% TV1/2014 1/2014 W1/2014 10/1/2014 2014 12/1/2014 1/1/15 2/1/2015 31/2015 4/1/2015 521/2015 61/2015 7/1/2015 11/2015 W1/2015 10/1/2015 11/1/2015 12/1/2015 -0.49% 2015 mely returns COG 33.947312 37.699556 38891151 40% 7.22% 41.559956 0.39% 40.993195 207 4L1017 0.26% 43.544556 5.94% 40.990955 -6,00% 43.404156 43.339376 497% 46.5143 228% 41.645775 0.95% 44.164207 -6.12% 46.904249 5.99% 49.060551 49.381356 0.45 56.512214 51.16119 1.294 50.92953 53.574519 5.29% 53.713138 0.26% 56.759014 5.67% 59.642293 61.799799 3.51% 61.335514 0459 62.04700 1.16% 62.513900 123% 61480414 2.12% 59415379 57.509109 321% 61.126152 51.666852 -15.47% 51.902999 045% 55.546606 6.25% 55.930547 1.42% 55.598774 54.26453 -2,40% 56.825542 4.22% 60.639579 6.71% 55.551456 3.44% 60.76.5597 3.79% 62.961933 361% 61.805201 52.375763 0.92% 62.878456 0.81% 61.715054 -1.85% 63.55104 2.97% 67.6T12S 6.49% 68.672287 1.47% 75.018143 924% 14.349141 -0.36% 74.566292 -0.25% 79.199593 31.124356 2.43% 333219 33.JT1258 0.5% 85.017238 1.97% 86.821495 * 2.12% 94.961594 97.214601 2.37% 58.76489356 14.3660584 4.25% 703.1787219 22.31% 19.76549611 14.73% monthly retums CNP monthly DLTR mobily HIST monthly INJ 22.955468 13.685558 40.560001 11.401415 2432 14581595 6.18% 39.990002 -1.41% 12.28TOS 7.72% 21 64136 174 15.235407 45.189999 13.00% 12.199212 0.71% 31.25523 9.0% 17.129 12.92% 7.17% 12.799294923 3145 0.63% 17.720203 3.00% 47 34000 80% 13.449264 5668% 32.526535 16.6543211 5.08% 48.040001 101% 13.09591 2.63% 17.01.2003 2.22% 50.84 5.83% 12.418666 -5.17% 35.061119 6.76% 17.975154 5.66% 53.650002 5.53% 13.235655 6.58% 35.189457 16.067 -7618 52.700001 -L77% 12.6.2009 14.531114 17.519495 5.41% 37.16 11.6967 3.7% 32.662644 -3.366 17.9925 2.63% 590002 2.17% 1399 3. 31.87MOT 12.116018 4.26 55.650002 -4.71%. 13.134541 -0.75% 35.886227 17.075342 -0.24% 133% 14.503250 5.99% 37.015766 3.19% 17.237402 0.95% 90.52 -10.48% 13.812354 -4.76% 32.421047 -124195 17.421562 1.97% 34.77 41% 14.7737616 31.35353 3.2018 17.629118 1.1998 52.18 -4.73% 15.201881 2.90% 35.355 15. isors 18.425365 4529 52.07 -0.21% 16.22583 6.74% 33.5601 17.099104 -2.58% 53.629993 1.84% 16.694325 2.99% 31.541445 -5.74 19. 1985 6.96% 54.459993 2.1% 16.649436 -0.22% 30.1527 -3.49% 18.281757 -4.78% 54.470001 0.02% 16.55773 0.53% 31.98538 1.79% 18672681 2.14% 5830001 154% 17.38255497 3031995 18.575TR -0.52% 36.00 4.59% 16.245464 -6.53% 28841427 18.605307 0.33% 6057 8.00% 17.922323 10.32% 30.540543 IR 123441 683000 12.86% 17.8 -0.30% * 214134 11.9552 -1.20% 7.3799 2.95% 18.2760 2289 24.391457 -10.30 17.694645 -145% 7099999 102 11,723 2.66% 26.930317 9.SIS 15.0320N 1.63 12.07% 16.320934 -8.26% 27.422413 15.R13158 -4.79% RL 150002 1.84% 15.63545 -3.00% 31.406328 14595 16.247032 2.74% 76.410004 3.84% 15.66457 278 31.536329 0415 15.782168 -2.86% 74.999 -1.86% 15.635911 -1.09% 29.306118 -7.07% 14928717 541% | 789999999 3.33% 1534513 0.43% 24.307165 -17.00 15. 171900 1.53% T 029999 1.22% 15.363273 1.30% 21.99826 14.02078 -3.22% 76.260002 -2.29% 14.055251 -8.51% 20.327253 -7.58% 1433518 -1.86% 660004 -12.39% 12.533201 -10.83% 20.15773 -0.07% 14.740006 2.33% % 65.439948 -1.76% 13.900391 10.98% 17.509718 135 -3.63% 75.4599 15.229. 13.323444 4.21% 16.46615 -59716 147997 77.220001 2.33% 12.31214 7.39% 19.312 14.64 2.67% 812 5.31% 11258145 -8.55% 19.755127 -2.9% 15.017386 4.25% 80.25 -1.32% 12.445866 10.54% 21.15916 12.62% 17.10169 13 82.459999 2.75% 13.57576 9.68% 21.80128 3.0 17.53492 2.53% 19.709999 -3.33% 13 LVM 4.10% 22.33257 2.4.1% 18.01789 5.03% 90540001 13 99% 12.61410120539 24.901556 7.47% 19.852242 7.795 % 942399 4.09% 13.340723 SM 23.001834 -4.10% 19.7802 96.290001 2.18% 14.800043 10.94% 22.966534 ..10 18.54664 82 699997 14.11% 14.566754 % 24.07712 19.436324 4.57% 78.93 4.56% 12.90564 12.63% 19455668 -19.07 19.076443 -1.85% 75.550008 -4.28% 13.080 0.70% 20:54 5.97% 19.93335 160004 16.09% 15.075015 15.25% 21.821281 STIS. 20050655 4.44% -12.49% 15.120014 561% 20.065115 22.179205 6.37% 77.1992002 0.01% 15.4789 2019 20:479912 2.034 23.118502 7669 061540619 0.4% 22.355.306 2.18% 23.566672 2.32%. LS.186.3.72% 21.728777 -2. 2437484 2.799997 59% 15.5417112.79 29.747055 24.45587 0.28% 77.699997 619% 15.54344 0.22% 23.497395 13.20 23.635469 -3.35% 9919928 -10.01% 15,1878 1.56% 23.390646 2.96% 72.09.2002 3.099 16.330084 3.23% 23.937235 25.501126 5.01% 19.63999 10.49% 15.857511 -2.29% 25.113535 4915 25.451674 461 26.22 9.02% 16.161312.04% 26.005421 25.774277 1.27% 9125 5.10% 17.39439 69% 29.0995 216.148951 1.45% 102.760002 12.61% 17.0 TS 1.18% 26.897095 -1.01% 24934357 -4.54% 17.3999999 4.43% 17.35094 0.309 26.62752 0.39% 18.55009054 L12% 69,61393452 1.87% 14.789997 0.99% 5.474120033 R.19% 3.40102618 4.82% 15.8192 % 687 1814 SR2% 319 5342356 7.11% - 222.6009053 1342 85.367210 223% 177,47611 10% 16.9.2013 11.78139721 16.71% 55.00933674 23.81% 63562149 20.17% mohly runs JPM mobily SS. 4663 34.514444 SR 503228 5.45% 36.9601 60241631 2.95% 38.730945 68.047775 7.99% 37.575073 67.999794 434% 3892235 67.162048 -1.23% 0.017 2.76% 42.056221 75. 158658 8.90% 69459465 -7395 40 549347 7259 10% 41.490225 75.004128 63% 41.359852 76661421 2.21% % 46.256241 74.695915 2.57% 41.234811 T2 151393 -3.41% 44.752612 75.12612 4.13% 45.23328 067584 7009 49.395302 23.201118 3.12% 45 34985 3340775 0.12% 45.501121 16.585355 3.23% 42.19 82.781405 -4.33% 47.220655 83.799194 364% 49 DIS 8.M1141 3.45% 49.6669834 89.752105 L12% 49.887714 90.143494 17.646172 -2.79% 5194623 83.933113 424% 45.140163 8.019556 SL 1940 84.909 -1.18% 90.600 83.727272 -1.39% 52849141 14.5.2006 0.95% 55 39 82.859528 -1.97% 5694821 85.195503 2.82% 57,6329 19.29395 -6.22% 54.259169 79.971413 0.09% S9642 16.550735 8.23% 16.30 0.21% 56.256348 8.647224 2215 56.296162 90L1316 1.67% 90.72579 90.796104 0.14% 48.322521 1053169 3.39% 50828765 97.425673 3.99 54244812 97.955123 054% 56.06272 106193214 841% 53.729829 10. 3.24% 55312218 10477287 4.79% 104 10785 -0.35% 58 0252 160221904 - 1.81% 6.0.352451 4,04% 70 37125 102.296139 4.23% 75.735815 10069557 -1.79% 74281784 108617861 7.915 79979477 111.255108 2.99% 12.525814 110.29995 76.784515 11450076 3279 72.920009 118.9531 3834 RL131378 119.339844 0335 13 81486427 119.5101 -0.36% RL122463 -1.16% 5245964 126 15275 7 23% 89.797874 126.90405 -0.06% 98.833 1.27.207559 0.89% 9.005562 99.16774436 56.3274 19.2174909 3.79% 15.2096652 1062.012932 17.54% 675.9295934 61.3751885 1305 52.6854055 MOD mohly NRG more 50 monthly TIX monthly VZ maly WP 19.768747 26.9483% 19.00 29.31242 7.00 74.091 8.03% 20.63723 4.39% 29.508563.32% 20.29724. 6.43% 29.54275 0.999% 4.69% 75.3997 0.64% 20.7153 03% 30774641 2.90% 20.20293 0.46% 31.62832 797 -2.98% 78980045 4.79% 22864521 10.39% 32.06057 4.24% 2145996 4.22% 30.623 327% 0.92101 2.46% 24.0556 521% 32.976251 2.79% 21.965755 432% 35.84600 12.05% 76.508200 -545% 22.122350 8.04% 30.01 STOC -3.98% 22.79443.77% 33.57359 -9.13% -3.30%. 19.042574 3.32% 23.14525 4.62% 30.49616 1.60% 22.611500 0.80% 34.88168 3.84% 5.57% 78.313301 0.45% 30.486813161% 23.5058363.96% 34.25611 -1.71% 367% 75.400 3.79 22855316 169% 21.76162 -7.18% 23.8129 131% 33.14450 2.30% 77,40 2.78% 23.795161 4.115 28.730.07% 25.541357 0.07% 25.54135726% 32.6476 1.30% 4.29% 77.601 0,32% 2484100 439% 28.59428 966% 27.53430 780938.23413 11.84% 76.35IS 0.86% 23.1331 -6.87% 26.745414 0.53% 26.480454 3.44% 35.10497 -0.65% 2.20% 78 790) 0.48% 25.109701 8.54% 20. 1.18% 26.933966 1.59% 34.76530 -0.07% -5.34% 16,42914 -2.99% 2434906 3.03%. 29. 17800 0.32% 26.041924 -10.00% 33.97301 331% 77,224556 194% 25.52836 44% 30.339523 3.98% 27.90335: 7.15% 34.02753 685% 0.23981: 3.90% 27.92576 939% 31.474594 3.75% 2.60015 08% 34.62037 -7.79% 82.981560 342% 28.7336 2.89% 32.53259 4.30% 26.4790407% 39.4196 1.77% -0.11% 83.00227 0.05% 31.431394 9.39% 31.36367 4.47% 24.78139. 6.41% 36.12754 8.10% 3.694 3.122265 0.12% 2.IR 4.33%, 325I 4.86% 24.26066 2.10% 35.30271 0.09% 78,0233% -6,13% 27.3640-16.77% 31.37232461% 2432456 0.26% 36.46017 3.03% 31% 77.33029 -989% 27.267937 0.13% 32.5619 3.79% 27.20937: 18% 35.41423 0.13% 1.39% 7890494 2.04% 27.00219 -0.97% 32011919 -1.69% 27.0955 4.42% 36.53849 0,40% 78.000111 -1.14% 26.53921 -1.61% 33.9999 621% 28.995994701% 35.72852 0.52% 0.14% 80.56942 3.29% 27.6.2641 4.77%.35.1819 3.45% 30.296518 449% 37.39094 1.80% 4.02% 78.670541 -2.36% 23.839 -1.7993642011 3.54% 31.490805 3.94% 34.57502 -7.53% 13.10% 77,612642 -1.34% 2195141430% 37.62237 : 328% 30.278561 35% 33.78419 2299 13.41% 83.086461 699% 21.472610 -2.18% 33.56.5481 -3.72% 31.5183594.09% 36.9808 9.66% -1.14% 12.521584 -0.62% 22.5560 5.09% 33.20901: 2.23% 32.24943 2.32% 36.35757 -1.66% 4.42% 51.76762 -0,91% 22.00 0.29% 33.240 009 21.71274 9.05% 29.71274 787% 37.72116 3.72% -0.64% 223541 0.41% 32.766521 -1.38% 29.63903025% 37.39071 3.01% 81.21416 -0,04% 20.60429 -921% 31.622393 288% 30.59916 3.10% 35.25042 -3.72 114% 85.3603 5.94% 20 2170 -1.89% 33.971723 6.75% 32.244543 6.75% 32.244543 552% 35.4650 0.99 -585% 1.17144 485% 18.05772 -10.68% 32.215 2.95% 32.475346 0.72% 35.20646 -0.51% 488% 491143 461% 13.461 70 33.459 34.34916 4.19% 33.002771X7% 33.29344 5.40% 5.35% 96.750T 13.92% 11.684343 -13.20% 34.68688 089% 33.96066 2.41% 35.5721 7.25% 4.53% 9.38101: 1.70% 11.33057 -3.03% 34.226511 -24% 32.742934 354% 35.22973 -1.9 -9.97% 102.6092 430% 1078971 4.77% 3639436 6.33% 32.94138 0.73% 35.62657 -98944 07077 4.27% 9.753831 -1.60% 3.01130 4.59% 3.0246 0.47% 38.73332 8.11% 4.14% 101.78413 -5.32% 10029213 2.82% 37.47554 -51% 34.423306 4.01% 39.80608 2.72% 5.19% 109.99.49 5.96% 12.103901 20.69% 40.68576 857% 36 51637 6.06% 42 4347 6.72% 110.6351 0.64% 14.0483 16.08% 39.40379% -3.19% 35.331424 323% 39.97085 S.RS 4,04% 1068170 3.50% 15.26977 3.69 3.28 132% 35.471223 0.40% 40.35107 -490% 105.31111 -141% 139739 9.70% 16.109160 120% 44.27823 9.715 2.94% 108.7145 -1.52% 12.90195 -7.67% 42.55142 -24% 36203484 581% 43.92728 -0.72% 6.34% 100% -1.69% 11.313462 12.31% 40.2350 4,06% 36.20735 324% 41.91391 4619 -1.39% 102.4861 0.52% 10472661 -7.43% 41.283364 101% 35.075454 3.13% 41.63356 -0.62% 4.01% 100.00SC -5.17%. 41.455400 0.53% 34.59232 -1.35% 38.52587 -7.4% 1639% 106.95975 5.99% 10.62455 6.999 37.63703-921% 36 745251 622% 40.42339 1.63% 10.97730 2.85% 11.486511 8.11%. 46.00 6.29% 35.365000 3.76% 43.2425 6.9794 192% 109.73831 0.70% 15.495491 3491% 40.1999 0.49% 35.266151 028% 39.70241 8.19% 7.67% 114.2545 4.14% 15.54057 0.30% 41.33041 281% 3692778 4.71% 40.63451 -3.07% 116.6954 2.28% 17.552321 12.92% 40,9589% -4.90% 37.353256 1.19% 39.91401 -1.72% 4.96% 126 2010 796% 15.162 963% 40.97546 0.04% 37.145435 436% 37.58877 5.03% 136 783% 15109481 -481% 41.64192 163% 35.525284 438% 39.64200 20% 11.26% 138 135 1.50% 16.19111: 7.22% 30.698354 428% 34.22550 -3.66% 37.00162 0.44% 140.7950 1.93% 23:14905 42.97% 39.90086 0.10% 33.343723238% 40.10020 8.37% -0.49% 145.1815 1.11% 234503 1.30% 40.175594 0.69% 34.281464 2.83% 40.26526 0.41% SONY 14803933 -1.48% 24.09946 2.73% 41.3932% 3.04% 35.121159 2.43% 41.54112 3.17% 5345 152 128K 653% 23.535058 2.319 43.97621: 6233 33.20910 3.33% 40.18131 -3.27% 4.49% 156.99 39% 2 MOIS 10.73%. 43.133766 -1.92% 35.4631198.24% 43.2287 2.32% 158.0718 0.08% 26331 3.00% 40.971237 3.01% 338926 1.67% 44.85159 401% 145% 2015124 1.07% 35.481341 067% 30.5914 19% 37.171506 083 5.73% 23.72205 10.97% 4.6842834.19% 5.20931% 4.37% 3.5457545 400 22.52% 1159.6735 1745% 248148 12.30% 435.7%80%801% 167.001714.22% 4465811 9.99% 1985% 82.175612 13.30% 21.29785 3019 16326 1457% 047691 15.12% 12.22957 16.97% -5.629 478% 3.99% -1.03% 0.63% 0.76% 1.17 0.7% 2.67% 11/2016 31/2016 4/1/2016 5/1/2016 6'1/2016 71/2016 8/1/2016 WI/2016 10/1/2016 11/1/2016 0.72% -3.77% -1.53% 72.18 6. 3.51% 1.75% 2.50 0.5% ..017 1.29% 1/11/2017 2/1/2017 11/2017 4/1/2017 5/1/2017 6/1/2017 71/2017 2/1/2017 W1/2017 10/1/2017 11/1/2017 12/1/2017 mohly average monthly yearly are yearly 1. 2619 2. 5.10% 1.24% 5.64% 147 | 195598 / Mean of monthly 04 Sufmothly 04: Mean of anual 04 Samlet 1.24% 0.0095584476 0.148669256 0.1023762439 05 . . S Name 1 ALL 2 COG 3 CNP 4 DL.TR S HST 6 INI 7 7 JPM RMCE 9 NRG 10 30 11 TIX 12 VZ 13 EWP Amal Sud Among reum 14.73% 22.31% 28.36% 2.11% 16,71% 1342 23.81 % 22.33% 20.12% 10.66% 13.05% 17.54% 19.85% 22.52% 13.30% 12.45% 2018 1280% 14.53% 8.01% 15.12% 14229 16.97% 9999 10.24% 0.1456675056 Date 04 ALL 12/1/2012 5.29 487 6.306 31 - 1095 1.39% 4. 3 2.97% 2/1/2013 31/2013 4/1/2013 5/1/2013 1/2013 11/2013 W/1/2013 91/2013 10/01/2013 11/1/2013 12/1/2013 1/1/2014 2/1/2014 31/2014 4/1/2014 S/1/2014 544999 0.0 2.50% 3. 2 2 2319 0.29% 1.47% 3105 -0.0994 339 -1.48% 2415 00% TV1/2014 1/2014 W1/2014 10/1/2014 2014 12/1/2014 1/1/15 2/1/2015 31/2015 4/1/2015 521/2015 61/2015 7/1/2015 11/2015 W1/2015 10/1/2015 11/1/2015 12/1/2015 -0.49% 2015 mely returns COG 33.947312 37.699556 38891151 40% 7.22% 41.559956 0.39% 40.993195 207 4L1017 0.26% 43.544556 5.94% 40.990955 -6,00% 43.404156 43.339376 497% 46.5143 228% 41.645775 0.95% 44.164207 -6.12% 46.904249 5.99% 49.060551 49.381356 0.45 56.512214 51.16119 1.294 50.92953 53.574519 5.29% 53.713138 0.26% 56.759014 5.67% 59.642293 61.799799 3.51% 61.335514 0459 62.04700 1.16% 62.513900 123% 61480414 2.12% 59415379 57.509109 321% 61.126152 51.666852 -15.47% 51.902999 045% 55.546606 6.25% 55.930547 1.42% 55.598774 54.26453 -2,40% 56.825542 4.22% 60.639579 6.71% 55.551456 3.44% 60.76.5597 3.79% 62.961933 361% 61.805201 52.375763 0.92% 62.878456 0.81% 61.715054 -1.85% 63.55104 2.97% 67.6T12S 6.49% 68.672287 1.47% 75.018143 924% 14.349141 -0.36% 74.566292 -0.25% 79.199593 31.124356 2.43% 333219 33.JT1258 0.5% 85.017238 1.97% 86.821495 * 2.12% 94.961594 97.214601 2.37% 58.76489356 14.3660584 4.25% 703.1787219 22.31% 19.76549611 14.73% monthly retums CNP monthly DLTR mobily HIST monthly INJ 22.955468 13.685558 40.560001 11.401415 2432 14581595 6.18% 39.990002 -1.41% 12.28TOS 7.72% 21 64136 174 15.235407 45.189999 13.00% 12.199212 0.71% 31.25523 9.0% 17.129 12.92% 7.17% 12.799294923 3145 0.63% 17.720203 3.00% 47 34000 80% 13.449264 5668% 32.526535 16.6543211 5.08% 48.040001 101% 13.09591 2.63% 17.01.2003 2.22% 50.84 5.83% 12.418666 -5.17% 35.061119 6.76% 17.975154 5.66% 53.650002 5.53% 13.235655 6.58% 35.189457 16.067 -7618 52.700001 -L77% 12.6.2009 14.531114 17.519495 5.41% 37.16 11.6967 3.7% 32.662644 -3.366 17.9925 2.63% 590002 2.17% 1399 3. 31.87MOT 12.116018 4.26 55.650002 -4.71%. 13.134541 -0.75% 35.886227 17.075342 -0.24% 133% 14.503250 5.99% 37.015766 3.19% 17.237402 0.95% 90.52 -10.48% 13.812354 -4.76% 32.421047 -124195 17.421562 1.97% 34.77 41% 14.7737616 31.35353 3.2018 17.629118 1.1998 52.18 -4.73% 15.201881 2.90% 35.355 15. isors 18.425365 4529 52.07 -0.21% 16.22583 6.74% 33.5601 17.099104 -2.58% 53.629993 1.84% 16.694325 2.99% 31.541445 -5.74 19. 1985 6.96% 54.459993 2.1% 16.649436 -0.22% 30.1527 -3.49% 18.281757 -4.78% 54.470001 0.02% 16.55773 0.53% 31.98538 1.79% 18672681 2.14% 5830001 154% 17.38255497 3031995 18.575TR -0.52% 36.00 4.59% 16.245464 -6.53% 28841427 18.605307 0.33% 6057 8.00% 17.922323 10.32% 30.540543 IR 123441 683000 12.86% 17.8 -0.30% * 214134 11.9552 -1.20% 7.3799 2.95% 18.2760 2289 24.391457 -10.30 17.694645 -145% 7099999 102 11,723 2.66% 26.930317 9.SIS 15.0320N 1.63 12.07% 16.320934 -8.26% 27.422413 15.R13158 -4.79% RL 150002 1.84% 15.63545 -3.00% 31.406328 14595 16.247032 2.74% 76.410004 3.84% 15.66457 278 31.536329 0415 15.782168 -2.86% 74.999 -1.86% 15.635911 -1.09% 29.306118 -7.07% 14928717 541% | 789999999 3.33% 1534513 0.43% 24.307165 -17.00 15. 171900 1.53% T 029999 1.22% 15.363273 1.30% 21.99826 14.02078 -3.22% 76.260002 -2.29% 14.055251 -8.51% 20.327253 -7.58% 1433518 -1.86% 660004 -12.39% 12.533201 -10.83% 20.15773 -0.07% 14.740006 2.33% % 65.439948 -1.76% 13.900391 10.98% 17.509718 135 -3.63% 75.4599 15.229. 13.323444 4.21% 16.46615 -59716 147997 77.220001 2.33% 12.31214 7.39% 19.312 14.64 2.67% 812 5.31% 11258145 -8.55% 19.755127 -2.9% 15.017386 4.25% 80.25 -1.32% 12.445866 10.54% 21.15916 12.62% 17.10169 13 82.459999 2.75% 13.57576 9.68% 21.80128 3.0 17.53492 2.53% 19.709999 -3.33% 13 LVM 4.10% 22.33257 2.4.1% 18.01789 5.03% 90540001 13 99% 12.61410120539 24.901556 7.47% 19.852242 7.795 % 942399 4.09% 13.340723 SM 23.001834 -4.10% 19.7802 96.290001 2.18% 14.800043 10.94% 22.966534 ..10 18.54664 82 699997 14.11% 14.566754 % 24.07712 19.436324 4.57% 78.93 4.56% 12.90564 12.63% 19455668 -19.07 19.076443 -1.85% 75.550008 -4.28% 13.080 0.70% 20:54 5.97% 19.93335 160004 16.09% 15.075015 15.25% 21.821281 STIS. 20050655 4.44% -12.49% 15.120014 561% 20.065115 22.179205 6.37% 77.1992002 0.01% 15.4789 2019 20:479912 2.034 23.118502 7669 061540619 0.4% 22.355.306 2.18% 23.566672 2.32%. LS.186.3.72% 21.728777 -2. 2437484 2.799997 59% 15.5417112.79 29.747055 24.45587 0.28% 77.699997 619% 15.54344 0.22% 23.497395 13.20 23.635469 -3.35% 9919928 -10.01% 15,1878 1.56% 23.390646 2.96% 72.09.2002 3.099 16.330084 3.23% 23.937235 25.501126 5.01% 19.63999 10.49% 15.857511 -2.29% 25.113535 4915 25.451674 461 26.22 9.02% 16.161312.04% 26.005421 25.774277 1.27% 9125 5.10% 17.39439 69% 29.0995 216.148951 1.45% 102.760002 12.61% 17.0 TS 1.18% 26.897095 -1.01% 24934357 -4.54% 17.3999999 4.43% 17.35094 0.309 26.62752 0.39% 18.55009054 L12% 69,61393452 1.87% 14.789997 0.99% 5.474120033 R.19% 3.40102618 4.82% 15.8192 % 687 1814 SR2% 319 5342356 7.11% - 222.6009053 1342 85.367210 223% 177,47611 10% 16.9.2013 11.78139721 16.71% 55.00933674 23.81% 63562149 20.17% mohly runs JPM mobily SS. 4663 34.514444 SR 503228 5.45% 36.9601 60241631 2.95% 38.730945 68.047775 7.99% 37.575073 67.999794 434% 3892235 67.162048 -1.23% 0.017 2.76% 42.056221 75. 158658 8.90% 69459465 -7395 40 549347 7259 10% 41.490225 75.004128 63% 41.359852 76661421 2.21% % 46.256241 74.695915 2.57% 41.234811 T2 151393 -3.41% 44.752612 75.12612 4.13% 45.23328 067584 7009 49.395302 23.201118 3.12% 45 34985 3340775 0.12% 45.501121 16.585355 3.23% 42.19 82.781405 -4.33% 47.220655 83.799194 364% 49 DIS 8.M1141 3.45% 49.6669834 89.752105 L12% 49.887714 90.143494 17.646172 -2.79% 5194623 83.933113 424% 45.140163 8.019556 SL 1940 84.909 -1.18% 90.600 83.727272 -1.39% 52849141 14.5.2006 0.95% 55 39 82.859528 -1.97% 5694821 85.195503 2.82% 57,6329 19.29395 -6.22% 54.259169 79.971413 0.09% S9642 16.550735 8.23% 16.30 0.21% 56.256348 8.647224 2215 56.296162 90L1316 1.67% 90.72579 90.796104 0.14% 48.322521 1053169 3.39% 50828765 97.425673 3.99 54244812 97.955123 054% 56.06272 106193214 841% 53.729829 10. 3.24% 55312218 10477287 4.79% 104 10785 -0.35% 58 0252 160221904 - 1.81% 6.0.352451 4,04% 70 37125 102.296139 4.23% 75.735815 10069557 -1.79% 74281784 108617861 7.915 79979477 111.255108 2.99% 12.525814 110.29995 76.784515 11450076 3279 72.920009 118.9531 3834 RL131378 119.339844 0335 13 81486427 119.5101 -0.36% RL122463 -1.16% 5245964 126 15275 7 23% 89.797874 126.90405 -0.06% 98.833 1.27.207559 0.89% 9.005562 99.16774436 56.3274 19.2174909 3.79% 15.2096652 1062.012932 17.54% 675.9295934 61.3751885 1305 52.6854055 MOD mohly NRG more 50 monthly TIX monthly VZ maly WP 19.768747 26.9483% 19.00 29.31242 7.00 74.091 8.03% 20.63723 4.39% 29.508563.32% 20.29724. 6.43% 29.54275 0.999% 4.69% 75.3997 0.64% 20.7153 03% 30774641 2.90% 20.20293 0.46% 31.62832 797 -2.98% 78980045 4.79% 22864521 10.39% 32.06057 4.24% 2145996 4.22% 30.623 327% 0.92101 2.46% 24.0556 521% 32.976251 2.79% 21.965755 432% 35.84600 12.05% 76.508200 -545% 22.122350 8.04% 30.01 STOC -3.98% 22.79443.77% 33.57359 -9.13% -3.30%. 19.042574 3.32% 23.14525 4.62% 30.49616 1.60% 22.611500 0.80% 34.88168 3.84% 5.57% 78.313301 0.45% 30.486813161% 23.5058363.96% 34.25611 -1.71% 367% 75.400 3.79 22855316 169% 21.76162 -7.18% 23.8129 131% 33.14450 2.30% 77,40 2.78% 23.795161 4.115 28.730.07% 25.541357 0.07% 25.54135726% 32.6476 1.30% 4.29% 77.601 0,32% 2484100 439% 28.59428 966% 27.53430 780938.23413 11.84% 76.35IS 0.86% 23.1331 -6.87% 26.745414 0.53% 26.480454 3.44% 35.10497 -0.65% 2.20% 78 790) 0.48% 25.109701 8.54% 20. 1.18% 26.933966 1.59% 34.76530 -0.07% -5.34% 16,42914 -2.99% 2434906 3.03%. 29. 17800 0.32% 26.041924 -10.00% 33.97301 331% 77,224556 194% 25.52836 44% 30.339523 3.98% 27.90335: 7.15% 34.02753 685% 0.23981: 3.90% 27.92576 939% 31.474594 3.75% 2.60015 08% 34.62037 -7.79% 82.981560 342% 28.7336 2.89% 32.53259 4.30% 26.4790407% 39.4196 1.77% -0.11% 83.00227 0.05% 31.431394 9.39% 31.36367 4.47% 24.78139. 6.41% 36.12754 8.10% 3.694 3.122265 0.12% 2.IR 4.33%, 325I 4.86% 24.26066 2.10% 35.30271 0.09% 78,0233% -6,13% 27.3640-16.77% 31.37232461% 2432456 0.26% 36.46017 3.03% 31% 77.33029 -989% 27.267937 0.13% 32.5619 3.79% 27.20937: 18% 35.41423 0.13% 1.39% 7890494 2.04% 27.00219 -0.97% 32011919 -1.69% 27.0955 4.42% 36.53849 0,40% 78.000111 -1.14% 26.53921 -1.61% 33.9999 621% 28.995994701% 35.72852 0.52% 0.14% 80.56942 3.29% 27.6.2641 4.77%.35.1819 3.45% 30.296518 449% 37.39094 1.80% 4.02% 78.670541 -2.36% 23.839 -1.7993642011 3.54% 31.490805 3.94% 34.57502 -7.53% 13.10% 77,612642 -1.34% 2195141430% 37.62237 : 328% 30.278561 35% 33.78419 2299 13.41% 83.086461 699% 21.472610 -2.18% 33.56.5481 -3.72% 31.5183594.09% 36.9808 9.66% -1.14% 12.521584 -0.62% 22.5560 5.09% 33.20901: 2.23% 32.24943 2.32% 36.35757 -1.66% 4.42% 51.76762 -0,91% 22.00 0.29% 33.240 009 21.71274 9.05% 29.71274 787% 37.72116 3.72% -0.64% 223541 0.41% 32.766521 -1.38% 29.63903025% 37.39071 3.01% 81.21416 -0,04% 20.60429 -921% 31.622393 288% 30.59916 3.10% 35.25042 -3.72 114% 85.3603 5.94% 20 2170 -1.89% 33.971723 6.75% 32.244543 6.75% 32.244543 552% 35.4650 0.99 -585% 1.17144 485% 18.05772 -10.68% 32.215 2.95% 32.475346 0.72% 35.20646 -0.51% 488% 491143 461% 13.461 70 33.459 34.34916 4.19% 33.002771X7% 33.29344 5.40% 5.35% 96.750T 13.92% 11.684343 -13.20% 34.68688 089% 33.96066 2.41% 35.5721 7.25% 4.53% 9.38101: 1.70% 11.33057 -3.03% 34.226511 -24% 32.742934 354% 35.22973 -1.9 -9.97% 102.6092 430% 1078971 4.77% 3639436 6.33% 32.94138 0.73% 35.62657 -98944 07077 4.27% 9.753831 -1.60% 3.01130 4.59% 3.0246 0.47% 38.73332 8.11% 4.14% 101.78413 -5.32% 10029213 2.82% 37.47554 -51% 34.423306 4.01% 39.80608 2.72% 5.19% 109.99.49 5.96% 12.103901 20.69% 40.68576 857% 36 51637 6.06% 42 4347 6.72% 110.6351 0.64% 14.0483 16.08% 39.40379% -3.19% 35.331424 323% 39.97085 S.RS 4,04% 1068170 3.50% 15.26977 3.69 3.28 132% 35.471223 0.40% 40.35107 -490% 105.31111 -141% 139739 9.70% 16.109160 120% 44.27823 9.715 2.94% 108.7145 -1.52% 12.90195 -7.67% 42.55142 -24% 36203484 581% 43.92728 -0.72% 6.34% 100% -1.69% 11.313462 12.31% 40.2350 4,06% 36.20735 324% 41.91391 4619 -1.39% 102.4861 0.52% 10472661 -7.43% 41.283364 101% 35.075454 3.13% 41.63356 -0.62% 4.01% 100.00SC -5.17%. 41.455400 0.53% 34.59232 -1.35% 38.52587 -7.4% 1639% 106.95975 5.99% 10.62455 6.999 37.63703-921% 36 745251 622% 40.42339 1.63% 10.97730 2.85% 11.486511 8.11%. 46.00 6.29% 35.365000 3.76% 43.2425 6.9794 192% 109.73831 0.70% 15.495491 3491% 40.1999 0.49% 35.266151 028% 39.70241 8.19% 7.67% 114.2545 4.14% 15.54057 0.30% 41.33041 281% 3692778 4.71% 40.63451 -3.07% 116.6954 2.28% 17.552321 12.92% 40,9589% -4.90% 37.353256 1.19% 39.91401 -1.72% 4.96% 126 2010 796% 15.162 963% 40.97546 0.04% 37.145435 436% 37.58877 5.03% 136 783% 15109481 -481% 41.64192 163% 35.525284 438% 39.64200 20% 11.26% 138 135 1.50% 16.19111: 7.22% 30.698354 428% 34.22550 -3.66% 37.00162 0.44% 140.7950 1.93% 23:14905 42.97% 39.90086 0.10% 33.343723238% 40.10020 8.37% -0.49% 145.1815 1.11% 234503 1.30% 40.175594 0.69% 34.281464 2.83% 40.26526 0.41% SONY 14803933 -1.48% 24.09946 2.73% 41.3932% 3.04% 35.121159 2.43% 41.54112 3.17% 5345 152 128K 653% 23.535058 2.319 43.97621: 6233 33.20910 3.33% 40.18131 -3.27% 4.49% 156.99 39% 2 MOIS 10.73%. 43.133766 -1.92% 35.4631198.24% 43.2287 2.32% 158.0718 0.08% 26331 3.00% 40.971237 3.01% 338926 1.67% 44.85159 401% 145% 2015124 1.07% 35.481341 067% 30.5914 19% 37.171506 083 5.73% 23.72205 10.97% 4.6842834.19% 5.20931% 4.37% 3.5457545 400 22.52% 1159.6735 1745% 248148 12.30% 435.7%80%801% 167.001714.22% 4465811 9.99% 1985% 82.175612 13.30% 21.29785 3019 16326 1457% 047691 15.12% 12.22957 16.97% -5.629 478% 3.99% -1.03% 0.63% 0.76% 1.17 0.7% 2.67% 11/2016 31/2016 4/1/2016 5/1/2016 6'1/2016 71/2016 8/1/2016 WI/2016 10/1/2016 11/1/2016 0.72% -3.77% -1.53% 72.18 6. 3.51% 1.75% 2.50 0.5% ..017 1.29% 1/11/2017 2/1/2017 11/2017 4/1/2017 5/1/2017 6/1/2017 71/2017 2/1/2017 W1/2017 10/1/2017 11/1/2017 12/1/2017 mohly average monthly yearly are yearly 1. 2619 2. 5.10% 1.24% 5.64% 147 | 195598 / Mean of monthly 04 Sufmothly 04: Mean of anual 04 Samlet 1.24% 0.0095584476 0.148669256 0.1023762439 05 . . S Name 1 ALL 2 COG 3 CNP 4 DL.TR S HST 6 INI 7 7 JPM RMCE 9 NRG 10 30 11 TIX 12 VZ 13 EWP Amal Sud Among reum 14.73% 22.31% 28.36% 2.11% 16,71% 1342 23.81 % 22.33% 20.12% 10.66% 13.05% 17.54% 19.85% 22.52% 13.30% 12.45% 2018 1280% 14.53% 8.01% 15.12% 14229 16.97% 9999 10.24% 0.1456675056