principles of investment

profileellyitis
Book1.xlsx
Home>Business & Finance homework help>Economics homework help>principles of investment

Question 3

PEPSICO NIKE IBM BAYER TOYOTA TOTAL BOEING BURBERRY SOUTHWEST GENERAL MILLS
Average Return (Mean) -0.2240242322 0.0144565855 -0.00089986 0.0100912656 0.086122832 0.0061819676 -0.2103472429 -0.2276376387 0.0315050577 0.0064627358
Standard Deviation (Total Risk) 2.1725887851 1.0490037991 0.9592041132 1.300880098 2.9612313861 2.6661197625 2.4798559579 3.1885462849 2.7013097009 1.1282688347
Variance 4.7201420289 1.1004089705 0.9200725308 1.6922890294 8.7688913221 7.1081945881 6.1496855718 10.1668274111 7.2970741002 1.2729905632
Date Average Return (Mean) Variance - Covariance (Covariance) Matrix
12/1/12 -0.025679334 0.05702156 0.0121232477 0.0570602072 4.6851770205 0.0362181937 0.0205631684 -0.0170196903 0.071856816 -0.0140031351 PEPSICO NIKE IBM BAYER TOYOTA TOTAL BOEING BURBERRY SOUTHWEST GENERAL MILLS
1/1/13 0.0703077551 0.050696758 0.0584020912 0.0301902712 0.0224801633 0.0581381964 -0.0199699738 0.0621019791 0.0915645596 -2.2656699058 PEPSICO 4.6401396217 -0.1394994654 0.5201621631 -0.2289929934 0.0339490756 -0.1016580616 0.040453563 -3.2867857116 3.21256035 0.6348242711
2/1/13 0.0392997774 0.0075572178 -0.0110921205 0.0072567077 0.0730737676 -2.3845022178 0.0401989444 -0.0262146675 0.0427826225 2.408370598 NIKE -0.1394994654 1.081757971 -0.0906038362 -0.0635793806 -0.6331895945 0.5432271686 0.078340536 -0.0248833745 0.0754568246 0.0825385232
3/1/13 -2.2523216317 0.084112374 0.0644411496 0.0390931308 0.000389697 2.2609462792 0.1164988791 -0.0355616243 0.1416181036 -4.5411045278 IBM 0.5201621631 -0.0906038362 0.9044780811 -0.1866243545 -0.0141186963 -0.1153146933 0.0704523409 -0.0945985554 0.0054703923 0.1640741633
4/1/13 2.3441803856 0.0749064066 -0.051762221 0.0099933172 0.1372460282 0.0618707992 0.0627532262 0.0254603793 0.0170196258 4.6274311647 BAYER -0.2289929934 -0.0635793806 -0.1866243545 1.6636061645 -0.2945114606 -0.0237055828 -0.7099324823 -0.0198709494 0.0761359957 -0.1966226149
5/1/13 -0.0208288405 -0.0309779171 0.0266968645 0.0517870186 0.0106907838 -0.0077930827 0.079966967 0.0582187347 0.0337314864 -0.0617459218 TOYOTA 0.0339490756 -0.6331895945 -0.0141186963 -0.2945114606 8.6202660455 -0.556830237 1.0990053319 -0.0145408801 0.0097239033 0.0085751801
6/1/13 0.0125492726 -2.2670074073 -0.0801086835 -0.0079370305 0.0261128713 -0.0233395087 -2.2635001318 -0.0623363652 -0.0946752412 0.0303336972 TOTAL -0.1016580616 0.5432271686 -0.1153146933 -0.0237055828 -0.556830237 6.9877167138 -0.5747027151 -0.0114354878 -0.0389847567 -0.2900953765
7/1/13 0.0281533161 -0.0120066119 0.0203552276 0.0831604208 0.0102243087 -13.7148605442 2.3282200433 0.1210139233 0.0732151344 0.0690616904 BOEING 0.040453563 0.078340536 0.0704523409 -0.7099324823 1.0990053319 -0.5747027151 6.045453613 3.083185831 -2.8802392371 -0.0799712936
8/1/13 -0.0466795477 2.3009946576 -0.0677153195 -0.0427396766 -0.00914754 13.857229453 -0.0112907738 0.0528140674 -0.0766141258 -0.0451336767 BURBERRY -3.2867857116 -0.0248833745 -0.0945985554 -0.0198709494 -0.0145408801 -0.0114354878 3.083185831 9.9945083024 -6.4373884691 -0.010471195
9/1/13 -0.0028888935 0.148561332 0.0208255961 0.0600153939 -2.244373899 0.0461088589 0.127358181 0.1091630704 0.1308948471 -0.0287964307 SOUTHWEST 3.21256035 0.0754568246 0.0054703923 0.0761359957 0.0097239033 -0.0389847567 -2.8802392371 -6.4373884691 7.1733948782 -0.0160557257
10/1/13 0.0632379499 -2.2605300428 -0.0327698837 0.0557348028 2.3224469009 0.068751729 0.1049350258 -0.0727878045 0.1677936458 0.0508547448 GENERAL MILLS 0.6348242711 0.0825385232 0.1640741633 -0.1966226149 0.0085751801 -0.2900953765 -0.0799712936 -0.010471195 -0.0160557257 1.251414452
11/1/13 0.0043901856 2.3462330962 0.0026191163 0.0681906648 -0.0343492286 -0.0141566533 0.0283303905 0.0115024214 -2.2260328307 0.0081481978
12/1/13 -0.0181603496 -0.0063381048 0.048330501 0.0617255213 -0.0253485928 0.0156268107 0.0201857035 0.0141450224 2.3159435113 -0.0103648869
1/1/14 -0.0247999068 -0.0733495518 -0.0598121434 -0.0730249759 -0.0605219625 -0.0553684037 -0.0858601296 -0.04696989 0.1083206965 -0.0386037618
2/1/14 -0.0036153068 0.0721449796 0.0469342215 0.0675169899 -6.9030609389 0.1268183578 -4.5763697459 0.0804139039 -2.2338783323 0.0486571849
3/1/14 0.0419452245 -0.0553108684 0.0442372641 -2.3457052536 6.8867203561 0.0107279152 4.5838284728 -0.1041992827 2.3534102343 0.0351535295
4/1/14 0.0352711488 -0.0123970914 0.0204653567 2.331441649 -0.0222910646 0.0948168883 -6.8800137895 0.0747217447 0.0252370707 0.022892879
5/1/14 0.0280124337 0.0528614299 -0.0636193164 -2.2438037443 0.0423483007 -0.025447365 6.9549126557 0.0234564618 0.0901440508 0.0433294633
6/1/14 0.0113693886 0.0114387709 -0.0110973286 2.2801863592 0.0562935626 0.0507041947 -0.0555329302 -0.0119551674 0.015381942 -0.0444849051
7/1/14 -0.0065242442 -2.3080160035 0.0557874752 -0.0702984372 -0.0140545896 -0.1127746866 -0.0545127231 -0.065380284 0.0537878689 -0.0465561599
8/1/14 0.0486278366 2.3208284474 0.0032816212 -2.2828835433 -0.031598309 0.0223830865 0.0511273705 0.0177754216 0.1238934036 0.0701222812
9/1/14 0.0064662765 0.1301606882 -0.007031343 2.3449368005 0.027692043 -0.0231585772 0.0106013447 0.043421635 0.0554732965 -0.0564535384
10/1/14 0.0396584789 0.041395704 -0.1438263763 0.0136104192 0.0426690719 -0.0607681687 -0.0195810966 -0.0024545871 0.0208065545 0.0294915355
11/1/14 -2.2625328246 0.0657680514 -2.3162423689 0.0550635995 0.0145618075 -0.0737869806 0.0729291721 0.0547891503 0.1929951478 -2.2792913946
12/1/14 2.2456498672 -0.0321352884 2.2986805948 -4.6974597277 0.0189056922 -0.0829831365 -0.0273241981 -0.0227461448 0.0118851227 2.3135204409
1/1/15 -0.0017369925 -0.0385358514 -0.0454578561 4.6525534033 0.0265025767 0.0203119144 0.1119014909 0.0378845673 0.0668199442 -0.016066885
2/1/15 0.0539662463 0.0514448817 0.054763977 -2.2733944389 0.0493627959 0.0403327612 0.037003846 0.1084463046 -0.043888597 0.0324037657
3/1/15 -0.0345356455 0.0383180645 -0.0019413854 2.319565997 0.0328446803 -0.0769089915 0.0010483553 -0.1187367526 0.0242186378 0.0509213023
4/1/15 0.0014358884 -0.0149622975 0.0650639045 -0.0335665442 0.0079202006 0.1000836578 -2.3485340279 0.0349029096 -0.0868444316 -0.0225130103
5/1/15 0.0136781201 0.0282299943 -0.0096206493 -0.0172854064 -0.0081615699 -0.0690588766 2.2827154765 -0.0240332094 -0.0905142621 0.0224075423
6/1/15 -0.0325686481 0.0660440981 -0.0345360118 0.0749282387 -0.030483856 -0.0264916648 -0.0065044264 -0.0629439671 -0.1130370994 -0.0076874989
7/1/15 0.0390847016 0.0645270631 -0.0041273785 -0.86939041 -0.0021704786 0.0156070841 0.038535709 0.0483545805 0.0918545387 0.043717914
8/1/15 -2.3315421639 0.6703232367 -0.0910659471 0.8304108338 -0.1199021227 -0.0604217221 -0.0982415624 -2.4628585331 0.0137175629 -0.0175956223
9/1/15 2.3100360179 -0.6052261187 -0.0116747781 -0.0573667954 0.003709963 -0.0371022662 0.0084237001 2.2664250794 0.0377171723 -0.0111613457
10/1/15 0.0880796983 -2.2365666801 -0.0343131296 0.0413093529 0.045312917 0.0913724924 0.1228697113 -0.0068060484 0.1962877948 0.0346672599
11/1/15 -0.0200648311 2.3120797059 -2.3073080854 -0.0051842509 0.0145727445 0.0249808126 -0.0178527219 -0.0919012519 -0.0088967193 0.0018896007
12/1/15 -0.0023992308 -0.0566071033 2.2989269152 -0.0614348051 -0.0111534164 -0.0954112583 0.0002335931 -0.0663227385 -0.0634347093 -0.0017327708
1/1/16 0.0007563717 -0.0054498395 -0.0978637413 -0.1051468977 -0.0247677541 0.0003807052 -0.1853276658 -0.0109567897 -0.1335447855 -0.0201461221
2/1/16 -0.0150165924 -2.3093811531 0.0487938925 -0.0808661681 -0.1423897679 0.0087614024 -0.0163654926 0.0670484303 0.1089425393 -2.25422467
3/1/16 -2.25604638 2.3006348456 0.154991895 0.1237149271 0.0211014152 0.0157550822 0.0807167545 0.0664101107 0.0657297624 0.0736832322
4/1/16 2.3143778126 -0.0394544678 -0.0370599693 -0.0366391915 -0.0257131675 0.1256171174 -2.2425074274 -0.1207197192 -0.0024607715 2.2703423078
5/1/16 -4.6227085137 -0.0651947407 -2.2505176316 -0.1469220456 0.01667448 -0.0449355222 -0.0663205001 -0.1119026871 -0.048924542 0.0304020811
6/1/16 4.6512408407 -0.0003622563 2.2993585687 0.0535705744 -0.0336315675 -0.0086939808 2.3397710396 -2.2948926808 -0.080101539 0.1275402191
7/1/16 0.035211464 0.0083371518 0.0566090998 0.0676076029 0.1098508806 0.0141767009 0.0287654551 2.4119603722 -0.0553423329 0.007960278
8/1/16 -0.0201239495 0.0378336703 -2.3134771721 -0.0070823289 0.0778069279 -0.0073031177 -0.032004676 0.0114787358 -0.003518612 -0.0083583953
9/1/16 0.0257941426 -0.0905504777 2.310995815 -0.0620166963 -0.0386206929 -0.0010476701 0.0257885977 0.0537004456 0.0557828084 -0.1031351776
10/1/16 -0.0145393079 -0.0452700122 -0.0330226529 -2.3154031661 0.0116372062 0.0154975331 0.0780203959 0.0043932221 -2.2731935246 -0.030194625
11/1/16 -0.0685265202 -0.0021944533 0.0540156883 2.2455570769 0.0245111973 -0.0016771228 0.0555108687 -0.0188059836 2.4542715769 -0.0092799078
12/1/16 0.0516311282 0.0324225172 0.0320052592 0.1067679339 -0.0112842331 -2.2354403703 0.0410908809 0.0388771551 0.0670027305 0.0135281537
1/1/17 -0.0081569934 0.0261602481 0.0501118814 0.0653293734 -13.8279597165 2.3077983497 0.0485210007 0.1198458099 0.0504965059 0.0114286909
2/1/17 0.0616556806 -2.2251341153 0.0299170077 -0.0100212843 13.7927922548 -0.0117379091 0.0979102837 0.0413592879 -2.2027839291 -0.0266135609
3/1/17 0.0133191897 2.2772493117 -0.0242209387 0.04532319 -0.0408588095 0.0089650542 -0.0103102692 0.0096221128 2.2301260319 -0.0227853979
4/1/17 0.0194598028 -0.0026475178 -0.0828749501 0.0760324668 -0.0044289055 0.0279618955 0.0440780765 -0.0347982583 0.0464817281 -0.0257480915
5/1/17 0.0311995725 -0.0446568263 -2.3515530267 0.0647243051 -0.005563794 0.0218430395 0.0150354566 0.1060684878 0.0665708365 -0.0052048208
6/1/17 -0.0050334437 0.1074341778 2.3201379013 0.0014016132 -0.023712101 -2.3425662076 0.0601579286 -0.0708143107 0.0335464425 -0.0238998532
7/1/17 0.0096511233 0.0042497555 -0.0613928695 -0.0258964007 0.071820071 2.3241298546 0.2038331438 0.0484862193 -0.110753699 0.0046821128
8/1/17 -0.0075751531 -0.1116839333 -0.0114008488 0.0128760509 0.0012399878 0.0266786797 -0.0116155092 -13.7791585677 -0.0626307206 -0.0350960106
9/1/17 -13.8464003738 -0.0149151956 0.0247410686 0.0655910893 0.0533401899 0.0280427253 0.0648861055 13.8349123049 -13.7421110577 -0.0285679161
10/1/17 -0.0061211821 0.0298302741 0.0718011843 0.0026265883 0.0387623026 0.0338344695 -13.7701749738 -13.7465177282 13.8646579118 0.0005794732
Date Excess Return
12/1/12 0.1983448983 0.0425649746 0.0130231077 0.0469689416 4.5990541885 0.0300362261 0.2309104113 0.2106179484 0.0403517583 -0.0204658709
1/1/13 0.2943319874 0.0362401725 0.0593019512 0.0200990056 -0.0636426687 0.0519562287 0.1903772691 0.2897396178 0.0600595019 -2.2721326416
2/1/13 0.2633240096 -0.0068993677 -0.0101922604 -0.0028345579 -0.0130490644 -2.3906841854 0.2505461873 0.2014229712 0.0112775649 2.4019078621
3/1/13 -2.0282973994 0.0696557885 0.0653410096 0.0290018651 -0.085733135 2.2547643116 0.326846122 0.1920760144 0.110113046 -4.5475672636
4/1/13 2.5682046178 0.0604498212 -0.0508623609 -0.0000979484 0.0511231962 0.0556888316 0.2731004691 0.253098018 -0.0144854319 4.6209684289
5/1/13 0.2031953917 -0.0454345026 0.0275967245 0.041695753 -0.0754320482 -0.0139750504 0.2903142099 0.2858563734 0.0022264287 -0.0682086576
6/1/13 0.2365735049 -2.2814639927 -0.0792088235 -0.0180282961 -0.0600099607 -0.0295214763 -2.0531528889 0.1653012735 -0.1261802989 0.0238709613
7/1/13 0.2521775483 -0.0264631974 0.0212550876 0.0730691552 -0.0758985233 -13.7210425118 2.5385672861 0.348651562 0.0417100767 0.0625989545
8/1/13 0.1773446845 2.2865380721 -0.0668154595 -0.0528309423 -0.095270372 13.8510474854 0.1990564691 0.2804517061 -0.1081191835 -0.0515964125
9/1/13 0.2211353388 0.1341047465 0.0217254561 0.0499241283 -2.330496731 0.0399268913 0.3377054239 0.3368007091 0.0993897894 -0.0352591665
10/1/13 0.2872621822 -2.2749866283 -0.0318700237 0.0456435371 2.2363240689 0.0625697614 0.3152822687 0.1548498342 0.1362885881 0.044392009
11/1/13 0.2284144178 2.3317765107 0.0035189764 0.0580993991 -0.1204720606 -0.0203386209 0.2386776334 0.2391400601 -2.2575378883 0.0016854619
12/1/13 0.2058638827 -0.0207946903 0.049230361 0.0516342557 -0.1114714248 0.0094448431 0.2305329464 0.2417826611 2.2844384536 -0.0168276227
1/1/14 0.1992243254 -0.0878061373 -0.0589122834 -0.0831162415 -0.1466447945 -0.0615503713 0.1244871133 0.1806677487 0.0768156388 -0.0450664977
2/1/14 0.2204089255 0.0576883941 0.0478340815 0.0574257242 -6.9891837709 0.1206363902 -4.366022503 0.3080515426 -2.26538339 0.0421944491
3/1/14 0.2659694567 -0.0697674539 0.0451371241 -2.3557965192 6.8005975241 0.0045459476 4.7941757157 0.123438356 2.3219051767 0.0286907937
4/1/14 0.2592953811 -0.0268536768 0.0213652167 2.3213503834 -0.1084138966 0.0886349207 -6.6696665466 0.3023593834 -0.006267987 0.0164301431
5/1/14 0.2520366659 0.0384048444 -0.0627194564 -2.2538950099 -0.0437745313 -0.0316293326 7.1652598986 0.2510941005 0.0586389931 0.0368667275
6/1/14 0.2353936209 -0.0030178146 -0.0101974686 2.2700950936 -0.0298292694 0.044522227 0.1548143126 0.2156824713 -0.0161231157 -0.0509476409
7/1/14 0.217499988 -2.3224725889 0.0566873353 -0.0803897029 -0.1001774216 -0.1189566542 0.1558345197 0.1622573547 0.0222828112 -0.0530188958
8/1/14 0.2726520689 2.3063718619 0.0041814812 -2.2929748089 -0.117721141 0.0162011189 0.2614746134 0.2454130603 0.0923883459 0.0636595454
9/1/14 0.2304905088 0.1157041028 -0.006131483 2.3348455349 -0.058430789 -0.0293405448 0.2209485876 0.2710592737 0.0239682389 -0.0629162743
10/1/14 0.2636827112 0.0269391185 -0.1429265163 0.0035191536 -0.0434537601 -0.0669501364 0.1907661462 0.2251830516 -0.0106985032 0.0230287996
11/1/14 -2.0385085923 0.051311466 -2.3153425089 0.0449723339 -0.0715610245 -0.0799689482 0.283276415 0.282426789 0.1614900901 -2.2857541304
12/1/14 2.4696740994 -0.0465918738 2.2995804549 -4.7075509934 -0.0672171398 -0.0891651041 0.1830230448 0.2048914939 -0.019619935 2.307057705
1/1/15 0.2222872397 -0.0529924369 -0.044557996 4.6424621377 -0.0596202553 0.0141299467 0.3222487338 0.265522206 0.0353148865 -0.0225296208
2/1/15 0.2779904785 0.0369882962 0.0556638371 -2.2834857045 -0.0367600361 0.0341507936 0.2473510889 0.3360839433 -0.0753936547 0.0259410299
3/1/15 0.1894885868 0.023861479 -0.0010415254 2.3094747314 -0.0532781517 -0.0830909591 0.2113955982 0.1089008861 -0.0072864199 0.0444585664
4/1/15 0.2254601207 -0.0294188829 0.0659637645 -0.0436578098 -0.0782026314 0.0939016902 -2.138186785 0.2625405483 -0.1183494893 -0.0289757462
5/1/15 0.2377023523 0.0137734089 -0.0087207892 -0.027376672 -0.0942844019 -0.0752408442 2.4930627194 0.2036044293 -0.1220193198 0.0159448065
6/1/15 0.1914555841 0.0515875126 -0.0336361518 0.0648369731 -0.116606688 -0.0326736325 0.2038428165 0.1646936716 -0.144542157 -0.0141502347
7/1/15 0.2631089339 0.0500704776 -0.0032275185 -0.8794816757 -0.0882933106 0.0094251165 0.2488829519 0.2759922192 0.060349481 0.0372551782
8/1/15 -2.1075179316 0.6558666512 -0.0901660871 0.8203195682 -0.2060249547 -0.0666036897 0.1121056805 -2.2352208944 -0.0177874948 -0.0240583581
9/1/15 2.5340602501 -0.6196827042 -0.0107749181 -0.0674580611 -0.082412869 -0.0432842339 0.218770943 2.4940627181 0.0062121146 -0.0176240815
10/1/15 0.3121039306 -2.2510232656 -0.0334132696 0.0312180873 -0.040809915 0.0851905248 0.3332169542 0.2208315903 0.1647827372 0.0282045241
11/1/15 0.2039594011 2.2976231204 -2.3064082254 -0.0152755166 -0.0715500875 0.018798845 0.192494521 0.1357363868 -0.040401777 -0.0045731351
12/1/15 0.2216250015 -0.0710636888 2.2998267752 -0.0715260707 -0.0972762484 -0.1015932259 0.2105808359 0.1613149002 -0.0949397669 -0.0081955066
1/1/16 0.2247806039 -0.019906425 -0.0969638813 -0.1152381633 -0.1108905861 -0.0058012624 0.0250195771 0.216680849 -0.1650498431 -0.0266088579
2/1/16 0.2090076399 -2.3238377386 0.0496937525 -0.0909574338 -0.2285125999 0.0025794348 0.1939817502 0.294686069 0.0774374817 -2.2606874058
3/1/16 -2.0320221477 2.2861782601 0.155891755 0.1136236615 -0.0650214168 0.0095731146 0.2910639974 0.2940477494 0.0342247048 0.0672204964
4/1/16 2.5384020448 -0.0539110533 -0.0361601092 -0.0467304571 -0.1118359995 0.1194351498 -2.0321601846 0.1069179194 -0.0339658292 2.2638795719
5/1/16 -4.3986842815 -0.0796513262 -2.2496177716 -0.1570133113 -0.069448352 -0.0511174898 0.1440267428 0.1157349516 -0.0804295997 0.0239393453
6/1/16 4.8752650729 -0.0148188418 2.3002584287 0.0434793088 -0.1197543995 -0.0148759484 2.5501182825 -2.0672550421 -0.1116065966 0.1210774832
7/1/16 0.2592356963 -0.0061194336 0.0575089598 0.0575163373 0.0237280486 0.0079947333 0.239112698 2.6395980109 -0.0868473905 0.0014975422
8/1/16 0.2039002828 0.0233770849 -2.3125773121 -0.0171735946 -0.0083159041 -0.0134850853 0.1783425669 0.2391163745 -0.0350236697 -0.0148211312
9/1/16 0.2498183749 -0.1050070632 2.311895675 -0.0721079619 -0.1247435249 -0.0072296377 0.2361358406 0.2813380843 0.0242777507 -0.1095979135
10/1/16 0.2094849243 -0.0597265977 -0.0321227929 -2.3254944318 -0.0744856258 0.0093155655 0.2883676388 0.2320308608 -2.3046985823 -0.0366573608
11/1/16 0.155497712 -0.0166510388 0.0549155483 2.2354658113 -0.0616116347 -0.0078590904 0.2658581115 0.2088316551 2.4227665193 -0.0157426437
12/1/16 0.2756553605 0.0179659317 0.0329051193 0.0966766683 -0.0974070651 -2.2416223379 0.2514381238 0.2665147938 0.0354976728 0.0070654178
1/1/17 0.2158672389 0.0117036626 0.0510117414 0.0552381077 -13.9140825485 2.3016163821 0.2588682436 0.3474834486 0.0189914482 0.004965955
2/1/17 0.2856799128 -2.2395907008 0.0308168677 -0.0201125499 13.7066694228 -0.0179198767 0.3082575266 0.2689969266 -2.2342889868 -0.0330762967
3/1/17 0.2373434219 2.2627927262 -0.0233210787 0.0352319244 -0.1269816415 0.0027830866 0.2000369737 0.2372597515 2.1986209742 -0.0292481337
4/1/17 0.243484035 -0.0171041032 -0.0819750901 0.0659412012 -0.0905517375 0.0217799279 0.2544253194 0.1928393804 0.0149766704 -0.0322108273
5/1/17 0.2552238048 -0.0591134118 -2.3506531667 0.0546330395 -0.091686626 0.0156610719 0.2253826995 0.3337061264 0.0350657788 -0.0116675566
6/1/17 0.2189907886 0.0929775923 2.3210377613 -0.0086896524 -0.109834933 -2.3487481752 0.2705051715 0.156823328 0.0020413848 -0.0303625891
7/1/17 0.2336753556 -0.01020683 -0.0604930095 -0.0359876664 -0.014302761 2.317947887 0.4141803867 0.276123858 -0.1422587567 -0.001780623
8/1/17 0.2164490792 -0.1261405187 -0.0105009888 0.0027847853 -0.0848828442 0.0204967121 0.1987317337 -13.551520929 -0.0941357783 -0.0415587465
9/1/17 -13.6223761415 -0.0293717811 0.0256409286 0.0554998236 -0.0327826421 0.0218607577 0.2752333484 14.0625499436 -13.7736161154 -0.035030652
10/1/17 0.2179030501 0.0153736887 0.0727010444 -0.0074646773 -0.0473605294 0.0276525018 -13.5598277309 -13.5188800896 13.8331528541 -0.0058832626

