Loading...
HomeMy WebLinkAbout2008 - November Financial Reports Handed Out Following Meeting NOVEMBER 2008 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 November 30, 2008 ~()fj.:'. . ..61$ MTD YTD Budget Variance % of Budget 11/30/08 2008 2008 +(-) Used Revenues: Property Taxes 0.00 996,853.38 1,985,600.00 988,746.62 50.20% Other Taxes & Assessments 0.00 0.00 50,000.00 50,000.00 0.00% Licenses & Permits 18,646.98 320,239.35 170,000.00 (150,239.35) 188.38% Building Inspection 9,919.98 262,966.63 111,000.00 (151,966.63) 236.91 % Fines & Forfeits 1,509.58 24,594.06 35,000.00 10,405.94 70.27% Intergovernmental 152,930.55 201,023.63 120,000.00 (81,023.63) 167.52% Fire Relief Aid 115,664.00 119,664.00 95,000.00 (24,664.00) 125.96% Charges for Services 0.00 1,245.10 2,000.00 754.90 62.26% Interest Earnings 2,512.16 38,423.44 60,000.00 21,576.56 64.04% Miscellaneous Revenues 0.00 858.64 19,000.00 18,141.36 4.52% Refunds & Reimbursements (5,480.24) 6,577.10 0.00 (6,577.10) 0.00% Fund Balance 0.00 0.00 0.00 0.00 0.00% Total Revenues 170,119.03 1,589,814.70 2,441,600.00 851,785.30 65.11% Expenditures: Current General Government Mayor and Council 2,502.88 26,161.99 35,000.00 8,838.01 74.75% Elections 3,490.59 7,202.20 7,000.00 (202.20) 102.89% Planning & Zoning 399.24 7,530.18 10,000.00 2,469.82 75.30% Administration 25,935.49 328,852.61 403,000.00 74,147.39 81.60% Financial Administration 0.00 12,475.00 13,500.00 1,025.00 92.41% Assessing 0.00 11,374.50 19,500.00 8,125.50 58.33% legal 12,812.90 42,424.49 70,00000 27,575.51 60.61 % City Hall (7,079.00) 20,757.28 40,000.00 19,242.72 51.89% Total General Government 38,062.10 456,778.25 598,000.00 141,221.75 76.38% Public Safety Police Protection 59,219.46 653,959.01 706,100.00 52,140.99 92.62% Fire Protection 0.00 110,510.00 202,00000 91,490.00 54.71 % Building Inspection 10,624.43 122,143.54 160,000.00 37,856.46 76.34% Electrical Inspection 4,712.66 9,718.90 7,000.00 (2,718.90) 138.84% Civil Defense 0.00 653.40 3,40000 2,746.60 19.22% Animal Control 0.00 1,244.62 2,000.00 755.38 62.23% Total Public Safety 74,556.55 898,229.47 1,080,500.00 182,270.53 83.13% Public Works Public Works 10,660.79 176,142.27 180,00000 3,857.73 97.86% Engineering Services 1,162.98 17,489.16 20,000.00 2,510.84 87.45% Recycling 292.63 5,535.91 6,00000 464.09 92.27% Streets 1,008.59 11,480.99 83,00000 71,519.01 13.83% Street lighting 2,262.47 24,286.32 32,000.00 7,713.68 75.89% Total Public Works 15,387.46 234,934.65 321,000.00 86,065.35 73.19% 12/9/2008 10:14 AM budget GF 2008 november 7c~Jtf'F~" MTD YTD Budget Variance % of Budget 11/30/08 2008 2008 +(-) Used Culture and Recreation Park/Ree. Committee 0.00 860.00 4,000.00 3,140.00 21.50% Park/Rec. Programs 0.00 13,748.41 16,000.00 2,251.59 85.93% Park Maintenance 15,177.32 81,663.34 68,000.00 (13,663.34) 120.09% Total Culture and Recreation 15,177.32 96,271.75 88,000.00 (8,271.75) 109.40% Community Development 12,170.22 13,264.05 0.00 (13,264.05) 0.00% Economic Development Economic Development 0.00 2,211.84 6,500.00 4,288.16 34.03% EDC - Frozen Fete Des Lacs 0.00 0.00 EDC - Business Directory 0.00 0.00 EDC - Business Promotion 0.00 0.00 EDC - Miscellaneous 0.00 0.00 Tax Abatement 0.00 12,670.42 Total Economic Development 0.00 2,211.84 6,500.00 4,288.16 34.03% Unallocated Miscellaneous 0.00 0.00 0.00 0.00 0.00% Refunds & Reimbursements 0.00 0.00 0.00 0.00 0.00% City Summer Festival 0.00 19,336.00 20,000.00 664.00 96.68% Total Miscellaneous 0.00 19,336.00 20,000.00 664.00 96.68% Total Current Expenditures 155,353.65 1,721,026.01 2,114,000.00 406,238.04 81.41% Capital Outlay General Government 0.00 11,104.76 23,000.00 11,895.24 48.28% Public Safety 0.00 0.00 5,000.00 5,000.00 0.00% Streets and Highways 0.00 512,450.56 95,000.00 (417,450.56) 539.42% Culture and Recreation 0.00 0.00 0.00 0.00 0.00% Total Capital Outlay 0.00 523,555.32 123,000.00 (400,555.32) 425.65% TOTAL EXPENDITURES 155,353.65 2,244,581.33 2,237,000.00 5,682.72 100.34% EXCESS (DEFICIT) OF REVENUES 14,765.38 (654,766.63) 204,600.00 846,102.58 N/A OVER EXPENDITURES OTHER FINANCING SOURCES (USES) Operating Transfer In 0.00 36,548.03 0.00 (36,548.03) N/A Operating Transfer Out 0.00 (205,029.24) (204,600.00) 429.24 N/A Sale of General Fixed Assets 0.00 0.00 0.00 0.00 N/A TOTAL OTHER FINANCING 0.00 (168,481.21 ) (204,600.00) (36,118.79) N/A SOURCES (USES) EXCESS (DEFICIENCY) OF 14,765.38 (823,247.84 ) 0.00 809,983.79 REVENUE AND OTHER FINANCING SOURCES OVER EXPENDITURES AND OTHER FINANCING USES PREPARED BY: JOHN W. MEYER, FINANCE DIRECTOR 12/9/2008 10:14 AM budget GF 2008 november Water Fund Monthly Financial Report Month Ended November 30, 2008 "Of~"".. Q1..~ MTD YTD Budget Variance % of Budget 11/30/08 2008 2008 +(-) Used Operating Revenue: Charges for Services 4,293.33 181,284.44 330,000.00 148,715.56 54.93% Total Operating Revenue 4,293.33 181,284.44 330,000.00 148,715.56 54.93% Operating Expenses: Salaries and Benefits 6,027.75 75,167.75 75,000.00 (167.75) 100.22% Professional Services 0.00 6,000.00 40,000.00 34,000.00 15.00% Supplies (1,182.25) 50,288.11 30,000.00 (20,288.11 ) 167.63% Other Services and Charges 1,542.30 6,114.30 40,000.00 33,885.70 15.29% Utilities 1,393.31 10,446.26 5,000.00 (5,446.26) 208.93% Depreciation 0.00 0.00 155,000.00 155,000.00 0.00% Total Operating Expenses 7,781.11 148,016.42 345,000.00 196,983.58 42.90% OPERATING INCOME (3,487.78) 33,268.02 (15,000.00) (48,268.02) -221.79% Nonoperating Revenue (Expense) Interest on Investments 1,250.96 13,567.95 15,000.00 1,432.05 90.45% Special Assessments 0.00 24,887.39 0.00 (24,887.39) 0.00% Hook up Fees and Unit Charges 20.00 30,171.66 0.00 (30,171.66) 0.00% Other Equipment 12,991.30 (201,094.50) 0.00 201,094.50 0.00% Interest Expense 0.00 0.00 0.00 0.00 0.00% Community Development Exp 0.00 0.00 0.00 0.00 0.00% Refunds & Reimbursements Rev 73.12 5,881.73 0.00 (5,881.73) 0.00% Refunds & Reimbursements Exp 0.00 0.00 0.00 0.00 0.00% Total Nonoperating Revenue 14,335.38 (126,585.77) 15,000.00 141,585.77 -843.91% (Expense) INCOME BEFORE OPERATING 10,847.60 (93,317.75) 0.00 93,317.75 0.00% TRANSFERS OPERATING TRANSFERS OUT 0.00 0.00 0.00 0.00 0.00% NET INCOME 10,847.60 (93,317.75) 0.00 93,317.75 0.00% CREDIT FOR DEPRECIATION ON 0.00 0.00 0.00 0.00 0.00% CONTRIBUTED ASSETS NET INCREASE IN RETAINED 10,847.60 (93,317.75) 0.00 93,317.75 0.00% EARNINGS PREPARED BY: JOHN MEYER FINANCE DIRECTOR 12/9/2008 2:12 PM budget report water 08 Sewer Fund Monthly Financial Report Month Ended November 30, 2008 '~'.Jf~.. 9*.~ MTD YTD Budget Variance % of Budget 11/30/08 2008 2008 +(-) Used Operating Revenue: Charges for Services 0.00 206,529.21 350,000.00 143,470.79 59.01 % Total Operating Revenue 0.00 206,529.21 350,000.00 143,470.79 59.01% Operating Expenses: Salaries and Benefits 6,114.23 73,402.98 75,000.00 1,597.02 97.87% Professional Services 0.00 19,378.69 30,000.00 10,621.31 64.60% Supplies 7,711.40 12,683.70 10,000.00 (2,683.70) 126.84% MCES Disposal Charges 13,530.63 162,367.56 200,000.00 37,632.44 81.18% Utilities 204.33 2,695.91 5,000.00 2,304.09 53.92% Depreciation 0.00 0.00 100,000.00 100,000.00 0.00% Total Operating Expenses 27,560.59 270,528.84 420,000.00 149,471.16 64.41 % OPERATING INCOME (27,560.59) (63,999.63) (70,000.00) (6,000.37) 0.00% Nonoperating Revenue (Expense) Interest on Investments 3,334.09 56,874.70 70,000.00 13,125.30 81.25% Special Assessments 0.00 15,730.92 0.00 (15,730.92) 0.00% Hook up Fees and Unit Charges 0.00 15,518.75 0.00 (15,518.75) 0.00% Other Equipment 7,365.14 (406,865.55) 0.00 406,865.55 0.00% Interest Expense 0.00 0.00 0.00 0.00 0.00% Refunds & Reimbursements Rev 0.00 0.00 0.00 0.00 0.00% Refunds & Reimbursements Exp 0.00 (314.00) 0.00 314.00 0.00% Total Nonoperating Revenue 10,699.23 (319,055.18) 70,000.00 389,055.18 -455.79% (Expense) INCOME BEFORE OPERATING (16,861.36) (383,054.81 ) 0.00 383,054.81 0.00% TRANSFERS OPERATING TRANSFERS OUT 0.00 0.00 0.00 0.00 0.00% NET INCOME (16,861.36) (383,054.81) 0.00 383,054.81 0.00% CREDIT FOR DEPRECIATION ON 0.00 0.00 0.00 0.00 0.00% CONTRIBUTED ASSETS NET INCREASE IN RETAINED (16,861.36) (383,054.81) 0.00 383,054.81 0.00% EARNINGS PREPARED BY: JOHN MEYER FINANCE DIRECTOR 12/9/2008 2:28 PM budget report sewer 08 2008 MONTHLY CASH/GENERAL LEDGER BALANCE RECONcrLlA TrONS Collateral 2008 Interest 1 0/31/2008 11/28/2008 12/31/2008 Bank Checking Statement Balance U.S. Gov't Securities $ 1,082,489.85 $ 1,183,514.06 Outstanding Deposits $ 479.20 Outstanding Checks $ (105,199.04) $ (305,994.49) Other Transactions $ (9,044.57) $ Monthly Interest $ 23,543.15 $ 2,571.42 $ 2,190.60 Net Checking Account Balance $ 968,725.44 $ 877,519.57 Investments Mainstreet Bank Flex CD Beginning $ 702,860.99 $ 702,860.99 Other Transactions $ 205,000.00 Monthly Interest $ 41,098.72 $ Ending Balance U.S. Gov't Securities $ 702,860.99 $ 907,860.99 Mainstreet Bank CD's Beginning 1003302586 CDARS $ 600,000.00 $ 600,000.00 1003111039 CDARS $ 1003154544 CDARS 1003638274 CDARS $ 350,000.00 $ 360,000.00 1004175111 CDARS $ 687,505.19 $ 693,844.38 1004296636 CDARS $ 1,170,858.77 $ 1,170,858.77 Monthly Interest - CDARS $ 62,761.14 $ Ending Balance FDIC(s) $ 2,808,363.96 $ 2,814,703.15 Mainstreet Bank - Subtotal $ 4,479,950.39 $ 4,600,083.71 Smith Barney Smith Barney Money Fund Beginning $ 104,175.53 $ 106,666.74 Monthly Adjustments $ 26,734.43 $ 2,491.21 $ 1,721.29 Other Transactions $ (105,000.00) Ending Balance U.S. Gov't Securities $ 106,666.74 $ 3,388.03 Smith Barney Gov't Bonds Beginning $ 250,493.16 $ 250,493.16 FHLB DTD 9/29/03 U.S. Gov't Securities FHLB DTD 6/30/03 U.S. Gov't Securities $ 411.37 $ 411.37 FHLMC DTD 6/30/03 U.S. Gov't Securities $ 99,750.00 $ (250.00) FNMA DTD 2/7103 U.S. Gov't Securities FNMA DTD 3/30/04 U.S. Gov't Securities $ 0.12 $ 0.12 FNMA DTD 4/8/04 U.S. Gov't Securities $ 394.17 $ 394.17 FHLB DTD 4/19/04 U.S. Gov't Securities $ $ FHLM DTD 3/25/04 U.S. Gov't Securities FHLM DTD 3/17104 U.S. Gov't Securities $ (62.50) $ (62.50) FHLM DTD 3/24/04 U.S. Gov't Securities $ 150,000.00 $ 150,000.00 Other Transactions Annual Fair Market Adjustments $ Ending Balance $ 250,493.16 $ 150,493.16 Smith Barney CD's Beginning $ 185,100.00 $ 185,100.00 Direct Merchants Bank FDIC Capitol One Bank FDIC $ 90,000.00 $ 90,000.00 Hemisphere Natl Bank FDIC Lehman Brothers Bank FDIC $ $ CIB Bank FDIC ~ (900.00) $ (900.00) Compass Bank FDIC 1 st. Nat! Bk of Nevada FDIC Cole Taylor Bank FDIC $ 96,000.00 $ 96,000.00 Other Transactions Monthly Adjustments $ Ending Balance $ 185,100.00 $ 185,100.00 Smith Barney - Subtotal $ 542,259.90 $ 338,981.19 Total Cashllnvestments Per Statement $ 5,022,210.29 $ 4,939,064.90 General Ledger Cash Balance $ 5,022,210.29 $ 4,939,064.90 Total Monthly Interest & Adjustments $ 154,137.44 $ 5,062.63 $ 3,911.89 CITY OF CENTERVILLE Cash Balances jwm MTD MTD Current FUND Oescr Account Debit Credit Balance Last Dim 10100 GENERAL FUND G 101-10100 $298,475.60 $289,037.88 $1,044,177.44 21ST AVE IMP DEBT SERVICE G 308-10100 $0.00 $0.00 $44,898.07 JOINT POLICE STATION 2005A G 309-10100 $0.00 $6,119.53 $52,534.05 MUNI STREET IMP DEBT SERVICE G 312-10100 $699.26 $0.00 $559,086.31 PARKVIEW DEVELOPMENT DEBT SERV G 324-10100 $0.00 $0.00 $6,024.15 PEL TIER PRESERVE DEBT SERVICE G 345-10100 $0.00 $0.00 $10,246.13 Hunters Crossing II G.O. Bond G 346-10100 $0.00 $0.00 -$28,619.03 GO Bond 2006A (Hunter3/back) G 348-10100 $438.48 $0.00 $403,482.86 GO Bond 2007A (CSAH 14, OM, F) G 349-10100 $228.16 $0.00 $138,766.81 PARK CAPITAL PROJECT G 402-10100 $127.13 $23,451.64 $44,388.71 PEDESTRIAN TRAIL WAYS G 414-10100 $0.00 $0.00 $12,817.25 STORM WATER IMP PROJECTS G 415-10100 $5,101.86 $1,320.11 $644,780.51 2006 Municipal Improvements G 449-10100 $0.00 $31,671.13 -$316,926.53 CSAH 14 Improvements 2007 G 450-10100 $768.63 $17,827.25 $369,571.13 2009 Street & Utility Improve G 451-10100 $0.00 $92,021.70 -$381,567.51 2007 Developments G 452-10100 $136.21 $9,522.00 $59,178.35 2007 Downtown Redevelopment G 453-10100 $143.01 $4,393.92 $95,466.05 WATER FUND G 601-10100 $67,152.05 $10,030.25 $739,170.03 SEWER FUND G 602-10100 $49,979.86 $20,423.35 $1,429,340.06 CABLE TV FUND G 614-10100 $0.00 $576.88 $12,250.06 Last Dim 10100 $423,250.25 $506,395.64 $4,939,064.90 $423,250.25 $506,395.64 $4,939,064.90 12/09/08 9: 17 AM Page 1 TAX LEVY AND TAX COLLECTION TRENDS December 9, 2008 Collection Adjusted Net Collections to Levy Year Year Levy Date % Collected 2007 I 2008* $ 1,921,713 $ 1,871,746 97.40% 2006 I 2007 $ 1,849,990 $ 1,823,034 98.54% 2005 I 2006 $ 1,731,984 $ 1,721,305 99.38% 2004 I 2005 $ 1,610,412 $ 1,606,353 99.75% 2003 I 2004 $ 1 ,441 ,999 $ 1,439,009 99.79% 2002 I 2003 $ 1,377,463 $ 1,377,463 100.00% 2001 I 2002 $ 1,364,311 $ 1,364,311 100.00% 2008* Does not include the January 2009 payment and subject to audit adjustments