YOU CAN SUBMIT AN EXCEL FILE FOR THIS ASSIGNMENT Calculate the monthly returns of the stocks of the following companies from January 2014 to May 2020. Yahoo Finance provides monthly returns! Use the prices given under \"adjusted close\" to avoid dividend and split issues. IBM Tesla 1. (50 points) What is the monthly expected return and the standard deviation of a portfolio that is composed of (x% IBM and y% Tesla), where {x,y | x%+y%=100%, x,y in {0,100}}* *i.e. do not have negative weights, only positive weights. Have at least 100 expected value and standard deviation combinations calculated and plot the \"opportunity set\". 2. (30 points) What is the composition (the weights of the assets) of a portfolio that is formed by investing in IBM and Tesla stocks and that has the lowest standard deviation? (That is, what is the weight of each stock in the lowest standard deviation portfolio...among all possible combinations, not only among the ones you calculated in question 1). You are expected to solve this question analytically. 3. (20 points) You have $10,000. What is the expected value and the standard deviation of a portfolio that is formed by investing $5K at the risk free rate and $5K on the portfolio you found in question 2 (assume that monthly risk free rate is 0.0025%) ? Does there exist another portfolio consisting of these assets AND that has a higher expected return and lower risk, measured by standard deviation? If there is, describe that portfolio with one sentence, do not calculate it. Date Adj Close (Te: Adj Close ( IBM) 12/1/13 10.02867 116.7883 Monthly Retu Monthly Retu TeslaWeight IBM Weight Portfolio Retu Portfolio Standard Deviation Covariance Calculation 1/1/14 12.094 110.0078 20.59% 581 0.982165 0.017835 0.201234 - #NAME? 0.002109 2/1/14 16.32067 115.294 34.95% 4.81 0.582743 0.417257 0.22371 3/1/14 13.89667 120.5088 -14.85%% 4.52% 0.005766 0.994234 0.044113 4/1/14 13.85933 123.0005 0.27% 2.07% 0.646761 0.353239 0.005566 5/1/14 13.85133 115419 0.06% 6.16% 0.664243 0.335757 -0.021079 6/1/14 16.004 114.1452 15.54% 1.10% 0.836487 0.163513 0.128196 7/1/14 14.88667 120.6941 -6.98% 5.74% 0.684774 0.315226 -0.029723 8/1/14 17.98 121.0908 20.78%% 0.334 0 0.601535 0.398465 0.126304 9/1/14 16.17867 120.2423 -10.026 -0.70 0.974318 0.025682 -0.097792 10/1/14 16.11333 104.1345 0.40% -13.40 0.714466 0.285534 -0.041136 11/1/14 16.30133 102.7219 1.17% 1.36%% 0.22738 0.77262 -0.007827 12/1/14 14.82733 102.3216 9.04%% 0.39% 0.790589 0.209411 -0.072303 1/1/15 13.57333 97.77445 -8.46% 4.449 0.260809 0.739191 -0.054907 2/1/15 13.556 103.2783 0.13% 5.63% 0.892911 0.107089 0.004888 3/1/15 12.58467 103.078 -7.17%% 0.19% 0.90575 0.09425 -0.065083 4/1/15 15.07 110.0076 19.75% 6.72% 0.89545 0.10455 0.18387 5/1/15 16.72 108.9544 10.95% 0.96%% 0.954918 0.045082 0.104121 6/1/15 17 884 105.2558 6.96% 3.394 0.337649 0.662351 0.001022 7/1/15 17.74333 104.8222 0.79% 0.41 0.521087 0478913 -0.006071 8/1/15 16.604 95.698 -6.42%% 8.70 0.124808 0.875192 -0.084193 9/1/15 16.56 94.58746 -0.27%% 1.16 0.649338 0.350662 -0.005791 10/1/15 13.79533 91.39694 -16.69% 3.37% 0.292791 0.707209 -0.072736 11/1/15 15.35067 90.9663 1 1.27% 0.47% 0.761996 0.238004 0.084789 12/1/15 16.00067 90.63415 4.23% 0.37%% 0.528882 0471118 0.020675 1/1/16 12.74667 82.18453 -20.34% 9.32% 0.335562 0.664438 -0.130186 2/1/16 12.79533 86.29409 0.384 5.00% 0.614728 0.385272 0.021612 3/1/16 15.318 100.7612 19.72%% 16.76 0.963866 0.036134 0.196089 4/1/16 16.05067 97.09529 4.78% 3.64% 0.885956 0.114044 0.038227 5/1/16 14.882 102.2847 -7.28% 5.34%% 0.005343 0.994657 0.052772 6/1/16 14.152 101.9552 4.91 0.32% 0.075794 0.924206 -0.006695 7/1/16 15.65267 107 8933 10.60%% 5.82% 0.69422 0.30578 0.091424 8/1/16 14.134 106.7245 1.08%% 0.162427 0.837573 -0.024833 9/1/16 13.602 107.6259 3.76%% 0.84% 0.771417 0.228583 -0.027105 10/1/16 13.182 104.1298 3.09% 3.25% 0.321716 0.678284 -0.031967 11/1/16 12.62667 109.9092 4.21% 5.55%% 0.730964 0.269036 -0.015862 12/1/16 14.246 1134838 12.82%% 3.25% 0.19325 0.80675 0.051022 1/1/17 16.79533 119.3155 17.90% 6.14 0.864515 0.135485 0.161668 2/1/17 16.666 122.9391 -0.77% 3.04 0.818983 0.181017 -0.000809 3/1/17 18.55333 119.9971 11.32%% 2.39% 0.385167 0.614833 0.028905 4/1/17 20.938 110.4533 12.85%% 7.95% 0.5187 0.4813 0.028389 5/1/17 22.734 105.1749 8.58%% 4.78 0.533667 0466333 0.023491 6/1/17 24.10733 107.0373 6.0495 1.77 0.731933 0.268067 0.048962 7/1/17 21.56467 100.5636 -10.55%% 5.95 0.509282 0.490718 -0.082936 8/1/17 23.72667 99.52251 10.03%% 1.13% 0.333988 0.666012 0.025935 9/1/17 22.74 102.0155 4.16%% 2.50 0.847338 0.152662 -0.031412 10/1/17 22.102 108.3299 2.81% 6.19 0.769846 0.230154 -0.007353 11/1/17 20.59 108.2667 6.84%% 0.06%% 0.742513 0.257487 -0.050946 12/1/17 20.75667 108.9582 0.81% 0.64%% 0.744604 0.255396 0.007659 1/1/18 23.62067 116.259 13.80% 6.70% 0.63829 0.36171 0.112308 2/1/18 22.87067 110.5698 -3.18% 4.815 0.113348 0.886652 -0.046225 3/1/18 17.742 110.0382 -22.42% 0.57% 0.269027 0.730973 -0.0645 4/1/18 19.59333 103.9636 10.43% 5.52% 0.730041 0.269959 0.061275 6/1/18 18.982 101.3458 3.12% 2.52%% 0.03269 0.96731 -0.025376 6/1/18 22.86333 101.3034 20.45% 0.04%% 0 0.717563 0.282437 0.146605 7/1/18 19876 105.0959 -13.07% 3.74% 0.880355 0.119645 -0.110548 8/1/18 20.11067 106.2199 1.18% 1.07% 0.390224 0.609776 0.011129 9/1/18 17.65133 110.8345 -12.23% 1.34%% 0.775926 0.224074 -0.085153 10/1/18 22488 84.60832 27 40% -23.66% 0.500546 0499454 0.018972 11/1/18 23.36533 91.08791 3.90%% 7.66% 0.947647 0.052353 0.04098 12/1/18 22.18667 84.37944 5.04%% 736% 0.512073 0487927 -0.061767 1/1/19 20.468 99.78259 7.75% 18.25% 2.25E-05 0.999978 0.18254 2/1/19 21.32533 102.5366 4.1946 2.76% 0.479849 0.520151 0.034455 3/1/19 18.65733 105.9616 -12.51% 3.34% 0.445642 0.554358 -0.037237 4/1/19 15.91267 105.3383 14.71% 0.59 0.594158 0405842 -0.089793 5/1/19 95.365 -22.43% 947% 0.869518 0.130482 -0.207357 6/1/19 14.89733 104.7887 20.68% 988 0.131006 0.868994 0 0.112965 7/1/19 16.10733 112.6459 8.12%% 7.50%% 0.158328 0.841672 0.07597 8/1/19 15.04067 102.9877 6.62% 8.57 0.896475 0.103525 -0.068243 9/1/19 16.058 111.805 6.76% 8.56%% 0.782927 0.217073 0.071541 10/1/19 20.99467 102.8173 30.74% 8.04%% 0.899198 0.100802 0.268335 11/1/19 21.996 103.3708 4.77%% 0.54 0.697459 0.302541 0.034894 12/1/19 27 88867 104.2728 26.7945 0.87 0.259963 0.740037 0.076101 1/1/20 43.37133 111.8109 55.52% 7.23% 0.936783 0.063217 0.524634 2/1/20 44.53267 101.2467 2.68%% 9.45 0.706075 0.293925 -0.008865 3/1/20 34.93333 87.1961 -21.56% -13.88 0.294931 0.705069 -0.161421 4/1/20 52.12533 98.69597 49.214 13.194 0.726779 0.273221 0.393709 5/1/20 55.66667 98.17719 6.79%% -0.539 0471766 0.528234 0.029275 0.265476 0.734524 0.731758 0.268242