Question 4

Efficient Frontier
PEPSICO NIKE IBM BAYER TOYOTA Average Return Excess Return
Average Return (Mean) - E[R] -0.2240242322 0.0144565855 -0.00089986 0.0100912656 0.086122832 S&P 500 PEPSICO NIKE IBM BAYER TOYOTA S&P 500 PEPSICO NIKE IBM BAYER TOYOTA
Standard Deviation (Total Risk) 2.1725887851 1.0490037991 0.9592041132 1.300880098 2.9612313861 0.0109999276 -0.025679334 0.05702156 0.0121232477 0.0570602072 4.6851770205 0.0017177733 0.1983448983 0.0425649746 0.0130231077 0.0469689416 4.5990541885
Variance 4.7201420289 1.1004089705 0.9200725308 1.6922890294 8.7688913221 0.0353552939 0.0703077551 0.050696758 0.0584020912 0.0301902712 0.0224801633 0.0260731396 0.2943319874 0.0362401725 0.0593019512 0.0200990056 -0.0636426687
Deviation per annun 16.8288003653 8.1255484878 7.4299631121 10.0765739101 22.9375996854 0.0179241659 0.0392997774 0.0075572178 -0.0110921205 0.0072567077 0.0730737676 0.0086420116 0.2633240096 -0.0068993677 -0.0101922604 -0.0028345579 -0.0130490644
Beta -6.6080824391 2.7748245943 7.3917498856 -3.154807038 5.2474318365 0.0205502024 -2.2523216317 0.084112374 0.0644411496 0.0390931308 0.000389697 0.0112680481 -2.0282973994 0.0696557885 0.0653410096 0.0290018651 -0.085733135
Weight PEPSICO NIKE IBM BAYER TOYOTA -0.0151129288 2.3441803856 0.0749064066 -0.051762221 0.0099933172 0.1372460282 -0.0243950831 2.5682046178 0.0604498212 -0.0508623609 -0.0000979484 0.0511231962
0 PEPSICO 4.6401396217 -0.1394994654 0.5201621631 -0.2289929934 0.0339490756 0.048277728 -0.0208288405 -0.0309779171 0.0266968645 0.0517870186 0.0106907838 0.0389955737 0.2031953917 -0.0454345026 0.0275967245 0.041695753 -0.0754320482
0 NIKE -0.1394994654 1.081757971 -0.0906038362 -0.0635793806 -0.6331895945 -0.0317982676 0.0125492726 -2.2670074073 -0.0801086835 -0.0079370305 0.0261128713 -0.0410804219 0.2365735049 -2.2814639927 -0.0792088235 -0.0180282961 -0.0600099607
1.0124385327 IBM 0.5201621631 -0.0906038362 0.9044780811 -0.1866243545 -0.0141186963 0.0293155913 0.0281533161 -0.0120066119 0.0203552276 0.0831604208 0.0102243087 0.020033437 0.2521775483 -0.0264631974 0.0212550876 0.0730691552 -0.0758985233
0 BAYER -0.2289929934 -0.0635793806 -0.1866243545 1.6636061645 -0.2945114606 0.043629971 -0.0466795477 2.3009946576 -0.0677153195 -0.0427396766 -0.00914754 0.0343478167 0.1773446845 2.2865380721 -0.0668154595 -0.0528309423 -0.095270372
0 TOYOTA 0.0339490756 -0.6331895945 -0.0141186963 -0.2945114606 8.6202660455 0.02766329 -0.0028888935 0.148561332 0.0208255961 0.0600153939 -2.244373899 0.0183811358 0.2211353388 0.1341047465 0.0217254561 0.0499241283 -2.330496731
1.0124385327 Variance Weighted Average 0 0 0.9271187797 0 0 0.0232894741 0.0632379499 -2.2605300428 -0.0327698837 0.0557348028 2.3224469009 0.0140073198 0.2872621822 -2.2749866283 -0.0318700237 0.0456435371 2.2363240689
Expected Return -0.0362314075 0.0043901856 2.3462330962 0.0026191163 0.0681906648 -0.0343492286 -0.0455135618 0.2284144178 2.3317765107 0.0035189764 0.0580993991 -0.1204720606
-21.43% Expected return assuming - expected return on market 9% and risk free 5% -21.43% 16.10% 34.57% -7.62% 25.99% 0.0422133749 -0.0181603496 -0.0063381048 0.048330501 0.0617255213 -0.0253485928 0.0329312206 0.2058638827 -0.0207946903 0.049230361 0.0516342557 -0.1114714248
16.10% Expected Excess Return -26.43% 11.10% 29.57% -12.62% 20.99% 0.0069082486 -0.0247999068 -0.0733495518 -0.0598121434 -0.0730249759 -0.0605219625 -0.0023739057 0.1992243254 -0.0878061373 -0.0589122834 -0.0831162415 -0.1466447945
34.57% Mean Excess 4% 0.0061816432 -0.0036153068 0.0721449796 0.0469342215 0.0675169899 -6.9030609389 -0.0031005111 0.2204089255 0.0576883941 0.0478340815 0.0574257242 -6.9891837709
-7.62% Mean 9% 0.020812196 0.0419452245 -0.0553108684 0.0442372641 -2.3457052536 6.8867203561 0.0115300417 0.2659694567 -0.0697674539 0.0451371241 -2.3557965192 6.8005975241
25.99% SD 0.9628700742 0.0188789966 0.0352711488 -0.0123970914 0.0204653567 2.331441649 -0.0222910646 0.0095968423 0.2592953811 -0.0268536768 0.0213652167 2.3213503834 -0.1084138966
Slope -6.6080824391 2.7748245943 7.3917498856 -3.154807038 5.2474318365 -0.0151946874 0.0280124337 0.0528614299 -0.0636193164 -2.2438037443 0.0423483007 -0.0244768417 0.2520366659 0.0384048444 -0.0627194564 -2.2538950099 -0.0437745313
0.0369636443 0.0113693886 0.0114387709 -0.0110973286 2.2801863592 0.0562935626 0.02768149 0.2353936209 -0.0030178146 -0.0101974686 2.2700950936 -0.0298292694
-0.0156354361 -0.0065242442 -2.3080160035 0.0557874752 -0.0702984372 -0.0140545896 -0.0249175904 0.217499988 -2.3224725889 0.0566873353 -0.0803897029 -0.1001774216
Min Variance 0.0229363989 0.0486278366 2.3208284474 0.0032816212 -2.2828835433 -0.031598309 0.0136542447 0.2726520689 2.3063718619 0.0041814812 -2.2929748089 -0.117721141
Mean Excess Return 0.3500000008 0.0242374737 0.0064662765 0.1301606882 -0.007031343 2.3449368005 0.027692043 0.0149553194 0.2304905088 0.1157041028 -0.006131483 2.3348455349 -0.058430789
STDEV 0.9628700742 -0.0041973846 0.0396584789 0.041395704 -0.1438263763 0.0136104192 0.0426690719 -0.0134795389 0.2636827112 0.0269391185 -0.1429265163 0.0035191536 -0.0434537601
Slope 0.3634966027 -0.0315327792 -2.2625328246 0.0657680514 -2.3162423689 0.0550635995 0.0145618075 -0.0408149335 -2.0385085923 0.051311466 -2.3153425089 0.0449723339 -0.0715610245
PEPSICO 0.0379301254 0.0534388764 2.2456498672 -0.0321352884 2.2986805948 -4.6974597277 0.0189056922 0.0441567222 2.4696740994 -0.0465918738 2.2995804549 -4.7075509934 -0.0672171398
NIKE 0.3261466567 -0.0175491972 -0.0017369925 -0.0385358514 -0.0454578561 4.6525534033 0.0265025767 -0.0268313515 0.2222872397 -0.0529924369 -0.044557996 4.6424621377 -0.0596202553
IBM 0.3481007994 0.0084847225 0.0539662463 0.0514448817 0.054763977 -2.2733944389 0.0493627959 -0.0007974318 0.2779904785 0.0369882962 0.0556638371 -2.2834857045 -0.0367600361
BAYER 0.2253421346 0.0104367298 -0.0345356455 0.0383180645 -0.0019413854 2.319565997 0.0328446803 0.0011545755 0.1894885868 0.023861479 -0.0010415254 2.3094747314 -0.0532781517
TOYOTA 0.0624802839 -0.0212355593 0.0014358884 -0.0149622975 0.0650639045 -0.0335665442 0.0079202006 -0.0305177136 0.2254601207 -0.0294188829 0.0659637645 -0.0436578098 -0.0782026314
0.0195496832 0.0136781201 0.0282299943 -0.0096206493 -0.0172854064 -0.0081615699 0.010267529 0.2377023523 0.0137734089 -0.0087207892 -0.027376672 -0.0942844019
-0.0646247309 -0.0325686481 0.0660440981 -0.0345360118 0.0749282387 -0.030483856 -0.0739068852 0.1914555841 0.0515875126 -0.0336361518 0.0648369731 -0.116606688
Efficient Frontier Min Variance Optimum Risky Portfolio that has maxium sharpe ratio -0.0267987313 0.0390847016 0.0645270631 -0.0041273785 -0.86939041 -0.0021704786 -0.0360808855 0.2631089339 0.0500704776 -0.0032275185 -0.8794816757 -0.0882933106
Mean 0.0797193795 -2.3315421639 0.6703232367 -0.0910659471 0.8304108338 -0.1199021227 0.0704372252 -2.1075179316 0.6558666512 -0.0901660871 0.8203195682 -0.2060249547
Mean Excess Return 0.1637871873 0.2 0.22 0.2724840375 0.3 0.33 0.33 0.0005047419 2.3100360179 -0.6052261187 -0.0116747781 -0.0573667954 0.003709963 -0.0087774124 2.5340602501 -0.6196827042 -0.0107749181 -0.0674580611 -0.082412869
STDEV 0.5119498082 13172766337.2997 2.0404611336 0.632074232 0.8446093809 0.8937436601 0.8937436601 -0.0176856585 0.0880796983 -2.2365666801 -0.0343131296 0.0413093529 0.045312917 -0.0269678128 0.3121039306 -2.2510232656 -0.0334132696 0.0312180873 -0.040809915
Slope 0.3199282131 0 0.1078187659 0.4310949944 0.3551937816 0.3692337241 0.3692337241 -0.0520676172 -0.0200648311 2.3120797059 -2.3073080854 -0.0051842509 0.0145727445 -0.0613497715 0.2039594011 2.2976231204 -2.3064082254 -0.0152755166 -0.0715500875
PEPSICO 0.0379301254 2803767476.54295 -0.9430891083 0 0.0353480065 0.0097560121 0.0097560121 -0.0041369056 -0.0023992308 -0.0566071033 2.2989269152 -0.0614348051 -0.0111534164 -0.0134190599 0.2216250015 -0.0710636888 2.2998267752 -0.0715260707 -0.0972762484
NIKE 0.3261466567 -8408363769.83827 0 0.3099112214 0 0 0 0.0639049904 0.0007563717 -0.0054498395 -0.0978637413 -0.1051468977 -0.0247677541 0.0546228361 0.2247806039 -0.019906425 -0.0969638813 -0.1152381633 -0.1108905861
IBM 0.3481007994 5645091668.56904 0 0.5974433369 0.8462560262 0.9217829977 0.9217829977 0.0026957616 -0.0150165924 -2.3093811531 0.0487938925 -0.0808661681 -0.1423897679 -0.0065863926 0.2090076399 -2.3238377386 0.0496937525 -0.0909574338 -0.2285125999
BAYER 0.2253421346 -40495374.3425768 0 0.0238809286 0.0468513608 0.0129794115 0.0129794115 0.0152083666 -2.25604638 2.3006348456 0.154991895 0.1237149271 0.0211014152 0.0059262124 -2.0320221477 2.2861782601 0.155891755 0.1136236615 -0.0650214168
TOYOTA 0.0624802839 0.0688572739 0.0688572739 0.0687645094 0.0715446065 0.0554815784 0.0554815784 0.0009105065 2.3143778126 -0.0394544678 -0.0370599693 -0.0366391915 -0.0257131675 -0.0083716478 2.5384020448 -0.0539110533 -0.0361601092 -0.0467304571 -0.1118359995
Capital Allocation (Risk premium = STDEV* Slope) 0.3500000008 1.1266572612 1.1266572612 1.1266572612 1.1266572612 1.1266572612 1.1266572612 1.1266572612 0.0349904331 -4.6227085137 -0.0651947407 -2.2505176316 -0.1469220456 0.01667448 0.0257082788 -4.3986842815 -0.0796513262 -2.2496177716 -0.1570133113 -0.069448352
-0.001219987 4.6512408407 -0.0003622563 2.2993585687 0.0535705744 -0.0336315675 -0.0105021413 4.8752650729 -0.0148188418 2.3002584287 0.0434793088 -0.1197543995
-0.0012352134 0.035211464 0.0083371518 0.0566090998 0.0676076029 0.1098508806 -0.0105173677 0.2592356963 -0.0061194336 0.0575089598 0.0575163373 0.0237280486
-0.0196168374 -0.0201239495 0.0378336703 -2.3134771721 -0.0070823289 0.0778069279 -0.0288989917 0.2039002828 0.0233770849 -2.3125773121 -0.0171735946 -0.0083159041
0.0336035454 0.0257941426 -0.0905504777 2.310995815 -0.0620166963 -0.0386206929 0.0243213911 0.2498183749 -0.1050070632 2.311895675 -0.0721079619 -0.1247435249
0.0180371111 -0.0145393079 -0.0452700122 -0.0330226529 -2.3154031661 0.0116372062 0.0087549568 0.2094849243 -0.0597265977 -0.0321227929 -2.3254944318 -0.0744856258
0.0177263146 -0.0685265202 -0.0021944533 0.0540156883 2.2455570769 0.0245111973 0.0084441603 0.155497712 -0.0166510388 0.0549155483 2.2354658113 -0.0616116347
0.036523001 0.0516311282 0.0324225172 0.0320052592 0.1067679339 -0.0112842331 0.0272408467 0.2756553605 0.0179659317 0.0329051193 0.0966766683 -0.0974070651
-0.0003892729 -0.0081569934 0.0261602481 0.0501118814 0.0653293734 -13.8279597165 -0.0096714272 0.2158672389 0.0117036626 0.0510117414 0.0552381077 -13.9140825485
0.0090501323 0.0616556806 -2.2251341153 0.0299170077 -0.0100212843 13.7927922548 -0.000232022 0.2856799128 -2.2395907008 0.0308168677 -0.0201125499 13.7066694228
0.0115097593 0.0133191897 2.2772493117 -0.0242209387 0.04532319 -0.0408588095 0.002227605 0.2373434219 2.2627927262 -0.0233210787 0.0352319244 -0.1269816415
0.0048022259 0.0194598028 -0.0026475178 -0.0828749501 0.0760324668 -0.0044289055 -0.0044799284 0.243484035 -0.0171041032 -0.0819750901 0.0659412012 -0.0905517375
0.0191640177 0.0311995725 -0.0446568263 -2.3515530267 0.0647243051 -0.005563794 0.0098818634 0.2552238048 -0.0591134118 -2.3506531667 0.0546330395 -0.091686626
0.0005462836 -0.0050334437 0.1074341778 2.3201379013 0.0014016132 -0.023712101 -0.0087358707 0.2189907886 0.0929775923 2.3210377613 -0.0086896524 -0.109834933
0.0191190393 0.0096511233 0.0042497555 -0.0613928695 -0.0258964007 0.071820071 0.009836885 0.2336753556 -0.01020683 -0.0604930095 -0.0359876664 -0.014302761
-0.0075751531 -0.1116839333 -0.0114008488 0.0128760509 0.0012399878 0.2164490792 -0.1261405187 -0.0105009888 0.0027847853 -0.0848828442
-13.8464003738 -0.0149151956 0.0247410686 0.0655910893 0.0533401899 -13.6223761415 -0.0293717811 0.0256409286 0.0554998236 -0.0327826421
-0.0061211821 0.0298302741 0.0718011843 0.0026265883 0.0387623026 0.2179030501 0.0153736887 0.0727010444 -0.0074646773 -0.0473605294

