Fama French Three Factor Model Analysis

Anonymous
timer Asked: Feb 24th, 2019
account_balance_wallet $45

Question Description

Problem 4: Fama-French Three-Factor Model. [50 points]

Download the Excel spreadsheet Portfolio_Returns.xlsx from Blackboard. The file contains the monthly excess returns in percent of a wide range of stocks and of QQQ (Nasdaq ETF), IWM (Russell ETF), and MCHI (China ETF).

Since some companies have not been publicly listed for the entire time period from January 2014 to December 2018, we cannot use them for our analysis. Please research the QQQ, IWM, and MCHI ETFs to see if you can use them as a replacement for missing stocks. For example, Alibaba (BABA) has not been listed for the entire time period, however, MCHI can serve as a decent albeit not perfect replacement in your analysis.

Additionally, the file contains the time series ExcMkt, SMB, and HML, representing the excess market return, the small-minus-big return, and the high-minus-low return.


For the following part, consider only your three largest holdings by market value.

1.Calculate using the single-factor model.

2.Estimate their risk (systematic and firm-specific) according to the single-factor model.

For the following part, consider your entire portfolio.

3.Calculate the weights of the stocks in your portfolio. Remember, stocks you’re selling short have negative weights, and the weights need to sum up to one.

4.Produce a time series for your portfolio of n stocks return using .RP(t)=w1R1(t)+...+wnRn(t).

5.Estimate your portfolio’s sensitivity to Fama-French’s three factors, that is, run the regression

RP(t)=αPmRm(t)+βSMLSML(t)+βHMLHML(t)+eP .

Remember: βm is a proxy to how much market risk your portfolio carries; βSML is your exposure to small over big firms; βHML is your exposure to firms with a high book value compared to their market capitalization. These three betas are assumed to be non-diversifiable risk factors, and in the long run investors should be rewarded for their risk of having greater betas.

6.Analyze your results. This includes, but is not limited to: classifying your portfolio in terms of aggressiveness, small vs large cap, value vs growth; identifying which of your holdings potentially contribute to the portfolio classification how; going back to your portfolio philosophy statement and discussing if your holdings reflect your investment goal; using the expected values of Rm,SML,HML to compute the expected return of your portfolio in the coming month.

Important:

Submit Problem 4 in a Word document to Blackboard at the specified time which includes the relevant tables from Excel or the data analytics tool of your choice.


All the instructions above are coming from the file: homework 4--problem 4.

