Loading...
HomeMy WebLinkAbout2016.11 November Monthly Report To: Wally Bobkiewicz, City Manager Martin Lyons, Assistant City Manager/Chief Financial Officer From: Ashley King, Finance Division Manager Subject: November 2016 Monthly Financial Report Date: December 29, 2016 Please find attached the unaudited financial statements as of November 30, 2016. A summary by fund for revenues, expenditures, fund and cash balances is as follows: YTD Revenues YTD Expenses YTD Net Fund Balance Cash Balance 101,039,141 98,048,007 2,991,135 13,695,971 6,849,781 811,061 657,381 153,680 153,680 189,086 872,992 718,712 154,279 667,518 669,261 1,000,000 916,667 83,333 83,333 1,083,333 6,742,940 5,885,071 857,869 1,011,740 1,527,451 61,621 79,877 (18,256)(18,256)143,958 1,725,317 2,163,117 (437,800)1,392,593 1,250,231 810,804 1,234,170 (423,366)128,352 (46,363) 321,268 242,250 79,018 (111,526)(111,526) 928,465 1,111,146 (182,681)(122,799)(122,798) 183,476 139,267 44,209 202,574 256,098 2,503,562 1,999,282 504,280 3,060,262 2,725,575 0 0 0 169,915 169,915 245,387 269,793 (24,406)(19,636)(19,636) 297,275 162,310 134,965 1,128,845 1,092,125 1,040,978 748,913 292,065 328,729 178,276 4,732,351 3,804,256 928,095 7,370,525 7,449,444 287,860 428,186 (140,326)385,103 385,103 1,235,733 1,293,965 (58,233)1,222,882 1,283,954 809,741 672,550 137,191 108,570 110,839 11,794 34,732 (22,937)419,326 427,648 580,000 1,175,103 (595,103)(283,033)(283,033) 21,124,873 23,244,866 (2,119,994)476,122 490,918 0 222,788 222,788 13,871,045 7,088,663 6,782,381 12,299,422 13,024,279 661,679 338,982 322,697 3,005,478 3,001,941 9,451,378 11,929,114 (2,477,736)8,300,138 7,845,655 30,211,147 27,848,841 2,362,306 18,680,865 7,065,369 12,785,965 11,379,908 1,406,057 5,418,865 3,234,818 4,631,775 4,438,417 193,358 (1,035,199)(1,660,213) 3,117,940 2,636,850 481,090 846,550 172,428 1,368,679 865,827 502,852 1,780,541 1,385,470 14,986,533 15,786,610 (800,077)(1,164,573)1,621,377 238,452,779 227,342,833 11,109,946 79,805,666 61,613,552 600 FLEET SERVICES FUND 601 EQUIPMENT REPLACEMENT FUND 605 INSURANCE FUND 510 WATER FUND 515 SEWER FUND 520 SOLID WASTE FUND 415 CAPITAL IMPROVEMENTS FUND 420 SPECIAL ASSESSMENT FUND 505 PARKING SYSTEM FUND 345 CHICAGO-MAIN TIF 320 DEBT SERVICE FUND 350 SSA #6 330 HOWARD-RIDGE TIF FUND 335 WEST EVANSTON TIF FUND 300 WASHINGTON NATIONAL TIF FUND 305 SPECIAL SERVICE AREA (SSA) #5 310 HOWARD-HARTREY TIF 240 HOME FUND 250 AFFORDABLE HOUSING FUND 186 LIBRARY DEBT SERVICE FUND 220 CDBG LOAN 225 ECONOMIC DEVELOPMENT FUND 235 NEIGHBORHOOD IMPROVEMENT 205 EMERGENCY TELEPHONE (E911) FUND 210 SPECIAL SERVICE AREA (SSA) #4 215 CDBG FUND 185 LIBRARY FUND 195 NEIGHBORHOOD STABILIZATION FUND 200 MOTOR FUEL TAX FUND 176 HEALTH AND HUMAN SERVICES 175 GENERAL ASSISTANCE FUND 180 GOOD NEIGHBOR FUND Fund Fund Description 100 GENERAL FUND NOTE: Negative Cash Balances (as seen above in the E911, SSA4, CDBG, HOME, Chicago-Main TIF, and Solid Waste Fund) reflect internal account balances and not external bank balances, due to transaction timing at month end. Also note that monthly fund balance is calculated as ending 2015 audited fund balance + YTD Net without other balance sheet adjustments. Memorandum Included above are the ending balances as of November 30, 2016 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 November 30, 2016, the General Fund is reporting a net surplus of $2,991,135. The attached supplemental charts show the General Fund Revenues at 90.1% of budget and expenses lower at 87.7%. The November target is 91.67%. General Fund revenues include the $2.9 million permit from Northwestern as well as pension property taxes. General Fund Expenses include the pension payments being paid as of October. The net surplus is anticipated to be mitigated by the 3 ½ payrolls in December. Through November 30, 2016, the SSA #4 Fund is showing a negative cash balance of $111,526 due to the timing of payments to the Downtown Evanston group. Through November 30, 2016, the Economic Development Fund is showing a fund balance of $3,060,262 and a cash balance of $2,725,575. Through November 30, 2016, the Chicago -Main TIF Fund is showing a negative fund and cash balance. This will be remedied with a draw from the Letter of Credit through First Bank & Trust that occurred in early December. Special Service Area #5 received 2016 property taxes in error for the first installment. This is due to the first property tax installment always being 55% of the previous year’s tax amount. This money was refunded to the County in December. Through November 30, 2016, the enterprise funds (Parking, Water, and Sewer) have balances above average. Through November 30, 2016, the Solid Waste Fund has a negative fund balance of $1,035,199 and a negative cash balance of $1,660,213. Through November 30, 2016, the Insurance Fund is showing a negative fund balance of $1,164,573 with a cash balance of $1,621,377. 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 2016 November YTD % of 2015 Budget Actual Actual Budget Actual 27,417,407 125,199 27,146,231 99.0% 25,915,970 45,986,550 5,623,145 39,500,390 85.9% 44,978,985 5,329,777 632,912 3,189,335 59.8% 5,324,137 9,276,550 370,418 10,689,959 115.2% 6,704,846 125,700 882 48,079 38.2% 155,619 4,609,825 286,316 3,134,215 68.0% 3,548,230 640,000 53,334 593,362 92.7% 640,000 5,374,751 291,637 5,366,917 99.9% 5,406,379 2,433,216 298,523 2,402,514 98.7% 2,239,528 8,842,365 646,242 7,309,945 82.7% 7,774,256 765,727 71,339 618,478 80.8% 670,245 1,286,843 274,286 1,013,182 78.7% 956,932 50,000 4,234 26,535 53.1% 6,572 112,138,711 8,678,465 101,039,141 90.1% 104,321,698 CITY COUNCIL 424,958 35,668 375,623 88.4% 419,962 CITY CLERK 263,203 21,391 256,825 97.6% 283,764 CITY MANAGER'S OFFICE 6,989,746 394,532 5,322,735 76.2% 1,814,469 LAW 1,130,000 84,546 915,719 81.0% 1,051,325 ADMINISTRATIVE SERVICES 9,634,173 825,666 7,856,707 81.6% 9,763,951 COMMUNITY DEVELOPMENT 2,782,897 191,615 2,177,564 78.2% 2,425,618 POLICE 37,696,278 2,437,896 34,124,512 90.5% 37,239,961 FIRE MGMT & SUPPORT 22,601,742 1,215,521 21,146,417 93.6% 21,331,507 HEALTH 3,610,779 242,963 2,746,554 76.1% 3,212,848 PARKS, REC. AND COMMUNITY SERV. 11,845,590 796,494 10,484,005 88.5% 11,180,116 PUBLIC WORKS AGENCY 14,861,248 1,469,018 12,640,802 85.1% 18,148,755 111,840,614 7,715,310 98,047,461 87.7% 106,872,275 112,138,711 8,678,465 101,039,141 90% 104,321,698 111,840,614 7,715,310 98,048,007 88% 106,872,275 298,097 963,155 2,991,135 1,003% (2,550,577) EXPENSE TOTALS Fund   100 - GENERAL FUND Net Gain Interest Income REVENUE TOTAL EXPENSE TOTAL Fund   100 - GENERAL FUND Totals REVENUE TOTALS 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 November Financial Report Through 11/30/16 Summary Listing Fund   505 - PARKING SYSTEM FUND 2016 November YTD % of 2015 Budget Actual Actual Budget Actual 0 50 3,200 150 6,379,675 473,527 5,695,893 89.3% 6,010,558 65,000 0 168,500 259.2% - 3,711,770 309,314 3,402,454 91.7% 2,925,296 12,125 0 0 0.0% - 119,216 1,521 153,040 128.4% 153,545 35,070 3,273 28,291 80.7% 18,260 10,322,856 787,685 9,451,378 91.6% 9,107,809 23,000 4,432 22,268 96.8% 29,187 1,160,688 181,917 1,047,071 90.2% 966,953 113,349 8,185 90,944 80.2% (33,034) 3,022,411 194,844 2,598,656 86.0% 2,616,554 278,864 23,488 216,302 77.6% 243,068 3,474,000 733,228 2,151,124 61.9% 128,726 188,252 17,001 164,667 87.5% 158,538 2,873,395 0 0 0.0% 2,846,227 11,000 388 4,790 43.5% 6,951 3,917,652 3,707,103 3,907,082 99.7% 503,423 252,000 24,049 238,064 94.5% 23,687 1,623,431 135,286 1,488,146 91.7% 1,242,741 16,938,042 5,029,921 11,929,114 70.4% 8,733,020 10,322,856 787,685 9,451,378 92% 9,107,809 16,938,042 5,029,921 11,929,114 70% 8,733,020 (6,615,186) (4,242,236) (2,477,736)37% 374,789 EXPENSE TOTALS Fund   505 - PARKING SYSTEM FUND Miscellaneous Interfund Transfers EXPENSE TOTAL Fund   505 - PARKING SYSTEM FUND REVENUE TOTALS Supplies Capital Outlay Insurance and Other Chargebacks Depreciation Expense Contingencies Debt Service Interest Income REVENUE TOTAL Employee Pay Benefits Pensions Services Permit Parking Charges for Services Parks and Recreation Charges for Services Interfund Transfers Intergovernmental Revenue Other Revenue November Financial Report Through 11/30/16 Summary Listing Fund   510 - WATER FUND 2016 November YTD % of 2015 Budget Actual Actual Budget Actual 70,000 5,230 86,585 123.7% 105,483 15,133,000 1,361,339 17,261,996 114.1% 15,141,770 39,000 9,475 47,627 122.1% 40,911 126,000 - 134,470 106.7% 125,545 - - 8,447,244 2,354,582 22,348,400 265,193 4,218,625 18.9% 350,065 1,600 1,756 14,717 919.8% 3,448 37,718,000 1,642,993 30,211,263 80.1% 18,121,804 210,465 14,768 162,649 77.3% 157,679 3,888,603 298,517 3,397,857 87.4% 3,884,943 360,355 30,093 339,884 94.3% (114,870) 4,763,760 104,985 1,658,516 34.8% 1,250,874 1,392,190 152,429 809,709 58.2% 1,048,119 24,776,106 129,526 7,304,615 29.5% 105 645,703 52,184 576,278 89.2% 663,015 - - - 2,096,633 1,000 - 658 65.8% 933 1,053,288 1,093,704 1,500,974 142.5% 432,628 62,980 - 10,543 16.7% (286,678) 3,970,805 330,901 12,087,159 304.4% 4,161,059 41,125,255 2,207,108 27,848,841 67.7% 13,294,439 37,718,000 1,642,993 30,211,263 18,121,804 41,125,255 2,207,108 27,848,841 13,294,439 (3,407,255) (564,115) 2,362,422 4,827,365 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 Interfund Transfers Other Revenue November Financial Report Through 11/30/16 Summary Listing Fund   515 - SEWER FUND 2016 November YTD % of 2015 Budget Actual Actual Budget Actual 12,869,000 817,762 12,204,034 94.8% 12,491,290 19,650 22 21,600 109.9% 19,650 984,165 - 554,863 56.4% 2,962 1,000 721 4,058 405.8% 2,706 13,873,815 818,504 12,784,555 92.1% 12,516,607 57,040 4,657 34,023 59.6% 60,837 881,327 63,497 750,677 85.2% 858,361 86,092 6,572 73,736 85.6% (27,099) 903,500 635 253,894 28.1% 90,109 92,300 2,437 33,480 36.3% 18,817 3,048,314 - 723,144 23.7% 13,609 144,451 12,598 128,111 88.7% 142,473 - - - 3,443,723 9,222,913 1,476,884 8,420,970 91.3% 1,550,407 1,500 - 5,000 333.3% 3,306 1,043,864 86,988 956,873 91.7% 1,005,223 15,481,301 1,654,268 11,379,908 73.5% 7,159,766 13,873,815 818,504 12,784,555 92% 12,516,607 15,481,301 1,654,268 11,379,908 74% 7,159,766 (1,607,486) (835,764) 1,404,647 (87%) 5,356,842 Fund   515 - SEWER FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund   515 - SEWER FUND Net Gain (Loss) Depreciation Expense Debt Service Miscellaneous Interfund Transfers EXPENSE TOTAL Benefits Pensions Services Supplies Capital Outlay Insurance and Other Chargebacks Sewer Charges for Services Other Charges for Services Other Revenue Interest Income REVENUE TOTAL Employee Pay November Financial Report Through 11/30/16 Summary Listing Fund   520 - SOLID WASTE FUND 2016 November YTD % of 2015 Budget Actual Actual Budget Actual 275,000 - 125,404 45.6% 213,490 3,632,394 285,023 3,264,181 89.9% 3,561,584 1,055,967 87,997 967,970 91.7% 1,055,967 238,000 181,918 273,667 115.0% 228,469 5,201,361 554,938 4,631,222 89.0% 5,059,510 25,000 2,346 35,463 141.9% 41,358 649,690 44,937 545,843 84.0% 574,692 63,718 4,540 55,508 87.1% (15,981) 3,679,126 439,572 3,128,641 85.0% 3,644,097 53,050 2,788 52,228 98.5% 73,788 25,750 2,650 5,314 20.6% 24,738 129,690 11,805 125,087 96.5% 249,232 - 19,089 20,233 68,419 15,000 - 12,232 81.5% - 499,493 41,624 457,869 91.7% 490,106 5,140,517 569,352 4,438,417 86.3% 5,150,448 5,201,361 554,938 4,631,222 89% 5,059,510 5,140,517 569,352 4,438,417 86% 5,150,448 60,844 (14,413) 192,805 317% (90,938) REVENUE TOTALS EXPENSE TOTALS Fund   520 - SOLID WASTE FUND Net Debt Service Miscellaneous Interfund Transfers EXPENSE TOTAL Fund   520 - SOLID WASTE FUND Totals Benefits Pensions Services Supplies Capital Outlay Insurance and Other Chargebacks License Other Charges for Services Interfund Transfers Other Revenue REVENUE TOTAL Employee Pay November Financial Report Through 11/30/16 Summary Listing Jan Feb Mar Apr May Jun Jul Aug Sept October November 2015 Unreserved Fund Balance 17,350,271 17,704,926 21,823,492 21,070,998 20,159,923 19,573,881 13,460,405 13,534,424 16,970,318 15,290,720 15,494,566 2016 Unreserved Fund Balance 11,859,782 14,097,256 17,193,730 16,597,583 18,375,173 21,225,995 15,790,000 17,674,579 15,983,833 12,732,816 13,695,971 2015 Cash Balance 5,232,590 6,567,371 10,786,783 8,666,475 8,237,917 7,501,885 6,692,927 9,614,255 5,925,461 6,629,607 5,932,660 2016 Cash Balance 3,656,830 2,587,845 8,182,090 7,808,208 7,101,333 12,919,440 10,046,315 10,473,240 9,442,294 7,391,338 6,849,781 2015 v 2016 Fund and Cash Balance-- General Fund - 5,000,000 10,000,000 15,000,000 20,000,000 25,000,000 2015 Unreserved Fund Balance 2016 Unreserved Fund Balance 2015 Cash Balance 2016 Cash Balance November YTD 2015 2016 2016 Actual 125,199 27,146,231 25,915,970 5,623,145 39,500,390 44,978,985 1,004,211 13,927,373 12,184,602 286,316 3,134,215 3,548,230 643,493 8,362,792 8,285,907 646,242 7,309,945 7,774,256 71,339 618,478 670,245 274,286 1,013,182 956,932 - - - - - - - - - 4,234 26,535 6,572 - - - - - - 8,678,465 101,039,141 104,321,698 4,677,807 53,039,908 60,215,578 1,281,933 9,948,974 11,506,401 26,810 125,225 155,975 791,501 24,321,550 8,571,637 72,462 772,511 952,678 - - - 5 49,794 30,529 - - - 109,173 1,473,857 17,171,181 755,620 8,316,188 8,268,296 7,715,310 98,048,007 106,872,275 8,678,465 101,039,141 104,321,698 7,715,310 98,048,007 106,872,275 963,155 2,991,135 (2,550,577) Starting Fund Balance 10,704,836 10,704,836 Net Change (567,485) 2,991,135 Ending Fund Balance 10,137,351 13,695,971 REVENUE TOTALS 112,138,711 EXPENSE TOTALS 112,706,196 Fund 100 - GENERAL FUND Totals -567,485 Interfund Transfers 9,935,696 EXPENSE TOTALS 112,706,196 Fund 100 - GENERAL FUND Totals Contingencies 213,505 Debt Service 0 Miscellaneous 1,679,285 Insurance and Other Chargebacks 25,528,321 Community Sponsored Organizations 925,029 Depreciation Expense 0 EXPENSE Salary and Benefits 62,388,836 Services and Supplies 11,834,924 Capital Outlay 200,600 Special Assessment 0 Reappropriation of Surplus 0 REVENUE TOTALS 112,138,711 Insurance 0 Library Revenue 0 Interest Income 50,000 Intergovernmental Revenue 765,727 Other Revenue 1,286,843 Workers Compensation and Liability 0 Fines and Forfeitures 4,609,825 Charges for Services 8,447,967 Interfund Transfers 8,842,365 REVENUE Property Taxes 27,417,407 Other Taxes 45,986,550 Licenses, Permits and Fees 14,732,027 Budget by Organization Report Through 11/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 100 - GENERAL FUND Run by Ashley King on 12/28/2016 09:59:38 AM Page 1 of 46 November YTD 2015 2016 2016 Actual 4,947 822,705 1,313,420 - - - - - - - - - - - - - - - - 167 3,208 3,405 49,423 19,534 - - - - - - - - - 120 697 62 - - - - - - 8,471 872,992 1,336,224 18,974 209,821 166,822 41,930 482,621 592,645 - - - 2,825 21,805 18,609 - - - - - - - - - - - - - 4,466 4,625 - - - 63,729 718,712 782,701 8,471 872,992 1,336,224 63,729 718,712 782,701 (55,257) 154,279 553,522 Starting Fund Balance 513,239 513,239 Net Change 38,167 154,279 Ending Fund Balance 551,406 667,518 REVENUE TOTALS 1,026,000 EXPENSE TOTALS 987,833 Fund 175 - GENERAL ASSISTANCE FUND 38,167 Interfund Transfers 0 EXPENSE TOTALS 987,833 Fund 175 - GENERAL ASSISTANCE FUND Contingencies 0 Debt Service 0 Miscellaneous 7,000 Insurance and Other Chargebacks 21,229 Community Sponsored Organizations 0 Depreciation Expense 0 EXPENSE Salary and Benefits 200,704 Services and Supplies 758,900 Capital Outlay 0 Special Assessment 0 Reappropriation of Surplus 0 REVENUE TOTALS 1,026,000 Insurance 0 Library Revenue 0 Interest Income 1,000 Intergovernmental Revenue 0 Other Revenue 25,000 Workers Compensation and Liability 0 Fines and Forfeitures 0 Charges for Services 0 Interfund Transfers 0 REVENUE Property Taxes 1,000,000 Other Taxes 0 Licenses, Permits and Fees 0 Budget by Organization Report Through 11/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 175 - GENERAL ASSISTANCE FUND Run by Ashley King on 12/28/2016 09:59:38 AM Page 2 of 46 November YTD 2015 2016 2016 Actual - - - 73,733 811,061 884,794 - - - - - - 73,733 811,061 884,794 - - - - - - 13,617 657,381 849,388 - - - 13,617 657,381 849,388 73,733 811,061 884,794 13,617 657,381 849,388 60,116 153,680 35,406 Starting Fund Balance - - Net Change 25,641 153,680 Ending Fund Balance 25,641 153,680 EXPENSE TOTALS 859,153 Fund 176 - HEALTH AND HUMAN 25,641 EXPENSE TOTALS 859,153 Fund 176 - HEALTH AND HUMAN REVENUE TOTALS 884,794 Capital Outlay 0 Community Sponsored Organizations 859,153 Miscellaneous 0 Other Revenue 0 REVENUE TOTALS 884,794 EXPENSE Services and Supplies 0 REVENUE Charges for Services 0 Interfund Transfers 884,794 Intergovernmental Revenue 0 Budget by Organization Report Through 11/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 176 - HEALTH AND HUMAN SERVICES Run by Ashley King on 12/28/2016 09:59:38 AM Page 3 of 46 November YTD 2015 2016 2016 Actual - 1,000,000 - - 1,000,000 - 83,333 916,667 - 83,333 916,667 - - 1,000,000 - 83,333 916,667 - (83,333) 83,333 - Starting Fund Balance - - Net Change - 83,333 Ending Fund Balance - 83,333 REVENUE TOTALS 1,000,000 EXPENSE TOTALS 1,000,000 Fund 180 - GOOD NEIGHBOR FUND Totals 0 Interfund Transfers 1,000,000 EXPENSE TOTALS 1,000,000 Fund 180 - GOOD NEIGHBOR FUND Totals REVENUE Other Revenue 1,000,000 REVENUE TOTALS 1,000,000 EXPENSE Budget by Organization Report Through 11/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 180 - GOOD NEIGHBOR FUND Run by Ashley King on 12/28/2016 09:59:38 AM Page 4 of 46 November YTD 2015 2016 2016 Actual 35,333 6,101,845 5,916,852 - - 46,059 10,652 129,551 129,808 - 235,800 171,000 7,500 67,918 181,283 2,552 58,230 286 10,326 145,193 315,924 521 4,403 2,683 66,884 6,742,940 6,763,897 320,806 3,685,425 4,062,199 221,178 1,485,921 1,425,484 717 38,472 299,628 34,888 363,337 810,678 - - - - - - - - - 20,833 229,167 250,000 7,523 82,749 81,468 605,946 5,885,071 6,929,456 66,884 6,742,940 6,763,897 605,946 5,885,071 6,929,456 (539,061) 857,869 (165,560) Starting Fund Balance 153,871 153,871 Net Change 20,015 857,869 Ending Fund Balance 173,886 1,011,740 EXPENSE TOTALS 6,997,142 Fund 185 - LIBRARY FUND Totals 20,015 EXPENSE TOTALS 6,997,142 Fund 185 - LIBRARY FUND Totals REVENUE TOTALS 7,017,157 Debt Service 0 Miscellaneous 250,000 Interfund Transfers 90,272 Insurance and Other Chargebacks 462,317 Depreciation Expense 0 Contingencies 0 EXPENSE Salary and Benefits 4,289,180 Services and Supplies 1,872,573 Capital Outlay 32,800 Library Revenue 333,300 Interest Income 2,000 REVENUE TOTALS 7,017,157 Interfund Transfers 185,800 Intergovernmental Revenue 94,177 Other Revenue 87,500 REVENUE Property Taxes 6,104,180 Other Taxes 50,200 Fines and Forfeitures 160,000 Budget by Organization Report Through 11/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 185 - LIBRARY FUND Run by Ashley King on 12/28/2016 09:59:38 AM Page 5 of 46 November YTD 2015 2016 2016 Actual - 364,827 601,811 - 676,150 - - 1 - - 1,040,978 601,811 - 11,770 - - 41,447 - 664,468 695,696 562,740 - - - 664,468 748,913 562,740 - 1,040,978 601,811 664,468 748,913 562,740 (664,468) 292,065 39,072 Starting Fund Balance 36,664 36,664 Net Change - 292,065 Ending Fund Balance 36,664 328,729 Fund 186 - LIBRARY DEBT SERVICE 0 Fund 186 - LIBRARY DEBT SERVICE REVENUE TOTALS 393,409 EXPENSE TOTALS 393,409 Debt Service 393,409 Miscellaneous 0 EXPENSE TOTALS 393,409 REVENUE TOTALS 393,409 EXPENSE Services and Supplies 0 Capital Outlay 0 REVENUE Property Taxes 393,409 Other Revenue 0 Interest Income 0 Budget by Organization Report Through 11/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 186 - LIBRARY DEBT SERVICE FUND Run by Ashley King on 12/28/2016 09:59:38 AM Page 6 of 46 November YTD 2015 2016 2016 Actual - - - - 61,420 130,126 - - - 23 201 - 23 61,621 130,126 1,688 19,599 54,159 - 6,060 4,611 1,515 37,790 68,352 344 3,736 5,308 - - - - 1,705 179 362 10,987 (2,483) 3,909 79,877 130,126 23 61,621 130,126 3,909 79,877 130,126 (3,885) (18,256) - Starting Fund Balance - - Net Change (303) (18,256) Ending Fund Balance (303) (18,256) EXPENSE TOTALS 198,954 Fund 195 - NEIGHBORHOOD -303 EXPENSE TOTALS 198,954 Fund 195 - NEIGHBORHOOD REVENUE TOTALS 198,651 Debt Service 0 Miscellaneous 120,862 Interfund Transfers 4,344 Services and Supplies 5,100 Capital Outlay 35,000 Insurance and Other Chargebacks 5,058 Interest Income 0 REVENUE TOTALS 198,651 EXPENSE Salary and Benefits 28,590 REVENUE Licenses, Permits and Fees 0 Intergovernmental Revenue 198,651 Other Revenue 0 Budget by Organization Report Through 11/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 195 - NEIGHBORHOOD STABILIZATION FUND Run by Ashley King on 12/28/2016 09:59:38 AM Page 7 of 46 November YTD 2015 2016 2016 Actual 165,372 1,719,374 2,465,781 - - - 577 5,943 819 - - - 165,948 1,725,317 2,466,600 - - - - 156,533 1,583,238 - - - - - - - - - 182,417 2,006,583 833,000 182,417 2,163,117 2,416,238 165,948 1,725,317 2,466,600 182,417 2,163,117 2,416,238 (16,468) (437,800) 50,362 Starting Fund Balance 1,830,393 1,830,393 Net Change (478,000) (437,800) Ending Fund Balance 1,352,393 1,392,593 Fund 200 - MOTOR FUEL TAX FUND Totals -478,000 Fund 200 - MOTOR FUEL TAX FUND Totals REVENUE TOTALS 1,711,000 EXPENSE TOTALS 2,189,000 Miscellaneous 0 Interfund Transfers 2,189,000 EXPENSE TOTALS 2,189,000 Capital Outlay 0 Contingencies 0 Debt Service 0 Reappropriation of Surplus 0 REVENUE TOTALS 1,711,000 EXPENSE Services and Supplies 0 REVENUE Intergovernmental Revenue 1,710,000 Other Revenue 0 Interest Income 1,000 Budget by Organization Report Through 11/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 200 - MOTOR FUEL TAX FUND Run by Ashley King on 12/28/2016 09:59:38 AM Page 8 of 46 November YTD 2015 2016 2016 Actual 41,378 808,587 977,071 - - - - - 100 262 2,217 189 41,641 810,804 977,361 36,387 453,616 505,437 4,294 252,040 347,694 100,146 313,952 239,421 4,736 68,212 78,684 - - - - - 2,046 - - - - - 1,500 13,305 146,350 159,215 158,868 1,234,170 1,333,996 41,641 810,804 977,361 158,868 1,234,170 1,333,996 (117,227) (423,366) (356,635) Starting Fund Balance 551,718 551,718 Net Change (497,643) (423,366) Ending Fund Balance 54,075 128,352 Fund 205 - EMERGENCY TELEPHONE -497,643 Fund 205 - EMERGENCY TELEPHONE REVENUE TOTALS 1,019,000 EXPENSE TOTALS 1,516,643 Miscellaneous 0 Interfund Transfers 159,655 EXPENSE TOTALS 1,516,643 Community Sponsored Organizations 0 Contingencies 5,000 Debt Service 0 Services and Supplies 377,600 Capital Outlay 393,615 Insurance and Other Chargebacks 77,498 Interest Income 1,000 REVENUE TOTALS 1,019,000 EXPENSE Salary and Benefits 503,275 REVENUE Other Taxes 1,018,000 Intergovernmental Revenue 0 Other Revenue 0 Budget by Organization Report Through 11/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 205 - EMERGENCY TELEPHONE (E911) FUND Run by Ashley King on 12/28/2016 09:59:38 AM Page 9 of 46 November YTD 2015 2016 2016 Actual 46 321,266 322,055 - 2 3 46 321,268 322,058 - 242,250 323,000 - - - - - - - 242,250 323,000 46 321,268 322,058 - 242,250 323,000 46 79,018 (942) Starting Fund Balance (190,544) (190,544) Net Change - 79,018 Ending Fund Balance (190,544) (111,526) EXPENSE TOTALS 320,000 Fund 210 - SPECIAL SERVICE AREA (SSA) 0 EXPENSE TOTALS 320,000 Fund 210 - SPECIAL SERVICE AREA (SSA) REVENUE TOTALS 320,000 EXPENSE Services and Supplies 320,000 Debt Service 0 Miscellaneous 0 REVENUE Property Taxes 320,000 Interest Income 0 REVENUE TOTALS 320,000 Budget by Organization Report Through 11/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 210 - SPECIAL SERVICE AREA (SSA) #4 Run by Ashley King on 12/28/2016 09:59:38 AM Page 10 of 46 November YTD 2015 2016 2016 Actual - - - - - - 24,558 918,268 1,502,924 - 10,197 3,318 - - - 24,558 928,465 1,506,242 32,050 362,490 318,743 - 4,934 28,988 - 185,245 276,834 5,685 61,719 44,043 115,531 201,223 235,459 - - - - - - 22,571 106,919 72,442 - 188,616 469,850 175,837 1,111,146 1,446,359 24,558 928,465 1,506,242 175,837 1,111,146 1,446,359 (151,279) (182,681) 59,883 Starting Fund Balance 59,882 59,882 Net Change 375 (182,681) Ending Fund Balance 60,257 (122,799) EXPENSE TOTALS 2,594,625 Fund 215 - CDBG FUND Totals 375 EXPENSE TOTALS 2,594,625 Fund 215 - CDBG FUND Totals REVENUE TOTALS 2,595,000 Debt Service 0 Miscellaneous 1,274,280 Interfund Transfers 864,113 Insurance and Other Chargebacks 67,147 Community Sponsored Organizations 0 Contingencies 0 EXPENSE Salary and Benefits 385,285 Services and Supplies 3,800 Capital Outlay 0 Other Revenue 0 Interest Income 0 REVENUE TOTALS 2,595,000 REVENUE Charges for Services 0 Interfund Transfers 0 Intergovernmental Revenue 2,595,000 Budget by Organization Report Through 11/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 215 - CDBG FUND Run by Ashley King on 12/28/2016 09:59:38 AM Page 11 of 46 November YTD 2015 2016 2016 Actual - - - 3,127 178,845 397,708 34 4,631 375 3,161 183,476 398,083 - - - 58 81,387 280,461 - 57,880 1,919 - - - 58 139,267 282,380 3,161 183,476 398,083 58 139,267 282,380 3,103 44,209 115,703 Starting Fund Balance 158,365 158,365 Net Change - 44,209 Ending Fund Balance 158,365 202,574 Fund 220 - CDBG LOAN Totals 0 Fund 220 - CDBG LOAN Totals REVENUE TOTALS 350,000 EXPENSE TOTALS 350,000 Miscellaneous 10,000 Interfund Transfers 0 EXPENSE TOTALS 350,000 REVENUE TOTALS 350,000 EXPENSE Salary and Benefits 0 Services and Supplies 340,000 REVENUE Intergovernmental Revenue 0 Other Revenue 350,000 Interest Income 0 Budget by Organization Report Through 11/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 220 - CDBG LOAN Run by Ashley King on 12/28/2016 09:59:38 AM Page 12 of 46 November YTD 2015 2016 2016 Actual 48,921 2,211,023 2,116,843 3,958 43,542 - - - - - 240,391 49,000 159 8,606 128 53,038 2,503,562 2,165,971 40,072 468,534 537,286 50,346 357,939 302,867 - 215,521 194,941 4,718 53,315 63,493 - - - - - - - - - - 97,966 1,419,643 73,273 806,007 632,230 168,409 1,999,282 3,150,460 53,038 2,503,562 2,165,971 168,409 1,999,282 3,150,460 (115,371) 504,280 (984,489) Starting Fund Balance 2,555,982 2,555,982 Net Change (286,099) 504,280 Ending Fund Balance 2,269,883 3,060,262 EXPENSE TOTALS 2,548,699 Fund 225 - ECONOMIC DEVELOPMENT -286,099 EXPENSE TOTALS 2,548,699 Fund 225 - ECONOMIC DEVELOPMENT REVENUE TOTALS 2,262,600 Debt Service 0 Miscellaneous 16,000 Interfund Transfers 632,770 Insurance and Other Chargebacks 87,423 Community Sponsored Organizations 0 Contingencies 0 EXPENSE Salary and Benefits 646,806 Services and Supplies 912,200 Capital Outlay 253,500 Other Revenue 50,000 Interest Income 100 REVENUE TOTALS 2,262,600 REVENUE Other Taxes 2,165,000 Interfund Transfers 47,500 Intergovernmental Revenue 0 Budget by Organization Report Through 11/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 225 - ECONOMIC DEVELOPMENT FUND Run by Ashley King on 12/28/2016 09:59:38 AM Page 13 of 46 November YTD 2015 2016 2016 Actual - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Starting Fund Balance 169,915 169,915 Net Change (80,000) - Ending Fund Balance 89,915 169,915 Starting Fund Balance 513,239 513,239 Net Change - - Ending Fund Balance 513,239 513,239 EXPENSE TOTALS 100,000 Fund 235 - NEIGHBORHOOD -80,000 EXPENSE TOTALS 100,000 Fund 235 - NEIGHBORHOOD REVENUE TOTALS 20,000 Debt Service 0 Miscellaneous 100,000 Interfund Transfers 0 REVENUE TOTALS 20,000 EXPENSE Services and Supplies 0 Capital Outlay 0 REVENUE Other Taxes 20,000 Interfund Transfers 0 Interest Income 0 Budget by Organization Report Through 11/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 235 - NEIGHBORHOOD IMPROVEMENT Run by Ashley King on 12/28/2016 09:59:38 AM Page 14 of 46 November YTD 2015 2016 2016 Actual - 220,396 465,961 2,282 24,977 6,402 0 14 19 2,282 245,387 472,382 3,007 27,772 12,388 12,888 238,384 282,753 - - - 309 2,784 - - - - - - - 100 100 193,931 68 752 28,359 16,373 269,793 517,430 2,282 245,387 472,382 16,373 269,793 517,430 (14,090) (24,406) (45,048) Starting Fund Balance 4,770 4,770 Net Change - (24,406) Ending Fund Balance 4,770 (19,636) EXPENSE TOTALS 402,168 Fund 240 - HOME FUND Totals 0 EXPENSE TOTALS 402,168 Fund 240 - HOME FUND Totals REVENUE TOTALS 402,168 Debt Service 0 Miscellaneous 500 Interfund Transfers 820 Capital Outlay 0 Insurance and Other Chargebacks 0 Community Sponsored Organizations 0 REVENUE TOTALS 402,168 EXPENSE Salary and Benefits 48,348 Services and Supplies 352,500 REVENUE Intergovernmental Revenue 393,868 Other Revenue 8,300 Interest Income 0 Budget by Organization Report Through 11/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 240 - HOME FUND Run by Ashley King on 12/28/2016 09:59:38 AM Page 15 of 46 November YTD 2015 2016 2016 Actual 20,000 86,667 100,000 - - - - - - 417 209,360 125,150 148 1,248 111 20,564 297,275 225,261 3,007 27,772 - - 201 98 - - - 309 2,784 - - 735 - - - - - 130,819 214,752 - - - 3,316 162,310 214,851 20,564 297,275 225,261 3,316 162,310 214,851 17,249 134,965 10,411 Starting Fund Balance 993,880 993,880 Net Change (313,719) 134,965 Ending Fund Balance 680,161 1,128,845 Fund 250 - AFFORDABLE HOUSING FUND -313,719 Fund 250 - AFFORDABLE HOUSING FUND REVENUE TOTALS 160,628 EXPENSE TOTALS 474,347 Miscellaneous 76,000 Interfund Transfers 0 EXPENSE TOTALS 474,347 Insurance and Other Chargebacks 0 Community Sponsored Organizations 0 Debt Service 0 EXPENSE Salary and Benefits 48,347 Services and Supplies 350,000 Capital Outlay 0 Other Revenue 130,400 Interest Income 228 REVENUE TOTALS 160,628 REVENUE Other Taxes 30,000 Interfund Transfers 0 Intergovernmental Revenue 0 Budget by Organization Report Through 11/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 250 - AFFORDABLE HOUSING FUND Run by Ashley King on 12/28/2016 09:59:38 AM Page 16 of 46 November YTD 2015 2016 2016 Actual 1,714 4,719,928 4,921,484 - - - - - - - - - 1,214 12,423 3,530 2,927 4,732,351 4,925,014 - - - 460 2,488 1,408 - 4,473 198,823 - - 574,976 - 74,007 110,310 338,481 3,723,287 3,265,296 338,941 3,804,256 4,150,811 2,927 4,732,351 4,925,014 338,941 3,804,256 4,150,811 (336,013) 928,095 774,203 Starting Fund Balance 6,442,430 6,442,430 Net Change (2,640,683) 928,095 Ending Fund Balance 3,801,747 7,370,525 EXPENSE TOTALS 7,787,683 Fund 300 - WASHINGTON NATIONAL TIF -2,640,683 EXPENSE TOTALS 7,787,683 Fund 300 - WASHINGTON NATIONAL TIF REVENUE TOTALS 5,147,000 Debt Service 0 Miscellaneous 500,000 Interfund Transfers 6,287,683 EXPENSE Salary and Benefits 0 Services and Supplies 1,000,000 Capital Outlay 0 Other Revenue 0 Interest Income 2,000 REVENUE TOTALS 5,147,000 REVENUE Property Taxes 5,145,000 Other Taxes 0 Interfund Transfers 0 Budget by Organization Report Through 11/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 300 - WASHINGTON NATIONAL TIF FUND Run by Ashley King on 12/28/2016 09:59:38 AM Page 17 of 46 November YTD 2015 2016 2016 Actual - 287,825 422,527 - - - - - - - 35 4 - 287,860 422,531 - - - 410,936 428,186 297,150 - - - 410,936 428,186 297,150 - 287,860 422,531 410,936 428,186 297,150 (410,936) (140,326) 125,381 Starting Fund Balance 525,429 525,429 Net Change (467,971) (140,326) Ending Fund Balance 57,458 385,103 Fund 305 - SPECIAL SERVICE AREA (SSA) -467,971 Fund 305 - SPECIAL SERVICE AREA (SSA) REVENUE TOTALS 300 EXPENSE TOTALS 468,271 Debt Service 416,872 Miscellaneous 0 EXPENSE TOTALS 468,271 Interest Income 300 REVENUE TOTALS 300 EXPENSE Services and Supplies 51,399 REVENUE Property Taxes 0 Interfund Transfers 0 Other Revenue 0 Budget by Organization Report Through 11/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 305 - SPECIAL SERVICE AREA (SSA) #5 Run by Ashley King on 12/28/2016 09:59:38 AM Page 18 of 46 November YTD 2015 2016 2016 Actual - 1,233,675 1,248,231 - - - 211 2,057 1,985 211 1,235,733 1,250,216 460 2,488 1,158 - 1,022,540 11,402 - - - - - - - 129,192 2,162,381 12,704 139,746 148,010 13,164 1,293,965 2,322,950 211 1,235,733 1,250,216 13,164 1,293,965 2,322,950 (12,953) (58,233) (1,072,734) Starting Fund Balance 1,281,115 1,281,115 Net Change (650,450) (58,233) Ending Fund Balance 630,665 1,222,882 REVENUE TOTALS 1,302,000 EXPENSE TOTALS 1,952,450 Fund 310 - HOWARD-HARTREY TIF Totals -650,450 Interfund Transfers 1,752,450 EXPENSE TOTALS 1,952,450 Fund 310 - HOWARD-HARTREY TIF Totals Community Sponsored Organizations 0 Debt Service 0 Miscellaneous 200,000 REVENUE TOTALS 1,302,000 EXPENSE Services and Supplies 0 Capital Outlay 0 REVENUE Property Taxes 1,300,000 Other Revenue 0 Interest Income 2,000 Budget by Organization Report Through 11/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 310 - HOWARD-HARTREY TIF Run by Ashley King on 12/28/2016 09:59:38 AM Page 19 of 46 November YTD 2015 2016 2016 Actual - - - - - - - - - - - - - - - - - - - - 893,387 - - - - - 893,387 - - - - - 893,387 - - (893,387) Starting Fund Balance - - Net Change - - Ending Fund Balance - - Fund 315 - SOUTHWEST TIF FUND Totals 0 Fund 315 - SOUTHWEST TIF FUND Totals REVENUE TOTALS 0 EXPENSE TOTALS 0 Miscellaneous 0 Interfund Transfers 0 EXPENSE TOTALS 0 EXPENSE Services and Supplies 0 Capital Outlay 0 Debt Service 0 REVENUE Property Taxes 0 Interest Income 0 REVENUE TOTALS 0 Budget by Organization Report Through 11/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 315 - SOUTHWEST TIF FUND Run by Ashley King on 12/28/2016 09:59:38 AM Page 20 of 46 November YTD 2015 2016 2016 Actual - 10,328,133 11,156,231 232,861 2,562,002 1,642,654 - 8,211,196 12,278,473 2,819 23,542 7,668 235,680 21,124,873 25,085,026 3,000 100,003 171,576 9,996,095 23,144,863 24,358,022 - - 3,062 - - - 9,999,095 23,244,866 24,532,661 235,680 21,124,873 25,085,026 9,999,095 23,244,866 24,532,661 (9,763,415) (2,119,994) 552,365 Starting Fund Balance 2,596,116 2,596,116 Net Change (2,751,668) (2,119,994) Ending Fund Balance (155,552) 476,122 EXPENSE TOTALS 16,279,452 Fund 320 - DEBT SERVICE FUND Totals -2,751,668 EXPENSE TOTALS 16,279,452 Fund 320 - DEBT SERVICE FUND Totals REVENUE TOTALS 13,527,784 Debt Service 15,963,682 Miscellaneous 0 Interfund Transfers 0 Interest Income 1,500 REVENUE TOTALS 13,527,784 EXPENSE Services and Supplies 315,770 REVENUE Property Taxes 10,879,993 Interfund Transfers 2,646,291 Other Revenue 0 Budget by Organization Report Through 11/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 320 - DEBT SERVICE FUND Run by Ashley King on 12/28/2016 09:59:38 AM Page 21 of 46 November YTD 2015 2016 2016 Actual 4,200 533,105 540,576 6,500 276,263 64,176 0 373 1,815 10,700 809,741 606,568 675 573,377 587,839 - - (6,275) - - - - - - 64 631 585 - - 350 8,958 98,542 107,500 9,697 672,550 689,999 10,700 809,741 606,568 9,697 672,550 689,999 1,003 137,191 (83,431) Starting Fund Balance (28,621) (28,621) Net Change 24,000 137,191 Ending Fund Balance (4,621) 108,570 Fund 330 - HOWARD-RIDGE TIF FUND 24,000 Fund 330 - HOWARD-RIDGE TIF FUND REVENUE TOTALS 1,670,100 EXPENSE TOTALS 1,646,100 Miscellaneous 0 Interfund Transfers 107,500 EXPENSE TOTALS 1,646,100 Insurance and Other Chargebacks 0 Community Sponsored Organizations 0 Debt Service 600 REVENUE TOTALS 1,670,100 EXPENSE Services and Supplies 538,000 Capital Outlay 1,000,000 REVENUE Property Taxes 550,000 Other Revenue 1,120,000 Interest Income 100 Budget by Organization Report Through 11/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 330 - HOWARD-RIDGE TIF FUND Run by Ashley King on 12/28/2016 09:59:38 AM Page 22 of 46 November YTD 2015 2016 2016 Actual - - - 1,028 10,283 - 132 1,512 257 1,161 11,794 257 - 507 1,158 - (1,028) (11,205) - - - - - - 788 7,753 7,185 - - 1,227 2,500 27,500 60,000 3,288 34,732 58,365 1,161 11,794 257 3,288 34,732 58,365 (2,127) (22,937) (58,107) Starting Fund Balance 442,263 442,263 Net Change (39,850) (22,937) Ending Fund Balance 402,413 419,326 Fund 335 - WEST EVANSTON TIF FUND -39,850 Fund 335 - WEST EVANSTON TIF FUND REVENUE TOTALS 150 EXPENSE TOTALS 40,000 Miscellaneous 0 Interfund Transfers 30,000 EXPENSE TOTALS 40,000 Insurance and Other Chargebacks 0 Contingencies 0 Debt Service 10,000 REVENUE TOTALS 150 EXPENSE Services and Supplies 0 Capital Outlay 0 REVENUE Property Taxes 0 Other Revenue 0 Interest Income 150 Budget by Organization Report Through 11/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 335 - WEST EVANSTON TIF FUND Run by Ashley King on 12/28/2016 09:59:38 AM Page 23 of 46 November YTD 2015 2016 2016 Actual - - - - - 2,000,000 - - 2,000,000 971 971 - - - 2,000,000 25,889 25,889 - 26,861 26,861 2,000,000 - - 2,000,000 26,861 26,861 2,000,000 (26,861) (26,861) - Starting Fund Balance - - Net Change - (26,861) Ending Fund Balance - (26,861) 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 0 Capital Outlay 0 Debt Service 40,000 REVENUE Property Taxes 0 Other Revenue 50,000 REVENUE TOTALS 50,000 Budget by Organization Report Through 11/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 340 - DEMPSTER-DODGE TIF FUND Run by Ashley King on 12/28/2016 09:59:38 AM Page 24 of 46 November YTD 2015 2016 2016 Actual - - - - 580,000 900,000 - 580,000 900,000 (971) 437 - 580,000 1,160,000 580,000 (21,319) 14,666 7,930 557,710 1,175,103 587,930 - 580,000 900,000 557,710 1,175,103 587,930 (557,710) (595,103) 312,070 Starting Fund Balance 312,070 312,070 Net Change 31,500 (595,103) Ending Fund Balance 343,570 (283,033) EXPENSE TOTALS 43,500 Fund 345 - CHICAGO-MAIN TIF Totals 31,500 EXPENSE TOTALS 43,500 Fund 345 - CHICAGO-MAIN TIF Totals REVENUE TOTALS 75,000 EXPENSE Services and Supplies 0 Capital Outlay 0 Debt Service 43,500 REVENUE Property Taxes 75,000 Other Revenue 0 REVENUE TOTALS 75,000 Budget by Organization Report Through 11/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 345 - CHICAGO-MAIN TIF Run by Ashley King on 12/28/2016 09:59:38 AM Page 25 of 46 November YTD 2015 2016 2016 Actual 847 222,787 - - 1 - 847 222,788 - - - - - - - - - - 847 222,788 - - - - 847 222,788 - Starting Fund Balance - - Net Change 10,500 222,788 Ending Fund Balance 10,500 222,788 Fund 350 - SPECIAL SERVICE AREA (SSA) 10,500 Fund 350 - SPECIAL SERVICE AREA (SSA) REVENUE TOTALS 210,500 EXPENSE TOTALS 200,000 EXPENSE Services and Supplies 200,000 Interfund Transfers 0 EXPENSE TOTALS 200,000 REVENUE Property Taxes 210,000 Interest Income 500 REVENUE TOTALS 210,500 Budget by Organization Report Through 11/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 350 - SPECIAL SERVICE AREA (SSA) #6 Run by Ashley King on 12/28/2016 09:59:38 AM Page 26 of 46 November YTD 2015 2016 2016 Actual - 96,586 87,391 240,083 2,640,917 - - 1,527,914 270,268 - 9,591,988 7,945,481 3,066 13,639 3,815 243,150 13,871,045 8,306,954 - - - 152,209 963,847 643,510 1,156,241 6,124,816 9,794,396 - - - - - 32,933 - - 490,000 1,308,450 7,088,663 10,960,839 243,150 13,871,045 8,306,954 1,308,450 7,088,663 10,960,839 (1,065,301) 6,782,381 (2,653,885) Starting Fund Balance 5,517,041 5,517,041 Net Change (2,209,000) 6,782,381 Ending Fund Balance 3,308,041 12,299,422 EXPENSE TOTALS 22,769,615 Fund 415 - CAPITAL IMPROVEMENTS -2,209,000 EXPENSE TOTALS 22,769,615 Fund 415 - CAPITAL IMPROVEMENTS REVENUE TOTALS 20,560,615 Debt Service 0 Miscellaneous 0 Interfund Transfers 490,000 EXPENSE Salary and Benefits 0 Services and Supplies 2,256,962 Capital Outlay 20,022,653 Other Revenue 9,248,000 Interest Income 0 REVENUE TOTALS 20,560,615 REVENUE Charges for Services 0 Interfund Transfers 6,471,000 Intergovernmental Revenue 4,841,615 Budget by Organization Report Through 11/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 415 - CAPITAL IMPROVEMENTS FUND Run by Ashley King on 12/28/2016 09:59:38 AM Page 27 of 46 November YTD 2015 2016 2016 Actual - - - - - - - - - - - - - - - - - - - - - - 513,349 243,113 - - - - - - - - - 649 25,534 24,832 1,105 122,796 125,218 - - - 1,754 661,679 393,163 - - - - 8,342 1,879 - - 226,538 - - - - - - - - 534 30,058 330,640 - 30,058 338,982 228,951 1,754 661,679 393,163 30,058 338,982 228,951 (28,304) 322,697 164,213 Starting Fund Balance 2,682,781 2,682,781 Net Change 98,950 322,697 Ending Fund Balance 2,781,731 3,005,478 REVENUE TOTALS 481,200 EXPENSE TOTALS 382,250 Fund 420 - SPECIAL ASSESSMENT FUND 98,950 Interfund Transfers 382,250 EXPENSE TOTALS 382,250 Fund 420 - SPECIAL ASSESSMENT FUND Insurance and Other Chargebacks 0 Debt Service 0 Miscellaneous 0 EXPENSE Salary and Benefits 0 Services and Supplies 0 Capital Outlay 0 Special Assessment 180,167 Reappropriation of Surplus 0 REVENUE TOTALS 481,200 Insurance 0 Library Revenue 0 Interest Income 51,033 Intergovernmental Revenue 0 Other Revenue 250,000 Workers Compensation and Liability 0 Fines and Forfeitures 0 Charges for Services 0 Interfund Transfers 0 REVENUE Property Taxes 0 Other Taxes 0 Licenses, Permits and Fees 0 Budget by Organization Report Through 11/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 420 - SPECIAL ASSESSMENT FUND Run by Ashley King on 12/28/2016 09:59:38 AM Page 28 of 46 November YTD 2015 2016 2016 Actual - - - - - - 50 3,200 150 - - - 473,527 5,864,393 6,010,558 309,314 3,402,454 2,925,296 - - - 1,521 153,040 153,545 3,273 28,291 18,260 787,685 9,451,378 9,107,809 194,534 1,160,283 963,107 218,333 2,814,958 2,859,622 733,228 2,151,124 128,726 17,001 164,667 158,538 - - - - - 2,846,227 388 4,790 6,951 3,707,103 3,907,082 503,423 24,049 238,064 23,687 135,286 1,488,146 1,242,741 5,029,921 11,929,114 8,733,020 787,685 9,451,378 9,107,809 5,029,921 11,929,114 8,733,020 (4,242,236) (2,477,736) 374,789 Starting Fund Balance 10,777,874 10,777,874 Net Change (6,615,186) (2,477,736) Ending Fund Balance 4,162,688 8,300,138 Fund 505 - PARKING SYSTEM FUND Totals -6,615,186 Fund 505 - PARKING SYSTEM FUND Totals REVENUE TOTALS 10,322,856 EXPENSE TOTALS 16,938,042 Miscellaneous 252,000 Interfund Transfers 1,623,431 EXPENSE TOTALS 16,938,042 Depreciation Expense 2,873,395 Contingencies 11,000 Debt Service 3,917,652 Capital Outlay 3,474,000 Insurance and Other Chargebacks 188,252 Community Sponsored Organizations 0 REVENUE TOTALS 10,322,856 EXPENSE Salary and Benefits 1,297,037 Services and Supplies 3,301,275 Intergovernmental Revenue 12,125 Other Revenue 119,216 Interest Income 35,070 Fines and Forfeitures 0 Charges for Services 6,444,675 Interfund Transfers 3,711,770 REVENUE Property Taxes 0 Other Taxes 0 Licenses, Permits and Fees 0 Budget by Organization Report Through 11/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 505 - PARKING SYSTEM FUND Run by Ashley King on 12/28/2016 09:59:38 AM Page 29 of 46 November YTD 2015 2016 2016 Actual - - - 5,230 86,585 105,483 1,370,698 17,443,977 15,308,225 - 8,447,244 2,354,582 - - - 265,193 4,218,625 350,065 1,756 14,717 3,448 1,642,877 30,211,147 18,121,804 343,379 3,900,390 3,927,752 257,414 2,468,225 2,298,993 129,526 7,304,615 105 52,184 576,278 663,015 - - - - - 2,096,633 - 658 933 1,093,704 1,500,974 432,628 - 10,543 (286,678) 330,901 12,087,159 4,161,059 13,294,439 1,642,877 30,211,147 18,121,804 2,537,444 20,753,485 13,294,439 (894,567) 9,457,662 4,827,365 Starting Fund Balance 9,223,203 9,223,203 Net Change (3,407,255) 9,457,662 Ending Fund Balance 5,815,948 18,680,865 EXPENSE TOTALS 41,125,255 Fund 510 - WATER FUND Totals -3,407,255 2,537,444 20,753,485EXPENSE TOTALS 41,125,255 Fund 510 - WATER FUND Totals REVENUE TOTALS 37,718,000 Debt Service 1,053,288 Miscellaneous 62,980 Interfund Transfers 3,970,805 Community Sponsored Organizations 0 Depreciation Expense 0 Contingencies 1,000 Services and Supplies 6,155,950 Capital Outlay 24,776,106 Insurance and Other Chargebacks 645,703 Interest Income 1,600 REVENUE TOTALS 37,718,000 EXPENSE Salary and Benefits 4,459,423 Interfund Transfers 0 Intergovernmental Revenue 0 Other Revenue 22,348,400 REVENUE Other Taxes 0 Licenses, Permits and Fees 70,000 Charges for Services 15,298,000 Budget by Organization Report Through 11/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 510 - WATER FUND Run by Ashley King on 12/28/2016 09:59:38 AM Page 30 of 46 November YTD 2015 2016 2016 Actual 819,194 12,227,044 12,510,940 - - - - 554,863 2,962 721 4,058 2,706 819,914 12,785,965 12,516,607 74,726 858,437 892,099 3,072 287,374 108,927 - 723,144 13,609 12,598 128,111 142,473 - - 3,443,723 - - - 1,476,884 8,420,970 1,550,407 - 5,000 3,306 86,988 956,873 1,005,223 1,654,268 11,379,908 7,159,766 819,914 12,785,965 12,516,607 1,654,268 11,379,908 7,159,766 (834,354) 1,406,057 5,356,842 Starting Fund Balance 4,012,808 4,012,808 Net Change (1,607,486) 1,406,057 Ending Fund Balance 2,405,322 5,418,865 Fund 515 - SEWER FUND Totals -1,607,486 Fund 515 - SEWER FUND Totals REVENUE TOTALS 13,873,815 EXPENSE TOTALS 15,481,301 Miscellaneous 1,500 Interfund Transfers 1,043,864 EXPENSE TOTALS 15,481,301 Depreciation Expense 0 Contingencies 0 Debt Service 9,222,913 Services and Supplies 995,800 Capital Outlay 3,048,314 Insurance and Other Chargebacks 144,451 Interest Income 1,000 REVENUE TOTALS 13,873,815 EXPENSE Salary and Benefits 1,024,459 REVENUE Charges for Services 12,888,650 Interfund Transfers 0 Other Revenue 984,165 Budget by Organization Report Through 11/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 515 - SEWER FUND Run by Ashley King on 12/28/2016 09:59:38 AM Page 32 of 46 November YTD 2015 2016 2016 Actual - 125,404 213,490 284,951 3,264,109 3,561,584 87,997 967,970 1,055,967 - - - 182,543 274,292 228,469 - - - 555,491 4,631,775 5,059,510 51,823 636,814 600,068 442,360 3,180,869 3,717,885 2,650 5,314 24,738 11,805 125,087 249,232 - - - - - - - - - 19,089 20,233 68,419 - 12,232 - 41,624 457,869 490,106 569,352 4,438,417 5,150,448 555,491 4,631,775 5,059,510 569,352 4,438,417 5,150,448 (13,860) 193,358 (90,938) Starting Fund Balance (1,228,557) (1,228,557) Net Change 60,844 193,358 Ending Fund Balance (1,167,713) (1,035,199) Fund 520 - SOLID WASTE FUND Totals 60,844 Fund 520 - SOLID WASTE FUND Totals REVENUE TOTALS 5,201,361 EXPENSE TOTALS 5,140,517 Miscellaneous 15,000 Interfund Transfers 499,493 EXPENSE TOTALS 5,140,517 Depreciation Expense 0 Contingencies 0 Debt Service 0 Capital Outlay 25,750 Insurance and Other Chargebacks 129,690 Community Sponsored Organizations 0 REVENUE TOTALS 5,201,361 EXPENSE Salary and Benefits 738,408 Services and Supplies 3,732,176 Intergovernmental Revenue 0 Other Revenue 238,000 Interest Income 0 REVENUE Licenses, Permits and Fees 275,000 Charges for Services 3,632,394 Interfund Transfers 1,055,967 Budget by Organization Report Through 11/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 520 - SOLID WASTE FUND Run by Ashley King on 12/28/2016 09:59:38 AM Page 33 of 46 November YTD 2015 2016 2016 Actual 282,301 3,105,379 3,289,009 - - - - - - 3,075 12,562 46,933 - - - 285,376 3,117,940 3,335,942 66,290 732,493 961,887 280,720 1,728,063 1,686,117 - - - 14,017 151,762 175,716 - - - - - - - - - - - - 2,230 24,532 25,820 363,257 2,636,850 2,849,539 285,376 3,117,940 3,335,942 363,257 2,636,850 2,849,539 (77,881) 481,090 486,403 Starting Fund Balance 365,460 365,460 Net Change (244,277) 481,090 Ending Fund Balance 121,183 846,550 EXPENSE TOTALS 3,644,146 Fund 600 - FLEET SERVICES FUND Totals -244,277 EXPENSE TOTALS 3,644,146 Fund 600 - FLEET SERVICES FUND Totals REVENUE TOTALS 3,399,869 Debt Service 0 Miscellaneous 0 Interfund Transfers 26,762 Insurance and Other Chargebacks 184,136 Depreciation Expense 0 Contingencies 450 EXPENSE Salary and Benefits 1,052,741 Services and Supplies 2,380,057 Capital Outlay 0 Other Revenue 81,781 Interest Income 1,000 REVENUE TOTALS 3,399,869 REVENUE Charges for Services 3,317,088 Interfund Transfers 0 Intergovernmental Revenue 0 Budget by Organization Report Through 11/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 600 - FLEET SERVICES FUND Run by Ashley King on 12/28/2016 09:59:38 AM Page 34 of 46 November YTD 2015 2016 2016 Actual 121,255 1,333,917 1,451,422 - - - 3,325 34,762 34,286 124,580 1,368,679 1,485,708 2,565 54,441 53,400 780,875 811,386 - - - 1,684,835 - - - 783,440 865,827 1,738,234 124,580 1,368,679 1,485,708 783,440 865,827 1,738,234 (658,860) 502,852 (252,527) Starting Fund Balance 1,277,689 1,277,689 Net Change 146,216 502,852 Ending Fund Balance 1,423,905 1,780,541 Fund 601 - EQUIPMENT REPLACEMENT 146,216 Fund 601 - EQUIPMENT REPLACEMENT REVENUE TOTALS 1,661,638 EXPENSE TOTALS 1,515,422 Depreciation Expense 0 Miscellaneous 0 EXPENSE TOTALS 1,515,422 REVENUE TOTALS 1,661,638 EXPENSE Services and Supplies 60,000 Capital Outlay 1,455,422 REVENUE Charges for Services 1,451,421 Interfund Transfers 0 Other Revenue 210,217 Budget by Organization Report Through 11/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 601 - EQUIPMENT REPLACEMENT FUND Run by Ashley King on 12/28/2016 09:59:38 AM Page 35 of 46 November YTD 2015 2016 2016 Actual 3,356 36,998 162,411 68 752 306,051 842,904 8,933,373 10,413,499 4,026 80,604 1,034,405 534,423 5,934,608 5,753,308 27 198 136 1,384,805 14,986,533 17,669,810 43,503 384,236 460,086 198,454 2,035,044 1,305,086 - - - 1,233,433 13,354,511 14,318,413 - - - - - - - - - - - - - 4,330 - 772 8,490 8,936 1,476,161 15,786,610 16,092,521 1,384,805 14,986,533 17,669,810 1,476,161 15,786,610 16,092,521 (91,356) (800,077) 1,577,289 Starting Fund Balance (364,496) (364,496) Net Change 565,405 (800,077) Ending Fund Balance 200,909 (1,164,573) Fund 605 - INSURANCE FUND Totals 565,405 Fund 605 - INSURANCE FUND Totals REVENUE TOTALS 17,758,038 EXPENSE TOTALS 17,192,633 Miscellaneous 0 Interfund Transfers 9,262 EXPENSE TOTALS 17,192,633 Depreciation Expense 0 Contingencies 0 Debt Service 0 Capital Outlay 0 Insurance and Other Chargebacks 15,378,608 Community Sponsored Organizations 0 REVENUE TOTALS 17,758,038 EXPENSE Salary and Benefits 419,515 Services and Supplies 1,385,248 Workers Compensation and Liability 1,023,094 Insurance 6,459,839 Interest Income 1,000 REVENUE Charges for Services 162,411 Interfund Transfers 0 Other Revenue 10,111,694 Budget by Organization Report Through 11/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 605 - INSURANCE FUND Run by Ashley King on 12/28/2016 09:59:38 AM Page 36 of 46 November YTD 2015 2016 2016 Actual - - - - - 280,000 - - - 111,404 9,961,659 6,273,004 - 1,033,287 1,206,228 111,404 10,994,946 7,759,232 697,911 7,818,351 8,302,220 - - - - - - - - - - - - 697,911 7,818,351 8,302,220 111,404 10,994,946 7,759,232 697,911 7,818,351 8,302,220 (586,507) 3,176,596 (542,988) Starting Fund Balance 66,741,084 66,741,084 Net Change 4,297,865 3,176,596 Ending Fund Balance 71,038,949 69,917,680 Fund 700 - FIRE PENSION FUND Totals 4,297,865 Fund 700 - FIRE PENSION FUND Totals REVENUE TOTALS 12,460,865 EXPENSE TOTALS 8,163,000 Debt Service 0 Miscellaneous 0 EXPENSE TOTALS 8,163,000 EXPENSE Salary and Benefits 8,163,000 Services and Supplies 0 Community Sponsored Organizations 0 Other Revenue 1,010,000 Interest Income 4,100,000 REVENUE TOTALS 12,460,865 REVENUE Property Taxes 7,070,865 Other Taxes 280,000 Interfund Transfers 0 Budget by Organization Report Through 11/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 700 - FIRE PENSION FUND Run by Ashley King on 12/28/2016 09:59:38 AM Page 37 of 46 November YTD 2015 2016 2016 Actual - - 57,836 - - 325,000 - - - 160,967 13,744,561 7,676,438 - 2,066,522 2,902,399 160,967 15,811,083 10,961,673 908,593 10,400,043 10,768,296 - - - - - - - - - 908,593 10,400,043 10,768,296 160,967 15,811,083 10,961,673 908,593 10,400,043 10,768,296 (747,627) 5,411,041 193,377 Starting Fund Balance 98,558,837 98,558,837 Net Change 6,383,940 5,411,041 Ending Fund Balance 104,942,777 103,969,878 REVENUE TOTALS 17,430,940 EXPENSE TOTALS 11,047,000 Fund 705 - POLICE PENSION FUND Totals 6,383,940 Miscellaneous 0 EXPENSE TOTALS 11,047,000 Fund 705 - POLICE PENSION FUND Totals EXPENSE Salary and Benefits 11,047,000 Services and Supplies 0 Debt Service 0 Other Revenue 1,550,000 Interest Income 6,500,000 REVENUE TOTALS 17,430,940 REVENUE Property Taxes 9,055,940 Other Taxes 325,000 Interfund Transfers 0 Budget by Organization Report Through 11/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 705 - POLICE PENSION FUND Run by Ashley King on 12/28/2016 09:59:38 AM Page 38 of 46