Question: A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 B C D E F G H I ACHC XRS DAI.DE BRK-A Date Adj Close Rend Adj Close Rend Adj Close Rend Adj Close Rend 3/1/2016 55.98 0.0102869518 51.639999 -0.0021256232 61.44 0.0251960621 205500 2/1/2016 55.41 -0.0920858445 51.75 0.078799227 59.93 -0.0165252638 202555 1/4/2016 61.029999 -0.0228946529 47.970001 0.0322788889 60.937 -0.1729730463 194360 12/1/2015 62.459999 -0.0949138213 46.470001 0.0551771105 73.682 -0.0843885527 197800 11/2/2015 69.010002 0.1237583781 44.040001 0.1453836113 80.473 0.0729304161 201360 10/1/2015 61.41 -0.0733363093 38.450001 0.1959564108 75.003 0.2177393168 204596 9/1/2015 66.269997 -0.0925647281 32.150002 0.0482556896 61.592 -0.0950337937 195240 8/3/2015 73.029999 -0.0846076722 30.67 -0.0928719582 68.06 -0.1195456721 202531 7/1/2015 79.779999 0.0185113872 33.810001 -0.0422095763 77.301 -0.0030565658 214000 6/1/2015 78.330002 0.0565147431 35.299999 -0.0254003858 77.538 -0.0426934663 204850 5/1/2015 74.139999 0.0823357518 36.220001 -0.0144217415 80.996 -0.0121595746 214800 4/1/2015 68.5 -0.0432960627 36.75 0.1062612551 81.993 -0.011012472 213400 3/2/2015 71.599998 0.1323738415 33.220001 0.0813802761 82.906 0.0372196019 217500 2/2/2015 63.23 0.0948917749 30.719999 -0.0093518542 79.931 0.0749337673 221180 1/2/2015 57.75 -0.0565266959 31.01 0.1039515842 74.359 0.1668732836 215865 12/1/2014 61.209999 -0.0129011293 28.09 -0.0856119494 63.725 0.0172562416 226000 11/3/2014 62.009998 -0.0006446575 30.719999 -0.0327456234 62.644 0.0930155462 223065 10/1/2014 62.049999 0.2793814227 31.76 -0.0910131394 57.313 0.0214218246 210000 9/2/2014 48.5 -0.0529193332 34.939999 0.0216373678 56.111 -0.0242753056 206900 8/1/2014 51.209999 0.0744859211 34.200001 0.1612903171 57.507 0.0058243257 205880 7/1/2014 47.66 0.0474725275 29.450001 0.0709091273 57.174 -0.0953194721 188124 6/2/2014 45.5 0.0670731958 27.5 0.1961722488 63.198 -0.0186493579 189900 5/1/2014 42.639999 0.0147548548 22.99 0.0393308753 64.399 0.0445057173 192000 4/1/2014 42.02 -0.0687056531 22.120001 -0.0177619449 61.655 0.0049878564 193275 3/3/2014 45.119999 -0.0873786425 22.52 -0.0505901792 61.349 0.0158464697 187350 2/3/2014 49.439999 -0.031348001 23.719999 -0.0096034234 60.392 0.0867538824 173708 1/2/2014 51.040001 0.0783857774 23.950001 0.0891314688 55.571 -0.0122467117 169511 12/2/2013 47.330002 0.0244588956 21.99 0.1162435982 56.26 0.0311583578 177900 11/1/2013 46.200001 0.0640258666 19.700001 0.0265763405 54.56 0.009267652 174750 10/1/2013 43.419998 0.1011919351 19.190001 0.3234483448 54.059 0.0489357161 172994 9/3/2013 39.43 0.028698094 14.5 0.216442953 51.537 0.109778419 170410 8/1/2013 38.330002 0.0395986721 11.92 0.0136054422 46.439 -0.005737898 167050 7/1/2013 36.869999 0.1149077412 11.76 0.1221374046 46.707 0.1233585069 173900 6/3/2013 33.07 -0.009583678 10.48 -0.0367647059 41.578 -0.0591935557 168600 5/1/2013 33.389999 0.0583201286 10.88 0.1262939959 44.194 0.1759978712 171300 4/1/2013 31.549999 0.0734943883 9.66 0.0309498399 37.58 0.0437149364 159000 3/1/2013 29.389999 0.0797207965 9.37 0.0528089888 36.006 -0.0705250658 156280 2/1/2013 27.219999 0.0645287055 8.9 0.0800970874 38.738 0.0650793214 152600 1/2/2013 25.57 0.0950749465 8.24 -0.1416666667 36.371 0.0376298071 145875 12/31/2012 23.35 9.6 35.052 134060 J K L M N O P Q R S T U GM ABBV PSX CX (NYSE) TSLA UA CVS Adj Close Adj Close Rend Adj Close Rend Adj Close Rend Adj Close Rend Adj Close Rend Adj Close Rend 0.0145 30.15 0.024116813 55.700001 0.019959714 84.57 0.0652475257 5.85 0.0559566787 186.350006 -0.0290730329 84.93 0.0148165608 98.300003 0.0422 29.440001 -0.0067475711 54.610001 -0.0052823495 79.389999 -0.002059699 5.54 0.2229580574 191.929993 0.0038179708 83.690002 -0.020367529 97.169998 -0.0174 29.639999 -0.1284915983 54.900002 -0.0635277665 79.553856 -0.0201711305 4.53 -0.1867145422 191.199997 -0.2033665223 85.43 0.0597940571 96.589996 -0.0177 34.009998 -0.0506020749 58.624271 0.0187446835 81.191582 -0.1063039588 5.57 -0.1158730159 240.009995 0.0423434388 80.610001 -0.0650661092 97.332878 -0.0158 35.822701 0.0369522583 57.545597 -0.0235096625 90.849213 0.0341436791 6.3 -0.0015847861 230.259995 0.1127434533 86.220001 -0.0931846951 93.669334 0.0479 34.546143 0.1628913697 58.931046 0.1045689187 87.849701 0.1589016562 6.31 -0.0972818312 206.929993 -0.1669484783 95.080002 -0.0175655819 98.338364 -0.0360 29.707111 0.0322469375 53.352077 -0.1281845903 75.804276 -0.0282028719 6.99 -0.1106870229 248.399994 -0.0026499799 96.779999 0.0130848949 95.723885 -0.0536 28.779074 -0.0656933809 61.196529 -0.1085560227 78.004219 0.0012407526 7.86 -0.0752941176 249.059998 -0.064211897 95.529999 -0.0382563468 101.597488 0.0447 30.802601 -0.0546055468 68.648766 0.0497035861 77.907555 -0.0131578647 8.5 -0.0720524017 266.149994 -0.007865563 99.330002 0.190436237 111.58857 -0.0463 32.581745 -0.0637978406 65.398239 0.0090103502 78.94632 0.0182002066 9.16 -0.0150537634 268.26001 0.069617252 83.440002 0.0641499521 103.729874 0.0066 34.80204 0.0259554763 64.81424 0.0298483797 77.535164 0.0045692874 9.3 -0.0332640333 250.800003 0.1094890496 78.410004 0.0110896321 101.257294 98.20118 -0.0189 33.921589 -0.0650666329 62.935711 0.1137050946 77.182495 0.0090331036 9.62 0.0564729836 226.050003 0.1974889983 77.550003 -0.0396284458 -0.0166 36.28236 0.0133444142 56.510212 -0.0323966959 76.491539 0.0017843688 9.10577 -0.0669954363 188.770004 -0.0716533505 80.75 0.0485650942 101.725883 0.0246 35.804569 0.1437769352 58.402252 0.0024854845 76.355293 0.1233270685 9.75962 0.1417324124 203.339996 -0.0012770628 77.010002 0.0683962245 102.376396 -0.0448 31.303804 -0.0655972508 58.257454 -0.0708578561 67.97245 -0.0192467723 8.54808 -0.1275760149 203.600006 -0.0845735248 72.080002 0.0615611175 96.748505 0.0132 33.501404 0.0535871598 62.70026 -0.0543351435 69.306374 -0.0180772218 9.79808 -0.1854516433 222.410004 -0.0904220499 67.900002 -0.0633190251 94.588631 0.0622 31.797468 0.0646496712 66.302834 0.090450571 70.582306 -0.0634500487 12.02885 0.0170737605 244.520004 0.0116673853 72.489998 0.1053674259 89.727104 0.0150 29.866602 -0.0169067175 60.803154 0.1068804177 75.364166 -0.0345590685 11.82692 -0.0567485959 241.699997 -0.0040382233 65.580002 -0.0509406093 84.276299 0.0050 30.380232 -0.0741516576 54.931999 0.0448625552 78.061913 -0.0656170114 12.53846 -0.014361123 242.679993 -0.1001854572 69.099998 0.0108249998 77.904549 0.0944 32.8134 0.02897692 52.573421 0.0561711276 83.543808 0.0794009605 12.72115 0.0533438989 269.700012 0.2077922453 68.360001 0.0241198652 77.767509 74.74295 -0.0094 31.889345 -0.0683195798 49.77737 -0.0656091712 77.398308 0.0084545256 12.07692 -0.0506424341 223.300003 -0.0698158591 66.75 0.1220372795 -0.0109 34.227772 0.05849488 53.272537 0.038836659 76.749428 -0.0514210967 12.72115 0.0279717172 240.059998 0.1554122028 59.490002 0.171293578 73.510544 -0.0066 32.336266 0.0029003107 51.280956 0.0432027828 80.909904 0.0249988925 12.375 0.0181958803 207.770004 -0.0005772043 50.790001 0.0388627948 76.387764 0.0316 32.242752 0.0017431453 49.157227 0.0222974699 78.936577 0.0799377527 12.15385 0.0408242978 207.889999 -0.002686486 48.889999 -0.1470691033 70.925919 0.0785 32.186646 -0.0407296079 48.085052 0.009624863 73.093636 0.0293881688 11.677139 -0.0344036631 208.449997 -0.1485233499 57.32 0.0131683427 72.741463 0.0248 33.553257 0.0033259044 47.626652 0.0341255455 71.006874 0.029669983 12.093189 0.0573965054 244.809998 0.3494845521 56.575001 0.0466192027 71.070137 -0.0472 33.442032 -0.1172007651 46.055 -0.0604063349 68.960808 -0.0523790778 11.436759 0.0456466327 181.410004 0.2059430462 54.055 0.2383733682 65.803528 0.0180 37.881809 0.0552543572 49.015869 0.0899897023 72.772568 0.1080303497 10.937499 0.0823420152 150.429993 0.1818824181 43.650002 0.0817844898 69.263199 0.0102 35.898273 0.0481730822 44.969112 0 65.677414 0.0868697833 10.1054 0.0330807898 127.279999 -0.2042015918 40.349998 -0.0055453603 64.801788 0.0152 34.248421 0.0272449313 44.969112 0.0929216336 60.428043 0.1143202348 9.78181 -0.0536668943 159.940002 -0.1728809736 40.575001 0.0213971817 60.253273 54.71199 0.0201 33.340073 0.0554577573 41.145779 0.0497535492 54.228615 0.0126095233 10.33654 -0.0053377547 193.369995 0.1442011538 39.724998 0.0937499449 -0.0394 31.588259 -0.0499023938 39.195656 -0.0631045587 53.553333 -0.066600506 10.39201 -0.0234577587 169 0.2585642036 36.32 0.0820795794 55.965302 0.0314 33.247383 0.0768537667 41.835678 0.1102590225 57.374504 0.0439653785 10.641639 0.0879008077 134.279999 0.2507451355 33.564999 0.1242672584 59.281765 -0.0158 30.874557 -0.0171141427 37.681007 -0.0316233101 54.958244 -0.11506688 9.78181 -0.0799988601 107.360001 0.0981996604 29.855 -0.0369354839 54.923046 0.0774 31.412149 0.0988975464 38.911518 -0.0729641654 62.104404 0.0974956801 10.632389 0.0222212501 97.760002 0.8107056562 31 0.0861947762 55.307259 0.0174 28.585148 0.1085549908 41.974125 0.1396810543 56.587379 -0.1289123905 10.40126 -0.0417649583 53.990002 0.4249143158 28.540001 0.1148437891 55.883575 0.0241 25.785954 0.0246777461 36.829712 0.1045503632 64.961754 0.1113405926 10.854602 0.1368709838 37.889999 0.087855206 25.6 0.0389610811 52.610512 48.90797 0.0461 25.16494 -0.0334638912 33.343624 0.0062687897 58.453506 0.0445534007 9.547787 -0.010138223 34.830002 -0.0714475111 24.639999 -0.0312561443 0.0881 26.036213 -0.0256677345 33.135902 55.960285 0.1406780053 9.645576 0.0992911164 37.509998 0.1074697109 25.434999 0.0482175993 48.984509 46.058098 26.722109 49.058792 8.77436 33.869999 24.264999 43 44 R E T U R N 45 Rend Risk 46 47 & R I S K 0.025654867 0.080965331 0.04826617 0.09673447 0.017592029 0.081537034 0.0117116757 0.0387169822 0.00523123 0.06731265 0.015988018 0.068757674 0.01648552 0.07148182 -0.0066428 0.08684801 0.05984459 0.19340631 0.03551082 0.07825196 ACHC 48 49 50 51 52 53 54 55 56 57 58 59 60 C O R E LA C T I O N XRS DAI.D BRK-A GM ABBV PSX CX TSLA UA CVS JNJ C O E F I C I E N T 0.075707 0.180956 0.333789 0.100723 -0.014074 0.430403 0.200276 0.286266 0.605017 0.433419 0.287255 0.045105 0.323829 0.452991 0.380879 0.153106 0.223074 0.385740 0.482996 0.394356 0.187652 0.187011 0.078545 0.180645 0.376818 0.243559 0.353031 0.243559 0.212647 0.119684 0.283564 0.171298 0.256178 0.091421 0.256178 0.332160 0.242354 0.180327 0.089817 -0.021641 -0.022324 0.040260 -0.022324 0.134894 0.315000 0.240869 0.029831 0.447256 0.441793 0.565095 0.351485 0.565095 0.113614 -0.367200 -0.414700 0.106316 0.170682 0.270702 0.632452 0.410031 0.619495 0.410031 0.274068 0.186000 -0.816000 61 62 63 P O R T F O L I O 65 66 67 68 69 W E I G H T % 64 ACHC XRS DAI.D BRK-A GM $ Share return V Expected Return 0.09 4 6300 0.0256548671 0.002308938 Investment 0.2345 1 16415 0.0482661713 0.0113184172 Shares 70,000 0.08 5 5600 0.0175920289 0.0014073623 Bonds 30,000 0.03 10 2100 0.0117116757 0.0003513503 Total 100,000 0.06 7 4200 0.0052312304 0.0003138738 A 70 71 72 73 74 75 76 B C D E ABBV PSX CX TSLA UA CVS JNJ 0.001 12 70 0.02 11 0.04 F G 0.0159880182 0.01648552 2800 -0.0066427971 -0.0002657119 0.1 3 7000 0.0598445881 0.0059844588 0.2245 2 15715 0.0355108178 0.0079721786 0.07 6 4900 0.0207641201 0.0014534884 0.05 8 3500 0.0140916933 0.0007045847 J K L M N O 0.0003297104 9 I 0.000015988 1400 H Total Return Of Shares Portfolio 3.19% P Q R S T U V W X Y 1 CVS 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 JNJ Rend Adj Close Rend 0.011629155 107.220001 0.019104667 0.006004783 105.209999 0.0146731616 -0.00763239 103.68856 0.0167445613 0.039111456 101.980934 0.0146187433 -0.04747923 100.511581 0.0094656074 0.027312713 99.569099 0.0822710154 -0.05781248 92.000153 -0.0067036059 -0.08953499 92.621048 -0.0549950441 0.075761164 98.011177 0.0282167034 0.024418784 95.321518 -0.0267625122 0.03112095 97.942711 0.0168370958 -0.03464903 96.320946 -0.013916489 -0.00635413 97.680313 -0.0186324214 0.058170315 99.534889 0.0308326015 0.022834393 96.557762 -0.0423639789 0.054181254 100.829292 -0.0339954275 0.064677793 104.377655 0.0109020262 0.081789191 103.251999 0.0111642813 0.001762176 102.111992 0.0275715589 0.040466144 99.372147 0.0433772543 0.016765024 95.24086 -0.0432996326 -0.03766598 99.551399 0.0311452662 0.077007744 96.544495 0.0086594301 -0.02495886 95.715652 0.0311513311 0.023516572 92.824059 0.0663266005 0.080035359 87.050308 0.0487495372 -0.04994963 83.003906 -0.0340647567 0.068847036 85.931129 -0.0324319962 0.075489924 88.811462 0.0292716516 0.101280962 86.285736 0.0682892557 -0.02239445 80.770012 0.0032403777 -0.05594407 80.509132 -0.0688659417 0.079360475 86.463524 0.0889820653 -0.00694688 79.398483 0.0199572843 -0.0103128 77.84491 -0.004895213 0.062213099 78.227852 0.0453821218 0.075704267 74.831825 0.071212738 -0.00156251 69.857109 0.0378625583 0.063537383 67.308632 0.0544935624 63.830292 43 44 45 46 0.02076412 0.04848525 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 0.510073 0.01409169 0.03818445 1 ACHC 1 ACHC 2 XRS 3 DAI.D 4 IBM 5 BRK-A 6 GM 7 ABBV 8 PSX 9 WFC 10 CX 11 TSLA 12 LNVGY 13 UA 14 T 15 KO 16 COST 17 JNJ 2 XRS 0 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 3 DAI.D 0 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 4 IBM 0 34 35 36 37 38 39 40 41 42 43 44 45 46 47 5 BRK-A 0 45 46 47 48 49 50 51 52 53 54 55 56 57 6 GM 0 56 57 58 59 60 61 62 63 64 65 66 67 7 ABBV 0 67 68 69 70 71 72 73 74 75 76 77 8 PSX 0 78 79 80 81 82 83 84 85 86 87 9 WFC 0 89 90 91 92 93 94 95 96 97 10 CX 0 100 101 102 103 104 105 106 107 11 TSLA 12 LNVGY 13 UA 14 T 15 KO 16 COST 17 JNJ 0 112 113 114 115 116 117 0 122 123 124 125 126 127 0 133 134 135 136 137 0 144 145 146 147 0 155 156 157 0 166 167 0 177 0

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!