Date 1/1/2014 2/1/2014 3/1/2014 4/1/2014 5/1/2014 6/1/2014 7/1/2014 8/1/2014 9/1/2014 10/1/2014 11/1/2014 12/1/2014 1/1/2015 2/1/2015 3/1/2015 4/1/2015 5/1/2015 6/1/2015 7/1/2015 8/1/2015 9/1/2015 10/1/2015 11/1/2015 12/1/2015 1/1/2016 2/1/2016 3/1/2016 4/1/2016 5/1/2016 6/1/2016 7/1/2016 8/1/2016 9/1/2016 10/1/2016 11/1/2016 12/1/2016 1/1/2017 2/1/2017 3/1/2017 4/1/2017 5/1/2017 6/1/2017 7/1/2017 8/1/2017 9/1/2017 10/1/2017 QQQ -1.92133 5.149783 -2.73082 -0.31938 4.485639 3.123602 1.181983 5.009472 -0.7567 2.641968 4.546351 -2.24239 -2.08232 7.220574 -2.36037 1.922348 2.248444 -2.48284 4.557766 -6.82448 -2.20385 11.36989 0.608841 -1.59862 -6.92042 -1.58535 6.831919 -3.19681 4.360034 -2.29526 7.130828 1.030074 2.193546 -1.47721 0.425935 1.10329 5.100108 4.33505 1.996946 2.676998 3.837345 -2.37679 3.991319 1.983588 -0.38469 4.516394 IWM -2.77393 4.778887 -0.74833 -3.74764 0.785855 5.272018 -6.05279 4.829665 -5.93055 6.593507 0.111531 2.891844 -3.27704 5.946413 1.777712 -2.56493 2.236343 0.782953 -1.1007 -6.311 -4.93249 5.622711 3.259927 -5.04133 -8.58752 -0.24339 7.999179 1.662241 2.230398 -0.03739 5.850292 1.764092 1.056843 -4.61705 11.05329 2.858079 0.241795 1.890045 -0.00434 1.099258 -2.03037 3.314413 0.788274 -1.34786 6.212957 0.638843 MCHI -8.9382 3.097244 -0.61851 -2.55612 4.607664 2.718173 6.728488 1.293191 -5.48574 3.862389 1.158301 1.840745 0.338443 5.277778 2.713909 15.00917 -4.515 -5.39375 -10.7066 -11.8705 -0.6576 7.966218 -1.16279 -3.23221 -11.9777 -2.38762 10.82746 -0.57457 -0.05731 1.041952 3.825247 6.204443 3.701129 -2.96845 -0.96602 -5.31853 7.460572 3.576252 2.474619 2.413449 5.041642 2.010336 8.560463 4.269535 1.668065 3.412932 A 1.678615 -2.09802 -1.77411 -3.13239 5.366395 1.109698 -2.35028 1.907648 -0.08201 -2.9835 7.132304 -4.21151 -7.51558 11.75536 -1.32416 -0.43321 -0.4351 -6.10245 6.143079 -11.3309 -5.1786 9.991261 10.75212 0.241076 -9.95977 -0.81681 6.67344 2.968018 12.13565 -3.10346 8.433562 -2.36878 0.458927 -7.49505 0.931014 3.862152 7.444636 4.718015 3.287739 4.073321 9.549446 -1.54634 0.739307 8.155526 -0.89346 6.091355 AAPL -10.7697 5.747445 1.995287 9.939636 7.871993 2.766295 2.87313 7.750938 -1.70732 7.19603 10.59651 -7.1891 6.142417 10.07459 -3.13716 0.578639 4.531234 -3.72659 -3.28882 -6.62053 -2.18162 8.340888 -0.57847 -11.0328 -7.53423 -0.15305 12.70107 -14.0021 7.169934 -4.28597 8.986276 2.341806 6.530424 0.413437 -2.16468 4.765512 4.73465 13.33427 4.838969 -0.05696 6.716979 -5.78139 3.200379 10.62418 -6.11439 9.590768 ACLS -0.81967 -7.85124 -3.58744 -16.7442 5.027933 6.382979 -12.5 15.42857 -1.48515 9.547739 -1.37615 19.06977 -6.25 16.66667 -15 5.882353 26.98413 -7.5 -0.33784 10.50847 -18.0982 4.868914 -5.71429 -1.90394 1.148301 -4.60015 11.98 2.132857 -5.60441 -0.39037 -0.57762 9.606168 13.19398 2.766145 -0.01 6.563407 4.427354 1.604737 21.65285 2.343617 12.92701 -3.73816 5.896587 -5.94586 30.77124 20.2025 AMT 1.327988 0.729476 0.490978 2.415941 7.315613 0.776437 4.901089 4.460218 -4.68133 4.133291 7.702564 -5.50325 -1.9221 2.258896 -5.03329 0.840465 -1.84069 1.018334 1.950906 -3.07013 -4.08099 16.19686 -2.78783 -1.94685 -2.70211 -2.28839 11.01037 2.936171 0.848124 7.913006 1.881241 -2.08444 0.42401 3.385983 -12.7415 3.869565 -2.10283 10.86821 5.850303 4.094738 4.108652 1.294593 2.960532 8.506787 -7.32214 5.024135 AMZN -10.0554 0.950682 -7.10715 -9.58334 2.768553 3.912974 -3.63015 8.32295 -4.89618 -5.2661 10.86231 -8.354 14.23554 7.229289 -2.12016 13.35125 1.766324 1.13226 23.51125 -4.33834 -0.19497 22.27236 6.21505 1.658171 -13.1615 -5.89394 7.422265 11.09943 9.57171 -1.01199 6.015326 1.343978 8.840315 -5.69173 -4.97949 -0.12326 9.776368 2.578157 4.88101 4.287086 7.467649 -2.7364 1.973388 -0.81688 -2.05308 14.88165 11/1/2017 12/1/2017 1/1/2018 2/1/2018 3/1/2018 4/1/2018 5/1/2018 6/1/2018 7/1/2018 8/1/2018 9/1/2018 10/1/2018 11/1/2018 12/1/2018 1.891738 0.511371 8.647062 -1.4028 -4.1957 0.365839 5.532922 1.005395 2.636388 5.620674 -0.43226 -8.78573 -0.44499 -8.84434 2.861176 -0.48994 2.448048 -3.95369 1.102996 0.841361 6.023579 0.474364 1.487702 4.150605 -2.47241 -11.1778 1.546321 -12.1552 1.35951 1.667435 12.31861 -7.609 -1.0304 -2.64839 2.821855 -5.8495 -1.36743 -4.98607 -1.54941 -11.277 7.763662 -7.74882 1.698627 -3.15326 9.53611 -6.70131 -2.58392 -1.64668 -5.95077 -0.2692 6.890578 2.111351 4.291812 -8.14935 11.48847 -6.71698 1.949004 -1.61459 -1.17364 6.703262 -5.92508 -1.64197 13.37406 -1.08183 2.638336 19.88346 -0.98029 -3.23775 -18.2988 -11.8598 -2.81556 -10.4025 -9.8661 -5.70846 0.493497 -10.7091 -3.54909 -6.96353 10.95111 -8.34182 -2.87277 -12.3528 15.23136 -10.8326 0.10097 -0.47526 3.415619 -5.77689 4.1935 -5.80649 1.334039 4.632052 2.663056 0.433632 -2.17486 7.04331 5.390888 -3.50721 6.386235 -0.70865 23.95389 4.132913 -4.42494 8.06747 3.913942 4.166525 4.407596 13.07645 -0.63243 -20.4092 5.587173 -11.325 AXP -6.05235 7.362973 -1.36941 -2.64085 4.655153 3.68306 -6.98693 1.761364 -2.24456 3.064364 2.74597 0.67085 -13.0242 1.11538 -3.93431 -0.85765 2.930923 -2.14501 -2.13587 0.867736 -3.37591 -0.80228 -2.2113 -2.92736 -22.7406 3.86785 10.45139 7.069607 0.494356 -7.17405 6.069533 1.717512 -2.36828 4.212109 8.451307 2.80176 3.497397 4.778015 -1.21661 0.53922 -2.97483 9.427913 1.486602 0.930767 4.973879 5.909049 B -2.27095 3.007744 0.052016 0.129971 -2.67955 3.103264 -11.1313 0.285266 -11.361 20.46129 0.787941 0.76232 -7.18725 16.85739 1.174413 -0.9632 0.699448 -3.1545 -0.15389 -0.4494 -6.67875 4.271845 2.796985 -8.13565 -8.14789 5.894462 2.078514 -7.26093 3.160566 -0.82863 14.50295 9.312568 -1.93098 -1.77092 16.28431 2.610693 1.457259 4.342406 2.4246 7.02051 3.146982 3.368168 2.749067 4.036963 12.57795 -7.68512 BA -8.22771 3.508303 -2.66056 2.812973 5.415782 -5.92976 -5.30535 5.894909 0.457413 -1.93908 8.197574 -3.2599 11.84028 4.40808 -0.51044 -4.49094 -1.33484 -1.28096 3.928777 -8.78795 0.206612 13.07369 -1.16622 -0.60127 -16.9268 -0.7217 7.392422 6.181902 -5.65995 2.92887 2.898303 -2.37173 1.749023 8.094468 6.508347 3.370638 4.931737 11.2024 -1.89983 4.456389 2.241843 5.333594 22.53936 -0.64579 5.981101 1.393026 BAC 7.578677 -1.31343 4.113557 -11.9767 0 1.584863 -0.78074 5.508197 6.295527 0.645161 -0.6993 5.291873 -15.3158 4.356436 -2.34928 3.508772 3.578154 3.456156 5.052879 -8.61298 -4.35038 7.702182 3.873659 -3.17834 -15.9934 -11.4769 8.369857 7.682308 1.638352 -10.0561 9.17367 11.88476 -3.05594 5.41131 28.44455 4.610152 2.403439 8.970601 -4.1654 -1.10977 -3.72324 8.195243 -0.64708 -0.54564 5.979485 7.999976 BDX -2.14499 6.566778 2.095197 -3.45917 4.131646 0.97098 -1.74134 0.800069 -2.41214 13.08321 9.036519 -0.40808 -0.77609 6.257242 -1.72801 -1.89428 -0.25555 1.243286 7.412637 -7.31515 -5.50802 7.432534 5.4238 2.983276 -5.66903 1.410832 3.405406 6.20789 3.208405 2.265249 3.759704 0.6675 1.778609 -6.59653 0.698713 -1.69355 7.051513 3.208914 0.580511 1.874335 1.14875 3.438151 3.153822 -1.06319 -1.48051 6.401452 BHP -6.23167 7.740422 0.079165 4.087354 -3.77091 0.839717 3.85683 -3.4604 -12.6235 0.951087 -13.1393 -8.34786 -2.09214 13.36067 -9.11231 10.37228 -12.985 -8.78333 -5.74797 -4.01355 -11.0186 4.016445 -18.8811 -3.45828 -14.9557 3.174888 15.89074 20.99386 -13.9538 5.875439 3.936583 1.967201 15.48 1.047821 7.185888 -4.71833 15.35966 -8.44397 -1.88784 -2.03238 -1.49258 1.364907 16.98535 4.326707 -5.10268 1.020289 BLK -5.05577 1.454388 3.810691 -4.28644 1.295681 5.473997 -4.65269 9.103114 -0.66862 3.89559 5.268095 0.118011 -4.76843 9.07756 -0.92065 -0.51935 0.505578 -4.83277 -2.79207 -9.41663 -1.65306 18.32118 3.338353 -5.82431 -7.72173 -0.75188 9.924711 4.617536 2.100403 -5.28256 6.904941 2.396382 -2.79621 -5.87444 8.649594 3.201631 -1.76387 3.564471 -0.41764 0.226394 6.354957 3.782393 0.905356 -1.26694 6.611511 5.219893 BRKB -5.87045 3.74552 7.937468 3.104745 -0.39581 -1.38694 -0.89286 9.423583 0.648452 1.462285 6.085902 0.981909 -4.15584 2.432076 -2.09619 -2.15493 1.267616 -4.81818 4.87106 -6.095 -2.71561 4.309816 -1.41891 -1.53882 -1.72918 3.370614 5.726441 2.527356 -3.40566 3.00405 -0.37914 4.291361 -4.02027 -0.13767 9.096029 3.488801 0.671744 4.395238 -2.79514 -0.93193 -0.01763 2.414589 3.236371 3.447749 1.102316 1.884689 C -8.96216 2.530044 -2.11803 0.651261 -0.68887 -0.98802 3.864119 5.602126 0.329138 3.31932 0.821969 0.259403 -13.2141 11.65069 -1.7169 3.493789 1.520484 2.14497 5.918978 -8.51865 -7.23635 7.275838 1.730299 -4.33612 -17.6279 -8.77998 7.444607 10.95891 0.616621 -8.99574 3.704982 8.950555 -1.08829 4.045213 15.10134 5.361027 -6.09755 7.394975 -0.01328 -0.95392 2.341894 10.41241 2.277488 -0.23678 6.833416 0.954817 CAT 4.088085 3.258439 2.474992 6.686523 -3.00759 6.299521 -6.6931 8.258065 -9.2051 3.172106 -0.79874 -9.0159 -11.9044 3.663874 -3.462 9.460304 -1.79558 -0.58603 -6.4456 -2.7852 -14.495 12.88697 -0.46582 -6.46561 -7.24884 8.752494 13.03761 2.525665 -6.71355 4.531096 10.20076 -0.99873 8.302148 -5.16608 14.48796 -2.98103 3.959594 1.005369 -4.06476 11.08823 3.039941 1.865448 6.741949 3.016626 6.055204 9.449222 2.212714 1.547499 0.32799 -2.01141 -4.45802 6.117403 -0.5957 -0.44519 1.751752 6.331158 0.331223 -3.37165 9.106479 -15.2875 1.953761 -4.61694 3.87293 -8.23944 -0.8164 -7.42001 7.150427 -1.01513 15.03525 0.384492 4.213797 -20.5054 6.204692 -10.8977 7.795113 6.45263 20.05208 2.632569 -9.59793 1.592341 5.960913 -4.86796 6.036537 -3.47311 8.34208 -4.77188 -2.01192 -7.18619 3.205871 4.702332 8.291084 0.2025 -6.33707 -0.37341 -2.68011 -3.067 9.382391 0.001917 -4.43955 -6.84309 3.092727 -12.9342 9.284068 -5.96744 13.38154 -8.72118 -2.18856 6.860461 -4.57352 8.322425 4.352439 4.433202 -0.18984 -11.8758 9.472928 -10.7498 1.310922 10.59592 6.478389 -5.25076 -2.22031 5.081697 6.341283 0.322033 4.3391 -8.23501 6.496635 -7.5335 -4.1211 8.669333 6.368187 2.918422 9.251313 -2.31185 -1.00572 -3.87256 2.301035 -6.23955 0.585431 -4.87398 -1.11109 -12.8846 3.852376 -7.69402 3.167031 2.609342 8.042558 -3.45919 -3.84587 -3.02249 -1.2756 -2.6879 5.851251 5.323398 2.432407 -4.31405 6.133328 -6.63245 3.084988 -1.53371 5.359695 -3.52024 -10.7042 1.000741 -1.99424 0.204879 7.266778 -0.44815 0.551853 -8.94383 -0.52787 -19.8381 3.859617 11.5501 3.662735 -5.11676 -4.80861 -1.69058 5.089981 -10.8305 6.486287 -3.60228 9.673551 -20.1097 11.64822 -6.52891 CMG 3.599985 2.400536 0.502468 -12.2436 9.747242 8.302108 13.50019 0.914498 -1.77706 -4.28899 4.015674 3.147886 3.700457 -6.32114 -2.17002 -4.48858 -0.93669 -1.71075 22.68467 -4.34097 1.442233 -11.11 -9.47784 -17.213 -5.61175 12.3848 -7.52059 -10.6264 4.976104 -8.88958 5.251129 -2.43987 2.341443 -14.8346 9.849741 -4.82651 11.65299 -0.68066 6.365377 6.448025 0.546993 -12.8913 -17.4528 -7.96154 -2.89383 -11.762 COTY -11.541 10.08154 0.875421 7.142857 3.925234 2.697842 -0.11675 0.467563 -2.57283 0.302115 21.92771 2.075099 -7.93804 18.82229 7.389381 -1.48331 4.265997 28.23907 -16.3904 13.39319 -9.84932 6.984479 -4.04145 -7.74938 -3.98971 15.70531 -2.3023 9.224639 -13.3653 -1.34878 3.365918 1.275266 -12.8215 -2.19021 -18.6268 -1.50126 4.820732 -1.57227 -3.49113 -1.5944 6.742314 -1.01037 9.098443 -18.5208 -0.39157 -6.92606 CSCO -1.56351 -0.50205 2.821101 3.948616 6.533968 0.9342 2.299872 -0.95125 1.480592 -2.78109 12.95464 0.63314 -4.56073 11.92869 -6.01491 4.741144 1.664932 -6.31184 4.290662 -8.93737 1.429675 10.80177 -5.54593 -0.35862 -11.7052 10.02624 8.727135 -2.56007 5.664791 -1.25924 7.369999 2.960675 0.870585 -2.50035 -2.81313 1.311382 2.492612 11.22302 -1.14176 1.623754 -7.51524 -0.78946 1.345877 2.326534 4.318569 2.336873 CXO -9.4537 23.86747 1.131016 6.489796 1.034879 9.635812 -2.56055 0.880682 -11.7221 -13.0473 -12.6387 4.724409 11.12782 -1.74109 6.426735 9.26501 -5.02132 -5.35328 -6.41138 1.501502 -9.11612 17.91455 -5.58192 -15.1599 2.43454 -5.16033 11.94809 14.96427 4.440374 -1.72595 4.113479 4.005765 6.28805 -7.59918 12.6574 -7.31569 5.118371 -5.05291 -3.13306 -1.35902 0.034742 -4.20103 7.113412 -14.8988 18.60875 1.800374 DAL 11.43065 8.706898 4.336043 6.291486 8.532773 -2.98171 -3.25413 5.923372 -8.66599 11.28631 16.25731 5.399614 -3.82192 -5.71019 0.98832 -0.71174 -3.65665 -4.28705 7.935735 -0.97507 2.489721 13.3051 -8.37174 9.094606 -12.6358 9.240525 0.892106 -14.4102 4.61773 -16.1958 6.348378 -4.65484 7.082041 6.102967 15.86048 2.066306 -4.00422 6.074572 -7.98113 -1.18142 8.519217 9.323269 -8.22035 -3.87638 2.092666 3.663629 DDAIF -3.8196 10.52632 2.564935 3.474187 2.576542 -1.87073 -11.931 -0.74182 -6.51801 2.188729 7.605489 -1.78784 9.356796 6.847187 2.840887 -0.13974 -2.39453 -2.32583 -3.02272 -9.7993 -9.44686 19.29993 2.732712 -6.32125 -16.2766 -2.97961 13.01516 -5.25699 -2.22474 -12.0628 13.17167 1.783725 2.135048 1.027713 -6.97371 11.64169 1.443479 -3.53502 10.95805 0.412489 -2.37134 -0.32135 -3.39368 3.890029 9.225407 4.963966 DIS -4.96073 11.29321 -0.91573 -0.9117 5.88606 2.059279 0.163284 4.657662 -0.94571 2.63956 1.236594 3.092188 -3.42924 14.42392 0.778248 3.651444 1.51766 3.415783 5.736743 -15.1 0.314095 11.29159 -0.23738 -6.8104 -8.82233 -0.33309 3.947755 3.967444 -3.92245 -1.43101 -1.224 -1.57289 -1.71384 -0.20307 6.927102 5.908597 6.129641 -0.5461 2.967547 1.899025 -6.6863 -1.62568 4.174386 -8.03142 -2.68881 -0.86103 DUK 2.332995 1.472826 0.479684 4.591407 -3.53347 4.375352 -2.77665 3.728403 1.054197 9.870269 -0.54114 3.263288 4.309313 -8.98216 -2.25334 1.028914 -1.32941 -6.74766 5.097706 -3.41656 1.452545 -0.65332 -4.02998 5.347143 5.466958 -0.33282 8.596047 -2.36498 0.361777 9.643812 -0.25313 -5.99867 0.457027 -0.04499 -6.75495 5.188924 1.145262 6.236105 -0.68415 0.547488 4.867216 -2.49931 1.760362 3.528666 -3.96171 5.141173 DVN -4.28317 8.780817 4.258658 4.586882 5.571429 7.779917 -4.91184 -0.10596 -9.29257 -11.9977 -1.71667 4.255888 -1.5357 2.190144 -1.67195 13.09899 -4.38352 -8.43783 -16.9272 -13.6787 -12.5195 13.04934 9.730503 -29.9624 -12.8225 -29.4824 40.76131 26.37484 4.055744 0.591771 5.58 13.17227 1.928607 -14.1211 27.54344 -5.41617 -0.32465 -4.827 -3.67134 -5.39516 -14.0129 -5.80668 4.121429 -5.82401 17.02775 0.42757 EA 15.08282 8.295455 1.469045 -2.44743 24.13428 2.106462 -6.32841 12.61905 -5.89323 15.05195 7.224799 7.022536 16.68616 4.228946 2.859391 -1.23268 8.030642 5.967652 7.593985 -7.54717 2.418745 6.376384 -5.93867 1.361884 -6.08538 -0.49254 2.890959 -6.45381 24.08054 -1.3099 0.719176 6.413438 5.113571 -8.07621 0.906964 -0.63575 5.889406 3.639732 3.461329 5.870465 19.4612 -6.7749 10.35376 3.987437 -2.92128 1.214421 11.86925 -5.13616 12.25204 -2.06529 1.356084 30.8773 1.478123 0.136628 0.370867 9.414321 -4.49783 1.088272 2.617993 -8.94298 12.62145 15.34819 -1.51774 -0.96843 -5.3995 -5.33126 -23.0687 6.275094 -5.05362 -7.08564 1.468123 -16.1932 -19.9681 -21.5329 9.144012 2.590965 9.156231 7.689711 -4.34063 3.95128 -3.7074 0.609239 -1.11769 12.79815 1.69216 -5.50951 4.45388 -9.67402 4.12982 7.317407 4.696284 -4.32748 -0.43167 4.436598 -12.7982 0.61741 5.261034 -6.12503 11.22441 -9.13272 -6.47089 -21.327 6.336016 5.730106 1.265 -4.61443 1.568312 -4.86542 3.970798 -8.48413 10.43487 7.300492 -1.26149 -5.55054 11.44628 -17.996 -0.82904 1.697434 8.279996 -6.50319 -1.25054 -2.12202 -7.83304 -11.8106 7.612586 -6.72179 -2.65565 -6.44099 -4.63084 -6.7256 7.086956 3.302896 0.968969 -5.1804 -2.75668 -0.24952 -0.99717 5.228453 9.057047 -1.51611 4.242073 -1.99434 0.394763 -4.5006 1.91264 -5.77513 -6.77984 -3.01452 2.707183 3.332312 -2.72717 2.348336 3.051937 0.50315 -1.65172 3.071685 8.162811 -2.75294 4.337344 7.528397 -0.18246 -25.9742 3.72243 14.14122 14.28334 5.812166 2.228535 -4.7812 -6.93276 -19.0683 -16.7541 -16.5529 -11.1586 -1.30298 20.73523 -2.67774 -2.10868 -2.82888 10.81948 7.582863 -8.86089 -12.0746 6.092836 -24.6817 -7.77508 -6.32774 EGAN -6.44531 -12.5261 -15.7518 -7.36544 0.458716 3.04414 -5.90842 2.511774 -8.11639 -31.6667 25.36585 0.77821 -2.02703 -31.4286 -5.17241 -0.90909 39.14373 10.10989 -10.978 -19.0583 9.972299 15.36524 0.436681 -7.4013 -12.2166 -0.02 -5.10021 4.778732 -13.9885 -11.895 -12.0767 27.80258 -2.54366 -7.78699 -17.5539 -10.6683 9.48381 -21.7791 -19.4744 3.398276 3.273333 6.391613 12.05121 -8.19811 58.73353 22.13222 EL -8.73606 0.440108 -2.84718 8.507775 5.859948 -3.08014 -1.0773 4.859151 -2.74632 0.615632 -1.06028 2.778527 -7.3622 17.45618 0.592718 -2.24868 7.843987 -0.8807 2.827141 -10.2131 1.14078 -0.27268 4.916112 4.673785 -3.20101 7.458745 3.242893 1.644119 -3.96211 -0.84807 2.04548 -3.65335 -0.77087 -1.63472 -10.4464 -1.58727 6.130741 2.393624 2.311581 2.721553 8.365059 1.894536 3.06607 8.339285 0.704467 3.59138 F -2.25183 2.874332 1.364522 4.326923 1.795666 4.86618 -0.56932 2.291422 -15.0488 -3.87683 11.63946 -1.46217 -4.1123 11.0809 -1.22399 -1.18996 -3.98734 -1.05471 -0.22483 -6.47336 -2.16294 10.23137 -3.24105 -1.68481 -12.4086 4.753869 7.893669 1.537422 -0.52622 -6.83987 1.78599 -0.49393 -4.22635 -1.52284 1.863935 1.391405 3.498287 1.335405 -7.13295 -0.18365 -3.11144 0.569496 1.483585 -1.7834 8.432212 3.687004 FB 14.49432 9.413457 -12.007 -0.76361 5.888257 6.303318 7.965522 2.986924 5.640203 -5.12399 3.613815 0.41184 -2.70443 4.031089 4.109155 -4.19023 0.533198 8.302816 9.613479 -4.87182 0.525551 13.42603 2.226145 0.392916 7.203835 -4.73437 6.695301 3.039956 1.036096 -3.83281 8.432923 1.738916 1.684726 2.100527 -9.60615 -2.8758 13.23249 3.965525 4.77301 5.722615 0.745324 -0.37692 12.03094 1.51709 -0.72965 5.288358 FDX -7.26855 0.007501 -0.469 2.783645 5.805505 5.158005 -2.97265 0.680828 9.319635 3.685352 6.439665 -2.4263 -2.62006 4.653776 -6.40673 2.490178 2.152503 -1.49296 0.598592 -12.1398 -4.24619 8.383109 1.595642 -5.8755 -10.8228 2.990235 19.06772 1.458781 -0.09479 -7.78502 6.647545 1.851526 6.147733 -0.22609 9.94296 -2.68668 1.522836 2.006428 1.305905 -2.84272 2.122393 12.32653 -4.34921 2.962444 5.384331 0.011959 GE -10.3461 2.24061 1.648999 3.862495 -0.37189 -1.10231 -4.29985 3.300199 -0.55794 0.741608 2.634638 -3.73277 -5.46102 9.790759 -4.54021 9.149536 0.701625 -1.74816 -1.76891 -4.90421 2.533523 14.6709 3.526971 4.814707 -6.59106 0.905401 9.074029 -3.28147 -1.70106 4.896657 -1.10005 0.30113 -4.47264 -1.77557 5.694467 3.475659 -6.05266 1.132798 -0.06355 -2.76812 -5.61364 -0.59326 -5.25327 -4.22901 -0.60932 -16.7153 GM -11.7201 0.332594 -4.08038 0.174317 0.290023 5.835593 -6.83196 2.897694 -7.39004 -1.69067 6.464968 5.385795 -6.55973 14.37768 1.309905 -6.50667 2.59555 -6.3861 -5.46055 -6.56934 3.19375 16.28914 3.695216 -5.09723 -12.8592 -0.69476 8.067887 1.167219 -1.64522 -8.3842 11.42876 1.184819 0.696072 -0.5551 9.262152 1.965113 5.040367 0.588244 -3.06875 -2.0862 -2.10965 4.026439 2.936012 1.46642 11.55676 6.348831 GOOG 5.376949 2.936569 -8.31983 -5.44194 6.309574 2.748754 -0.63969 0 1.007698 -3.16614 -3.08543 -2.84776 1.542553 4.46756 -1.86246 -1.94526 -0.97331 -2.18 20.19174 -1.17645 -1.58997 16.82884 4.472363 2.182297 -2.10915 -6.10116 6.74154 -6.98228 6.15297 -5.94889 11.06077 -0.24633 1.314985 0.912728 -3.38778 1.787846 3.19521 3.275805 0.741371 9.159702 6.441391 -5.87742 2.325651 0.858952 2.015756 5.908269 GOOGL 5.376949 2.936569 -8.31983 -4.31151 6.874439 2.277617 -0.87571 0.484859 1.038876 -3.49076 -3.30886 -3.3547 1.298383 4.665613 -1.40945 -1.06905 -0.62868 -0.96824 21.75024 -1.47224 -1.45874 15.51138 3.452718 1.977285 -2.15136 -5.81628 6.349036 -7.22195 5.777704 -6.07195 12.46134 -0.20829 1.779076 0.706314 -4.21052 2.10564 3.460536 2.976374 0.309673 8.999304 6.707836 -5.87609 1.631661 0.940143 1.844592 6.0021 GSK -3.46507 9.997499 -4.48695 3.630919 -1.45288 -0.8528 -9.55497 2.888338 -6.37475 -1.04416 3.497046 -7.98708 2.948058 9.356836 -2.67819 0 -2.60225 -6.13027 4.297719 -4.55545 -6.05913 11.9896 -4.67245 -0.40496 2.319616 -3.44979 4.84165 5.809975 -0.11087 2.269356 3.971694 -2.58375 -0.77932 -7.25394 -4.46538 1.875266 2.037382 6.936249 1.609344 -3.03861 9.32322 -2.56961 -6.09968 0.452701 0.829712 -10.3609 7.495758 47.79732 -3.91952 53.35535 2.460645 8.665031 47.83688 17.82875 -14.0673 9.84 -43.5066 -7.96778 -0.71548 -11.7647 11.90708 1.840626 5.957274 2.747407 8.027934 -1.2287 1.025238 -4.65686 -5.59135 3.961601 3.561105 -5.61252 3.93345 -8.99415 1.95749 -0.32962 -10.0682 -3.39168 4.309783 2.69242 2.618007 -4.29584 -8.17614 -5.73769 -2.57616 4.89468 -1.64597 -18.8935 -1.67947 -0.49637 5.800688 -4.69559 -10.5114 7.501279 11.36 1.184434 -11.3477 1.66524 -6.56325 -7.894 -7.54544 -6.9605 2.422104 7.945211 5.075541 -6.23237 -2.47956 2.812813 0.636699 -8.75013 8.124154 -0.9409 -1.18451 -8.68288 3.75029 -29.5128 -9.35579 -4.02582 -7.44524 -12.127 -4.58492 4.236855 -0.06893 -2.60593 -0.01305 -5.22236 -12.0755 -10.7303 -25.9226 0.8751 0.175933 -4.10326 3.35426 -7.32528 -6.84189 0.960715 16.0821 -7.07163 -3.94173 -5.06636 -5.71962 8.482409 3.536863 -11.1095 0.389193 2.356618 11.69619 -5.68379 -6.72252 -1.54145 6.510743 2.685832 8.947695 -0.0836 -2.17924 -9.96821 1.46009 -5.56449 0.222989 1.572855 12.11897 -6.73313 -6.16935 -1.92954 7.853481 2.513636 8.521444 0.213201 -2.15682 -9.84139 1.568611 -6.01977 -2.45721 1.079424 5.641339 -1.61909 7.481212 2.521889 2.222899 -0.65826 3.015391 -1.58666 -0.96481 -2.95326 8.316109 -8.93134 IBM -5.80583 5.375316 3.953124 2.06764 -5.61852 -1.67607 5.737298 0.922127 -1.28445 -13.3962 -0.68441 -1.06678 -4.44403 6.370516 -0.88922 6.722741 -0.20028 -4.12025 -0.4119 -7.945 -1.97444 -3.37311 0.464736 -1.30106 -9.33277 6.055377 15.56422 -3.64816 6.335969 -1.29488 5.804219 -0.24868 -0.03888 -3.26835 6.492445 2.294004 5.098864 3.815722 -3.18871 -8.00337 -3.90548 0.726215 -6.02463 -0.18006 1.343266 6.099688 INCY 29.40944 -1.92308 -16.7134 -9.26756 2.038715 13.90515 -15.7158 13.93736 -9.50185 36.71764 12.6603 -3.22965 9.027493 7.702923 6.767618 6.000436 13.3697 -5.39265 0.067172 11.42117 -5.04346 6.525877 -2.79929 -5.07828 -34.9478 4.146667 -1.42136 -0.28598 16.78812 -5.26819 12.7707 -10.1187 16.24387 -7.78328 17.60527 -2.00478 20.84361 9.769422 0.398249 -7.07476 4.003405 -2.7044 5.79133 3.001005 -15.1326 -3.07955 INTC -5.45174 1.861704 4.256866 3.393507 3.240492 13.10395 9.676375 3.745638 -0.28637 -2.32625 10.25657 -2.57718 -8.95564 1.354419 -5.95489 4.09338 6.646336 -11.7382 -4.8167 -0.60373 5.606167 12.3424 3.409206 -0.93033 -9.96646 -3.78462 9.307475 -6.40876 5.224993 3.810326 6.260488 3.71623 5.162502 -7.64914 0.265023 4.494496 1.476405 -1.02392 -0.38912 0.171791 0.565419 -6.62328 5.057445 -0.47936 8.492834 19.36903 IRWD 19.46598 4.614275 -15.093 -10.5519 29.94555 7.053073 -3.45727 -12.5676 0.11592 8.220764 -1.28388 10.69364 1.697128 -0.8344 3.559871 -14.625 3.29429 -14.5287 -13.3499 5.263158 -5.27273 9.021113 7.394366 -5.01 -20.3724 4.530379 13.34788 -4.48898 19.51153 4.663747 8.048834 -5.61094 19.02048 -19.6044 22.19047 -2.04858 -5.9916 17.4148 0.976513 -4.38763 8.457157 6.546437 -6.05517 -10.2308 -1.21853 -2.56305 IVV -3.49044 4.559915 0.871902 0.744127 2.284478 2.088995 -1.39594 3.969112 -1.37573 2.385756 2.75383 -0.29703 -2.90037 5.645442 -1.59049 0.971948 1.300929 -1.97788 2.190908 -6.14375 -2.49801 8.479062 0.392251 -1.74252 -5.01317 -0.07652 6.802835 0.381967 1.681892 0.232185 3.718717 0.108223 -0.00907 -1.79882 3.658866 2.114865 1.711189 3.935014 0.087809 0.915145 1.334223 0.610514 2.004689 0.183686 1.951055 2.234754 IWM -2.77393 4.778887 -0.74833 -3.74764 0.785855 5.272018 -6.05279 4.829665 -5.93055 6.593507 0.111531 2.891844 -3.27704 5.946413 1.777712 -2.56493 2.236343 0.782953 -1.1007 -6.311 -4.93249 5.622711 3.259927 -5.04133 -8.58752 -0.24339 7.999179 1.662241 2.230398 -0.03739 5.850292 1.764092 1.056843 -4.61705 11.05329 2.858079 0.241795 1.890045 -0.00434 1.099258 -2.03037 3.314413 0.788274 -1.34786 6.212957 0.638843 JNJ -3.40649 4.876599 6.632653 3.115138 0.862343 3.114528 -4.32996 4.340371 2.757158 1.116427 1.087893 -3.39954 -4.2364 3.081395 -1.86323 -1.39165 1.686798 -2.67625 2.82167 -5.48089 -0.67036 8.227102 0.94123 1.451873 1.664455 1.44262 2.821935 3.575952 1.248347 7.620429 3.219901 -4.08761 -1.03391 -1.83156 -3.38801 3.483028 -1.74124 8.575109 1.884737 -0.91712 4.495554 3.090097 0.255043 0.282515 -1.87288 7.140213 JPM -4.71718 2.637283 6.846181 -7.21178 -0.7324 3.689041 0.782185 3.086527 1.328848 1.080924 -0.5291 4.022606 -12.547 12.68849 -1.1423 5.120642 3.98356 3.010033 1.790102 -6.46432 -4.883 6.142186 3.782101 -0.98481 -9.27623 -5.39815 5.166501 7.503897 3.265316 -4.80014 3.71489 5.498212 -1.36815 4.73923 15.74224 7.603778 -1.42207 7.037868 -3.09776 -0.43909 -5.63471 11.19989 0.90908 -1.08129 4.993067 5.857338 KMB 4.700364 0.896041 0.681874 1.814059 0.089087 -0.25906 -6.60852 3.976124 0.379774 6.228502 6.402739 -0.17484 -6.5605 1.574657 -1.53222 2.408739 -0.75668 -1.86146 8.49297 -7.34105 3.215705 9.7854 -0.4678 7.615116 0.869811 1.443946 3.932846 -6.93885 1.467754 8.965032 -5.78811 -1.17014 -0.8062 -9.31919 1.038859 -0.52457 6.102657 9.387887 0.003741 -1.47825 -0.07541 0.203532 -4.67847 0.015554 -3.86618 -4.48327 LAMR -6.83254 10.12736 -4.86849 -2.11765 0.482801 7.417916 -5.37736 4.646062 -4.6114 4.873096 3.175218 2.225461 4.436987 3.71296 3.212273 -2.21022 4.589372 -4.06008 4.47112 -11.174 -0.88902 8.144883 3.508772 3.88496 -6.46215 1.797858 8.996948 0.868049 4.841709 3.116108 2.332941 -8.16913 6.088009 -2.86796 4.465965 2.563903 12.2741 -0.09297 0.074146 -3.62238 -2.91833 6.260406 -4.14775 -5.7723 4.20918 2.697101 0.859002 -0.44721 6.590561 -3.95011 -1.66014 -5.66043 -1.58475 -1.27934 3.583737 2.005559 3.07911 -23.8525 8.848264 -8.71981 -12.6716 -4.41367 -4.77688 -5.79169 -2.2689 -25.809 10.07957 -2.00026 -0.84657 10.91604 -6.68497 -6.35676 -1.05936 -1.21724 -0.93371 2.8538 4.179428 2.962826 5.540377 -1.02326 7.403114 -10.0857 -3.39878 1.138765 -2.50391 -1.05699 5.671279 -5.01661 12.20869 -13.2921 -1.3108 -4.22884 8.541972 17.29357 2.398631 2.766351 0.67682 -0.36747 -4.20405 -29.2258 5.316183 -25.2262 3.041981 1.120743 5.580906 -3.91433 -2.58651 0.214222 2.270724 0.446384 3.586567 3.07355 0.387025 -7.01199 1.741103 -9.0546 2.861176 -0.48994 2.448048 -3.95369 1.102996 0.841361 6.023579 0.474364 1.487702 4.150605 -2.47241 -11.1778 1.546321 -12.1552 0.470521 0.189911 -1.20505 -5.52568 -1.452 -1.43536 -4.87058 1.297887 9.053779 2.155474 2.433711 1.127218 5.424119 -12.3411 3.806294 2.225346 8.608954 -0.25697 -4.90788 -0.72699 -1.76714 -2.76592 10.75232 -0.48188 -1.66859 -2.9048 1.81046 -12.3943 6.363872 1.477543 -3.14332 -5.30658 0.053877 -6.12384 -2.73803 5.338008 7.928096 1.315496 -0.94692 -8.40894 10.43361 -0.55481 6.720114 -0.33835 -3.12724 -7.79056 -3.01424 -0.06146 8.508564 -0.19194 7.628025 4.484846 2.002021 -5.94835 3.256989 -7.78465 LULU -22.5987 10.11162 4.531902 -12.664 -2.83039 -9.29868 -4.97777 3.808657 5.209116 -0.85694 15.70228 15.77091 18.73096 3.321256 -6.45821 -0.59356 -6.04965 9.215588 -3.7366 1.829462 -20.8717 -2.92201 -2.74558 9.713965 18.28617 1.043316 7.918785 -3.20008 -0.80329 13.55835 5.11133 -1.48813 -20.318 -6.13676 -0.46415 14.00755 3.83752 -3.37284 -20.5479 0.200627 -7.23308 23.55715 3.231492 -6.7253 8.076811 -1.27876 MCD -2.94754 1.901451 3.0268 3.417321 0.849003 -0.68027 -6.1346 -0.03555 1.163039 -1.13912 4.198455 -3.21248 -1.34472 7.902195 -1.47624 -0.91338 0.2332 -0.89649 5.038393 -4.00647 3.693959 13.92469 2.493946 3.476335 4.763997 -4.62415 7.224645 0.634494 -3.51225 -0.70499 -2.25533 -0.95301 -0.27938 -2.43852 6.767132 2.024163 0.658324 4.875465 1.505448 7.912349 7.772488 2.070525 1.222766 3.630892 -2.14664 6.439232 MCHI -8.9382 3.097244 -0.61851 -2.55612 4.607664 2.718173 6.728488 1.293191 -5.48574 3.862389 1.158301 1.840745 0.338443 5.277778 2.713909 15.00917 -4.515 -5.39375 -10.7066 -11.8705 -0.6576 7.966218 -1.16279 -3.23221 -11.9777 -2.38762 10.82746 -0.57457 -0.05731 1.041952 3.825247 6.204443 3.701129 -2.96845 -0.96602 -5.31853 7.460572 3.576252 2.474619 2.413449 5.041642 2.010336 8.560463 4.269535 1.668065 3.412932 MRK 5.834166 7.589201 0.399595 3.153074 -1.19536 0.737303 -1.91876 5.939373 -0.6588 -2.26046 4.245771 -5.2638 6.145448 -2.88653 -1.02409 3.61865 2.233042 -5.78933 3.565783 -8.66689 -7.48993 10.67018 -3.01866 0.510486 -4.08043 -0.92784 6.268573 3.637704 2.579351 3.219064 1.8026 7.020573 0.11452 -5.93251 4.196403 -3.08967 5.259813 6.219074 -2.86053 -1.95431 4.400132 -0.89537 -0.39766 -0.12131 0.888928 -14.0522 MSFT 1.149425 1.999629 6.995563 -1.43938 2.038619 1.856375 3.501199 5.90968 2.047105 1.272649 2.479414 -2.84459 -13.0248 9.311685 -7.2862 19.64088 -3.03185 -5.78318 5.775764 -6.19827 1.700368 18.93357 3.950188 2.069117 -0.71296 -7.01125 8.529528 -9.71487 7.023782 -3.47283 10.74803 1.991513 0.223648 4.007778 1.223659 3.089814 3.999266 -0.47861 2.908418 3.897768 2.528981 -1.36298 5.399317 3.305125 -0.46448 11.576 MTN -9.41114 3.184153 -0.28837 -0.67432 0.664452 11.35075 -2.17673 5.284768 9.145805 0.018789 1.482168 4.461354 -3.69801 0.056974 18.51158 -4.07078 4.566072 5.862722 0.448718 -1.62276 -2.99324 9.717105 5.631952 6.629743 -2.34612 1.908 5.588268 -3.04665 1.231901 5.927997 3.481411 10.716 -0.99835 2.139085 -0.66228 2.314803 6.301826 5.579681 6.479888 2.951563 8.156129 -4.75811 3.839678 8.066197 -0.01542 0.790242 MU 5.931034 4.991319 -2.19099 10.3973 9.456355 15.25009 -7.28376 6.710311 5.092025 -3.41506 8.643095 -2.61474 -16.4096 4.800957 -11.5422 3.685957 -0.71098 -32.5456 -1.75159 -11.3452 -8.7142 10.5474 -3.80435 -11.1211 -22.1145 -3.64647 -1.52517 2.664308 18.31558 8.156101 -0.16535 19.99456 7.802923 -3.50706 13.80119 12.20758 9.950876 -2.81893 23.26352 -4.30606 11.14347 -3.01743 -5.89719 13.60132 22.93158 12.57209 MUB 2.564103 1.045321 0.084332 1.243389 1.121049 -0.16329 0.211364 1.505322 -0.07965 0.547393 0.117556 0.809165 1.59507 -1.12398 0.218674 -0.70993 -0.4889 -0.34143 1.123399 -0.11073 0.863289 0.359735 0.497534 1.012537 0.757772 0.001811 0.422486 0.656135 0.267265 1.599011 -0.07133 0.105578 -0.58285 -0.9842 -4.11036 1.690693 0.218828 0.483477 0.295913 0.490372 1.473439 -0.47969 0.80569 0.709673 -0.51706 -0.00015 NFLX 11.17962 8.86815 -21.004 -8.51916 29.74475 5.449585 -4.0581 12.99205 -5.53974 -12.9461 -11.7575 -1.43686 29.32877 7.494341 -12.2592 33.55252 12.14016 5.268724 21.80272 0.629866 -10.2321 4.958358 13.79406 -7.26695 -19.7162 1.689495 9.422244 -11.9439 13.91869 -10.8321 -0.27142 6.774521 1.108784 26.68726 -6.31255 5.781966 13.61913 0.969168 3.966341 2.920029 7.081919 -8.43677 21.5149 -3.91583 3.710584 8.225412 NGG -0.8267 7.749305 -1.51862 3.375036 5.16465 2.704002 -0.50683 4.109207 -3.8266 3.491931 -0.88082 -2.67218 -0.45287 -2.53057 -5.76138 4.364649 6.302833 -7.04853 3.174849 -0.66046 5.213055 2.82924 -1.45076 0.11959 1.816287 -5.00517 6.133389 0.816099 2.461879 3.574405 -2.54926 -4.10558 2.311271 -8.02169 -11.3766 2.177815 0.200014 4.030463 4.292104 2.139666 17.0159 -8.35197 -0.56347 2.021662 -1.84466 -2.73711 8.780348 17.27858 -0.59352 3.58518 9.769026 11.84384 5.120521 18.70817 -4.08471 29.00215 4.729623 -13.5816 -5.99255 -8.44349 3.55669 -0.00278 -0.67937 -7.34969 -0.98218 6.932516 -4.57741 -1.59346 0.382472 3.458129 2.969029 5.554516 7.038768 -5.99341 1.35951 1.667435 12.31861 -7.609 -1.0304 -2.64839 2.821855 -5.8495 -1.36743 -4.98607 -1.54941 -11.277 7.763662 -7.74882 0.246738 2.591795 5.185895 -8.59945 1.221036 7.937841 0.981114 2.620447 8.357298 3.969346 3.985566 3.573744 7.604268 -3.19038 1.62236 1.537658 10.96084 -0.95866 -2.7861 2.325213 6.005537 -0.3727 7.415297 6.144882 1.666078 -6.80013 4.094827 -8.59473 -1.76544 -5.26383 2.756287 -5.91619 8.266997 3.292567 4.866323 14.33559 0.817424 7.4898 -8.0782 -8.06811 10.90547 -24.1464 -4.41311 -3.08599 6.212957 11.53227 6.702372 -11.9543 25.11011 -9.08252 0.507429 -0.67146 -14.0304 -16.794 2.046935 -17.9027 -0.54754 0.92302 -1.25683 -0.71115 0.372579 -0.8316 1.110821 -0.00159 -0.01043 -0.00401 -0.83118 -0.7496 0.931012 1.156499 -4.58542 2.245004 40.70059 7.688742 1.242482 5.653127 12.3864 11.18821 -13.9505 8.798364 1.604243 -19.5282 -5.3659 -6.64511 0.086554 -2.2527 -2.03144 -10.6683 9.261663 2.961187 -0.6718 -0.06833 -3.3292 -2.15704 -2.30094 2.97236 1.714933 -10.4239 NKE -7.36267 7.811752 -5.6705 -1.23206 5.759651 0.832141 -0.54159 2.151145 13.55824 4.226457 6.797892 -2.88272 -4.05616 5.583063 3.305189 -1.4851 3.144755 6.245697 6.665432 -3.01163 10.31822 6.554444 0.95398 -5.2837 -0.794 -0.69731 0.044946 -4.12583 -6.3215 0.237091 0.523478 3.853874 -8.44341 -4.71136 -0.22921 1.848649 4.032398 8.01293 -2.22812 -0.6242 -4.42744 11.66497 0.014746 -10.3525 -1.90784 5.965931 NKTR 19.82379 -5.66176 -5.5339 -2.88779 -0.33135 9.283096 -17.7067 35.16588 -15.3576 14.25021 20.8847 -7.0186 -5.54839 -10.724 -15.8378 -13.4545 20.79832 8.782609 0.799361 -12.3711 -0.81448 8.30292 31.92923 7.588978 -19.0604 -18.1285 23.07758 14.02636 -1.54061 -7.85679 21.48387 3.218866 -3.7735 -27.8431 -0.93742 -0.1521 -1.34399 7.969909 79.40425 -19.2234 4.737048 -1.71996 11.5924 -3.75468 14.03268 0.285 NVDA -1.9975 17.60106 -2.55713 3.126745 3.348899 -2.42105 -5.60949 11.63058 -5.14139 5.907859 7.774196 -4.38722 -4.21446 15.30355 -5.14506 6.069295 0.169187 -9.12788 -0.79562 13.15772 9.653025 15.09128 12.22262 3.899206 -11.1447 7.439884 13.59607 -0.29066 31.81789 0.600719 21.44352 7.601944 11.68525 3.83289 29.75021 15.74007 2.245928 -6.97509 7.311348 -4.30044 38.48132 0.08548 12.34699 4.264153 5.416374 15.59496 PG -5.16928 2.66249 2.466311 3.239627 -2.13204 -2.72311 -0.83367 7.48836 0.758032 5.011737 3.620946 0.729846 -6.80874 0.996559 -3.74721 -2.17097 -1.40863 -0.19135 -1.16433 -7.8618 1.797085 7.128207 -2.01623 6.09636 3.760467 -1.7338 2.49588 -1.87603 1.138278 4.459269 1.859791 1.989581 2.77464 -2.54996 -5.01 1.934589 4.967787 3.921187 -1.36963 -2.10662 0.810262 -1.12709 4.954531 1.506565 -1.48807 -4.4755 PM -10.3179 3.544919 2.37248 4.348357 3.640407 -3.77594 -2.72803 4.353128 -1.38246 6.726619 -2.33682 -5.17465 -1.48557 3.389831 -8.02601 10.80579 -0.47921 -2.30483 6.685793 -6.6994 0.696026 11.43325 -1.14253 1.769598 2.378807 1.113207 8.894034 0.000193 0.56073 4.103226 -1.45531 -0.34914 -1.71133 -0.8223 -8.47122 4.794488 5.031593 13.71221 4.162587 -1.87462 8.023724 -1.17328 -0.70006 0.098501 -4.24757 -5.82822 QNST -4.83314 -20.3144 0.758725 -8.13253 -8.85246 -0.89928 -9.43739 -4.00802 -13.3612 -2.40964 11.85185 33.99558 -15.6507 31.05469 -11.3264 -8.7395 9.208103 8.768971 -9.76744 -5.49828 0.909091 0 -11.8919 -12.2799 -11.1988 -22.0672 15.13152 2.913977 5.103636 -4.07405 2.233521 -15.7225 -1.32719 -3.99351 9.99 17.83834 -6.95489 -7.75429 20.71303 14.82179 -13.2296 7.137943 -6.78463 37.44213 37.29318 20.99844 RSP -2.9614 5.336997 0.607108 0.383614 2.156408 2.85856 -2.33346 4.204485 -2.58491 3.021507 2.663934 0.279891 -2.92067 5.723698 -0.95911 0.407156 0.724994 -2.26862 0.964912 -5.46109 -3.01458 6.987493 0.304956 -2.48621 -5.56846 0.97475 7.959024 1.237931 1.34832 -0.08341 4.124368 0.135354 0.083002 -2.46048 5.226052 1.095761 1.96831 3.094193 -0.00907 0.610647 0.497865 1.103722 1.526893 -1.0883 2.844009 0.998549 SBUX -9.27414 0.142212 3.410372 -3.76124 4.097531 5.652649 0.387697 0.506506 -3.02018 0.132521 7.920422 1.034355 6.678854 7.189607 1.299674 4.709609 5.139723 3.185142 8.048121 -5.30101 3.893255 10.08093 -1.56599 -2.22534 1.222717 -3.91697 2.539698 -5.8224 -2.04599 4.042671 1.608151 -2.81373 -3.73688 -1.99636 9.723331 -4.25632 -0.58035 3.414141 2.642762 2.810079 6.284959 -8.39202 -7.49583 2.006256 -2.18624 2.013891 SCHB -3.19929 4.750975 1.071907 0.109385 2.250874 2.458218 -1.86505 4.097801 -2.02967 2.670873 2.519459 -0.02801 -2.76997 5.718415 -1.00222 0.515055 1.320457 -1.77387 1.751941 -6.04578 -2.93728 7.934455 0.599281 -2.12956 -5.71962 -0.04163 7.107606 0.558182 1.745448 0.206366 3.942823 0.184041 0.158617 -2.16067 4.443125 1.929457 1.861071 3.654983 0.047264 0.948948 1.033181 0.733068 1.948474 0.044138 2.334555 2.077132 SINA -22.6231 4.81669 -11.5908 -20.874 -6.25523 11.06896 -2.77275 -4.56706 -10.9138 -0.41322 -7.37125 -1.42292 -3.18097 2.484815 -13.3621 36.80037 -7.4213 31.5124 -24.1856 -4.58015 3.535484 18.74377 6.150294 -2.32362 -6.99381 -7.04938 10.86483 5.732031 7.815913 -3.98223 3.855072 41.96218 -3.5102 -2.30904 6.810072 -21.1434 14.64992 -0.31252 3.695011 6.45305 27.4885 -13.3294 11.51056 7.314282 12.49961 -6.19554 9.794523 3.781099 8.954748 -1.85436 -0.69934 2.794979 4.846109 11.13997 -3.63641 6.978213 2.915693 -11.6159 0.219787 -1.49458 124.0379 10.52308 39.89335 3.418286 22.63878 -21.4086 -4.19212 -39.3078 7.560664 26.24684 -8.46704 -36.7386 4.240889 -18.8085 -2.96184 -3.68225 26.91842 -1.59498 -4.42165 -3.02873 12.06223 -6.20289 3.200068 14.53051 -0.02887 -25.1669 -22.5838 -18.5037 4.147473 2.010233 -5.42102 -9.16722 0.847906 -8.02064 1.00736 6.543067 4.396477 2.399347 0.187553 7.310467 6.394199 -2.93045 -1.88619 3.786518 1.385504 -3.54188 -3.07697 -17.645 -3.14 2.82482 6.726302 -9.90508 6.029553 7.818339 -1.92861 -21.8167 20.03236 -21.699 11.22652 40.61883 -2.86181 -12.1212 21.83509 -7.50689 4.249449 14.24422 -10.6971 16.98023 1.329434 0.367621 3.719959 1.148356 4.274836 -4.50029 -1.04619 0.231934 1.312178 0.831998 2.941384 1.800971 0.021362 -7.43651 2.434313 -9.72752 5.911842 -0.76451 -1.18958 0.954149 1.263538 -0.69277 -1.18559 -13.9392 7.086673 2.575768 6.192376 2.325834 14.93632 -3.66722 2.924982 1.046756 5.097688 -3.82243 -2.12934 0.236235 2.6868 0.523216 3.204146 3.241261 0.090941 -7.63424 1.738649 -9.46216 -9.25789 2.507934 16.77765 -0.38292 -10.947 -8.51249 -5.08034 -6.88961 -5.13107 -11.989 -2.23568 -9.07025 2.126113 -17.3739 SKX -12.7981 16.7532 8.330863 12.17843 8.563064 2.696629 14.15755 11.88422 -8.66884 2.701182 12.16438 -10.0309 9.230769 12.90804 5.532727 25.0452 17.73799 3.702654 37.03434 -6.45397 -4.73213 -30.1909 -3.20513 0.023113 -6.69653 16.759 -7.52304 8.528588 -5.69835 -4.67191 -19.199 1.187327 -5.82008 -8.18594 8.311446 7.871668 2.156908 2.14949 6.904164 -8.06457 1.009307 15.53561 -4.84966 -5.99958 -5.16 27.132 SNE -8.90688 11.42857 9.681576 -7.74059 -8.27664 3.646477 9.898629 3.689636 -5.59916 9.866962 10.94854 -6.91223 13.77626 21.59725 -5.43785 12.88275 2.282501 -8.18241 -0.14089 -9.06526 -4.65422 15.91837 -8.73239 -5.06401 -2.97627 -11.5778 22.18962 -6.3086 15.59166 5.328169 13.81305 -3.76139 3.516061 -5.68095 -7.22353 -3.60757 7.951438 2.239485 9.223319 2.292129 6.02343 4.227275 7.471241 -3.59621 -5.86845 16.16603 SPPI -4.97175 -0.71344 -6.10778 -12.3724 13.39156 4.36457 -13.4071 15.19886 0.369914 -6.87961 -4.88127 -3.8835 1.010101 -11 -2.56822 -6.91928 10.97345 9.090909 1.096491 5.133767 -17.7442 -12.8763 15.16315 0.49 -17.7546 -8.89097 40.68796 11.46799 5.631749 -12.303 4.54621 -22.7274 -12.0727 -24.217 10.44198 13.26923 5.151874 37.29906 1.5325 17.02692 -25.6842 31.56544 0.064228 30.7411 44.06984 39.14241 SPY -3.52483 4.551577 0.831068 0.69515 2.320641 2.063337 -1.34376 3.946346 -1.37912 2.355091 2.747198 -0.25602 -2.96293 5.620456 -1.57448 0.983384 1.285618 -2.02906 2.258926 -6.09501 -2.54301 8.505975 0.365508 -1.72792 -4.98827 -0.10301 6.70425 0.384511 1.690764 0.327347 3.6296 0.099749 -0.01221 -1.7537 3.673839 1.998321 1.749469 3.889152 0.095807 0.942619 1.35129 0.57743 1.985418 0.20177 1.924094 2.266406 SRNE 17.90123 20.62827 11.28472 -28.3151 -43.3079 29.55854 -19.4074 1.102941 -17.8182 -6.63717 -8.76777 161.5584 0.19861 28.04757 -10.5263 -21.9723 52.88248 27.77375 17.93417 -38.9798 -33.8328 2.979738 -7.29167 8.729076 -39.7345 15.02762 -10.9472 27.49929 1.447726 -19.5602 12.30143 5.862353 16.19622 -25.7306 -8.70565 -6.69667 10.16408 -3.7437 -24.0685 -50.6829 -20.5728 28.97226 -2.57 -7.78231 -5.64556 55.79235 T -3.96007 -4.17167 9.834012 3.124061 -0.64426 -0.31012 1.952455 -1.77016 0.800915 0.158749 1.549943 -5.05936 -0.60596 4.981774 -5.52662 7.622194 -0.28868 2.83729 -0.87465 -4.43293 -1.86747 4.314102 0.477469 2.187802 6.261972 2.448109 5.988119 0.327595 0.840077 10.35037 1.280893 -5.58711 -0.68047 -8.31611 4.991359 10.06578 0.265576 -0.91761 -0.6043 -3.51981 -2.83567 -2.1363 4.658296 -4.03872 4.474869 -13.0916 TCEHY 7.34244 15.83514 -13.7328 -9.98553 13.72806 8.144476 6.286837 -0.07394 -8.62005 8.30027 -0.37445 -9.25578 15.92006 3.507729 8.960368 8.697944 -3.01156 0.450902 -7.18204 -9.45728 0.178042 11.7891 5.72337 -1.66414 -4.49522 -2.10111 11.36965 -0.69493 10.13099 3.300726 5.334811 6.963471 7.647053 -4.84511 -6.00322 -2.91693 8.07313 1.392118 8.629639 8.577859 10.05521 4.561686 11.05347 5.840931 3.654389 2.494538 TEVA 11.3523 12.46537 5.913009 -7.53217 3.953817 3.822539 2.060282 -1.29042 2.341965 5.060465 1.378957 0.930151 -1.13024 0.797993 9.259909 -3.01766 -0.05234 -1.66389 16.78511 -6.28853 -12.3428 4.835282 6.848304 4.296372 -6.3476 -9.13018 -3.77899 1.746681 -4.21825 -3.18175 6.490054 -5.31998 -8.7122 -7.12715 -11.8022 -3.11628 -7.81931 5.5807 -8.39665 -1.63928 -11.8396 20.36692 -3.23075 -50.5697 10.881 -21.6809 THO -6.98896 9.032509 9.43554 -0.31117 -1.42928 -4.84054 -6.85775 1.397017 -4.11469 3.250077 11.09851 -4.45163 0.859137 9.423248 2.513785 -4.40121 1.529001 -7.44073 -0.71073 -2.32641 -5.09344 4.985555 7.100592 -2.53792 -6.63511 5.60655 15.6721 0.382034 1.520772 0.042897 18.20675 6.002995 4.354615 -6.00319 26.7962 -0.23332 3.408276 7.032464 -12.9958 0.002013 -5.9344 15.74941 0.724106 3.032924 15.80654 8.405083 TI 11.14458 2.529359 3.876652 8.905852 -3.58255 1.938611 -9.58796 0.788782 -0.52174 -1.22378 -1.23894 -5.55556 9.108159 3.73913 -2.68231 1.205857 4.170213 3.921569 3.773585 -8.25758 1.403799 13.19218 -7.05036 -2.09978 -11.8677 -14.1007 12.61048 -9.55588 -3.18623 -13.565 3.896769 6.929352 -8.72044 4.563836 -13.7355 18.82027 -3.18961 -6.77635 12.17423 -1.27087 6.232135 -1.22279 11.15995 -6.82077 -3.18278 -8.49426 9.882406 7.716268 8.743066 -0.7655 -5.0809 -26.8564 1.824912 3.129098 -7.79079 6.189206 -5.4078 2.101443 -5.67527 -15.4122 7.729261 -4.04299 6.541835 5.146571 -4.32135 -5.33239 2.609291 8.715383 5.224315 5.041777 6.571802 -10.9402 -2.6001 -8.78523 -0.02895 -3.40633 13.55755 -0.24928 -25.3176 -1.19656 21.02834 8.517335 1.414427 0.96729 -22.1193 -29.3567 21.33261 -39.6782 2.976582 1.118674 5.525914 -3.74604 -2.86155 0.376816 2.29091 0.435517 3.544659 3.031981 0.444829 -7.10043 1.674931 -8.98362 -15.1743 68.79889 94.62684 34.34946 -48.3612 19.27748 27.50228 -8.42025 -22.3822 -1.05286 -20.8707 -27.69 8.28395 -30.8258 8.032927 6.781908 -2.50335 -3.18076 -1.91063 -7.11087 -1.30208 -0.78975 0.952428 -0.25384 4.984627 -7.46245 1.645293 -8.83277 13.516 1.365789 13.85379 -7.3434 -3.03492 -7.94634 3.99855 -1.74082 -9.21473 -5.76175 -5.48148 -16.1303 16.5692 -1.70464 7.934394 27.77775 7.594485 -8.39025 -8.82726 5.067724 19.43731 12.97628 -1.7225 -4.46242 -6.12992 -7.43234 7.627808 -28.6023 12.64207 -1.69385 -9.43856 -5.71515 -10.547 -7.98058 -12.8967 5.432354 -2.76807 0.462035 -12.4509 -16.5274 -2.8078 -22.9127 -3.91275 4.137053 4.872619 -0.22038 5.625856 4.457701 -19.4207 -9.29842 3.654714 -15.5143 -7.12674 -1.02333 9.904034 -15.4572 TOL -0.67568 6.14966 -7.97231 -4.62396 5.78271 1.877416 -11.4092 8.871214 -12.4473 2.535302 9.514867 -2.05773 1.021301 10.65858 2.688593 -9.65938 1.772651 5.584739 1.911495 -5.01028 -7.38437 5.05257 3.363914 -10.4457 -17.0671 -0.6355 7.484554 -7.49899 6.766557 -7.70439 4.0677 10.97607 -3.97626 -8.12449 8.080379 4.487869 1.12129 8.824796 5.740357 -0.16435 2.496266 6.984161 -2.20175 0.868798 6.352505 11.13821 TSLA 20.5951 34.94846 -14.8523 -0.26865 -0.05772 15.54122 -6.98159 20.77922 -10.0185 -0.40382 1.166736 -9.04221 -8.45735 -0.1277 -7.16534 19.7489 10.94891 6.961722 -0.78655 -6.42119 -0.265 -16.6948 11.27434 4.224344 -20.3467 0.361799 19.69552 4.773044 -7.29111 -4.92525 10.58392 -9.72229 -3.78397 -3.10778 -4.22282 12.79471 17.85508 -0.81006 11.29445 12.80304 8.517706 5.980879 -10.6173 9.935659 -4.24847 -2.89563 TTWO 10.42026 3.076121 10.92564 -7.06794 1.226693 7.804169 0.629496 5.049151 -1.87154 14.65106 4.574669 1.337672 6.029254 -10.8681 -3.90713 -6.89452 15.48523 0.730727 14.5448 -7.75807 -1.37315 15.55865 6.536145 -1.50845 -0.41184 3.697579 4.647963 -9.27467 13.8285 -2.56433 5.939916 8.168153 3.683704 -1.55061 10.89336 0.091877 8.805608 6.166897 3.988954 5.990155 22.04024 -4.43842 8.242892 22.94724 4.450342 8.14633 TWTR 1.335428 -14.8682 -15.0064 -16.4988 -16.7565 26.2947 10.30022 10.09073 3.678392 -19.6006 0.651073 -14.0632 4.627823 28.11084 4.159734 -22.2045 -5.87782 -1.22716 -14.3843 -10.3837 -3.05865 5.642168 -10.7519 -8.90764 -27.4084 7.837143 -8.68446 -11.6716 4.093967 11.08381 -1.61669 15.42471 19.96959 -22.1458 2.998357 -11.8742 8.05816 -10.5394 -5.22975 10.18411 11.10505 -2.51633 -10.0308 5.006333 -0.32655 22.13881 TXN -2.75564 6.037736 4.893238 -2.98982 3.366337 1.724138 -2.60166 4.172973 -1.01702 4.863402 9.585179 -1.75487 0.602156 10.00935 -2.7466 -4.61735 3.1544 -7.88627 -2.30997 -4.28171 3.511706 15.28144 2.468265 -5.70511 -2.72232 0.150036 8.278755 -0.02861 6.231234 3.362838 11.9152 -0.32108 0.900334 0.934688 5.105601 -1.32853 4.145343 1.389706 5.112261 -1.1548 4.120349 -6.80021 6.367712 1.679477 8.144726 8.470984 UNH -4.01062 6.903708 6.491316 -8.47664 6.116738 3.146935 -0.85627 6.946329 -0.06841 10.15652 3.810125 2.875473 5.104362 6.945882 4.447356 -5.82467 7.908438 1.914342 -0.4918 -4.69522 0.703579 1.525731 -4.30464 4.807674 -2.11813 3.401327 8.655235 2.146711 1.501239 6.094267 1.396431 -5.01302 3.359784 0.93 12.45374 1.056407 1.247178 1.983442 -0.48926 6.577645 0.111546 6.22551 3.37623 3.606366 -1.25077 7.247248 USO -1.47225 5.574713 -0.40827 -0.73791 3.744493 3.184713 -6.59722 -1.52829 -3.77517 -10.9852 -16.4871 -20.4066 -12.4754 1.571268 -6.96133 21.79335 -0.97513 -2.11718 -21.5795 1.92431 -7.61485 0.885559 -12.6941 -14.9365 -12.2827 -6.75575 7.757778 16.48485 5.034248 -2.54738 -15.6639 6.127541 5.481931 -3.67965 3.78867 7.197813 -3.45297 1.10841 -7.10424 -3.8094 -2.79437 -4.67847 8.140526 -6.41296 8.217373 4.703864 V -3.25579 5.065756 -4.46136 -6.13824 6.233391 -1.9178 0.142376 0.906148 0.399962 13.15086 7.14571 1.55312 -2.78032 6.625711 -3.56419 0.978444 4.163592 -2.22772 12.19657 -5.20793 -2.30014 11.36951 2.02265 -1.85787 -3.95584 -2.65029 5.629952 0.983724 2.376031 -6.06256 5.211226 3.811011 2.204969 -0.24975 -6.10706 0.875329 5.971279 6.483702 1.027539 2.594312 4.523687 -1.58263 6.093361 4.053551 1.571515 4.413991 VCIT 2.031439 1.505819 0.004016 1.084356 1.423598 0.156007 -0.24455 1.464813 -1.32523 1.145102 0.726204 -0.24867 3.019744 -0.99021 0.366277 0.035194 -0.74832 -1.25372 0.20302 -0.93084 1.725193 0.278398 -0.01003 -0.71061 0.465681 1.059312 2.313562 0.973406 0.039885 2.592937 0.97642 -0.21294 0.166457 -0.9005 -2.99424 0.561983 0.321727 0.903318 -0.03583 1.109676 0.988574 -0.12164 0.885853 0.676226 -0.4577 0.111727 VEU -7.47092 7.541542 0.460863 1.470881 1.919687 1.677744 -1.47256 1.009317 -4.87794 0.203087 -0.32428 -3.95599 -0.02134 5.848453 -1.41158 4.740406 -1.0384 -2.80729 -0.28836 -7.74633 -4.03517 6.685433 -1.31926 -2.53115 -5.60779 -2.46021 8.287214 2.098922 -0.80437 -0.73734 4.227375 0.673978 1.562481 -1.71492 -2.13718 1.904947 4.102146 1.220596 2.961083 2.040738 2.991403 0.445293 3.307973 0.548051 1.748913 1.864088 9.237984 -4.67971 -2.95897 -6.01382 -1.44329 -2.4065 -6.47302 -6.47072 -4.55469 2.590993 -8.98246 2.074927 -2.22991 -0.31132 -6.92101 0.719454 13.68798 -3.28519 -22.5446 10.29475 -3.26011 20.30744 -13.226 1.020653 -12.379 27.21114 3.72134 -5.23451 0.733376 -1.67673 15.27532 -11.7939 -12.715 1.833819 12.26598 5.463141 -4.67166 18.01377 3.166861 -6.79917 -15.0787 -6.32659 -0.27399 16.57667 7.386876 23.33053 -9.06539 4.341213 14.34367 25.71014 -27.1808 10.22594 -19.2518 21.91119 -9.6764 -8.80685 0.54054 7.259162 5.490114 -1.31361 -4.23629 -2.50789 10.84566 -1.62333 1.374959 0.810176 -4.69626 -12.951 7.38221 -5.54804 8.815443 -3.46906 7.292703 -4.59518 -5.18093 10.32729 2.021591 1.803021 3.051869 5.858482 -0.72068 -1.95289 7.820765 -11.6486 4.860531 4.617934 7.966603 -4.80954 5.700534 5.283988 -1.95159 11.00391 -5.33928 2.851204 5.356458 -11.3369 -22.37 -10.162 2.472971 1.180095 8.844569 -0.97844 -2.8205 5.929219 3.052999 1.183439 3.078958 7.423236 2.028501 -8.34511 2.801335 -7.08436 -0.33429 0.360178 -1.26574 -1.63391 0.135638 -1.20382 0.444518 -0.31271 0.632405 0.422808 -0.61683 -1.0691 -0.39272 1.369769 0.552676 1.957439 5.591754 -5.41775 -0.56385 0.430167 -2.13342 -2.27604 2.733519 -2.50346 0.294532 -8.48971 1.286583 -5.12554 VGK -4.57483 7.34272 -0.64739 2.64631 0.776731 -0.07624 -4.32027 0.732218 -3.97688 -1.90148 2.067565 -4.69331 0.515169 6.093394 -2.43456 4.241977 0.283086 -3.27589 2.667655 -7.01913 -4.12283 5.896706 -1.24808 -2.62714 -5.56333 -3.24649 7.012457 2.751748 -0.5114 -4.0593 3.451925 0.663513 0.779733 -3.54965 -2.34993 4.889991 2.922036 0.54752 4.399996 3.847615 4.848548 -0.57471 2.759162 -0.01945 3.12141 0.372884 VZ -1.21133 -0.91628 -0.02102 -0.68587 6.912048 -2.06165 4.165223 -1.19 0.341228 1.628708 0.676617 -7.53113 -1.1238 8.182017 -1.65824 4.883128 -1.98255 -5.72411 1.571507 -1.66702 -5.4336 9.133627 -3.05034 1.684169 9.445288 1.500913 6.583588 -4.82183 -0.08852 9.685305 0.206475 -5.57856 -0.68883 -6.42136 3.732204 6.943948 -7.23105 1.225048 -1.80312 -4.75267 1.530068 -4.30528 9.742486 -0.97843 3.078647 -2.19419 WMT -5.09595 0.026781 2.97444 4.291509 -3.09538 -2.21441 -1.98481 3.273185 1.284768 -0.26154 14.77645 -1.34189 -1.04797 -1.23558 -1.40656 -5.10638 -4.24257 -4.49711 1.480333 -9.47281 0.169937 -11.7212 2.795248 5.045698 8.244486 -0.05014 3.985288 -2.37531 6.634088 3.144736 -0.08847 -1.4548 0.931848 -2.93181 0.575547 -1.19496 -3.48329 6.238094 2.333822 4.250777 5.184259 -3.77501 5.625032 -1.88038 -0.00034 11.64535 XBI 15.36866 8.994075 -12.7841 -9.65048 2.773246 16.862 -5.05877 10.77291 -3.35005 9.886517 4.912772 3.965846 7.073903 7.50313 5.174771 -8.50111 15.43159 6.09123 1.268633 -13.0559 -15.8594 7.036145 8.494672 -2.69249 -28.0015 -5.26233 7.955312 4.384115 7.629533 -6.77952 14.75441 -3.20995 10.35094 -15.3164 11.60175 -5.55498 9.6069 8.141818 -1.24174 2.978555 -5.28116 14.10145 1.212716 7.150629 3.224241 -3.47454 XLF -3.65965 3.038936 3.330083 -1.70098 1.502732 2.419277 -1.45119 4.239179 -0.40084 2.89167 2.348993 1.87035 -6.95512 5.823555 -0.62211 0.082953 1.947783 -0.4531 3.40443 -7.06069 -2.8021 6.266549 1.993355 -2.35832 -8.86439 -2.92055 7.242923 3.59 1.877602 -3.27301 3.458451 3.82778 -2.89945 2.259793 14.02242 3.729415 0.218065 5.236705 -2.98308 -0.89282 -1.24997 6.454042 1.632473 -1.6444 5.042662 2.771562 XOM ExcMkt -8.93281 -3.32 5.192481 4.65 1.464631 0.43 4.842342 -0.19 -1.17138 2.06 0.149209 2.61 -1.72825 -2.04 1.22812 4.24 -5.43937 -1.97 2.828283 2.52 -5.71111 2.55 2.109565 -0.06 -5.44078 -3.11 2.044931 6.13 -3.99819 -1.12 2.788235 0.59 -1.66338 1.36 -2.34742 -1.53 -4.79567 1.54 -4.11715 -6.04 -1.18288 -3.08 11.28447 7.75 -0.42613 0.56 -4.55323 -2.17 -0.13829 -5.77 3.87292 -0.07 4.271953 6.96 5.744277 0.92 1.54178 1.78 5.282179 -0.05 -5.12988 3.95 -1.20456 0.5 0.140661 0.25 -4.55712 -2.02 5.687906 4.86 3.360607 1.82 -7.09739 1.94 -2.21126 3.57 0.8185 0.17 -0.48897 1.09 -0.54163 1.06 0.225714 0.78 -0.9247 1.87 -3.79532 0.16 7.31207 2.51 1.581139 2.25 SMB 0.86 0.32 -1.89 -4.25 -1.85 3.07 -4.24 0.36 -3.83 4.23 -2.09 2.54 -0.56 0.48 3.02 -2.97 0.87 2.83 -4.14 0.48 -2.64 -1.97 3.64 -2.82 -3.36 0.78 0.87 0.68 -0.26 0.65 2.65 1.15 2.02 -4.37 5.49 0.07 -1.02 -2 1.19 0.73 -2.55 2.16 -1.4 -1.69 4.54 -1.94 HML -2.09 -0.4 5.08 1.14 -0.27 -0.74 0.01 -0.58 -1.23 -1.68 -2.99 2.06 -3.47 -1.79 -0.46 1.86 -1.37 -0.79 -4.12 2.68 0.52 -0.08 -0.52 -2.58 2.1 -0.48 1.12 3.26 -1.81 -1.49 -1.13 3.31 -1.48 4.18 8.27 3.6 -2.78 -1.8 -3.18 -1.9 -3.78 1.32 -0.28 -2.24 3.03 -0.06 -0.13119 1.440673 5.519755 -6.25597 -0.48087 2.009613 -2.56424 -1.40484 3.242815 -2.98564 -0.08257 -8.08755 -0.85594 -5.02826 6.228753 3.918646 3.211599 -11.817 0.047574 4.35719 -3.54426 5.398074 3.67714 5.1266 -1.95246 7.911721 5.442701 -6.95617 11.28181 2.00851 7.839367 -15.6729 -0.69081 -0.71323 -6.24552 3.62787 4.019802 7.897848 -2.18422 6.59309 -2.80266 -4.27488 -0.61802 1.972778 9.905318 -3.33373 -2.96928 -0.9949 8.701113 0.469805 -0.05495 4.929726 -4.34128 -17.672 3.030719 -12.2989 3.378647 1.794976 6.44679 -3.03535 -4.27707 -0.57526 -1.12361 -1.88692 4.954705 1.199571 -2.36548 -4.90356 2.445571 -11.3081 0.775728 0.330219 4.265897 -12.4701 -1.61195 4.068551 5.402889 1.694072 -1.63468 -0.78846 5.899645 -6.47088 0.605779 -14.4164 3.12 1.06 5.58 -3.65 -2.35 0.29 2.65 0.48 3.19 3.44 0.06 -7.68 1.69 -9.55 -0.66 -1.26 -3.03 0.28 3.93 1.1 5.24 1.17 -2.15 1.23 -2.37 -4.68 -0.74 -2.61 -0.05 0.14 -1.37 -1.19 -0.11 0.53 -3.16 -2.39 0.39 -4.12 -1.34 3.41 0.2 -1.51
Homework AD 717 Week 4 – Single-factor and multi-factor models Unless stated otherwise, round your answers to two decimal points, and do not round intermediate calculations. Problem 1. [20 points] The following are estimates for two stocks. Stock A B Expected Return 10% 17 Beta 0.95 1.50 Firm-Specific Standard Deviation 35% 45 The market index has a standard deviation of 19% and the risk-free rate is 12%. a) What are the standard deviations of stocks A and B? b) Suppose we build a portfolio with the following proportion: 0.35 in stock A, 0.35 in stock B, and 0.3 in riskfree T-bills. Compute the expected return, standard deviation, beta, and nonsystematic standard deviation of the portfolio Problem 2. [20 points] Suppose that the index model for stocks A and B is estimated from excess returns with the following results: 𝑅𝐴 = 3.00% + 1.05𝑅𝑀 + 𝑒𝐴 𝑅𝐵 = −1.20% + 1.20𝑅𝑀 + 𝑒𝐵 and σM = 29%; R-squaredA = 0.29; R-squaredB = 0.14 Assume you create portfolio P with investment proportions of 0.60 in A and 0.40 in B. a) What is the standard deviation of the portfolio? [Hint: R-squared is the variance explained by the market risk 𝛽 2 𝜎𝑀2 divided by the variance in the stock 𝜎𝐵2 .] b) What is the beta of the portfolio? c) What is the firm-specific variance of the portfolio? (Round to 3 decimals.) d) What is the covariance between the portfolio and the market index? (Round to 3 decimals.) Problem 3. [10 points] Consider a security of which we expect to pay a constant dividend of $18.49 in perpetuity. Furthermore, its expected rate of return is 20.1%. Using the equation for present value of a perpetuity, we know that the price of the security ought to be 𝑃𝑟𝑖𝑐𝑒 = 𝐷/𝑘, where D is the constant dividend and k is the expected rate of return. Assume that the risk-free rate is 3%, and the market risk premium is 6.4%. What will happen to the market price of the security if its correlation with the market portfolio doubles, while all other variables, including the dividend, remain unchanged? Problem 4: Fama-French Three-Factor Model. [50 points] Download the Excel spreadsheet Portfolio_Returns.xlsx from Blackboard. The file contains the monthly excess returns in percent of a wide range of stocks and of QQQ (Nasdaq ETF), IWM (Russell ETF), and MCHI (China ETF). Since some companies have not been publicly listed for the entire time period from January 2014 to December 2018, we cannot use them for our analysis. Please research the QQQ, IWM, and MCHI ETFs to see if you can use them as a replacement for missing stocks. For example, Alibaba (BABA) has not been listed for the entire time period, however, MCHI can serve as a decent albeit not perfect replacement in your analysis. Additionally, the file contains the time series ExcMkt, SMB, and HML, representing the excess market return, the small-minus-big return, and the high-minus-low return. For the following part, consider only your three largest holdings by market value. a) Calculate 𝛼, 𝛽 using the single-factor model. b) Estimate their risk (systematic and firm-specific) according to the single-factor model. For the following part, consider your entire portfolio. c) Calculate the weights of the stocks in your portfolio. Remember, stocks you’re selling short have negative weights, and the weights need to sum up to one. d) Produce a time series for your portfolio of n stocks return using 𝑅𝑃 (𝑡) = 𝑤1 𝑅1 (𝑡) + ⋯ + 𝑤𝑛 𝑅𝑛 (𝑡). e) Estimate your portfolio’s sensitivity to Fama-French’s three factors, that is, run the regression 𝑅𝑃 (𝑡) = 𝛼𝑃 + 𝛽𝑚 𝑅𝑚 (𝑡) + 𝛽𝑆𝑀𝐿 𝑆𝑀𝐿(𝑡) + 𝛽𝐻𝑀𝐿 𝐻𝑀𝐿(𝑡) + 𝑒𝑃 . Remember: 𝛽𝑚 is a proxy to how much market risk your portfolio carries; 𝛽𝑆𝑀𝐿 is your exposure to small over big firms; 𝛽𝐻𝑀𝐿 is your exposure to firms with a high book value compared to their market capitalization. These three betas are assumed to be non-diversifiable risk factors, and in the long run investors should be rewarded for their risk of having greater betas. f) Analyze your results. This includes, but is not limited to: classifying your portfolio in terms of aggressiveness, small vs large cap, value vs growth; identifying which of your holdings potentially contribute to the portfolio classification how; going back to your portfolio philosophy statement and discussing if your holdings reflect your investment goal; using the expected values of 𝑅𝑚 , 𝑆𝑀𝐿, 𝐻𝑀𝐿 to compute the expected return of your portfolio in the coming month. Important: • Submit Problems 1 through 3 at the beginning of our next class in handwritten form. Scans, prints, and similar forms of submission will not be accepted for this part of the homework. • Submit Problem 4 in a Word document to Blackboard at the specified time which includes the relevant tables from Excel or the data analytics tool of your choice.

Tutor Answer

JeffDaniels
School: Cornell University

flag Report DMCA
Review

Anonymous
Thanks, good work

Similar Questions
Hot Questions
Related Tags
Study Guides

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors