A-plus writer

profilebauel_33
h.three_companies.xlsx
Home>Business & Finance homework help>A-plus writer

Apple

Apple S&P 500 Apple Return SP return Dividend o
1/1/05 46.9 1,181.27 0.47 Market Return 0.130879007 g 8% Actual Annual Dividend growth
2/1/05 44.86 1,203.6 -0.0434968017 0.0189033836 Risk Premium 9% beta 1.1894803182
3/1/05 41.67 1,180.59 -0.0711101204 -0.0191176471 Risk Free rs=rf+Beta(7%) 15%
4/1/05 36.06 1,156.85 -0.1346292297 -0.0201085898 4% P0=D0(1+g)/rs-g 731%
5/1/05 39.76 1,191.5 0.1026067665 0.0299520249
6/1/05 36.81 1,191.33 -0.074195171 -0.0001426773
7/1/05 42.65 1,234.18 0.1586525401 0.0359682036 Date Dividends
8/1/05 46.89 1,220.33 0.0994138335 -0.011222026 8/8/08 0.37857 SUMMARY OUTPUT
9/1/05 53.61 1,228.81 0.1433141395 0.00694894 11/6/08 0.37857
10/1/05 57.59 1,207.01 0.0742398806 -0.017740741 2/6/09 0.37857 Regression Statistics
11/1/05 67.82 1,249.48 0.1776350061 0.0351861211 5/8/09 0.43571 Multiple R 0.3999294163
12/1/05 71.89 1,248.29 0.0600117959 -0.0009523962 8/7/09 0.43571 R Square 0.159943538
1/1/06 75.51 1,280.08 0.0503547086 0.0254668386 11/5/09 0.43571 Adjusted R Square 0.1529430675
2/1/06 68.49 1,280.66 -0.0929678188 0.0004530967 2/5/10 0.43571 Standard Error 0.1157947712
3/1/06 62.72 1,294.87 -0.0842458753 0.0110958412 5/7/10 0.47 Observations 122
4/1/06 70.39 1,310.61 0.1222895408 0.0121556604 8/6/10 0.47
5/1/06 59.77 1,270.09 -0.1508737037 -0.0309169013 11/5/10 0.47 ANOVA
6/1/06 57.27 1,270.2 -0.0418270035 0.000086608 2/4/11 0.47 df SS MS F Significance F
7/1/06 67.96 1,276.66 0.1866596822 0.0050858133 Regression 1 0.306349634 0.306349634 22.847541122 0.0000050226
8/1/06 67.85 1,303.82 -0.0016185992 0.0212742625 Residual 120 1.6090114856 0.013408429
9/1/06 76.98 1,335.85 0.1345615328 0.0245662745 Total 121 1.9153611197
10/1/06 81.08 1,377.94 0.0532605872 0.0315080286
11/1/06 91.66 1,400.63 0.1304884065 0.0164666096 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
12/1/06 84.84 1,418.3 -0.0744054113 0.0126157515 Intercept 0.0153787778 0.0105791771 1.4536837483 0.1486443386 -0.0055672563 0.0363248119 -0.0055672563 0.0363248119
1/1/07 85.73 1,438.24 0.0104903347 0.0140590848 Market Return 1.1894803182 0.2488499321 4.7799101584 0.0000050226 0.6967747774 1.6821858589 0.6967747774 1.6821858589
2/1/07 84.61 1,406.82 -0.0130642716 -0.0218461453
3/1/07 92.91 1,420.86 0.0980971516 0.0099799548
4/1/07 99.8 1,482.37 0.0741577871 0.0432906831
5/1/07 121.19 1,530.62 0.2143286573 0.0325492286
6/1/07 122.04 1,503.35 0.00701378 -0.0178163097
7/1/07 131.76 1,455.27 0.0796460177 -0.0319819071
8/1/07 138.48 1,473.99 0.0510018215 0.0128635923
9/1/07 153.47 1,526.75 0.1082466782 0.0357940013
10/1/07 189.95 1,549.38 0.2377011794 0.014822335
11/1/07 182.22 1,481.14 -0.0406949197 -0.0440434238
12/1/07 198.08 1,468.36 0.0870376468 -0.0086284889
1/1/08 135.36 1,378.55 -0.3166397415 -0.0611634749
2/1/08 125.02 1,330.63 -0.0763888889 -0.0347611621
3/1/08 143.5 1,322.7 0.1478163494 -0.0059595831
4/1/08 173.95 1,385.59 0.212195122 0.0475466848
5/1/08 188.75 1,400.38 0.0850819201 0.0106741532
6/1/08 167.44 1280 -0.1129006623 -0.0859623816
7/1/08 158.95 1,267.38 -0.0507047301 -0.009859375
8/1/08 169.53 1,282.83 0.0665618119 0.0121905032
9/1/08 113.66 1,166.36 -0.3295581903 -0.0907914533
10/1/08 107.59 968.75 -0.0534048918 -0.1694245344
11/1/08 92.67 896.24 -0.138674598 -0.0748490323
12/1/08 85.35 903.25 -0.0789899644 0.0078215657
1/1/09 90.13 825.88 0.0560046866 -0.0856573485
2/1/09 89.31 735.09 -0.0090979696 -0.1099312249
3/1/09 105.12 797.87 0.1770238495 0.0854045083
4/1/09 125.83 872.81 0.1970129376 0.0939250755
5/1/09 135.81 919.14 0.0793133593 0.0530814267
6/1/09 142.43 919.32 0.0487445696 0.0001958352
7/1/09 163.39 987.48 0.1471600084 0.074141757
8/1/09 168.21 1,020.62 0.0294999694 0.0335601734
9/1/09 185.35 1,057.08 0.101896439 0.0357233838
10/1/09 188.5 1,036.19 0.0169948746 -0.0197619858
11/1/09 199.91 1,095.63 0.060530504 0.057363997
12/1/09 210.73 1,115.1 0.054124356 0.0177705977
1/1/10 192.06 1,073.87 -0.0885967826 -0.0369742624
2/1/10 204.62 1,104.49 0.0653962303 0.0285136935
3/1/10 235 1,169.43 0.1484703353 0.0587963676
4/1/10 261.09 1,186.69 0.1110212766 0.0147593272
5/1/10 256.88 1,089.41 -0.016124708 -0.0819759162
6/1/10 251.53 1,030.71 -0.0208268452 -0.0538823767
7/1/10 257.25 1,101.6 0.0227408261 0.0687778328
8/1/10 243.1 1,049.33 -0.0550048591 -0.0474491649
9/1/10 283.75 1,141.2 0.1672151378 0.087551104
10/1/10 300.98 1,183.26 0.060722467 0.0368559411
11/1/10 311.15 1,180.55 0.0337896206 -0.0022902828
12/1/10 322.56 1,257.64 0.0366704162 0.065300072
1/1/11 339.32 1,286.12 0.0519593254 0.0226455902
2/1/11 353.21 1,327.22 0.0409348108 0.0319565826
3/1/11 348.51 1,325.83 -0.0133065315 -0.0010473019
4/1/11 350.13 1,363.61 0.0046483602 0.0284953576
5/1/11 347.83 1,345.2 -0.0065689887 -0.0135009277
6/1/11 335.67 1,320.64 -0.0349596067 -0.0182575082
7/1/11 390.48 1,292.28 0.1632853696 -0.0214744366
8/1/11 384.83 1,218.89 -0.014469371 -0.0567910979
9/1/11 381.32 1,131.42 -0.0091209105 -0.071762013
10/1/11 404.78 1,253.3 0.0615231302 0.1077230383
11/1/11 382.2 1,246.96 -0.0557833885 -0.0050586452
12/1/11 405 1,257.6 0.0596546311 0.0085327517
1/1/12 456.48 1,312.41 0.1271111111 0.0435830153
2/1/12 542.44 1,365.68 0.1883105503 0.0405894499
3/1/12 599.55 1,408.47 0.1052835337 0.0313323765
4/1/12 583.98 1,397.91 -0.0259694771 -0.0074974973
5/1/12 577.73 1,310.33 -0.0107024213 -0.0626506714
6/1/12 584 1,362.16 0.0108528205 0.0395549213
7/1/12 610.76 1,379.32 0.0458219178 0.012597639
8/1/12 665.24 1,406.58 0.0892003406 0.0197633617
9/1/12 667.1 1,440.67 0.0027959834 0.0242360904
10/1/12 595.32 1,412.16 -0.10760006 -0.0197894035
11/1/12 585.28 1,416.18 -0.0168648794 0.0028467029
12/1/12 532.17 1,426.19 -0.0907428923 0.0070683105
1/1/13 455.49 1,498.11 -0.1440892948 0.0504280636
2/1/13 441.4 1,514.68 -0.0309337197 0.011060603
3/1/13 442.66 1,569.19 0.0028545537 0.0359877994
4/1/13 442.78 1,597.57 0.0002710884 0.018085764
5/1/13 449.73 1,630.74 0.0156962826 0.0207627835
6/1/13 396.53 1,606.28 -0.1182931981 -0.0149993255
7/1/13 452.53 1,685.73 0.141225128 0.0494621112
8/1/13 487.22 1,632.97 0.0766579011 -0.0312980133
9/1/13 476.75 1,681.55 -0.0214892656 0.0297494749
10/1/13 522.7 1,756.54 0.0963817514 0.0445957599
11/1/13 556.07 1,805.81 0.0638415917 0.0280494609
12/1/13 561.02 1,848.36 0.008901757 0.0235628333
1/1/14 500.6 1,782.59 -0.1076966953 -0.0355828951
2/1/14 526.24 1,859.45 0.0512185378 0.0431170376
3/1/14 536.74 1,872.34 0.0199528732 0.0069321574
4/1/14 590.09 1,883.95 0.0993963558 0.0062007969
5/1/14 633 1,923.57 0.072717721 0.0210302821
6/1/14 92.93 1,960.23 -0.8531911532 0.0190583134
7/1/14 95.6 1,930.67 0.0287313031 -0.0150798631
8/1/14 102.5 2,003.37 0.0721757322 0.0376553217
9/1/14 100.75 1,972.29 -0.0170731707 -0.0155138591
10/1/14 108 2,018.05 0.0719602978 0.0232014562
11/1/14 118.93 2,067.56 0.1012037037 0.0245335844
12/1/14 110.38 2,058.9 -0.0718910283 -0.0041885121
1/1/15 117.16 1,994.99 0.061424171 -0.0310408471
2/1/15 128.46 2,104.5 0.0964493001 0.0548925057
3/1/15 129.09 2,117.39 0.0049042504 0.0061249703

&"Helvetica,Regular"&12&K000000 &P

HPQ

HPQ S&P 500 HPQ Return SP return Dividend o
1/1/05 19.59 1,181.27 0.16 Market Return 0.130879007 g 3%
2/1/05 20.8 1,203.6 0.0617662072 0.0189033836 Risk Premium 9% beta 1.1578674672
3/1/05 21.94 1,180.59 0.0548076923 -0.0191176471 Risk Free rs=rf+Beta(7%) 15%
4/1/05 20.47 1,156.85 -0.0670009116 -0.0201085898 4% P0=D0(1+g)/rs-g 1.4302346755
5/1/05 22.51 1,191.5 0.0996580362 0.0299520249
6/1/05 23.51 1,191.33 0.0444247001 -0.0001426773
7/1/05 24.62 1,234.18 0.0472139515 0.0359682036 Date HPQ Dividends
8/1/05 27.76 1,220.33 0.1275385865 -0.011222026 2014-12-08 0.16
9/1/05 29.2 1,228.81 0.0518731988 0.00694894 2014-09-08 0.16 SUMMARY OUTPUT
10/1/05 28.04 1,207.01 -0.0397260274 -0.017740741 2014-06-09 0.16
11/1/05 29.67 1,249.48 0.0581312411 0.0351861211 2014-03-10 0.145 Regression Statistics
12/1/05 28.63 1,248.29 -0.0350522413 -0.0009523962 2013-12-09 0.145 Multiple R 0.5778845104
1/1/06 31.18 1,280.08 0.0890674118 0.0254668386 2013-09-09 0.145 R Square 0.3339505074
2/1/06 32.81 1,280.66 0.0522771007 0.0004530967 2013-06-10 0.145 Adjusted R Square 0.3284000949
3/1/06 32.9 1,294.87 0.0027430661 0.0110958412 2013-03-11 0.132 Standard Error 0.0694595313
4/1/06 32.47 1,310.61 -0.0130699088 0.0121556604 2012-12-10 0.132 Observations 122
5/1/06 32.38 1,270.09 -0.0027717893 -0.0309169013 2012-09-10 0.132
6/1/06 31.68 1,270.2 -0.0216182829 0.000086608 2012-06-11 0.132 ANOVA
7/1/06 31.91 1,276.66 0.007260101 0.0050858133 2012-03-12 0.12 df SS MS F Significance F
8/1/06 36.56 1,303.82 0.1457223441 0.0212742625 2011-12-12 0.12 Regression 1 0.2902822953 0.2902822953 60.1667914015 0
9/1/06 36.69 1,335.85 0.0035557987 0.0245662745 2011-09-12 0.12 Residual 120 0.5789551782 0.0048246265
10/1/06 38.74 1,377.94 0.055873535 0.0315080286 2011-06-13 0.12 Total 121 0.8692374736
11/1/06 39.46 1,400.63 0.0185854414 0.0164666096 2011-03-14 0.08
12/1/06 41.19 1,418.3 0.0438418652 0.0126157515 2010-12-13 0.08 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
1/1/07 43.28 1,438.24 0.050740471 0.0140590848 2010-09-13 0.08 Intercept 0.0016842049 0.0063459228 0.2653995327 0.7911570858 -0.0108802804 0.0142486903 -0.0108802804 0.0142486903
2/1/07 39.35 1,406.82 -0.0908040665 -0.0218461453 2010-06-14 0.08 Market Return 1.1578674672 0.1492727129 7.7567255593 0 0.8623178879 1.4534170465 0.8623178879 1.4534170465
3/1/07 40.14 1,420.86 0.0200762389 0.0099799548 2010-03-15 0.08
4/1/07 42.14 1,482.37 0.0498256104 0.0432906831 2009-12-14 0.08
5/1/07 45.71 1,530.62 0.084717608 0.0325492286 2009-09-14 0.08
6/1/07 44.62 1,503.35 -0.0238459856 -0.0178163097 2009-06-08 0.08
7/1/07 46.03 1,455.27 0.0316001793 -0.0319819071 2009-03-09 0.08
8/1/07 49.35 1,473.99 0.0721268738 0.0128635923 2008-12-15 0.08
9/1/07 49.79 1,526.75 0.0089159068 0.0357940013 2008-09-08 0.08
10/1/07 51.68 1,549.38 0.0379594296 0.014822335 2008-06-09 0.08
11/1/07 51.16 1,481.14 -0.0100619195 -0.0440434238 2008-03-10 0.08
12/1/07 50.48 1,468.36 -0.0132916341 -0.0086284889 2007-12-10 0.08
1/1/08 43.72 1,378.55 -0.1339144216 -0.0611634749 2007-09-10 0.08
2/1/08 47.77 1,330.63 0.0926349497 -0.0347611621 2007-06-11 0.08
3/1/08 45.66 1,322.7 -0.0441699812 -0.0059595831 2007-03-12 0.08
4/1/08 46.35 1,385.59 0.0151116951 0.0475466848 2006-12-11 0.08
5/1/08 47.06 1,400.38 0.0153182309 0.0106741532 2006-09-11 0.08
6/1/08 44.21 1280 -0.060560986 -0.0859623816 2006-06-12 0.08
7/1/08 44.8 1,267.38 0.013345397 -0.009859375 2006-03-13 0.08
8/1/08 46.92 1,282.83 0.0473214286 0.0121905032 2005-12-12 0.08
9/1/08 46.24 1,166.36 -0.0144927536 -0.0907914533 2005-09-12 0.08
10/1/08 38.28 968.75 -0.1721453287 -0.1694245344 2005-06-13 0.08
11/1/08 35.28 896.24 -0.078369906 -0.0748490323 2005-03-14 0.08
12/1/08 36.29 903.25 0.0286281179 0.0078215657
1/1/09 34.75 825.88 -0.0424359328 -0.0856573485
2/1/09 29.03 735.09 -0.1646043165 -0.1099312249
3/1/09 32.06 797.87 0.1043747847 0.0854045083
4/1/09 35.98 872.81 0.1222707424 0.0939250755
5/1/09 34.35 919.14 -0.0453029461 0.0530814267
6/1/09 38.65 919.32 0.1251819505 0.0001958352
7/1/09 43.3 987.48 0.1203104787 0.074141757
8/1/09 44.89 1,020.62 0.0367205543 0.0335601734
9/1/09 47.21 1,057.08 0.0516818891 0.0357233838
10/1/09 47.46 1,036.19 0.0052954882 -0.0197619858
11/1/09 49.06 1,095.63 0.0337126001 0.057363997
12/1/09 51.51 1,115.1 0.0499388504 0.0177705977
1/1/10 47.07 1,073.87 -0.086196855 -0.0369742624
2/1/10 50.79 1,104.49 0.0790312301 0.0285136935
3/1/10 53.15 1,169.43 0.0464658397 0.0587963676
4/1/10 51.97 1,186.69 -0.022201317 0.0147593272
5/1/10 46.01 1,089.41 -0.114681547 -0.0819759162
6/1/10 43.28 1,030.71 -0.0593349272 -0.0538823767
7/1/10 46.04 1,101.6 0.0637707948 0.0687778328
8/1/10 38.45 1,049.33 -0.1648566464 -0.0474491649
9/1/10 42.07 1,141.2 0.0941482445 0.087551104
10/1/10 42.04 1,183.26 -0.0007130972 0.0368559411
11/1/10 41.93 1,180.55 -0.0026165557 -0.0022902828
12/1/10 42.1 1,257.64 0.0040543763 0.065300072
1/1/11 45.69 1,286.12 0.0852731591 0.0226455902
2/1/11 43.63 1,327.22 -0.0450864522 0.0319565826
3/1/11 40.97 1,325.83 -0.0609672244 -0.0010473019
4/1/11 40.37 1,363.61 -0.0146448621 0.0284953576
5/1/11 37.38 1,345.2 -0.0740648997 -0.0135009277
6/1/11 36.4 1,320.64 -0.0262172285 -0.0182575082
7/1/11 35.17 1,292.28 -0.0337912088 -0.0214744366
8/1/11 26.03 1,218.89 -0.25988058 -0.0567910979
9/1/11 22.45 1,131.42 -0.1375336151 -0.071762013
10/1/11 26.61 1,253.3 0.1853006682 0.1077230383
11/1/11 27.95 1,246.96 0.0503570086 -0.0050586452
12/1/11 25.76 1,257.6 -0.0783542039 0.0085327517
1/1/12 27.98 1,312.41 0.0861801242 0.0435830153
2/1/12 25.31 1,365.68 -0.0954253038 0.0405894499
3/1/12 23.83 1,408.47 -0.0584749111 0.0313323765
4/1/12 24.76 1,397.91 0.0390264373 -0.0074974973
5/1/12 22.68 1,310.33 -0.084006462 -0.0626506714
6/1/12 20.11 1,362.16 -0.1133156966 0.0395549213
7/1/12 18.24 1,379.32 -0.0929885629 0.012597639
8/1/12 16.88 1,406.58 -0.0745614035 0.0197633617
9/1/12 17.06 1,440.67 0.0106635071 0.0242360904
10/1/12 13.85 1,412.16 -0.1881594373 -0.0197894035
11/1/12 12.99 1,416.18 -0.0620938628 0.0028467029
12/1/12 14.25 1,426.19 0.0969976905 0.0070683105
1/1/13 16.51 1,498.11 0.1585964912 0.0504280636
2/1/13 20.14 1,514.68 0.2198667474 0.011060603
3/1/13 23.84 1,569.19 0.183714002 0.0359877994
4/1/13 20.6 1,597.57 -0.1359060403 0.018085764
5/1/13 24.42 1,630.74 0.1854368932 0.0207627835
6/1/13 24.8 1,606.28 0.0155610156 -0.0149993255
7/1/13 25.68 1,685.73 0.035483871 0.0494621112
8/1/13 22.34 1,632.97 -0.1300623053 -0.0312980133
9/1/13 20.99 1,681.55 -0.0604297225 0.0297494749
10/1/13 24.37 1,756.54 0.1610290615 0.0445957599
11/1/13 27.35 1,805.81 0.1222814936 0.0280494609
12/1/13 27.98 1,848.36 0.0230347349 0.0235628333
1/1/14 29 1,782.59 0.0364546104 -0.0355828951
2/1/14 29.88 1,859.45 0.0303448276 0.0431170376
3/1/14 32.36 1,872.34 0.0829986613 0.0069321574
4/1/14 33.06 1,883.95 0.021631644 0.0062007969
5/1/14 33.5 1,923.57 0.0133091349 0.0210302821
6/1/14 33.68 1,960.23 0.0053731343 0.0190583134
7/1/14 35.61 1,930.67 0.057304038 -0.0150798631
8/1/14 38 2,003.37 0.0671159787 0.0376553217
9/1/14 35.47 1,972.29 -0.0665789474 -0.0155138591
10/1/14 35.88 2,018.05 0.011559064 0.0232014562
11/1/14 39.06 2,067.56 0.0886287625 0.0245335844
12/1/14 40.13 2,058.9 0.0273937532 -0.0041885121
1/1/15 36.13 1,994.99 -0.0996760528 -0.0310408471
2/1/15 34.84 2,104.5 -0.0357044008 0.0548925057
3/1/15 34.57 2,117.39 -0.007749713 0.0061249703

