Loading...
HomeMy WebLinkAbout2021.05 May Monthly Report To: Erika Storlie, City Manager From: Hitesh Desai, CFO/City Treasurer Tasheik Kerr, Management Analyst Subject: May 2021 Monthly Financial Report Date: July 16, 2021 Please find attached the unaudited financial statements as of May 31, 2021. A summary by fund for revenues, expenditures, fund and cash balances is as follows: May 2021 Revenue Expense Net Fund Balance Cash Balance 100 GENERAL FUND 53,689,814 48,173,934 5,515,880 22,982,147 19,355,949 170 AMERICAN RESCUE PLAN 21,590,807 - 21,590,807 21,590,807 21,590,807 175 GENERAL ASSISTANCE FUND 603,198 478,345 124,853 514,388 514,281 176 HEALTH AND HUMAN SERVICES 1,777,976 770,607 1,007,369 1,977,432 1,977,276 177 REPARATIONS FUND 24,519 20 24,499 242,640 242,640 180 GOOD NEIGHBOR FUND 1,000,405 425,512 574,893 925,711 925,711 185 LIBRARY FUND 4,500,112 3,243,263 1,256,849 4,151,688 4,163,992 186 LIBRARY DEBT SERVICE FUND 200,000 - 200,000 201,145 201,145 187 LIBRARY CAPITAL IMPROVEMENT FD - 281,327 (281,327) 1,002,632 1,002,632 200 MOTOR FUEL TAX FUND 1,943,226 833,171 1,110,055 5,072,798 4,850,404 205 EMERGENCY TELEPHONE (E911) FUND 590,680 349,994 240,686 1,630,317 1,273,605 210 SPECIAL SERVICE AREA (SSA) #4 298,858 187,607 111,251 (103,409) (103,409) 215 CDBG FUND 73,517 492,006 (418,489) (357,666) (357,666) 220 CDBG LOAN FUND 53,191 9 53,182 236,007 236,007 235 NEIGHBORHOOD IMPROVEMENT 12 6 5 22,126 22,126 240 HOME FUND 166,168 205,289 (39,120) (9,555) 16,482 250 AFFORDABLE HOUSING FUND 177,101 522,707 (345,606) 3,456,176 3,596,795 320 DEBT SERVICE FUND 7,550,467 10 7,550,457 8,271,915 8,294,938 330 HOWARD-RIDGE TIF FUND 673,971 231,125 442,846 2,778,889 2,762,019 335 WEST EVANSTON TIF FUND 1,043,307 31,684 1,011,623 2,806,253 2,806,253 340 DEMPSTER-DODGE TIF FUND 93,866 70,718 23,148 235,411 235,411 345 CHICAGO-MAIN TIF 461,387 226,428 234,959 1,559,630 1,559,630 350 SPECIAL SERVICE AREA (SSA) #6 5,269 0 5,269 9,342 9,342 355 SPECIAL SERVICE AREA (SSA) #7 76,855 16,625 60,231 60,584 60,584 360 SPECIAL SERVICE AREA (SSA) #8 31,525 74,228 (42,703) (41,657) (41,657) 415 CAPITAL IMPROVEMENTS FUND 335,423 1,569,236 (1,233,813) 9,284,699 9,675,066 416 CROWN CONSTRUCTION FUND 2,754,617 65,421 2,689,195 5,320,080 6,608,336 417 CROWN COMMUNITY CTR MAINTENANCE 72,915 - 72,915 247,915 247,915 420 SPECIAL ASSESSMENT FUND 52,542 203,910 (151,368) 2,502,100 2,498,917 505 PARKING SYSTEM FUND 2,646,191 3,785,986 (1,139,794) (650,835) (391,855) 510 WATER FUND 8,206,002 8,794,822 (588,820) 10,320,727 12,049,549 515 SEWER FUND 3,813,239 3,815,569 (2,331) 4,899,615 3,265,694 520 SOLID WASTE FUND 2,485,205 2,248,759 236,446 86,121 (611,595) 600 FLEET SERVICES FUND 1,296,343 1,144,354 151,990 891,670 (458,918) 601 EQUIPMENT REPLACEMENT FUND 156,945 854,401 (697,457) (173,913) (173,913) 605 INSURANCE FUND 8,622,674 7,766,598 856,076 (7,607,614) (3,030,775) Grand Total 127,068,328 86,863,671 40,204,656 104,336,317 104,873,718 Memorandum Please note that the attached supporting documents have been updated to show further fund and department analysis. Included above are ending fund and cash balances as of May 31, 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 May 31, 2021 with a fund balance of $22,982,147 and cash balance of $19,355,949. The attached financials show General Fund revenues at 48.36% of budget and expenses at 43.39% of budget against a target of 41%. The 2020 ending balance for the General Fund is 17,466,267. As of May 31, 2021, 57.39% of property tax revenue to the General Fund has been received. The second installment of property taxes will be received in July and August. Expenses are slightly above target because of combined property tax transfers of $10M to respective pension funds being part of Police and Fire Departments expenditures . January through May 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 May, Police had spent 28% of budget for overtime, and Fire had spent 79% of budget. For Police, this is below target of 41%. 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 May 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 May 31, 2021 are at 22.89% of budget and expenses are at 33.65%. The fund ended 2020 with a negative fund balance of $488,959.. Through May 31, 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 May 31, 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,945. Through May 31, 2021, the Solid Waste Fund has a fund balance of $86,121 and a negative cash balance of $611,595. The fund ended 2020 with a fund balance of $(150,325) Other Funds Through May 31, 2021, the SSA #4 Fund is showing negative fund balance of $103,409 and a negative cash balance of $103,409. Through May 31, 2021, the Capital Improvements Fund is showing a fund balance of $9,284,699 and a cash balance of $9,675,066. The fund continues to spend down Series 2019B and Series 2020 bond proceeds. Through May 31, 2021, the Crown Construction fund is showing fund balance of $5,320,080 and cash balance of $6,608,336. The fund continues to spend down balances from bond proceeds and gifts from the Friends of Robert Crown . Through May 31, 2021, the Insurance Fund is showing a negative fund balance of $7,607,614 and a negative cash balance of $3,030,775. 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 Property Taxes $5,431,974 State Income Tax $4,681,054 Sales Tax - Basic $4,019,339 Recreation Program Fees $2,904,459 Building Permits $2,800,777 Sales Tax - Home Rule $2,789,534 Real Estate Transfer Tax $1,857,826 State Use Tax $1,184,620 Electric Utility Tax $1,183,744 Major Funds Revenue Dashboard Summary For the Period Ending May 31, 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 $11,392,952 Fire Mgmt & Support $6,646,081 Public Works Agency $4,106,466 Administrative Services $3,972,678 Parks And Recreation $3,275,063 City Manager'S Office $1,803,155 Community Development $1,325,911 Health $696,699 City Council $206,989 Law $197,333 Major Funds Expenditure Dashboard Summary For the Period Ending May 31, 2021 Top 10 GENERAL FUND Expenditures by Department (YTD) $0.0 $5.0 $10.0 $15.0 $20.0 $25.0 $30.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 7,087,397 19,215,616 36.88%7,993,493 19,200,000 41.63% Business & Occupation Taxes 9,799,990 22,031,358 44.48%10,933,050 22,955,000 47.63% Other Taxes 1,893,353 7,411,753 25.55%3,193,294 7,105,000 44.94% --0 65,094 0.00%38,377 0 Intergovernmental 473,036 3,516,270 13.45%1,630,415 1,584,942 102.87% Charges for Services 2,880,863 7,527,170 38.27%4,000,843 9,357,875 42.75% Licenses & Permits 3,889,212 9,169,414 42.42%4,154,568 7,600,550 54.66% Fines and Forefeitures 797,528 2,990,415 26.67%1,044,993 4,123,500 25.34% Interest earnings 52,092 68,280 76.29%13,483 55,000 24.51% Miscellaneous Revenue 116,649 234,834 49.67%82,454 122,100 67.53% Other Financing Sources 468,983 1,116,601 42.00%297,743 1,471,000 20.24% Transfers In 3,741,293 9,269,103 40.36%4,067,947 9,149,103 TOTAL REVENUE $45,150,341 $111,975,537 40.32%$53,689,814 $111,022,609 48.36% EXPENDITURES Salaries $24,157,678 $55,417,401 43.59%$24,829,927 $58,394,928 42.52% Benefits 5,583,946 12,344,532 45.23%5,552,969 12,518,165 44.36% Supplies 919,333 3,214,808 28.60%638,776 2,608,964 24.48% Services 2,461,843 7,694,142 32.00%2,158,789 8,231,769 26.23% Capital Outlay 27,556 235,983 11.68%25,566 320,000 7.99% Debt Service 0 0 310,068 0 Other 182,657 573,596 31.84%180,472 593,125 30.43% Transfers 14,608,602 30,231,098 48.32%14,477,367 28,353,239 51.06% TOTAL EXPENDITURES $47,941,615 $109,711,559 43.70%$48,173,934 $111,020,191 43.39% SURPLUS / (DEFICIT)($2,791,274)$2,263,978 $5,515,880 $2,418 ENDING FUND BALANCE $12,411,016 $22,982,147 GENERAL FUND | Financial Summary For the Period Ending May 31, 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 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,931 $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 1,980 3,132 63.23%628 1,000 62.76% 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,500 $1,146,152 44.45%$603,198 $1,328,500 45.40% EXPENDITURES Salaries $134,696 $301,176 44.72%$155,582 $345,974 44.97% Benefits 43,576 101,465 42.95%53,355 106,088 50.29% Supplies 87 1,092 7.96%72 4,232 1.69% Services 305,918 707,040 43.27%269,336 861,750 31.25% 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 $484,187 $1,115,683 43.40%$478,345 $1,325,044 36.10% SURPLUS / (DEFICIT)$25,313 $30,469 $124,853 $3,456 ENDING FUND BALANCE $384,379 $514,388 GENERAL ASSISTANCE FUND | Financial Summary For the Period Ending May 31, 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 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 29,167 98,549 29.60%57,165 125,000 45.73% Charges for Services 0 0 0 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 164 801 20.53%571 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 41,667 100,000 41.67%187,500 450,000 41.67% TOTAL REVENUE $2,019,598 $3,335,300 60.55%$1,777,976 $3,687,000 48.22% EXPENDITURES Salaries $272,012 $1,089,063 24.98%$470,875 $1,834,955 25.66% Benefits 75,593 305,453 24.75%150,139 422,193 35.56% Supplies 891 4,523 19.69%2,353 15,410 15.27% Services 1,055 14,903 7.08%8,010 764,833 1.05% Capital Outlay 0 0 0 0 Debt Service 0 0 0 0 Other 230,632 985,359 23.41%139,230 608,333 22.89% Transfers 1,397 3,352 41.67%0 0 TOTAL EXPENDITURES $581,579 $2,402,653 24.21%$770,607 $3,645,724 21.14% SURPLUS / (DEFICIT)$1,438,018 $932,646 $1,007,369 $41,276 ENDING FUND BALANCE $1,475,435 $1,977,432 HUMAN SERVICES FUND | Financial Summary For the Period Ending May 31, 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.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 $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 95 0 Miscellaneous Revenue 0 0 0 0 Other Financing Sources 5,500 16,807 32.73%24,424 0 Transfers In 0 200,000 0.00%0 0 TOTAL REVENUE $5,500 $216,807 2.54%$24,519 $400,000 6.13% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 0 0 Services 0 0 20 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 $20 $400,000 0.01% SURPLUS / (DEFICIT)$5,500 $216,807 $24,499 $0 ENDING FUND BALANCE $6,835 $242,640 REPARATIONS FUND | Financial Summary For the Period Ending May 31, 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 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,410 1,805 78.10%405 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,410 $1,001,805 99.96%$1,000,405 $1,000,000 100.04% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 0 0 Services 245 497 49.27%247 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 362,500 870,000 41.67%414,152 380,000 108.99% TOTAL EXPENDITURES $364,880 $903,532 40.38%$425,512 $1,000,000 42.55% SURPLUS / (DEFICIT)$636,531 $98,273 $574,893 $0 ENDING FUND BALANCE $889,075 $925,711 GOOD NEIGHBOR FUND | Financial Summary For the Period Ending May 31, 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 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 25,920 215,046 12.05%117,033 238,000 49.17% Charges for Services 65 150 43.22%93 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 10,627 22,320 47.61%4,478 0 Interest earnings 40,309 26,949 149.57%4,842 15,000 32.28% Miscellaneous Revenue 13,708 22,848 59.99%8,692 10,000 86.92% Other Financing Sources 84,023 476,244 17.64%155,252 617,224 25.15% Transfers In 29,167 269,414 10.83%250,000 209,000 119.62% TOTAL REVENUE $3,842,916 $8,301,863 46.29%$4,500,112 $8,341,224 53.95% EXPENDITURES Salaries $1,785,676 $4,262,028 41.90%$1,927,559 $4,654,672 41.41% Benefits 510,592 1,192,971 42.80%533,102 1,330,346 40.07% Supplies 349,669 800,856 43.66%268,996 909,900 29.56% Services 347,466 865,661 40.14%363,101 1,067,100 34.03% Capital Outlay 0 775 0.00%0 8,500 0.00% Debt Service 0 0 0 0 Other 0 0 0 0 Transfers 147,656 354,375 41.67%150,505 361,226 41.67% TOTAL EXPENDITURES $3,141,060 $7,476,666 42.01%$3,243,263 $8,331,744 38.93% SURPLUS / (DEFICIT)$701,856 $825,196 $1,256,849 $9,480 ENDING FUND BALANCE $2,771,499 $4,151,688 LIBRARY FUND | Financial Summary For the Period Ending May 31, 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 0 452,261 0.00%0 482,243 0.00% Other 0 0 0 0 Transfers 0 0 0 0 TOTAL EXPENDITURES $0 $452,261 0.00%$0 $482,243 0.00% SURPLUS / (DEFICIT)$240,000 $27,884 $200,000 $0 ENDING FUND BALANCE $213,261 $201,145 LIBRARY DEBT SERVICE FUND | Financial Summary For the Period Ending May 31, 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.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 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%281,327 449,000 62.66% Debt Service 0 0 0 0 Other 0 0 0 0 Transfers 0 0 0 0 TOTAL EXPENDITURES $0 $94,525 0.00%$281,327 $449,000 62.66% SURPLUS / (DEFICIT)$0 ($94,525)($281,327)$0 ENDING FUND BALANCE $1,378,484 $1,002,632 LIBRARY CAPITAL IMPROVEMENT FD | Financial Summary For the Period Ending May 31, 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 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 0 Transfers In 0 0 0 0 TOTAL REVENUE $0 $0 $0 $0 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 0 0 0 0 Other 0 0 0 0 Transfers 0 0 0 0 TOTAL EXPENDITURES $0 $0 $0 $0 SURPLUS / (DEFICIT)$0 $0 $0 $0 ENDING FUND BALANCE $0 $0 #N/A For the Period Ending May 31, 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.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 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,064,209 4,426,655 46.63%1,940,764 3,656,700 53.07% Charges for Services 0 0 0 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 13,872 18,013 77.01%2,462 12,000 20.52% Miscellaneous Revenue 0 0 0 0 Other Financing Sources 0 0 0 0 Transfers In 0 0 0 0 TOTAL REVENUE $2,078,082 $4,444,668 46.75%$1,943,226 $3,668,700 52.97% 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 35,980 287,594 12.51%51,367 365,000 14.07% 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 435,411 1,044,987 41.67%435,410 1,044,987 41.67% TOTAL EXPENDITURES $844,098 $3,046,382 27.71%$833,171 $4,366,987 19.08% SURPLUS / (DEFICIT)$1,233,983 $1,398,286 $1,110,055 ($698,287) ENDING FUND BALANCE $3,798,440 $5,072,798 MOTOR FUEL TAX FUND | Financial Summary For the Period Ending May 31, 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.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 $0 $0 $0 $0 Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 508,043 1,487,726 34.15%590,026 1,321,600 44.64% --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,563 5,531 82.50%388 7,000 5.54% Miscellaneous Revenue 0 0 266 0 Other Financing Sources 0 0 0 0 Transfers In 0 0 0 0 TOTAL REVENUE $572,811 $1,734,078 33.03%$590,680 $1,328,600 44.46% EXPENDITURES Salaries $204,810 $423,454 48.37%$167,674 $535,437 31.32% Benefits 66,478 136,707 48.63%65,178 207,542 31.40% Supplies 14,014 47,404 29.56%1,236 53,700 2.30% Services 63,839 194,034 32.90%68,861 320,300 21.50% Capital Outlay 66,668 506,613 13.16%1,950 299,163 0.65% Debt Service 0 0 0 0 Other 0 0 0 0 Transfers 115,929 278,229 41.67%45,095 108,230 41.67% TOTAL EXPENDITURES $531,737 $1,586,442 33.52%$349,994 $1,524,371 22.96% SURPLUS / (DEFICIT)$41,074 $147,637 $240,686 ($195,771) ENDING FUND BALANCE $1,283,068 $1,630,317 EMERGENCY TELEPHONE (E911) FUND | Financial Summary For the Period Ending May 31, 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.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,858 $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%187,607 575,000 32.63% 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%$187,607 $575,000 32.63% SURPLUS / (DEFICIT)$0 $11,533 $111,251 $0 ENDING FUND BALANCE ($226,193)($103,409) SPECIAL SERVICE AREA (SSA) #9 | Financial Summary For the Period Ending May 31, 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.0 $0.0 $0.1 $0.1 $0.1 $0.1 $0.1 $0.2 $0.2 $0.2 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 107,625 1,698,646 6.34%73,517 2,758,514 2.67% 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 $107,625 $1,698,646 6.34%$73,517 $2,758,514 2.67% EXPENDITURES Salaries $137,625 $314,548 43.75%$118,290 $235,691 50.19% Benefits 46,714 93,920 49.74%34,871 84,306 41.36% Supplies 1,860 1,860 100.00%1,860 2,400 77.49% Services 1,626 24,653 6.59%260 503,800 0.05% 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%103,565 1,780,000 5.82% Transfers 8,498 304,349 2.79%138,009 150,000 92.01% TOTAL EXPENDITURES $340,448 $1,698,646 20.04%$492,006 $2,756,197 17.85% SURPLUS / (DEFICIT)($232,823)$0 ($418,489)$2,317 ENDING FUND BALANCE ($172,000)($357,666) CDBG FUND | Financial Summary For the Period Ending May 31, 2021 $0.0 $0.0 $0.0 $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.1 $0.1 $0.1 $0.1 $0.1 $0.2 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,949 2,388 81.63%430 0 Miscellaneous Revenue 0 0 0 0 Other Financing Sources 19,981 74,016 27.00%52,761 110,000 47.96% Transfers In 0 0 0 0 TOTAL REVENUE $21,930 $76,404 28.70%$53,191 $110,000 48.36% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 0 0 Services 61,686 120,956 51.00%0 175,000 0.00% Capital Outlay 0 0 0 0 Debt Service 0 0 0 0 Other 9 9 100.00%9 0 Transfers 0 0 0 0 TOTAL EXPENDITURES $61,694 $120,964 51.00%$9 $175,000 0.01% SURPLUS / (DEFICIT)($39,764)($44,560)$53,182 ($65,000) ENDING FUND BALANCE $187,621 $236,007 CDBG LOAN FUND | Financial Summary For the Period Ending May 31, 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 278 334 83.06%12 0 Miscellaneous Revenue 0 0 0 0 Other Financing Sources 0 0 0 0 Transfers In 0 0 0 0 TOTAL REVENUE $278 $334 83.06%$12 $0 EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 0 0 Services 43 78 55.89%6 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 $43 $150,078 0.03%$6 $0 SURPLUS / (DEFICIT)$234 ($149,744)$5 $0 ENDING FUND BALANCE $172,099 $22,126 NEIGHBORHOOD IMPROVEMENT | Financial Summary For the Period Ending May 31, 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 $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 63,689 427,547 14.90%150,692 540,453 27.88% Charges for Services 0 0 0 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 67 115 58.31%29 150 19.13% Miscellaneous Revenue 0 0 0 0 Other Financing Sources 25,410 43,541 58.36%15,448 25,000 61.79% Transfers In 0 0 0 0 TOTAL REVENUE $89,166 $471,203 18.92%$166,168 $565,603 29.38% EXPENDITURES Salaries $325 $9,256 3.52%$21,749 $47,710 45.59% Benefits 754 3,265 23.09%6,626 16,165 40.99% Supplies 590 590 100.00%590 0 Services 63,716 410,606 15.52%176,755 500,565 35.31% Capital Outlay 0 0 0 0 Debt Service 0 0 0 0 Other 0 48 0.00%0 500 0.00% Transfers 373 25,398 1.47%(431)0 TOTAL EXPENDITURES $65,758 $449,163 14.64%$205,289 $564,941 36.34% SURPLUS / (DEFICIT)$23,409 $22,039 ($39,120)$662 ENDING FUND BALANCE $30,934 ($9,555) HOME FUND | Financial Summary For the Period Ending May 31, 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.0 $0.0 $0.0 $0.1 $0.1 $0.1 $0.1 $0.1 $0.2 $0.2 $0.2 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%108,974 658,000 16.56% Charges for Services 0 0 0 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 20,845 27,280 76.41%3,960 5,700 69.48% Miscellaneous Revenue 0 0 0 0 Other Financing Sources 64,583 655,417 9.85%64,167 175,600 36.54% Transfers In 0 0 0 0 TOTAL REVENUE $85,428 $1,014,647 8.42%$177,101 $914,300 19.37% EXPENDITURES Salaries $38,510 $99,985 38.52%$57,519 $150,933 38.11% Benefits 12,329 30,182 40.85%18,253 51,750 35.27% Supplies 2,048 2,048 100.00%1,860 0 Services 11,491 384,945 2.99%296,022 2,031,050 14.57% Capital Outlay 400 2,800 14.29%3,000 10,000 30.00% Debt Service 0 0 0 0 Other 14,697 652,722 2.25%173,362 268,510 64.56% Transfers 0 (34,215)0.00%(27,309)17,000 -160.64% TOTAL EXPENDITURES $79,474 $1,138,467 6.98%$522,707 $2,529,244 20.67% SURPLUS / (DEFICIT)$5,954 ($123,819)($345,606)($1,614,944) ENDING FUND BALANCE $3,931,557 $3,456,176 AFFORDABLE HOUSING FUND | Financial Summary For the Period Ending May 31, 2021 $0.0 $0.0 $0.0 $0.1 $0.1 $0.1 $0.1 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 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 9,512 25,800 36.87%3,236 1,500 215.73% Miscellaneous Revenue 0 0 0 0 Other Financing Sources 0 12,018,001 0.00%(1,135)0 Transfers In 1,382,939 3,319,053 41.67%498,925 1,197,401 41.67% TOTAL REVENUE $7,062,119 $28,176,963 25.06%$7,550,467 $15,135,164 49.89% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 0 0 Services 5 97,523 0.00%10 0 Capital Outlay 0 0 0 0 Debt Service 0 27,802,360 0.00%0 15,133,666 0.00% Other 0 0 0 0 Transfers 0 0 0 0 TOTAL EXPENDITURES $5 $27,899,883 0.00%$10 $15,133,666 0.00% SURPLUS / (DEFICIT)$7,062,114 $277,080 $7,550,457 $1,498 ENDING FUND BALANCE $7,506,492 $8,271,915 DEBT SERVICE FUND | Financial Summary For the Period Ending May 31, 2021 ($1.0) $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.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 $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 12,703 15,829 80.25%2,549 400 637.16% Miscellaneous Revenue 0 0 0 0 Other Financing Sources 17,974 20,632 87.12%447 5,366 8.33% Transfers In 0 0 0 0 TOTAL REVENUE $404,530 $1,243,480 32.53%$673,971 $973,766 69.21% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 0 0 Services 156,426 352,869 44.33%149,995 335,000 44.77% Capital Outlay 0 382,140 0.00%(9,750)500,000 -1.95% Debt Service 0 0 0 0 Other 576 731 78.74%0 0 Transfers 72,130 314,020 22.97%90,880 218,113 41.67% TOTAL EXPENDITURES $229,133 $1,049,760 21.83%$231,125 $1,053,113 21.95% SURPLUS / (DEFICIT)$175,397 $193,719 $442,846 ($79,347) ENDING FUND BALANCE $2,317,721 $2,778,889 HOWARD-RIDGE TIF FUND | Financial Summary For the Period Ending May 31, 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.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 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,222 $1,697,958 21.16%$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 2,751 6,071 45.32%1,859 4,000 46.48% Miscellaneous Revenue 0 0 0 0 Other Financing Sources 5,141 10,283 50.00%171,504 11,000 1559.13% Transfers In 0 0 0 0 TOTAL REVENUE $367,115 $1,714,311 21.41%$1,043,307 $1,252,000 83.33% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 0 0 Services 9 787 1.10%434 5,000 8.69% 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 56,250 135,000 41.67%31,250 75,000 41.67% TOTAL EXPENDITURES $56,259 $630,157 8.93%$31,684 $780,000 4.06% SURPLUS / (DEFICIT)$310,856 $1,084,154 $1,011,623 $472,000 ENDING FUND BALANCE $1,021,332 $2,806,253 WEST EVANSTON TIF FUND | Financial Summary For the Period Ending May 31, 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 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 413 796 51.92%197 0 Miscellaneous Revenue 0 0 0 0 Other Financing Sources 0 0 0 0 Transfers In 41,667 100,000 41.67%0 0 TOTAL REVENUE $109,618 $271,102 40.43%$93,866 $147,000 63.85% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 0 0 Services 1 773 0.16%333 2,000 16.64% Capital Outlay 0 0 0 0 Debt Service 0 0 0 0 Other 0 0 0 0 Transfers 69,113 165,870 41.67%70,385 168,923 41.67% TOTAL EXPENDITURES $69,114 $166,643 41.47%$70,718 $170,923 41.37% SURPLUS / (DEFICIT)$40,505 $104,460 $23,148 ($23,923) ENDING FUND BALANCE $148,308 $235,411 DEMPSTER-DODGE TIF FUND | Financial Summary For the Period Ending May 31, 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 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 38,794 5,057 767.10%1,208 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,474 $1,150,612 29.85%$461,387 $2,009,000 22.97% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 0 0 Services 8 785 1.04%341 5,000 6.83% Capital Outlay 0 251,299 0.00%116,567 1,130,000 10.32% Debt Service 0 0 0 0 Other 0 0 0 0 Transfers 108,588 260,610 41.67%109,520 262,843 41.67% TOTAL EXPENDITURES $108,596 $512,694 21.18%$226,428 $1,397,843 16.20% SURPLUS / (DEFICIT)$234,879 $637,918 $234,959 $611,157 ENDING FUND BALANCE $921,632 $1,559,630 CHICAGO-MAIN TIF | Financial Summary For the Period Ending May 31, 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 $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 127 316 40.37%5 500 0.91% Miscellaneous Revenue 0 0 0 0 Other Financing Sources 0 0 0 0 Transfers In 0 0 0 0 TOTAL REVENUE $124,232 $225,143 55.18%$5,269 $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%0 221,500 0.00% 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%$0 $221,500 0.00% SURPLUS / (DEFICIT)$124,231 ($1,269)$5,269 $0 ENDING FUND BALANCE $129,573 $9,342 SPECIAL SERVICE AREA (SSA) #6 | Financial Summary For the Period Ending May 31, 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 $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%55 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,855 $115,000 66.83% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 0 0 Services 0 140,995 0.00%16,625 115,000 14.46% 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%$16,625 $115,000 14.46% SURPLUS / (DEFICIT)$0 $353 $60,231 $0 ENDING FUND BALANCE $0 $60,584 SPECIAL SERVICE AREA (SSA) #7 | Financial Summary For the Period Ending May 31, 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.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 $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%74,228 60,200 123.30% 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%$74,228 $60,200 123.30% SURPLUS / (DEFICIT)$0 $1,046 ($42,703)$0 ENDING FUND BALANCE $0 ($41,657) SPECIAL SERVICE AREA (SSA) #8 | Financial Summary For the Period Ending May 31, 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.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 329,333 0 Charges for Services 0 0 0 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 61,892 85,930 72.03%6,815 0 Miscellaneous Revenue 20,000 21,000 95.24%0 0 Other Financing Sources (1,312)6,885,294 -0.02%(726)7,645,000 -0.01% Transfers In 133,333 470,000 28.37%0 0 TOTAL REVENUE $213,913 $7,462,224 2.87%$335,423 $7,645,000 4.39% EXPENDITURES Salaries $217,448 $505,862 42.99%$229,679 $530,932 43.26% Benefits 68,129 156,855 43.43%70,371 165,835 42.43% Supplies 0 0 0 0 Services 372,895 1,619,728 23.02%363,584 0 Capital Outlay 1,648,574 6,893,688 23.91%905,602 9,705,000 9.33% Debt Service 0 0 0 0 Other 0 0 0 0 Transfers 0 290,000 0.00%0 0 TOTAL EXPENDITURES $2,307,046 $9,466,133 24.37%$1,569,236 $10,401,766 15.09% SURPLUS / (DEFICIT)($2,093,133)($2,003,910)($1,233,813)($2,756,766) ENDING FUND BALANCE $10,429,289 $9,284,699 CAPITAL IMPROVEMENTS FUND | Financial Summary For the Period Ending May 31, 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.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 750,000 0 Charges for Services 0 0 0 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 77,762 90,688 85.75%4,617 0 Miscellaneous Revenue 0 0 0 0 Other Financing Sources 1,000,000 2,037,500 49.08%2,000,000 1,000,000 200.00% Transfers In 0 2,000,000 0.00%0 0 TOTAL REVENUE $1,077,762 $4,128,188 26.11%$2,754,617 $1,000,000 275.46% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 43,602 71,534 60.95%0 0 Services 111,680 261,928 42.64%6,294 0 Capital Outlay 2,817,429 6,884,236 40.93%59,127 1,000,000 5.91% Debt Service 0 0 0 0 Other 0 0 0 0 Transfers 0 637,500 0.00%0 637,500 0.00% TOTAL EXPENDITURES $2,972,711 $7,855,198 37.84%$65,421 $1,637,500 4.00% SURPLUS / (DEFICIT)($1,894,949)($3,727,010)$2,689,195 ($637,500) ENDING FUND BALANCE $4,462,946 $5,320,080 CROWN CONSTRUCTION FUND | Financial Summary For the Period Ending May 31, 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 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 14,226 35,236 40.37%2,613 30,000 8.71% Miscellaneous Revenue 0 0 0 0 Other Financing Sources 93,780 168,415 55.68%49,929 125,000 39.94% Transfers In 0 0 0 0 TOTAL REVENUE $108,006 $203,651 53.03%$52,542 $155,000 33.90% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 0 0 Services 25 60 41.67%25 0 Capital Outlay 0 0 0 500,000 0.00% Debt Service 0 0 0 0 Other 0 0 0 0 Transfers 199,138 477,930 41.67%203,885 489,314 41.67% TOTAL EXPENDITURES $199,163 $477,990 41.67%$203,910 $989,314 20.61% SURPLUS / (DEFICIT)($91,156)($274,339)($151,368)($834,314) ENDING FUND BALANCE $2,836,649 $2,502,100 SPECIAL ASSESSMENT FUND | Financial Summary For the Period Ending May 31, 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 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,391,398 6,728,991 50.40%2,447,030 10,133,725 24.15% Licenses & Permits 75 75 100.00%150 0 Fines and Forefeitures 0 0 0 0 Interest earnings 12,333 53,584 23.02%5,575 20,000 27.88% Miscellaneous Revenue 21,750 29,350 74.11%4,358 11,400 38.22% Other Financing Sources 156,018 1,836,962 8.49%189,079 1,393,300 13.57% Transfers In 0 140,907 0.00%0 0 TOTAL REVENUE $3,581,574 $8,789,869 40.75%$2,646,191 $11,558,425 22.89% EXPENDITURES Salaries $508,288 $1,187,336 42.81%$506,190 $1,083,263 46.73% Benefits 173,857 385,740 45.07%151,741 358,532 42.32% Supplies 4,082 17,497 23.33%1,117 20,900 5.34% Services 2,139,787 3,968,340 53.92%1,566,536 4,457,583 35.14% Capital Outlay 263,452 343,622 76.67%108,783 1,750,000 6.22% Debt Service 0 0 0 47,164 0.00% Other 0 0 0 50,000 0.00% Transfers 1,451,072 4,982,573 29.12%1,451,620 3,483,892 41.67% TOTAL EXPENDITURES $4,540,538 $10,885,106 41.71%$3,785,986 $11,251,334 33.65% SURPLUS / (DEFICIT)($958,964)($2,095,238)($1,139,794)$307,091 ENDING FUND BALANCE $1,625,233 ($650,835) PARKING SYSTEM FUND | Financial Summary For the Period Ending May 31, 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 7,426,371 19,424,200 38.23%7,785,934 23,006,700 33.84% Licenses & Permits 29,741 61,117 48.66%30,507 50,000 61.01% Fines and Forefeitures 0 0 0 0 Interest earnings 44,977 71,543 62.87%27,949 70,000 39.93% Miscellaneous Revenue 275 7,384 3.72%3,312 5,000 66.24% Other Financing Sources 3,362,382 8,867,096 37.92%358,300 19,624,150 1.83% Transfers In 0 0 0 0 TOTAL REVENUE $10,863,746 $28,431,339 38.21%$8,206,002 $42,755,850 19.19% EXPENDITURES Salaries $1,807,756 $4,228,639 42.75%$1,883,406 $4,516,038 41.70% Benefits 608,726 1,347,367 45.18%584,605 1,421,880 41.11% Supplies 238,091 954,654 24.94%261,940 1,624,990 16.12% Services 1,202,602 3,613,124 33.28%848,686 4,673,720 18.16% Capital Outlay 2,510,326 8,688,604 28.89%2,668,698 24,092,200 11.08% Debt Service 135,695 4,161,316 3.26%135,695 2,318,294 5.85% Other 0 0 7,952 1,000 795.22% Transfers 1,869,206 4,486,095 41.67%2,403,840 5,769,212 41.67% TOTAL EXPENDITURES $8,372,403 $27,479,799 30.47%$8,794,822 $44,417,334 19.80% SURPLUS / (DEFICIT)$2,491,343 $951,541 ($588,820)($1,661,484) ENDING FUND BALANCE $12,449,350 $10,320,727 WATER FUND | Financial Summary For the Period Ending May 31, 2021 $0.0 $1.0 $2.0 $3.0 $4.0 $5.0 $6.0 $7.0 $8.0 $9.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 $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,901,071 10,242,066 38.09%3,814,449 10,375,408 36.76% Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 15,220 15,111 100.72%1,681 25,000 6.72% Miscellaneous Revenue 0 0 0 1,000 0.00% Other Financing Sources 0 1,964,331 0.00%(2,892)2,000,000 -0.14% Transfers In 0 0 0 0 TOTAL REVENUE $3,916,291 $12,221,507 32.04%$3,813,239 $12,401,408 30.75% EXPENDITURES Salaries $403,394 $977,605 41.26%$422,929 $1,070,069 39.52% Benefits 148,728 341,418 43.56%134,881 360,397 37.43% Supplies 3,789 52,733 7.19%20,241 112,600 17.98% Services 363,045 2,514,268 14.44%115,247 1,368,350 8.42% Capital Outlay 0 462,137 0.00%13,489 3,343,000 0.40% Debt Service 2,613,932 1,386,811 188.49%2,613,932 5,195,191 50.31% Other 0 0 0 0 Transfers 476,704 1,644,089 29.00%494,850 1,187,630 41.67% TOTAL EXPENDITURES $4,009,593 $7,379,059 54.34%$3,815,569 $12,637,237 30.19% SURPLUS / (DEFICIT)($93,302)$4,842,448 ($2,331)($235,829) ENDING FUND BALANCE ($33,804)$4,899,615 SEWER FUND | Financial Summary For the Period Ending May 31, 2021 ($0.5) $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 $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 1,609,905 4,247,762 37.90%1,684,910 4,516,450 37.31% Licenses & Permits 96,660 299,838 32.24%77,574 297,000 26.12% Fines and Forefeitures 0 0 0 0 Interest earnings 0 0 0 0 Miscellaneous Revenue 0 0 0 0 Other Financing Sources 51,165 71,739 71.32%72,721 122,000 59.61% Transfers In 0 0 0 0 TOTAL REVENUE $2,423,731 $5,951,839 40.72%$2,485,205 $6,267,950 39.65% EXPENDITURES Salaries $380,159 $1,043,606 36.43%$482,597 $1,161,525 41.55% Benefits 125,631 316,616 39.68%149,613 342,727 43.65% Supplies 4,817 11,106 43.38%3,632 3,050 119.09% Services 1,347,811 3,440,354 39.18%1,286,879 3,677,326 34.99% Capital Outlay 124,090 391,359 31.71%192,793 505,000 38.18% Debt Service 0 0 0 0 Other 6,389 7,243 88.20%7,409 10,000 74.09% Transfers 134,318 322,362 41.67%125,835 302,000 41.67% TOTAL EXPENDITURES $2,123,214 $5,532,647 38.38%$2,248,759 $6,001,628 37.47% SURPLUS / (DEFICIT)$300,517 $419,192 $236,446 $266,322 ENDING FUND BALANCE ($269,001)$86,121 SOLID WASTE FUND | Financial Summary For the Period Ending May 31, 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.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 1,279,173 3,070,014 41.67%1,294,765 3,127,440 41.40% 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%1,578 69,000 2.29% Transfers In 0 0 0 0 TOTAL REVENUE $1,291,123 $3,084,468 41.86%$1,296,343 $3,197,440 40.54% EXPENDITURES Salaries $332,973 $808,827 41.17%$353,762 $846,619 41.79% Benefits 122,384 287,456 42.57%121,891 301,548 40.42% Supplies 593,731 1,203,372 49.34%625,271 1,963,708 31.84% Services 56,598 121,071 46.75%23,505 70,799 33.20% 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,105,690 $2,420,731 45.68%$1,144,354 $3,182,673 35.96% SURPLUS / (DEFICIT)$185,432 $663,737 $151,990 $14,767 ENDING FUND BALANCE $261,376 $891,670 FLEET SERVICES FUND | Financial Summary For the Period Ending May 31, 2021 $0.0 $0.2 $0.4 $0.6 $0.8 $1.0 $1.2 $1.4 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 0 Other Taxes 0 0 0 0 --0 0 0 0 Intergovernmental 0 0 0 0 Charges for Services 616,427 1,479,425 41.67%93,695 224,885 41.66% 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%63,090 1,060,217 5.95% Transfers In 0 0 0 0 TOTAL REVENUE $630,208 $2,298,178 27.42%$156,945 $1,285,102 12.21% 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,295,405 648,105 199.88%854,331 1,600,000 53.40% Debt Service 0 1,532,789 0.00%0 0 Other 0 0 0 0 Transfers 0 0 0 0 TOTAL EXPENDITURES $1,331,113 $2,216,620 60.05%$854,401 $1,600,000 53.40% SURPLUS / (DEFICIT)($700,905)$81,558 ($697,457)($314,898) ENDING FUND BALANCE ($258,919)($173,913) EQUIPMENT REPLACEMENT FUND | Financial Summary For the Period Ending May 31, 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.0 $0.2 $0.4 $0.6 $0.8 $1.0 $1.2 $1.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 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,350,945 3,353,241 40.29%1,467,130 3,253,500 45.09% Transfers In 6,733,793 15,723,505 42.83%7,154,713 18,094,686 39.54% TOTAL REVENUE $8,085,034 $19,324,009 41.84%$8,622,674 $21,348,186 40.39% EXPENDITURES Salaries $182,551 $484,825 37.65%$229,595 $497,615 46.14% Benefits 5,889,460 13,546,217 43.48%5,712,656 15,011,272 38.06% Supplies 0 0 0 200 0.00% Services 2,138,360 4,156,988 51.44%1,824,347 4,709,000 38.74% Capital Outlay 0 0 0 0 Debt Service 0 0 0 0 Other 0 0 0 0 Transfers 0 0 0 0 TOTAL EXPENDITURES $8,210,371 $18,188,029 45.14%$7,766,598 $20,218,087 38.41% SURPLUS / (DEFICIT)($125,337)$1,135,980 $856,076 $1,130,099 ENDING FUND BALANCE ($9,725,006)($7,607,614) INSURANCE FUND | Financial Summary For the Period Ending May 31, 2021 $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 Revenues by Source Prior YTD Current YTD $0.0 $1.0 $2.0 $3.0 $4.0 $5.0 $6.0 $7.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%620,938 2,500,000 24.84% Miscellaneous Revenue 0 0 0 0 Other Financing Sources 703,933 12,621,341 5.58%12,277,897 11,815,000 103.92% Transfers In 0 0 0 0 TOTAL REVENUE $703,933 $13,959,721 5.04%$12,898,834 $14,315,000 90.11% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 4,172,997 10,314,909 40.46%4,472,952 10,805,300 41.40% 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 $4,172,997 $10,373,329 40.23%$4,571,013 $11,030,300 41.44% SURPLUS / (DEFICIT)($3,469,065)$3,586,392 $8,327,822 $3,284,700 ENDING FUND BALANCE ($7,055,457)$8,327,822 FIRE PENSION FUND | Financial Summary For the Period Ending May 31, 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 $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 0 1,641,885 0.00%1,025,926 1,500,000 68.40% Miscellaneous Revenue 0 0 0 0 Other Financing Sources 978,965 21,084,778 4.64%19,049,630 18,214,700 104.58% Transfers In 0 0 0 0 TOTAL REVENUE $978,965 $22,726,663 4.31%$20,075,556 $19,714,700 101.83% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 5,508,371 13,439,772 40.99%5,915,062 14,326,000 41.29% Supplies 0 0 0 0 Services 0 0 0 0 Capital Outlay 0 0 0 0 Debt Service 0 0 0 0 Other 0 183,143 0.00%154,571 375,000 41.22% Transfers 0 0 0 0 TOTAL EXPENDITURES $5,508,371 $13,622,915 40.43%$6,069,633 $14,701,000 41.29% SURPLUS / (DEFICIT)($4,529,405)$9,103,748 $14,005,923 $5,013,700 ENDING FUND BALANCE ($13,633,154)$14,005,923 POLICE PENSION FUND | Financial Summary For the Period Ending May 31, 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 Mi l l i o n s Expenditures by Object Prior YTD Current YTD