Question 5 and 6

PEPSICO NIKE IBM BAYER TOYOTA
Average Return (Mean) -0.2240242322 0.0144565855 -0.00089986 0.0100912656 0.086122832
Standard Deviation (Total Risk) 2.1725887851 1.0490037991 0.9592041132 1.300880098 2.9612313861
Variance 4.7201420289 1.1004089705 0.9200725308 1.6922890294 8.7688913221
Optimal (Solver) PEPSICO NIKE IBM BAYER TOYOTA
Weight Portfolio Return 0.0035594241 PEPSICO 4.6401396217 -0.1394994654 0.5201621631 -0.2289929934 0.0339490756
PEPSICO 0.0379301254 Portfolio Variance 0.2620926062 NIKE -0.1394994654 1.081757971 -0.0906038362 -0.0635793806 -0.6331895945
NIKE 0.3261466567 Portfolio Standard Deviation 0.5119498082 IBM 0.5201621631 -0.0906038362 0.9044780811 -0.1866243545 -0.0141186963
IBM 0.3481007994 BAYER -0.2289929934 -0.0635793806 -0.1866243545 1.6636061645 -0.2945114606
BAYER 0.2253421346 TOYOTA 0.0339490756 -0.6331895945 -0.0141186963 -0.2945114606 8.6202660455
TOYOTA 0.0624802839
Sum 1.00
If weight were distributed equally
Weight Portfolio Return -0.0228506818
PEPSICO 0.2 Portfolio Variance 0.5886492319
NIKE 0.2 Portfolio Standard Deviation 0.7672347958
IBM 0.2
BAYER 0.2
TOYOTA 0.2
Sum 1.00

Question 7

Beta Beta, a measure of volatility or systematic risk. Select one company in addition to Standard & Poor's 500 Index (S&P 500). Use Excel to give three ways to find Beta and explain your findings
SOUTHWEST S&P 500
Average Return (Mean) 0.0315050577 0.0092821543
Standard Deviation (Total Risk) 2.7013097009 0.0274177588
Variance 7.2970741002 0.0007517335 Alpha 0.06%
Beta (Risk Measure) - Slope 5.2908 Slope of regression line - (More vulnerable because beta is bigger than 1)
SOUTHWEST S&P 500 SOUTHWEST S&P 500 Beta (Risk Measure) - Covariance 5.2908 Covariance of the 2 stocks divided by the variance of the market (S&P 500) - Excess return of the stock with excess return of market divided by variance of market
Date Average Monthly Return Excess Return Beta (Risk Measure) - Regression 5.2908 Regression coefficient of X Variable 1 same as other results and that is the beta
12/1/12 7.2% 1.1% 4.0% 0.2% R-Squared 0.0274563179
1/1/13 9.2% 3.5% 6.0% 2.6%
2/1/13 4.3% 1.8% 1.1% 0.9% SouthWest is 5 times more vulnerable than the S&P 500
3/1/13 14.2% 2.1% 11.0% 1.1% 0.06% stock outperformed the market
4/1/13 1.7% -1.5% -1.4% -2.4% 5.29 beta - more volatile than the market
5/1/13 3.4% 4.8% 0.2% 3.9% R^2 Loosely predictable
6/1/13 -9.5% -3.2% -12.6% -4.1%
7/1/13 7.3% 2.9% 4.2% 2.0% SUMMARY OUTPUT Beta (Risk Measure) - Regression
8/1/13 -7.7% 4.4% -10.8% 3.4%
9/1/13 13.1% 2.8% 9.9% 1.8% Regression Statistics
10/1/13 16.8% 2.3% 13.6% 1.4% Multiple R 0.1656994807
11/1/13 -222.6% -3.6% -225.8% -4.6% R Square 0.0274563179
12/1/13 231.6% 4.2% 228.4% 3.3% Adjusted R Square 0.0094462497
1/1/14 10.8% 0.7% 7.7% -0.2% Standard Error 0.8713063366
2/1/14 -223.4% 0.6% -226.5% -0.3% Observations 56
3/1/14 235.3% 2.1% 232.2% 1.2%
4/1/14 2.5% 1.9% -0.6% 1.0% ANOVA
5/1/14 9.0% -1.5% 5.9% -2.4% df SS MS F Significance F
6/1/14 1.5% 3.7% -1.6% 2.8% Regression 1 1.1573605712 1.1573605712 1.5244982768 0.2222858758
7/1/14 5.4% -1.6% 2.2% -2.5% Residual 54 40.9954355423 0.7591747323
8/1/14 12.4% 2.3% 9.2% 1.4% Total 55 42.1527961135
9/1/14 5.5% 2.4% 2.4% 1.5%
10/1/14 2.1% -0.4% -1.1% -1.3% Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
11/1/14 19.3% -3.2% 16.1% -4.1% Intercept -0.0169870903 0.123039483 -0.1380621072 0.8907048789 -0.2636664013 0.2296922208 -0.2636664013 0.2296922208
12/1/14 1.2% 5.3% -2.0% 4.4% X Variable 1 5.2907963452 4.285066597 1.234705745 0.2222858758 -3.3002449236 13.8818376141 -3.3002449236 13.8818376141
1/1/15 6.7% -1.8% 3.5% -2.7%
2/1/15 -4.4% 0.8% -7.5% -0.1%
3/1/15 2.4% 1.0% -0.7% 0.1%
4/1/15 -8.7% -2.1% -11.8% -3.1%
5/1/15 -9.1% 2.0% -12.2% 1.0%
6/1/15 -11.3% -6.5% -14.5% -7.4%
7/1/15 9.2% -2.7% 6.0% -3.6%
8/1/15 1.4% 8.0% -1.8% 7.0%
9/1/15 3.8% 0.1% 0.6% -0.9%
10/1/15 19.6% -1.8% 16.5% -2.7%
11/1/15 -0.9% -5.2% -4.0% -6.1%
12/1/15 -6.3% -0.4% -9.5% -1.3%
1/1/16 -13.4% 6.4% -16.5% 5.5%
2/1/16 10.9% 0.3% 7.7% -0.7%
3/1/16 6.6% 1.5% 3.4% 0.6%
4/1/16 -0.2% 0.1% -3.4% -0.8%
5/1/16 -4.9% 3.5% -8.0% 2.6%
6/1/16 -8.0% -0.1% -11.2% -1.1%
7/1/16 -5.5% -0.1% -8.7% -1.1%
8/1/16 -0.4% -2.0% -3.5% -2.9%
9/1/16 5.6% 3.4% 2.4% 2.4%
10/1/16 -227.3% 1.8% -230.5% 0.9%
11/1/16 245.4% 1.8% 242.3% 0.8%
12/1/16 6.7% 3.7% 3.5% 2.7%
1/1/17 5.0% -0.0% 1.9% -1.0%
2/1/17 -220.3% 0.9% -223.4% -0.0%
3/1/17 223.0% 1.2% 219.9% 0.2%
4/1/17 4.6% 0.5% 1.5% -0.4%
5/1/17 6.7% 1.9% 3.5% 1.0%
6/1/17 3.4% 0.1% 0.2% -0.9%
7/1/17 -11.1% 1.9% -14.2% 1.0%

Regressing Southwest Excess Returns on S&P 500, 2012 to 2017

1.717773268705992E-3 2.6073139596813177E-2 8.6420116314452917E-3 1.1268048137567462E-2 -2.4395083094538153E-2 3.8995573675380223E-2 -4.1080421861234964E-2 2.0033437003676803E-2 3.4347816691880619E-2 1.8381135750625194E-2 1.4007319783723214E-2 -4.5513561768175267E-2 3.2931220595881321E-2 -2.3739056678128111E-3 -3.1005111047755288E-3 1.1530041671155804E-2 9.5968423415447503E-3 -2.4476841653695517E-2 2.7681490038008676E-2 -2.4917590361643462E-2 1.3654244663262675E-2 1.4955319391465863E-2 -1.3479538867731391E-2 -4.0814933500108938E-2 4.4156722159949313E-2 -2.6831351513110446E-2 -7.9743183015390691E-4 1.154575479982994E-3 -3.0517713559591764E-2 1.0267528963333191E-2 -7.3906885181701881E-2 -3.6080885547812525E-2 7.0437225211971988E-2 -8.7774124260411243E-3 -2.6967812819601443E-2 -6.134977151069515E-2 -1.3419059919950467E-2 5.4622836132475816E-2 -6.5863926349954399E-3 5.92621236217971E-3 -8.3716477990439971E-3 2.5708278767044075E-2 -1.0502141300829972E-2 -1.0517367689556788E-2 -2.8898991704495752E-2 2.4321391107710755E-2 8.7549567755276555E-3 8.4441603114581033E-3 2.7240846715880139E-2 -9.6714272281266667E-3 -2.3202200270018222E-4 2.2276049711741162E-3 -4.479928359052603E-3 9.8818633786503917E-3 -8.7358707121186572E-3 9.8368850408194815E-3 4.0351758275292214E-2 6.005950188190199E-2 1.1277564862683977E-2 0.1101130459547629 -1.4485431882412917E-2 2.2264286987658394E-3 -0.12618029886096671 4.1710076717426624E-2 -0.10811918348759605 9.9389789406385765E-2 0.13628858814910966 -2.25753788 83332431 2.284438453610083 7.6815638775738382E-2 -2.2653833899506806 2.3219051766563599 -6.2679869771669929E-3 5.8638993143736141E-2 -1.6123115681013905E-2 2.2282811184977311E-2 9.2388345931205096E-2 2.3968238850995728E-2 -1.0698503193237365E-2 0.16149009014865182 -1.96199349654884E-2 3.5314886501101435E-2 -7.5393654713421465E-2 -7.2864198972629191E-3 -0.11834948929984504 -0.1220193198065283 -0.14454215704589382 6.0349480986929223E-2 -1.7787494754457386E-2 6.2121145804539257E-3 0.16478273716113359 -4.0401777003646694E-2 -9.49397669414975E-2 -0.16504984313105303 7.7437481650508705E-2 3.4224704772023003E-2 -3.3965829217049617E-2 -8.0429599716182062E-2 -0.11160659663917705 -8.6847390537539371E-2 -3.5023669683980303E-2 2.4277750673007241E-2 -2.3046985823066177 2.4227665192610663 3.5497672830820358E-2 1.8991448194365268E-2 -2.2342889868182891 2.1986209742455869 1.4976670392833819E-2 3.5065778789564843E-2 2.0413848165387743E-3 -0.14225875669911547

