Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2007-01-10 Add'l Handouts
Phases 01 02 03 04 ~ , 'L ., I , l...~ \ ........ -, - ," v ..... ...,... - -~ ....- .. .~ ::"-~~ ~." ~~~ <<2t- ': ~ :~.. _.,,: """ ,~AA - p .07 J .fl.. "Iff DOWNTOWN CENTERVILLE REDEVELOPMENT 2007 BEARD DEVELOPMENT County Land Price Public Total Price Estimated Estimated Per Square Improvements Per Square Average Difference After Value of Maximun Est. Difference Location Market Price Purchase Price Size Foot Cost Est. Total Price Foot Market Price Land Sale Development TIF After TIF Block 1 831600 1164240 90000 $ 12.94 $ 360,000 $ 1,524,240 $ 16.94 $ 7.00 $ (9.94) $5,640,000 $ 485,526.50 $ (4.54) Block 2 1029600 1441440 90000 $ 16.02 $ 360,000 $ 1,801,440 $ 20.02 $ 7.00 $ (13.02) $5,640,000 $ 470,066.86 $ (7.79) Block 3 1111100 1555540 90000 $ 17.28 $ 360,000 $ 1,915,540 $ 21.28 $ 7.00 $ (14.28) $8,100,000 $ 1,128,893.62 $ (1.74) Block 4 410100 574140 45000 $ 12.76 $ 180,000 $ 754,140 $ 16.76 $ 7.00 $ (9.76) $6,480,000 $ 958,017.71 $ 11.53 Block 5 849000 1188600 90000 $ 13.21 $ 360,000 $ 1,548,600 $ 17.21 $ 7.00 $ (10.21) $16,200,000 $ 2,424,470.29 $ 16.73 Block 6 900300 1260420 90000 $ 14.00 $ 360,000 $ 1,620,420 $ 18.00 $ 7.00 $ (11.00) $8,000,000 $ 710,495.54 $ (3.11) Block 7 548500 548500 60000 $ 9.14 $ 240,000 $ 788,500 $ 13.14 $ 7.00 $ (6.14) $4,320,000 $ 376,457.93 $ 0.13 Block 8 1008800 1412320 45000 $ 31.38 $ 180,000 $ 1,592,320 $ 35.38 $ 7.00 $ (28.38) $6,480,000 $ 887,898.86 $ (8.65) Block 9 157500 157500 22500 $ 7.00 $ 90,000 $ 247,500 $ 11.00 $ 7.00 $ (4.00) $2,835,000 $ 353,604.21 $ 11.72 Heritage 2024700 2834580 157500 $ 18.00 $ 630,000 $ 3,464,580 $ 22.00 $ 7.00 $ (15.00) $11,280,000 $ 1,055,745.30 $ (8.29) County Land Price Public Total Price Maximun Est. Estimated Estimated Per Square Improvements Per Square Total Land Difference After Value of TIF (present Difference Location Market Price Purchase Price Size Foot Cost Est. Total Price Foot Sale Proceeds Land Sale Development value) After TIF Phase One 3576000 4724000 307,500 $ 19.12 $ 1,230,000 $ 5,954,000 $ 19.30 $ 2,152,500 $ (3,801,500) $ 24,915,000 2,573,554.35 (1,227,946) Phase Two 3283800 4597320 292,500 $ 14.65 $ 1,170,000 $ 5,767,320 $ 18.65 $ 2,047,500 $ (3,719,820) $33,960,000 4,438,233.30 718,413 Phase Three 900300 1260420 90,000 $ 14.00 $ 360,000 $ 1,620,420 $ 18.00 $ 630,000 $ (990,420) $8,000,000 710,495.54 (279,924) Phase Four 1111100 1555540 90,000 $ 17.28 $ 360,000 $ 1,915,540 $ 21.28 $ 630,000 $ (2,545,540) $8,100,000 1,128,893.62 (156,646) Total $ 8,871,200 $ 12,137,280 780,000 $ 16.27 $ 3,120,000 $ 15,257,280 $ 19.31 $ 5,460,000 $ (11,057,280) $ 74,975,000 8,851,176.81 (946,103) .. , DECEMBER 2006 CITY OF CENTERVILLE CITY COUNCIL REPORT 1. Financial Statement & Budget Report 2. Bank Reconciliation & Fund Cash Balance Prepared By: John W. Meyer Finance Director General Fund Monthly Financial Report Month Ended December 31, 2006 MTD YTD Budget Variance % of Budget 12131/08 2008 2008 +(-) Used Revenues: Property Taxes 827,373.51 1,738,037.83 1,725,000.00 (13,037.83) 100.76% Other Taxes & Assessments 0.00 3,441.58 84,500.00 81,058.42 0.00% Ucenses & Permits 6,431.51 138,097.99 195,000.00 56,902.01 70.82% Building Inspection 4,216.60 82,900.69 168,000.00 85,099.31 49.35% Rnes & Forfeits 2,532.15 38,564.70 30,000.00 (8,564.70) 128.55% Intergovernmental 11,950.20 187,365.20 110,000.00 (77,365.20) 170.33% Rre Relief Aid 0.00 159,599.00 95,000.00 (64,599.00) 168.00% Charges for Services 375.50 4,089.47 2,000.00 (2,089.47) 204.47% Interest Eamlngs 3,157.03 57,800.02 40,000.00 (17,800.02) 144.50% . Miscellaneous Revenues 17,549.69 28,347.54 10,000.00 (18,347.54) 283.48% Refunds & Reimbursements 1,788.07 12,741.11 4,000.00 (8,741.11) 318.53% Fund Belance 0.00 0.00 0.00 0.00 0.00% Total Revenues 871.167.88 2,208.48&.44 2,200.&00.00 (7.986.44) 100.38% expenditures: Current General Government Mayor and Council 1,594.75 20,284.11 23,000.00 2,715.89 88.19% Elections 2,003.71 7,138.93 5,000.00 (2,138.93) 0.00% Planning & ZOning 542.76 11,879.63 10,000.00 (1,879.63) 118.80% Administration 27,380.06 340,043.24 324,600.00 (15,443.24) 104.76% Financial Administration 0.00 12,373.04 18,000.00 5,626.96 68.74% Assessing 0.00 19,180.20 20,000.00 819.80 95.90% Legal 6,037.80 71,8n.37 80,000.00 8,122.63 89.85% City Hall 1,927.68 29,902.06 38,000.00 8,097.94 78.69% Total ~neral Government 39.488.78 612,878.68 618,800.00 6,921.42 98.88% Public SafetJ Police Protection 48,114.67 627,049.34 5n,376.oo (49,673.34) 108.60% Rte Protection 0.00 248,919.00 186,000.00 (62,919.00) 133.83% Building Inspection 12,968.46 157,689.94 155,000.00 (2,689.94) 101.74% Electrical Inspection 0.00 6,175.60 9,000.00 2,824.40 68.62% CMI Defense 0.00 862.00 ' 4,000.00 3,138.00 21.55% Animal Control 0.00 2,022.40 1,500.00 (522.40) 134.83% Total Public SafetJ 81,083.13 1,042,718.28 932,878.00 (109,842.28) 111.77"Ai Public Works Public Works 8,962.13 186,037.82 170,000.00 (16,037.82) 109.43% Engineering Services 2,624.98 33,813.05 15,000.00 (18,813.05) 225.42% Recycling 256.54 8,406.28 5,000.00 (3,406.28) 168.13% Streets 1 ,971.01 17,647.66 80,000.00 62,352.34 22.06% Street Ughtlng 0.00 27,683.23 27,000.00 (683.23) 102.53% Total PubDc Works 13,814.88 273,688.04 297,000.00 23,411.98 92.12% 1/912007 2:44 PM budget GF 2006.xJs ~. .""'_1;".. MTD YTD BUdget Variance % of Budget 12131108 2006 2006 +(-) Used Culture and Recreation Park/Rec. Committee 0.00 2,378.22 2,500.00 121.78 95.13% Park/Rec. Programs . 352.00 2,333.07 10,000.00 7,666.93 23.33% Park Maintenance 1,688.39 79,105.60 65,000.00 (14,105.60) 121.70% Total Culture and Recreation 2,040.39 83,816.89 77,600.00 (6,316.89) 108.16% Community Development 21,018.88 117,428.88 0.00 (117,429.99) 0.00% Economic Development Economic Development 5,917.09 9,974.55 6,500.00 (3,474.55) 153.45% EDC - Frozen Fete Des Lacs 0.00 530.88 EDC ,; Business Directory . 0.00 0.00 EDC - Business Promotion 0.00 . 0.00 EDC - Miscellaneous 0.00 0.00 Cougar Cash 0.00 0.00 Total Economic Development 6,817.08 8,874.66 6,600.00 (3,474.66) 163.46% Unallocated Miscellaneous 0.00 100.00 0.00 (100.00) 0.00% Refunds & Reimbursements 0.00 0.00 0.00 0.00 0.00% City Summer Festival 0.00 18,944.87 20,000.00 1,055.13 94.72% Total Miscellaneous 0.00 18,044.87 20,000.00 . 1,066.13 86.22% Total CUJ'I'8nt ExpendItures 143,362.01 2,068,261.20 1,862,478.00 (89,246.21) 111.16% Capital Outlay General Government 0.00 0.00 42,124.00 42,124.00 0.00% Public Safety 0.00 0.00 0.00 0.00 0.00% Streets and Highways 0.00 0.00 100,000.00 100,000.00 0.00% Culture and Recreation 0.00 0.00 25,000.00 25,000.00 0.00% Total Capital Outlay 0.00 0.00 167,124.00 167,124.00 0.00% TOTAL EXPENDITURES 143,362.01 2,068,261.20 2,018,600.00 77,878.78 101.86% EXCESS (DEFICIT) OF REVENUES 727,786.86 148,234.24 180,800.00 (86,864.23) N/A OVER EXPENDITURES OTHER FINANCING SOURCES (lISES) Operating Transfer In 0.00 65,400.00 0.00 (65,400.00) NJA Operating Transfer Out (205,900.00) (205,900.00) (180,900.00) 25,000.00 NJA Sale of General FIxed Assets 0.00 0.00 0.00 0.00 NJA TOTAL OTHER FINANCING (206,800.00) (140,600.00) (180,800.00) (40,400.00) N/A SOURCES (USES) EXCESS (DEFICIENCY) OF 621,886.86 8,734.24 0.00 (126,284.23) REVENUE AND OTHER FINANCING SOURCES OVER EXPENDITURES AND OTHER FINANCING USES PREPARED BY: JOHN W. MEYER, FINANCE DIRECTOR 11912007 2:44 PM budget GF 2006.xIs Sewer Fund Monthly Financial Report Month Ended December 31, 2006 MTD YTD Budget Variance % of Budget 12131/06 2006 2006 +(-) Used Operating Revenue: Charges for Services 2,644.65 287,849.81 230,000.00 (57,849.81) 125.15% Total Operating Revenue 2,644.85 287,849.81 230,000.00 (&7,849.81) 125.15% Operating Expenses: Salaries and Benefits 4,748.97 78,808.80 63,n9.oo (15,029.80) 123.57% Professional Services 0.00 43,304.28 10,000.00 (33,304.28) 433.04% Supplies 350.94 7,642.61 13,550.00 5,907.39 56.40% MCES Disposal Charges 12,344.38 144,470.44 130,000.00 (14,470.44) 111.13% Utilities 144.05 1,714.56 1,500.00 (214.56) 114.30% Depreciation 0.00 0.00 30,000.00 30,000.00 0.00% Total Operating Expenses 17,588.34 275,940.&9 248,829.00 (27,111.&9) 110.90% OPERATING INCOME (14,943.&9) 11,909.12 (18,829.00) (30,738.12) -83.25% Nonoperating Revenue (Expense) Interest on Investments 4,488.64 73,572.67 26,000.00 (47,572.67) 282.97% Special Assessments 18,099.19 46,096.15 50,000.00 3,903.85 92.19% Hookup Fees and Unit Charges 2,165.50 39,482.50 80,500.00 41,017.50 49.05% Other Equipment 0.00 (25, 120.54} 0.00 25,120.54 0.00% Interest Expense 0.00 (55.00) (8,780.25) (8,725.25) 0.63% Refunds & Reimbursements Rev 0.00 43.45 0.00 (43.45) 0.00% Refunds & Reimbursements Exp 0.00 0.00 0.00 0.00 0.00% Total Nonoperating Revenue 24,763.33 134,019.23 147,719.76 13,700.62 90.73% (Expense) INCOME BEFORE OPERATING 9,809.64 145,928.36 128,890.76 (17,037.60) 113.22% TRANSFERS OPERATING TRANSFERS OUT 0.00 0.00 0.00 0.00 0.00% NET INCOME 9,809.64 145,928.36 128,890.76 (17,037.60) 113.22% CREDIT FOR DEPRECIATION ON 0.00 . 0.00 0.00 0.00 0.00% CONTRIBUTED ASSETS NET INCREASE IN RETAINED 9,809.64 145,928.36 128,890.76 (17,037.60) 113.22% . EARNINGS PREPARED BY: JOHN MEYER FINANCE DIRECTOR 1/912007 3:36 PM budget report sewer OS.xls 11912007 3:29 PM budget report water 06.x1s 2006 MONTHLY CASH/GENERAL LEDGER BALANCE RECONCILIATIONS 2006 Interest 1/31/2006 2/28/2006 3/31/2006 413012006 Bank Checking Statement Balance $ 803,247.18 $ 576,893.86 $ 550,921.59 $ 419,865.91 OufstandIng Deposits $ $ $ 0.40 $ OUtstanding Checks $ (67,n1.16) $ (63,380.72) $ (36,184.21) $ (111,439.11) Monthly Interest $ 54,083.60 $ 2,751.26 $ 1,773.36 $ 1,915.44 $ 1,325.21 Net Checking Account Balance $ 735,476.02 $ 513,513.14 $ 514,737.78 $ 308,426.80 Investments Malnstreet Bank Rex CD Beginning $ 823,948.42 $ 823,948.42 $ 993,948.42 $ 1,001,304.48 Other Tansactions $ $ 170,000.00 $ Monthly Interest $ 26,053.47 $ $ $ 7,356.06 Ending Balance $ 823,948.42 $ 993,948.42 $ 1,001,304.48 $ 1,001,304.48 Malnstreet Bank CD's Beginning $ 3,641,036.10 $ 3,641,036.10 $ 3,641,036.10 $ 3,676,5n.55 1000669381 CDARS $ 1,094,725.69 $ 1,094,725.69 $ $ 4.24% 1000532637 CDARS $ 1,104,034.85 $ 1,104,034.85 5.41 % 1001349356 CDARS $ 2,546,310.41 $ 2,546,310.41 $ 2,572,542.70 $ 2,572,542.70 Other Transactions Monthly Interest - CD $ $ $ $ Monthly Interest - CDARS $ 117,396.54 $ $ $ 35,541.45 Ending Balance $ 3,641,036.10 $ 3,641,036.10 $ 3,676,577.55 $ 3,676,577.55 Malnstreet Bank. Subtotal $ 5,200,460.54 $ 5,148,497.66 $ 5,192,619.81 $ 4,986,308.83 Smith Barney Smith Barney Money Fund Beginning $ 167,502.62 $ 170,287.32 $ 11,183.42 $ 23,972.05 Monthly Adjustments $ 98,466.58 $ 2,764:70 $ 10,896.10 $ 12,788.63 $ 12,053.34 Other Transactions $ $ (170,000.00) $ Ending Balance $ 170,287.32 $ 11,183.42 $ 23,972.05 $ 36,025.39 Smith Barney Gov't Bonds Beginning $ 1,nO,493.16 $ 1,nO,493.16 $ 1,nO,493.16 $ 1,nO,493.16 FHLB DID 9129103 $ 100,000.00 $ 100,000.00 $ 100,000.00 $ 100,000.00 FHLB DID 6130103 $ 100,411.37 $ 100,411.37 $ 100,411.37 $ 100,411.37 FHLMC DID 8/14/03 $ 150,000.00 $ 150,000.00 $ 150,000.00 $ 150,000.00 FHLMC DTD 6130103 $ 99,750.00 $ 99,750.00 $ 99,750.00 $ 99,750.00 FNMA DID 217103 $ 205,000.00 $ 205,000.00 $ 205,000.00 $ 205,000.00 FNMA DTD 3130104 $ 100,000.12 $ 100,000.12 $ 100,000.12 $ 100,000.12 FNMA DID4/8/04 $ 200,394.17 $ 200,394.17 $ 200,394.17 $ 200,394.17 FHLB DID 4/19/04 $ 250,000.00 $ 250,000.00 $ 250,000.00 $ 250,000.00 FHLM DID 11/28/03 $ $ $ $ FHLM DID 3/25/04 $ 150,000.00 $ 150,000.00 $ 150,000.00 $ 150,000.00 FHLM DID 3/17/04 $ 99,937.50 $ 99,937.50 $ 99,937.50 $ 99,937.50 FHLM DID 3/24/04 $ 150,000.00 $ 150,000.00 $ 150,000.00 $ 150,000.00 FHLM DTD 2/27/03 $ 165,000.00 $ 165,000.00 $ 165,000.00 $ 165,000.00 Other Transactions Monthly Adjustments $ Ending Balance $ 1,nO,493.16 $ 1,nO,493.16 $ 1,nO,493.16 $ 1,nO,493.16 Smith Barney CD's Beginning $ 657,100.00 $ 657,100.00 $ 657,100.00 $ 657,100.00 DIrect Merchants Bank $ 100,000.00 $ 100,000.00 $ 100,000.00 $ 100,000.00 Capitol One Bank $ 100,000.00 $ 100,000.00 $ 100,000.00 $ 100,000.00 Hemisphere NatI Bank $ 96,000.00 $ 96,000.00 $ 96,opO.OO $ 96,000.00 Lehman Brothers Bank $ 96,000.00 $ 96,000.00 $ 96,000.00 $ 96,000.00 CIB Bank $ 89,100.00 $ 89,100.00 $ 89,100.00 $ 89,100.00 Compass Bank $ $ $ $ 1st NatI Bk of Nevada $ 80,000.00 $ 80,000.00 $ 80,000.00 $ 80,000.00 Cole Taylor Bank $ 96,000.00 $ 98,000.00 $ 96,000.00 $ 96,000.00 Other Transactions Monthly Adjustments $ Ending Balance $ 657,100.00 $ 657,100.00 $ 657,100.00 $ 657,100.00 Smith Barney . Subtotal $ 2,597,880.48 $ 2,438,n6.58 $ 2,451,565.21 $ 2,463,618.55 Total CasMnvestments Per Statement $ 7,798,341.02 $ 7,587,274.24 $ 7,644,185.02 $ 7,449,927.38 General Ledger Cash Balance $ 7,798,341.02 $ 7,587,274.24 $ 7,644,185.02 $ 7,449,927.38 Total Monthly Interest & Adjustments $ 296,000.19 $ 5,535.96 $ 12,669.48 $ 57,601.58 $ 13,378.55 2008 MONTHLY CASH/GENERAL LEDGER BALANCE RECONClUATIC 2006 Interest 5/31/2006 613012006 7/31/2006 8/31/2006 Bank Checking Stateme~t Balance $ 294,770.44 $ 1,274,368.71 $ 1,004,807.57 $ 519,024.95 Outstanding Deposits $ 0.01 $ 0.01 $ 0.01 Outstanding Checks $ (141,163.62) $ (883,640.87) $ (507,562.15) $ (102,060.13) Monthly Interest $ 54,083.60 $ 1,314.32 $ 2,103.75 $ 3,672.17 $ 2,212.31 Net Checking Account Balance $ 153,606.82 $ 390,727.85 $ 497,245.43 $ 416,964.83 Investments Malnstreet Bank Rex CO Beginning $ 1,001,304.48 $ 1,001,304.48 $ 676,138.90 $ 376,138.90 Other Tansacllons $ (336,295.42) $ (300,000.00) $ 52,500.00 Monthly Interest $ 26,053.47 $ 11,129.84 $ ending Balance $ 1,001,304.48 $ 676,138.90 $ 376,138.90 $ 428,638.90 Malnstreet Bank CD's BegInnIng $ 3,676,577.55 $ 3,676,577.55 $ 2,599,341.31 $ 2,599,341.31 1000669381COARS $ $ $ 4.24% 1000532637 COARS $ 1,104,034.85 $ $ 5.41% 1001349356 COARS $ 2,572,542.70 $ 2,599,341.31 $ 2,599,341.31 $ 2,599,341.31 Other Transacllons Monthly Interest - CO $ Monthly Interest - COARS $ 117,396.54 $ 36,468.34 $ ending Balance $ 3,676,577.55 $ 2,599,341.31 $ 2,599,341.31 $ 2,599,341.31 Malnstreet Bank - SubtDtal $ 4,831,488.85 $ 3,666,208.06 $ 3,472,725.64 . $ 3,444,945.04 Smith Barney Smith Barney Monay Fund BegIMlng $ 36,025.39 $ 40,370.79 $ 50,163.12 $ 52,111.93 Monthly Adjustments $ 98,466.58 $ 4,345.40 $ 9,792.33 $ 1,948.81 $ 10,238.98 Other Transacllons ending Balance $ 40,370.79 $ 50,163.12 $ 52,111.93 $ 62,350.91 Smith Bamey Gov't Bonds Beginning $ 1,770,493.16 $ 1,770,493.16 $ 1,770,493.16. $ 1,770,493.16 FHLB OTD 9129/03 $ 100,000.00 $ 100,000.00 $ 100,000.00 $ 100,000.00 FHLB OTD 6/30/03 $ 100,411.37 $ 100,411.37 $ 100,411.37 $ 100,411.37 FHLMC OTD 8/14/03 $ 150,000.00 $ 150,000.00 $ 150,000.00 $ 150,000.00 FHLMC OTD 6130/03 $ 99,750.00 $ 99,750.00 $ 99,750.00 $ 99,750.00 FNMA OTD 217/03 $ 205,000.00 $ 205,000.00 $. 205,000.00 $ 205,000.00 FNMA OTD 3130104 $ 100,000.12 $ 100,000.12 $ 100,000.12 $ 100,000.12 FNMA OTD 4/8/04 $ 200,394.17 $ 2(10,394.17 $ 200,394.17 $ 200,394.17 FHLB OTD 4/19/04 $ 250,000.00 $ 250,000.00 $ 250,000.00 $ 250,000.00 FHLM OTD 11/28/03 $ $ $ $ FHLM OTD 3/25/04 $ 150,000.00 $ 150,000.00 $ 150,000.00 $ 150,000.00 FHLM OTD 3/17/04 $ 99,937.50 $ 99,937.50 $ 99,937.50 $ 99,937.50 FHLM OTD 3/24/04 $ 150,000.00 $ 150,000.00 $ 150,000.00 $ 150,000.00 FHLM OTD 2/27/03 $ 165,000.00 $ 165,000.00 $ 165,000.00 $ 165,000.00 Other Transacllons Monthly Adjustments $ ending Balance $ 1,770,493.16 $ 1,770,493.16 $ 1,770,493.16 $ 1,770,493.16 Smith Bamey CO's Beginning $ 657,100.00 $ 657,100.00 $ 557,100.00 $ 557,100.00 DIrect Merchants Bank $ 100,000.00 $ $ $ Capitol One Bank $ 100,000.00 $ 100,000.00 $ 100,000.00 $ 100,000.00 Hemisphere NatI Bank $ 96,000.00 $ 96,000.00 $ 96,000.00 $ 96,000.00 Lehman Brothers Bank $ 96,000.00 $ 96,000.00 $ 96,000.00 $ 96,000.00 CIB Bank $ 89,100.00 $ 89,100.00 $ 89,100.00 $. 89,100.00 Compass Bank $ $ $ $ 1sl NaU Bk of Nevada $ 80,000.00 $ 80,000.00 $ 80,000.00 $ 80,000.00 Cole Taylor Bank $ 96,000.00 $ 96,000.00 $ 96,000.00 $ 96,000.00 Other Transacllons Monthly Adjustments $ EndIng Balance $ 657,100.00 $ 557,100.00 $ 557,100.00 $ 557,100.00 Smith Barney - Subtotal $ 2,467,963.95 $ 2,377,756.28 $ 2,379,705.09 $ 2,389,944.07 Total Cashllnvestments Per Statement $ 7,299,452.80 $ 6,043,964.34 $ 5,852,430.73 $ 5,834,889.11 General Ledger Cash Balance $ 7,299,452.80 $ 6,043,964.34 $ 5,852,430.73 $ 5,834,889.11 Total Monthly Interest & Adjustments $ 296,000.19 $ 5,659.72 $ 59,494.26 $ 5,620.98 $ 12,451.29 -- --------------- 2008 MONTHLY CASH/GENERAL LEDGER BAlANCE RECONClUAnC 2006 Interest 9/3012006 10/3112006 11/3012006 1213112006 Bank Checking Statement Balance $ 3,186,768.63 $ 2,641,080.13 $ 2,589,814.99 $ 2,912,999.26 Outstanding Deposits $ $ 0.09 $ Outstanding Checks $ (222,393.26) $ (55,556.40) $ (573,101.77) $ (328,102.79) Monthly Interest $ 54,083.60 $ 9,554.42 $ 9,876.82 $ 8,405.88 $ 9,178.66 Net Checking Account Balance $ 2,964,375.37 $ 2,585,523.73 $ 2,016,713.31 $ 2,684,896.47 Investments Malnstreet Bank Rex CO Beginning $ 428,638.90 $ 432,575.58 $ 432,575.58 $ 182,303.84 other Tansactions $ $ (270,271.94) $ 100,000.00 Monthly Interest $ 26,053.47 $ 3,936.68 $ $ 3,830.89 ending Balance $ 432,575.58 $ 432,575.58 $ 162,303.64 $ 266,934.63 Ma/nstreet Bank CD's BegInning $ 2,599,341.31 $ 2,626,718.37 $ 2,626,718.37 $ 3,000,000.00 1000669381 COARS 4.24% 1000532637 COARS 5.41% 1001349356 COARS $ 2,626,718.37 $ 2,626,718.37 $ 3,000,000.00 $ 3,000,000.00 Other Transactions Monthly Interest - CD $ Monthly Interest - COARS $ 117,396.54 $ 27,3n.06 $ $ 18,009.69 $ Ending Balance $ 2,626,718.37 $2,626,718.37 $ 3,000,000.00 $ 3,000.000;00 MaInstreet Bank. Subtotal $ 6,023,669.32 $ 5,644,817.68 $ 5,179,016.95 $ 6,660,831.00 Smith Barney Smith Bamey Money Fund Beginning $ 62,350.91 $ 72,461.22 $ 87,093.81 $ 106,930.40 Monthly Adjustments $ 98,466.58 $ 10,110.31 $ 14,632.59 $ 3,836.59 $ 6,038.80 Other Transactions $ 15,000.00 $ (100,000.00) ending Balance $ 72,461.22 $ 87,093.81 $ 105,930.40 $ 10,989.20 Smith Barney Gov't Bonds Beginning $ 1,770,493.16 $ 1,770,493.16 $ 1,770,493.16 $ 1,770,493.18 FHLB OTO 9129/03 $ 100,000.00 $ 100,000.00 $ 100,000.00 $ 100,000.00 FHLB OTD 6130103 $ 100,411.37 $ 100,411.37 $ 100,411.37 $ 100,411.37 FHLMC OTD 8/14103 $ 150,000.00 $ 150,000.00 $ 150,000.00 $ 160,1100.00 FHLMC OTD 6130103 $ 99,750.00 $ 99,750.00 $ 99,750.00 $ 99,760.00 FNMA OTD 217/03 $ 205,000.00 $ 205,000.00 $ 205,000.00 $ 206,000.00 FNMA OTD 3130/04 $ 100,000.12 $ 100,000.12 $ 100,000.12 $ 100,000.12 FNMA OTD 418/04 $ 200,394.17 $ 200,394.17 $ 200,394.17 $ 200,394.17 FHLB OTD 4119/04 $ 250,000.00 $ 250,000.00 $ 250,000.00 $ 260,000.00 FHLM OTD 11128/03 $ $ $ $ FHLM OTD 3125/04 $ 150,000.00 $ 150,000.00 $ 150,000.00 $' 160,000.00 FHLM OTD 3/17/04 $ 99,937.50 $ 99,937.50 $ 99,937.50 $ 99,937.60 FHLM OTD 3124104 $ 150,000.00 $ 150,000.00 $ 150,000.00 $ 160,000.00 FHLM OTD 2127/03 $ 165,000.00 $ 165,000.00 $ 165,000.00 $ 166,000.00 Other T","sactlons Monthly Adjustments $ $ $ $ $ ending Balance $ 1,770,493.16 $ 1,770,493.16 $ 1,770,493.16 $ 1,770,493.18 Smith Barney CD's Beginning $ 557,100.00 $ 557,100.00 $ 557,100.00 $ 467,100.00 DIrect Merchants Bank $ $ $ $ Capitol One Bank $ 100,000.00 $ 100,000.00 $ $ Hemisphere NatI Bank $ 96,000.00 $ 96,000.00 $ 96,000.00 $ 88,000.00 Lehman Brothers Bank $ 96,000.00 $ 96,000.00 $ 96,000.00 $ 98,000.00 CIB Bank $ 89,100.00 $ 89,100.00 $ 89,100.00 $ 89,100.00 Compass Bank $ $ $ $ 1 st NaU Bk of Nevada $ 80,000.00 $ 8O~000.00 $ 80,000.00 $ 80.000.00 Cole Taylor Bank $ 96,000.00 $ 96,000.00 $ 96,000.00 $ 88,000.00 other Transactions Monthly Adjustments $ Ending Balance $ 557,100.00 $ 557,100.00 $ 457,100.00 $ 467,100.00 Smith Barney . Subtotal $ 2,400,054.38 $ 2,414,686.97 $ 2,333,523.56 $ 2,238,662.36 Total Cashllnvestments Per Statement $ 8,423,723.70 $ 8,059,504.65 $ 7,512,540.51 $ 8,089,393.36 General Ledger Cash Balance $ 8,423,723.70 $ 8,059,504.65 $ 7,512,540.51 $ 8,089,393.36 Total Monthly Interest & Adjustments $ 296,000.19 $ 50,978.47 $ 24,509.41 $ 30,252.16 $ 17,848.36 CITY OF CENTERVILLE Cash Balances jwm MTD MTD Current FUND Oeser Account Debit Credit Balance Last Dim 10100 GENERAL FUND G 101-10100 $915,274.04 $397,652.83 $1,732,153.70 MOUNDTRNLDEBTSER~CE G 306-10100 $48.12 $0.00 $22,840.87 21ST AVE IMP DEBT SER~CE G 308-10100 $89.12 $0.00 $41,378.92 JOINT POUCE STATION 2005A G 309-10100 $78,500.00 $6,614.26 $38,814.44 MUNI STREET IMP DEBT SER~CE G 312-10100 $128,980.90 $0.00 $472,978.92 IND PARK T1F 1-4 DEBT SERV G 317-10100 $8.02 $0.00 $14,789.n PARKVIEW DEVELOPMENT DEBT SERV G 324-10100 $259.49 $0.00 $2,365.45 ELEM WATER MAIN EXT DEBT SERV G 325-10100 $2,981.65 $0.00 $6,331.03 G.O. Bond Pheasant I 2001 G 327-10100 $1,121.26 $0.00 $524,712.97 G.O. Bond Hunters Cross 12000 G 338-10100 $1,732.98 $0.00 $61,723.73 CSAH 14WATERMAlN G 339-10100 $0.00 $0.00 -$0.07 PHEASANT MARSH II G.O. 2002 G 342-10100 $1,681.00 $0.00 $786,972.61 PEL TIER PRESERVE DEBT SERVICE G 345-10100 $17,140.29 $0.00 -$23,381.26 Hunters Crossing II G.O. Bond G 346-10100 $17,068.31 $0.00 $672,508.60 GO Bond 2006A (Hunter3lback) G 346-10100 $433.27 $22,386.10 $178,982.72 PARK CAPITAL PROJECT G 402-10100 $160,393.94 $366,473.27 $61,002.96 21ST AVENUE IMPROVEMENTS G408-10100 $545.36 $0.00 $1,090.71 MUNI STREET CAPITAL PROJECT G 412-10100 $238.86 $0.00 $111,695.44 PEDESTRIAN TRAIL WA VS G 414-10100 $7.52 $0.00 $12,809.91 STORM WATER IMP PROJECTS G 415-10100 $1,241.23 $1,518.49 $303,829.14 PHEASANT MARSH III G 443-10100 $55.25 $5,162.84 $17,485.73 HUNTERS CROSSING PHASE" G 446-10100 $71.29 $0.00 $45,048.46 CENTER~LLE TOWN OFFICE PARK G 447-10100 $0.00 $0.00 $8,437.00 HUNTER'S CROSSING 3RD ADDN G448-10100 $381.47 $2,223.87 $171,824.39 2006 Municipal Improvements G 449-10100 $1,761.35 $30,476.97 $126,100.88 WATER FUND G 601-10100 $39,021.66 $29,712.36 $537,178.06 SEWER FUND G 602-10100 $28,932.48 $19,122.84 $2,147,300.90 CABLE TV FUND G 614-10100 $6.52 $208.86 $12,417.38 Last Dim 10100 $1,397,975.3 $881,552.69 $8,089,393.36 8 &1,397,975.38 $881,552.69 $8,089,393.36 01/09107 1:34 PM Page 1