Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2017.02 February Monthly Report
To: Wally Bobkiewicz, City Manager Martin Lyons, Assistant City Manager/Chief Financial Officer From: Ashley King, Finance & Budget Manager Subject: February 2017 Monthly Financial Report Date: April 14, 2017 Please find attached the unaudited financial statements as of February 28, 2017. A summary by fund for revenues, expenditures, fund and cash balances is as follows: 17,941,158 15,493,719 2,447,439 17,244,431 6,393,110 143,192 61 143,131 178,531 213,938 134,341 126,525 7,816 592,461 594,204 1,000,000 166,667 833,333 833,333 833,333 973,897 872,529 101,368 862,186 805,707 20 4,556 (4,537)(32,826)127,615 346,108 142,998 203,110 1,616,788 1,440,087 156,675 106,115 50,559 62,863 (3,527) 35,700 35,700 (156,576)(156,576) 68,936 (68,936)(4,830)(6,210) 17,098 70 17,028 174,689 227,949 169,915 169,915 4,566 26,169 (21,603)(19,226)(19,226) 32,318 13,501 18,817 1,419,740 1,420,005 16,803 29,597 758,999 58,333 700,665 7,325,341 7,404,260 576 576 473,640 705,320 36,510 32,507 4,003 3,919 6,189 2,424 6,740 (4,315)412,945 421,267 (29,415)(29,415) 37,325 (37,325)97,752 97,752 22,034 22,034 100,328 100,329 2,054,480 2,054,480 2,800,535 2,815,330 88,593 200,508 (111,915)11,514,543 11,714,911 150,963 43,905 107,059 406,275 3,102,738 1,085,475 869,094 216,382 11,703,251 7,833,758 3,649,153 1,635,157 2,013,996 7,305,418 7,803,716 2,273,718 982,135 1,291,582 6,985,503 4,331,509 813,576 789,720 23,856 (902,642)(1,521,833) 570,691 385,393 185,297 958,536 240,347 297,036 15,524 281,512 1,565,233 1,166,845 2,616,468 2,913,856 (297,388)(936,493)1,493,203 TOTAL 35,205,767 24,992,042 10,213,725 72,742,952 59,756,145 Cash BalanceFund BalanceYTD Net YTD Expenses YTD Revenues 605 INSURANCE FUND 520 SOLID WASTE FUND 600 FLEET SERVICES FUND 601 EQUIPMENT REPLACEMENT FUND 515 SEWER FUND 505 PARKING SYSTEM FUND 510 WATER FUND 420 SPECIAL ASSESSMENT FUND 415 CAPITAL IMPROVEMENTS FUND 320 DEBT SERVICE FUND 345 CHICAGO-MAIN TIF 350 SPECIAL SERVICE AREA (SSA) #6 330 HOWARD-RIDGE TIF FUND 335 WEST EVANSTON TIF FUND 340 DEMPSTER-DODGE TIF FUND 310 HOWARD-HARTREY TIF 186 LIBRARY DEBT SERVICE FUND 300 WASHINGTON NATIONAL TIF 240 HOME FUND 250 AFFORDABLE HOUSING FUND 235 NEIGHBORHOOD IMPROVEMENT 210 SPECIAL SERVICE AREA (SSA) #4 215 CDBG FUND 220 CDBG LOAN 195 NEIGHBORHOOD STABILIZATION 200 MOTOR FUEL TAX FUND 205 EMERGENCY TELEPHONE (E911) 185 LIBRARY FUND 100 GENERAL FUND 176 HEALTH AND HUMAN SERVICES 175 GENERAL ASSISTANCE FUND Fund Fund Description 180 GOOD NEIGHBOR FUND Memorandum Included above are the ending balances as of February 28, 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 propert y tax) due to the City and accounts payable/accrued expenses. As of February 28, 2017, the General Fund is reporting a net surplus of $2,447,439. The General Fund balance is $17,244,431 with a cash balance of $6,393,110. 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 15.10% of budget and expenses lower at 13.05%. Through February 28, 2017, the SSA #4 Fund is showing a negative fund and cash balance of $156,576. This is due to the timing of payments to the Downtown Evanston group. Through February 28, 2017, the Home Fund is showing a negative cash balance of $19,226. Through February 28, 2017, the CDBG Fund is showing a negative cash balance of $6,210. This will be reimbursed with draw-downs during February. Through February 28, 2017, the Capital Fund is showing a fund balance of $11,514,543 and a cash balance of $11,714,911. 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 February 28, 2017, the enterprise funds (Parking, Water, and Sewer) have balances above average due to the timing of capital projects for 2017 . A $2.1 million check is being processed for Emerson Ridge Greenbay project payment to IDOT in April. This will reduce the fund balances in Water, Sewer, and Parking. Through February 28, 2017, the Solid Waste Fund has a negative fund balance of $902,642 and a negative cash balance of $1,521,833. Through February 28, 2017, the Insurance Fund is showing a negative fund balance of $936,493 with a cash balance of $1,493,203. 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 Feb YTD %2016 Actual Actual Actual 3,826,821 3,886,303 13.57% 27,302,687 4,722,017 8,483,806 17.17% 44,922,404 1,517,686 2,019,042 11.70% 16,574,229 308,570 401,657 10.54% 3,602,413 1,035,309 1,688,496 18.74% 8,946,002 633,976 1,267,953 16.45% 8,709,861 50,413 77,984 9.28% 983,516 61,206 111,986 5.43% 1,481,808 - - - - - - - - - 1,334 3,931 7.85% 30,285 - - - - - - 12,157,333 17,941,158 15.10% 112,553,206 36,643 62,404 12.53% 433,601 31,185 47,353 17.19% 294,665 511,302 892,756 9.21% 6,983,366 58,833 101,727 9.80% 1,052,130 821,450 1,231,189 12.69% 9,151,462 190,173 333,149 11.88% 2,510,408 3,918,996 5,834,776 15.26% 37,817,627 2,226,113 3,364,560 13.85% 23,235,714 230,288 424,060 11.84% 3,097,351 - - (1,475) 725,210 1,229,130 9.94% 11,997,476 1,089,969 1,972,614 12.17% 14,738,137 13.05% 111,310,462 12,157,333 17,941,158 112,553,206 9,840,161 15,493,719 111,310,462 2,317,172 2,447,439 1,242,744 - 12,361,460 9,840,161 15,493,719 REVENUE TOTALS 118,778,832 EXPENSE TOTALS 118,686,191 Fund 100 - GENERAL FUND Totals 92,641 EXPENSE TOTALS 118,686,191 Fund 100 - GENERAL FUND Totals Police 38,223,842 Fire 24,294,001 16,212,848 Health Parks Public Works Agency 3,582,312 Law Dept 1,038,137 Admin Services 9,700,879 Community Development 2,804,668 EXPENSE City Council 498,189 City Clerk 275,488 City Manager's Office 9,694,367 Special Assessment - Reappropriation of Surplus - REVENUE TOTALS 118,778,832 Insurance - Library Revenue - Interest Income 50,100 Intergovernmental Revenue 839,965 Other Revenue 2,060,829 Workers Compensation and Liability - Fines and Forfeitures 3,810,000 Charges for Services 9,010,612 Interfund Transfers 7,705,774 REVENUE Property Taxes 28,639,628 Other Taxes 49,402,274 Licenses, Permits and Fees 17,259,650 February 2017 Financial Report Through 02/28/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 100 - GENERAL FUND Fund 505 - PARKING SYSTEM FUND Feb YTD %2016 Actual Actual Actual - - - - - +++ - - 600 +++ 3,350 - - +++ - 646,722 1,056,972 15.54% 6,523,524 - - 0.00% 3,711,768 - - 0.00% - 8,508 22,567 11.11% 195,895 2,772 5,336 15.22% 38,159 658,002 1,085,475 9.71% 10,472,695 85,116 154,897 12.41% 1,338,122 385,649 417,324 11.92% 3,084,543 - - 0.00% 2,867,258 43,956 84,204 16.07% 504,784 - - - - - - 221 221 2.00% 5,910 - - 0.00% 390,235 - - 0.00% 238,064 106,224 212,447 13.41% 1,303,783 621,166 869,094 5.98% 9,732,700 658,002 1,085,475 10,472,695 621,166 869,094 9,732,700 36,836 216,382 739,995 Fund 505 - PARKING SYSTEM FUND (3,350,830) Fund 505 - PARKING SYSTEM FUND REVENUE TOTALS 11,173,922 EXPENSE TOTALS 14,524,752 Miscellaneous 304,000 Interfund Transfers 1,584,683 EXPENSE TOTALS 14,524,752 Depreciation Expense - Contingencies 11,000 Debt Service 4,331,771 Capital Outlay 3,020,000 Insurance and Other Chargebacks 524,102 Community Sponsored Organizations - REVENUE TOTALS 11,173,922 EXPENSE Salary and Benefits 1,247,921 Services and Supplies 3,501,275 Intergovernmental Revenue 12,125 Other Revenue 203,216 Interest Income 35,070 Fines and Forfeitures - Charges for Services 6,802,875 Interfund Transfers 4,120,636 REVENUE Property Taxes - Other Taxes - Licenses, Permits and Fees - February 2017 Financial Report Through 02/28/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 505 - PARKING SYSTEM FUND Fund 510 - WATER FUND Feb YTD %2016 Actual Actual Actual - - - 4,554 9,743 13.92% 90,592 1,969,438 3,629,421 20.75% 16,058,497 - - - - - - 2,919 6,204 0.09% 306,143 2,001 3,785 236.58% 16,116 1,978,912 3,649,153 14.96% 16,471,349 335,408 626,924 13.66% 4,494,885 204,021 232,038 6.43% 2,635,607 - (689)-0.36% 166,709 97,192 179,832 15.32% 1,110,835 - - - - - - - - 0.00% 1,000 - - 0.00% 633,708 - - 0.00% 10,543 298,526 597,052 17.05% 12,156,871 11.22% 21,210,158 1,978,912 3,649,153 16,471,349 935,146 1,635,157 21,210,158 1,043,766 2,013,996 (4,738,810) REVENUE TOTALS 24,395,000 EXPENSE TOTALS 14,568,688 Fund 510 - WATER FUND Totals 9,826,312 EXPENSE TOTALS 14,568,688 935,146 1,635,157 Fund 510 - WATER FUND Totals Debt Service 1,438,470 Miscellaneous 62,980 Interfund Transfers 3,502,313 Community Sponsored Organizations - Depreciation Expense - Contingencies 1,000 Services and Supplies 3,611,150 Capital Outlay 189,300 Insurance and Other Chargebacks 1,174,064 Interest Income 1,600 REVENUE TOTALS 24,395,000 EXPENSE Salary and Benefits 4,589,411 Interfund Transfers - Intergovernmental Revenue - Other Revenue 6,828,400 REVENUE Other Taxes - Licenses, Permits and Fees 70,000 Charges for Services 17,495,000 February 2017 Financial Report Through 02/28/17 Prior Fiscal Year Activity Included Detail Listing 2017 Classification Budget Fund 510 - WATER FUND Fund 515 - SEWER FUND Feb YTD %2016 Actual Actual Actual 1,064,097 2,272,928 18.15% 13,048,760 - - - - - 0.00% 3,087 422 790 78.95% 4,450 1,064,520 2,273,718 17.32% 13,056,297 74,831 137,670 13.91% 985,218 2,019 2,261 0.23% 583,385 - - 0.00% 790,772 36,918 70,288 16.23% 414,270 - - - - - - 426,184 606,637 7.25% 1,336,366 - - 0.00% 5,000 82,640 165,279 16.67% 773,873 622,592 982,135 6.72% 4,888,884 1,064,520 2,273,718 13,056,297 622,592 982,135 4,888,884 441,927 1,291,582 8,167,412 Fund 515 - SEWER FUND Totals (1,480,742) Fund 515 - SEWER FUND Totals REVENUE TOTALS 13,126,315 EXPENSE TOTALS 14,607,057 Miscellaneous 1,500 Interfund Transfers 991,677 EXPENSE TOTALS 14,607,057 Depreciation Expense - Contingencies - Debt Service 8,370,946 Services and Supplies 1,000,800 Capital Outlay 2,819,700 Insurance and Other Chargebacks 432,953 Interest Income 1,000 REVENUE TOTALS 13,126,315 EXPENSE Salary and Benefits 989,481 REVENUE Charges for Services 12,521,150 Interfund Transfers - Other Revenue 604,165 February 2017 Financial Report Through 02/28/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 515 - SEWER FUND Fund 520 - SOLID WASTE FUND Feb YTD %2016 Actual Actual Actual - 44,740 16.27% 125,404 301,317 591,677 16.29% 3,586,453 87,997 175,995 16.67% 1,055,967 - - - 715 1,165 0.49% 274,808 - - - 390,029 813,576 15.64% 5,042,632 48,171 83,820 11.17% 726,698 601,876 603,921 16.18% 3,357,198 199 199 0.77% 6,034 10,147 17,645 11.82% 138,618 - - - - - - - - - - - 0.00% 2,251 - - 0.00% 12,232 42,067 84,135 16.67% 499,493 702,461 789,720 15.19% 4,742,523 390,029 813,576 5,042,632 702,461 789,720 4,742,523 (312,432) 23,856 300,109 Fund 520 - SOLID WASTE FUND Totals 3,016 Fund 520 - SOLID WASTE FUND Totals REVENUE TOTALS 5,201,361 EXPENSE TOTALS 5,198,345 Miscellaneous 15,000 Interfund Transfers 504,807 EXPENSE TOTALS 5,198,345 Depreciation Expense - Contingencies - Debt Service 21,046 Capital Outlay 25,750 Insurance and Other Chargebacks 149,325 Community Sponsored Organizations - REVENUE TOTALS 5,201,361 EXPENSE Salary and Benefits 750,241 Services and Supplies 3,732,176 Intergovernmental Revenue - Other Revenue 238,000 Interest Income - REVENUE Licenses, Permits and Fees 275,000 Charges for Services 3,632,394 Interfund Transfers 1,055,967 February 2017 Financial Report Through 02/28/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 520 - SOLID WASTE FUND February 2017 YTD 2017 2016 Actual 3,826,821 3,886,303 27,302,687 4,722,017 8,483,806 44,922,404 1,517,686 2,019,042 16,574,229 308,570 401,657 3,602,413 1,035,309 1,688,496 8,946,002 633,976 1,267,953 8,709,861 50,413 77,984 983,516 61,206 111,986 1,481,808 - - - - - - - - - 1,334 3,931 30,285 - - - - - - 12,157,333 17,941,158 112,553,206 5,148,296 9,009,043 61,447,382 711,567 1,002,119 11,978,983 9,477 13,167 159,648 3,254,663 4,068,423 28,062,250 9,399 9,399 865,156 - - - 428 428 51,836 - - - 24,862 28,200 1,702,512 681,469 1,362,938 7,041,881 9,840,161 15,493,719 111,309,648 12,157,333 17,941,158 112,553,206 9,840,161 15,493,719 111,309,648 2,317,172 2,447,439 1,243,558 Starting Fund Balance 14,796,992 14,796,992 Net Change 92,641 2,447,439 Ending Fund Balance 14,889,633 17,244,431 REVENUE TOTALS 118,778,832 EXPENSE TOTALS 118,686,191 Fund 100 - GENERAL FUND Totals 92,641 Interfund Transfers 9,909,626 EXPENSE TOTALS 118,686,191 Fund 100 - GENERAL FUND Totals Contingencies 213,519 Debt Service - Miscellaneous 1,200,481 Insurance and Other Chargebacks 30,321,297 Community Sponsored Organizations 204,568 Depreciation Expense - EXPENSE Salary and Benefits 62,620,910 Services and Supplies 13,716,790 Capital Outlay 499,000 Special Assessment - Reappropriation of Surplus - REVENUE TOTALS 118,778,832 Insurance - Library Revenue - Interest Income 50,100 Intergovernmental Revenue 839,965 Other Revenue 2,060,829 Workers Compensation and Liability - Fines and Forfeitures 3,810,000 Charges for Services 9,010,612 Interfund Transfers 7,705,774 Property Taxes 28,639,628 Other Taxes 49,402,274 Licenses, Permits and Fees 17,259,650 City of Evanston Financial Report Through 02/28/17 Prior Fiscal Year Activity Included Classification Budget 2017 Fund 100 - GENERAL FUND REVENUE Run by Ashley King on 03/28/2017 12:33:20 PM Page 1 of 53 February 2017 YTD 2017 2016 Actual 117,581 120,472 827,615 - - - - - - - - - - - - - - - - - 167 - 13,759 49,423 - - - - - - - - - 53 111 802 - - - - - - 117,634 134,341 878,006 21,356 37,126 246,916 42,316 82,872 529,013 - - - 3,708 6,527 26,205 - - - - - - - - - - - - - - 2,723 - - - 67,380 126,525 804,857 117,634 134,341 878,006 67,380 126,525 804,857 50,254 7,816 73,149 Starting Fund Balance 584,645 584,645 Net Change (252,971) 7,816 Ending Fund Balance 331,674 592,461 REVENUE TOTALS 926,000 EXPENSE TOTALS 1,178,971 Fund 175 - GENERAL ASSISTANCE FUND (252,971) Interfund Transfers - EXPENSE TOTALS 1,178,971 Fund 175 - GENERAL ASSISTANCE FUND Contingencies - Debt Service - Miscellaneous 7,000 Insurance and Other Chargebacks 30,968 Community Sponsored Organizations - Depreciation Expense - EXPENSE Salary and Benefits 282,103 Services and Supplies 858,900 Capital Outlay - Special Assessment - Reappropriation of Surplus - REVENUE TOTALS 926,000 Insurance - Library Revenue - Interest Income 1,000 Intergovernmental Revenue - Other Revenue 25,000 Workers Compensation and Liability - Fines and Forfeitures - Charges for Services - Interfund Transfers - Property Taxes 900,000 Other Taxes - Licenses, Permits and Fees - City of Evanston Financial Report Through 02/28/17 Prior Fiscal Year Activity Included Classification Budget 2017 Fund 175 - GENERAL ASSISTANCE FUND REVENUE Run by Ashley King on 03/28/2017 12:33:20 PM Page 2 of 53 February 2017 YTD 2017 2016 Actual - - - 71,596 143,192 884,794 - - - - - - 71,596 143,192 884,794 - 61 61 - - - - - 849,333 - - - - 61 849,394 71,596 143,192 884,794 - 61 849,394 71,596 143,131 35,400 Starting Fund Balance 35,400 35,400 Net Change - 143,131 Ending Fund Balance 35,400 178,531 EXPENSE TOTALS 859,153 Fund 176 - HEALTH AND HUMAN - EXPENSE TOTALS 859,153 Fund 176 - HEALTH AND HUMAN REVENUE TOTALS 859,153 Capital Outlay - Community Sponsored Organizations 92,098 Miscellaneous - Other Revenue - REVENUE TOTALS 859,153 EXPENSE Services and Supplies 767,055 Charges for Services - Interfund Transfers 859,153 Intergovernmental Revenue - City of Evanston Financial Report Through 02/28/17 Prior Fiscal Year Activity Included Classification Budget 2017 Fund 176 - HEALTH AND HUMAN SERVICES REVENUE Run by Ashley King on 03/28/2017 12:33:20 PM Page 3 of 53 February 2017 YTD 2017 2016 Actual - 1,000,000 1,000,000 - 1,000,000 1,000,000 83,333 166,667 1,000,000 83,333 166,667 1,000,000 - - 1,000,000 83,333 166,667 1,000,000 (83,333) 833,333 (0) Starting Fund Balance - - Net Change - 833,333 Ending Fund Balance - 833,333 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 Other Revenue 1,000,000 REVENUE TOTALS 1,000,000 EXPENSE Interfund Transfers 1,000,000 City of Evanston Financial Report Through 02/28/17 Prior Fiscal Year Activity Included Classification Budget 2017 Fund 180 - GOOD NEIGHBOR FUND REVENUE Run by Ashley King on 03/28/2017 12:33:20 PM Page 4 of 53 February 2017 YTD 2017 2016 Actual 866,529 883,483 6,136,248 - - 4,141 11,572 23,948 152,537 - - 235,800 2,820 4,820 75,418 342 492 67,943 5,333 60,925 339,027 113 230 4,717 886,709 973,897 7,015,830 311,192 547,347 4,246,657 172,934 197,167 1,733,725 - - 57,842 42,265 70,745 406,163 - - - - - - - - - - - 250,000 28,635 57,270 90,272 555,025 872,529 6,784,659 886,709 973,897 7,015,830 555,025 872,529 6,784,659 331,684 101,368 231,172 Starting Fund Balance 760,818 760,818 Net Change - 101,368 Ending Fund Balance 760,818 862,186 EXPENSE TOTALS 7,250,345 Fund 185 - LIBRARY FUND Totals - EXPENSE TOTALS 7,250,345 Fund 185 - LIBRARY FUND Totals REVENUE TOTALS 7,250,345 Debt Service - Miscellaneous - Interfund Transfers 343,618 Insurance and Other Chargebacks 500,433 Depreciation Expense - Contingencies - EXPENSE Salary and Benefits 4,460,836 Services and Supplies 1,940,058 Capital Outlay 5,400 Library Revenue 386,020 Interest Income 5,400 REVENUE TOTALS 7,250,345 Interfund Transfers 190,200 Intergovernmental Revenue 57,418 Other Revenue 24,849 Property Taxes 6,376,358 Other Taxes 46,100 Fines and Forfeitures 164,000 City of Evanston Financial Report Through 02/28/17 Prior Fiscal Year Activity Included Classification Budget 2017 Fund 185 - LIBRARY FUND REVENUE Run by Ashley King on 03/28/2017 12:33:20 PM Page 5 of 53 February 2017 YTD 2017 2016 Actual - - 364,827 - - 676,150 - - 1 - - 1,040,978 - - 12,349 - - - - - 385,696 - - - - - 398,044 - - 1,040,978 - - 398,044 - - 642,934 Starting Fund Balance 16,803 16,803 Net Change - - Ending Fund Balance 16,803 16,803 Fund 186 - LIBRARY DEBT SERVICE - Fund 186 - LIBRARY DEBT SERVICE REVENUE TOTALS 345,955 EXPENSE TOTALS 345,955 Debt Service 345,955 Miscellaneous - EXPENSE TOTALS 345,955 REVENUE TOTALS 345,955 EXPENSE Services and Supplies - Capital Outlay - Property Taxes 345,955 Other Revenue - Interest Income - City of Evanston Financial Report Through 02/28/17 Prior Fiscal Year Activity Included Classification Budget 2017 Fund 186 - LIBRARY DEBT SERVICE FUND REVENUE Run by Ashley King on 03/28/2017 12:33:20 PM Page 6 of 53 February 2017 YTD 2017 2016 Actual - - - - - 91,447 - - - 11 20 - 11 20 91,447 1,679 3,150 22,569 - - 6,319 - - 39,316 373 653 4,173 - - - - - 1,705 377 753 17,623 2,429 4,556 91,705 11 20 91,447 2,429 4,556 91,705 (2,418) (4,537) (259) Starting Fund Balance (28,289) (28,289) Net Change (303) (4,537) Ending Fund Balance (28,592) (32,826) EXPENSE TOTALS 98,899 Fund 195 - NEIGHBORHOOD 40,601 EXPENSE TOTALS 98,899 Fund 195 - NEIGHBORHOOD REVENUE TOTALS 139,500 Debt Service - Miscellaneous 50,000 Interfund Transfers 4,518 Services and Supplies 5,100 Capital Outlay 7,000 Insurance and Other Chargebacks 3,984 Interest Income - REVENUE TOTALS 139,500 EXPENSE Salary and Benefits 28,297 Licenses, Permits and Fees - Intergovernmental Revenue 139,500 Other Revenue - City of Evanston Financial Report Through 02/28/17 Prior Fiscal Year Activity Included Classification Budget 2017 Fund 195 - NEIGHBORHOOD STABILIZATION FUND REVENUE Run by Ashley King on 03/28/2017 12:33:20 PM Page 7 of 53 February 2017 YTD 2017 2016 Actual 167,974 344,675 1,896,461 - - - 738 1,433 6,613 - - - 168,712 346,108 1,903,074 - - - - - 130,789 - - - - - - - - - 71,499 142,998 2,189,000 71,499 142,998 2,319,789 168,712 346,108 1,903,074 71,499 142,998 2,319,789 97,212 203,110 (416,715) Starting Fund Balance 1,413,678 1,413,678 Net Change (327,990) 203,110 Ending Fund Balance 1,085,688 1,616,788 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 Miscellaneous - Interfund Transfers 857,990 EXPENSE TOTALS 2,248,990 Capital Outlay 1,391,000 Contingencies - Debt Service - Reappropriation of Surplus - REVENUE TOTALS 1,921,000 EXPENSE Services and Supplies - Intergovernmental Revenue 1,920,000 Other Revenue - Interest Income 1,000 City of Evanston Financial Report Through 02/28/17 Prior Fiscal Year Activity Included Classification Budget 2017 Fund 200 - MOTOR FUEL TAX FUND REVENUE Run by Ashley King on 03/28/2017 12:33:20 PM Page 8 of 53 February 2017 YTD 2017 2016 Actual 77,139 156,258 1,038,331 - - - - - - 150 416 2,472 77,289 156,675 1,040,803 30,628 53,805 509,028 24,331 28,313 263,105 - - 423,493 6,533 11,834 91,628 - - - - - - - - - - - - 6,081 12,163 142,207 67,574 106,115 1,429,460 77,289 156,675 1,040,803 67,574 106,115 1,429,460 9,715 50,559 (388,657) Starting Fund Balance 12,304 12,304 Net Change (8,718) 50,559 Ending Fund Balance 3,586 62,863 Fund 205 - EMERGENCY TELEPHONE (8,718) Fund 205 - EMERGENCY TELEPHONE REVENUE TOTALS 1,021,700 EXPENSE TOTALS 1,030,418 Miscellaneous - Interfund Transfers 72,977 EXPENSE TOTALS 1,030,418 Community Sponsored Organizations - Contingencies - Debt Service - Services and Supplies 282,400 Capital Outlay 55,000 Insurance and Other Chargebacks 102,517 Interest Income 1,000 REVENUE TOTALS 1,021,700 EXPENSE Salary and Benefits 517,524 Other Taxes 1,020,700 Intergovernmental Revenue - Other Revenue - City of Evanston Financial Report Through 02/28/17 Prior Fiscal Year Activity Included Classification Budget 2017 Fund 205 - EMERGENCY TELEPHONE (E911) FUND REVENUE Run by Ashley King on 03/28/2017 12:33:20 PM Page 9 of 53 February 2017 YTD 2017 2016 Actual 35,700 35,700 321,266 - - 2 35,700 35,700 321,268 - - 323,000 - - - - - - - - 323,000 35,700 35,700 321,268 - - 323,000 35,700 35,700 (1,732) Starting Fund Balance (192,276) (192,276) Net Change - 35,700 Ending Fund Balance (192,276) (156,576) EXPENSE TOTALS 320,000 Fund 210 - SPECIAL SERVICE AREA (SSA) - EXPENSE TOTALS 320,000 Fund 210 - SPECIAL SERVICE AREA (SSA) REVENUE TOTALS 320,000 EXPENSE Services and Supplies 320,000 Debt Service - Miscellaneous - Property Taxes 320,000 Interest Income - REVENUE TOTALS 320,000 City of Evanston Financial Report Through 02/28/17 Prior Fiscal Year Activity Included Classification Budget 2017 Fund 210 - SPECIAL SERVICE AREA (SSA) #4 REVENUE Run by Ashley King on 03/28/2017 12:33:20 PM Page 10 of 53 February 2017 YTD 2017 2016 Actual - - - - - - - - 2,016,478 - - 10,197 - - - - - 2,026,675 28,801 52,737 414,848 1,040 1,040 7,600 - - 608,829 7,620 13,699 87,411 - - 507,815 - - - - - - - - 61,555 730 1,460 335,774 38,191 68,936 2,023,832 - - 2,026,675 38,191 68,936 2,023,832 (38,191) (68,936) 2,843 Starting Fund Balance 64,106 64,106 Net Change (9,484) (68,936) Ending Fund Balance 54,622 (4,830) EXPENSE TOTALS 2,281,978 Fund 215 - CDBG FUND Totals (9,484) EXPENSE TOTALS 2,281,978 Fund 215 - CDBG FUND Totals REVENUE TOTALS 2,272,494 Debt Service - Miscellaneous 569,970 Interfund Transfers 829,458 Insurance and Other Chargebacks 93,120 Community Sponsored Organizations 175,500 Contingencies - EXPENSE Salary and Benefits 393,090 Services and Supplies 220,840 Capital Outlay - Other Revenue - Interest Income - REVENUE TOTALS 2,272,494 Charges for Services - Interfund Transfers - Intergovernmental Revenue 2,272,494 City of Evanston Financial Report Through 02/28/17 Prior Fiscal Year Activity Included Classification Budget 2017 Fund 215 - CDBG FUND REVENUE Run by Ashley King on 03/28/2017 12:33:20 PM Page 11 of 53 February 2017 YTD 2017 2016 Actual - - - 13,610 17,070 208,541 10 28 4,656 13,620 17,098 213,197 - - - 70 70 160,641 - - - - - - 70 70 160,641 13,620 17,098 213,197 70 70 160,641 13,550 17,028 52,555 Starting Fund Balance 157,661 157,661 Net Change - 17,028 Ending Fund Balance 157,661 174,689 Fund 220 - CDBG LOAN Totals - Fund 220 - CDBG LOAN Totals REVENUE TOTALS 293,000 EXPENSE TOTALS 293,000 Miscellaneous - Interfund Transfers - EXPENSE TOTALS 293,000 REVENUE TOTALS 293,000 EXPENSE Salary and Benefits - Services and Supplies 293,000 Intergovernmental Revenue - Other Revenue 293,000 Interest Income - City of Evanston Financial Report Through 02/28/17 Prior Fiscal Year Activity Included Classification Budget 2017 Fund 220 - CDBG LOAN REVENUE Run by Ashley King on 03/28/2017 12:33:20 PM Page 12 of 53 February 2017 YTD 2017 2016 Actual - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Starting Fund Balance 169,915 169,915 Net Change (100,000) - Ending Fund Balance 69,915 169,915 EXPENSE TOTALS 100,000 Fund 235 - NEIGHBORHOOD (100,000) EXPENSE TOTALS 100,000 Fund 235 - NEIGHBORHOOD REVENUE TOTALS - Debt Service - Miscellaneous 100,000 Interfund Transfers - REVENUE TOTALS - EXPENSE Services and Supplies - Capital Outlay - Other Taxes - Interfund Transfers - Interest Income - City of Evanston Financial Report Through 02/28/17 Prior Fiscal Year Activity Included Classification Budget 2017 Fund 235 - NEIGHBORHOOD IMPROVEMENT REVENUE Run by Ashley King on 03/28/2017 12:33:20 PM Page 13 of 53 February 2017 YTD 2017 2016 Actual - - 178,211 2,157 4,564 27,259 1 2 14 2,158 4,566 205,484 2,992 5,235 31,964 10,184 20,209 180,110 - - - 404 724 3,998 - - - - - - - - 100 - - (8,295) 13,580 26,169 207,876 2,158 4,566 205,484 13,580 26,169 207,876 (11,422) (21,603) (2,392) Starting Fund Balance 2,377 2,377 Net Change (831) (21,603) Ending Fund Balance 1,546 (19,226) EXPENSE TOTALS 586,692 Fund 240 - HOME FUND Totals (831) EXPENSE TOTALS 586,692 Fund 240 - HOME FUND Totals REVENUE TOTALS 585,861 Debt Service - Miscellaneous 500 Interfund Transfers - Capital Outlay - Insurance and Other Chargebacks 4,987 Community Sponsored Organizations - REVENUE TOTALS 585,861 EXPENSE Salary and Benefits 41,005 Services and Supplies 540,200 Intergovernmental Revenue 585,861 Other Revenue - Interest Income - City of Evanston Financial Report Through 02/28/17 Prior Fiscal Year Activity Included Classification Budget 2017 Fund 240 - HOME FUND REVENUE Run by Ashley King on 03/28/2017 12:33:20 PM Page 14 of 53 February 2017 YTD 2017 2016 Actual - - 106,780 - - - - - - 417 32,083 448,343 84 234 1,392 501 32,318 556,515 2,992 5,235 34,138 - - 201 - - - 336 588 3,178 - - 735 - - - 5,950 7,678 110,956 - - - 9,278 13,501 149,207 501 32,318 556,515 9,278 13,501 149,207 (8,777) 18,817 407,308 Starting Fund Balance 1,400,923 1,400,923 Net Change (1,071,422) 18,817 Ending Fund Balance 329,501 1,419,740 Fund 250 - AFFORDABLE HOUSING FUND (1,071,422) Fund 250 - AFFORDABLE HOUSING FUND REVENUE TOTALS 635,830 EXPENSE TOTALS 1,707,252 Miscellaneous 102,500 Interfund Transfers - EXPENSE TOTALS 1,707,252 Insurance and Other Chargebacks 8,800 Community Sponsored Organizations 455,000 Debt Service - EXPENSE Salary and Benefits 63,452 Services and Supplies 1,077,500 Capital Outlay - Other Revenue 585,600 Interest Income 230 REVENUE TOTALS 635,830 Other Taxes 50,000 Interfund Transfers - Intergovernmental Revenue - City of Evanston Financial Report Through 02/28/17 Prior Fiscal Year Activity Included Classification Budget 2017 Fund 250 - AFFORDABLE HOUSING FUND REVENUE Run by Ashley King on 03/28/2017 12:33:20 PM Page 15 of 53 February 2017 YTD 2017 2016 Actual 747,788 755,625 4,729,649 - - - - - - - - - 1,789 3,373 14,012 749,577 758,999 4,743,661 - - - - - 2,750 - - 4,473 - - - - - 1,098,676 29,167 58,333 4,455,515 29,167 58,333 5,561,415 749,577 758,999 4,743,661 29,167 58,333 5,561,415 720,411 700,665 (817,754) Starting Fund Balance 6,624,676 6,624,676 Net Change (5,385,636) 700,665 Ending Fund Balance 1,239,040 7,325,341 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 5,155,000 Debt Service - Miscellaneous 100,000 Interfund Transfers 9,940,636 EXPENSE Salary and Benefits - Services and Supplies 500,000 Capital Outlay - Other Revenue - Interest Income 10,000 REVENUE TOTALS 5,155,000 Property Taxes 5,145,000 Other Taxes - Interfund Transfers - City of Evanston Financial Report Through 02/28/17 Prior Fiscal Year Activity Included Classification Budget 2017 Fund 300 - WASHINGTON NATIONAL TIF FUND REVENUE Run by Ashley King on 03/28/2017 12:33:20 PM Page 16 of 53 February 2017 YTD 2017 2016 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 - - EXPENSE TOTALS - Fund 305 - SPECIAL SERVICE AREA (SSA) - EXPENSE TOTALS - Fund 305 - SPECIAL SERVICE AREA (SSA) REVENUE TOTALS - Debt Service - Miscellaneous - Interfund Transfers - Interest Income - REVENUE TOTALS - EXPENSE Services and Supplies - Property Taxes - Interfund Transfers - Other Revenue - City of Evanston Financial Report Through 02/28/17 Prior Fiscal Year Activity Included Classification Budget 2017 Fund 305 - SPECIAL SERVICE AREA (SSA) #5 REVENUE Run by Ashley King on 03/28/2017 12:33:20 PM Page 17 of 53 February 2017 YTD 2017 2016 Actual - - 1,233,675 - - - 292 576 2,319 292 576 1,235,994 - - 2,488 - - - - - - - - - - - 129,192 - - 1,741,757 - - 1,873,437 292 576 1,235,994 - - 1,873,437 292 576 (637,443) Starting Fund Balance 473,064 473,064 Net Change (87,357) 576 Ending Fund Balance 385,707 473,640 REVENUE TOTALS - EXPENSE TOTALS 87,357 Fund 310 - HOWARD-HARTREY TIF Totals (87,357) Interfund Transfers 87,357 EXPENSE TOTALS 87,357 Fund 310 - HOWARD-HARTREY TIF Totals Community Sponsored Organizations - Debt Service - Miscellaneous - REVENUE TOTALS - EXPENSE Services and Supplies - Capital Outlay - Property Taxes - Other Revenue - Interest Income - City of Evanston Financial Report Through 02/28/17 Prior Fiscal Year Activity Included Classification Budget 2017 Fund 310 - HOWARD-HARTREY TIF REVENUE Run by Ashley King on 03/28/2017 12:33:20 PM Page 18 of 53 February 2017 YTD 2017 2016 Actual 1,516,460 1,539,139 10,438,928 256,961 513,922 3,079,968 - - 8,211,196 733 1,419 24,264 1,774,154 2,054,480 21,754,356 - - 149,553 - - 23,454,863 - - - - - - - - 23,604,416 1,774,154 2,054,480 21,754,356 - - 23,604,416 1,774,154 2,054,480 (1,850,061) Starting Fund Balance 746,055 746,055 Net Change (305,500) 2,054,480 Ending Fund Balance 440,555 2,800,535 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 14,125,637 Debt Service 14,310,887 Miscellaneous - Interfund Transfers - Interest Income 1,500 REVENUE TOTALS 14,125,637 EXPENSE Services and Supplies 120,250 Property Taxes 10,879,993 Interfund Transfers 3,244,144 Other Revenue - City of Evanston Financial Report Through 02/28/17 Prior Fiscal Year Activity Included Classification Budget 2017 Fund 320 - DEBT SERVICE FUND REVENUE Run by Ashley King on 03/28/2017 12:33:20 PM Page 19 of 53 February 2017 YTD 2017 2016 Actual 19,103 23,510 533,105 13,000 13,000 282,307 0 0 374 32,103 36,510 815,787 22,365 22,365 679,056 - - - - - - - - - 74 142 693 - - - 5,000 10,000 107,500 27,439 32,507 787,249 32,103 36,510 815,787 27,439 32,507 787,249 4,664 4,003 28,537 Starting Fund Balance (84) (84) Net Change (13,200) 4,003 Ending Fund Balance (13,284) 3,919 Fund 330 - HOWARD-RIDGE TIF FUND (13,200) Fund 330 - HOWARD-RIDGE TIF FUND REVENUE TOTALS 1,585,400 EXPENSE TOTALS 1,598,600 Miscellaneous - Interfund Transfers 60,000 EXPENSE TOTALS 1,598,600 Insurance and Other Chargebacks - Community Sponsored Organizations - Debt Service 600 REVENUE TOTALS 1,585,400 EXPENSE Services and Supplies 538,000 Capital Outlay 1,000,000 Property Taxes 555,000 Other Revenue 1,030,000 Interest Income 400 City of Evanston Financial Report Through 02/28/17 Prior Fiscal Year Activity Included Classification Budget 2017 Fund 330 - HOWARD-RIDGE TIF FUND REVENUE Run by Ashley King on 03/28/2017 12:33:20 PM Page 20 of 53 February 2017 YTD 2017 2016 Actual - - - 1,028 2,057 11,311 195 368 1,684 1,223 2,424 12,995 - - 507 - - (1,028) - - - - - - 910 1,740 8,519 - - - 2,500 5,000 30,000 3,410 6,740 37,998 1,223 2,424 12,995 3,410 6,740 37,998 (2,187) (4,315) (25,003) Starting Fund Balance 417,260 417,260 Net Change (39,850) (4,315) Ending Fund Balance 377,410 412,945 Fund 335 - WEST EVANSTON TIF FUND (39,850) Fund 335 - WEST EVANSTON TIF FUND REVENUE TOTALS 150 EXPENSE TOTALS 40,000 Miscellaneous - Interfund Transfers 30,000 EXPENSE TOTALS 40,000 Insurance and Other Chargebacks - Contingencies - Debt Service 10,000 REVENUE TOTALS 150 EXPENSE Services and Supplies - Capital Outlay - Property Taxes - Other Revenue - Interest Income 150 City of Evanston Financial Report Through 02/28/17 Prior Fiscal Year Activity Included Classification Budget 2017 Fund 335 - WEST EVANSTON TIF FUND REVENUE Run by Ashley King on 03/28/2017 12:33:20 PM Page 21 of 53 February 2017 YTD 2017 2016 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) EXPENSE TOTALS 40,000 Fund 340 - DEMPSTER-DODGE TIF FUND 10,000 EXPENSE TOTALS 40,000 Fund 340 - DEMPSTER-DODGE TIF FUND REVENUE TOTALS 50,000 EXPENSE Services and Supplies - Capital Outlay - Debt Service 40,000 Property Taxes - Other Revenue 50,000 REVENUE TOTALS 50,000 City of Evanston Financial Report Through 02/28/17 Prior Fiscal Year Activity Included Classification Budget 2017 Fund 340 - DEMPSTER-DODGE TIF FUND REVENUE Run by Ashley King on 03/28/2017 12:33:20 PM Page 22 of 53 February 2017 YTD 2017 2016 Actual - - - - - 1,580,000 - - 1,580,000 - - 437 - - 1,740,000 3,033 37,325 16,556 3,033 37,325 1,756,993 - - 1,580,000 3,033 37,325 1,756,993 (3,033) (37,325) (176,993) Starting Fund Balance 135,077 135,077 Net Change (60,000) (37,325) Ending Fund Balance 75,077 97,752 EXPENSE TOTALS 60,000 Fund 345 - CHICAGO-MAIN TIF Totals (60,000) EXPENSE TOTALS 60,000 Fund 345 - CHICAGO-MAIN TIF Totals REVENUE TOTALS - EXPENSE Services and Supplies - Capital Outlay - Debt Service 60,000 Property Taxes - Other Revenue - REVENUE TOTALS - City of Evanston Financial Report Through 02/28/17 Prior Fiscal Year Activity Included Classification Budget 2017 Fund 345 - CHICAGO-MAIN TIF REVENUE Run by Ashley King on 03/28/2017 12:33:20 PM Page 23 of 53 February 2017 YTD 2017 2016 Actual 21,532 22,034 223,296 0 0 2 21,533 22,034 223,298 - - 145,003 - - - - - 145,003 21,533 22,034 223,298 - - 145,003 21,533 22,034 78,294 Starting Fund Balance 78,294 78,294 Net Change 500 22,034 Ending Fund Balance 78,794 100,328 Fund 350 - SPECIAL SERVICE AREA (SSA) 500 Fund 350 - SPECIAL SERVICE AREA (SSA) REVENUE TOTALS 220,500 EXPENSE TOTALS 220,000 EXPENSE Services and Supplies 220,000 Interfund Transfers - EXPENSE TOTALS 220,000 Property Taxes 220,000 Interest Income 500 REVENUE TOTALS 220,500 City of Evanston Financial Report Through 02/28/17 Prior Fiscal Year Activity Included Classification Budget 2017 Fund 350 - SPECIAL SERVICE AREA (SSA) #6 REVENUE Run by Ashley King on 03/28/2017 12:33:20 PM Page 24 of 53 February 2017 YTD 2017 2016 Actual - - 96,586 41,667 83,333 4,864,054 - - 1,527,914 - - 9,591,988 2,645 5,260 16,690 44,312 88,593 16,097,233 - - - 19,989 19,989 1,320,475 97,186 97,186 8,510,648 - - - - - - 41,667 83,333 490,000 158,842 200,508 10,321,124 44,312 88,593 16,097,233 158,842 200,508 10,321,124 (114,530) (111,915) 5,776,109 Starting Fund Balance 11,626,458 11,626,458 Net Change (8,583,512) (111,915) Ending Fund Balance 3,042,946 11,514,543 EXPENSE TOTALS 30,508,512 Fund 415 - CAPITAL IMPROVEMENTS (8,583,512) EXPENSE TOTALS 30,508,512 Fund 415 - CAPITAL IMPROVEMENTS REVENUE TOTALS 21,925,000 Debt Service - Miscellaneous - Interfund Transfers 500,000 EXPENSE Salary and Benefits - Services and Supplies - Capital Outlay 30,008,512 Other Revenue 12,295,000 Interest Income - REVENUE TOTALS 21,925,000 Charges for Services - Interfund Transfers 7,710,000 Intergovernmental Revenue 1,920,000 City of Evanston Financial Report Through 02/28/17 Prior Fiscal Year Activity Included Classification Budget 2017 Fund 415 - CAPITAL IMPROVEMENTS FUND REVENUE Run by Ashley King on 03/28/2017 12:33:20 PM Page 25 of 53 February 2017 YTD 2017 2016 Actual - - - - - - - - - - - - - - - - - - - - - - - 513,349 - - - - - - - - - 1,391 14,530 29,661 65,239 136,434 142,874 - - - 66,630 150,963 685,884 - - - - - 8,751 - - - - - - - - - - - - 21,952 43,905 360,698 21,952 43,905 369,449 66,630 150,963 685,884 21,952 43,905 369,449 44,678 107,059 316,435 Starting Fund Balance 299,216 299,216 Net Change (32,227) 107,059 Ending Fund Balance 266,989 406,275 REVENUE TOTALS 481,200 EXPENSE TOTALS 513,427 Fund 420 - SPECIAL ASSESSMENT FUND (32,227) Interfund Transfers 513,427 EXPENSE TOTALS 513,427 Fund 420 - SPECIAL ASSESSMENT FUND Insurance and Other Chargebacks - Debt Service - Miscellaneous - EXPENSE Salary and Benefits - Services and Supplies - Capital Outlay - Special Assessment 180,167 Reappropriation of Surplus - REVENUE TOTALS 481,200 Insurance - Library Revenue - Interest Income 51,033 Intergovernmental Revenue - Other Revenue 250,000 Workers Compensation and Liability - Fines and Forfeitures - Charges for Services - Interfund Transfers - Property Taxes - Other Taxes - Licenses, Permits and Fees - City of Evanston Financial Report Through 02/28/17 Prior Fiscal Year Activity Included Classification Budget 2017 Fund 420 - SPECIAL ASSESSMENT FUND REVENUE Run by Ashley King on 03/28/2017 12:33:20 PM Page 26 of 53 February 2017 YTD 2017 2016 Actual - - - - - - - 600 3,350 - - - 646,722 1,056,972 6,523,524 - - 3,711,768 - - - 8,508 22,567 195,895 2,772 5,336 38,159 658,002 1,085,475 10,472,695 85,116 154,897 1,338,122 385,649 417,324 3,084,543 - - 2,867,258 43,956 84,204 504,784 - - - - - - 221 221 5,910 - - 390,235 - - 238,064 106,224 212,447 1,303,783 621,166 869,094 9,732,700 658,002 1,085,475 10,472,695 621,166 869,094 9,732,700 36,836 216,382 739,995 Starting Fund Balance 11,486,869 11,486,869 Net Change (3,350,830) 216,382 Ending Fund Balance 8,136,039 11,703,251 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 Miscellaneous 304,000 Interfund Transfers 1,584,683 EXPENSE TOTALS 14,524,752 Depreciation Expense - Contingencies 11,000 Debt Service 4,331,771 Capital Outlay 3,020,000 Insurance and Other Chargebacks 524,102 Community Sponsored Organizations - REVENUE TOTALS 11,173,922 EXPENSE Salary and Benefits 1,247,921 Services and Supplies 3,501,275 Intergovernmental Revenue 12,125 Other Revenue 203,216 Interest Income 35,070 Fines and Forfeitures - Charges for Services 6,802,875 Interfund Transfers 4,120,636 Property Taxes - Other Taxes - Licenses, Permits and Fees - City of Evanston Financial Report Through 02/28/17 Prior Fiscal Year Activity Included Classification Budget 2017 Fund 505 - PARKING SYSTEM FUND REVENUE Run by Ashley King on 03/28/2017 12:33:20 PM Page 27 of 53 February 2017 YTD 2017 2016 Actual - - - 4,554 9,743 90,592 1,969,438 3,629,421 16,058,497 - - - - - 8,654,978 2,919 6,204 306,143 2,001 3,785 16,116 1,978,912 3,649,153 25,126,327 335,408 626,924 4,494,885 204,021 232,038 3,022,866 - (689) 7,374,864 97,192 179,832 1,110,835 - - - - - - - - 1,000 - - 633,708 - - 10,543 298,526 597,052 12,156,871 28,805,572 1,978,912 3,649,153 25,126,327 28,805,572 1,043,766 2,013,996 (3,679,246) Starting Fund Balance 5,291,422 5,291,422 Net Change (4,966,509) 2,013,996 Ending Fund Balance 324,913 7,305,418 EXPENSE TOTALS 29,361,509 Fund 510 - WATER FUND Totals (4,966,509) 935,146 1,635,157 935,146 1,635,157 EXPENSE TOTALS 29,361,509 Fund 510 - WATER FUND Totals REVENUE TOTALS 24,395,000 Debt Service 1,438,470 Miscellaneous 62,982 Interfund Transfers 3,502,313 Community Sponsored Organizations - Depreciation Expense - Contingencies 1,000 Services and Supplies 3,611,150 Capital Outlay 14,982,119 Insurance and Other Chargebacks 1,174,064 Interest Income 1,600 REVENUE TOTALS 24,395,000 EXPENSE Salary and Benefits 4,589,411 Interfund Transfers - Intergovernmental Revenue - Other Revenue 6,828,400 Other Taxes - Licenses, Permits and Fees 70,000 Charges for Services 17,495,000 City of Evanston Financial Report Through 02/28/17 Prior Fiscal Year Activity Included Classification Budget 2017 Fund 510 - WATER FUND REVENUE Run by Ashley King on 03/28/2017 12:33:20 PM Page 28 of 53 February 2017 YTD 2017 2016 Actual 1,064,097 2,272,928 13,048,760 - - - - - 3,087 422 790 4,450 1,064,520 2,273,718 13,056,297 74,831 137,670 985,218 2,019 2,261 583,385 - - 790,772 36,918 70,288 414,270 - - - - - - 426,184 606,637 1,336,366 - - 5,000 82,640 165,279 773,873 622,592 982,135 4,888,884 1,064,520 2,273,718 13,056,297 622,592 982,135 4,888,884 441,927 1,291,582 8,167,412 Starting Fund Balance 5,693,921 5,693,921 Net Change (1,480,742) 1,291,582 Ending Fund Balance 4,213,179 6,985,503 Fund 515 - SEWER FUND Totals (1,480,742) Fund 515 - SEWER FUND Totals REVENUE TOTALS 13,126,315 EXPENSE TOTALS 14,607,057 Miscellaneous 1,500 Interfund Transfers 991,677 EXPENSE TOTALS 14,607,057 Depreciation Expense - Contingencies - Debt Service 8,370,946 Services and Supplies 1,000,800 Capital Outlay 2,819,700 Insurance and Other Chargebacks 432,953 Interest Income 1,000 REVENUE TOTALS 13,126,315 EXPENSE Salary and Benefits 989,481 Charges for Services 12,521,150 Interfund Transfers - Other Revenue 604,165 City of Evanston Financial Report Through 02/28/17 Prior Fiscal Year Activity Included Classification Budget 2017 Fund 515 - SEWER FUND REVENUE Run by Ashley King on 03/28/2017 12:33:20 PM Page 30 of 53 February 2017 YTD 2017 2016 Actual - 44,740 125,404 301,317 591,677 3,586,453 87,997 175,995 1,055,967 - - - 715 1,165 274,808 - - - 390,029 813,576 5,042,632 48,171 83,820 726,698 601,876 603,921 3,357,198 199 199 6,034 10,147 17,645 138,618 - - - - - - - - - - - 2,251 - - 12,232 42,067 84,135 499,493 702,461 789,720 4,742,523 390,029 813,576 5,042,632 702,461 789,720 4,742,523 (312,432) 23,856 300,109 Starting Fund Balance (926,498) (926,498) Net Change 3,016 23,856 Ending Fund Balance (923,482) (902,642) Fund 520 - SOLID WASTE FUND Totals 3,016 Fund 520 - SOLID WASTE FUND Totals REVENUE TOTALS 5,201,361 EXPENSE TOTALS 5,198,345 Miscellaneous 15,000 Interfund Transfers 504,807 EXPENSE TOTALS 5,198,345 Depreciation Expense - Contingencies - Debt Service 21,046 Capital Outlay 25,750 Insurance and Other Chargebacks 149,325 Community Sponsored Organizations - REVENUE TOTALS 5,201,361 EXPENSE Salary and Benefits 750,241 Services and Supplies 3,732,176 Intergovernmental Revenue - Other Revenue 238,000 Interest Income - Licenses, Permits and Fees 275,000 Charges for Services 3,632,394 Interfund Transfers 1,055,967 City of Evanston Financial Report Through 02/28/17 Prior Fiscal Year Activity Included Classification Budget 2017 Fund 520 - SOLID WASTE FUND REVENUE Run by Ashley King on 03/28/2017 12:33:20 PM Page 31 of 53 February 2017 YTD 2017 2016 Actual 283,620 567,239 3,387,680 - - - - - - 510 3,452 14,415 - - - 284,129 570,691 3,402,094 74,474 125,670 888,262 209,235 227,740 1,912,423 - - - 15,831 27,344 167,952 - - - - - - - - - - - - 2,319 4,639 26,762 301,859 385,393 2,995,399 284,129 570,691 3,402,094 301,859 385,393 2,995,399 (17,729) 185,297 406,695 Starting Fund Balance 773,239 773,239 Net Change (248,021) 185,297 Ending Fund Balance 525,218 958,536 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 3,471,216 Debt Service - Miscellaneous - Interfund Transfers 27,833 Insurance and Other Chargebacks 239,630 Depreciation Expense - Contingencies 450 EXPENSE Salary and Benefits 1,071,267 Services and Supplies 2,380,057 Capital Outlay - Other Revenue 81,781 Interest Income 1,000 REVENUE TOTALS 3,471,216 Charges for Services 3,388,435 Interfund Transfers - Intergovernmental Revenue - City of Evanston Financial Report Through 02/28/17 Prior Fiscal Year Activity Included Classification Budget 2017 Fund 600 - FLEET SERVICES FUND REVENUE Run by Ashley King on 03/28/2017 12:33:20 PM Page 32 of 53 February 2017 YTD 2017 2016 Actual 129,171 258,343 1,455,172 - - - 38,693 38,693 45,869 167,864 297,036 1,501,041 - - 102,765 15,524 15,524 - - - - - - - 15,524 15,524 102,765 167,864 297,036 1,501,041 15,524 15,524 102,765 152,341 281,512 1,398,276 Starting Fund Balance 1,283,721 1,283,721 Net Change 229,853 281,512 Ending Fund Balance 1,513,574 1,565,233 Fund 601 - EQUIPMENT REPLACEMENT 229,853 Fund 601 - EQUIPMENT REPLACEMENT REVENUE TOTALS 1,760,275 EXPENSE TOTALS 1,530,422 Depreciation Expense - Miscellaneous - EXPENSE TOTALS 1,530,422 REVENUE TOTALS 1,760,275 EXPENSE Services and Supplies 75,000 Capital Outlay 1,455,422 Charges for Services 1,550,058 Interfund Transfers - Other Revenue 210,217 City of Evanston Financial Report Through 02/28/17 Prior Fiscal Year Activity Included Classification Budget 2017 Fund 601 - EQUIPMENT REPLACEMENT FUND REVENUE Run by Ashley King on 03/28/2017 12:33:20 PM Page 33 of 53 February 2017 YTD 2017 2016 Actual 13,534 27,069 441,246 68 137 69,552 903,434 1,573,094 9,994,682 79,397 165,534 89,822 460,692 850,595 6,546,063 24 39 218 1,457,150 2,616,468 17,141,583 46,145 84,024 448,109 33,350 64,692 4,073,131 - - - 1,297,035 2,763,535 14,539,279 - - - - - - - - - - - - - - 4,330 803 1,605 9,262 1,377,332 2,913,856 19,074,111 1,457,150 2,616,468 17,141,583 1,377,332 2,913,856 19,074,111 79,818 (297,388) (1,932,528) Starting Fund Balance (639,105) (639,105) Net Change (224,815) (297,388) Ending Fund Balance (863,920) (936,493) Fund 605 - INSURANCE FUND Totals (224,815) Fund 605 - INSURANCE FUND Totals REVENUE TOTALS 18,850,796 EXPENSE TOTALS 19,075,611 Miscellaneous - Interfund Transfers 9,632 EXPENSE TOTALS 19,075,611 Depreciation Expense - Contingencies - Debt Service - Capital Outlay - Insurance and Other Chargebacks 16,146,290 Community Sponsored Organizations - REVENUE TOTALS 18,850,796 EXPENSE Salary and Benefits 534,441 Services and Supplies 2,385,248 Workers Compensation and Liability 1,030,815 Insurance 6,413,937 Interest Income 1,000 Charges for Services 162,411 Interfund Transfers 4,987 Other Revenue 11,237,646 City of Evanston Financial Report Through 02/28/17 Prior Fiscal Year Activity Included Classification Budget 2017 Fund 605 - INSURANCE FUND REVENUE Run by Ashley King on 03/28/2017 12:33:20 PM Page 34 of 53 February 2017 YTD 2017 2016 Actual - - - - - - - - - 1,076,720 1,149,442 10,902,978 10 10 1,559,737 1,076,729 1,149,451 12,462,715 717,010 1,434,019 8,429,695 - - - - - - - - - - - 174,111 717,010 1,434,019 8,603,806 1,076,729 1,149,451 12,462,715 717,010 1,434,019 8,603,806 359,720 (284,568) 3,858,910 Starting Fund Balance 70,630,343 70,630,343 Net Change 4,636,709 (284,568) Ending Fund Balance 75,267,052 70,345,775 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 Debt Service - Miscellaneous - EXPENSE TOTALS 8,705,000 EXPENSE Salary and Benefits 8,705,000 Services and Supplies - Community Sponsored Organizations - Other Revenue 1,050,000 Interest Income 4,100,000 REVENUE TOTALS 13,341,709 Property Taxes 7,868,709 Other Taxes 280,000 Interfund Transfers 43,000 City of Evanston Financial Report Through 02/28/17 Prior Fiscal Year Activity Included Classification Budget 2017 Fund 700 - FIRE PENSION FUND REVENUE Run by Ashley King on 03/28/2017 12:33:20 PM Page 35 of 53 February 2017 YTD 2017 2016 Actual - - - - - - - - - 1,416,738 1,526,356 16,286,867 12 12 2,713,348 1,416,750 1,526,368 19,000,215 934,821 1,865,413 11,094,711 - - - - - - - - 272,795 934,821 1,865,413 11,367,506 1,416,750 1,526,368 19,000,215 934,821 1,865,413 11,367,506 481,928 (339,045) 7,632,708 Starting Fund Balance 106,204,773 106,204,773 Net Change 6,627,200 (339,045) Ending Fund Balance 112,831,973 105,865,728 REVENUE TOTALS 18,444,200 EXPENSE TOTALS 11,817,000 Fund 705 - POLICE PENSION FUND Totals 6,627,200 Miscellaneous - EXPENSE TOTALS 11,817,000 Fund 705 - POLICE PENSION FUND Totals EXPENSE Salary and Benefits 11,817,000 Services and Supplies - Debt Service - Other Revenue 1,650,000 Interest Income 6,500,000 REVENUE TOTALS 18,444,200 Property Taxes 9,912,200 Other Taxes 325,000 Interfund Transfers 57,000 City of Evanston Financial Report Through 02/28/17 Prior Fiscal Year Activity Included Classification Budget 2017 Fund 705 - POLICE PENSION FUND REVENUE Run by Ashley King on 03/28/2017 12:33:20 PM Page 36 of 53