Apple Inc

profileesolutions
apple_inc_q1.xls

MAIN

your name here
output
1) RATIO ANALYSIS Profit Margin 0.000
Return on Assets 0.000
Price/Earnings 0.000
Market/Book 0.000
Price per Share 126.200
as of (date) 15-Apr-15
output
2) CAPITAL BUDGETING Net Present Value 0.0
Modified IRR 0.000
3) PORTFOLIO MANAGEMENT See PORT tab Portfolio YHOO GE MMM ^GSPC
std dev 0.00000 0.00000 0.00000 0.00000 0.00000
total K 0.00000 0.00000 0.00000 0.00000 0.00000
4) HYPERBOLA std dev 0.00000 0.00000 0.00000
total K 0.00000 0.00000 0.00000
5) CAPM & BETA Portfolio YHOO GE MMM ^GSPC
beta 0.000 0.000 0.000 0.000 0.000
6) VALUATION STOCKS: price (pps) 0.00
BONDS: PV of PMTS 0.00
PV of FV 0.00
Value 0.00
Continuous Comp FV 0.00
Payments 0.00
period Begin'g interest$ PMTS Red'n Ending
Balance Balance Balance
1 22695.00 0.00 0.00 0.00 0.00
2 0.00 0.00 0.00 0.00 0.00
3 0.00 0.00 0.00 0.00 0.00
7) Black-Scholes Option Pricing Model
ln (S/K)= 0.0000
(r+σ^2/2)T 0.0000
σ*T^1/2 0.0000
d1= 0.0000
d2= 0.0000
N(d1)= 0.0000
N(d2)= 0.0000
discounted strike price 0.00
C=SN(d1)-dspN(d2) 0.00
8) Currency Exchange Rates US$ ¥ £ C$ Ps
US$ 1.00000 0.00000 0.00000 0.00000 0.00000 0.00000
0.67020 0.00000 0.00000 0.00000 0.00000 0.00000
¥ 89.67000 0.00000 0.00000 0.00000 0.00000 0.00000
£ 0.59900 0.00000 0.00000 0.00000 0.00000 0.00000
C$ 1.05000 0.00000 0.00000 0.00000 0.00000 0.00000
Ps 13.03950 0.00000 0.00000 0.00000 0.00000 0.00000
Premium/discount
1-mos forward 0.0000
3-mos forward 0.0000
6-mos forward 0.0000
$$$$$ END OF FILE $$$$$$$$$$$ END OF FINAL $$$$$$$$
Comment: This was the hardest course I have yet to take and for that I am grateful. It made me reach well beyond my comfort zone, which is always a good thing. Thank you. Gwen

RATIO

Ratio Analysis Worksheet
inputs
Sales
Net Income
Total Assets
Shareholders Equity
Market Capitalization
Stock Price
Earnings per Share
date of inputs
outputs
Profit Margin <= Blue cells should automatically copy to "MAIN" tab
Return on Assets
Price/Earnings
Market/Book
Price per Share 126.2
as of (date) 15-Apr-15

CAP BUD

Capital Budgeting Worksheet
output
Net Present Value <= set B4 =B12
Modified IRR <= set B5 =B17
discount rate 0.155 input
years 0 1 2 3 4 5
cash flows -300 120 130 140 150 160
discount factors
present values
Net Present Value
reinvestment factors
future values
terminal value
IRR*
Note: Use a fixed discount rate for all years, NOT ascending rates.

PORT

