Loading...
HomeMy WebLinkAbout2020.05 May Monthly Report To: Erika Storlie, City Manager From: Hitesh Desai, CFO/City Treasurer Kate Lewis-Lakin, Budget Coordinator Subject: May 2020 Monthly Financial Report Date: July 31, 2020 Please find attached the unaudited financial statements as of May 31, 2020. A summary by fund for revenues, expenditures, fund and cash balances is as follows: May 2020 Revenue Expense Net Fund Balance Cash Balance 100 GENERAL FUND 45,150,341 47,941,615 (2,791,274) 12,877,460 10,053,107 175 GENERAL ASSISTANCE FUND 509,500 484,187 25,313 388,352 388,352 176 HEALTH AND HUMAN SERVICES 2,019,598 581,579 1,438,018 1,468,777 1,468,777 177 REPARATIONS FUND 5,500 - 5,500 6,835 6,835 180 GOOD NEIGHBOR FUND 1,001,410 364,880 636,531 889,075 889,075 185 LIBRARY FUND 3,842,916 3,141,060 701,856 2,771,499 2,770,967 186 LIBRARY DEBT SERVICE FUND 240,000 - 240,000 241,144 241,144 187 LIBRARY CAPITAL IMPROVEMENT FD - - - 1,378,484 1,378,484 200 MOTOR FUEL TAX FUND 2,078,082 844,098 1,233,983 3,903,015 3,576,046 205 EMERGENCY TELEPHONE (E911) FUND 572,811 531,737 41,074 1,312,034 928,285 210 SPECIAL SERVICE AREA (SSA) #4 - - - (226,193) (226,193) 215 CDBG FUND 107,625 340,448 (232,823) (169,526) (169,526) 220 CDBG LOAN FUND 21,930 61,694 (39,764) 187,621 187,621 235 NEIGHBORHOOD IMPROVEMENT 278 43 234 172,099 172,099 240 HOME FUND 89,166 65,758 23,409 30,934 30,934 250 AFFORDABLE HOUSING FUND 85,428 79,474 5,954 3,931,557 4,060,058 320 DEBT SERVICE FUND 7,062,119 5 7,062,114 7,479,545 7,502,568 330 HOWARD-RIDGE TIF FUND 404,530 229,133 175,397 2,300,162 2,300,851 335 WEST EVANSTON TIF FUND 367,115 56,259 310,856 1,021,332 1,021,332 340 DEMPSTER-DODGE TIF FUND 109,618 69,114 40,505 148,308 148,308 345 CHICAGO-MAIN TIF 343,474 108,596 234,879 921,632 921,632 350 SPECIAL SERVICE AREA (SSA) #6 124,232 0 124,231 129,573 129,573 415 CAPITAL IMPROVEMENTS FUND 213,913 2,307,046 (2,093,133) 10,567,113 11,485,647 416 CROWN CONSTRUCTION FUND 1,077,762 2,972,711 (1,894,949) 5,751,202 9,611,455 417 CROWN COMMUNITY CTR MAINTENANCE 72,917 - 72,917 72,917 72,917 420 SPECIAL ASSESSMENT FUND 108,006 199,163 (91,156) 2,836,649 2,833,466 505 PARKING SYSTEM FUND 3,581,574 4,540,538 (958,964) 1,417,026 1,569,307 510 WATER FUND 10,863,746 8,372,403 2,491,343 5,560,041 5,873,323 515 SEWER FUND 3,916,291 4,009,593 (93,302) 4,884,670 3,527,638 520 SOLID WASTE FUND 2,423,731 2,123,214 300,517 (239,014) (861,290) 600 FLEET SERVICES FUND 1,291,123 1,105,690 185,432 300,907 (900,202) 601 EQUIPMENT REPLACEMENT FUND 630,208 1,331,113 (700,905) 204,045 (68,919) 605 INSURANCE FUND 8,085,034 8,210,371 (125,337) (11,718,435) (6,512,868) Grand Total 96,399,977 90,071,521 6,328,456 60,800,840 64,410,802 Memorandum Please note that the attached supporting documents have been updated to show further fund analysis. Included above are ending fund and cash balances as of May 31, 2020. 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. General Fund The unaudited financial statements show the General Fund as of May 31, 2020 with a fund balance of $12,877,460 and cash balance of $ 10,053,107. The attached financials show year-end General Fund revenues at 38.00% of budget and expenses at 40.91 % of budget. These are near target of 41%. As of May 31, 47.51% of property tax revenue to the General Fund has been received. The second installment of property taxes is received in July and August. Expenses are near target, as January through May are typically slower months for program spending and overtime. The mild winter weather in these months helped keep costs low. Staff continues to monitor Police and Fire overtime expenses. Through May, Police had spent 29% of budget for overtime, and Fire had spent 104% of budget. For Police, this is below target of 41%, as January through May tend to be slower months. May also saw the start of the pandemic which reduced overtime .Overtime is higher in Fire Department due to continuing vacancies in the department that require hirebacks to maintain minimum staffing. Overtime is typically higher in the summer months. Overtime Expenses 2019 Actual 2020 Budget 2020 YTD % Budget Enterprise Funds Parking fund revenues through May 31, 2020 are at 27.52% of budget and expenses are at 33.98%. The 2019 ending fund balance was $2,375,989. Through May 31, 2020, the Water Fund appears low on revenue and expenses. This is because capital projects funded with IEPA loan have been delayed. These projects are budgeted in Other Revenue and expe nses in Capital Outlay. The 2019 ending fund balance was $3,068,697. The Water Fund revenues reflect payment from the Village of Skokie at the rate of $0.81 per 1000 gallons against the billed rate of $2.06 per 1000 gallons. This issue is currently being challenged in the court. Through May 31, 2020, the Sewer Fund also appears low on expenses due to capital projects. Majority of work will be performed later in the year on these projects. These projects are primarily funded through IEPA loan financing , budgeted as Other Revenue. The 2019 ending fund balance was $4,997,971. Through May 31, 2020, the Solid Waste Fund has a negative fund balance of $239,014, and a negative cash balance of $861,290 . The fund ended 2019 with a surplus of $559,718, bringing it to an ending balance of negative $539,532. Other Funds Through May 31, 2020, the SSA #4 Fund is showing a negative fund balance of $226,193 and negative cash balance of $226,193. Through May 31, 2020, the Capital Improvements Fund is showing a fund balance of $10,567,113 and a cash balance of $ 11,485,647. The fund continues to spend down 2019B bond proceeds received in June 2019. Through May 31, 2020, the Crown Construction fund is showing fund balance of $5,751,202 and cash balance of $9,611,455. The fund continues to spend down balances from bond proceeds and gifts from the Friends of Robert Crown in 2019. Through May 31, 2020, the Insurance Fund is showing a negative fund balance of $11,718,435 and a negative cash balance of $ 6,512,868. Fund balance is significantly lower than cash balance due to accrued liabilities for pending litigation s. If there are any questions on the attached report, please contact me by phone at (847) 448-8082 or by email: hdesai@cityofevanston.org. Detailed fund summary reports can be found at: http://www.cityofevanston.org/city-budget/financial-reports/. CERTIFICATION OF ATTACHED FINANCIAL REPORTS As required per Illinois Statute 65 ILCS 5/3.1-35-45 I, Hitesh Desai, Treasurer of the City of Evanston, hereby affirm that I have reviewed the May 31, 2020 year-to-date financial information and reports which to the best of my knowledge appear accurate and complete. January February March April May*June July August September October*November*December 2020 Unreserved Fund Balance 15,446,541$ 15,394,886$ 17,267,642$ 16,294,341$ 12,877,460$ 2019 Unreserved Fund Balance 14,074,270$ 15,248,569$ 19,960,779$ 18,594,617$ 17,601,206$ 16,913,780$ 19,181,628$ 21,272,425$ 20,103,645$ 19,396,425$ 16,634,199$ 15,668,734$ 2020 Cash Balance 10,333,157$ 11,915,776$ 13,307,450$ 13,351,609$ 10,053,107$ 2019 Cash Balance 10,603,771$ 14,634,340$ 17,403,563$ 16,875,201$ 16,013,733$ 10,547,544$ 13,286,786$ 15,561,077$ 15,627,196$ 13,669,397$ 11,039,528$ 11,290,625$ *In 2020, May and October have 3 paydays. In 2019, May and November had 3 paydays. 2020 and 2019 Fund and Cash Balance - General Fund $- $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 2020 Unreserved Fund Balance 2019 Unreserved Fund Balance 2020 Cash Balance 2019 Cash Balance Pension Property Tax $9,763,601 Property Taxes $4,186,342 Sales Tax - Basic $3,741,902 State Income Tax $3,207,643 Building Permits $2,662,874 Sales Tax - Home Rule $2,445,342 Recreation Program Fees $1,393,649 Parking Tax $1,235,794 Electric Utility Tax $1,190,217 Liquor Tax $1,140,828 GENERAL FUND Revenue Dashboard Summary For the Period Ending May 31, 2020 Top 10 GENERAL FUND Sources of Revenue (YTD) $0.0 $20.0 $40.0 $60.0 $80.0 $100.0 $120.0 $140.0 100 GENERAL FUND 505 PARKING SYSTEM FUND 510 WATER FUND 515 SEWER FUND 520 SOLID WASTE FUND Mi l l i o n s Revenues by Fund Budget Current YTD ($2.0) $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 $17,812,235 Fire Mgmt & Support $11,838,040 Public Works Agency $4,774,108 Administrative Services $3,772,020 City Manager'S Office $3,714,962 Parks, Rec. And Community Serv.$3,543,282 Community Development $1,307,834 Health $696,384 GENERAL FUND Expenditure Dashboard Summary For the Period Ending May 31, 2020 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 $140.0 100 GENERAL FUND 505 PARKING SYSTEM FUND 510 WATER FUND 515 SEWER FUND 520 SOLID WASTE 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 $16,012,252 $29,888,938 53.57%$13,949,944 $29,362,987 47.51% Sales & Use Taxes 7,258,465 19,418,652 37.38%7,087,397 20,150,000 35.17% Business & Occupation Taxes 12,537,917 27,459,110 45.66%9,799,990 26,935,000 36.38% Other Taxes 2,598,178 6,760,120 38.43%1,893,353 8,155,000 23.22% Intergovernmental 695,584 1,236,263 56.27%473,036 1,006,967 46.98% Charges for Services 4,663,598 9,222,780 50.57%2,880,863 10,187,350 28.28% Licenses & Permits 3,996,817 7,667,185 52.13%3,889,212 7,663,550 50.75% Fines and Forefeitures 1,772,915 5,108,236 34.71%797,528 4,670,500 17.08% Interest earnings 78,781 210,194 37.48%52,092 55,000 94.71% Miscellaneous Revenue (28,324)1,646 -1720.46%116,649 227,100 51.36% Other Financing Sources 268,061 1,421,294 18.86%468,983 1,428,000 32.84% Transfers In 3,673,755 8,817,013 41.67%3,741,293 8,979,103 41.67% TOTAL REVENUE $53,527,999 $117,211,433 45.67%$45,150,341 $118,820,557 38.00% EXPENDITURES Salaries $24,427,656 $59,109,976 41.33%$24,157,678 $60,092,848 40.20% Benefits 5,526,004 12,954,271 42.66%5,583,946 13,385,615 41.72% Supplies 1,303,948 3,086,662 42.24%919,333 2,574,115 35.71% Services 2,209,565 8,310,119 26.59%2,461,843 9,156,947 26.88% Capital Outlay 90,104 180,037 50.05%27,556 350,000 7.87% Debt Service 0 0 0 0 Other 287,672 957,607 30.04%182,657 951,377 19.20% Transfers 15,670,819 30,576,390 51.25%14,608,602 30,689,590 47.60% TOTAL EXPENDITURES $49,515,769 $115,175,062 42.99%$47,941,615 $117,200,492 40.91% SURPLUS / (DEFICIT)$4,012,230 $2,036,371 ($2,791,274)$1,620,065 ENDING FUND BALANCE $17,644,593 $12,877,460 GENERAL FUND | Financial Summary For the Period Ending May 31, 2020 ($2.0) $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 $506,120 $903,910 55.99%$486,931 $1,080,000 45.09% Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 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 6,828 15,380 44.39%1,980 1,000 198.00% Miscellaneous Revenue 0 0 0 0 Other Financing Sources 8,431 21,723 38.81%20,589 27,500 74.87% Transfers In 0 0 0 0 TOTAL REVENUE $521,379 $941,013 55.41%$509,500 $1,108,500 45.96% EXPENDITURES Salaries $124,877 $297,156 42.02%$134,696 $337,275 39.94% Benefits 37,109 88,763 41.81%43,576 105,591 41.27% Supplies 578 1,557 37.10%87 4,232 2.05% Services 322,181 786,872 40.94%305,918 861,750 35.50% Capital Outlay 0 0 0 0 Debt Service 0 0 0 0 Other 728 5,319 13.69%(90)7,000 -1.29% Transfers 0 0 0 0 TOTAL EXPENDITURES $485,473 $1,179,667 41.15%$484,187 $1,315,848 36.80% SURPLUS / (DEFICIT)$35,906 ($238,654)$25,313 ($207,348) ENDING FUND BALANCE $637,600 $388,352 GENERAL ASSISTANCE FUND | Financial Summary For the Period Ending May 31, 2020 $0.0 $0.1 $0.2 $0.3 $0.4 $0.5 $0.6 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 $0 $0 $1,947,000 $3,110,000 62.60% Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 0 0 0 0 Intergovernmental 0 0 29,167 155,000 18.82% Charges for Services 0 0 0 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 35 163 21.71%164 0 Miscellaneous Revenue 0 0 0 0 Other Financing Sources 0 70,006 0.00%1,600 8,000 20.00% Transfers In 345,196 828,471 41.67%41,667 100,000 41.67% TOTAL REVENUE $345,232 $898,640 38.42%$2,019,598 $3,373,000 59.88% EXPENDITURES Salaries $0 $0 $272,012 $1,751,689 15.53% Benefits 0 1,342 0.00%75,593 418,135 18.08% Supplies 0 0 891 15,410 5.78% Services 7 7,904 0.09%1,055 770,833 0.14% Capital Outlay 0 0 0 0 Debt Service 0 0 0 0 Other 255,760 872,281 29.32%230,632 408,333 56.48% Transfers 0 0 1,397 3,352 41.67% TOTAL EXPENDITURES $255,767 $881,526 29.01%$581,579 $3,367,752 17.27% SURPLUS / (DEFICIT)$89,465 $17,114 $1,438,018 $5,248 ENDING FUND BALANCE $103,109 $1,468,777 HUMAN SERVICES FUND | Financial Summary For the Period Ending May 31, 2020 $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 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 250,000 0.00% Other Taxes 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 1,335 0.00%5,500 0 Transfers In 0 0 0 0 TOTAL REVENUE $0 $1,335 0.00%$5,500 $250,000 2.20% 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 250,000 0.00% Transfers 0 0 0 0 TOTAL EXPENDITURES $0 $0 $0 $250,000 0.00% SURPLUS / (DEFICIT)$0 $1,335 $5,500 $0 ENDING FUND BALANCE $0 $6,835 REPARATIONS FUND | Financial Summary For the Period Ending May 31, 2020 $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 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,507 4,307 58.21%1,410 2,000 70.50% 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,002,507 $1,004,307 99.82%$1,001,410 $1,002,000 99.94% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 0 0 Services 420 583 71.99%245 0 Capital Outlay 0 0 0 0 Debt Service 0 0 0 0 Other 92,345 125,781 73.42%2,134 125,000 1.71% Transfers 262,500 630,000 41.67%362,500 875,000 41.43% TOTAL EXPENDITURES $355,265 $756,364 46.97%$364,880 $1,000,000 36.49% SURPLUS / (DEFICIT)$647,242 $247,943 $636,531 $2,000 ENDING FUND BALANCE $651,844 $889,075 GOOD NEIGHBOR FUND | Financial Summary For the Period Ending May 31, 2020 $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 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,665,950 $6,739,362 54.40%$3,639,099 $7,252,000 50.18% Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 0 0 0 0 Intergovernmental 24,138 300,330 8.04%25,920 108,000 24.00% Charges for Services 182 445 40.95%65 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 37,309 84,204 44.31%10,627 60,000 17.71% Interest earnings 41,696 108,898 38.29%40,309 15,000 268.73% Miscellaneous Revenue 6,613 19,261 34.33%13,708 10,000 137.08% Other Financing Sources 194,616 508,483 38.27%84,023 787,000 10.68% Transfers In 62,500 195,000 32.05%29,167 275,948 10.57% TOTAL REVENUE $4,033,006 $7,955,983 50.69%$3,842,916 $8,507,948 45.17% EXPENDITURES Salaries $1,695,441 $4,079,134 41.56%$1,785,676 $4,575,345 39.03% Benefits 437,711 1,062,045 41.21%510,592 1,309,669 38.99% Supplies 291,685 902,432 32.32%349,669 1,172,450 29.82% Services 317,065 905,743 35.01%347,466 1,048,440 33.14% Capital Outlay 5 2,353 0.21%0 12,500 0.00% Debt Service 0 0 0 0 Other 0 0 0 0 Transfers 153,242 437,787 35.00%147,656 354,375 41.67% TOTAL EXPENDITURES $2,895,149 $7,389,495 39.18%$3,141,060 $8,472,778 37.07% SURPLUS / (DEFICIT)$1,137,857 $566,488 $701,856 $35,170 ENDING FUND BALANCE $2,641,011 $2,771,499 LIBRARY FUND | Financial Summary For the Period Ending May 31, 2020 $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.2 $0.4 $0.6 $0.8 $1.0 $1.2 $1.4 $1.6 $1.8 $2.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 $175,000 $350,000 50.00%$240,000 $480,144 49.99% Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 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 $175,000 $350,000 50.00%$240,000 $480,144 49.99% 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 353,438 0.00%0 480,144 0.00% Other 0 0 0 0 Transfers 0 0 0 0 TOTAL EXPENDITURES $0 $353,438 0.00%$0 $480,144 0.00% SURPLUS / (DEFICIT)$175,000 ($3,438)$240,000 $0 ENDING FUND BALANCE $179,582 $241,144 LIBRARY DEBT SERVICE FUND | Financial Summary For the Period Ending May 31, 2020 $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 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 2,221,274 0.00%0 543,000 0.00% Transfers In 0 0 0 0 TOTAL REVENUE $0 $2,221,274 0.00%$0 $543,000 0.00% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 0 0 Services 0 22,462 0.00%0 0 Capital Outlay 204,478 538,877 37.95%0 543,000 0.00% Debt Service 0 0 0 0 Other 0 0 0 0 Transfers 0 1,250,000 0.00%0 0 TOTAL EXPENDITURES $204,478 $1,811,339 11.29%$0 $543,000 0.00% SURPLUS / (DEFICIT)($204,478)$409,934 $0 $0 ENDING FUND BALANCE $764,072 $1,378,484 LIBRARY CAPITAL IMPROVEMENT FD | Financial Summary For the Period Ending May 31, 2020 $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 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 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 $451 $0 $0 $0 Benefits 161 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 $611 $0 $0 $0 SURPLUS / (DEFICIT)($611)$0 $0 $0 ENDING FUND BALANCE ($611)$0 NEIGHBORHOOD STABILIZATION FUND | Financial Summary For the Period Ending May 31, 2020 $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 Intergovernmental 775,791 2,443,580 31.75%2,064,209 3,220,400 64.10% Charges for Services 0 0 0 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 16,788 47,204 35.56%13,872 12,000 115.60% Miscellaneous Revenue 0 0 0 0 Other Financing Sources 0 0 0 0 Transfers In 0 0 0 0 TOTAL REVENUE $792,578 $2,490,784 31.82%$2,078,082 $3,232,400 64.29% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 331,446 625,000 53.03% Services 0 0 35,980 365,000 9.86% Capital Outlay 2,092 874,910 0.24%41,262 1,450,000 2.85% Debt Service 0 0 0 0 Other 0 0 0 0 Transfers 409,540 982,897 41.67%435,411 1,044,987 41.67% TOTAL EXPENDITURES $411,632 $1,857,806 22.16%$844,098 $3,484,987 24.22% SURPLUS / (DEFICIT)$380,946 $632,978 $1,233,983 ($252,587) ENDING FUND BALANCE $2,417,000 $3,903,015 MOTOR FUEL TAX FUND | Financial Summary For the Period Ending May 31, 2020 $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 477,064 1,468,418 32.49%508,043 1,321,600 38.44% Intergovernmental 0 0 60,205 0 Charges for Services 0 0 0 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 9,116 19,739 46.18%4,563 7,000 65.19% Miscellaneous Revenue 0 0 0 240,821 0.00% Other Financing Sources 0 0 0 0 Transfers In 0 0 0 0 TOTAL REVENUE $486,181 $1,488,157 32.67%$572,811 $1,569,421 36.50% EXPENDITURES Salaries $195,479 $467,429 41.82%$204,810 $475,325 43.09% Benefits 61,739 146,014 42.28%66,478 159,656 41.64% Supplies 19,161 47,313 40.50%14,014 53,700 26.10% Services 52,677 221,545 23.78%63,839 320,300 19.93% Capital Outlay 2,478 4,698 52.75%66,668 534,163 12.48% Debt Service 0 0 0 0 Other 0 0 0 0 Transfers 38,443 92,263 41.67%115,929 278,230 41.67% TOTAL EXPENDITURES $369,977 $979,263 37.78%$531,737 $1,821,374 29.19% SURPLUS / (DEFICIT)$116,204 $508,895 $41,074 ($251,953) ENDING FUND BALANCE $878,269 $1,312,034 EMERGENCY TELEPHONE (E911) FUND | Financial Summary For the Period Ending May 31, 2020 $0.0 $0.1 $0.2 $0.3 $0.4 $0.5 $0.6 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 $197,686 $447,638 44.16%$0 $592,665 0.00% Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 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 37 63 58.20%0 0 Miscellaneous Revenue 0 0 0 0 Other Financing Sources 0 0 0 0 Transfers In 0 0 0 0 TOTAL REVENUE $197,722 $447,701 44.16%$0 $592,665 0.00% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 0 0 Services 131,250 447,058 29.36%0 592,665 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 $131,250 $447,058 29.36%$0 $592,665 0.00% SURPLUS / (DEFICIT)$66,472 $642 $0 $0 ENDING FUND BALANCE ($160,364)($226,193) SPECIAL SERVICE AREA (SSA) #9 | Financial Summary For the Period Ending May 31, 2020 $0.0 $0.1 $0.1 $0.2 $0.2 $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 Intergovernmental 71,769 1,840,947 3.90%107,625 1,963,875 5.48% 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 297 790 37.59%0 0 Transfers In 0 0 0 0 TOTAL REVENUE $72,066 $1,841,737 3.91%$107,625 $1,963,875 5.48% EXPENDITURES Salaries $133,681 $314,262 42.54%$137,625 $363,643 37.85% Benefits 43,612 103,484 42.14%46,714 127,739 36.57% Supplies 56,400 56,400 100.00%1,860 2,400 77.50% Services 1,509 8,547 17.65%1,626 59,050 2.75% Capital Outlay 5,804 593,562 0.98%98,648 0 Debt Service 0 0 0 0 Other 18,611 422,839 4.40%45,478 1,390,648 3.27% Transfers 22,636 342,700 6.61%8,498 20,395 41.66% TOTAL EXPENDITURES $282,252 $1,841,793 15.32%$340,448 $1,963,875 17.34% SURPLUS / (DEFICIT)($210,186)($56)($232,823)$0 ENDING FUND BALANCE ($146,833)($169,526) CDBG FUND | Financial Summary For the Period Ending May 31, 2020 $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 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,318 9,096 36.47%1,949 0 Miscellaneous Revenue 0 0 0 0 Other Financing Sources 82,891 47,376 174.96%19,981 175,000 11.42% Transfers In 0 0 0 0 TOTAL REVENUE $86,209 $56,473 152.66%$21,930 $175,000 12.53% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 0 0 Services 56 674 8.32%61,686 175,000 35.25% Capital Outlay 0 0 0 0 Debt Service 0 0 0 0 Other 0 1,607 0.00%9 0 Transfers 0 0 0 0 TOTAL EXPENDITURES $56 $2,281 2.46%$61,694 $175,000 35.25% SURPLUS / (DEFICIT)$86,152 $54,192 ($39,764)$0 ENDING FUND BALANCE $259,346 $187,621 CDBG LOAN FUND | Financial Summary For the Period Ending May 31, 2020 $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 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 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 394 904 43.59%278 0 Miscellaneous Revenue 0 0 0 0 Other Financing Sources 0 0 0 0 Transfers In 0 0 0 0 TOTAL REVENUE $394 $904 43.59%$278 $0 EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 0 0 Services 66 113 58.21%43 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 $66 $113 58.21%$43 $0 SURPLUS / (DEFICIT)$328 $791 $234 $0 ENDING FUND BALANCE $171,402 $172,099 NEIGHBORHOOD IMPROVEMENT | Financial Summary For the Period Ending May 31, 2020 $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 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 Intergovernmental 48,689 232,564 20.94%63,689 634,528 10.04% Charges for Services 0 0 0 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 78 5,071 1.53%67 150 44.60% Miscellaneous Revenue 0 0 0 0 Other Financing Sources 11,285 22,515 50.12%25,410 25,000 101.64% Transfers In 0 0 0 0 TOTAL REVENUE $60,052 $260,149 23.08%$89,166 $659,678 13.52% EXPENDITURES Salaries $10,800 $19,463 55.49%$325 $28,249 1.15% Benefits 2,626 5,436 48.31%754 7,470 10.09% Supplies 0 0 590 0 Services 56,371 220,288 25.59%63,716 622,565 10.23% Capital Outlay 0 0 0 0 Debt Service 0 0 0 0 Other 290 290 100.00%0 500 0.00% Transfers 373 14,471 2.57%373 894 41.67% TOTAL EXPENDITURES $70,459 $259,948 27.11%$65,758 $659,678 9.97% SURPLUS / (DEFICIT)($10,407)$201 $23,409 $0 ENDING FUND BALANCE ($3,083)$30,934 HOME FUND | Financial Summary For the Period Ending May 31, 2020 $0.0 $0.0 $0.0 $0.0 $0.0 $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 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 20,000 63,000 31.75%0 75,000 0.00% Intergovernmental 0 11,013 0.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 9,291 41,126 22.59%20,845 16,581 125.71% Miscellaneous Revenue 34 34 100.00%0 0 Other Financing Sources 272,083 2,737,500 9.94%64,583 130,600 49.45% Transfers In 0 0 0 0 TOTAL REVENUE $301,408 $2,852,672 10.57%$85,428 $222,181 38.45% EXPENDITURES Salaries $42,621 $97,710 43.62%$38,510 $107,570 35.80% Benefits 12,598 30,125 41.82%12,329 34,746 35.48% Supplies 0 50 0.00%2,048 0 Services 13,975 80,972 17.26%11,491 1,478,550 0.78% Capital Outlay 2,234 3,434 65.06%400 10,000 4.00% Debt Service 0 0 0 0 Other 16,596 68,148 24.35%14,697 77,500 18.96% Transfers 0 11,785 0.00%0 5,000 0.00% TOTAL EXPENDITURES $88,023 $292,224 30.12%$79,474 $1,713,366 4.64% SURPLUS / (DEFICIT)$213,384 $2,560,447 $5,954 ($1,491,185) ENDING FUND BALANCE $1,578,539 $3,931,557 AFFORDABLE HOUSING FUND | Financial Summary For the Period Ending May 31, 2020 $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 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,895,214 $10,581,996 55.71%$5,669,667 $12,521,931 45.28% Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 0 0 0 0 Intergovernmental 36,440 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 77,641 152,581 50.88%9,512 1,500 634.15% Miscellaneous Revenue 0 0 0 0 Other Financing Sources (4,815)135,486 -3.55%0 0 Transfers In 1,636,145 4,390,093 37.27%1,382,939 3,319,053 41.67% TOTAL REVENUE $7,640,625 $15,260,156 50.07%$7,062,119 $15,842,484 44.58% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 0 0 Services 36 7,034 0.51%5 0 Capital Outlay 0 0 0 0 Debt Service 0 15,253,672 0.00%0 15,840,981 0.00% Other 0 0 0 0 Transfers 0 0 0 0 TOTAL EXPENDITURES $36 $15,260,706 0.00%$5 $15,840,981 0.00% SURPLUS / (DEFICIT)$7,640,590 ($550)$7,062,114 $1,503 ENDING FUND BALANCE $8,058,570 $7,479,545 DEBT SERVICE FUND | Financial Summary For the Period Ending May 31, 2020 ($1.0) $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.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 $346,849 $680,510 50.97%$373,853 $695,000 53.79% Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 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 37,579 0.00%12,703 400 3175.66% Miscellaneous Revenue 0 0 0 0 Other Financing Sources 19,289 50,375 38.29%17,974 5,366 334.96% Transfers In 0 0 0 0 TOTAL REVENUE $366,138 $768,465 47.65%$404,530 $700,766 57.73% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 0 0 Services 941 593,648 0.16%156,426 368,000 42.51% Capital Outlay 2,438 12,188 20.00%0 0 Debt Service 794 49,843 1.59%0 0 Other 0 1,771 0.00%576 0 Transfers 144,260 203,112 71.02%72,130 173,113 41.67% TOTAL EXPENDITURES $148,433 $860,562 17.25%$229,133 $541,113 42.34% SURPLUS / (DEFICIT)$217,705 ($92,097)$175,397 $159,653 ENDING FUND BALANCE $2,434,567 $2,300,162 HOWARD-RIDGE TIF FUND | Financial Summary For the Period Ending May 31, 2020 $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 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 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 $118,739 $710,020 16.72%$359,222 $722,135 49.74% Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 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,006 11,795 8.53%2,751 4,000 68.78% Miscellaneous Revenue 0 0 0 0 Other Financing Sources 5,141 11,311 45.45%5,141 11,000 46.74% Transfers In 0 0 0 0 TOTAL REVENUE $124,886 $733,126 17.03%$367,115 $737,135 49.80% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 0 0 Services 0 1,805 0.00%9 5,000 0.17% Capital Outlay 0 0 0 400,000 0.00% Debt Service 258,711 611,225 42.33%0 0 Other 0 0 0 200,000 0.00% Transfers 12,500 30,000 41.67%56,250 135,000 41.67% TOTAL EXPENDITURES $271,211 $643,031 42.18%$56,259 $740,000 7.60% SURPLUS / (DEFICIT)($146,325)$90,096 $310,856 ($2,865) ENDING FUND BALANCE $474,056 $1,021,332 WEST EVANSTON TIF FUND | Financial Summary For the Period Ending May 31, 2020 $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 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 $75,310 $122,797 61.33%$67,538 $122,797 55.00% Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 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 2,094 0.70%413 0 Miscellaneous Revenue 0 0 0 0 Other Financing Sources 0 0 0 0 Transfers In 0 0 41,667 100,000 41.67% TOTAL REVENUE $75,324 $124,891 60.31%$109,618 $222,797 49.20% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 0 0 Services 0 1,061 0.00%1 2,000 0.06% Capital Outlay 0 0 0 0 Debt Service 0 0 0 0 Other 0 0 0 0 Transfers 29,529 70,870 41.67%69,113 165,870 41.67% TOTAL EXPENDITURES $29,529 $71,931 41.05%$69,114 $167,870 41.17% SURPLUS / (DEFICIT)$45,795 $52,960 $40,505 $54,927 ENDING FUND BALANCE $100,638 $148,308 DEMPSTER-DODGE TIF FUND | Financial Summary For the Period Ending May 31, 2020 $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 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 $127,851 $603,848 21.17%$304,681 $607,043 50.19% Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 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 32 10,673 0.30%38,794 0 Miscellaneous Revenue 0 0 0 0 Other Financing Sources 0 0 0 0 Transfers In 0 0 0 0 TOTAL REVENUE $127,883 $614,522 20.81%$343,474 $607,043 56.58% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 0 0 Services 0 1,067 0.00%8 5,000 0.16% Capital Outlay 0 0 0 430,000 0.00% Debt Service 0 0 0 0 Other 0 0 0 0 Transfers 41,921 100,610 41.67%108,588 318,820 34.06% TOTAL EXPENDITURES $41,921 $101,677 41.23%$108,596 $753,820 14.41% SURPLUS / (DEFICIT)$85,962 $512,844 $234,879 ($146,777) ENDING FUND BALANCE $259,871 $921,632 CHICAGO-MAIN TIF | Financial Summary For the Period Ending May 31, 2020 $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 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 $123,936 $223,306 55.50%$124,104 $221,000 56.16% Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 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 2,304 0.00%127 500 25.50% Miscellaneous Revenue 0 0 0 0 Other Financing Sources 0 0 0 0 Transfers In 0 0 0 0 TOTAL REVENUE $123,936 $225,611 54.93%$124,232 $221,500 56.09% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 0 0 Services 0 223,368 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 $223,368 0.00%$0 $221,500 0.00% SURPLUS / (DEFICIT)$123,936 $2,243 $124,231 $0 ENDING FUND BALANCE $127,035 $129,573 SPECIAL SERVICE AREA (SSA) #6 | Financial Summary For the Period Ending May 31, 2020 $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 $0 $0 $0 Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 0 0 0 0 Intergovernmental 0 894,216 0.00%0 510,000 0.00% Charges for Services 290 84,261 0.34%0 0 Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 107,435 291,706 36.83%61,892 50,000 123.78% Miscellaneous Revenue 0 123,682 0.00%20,000 0 Other Financing Sources 0 8,352,155 0.00%(1,312)12,192,000 -0.01% Transfers In 0 198,181 0.00%133,333 320,000 41.67% TOTAL REVENUE $107,726 $9,944,202 1.08%$213,913 $13,072,000 1.64% EXPENDITURES Salaries $220,411 $517,558 42.59%$217,448 $510,746 42.57% Benefits 61,982 147,061 42.15%68,129 160,598 42.42% Supplies 0 0 0 0 Services 499,806 2,212,654 22.59%372,895 0 Capital Outlay 1,266,125 8,001,288 15.82%1,648,574 16,380,537 10.06% Debt Service 0 0 0 0 Other 0 0 0 0 Transfers 0 303,644 0.00%0 0 TOTAL EXPENDITURES $2,048,324 $11,182,204 18.32%$2,307,046 $17,051,881 13.53% SURPLUS / (DEFICIT)($1,940,598)($1,238,002)($2,093,133)($3,979,881) ENDING FUND BALANCE $11,957,650 $10,567,113 CAPITAL IMPROVEMENTS FUND | Financial Summary For the Period Ending May 31, 2020 ($0.0) $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.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 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 192,476 530,368 36.29%77,762 50,000 155.52% Miscellaneous Revenue 0 0 0 0 Other Financing Sources 5,003,840 21,732,046 23.03%1,000,000 1,000,000 100.00% Transfers In 0 1,000,000 0.00%0 3,000,000 0.00% TOTAL REVENUE $5,196,316 $23,262,413 22.34%$1,077,762 $4,050,000 26.61% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 289,642 0.00%43,602 0 Services 258,101 771,433 33.46%111,680 460,000 24.28% Capital Outlay 3,966,451 31,777,910 12.48%2,817,429 7,870,000 35.80% Debt Service 0 0 0 0 Other 0 0 0 0 Transfers 0 302,813 0.00%0 0 TOTAL EXPENDITURES $4,224,552 $33,141,798 12.75%$2,972,711 $8,330,000 35.69% SURPLUS / (DEFICIT)$971,764 ($9,879,384)($1,894,949)($4,280,000) ENDING FUND BALANCE $18,497,299 $5,751,202 CROWN CONSTRUCTION FUND | Financial Summary For the Period Ending May 31, 2020 $0.0 $1.0 $2.0 $3.0 $4.0 $5.0 $6.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 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 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 21,172 79,818 26.53%14,226 38,000 37.44% Miscellaneous Revenue 0 0 0 0 Other Financing Sources 102,211 519,922 19.66%93,780 375,000 25.01% Transfers In 0 0 0 0 TOTAL REVENUE $123,383 $599,740 20.57%$108,006 $413,000 26.15% EXPENDITURES Salaries $2,094 $900 232.56%$0 $0 Benefits 631 271 232.56%0 0 Supplies 0 0 0 0 Services 25 3,120 0.80%25 0 Capital Outlay 0 1,477 0.00%0 500,000 0.00% Debt Service 0 0 0 0 Other 0 0 0 0 Transfers 119,565 286,955 41.67%199,138 457,930 43.49% TOTAL EXPENDITURES $122,314 $292,724 41.78%$199,163 $957,930 20.79% SURPLUS / (DEFICIT)$1,068 $307,017 ($91,156)($544,930) ENDING FUND BALANCE $2,621,857 $2,836,649 SPECIAL ASSESSMENT FUND | Financial Summary For the Period Ending May 31, 2020 $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.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 Intergovernmental 0 0 0 0 Charges for Services 3,780,343 10,298,674 36.71%3,391,398 12,638,475 26.83% Licenses & Permits 1,030 79,053 1.30%75 0 Fines and Forefeitures 0 0 0 0 Interest earnings 49,371 113,897 43.35%12,333 20,000 61.66% Miscellaneous Revenue 2,850 9,800 29.08%21,750 11,400 190.79% Other Financing Sources 105,994 474,528 22.34%156,018 345,300 45.18% Transfers In 0 0 0 0 TOTAL REVENUE $3,939,588 $10,975,952 35.89%$3,581,574 $13,015,175 27.52% EXPENDITURES Salaries $582,859 $1,339,654 43.51%$508,288 $1,304,199 38.97% Benefits 176,483 425,577 41.47%173,857 458,584 37.91% Supplies 36,592 75,197 48.66%4,082 22,900 17.82% Services 1,220,288 4,422,839 27.59%2,139,787 4,884,583 43.81% Capital Outlay 459,839 50,801 905.18%263,452 1,575,000 16.73% Debt Service 0 2,695,297 0.00%0 34,354 0.00% Other 51,535 51,935 99.23%0 100,000 0.00% Transfers 1,456,990 3,496,775 41.67%1,451,072 4,982,574 29.12% TOTAL EXPENDITURES $3,984,585 $12,558,075 31.73%$4,540,538 $13,362,194 33.98% SURPLUS / (DEFICIT)($44,997)($1,582,122)($958,964)($347,019) ENDING FUND BALANCE $3,913,116 $1,417,026 PARKING SYSTEM FUND | Financial Summary For the Period Ending May 31, 2020 $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 Intergovernmental 0 0 0 0 Charges for Services 6,840,331 16,810,050 40.69%7,049,536 23,068,270 30.56% Licenses & Permits 30,961 51,805 59.76%29,741 50,000 59.48% Fines and Forefeitures 0 0 0 0 Interest earnings 235,327 734,037 32.06%421,813 70,000 602.59% Miscellaneous Revenue 2,073 3,795 54.62%275 5,000 5.50% Other Financing Sources 2,342,444 444,967 526.43%3,362,382 24,930,200 13.49% Transfers In 0 0 0 0 TOTAL REVENUE $9,451,136 $18,044,655 52.38%$10,863,746 $48,123,470 22.57% EXPENDITURES Salaries $1,852,434 $4,132,258 44.83%$1,807,756 $4,368,359 41.38% Benefits 552,602 1,247,387 44.30%608,726 1,416,147 42.98% Supplies 340,923 841,245 40.53%238,091 1,506,590 15.80% Services 737,792 2,360,881 31.25%1,202,602 4,292,620 28.02% Capital Outlay 4,069,763 168,327 2417.77%2,510,326 30,785,000 8.15% Debt Service 135,695 3,573,558 3.80%135,695 2,291,201 5.92% Other 1,000 1,000 100.00%0 1,000 0.00% Transfers 1,842,414 4,421,794 41.67%1,869,206 5,486,095 34.07% TOTAL EXPENDITURES $9,532,623 $16,746,450 56.92%$8,372,403 $50,147,012 16.70% SURPLUS / (DEFICIT)($81,487)$1,298,205 $2,491,343 ($2,023,542) ENDING FUND BALANCE $1,689,005 $5,560,041 WATER FUND | Financial Summary For the Period Ending May 31, 2020 $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 $4.0 $4.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 Intergovernmental 0 0 0 0 Charges for Services 4,449,572 10,780,345 41.27%3,901,071 10,410,200 37.47% Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 46,174 39,012 118.36%15,220 25,000 60.88% Miscellaneous Revenue 0 0 0 1,000 0.00% Other Financing Sources 0 14,594 0.00%0 3,600,000 0.00% Transfers In 0 0 0 0 TOTAL REVENUE $4,495,745 $10,833,951 41.50%$3,916,291 $14,036,200 27.90% EXPENDITURES Salaries $453,075 $994,663 45.55%$403,394 $1,026,571 39.30% Benefits 133,202 311,325 42.79%148,728 352,463 42.20% Supplies 3,906 59,363 6.58%3,789 110,100 3.44% Services 341,888 192,000 178.07%363,045 1,348,350 26.93% Capital Outlay 2,068 (10,482)-19.73%0 3,432,000 0.00% Debt Service 2,754,494 4,478,056 61.51%2,613,932 5,803,653 45.04% Other 0 0 0 0 Transfers 439,839 2,055,614 21.40%476,704 2,644,088 18.03% TOTAL EXPENDITURES $4,128,471 $8,080,540 51.09%$4,009,593 $14,717,225 27.24% SURPLUS / (DEFICIT)$367,274 $2,753,411 ($93,302)($681,025) ENDING FUND BALANCE $2,591,835 $4,884,670 SEWER FUND | Financial Summary For the Period Ending May 31, 2020 $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 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 $410,000 $820,000 50.00%$666,000 $1,332,500 49.98% Sales & Use Taxes 0 0 0 0 Business & Occupation Taxes 0 0 0 0 Other Taxes 0 0 0 0 Intergovernmental 0 0 0 0 Charges for Services 1,617,950 4,238,116 38.18%1,609,905 4,202,300 38.31% Licenses & Permits 103,367 300,733 34.37%96,660 297,000 32.55% Fines and Forefeitures 0 0 0 0 Interest earnings 0 0 0 0 Miscellaneous Revenue 0 0 0 0 Other Financing Sources 66,047 129,377 51.05%51,165 122,000 41.94% Transfers In 62,500 150,000 41.67%0 0 TOTAL REVENUE $2,259,864 $5,638,226 40.08%$2,423,731 $5,953,800 40.71% EXPENDITURES Salaries $385,910 $899,873 42.88%$380,159 $1,128,187 33.70% Benefits 108,917 260,763 41.77%125,631 347,135 36.19% Supplies 5,622 16,442 34.19%4,817 3,050 157.95% Services 1,279,278 3,417,010 37.44%1,347,811 3,553,351 37.93% Capital Outlay 28,395 121,728 23.33%124,090 357,520 34.71% Debt Service 0 27,449 0.00%0 0 Other 8,550 12,882 66.37%6,389 10,000 63.89% Transfers 134,318 322,362 41.67%134,318 438,462 30.63% TOTAL EXPENDITURES $1,950,989 $5,078,508 38.42%$2,123,214 $5,837,705 36.37% SURPLUS / (DEFICIT)$308,875 $559,718 $300,517 $116,095 ENDING FUND BALANCE ($790,374)($239,014) SOLID WASTE FUND | Financial Summary For the Period Ending May 31, 2020 $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 Intergovernmental 0 0 0 0 Charges for Services 1,229,340 2,950,416 41.67%1,279,173 3,070,012 41.67% 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 45 0.00%0 1,781 0.00% Other Financing Sources 4,733 17,725 26.70%11,950 80,000 14.94% Transfers In 0 0 0 0 TOTAL REVENUE $1,234,073 $2,968,186 41.58%$1,291,123 $3,152,793 40.95% EXPENDITURES Salaries $352,933 $793,057 44.50%$332,973 $820,402 40.59% Benefits 112,993 274,302 41.19%122,384 306,142 39.98% Supplies 737,205 1,793,632 41.10%593,731 1,963,708 30.24% Services 50,553 161,336 31.33%56,598 70,799 79.94% Capital Outlay 0 2,904 0.00%4 0 Debt Service 0 0 0 0 Other 76 23,583 0.32%0 0 Transfers 14,631 35,114 41.67%0 0 TOTAL EXPENDITURES $1,268,390 $3,083,928 41.13%$1,105,690 $3,161,051 34.98% SURPLUS / (DEFICIT)($34,317)($115,741)$185,432 ($8,258) ENDING FUND BALANCE $196,899 $300,907 FLEET SERVICES FUND | Financial Summary For the Period Ending May 31, 2020 $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 $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 Intergovernmental 0 0 0 0 Charges for Services 545,722 1,309,733 41.67%616,427 1,479,424 41.67% Licenses & Permits 0 0 0 0 Fines and Forefeitures 0 0 0 0 Interest earnings 1,706 3,103 54.96%400 0 Miscellaneous Revenue 0 0 0 0 Other Financing Sources 14,760 31,618 46.68%13,380 870,217 1.54% Transfers In 0 0 0 0 TOTAL REVENUE $562,188 $1,344,454 41.82%$630,208 $2,349,641 26.82% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 0 0 0 0 Supplies 0 0 0 0 Services 35,953 36,082 99.64%35,707 0 Capital Outlay 669,670 0 1,295,405 2,660,000 48.70% Debt Service 0 1,490,126 0.00%0 0 Other 0 0 0 0 Transfers 0 0 0 0 TOTAL EXPENDITURES $705,623 $1,526,208 46.23%$1,331,113 $2,660,000 50.04% SURPLUS / (DEFICIT)($143,435)($181,754)($700,905)($310,359) ENDING FUND BALANCE $943,269 $204,045 EQUIPMENT REPLACEMENT FUND | Financial Summary For the Period Ending May 31, 2020 $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 Intergovernmental 0 0 0 0 Charges for Services 0 101 0.00%296 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,370,335 2,956,066 46.36%1,350,945 3,254,356 41.51% Transfers In 6,747,650 16,254,253 41.51%6,733,793 17,768,792 37.90% TOTAL REVENUE $8,117,986 $19,210,420 42.26%$8,085,034 $21,023,148 38.46% EXPENDITURES Salaries $155,248 $421,753 36.81%$182,551 $490,402 37.22% Benefits 6,173,312 13,218,114 46.70%5,889,460 14,506,682 40.60% Supplies 0 0 0 200 0.00% Services 4,100,417 8,359,690 49.05%2,138,360 4,440,000 48.16% Capital Outlay 0 0 0 0 Debt Service 0 0 0 0 Other 0 0 0 0 Transfers 4,214 10,114 41.67%0 0 TOTAL EXPENDITURES $10,433,191 $22,009,670 47.40%$8,210,371 $19,437,284 42.24% SURPLUS / (DEFICIT)($2,315,205)($2,799,251)($125,337)$1,585,864 ENDING FUND BALANCE ($11,109,052)($11,718,435) INSURANCE FUND | Financial Summary For the Period Ending May 31, 2020 $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 $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 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 654,840 2,050,406 31.94%0 2,500,000 0.00% Miscellaneous Revenue 0 0 0 0 Other Financing Sources 12,618,506 21,901,059 57.62%703,933 11,378,503 6.19% Transfers In 0 0 0 20,000 0.00% TOTAL REVENUE $13,273,346 $23,951,465 55.42%$703,933 $13,898,503 5.06% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 4,008,613 9,722,353 41.23%4,172,997 9,976,897 41.83% Supplies 0 0 0 0 Services 0 0 0 0 Capital Outlay 0 0 0 0 Debt Service 0 0 0 0 Other 94,894 203,188 46.70%0 100,000 0.00% Transfers 0 0 0 0 TOTAL EXPENDITURES $4,103,506 $9,925,541 41.34%$4,172,997 $10,076,897 41.41% SURPLUS / (DEFICIT)$9,169,839 $14,025,923 ($3,469,065)$3,821,606 ENDING FUND BALANCE $84,950,957 $86,337,976 FIRE PENSION FUND | Financial Summary For the Period Ending May 31, 2020 $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 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 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,119,081 3,134,491 35.70%0 3,500,000 0.00% Miscellaneous Revenue 0 0 0 0 Other Financing Sources 15,196,108 34,340,999 44.25%978,965 17,343,068 5.64% Transfers In 0 0 0 0 TOTAL REVENUE $16,315,188 $37,475,490 43.54%$978,965 $20,843,068 4.70% EXPENDITURES Salaries $0 $0 $0 $0 Benefits 5,213,057 12,574,748 41.46%5,508,371 13,124,007 41.97% Supplies 0 0 0 0 Services 0 0 0 0 Capital Outlay 0 0 0 0 Debt Service 0 0 0 0 Other 90,970 345,959 26.29%0 325,000 0.00% Transfers 0 0 0 0 TOTAL EXPENDITURES $5,304,027 $12,920,706 41.05%$5,508,371 $13,449,007 40.96% SURPLUS / (DEFICIT)$11,011,161 $24,554,784 ($4,529,405)$7,394,061 ENDING FUND BALANCE $127,766,219 $136,780,436 POLICE PENSION FUND | Financial Summary For the Period Ending May 31, 2020 $0.0 $2.0 $4.0 $6.0 $8.0 $10.0 $12.0 $14.0 $16.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