Loading...
HomeMy WebLinkAbout2021.06 June Monthly Report To: Erika Storlie, City Manager From: Hitesh Desai, CFO/City Treasurer Tasheik Kerr, Management Analyst Subject: June 2021 Monthly Financial Report Date: July 30, 2021 Please find attached the unaudited financial statements as of June 30, 2021. A summary by fund for revenues, expenditures, fund and cash balances is as follows: June 2021 Revenue Expense Net Fund Balance Cash Balance 100 GENERAL FUND 61,447,649 55,334,977 6,112,672 23,578,939 19,837,840 170 AMERICAN RESCUE PLAN 21,595,089 - 21,595,089 21,595,089 21,595,089 175 GENERAL ASSISTANCE FUND 603,347 554,271 49,076 438,611 438,483 176 HEALTH AND HUMAN SERVICES 1,826,540 966,873 859,667 1,829,730 1,829,541 177 REPARATIONS FUND 25,151 25 25,126 243,267 243,267 180 GOOD NEIGHBOR FUND 1,000,502 425,533 574,969 925,786 925,786 185 LIBRARY FUND 4,515,731 3,912,558 603,173 3,498,013 3,510,276 186 LIBRARY DEBT SERVICE FUND 200,000 124,950 75,050 76,195 76,195 187 LIBRARY CAPITAL IMPROVEMENT FD - 374,928 (374,928) 909,030 909,030 200 MOTOR FUEL TAX FUND 3,005,075 966,452 2,038,623 6,001,366 5,778,972 205 EMERGENCY TELEPHONE (E911) FUND 723,442 448,687 274,755 1,664,385 1,307,661 210 SPECIAL SERVICE AREA (SSA) #4 298,859 299,214 (355) (215,015) (215,015) 215 CDBG FUND 132,451 638,841 (506,390) (445,567) (445,567) 220 CDBG LOAN FUND 56,038 - 56,038 238,863 238,863 235 NEIGHBORHOOD IMPROVEMENT 14 7 7 22,128 22,128 240 HOME FUND 185,239 248,622 (63,383) (33,818) (7,781) 250 AFFORDABLE HOUSING FUND 246,250 958,134 (711,884) 3,089,898 3,230,516 320 DEBT SERVICE FUND 7,651,746 2,935,227 4,716,519 5,437,977 5,461,000 330 HOWARD-RIDGE TIF FUND 678,059 253,469 424,591 2,760,634 2,743,764 335 WEST EVANSTON TIF FUND 1,043,839 37,936 1,005,903 2,800,533 2,800,533 340 DEMPSTER-DODGE TIF FUND 93,916 84,795 9,121 221,384 221,384 345 CHICAGO-MAIN TIF 461,690 248,333 213,357 1,538,028 1,538,028 350 SPECIAL SERVICE AREA (SSA) #6 5,270 7,548 (2,278) 1,795 1,795 355 SPECIAL SERVICE AREA (SSA) #7 76,870 73,741 3,129 3,482 3,482 360 SPECIAL SERVICE AREA (SSA) #8 31,525 30,893 632 1,678 1,678 415 CAPITAL IMPROVEMENTS FUND 361,326 2,595,532 (2,234,206) 8,284,306 8,674,674 416 CROWN CONSTRUCTION FUND 3,205,618 73,204 3,132,414 5,763,298 7,051,555 417 CROWN COMMUNITY CTR MAINTENANCE 87,498 - 87,498 262,498 262,498 420 SPECIAL ASSESSMENT FUND 57,555 244,692 (187,137) 2,466,330 2,463,147 505 PARKING SYSTEM FUND 3,254,775 4,494,429 (1,239,654) (750,694) (489,661) 510 WATER FUND 9,908,367 11,330,842 (1,422,476) 9,487,072 11,363,696 515 SEWER FUND 4,544,491 4,374,807 169,684 5,071,630 3,688,814 520 SOLID WASTE FUND 2,893,287 2,699,154 194,133 43,808 (635,169) 600 FLEET SERVICES FUND 1,556,438 1,373,631 182,806 922,487 (426,748) 601 EQUIPMENT REPLACEMENT FUND 191,884 977,166 (785,282) (261,738) (261,738) 605 INSURANCE FUND 10,262,509 9,385,055 877,454 (7,586,235) (3,106,468) Grand Total 142,228,042 106,474,528 35,753,514 99,885,174 100,631,549 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 June 30, 2021. 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. 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 June 30, 2021 with a fund balance of $23,578,939 and cash balance of $19,837,840. The attached financials show General Fund revenues at 55.27% of budget and expenses at 49.84% of budget against a target of 50%. The 2020 ending balance for the General Fund is 17,466,267. As of June 30, 2021, 57.39% of property tax revenue to the General Fund has been received. It is expected that the Cook County second installment property tax bills for tax year 2020 will be mailed during the last week of July. Expenses are slightly below target. January through June 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 June, Police had spent 36% of budget for overtime, and Fire had spent 89% of budget. For Police, this is below target of 50%. Overtime is higher in Fire Department due to the onboarding/ training of new firefighters. Overtime will begin to decrease once recuits are fully trained. Fire overtime is also high in July due to 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 Enterprise Funds Parking fund revenues through June 30, 2021 are at 28.16% of budget and expenses are at 39.95%. The fund ended 2020 with a fund balance of $488,957. Through June 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 expe nses 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 June 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 revenues are low because of bond proceeds (budgeted as Other Financing Sources) expected in late summer. The 2020 ending fund balance is $4,901,944. Through June 30, 2021, the Solid Waste Fund has a fund balance of $43,808 and a negative cash balance of $635,169. The fund ended 2020 with a fund balance of $(150,325). Other Funds Through June 30, 2021, the SSA #4 Fund is showing negative fund balance of $215,015 and a negative cash balance of $215,015. Through June 30, 2021, the Capital Improvements Fund is showing a fund balance of $8,284,306 and a cash balance of $8,674,674. The fund continues to spend down Series 2019B and Series 2020 bond proceeds. Through June 30, 2021, the Crown Construction fund is showing fund balance of $5,763,298 and cash balance of $7,051,555. The fund continues to spend down balances from bond proceeds and gifts from the Friends of Robert Crown . Through June 30, 2021, the Insurance Fund is showing a negative fund balance of $7,586,235 and a negative cash balance of $3,106,468. 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 May31, 2021 year-to-date financial information and reports which to the best of my knowledge appear accurate and complete. Pension Property Tax $10,807,181 State Income Tax $5,667,598 Property Taxes $5,431,974 Sales Tax - Basic $5,131,851 Recreation Program Fees $3,734,815 Sales Tax - Home Rule $3,647,451 Building Permits $3,308,490 Real Estate Transfer Tax $2,296,379 State Use Tax $1,440,624 Electric Utility Tax $1,385,439 Major Funds Revenue Dashboard Summary For the Period Ending June 30, 2021 Top 10 GENERAL FUND Sources of Revenue (YTD) $0.0 $20.0 $40.0 $60.0 $80.0 $100.0 $120.0 100 GENERAL FUND 513 WATER DEPR IMPRV &EXTENSION FUND 515 SEWER FUND 605 INSURANCE FUND 700 FIRE PENSION FUND Mi l l i o n s Revenues by Fund Budget Current YTD $0.0 $2.0 $4.0 $6.0 $8.0 $10.0 $12.0 $14.0 $16.0 $18.0 Mi l l i o n s General Fund Revenue by Source Prior YTD Current YTD Police $13,296,741 Fire Mgmt & Support $7,794,596 Administrative Services $4,818,951 Public Works Agency $4,812,844 Parks And Recreation $4,273,435 City Manager'S Office $2,223,899 Community Development $1,610,026 Health $864,127 City Council $242,922 Law $230,891 Major Funds Expenditure Dashboard Summary For the Period Ending June 30, 2021 Top 10 GENERAL FUND Expenditures by Department (YTD) $0.0 $5.0 $10.0 $15.0 $20.0 $25.0 $30.0 $35.0 SALARIES BENEFITS SUPPLIES SERVICES CAPITAL OUTLAY DEBT SERVICE OTHER TRANSFERS Mi l l i o n s General Fund Expenditures by Object Prior YTD Current YTD $0.0 $20.0 $40.0 $60.0 $80.0 $100.0 $120.0 100 GENERAL FUND 513 WATER DEPR IMPRV &EXTENSION FUND 515 SEWER FUND 605 INSURANCE FUND 700 FIRE PENSION FUND Mi l l i o n s Expenditures by Fund Budget Current YTD Prior YTD FY2016 Actual YTD FY2016 FYTD Current Budget 2017 Prior YTD Prior Year Actual YTD % of PY Actual Current YTD Annual Budget YTD % of Budget REVENUES Property Taxes $13,949,944 $29,359,627 47.51%$16,239,155 $28,298,539 57.39% Sales & Use Taxes 8,545,934 19,215,616 44.47%10,219,927 19,200,000 53.23% Business & Occupation Taxes 11,733,836 22,031,358 53.26%13,092,405 22,955,000 57.04% Other Taxes 2,262,721 7,411,753 30.53%3,675,311 7,105,000 51.73% --0 65,094 0.00%48,280 0 Intergovernmental 702,317 3,516,270 19.97%1,829,081 1,584,942 115.40% Charges for Services 4,010,537 7,527,170 53.28%4,959,229 9,357,875 53.00% Licenses & Permits 4,382,543 9,169,414 47.80%4,745,605 7,600,550 62.44% Fines and Forefeitures 878,317 2,990,415 29.37%1,337,884 4,123,500 32.45% Interest earnings 54,273 68,280 79.49%16,661 55,000 30.29% Miscellaneous Revenue 122,583 234,834 52.20%84,716 122,100 69.38% Other Financing Sources 656,122 1,116,601 58.76%320,786 1,471,000 21.81% Transfers In 4,779,552 9,269,103 51.56%4,798,706 9,149,103 TOTAL REVENUE $52,078,678 $111,975,537 46.51%$61,367,746 $111,022,609 55.27% EXPENDITURES Salaries $28,181,864 $55,417,401 50.85%$29,443,030 $58,394,928 50.42% Benefits 6,578,903 12,344,532 53.29%6,576,274 12,518,165 52.53% Supplies 1,288,573 3,214,808 40.08%821,104 2,608,964 31.47% Services 2,998,500 7,694,142 38.97%2,777,654 8,231,769 33.74% Capital Outlay 47,965 235,983 20.33%47,394 320,000 14.81% Debt Service 0 0 310,068 0 Other 204,942 573,596 35.73%279,271 593,125 47.08% Transfers 15,502,304 30,231,098 51.28%15,080,181 28,353,239 53.19% TOTAL EXPENDITURES $54,803,051 $109,711,559 49.95%$55,334,977 $111,020,191 49.84% SURPLUS / (DEFICIT)($2,724,373)$2,263,978 $6,032,769 $2,418 ENDING FUND BALANCE $12,477,917 $23,499,036 GENERAL FUND | Financial Summary For the Period Ending June 30, 2021 $0.0 $2.0 $4.0 $6.0 $8.0 $10.0 $12.0 $14.0 $16.0 $18.0 Mi l l i o n s Revenues by Source Prior YTD Current YTD $0.0 $5.0 $10.0 $15.0 $20.0 $25.0 $30.0 $35.0 Mi l l i o n s Expenditures by Object Prior YTD Current YTD Prior YTD FY2016 Actual YTD FY2016 FYTD Current Budget 2017 Prior YTD Prior Year Actual YTD % of PY Actual Current YTD Annual Budget YTD % of Budget REVENUES Property Taxes $486,947 $1,100,904 44.23%$599,985 $1,300,000 46.15% Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 0 0 0 0 --0 0 0 0 Intergovernmental 0 0 0 0 Charges for Services 0 0 0 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 2,167 3,132 69.20%777 1,000 77.70% Miscellaneous Revenue 0 0 0 0 Other Financing Sources 20,589 42,116 48.89%2,585 27,500 9.40% Transfers In 0 0 0 0 TOTAL REVENUE $509,703 $1,146,152 44.47%$603,347 $1,328,500 45.42% EXPENDITURES Salaries $159,489 $301,176 52.96%$182,176 $345,974 52.66% Benefits 51,851 101,465 51.10%63,316 106,088 59.68% Supplies 87 1,092 7.96%72 4,232 1.69% Services 373,730 707,040 52.86%308,708 861,750 35.82% Capital Outlay 0 0 0 0 Debt Service 0 0 0 0 Other (90)4,910 -1.83%0 7,000 0.00% Transfers 0 0 0 0 TOTAL EXPENDITURES $585,067 $1,115,683 52.44%$554,271 $1,325,044 41.83% SURPLUS / (DEFICIT)($75,364)$30,469 $49,076 $3,456 ENDING FUND BALANCE $283,703 $438,611 GENERAL ASSISTANCE FUND | Financial Summary For the Period Ending June 30, 2021 $0.0 $0.1 $0.2 $0.3 $0.4 $0.5 $0.6 $0.7 Mi l l i o n s Revenues by Source Prior YTD Current YTD ($0.1) $0.0 $0.1 $0.1 $0.2 $0.2 $0.3 $0.3 $0.4 $0.4 Mi l l i o n s Expenditures by Object Prior YTD Current YTD Prior YTD FY2016 Actual YTD FY2016 FYTD Current Budget 2017 Prior YTD Prior Year Actual YTD % of PY Actual Current YTD Annual Budget YTD % of Budget REVENUES Property Taxes $1,947,000 $3,110,000 62.60%$1,530,000 $3,110,000 49.20% Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 0 0 0 0 --0 0 0 0 Intergovernmental 35,000 98,549 35.52%67,998 125,000 54.40% Charges for Services 0 0 0 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 292 801 36.48%802 0 Miscellaneous Revenue 0 20,000 0.00%2,300 0 Other Financing Sources 1,600 5,950 26.89%440 2,000 22.00% Transfers In 50,000 100,000 50.00%225,000 450,000 50.00% TOTAL REVENUE $2,033,892 $3,335,300 60.98%$1,826,540 $3,687,000 49.54% EXPENDITURES Salaries $335,023 $1,089,063 30.76%$616,539 $1,834,955 33.60% Benefits 91,566 305,453 29.98%184,245 422,193 43.64% Supplies 891 4,523 19.69%2,353 15,410 15.27% Services 1,104 14,903 7.41%8,061 764,833 1.05% Capital Outlay 0 0 0 0 Debt Service 0 0 0 0 Other 230,632 985,359 23.41%155,674 608,333 25.59% Transfers 1,676 3,352 50.00%0 0 TOTAL EXPENDITURES $660,892 $2,402,653 27.51%$966,873 $3,645,724 26.52% SURPLUS / (DEFICIT)$1,373,000 $932,646 $859,667 $41,276 ENDING FUND BALANCE $1,410,417 $1,829,730 HUMAN SERVICES FUND | Financial Summary For the Period Ending June 30, 2021 $0.0 $0.5 $1.0 $1.5 $2.0 $2.5 Mi l l i o n s Revenues by Source Prior YTD Current YTD $0.0 $0.1 $0.2 $0.3 $0.4 $0.5 $0.6 $0.7 Mi l l i o n s Expenditures by Object Prior YTD Current YTD Prior YTD FY2016 Actual YTD FY2016 FYTD Current Budget 2017 Prior YTD Prior Year Actual YTD % of PY Actual Current YTD Annual Budget YTD % of Budget REVENUES Property Taxes $0 $0 $0 $0 Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 400,000 0.00% Other Taxes 0 0 0 0 --0 0 0 0 Intergovernmental 0 0 0 0 Charges for Services 0 0 0 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 0 0 142 0 Miscellaneous Revenue 0 0 0 0 Other Financing Sources 9,996 16,807 59.48%25,009 0 Transfers In 0 200,000 0.00%0 0 TOTAL REVENUE $9,996 $216,807 4.61%$25,151 $400,000 6.29% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 0 0 Services 0 0 25 0 Capital Outlay 0 0 0 0 Debt Service 0 0 0 0 Other 0 0 0 400,000 0.00% Transfers 0 0 0 0 TOTAL EXPENDITURES $0 $0 $25 $400,000 0.01% SURPLUS / (DEFICIT)$9,996 $216,807 $25,126 $0 ENDING FUND BALANCE $11,331 $243,267 REPARATIONS FUND | Financial Summary For the Period Ending June 30, 2021 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 Mi l l i o n s Revenues by Source Prior YTD Current YTD $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 Mi l l i o n s Expenditures by Object Prior YTD Current YTD Prior YTD FY2016 Actual YTD FY2016 FYTD Current Budget 2017 Prior YTD Prior Year Actual YTD % of PY Actual Current YTD Annual Budget YTD % of Budget REVENUES Property Taxes $0 $0 $0 $0 Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 0 0 0 0 --0 0 0 0 Intergovernmental 0 0 0 0 Charges for Services 0 0 0 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 1,487 1,805 82.38%502 0 Miscellaneous Revenue 0 0 0 0 Other Financing Sources 1,000,000 1,000,000 100.00%1,000,000 1,000,000 100.00% Transfers In 0 0 0 0 TOTAL REVENUE $1,001,487 $1,001,805 99.97%$1,000,502 $1,000,000 100.05% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 0 0 Services 275 497 55.24%269 0 Capital Outlay 0 0 0 0 Debt Service 0 0 0 0 Other 2,134 33,035 6.46%11,113 620,000 1.79% Transfers 435,000 870,000 50.00%414,152 380,000 108.99% TOTAL EXPENDITURES $437,409 $903,532 48.41%$425,533 $1,000,000 42.55% SURPLUS / (DEFICIT)$564,078 $98,273 $574,969 $0 ENDING FUND BALANCE $816,623 $925,786 GOOD NEIGHBOR FUND | Financial Summary For the Period Ending June 30, 2021 $0.0 $0.2 $0.4 $0.6 $0.8 $1.0 $1.2 Mi l l i o n s Revenues by Source Prior YTD Current YTD $0.0 $0.1 $0.1 $0.2 $0.2 $0.3 $0.3 $0.4 $0.4 $0.5 $0.5 Mi l l i o n s Expenditures by Object Prior YTD Current YTD Prior YTD FY2016 Actual YTD FY2016 FYTD Current Budget 2017 Prior YTD Prior Year Actual YTD % of PY Actual Current YTD Annual Budget YTD % of Budget REVENUES Property Taxes $3,639,099 $7,268,891 50.06%$3,959,723 $7,252,000 54.60% Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 0 0 0 0 --0 0 0 0 Intergovernmental 31,460 215,046 14.63%117,033 238,000 49.17% Charges for Services 65 150 43.22%111 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 16,771 22,320 75.14%4,478 0 Interest earnings 40,592 26,949 150.62%6,103 15,000 40.68% Miscellaneous Revenue 19,726 22,848 86.33%8,692 10,000 86.92% Other Financing Sources 172,410 476,244 36.20%155,543 617,224 25.20% Transfers In 35,148 269,414 13.05%250,000 209,000 119.62% TOTAL REVENUE $3,955,271 $8,301,863 47.64%$4,501,682 $8,341,224 53.97% EXPENDITURES Salaries $2,089,085 $4,262,028 49.02%$2,288,539 $4,654,672 49.17% Benefits 604,463 1,192,971 50.67%633,738 1,330,346 47.64% Supplies 369,649 800,856 46.16%355,108 909,900 39.03% Services 391,099 865,661 45.18%454,567 1,067,100 42.60% Capital Outlay 0 775 0.00%0 8,500 0.00% Debt Service 0 0 0 0 Other 0 0 0 0 Transfers 177,188 354,375 50.00%180,606 361,226 50.00% TOTAL EXPENDITURES $3,631,483 $7,476,666 48.57%$3,912,558 $8,331,744 46.96% SURPLUS / (DEFICIT)$323,788 $825,196 $589,125 $9,480 ENDING FUND BALANCE $2,393,431 $3,483,964 LIBRARY FUND | Financial Summary For the Period Ending June 30, 2021 $0.0 $0.5 $1.0 $1.5 $2.0 $2.5 $3.0 $3.5 $4.0 $4.5 Mi l l i o n s Revenues by Source Prior YTD Current YTD $0.0 $0.5 $1.0 $1.5 $2.0 $2.5 Mi l l i o n s Expenditures by Object Prior YTD Current YTD Prior YTD FY2016 Actual YTD FY2016 FYTD Current Budget 2017 Prior YTD Prior Year Actual YTD % of PY Actual Current YTD Annual Budget YTD % of Budget REVENUES Property Taxes $240,000 $480,145 49.98%$200,000 $482,243 41.47% Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 0 0 0 0 --0 0 0 0 Intergovernmental 0 0 0 0 Charges for Services 0 0 0 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 0 0 0 0 Miscellaneous Revenue 0 0 0 0 Other Financing Sources 0 0 0 0 Transfers In 0 0 0 0 TOTAL REVENUE $240,000 $480,145 49.98%$200,000 $482,243 41.47% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 0 0 Services 0 0 0 0 Capital Outlay 0 0 0 0 Debt Service 128,748 452,261 28.47%124,950 482,243 25.91% Other 0 0 0 0 Transfers 0 0 0 0 TOTAL EXPENDITURES $128,748 $452,261 28.47%$124,950 $482,243 25.91% SURPLUS / (DEFICIT)$111,252 $27,884 $75,050 $0 ENDING FUND BALANCE $84,513 $76,195 LIBRARY DEBT SERVICE FUND | Financial Summary For the Period Ending June 30, 2021 $0.0 $0.1 $0.1 $0.2 $0.2 $0.3 $0.3 Mi l l i o n s Revenues by Source Prior YTD Current YTD $0.0 $0.0 $0.0 $0.1 $0.1 $0.1 $0.1 $0.1 Mi l l i o n s Expenditures by Object Prior YTD Current YTD Prior YTD FY2016 Actual YTD FY2016 FYTD Current Budget 2017 Prior YTD Prior Year Actual YTD % of PY Actual Current YTD Annual Budget YTD % of Budget REVENUES Property Taxes $0 $0 $0 $0 Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 0 0 0 0 --0 0 0 0 Intergovernmental 0 0 0 0 Charges for Services 0 0 0 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 0 0 0 0 Miscellaneous Revenue 0 0 0 0 Other Financing Sources 0 0 0 449,000 0.00% Transfers In 0 0 0 0 TOTAL REVENUE $0 $0 $0 $449,000 0.00% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 0 0 Services 0 0 0 0 Capital Outlay 0 94,525 0.00%374,928 449,000 83.50% Debt Service 0 0 0 0 Other 0 0 0 0 Transfers 0 0 0 0 TOTAL EXPENDITURES $0 $94,525 0.00%$374,928 $449,000 83.50% SURPLUS / (DEFICIT)$0 ($94,525)($374,928)$0 ENDING FUND BALANCE $1,378,484 $909,030 LIBRARY CAPITAL IMPROVEMENT FD | Financial Summary For the Period Ending June 30, 2021 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 Mi l l i o n s Revenues by Source Prior YTD Current YTD $0.0 $0.1 $0.1 $0.2 $0.2 $0.3 $0.3 $0.4 $0.4 Mi l l i o n s Expenditures by Object Prior YTD Current YTD Prior YTD FY2016 Actual YTD FY2016 FYTD Current Budget 2017 Prior YTD Prior Year Actual YTD % of PY Actual Current YTD Annual Budget YTD % of Budget REVENUES Property Taxes $0 $0 $0 $0 Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 0 0 0 0 --0 0 0 0 Intergovernmental 2,239,126 4,426,655 50.58%3,002,301 3,656,700 82.10% Charges for Services 0 0 0 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 14,984 18,013 83.18%2,774 12,000 23.12% Miscellaneous Revenue 0 0 0 0 Other Financing Sources 0 0 0 0 Transfers In 0 0 0 0 TOTAL REVENUE $2,254,110 $4,444,668 50.71%$3,005,075 $3,668,700 81.91% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 331,446 396,989 83.49%317,439 673,000 47.17% Services 52,600 287,594 18.29%97,565 365,000 26.73% Capital Outlay 41,262 1,316,812 3.13%28,955 2,284,000 1.27% Debt Service 0 0 0 0 Other 0 0 0 0 Transfers 522,494 1,044,987 50.00%522,492 1,044,987 50.00% TOTAL EXPENDITURES $947,801 $3,046,382 31.11%$966,452 $4,366,987 22.13% SURPLUS / (DEFICIT)$1,306,308 $1,398,286 $2,038,623 ($698,287) ENDING FUND BALANCE $3,870,765 $6,001,366 MOTOR FUEL TAX FUND | Financial Summary For the Period Ending June 30, 2021 $0.0 $0.5 $1.0 $1.5 $2.0 $2.5 $3.0 $3.5 Mi l l i o n s Revenues by Source Prior YTD Current YTD $0.0 $0.1 $0.2 $0.3 $0.4 $0.5 $0.6 Mi l l i o n s Expenditures by Object Prior YTD Current YTD Prior YTD FY2016 Actual YTD FY2016 FYTD Current Budget 2017 Prior YTD Prior Year Actual YTD % of PY Actual Current YTD Annual Budget YTD % of Budget REVENUES Property Taxes $0 $0 $0 $0 Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 627,426 1,487,726 42.17%722,726 1,321,600 54.69% --0 0 0 0 Intergovernmental 60,205 240,821 25.00%0 0 Charges for Services 0 0 0 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 4,891 5,531 88.43%449 7,000 6.42% Miscellaneous Revenue 0 0 266 0 Other Financing Sources 0 0 0 0 Transfers In 0 0 0 0 TOTAL REVENUE $692,523 $1,734,078 39.94%$723,442 $1,328,600 54.45% EXPENDITURES Salaries $233,365 $423,454 55.11%$198,721 $535,437 37.11% Benefits 77,629 136,707 56.78%78,044 207,542 37.60% Supplies 16,861 47,404 35.57%1,236 53,700 2.30% Services 70,443 194,034 36.30%108,776 320,300 33.96% Capital Outlay 253,337 506,613 50.01%7,796 299,163 2.61% Debt Service 0 0 0 0 Other 0 0 0 0 Transfers 139,115 278,229 50.00%54,114 108,230 50.00% TOTAL EXPENDITURES $790,750 $1,586,442 49.84%$448,687 $1,524,371 29.43% SURPLUS / (DEFICIT)($98,227)$147,637 $274,755 ($195,771) ENDING FUND BALANCE $1,143,766 $1,664,385 EMERGENCY TELEPHONE (E911) FUND | Financial Summary For the Period Ending June 30, 2021 $0.0 $0.1 $0.2 $0.3 $0.4 $0.5 $0.6 $0.7 $0.8 Mi l l i o n s Revenues by Source Prior YTD Current YTD $0.0 $0.1 $0.1 $0.2 $0.2 $0.3 $0.3 Mi l l i o n s Expenditures by Object Prior YTD Current YTD Prior YTD FY2016 Actual YTD FY2016 FYTD Current Budget 2017 Prior YTD Prior Year Actual YTD % of PY Actual Current YTD Annual Budget YTD % of Budget REVENUES Property Taxes $0 $0 $0 $0 Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 0 0 0 0 --0 0 0 0 Intergovernmental 137,625 1,698,646 8.10%132,451 2,758,514 4.80% Charges for Services 0 0 0 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 0 0 0 0 Miscellaneous Revenue 0 0 0 0 Other Financing Sources 0 0 0 0 Transfers In 0 0 0 0 TOTAL REVENUE $137,625 $1,698,646 8.10%$132,451 $2,758,514 4.80% EXPENDITURES Salaries $168,763 $314,548 53.65%$139,652 $235,691 59.25% Benefits 53,857 93,920 57.34%41,514 84,306 49.24% Supplies 1,860 1,860 100.00%1,860 2,400 77.49% Services 1,631 24,653 6.62%1,205 503,800 0.24% Capital Outlay 98,648 454,007 21.73%25,459 0 Debt Service 0 153,125 0.00%69,691 0 Other 45,478 352,183 12.91%221,451 1,780,000 12.44% Transfers 80,547 304,349 26.47%138,009 150,000 92.01% TOTAL EXPENDITURES $450,784 $1,698,646 26.54%$638,841 $2,756,197 23.18% SURPLUS / (DEFICIT)($313,159)$0 ($506,390)$2,317 ENDING FUND BALANCE ($252,336)($445,567) CDBG FUND | Financial Summary For the Period Ending June 30, 2021 $0.0 $0.0 $0.0 $0.1 $0.1 $0.1 $0.1 $0.1 $0.2 Mi l l i o n s Revenues by Source Prior YTD Current YTD $0.0 $0.1 $0.1 $0.2 $0.2 $0.3 Mi l l i o n s Expenditures by Object Prior YTD Current YTD Prior YTD FY2016 Actual YTD FY2016 FYTD Current Budget 2017 Prior YTD Prior Year Actual YTD % of PY Actual Current YTD Annual Budget YTD % of Budget REVENUES Property Taxes $0 $603,396 0.00%$298,855 $575,000 51.97% Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 0 0 0 0 --0 0 0 0 Intergovernmental 0 0 0 0 Charges for Services 0 0 0 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 0 87 0.00%3 0 Miscellaneous Revenue 0 0 0 0 Other Financing Sources 0 0 0 0 Transfers In 0 0 0 0 TOTAL REVENUE $0 $603,483 0.00%$298,859 $575,000 51.98% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 0 0 Services 0 591,950 0.00%299,214 575,000 52.04% Capital Outlay 0 0 0 0 Debt Service 0 0 0 0 Other 0 0 0 0 Transfers 0 0 0 0 TOTAL EXPENDITURES $0 $591,950 0.00%$299,214 $575,000 52.04% SURPLUS / (DEFICIT)$0 $11,533 ($355)$0 ENDING FUND BALANCE ($226,193)($215,015) SPECIAL SERVICE AREA (SSA) #9 | Financial Summary For the Period Ending June 30, 2021 $0.0 $0.1 $0.1 $0.2 $0.2 $0.3 $0.3 $0.4 Mi l l i o n s Revenues by Source Prior YTD Current YTD $0.0 $0.1 $0.1 $0.2 $0.2 $0.3 $0.3 $0.4 Mi l l i o n s Expenditures by Object Prior YTD Current YTD Prior YTD FY2016 Actual YTD FY2016 FYTD Current Budget 2017 Prior YTD Prior Year Actual YTD % of PY Actual Current YTD Annual Budget YTD % of Budget REVENUES Property Taxes $0 $0 $0 $0 Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 0 0 0 0 --0 0 0 0 Intergovernmental 0 0 0 0 Charges for Services 0 0 0 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 2,022 2,388 84.67%504 0 Miscellaneous Revenue 0 0 0 0 Other Financing Sources 21,434 74,016 28.96%55,535 110,000 50.49% Transfers In 0 0 0 0 TOTAL REVENUE $23,456 $76,404 30.70%$56,038 $110,000 50.94% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 0 0 Services 63,586 120,956 52.57%0 175,000 0.00% Capital Outlay 0 0 0 0 Debt Service 0 0 0 0 Other 9 9 100.00%0 0 Transfers 0 0 0 0 TOTAL EXPENDITURES $63,594 $120,964 52.57%$0 $175,000 0.00% SURPLUS / (DEFICIT)($40,138)($44,560)$56,038 ($65,000) ENDING FUND BALANCE $187,247 $238,863 CDBG LOAN FUND | Financial Summary For the Period Ending June 30, 2021 $0.0 $0.0 $0.0 $0.0 $0.0 $0.1 $0.1 Mi l l i o n s Revenues by Source Prior YTD Current YTD $0.0 $0.0 $0.0 $0.0 $0.0 $0.1 $0.1 $0.1 Mi l l i o n s Expenditures by Object Prior YTD Current YTD Prior YTD FY2016 Actual YTD FY2016 FYTD Current Budget 2017 Prior YTD Prior Year Actual YTD % of PY Actual Current YTD Annual Budget YTD % of Budget REVENUES Property Taxes $0 $0 $0 $0 Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 0 0 0 0 --0 0 0 0 Intergovernmental 0 0 0 0 Charges for Services 0 0 0 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 293 334 87.54%14 0 Miscellaneous Revenue 0 0 0 0 Other Financing Sources 0 0 0 0 Transfers In 0 0 0 0 TOTAL REVENUE $293 $334 87.54%$14 $0 EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 0 0 Services 49 78 63.29%7 0 Capital Outlay 0 0 0 0 Debt Service 0 0 0 0 Other 0 0 0 0 Transfers 0 150,000 0.00%0 0 TOTAL EXPENDITURES $49 $150,078 0.03%$7 $0 SURPLUS / (DEFICIT)$243 ($149,744)$7 $0 ENDING FUND BALANCE $172,108 $22,128 NEIGHBORHOOD IMPROVEMENT | Financial Summary For the Period Ending June 30, 2021 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 Mi l l i o n s Revenues by Source Prior YTD Current YTD $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 Mi l l i o n s Expenditures by Object Prior YTD Current YTD Prior YTD FY2016 Actual YTD FY2016 FYTD Current Budget 2017 Prior YTD Prior Year Actual YTD % of PY Actual Current YTD Annual Budget YTD % of Budget REVENUES Property Taxes $0 $0 $0 $0 Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 0 0 0 0 --0 0 0 0 Intergovernmental 74,592 427,547 17.45%169,758 540,453 31.41% Charges for Services 0 0 0 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 72 115 62.66%34 150 22.66% Miscellaneous Revenue 0 0 0 0 Other Financing Sources 27,692 43,541 63.60%15,448 25,000 61.79% Transfers In 0 0 0 0 TOTAL REVENUE $102,356 $471,203 21.72%$185,239 $565,603 32.75% EXPENDITURES Salaries $325 $9,256 3.52%$25,678 $47,710 53.82% Benefits 754 3,265 23.09%7,884 16,165 48.77% Supplies 590 590 100.00%590 0 Services 86,019 410,606 20.95%214,471 500,565 42.85% Capital Outlay 0 0 0 0 Debt Service 0 0 0 0 Other 0 48 0.00%0 500 0.00% Transfers 14,493 25,398 57.06%0 0 TOTAL EXPENDITURES $102,182 $449,163 22.75%$248,623 $564,941 44.01% SURPLUS / (DEFICIT)$175 $22,039 ($63,383)$662 ENDING FUND BALANCE $7,700 ($33,818) HOME FUND | Financial Summary For the Period Ending June 30, 2021 $0.0 $0.0 $0.0 $0.1 $0.1 $0.1 $0.1 $0.1 $0.2 $0.2 Mi l l i o n s Revenues by Source Prior YTD Current YTD $0.0 $0.1 $0.1 $0.2 $0.2 $0.3 Mi l l i o n s Expenditures by Object Prior YTD Current YTD Prior YTD FY2016 Actual YTD FY2016 FYTD Current Budget 2017 Prior YTD Prior Year Actual YTD % of PY Actual Current YTD Annual Budget YTD % of Budget REVENUES Property Taxes $5,669,667 $12,814,109 44.25%$7,049,442 $13,936,263 50.58% Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 0 0 0 0 --0 0 0 0 Intergovernmental 0 0 0 0 Charges for Services 0 0 0 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 12,191 25,800 47.25%3,594 1,500 239.60% Miscellaneous Revenue 0 0 0 0 Other Financing Sources 0 12,018,001 0.00%0 0 Transfers In 1,659,527 3,319,053 50.00%598,710 1,197,401 50.00% TOTAL REVENUE $7,341,385 $28,176,963 26.05%$7,651,746 $15,135,164 50.56% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 0 0 Services 9 97,523 0.01%15 0 Capital Outlay 0 0 0 0 Debt Service 2,926,522 27,802,360 10.53%2,935,212 15,133,666 19.40% Other 0 0 0 0 Transfers 0 0 0 0 TOTAL EXPENDITURES $2,926,531 $27,899,883 10.49%$2,935,227 $15,133,666 19.40% SURPLUS / (DEFICIT)$4,414,853 $277,080 $4,716,519 $1,498 ENDING FUND BALANCE $4,859,232 $5,437,977 DEBT SERVICE FUND | Financial Summary For the Period Ending June 30, 2021 $0.0 $1.0 $2.0 $3.0 $4.0 $5.0 $6.0 $7.0 $8.0 Mi l l i o n s Revenues by Source Prior YTD Current YTD $0.0 $0.5 $1.0 $1.5 $2.0 $2.5 $3.0 $3.5 Mi l l i o n s Expenditures by Object Prior YTD Current YTD Prior YTD FY2016 Actual YTD FY2016 FYTD Current Budget 2017 Prior YTD Prior Year Actual YTD % of PY Actual Current YTD Annual Budget YTD % of Budget REVENUES Property Taxes $0 $0 $0 $0 Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 0 76,650 0.00%0 75,000 0.00% --0 0 0 0 Intergovernmental 0 255,300 0.00%162,013 658,000 24.62% Charges for Services 0 0 0 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 22,576 27,280 82.75%4,617 5,700 81.01% Miscellaneous Revenue 0 0 0 0 Other Financing Sources 65,000 655,417 9.92%64,167 175,600 36.54% Transfers In 0 0 0 0 TOTAL REVENUE $87,576 $1,014,647 8.63%$230,797 $914,300 25.24% EXPENDITURES Salaries $45,368 $99,985 45.38%$67,668 $150,933 44.83% Benefits 14,422 30,182 47.78%21,688 51,750 41.91% Supplies 2,048 2,048 100.00%1,860 0 Services 11,496 384,945 2.99%714,440 2,031,050 35.18% Capital Outlay 1,600 2,800 57.14%4,200 10,000 42.00% Debt Service 0 0 0 0 Other 14,776 652,722 2.26%148,278 268,510 55.22% Transfers (6,911)(34,215)20.20%0 17,000 0.00% TOTAL EXPENDITURES $82,799 $1,138,467 7.27%$958,134 $2,529,244 37.88% SURPLUS / (DEFICIT)$4,777 ($123,819)($727,337)($1,614,944) ENDING FUND BALANCE $3,930,379 $3,074,445 AFFORDABLE HOUSING FUND | Financial Summary For the Period Ending June 30, 2021 $0.0 $0.0 $0.0 $0.1 $0.1 $0.1 $0.1 $0.1 $0.2 $0.2 Mi l l i o n s Revenues by Source Prior YTD Current YTD ($0.1) $0.0 $0.1 $0.2 $0.3 $0.4 $0.5 $0.6 $0.7 $0.8 Mi l l i o n s Expenditures by Object Prior YTD Current YTD Prior YTD FY2016 Actual YTD FY2016 FYTD Current Budget 2017 Prior YTD Prior Year Actual YTD % of PY Actual Current YTD Annual Budget YTD % of Budget REVENUES Property Taxes $373,853 $1,207,019 30.97%$670,975 $968,000 69.32% Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 0 0 0 0 --0 0 0 0 Intergovernmental 0 0 0 0 Charges for Services 0 0 0 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 13,715 15,829 86.65%3,137 400 784.27% Miscellaneous Revenue 0 0 0 0 Other Financing Sources 18,869 20,632 91.45%3,947 5,366 73.56% Transfers In 0 0 0 0 TOTAL REVENUE $406,437 $1,243,480 32.69%$678,059 $973,766 69.63% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 0 0 Services 156,427 352,869 44.33%144,413 335,000 43.11% Capital Outlay 372,390 382,140 97.45%0 500,000 0.00% Debt Service 0 0 0 0 Other 731 731 100.00%0 0 Transfers 227,464 314,020 72.44%109,056 218,113 50.00% TOTAL EXPENDITURES $757,011 $1,049,760 72.11%$253,469 $1,053,113 24.07% SURPLUS / (DEFICIT)($350,574)$193,719 $424,590 ($79,347) ENDING FUND BALANCE $1,791,750 $2,760,634 HOWARD-RIDGE TIF FUND | Financial Summary For the Period Ending June 30, 2021 $0.0 $0.1 $0.2 $0.3 $0.4 $0.5 $0.6 $0.7 $0.8 Mi l l i o n s Revenues by Source Prior YTD Current YTD $0.0 $0.1 $0.1 $0.2 $0.2 $0.3 $0.3 $0.4 $0.4 Mi l l i o n s Expenditures by Object Prior YTD Current YTD Prior YTD FY2016 Actual YTD FY2016 FYTD Current Budget 2017 Prior YTD Prior Year Actual YTD % of PY Actual Current YTD Annual Budget YTD % of Budget REVENUES Property Taxes $359,872 $1,697,958 21.19%$869,944 $1,237,000 70.33% Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 0 0 0 0 --0 0 0 0 Intergovernmental 0 0 0 0 Charges for Services 0 0 0 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 3,111 6,071 51.25%2,391 4,000 59.78% Miscellaneous Revenue 0 0 0 0 Other Financing Sources 6,170 10,283 60.00%171,504 11,000 1559.13% Transfers In 0 0 0 0 TOTAL REVENUE $369,153 $1,714,311 21.53%$1,043,839 $1,252,000 83.37% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 0 0 Services 9 787 1.20%436 5,000 8.72% Capital Outlay 0 494,370 0.00%0 500,000 0.00% Debt Service 0 0 0 0 Other 0 0 0 200,000 0.00% Transfers 67,500 135,000 50.00%37,500 75,000 50.00% TOTAL EXPENDITURES $67,509 $630,157 10.71%$37,936 $780,000 4.86% SURPLUS / (DEFICIT)$301,643 $1,084,154 $1,005,903 $472,000 ENDING FUND BALANCE $1,012,119 $2,800,533 WEST EVANSTON TIF FUND | Financial Summary For the Period Ending June 30, 2021 $0.0 $0.1 $0.2 $0.3 $0.4 $0.5 $0.6 $0.7 $0.8 $0.9 $1.0 Mi l l i o n s Revenues by Source Prior YTD Current YTD $0.0 $0.0 $0.0 $0.0 $0.0 $0.1 $0.1 $0.1 $0.1 Mi l l i o n s Expenditures by Object Prior YTD Current YTD Prior YTD FY2016 Actual YTD FY2016 FYTD Current Budget 2017 Prior YTD Prior Year Actual YTD % of PY Actual Current YTD Annual Budget YTD % of Budget REVENUES Property Taxes $304,681 $1,145,555 26.60%$460,178 $879,000 52.35% Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 0 0 0 0 --0 0 0 0 Intergovernmental 0 0 0 0 Charges for Services 0 0 0 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 39,118 5,057 773.51%1,511 0 Miscellaneous Revenue 0 0 0 0 Other Financing Sources 0 0 0 1,130,000 0.00% Transfers In 0 0 0 0 TOTAL REVENUE $343,799 $1,150,612 29.88%$461,690 $2,009,000 22.98% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 0 0 Services 9 785 1.13%342 5,000 6.85% Capital Outlay 62,784 251,299 24.98%116,567 1,130,000 10.32% Debt Service 0 0 0 0 Other 0 0 0 0 Transfers 130,305 260,610 50.00%131,424 262,843 50.00% TOTAL EXPENDITURES $193,098 $512,694 37.66%$248,333 $1,397,843 17.77% SURPLUS / (DEFICIT)$150,701 $637,918 $213,357 $611,157 ENDING FUND BALANCE $837,454 $1,538,028 CHICAGO-MAIN TIF | Financial Summary For the Period Ending June 30, 2021 $0.0 $0.1 $0.1 $0.2 $0.2 $0.3 $0.3 $0.4 $0.4 $0.5 $0.5 Mi l l i o n s Revenues by Source Prior YTD Current YTD $0.0 $0.0 $0.0 $0.1 $0.1 $0.1 $0.1 $0.1 Mi l l i o n s Expenditures by Object Prior YTD Current YTD Prior YTD FY2016 Actual YTD FY2016 FYTD Current Budget 2017 Prior YTD Prior Year Actual YTD % of PY Actual Current YTD Annual Budget YTD % of Budget REVENUES Property Taxes $67,538 $170,306 39.66%$93,669 $147,000 63.72% Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 0 0 0 0 --0 0 0 0 Intergovernmental 0 0 0 0 Charges for Services 0 0 0 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 465 796 58.48%247 0 Miscellaneous Revenue 0 0 0 0 Other Financing Sources 0 0 0 0 Transfers In 50,000 100,000 50.00%0 0 TOTAL REVENUE $118,004 $271,102 43.53%$93,916 $147,000 63.89% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 0 0 Services 1 773 0.17%333 2,000 16.65% Capital Outlay 0 0 0 0 Debt Service 0 0 0 0 Other 0 0 0 0 Transfers 82,935 165,870 50.00%84,462 168,923 50.00% TOTAL EXPENDITURES $82,936 $166,643 49.77%$84,795 $170,923 49.61% SURPLUS / (DEFICIT)$35,068 $104,460 $9,121 ($23,923) ENDING FUND BALANCE $142,871 $221,384 DEMPSTER-DODGE TIF FUND | Financial Summary For the Period Ending June 30, 2021 $0.0 $0.0 $0.0 $0.0 $0.0 $0.1 $0.1 $0.1 $0.1 $0.1 $0.1 Mi l l i o n s Revenues by Source Prior YTD Current YTD $0.0 $0.0 $0.0 $0.0 $0.0 $0.1 $0.1 $0.1 $0.1 $0.1 Mi l l i o n s Expenditures by Object Prior YTD Current YTD Prior YTD FY2016 Actual YTD FY2016 FYTD Current Budget 2017 Prior YTD Prior Year Actual YTD % of PY Actual Current YTD Annual Budget YTD % of Budget REVENUES Property Taxes $124,104 $224,827 55.20%$5,264 $221,000 2.38% Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 0 0 0 0 --0 0 0 0 Intergovernmental 0 0 0 0 Charges for Services 0 0 0 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 173 316 54.81%6 500 1.26% Miscellaneous Revenue 0 0 0 0 Other Financing Sources 0 0 0 0 Transfers In 0 0 0 0 TOTAL REVENUE $124,277 $225,143 55.20%$5,270 $221,500 2.38% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 0 0 Services 0 226,412 0.00%7,548 221,500 3.41% Capital Outlay 0 0 0 0 Debt Service 0 0 0 0 Other 0 0 0 0 Transfers 0 0 0 0 TOTAL EXPENDITURES $0 $226,412 0.00%$7,548 $221,500 3.41% SURPLUS / (DEFICIT)$124,277 ($1,269)($2,278)$0 ENDING FUND BALANCE $129,619 $1,795 SPECIAL SERVICE AREA (SSA) #6 | Financial Summary For the Period Ending June 30, 2021 $0.0 $0.0 $0.0 $0.1 $0.1 $0.1 $0.1 $0.1 Mi l l i o n s Revenues by Source Prior YTD Current YTD $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 Mi l l i o n s Expenditures by Object Prior YTD Current YTD Prior YTD FY2016 Actual YTD FY2016 FYTD Current Budget 2017 Prior YTD Prior Year Actual YTD % of PY Actual Current YTD Annual Budget YTD % of Budget REVENUES Property Taxes $0 $141,256 0.00%$76,800 $115,000 66.78% Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 0 0 0 0 --0 0 0 0 Intergovernmental 0 0 0 0 Charges for Services 0 0 0 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 0 91 0.00%70 0 Miscellaneous Revenue 0 0 0 0 Other Financing Sources 0 0 0 0 Transfers In 0 0 0 0 TOTAL REVENUE $0 $141,348 0.00%$76,870 $115,000 66.84% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 0 0 Services 0 140,995 0.00%73,741 115,000 64.12% Capital Outlay 0 0 0 0 Debt Service 0 0 0 0 Other 0 0 0 0 Transfers 0 0 0 0 TOTAL EXPENDITURES $0 $140,995 0.00%$73,741 $115,000 64.12% SURPLUS / (DEFICIT)$0 $353 $3,129 $0 ENDING FUND BALANCE $0 $3,482 SPECIAL SERVICE AREA (SSA) #7 | Financial Summary For the Period Ending June 30, 2021 $0.0 $0.0 $0.0 $0.0 $0.0 $0.1 $0.1 $0.1 $0.1 $0.1 Mi l l i o n s Revenues by Source Prior YTD Current YTD $0.0 $0.0 $0.0 $0.0 $0.0 $0.1 $0.1 $0.1 $0.1 Mi l l i o n s Expenditures by Object Prior YTD Current YTD Prior YTD FY2016 Actual YTD FY2016 FYTD Current Budget 2017 Prior YTD Prior Year Actual YTD % of PY Actual Current YTD Annual Budget YTD % of Budget REVENUES Property Taxes $0 $59,744 0.00%$31,525 $60,200 52.37% Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 0 0 0 0 --0 0 0 0 Intergovernmental 0 0 0 0 Charges for Services 0 0 0 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 0 24 0.00%1 0 Miscellaneous Revenue 0 0 0 0 Other Financing Sources 0 0 0 0 Transfers In 0 0 0 0 TOTAL REVENUE $0 $59,768 0.00%$31,525 $60,200 52.37% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 0 0 Services 0 58,722 0.00%30,893 60,200 51.32% Capital Outlay 0 0 0 0 Debt Service 0 0 0 0 Other 0 0 0 0 Transfers 0 0 0 0 TOTAL EXPENDITURES $0 $58,722 0.00%$30,893 $60,200 51.32% SURPLUS / (DEFICIT)$0 $1,046 $632 $0 ENDING FUND BALANCE $0 $1,678 SPECIAL SERVICE AREA (SSA) #8 | Financial Summary For the Period Ending June 30, 2021 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 Mi l l i o n s Revenues by Source Prior YTD Current YTD $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 Mi l l i o n s Expenditures by Object Prior YTD Current YTD Prior YTD FY2016 Actual YTD FY2016 FYTD Current Budget 2017 Prior YTD Prior Year Actual YTD % of PY Actual Current YTD Annual Budget YTD % of Budget REVENUES Property Taxes $0 $0 $0 $0 Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 0 0 0 0 --0 0 0 0 Intergovernmental 0 0 329,333 0 Charges for Services 0 0 24,913 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 77,230 85,930 89.88%7,079 0 Miscellaneous Revenue 20,000 21,000 95.24%0 0 Other Financing Sources (1,312)6,885,294 -0.02%0 7,645,000 0.00% Transfers In 160,000 470,000 34.04%0 0 TOTAL REVENUE $255,918 $7,462,224 3.43%$361,326 $7,645,000 4.73% EXPENDITURES Salaries $253,642 $505,862 50.14%$269,629 $530,932 50.78% Benefits 80,338 156,855 51.22%83,441 165,835 50.32% Supplies 0 0 0 0 Services 469,746 1,619,728 29.00%660,853 0 Capital Outlay 1,993,609 6,893,688 28.92%1,581,609 9,705,000 16.30% Debt Service 0 0 0 0 Other 0 0 0 0 Transfers 290,000 290,000 100.00%0 0 TOTAL EXPENDITURES $3,087,334 $9,466,133 32.61%$2,595,532 $10,401,766 24.95% SURPLUS / (DEFICIT)($2,831,416)($2,003,910)($2,234,207)($2,756,766) ENDING FUND BALANCE $9,691,006 $8,284,306 CAPITAL IMPROVEMENTS FUND | Financial Summary For the Period Ending June 30, 2021 ($0.1) $0.0 $0.1 $0.1 $0.2 $0.2 $0.3 $0.3 $0.4 Mi l l i o n s Revenues by Source Prior YTD Current YTD $0.0 $0.5 $1.0 $1.5 $2.0 $2.5 Mi l l i o n s Expenditures by Object Prior YTD Current YTD Prior YTD FY2016 Actual YTD FY2016 FYTD Current Budget 2017 Prior YTD Prior Year Actual YTD % of PY Actual Current YTD Annual Budget YTD % of Budget REVENUES Property Taxes $0 $0 $0 $0 Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 0 0 0 0 --0 0 0 0 Intergovernmental 0 0 1,000,000 0 Charges for Services 0 0 0 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 80,982 90,688 89.30%5,618 0 Miscellaneous Revenue 0 0 0 0 Other Financing Sources 1,637,500 2,037,500 80.37%2,200,000 1,000,000 220.00% Transfers In 0 2,000,000 0.00%0 0 TOTAL REVENUE $1,718,482 $4,128,188 41.63%$3,205,618 $1,000,000 320.56% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 43,602 71,534 60.95%0 0 Services 111,710 261,928 42.65%6,299 0 Capital Outlay 4,304,098 6,884,236 62.52%66,905 1,000,000 6.69% Debt Service 0 0 0 0 Other 0 0 0 0 Transfers 0 637,500 0.00%0 637,500 0.00% TOTAL EXPENDITURES $4,459,410 $7,855,198 56.77%$73,204 $1,637,500 4.47% SURPLUS / (DEFICIT)($2,740,928)($3,727,010)$3,132,414 ($637,500) ENDING FUND BALANCE $3,616,967 $5,763,298 CROWN CONSTRUCTION FUND | Financial Summary For the Period Ending June 30, 2021 $0.0 $0.5 $1.0 $1.5 $2.0 $2.5 Mi l l i o n s Revenues by Source Prior YTD Current YTD $0.0 $0.5 $1.0 $1.5 $2.0 $2.5 $3.0 $3.5 $4.0 $4.5 $5.0 Mi l l i o n s Expenditures by Object Prior YTD Current YTD Prior YTD FY2016 Actual YTD FY2016 FYTD Current Budget 2017 Prior YTD Prior Year Actual YTD % of PY Actual Current YTD Annual Budget YTD % of Budget REVENUES Property Taxes $0 $0 $0 $0 Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 0 0 0 0 --0 0 0 0 Intergovernmental 0 0 0 0 Charges for Services 0 0 0 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 15,496 35,236 43.98%3,134 30,000 10.45% Miscellaneous Revenue 0 0 0 0 Other Financing Sources 94,031 168,415 55.83%54,421 125,000 43.54% Transfers In 0 0 0 0 TOTAL REVENUE $109,527 $203,651 53.78%$57,555 $155,000 37.13% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 0 0 Services 30 60 50.00%30 0 Capital Outlay 0 0 0 500,000 0.00% Debt Service 0 0 0 0 Other 0 0 0 0 Transfers 238,965 477,930 50.00%244,662 489,314 50.00% TOTAL EXPENDITURES $238,995 $477,990 50.00%$244,692 $989,314 24.73% SURPLUS / (DEFICIT)($129,468)($274,339)($187,137)($834,314) ENDING FUND BALANCE $2,798,338 $2,466,330 SPECIAL ASSESSMENT FUND | Financial Summary For the Period Ending June 30, 2021 $0.0 $0.0 $0.0 $0.0 $0.0 $0.1 $0.1 $0.1 $0.1 $0.1 $0.1 Mi l l i o n s Revenues by Source Prior YTD Current YTD $0.0 $0.1 $0.1 $0.2 $0.2 $0.3 $0.3 Mi l l i o n s Expenditures by Object Prior YTD Current YTD Prior YTD FY2016 Actual YTD FY2016 FYTD Current Budget 2017 Prior YTD Prior Year Actual YTD % of PY Actual Current YTD Annual Budget YTD % of Budget REVENUES Property Taxes $0 $0 $0 $0 Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 0 0 0 0 --0 0 0 0 Intergovernmental 0 0 0 0 Charges for Services 3,805,033 6,728,991 56.55%3,024,550 10,133,725 29.85% Licenses & Permits 75 75 100.00%150 0 Fines and Forefeitures 0 0 0 0 Interest earnings 32,654 53,584 60.94%13,493 20,000 67.47% Miscellaneous Revenue 23,650 29,350 80.58%5,308 11,400 46.56% Other Financing Sources 176,877 1,836,962 9.63%211,275 1,393,300 15.16% Transfers In 140,907 140,907 100.00%0 0 TOTAL REVENUE $4,179,197 $8,789,869 47.55%$3,254,775 $11,558,425 28.16% EXPENDITURES Salaries $601,733 $1,187,336 50.68%$585,278 $1,083,263 54.03% Benefits 208,280 385,740 54.00%179,185 358,532 49.98% Supplies 5,034 17,497 28.77%1,283 20,900 6.14% Services 2,310,205 3,968,340 58.22%1,849,741 4,457,583 41.50% Capital Outlay 263,452 343,622 76.67%108,783 1,750,000 6.22% Debt Service 0 0 28,215 47,164 59.82% Other 0 0 0 50,000 0.00% Transfers 1,741,287 4,982,573 34.95%1,741,944 3,483,892 50.00% TOTAL EXPENDITURES $5,129,991 $10,885,106 47.13%$4,494,429 $11,251,334 39.95% SURPLUS / (DEFICIT)($950,795)($2,095,238)($1,239,654)$307,091 ENDING FUND BALANCE $1,633,403 ($750,694) PARKING SYSTEM FUND | Financial Summary For the Period Ending June 30, 2021 $0.0 $0.5 $1.0 $1.5 $2.0 $2.5 $3.0 $3.5 $4.0 Mi l l i o n s Revenues by Source Prior YTD Current YTD $0.0 $0.5 $1.0 $1.5 $2.0 $2.5 Mi l l i o n s Expenditures by Object Prior YTD Current YTD Prior YTD FY2016 Actual YTD FY2016 FYTD Current Budget 2017 Prior YTD Prior Year Actual YTD % of PY Actual Current YTD Annual Budget YTD % of Budget REVENUES Property Taxes $0 $0 $0 $0 Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 0 0 0 0 --0 0 0 0 Intergovernmental 0 0 0 0 Charges for Services 9,955,741 19,424,200 51.25%9,433,136 23,006,700 41.00% Licenses & Permits 39,193 61,117 64.13%43,907 50,000 87.81% Fines and Forefeitures 0 0 0 0 Interest earnings 46,785 71,543 65.40%30,112 70,000 43.02% Miscellaneous Revenue 275 7,384 3.72%3,312 5,000 66.24% Other Financing Sources 3,980,296 8,867,096 44.89%357,977 19,624,150 1.82% Transfers In 0 0 0 0 TOTAL REVENUE $14,022,290 $28,431,339 49.32%$9,868,444 $42,755,850 23.08% EXPENDITURES Salaries $2,149,290 $4,228,639 50.83%$2,212,304 $4,516,038 48.99% Benefits 721,912 1,347,367 53.58%693,058 1,421,880 48.74% Supplies 357,403 954,654 37.44%328,773 1,624,990 20.23% Services 1,480,051 3,613,124 40.96%1,051,250 4,673,720 22.49% Capital Outlay 2,717,000 8,688,604 31.27%2,907,278 24,092,200 12.07% Debt Service 622,195 4,161,316 14.95%1,245,620 2,318,294 53.73% Other 0 0 7,952 1,000 795.22% Transfers 2,243,048 4,486,095 50.00%2,884,608 5,769,212 50.00% TOTAL EXPENDITURES $10,290,899 $27,479,799 37.45%$11,330,842 $44,417,334 25.51% SURPLUS / (DEFICIT)$3,731,392 $951,541 ($1,462,399)($1,661,484) ENDING FUND BALANCE $13,689,398 $9,447,148 WATER FUND | Financial Summary For the Period Ending June 30, 2021 $0.0 $2.0 $4.0 $6.0 $8.0 $10.0 $12.0 Mi l l i o n s Revenues by Source Prior YTD Current YTD $0.0 $0.5 $1.0 $1.5 $2.0 $2.5 $3.0 $3.5 Mi l l i o n s Expenditures by Object Prior YTD Current YTD Prior YTD FY2016 Actual YTD FY2016 FYTD Current Budget 2017 Prior YTD Prior Year Actual YTD % of PY Actual Current YTD Annual Budget YTD % of Budget REVENUES Property Taxes $0 $0 $0 $0 Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 0 0 0 0 --0 0 0 0 Intergovernmental 0 0 0 0 Charges for Services 5,738,002 10,242,066 56.02%4,542,620 10,375,408 43.78% Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 11,034 15,111 73.02%1,871 25,000 7.49% Miscellaneous Revenue 0 0 0 1,000 0.00% Other Financing Sources 0 1,964,331 0.00%0 2,000,000 0.00% Transfers In 0 0 0 0 TOTAL REVENUE $5,749,037 $12,221,507 47.04%$4,544,491 $12,401,408 36.64% EXPENDITURES Salaries $476,178 $977,605 48.71%$500,506 $1,070,069 46.77% Benefits 176,270 341,418 51.63%160,476 360,397 44.53% Supplies 4,548 52,733 8.63%24,691 112,600 21.93% Services 366,114 2,514,268 14.56%136,196 1,368,350 9.95% Capital Outlay 0 462,137 0.00%109,988 3,343,000 3.29% Debt Service 2,780,397 1,386,811 200.49%2,849,130 5,195,191 54.84% Other 0 0 0 0 Transfers 572,045 1,644,089 34.79%593,820 1,187,630 50.00% TOTAL EXPENDITURES $4,375,552 $7,379,059 59.30%$4,374,807 $12,637,237 34.62% SURPLUS / (DEFICIT)$1,373,484 $4,842,448 $169,684 ($235,829) ENDING FUND BALANCE $1,432,982 $5,071,630 SEWER FUND | Financial Summary For the Period Ending June 30, 2021 $0.0 $1.0 $2.0 $3.0 $4.0 $5.0 $6.0 $7.0 Mi l l i o n s Revenues by Source Prior YTD Current YTD $0.0 $0.5 $1.0 $1.5 $2.0 $2.5 $3.0 Mi l l i o n s Expenditures by Object Prior YTD Current YTD Prior YTD FY2016 Actual YTD FY2016 FYTD Current Budget 2017 Prior YTD Prior Year Actual YTD % of PY Actual Current YTD Annual Budget YTD % of Budget REVENUES Property Taxes $666,000 $1,332,500 49.98%$650,000 $1,332,500 48.78% Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 0 0 0 0 --0 0 0 0 Intergovernmental 0 0 0 0 Charges for Services 2,163,012 4,247,762 50.92%2,045,668 4,516,450 45.29% Licenses & Permits 141,603 299,838 47.23%124,714 297,000 41.99% Fines and Forefeitures 0 0 0 0 Interest earnings 0 0 0 0 Miscellaneous Revenue 0 0 0 0 Other Financing Sources 52,501 71,739 73.18%72,755 122,000 59.64% Transfers In 0 0 0 0 TOTAL REVENUE $3,023,116 $5,951,839 50.79%$2,893,137 $6,267,950 46.16% EXPENDITURES Salaries $442,943 $1,043,606 42.44%$561,086 $1,161,525 48.31% Benefits 148,352 316,616 46.86%175,355 342,727 51.16% Supplies 4,837 11,106 43.56%3,775 3,050 123.78% Services 1,601,664 3,440,354 46.56%1,603,120 3,677,326 43.59% Capital Outlay 126,715 391,359 32.38%197,407 505,000 39.09% Debt Service 0 0 0 0 Other 6,389 7,243 88.20%7,409 10,000 74.09% Transfers 161,181 322,362 50.00%151,002 302,000 50.00% TOTAL EXPENDITURES $2,492,082 $5,532,647 45.04%$2,699,154 $6,001,628 44.97% SURPLUS / (DEFICIT)$531,034 $419,192 $193,983 $266,322 ENDING FUND BALANCE ($38,484)$43,658 SOLID WASTE FUND | Financial Summary For the Period Ending June 30, 2021 $0.0 $0.5 $1.0 $1.5 $2.0 $2.5 Mi l l i o n s Revenues by Source Prior YTD Current YTD $0.0 $0.2 $0.4 $0.6 $0.8 $1.0 $1.2 $1.4 $1.6 $1.8 Mi l l i o n s Expenditures by Object Prior YTD Current YTD Prior YTD FY2016 Actual YTD FY2016 FYTD Current Budget 2017 Prior YTD Prior Year Actual YTD % of PY Actual Current YTD Annual Budget YTD % of Budget REVENUES Property Taxes $0 $0 $0 $0 Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 0 0 0 0 --0 0 0 0 Intergovernmental 0 0 0 0 Charges for Services 1,535,007 3,070,014 50.00%1,553,718 3,127,440 49.68% Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 0 0 0 1,000 0.00% Miscellaneous Revenue 0 70 0.00%0 0 Other Financing Sources 11,950 14,384 83.08%2,720 69,000 3.94% Transfers In 0 0 0 0 TOTAL REVENUE $1,546,957 $3,084,468 50.15%$1,556,438 $3,197,440 48.68% EXPENDITURES Salaries $391,015 $808,827 48.34%$415,052 $846,619 49.02% Benefits 145,769 287,456 50.71%146,050 301,548 48.43% Supplies 641,186 1,203,372 53.28%761,605 1,963,708 38.78% Services 56,622 121,071 46.77%31,000 70,799 43.79% Capital Outlay 4 4 100.00%19,924 0 Debt Service 0 0 0 0 Other 0 0 0 0 Transfers 0 0 0 0 TOTAL EXPENDITURES $1,234,596 $2,420,731 51.00%$1,373,631 $3,182,673 43.16% SURPLUS / (DEFICIT)$312,361 $663,737 $182,806 $14,767 ENDING FUND BALANCE $388,305 $922,487 FLEET SERVICES FUND | Financial Summary For the Period Ending June 30, 2021 $0.0 $0.2 $0.4 $0.6 $0.8 $1.0 $1.2 $1.4 $1.6 $1.8 Mi l l i o n s Revenues by Source Prior YTD Current YTD $0.0 $0.1 $0.2 $0.3 $0.4 $0.5 $0.6 $0.7 $0.8 Mi l l i o n s Expenditures by Object Prior YTD Current YTD Prior YTD FY2016 Actual YTD FY2016 FYTD Current Budget 2017 Prior YTD Prior Year Actual YTD % of PY Actual Current YTD Annual Budget YTD % of Budget REVENUES Property Taxes $0 $0 $0 $0 Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 0 0 0 0 --0 0 0 0 Intergovernmental 0 0 0 0 Charges for Services 739,713 1,479,425 50.00%112,434 224,885 50.00% Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 400 433 92.47%160 0 Miscellaneous Revenue 0 0 0 0 Other Financing Sources 13,380 818,320 1.64%79,290 1,060,217 7.48% Transfers In 0 0 0 0 TOTAL REVENUE $753,493 $2,298,178 32.79%$191,884 $1,285,102 14.93% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 0 0 Services 35,707 35,726 99.95%70 0 Capital Outlay 1,452,369 648,105 224.09%977,096 1,600,000 61.07% Debt Service 0 1,532,789 0.00%0 0 Other 0 0 0 0 Transfers 0 0 0 0 TOTAL EXPENDITURES $1,488,076 $2,216,620 67.13%$977,166 $1,600,000 61.07% SURPLUS / (DEFICIT)($734,583)$81,558 ($785,282)($314,898) ENDING FUND BALANCE ($292,598)($261,738) EQUIPMENT REPLACEMENT FUND | Financial Summary For the Period Ending June 30, 2021 $0.0 $0.1 $0.2 $0.3 $0.4 $0.5 $0.6 $0.7 $0.8 Mi l l i o n s Revenues by Source Prior YTD Current YTD $0.0 $0.2 $0.4 $0.6 $0.8 $1.0 $1.2 $1.4 $1.6 Mi l l i o n s Expenditures by Object Prior YTD Current YTD Prior YTD FY2016 Actual YTD FY2016 FYTD Current Budget 2017 Prior YTD Prior Year Actual YTD % of PY Actual Current YTD Annual Budget YTD % of Budget REVENUES Property Taxes $0 $0 $0 $0 Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 0 0 0 0 --0 0 0 0 Intergovernmental 0 0 0 0 Charges for Services 296 247,262 0.12%830 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 0 0 0 0 Miscellaneous Revenue 0 0 0 0 Other Financing Sources 1,662,129 3,353,241 49.57%1,678,257 3,253,500 51.58% Transfers In 8,066,679 15,723,505 51.30%8,583,421 18,094,686 47.44% TOTAL REVENUE $9,729,104 $19,324,009 50.35%$10,262,509 $21,348,186 48.07% EXPENDITURES Salaries $217,526 $484,825 44.87%$262,576 $497,615 52.77% Benefits 7,065,207 13,546,217 52.16%6,971,299 15,011,272 46.44% Supplies 0 0 0 200 0.00% Services 2,186,385 4,156,988 52.60%2,151,180 4,709,000 45.68% Capital Outlay 0 0 0 0 Debt Service 0 0 0 0 Other 0 0 0 0 Transfers 0 0 0 0 TOTAL EXPENDITURES $9,469,118 $18,188,029 52.06%$9,385,055 $20,218,087 46.42% SURPLUS / (DEFICIT)$259,986 $1,135,980 $877,454 $1,130,099 ENDING FUND BALANCE ($9,339,683)($7,586,235) INSURANCE FUND | Financial Summary For the Period Ending June 30, 2021 $0.0 $0.2 $0.4 $0.6 $0.8 $1.0 $1.2 $1.4 $1.6 $1.8 Mi l l i o n s Revenues by Source Prior YTD Current YTD $0.0 $1.0 $2.0 $3.0 $4.0 $5.0 $6.0 $7.0 $8.0 Mi l l i o n s Expenditures by Object Prior YTD Current YTD Prior YTD FY2016 Actual YTD FY2016 FYTD Current Budget 2017 Prior YTD Prior Year Actual YTD % of PY Actual Current YTD Annual Budget YTD % of Budget REVENUES Property Taxes $0 $0 $0 $0 Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 0 0 0 0 --0 0 0 0 Intergovernmental 0 0 0 0 Charges for Services 0 0 0 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 0 1,338,380 0.00%942,271 2,500,000 37.69% Miscellaneous Revenue 0 0 0 0 Other Financing Sources 780,756 12,621,341 6.19%13,142,637 11,815,000 111.24% Transfers In 0 0 0 0 TOTAL REVENUE $780,756 $13,959,721 5.59%$14,084,908 $14,315,000 98.39% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 5,023,819 10,314,909 48.70%5,351,506 10,805,300 49.53% Supplies 0 0 0 0 Services 0 0 0 0 Capital Outlay 0 0 0 0 Debt Service 0 0 0 0 Other 0 58,421 0.00%98,061 225,000 43.58% Transfers 0 0 0 0 TOTAL EXPENDITURES $5,023,819 $10,373,329 48.43%$5,449,567 $11,030,300 49.41% SURPLUS / (DEFICIT)($4,243,064)$3,586,392 $8,635,341 $3,284,700 ENDING FUND BALANCE $93,204,658 $109,669,454 FIRE PENSION FUND | Financial Summary For the Period Ending June 30, 2021 $0.0 $2.0 $4.0 $6.0 $8.0 $10.0 $12.0 $14.0 Mi l l i o n s Revenues by Source Prior YTD Current YTD $0.0 $1.0 $2.0 $3.0 $4.0 $5.0 $6.0 Mi l l i o n s Expenditures by Object Prior YTD Current YTD Prior YTD FY2016 Actual YTD FY2016 FYTD Current Budget 2017 Prior YTD Prior Year Actual YTD % of PY Actual Current YTD Annual Budget YTD % of Budget REVENUES Property Taxes $0 $0 $0 $0 Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 0 0 0 0 --0 0 0 0 Intergovernmental 0 0 0 0 Charges for Services 0 0 0 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 396,723 1,641,885 24.16%1,721,807 1,500,000 114.79% Miscellaneous Revenue 0 0 0 0 Other Financing Sources 2,711,967 21,084,778 12.86%20,933,657 18,214,700 114.93% Transfers In 0 0 0 0 TOTAL REVENUE $3,108,690 $22,726,663 13.68%$22,655,465 $19,714,700 114.92% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 6,645,493 13,439,772 49.45%7,095,402 14,326,000 49.53% Supplies 0 0 0 0 Services 0 0 0 0 Capital Outlay 0 0 0 0 Debt Service 0 0 0 0 Other 110,777 183,143 60.49%154,586 375,000 41.22% Transfers 0 0 0 0 TOTAL EXPENDITURES $6,756,270 $13,622,915 49.59%$7,249,988 $14,701,000 49.32% SURPLUS / (DEFICIT)($3,647,580)$9,103,748 $15,405,477 $5,013,700 ENDING FUND BALANCE $145,385,109 $173,541,914 POLICE PENSION FUND | Financial Summary For the Period Ending June 30, 2021 $0.0 $5.0 $10.0 $15.0 $20.0 $25.0 Mi l l i o n s Revenues by Source Prior YTD Current YTD $0.0 $1.0 $2.0 $3.0 $4.0 $5.0 $6.0 $7.0 $8.0 Mi l l i o n s Expenditures by Object Prior YTD Current YTD