Loading...
HomeMy WebLinkAbout2019.01 January Monthly Report To: Wally Bobkiewicz, City Manager From: Hitesh Desai, CFO/City Treasurer Kate Lewis-Lakin, Budget Coordinator Subject: January 2019 Monthly Financial Report Date: March 14, 2019 Please find attached the unaudited financial statements as of January 31, 2019. A summary by fund for revenues, expenditures, fund and cash balances is as follows: January 2019 Revenue Expense Net Fund Balance Cash Balance 100 GENERAL FUND 5,984,514 5,623,421 361,092 14,074,270 10,603,771 175 GENERAL ASSISTANCE FUND 10,709 86,615 (75,906) 525,881 525,881 176 HEALTH AND HUMAN SERVICES 69,075 7 69,067 82,713 82,712 180 GOOD NEIGHBOR FUND 1,000,597 52,622 947,975 952,262 952,262 185 LIBRARY FUND 130,116 338,241 (208,125) 1,353,605 1,296,196 186 LIBRARY DEBT SERVICE FUND - - - 4,503 4,504 187 LIBRARY CAPITAL IMPROVEMENT FD - - - 968,627 968,627 200 MOTOR FUEL TAX FUND 165,145 81,908 83,237 1,998,047 1,989,034 205 EMERGENCY TELEPHONE (E911) FUND 1,779 48,421 (46,641) 782,950 472,901 210 SPECIAL SERVICE AREA (SSA) #4 - - - (226,835) (226,836) 215 CDBG FUND - 27,080 (27,080) 36,360 22,148 220 CDBG LOAN FUND 3,907 56 3,850 177,045 177,044 235 NEIGHBORHOOD IMPROVEMENT 94 19 75 171,149 171,148 240 HOME FUND 2,296 2,115 181 7,513 7,513 250 AFFORDABLE HOUSING FUND 50,922 6,785 44,138 1,404,896 1,507,500 320 DEBT SERVICE FUND 350,726 5 350,721 768,707 849,391 330 HOWARD-RIDGE TIF FUND - 29,134 (29,134) 2,187,728 2,189,997 335 WEST EVANSTON TIF FUND 2,017 5,969 (3,953) 616,428 611,613 340 DEMPSTER-DODGE TIF FUND - 5,906 (5,906) 48,937 48,937 345 CHICAGO-MAIN TIF 7,270 8,384 (1,115) 172,794 172,795 350 SPECIAL SERVICE AREA (SSA) #6 1,217 - 1,217 4,316 4,316 415 CAPITAL IMPROVEMENTS FUND 24,379 51,609 (27,230) 15,001,836 12,380,310 416 CROWN CONSTRUCTION FUND 53,977 5 53,972 16,563,898 18,452,576 420 SPECIAL ASSESSMENT FUND 66,384 25,090 41,294 2,664,972 2,661,435 505 PARKING SYSTEM FUND 612,742 572,263 40,479 3,153,175 3,109,251 510 WATER FUND 1,542,107 730,180 811,927 7,641,767 5,719,233 515 SEWER FUND 1,096,860 346,328 750,532 11,157,679 3,605,736 520 SOLID WASTE FUND 357,288 88,594 268,694 (731,589) (1,108,801) 600 FLEET SERVICES FUND 245,868 85,548 160,320 128,259 (626,770) 601 EQUIPMENT REPLACEMENT FUND 109,588 91 109,498 1,048,296 991,755 605 INSURANCE FUND 1,315,901 1,985,866 (669,966) (9,454,913) (5,097,031) Grand Total 13,205,478 10,202,264 3,003,214 73,285,275 62,519,148 Memorandum Included above are the ending balances as of January 31, 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 en ding 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 5.2% of budget and expenses at 4.9% of budget, both below target of 8.3%. Revenues are often below target at this point in the year because the first property tax installment does not come due until March. Expenses are below target in all departments. Because of payroll timing, January includes less than 1.5 pay periods. Additionally, January tends to have low programmatic spending. The department with the highest percent spending to budget is the Public Works Agency, due to the costs of snow removal operations in January. Enterprise Funds Parking fund revenues through January 31, 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 January 31, 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 January 31, 2019, the Solid Waste Fund has a negative fund balance of $731,589 and a negative cash balance of $1,108,801. 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 January 31, 2019, the E911 and CDBG Funds are higher monthly expenses than revenues. This is due to a delay in reimbursements from state and federal government agencies. As of January 31 both funds have positive fund and cash balances. Through January 31, 2019, funds receiving property tax revenue show higher monthly expenses than revenues. This includes the General Assistance Fund, 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. Through January 31, 2019, the SSA #4 Fund is showing a negative fund and cash balance of $226,835. Through January 31, 2019, the Capital Fund is showing a fund balance of $15,001,835 and a cash balance of $12,380,310. The fund continues to spend down balances from the 2018B General Obligation Bonds received in August 2018. Through January 31, 2019, the Crown Construction fund is showing a fund balance of $16,563,898 and cash balance of $18,452,576 . The fund continues to spend down balances from the 2018A General Obligation Bond proceeds received in August 2018. Through January 31, 2019, the Insurance Fund is showing a negative fund balance of $9,483,124 and a negative cash balance of $5,097,031. 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 January 31, 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 September October November 2019 Unreserved Fund Balance 14,074,270$ 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$ 16,923,253$ 16,225,727$ 13,799,783$ 2019 Cash Balance 10,603,771$ 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$ 10,763,842$ 11,463,410$ 9,825,856$ 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 January 2019 2019 YTD % YTD to Budget 100 GENERAL FUND Target = 8.3% Revenue Property Taxes 28,188,353 30,047,955 56,997 56,997 0.2% Other Taxes 50,042,144 50,796,300 3,097,983 3,097,983 6.1% Licenses, Permits and Fees 11,680,895 10,526,400 1,105,878 1,105,878 10.5% Charges for Services 10,412,949 8,900,909 595,104 595,104 6.7% Fines and Forfeitures 3,765,058 4,700,500 300,958 300,958 6.4% Interest Income 94,681 55,100 14,458 14,458 26.2% Intergovernmental Revenue 1,466,926 994,303 32,686 32,686 3.3% Other Revenue 1,763,275 988,300 45,698 45,698 4.6% Interfund Transfers 8,133,142 8,877,103 734,751 734,751 8.3% Revenue Total 115,547,424 115,886,870 5,984,514 5,984,514 5.2% Expenses 13 CITY COUNCIL 547,275 528,173 27,509 27,509 5.2% 14 CITY CLERK 217,953 180,704 11,262 11,262 6.2% 15 CITY MANAGER'S OFFICE 7,106,668 7,997,018 502,767 502,767 6.3% 17 LAW 680,554 646,183 39,320 39,320 6.1% 19 ADMINISTRATIVE SERVICES 9,206,386 9,483,577 428,962 428,962 4.5% 21 COMMUNITY DEVELOPMENT 3,572,658 3,480,360 141,763 141,763 4.1% 22 POLICE 39,374,467 38,737,094 1,758,058 1,758,058 4.5% 23 FIRE MGMT & SUPPORT 24,813,300 24,379,850 1,122,909 1,122,909 4.6% 24 HEALTH 3,165,206 3,190,606 182,617 182,617 5.7% 30 PARKS, REC. AND COMMUNITY SERV.12,842,485 12,297,509 522,110 522,110 4.2% 40 PUBLIC WORKS AGENCY 13,523,392 13,232,299 886,143 886,143 6.7% Expenses Total 115,050,345 114,153,373 5,623,421 5,623,421 4.9% Net 497,079 1,733,497 361,092 361,092 Beginning Fund Balance 13,216,099 13,713,178 13,713,178 Fund Balance % Ending Fund Balance 13,713,178 15,446,675 14,074,270 12.3% 2018 Actual 2019 Budget January 2019 2019 YTD % YTD to Budget 505 PARKING SYSTEM FUND Target = 8.3% Revenue Licenses, Permits and Fees 2,798 Charges for Services 6,299,975 10,343,855 591,809 591,809 5.7% Interest Income 109,598 20,000 7,260 7,260 36.3% Intergovernmental Revenue - 0.0% Other Revenue 318,293 202,020 13,673 13,673 6.8% Interfund Transfers 3,037,704 0.0% Revenue Total 9,768,368 10,565,875 612,742 612,742 5.8% Expenses Salary and Benefits 1,774,780 1,996,976 91,913 91,913 4.6% Services and Supplies 4,008,848 3,546,775 185,552 185,552 5.2% Insurance and Other Chargebacks 319,648 333,969 27,831 27,831 8.3% Miscellaneous 231,879 304,000 - - 0.0% Contingencies 1,495 11,000 - - 0.0% Capital Outlay 518,681 3,510,000 3,400 3,400 0.1% Interfund Transfers 1,440,417 3,512,807 263,567 263,567 7.5% Debt Service 3,070,625 34,354 - - 0.0% Expenses Total 11,366,373 13,249,881 572,263 572,263 4.3% Net (1,598,005) (2,684,006) 40,479 40,479 Beginning Fund Balance 4,710,701 3,112,696 3,112,696 Fund Balance % Ending Fund Balance 3,112,696 428,690 3,153,175 23.8% 510-513 WATER FUND 2018 Actual 2019 Budget January 2019 2019 YTD % YTD to Budget Target = 8.3% Revenue Charges for Services 16,064,914 22,615,529 1,496,970 1,496,970 6.6% Interest Income 255,928 40,000 38,524 38,524 96.3% Interfund Transfers 187,430 0.0% Licenses, Permits and Fees 47,218 50,000 3,870 3,870 7.7% Other Revenue 5,321,469 23,194,160 2,743 2,743 0.0% Revenue Total 21,876,958 45,899,689 1,542,107 1,542,107 3.4% Expenses Salary and Benefits 5,563,077 5,533,772 300,779 300,779 5.4% Services and Supplies 3,984,623 6,231,350 49,013 49,013 0.8% Insurance and Other Chargebacks 470,397 489,481 42,695 42,695 8.7% Capital Outlay 6,110,431 30,345,500 9,000 9,000 0.0% Debt Service 1,799,077 2,081,841 - - 0.0% Interfund Transfers 3,682,309 3,932,313 327,693 327,693 8.3% Miscellaneous - 42,000 - - 0.0% Contingencies - 1,000 1,000 1,000 100.0% Expenses Total 21,609,914 48,657,257 730,180 730,180 1.5% Net 267,045 (2,757,568) 811,927 811,927 Beginning Fund Balance 6,562,795 6,829,840 6,829,840 Fund Balance % Ending Fund Balance 6,829,840 4,072,272 7,641,767 15.7% 2018 Actual 2019 Budget January 2019 2019 YTD % YTD to Budget 515 SEWER FUND Target = 8.3% Revenue Charges for Services 11,919,244 10,483,885 1,086,895 1,086,895 10.4% Interest Income 56,455 5,000 9,966 9,966 199.3% 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,096,860 1,096,860 8.1% Expenses Salary and Benefits 1,320,523 1,354,512 64,779 64,779 4.8% Services and Supplies 772,151 284,500 7,336 7,336 2.6% Insurance and Other Chargebacks 269,988 282,083 23,507 23,507 8.3% Miscellaneous 230 1,500 - - 0.0% Capital Outlay 1,098,782 4,910,636 2,000 2,000 0.0% Interfund Transfers 991,677 1,773,532 64,461 64,461 3.6% Debt Service 2,844,540 6,148,475 184,245 184,245 3.0% Expenses Total 7,297,891 14,755,238 346,328 346,328 2.3% Net 6,369,391 (1,162,353) 750,532 750,532 Beginning Fund Balance 4,037,755 10,407,146 10,407,146 Fund Balance % Ending Fund Balance 10,407,146 9,244,793 11,157,679 75.6% 2018 Actual 2019 Budget January 2019 2019 YTD % YTD to Budget 520 SOLID WASTE FUND Target = 8.3% Revenue Property Taxes 410,000 820,000 - - 0.0% Charges for Services 3,672,193 4,239,270 255,654 255,654 6.0% Other Revenue 124,222 138,000 30,088 30,088 21.8% Interfund Transfers 705,967 150,000 12,500 12,500 8.3% Licenses, Permits and Fees 213,545 486,000 59,046 59,046 12.1% Revenue Total 5,125,927 5,833,270 357,288 357,288 6.1% Expenses Salary and Benefits 984,745 1,076,209 53,902 53,902 5.0% Services and Supplies 3,438,594 3,601,076 6,930 6,930 0.2% Insurance and Other Chargebacks 1,520 - 898 898 0.0% Miscellaneous 5,288 7,500 - - 0.0% Capital Outlay 289,938 386,650 - - 0.0% Interfund Transfers 322,362 322,362 26,864 26,864 8.3% Debt Service 21,797 22,745 - - 0.0% Expenses Total 5,064,244 5,416,542 88,594 88,594 1.6% Net 61,683 416,728 268,694 268,694 Beginning Fund Balance (1,061,966) (1,000,283) (1,000,283) Fund Balance % Ending Fund Balance (1,000,283) (583,555) (731,589) -13.5% Through January 31, 2019 2018 Actual 2019 Budget January 2019 2019 YTD % YTD to Budget 100 GENERAL FUND Target = 8.3% Revenue Property Taxes 28,188,353 30,047,955 56,997 56,997 0.2% Other Taxes 50,042,144 50,796,300 3,097,983 3,097,983 6.1% Licenses, Permits and Fees 11,680,895 10,526,400 1,105,878 1,105,878 10.5% Charges for Services 10,412,949 8,900,909 595,104 595,104 6.7% Fines and Forfeitures 3,765,058 4,700,500 300,958 300,958 6.4% Interest Income 94,681 55,100 14,458 14,458 26.2% Intergovernmental Revenue 1,466,926 994,303 32,686 32,686 3.3% Other Revenue 1,763,275 988,300 45,698 45,698 4.6% Interfund Transfers 8,133,142 8,877,103 734,751 734,751 8.3% Revenue Total 115,547,424 115,886,870 5,984,514 5,984,514 5.2% Expenses 13 CITY COUNCIL 547,275 528,173 27,509 27,509 5.2% 14 CITY CLERK 217,953 180,704 11,262 11,262 6.2% 15 CITY MANAGER'S OFFICE 7,106,668 7,997,018 502,767 502,767 6.3% 17 LAW 680,554 646,183 39,320 39,320 6.1% 19 ADMINISTRATIVE SERVICES 9,206,386 9,483,577 428,962 428,962 4.5% 21 COMMUNITY DEVELOPMENT 3,572,658 3,480,360 141,763 141,763 4.1% 22 POLICE 39,374,467 38,737,094 1,758,058 1,758,058 4.5% 23 FIRE MGMT & SUPPORT 24,813,300 24,379,850 1,122,909 1,122,909 4.6% 24 HEALTH 3,165,206 3,190,606 182,617 182,617 5.7% 30 PARKS, REC. AND COMMUNITY SERV.12,842,485 12,297,509 522,110 522,110 4.2% 40 PUBLIC WORKS AGENCY 13,523,392 13,232,299 886,143 886,143 6.7% Expenses Total 115,050,345 114,153,373 5,623,421 5,623,421 4.9% Net 497,079 1,733,497 361,092 361,092 Beginning Fund Balance 13,216,099 13,713,178 13,713,178 Fund Balance % Ending Fund Balance 13,713,178 15,446,675 14,074,270 12.3% Through January 31, 2019 2018 Actual 2019 Budget January 2019 2019 YTD % YTD to Budget 175 GENERAL ASSISTANCE FUND Target = 8.3% Revenue Property Taxes 913,827 925,000 1,107 1,107 0.1% Interest Income 10,174 1,000 1,344 1,344 134.4% Other Revenue 14,724 27,500 8,259 8,259 30.0% Revenue Total 938,725 953,500 10,709 10,709 1.1% Expenses Salary and Benefits 398,715 407,294 22,028 22,028 5.4% Services and Supplies 578,513 859,482 64,607 64,607 7.5% Miscellaneous 4,209 7,000 (20) (20) -0.3% Expenses Total 981,437 1,273,776 86,615 86,615 6.8% Net (42,712) (320,276) (75,906) (75,906) Beginning Fund Balance 644,499 601,787 601,787 Fund Balance % Ending Fund Balance 601,787 281,511 525,881 41.3% 2018 Actual 2019 Budget January 2019 2019 YTD % YTD to Budget 176 HEALTH AND HUMAN SERVICES Target = 8.3% Revenue Interest Income 247 - 35 35 0.0% Other Revenue 22,593 0.0% Interfund Transfers 828,471 828,471 69,039 69,039 8.3% Revenue Total 851,311 828,471 69,075 69,075 8.3% Expenses Salary and Benefits - 0.0% Services and Supplies 57,637 736,373 7 7 0.0% Miscellaneous 10,000 0.0% Community Sponsored Organizations 759,214 81,098 - - 0.0% Expenses Total 826,851 817,471 7 7 0.0% Net 24,460 11,000 69,067 69,067 Beginning Fund Balance (10,815) 13,645 13,645 Fund Balance % Ending Fund Balance 13,645 24,645 82,713 10.1% Through January 31, 2019 2018 Actual 2019 Budget January 2019 2019 YTD % YTD to Budget 180 GOOD NEIGHBOR FUND Target = 8.3% Revenue Interest Income 2,718 2,000 597 597 29.8% Other Revenue 1,000,000 1,000,000 1,000,000 1,000,000 100.0% Revenue Total 1,002,718 1,002,000 1,000,597 1,000,597 99.9% Expenses Services and Supplies 315 - 122 122 0.0% Miscellaneous 370,000 - - 0.0% Interfund Transfers 1,000,000 630,000 52,500 52,500 8.3% Expenses Total 1,000,315 1,000,000 52,622 52,622 5.3% Net 2,404 2,000 947,975 947,975 Beginning Fund Balance 1,884 4,288 4,288 Fund Balance % Ending Fund Balance 4,288 6,288 952,262 95.2% Through January 31, 2019 2018 Actual 2019 Budget January 2019 2019 YTD % YTD to Budget 185 LIBRARY FUND Target = 8.3% Revenue Interest Income 48,821 10,000 7,318 7,318 73.2% Other Revenue 244,942 333,500 87,411 87,411 26.2% Interfund Transfers 265,771 345,771 12,500 12,500 3.6% Charges for Services 332 - 50 50 0.0% Fines and Forfeitures 110,721 85,000 8,974 8,974 10.6% Intergovernmental Revenue 221,158 123,000 - - 0.0% Library Revenue 220,981 238,000 5,053 5,053 2.1% Property Taxes 6,597,472 6,810,000 8,811 8,811 0.1% Revenue Total 7,710,199 7,945,271 130,116 130,116 1.6% Expenses Salary and Benefits 4,993,616 5,124,176 280,156 280,156 5.5% Services and Supplies 1,829,028 2,230,588 27,436 27,436 1.2% Miscellaneous 37,000 - - 0.0% Capital Outlay 1,179 12,400 - - 0.0% Interfund Transfers 366,949 367,781 30,648 30,648 8.3% Expenses Total 7,190,773 7,771,945 338,241 338,241 4.4% Net 519,426 173,326 (208,125) (208,125) Beginning Fund Balance 1,042,304 1,561,730 1,561,730 Fund Balance % Ending Fund Balance 1,561,730 1,735,056 1,353,605 17.4% Through January 31, 2019 2018 Actual 2019 Budget January 2019 2019 YTD % YTD to Budget 186 LIBRARY DEBT SERVICE FUND Target = 8.3% Revenue Other Revenue - 0.0% Property Taxes 333,896 353,437 - - 0.0% Revenue Total 333,896 353,437 - - 0.0% Expenses Services and Supplies 78 0.0% Interfund Transfers - 0.0% Debt Service 333,404 353,437 - - 0.0% Expenses Total 333,482 353,437 - - 0.0% Net 414 - - - Beginning Fund Balance 4,089 4,503 4,503 Fund Balance % Ending Fund Balance 4,503 4,503 4,503 1.3% Through January 31, 2019 2018 Actual 2019 Budget January 2019 2019 YTD % YTD to Budget 187 LIBRARY CAPITAL IMPROVEMENT FD Target = 8.3% 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,622 0.0% Interfund Transfers 1,250,000 1,250,000 - - 0.0% Capital Outlay 190,247 585,000 - - 0.0% Debt Service 26,631 0.0% Expenses Total 1,497,500 1,835,000 - - 0.0% Net 660,228 - - - Beginning Fund Balance 308,399 968,627 968,627 Fund Balance % Ending Fund Balance 968,627 968,627 968,627 52.8% Through January 31, 2019 2018 Actual 2019 Budget January 2019 2019 YTD % YTD to Budget 200 MOTOR FUEL TAX FUND Target = 8.3% Revenue Interest Income 47,035 12,000 3,364 3,364 28.0% Interfund Transfers 42,709 0.0% Intergovernmental Revenue 1,909,326 1,910,000 161,781 161,781 8.5% Revenue Total 1,999,069 1,922,000 165,145 165,145 8.6% Expenses Interfund Transfers 957,990 982,897 81,908 81,908 8.3% Capital Outlay 1,500,000 1,206,000 - - 0.0% Expenses Total 2,457,990 2,188,897 81,908 81,908 3.7% Net (458,921) (266,897) 83,237 83,237 Beginning Fund Balance 2,373,730 1,914,809 1,914,809 Fund Balance % Ending Fund Balance 1,914,809 1,647,912 1,998,047 91.3% Through January 31, 2019 2018 Actual 2019 Budget January 2019 2019 YTD % YTD to Budget 205 EMERGENCY TELEPHONE (E911) FUND Target = 8.3% Revenue Interest Income 13,504 7,000 1,779 1,779 25.4% Other Revenue 863 0.0% Other Taxes 1,545,996 1,312,800 - - 0.0% Revenue Total 1,560,362 1,319,800 1,779 1,779 0.1% Expenses Salary and Benefits 602,144 613,825 34,208 34,208 5.6% Services and Supplies 210,642 290,400 6,524 6,524 2.2% Interfund Transfers 73,366 74,034 6,170 6,170 8.3% Capital Outlay 9,167 25,000 - - 0.0% Insurance and Other Chargebacks 17,448 18,230 1,519 1,519 8.3% Expenses Total 912,767 1,021,489 48,421 48,421 4.7% Net 647,595 298,311 (46,641) (46,641) Beginning Fund Balance 181,996 829,591 829,591 Fund Balance % Ending Fund Balance 829,591 1,127,902 782,950 76.6% Through January 31, 2019 2018 Actual 2019 Budget January 2019 2019 YTD % YTD to Budget 210 SPECIAL SERVICE AREA (SSA) #4 Target = 8.3% Revenue Interest Income 25 0.0% Property Taxes 341,934 525,000 - - 0.0% Revenue Total 341,959 525,000 - - 0.0% Expenses Services and Supplies 370,000 525,000 - - 0.0% Expenses Total 370,000 525,000 - - 0.0% Net (28,041) - - - Beginning Fund Balance (198,794) (226,835) (226,835) Fund Balance % Ending Fund Balance (226,835) (226,835) (226,835) -43.2% Through January 31, 2019 2018 Actual 2019 Budget January 2019 2019 YTD % YTD to Budget 215 CDBG FUND Target = 8.3% Revenue Other Revenue 14,347 0.0% Intergovernmental Revenue 1,511,105 2,631,080 - - 0.0% Revenue Total 1,525,452 2,631,080 - - 0.0% Expenses Salary and Benefits 447,373 509,100 23,841 23,841 4.7% Services and Supplies 5,032 447,700 945 945 0.2% Miscellaneous 154,443 971,410 - - 0.0% Interfund Transfers 21,050 634,640 775 775 0.1% Capital Outlay 443,440 0.0% Community Sponsored Organizations 161,448 50,000 - - 0.0% Insurance and Other Chargebacks 293,332 18,230 1,519 1,519 8.3% Expenses Total 1,526,119 2,631,080 27,080 27,080 1.0% Net (667) - (27,080) (27,080) Beginning Fund Balance 64,107 63,440 63,440 Fund Balance % Ending Fund Balance 63,440 63,440 36,360 1.4% Through January 31, 2019 2018 Actual 2019 Budget January 2019 2019 YTD % YTD to Budget 220 CDBG LOAN FUND Target = 8.3% Revenue Interest Income 2,468 - 1,010 1,010 0.0% Other Revenue 117,150 250,000 2,896 2,896 1.2% Revenue Total 119,618 250,000 3,907 3,907 1.6% Expenses Services and Supplies 190,484 250,000 56 56 0.0% Insurance and Other Chargebacks 8,552 0.0% Expenses Total 199,035 250,000 56 56 0.0% Net (79,418) - 3,850 3,850 Beginning Fund Balance 252,612 173,194 173,194 Fund Balance % Ending Fund Balance 173,194 173,194 177,045 70.8% Through January 31, 2019 2018 Actual 2019 Budget January 2019 2019 YTD % YTD to Budget 235 NEIGHBORHOOD IMPROVEMENT Target = 8.3% Revenue Interest Income 1,066 - 94 94 0.0% Revenue Total 1,066 - 94 94 0.0% Expenses Services and Supplies 163 - 19 19 0.0% Interfund Transfers 100,000 - - 0.0% Miscellaneous - 0.0% Expenses Total 163 100,000 19 19 0.0% Net 903 (100,000) 75 75 Beginning Fund Balance 170,171 171,074 171,074 Fund Balance % Ending Fund Balance 171,074 71,074 171,149 171.1% Through January 31, 2019 2018 Actual 2019 Budget January 2019 2019 YTD % YTD to Budget 240 HOME FUND Target = 8.3% Revenue Interest Income 5,451 - 14 14 0.0% Other Revenue 27,477 - 2,282 2,282 0.0% Intergovernmental Revenue 300,423 741,269 - - 0.0% Revenue Total 333,351 741,269 2,296 2,296 0.3% Expenses Salary and Benefits 36,165 33,375 1,836 1,836 5.5% Services and Supplies 301,124 696,500 205 205 0.0% Miscellaneous - 500 - - 0.0% Insurance and Other Chargebacks (1,992) 10,894 75 75 0.7% Expenses Total 335,296 741,269 2,115 2,115 0.3% Net (1,945) - 181 181 Beginning Fund Balance 9,277 7,332 7,332 Fund Balance % Ending Fund Balance 7,332 7,332 7,513 1.0% Through January 31, 2019 2018 Actual 2019 Budget January 2019 2019 YTD % YTD to Budget 250 AFFORDABLE HOUSING FUND Target = 8.3% Revenue Interest Income 14,449 4,500 1,556 1,556 34.6% Other Revenue 130,000 2,530,600 39,167 39,167 1.5% Other Taxes 58,700 80,000 10,000 10,000 12.5% Revenue Total 203,149 2,615,100 50,722 50,722 1.9% Expenses Salary and Benefits 82,935 136,697 6,672 6,672 4.9% Services and Supplies 126,852 818,500 113 113 0.0% Miscellaneous 43,387 52,500 - - 0.0% Insurance and Other Chargebacks 47,755 0.0% Community Sponsored Organizations 18,006 20,000 - - 0.0% Expenses Total 318,935 1,027,697 6,785 6,785 0.7% Net (115,786) 1,587,403 44,138 44,138 Beginning Fund Balance 1,476,544 1,360,758 1,360,758 Fund Balance % Ending Fund Balance 1,360,758 2,948,161 1,404,896 136.7% Through January 31, 2019 2018 Actual 2019 Budget January 2019 2019 YTD % YTD to Budget 320 DEBT SERVICE FUND Target = 8.3% Revenue Property Taxes 10,520,453 10,879,993 14,189 14,189 0.1% Other Revenue 7,106,441 - (4,815) (4,815) 0.0% Interfund Transfers 4,137,334 4,676,744 327,229 327,229 7.0% Interest Income 159,322 1,500 6,836 6,836 455.7% Intergovernmental Revenue 86,624 87,457 7,288 7,288 8.3% Revenue Total 22,010,174 15,645,694 350,726 350,726 2.2% Expenses Services and Supplies 63,225 120,000 5 5 0.0% Debt Service 21,770,744 14,647,219 - - 0.0% Expenses Total 21,833,969 14,767,219 5 5 0.0% Net 176,205 878,475 350,721 350,721 Beginning Fund Balance 241,781 417,986 417,986 Fund Balance % Ending Fund Balance 417,986 1,296,461 768,707 5.2% Through January 31, 2019 2018 Actual 2019 Budget January 2019 2019 YTD % YTD to Budget 330 HOWARD-RIDGE TIF FUND Target = 8.3% Revenue Property Taxes 622,345 655,000 - - 0.0% Interest Income 120 400 - - 0.0% Other Revenue 3,530,261 5,366 - - 0.0% Revenue Total 4,152,727 660,766 - - 0.0% Expenses Services and Supplies 490,957 400,000 - - 0.0% Interfund Transfers 105,319 346,225 28,852 28,852 8.3% Capital Outlay 1,585,566 0.0% Debt Service 1,401 - 282 282 0.0% Expenses Total 2,183,243 746,225 29,134 29,134 3.9% Net 1,969,484 (85,459) (29,134) (29,134) Beginning Fund Balance 247,378 2,216,862 2,216,862 Fund Balance % Ending Fund Balance 2,216,862 2,131,403 2,187,728 293.2% Through January 31, 2019 2018 Actual 2019 Budget January 2019 2019 YTD % YTD to Budget 335 WEST EVANSTON TIF FUND Target = 8.3% Revenue Property Taxes 217,949 220,000 - - 0.0% Interest Income 12,403 4,000 989 989 24.7% Other Revenue 11,311 11,000 1,028 1,028 9.3% Revenue Total 241,663 235,000 2,017 2,017 0.9% Expenses Services and Supplies 6,831 0.0% Interfund Transfers 30,000 30,000 2,500 2,500 8.3% Debt Service 17,218 613,000 3,469 3,469 0.6% Expenses Total 54,049 643,000 5,969 5,969 0.9% Net 187,614 (408,000) (3,953) (3,953) Beginning Fund Balance 432,766 620,380 620,380 Fund Balance % Ending Fund Balance 620,380 212,380 616,428 95.9% Through January 31, 2019 2018 Actual 2019 Budget January 2019 2019 YTD % YTD to Budget 340 DEMPSTER-DODGE TIF FUND Target = 8.3% Revenue Property Taxes 136,927 275,000 - - 0.0% Interest Income 10 0.0% Revenue Total 136,937 275,000 - - 0.0% Expenses Services and Supplies 1,981 0.0% Interfund Transfers 74,104 70,870 5,906 5,906 8.3% Debt Service - 0.0% Expenses Total 76,085 70,870 5,906 5,906 8.3% Net 60,852 204,130 (5,906) (5,906) Beginning Fund Balance (6,009) 54,843 54,843 Fund Balance % Ending Fund Balance 54,843 258,973 48,937 69.1% Through January 31, 2019 2018 Actual 2019 Budget January 2019 2019 YTD % YTD to Budget 345 CHICAGO-MAIN TIF Target = 8.3% Revenue Property Taxes 222,235 225,000 7,269 7,269 3.2% Interest Income 23 - 1 1 0.0% Revenue Total 222,258 225,000 7,270 7,270 3.2% Expenses Services and Supplies 1,981 0.0% Interfund Transfers 107,561 100,610 8,384 8,384 8.3% Debt Service - 0.0% Expenses Total 109,542 100,610 8,384 8,384 8.3% Net 112,716 124,390 (1,115) (1,115) Beginning Fund Balance 61,193 173,909 173,909 Fund Balance % Ending Fund Balance 173,909 298,299 172,794 171.7% Through January 31, 2019 2018 Actual 2019 Budget January 2019 2019 YTD % YTD to Budget 350 SPECIAL SERVICE AREA (SSA) #6 Target = 8.3% Revenue Interest Income 34 500 0 0 0.0% Property Taxes 115,944 221,000 1,217 1,217 0.6% Revenue Total 115,978 221,500 1,217 1,217 0.5% Expenses Services and Supplies 115,086 221,500 - - 0.0% Expenses Total 115,086 221,500 - - 0.0% Net 892 - 1,217 1,217 Beginning Fund Balance 2,207 3,099 3,099 Fund Balance % Ending Fund Balance 3,099 3,099 4,316 1.9% Through January 31, 2019 2018 Actual 2019 Budget January 2019 2019 YTD % YTD to Budget 415 CAPITAL IMPROVEMENTS FUND Target = 8.3% Revenue Other Revenue 10,274,896 9,000,000 - - 0.0% Interfund Transfers 9,760,353 715,000 - - 0.0% Interest Income 198,795 - 24,089 24,089 0.0% Intergovernmental Revenue 206,797 3,970,000 - - 0.0% Charges for Services 59,572 - 290 290 0.0% Revenue Total 20,500,412 13,685,000 24,379 24,379 0.2% Expenses Salary and Benefits 650,759 648,393 44,004 44,004 6.8% Services and Supplies 1,473,875 - 5 5 0.0% Capital Outlay 11,435,661 13,612,156 7,600 7,600 0.1% Interfund Transfers 669,524 0.0% Expenses Total 14,229,819 14,260,549 51,609 51,609 0.4% Net 6,270,593 (575,549) (27,230) (27,230) Beginning Fund Balance 8,758,473 15,029,066 15,029,066 Fund Balance % Ending Fund Balance 15,029,066 14,453,517 15,001,836 105.2% Through January 31, 2019 2018 Actual 2019 Budget January 2019 2019 YTD % YTD to Budget 416 CROWN CONSTRUCTION FUND Target = 8.3% Revenue Other Revenue 25,652,394 17,605,498 3,840 3,840 0.0% Interest Income 159,657 50,000 50,137 50,137 100.3% Intergovernmental Revenue 1,250,000 1,250,000 - - 0.0% Revenue Total 27,062,051 18,905,498 53,977 53,977 0.3% Expenses Services and Supplies 2,007,340 - 5 5 0.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 5 0.0% Net 15,969,065 (4,764,502) 53,972 53,972 Beginning Fund Balance 540,861 16,509,926 16,509,926 Fund Balance % Ending Fund Balance 16,509,926 11,745,424 16,563,898 70.0% Through January 31, 2019 2018 Actual 2019 Budget January 2019 2019 YTD % YTD to Budget 420 SPECIAL ASSESSMENT FUND Target = 8.3% Revenue Other Revenue 277,004 250,000 - - 0.0% Special Assessment 187,814 180,167 60,796 60,796 33.7% Interest Income 53,599 38,000 5,588 5,588 14.7% Revenue Total 518,417 468,167 66,384 66,384 14.2% Expenses Salary and Benefits 73,323 - 1,172 1,172 0.0% Services and Supplies 1,953 - 5 5 0.0% Interfund Transfers 513,427 286,955 23,913 23,913 8.3% Capital Outlay 650,000 - - 0.0% Debt Service 303,736 0.0% Expenses Total 892,439 936,955 25,090 25,090 2.7% Net (374,022) (468,788) 41,294 41,294 Beginning Fund Balance 2,997,700 2,623,678 2,623,678 Fund Balance % Ending Fund Balance 2,623,678 2,154,890 2,664,972 284.4% Through January 31, 2019 2018 Actual 2019 Budget January 2019 2019 YTD % YTD to Budget 505 PARKING SYSTEM FUND Target = 8.3% Revenue Licenses, Permits and Fees 2,798 Charges for Services 6,299,975 10,343,855 591,809 591,809 5.7% Interest Income 109,598 20,000 7,260 7,260 36.3% Intergovernmental Revenue - 0.0% Other Revenue 318,293 202,020 13,673 13,673 6.8% Interfund Transfers 3,037,704 0.0% Revenue Total 9,768,368 10,565,875 612,742 612,742 5.8% Expenses Salary and Benefits 1,774,780 1,996,976 91,913 91,913 4.6% Services and Supplies 4,008,848 3,546,775 185,552 185,552 5.2% Insurance and Other Chargebacks 319,648 333,969 27,831 27,831 8.3% Miscellaneous 231,879 304,000 - - 0.0% Contingencies 1,495 11,000 - - 0.0% Capital Outlay 518,681 3,510,000 3,400 3,400 0.1% Interfund Transfers 1,440,417 3,512,807 263,567 263,567 7.5% Debt Service 3,070,625 34,354 - - 0.0% Expenses Total 11,366,373 13,249,881 572,263 572,263 4.3% Net (1,598,005) (2,684,006) 40,479 40,479 Beginning Fund Balance 4,710,701 3,112,696 3,112,696 Fund Balance % Ending Fund Balance 3,112,696 428,690 3,153,175 23.8% Through January 31, 2019 510-513 WATER FUND 2018 Actual 2019 Budget January 2019 2019 YTD % YTD to Budget Target = 8.3% Revenue Charges for Services 16,064,914 22,615,529 1,496,970 1,496,970 6.6% Interest Income 255,928 40,000 38,524 38,524 96.3% Interfund Transfers 187,430 0.0% Licenses, Permits and Fees 47,218 50,000 3,870 3,870 7.7% Other Revenue 5,321,469 23,194,160 2,743 2,743 0.0% Revenue Total 21,876,958 45,899,689 1,542,107 1,542,107 3.4% Expenses Salary and Benefits 5,563,077 5,533,772 300,779 300,779 5.4% Services and Supplies 3,984,623 6,231,350 49,013 49,013 0.8% Insurance and Other Chargebacks 470,397 489,481 42,695 42,695 8.7% Capital Outlay 6,110,431 30,345,500 9,000 9,000 0.0% Debt Service 1,799,077 2,081,841 - - 0.0% Interfund Transfers 3,682,309 3,932,313 327,693 327,693 8.3% Miscellaneous - 42,000 - - 0.0% Contingencies - 1,000 1,000 1,000 100.0% Expenses Total 21,609,914 48,657,257 730,180 730,180 1.5% Net 267,045 (2,757,568) 811,927 811,927 Beginning Fund Balance 6,562,795 6,829,840 6,829,840 Fund Balance % Ending Fund Balance 6,829,840 4,072,272 7,641,767 15.7% Through January 31, 2019 2018 Actual 2019 Budget January 2019 2019 YTD % YTD to Budget 515 SEWER FUND Target = 8.3% Revenue Charges for Services 11,919,244 10,483,885 1,086,895 1,086,895 10.4% Interest Income 56,455 5,000 9,966 9,966 199.3% 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,096,860 1,096,860 8.1% Expenses Salary and Benefits 1,320,523 1,354,512 64,779 64,779 4.8% Services and Supplies 772,151 284,500 7,336 7,336 2.6% Insurance and Other Chargebacks 269,988 282,083 23,507 23,507 8.3% Miscellaneous 230 1,500 - - 0.0% Capital Outlay 1,098,782 4,910,636 2,000 2,000 0.0% Interfund Transfers 991,677 1,773,532 64,461 64,461 3.6% Debt Service 2,844,540 6,148,475 184,245 184,245 3.0% Expenses Total 7,297,891 14,755,238 346,328 346,328 2.3% Net 6,369,391 (1,162,353) 750,532 750,532 Beginning Fund Balance 4,037,755 10,407,146 10,407,146 Fund Balance % Ending Fund Balance 10,407,146 9,244,793 11,157,679 75.6% Through January 31, 2019 2018 Actual 2019 Budget January 2019 2019 YTD % YTD to Budget 520 SOLID WASTE FUND Target = 8.3% Revenue Property Taxes 410,000 820,000 - - 0.0% Charges for Services 3,672,193 4,239,270 255,654 255,654 6.0% Other Revenue 124,222 138,000 30,088 30,088 21.8% Interfund Transfers 705,967 150,000 12,500 12,500 8.3% Licenses, Permits and Fees 213,545 486,000 59,046 59,046 12.1% Revenue Total 5,125,927 5,833,270 357,288 357,288 6.1% Expenses Salary and Benefits 984,745 1,076,209 53,902 53,902 5.0% Services and Supplies 3,438,594 3,601,076 6,930 6,930 0.2% Insurance and Other Chargebacks 1,520 - 898 898 0.0% Miscellaneous 5,288 7,500 - - 0.0% Capital Outlay 289,938 386,650 - - 0.0% Interfund Transfers 322,362 322,362 26,864 26,864 8.3% Debt Service 21,797 22,745 - - 0.0% Expenses Total 5,064,244 5,416,542 88,594 88,594 1.6% Net 61,683 416,728 268,694 268,694 Beginning Fund Balance (1,061,966) (1,000,283) (1,000,283) Fund Balance % Ending Fund Balance (1,000,283) (583,555) (731,589) -13.5% Through January 31, 2019 2018 Actual 2019 Budget January 2019 2019 YTD % YTD to Budget 600 FLEET SERVICES FUND Target = 8.3% Revenue Charges for Services 2,988,640 2,950,415 245,868 245,868 8.3% 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 245,868 8.1% Expenses Salary and Benefits 1,103,612 1,117,701 59,654 59,654 5.3% Services and Supplies 2,234,609 2,030,057 20,364 20,364 1.0% Miscellaneous 118 0.0% Interfund Transfers 33,442 35,114 2,926 2,926 8.3% Insurance and Other Chargebacks 868 - 2,604 2,604 0.0% Contingencies - 450 - - 0.0% Expenses Total 3,372,649 3,183,322 85,548 85,548 2.7% Net (365,219) (150,126) 160,320 160,320 Beginning Fund Balance 333,159 (32,060) (32,060) Fund Balance % Ending Fund Balance (32,060) (182,186) 128,259 4.0% 2018 Actual 2019 Budget January 2019 2019 YTD % YTD to Budget 601 EQUIPMENT REPLACEMENT FUND Target = 8.3% Revenue Charges for Services 1,334,732 1,309,732 109,144 109,144 8.3% Interest Income 5,037 - 444 444 0.0% Other Revenue 39,603 210,217 - - 0.0% Revenue Total 1,379,372 1,519,949 109,588 109,588 7.2% Expenses Services and Supplies 40,745 75,000 91 91 0.1% Capital Outlay 1,249,347 1,547,977 - - 0.0% Expenses Total 1,290,092 1,622,977 91 91 0.0% Net 89,280 (103,028) 109,498 109,498 Beginning Fund Balance 849,519 938,799 938,799 Fund Balance % Ending Fund Balance 938,799 835,771 1,048,296 64.6% Through January 31, 2019 2018 Actual 2019 Budget January 2019 2019 YTD % YTD to Budget 605 INSURANCE FUND Target = 8.3% Revenue Other Revenue 10,447,722 10,391,176 622,640 622,640 6.0% Charges for Services 167,917 0.0% Interfund Transfers - 54,958 - - 0.0% Insurance 5,625,636 6,118,205 445,262 445,262 7.3% Workers Compensation and Liability 2,087,381 3,026,943 247,999 247,999 8.2% Interest Income - 1,000 - - 0.0% Revenue Total 18,328,656 19,592,282 1,315,901 1,315,901 6.7% Expenses 0.0% Salary and Benefits 575,577 630,531 28,640 28,640 4.5% Services and Supplies 5,804,544 2,420,448 629,750 629,750 26.0% Insurance and Other Chargebacks 16,380,334 15,901,777 1,326,634 1,326,634 8.3% Capital Outlay 5,011 Interfund Transfers 9,632 10,114 843 843 8.3% Expenses Total 22,775,098 18,962,870 1,985,866 1,985,866 10.5% Net (4,446,442) 629,412 (669,966) (669,966) Beginning Fund Balance (4,338,505) (8,784,947) (8,784,947) Fund Balance % Ending Fund Balance (8,784,947) (8,155,535) (9,454,913) -49.9% Through January 31, 2019 2018 Actual 2019 Budget January 2019 2019 YTD % YTD to Budget 700 FIRE PENSION FUND Target = 8.3% Revenue Other Revenue 3,825,767 9,068,084 59,858 59,858 0.7% 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 59,858 59,858 0.5% Expenses Salary and Benefits 9,261,585 9,333,500 810,523 810,523 8.7% Miscellaneous 91,737 0.0% Expenses Total 9,353,322 9,333,500 810,523 810,523 8.7% Net (3,296,959) 2,534,584 (750,666) (750,666) Beginning Fund Balance 79,073,077 75,776,118 75,776,118 Fund Balance % Ending Fund Balance 75,776,118 78,310,702 75,025,453 803.8% 2018 Actual 2019 Budget January 2019 2019 YTD % YTD to Budget 705 POLICE PENSION FUND Target = 8.3% Revenue Interest Income 2,971,614 3,000,000 - - 0.0% Other Revenue 4,442,478 15,946,808 84,856 84,856 0.5% Interfund Transfers - 0.0% Other Taxes 325,000 - - 0.0% Revenue Total 7,414,092 19,271,808 84,856 84,856 0.4% Expenses Salary and Benefits 11,996,570 12,601,500 1,034,143 1,034,143 8.2% Miscellaneous 292,132 275,000 - - 0.0% Expenses Total 12,288,703 12,876,500 1,034,143 1,034,143 8.0% Net (4,874,611) 6,395,308 (949,286) (949,286) Beginning Fund Balance 121,629,667 116,755,056 116,755,056 Fund Balance % Ending Fund Balance 116,755,056 123,150,364 115,805,770 899.4%