S&P 500 (x)

South West (y)

S&P 500

Date Adj Close Volume Monthly Return Excess Return Average Return(Mean) Variance Standard Deviation
12/1/12 1426.189941 66388180000 0.0092821543 0.0007517335 0.0274177588
1/1/13 1,498 75848510000
2/1/13 1,515 69273480000 0.0109999276 0.0017177733
3/1/13 1,569 68527110000 0.0353552939 0.0260731396
4/1/13 1,598 77098000000 0.0179241659 0.0086420116
5/1/13 1,631 76447250000 0.0205502024 0.0112680481
6/1/13 1,606 74946790000 -0.0151129288 -0.0243950831
7/1/13 1,686 68106820000 0.048277728 0.0389955737
8/1/13 1,633 64802810000 -0.0317982676 -0.0410804219
9/1/13 1,682 66174410000 0.0293155913 0.020033437
10/1/13 1,757 76647400000 0.043629971 0.0343478167
11/1/13 1,806 63628190000 0.02766329 0.0183811358
12/1/13 1,848 64958820000 0.0232894741 0.0140073198
1/1/14 1,783 75871910000 -0.0362314075 -0.0455135618
2/1/14 1,859 69725590000 0.0422133749 0.0329312206
3/1/14 1,872 71885030000 0.0069082486 -0.0023739057
4/1/14 1,884 71595810000 0.0061816432 -0.0031005111
5/1/14 1,924 63623630000 0.020812196 0.0115300417
6/1/14 1,960 63283380000 0.0188789966 0.0095968423
7/1/14 1,931 66524690000 -0.0151946874 -0.0244768417
8/1/14 2,003 58131140000 0.0369636443 0.02768149
9/1/14 1,972 66706000000 -0.0156354361 -0.0249175904
10/1/14 2,018 93714040000 0.0229363989 0.0136542447
11/1/14 2,068 63600190000 0.0242374737 0.0149553194
12/1/14 2,059 80743820000 -0.0041973846 -0.0134795389
1/1/15 1,995 77330040000 -0.0315327792 -0.0408149335
2/1/15 2,105 68775560000 0.0534388764 0.0441567222
3/1/15 2,068 76675850000 -0.0175491972 -0.0268313515
4/1/15 2,086 72060940000 0.0084847225 -0.0007974318
5/1/15 2,107 65187730000 0.0104367298 0.0011545755
6/1/15 2,063 73213980000 -0.0212355593 -0.0305177136
7/1/15 2,104 77920590000 0.0195496832 0.010267529
8/1/15 1,972 84626790000 -0.0646247309 -0.0739068852
9/1/15 1,920 79989370000 -0.0267987313 -0.0360808855
10/1/15 2,079 85844900000 0.0797193795 0.0704372252
11/1/15 2,080 75943590000 0.0005047419 -0.0087774124
12/1/15 2,044 83649260000 -0.0176856585 -0.0269678128
1/1/16 1,940 92409770000 -0.0520676172 -0.0613497715
2/1/16 1,932 93049560000 -0.0041369056 -0.0134190599
3/1/16 2,060 92639420000 0.0639049904 0.0546228361
4/1/16 2,065 81124990000 0.0026957616 -0.0065863926
5/1/16 2,097 78883600000 0.0152083666 0.0059262124
6/1/16 2,099 86852700000 0.0009105065 -0.0083716478
7/1/16 2,174 69530250000 0.0349904331 0.0257082788
8/1/16 2,171 75610310000 -0.001219987 -0.0105021413
9/1/16 2,168 77270240000 -0.0012352134 -0.0105173677
10/1/16 2,126 73196630000 -0.0196168374 -0.0288989917
11/1/16 2,199 88299760000 0.0336035454 0.0243213911
12/1/16 2,239 75251240000 0.0180371111 0.0087549568
1/1/17 2,279 70483180000 0.0177263146 0.0084441603
2/1/17 2,364 69162420000 0.036523001 0.0272408467
3/1/17 2,363 81547770000 -0.0003892729 -0.0096714272
4/1/17 2,384 65265670000 0.0090501323 -0.000232022
5/1/17 2,412 79607170000 0.0115097593 0.002227605
6/1/17 2,423 81002490000 0.0048022259 -0.0044799284
7/1/17 2,470 63169400000 0.0191640177 0.0098818634
8/1/17 2,472 70616030000 0.0005462836 -0.0087358707
9/1/17 2,519 66337980000 0.0191190393 0.009836885

PEPSICO

Date Adj Close Volume Monthly Return Excess Return Average Return(Mean) Variance Standard Deviation
10/1/12 null null -0.2240242322 4.7201420289 2.1725887851
11/1/12 60,897,648 100168400
12/1/12 59,353,745 98276000 -0.025679334 0.1983448983
1/1/13 63,676,971 120185200 0.0703077551 0.2943319874
2/1/13 66,229,286 122822500 0.0392997774 0.2633240096
3/1/13 6,964,328 108962100 -2.2523216317 -2.0282973994
4/1/13 72,601,204 123909700 2.3441803856 2.5682046178
5/1/13 71,104,645 92016900 -0.0208288405 0.2031953917
6/1/13 72,002,579 112685400 0.0125492726 0.2365735049
7/1/13 74,058,495 111819000 0.0281533161 0.2521775483
8/1/13 70,680,923 93237000 -0.0466795477 0.1773446845
9/1/13 70,477,028 92056100 -0.0028888935 0.2211353388
10/1/13 75,077,789 109417600 0.0632379499 0.2872621822
11/1/13 75,408,119 79017100 0.0043901856 0.2284144178
12/1/13 74,051,041 99693900 -0.0181603496 0.2058638827
1/1/14 72,237,167 102347400 -0.0247999068 0.1992243254
2/1/14 71,976,479 143431700 -0.0036153068 0.2204089255
3/1/14 75,059,761 118964900 0.0419452245 0.2659694567
4/1/14 77,754,448 116138500 0.0352711488 0.2592953811
5/1/14 79,963,333 76849900 0.0280124337 0.2520366659
6/1/14 80,877,655 82689300 0.0113693886 0.2353936209
7/1/14 80,351,707 91149100 -0.0065242442 0.217499988
8/1/14 84,355,598 90996100 0.0486278366 0.2726520689
9/1/14 84,902,832 86888800 0.0064662765 0.2304905088
10/1/14 88,337,608 126693700 0.0396584789 0.2636827112
11/1/14 9,194,754 75409800 -2.2625328246 -2.0385085923
12/1/14 86,858,727 94377400 2.2456498672 2.4696740994
1/1/15 86,707,985 111856800 -0.0017369925 0.2222872397
2/1/15 91,515,854 101021500 0.0539662463 0.2779904785
3/1/15 88,409,248 111259900 -0.0345356455 0.1894885868
4/1/15 88,536,285 95836600 0.0014358884 0.2254601207
5/1/15 89,755,615 77389100 0.0136781201 0.2377023523
6/1/15 86,879,486 91613500 -0.0325686481 0.1914555841
7/1/15 90,342,377 107155600 0.0390847016 0.2631089339
8/1/15 8,776,384 126402100 -2.3315421639 -2.1075179316
9/1/15 88,420,204 103551500 2.3100360179 2.5340602501
10/1/15 96,561,508 111021700 0.0880796983 0.3121039306
11/1/15 94,643,326 76086900 -0.0200648311 0.2039594011
12/1/15 94,416,527 92168800 -0.0023992308 0.2216250015
1/1/16 94,487,968 112003300 0.0007563717 0.2247806039
2/1/16 93,079,681 96899800 -0.0150165924 0.2090076399
3/1/16 9,751,387 104728800 -2.25604638 -2.0320221477
4/1/16 98,670,631 100934200 2.3143778126 2.5384020448
5/1/16 969,552 92255700 -4.6227085137 -4.3986842815
6/1/16 101,526,482 97386900 4.6512408407 4.8752650729
7/1/16 105,165,062 91955900 0.035211464 0.2592356963
8/1/16 103,069,878 67251900 -0.0201239495 0.2039002828
9/1/16 105,763,062 90629200 0.0257941426 0.2498183749
10/1/16 104,236,465 87371000 -0.0145393079 0.2094849243
11/1/16 97,332,748 106184200 -0.0685265202 0.155497712
12/1/16 102,490,143 85750400 0.0516311282 0.2756553605
1/1/17 101,657,532 83246300 -0.0081569934 0.2158672389
2/1/17 108,122,551 81757500 0.0616556806 0.2856799128
3/1/17 109,572,289 93121500 0.0133191897 0.2373434219
4/1/17 111,725,426 68457700 0.0194598028 0.243484035
5/1/17 115,266,159 72360700 0.0311995725 0.2552238048
6/1/17 114,687,431 74499100 -0.0050334437 0.2189907886
7/1/17 115,799,652 70464600 0.0096511233 0.2336753556
8/1/17 114,925,766 66908700 -0.0075751531 0.2164490792
9/1/17 111.43 79755600 -13.8464003738 -13.6223761415
10/1/17 110.75 68859400 -0.0061211821 0.2179030501

NIKE

Date Adj Close Volume Monthly Return Excess Return Average Return(Mean) Variance Standard Deviation
10/1/12 null null 0.0144565855 1.1004089705 1.0490037991
11/1/12 22,765,509 188968400
12/1/12 24,101,358 187460200 0.05702156 0.0425649746
1/1/13 25,354,721 149268200 0.050696758 0.0362401725
2/1/13 25,547,058 123347800 0.0075572178 -0.0068993677
3/1/13 27,788,841 197793600 0.084112374 0.0696557885
4/1/13 29,950,348 147312200 0.0749064066 0.0604498212
5/1/13 29,036,772 143206000 -0.0309779171 -0.0454345026
6/1/13 3,008,843 179310200 -2.2670074073 -2.2814639927
7/1/13 2,972,933 139193800 -0.0120066119 -0.0264631974
8/1/13 29,682,085 136639400 2.3009946576 2.2865380721
9/1/13 34,436,085 226198200 0.148561332 0.1341047465
10/1/13 3,591,518 178418000 -2.2605300428 -2.2749866283
11/1/13 37,517,521 102247600 2.3462330962 2.3317765107
12/1/13 37,280,483 162278800 -0.0063381048 -0.0207946903
1/1/14 34,643,856 167970600 -0.0733495518 -0.0878061373
2/1/14 37,235,603 136880200 0.0721449796 0.0576883941
3/1/14 35,231,991 178531800 -0.0553108684 -0.0697674539
4/1/14 34,797,913 166126400 -0.0123970914 -0.0268536768
5/1/14 36,686,867 113444000 0.0528614299 0.0384048444
6/1/14 37,108,929 165319600 0.0114387709 -0.0030178146
7/1/14 3,690,794 134401800 -2.3080160035 -2.3224725889
8/1/14 37,587,444 115312800 2.3208284474 2.3063718619
9/1/14 42,812,527 217202400 0.1301606882 0.1157041028
10/1/14 44,621,975 183619800 0.041395704 0.0269391185
11/1/14 47,655,331 99490000 0.0657680514 0.051311466
12/1/14 46,148,258 166357300 -0.0321352884 -0.0465918738
1/1/15 44,403,725 65078600 -0.0385358514 -0.0529924369
2/1/15 46,747,849 69169400 0.0514448817 0.0369882962
3/1/15 48,573,898 94241100 0.0383180645 0.023861479
4/1/15 47,852,531 61647000 -0.0149622975 -0.0294188829
5/1/15 49,222,656 57032200 0.0282299943 0.0137734089
6/1/15 52,583,275 70939300 0.0660440981 0.0515875126
7/1/15 56,088,184 63468900 0.0645270631 0.0500704776
8/1/15 109,645,058 102499000 0.6703232367 0.6558666512
9/1/15 59,860,825 129835300 -0.6052261187 -0.6196827042
10/1/15 6,394,611 155220000 -2.2365666801 -2.2510232656
11/1/15 64,556,145 157813300 2.3120797059 2.2976231204
12/1/15 61,003,315 176476500 -0.0566071033 -0.0710636888
1/1/16 60,671,761 201089300 -0.0054498395 -0.019906425
2/1/16 6,026,083 210777400 -2.3093811531 -2.3238377386
3/1/16 60,143,421 230046500 2.3006348456 2.2861782601
4/1/16 57,816,696 178008400 -0.0394544678 -0.0539110533
5/1/16 54,167,595 192223100 -0.0651947407 -0.0796513262
6/1/16 54,147,976 316652300 -0.0003622563 -0.0148188418
7/1/16 54,601,303 166759400 0.0083371518 -0.0061194336
8/1/16 56,706,646 180845100 0.0378336703 0.0233770849
9/1/16 51,797,451 230891200 -0.0905504777 -0.1050070632
10/1/16 49,504,864 190211200 -0.0452700122 -0.0597265977
11/1/16 49,396,347 165972900 -0.0021944533 -0.0166510388
12/1/16 51,024,147 229408200 0.0324225172 0.0179659317
1/1/17 52,376,564 175817200 0.0261602481 0.0117036626
2/1/17 5,659,441 178338300 -2.2251341153 -2.2395907008
3/1/17 55,178,558 249512200 2.2772493117 2.2627927262
4/1/17 55,032,665 137900400 -0.0026475178 -0.0171041032
5/1/17 52,629,147 223428200 -0.0446568263 -0.0591134118
6/1/17 58,598,217 275319700 0.1074341778 0.0929775923
7/1/17 58,847,775 158127000 0.0042497555 -0.01020683
8/1/17 52,629,147 174889500 -0.1116839333 -0.1261405187
9/1/17 51849998 211929400 -0.0149151956 -0.0293717811
10/1/17 53419998 167980200 0.0298302741 0.0153736887

