Use the following from Excel to solve
Available capital is $1,263,897 and all capital must be invested at a minimum. Short selling is allowed, but no more than $379,169.10 in any stock and no more than $631,948.50 in total short sales. All capital generated from short sales can be utilized on long positions in each stock but total investment cannot exceed $1,516,676.40 due to margin restrictions. 1) What is the expected return of the minimum variance portfolio? Your answer must be in percentage and with 2 decimal places. 2) What is the standard deviation of the minimum variance portfolio? Your answer must be in percentage and with 2 decimal places. 3) What is the lowest coefficient of variation possible? 4) What is the maximum expected return ? Your answer must be in percentage and with 2 decimal places. 1/1/13 1/1/13 4/1/15 5/1/15 5/1/15 7/1/15 4/1/13 10/1/15 11/1/15 17/1/13 1/1/14 1/1/14 3/1/14 4/1/14 765 5/1/14 6/1/14 7/1/14 8/1/14 9/1/14 10/1/14 11/1/14 12/1/14 101 723541 93.9 1/1/15 2/1/15 118 385651 103.146 9/1/15 115 124252 4/1/15 115. 5/1/15 120. 6/1/15 116.534195 100.406 7/1/15 112 697105 106 299 34 8/1/15 104 911461 105 781 35 2017 9/1/15 102 941124 104.9 36 5547 10/1/15 111 527328 112 874 44.4826 11/1/15 110.407394 122 223 44 0886 2 66 0148 12/1/15 98.657883 120.735 41 3787 1/1/16 91 23465 115 318 36 2059 2/1/16 90.625412 113 814 40 3732 25.8546 71.4393 179.903 3/1/16 102.708244 122 351 43.116 26.0882 73 2366 191 019 4/1/16 88 337189 123.448 43 0101 28.7903 71 288 192.76: 5/1/16 94.104469 121 816 40 9565 30 5418 72 6968 196.04 6/1/16 90.638489 418 341 37 8037 31 2682 75 9531 195.703 7/1/16 98 801666 128.129 35.7684 32.7601 76 7784 203.896 8/1/16 100 593552 124.3 35.6428 30.9041 78 9346 204.14 9/1/16 107 769504 419.87 37.6876 30 3283 81 1406 203.126 10/1/16 108 230583 113.657 38.8317 28 3943 78.4735 200.612 11/1/16 12/1/16 105 954799 120.541 45 1689 28 5 208.003 $10 97081 125 564 48 299 28 6683 76 6009 210.976 50 1/1/17 116 269257 128 842 50 8005 28 6954 29.8078 216.047 2/1/17 191 25444 135.706 56.1321 308568 83.6262 224.504 3/1/17 198 241959 137.504 52 2087 31 2534 82 5059 223.818 4/1/17 138 23233 147.075 54.6927 30 9825 80 1919 227-046 5/1/17 146 948749 144.635 58 4576 29 8282 a1 5cas 230.22 6/1/17 139.160446 145 366 60 4519 30:984 80.639 230.564 7/1/47 143 741487 141.765 54 2141 30 5874 840348 23645 8/1/17 154 466263 142 021 50 8288 31 2884 86 0459 237.14 9/1/17 149.50444 455.921 10/1/17 163 977585 158 027 54.7 33 252 84 8429 240.724