Loading...
HomeMy WebLinkAbout2021.09 September Monthly Report To: Kelley A. Gandurski, Interim City Manager From: Hitesh Desai, CFO/City Treasurer Subject: September 2021 Monthly Financial Report Date: November 3, 2021 Please find attached the unaudited financial statements as of September 30, 2021. A summary by fund for revenues, expenditures, fund and cash balances is as follows: Fund #Fund Name Revenue Expense Net Fund Balance Cash Balance 100 General 89,170,924 81,398,051 7,772,874 25,239,141 20,660,908 170 American Rescue Plan 21,606,726 3,950,000 17,656,726 17,656,726 17,656,726 175 General Assistance 988,022 820,105 167,916 557,451 557,324 176 Health and Human Services 3,634,803 1,694,729 1,940,073 2,910,137 2,909,947 177 Reparations 31,502 1,473 30,029 248,171 248,171 180 Good Neighbor 1,000,748 426,132 574,616 925,434 925,434 185 Library 6,181,636 5,782,411 399,225 3,294,064 3,306,327 186 Library Debt Service 482,243 124,950 357,293 358,438 358,438 187 Library Capital Improvement FD - 386,219 (386,219) 897,739 897,739 200 MFT 3,772,583 2,746,872 1,025,711 4,988,454 4,766,060 205 E911 960,533 717,325 243,208 1,632,838 1,276,114 210 Special Service Area (SSA) #9 504,468 299,214 205,254 (9,406) (9,406) 215 CDBG 797,168 946,903 (149,734) (88,911) (88,911) 220 CD Loan 100,070 - 100,070 282,895 282,895 235 Neighborhood Improvement 19 9 10 22,131 22,131 240 Home 341,003 347,010 (6,007) 23,558 23,558 250 Affordable Housing 398,994 1,654,139 (1,255,144) 2,546,638 2,679,530 320 Debt Service 15,490,308 7,019,888 8,470,420 9,191,878 9,191,878 330 Howard Ridge 745,286 317,880 427,406 2,763,449 2,745,890 335 West Evanston 1,548,239 439,576 1,108,663 2,903,293 2,903,293 340 Dempster-Dodge-TIF 139,633 127,158 12,475 224,738 224,738 345 Chicago Main-TIF 886,628 1,120,857 (234,229) 1,090,443 1,090,443 350 Special Service Area (SSA) #6 63,604 7,548 56,056 60,129 60,129 355 Special Service Area (SSA) #7 91,629 73,741 17,888 18,241 18,241 360 Special Service Area (SSA) #8 42,720 30,893 11,827 12,872 12,872 415 Capital Improvements 9,343,754 4,515,284 4,828,470 15,346,982 15,669,588 416 Crown Construction 3,209,220 1,613,301 1,595,919 4,226,803 5,515,060 417 Crown Community CTR Maintenance 131,247 - 131,247 306,247 306,247 420 Special Assessment 72,142 367,038 (294,896) 2,358,571 2,354,291 505 Parking 7,142,182 6,610,565 531,617 1,020,574 1,190,136 510 Water 23,340,729 20,502,081 2,838,648 13,748,195 15,813,455 515 Sewer 7,706,006 6,125,982 1,580,025 6,481,970 4,722,272 520 Solid Waste 4,745,446 4,294,821 450,626 300,300 (444,378) 600 Fleet 2,333,297 2,159,338 173,959 913,640 (435,711) 601 Equipment Replacement 329,105 1,038,522 (709,417) (185,873) (185,873) 605 Insurance 15,429,431 13,888,046 1,541,385 (6,922,304) (2,443,207) Grand Total 222,762,047 171,548,058 51,213,989 115,345,647 114,782,348 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 September 30, 2021. Cash balance represents liquid cash and/or invested assets which can be used (or easily sold) to support and fund current ooperations. 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. All fund balances are unaudited. Covid-19 Staff continues to monitor the impact of Covid-19 on the City’s finances for 2021. General Fund The unaudited financial statements show the General Fund as of September 30, 2021 with a fund balance of $25,239,141 and cash balance of $20,660,908. The attached financials show General Fund revenues at 80% of budget and expenses at 73% of budget against a target of 75%. The 2020 ending balance for the General Fund is 17,466,267. The Cook County second installment property tax bills for tax year 2020 went out during the last week of August with a due date of October 1. Expenses are slightly below target. January through September are typically slower months for program spending and overtime. The mild winter weather in the early part of the year helped keep costs low. Staff continues to monitor Police and Fire overtime expenses. Through September, Police had spent 60% of budget for overtime, and Fire had spent 117% over the annual budget. For Police, this is below target of 75%. Overtime is higher in Fire Department due to the onboarding/ training of new firefighters. Overtime will begin to decrease once recruits are fully trained. Fire overtime is also high because of Firefighter/Paramedics serving at vaccine clinics. This cost is expected to be covered by FEMA reimbursement. Overtime Expenses 2020 Actual 2021 Budget 2021 YTD % Budget Police $913,232 $ 1,484,322 $887,067 60% Fire $1,651,457 $ 959,956 $1,124,846 117% Enterprise Funds Parking fund revenues through September 30, 2021 are at 62% of budget and expenses are at 59%. The fund ended 2020 with a fund balance of $488,957. Through September 30, 2021 , the Water Fund appears low on revenue and expenses. This is because capital projects funded with IEPA loan/debt will take place later in the year. These projects are budgeted in Other Revenue and expenses in Capital Outlay. The 2020 ending fund balance is $10,909,547. The Water Fund revenues reflect payment from the Village of Skokie at the rate of $1.26 per 1000 gallons as agreed upon recently. Through September 30, 2021, the Sewer Fund also appears low on expenses mainly due to the capital projects and debt service payments occurring later in the year. The 2020 ending fund balance is $4,901,944. Through September 30, 2021, the Solid Waste Fund has a fund balance of $300,300 and a negative cash balance of $444,378. The fund ended 2020 with a fund balance of $(150,325). Other Funds Through September 30, 2021, the SSA #9 Fund is showing negative fund and cash balance of $9,406. Through September 30, 2021, the Capital Improvements Fund is showing a fund balance of $15,346,982 and a cash balance of $15,669,588. The fund continues to spend down Series 2021 and Series 2020 bond proceeds. Through September 30, 2021, the Crown Construction fund is showing fund balance of $4,226,803 and cash balance of $5,515,060. The fund continues to spend down balances from bond proceeds and gifts from the Friends of Robert Crown. Through September 30, 2021, the Insurance Fund is showing a negative fund balance of $6,922,304 and a negative cash balance of $2,443,207. Fund balance is significantly lower than cash balance due to accrued liabilities for pending litigations. 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 September 30, 2021 year-to-date financial information and reports which to the best of my knowledge appear accurate and complete. In this low interest rate environment, staff tries to take advantage of the opportunity for higher investment returns by moving money amongst the banks or investing in municipal securities. At the same time, we strive to be compliant with our investment policy of not having over 50% in one institution. Staff will continue to monitor the allocation of Cash and Investments. If you have any questions on this report or would like to discuss in greater detail, please contact me by phone at (847) 448.8082 or by e-mail at hdesai@cityofevanston.org. Fund #Fund Cash Investments Interfund Total 100 General 19,609,575 967,798 83,535 20,660,908 170 American Rescue Plan - 17,656,726 - 17,656,726 175 General Assistance 653,244 1 (95,921) 557,324 176 Health and Human Services 1,742,278 - 1,167,670 2,909,947 177 Reparations 244,038 - 4,132 248,171 180 Good Neighbor 925,786 - (352) 925,434 200 MFT - 5,027,236 (261,176) 4,766,060 205 E911 503,393 - 772,721 1,276,114 210 SSD4 - - (9,406) *(9,406) 215 CDBG 45,370 - (134,281) (88,911) 220 CD Loan 238,863 - 44,032 282,895 235 Neighborhood Improvement 22,128 - 3 22,131 240 Home 26,157 - (2,599) 23,558 250 Affordable Housing 214,957 1,973,128 491,445 2,679,530 320 Debt Service 7,749,372 1,144,190 298,316 9,191,878 330 Howard Ridge 774,940 2,013,044 (42,095) 2,745,890 335 West Evanston 2,920,748 - (17,455) 2,903,293 340 Dempster-Dodge-TIF 266,839 - (42,101) 224,738 345 Chicago Main-TIF 1,155,427 - (64,984) 1,090,443 350 Special Service Area (SSA) #6 60,128 - 1 60,129 355 Special Service Area (SSA) #7 18,235 - 5 18,241 360 Special Service Area (SSA) #8 12,872 - 1 12,872 415 Capital Improvements 11,411,692 1,503,656 2,754,240 15,669,588 416 Crown Construction 5,511,473 - 3,587 5,515,060 417 Crown Community CTR Maintenance 262,498 - 43,749 306,247 420 Special Assessment 171,016 2,053,855 129,419 2,354,291 505 Parking 6,298,569 1,305,492 (6,413,924) 1,190,136 510 Water 17,510,355 2,390,395 (4,087,295) 15,813,455 515 Sewer 3,466,730 1,335,253 (79,711) 4,722,272 520 Solid Waste - - (444,378) *(444,378) 600 Fleet - - (435,711) *(435,711) 601 Equipment Replacement - - (185,873) *(185,873) 605 Insurance - - (2,443,207) *(2,443,207) Total without Library 81,816,686 37,370,774 (8,967,616) 110,219,844 185 Library 2,706,881 2,027,594 (1,428,148) 3,306,327 186 Library Debt Service 76,195 - 282,243 358,438 187 Library Capital Improvement FD 897,739 - - 897,739 Library Total 3,680,814 2,027,594 (1,145,905) 4,562,504 Total 85,497,501 39,398,368 (10,113,521) 114,782,348 City of Evanston Cash & Investment Summary by Fund September 30, 2021 Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual .00 .00 (200.00)200.00 +++.00 500.00 .00 121.00 379.00 24 47.00 68,600,003.00 5,392,470.44 55,666,676.97 12,933,326.03 81 71,948,682.90 537,000.00 36,189.75 361,023.74 175,976.26 67 374,776.51 3,958,500.00 847,906.32 2,546,681.17 1,411,818.83 64 2,468,829.67 4,974,700.00 571,383.19 4,880,543.09 94,156.91 98 7,577,748.81 12,599,461.00 2,639,156.98 9,269,666.09 3,329,794.91 74 12,098,944.12 12,420,378.00 2,379,006.38 9,707,896.17 2,712,481.83 78 12,282,439.34 1,272,842.00 27,227.00 1,278,002.15 (5,160.15)100 888,088.69 .00 .00 5.00 (5.00)+++5.13 6,021,025.00 356,704.78 5,142,251.46 878,773.54 85 5,095,070.90 638,200.00 26,110.27 318,257.55 319,942.45 50 253,667.34 $111,022,609.00 $12,276,155.11 $89,170,924.39 $21,851,684.61 80%$112,988,300.41 .00 .00 795.00 (795.00)+++3,139.75 556,165.60 45,031.72 363,561.28 192,604.32 65 472,270.09 178,794.66 14,883.74 136,743.34 42,051.32 76 183,831.96 6,004,834.63 512,538.01 4,409,907.54 1,594,927.09 73 10,136,584.81 576,892.00 49,098.37 358,641.91 218,250.09 62 511,640.20 10,360,246.39 1,114,131.61 7,473,098.91 2,887,147.48 72 9,295,177.88 3,073,829.11 250,725.22 2,359,988.17 713,840.94 77 3,150,001.53 39,734,285.59 4,407,200.18 28,587,613.37 11,146,672.22 72 38,724,587.22 26,006,574.05 2,992,308.86 19,209,103.29 6,797,470.76 74 26,265,320.62 1,556,419.50 140,953.27 1,451,775.70 104,643.80 93 1,331,233.68 11,329,360.87 1,208,646.08 8,435,598.46 2,893,762.41 74 9,550,408.37 11,642,790.99 860,007.18 8,611,223.81 3,031,567.18 74 11,566,540.90 .00 .00 .00 .00 +++30.00 $111,020,193.39 $11,595,524.24 $81,398,050.78 $29,622,142.61 73%$111,190,767.01 111,022,609.00 12,276,155.11 89,170,924.39 21,851,684.61 80%112,988,300.41 111,020,193.39 11,595,524.24 81,398,050.78 29,622,142.61 73%111,190,767.01 $2,415.61 $680,630.87 $7,772,873.61 $7,770,458.00 321,777%$1,797,533.40 Fund 100 - GENERAL FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund 100 - GENERAL FUND Net Gain (Loss) PUBLIC WORKS AGENCY LIBRARY EXPENSE TOTALS FIRE MGMT & SUPPORT HEALTH PARKS AND RECREATION ADMINISTRATIVE SERVICES COMMUNITY DEVELOPMENT POLICE CITY CLERK CITY MANAGER'S OFFICE LAW EXPENSE LEGISLATIVE CITY COUNCIL PARKS AND RECREATION PUBLIC WORKS AGENCY REVENUE TOTALS FIRE MGMT & SUPPORT HEALTH PUBLIC WORKS ADMINISTRATIVE SERVICES COMMUNITY DEVELOPMENT POLICE CITY CLERK CITY MANAGER'S OFFICE LAW Fund Type GENERAL FUND Fund 100 - GENERAL FUND REVENUE LEGISLATIVE Income Statement Through 09/30/21 Summary Listing Organization Organization Description Fund Category Governmental Funds Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 3,110,000.00 1,580,000.00 3,110,000.00 .00 100 3,110,000.00 450,000.00 37,500.00 337,500.00 112,500.00 75 100,000.00 125,000.00 17,353.80 183,259.60 (58,259.60)147 50,548.97 2,000.00 .00 2,740.00 (740.00)137 95,950.00 .00 145.65 1,303.06 (1,303.06)+++800.72 $3,687,000.00 $1,634,999.45 $3,634,802.66 $52,197.34 99%$3,357,299.69 $3,687,000.00 $1,634,999.45 $3,634,802.66 $52,197.34 99%$3,357,299.69 736,373.00 .00 .00 736,373.00 0 .00 $736,373.00 $0.00 $0.00 $736,373.00 0%$0.00 1,697,148.21 103,806.19 1,146,987.92 550,160.29 68 1,217,849.18 603,870.00 3,587.29 325,350.96 278,519.04 54 338,286.16 .00 .00 8,861.29 (8,861.29)+++10,268.14 143,333.00 35,833.26 88,125.27 55,207.73 61 735,569.47 465,000.00 9,243.11 125,403.77 339,596.23 27 112,670.28 .00 .00 .00 .00 +++3,352.00 $2,909,351.21 $152,469.85 $1,694,729.21 $1,214,622.00 58%$2,417,995.23 $3,645,724.21 $152,469.85 $1,694,729.21 $1,950,995.00 46%$2,417,995.23 3,687,000.00 1,634,999.45 3,634,802.66 52,197.34 99%3,357,299.69 3,645,724.21 152,469.85 1,694,729.21 1,950,995.00 46%2,417,995.23 $41,275.79 $1,482,529.60 $1,940,073.45 $1,898,797.66 4,700%$939,304.46 Income Statement Through 09/30/21 Summary Listing Classification Fund Category Governmental Funds Fund Type GENERAL FUND Fund 176 - HUMAN SERVICES FUND REVENUE Department 24 - HEALTH Property Taxes Interfund Transfers Intergovernmental Revenue Other Revenue Interest Income Department 24 - HEALTH Totals REVENUE TOTALS EXPENSE Department 21 - COMMUNITY DEVELOPMENT Services and Supplies Department 21 - COMMUNITY DEVELOPMENT Totals Department 24 - HEALTH Salary and Benefits Services and Supplies Insurance and Other Chargebacks Community Sponsored Organizations Miscellaneous REVENUE TOTALS EXPENSE TOTALS Fund 176 - HUMAN SERVICES FUND Net Gain (Loss) Interfund Transfers Department 24 - HEALTH Totals EXPENSE TOTALS Fund 176 - HUMAN SERVICES FUND Totals Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual .00 .00 21,586,827.00 (21,586,827.00)+++.00 .00 3,458.89 19,898.91 (19,898.91)+++.00 $0.00 $3,458.89 $21,606,725.91 ($21,606,725.91)+++$0.00 $0.00 $3,458.89 $21,606,725.91 ($21,606,725.91)+++$0.00 .00 3,950,000.00 3,950,000.00 (3,950,000.00)+++.00 $0.00 $3,950,000.00 $3,950,000.00 ($3,950,000.00)+++$0.00 $0.00 $3,950,000.00 $3,950,000.00 ($3,950,000.00)+++$0.00 .00 3,458.89 21,606,725.91 (21,606,725.91)+++.00 .00 3,950,000.00 3,950,000.00 (3,950,000.00)+++.00 $0.00 ($3,946,541.11)$17,656,725.91 $17,656,725.91 +++$0.00 Income Statement Through 09/30/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Special Revenue Funds Fund 170 - AMERICAN RESCUE PLAN REVENUE Department 99 - NON-DEPARTMENTAL Intergovernmental Revenue Interest Income Department 99 - NON-DEPARTMENTAL Totals REVENUE TOTALS EXPENSE Department 99 - NON-DEPARTMENTAL Interfund Transfers EXPENSE TOTALS Fund 170 - AMERICAN RESCUE PLAN Net Gain (Loss) Department 99 - NON-DEPARTMENTAL Totals EXPENSE TOTALS Fund 170 - AMERICAN RESCUE PLAN Totals REVENUE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 1,300,000.00 383,823.86 984,370.40 315,629.60 76 1,100,904.14 27,500.00 .00 2,585.00 24,915.00 9 42,115.91 1,000.00 75.19 1,066.27 (66.27)107 3,131.62 $1,328,500.00 $383,899.05 $988,021.67 $340,478.33 74%$1,146,151.67 $1,328,500.00 $383,899.05 $988,021.67 $340,478.33 74%$1,146,151.67 452,062.40 33,016.26 357,509.25 94,553.15 79 406,614.05 865,982.00 51,326.95 458,182.51 407,799.49 53 708,132.08 7,000.00 .00 4,413.58 2,586.42 63 4,910.00 $1,325,044.40 $84,343.21 $820,105.34 $504,939.06 62%$1,119,656.13 $1,325,044.40 $84,343.21 $820,105.34 $504,939.06 62%$1,119,656.13 1,328,500.00 383,899.05 988,021.67 340,478.33 74%1,146,151.67 1,325,044.40 84,343.21 820,105.34 504,939.06 62%1,119,656.13 $3,455.60 $299,555.84 $167,916.33 $164,460.73 4,859%$26,495.54 Income Statement Through 09/30/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Special Revenue Funds Fund 175 - GENERAL ASSISTANCE FUND REVENUE Department 24 - HEALTH Property Taxes Other Revenue Interest Income Department 24 - HEALTH Totals REVENUE TOTALS EXPENSE Department 24 - HEALTH Salary and Benefits Services and Supplies Miscellaneous Department 24 - HEALTH Totals EXPENSE TOTALS Fund 175 - GENERAL ASSISTANCE FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund 175 - GENERAL ASSISTANCE FUND Net Gain (Loss) Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 400,000.00 .00 .00 400,000.00 0 .00 .00 .00 .00 .00 +++200,000.00 .00 5,050.00 31,230.29 (31,230.29)+++16,806.50 .00 42.07 271.48 (271.48)+++.00 $400,000.00 $5,092.07 $31,501.77 $368,498.23 8%$216,806.50 $400,000.00 $5,092.07 $31,501.77 $368,498.23 8%$216,806.50 .00 170.96 1,472.60 (1,472.60)+++.00 400,000.00 .00 .00 400,000.00 0 .00 $400,000.00 $170.96 $1,472.60 $398,527.40 0%$0.00 $400,000.00 $170.96 $1,472.60 $398,527.40 0%$0.00 400,000.00 5,092.07 31,501.77 368,498.23 8%216,806.50 400,000.00 170.96 1,472.60 398,527.40 0%.00 $0.00 $4,921.11 $30,029.17 $30,029.17 +++$216,806.50 Income Statement Through 09/30/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Special Revenue Funds Fund 177 - REPARATIONS FUND REVENUE Department 15 - CITY MANAGER'S OFFICE Other Taxes Interfund Transfers Other Revenue Interest Income Department 15 - CITY MANAGER'S OFFICE Totals REVENUE TOTALS EXPENSE Department 15 - CITY MANAGER'S OFFICE Services and Supplies Miscellaneous Department 15 - CITY MANAGER'S OFFICE Totals EXPENSE TOTALS Fund 177 - REPARATIONS FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund 177 - REPARATIONS FUND Net Gain (Loss) Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 1,000,000.00 .00 1,000,000.00 .00 100 1,000,000.00 .00 75.66 748.17 (748.17)+++1,805.35 $1,000,000.00 $75.66 $1,000,748.17 ($748.17)100%$1,001,805.35 $1,000,000.00 $75.66 $1,000,748.17 ($748.17)100%$1,001,805.35 .00 32.49 359.49 (359.49)+++497.43 620,000.00 508.09 11,620.59 608,379.41 2 33,034.90 380,000.00 .00 414,151.77 (34,151.77)109 870,000.04 $1,000,000.00 $540.58 $426,131.85 $573,868.15 43%$903,532.37 $1,000,000.00 $540.58 $426,131.85 $573,868.15 43%$903,532.37 1,000,000.00 75.66 1,000,748.17 (748.17)100%1,001,805.35 1,000,000.00 540.58 426,131.85 573,868.15 43%903,532.37 $0.00 ($464.92)$574,616.32 $574,616.32 +++$98,272.98 Income Statement Through 09/30/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Special Revenue Funds Fund 180 - GOOD NEIGHBOR FUND REVENUE Department 99 - NON-DEPARTMENTAL Other Revenue Interest Income Department 99 - NON-DEPARTMENTAL Totals REVENUE TOTALS EXPENSE Department 99 - NON-DEPARTMENTAL Services and Supplies Fund 180 - GOOD NEIGHBOR FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund 180 - GOOD NEIGHBOR FUND Net Gain (Loss) Miscellaneous Interfund Transfers Department 99 - NON-DEPARTMENTAL Totals EXPENSE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 7,252,000.00 1,488,881.99 5,451,370.72 1,800,629.28 75 7,268,891.26 .00 31.39 4,509.40 (4,509.40)+++22,320.17 .00 .00 171.83 (171.83)+++149.90 209,000.00 .00 250,000.00 (41,000.00)120 199,414.25 238,000.00 .00 232,547.34 5,452.66 98 285,045.65 400,000.00 1,475.91 177,594.62 222,405.38 44 427,372.39 227,224.00 4,241.41 57,201.76 170,022.24 25 71,720.03 15,000.00 563.03 8,240.48 6,759.52 55 26,949.16 $8,341,224.00 $1,495,193.73 $6,181,636.15 $2,159,587.85 74%$8,301,862.81 $8,341,224.00 $1,495,193.73 $6,181,636.15 $2,159,587.85 74%$8,301,862.81 5,910,018.36 432,716.07 4,163,884.20 1,746,134.16 70 5,405,967.44 2,052,000.00 240,773.31 1,346,154.40 705,845.60 66 1,714,948.94 8,500.00 1,463.52 1,463.52 7,036.48 17 775.00 .00 .00 .00 .00 +++600.00 361,226.00 30,101.00 270,909.00 90,317.00 75 354,375.00 $8,331,744.36 $705,053.90 $5,782,411.12 $2,549,333.24 69%$7,476,666.38 $8,331,744.36 $705,053.90 $5,782,411.12 $2,549,333.24 69%$7,476,666.38 8,341,224.00 1,495,193.73 6,181,636.15 2,159,587.85 74%8,301,862.81 8,331,744.36 705,053.90 5,782,411.12 2,549,333.24 69%7,476,666.38 $9,479.64 $790,139.83 $399,225.03 $389,745.39 4,211%$825,196.43 Income Statement Through 09/30/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Special Revenue Funds Fund 185 - LIBRARY FUND REVENUE Department 48 - LIBRARY Property Taxes Fines and Forfeitures Charges for Services Interfund Transfers Intergovernmental Revenue Other Revenue Library Revenue Interest Income Department 48 - LIBRARY Totals REVENUE TOTALS EXPENSE Department 48 - LIBRARY Salary and Benefits Services and Supplies Capital Outlay Miscellaneous Interfund Transfers EXPENSE TOTALS Fund 185 - LIBRARY FUND Net Gain (Loss) Department 48 - LIBRARY Totals EXPENSE TOTALS Fund 185 - LIBRARY FUND Totals REVENUE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 3,656,700.00 268,760.14 3,768,951.27 (112,251.27)103 4,346,950.35 12,000.00 266.86 3,631.73 8,368.27 30 18,013.10 $3,668,700.00 $269,027.00 $3,772,583.00 ($103,883.00)103%$4,364,963.45 $3,668,700.00 $269,027.00 $3,772,583.00 ($103,883.00)103%$4,364,963.45 .00 163,434.00 163,434.00 (163,434.00)+++25,472.95 .00 .00 .00 .00 +++1,044,987.00 $0.00 $163,434.00 $163,434.00 ($163,434.00)+++$1,070,459.95 1,038,000.00 56,106.20 617,205.22 420,794.78 59 684,583.03 2,284,000.00 800,812.67 1,182,494.61 1,101,505.39 52 1,316,209.69 1,044,987.00 87,082.00 783,738.00 261,249.00 75 .00 $4,366,987.00 $944,000.87 $2,583,437.83 $1,783,549.17 59%$2,000,792.72 $4,366,987.00 $1,107,434.87 $2,746,871.83 $1,620,115.17 63%$3,071,252.67 3,668,700.00 269,027.00 3,772,583.00 (103,883.00)103%4,364,963.45 4,366,987.00 1,107,434.87 2,746,871.83 1,620,115.17 63%3,071,252.67 ($698,287.00)($838,407.87)$1,025,711.17 $1,723,998.17 (147%)$1,293,710.78 Income Statement Through 09/30/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Special Revenue Funds Fund 200 - MOTOR FUEL TAX FUND REVENUE Department 40 - PUBLIC WORKS AGENCY Intergovernmental Revenue Interest Income Department 40 - PUBLIC WORKS AGENCY Totals REVENUE TOTALS EXPENSE Department 26 - PUBLIC WORKS Capital Outlay Interfund Transfers Department 26 - PUBLIC WORKS Totals Department 40 - PUBLIC WORKS AGENCY Services and Supplies Capital Outlay REVENUE TOTALS EXPENSE TOTALS Fund 200 - MOTOR FUEL TAX FUND Net Gain (Loss) Interfund Transfers Department 40 - PUBLIC WORKS AGENCY Totals EXPENSE TOTALS Fund 200 - MOTOR FUEL TAX FUND Totals Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 1,321,600.00 .00 959,625.69 361,974.31 73 1,460,634.96 .00 .00 .00 .00 +++240,821.00 .00 .00 266.17 (266.17)+++.00 7,000.00 49.50 641.41 6,358.59 9 5,531.23 $1,328,600.00 $49.50 $960,533.27 $368,066.73 72%$1,706,987.19 $1,328,600.00 $49.50 $960,533.27 $368,066.73 72%$1,706,987.19 742,978.48 42,199.75 407,845.90 335,132.58 55 561,536.22 374,000.00 102,376.28 220,512.72 153,487.28 59 241,438.39 299,163.00 .00 7,795.66 291,367.34 3 506,613.00 18,230.00 1,519.00 13,671.00 4,559.00 75 18,229.00 .00 .00 .00 .00 +++500.00 90,000.00 7,500.00 67,500.00 22,500.00 75 260,000.00 $1,524,371.48 $153,595.03 $717,325.28 $807,046.20 47%$1,588,316.61 $1,524,371.48 $153,595.03 $717,325.28 $807,046.20 47%$1,588,316.61 1,328,600.00 49.50 960,533.27 368,066.73 72%1,706,987.19 1,524,371.48 153,595.03 717,325.28 807,046.20 47%1,588,316.61 ($195,771.48)($153,545.53)$243,207.99 $438,979.47 (124%)$118,670.58 Income Statement Through 09/30/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Special Revenue Funds Fund 205 - EMERGENCY TELEPHONE (E911) FUND REVENUE Department 22 - POLICE Other Taxes Intergovernmental Revenue Other Revenue Interest Income Department 22 - POLICE Totals REVENUE TOTALS EXPENSE Department 22 - POLICE Salary and Benefits Services and Supplies Capital Outlay Insurance and Other Chargebacks Fund 205 - EMERGENCY TELEPHONE (E911) FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund 205 - EMERGENCY TELEPHONE (E911) FUND Net Gain (Loss) Miscellaneous Interfund Transfers Department 22 - POLICE Totals EXPENSE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 592,665.00 198,912.07 504,462.89 88,202.11 85 603,396.20 .00 .00 5.00 (5.00)+++87.15 $592,665.00 $198,912.07 $504,467.89 $88,197.11 85%$603,483.35 $592,665.00 $198,912.07 $504,467.89 $88,197.11 85%$603,483.35 575,000.00 .00 299,213.69 275,786.31 52 591,950.27 $575,000.00 $0.00 $299,213.69 $275,786.31 52%$591,950.27 $575,000.00 $0.00 $299,213.69 $275,786.31 52%$591,950.27 592,665.00 198,912.07 504,467.89 88,197.11 85%603,483.35 575,000.00 .00 299,213.69 275,786.31 52%591,950.27 $17,665.00 $198,912.07 $205,254.20 $187,589.20 1,162%$11,533.08 Income Statement Through 09/30/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Special Revenue Funds Fund 210 - SPECIAL SERVICE AREA (SSA) #9 REVENUE Department 21 - COMMUNITY DEVELOPMENT Property Taxes Interest Income Department 21 - COMMUNITY DEVELOPMENT Totals REVENUE TOTALS EXPENSE Department 21 - COMMUNITY DEVELOPMENT Services and Supplies EXPENSE TOTALS Fund 210 - SPECIAL SERVICE AREA (SSA) #9 Net Gain (Loss) Department 21 - COMMUNITY DEVELOPMENT Totals EXPENSE TOTALS Fund 210 - SPECIAL SERVICE AREA (SSA) #9 Totals REVENUE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 2,758,514.00 312,297.17 797,168.31 1,961,345.69 29 1,698,645.65 $2,758,514.00 $312,297.17 $797,168.31 $1,961,345.69 29%$1,698,645.65 $2,758,514.00 $312,297.17 $797,168.31 $1,961,345.69 29%$1,698,645.65 319,997.01 25,692.74 259,485.09 60,511.92 81 365,979.08 506,200.00 5.60 4,918.78 501,281.22 1 71,266.08 .00 2,500.00 127,730.49 (127,730.49)+++607,132.53 150,000.00 .00 138,008.55 11,991.45 92 292,237.53 80,000.00 16,548.06 385,028.16 (305,028.16)481 282,315.50 1,700,000.00 11,573.66 31,731.49 1,668,268.51 2 70,077.60 .00 .00 .00 .00 +++12,111.33 $2,756,197.01 $56,320.06 $946,902.56 $1,809,294.45 34%$1,701,119.65 $2,756,197.01 $56,320.06 $946,902.56 $1,809,294.45 34%$1,701,119.65 2,758,514.00 312,297.17 797,168.31 1,961,345.69 29%1,698,645.65 2,756,197.01 56,320.06 946,902.56 1,809,294.45 34%1,701,119.65 $2,316.99 $255,977.11 ($149,734.25)($152,051.24)(6,462%)($2,474.00) Income Statement Through 09/30/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Special Revenue Funds Fund 215 - CDBG FUND REVENUE Department 21 - COMMUNITY DEVELOPMENT Intergovernmental Revenue Department 21 - COMMUNITY DEVELOPMENT Totals REVENUE TOTALS EXPENSE Department 21 - COMMUNITY DEVELOPMENT Salary and Benefits Services and Supplies Capital Outlay Insurance and Other Chargebacks Community Sponsored Organizations Miscellaneous Interfund Transfers EXPENSE TOTALS Fund 215 - CDBG FUND Net Gain (Loss) Department 21 - COMMUNITY DEVELOPMENT Totals EXPENSE TOTALS Fund 215 - CDBG FUND Totals REVENUE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 110,000.00 13,645.20 99,455.92 10,544.08 90 74,015.96 .00 42.79 614.54 (614.54)+++2,387.91 $110,000.00 $13,687.99 $100,070.46 $9,929.54 91%$76,403.87 $110,000.00 $13,687.99 $100,070.46 $9,929.54 91%$76,403.87 175,000.00 .00 .00 175,000.00 0 120,955.83 .00 .00 .00 .00 +++8.50 $175,000.00 $0.00 $0.00 $175,000.00 0%$120,964.33 $175,000.00 $0.00 $0.00 $175,000.00 0%$120,964.33 110,000.00 13,687.99 100,070.46 9,929.54 91%76,403.87 175,000.00 .00 .00 175,000.00 0%120,964.33 ($65,000.00)$13,687.99 $100,070.46 $165,070.46 (154%)($44,560.46) Income Statement Through 09/30/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Special Revenue Funds Fund 220 - CDBG LOAN FUND REVENUE Department 21 - COMMUNITY DEVELOPMENT Other Revenue Interest Income Department 21 - COMMUNITY DEVELOPMENT Totals REVENUE TOTALS EXPENSE Department 21 - COMMUNITY DEVELOPMENT Services and Supplies REVENUE TOTALS EXPENSE TOTALS Fund 220 - CDBG LOAN FUND Net Gain (Loss) Miscellaneous Department 21 - COMMUNITY DEVELOPMENT Totals EXPENSE TOTALS Fund 220 - CDBG LOAN FUND Totals Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual .00 1.81 18.75 (18.75)+++334.15 $0.00 $1.81 $18.75 ($18.75)+++$334.15 $0.00 $1.81 $18.75 ($18.75)+++$334.15 .00 .78 8.63 (8.63)+++77.70 .00 .00 .00 .00 +++150,000.00 $0.00 $0.78 $8.63 ($8.63)+++$150,077.70 $0.00 $0.78 $8.63 ($8.63)+++$150,077.70 .00 1.81 18.75 (18.75)+++334.15 .00 .78 8.63 (8.63)+++150,077.70 $0.00 $1.03 $10.12 $10.12 +++($149,743.55) Income Statement Through 09/30/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Special Revenue Funds Fund 235 - NEIGHBORHOOD IMPROVEMENT REVENUE Department 21 - COMMUNITY DEVELOPMENT Interest Income Department 21 - COMMUNITY DEVELOPMENT Totals REVENUE TOTALS EXPENSE Department 21 - COMMUNITY DEVELOPMENT Services and Supplies Interfund Transfers EXPENSE TOTALS Fund 235 - NEIGHBORHOOD IMPROVEMENT Net Gain (Loss) Department 21 - COMMUNITY DEVELOPMENT Totals EXPENSE TOTALS Fund 235 - NEIGHBORHOOD IMPROVEMENT Totals REVENUE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual .00 .00 .00 .00 +++31,207.45 540,453.00 65,110.00 311,835.68 228,617.32 58 427,547.16 25,000.00 2,157.00 29,109.41 (4,109.41)116 12,333.55 150.00 9.72 57.50 92.50 38 114.73 $565,603.00 $67,276.72 $341,002.59 $224,600.41 60%$471,202.89 $565,603.00 $67,276.72 $341,002.59 $224,600.41 60%$471,202.89 63,875.72 5,794.05 49,728.76 14,146.96 78 12,520.85 500,565.00 65,115.24 297,610.38 202,954.62 59 411,196.39 .00 .00 (431.14)431.14 +++25,398.32 500.00 .00 101.50 398.50 20 47.85 $564,940.72 $70,909.29 $347,009.50 $217,931.22 61%$449,163.41 $564,940.72 $70,909.29 $347,009.50 $217,931.22 61%$449,163.41 565,603.00 67,276.72 341,002.59 224,600.41 60%471,202.89 564,940.72 70,909.29 347,009.50 217,931.22 61%449,163.41 $662.28 ($3,632.57)($6,006.91)($6,669.19)(907%)$22,039.48 Income Statement Through 09/30/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Special Revenue Funds Fund 240 - HOME FUND REVENUE Department 21 - COMMUNITY DEVELOPMENT Charges for Services Intergovernmental Revenue Other Revenue Interest Income Department 21 - COMMUNITY DEVELOPMENT Totals REVENUE TOTALS EXPENSE Department 21 - COMMUNITY DEVELOPMENT Salary and Benefits Services and Supplies Insurance and Other Chargebacks Miscellaneous EXPENSE TOTALS Fund 240 - HOME FUND Net Gain (Loss) Department 21 - COMMUNITY DEVELOPMENT Totals EXPENSE TOTALS Fund 240 - HOME FUND Totals REVENUE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 75,000.00 .00 15,453.00 59,547.00 21 76,650.00 658,000.00 44,168.73 280,852.88 377,147.12 43 255,299.89 175,600.00 416.67 96,666.69 78,933.31 55 655,416.71 5,700.00 382.50 6,021.73 (321.73)106 27,280.46 $914,300.00 $44,967.90 $398,994.30 $515,305.70 44%$1,014,647.06 $914,300.00 $44,967.90 $398,994.30 $515,305.70 44%$1,014,647.06 202,683.56 14,324.93 132,842.31 69,841.25 66 118,297.21 2,031,050.00 21,705.00 1,221,139.95 809,910.05 60 398,862.20 10,000.00 .00 4,200.00 5,800.00 42 2,800.00 17,000.00 .00 (27,308.62)44,308.62 (161)(34,214.97) 166,000.00 88,496.88 306,362.33 (140,362.33)185 246,094.03 102,510.00 778.50 16,902.66 85,607.34 16 406,628.08 $2,529,243.56 $125,305.31 $1,654,138.63 $875,104.93 65%$1,138,466.55 $2,529,243.56 $125,305.31 $1,654,138.63 $875,104.93 65%$1,138,466.55 914,300.00 44,967.90 398,994.30 515,305.70 44%1,014,647.06 2,529,243.56 125,305.31 1,654,138.63 875,104.93 65%1,138,466.55 ($1,614,943.56)($80,337.41)($1,255,144.33)$359,799.23 78%($123,819.49) Income Statement Through 09/30/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Special Revenue Funds Fund 250 - AFFORDABLE HOUSING FUND REVENUE Department 21 - COMMUNITY DEVELOPMENT Other Taxes Intergovernmental Revenue Other Revenue Interest Income Department 21 - COMMUNITY DEVELOPMENT Totals REVENUE TOTALS EXPENSE Department 21 - COMMUNITY DEVELOPMENT Salary and Benefits Services and Supplies Capital Outlay Insurance and Other Chargebacks Community Sponsored Organizations Miscellaneous Department 21 - COMMUNITY DEVELOPMENT Totals EXPENSE TOTALS Fund 250 - AFFORDABLE HOUSING FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund 250 - AFFORDABLE HOUSING FUND Net Gain (Loss) Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 482,243.00 282,243.00 482,243.00 .00 100 480,145.00 $482,243.00 $282,243.00 $482,243.00 $0.00 100%$480,145.00 $482,243.00 $282,243.00 $482,243.00 $0.00 100%$480,145.00 482,243.00 .00 124,950.26 357,292.74 26 438,095.05 $482,243.00 $0.00 $124,950.26 $357,292.74 26%$438,095.05 .00 .00 .00 .00 +++42,049.00 $0.00 $0.00 $0.00 $0.00 +++$42,049.00 $482,243.00 $0.00 $124,950.26 $357,292.74 26%$480,144.05 482,243.00 282,243.00 482,243.00 .00 100%480,145.00 482,243.00 .00 124,950.26 357,292.74 26%480,144.05 $0.00 $282,243.00 $357,292.74 $357,292.74 +++$0.95 Income Statement Through 09/30/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Debt Service Funds Fund 186 - LIBRARY DEBT SERVICE FUND REVENUE Department 48 - LIBRARY Property Taxes Department 48 - LIBRARY Totals REVENUE TOTALS EXPENSE Department 48 - LIBRARY Debt Service Department 48 - LIBRARY Totals Fund 186 - LIBRARY DEBT SERVICE FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund 186 - LIBRARY DEBT SERVICE FUND Net Gain (Loss) Department 99 - NON-DEPARTMENTAL Debt Service Department 99 - NON-DEPARTMENTAL Totals EXPENSE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 968,000.00 54,556.18 725,531.30 242,468.70 75 1,227,407.93 5,366.00 2,803.80 15,092.72 (9,726.72)281 20,631.95 400.00 480.34 4,661.57 (4,261.57)1,165 12,998.83 $973,766.00 $57,840.32 $745,285.59 $228,480.41 77%$1,261,038.71 $973,766.00 $57,840.32 $745,285.59 $228,480.41 77%$1,261,038.71 335,000.00 .41 154,295.66 180,704.34 46 352,868.87 500,000.00 .00 .00 500,000.00 0 382,140.14 .00 .00 .00 .00 +++731.37 218,113.00 18,176.00 163,584.00 54,529.00 75 314,020.09 $1,053,113.00 $18,176.41 $317,879.66 $735,233.34 30%$1,049,760.47 $1,053,113.00 $18,176.41 $317,879.66 $735,233.34 30%$1,049,760.47 973,766.00 57,840.32 745,285.59 228,480.41 77%1,261,038.71 1,053,113.00 18,176.41 317,879.66 735,233.34 30%1,049,760.47 ($79,347.00)$39,663.91 $427,405.93 $506,752.93 (539%)$211,278.24 Income Statement Through 09/30/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Debt Service Funds Fund 330 - HOWARD-RIDGE TIF FUND REVENUE Department 99 - NON-DEPARTMENTAL Property Taxes Other Revenue Interest Income Department 99 - NON-DEPARTMENTAL Totals REVENUE TOTALS EXPENSE Department 99 - NON-DEPARTMENTAL Services and Supplies Capital Outlay Miscellaneous Interfund Transfers Department 99 - NON-DEPARTMENTAL Totals Fund 330 - HOWARD-RIDGE TIF FUND Net Gain (Loss) EXPENSE TOTALS Fund 330 - HOWARD-RIDGE TIF FUND Totals REVENUE TOTALS EXPENSE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 1,237,000.00 502,868.57 1,372,812.34 (135,812.34)111 1,697,958.33 11,000.00 .00 171,504.26 (160,504.26)1,559 10,282.60 4,000.00 482.35 3,922.54 77.46 98 6,070.52 $1,252,000.00 $503,350.92 $1,548,239.14 ($296,239.14)124%$1,714,311.45 $1,252,000.00 $503,350.92 $1,548,239.14 ($296,239.14)124%$1,714,311.45 5,000.00 1.56 50,688.91 (45,688.91)1,014 787.35 500,000.00 332,637.00 332,637.00 167,363.00 67 111,700.00 200,000.00 .00 .00 200,000.00 0 382,670.00 75,000.00 6,250.00 56,250.00 18,750.00 75 135,000.00 $780,000.00 $338,888.56 $439,575.91 $340,424.09 56%$630,157.35 $780,000.00 $338,888.56 $439,575.91 $340,424.09 56%$630,157.35 1,252,000.00 503,350.92 1,548,239.14 (296,239.14)124%1,714,311.45 780,000.00 338,888.56 439,575.91 340,424.09 56%630,157.35 $472,000.00 $164,462.36 $1,108,663.23 $636,663.23 235%$1,084,154.10 Income Statement Through 09/30/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Debt Service Funds Fund 335 - WEST EVANSTON TIF FUND REVENUE Department 99 - NON-DEPARTMENTAL Property Taxes Other Revenue Interest Income Department 99 - NON-DEPARTMENTAL Totals REVENUE TOTALS EXPENSE Department 99 - NON-DEPARTMENTAL Services and Supplies Capital Outlay Miscellaneous Interfund Transfers Department 99 - NON-DEPARTMENTAL Totals Fund 335 - WEST EVANSTON TIF FUND Net Gain (Loss) EXPENSE TOTALS Fund 335 - WEST EVANSTON TIF FUND Totals REVENUE TOTALS EXPENSE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 147,000.00 45,586.93 139,255.50 7,744.50 95 170,306.49 .00 .00 .00 .00 +++100,000.00 .00 38.80 377.28 (377.28)+++795.89 $147,000.00 $45,625.73 $139,632.78 $7,367.22 95%$271,102.38 $147,000.00 $45,625.73 $139,632.78 $7,367.22 95%$271,102.38 2,000.00 .12 464.63 1,535.37 23 772.52 168,923.00 14,077.00 126,693.00 42,230.00 75 165,870.00 $170,923.00 $14,077.12 $127,157.63 $43,765.37 74%$166,642.52 $170,923.00 $14,077.12 $127,157.63 $43,765.37 74%$166,642.52 147,000.00 45,625.73 139,632.78 7,367.22 95%271,102.38 170,923.00 14,077.12 127,157.63 43,765.37 74%166,642.52 ($23,923.00)$31,548.61 $12,475.15 $36,398.15 (52%)$104,459.86 Income Statement Through 09/30/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Debt Service Funds Fund 340 - DEMPSTER-DODGE TIF FUND REVENUE Department 99 - NON-DEPARTMENTAL Property Taxes Interfund Transfers Interest Income Department 99 - NON-DEPARTMENTAL Totals REVENUE TOTALS EXPENSE Department 99 - NON-DEPARTMENTAL Fund 340 - DEMPSTER-DODGE TIF FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund 340 - DEMPSTER-DODGE TIF FUND Net Gain (Loss) Services and Supplies Interfund Transfers Department 99 - NON-DEPARTMENTAL Totals EXPENSE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 879,000.00 424,208.37 884,386.76 (5,386.76)101 1,145,554.72 1,130,000.00 .00 .00 1,130,000.00 0 .00 .00 170.00 2,241.45 (2,241.45)+++5,057.19 $2,009,000.00 $424,378.37 $886,628.21 $1,122,371.79 44%$1,150,611.91 $2,009,000.00 $424,378.37 $886,628.21 $1,122,371.79 44%$1,150,611.91 5,000.00 .55 475.98 4,524.02 10 785.07 1,130,000.00 238,171.93 923,245.09 206,754.91 82 251,298.71 262,843.00 21,904.00 197,136.00 65,707.00 75 260,610.00 $1,397,843.00 $260,076.48 $1,120,857.07 $276,985.93 80%$512,693.78 $1,397,843.00 $260,076.48 $1,120,857.07 $276,985.93 80%$512,693.78 2,009,000.00 424,378.37 886,628.21 1,122,371.79 44%1,150,611.91 1,397,843.00 260,076.48 1,120,857.07 276,985.93 80%512,693.78 $611,157.00 $164,301.89 ($234,228.86)($845,385.86)(38%)$637,918.13 Income Statement Through 09/30/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Debt Service Funds Fund 345 - CHICAGO-MAIN TIF REVENUE Department 99 - NON-DEPARTMENTAL Property Taxes Other Revenue Interest Income Department 99 - NON-DEPARTMENTAL Totals REVENUE TOTALS EXPENSE Department 99 - NON-DEPARTMENTAL Services and Supplies Capital Outlay Interfund Transfers Department 99 - NON-DEPARTMENTAL Totals EXPENSE TOTALS Fund 345 - CHICAGO-MAIN TIF Totals REVENUE TOTALS EXPENSE TOTALS Fund 345 - CHICAGO-MAIN TIF Net Gain (Loss) Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 221,000.00 58,332.76 63,596.91 157,403.09 29 224,827.08 500.00 .32 7.28 492.72 1 315.81 $221,500.00 $58,333.08 $63,604.19 $157,895.81 29%$225,142.89 $221,500.00 $58,333.08 $63,604.19 $157,895.81 29%$225,142.89 221,500.00 .00 7,548.47 213,951.53 3 226,411.95 $221,500.00 $0.00 $7,548.47 $213,951.53 3%$226,411.95 $221,500.00 $0.00 $7,548.47 $213,951.53 3%$226,411.95 221,500.00 58,333.08 63,604.19 157,895.81 29%225,142.89 221,500.00 .00 7,548.47 213,951.53 3%226,411.95 $0.00 $58,333.08 $56,055.72 $56,055.72 +++($1,269.06) Income Statement Through 09/30/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Debt Service Funds Fund 350 - SPECIAL SERVICE AREA (SSA) #6 REVENUE Department 99 - NON-DEPARTMENTAL Property Taxes Interest Income Department 99 - NON-DEPARTMENTAL Totals REVENUE TOTALS EXPENSE Department 99 - NON-DEPARTMENTAL Services and Supplies EXPENSE TOTALS Fund 350 - SPECIAL SERVICE AREA (SSA) #6 Net Gain (Loss) Department 99 - NON-DEPARTMENTAL Totals EXPENSE TOTALS Fund 350 - SPECIAL SERVICE AREA (SSA) #6 Totals REVENUE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 154,800.00 14,753.32 91,553.40 63,246.60 59 141,256.43 .00 .61 75.18 (75.18)+++91.37 $154,800.00 $14,753.93 $91,628.58 $63,171.42 59%$141,347.80 $154,800.00 $14,753.93 $91,628.58 $63,171.42 59%$141,347.80 115,000.00 .00 73,740.97 41,259.03 64 140,994.91 $115,000.00 $0.00 $73,740.97 $41,259.03 64%$140,994.91 $115,000.00 $0.00 $73,740.97 $41,259.03 64%$140,994.91 154,800.00 14,753.93 91,628.58 63,171.42 59%141,347.80 115,000.00 .00 73,740.97 41,259.03 64%140,994.91 $39,800.00 $14,753.93 $17,887.61 ($21,912.39)45%$352.89 Income Statement Through 09/30/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Debt Service Funds Fund 355 - SPECIAL SERVICE AREA (SSA) #7 REVENUE Department 99 - NON-DEPARTMENTAL Property Taxes Interest Income Department 99 - NON-DEPARTMENTAL Totals REVENUE TOTALS EXPENSE Department 99 - NON-DEPARTMENTAL Services and Supplies EXPENSE TOTALS Fund 355 - SPECIAL SERVICE AREA (SSA) #7 Net Gain (Loss) Department 99 - NON-DEPARTMENTAL Totals EXPENSE TOTALS Fund 355 - SPECIAL SERVICE AREA (SSA) #7 Totals REVENUE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 60,200.00 .00 31,524.70 28,675.30 52 59,743.95 .00 11,193.93 11,194.95 (11,194.95)+++24.15 $60,200.00 $11,193.93 $42,719.65 $17,480.35 71%$59,768.10 $60,200.00 $11,193.93 $42,719.65 $17,480.35 71%$59,768.10 60,200.00 .00 30,893.10 29,306.90 51 58,722.29 $60,200.00 $0.00 $30,893.10 $29,306.90 51%$58,722.29 $60,200.00 $0.00 $30,893.10 $29,306.90 51%$58,722.29 60,200.00 11,193.93 42,719.65 17,480.35 71%59,768.10 60,200.00 .00 30,893.10 29,306.90 51%58,722.29 $0.00 $11,193.93 $11,826.55 $11,826.55 +++$1,045.81 Income Statement Through 09/30/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Debt Service Funds Fund 360 - SPECIAL SERVICE AREA (SSA) #8 REVENUE Department 99 - NON-DEPARTMENTAL Property Taxes Interest Income Department 99 - NON-DEPARTMENTAL Totals REVENUE TOTALS EXPENSE Department 99 - NON-DEPARTMENTAL Services and Supplies Department 99 - NON-DEPARTMENTAL Totals EXPENSE TOTALS Fund 360 - SPECIAL SERVICE AREA (SSA) #8 Totals REVENUE TOTALS EXPENSE TOTALS Fund 360 - SPECIAL SERVICE AREA (SSA) #8 Net Gain (Loss) Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 449,000.00 .00 .00 449,000.00 0 .00 $449,000.00 $0.00 $0.00 $449,000.00 0%$0.00 $449,000.00 $0.00 $0.00 $449,000.00 0%$0.00 449,000.00 .00 386,219.11 62,780.89 86 94,525.25 $449,000.00 $0.00 $386,219.11 $62,780.89 86%$94,525.25 $449,000.00 $0.00 $386,219.11 $62,780.89 86%$94,525.25 449,000.00 .00 .00 449,000.00 0%.00 449,000.00 .00 386,219.11 62,780.89 86%94,525.25 $0.00 $0.00 ($386,219.11)($386,219.11)+++($94,525.25) Income Statement Through 09/30/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Capital Project Funds Fund 187 - LIBRARY CAPITAL IMPROVEMENT FD REVENUE Department 48 - LIBRARY Other Revenue Department 48 - LIBRARY Totals REVENUE TOTALS EXPENSE Department 48 - LIBRARY Capital Outlay Department 48 - LIBRARY Totals Fund 187 - LIBRARY CAPITAL IMPROVEMENT FD Net Gain (Loss) EXPENSE TOTALS Fund 187 - LIBRARY CAPITAL IMPROVEMENT FD Totals REVENUE TOTALS EXPENSE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 13,936,263.00 3,518,511.74 10,574,599.27 3,361,663.73 76 12,814,108.59 1,197,401.00 99,785.00 898,065.00 299,336.00 75 3,319,053.04 .00 4,010,810.46 4,010,403.50 (4,010,403.50)+++12,054,284.90 1,500.00 838.91 7,239.89 (5,739.89)483 24,864.03 $15,135,164.00 $7,629,946.11 $15,490,307.66 ($355,143.66)102%$28,212,310.56 $15,135,164.00 $7,629,946.11 $15,490,307.66 ($355,143.66)102%$28,212,310.56 .00 49,187.95 49,207.93 (49,207.93)+++133,807.04 15,133,666.00 4,035,468.75 6,970,680.53 8,162,985.47 46 27,774,476.37 $15,133,666.00 $4,084,656.70 $7,019,888.46 $8,113,777.54 46%$27,908,283.41 $15,133,666.00 $4,084,656.70 $7,019,888.46 $8,113,777.54 46%$27,908,283.41 15,135,164.00 7,629,946.11 15,490,307.66 (355,143.66)102%28,212,310.56 15,133,666.00 4,084,656.70 7,019,888.46 8,113,777.54 46%27,908,283.41 $1,498.00 $3,545,289.41 $8,470,419.20 $8,468,921.20 565,449%$304,027.15 Fund 320 - DEBT SERVICE FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund 320 - DEBT SERVICE FUND Net Gain (Loss) Department 99 - NON-DEPARTMENTAL Services and Supplies Debt Service Department 99 - NON-DEPARTMENTAL Totals EXPENSE TOTALS Other Revenue Interest Income Department 99 - NON-DEPARTMENTAL Totals REVENUE TOTALS EXPENSE Fund 320 - DEBT SERVICE FUND REVENUE Department 99 - NON-DEPARTMENTAL Property Taxes Interfund Transfers Income Statement Through 09/30/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Capital Project Funds Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual .00 16,477.68 105,362.31 (105,362.31)+++.00 .00 .00 .00 .00 +++470,000.04 .00 .00 331,168.38 (331,168.38)+++.00 7,645,000.00 8,638,451.85 8,969,069.48 (1,324,069.48)117 6,833,019.50 .00 1,027.45 8,920.16 (8,920.16)+++24,813.33 $7,645,000.00 $8,655,956.98 $9,414,520.33 ($1,769,520.33)123%$7,327,832.87 .00 (70,081.00)(71,658.88)71,658.88 +++18,170.77 .00 2.55 892.68 (892.68)+++61,116.40 $0.00 ($70,078.45)($70,766.20)$70,766.20 +++$79,287.17 $7,645,000.00 $8,585,878.53 $9,343,754.13 ($1,698,754.13)122%$7,407,120.04 696,766.01 40,174.74 503,265.27 193,500.74 72 676,147.47 .00 381,621.24 1,209,698.65 (1,209,698.65)+++1,564,539.87 9,705,000.00 870,360.04 2,802,319.35 6,902,680.65 29 7,018,081.23 $10,401,766.01 $1,292,156.02 $4,515,283.27 $5,886,482.74 43%$9,258,768.57 .00 .00 .00 .00 +++85.00 .00 .00 .00 .00 +++290,000.00 $0.00 $0.00 $0.00 $0.00 +++$290,085.00 $10,401,766.01 $1,292,156.02 $4,515,283.27 $5,886,482.74 43%$9,548,853.57 7,645,000.00 8,585,878.53 9,343,754.13 (1,698,754.13)122%7,407,120.04 10,401,766.01 1,292,156.02 4,515,283.27 5,886,482.74 43%9,548,853.57 ($2,756,766.01)$7,293,722.51 $4,828,470.86 $7,585,236.87 (175%)($2,141,733.53) Fund 415 - CAPITAL IMPROVEMENTS FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund 415 - CAPITAL IMPROVEMENTS FUND Net Gain (Loss) Department 99 - NON-DEPARTMENTAL Services and Supplies Interfund Transfers Department 99 - NON-DEPARTMENTAL Totals EXPENSE TOTALS Department 40 - PUBLIC WORKS AGENCY Salary and Benefits Services and Supplies Capital Outlay Department 40 - PUBLIC WORKS AGENCY Totals Other Revenue Interest Income Department 99 - NON-DEPARTMENTAL Totals REVENUE TOTALS EXPENSE Intergovernmental Revenue Other Revenue Interest Income Department 40 - PUBLIC WORKS AGENCY Totals Department 99 - NON-DEPARTMENTAL Fund 415 - CAPITAL IMPROVEMENTS FUND REVENUE Department 40 - PUBLIC WORKS AGENCY Charges for Services Interfund Transfers Income Statement Through 09/30/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Capital Project Funds Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual .00 .00 .00 .00 +++2,000,000.00 .00 .00 1,000,000.00 (1,000,000.00)+++.00 1,000,000.00 .00 2,200,000.00 (1,200,000.00)220 2,037,500.00 .00 1,193.82 9,219.53 (9,219.53)+++90,687.56 $1,000,000.00 $1,193.82 $3,209,219.53 ($2,209,219.53)321%$4,128,187.56 $1,000,000.00 $1,193.82 $3,209,219.53 ($2,209,219.53)321%$4,128,187.56 .00 5.00 6,314.13 (6,314.13)+++333,461.83 1,000,000.00 1,436,459.07 1,606,986.39 (606,986.39)161 8,172,492.39 637,500.00 .00 .00 637,500.00 0 637,500.00 $1,637,500.00 $1,436,464.07 $1,613,300.52 $24,199.48 99%$9,143,454.22 $1,637,500.00 $1,436,464.07 $1,613,300.52 $24,199.48 99%$9,143,454.22 1,000,000.00 1,193.82 3,209,219.53 (2,209,219.53)321%4,128,187.56 1,637,500.00 1,436,464.07 1,613,300.52 24,199.48 99%9,143,454.22 ($637,500.00)($1,435,270.25)$1,595,919.01 $2,233,419.01 (250%)($5,015,266.66) Income Statement Through 09/30/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Capital Project Funds Fund 416 - CROWN CONSTRUCTION FUND REVENUE Department 40 - PUBLIC WORKS AGENCY Interfund Transfers Intergovernmental Revenue Other Revenue Interest Income Department 40 - PUBLIC WORKS AGENCY Totals REVENUE TOTALS EXPENSE Department 40 - PUBLIC WORKS AGENCY Services and Supplies Capital Outlay Interfund Transfers Department 40 - PUBLIC WORKS AGENCY Totals Fund 416 - CROWN CONSTRUCTION FUND Net Gain (Loss) EXPENSE TOTALS Fund 416 - CROWN CONSTRUCTION FUND Totals REVENUE TOTALS EXPENSE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 175,000.00 14,583.00 131,247.00 43,753.00 75 175,000.00 $175,000.00 $14,583.00 $131,247.00 $43,753.00 75%$175,000.00 $175,000.00 $14,583.00 $131,247.00 $43,753.00 75%$175,000.00 175,000.00 14,583.00 131,247.00 43,753.00 75%175,000.00 .00 .00 .00 .00 +++.00 $175,000.00 $14,583.00 $131,247.00 ($43,753.00)75%$175,000.00 Income Statement Through 09/30/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Capital Project Funds Fund 417 - CROWN COMMUNITY CTR MAINTENANCE REVENUE Department 40 - PUBLIC WORKS AGENCY Interfund Transfers Department 40 - PUBLIC WORKS AGENCY Totals Fund 417 - CROWN COMMUNITY CTR MAINTENANCE Net Gain (Loss) REVENUE TOTALS Fund 417 - CROWN COMMUNITY CTR MAINTENANCE Totals REVENUE TOTALS EXPENSE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 125,000.00 .00 61,249.68 63,750.32 49 168,414.88 .00 (1,109.75)(1,109.75)1,109.75 +++.00 30,000.00 402.04 12,002.43 17,997.57 40 35,236.30 $155,000.00 ($707.71)$72,142.36 $82,857.64 47%$203,651.18 $155,000.00 ($707.71)$72,142.36 $82,857.64 47%$203,651.18 .00 5.00 45.00 (45.00)+++60.00 .00 .00 .00 .00 +++.00 .00 .00 .00 .00 +++477,930.00 $0.00 $5.00 $45.00 ($45.00)+++$477,990.00 500,000.00 .00 .00 500,000.00 0 .00 489,314.00 40,777.00 366,993.00 122,321.00 75 .00 $989,314.00 $40,777.00 $366,993.00 $622,321.00 37%$0.00 $989,314.00 $40,782.00 $367,038.00 $622,276.00 37%$477,990.00 155,000.00 (707.71)72,142.36 82,857.64 47%203,651.18 989,314.00 40,782.00 367,038.00 622,276.00 37%477,990.00 ($834,314.00)($41,489.71)($294,895.64)$539,418.36 35%($274,338.82) Income Statement Through 09/30/21 Summary Listing Classification Fund Category Governmental Funds Fund Type Capital Project Funds Fund 420 - SPECIAL ASSESSMENT FUND REVENUE Department 26 - PUBLIC WORKS Other Taxes Other Revenue Interest Income Department 26 - PUBLIC WORKS Totals REVENUE TOTALS EXPENSE Department 26 - PUBLIC WORKS Services and Supplies Capital Outlay Interfund Transfers Department 26 - PUBLIC WORKS Totals Department 40 - PUBLIC WORKS AGENCY Capital Outlay Interfund Transfers Department 40 - PUBLIC WORKS AGENCY Totals EXPENSE TOTALS Fund 420 - SPECIAL ASSESSMENT FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund 420 - SPECIAL ASSESSMENT FUND Net Gain (Loss) Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual .00 225.00 375.00 (375.00)+++75.00 10,133,725.00 717,654.90 5,887,491.36 4,246,233.64 58 6,937,516.53 .00 .00 .00 .00 +++140,907.09 .00 950,000.00 950,000.00 (950,000.00)+++.00 1,404,700.00 35,201.92 289,186.85 1,115,513.15 21 348,622.73 20,000.00 648.48 15,128.44 4,871.56 76 53,583.60 $11,558,425.00 $1,703,730.30 $7,142,181.65 $4,416,243.35 62%$7,480,704.95 .00 .00 .00 .00 +++2,831.29 $0.00 $0.00 $0.00 $0.00 +++$2,831.29 $11,558,425.00 $1,703,730.30 $7,142,181.65 $4,416,243.35 62%$7,483,536.24 255,033.38 17,104.38 166,428.60 88,604.78 65 270,658.21 $255,033.38 $17,104.38 $166,428.60 $88,604.78 65%$270,658.21 693,477.26 35,043.55 524,486.04 168,991.22 76 764,801.44 4,484,316.00 392,466.67 2,763,920.32 1,720,395.68 62 3,970,535.24 1,750,000.00 22,365.25 141,673.57 1,608,326.43 8 8,004.00 351,502.00 29,292.00 263,628.00 87,874.00 75 350,666.04 .00 .00 .00 .00 +++2,899,592.72 47,164.00 .00 28,215.00 18,949.00 60 11,644.07 50,000.00 .00 .00 50,000.00 0 .00 3,132,390.00 261,032.00 2,349,288.00 783,102.00 75 4,631,907.00 $10,508,849.26 $740,199.47 $6,071,210.93 $4,437,638.33 58%$12,637,150.51 487,451.58 40,838.52 372,925.36 114,526.22 77 523,157.26 .00 .00 .00 .00 +++23,335.04 $487,451.58 $40,838.52 $372,925.36 $114,526.22 77%$546,492.30 $11,251,334.22 $798,142.37 $6,610,564.89 $4,640,769.33 59%$13,454,301.02 11,558,425.00 1,703,730.30 7,142,181.65 4,416,243.35 62%7,483,536.24 11,251,334.22 798,142.37 6,610,564.89 4,640,769.33 59%13,454,301.02 $307,090.78 $905,587.93 $531,616.76 $224,525.98 173%($5,970,764.78) Income Statement Through 09/30/21 Summary Listing Classification Fund Category Proprietary Funds Fund Type Enterprise Funds Fund 505 - PARKING SYSTEM FUND REVENUE Department 19 - ADMINISTRATIVE SERVICES Licenses, Permits and Fees Charges for Services Interfund Transfers Intergovernmental Revenue Other Revenue Interest Income Department 19 - ADMINISTRATIVE SERVICES Totals Department 40 - PUBLIC WORKS AGENCY Other Revenue Department 40 - PUBLIC WORKS AGENCY Totals REVENUE TOTALS EXPENSE Department 15 - CITY MANAGER'S OFFICE Salary and Benefits Department 15 - CITY MANAGER'S OFFICE Totals Department 19 - ADMINISTRATIVE SERVICES Salary and Benefits Services and Supplies Capital Outlay Insurance and Other Chargebacks Depreciation Expense Debt Service Miscellaneous Interfund Transfers Department 19 - ADMINISTRATIVE SERVICES Totals Department 40 - PUBLIC WORKS AGENCY Salary and Benefits REVENUE TOTALS EXPENSE TOTALS Fund 505 - PARKING SYSTEM FUND Net Gain (Loss) Services and Supplies Department 40 - PUBLIC WORKS AGENCY Totals EXPENSE TOTALS Fund 505 - PARKING SYSTEM FUND Totals Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 50,000.00 (371.00)47,453.90 2,546.10 95 61,116.67 23,006,700.00 2,055,966.12 15,358,881.37 7,647,818.63 67 23,591,431.45 .00 3,000,000.00 3,000,000.00 (3,000,000.00)+++.00 19,629,150.00 1,705,334.74 2,127,522.24 17,501,627.76 11 298,660.82 70,000.00 1,631.25 34,645.39 35,354.61 49 71,542.67 $42,755,850.00 $6,762,561.11 $20,568,502.90 $22,187,347.10 48%$24,022,751.61 .00 2,772,225.94 2,772,225.94 (2,772,225.94)+++143,910.27 $0.00 $2,772,225.94 $2,772,225.94 ($2,772,225.94)+++$143,910.27 $42,755,850.00 $9,534,787.05 $23,340,728.84 $19,415,121.16 55%$24,166,661.88 5,927,918.46 359,569.98 4,182,652.27 1,745,266.19 71 5,618,144.35 4,793,710.00 329,056.93 2,122,482.34 2,671,227.66 44 3,212,472.18 24,200.00 .00 .00 24,200.00 0 .00 .00 3,612.96 14,967.96 (14,967.96)+++.00 .00 .00 .00 .00 +++2,865,860.20 1,000.00 .00 .00 1,000.00 0 .00 15,000.00 .00 8,580.19 6,419.81 57 300.00 180,000.00 15,000.00 135,000.00 45,000.00 75 11,418,966.32 $10,941,828.46 $707,239.87 $6,463,682.76 $4,478,145.70 59%$23,115,743.05 .00 .00 .00 .00 +++(120,875.19) .00 34,179.81 34,179.81 (34,179.81)+++.00 1,539,653.00 128,304.00 1,154,736.00 384,917.00 75 1,513,955.00 2,318,294.00 2,822,596.88 4,068,216.50 (1,749,922.50)175 1,089,040.81 4,049,559.00 337,464.00 3,037,176.00 1,012,383.00 75 3,799,559.00 $7,907,506.00 $3,322,544.69 $8,294,308.31 ($386,802.31)105%$6,281,679.62 $18,849,334.46 $4,029,784.56 $14,757,991.07 $4,091,343.39 78%$29,397,422.67 42,755,850.00 9,534,787.05 23,340,728.84 19,415,121.16 55%24,166,661.88 18,849,334.46 4,029,784.56 14,757,991.07 4,091,343.39 78%29,397,422.67 $23,906,515.54 $5,505,002.49 $8,582,737.77 ($15,323,777.77)36%($5,230,760.79) Income Statement Through 09/30/21 Summary Listing Classification Fund Category Proprietary Funds Fund Type Enterprise Funds Fund 510 - WATER FUND REVENUE Department 40 - PUBLIC WORKS AGENCY Licenses, Permits and Fees Charges for Services Intergovernmental Revenue Other Revenue Interest Income Department 40 - PUBLIC WORKS AGENCY Totals Department 71 - UTILITIES Other Revenue Department 71 - UTILITIES Totals REVENUE TOTALS EXPENSE Department 40 - PUBLIC WORKS AGENCY Salary and Benefits Services and Supplies Capital Outlay Insurance and Other Chargebacks Depreciation Expense Contingencies Miscellaneous Interfund Transfers Department 40 - PUBLIC WORKS AGENCY Totals Department 71 - UTILITIES Salary and Benefits Services and Supplies Insurance and Other Chargebacks Debt Service Interfund Transfers EXPENSE TOTALS Fund 510 - WATER FUND Net Gain (Loss) Department 71 - UTILITIES Totals EXPENSE TOTALS Fund 510 - WATER FUND Totals REVENUE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 1,500,000.00 13,303.00 186,852.60 1,313,147.40 12 1,060.49 24,068,000.00 1,261,955.73 5,557,237.02 18,510,762.98 23 420,882.76 .00 .00 .00 .00 +++(11,246,385.32) $25,568,000.00 $1,275,258.73 $5,744,089.62 $19,823,910.38 22%($10,824,442.07) $25,568,000.00 $1,275,258.73 $5,744,089.62 $19,823,910.38 22%($10,824,442.07) .00 .00 .00 .00 +++.00 25,568,000.00 1,275,258.73 5,744,089.62 19,823,910.38 22%(10,824,442.07) ($25,568,000.00)($1,275,258.73)($5,744,089.62)$19,823,910.38 22%$10,824,442.07 Income Statement Through 09/30/21 Summary Listing Classification Fund Category Proprietary Funds Fund Type Enterprise Funds Fund 513 - WATER DEPR IMPRV &EXTENSION FUND EXPENSE Department 71 - UTILITIES Services and Supplies Capital Outlay REVENUE TOTALS EXPENSE TOTALS Fund 513 - WATER DEPR IMPRV &EXTENSION FUND Net Gain (Loss) Interfund Transfers Department 71 - UTILITIES Totals EXPENSE TOTALS Fund 513 - WATER DEPR IMPRV &EXTENSION FUND Totals Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 10,375,408.00 1,258,088.57 7,705,324.06 2,670,083.94 74 10,242,065.74 2,001,000.00 (1,407.42)(2,443.75)2,003,443.75 (0)385,501.29 25,000.00 489.15 3,126.14 21,873.86 13 15,110.87 $12,401,408.00 $1,257,170.30 $7,706,006.45 $4,695,401.55 62%$10,642,677.90 .00 .00 .00 .00 +++47,866.81 $0.00 $0.00 $0.00 $0.00 +++$47,866.81 $12,401,408.00 $1,257,170.30 $7,706,006.45 $4,695,401.55 62%$10,690,544.71 1,425,265.69 92,249.50 965,631.21 459,634.48 68 1,332,414.71 1,484,650.00 257,937.59 677,793.77 806,856.23 46 394,477.24 3,343,000.00 .00 117,444.02 3,225,555.98 4 .00 332,255.00 27,688.00 249,192.00 83,063.00 75 306,557.04 .00 .00 .00 .00 +++3,773,558.96 1,500.00 .00 500.00 1,000.00 33 1,456.21 855,375.00 71,282.00 641,538.00 213,837.00 75 1,337,532.00 $7,442,045.69 $449,157.09 $2,652,099.00 $4,789,946.69 36%$7,145,996.16 .00 .00 .00 .00 +++60,949.08 5,195,191.00 311,978.99 3,473,882.76 1,721,308.24 67 726,343.24 $5,195,191.00 $311,978.99 $3,473,882.76 $1,721,308.24 67%$787,292.32 $12,637,236.69 $761,136.08 $6,125,981.76 $6,511,254.93 48%$7,933,288.48 12,401,408.00 1,257,170.30 7,706,006.45 4,695,401.55 62%10,690,544.71 12,637,236.69 761,136.08 6,125,981.76 6,511,254.93 48%7,933,288.48 ($235,828.69)$496,034.22 $1,580,024.69 $1,815,853.38 (670%)$2,757,256.23 Income Statement Through 09/30/21 Summary Listing Classification Fund Category Proprietary Funds Fund Type Enterprise Funds Fund 515 - SEWER FUND REVENUE Department 40 - PUBLIC WORKS AGENCY Charges for Services Other Revenue Interest Income Department 40 - PUBLIC WORKS AGENCY Totals Department 71 - UTILITIES Other Revenue Department 71 - UTILITIES Totals REVENUE TOTALS EXPENSE Department 40 - PUBLIC WORKS AGENCY Salary and Benefits Services and Supplies Capital Outlay Insurance and Other Chargebacks Depreciation Expense Miscellaneous Interfund Transfers Department 40 - PUBLIC WORKS AGENCY Totals Department 71 - UTILITIES Salary and Benefits Debt Service Department 71 - UTILITIES Totals Fund 515 - SEWER FUND Net Gain (Loss) EXPENSE TOTALS Fund 515 - SEWER FUND Totals REVENUE TOTALS EXPENSE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual .00 278.00 1,821.00 (1,821.00)+++2,184.00 $0.00 $278.00 $1,821.00 ($1,821.00)+++$2,184.00 1,332,500.00 682,500.00 1,332,500.00 .00 100 1,332,500.00 297,000.00 61,232.27 211,997.42 85,002.58 71 298,870.04 4,516,450.00 387,229.06 3,097,498.92 1,418,951.08 69 4,245,578.25 122,000.00 592.00 101,628.88 20,371.12 83 71,739.00 $6,267,950.00 $1,131,553.33 $4,743,625.22 $1,524,324.78 76%$5,948,687.29 $6,267,950.00 $1,131,831.33 $4,745,446.22 $1,522,503.78 76%$5,950,871.29 1,405,702.00 97,849.82 1,039,461.59 366,240.41 74 1,333,777.77 3,778,926.00 544,504.86 2,605,346.15 1,173,579.85 69 3,519,042.76 505,000.00 117,894.07 415,975.47 89,024.53 82 104,512.20 .00 .00 .00 .00 +++41,124.85 10,000.00 125.00 7,534.40 2,465.60 75 8,143.41 302,000.00 25,167.00 226,503.00 75,497.00 75 322,362.00 $6,001,628.00 $785,540.75 $4,294,820.61 $1,706,807.39 72%$5,328,962.99 .00 .00 .00 .00 +++(13,022.26) $0.00 $0.00 $0.00 $0.00 +++($13,022.26) $6,001,628.00 $785,540.75 $4,294,820.61 $1,706,807.39 72%$5,315,940.73 6,267,950.00 1,131,831.33 4,745,446.22 1,522,503.78 76%5,950,871.29 6,001,628.00 785,540.75 4,294,820.61 1,706,807.39 72%5,315,940.73 $266,322.00 $346,290.58 $450,625.61 $184,303.61 169%$634,930.56 Income Statement Through 09/30/21 Summary Listing Classification Fund Category Proprietary Funds Fund Type Enterprise Funds Fund 520 - SOLID WASTE FUND REVENUE Department 26 - PUBLIC WORKS Charges for Services Department 26 - PUBLIC WORKS Totals Department 40 - PUBLIC WORKS AGENCY Property Taxes Licenses, Permits and Fees Charges for Services Other Revenue Department 40 - PUBLIC WORKS AGENCY Totals REVENUE TOTALS EXPENSE Department 40 - PUBLIC WORKS AGENCY Salary and Benefits Services and Supplies Capital Outlay Depreciation Expense Miscellaneous Interfund Transfers Department 40 - PUBLIC WORKS AGENCY Totals Department 71 - UTILITIES Salary and Benefits Department 71 - UTILITIES Totals EXPENSE TOTALS Fund 520 - SOLID WASTE FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund 520 - SOLID WASTE FUND Net Gain (Loss) Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 3,127,440.00 258,953.00 2,330,577.00 796,863.00 75 3,070,014.00 69,000.00 .00 2,719.84 66,280.16 4 14,453.78 1,000.00 .00 .00 1,000.00 0 .00 $3,197,440.00 $258,953.00 $2,333,296.84 $864,143.16 73%$3,084,467.78 $3,197,440.00 $258,953.00 $2,333,296.84 $864,143.16 73%$3,084,467.78 1,148,166.41 79,135.03 817,818.90 330,347.51 71 1,134,913.86 2,034,507.00 258,506.46 1,303,672.65 730,834.35 64 1,316,444.13 .00 203.50 20,127.72 (20,127.72)+++3.92 .00 128.88 17,718.34 (17,718.34)+++7,999.49 .00 .00 .00 .00 +++900.00 $3,182,673.41 $337,973.87 $2,159,337.61 $1,023,335.80 68%$2,460,261.40 $3,182,673.41 $337,973.87 $2,159,337.61 $1,023,335.80 68%$2,460,261.40 3,197,440.00 258,953.00 2,333,296.84 864,143.16 73%3,084,467.78 3,182,673.41 337,973.87 2,159,337.61 1,023,335.80 68%2,460,261.40 $14,766.59 ($79,020.87)$173,959.23 $159,192.64 1,178%$624,206.38 Income Statement Through 09/30/21 Summary Listing Classification Fund Category Proprietary Funds Fund Type Internal Service Funds Fund 600 - FLEET SERVICES FUND REVENUE Department 19 - ADMINISTRATIVE SERVICES Charges for Services Other Revenue Interest Income Department 19 - ADMINISTRATIVE SERVICES Totals REVENUE TOTALS EXPENSE Department 19 - ADMINISTRATIVE SERVICES Salary and Benefits Services and Supplies Capital Outlay Insurance and Other Chargebacks Miscellaneous EXPENSE TOTALS Fund 600 - FLEET SERVICES FUND Net Gain (Loss) Department 19 - ADMINISTRATIVE SERVICES Totals EXPENSE TOTALS Fund 600 - FLEET SERVICES FUND Totals REVENUE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 224,885.00 18,739.00 168,651.00 56,234.00 75 1,479,425.00 1,060,217.00 13,201.00 160,294.00 899,923.00 15 158,320.03 .00 .00 159.62 (159.62)+++432.99 $1,285,102.00 $31,940.00 $329,104.62 $955,997.38 26%$1,638,178.02 $1,285,102.00 $31,940.00 $329,104.62 $955,997.38 26%$1,638,178.02 .00 .00 69.90 (69.90)+++35,725.99 1,600,000.00 61,356.00 1,038,452.02 561,547.98 65 648,105.00 $1,600,000.00 $61,356.00 $1,038,521.92 $561,478.08 65%$683,830.99 .00 .00 .00 .00 +++1,532,788.60 $0.00 $0.00 $0.00 $0.00 +++$1,532,788.60 $1,600,000.00 $61,356.00 $1,038,521.92 $561,478.08 65%$2,216,619.59 1,285,102.00 31,940.00 329,104.62 955,997.38 26%1,638,178.02 1,600,000.00 61,356.00 1,038,521.92 561,478.08 65%2,216,619.59 ($314,898.00)($29,416.00)($709,417.30)($394,519.30)225%($578,441.57) Income Statement Through 09/30/21 Summary Listing Classification Fund Category Proprietary Funds Fund Type Internal Service Funds Fund 601 - EQUIPMENT REPLACEMENT FUND REVENUE Department 19 - ADMINISTRATIVE SERVICES Charges for Services Other Revenue Interest Income Department 19 - ADMINISTRATIVE SERVICES Totals REVENUE TOTALS EXPENSE Department 19 - ADMINISTRATIVE SERVICES Services and Supplies Capital Outlay Department 19 - ADMINISTRATIVE SERVICES Totals Department 26 - PUBLIC WORKS Depreciation Expense EXPENSE TOTALS Fund 601 - EQUIPMENT REPLACEMENT FUND Net Gain (Loss) Department 26 - PUBLIC WORKS Totals EXPENSE TOTALS Fund 601 - EQUIPMENT REPLACEMENT FUND Totals REVENUE TOTALS Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual .00 6,340.19 7,170.63 (7,170.63)+++247,262.46 .00 .00 .00 .00 +++2,000,000.00 10,402,039.00 835,538.66 7,551,003.69 2,851,035.31 73 9,707,994.97 1,475,000.00 122,581.43 1,101,070.83 373,929.17 75 2,876,171.13 8,890,677.00 716,536.65 6,770,185.91 2,120,491.09 76 6,492,580.46 $20,767,716.00 $1,680,996.93 $15,429,431.06 $5,338,284.94 74%$21,324,009.02 $20,767,716.00 $1,680,996.93 $15,429,431.06 $5,338,284.94 74%$21,324,009.02 662,619.98 37,684.54 446,692.60 215,927.38 67 618,397.39 2,914,200.00 93,121.28 1,518,269.63 1,395,930.37 52 3,465,872.47 16,641,267.00 1,371,327.80 11,923,083.76 4,718,183.24 72 14,110,030.08 .00 .00 .00 .00 +++300.00 $20,218,086.98 $1,502,133.62 $13,888,045.99 $6,330,040.99 69%$18,194,599.94 $20,218,086.98 $1,502,133.62 $13,888,045.99 $6,330,040.99 69%$18,194,599.94 20,767,716.00 1,680,996.93 15,429,431.06 5,338,284.94 74%21,324,009.02 20,218,086.98 1,502,133.62 13,888,045.99 6,330,040.99 69%18,194,599.94 $549,629.02 $178,863.31 $1,541,385.07 $991,756.05 280%$3,129,409.08 Income Statement Through 09/30/21 Summary Listing Classification Fund Category Proprietary Funds Fund Type Internal Service Funds Fund 605 - INSURANCE FUND REVENUE Department 99 - NON-DEPARTMENTAL Charges for Services Interfund Transfers Other Revenue Workers Compensation and Liability Insurance Department 99 - NON-DEPARTMENTAL Totals REVENUE TOTALS EXPENSE Department 99 - NON-DEPARTMENTAL Salary and Benefits Services and Supplies Insurance and Other Chargebacks Miscellaneous Department 99 - NON-DEPARTMENTAL Totals EXPENSE TOTALS Fund 605 - INSURANCE FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund 605 - INSURANCE FUND Net Gain (Loss) Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 11,815,000.00 (1,291,751.72)12,430,738.86 (615,738.86)105 19,601,260.66 2,500,000.00 347,982.14 1,628,136.89 871,863.11 65 2,174,018.22 $14,315,000.00 ($943,769.58)$14,058,875.75 $256,124.25 98%$21,775,278.88 $14,315,000.00 ($943,769.58)$14,058,875.75 $256,124.25 98%$21,775,278.88 10,805,300.00 905,145.71 8,024,809.75 2,780,490.25 74 10,399,738.82 225,000.00 3,042.54 147,318.16 77,681.84 65 148,468.04 $11,030,300.00 $908,188.25 $8,172,127.91 $2,858,172.09 74%$10,548,206.86 $11,030,300.00 $908,188.25 $8,172,127.91 $2,858,172.09 74%$10,548,206.86 14,315,000.00 (943,769.58)14,058,875.75 256,124.25 98%21,775,278.88 11,030,300.00 908,188.25 8,172,127.91 2,858,172.09 74%10,548,206.86 $3,284,700.00 ($1,851,957.83)$5,886,747.84 $2,602,047.84 179%$11,227,072.02 Income Statement Through 09/30/21 Summary Listing Classification Fund Category Fiduciary Funds Fund Type Pension Trust Funds Fund 700 - FIRE PENSION FUND REVENUE Department 23 - FIRE MGMT & SUPPORT Other Revenue Interest Income Department 23 - FIRE MGMT & SUPPORT Totals REVENUE TOTALS EXPENSE Department 23 - FIRE MGMT & SUPPORT Salary and Benefits REVENUE TOTALS EXPENSE TOTALS Fund 700 - FIRE PENSION FUND Net Gain (Loss) Miscellaneous Department 23 - FIRE MGMT & SUPPORT Totals EXPENSE TOTALS Fund 700 - FIRE PENSION FUND Totals Annual MTD YTD Budget Less % of Prior Year Budget Amount Actual Amount Actual Amount YTD Actual Budget Total Actual 18,214,700.00 (3,668,287.92)22,115,258.57 (3,900,558.57)121 28,106,377.21 1,500,000.00 406,061.65 2,522,753.69 (1,022,753.69)168 2,579,448.58 $19,714,700.00 ($3,262,226.27)$24,638,012.26 ($4,923,312.26)125%$30,685,825.79 $19,714,700.00 ($3,262,226.27)$24,638,012.26 ($4,923,312.26)125%$30,685,825.79 14,326,000.00 1,471,431.53 11,353,164.62 2,972,835.38 79 13,459,230.47 375,000.00 .00 265,551.95 109,448.05 71 399,999.29 $14,701,000.00 $1,471,431.53 $11,618,716.57 $3,082,283.43 79%$13,859,229.76 $14,701,000.00 $1,471,431.53 $11,618,716.57 $3,082,283.43 79%$13,859,229.76 19,714,700.00 (3,262,226.27)24,638,012.26 (4,923,312.26)125%30,685,825.79 14,701,000.00 1,471,431.53 11,618,716.57 3,082,283.43 79%13,859,229.76 $5,013,700.00 ($4,733,657.80)$13,019,295.69 $8,005,595.69 260%$16,826,596.03 Income Statement Through 09/30/21 Summary Listing Classification Fund Category Fiduciary Funds Fund Type Pension Trust Funds Fund 705 - POLICE PENSION FUND REVENUE Department 22 - POLICE Other Revenue Interest Income Department 22 - POLICE Totals REVENUE TOTALS EXPENSE Department 22 - POLICE Salary and Benefits Miscellaneous Department 22 - POLICE Totals EXPENSE TOTALS Fund 705 - POLICE PENSION FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund 705 - POLICE PENSION FUND Net Gain (Loss)