IBM

Date Adj Close Volume Monthly Return Excess Return Average Return(Mean) Variance Standard Deviation
10/1/12 null null -0.00089986 0.9200725308 0.9592041132
11/1/12 164,379,578 81892500
12/1/12 166,384,521 79320200 0.0121232477 0.0130231077
1/1/13 176,391,083 87636600 0.0584020912 0.0593019512
2/1/13 174,445,343 64144100 -0.0110921205 -0.0101922604
3/1/13 186,056,915 76023800 0.0644411496 0.0653410096
4/1/13 176,671,204 108666600 -0.051762221 -0.0508623609
5/1/13 181,451,294 90683600 0.0266968645 0.0275967245
6/1/13 167,482,452 80215000 -0.0801086835 -0.0792088235
7/1/13 170,926,529 88079400 0.0203552276 0.0212550876
8/1/13 159,735,367 73077400 -0.0677153195 -0.0668154595
9/1/13 163,096,832 71488100 0.0208255961 0.0217254561
10/1/13 157,838,791 130967100 -0.0327698837 -0.0318700237
11/1/13 158,252,731 100984900 0.0026191163 0.0035189764
12/1/13 166,089,005 97993100 0.048330501 0.049230361
1/1/14 156,446,121 123489300 -0.0598121434 -0.0589122834
2/1/14 163,963,837 87054800 0.0469342215 0.0478340815
3/1/14 171,379,974 118984000 0.0442372641 0.0451371241
4/1/14 174,923,462 118441200 0.0204653567 0.0213652167
5/1/14 164,141,556 70018300 -0.0636193164 -0.0627194564
6/1/14 162,330,093 78501700 -0.0110973286 -0.0101974686
7/1/14 171,643,448 97597800 0.0557874752 0.0566873353
8/1/14 172,207,642 53454100 0.0032816212 0.0041814812
9/1/14 171,001,038 64179600 -0.007031343 -0.006131483
10/1/14 148,093,414 146255300 -0.1438263763 -0.1429265163
11/1/14 14,608,461 80015600 -2.3162423689 -2.3153425089
12/1/14 145,515,335 101583300 2.2986805948 2.2995804549
1/1/15 139,048,615 117006200 -0.0454578561 -0.044557996
2/1/15 146,875,839 76963200 0.054763977 0.0556638371
3/1/15 146,590,973 104847300 -0.0019413854 -0.0010415254
4/1/15 156,445,877 93533800 0.0650639045 0.0659637645
5/1/15 154,947,983 57785700 -0.0096206493 -0.0087207892
6/1/15 149,688,049 80846400 -0.0345360118 -0.0336361518
7/1/15 149,071,503 93854600 -0.0041273785 -0.0032275185
8/1/15 136,095,947 93667600 -0.0910659471 -0.0901660871
9/1/15 134,516,296 81556300 -0.0116747781 -0.0107749181
10/1/15 129,978,912 120371200 -0.0343131296 -0.0334132696
11/1/15 12,936,647 85427700 -2.3073080854 -2.3064082254
12/1/15 128,894,089 97954000 2.2989269152 2.2998267752
1/1/16 116,877,609 126221600 -0.0978637413 -0.0969638813
2/1/16 122,721,947 106605800 0.0487938925 0.0496937525
3/1/16 143,296,097 105698400 0.154991895 0.155891755
4/1/16 138,082,748 93489400 -0.0370599693 -0.0361601092
5/1/16 14,546,283 75181700 -2.2505176316 -2.2496177716
6/1/16 144,994,247 76966700 2.2993585687 2.3002584287
7/1/16 153,439,011 69408600 0.0566090998 0.0575089598
8/1/16 15,177,681 69316700 -2.3134771721 -2.3125773121
9/1/16 153,058,746 69885800 2.310995815 2.311895675
10/1/16 148,086,884 78230800 -0.0330226529 -0.0321227929
11/1/16 156,305,878 76307100 0.0540156883 0.0549155483
12/1/16 161,389,404 68957500 0.0320052592 0.0329051193
1/1/17 169,682,999 88746500 0.0501118814 0.0510117414
2/1/17 174,836,105 59612000 0.0299170077 0.0308168677
3/1/17 170,652,283 79477000 -0.0242209387 -0.0233210787
4/1/17 157,079,666 100052300 -0.0828749501 -0.0819750901
5/1/17 14,957,309 103329100 -2.3515530267 -2.3506531667
6/1/17 152,221,695 83977000 2.3201379013 2.3210377613
7/1/17 143,157,455 93293500 -0.0613928695 -0.0604930095
8/1/17 141,534,607 80268700 -0.0114008488 -0.0105009888
9/1/17 145080002 78296700 0.0247410686 0.0256409286
10/1/17 155880005 100668400 0.0718011843 0.0727010444

BAYER

Date Adj Close Volume Monthly Return Excess Return Average Return(Mean) Variance Standard Deviation
10/1/12 null null 0.0100912656 1.6922890294 1.300880098
11/1/12 18,916,834 4098000
12/1/12 20,027,622 3865600 0.0570602072 0.0469689416
1/1/13 20,641,481 6051200 0.0301902712 0.0200990056
2/1/13 20,791,815 2433200 0.0072567077 -0.0028345579
3/1/13 21,620,729 2722400 0.0390931308 0.0290018651
4/1/13 21,837,875 4616800 0.0099933172 -0.0000979484
5/1/13 22,998,589 3032000 0.0517870186 0.041695753
6/1/13 22,816,771 2640000 -0.0079370305 -0.0180282961
7/1/13 24,795,353 4118400 0.0831604208 0.0730691552
8/1/13 23,757,935 2182400 -0.0427396766 -0.0528309423
9/1/13 25,227,432 3008000 0.0600153939 0.0499241283
10/1/13 26,673,399 2024800 0.0557348028 0.0456435371
11/1/13 28,555,725 2248000 0.0681906648 0.0580993991
12/1/13 30,373,878 4754800 0.0617255213 0.0516342557
1/1/14 28,234,877 5086800 -0.0730249759 -0.0831162415
2/1/14 30,207,039 2747200 0.0675169899 0.0574257242
3/1/14 2,893,219 3858000 -2.3457052536 -2.3557965192
4/1/14 29,779,236 3353600 2.331441649 2.3213503834
5/1/14 3,158,217 2578400 -2.2438037443 -2.2538950099
6/1/14 30,882,633 10249600 2.2801863592 2.2700950936
7/1/14 28,786,184 2592400 -0.0702984372 -0.0803897029
8/1/14 2,935,894 7151200 -2.2828835433 -2.2929748089
9/1/14 30,629,047 3402800 2.3449368005 2.3348455349
10/1/14 31,048,771 6046000 0.0136104192 0.0035191536
11/1/14 32,806,374 3030400 0.0550635995 0.0449723339
12/1/14 299,142 7220000 -4.6974597277 -4.7075509934
1/1/15 31,365,749 4450000 4.6525534033 4.6424621377
2/1/15 3,229,483 5179600 -2.2733944389 -2.2834857045
3/1/15 32,847,908 5442400 2.319565997 2.3094747314
4/1/15 31,763,617 3378800 -0.0335665442 -0.0436578098
5/1/15 31,219,288 3642000 -0.0172854064 -0.027376672
6/1/15 33,648,361 9504000 0.0749282387 0.0648369731
7/1/15 14,105,629 5043200 -0.86939041 -0.8794816757
8/1/15 32,361,996 3514000 0.8304108338 0.8203195682
9/1/15 30,557,739 3147200 -0.0573667954 -0.0674580611
10/1/15 31,846,495 4623600 0.0413093529 0.0312180873
11/1/15 31,681,822 5737600 -0.0051842509 -0.0152755166
12/1/15 29,794,037 10909200 -0.0614348051 -0.0715260707
1/1/16 26,820,362 8585600 -0.1051468977 -0.1152381633
2/1/16 24,736,879 5618800 -0.0808661681 -0.0909574338
3/1/16 27,994,558 4206000 0.1237149271 0.1136236615
4/1/16 26,987,423 7190000 -0.0366391915 -0.0467304571
5/1/16 23,299,896 23299200 -0.1469220456 -0.1570133113
6/1/16 24,582,123 16386000 0.0535705744 0.0434793088
7/1/16 26,301,529 6444400 0.0676076029 0.0575163373
8/1/16 26,115,911 6981200 -0.0070823289 -0.0171735946
9/1/16 24,545,488 7777200 -0.0620166963 -0.0721079619
10/1/16 2,423,287 4913600 -2.3154031661 -2.3254944318
11/1/16 22,889,584 11446400 2.2455570769 2.2354658113
12/1/16 25,468,691 17024000 0.1067679339 0.0966766683
1/1/17 27,188,097 2958500 0.0653293734 0.0552381077
2/1/17 26,916,998 1966400 -0.0100212843 -0.0201125499
3/1/17 28,165,031 1661700 0.04532319 0.0352319244
4/1/17 30,390,001 1328000 0.0760324668 0.0659412012
5/1/17 32,422,024 1811100 0.0647243051 0.0546330395
6/1/17 32,467,499 1758200 0.0014016132 -0.0086896524
7/1/17 31,637,501 1365900 -0.0258964007 -0.0359876664
8/1/17 32,047,501 1233200 0.0128760509 0.0027847853
9/1/17 34220001 2424400 0.0655910893 0.0554998236
10/1/17 34310001 8290000 0.0026265883 -0.0074646773

TOYOTA

