# Security Valuation Project First read the instructions and make sure you understand the concepts .. there are 8 problems must be done by the excel … chec

Security Valuation Project First read the instructions and make sure you understand the concepts .. there are 8 problems must be done by the excel … check out the uploaded files .. Security Valuation Project
Estimate American Express’ Required Rate of Return and Intrinsic Value Per Share
which means that I should be able to see your formulas by clicking on the appropriate cells.
Download weekly data for Jabil Circuit (symbol: JBL) from January 4, 2010, to January 4, 2019. Do the same thing
for Depository Receipts from Standard and Poor’s (S&P). S&P’s Depository Receipts have symbol SPY and are
commonly called “spiders.” We will use SPY as the market portfolio.
Problems:
1.
2.
3.
4.
Calculate the weekly return on JBL by dividing the adjusted close in any particular week by the adjusted
closing price the previous week and subtracting 1.
Calculate the weekly return on the SPY the same way. Paste the returns on the S&P and the returns on JBL
into a single spreadsheet. (To do so, use the “Paste-Special-Values” sequence in Excel).
Calculate the correlation coefficient between JBL returns and SPY returns.
You will run a regression in Excel using the returns on JBL as the dependent, or Y variable, and returns on
the SPY as the independent, or X variable. You can use the data analysis function under the tools menu
(you may have to first click “Add ins” under the tools menu and then check the box labeled “Analysis
Toolpak”). Click “Tools-Data Analysis Regression” to set up the regression. Type in the cell range
containing JBL returns for the input Y range, and type in the cell range containing the SPY returns for the
input X range. Leave all the other boxes unchecked.
You have just estimated JBL’s beta, which is the coefficient of the X variable in the regression output.
5. Estimate JBL’s required rate of return using a risk-free rate of 0.5% and a market risk premium of 1.5%.
6. Estimate JBL’s dividend growth rate (g) using the formula g = ROE × b, where b is the retention ratio. Remember
that b = 1- Dividend Payout Ratio. Use the value of “Dvd Payout Ratio” for 2018Y in the “11) Profitability” tab
under “5) Ratios.” Convert the dividend payout ratio to a decimal. Use the ROE value in the same location, and
convert it to a decimal.
7. Find the most recent annual dividend paid by JBL as of the most recent date in the date range and assume that the
dividend growth rate will remain constant. What would be JBL’s intrinsic stock price according to the Constant
Dividend Growth Model?
8. Answer the following questions by comparing your computed stock price from Problem 7 to JBL’s closing price
as of the most recent date in the raw data. Is JBL’s current stock price overvalued or undervalued? Why? If you
already hold JBL in your portfolio, should you sell it or keep holding it? Why? If you do not already hold JBL,
should you buy it or not? Why?
2/6/2019
2/1/2019
1/25/2019
1/18/2019
1/11/2019
1/4/2019
27.2475 JBL
26.57
25.83
25.42
24.55
23.95
12/28/2018
12/21/2018
12/14/2018
12/7/2018
24.49
23.4
21.84
23.26
11/30/2018
11/23/2018
11/16/2018
11/9/2018
11/2/2018
24.97
24.64
24.99
25.29
26.13
10/26/2018
10/19/2018
10/12/2018
10/5/2018
23.63
23.93
23.73
25.72
9/28/2018
9/21/2018
9/14/2018
9/7/2018
27.08
29.86
29.5
29.15
8/31/2018
8/24/2018
8/17/2018
8/10/2018
8/3/2018
29.56
28.1
27.67
28.08
28.54
7/27/2018
7/20/2018
7/13/2018
7/6/2018
28.05
28.56
28.67
28.22
6/29/2018
6/22/2018
6/15/2018
6/8/2018
6/1/2018
27.66
28.3
27.73
29.25
28.68
5/25/2018
28.21
1/4/2019
2531.94 S&P
12/28/2018
12/21/2018
12/14/2018
12/7/2018
2485.74
2416.62
2599.95
2633.08
11/30/2018
11/23/2018
11/16/2018
11/9/2018
11/2/2018
2760.17
2632.56
2736.27
2781.01
2723.06
10/26/2018
10/19/2018
10/12/2018
10/5/2018
2658.69
2767.78
2767.13
2885.57
9/28/2018
9/21/2018
9/14/2018
9/7/2018
2913.98
2929.67
2904.98
2871.68
8/31/2018
8/24/2018
8/17/2018
8/10/2018
8/3/2018
2901.52
2874.69
2850.13
2833.28
2840.35
7/27/2018
7/20/2018
7/13/2018
7/6/2018
2818.82
2801.83
2801.31
2759.82
6/29/2018
6/22/2018
6/15/2018
6/8/2018
6/1/2018
2718.37
2754.88
2779.66
2779.03
2734.62
5/25/2018
5/18/2018
5/11/2018
5/4/2018
2721.33
2712.97
2727.72
2663.42
4/27/2018
4/20/2018
2669.91
2670.14
5/18/2018
5/11/2018
5/4/2018
27.93
27.61
27.44
4/27/2018
4/20/2018
4/13/2018
4/6/2018
26.67
27.94
29.23
27.95
3/30/2018
3/23/2018
3/16/2018
3/9/2018
3/2/2018
28.73
28.59
31.37
28.19
27
2/23/2018
2/16/2018
2/9/2018
2/2/2018
26.61
26.37
25.44
25.28
1/26/2018
1/19/2018
1/12/2018
1/5/2018
26.53
27.39
27.66
27.19
12/29/2017
12/22/2017
12/15/2017
12/8/2017
12/1/2017
26.25
26.7
27.87
27.88
28.58
11/24/2017
11/17/2017
11/10/2017
11/3/2017
29.78
29.22
28.61
28.02
10/27/2017
10/20/2017
10/13/2017
10/6/2017
28.44
27.96
28.24
29.79
9/29/2017
9/22/2017
9/15/2017
9/8/2017
9/1/2017
28.55
29.44
30.72
30.44
31.34
4/13/2018
4/6/2018
2656.3
2604.47
3/30/2018
3/23/2018
3/16/2018
3/9/2018
3/2/2018
2640.87
2588.26
2752.01
2786.57
2691.25
2/23/2018
2/16/2018
2/9/2018
2/2/2018
2747.3
2732.22
2619.55
2762.13
1/26/2018
1/19/2018
1/12/2018
1/5/2018
2872.87
2810.3
2786.24
2743.15
12/29/2017
12/22/2017
12/15/2017
12/8/2017
12/1/2017
2673.61
2683.34
2675.81
2651.5
2642.22
11/24/2017
11/17/2017
11/10/2017
11/3/2017
2602.42
2578.85
2582.3
2587.84
10/27/2017
10/20/2017
10/13/2017
10/6/2017
2581.07
2575.21
2553.17
2549.33
9/29/2017
9/22/2017
9/15/2017
9/8/2017
9/1/2017
2519.36
2502.22
2500.23
2461.43
2476.55
8/25/2017
8/18/2017
8/11/2017
8/4/2017
2443.05
2425.55
2441.32
2476.83
7/28/2017
2472.1
8/25/2017
8/18/2017
8/11/2017
8/4/2017
30.3
29.67
29.22
30.72
7/28/2017
7/21/2017
7/14/2017
7/7/2017
30.57
30.74
30.49
29.29
6/30/2017
6/23/2017
6/16/2017
6/9/2017
6/2/2017
29.19
30.09
28.46
31.04
30.86
5/26/2017
5/19/2017
5/12/2017
5/5/2017
29.32
28.58
28.95
28.95
4/28/2017
4/21/2017
4/14/2017
4/7/2017
29.02
28.95
28.24
28.72
3/31/2017
3/24/2017
3/17/2017
3/10/2017
3/3/2017
28.92
28.74
28.8
26.33
25.96
2/24/2017
2/17/2017
2/10/2017
2/3/2017
26.23
25.91
25.44
24.39
1/27/2017
1/20/2017
1/13/2017
1/6/2017
23.88
23.2
23.58
23.34
12/30/2016
12/23/2016
12/16/2016
12/9/2016
12/2/2016
23.67
24.11
24.15
21.62
20.5
7/21/2017
7/14/2017
7/7/2017
2472.54
2459.27
2425.18
6/30/2017
6/23/2017
6/16/2017
6/9/2017
6/2/2017
2423.41
2438.3
2433.15
2431.77
2439.07
5/26/2017
5/19/2017
5/12/2017
5/5/2017
2415.82
2381.73
2390.9
2399.29
4/28/2017
4/21/2017
4/14/2017
4/7/2017
2384.2
2348.69
2328.95
2355.54
3/31/2017
3/24/2017
3/17/2017
3/10/2017
3/3/2017
2362.72
2343.98
2378.25
2372.6
2383.12
2/24/2017
2/17/2017
2/10/2017
2/3/2017
2367.34
2351.16
2316.1
2297.42
1/27/2017
1/20/2017
1/13/2017
1/6/2017
2294.69
2271.31
2274.64
2276.98
12/30/2016
12/23/2016
12/16/2016
12/9/2016
12/2/2016
2238.83
2263.79
2258.07
2259.53
2191.95
11/25/2016
11/18/2016
11/11/2016
11/4/2016
2213.35
2181.9
2164.45
2085.18
11/25/2016
11/18/2016
11/11/2016
11/4/2016
21.62
20.41
21.65
20.45
10/28/2016
10/21/2016
10/14/2016
10/7/2016
21.42
21.68
21.26
21.78
9/30/2016
9/23/2016
9/16/2016
9/9/2016
9/2/2016
21.82
21.89
22.48
20.69
21.42
8/26/2016
8/19/2016
8/12/2016
8/5/2016
21.08
21.08
20.84
20.72
7/29/2016
7/22/2016
7/15/2016
7/8/2016
7/1/2016
20.35
20.37
20.57
18.76
18.62
6/24/2016
6/17/2016
6/10/2016
6/3/2016
18.53
18.95
18.86
19.43
5/27/2016
5/20/2016
5/13/2016
5/6/2016
19.03
17.58
16.88
17.04
4/29/2016
4/22/2016
4/15/2016
4/8/2016
4/1/2016
17.36
17.96
17.88
17.97
19.2
3/25/2016
3/18/2016
3/11/2016
18.94
19.59
21.72
10/28/2016
10/21/2016
10/14/2016
10/7/2016
2126.41
2141.16
2132.98
2153.74
9/30/2016
9/23/2016
9/16/2016
9/9/2016
9/2/2016
2168.27
2164.69
2139.16
2127.81
2179.98
8/26/2016
8/19/2016
8/12/2016
8/5/2016
2169.04
2183.87
2184.05
2182.87
7/29/2016
7/22/2016
7/15/2016
7/8/2016
7/1/2016
2173.6
2175.03
2161.74
2129.9
2102.95
6/24/2016
6/17/2016
6/10/2016
6/3/2016
2037.41
2071.22
2096.07
2099.13
5/27/2016
5/20/2016
5/13/2016
5/6/2016
2099.06
2052.32
2046.61
2057.14
4/29/2016
4/22/2016
4/15/2016
4/8/2016
4/1/2016
2065.3
2091.58
2080.73
2047.6
2072.78
3/25/2016
3/18/2016
3/11/2016
3/4/2016
2035.94
2049.58
2022.19
1999.99
2/26/2016
2/19/2016
2/12/2016
2/5/2016
1948.05
1917.78
1864.78
1880.05
3/4/2016
21.73
2/26/2016
2/19/2016
2/12/2016
2/5/2016
20.84
20.7
19.06
19.91
1/29/2016
1/22/2016
1/15/2016
1/8/2016
1/1/2016
19.91
19.23
19.3
19.84
23.29
12/25/2015
12/18/2015
12/11/2015
12/4/2015
23.9
23.52
23.84
25.93
11/27/2015
11/20/2015
11/13/2015
11/6/2015
25.48
25.21
23.49
24.24
10/30/2015
10/23/2015
10/16/2015
10/9/2015
10/2/2015
22.98
23.13
23.06
22.52
21.92
9/25/2015
9/18/2015
9/11/2015
9/4/2015
21.88
20.01
19.77
19.01
8/28/2015
8/21/2015
8/14/2015
8/7/2015
19.47
18.59
19.77
19.7
7/31/2015
7/24/2015
7/17/2015
7/10/2015
7/3/2015
20.25
19.48
20.01
20.51
21.1
6/26/2015
6/19/2015
21.98
22.6
1/29/2016
1/22/2016
1/15/2016
1/8/2016
1/1/2016
1940.24
1906.9
1880.33
1922.03
2043.94
12/25/2015
12/18/2015
12/11/2015
12/4/2015
2060.99
2005.55
2012.37
2091.69
11/27/2015
11/20/2015
11/13/2015
11/6/2015
2090.11
2089.17
2023.04
2099.2
10/30/2015
10/23/2015
10/16/2015
10/9/2015
10/2/2015
2079.36
2075.15
2033.11
2014.89
1951.36
9/25/2015
9/18/2015
9/11/2015
9/4/2015
1931.34
1958.03
1961.05
1921.22
8/28/2015
8/21/2015
8/14/2015
8/7/2015
1988.87
1970.89
2091.54
2077.57
7/31/2015
7/24/2015
7/17/2015
7/10/2015
7/3/2015
2103.84
2079.65
2126.64
2076.62
2076.78
6/26/2015
6/19/2015
6/12/2015
6/5/2015
2101.49
2109.99
2094.11
2092.83
5/29/2015
5/22/2015
5/15/2015
2107.39
2126.06
2122.73
6/12/2015
6/5/2015
24.14
24.23
5/8/2015
5/1/2015
2116.1
2108.29
5/29/2015
5/22/2015
5/15/2015
5/8/2015
5/1/2015
24.57
24.57
24.31
23.38
22.96
4/24/2015
4/17/2015
4/10/2015
4/3/2015
2117.69
2081.18
2102.06
2066.96
3/27/2015
3/20/2015
3/13/2015
3/6/2015
2061.02
2108.1
2053.4
2071.26
2/27/2015
2/20/2015
2/13/2015
2/6/2015
2104.5
2110.3
2096.99
2055.47
1/30/2015
1/23/2015
1/16/2015
1/9/2015
1/2/2015
1994.99
2051.82
2019.42
2044.81
2058.2
12/26/2014
12/19/2014
12/12/2014
12/5/2014
2088.77
2070.65
2002.33
2075.37
11/28/2014
11/21/2014
11/14/2014
11/7/2014
2067.56
2063.5
2039.82
2031.92
10/31/2014
10/24/2014
10/17/2014
10/10/2014
10/3/2014
2018.05
1964.58
1886.76
1906.13
1967.9
9/26/2014
9/19/2014
9/12/2014
9/5/2014
1982.85
2010.4
1985.54
2007.71
8/29/2014
8/22/2014
2003.37
1988.4
4/24/2015
4/17/2015
4/10/2015
4/3/2015
3/27/2015
3/20/2015
3/13/2015
3/6/2015
23.69
23.07
23.91
23.14
22.9
23.65
21.73
21.74
2/27/2015
2/20/2015
2/13/2015
2/6/2015
21.97
22.39
22.27
21.24
1/30/2015
1/23/2015
1/16/2015
1/9/2015
1/2/2015
20.61
20.79
21.07
21.75
21.62
12/26/2014
12/19/2014
12/12/2014
12/5/2014
22.33
21.44
19.51
20.71
11/28/2014
11/21/2014
11/14/2014
11/7/2014
20.75
20.62
20.71
21.13
10/31/2014
10/24/2014
10/17/2014
10/10/2014
10/3/2014
20.95
19.43
18.49
18.2
19.98
9/26/2014
20.6
9/19/2014
9/12/2014
9/5/2014
21.34
21.5
21.39
8/15/2014
8/8/2014
8/1/2014
1955.06
1931.59
1925.15
8/29/2014
8/22/2014
8/15/2014
8/8/2014
8/1/2014
21.58
21.41
20.55
19.92
20.05
7/25/2014
7/18/2014
7/11/2014
7/4/2014
1978.34
1978.22
1967.57
1985.44
7/25/2014
7/18/2014
7/11/2014
7/4/2014
20.77
20.8
20.72
21.05
6/27/2014
6/20/2014
6/13/2014
6/6/2014
1960.96
1962.87
1936.16
1949.44
6/27/2014
6/20/2014
6/13/2014
6/6/2014
20.91
20.48
19.79
19.48
5/30/2014
5/23/2014
5/16/2014
5/9/2014
5/2/2014
1923.57
1900.53
1877.86
1878.48
1881.14
5/30/2014
5/23/2014
5/16/2014
5/9/2014
5/2/2014
18.82
18.5
17.76
17.52
17.6
4/25/2014
4/18/2014
4/11/2014
4/4/2014
1863.4
1864.85
1815.69
1865.09
4/25/2014
4/18/2014
4/11/2014
4/4/2014
17.64
17.6
17.23
18.44
3/28/2014
3/21/2014
3/14/2014
3/7/2014
1857.62
1866.52
1841.13
1878.04
3/28/2014
3/21/2014
3/14/2014
3/7/2014
17.76
17.72
17.73
18.39
2/28/2014
2/21/2014
2/14/2014
2/7/2014
1859.45
1836.25
1838.63
1797.02
1/31/2014
1/24/2014
1/17/2014
1/10/2014
1/3/2014
1782.59
1790.29
1838.7
1842.37
1831.37
12/27/2013
12/20/2013
12/13/2013
12/6/2013
1841.4
1818.32
1775.32
1805.09
11/29/2013
1805.81
2/28/2014
2/21/2014
2/14/2014
2/7/2014
18.51
18.48
18.49
18.01
1/31/2014
1/24/2014
1/17/2014
1/10/2014
1/3/2014
17.97
17.96
18.01
17.02
17.19
12/27/2013
12/20/2013
12/13/2013
12/6/2013
17.01
16.12
19.07
20.42
11/22/2013
11/15/2013
11/8/2013
11/1/2013
1804.76
1798.18
1770.61
1761.64
11/29/2013
11/22/2013
11/15/2013
11/8/2013
11/1/2013
20.27
19.62
19.82
20.51
20.71
10/25/2013
10/18/2013
10/11/2013
10/4/2013
1759.77
1744.5
1703.2
1690.5
9/27/2013
9/20/2013
9/13/2013
9/6/2013
1691.75
1709.91
1687.99
1655.17
8/30/2013
8/23/2013
8/16/2013
8/9/2013
8/2/2013
1632.97
1663.5
1655.83
1691.42
1709.67
7/26/2013
7/19/2013
7/12/2013
7/5/2013
1691.65
1692.09
1680.19
1631.89
6/28/2013
6/21/2013
6/14/2013
6/7/2013
1606.28
1592.43
1626.73
1643.38
5/31/2013
5/24/2013
5/17/2013
5/10/2013
5/3/2013
1630.74
1649.6
1667.47
1633.7
1614.42
4/26/2013
4/19/2013
4/12/2013
4/5/2013
1582.24
1555.25
1588.85
1553.28
3/29/2013
3/22/2013
3/15/2013
3/8/2013
3/1/2013
1569.19
1556.89
1560.7
1551.18
1518.2
10/25/2013
10/18/2013
10/11/2013
10/4/2013
22.52
22.52
21.99
22.11
9/27/2013
9/20/2013
9/13/2013
9/6/2013
21.42
23.11
23.67
23
8/30/2013
8/23/2013
8/16/2013
8/9/2013
8/2/2013
22.82
23.39
23.36
23.63
23.39
7/26/2013
7/19/2013
7/12/2013
7/5/2013
22.6
22.25
21.95
20.93
6/28/2013
6/21/2013
6/14/2013
6/7/2013
20.38
20.23
19.42
19.44
5/31/2013
5/24/2013
5/17/2013
5/10/2013
5/3/2013
20.06
19.25
20.05
19.28
18.23
4/26/2013
4/19/2013
4/12/2013
4/5/2013
17.31
16.57
18.01
18.31
3/29/2013
3/22/2013
3/15/2013
3/8/2013
3/1/2013
18.48
18.56
19.25
18.89
18.47
2/22/2013
2/15/2013
2/8/2013
2/1/2013
19.07
19.77
19.36
19.36
1/25/2013
1/18/2013
1/11/2013
1/4/2013
19.94
19.63
19.92
19.44
12/28/2012
12/21/2012
12/14/2012
12/7/2012
18.61
19.39
17.51
18.37
11/30/2012
11/23/2012
11/16/2012
11/9/2012
11/2/2012
19
18.95
17.63
17.62
17.4
10/26/2012
10/19/2012
10/12/2012
10/5/2012
17.28
17.19
17.03
18.05
9/28/2012
9/21/2012
9/14/2012
9/7/2012
18.72
21.55
22.7
21.9
8/31/2012
8/24/2012
8/17/2012
8/10/2012
8/3/2012
22.78
23.27
23.16
22.67
22.02
7/27/2012
7/20/2012
7/13/2012
21.22
20.55
19.02
2/22/2013
2/15/2013
2/8/2013
2/1/2013
1515.6
1519.79
1517.93
1513.17
1/25/2013
1/18/2013
1/11/2013
1/4/2013
1502.96
1485.98
1472.05
1466.47
12/28/2012
12/21/2012
12/14/2012
12/7/2012
1402.43
1430.15
1413.58
1418.07
11/30/2012
11/23/2012
11/16/2012
11/9/2012
11/2/2012
1416.18
1409.15
1359.88
1379.85
1414.2
10/26/2012
10/19/2012
10/12/2012
10/5/2012
1411.94
1433.19
1428.59
1460.93
9/28/2012
9/21/2012
9/14/2012
9/7/2012
1440.67
1460.15
1465.77
1437.92
8/31/2012
8/24/2012
8/17/2012
8/10/2012
8/3/2012
1406.58
1411.13
1418.16
1405.87
1390.99
7/27/2012
7/20/2012
7/13/2012
7/6/2012
1385.97
1362.66
1356.78
1354.68
6/29/2012
6/22/2012
6/15/2012
6/8/2012
1362.16
1335.02
1342.83
1325.66
7/6/2012
19.85
6/1/2012
1278.05
6/29/2012
6/22/2012
6/15/2012
6/8/2012
6/1/2012
20.33
19.76
19.13
19.1
18.19
5/25/2012
5/18/2012
5/11/2012
5/4/2012
1317.82
1295.22
1353.39
1369.1
4/27/2012
4/20/2012
4/13/2012
4/6/2012
1403.36
1378.53
1370.26
1398.08
3/30/2012
3/23/2012
3/16/2012
3/9/2012
3/2/2012
1408.47
1397.11
1404.17
1370.87
1369.63
2/24/2012
2/17/2012
2/10/2012
2/3/2012
1365.74
1361.23
1342.64
1344.9
1/27/2012
1/20/2012
1/13/2012
1/6/2012
1316.33
1315.38
1289.09
1277.81
12/30/2011
12/23/2011
12/16/2011
12/9/2011
12/2/2011
1257.6
1265.33
1219.66
1255.19
1244.28
11/25/2011
11/18/2011
11/11/2011
11/4/2011
1158.67
1215.65
1263.85
1253.23
10/28/2011
10/21/2011
10/14/2011
10/7/2011
1285.09
1238.25
1224.58
1155.46
9/30/2011
9/23/2011
9/16/2011
1131.42
1136.43
1216.01
5/25/2012
5/18/2012
5/11/2012
5/4/2012
19.25
18.91
20.04
21.66
4/27/2012
4/20/2012
4/13/2012
4/6/2012
23.58
22.58
23.03
24.2
3/30/2012
3/23/2012
3/16/2012
3/9/2012
3/2/2012
25.12
25.5
26.82
26.16
25.98
2/24/2012
2/17/2012
2/10/2012
2/3/2012
26.01
26.03
24.72
24.12
1/27/2012
1/20/2012
1/13/2012
1/6/2012
22.8
23
21.04
20.87
12/30/2011
12/23/2011
12/16/2011
12/9/2011
12/2/2011
19.66
19.91
19.42
20.65
20.71
11/25/2011
11/18/2011
11/11/2011
11/4/2011
18.34
20.32
20.91
20.59
10/28/2011
10/21/2011
21.32
19.92
10/14/2011
10/7/2011
20.07
18.6
9/9/2011
9/2/2011
1154.23
1173.97
9/30/2011
9/23/2011
9/16/2011
9/9/2011
9/2/2011
17.79
16.28
17.66
15.76
16.37
8/26/2011
8/19/2011
8/12/2011
8/5/2011
1176.8
1123.53
1178.81
1199.38
7/29/2011
7/22/2011
7/15/2011
7/8/2011
7/1/2011
1292.28
1345.02
1316.14
1343.8
1339.67
6/24/2011
6/17/2011
6/10/2011
6/3/2011
1268.44
1271.5
1270.98
1300.16
5/27/2011
5/20/2011
5/13/2011
5/6/2011
1331.1
1333.27
1337.77
1340.2
4/29/2011
4/22/2011
4/15/2011
4/8/2011
4/1/2011
1363.61
1337.39
1319.68
1328.17
1332.41
3/25/2011
3/18/2011
3/11/2011
3/4/2011
1313.8
1279.2
1304.28
1321.15
2/25/2011
2/18/2011
2/11/2011
2/4/2011
1319.88
1343.01
1329.15
1310.87
1/28/2011
1/21/2011
1/14/2011
1/7/2011
1276.34
1283.35
1293.24
1271.5
12/31/2010
12/24/2010
1257.64
1256.77
8/26/2011
8/19/2011
8/12/2011
8/5/2011
15.46
14.22
16.25
15.54
7/29/2011
7/22/2011
7/15/2011
7/8/2011
7/1/2011
18.31
20.26
19.79
21.35
20.77
6/24/2011
6/17/2011
6/10/2011
6/3/2011
19.14
18.29
19.08
19.95
5/27/2011
5/20/2011
5/13/2011
5/6/2011
21.22
20.74
21.58
20.99
4/29/2011
4/22/2011
4/15/2011
4/8/2011
4/1/2011
19.84
19.91
19.18
19.79
20.04
3/25/2011
3/18/2011
3/11/2011
3/4/2011
2/25/2011
2/18/2011
2/11/2011
2/4/2011
1/28/2011
21.28
18.59
20.48
21.79
20.93
22.57
21.66
21.22
19.81
1/21/2011
1/14/2011
1/7/2011
19.84
21.34
21.07
12/17/2010
12/10/2010
12/3/2010
1243.91
1240.4
1224.71
12/31/2010
12/24/2010
12/17/2010
12/10/2010
12/3/2010
20.09
19.93
17.47
16.71
16.16
11/26/2010
11/19/2010
11/12/2010
11/5/2010
1189.4
1199.73
1199.21
1225.85
11/26/2010
11/19/2010
11/12/2010
11/5/2010
14.59
15.03
14.39
15.63
10/29/2010
10/22/2010
10/15/2010
10/8/2010
10/1/2010
1183.26
1183.08
1176.19
1165.15
1146.24
10/29/2010
10/22/2010
10/15/2010
10/8/2010
10/1/2010
15.34
14.18
14.75
14.71
14.3
9/24/2010
9/17/2010
9/10/2010
9/3/2010
1148.67
1125.59
1109.55
1104.51
8/27/2010
8/20/2010
8/13/2010
8/6/2010
1064.59
1071.69
1079.25
1121.64
7/30/2010
7/23/2010
7/16/2010
7/9/2010
7/2/2010
1101.6
1102.66
1064.88
1077.96
1022.58
6/25/2010
6/18/2010
6/11/2010
6/4/2010
1076.77
1117.51
1091.6
1064.88
5/28/2010
5/21/2010
5/14/2010
5/7/2010
1089.41
1087.69
1135.68
1110.89
4/30/2010
4/23/2010
4/16/2010
4/9/2010
4/2/2010
1186.69
1217.28
1192.13
1194.37
1178.1
9/24/2010
9/17/2010
9/10/2010
9/3/2010
13.57
12.79
12.22
11.73
8/27/2010
8/20/2010
8/13/2010
8/6/2010
10.82
11.17
11.55
13.29
7/30/2010
7/23/2010
7/16/2010
7/9/2010
7/2/2010
14.51
15.31
14.79
13.97
13.02
6/25/2010
6/18/2010
6/11/2010
6/4/2010
14.4
13.96
13.09
12.66
5/28/2010
5/21/2010
5/14/2010
5/7/2010
13.69
13.15
14.12
14.09
4/30/2010
4/23/2010
4/16/2010
4/9/2010
4/2/2010
3/26/2010
3/19/2010
3/12/2010
3/5/2010
15.32
17.02
16.45
16.8
16.27
16.37
17.34
17.62
16.72
2/26/2010
2/19/2010
2/12/2010
2/5/2010
15.17
15.16
14.74
14.36
1/29/2010
1/22/2010
1/15/2010
1/8/2010
1/1/2010
14.48
15.69
17.04
17.54
17.37
12/25/2009
12/18/2009
12/11/2009
12/4/2009
17.42
14.8
14.06
12.94
11/27/2009
11/20/2009
11/13/2009
11/6/2009
13.34
13.63
14.48
14.29
10/30/2009
10/23/2009
10/16/2009
10/9/2009
10/2/2009
13.38
14.96
14.78
14.35
12.94
9/25/2009
11.87
3/26/2010
3/19/2010
3/12/2010
3/5/2010
1166.59
1159.9
1149.99
1138.7
2/26/2010
2/19/2010
2/12/2010
2/5/2010
1104.49
1109.17
1075.51
1066.19
1/29/2010
1/22/2010
1/15/2010
1/8/2010
1/1/2010
1073.87
1091.76
1136.03
1144.98
1115.1
12/25/2009
12/18/2009
12/11/2009
12/4/2009
1126.48
1102.47
1106.41
1105.98
11/27/2009
11/20/2009
11/13/2009
11/6/2009
1091.49
1091.38
1093.48
1069.3
10/30/2009
10/23/2009
10/16/2009
10/9/2009
10/2/2009
1036.19
1079.6
1087.68
1071.49
1025.21
9/25/2009
1044.38
Name:
Company:
FILL IN.
Date
Company Prices % Ret Company
FILL IN.
FILL IN.
FILL IN.
USE AS MANY ROW…