Question: Adjusted Closing Prices Gross Return Excess Return Cumalitive Gross Date SPX AMZN BAC CSCO FB JNJ XOM Tbill Monthly Tbill SPX AMZN BAC CSCO FB

Adjusted Closing Prices Gross Return Excess Return Cumalitive Gross
Date SPX AMZN BAC CSCO FB JNJ XOM Tbill Monthly Tbill SPX AMZN BAC CSCO FB JNJ XOM EWP SPX AMZN BAC CSCO FB JNJ XOM SPX BAC CSCO
12/30/16 2238.83 749.87 19.96 25.71 115.05 100.97 68.75 0.48 0.0004
1/31/17 2278.87 823.48 20.45 26.36 130.32 99.25 63.89 0.50 0.000416667 0.017884358 0.098163662 0.024434243 0.025274077 0.132724934 -0.017012495 -0.070574284 0.031768356 0.02 0.10 0.02 0.02 0.13 -0.02 -0.07 1.017884358 1.024434243 1.025274077
2/28/17 2363.64 845.04 22.29 29.33 135.54 107.81 62.50 0.52 0.000435833 0.03719816 0.026181569 0.090106121 0.112630344 0.040055139 0.086257604 -0.021771233 0.055176591 0.04 0.03 0.09 0.11 0.04 0.09 -0.02 1.055747784 1.116742038 1.140751049
3/31/17 2362.72 886.54 21.37 29.01 142.05 109.88 63.03 0.74 0.000615 -0.000389197 0.049110103 -0.041251755 -0.01111783 0.048030178 0.01914743 0.008484899 0.011667171 0.00 0.05 -0.04 -0.01 0.05 0.02 0.01 1.05533689 1.07067447 1.128068373
4/28/17 2384.20 924.99 21.14 29.49 150.25 108.93 62.76 0.78 0.00065 0.009091209 0.043370872 -0.010597819 0.016769122 0.05772613 -0.008671346 -0.004389612 0.015301225 0.01 0.04 -0.01 0.02 0.06 -0.01 0.00 1.064931177 1.059327656 1.146985089
5/31/17 2411.80 994.62 20.37 27.29 151.46 113.89 62.46 0.95 0.000791667 0.011576251 0.075276496 -0.036692159 -0.074552278 0.008053291 0.045602111 -0.004774362 0.001752183 0.01 0.07 -0.04 -0.07 0.01 0.05 -0.01 1.077259088 1.020458636 1.061474737
6/30/17 2423.41 968.00 22.05 27.09 150.98 117.48 62.64 0.99 0.0008275 0.004813775 -0.026763985 0.082552139 -0.007294736 -0.003169226 0.031500815 0.002857318 0.012880387 0.00 -0.03 0.08 -0.01 0.00 0.03 0.00 1.082444771 1.10469968 1.053731559
7/31/17 2470.30 987.78 21.92 27.48 169.25 117.86 62.10 1.05 0.0008775 0.019348826 0.020433914 -0.005770562 0.014179943 0.121009435 0.003250714 -0.008547163 0.023692713 0.02 0.02 -0.01 0.01 0.12 0.00 -0.01 1.103388807 1.098324941 1.068673412
8/31/17 2471.65 980.60 21.82 28.14 171.97 118.30 59.80 0.98 0.000815 0.000546433 -0.007268878 -0.004469483 0.024165289 0.016070907 0.003707088 -0.037108448 -0.001217254 0.00 -0.01 0.00 0.02 0.02 0.00 -0.04 1.103991735 1.093415997 1.094498214
9/29/17 2519.36 961.35 23.15 29.38 170.87 116.19 64.22 1.03 0.000856667 0.019302979 -0.019630839 0.060695033 0.044085557 -0.006396499 -0.017828695 0.074020974 0.022090922 0.02 -0.02 0.06 0.04 -0.01 -0.02 0.07 1.125302064 1.159780917 1.142749778
10/31/17 2575.26 1105.28 25.02 30.10 180.06 124.59 65.29 1.12 0.000935833 0.022188135 0.149716603 0.080899674 0.024237613 0.053783597 0.072302202 0.016711179 0.065875145 0.02 0.15 0.08 0.02 0.05 0.07 0.02 1.150270418 1.253606815 1.170447304
11/30/17 2647.58 1176.75 25.84 32.87 177.18 125.28 65.85 1.24 0.001031667 0.028082628 0.06466232 0.032860341 0.092239586 -0.015994696 0.00554651 0.008528301 0.03090706 0.03 0.06 0.03 0.09 -0.02 0.01 0.01 1.182573034 1.294800763 1.278408879
12/29/17 2673.61 1169.47 27.08 33.75 176.46 125.63 66.13 1.36 0.001129167 0.00983163 -0.006186555 0.047923096 0.026809855 -0.004063585 0.002799153 0.004202383 0.011514058 0.01 -0.01 0.05 0.03 0.00 0.00 0.00 1.194199655 1.356851624 1.312682836
1/31/18 2823.81 1450.89 29.36 36.88 186.89 124.26 69.02 1.43 0.001191667 0.056178704 0.240638965 0.084011046 0.092685361 0.059106832 -0.010950446 0.043758897 0.084475109 0.06 0.24 0.08 0.09 0.06 -0.01 0.04 1.261288245 1.470842148 1.434349318
2/28/18 2713.83 1512.45 29.45 39.76 178.32 117.53 60.49 1.62 0.001348333 -0.038947372 0.042429085 0.003124771 0.077996897 -0.045855808 -0.0541165 -0.123545284 -0.01706114 -0.04 0.04 0.00 0.08 -0.05 -0.05 -0.12 1.212164382 1.475438192 1.546224114
3/29/18 2640.87 1447.34 27.62 38.08 159.79 115.97 59.59 1.67 0.001391667 -0.026884499 -0.043049348 -0.062226133 -0.0422063 -0.103914386 -0.013319956 -0.014919338 -0.04700591 -0.03 -0.04 -0.06 -0.04 -0.10 -0.01 -0.02 1.17957595 1.383627379 1.480963716
4/30/18 2648.05 1566.13 27.55 39.64 172.00 114.47 62.10 1.76 0.001469167 0.002718775 0.082074731 -0.002334196 0.04094292 0.076412839 -0.012953663 0.042085301 0.037304655 0.00 0.08 0.00 0.04 0.08 -0.01 0.04 1.182782952 1.380397722 1.541598694
5/31/18 2705.27 1629.62 26.85 38.23 191.78 109.05 65.55 1.87 0.001558333 0.021608342 0.040539412 -0.025446287 -0.035673973 0.114999994 -0.047298826 0.055478189 0.016699752 0.02 0.04 -0.03 -0.04 0.11 -0.05 0.06 1.208340931 1.345271726 1.486603745
6/29/18 2718.37 1699.80 26.06 38.51 194.32 110.62 66.75 1.88 0.001566667 0.004842436 0.043065288 -0.029269865 0.007492344 0.013244384 0.014378985 0.018341044 0.010808697 0.00 0.04 -0.03 0.01 0.01 0.01 0.02 1.214192244 1.305895804 1.497741892
7/31/18 2816.29 1777.44 28.55 38.14 172.58 120.81 65.76 1.99 0.001654167 0.036021556 0.045675897 0.095423796 -0.00953704 -0.111877337 0.092137789 -0.014746815 0.015779382 0.04 0.05 0.10 -0.01 -0.11 0.09 -0.02 1.257929338 1.430509339 1.483457869
8/31/18 2901.52 2012.71 28.60 43.09 175.73 123.61 65.35 2.06 0.0017125 0.030263211 0.13236454 0.001619221 0.129581359 0.01825237 0.023148073 -0.006294868 0.049378449 0.03 0.13 0.00 0.13 0.02 0.02 -0.01 1.29599832 1.432825649 1.675686355
9/28/18 2913.98 2003.00 27.37 43.88 164.46 126.80 69.30 2.15 0.001791667 0.004294287 -0.004824322 -0.042922366 0.018421562 -0.064132415 0.025837072 0.060496457 -0.001587335 0.00 -0.01 -0.04 0.02 -0.06 0.03 0.06 1.301563709 1.371325381 1.706555114
10/31/18 2711.74 1598.01 25.55 41.54 151.79 128.47 64.95 2.28 0.001898333 -0.069403356 -0.202191707 -0.066530832 -0.053251507 -0.077040092 0.01317225 -0.06280884 -0.075175121 -0.07 -0.20 -0.07 -0.05 -0.08 0.01 -0.06 1.211230819 1.280089963 1.615678483
11/30/18 2760.17 1690.17 26.38 43.47 140.61 135.67 65.46 2.31 0.001923333 0.017859357 0.05767175 0.032727232 0.046338582 -0.073654342 0.056043173 0.007855521 0.020763653 0.02 0.06 0.03 0.05 -0.07 0.06 0.01 1.232862623 1.321983764 1.690546733
12/31/18 2506.85 1501.97 23.02 39.35 131.09 119.19 56.15 2.30 0.001916667 -0.091776895 -0.111349786 -0.127545673 -0.094839917 -0.067705035 -0.121511253 -0.14226409 -0.111269292 -0.09 -0.11 -0.13 -0.10 -0.07 -0.12 -0.14 1.11971432 1.153370454 1.530215422
1/31/19 2704.10 1718.73 26.60 43.28 166.69 122.91 60.34 2.34 0.00195 0.078684402 0.144317139 0.155438486 0.099841909 0.271569205 0.031228346 0.074644467 0.129106592 0.08 0.14 0.16 0.10 0.27 0.03 0.07 1.207818371 1.332648611 1.68299505
2/28/19 2784.49 1639.83 27.31 47.38 161.45 127.03 65.80 2.38 0.001985833 0.029728889 -0.045906003 0.026640803 0.094734636 -0.031435629 0.033560411 0.090439323 0.02760559 0.03 -0.05 0.03 0.09 -0.03 0.03 0.09 1.24372547 1.36815144 1.842432973
3/29/19 2834.40 1780.75 25.91 49.41 166.69 129.96 67.27 2.33 0.00194 0.017924256 0.085935766 -0.05123799 0.042882074 0.0324559 0.023053302 0.02239646 0.025514252 0.02 0.09 -0.05 0.04 0.03 0.02 0.02 1.266018324 1.298050111 1.92144032
4/30/19 2945.83 1926.52 28.71 51.52 193.40 131.27 66.84 2.37 0.001973333 0.039313498 0.081858779 0.108372616 0.042864247 0.160237517 0.010086568 -0.006435791 0.065763989 0.04 0.08 0.11 0.04 0.16 0.01 -0.01 1.315789933 1.438723196 2.003801412
5/31/19 2752.06 1775.07 24.98 47.91 177.47 122.76 59.59 2.29 0.001910833 -0.065777731 -0.078613288 -0.130150375 -0.070062605 -0.082368115 -0.064820374 -0.108355729 -0.089461748 -0.07 -0.08 -0.13 -0.07 -0.08 -0.07 -0.11 1.229240256 1.251472834 1.863409865
6/28/19 2941.76 1893.63 27.38 50.40 193.00 130.37 64.53 2.04 0.001695833 0.068930164 0.066791767 0.09611663 0.051893251 0.087507742 0.061990238 0.082803307 0.074117156 0.07 0.07 0.10 0.05 0.09 0.06 0.08 1.313971989 1.371760184 1.96010826
7/31/19 2980.38 1866.78 28.96 51.34 194.23 121.89 62.62 2.03 0.001691667 0.013128152 -0.014179104 0.05793092 0.018629991 0.006373036 -0.065048892 -0.02962276 -0.004719468 0.01 -0.01 0.06 0.02 0.01 -0.07 -0.03 1.331222013 1.451227514 1.99662506
8/30/19 2926.46 1776.29 25.97 43.38 185.67 121.05 58.38 1.93 0.001610833 -0.018091627 -0.048473837 -0.10332463 -0.155054066 -0.044071452 -0.006897208 -0.067624017 -0.071307535 -0.02 -0.05 -0.10 -0.16 -0.04 -0.01 -0.07 1.30713804 1.301279968 1.687040227
9/30/19 2976.74 1735.91 27.72 45.79 178.08 122.01 60.20 1.77 0.001475 0.017181178 -0.022732777 0.067330439 0.055543681 -0.040878958 0.00794652 0.031104016 0.015985487 0.02 -0.02 0.07 0.06 -0.04 0.01 0.03 1.329596212 1.38889572 1.780744651
10/31/19 3037.56 1776.66 29.72 44.36 191.65 124.52 57.61 1.50 0.001248333 0.020431771 0.023474719 0.071991724 -0.031171115 0.076201661 0.020559398 -0.043053479 0.019267151 0.02 0.02 0.07 -0.03 0.08 0.02 -0.04 1.356762217 1.488884717 1.725236855
11/29/19 3140.98 1800.80 31.66 42.31 201.64 130.56 58.78 1.54 0.001283333 0.034047037 0.013587301 0.065557932 -0.046305874 0.0521263 0.048489893 0.020447559 0.025250518 0.03 0.01 0.07 -0.05 0.05 0.05 0.02 1.40295595 1.58649292 1.645348254
12/31/19 3230.78 1847.84 33.65 44.78 205.25 138.52 60.21 1.51 0.001254167 0.028589819 0.026121677 0.062793842 0.058485933 0.017903199 0.0609497 0.024218605 0.041345493 0.03 0.03 0.06 0.06 0.02 0.06 0.02 1.443066207 1.686114905 1.741577982
1/31/20 3225.52 2008.72 31.37 43.24 201.91 141.37 53.60 1.51 0.001258333 -0.001628093 0.087063819 -0.067859113 -0.034446589 -0.016272819 0.020566221 -0.109773774 -0.020520376 0.00 0.09 -0.07 -0.03 -0.02 0.02 -0.11 1.440716762 1.571696642 1.68158656
2/28/20 2954.22 1883.75 27.23 37.56 192.47 128.52 45.02 1.23 0.001025 -0.084110484 -0.062213735 -0.131891729 -0.131390045 -0.046753518 -0.090901281 -0.160037061 -0.104264561 -0.08 -0.06 -0.13 -0.13 -0.05 -0.09 -0.16 1.319537378 1.364402855 1.460642827
3/31/20 2584.59 1949.72 20.41 36.97 166.80 125.32 33.23 0.03 0.000025 -0.125119282 0.035020555 -0.250334687 -0.015527127 -0.133371423 -0.024910668 -0.261858467 -0.10889697 -0.13 0.03 -0.25 -0.02 -0.13 -0.03 -0.26 1.154437808 1.022845493 1.43796324
4/30/20 2912.43 2474.00 23.13 40.24 204.71 143.39 40.67 0.09 0.000075 0.126844038 0.268900169 0.132830963 0.088318836 0.227278197 0.144207909 0.22386084 0.180499486 0.13 0.27 0.13 0.09 0.23 0.14 0.22 1.300871362 1.158711045 1.564962479
5/29/20 3044.31 2442.37 23.19 45.41 225.09 143.14 40.57 0.13 0.000106667 0.04528182 -0.012784916 0.002910738 0.128362387 0.099555412 -0.001725228 -0.002547041 0.035228558 0.04 -0.01 0.00 0.13 0.10 0.00 0.00 1.359777184 1.162083749 1.765844799
6/30/20 3100.29 2758.82 23.00 44.29 227.07 135.33 39.90 0.14 0.0001125 0.018388396 0.129566747 -0.008472924 -0.024675937 0.00879653 -0.054588283 -0.016494415 0.00528862 0.02 0.13 -0.01 -0.03 0.01 -0.05 -0.02 1.384781306 1.152237502 1.722270924
7/31/20 3271.12 3164.68 24.09 45.07 253.67 140.26 37.54 0.08 6.91667E-05 0.055101321 0.147113568 0.047578862 0.01781804 0.11714445 0.036478829 -0.059034002 0.050783291 0.05 0.15 0.05 0.02 0.12 0.04 -0.06 1.461084586 1.207059651 1.752958415
8/31/20 3500.31 3450.96 24.92 40.40 293.20 148.61 36.34 0.10 7.91667E-05 0.070064667 0.090460974 0.034565977 -0.103609362 0.155832437 0.059488427 -0.032131013 0.03370124 0.07 0.09 0.03 -0.10 0.16 0.06 -0.03 1.563454991 1.248782847 1.571335512
9/30/20 3363.00 3148.73 23.49 37.70 261.90 144.22 31.23 0.09 7.08333E-05 -0.03922797 -0.087578524 -0.057583056 -0.067029765 -0.106753127 -0.029528633 -0.140460441 -0.081888924 -0.04 -0.09 -0.06 -0.07 -0.11 -0.03 -0.14 1.502123825 1.176874114 1.466009262
10/30/20 3269.96 3036.15 23.11 34.67 263.11 132.82 29.68 0.08 6.91667E-05 -0.027665786 -0.035754123 -0.016189342 -0.08019485 0.00462005 -0.079057073 -0.049810912 -0.043131042 -0.03 -0.04 -0.02 -0.08 0.00 -0.08 -0.05 1.460566388 1.157821297 1.348442869
11/30/20 3621.63 3168.04 27.46 41.55 276.97 141.12 35.53 0.08 0.0000625 0.107545635 0.043439929 0.188185589 0.198328848 0.052677651 0.062543558 0.197116736 0.123315385 0.11 0.04 0.19 0.20 0.05 0.06 0.20 1.617643929 1.37570658 1.61587799
12/31/20 3756.07 3256.93 29.74 43.22 273.16 153.51 38.41 0.07 5.41667E-05 0.037121459 0.028058324 0.08305793 0.04021372 -0.013755992 0.087780131 0.081038543 0.050665443 0.04 0.03 0.08 0.04 -0.01 0.09 0.08 1.677693231 1.489969921 1.680858455
1/29/21 3714.24 3206.20 29.09 43.41 258.33 159.12 41.78 0.05 0.00004 -0.011136661 -0.015576012 -0.021775021 0.0042804 -0.054290587 0.036535808 0.087821355 0.00576599 -0.01 -0.02 -0.02 0.00 -0.05 0.04 0.09 1.659009331 1.457525794 1.688053203
2/26/21 3811.15 3092.93 34.05 43.69 257.62 155.53 51.52 0.04 2.91667E-05 0.026091451 -0.035328433 0.1706576 0.006505076 -0.002748392 -0.022570304 0.233124987 0.057873422 0.03 -0.04 0.17 0.01 0.00 -0.02 0.23 1.702295292 1.706263648 1.699034116
3/31/21 3972.89 3094.08 38.15 50.35 294.53 161.31 52.90 0.01 1.08333E-05 0.042438633 0.000371863 0.120200984 0.152440334 0.143273056 0.03717026 0.02685307 0.079651595 0.04 0.00 0.12 0.15 0.14 0.04 0.03 1.774538377 1.911358218 1.958035445
4/30/21 4181.17 3467.42 39.96 49.92 325.08 159.72 54.24 0.00 0.0000025 0.052425321 0.120662631 0.047557475 -0.008412649 0.103724538 -0.009857084 0.025255325 0.046088373 0.05 0.12 0.05 -0.01 0.10 -0.01 0.02 1.867569122 2.002257588 1.94156318
5/28/21 4204.11 3223.07 41.80 51.88 328.73 167.16 56.12 0.01 6.66667E-06 0.005486489 -0.070470223 0.045891884 0.039088592 0.01122808 0.046555303 0.0345969 0.017415089 0.01 -0.07 0.05 0.04 0.01 0.05 0.03 1.877815518 2.094144961 2.017456151
6/30/21 4297.50 3440.16 40.82 51.97 347.71 162.70 60.64 0.04 3.33333E-05 0.02221401 0.067354987 -0.023270644 0.001890371 0.05773729 -0.026646941 0.080692231 0.025892882 0.02 0.07 -0.02 0.00 0.06 -0.03 0.08 1.91952933 2.045412859 2.021269891
7/30/21 4395.26 3327.59 37.98 54.68 356.30 170.07 55.35 0.04 3.33333E-05 0.022748055 -0.032722265 -0.069609409 0.052000702 0.024704487 0.045283401 -0.087349442 -0.011682088 0.02 -0.03 -0.07 0.05 0.02 0.04 -0.09 1.963194889 1.903032878 2.126377344
8/31/21 4522.68 3470.79 41.34 58.28 379.38 172.00 53.21 0.04 3.33333E-05 0.028990416 0.043034132 0.088373278 0.065920188 0.064776923 0.01137522 -0.038645151 0.038739098 0.03 0.04 0.09 0.07 0.06 0.01 -0.04 2.020108726 2.071210132 2.266548539
9/30/21 4307.54 3285.04 42.25 53.75 339.39 160.45 57.40 0.03 2.33333E-05 -0.047569169 -0.053518075 0.021976804 -0.077770264 -0.105408797 -0.067174968 0.07887016 -0.034237523 -0.05 -0.05 0.02 -0.08 -0.11 -0.07 0.08 1.924013833 2.116728711 2.09027846
10/29/21 4605.38 3372.43 47.55 55.64 323.57 161.82 62.92 0.05 0.00004 0.069143836 0.026602383 0.125559518 0.035239848 -0.046613063 0.008544874 0.096055747 0.040498218 0.07 0.03 0.13 0.03 -0.05 0.01 0.10 2.05704753 2.382504146 2.163939555
11/30/21 4567.00 3507.07 44.26 54.52 324.46 155.93 59.18 0.05 0.00004 -0.008333706 0.039923776 -0.069275812 -0.020189346 0.002750515 -0.036398916 -0.059342256 -0.02415534 -0.01 0.04 -0.07 -0.02 0.00 -0.04 -0.06 2.039904701 2.217454237 2.120251031
12/30/21 4778.73 3372.89 44.53 63.25 344.36 172.31 60.12 0.03 2.08333E-05 0.046360845 -0.038259907 0.006168834 0.160102098 0.061332659 0.105047173 0.015875654 0.051311085 0.05 -0.04 0.01 0.16 0.06 0.10 0.02 2.134476407 2.231133345 2.45970767
Return 0.164358957 0.341131914 0.201606935 0.210984479 0.260150315 0.122096685 0.017143132 0.187385577
STDEV 0.154002434 0.277519453 0.282515678 0.247021355 0.287227186 0.173427983 0.297075622 0.191628115
CORREL 1 0.609240268 0.807164631 0.601762593 0.692831202 0.657910531 0.705475866
COVARIANCE 0.001976396 0.002169843 0.002926517 0.001907682 0.002553873 0.001464308 0.002689648 0.002285312
Beta 0.073162269 0.080323313 0.108333871 0.070618627 0.09453934 0.05420578 0.099565473 0.084597734
  1. (Challenge, 1 point) For the six stocks and EWP compute the total variance, systematic variance, unique variance, and R2.

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 Accounting Questions!