Loading...
HomeMy WebLinkAbout2004-10-13 Handouts tervi{{e 'EstaGllshc,f 1857 UPDATE CITY OF CENTERVILLE 10/13/04 3:43 PM Page 1 *Check Summary Register@ Name 10100 MAIN STREET BANK Paid Chk# 019645 CHOICEPOINT SERVICES INC. Paid Chk# 019646 CITY OF ST. PAUL Paid Chk# 019647 CONNEXUS ENERGY Paid Chk# 019646 CULLIGAN Paid Chk# 019649 DEPARTMENT OF Paid Chk# 019650 DRESEL CONTRACTING Paid Chk# 019651 GOPHER STATE ONE CALL INC Paid Chk# 019652 HASLER, INC. Paid Chk# 019653 IIMC Paid Chk# 019654 MARATHON ASHLAND Paid Chk# 019655 MET. COUNCIL ENV. SERVo Paid Chk# 019656 MINNESOTA RURAL WATER Paid Chk# 019657 OTTER LAKE ANIMAL CARE Paid Chk# 019658 QWEST Paid Chk# 019659 RADlOSHACK CREDIT Paid Chk# 019660 SAM'S CLUB Paid Chk# 019661 TIME SAVER Paid Chk# 019662 TOWN CRIER PROMOTIONS Paid Chk# 019663 VISU-SEWER CLEAN & SEAL Paid Chk# 019664 XCEL ENERGY Check Date OCTOBER 2004 Check Amt 10/13/2004 10/13/2004 10/13/2004 10/13/2004 10/13/2004 10/13/2004 10/13/2004 10/13/2004 10/13/2004 10/13/2004 10/13/2004 10/1312004 10/13/2004 10/13/2004 10/13/2004 10/13/2004 10/1312004 10/13/2004 10/13/2004 10/13/2004 Total Checks $24.00 DRUG TEST $67.46 ASPHALT $479.03 7087 20TH AVE N - SERV THRU9-2 $84.22 WATERlRENTAL $40.00 K. SWEENEY - NOTARY FILING FEE $246,693.79 2004 UT AND STR. IMPR. PAY REQ $75.90 SEPTEMBER SERVICES $9.05 POSTAGE METER RESET $100.00 T. BENDER MEMBER FEE $155.39 FUEL THRU SEPT 2004 $11,546.33 NOVEMBER WATERWATER SERVICES $75.00 11-4-04 CONFERENCE - J. MCPHER $38.50 ANIMAL CARE - IMPOUND FEE $112.56 612 E35-0084 SERVTHRU 10-31- $205.97 DSL FILTERS FOR MIU'S $231.22 SUPPLIES $272.00 COUNCIL MEETING 9-22-04 $94.65 P. PALZER JACKET $3,060.00 CIPP REPAIR $1,314.66 1875 FOX FUN - SERVTHRU 10-6- $264,679.73 . City of Centeruille CASH/GENERAL LEDGER BALANCE RECONClUATION September 30, 2004 Balance per Bank Statement Mainstreet Bank Checking Account #3017115 $310,641.05 Total Checking Account $310,641.05 Add Outstanding Deposits $0.16 Total Outstanding Deposits $0.16 Less Outstanding Checks See attached list 1$4,862.34) Total Outstanding Checks ($4,862.34\ Checking Account Balance $305,778.87 Add Investments See attached list $8,125,571.21 Total Investments $8,125,571.21 TOTAL CASH PER BANK $8,431,350.08 Ajustment for Outstanding EFT $0.00 TOTAL REVISED CASH PER BANK $8,431,350.08 TOTAL CASH PER GENERAL LEDGER $8,431,350.08 Auoust 31, 2004 DIFFERENCE BETWEEN BANK AND GENERAL LEDGER $0.00 10/5/2004 10:57 AM bank reconciliation Septl 04.xls CITY OF CENTERVILLE Cash Balances 10105/04 10:56 AM Page 1 Current Period: SEPTEMBER 2004 MTD MTD Current FUND Oeser Account Debit Credit Balance Cash GENERAL FUND G 101-10100 $43,585.30 $247,608.09 $779,818.15 MOUND TRAil DEBT SERVICE G 306-10100 $0.00 $0.00 $21,643.00 21 ST AVE IMP DEBT SERVICE G 308-10100 $0.00 $0.00 $36,437.04 MUNI STREET IMP DEBT SERVICE G 312-10100 $0.00 $0.00 $61,461.75 IND PARK TIF 1-4 DEBT SERV G 317-10100 $0.00 $0.00 -$7,666.66 PARKVIEW DEVELOPMENT DEBT SERV G 324-10100 $0.00 $0.00 $303,366.65 ELEM WATER MAIN EXT DEBT SERV G 325-10100 $0.00 $0.00 $5,022.50 G.O. Bond Pheasant I 2001 G 327-10100 $0.00 $0.00 $548,455.54 G.O. Bond Hunters Crossing I G 336-10100 $0.00 $0.00 $150,897.07 PHEASANT MARSH II G.O. 2002 G 342-10100 $0.00 $0.00 $824,838.29 PEL TIER PRESERVE DEBT SERVICE G 345-10100 $0.00 $0.00 $299,937.56 Hunters Crossing II G.O. Bond G 346-10100 $0.00 $6,825.00 $14,220.96 PARK CAPITAL PROJECT G 402-10100 $540.00 $0.00 $315,660.62 MUNI STREET CAPITAL PROJECT G 412-10100 $0.00 $501,900.74 $786,724.21 PEDESTRIAN TRAIL WAYS G 414-10100 $0.00 $0.00 $12,500.00 STORM WATER IMP PROJECTS G 415-10100 $1,879.44 $5.468.80 $275,736.95 PHEASANT MARSH G 438-10100 $0.00 $0.00 $154,319.64 THE SHORES G 440-10100 $0.00 $0.00 $216.02 EAGLE PASS 2ND ADDN G 441-10100 $0.00 $627.00 $56,906.06 PHEASANT MARSH II G442-10100 $0.00 $228.00 $108,376.05 PHEASANT MARSH III G 443-10100 $0.00 $0.00 $8,885.60 PEL TIER PRESERVE PROJECT G 445-10100 $0.00 $1,451.82 $219,056.71 HUNTERS CROSSING PHASE II G 446-10100 $0.00 $11,241.18 $181,844.91 WATER FUND G 601-10100 $14,668.27 $103,409.51 $1,165,323.25 SEWER FUND G 602-10100 $19,576.90 $38,524.65 $2,062,120.85 CABLE TV FUND G 614-10100 $0.00 $173.45 $15,809.40 SAVINGS & CD INTEREST G 619-10100 $31,437.96 $0.00 $31,437.96 Total Cash $111,687.87 $917,458.24 $8,431,350.08 Grand Total $111,687.87 $917,458.24 $8,431,350.08 Cltv of Centerville Schedule of Cash and Investments Month Ended SeDtember 3D, 2004 Account Number Face or InUlrest Ac ulsition Call D., VTD Account Value "to D.to Datil Date Interest Malnstreet Bank ChecKln 3017115 $305,778.87 0.10% $352.66 FlexIble CD Savi "' 1321332 $1,683,217.78 2.00% 06126/03 $24065.73 CertificaleofDe Sit 300195 $108,149.11 4.50% 101WI02 jOl1007 $3,572.81 CertificaleofDe ;1 300196 $213,320.31 3.70% 10110102 10110104 $5,817.00 Certificate of De O!;il 300197 $214,432.88 4.00% 10/10102 10/10~ $8,312.08 Certificate of De ::oit 300198 $0.00 2.45% 10f10102 04110104 $1,387.96 Certificate of De ::oil 300209 $156480.26 4.10% 10124102 10/24105 $4,719.00 Certificate of De O$it 300259 $158759.57 3.25% 12/05102 06lO5JU5 $3,824.84 Certificate of De O$il 300265 $211679.42 3.25% 12f13102 06113105 $5,099.77 Certificate of De o::oil 300266 $160145.35 3.75% 12f13102 12/13107 $4,440.75 Cel/ifica!e of De " 300267 $0.00 2.30% 12f13102 06/13104 $1,194.09 CertificaleofDe osil 300272 $104,648.95 2.60% 12f17102 12f17104 $2,023.49 CertificaleofDe ;1 300273 $105,839.70 3.25% 12f17102 06117/05 $2,549.88 CertfficateofDe .t 300348 $207,497.08 2.95% 04/16103 10J16105 $4,528.06 Certificate of De Sit 300375 $0.00 2.01% 06103103 03103104 $503.64 CertificaleofDe ;1 300377 $0.00 2.01% 06/09103 03109104 $1,150.49 Certificate of De O!;it 300382 $0.00 2.01% 0&10103 03J1D/D4 $755.48 Certificate of De osit 300449 $153,795.78 2.50% 08f01103 11101104 $2,850.57 Certificate of De sit 300561 $102852.03 3.80% 12/04103 12104108 $2,852.03 CertificaleofDe osit 300562 $101,895.41 2.52% 12104103 12f04106 $1,895.41 CerttficateofDe OSit 300563 $200,000.00 2.10% 12/04103 11104104 $0.00 Cettificate of De 01511 300564 $200,000.00 2.10% 12/04103 11/04104 $0.00 Certificate of De sit 300585 $100,000.00 2.10% 12104103 11104104 $0.00 Certificate of De osit 300586 $254,738.53 2.50% 12f12103 12f12f06 $4,738.53 Certificate of De osil 300561 $100,000.00 2.10% 12f12103 11112104 $0.00 Certificate of De osit 300573 $100,000.00 2.10% 12116f03 11/16104 $0.00 Certificate of De " 300583 $101,666.70 2.20% 12f113103 12f18105 $1,666.70 CerlificateofD ;1 3005&1 $101,895.41 2.50% 12f18f03 12f18106 $1,895.41 CertificaleofD osil 300587 $101,666.70 2.20% 12f19103 12f19105 $1,688.10 Certificale of De osit 300680 $101228.13 2.45% 03109104 09109105 $1,228.13 Certificate of De osie 300704 $153001.71 4.00% 03123/04 03123109 $3,001.71 CertificaleofDe osit 300705 $151,934.42 2.55% 03123104 03123106 $1,934.42 Certificate of De OSlt 300733 $113,447.49 2.28% 04112104 07/12105 $641.23 Certificate of De osil 300769 $200,000.00 2.73% 051f6lO4 11118/OB $0.00 $5968072.19 $96668.95 U.S. Bank CertificaleofDe osil 3006093151 $0.00 2,47% 07112f74 07/12104 $45.76 Certificate of De osit 4670 $0,00 2.47% 12130n6 06130104 $55.16 $0_00 $100.92 MBIA 4MFund MN-01-0034-Q001 $5,093.16 0.64% $29.95 $5093.16 $21,l15 Smith Barne MOO Funds Smith Barne $10,591.6\} 0.59% $424.11 CanJlicateof ;I Ca 'Ia, one $100000.00 4.90% 11J13101 11/22106 $3,691.76 Certificate of De osit Direct Merchants $100,000,00 5.65% 06107101 06114106 $4,401.53 Certificate of 0 sltsle 6.5% First Bank PR $0.00 4.00% 06lO5JU2 06126104 06126/09 $1,925.26 CertificateofD oslt discounted CIB Bank IL $89,100.00 4.00% 03128103 03l28i04 03128111 $1,795.01 Certificate of De osil Lehmann Bros. $96,000.00 4.60% 12130103 06130104 12130110 $2,952.08 Certificate of De osit Com ass Bank $00,000.00 5.125% 06129/04 06129105 06129/11 SO.OO CertificaleofDe osil Hem!:; here Bank $96,000.00 3,600% 06125104 06125107 $0.00 FHLMC sle ~" 3133FO-WT -2 $0.00 3.00% 10/18102 10/15103 10/15109 $2496.17 FHLMCM 312925-BR-O $0,00 5.25% 061OSf02 03118104 03118109 $6,693.75 FNMA 3136F2-WY-O $0.00 4.50% 12113102 12111103 06111110 $1,637.50 FNMA 3136F2-X7.a $205,000.00 4.00% 02/07103 02106104 08f06110 $6,200.00 fHLMC dlscounled 3128X1_MZ_7 $lXl,750.00 3.00% 06130/03 12130/03 06130109 $1,500.00 fHLBC 31339X-RD-B $100,000.00 3.25% 06130103 09130103 12130108 $0.00 FHLMC 31~FO-2C-2 $150,000.00 4.00% 08114103 08/15104 02/15109 $450000 FNMA 31363F3-2K-1 $0.00 4.00% 09110/03 11/13/03 2f13109 $5,099.44 FHLMC 3126X1-7F-8 $100,000.00 3.50% 11126103 12106104 12106111 $1,827.78 FNMA 3136F4-G6-1 SO.OO 4.00% 12130103 03103104 12130/08 $4125.00 FHLMC sle ~Ie 312BX2-ZU-2 $&9,937.50 4,00% 03l17J04 03117105 09117/12 $2,000.00 FHLMC ste ~" 3128X2_57_1 $150,000.00 3,50% 03124104 03124105 09124/12 $2,625.00 FHLMC 3133F1-DH-7 $150,000.00 4.00% 03l25JU4 03115105 03115f12 $2,833.33 FHtBC 3133X5.N5-3 $250,000.00 4.25% 04f19J{/4 07/19104 10/19111 $0.00 FNMA 3136I=5-QC-8 $200,394.17 4.73% 04122104 07108104 04108111 SO.OO FHLBC 3133X1-AW-7 $100,411.37 4.00% 05106104 09129104 09129108 $0.00 FHLMC $165,000.00 5.00% 06124104 000_ 02121113 FNMA 31361=5-YM-8 $0.00 4.80% 05106104 08106/04 11106109 $1,922.66 FHLBC 3133X7-LP-7 $100,000.00 4.03% 06128104 09126104 09/28107 sa.OO $2458184.73 $60858...44 TOTAl. CASH AND INVESTMENTS $8.431,350.08 $157,656.26 p, Cash Chan eFund Kjm $100.00 1m rest Kri. $100.00 TotalPe Cash $200.00 10/512004 11:07AM schedule of investmenls5ept 30,04.xls