Loading...
HomeMy WebLinkAbout2019.02 February Monthly Report To: Wally Bobkiewicz, City Manager From: Hitesh Desai, CFO/City Treasurer Kate Lewis-Lakin, Budget Coordinator Subject: February 2019 Monthly Financial Report Date: March 26, 2019 Please find attached the unaudited financial statements as of February 28, 2019. A summary by fund for revenues, expenditures, fund and cash balances is as follows: February 2019 Revenue Expense Net Fund Balance Cash Balance 100 GENERAL FUND 18,015,277 16,352,666 1,662,610 15,248,569 14,634,340 175 GENERAL ASSISTANCE FUND 144,029 180,300 (36,271) 565,516 565,517 176 HEALTH AND HUMAN SERVICES 138,114 23,896 114,218 127,863 127,863 180 GOOD NEIGHBOR FUND 1,001,095 105,223 895,871 900,474 900,474 185 LIBRARY FUND 1,149,385 896,113 253,272 1,815,001 1,757,072 186 LIBRARY DEBT SERVICE FUND - - - 4,581 4,582 187 LIBRARY CAPITAL IMPROVEMENT FD - 8,499 (8,499) 960,050 960,050 200 MOTOR FUEL TAX FUND 330,125 163,816 166,309 2,081,118 1,916,530 205 EMERGENCY TELEPHONE (E911) FUND 121,846 106,748 15,098 844,689 534,640 210 SPECIAL SERVICE AREA (SSA) #4 32,366 - 32,366 (194,470) (194,470) 215 CDBG FUND 297 67,073 (66,776) (3,335) (3,336) 220 CDBG LOAN FUND 48,414 56 48,358 221,552 221,552 235 NEIGHBORHOOD IMPROVEMENT 172 35 137 171,211 171,211 240 HOME FUND 4,600 4,763 (163) 7,169 7,169 250 AFFORDABLE HOUSING FUND 52,599 21,302 31,297 1,396,472 1,495,126 320 DEBT SERVICE FUND 2,283,851 12 2,283,840 2,701,826 2,777,695 330 HOWARD-RIDGE TIF FUND 14,208 58,123 (43,915) 2,172,948 2,175,217 335 WEST EVANSTON TIF FUND 21,569 109,866 (88,297) 532,083 532,083 340 DEMPSTER-DODGE TIF FUND 75,310 11,812 63,498 118,341 118,341 345 CHICAGO-MAIN TIF 110,020 16,768 93,252 267,161 267,161 350 SPECIAL SERVICE AREA (SSA) #6 29,481 - 29,481 32,580 32,580 415 CAPITAL IMPROVEMENTS FUND 46,719 59,872 (13,152) 14,941,923 9,414,032 416 CROWN CONSTRUCTION FUND 84,798 10 84,788 16,594,715 16,594,715 420 SPECIAL ASSESSMENT FUND 95,664 49,008 46,657 2,670,335 2,666,798 505 PARKING SYSTEM FUND 1,081,284 1,658,825 (577,540) 2,535,156 2,794,957 510 WATER FUND 3,120,595 1,814,660 1,305,935 8,140,775 5,768,205 515 SEWER FUND 2,113,996 750,878 1,363,118 11,765,264 4,012,955 520 SOLID WASTE FUND 648,709 647,869 840 (999,444) (1,385,515) 600 FLEET SERVICES FUND 491,736 322,688 169,048 414,067 (643,067) 601 EQUIPMENT REPLACEMENT FUND 219,086 162 218,923 556,129 980,412 605 INSURANCE FUND 2,934,051 4,586,537 (1,652,486) (10,437,433) (6,127,037) Grand Total 34,409,398 28,017,581 6,391,817 76,152,885 63,077,851 Memorandum Included above are the ending balances as of February 28, 2019 for both unreserved fund and cash balances. Of these two amounts, cash balance is the more meaningful metric since this represents liquid cash and/or invested assets which can be used (or easily sold) to support and fund current operations. While e nding fund balance is also an important measurement of the City’s financial health, it usually includes illiquid assets or future cash receipts or disbursements such as receivables (including property tax) due to the City and accounts payable/accrued expenses. 2018 actual numbers are preliminary and unaudited and are subject to change. Fund balance numbers are also subject to change as a result. The 2018 audit will be completed by June 30, 2019. General Fund The attached financials show General Fund revenues at 15.5% of budget and expenses at 14.3% of budget, both below target of 16.7%. Revenues are often below target at this point in the year because the first property tax installment is due in March. Property tax revenue received in February was much higher than January. Expenses are below target in all department s. Because of payroll timing, January included less than 1.5 pay periods. Additionally, January and February tend to have low programmatic spending. The department with the highest percent spending to budget is the Public Works Agency with 18%, due to the costs of snow removal operations in January and February. Enterprise Funds Parking fund revenues through February 28, 2019 are below target. This is because the budget includes an increase in all parking meter rates beginning March 1, 2019. Revenue is expected to rise as the new rates are implemented. Through February 28, 2019, the Water Fund appears low on revenue and expenses. This is because the budget includes multiple large capital projects, with IEPA loan funding budgeted in Other Revenue and expenses budgeted in Capital Outlay. The Water Fund revenues reflect payment from the Village of Skokie at the rate of $0 .78 per 1000 gallons against the billed rate of $2.06 per 1000 gallons. This issue is currently being challenged in the court. Through February 28, 2019, the Sewer Fund also appears low on expenses due to a delay in capital project spending until the summer months. These projects are also primarily funded through IEPA loan financing. Through February 28, 2019, the Solid Waste Fund has a negative fund balance of $999,444 and a negative cash balance of $1,385,515. The Solid Waste Fund received property tax revenue for the first time in 2018, and will receive $820,000 in property tax revenue in 2019. Other Funds Through February 28, 2019, funds receiving property tax revenue tend to show revenue lower than target. This includes the General Assistance Fun d, Library Fund, and TIF Funds. This is because the first installment of property taxes is not due until March. Balances in these funds are expected to increase with the receipt of the first installment in March. Property taxes received in February were su bstantially higher than what was received in January. Through February 28, 2019, the SSA #4 Fund is showing a negative fund and cash balance of $194,470. Through February 28, 2019, the CDBG Fund has higher monthly and year-to-date expenses than revenues. This is due to a delay in reimbursements from state and federal government agencies. As of February 28 funds the fund has a negative fund and cash balance of $3,335. Through February 28, 2019, the Capital Fund is showing a fund balance of $14,941,923 and a cash balance of $9,414,032. The fund continues to spend down balances from the 2018B General Obligation Bonds received in August 2018. Through February 28, 2019, the Crown Construction fund is showing fund and cash balances of $16,594,715. The fund continues to spend down balances from the 2018 A General Obligation Bond proceeds received in August 2018. Through February 28, 2019, the Insurance Fund is showing a negative fund balance of $10,437,433 and a negative cash balance of $6,127,037. Fund balance is significantly lower than cash balance due to accrued liabilities for pending litigation. 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 February 28, 2019 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 2019 Unreserved Fund Balance 14,074,270$ 15,222,908$ 2018 Unreserved Fund Balance 16,512,558$ 15,306,742$ 17,933,253$ 17,384,626$ 18,479,429$ 15,488,721$ 17,279,434$ 18,345,522$ 2019 Cash Balance 10,603,771$ 14,634,340$ 2018 Cash Balance 8,905,448$ 8,120,225$ 12,288,418$ 11,184,339$ 12,226,888$ 9,006,016$ 10,816,697$ 12,252,460$ 2018 v 2019 Fund and Cash Balance - General Fund $- $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000 $14,000,000 $16,000,000 $18,000,000 $20,000,000 2019 Unreserved Fund Balance 2018 Unreserved Fund Balance 2019 Cash Balance 2018 Cash Balance 2018 Actual 2019 Budget February 2019 YTD 2019 % YTD to Budget 100 GENERAL FUND Target = 16.7% Revenue Property Taxes 28,188,353 30,047,955 4,585,199 4,642,196 15.4% Other Taxes 50,095,876 50,796,300 4,393,448 7,491,431 14.7% Licenses, Permits and Fees 11,680,895 10,526,400 867,906 1,973,785 18.8% Charges for Services 10,396,458 8,900,909 1,079,067 1,674,170 18.8% Fines and Forfeitures 3,765,058 4,700,500 339,909 640,868 13.6% Interest Income 94,681 55,100 13,895 28,353 51.5% Intergovernmental Revenue 1,466,926 994,303 40,018 72,703 7.3% Other Revenue 1,906,784 988,300 (23,430) 22,268 2.3% Interfund Transfers 8,133,142 8,877,103 734,751 1,469,502 16.6% Revenue Total 115,728,174 115,886,870 12,030,763 18,015,277 15.5% Expenses 13 CITY COUNCIL 547,275 528,173 43,357 70,866 13.4% 14 CITY CLERK 217,953 180,704 16,442 27,704 15.3% 15 CITY MANAGER'S OFFICE 7,324,610 7,997,018 535,636 1,038,403 13.0% 17 LAW 688,581 646,183 51,630 90,950 14.1% 19 ADMINISTRATIVE SERVICES 9,221,165 9,483,577 590,332 1,019,293 10.7% 21 COMMUNITY DEVELOPMENT 3,579,301 3,480,360 216,639 358,403 10.3% 22 POLICE 39,392,691 38,737,094 4,048,332 5,806,391 15.0% 23 FIRE MGMT & SUPPORT 24,813,300 24,379,850 2,803,504 3,926,413 16.1% 24 HEALTH 3,187,544 3,190,606 213,108 395,725 12.4% 30 PARKS, REC. AND COMMUNITY SERV.12,889,510 12,297,509 719,073 1,241,182 10.1% 40 PUBLIC WORKS AGENCY 13,523,392 13,232,299 1,491,193 2,377,336 18.0% Expenses Total 115,385,322 114,153,373 10,729,245 16,352,666 14.3% Net 342,851 1,733,497 1,301,518 1,662,610 Beginning Fund Balance 13,243,107 13,585,958 13,585,958 Fund Balance % Ending Fund Balance 13,585,958 15,319,455 15,248,569 13.4% 2018 Actual 2019 Budget February 2019 YTD 2019 % YTD to Budget 505 PARKING SYSTEM FUND Target = 16.7% Revenue Licenses, Permits and Fees 2,798 Charges for Services 6,299,975 10,343,855 417,498 1,009,307 9.8% Interest Income 109,598 20,000 5,998 13,258 66.3% Intergovernmental Revenue - - 0.0% Other Revenue 318,293 202,020 45,046 58,719 29.1% Interfund Transfers 3,037,704 - 0.0% Revenue Total 9,768,368 10,565,875 468,542 1,081,284 10.2% Expenses Salary and Benefits 1,774,780 1,996,976 130,813 222,726 11.2% Services and Supplies 4,008,848 3,546,775 337,715 523,267 14.8% Insurance and Other Chargebacks 319,648 333,969 27,831 55,661 16.7% Miscellaneous 231,879 304,000 - 0.0% Contingencies 1,495 11,000 - 0.0% Capital Outlay 518,681 3,510,000 326,636 330,036 9.4% Interfund Transfers 1,440,417 3,512,807 263,567 527,135 15.0% Debt Service 3,070,625 34,354 - 0.0% Expenses Total 11,366,373 13,249,881 1,086,562 1,658,825 12.5% Net (1,598,005) (2,684,006) (618,020) (577,540) Beginning Fund Balance 4,710,701 3,112,696 3,112,696 Fund Balance % Ending Fund Balance 3,112,696 428,690 2,535,156 19.1% 510-513 WATER FUND 2018 Actual 2019 Budget February 2019 YTD 2019 % YTD to Budget Target = 16.7% Revenue Charges for Services 16,064,914 22,615,529 1,474,982 2,971,952 13.1% Interest Income 255,928 40,000 45,897 84,421 211.1% Interfund Transfers 187,430 - 0.0% Licenses, Permits and Fees 47,218 50,000 3,040 6,910 13.8% Other Revenue 5,321,469 23,194,160 54,569 57,312 0.2% Revenue Total 21,876,958 45,899,689 1,578,488 3,120,595 6.8% Expenses Salary and Benefits 5,563,077 5,533,772 436,353 737,132 13.3% Services and Supplies 3,984,623 6,231,350 279,644 328,657 5.3% Insurance and Other Chargebacks 470,397 489,481 40,790 83,485 17.1% Capital Outlay 6,110,431 30,345,500 9,000 0.0% Debt Service 1,799,077 2,081,841 - 0.0% Interfund Transfers 3,682,309 3,932,313 327,693 655,386 16.7% Miscellaneous - 42,000 - 0.0% Contingencies - 1,000 1,000 100.0% Expenses Total 21,609,914 48,657,257 1,084,480 1,814,660 3.7% Net 267,045 (2,757,568) 494,008 1,305,935 Beginning Fund Balance 6,562,795 6,829,840 6,829,840 Fund Balance % Ending Fund Balance 6,829,840 4,072,272 8,135,775 16.7% 2018 Actual 2019 Budget February 2019 YTD 2019 % YTD to Budget 515 SEWER FUND Target = 16.7% Revenue Charges for Services 11,919,244 10,483,885 1,008,231 2,095,126 20.0% Interest Income 56,455 5,000 8,905 18,871 377.4% Other Revenue 1,504,154 3,104,000 - 0.0% Interfund Transfers 187,430 - 0.0% Revenue Total 13,667,282 13,592,885 1,017,136 2,113,996 15.6% Expenses Salary and Benefits 1,320,523 1,354,512 107,267 172,046 12.7% Services and Supplies 766,651 284,500 6,226 13,562 4.8% Insurance and Other Chargebacks 269,988 282,083 23,507 47,014 16.7% Miscellaneous 230 1,500 - 0.0% Capital Outlay 734,666 4,910,636 2,000 0.0% Interfund Transfers 991,677 1,773,532 64,461 128,922 7.3% Debt Service 2,844,540 6,148,475 203,089 387,334 6.3% Expenses Total 6,928,274 14,755,238 404,550 750,878 5.1% Net 6,739,008 (1,162,353) 612,586 1,363,118 Beginning Fund Balance 3,663,138 10,402,146 10,402,146 Fund Balance % Ending Fund Balance 10,402,146 9,239,793 11,765,264 79.7% 2018 Actual 2019 Budget February 2019 YTD 2019 % YTD to Budget 520 SOLID WASTE FUND Target = 16.7% Revenue Property Taxes 410,000 820,000 - 0.0% Charges for Services 3,672,193 4,239,270 278,236 533,890 12.6% Other Revenue 124,222 138,000 864 30,952 22.4% Interfund Transfers 705,967 150,000 12,500 25,000 16.7% Licenses, Permits and Fees 213,545 486,000 (180) 58,866 12.1% Revenue Total 5,125,927 5,833,270 291,421 648,709 11.1% Expenses Salary and Benefits 984,745 1,076,209 83,104 137,006 12.7% Services and Supplies 3,438,594 3,601,076 446,455 453,385 12.6% Insurance and Other Chargebacks 1,520 - 898 100.0% Miscellaneous 5,288 7,500 203 203 2.7% Capital Outlay 289,938 386,650 2,650 2,650 0.7% Interfund Transfers 322,362 322,362 26,864 53,727 16.7% Debt Service 21,797 22,745 - 0.0% Expenses Total 5,064,244 5,416,542 559,275 647,869 12.0% Net 61,683 416,728 (267,854) 840 Beginning Fund Balance (1,061,966) (1,000,283) (1,000,283) Fund Balance % Ending Fund Balance (1,000,283) (583,555) (999,444) -18.5% Through February 28, 2019 2018 Actual 2019 Budget February 2019 YTD 2019 % YTD to Budget 100 GENERAL FUND Target = 16.7% Revenue Property Taxes 28,188,353 30,047,955 4,585,199 4,642,196 15.4% Other Taxes 50,095,876 50,796,300 4,393,448 7,491,431 14.7% Licenses, Permits and Fees 11,680,895 10,526,400 867,906 1,973,785 18.8% Charges for Services 10,396,458 8,900,909 1,079,067 1,674,170 18.8% Fines and Forfeitures 3,765,058 4,700,500 339,909 640,868 13.6% Interest Income 94,681 55,100 13,895 28,353 51.5% Intergovernmental Revenue 1,466,926 994,303 40,018 72,703 7.3% Other Revenue 1,906,784 988,300 (23,430) 22,268 2.3% Interfund Transfers 8,133,142 8,877,103 734,751 1,469,502 16.6% Revenue Total 115,728,174 115,886,870 12,030,763 18,015,277 15.5% Expenses 13 CITY COUNCIL 547,275 528,173 43,357 70,866 13.4% 14 CITY CLERK 217,953 180,704 16,442 27,704 15.3% 15 CITY MANAGER'S OFFICE 7,324,610 7,997,018 535,636 1,038,403 13.0% 17 LAW 688,581 646,183 51,630 90,950 14.1% 19 ADMINISTRATIVE SERVICES 9,221,165 9,483,577 590,332 1,019,293 10.7% 21 COMMUNITY DEVELOPMENT 3,579,301 3,480,360 216,639 358,403 10.3% 22 POLICE 39,392,691 38,737,094 4,048,332 5,806,391 15.0% 23 FIRE MGMT & SUPPORT 24,813,300 24,379,850 2,803,504 3,926,413 16.1% 24 HEALTH 3,187,544 3,190,606 213,108 395,725 12.4% 30 PARKS, REC. AND COMMUNITY SERV.12,889,510 12,297,509 719,073 1,241,182 10.1% 40 PUBLIC WORKS AGENCY 13,523,392 13,232,299 1,491,193 2,377,336 18.0% Expenses Total 115,385,322 114,153,373 10,729,245 16,352,666 14.3% Net 342,851 1,733,497 1,301,518 1,662,610 Beginning Fund Balance 13,243,107 13,585,958 13,585,958 Fund Balance % Ending Fund Balance 13,585,958 15,319,455 15,248,569 13.4% Through February 28, 2019 2018 Actual 2019 Budget February 2019 YTD 2019 % YTD to Budget 175 GENERAL ASSISTANCE FUND Target = 16.7% Revenue Property Taxes 913,827 925,000 132,200 133,307 14.4% Interest Income 10,174 1,000 1,121 2,464 246.4% Other Revenue 14,724 27,500 8,259 30.0% Revenue Total 938,725 953,500 133,320 144,029 15.1% Expenses Salary and Benefits 398,715 407,294 31,261 53,289 13.1% Services and Supplies 578,513 859,482 62,424 127,031 14.8% Miscellaneous 4,209 7,000 (20) -0.3% Expenses Total 981,437 1,273,776 93,685 180,300 14.2% Net (42,712) (320,276) 39,635 (36,271) Beginning Fund Balance 644,499 601,787 601,787 Fund Balance % Ending Fund Balance 601,787 281,511 565,516 44.4% 2018 Actual 2019 Budget February 2019 YTD 2019 % YTD to Budget 176 HEALTH AND HUMAN SERVICES Target = 16.7% Revenue Interest Income 247 - 35 100.0% Other Revenue 22,593 - 0.0% Interfund Transfers 828,471 828,471 69,039 138,079 16.7% Revenue Total 851,311 828,471 69,039 138,114 16.7% Expenses Salary and Benefits - - 0.0% Services and Supplies 57,637 736,373 7 0.0% Miscellaneous 10,000 - 0.0% Community Sponsored Organizations 759,214 81,098 23,889 23,889 29.5% Expenses Total 826,851 817,471 23,889 23,896 2.9% Net 24,460 11,000 45,150 114,218 Beginning Fund Balance (10,815) 13,645 13,645 Fund Balance % Ending Fund Balance 13,645 24,645 127,863 15.6% Through February 28, 2019 2018 Actual 2019 Budget February 2019 YTD 2019 % YTD to Budget 180 GOOD NEIGHBOR FUND Target = 16.7% Revenue Interest Income 2,718 2,000 498 1,095 54.7% Other Revenue 1,000,000 1,000,000 1,000,000 100.0% Revenue Total 1,002,718 1,002,000 498 1,001,095 99.9% Expenses Services and Supplies 0 - 101 223 100.0% Miscellaneous 370,000 - 0.0% Interfund Transfers 1,000,000 630,000 52,500 105,000 16.7% Expenses Total 1,000,000 1,000,000 52,601 105,223 10.5% Net 2,718 2,000 (52,103) 895,871 Beginning Fund Balance 1,884 4,602 4,602 Fund Balance % Ending Fund Balance 4,602 6,602 900,474 90.0% Through February 28, 2019 2018 Actual 2019 Budget February 2019 YTD 2019 % YTD to Budget 185 LIBRARY FUND Target = 16.7% Revenue Property Taxes 6,597,472 6,810,000 957,844 966,655 14.2% Interest Income 48,821 10,000 5,939 13,257 132.6% Other Revenue 244,942 333,500 15,318 102,729 30.8% Interfund Transfers 265,771 345,771 12,500 25,000 7.2% Charges for Services 332 - 28 79 100.0% Fines and Forfeitures 110,721 85,000 6,344 15,318 18.0% Intergovernmental Revenue 221,158 123,000 9,180 9,180 7.5% Library Revenue 220,981 238,000 12,115 17,167 7.2% Revenue Total 7,710,199 7,945,271 1,019,269 1,149,385 14.5% Expenses Salary and Benefits 4,993,616 5,124,176 377,829 657,985 12.8% Services and Supplies 1,829,028 2,230,588 149,395 176,831 7.9% Miscellaneous 37,000 - 0.0% Capital Outlay 1,179 12,400 - 0.0% Interfund Transfers 366,949 367,781 30,648 61,297 16.7% Expenses Total 7,190,773 7,771,945 557,872 896,113 11.5% Net 519,426 173,326 461,396 253,272 Beginning Fund Balance 1,042,304 1,561,730 1,561,730 Fund Balance % Ending Fund Balance 1,561,730 1,735,056 1,815,001 23.4% Through February 28, 2019 2018 Actual 2019 Budget February 2019 YTD 2019 % YTD to Budget 186 LIBRARY DEBT SERVICE FUND Target = 16.7% Revenue Property Taxes 333,896 353,437 - - 0.0% Other Revenue - - - 0.0% Revenue Total 333,896 353,437 - - 0.0% Expenses Services and Supplies - - - 0.0% Interfund Transfers - - - 0.0% Debt Service 333,404 353,437 - - 0.0% Expenses Total 333,404 353,437 - - 0.0% Net 492 - - - Beginning Fund Balance 4,089 4,581 4,581 Fund Balance % Ending Fund Balance 4,581 4,581 4,581 1.3% Through February 28, 2019 2018 Actual 2019 Budget February 2019 YTD 2019 % YTD to Budget 187 LIBRARY CAPITAL IMPROVEMENT FD Target = 16.7% Revenue Other Revenue 2,157,728 1,835,000 - 0.0% Revenue Total 2,157,728 1,835,000 - 0.0% Expenses Services and Supplies 30,700 - 0.0% Interfund Transfers 1,250,000 1,250,000 - 0.0% Capital Outlay 190,247 585,000 8,499 8,499 1.5% Debt Service 26,631 - 0.0% Expenses Total 1,497,577 1,835,000 8,499 8,499 0.5% Net 660,150 - (8,499) (8,499) Beginning Fund Balance 308,399 968,549 968,549 Fund Balance % Ending Fund Balance 968,549 968,549 960,050 52.3% Through February 28, 2019 2018 Actual 2019 Budget February 2019 YTD 2019 % YTD to Budget 200 MOTOR FUEL TAX FUND Target = 16.7% Revenue Interest Income 47,035 12,000 3,377 6,742 56.2% Interfund Transfers 42,709 - 0.0% Intergovernmental Revenue 1,909,326 1,910,000 161,603 323,384 16.9% Revenue Total 1,999,069 1,922,000 164,980 330,125 17.2% Expenses Interfund Transfers 957,990 982,897 81,908 163,816 16.7% Capital Outlay 1,500,000 1,206,000 - 0.0% Expenses Total 2,457,990 2,188,897 81,908 163,816 7.5% Net (458,921) (266,897) 83,072 166,309 Beginning Fund Balance 2,373,730 1,914,809 1,914,809 Fund Balance % Ending Fund Balance 1,914,809 1,647,912 2,081,118 95.1% Through February 28, 2019 2018 Actual 2019 Budget February 2019 YTD 2019 % YTD to Budget 205 EMERGENCY TELEPHONE (E911) FUND Target = 16.7% Revenue Interest Income 13,504 7,000 1,824 3,604 51.5% Other Revenue 863 - 0.0% Other Taxes 1,545,996 1,312,800 118,242 118,242 9.0% Revenue Total 1,560,362 1,319,800 120,066 121,846 9.2% Expenses Salary and Benefits 602,144 613,825 46,765 80,973 13.2% Services and Supplies 210,642 290,400 3,874 10,398 3.6% Interfund Transfers 73,366 74,034 6,170 12,339 16.7% Capital Outlay 9,167 25,000 - 0.0% Insurance and Other Chargebacks 17,448 18,230 1,519 3,038 16.7% Expenses Total 912,767 1,021,489 58,327 106,748 10.5% Net 647,595 298,311 61,739 15,098 Beginning Fund Balance 181,996 829,591 829,591 Fund Balance % Ending Fund Balance 829,591 1,127,902 844,689 82.7% Through February 28, 2019 2018 Actual 2019 Budget February 2019 YTD 2019 % YTD to Budget 210 SPECIAL SERVICE AREA (SSA) #4 Target = 16.7% Revenue Interest Income 25 - 0.0% Property Taxes 341,934 525,000 32,366 32,366 6.2% Revenue Total 341,959 525,000 32,366 32,366 6.2% Expenses Services and Supplies 370,000 525,000 - 0.0% Expenses Total 370,000 525,000 - 0.0% Net (28,041) - 32,366 32,366 Beginning Fund Balance (198,794) (226,835) (226,835) Fund Balance % Ending Fund Balance (226,835) (226,835) (194,470) -37.0% Through February 28, 2019 2018 Actual 2019 Budget February 2019 YTD 2019 % YTD to Budget 215 CDBG FUND Target = 16.7% Revenue Other Revenue 14,347 297 297 100.0% Intergovernmental Revenue 1,511,105 2,631,080 - 0.0% Revenue Total 1,525,452 2,631,080 297 297 0.0% Expenses Salary and Benefits 447,373 509,100 32,318 56,159 11.0% Services and Supplies 5,032 447,700 17 962 0.2% Miscellaneous 154,443 971,410 - 0.0% Interfund Transfers 21,050 634,640 775 1,549 0.2% Capital Outlay 443,440 5,364 5,364 100.0% Community Sponsored Organizations 161,448 50,000 - 0.0% Insurance and Other Chargebacks 293,332 18,230 1,519 3,038 16.7% Expenses Total 1,526,119 2,631,080 39,993 67,073 2.5% Net (667) - (39,696) (66,776) Beginning Fund Balance 64,107 63,440 63,440 Fund Balance % Ending Fund Balance 63,440 63,440 (3,335) -0.1% Through February 28, 2019 2018 Actual 2019 Budget February 2019 YTD 2019 % YTD to Budget 220 CDBG LOAN FUND Target = 16.7% Revenue Interest Income 5,087 - 482 1,492 100.0% Other Revenue 114,531 250,000 44,026 46,922 18.8% Revenue Total 119,618 250,000 44,508 48,414 19.4% Expenses Services and Supplies 190,484 250,000 56 0.0% Insurance and Other Chargebacks 8,552 - 0.0% Expenses Total 199,035 250,000 56 0.0% Net (79,418) - 44,508 48,358 Beginning Fund Balance 252,612 173,194 173,194 Fund Balance % Ending Fund Balance 173,194 173,194 221,552 88.6% Through February 28, 2019 2018 Actual 2019 Budget February 2019 YTD 2019 % YTD to Budget 235 NEIGHBORHOOD IMPROVEMENT Target = 16.7% Revenue Interest Income 1,066 - 78 172 100.0% Revenue Total 1,066 - 78 172 100.0% Expenses Services and Supplies 163 - 16 35 100.0% Interfund Transfers 100,000 - 0.0% Miscellaneous - - 0.0% Expenses Total 163 100,000 16 35 0.0% Net 903 (100,000) 62 137 Beginning Fund Balance 170,171 171,074 171,074 Fund Balance % Ending Fund Balance 171,074 71,074 171,211 171.2% Through February 28, 2019 2018 Actual 2019 Budget February 2019 YTD 2019 % YTD to Budget 240 HOME FUND Target = 16.7% Revenue Interest Income 5,451 - 22 36 100.0% Other Revenue 27,477 - 2,282 4,564 100.0% Intergovernmental Revenue 300,423 741,269 - 0.0% Revenue Total 333,351 741,269 2,304 4,600 0.6% Expenses Salary and Benefits 36,165 33,375 2,568 4,404 13.2% Services and Supplies 301,124 696,500 6 211 0.0% Miscellaneous - 500 - 0.0% Insurance and Other Chargebacks (1,992) 10,894 75 149 1.4% Expenses Total 335,296 741,269 2,648 4,763 0.6% Net (1,945) - (344) (163) Beginning Fund Balance 9,277 7,332 7,332 Fund Balance % Ending Fund Balance 7,332 7,332 7,169 1.0% Through February 28, 2019 2018 Actual 2019 Budget February 2019 YTD 2019 % YTD to Budget 250 AFFORDABLE HOUSING FUND Target = 16.7% Revenue Interest Income 14,449 4,500 1,877 3,433 76.3% Other Revenue 134,417 2,530,600 39,167 1.5% Other Taxes 58,700 80,000 10,000 12.5% Revenue Total 207,566 2,615,100 1,877 52,599 2.0% Expenses Salary and Benefits 82,935 136,697 11,041 17,713 13.0% Services and Supplies 126,852 818,500 102 215 0.0% Miscellaneous 43,387 52,500 1,140 1,140 2.2% Insurance and Other Chargebacks 47,755 - 0.0% Community Sponsored Organizations 18,006 20,000 - - 0.0% Capital Outlay 2,234 2,234 100.0% Expenses Total 318,935 1,027,697 14,518 21,302 2.1% Net (111,369) 2,615,100 (157) 31,297 Beginning Fund Balance 1,476,544 1,365,175 1,365,175 Fund Balance % Ending Fund Balance 1,365,175 3,980,275 1,396,472 135.9% Through February 28, 2019 2018 Actual 2019 Budget February 2019 YTD 2019 % YTD to Budget 320 DEBT SERVICE FUND Target = 16.7% Revenue Property Taxes 10,520,453 10,879,993 1,588,122 1,602,311 14.7% Other Revenue 7,106,441 - (4,815) 100.0% Interfund Transfers 4,137,334 4,676,744 327,229 654,458 14.0% Interest Income 159,322 1,500 10,486 17,322 1154.8% Intergovernmental Revenue 86,624 87,457 7,288 14,576 16.7% Revenue Total 22,010,174 15,645,694 1,933,125 2,283,851 14.6% Expenses Services and Supplies 63,225 120,000 6 12 0.0% Debt Service 21,770,744 14,647,219 - 0.0% Expenses Total 21,833,969 14,767,219 6 12 0.0% Net 176,205 878,475 1,933,119 2,283,840 Beginning Fund Balance 241,781 417,986 417,986 Fund Balance % Ending Fund Balance 417,986 1,296,461 2,701,826 18.3% Through February 28, 2019 2018 Actual 2019 Budget February 2019 YTD 2019 % YTD to Budget 330 HOWARD-RIDGE TIF FUND Target = 16.7% Revenue Property Taxes 622,345 655,000 13,761 13,761 2.1% Interest Income 120 400 - 0.0% Other Revenue 3,530,261 5,366 447 447 8.3% Revenue Total 4,152,727 660,766 14,208 14,208 2.2% Expenses Services and Supplies 490,957 400,000 - 0.0% Interfund Transfers 105,319 346,225 28,852 57,704 16.7% Capital Outlay 1,585,566 - 0.0% Debt Service 1,401 - 136 419 100.0% Expenses Total 2,183,243 746,225 28,988 58,123 7.8% Net 1,969,484 (85,459) (14,780) (43,915) Beginning Fund Balance 247,378 2,216,862 2,216,862 Fund Balance % Ending Fund Balance 2,216,862 2,131,403 2,172,948 291.2% Through February 28, 2019 2018 Actual 2019 Budget February 2019 YTD 2019 % YTD to Budget 335 WEST EVANSTON TIF FUND Target = 16.7% Revenue Property Taxes 217,949 220,000 19,552 19,552 8.9% Interest Income 12,403 4,000 989 24.7% Other Revenue 11,311 11,000 1,028 9.3% Revenue Total 241,663 235,000 19,552 21,569 9.2% Expenses Services and Supplies 6,831 - 0.0% Interfund Transfers 30,000 30,000 2,500 5,000 16.7% Debt Service 17,218 613,000 101,397 104,866 17.1% Expenses Total 54,049 643,000 103,897 109,866 17.1% Net 187,614 (408,000) (84,345) (88,297) Beginning Fund Balance 432,766 620,380 620,380 Fund Balance % Ending Fund Balance 620,380 212,380 532,083 82.8% Through February 28, 2019 2018 Actual 2019 Budget February 2019 YTD 2019 % YTD to Budget 340 DEMPSTER-DODGE TIF FUND Target = 16.7% Revenue Property Taxes 136,927 275,000 75,310 75,310 27.4% Interest Income 10 - 0.0% Revenue Total 136,937 275,000 75,310 75,310 27.4% Expenses Services and Supplies 1,981 - 0.0% Interfund Transfers 74,104 70,870 5,906 11,812 16.7% Debt Service - - 0.0% Expenses Total 76,085 70,870 5,906 11,812 16.7% Net 60,852 204,130 69,404 63,498 Beginning Fund Balance (6,009) 54,843 54,843 Fund Balance % Ending Fund Balance 54,843 258,973 118,341 167.0% Through February 28, 2019 2018 Actual 2019 Budget February 2019 YTD 2019 % YTD to Budget 345 CHICAGO-MAIN TIF Target = 16.7% Revenue Property Taxes 222,235 225,000 102,751 110,020 48.9% Interest Income 23 - 1 100.0% Revenue Total 222,258 225,000 102,751 110,020 48.9% Expenses Services and Supplies 1,981 - 0.0% Interfund Transfers 107,561 100,610 8,384 16,768 16.7% Debt Service - - 0.0% Expenses Total 109,542 100,610 8,384 16,768 16.7% Net 112,716 124,390 94,367 93,252 Beginning Fund Balance 61,193 173,909 173,909 Fund Balance % Ending Fund Balance 173,909 298,299 267,161 265.5% Through February 28, 2019 2018 Actual 2019 Budget February 2019 YTD 2019 % YTD to Budget 350 SPECIAL SERVICE AREA (SSA) #6 Target = 16.7% Revenue Interest Income 34 500 0 0.0% Property Taxes 115,944 221,000 28,264 29,481 13.3% Revenue Total 115,978 221,500 28,264 29,481 13.3% Expenses Services and Supplies 115,086 221,500 - 0.0% Expenses Total 115,086 221,500 - 0.0% Net 892 - 28,264 29,481 Beginning Fund Balance 2,207 3,099 3,099 Fund Balance % Ending Fund Balance 3,099 3,099 32,580 14.7% Through February 28, 2019 2018 Actual 2019 Budget February 2019 YTD 2019 % YTD to Budget 415 CAPITAL IMPROVEMENTS FUND Target = 16.7% Revenue Other Revenue 10,274,896 9,000,000 - 0.0% Interfund Transfers 9,760,353 715,000 - 0.0% Interest Income 198,795 - 22,340 46,429 100.0% Intergovernmental Revenue 206,797 3,970,000 - 0.0% Charges for Services 59,572 - 290 100.0% Revenue Total 20,500,412 13,685,000 22,340 46,719 0.3% Expenses Salary and Benefits 650,759 648,393 50,247 94,251 14.5% Services and Supplies 1,425,667 - (47,432) (47,427) 100.0% Capital Outlay 11,557,860 13,612,156 5,448 13,048 0.1% Interfund Transfers 669,524 - 0.0% Expenses Total 14,303,810 14,260,549 8,263 59,872 0.4% Net 6,196,602 (575,549) 14,077 (13,152) Beginning Fund Balance 8,758,473 14,955,075 14,955,075 Fund Balance % Ending Fund Balance 14,955,075 14,379,526 14,941,923 104.8% Through February 28, 2019 2018 Actual 2019 Budget February 2019 YTD 2019 % YTD to Budget 416 CROWN CONSTRUCTION FUND Target = 16.7% Revenue Other Revenue 25,652,394 17,605,498 3,840 0.0% Interest Income 159,657 50,000 30,821 80,958 161.9% Intergovernmental Revenue 1,250,000 1,250,000 - 0.0% Revenue Total 27,062,051 18,905,498 30,821 84,798 0.4% Expenses Services and Supplies 2,007,340 - 5 10 100.0% Capital Outlay 8,769,266 23,670,000 - - 0.0% Debt Service - - 0.0% Interfund Transfers 316,380 - 0.0% Expenses Total 11,092,986 23,670,000 5 10 0.0% Net 15,969,065 (4,764,502) 30,816 84,788 Beginning Fund Balance 540,861 16,509,926 16,509,926 Fund Balance % Ending Fund Balance 16,509,926 11,745,424 16,594,715 70.1% Through February 28, 2019 2018 Actual 2019 Budget February 2019 YTD 2019 % YTD to Budget 420 SPECIAL ASSESSMENT FUND Target = 16.7% Revenue Other Revenue 277,004 250,000 - 0.0% Special Assessment 183,472 180,167 23,875 84,671 47.0% Interest Income 57,940 38,000 5,406 10,994 28.9% Revenue Total 518,417 468,167 29,281 95,664 20.4% Expenses Salary and Benefits 73,323 - 1,172 100.0% Services and Supplies 1,953 - 5 10 100.0% Interfund Transfers 513,427 286,955 23,913 47,826 16.7% Capital Outlay 650,000 - 0.0% Debt Service 303,736 - 0.0% Expenses Total 892,439 936,955 23,918 49,008 5.2% Net (374,022) (468,788) 5,363 46,657 Beginning Fund Balance 2,997,700 2,623,678 2,623,678 Fund Balance % Ending Fund Balance 2,623,678 2,154,890 2,670,335 285.0% Through February 28, 2019 2018 Actual 2019 Budget February 2019 YTD 2019 % YTD to Budget 505 PARKING SYSTEM FUND Target = 16.7% Revenue Licenses, Permits and Fees 2,798 Charges for Services 6,299,975 10,343,855 417,498 1,009,307 9.8% Interest Income 109,598 20,000 5,998 13,258 66.3% Intergovernmental Revenue - - 0.0% Other Revenue 318,293 202,020 45,046 58,719 29.1% Interfund Transfers 3,037,704 - 0.0% Revenue Total 9,768,368 10,565,875 468,542 1,081,284 10.2% Expenses Salary and Benefits 1,774,780 1,996,976 130,813 222,726 11.2% Services and Supplies 4,008,848 3,546,775 337,715 523,267 14.8% Insurance and Other Chargebacks 319,648 333,969 27,831 55,661 16.7% Miscellaneous 231,879 304,000 - 0.0% Contingencies 1,495 11,000 - 0.0% Capital Outlay 518,681 3,510,000 326,636 330,036 9.4% Interfund Transfers 1,440,417 3,512,807 263,567 527,135 15.0% Debt Service 3,070,625 34,354 - 0.0% Expenses Total 11,366,373 13,249,881 1,086,562 1,658,825 12.5% Net (1,598,005) (2,684,006) (618,020) (577,540) Beginning Fund Balance 4,710,701 3,112,696 3,112,696 Fund Balance % Ending Fund Balance 3,112,696 428,690 2,535,156 19.1% Through February 28, 2019 510-513 WATER FUND 2018 Actual 2019 Budget February 2019 YTD 2019 % YTD to Budget Target = 16.7% Revenue Charges for Services 16,064,914 22,615,529 1,474,982 2,971,952 13.1% Interest Income 255,928 40,000 45,897 84,421 211.1% Interfund Transfers 187,430 - 0.0% Licenses, Permits and Fees 47,218 50,000 3,040 6,910 13.8% Other Revenue 5,321,469 23,194,160 54,569 57,312 0.2% Revenue Total 21,876,958 45,899,689 1,578,488 3,120,595 6.8% Expenses Salary and Benefits 5,563,077 5,533,772 436,353 737,132 13.3% Services and Supplies 3,979,623 6,231,350 279,644 328,657 5.3% Insurance and Other Chargebacks 470,397 489,481 40,790 83,485 17.1% Capital Outlay 6,110,431 30,345,500 9,000 0.0% Debt Service 1,799,077 2,081,841 - 0.0% Interfund Transfers 3,682,309 3,932,313 327,693 655,386 16.7% Miscellaneous - 42,000 - 0.0% Contingencies - 1,000 1,000 100.0% Expenses Total 21,604,914 48,657,257 1,084,480 1,814,660 3.7% Net 272,045 (2,757,568) 494,008 1,305,935 Beginning Fund Balance 6,562,795 6,834,840 6,834,840 Fund Balance % Ending Fund Balance 6,834,840 4,077,272 8,140,775 16.7% Through February 28, 2019 2018 Actual 2019 Budget February 2019 YTD 2019 % YTD to Budget 515 SEWER FUND Target = 16.7% Revenue Charges for Services 11,919,244 10,483,885 1,008,231 2,095,126 20.0% Interest Income 56,455 5,000 8,905 18,871 377.4% Other Revenue 1,504,154 3,104,000 - 0.0% Interfund Transfers 187,430 - 0.0% Revenue Total 13,667,282 13,592,885 1,017,136 2,113,996 15.6% Expenses Salary and Benefits 1,320,523 1,354,512 107,267 172,046 12.7% Services and Supplies 766,651 284,500 6,226 13,562 4.8% Insurance and Other Chargebacks 269,988 282,083 23,507 47,014 16.7% Miscellaneous 230 1,500 - 0.0% Capital Outlay 734,666 4,910,636 2,000 0.0% Interfund Transfers 991,677 1,773,532 64,461 128,922 7.3% Debt Service 2,844,540 6,148,475 203,089 387,334 6.3% Expenses Total 6,928,274 14,755,238 404,550 750,878 5.1% Net 6,739,008 (1,162,353) 612,586 1,363,118 Beginning Fund Balance 3,663,138 10,402,146 10,402,146 Fund Balance % Ending Fund Balance 10,402,146 9,239,793 11,765,264 79.7% Through February 28, 2019 2018 Actual 2019 Budget February 2019 YTD 2019 % YTD to Budget 520 SOLID WASTE FUND Target = 16.7% Revenue Property Taxes 410,000 820,000 - 0.0% Charges for Services 3,672,193 4,239,270 278,236 533,890 12.6% Other Revenue 124,222 138,000 864 30,952 22.4% Interfund Transfers 705,967 150,000 12,500 25,000 16.7% Licenses, Permits and Fees 213,545 486,000 (180) 58,866 12.1% Revenue Total 5,125,927 5,833,270 291,421 648,709 11.1% Expenses Salary and Benefits 984,745 1,076,209 83,104 137,006 12.7% Services and Supplies 3,438,594 3,601,076 446,455 453,385 12.6% Insurance and Other Chargebacks 1,520 - 898 100.0% Miscellaneous 5,288 7,500 203 203 2.7% Capital Outlay 289,938 386,650 2,650 2,650 0.7% Interfund Transfers 322,362 322,362 26,864 53,727 16.7% Debt Service 21,797 22,745 - 0.0% Expenses Total 5,064,244 5,416,542 559,275 647,869 12.0% Net 61,683 416,728 (267,854) 840 Beginning Fund Balance (1,061,966) (1,000,283) (1,000,283) Fund Balance % Ending Fund Balance (1,000,283) (583,555) (999,444) -18.5% Through February 28, 2019 2018 Actual 2019 Budget February 2019 YTD 2019 % YTD to Budget 600 FLEET SERVICES FUND Target = 16.7% Revenue Charges for Services 2,988,640 2,950,415 245,868 491,736 16.7% Other Revenue 18,765 81,781 - 0.0% Interest Income 24 1,000 - 0.0% Revenue Total 3,007,429 3,033,196 245,868 491,736 16.2% Expenses Salary and Benefits 1,110,729 1,117,701 73,016 132,670 11.9% Services and Supplies 1,950,412 2,030,057 159,429 179,793 8.9% Miscellaneous 118 - 0.0% Interfund Transfers 33,442 35,114 2,926 5,852 16.7% Insurance and Other Chargebacks 868 - 1,736 4,339 100.0% Contingencies - 450 34 34 7.6% Expenses Total 3,095,569 3,183,322 237,140 322,688 10.1% Net (88,140) (150,126) 8,728 169,048 Beginning Fund Balance 333,159 245,019 245,019 Fund Balance % Ending Fund Balance 245,019 94,893 414,067 13.0% 2018 Actual 2019 Budget February 2019 YTD 2019 % YTD to Budget 601 EQUIPMENT REPLACEMENT FUND Target = 16.7% Revenue Charges for Services 1,334,732 1,309,732 109,144 218,289 16.7% Interest Income 5,037 - 353 797 100.0% Other Revenue (74,225) 210,217 - 0.0% Revenue Total 1,265,543 1,519,949 109,497 219,086 14.4% Expenses Services and Supplies 40,745 75,000 72 162 0.2% Capital Outlay 41,579 1,547,977 - - 0.0% Depreciation Expense 1,695,533 - 0.0% Expenses Total 1,777,856 1,622,977 72 162 0.0% Net (512,313) (103,028) 109,425 218,923 Beginning Fund Balance 849,519 337,206 337,206 Fund Balance % Ending Fund Balance 337,206 234,178 556,129 34.3% Through February 28, 2019 2018 Actual 2019 Budget February 2019 YTD 2019 % YTD to Budget 605 INSURANCE FUND Target = 16.7% Revenue Other Revenue 10,447,722 10,391,176 841,680 1,464,320 14.1% Charges for Services 167,917 - 0.0% Interfund Transfers - 54,958 - 0.0% Insurance 5,625,636 6,118,205 502,492 947,754 15.5% Workers Compensation and Liability 2,087,381 3,026,943 273,979 521,978 17.2% Interest Income - 1,000 - 0.0% Revenue Total 18,328,656 19,592,282 1,618,151 2,934,051 15.0% Expenses Salary and Benefits 575,577 630,531 39,266 67,905 10.8% Services and Supplies 5,804,544 2,420,448 1,284,587 1,914,337 79.1% Insurance and Other Chargebacks 16,380,334 15,901,777 1,275,975 2,602,609 16.4% Capital Outlay 5,011 - 0.0% Interfund Transfers 9,632 10,114 843 1,686 16.7% Expenses Total 22,775,098 18,962,870 2,600,671 4,586,537 24.2% Net (4,446,442) 629,412 (982,520) (1,652,486) Beginning Fund Balance (4,338,505) (8,784,947) (8,784,947) Fund Balance % Ending Fund Balance (8,784,947) (8,155,535) (10,437,433) -55.0% Through February 28, 2019 2018 Actual 2019 Budget February 2019 YTD 2019 % YTD to Budget 700 FIRE PENSION FUND Target = 16.7% Revenue Other Revenue 3,825,767 9,068,084 60,757 120,615 1.3% Interfund Transfers - 20,000 - 0.0% Interest Income 2,230,596 2,500,000 - 0.0% Other Taxes - 280,000 - 0.0% Revenue Total 6,056,363 11,868,084 60,757 120,615 1.0% Expenses Salary and Benefits 9,261,585 9,333,500 810,526 1,621,050 17.4% Miscellaneous 91,737 - 0.0% Expenses Total 9,353,322 9,333,500 810,526 1,621,050 17.4% Net (3,296,959) 2,534,584 (749,769) (1,500,435) Beginning Fund Balance 79,073,077 75,776,118 75,776,118 Fund Balance % Ending Fund Balance 75,776,118 78,310,702 74,275,684 795.8% 2018 Actual 2019 Budget February 2019 YTD 2019 % YTD to Budget 705 POLICE PENSION FUND Target = 16.7% Revenue Interest Income 2,971,614 3,000,000 - 0.0% Other Revenue 4,442,478 15,946,808 141,693 226,550 1.4% Interfund Transfers - - 0.0% Other Taxes 325,000 - 0.0% Revenue Total 7,414,092 19,271,808 141,693 226,550 1.2% Expenses Salary and Benefits 11,996,570 12,601,500 1,039,530 2,073,673 16.5% Miscellaneous 292,132 275,000 - 0.0% Expenses Total 12,288,703 12,876,500 1,039,530 2,073,673 16.1% Net (4,874,611) 6,395,308 (897,837) (1,847,123) Beginning Fund Balance 121,629,667 116,755,056 116,755,056 Fund Balance % Ending Fund Balance 116,755,056 123,150,364 114,907,933 892.4%