A2366 Read-only File Home Insert Draw Formulas Data Review View E 299 B Read Only. You can't have changes to this file Save a copy Dismiss fx 4 B C D E F G 1 Date Open High Low Close Adj Close Volume 2 3/1/1991 3.583333 4,046296 3.574074 4 2.541642 122175600 4 4/1/1991 4.462963 3.925926 4.259259 2.707935 159858000 4 5/1/1991 4.259259 4.944445 4,092593 4.87963 3.102351 150830400 5 6/1/1991 4.861111 5.166667 4.75 5.013889 3.18771 132258000 G 7/1/1991 5.055555 5.513889 4.916667 5.388889 3.426128 145098000 8/1/1991 5.375 6.013889 5.013889 5.986111 3.808241 137558400 8 9/1/1991 5.972222 6.152778 5.569445 6.055555 3.854612 102528600 10/1/1991 6111111 6.361111 5.722222 6.333333 4.031427123541500 10 11/1/1991 6.361111 6.833333 6.166667 6.694445 4.261291 140218500 11 12/1/1991 6.638889 7.791667 6,611111 7.486111 4.767655 141093000 12 1/1/1992 7.416667 7.986111 6.75 6.847222 4.36077 227041800 13 2/1/1992 6.861111 7.541667 6.611111 7.111111 4.528832 140568900 14 3/1/1992 7.125 7.430555 6.722222 7.194445 4.581903 124140600 15 4/1/1992 7.166667 7.625 6.708333 6.930555 4.415907 172449300 16 5/1/1992 6.930555 7.888889 6.736111 7.847222 4.999977 144565200 17 6/1/1992 7.847222 7.930555 7.027778 7.472222 4.764278 157690800 18 7/1/1992 7.458333 8.4375 7.444445 8,375 5:339887 105941700 19 8/1/1992 8.375 8.916667 8.3125 8.895833 5.671967 127167000 20 9/1/1992 8.895833 9.5 8.75 9.229167 5.887973 107329500 21 10/1/1992 9.229167 9.708333 8.166667 9.645833 6.153795 143959500 22 11/1/1992 9.645833 10.166667 9.479167 10.166667 6,486077 110418600 23 12/1/1992 10.166667 11.4375 10.104167 11.25 7.180783 121772100 24 1/1/1993 11.291667 11.3125 10.416667 10.854167 6.928125 126363500 25 2/1/1993 11 11.229167 9.25 10.604167 6.768551 178744200 26 3/1/1993 10.645833 10.833333 10.083333 10.541667 6.728658 137554800 27 4/1/1993 10.604167 10.604167 8.805555 9.388889 5.995648 262283704 28 5/1/1993 9.361111 10.444445 9.277778 10.277778 6.563284 115223800 29 6/1/1993 10 277778 10.416667 9.138889 9.722222 6.20851 113073000 30 7/1/1993 9.722222 10.027778 9.333333 9.805555 6.266089 64537200 31 8/1/1993 9.944445 10.5 8.861111 9.5 6.070829 189273600 32 9/1/1993 9.388889 9.416667 7.777778 8.555555 5.471241 224709600 33 10/1/1993 8.666667 8.916667 8.277778 8.805555 5.631116 95007300 34 11/1/1993 8805555 9833333 8.727222 9.222222 5.897569 117217300 35 12/1/1993 9.388889 9611111 8.666667 8.777778 5.617389 89783700 36 1/1/1994 8.777778 9 8.111111 8.666667 5.546283 147195900 37 2/1/1994 8.666667 9.444445 8.25 9.25 5.919591 119164500 38 3/1/1994 9.25 9.916667 8.666667 9.055555 5.795155 137021400 39 4/1/1994 8.833333 9.611111 8.777778 9.333333 5.977293 77751800 40 5/1/1994 9.388889 10.305555 8.805555 10.027778 6.422037 116262600 5/1/1994 10 10.305555 9.083333 9.361111 5.995082 98007300 42 7/1/1994 9.416667 9.833333 8.888889 9083333 5.822309 BOS93500 43 8/1/1994 90SSSSS 10.277778 8.833333 10.055555 6.445493 130650600 44 9/1/1994 9.8888.89 10 9.25 9.333333 5.982556 89095200 45 10/1/1994 938889 10.222222 9.083333 10.111111 6.486981 88497900 46 11/1/1994 10.083133 10.722222 9.888889 10.277778 6.593915123902700 17/1/1994 10 222222 10.5 9.805555 10.222222 6556274 90020700 LB 1/1/1995 10.194445 10.777778 9.916667 10.388889 6.67097 75995100 + HD LINE Save a copy Dismiss Read Only - You can't save changes to this file H 4 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 A B 1/1/1995 10.194445 10.777778 2/1/1995 10.388889 11.111111 3/1/1995 10 10.333333 4/1/1995 9.805555 9.833333 5/1/1995 9.277778 10 6/1/1995 9.305555 9.666667 7/1/1995 9 10.055555 8/1/1995 9.777778 9.972222 9/1/1995 8.916667 9.527778 10/1/1995 8.861111 8.916667 11/1/1995 8.277778 9.972222 12/1/1995 9.888889 10.666667 1/1/1996 10.555555 10.555555 2/1/1996 10.222222 10.666667 3/1/1996 9.777778 11.194445 4/1/1996 10.666667 10.694445 5/1/1996 10.472222 11.916667 6/1/1996 11.305555 12.694445 7/1/1996 12.027778 12.333333 8/1/1996 11.222222 12.416667 9/1/1996 11.555555 13.166667 10/1/1996 12.75 13.222222 11/1/1996 12.166667 12.722222 12/1/1996 11.722222 11.916667 1/1/1997 11.166667 11.861111 2/1/1997 11.055555 12.638889 3/1/1997 12.027778 13.027778 4/1/1997 11.722222 12.972222 5/1/1997 12.888889 14.138889 6/1/1997 14 15.555555 7/1/1997 15.333333 16.645834 8/1/1997 16.625 16.875 9/1/1997 15.8125 18.125 10/1/1997 17.520834 18.875 11/1/1997 19.166666 19.354166 12/1/1997 18.9375 20.166666 1/1/1998 19.666666 20.541666 2/1/1998 20.5 22.9375 3/1/1998 21.208334 23.479166 4/1/1998 22.479166 24.229166 5/1/1998 23.541666 26.3125 6/1/1998 26.5 28.854166 7/1/1998 27.75 32.666668 8/1/1998 27.708334 30.625 9/1/1998 25.666666 29.75 10/1/1998 25.333334 29.958334 11/1/1998 29.25 34.666668 12/1/1998 33.083332 41.333332 D E F G 9.916667 10.388889 6.67097 75995100 9.777778 9.972222 6.403414 136976100 9.416667 9.833333 6.319655 156233100 8.944445 9.277778 5.962615 149049000 8.861111 9.25 5.944762 239833500 8.583333 9.055555 5.819794 256794000 9 9.777778 6.291645 150219300 8.833333 8.888889 5.719676 121607400 8.555555 8.861111 5.701804 226977900 8.138889 8.277778 5.332856 184975500 8.277778 9.861111 6.352895 182068500 9.527778 10.611111 6.836078 135652200 9.222222 10.222222 6.626038 161350200 95 9.611111 6.229913 132092100 9.611111 10.611111 6,878115 175554300 9.444445 10.527778 6.831122 151975800 10.111111 11.361111 7.37184 164260500 11.222222 12 7.786396 122949300 10.666667 11.194445 7.271627 143290500 11.166667 11.805555 7.66859 105199800 11.527778 12.638889 8.209908 100999800 11.722222 12.194445 7.970256 115790400 11.277778 11.583333 7570839 177473100 10.722222 11.138889 7.280351 151104600 10.611111 11 7.19774 219352500 11 12. 138889 7.942964 240154500 11.833333 11.888889 7.779376 133444200 11.638889 12.888889 8.442658 119518200 12.666667 14.027778 9.188667 173334300 13.805555 15.333333 10.04385 134911200 14.604167 16.604166 10.888784 119939400 15.6875 15.729167 10.314973 106325700 15.791667 17:375 11.394289 127059900 16.729166 18.583334 12.198839 136966800 17.875 18.6875 12.257221 93867000 17.645834 19.625 12.882621 103974000 18.4375 20.166666 13.249524 87627000 20.416666 21.291666 13.98865 107246700 21.145834 22.541666 14.809909 136070400 21.854166 23.229166 15.27341 121498500 22.5625 26.1875 17.21854 120076200 25.354166 27.6875 18.204803 145564200 27.75 27.916666 18,369179 160953300 23 875 25.416666 16.724178 150086700 23.5 26.333334 17327356 154875500 21.083334 29.041666 19,124479 186681200 28.75 33 166668 21.840864 105595800 32.166668 40.791668 26.86208 106602500 81 82 84 85 86 87 88 89 90 91 92 93 94 95 + HD UNH o Read Only - You can't have changes to this file Save a copy Dismiss H A D 95 12/1/1998 33.083332 41.333332 32.166663 40.791668 26.8620B 106602500 96 1/1/1999 40.25 40.833332 34 581332 40.333332 26.576279 139142100 97 2/1/1999 40.25 41.125 35.875 39.791668 26.21937 101235500 98 3/1/1999 39,083332 44,208332 38 33332 41.5 27.345013111417300 99 4/1/1999 41.666668 45.291668 37.708332 39.833332 26.260029 117391700 100 5/1/1999 39.875 41.166668 36.833332 37.708332 24.859119 124822600 101 6/1/1999 38 43.125 36.75 42.958332 28.320168 104368200 102 7/1/1999 42.541668 46.625 41.625 42.541668 28.064161 87116400 103 B/1/1999 42.083332 44,25 35.75 27.047136 119803400 104 9/1/1999 40.833332 46 39.375 45.75 30.200178 101501700 105 10/1/1999 45.583332 52.333332 44.708332 50.5 33.335709 126242100 106 11/1/1999 50.416668 55.666668 49.916668 52.791668 34.84848 116575000 107 12/1/1999 53.125 69.75 52.916668 68.75 45.416862 139004800 108 1/1/2000 68.625 69.1875 54.875 56.625 37.406963 134837200 109 2/1/2000 56.9375 62 52.625 57.5 37.984985125200600 110 3/1/2000 57.8125 69.5625 51 64.5 42.609234 147000700 111 4/1/2000 65.5 70 55.3125 56.5 37.352119 108585200 112 5/1/2000 56.5 57.9375 44.125 49 32.393871 145181700 113 6/1/2000 49 54 45 49.9375 33.013645 131944300 114 7/1/2000 49.6875 58.75 48.625 51.75 34.241669 92784800 115 8/1/2000 51.9375 60 48 48,0625 31.801737 145390600 116 9/1/2000 49 56.1875 48,0625 52.9375 35.055447 105695500 117 10/1/2000 53.9375 56.8125 34.6875 43 28.474813 269631700 118 11/1/2000 43 44.3125 35.4375 39.1875 25.950134 159686700 119 12/1/2000 39.25 47.4375 38.75 45.6875 30.285721 175587400 120 1/1/2001 45.6875 52.5 40.9375 48.200001 31.951256 224446800 121 2/1/2001 47.52 48.900002 39.619999 42.5 28.172779 141499800 122 3/1/2001 42.400002 45.5 38.110001 43.099998 28.570509 179137300 123 4/1/2001 43.099998 48.5 40.049999 47.099998 31.252243 139696600 124 5/1/2001 47.009998 53.73 46.75 49.290001 32.705364 143446900 125 6/1/2001 49 51.450001 46.549999 47.240002 31.345131 118961200 126 7/1/2001 46.990002 50.900002 44.599998 50.369999 33.448341 106056100 127 8/1/2001 50.369999 50.700001 45.950001 30.513245 124733500 128 9/1/2001 45.82 48 30.299999 38,369999 25.500534 193174700 129 10/1/2001 38.119999 43.119999 37.099998 38.23 25.407494 173826200 130 11/1/2001 38.23 47.23 37.470001 46.650002 31.003386 172422800 131 12/1/2001 46.66 52.040001 46.25 51.009998 33.977474 134069300 132 1/1/2002 51.009998 51.650002 46.900002 50.09 33.364685 129964900 133 2/1/2002 50 52 599998 48.349998 50 33.304741 129384000 134 3/1/2002 50.279999 50.5 47.099998 48.610001 32.378868 154230200 135 4/1/2002 48.150002 50.459999 46 46,369999 30.9188 131218600 136 5/1/2002 46.439999 49.5 39.849998 41.689999 27.798248 235069000 137 6/1/2002 41.150002 42.049999 34.900002 36.73 24.490999 204571300 138 7/1/2002 36.75 38.5 27.25 30.879999 20.616102 357101400 139 8/1/2002 34.48 26.1 32.93 21.984726 357006500 140 9/1/2002 32.630001 34.900002 24.75 26.1 17.424892 219699300 10/1/2002 25.950001 31.32 23.18 28.879999 19.310186 319117100 142 11/1/2002 28.809999 29.25 23.799999 26.4 17.651972 356145400 45.27 30.75 + HD UNH File Home Insert Draw Formula Review View 29 24- Read Only - You can't save changes to this file Save a copy Dismiss x H 142 143 144 145 146 142 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 B C D F 11/1/2002 28.809999 29.25 23.799999 26.4 17.651972 356145400 12/1/2002 27.48 27.629999 23.01 24.02 16.060625 284287400 1/1/2003 24.209999 24.91 20.1 2009 14,006226 393066300 2/1/2003 21 23.59 20.18 23.450001 15.715118 231128700 3/1/2003 23.49 25.799999 21.51 24.360001 16.324961 229009100 4/1/2003 24.610001 28.76 239 28, 129999 18.903194 220136700 5/1/2003 28.1 3257 27.35 32.490002 21.833078 250999800 6/1/2003 32.75 34.720001 31.58 33.119999 22.25643 182886200 7/1/2003 33.119999 34.700001 30.559999 31.200001 21.004919 197934200 8/1/2003 31.25 34,23 30.1 32.16 21.65123 200772100 9/1/2003 31.93 34.25 31.110001 31.85 21.442532 215459500 10/1/2003 32.119999 37.84 32,060001 37.07 25.011259 173351900 11/1/2003 37.43 37.889999 34.830002 36.759998 24.802095 129531900 12/1/2003 36.880001 36.98 31.93 35.490002 23.945223 193037700 1/1/2004 35.75 36.400002 34.700001 35.470001 23.977381 183718600 2/1/2004 35.470001 37.080002 35.009998 36.310001 24.545216 144953600 3/1/2004 36.580002 37.650002 35.119999 37.360001 25.254999 158885900 4/1/2004 37.299999 37.84 35.189999 35.189999 23.832926 133451400 5/1/2004 35.25 36.299999 32.34 35.919998 24.327314 170501900 6/1/2004 35.77 36.130001 34.75 35.200001 23.839701 171113400 7/1/2004 35 209999 35.349998 32.57 33.720001 22.891642 129195800 8/1/2004 33.720001 36.869999 32.389999 36.560001 24.819645 144180100 9/1/2004 36.549999 39.73 36.360001 39.200001 26.673927 140363500 10/1/2004 39.59 415 38.310001 41.080002 27.953197 130066700 11/1/2004 4102 44.299999 40.799999 41.75 28.409088 156743400 12/1/2004 41.950001 43.09 41.490002 42.740002 29.14031 122581700 1/1/2005 42.990002 43.27 40.279999 41.259998 28.131237 125399300 2/1/2005 41.200001 47.990002 38.880001 40.02 27.28581 134241800 3/1/2005 40.049999 40.27 37.439999 38.240002 26.072195171584800 4/1/2005 38.400002 38.75 34.560001 35.369999 24176037 175448400 5/1/2005 35.669998 40.34 35.540001 39.349998 26.896441 165217800 6/1/2005 39,200001 40.93 38.150002 38.900002 26.588877 140214700 7/1/2005 39.18 43.98 38.610001 43.509998 29.814508 148971100 8/1/2005 43.209999 43 389999 39.139999 40.32 27.628603 188347600 9/1/2005 40.700001 42.040001 37. 139999 38.139999 26.199429 201857000 10/1/2005 38.150002 41.470001 37,48 41.040001 28.191517 212047300 11/1/2005 41 43.27 40.349998 41.779999 28.699844 188661700 12/1/2005 41.84 42.790001 40.419998 40.48 27.873762 123216400 1/1/2006 40.389999 43 200001 39.650002 40.549999 27.921951 190368300 2/1/2006 40.450001 43 38.5 42.150002 29.023705169723200 3/1/2006 42.150002 43.950001 40.279999 42.299999 29.126972 192419800 4/1/2006 42.380001 42.93 39.5 39.93 27.594067 142636300 5/1/2006 40.150002 41.610001 37.299999 38.119999 26.343233 264997600 6/1/2006 37.950001 38.799999 35.630001 35.790001 24.733067 297879600 7/1/2006 35.860001 35.98 32.849998 34.709999 24.08316 294513800 8/1/2006 34.5 35.220001 33.07 34.290001 23.79175 284655800 9/1/2006 34.299999 37.650002 33.75 36.27 25.165546 245905100 10/1/2006 36.18 38.240002 35.549999 37,330002 26.013662 268215200 HD UNH + File Homie Insert Draw Formulas Data Review View M Read Only - You can't save changes to this file Save a copy Dismiss f 4 A C D E G H 189 10 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 10/1/2006 36.18 38.240002 35.549999 37.330002 26.013662268215200 11/1/2006 37.5 38.849998 35,77 37.970001 26.459658355710000 12/1/2006 39.099998 40.369999 38.1 40.16 28.154299 323271600 1/1/2007 41.299999 41.84 39,060001 40.740002 28.5609316367900 2/1/2007 40.77 42.009998 39 290001 39.59 27.754688 258092400 3/1/2007 39.169998 39.650002 36.349998 36.740002 25.756691326396300 4/1/2007 36.66999 39.689999 36.599998 37.869999 26.704264 250809800 5/1/2007 38. 150002 39.619999 37.900002 38.869999 27.40M16 276299900 6/1/2007 39.099998 41.189999 37.349998 39.349998 27.747887 370787500 7/1/2007 39.549999 41.009998 36.720001 37.169998 26.359659417546100 8/1/2007 36.939999 38.540001 31 85 38.310001 27.168131 769305600 9/1/2007 37209999 37369999 32.369999 32.439999 23.153109515270200 10/1/2007 32.580002 34,549999 30 280001 31.51 22.48934 400517900 11/1/2007 31.4 31.58 26.780001 28.559999 20.383869 406371300 12/1/2007 28.620001 29.799999 25.57 26.940001 19.386312330175300 1/1/2008 27:129999 31.08 23.77 30.639999 22.04887 482772200 2/1/2008 30.299999 30.690001 26.41 26 549999 19.105667 356434400 3/1/2008 26.5 30 24870001 27.969999 20.127504 375945900 4/1/2008 28.200001 30.16 27.4 28,799999 20.913002 315442200 5/1/2008 29.09 30.5 26.280001 27.360001 19.867355 358885800 6/1/2008 27.41 28.129999 23.32 23.42 17.00634 367890700 7/1/2008 23.110001 25.85 20.76 23.83 17.448597 397904400 8/1/2008 24.030001 28.75 22.82 27.120001 19.857586 407771000 9/1/2008 27.65 30,74 24.440001 25.889999 18.956963 621080800 10/1/2008 25.52 26.09 17.049999 23.59 17.417381 628648800 11/1/2008 23.48 23.790001 17.459999 23.110001 17.062977 459693800 12/1/2008 22.549999 25.190001 20.65 23.02 16.996525439676-400 1/1/2009 23.07 25.49 21.299999 21.530001 16.066845 431144100 2/1/2009 21.209999 23.85 18.24 20.889999 15.589233 454586800 3/1/2009 20.35 24.360001 17.49 23.559999 17.581728 533962800 4/1/2009 23.15 27.07 22.92 26.32 19.886847398336600 5/1/2009 26.58 26.77 22.33 23.16 17.499222425707400 6/1/2009 23.59 25.120001 22.530001 23.629999 17.854338 350279000 7/1/2009 23.799999 26.190001 22.27 25.940001 19.780951 299152600 8/1/2009 26.18 27.940001 25.43 27 290001 20.810406343157900 9/1/2009 27.01 28.440001 26 32 26.639999 20.314737 255075500 10/1/2009 25.65 28.02 24.959999 25.09 19.291824 327855200 11/1/2009 25.139999 27.950001 24,469999 27.360001 21.037233324108800 17/1/2009 27.49 29.440001 27.35 28.93 22.244415272428900 1/1/2010 29.15 29.24 27 190001 28.01 21.715611 305927400 2/1/2010 28.01 31.450001 27.530001 31.200001 24188751 358199600 3/1/2010 31.24 32.98 31.09 32.349998 25.080324 331755400 4/1/2010 32.41 37.029999 32.16 35.23 27.516315 371036400 5/1/2010 35389999 16.299999 32.07 33.860001 26.446287 522063700 6/1/2010 33.419998 34,169998 27.99 28.07 21.924019 445088000 7/1/2010 28.41 29.370001 26.620001 28.51 22.423969375351500 8/1/2010 28.82 29.24 27.1 27.82 21 881266 279092800 9/1/2010 28.08 32.23 28.059999 31.68 25.129145 235029100 HD UNH 216 217 218 219 220 221 222 223 224 225 226 227 228 2.29 230 231 232 233 235 236 + Read Only - You can't save changes to this file. Save a copy Dismi D 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 A B 8/1/2014 80.559998 93.519997 9/1/2014 93.040001 93.75 10/1/2014 92.139999 99.260002 11/1/2014 96.809998 99.800003 12/1/2014 99.489998 106.02 1/1/2015 105.16 107.74 2/1/2015 104.78 117.92 3/1/2015 114.86 117.99 4/1/2015 113.88 116.25 5/1/2015 106.98 116.48 6/1/2015 111.97 113.71 7/1/2015 112.45 118.13 8/1/2015 117.62 123.8 9/1/2015 113.99 119.82 10/1/2015 116.23 125.75 11/1/2015 124.24 135.47 12/1/2015 133.52 134.83 1/1/2016 130.11 131.94 2/1/2016 124.92 127.75 3/1/2016 124.78 134.28999 4/1/2016 133.10001 137 5/1/2016 134.37 137.82001 6/1/2016 132.12 132.73 7/1/2016 128.28999 138.72 8/1/2016 138.06 139 9/1/2016 134.48 135.88001 10/1/2016 128.2 130.45 11/1/2016 121.69 132.14 12/1/2016 129.34 137.32001 1/1/2017 135.10001 139.37 2/1/2017 137.66 146.33 3/1/2017 146.72 150.14999 4/1/2017 146.94 156.27 5/1/2017 156.22 160.86 6/1/2017 153.52 159.22 7/1/2017 154.39 154.78999 8/1/2017 150.24001 156.05 9/1/2017 150.26 163.61 10/1/2017 164.2 167.94 11/1/2017 166.42 180.67 12/1/2017 180.32001 191,49001 1/1/2018 190.21001 207.61 2/1/2018 199.34 202.25 3/1/2018 182.75 184.39999 4/1/2018 177.14999 187.8 5/1/2018 184.73 191.64999 6/1/2018 187.21001 201.60001 7/1/2018 193.82001 204.25 79.660004 88.330002 86.349998 95.150002 96.989998 100.24 101.57 111.58 106.62 106.85 109.03 110.17 92.169998 111.8 114.71 118.61 130.01 113.59 109.62 123.98 131.75 130.02 123.62 128.12 133.60001 125.35 121.62 119.2 128.67999 133.05 136.33 145.83 145.76 153.28 150.75 144.25 146.89 149,76 161.51 160.53 176.7 187.82001 175.42 171.56 170.42 181.2 186.52 192.12 E F 935 31.230721 148205800 91.739998 79.701675 153432100 97.519997 85.151245 145336900 99.400002 86.792801 103033400 104.97 91.656342 118058000 104.42 91.611542 109808700 114.75 100.57445 110415700 113,61 99.674248 104110600 106,98 94.340485 95675500 111.42 98.255898 100397400 111.13 98.000153 104809700 117.03 103.75125 97800100 116.46 103.24592 135234000 115.49 102.38599 122128700 123,64 110.16938 97180400 133.88001 119.29372 111416100 132.25 117.84133 99749700 125.76 112.55444 147050100 124.12 111.08665 135914000 133.42999 119.41901 94146700 133.89 120.48964 82951100 132.12 118.89681 112394600 127.69 115.50521 114046600 138.24001 125.04851 78399700 134.12 121.32165 91331300 128.67999 116.99766 107739700 122.01 110.9332 97360300 129.39999 117.6523 133565300 134.08 122.55474 99553700 137.58 125.75385 83138300 144.91 132.45383 75930200 146.83 134.20876 92996000 156.10001 143.55026 75716700 153,51 141.1685 93676400 153.39999 141.88255 100510600 149.60001 138.36787 102500900 149.87 138.61758 114385100 163.56 152.17435 110280500 165.78 154.23978 71346000 179.82001 167.30244 103227500 189.53 177.22983 103713100 200.89999 187.86194 92074000 182.27 170.44101 127014100 178.24001 166.67253 109321100 184.8 173.79231 101369800 186.55 175.4381 103145700 195.10001 184.50607 93713000 197.52 186.79466 67987900 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 A2 366 - Read-only File Home Insert Draw Formulas Data Review View 298 Read Only - You can't save changes to this file Save a copy Disr fx H 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 50 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 B D E G 7/1/2018 193.82001 204.25 192.12 19752 186.79466 67987900 8/1/2018 196.86 203.55 191.09 200.77 189.86812 88542700 9/1/2018 200.69 215.42999 200.5 207.14999 196.90588 83962700 10/1/2018 208.52 209.78999 170.91 175.88001 167.1823 133142600 11/1/2018 176.84 188.69 167 180.32001 171.40271 132549500 12/1/2018 183.28999 183.5 158.09 171.82001 164.30003 117667300 1/1/2019 169.71001 184,67 168.21001 183.53 175.4975 98771800 2/1/2019 184.03 193.42 182.45 185.14 177.03705 90471400 3/1/2019 185.82001 192.19 179.52 191.89 183.49162 95115500 4/1/2019 192.99001 208.3 192.85001 203.7 196.23518 71203800 5/1/2019 203.2 203.52 186.27 189.85001 182.89273 94651500 6/1/2019 189.52 211.99001 188.75 207.97 200.34869 90786400 7/1/2019 209.7 219.3 208.17 213.69 207.30306 64169000 8/1/2019 214.14 229.27 199.05 227.91 221.09801 98962100 9/1/2019 226.45 235.49001 220.67 232.02 225.08519 75292900 10/1/2019 233.01 238.99001 222.12 233.89 228.28487 64772200 11/1/2019 236.07001 239.31 216.88001 220.51 215.22551 102466300 12/1/2019 220.89999 222 210.61 218.38001 213.14656 111759300 1/1/2020 219.08 236.53 216.39999 228.10001 224.05756 97265400 2/1/2020 230.3 247.36 212.33 217.84 213.97937 86014100 3/1/2020 219.98 241.32001 140.63001 186.71001 183.40108 221563200 4/1/2020 175.91 224.22 174 219.83 217.37882 120718900 5/1/2020 216.77 252.23 215.21001 248.48 245.70934 115258000 6/1/2020 249.41 259.29001 234.31 250.51 247.71672 103044200 7/1/2020 249.64999 269.07001 246.22 265.48999 264.09726 66948800 8/1/2020 266.73001 292.95001 263.84 285.04001 283.54474 74355500 9/1/2020 284.03 288.04001 262.81 277.70999276.25317 80496700 10/1/2020 279.44 292.64999 262.03 266.70999 266.70999 59503400 11/1/2020 270.14999 289 268.51999 284.23999 284.23999 14874400 1. Using the annual stock prices for United Health Group and Home Depot, calculate and interpret the following statistics for the two stocks: (20 Points) a. Expected Return b. Variance c. Standard Deviation d. Covariance e. Correlation Coefficient 2. Construct an optimal portfolio containing only the two risky assets assuming the investor's level of risk aversion is A=1 and A=4. (show the return, standard deviation, and utility of the portfolios) (16 Points) 3. Calculate the minimum variance portfolio. (4 Points) 4. Calculate the optimal risky market portfolio assuming that the risk-free rate is 2.5% per year. (8 points) 5. Calculate and graph the optimal portfolio containing the risky market portfolio and the risk-free asset for an investor assuming the investor's level of risk aversion is A=1 and A=4. (show the return, standard deviation, and utility of the portfolios). (16 Points) A2366 Read-only File Home Insert Draw Formulas Data Review View E 299 B Read Only. You can't have changes to this file Save a copy Dismiss fx 4 B C D E F G 1 Date Open High Low Close Adj Close Volume 2 3/1/1991 3.583333 4,046296 3.574074 4 2.541642 122175600 4 4/1/1991 4.462963 3.925926 4.259259 2.707935 159858000 4 5/1/1991 4.259259 4.944445 4,092593 4.87963 3.102351 150830400 5 6/1/1991 4.861111 5.166667 4.75 5.013889 3.18771 132258000 G 7/1/1991 5.055555 5.513889 4.916667 5.388889 3.426128 145098000 8/1/1991 5.375 6.013889 5.013889 5.986111 3.808241 137558400 8 9/1/1991 5.972222 6.152778 5.569445 6.055555 3.854612 102528600 10/1/1991 6111111 6.361111 5.722222 6.333333 4.031427123541500 10 11/1/1991 6.361111 6.833333 6.166667 6.694445 4.261291 140218500 11 12/1/1991 6.638889 7.791667 6,611111 7.486111 4.767655 141093000 12 1/1/1992 7.416667 7.986111 6.75 6.847222 4.36077 227041800 13 2/1/1992 6.861111 7.541667 6.611111 7.111111 4.528832 140568900 14 3/1/1992 7.125 7.430555 6.722222 7.194445 4.581903 124140600 15 4/1/1992 7.166667 7.625 6.708333 6.930555 4.415907 172449300 16 5/1/1992 6.930555 7.888889 6.736111 7.847222 4.999977 144565200 17 6/1/1992 7.847222 7.930555 7.027778 7.472222 4.764278 157690800 18 7/1/1992 7.458333 8.4375 7.444445 8,375 5:339887 105941700 19 8/1/1992 8.375 8.916667 8.3125 8.895833 5.671967 127167000 20 9/1/1992 8.895833 9.5 8.75 9.229167 5.887973 107329500 21 10/1/1992 9.229167 9.708333 8.166667 9.645833 6.153795 143959500 22 11/1/1992 9.645833 10.166667 9.479167 10.166667 6,486077 110418600 23 12/1/1992 10.166667 11.4375 10.104167 11.25 7.180783 121772100 24 1/1/1993 11.291667 11.3125 10.416667 10.854167 6.928125 126363500 25 2/1/1993 11 11.229167 9.25 10.604167 6.768551 178744200 26 3/1/1993 10.645833 10.833333 10.083333 10.541667 6.728658 137554800 27 4/1/1993 10.604167 10.604167 8.805555 9.388889 5.995648 262283704 28 5/1/1993 9.361111 10.444445 9.277778 10.277778 6.563284 115223800 29 6/1/1993 10 277778 10.416667 9.138889 9.722222 6.20851 113073000 30 7/1/1993 9.722222 10.027778 9.333333 9.805555 6.266089 64537200 31 8/1/1993 9.944445 10.5 8.861111 9.5 6.070829 189273600 32 9/1/1993 9.388889 9.416667 7.777778 8.555555 5.471241 224709600 33 10/1/1993 8.666667 8.916667 8.277778 8.805555 5.631116 95007300 34 11/1/1993 8805555 9833333 8.727222 9.222222 5.897569 117217300 35 12/1/1993 9.388889 9611111 8.666667 8.777778 5.617389 89783700 36 1/1/1994 8.777778 9 8.111111 8.666667 5.546283 147195900 37 2/1/1994 8.666667 9.444445 8.25 9.25 5.919591 119164500 38 3/1/1994 9.25 9.916667 8.666667 9.055555 5.795155 137021400 39 4/1/1994 8.833333 9.611111 8.777778 9.333333 5.977293 77751800 40 5/1/1994 9.388889 10.305555 8.805555 10.027778 6.422037 116262600 5/1/1994 10 10.305555 9.083333 9.361111 5.995082 98007300 42 7/1/1994 9.416667 9.833333 8.888889 9083333 5.822309 BOS93500 43 8/1/1994 90SSSSS 10.277778 8.833333 10.055555 6.445493 130650600 44 9/1/1994 9.8888.89 10 9.25 9.333333 5.982556 89095200 45 10/1/1994 938889 10.222222 9.083333 10.111111 6.486981 88497900 46 11/1/1994 10.083133 10.722222 9.888889 10.277778 6.593915123902700 17/1/1994 10 222222 10.5 9.805555 10.222222 6556274 90020700 LB 1/1/1995 10.194445 10.777778 9.916667 10.388889 6.67097 75995100 + HD LINE Save a copy Dismiss Read Only - You can't save changes to this file H 4 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 A B 1/1/1995 10.194445 10.777778 2/1/1995 10.388889 11.111111 3/1/1995 10 10.333333 4/1/1995 9.805555 9.833333 5/1/1995 9.277778 10 6/1/1995 9.305555 9.666667 7/1/1995 9 10.055555 8/1/1995 9.777778 9.972222 9/1/1995 8.916667 9.527778 10/1/1995 8.861111 8.916667 11/1/1995 8.277778 9.972222 12/1/1995 9.888889 10.666667 1/1/1996 10.555555 10.555555 2/1/1996 10.222222 10.666667 3/1/1996 9.777778 11.194445 4/1/1996 10.666667 10.694445 5/1/1996 10.472222 11.916667 6/1/1996 11.305555 12.694445 7/1/1996 12.027778 12.333333 8/1/1996 11.222222 12.416667 9/1/1996 11.555555 13.166667 10/1/1996 12.75 13.222222 11/1/1996 12.166667 12.722222 12/1/1996 11.722222 11.916667 1/1/1997 11.166667 11.861111 2/1/1997 11.055555 12.638889 3/1/1997 12.027778 13.027778 4/1/1997 11.722222 12.972222 5/1/1997 12.888889 14.138889 6/1/1997 14 15.555555 7/1/1997 15.333333 16.645834 8/1/1997 16.625 16.875 9/1/1997 15.8125 18.125 10/1/1997 17.520834 18.875 11/1/1997 19.166666 19.354166 12/1/1997 18.9375 20.166666 1/1/1998 19.666666 20.541666 2/1/1998 20.5 22.9375 3/1/1998 21.208334 23.479166 4/1/1998 22.479166 24.229166 5/1/1998 23.541666 26.3125 6/1/1998 26.5 28.854166 7/1/1998 27.75 32.666668 8/1/1998 27.708334 30.625 9/1/1998 25.666666 29.75 10/1/1998 25.333334 29.958334 11/1/1998 29.25 34.666668 12/1/1998 33.083332 41.333332 D E F G 9.916667 10.388889 6.67097 75995100 9.777778 9.972222 6.403414 136976100 9.416667 9.833333 6.319655 156233100 8.944445 9.277778 5.962615 149049000 8.861111 9.25 5.944762 239833500 8.583333 9.055555 5.819794 256794000 9 9.777778 6.291645 150219300 8.833333 8.888889 5.719676 121607400 8.555555 8.861111 5.701804 226977900 8.138889 8.277778 5.332856 184975500 8.277778 9.861111 6.352895 182068500 9.527778 10.611111 6.836078 135652200 9.222222 10.222222 6.626038 161350200 95 9.611111 6.229913 132092100 9.611111 10.611111 6,878115 175554300 9.444445 10.527778 6.831122 151975800 10.111111 11.361111 7.37184 164260500 11.222222 12 7.786396 122949300 10.666667 11.194445 7.271627 143290500 11.166667 11.805555 7.66859 105199800 11.527778 12.638889 8.209908 100999800 11.722222 12.194445 7.970256 115790400 11.277778 11.583333 7570839 177473100 10.722222 11.138889 7.280351 151104600 10.611111 11 7.19774 219352500 11 12. 138889 7.942964 240154500 11.833333 11.888889 7.779376 133444200 11.638889 12.888889 8.442658 119518200 12.666667 14.027778 9.188667 173334300 13.805555 15.333333 10.04385 134911200 14.604167 16.604166 10.888784 119939400 15.6875 15.729167 10.314973 106325700 15.791667 17:375 11.394289 127059900 16.729166 18.583334 12.198839 136966800 17.875 18.6875 12.257221 93867000 17.645834 19.625 12.882621 103974000 18.4375 20.166666 13.249524 87627000 20.416666 21.291666 13.98865 107246700 21.145834 22.541666 14.809909 136070400 21.854166 23.229166 15.27341 121498500 22.5625 26.1875 17.21854 120076200 25.354166 27.6875 18.204803 145564200 27.75 27.916666 18,369179 160953300 23 875 25.416666 16.724178 150086700 23.5 26.333334 17327356 154875500 21.083334 29.041666 19,124479 186681200 28.75 33 166668 21.840864 105595800 32.166668 40.791668 26.86208 106602500 81 82 84 85 86 87 88 89 90 91 92 93 94 95 + HD UNH o Read Only - You can't have changes to this file Save a copy Dismiss H A D 95 12/1/1998 33.083332 41.333332 32.166663 40.791668 26.8620B 106602500 96 1/1/1999 40.25 40.833332 34 581332 40.333332 26.576279 139142100 97 2/1/1999 40.25 41.125 35.875 39.791668 26.21937 101235500 98 3/1/1999 39,083332 44,208332 38 33332 41.5 27.345013111417300 99 4/1/1999 41.666668 45.291668 37.708332 39.833332 26.260029 117391700 100 5/1/1999 39.875 41.166668 36.833332 37.708332 24.859119 124822600 101 6/1/1999 38 43.125 36.75 42.958332 28.320168 104368200 102 7/1/1999 42.541668 46.625 41.625 42.541668 28.064161 87116400 103 B/1/1999 42.083332 44,25 35.75 27.047136 119803400 104 9/1/1999 40.833332 46 39.375 45.75 30.200178 101501700 105 10/1/1999 45.583332 52.333332 44.708332 50.5 33.335709 126242100 106 11/1/1999 50.416668 55.666668 49.916668 52.791668 34.84848 116575000 107 12/1/1999 53.125 69.75 52.916668 68.75 45.416862 139004800 108 1/1/2000 68.625 69.1875 54.875 56.625 37.406963 134837200 109 2/1/2000 56.9375 62 52.625 57.5 37.984985125200600 110 3/1/2000 57.8125 69.5625 51 64.5 42.609234 147000700 111 4/1/2000 65.5 70 55.3125 56.5 37.352119 108585200 112 5/1/2000 56.5 57.9375 44.125 49 32.393871 145181700 113 6/1/2000 49 54 45 49.9375 33.013645 131944300 114 7/1/2000 49.6875 58.75 48.625 51.75 34.241669 92784800 115 8/1/2000 51.9375 60 48 48,0625 31.801737 145390600 116 9/1/2000 49 56.1875 48,0625 52.9375 35.055447 105695500 117 10/1/2000 53.9375 56.8125 34.6875 43 28.474813 269631700 118 11/1/2000 43 44.3125 35.4375 39.1875 25.950134 159686700 119 12/1/2000 39.25 47.4375 38.75 45.6875 30.285721 175587400 120 1/1/2001 45.6875 52.5 40.9375 48.200001 31.951256 224446800 121 2/1/2001 47.52 48.900002 39.619999 42.5 28.172779 141499800 122 3/1/2001 42.400002 45.5 38.110001 43.099998 28.570509 179137300 123 4/1/2001 43.099998 48.5 40.049999 47.099998 31.252243 139696600 124 5/1/2001 47.009998 53.73 46.75 49.290001 32.705364 143446900 125 6/1/2001 49 51.450001 46.549999 47.240002 31.345131 118961200 126 7/1/2001 46.990002 50.900002 44.599998 50.369999 33.448341 106056100 127 8/1/2001 50.369999 50.700001 45.950001 30.513245 124733500 128 9/1/2001 45.82 48 30.299999 38,369999 25.500534 193174700 129 10/1/2001 38.119999 43.119999 37.099998 38.23 25.407494 173826200 130 11/1/2001 38.23 47.23 37.470001 46.650002 31.003386 172422800 131 12/1/2001 46.66 52.040001 46.25 51.009998 33.977474 134069300 132 1/1/2002 51.009998 51.650002 46.900002 50.09 33.364685 129964900 133 2/1/2002 50 52 599998 48.349998 50 33.304741 129384000 134 3/1/2002 50.279999 50.5 47.099998 48.610001 32.378868 154230200 135 4/1/2002 48.150002 50.459999 46 46,369999 30.9188 131218600 136 5/1/2002 46.439999 49.5 39.849998 41.689999 27.798248 235069000 137 6/1/2002 41.150002 42.049999 34.900002 36.73 24.490999 204571300 138 7/1/2002 36.75 38.5 27.25 30.879999 20.616102 357101400 139 8/1/2002 34.48 26.1 32.93 21.984726 357006500 140 9/1/2002 32.630001 34.900002 24.75 26.1 17.424892 219699300 10/1/2002 25.950001 31.32 23.18 28.879999 19.310186 319117100 142 11/1/2002 28.809999 29.25 23.799999 26.4 17.651972 356145400 45.27 30.75 + HD UNH File Home Insert Draw Formula Review View 29 24- Read Only - You can't save changes to this file Save a copy Dismiss x H 142 143 144 145 146 142 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 B C D F 11/1/2002 28.809999 29.25 23.799999 26.4 17.651972 356145400 12/1/2002 27.48 27.629999 23.01 24.02 16.060625 284287400 1/1/2003 24.209999 24.91 20.1 2009 14,006226 393066300 2/1/2003 21 23.59 20.18 23.450001 15.715118 231128700 3/1/2003 23.49 25.799999 21.51 24.360001 16.324961 229009100 4/1/2003 24.610001 28.76 239 28, 129999 18.903194 220136700 5/1/2003 28.1 3257 27.35 32.490002 21.833078 250999800 6/1/2003 32.75 34.720001 31.58 33.119999 22.25643 182886200 7/1/2003 33.119999 34.700001 30.559999 31.200001 21.004919 197934200 8/1/2003 31.25 34,23 30.1 32.16 21.65123 200772100 9/1/2003 31.93 34.25 31.110001 31.85 21.442532 215459500 10/1/2003 32.119999 37.84 32,060001 37.07 25.011259 173351900 11/1/2003 37.43 37.889999 34.830002 36.759998 24.802095 129531900 12/1/2003 36.880001 36.98 31.93 35.490002 23.945223 193037700 1/1/2004 35.75 36.400002 34.700001 35.470001 23.977381 183718600 2/1/2004 35.470001 37.080002 35.009998 36.310001 24.545216 144953600 3/1/2004 36.580002 37.650002 35.119999 37.360001 25.254999 158885900 4/1/2004 37.299999 37.84 35.189999 35.189999 23.832926 133451400 5/1/2004 35.25 36.299999 32.34 35.919998 24.327314 170501900 6/1/2004 35.77 36.130001 34.75 35.200001 23.839701 171113400 7/1/2004 35 209999 35.349998 32.57 33.720001 22.891642 129195800 8/1/2004 33.720001 36.869999 32.389999 36.560001 24.819645 144180100 9/1/2004 36.549999 39.73 36.360001 39.200001 26.673927 140363500 10/1/2004 39.59 415 38.310001 41.080002 27.953197 130066700 11/1/2004 4102 44.299999 40.799999 41.75 28.409088 156743400 12/1/2004 41.950001 43.09 41.490002 42.740002 29.14031 122581700 1/1/2005 42.990002 43.27 40.279999 41.259998 28.131237 125399300 2/1/2005 41.200001 47.990002 38.880001 40.02 27.28581 134241800 3/1/2005 40.049999 40.27 37.439999 38.240002 26.072195171584800 4/1/2005 38.400002 38.75 34.560001 35.369999 24176037 175448400 5/1/2005 35.669998 40.34 35.540001 39.349998 26.896441 165217800 6/1/2005 39,200001 40.93 38.150002 38.900002 26.588877 140214700 7/1/2005 39.18 43.98 38.610001 43.509998 29.814508 148971100 8/1/2005 43.209999 43 389999 39.139999 40.32 27.628603 188347600 9/1/2005 40.700001 42.040001 37. 139999 38.139999 26.199429 201857000 10/1/2005 38.150002 41.470001 37,48 41.040001 28.191517 212047300 11/1/2005 41 43.27 40.349998 41.779999 28.699844 188661700 12/1/2005 41.84 42.790001 40.419998 40.48 27.873762 123216400 1/1/2006 40.389999 43 200001 39.650002 40.549999 27.921951 190368300 2/1/2006 40.450001 43 38.5 42.150002 29.023705169723200 3/1/2006 42.150002 43.950001 40.279999 42.299999 29.126972 192419800 4/1/2006 42.380001 42.93 39.5 39.93 27.594067 142636300 5/1/2006 40.150002 41.610001 37.299999 38.119999 26.343233 264997600 6/1/2006 37.950001 38.799999 35.630001 35.790001 24.733067 297879600 7/1/2006 35.860001 35.98 32.849998 34.709999 24.08316 294513800 8/1/2006 34.5 35.220001 33.07 34.290001 23.79175 284655800 9/1/2006 34.299999 37.650002 33.75 36.27 25.165546 245905100 10/1/2006 36.18 38.240002 35.549999 37,330002 26.013662 268215200 HD UNH + File Homie Insert Draw Formulas Data Review View M Read Only - You can't save changes to this file Save a copy Dismiss f 4 A C D E G H 189 10 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 10/1/2006 36.18 38.240002 35.549999 37.330002 26.013662268215200 11/1/2006 37.5 38.849998 35,77 37.970001 26.459658355710000 12/1/2006 39.099998 40.369999 38.1 40.16 28.154299 323271600 1/1/2007 41.299999 41.84 39,060001 40.740002 28.5609316367900 2/1/2007 40.77 42.009998 39 290001 39.59 27.754688 258092400 3/1/2007 39.169998 39.650002 36.349998 36.740002 25.756691326396300 4/1/2007 36.66999 39.689999 36.599998 37.869999 26.704264 250809800 5/1/2007 38. 150002 39.619999 37.900002 38.869999 27.40M16 276299900 6/1/2007 39.099998 41.189999 37.349998 39.349998 27.747887 370787500 7/1/2007 39.549999 41.009998 36.720001 37.169998 26.359659417546100 8/1/2007 36.939999 38.540001 31 85 38.310001 27.168131 769305600 9/1/2007 37209999 37369999 32.369999 32.439999 23.153109515270200 10/1/2007 32.580002 34,549999 30 280001 31.51 22.48934 400517900 11/1/2007 31.4 31.58 26.780001 28.559999 20.383869 406371300 12/1/2007 28.620001 29.799999 25.57 26.940001 19.386312330175300 1/1/2008 27:129999 31.08 23.77 30.639999 22.04887 482772200 2/1/2008 30.299999 30.690001 26.41 26 549999 19.105667 356434400 3/1/2008 26.5 30 24870001 27.969999 20.127504 375945900 4/1/2008 28.200001 30.16 27.4 28,799999 20.913002 315442200 5/1/2008 29.09 30.5 26.280001 27.360001 19.867355 358885800 6/1/2008 27.41 28.129999 23.32 23.42 17.00634 367890700 7/1/2008 23.110001 25.85 20.76 23.83 17.448597 397904400 8/1/2008 24.030001 28.75 22.82 27.120001 19.857586 407771000 9/1/2008 27.65 30,74 24.440001 25.889999 18.956963 621080800 10/1/2008 25.52 26.09 17.049999 23.59 17.417381 628648800 11/1/2008 23.48 23.790001 17.459999 23.110001 17.062977 459693800 12/1/2008 22.549999 25.190001 20.65 23.02 16.996525439676-400 1/1/2009 23.07 25.49 21.299999 21.530001 16.066845 431144100 2/1/2009 21.209999 23.85 18.24 20.889999 15.589233 454586800 3/1/2009 20.35 24.360001 17.49 23.559999 17.581728 533962800 4/1/2009 23.15 27.07 22.92 26.32 19.886847398336600 5/1/2009 26.58 26.77 22.33 23.16 17.499222425707400 6/1/2009 23.59 25.120001 22.530001 23.629999 17.854338 350279000 7/1/2009 23.799999 26.190001 22.27 25.940001 19.780951 299152600 8/1/2009 26.18 27.940001 25.43 27 290001 20.810406343157900 9/1/2009 27.01 28.440001 26 32 26.639999 20.314737 255075500 10/1/2009 25.65 28.02 24.959999 25.09 19.291824 327855200 11/1/2009 25.139999 27.950001 24,469999 27.360001 21.037233324108800 17/1/2009 27.49 29.440001 27.35 28.93 22.244415272428900 1/1/2010 29.15 29.24 27 190001 28.01 21.715611 305927400 2/1/2010 28.01 31.450001 27.530001 31.200001 24188751 358199600 3/1/2010 31.24 32.98 31.09 32.349998 25.080324 331755400 4/1/2010 32.41 37.029999 32.16 35.23 27.516315 371036400 5/1/2010 35389999 16.299999 32.07 33.860001 26.446287 522063700 6/1/2010 33.419998 34,169998 27.99 28.07 21.924019 445088000 7/1/2010 28.41 29.370001 26.620001 28.51 22.423969375351500 8/1/2010 28.82 29.24 27.1 27.82 21 881266 279092800 9/1/2010 28.08 32.23 28.059999 31.68 25.129145 235029100 HD UNH 216 217 218 219 220 221 222 223 224 225 226 227 228 2.29 230 231 232 233 235 236 + Read Only - You can't save changes to this file. Save a copy Dismi D 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 A B 8/1/2014 80.559998 93.519997 9/1/2014 93.040001 93.75 10/1/2014 92.139999 99.260002 11/1/2014 96.809998 99.800003 12/1/2014 99.489998 106.02 1/1/2015 105.16 107.74 2/1/2015 104.78 117.92 3/1/2015 114.86 117.99 4/1/2015 113.88 116.25 5/1/2015 106.98 116.48 6/1/2015 111.97 113.71 7/1/2015 112.45 118.13 8/1/2015 117.62 123.8 9/1/2015 113.99 119.82 10/1/2015 116.23 125.75 11/1/2015 124.24 135.47 12/1/2015 133.52 134.83 1/1/2016 130.11 131.94 2/1/2016 124.92 127.75 3/1/2016 124.78 134.28999 4/1/2016 133.10001 137 5/1/2016 134.37 137.82001 6/1/2016 132.12 132.73 7/1/2016 128.28999 138.72 8/1/2016 138.06 139 9/1/2016 134.48 135.88001 10/1/2016 128.2 130.45 11/1/2016 121.69 132.14 12/1/2016 129.34 137.32001 1/1/2017 135.10001 139.37 2/1/2017 137.66 146.33 3/1/2017 146.72 150.14999 4/1/2017 146.94 156.27 5/1/2017 156.22 160.86 6/1/2017 153.52 159.22 7/1/2017 154.39 154.78999 8/1/2017 150.24001 156.05 9/1/2017 150.26 163.61 10/1/2017 164.2 167.94 11/1/2017 166.42 180.67 12/1/2017 180.32001 191,49001 1/1/2018 190.21001 207.61 2/1/2018 199.34 202.25 3/1/2018 182.75 184.39999 4/1/2018 177.14999 187.8 5/1/2018 184.73 191.64999 6/1/2018 187.21001 201.60001 7/1/2018 193.82001 204.25 79.660004 88.330002 86.349998 95.150002 96.989998 100.24 101.57 111.58 106.62 106.85 109.03 110.17 92.169998 111.8 114.71 118.61 130.01 113.59 109.62 123.98 131.75 130.02 123.62 128.12 133.60001 125.35 121.62 119.2 128.67999 133.05 136.33 145.83 145.76 153.28 150.75 144.25 146.89 149,76 161.51 160.53 176.7 187.82001 175.42 171.56 170.42 181.2 186.52 192.12 E F 935 31.230721 148205800 91.739998 79.701675 153432100 97.519997 85.151245 145336900 99.400002 86.792801 103033400 104.97 91.656342 118058000 104.42 91.611542 109808700 114.75 100.57445 110415700 113,61 99.674248 104110600 106,98 94.340485 95675500 111.42 98.255898 100397400 111.13 98.000153 104809700 117.03 103.75125 97800100 116.46 103.24592 135234000 115.49 102.38599 122128700 123,64 110.16938 97180400 133.88001 119.29372 111416100 132.25 117.84133 99749700 125.76 112.55444 147050100 124.12 111.08665 135914000 133.42999 119.41901 94146700 133.89 120.48964 82951100 132.12 118.89681 112394600 127.69 115.50521 114046600 138.24001 125.04851 78399700 134.12 121.32165 91331300 128.67999 116.99766 107739700 122.01 110.9332 97360300 129.39999 117.6523 133565300 134.08 122.55474 99553700 137.58 125.75385 83138300 144.91 132.45383 75930200 146.83 134.20876 92996000 156.10001 143.55026 75716700 153,51 141.1685 93676400 153.39999 141.88255 100510600 149.60001 138.36787 102500900 149.87 138.61758 114385100 163.56 152.17435 110280500 165.78 154.23978 71346000 179.82001 167.30244 103227500 189.53 177.22983 103713100 200.89999 187.86194 92074000 182.27 170.44101 127014100 178.24001 166.67253 109321100 184.8 173.79231 101369800 186.55 175.4381 103145700 195.10001 184.50607 93713000 197.52 186.79466 67987900 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 A2 366 - Read-only File Home Insert Draw Formulas Data Review View 298 Read Only - You can't save changes to this file Save a copy Disr fx H 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 50 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 B D E G 7/1/2018 193.82001 204.25 192.12 19752 186.79466 67987900 8/1/2018 196.86 203.55 191.09 200.77 189.86812 88542700 9/1/2018 200.69 215.42999 200.5 207.14999 196.90588 83962700 10/1/2018 208.52 209.78999 170.91 175.88001 167.1823 133142600 11/1/2018 176.84 188.69 167 180.32001 171.40271 132549500 12/1/2018 183.28999 183.5 158.09 171.82001 164.30003 117667300 1/1/2019 169.71001 184,67 168.21001 183.53 175.4975 98771800 2/1/2019 184.03 193.42 182.45 185.14 177.03705 90471400 3/1/2019 185.82001 192.19 179.52 191.89 183.49162 95115500 4/1/2019 192.99001 208.3 192.85001 203.7 196.23518 71203800 5/1/2019 203.2 203.52 186.27 189.85001 182.89273 94651500 6/1/2019 189.52 211.99001 188.75 207.97 200.34869 90786400 7/1/2019 209.7 219.3 208.17 213.69 207.30306 64169000 8/1/2019 214.14 229.27 199.05 227.91 221.09801 98962100 9/1/2019 226.45 235.49001 220.67 232.02 225.08519 75292900 10/1/2019 233.01 238.99001 222.12 233.89 228.28487 64772200 11/1/2019 236.07001 239.31 216.88001 220.51 215.22551 102466300 12/1/2019 220.89999 222 210.61 218.38001 213.14656 111759300 1/1/2020 219.08 236.53 216.39999 228.10001 224.05756 97265400 2/1/2020 230.3 247.36 212.33 217.84 213.97937 86014100 3/1/2020 219.98 241.32001 140.63001 186.71001 183.40108 221563200 4/1/2020 175.91 224.22 174 219.83 217.37882 120718900 5/1/2020 216.77 252.23 215.21001 248.48 245.70934 115258000 6/1/2020 249.41 259.29001 234.31 250.51 247.71672 103044200 7/1/2020 249.64999 269.07001 246.22 265.48999 264.09726 66948800 8/1/2020 266.73001 292.95001 263.84 285.04001 283.54474 74355500 9/1/2020 284.03 288.04001 262.81 277.70999276.25317 80496700 10/1/2020 279.44 292.64999 262.03 266.70999 266.70999 59503400 11/1/2020 270.14999 289 268.51999 284.23999 284.23999 14874400 1. Using the annual stock prices for United Health Group and Home Depot, calculate and interpret the following statistics for the two stocks: (20 Points) a. Expected Return b. Variance c. Standard Deviation d. Covariance e. Correlation Coefficient 2. Construct an optimal portfolio containing only the two risky assets assuming the investor's level of risk aversion is A=1 and A=4. (show the return, standard deviation, and utility of the portfolios) (16 Points) 3. Calculate the minimum variance portfolio. (4 Points) 4. Calculate the optimal risky market portfolio assuming that the risk-free rate is 2.5% per year. (8 points) 5. Calculate and graph the optimal portfolio containing the risky market portfolio and the risk-free asset for an investor assuming the investor's level of risk aversion is A=1 and A=4. (show the return, standard deviation, and utility of the portfolios). (16 Points)