Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2018.04 April Monthly Report
YTD Revenues YTD Expenses YTD Net Fund Balance Cash Balance 42,106,297 37,846,412 4,259,884 17,546,789 11,184,339 510,299 288,851 221,448 865,948 865,948 276,184 232,046 44,138 55,915 33,322 403 333,333 (332,930) (331,046) 668,954 3,695,847 2,016,478 1,679,369 2,664,141 2,663,744 156,995 - 156,995 161,197 161,085 - - - 308,399 308,399 6,670 18,001 (11,331) (13,773) 93,482 636,824 819,330 (182,506) 2,191,224 2,026,636 321,380 250,472 70,908 256,401 (57,145) 159,977 92,500 67,477 (131,317) (131,317) 11,608 155,815 (144,207) (80,113) (80,100) 11,959 41,672 (29,714) 222,897 222,898 69 - 69 170,240 170,240 49,321 53,936 (4,615) 4,662 4,662 76,446 29,475 46,971 1,523,515 1,527,931 2,986,106 2,393,681 592,425 5,854,969 5,928,644 6,021,662 - 6,021,662 6,218,119 6,339,312 328,035 747,608 (419,573) (145,695) (169,926) 47,041 15,090 31,951 464,717 473,039 26,404 - 26,404 20,395 20,395 31,310 - 31,310 92,504 92,504 115,544 - 115,544 117,750 117,751 2,180,632 2,660,479 (479,847) 8,967,509 9,406,529 - 333,696 (333,696) 206,985 207,165 120,858 192,028 (71,169) 2,926,531 2,922,994 4,286,619 1,721,388 2,565,231 7,474,634 7,007,269 6,209,253 3,751,295 2,457,959 9,782,945 5,502,775 4,734,003 2,987,760 1,746,243 5,896,170 3,025,838 1,734,266 1,150,530 583,736 (585,278) (968,391) 1,002,691 933,754 68,937 427,173 (362,306) 445,244 331,182 114,062 1,191,039 963,581 5,856,567 6,060,474 (203,907) (5,551,942) (1,732,016) 84,146,516 65,457,286 18,689,228 68,773,603 58,438,231 605 INSURANCE FUND 520 SOLID WASTE FUND 600 FLEET SERVICES FUND 601 EQUIPMENT REPLACEMENT FUND 505 PARKING SYSTEM FUND 510 WATER FUND 515 SEWER FUND 415 CAPITAL IMPROVEMENTS FUND 416 CROWN CONSTRUCTION FUND 420 SPECIAL ASSESSMENT FUND 350 SPECIAL SERVICE AREA (SSA) #6 187 LIBRARY CAPITAL IMPROVEMENT FD 320 DEBT SERVICE FUND 335 WEST EVANSTON TIF FUND 340 DEMPSTER-DODGE TIF FUND 345 CHICAGO-MAIN TIF 250 AFFORDABLE HOUSING FUND 300 WASHINGTON NATIONAL TIF FUND 330 HOWARD-RIDGE TIF FUND 235 NEIGHBORHOOD IMPROVEMENT 240 HOME FUND 186 LIBRARY DEBT SERVICE FUND 210 SPECIAL SERVICE AREA (SSA) #4 215 CDBG FUND 220 CDBG LOAN FUND 195 NEIGHBORHOOD STABILIZATION 200 MOTOR FUEL TAX FUND 205 EMERGENCY TELEPHONE (E911) FUND 176 HEALTH AND HUMAN SERVICES 180 GOOD NEIGHBOR FUND 185 LIBRARY FUND Fund Fund Description 100 GENERAL FUND 175 GENERAL ASSISTANCE FUND To: Wally Bobkiewicz, City Manager From: Hitesh Desai, CFO/City Treasurer Ashley King, Budget & Finance Manager Kate Lewis-Lakin, Senior Management Analyst Subject: April 2018 Monthly Financial Report Date: May 29, 2018 Please find attached the unaudited financial statements as of April 30, 2018. A summary by fund for revenues, expenditures, fund and cash balances is as follows: Memorandum Included above are the ending balances as of April 30, 2018 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 ending 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 t ax) due to the City and accounts payable/accrued expenses. The fund balances included in this financial report are based on unaudited 2017 year - end balances. These numbers may change slightly as a result of the annual audit, which will be completed in June. As of April 30, 2018, the General Fund is reporting a net surplus of $4,259,884. The General Fund balance is $17,546,789 with a cash balance of $11,184,339. The attached supplemental charts show the General Fund Revenues at 37% of budget and expenses at 33%. Fund and cash balances increased significantly as a result of the first installment of property taxes being received. This is the first of two annual installments. Additionally, the Insurance and Other Chargebacks category shows higher expenses, as this includes the transfer of property tax pension revenue to the Police and Fire pension funds. Through April 30, 2018, the Good Neighbor Fund is showing a negative fund balance of $331,046. This is because the revenue to this fund from Northwestern University is not received until later in the year. Transfers to other funds from the Good Neighbor Fund are made monthly to cover expenses throughout the year on designated projects. Through April 30, 2018, the Neighborhood Stabilization Fund is showing a negative fund balance of $13,773. This is due to the timing of grant funding revenues. Through April 30, 2018, the E911 Fund is showing negative cash balance of $57,145. This is due to timing of E911 revenues f rom the state and the expenses related to the replacement of Computer Aided Dispatch (CAD) and Police/Fire Records Software. Through April 30, 2018, the SSA #4 Fund is showing a negative fund and cash balance of $131,317. This is due to the timing of payments to the Downtown Evanston group. Through April 30, 2018, the CDBG fund is showing a negative fund balance of $80,113 and a negative cash balance of $80,100. This is due to a delay in reimbursements and will be repaid with draw-downs during May. Through April 30, 2018, the Howard-Ridge TIF Fund is showing a negative fund balance of $145,695 and a negative cash balance of $169,926. This is due to money spent on capital projects. The City has planned bond funding to provide cash for these projec ts later this summer. January February March April May June July August 2017 Unreserved Fund Balance 15,453,984$ 17,244,431$ 19,450,955$ 18,292,843$ 2018 Unreserved Fund Balance 16,512,558$ 15,306,742$ 17,933,253$ 17,384,626$ 2017 Cash Balance 6,338,271$ 6,393,110$ 11,561,044$ 10,901,398$ 2018 Cash Balance 8,905,448$ 8,120,225$ 12,288,418$ 11,184,339$ 2017 v 2018 Fund and Cash Balance-- General Fund $- $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 2017 Unreserved Fund Balance 2018 Unreserved Fund Balance 2017 Cash Balance 2018 Cash Balance 2018 April YTD 2017 Budget 2018 2018 %Actual 28,849,196 199,097 15,790,267 55% 28,294,363 49,742,274 4,553,525 16,187,477 33% 46,951,377 5,548,000 284,216 1,504,381 27% 5,129,042 6,681,900 304,841 1,195,433 18% 7,990,628 167,500 1,076 31,554 19% 238,240 3,897,500 84,576 949,996 24% 3,484,050 1,373,500 - 19,578 1% 662,214 5,885,750 491,524 1,936,750 33% 5,471,036 2,818,300 153,738 839,559 30% 2,620,775 7,748,417 618,143 2,472,571 32% 11,586,942 778,100 172,831 453,788 58% 1,468,393 1,300,217 80,879 713,764 55% 1,608,106 50,100 6,154 11,179 22% 38,544 REVENUE TOTAL 114,840,754 6,950,598 42,106,297 37% 115,543,710 CITY COUNCIL 492,806 44,452 163,748 33% 498,172 CITY CLERK 191,784 14,496 49,226 26% 251,193 CITY MANAGER'S OFFICE 7,540,597 756,859 2,275,218 30% 7,539,496 LAW 736,346 67,710 229,413 31% 772,045 ADMINISTRATIVE SERVICES 9,075,303 675,773 2,583,907 28% 9,314,164 COMMUNITY DEVELOPMENT 3,614,774 266,907 1,007,734 28% 2,592,984 POLICE 38,391,099 2,427,652 14,353,403 37% 39,067,047 FIRE MGMT & SUPPORT 23,934,390 1,459,809 9,129,803 38% 24,355,551 HEALTH 3,697,529 236,095 923,157 25% 3,071,334 PARKS, REC. AND COMMUNITY SERV. 11,955,812 797,106 2,791,150 23% 12,479,438 PUBLIC WORKS AGENCY 14,607,356 954,466 4,339,653 30% 13,983,314 EXPENSE TOTAL 114,237,796 7,701,325 37,846,412 33% 113,924,739 114,840,754 6,950,598 42,106,297 37% 115,543,710 114,237,796 7,701,325 37,846,412 33% 113,924,739 602,958 (750,726) 4,259,885 1,618,971 REVENUE TOTALS EXPENSE TOTALS Fund 100 - GENERAL FUND Net Gain Fund 100 - GENERAL FUND Totals Other Revenue Interest Income Parking Charges for Services Parks and Recreation Charges for Services Other Charges for Services Interfund Transfers Fines and Forfeitures Property Taxes Other Taxes License Intergovernmental Revenue April 2018 Financial Report Through 04/30/18 Summary Listing Fund 100 - GENERAL FUND Permit Fee April YTD 2017 2018 2018 %Actuals - 1,813 0.0% 1,900 1,213,735 2,803,478 42.0% 6,184,922 347,253 1,389,013 32.9% 4,120,636 - - 0.0% - 13,095 79,281 41.0% 253,523 4,255 13,035 37.2% 62,067 1,578,339 4,286,619 38.5% 10,623,048 138,768 506,009 27.4% 1,675,404 87,330 445,766 12.9% 3,172,070 135,568 143,821 5.9% 280,311 26,637 106,549 33.3% 319,648 - - 0.0% 2,561,771 - - 0.0% 4,246 - - 0.0% 267,734 - 39,103 12.9% 267,436 120,035 480,139 33.3% 1,584,683 508,338 1,721,388 13.3% 10,133,302 1,578,339 4,286,619 38.5% 10,623,048 508,338 1,721,388 13.3% 10,133,302 1,070,001 2,565,231 489,746 EXPENSE TOTALS 12,896,493 Fund 505 - PARKING SYSTEM FUND (1,762,367) Fund 505 - PARKING SYSTEM FUND REVENUE TOTALS 11,134,126 EXPENSE TOTALS 12,896,493 Debt Service 3,070,625 Miscellaneous 304,000 Interfund Transfers 1,440,417 Insurance and Other Chargebacks 319,648 Depreciation Expense - Contingencies 11,000 Salary and Benefits 1,849,028 Services and Supplies 3,451,775 Capital Outlay 2,450,000 Interest Income 35,070 REVENUE TOTALS 11,134,126 EXPENSE Interfund Transfers 4,217,040 Intergovernmental Revenue 12,125 Other Revenue 193,316 Fund 505 - PARKING SYSTEM FUND REVENUE Licenses, Permits and Fees - Charges for Services 6,676,575 April 2018 Financial Report Through 04/30/18 2018 Classification Budget April YTD 2017 2018 2018 %Actuals 8,617 13,022 18.6% 86,063 1,472,532 6,119,107 33.5% 17,255,947 19,436 31,780 0.1% 294,812 16,190 45,345 181.4% 35,784 1,516,776 6,209,253 13.6% 17,672,605 422,525 1,580,773 28.2% 5,958,873 198,033 607,375 13.0% 2,528,863 33,400 145,794 0.5% 11,408 39,041 156,164 33.3% 468,492 - - 0.0% - - - 0.0% 2,470,280 33,752 33,752 1.7% 717,388 - - 0.0% (203,530) 306,859 1,227,436 34.1% 7,360,654 1,033,611 3,751,295 8.2% 19,312,428 1,516,776 6,209,253 13.6% 17,672,605 1,033,611 3,751,295 8.2% 19,312,428 483,164 2,457,959 (1,639,823) Fund 510 - WATER FUND Totals 32,150 Fund 510 - WATER FUND Totals REVENUE TOTALS 45,695,656 Interfund Transfers 3,602,313 EXPENSE TOTALS 45,663,506 EXPENSE TOTALS 45,663,506 Depreciation Expense - Debt Service 1,960,760 Miscellaneous 15,000 Services and Supplies 4,655,410 Capital Outlay 29,346,200 Insurance and Other Chargebacks 468,492 25,000 REVENUE TOTALS 45,695,656 EXPENSE Salary and Benefits 5,614,331 Contingencies 1,000 April 2018 Financial Report Through 04/30/18 2018 Classification Budget Fund 510 - WATER FUND REVENUE Licenses, Permits and Fees 70,000 Charges for Services 18,267,000 Other Revenue 27,333,656 Interest Income April YTD 2017 2018 2018 %Actuals 1,027,577 4,724,553 37.5% 12,477,657 - - 0.0% 14,870 2,413 9,450 189.0% 16,023 1,029,989 4,734,003 32.2% 12,508,550 101,367 379,098 29.7% 1,313,154 7,875 15,634 0.6% 88,677 48,690 58,703 2.7% 7,676 22,499 89,996 33.3% 269,988 - - 0.0% 3,530,787 266,839 2,113,770 28.0% 1,143,643 - - 0.0% 9,265 82,640 330,559 33.3% 1,141,676 529,910 2,987,760 20.2% 7,504,867 1,029,989 4,734,003 32.2% 12,508,550 529,910 2,987,760 20.2% 7,504,867 500,079 1,746,243 5,003,683 Fund 515 - SEWER FUND Totals (119,220) Fund 515 - SEWER FUND Totals REVENUE TOTALS 14,698,650 EXPENSE TOTALS 14,817,870 Miscellaneous 1,500 Interfund Transfers 991,677 EXPENSE TOTALS 14,817,870 Insurance and Other Chargebacks 269,988 Depreciation Expense - Debt Service 7,540,066 Salary and Benefits 1,274,709 Services and Supplies 2,558,630 Capital Outlay 2,181,300 Interest Income 5,000 REVENUE TOTALS 14,698,650 EXPENSE Fund 515 - SEWER FUND REVENUE Charges for Services 12,589,650 Other Revenue 2,104,000 April 2018 Financial Report Through 04/30/18 2018 Classification Budget April YTD 2017 2018 2018 %Actuals - 260,915 63.6% - - 14,448 5.3% 199,513 323,617 1,202,768 33.1% 3,611,308 58,831 235,322 33.3% 755,967 13,172 20,813 8.7% 250,687 - - 0.0% - 395,620 1,734,266 33.0% 4,817,475 72,664 265,172 26.7% 890,220 99,987 770,281 22.1% 3,482,141 2,502 3,936 1.4% 24,635 - - 0.0% 1,797 3,538 3,688 49.2% 3,057 26,864 107,454 33.3% 504,807 205,555 1,150,530 22.5% 4,906,657 395,620 1,734,266 33.0% 4,817,475 205,555 1,150,530 22.5% 4,906,657 190,066 583,736 (89,182) EXPENSE TOTALS 5,109,701 EXPENSE TOTALS 5,109,701 Fund 520 - SOLID WASTE FUND Totals 151,660 Fund 520 - SOLID WASTE FUND Totals REVENUE TOTALS 5,261,361 Debt Service 21,797 Miscellaneous 7,500 Interfund Transfers 322,362 Salary and Benefits 993,616 Services and Supplies 3,488,676 Capital Outlay 275,750 Interest Income - REVENUE TOTALS 5,261,361 EXPENSE Charges for Services 3,632,394 Interfund Transfers 705,967 Other Revenue 238,000 Fund 520 - SOLID WASTE FUND REVENUE Property Taxes 410,000 Licenses, Permits and Fees 275,000 April 2018 Financial Report Through 04/30/18 2018 Classification Budget April YTD 2017 2018 2018 Actuals 199,097 15,790,267 28,294,363 4,553,525 16,187,477 46,951,377 590,134 2,731,368 13,357,911 84,576 949,996 3,484,050 645,261 2,795,887 8,754,025 618,143 2,472,571 11,586,943 172,831 453,788 1,468,393 80,879 713,764 1,608,106 - - - - - - - - - 6,154 11,179 38,544 - - - - - - 6,950,598 42,106,297 115,543,711 5,377,162 21,276,712 71,659,904 828,624 2,704,304 13,414,590 21,184 29,062 361,427 757,497 11,102,383 20,883,996 35,510 36,825 124,131 - - - - 106 4,090 - - - 41,837 138,980 835,363 639,510 2,558,040 6,641,237 7,701,325 37,846,412 113,924,739 6,950,598 42,106,297 115,543,711 7,701,325 37,846,412 113,924,739 (750,726) 4,259,885 1,618,973 Starting Fund Balance 13,286,905 13,286,905 Net Change 602,958 4,259,885 Ending Fund Balance 13,889,863 17,546,790 REVENUE TOTALS 114,840,754 EXPENSE TOTALS 114,237,796 Fund 100 - GENERAL FUND Totals 602,958 EXPENSE TOTALS 114,237,796 Fund 100 - GENERAL FUND Totals Debt Service - Miscellaneous 1,015,317 Interfund Transfers 7,704,802 Community Sponsored Organizations 123,886 Depreciation Expense - Contingencies 208,500 Services and Supplies 12,367,791 Capital Outlay 354,000 Insurance and Other Chargebacks 22,287,563 REVENUE TOTALS 114,840,754 EXPENSE Salary and Benefits 70,175,937 Interest Income 50,100 Special Assessment - Reappropriation of Surplus - Workers Compensation and Liability - Insurance - Library Revenue - Interfund Transfers 7,748,417 Intergovernmental Revenue 778,100 Other Revenue 1,300,217 Licenses, Permits and Fees 12,397,400 Fines and Forfeitures 3,897,500 Charges for Services 10,077,550 Fund 100 - GENERAL FUND REVENUE Property Taxes 28,849,196 Other Taxes 49,742,274 April 2018 Financial Report Through 04/30/18 2018 Classification Budget Run by Kate LewisLakin on 05/25/2018 11:05:05 AM Page 1 of 35 April YTD 2017 2018 2018 Actuals 7,578 499,852 933,020 - - - - - - - - - - - - - - - - - - 4,052 9,837 33,019 - - - - - - - - - 290 610 1,548 - - - - - - 11,921 510,299 967,586 30,194 114,762 324,972 42,172 174,029 579,392 - - - - - - - - - - - - - - - - - - 70 60 5,110 - - - 72,435 288,851 909,475 11,921 510,299 967,586 72,435 288,851 909,475 (60,515) 221,448 58,111 Starting Fund Balance 644,499 644,499 Net Change (312,421) 221,448 Ending Fund Balance 332,078 865,947 REVENUE TOTALS 953,500 EXPENSE TOTALS 1,265,921 Fund 175 - GENERAL ASSISTANCE FUND (312,421) EXPENSE TOTALS 1,265,921 Fund 175 - GENERAL ASSISTANCE FUND Debt Service - Miscellaneous 7,000 Interfund Transfers - Community Sponsored Organizations - Depreciation Expense - Contingencies - Services and Supplies 858,200 Capital Outlay - Insurance and Other Chargebacks - REVENUE TOTALS 953,500 EXPENSE Salary and Benefits 400,721 Interest Income 1,000 Special Assessment - Reappropriation of Surplus - Workers Compensation and Liability - Insurance - Library Revenue - Interfund Transfers - Intergovernmental Revenue - Other Revenue 27,500 Licenses, Permits and Fees - Fines and Forfeitures - Charges for Services - Fund 175 - GENERAL ASSISTANCE FUND REVENUE Property Taxes 925,000 Other Taxes - April 2018 Financial Report Through 04/30/18 2018 Classification Budget Run by Kate LewisLakin on 05/25/2018 11:05:05 AM Page 2 of 35 April YTD 2017 2018 2018 Actuals - - - 69,039 276,157 859,153 - - - - - - 8 27 14 69,048 276,184 859,167 - - 22,593 14,400 14,400 121 - - - 180,313 215,146 918,074 2,500 2,500 - 197,213 232,046 940,789 69,048 276,184 859,167 197,213 232,046 940,789 (128,165) 44,138 (81,622) Starting Fund Balance 11,777 11,777 Net Change (30,682) 44,138 Ending Fund Balance (18,905) 55,915 Fund 176 - HEALTH AND HUMAN SERVICES (30,682) Fund 176 - HEALTH AND HUMAN SERVICES REVENUE TOTALS 828,471 EXPENSE TOTALS 859,153 Miscellaneous - EXPENSE TOTALS 859,153 Services and Supplies 859,153 Capital Outlay - Community Sponsored Organizations - REVENUE TOTALS 828,471 EXPENSE Salary and Benefits - Intergovernmental Revenue - Other Revenue - Interest Income - Fund 176 - HEALTH AND HUMAN SERVICES REVENUE Charges for Services - Interfund Transfers 828,471 April 2018 Financial Report Through 04/30/18 2018 Classification Budget Run by Kate LewisLakin on 05/25/2018 11:05:05 AM Page 3 of 35 April YTD 2017 2018 2018 Actuals - - 1,000,000 168 403 1,884 168 403 1,001,884 83,333 333,333 1,000,000 83,333 333,333 1,000,000 168 403 1,001,884 83,333 333,333 1,000,000 (83,165) (332,930) 1,884 Starting Fund Balance 1,884 1,884 Net Change - (332,930) Ending Fund Balance 1,884 (331,046) REVENUE TOTALS 1,000,000 EXPENSE TOTALS 1,000,000 Fund 180 - GOOD NEIGHBOR FUND Totals - EXPENSE TOTALS 1,000,000 Fund 180 - GOOD NEIGHBOR FUND Totals REVENUE TOTALS 1,000,000 EXPENSE Interfund Transfers 1,000,000 Fund 180 - GOOD NEIGHBOR FUND REVENUE Other Revenue 1,000,000 Interest Income - April 2018 Financial Report Through 04/30/18 2018 Classification Budget Run by Kate LewisLakin on 05/25/2018 11:05:05 AM Page 4 of 35 April YTD 2017 2018 2018 Actuals 47,066 3,419,927 6,370,507 - - - 11,272 43,178 122,862 25 105 338 5,833 23,333 190,200 58,303 94,861 74,206 5,991 21,305 70,807 2,745 90,899 362,608 1,317 2,239 5,169 132,553 3,695,847 7,196,696 382,000 1,450,144 4,739,145 178,909 444,017 1,712,359 - - 9,904 - - - - - - - - - - - - - - 22 30,579 122,316 343,618 591,488 2,016,478 6,805,048 132,553 3,695,847 7,196,696 591,488 2,016,478 6,805,048 (458,935) 1,679,369 391,648 Starting Fund Balance 984,772 984,772 Net Change 221,912 1,679,369 Ending Fund Balance 1,206,684 2,664,141 REVENUE TOTALS 7,693,209 EXPENSE TOTALS 7,471,297 Fund 185 - LIBRARY FUND Totals 221,912 EXPENSE TOTALS 7,471,297 Fund 185 - LIBRARY FUND Totals Debt Service - Miscellaneous - Interfund Transfers 366,949 Insurance and Other Chargebacks - Depreciation Expense - Contingencies - Salary and Benefits 5,089,260 Services and Supplies 2,004,688 Capital Outlay 10,400 Interest Income 5,400 REVENUE TOTALS 7,693,209 EXPENSE Intergovernmental Revenue 152,418 Other Revenue 130,000 Library Revenue 324,620 Fines and Forfeitures 130,000 Charges for Services - Interfund Transfers 265,771 Fund 185 - LIBRARY FUND REVENUE Property Taxes 6,685,000 Other Taxes - April 2018 Financial Report Through 04/30/18 2018 Classification Budget Run by Kate LewisLakin on 05/25/2018 11:05:05 AM Page 5 of 35 April YTD 2017 2018 2018 Actuals 2,641 156,995 338,897 - - 778,745 - - 7 2,641 156,995 1,117,649 - - 8,587 - - - - - 1,134,570 - - - - - 112 - - 1,143,269 2,641 156,995 1,117,649 - - 1,143,269 2,641 156,995 (25,619) Starting Fund Balance 4,202 4,202 Net Change 12,386 156,995 Ending Fund Balance 16,588 161,197 EXPENSE TOTALS 333,404 Fund 186 - LIBRARY DEBT SERVICE FUND 12,386 Fund 186 - LIBRARY DEBT SERVICE FUND REVENUE TOTALS 345,790 Miscellaneous - Interfund Transfers - EXPENSE TOTALS 333,404 Services and Supplies - Capital Outlay - Debt Service 333,404 Interest Income - REVENUE TOTALS 345,790 EXPENSE Fund 186 - LIBRARY DEBT SERVICE FUND REVENUE Property Taxes 345,790 Other Revenue - April 2018 Financial Report Through 04/30/18 2018 Classification Budget Run by Kate LewisLakin on 05/25/2018 11:05:05 AM Page 6 of 35 April YTD 2017 2018 2018 Actuals - - - - - 1,431,106 - - - - - 1,431,106 - - 30,790 - - 1,091,917 - - - - - - - - 1,122,708 - - 1,431,106 - - 1,122,708 - - 308,399 Starting Fund Balance 308,399 308,399 Net Change - - Ending Fund Balance 308,399 308,399 Fund 187 - LIBRARY CAPITAL IMPROVEMENT - Fund 187 - LIBRARY CAPITAL IMPROVEMENT REVENUE TOTALS 10,095,000 EXPENSE TOTALS 10,095,000 Interfund Transfers - EXPENSE TOTALS 10,095,000 Services and Supplies - Capital Outlay 10,095,000 Debt Service - Interest Income - REVENUE TOTALS 10,095,000 EXPENSE Fund 187 - LIBRARY CAPITAL IMPROVEMENT FD REVENUE Property Taxes - Other Revenue 10,095,000 April 2018 Financial Report Through 04/30/18 2018 Classification Budget Run by Kate LewisLakin on 05/25/2018 11:05:05 AM Page 7 of 35 April YTD 2017 2018 2018 Actuals - - - 6,617 6,617 37,641 - - - 22 53 - 6,639 6,670 37,641 2,132 7,973 26,454 - 1,860 1,860 4,873 4,873 2,642 - - (233) - - - 1,744 1,744 2,400 388 1,551 4,518 9,138 18,001 37,641 6,639 6,670 37,641 9,138 18,001 37,641 (2,498) (11,331) - Starting Fund Balance (2,442) (2,442) Net Change 326 (11,331) Ending Fund Balance (2,116) (13,773) EXPENSE TOTALS 94,821 Fund 195 - NEIGHBORHOOD STABILIZATION 326 Fund 195 - NEIGHBORHOOD STABILIZATION REVENUE TOTALS 95,147 Miscellaneous 50,000 Interfund Transfers 4,654 EXPENSE TOTALS 94,821 Capital Outlay 7,000 Insurance and Other Chargebacks - Debt Service - EXPENSE Salary and Benefits 28,067 Services and Supplies 5,100 Other Revenue - Interest Income - REVENUE TOTALS 95,147 Fund 195 - NEIGHBORHOOD STABILIZATION FUND REVENUE Licenses, Permits and Fees - Intergovernmental Revenue 95,147 April 2018 Financial Report Through 04/30/18 2018 Classification Budget Run by Kate LewisLakin on 05/25/2018 11:05:05 AM Page 8 of 35 April YTD 2017 2018 2018 Actuals 144,718 623,800 1,899,884 - - - 3,219 13,024 18,158 - - - 147,937 636,824 1,918,041 - - - 125,000 500,000 - - - - - - - - - - 79,833 319,330 957,990 204,833 819,330 957,990 147,937 636,824 1,918,041 204,833 819,330 957,990 (56,896) (182,506) 960,051 Starting Fund Balance 2,373,729 2,373,729 Net Change (535,990) (182,506) Ending Fund Balance 1,837,739 2,191,223 Fund 200 - MOTOR FUEL TAX FUND Totals (535,990) Fund 200 - MOTOR FUEL TAX FUND Totals REVENUE TOTALS 1,922,000 EXPENSE TOTALS 2,457,990 Interfund Transfers 957,990 EXPENSE TOTALS 2,457,990 Contingencies - Debt Service - Miscellaneous - EXPENSE Services and Supplies - Capital Outlay 1,500,000 Interest Income 12,000 Reappropriation of Surplus - REVENUE TOTALS 1,922,000 Fund 200 - MOTOR FUEL TAX FUND REVENUE Intergovernmental Revenue 1,910,000 Other Revenue - April 2018 Financial Report Through 04/30/18 2018 Classification Budget Run by Kate LewisLakin on 05/25/2018 11:05:05 AM Page 9 of 35 April YTD 2017 2018 2018 Actuals 88,320 317,520 978,523 - - - - 863 - 1,462 2,998 7,178 89,782 321,380 985,701 50,246 181,602 585,510 4,814 38,599 239,161 - - 51,670 1,454 5,816 17,448 - - - - - - - - - - - - 6,114 24,455 72,977 62,628 250,472 966,766 89,782 321,380 985,701 62,628 250,472 966,766 27,154 70,908 18,935 Starting Fund Balance 185,493 185,493 Net Change 8,262 70,908 Ending Fund Balance 193,755 256,401 Fund 205 - EMERGENCY TELEPHONE (E911) 8,262 Fund 205 - EMERGENCY TELEPHONE (E911) REVENUE TOTALS 1,051,700 EXPENSE TOTALS 1,043,438 Interfund Transfers 73,366 EXPENSE TOTALS 1,043,438 Contingencies - Debt Service - Miscellaneous - Capital Outlay 55,000 Insurance and Other Chargebacks 17,448 Community Sponsored Organizations - EXPENSE Salary and Benefits 615,224 Services and Supplies 282,400 Other Revenue - Interest Income 1,000 REVENUE TOTALS 1,051,700 Fund 205 - EMERGENCY TELEPHONE (E911) FUND REVENUE Other Taxes 1,050,700 Intergovernmental Revenue - April 2018 Financial Report Through 04/30/18 2018 Classification Budget Run by Kate LewisLakin on 05/25/2018 11:05:05 AM Page 10 of 35 April YTD 2017 2018 2018 Actuals 3,517 159,953 322,477 7 24 5 3,524 159,977 322,482 92,500 92,500 329,000 - - - - - - 92,500 92,500 329,000 3,524 159,977 322,482 92,500 92,500 329,000 (88,976) 67,477 (6,518) Starting Fund Balance (198,794) (198,794) Net Change - 67,477 Ending Fund Balance (198,794) (131,317) EXPENSE TOTALS 370,000 Fund 210 - SPECIAL SERVICE AREA (SSA) #4 - Fund 210 - SPECIAL SERVICE AREA (SSA) #4 REVENUE TOTALS 370,000 Debt Service - Miscellaneous - EXPENSE TOTALS 370,000 REVENUE TOTALS 370,000 EXPENSE Services and Supplies 370,000 Fund 210 - SPECIAL SERVICE AREA (SSA) #4 REVENUE Property Taxes 370,000 Interest Income - April 2018 Financial Report Through 04/30/18 2018 Classification Budget Run by Kate LewisLakin on 05/25/2018 11:05:05 AM Page 11 of 35 April YTD 2017 2018 2018 Actuals - - - - - - 10,895 10,895 1,906,708 - 713 262 - - - 10,895 11,608 1,906,970 35,035 124,560 431,440 23 3,345 3,797 3,664 14,558 645,289 1,454 5,816 392,279 - - 318,412 - - - - - - - 4,551 95,606 746 2,985 20,145 40,922 155,815 1,906,970 10,895 11,608 1,906,970 40,922 155,815 1,906,970 (30,027) (144,207) - Starting Fund Balance 64,094 64,094 Net Change (109,388) (144,207) Ending Fund Balance (45,294) (80,113) EXPENSE TOTALS 2,439,512 Fund 215 - CDBG FUND Totals (109,388) Fund 215 - CDBG FUND Totals REVENUE TOTALS 2,330,124 Miscellaneous 569,970 Interfund Transfers 949,656 EXPENSE TOTALS 2,439,512 Community Sponsored Organizations 175,500 Contingencies - Debt Service - Services and Supplies 220,840 Capital Outlay - Insurance and Other Chargebacks 20,648 REVENUE TOTALS 2,330,124 EXPENSE Salary and Benefits 502,898 Intergovernmental Revenue 2,330,124 Other Revenue - Interest Income - Fund 215 - CDBG FUND REVENUE Charges for Services - Interfund Transfers - April 2018 Financial Report Through 04/30/18 2018 Classification Budget Run by Kate LewisLakin on 05/25/2018 11:05:05 AM Page 12 of 35 April YTD 2017 2018 2018 Actuals - - - 2,703 11,712 51,369 66 246 3,391 2,769 11,959 54,760 - - - - 41,672 13,070 - - - - - - - 41,672 13,070 2,769 11,959 54,760 - 41,672 13,070 2,769 (29,714) 41,690 Starting Fund Balance 252,611 252,611 Net Change - (29,714) Ending Fund Balance 252,611 222,897 Fund 220 - CDBG LOAN FUND Totals - Fund 220 - CDBG LOAN FUND Totals REVENUE TOTALS 293,000 EXPENSE TOTALS 293,000 Interfund Transfers - EXPENSE TOTALS 293,000 Salary and Benefits - Services and Supplies 293,000 Miscellaneous - Interest Income - REVENUE TOTALS 293,000 EXPENSE Fund 220 - CDBG LOAN FUND REVENUE Intergovernmental Revenue - Other Revenue 293,000 April 2018 Financial Report Through 04/30/18 2018 Classification Budget Run by Kate LewisLakin on 05/25/2018 11:05:05 AM Page 13 of 35 April YTD 2017 2018 2018 Actuals - - - - - - 31 69 256 31 69 256 - - - - - - - - - - - - - - - - - - 31 69 256 - - - 31 69 256 Starting Fund Balance 170,171 170,171 Net Change (100,000) 69 Ending Fund Balance 70,171 170,240 EXPENSE TOTALS 100,000 Fund 235 - NEIGHBORHOOD IMPROVEMENT (100,000) Fund 235 - NEIGHBORHOOD IMPROVEMENT REVENUE TOTALS - Miscellaneous 100,000 Interfund Transfers - EXPENSE TOTALS 100,000 Services and Supplies - Capital Outlay - Debt Service - Interest Income - REVENUE TOTALS - EXPENSE Fund 235 - NEIGHBORHOOD IMPROVEMENT REVENUE Other Taxes - Interfund Transfers - April 2018 Financial Report Through 04/30/18 2018 Classification Budget Run by Kate LewisLakin on 05/25/2018 11:05:05 AM Page 14 of 35 April YTD 2017 2018 2018 Actuals 17,369 40,168 227,450 2,282 9,128 21,820 8 25 5,685 19,659 49,321 254,955 2,622 12,405 43,994 17,369 41,258 231,806 - - - 68 273 (27,871) - - - - - - - - 126 - - - 20,059 53,936 248,055 19,659 49,321 254,955 20,059 53,936 248,055 (400) (4,615) 6,900 Starting Fund Balance 9,277 9,277 Net Change 615 (4,615) Ending Fund Balance 9,892 4,662 EXPENSE TOTALS 588,321 Fund 240 - HOME FUND Totals 615 Fund 240 - HOME FUND Totals REVENUE TOTALS 588,936 Miscellaneous 500 Interfund Transfers - EXPENSE TOTALS 588,321 Insurance and Other Chargebacks 820 Community Sponsored Organizations - Debt Service - Salary and Benefits 46,801 Services and Supplies 540,200 Capital Outlay - Interest Income - REVENUE TOTALS 588,936 EXPENSE Fund 240 - HOME FUND REVENUE Intergovernmental Revenue 588,936 Other Revenue - April 2018 Financial Report Through 04/30/18 2018 Classification Budget Run by Kate LewisLakin on 05/25/2018 11:05:05 AM Page 15 of 35 April YTD 2017 2018 2018 Actuals - 10,000 97,000 - - - - - - 31,667 64,167 333,056 1,030 2,279 5,623 32,697 76,446 435,678 4,959 24,847 44,432 - - 209,772 - - - - - 11,532 - 2,398 8,927 - - - 1,330 2,230 85,660 - - - 6,289 29,475 360,323 32,697 76,446 435,678 6,289 29,475 360,323 26,408 46,971 75,355 Starting Fund Balance 1,476,543 1,476,543 Net Change (38,470) 46,971 Ending Fund Balance 1,438,073 1,523,514 Fund 250 - AFFORDABLE HOUSING FUND (38,470) Fund 250 - AFFORDABLE HOUSING FUND REVENUE TOTALS 450,830 EXPENSE TOTALS 489,300 Interfund Transfers - EXPENSE TOTALS 489,300 Community Sponsored Organizations 70,000 Debt Service - Miscellaneous 43,000 Services and Supplies 279,500 Capital Outlay - Insurance and Other Chargebacks - REVENUE TOTALS 450,830 EXPENSE Salary and Benefits 96,800 Intergovernmental Revenue - Other Revenue 400,600 Interest Income 230 Fund 250 - AFFORDABLE HOUSING FUND REVENUE Other Taxes 50,000 Interfund Transfers - April 2018 Financial Report Through 04/30/18 2018 Classification Budget Run by Kate LewisLakin on 05/25/2018 11:05:05 AM Page 16 of 35 April YTD 2017 2018 2018 Actuals 15,150 2,974,454 5,249,949 - - - - - - - - - 5,040 11,652 45,924 20,190 2,986,106 5,295,873 - - - - - 2,007 - - - - - - 24,668 24,668 98,672 592,253 2,369,013 5,557,325 616,921 2,393,681 5,658,005 20,190 2,986,106 5,295,873 616,921 2,393,681 5,658,005 (596,731) 592,425 (362,132) Starting Fund Balance 5,262,544 5,262,544 Net Change (3,437,040) 592,425 Ending Fund Balance 1,825,504 5,854,969 EXPENSE TOTALS 9,207,040 Fund 300 - WASHINGTON NATIONAL TIF (3,437,040) Fund 300 - WASHINGTON NATIONAL TIF REVENUE TOTALS 5,770,000 Miscellaneous 100,000 Interfund Transfers 7,107,040 EXPENSE TOTALS 9,207,040 Services and Supplies 2,000,000 Capital Outlay - Debt Service - REVENUE TOTALS 5,770,000 EXPENSE Salary and Benefits - Interfund Transfers - Other Revenue - Interest Income 20,000 Fund 300 - WASHINGTON NATIONAL TIF FUND REVENUE Property Taxes 5,750,000 Other Taxes - April 2018 Financial Report Through 04/30/18 2018 Classification Budget Run by Kate LewisLakin on 05/25/2018 11:05:05 AM Page 17 of 35 April YTD 2017 2018 2018 Actuals 61,869 4,825,990 10,797,411 288,930 1,155,718 2,895,561 7,219 28,875 83,293 - - 8,883,103 2,365 11,079 36,782 360,382 6,021,662 22,696,150 - - 100,625 - - 23,099,797 - - (57) - - - - - 23,200,365 360,382 6,021,662 22,696,150 - - 23,200,365 360,382 6,021,662 (504,215) Starting Fund Balance 196,457 196,457 Net Change 274,759 6,021,662 Ending Fund Balance 471,216 6,218,119 REVENUE TOTALS 14,572,016 EXPENSE TOTALS 14,297,257 Fund 320 - DEBT SERVICE FUND Totals 274,759 EXPENSE TOTALS 14,297,257 Fund 320 - DEBT SERVICE FUND Totals Debt Service 14,177,257 Miscellaneous - Interfund Transfers - REVENUE TOTALS 14,572,016 EXPENSE Services and Supplies 120,000 Intergovernmental Revenue 83,292 Other Revenue - Interest Income 1,500 Fund 320 - DEBT SERVICE FUND REVENUE Property Taxes 10,879,993 Interfund Transfers 3,607,231 April 2018 Financial Report Through 04/30/18 2018 Classification Budget Run by Kate LewisLakin on 05/25/2018 11:05:05 AM Page 18 of 35 April YTD 2017 2018 2018 Actuals - 318,714 583,827 8,246 9,259 32,000 57 62 22 8,303 328,035 615,848 227,068 227,194 307,391 125,000 500,000 - - - - - - - 111 414 995 - - - 5,000 20,000 60,000 357,178 747,608 368,386 8,303 328,035 615,848 357,178 747,608 368,386 (348,875) (419,573) 247,462 Starting Fund Balance 273,878 273,878 Net Change (296,100) (419,573) Ending Fund Balance (22,222) (145,695) Fund 330 - HOWARD-RIDGE TIF FUND Totals (296,100) Fund 330 - HOWARD-RIDGE TIF FUND Totals REVENUE TOTALS 4,385,400 EXPENSE TOTALS 4,681,500 Interfund Transfers 60,000 EXPENSE TOTALS 4,681,500 Community Sponsored Organizations - Debt Service 960,000 Miscellaneous - Services and Supplies 461,500 Capital Outlay 3,200,000 Insurance and Other Chargebacks - Interest Income 400 REVENUE TOTALS 4,385,400 EXPENSE Fund 330 - HOWARD-RIDGE TIF FUND REVENUE Property Taxes 605,000 Other Revenue 3,780,000 April 2018 Financial Report Through 04/30/18 2018 Classification Budget Run by Kate LewisLakin on 05/25/2018 11:05:05 AM Page 19 of 35 April YTD 2017 2018 2018 Actuals 2,630 41,921 43,503 1,028 3,085 12,339 661 2,036 3,898 4,320 47,041 59,741 - - 2,007 - - - - - - - - - 1,359 5,090 12,227 - - - 2,500 10,000 30,000 3,859 15,090 44,235 4,320 47,041 59,741 3,859 15,090 44,235 460 31,951 15,506 Starting Fund Balance 432,766 432,766 Net Change (39,850) 31,951 Ending Fund Balance 392,916 464,717 Fund 335 - WEST EVANSTON TIF FUND Totals (39,850) Fund 335 - WEST EVANSTON TIF FUND Totals REVENUE TOTALS 150 EXPENSE TOTALS 40,000 Interfund Transfers 30,000 EXPENSE TOTALS 40,000 Contingencies - Debt Service 10,000 Miscellaneous - Services and Supplies - Capital Outlay - Insurance and Other Chargebacks - Interest Income 150 REVENUE TOTALS 150 EXPENSE Fund 335 - WEST EVANSTON TIF FUND REVENUE Property Taxes - Other Revenue - April 2018 Financial Report Through 04/30/18 2018 Classification Budget Run by Kate LewisLakin on 05/25/2018 11:05:05 AM Page 20 of 35 April YTD 2017 2018 2018 Actuals - 26,401 48,001 - - 2,067,512 - 3 1 - 26,404 2,115,514 - - 38,588 - - - - - 2,053,521 - - 2,092,108 - 26,404 2,115,514 - - 2,092,108 - 26,404 23,406 Starting Fund Balance (6,009) (6,009) Net Change 202,334 26,404 Ending Fund Balance 196,325 20,395 REVENUE TOTALS 275,000 EXPENSE TOTALS 72,666 Fund 340 - DEMPSTER-DODGE TIF FUND 202,334 EXPENSE TOTALS 72,666 Fund 340 - DEMPSTER-DODGE TIF FUND Services and Supplies - Capital Outlay - Debt Service 72,666 Interest Income - REVENUE TOTALS 275,000 EXPENSE Fund 340 - DEMPSTER-DODGE TIF FUND REVENUE Property Taxes 275,000 Other Revenue - April 2018 Financial Report Through 04/30/18 2018 Classification Budget Run by Kate LewisLakin on 05/25/2018 11:05:05 AM Page 21 of 35 April YTD 2017 2018 2018 Actuals 2,995 31,307 75,430 - - 3,520,189 1 4 9 2,996 31,310 3,595,628 - - 58,113 - - 580,000 - - 3,031,398 - - 3,669,511 2,996 31,310 3,595,628 - - 3,669,511 2,996 31,310 (73,884) Starting Fund Balance 61,193 61,193 Net Change 316,001 31,310 Ending Fund Balance 377,194 92,503 REVENUE TOTALS 425,000 EXPENSE TOTALS 108,999 Fund 345 - CHICAGO-MAIN TIF Totals 316,001 EXPENSE TOTALS 108,999 Fund 345 - CHICAGO-MAIN TIF Totals Services and Supplies - Capital Outlay - Debt Service 108,999 Interest Income - REVENUE TOTALS 425,000 EXPENSE Fund 345 - CHICAGO-MAIN TIF REVENUE Property Taxes 425,000 Other Revenue - April 2018 Financial Report Through 04/30/18 2018 Classification Budget Run by Kate LewisLakin on 05/25/2018 11:05:05 AM Page 22 of 35 April YTD 2017 2018 2018 Actuals 2,298 115,527 215,245 8 17 21 2,306 115,544 215,266 - - 213,354 - - 78,000 - - 291,354 2,306 115,544 215,266 - - 291,354 2,306 115,544 (76,088) Starting Fund Balance 2,206 2,206 Net Change - 115,544 Ending Fund Balance 2,206 117,750 Fund 350 - SPECIAL SERVICE AREA (SSA) #6 - Fund 350 - SPECIAL SERVICE AREA (SSA) #6 REVENUE TOTALS 221,500 EXPENSE TOTALS 221,500 Interfund Transfers - EXPENSE TOTALS 221,500 REVENUE TOTALS 221,500 EXPENSE Services and Supplies 221,500 Fund 350 - SPECIAL SERVICE AREA (SSA) #6 REVENUE Property Taxes 221,000 Interest Income 500 April 2018 Financial Report Through 04/30/18 2018 Classification Budget Run by Kate LewisLakin on 05/25/2018 11:05:05 AM Page 23 of 35 April YTD 2017 2018 2018 Actuals - - 359,706 - - 33,339 536,667 2,146,667 787,177 - - 530,812 - - 11,246,149 7,654 33,965 56,607 544,321 2,180,632 13,013,790 51,108 182,351 5,392 60,830 154,307 1,672,608 875,375 2,157,155 13,582,482 - - - - - - 41,667 166,667 500,000 1,028,979 2,660,479 15,760,481 544,321 2,180,632 13,013,790 1,028,979 2,660,479 15,760,481 (484,658) (479,847) (2,746,691) Starting Fund Balance 9,447,356 9,447,356 Net Change (7,655,527) (479,847) Ending Fund Balance 1,791,829 8,967,509 REVENUE TOTALS 22,642,000 EXPENSE TOTALS 30,297,527 Fund 415 - CAPITAL IMPROVEMENTS FUND (7,655,527) EXPENSE TOTALS 30,297,527 Fund 415 - CAPITAL IMPROVEMENTS FUND Debt Service - Miscellaneous - Interfund Transfers 500,000 Salary and Benefits 85,527 Services and Supplies - Capital Outlay 29,712,000 Interest Income - REVENUE TOTALS 22,642,000 EXPENSE Interfund Transfers 6,450,000 Intergovernmental Revenue 4,190,000 Other Revenue 12,002,000 Fund 415 - CAPITAL IMPROVEMENTS FUND REVENUE Licenses, Permits and Fees - Charges for Services - April 2018 Financial Report Through 04/30/18 2018 Classification Budget Run by Kate LewisLakin on 05/25/2018 11:05:05 AM Page 24 of 35 April YTD 2017 2018 2018 Actuals - - 649,512 - - 900,000 - - - - - 1,549,512 175,128 321,927 638,727 11,770 11,770 369,924 - - - 186,897 333,696 1,008,651 - - 1,549,512 186,897 333,696 1,008,651 (186,897) (333,696) 540,861 Starting Fund Balance 540,681 540,681 Net Change 1,866,000 (333,696) Ending Fund Balance 2,406,681 206,985 REVENUE TOTALS 11,500,000 EXPENSE TOTALS 9,634,000 Fund 416 - CROWN CONSTRUCTION FUND 1,866,000 EXPENSE TOTALS 9,634,000 Fund 416 - CROWN CONSTRUCTION FUND Services and Supplies 1,634,000 Capital Outlay 8,000,000 Interfund Transfers - Interest Income - REVENUE TOTALS 11,500,000 EXPENSE Fund 416 - CROWN CONSTRUCTION FUND REVENUE Interfund Transfers - Other Revenue 11,500,000 April 2018 Financial Report Through 04/30/18 2018 Classification Budget Run by Kate LewisLakin on 05/25/2018 11:05:05 AM Page 25 of 35 April YTD 2017 2018 2018 Actuals - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 1,764 16,151 31,207 14,033 104,707 237,012 - - - 15,797 120,858 268,219 5,558 20,886 694 - - 5,613 - - - - - - - - - - - - 42,786 171,142 263,427 48,344 192,028 269,734 15,797 120,858 268,219 48,344 192,028 269,734 (32,547) (71,169) (1,516) Starting Fund Balance 2,997,700 2,997,700 Net Change (123,850) (71,169) Ending Fund Balance 2,873,850 2,926,531 REVENUE TOTALS 461,367 EXPENSE TOTALS 585,217 Fund 420 - SPECIAL ASSESSMENT FUND (123,850) EXPENSE TOTALS 585,217 Fund 420 - SPECIAL ASSESSMENT FUND Debt Service - Miscellaneous - Interfund Transfers 513,427 Services and Supplies - Capital Outlay - Insurance and Other Chargebacks - REVENUE TOTALS 461,367 EXPENSE Salary and Benefits 71,790 Interest Income 31,200 Special Assessment 180,167 Reappropriation of Surplus - Workers Compensation and Liability - Insurance - Library Revenue - Interfund Transfers - Intergovernmental Revenue - Other Revenue 250,000 Licenses, Permits and Fees - Fines and Forfeitures - Charges for Services - Fund 420 - SPECIAL ASSESSMENT FUND REVENUE Property Taxes - Other Taxes - April 2018 Financial Report Through 04/30/18 2018 Classification Budget Run by Kate LewisLakin on 05/25/2018 11:05:05 AM Page 26 of 35 April YTD 2017 2018 2018 %Actuals - 1,813 0.0% 1,900 1,213,735 2,803,478 42.0% 6,184,922 347,253 1,389,013 32.9% 4,120,636 - - 0.0% - 13,095 79,281 41.0% 253,523 4,255 13,035 37.2% 62,067 1,578,339 4,286,619 38.5% 10,623,048 138,768 506,009 27.4% 1,675,404 87,330 445,766 12.9% 3,172,070 135,568 143,821 5.9% 280,311 26,637 106,549 33.3% 319,648 - - 0.0% 2,561,771 - - 0.0% 4,246 - - 0.0% 267,734 - 39,103 12.9% 267,436 120,035 480,139 33.3% 1,584,683 508,338 1,721,388 13.3% 10,133,302 1,578,339 4,286,619 38.5% 10,623,048 508,338 1,721,388 13.3% 10,133,302 1,070,001 2,565,231 489,746 Starting Fund Balance 4,909,402 4,909,402 Net Change (1,762,367) 2,565,231 Ending Fund Balance 3,147,035 7,474,633 EXPENSE TOTALS 12,896,493 Fund 505 - PARKING SYSTEM FUND Totals (1,762,367) Fund 505 - PARKING SYSTEM FUND Totals REVENUE TOTALS 11,134,126 EXPENSE TOTALS 12,896,493 Debt Service 3,070,625 Miscellaneous 304,000 Interfund Transfers 1,440,417 Insurance and Other Chargebacks 319,648 Depreciation Expense - Contingencies 11,000 Salary and Benefits 1,849,028 Services and Supplies 3,451,775 Capital Outlay 2,450,000 Interest Income 35,070 REVENUE TOTALS 11,134,126 EXPENSE Interfund Transfers 4,217,040 Intergovernmental Revenue 12,125 Other Revenue 193,316 Fund 505 - PARKING SYSTEM FUND REVENUE Licenses, Permits and Fees - Charges for Services 6,676,575 April 2018 Financial Report Through 04/30/18 2018 Classification Budget Run by Kate LewisLakin on 05/25/2018 11:05:05 AM Page 27 of 35 April YTD 2017 2018 2018 %Actuals 8,617 13,022 18.6% 86,063 1,472,532 6,119,107 33.5% 17,255,947 19,436 31,780 0.1% 294,812 16,190 45,345 181.4% 35,784 1,516,776 6,209,253 13.6% 17,672,605 422,525 1,580,773 28.2% 5,958,873 198,033 607,375 13.0% 2,528,863 33,400 145,794 0.5% 11,408 39,041 156,164 33.3% 468,492 - - 0.0% - - - 0.0% 2,470,280 33,752 33,752 1.7% 717,388 - - 0.0% (203,530) 306,859 1,227,436 34.1% 7,360,654 1,033,611 3,751,295 8.2% 19,312,428 1,516,776 6,209,253 13.6% 17,672,605 1,033,611 3,751,295 8.2% 19,312,428 483,164 2,457,959 (1,639,823) Starting Fund Balance 7,324,987 7,324,987 Net Change 32,150 2,457,959 Ending Fund Balance 7,357,137 9,782,946 Fund 510 - WATER FUND Totals 32,150 Fund 510 - WATER FUND Totals REVENUE TOTALS 45,695,656 Interfund Transfers 3,602,313 EXPENSE TOTALS 45,663,506 EXPENSE TOTALS 45,663,506 Depreciation Expense - Debt Service 1,960,760 Miscellaneous 15,000 Services and Supplies 4,655,410 Capital Outlay 29,346,200 Insurance and Other Chargebacks 468,492 25,000 REVENUE TOTALS 45,695,656 EXPENSE Salary and Benefits 5,614,331 Contingencies 1,000 April 2018 Financial Report Through 04/30/18 2018 Classification Budget Fund 510 - WATER FUND REVENUE Licenses, Permits and Fees 70,000 Charges for Services 18,267,000 Other Revenue 27,333,656 Interest Income Run by Kate LewisLakin on 05/25/2018 11:05:05 AM Page 28 of 35 April YTD 2017 2018 2018 %Actuals 1,027,577 4,724,553 37.5% 12,477,657 - - 0.0% 14,870 2,413 9,450 189.0% 16,023 1,029,989 4,734,003 32.2% 12,508,550 101,367 379,098 29.7% 1,313,154 7,875 15,634 0.6% 88,677 48,690 58,703 2.7% 7,676 22,499 89,996 33.3% 269,988 - - 0.0% 3,530,787 266,839 2,113,770 28.0% 1,143,643 - - 0.0% 9,265 82,640 330,559 33.3% 1,141,676 529,910 2,987,760 20.2% 7,504,867 1,029,989 4,734,003 32.2% 12,508,550 529,910 2,987,760 20.2% 7,504,867 500,079 1,746,243 5,003,683 Starting Fund Balance 4,149,927 4,149,927 Net Change (119,220) 1,746,243 Ending Fund Balance 4,030,707 5,896,170 Fund 515 - SEWER FUND Totals (119,220) Fund 515 - SEWER FUND Totals REVENUE TOTALS 14,698,650 EXPENSE TOTALS 14,817,870 Miscellaneous 1,500 Interfund Transfers 991,677 EXPENSE TOTALS 14,817,870 Insurance and Other Chargebacks 269,988 Depreciation Expense - Debt Service 7,540,066 Salary and Benefits 1,274,709 Services and Supplies 2,558,630 Capital Outlay 2,181,300 Interest Income 5,000 REVENUE TOTALS 14,698,650 EXPENSE Fund 515 - SEWER FUND REVENUE Charges for Services 12,589,650 Other Revenue 2,104,000 April 2018 Financial Report Through 04/30/18 2018 Classification Budget Run by Kate LewisLakin on 05/25/2018 11:05:05 AM Page 29 of 35 April YTD 2017 2018 2018 %Actuals - 260,915 63.6% - - 14,448 5.3% 199,513 323,617 1,202,768 33.1% 3,611,308 58,831 235,322 33.3% 755,967 13,172 20,813 8.7% 250,687 - - 0.0% - 395,620 1,734,266 33.0% 4,817,475 72,664 265,172 26.7% 890,220 99,987 770,281 22.1% 3,482,141 2,502 3,936 1.4% 24,635 - - 0.0% 1,797 3,538 3,688 49.2% 3,057 26,864 107,454 33.3% 504,807 205,555 1,150,530 22.5% 4,906,657 395,620 1,734,266 33.0% 4,817,475 205,555 1,150,530 22.5% 4,906,657 190,066 583,736 (89,182) Starting Fund Balance (1,169,015) (1,169,015) Net Change 151,660 583,736 Ending Fund Balance (1,017,355) (585,279) EXPENSE TOTALS 5,109,701 EXPENSE TOTALS 5,109,701 Fund 520 - SOLID WASTE FUND Totals 151,660 Fund 520 - SOLID WASTE FUND Totals REVENUE TOTALS 5,261,361 Debt Service 21,797 Miscellaneous 7,500 Interfund Transfers 322,362 Salary and Benefits 993,616 Services and Supplies 3,488,676 Capital Outlay 275,750 Interest Income - REVENUE TOTALS 5,261,361 EXPENSE Charges for Services 3,632,394 Interfund Transfers 705,967 Other Revenue 238,000 Fund 520 - SOLID WASTE FUND REVENUE Property Taxes 410,000 Licenses, Permits and Fees 275,000 April 2018 Financial Report Through 04/30/18 2018 Classification Budget Run by Kate LewisLakin on 05/25/2018 11:05:05 AM Page 30 of 35 April YTD 2017 2018 2018 Actuals 249,053 996,213 2,478,435 - - - - - - - 6,454 19,016 - 24 339 249,053 1,002,691 2,497,791 81,189 308,158 1,154,569 176,701 614,449 1,736,789 - - - - - - - - - - - - - - - - - - 2,787 11,147 27,833 260,677 933,754 2,919,191 249,053 1,002,691 2,497,791 260,677 933,754 2,919,191 (11,623) 68,937 (421,401) Starting Fund Balance 358,236 358,236 Net Change (192,655) 68,937 Ending Fund Balance 165,581 427,173 EXPENSE TOTALS 3,333,871 Fund 600 - FLEET SERVICES FUND Totals (192,655) Fund 600 - FLEET SERVICES FUND Totals REVENUE TOTALS 3,141,216 Miscellaneous - Interfund Transfers 33,442 EXPENSE TOTALS 3,333,871 Depreciation Expense - Contingencies 450 Debt Service - Services and Supplies 2,230,057 Capital Outlay - Insurance and Other Chargebacks - REVENUE TOTALS 3,141,216 EXPENSE Salary and Benefits 1,069,922 Intergovernmental Revenue - Other Revenue 81,781 Interest Income 1,000 Fund 600 - FLEET SERVICES FUND REVENUE Charges for Services 3,058,435 Interfund Transfers - April 2018 Financial Report Through 04/30/18 2018 Classification Budget Run by Kate LewisLakin on 05/25/2018 11:05:05 AM Page 31 of 35 April YTD 2017 2018 2018 Actuals 111,228 444,911 1,400,057 - - - - - 88,015 107 333 2,128 111,335 445,244 1,490,200 927 3,710 74,539 2,051 327,472 - - - 1,780,829 - - - 2,978 331,182 1,855,367 111,335 445,244 1,490,200 2,978 331,182 1,855,367 108,357 114,062 (365,167) Starting Fund Balance 1,076,977 1,076,977 Net Change (20,147) 114,062 Ending Fund Balance 1,056,830 1,191,039 EXPENSE TOTALS 1,597,977 Fund 601 - EQUIPMENT REPLACEMENT FUND (20,147) Fund 601 - EQUIPMENT REPLACEMENT FUND REVENUE TOTALS 1,577,830 Depreciation Expense - Miscellaneous - EXPENSE TOTALS 1,597,977 EXPENSE Services and Supplies 75,000 Capital Outlay 1,522,977 Other Revenue 210,217 Interest Income - REVENUE TOTALS 1,577,830 Fund 601 - EQUIPMENT REPLACEMENT FUND REVENUE Charges for Services 1,367,613 Interfund Transfers - April 2018 Financial Report Through 04/30/18 2018 Classification Budget Run by Kate LewisLakin on 05/25/2018 11:05:05 AM Page 32 of 35 April YTD 2017 2018 2018 Actuals 13,534 59,418 162,411 - - 2,300,000 - - - 877,693 3,277,469 10,926,377 177,128 688,897 1,032,678 417,041 1,830,170 5,611,626 263 613 382 1,485,660 5,856,567 20,033,473 75,860 251,554 606,021 52,557 253,784 3,594,432 - - - 1,318,177 5,551,925 17,164,869 - - - - - - - - - - - - - - - 803 3,211 9,632 1,447,397 6,060,474 21,374,954 1,485,660 5,856,567 20,033,473 1,447,397 6,060,474 21,374,954 38,262 (203,907) (1,341,481) Starting Fund Balance (5,348,035) (5,348,035) Net Change 653,342 (203,907) Ending Fund Balance (4,694,693) (5,551,942) EXPENSE TOTALS 18,439,931 Fund 605 - INSURANCE FUND Totals 653,342 Fund 605 - INSURANCE FUND Totals REVENUE TOTALS 19,093,273 Miscellaneous - Interfund Transfers 9,632 EXPENSE TOTALS 18,439,931 Depreciation Expense - Contingencies - Debt Service - Capital Outlay - Insurance and Other Chargebacks 15,315,824 Community Sponsored Organizations - EXPENSE Salary and Benefits 729,027 Services and Supplies 2,385,448 Insurance 5,811,177 Interest Income 1,000 REVENUE TOTALS 19,093,273 Intergovernmental Revenue - Other Revenue 10,867,028 Workers Compensation and Liability 2,196,415 Fund 605 - INSURANCE FUND REVENUE Charges for Services 162,411 Interfund Transfers 55,242 April 2018 Financial Report Through 04/30/18 2018 Classification Budget Run by Kate LewisLakin on 05/25/2018 11:05:05 AM Page 33 of 35 April YTD 2017 2018 2018 Actuals - - - - - - - - - 57,146 3,208,515 15,225,459 55,881 495,219 2,065,885 113,027 3,703,734 17,291,343 745,326 2,992,166 8,682,009 - - - - - - - - - - 21,413 136,256 745,326 3,013,579 8,818,265 113,027 3,703,734 17,291,343 745,326 3,013,579 8,818,265 (632,299) 690,155 8,473,079 Starting Fund Balance 79,101,435 79,101,435 Net Change 4,989,947 690,155 Ending Fund Balance 84,091,382 79,791,590 Fund 700 - FIRE PENSION FUND Totals 4,989,947 Fund 700 - FIRE PENSION FUND Totals REVENUE TOTALS 13,784,947 EXPENSE TOTALS 8,795,000 Miscellaneous - EXPENSE TOTALS 8,795,000 Services and Supplies - Community Sponsored Organizations - Debt Service - REVENUE TOTALS 13,784,947 EXPENSE Salary and Benefits 8,795,000 Interfund Transfers 10,000 Other Revenue 9,394,947 Interest Income 4,100,000 Fund 700 - FIRE PENSION FUND REVENUE Property Taxes - Other Taxes 280,000 April 2018 Financial Report Through 04/30/18 2018 Classification Budget Run by Kate LewisLakin on 05/25/2018 11:05:05 AM Page 34 of 35 April YTD 2017 2018 2018 Actuals - - - - - - - - - 241,002 4,053,387 24,497,983 113,103 715,892 2,829,084 354,105 4,769,279 27,327,068 988,794 3,956,863 11,624,574 - - - - - - 48,579 108,817 264,371 1,037,373 4,065,681 11,888,945 354,105 4,769,279 27,327,068 1,037,373 4,065,681 11,888,945 (683,269) 703,599 15,438,122 Starting Fund Balance 121,645,511 121,645,511 Net Change 6,194,704 703,599 Ending Fund Balance 127,840,215 122,349,110 REVENUE TOTALS 18,719,704 EXPENSE TOTALS 12,525,000 Fund 705 - POLICE PENSION FUND Totals 6,194,704 EXPENSE TOTALS 12,525,000 Fund 705 - POLICE PENSION FUND Totals Services and Supplies - Debt Service - Miscellaneous 270,000 REVENUE TOTALS 18,719,704 EXPENSE Salary and Benefits 12,255,000 Interfund Transfers 57,000 Other Revenue 12,162,704 Interest Income 6,500,000 Fund 705 - POLICE PENSION FUND REVENUE Property Taxes - Other Taxes - April 2018 Financial Report Through 04/30/18 2018 Classification Budget Run by Kate LewisLakin on 05/25/2018 11:05:05 AM Page 35 of 35