I need paraphrasing and changes in the layout plus changing one or two of the references

profileaalhassu
part_three_excel.xlsx
Home>Business & Finance homework help>I need paraphrasing and changes in the layout plus changing one or two of the references

Verizon

Date Verizon SP500 Verizon Returns SP returns Date Dividends
12/1/14 46.78 2058.9 -0.0753113263 -0.0041885121 10/8/14 0.55 0.55
11/3/14 50.59 2067.56 0.0067661692 0.0245335844 7/8/14 0.53 Market Price 49.2 g 1%
10/1/14 50.25 2018.05 0.0052010402 0.0232014562 4/8/14 0.53 Beta 0.36
9/2/14 49.99 1972.29 0.0034122842 -0.0155138591 1/8/14 0.53
8/1/14 49.82 2003.37 -0.0119000397 0.0376553217 10/8/13 0.53 rs=rf+Beta(7%) 4%
7/1/14 50.42 1930.67 0.0304516656 -0.0150798631 7/8/13 0.515
6/2/14 48.93 1960.23 -0.0206164932 0.0190583134 4/8/13 0.515 P0=D0(1+g)/rs-g 18.5166666667
5/1/14 49.96 1923.57 0.0691204793 0.0210302821 1/8/13 0.515
4/1/14 46.73 1883.95 -0.0176581879 0.0062007969 10/5/12 0.515 Beta smaller than one less risky
3/3/14 47.57 1872.34 -0.0002101723 0.0069321574 7/6/12 0.5
2/3/14 47.58 1859.45 -0.0091628488 0.0431170376 4/5/12 0.5 SUMMARY OUTPUT
1/2/14 48.02 1782.59 -0.0227920228 -0.0355828951 1/6/12 0.5
12/2/13 49.14 1848.36 -0.0096735187 0.0235628333 10/5/11 0.5 Regression Statistics
11/1/13 49.62 1805.81 -0.0176202732 0.0280494609 7/6/11 0.488 Multiple R 0.425542069
10/1/13 50.51 1756.54 0.0822798372 0.0445957599 4/6/11 0.488 R Square 0.1810860525
9/3/13 46.67 1681.55 -0.0149852258 0.0297494749 1/6/11 0.488 Adjusted R Square 0.174086788
8/1/13 47.38 1632.97 -0.0424413905 -0.0312980133 10/6/10 0.488 Standard Error 0.0385888752
7/1/13 49.48 1685.73 -0.01708383 0.0494621112 7/7/10 0.475 Observations 119
6/3/13 50.34 1606.28 0.0383663366 -0.0149993255 4/7/10 0.4455
5/1/13 48.48 1630.74 -0.1007234279 0.0207627835 1/6/10 0.4455 ANOVA
4/1/13 53.91 1597.57 0.0968463886 0.018085764 10/7/09 0.4455 df SS MS F Significance F
3/1/13 49.15 1569.19 0.0563077584 0.0359877994 7/8/09 0.43143 Regression 1 0.0385262585 0.0385262585 25.8721544665 0.0000014035
2/1/13 46.53 1514.68 0.0669571199 0.011060603 4/7/09 0.43143 Residual 117 0.1742248505 0.0014891013
1/2/13 43.61 1498.11 0.0078576381 0.0504280636 1/7/09 0.43143 Total 118 0.212751109
12/3/12 43.27 1426.19 -0.0192656392 0.0070683105 10/8/08 0.43143
11/1/12 44.12 1416.18 -0.0116487455 0.0028467029 7/8/08 0.40329 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
10/1/12 44.64 1412.16 -0.0204081633 -0.0197894035 4/8/08 0.40329 Intercept 0.0043139763 0.003546383 1.2164440178 0.2262641597 -0.0027094493 0.011337402 -0.0027094493 0.011337402
9/4/12 45.57 1440.67 0.0612482534 0.0242360904 4/1/08 0 Verizon Returns 0.36 0.0713161135 5.086467779 0.0000014035 0.2215092877 0.5039849391 0.2215092877 0.5039849391
8/1/12 42.94 1406.58 -0.0487372619 0.0197633617 1/8/08 0.40143
7/2/12 45.14 1379.32 0.0157515752 0.012597639 10/5/07 0.40143
6/1/12 44.44 1362.16 0.0672430355 0.0395549213 7/6/07 0.37809
5/1/12 41.64 1310.33 0.0312035661 -0.0626506714 4/5/07 0.37809
4/2/12 40.38 1397.91 0.0562385561 -0.0074974973 1/8/07 0.37809
3/1/12 38.23 1408.47 0.0031487798 0.0313323765 11/20/06 0
2/1/12 38.11 1365.68 0.0119490175 0.0405894499 10/5/06 0.36423
1/3/12 37.66 1312.41 -0.0613160518 0.0435830153 7/6/06 0.36423
12/1/11 40.12 1257.6 0.0633448184 0.0085327517 4/6/06 0.36423
11/1/11 37.73 1246.96 0.0202812331 -0.0050586452 1/6/06 0.36423
10/3/11 36.98 1253.3 0.0048913043 0.1077230383 10/5/05 0.36423
9/1/11 36.8 1131.42 0.0174177495 -0.071762013 7/6/05 0.36423
8/1/11 36.17 1218.89 0.0249362426 -0.0567910979 4/6/05 0.36423
7/1/11 35.29 1292.28 -0.0521085146 -0.0214744366 1/6/05 0.34624 0.35
6/1/11 37.23 1320.64 0.0081234768 -0.0182575082
5/2/11 36.93 1345.2 -0.0224986765 -0.0135009277
4/1/11 37.78 1363.61 -0.0197197717 0.0284953576
3/1/11 38.54 1325.83 0.0438786566 -0.0010473019
2/1/11 36.92 1327.22 0.0364963504 0.0319565826
1/3/11 35.62 1286.12 -0.0044717719 0.0226455902
12/1/10 35.78 1257.64 0.1177756951 0.065300072
11/1/10 32.01 1180.55 -0.0144704433 -0.0022902828
10/1/10 32.48 1183.26 -0.0033752685 0.0368559411
9/1/10 32.59 1141.2 0.1036234338 0.087551104
8/2/10 29.53 1049.33 0.0161734343 -0.0474491649
7/1/10 29.06 1101.6 0.0371163455 0.0687778328
6/1/10 28.02 1030.71 0.0181686047 -0.0538823767
5/3/10 27.52 1089.41 -0.0477508651 -0.0819759162
4/1/10 28.9 1186.69 -0.0683430045 0.0147593272
3/1/10 31.02 1169.43 0.072243346 0.0587963676
2/1/10 28.93 1104.49 -0.0166553365 0.0285136935
1/4/10 29.42 1073.87 -0.1119830969 -0.0369742624
12/1/09 33.13 1115.1 0.0530832804 0.0177705977
11/2/09 31.46 1095.63 0.063197026 0.057363997
10/1/09 29.59 1036.19 -0.0224644863 -0.0197619858
9/1/09 30.27 1057.08 -0.024806701 0.0357233838
8/3/09 31.04 1020.62 -0.0321172435 0.0335601734
7/1/09 32.07 987.48 0.0436055971 0.074141757
6/1/09 30.73 919.32 0.0502392344 0.0001958352
5/1/09 29.26 919.14 -0.0355965722 0.0530814267
4/1/09 30.34 872.81 0.0046357616 0.0939250755
3/2/09 30.2 797.87 0.0585348756 0.0854045083
2/2/09 28.53 735.09 -0.0448610646 -0.1099312249
1/2/09 29.87 825.88 -0.118879056 -0.0856573485
12/1/08 33.9 903.25 0.0382848392 0.0078215657
11/3/08 32.65 896.24 0.100438153 -0.0748490323
10/1/08 29.67 968.75 -0.0754129012 -0.1694245344
9/2/08 32.09 1166.36 -0.0862756264 -0.0907914533
8/1/08 35.12 1282.83 0.0317273796 0.0121905032
7/1/08 34.04 1267.38 -0.0384180791 -0.009859375
6/2/08 35.4 1280 -0.0798024435 -0.0859623816
5/1/08 38.47 1400.38 -0.0002598753 0.0106741532
4/1/08 38.48 1385.59 0.0556927298 0.0475466848
3/3/08 36.45 1322.7 0.0035792952 -0.0059595831
2/1/08 36.32 1330.63 -0.0646407417 -0.0347611621
1/2/08 38.83 1378.55 -0.1112382696 -0.0611634749
12/3/07 43.69 1468.36 0.0111085397 -0.0086284889
11/1/07 43.21 1481.14 -0.0620794443 -0.0440434238
10/1/07 46.07 1549.38 0.0404245709 0.014822335
9/4/07 44.28 1526.75 0.0573065903 0.0357940013
8/1/07 41.88 1473.99 -0.0173627405 0.0128635923
7/2/07 42.62 1455.27 0.0352198203 -0.0319819071
6/1/07 41.17 1503.35 -0.0542154836 -0.0178163097
5/1/07 43.53 1530.62 0.1401257203 0.0325492286
4/2/07 38.18 1482.37 0.0068565401 0.0432906831
3/1/07 37.92 1420.86 0.0139037433 0.0099799548
2/1/07 37.4 1406.82 -0.0290758048 -0.0218461453
1/3/07 38.52 1438.24 0.0343716434 0.0140590848
12/1/06 37.24 1418.3 0.0658271322 0.0126157515
11/1/06 34.94 1400.63 -0.0556756757 0.0164666096
10/2/06 37 1377.94 -0.003501212 0.0315080286
9/1/06 37.13 1335.85 0.0554292211 0.0245662745
8/1/06 35.18 1303.82 0.0402128918 0.0212742625
7/3/06 33.82 1276.66 0.0098536877 0.0050858133
6/1/06 33.49 1270.2 0.0730535085 0.000086608
5/1/06 31.21 1270.09 -0.0551014229 -0.0309169013
4/3/06 33.03 1310.61 -0.0302407516 0.0121556604
3/1/06 34.06 1294.87 0.0106824926 0.0110958412
2/1/06 33.7 1280.66 0.0644346178 0.0004530967
1/3/06 31.66 1280.08 0.0511288181 0.0254668386
12/1/05 30.12 1248.29 -0.0581613508 -0.0009523962
11/1/05 31.98 1249.48 0.0149158997 0.0351861211
10/3/05 31.51 1207.01 -0.0360966656 -0.017740741
9/1/05 32.69 1228.81 -0.0006114338 0.00694894
8/1/05 32.71 1220.33 -0.0444054923 -0.011222026
7/1/05 34.23 1234.18 -0.0092619392 0.0359682036
6/1/05 34.55 1191.33 -0.0234595817 -0.0001426773
5/2/05 35.38 1191.5 -0.0117318436 0.0299520249
4/1/05 35.8 1156.85 0.0084507042 -0.0201085898
3/1/05 35.5 1180.59 -0.0130664443 -0.0191176471
2/1/05 35.97 1203.6 0.0106771565 0.0189033836
1/3/05 35.59 1181.27 ERROR:#DIV/0! ERROR:#DIV/0!

Motorola

Date Motorola SP500 Motorola Return SP Return Date Dividends
12/1/14 67.08 2058.9 0.0206938527 -0.0041885121 12/11/14 0.34 0.34
11/3/14 65.72 2067.56 0.0189147287 0.0245335844 9/11/14 0.34 Market Price 61.61 g -2%
10/1/14 64.5 2018.05 0.0192793932 0.0232014562 6/11/14 0.31 Beta 0.03
9/2/14 63.28 1972.29 0.0653198653 -0.0155138591 3/12/14 0.31
8/1/14 59.4 2003.37 -0.0672110553 0.0376553217 12/11/13 0.31 rs=rf+Beta(7%) 2%
7/1/14 63.68 1930.67 -0.0434129488 -0.0150798631 9/11/13 0.31
6/2/14 66.57 1960.23 -0.0126075349 0.0190583134 6/12/13 0.26 P0=D0(1+g)/rs-g 8.33
5/1/14 67.42 1923.57 0.0603963511 0.0210302821 3/13/13 0.26
4/1/14 63.58 1883.95 -0.0110437082 0.0062007969 12/12/12 0.26 Beta smaller than one less risky
3/3/14 64.29 1872.34 -0.0288519637 0.0069321574 9/12/12 0.26
2/3/14 66.2 1859.45 0.0376175549 0.0431170376 6/13/12 0.22 SUMMARY OUTPUT
1/2/14 63.8 1782.59 -0.0548148148 -0.0355828951 3/13/12 0.22
12/2/13 67.5 1848.36 0.0245901639 0.0235628333 12/13/11 0.22 Regression Statistics
11/1/13 65.88 1805.81 0.0537428023 0.0280494609 9/13/11 0.22 Multiple R 0.2335000499
10/1/13 62.52 1756.54 0.0528797575 0.0445957599 1/4/11 0 R Square 0.0545222733
9/3/13 59.38 1681.55 0.0601678272 0.0297494749 12/11/08 0.20213 Adjusted R Square 0.0464412671
8/1/13 56.01 1632.97 0.0215210651 -0.0312980133 9/11/08 0.20213 Standard Error 0.0414637557
7/1/13 54.83 1685.73 -0.0502338472 0.0494621112 6/12/08 0.20213 Observations 119
6/3/13 57.73 1606.28 -0.003968254 -0.0149993255 3/12/08 0.20213
5/1/13 57.96 1630.74 0.0132867133 0.0207627835 12/12/07 0.20213 ANOVA
4/1/13 57.2 1597.57 -0.106668749 0.018085764 9/12/07 0.20213 df SS MS F Significance F
3/1/13 64.03 1569.19 0.0292557467 0.0359877994 6/13/07 0.20213 Regression 1 0.0115996741 0.0115996741 6.7469658972 0.0105965201
2/1/13 62.21 1514.68 0.0654221613 0.011060603 3/13/07 0.20213 Residual 117 0.2011514349 0.001719243
1/2/13 58.39 1498.11 0.048670977 0.0504280636 12/13/06 0.20213 Total 118 0.212751109
12/3/12 55.68 1426.19 0.0225895317 0.0070683105 9/13/06 0.20213
11/1/12 54.45 1416.18 0.0535990712 0.0028467029 6/13/06 0.20213 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
10/1/12 51.68 1412.16 0.0223541048 -0.0197894035 3/13/06 0.1617 Intercept 0.0045872602 0.0038207043 1.2006320995 0.2323191108 -0.0029794444 0.0121539648 -0.0029794444 0.0121539648
9/4/12 50.55 1440.67 0.0606378514 0.0242360904 12/13/05 0.1617 Motorola Return 0.03 0.0121669722 2.5974922324 0.0105965201 0.0075075649 0.0556996668 0.0075075649 0.0556996668
8/1/12 47.66 1406.58 -0.0140670252 0.0197633617 9/13/05 0.1617
7/2/12 48.34 1379.32 0.0047807109 0.012597639 6/13/05 0.1617
6/1/12 48.11 1362.16 0.0006239601 0.0395549213 3/11/05 0.1617 0.16
5/1/12 48.08 1310.33 -0.0578091319 -0.0626506714
4/2/12 51.03 1397.91 0.0039346842 -0.0074974973
3/1/12 50.83 1408.47 0.0206827309 0.0313323765
2/1/12 49.8 1365.68 0.0730446025 0.0405894499
1/3/12 46.41 1312.41 0.0025923526 0.0435830153
12/1/11 46.29 1257.6 -0.0081422756 0.0085327517
11/1/11 46.67 1246.96 -0.0051161799 -0.0050586452
10/3/11 46.91 1253.3 0.1195704057 0.1077230383
9/1/11 41.9 1131.42 -0.0045141364 -0.071762013
8/1/11 42.09 1218.89 -0.0623746937 -0.0567910979
7/1/11 44.89 1292.28 -0.0249782798 -0.0214744366
6/1/11 46.04 1320.64 -0.0382285356 -0.0182575082
5/2/11 47.87 1345.2 0.0433740192 -0.0135009277
4/1/11 45.88 1363.61 0.026627881 0.0284953576
3/1/11 44.69 1325.83 0.156573499 -0.0010473019
2/1/11 38.64 1327.22 -0.0033531081 0.0319565826
1/3/11 38.77 1286.12 3.2745314223 0.0226455902
12/1/10 9.07 1257.64 0.184073107 0.065300072
11/1/10 7.66 1180.55 -0.0612745098 -0.0022902828
10/1/10 8.16 1183.26 -0.0433763189 0.0368559411
9/1/10 8.53 1141.2 0.1343085106 0.087551104
8/2/10 7.52 1049.33 0.0040053405 -0.0474491649
7/1/10 7.49 1101.6 0.1487730061 0.0687778328
6/1/10 6.52 1030.71 -0.0481751825 -0.0538823767
5/3/10 6.85 1089.41 -0.0311173975 -0.0819759162
4/1/10 7.07 1186.69 0.0071225071 0.0147593272
3/1/10 7.02 1169.43 0.0384615385 0.0587963676
2/1/10 6.76 1104.49 0.0991869919 0.0285136935
1/4/10 6.15 1073.87 -0.2074742268 -0.0369742624
12/1/09 7.76 1115.1 -0.0312109863 0.0177705977
11/2/09 8.01 1095.63 -0.065344224 0.057363997
10/1/09 8.57 1036.19 -0.0023282887 -0.0197619858
9/1/09 8.59 1057.08 0.1963788301 0.0357233838
8/3/09 7.18 1020.62 0.0027932961 0.0335601734
7/1/09 7.16 987.48 0.0799396682 0.074141757
6/1/09 6.63 919.32 0.0940594059 0.0001958352
5/1/09 6.06 919.14 0.095840868 0.0530814267
4/1/09 5.53 872.81 0.3073286052 0.0939250755
3/2/09 4.23 797.87 0.2017045455 0.0854045083
2/2/09 3.52 735.09 -0.2054176072 -0.1099312249
1/2/09 4.43 825.88 0 -0.0856573485
12/1/08 4.43 903.25 0.0278422274 0.0078215657
11/3/08 4.31 896.24 -0.1973929236 -0.0748490323
10/1/08 5.37 968.75 -0.2478991597 -0.1694245344
9/2/08 7.14 1166.36 -0.2420382166 -0.0907914533
8/1/08 9.42 1282.83 0.0902777778 0.0121905032
7/1/08 8.64 1267.38 0.1771117166 -0.009859375
6/2/08 7.34 1280 -0.2132904609 -0.0859623816
5/1/08 9.33 1400.38 -0.063253012 0.0106741532
4/1/08 9.96 1385.59 0.0709677419 0.0475466848
3/3/08 9.3 1322.7 -0.0672016048 -0.0059595831
2/1/08 9.97 1330.63 -0.1330434783 -0.0347611621
1/2/08 11.5 1378.55 -0.283042394 -0.0611634749
12/3/07 16.04 1468.36 0.0043832185 -0.0086284889
11/1/07 15.97 1481.14 -0.1500798297 -0.0440434238
10/1/07 18.79 1549.38 0.0140313006 0.014822335
9/4/07 18.53 1526.75 0.0932153392 0.0357940013
8/1/07 16.95 1473.99 -0.0023543261 0.0128635923
7/2/07 16.99 1455.27 -0.0401129944 -0.0319819071
6/1/07 17.7 1503.35 -0.026937878 -0.0178163097
5/1/07 18.19 1530.62 0.0496249279 0.0325492286
4/2/07 17.33 1482.37 -0.0192416525 0.0432906831
3/1/07 17.67 1420.86 -0.0458963283 0.0099799548
2/1/07 18.52 1406.82 -0.0670025189 -0.0218461453
1/3/07 19.85 1438.24 -0.0345330739 0.0140590848
12/1/06 20.56 1418.3 -0.0726206585 0.0126157515
11/1/06 22.17 1400.63 -0.0385949696 0.0164666096
10/2/06 23.06 1377.94 -0.0776 0.0315080286
9/1/06 25 1335.85 0.0692899914 0.0245662745
8/1/06 23.38 1303.82 0.0272407733 0.0212742625
7/3/06 22.76 1276.66 0.129528536 0.0050858133
6/1/06 20.15 1270.2 -0.0445708867 0.000086608
5/1/06 21.09 1270.09 -0.0121779859 -0.0309169013
4/3/06 21.35 1310.61 -0.068092536 0.0121556604
3/1/06 22.91 1294.87 0.0705607477 0.0110958412
2/1/06 21.4 1280.66 -0.0576838397 0.0004530967
1/3/06 22.71 1280.08 0.005312085 0.0254668386
12/1/05 22.59 1248.29 -0.0622665006 -0.0009523962
11/1/05 24.09 1249.48 0.0870938628 0.0351861211
10/3/05 22.16 1207.01 0.005901044 -0.017740741
9/1/05 22.03 1228.81 0.0068555759 0.00694894
8/1/05 21.88 1220.33 0.0330500472 -0.011222026
7/1/05 21.18 1234.18 0.1599123768 0.0359682036
6/1/05 18.26 1191.33 0.0512377663 -0.0001426773
5/2/05 17.37 1191.5 0.1323337679 0.0299520249
4/1/05 15.34 1156.85 0.0247160989 -0.0201085898
3/1/05 14.97 1180.59 -0.0440613027 -0.0191176471
2/1/05 15.66 1203.6 -0.0050825921 0.0189033836
1/3/05 15.74 1181.27 ERROR:#DIV/0! ERROR:#DIV/0!