Portfolio Worksheet Yahoo GenlElect 3M Co S&P500 This is the HYPERBOLA section: CLX NSRGY.PK CLX NSRGY.PK CLX NSRGY.PK
Portfolio YHOO GE MMM ^GSPC Portfolio Clorox Nestlé Portfolio Clorox Nestlé Portfolio Clorox Nestlé
No. of shares 2000 6500 700 # of shares 900 2760 900 2760 900 2760
30-Jun-06 33.00 32.96 80.77 1270.20 Portfolios with different mixes 12/31/08 55.56 39.7 55.56 39.7 55.56 39.7
3-Jul-06 33.30 33.33 81.12 1280.19 100/0 50/50 0/100 1/2/09 56.37 39.45 56.37 39.45 56.37 39.45
5-Jul-06 32.47 33.31 80.55 1270.91 std dev 1/5/09 56.23 38.4 56.23 38.4 56.23 38.4
6-Jul-06 33.11 33.50 81.39 1274.08 total K 1/6/09 55.53 38 55.53 38 55.53 38
7-Jul-06 32.50 33.30 74.10 1265.48 1/7/09 54.62 38.35 54.62 38.35 54.62 38.35
10-Jul-06 32.85 33.45 73.11 1267.34 Use this space for calculating the normalized 1/8/09 54.44 38.55 54.44 38.55 54.44 38.55
30-Jun-06 1270.20 number of shares for clorox and nestles 1/9/09 52.9 36.25 52.9 36.25 52.9 36.25
3-Jul-06 1280.19 Use =10000/average pps 1/12/09 52.67 36.2 52.67 36.2 52.67 36.2
5-Jul-06 Fill in formulas for Market Value 1270.91 1/13/09 52.53 36.19 52.53 36.19 52.53 36.19
6-Jul-06 1274.08 1/14/09 51.41 35.3 51.41 35.3 51.41 35.3
7-Jul-06 1265.48 1/15/09 50.93 35.85 50.93 35.85 50.93 35.85
10-Jul-06 1267.34 1/16/09 51.36 36.54 51.36 36.54 51.36 36.54
30-Jun-06 these cells intentionally blank 1/20/09 50.3 35.43 50.3 35.43 50.3 35.43
3-Jul-06 1/21/09 51.03 35.9 51.03 35.9 51.03 35.9
5-Jul-06 1/22/09 51.52 35.35 51.52 35.35 51.52 35.35
6-Jul-06 Fill in formulas for Daily Returns 1/23/09 49.57 35.1 49.57 35.1 49.57 35.1
7-Jul-06 1/26/09 48.51 35.53 48.51 35.53 48.51 35.53
10-Jul-06 1/27/09 48.91 35.6 48.91 35.6 48.91 35.6
1/28/09 49.83 35 49.83 35 49.83 35
std dev 1/29/09 50.45 34.52 50.45 34.52 50.45 34.52
total K 1/30/09 50.15 34.45 50.15 34.45 50.15 34.45
2/2/09 50.43 34 50.43 34 50.43 34
beta 2/3/09 51.82 35.21 51.82 35.21 51.82 35.21
2/4/09 52.7 33.79 52.7 33.79 52.7 33.79
2/5/09 53.13 32.76 53.13 32.76 53.13 32.76
2/6/09 54.07 32.84 54.07 32.84 54.07 32.84
2/9/09 53.82 32.83 53.82 32.83 53.82 32.83
2/10/09 51.94 32.95 51.94 32.95 51.94 32.95
2/11/09 52.43 32.55 52.43 32.55 52.43 32.55
2/12/09 52.01 32.5 52.01 32.5 52.01 32.5
2/13/09 51.98 32.06 51.98 32.06 51.98 32.06
2/17/09 49.87 31.45 49.87 31.45 49.87 31.45
2/18/09 49.99 31.37 49.99 31.37 49.99 31.37
2/19/09 50.27 32.67 50.27 32.67 50.27 32.67
2/20/09 49.71 33.8 49.71 33.8 49.71 33.8
2/23/09 48.47 32.46 48.47 32.46 48.47 32.46
2/24/09 49.41 33.37 49.41 33.37 49.41 33.37
2/25/09 49.15 32.84 49.15 32.84 49.15 32.84
2/26/09 48.22 32.2 48.22 32.2 48.22 32.2
2/27/09 48.6 32.51 48.6 32.51 48.6 32.51
3/2/09 47.34 31.05 47.34 31.05 47.34 31.05
3/3/09 47.2 29.86 47.2 29.86 47.2 29.86
3/4/09 47.51 31.05 47.51 31.05 47.51 31.05
3/5/09 46.04 30.25 46.04 30.25 46.04 30.25
3/6/09 46.78 30.94 46.78 30.94 46.78 30.94
3/9/09 45.9 30.3 45.9 30.3 45.9 30.3
3/10/09 47.79 31.7 47.79 31.7 47.79 31.7
3/11/09 48.14 31.69 48.14 31.69 48.14 31.69
3/12/09 49.58 31.33 49.58 31.33 49.58 31.33
3/13/09 50.45 31.55 50.45 31.55 50.45 31.55
3/16/09 50.76 31.5 50.76 31.5 50.76 31.5
3/17/09 51.42 31.8 51.42 31.8 51.42 31.8
3/18/09 51.62 32.3 51.62 32.3 51.62 32.3
3/19/09 49.72 32.08 49.72 32.08 49.72 32.08
3/20/09 49.45 31.3 49.45 31.3 49.45 31.3
3/23/09 51.38 33.07 51.38 33.07 51.38 33.07
3/24/09 50.98 33.1 50.98 33.1 50.98 33.1
3/25/09 51.23 34.06 51.23 34.06 51.23 34.06
3/26/09 52.1 34.2 52.1 34.2 52.1 34.2
3/27/09 51.7 33.02 51.7 33.02 51.7 33.02
3/30/09 50.97 32.53 50.97 32.53 50.97 32.53
3/31/09 51.48 33.55 51.48 33.55 51.48 33.55
4/1/09 51.87 34.31 51.87 34.31 51.87 34.31
4/2/09 53.41 34.5 53.41 34.5 53.41 34.5
4/3/09 53.31 34.2 53.31 34.2 53.31 34.2
4/6/09 53.42 34.65 53.42 34.65 53.42 34.65
4/7/09 52.38 34.86 52.38 34.86 52.38 34.86
4/8/09 53.85 34.5 53.85 34.5 53.85 34.5
4/9/09 54.08 34.25 54.08 34.25 54.08 34.25
4/13/09 53.14 34.65 53.14 34.65 53.14 34.65
4/14/09 52.95 34.26 52.95 34.26 52.95 34.26
4/15/09 53.81 34.1 53.81 34.1 53.81 34.1
4/16/09 55.18 33.75 55.18 33.75 55.18 33.75
4/17/09 55.9 32.75 55.9 32.75 55.9 32.75
4/20/09 55.6 32.3 55.6 32.3 55.6 32.3
4/21/09 55.82 32.5 55.82 32.5 55.82 32.5
4/22/09 55.96 32.14 55.96 32.14 55.96 32.14
4/23/09 55.68 32.32 55.68 32.32 55.68 32.32
4/24/09 56.03 32.05 56.03 32.05 56.03 32.05
4/27/09 55.73 31.9 55.73 31.9 55.73 31.9
4/28/09 55.66 31.9 55.66 31.9 55.66 31.9
4/29/09 55.95 32.9 55.95 32.9 55.95 32.9
4/30/09 56.05 32.45 56.05 32.45 56.05 32.45
5/1/09 55.3 32.6 55.3 32.6 55.3 32.6
5/4/09 54.22 34.62 54.22 34.62 54.22 34.62
5/5/09 53.94 34.13 53.94 34.13 53.94 34.13
5/6/09 53.34 34.5 53.34 34.5 53.34 34.5
5/7/09 52.74 34.65 52.74 34.65 52.74 34.65
5/8/09 52.42 35.65 52.42 35.65 52.42 35.65
5/11/09 52.15 35.37 52.15 35.37 52.15 35.37
5/12/09 52 36.28 52 36.28 52 36.28
5/13/09 51.4 36.44 51.4 36.44 51.4 36.44
5/14/09 50.44 36.78 50.44 36.78 50.44 36.78
5/15/09 51.11 35.85 51.11 35.85 51.11 35.85
5/18/09 52.08 36.45 52.08 36.45 52.08 36.45
5/19/09 52.37 36.38 52.37 36.38 52.37 36.38
5/20/09 52.43 36.6 52.43 36.6 52.43 36.6
5/21/09 51.49 36.49 51.49 36.49 51.49 36.49
5/22/09 51.11 36.71 51.11 36.71 51.11 36.71
5/26/09 52.03 37.05 52.03 37.05 52.03 37.05
5/27/09 51.32 36.1 51.32 36.1 51.32 36.1
5/28/09 51.59 36.25 51.59 36.25 51.59 36.25
5/29/09 52.44 36.47 52.44 36.47 52.44 36.47
6/1/09 52.58 36.93 52.58 36.93 52.58 36.93
6/2/09 53.38 37.14 53.38 37.14 53.38 37.14
6/3/09 53.07 36.95 53.07 36.95 53.07 36.95
6/4/09 52.84 37.38 52.84 37.38 52.84 37.38
6/5/09 52.94 35.79 52.94 35.79 52.94 35.79
6/8/09 53.77 36.21 53.77 36.21 53.77 36.21
6/9/09 53.67 36.58 53.67 36.58 53.67 36.58
6/10/09 53.49 36.3 53.49 36.3 53.49 36.3
6/11/09 53.65 36.7 53.65 36.7 53.65 36.7
6/12/09 56.39 36.44 56.39 36.44 56.39 36.44
6/15/09 55.98 35.63 55.98 35.63 55.98 35.63
6/16/09 55.56 35.75 55.56 35.75 55.56 35.75
6/17/09 56.32 36.1 56.32 36.1 56.32 36.1
6/18/09 56.68 36.25 56.68 36.25 56.68 36.25
6/19/09 56.07 37.05 56.07 37.05 56.07 37.05
6/22/09 55.96 36.84 55.96 36.84 55.96 36.84
6/23/09 55.29 38.29 55.29 38.29 55.29 38.29
6/24/09 55.46 37.4 55.46 37.4 55.46 37.4
6/25/09 56.33 37.51 56.33 37.51 56.33 37.51
6/26/09 55.91 37.74 55.91 37.74 55.91 37.74
6/29/09 56.53 37.95 56.53 37.95 56.53 37.95
6/30/09 55.83 37.62 55.83 37.62 55.83 37.62
7/1/09 56.59 38.55 56.59 38.55 56.59 38.55
7/2/09 55.97 37.8 55.97 37.8 55.97 37.8
7/6/09 56.81 38.05 56.81 38.05 56.81 38.05
7/7/09 56.33 37.76 56.33 37.76 56.33 37.76
7/8/09 56.41 37.7 56.41 37.7 56.41 37.7
7/9/09 56.37 38.11 56.37 38.11 56.37 38.11
7/10/09 56.3 37.73 56.3 37.73 56.3 37.73
7/13/09 57.37 38.5 57.37 38.5 57.37 38.5
7/14/09 57.41 38.07 57.41 38.07 57.41 38.07
7/15/09 57.77 39.51 57.77 39.51 57.77 39.51
7/16/09 57.83 40 57.83 40 57.83 40
7/17/09 58.09 40.4 58.09 40.4 58.09 40.4
7/20/09 58.61 40.14 58.61 40.14 58.61 40.14
7/21/09 58.74 40.19 58.74 40.19 58.74 40.19
7/22/09 59.3 40.25 59.3 40.25 59.3 40.25
7/23/09 59.77 40.11 59.77 40.11 59.77 40.11
7/24/09 59.66 39.9 59.66 39.9 59.66 39.9
7/27/09 59.53 40.35 59.53 40.35 59.53 40.35
7/28/09 60.1 40.64 60.1 40.64 60.1 40.64
7/29/09 60.26 40.09 60.26 40.09 60.26 40.09
7/30/09 60.79 40.6 60.79 40.6 60.79 40.6
7/31/09 61.01 41.08 61.01 41.08 61.01 41.08
8/3/09 59 41.27 59 41.27 59 41.27
8/4/09 58.75 41.12 58.75 41.12 58.75 41.12
8/5/09 58.04 40.74 58.04 40.74 58.04 40.74
8/6/09 57.03 41.08 57.03 41.08 57.03 41.08
8/7/09 57.88 40.85 57.88 40.85 57.88 40.85
8/10/09 57.54 40.45 57.54 40.45 57.54 40.45
8/11/09 57.63 40.8 57.63 40.8 57.63 40.8
8/12/09 58 39.45 58 39.45 58 39.45
8/13/09 58.04 38.78 58.04 38.78 58.04 38.78
8/14/09 57.68 39.41 57.68 39.41 57.68 39.41
8/17/09 57.22 38.82 57.22 38.82 57.22 38.82
8/18/09 57.2 39.15 57.2 39.15 57.2 39.15
8/19/09 57.74 40.27 57.74 40.27 57.74 40.27
8/20/09 58.18 40.35 58.18 40.35 58.18 40.35
8/21/09 58.69 41 58.69 41 58.69 41
8/24/09 58.49 40.9 58.49 40.9 58.49 40.9
8/25/09 58.98 40.6 58.98 40.6 58.98 40.6
8/26/09 59.26 40.3 59.26 40.3 59.26 40.3
8/27/09 59.08 40.54 59.08 40.54 59.08 40.54
8/28/09 58.82 40.32 58.82 40.32 58.82 40.32
8/31/09 59.09 41.45 59.09 41.45 59.09 41.45
9/1/09 58.38 41.1 58.38 41.1 58.38 41.1
9/2/09 58.16 41.1 58.16 41.1 58.16 41.1
9/3/09 58.17 40.8 58.17 40.8 58.17 40.8
9/4/09 58.59 41.01 58.59 41.01 58.59 41.01
9/8/09 58.88 41.75 58.88 41.75 58.88 41.75
9/9/09 58.35 41.56 58.35 41.56 58.35 41.56
9/10/09 58.79 41.75 58.79 41.75 58.79 41.75
9/11/09 57.66 42.06 57.66 42.06 57.66 42.06
9/14/09 57.82 42.4 57.82 42.4 57.82 42.4
9/15/09 57.25 41.8 57.25 41.8 57.25 41.8
9/16/09 57.35 42.45 57.35 42.45 57.35 42.45
9/17/09 57.06 42.6 57.06 42.6 57.06 42.6
9/18/09 57.93 43.02 57.93 43.02 57.93 43.02
9/21/09 57.66 42.93 57.66 42.93 57.66 42.93
9/22/09 59.14 42.76 59.14 42.76 59.14 42.76
9/23/09 58.77 42.89 58.77 42.89 58.77 42.89
9/24/09 58.74 42.5 58.74 42.5 58.74 42.5
9/25/09 58.65 42.68 58.65 42.68 58.65 42.68
9/28/09 58.95 42.43 58.95 42.43 58.95 42.43
9/29/09 58.52 42.44 58.52 42.44 58.52 42.44
9/30/09 58.82 42.69 58.82 42.69 58.82 42.69
10/1/09 57.64 42.12 57.64 42.12 57.64 42.12
10/2/09 57.6 41.72 57.6 41.72 57.6 41.72
10/5/09 56.89 42.07 56.89 42.07 56.89 42.07
10/6/09 57.1 42.62 57.1 42.62 57.1 42.62
10/7/09 57.32 42 57.32 42 57.32 42
10/8/09 58.87 42.08 58.87 42.08 58.87 42.08
10/9/09 58.69 41.63 58.69 41.63 58.69 41.63
10/12/09 58.6 42.65 58.6 42.65 58.6 42.65
10/13/09 58.55 42.75 58.55 42.75 58.55 42.75
10/14/09 58.24 43.01 58.24 43.01 58.24 43.01
10/15/09 58.4 43 58.4 43 58.4 43
10/16/09 58.17 42.61 58.17 42.61 58.17 42.61
10/19/09 58.23 44.3 58.23 44.3 58.23 44.3
10/20/09 58.14 44.83 58.14 44.83 58.14 44.83
10/21/09 57.84 45.15 57.84 45.15 57.84 45.15
10/22/09 59.38 46.51 59.38 46.51 59.38 46.51
10/23/09 59.14 46.05 59.14 46.05 59.14 46.05
10/26/09 58.25 45.65 58.25 45.65 58.25 45.65
10/27/09 58.06 46.25 58.06 46.25 58.06 46.25
10/28/09 57.99 45.8 57.99 45.8 57.99 45.8
10/29/09 58.83 47.05 58.83 47.05 58.83 47.05
10/30/09 59.23 46.52 59.23 46.52 59.23 46.52
11/2/09 59.4 47.05 59.4 47.05 59.4 47.05
11/3/09 58.66 46.23 58.66 46.23 58.66 46.23
11/4/09 58.84 46.31 58.84 46.31 58.84 46.31
11/5/09 59.47 47.2 59.47 47.2 59.47 47.2
11/6/09 59.93 46.88 59.93 46.88 59.93 46.88
11/9/09 61.18 47.62 61.18 47.62 61.18 47.62
11/10/09 60.66 47.96 60.66 47.96 60.66 47.96
11/11/09 60.34 47.68 60.34 47.68 60.34 47.68
11/12/09 59.71 46.7 59.71 46.7 59.71 46.7
11/13/09 59.74 46.97 59.74 46.97 59.74 46.97
11/16/09 60.04 47.51 60.04 47.51 60.04 47.51
11/17/09 60.21 47.55 60.21 47.55 60.21 47.55
11/18/09 60.7 47.8 60.7 47.8 60.7 47.8
11/19/09 59.85 47.25 59.85 47.25 59.85 47.25
11/20/09 59.65 47.11 59.65 47.11 59.65 47.11
11/23/09 60.31 47.73 60.31 47.73 60.31 47.73
11/24/09 60.39 47.87 60.39 47.87 60.39 47.87
11/25/09 60.46 48.88 60.46 48.88 60.46 48.88
11/27/09 60.05 48.34 60.05 48.34 60.05 48.34
11/30/09 60.27 47.42 60.27 47.42 60.27 47.42
12/1/09 60.73 48.52 60.73 48.52 60.73 48.52
12/2/09 61.24 49.07 61.24 49.07 61.24 49.07
12/3/09 61.13 49.64 61.13 49.64 61.13 49.64
12/4/09 61.4 49.27 61.4 49.27 61.4 49.27
12/7/09 61.05 48.86 61.05 48.86 61.05 48.86
12/8/09 61.3 47.5 61.3 47.5 61.3 47.5
12/9/09 61.89 47.71 61.89 47.71 61.89 47.71
12/10/09 61.97 48.52 61.97 48.52 61.97 48.52
12/11/09 62.58 48.48 62.58 48.48 62.58 48.48
12/14/09 62.66 48.39 62.66 48.39 62.66 48.39
12/15/09 62.49 48.18 62.49 48.18 62.49 48.18
12/16/09 61.84 48.05 61.84 48.05 61.84 48.05
12/17/09 61.6 47.44 61.6 47.44 61.6 47.44
12/18/09 61.4 48 61.4 48 61.4 48
12/21/09 61.76 48.18 61.76 48.18 61.76 48.18
12/22/09 61.88 48.71 61.88 48.71 61.88 48.71
12/23/09 61.85 49.1 61.85 49.1 61.85 49.1
12/24/09 61.89 49.21 61.89 49.21 61.89 49.21
12/28/09 61.93 48.88 61.93 48.88 61.93 48.88
12/29/09 61.84 49.03 61.84 49.03 61.84 49.03
12/30/09 61.58 48.28 61.58 48.28 61.58 48.28
12/31/09 61 48.56 61 48.56 61 48.56
12/31/08 159576 50004 109572 159576 50004 109572 159576 50004 109572
1/2/09 159615 50733 108882 159615 50733 108882 159615 50733 108882
1/5/09 156591 50607 105984 156591 50607 105984 156591 50607 105984
1/6/09 154857 49977 104880 154857 49977 104880 154857 49977 104880
1/7/09 155004 49158 105846 155004 49158 105846 155004 49158 105846
1/8/09 155394 48996 106398 155394 48996 106398 155394 48996 106398
1/9/09 147660 47610 100050 147660 47610 100050 147660 47610 100050
1/12/09 147315 47403 99912 147315 47403 99912 147315 47403 99912
1/13/09 147161.4 47277 99884.4 147161.4 47277 99884.4 147161.4 47277 99884.4
1/14/09 143697 46269 97428 143697 46269 97428 143697 46269 97428
1/15/09 144783 45837 98946 144783 45837 98946 144783 45837 98946
1/16/09 147074.4 46224 100850.4 147074.4 46224 100850.4 147074.4 46224 100850.4
1/20/09 143056.8 45270 97786.8 143056.8 45270 97786.8 143056.8 45270 97786.8
1/21/09 145011 45927 99084 145011 45927 99084 145011 45927 99084
1/22/09 143934 46368 97566 143934 46368 97566 143934 46368 97566
1/23/09 141489 44613 96876 141489 44613 96876 141489 44613 96876
1/26/09 141721.8 43659 98062.8 141721.8 43659 98062.8 141721.8 43659 98062.8
1/27/09 142275 44019 98256 142275 44019 98256 142275 44019 98256
1/28/09 141447 44847 96600 141447 44847 96600 141447 44847 96600
1/29/09 140680.2 45405 95275.2 140680.2 45405 95275.2 140680.2 45405 95275.2
1/30/09 140217 45135 95082 140217 45135 95082 140217 45135 95082
2/2/09 139227 45387 93840 139227 45387 93840 139227 45387 93840
2/3/09 143817.6 46638 97179.6 143817.6 46638 97179.6 143817.6 46638 97179.6
2/4/09 140690.4 47430 93260.4 140690.4 47430 93260.4 140690.4 47430 93260.4
2/5/09 138234.6 47817 90417.6 138234.6 47817 90417.6 138234.6 47817 90417.6
2/6/09 139301.4 48663 90638.4 139301.4 48663 90638.4 139301.4 48663 90638.4
2/9/09 139048.8 48438 90610.8 139048.8 48438 90610.8 139048.8 48438 90610.8
2/10/09 137688 46746 90942 137688 46746 90942 137688 46746 90942
2/11/09 137025 47187 89838 137025 47187 89838 137025 47187 89838
2/12/09 136509 46809 89700 136509 46809 89700 136509 46809 89700
2/13/09 135267.6 46782 88485.6 135267.6 46782 88485.6 135267.6 46782 88485.6
2/17/09 131685 44883 86802 131685 44883 86802 131685 44883 86802
2/18/09 131572.2 44991 86581.2 131572.2 44991 86581.2 131572.2 44991 86581.2
2/19/09 135412.2 45243 90169.2 135412.2 45243 90169.2 135412.2 45243 90169.2
2/20/09 138027 44739 93288 138027 44739 93288 138027 44739 93288
2/23/09 133212.6 43623 89589.6 133212.6 43623 89589.6 133212.6 43623 89589.6
2/24/09 136570.2 44469 92101.2 136570.2 44469 92101.2 136570.2 44469 92101.2
2/25/09 134873.4 44235 90638.4 134873.4 44235 90638.4 134873.4 44235 90638.4
2/26/09 132270 43398 88872 132270 43398 88872 132270 43398 88872
2/27/09 133467.6 43740 89727.6 133467.6 43740 89727.6 133467.6 43740 89727.6
3/2/09 128304 42606 85698 128304 42606 85698 128304 42606 85698
3/3/09 124893.6 42480 82413.6 124893.6 42480 82413.6 124893.6 42480 82413.6
3/4/09 128457 42759 85698 128457 42759 85698 128457 42759 85698
3/5/09 124926 41436 83490 124926 41436 83490 124926 41436 83490
3/6/09 127496.4 42102 85394.4 127496.4 42102 85394.4 127496.4 42102 85394.4
3/9/09 124938 41310 83628 124938 41310 83628 124938 41310 83628
3/10/09 130503 43011 87492 130503 43011 87492 130503 43011 87492
3/11/09 130790.4 43326 87464.4 130790.4 43326 87464.4 130790.4 43326 87464.4
3/12/09 131092.8 44622 86470.8 131092.8 44622 86470.8 131092.8 44622 86470.8
3/13/09 132483 45405 87078 132483 45405 87078 132483 45405 87078
3/16/09 132624 45684 86940 132624 45684 86940 132624 45684 86940
3/17/09 134046 46278 87768 134046 46278 87768 134046 46278 87768
3/18/09 135606 46458 89148 135606 46458 89148 135606 46458 89148
3/19/09 133288.8 44748 88540.8 133288.8 44748 88540.8 133288.8 44748 88540.8
3/20/09 130893 44505 86388 130893 44505 86388 130893 44505 86388
3/23/09 137515.2 46242 91273.2 137515.2 46242 91273.2 137515.2 46242 91273.2
3/24/09 137238 45882 91356 137238 45882 91356 137238 45882 91356
3/25/09 140112.6 46107 94005.6 140112.6 46107 94005.6 140112.6 46107 94005.6
3/26/09 141282 46890 94392 141282 46890 94392 141282 46890 94392
3/27/09 137665.2 46530 91135.2 137665.2 46530 91135.2 137665.2 46530 91135.2
3/30/09 135655.8 45873 89782.8 135655.8 45873 89782.8 135655.8 45873 89782.8
3/31/09 138930 46332 92598 138930 46332 92598 138930 46332 92598
4/1/09 141378.6 46683 94695.6 141378.6 46683 94695.6 141378.6 46683 94695.6
4/2/09 143289 48069 95220 143289 48069 95220 143289 48069 95220
4/3/09 142371 47979 94392 142371 47979 94392 142371 47979 94392
4/6/09 143712 48078 95634 143712 48078 95634 143712 48078 95634
4/7/09 143355.6 47142 96213.6 143355.6 47142 96213.6 143355.6 47142 96213.6
4/8/09 143685 48465 95220 143685 48465 95220 143685 48465 95220
4/9/09 143202 48672 94530 143202 48672 94530 143202 48672 94530
4/13/09 143460 47826 95634 143460 47826 95634 143460 47826 95634
4/14/09 142212.6 47655 94557.6 142212.6 47655 94557.6 142212.6 47655 94557.6
4/15/09 142545 48429 94116 142545 48429 94116 142545 48429 94116
4/16/09 142812 49662 93150 142812 49662 93150 142812 49662 93150
4/17/09 140700 50310 90390 140700 50310 90390 140700 50310 90390
4/20/09 139188 50040 89148 139188 50040 89148 139188 50040 89148
4/21/09 139938 50238 89700 139938 50238 89700 139938 50238 89700
4/22/09 139070.4 50364 88706.4 139070.4 50364 88706.4 139070.4 50364 88706.4
4/23/09 139315.2 50112 89203.2 139315.2 50112 89203.2 139315.2 50112 89203.2
4/24/09 138885 50427 88458 138885 50427 88458 138885 50427 88458
4/27/09 138201 50157 88044 138201 50157 88044 138201 50157 88044
4/28/09 138138 50094 88044 138138 50094 88044 138138 50094 88044
4/29/09 141159 50355 90804 141159 50355 90804 141159 50355 90804
4/30/09 140007 50445 89562 140007 50445 89562 140007 50445 89562
5/1/09 139746 49770 89976 139746 49770 89976 139746 49770 89976
5/4/09 144349.2 48798 95551.2 144349.2 48798 95551.2 144349.2 48798 95551.2
5/5/09 142744.8 48546 94198.8 142744.8 48546 94198.8 142744.8 48546 94198.8
5/6/09 143226 48006 95220 143226 48006 95220 143226 48006 95220
5/7/09 143100 47466 95634 143100 47466 95634 143100 47466 95634
5/8/09 145572 47178 98394 145572 47178 98394 145572 47178 98394
5/11/09 144556.2 46935 97621.2 144556.2 46935 97621.2 144556.2 46935 97621.2
5/12/09 146932.8 46800 100132.8 146932.8 46800 100132.8 146932.8 46800 100132.8
5/13/09 146834.4 46260 100574.4 146834.4 46260 100574.4 146834.4 46260 100574.4
5/14/09 146908.8 45396 101512.8 146908.8 45396 101512.8 146908.8 45396 101512.8
5/15/09 144945 45999 98946 144945 45999 98946 144945 45999 98946
5/18/09 147474 46872 100602 147474 46872 100602 147474 46872 100602
5/19/09 147541.8 47133 100408.8 147541.8 47133 100408.8 147541.8 47133 100408.8
5/20/09 148203 47187 101016 148203 47187 101016 148203 47187 101016
5/21/09 147053.4 46341 100712.4 147053.4 46341 100712.4 147053.4 46341 100712.4
5/22/09 147318.6 45999 101319.6 147318.6 45999 101319.6 147318.6 45999 101319.6
5/26/09 149085 46827 102258 149085 46827 102258 149085 46827 102258
5/27/09 145824 46188 99636 145824 46188 99636 145824 46188 99636
5/28/09 146481 46431 100050 146481 46431 100050 146481 46431 100050
5/29/09 147853.2 47196 100657.2 147853.2 47196 100657.2 147853.2 47196 100657.2
6/1/09 149248.8 47322 101926.8 149248.8 47322 101926.8 149248.8 47322 101926.8
6/2/09 150548.4 48042 102506.4 150548.4 48042 102506.4 150548.4 48042 102506.4
6/3/09 149745 47763 101982 149745 47763 101982 149745 47763 101982
6/4/09 150724.8 47556 103168.8 150724.8 47556 103168.8 150724.8 47556 103168.8
6/5/09 146426.4 47646 98780.4 146426.4 47646 98780.4 146426.4 47646 98780.4
6/8/09 148332.6 48393 99939.6 148332.6 48393 99939.6 148332.6 48393 99939.6
6/9/09 149263.8 48303 100960.8 149263.8 48303 100960.8 149263.8 48303 100960.8
6/10/09 148329 48141 100188 148329 48141 100188 148329 48141 100188
6/11/09 149577 48285 101292 149577 48285 101292 149577 48285 101292
6/12/09 151325.4 50751 100574.4 151325.4 50751 100574.4 151325.4 50751 100574.4
6/15/09 148720.8 50382 98338.8 148720.8 50382 98338.8 148720.8 50382 98338.8
6/16/09 148674 50004 98670 148674 50004 98670 148674 50004 98670
6/17/09 150324 50688 99636 150324 50688 99636 150324 50688 99636
6/18/09 151062 51012 100050 151062 51012 100050 151062 51012 100050
6/19/09 152721 50463 102258 152721 50463 102258 152721 50463 102258
6/22/09 152042.4 50364 101678.4 152042.4 50364 101678.4 152042.4 50364 101678.4
6/23/09 155441.4 49761 105680.4 155441.4 49761 105680.4 155441.4 49761 105680.4
6/24/09 153138 49914 103224 153138 49914 103224 153138 49914 103224
6/25/09 154224.6 50697 103527.6 154224.6 50697 103527.6 154224.6 50697 103527.6
6/26/09 154481.4 50319 104162.4 154481.4 50319 104162.4 154481.4 50319 104162.4
6/29/09 155619 50877 104742 155619 50877 104742 155619 50877 104742
6/30/09 154078.2 50247 103831.2 154078.2 50247 103831.2 154078.2 50247 103831.2
7/1/09 157329 50931 106398 157329 50931 106398 157329 50931 106398
7/2/09 154701 50373 104328 154701 50373 104328 154701 50373 104328
7/6/09 156147 51129 105018 156147 51129 105018 156147 51129 105018
7/7/09 154914.6 50697 104217.6 154914.6 50697 104217.6 154914.6 50697 104217.6
7/8/09 154821 50769 104052 154821 50769 104052 154821 50769 104052
7/9/09 155916.6 50733 105183.6 155916.6 50733 105183.6 155916.6 50733 105183.6
7/10/09 154804.8 50670 104134.8 154804.8 50670 104134.8 154804.8 50670 104134.8
7/13/09 157893 51633 106260 157893 51633 106260 157893 51633 106260
7/14/09 156742.2 51669 105073.2 156742.2 51669 105073.2 156742.2 51669 105073.2
7/15/09 161040.6 51993 109047.6 161040.6 51993 109047.6 161040.6 51993 109047.6
7/16/09 162447 52047 110400 162447 52047 110400 162447 52047 110400
7/17/09 163785 52281 111504 163785 52281 111504 163785 52281 111504
7/20/09 163535.4 52749 110786.4 163535.4 52749 110786.4 163535.4 52749 110786.4
7/21/09 163790.4 52866 110924.4 163790.4 52866 110924.4 163790.4 52866 110924.4
7/22/09 164460 53370 111090 164460 53370 111090 164460 53370 111090
7/23/09 164496.6 53793 110703.6 164496.6 53793 110703.6 164496.6 53793 110703.6
7/24/09 163818 53694 110124 163818 53694 110124 163818 53694 110124
7/27/09 164943 53577 111366 164943 53577 111366 164943 53577 111366
7/28/09 166256.4 54090 112166.4 166256.4 54090 112166.4 166256.4 54090 112166.4
7/29/09 164882.4 54234 110648.4 164882.4 54234 110648.4 164882.4 54234 110648.4
7/30/09 166767 54711 112056 166767 54711 112056 166767 54711 112056
7/31/09 168289.8 54909 113380.8 168289.8 54909 113380.8 168289.8 54909 113380.8
8/3/09 167005.2 53100 113905.2 167005.2 53100 113905.2 167005.2 53100 113905.2
8/4/09 166366.2 52875 113491.2 166366.2 52875 113491.2 166366.2 52875 113491.2
8/5/09 164678.4 52236 112442.4 164678.4 52236 112442.4 164678.4 52236 112442.4
8/6/09 164707.8 51327 113380.8 164707.8 51327 113380.8 164707.8 51327 113380.8
8/7/09 164838 52092 112746 164838 52092 112746 164838 52092 112746
8/10/09 163428 51786 111642 163428 51786 111642 163428 51786 111642
8/11/09 164475 51867 112608 164475 51867 112608 164475 51867 112608
8/12/09 161082 52200 108882 161082 52200 108882 161082 52200 108882
8/13/09 159268.8 52236 107032.8 159268.8 52236 107032.8 159268.8 52236 107032.8
8/14/09 160683.6 51912 108771.6 160683.6 51912 108771.6 160683.6 51912 108771.6
8/17/09 158641.2 51498 107143.2 158641.2 51498 107143.2 158641.2 51498 107143.2
8/18/09 159534 51480 108054 159534 51480 108054 159534 51480 108054
8/19/09 163111.2 51966 111145.2 163111.2 51966 111145.2 163111.2 51966 111145.2
8/20/09 163728 52362 111366 163728 52362 111366 163728 52362 111366
8/21/09 165981 52821 113160 165981 52821 113160 165981 52821 113160
8/24/09 165525 52641 112884 165525 52641 112884 165525 52641 112884
8/25/09 165138 53082 112056 165138 53082 112056 165138 53082 112056
8/26/09 164562 53334 111228 164562 53334 111228 164562 53334 111228
8/27/09 165062.4 53172 111890.4 165062.4 53172 111890.4 165062.4 53172 111890.4
8/28/09 164221.2 52938 111283.2 164221.2 52938 111283.2 164221.2 52938 111283.2
8/31/09 167583 53181 114402 167583 53181 114402 167583 53181 114402
9/1/09 165978 52542 113436 165978 52542 113436 165978 52542 113436
9/2/09 165780 52344 113436 165780 52344 113436 165780 52344 113436
9/3/09 164961 52353 112608 164961 52353 112608 164961 52353 112608
9/4/09 165918.6 52731 113187.6 165918.6 52731 113187.6 165918.6 52731 113187.6
9/8/09 168222 52992 115230 168222 52992 115230 168222 52992 115230
9/9/09 167220.6 52515 114705.6 167220.6 52515 114705.6 167220.6 52515 114705.6
9/10/09 168141 52911 115230 168141 52911 115230 168141 52911 115230
9/11/09 167979.6 51894 116085.6 167979.6 51894 116085.6 167979.6 51894 116085.6
9/14/09 169062 52038 117024 169062 52038 117024 169062 52038 117024
9/15/09 166893 51525 115368 166893 51525 115368 166893 51525 115368
9/16/09 168777 51615 117162 168777 51615 117162 168777 51615 117162
9/17/09 168930 51354 117576 168930 51354 117576 168930 51354 117576
9/18/09 170872.2 52137 118735.2 170872.2 52137 118735.2 170872.2 52137 118735.2
9/21/09 170380.8 51894 118486.8 170380.8 51894 118486.8 170380.8 51894 118486.8
9/22/09 171243.6 53226 118017.6 171243.6 53226 118017.6 171243.6 53226 118017.6
9/23/09 171269.4 52893 118376.4 171269.4 52893 118376.4 171269.4 52893 118376.4
9/24/09 170166 52866 117300 170166 52866 117300 170166 52866 117300
9/25/09 170581.8 52785 117796.8 170581.8 52785 117796.8 170581.8 52785 117796.8
9/28/09 170161.8 53055 117106.8 170161.8 53055 117106.8 170161.8 53055 117106.8
9/29/09 169802.4 52668 117134.4 169802.4 52668 117134.4 169802.4 52668 117134.4
9/30/09 170762.4 52938 117824.4 170762.4 52938 117824.4 170762.4 52938 117824.4
10/1/09 168127.2 51876 116251.2 168127.2 51876 116251.2 168127.2 51876 116251.2
10/2/09 166987.2 51840 115147.2 166987.2 51840 115147.2 166987.2 51840 115147.2
10/5/09 167314.2 51201 116113.2 167314.2 51201 116113.2 167314.2 51201 116113.2
10/6/09 169021.2 51390 117631.2 169021.2 51390 117631.2 169021.2 51390 117631.2
10/7/09 167508 51588 115920 167508 51588 115920 167508 51588 115920
10/8/09 169123.8 52983 116140.8 169123.8 52983 116140.8 169123.8 52983 116140.8
10/9/09 167719.8 52821 114898.8 167719.8 52821 114898.8 167719.8 52821 114898.8
10/12/09 170454 52740 117714 170454 52740 117714 170454 52740 117714
10/13/09 170685 52695 117990 170685 52695 117990 170685 52695 117990
10/14/09 171123.6 52416 118707.6 171123.6 52416 118707.6 171123.6 52416 118707.6
10/15/09 171240 52560 118680 171240 52560 118680 171240 52560 118680
10/16/09 169956.6 52353 117603.6 169956.6 52353 117603.6 169956.6 52353 117603.6
10/19/09 174675 52407 122268 174675 52407 122268 174675 52407 122268
10/20/09 176056.8 52326 123730.8 176056.8 52326 123730.8 176056.8 52326 123730.8
10/21/09 176670 52056 124614 176670 52056 124614 176670 52056 124614
10/22/09 181809.6 53442 128367.6 181809.6 53442 128367.6 181809.6 53442 128367.6
10/23/09 180324 53226 127098 180324 53226 127098 180324 53226 127098
10/26/09 178419 52425 125994 178419 52425 125994 178419 52425 125994
10/27/09 179904 52254 127650 179904 52254 127650 179904 52254 127650
10/28/09 178599 52191 126408 178599 52191 126408 178599 52191 126408
10/29/09 182805 52947 129858 182805 52947 129858 182805 52947 129858
10/30/09 181702.2 53307 128395.2 181702.2 53307 128395.2 181702.2 53307 128395.2
11/2/09 183318 53460 129858 183318 53460 129858 183318 53460 129858
11/3/09 180388.8 52794 127594.8 180388.8 52794 127594.8 180388.8 52794 127594.8
11/4/09 180771.6 52956 127815.6 180771.6 52956 127815.6 180771.6 52956 127815.6
11/5/09 183795 53523 130272 183795 53523 130272 183795 53523 130272
11/6/09 183325.8 53937 129388.8 183325.8 53937 129388.8 183325.8 53937 129388.8
11/9/09 186493.2 55062 131431.2 186493.2 55062 131431.2 186493.2 55062 131431.2
11/10/09 186963.6 54594 132369.6 186963.6 54594 132369.6 186963.6 54594 132369.6
11/11/09 185902.8 54306 131596.8 185902.8 54306 131596.8 185902.8 54306 131596.8
11/12/09 182631 53739 128892 182631 53739 128892 182631 53739 128892
11/13/09 183403.2 53766 129637.2 183403.2 53766 129637.2 183403.2 53766 129637.2
11/16/09 185163.6 54036 131127.6 185163.6 54036 131127.6 185163.6 54036 131127.6
11/17/09 185427 54189 131238 185427 54189 131238 185427 54189 131238
11/18/09 186558 54630 131928 186558 54630 131928 186558 54630 131928
11/19/09 184275 53865 130410 184275 53865 130410 184275 53865 130410
11/20/09 183708.6 53685 130023.6 183708.6 53685 130023.6 183708.6 53685 130023.6
11/23/09 186013.8 54279 131734.8 186013.8 54279 131734.8 186013.8 54279 131734.8
11/24/09 186472.2 54351 132121.2 186472.2 54351 132121.2 186472.2 54351 132121.2
11/25/09 189322.8 54414 134908.8 189322.8 54414 134908.8 189322.8 54414 134908.8
11/27/09 187463.4 54045 133418.4 187463.4 54045 133418.4 187463.4 54045 133418.4
11/30/09 185122.2 54243 130879.2 185122.2 54243 130879.2 185122.2 54243 130879.2
12/1/09 188572.2 54657 133915.2 188572.2 54657 133915.2 188572.2 54657 133915.2
12/2/09 190549.2 55116 135433.2 190549.2 55116 135433.2 190549.2 55116 135433.2
12/3/09 192023.4 55017 137006.4 192023.4 55017 137006.4 192023.4 55017 137006.4
12/4/09 191245.2 55260 135985.2 191245.2 55260 135985.2 191245.2 55260 135985.2
12/7/09 189798.6 54945 134853.6 189798.6 54945 134853.6 189798.6 54945 134853.6
12/8/09 186270 55170 131100 186270 55170 131100 186270 55170 131100
12/9/09 187380.6 55701 131679.6 187380.6 55701 131679.6 187380.6 55701 131679.6
12/10/09 189688.2 55773 133915.2 189688.2 55773 133915.2 189688.2 55773 133915.2
12/11/09 190126.8 56322 133804.8 190126.8 56322 133804.8 190126.8 56322 133804.8
12/14/09 189950.4 56394 133556.4 189950.4 56394 133556.4 189950.4 56394 133556.4
12/15/09 189217.8 56241 132976.8 189217.8 56241 132976.8 189217.8 56241 132976.8
12/16/09 188274 55656 132618 188274 55656 132618 188274 55656 132618
12/17/09 186374.4 55440 130934.4 186374.4 55440 130934.4 186374.4 55440 130934.4
12/18/09 187740 55260 132480 187740 55260 132480 187740 55260 132480
12/21/09 188560.8 55584 132976.8 188560.8 55584 132976.8 188560.8 55584 132976.8
12/22/09 190131.6 55692 134439.6 190131.6 55692 134439.6 190131.6 55692 134439.6
12/23/09 191181 55665 135516 191181 55665 135516 191181 55665 135516
12/24/09 191520.6 55701 135819.6 191520.6 55701 135819.6 191520.6 55701 135819.6
12/28/09 190645.8 55737 134908.8 190645.8 55737 134908.8 190645.8 55737 134908.8
12/29/09 190978.8 55656 135322.8 190978.8 55656 135322.8 190978.8 55656 135322.8
12/30/09 188674.8 55422 133252.8 188674.8 55422 133252.8 188674.8 55422 133252.8
12/31/09 188932.5 54900 134032.5 188932.5 54900 134032.5 188932.5 54900 134032.5
12/31/08
1/2/09 0 0.015 -0.006 0 0.015 -0.006 0 0.015 -0.006
1/5/09 -0.019 -0.002 -0.027 -0.019 -0.002 -0.027 -0.019 -0.002 -0.027
1/6/09 -0.011 -0.012 -0.01 -0.011 -0.012 -0.01 -0.011 -0.012 -0.01
1/7/09 0.001 -0.016 0.009 0.001 -0.016 0.009 0.001 -0.016 0.009
1/8/09 0.003 -0.003 0.005 0.003 -0.003 0.005 0.003 -0.003 0.005
1/9/09 -0.05 -0.028 -0.06 -0.05 -0.028 -0.06 -0.05 -0.028 -0.06
1/12/09 -0.002 -0.004 -0.001 -0.002 -0.004 -0.001 -0.002 -0.004 -0.001
1/13/09 -0.001 -0.003 0 -0.001 -0.003 0 -0.001 -0.003 0
1/14/09 -0.024 -0.021 -0.025 -0.024 -0.021 -0.025 -0.024 -0.021 -0.025
1/15/09 0.008 -0.009 0.016 0.008 -0.009 0.016 0.008 -0.009 0.016
1/16/09 0.016 0.008 0.019 0.016 0.008 0.019 0.016 0.008 0.019
1/20/09 -0.027 -0.021 -0.03 -0.027 -0.021 -0.03 -0.027 -0.021 -0.03
1/21/09 0.014 0.015 0.013 0.014 0.015 0.013 0.014 0.015 0.013
1/22/09 -0.007 0.01 -0.015 -0.007 0.01 -0.015 -0.007 0.01 -0.015
1/23/09 -0.017 -0.038 -0.007 -0.017 -0.038 -0.007 -0.017 -0.038 -0.007
1/26/09 0.002 -0.021 0.012 0.002 -0.021 0.012 0.002 -0.021 0.012
1/27/09 0.004 0.008 0.002 0.004 0.008 0.002 0.004 0.008 0.002
1/28/09 -0.006 0.019 -0.017 -0.006 0.019 -0.017 -0.006 0.019 -0.017
1/29/09 -0.005 0.012 -0.014 -0.005 0.012 -0.014 -0.005 0.012 -0.014
1/30/09 -0.003 -0.006 -0.002 -0.003 -0.006 -0.002 -0.003 -0.006 -0.002
2/2/09 -0.007 0.006 -0.013 -0.007 0.006 -0.013 -0.007 0.006 -0.013
2/3/09 0.033 0.028 0.036 0.033 0.028 0.036 0.033 0.028 0.036
2/4/09 -0.022 0.017 -0.04 -0.022 0.017 -0.04 -0.022 0.017 -0.04
2/5/09 -0.017 0.008 -0.03 -0.017 0.008 -0.03 -0.017 0.008 -0.03
2/6/09 0.008 0.018 0.002 0.008 0.018 0.002 0.008 0.018 0.002
2/9/09 -0.002 -0.005 0 -0.002 -0.005 0 -0.002 -0.005 0
2/10/09 -0.01 -0.035 0.004 -0.01 -0.035 0.004 -0.01 -0.035 0.004
2/11/09 -0.005 0.009 -0.012 -0.005 0.009 -0.012 -0.005 0.009 -0.012
2/12/09 -0.004 -0.008 -0.002 -0.004 -0.008 -0.002 -0.004 -0.008 -0.002
2/13/09 -0.009 -0.001 -0.014 -0.009 -0.001 -0.014 -0.009 -0.001 -0.014
2/17/09 -0.026 -0.041 -0.019 -0.026 -0.041 -0.019 -0.026 -0.041 -0.019
2/18/09 -0.001 0.002 -0.003 -0.001 0.002 -0.003 -0.001 0.002 -0.003
2/19/09 0.029 0.006 0.041 0.029 0.006 0.041 0.029 0.006 0.041
2/20/09 0.019 -0.011 0.035 0.019 -0.011 0.035 0.019 -0.011 0.035
2/23/09 -0.035 -0.025 -0.04 -0.035 -0.025 -0.04 -0.035 -0.025 -0.04
2/24/09 0.025 0.019 0.028 0.025 0.019 0.028 0.025 0.019 0.028
2/25/09 -0.012 -0.005 -0.016 -0.012 -0.005 -0.016 -0.012 -0.005 -0.016
2/26/09 -0.019 -0.019 -0.019 -0.019 -0.019 -0.019 -0.019 -0.019 -0.019
2/27/09 0.009 0.008 0.01 0.009 0.008 0.01 0.009 0.008 0.01
3/2/09 -0.039 -0.026 -0.045 -0.039 -0.026 -0.045 -0.039 -0.026 -0.045
3/3/09 -0.027 -0.003 -0.038 -0.027 -0.003 -0.038 -0.027 -0.003 -0.038
3/4/09 0.029 0.007 0.04 0.029 0.007 0.04 0.029 0.007 0.04
3/5/09 -0.027 -0.031 -0.026 -0.027 -0.031 -0.026 -0.027 -0.031 -0.026
3/6/09 0.021 0.016 0.023 0.021 0.016 0.023 0.021 0.016 0.023
3/9/09 -0.02 -0.019 -0.021 -0.02 -0.019 -0.021 -0.02 -0.019 -0.021
3/10/09 0.045 0.041 0.046 0.045 0.041 0.046 0.045 0.041 0.046
3/11/09 0.002 0.007 0 0.002 0.007 0 0.002 0.007 0
3/12/09 0.002 0.03 -0.011 0.002 0.03 -0.011 0.002 0.03 -0.011
3/13/09 0.011 0.018 0.007 0.011 0.018 0.007 0.011 0.018 0.007
3/16/09 0.001 0.006 -0.002 0.001 0.006 -0.002 0.001 0.006 -0.002
3/17/09 0.011 0.013 0.01 0.011 0.013 0.01 0.011 0.013 0.01
3/18/09 0.012 0.004 0.016 0.012 0.004 0.016 0.012 0.004 0.016
3/19/09 -0.017 -0.037 -0.007 -0.017 -0.037 -0.007 -0.017 -0.037 -0.007
3/20/09 -0.018 -0.005 -0.024 -0.018 -0.005 -0.024 -0.018 -0.005 -0.024
3/23/09 0.051 0.039 0.057 0.051 0.039 0.057 0.051 0.039 0.057
3/24/09 -0.002 -0.008 0.001 -0.002 -0.008 0.001 -0.002 -0.008 0.001
3/25/09 0.021 0.005 0.029 0.021 0.005 0.029 0.021 0.005 0.029
3/26/09 0.008 0.017 0.004 0.008 0.017 0.004 0.008 0.017 0.004
3/27/09 -0.026 -0.008 -0.035 -0.026 -0.008 -0.035 -0.026 -0.008 -0.035
3/30/09 -0.015 -0.014 -0.015 -0.015 -0.014 -0.015 -0.015 -0.014 -0.015
3/31/09 0.024 0.01 0.031 0.024 0.01 0.031 0.024 0.01 0.031
4/1/09 0.018 0.008 0.023 0.018 0.008 0.023 0.018 0.008 0.023
4/2/09 0.014 0.03 0.006 0.014 0.03 0.006 0.014 0.03 0.006
4/3/09 -0.006 -0.002 -0.009 -0.006 -0.002 -0.009 -0.006 -0.002 -0.009
4/6/09 0.009 0.002 0.013 0.009 0.002 0.013 0.009 0.002 0.013
4/7/09 -0.002 -0.019 0.006 -0.002 -0.019 0.006 -0.002 -0.019 0.006
4/8/09 0.002 0.028 -0.01 0.002 0.028 -0.01 0.002 0.028 -0.01
4/9/09 -0.003 0.004 -0.007 -0.003 0.004 -0.007 -0.003 0.004 -0.007
4/13/09 0.002 -0.017 0.012 0.002 -0.017 0.012 0.002 -0.017 0.012
4/14/09 -0.009 -0.004 -0.011 -0.009 -0.004 -0.011 -0.009 -0.004 -0.011
4/15/09 0.002 0.016 -0.005 0.002 0.016 -0.005 0.002 0.016 -0.005
4/16/09 0.002 0.025 -0.01 0.002 0.025 -0.01 0.002 0.025 -0.01
4/17/09 -0.015 0.013 -0.03 -0.015 0.013 -0.03 -0.015 0.013 -0.03
4/20/09 -0.011 -0.005 -0.014 -0.011 -0.005 -0.014 -0.011 -0.005 -0.014
4/21/09 0.005 0.004 0.006 0.005 0.004 0.006 0.005 0.004 0.006
4/22/09 -0.006 0.003 -0.011 -0.006 0.003 -0.011 -0.006 0.003 -0.011
4/23/09 0.002 -0.005 0.006 0.002 -0.005 0.006 0.002 -0.005 0.006
4/24/09 -0.003 0.006 -0.008 -0.003 0.006 -0.008 -0.003 0.006 -0.008
4/27/09 -0.005 -0.005 -0.005 -0.005 -0.005 -0.005 -0.005 -0.005 -0.005
4/28/09 0 -0.001 0 0 -0.001 0 0 -0.001 0
4/29/09 0.022 0.005 0.031 0.022 0.005 0.031 0.022 0.005 0.031
4/30/09 -0.008 0.002 -0.014 -0.008 0.002 -0.014 -0.008 0.002 -0.014
5/1/09 -0.002 -0.013 0.005 -0.002 -0.013 0.005 -0.002 -0.013 0.005
5/4/09 0.033 -0.02 0.062 0.033 -0.02 0.062 0.033 -0.02 0.062
5/5/09 -0.011 -0.005 -0.014 -0.011 -0.005 -0.014 -0.011 -0.005 -0.014
5/6/09 0.003 -0.011 0.011 0.003 -0.011 0.011 0.003 -0.011 0.011
5/7/09 -0.001 -0.011 0.004 -0.001 -0.011 0.004 -0.001 -0.011 0.004
5/8/09 0.017 -0.006 0.029 0.017 -0.006 0.029 0.017 -0.006 0.029
5/11/09 -0.007 -0.005 -0.008 -0.007 -0.005 -0.008 -0.007 -0.005 -0.008
5/12/09 0.016 -0.003 0.026 0.016 -0.003 0.026 0.016 -0.003 0.026
5/13/09 -0.001 -0.012 0.004 -0.001 -0.012 0.004 -0.001 -0.012 0.004
5/14/09 0.001 -0.019 0.009 0.001 -0.019 0.009 0.001 -0.019 0.009
5/15/09 -0.013 0.013 -0.025 -0.013 0.013 -0.025 -0.013 0.013 -0.025
5/18/09 0.017 0.019 0.017 0.017 0.019 0.017 0.017 0.019 0.017
5/19/09 0 0.006 -0.002 0 0.006 -0.002 0 0.006 -0.002
5/20/09 0.004 0.001 0.006 0.004 0.001 0.006 0.004 0.001 0.006
5/21/09 -0.008 -0.018 -0.003 -0.008 -0.018 -0.003 -0.008 -0.018 -0.003
5/22/09 0.002 -0.007 0.006 0.002 -0.007 0.006 0.002 -0.007 0.006
5/26/09 0.012 0.018 0.009 0.012 0.018 0.009 0.012 0.018 0.009
5/27/09 -0.022 -0.014 -0.026 -0.022 -0.014 -0.026 -0.022 -0.014 -0.026
5/28/09 0.005 0.005 0.004 0.005 0.005 0.004 0.005 0.005 0.004
5/29/09 0.009 0.016 0.006 0.009 0.016 0.006 0.009 0.016 0.006
6/1/09 0.009 0.003 0.013 0.009 0.003 0.013 0.009 0.003 0.013
6/2/09 0.009 0.015 0.006 0.009 0.015 0.006 0.009 0.015 0.006
6/3/09 -0.005 -0.006 -0.005 -0.005 -0.006 -0.005 -0.005 -0.006 -0.005
6/4/09 0.007 -0.004 0.012 0.007 -0.004 0.012 0.007 -0.004 0.012
6/5/09 -0.029 0.002 -0.043 -0.029 0.002 -0.043 -0.029 0.002 -0.043
6/8/09 0.013 0.016 0.012 0.013 0.016 0.012 0.013 0.016 0.012
6/9/09 0.006 -0.002 0.01 0.006 -0.002 0.01 0.006 -0.002 0.01
6/10/09 -0.006 -0.003 -0.008 -0.006 -0.003 -0.008 -0.006 -0.003 -0.008
6/11/09 0.008 0.003 0.011 0.008 0.003 0.011 0.008 0.003 0.011
6/12/09 0.012 0.051 -0.007 0.012 0.051 -0.007 0.012 0.051 -0.007
6/15/09 -0.017 -0.007 -0.022 -0.017 -0.007 -0.022 -0.017 -0.007 -0.022
6/16/09 0 -0.008 0.003 0 -0.008 0.003 0 -0.008 0.003
6/17/09 0.011 0.014 0.01 0.011 0.014 0.01 0.011 0.014 0.01
6/18/09 0.005 0.006 0.004 0.005 0.006 0.004 0.005 0.006 0.004
6/19/09 0.011 -0.011 0.022 0.011 -0.011 0.022 0.011 -0.011 0.022
6/22/09 -0.004 -0.002 -0.006 -0.004 -0.002 -0.006 -0.004 -0.002 -0.006
6/23/09 0.022 -0.012 0.039 0.022 -0.012 0.039 0.022 -0.012 0.039
6/24/09 -0.015 0.003 -0.023 -0.015 0.003 -0.023 -0.015 0.003 -0.023
6/25/09 0.007 0.016 0.003 0.007 0.016 0.003 0.007 0.016 0.003
6/26/09 0.002 -0.007 0.006 0.002 -0.007 0.006 0.002 -0.007 0.006
6/29/09 0.007 0.011 0.006 0.007 0.011 0.006 0.007 0.011 0.006
6/30/09 -0.01 -0.012 -0.009 -0.01 -0.012 -0.009 -0.01 -0.012 -0.009
7/1/09 0.021 0.014 0.025 0.021 0.014 0.025 0.021 0.014 0.025
7/2/09 -0.017 -0.011 -0.019 -0.017 -0.011 -0.019 -0.017 -0.011 -0.019
7/6/09 0.009 0.015 0.007 0.009 0.015 0.007 0.009 0.015 0.007
7/7/09 -0.008 -0.008 -0.008 -0.008 -0.008 -0.008 -0.008 -0.008 -0.008
7/8/09 -0.001 0.001 -0.002 -0.001 0.001 -0.002 -0.001 0.001 -0.002
7/9/09 0.007 -0.001 0.011 0.007 -0.001 0.011 0.007 -0.001 0.011
7/10/09 -0.007 -0.001 -0.01 -0.007 -0.001 -0.01 -0.007 -0.001 -0.01
7/13/09 0.02 0.019 0.02 0.02 0.019 0.02 0.02 0.019 0.02
7/14/09 -0.007 0.001 -0.011 -0.007 0.001 -0.011 -0.007 0.001 -0.011
7/15/09 0.027 0.006 0.038 0.027 0.006 0.038 0.027 0.006 0.038
7/16/09 0.009 0.001 0.012 0.009 0.001 0.012 0.009 0.001 0.012
7/17/09 0.008 0.004 0.01 0.008 0.004 0.01 0.008 0.004 0.01
7/20/09 -0.002 0.009 -0.006 -0.002 0.009 -0.006 -0.002 0.009 -0.006
7/21/09 0.002 0.002 0.001 0.002 0.002 0.001 0.002 0.002 0.001
7/22/09 0.004 0.01 0.001 0.004 0.01 0.001 0.004 0.01 0.001
7/23/09 0 0.008 -0.003 0 0.008 -0.003 0 0.008 -0.003
7/24/09 -0.004 -0.002 -0.005 -0.004 -0.002 -0.005 -0.004 -0.002 -0.005
7/27/09 0.007 -0.002 0.011 0.007 -0.002 0.011 0.007 -0.002 0.011
7/28/09 0.008 0.01 0.007 0.008 0.01 0.007 0.008 0.01 0.007
7/29/09 -0.008 0.003 -0.014 -0.008 0.003 -0.014 -0.008 0.003 -0.014
7/30/09 0.011 0.009 0.013 0.011 0.009 0.013 0.011 0.009 0.013
7/31/09 0.009 0.004 0.012 0.009 0.004 0.012 0.009 0.004 0.012
8/3/09 -0.008 -0.033 0.005 -0.008 -0.033 0.005 -0.008 -0.033 0.005
8/4/09 -0.004 -0.004 -0.004 -0.004 -0.004 -0.004 -0.004 -0.004 -0.004
8/5/09 -0.01 -0.012 -0.009 -0.01 -0.012 -0.009 -0.01 -0.012 -0.009
8/6/09 0 -0.017 0.008 0 -0.017 0.008 0 -0.017 0.008
8/7/09 0.001 0.015 -0.006 0.001 0.015 -0.006 0.001 0.015 -0.006
8/10/09 -0.009 -0.006 -0.01 -0.009 -0.006 -0.01 -0.009 -0.006 -0.01
8/11/09 0.006 0.002 0.009 0.006 0.002 0.009 0.006 0.002 0.009
8/12/09 -0.021 0.006 -0.033 -0.021 0.006 -0.033 -0.021 0.006 -0.033
8/13/09 -0.011 0.001 -0.017 -0.011 0.001 -0.017 -0.011 0.001 -0.017
8/14/09 0.009 -0.006 0.016 0.009 -0.006 0.016 0.009 -0.006 0.016
8/17/09 -0.013 -0.008 -0.015 -0.013 -0.008 -0.015 -0.013 -0.008 -0.015
8/18/09 0.006 0 0.009 0.006 0 0.009 0.006 0 0.009
8/19/09 0.022 0.009 0.029 0.022 0.009 0.029 0.022 0.009 0.029
8/20/09 0.004 0.008 0.002 0.004 0.008 0.002 0.004 0.008 0.002
8/21/09 0.014 0.009 0.016 0.014 0.009 0.016 0.014 0.009 0.016
8/24/09 -0.003 -0.003 -0.002 -0.003 -0.003 -0.002 -0.003 -0.003 -0.002
8/25/09 -0.002 0.008 -0.007 -0.002 0.008 -0.007 -0.002 0.008 -0.007
8/26/09 -0.003 0.005 -0.007 -0.003 0.005 -0.007 -0.003 0.005 -0.007
8/27/09 0.003 -0.003 0.006 0.003 -0.003 0.006 0.003 -0.003 0.006
8/28/09 -0.005 -0.004 -0.005 -0.005 -0.004 -0.005 -0.005 -0.004 -0.005
8/31/09 0.02 0.005 0.028 0.02 0.005 0.028 0.02 0.005 0.028
9/1/09 -0.01 -0.012 -0.008 -0.01 -0.012 -0.008 -0.01 -0.012 -0.008
9/2/09 -0.001 -0.004 0 -0.001 -0.004 0 -0.001 -0.004 0
9/3/09 -0.005 0 -0.007 -0.005 0 -0.007 -0.005 0 -0.007
9/4/09 0.006 0.007 0.005 0.006 0.007 0.005 0.006 0.007 0.005
9/8/09 0.014 0.005 0.018 0.014 0.005 0.018 0.014 0.005 0.018
9/9/09 -0.006 -0.009 -0.005 -0.006 -0.009 -0.005 -0.006 -0.009 -0.005
9/10/09 0.006 0.008 0.005 0.006 0.008 0.005 0.006 0.008 0.005
9/11/09 -0.001 -0.019 0.007 -0.001 -0.019 0.007 -0.001 -0.019 0.007
9/14/09 0.006 0.003 0.008 0.006 0.003 0.008 0.006 0.003 0.008
9/15/09 -0.013 -0.01 -0.014 -0.013 -0.01 -0.014 -0.013 -0.01 -0.014
9/16/09 0.011 0.002 0.016 0.011 0.002 0.016 0.011 0.002 0.016
9/17/09 0.001 -0.005 0.004 0.001 -0.005 0.004 0.001 -0.005 0.004
9/18/09 0.011 0.015 0.01 0.011 0.015 0.01 0.011 0.015 0.01
9/21/09 -0.003 -0.005 -0.002 -0.003 -0.005 -0.002 -0.003 -0.005 -0.002
9/22/09 0.005 0.026 -0.004 0.005 0.026 -0.004 0.005 0.026 -0.004
9/23/09 0 -0.006 0.003 0 -0.006 0.003 0 -0.006 0.003
9/24/09 -0.006 -0.001 -0.009 -0.006 -0.001 -0.009 -0.006 -0.001 -0.009
9/25/09 0.002 -0.002 0.004 0.002 -0.002 0.004 0.002 -0.002 0.004
9/28/09 -0.002 0.005 -0.006 -0.002 0.005 -0.006 -0.002 0.005 -0.006
9/29/09 -0.002 -0.007 0 -0.002 -0.007 0 -0.002 -0.007 0
9/30/09 0.006 0.005 0.006 0.006 0.005 0.006 0.006 0.005 0.006
10/1/09 -0.015 -0.02 -0.013 -0.015 -0.02 -0.013 -0.015 -0.02 -0.013
10/2/09 -0.007 -0.001 -0.009 -0.007 -0.001 -0.009 -0.007 -0.001 -0.009
10/5/09 0.002 -0.012 0.008 0.002 -0.012 0.008 0.002 -0.012 0.008
10/6/09 0.01 0.004 0.013 0.01 0.004 0.013 0.01 0.004 0.013
10/7/09 -0.009 0.004 -0.015 -0.009 0.004 -0.015 -0.009 0.004 -0.015
10/8/09 0.01 0.027 0.002 0.01 0.027 0.002 0.01 0.027 0.002
10/9/09 -0.008 -0.003 -0.011 -0.008 -0.003 -0.011 -0.008 -0.003 -0.011
10/12/09 0.016 -0.002 0.025 0.016 -0.002 0.025 0.016 -0.002 0.025
10/13/09 0.001 -0.001 0.002 0.001 -0.001 0.002 0.001 -0.001 0.002
10/14/09 0.003 -0.005 0.006 0.003 -0.005 0.006 0.003 -0.005 0.006
10/15/09 0.001 0.003 0 0.001 0.003 0 0.001 0.003 0
10/16/09 -0.007 -0.004 -0.009 -0.007 -0.004 -0.009 -0.007 -0.004 -0.009
10/19/09 0.028 0.001 0.04 0.028 0.001 0.04 0.028 0.001 0.04
10/20/09 0.008 -0.002 0.012 0.008 -0.002 0.012 0.008 -0.002 0.012
10/21/09 0.003 -0.005 0.007 0.003 -0.005 0.007 0.003 -0.005 0.007
10/22/09 0.029 0.027 0.03 0.029 0.027 0.03 0.029 0.027 0.03
10/23/09 -0.008 -0.004 -0.01 -0.008 -0.004 -0.01 -0.008 -0.004 -0.01
10/26/09 -0.011 -0.015 -0.009 -0.011 -0.015 -0.009 -0.011 -0.015 -0.009
10/27/09 0.008 -0.003 0.013 0.008 -0.003 0.013 0.008 -0.003 0.013
10/28/09 -0.007 -0.001 -0.01 -0.007 -0.001 -0.01 -0.007 -0.001 -0.01
10/29/09 0.024 0.014 0.027 0.024 0.014 0.027 0.024 0.014 0.027
10/30/09 -0.006 0.007 -0.011 -0.006 0.007 -0.011 -0.006 0.007 -0.011
11/2/09 0.009 0.003 0.011 0.009 0.003 0.011 0.009 0.003 0.011
11/3/09 -0.016 -0.012 -0.017 -0.016 -0.012 -0.017 -0.016 -0.012 -0.017
11/4/09 0.002 0.003 0.002 0.002 0.003 0.002 0.002 0.003 0.002
11/5/09 0.017 0.011 0.019 0.017 0.011 0.019 0.017 0.011 0.019
11/6/09 -0.003 0.008 -0.007 -0.003 0.008 -0.007 -0.003 0.008 -0.007
11/9/09 0.017 0.021 0.016 0.017 0.021 0.016 0.017 0.021 0.016
11/10/09 0.003 -0.008 0.007 0.003 -0.008 0.007 0.003 -0.008 0.007
11/11/09 -0.006 -0.005 -0.006 -0.006 -0.005 -0.006 -0.006 -0.005 -0.006
11/12/09 -0.018 -0.01 -0.021 -0.018 -0.01 -0.021 -0.018 -0.01 -0.021
11/13/09 0.004 0.001 0.006 0.004 0.001 0.006 0.004 0.001 0.006
11/16/09 0.01 0.005 0.011 0.01 0.005 0.011 0.01 0.005 0.011
11/17/09 0.001 0.003 0.001 0.001 0.003 0.001 0.001 0.003 0.001
11/18/09 0.006 0.008 0.005 0.006 0.008 0.005 0.006 0.008 0.005
11/19/09 -0.012 -0.014 -0.012 -0.012 -0.014 -0.012 -0.012 -0.014 -0.012
11/20/09 -0.003 -0.003 -0.003 -0.003 -0.003 -0.003 -0.003 -0.003 -0.003
11/23/09 0.013 0.011 0.013 0.013 0.011 0.013 0.013 0.011 0.013
11/24/09 0.002 0.001 0.003 0.002 0.001 0.003 0.002 0.001 0.003
11/25/09 0.015 0.001 0.021 0.015 0.001 0.021 0.015 0.001 0.021
11/27/09 -0.01 -0.007 -0.011 -0.01 -0.007 -0.011 -0.01 -0.007 -0.011
11/30/09 -0.012 0.004 -0.019 -0.012 0.004 -0.019 -0.012 0.004 -0.019
12/1/09 0.019 0.008 0.023 0.019 0.008 0.023 0.019 0.008 0.023
12/2/09 0.01 0.008 0.011 0.01 0.008 0.011 0.01 0.008 0.011
12/3/09 0.008 -0.002 0.012 0.008 -0.002 0.012 0.008 -0.002 0.012
12/4/09 -0.004 0.004 -0.007 -0.004 0.004 -0.007 -0.004 0.004 -0.007
12/7/09 -0.008 -0.006 -0.008 -0.008 -0.006 -0.008 -0.008 -0.006 -0.008
12/8/09 -0.019 0.004 -0.028 -0.019 0.004 -0.028 -0.019 0.004 -0.028
12/9/09 0.006 0.01 0.004 0.006 0.01 0.004 0.006 0.01 0.004
12/10/09 0.012 0.001 0.017 0.012 0.001 0.017 0.012 0.001 0.017
12/11/09 0.002 0.01 -0.001 0.002 0.01 -0.001 0.002 0.01 -0.001
12/14/09 -0.001 0.001 -0.002 -0.001 0.001 -0.002 -0.001 0.001 -0.002
12/15/09 -0.004 -0.003 -0.004 -0.004 -0.003 -0.004 -0.004 -0.003 -0.004
12/16/09 -0.005 -0.01 -0.003 -0.005 -0.01 -0.003 -0.005 -0.01 -0.003
12/17/09 -0.01 -0.004 -0.013 -0.01 -0.004 -0.013 -0.01 -0.004 -0.013
12/18/09 0.007 -0.003 0.012 0.007 -0.003 0.012 0.007 -0.003 0.012
12/21/09 0.004 0.006 0.004 0.004 0.006 0.004 0.004 0.006 0.004
12/22/09 0.008 0.002 0.011 0.008 0.002 0.011 0.008 0.002 0.011
12/23/09 0.006 0 0.008 0.006 0 0.008 0.006 0 0.008
12/24/09 0.002 0.001 0.002 0.002 0.001 0.002 0.002 0.001 0.002
12/28/09 -0.005 0.001 -0.007 -0.005 0.001 -0.007 -0.005 0.001 -0.007
12/29/09 0.002 -0.001 0.003 0.002 -0.001 0.003 0.002 -0.001 0.003
12/30/09 -0.012 -0.004 -0.015 -0.012 -0.004 -0.015 -0.012 -0.004 -0.015
12/31/09 0.001 -0.009 0.006 0.001 -0.009 0.006 0.001 -0.009 0.006

