Boston University Factor Models & Behavioral Finance Questions HW 3

User Generated

Xnyrb

Business Finance

Boston University

Description

Answering the homework questions that are uploaded. 6 Questions that can be done on Excel and that are based on financial calculations and portfolio management. I need the answers in an excel workbook with the work shown on there. The 6th question is a short answer question about investment decisions.

Unformatted Attachment Preview

Name: _______________________________________ Homework 3 Short Calculations 1. The following are estimates for two stocks: Stock Expected Return A 10% B 17 Firm-Specific Beta Standard Deviation 0.95 35% 1.50 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 risk-free T-bills. Compute the expected return, standard deviation, beta, and nonsystematic standard deviation of the portfolio 2. 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.) 3. 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? -1- Excel Problems 4. In this problem, we will build an active portfolio, that is, a portfolio consisting of individually selected stocks to complement our passive investments. To do this, create an Excel worksheet. Use the following instructions with a market risk premium 𝒓𝑴 − 𝒓𝒇 of 5%. Consider the following annualized information regarding a selection of six stocks (Apple Inc, Amazon.com Inc, Intuitive Surgical Inc, Target Corp, Walmart Inc, and Exxon Mobil Corp) and the S&P 500 that we have obtained from a regression analysis: • • • SD of Excess Return Beta S&P 500 0.1701 1.00 SD of Systematic Component 0.1701 $AAPL 0.2869 1.20 0.2041 0.2016 $AMZN 0.3554 1.60 0.2721 0.2286 $ISRG 0.3409 1.50 0.2551 0.2261 $TGT 0.2761 0.80 0.1361 0.2403 $WMT 0.2296 0.60 0.1020 0.2057 $XOM 0.2163 0.85 0.1446 0.1609 SD of Residual 0.0000 Find the covariance matrix according to the index model, where the covariance between two assets is defined as 𝐶𝑜𝑣A𝑟C , 𝑟E F = 𝛽C 𝛽E 𝜎+2 . [Hint: You can find the 𝜎+2 from the above table if you compute the covariance of the index with itself because 𝛽G&I JKK = 1.] Create a forecast of 𝛼C for each company, that is, the return in percent you anticipate in excess over the return expected through its 𝛽C in the coming year. [Example: If the 𝛽 of the company were to be 1, you’d expect an excess return of 5% in the absence of 𝛼. However, if you anticipated that the company’s stock was going to realize an excess return of 4% or 6%, then its 𝛼 would be -1% or +1%, respectively.] This forecast can just be a guess for this problem! Construct the risky portfolio according to Table 27.1 in your book or according to “How to build your portfolio” in today’s lecture slides. Compute and report the following parameters for your portfolio: a) b) c) d) Weights of the securities in your active portfolio and its 𝛼. Weight of the active portfolio in the overall portfolio. Aggregate alpha and beta of the active portfolio and of the overall portfolio. Compare the Sharpe ratio of an investment in the market with the Sharpe ratio of the overall portfolio you have constructed! You need to report answers with your own assumptions. But you can check your work with: Alpha AAPL AMZN ISRG TGT WMT XOM 0.5% 0.5% 1.0% -0.5% 1.0% -0.8% Using these values for each stock, your active portfolio should have 𝛼I = 3.263%, 𝛽I = 1.584. The overall portfolio should come out to 𝛼P = 0.527%, 𝛽P = 1.094. The Sharpe ratio of this overall portfolio is 0.390, whereas the Sharpe ratio of the market portfolio is 0.294. -2- Name: _______________________________________ 5. (Fama-French Three-Factor Model.) You will analyze the risk-factors associated with some stocks in your portfolio. To limit the amount of work, consider only the five largest holdings in your portfolio by market value. Instructions: • Download the Excel spreadsheet Portfolio_Returns.xlsx from Blackboard. § The file contains the monthly excess returns 𝑅C = 𝑟C − 𝑟S in percent for a wide range of stocks and for QQQ (Nasdaq ETF), IWM (Russell ETF), and MCHI (China ETF). § 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 – these are the factors of the Fama-French Three-Factor model. • Since not all companies are going to be available in the Excel file, 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 we will study. However, MCHI can serve as a decent albeit not perfect replacement in your analysis. (If none of these fit, do not use the stock and instead include your next-largest holding.) With your five largest positions and the data from the Excel file, solve the following problems: a) Calculate 𝛼, 𝛽 using the single-factor model. b) Estimate their risk (systematic and firm-specific) according to the single-factor model. 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 return time series for your portfolio of the largest three stocks, using 𝑅I (𝑡) = 𝑤X 𝑅X (𝑡) + 𝑤2 𝑅2 + 𝑤Y𝑅Y. Estimate your portfolio’s sensitivity to Fama-French’s three factors, that is, run the regression 𝑅I (𝑡) = 𝛼I + 𝛽+ 𝑅+ (𝑡) + 𝛽G+Z 𝑆𝑀𝐿(𝑡) + 𝛽^+Z 𝐻𝑀𝐿(𝑡) + 𝑒I . Remember: 𝛽` is a proxy to how much market risk your portfolio carries; 𝛽G+Z is your exposure to small over big firms; 𝛽^+Z is your exposure to firms with a high book value compared to their market capitalization. These three betas are assumed to be nondiversifiable risk factors, and in the long run investors should be rewarded for their risk of having greater betas. e) 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. Short Essay 6. Humans suffer from cognitive biases, and we must consider this making investment decisions. One relevant bias is overconfidence. We are prone to overestimate our ability to make forecasts and to underestimate the risks. One way to address this is a “pre-mortem” exercise. For this, consider your investment philosophy from HW 1. Imagine at the end of the semester your investment results are disappointing and your portfolio is not fulfilling its objective. Write a one-page report, describing what could be the reason things went wrong. -3- The following problems are for your practice only. They will help you prepare for the exam, but you need not submit them. Practice Problems Chapter 8, Problems 1, 4, 7 Chapter 9, Problems 1, 10-16, 23 -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
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

I'm almost done buddy. Here is the work I've done so far

HOMEWORK 3
1
A)
Stock
A
B
T-Bills

Weight

Expected Return Beta
FS-STDEV
0,35
10%
0,95
35,00
0,35
17%
1,5
45,00
0,3
12%
0
0

B)
Expected Return
13,05%
Beta
0,8575
Non-Systematic Variance398,13
Residual STDEV
19,95
Total Variance
663,57
STDEV
25,76

Market Index RFR
Stock STDEV
19,00
12%
63175,00%
128250,00%
0

Market Standard deviation
Market Variance

A
B

29%
0,0841

R-square Beta
beta*Market
Variance
VarianceWeights Variance*w^2
0,29
1,05 0,088305
0,3045
0,6 0,10962
0,14
1,2 0,10092 0,720857
0,4 0,115337
Portfolio Risk
0,224957
Portfolio Standard
0,474296
deviation

B)
Alpha
A
B
Portfolio

Beta
3
-1,2
1,8

C)
Portfolio Variance
0,224957
Portfolio Beta 2,25
Beta Squared 5,0625
Market Variance
0,0841
Firm Specific -0,2008
Risk
D)
Portfolio Beta 2,25
Market Variance
0,0841
Cov (Portfolio,
0,189225
Market)

1,05
1,2
2,25

D
18,49
k
20,10%
Risk free rate
3%
Risk Premium 6,40%
Required Rate9,400%
of Return ®
Stock Price 91,99005

Expected Return
20,10%
Risk free
3%
Risk premium 6,40%
Initial correlation
267%
After doubling the correlation
NewCorrelation
5,34375
New Expected
37,200%
Retun
New Stock Price
49,7043
%change in stock
-45,97%
Price

market risk premium=
S&P 500
AAPL
AMZN
ISRG
TGT
WMT
XOM

Variance-covariance matrix
Market Variance
S&P 500
AAPL
AMZN
ISRG
TGT
WMT
XOM

5%
SD of Excess ReturnBeta
0,1701
0,2869
0,3554
0,3409
0,2761
0,2296
0,2163

0,02893401
S&P 500
$AAPL
0,0289
0,0347
0,0463
0,0434
0,0231
0,0174
0,0246

market risk premium=

$AMZN

$ISRG

$TGT

$WMT

0,0347
0,0417
0,0556
0,0521
0,0278
0,0208

0,0463
0,0556
0,0741
0,0694
0,0370
0,0278

0,0434
0,0521
0,0694
0,0651
0,0347
0,0260

0,0231
0,0278
0,0370
0,0347
0,0185
0,0139

0,0174
0,0208
0,0278
0,0260
0,0139
0,0104

0,0295

0,0394

0,0369

0,0197

0,0148

5%
Beta

S&P 500

1
1,2
1,6
1,5
0,8
0,6
0,85

SD of Systematic ComponentSD of Residual
0,1701
0
0,2041
0,2016
0,2721
0,2286
0,2551
0,2261
0,1361
0,2403
0,102
0,2057
0,1446
0,1609

Expected Return alpha
(%) %
1

5

0,00

$AAPL

1,2

6,5

0,50

$AMZN

1,6

9

1,00

$ISRG

1,5

9

1,50

$TGT

0,8

3,5

-0,50

$WMT

0,6

4

1,00

$XOM

0,85

initial weight

3

Weight

-1,25

Weight x Alpha

weight x Beta

(weight x SD of Residual)^2
weighted of expected excess return

$AAPL

12,30237465

0,447821169

22,3911%

0,537385403

0,008150613

0,537385403

$AM...


Anonymous
I was stuck on this subject and a friend recommended Studypool. I'm so glad I checked it out!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags