Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2016.09 September Monthly Report
To: Wally Bobkiewicz, City Manager Martin Lyons, Assistant City Manager/Chief Financial Officer From: Ashley King, Finance Division Manager Subject: September 2016 Monthly Financial Report Date: November 4, 2016 Please find attached the unaudited financial statements as of September 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 88,063,846 82,784,748 5,279,097 15,983,933 9,442,294 663,595 642,351 21,244 21,244 56,650 860,815 592,136 268,679 781,918 783,768 1,000,000 375,000 625,000 625,000 625,000 6,393,503 4,790,659 1,602,844 1,756,715 2,277,293 61,586 73,574 (11,989)(11,989) 150,226 1,415,956 1,798,283 (382,327)1,448,066 1,305,703 653,850 1,002,708 (348,859)202,860 28,325 321,194 242,250 78,944 (111,600) (111,600) 813,213 899,241 (86,028)(26,146) (26,145) 78,770 137,377 (58,607)99,758 153,282 1,826,149 1,679,547 146,601 2,702,583 2,369,902 0 169,915 169,915 187,693 146,790 40,903 45,673 95,673 234,517 155,684 78,833 1,072,713 1,035,992 1,040,978 83,277 957,701 994,365 843,912 4,727,840 3,102,166 1,625,674 8,068,104 8,147,023 287,860 17,250 270,610 796,039 796,039 1,235,304 2,385,491 (1,150,186)130,929 192,000 638,163 397,884 240,279 211,658 213,926 9,435 28,181 (18,747)423,516 431,838 580,000 612,972 (32,972)279,098 279,098 20,653,553 4,236,780 16,416,774 19,012,890 10,035,869 221,813 221,813 221,813 221,813 14,206,703 4,387,323 9,819,380 15,336,421 16,061,794 659,584 278,039 381,545 3,064,326 3,060,789 8,320,838 5,533,079 2,787,759 13,565,633 13,113,893 25,705,352 23,485,187 2,220,165 11,443,368 8,323,248 10,625,477 9,284,954 1,340,523 5,353,331 3,234,833 3,681,938 3,599,449 82,489 (1,146,068) (1,663,660) 2,550,264 2,020,936 529,328 894,788 223,673 1,122,843 58,670 1,064,173 2,341,862 1,946,791 12,363,450 13,021,199 (657,749)(1,022,245) 1,763,705 TOTAL 211,206,082 167,853,187 43,352,895 104,730,471 85,582,864 Fund Fund Description 100 GENERAL FUND 185 LIBRARY FUND 195 NEIGHBORHOOD STABILIZATION 176 HEALTH AND HUMAN SERVICES 175 GENERAL ASSISTANCE FUND 180 GOOD NEIGHBOR FUND 200 MOTOR FUEL TAX FUND 205 EMERGENCY TELEPHONE (E911) 210 SPECIAL SERVICE AREA (SSA) #4 215 CDBG FUND 220 CDBG LOAN 225 ECONOMIC DEVELOPMENT FUND 250 AFFORDABLE HOUSING FUND 186 LIBRARY DEBT SERVICE FUND 235 NEIGHBORHOOD IMPROVEMENT 240 HOME FUND 330 HOWARD-RIDGE TIF FUND 300 WASHINGTON NATIONAL TIF 305 SPECIAL SERVICE AREA (SSA) #5 310 HOWARD-HARTREY TIF 320 DEBT SERVICE FUND 350 SSA #6 335 WEST EVANSTON TIF FUND 345 CHICAGO-MAIN TIF 505 PARKING SYSTEM FUND 510 WATER FUND 415 CAPITAL IMPROVEMENTS FUND 420 SPECIAL ASSESSMENT FUND 601 EQUIPMENT REPLACEMENT FUND 605 INSURANCE FUND 515 SEWER FUND 520 SOLID WASTE FUND 600 FLEET SERVICES FUND NOTE: Negative Cash Balances (as seen above in the CDBG, SSA 4, & 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 a s of September 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 September 30, 2016, the General Fund is reporting a net surplus of $5,279,097. The attached supplemental charts show the General Fund Revenues at 78.5% of budget and expenses lower at 74%. The September target is 75%. General Fund revenues include the $2.9 million permit from Northwestern as well as pension property taxes. General Fund Expenses are just above budget year-to-date due to the pension payments being totally paid for the year as of September 30, 2016. The net surplus is anticipated to be mitigated by the 3 payrolls in December. Through September 30, 2016, the SSA #4 Fund is showing a negative cash balance of $111,600 due to the timing of payments to the Downtown Evanston group and receipt of property taxes. Through September 30, 2016, the CDBG Fund is showing a negative cash balance of $26,145 which will be reimbursed from August draw-downs. Through September 30, 2016, the Economic Development Fund is showing a fund balance of $2,702,583 and a cash balance of $2,369,902. 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 will be refunded to the County during the second installment billing. The fund will then officially close. Through September 30, 2016, the enterprise funds (Parking, Water, and Sewer) have balances above average. As construction season continues, the balances in all three of these funds will be reduced. Through September 30, 2016, the Solid Waste Fund has a negative fund balance of $1,022,245 and a negative cash balance of $1,663,660. Through September 30, 2016, the Insurance Fund is showing a negative fund balance of $1,022,245 with a cash balance of $1,763,705. 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 the following link: http://www.cityofevanston.org/city-budget/financial- reports/. Fund 100 - GENERAL FUND 2016 Budget Sept Actual YTD Actual % 2015 Actual 27,417,407 301,397 27,021,032 99% 25,915,970 45,986,550 3,426,087 31,933,910 69% 44,978,985 5,329,777 149,970 2,477,747 46% 5,324,137 9,276,550 409,276 10,006,627 108% 6,704,846 125,700 197 44,301 35% 155,619 4,609,825 305,475 2,539,279 55% 3,548,230 640,000 - 6,695 1% 640,000 5,374,751 252,574 4,855,666 90% 5,406,379 2,433,216 238,283 1,884,333 77% 2,239,528 8,842,365 847,527 6,017,462 68% 7,836,484 765,727 79,991 556,145 73% 670,245 1,286,843 138,182 701,441 55% 894,703 50,000 3,238 19,209 38% 6,572 112,138,711 6,152,197 88,063,846 78.5% 104,321,698 424,958 30,232 309,187 73% 419,962 263,203 23,863 214,722 82% 283,764 6,989,746 484,786 4,432,151 63% 1,814,469 1,130,000 88,745 748,204 66% 1,051,325 9,634,173 858,397 6,345,539 66% 9,763,951 2,782,897 214,725 1,804,294 65% 2,425,618 37,696,278 2,250,013 29,229,268 78% 37,239,961 22,601,742 1,353,764 18,427,747 82% 21,331,507 3,610,779 239,748 2,269,622 63% 3,212,848 11,845,590 1,106,074 8,906,137 75% 11,180,116 14,861,248 1,192,496 10,097,330 68% - 111,840,614 7,842,843 82,784,202 74.0% 88,723,520 112,138,711 6,152,197 88,063,846 64% 104,321,698 111,840,614 7,842,843 82,784,202 60% 88,723,520 298,097 (1,690,646) 5,279,643 1,771% 15,598,178 Fund 100 - GENERAL FUND Net Gain 40 - PUBLIC WORKS AGENCY EXPENSE TOTAL Fund 100 - GENERAL FUND Totals REVENUE TOTALS EXPENSE TOTALS 19 - ADMINISTRATIVE SERVICES 21 - COMMUNITY DEVELOPMENT 22 - POLICE 23 - FIRE MGMT & SUPPORT 24 - HEALTH 30 - PARKS, REC. AND COMMUNITY Interest Income REVENUE TOTAL 13 - CITY COUNCIL 14 - CITY CLERK 15 - CITY MANAGER'S OFFICE 17 - LAW 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 FINANCIAL REPORT Through 09/30/16 Enterprise Funds Classification Fund 505 - PARKING SYSTEM FUND 2016 Budget Sept Actual YTD Actual % 2015 Actual - 150 3,150 +++ 150 6,379,675 597,376 5,217,522 82 6,010,558 65,000 - 168,500 259 - 3,711,770 309,314 2,783,826 75 2,925,296 12,125 - - 0 - 119,216 11,594 126,237 106 153,545 35,070 3,432 21,603 62 18,260 10,322,856 921,867 8,320,838 9,107,809 23,000 443 16,898 73 29,187 1,160,688 78,785 787,850 68 966,953 113,349 7,651 75,204 66 (33,034) 3,022,411 239,853 2,182,170 72 2,616,554 278,864 33,382 160,486 58 243,068 3,474,000 6,238 542,224 16 128,726 507,900 42,154 372,014 73 478,187 2,873,395 - - 0 2,846,227 11,000 991 4,403 40 6,951 3,917,652 - 199,979 5 503,423 252,000 47,162 214,015 85 23,687 1,303,783 108,649 977,837 75 923,092 16,938,042 565,307 5,533,079 8,733,020 10,322,856 921,867 8,320,838 81% 9,107,809 16,938,042 565,307 5,533,079 33% 8,733,020 (6,615,186) 356,559 2,787,759 (42%) 374,789 EXPENSE TOTALS Fund 505 - PARKING SYSTEM 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 FINANCIAL REPORT Through 09/30/16 Enterprise Funds Classification Fund 510 - WATER FUND 2016 Budget Sept Actual YTD Actual % 2015 Actual 70,000 6,513 71,716 102% 105,483 15,133,000 2,793,973 13,667,214 90% 15,141,770 39,000 4,214 34,136 88% 40,911 126,000 140 134,470 107% 125,545 - 950,000 7,947,244 2,354,582 22,348,400 3,763,382 3,839,371 17% 350,065 1,600 1,712 11,201 700% 3,448 37,718,000 7,519,934 25,705,352 68% 18,121,804 210,465 16,921 136,112 65% 157,679 3,888,603 298,582 2,807,030 72% 3,884,943 360,355 30,297 280,583 78% (114,870) 4,763,760 414,840 1,359,383 29% 1,250,874 1,392,190 106,048 640,887 46% 1,048,119 24,776,106 972,018 6,478,847 26% 105 1,114,195 91,313 823,645 74% 1,131,508 - - - 2,096,633 1,000 - 658 66% 933 1,053,288 - 373,518 35% 432,628 62,980 - 10,543 17% (286,678) 3,502,313 1,241,859 10,573,979 302% 3,692,565 41,125,255 3,171,879 23,485,187 57% 13,294,439 37,718,000 7,519,934 25,705,352 18,121,804 41,125,255 3,171,879 23,485,187 13,294,439 (3,407,255) 4,348,055 2,220,165 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 FINANCIAL REPORT Through 09/30/16 Enterprise Funds Classification Fund 515 - SEWER FUND 2016 Budget Sept Actual YTD Actual % 2015 Actual 12,869,000 1,128,943 10,046,032 78% 12,491,290 19,650 21,579 21,579 110% 19,650 984,165 - 554,863 56% 2,962 1,000 183 3,003 300% 2,706 13,873,815 1,150,705 10,625,477 77% 12,516,607 57,040 3,126 28,063 49% 60,837 881,327 60,214 627,087 71% 858,361 86,092 6,108 61,243 71% (27,099) 903,500 14,025 247,929 27% 90,109 92,300 4,579 28,580 31% 18,817 3,048,314 - 723,144 24% 13,609 414,439 33,886 306,258 74% 412,461 - - - 3,443,723 9,222,913 1,859,821 6,677,246 72% 1,550,407 1,500 - 5,000 333% 3,306 773,876 64,489 580,405 75% 735,235 15,481,301 2,046,248 9,284,954 60% 7,159,766 13,873,815 1,150,705 10,625,477 77% 12,516,607 15,481,301 2,046,248 9,284,954 60% 7,159,766 (1,607,486) (895,543) 1,340,523 (83%) 5,356,842 Fund 515 - SEWER FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund 515 - SEWER FUND Net Gain 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 FINANCIAL REPORT Through 09/30/16 Enterprise Funds Classification Fund 520 - SOLID WASTE FUND 2016 Budget Sept Actual YTD Actual % 2015 Actual 275,000 43,470 125,404 46% 213,490 3,632,394 306,709 2,678,099 74% 3,561,584 1,055,967 87,997 791,975 75% 1,055,967 238,000 24,434 86,459 36% 228,469 5,201,361 462,610 3,681,938 71% 5,059,510 25,000 2,805 31,178 125% 41,358 649,690 50,526 449,781 69% 574,692 63,718 5,089 45,886 72% (15,981) 3,679,126 462,693 2,535,908 69% 3,644,097 53,050 8,021 44,557 84% 73,788 25,750 - 2,664 10% 24,738 129,690 11,805 101,478 78% 249,232 - - 1,144 68,419 15,000 - 12,232 82% - 499,493 41,624 374,620 75% 490,106 5,140,517 582,564 3,599,449 70% 5,150,448 5,201,361 462,610 3,681,938 71% 5,059,510 5,140,517 582,564 3,599,449 70% 5,150,448 60,844 (119,954) 82,489 136% (90,938) REVENUE TOTALS EXPENSE TOTALS Fund 520 - SOLID WASTE FUND Net Gain 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 FINANCIAL REPORT Through 09/30/16 Enterprise Funds Classification Jan Feb Mar Apr May Jun Jul Aug Sept 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 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 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 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 2015 v 2016 Fund and Cash Balance-- General Fund - 5,000,000 10,000,000 15,000,000 20,000,000 25,000,000 Jan Feb Mar Apr May Jun Jul Aug Sept 2015 Unreserved Fund Balance 2016 Unreserved Fund Balance 2015 Cash Balance 2016 Cash Balance Sept YTD 2016 2016 Actual 301,397 27,021,032 25,915,970 3,426,087 31,933,910 44,978,985 559,443 12,528,675 12,184,602 305,475 2,539,279 3,548,230 490,857 6,746,694 8,285,907 847,527 6,017,462 7,836,484 79,991 556,145 670,245 138,182 701,441 894,703 - - - - - - - - - 3,238 19,209 6,572 - - - - - - 6,152,197 88,063,846 104,321,698 4,678,254 43,724,250 60,215,578 1,300,659 8,003,597 11,506,401 6,388 96,361 155,975 902,128 7,936,623 10,846,854 64,205 635,844 952,678 - - - 5 50,790 30,529 - - - 148,535 1,192,600 17,171,181 742,668 21,144,683 5,993,080 7,842,843 82,784,748 106,872,275 6,152,197 88,063,846 104,321,698 7,842,843 82,784,748 106,872,275 (1,690,646) 5,279,097 (2,550,577) Starting Fund Balance 10,704,836 10,704,836 Net Change (567,485) 5,279,097 Ending Fund Balance 10,137,351 15,983,933 REVENUE TOTALS 112,138,711 EXPENSE TOTALS 112,706,196 Fund 100 - GENERAL FUND Totals (567,485) Interfund Transfers 7,253,832 EXPENSE TOTALS 112,706,196 Fund 100 - GENERAL FUND Totals Contingencies 213,505 Debt Service - Miscellaneous 1,679,285 Insurance and Other Chargebacks 28,210,185 Community Sponsored Organizations 925,029 Depreciation Expense - EXPENSE Salary and Benefits 62,388,836 Services and Supplies 11,834,924 Capital Outlay 200,600 Special Assessment - Reappropriation of Surplus - REVENUE TOTALS 112,138,711 Insurance - Library Revenue - Interest Income 50,000 Intergovernmental Revenue 765,727 Other Revenue 1,286,843 Workers Compensation and Liability - 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 Monthly Financial Report Through 09/30/16 2016 Classification Budget Fund 100 - GENERAL FUND 2015 Actual Run by Ashley King on 10/27/2016 10:47:47 AM Page 1 of 48 Sept YTD 2016 2016 Actual 9,272 816,283 1,313,420 - - - - - - - - - - - - - - - - - 3,208 7,683 44,018 19,534 - - - - - - - - - 193 513 62 - - - - - - 17,148 860,815 1,336,224 16,097 173,887 166,822 45,054 396,993 592,645 - - - 2,140 16,840 18,609 - - - - - - - - - - - - 155 4,416 4,625 - - - 63,446 592,136 782,701 17,148 860,815 1,336,224 63,446 592,136 782,701 (46,298) 268,679 553,522 Starting Fund Balance 513,239 513,239 Net Change 38,167 268,679 Ending Fund Balance 551,406 781,918 REVENUE TOTALS 1,026,000 EXPENSE TOTALS 987,833 Fund 175 - GENERAL ASSISTANCE FUND 38,167 Interfund Transfers - EXPENSE TOTALS 987,833 Fund 175 - GENERAL ASSISTANCE FUND Contingencies - Debt Service - Miscellaneous 7,000 Insurance and Other Chargebacks 21,229 Community Sponsored Organizations - Depreciation Expense - EXPENSE Salary and Benefits 200,704 Services and Supplies 758,900 Capital Outlay - Special Assessment - Reappropriation of Surplus - REVENUE TOTALS 1,026,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 - REVENUE Property Taxes 1,000,000 Other Taxes - Licenses, Permits and Fees - Monthly Financial Report Through 09/30/16 2016 Classification Budget Fund 175 - GENERAL ASSISTANCE FUND 2015 Actual Run by Ashley King on 10/27/2016 10:47:47 AM Page 3 of 48 Sept YTD 2016 2016 Actual - - - 73,733 663,595 884,794 - - - - - - 73,733 663,595 884,794 - - - - - - 203,597 642,351 849,388 - - - 203,597 642,351 849,388 73,733 663,595 884,794 203,597 642,351 849,388 (129,864) 21,244 35,406 Starting Fund Balance - - Net Change 25,641 21,244 Ending Fund Balance 25,641 21,244 EXPENSE TOTALS 859,153 Fund 176 - HEALTH AND HUMAN 25,641 2015 Actual EXPENSE TOTALS 859,153 Fund 176 - HEALTH AND HUMAN REVENUE TOTALS 884,794 Capital Outlay - Community Sponsored Organizations 859,153 Miscellaneous - Other Revenue - REVENUE TOTALS 884,794 EXPENSE Services and Supplies - REVENUE Charges for Services - Interfund Transfers 884,794 Intergovernmental Revenue - Monthly Financial Report Through 09/30/16 2016 Classification Budget Fund 176 - HEALTH AND HUMAN SERVICES Run by Ashley King on 10/27/2016 10:47:47 AM Page 4 of 48 Sept YTD 2016 2016 Actual 1,000,000 1,000,000 - 1,000,000 1,000,000 - 41,667 375,000 - 41,667 375,000 - 1,000,000 1,000,000 - 41,667 375,000 - 958,333 625,000 - Starting Fund Balance - - Net Change - 625,000 Ending Fund Balance - 625,000 REVENUE TOTALS 1,000,000 EXPENSE TOTALS 1,000,000 Fund 180 - GOOD NEIGHBOR FUND Totals - 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 Monthly Financial Report Through 09/30/16 2016 Classification Budget Fund 180 - GOOD NEIGHBOR FUND 2015 Actual Run by Ashley King on 10/27/2016 10:47:47 AM Page 5 of 48 Sept YTD 2016 2016 Actual 66,405 6,063,705 5,916,852 - - 46,059 11,825 107,493 129,808 - - 171,000 - 60,418 181,283 8,784 39,106 286 7,444 119,185 315,924 422 3,596 2,683 94,880 6,393,503 6,763,897 332,055 3,054,959 4,062,199 238,469 1,147,839 1,425,484 156 37,755 299,628 33,547 294,902 810,678 - - - - - - - - - 20,833 187,500 250,000 7,523 67,704 81,468 632,582 4,790,659 6,929,456 94,880 6,393,503 6,763,897 632,582 4,790,659 6,929,456 (537,702) 1,602,844 (165,560) Starting Fund Balance 153,871 153,871 Net Change 20,015 1,602,844 Ending Fund Balance 173,886 1,756,715 EXPENSE TOTALS 6,997,142 Fund 185 - LIBRARY FUND Totals 20,015 2015 Actual EXPENSE TOTALS 6,997,142 Fund 185 - LIBRARY FUND Totals REVENUE TOTALS 7,017,157 Debt Service - Miscellaneous 250,000 Interfund Transfers 90,272 Insurance and Other Chargebacks 462,317 Depreciation Expense - Contingencies - 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 Monthly Financial Report Through 09/30/16 2016 Classification Budget Fund 185 - LIBRARY FUND Run by Ashley King on 10/27/2016 10:47:47 AM Page 6 of 48 Sept YTD 2016 2016 Actual 3,883 364,827 601,811 676,150 676,150 - 1 1 - 680,034 1,040,978 601,811 10,603 10,603 - - 41,447 - - 31,228 562,740 - - - 10,603 83,277 562,740 680,034 1,040,978 601,811 10,603 83,277 562,740 669,431 957,701 39,072 Starting Fund Balance 36,664 36,664 Net Change - 957,701 Ending Fund Balance 36,664 994,365 Fund 186 - LIBRARY DEBT SERVICE - 2015 Actual Fund 186 - LIBRARY DEBT SERVICE REVENUE TOTALS 393,409 EXPENSE TOTALS 393,409 Debt Service 393,409 Miscellaneous - EXPENSE TOTALS 393,409 REVENUE TOTALS 393,409 EXPENSE Services and Supplies - Capital Outlay - REVENUE Property Taxes 393,409 Other Revenue - Interest Income - Monthly Financial Report Through 09/30/16 2016 Classification Budget Fund 186 - LIBRARY DEBT SERVICE FUND Run by Ashley King on 10/27/2016 10:47:47 AM Page 7 of 48 Sept YTD 2016 2016 Actual - - - 25,145 61,420 130,126 - - - 19 166 - 25,164 61,586 130,126 1,688 16,223 54,159 - 6,060 4,611 - 36,275 68,352 344 3,048 6,847 - - - - 1,705 179 7,367 10,263 (4,022) 9,399 73,574 130,126 25,164 61,586 130,126 9,399 73,574 130,126 15,765 (11,989) - Starting Fund Balance - - Net Change (303) (11,989) Ending Fund Balance (303) (11,989) EXPENSE TOTALS 198,954 Fund 195 - NEIGHBORHOOD (303) 2015 Actual EXPENSE TOTALS 198,954 Fund 195 - NEIGHBORHOOD REVENUE TOTALS 198,651 Debt Service - Miscellaneous 120,862 Interfund Transfers 4,344 Services and Supplies 5,100 Capital Outlay 35,000 Insurance and Other Chargebacks 5,058 Interest Income - REVENUE TOTALS 198,651 EXPENSE Salary and Benefits 28,590 REVENUE Licenses, Permits and Fees - Intergovernmental Revenue 198,651 Other Revenue - Monthly Financial Report Through 09/30/16 2016 Classification Budget Fund 195 - NEIGHBORHOOD STABILIZATION FUND Run by Ashley King on 10/27/2016 10:47:47 AM Page 8 of 48 Sept YTD 2016 2016 Actual 161,837 1,411,147 2,465,781 - - - 610 4,809 819 - - - 162,447 1,415,956 2,466,600 - - - - 156,533 1,583,238 - - - - - - - - - 182,417 1,641,750 833,000 182,417 1,798,283 2,416,238 162,447 1,415,956 2,466,600 182,417 1,798,283 2,416,238 (19,969) (382,327) 50,362 Starting Fund Balance 1,830,393 1,830,393 Net Change (478,000) (382,327) Ending Fund Balance 1,352,393 1,448,066 Fund 200 - MOTOR FUEL TAX FUND Totals (478,000) 2015 Actual Fund 200 - MOTOR FUEL TAX FUND Totals REVENUE TOTALS 1,711,000 EXPENSE TOTALS 2,189,000 Miscellaneous - Interfund Transfers 2,189,000 EXPENSE TOTALS 2,189,000 Capital Outlay - Contingencies - Debt Service - Reappropriation of Surplus - REVENUE TOTALS 1,711,000 EXPENSE Services and Supplies - REVENUE Intergovernmental Revenue 1,710,000 Other Revenue - Interest Income 1,000 Monthly Financial Report Through 09/30/16 2016 Classification Budget Fund 200 - MOTOR FUEL TAX FUND Run by Ashley King on 10/27/2016 10:47:47 AM Page 9 of 48 Sept YTD 2016 2016 Actual 115,899 652,091 977,071 - - - - - 100 197 1,759 189 116,096 653,850 977,361 40,626 369,340 505,437 30,697 242,784 347,694 48,705 213,805 239,421 7,891 70,124 96,132 - - - - - 2,046 - - - - - 1,500 11,851 106,655 141,767 139,770 1,002,708 1,333,996 116,096 653,850 977,361 139,770 1,002,708 1,333,996 (23,675) (348,859) (356,635) Starting Fund Balance 551,718 551,718 Net Change (497,643) (348,859) Ending Fund Balance 54,075 202,860 Fund 205 - EMERGENCY TELEPHONE (497,643) 2015 Actual Fund 205 - EMERGENCY TELEPHONE REVENUE TOTALS 1,019,000 EXPENSE TOTALS 1,516,643 Miscellaneous - Interfund Transfers 142,207 EXPENSE TOTALS 1,516,643 Community Sponsored Organizations - Contingencies 5,000 Debt Service - Services and Supplies 377,600 Capital Outlay 393,615 Insurance and Other Chargebacks 94,946 Interest Income 1,000 REVENUE TOTALS 1,019,000 EXPENSE Salary and Benefits 503,275 REVENUE Other Taxes 1,018,000 Intergovernmental Revenue - Other Revenue - Monthly Financial Report Through 09/30/16 2016 Classification Budget Fund 205 - EMERGENCY TELEPHONE (E911) FUND Run by Ashley King on 10/27/2016 10:47:47 AM Page 10 of 48 Sept YTD 2016 2016 Actual 2,829 321,192 322,055 1 2 3 2,830 321,194 322,058 80,750 242,250 323,000 - - - - - - 80,750 242,250 323,000 2,830 321,194 322,058 80,750 242,250 323,000 (77,920) 78,944 (942) Starting Fund Balance (190,544) (190,544) Net Change - 78,944 Ending Fund Balance (190,544) (111,600) EXPENSE TOTALS 320,000 Fund 210 - SPECIAL SERVICE AREA (SSA) - 2015 Actual EXPENSE TOTALS 320,000 Fund 210 - SPECIAL SERVICE AREA (SSA) REVENUE TOTALS 320,000 EXPENSE Services and Supplies 320,000 Debt Service - Miscellaneous - REVENUE Property Taxes 320,000 Interest Income - REVENUE TOTALS 320,000 Monthly Financial Report Through 09/30/16 2016 Classification Budget Fund 210 - SPECIAL SERVICE AREA (SSA) #4 Run by Ashley King on 10/27/2016 10:47:47 AM Page 11 of 48 Sept YTD 2016 2016 Actual - - - - - - 198,367 803,016 1,502,924 - 10,197 3,318 - - - 198,367 813,213 1,506,242 31,817 300,562 318,743 22 4,554 28,988 - 185,245 276,834 5,685 52,095 58,583 - 85,692 235,459 - - - - - - 767 84,222 72,442 186,166 186,871 455,310 224,457 899,241 1,446,359 198,367 813,213 1,506,242 224,457 899,241 1,446,359 (26,090) (86,028) 59,883 Starting Fund Balance 59,882 59,882 Net Change 375 (86,028) Ending Fund Balance 60,257 (26,146) EXPENSE TOTALS 2,594,625 Fund 215 - CDBG FUND Totals 375 2015 Actual EXPENSE TOTALS 2,594,625 Fund 215 - CDBG FUND Totals REVENUE TOTALS 2,595,000 Debt Service - Miscellaneous 1,274,280 Interfund Transfers 843,465 Insurance and Other Chargebacks 87,795 Community Sponsored Organizations - Contingencies - EXPENSE Salary and Benefits 385,285 Services and Supplies 3,800 Capital Outlay - Other Revenue - Interest Income - REVENUE TOTALS 2,595,000 REVENUE Charges for Services - Interfund Transfers - Intergovernmental Revenue 2,595,000 Monthly Financial Report Through 09/30/16 2016 Classification Budget Fund 215 - CDBG FUND Run by Ashley King on 10/27/2016 10:47:47 AM Page 12 of 48 Sept YTD 2016 2016 Actual - - - 4,415 74,198 397,708 25 4,571 375 4,440 78,770 398,083 - - - 15,645 79,497 280,461 - 57,880 1,919 - - - 15,645 137,377 282,380 4,440 78,770 398,083 15,645 137,377 282,380 (11,205) (58,607) 115,703 Starting Fund Balance 158,365 158,365 Net Change - (58,607) Ending Fund Balance 158,365 99,758 Fund 220 - CDBG LOAN Totals - 2015 Actual Fund 220 - CDBG LOAN Totals REVENUE TOTALS 350,000 EXPENSE TOTALS 350,000 Miscellaneous 10,000 Interfund Transfers - EXPENSE TOTALS 350,000 REVENUE TOTALS 350,000 EXPENSE Salary and Benefits - Services and Supplies 340,000 REVENUE Intergovernmental Revenue - Other Revenue 350,000 Interest Income - Monthly Financial Report Through 09/30/16 2016 Classification Budget Fund 220 - CDBG LOAN Run by Ashley King on 10/27/2016 10:47:47 AM Page 13 of 48 Sept YTD 2016 2016 Actual 55,774 1,543,470 2,116,843 35,625 35,625 - - - - - 238,726 49,000 119 8,327 128 91,518 1,826,149 2,165,971 43,496 386,849 537,286 94,479 276,086 302,867 12,377 215,521 194,941 6,307 54,137 80,941 - - - - - - - - - - 97,966 1,419,643 72,110 648,988 614,782 228,769 1,679,547 3,150,460 91,518 1,826,149 2,165,971 228,769 1,679,547 3,150,460 (137,251) 146,601 (984,489) Starting Fund Balance 2,555,982 2,555,982 Net Change (286,099) 146,601 Ending Fund Balance 2,269,883 2,702,583 EXPENSE TOTALS 2,548,699 Fund 225 - ECONOMIC DEVELOPMENT (286,099) 2015 Actual EXPENSE TOTALS 2,548,699 Fund 225 - ECONOMIC DEVELOPMENT REVENUE TOTALS 2,262,600 Debt Service - Miscellaneous 16,000 Interfund Transfers 615,322 Insurance and Other Chargebacks 104,871 Community Sponsored Organizations - Contingencies - 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 - Monthly Financial Report Through 09/30/16 2016 Classification Budget Fund 225 - ECONOMIC DEVELOPMENT FUND Run by Ashley King on 10/27/2016 10:47:47 AM Page 14 of 48 Sept YTD 2016 2016 Actual - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Starting Fund Balance 169,915 169,915 Net Change (80,000) - Ending Fund Balance 89,915 169,915 EXPENSE TOTALS 100,000 Fund 235 - NEIGHBORHOOD (80,000) 2015 Actual EXPENSE TOTALS 100,000 Fund 235 - NEIGHBORHOOD REVENUE TOTALS 20,000 Debt Service - Miscellaneous 100,000 Interfund Transfers - REVENUE TOTALS 20,000 EXPENSE Services and Supplies - Capital Outlay - REVENUE Other Taxes 20,000 Interfund Transfers - Interest Income - Monthly Financial Report Through 09/30/16 2016 Classification Budget Fund 235 - NEIGHBORHOOD IMPROVEMENT Run by Ashley King on 10/27/2016 10:47:47 AM Page 15 of 48 Sept YTD 2016 2016 Actual 43,154 167,145 465,961 2,407 20,538 6,402 2 10 19 45,563 187,693 472,382 3,001 21,765 12,388 - 122,245 282,753 - - - 378 2,781 1,368 - - - - - - - - 193,931 - - 26,990 3,379 146,790 517,430 45,563 187,693 472,382 3,379 146,790 517,430 42,184 40,903 (45,048) Starting Fund Balance 4,770 4,770 Net Change - 40,903 Ending Fund Balance 4,770 45,673 EXPENSE TOTALS 402,168 Fund 240 - HOME FUND Totals - 2015 Actual EXPENSE TOTALS 402,168 Fund 240 - HOME FUND Totals REVENUE TOTALS 402,168 Debt Service - Miscellaneous 500 Interfund Transfers - Capital Outlay - Insurance and Other Chargebacks 820 Community Sponsored Organizations - 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 - Monthly Financial Report Through 09/30/16 2016 Classification Budget Fund 240 - HOME FUND Run by Ashley King on 10/27/2016 10:47:47 AM Page 16 of 48 Sept YTD 2016 2016 Actual 10,000 56,667 100,000 - - - - - - 556 176,860 125,150 111 990 111 10,666 234,517 225,261 3,001 21,765 - 201 201 98 - - - 309 2,166 - - 735 - - - - 40,625 130,819 214,752 - - - 44,136 155,684 214,851 10,666 234,517 225,261 44,136 155,684 214,851 (33,470) 78,833 10,411 Starting Fund Balance 993,880 993,880 Net Change (313,719) 78,833 Ending Fund Balance 680,161 1,072,713 Fund 250 - AFFORDABLE HOUSING FUND (313,719) 2015 Actual Fund 250 - AFFORDABLE HOUSING FUND REVENUE TOTALS 160,628 EXPENSE TOTALS 474,347 Miscellaneous 76,000 Interfund Transfers - EXPENSE TOTALS 474,347 Insurance and Other Chargebacks - Community Sponsored Organizations - Debt Service - EXPENSE Salary and Benefits 48,347 Services and Supplies 350,000 Capital Outlay - Other Revenue 130,400 Interest Income 228 REVENUE TOTALS 160,628 REVENUE Other Taxes 30,000 Interfund Transfers - Intergovernmental Revenue - Monthly Financial Report Through 09/30/16 2016 Classification Budget Fund 250 - AFFORDABLE HOUSING FUND Run by Ashley King on 10/27/2016 10:47:47 AM Page 17 of 48 Sept YTD 2016 2016 Actual 38,549 4,718,214 4,921,484 - - - - - - - - - 1,536 9,626 3,530 40,085 4,727,840 4,925,014 - - - 1,813 2,028 1,408 - 4,473 198,823 - - 574,976 - 49,338 110,310 338,481 3,046,326 3,265,296 340,293 3,102,166 4,150,811 40,085 4,727,840 4,925,014 340,293 3,102,166 4,150,811 (300,208) 1,625,674 774,203 Starting Fund Balance 6,442,430 6,442,430 Net Change (2,640,683) 1,625,674 Ending Fund Balance 3,801,747 8,068,104 EXPENSE TOTALS 7,787,683 Fund 300 - WASHINGTON NATIONAL TIF (2,640,683) 2015 Actual EXPENSE TOTALS 7,787,683 Fund 300 - WASHINGTON NATIONAL TIF REVENUE TOTALS 5,147,000 Debt Service - Miscellaneous 500,000 Interfund Transfers 6,287,683 EXPENSE Salary and Benefits - Services and Supplies 1,000,000 Capital Outlay - Other Revenue - Interest Income 2,000 REVENUE TOTALS 5,147,000 REVENUE Property Taxes 5,145,000 Other Taxes - Interfund Transfers - Monthly Financial Report Through 09/30/16 2016 Classification Budget Fund 300 - WASHINGTON NATIONAL TIF FUND Run by Ashley King on 10/27/2016 10:47:47 AM Page 18 of 48 Sept YTD 2016 2016 Actual - 287,825 422,527 - - - - - - - 35 4 - 287,860 422,531 - - - - 17,250 297,150 - - - - 17,250 297,150 - 287,860 422,531 - 17,250 297,150 - 270,610 125,381 Starting Fund Balance 525,429 525,429 Net Change (467,971) 270,610 Ending Fund Balance 57,458 796,039 Fund 305 - SPECIAL SERVICE AREA (SSA) (467,971) 2015 Actual Fund 305 - SPECIAL SERVICE AREA (SSA) REVENUE TOTALS 300 EXPENSE TOTALS 468,271 Debt Service 416,872 Miscellaneous - EXPENSE TOTALS 468,271 Interest Income 300 REVENUE TOTALS 300 EXPENSE Services and Supplies 51,399 REVENUE Property Taxes - Interfund Transfers - Other Revenue - Monthly Financial Report Through 09/30/16 2016 Classification Budget Fund 305 - SPECIAL SERVICE AREA (SSA) #5 Run by Ashley King on 10/27/2016 10:47:47 AM Page 19 of 48 Sept YTD 2016 2016 Actual - 1,233,675 1,248,231 - - - 225 1,629 1,985 225 1,235,304 1,250,216 1,813 2,028 1,158 633,419 939,934 11,402 - - - - - - - 129,192 2,162,381 146,038 1,314,338 148,010 781,269 2,385,491 2,322,950 225 1,235,304 1,250,216 781,269 2,385,491 2,322,950 (781,044) (1,150,186) (1,072,734) Starting Fund Balance 1,281,115 1,281,115 Net Change (650,450) (1,150,186) Ending Fund Balance 630,665 130,929 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 - Debt Service - Miscellaneous 200,000 REVENUE TOTALS 1,302,000 EXPENSE Services and Supplies - Capital Outlay - REVENUE Property Taxes 1,300,000 Other Revenue - Interest Income 2,000 Monthly Financial Report Through 09/30/16 2016 Classification Budget Fund 310 - HOWARD-HARTREY TIF 2015 Actual Run by Ashley King on 10/27/2016 10:47:47 AM Page 20 of 48 Sept YTD 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 - 2015 Actual Fund 315 - SOUTHWEST TIF FUND Totals REVENUE TOTALS - EXPENSE TOTALS - Miscellaneous - Interfund Transfers - EXPENSE TOTALS - EXPENSE Services and Supplies - Capital Outlay - Debt Service - REVENUE Property Taxes - Interest Income - REVENUE TOTALS - Monthly Financial Report Through 09/30/16 2016 Classification Budget Fund 315 - SOUTHWEST TIF FUND Run by Ashley King on 10/27/2016 10:47:47 AM Page 21 of 48 Sept YTD 2016 2016 Actual 106,723 10,328,133 11,156,231 232,861 2,096,279 1,642,654 8,211,196 8,211,196 12,278,473 3,197 17,945 7,668 8,553,976 20,653,553 25,085,026 74,553 77,328 171,576 - 4,159,452 24,358,022 - - 3,062 - - - 74,553 4,236,780 24,532,661 8,553,976 20,653,553 25,085,026 74,553 4,236,780 24,532,661 8,479,424 16,416,774 552,365 Starting Fund Balance 2,596,116 2,596,116 Net Change (2,751,668) 16,416,774 Ending Fund Balance (155,552) 19,012,890 EXPENSE TOTALS 16,279,452 Fund 320 - DEBT SERVICE FUND Totals (2,751,668) 2015 Actual EXPENSE TOTALS 16,279,452 Fund 320 - DEBT SERVICE FUND Totals REVENUE TOTALS 13,527,784 Debt Service 15,963,682 Miscellaneous - Interfund Transfers - 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 - Monthly Financial Report Through 09/30/16 2016 Classification Budget Fund 320 - DEBT SERVICE FUND Run by Ashley King on 10/27/2016 10:47:47 AM Page 22 of 48 Sept YTD 2016 2016 Actual - 528,905 540,576 21,966 108,926 64,176 46 332 1,815 22,012 638,163 606,568 645 316,755 587,839 - - (6,275) - - - - - - 63 505 585 - - 350 40,625 80,625 107,500 41,332 397,884 689,999 22,012 638,163 606,568 41,332 397,884 689,999 (19,320) 240,279 (83,431) Starting Fund Balance (28,621) (28,621) Net Change 24,000 240,279 Ending Fund Balance (4,621) 211,658 Fund 330 - HOWARD-RIDGE TIF FUND 24,000 2015 Actual Fund 330 - HOWARD-RIDGE TIF FUND REVENUE TOTALS 1,670,100 EXPENSE TOTALS 1,646,100 Miscellaneous - Interfund Transfers 107,500 EXPENSE TOTALS 1,646,100 Insurance and Other Chargebacks - Community Sponsored Organizations - 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 Monthly Financial Report Through 09/30/16 2016 Classification Budget Fund 330 - HOWARD-RIDGE TIF FUND Run by Ashley King on 10/27/2016 10:47:47 AM Page 23 of 48 Sept YTD 2016 2016 Actual - - - 1,028 8,226 - 166 1,208 257 1,194 9,435 257 - 507 1,158 - (1,028) (11,205) - - - - - - 770 6,203 7,185 - - 1,227 2,500 22,500 60,000 3,270 28,181 58,365 1,194 9,435 257 3,270 28,181 58,365 (2,076) (18,747) (58,107) Starting Fund Balance 442,263 442,263 Net Change (39,850) (18,747) Ending Fund Balance 402,413 423,516 Fund 335 - WEST EVANSTON TIF FUND (39,850) 2015 Actual 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 - REVENUE Property Taxes - Other Revenue - Interest Income 150 Monthly Financial Report Through 09/30/16 2016 Classification Budget Fund 335 - WEST EVANSTON TIF FUND Run by Ashley King on 10/27/2016 10:47:47 AM Page 24 of 48 Sept YTD 2016 2016 Actual - - - - - 2,000,000 - - 2,000,000 - - - - - 2,000,000 - - - - - 2,000,000 - - 2,000,000 - - 2,000,000 - - - Starting Fund Balance - - Net Change 10,000 - Ending Fund Balance 10,000 - EXPENSE TOTALS 40,000 Fund 340 - DEMPSTER-DODGE TIF FUND 10,000 2015 Actual EXPENSE TOTALS 40,000 Fund 340 - DEMPSTER-DODGE TIF FUND REVENUE TOTALS 50,000 EXPENSE Services and Supplies - Capital Outlay - Debt Service 40,000 REVENUE Property Taxes - Other Revenue 50,000 REVENUE TOTALS 50,000 Monthly Financial Report Through 09/30/16 2016 Classification Budget Fund 340 - DEMPSTER-DODGE TIF FUND Run by Ashley King on 10/27/2016 10:47:47 AM Page 25 of 48 Sept YTD 2016 2016 Actual - - - - 580,000 900,000 - 580,000 900,000 - 1,408 - - 580,000 580,000 4,466 31,564 7,930 4,466 612,972 587,930 - 580,000 900,000 4,466 612,972 587,930 (4,466) (32,972) 312,070 Starting Fund Balance 312,070 312,070 Net Change 31,500 (32,972) Ending Fund Balance 343,570 279,098 EXPENSE TOTALS 43,500 Fund 345 - CHICAGO-MAIN TIF Totals 31,500 2015 Actual EXPENSE TOTALS 43,500 Fund 345 - CHICAGO-MAIN TIF Totals REVENUE TOTALS 75,000 EXPENSE Services and Supplies - Capital Outlay - Debt Service 43,500 REVENUE Property Taxes 75,000 Other Revenue - REVENUE TOTALS 75,000 Monthly Financial Report Through 09/30/16 2016 Classification Budget Fund 345 - CHICAGO-MAIN TIF Run by Ashley King on 10/27/2016 10:47:47 AM Page 26 of 48 Sept YTD 2016 2016 Actual 2,285 221,812 - 0 1 - 2,285 221,813 - - - - - - - - - - 2,285 221,813 - - - - 2,285 221,813 - Starting Fund Balance - - Net Change 10,500 221,813 Ending Fund Balance 10,500 221,813 Fund 350 - SPECIAL SERVICE AREA (SSA) 10,500 2015 Actual Fund 350 - SPECIAL SERVICE AREA (SSA) REVENUE TOTALS 210,500 EXPENSE TOTALS 200,000 EXPENSE Services and Supplies 200,000 Interfund Transfers - EXPENSE TOTALS 200,000 REVENUE Property Taxes 210,000 Interest Income 500 REVENUE TOTALS 210,500 Monthly Financial Report Through 09/30/16 2016 Classification Budget Fund 350 - SPECIAL SERVICE AREA (SSA) #6 Run by Ashley King on 10/27/2016 10:47:47 AM Page 27 of 48 Sept YTD 2016 2016 Actual 15,603 92,289 87,391 331,750 2,985,750 - - 1,527,914 270,268 9,347,683 9,591,936 7,945,481 1,460 8,814 3,815 9,696,496 14,206,703 8,306,954 - - - 347,977 728,097 643,510 1,283,877 3,659,226 9,794,396 - - - - - 32,933 - - 490,000 1,631,854 4,387,323 10,960,839 9,696,496 14,206,703 8,306,954 1,631,854 4,387,323 10,960,839 8,064,642 9,819,380 (2,653,885) Starting Fund Balance 5,517,041 5,517,041 Net Change (2,209,000) 9,819,380 Ending Fund Balance 3,308,041 15,336,421 EXPENSE TOTALS 22,769,615 Fund 415 - CAPITAL IMPROVEMENTS (2,209,000) 2015 Actual EXPENSE TOTALS 22,769,615 Fund 415 - CAPITAL IMPROVEMENTS REVENUE TOTALS 20,560,615 Debt Service - Miscellaneous - Interfund Transfers 490,000 EXPENSE Salary and Benefits - Services and Supplies 2,256,962 Capital Outlay 20,022,653 Other Revenue 9,248,000 Interest Income - REVENUE TOTALS 20,560,615 REVENUE Charges for Services - Interfund Transfers 6,471,000 Intergovernmental Revenue 4,841,615 Monthly Financial Report Through 09/30/16 2016 Classification Budget Fund 415 - CAPITAL IMPROVEMENTS FUND Run by Ashley King on 10/27/2016 10:47:47 AM Page 28 of 48 Sept YTD 2016 2016 Actual - - - - - - - - - - - - - - - - - - - - - 513,349 513,349 243,113 - - - - - - - - - 643 24,630 24,832 712 121,606 125,218 - - - 514,704 659,584 393,163 - - - 7,503 7,516 1,879 - - 226,538 - - - - - - - - 534 30,058 270,523 - 37,562 278,039 228,951 514,704 659,584 393,163 37,562 278,039 228,951 477,142 381,545 164,213 Starting Fund Balance 2,682,781 2,682,781 Net Change 98,950 381,545 Ending Fund Balance 2,781,731 3,064,326 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 - 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 - REVENUE Property Taxes - Other Taxes - Licenses, Permits and Fees - Monthly Financial Report Through 09/30/16 2016 Classification Budget Fund 420 - SPECIAL ASSESSMENT FUND 2015 Actual Run by Ashley King on 10/27/2016 10:47:47 AM Page 29 of 48 Sept YTD 2016 2016 Actual - - - - - - 150 3,150 150 - - - 597,376 5,386,022 6,010,558 309,314 2,783,826 2,925,296 - - - 11,594 126,237 153,545 3,432 21,603 18,260 921,867 8,320,838 9,107,809 86,878 879,951 963,107 273,235 2,342,656 2,859,622 6,238 542,224 128,726 42,154 372,014 478,187 - - - - - 2,846,227 991 4,403 6,951 - 199,979 503,423 47,162 214,015 23,687 108,649 977,837 923,092 565,307 5,533,079 8,733,020 921,867 8,320,838 9,107,809 565,307 5,533,079 8,733,020 356,559 2,787,759 374,789 Starting Fund Balance 10,777,874 10,777,874 Net Change (6,615,186) 2,787,759 Ending Fund Balance 4,162,688 13,565,633 Fund 505 - PARKING SYSTEM FUND Totals (6,615,186) 2015 Actual Fund 505 - PARKING SYSTEM FUND Totals REVENUE TOTALS 10,322,856 EXPENSE TOTALS 16,938,042 Miscellaneous 252,000 Interfund Transfers 1,303,783 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 507,900 Community Sponsored Organizations - 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 - Charges for Services 6,444,675 Interfund Transfers 3,711,770 REVENUE Property Taxes - Other Taxes - Licenses, Permits and Fees - Monthly Financial Report Through 09/30/16 2016 Classification Budget Fund 505 - PARKING SYSTEM FUND Run by Ashley King on 10/27/2016 10:47:47 AM Page 30 of 48 Sept YTD 2016 2016 Actual - - - 6,513 71,716 105,483 2,798,326 13,835,820 15,308,225 950,000 7,947,244 2,721,993 - - - 3,763,382 3,839,371 350,065 1,713 11,201 3,982 7,519,935 25,705,352 18,489,749 345,801 3,223,726 3,927,752 520,888 2,000,271 2,303,346 972,018 6,478,847 750,269 91,313 823,645 1,131,508 - - - - - 2,096,633 - 658 933 - 373,518 432,628 - 10,543 (286,678) 1,241,859 10,573,979 6,045,149 3,171,879 23,485,187 16,401,539 7,519,935 25,705,352 18,489,749 3,171,879 23,485,187 16,401,539 4,348,056 2,220,165 2,088,210 Starting Fund Balance 9,223,203 9,223,203 Net Change (3,407,255) 2,220,165 Ending Fund Balance 5,815,948 11,443,368 EXPENSE TOTALS 41,125,255 Fund 510 - WATER FUND Totals (3,407,255) 2015 Actual EXPENSE 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,502,313 Community Sponsored Organizations - Depreciation Expense - Contingencies 1,000 Services and Supplies 6,155,950 Capital Outlay 24,776,106 Insurance and Other Chargebacks 1,114,195 Interest Income 1,600 REVENUE TOTALS 37,718,000 EXPENSE Salary and Benefits 4,459,423 Interfund Transfers - Intergovernmental Revenue - Other Revenue 22,348,400 REVENUE Other Taxes - Licenses, Permits and Fees 70,000 Charges for Services 15,298,000 Monthly Financial Report Through 09/30/16 2016 Classification Budget Fund 510 - WATER FUND Run by Ashley King on 10/27/2016 10:47:47 AM Page 31 of 48 Sept YTD 2016 2016 Actual 1,150,522 10,067,611 12,510,940 - - - - 554,863 2,962 183 3,003 2,706 1,150,705 10,625,477 12,516,607 69,448 716,393 892,099 18,604 276,509 108,927 - 723,144 13,609 33,886 306,258 412,461 - - 3,443,723 - - - 1,859,821 6,677,246 1,550,407 - 5,000 3,306 64,489 580,405 735,235 2,046,248 9,284,954 7,159,766 1,150,705 10,625,477 12,516,607 2,046,248 9,284,954 7,159,766 (895,543) 1,340,523 5,356,842 Starting Fund Balance 4,012,808 4,012,808 Net Change (1,607,486) 1,340,523 Ending Fund Balance 2,405,322 5,353,331 Fund 515 - SEWER FUND Totals (1,607,486) 2015 Actual Fund 515 - SEWER FUND Totals REVENUE TOTALS 13,873,815 EXPENSE TOTALS 15,481,301 Miscellaneous 1,500 Interfund Transfers 773,876 EXPENSE TOTALS 15,481,301 Depreciation Expense - Contingencies - Debt Service 9,222,913 Services and Supplies 995,800 Capital Outlay 3,048,314 Insurance and Other Chargebacks 414,439 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 - Other Revenue 984,165 Monthly Financial Report Through 09/30/16 2016 Classification Budget Fund 515 - SEWER FUND Run by Ashley King on 10/27/2016 10:47:47 AM Page 32 of 48 Sept YTD 2016 2016 Actual 43,470 125,404 213,490 306,709 2,678,099 3,561,584 87,997 791,975 1,055,967 - - - 24,434 86,459 228,469 - - - 462,610 3,681,938 5,059,510 58,421 526,845 600,068 470,714 2,580,466 3,717,885 - 2,664 24,738 11,805 101,478 249,232 - - - - - - - - - - 1,144 68,419 - 12,232 - 41,624 374,620 490,106 582,564 3,599,449 5,150,448 462,610 3,681,938 5,059,510 582,564 3,599,449 5,150,448 (119,954) 82,489 (90,938) Starting Fund Balance (1,228,557) (1,228,557) Net Change 60,844 82,489 Ending Fund Balance (1,167,713) (1,146,068) Fund 520 - SOLID WASTE FUND Totals 60,844 2015 Actual 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 - Contingencies - Debt Service - Capital Outlay 25,750 Insurance and Other Chargebacks 129,690 Community Sponsored Organizations - REVENUE TOTALS 5,201,361 EXPENSE Salary and Benefits 738,408 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 Monthly Financial Report Through 09/30/16 2016 Classification Budget Fund 520 - SOLID WASTE FUND Run by Ashley King on 10/27/2016 10:47:47 AM Page 33 of 48 Sept YTD 2016 2016 Actual 282,301 2,540,777 3,289,009 - - - - - - 910 9,487 46,933 - - - 283,211 2,550,264 3,335,942 62,394 602,914 961,887 282,545 1,274,221 1,686,117 - - - 10,593 123,729 175,716 - - - - - - - - - - - - 2,230 20,071 25,820 357,762 2,020,936 2,849,539 283,211 2,550,264 3,335,942 357,762 2,020,936 2,849,539 (74,551) 529,328 486,403 Starting Fund Balance 365,460 365,460 Net Change (244,277) 529,328 Ending Fund Balance 121,183 894,788 EXPENSE TOTALS 3,644,146 Fund 600 - FLEET SERVICES FUND Totals (244,277) 2015 Actual EXPENSE TOTALS 3,644,146 Fund 600 - FLEET SERVICES FUND Totals REVENUE TOTALS 3,399,869 Debt Service - Miscellaneous - Interfund Transfers 26,762 Insurance and Other Chargebacks 184,136 Depreciation Expense - Contingencies 450 EXPENSE Salary and Benefits 1,052,741 Services and Supplies 2,380,057 Capital Outlay - Other Revenue 81,781 Interest Income 1,000 REVENUE TOTALS 3,399,869 REVENUE Charges for Services 3,317,088 Interfund Transfers - Intergovernmental Revenue - Monthly Financial Report Through 09/30/16 2016 Classification Budget Fund 600 - FLEET SERVICES FUND Run by Ashley King on 10/27/2016 10:47:47 AM Page 34 of 48 Sept YTD 2016 2016 Actual 121,255 1,091,406 1,451,422 - - - - 31,437 34,286 121,255 1,122,843 1,485,708 35,640 49,311 53,400 927 9,359 - - - 1,684,835 - - - 36,567 58,670 1,738,234 121,255 1,122,843 1,485,708 36,567 58,670 1,738,234 84,688 1,064,173 (252,527) Starting Fund Balance 1,277,689 1,277,689 Net Change 146,216 1,064,173 Ending Fund Balance 1,423,905 2,341,862 Fund 601 - EQUIPMENT REPLACEMENT 146,216 2015 Actual Fund 601 - EQUIPMENT REPLACEMENT REVENUE TOTALS 1,661,638 EXPENSE TOTALS 1,515,422 Depreciation Expense - Miscellaneous - 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 - Other Revenue 210,217 Monthly Financial Report Through 09/30/16 2016 Classification Budget Fund 601 - EQUIPMENT REPLACEMENT FUND Run by Ashley King on 10/27/2016 10:47:47 AM Page 35 of 48 Sept YTD 2016 2016 Actual 3,356 30,285 162,411 68 615 306,051 828,896 7,265,671 10,413,499 430 76,287 1,034,405 577,417 4,990,445 5,753,308 19 147 136 1,410,186 12,363,450 17,669,810 43,780 415,014 460,086 231,130 1,741,458 1,305,086 - - - 1,225,758 10,853,451 14,318,413 - - - - - - - - - - - - - 4,330 - 772 6,946 8,936 1,501,440 13,021,199 16,092,521 1,410,186 12,363,450 17,669,810 1,501,440 13,021,199 16,092,521 (91,254) (657,749) 1,577,289 Starting Fund Balance (364,496) (364,496) Net Change 565,405 (657,749) Ending Fund Balance 200,909 (1,022,245) Fund 605 - INSURANCE FUND Totals 565,405 2015 Actual Fund 605 - INSURANCE FUND Totals REVENUE TOTALS 17,758,038 EXPENSE TOTALS 17,192,633 Miscellaneous - Interfund Transfers 9,262 EXPENSE TOTALS 17,192,633 Depreciation Expense - Contingencies - Debt Service - Capital Outlay - Insurance and Other Chargebacks 15,378,608 Community Sponsored Organizations - 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 - Other Revenue 10,111,694 Monthly Financial Report Through 09/30/16 2016 Classification Budget Fund 605 - INSURANCE FUND Run by Ashley King on 10/27/2016 10:47:47 AM Page 36 of 48 Sept YTD 2016 2016 Actual 73,163 7,037,850 - 7,458 274,862 280,000 - - - 77,013 706,237 6,273,004 - 68 1,206,228 157,634 8,019,017 7,759,232 692,062 6,278,046 8,302,220 - - - - - - - - - - - - 692,062 6,278,046 8,302,220 157,634 8,019,017 7,759,232 692,062 6,278,046 8,302,220 (534,429) 1,740,970 (542,988) Starting Fund Balance 66,741,084 66,741,084 Net Change 4,297,865 1,740,970 Ending Fund Balance 71,038,949 68,482,054 Fund 700 - FIRE PENSION FUND Totals 4,297,865 2015 Actual Fund 700 - FIRE PENSION FUND Totals REVENUE TOTALS 12,460,865 EXPENSE TOTALS 8,163,000 Debt Service - Miscellaneous - EXPENSE TOTALS 8,163,000 EXPENSE Salary and Benefits 8,163,000 Services and Supplies - Community Sponsored Organizations - 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 - Monthly Financial Report Through 09/30/16 2016 Classification Budget Fund 700 - FIRE PENSION FUND Run by Ashley King on 10/27/2016 10:47:47 AM Page 37 of 48 Sept YTD 2016 2016 Actual 93,598 9,012,614 57,836 7,458 274,862 325,000 - - - 113,904 (1,294,362) 7,676,438 - 162,612 2,902,399 214,961 8,155,726 10,961,673 904,589 8,250,604 10,768,296 - - - - - - - - - 904,589 8,250,604 10,768,296 214,961 8,155,726 10,961,673 904,589 8,250,604 10,768,296 (689,628) (94,879) 193,377 Starting Fund Balance 98,558,837 98,558,837 Net Change 6,383,940 (94,879) Ending Fund Balance 104,942,777 98,463,958 REVENUE TOTALS 17,430,940 EXPENSE TOTALS 11,047,000 Fund 705 - POLICE PENSION FUND Totals 6,383,940 Miscellaneous - EXPENSE TOTALS 11,047,000 Fund 705 - POLICE PENSION FUND Totals EXPENSE Salary and Benefits 11,047,000 Services and Supplies - Debt Service - 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 - Monthly Financial Report Through 09/30/16 2016 Classification Budget Fund 705 - POLICE PENSION FUND 2015 Actual Run by Ashley King on 10/27/2016 10:47:47 AM Page 38 of 48