HOMEWORK > MGT_8813_HW_4_Portfolio_Optimization_Stroup.xlsm Georgia Institute Of Technology MGT 8813

Georgia Institute Of Technology MGT 8813 TE LOW KO WEN BAC AAPL LNN Dec-19 113.3128 50.00843 20.72241 32.497189 71.81092 92.98201 see below starting in line Jan-20 109.9823 52.7641 20.21858 30.457336 75.68943 96.89542 Feb-20 101.2882 48.32793 17.61545 26.440269 66.84909 95.92674 Mar-20 81.78518 39.97964 13.96683 19.695684 62.33318 88.96224 Apr-20 99.55837 41.82499 18.64122 22.4542 ...[Show More]

Georgia Institute Of Technology

MGT 8813
TE LOW KO WEN BAC AAPL LNN Dec-19 113.3128 50.00843 20.72241 32.497189 71.81092 92.98201 see below starting in line Jan-20 109.9823 52.7641 20.21858 30.457336 75.68943 96.89542 Feb-20 101.2882 48.32793 17.61545 26.440269 66.84909 95.92674 Mar-20 81.78518 39.97964 13.96683 19.695684 62.33318 88.96224 Apr-20 99.55837 41.82499 18.64122 22.454243 72.01813 87.42741 May-20 124.61 42.54501 19.9553 22.519598 77.93549 91.23535 Jun-20 129.17 40.72218 20.49164 22.174147 89.66415 89.90941 Jul-20 142.3527 43.44656 21.80883 23.391172 104.4706 94.55063 Aug-20 158.0411 45.55267 19.70134 24.199711 126.8669 97.4368 Sep-20 159.1638 45.40551 21.0293 22.648449 114.065 94.55226 Oct-20 151.7171 44.55851 20.60494 22.436998 107.2197 102.9825 Nov-20 150.0432 47.84059 20.73696 26.659319 117.2562 113.271 Dec-20 154.5593 51.2432 20.73648 28.694744 130.9161 125.9798 Jan-21 160.6643 44.99199 19.29855 28.244865 130.1959 137.1303 Feb-21 154.3681 45.77689 19.32693 33.065067 119.639 157.1561 Mar-21 183.7729 49.2529 19.16612 36.856453 120.6972 163.7345 Apr-21 189.6384 50.85944 21.44732 38.801018 129.8964 162.9091 May-21 188.8216 52.09371 22.065 40.581676 123.1279 161.779 Jun-21 187.9881 50.98192 22.35215 39.471157 135.5609 162.751 Jul-21 186.7476 54.138 22.15172 36.878185 144.3699 158.2313 Aug-21 198.4251 53.45452 21.97038 40.137234 150.2789 162.2291 Sep-21 197.4227 49.80924 20.80091 40.810188 140.2643 149.7524 Oct-21 227.5529 53.91533 21.39577 46.169678 148.4919 143.7146 Nov-21 238.8961 50.16602 19.74551 42.971245 163.8565 143.5666 Dec-21 252.4628 57.07083 23.01294 42.990562 176.2762 150.2732 Jan-22 231.8247 58.80579 22.22172 44.799549 173.5065 124.8157 Feb-22 216.6259 59.99136 21.9419 42.915913 163.9169 129.7194 Mar-22 198.1344 59.76003 21.19892 40.022488 173.5586 155.6285 Apr-22 193.7638 62.75245 19.17544 34.81282 156.7007 133.9609 May-22 192.1569 61.55781 18.08857 36.295879 147.9438 124.8914 Jun-22 171.8589 61.10132 18.44371 30.373404 136.0964 131.994 Jul-22 188.4476 62.77539 20.54403 33.178272 161.7688 153.0025 Aug-22 192.1013 60.36885 18.73678 32.982006 156.503 159.3627 Sep-22 185.8377 54.80251 18.37651 29.635723 137.7608 142.678 Oct-22 192.9028 58.97614 20.43145 35.599628 152.8527 168.5887 Nov-22 211.4619 62.68125 22.18159 37.387508 147.5595 175.7485 Dec-22 198.2201 63.12579 22.37585 32.715305 129.7319 162.4956 Returns DATE LOW KO WEN BAC AAPL LNN Jan-20 -3.0% 5.4% -2.5% -6.5% 5.3% 4.1% Feb-20 -8.2% -8.8% -13.8% -14.1% -12.4% -1.0% Mar-20 -21.4% -19.0% -23.2% -29.4% -7.0% -7.5% Apr-20 19.7% 4.5% 28.9% 13.1% 14.4% -1.7% P

[Show Less]