Date Adj Close Volume Monthly Return Excess Return Average Return(Mean) Variance Standard Deviation
10/1/12 null null 0.086122832 8.7688913221 2.9612313861
11/1/12 769,562 6800700
12/1/12 83,366,226 7727300 4.6851770205 4.5990541885
1/1/13 85,261,536 10841100 0.0224801633 -0.0636426687
2/1/13 91,725,204 12666000 0.0730737676 -0.0130490644
3/1/13 91,760,956 9150800 0.000389697 -0.085733135
4/1/13 105,259,941 15394800 0.1372460282 0.0511231962
5/1/13 106,391,289 17928700 0.0106907838 -0.0754320482
6/1/13 109,206,062 13879300 0.0261128713 -0.0600099607
7/1/13 110,328,346 9083500 0.0102243087 -0.0758985233
8/1/13 109,323,715 8360300 -0.00914754 -0.095270372
9/1/13 11,587,645 6721300 -2.244373899 -2.330496731
10/1/13 118,200,974 7704200 2.3224469009 2.2363240689
11/1/13 114,209,801 8001200 -0.0343492286 -0.1204720606
12/1/13 111,351,128 8815500 -0.0253485928 -0.1114714248
1/1/14 104,811,821 9045900 -0.0605219625 -0.1466447945
2/1/14 105,305 7753200 -6.9030609389 -6.9891837709
3/1/14 103,113,052 9660400 6.8867203561 6.8005975241
4/1/14 100,839,981 11322900 -0.0222910646 -0.1084138966
5/1/14 105,202,095 7703500 0.0423483007 -0.0437745313
6/1/14 111,294,159 7452600 0.0562935626 -0.0298292694
7/1/14 109,740,906 5568800 -0.0140545896 -0.1001774216
8/1/14 106,327,492 5419400 -0.031598309 -0.117721141
9/1/14 109,313,065 6340200 0.027692043 -0.058430789
10/1/14 114,078,293 10715600 0.0426690719 -0.0434537601
11/1/14 115,751,633 8026600 0.0145618075 -0.0715610245
12/1/14 117,960,815 8056500 0.0189056922 -0.0672171398
1/1/15 121,128,876 6699600 0.0265025767 -0.0596202553
2/1/15 127,258,171 5862000 0.0493627959 -0.0367600361
3/1/15 131,507,324 7387200 0.0328446803 -0.0532781517
4/1/15 132,553,024 5451500 0.0079202006 -0.0782026314
5/1/15 131,475,586 5461000 -0.0081615699 -0.0942844019
6/1/15 127,528,175 4898500 -0.030483856 -0.116606688
7/1/15 127,251,678 5847900 -0.0021704786 -0.0882933106
8/1/15 112,873,161 7952500 -0.1199021227 -0.2060249547
9/1/15 113,292,694 11592400 0.003709963 -0.082412869
10/1/15 118,544,403 5925900 0.045312917 -0.040809915
11/1/15 120,284,569 4928600 0.0145727445 -0.0715500875
12/1/15 118,950,439 6930700 -0.0111534164 -0.0972762484
1/1/16 116,040,489 8483500 -0.0247677541 -0.1108905861
2/1/16 100,639,961 10570800 -0.1423897679 -0.2285125999
3/1/16 102,786,171 8270200 0.0211014152 -0.0650214168
4/1/16 100,176,903 10843600 -0.0257131675 -0.1118359995
5/1/16 101,861,305 10442900 0.01667448 -0.069448352
6/1/16 98,492,516 11610800 -0.0336315675 -0.1197543995
7/1/16 109,928,642 7837700 0.1098508806 0.0237280486
8/1/16 118,823,402 8962300 0.0778069279 -0.0083159041
9/1/16 114,321,846 6822900 -0.0386206929 -0.1247435249
10/1/16 115,660,004 4077400 0.0116372062 -0.0744856258
11/1/16 118,529,999 5317200 0.0245111973 -0.0616116347
12/1/16 117,199,997 4185800 -0.0112842331 -0.0974070651
1/1/17 116 4125200 -13.8279597165 -13.9140825485
2/1/17 113,150,002 5079700 13.7927922548 13.7066694228
3/1/17 108,620,003 5181700 -0.0408588095 -0.1269816415
4/1/17 108,139,999 5862600 -0.0044289055 -0.0905517375
5/1/17 107,540,001 5179700 -0.005563794 -0.091686626
6/1/17 105,019,997 5811100 -0.023712101 -0.109834933
7/1/17 112,839,996 4520600 0.071820071 -0.014302761
8/1/17 112,980,003 4247800 0.0012399878 -0.0848828442
9/1/17 119169998 3710700 0.0533401899 -0.0327826421
10/1/17 123879997 2822300 0.0387623026 -0.0473605294

TOTAL

Date Adj Close Volume Monthly Return Excess Return Average Return(Mean) Variance Standard Deviation
10/1/12 null null 0.0061819676 7.1081945881 2.6661197625
11/1/12 37,920,086 41059500
12/1/12 39,318,657 27962100 0.0362181937 0.0300362261
1/1/13 41,672,329 26389000 0.0581381964 0.0519562287
2/1/13 3,839,473 38424000 -2.3845022178 -2.3906841854
3/1/13 36,828,846 34472300 2.2609462792 2.2547643116
4/1/13 39,179,443 39568500 0.0618707992 0.0556888316
5/1/13 38,875,301 26801000 -0.0077930827 -0.0139750504
6/1/13 37,978,477 25963800 -0.0233395087 -0.0295214763
7/1/13 42 28502400 -13.7148605442 -13.7210425118
8/1/13 43,789,257 35899300 13.857229453 13.8510474854
9/1/13 45,855,602 28572900 0.0461088589 0.0399268913
10/1/13 49,119,156 24078700 0.068751729 0.0625697614
11/1/13 48,428,692 19371900 -0.0141566533 -0.0203386209
12/1/13 49,191,422 22337600 0.0156268107 0.0094448431
1/1/14 46,541,801 20097300 -0.0553684037 -0.0615503713
2/1/14 52,834,755 25321900 0.1268183578 0.1206363902
3/1/14 53,404,613 23529500 0.0107279152 0.0045459476
4/1/14 58,716,103 22861300 0.0948168883 0.0886349207
5/1/14 57,240,784 24535500 -0.025447365 -0.0316293326
6/1/14 60,217,972 17799200 0.0507041947 0.044522227
7/1/14 53,795,841 24088700 -0.1127746866 -0.1189566542
8/1/14 55,013,535 24788000 0.0223830865 0.0162011189
9/1/14 53,754,139 22406300 -0.0231585772 -0.0293405448
10/1/14 50,584,869 44474000 -0.0607681687 -0.0669501364
11/1/14 46,986,744 22628400 -0.0737869806 -0.0799689482
12/1/14 43,245,033 49125200 -0.0829831365 -0.0891651041
1/1/15 44,132,404 50258100 0.0203119144 0.0141299467
2/1/15 45,948,769 35030500 0.0403327612 0.0341507936
3/1/15 42,547,371 31021500 -0.0769089915 -0.0830909591
4/1/15 47,026,051 30132300 0.1000836578 0.0939016902
5/1/15 43,888,084 20741200 -0.0690588766 -0.0752408442
6/1/15 42,740,681 25389300 -0.0264916648 -0.0326736325
7/1/15 43,412,971 34614800 0.0156070841 0.0094251165
8/1/15 40,867,558 67696500 -0.0604217221 -0.0666036897
9/1/15 39,379,063 55547600 -0.0371022662 -0.0432842339
10/1/15 43,146,736 41942800 0.0913724924 0.0851905248
11/1/15 44,238,152 28468900 0.0249808126 0.018798845
12/1/15 40,212,437 45029100 -0.0954112583 -0.1015932259
1/1/16 40,227,749 42811700 0.0003807052 -0.0058012624
2/1/16 40,581,749 77095900 0.0087614024 0.0025794348
3/1/16 41,226,181 56195200 0.0157550822 0.0095731146
4/1/16 46,744,221 46065700 0.1256171174 0.1194351498
5/1/16 44,690,239 33292800 -0.0449355222 -0.0511174898
6/1/16 44,303,387 52733100 -0.0086939808 -0.0148759484
7/1/16 44,935,936 34421600 0.0141767009 0.0079947333
8/1/16 44,608,959 29462100 -0.0073031177 -0.0134850853
9/1/16 44,562,248 39219600 -0.0010476701 -0.0072296377
10/1/16 45,258,232 36222000 0.0154975331 0.0093155655
11/1/16 45,182,392 42144000 -0.0016771228 -0.0078590904
12/1/16 4,832,032 39868400 -2.2354403703 -2.2416223379
1/1/17 48,572,884 38373200 2.3077983497 2.3016163821
2/1/17 48,006,073 43885100 -0.0117379091 -0.0179198767
3/1/17 48,438,385 47311500 0.0089650542 0.0027830866
4/1/17 49,811,928 45215500 0.0279618955 0.0217799279
5/1/17 50,911,942 50398400 0.0218430395 0.0156610719
6/1/17 4,891,658 34906700 -2.3425662076 -2.3487481752
7/1/17 49,981,911 26065100 2.3241298546 2.317947887
8/1/17 51,333,309 29094500 0.0266786797 0.0204967121
9/1/17 52793209 25275900 0.0280427253 0.0218607577
10/1/17 54610001 15522600 0.0338344695 0.0276525018

BOEING

Date Adj Close Volume Monthly Return Excess Return Average Return(Mean) Variance Standard Deviation
10/1/12 null null -0.2103472429 6.1496855718 2.4798559579
11/1/12 65,266,121 101603600
12/1/12 66,622,093 90048100 0.0205631684 0.2309104113
1/1/13 65,304,848 191804200 -0.0199699738 0.1903772691
2/1/13 67,983,513 101429400 0.0401989444 0.2505461873
3/1/13 76,383,301 105390300 0.1164988791 0.326846122
4/1/13 81,330,193 106380800 0.0627532262 0.2731004691
5/1/13 88,101,036 111622200 0.079966967 0.2903142099
6/1/13 9,161,264 99711500 -2.2635001318 -2.0531528889
7/1/13 93,991,486 152799000 2.3282200433 2.5385672861
8/1/13 92,936,218 79814700 -0.0112907738 0.1990564691
9/1/13 105,559,166 89293700 0.127358181 0.3377054239
10/1/13 117,238,068 102075200 0.1049350258 0.3152822687
11/1/13 120,606,964 88250600 0.0283303905 0.2386776334
12/1/13 123,066,238 78680000 0.0201857035 0.2305329464
1/1/14 112,940,666 113971400 -0.0858601296 0.1244871133
2/1/14 1,162,407 119986800 -4.5763697459 -4.366022503
3/1/14 113,786,209 97798400 4.5838284728 4.7941757157
4/1/14 116,987 77966900 -6.8800137895 -6.6696665466
5/1/14 122,635,948 61514500 6.9549126557 7.1652598986
6/1/14 116,011,261 78754100 -0.0555329302 0.1548143126
7/1/14 109,856,453 111816600 -0.0545127231 0.1558345197
8/1/14 115,619,186 79247500 0.0511273705 0.2614746134
9/1/14 116,851,425 75364300 0.0106013447 0.2209485876
10/1/14 114,585,602 107425800 -0.0195810966 0.1907661462
11/1/14 123,254,501 72415400 0.0729291721 0.283276415
12/1/14 119,932,266 96842100 -0.0273241981 0.1830230448
1/1/15 134,132,568 108953000 0.1119014909 0.3222487338
2/1/15 139,188,965 92501800 0.037003846 0.2473510889
3/1/15 139,334,961 81417100 0.0010483553 0.2113955982
4/1/15 13,307,753 84494200 -2.3485340279 -2.138186785
5/1/15 130,459,427 79281400 2.2827154765 2.4930627194
6/1/15 129,613,617 70426300 -0.0065044264 0.2038428165
7/1/15 134,705,856 70138100 0.038535709 0.2488829519
8/1/15 122,101,418 92706100 -0.0982415624 0.1121056805
9/1/15 123,134,308 81148500 0.0084237001 0.218770943
10/1/15 139,232,529 92056900 0.1228697113 0.3332169542
11/1/15 136,768,906 52868200 -0.0178527219 0.192494521
12/1/15 136,800,858 79585600 0.0002335931 0.2105808359
1/1/16 113,658,531 135840800 -0.1853276658 0.0250195771
2/1/16 111,813,591 153106200 -0.0163654926 0.1939817502
3/1/16 121,213,066 107811800 0.0807167545 0.2910639974
4/1/16 12,871,846 96152000 -2.2425074274 -2.0321601846
5/1/16 12,045,871 82219600 -0.0663205001 0.1440267428
6/1/16 125,022,408 102652400 2.3397710396 2.5501182825
7/1/16 128,670,959 76099900 0.0287654551 0.239112698
8/1/16 124,618,088 61444000 -0.032004676 0.1783425669
9/1/16 127,873,611 71550300 0.0257885977 0.2361358406
10/1/16 138,249,878 80920900 0.0780203959 0.2883676388
11/1/16 146,141,251 73628200 0.0555108687 0.2658581115
12/1/16 152,271,408 62860400 0.0410908809 0.2514381238
1/1/17 159,841,949 73355200 0.0485210007 0.2588682436
2/1/17 176,283,905 67319300 0.0979102837 0.3082575266
3/1/17 174,475,708 71329400 -0.0103102692 0.2000369737
4/1/17 182,338,272 52167800 0.0440780765 0.2544253194
5/1/17 185,100,525 66022900 0.0150354566 0.2253826995
6/1/17 196,577,545 64597400 0.0601579286 0.2705051715
7/1/17 241,022,461 75175600 0.2038331438 0.4141803867
8/1/17 238,239,059 84515800 -0.0116155092 0.1987317337
9/1/17 254210007 76743100 0.0648861055 0.2752333484
10/1/17 266 48755400 -13.7701749738 -13.5598277309

BURBERRY

