Loading...
13.1 SR 10-21-2024The 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 October 21, 2024 Prepared By Lori Stich, Finance Manager Item Description September Financial Report 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 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 September, actual revenues (excluding property taxes and transfers in) and expenditures should run about 75% of the annual budget. It is natural for some 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 in the budget are highlighted below accompanied by a general discussion of the variance. General Fund Revenues: ▪ License & permit collections are at about 59% of budget estimates. September collections were primarily building-related permits and rental licenses. ▪ Charges for services are about 93% of estimates with plan check fees and recreation fees making up the majority of September collections. ▪ Court fines which lag a month are about 78% of budget estimates including August collections received by the county. ▪ Transfers in consist of ERMU’s 4% August monthly electric revenues. Expenditures: Page 283 of 294 ▪ Total departmental expenditures are about 69% of the budget and most departments are within or below budget estimates. Multipurpose facility Through the end of September, expenditures of $1,314,369 exceeded revenues of $1,112,158 by $202,211. The majority of September collections consist of ice rent, facility rentals, concessions, and naming rights/sponsorships, while expenditures are primarily attributable to personal services and utilities. Financial Impact N/A Mission/Policy/Goal Responsible for every dollar - good stewards. Attachments 1. 09-2024 Financial reports Page 284 of 294 10-17-2024 08:52 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2024 101-GENERAL FUND FINANCIAL SUMMARY 75.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 1,024,710.11 13,085,695.81 60.66 8,484,904.19 12,812,104.73 TOTAL REVENUES 21,570,600.00 1,024,710.11 13,085,695.81 60.66 8,484,904.19 12,812,104.73 ============= ============= ============= ======= ============= ============= EXPENDITURE SUMMARY General Government City Council 213,550.00 57,272.54 175,615.42 82.24 37,934.58 181,445.77 Communications 485,300.00 37,873.57 331,661.89 68.34 153,638.11 320,326.79 Administrative Services 721,850.00 66,050.16 542,601.99 75.17 179,248.01 501,573.77 Human Resources 426,550.00 46,111.70 309,104.82 72.47 117,445.18 292,633.18 Elections 75,500.00 559.21 45,518.98 60.29 29,981.02 6,213.68 Finance 800,750.00 61,556.65 614,348.40 76.72 186,401.60 552,043.80 Information Technology 731,500.00 64,071.78 485,222.30 66.33 246,277.70 403,675.20 Legal 275,000.00 19,347.92 234,356.33 85.22 40,643.67 184,515.68 Community Development 0.00 22.47 34,329.01 0.00 ( 34,329.01) 168,396.94 Planning 485,100.00 35,228.69 330,240.20 68.08 154,859.80 178,767.80 Building Maintenance 1,085,250.00 83,508.46 775,083.62 71.42 310,166.38 758,108.06 TOTAL General Government 5,300,350.00 471,603.15 3,878,082.96 73.17 1,422,267.04 3,547,700.67 Public Safety Police Administration 1,175,550.00 77,774.83 966,414.42 82.21 209,135.58 888,830.34 Patrol 3,780,150.00 287,265.80 2,674,681.91 70.76 1,105,468.09 2,555,814.91 Investigations 1,430,850.00 103,903.43 901,308.18 62.99 529,541.82 942,073.56 Police Support Services 945,800.00 70,029.76 627,089.60 66.30 318,710.40 473,924.81 Police Reserves 16,550.00 202.70 1,810.72 10.94 14,739.28 7,262.19 Public safety building 229,500.00 20,997.70 137,305.22 59.83 92,194.78 141,109.50 Fire Administration 1,332,800.00 84,795.74 804,544.43 60.36 528,255.57 751,332.69 Fire Operations 630,450.00 65,957.55 407,465.72 64.63 222,984.28 499,866.13 Emergency Management 34,750.00 1,807.74 17,156.59 49.37 17,593.41 19,027.95 Building Safety 625,500.00 47,630.64 447,643.74 71.57 177,856.26 418,656.23 Code Enforcement 126,000.00 10,504.05 90,579.97 71.89 35,420.03 84,701.15 Environmental 101,700.00 6,711.12 87,347.52 85.89 14,352.48 81,510.40 TOTAL Public Safety 10,429,600.00 777,581.06 7,163,348.02 68.68 3,266,251.98 6,864,109.86 Public Works Street Maintenance 1,742,150.00 95,289.07 1,102,975.56 63.31 639,174.44 1,126,126.62 Snow Removal 411,150.00 7,290.52 212,864.65 51.77 198,285.35 242,529.18 Equipment Services 397,300.00 30,273.08 287,837.74 72.45 109,462.26 267,984.27 Engineering 489,150.00 26,291.75 309,443.00 63.26 179,707.00 340,664.58 TOTAL Public Works 3,039,750.00 159,144.42 1,913,120.95 62.94 1,126,629.05 1,977,304.65 Page 285 of 294 10-17-2024 08:52 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2024 101-GENERAL FUND FINANCIAL SUMMARY 75.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 144,272.38 1,176,282.74 67.46 567,417.26 1,060,162.34 Parks & Rec Admin 621,100.00 43,602.38 421,677.81 67.89 199,422.19 427,708.34 Recreation Programs 181,550.00 5,100.13 133,305.02 73.43 48,244.98 125,244.10 Farmers Market 9,500.00 9,022.95 25,474.04 268.15 ( 15,974.04) 27,859.32 Sr Citizen Programs 196,000.00 21,220.70 151,374.42 77.23 44,625.58 125,048.96 TOTAL Culture & Recreation 2,751,850.00 223,218.54 1,908,114.03 69.34 843,735.97 1,766,023.06 Economic Development Economic Development 0.00 3,468.45 36,142.96 0.00 ( 36,142.96) 30,726.31 Energy City 49,050.00 2,122.72 20,488.65 41.77 28,561.35 34,986.96 TOTAL Economic Development 49,050.00 5,591.17 56,631.61 115.46 ( 7,581.61) 65,713.27 General _____________ _____________ _____________ _______ _____________ _____________ TOTAL EXPENDITURES 21,570,600.00 1,637,138.34 14,919,297.57 69.16 6,651,302.43 14,220,851.51 ============= ============= ============= ======= ============= ============= REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 612,428.23)( 1,833,601.76) 1,833,601.76 ( 1,408,746.78) Page 286 of 294 10-17-2024 08:52 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2024 101-GENERAL FUND 75.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 0.00 7,620,403.82 51.08 7,297,296.18 7,202,669.39 101-3-0000-3112 Delinquent Ad Valorem Taxes 0.00 0.00 49,612.24 0.00 ( 49,612.24) 28,680.86 101-3-0000-3121 Gravel Tax 225,000.00 0.00 68,695.16 30.53 156,304.84 61,417.95 101-3-0000-3131 Penalties/Interest 0.00 0.00 2,449.11 0.00 ( 2,449.11) 251.38 TOTAL Taxes 15,142,700.00 0.00 7,741,160.33 51.12 7,401,539.67 7,293,019.58 Licenses & Permits 101-3-0000-3211 Liquor License 82,000.00 120.00 77,805.00 94.88 4,195.00 77,630.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 450.00 101-3-0000-3214 Rental License 65,000.00 3,750.00 36,260.00 55.78 28,740.00 50,760.00 101-3-0000-3216 Mining License 26,000.00 0.00 26,887.75 103.41 ( 887.75) 26,842.75 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 ( 17.14) 15,612.86 97.58 387.14 9,820.00 101-3-0000-3229 NPDES Permit 23,000.00 1,050.00 10,325.00 44.89 12,675.00 11,900.00 101-3-0000-3231 Building Permit 600,000.00 38,523.90 319,644.10 53.27 280,355.90 461,986.55 101-3-0000-3232 Plumbing/Heating Permit 160,000.00 21,293.39 90,842.73 56.78 69,157.27 195,533.26 101-3-0000-3233 Permit Surcharge 700.00 ( 1,985.14) 5,506.01 786.57 ( 4,806.01) 2,226.74 101-3-0000-3235 Animal License 0.00 0.00 250.00 0.00 ( 250.00) 610.00 101-3-0000-3237 Other Non-Business Lic/Permit 25,000.00 831.05 8,492.24 33.97 16,507.76 29,618.07 TOTAL Licenses & Permits 1,008,200.00 63,566.06 594,980.69 59.01 413,219.31 870,542.37 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 326,632.63 329,632.63 143.32 ( 99,632.63) 279,775.23 101-3-0000-3325 Police 2% Aid 340,000.00 414,088.39 445,511.30 131.03 ( 105,511.30) 339,387.01 101-3-0000-3326 Police Training Reimb 35,000.00 0.00 0.00 0.00 35,000.00 31,316.15 101-3-0000-3329 State Crime Prevention Grant 48,000.00 0.00 31,545.97 65.72 16,454.03 21,236.32 101-3-0000-3330 Other State Grants 0.00 0.00 12,396.61 0.00 ( 12,396.61) 0.00 TOTAL Intergovernmental Rev 659,000.00 740,721.02 819,086.51 124.29 ( 160,086.51) 672,023.41 Charges for Services 101-3-0000-3412 Planning & Zoning Fees 25,000.00 3,010.00 23,680.00 94.72 1,320.00 16,546.50 101-3-0000-3413 Plan Check Fee 250,000.00 14,118.81 136,167.81 54.47 113,832.19 191,019.00 101-3-0000-3415 Special Assessment Search 500.00 0.00 150.00 30.00 350.00 95.00 101-3-0000-3417 Copies 1,500.00 30.36 1,031.82 68.79 468.18 795.27 101-3-0000-3430 Lockout Fees 3,500.00 160.00 1,468.00 41.94 2,032.00 2,100.00 101-3-0000-3431 Police Services 45,000.00 390.00 18,866.82 41.93 26,133.18 28,310.00 101-3-0000-3432 School Liaison 183,000.00 0.00 184,463.13 100.80 ( 1,463.13) 177,200.68 101-3-0000-3434 Animal Impound Fee 500.00 0.00 400.00 80.00 100.00 300.00 101-3-0000-3436 Fire Contracts 400,000.00 0.00 470,798.46 117.70 ( 70,798.46) 430,774.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 2,497.50 25,797.50 73.71 9,202.50 13,587.45 Page 287 of 294 10-17-2024 08:52 AM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2024 101-GENERAL FUND 75.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 5,065.00 25.33 14,935.00 20,551.35 101-3-0000-3461 Recreation Fees 50,000.00 75.00 42,889.04 85.78 7,110.96 48,591.94 101-3-0000-3462 Sr Center Activities 43,000.00 2,428.30 30,909.82 71.88 12,090.18 34,505.30 101-3-0000-3463 Farmer's Market 12,000.00 6,860.00 43,436.55 361.97 ( 31,436.55) 42,558.41 101-3-0000-3469 Elk RiverFest 20,000.00 0.00 22,528.00 112.64 ( 2,528.00) 26,750.11 101-3-0000-3472 Park Use Fee 40,000.00 2,723.00 47,700.78 119.25 ( 7,700.78) 42,383.54 101-3-0000-3483 Sewer Inspection Fee 15,000.00 2,200.00 13,000.00 86.67 2,000.00 12,205.00 101-3-0000-3484 Contractor License Check 1,200.00 80.00 760.00 63.33 440.00 665.00 TOTAL Charges for Services 1,148,200.00 34,572.97 1,070,122.07 93.20 78,077.93 1,088,638.94 Fines & Forfeits 101-3-0000-3510 Court Fines 150,000.00 15,617.36 113,833.26 75.89 36,166.74 113,239.05 101-3-0000-3512 Ordinance Violations 0.00 1,600.00 3,100.00 0.00 ( 3,100.00) 3,400.00 TOTAL Fines & Forfeits 150,000.00 17,217.36 116,933.26 77.96 33,066.74 116,639.05 Special Assessments _____________ _____________ _____________ _______ _____________ _____________ Other Revenue 101-3-0000-3621 Interest Income 150,000.00 0.00 156,850.76 104.57 ( 6,850.76) 135,113.55 101-3-0000-3625 Refunds & Reimbursements 145,000.00 0.00 ( 10,210.65) 7.04- 155,210.65 4,880.85 101-3-0000-3626 Contributions 25,000.00 0.00 25,750.00 103.00 ( 750.00) 42,260.00 101-3-0000-3629 Miscellaneous Revenue 10,000.00 383.21 14,308.26 143.08 ( 4,308.26) 8,289.50 TOTAL Other Revenue 330,000.00 383.21 186,698.37 56.58 143,301.63 190,543.90 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 97,500.00 109.55 ( 8,500.00) 78,500.00 101-3-0000-3942 Transfer-WWTS 175,000.00 0.00 175,000.00 100.00 0.00 170,000.00 101-3-0000-3943 Transfer-Liquor 1,000,000.00 0.00 1,000,000.00 100.00 0.00 1,000,000.00 101-3-0000-3944 Transfer-Garbage 250,000.00 0.00 58,000.00 23.20 192,000.00 56,500.00 101-3-0000-3945 Transfer-Utilities 1,400,000.00 168,249.49 1,007,490.06 71.96 392,509.94 1,058,448.69 101-3-0000-3946 Transfer-Stormwater 135,000.00 0.00 135,000.00 100.00 0.00 135,000.00 101-3-0000-3948 Transfer-EDA 46,000.00 0.00 46,000.00 100.00 0.00 45,000.00 101-3-0000-3949 Transfer-HRA 37,500.00 0.00 37,500.00 100.00 0.00 36,500.00 TOTAL Transfers In 3,132,500.00 168,249.49 2,556,714.58 81.62 575,785.42 2,580,697.48 ____________________________________________________________________________________________ TOTAL General Fund 21,570,600.00 1,024,710.11 13,085,695.81 60.66 8,484,904.19 12,812,104.73 __________________________________________________________________________________________________________________________________ TOTAL REVENUE 21,570,600.00 1,024,710.11 13,085,695.81 60.66 8,484,904.19 12,812,104.73 ============= ============= ============= ======= ============= ============= Page 288 of 294 Current Budget Year to Date Actual % of Budget Revenues: Ice Rental $893,500 $525,769 58.84% Admissions 45,000 24,106 53.57% Dry Floor Events/Craft Shows 7,000 1,285 18.36% Facility Rental 244,400 165,640 67.77% Advertising/Naming Rights/Sponsorships 178,000 107,050 60.14% Recreation fees (Skating/Hockey)290,000 141,217 48.70% Concessions/catering/vending 229,000 139,042 60.72% Other Revenues (interest, etc.)9,100 8,049 88.45% Total Revenues $1,896,000 $1,112,158 58.66% Operating expenses: Personal services $900,650 $729,830 81.03% Supplies 159,800 138,418 86.62% Other service charges 661,300 427,535 64.65% Capital Outlay 120,400 18,587 15.44% Total Expenditures $1,842,150 $1,314,369 71.35% Revenues over/(under) expenditures $53,850 ($202,211) CITY OF ELK RIVER MULTIPURPOSE FACILITY - BUDGET TO ACTUAL MONTH ENDED SEPTEMBER 30, 2024 Budget, $1,896,000 Budget, $1,842,150 Actual $1,112,158 Actual $1,314,369 $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 September 2024 Page 289 of 294 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$ 6,280,399$ 76.96% Cost of sales (6,028,000) (4,242,374) 70.38% Gross profit 2,133,000 2,038,024 95.55% Operating revenues: User charges - - - 2,630,000$ 1,846,876$ 70.22%2,009,800$ 1,305,771$ 64.97%630,000$ 448,589$ 71.20% Delinquency collections - - - 1,000 1,026 102.61%- 1,207 - - 82 - Other 9,000 3,040 33.78%180,000 119,993 66.66%- - - - - - Total operating revenues 9,000 3,040 33.78%2,811,000 1,967,895 70.01%2,009,800 1,306,978 65.03%630,000 448,671 71.22% Operating expenses: Personal services 1,070,500 861,671 80.49%863,500 584,351 67.67%45,550 34,050 74.75%- - - Supplies 28,100 27,976 99.56%324,600 175,555 54.08%23,400 1,880 8.03%1,000 315 31.54% Other service charges 355,950 281,255 79.02%972,410 920,843 94.70%1,773,250 1,127,300 63.57%453,600 60,347 13.30% Depreciation *100,000 - 0.00%1,705,000 - 0.00%- - - 495,000 - 0.00% Total operating expenses 1,554,550 1,170,902 75.32%3,865,510 1,680,749 43.48%1,842,200 1,163,230 63.14%949,600 60,663 6.39% Operating income (loss)587,450 870,162 148.13%(1,054,510) 287,146 -27.23%167,600 143,748 85.77%(319,600) 388,009 -121.40% Nonoperating revenues (expenses): Interest income 125,000 75,523 60.42%125,000 192,353 153.88%8,000 19,130 239.12%25,000 44,791 179.16% Interest expense/agent fees - - - (82,800) (82,735) 99.92%- - - - - - Total nonoperating revenues (expenses)125,000 75,523 60.42%42,200 109,618 259.76%8,000 19,130 239.12%25,000 44,791 179.16% Income (loss) before contributions & transfers 712,450 945,686 132.74%(1,012,310) 396,764 -39.19%175,600 162,878 92.76%(294,600) 432,800 -146.91% Contributions - connection fees - - - 1,000,000 499,807 49.98%- - - - - - 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) (1,250,000) 100.00%(175,000) (175,000) 100.00%(58,000) (58,000) 100.00%(175,000) (175,000) 100.00% NET INCOME (LOSS)(537,550) (304,314) 56.61%(187,310) 1,073,271 -572.99%117,600 104,878 89.18%(469,600) 257,800 -54.90% 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) (304,314) (880,310) 133,990 117,600 104,878 (469,600) 257,800 * Recorded at year-end CITY OF ELK RIVER ENTERPRISE FUNDS - BUDGET TO ACTUAL MONTH ENDED SPTEMBER 30, 2024 Liquor Sewer Garbage Stormwater Page 290 of 294 10-17-2024 08:55 AM CITY OF ELK RIVER PAGE: 1 POOLED CASH REPORT (FUND 999) AS OF: SEPTEMBER 30TH, 2024 BEGINNING CURRENT CURRENT FUND ACCOUNT# ACCOUNT NAME BALANCE ACTIVITY BALANCE __________________________________________________________________________________________________________________ CLAIM ON CASH 002-1010 Cash - Section 125 11,320.91 1,988.59 13,309.50 101-1010 Cash - General Fund 8,045,168.27 ( 617,323.39) 7,427,844.88 211-1010 Cash - Library 191,359.89 ( 9,457.47) 181,902.42 219-1010 Cash - Federal COVID Fund 1,061,373.81 5,092.19 1,066,466.00 221-1010 Cash - Multipurpose Facility ( 179,789.29)( 78,755.09)( 258,544.38) 225-1010 Cash - Park Dedication 1,126,952.22 9,246.25 1,136,198.47 228-1010 Cash - Landfill 180,305.26 ( 150.65) 180,154.61 231-1010 Cash - Landfill Const Debris 860,029.71 0.00 860,029.71 240-1010 Cash - Micro Loan Fund 1,158,716.31 1,000.00 1,159,716.31 242-1010 Cash - State DEED 276,734.06 2,642.66 279,376.72 245-1010 Cash - Development Fund 1,783,598.00 ( 2,498.25) 1,781,099.75 290-1010 Cash - Capital Outlay Reserve 2,483,653.03 ( 20,138.69) 2,463,514.34 291-1010 Cash - Insurance Reserve ( 147,906.08)( 11,526.97)( 159,433.05) 292-1010 Cash - Govt Bldgs Reserve 5,580,315.99 199,987.80 5,780,303.79 294-1010 Cash - Drug Forfeiture 7,393.31 ( 189.00) 7,204.31 296-1010 Cash - GRE Reserve 839,047.74 500.00 839,547.74 301-1010 Cash - 2020A GO CIP Bonds 245,939.09 0.00 245,939.09 302-1010 Cash - 2021A GO CIP BONDS 166,137.15 ( 500.00) 165,637.15 333-1010 Cash - 2020B (2010/2012) Bonds 176,909.82 0.00 176,909.82 343-1010 Cash - 2019A Sales Tax Bonds 8,209,905.59 332,429.06 8,542,334.65 401-1010 Cash - Pavement Mgmt 5,296,309.76 ( 5,635.00) 5,290,674.76 403-1010 Cash - Street Improvement 522,696.98 ( 6,194.00) 516,502.98 406-1010 Cash - City Wide Trunk Util 105,654.85 ( 5,660.00) 99,994.85 410-1010 Cash - Equipment Replacement 2,035,426.21 39,250.00 2,074,676.21 411-1010 Cash - Technology Replacement 45,522.11 7,432.51 52,954.62 420-1010 Cash - Active ER 1,507,124.58 2,528.25 1,509,652.83 421-1010 Cash - PS Building/Fire Sta 3 932,209.09 3,531.90 935,740.99 440-1010 Cash - Park Improvement 407,336.82 40,982.19 448,319.01 462-1010 Cash - TIF #22 Downtown Redev ( 141.66) 0.00 ( 141.66) 463-1010 Cash - TIF #23 Pref Powder 0.04 0.00 0.04 464-1010 Cash - TIF #24 Beaudry Truck ( 1,151.92) 0.00 ( 1,151.92) 465-1010 Cash - TIF 25 Jackson Hills 20,643.60 0.00 20,643.60 466-1010 Cash - TIF #26 Shoot Steel 3,068.88 ( 845.00) 2,223.88 467-1010 Cash - TIF #27 Delta Apartment 38,929.00 0.00 38,929.00 602-1010 Cash - Wastewater Treatment 9,867,501.88 139,716.67 10,007,218.55 603-1010 Cash - Liquor 3,192,410.20 ( 51,848.79) 3,140,561.41 605-1010 Cash - Garbage 995,406.79 19,502.87 1,014,909.66 607-1010 Cash - Storm Water 2,336,982.98 55,061.37 2,392,044.35 801-1010 Cash - Interest 0.00 161,262.51 161,262.51 821-1010 Cash - Developer Escrow 1,122,464.83 ( 243,215.96) 879,248.87 TOTAL CLAIM ON CASH 60,505,559.81 ( 31,783.44) 60,473,776.37 =============== ============== ============== CASH IN BANK - POOLED CASH 999-1000 A/P BANK ACCOUNTS 224,791,849.29 1,456,497.61 226,248,346.90 999-1001 PY BANK ACCOUNT (192,668,479.04)( 1,488,281.05)(194,156,760.09) 999-1002 POOLED INVESTMENTS 28,382,189.56 0.00 28,382,189.56 SUBTOTAL CASH IN BANK - POOLED CASH 60,505,559.81 ( 31,783.44) 60,473,776.37 Page 291 of 294