636879 68844795 513440552 33878605 69532204 504732208

Info icon This preview shows pages 77–87. Sign up to view the full content.

View Full Document Right Arrow Icon
33.636879 68.844795 513.440552 33.878605 69.532204 504.732208 33.82489 68.545265 510.20163 31.810438 68.475479 504.319885 31.989504 69.25631 502.437134 31.300102 67.008606 433.177612 30.556997 64.891243 433.356445 30.333172 63.603474 435.363373 29.787035 63.566593 448.637054 29.357281 61.546684 441.662415 29.572159 61.216171 436.948059 27.888971 65.6036 420.713654 29.903421 64.15519 432.293335 31.112091 65.972313 425.68631 28.271706 66.144821 442.328094 29.071844 59.447639 450.355865 28.351721 60.50592 439.814423 28.111677 57.68692 445.403076 27.916082 55.58868 458.517792 31.712318 55.792755 443.858124 30.41431 54.603664 437.340515 30.707691 51.871002 437.618713 29.5786 54.090885 434.692749 30.583231 56.255829 437.022583 31.712318 57.794186 432.795074 31.02775 58.830223 433.838287 30.467651 58.231087 451.652435 30.785208 56.675735 437.270966 28.860579 58.864426 420.127472 29.566862 58.475864 398.120605 28.066011 54.216034 397.350616 26.282639 50.75021
Image of page 77

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
392.472351 25.417442 55.853436 388.994965 25.337984 54.995747 394.528961 25.258524 57.524616 402.536896 24.940697 60.026207 404.518982 24.755299 57.654575 413.073364 24.719982 56.10294 400.490204 24.675844 55.940506 397.271149 24.306852 58.583717 393.883179 24.525751 59.798782 390.147461 24.122974 61.367016 385.294037 24.455706 58.607338 374.399902 24.411926 56.832123 349.978729 23.860291 64.599586 367.604095 23.492538 67.222336 366.600616 23.413733 68.087959 347.743256 23.24737 65.8386 355.502808 24.035414 67.097015 348.711975 23.475025 65.864456 339.894318 23.168566 68.895454 346.928558 23.308664 75.617699 331.826782 24.254316 73.837326 321.498962 23.031847 68.175804 329.372742 25.038012 70.35836 349,480,000.00 7,710,000,000.00 5,130,000,000.00 360,404,748,294.80 645,094,158,000.00 899,032,500,000.00 9.65% 17.27% 24.06%
Image of page 78
AMZN LUV 1129.130005 53.459999 =$'Stock Portfolio'.AL5 1111.599976 54.139999 =$'Stock Portfolio'.AL6 1100.949951 54.110001 982.909973 59.369999 1002.940002 59.119999 989.580017 58.439999 961.349976 55.98 955.099976 54.93 986.789978 54.720001 965.900024 52.869999 978.25 52.189999 945.26001 52.557007 958.469971 53.04586 967.98999 54.013599 987.580017 56.447903 1020.039978 56.427952 1025.670044 60.139263 1001.809998 61.785412 978.76001 64.090019 968 61.994919 1003.73999 61.775433 987.710022 60.149242 978.309998 59.19833 1006.72998 60.094368 995.780029 60.403004 959.840027 57.78458 961.349976 56.968189 934.150024 58.142994 924.98999 55.972591 898.530029 55.385185 884.669983 54.070992 894.880005 54.299984 886.539978 53.523411 845.609985 52.378475 852.309998 52.945969 852.460022 55.537434 849.880005 58.499165 845.23999 58.181126 845.070007 56.968601 827.460022 54.374603 810.200012 52.555824 835.77002 52.376926 808.330017 50.776794 817.140015 50.83643 795.98999 49.623909 749.869995 49.534458 760.590027 50.14072
Image of page 79

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
757.77002 49.623909 768.659973 49.379639 740.340027 47.515129 780.369995 47.058922 760.159973 46.672134 739.01001 43.478676 755.049988 40.047192 776.320007 38.857082 818.98999 42.080299 822.960022 40.979446 839.429993 38.152935 837.309998 38.569469 805.75 36.933071 778.52002 36.288429 760.140015 37.032249 772.440002 36.585957 769 35.971066 757.309998 35.952656 772.559998 36.120796 765.97998 37.43626 758.809998 36.605438 744.859985 37.416485 735.440002 42.688213 745.809998 40.096855 725.679993 39.167126 698.960022 37.891232 706.390015 39.305603 717.909973 43.049572 725.539978 41.135372 712.23999 41.766869 702.799988 41.628719 709.919983 41.007107 673.950012 41.174843 659.590027 44.016529 620.5 46.62141 625.890015 46.414207 594.599976 43.907993 598.5 43.967201 582.950012 43.473846 552.080017 43.907993 569.609985 42.753563 575.140015 40.874699 555.22998 41.534599 534.900024 38.717693 507.079987 35.693951 502.130005 35.152233 587 37.053162 596.380005 38.412369
Image of page 80
570.179993 39.170765 607.049988 41.574001 675.890015 42.41119 662.789978 43.238537 664.140015 42.096016 640.150024 42.701073 672.640015 48.5919 673.26001 45.06134 668.450012 46.536499 642.349976 45.130177 659.369995 46.074284 625.900024 45.523556 599.030029 44.481106 570.76001 39.888432 539.799988 39.278694 532.539978 37.74453 524.25 37.459328 540.26001 38.816479 529.440002 37.901878 499 36.613575 518.01001 36.485714 494.470001 37.213184 531.52002 38.636532 522.619995 36.889244 536.150024 35.534618 529.419983 34.356667 483.01001 34.121082 443.51001 33.208176 437.709991 31.912441 438.100006 33.689171 434.920013 33.591007 429.920013 34.356667 426.950012 36.412918 429.230011 36.295361 427.630005 36.109241 426 41.036789 433.690002 42.349495 422.869995 41.732323 445.100006 42.604198 375.559998 40.938831 382.649994 41.947845 372.25 41.98703 370.559998 43.338924 378.48999 45.415741 370.579987 43.60342 380.089996 42.360512 380.160004 42.301815 383.660004 43.808392
Image of page 81

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
381.829987 42.360512 374.279999 43.182289 354.529999 44.199726 312.390015 44.786709 290.73999 38.623394 296.929993 39.904976 308.519989 41.763748 309.089996 41.000671 299.899994 39.386475 307.320007 40.453827 312.630005 40.170521 338.640015 40.854359 332.630005 37.142101 327.820007 38.050629 299.859985 37.357025 305.459991 33.683846 287.059998 33.087925 303.640015 30.333042 311.390015 29.86413 322.73999 32.658085 323.209991 33.127003 331.320007 33.761993 331.190002 33.087925 346.380005 32.071945 339.040009 31.270878 331.589996 31.073498 333.630005 29.01623 316.799988 27.573223 307.059998 27.719473 324.01001 28.509224 358.660004 27.114965 346.200012 26.754211 337.48999 27.017467 324.570007 26.461708 324.200012 26.607964 326.269989 25.642702 329.670013 26.839443 312.549988 25.730455 312.23999 25.088411 297.700012 23.94051 292.23999 23.697311 308.01001 23.522209 303.829987 23.298464 324.910004 22.850979 311.730011 22.131111 323 23.162273 338.290009 22.529959 360.619995 22.549412
Image of page 82
373.73999 23.269285 372.059998 22.431278 362.100006 21.79039 346.76001 21.130074 357.350006 20.683388 361.079987 20.809622 358.690002 20.343517 387.600006 20.236704 399.609985 20.605703 397.660004 20.421207 396.440002 18.857817 398.079987 18.197498 402.200012 18.314028 384.23999 18.051565 386.950012 17.741503 393.619995 18.01281 372.309998 17.983742 369.170013 17.596163 350.309998 17.140753 359 16.927584 363.390015 16.636898 328.929993 15.571051 310.890015 14.757132 319.040009 14.427691 316.01001 14.185451 316.339996 13.962591 297.920013 13.468426 295.859985 12.693266 280.980011 12.412269 290.01001 12.857985 284.820007 12.925813 297.26001 13.275599 304.209991 13.710389 312.01001 13.323908 305.230011 13.343231 307.549988 13.005062 285.880005 12.357708 277.690002 12.454329 273.359985 13.024387 273.98999 13.401206 276.869995 13.37301 269.200012 13.652418 261.73999 13.758399 269.899994 13.854743 263.630005 13.642781 258.049988 13.556068 254.809998 12.900908 260.320007 12.852733
Image of page 83

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
272.869995 12.669672 255.479996 12.342093 266.48999 12.987619 257.75 12.399899 261.820007 11.927798 274.190002 11.802373 265.73999 11.378795 265.420013 11.167009 265.089996 11.167009 261.950012 11.205514 265 10.810817 283.98999 11.01298 272.119995 10.839699 267.940002 10.637536 259.149994 10.473886 245.179993 9.780757 256.920013 10.06956 249.190002 9.809639 253.270004 9.433817 252.050003 9.164556 239.880005 9.010691 225.229996 8.587564 226.309998 8.712582 481,870,000.00 593,390,000.00 544,093,875,509.35 31,722,628,806.61 =K265*K2 14.56% 0.85% =K266/SUM($B$266:$K$266)
Image of page 84
Date PG HD KO JNJ WFC 11/6/2017 1.21% -1.10% 0.41% -0.13% -3.82% 10/30/2017 -0.69% -2.20% -0.37% -1.53% 0.60% 10/23/2017 -0.80% 1.95% -0.82% -0.76% 1.46% 10/16/2017 -5.45% -1.05% 0.28% 3.96% 2.01% 10/9/2017 0.60% -1.25% 1.35% 2.06% -3.71% 10/2/2017 1.31% 0.97% 0.91% 2.12% 0.52% 9/25/2017 -1.54% 1.80% -1.21% -1.38% 1.39% 9/18/2017 -1.27% 0.57% -0.86% -2.62% 4.64% 9/11/2017 0.30% -1.21% -0.41% 2.29% 3.86% 9/4/2017 0.17% 5.89% 0.98% -0.36% -3.02% 8/28/2017 -0.14% 0.33% 0.31% -0.18% -1.81% 8/21/2017 -0.12% 1.04% -0.37% -1.04% -0.08% 8/14/2017 1.07% -5.31% 0.02% -0.68% -0.76% 8/7/2017 0.57% 0.97% 0.05% -0.38% -1.25% 7/31/2017 0.34% 2.69% -1.27% 0.68% -1.12% 7/24/2017 2.41% 0.55% 2.00% -2.91% -1.87% 7/17/2017 1.56% -4.58% 0.63% 1.70% -1.76% 7/10/2017 -0.79% 0.01% 0.50% -0.28% -1.61% 7/3/2017 0.41% -1.18% -1.18% -0.13% 0.34% 6/26/2017 -2.73% 0.95% -1.04% -3.40% 5.24% 6/19/2017 -0.43% -3.88% 0.54% 1.21% -2.96% 6/12/2017 1.52% 1.96% -0.17% 1.80% -0.09% 6/5/2017 -0.65% -1.39% -1.40% 0.79% 3.52% 5/29/2017 1.36% -0.13% 0.94% 2.80% -1.40% 5/22/2017 1.00% -1.32% 3.19% -0.38% -1.49% 5/15/2017 -0.11% -0.81% 0.56% 2.36% -0.18% 5/8/2017 -0.52% 0.34% -0.38% -0.22% -3.42% 5/1/2017 -1.12% -0.66% 1.09% -0.29% 2.08% 4/24/2017 -0.87% 3.57% 0.03% 1.07% 1.32% 4/17/2017 -1.74% 2.35% 0.50% -2.94% 2.91% 4/10/2017 0.73% -1.25% 0.27% -0.27% -6.83% 4/3/2017 -0.86% -0.21% 0.25% -0.03% -1.74% 3/27/2017 -0.96% -1.02% 0.60% -1.07% -0.56% 3/20/2017 -0.64% -1.69% 0.94% -2.36% -5.22% 3/13/2017 -0.24% 2.04% -0.77% 1.13% -0.56% 3/6/2017 0.46% -1.07% -0.60% 1.61% -0.32% 2/27/2017 -0.77% 0.85% 1.51% 1.20% 1.60% 2/20/2017 -0.21% 1.62% 1.17% 2.88% -0.74% 2/13/2017 3.32% 1.81% 1.44% 2.77% 1.89% 2/6/2017 0.47% 0.93% -2.49% 1.08% -0.29% 1/30/2017 0.63% -0.67% 0.07% -0.09% 0.94% 1/23/2017 -0.21% 1.58% 0.16% -1.00% 2.47% 1/16/2017 3.85% 0.00% 0.92% -0.72% -0.69% 1/9/2017 -1.37% 0.71% -2.23% -1.79% 0.24% 1/2/2017 0.96% -0.83% 0.52% 0.62% -0.38% Excess returns: Returns minus means
Image of page 85

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
12/26/2016 -1.20% -1.14% -0.49% -0.97% -1.78% 12/19/2016 0.17% -0.46% -0.49% -0.25% 0.86% 12/12/2016 0.20% 0.86% -0.77% 2.85% -3.45% 12/5/2016 2.20% 2.79% 4.67% -0.05% 6.18% 11/28/2016 -1.44% -1.72% -3.01% -2.24% 1.55% 11/21/2016 1.60% 2.08% 1.35% -0.71% -0.63% 11/14/2016 -2.07% -1.60% -0.44% -2.98% 1.83% 11/7/2016 -1.94% 6.72% -1.75% 2.56% 15.41% 10/31/2016 -2.21% -2.60% -1.44% -0.51% -3.84% 10/24/2016 3.54% -2.83% 0.09% 1.33% 2.24% 10/17/2016 -4.91% -0.28% 0.95% -3.89% 0.59% 10/10/2016 -1.92% -1.90% -0.30% -1.74% -1.63% 10/3/2016 0.11% -0.71% -1.56% 0.61% 2.09% 9/26/2016 2.08% 0.28% -1.14% -0.90% -3.50% 9/19/2016 -0.49% 0.91% 2.08% 0.15% 0.43% 9/12/2016 1.91% -1.70% -0.46% -0.31% -7.25% 9/5/2016 -2.41% -5.55% -3.39% -1.24% -3.94% 8/29/2016 0.54% 0.17% 0.63% -0.09% 3.87% 8/22/2016 0.15% -1.23% -1.53% -0.39% -0.54% 8/15/2016 0.15% -1.23% -0.40% -3.04% 1.30% 8/8/2016 1.29% -0.67% 1.11% -1.15% -1.07% 8/1/2016 0.06% -1.38% -0.50% -1.12% 1.22% 7/25/2016 0.47% 0.83% -5.07% -0.16% -0.98% 7/18/2016 -0.50% 0.86% 0.29% 1.32% 1.02% 7/11/2016 0.12% -0.09% 0.40% -0.20% -0.42% 7/4/2016 1.00% 3.16% 0.42% 0.96% 1.35% 6/27/2016 2.85% 2.10% 2.52% 4.46% 2.59% 6/20/2016 -1.22% -1.00% -1.33% -0.19% -2.18% 6/13/2016 -0.25% -1.74% -2.80% -1.64% -3.92% 6/6/2016 0.72% -2.13% 1.94% 1.62% -4.01% 5/30/2016 1.11% -2.07% 0.43% 1.17% -1.56% 5/23/2016 1.58% 1.15% 1.72% 0.76% 3.96% 5/16/2016 -1.66% -1.38% -3.29% -1.14% 0.80% 5/9/2016 -1.27% -2.33% -0.09% 0.40% -1.09% 5/2/2016 2.31% 0.93% 1.00% 0.27% -2.19% 4/25/2016 -1.19% -1.73% 0.43% -1.42% -1.53% 4/18/2016 -1.00% 0.06% -3.59% 2.49% 4.54% 4/11/2016 -1.25% 0.62% -1.81% 0.66% 2.22% 4/4/2016 -0.56% -1.33% -0.07% -0.40% -3.14% 3/28/2016 0.61% 2.89% 2.55% 0.49% -1.18% 3/21/2016 -0.48% -1.10% -0.20% 0.43% -3.55% 3/14/2016 1.53% 2.36% 1.51% -0.52% 0.68% 3/7/2016 -2.27% 1.87% 2.29% 0.81% -0.33% 2/29/2016 2.74% -0.97% 2.07% 0.36% 3.90% 2/22/2016 -1.01% 3.27% -1.60% 1.94% -0.29% 2/15/2016 0.82% 4.10% 1.37% 1.95% 1.38% 2/8/2016 -0.42% -0.51% 1.41%
Image of page 86
Image of page 87
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern