Loading...
HomeMy WebLinkAbout2024.05 May Monthly Report To: Luke Stowe, City Manager From: Hitesh Desai, CFO/City Treasurer Subject: May 2024 Monthly Financial Report Date: July 5, 2024 Please find attached the financial statements as of May 31, 2024. A summary by fund for revenues, expenditures, fund, and cash balances is as follows . City of Evanston Cash & Investment Summary by Fund May 31 , 2024 Fund #Fund Revenue Expense Net Fund Balance Cash Balance 100 General 58,423,726 59,430,747 (1,007,021) 48,059,451 44,214,402 170 American Rescue Plan 634,176 1,353,060 (718,883) 1,316,088 24,695,411 175 General Assistance 738,682 497,218 241,465 1,536,310 1,536,717 176 Human Services 2,021,960 1,334,747 687,213 3,076,223 3,076,223 177 Reparations 1,013,108 1,999,243 (986,135) 567,940 567,940 178 Sustainability 779,761 386,520 393,241 1,180,541 1,180,542 180 Good Neighbor 3,002,775 1,500,124 1,502,650 1,690,975 1,690,975 185 Library 4,333,267 3,105,967 1,227,299 6,054,070 6,056,425 186 Library Debt Service 287,338 110,642 176,696 179,477 179,477 187 Library Capital Improvement FD - (498) 498 (488,016) (488,016) 200 MFT 1,531,707 302,710 1,228,997 7,513,201 7,208,334 205 E911 508,207 532,917 (24,710) 1,536,064 1,174,764 210 Special Service Area (SSA) #9 332,468 325,032 7,436 20,688 20,688 215 CDBG 9,857 222,548 (212,690) (153,367) (153,367) 220 CD Loan 14,379 - 14,379 405,343 405,344 235 Neighborhood Improvement 337 1 336 23,221 23,221 240 Home 14,760 27,061 (12,301) (4,446) (4,446) 250 Affordable Housing 1,192,209 95,201 1,097,008 3,867,634 4,022,700 320 Debt Service 7,723,387 2,424,362 5,299,025 8,204,060 8,204,060 330 Howard Ridge 652,003 1,103,088 (451,085) 1,385,752 1,371,526 335 West Evanston 1,038,691 260,377 778,314 2,995,348 2,995,290 340 Dempster-Dodge-TIF 258,193 74,046 184,147 832,405 832,347 345 Chicago Main-TIF 677,993 372,867 305,126 527,172 527,113 350 Special Service Area (SSA) #6 110,451 101,639 8,812 43,038 264,900 355 Special Service Area (SSA) #7 76,099 71,826 4,273 18,609 18,608 360 Special Service Area (SSA) #8 32,288 30,974 1,315 8,467 8,467 365 Five-Fifth TIF 440,448 322,806 117,643 (19,746) (19,804) 415 Capital Improvements 634,338 3,795,997 (3,161,660) (11,335,069) (2,548,846) 416 Crown Construction 373,990 257,990 116,000 4,920,106 4,920,107 417 Crown Community CTR Maintenance 72,915 - 72,915 737,956 737,956 420 Special Assessment 102,129 38,360 63,769 626,827 626,827 505 Parking 4,125,052 4,024,110 100,942 2,636,012 2,092,099 510-513 Water 10,269,623 12,110,450 (1,840,827) 3,590,224 (604,549) 515 Sewer 3,565,667 2,829,429 736,238 9,323,512 7,478,196 520 Solid Waste 2,807,597 2,364,390 443,207 3,374,359 2,004,148 600 Fleet 1,814,807 1,297,405 517,402 1,899,027 367,259 601 Equipment Replacement 396,357 939,253 (542,895) 2,907,083 416,628 605 Insurance 8,660,631 9,618,893 (958,262) 2,331,870 3,666,031 Memorandum Please note that the attached supporting documents have been updated to show further fund and department analysis . Included above are ending fund and cash balances as of May 31, 2024. Cash balance represents liquid cash and/or invested assets which can be used (or easily sold) to support and fund current operations. Fund balance includes illiquid assets or future cash receipts or disbursements such as receivables (including property tax) due to the City and accounts payable/accrued expenses The FY 2023 annual audit by Sikich, LLP was finalized in June of 2024. There is a three (3) months lag in some of the state distributed revenues like Sales Tax, Home Rule Sales Tax, Use Tax and Telecommunication Tax. The unaudited financials as of May 31, 2024, show the General Fund with a fund balance of $48,059,451 and cash balance of $44,214,402 . The attached financials show General Fund revenues at 44% and expenses at 41%. General Fund Expenses by Category FY 2024 Actual Revenues (Through 05/31/2024) Account Description 100 GENERAL FUND 177 REPARATIONS FUND 700 FIRE PENSION FUND 705 POLICE PENSION FUND Grand Total STATE INCOME TAX 6,140,842 - - - 6,140,842 PROPERTY TAXES 4,875,273 - - - 4,875,273 RECREATION PROGRAM FEES 3,839,174 - - - 3,839,174 BUILDING PERMITS 3,409,806 - - - 3,409,806 SALES TAX - BASIC 3,092,388 - - - 3,092,388 SALES TAX - HOME RULE 2,322,811 - - - 2,322,811 TICKET FINES-PARKING 1,380,569 - - 1,380,569 PARKING TAX 1,080,965 - - - 1,080,965 ELECTRIC UTILITY TAX 1,066,360 - - - 1,066,360 PERSONAL PROPERTY REPLACEMENT TAX 1,048,122 1,048,122 AMBULANCE SERVICE 1,033,373 - - - 1,033,373 REAL ESTATE TRANSFER TAX - 988,480 988,480 LIQUOR TAX 956,629 - - - 956,629 NATURAL GAS UTILITY TAX 765,960 - - 765,960 INVESTMENT INCOME 738,021 - - - 738,021 STATE USE TAX 676,443 - - - 676,443 General Fund 2024 Budget 2024 Actual % of Budget 2023 Budget 2023 Actual % of Budget Expenses Salary and Benefits 88,012,393 33,465,141 38%75,748,150 32,465,918 43% Insurance and Other Chargebacks 29,518,684 15,202,906 52%28,934,436 17,626,702 61% Services and Supplies 19,446,153 6,095,498 31%16,965,457 5,294,789 31% Capital Outlay 272,000 2,778,301 1021%694,500 83,213 12% Interfund Transfers 4,887,100 1,723,790 35%4,248,750 5,219,474 123% Miscellaneous 1,545,213 159,910 10%617,822 7,983 1% Community Sponsored Organizations 120,000 4,995 4%120,000 2,599 2% Contingencies 126,000 206 0%408,500 96,267 24% Expenses Total 143,927,543 59,430,747 41%127,737,614 60,796,945 48% Through May 31, 2024, Police spent 36% of budget for overtime, and Fire spent 32% of the annual budget. Overtime Expenses 2023 Actual 2024 Budget 2024 YTD % Budget Police $1,862,988 $ 1,736,349 624,736 36% Fire $1,005,238 $ 1,084,000 346,101 32% Enterprise Funds Through May 31, 2024, the Water Fund is showing a fund balance of $3,590,224 and a negative cash balance of 604,549 . Capital projects funded by IEPA loans have begun. These projects are budgeted in Other Revenue and expenses in Capital Outlay. These projects have been drawing on the existing fund balance while the City moves forward with a 2024 GO Bond issuance. Other Funds Through May 31, 2024, the Capital Improvements Fund is showing a negative fund balance of $11,335,069 and a negative cash balance of $2,548,846 . The fund continues to spend down Series 2021 and Series 2020 bond proceeds. The fund saw a significant decrease in fund balance due to the booking of expenses for projects that have been completed, but invoices not received from IDOT as well as deferred issuance of 2022 , 2023, & 2024 bonds. In May, the City Council recommended that the City move forward with issuance of GO Bonds in June 2024 for CIP Fund and Water Fund projects. Through May 31, 2024, the Fleet Fund is showing a fund balance of $1,899,027 and a cash balance of $367,259. This difference is largely a result of inventory on hand that is reflected as an asset in the fund balance but reduced from the cash balance. Through May 31, 2024, the Insurance Fund is showing a fund balance of $2,331,870 and a cash balance of $3,666,031. If there are any questions on the attached report, please contact me by phone at (847) 448 -8082 or by email: hdesai@cityofevanston.org . Detailed fund summary reports can be found at: http://www.cityofevanston.org/city -budget/financial-reports/. CERTIFICATION OF ATTACHED FINANCIAL REPORTS As required per Illinois Statute 65 ILCS 5/3.1 -35-45 I, Hitesh Desai, Treasurer of the City of Evanston, hereby affirm that I have reviewed the May 31, 2024 year -to-date financial information and reports which to the best of my knowledge appear accurate and complete. FUNDS 2024 Budget 2024 Actual % of Budget 2023 Budget 2023 Actual % of Budget 100 GENERAL FUND Revenue Charges for Services 11,655,200 5,234,291 45% 8,785,075 5,260,036 60% Fines and Forfeitures 3,725,000 1,575,282 42% 3,632,500 1,576,945 43% Interest Income 500,000 738,021 148% 55,000 553,847 1007% Interfund Transfers 9,623,390 3,384,745 35% 7,733,949 3,866,970 50% Intergovernmental Revenue 3,966,034 1,305,752 33% 3,116,184 1,358,726 44% Licenses, Permits and Fees 7,336,450 5,132,530 70% 7,543,450 3,546,333 47% Other Revenue 1,301,500 440,531 34% 1,168,600 468,672 40% Other Taxes 66,300,000 25,029,989 38% 56,570,000 26,394,343 47% Property Taxes 29,047,402 15,582,585 54% 29,047,402 15,589,708 54% Revenue Total 133,454,976 58,423,726 44% 117,652,160 58,615,579 50% Expenses 12 LEGISLATIVE - 4,687 13 CITY COUNCIL 594,133 262,763 44% 658,324 228,693 35% 14 CITY CLERK 535,355 138,434 26% 360,108 145,490 40% 15 CITY MANAGER'S OFFICE 10,177,532 2,527,486 25% 8,143,075 5,835,005 72% 17 LAW 1,354,786 431,095 32% 988,558 348,300 35% 19 ADMINISTRATIVE SERVICES 15,148,003 5,222,663 34% 12,537,670 4,767,772 38% 21 COMMUNITY DEVELOPMENT 4,687,076 1,442,102 31% 4,183,421 1,426,393 34% 22 POLICE 35,221,511 14,343,874 41% 29,214,097 14,056,424 48% 23 FIRE MGMT & SUPPORT 22,110,663 8,286,673 37% 18,689,924 8,396,467 45% 24 HEALTH 1,817,273 703,943 39% 1,413,058 765,332 54% 30 PARKS AND RECREATION 14,547,351 7,499,218 52% 12,751,313 3,864,097 30% 40 PUBLIC WORKS AGENCY 15,868,893 5,070,460 32% 13,708,631 5,267,275 38% 99 NON-DEPARTMENTAL 21,864,968 13,497,350 62% 25,089,436 15,695,696 63% Expenses Total 143,927,543 59,430,747 41%127,737,614 60,796,945 48% FUNDS 2024 Budget 2024 Actual % of Budget 2023 Budget 2023 Actual % of Budget 170 AMERICAN RESCUE PLAN Revenue Interest Income 50,000 634,176 1268% - 572,197 Other Revenue - - Revenue Total 50,000 634,176 1268% - 572,197 Expenses Capital Outlay 10,188,900 656,777 6% 800,000 386,328 48% Community Sponsored Organizations - 176,931 - 2,542 Insurance and Other Chargebacks 100,000 - 0% 850,000 - 0% Interfund Transfers 1,250,000 - 0% 2,600,000 - 0% Miscellaneous 10,294,191 301,525 3% 18,500,000 282,987 2% Salary and Benefits - 148,975 Services and Supplies 3,275,000 118,673 4% - 276,253 Expenses Total 25,108,091 1,253,905 5% 22,750,000 1,097,085 5% 175 GENERAL ASSISTANCE FUND Revenue Interest Income 1,000 34,107 3411% 1,000 18,419 1842% Other Revenue 27,500 3,766 14% 27,500 - 0% Property Taxes 1,050,000 700,809 67% 1,300,000 692,352 53% Revenue Total 1,078,500 738,682 68% 1,328,500 710,772 54% Expenses Miscellaneous 7,000 1,475 21% 7,000 4,685 67% Salary and Benefits 539,408 219,620 41% 488,738 206,831 42% Services and Supplies 874,482 276,123 32% 864,482 226,901 26% Expenses Total 1,420,890 497,218 35% 1,360,220 438,417 32% FUNDS 2024 Budget 2024 Actual % of Budget 2023 Budget 2023 Actual % of Budget 176 HUMAN SERVICES FUND Revenue Interest Income 6,000 29,186 486% - 20,383 Intergovernmental Revenue 114,000 312,774 274% 114,000 86,018 75% Other Revenue 20,000 - 0% 2,000 8,000 400% Property Taxes 3,360,000 1,680,000 50% 3,110,000 1,555,000 50% Revenue Total 3,500,000 2,021,960 58% 3,226,000 1,669,401 52% Expenses Community Sponsored Organizations 60,000 243,590 406% 60,000 257,713 430% Miscellaneous 210,000 41,081 20% 213,000 62,484 29% Salary and Benefits 2,654,369 982,600 37% 2,373,285 763,976 32% Services and Supplies 2,334,063 67,476 3% 1,804,973 34,531 2% Expenses Total 5,258,432 1,334,747 25% 4,451,258 1,118,704 25% 177 REPARATIONS FUND Revenue Interest Income 2,500 21,204 848% - 4,331 Intergovernmental Revenue 100,000 - 0% Other Revenue - 3,424 - 433 Other Taxes 1,400,000 988,480 71% 3,400,000 1,149,761 34% Revenue Total 1,502,500 1,013,108 67% 3,400,000 1,154,525 34% Expenses Miscellaneous 3,400,000 1,965,445 58% 3,400,000 57,365 2% Services and Supplies 101,000 33,798 33% - 833 Expenses Total 3,501,000 1,999,243 57% 3,400,000 58,198 2% FUNDS 2024 Budget 2024 Actual % of Budget 2023 Budget 2023 Actual % of Budget 178 SUSTAINABILITY FUND Revenue Interest Income 2,000 11,656 583% - 4,537 Interfund Transfers 700,000 583,335 83% 200,000 100,002 50% Intergovernmental Revenue 10,000 - 0% Licenses, Permits and Fees 500,000 184,770 37% 500,000 202,578 41% Other Revenue 650,000 - 0% 500,000 - 0% Revenue Total 1,862,000 779,761 42% 1,200,000 307,117 26% Expenses Community Sponsored Organizations 500,000 - 0% Miscellaneous 525,000 - 0% Salary and Benefits 250,368 95,513 38% 256,893 44,500 17% Services and Supplies 725,120 291,007 40% 546,000 70,476 13% Expenses Total 2,000,488 386,520 19% 802,893 114,976 14% 180 GOOD NEIGHBOR FUND Revenue Interest Income 1,000 2,775 277% - 7,322 Other Revenue 3,000,000 3,000,000 100% Revenue Total 3,001,000 3,002,775 100% - 7,322 Expenses Capital Outlay - 75,000 Interfund Transfers 3,000,000 1,500,000 50% 85,000 - 0% Miscellaneous 314,000 - 0% - 225,000 Services and Supplies - 124 - 80 Expenses Total 3,314,000 1,500,124 45% 85,000 300,080 353% FUNDS 2024 Budget 2024 Actual % of Budget 2023 Budget 2023 Actual % of Budget 185 LIBRARY FUND Revenue Charges for Services 400 1,451 363% 400 161 40% Interest Income 25,000 129,703 519% 21,600 90,792 420% Interfund Transfers 216,999 - 0% 250,000 - 0% Intergovernmental Revenue 200,213 11,433 6% 209,866 49,366 24% Library Revenue 109,394 48,052 44% 155,394 32,178 21% Other Revenue 405,000 93,552 23% 405,000 81,511 20% Property Taxes 8,213,664 4,049,076 49% 7,535,472 3,837,581 51% Revenue Total 9,170,670 4,333,267 47% 8,577,732 4,091,588 48% Expenses Capital Outlay 3,500 - 0% 1,500 - 0% Insurance and Other Chargebacks - 168 - 1,027 Interfund Transfers 360,325 150,130 42% 305,325 152,658 50% Salary and Benefits 7,264,128 2,328,540 32% 6,393,544 2,238,821 35% Services and Supplies 2,313,194 627,129 27% 2,247,673 726,240 32% Expenses Total 9,941,147 3,105,967 31% 8,948,042 3,118,746 35% 186 LIBRARY DEBT SERVICE FUND Revenue Property Taxes 574,677 287,338 50% 507,913 253,956 50% Revenue Total 574,677 287,338 50% 507,913 253,956 50% Expenses Debt Service 574,677 110,642 19% 507,913 - 0% Expenses Total 574,677 110,642 19% 507,913 - 0% 187 LIBRARY CAPITAL IMPROVEMENT FD Revenue Other Revenue 550,000 - 0% 950,000 - 0% Revenue Total 550,000 - 0% 950,000 - 0% Expenses Capital Outlay 550,000 - 0% 950,000 292,464 31% Expenses Total 550,000 - 0% 950,000 292,464 31% FUNDS 2024 Budget 2024 Actual % of Budget 2023 Budget 2023 Actual % of Budget 200 MOTOR FUEL TAX FUND Revenue Interest Income 15,000 152,502 1017% 12,000 61,217 510% Intergovernmental Revenue 2,986,239 1,379,205 46% 2,700,000 1,319,976 49% Revenue Total 3,001,239 1,531,707 51% 2,712,000 1,381,192 51% Expenses Capital Outlay 4,405,000 6,167 0% 2,778,600 32,124 1% Salary and Benefits 325,000 - 0% 325,000 - 0% Services and Supplies 1,890,000 296,543 16% 1,038,000 184,712 18% Expenses Total 6,620,000 302,710 5% 4,141,600 216,836 5% 205 EMERGENCY TELEPHONE (E911) FUND Revenue Interest Income 7,000 16,786 240% 7,000 11,443 163% Other Taxes 1,450,000 491,420 34% 1,400,000 485,375 35% Revenue Total 1,457,000 508,207 35% 1,407,000 496,817 35% Expenses Capital Outlay 480,000 9,310 2% 450,000 42,291 9% Insurance and Other Chargebacks 19,142 7,975 42% 19,142 9,570 50% Interfund Transfers 100,000 41,665 42% 90,000 45,000 50% Miscellaneous - 338 Salary and Benefits 810,331 274,440 34% 758,058 319,791 42% Services and Supplies 368,350 199,189 54% 355,000 164,876 46% Expenses Total 1,777,823 532,917 30% 1,672,200 581,528 35% 210 SPECIAL SERVICE AREA (SSA) #9 Revenue Interest Income - 5,044 - 1,615 Interfund Transfers 206,750 206,750 100% Property Taxes 592,665 327,425 55% 595,000 315,569 53% Revenue Total 592,665 332,468 56% 801,750 523,934 65% Expenses Services and Supplies 575,000 325,032 57% 575,000 - 0% Expenses Total 575,000 325,032 57% 575,000 - 0% FUNDS 2024 Budget 2024 Actual % of Budget 2023 Budget 2023 Actual % of Budget 215 CDBG FUND Revenue Interest Income - 3,388 - 1,822 Intergovernmental Revenue 3,068,463 6,470 0% 3,629,000 111,487 3% Revenue Total 3,068,463 9,857 0% 3,629,000 113,309 3% Expenses Capital Outlay - 6,470 - 84,605 Community Sponsored Organizations 75,000 - 0% 75,000 43,460 58% Miscellaneous 2,341,499 - 0% 2,576,376 3,696 0% Salary and Benefits 681,559 211,159 31% 702,459 174,904 25% Services and Supplies 17,480 4,919 28% 307,200 5,836 2% Expenses Total 3,115,538 222,548 7% 3,661,035 312,500 9% 220 CDBG LOAN FUND Revenue Interest Income 5,000 11,491 230% - 9,493 Other Revenue 443,121 2,888 1% 100,000 41,203 41% Revenue Total 448,121 14,379 3% 100,000 50,696 51% Expenses Services and Supplies 440,000 - 0% 325,000 44,502 14% Expenses Total 440,000 - 0% 325,000 44,502 14% 235 NEIGHBORHOOD IMPROVEMENT Revenue Interest Income - 337 - 252 Revenue Total - 337 - 252 Expenses Services and Supplies - 1 - 3 Expenses Total - 1 - 3 FUNDS 2024 Budget 2024 Actual % of Budget 2023 Budget 2023 Actual % of Budget 240 HOME FUND Revenue Interest Income 150 183 122% 150 351 234% Intergovernmental Revenue 2,345,000 3,417 0% 650,000 - 0% Other Revenue 25,000 11,160 45% 25,000 11,410 46% Revenue Total 2,370,150 14,760 1% 675,150 11,761 2% Expenses Insurance and Other Chargebacks 1,150,000 - 0% Miscellaneous 2,000 207 10% 2,000 - 0% Salary and Benefits 68,137 18,081 27% 70,572 24,056 34% Services and Supplies 801,065 8,773 1% 582,266 615 0% Expenses Total 2,021,202 27,061 1% 654,838 24,672 4% 250 AFFORDABLE HOUSING FUND Revenue Interest Income 8,000 66,050 826% 4,500 50,325 1118% Interfund Transfers 1,000,000 1,000,000 100% Intergovernmental Revenue 145,000 61,576 42% 145,000 28,760 20% Other Revenue 130,000 64,583 50% 130,600 64,583 49% Other Taxes 50,000 - 0% 50,000 - 0% Revenue Total 1,333,000 1,192,209 89% 330,100 143,668 44% Expenses Community Sponsored Organizations 154,000 61,342 40% 166,000 28,760 17% Insurance and Other Chargebacks 11,000 234 2% 12,000 - 0% Miscellaneous 1,051,500 3,620 0% 53,500 786 1% Salary and Benefits 41,038 18,081 44% 130,126 29,445 23% Services and Supplies 1,670,000 11,925 1% 1,565,000 167,043 11% Expenses Total 2,927,538 95,201 3% 1,926,626 226,034 12% FUNDS 2024 Budget 2024 Actual % of Budget 2023 Budget 2023 Actual % of Budget 320 DEBT SERVICE FUND Revenue Interest Income 10,000 38,934 389% 10,000 84,257 843% Interfund Transfers 2,693,941 670,955 25% 2,918,969 1,159,488 40% Other Revenue - 301 Property Taxes 12,766,093 7,013,196 55% 12,878,258 6,939,775 54% Revenue Total 15,470,034 7,723,387 50% 15,807,227 8,183,520 52% Expenses Debt Service 15,460,034 2,418,057 16% 15,797,123 - 0% Interfund Transfers - - Miscellaneous - (7,662) Services and Supplies 6,600 6,306 96% 6,600 17 0% Expenses Total 15,466,634 2,424,362 16% 15,803,723 (7,645) 0% 330 HOWARD-RIDGE TIF FUND Revenue Interest Income 10,000 41,086 411% 10,000 37,100 371% Other Revenue 5,000 10,500 210% 5,000 17,500 350% Property Taxes 1,100,000 600,417 55% 1,100,000 630,474 57% Revenue Total 1,115,000 652,003 58% 1,115,000 685,075 61% Expenses Capital Outlay 50,000 922,026 1844% 785,000 10,000 1% Interfund Transfers 363,513 151,465 42% 395,913 197,958 50% Miscellaneous - 22,000 - 122,367 Services and Supplies 65,000 7,597 12% 250,000 122,390 49% Expenses Total 478,513 1,103,088 231% 1,430,913 452,715 32% FUNDS 2024 Budget 2024 Actual % of Budget 2023 Budget 2023 Actual % of Budget 335 WEST EVANSTON TIF FUND Revenue Interest Income 5,000 55,712 1114% 5,000 42,203 844% Other Revenue 10,000 - 0% Property Taxes 1,450,000 982,979 68% 1,450,000 804,439 55% Revenue Total 1,455,000 1,038,691 71% 1,465,000 846,643 58% Expenses Capital Outlay 3,315,000 129,465 4% 3,660,000 1,912 0% Interfund Transfers 75,000 31,250 42% 75,000 37,500 50% Miscellaneous 12,000 13,000 108% 200,000 560,000 280% Services and Supplies 1,005,000 86,663 9% 5,000 12,535 251% Expenses Total 4,407,000 260,377 6% 3,940,000 611,947 16% 340 DEMPSTER-DODGE TIF FUND Revenue Interest Income 1,000 14,691 1469% 1,000 6,570 657% Property Taxes 180,000 243,502 135% 180,000 121,726 68% Revenue Total 181,000 258,193 143% 181,000 128,296 71% Expenses Interfund Transfers 176,857 73,690 42% 174,483 87,240 50% Services and Supplies 2,000 356 18% 2,000 6,467 323% Expenses Total 178,857 74,046 41% 176,483 93,707 53% 345 CHICAGO-MAIN TIF Revenue Interest Income 5,000 48,158 963% 2,500 31,258 1250% Other Revenue 1,880,000 50,000 3% 1,880,000 - 0% Property Taxes 1,000,000 579,834 58% 1,000,000 650,452 65% Revenue Total 2,885,000 677,993 24% 2,882,500 681,710 24% Expenses Capital Outlay 260,000 249,161 96% 2,469,000 3,178 0% Interfund Transfers 272,480 113,535 42% 271,355 135,678 50% Miscellaneous 250,000 8,400 3% 250,000 20,000 8% Services and Supplies 15,010 1,771 12% 5,000 12,532 251% Expenses Total 797,490 372,867 47% 2,995,355 171,388 6% FUNDS 2024 Budget 2024 Actual % of Budget 2023 Budget 2023 Actual % of Budget 350 SPECIAL SERVICE AREA (SSA) #6 Revenue Interest Income 250 6,728 2691% 250 4,819 1927% Property Taxes 221,000 103,723 47% 221,000 118,344 54% Revenue Total 221,250 110,451 50% 221,250 123,163 56% Expenses Services and Supplies 220,000 101,639 46% 220,000 (117,144) -53% Expenses Total 220,000 101,639 46% 220,000 (117,144) -53% 355 SPECIAL SERVICE AREA (SSA) #7 Revenue Interest Income 200 1,226 613% 200 964 482% Property Taxes 142,000 74,873 53% 142,000 77,003 54% Revenue Total 142,200 76,099 54% 142,200 77,967 55% Expenses Services and Supplies 140,000 71,826 51% 140,000 - 0% Expenses Total 140,000 71,826 51% 140,000 - 0% 360 SPECIAL SERVICE AREA (SSA) #8 Revenue Interest Income - 586 - 391 Property Taxes 60,200 31,702 53% 60,200 33,287 55% Revenue Total 60,200 32,288 54% 60,200 33,679 56% Expenses Services and Supplies 60,200 30,974 51% 60,200 - 0% Expenses Total 60,200 30,974 51% 60,200 - 0% 365 FIVE FIFTH TIF FUND Revenue Interest Income - 2,229 Property Taxes - 438,219 Revenue Total - 440,448 Expenses Capital Outlay - - - 177,091 Miscellaneous - - - 31,737 Services and Supplies 100,000 322,806 323% 100,000 6,465 6% Expenses Total 100,000 322,806 323% 100,000 215,293 215% FUNDS 2024 Budget 2024 Actual % of Budget 2023 Budget 2023 Actual % of Budget 415 CAPITAL IMPROVEMENTS FUND Revenue Charges for Services - 348 Interest Income - 45,590 - 80,184 Interfund Transfers 85,000 3,264,226 3840% Intergovernmental Revenue 1,470,000 522,679 36% 4,592,500 322,500 7% Other Revenue 23,283,500 65,721 0% 17,350,000 45,505 0% Revenue Total 24,753,500 634,338 3% 22,027,500 3,712,415 17% Expenses Capital Outlay 23,358,500 3,171,700 14% 22,492,500 1,010,987 4% Miscellaneous - (32,782) Services and Supplies 1,860,000 624,297 34% - 339,294 Expenses Total 25,218,500 3,795,997 15% 22,492,500 1,317,498 6% 416 CROWN CONSTRUCTION FUND Revenue Interest Income 10,000 121,752 1218% 10,000 94,471 945% Other Revenue 1,000,000 252,238 25% 1,000,000 - 0% Revenue Total 1,010,000 373,990 37% 1,010,000 94,471 9% Expenses Capital Outlay 200,000 - 0% 200,000 - 0% Interfund Transfers 619,118 257,965 42% 945,000 472,500 50% Miscellaneous - 13,321 Services and Supplies 60 25 42% - 25 Expenses Total 819,178 257,990 31% 1,145,000 485,846 42% 417 CROWN COMMUNITY CTR MAINTENANCE Revenue Interfund Transfers 175,000 72,915 42% 175,000 87,498 50% Revenue Total 175,000 72,915 42% 175,000 87,498 50% Expenses Capital Outlay 175,000 - 0% 175,000 - 0% Expenses Total 175,000 - 0% 175,000 - 0% FUNDS 2024 Budget 2024 Actual % of Budget 2023 Budget 2023 Actual % of Budget 420 SPECIAL ASSESSMENT FUND Revenue Interest Income 35,000 14,309 41% 30,000 27,775 93% Other Taxes 125,000 87,820 70% 125,000 92,039 74% Revenue Total 160,000 102,129 64% 155,000 119,815 77% Expenses Capital Outlay 452,500 - 0% 375,000 13,589 4% Interfund Transfers 425,652 38,335 9% 455,360 227,676 50% Services and Supplies 50 25 50% - 25 Expenses Total 878,202 38,360 4% 830,360 241,290 29% 505 PARKING SYSTEM FUND Revenue Charges for Services 8,420,000 3,919,460 47% 8,308,975 3,516,691 42% Interest Income 25,000 58,201 233% 20,000 34,429 172% Intergovernmental Revenue 1,100,000 - 0% 1,100,000 - 0% Other Revenue 422,900 147,392 35% 486,700 161,475 33% Revenue Total 9,967,900 4,125,052 41% 9,915,675 3,712,594 37% Expenses Capital Outlay - - 1,600,000 131,180 8% Debt Service 79,150 17,075 22% 76,150 - 0% Insurance and Other Chargebacks 369,077 153,780 42% 369,077 184,925 50% Interfund Transfers 3,180,390 1,325,160 42% 3,132,390 1,566,192 50% Miscellaneous 50,000 (2,954) -6% Salary and Benefits 1,582,397 649,385 41% 1,716,539 599,678 35% Services and Supplies 4,220,350 1,878,710 45% 4,340,316 1,678,146 39% Expenses Total 9,431,364 4,024,110 43% 11,284,472 4,157,167 37% FUNDS 2024 Budget 2024 Actual % of Budget 2023 Budget 2023 Actual % of Budget 510 WATER FUND Revenue Charges for Services 25,259,051 9,445,479 37% 24,378,734 9,009,383 37% Interest Income 70,000 92,271 132% 70,000 99,744 142% Licenses, Permits and Fees 50,000 32,606 65% 50,000 205 0% Other Revenue 66,234,150 699,267 1% 51,039,150 2,794,553 5% Revenue Total 91,613,201 10,269,623 11% 75,537,884 11,903,885 16% Expenses Capital Outlay 58,470,500 4,327,751 7% 388,400 - 0% Contingencies 1,000 - 0% 1,000 - 0% Debt Service 4,826,609 892,866 18% 4,072,486 135,695 3% Insurance and Other Chargebacks 1,665,135 701,126 42% 1,665,135 833,227 50% Interfund Transfers 4,363,000 1,817,920 42% 4,229,559 2,114,784 50% Miscellaneous 10,000 - 0% 15,000 (41,669) -278% Salary and Benefits 7,936,849 2,425,040 31% 7,110,142 2,418,766 34% Services and Supplies 10,284,310 2,062,477 20% 5,908,008 1,005,462 17% Expenses Total 87,557,403 12,227,179 14% 23,389,730 6,466,265 28% 513 WATER DEPR IMPRV &EXTENSION FUND Expenses Capital Outlay - 746,239 57,780,500 123,908 0% Services and Supplies - 1,572 11,700 226,681 1937% Expenses Total - 747,811 57,792,200 350,589 1% FUNDS 2024 Budget 2024 Actual % of Budget 2023 Budget 2023 Actual % of Budget 515 SEWER FUND Revenue Charges for Services 10,229,424 3,515,956 34% 10,240,424 3,524,034 34% Interest Income 25,000 48,944 196% 25,000 33,221 133% Other Revenue 1,000 768 77% 1,000 - 0% Revenue Total 10,255,424 3,565,667 35% 10,266,424 3,557,254 35% Expenses Capital Outlay 2,950,000 - 0% 3,050,700 228,771 7% Debt Service 3,550,270 1,632,714 46% 3,809,232 1,742,782 46% Insurance and Other Chargebacks 369,800 154,085 42% 369,800 184,902 50% Interfund Transfers 1,271,321 529,715 42% 883,858 441,930 50% Miscellaneous 1,500 (19,512) -1301% Salary and Benefits 1,546,276 466,993 30% 1,386,579 525,687 38% Services and Supplies 1,718,600 45,922 3% 1,750,300 (42,795) -2% Expenses Total 11,406,267 2,829,429 25% 11,251,969 3,061,766 27% 520 SOLID WASTE FUND Revenue Charges for Services 4,902,674 1,960,667 40% 4,669,000 1,824,828 39% Interest Income 3,000 5,076 169% - 2,705 Interfund Transfers 100,000 - 0% Licenses, Permits and Fees 375,000 170,775 46% 389,000 95,118 24% Other Revenue 38,000 4,828 13% 122,000 52,559 43% Property Taxes 1,332,500 666,250 50% 1,332,500 666,250 50% Revenue Total 6,751,174 2,807,597 42% 6,512,500 2,641,460 41% Expenses Capital Outlay 850,000 27,666 3% 525,000 20,682 4% Interfund Transfers 418,600 174,415 42% 322,000 160,998 50% Miscellaneous 30,000 8,616 29% 15,000 9,816 65% Salary and Benefits 1,893,717 653,165 34% 1,651,410 630,990 38% Services and Supplies 4,081,466 1,500,528 37% 3,935,115 1,300,222 33% Expenses Total 7,273,783 2,364,390 33% 6,448,525 2,122,708 33% FUNDS 2024 Budget 2024 Actual % of Budget 2023 Budget 2023 Actual % of Budget 600 FLEET SERVICES FUND Revenue Charges for Services 4,216,140 1,756,720 42% 3,244,440 1,622,214 50% Interest Income 1,000 288 29% 1,000 - 0% Other Revenue 44,000 57,798 131% 69,000 3,780 5% Revenue Total 4,261,140 1,814,807 43% 3,314,440 1,625,994 49% Expenses Capital Outlay - 780 - 2,145 Salary and Benefits 1,624,232 628,340 39% 1,417,422 583,116 41% Services and Supplies 2,588,890 668,284 26% 2,044,557 859,416 42% Expenses Total 4,213,122 1,297,405 31% 3,461,979 1,444,677 42% 601 EQUIPMENT REPLACEMENT FUND Revenue Charges for Services 754,885 314,535 42% 754,885 377,442 50% Interest Income 2,000 13,954 698% - 8,504 Intergovernmental Revenue 1,250,000 - 0% 1,500,000 - 0% Other Revenue 25,000 67,868 271% 25,000 77,859 311% Revenue Total 2,031,885 396,357 20% 2,279,885 463,805 20% Expenses Capital Outlay 3,365,167 938,677 28% 2,700,000 986,846 37% Services and Supplies - 575 - 93 Expenses Total 3,365,167 939,253 28% 2,700,000 986,939 37% 605 INSURANCE FUND Revenue Charges for Services - 1,342 - 129 Insurance 10,098,091 3,990,884 40% 9,444,453 4,286,171 45% Interest Income - 16,145 Other Revenue 12,859,571 4,233,979 33% 11,448,112 4,342,548 38% Workers Compensation and Liability 886,000 418,281 47% 862,500 749,830 87% Revenue Total 23,843,662 8,660,631 36% 21,755,065 9,378,678 43% Expenses Insurance and Other Chargebacks 19,330,965 7,182,087 37% 16,765,000 6,527,244 39% Salary and Benefits 3,805 2,409 63% 4,287 29,225 682% Services and Supplies 3,660,000 2,434,397 67% 3,244,200 1,655,548 51% Expenses Total 22,994,770 9,618,893 42% 20,013,487 8,212,017 41%