Security Valuation Project Estimate American Express apply solution in Excel on the file attached there are two sheets in file Problems: 1. Calculate the
Security Valuation Project Estimate American Express apply solution in Excel on the file attached
there are two sheets in file
Problems: 1. 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.
2. 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).
3. Calculate the correlation coefficient between JBL returns and SPY returns.
4. 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? Date
Last Px
2/4/2019
26.76
2/1/2019
26.57
1/25/2019
1/18/2019
1/11/2019
1/4/2019
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
5/18/2018
5/11/2018
5/4/2018
28.21
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
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
23.67
24.11
24.15
21.62
12/2/2016
20.5
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
18.94
19.59
3/11/2016
3/4/2016
21.72
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
21.98
6/19/2015
6/12/2015
6/5/2015
22.6
24.14
24.23
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
23.69
23.07
23.91
23.14
3/27/2015
3/20/2015
3/13/2015
3/6/2015
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
9/19/2014
9/12/2014
9/5/2014
20.6
21.34
21.5
21.39
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
20.77
20.8
20.72
21.05
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
18.82
18.5
17.76
17.52
17.6
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
17.76
17.72
17.73
18.39
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/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
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
17.31
16.57
18.01
4/5/2013
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
21.22
20.55
7/13/2012
7/6/2012
19.02
19.85
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
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
21.32
10/21/2011
10/14/2011
10/7/2011
19.92
20.07
18.6
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
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
21.28
18.59
20.48
21.79
2/25/2011
2/18/2011
2/11/2011
2/4/2011
20.93
22.57
21.66
21.22
1/28/2011
1/21/2011
1/14/2011
1/7/2011
19.81
19.84
21.34
21.07
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
14.59
15.03
14.39
15.63
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
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
15.32
17.02
16.45
16.8
16.27
3/26/2010
3/19/2010
3/12/2010
3/5/2010
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
Date
Last Px
2/4/2019
271.96
2/1/2019
270.06
1/25/2019
1/18/2019
1/11/2019
1/4/2019
265.78
266.46
258.98
252.39
12/28/2018
12/21/2018
12/14/2018
12/7/2018
247.75
240.7
260.47
263.57
11/30/2018
11/23/2018
11/16/2018
11/9/2018
11/2/2018
275.65
263.25
273.73
277.76
271.89
10/26/2018
10/19/2018
10/12/2018
10/5/2018
265.33
276.25
275.95
287.82
9/28/2018
9/21/2018
9/14/2018
9/7/2018
290.72
291.99
290.88
287.6
8/31/2018
8/24/2018
8/17/2018
8/10/2018
8/3/2018
290.31
287.51
285.06
283.16
283.6
7/27/2018
7/20/2018
7/13/2018
7/6/2018
281.42
279.68
279.59
275.42
6/29/2018
6/22/2018
6/15/2018
6/8/2018
6/1/2018
271.28
274.74
277.13
278.19
273.6
5/25/2018
5/18/2018
5/11/2018
5/4/2018
272.15
271.33
272.85
266.02
4/27/2018
4/20/2018
4/13/2018
4/6/2018
266.56
266.61
265.15
259.72
3/30/2018
3/23/2018
3/16/2018
3/9/2018
3/2/2018
263.15
258.05
274.2
278.87
269.08
2/23/2018
2/16/2018
2/9/2018
2/2/2018
274.71
273.11
261.5
275.45
1/26/2018
1/19/2018
1/12/2018
1/5/2018
286.58
280.41
277.92
273.42
12/29/2017
12/22/2017
12/15/2017
12/8/2017
12/1/2017
266.86
267.51
266.51
265.51
264.46
11/24/2017
11/17/2017
11/10/2017
11/3/2017
260.36
257.86
258.09
258.45
10/27/2017
10/20/2017
10/13/2017
10/6/2017
257.71
257.11
254.95
254.37
9/29/2017
9/22/2017
9/15/2017
9/8/2017
9/1/2017
251.23
249.44
249.19
246.58
247.84
8/25/2017
8/18/2017
8/11/2017
8/4/2017
244.56
242.71
244.12
247.41
7/28/2017
7/21/2017
7/14/2017
7/7/2017
246.91
246.88
245.56
242.11
6/30/2017
6/23/2017
6/16/2017
6/9/2017
6/2/2017
241.8
243.13
242.64
243.41
244.17
5/26/2017
5/19/2017
5/12/2017
5/5/2017
241.71
238.31
238.98
239.7
4/28/2017
4/21/2017
4/14/2017
4/7/2017
238.08
234.59
232.51
235.2
3/31/2017
3/24/2017
3/17/2017
3/10/2017
3/3/2017
235.74
233.86
237.03
237.69
238.42
2/24/2017
2/17/2017
2/10/2017
2/3/2017
236.74
235.09
231.51
229.34
1/27/2017
1/20/2017
1/13/2017
1/6/2017
228.97
226.74
227.05
227.21
12/30/2016
12/23/2016
12/16/2016
12/9/2016
223.53
225.71
225.04
226.51
12/2/2016
219.68
11/25/2016
11/18/2016
11/11/2016
11/4/2016
221.52
218.5
216.42
208.55
10/28/2016
10/21/2016
10/14/2016
10/7/2016
212.54
213.98
213.12
215.04
9/30/2016
9/23/2016
9/16/2016
9/9/2016
9/2/2016
216.3
215.99
213.37
213.28
218.37
8/26/2016
8/19/2016
8/12/2016
8/5/2016
217.29
218.54
218.46
218.18
7/29/2016
217.12
7/22/2016
217.24
7/15/2016
215.83
7/8/2016
212.65
7/1/2016 209.9208
6/24/2016
6/17/2016
6/10/2016
6/3/2016
203.13
206.52
210.07
210.28
5/27/2016
5/20/2016
5/13/2016
5/6/2016
210.24
205.49
204.76
205.72
4/29/2016 206.3308
4/22/2016
208.97
4/15/2016
207.78
4/8/2016 204.4992
4/1/2016
206.92
3/25/2016
3/18/2016
203.12
204.38
3/11/2016
3/4/2016
202.76
200.43
2/26/2016 195.0892
2/19/2016
192
2/12/2016
186.63
2/5/2016
187.95
1/29/2016 193.7208
1/22/2016
190.52
1/15/2016
187.81
1/8/2016 191.923
1/1/2016
203.87
12/25/2015
205.68
12/18/2015 200.0208
12/11/2015
201.88
12/4/2015
209.62
11/27/2015
209.56
11/20/2015 209.3108
11/13/2015
202.54
11/6/2015
210.04
10/30/2015
10/23/2015
10/16/2015
10/9/2015
10/2/2015
207.93
207.51
203.27
201.33
195
9/25/2015
9/18/2015
9/11/2015
9/4/2015
192.85
195.45
196.74
192.59
8/28/2015
8/21/2015
8/14/2015
8/7/2015
199.28
197.83
209.42
207.95
7/31/2015
7/24/2015
7/17/2015
7/10/2015
7/3/2015
210.5
208
212.48
207.48
207.31
6/26/2015
209.82
6/19/2015
6/12/2015
6/5/2015
210.81
210.01
209.77
5/29/2015
5/22/2015
5/15/2015
5/8/2015
5/1/2015
211.14
212.99
212.44
211.62
210.72
4/24/2015 211.6499
4/17/2015
207.95
4/10/2015
210.04
4/3/2015 206.435
3/27/2015
205.74
3/20/2015
210.41
3/13/2015 205.8272
3/6/2015
207.5
2/27/2015
2/20/2015
2/13/2015
2/6/2015
210.66
211.239
209.78
205.55
1/30/2015
1/23/2015
1/16/2015
1/9/2015
1/2/2015
199.45
204.97
201.63
204.25
205.43
12/26/2014
12/19/2014
12/12/2014
12/5/2014
208.44
206.52
200.89
208
11/28/2014
11/21/2014
11/14/2014
11/7/2014
207.2
206.68
204.24
203.34
10/31/2014
10/24/2014
10/17/2014
10/10/2014
10/3/2014
201.66
196.43
188.47
190.54
196.52
9/26/2014
9/19/2014
9/12/2014
9/5/2014
197.9
200.7
199.13
201.11
8/29/2014
8/22/2014
8/15/2014
8/8/2014
8/1/2014
200.71
199.19
195.72
193.24
192.5
7/25/2014
197.72
7/18/2014 197.7099
7/11/2014
196.61
7/4/2014
198.2
6/27/2014
6/20/2014
6/13/2014
6/6/2014
195.82
195.94
194.13
195.375
5/30/2014
5/23/2014
5/16/2014
5/9/2014
5/2/2014
192.68
190.35
188.05
187.96
188.06
4/25/2014
4/18/2014
4/11/2014
4/4/2014
186.29
186.39
181.51
186.4
3/28/2014
3/21/2014
3/14/2014
3/7/2014
185.49
186.2
184.66
188.26
2/28/2014
2/21/2014
2/14/2014
2/7/2014
186.29
183.89
184.02
179.68
1/31/2014
1/24/2014
1/17/2014
1/10/2014
1/3/2014
178.18
178.89
183.635
184.14
182.885
12/27/2013
12/20/2013
12/13/2013
12/6/2013
183.845
181.56
178.11
180.94
11/29/2013
11/22/2013
11/15/2013
11/8/2013
11/1/2013
181
180.81
180.05
177.29
176.21
10/25/2013
10/18/2013
10/11/2013
10/4/2013
175.95
174.388
170.26
168.89
9/27/2013
9/20/2013
9/13/2013
9/6/2013
168.909
170.72
169.33
166.04
8/30/2013
8/23/2013
8/16/2013
8/9/2013
8/2/2013
163.65
166.62
165.83
169.31
170.95
7/26/2013
7/19/2013
7/12/2013
7/5/2013
169.11
169.17
167.51
163.02
6/28/2013
6/21/2013
6/14/2013
6/7/2013
160.42
159.07
163.175
164.8
5/31/2013
5/24/2013
5/17/2013
5/10/2013
5/3/2013
163.445
165.308
166.94
163.41
161.368
4/26/2013
4/19/2013
4/12/2013
158.24
155.48
158.8
4/5/2013
155.158
3/29/2013
3/22/2013
3/15/2013
3/8/2013
3/1/2013
156.67
155.6
155.83
155.44
152.11
2/22/2013
2/15/2013
2/8/2013
2/1/2013
151.89
152.11
151.8
151.24
1/25/2013
1/18/2013
1/11/2013
1/4/2013
150.25
148.33
147.07
146.37
12/28/2012
140.03
12/21/2012
142.79
12/14/2012 142.1051
12/7/2012 142.415
11/30/2012
11/23/2012
11/16/2012
11/9/2012
11/2/2012
142.155
141.35
136.37
138.16
141.56
10/26/2012
141.35
10/19/2012 143.3896
10/12/2012
142.89
10/5/2012
146.14
9/28/2012
9/21/2012
9/14/2012
9/7/2012
143.97
145.87
147.24
144.33
8/31/2012
8/24/2012
8/17/2012
8/10/2012
8/3/2012
141.16
141.51
142.18
140.84
139.349
7/27/2012
7/20/2012
138.675
136.47
7/13/2012
7/6/2012
135.75
135.49
6/29/2012
6/22/2012
6/15/2012
6/8/2012
6/1/2012
136.105
133.46
134.14
133.1
128.16
5/25/2012
5/18/2012
5/11/2012
5/4/2012
132.1
129.74
135.61
137
4/27/2012
4/20/2012
4/13/2012
4/6/2012
140.39
137.95
137.14
139.79
3/30/2012
3/23/2012
3/16/2012
3/9/2012
3/2/2012
140.81
139.65
140.3
137.57
137.312
2/24/2012
2/17/2012
2/10/2012
2/3/2012
136.93
136.41
134.361
134.54
1/27/2012
1/20/2012
1/13/2012
1/6/2012
131.82
131.54
128.84
127.71
12/30/2011
12/23/2011
12/16/2011
12/9/2011
12/2/2011
125.5
126.39
121.59
126.05
124.86
11/25/2011
11/18/2011
11/11/2011
11/4/2011
116.34
121.979
126.66
125.481
10/28/2011
128.6
10/21/2011
10/14/2011
10/7/2011
123.97
122.57
115.71
9/30/2011
9/23/2011
9/16/2011
9/9/2011
9/2/2011
113.15
113.54
121.521
115.92
117.85
8/26/2011
8/19/2011
8/12/2011
8/5/2011
117.97
112.64
118.12
120.08
7/29/2011
7/22/2011
7/15/2011
7/8/2011
7/1/2011
129.33
134.58
131.69
134.4
133.92
6/24/2011
6/17/2011
6/10/2011
6/3/2011
126.81
127.05
127.6
130.42
5/27/2011
5/20/2011
5/13/2011
5/6/2011
133.51
133.61
134.04
134.2
4/29/2011
4/22/2011
4/15/2011
4/8/2011
4/1/2011
136.43
133.78
132.04
132.86
133.15
3/25/2011
3/18/2011
3/11/2011
3/4/2011
131.3
127.76
130.84
132.47
2/25/2011
2/18/2011
2/11/2011
2/4/2011
132.33
134.53
133.11
131.15
1/28/2011
1/21/2011
1/14/2011
1/7/2011
127.72
128.37
129.3
127.14
12/31/2010
12/24/2010
12/17/2010
12/10/2010
12/3/2010
125.75
125.6
124.3
124.48
122.89
11/26/2010
11/19/2010
11/12/2010
11/5/2010
118.8
120.29
120.198
122.725
10/29/2010
118.49
10/22/2010 118.347
10/15/2010
117.7
10/8/2010 116.5375
10/1/2010
114.61
9/24/2010
9/17/2010
9/10/2010
9/3/2010
114.82
112.49
111.482
110.89
8/27/2010
8/20/2010
8/13/2010
8/6/2010
106.86
107.53
108.31
112.392
7/30/2010
7/23/2010
7/16/2010
7/9/2010
7/2/2010
110.27
110.41
106.66
107.96
102.2
6/25/2010 107.8675
6/18/2010 111.729
6/11/2010
109.68
6/4/2010
106.82
5/28/2010
5/21/2010
5/14/2010
5/7/2010
109.369
109.115
113.89
111.26
4/30/2010 118.8125
4/23/2010 121.8125
4/16/2010
119.36
4/9/2010
119.55
4/2/2010
117.8
3/26/2010
3/19/2010
3/12/2010
3/5/2010
116.582
115.97
115.46
114.25
2/26/2010
2/19/2010
2/12/2010
2/5/2010
110.74
111.14
108.04
106.66
1/29/2010
1/22/2010
1/15/2010
1/8/2010
1/1/2010
107.39
109.21
113.64
114.57
111.44
12/25/2009
12/18/2009
12/11/2009
12/4/2009
112.48
110.21
111.11
111.01
11/27/2009
11/20/2009
11/13/2009
11/6/2009
109.57
109.43
109.62
107.13
10/30/2009
10/23/2009
10/16/2009
10/9/2009
10/2/2009
103.56
108.08
108.89
107.26
102.49
9/25/2009
104.45
Purchase answer to see full
attachment