Chp.9 Estimating Beta.xlsx - Date S&P 500 Adj Close S&P 500 Returns Costco Adj Close Costco Return 2730.199951 0.006807 229.39473 0.0057297

Chp.9 Estimating Beta.xlsx - Date S&P 500 Adj Close S&P 500...

This preview shows page 1 - 5 out of 27 pages.

Date S&P 500 Adj Close S&P 500 Returns Costco Adj Close Costco Return 11/1/2018 2730.199951 0.006807 229.39473 0.0057297 10/1/2018 2711.73999 -0.069403 228.087845 -0.0266093 9/1/2018 2913.97998 0.004294 234.323013 0.0100075 8/1/2018 2901.52002 0.030263 232.001251 0.0659320 7/1/2018 2816.290039 0.036022 217.651077 0.0465596 6/1/2018 2718.370117 0.004842 207.96817 0.0572507 5/1/2018 2705.27002 0.021608 196.706573 0.0054778 4/1/2018 2648.050049 0.002719 195.634933 0.0463303 3/1/2018 2640.870117 -0.026884 186.972443 -0.0102974 2/1/2018 2713.830078 -0.038947 188.917801 -0.0203725 1/1/2018 2823.810059 0.056179 192.846573 0.0470126 12/1/2017 2673.610107 0.034343 184.187439 0.0121580 11/1/2017 2584.840088 0.003720 181.974991 0.1449588 10/1/2017 2575.26001 0.022188 158.935837 -0.0195385 9/1/2017 2519.360107 0.019303 162.103088 0.0515201 8/1/2017 2471.649902 0.000546 154.160706 -0.0111663 7/1/2017 2470.300049 0.019349 155.90155 -0.0088790 6/1/2017 2423.409912 0.004814 157.298203 -0.0751155 5/1/2017 2411.800049 0.011576 170.073349 0.0163921 4/1/2017 2384.199951 0.009091 167.330444 0.0586203 3/1/2017 2362.719971 -0.000389 158.064651 -0.0510121 2/1/2017 2363.639893 0.037198 166.561295 0.0806953 1/1/2017 2278.870117 0.017884 154.124191 0.0239834 12/1/2016 2238.830078 0.018201 150.514343 0.0699007 11/1/2016 2198.810059 0.034175 140.680664 0.0151485 10/1/2016 2126.149902 -0.019426 138.58136 -0.0304242 9/1/2016 2168.27002 -0.001234 142.929886 -0.0565739 8/1/2016 2170.949951 -0.001219 151.500885 -0.0306781 7/1/2016 2173.600098 0.035610 156.295746 0.0648242 6/1/2016 2098.860107 0.000911 146.780792 0.0555891 5/1/2016 2096.949951 0.015325 139.051071 0.0072909 4/1/2016 2065.300049 0.002699 138.044601 -0.0599696 3/1/2016 2059.73999 0.065991 146.851212 0.0531709 2/1/2016 1932.22998 -0.004128 139.43721 -0.0072127 1/1/2016 1940.23999 -0.050735 140.450241 -0.0642724 12/1/2015 2043.939941 -0.017530 150.097366 0.0030815 11/1/2015 2080.409912 0.000505 149.636261 0.0208701 10/1/2015 2079.360107 0.082983 146.577179 0.0937263 9/1/2015 1920.030029 -0.026443 134.016327 0.0351122 8/1/2015 1972.180054 -0.062581 129.470337 -0.0361322 7/1/2015 2103.840088 0.019742 134.323746 0.0758183 6/1/2015 2063.110107 -0.021012 124.857277 -0.0528089 5/1/2015 2107.389893 0.010491 131.818466 -0.0004886 4/1/2015 2085.51001 0.008521 131.882904 -0.0557755
Image of page 1

Subscribe to view the full document.

3/1/2015 2067.889893 -0.017396 139.673248 0.0676033 2/1/2015 2104.5 0.054893 130.828796 0.0277643 1/1/2015 1994.98999 -0.031041 127.294548 0.0087478 12/1/2014 2058.899902 -0.004189 126.190659 -0.0000132 11/1/2014 2067.560059 0.024534 126.192322 0.0656071 10/1/2014 2018.050049 0.023201 118.422935 0.0642353 9/1/2014 1972.290039 -0.015514 111.275146 0.0350183 8/1/2014 2003.369995 0.037655 107.510315 0.0332401 7/1/2014 1930.670044 -0.015080 104.051628 0.0206669 6/1/2014 1960.22998 0.019058 101.944748 -0.0043731 5/1/2014 1923.569946 0.021030 102.392525 0.0029391 4/1/2014 1883.949951 0.006201 102.092461 0.0358165 3/1/2014 1872.339966 0.006932 98.562302 -0.0412509 2/1/2014 1859.449951 0.043117 102.803024 0.0395160 1/1/2014 1782.589966 -0.035583 98.895088 -0.0559569 12/1/2013 1848.359985 0.023563 104.756966 -0.0486959 11/1/2013 1805.810059 0.028049 110.119324 0.0629661
Image of page 2
FIIFX Adj Close FIIFX Returns 8.83 0.001468518 8.817052 -0.004167968 8.853955 -0.001906465 8.870867 0.0048331489 8.828199 0.0038261196 8.79455 -0.001795385 8.810368 0.0048275327 8.76804 -0.004015272 8.803388 0.0004452541 8.79947 -0.007381466 8.864906 0.0051387911 8.819584 -0.00821366 8.892625 -0.003864403 8.927123 0.0015011653 8.913742 -0.00170546 8.92897 0.0047077055 8.887132 0.0079578377 8.816968 -0.002141268 8.835888 0.006902314 8.775318 0.0080235769 8.705469 0.0027101086 8.68194 0.0080673814 8.61246 0.0075494319 8.547928 0.0005391345 8.543322 -0.018771617 8.706762 -0.001701637 8.721603 0.0014851868 8.708669 0.0004291819 8.704933 0.0090625059 8.626753 0.0145580966 8.502966 -0.001502977 8.515765 0.0094055343 8.436416 0.0183287726 8.28457 0.0029658337 8.260072 0.0031721094 8.233953 -0.009954261 8.31674 -0.000216024 8.318537 0.0030200796 8.29349 0.0030166122 8.268547 -0.005553881 8.314726 0.0008505403 8.30766 -0.008648547 8.380136 -0.001259727 8.390706 -0.000202921 -0.080000-0.060000-0.040000-0.020000 0.00000 -0.1000000 -0.0500000 0.0000000 0.0500000 0.1000000 0.1500000 0.2000000 Co S&P 500 Retur Costco Returns -0.080000 -0.060000 -0.040000 -0.020000 0.000000 0 -0.08 -0.06 -0.04 -0.02 0 0.02 0.04 0.06 0.08 F S&P 500 Ret FIIFX Returns
Image of page 3

Subscribe to view the full document.

8.392409 0.0040904642
Image of page 4
Image of page 5

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

Ask Expert Tutors You can ask 0 bonus questions You can ask 0 questions (0 expire soon) You can ask 0 questions (will expire )
Answers in as fast as 15 minutes