Help - Investment Spreadsheet - Compounding Daily Interest

[Justinian]

I am trying to make an investment spreadsheet. Here is what I need:
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I want to start with $10,000 and compound it daily at 1.5%. At month #3, I want to subtract the original $10,000 from the total and then continue month #4.
<o> </o>
As this account grows, I would like to take withdrawals: 5%,10%,15%, or maybe even 20% sometime during the month. I would like to know how these withdrawals would affect my current and future earnings if I did take them because I don't want to kill my investment. So if at month #3, I have $12,000, I want to withdraw $500 and then have Excel compute what my remainder is and then have that new total continue to compound. This would happen whenever I make a withdrawal.
<o> </o>
Any ideas how I can set-up this spreadsheet?

 

[Jeff Meyers]

Here's an example of how you could set-up this spreadsheet.

Note that all additions / contributions and reductions / withdrawls occur at the beginning of the day in this example (which affects that day's interest / investment earnings).

Copy the dates down in Column A and the formulas down in Columns B, F, & G. The daily interest rate is specificed in each row to allow you to adjust / change it.

Excel Workbook
	A	B	C	D	E	F	G
1		Opening	[ + ]	[ - ]	Interest		Closing
2	Date	Balance	Additions	Withdrawls	Rate	Interest	Balance
3	06/01/12	-	10,000.00	-	1.5%	150.00	10,150.00
4	06/02/12	10,150.00	-	-	1.5%	152.25	10,302.25
5	06/03/12	10,302.25	-	-	1.5%	154.53	10,456.78
6	06/04/12	10,456.78	-	-	1.5%	156.85	10,613.64
7	06/05/12	10,613.64	-	-	1.5%	159.20	10,772.84
8	06/06/12	10,772.84	-	-	1.5%	161.59	10,934.43
9	06/07/12	10,934.43	-	-	1.5%	164.02	11,098.45
10	06/08/12	11,098.45	-	-	1.5%	166.48	11,264.93
11	06/09/12	11,264.93	-	-	1.5%	168.97	11,433.90
12	06/10/12	11,433.90	-	(5,000.00)	1.5%	96.51	6,530.41
13	06/11/12	6,530.41	-	-	1.5%	97.96	6,628.36
14	06/12/12	6,628.36	-	-	1.5%	99.43	6,727.79
15	06/13/12	6,727.79	-	-	1.5%	100.92	6,828.71
16	06/14/12	6,828.71	2,000.00	-	1.5%	132.43	8,961.14
17	06/15/12	8,961.14	-	-	1.5%	134.42	9,095.55
18	06/16/12	9,095.55	-	-	1.5%	136.43	9,231.99
19	06/17/12	9,231.99	-	(500.00)	1.5%	130.98	8,862.97
20	06/18/12	8,862.97	-	-	1.5%	132.94	8,995.91
21	06/19/12	8,995.91	-	-	1.5%	134.94	9,130.85
22	06/20/12	9,130.85	-	-	1.5%	136.96	9,267.81
23
24
25	--------------	--------------	--------------	--------------	--------------	--------------	--------------
26
Sheet2

Excel 2010

Cell Formulas
Range	Formula
F3	=SUM(B3:D3)*E3
F4	=SUM(B4:D4)*E4
F5	=SUM(B5:D5)*E5
F6	=SUM(B6:D6)*E6
F7	=SUM(B7:D7)*E7
F8	=SUM(B8:D8)*E8
F9	=SUM(B9:D9)*E9
F10	=SUM(B10:D10)*E10
F11	=SUM(B11:D11)*E11
F12	=SUM(B12:D12)*E12
F13	=SUM(B13:D13)*E13
F14	=SUM(B14:D14)*E14
F15	=SUM(B15:D15)*E15
F16	=SUM(B16:D16)*E16
F17	=SUM(B17:D17)*E17
F18	=SUM(B18:D18)*E18
F19	=SUM(B19:D19)*E19
F20	=SUM(B20:D20)*E20
F21	=SUM(B21:D21)*E21
F22	=SUM(B22:D22)*E22
G3	=SUM(B3:D3)+F3
G4	=SUM(B4:D4)+F4
G5	=SUM(B5:D5)+F5
G6	=SUM(B6:D6)+F6
G7	=SUM(B7:D7)+F7
G8	=SUM(B8:D8)+F8
G9	=SUM(B9:D9)+F9
G10	=SUM(B10:D10)+F10
G11	=SUM(B11:D11)+F11
G12	=SUM(B12:D12)+F12
G13	=SUM(B13:D13)+F13
G14	=SUM(B14:D14)+F14
G15	=SUM(B15:D15)+F15
G16	=SUM(B16:D16)+F16
G17	=SUM(B17:D17)+F17
G18	=SUM(B18:D18)+F18
G19	=SUM(B19:D19)+F19
G20	=SUM(B20:D20)+F20
G21	=SUM(B21:D21)+F21
G22	=SUM(B22:D22)+F22
B4	=+G3
B5	=+G4
B6	=+G5
B7	=+G6
B8	=+G7
B9	=+G8
B10	=+G9
B11	=+G10
B12	=+G11
B13	=+G12
B14	=+G13
B15	=+G14
B16	=+G15
B17	=+G16
B18	=+G17
B19	=+G18
B20	=+G19
B21	=+G20
B22	=+G21

 

[Justinian]

I am confused. Is this interest compounded daily? Some of my results are not matching yours. F12 for me says $99.08 but yours says $96.51.

 

[Jeff Meyers]

Yes, the interest is compounding daily. For instance, on day 1 the interest is $150.00 ($10,000.00 * 1.5%), on day 2 the interest is $152.25 (($10,000.00 + $150.00) * 1.5%), and so on.

Not sure why there is a discrepancy. Can you post your data?

 

[Justinian]

<TABLE style="WIDTH: 465pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=617><COLGROUP><COL style="WIDTH: 57pt; mso-width-source: userset; mso-width-alt: 2779" width=76><COL style="WIDTH: 68pt; mso-width-source: userset; mso-width-alt: 3291" width=90><COL style="WIDTH: 70pt; mso-width-source: userset; mso-width-alt: 3401" width=93><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3437" width=94><COL style="WIDTH: 63pt; mso-width-source: userset; mso-width-alt: 3072" width=84><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3145" width=86><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3437" width=94><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; WIDTH: 57pt; HEIGHT: 15pt; BORDER-TOP: #b2b2b2 0.5pt solid; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl64 height=20 width=76>06/01/12</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; WIDTH: 68pt; BORDER-TOP: #b2b2b2 0.5pt solid; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65 width=90> $ - </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; WIDTH: 70pt; FONT-FAMILY: Calibri; BACKGROUND: #ffffcc; COLOR: green; FONT-SIZE: 11pt; BORDER-TOP: #b2b2b2 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #b2b2b2 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl65 width=93> $ 10,000.00 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; WIDTH: 71pt; BORDER-TOP: #b2b2b2 0.5pt solid; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65 width=94> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; WIDTH: 63pt; BORDER-TOP: #b2b2b2 0.5pt solid; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl66 width=84>1.50%</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; WIDTH: 65pt; BORDER-TOP: #b2b2b2 0.5pt solid; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl67 width=86> $ 150.00 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; WIDTH: 71pt; BORDER-TOP: #b2b2b2 0.5pt solid; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65 width=94> $ 10,150.00 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl64 height=20>06/02/12</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 10,150.00 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl66>1.50%</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl67> $ 152.25 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 10,302.25 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl64 height=20>06/03/12</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 10,302.25 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl66>1.50%</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl67> $ 154.53 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 10,456.78 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl64 height=20>06/04/12</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 10,456.78 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl66>1.50%</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl67> $ 156.85 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 10,613.64 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl64 height=20>06/05/12</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 10,613.64 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl66>1.50%</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl67> $ 159.20 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 10,772.84 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl64 height=20>06/06/12</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 10,772.84 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl66>1.50%</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl67> $ 161.59 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 10,934.43 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl64 height=20>06/07/12</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 10,934.43 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl66>1.50%</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl67> $ 164.02 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 11,098.45 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl64 height=20>06/08/12</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 11,098.45 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl66>1.50%</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl67> $ 166.48 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 11,264.93 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl64 height=20>06/09/12</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 11,264.93 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl66>1.50%</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl67> $ 168.97 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 11,433.90 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl64 height=20>06/10/12</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 11,433.90 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl66>1.50%</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl67> $ 171.51 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 11,605.41 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl64 height=20>06/11/12</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 11,605.41 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; FONT-STYLE: italic; FONT-FAMILY: Calibri; BACKGROUND: #ffffcc; COLOR: red; FONT-SIZE: 11pt; BORDER-TOP: #b2b2b2 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #b2b2b2 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl65> $ (5,000.00)</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl66>1.50%</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl67> $ 99.08 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 6,704.49 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl64 height=20>06/12/12</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 6,704.49 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl66>1.50%</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl67> $ 100.57 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 6,805.06 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl64 height=20>06/13/12</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 6,805.06 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl66>1.50%</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl67> $ 102.08 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 6,907.13 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl64 height=20>06/14/12</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 6,907.13 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl66>1.50%</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl67> $ 103.61 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 7,010.74 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl64 height=20>06/15/12</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 7,010.74 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND: #ffffcc; COLOR: green; FONT-SIZE: 11pt; BORDER-TOP: #b2b2b2 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #b2b2b2 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl65> $ 2,000.00 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl66>1.50%</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl67> $ 135.16 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 9,145.90 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl64 height=20>06/16/12</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 9,145.90 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl66>1.50%</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl67> $ 137.19 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 9,283.09 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl64 height=20>06/17/12</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 9,283.09 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl66>1.50%</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl67> $ 139.25 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 9,422.34 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl64 height=20>06/18/12</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 9,422.34 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; FONT-STYLE: italic; FONT-FAMILY: Calibri; BACKGROUND: #ffffcc; COLOR: red; FONT-SIZE: 11pt; BORDER-TOP: #b2b2b2 0.5pt solid; FONT-WEIGHT: 700; BORDER-RIGHT: #b2b2b2 0.5pt solid; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" class=xl65> $ (500.00)</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl66>1.50%</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl67> $ 133.84 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 9,056.17 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl64 height=20>06/19/12</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 9,056.17 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl66>1.50%</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl67> $ 135.84 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 9,192.01 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl64 height=20>06/20/12</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 9,192.01 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl66>1.50%</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl67> $ 137.88 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 9,329.89 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl64 height=20>06/21/12</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 9,329.89 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl66>1.50%</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl67> $ 139.95 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 9,469.84 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl64 height=20>06/22/12</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 9,469.84 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl66>1.50%</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl67> $ 142.05 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 9,611.89 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl64 height=20>06/23/12</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 9,611.89 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl66>1.50%</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl67> $ 144.18 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 9,756.07 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl64 height=20>06/24/12</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 9,756.07 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl66>1.50%</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl67> $ 146.34 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 9,902.41 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl64 height=20>06/25/12</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 9,902.41 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl66>1.50%</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl67> $ 148.54 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 10,050.94 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl64 height=20>06/26/12</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 10,050.94 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl66>1.50%</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl67> $ 150.76 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 10,201.71 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl64 height=20>06/27/12</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 10,201.71 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl66>1.50%</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl67> $ 153.03 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 10,354.73 </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2 0.5pt solid; BACKGROUND-COLOR: #ffffcc; HEIGHT: 15pt; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl64 height=20>06/28/12</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 10,354.73 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl66>1.50%</TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl67> $ 155.32 </TD><TD style="BORDER-BOTTOM: #b2b2b2 0.5pt solid; BORDER-LEFT: #b2b2b2; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: #b2b2b2; BORDER-RIGHT: #b2b2b2 0.5pt solid" class=xl65> $ 10,510.06 </TD></TR></TBODY></TABLE>

 

[Jeff Meyers]

The discrepancies are a result of our worksheets not being the same - the timing of withdrawls and additions are different:

Mine reflects a 5,000 withdrawl on 06/10 and you have it recorded on 06/11
Mine reflects a 2,000 addition on 06/14 and you have it recorded on 06/15
Mine reflects a 500 withdrawl on 06/17 and you have it recorded on 06/18

Change these transactions to the same dates and our worksheets will match.

 

[Justinian]

Ok, I see it now. Thank you!

 

[Jeff Meyers]

You are welcome. Happy to help. Thanks for the feedback.