VALUATION

Valuation worksheet
1) Expected stock price (Gordon's Model)
input output
growth (g) 0.06
last div (DO) 2.00
req rate (k) 0.15
price (pps)
2) Value of a Bond (Vb)
input output
coupon 0.0875
mat_yrs 5
mktrates 0.0975
PV of PMTS
PV of FV
Value
3) Continuous Compounding
input output
PV 10000
rate 0.0345
time 2.5
FV
4) Loan calculator
input output
PVa 22695
No of years 5
Annual rate 5.50%
PMTS
Amortization Table
period Begin'g interest$ PMTS Red'n Ending
Balance @ 5.5% Balance Balance
1 22695
2
3

BSOPM

Black-Scholes Option Pricing Model
input
current stock price S= 35.75
riskless rate r= 0.025
strike price K= 36
No of yrs T= 0.25
stddev of returns σ= 0.3
output
ln (S/K)=
(r+σ^2/2)T
σ*T^1/2
d1=
d2=
N(d1)=
N(d2)=
discounted strike price
C=SN(d1)-dspN(d2)

CURRENCY

Currency worksheet
Crossrate table
US$ ¥ £ C$ Ps
US$ 1.00000
0.67020
¥ 89.67000
£ 0.59900
C$ 1.05000
Ps 13.03950
First column is "per US$" The Wall Street Journal 14 Nov 2009
First row is "no. of US$ per unit of foreign currency"
Forward rates (as shown in The Wall Street Journal)
Premium/discount
British pound 1.6747
1-mos forward 1.6743
3-mos forward 1.6736
6-mos forward 1.6729