Date Adj Close Volume Monthly Return Excess Return Average Return(Mean) Variance Standard Deviation
10/1/12 null null -0.2276376387 10.1668274111 3.1885462849
11/1/12 17,455,481 6155800
12/1/12 17,160,908 5208000 -0.0170196903 0.2106179484
1/1/13 18,260,422 5480200 0.0621019791 0.2897396178
2/1/13 17,787,951 1967800 -0.0262146675 0.2014229712
3/1/13 17,166,498 4818200 -0.0355616243 0.1920760144
4/1/13 17,609,175 1222000 0.0254603793 0.253098018
5/1/13 18,664,789 399800 0.0582187347 0.2858563734
6/1/13 17,536,816 1072200 -0.0623363652 0.1653012735
7/1/13 19,792,763 1365400 0.1210139233 0.348651562
8/1/13 20,866,196 1107000 0.0528140674 0.2804517061
9/1/13 23,272,991 2937600 0.1091630704 0.3368007091
10/1/13 21,639,183 802000 -0.0727878045 0.1548498342
11/1/13 21,889,523 617000 0.0115024214 0.2391400601
12/1/13 22,201,351 1561400 0.0141450224 0.2417826611
1/1/14 21,182,667 2340000 -0.04696989 0.1806677487
2/1/14 22,956,409 526200 0.0804139039 0.3080515426
3/1/14 20,684,774 4041800 -0.1041992827 0.123438356
4/1/14 22,289,587 3693200 0.0747217447 0.3023593834
5/1/14 22,818,602 712000 0.0234564618 0.2510941005
6/1/14 22,547,426 413200 -0.0119551674 0.2156824713
7/1/14 21,120,426 400000 -0.065380284 0.1622573547
8/1/14 21,499,207 2821200 0.0177754216 0.2454130603
9/1/14 22,453,302 1754000 0.043421635 0.2710592737
10/1/14 22,398,256 922400 -0.0024545871 0.2251830516
11/1/14 23,659,678 787200 0.0547891503 0.282426789
12/1/14 23,127,586 752200 -0.0227461448 0.2048914939
1/1/15 24,020,573 311500 0.0378845673 0.265522206
2/1/15 26,772,011 302400 0.1084463046 0.3360839433
3/1/15 23,774,658 354800 -0.1187367526 0.1089008861
4/1/15 24,619,114 1140300 0.0349029096 0.2625405483
5/1/15 24,034,491 1537900 -0.0240332094 0.2036044293
6/1/15 22,568,293 394400 -0.0629439671 0.1646936716
7/1/15 23,686,388 460600 0.0483545805 0.2759922192
8/1/15 2,017,869 1622100 -2.4628585331 -2.2352208944
9/1/15 19,462,063 1781700 2.2664250794 2.4940627181
10/1/15 19,330,053 678000 -0.0068060484 0.2208315903
11/1/15 17,632,782 485300 -0.0919012519 0.1357363868
12/1/15 16,501,265 883400 -0.0663227385 0.1613149002
1/1/16 16,321,451 828200 -0.0109567897 0.216680849
2/1/16 17,453,299 577600 0.0670484303 0.294686069
3/1/16 18,651,728 622700 0.0664101107 0.2940477494
4/1/16 16,530,697 203800 -0.1207197192 0.1069179194
5/1/16 14,780,613 893300 -0.1119026871 0.1157349516
6/1/16 1,489,475 650500 -2.2948926808 -2.0672550421
7/1/16 16,616,299 464700 2.4119603722 2.6395980109
8/1/16 16,808,132 182900 0.0114787358 0.2391163745
9/1/16 17,735,411 1272100 0.0537004456 0.2813380843
10/1/16 17,813,498 286100 0.0043932221 0.2320308608
11/1/16 17,481,628 414800 -0.0188059836 0.2088316551
12/1/16 18,174,648 501300 0.0388771551 0.2665147938
1/1/17 20,488,699 533400 0.1198458099 0.3474834486
2/1/17 21,353,865 456600 0.0413592879 0.2689969266
3/1/17 21,560,326 211400 0.0096221128 0.2372597515
4/1/17 20,822,968 143700 -0.0347982583 0.1928393804
5/1/17 23,153,017 1701300 0.1060684878 0.3337061264
6/1/17 21,570,158 1200400 -0.0708143107 0.156823328
7/1/17 22,641,783 310100 0.0484862193 0.276123858
8/1/17 23 398900 -13.7791585677 -13.551520929
9/1/17 23940001 619700 13.8349123049 14.0625499436
10/1/17 25.65 403600 -13.7465177282 -13.5188800896

SOUTHWEST

Date Adj Close Volume Monthly Return Excess Return Average Return(Mean) Variance Standard Deviation
10/1/12 null null 0.0315050577 7.2970741002 2.7013097009
11/1/12 9,164,556 133572500
12/1/12 9,847,329 134684300 0.071856816 0.0403517583
1/1/13 10,791,565 187986900 0.0915645596 0.0600595019
2/1/13 11,263,275 127153100 0.0427826225 0.0112775649
3/1/13 12,976,831 140992100 0.1416181036 0.110113046
4/1/13 13,199,582 158625600 0.0170196258 -0.0144854319
5/1/13 13,652,418 174503900 0.0337314864 0.0022264287
6/1/13 12,419,172 150874500 -0.0946752412 -0.1261802989
7/1/13 13,362,557 119536000 0.0732151344 0.0417100767
8/1/13 12,377,031 119007600 -0.0766141258 -0.1081191835
9/1/13 14,107,933 124606400 0.1308948471 0.0993897894
10/1/13 16,685,347 151855900 0.1677936458 0.1362885881
11/1/13 1,801,281 150545200 -2.2260328307 -2.2575378883
12/1/13 18,255,047 122877900 2.3159435113 2.2844384536
1/1/14 20,343,517 195636400 0.1083206965 0.0768156388
2/1/14 2,179,039 154461900 -2.2338783323 -2.26538339
3/1/14 22,926,517 148114800 2.3534102343 2.3219051767
4/1/14 23,512,478 141600700 0.0252370707 -0.006267987
5/1/14 25,730,455 105610500 0.0901440508 0.0586389931
6/1/14 26,129,299 140138400 0.015381942 -0.0161231157
7/1/14 27,573,223 141101900 0.0537878689 0.0222828112
8/1/14 31,209,999 102522300 0.1238934036 0.0923883459
9/1/14 32,990,242 150320300 0.0554732965 0.0239682389
10/1/14 33,683,846 278877600 0.0208065545 -0.0106985032
11/1/14 40,854,359 150416400 0.1929951478 0.1614900901
12/1/14 41,342,815 194291500 0.0118851227 -0.019619935
1/1/15 44,199,726 186821100 0.0668199442 0.0353148865
2/1/15 42,301,815 150474600 -0.043888597 -0.0753936547
3/1/15 43,338,814 132882700 0.0242186378 -0.0072864199
4/1/15 39,733,879 140801100 -0.0868444316 -0.1183494893
5/1/15 36,295,361 185838400 -0.0905142621 -0.1220193198
6/1/15 32,416,023 237862200 -0.1130370994 -0.144542157
7/1/15 35,534,618 195239800 0.0918545387 0.060349481
8/1/15 36,025,425 186628400 0.0137175629 -0.0177874948
9/1/15 37,410,152 140309600 0.0377171723 0.0062121146
10/1/15 45,523,556 163675600 0.1962877948 0.1647827372
11/1/15 45,120,342 99927700 -0.0088967193 -0.040401777
12/1/15 42,347,038 138821000 -0.0634347093 -0.0949397669
1/1/16 37,053,162 153889500 -0.1335447855 -0.1650498431
2/1/16 41,317,917 146087600 0.1089425393 0.0774374817
3/1/16 44,124,977 135642000 0.0657297624 0.0342247048
4/1/16 44,016,529 136603700 -0.0024607715 -0.0339658292
5/1/16 41,914,871 112991700 -0.048924542 -0.0804295997
6/1/16 38,688,374 168318000 -0.080101539 -0.1116065966
7/1/16 36,605,438 172792800 -0.0553423329 -0.0868473905
8/1/16 36,476,864 140678000 -0.003518612 -0.0350236697
9/1/16 38,569,469 133578000 0.0557828084 0.0242777507
10/1/16 3,971,991 211571400 -2.2731935246 -2.3046985823
11/1/16 46,225,845 147525000 2.4542715769 2.4227665193
12/1/16 49,429,222 104357100 0.0670027305 0.0354976728
1/1/17 51,989,319 123698600 0.0504965059 0.0189914482
2/1/17 5,744,566 99884700 -2.2027839291 -2.2342889868
3/1/17 53,430,428 137616000 2.2301260319 2.1986209742
4/1/17 55,972,591 91034200 0.0464817281 0.0149766704
5/1/17 59,825,558 89185500 0.0665708365 0.0350657788
6/1/17 61,866,535 105401300 0.0335464425 0.0020413848
7/1/17 55,380,398 105937200 -0.110753699 -0.1422587567
8/1/17 52,018,269 128344000 -0.0626307206 -0.0941357783
9/1/17 55.98 116273300 -13.7421110577 -13.7736161154
10/1/17 58799999 76178900 13.8646579118 13.8331528541

GENERAL MiLLS

Date Adj Close Volume Monthly Return Excess Return Average Return(Mean) Variance Standard Deviation
10/1/12 null null 0.0064627358 1.2729905632 1.1282688347
11/1/12 35,038,391 77233500
12/1/12 34,551,163 72698200 -0.0140031351 -0.0204658709
1/1/13 3,585,046 73881700 -2.2656699058 -2.2721326416
2/1/13 39,850,777 79160000 2.408370598 2.4019078621
3/1/13 424,874 90178800 -4.5411045278 -4.5475672636
4/1/13 43,443,817 77897800 4.6274311647 4.6209684289
5/1/13 40,842,476 81324600 -0.0617459218 -0.0682086576
6/1/13 42,100,361 77568500 0.0303336972 0.0238709613
7/1/13 45,110,634 59368100 0.0690616904 0.0625989545
8/1/13 43,119,888 66850300 -0.0451336767 -0.0515964125
9/1/13 41,895,897 80060500 -0.0287964307 -0.0352591665
10/1/13 44,081,608 63175000 0.0508547448 0.044392009
11/1/13 44,442,261 53448700 0.0081481978 0.0016854619
12/1/13 43,984,001 66391500 -0.0103648869 -0.0168276227
1/1/14 42,318,409 76145400 -0.0386037618 -0.0450664977
2/1/14 44,428,421 53813200 0.0486571849 0.0421944491
3/1/14 46,018,013 71871600 0.0351535295 0.0286907937
4/1/14 47,083,649 67335800 0.022892879 0.0164301431
5/1/14 49,168,602 45191200 0.0433294633 0.0368667275
6/1/14 47,029,278 65052400 -0.0444849051 -0.0509476409
7/1/14 44,889,961 59323200 -0.0465561599 -0.0530188958
8/1/14 48,150,738 48356700 0.0701222812 0.0636595454
9/1/14 45,507,763 74338500 -0.0564535384 -0.0629162743
10/1/14 46,869,843 65511600 0.0294915355 0.0230287996
11/1/14 4,797,443 52778500 -2.2792913946 -2.2857541304
12/1/14 48,501,926 66498300 2.3135204409 2.307057705
1/1/15 47,728,878 71590200 -0.016066885 -0.0225296208
2/1/15 49,300,804 51179600 0.0324037657 0.0259410299
3/1/15 51,876,282 77233400 0.0509213023 0.0444585664
4/1/15 50,721,439 53201200 -0.0225130103 -0.0289757462
5/1/15 51,870,811 38866200 0.0224075423 0.0159448065
6/1/15 51,473,583 58554300 -0.0076874989 -0.0141502347
7/1/15 53,773,815 79170000 0.043717914 0.0372551782
8/1/15 52,835,907 65541600 -0.0175956223 -0.0240583581
9/1/15 52,249,466 94534500 -0.0111613457 -0.0176240815
10/1/15 54,092,575 65418900 0.0346672599 0.0282045241
11/1/15 54,194,885 55875900 0.0018896007 -0.0045731351
12/1/15 54,101,059 78395800 -0.0017327708 -0.0081955066
1/1/16 53,022,038 78471400 -0.0201461221 -0.0266088579
2/1/16 5,564,922 65308500 -2.25422467 -2.2606874058
3/1/16 5,990,448 86045700 0.0736832322 0.0672204964
4/1/16 58,003,799 73053800 2.2703423078 2.2638795719
5/1/16 59,794,315 58225100 0.0304020811 0.0239393453
6/1/16 67,928,169 74203300 0.1275402191 0.1210774832
7/1/16 68,471,054 70302100 0.007960278 0.0014975422
8/1/16 67,901,131 67562100 -0.0083583953 -0.0148211312
9/1/16 61,247,162 78504200 -0.1031351776 -0.1095979135
10/1/16 59,425,468 67677200 -0.030194625 -0.0366573608
11/1/16 58,876,556 69333400 -0.0092799078 -0.0157426437
12/1/16 59,678,459 56069300 0.0135281537 0.0070654178
1/1/17 60,364,418 51639900 0.0114286909 0.004965955
2/1/17 58,779,095 66711800 -0.0266135609 -0.0330762967
3/1/17 57,454,933 79355600 -0.0227853979 -0.0292481337
4/1/17 55,994,461 52883000 -0.0257480915 -0.0322108273
5/1/17 55,703,777 91889200 -0.0052048208 -0.0116675566
6/1/17 54,388,248 91026400 -0.0238998532 -0.0303625891
7/1/17 54,643,497 78836500 0.0046821128 -0.001780623
8/1/17 52,758,991 90477800 -0.0350960106 -0.0415587465
9/1/17 51273102 93828400 -0.0285679161 -0.035030652
10/1/17 51302822 63301200 0.0005794732 -0.0058832626