AT&T

Date AT&T SP500 AT&T Return SP Return Date Dividends
12/1/14 33.59 2058.9 -0.0505935557 -0.0041885121 10/8/14 0.46 0.46 Marketin Price 32.75 g -1%
11/3/14 35.38 2067.56 0.0154994259 0.0245335844 7/8/14 0.46 beta 0.41
10/1/14 34.84 2018.05 -0.0113507378 0.0232014562 4/8/14 0.46 rs=rf+Beta(7%) 5%
9/2/14 35.24 1972.29 0.0080091533 -0.0155138591 1/8/14 0.46 P0=D0(1+g)/rs-g 7.59
8/1/14 34.96 2003.37 -0.0177016016 0.0376553217 10/8/13 0.45
7/1/14 35.59 1930.67 0.0065045249 -0.0150798631 7/8/13 0.45
6/2/14 35.36 1960.23 -0.0031012123 0.0190583134 4/8/13 0.45
5/1/14 35.47 1923.57 -0.006442577 0.0210302821 1/8/13 0.45
4/1/14 35.7 1883.95 0.0179640719 0.0062007969 10/5/12 0.44
3/3/14 35.07 1872.34 0.098340119 0.0069321574 7/6/12 0.44 SUMMARY OUTPUT
2/3/14 31.93 1859.45 -0.0417166867 0.0431170376 4/5/12 0.44
1/2/14 33.32 1782.59 -0.0523321957 -0.0355828951 1/6/12 0.44 Regression Statistics
12/2/13 35.16 1848.36 -0.0014200511 0.0235628333 10/5/11 0.43 Multiple R 0.4806914199
11/1/13 35.21 1805.81 -0.0273480663 0.0280494609 7/6/11 0.43 R Square 0.2310642412
10/1/13 36.2 1756.54 0.0703725606 0.0445957599 4/6/11 0.43 Adjusted R Square 0.2244921407
9/3/13 33.82 1681.55 -0.0002955956 0.0297494749 1/6/11 0.43 Standard Error 0.0373928024
8/1/13 33.83 1632.97 -0.0408278991 -0.0312980133 10/6/10 0.42 Observations 119
7/1/13 35.27 1685.73 -0.0036723164 0.0494621112 7/7/10 0.42
6/3/13 35.4 1606.28 0.0117176336 -0.0149993255 4/7/10 0.42 ANOVA
5/1/13 34.99 1630.74 -0.0659369995 0.0207627835 1/6/10 0.42 df SS MS F Significance F
4/1/13 37.46 1597.57 0.0209866449 0.018085764 10/7/09 0.41 Regression 1 0.0491591736 0.0491591736 35.1583547903 0.0000000315
3/1/13 36.69 1569.19 0.0217209691 0.0359877994 7/8/09 0.41 Residual 117 0.1635919355 0.0013982217
2/1/13 35.91 1514.68 0.032193159 0.011060603 4/7/09 0.41 Total 118 0.212751109
1/2/13 34.79 1498.11 0.0320379709 0.0504280636 1/7/09 0.41
12/3/12 33.71 1426.19 -0.0123058892 0.0070683105 10/8/08 0.4 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
11/1/12 34.13 1416.18 -0.0132986412 0.0028467029 7/8/08 0.4 Intercept 0.0038810647 0.0034399511 1.1282325436 0.2615299384 -0.0029315781 0.0106937075 -0.0029315781 0.0106937075
10/1/12 34.59 1412.16 -0.0824933687 -0.0197894035 4/8/08 0.4 AT&T Return 0.41 0.0696255859 5.9294481017 0.0000000315 0.2749514736 0.5507311222 0.2749514736 0.5507311222
9/4/12 37.7 1440.67 0.028930131 0.0242360904 1/8/08 0.4
8/1/12 36.64 1406.58 -0.0337552743 0.0197633617 10/5/07 0.355
7/2/12 37.92 1379.32 0.063376332 0.012597639 7/6/07 0.355
6/1/12 35.66 1362.16 0.0436055019 0.0395549213 4/5/07 0.355
5/1/12 34.17 1310.33 0.0382862352 -0.0626506714 1/8/07 0.355
4/2/12 32.91 1397.91 0.0537944284 -0.0074974973 10/5/06 0.333
3/1/12 31.23 1408.47 0.0209218699 0.0313323765 7/6/06 0.333
2/1/12 30.59 1365.68 0.0401224073 0.0405894499 4/6/06 0.333
1/3/12 29.41 1312.41 -0.0274470899 0.0435830153 1/6/06 0.333
12/1/11 30.24 1257.6 0.0434782609 0.0085327517 10/5/05 0.323
11/1/11 28.98 1246.96 -0.011258956 -0.0050586452 7/6/05 0.323
10/3/11 29.31 1253.3 0.0276998597 0.1077230383 4/6/05 0.323
9/1/11 28.52 1131.42 0.0014044944 -0.071762013 1/6/05 0.323 0.323
8/1/11 28.48 1218.89 -0.026657553 -0.0567910979
7/1/11 29.26 1292.28 -0.0684495384 -0.0214744366
6/1/11 31.41 1320.64 -0.0047528517 -0.0182575082
5/2/11 31.56 1345.2 0.0141388175 -0.0135009277
4/1/11 31.12 1363.61 0.0166612218 0.0284953576
3/1/11 30.61 1325.83 0.0785764623 -0.0010473019
2/1/11 28.38 1327.22 0.03125 0.0319565826
1/3/11 27.52 1286.12 -0.063308373 0.0226455902
12/1/10 29.38 1257.64 0.0572148255 0.065300072
11/1/10 27.79 1180.55 -0.0255960729 -0.0022902828
10/1/10 28.52 1183.26 -0.0027972028 0.0368559411
9/1/10 28.6 1141.2 0.0580836108 0.087551104
8/2/10 27.03 1049.33 0.0420200463 -0.0474491649
7/1/10 25.94 1101.6 0.0723439438 0.0687778328
6/1/10 24.19 1030.71 -0.004526749 -0.0538823767
5/3/10 24.3 1089.41 -0.0675364543 -0.0819759162
4/1/10 26.06 1186.69 0.0085139319 0.0147593272
3/1/10 25.84 1169.43 0.0415155179 0.0587963676
2/1/10 24.81 1104.49 -0.0216876972 0.0285136935
1/4/10 25.36 1073.87 -0.0952550838 -0.0369742624
12/1/09 28.03 1115.1 0.0404602821 0.0177705977
11/2/09 26.94 1095.63 0.0494740943 0.057363997
10/1/09 25.67 1036.19 -0.0496112551 -0.0197619858
9/1/09 27.01 1057.08 0.0368522073 0.0357233838
8/3/09 26.05 1020.62 -0.0068623713 0.0335601734
7/1/09 26.23 987.48 0.055958132 0.074141757
6/1/09 24.84 919.32 0.0020169423 0.0001958352
5/1/09 24.79 919.14 -0.0323965652 0.0530814267
4/1/09 25.62 872.81 0.0166666667 0.0939250755
3/2/09 25.2 797.87 0.0601598654 0.0854045083
2/2/09 23.77 735.09 -0.0345247766 -0.1099312249
1/2/09 24.62 825.88 -0.1361403509 -0.0856573485
12/1/08 28.5 903.25 -0.0021008403 0.0078215657
11/3/08 28.56 896.24 0.0668658947 -0.0748490323
10/1/08 26.77 968.75 -0.0411891117 -0.1694245344
9/2/08 27.92 1166.36 -0.1272272585 -0.0907914533
8/1/08 31.99 1282.83 0.0382992535 0.0121905032
7/1/08 30.81 1267.38 -0.0854853072 -0.009859375
6/2/08 33.69 1280 -0.1556390977 -0.0859623816
5/1/08 39.9 1400.38 0.0307414105 0.0106741532
4/1/08 38.71 1385.59 0.0107049608 0.0475466848
3/3/08 38.3 1322.7 0.0996267585 -0.0059595831
2/1/08 34.83 1330.63 -0.0950896337 -0.0347611621
1/2/08 38.49 1378.55 -0.0738691049 -0.0611634749
12/3/07 41.56 1468.36 0.0876733839 -0.0086284889
11/1/07 38.21 1481.14 -0.0856664274 -0.0440434238
10/1/07 41.79 1549.38 -0.0122902387 0.014822335
9/4/07 42.31 1526.75 0.0611988964 0.0357940013
8/1/07 39.87 1473.99 0.0181307457 0.0128635923
7/2/07 39.16 1455.27 -0.0563855422 -0.0319819071
6/1/07 41.5 1503.35 0.0038703435 -0.0178163097
5/1/07 41.34 1530.62 0.0676652893 0.0325492286
4/2/07 38.72 1482.37 -0.018006594 0.0432906831
3/1/07 39.43 1420.86 0.0714673913 0.0099799548
2/1/07 36.8 1406.82 -0.0220568695 -0.0218461453
1/3/07 37.63 1438.24 0.0525874126 0.0140590848
12/1/06 35.75 1418.3 0.0542612799 0.0126157515
11/1/06 33.91 1400.63 -0.0099270073 0.0164666096
10/2/06 34.25 1377.94 0.0519041769 0.0315080286
9/1/06 32.56 1335.85 0.0459363958 0.0245662745
8/1/06 31.13 1303.82 0.0380126709 0.0212742625
7/3/06 29.99 1276.66 0.0752958049 0.0050858133
6/1/06 27.89 1270.2 0.0702225633 0.000086608
5/1/06 26.06 1270.09 -0.0057230065 -0.0309169013
4/3/06 26.21 1310.61 -0.0306952663 0.0121556604
3/1/06 27.04 1294.87 -0.019934759 0.0110958412
2/1/06 27.59 1280.66 0.0631984586 0.0004530967
1/3/06 25.95 1280.08 0.0596161699 0.0254668386
12/1/05 24.49 1248.29 -0.0168606985 -0.0009523962
11/1/05 24.91 1249.48 0.0444444444 0.0351861211
10/3/05 23.85 1207.01 -0.0050062578 -0.017740741
9/1/05 23.97 1228.81 -0.0045681063 0.00694894
8/1/05 24.08 1220.33 -0.0151329243 -0.011222026
7/1/05 24.45 1234.18 0.0294736842 0.0359682036
6/1/05 23.75 1191.33 0.0158254919 -0.0001426773
5/2/05 23.38 1191.5 -0.0176470588 0.0299520249
4/1/05 23.8 1156.85 0.0046433094 -0.0201085898
3/1/05 23.69 1180.59 -0.0153782211 -0.0191176471
2/1/05 24.06 1203.6 0.0126262626 0.0189033836
1/3/05 23.76 1181.27 ERROR:#DIV/0! ERROR:#DIV/0!