|
<br /> City of Centerville
<br /> Schedule of Cash and Investments
<br /> Month Ended November 30, 2004
<br /> Account Number Face or Interest Acquisition Call Due YTD
<br /> Account Value Rate Date Date Date Interest
<br />Mainstreet Bank
<br />Checking 3017115 $688,737.50 0.10% 979.86
<br />Flexible CD Savings 1321332 $1,047,648.43 2.00% 06/26/03 $24,065.73
<br />Certificate of Deposit 300195 $109,375.79 4.50% 10/10/02 10/10/07 $4,799.29
<br />Certificate of Deposit 300196 $0.00 3.70% 10/10/02 10/10/04 $7,850.08
<br />Certificate of Deposit 300197 $216,594.83 4.00% 10/10/02 10/10/05 $8,474.03
<br />Certificate of Deposit 300198 $0.00 2.45% 10/10/02 04/10/04 $1,387.96
<br />Certificate of Deposit 300209 $158,097.37 4.10% 10/24/02 10/24/05 $6,336.11
<br />Certificate of Deposit 300259 $158,759.57 3.25% 12/05/02 06/05/05 $3,824.84
<br />Certificate of Deposit 300265 $211,679.42 3.25% 12/13/02 06/13/05 $5,099.77
<br />Certificate of Deposit 300266 $160,145.35 3.75% 12/13/02 12/13/07 $4,440.75
<br />Certificate of Deposit 300267 $0.00 2.30% 12/13/02 06/13/04 $1,194.09
<br />Certificate of Deposit 300272 $104,648.95 2.60% 12/17/02 12/17/04 $2,023.49
<br />Certificate of Deposit 300273 $105,839.70 3.25% 12/17/02 06/17/05 $2,549.88
<br />Certificate of Deposit 300348 $209,039.95 2.95% 04/16/03 10/16/05 $6,070.93
<br />Certificate of Deposit 300375 $0.00 2.01% 06/03/03 03/03/04 $503.64
<br />Certificate of Deposit 300377 $0.00 2.01% 06/09/03 03/09/04 $1,150.49
<br />Certificate of Deposit 300382 $0.00 2.01% 06/10/03 03/10/04 $755.46
<br />Certificate of Deposit 300449 $0.00 2.50% 08/01/03 11/01/04 $4,764.90
<br />Certificate of Deposit 300561 $102,852.03 3.80% 12/04/03 12/04/08 $2,852.03
<br />Certificate of Deposit 300562 $101,895.41 2.52% 12/04/03 12/04/06 $1,895.41
<br />Certificate of Deposit 300563 $0.00 2.10% 12/04/03 11/04/04 $3,866.30
<br />Certificate of Deposit 300564 $0.00 2.10% 12/04/03 11/04/04 $3,866.30
<br />Certificate of Deposit 300565 $0.00 2.10% 12/04/03 11/04/04 $1,933.15
<br />Certificate of Deposit 300566 $254,738.53 2.50% 12/12/03 12/12/06 $4,738.53
<br />Certificate of Deposit 300567 $0.00 2.10% 12/12/03 11/12/04 $1,933.15
<br />Certificate of Deposit 300573 $0.00 2.10% 12/16/03 11/16/04 $1,933.15
<br />Certificate of Deposit 300583 $101,666.70 2.20% 12/18/03 12/18/05 $1,666.70
<br />Certificate of Deposit 300584 $101,895.41 2.50% 12/18/03 12/18/06 $1,895.41
<br />Certificate of Deposit 300587 $101,666.70 2.20% 12/19/03 12/19/05 $1,666.70
<br />Certificate of Deposit 300680 $101,228.73 2.45% 03/09/04 09/09/05 $1,228.73
<br />Certificate of Deposit 300704 $153,001.71 4.00% 03/23/04 03/23/09 $3.001.71
<br />Certificate of Deposit 300705 $151,934.42 2.55% 03/23/04 03/23/06 $1,934.42
<br />Certificate of Deposit 300733 $114,099.46 2.28% 04/12/04 07/12/05 $1,293.20
<br />Certificate of Deposit 300769 $201,391.18 2.73% 05/18/04 11/18/06 $1,391.18
<br />Certificate of Deposit 300876 $215,353.39 3.25% 10/12/2004 04/12/07 $0.00
<br />Certificate of Deposit 300923 $300,000.00 3.84% 11/4/2004 05/04/07 $0.00
<br />Certificate of Deposit 300970 $101,933.15 3.72% 11/17/2004 05/17/07 $0.00
<br />Certificate of Deposit 300971 $101,933.15 3.72% 11/17/2004 05/17/07 $0.00
<br /> $5,376,156.83 $123,367.37
<br />U.S. Bank
<br />Certificate of Deposit 3006093151 $0.00 2.47% 07/12/74 07/12/04 $45.76
<br />Certificate of Deposit 4670 $0.00 2.47% 12/30/76 06/30/04 $55.16
<br /> $0.00 $100.92
<br />MBIA
<br />4M Fund MN-01-0034-0001 $5,105.30 0.64% $42.09
<br /> $5,105.30 $42.09
<br />Smith Barnev
<br />Money Funds Smith Barnev $30,034.76 0.59% $1,475.42
<br />Certificate of Deposit Capital One $100,000.00 4.90% 11/13/01 11/22/06 $4,510.66
<br />Certificate of Deposit Direct Merchants $100,000.00 5.85% 06/07/01 06/14/06 $5,385.20
<br />Certificate of De DDS it (step 6 First Bank PR $0.00 4.00% 06/05/02 06/26/04 06/26/09 $1,925.26
<br />Certificate of Deposit (discOL CIB Bank IL $89,100.00 4.00% 03/28/03 03/28/04 03/28/11 $3,609.86
<br />Certificate of Deposit Lehmann Bros. $96,000.00 4.60% 12/30/03 06/30/04 12/30/10 $3,690.10
<br />Certificate of Deposit Compass Bank $96,000.00 5.125% 06/29/04 06/29/05 06/29/11 $0.00
<br />Certificate of Deposit Hemisphere Bank $96,000.00 3.600% 06/25/04 06/25/07 $0.00
<br />FHLMC (step rate) 3133FO-WT-2 $0.00 3.00% 10/18/02 10/15/03 10/15/09 $2,496.17
<br />FHLMCM 312925-BR-0 $0.00 5.25% 06/05/02 03/18/04 03/18/09 $6,693.75
<br />FNMA 3136F2-WY-0 $0.00 4.50% 12/13/02 12/11/03 06/11/10 $1,837.50
<br />FNMA 3136F2-X7-8 $205,000.00 4.00% 02/07/03 02/06/04 08/06/10 $8,200.00
<br />FHLMC (discounted) 3128X1-MZ-7 $99,750.00 3.00% 06/30/03 12/30/03 06/30/09 $1,500.00
<br />FHLBC 31339X-RD-8 $100,000.00 3.25% 06/30/03 09/30/03 12/30/08 $0.00
<br />FHLMC 3133FO-2C-2 $150,000.00 4.00% 08/14/03 08/15/04 02/15/09 $5,500.00
<br />FNMA 31363F3-2K-1 $0.00 4.00% 09/10/03 11/13/03 2/13/09 $5,099.44
<br />FHLMC 3128X1-7F-8 $100,000.00 3.50% 11/28/03 12/06/04 12/06/11 $1,827.78
<br />FNMA 3136F4-G8-1 $0.00 4.00% 12/30/03 03/03/04 12/30/08 $4,125.00
<br />FHLMC (step rate) 3128X2-ZU-2 $99,937.50 4.00% 03/17/04 03/17/05 09/17/12 $2,000.00
<br />FHLMC (step rate) 3128X2-S7-1 $150,000.00 3.50% 03/24/04 03/24/05 09/24/12 $2,625.00
<br />FHLMC 3133F1-DH-7 $150,000.00 4.00% 03/25/04 03/15/05 03/15/12 $3,833.33
<br />FHLBC 3133X5-N5-3 $250,000.00 4.25% 04/19/04 07/19/04 10/19/11 $5,312.50
<br />FNMA 3136F5-QC-8 $200,394.17 4.73% 04/22/04 07/08/04 04/08/11 $4,730.00
<br />FHLBC 3133X1-AW-7 $100,411.37 4.00% 05/06/04 09/29/04 09/29/08 $2,000.00
<br />FHLMC 3128XO-N5-4 $165,000.00 5.00% 08/24/04 08/04/04 02/27/13 $0.00
<br />FNMA 3136F5-YM-8 $0.00 4.80% 05/06/04 08/06/04 11/06/09 $1,922.66
<br />FHLBC (callled) 3133X7-LP-7 $0.00 4.03% 06/28/04 09/28/04 09/28/07 $0.00
<br />FNMA 3136F5-KR-1 $100,000.12 4.28% 09/28/04 10/08/04 03/30/11 $0.00
<br /> $2,477,627.92 $80,299.63
<br />TOTAL CASH AND INVESTMENTS $7,858,890.05 $203,810.01
<br />Petty Cash
<br />Change Fund Kim $100.00
<br />Imprest Kris $100.00
<br />Total PettY Cash $200.00 I
<br /> lL1tlILUU44: ;J t-'M scnedule 01 Investmenlrn:3lJ-
<br />
<br />4xls.xls
<br />1
<br />
|