Subject: FW: Investment List.xls
|
WASECA COUNTY INVESTMENT PORTFOLIO AS OF JUNE 30, 2010 |
||||||||||||||
|
PRCHSD |
BANK |
CERT # |
RATE |
TERM |
GEN REV |
R&B |
W MGT |
EC DEV |
DITCH |
MATURE |
INT EARN |
REC # |
AMT |
R/C |
|
11/6/2001 |
6 Bonds |
4 |
Liquid |
11,560.96 |
8/1/21 |
Note 1 Below |
||||||||
|
10/11/2005 |
NRSB |
50173 |
3.2 |
30 mo |
88,000 |
10/11/2010 |
2,552.00 |
48149 |
||||||
|
11/17/2008 |
Wachovia |
84603MB70 |
4 |
18 mos |
5/26/2010 |
1,884.38 |
48824 |
95,000 |
Called |
|||||
|
11/26/2008 |
Wachovia |
381426UN3 |
4.25 |
2 years |
96,000 |
11/26/2010 |
2,023.23 |
48824 |
||||||
|
1/16/2009 |
Wachovia |
36185AH92 |
2.3 |
18 mos |
95,000 |
7/16/10 |
1,101.48 |
47252 |
||||||
|
2/12/2009 |
First Natl |
61429 |
2 |
1 year |
2/12/10 |
10,000.00 |
47523 |
500,000 |
Cashed |
|||||
|
3/20/2008 |
First Natl |
62361 |
1.85 |
1 year |
500,000 |
3/20/11 |
9,250.00 |
47911 |
Renewed |
|||||
|
4/22/2009 |
Wachovia |
02580VMB8 |
2.25 |
2 years |
87,000 |
4/25/2011 |
976.07 |
48354 |
||||||
|
4/22/2009 |
Wachovia |
25469JU31 |
2.25 |
2 years |
88,000 |
4/25/2011 |
987.29 |
48354 |
||||||
|
5/28/2008 |
JSB |
12447 |
2.01 |
1 year |
100,000 |
5/28/2010 |
2,010.00 |
48715 |
||||||
|
5/27/2009 |
Wachovia |
795450LU7 |
2.65 |
2 years |
6/3/2011 |
653.43 |
47125/47762 |
100,000 |
Called |
|||||
|
6/30/2009 |
First Natl |
62517 |
1.45 |
1 year |
6/30/2010 |
7,250.00 |
49196 |
500,000 |
Renewed |
|||||
|
7/17/2009 |
First Natl |
62562 |
1.61 |
1 year |
625,000 |
7/17/2010 |
10,062.50 |
49397 |
||||||
|
7/17/2009 |
First Natl |
62563 |
1.61 |
1 year |
300,000 |
7/17/2010 |
4,830.00 |
49398 |
||||||
|
7/28/2009 |
First Natl |
62888 |
1.15 |
6 mo |
1/28/2010 |
1,014.52 |
47315 |
175,000 |
||||||
|
8/10/2009 |
Roundbk |
69778 |
1.65 |
1 year |
150,000 |
8/10/2010 |
||||||||
|
8/11/2009 |
Roundbk |
69784 |
1.65 |
1 year |
500,000 |
8/11/2010 |
||||||||
|
8/17/2009 |
First Natl |
61440 |
0.95 |
6 mo |
75,000 |
8/17/2010 |
434.79 |
47596 |
||||||
|
8/21/2009 |
Roundbk |
69834 |
1.41 |
6 mo |
2/21/2010 |
718.52 |
47570/47591 |
100,000 |
Cashed |
|||||
|
8/21/2009 |
Roundbk |
69833 |
1.68 |
1 year |
400,000 |
8/21/2010 |
||||||||
|
8/21/2009 |
Roundbk |
69832 |
1.68 |
1 year |
500,000 |
8/21/2010 |
||||||||
|
8/23/2009 |
United Pr |
50110003512 |
1.73 |
1 year |
250,000 |
8/23/2010 |
||||||||
|
8/21/2009 |
JSB |
12977 |
1.75 |
2 years |
100,000 |
8/21/2011 |
||||||||
|
10/15/2009 |
WF Adv |
3133XUYV9 |
2 |
5 years |
10/15/2014 |
1,000.00 |
47252 |
200,000 |
Called |
|||||
|
11/16/2009 |
Roundbk |
70102 |
1.45 |
1 year |
1,000,000 |
11/16/2010 |
||||||||
|
12/16/2009 |
WF Adv |
3136FJUW9 |
2 |
7 years |
200,000 |
12/16/2016 |
2,000.00 |
49048 |
||||||
|
12/28/2009 |
WF Adv |
3136FJZE4 |
3 |
7 years |
12/28/2016 |
1,500.00 |
49250 |
100,000 |
Called |
|||||
|
12/29/2009 |
Roundbk |
70182 |
1.35 |
1 year |
1,000,000 |
12/29/2010 |
||||||||
|
1/26/2010 |
WF Adv |
3133XWNE5 |
2 |
7 years |
1/26/2017 |
1,000.00 |
48397 |
200,000 |
Called |
|||||
|
2/12/2010 |
Roundbk |
70293 |
1.3 |
1 year |
500,000 |
2/12/2011 |
||||||||
|
3/2/2010 |
WF Adv |
3136FMDC5 |
2 |
5 years |
100,000 |
3/24/2015 |
||||||||
|
4/21/2010 |
WF Adv |
3136FMPN8 |
2.53 |
7 years |
250,000 |
5/4/2017 |
||||||||
|
5/18/2010 |
WF Adv |
3136FMUC6 |
2.25 |
7 years |
100,000 |
5/26/2017 |
||||||||
|
6/30/2010 |
Roundbk |
70720 |
0.8 |
1 year |
500,000 |
6/30/2011 |
||||||||
|
6/30/2010 |
WF Adv |
3136FML69 |
2 |
5 1/2 yrs |
250,000 |
12/30/2015 |
||||||||
|
TOTAL CURRENT INVESTED/FUND |
|
6,940,560.96 |
0 |
850,000 |
75,000.00 |
0 |
7,865,560.96 |
61,248.21 |
|
|
|
|||
|
TOTAL INT |
||||||||||||||
|
INTEREST COLLECTED TO DATE/FUND |
54,250.38 |
5,548.52 |
434.79 |
1,014.52 |
= |
61,248.21 |
||||||||
|
INVESTMENTS HELD PER BANK |
||||||||||||||
|
ROUNDBK |
FIRST NATL |
WELLSF |
UNITED PR |
JSB |
NRSB |
WellsF Adv |
BONDS |
TOTAL INVEST |
||||||
|
4,550,000 |
1,500,000 |
250,000 |
200,000 |
88,000 |
1,266,000.00 |
+11,560.96 = |
7,865,560.96 |
|||||||
|
Respectfully prepared and sumbitted
by Joyce Oliver, Waseca County Treasurer |
||||||||||||||
|
Note #1 The 6 savings bonds are being held in the
Treasurer's Office safe. Waseca County has ownership of these bonds due to a
release of funds in a missing heir estate. |
||||||||||||||