Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2017.03 March Monthly Report
To: Wally Bobkiewicz, City Manager Martin Lyons, Assistant City Manager/Chief Financial Officer From: Ashley King, Finance & Budget Manager Subject: March 2017 Monthly Financial Report Date: April 24, 2017 Please find attached the unaudited financial statements as of March 31, 2017. A summary by fund for revenues, expenditures, fund and cash balances is as follows: YTD Revenues YTD Expenses YTD Net Fund Balance Cash Balance 33,797,810 28,860,790 4,937,020 19,734,012 11,561,044 214,788 121 214,667 250,067 285,473 451,875 200,404 251,471 836,116 837,859 1,000,000 250,000 750,000 750,000 750,000 3,375,148 1,401,264 1,973,884 2,734,702 2,625,046 29 8,845 (8,816)(37,105)123,594 507,284 214,498 292,786 1,706,464 1,529,763 234,250 187,666 46,584 58,888 (7,502) 157,151 - 157,151 (35,125)(35,125) - 106,562 (106,562)(42,456)(42,456) 19,287 1,270 18,017 175,678 228,938 - - - 169,915 169,915 6,973 30,371 (23,398)(21,021)(21,020) 43,416 20,076 23,340 1,424,263 1,424,529 - - - 16,803 16,803 2,417,651 87,500 2,330,151 8,954,827 8,033,746 930 - 930 473,994 705,674 297,241 39,476 257,765 257,681 259,950 3,680 10,070 (6,389)410,871 419,193 - - - (29,415)(29,415) - 40,091 (40,091)94,986 94,986 116,356 - 116,356 194,650 194,650 6,472,328 - 6,472,328 7,218,383 7,233,178 138,259 608,107 (469,847)11,156,611 12,005,150 173,755 65,857 107,898 407,114 3,103,577 1,058,532 1,729,507 (670,974)10,815,895 6,959,523 3,931,560 2,469,974 1,461,586 6,753,008 7,585,169 3,071,997 2,571,289 500,708 6,194,629 3,443,076 1,256,398 1,126,190 130,208 (796,290)(1,490,123) 857,371 667,929 189,442 962,681 242,030 426,207 17,379 408,829 1,692,550 1,294,161 4,247,254 4,411,711 (164,457)(803,562)362,886 64,277,531 45,126,946 19,150,585 81,679,812 69,864,273 601 EQUIPMENT REPLACEMENT FUND 605 INSURANCE FUND 600 FLEET SERVICES FUND 515 SEWER FUND 520 SOLID WASTE FUND 510 WATER FUND 505 PARKING SYSTEM FUND 420 SPECIAL ASSESSMENT FUND 415 CAPITAL IMPROVEMENTS FUND 320 DEBT SERVICE FUND 345 CHICAGO-MAIN TIF 350 SPECIAL SERVICE AREA (SSA) #6 335 WEST EVANSTON TIF FUND 340 DEMPSTER-DODGE TIF FUND 330 HOWARD-RIDGE TIF FUND 310 HOWARD-HARTREY TIF 300 WASHINGTON NATIONAL TIF 186 LIBRARY DEBT SERVICE FUND 250 AFFORDABLE HOUSING FUND 235 NEIGHBORHOOD IMPROVEMENT 240 HOME FUND 215 CDBG FUND 220 CDBG LOAN 205 EMERGENCY TELEPHONE (E911) 210 SPECIAL SERVICE AREA (SSA) #4 195 NEIGHBORHOOD STABILIZATION 200 MOTOR FUEL TAX FUND 185 LIBRARY FUND 175 GENERAL ASSISTANCE FUND 180 GOOD NEIGHBOR FUND 176 HEALTH AND HUMAN SERVICES 100 GENERAL FUND Fund Fund Description Memorandum Included above are the ending balances as of March 31, 2017 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 tax) due to the City and accounts payable/accrued expenses. As of March 31, 2017, the General Fund is reporting a net surplus of $4,937,020. The General Fund balance is $19,734,012 with a cash balance of $11,561,044. This year shows the Economic Development Fund merged with the General Fund —increasing both Fund and Cash balances. The attached supplemental charts show the General Fund Revenues at 28.5% of budget and expenses lower at 24.3%. This revenue number reflects receipt of 50% of property taxes; permit revenue, however, is well - below estimates. Through March 31, 2017, the SSA #4 Fund is showing a negative fund and cash balance of $35,125. This is due to the timing of payments to the Downtown Evanston group. Through March 31, 2017, the Home Fund is showing a negative cash balance of $21,020. Through March 31, 2017, the CDBG Fund is showing a negative cash balance of $42,456. This will be reimbursed with draw-downs during March. Through March 31, 2017, the Capital Fund is showing a fund balance of $11,156,611 and a cash balance of $12,005,150. As the year-end close process for 2016 continues through May, expenses are anticipated to increase to reflect payables due to IDOT and other organizations which will be paid in 2017. This will reduce the fund balances Through March 31, 2017, the enterprise funds (Parking, Water, and Sewer) have balances above average due to the timing of capital projects for 2017. Through March 31, 2017, the Solid Waste Fund has a negative fund balance of $796,290 and a negative cash balance of $1,490,123. Through March 31, 2017, the Insurance Fund is showing a negative fund balance of $803,562 with a cash balance of $362,886. Advanced Disposal fees were all held in escrow in the Insurance Fund. After the settlement, these are these are treated as revenues in the General Fund. If there are any questions on the attached report, please contact me by phone at (847) 859-7884 or by email: aking@cityofevanston.org. Detailed fund summary reports can be found at: http://www.cityofevanston.org/city-budget/financial-reports/. Fund 100 - GENERAL FUND 2017 Budget March Actual YTD Actual % 2016 Actual 28,639,628 10,527,723 14,414,026 50.3% 27,302,687 49,402,274 3,167,760 11,651,566 23.6% 44,922,404 5,496,150 178,883 1,093,219 19.9% 6,784,745 11,648,000 319,325 1,343,319 11.5% 11,012,646 115,500 4,429 87,001 75.3% 70,395 3,810,000 271,821 673,477 17.7% 3,611,901 640,000 - 22,214 3.5% 687,835 5,650,895 469,033 1,483,823 26.3% 5,401,563 2,719,717 165,488 816,979 30.0% 2,798,972 7,705,774 613,976 1,881,929 24.4% 8,709,861 839,965 84,757 162,741 19.4% 988,671 2,060,829 52,764 162,889 7.9% 1,382,941 50,100 696 4,627 9.2% 30,285 118,778,832 15,856,652 33,797,810 28.5% 113,704,908 CITY COUNCIL 498,189 30,379 92,782 18.6% 433,601 CITY CLERK 275,488 21,096 68,450 24.8% 294,665 CITY MANAGER'S OFFICE 9,694,367 476,942 1,369,698 14.1% 6,985,591 LAW 1,038,137 62,468 164,194 15.8% 1,052,130 ADMINISTRATIVE SERVICES 9,700,879 727,465 1,958,654 20.2% 9,164,947 COMMUNITY DEVELOPMENT 2,804,668 188,492 521,641 18.6% 2,510,408 POLICE 38,223,842 5,572,678 11,407,455 29.8% 37,817,627 FIRE MGMT & SUPPORT 24,294,001 4,009,324 7,373,884 30.4% 23,235,714 HEALTH 3,582,312 238,584 662,644 18.5% 3,097,351 PUBLIC WORKS - - - #DIV/0! (1,475) PARKS, REC. AND COMMUNITY SERV. 12,361,460 841,221 2,070,351 16.7% 11,997,476 PUBLIC WORKS AGENCY 16,212,848 1,198,422 3,171,035 19.6% 14,738,137 118,686,191 13,367,071 28,860,790 24.3% 111,326,171 118,778,832 15,856,652 33,797,810 28% 113,704,908 118,686,191 13,367,071 28,860,790 24% 111,326,997 92,641 2,489,581 4,937,020 5,329% 2,377,911 Fund 100 - GENERAL FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund 100 - GENERAL FUND Net Gain (Loss) EXPENSE TOTAL Interest Income REVENUE TOTAL Parking Charges for Services Parks and Recreation Charges for Services Other Charges for Services Interfund Transfers Intergovernmental Revenue Other Revenue Property Taxes Other Taxes License Permit Fee Fines and Forfeitures March 2017 Financial Report Through 03/31/17 Summary Listing Classification Fund 505 - PARKING SYSTEM FUND 2017 Budget March Actual YTD Actual % 2016 Actual - - 600 #DIV/0! 3,350 6,737,875 (74,615) 1,014,646 15.1% 6,340,992 65,000 - - 0.0% 168,500 4,120,636 - - 0.0% 3,711,768 12,125 - - 0.0% - 203,216 12,167 34,734 17.1% 195,895 35,070 3,216 8,552 24.4% 38,159 11,173,922 (59,232) 1,058,532 9.5% 10,458,663 26,000 2,050 3,870 14.9% 26,465 1,117,119 77,097 217,133 19.4% 1,206,649 104,802 7,272 20,313 19.4% 93,277 3,222,411 265,192 659,653 20.5% 2,846,933 278,864 14,468 37,332 13.4% 237,610 3,020,000 262,755 262,755 8.7% (24,598) 524,102 43,124 127,328 24.3% 504,784 - - - 2,836,672 11,000 468 689 6.3% 5,910 4,331,771 - - 0.0% 390,235 304,000 81,763 81,763 26.9% 255,626 1,584,683 106,224 318,671 20.1% 1,303,783 14,524,752 860,413 1,729,507 11.9% 9,683,345 11,173,922 (59,232) 1,058,532 9% 10,458,663 14,524,752 860,413 1,729,507 12% 9,683,345 (3,350,830) (919,645) (670,974)20% 775,318 REVENUE TOTALS EXPENSE TOTALS Fund 505 - PARKING SYSTEM FUND Net Gain Debt Service Miscellaneous Interfund Transfers EXPENSE TOTAL Fund 505 - PARKING SYSTEM FUND Totals Services Supplies Capital Outlay Insurance and Other Chargebacks Depreciation Expense Contingencies Other Revenue Interest Income REVENUE TOTAL Employee Pay Benefits Pensions Permit Parking Charges for Services Parks and Recreation Charges for Services Interfund Transfers Intergovernmental Revenue March 2017 Financial Report Through 03/31/17 Summary Listing Classification Fund 510 - WATER FUND 2017 Budget March Actual YTD Actual % 2016 Actual 70,000 7,409 17,152 24.5% 90,592 17,324,000 265,349 3,887,644 22.4% 15,851,052 36,000 3,735 10,966 30.5% 51,737 135,000 125 20 0.0% 168,482 6,828,400 3,349 9,553 0.1% 306,143 1,600 2,440 6,225 389.1% 16,116 24,395,000 282,407 3,931,560 16.1% 16,484,123 183,365 7,755 33,725 18.4% 193,328 4,037,387 300,179 848,692 21.0% 3,898,385 368,658 28,122 80,563 21.9% 495,309 2,250,760 253,175 404,658 18.0% 1,735,462 1,360,390 110,316 184,171 13.5% 876,885 14,982,119 29,700 (232,508)-1.6% 791 1,174,064 95,263 275,095 23.4% 1,110,835 - - - #DIV/0! 1,973,593 1,000 - - 0.0% 1,000 1,438,470 - - 0.0% 633,708 62,980 - - 0.0% 238,468 3,502,313 278,526 875,578 25.0% 3,502,313 29,361,507 1,103,036 2,469,974 8.4% 14,660,077 24,395,000 282,407 3,931,560 16% 16,484,123 29,361,507 1,103,036 2,469,974 19% 14,660,077 (4,966,507) (820,629) 1,461,586 13% 1,824,045 EXPENSE TOTALS Fund 510 - WATER FUND Net Gain (Loss) Miscellaneous Interfund Transfers EXPENSE TOTAL Fund 510 - WATER FUND Totals REVENUE TOTALS Supplies Capital Outlay Insurance and Other Chargebacks Depreciation Expense Contingencies Debt Service Interest Income REVENUE TOTAL Employee Pay Benefits Pensions Services Fee Water Charges for Services Sewer Charges for Services Other Charges for Services Other Revenue March 2017 Financial Report Through 03/31/17 Summary Listing Classification Fund 515 - SEWER FUND 2017 Budget March Actual YTD Actual % 2016 Actual 12,501,500 797,835 3,070,763 24.6% 13,027,160 19,650 - - 0.0% 21,600 604,165 - - 0.0% 3,087 1,000 444 1,234 123.4% 4,450 13,126,315 798,279 3,071,997 23.4% 13,056,297 57,040 790 7,932 13.9% 37,763 859,043 66,243 185,198 21.6% 862,355 73,398 6,150 17,723 24.1% 110,255 908,500 28,201 28,201 3.1% 109,493 92,300 1,016 3,278 3.6% 48,058 2,819,700 - - 0.0% 15,370 432,953 36,580 106,868 24.7% 414,270 - - - #DIV/0! 3,461,103 8,370,946 1,367,533 1,974,170 23.6% 1,336,366 1,500 - - 0.0% 5,000 991,677 82,640 247,919 25.0% 773,873 14,607,057 1,589,153 2,571,289 17.6% 7,173,906 13,126,315 798,279 3,071,997 23% 13,056,297 14,607,057 1,589,153 2,571,289 18% 7,173,906 (1,480,742) (790,874) 500,708 (34%) 5,882,391 Fund 515 - SEWER FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund 515 - SEWER FUND Net Gain (Loss) Insurance and Other Chargebacks Depreciation Expense Debt Service Miscellaneous Interfund Transfers EXPENSE TOTAL Employee Pay Benefits Pensions Services Supplies Capital Outlay Sewer Charges for Services Other Charges for Services Other Revenue Interest Income REVENUE TOTAL March 2017 Financial Report Through 03/31/17 Summary Listing Classification Fund 520 - SOLID WASTE FUND 2017 Budget March Actual YTD Actual % 2016 Actual 275,000 41,263 86,004 31.3% 125,404 3,632,394 301,358 893,035 24.6% 3,586,453 1,055,967 87,997 263,992 25.0% 1,055,967 238,000 12,203 13,368 5.6% 274,808 5,201,361 442,822 1,256,398 24.2% 5,042,632 45,000 1,424 2,750 6.1% 43,025 644,768 43,664 119,115 18.5% 620,226 60,473 4,154 11,197 18.5% 72,588 3,679,126 232,568 833,514 22.7% 3,302,430 53,050 660 3,635 6.9% 54,768 25,750 2,085 2,285 8.9% 6,034 149,325 9,847 27,492 18.4% 138,618 21,046 - - 0.0% 2,251 15,000 - - 0.0% 12,232 504,807 42,067 126,202 25.0% 499,493 5,198,345 336,470 1,126,190 21.7% 4,751,664 5,201,361 442,822 1,256,398 24% 5,042,632 5,198,345 336,470 1,126,190 22% 4,751,664 3,016 106,352 130,208 4,317% 290,968 Fund 520 - SOLID WASTE FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund 520 - SOLID WASTE FUND Net Gain (Loss) Insurance and Other Chargebacks Debt Service Miscellaneous Interfund Transfers EXPENSE TOTAL Employee Pay Benefits Pensions Services Supplies Capital Outlay License Other Charges for Services Interfund Transfers Other Revenue REVENUE TOTAL March 2017 Financial Report Through 03/31/17 Summary Listing Classification March YTD 2016 2017 2017 Actual 10,527,723 14,414,026 27,302,687 3,167,760 11,651,566 44,922,404 502,637 2,523,539 17,867,787 271,821 673,477 3,611,901 634,520 2,323,016 8,888,370 613,976 1,881,929 8,709,861 84,757 162,741 988,671 52,764 162,889 1,382,941 - - - - - - - - - 696 4,627 30,285 - - - - - - 15,856,652 33,797,810 113,704,908 4,547,816 13,556,859 61,447,382 892,029 1,894,148 11,994,107 21,978 35,145 159,648 7,200,189 11,268,612 28,062,250 - 9,399 865,156 - - - 190 619 51,836 - - - 23,400 51,600 1,704,736 681,469 2,044,406 7,041,881 13,367,071 28,860,790 111,326,997 15,856,652 33,797,810 113,704,908 13,367,071 28,860,790 111,326,997 2,489,581 4,937,020 2,377,911 Starting Fund Balance 14,796,992 14,796,992 Net Change 92,641 4,937,020 Ending Fund Balance 14,889,633 19,734,012 City of Evanston Financial Report Through 03/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 100 - GENERAL FUND REVENUE Property Taxes 28,639,628 Other Taxes 49,402,274 Licenses, Permits and Fees 17,259,650 Fines and Forfeitures 3,810,000 Charges for Services 9,010,612 Interfund Transfers 7,705,774 Intergovernmental Revenue 839,965 Other Revenue 2,060,829 Workers Compensation and Liability - Insurance - Library Revenue - Interest Income 50,100 Special Assessment - Reappropriation of Surplus - REVENUE TOTALS 118,778,832 EXPENSE Salary and Benefits 62,620,910 Services and Supplies 13,716,790 Capital Outlay 499,000 Insurance and Other Chargebacks 30,321,297 Community Sponsored Organizations 204,568 Depreciation Expense - Contingencies 213,519 Debt Service - Miscellaneous 1,200,481 Interfund Transfers 9,909,626 EXPENSE TOTALS 118,686,191 Fund 100 - GENERAL FUND Totals REVENUE TOTALS 118,778,832 EXPENSE TOTALS 118,686,191 Fund 100 - GENERAL FUND Totals 92,641 Run by Ashley King on 04/24/2017 02:59:39 PM Page 1 of 51 March YTD 2016 2017 2017 Actual 317,482 437,954 827,615 - - - - - - - - - - - - - - - - - - - 13,759 49,590 - - - - - - - - - 52 163 802 - - - - - - 317,534 451,875 878,006 21,356 58,482 246,916 49,215 132,087 529,013 - - - 3,258 9,785 26,205 - - - - - - - - - - - - 50 50 2,723 - - - 73,879 200,404 804,857 317,534 451,875 878,006 73,879 200,404 804,857 243,655 251,471 73,149 Starting Fund Balance 584,645 584,645 Net Change (252,971) 251,471 Ending Fund Balance 331,674 836,116 City of Evanston Financial Report Through 03/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 175 - GENERAL ASSISTANCE FUND REVENUE Property Taxes 900,000 Other Taxes - Licenses, Permits and Fees - Fines and Forfeitures - Charges for Services - Interfund Transfers - Intergovernmental Revenue - Other Revenue 25,000 Workers Compensation and Liability - Insurance - Library Revenue - Interest Income 1,000 Special Assessment - Reappropriation of Surplus - REVENUE TOTALS 926,000 EXPENSE Salary and Benefits 282,103 Services and Supplies 858,900 Capital Outlay - Insurance and Other Chargebacks 30,968 Community Sponsored Organizations - Depreciation Expense - Contingencies - Debt Service - Miscellaneous 7,000 Interfund Transfers - EXPENSE TOTALS 1,178,971 Fund 175 - GENERAL ASSISTANCE FUND REVENUE TOTALS 926,000 EXPENSE TOTALS 1,178,971 Fund 175 - GENERAL ASSISTANCE FUND (252,971) Run by Ashley King on 04/24/2017 02:59:39 PM Page 2 of 51 March YTD 2016 2017 2017 Actual - - - 71,596 214,788 884,794 - - - - - - 71,596 214,788 884,794 61 121 61 - - - - - 849,333 - - - 61 121 849,394 71,596 214,788 884,794 61 121 849,394 71,535 214,667 35,400 Starting Fund Balance 35,400 35,400 Net Change - 214,667 Ending Fund Balance 35,400 250,067 City of Evanston Financial Report Through 03/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 176 - HEALTH AND HUMAN SERVICES REVENUE Charges for Services - Interfund Transfers 859,153 Intergovernmental Revenue - Other Revenue - REVENUE TOTALS 859,153 EXPENSE Services and Supplies 767,055 859,153 Capital Outlay - Community Sponsored Organizations 92,098 Miscellaneous - EXPENSE TOTALS 859,153 Fund 176 - HEALTH AND HUMAN - EXPENSE TOTALS 859,153 Fund 176 - HEALTH AND HUMAN REVENUE TOTALS Run by Ashley King on 04/24/2017 02:59:39 PM Page 3 of 51 March YTD 2016 2017 2017 Actual - 1,000,000 1,000,000 - 1,000,000 1,000,000 83,333 250,000 1,000,000 83,333 250,000 1,000,000 - 1,000,000 1,000,000 83,333 250,000 1,000,000 (83,333) 750,000 (0) Starting Fund Balance - - Net Change - 750,000 Ending Fund Balance - 750,000 City of Evanston Financial Report Through 03/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 180 - GOOD NEIGHBOR FUND REVENUE Other Revenue 1,000,000 REVENUE TOTALS 1,000,000 EXPENSE Interfund Transfers 1,000,000 EXPENSE TOTALS 1,000,000 Fund 180 - GOOD NEIGHBOR FUND Totals REVENUE TOTALS 1,000,000 EXPENSE TOTALS 1,000,000 Fund 180 - GOOD NEIGHBOR FUND Totals - Run by Ashley King on 04/24/2017 02:59:39 PM Page 4 of 51 March YTD 2016 2017 2017 Actual 2,355,019 3,238,501 6,136,248 - - 4,141 15,177 39,124 152,537 83 83 - - - 235,800 100 4,920 75,418 6,103 6,595 67,943 24,622 85,547 339,027 147 377 4,717 2,401,251 3,375,148 7,015,830 316,209 863,557 4,246,657 144,626 341,793 1,733,725 - - 57,842 39,265 110,010 406,163 - - - - - - - - - - - 250,000 28,635 85,904 90,272 528,735 1,401,264 6,784,659 2,401,251 3,375,148 7,015,830 528,735 1,401,264 6,784,659 1,872,516 1,973,884 231,172 Starting Fund Balance 760,818 760,818 Net Change - 1,973,884 Ending Fund Balance 760,818 2,734,702 City of Evanston Financial Report Through 03/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 185 - LIBRARY FUND REVENUE Property Taxes 6,376,358 Other Taxes 46,100 Fines and Forfeitures 164,000 Charges for Services - Interfund Transfers 190,200 Intergovernmental Revenue 57,418 Other Revenue 24,849 Library Revenue 386,020 Interest Income 5,400 REVENUE TOTALS 7,250,345 EXPENSE Salary and Benefits 4,460,836 Services and Supplies 1,940,058 Capital Outlay 5,400 Insurance and Other Chargebacks 500,433 Depreciation Expense - Contingencies - Debt Service - Miscellaneous - Interfund Transfers 343,618 EXPENSE TOTALS 7,250,345 Fund 185 - LIBRARY FUND Totals REVENUE TOTALS 7,250,345 EXPENSE TOTALS 7,250,345 Fund 185 - LIBRARY FUND Totals - Run by Ashley King on 04/24/2017 02:59:39 PM Page 5 of 51 March YTD 2016 2017 2017 Actual - - 364,827 - - - - - 1 - - 364,828 - - (1,007) - - - - - 385,696 - - - - - 384,689 - - 364,828 - - 384,689 - - (19,861) Starting Fund Balance 16,803 16,803 Net Change - - Ending Fund Balance 16,803 16,803 City of Evanston Financial Report Through 03/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 186 - LIBRARY DEBT SERVICE FUND REVENUE Property Taxes 345,955 Other Revenue - Interest Income - REVENUE TOTALS 345,955 EXPENSE Services and Supplies - Capital Outlay - Debt Service 345,955 Miscellaneous - EXPENSE TOTALS 345,955 Fund 186 - LIBRARY DEBT SERVICE - Fund 186 - LIBRARY DEBT SERVICE REVENUE TOTALS 345,955 EXPENSE TOTALS 345,955 Run by Ashley King on 04/24/2017 02:59:39 PM Page 6 of 51 March YTD 2016 2017 2017 Actual - - - - - 91,447 - - - 9 29 - 9 29 91,447 1,679 4,829 22,569 1,860 1,860 6,060 - - 39,316 373 1,027 4,173 - - - - - 1,705 377 1,130 17,623 4,289 8,845 91,447 9 29 91,447 4,289 8,845 91,447 (4,280) (8,816) - Starting Fund Balance (28,289) (28,289) Net Change (303) (8,816) Ending Fund Balance (28,592) (37,105) City of Evanston Financial Report Through 03/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 195 - NEIGHBORHOOD STABILIZATION FUND REVENUE Licenses, Permits and Fees - Intergovernmental Revenue 139,500 Other Revenue - Interest Income - REVENUE TOTALS 139,500 EXPENSE Salary and Benefits 28,297 Services and Supplies 5,100 Capital Outlay 7,000 Insurance and Other Chargebacks 3,984 139,500 Debt Service - Miscellaneous 50,000 Interfund Transfers 4,518 EXPENSE TOTALS 98,899 Fund 195 - NEIGHBORHOOD 40,601 EXPENSE TOTALS 98,899 Fund 195 - NEIGHBORHOOD REVENUE TOTALS Run by Ashley King on 04/24/2017 02:59:39 PM Page 7 of 51 March YTD 2016 2017 2017 Actual 160,153 504,827 1,896,461 - - - 1,023 2,456 6,613 - - - 161,176 507,284 1,903,074 - - - - - 130,789 - - - - - - - - - 71,499 214,498 2,189,000 71,499 214,498 2,319,789 161,176 507,284 1,903,074 71,499 214,498 2,319,789 89,677 292,786 (416,715) Starting Fund Balance 1,413,678 1,413,678 Net Change (327,990) 292,786 Ending Fund Balance 1,085,688 1,706,464 City of Evanston Financial Report Through 03/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 200 - MOTOR FUEL TAX FUND REVENUE Intergovernmental Revenue 1,920,000 Other Revenue - Interest Income 1,000 Reappropriation of Surplus - REVENUE TOTALS 1,921,000 EXPENSE Services and Supplies - Capital Outlay 1,391,000 Contingencies - Debt Service - Miscellaneous - Interfund Transfers 857,990 EXPENSE TOTALS 2,248,990 Fund 200 - MOTOR FUEL TAX FUND Totals (327,990) Fund 200 - MOTOR FUEL TAX FUND Totals REVENUE TOTALS 1,921,000 EXPENSE TOTALS 2,248,990 Run by Ashley King on 04/24/2017 02:59:39 PM Page 8 of 51 March YTD 2016 2017 2017 Actual 76,814 233,072 1,038,331 - - - - - - 761 1,178 2,472 77,576 234,250 1,040,803 39,179 92,983 509,028 28,361 56,674 263,105 - - 423,493 7,930 19,764 91,628 - - - - - - - - - - - - 6,081 18,244 142,207 81,551 187,666 1,429,460 77,576 234,250 1,040,803 81,551 187,666 1,429,460 (3,975) 46,584 (388,657) Starting Fund Balance 12,304 12,304 Net Change (8,718) 46,584 Ending Fund Balance 3,586 58,888 City of Evanston Financial Report Through 03/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 205 - EMERGENCY TELEPHONE (E911) FUND REVENUE Other Taxes 1,020,700 Intergovernmental Revenue - Other Revenue - Interest Income 1,000 REVENUE TOTALS 1,021,700 EXPENSE Salary and Benefits 517,524 Services and Supplies 282,400 Capital Outlay 55,000 Insurance and Other Chargebacks 102,517 Community Sponsored Organizations - Contingencies - Debt Service - Miscellaneous - Interfund Transfers 72,977 EXPENSE TOTALS 1,030,418 Fund 205 - EMERGENCY TELEPHONE (8,718) Fund 205 - EMERGENCY TELEPHONE REVENUE TOTALS 1,021,700 EXPENSE TOTALS 1,030,418 Run by Ashley King on 04/24/2017 02:59:39 PM Page 9 of 51 March YTD 2016 2017 2017 Actual 121,451 157,151 321,266 - - 2 121,451 157,151 321,268 - - 323,000 - - - - - - - - 323,000 121,451 157,151 321,268 - - 323,000 121,451 157,151 (1,732) Starting Fund Balance (192,276) (192,276) Net Change - 157,151 Ending Fund Balance (192,276) (35,125) City of Evanston Financial Report Through 03/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 210 - SPECIAL SERVICE AREA (SSA) #4 REVENUE Property Taxes 320,000 Interest Income - REVENUE TOTALS 320,000 320,000 EXPENSE Services and Supplies 320,000 Debt Service - Miscellaneous - EXPENSE TOTALS 320,000 Fund 210 - SPECIAL SERVICE AREA (SSA) - EXPENSE TOTALS 320,000 Fund 210 - SPECIAL SERVICE AREA (SSA) REVENUE TOTALS Run by Ashley King on 04/24/2017 02:59:39 PM Page 10 of 51 March YTD 2016 2017 2017 Actual - - - - - - - - 2,016,478 - - 10,197 - - - - - 2,026,675 26,585 79,323 414,848 2,434 3,474 6,219 - - 608,829 7,620 21,320 87,411 - - 507,815 - - - - - - 257 257 61,555 730 2,189 335,774 37,626 106,562 2,022,452 - - 2,026,675 37,626 106,562 2,022,452 (37,626) (106,562) 4,224 Starting Fund Balance 64,106 64,106 Net Change (9,484) (106,562) Ending Fund Balance 54,622 (42,456) City of Evanston Financial Report Through 03/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 215 - CDBG FUND REVENUE Charges for Services - Interfund Transfers - Intergovernmental Revenue 2,272,494 Other Revenue - Interest Income - REVENUE TOTALS 2,272,494 EXPENSE Salary and Benefits 393,090 Services and Supplies 220,840 Capital Outlay - Insurance and Other Chargebacks 93,120 Community Sponsored Organizations 175,500 Contingencies - 2,272,494 Debt Service - Miscellaneous 569,970 Interfund Transfers 829,458 EXPENSE TOTALS 2,281,978 Fund 215 - CDBG FUND Totals (9,484) EXPENSE TOTALS 2,281,978 Fund 215 - CDBG FUND Totals REVENUE TOTALS Run by Ashley King on 04/24/2017 02:59:39 PM Page 11 of 51 March YTD 2016 2017 2017 Actual - - - 2,160 19,231 208,541 28 56 4,656 2,188 19,287 213,197 - - - 1,200 1,270 160,641 - - - - - - 1,200 1,270 160,641 2,188 19,287 213,197 1,200 1,270 160,641 988 18,017 52,555 Starting Fund Balance 157,661 157,661 Net Change - 18,017 Ending Fund Balance 157,661 175,678 City of Evanston Financial Report Through 03/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 220 - CDBG LOAN REVENUE Intergovernmental Revenue - Other Revenue 293,000 Interest Income - REVENUE TOTALS 293,000 EXPENSE Salary and Benefits - Services and Supplies 293,000 Miscellaneous - Interfund Transfers - EXPENSE TOTALS 293,000 Fund 220 - CDBG LOAN Totals - Fund 220 - CDBG LOAN Totals REVENUE TOTALS 293,000 EXPENSE TOTALS 293,000 Run by Ashley King on 04/24/2017 02:59:39 PM Page 12 of 51 March YTD 2016 2017 2017 Actual - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Starting Fund Balance 169,915 169,915 Net Change (100,000) - Ending Fund Balance 69,915 169,915 City of Evanston Financial Report Through 03/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 235 - NEIGHBORHOOD IMPROVEMENT REVENUE Other Taxes - Interfund Transfers - Interest Income - REVENUE TOTALS - EXPENSE Services and Supplies - Capital Outlay - - Debt Service - Miscellaneous 100,000 Interfund Transfers - EXPENSE TOTALS 100,000 Fund 235 - NEIGHBORHOOD (100,000) EXPENSE TOTALS 100,000 Fund 235 - NEIGHBORHOOD REVENUE TOTALS Run by Ashley King on 04/24/2017 02:59:39 PM Page 13 of 51 March YTD 2016 2017 2017 Actual - - 178,211 2,407 6,971 27,259 1 2 14 2,408 6,973 205,484 3,082 8,317 31,964 590 20,799 180,110 - - - 404 1,128 3,998 - - - - - - 126 126 100 - - (8,295) 4,202 30,371 207,876 2,408 6,973 205,484 4,202 30,371 207,876 (1,794) (23,398) (2,392) Starting Fund Balance 2,377 2,377 Net Change (831) (23,398) Ending Fund Balance 1,546 (21,021) City of Evanston Financial Report Through 03/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 240 - HOME FUND REVENUE Intergovernmental Revenue 585,861 Other Revenue - Interest Income - REVENUE TOTALS 585,861 EXPENSE Salary and Benefits 41,005 Services and Supplies 540,200 Capital Outlay - Insurance and Other Chargebacks 4,987 Community Sponsored Organizations - 585,861 Debt Service - Miscellaneous 500 Interfund Transfers - EXPENSE TOTALS 586,692 Fund 240 - HOME FUND Totals (831) EXPENSE TOTALS 586,692 Fund 240 - HOME FUND Totals REVENUE TOTALS Run by Ashley King on 04/24/2017 02:59:39 PM Page 14 of 51 March YTD 2016 2017 2017 Actual 10,000 10,000 106,780 - - - - - - 417 32,500 448,343 682 916 1,392 11,098 43,416 556,515 3,082 8,317 34,138 - - 201 - - - 336 923 3,178 - - 735 - - - 3,157 10,835 110,956 - - - 6,575 20,076 149,207 11,098 43,416 556,515 6,575 20,076 149,207 4,523 23,340 407,308 Starting Fund Balance 1,400,923 1,400,923 Net Change (1,071,422) 23,340 Ending Fund Balance 329,501 1,424,263 City of Evanston Financial Report Through 03/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 250 - AFFORDABLE HOUSING FUND REVENUE Other Taxes 50,000 Interfund Transfers - Intergovernmental Revenue - Other Revenue 585,600 Interest Income 230 REVENUE TOTALS 635,830 EXPENSE Salary and Benefits 63,452 Services and Supplies 1,077,500 Capital Outlay - Insurance and Other Chargebacks 8,800 Community Sponsored Organizations 455,000 Debt Service - Miscellaneous 102,500 Interfund Transfers - EXPENSE TOTALS 1,707,252 Fund 250 - AFFORDABLE HOUSING FUND (1,071,422) Fund 250 - AFFORDABLE HOUSING FUND REVENUE TOTALS 635,830 EXPENSE TOTALS 1,707,252 Run by Ashley King on 04/24/2017 02:59:39 PM Page 15 of 51 March YTD 2016 2017 2017 Actual 1,656,550 2,412,175 4,729,649 - - - - - - - - - 2,103 5,476 14,012 1,658,652 2,417,651 4,743,661 - - - - - 2,750 - - 4,473 - - - - - 1,098,676 29,167 87,500 4,455,515 29,167 87,500 5,561,415 1,658,652 2,417,651 4,743,661 29,167 87,500 5,561,415 1,629,485 2,330,151 (817,754) Starting Fund Balance 6,624,676 6,624,676 Net Change (5,385,636) 2,330,151 Ending Fund Balance 1,239,040 8,954,827 City of Evanston Financial Report Through 03/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 300 - WASHINGTON NATIONAL TIF FUND REVENUE Property Taxes 5,145,000 Other Taxes - Interfund Transfers - Other Revenue - Interest Income 10,000 REVENUE TOTALS 5,155,000 EXPENSE Salary and Benefits - Services and Supplies 500,000 Capital Outlay - 5,155,000 Debt Service - Miscellaneous 100,000 Interfund Transfers 9,940,636 EXPENSE TOTALS 10,540,636 Fund 300 - WASHINGTON NATIONAL TIF (5,385,636) EXPENSE TOTALS 10,540,636 Fund 300 - WASHINGTON NATIONAL TIF REVENUE TOTALS Run by Ashley King on 04/24/2017 02:59:39 PM Page 16 of 51 March YTD 2016 2017 2017 Actual - - (180) - - - - - - - - 35 - - (145) - - 5,652 - - 428,186 - - - - - 91,445 - - 525,284 - - (145) - - 525,284 - - (525,429) Starting Fund Balance - - Net Change - - Ending Fund Balance - - City of Evanston Financial Report Through 03/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 305 - SPECIAL SERVICE AREA (SSA) #5 REVENUE Property Taxes - Interfund Transfers - Other Revenue - Interest Income - REVENUE TOTALS - EXPENSE Services and Supplies - - Debt Service - Miscellaneous - Interfund Transfers - EXPENSE TOTALS - Fund 305 - SPECIAL SERVICE AREA (SSA) - EXPENSE TOTALS - Fund 305 - SPECIAL SERVICE AREA (SSA) REVENUE TOTALS Run by Ashley King on 04/24/2017 02:59:39 PM Page 17 of 51 March YTD 2016 2017 2017 Actual - - 1,233,675 - - - 354 930 2,319 354 930 1,235,994 - - 2,488 - - - - - - - - - - - 129,192 - - 1,741,757 - - 1,873,437 354 930 1,235,994 - - 1,873,437 354 930 (637,443) Starting Fund Balance 473,064 473,064 Net Change (87,357) 930 Ending Fund Balance 385,707 473,994 City of Evanston Financial Report Through 03/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 310 - HOWARD-HARTREY TIF REVENUE Property Taxes - Other Revenue - Interest Income - REVENUE TOTALS - EXPENSE Services and Supplies - Capital Outlay - Community Sponsored Organizations - Debt Service - Miscellaneous - Interfund Transfers 87,357 EXPENSE TOTALS 87,357 Fund 310 - HOWARD-HARTREY TIF Totals REVENUE TOTALS - EXPENSE TOTALS 87,357 Fund 310 - HOWARD-HARTREY TIF Totals (87,357) Run by Ashley King on 04/24/2017 02:59:39 PM Page 18 of 51 March YTD 2016 2017 2017 Actual 4,159,930 5,699,069 10,438,928 256,961 770,882 3,079,968 - - 8,211,196 958 2,377 24,264 4,417,848 6,472,328 21,754,356 - - 149,553 - - 23,454,863 - - - - - - - - 23,604,416 4,417,848 6,472,328 21,754,356 - - 23,604,416 4,417,848 6,472,328 (1,850,061) Starting Fund Balance 746,055 746,055 Net Change (305,500) 6,472,328 Ending Fund Balance 440,555 7,218,383 City of Evanston Financial Report Through 03/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 320 - DEBT SERVICE FUND REVENUE Property Taxes 10,879,993 Interfund Transfers 3,244,144 Other Revenue - Interest Income 1,500 REVENUE TOTALS 14,125,637 EXPENSE Services and Supplies 120,250 14,125,637 Debt Service 14,310,887 Miscellaneous - Interfund Transfers - EXPENSE TOTALS 14,431,137 Fund 320 - DEBT SERVICE FUND Totals (305,500) EXPENSE TOTALS 14,431,137 Fund 320 - DEBT SERVICE FUND Totals REVENUE TOTALS Run by Ashley King on 04/24/2017 02:59:39 PM Page 19 of 51 March YTD 2016 2017 2017 Actual 261,731 285,241 533,105 (1,000) 12,000 282,307 0 0 374 260,731 297,241 815,787 1,902 24,267 679,056 - - - - - - - - - 68 209 693 - - - 5,000 15,000 107,500 6,969 39,476 787,249 260,731 297,241 815,787 6,969 39,476 787,249 253,762 257,765 28,537 Starting Fund Balance (84) (84) Net Change (13,200) 257,765 Ending Fund Balance (13,284) 257,681 City of Evanston Financial Report Through 03/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 330 - HOWARD-RIDGE TIF FUND REVENUE Property Taxes 555,000 Other Revenue 1,030,000 Interest Income 400 REVENUE TOTALS 1,585,400 EXPENSE Services and Supplies 538,000 Capital Outlay 1,000,000 Insurance and Other Chargebacks - Community Sponsored Organizations - Debt Service 600 Miscellaneous - Interfund Transfers 60,000 EXPENSE TOTALS 1,598,600 Fund 330 - HOWARD-RIDGE TIF FUND (13,200) Fund 330 - HOWARD-RIDGE TIF FUND REVENUE TOTALS 1,585,400 EXPENSE TOTALS 1,598,600 Run by Ashley King on 04/24/2017 02:59:39 PM Page 20 of 51 March YTD 2016 2017 2017 Actual - - - 1,028 3,085 11,311 228 596 1,684 1,256 3,680 12,995 - - 507 - - (1,028) - - - - - - 830 2,570 8,519 - - - 2,500 7,500 30,000 3,330 10,070 37,998 1,256 3,680 12,995 3,330 10,070 37,998 (2,074) (6,389) (25,003) Starting Fund Balance 417,260 417,260 Net Change (39,850) (6,389) Ending Fund Balance 377,410 410,871 City of Evanston Financial Report Through 03/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 335 - WEST EVANSTON TIF FUND REVENUE Property Taxes - Other Revenue - Interest Income 150 REVENUE TOTALS 150 EXPENSE Services and Supplies - Capital Outlay - Insurance and Other Chargebacks - Contingencies - Debt Service 10,000 Miscellaneous - Interfund Transfers 30,000 EXPENSE TOTALS 40,000 Fund 335 - WEST EVANSTON TIF FUND (39,850) Fund 335 - WEST EVANSTON TIF FUND REVENUE TOTALS 150 EXPENSE TOTALS 40,000 Run by Ashley King on 04/24/2017 02:59:39 PM Page 21 of 51 March YTD 2016 2017 2017 Actual - - - - - - - - - - - 971 - - - - - 28,444 - - 29,415 - - - - - 29,415 - - (29,415) Starting Fund Balance (29,415) (29,415) Net Change - - Ending Fund Balance (29,415) (29,415) City of Evanston Financial Report Through 03/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 340 - DEMPSTER-DODGE TIF FUND REVENUE Property Taxes - Other Revenue 50,000 REVENUE TOTALS 50,000 50,000 EXPENSE Services and Supplies - Capital Outlay - Debt Service 40,000 EXPENSE TOTALS 40,000 Fund 340 - DEMPSTER-DODGE TIF FUND 10,000 EXPENSE TOTALS 40,000 Fund 340 - DEMPSTER-DODGE TIF FUND REVENUE TOTALS Run by Ashley King on 04/24/2017 02:59:39 PM Page 22 of 51 March YTD 2016 2017 2017 Actual - - - - - 1,580,000 - - 1,580,000 - - 437 - - 1,740,000 2,766 40,091 16,556 2,766 40,091 1,756,993 - - 1,580,000 2,766 40,091 1,756,993 (2,766) (40,091) (176,993) Starting Fund Balance 135,077 135,077 Net Change (60,000) (40,091) Ending Fund Balance 75,077 94,986 City of Evanston Financial Report Through 03/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 345 - CHICAGO-MAIN TIF REVENUE Property Taxes - Other Revenue - REVENUE TOTALS - - EXPENSE Services and Supplies - Capital Outlay - Debt Service 60,000 EXPENSE TOTALS 60,000 Fund 345 - CHICAGO-MAIN TIF Totals (60,000) EXPENSE TOTALS 60,000 Fund 345 - CHICAGO-MAIN TIF Totals REVENUE TOTALS Run by Ashley King on 04/24/2017 02:59:39 PM Page 23 of 51 March YTD 2016 2017 2017 Actual 94,321 116,355 223,296 0 1 2 94,322 116,356 223,298 - - 145,003 - - - - - 145,003 94,322 116,356 223,298 - - 145,003 94,322 116,356 78,294 Starting Fund Balance 78,294 78,294 Net Change 500 116,356 Ending Fund Balance 78,794 194,650 City of Evanston Financial Report Through 03/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 350 - SPECIAL SERVICE AREA (SSA) #6 REVENUE Property Taxes 220,000 Interest Income 500 REVENUE TOTALS 220,500 EXPENSE Services and Supplies 220,000 Interfund Transfers - EXPENSE TOTALS 220,000 Fund 350 - SPECIAL SERVICE AREA (SSA) 500 Fund 350 - SPECIAL SERVICE AREA (SSA) REVENUE TOTALS 220,500 EXPENSE TOTALS 220,000 Run by Ashley King on 04/24/2017 02:59:39 PM Page 24 of 51 March YTD 2016 2017 2017 Actual - - 96,586 41,667 125,000 4,864,054 - - 1,527,914 5,074 5,074 10,268,138 2,926 8,185 16,690 49,666 138,259 16,773,383 - - - 100,882 120,871 1,333,831 279,673 362,235 8,840,135 - - - - - - 41,667 125,000 490,000 422,222 608,107 10,663,966 49,666 138,259 16,773,383 422,222 608,107 10,663,966 (372,556) (469,847) 6,109,417 Starting Fund Balance 11,626,458 11,626,458 Net Change (8,583,512) (469,847) Ending Fund Balance 3,042,946 11,156,611 City of Evanston Financial Report Through 03/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 415 - CAPITAL IMPROVEMENTS FUND REVENUE Charges for Services - Interfund Transfers 7,710,000 Intergovernmental Revenue 1,920,000 Other Revenue 12,295,000 Interest Income - REVENUE TOTALS 21,925,000 EXPENSE Salary and Benefits - Services and Supplies - Capital Outlay 30,008,512 21,925,000 Debt Service - Miscellaneous - Interfund Transfers 500,000 EXPENSE TOTALS 30,508,512 Fund 415 - CAPITAL IMPROVEMENTS (8,583,512) EXPENSE TOTALS 30,508,512 Fund 415 - CAPITAL IMPROVEMENTS REVENUE TOTALS Run by Ashley King on 04/24/2017 02:59:39 PM Page 25 of 51 March YTD 2016 2017 2017 Actual - - - - - - - - - - - - - - - - - - - - - - - 513,349 - - - - - - - - - 272 14,802 29,661 22,520 158,953 142,874 - - - 22,792 173,755 685,884 - - - - - 8,751 - - - - - - - - - - - - 21,952 65,857 360,698 21,952 65,857 369,449 22,792 173,755 685,884 21,952 65,857 369,449 839 107,898 316,435 Starting Fund Balance 299,216 299,216 Net Change (32,227) 107,898 Ending Fund Balance 266,989 407,114 City of Evanston Financial Report Through 03/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 420 - SPECIAL ASSESSMENT FUND REVENUE Property Taxes - Other Taxes - Licenses, Permits and Fees - Fines and Forfeitures - Charges for Services - Interfund Transfers - Intergovernmental Revenue - Other Revenue 250,000 Workers Compensation and Liability - Insurance - Library Revenue - Interest Income 51,033 Special Assessment 180,167 Reappropriation of Surplus - REVENUE TOTALS 481,200 EXPENSE Salary and Benefits - Services and Supplies - Capital Outlay - Insurance and Other Chargebacks - Debt Service - Miscellaneous - Interfund Transfers 513,427 EXPENSE TOTALS 513,427 Fund 420 - SPECIAL ASSESSMENT FUND REVENUE TOTALS 481,200 EXPENSE TOTALS 513,427 Fund 420 - SPECIAL ASSESSMENT FUND (32,227) Run by Ashley King on 04/24/2017 02:59:39 PM Page 26 of 51 March YTD 2016 2017 2017 Actual - - - - - - - 600 3,350 - - - (74,615) 1,014,646 6,509,492 - - 3,711,768 - - - 12,167 34,734 195,895 3,216 8,552 38,159 (59,232) 1,058,532 10,458,663 86,419 241,316 1,326,390 279,661 696,985 3,084,543 262,755 262,755 (24,598) 43,124 127,328 504,784 - - - - - 2,836,672 468 689 5,910 - - 390,235 81,763 81,763 255,626 106,224 318,671 1,303,783 860,413 1,729,507 9,683,345 (59,232) 1,058,532 10,458,663 860,413 1,729,507 9,683,345 (919,645) (670,974) 775,318 Starting Fund Balance 11,486,869 11,486,869 Net Change (3,350,830) (670,974) Ending Fund Balance 8,136,039 10,815,895 City of Evanston Financial Report Through 03/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 505 - PARKING SYSTEM FUND REVENUE Property Taxes - Other Taxes - Licenses, Permits and Fees - Fines and Forfeitures - Charges for Services 6,802,875 Interfund Transfers 4,120,636 Intergovernmental Revenue 12,125 Other Revenue 203,216 Interest Income 35,070 REVENUE TOTALS 11,173,922 EXPENSE Salary and Benefits 1,247,921 Services and Supplies 3,501,275 Capital Outlay 3,020,000 Insurance and Other Chargebacks 524,102 Community Sponsored Organizations - Depreciation Expense - Contingencies 11,000 Debt Service 4,331,771 Miscellaneous 304,000 Interfund Transfers 1,584,683 EXPENSE TOTALS 14,524,752 Fund 505 - PARKING SYSTEM FUND Totals (3,350,830) Fund 505 - PARKING SYSTEM FUND Totals REVENUE TOTALS 11,173,922 EXPENSE TOTALS 14,524,752 Run by Ashley King on 04/24/2017 02:59:39 PM Page 27 of 51 March YTD 2016 2017 2017 Actual - - - 7,409 17,152 90,592 269,209 3,898,630 16,071,271 - - - - - - 3,349 9,553 306,143 2,440 6,225 16,116 282,407 3,931,560 16,484,123 336,056 962,980 4,587,022 363,491 588,829 2,612,347 29,700 (232,508) 791 95,263 275,095 1,110,835 - - - - - 1,973,593 - - 1,000 - - 633,708 - - 238,468 278,526 875,578 3,502,313 14,660,077 282,407 3,931,560 16,484,123 1,103,036 2,469,974 14,660,077 (820,629) 1,461,586 1,824,045 Starting Fund Balance 5,291,422 5,291,422 Net Change 1,824,045 1,461,586 Ending Fund Balance 7,115,467 6,753,008 City of Evanston Financial Report Through 03/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 510 - WATER FUND REVENUE Other Taxes - Licenses, Permits and Fees 70,000 Charges for Services 17,495,000 Interfund Transfers - Intergovernmental Revenue - Other Revenue 6,828,400 Interest Income 1,600 REVENUE TOTALS 24,395,000 EXPENSE Salary and Benefits 4,589,411 Services and Supplies 3,611,150 Capital Outlay 14,982,119 Insurance and Other Chargebacks 1,174,064 Community Sponsored Organizations - Depreciation Expense - Contingencies 1,000 REVENUE TOTALS 24,395,000 Debt Service 1,438,470 Miscellaneous 62,980 Interfund Transfers 3,502,313 EXPENSE TOTALS 29,361,507 Fund 510 - WATER FUND Totals 1,824,045 1,103,036 2,469,974 EXPENSE TOTALS 29,361,507 Fund 510 - WATER FUND Totals Run by Ashley King on 04/24/2017 02:59:39 PM Page 28 of 51 March YTD 2016 2017 2017 Actual 797,835 3,070,763 13,048,760 - - - - - 3,087 444 1,234 4,450 798,279 3,071,997 13,056,297 73,183 210,853 1,010,374 29,217 31,479 157,551 - - 15,370 36,580 106,868 414,270 - - 3,461,103 - - - 1,367,533 1,974,170 1,336,366 - - 5,000 82,640 247,919 773,873 1,589,153 2,571,289 7,173,906 798,279 3,071,997 13,056,297 1,589,153 2,571,289 7,173,906 (790,874) 500,708 5,882,391 Starting Fund Balance 5,693,921 5,693,921 Net Change (1,480,742) 500,708 Ending Fund Balance 4,213,179 6,194,629 City of Evanston Financial Report Through 03/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 515 - SEWER FUND REVENUE Charges for Services 12,521,150 Interfund Transfers - Other Revenue 604,165 Interest Income 1,000 REVENUE TOTALS 13,126,315 EXPENSE Salary and Benefits 989,481 Services and Supplies 1,000,800 Capital Outlay 2,819,700 Insurance and Other Chargebacks 432,953 Depreciation Expense - Contingencies - Debt Service 8,370,946 Miscellaneous 1,500 Interfund Transfers 991,677 EXPENSE TOTALS 14,607,057 Fund 515 - SEWER FUND Totals (1,480,742) Fund 515 - SEWER FUND Totals REVENUE TOTALS 13,126,315 EXPENSE TOTALS 14,607,057 Run by Ashley King on 04/24/2017 02:59:39 PM Page 30 of 51 March YTD 2016 2017 2017 Actual 41,263 86,004 125,404 301,358 893,035 3,586,453 87,997 263,992 1,055,967 - - - 12,203 13,368 274,808 - - - 442,822 1,256,398 5,042,632 49,242 133,062 735,839 233,228 837,149 3,357,198 2,085 2,285 6,034 9,847 27,492 138,618 - - - - - - - - - - - 2,251 - - 12,232 42,067 126,202 499,493 336,470 1,126,190 4,751,664 442,822 1,256,398 5,042,632 336,470 1,126,190 4,751,664 106,352 130,208 290,968 Starting Fund Balance (926,498) (926,498) Net Change 3,016 130,208 Ending Fund Balance (923,482) (796,290) City of Evanston Financial Report Through 03/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 520 - SOLID WASTE FUND REVENUE Licenses, Permits and Fees 275,000 Charges for Services 3,632,394 Interfund Transfers 1,055,967 Intergovernmental Revenue - Other Revenue 238,000 Interest Income - REVENUE TOTALS 5,201,361 EXPENSE Salary and Benefits 750,241 Services and Supplies 3,732,176 Capital Outlay 25,750 Insurance and Other Chargebacks 149,325 Community Sponsored Organizations - Depreciation Expense - Contingencies - Debt Service 21,046 Miscellaneous 15,000 Interfund Transfers 504,807 EXPENSE TOTALS 5,198,345 Fund 520 - SOLID WASTE FUND Totals 3,016 Fund 520 - SOLID WASTE FUND Totals REVENUE TOTALS 5,201,361 EXPENSE TOTALS 5,198,345 Run by Ashley King on 04/24/2017 02:59:39 PM Page 31 of 51 March YTD 2016 2017 2017 Actual 283,620 850,859 3,387,680 - - - - - - 3,061 6,512 14,415 - - - 286,680 857,371 3,402,094 73,924 199,594 888,262 190,961 418,701 1,912,423 - - - 15,331 42,675 167,952 - - 44 - - - - - - - - - 2,319 6,958 26,762 282,536 667,929 2,995,443 286,680 857,371 3,402,094 282,536 667,929 2,995,443 4,145 189,442 406,652 Starting Fund Balance 773,239 773,239 Net Change (248,021) 189,442 Ending Fund Balance 525,218 962,681 City of Evanston Financial Report Through 03/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 600 - FLEET SERVICES FUND REVENUE Charges for Services 3,388,435 Interfund Transfers - Intergovernmental Revenue - Other Revenue 81,781 Interest Income 1,000 REVENUE TOTALS 3,471,216 EXPENSE Salary and Benefits 1,071,267 Services and Supplies 2,380,057 Capital Outlay - Insurance and Other Chargebacks 239,630 Depreciation Expense - Contingencies 450 3,471,216 Debt Service - Miscellaneous - Interfund Transfers 27,833 EXPENSE TOTALS 3,719,237 Fund 600 - FLEET SERVICES FUND Totals (248,021) EXPENSE TOTALS 3,719,237 Fund 600 - FLEET SERVICES FUND Totals REVENUE TOTALS Run by Ashley King on 04/24/2017 02:59:39 PM Page 32 of 51 March YTD 2016 2017 2017 Actual 129,171 387,514 1,455,172 - - - - 38,693 63,430 129,171 426,207 1,518,602 - - 102,765 1,855 17,379 - - - 1,624,064 - - - 1,855 17,379 1,726,829 129,171 426,207 1,518,602 1,855 17,379 1,726,829 127,317 408,829 (208,226) Starting Fund Balance 1,283,721 1,283,721 Net Change 229,853 408,829 Ending Fund Balance 1,513,574 1,692,550 City of Evanston Financial Report Through 03/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 601 - EQUIPMENT REPLACEMENT FUND REVENUE Charges for Services 1,550,058 Interfund Transfers - Other Revenue 210,217 REVENUE TOTALS 1,760,275 EXPENSE Services and Supplies 75,000 Capital Outlay 1,455,422 Depreciation Expense - Miscellaneous - EXPENSE TOTALS 1,530,422 Fund 601 - EQUIPMENT REPLACEMENT 229,853 Fund 601 - EQUIPMENT REPLACEMENT REVENUE TOTALS 1,760,275 EXPENSE TOTALS 1,530,422 Run by Ashley King on 04/24/2017 02:59:39 PM Page 33 of 51 March YTD 2016 2017 2017 Actual 13,534 40,603 441,246 68 205 69,552 904,073 2,477,167 9,994,682 109,807 275,341 89,822 603,288 1,453,884 6,546,063 16 55 218 1,630,786 4,247,254 17,141,583 46,132 130,157 448,109 112,042 176,733 4,073,131 - - - 1,338,878 4,102,413 14,539,279 - - - - - - - - - - - - - - 4,330 803 2,408 9,262 1,497,856 4,411,711 19,074,111 1,630,786 4,247,254 17,141,583 1,497,856 4,411,711 19,074,111 132,931 (164,457) (1,932,528) Starting Fund Balance (639,105) (639,105) Net Change (224,815) (164,457) Ending Fund Balance (863,920) (803,562) City of Evanston Financial Report Through 03/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 605 - INSURANCE FUND REVENUE Charges for Services 162,411 Interfund Transfers 4,987 Other Revenue 11,237,646 Workers Compensation and Liability 1,030,815 Insurance 6,413,937 Interest Income 1,000 REVENUE TOTALS 18,850,796 EXPENSE Salary and Benefits 534,441 Services and Supplies 2,385,248 Capital Outlay - Insurance and Other Chargebacks 16,146,290 Community Sponsored Organizations - Depreciation Expense - Contingencies - Debt Service - Miscellaneous - Interfund Transfers 9,632 EXPENSE TOTALS 19,075,611 Fund 605 - INSURANCE FUND Totals (224,815) Fund 605 - INSURANCE FUND Totals REVENUE TOTALS 18,850,796 EXPENSE TOTALS 19,075,611 Run by Ashley King on 04/24/2017 02:59:39 PM Page 34 of 51 March YTD 2016 2017 2017 Actual - - - - - - - - - 2,818,313 3,967,754 10,902,978 15 25 1,559,737 2,818,328 3,967,779 12,462,715 714,622 2,148,641 8,429,695 - - - - - - - - - - - 174,111 714,622 2,148,641 8,603,806 2,818,328 3,967,779 12,462,715 714,622 2,148,641 8,603,806 2,103,706 1,819,138 3,858,910 Starting Fund Balance 70,630,343 70,630,343 Net Change 4,636,709 1,819,138 Ending Fund Balance 75,267,052 72,449,481 City of Evanston Financial Report Through 03/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 700 - FIRE PENSION FUND REVENUE Property Taxes 7,868,709 Other Taxes 280,000 Interfund Transfers 43,000 Other Revenue 1,050,000 Interest Income 4,100,000 REVENUE TOTALS 13,341,709 EXPENSE Salary and Benefits 8,705,000 Services and Supplies - Community Sponsored Organizations - Debt Service - Miscellaneous - EXPENSE TOTALS 8,705,000 Fund 700 - FIRE PENSION FUND Totals 4,636,709 Fund 700 - FIRE PENSION FUND Totals REVENUE TOTALS 13,341,709 EXPENSE TOTALS 8,705,000 Run by Ashley King on 04/24/2017 02:59:39 PM Page 35 of 51 March YTD 2016 2017 2017 Actual - - - - - - - - - 3,626,183 5,152,538 16,286,867 20 32 2,713,348 3,626,202 5,152,570 19,000,215 934,218 2,799,631 11,094,711 - - - - - - - - 272,795 934,218 2,799,631 11,367,506 3,626,202 5,152,570 19,000,215 934,218 2,799,631 11,367,506 2,691,984 2,352,939 7,632,708 Starting Fund Balance 106,204,773 106,204,773 Net Change 6,627,200 2,352,939 Ending Fund Balance 112,831,973 108,557,712 City of Evanston Financial Report Through 03/31/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 705 - POLICE PENSION FUND REVENUE Property Taxes 9,912,200 Other Taxes 325,000 Interfund Transfers 57,000 Other Revenue 1,650,000 Interest Income 6,500,000 REVENUE TOTALS 18,444,200 EXPENSE Salary and Benefits 11,817,000 Services and Supplies - Debt Service - Miscellaneous - EXPENSE TOTALS 11,817,000 Fund 705 - POLICE PENSION FUND Totals REVENUE TOTALS 18,444,200 EXPENSE TOTALS 11,817,000 Fund 705 - POLICE PENSION FUND Totals 6,627,200 Run by Ashley King on 04/24/2017 02:59:39 PM Page 36 of 51