&"Helvetica,Regular"&12&K000000 &P

MSFT

Microsoft S&P 500 MSFT Return SP return Dividend o
1/1/05 26.28 1,181.27 0.31 Market Return 0.130879007 g 11% Actual Annual growth
2/1/05 25.16 1,203.6 -0.0426179604 0.0189033836 Risk Premium 9% beta 0.9882380032
3/1/05 24.17 1,180.59 -0.0393481717 -0.0191176471 Risk Free rs=rf+Beta(7%) 13%
4/1/05 25.3 1,156.85 0.0467521721 -0.0201085898 4% P0=D0(1+g)/rs-g 15.1414295554
5/1/05 25.8 1,191.5 0.0197628458 0.0299520249
6/1/05 24.84 1,191.33 -0.0372093023 -0.0001426773
7/1/05 25.61 1,234.18 0.0309983897 0.0359682036 Date Microsoft Dividends
8/1/05 27.38 1,220.33 0.0691136275 -0.011222026 2015-02-17 0.31
9/1/05 25.73 1,228.81 -0.0602629657 0.00694894 2014-11-18 0.31 SUMMARY OUTPUT
10/1/05 25.7 1,207.01 -0.0011659541 -0.017740741 2014-08-19 0.28
11/1/05 27.68 1,249.48 0.0770428016 0.0351861211 2014-05-13 0.28 Regression Statistics
12/1/05 26.15 1,248.29 -0.0552745665 -0.0009523962 2014-02-18 0.28 Multiple R 0.6158326661
1/1/06 28.15 1,280.08 0.0764818356 0.0254668386 2013-11-19 0.28 R Square 0.3792498726
2/1/06 26.87 1,280.66 -0.0454706927 0.0004530967 2013-08-13 0.23 Adjusted R Square 0.3740769549
3/1/06 27.21 1,294.87 0.0126535169 0.0110958412 2013-05-14 0.23 Standard Error 0.0537054101
4/1/06 24.15 1,310.61 -0.1124586549 0.0121556604 2013-02-19 0.23 Observations 122
5/1/06 22.65 1,270.09 -0.0621118012 -0.0309169013 2012-11-13 0.23
6/1/06 23.3 1,270.2 0.0286975717 0.000086608 2012-08-14 0.2 ANOVA
7/1/06 24.06 1,276.66 0.0326180258 0.0050858133 2012-05-15 0.2 df SS MS F Significance F
8/1/06 25.7 1,303.82 0.068162926 0.0212742625 2012-02-14 0.2 Regression 1 0.2114588894 0.2114588894 73.3144991912 0
9/1/06 27.35 1,335.85 0.0642023346 0.0245662745 2011-11-15 0.2 Residual 120 0.346112529 0.0028842711
10/1/06 28.71 1,377.94 0.049725777 0.0315080286 2011-08-16 0.16 Total 121 0.5575714184
11/1/06 29.36 1,400.63 0.0226401951 0.0164666096 2011-05-17 0.16
12/1/06 29.86 1,418.3 0.0170299728 0.0126157515 2011-02-15 0.16 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
1/1/07 30.86 1,438.24 0.0334896182 0.0140590848 2010-11-16 0.16 Intercept 0.0008579513 0.0049066036 0.1748564444 0.8614871173 -0.0088567823 0.0105726848 -0.0088567823 0.0105726848
2/1/07 28.17 1,406.82 -0.0871678548 -0.0218461453 2010-08-17 0.13 Market Return 0.9882380032 0.1154161584 8.5623886382 0 0.7597220448 1.2167539616 0.7597220448 1.2167539616
3/1/07 27.87 1,420.86 -0.0106496273 0.0099799548 2010-05-18 0.13
4/1/07 29.94 1,482.37 0.0742734123 0.0432906831 2010-02-16 0.13
5/1/07 30.69 1,530.62 0.0250501002 0.0325492286 2009-11-17 0.13
6/1/07 29.47 1,503.35 -0.0397523623 -0.0178163097 2009-08-18 0.13
7/1/07 28.99 1,455.27 -0.0162877503 -0.0319819071 2009-05-19 0.13
8/1/07 28.73 1,473.99 -0.0089686099 0.0128635923 2009-02-17 0.13
9/1/07 29.46 1,526.75 0.0254089802 0.0357940013 2008-11-18 0.13
10/1/07 36.81 1,549.38 0.249490835 0.014822335 2008-08-19 0.11
11/1/07 33.6 1,481.14 -0.087204564 -0.0440434238 2008-05-13 0.11
12/1/07 35.6 1,468.36 0.0595238095 -0.0086284889 2008-02-19 0.11
1/1/08 32.6 1,378.55 -0.0842696629 -0.0611634749 2007-11-13 0.11
2/1/08 27.2 1,330.63 -0.1656441718 -0.0347611621 2007-08-14 0.1
3/1/08 28.38 1,322.7 0.0433823529 -0.0059595831 2007-05-15 0.1
4/1/08 28.52 1,385.59 0.0049330514 0.0475466848 2007-02-13 0.1
5/1/08 28.32 1,400.38 -0.0070126227 0.0106741532 2006-11-14 0.1
6/1/08 27.51 1280 -0.0286016949 -0.0859623816 2006-08-15 0.09
7/1/08 25.72 1,267.38 -0.0650672483 -0.009859375 2006-05-15 0.09
8/1/08 27.29 1,282.83 0.0610419907 0.0121905032 2006-02-15 0.09
9/1/08 26.69 1,166.36 -0.0219860755 -0.0907914533 2005-11-15 0.08
10/1/08 22.33 968.75 -0.1633570626 -0.1694245344 2005-08-15 0.08
11/1/08 20.22 896.24 -0.0944917152 -0.0748490323 2005-05-16 0.08
12/1/08 19.44 903.25 -0.0385756677 0.0078215657 2005-02-15 0.08
1/1/09 17.1 825.88 -0.1203703704 -0.0856573485
2/1/09 16.15 735.09 -0.0555555556 -0.1099312249
3/1/09 18.37 797.87 0.1374613003 0.0854045083
4/1/09 20.26 872.81 0.1028851388 0.0939250755
5/1/09 20.89 919.14 0.0310957552 0.0530814267
6/1/09 23.77 919.32 0.1378650072 0.0001958352
7/1/09 23.52 987.48 -0.010517459 0.074141757
8/1/09 24.65 1,020.62 0.0480442177 0.0335601734
9/1/09 25.72 1,057.08 0.0434077079 0.0357233838
10/1/09 27.73 1,036.19 0.0781493002 -0.0197619858
11/1/09 29.41 1,095.63 0.0605842048 0.057363997
12/1/09 30.48 1,115.1 0.0363821829 0.0177705977
1/1/10 28.18 1,073.87 -0.0754593176 -0.0369742624
2/1/10 28.67 1,104.49 0.0173882186 0.0285136935
3/1/10 29.29 1,169.43 0.0216253924 0.0587963676
4/1/10 30.54 1,186.69 0.0426766815 0.0147593272
5/1/10 25.8 1,089.41 -0.1552062868 -0.0819759162
6/1/10 23.01 1,030.71 -0.1081395349 -0.0538823767
7/1/10 25.81 1,101.6 0.1216862234 0.0687778328
8/1/10 23.47 1,049.33 -0.0906625339 -0.0474491649
9/1/10 24.49 1,141.2 0.0434597358 0.087551104
10/1/10 26.67 1,183.26 0.0890159249 0.0368559411
11/1/10 25.26 1,180.55 -0.0528683915 -0.0022902828
12/1/10 27.91 1,257.64 0.104908947 0.065300072
1/1/11 27.73 1,286.12 -0.0064493013 0.0226455902
2/1/11 26.58 1,327.22 -0.0414713307 0.0319565826
3/1/11 25.39 1,325.83 -0.0447705041 -0.0010473019
4/1/11 25.92 1,363.61 0.02087436 0.0284953576
5/1/11 25.01 1,345.2 -0.0351080247 -0.0135009277
6/1/11 26 1,320.64 0.0395841663 -0.0182575082
7/1/11 27.4 1,292.28 0.0538461538 -0.0214744366
8/1/11 26.6 1,218.89 -0.0291970803 -0.0567910979
9/1/11 24.89 1,131.42 -0.0642857143 -0.071762013
10/1/11 26.63 1,253.3 0.0699075934 0.1077230383
11/1/11 25.58 1,246.96 -0.0394292152 -0.0050586452
12/1/11 25.96 1,257.6 0.0148553557 0.0085327517
1/1/12 29.53 1,312.41 0.1375192604 0.0435830153
2/1/12 31.74 1,365.68 0.0748391466 0.0405894499
3/1/12 32.26 1,408.47 0.0163831128 0.0313323765
4/1/12 32.02 1,397.91 -0.0074395536 -0.0074974973
5/1/12 29.19 1,310.33 -0.0883822611 -0.0626506714
6/1/12 30.59 1,362.16 0.0479616307 0.0395549213
7/1/12 29.47 1,379.32 -0.0366132723 0.012597639
8/1/12 30.82 1,406.58 0.0458092976 0.0197633617
9/1/12 29.76 1,440.67 -0.0343932511 0.0242360904
10/1/12 28.54 1,412.16 -0.0409946237 -0.0197894035
11/1/12 26.62 1,416.18 -0.0672740014 0.0028467029
12/1/12 26.71 1,426.19 0.0033809166 0.0070683105
1/1/13 27.45 1,498.11 0.0277049794 0.0504280636
2/1/13 27.8 1,514.68 0.0127504554 0.011060603
3/1/13 28.61 1,569.19 0.0291366906 0.0359877994
4/1/13 33.1 1,597.57 0.1569381335 0.018085764
5/1/13 34.9 1,630.74 0.0543806647 0.0207627835
6/1/13 34.54 1,606.28 -0.0103151862 -0.0149993255
7/1/13 31.84 1,685.73 -0.0781702374 0.0494621112
8/1/13 33.4 1,632.97 0.0489949749 -0.0312980133
9/1/13 33.28 1,681.55 -0.0035928144 0.0297494749
10/1/13 35.41 1,756.54 0.0640024038 0.0445957599
11/1/13 38.13 1,805.81 0.0768144592 0.0280494609
12/1/13 37.41 1,848.36 -0.0188827695 0.0235628333
1/1/14 37.84 1,782.59 0.0114942529 -0.0355828951
2/1/14 38.31 1,859.45 0.0124207188 0.0431170376
3/1/14 40.99 1,872.34 0.0699556252 0.0069321574
4/1/14 40.4 1,883.95 -0.0143937546 0.0062007969
5/1/14 40.94 1,923.57 0.0133663366 0.0210302821
6/1/14 41.7 1,960.23 0.0185637518 0.0190583134
7/1/14 43.16 1,930.67 0.0350119904 -0.0150798631
8/1/14 45.43 2,003.37 0.0525949954 0.0376553217
9/1/14 46.36 1,972.29 0.0204710544 -0.0155138591
10/1/14 46.95 2,018.05 0.0127264884 0.0232014562
11/1/14 47.81 2,067.56 0.0183173589 0.0245335844
12/1/14 46.45 2,058.9 -0.0284459318 -0.0041885121
1/1/15 40.4 1,994.99 -0.130247578 -0.0310408471
2/1/15 43.85 2,104.5 0.0853960396 0.0548925057
3/1/15 43.88 2,117.39 0.0006841505 0.0061249703

&"Helvetica,Regular"&12&K000000 &P