Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
13.1 SR 07-15-2024
The Elk River Vision A welcoming community with revolutionary and spirited resourcefulness, exceptional service, and community engagement that encourages and inspires prosperity Request for Action To City Council Item Number 13.1 Meeting Date July 15, 2024 Prepared By Lori Stich, Finance Manager Item Description Financial Report - June Reviewed by Lori Stich Joe Stremcha Cal Portner Tina Allard Action Requested Information Only Background/Discussion This report is designed to provide summary information regarding the overall level of revenues and expenditures in the General Fund, the Multipurpose Facility Special Revenue Fund, and the Enterprise Funds. These funds provide an important picture of the city’s financial health. For the month of June, actual revenues (excluding property taxes and transfers in) and expenditures should run about 50% of the annual budget. It is natural for some of the items to vary from month to month, such as exceeding budget for Supplies but being below budget for Services. This is not considered serious as long as the total expenditure budget amount is not overspent. Significant variances from budget are highlighted below accompanied with a general discussion for the variance. General Fund Revenues: ▪ June revenues include the 70% advance of the first half property tax settlement. The remaining balance is received in July. ▪ License & permit collections are at about 32% of budget estimates and consist primarily of building- related permits, rental licenses and liquor licenses. ▪ Charges for services are about 52% of estimates with plan check fees and recreation fees making up the majority of June collections. ▪ Transfers in consist of ERMU’s 4% May monthly electric revenues. The remaining transfers in will be recorded in July. Expenditures: Page 378 of 389 • Total departmental expenditures are about 44% of budget and most departments are within or below budget estimates. Multipurpose Facility Through the end of June, revenues of $825,907 exceeded expenditures of $767,153 by $58,754. The majority of June collections consist of hockey and skating registrations, ice rent, facility rentals, and naming rights/sponsorships while expenditures are primarily attributable to personal services and utilities. Financial Impact N/A Mission/Policy/Goal Grow responsibly and be good stewards for every dollar to develop a sustainable and prosperous community Attachments 1. 06-2024 Financial Reports Page 379 of 389 7-09-2024 03:57 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2024 101-GENERAL FUND FINANCIAL SUMMARY 50.00% OF YEAR COMPLETED CURRENT CURRENT YEAR TO DATE % OF BUDGET PRIOR FY BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCE __________________________________________________________________________________________________________________________________ REVENUE SUMMARY General Fund 21,570,600.00 5,593,090.46 7,053,437.82 32.70 14,517,162.18 7,068,002.25 TOTAL REVENUES 21,570,600.00 5,593,090.46 7,053,437.82 32.70 14,517,162.18 7,068,002.25 ============= ============= ============= ======= ============= ============= EXPENDITURE SUMMARY General Government City Council 213,550.00 25,606.47 95,529.09 44.73 118,020.91 72,074.78 Communications 485,300.00 37,295.73 212,000.83 43.68 273,299.17 194,293.21 Administrative Services 721,850.00 73,522.93 345,420.00 47.85 376,430.00 313,645.15 Human Resources 426,550.00 25,484.42 174,211.57 40.84 252,338.43 188,981.71 Elections 75,500.00 0.00 25,588.59 33.89 49,911.41 6,213.68 Finance 800,750.00 64,411.92 431,347.42 53.87 369,402.58 374,859.79 Information Technology 731,500.00 48,061.81 279,339.06 38.19 452,160.94 254,320.31 Legal 275,000.00 0.00 138,028.70 50.19 136,971.30 110,367.86 Community Development 0.00 13.57 34,279.03 0.00 ( 34,279.03) 119,065.09 Planning 485,100.00 35,539.30 211,045.82 43.51 274,054.18 114,026.77 Building Maintenance 1,085,250.00 93,188.63 490,502.78 45.20 594,747.22 479,106.29 TOTAL General Government 5,300,350.00 403,124.78 2,437,292.89 45.98 2,863,057.11 2,226,954.64 Public Safety Police Administration 1,175,550.00 182,185.32 742,377.90 63.15 433,172.10 634,497.85 Patrol 3,780,150.00 271,618.54 1,630,649.81 43.14 2,149,500.19 1,605,595.07 Investigations 1,430,850.00 95,826.89 520,096.66 36.35 910,753.34 587,151.00 Police Support Services 945,800.00 70,301.96 375,461.22 39.70 570,338.78 305,028.34 Police Reserves 16,550.00 91.22 770.06 4.65 15,779.94 3,408.28 Public safety building 229,500.00 15,594.67 75,883.25 33.06 153,616.75 96,053.10 Fire Administration 1,332,800.00 86,965.15 502,668.33 37.72 830,131.67 496,001.38 Fire Operations 630,450.00 53,069.42 265,300.54 42.08 365,149.46 338,054.36 Emergency Management 34,750.00 696.15 8,396.56 24.16 26,353.44 15,625.60 Building Safety 625,500.00 47,794.36 284,222.15 45.44 341,277.85 267,038.26 Code Enforcement 126,000.00 9,277.20 56,514.30 44.85 69,485.70 52,511.92 Environmental 101,700.00 9,768.73 56,599.56 55.65 45,100.44 44,935.21 TOTAL Public Safety 10,429,600.00 843,189.61 4,518,940.34 43.33 5,910,659.66 4,445,900.37 Public Works Street Maintenance 1,742,150.00 200,233.65 760,937.89 43.68 981,212.11 661,281.53 Snow Removal 411,150.00 2,850.00 204,643.13 49.77 206,506.87 236,787.21 Equipment Services 397,300.00 29,940.60 183,981.20 46.31 213,318.80 166,411.92 Engineering 489,150.00 26,619.39 219,342.00 44.84 269,808.00 218,508.82 TOTAL Public Works 3,039,750.00 259,643.64 1,368,904.22 45.03 1,670,845.78 1,282,989.48 Page 380 of 389 7-09-2024 03:57 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2024 101-GENERAL FUND FINANCIAL SUMMARY 50.00% OF YEAR COMPLETED CURRENT CURRENT YEAR TO DATE % OF BUDGET PRIOR FY BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCE __________________________________________________________________________________________________________________________________ Culture & Recreation Parks Department 1,743,700.00 145,826.64 713,091.71 40.90 1,030,608.29 604,617.82 Parks & Rec Admin 621,100.00 32,460.85 278,784.98 44.89 342,315.02 264,368.82 Recreation Programs 181,550.00 24,796.00 57,079.96 31.44 124,470.04 65,787.99 Farmers Market 9,500.00 4,767.46 6,471.61 68.12 3,028.39 2,382.70 Sr Citizen Programs 196,000.00 16,835.50 92,874.69 47.39 103,125.31 79,978.31 TOTAL Culture & Recreation 2,751,850.00 224,686.45 1,148,302.95 41.73 1,603,547.05 1,017,135.64 Economic Development Economic Development 0.00 97.94 23,281.75 0.00 ( 23,281.75) 21,563.50 Energy City 49,050.00 2,102.72 13,121.60 26.75 35,928.40 27,148.20 TOTAL Economic Development 49,050.00 2,200.66 36,403.35 74.22 12,646.65 48,711.70 General _____________ _____________ _____________ _______ _____________ _____________ TOTAL EXPENDITURES 21,570,600.00 1,732,845.14 9,509,843.75 44.09 12,060,756.25 9,021,691.83 ============= ============= ============= ======= ============= ============= REVENUES OVER/(UNDER) EXPENDITURES 0.00 3,860,245.32 ( 2,456,405.93) 2,456,405.93 ( 1,953,689.58) Page 381 of 389 7-09-2024 03:57 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2024 101-GENERAL FUND 50.00% OF YEAR COMPLETED CURRENT CURRENT YEAR TO DATE % OF BUDGET PRIOR FY REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCE __________________________________________________________________________________________________________________________________ General Fund ============ Taxes 101-3-0000-3111 Current Ad Valorem Taxes 14,917,700.00 5,335,966.79 5,332,640.87 35.75 9,585,059.13 5,040,174.21 101-3-0000-3112 Delinquent Ad Valorem Taxes 0.00 0.00 2,573.46 0.00 ( 2,573.46) 0.00 101-3-0000-3121 Gravel Tax 225,000.00 0.00 13,155.99 5.85 211,844.01 8,943.23 101-3-0000-3131 Penalties/Interest 0.00 0.00 752.46 0.00 ( 752.46) 0.00 TOTAL Taxes 15,142,700.00 5,335,966.79 5,349,122.78 35.32 9,793,577.22 5,049,117.44 Licenses & Permits 101-3-0000-3211 Liquor License 82,000.00 6,200.00 72,445.00 88.35 9,555.00 77,550.00 101-3-0000-3212 THC License 4,000.00 0.00 400.00 10.00 3,600.00 2,400.00 101-3-0000-3213 Cigarette License 4,000.00 0.00 450.00 11.25 3,550.00 300.00 101-3-0000-3214 Rental License 65,000.00 2,640.00 28,930.00 44.51 36,070.00 37,450.00 101-3-0000-3216 Mining License 26,000.00 6,628.20 6,628.20 25.49 19,371.80 19,235.35 101-3-0000-3217 Garbage Hauler License 2,500.00 0.00 2,505.00 100.20 ( 5.00) 765.00 101-3-0000-3218 Other Business License/Permit 16,000.00 6,240.00 11,990.00 74.94 4,010.00 8,310.00 101-3-0000-3229 NPDES Permit 23,000.00 350.00 3,675.00 15.98 19,325.00 4,550.00 101-3-0000-3231 Building Permit 600,000.00 18,631.30 143,695.40 23.95 456,304.60 276,511.90 101-3-0000-3232 Plumbing/Heating Permit 160,000.00 8,302.17 44,242.16 27.65 115,757.84 159,177.14 101-3-0000-3233 Permit Surcharge 700.00 875.99 2,816.94 402.42 ( 2,116.94) 2,672.92 101-3-0000-3235 Animal License 0.00 0.00 100.00 0.00 ( 100.00) 560.00 101-3-0000-3237 Other Non-Business Lic/Permit 25,000.00 800.00 5,391.19 21.56 19,608.81 12,795.00 TOTAL Licenses & Permits 1,008,200.00 50,667.66 323,268.89 32.06 684,931.11 602,277.31 Intergovernmental Rev 101-3-0000-3311 Federal Grant 0.00 0.00 0.00 0.00 0.00 308.70 101-3-0000-3322 MV Credit 6,000.00 0.00 0.00 0.00 6,000.00 0.00 101-3-0000-3323 Fire State Aid 230,000.00 0.00 3,000.00 1.30 227,000.00 4,000.00 101-3-0000-3325 Police 2% Aid 340,000.00 0.00 0.00 0.00 340,000.00 0.00 101-3-0000-3326 Police Training Reimb 35,000.00 0.00 0.00 0.00 35,000.00 0.00 101-3-0000-3329 State Crime Prevention Grant 48,000.00 10,959.93 10,959.93 22.83 37,040.07 2,069.79 101-3-0000-3330 Other State Grants 0.00 12,396.61 12,396.61 0.00 ( 12,396.61) 0.00 TOTAL Intergovernmental Rev 659,000.00 23,356.54 26,356.54 4.00 632,643.46 6,378.49 Charges for Services 101-3-0000-3412 Planning & Zoning Fees 25,000.00 3,643.75 14,913.75 59.66 10,086.25 12,681.50 101-3-0000-3413 Plan Check Fee 250,000.00 8,915.67 63,183.22 25.27 186,816.78 137,542.77 101-3-0000-3415 Special Assessment Search 500.00 0.00 60.00 12.00 440.00 65.00 101-3-0000-3417 Copies 1,500.00 110.38 700.78 46.72 799.22 685.39 101-3-0000-3430 Lockout Fees 3,500.00 140.00 928.00 26.51 2,572.00 1,520.00 101-3-0000-3431 Police Services 45,000.00 390.00 11,646.82 25.88 33,353.18 12,220.00 101-3-0000-3432 School Liaison 183,000.00 0.00 93,556.76 51.12 89,443.24 89,805.56 101-3-0000-3434 Animal Impound Fee 500.00 0.00 350.00 70.00 150.00 300.00 101-3-0000-3436 Fire Contracts 400,000.00 0.00 259,592.96 64.90 140,407.04 238,139.39 101-3-0000-3437 Fire Services 3,000.00 0.00 1,009.34 33.64 1,990.66 ( 300.00) 101-3-0000-3451 Street Services 35,000.00 4,000.00 15,817.50 45.19 19,182.50 8,430.00 Page 382 of 389 7-09-2024 03:57 PM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30TH, 2024 101-GENERAL FUND 50.00% OF YEAR COMPLETED CURRENT CURRENT YEAR TO DATE % OF BUDGET PRIOR FY REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCE __________________________________________________________________________________________________________________________________ 101-3-0000-3452 Engineering Services Reimb 20,000.00 0.00 0.00 0.00 20,000.00 14,635.45 101-3-0000-3461 Recreation Fees 50,000.00 1,849.00 32,996.04 65.99 17,003.96 38,124.15 101-3-0000-3462 Sr Center Activities 43,000.00 1,651.53 20,834.10 48.45 22,165.90 25,564.38 101-3-0000-3463 Farmer's Market 12,000.00 4,360.55 24,055.55 200.46 ( 12,055.55) 17,110.00 101-3-0000-3469 Elk RiverFest 20,000.00 642.61 12,484.61 62.42 7,515.39 7,024.90 101-3-0000-3472 Park Use Fee 40,000.00 5,288.39 36,028.68 90.07 3,971.32 26,725.54 101-3-0000-3483 Sewer Inspection Fee 15,000.00 1,915.00 6,940.00 46.27 8,060.00 6,190.00 101-3-0000-3484 Contractor License Check 1,200.00 60.00 415.00 34.58 785.00 325.00 TOTAL Charges for Services 1,148,200.00 32,966.88 595,513.11 51.86 552,686.89 636,789.03 Fines & Forfeits 101-3-0000-3510 Court Fines 150,000.00 13,741.45 67,500.99 45.00 82,499.01 63,884.70 101-3-0000-3512 Ordinance Violations 0.00 0.00 0.00 0.00 0.00 3,100.00 TOTAL Fines & Forfeits 150,000.00 13,741.45 67,500.99 45.00 82,499.01 66,984.70 Special Assessments _____________ _____________ _____________ _______ _____________ _____________ Other Revenue 101-3-0000-3621 Interest Income 150,000.00 0.00 89,153.01 59.44 60,846.99 73,344.57 101-3-0000-3625 Refunds & Reimbursements 145,000.00 16,765.80 ( 10,229.40) 7.05- 155,229.40 ( 1,048.82) 101-3-0000-3626 Contributions 25,000.00 0.00 25,750.00 103.00 ( 750.00) 39,760.00 101-3-0000-3629 Miscellaneous Revenue 10,000.00 850.36 4,388.87 43.89 5,611.13 4,671.71 TOTAL Other Revenue 330,000.00 17,616.16 109,062.48 33.05 220,937.52 116,727.46 Other Financing Sources _____________ _____________ _____________ _______ _____________ _____________ Transfers In 101-3-0000-3921 Transfers 0.00 0.00 224.52 0.00 ( 224.52) 748.79 101-3-0000-3926 Transfer-Capital Outlay Reserv 89,000.00 0.00 8,500.00 9.55 80,500.00 0.00 101-3-0000-3942 Transfer-WWTS 175,000.00 0.00 0.00 0.00 175,000.00 0.00 101-3-0000-3943 Transfer-Liquor 1,000,000.00 0.00 0.00 0.00 1,000,000.00 0.00 101-3-0000-3944 Transfer-Garbage 250,000.00 0.00 0.00 0.00 250,000.00 0.00 101-3-0000-3945 Transfer-Utilities 1,400,000.00 118,774.98 573,888.51 40.99 826,111.49 588,979.03 101-3-0000-3946 Transfer-Stormwater 135,000.00 0.00 0.00 0.00 135,000.00 0.00 101-3-0000-3948 Transfer-EDA 46,000.00 0.00 0.00 0.00 46,000.00 0.00 101-3-0000-3949 Transfer-HRA 37,500.00 0.00 0.00 0.00 37,500.00 0.00 TOTAL Transfers In 3,132,500.00 118,774.98 582,613.03 18.60 2,549,886.97 589,727.82 ____________________________________________________________________________________________ TOTAL General Fund 21,570,600.00 5,593,090.46 7,053,437.82 32.70 14,517,162.18 7,068,002.25 __________________________________________________________________________________________________________________________________ TOTAL REVENUE 21,570,600.00 5,593,090.46 7,053,437.82 32.70 14,517,162.18 7,068,002.25 ============= ============= ============= ======= ============= ============= Page 383 of 389 Current Budget Year to Date Actual % of Budget Revenues: Ice Rental $893,500 $403,893 45.20% Admissions 45,000 24,106 53.57% Dry Floor Events/Craft Shows 7,000 465 6.64% Facility Rental 244,400 102,550 41.96% Advertising/Naming Rights/Sponsorships 178,000 70,175 39.42% Recreation fees (Skating/Hockey)290,000 107,117 36.94% Concessions/vending 229,000 110,757 48.37% Other Revenues (interest, etc.)9,100 6,844 75.21% Total Revenues $1,896,000 $825,907 43.56% Operating expenses: Personal services $900,650 $442,771 49.16% Supplies 159,800 104,908 65.65% Other service charges 661,300 219,474 33.19% Capital Outlay 120,400 0 0.00% Total Expenditures $1,842,150 $767,153 41.64% Revenues over/(under) expenditures $53,850 $58,754 CITY OF ELK RIVER MULTIPURPOSE FACILITY - BUDGET TO ACTUAL MONTH ENDED JUNE 30, 2024 Budget, $1,896,000 Budget, $1,842,150 Actual $825,907 Actual $767,153 $0 $200,000 $400,000 $600,000 $800,000 $1,000,000 $1,200,000 $1,400,000 $1,600,000 $1,800,000 $2,000,000 Total Revenues Total Expenditures FTCenter June 2024 Page 384 of 389 Current Budget Year to Date Actual % of Budget Current Budget Year to Date Actual % of Budget Current Budget Year to Date Actual % of Budget Current Budget Year to Date Actual % of Budget Sales and cost of sales: Sales 8,161,000$ 3,984,859$ 48.83% Cost of sales (6,028,000) (2,579,026) 42.78% Gross profit 2,133,000 1,405,833 65.91% Operating revenues: User charges - - - 2,630,000$ 1,144,771$ 43.53%2,009,800$ 811,167$ 40.36%630,000$ 279,135$ 44.31% Delinquency collections - - - 1,000 - 0.00%- 117 - - 19 - Other 9,000 2,510 27.89%180,000 76,359 42.42%- - - - - - Total operating revenues 9,000 2,510 27.89%2,811,000 1,221,130 43.44%2,009,800 811,284 40.37%630,000 279,154 44.31% Operating expenses: Personal services 1,070,500 563,321 52.62%863,500 376,946 43.65%45,550 21,869 48.01%- - - Supplies 28,100 20,406 72.62%324,600 111,229 34.27%23,400 1,328 5.68%1,000 315 31.54% Other service charges 355,950 158,435 44.51%972,410 669,641 68.86%1,773,250 704,862 39.75%453,600 57,153 12.60% Depreciation *100,000 - 0.00%1,705,000 - 0.00%- - - 495,000 - 0.00% Total operating expenses 1,554,550 742,162 47.74%3,865,510 1,157,816 29.95%1,842,200 728,059 39.52%949,600 57,468 6.05% Operating income (loss)587,450 666,181 113.40%(1,054,510) 63,314 -6.00%167,600 83,225 49.66%(319,600) 221,685 -69.36% Nonoperating revenues (expenses): Interest income 125,000 50,778 40.62%125,000 124,659 99.73%8,000 12,167 152.09%25,000 28,396 113.58% Interest expense/agent fees - - - (82,800) (42,918) 51.83%- - - - - - Total nonoperating revenues (expenses)125,000 50,778 40.62%42,200 81,742 193.70%8,000 12,167 152.09%25,000 28,396 113.58% Income (loss) before contributions & transfers 712,450 716,959 100.63%(1,012,310) 145,056 -14.33%175,600 95,392 54.32%(294,600) 250,081 -84.89% Contributions - connection fees - - - 1,000,000 107,826 10.78%- - - - - - Transfers in (ARPA funds)- 350,000 0.00% Sale of assets - - 0.00%- 1,700 0.00%- - 0.00%- - 0.00% Transfers out (1,250,000) - 0.00%(175,000) - 0.00%(58,000) - 0.00%(175,000) - 0.00% NET INCOME (LOSS)(537,550) 716,959 -133.38%(187,310) 604,581 -322.77%117,600 95,392 81.12%(469,600) 250,081 -53.25% Items reclassified to balance sheet at year end: Bond Proceeds - - Capital Outlay (91,000) - - (173,000) (419,281) - - - - - - - Bond Payment (Payoff 2014B Refunded Debt)- - - (520,000) (520,000) - - - - - - - Revenues over/(under) expenditures (628,550) 716,959 (880,310) (334,700) 117,600 95,392 (469,600) 250,081 * Recorded at year-end CITY OF ELK RIVER ENTERPRISE FUNDS - BUDGET TO ACTUAL MONTH ENDED JUNE 30, 2024 Liquor Sewer Garbage Stormwater Page 385 of 389 7-09-2024 04:44 PM CITY OF ELK RIVER PAGE: 1 POOLED CASH REPORT (FUND 999) AS OF: JUNE 30TH, 2024 BEGINNING CURRENT CURRENT FUND ACCOUNT# ACCOUNT NAME BALANCE ACTIVITY BALANCE __________________________________________________________________________________________________________________ CLAIM ON CASH 002-1010 Cash - Section 125 11,434.53 ( 824.17) 10,610.36 101-1010 Cash - General Fund 2,178,890.84 4,619,279.18 6,798,170.02 211-1010 Cash - Library 175,747.87 17,110.72 192,858.59 219-1010 Cash - Federal COVID Fund 1,083,551.84 3,758.69 1,087,310.53 221-1010 Cash - Multipurpose Facility ( 26,034.00) 49,657.01 23,623.01 225-1010 Cash - Park Dedication 1,448,021.34 ( 9,739.20) 1,438,282.14 228-1010 Cash - Landfill 189,828.80 ( 12,282.70) 177,546.10 231-1010 Cash - Landfill Const Debris 854,027.21 0.00 854,027.21 240-1010 Cash - Micro Loan Fund 1,150,477.56 3,511.52 1,153,989.08 242-1010 Cash - State DEED 464,433.80 181.21 464,615.01 245-1010 Cash - Development Fund 1,701,579.03 49,067.57 1,750,646.60 290-1010 Cash - Capital Outlay Reserve 2,668,657.38 ( 13,160.68) 2,655,496.70 291-1010 Cash - Insurance Reserve ( 107,713.26)( 51,678.85)( 159,392.11) 292-1010 Cash - Govt Bldgs Reserve 5,162,344.30 244,831.26 5,407,175.56 294-1010 Cash - Drug Forfeiture 7,274.65 0.00 7,274.65 296-1010 Cash - GRE Reserve 832,195.21 0.00 832,195.21 301-1010 Cash - 2020A GO CIP Bonds 33,715.44 217,660.39 251,375.83 302-1010 Cash - 2021A GO CIP BONDS 20,085.48 140,265.61 160,351.09 333-1010 Cash - 2020B (2010/2012) Bonds ( 173,296.30) 0.00 ( 173,296.30) 343-1010 Cash - 2019A Sales Tax Bonds 7,911,713.14 ( 267,127.84) 7,644,585.30 401-1010 Cash - Pavement Mgmt 6,047,819.63 ( 981,371.61) 5,066,448.02 403-1010 Cash - Street Improvement 542,019.32 ( 6,818.50) 535,200.82 406-1010 Cash - City Wide Trunk Util 311,555.38 ( 85,643.24) 225,912.14 410-1010 Cash - Equipment Replacement 1,823,952.61 39,250.00 1,863,202.61 411-1010 Cash - Technology Replacement 51,255.81 1,922.68 53,178.49 420-1010 Cash - Active ER 1,503,597.30 ( 1,842.93) 1,501,754.37 421-1010 Cash - PS Building/Fire Sta 3 921,139.41 3,610.27 924,749.68 440-1010 Cash - Park Improvement ( 23,788.95)( 102,434.40)( 126,223.35) 462-1010 Cash - TIF #22 Downtown Redev 1,342.75 0.00 1,342.75 463-1010 Cash - TIF #23 Pref Powder 5,399.29 0.00 5,399.29 465-1010 Cash - TIF 25 Jackson Hills 18,300.30 0.00 18,300.30 466-1010 Cash - TIF #26 Shoot Steel 2,381.20 ( 363.50) 2,017.70 467-1010 Cash - TIF #27 Delta Apartment 1,398.28 0.00 1,398.28 602-1010 Cash - Wastewater Treatment 9,467,646.23 59,086.85 9,526,733.08 603-1010 Cash - Liquor 4,136,093.15 33,815.34 4,169,908.49 605-1010 Cash - Garbage 997,855.73 7,567.11 1,005,422.84 607-1010 Cash - Storm Water 2,332,774.86 51,551.25 2,384,326.11 801-1010 Cash - Interest ( 2,735.13) 116,941.89 114,206.76 821-1010 Cash - Developer Escrow 1,171,764.24 3,710.25 1,175,474.49 TOTAL CLAIM ON CASH 54,896,706.27 4,129,491.18 59,026,197.45 =============== ============== ============== CASH IN BANK - POOLED CASH 999-1000 A/P BANK ACCOUNTS 214,180,213.78 5,577,968.98 219,758,182.76 999-1001 PY BANK ACCOUNT (187,665,697.07)( 1,448,477.80)(189,114,174.87) 999-1002 POOLED INVESTMENTS 28,382,189.56 0.00 28,382,189.56 SUBTOTAL CASH IN BANK - POOLED CASH 54,896,706.27 4,129,491.18 59,026,197.45 Page 386 of 389