Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2015.11 November Monthly Report
To: Wally Bobkiewicz, City Manager Martin Lyons, Assistant City Manager/Chief Financial Officer From: Ashley King, Assistant Director of Administrative Services David Meimers, Accounting Manager Subject: November 2015 Monthly Financial Report Date: January 8, 2016 Please find attached the unaudited financial statements as of November 30, 2015. A summary by fund for revenues, expenditures, fund and cash balances is as follows: YTD Revenues YTD Expenses YTD Net Fund Balance Cash Balance 80,361,114 79,850,513 510,600 15,494,566 5,932,660 1,336,215 710,736 625,479 808,578 586,939 6,674,191 5,342,346 1,331,845 2,710,815 1,921,830 195,335 113,865 81,469 81,469 230,720 1,008,461 2,142,207 (1,133,746) 646,285 1,103,504 829,331 965,458 (136,127) 772,226 580,561 322,058 323,000 (942) 144,258 (190,544) 1,117,765 1,319,037 (201,272) (16,370) (448,736) 189,935 31,424 158,511 2,509,172 279,173 2,110,457 2,868,389 (757,932) 2,782,539 2,200,468 - - - 169,915 169,915 490,670 473,246 17,423 4,597,502 (30,736) 231,727 54,248 177,478 2,724,399 968,044 600,461 182,053 418,408 512,003 416,000 4,924,321 3,273,825 1,650,495 7,837,199 7,386,001 422,531 21,075 401,456 865,502 801,504 1,249,902 2,298,659 (1,048,757) 1,320,726 1,357,156 - 893,387 (893,387) 278 - 611,617 679,454 (67,836) 191,283 (11,092) 218 52,480 (52,262) 448,108 455,203 - - - - 2,900,000 2,295,064 604,936 604,936 604,936 24,853,121 3,783,652 21,069,468 24,866,255 11,795,833 8,499,765 7,584,966 914,799 9,085,725 9,572,059 358,015 228,417 129,598 2,648,167 2,644,096 8,895,775 6,910,665 1,985,110 14,799,827 14,520,950 20,490,202 16,057,340 4,432,862 11,886,969 9,668,006 12,274,195 11,820,282 453,913 4,859,850 2,832,938 4,768,572 4,379,218 389,354 (1,112,075) (1,236,070) 3,062,043 2,565,746 496,297 375,353 (199,322) 1,411,185 1,306,477 104,708 2,288,494 1,271,683 15,134,533 15,466,434 (331,901) (3,713,828) 1,229,138 TOTALS 205,323,713 173,993,664 31,330,049 111,190,125 76,412,818 Fund Fund Description 100 GENERAL FUND 175 GENERAL ASSISTANCE FUND 185 LIBRARY FUND 195 NEIGHBORHOOD STABILIZATION FUND 200 MOTOR FUEL TAX FUND 205 EMERGENCY TELEPHONE (E911) FUND 210 SPECIAL SERVICE AREA (SSA) #4 215 CDBG FUND 220 CDBG LOAN 225 ECONOMIC DEVELOPMENT FUND 235 NEIGHBORHOOD IMPROVEMENT 240 HOME FUND 250 AFFORDABLE HOUSING FUND 186 LIBRARY DEBT SERVICE FUND 300 WASHINGTON NATIONAL TIF FUND 305 SPECIAL SERVICE AREA (SSA) #5 310 HOWARD-HARTREY TIF 315 SOUTHWEST TIF FUND 330 HOWARD-RIDGE TIF FUND 335 WEST EVANSTON TIF FUND 340 DEMPSTER-DODGE TIF FUND 345 CHICAGO-MAIN TIF 320 DEBT SERVICE FUND 415 CAPITAL IMPROVEMENTS FUND 420 SPECIAL ASSESSMENT FUND 505 PARKING SYSTEM FUND 510 WATER FUND 515 SEWER FUND 520 SOLID WASTE FUND 600 FLEET SERVICES FUND 601 EQUIPMENT REPLACEMENT FUND 605 INSURANCE FUND Memorandum Included above are the ending balances as of November 30, 2015 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 may 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, 2015, the General Fund is reporting a net surplus of $510,600. This is primarily due to the timing of revenues. At this point, approximately 97% of property taxes have been received. As can be seen in the chart on page four of this memorandum, the General Fund expenditures are 87% of budget and revenues are 88% of budget. Both these numbers are below the 91.6% target for November. Through November 30, 2015, the Community Development Block Grant (CDBG) Fund is showing a negative cash balance of $448,736. This amount will be reimbursed from draw-downs from HUD during December. Through November 30, 2015, the Economic Development Fund is showing a fund balance of $2,782,539 and a cash balance of $2,200,468. Through November 30, 2015, the Howard-Hartrey TIF has $2.3 million in expenses during 2015 which is largely due to payments to the Auto Barn as a part of the development agreement in this TIF. Through November 30, 2015, the Debt Service Fund is showing $24.8 million in revenues due to the refinancing of the 2006B bonds. $11.4 of this amount will be in reserve to refund the 2006B bonds on January 1st. The Parking Fund (fund balance of $14,799,827) is above budget due to the transfer from the Washington National TIF for the Sherman Deck Bond payment (December 1st annually). Through November 30, 2015, the Solid Waste Fund is showing a negative fund balance of $1,112,075 and a negative cash balance of $1,236,070. Though operating at a surplus for the year, the Fleet Fund is showing a negative cash balance of $199,322 through November 30, 2015. The fund balance for the Fleet Fund is $375,353. This is a significant improvement over the end of 2014 fund balance of negative $113,833. Through November 30, 2015, the Insurance Fund is showing a negative fund balance of $3,713,828. This negative balance is primarily for claims/cases being expensed. These claims/cases have not been settled, a nd therefore there is no guarantee the City will actually experience this negative fund balance as estimated. The Insurance Fund’s cash balance of $1,229,138 includes transfers from the IPBC Health Insurance Pool. If there are any questions on the atta ched report, please contact me by phone at (847) 859-7884 or by email: aking@cityofevanston.org. Detailed fund summary reports can Budget November YTD Actual Amount 2014 Actual Property Taxes 11,637,118 75,653 11,397,034 98 11,547,828 Other Taxes 43,689,300 3,406,415 39,708,202 91 42,686,089 License 4,001,877 1,190,467 2,942,174 74 3,640,206 Permit 8,139,082 405,512 6,370,083 78 9,400,120 Fee 1,756,200 374,512 1,787,413 102 1,840,274 Fines and Forfeitures 4,495,774 313,581 3,255,811 72 3,357,965 Health Department Charges 47,027 132,697 282 416,946 Parking Charges for Services 640,000 0 641,667 Parks and Recreation Charges for 5,367,751 233,305 5,085,222 95 5,339,742 Other Charges for Services 1,692,616 114,490 1,504,240 89 1,536,216 Interfund Transfers 7,892,893 773,261 7,191,794 91 7,794,625 Intergovernmental Revenue 723,700 22,615 384,226 53 627,970 Other Revenue 1,311,343 33,297 596,339 45 1,362,838 Interest Income 50,000 877 5,879 12 13,037 91,444,681 6,943,985 80,361,114 87%90,205,523 427,044 30,814 364,950 85 450,773 249,979 21,145 242,810 97 259,908 1,903,126 107,312 1,528,667 80 1,911,831 1,129,534 76,721 907,716 80 1,060,790 10,371,388 711,224 8,292,014 80 8,382,105 2,427,257 213,675 2,078,582 86 2,627,186 27,745,569 2,253,480 25,175,620 91 28,272,128 14,462,599 1,107,082 13,007,119 90 14,806,150 3,658,702 235,949 2,882,732 79 3,030,175 18,048,955 1,279,418 15,472,123 86 18,454,528 10,836,161 699,746 9,898,180 91 12,350,340 91,260,314 6,736,566 79,850,513 87%91,605,914 91,444,681 6,943,985 80,361,114 88%90,205,523 91,260,314 6,736,566 79,850,513 87%91,605,914 Starting Fund Balance 14,983,966 14,983,966 Net Change 174,321 510,600 Ending Fund Balance 15,158,287 15,494,566 REVENUE TOTALS EXPENSE TOTALS REVENUES REVENUE TOTALS General Fund-- November 2015 26 PUBLIC WORKS 30 PARKS, REC. AND COMMUNITY SERV. EXPENSE TOTALS Grand Totals 22 POLICE 23 FIRE MGMT & SUPPORT 24 HEALTH 17 LAW 19 ADMINISTRATIVE SERVICES 21 COMMUNITY DEVELOPMENT 13 CITY COUNCIL 14 CITY CLERK 15 CITY MANAGER'S OFFICE EXPENSE Classification Fund Category Governmental Funds Fund Type GENERAL FUND Budget Amount Nov YTD % 2014 Actual 3,227,325 717,149 3,147,673 98 2,715,744 +++(48,660) 694,140 63,670 649,519 94 660,944 5,262,436 378,036 4,076,653 77 4,412,973 1,280,700 77,497 1,021,930 80 1,296,314 10,464,601 1,236,351 8,895,775 85%9,037,314 10,464,601 1,236,351 8,895,775 85%9,037,314 4,929,138 427,402 2,632,467 53 1,978,168 1,213,609 73,466 886,845 73 429,634 629,856 34,786 358,488 57 417,414 176,400 13,200 7 174,100 +++(140,642) 5,832,240 99,922 1,126,174 19 2,904,338 1,658,921 77,385 736,135 44 1,898,137 29,482 66,845 227 4,398 1,189,648 99,137 1,090,512 92 1,188,891 15,659,294 812,098 6,910,665 44%8,854,437 15,659,294 812,098 6,910,665 44%8,854,437 10,464,601 1,236,351 8,895,775 85%9,037,314 15,659,294 812,098 6,910,665 44%8,854,437 (5,194,693)424,253 1,985,110 (38%)182,877 Starting Fund Balance 12,814,717 12,814,717 Net Change (5,194,693) 1,985,110 Ending Fund Balance 7,620,024 14,799,827 Parking Fund-- November 2015 Fund 505 - PARKING SYSTEM FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund 505 - PARKING SYSTEM FUND Net 7039 2010B BONDS-PARKING DEBT SERV. 7050 TRANSFERS Department 19 - ADMINISTRATIVE EXPENSE TOTALS 7035 CHURCH/CHICAGO GARAGE 7036 SHERMAN GARAGE 7037 MAPLE GARAGE 7015 PARKING LOTS & METERS 7025 CHURCH STREET GARAGE 7030 PARKING GARAGE BONDS Department 19 - ADMINISTRATIVE REVENUE TOTALS EXPENSE Department 19 - ADMINISTRATIVE SERVICES 7005 PARKING SYSTEM MGT 7025 CHURCH STREET GARAGE 7036 SHERMAN GARAGE 7037 MAPLE GARAGE Fund 505 - PARKING SYSTEM FUND REVENUE Department 19 - ADMINISTRATIVE SERVICES 7005 PARKING SYSTEM MGT 7015 PARKING LOTS & METERS Organization Organization Description Fund Category Proprietary Funds Fund Type Enterprise Funds Budget Amount Nov YTD %2014 Actual 28,014,100 1,303,703 14,643,726 52 15,054,698 +++350 45,000 3,398 41,578 92 +++5,672 +++8,508 523 1,889 +++56 5,803,009 5,803,009 +++ 28,059,100 7,110,633 20,490,202 73%15,069,284 28,059,100 7,110,633 20,490,202 73%15,069,284 1,059,638 84,210 840,694 79 3,502,605 2,426,701 177,633 1,915,216 79 2,023,601 2,612,781 143,594 1,742,291 67 2,331,616 1,724,142 132,705 1,396,729 81 1,444,158 194,336 11,100 169,362 87 280,083 527,500 3,597 170,103 32 204,980 419,000 283,825 404,529 97 72,953 18,402,600 217,056 1 12,430 67,505 67,505 100 92,168 6,238 7 13,750 240,920 51,105 21 102,909 300,694 62,847 21 121,718 149,171 37,086 25 91,461 3,662,545 305,212 3,357,334 92 3,838,052 5,500,000 +++5,500,000 195,941 42,586 119,246 61 45,218 32,075,642 1,184,463 16,057,340 50%19,585,533 32,075,642 1,184,463 16,057,340 50%19,585,533 28,059,100 7,110,633 20,490,202 73%15,069,284 32,075,642 1,184,463 16,057,340 50%19,585,533 (4,016,542)5,926,170 4,432,862 (4,516,249) Starting Fund Balance 7,454,107 7,454,107 Net Change 32,075,642 4,432,862 Ending Fund Balance 39,529,749 11,886,969 EXPENSE TOTALS Grand Total Net Gain (Loss) Water Fund-- November 2015 Grand Totals REVENUE TOTALS 7165 TRANSFER TO DEP.,IMP.,EXT 7509 2014A BONDS Department 71 - UTILITIES Totals EXPENSE TOTALS 7150 2012A BONDS 7151 2013A BONDS 7160 INTERFUND TRANSFERS 7133 ARRA / IEPA LOAN DS (L173382) 7140 2010B BONDS 7145 2011A BONDS 7125 OTHER OPERATIONS 7130 WATER CAPITAL OUTLAY 7131 CAPITAL IMPROVEMENTS 7110 FILTRATION 7115 DISTRIBUTION 7120 WATER METER MAINTENANCE EXPENSE Department 71 - UTILITIES 7100 WATER GENERAL SUPPORT 7105 PUMPING 7300 WATER BOND AND INTEREST 7509 2014A BONDS Department 71 - UTILITIES Totals REVENUE TOTALS 7110 FILTRATION 7130 WATER CAPITAL OUTLAY 7131 CAPITAL IMPROVEMENTS Fund 510 - WATER FUND REVENUE Department 71 - UTILITIES 7100 WATER GENERAL SUPPORT 7105 PUMPING Organization Description Fund Category Proprietary Funds Fund Type Enterprise Funds Budget Amount Nov YTD %2014 Actual 13,077,865 1,197,996 12,034,886 92 12,770,136 239,309 +++18,150 13,077,865 1,197,996 12,274,195 94%12,788,286 13,077,865 1,197,996 12,274,195 94%12,788,286 1,779,750 138,782 1,481,409 83 5,113,395 103,300 26,406 26 23,879 818,608 68,217 750,391 92 622,316 13,500 - 11,249 83 2,821 1,055,000 60,730 1,070,406 101 208,204 +++(3,424) 80,000 40,028 80,057 100 11,000 0 24,551 1,662 7 3,663 49,772 10,558 21 21,260 317,397 317,397 100 23,318 +++3,206 100,015 50,008 50 4,773 301,552 150,776 50 14,390 542,998 542,998 100 36,626 259,925 129,962 50 19,227 342,348 342,348 100 32,324 280,621 280,621 100 26,800 360,906 360,907 100 41,843 545,202 272,601 50 75,063 401,678 401,678 100 49,059 132,000 132,000 100 17,882 153,733 153,733 100 20,011 254,850 22,425 9 53,520 13,389,635 1,292,051 11,820,282 88%7,645,350 13,077,865 1,197,996 12,274,195 94% 12,788,286 13,389,635 1,292,051 11,820,282 88% 7,645,350 (311,770) (94,055) 453,913 5,142,936 Starting Fund Balance 4,405,937 4,405,937 Net Change (311,770) 453,913 Ending Fund Balance 4,094,167 4,859,850 Grand Totals REVENUE TOTALS EXPENSE TOTALS Grand Total Net Gain (Loss) EXPENSE TOTALS 7585 IEPA PH 7G DS (L171126) 7590 2007 BONDS (1997)SEWER1 7570 IEPA PH 5C DS (L171068) 7575 IEPA PH 7A DS (L170892) 7580 IEPA PH 7E DS (L171069) 7555 IEPA PH 5A DS (L170890) 7560 IEPA PH 5B DS (L171067) 7565 IEPA PH 7 DS (L171130) 7540 IEPA PH 4C DS (L170967) 7545 IEPA PH 4A DS (L170889) 7550 IEPA PH 4D DS (L170968) 7525 IEPA PH 3B DS (L170951) 7530 IEPA PH 3A DS (L170930) 7535 IEPA PH 4B DS (L170966) 7478 IEPA (L 17-5240) 7511 2010B BONDS 7512 2011 A BONDS- SEWER DEBT SERV. 7420 SEWER IMPROVEMENTS 7425 LONG RANGE SEWER IMPROVE 7477 IEPA (L 174775) 7410 SEWER OTHER OPERATIONS 7411 INTERFUND TRANSFERS 7415 CAPITAL OUTLAY Department 71 - UTILITIES Totals REVENUE TOTALS EXPENSE Department 71 - UTILITIES 7400 SEWER MAINTENANCE REVENUE Department 71 - UTILITIES 7400 SEWER MAINTENANCE 7420 SEWER IMPROVEMENTS Organization Description Sewer Fund-- November 2015 Budget Amount Nov YTD % 2014 Actual 4,683,361 370,967 4,204,312 90 4,649,654 179,000 56,011 366,629 205 140,559 220,000 160,603 197,631 90 236,967 5,082,361 587,580 4,768,572 94%5,027,180 5,082,361 587,580 4,768,572 94%5,027,180 1,321 +++2,912 3,209,621 219,398 2,605,858 81 2,876,007 1,281,949 85,868 1,168,411 91 1,210,051 700,250 76,630 603,627 86 676,135 5,191,820 381,896 4,379,218 84%4,765,105 +++502 +++90,089 +++90,591 5,191,820 381,896 4,379,218 84%4,855,696 5,082,361 587,580 4,768,572 94%5,027,180 5,191,820 381,896 4,379,218 84%4,855,696 (109,459)205,684 389,354 171,484 Starting Fund Balance (1,112,075) (1,112,075) Net Change (109,459) 389,354 Ending Fund Balance (1,221,534) (722,720) REVENUE TOTALS EXPENSE TOTALS Fund 520 - SOLID WASTE FUND Net Gain 7690 RESIDENTIAL RECYCLING COL Department 71 - UTILITIES Totals EXPENSE TOTALS Fund 520 - SOLID WASTE FUND Totals 7695 YARD WASTE COLLECTION Department 26 - PUBLIC WORKS Totals Department 71 - UTILITIES 7685 REFUSE COLLECT & DISPOSAL 7651 GENRAL SUPPORT 7685 REFUSE COLLECT & DISPOSAL 7690 RESIDENTIAL RECYCLING COL 7695 YARD WASTE COLLECTION Department 26 - PUBLIC WORKS Totals REVENUE TOTALS EXPENSE Department 26 - PUBLIC WORKS REVENUE Department 26 - PUBLIC WORKS 7685 REFUSE COLLECT & DISPOSAL 7690 RESIDENTIAL RECYCLING COL Organization Organization Description Solid Waste Fund-- November 2015 2015 Nov-15 YTD 2014 Budget Transactions Transactions Actual 11,637,118 75,653 11,397,034 11,547,828 43,689,300 3,406,415 39,708,202 42,686,089 13,897,159 1,970,491 11,099,669 14,880,600 4,495,774 313,581 3,255,811 3,357,965 7,747,394 347,795 6,722,159 7,934,572 7,892,893 773,261 7,191,794 7,794,625 723,700 22,615 384,226 627,970 1,311,343 33,297 596,339 1,362,838 50,000 877 5,879 13,037 91,444,681 6,943,985 80,361,114 90,205,523 68,404,181 5,120,930 60,283,252 69,079,362 11,407,830 615,036 9,427,319 11,645,408 185,600 10,446 98,788 204,704 3,019,098 250,347 2,768,760 2,949,778 966,029 79,461 838,996 677,669 212,967 30,433 57,117 1,661,041 206,656 1,542,509 1,685,166 5,478,568 453,690 4,860,456 5,306,709 91,335,314 6,736,566 79,850,513 91,605,914 91,444,681 6,943,985 80,361,114 90,205,523 91,335,314 6,736,566 79,850,513 91,605,914 109,367 207,420 510,600 (1,400,391) Starting Fund Balance 14,983,966 14,983,966 Net Change 109,367 510,600 Ending Fund Balance 15,093,333 15,494,566 REVENUE TOTALS EXPENSE TOTALS Fund 100 - GENERAL FUND Totals Interfund Transfers EXPENSE TOTALS Fund 100 - GENERAL FUND Totals Contingencies Debt Service Miscellaneous Insurance and Other Chargebacks Community Sponsored Organizations Depreciation Expense EXPENSE Salary and Benefits Services and Supplies Capital Outlay Special Assessment Reappropriation of Surplus REVENUE TOTALS Insurance Library Revenue Interest Income Intergovernmental Revenue Other Revenue Workers Compensation and Liability Fines and Forfeitures Charges for Services Interfund Transfers REVENUE Property Taxes Other Taxes Licenses, Permits and Fees Budget by Organization Report Through 11/30/15 Prior Fiscal Year Activity Included Classification Fund 100 - GENERAL FUND Run by Ashley King on 01/06/2016 15:19:55 PM Page 1 of 49 2015 Nov-15 YTD 2014 Budget Transactions Transactions Actual 1,348,553 - 1,313,420 1,762,916 - - - - - - - - - - - - - - - - - - - - - - 3,208 1,992 25,000 2,265 19,534 491,066 - - - - - - - - - - - - 1,000 10 54 88 - - - - - - - - 1,374,553 2,275 1,336,215 2,256,061 215,319 16,633 156,596 146,369 1,155,050 41,138 549,515 694,669 - - - - - - - - - - - 105,445 - - - - - - - - - - - - - 40 4,625 1,308 - - - - 1,370,369 57,811 710,736 947,791 1,374,553 2,275 1,336,215 2,256,061 1,370,369 57,811 710,736 947,791 4,184 (55,537) 625,479 1,308,270 Starting Fund Balance 183,099 183,099 Net Change 1,370,369 625,479 Ending Fund Balance 1,553,468 808,578 REVENUE TOTALS EXPENSE TOTALS Fund 175 - GENERAL ASSISTANCE Interfund Transfers EXPENSE TOTALS Fund 175 - GENERAL ASSISTANCE Contingencies Debt Service Miscellaneous Insurance and Other Chargebacks Community Sponsored Organizations Depreciation Expense EXPENSE Salary and Benefits Services and Supplies Capital Outlay Special Assessment Reappropriation of Surplus REVENUE TOTALS Insurance Library Revenue Interest Income Intergovernmental Revenue Other Revenue Workers Compensation and Liability Fines and Forfeitures Charges for Services Interfund Transfers REVENUE Property Taxes Other Taxes Licenses, Permits and Fees Budget by Organization Report Through 11/30/15 Prior Fiscal Year Activity Included Classification Fund 175 - GENERAL ASSISTANCE FUND Run by Ashley King on 01/06/2016 15:19:55 PM Page 2 of 49 2015 Nov-15 YTD 2014 Budget Transactions Transactions Actual 884,794 73,733 811,061 884,794 73,733 811,061 859,153 191,764 823,611 859,153 191,764 823,611 884,794 73,733 811,061 859,153 191,764 823,611 25,641 (118,031)(12,549) Starting Fund Balance 0 - Net Change 25,641 (12,549) Ending Fund Balance 25,641 (12,549) Fund 176 - HEALTH AND HUMAN Fund 176 - HEALTH AND HUMAN REVENUE TOTALS EXPENSE TOTALS Community Sponsored Organizations Miscellaneous EXPENSE TOTALS REVENUE TOTALS EXPENSE Services and Supplies Capital Outlay REVENUE Charges for Services Interfund Transfers Intergovernmental Revenue Budget by Organization Report Through 11/30/15 Prior Fiscal Year Activity Included Classification Fund 176 - HEALTH AND HUMAN SERVICES Run by Ashley King on 01/06/2016 15:19:55 PM Page 3 of 49 2015 Nov-15 YTD 2014 Budget Transactions Transactions Actual 5,813,505 52,070 5,899,984 5,205,279 50,200 - - 50,200 156,000 10,623 175,884 157,637 - 56,921 145,096 94,962 171,000 - 171,000 199,315 94,177 - 93,108 97,108 - (11) 350 22,662 346,810 53,336 186,393 255,774 - 379 2,377 2,869 6,631,692 173,319 6,674,191 6,085,806 4,710,919 335,432 3,807,649 4,130,680 1,542,994 95,596 1,196,638 1,262,675 46,430 - 34,214 69,995 77,268 6,439 70,829 114,597 - - - - - - - - - - - - 250,000 20,833 229,167 210,000 4,081 350 3,850 4,081 6,631,692 458,649 5,342,346 5,792,028 6,631,692 173,319 6,674,191 6,085,806 6,631,692 458,649 5,342,346 5,792,028 - (285,331) 1,331,845 293,777 Starting Fund Balance 1,378,970 1,378,970 Net Change - 1,331,845 Ending Fund Balance 1,378,970 2,710,815 REVENUE TOTALS EXPENSE TOTALS Fund 185 - LIBRARY FUND Totals Interfund Transfers EXPENSE TOTALS Fund 185 - LIBRARY FUND Totals Contingencies Debt Service Miscellaneous Capital Outlay Insurance and Other Chargebacks Depreciation Expense REVENUE TOTALS EXPENSE Salary and Benefits Services and Supplies Other Revenue Library Revenue Interest Income Charges for Services Interfund Transfers Intergovernmental Revenue REVENUE Property Taxes Other Taxes Fines and Forfeitures Budget by Organization Report Through 11/30/15 Prior Fiscal Year Activity Included Classification Fund 185 - LIBRARY FUND Run by Ashley King on 01/06/2016 15:19:55 PM Page 4 of 49 2015 Nov-15 YTD 2014 Budget Transactions Transactions Actual 605,138 2,447 600,461 746,112 1,000 - - - 606,138 2,447 600,461 746,112 - - 14,550 - - 55,161 127,101 - 605,138 - 40,402 748,521 - - - - 605,138 55,161 182,053 748,521 606,138 2,447 600,461 746,112 605,138 55,161 182,053 748,521 1,000 (52,713) 418,408 (2,409) Starting Fund Balance 93,595 93,595 - Net Change 1,000 418,408 Ending Fund Balance 94,595 512,003 REVENUE TOTALS EXPENSE TOTALS Fund 186 - LIBRARY DEBT SERVICE Miscellaneous EXPENSE TOTALS Fund 186 - LIBRARY DEBT SERVICE EXPENSE Services and Supplies Capital Outlay Debt Service REVENUE Property Taxes Interest Income REVENUE TOTALS Budget by Organization Report Through 11/30/15 Prior Fiscal Year Activity Included Classification Fund 186 - LIBRARY DEBT SERVICE FUND Run by Ashley King on 01/06/2016 15:19:55 PM Page 5 of 49 2015 Nov-15 YTD 2014 Budget Transactions Transactions Actual - - - - - - 59,687 1,107,077 500,000 - 135,461 42,412 - 27 186 - 500,000 27 195,335 1,149,489 53,661 3,723 53,810 90,126 3,250 121 4,498 4,265 155,000 - 60,539 660,448 4,191 349 3,842 7,951 - - - - 159,994 - 180 339,920 7,500 (10,287) (9,004) 46,779 383,596 (6,093) 113,865 1,149,489 500,000 27 195,335 1,149,489 383,596 (6,093) 113,865 1,149,489 116,404 6,121 81,469 - Starting Fund Balance - - Net Change 116,404 81,469 Ending Fund Balance 116,404 81,469 EXPENSE TOTALS Fund 195 - NEIGHBORHOOD EXPENSE TOTALS Fund 195 - NEIGHBORHOOD REVENUE TOTALS Debt Service Miscellaneous Interfund Transfers Services and Supplies Capital Outlay Insurance and Other Chargebacks Interest Income REVENUE TOTALS EXPENSE Salary and Benefits REVENUE Licenses, Permits and Fees Intergovernmental Revenue Other Revenue Budget by Organization Report Through 11/30/15 Prior Fiscal Year Activity Included Classification Fund 195 - NEIGHBORHOOD STABILIZATION FUND Run by Ashley King on 01/06/2016 15:19:55 PM Page 6 of 49 2015 Nov-15 YTD 2014 Budget Transactions Transactions Actual - - - 322,396 1,750,000 - 1,007,793 1,871,619 - - - - 1,000 48 668 277 - - - - 1,751,000 48 1,008,461 2,194,292 - - - - 1,700,000 50,000 1,378,624 893,829 - - - - - - - - - - - - 833,000 69,417 763,583 833,000 2,533,000 119,417 2,142,207 1,726,829 1,751,000 48 1,008,461 2,194,292 2,533,000 119,417 2,142,207 1,726,829 (782,000) (119,368) (1,133,746) 467,463 Starting Fund Balance 1,780,031 1,780,031 Net Change (782,000) (1,133,746) Ending Fund Balance 998,031 646,285 EXPENSE TOTALS Fund 200 - MOTOR FUEL TAX FUND EXPENSE TOTALS Fund 200 - MOTOR FUEL TAX FUND REVENUE TOTALS Debt Service Miscellaneous Interfund Transfers EXPENSE Services and Supplies Capital Outlay Contingencies Interest Income Reappropriation of Surplus REVENUE TOTALS REVENUE Charges for Services Intergovernmental Revenue Other Revenue Budget by Organization Report Through 11/30/15 Prior Fiscal Year Activity Included Classification Fund 200 - MOTOR FUEL TAX FUND Run by Ashley King on 01/06/2016 15:19:55 PM Page 7 of 49 2015 Nov-15 YTD 2014 Budget Transactions Transactions Actual 1,038,239 62,962 829,044 939,451 - - - - - - 100 1,751 1,000 0 187 99 1,039,239 62,962 829,331 941,302 559,058 46,602 507,877 512,750 653,661 12,642 312,640 346,506 40,000 - (4,552) 238,052 12,038 1,003 11,035 11,622 - - - - 5,000 - 2,046 - - - - - - 1,500 1,500 1,500 147,177 12,265 134,912 143,398 1,416,934 74,012 965,458 1,253,827 1,039,239 62,962 829,331 941,302 1,416,934 74,012 965,458 1,253,827 (377,695) (11,050) (136,127) (312,526) Starting Fund Balance 908,353 908,353 Net Change (136,734) (136,127) Ending Fund Balance 771,619 772,226 Fund 205 - EMERGENCY TELEPHONE Fund 205 - EMERGENCY TELEPHONE REVENUE TOTALS EXPENSE TOTALS Miscellaneous Interfund Transfers EXPENSE TOTALS Community Sponsored Organizations Contingencies Debt Service Services and Supplies Capital Outlay Insurance and Other Chargebacks Interest Income REVENUE TOTALS EXPENSE Salary and Benefits REVENUE Licenses, Permits and Fees Charges for Services Other Revenue Budget by Organization Report Through 11/30/15 Prior Fiscal Year Activity Included Classification Fund 205 - EMERGENCY TELEPHONE (E911) FUND Run by Ashley King on 01/06/2016 15:19:55 PM Page 8 of 49 2015 Nov-15 YTD 2014 Budget Transactions Transactions Actual 320,000 - 322,055 310,595 - - 3 4 320,000 - 322,058 310,599 320,000 80,750 323,000 320,000 - - - - - - - - 320,000 80,750 323,000 320,000 320,000 - 322,058 310,599 320,000 80,750 323,000 320,000 - (80,750) (942) (9,401) Starting Fund Balance 145,200 145,200 Net Change - (942) Ending Fund Balance 145,200 144,258 EXPENSE TOTALS Fund 210 - SPECIAL SERVICE AREA EXPENSE TOTALS Fund 210 - SPECIAL SERVICE AREA REVENUE TOTALS EXPENSE Services and Supplies Debt Service Miscellaneous REVENUE Property Taxes Interest Income REVENUE TOTALS Budget by Organization Report Through 11/30/15 Prior Fiscal Year Activity Included Classification Fund 210 - SPECIAL SERVICE AREA (SSA) #4 Run by Ashley King on 01/06/2016 15:19:55 PM Page 9 of 49 2015 Nov-15 YTD 2014 Budget Transactions Transactions Actual - - - - - - - - 1,400,000 - 1,114,447 - 590,111 276 3,318 13,196 - - - - 1,990,111 276 1,117,765 13,196 430,821 29,757 315,753 268,181 21,823 342 26,588 70,199 827,211 174,124 231,071 188,836 6,227 519 5,708 3,035 281,500 18,931 235,459 210,737 - - - - - - - - 55,500 - 63,399 74,660 367,029 137,625 441,060 596,849 1,990,111 361,298 1,319,037 1,412,496 1,990,111 276 1,117,765 13,196 1,990,111 361,298 1,319,037 1,412,496 - (361,022) (201,272) (1,399,300) Starting Fund Balance 184,902 184,902 Net Change - (201,272) Ending Fund Balance 184,902 (16,370) EXPENSE TOTALS Fund 215 - CDBG FUND Totals EXPENSE TOTALS Fund 215 - CDBG FUND Totals REVENUE TOTALS Debt Service Miscellaneous Interfund Transfers Insurance and Other Chargebacks Community Sponsored Organizations Contingencies EXPENSE Salary and Benefits Services and Supplies Capital Outlay Other Revenue Interest Income REVENUE TOTALS REVENUE Charges for Services Interfund Transfers Intergovernmental Revenue Budget by Organization Report Through 11/30/15 Prior Fiscal Year Activity Included Classification Fund 215 - CDBG FUND Run by Ashley King on 01/06/2016 15:19:55 PM Page 10 of 49 2015 Nov-15 YTD 2014 Budget Transactions Transactions Actual 237,000 - - (5,873) - 25,812 189,628 45,376 100 57 307 - 237,100 25,869 189,935 39,503 - - - - 237,100 27 27,256 39,503 - 325 4,168 - - - - - 237,100 352 31,424 39,503 237,100 25,869 189,935 39,503 237,100 352 31,424 39,503 - 25,517 158,511 - Starting Fund Balance 2,350,661 2,350,661 Net Change - 158,511 Ending Fund Balance 2,350,661 2,509,172 Fund 220 - CDBG LOAN Totals Fund 220 - CDBG LOAN Totals REVENUE TOTALS EXPENSE TOTALS Miscellaneous Interfund Transfers EXPENSE TOTALS REVENUE TOTALS EXPENSE Salary and Benefits Services and Supplies REVENUE Intergovernmental Revenue Other Revenue Interest Income Budget by Organization Report Through 11/30/15 Prior Fiscal Year Activity Included Classification Fund 220 - CDBG LOAN Run by Ashley King on 01/06/2016 15:19:55 PM Page 11 of 49 2015 Nov-15 YTD 2014 Budget Transactions Transactions Actual 1,800,000 20,881 2,065,300 1,913,372 - - - - 47,500 - - - 65,500 3,958 45,042 45,500 3,700 2 116 2,831 1,916,700 24,841 2,110,457 1,961,703 672,310 47,586 529,784 558,123 912,200 37,683 285,679 738,622 253,500 21,555 180,515 94,978 14,782 1,232 13,550 14,271 - - - 181 - - - - - - - - 916,000 - 1,292,866 52,105 483,736 51,454 565,994 470,155 3,252,528 159,511 2,868,389 1,928,435 1,916,700 24,841 2,110,457 1,961,703 3,252,528 159,511 2,868,389 1,928,435 (1,335,828) (134,669) (757,932) 33,268 Starting Fund Balance 3,540,471 3,540,471 Net Change (1,335,828) (757,932) Ending Fund Balance 2,204,643 2,782,539 EXPENSE TOTALS Fund 225 - ECONOMIC EXPENSE TOTALS Fund 225 - ECONOMIC REVENUE TOTALS Debt Service Miscellaneous Interfund Transfers Insurance and Other Chargebacks Community Sponsored Organizations Contingencies EXPENSE Salary and Benefits Services and Supplies Capital Outlay Other Revenue Interest Income REVENUE TOTALS REVENUE Other Taxes Charges for Services Interfund Transfers Budget by Organization Report Through 11/30/15 Prior Fiscal Year Activity Included Classification Fund 225 - ECONOMIC DEVELOPMENT FUND Run by Ashley King on 01/06/2016 15:19:55 PM Page 12 of 49 2015 Nov-15 YTD 2014 Budget Transactions Transactions Actual 20,000 - - 20,000 - - - - - - - - 20,000 - - 20,000 - - - - - - - - - - - - 50,000 - - - - - - - 50,000 - - - 20,000 - - 20,000 50,000 - - - (30,000) - - 20,000 Starting Fund Balance 169,915 169,915 Net Change (30,000) - Ending Fund Balance 139,915 169,915 EXPENSE TOTALS Fund 235 - NEIGHBORHOOD EXPENSE TOTALS Fund 235 - NEIGHBORHOOD REVENUE TOTALS Debt Service Miscellaneous Interfund Transfers REVENUE TOTALS EXPENSE Services and Supplies Capital Outlay REVENUE Other Taxes Interfund Transfers Interest Income Budget by Organization Report Through 11/30/15 Prior Fiscal Year Activity Included Classification Fund 235 - NEIGHBORHOOD IMPROVEMENT Run by Ashley King on 01/06/2016 15:19:55 PM Page 13 of 49 2015 Nov-15 YTD 2014 Budget Transactions Transactions Actual 216,000 - 459,428 - 225,200 2,282 31,226 27,384 - 1 15 63 441,200 2,283 490,670 27,447 38,171 - 12,388 22,164 402,529 14,701 432,031 924,053 - - - 146 - - - - - - - - - - - - 500 60 680 716 - 27,007 28,147 13,143 441,200 41,768 473,246 960,223 441,200 2,283 490,670 27,447 441,200 41,768 473,246 960,223 - (39,485) 17,423 (932,776) Starting Fund Balance 4,580,079 4,580,079 Net Change - 17,423 Ending Fund Balance 4,580,079 4,597,502 EXPENSE TOTALS Fund 240 - HOME FUND Totals EXPENSE TOTALS Fund 240 - HOME FUND Totals REVENUE TOTALS Debt Service Miscellaneous Interfund Transfers Capital Outlay Insurance and Other Chargebacks Community Sponsored Organizations REVENUE TOTALS EXPENSE Salary and Benefits Services and Supplies REVENUE Intergovernmental Revenue Other Revenue Interest Income Budget by Organization Report Through 11/30/15 Prior Fiscal Year Activity Included Classification Fund 240 - HOME FUND Run by Ashley King on 01/06/2016 15:19:55 PM Page 14 of 49 2015 Nov-15 YTD 2014 Budget Transactions Transactions Actual - - - 919 - - - 353,383 - - - 354,302 - - - - - - - - - - - - - - - 209,376 - - - 209,376 - - - 354,302 - - - 209,376 - - - 144,927 Starting Fund Balance 3,920,732 3,920,732 Net Change - - Ending Fund Balance 3,920,732 3,920,732 REVENUE TOTALS EXPENSE TOTALS Fund 245 - LIBRARY ENDOWMENT Interfund Transfers EXPENSE TOTALS Fund 245 - LIBRARY ENDOWMENT EXPENSE Services and Supplies Capital Outlay Miscellaneous REVENUE Other Revenue Interest Income REVENUE TOTALS Budget by Organization Report Through 11/30/15 Prior Fiscal Year Activity Included Classification Fund 245 - LIBRARY ENDOWMENT FUND Run by Ashley King on 01/06/2016 15:19:55 PM Page 15 of 49 2015 Nov-15 YTD 2014 Budget Transactions Transactions Actual 30,000 30,000 90,000 30,000 - - - - - - - - 374,772 10,082 141,621 160,525 228 1 106 256 405,000 40,083 231,727 190,781 - - - - 350,000 - 98 23,949 - - - - - - - - - - - - 55,000 9,852 54,150 57,000 - - - 13,990 405,000 9,852 54,248 94,939 405,000 40,083 231,727 190,781 405,000 9,852 54,248 94,939 - 30,231 177,478 95,842 Starting Fund Balance 2,546,920 2,546,920 Net Change - 177,478 Ending Fund Balance 2,546,920 2,724,399 REVENUE TOTALS EXPENSE TOTALS Fund 250 - AFFORDABLE HOUSING Interfund Transfers EXPENSE TOTALS Fund 250 - AFFORDABLE HOUSING Community Sponsored Organizations Debt Service Miscellaneous EXPENSE Salary and Benefits Services and Supplies Capital Outlay Other Revenue Interest Income REVENUE TOTALS REVENUE Other Taxes Charges for Services Interfund Transfers Budget by Organization Report Through 11/30/15 Prior Fiscal Year Activity Included Classification Fund 250 - AFFORDABLE HOUSING FUND Run by Ashley King on 01/06/2016 15:19:55 PM Page 16 of 49 2015 Nov-15 YTD 2014 Budget Transactions Transactions Actual 4,900,000 - 4,921,484 4,969,568 - - - - - - - - - - - - 10,000 641 2,837 13,420 4,910,000 641 4,924,321 4,982,987 - - - - - - 1,070 36,978 1,800,000 105 165,910 246 575,000 - 14,988 577,280 500,000 24,668 98,670 74,003 3,265,296 272,108 2,993,188 3,256,296 6,140,296 296,881 3,273,825 3,944,802 4,910,000 641 4,924,321 4,982,987 6,140,296 296,881 3,273,825 3,944,802 (1,230,296) (296,240) 1,650,495 1,038,186 Starting Fund Balance 6,186,704 6,186,704 Net Change (1,230,296) 1,650,495 Ending Fund Balance 4,956,408 7,837,199 EXPENSE TOTALS Fund 300 - WASHINGTON NATIONAL EXPENSE TOTALS Fund 300 - WASHINGTON NATIONAL REVENUE TOTALS Debt Service Miscellaneous Interfund Transfers EXPENSE Salary and Benefits Services and Supplies Capital Outlay Other Revenue Interest Income REVENUE TOTALS REVENUE Property Taxes Other Taxes Interfund Transfers Budget by Organization Report Through 11/30/15 Prior Fiscal Year Activity Included Classification Fund 300 - WASHINGTON NATIONAL TIF FUND Run by Ashley King on 01/06/2016 15:19:55 PM Page 17 of 49 2015 Nov-15 YTD 2014 Budget Transactions Transactions Actual 425,000 - 422,527 428,515 - - - - - - - - 300 - 4 5 425,300 - 422,531 428,521 - - - - 425,175 - 21,075 442,050 - - - - 425,175 - 21,075 442,050 425,300 - 422,531 428,521 425,175 - 21,075 442,050 125 - 401,456 (13,529) Starting Fund Balance 464,046 464,046 Net Change 125 401,456 Ending Fund Balance 464,171 865,502 Fund 305 - SPECIAL SERVICE AREA Fund 305 - SPECIAL SERVICE AREA REVENUE TOTALS EXPENSE TOTALS Debt Service Miscellaneous EXPENSE TOTALS Interest Income REVENUE TOTALS EXPENSE Services and Supplies REVENUE Property Taxes Interfund Transfers Other Revenue Budget by Organization Report Through 11/30/15 Prior Fiscal Year Activity Included Classification Fund 305 - SPECIAL SERVICE AREA (SSA) #5 Run by Ashley King on 01/06/2016 15:19:55 PM Page 18 of 49 2015 Nov-15 YTD 2014 Budget Transactions Transactions Actual 1,150,000 - 1,248,231 1,140,311 4,500 202 1,671 13,819 1,154,500 202 1,249,902 1,154,130 - - 1,070 1,003,464 1,000,000 105 8,540 246 - - - - - - - 776,153 2,500,000 539,005 2,153,374 217,435 148,010 12,334 135,676 144,400 3,648,010 551,445 2,298,659 2,141,697 1,154,500 202 1,249,902 1,154,130 3,648,010 551,445 2,298,659 2,141,697 (2,493,510) (551,243) (1,048,757) (987,566) Starting Fund Balance 2,369,483 2,369,483 Net Change (2,493,510) (1,048,757) Ending Fund Balance (124,027) 1,320,726 EXPENSE TOTALS Fund 310 - HOWARD-HARTREY TIF EXPENSE TOTALS Fund 310 - HOWARD-HARTREY TIF REVENUE TOTALS Debt Service Miscellaneous Interfund Transfers EXPENSE Services and Supplies Capital Outlay Community Sponsored Organizations REVENUE Property Taxes Interest Income REVENUE TOTALS Budget by Organization Report Through 11/30/15 Prior Fiscal Year Activity Included Classification Fund 310 - HOWARD-HARTREY TIF Run by Ashley King on 01/06/2016 15:19:55 PM Page 19 of 49 2015 Nov-15 YTD 2014 Budget Transactions Transactions Actual - - - 607,662 - - - 6 - - - 607,668 861,217 - - 1,978 - - - 15,600 - - - - - - 893,387 - - - - 29,500 861,217 - 893,387 47,077 - - - 607,668 861,217 - 893,387 47,077 (861,217) - (893,387) 560,591 Starting Fund Balance 893,665 893,665 Net Change (861,217) (893,387) Ending Fund Balance 32,448 278 Fund 315 - SOUTHWEST TIF FUND Fund 315 - SOUTHWEST TIF FUND REVENUE TOTALS EXPENSE TOTALS Miscellaneous Interfund Transfers EXPENSE TOTALS EXPENSE Services and Supplies Capital Outlay Debt Service REVENUE Property Taxes Interest Income REVENUE TOTALS Budget by Organization Report Through 11/30/15 Prior Fiscal Year Activity Included Classification Fund 315 - SOUTHWEST TIF FUND Run by Ashley King on 01/06/2016 15:19:55 PM Page 20 of 49 2015 Nov-15 YTD 2014 Budget Transactions Transactions Actual 10,879,993 93,330 11,131,544 11,237,317 2,743,836 206,928 2,276,213 1,797,563 11,437,986 11,437,986 1,500 1,320 7,378 11,934 13,625,329 11,739,565 24,853,121 13,046,814 292,320 145,023 154,076 79,120 13,432,509 - 3,628,784 12,780,039 193,285 793 793 - - - - - 13,918,114 145,816 3,783,652 12,859,158 13,625,329 11,739,565 24,853,121 13,046,814 13,918,114 145,816 3,783,652 12,859,158 (292,785) 11,593,749 21,069,468 187,656 Starting Fund Balance 3,796,787 3,796,787 Net Change (292,785) 21,069,468 Ending Fund Balance 3,504,002 24,866,255 EXPENSE TOTALS Fund 320 - DEBT SERVICE FUND Totals EXPENSE TOTALS Fund 320 - DEBT SERVICE FUND Totals REVENUE TOTALS Debt Service Miscellaneous Interfund Transfers Interest Income REVENUE TOTALS EXPENSE Services and Supplies REVENUE Property Taxes Interfund Transfers Other Revenue Budget by Organization Report Through 11/30/15 Prior Fiscal Year Activity Included Detail Listing Classification Fund 320 - DEBT SERVICE FUND Run by Ashley King on 01/06/2016 15:19:55 PM Page 21 of 49 2015 Nov-15 YTD 2014 Budget Transactions Transactions Actual 545,000 - 540,576 444,587 300,500 4,128 69,236 61,932 500 6 1,804 211 846,000 4,134 611,617 506,731 490,000 526 586,636 553,958 200,000 105 (6,275) 166,921 - - - - 600 50 536 2,507 - - 15 - 107,500 8,958 98,542 105,500 798,100 9,640 679,454 828,885 846,000 4,134 611,617 506,731 798,100 9,640 679,454 828,885 47,900 (5,506) (67,836) (322,154) Starting Fund Balance 259,119 259,119 Net Change 47,900 (67,836) Ending Fund Balance 307,019 191,283 REVENUE TOTALS EXPENSE TOTALS Fund 330 - HOWARD-RIDGE TIF Interfund Transfers EXPENSE TOTALS Fund 330 - HOWARD-RIDGE TIF Community Sponsored Organizations Debt Service Miscellaneous REVENUE TOTALS EXPENSE Services and Supplies Capital Outlay REVENUE Property Taxes Other Revenue Interest Income Budget by Organization Report Through 11/30/15 Prior Fiscal Year Activity Included Classification Fund 330 - HOWARD-RIDGE TIF FUND Run by Ashley King on 01/06/2016 15:19:55 PM Page 22 of 49 2015 Nov-15 YTD 2014 Budget Transactions Transactions Actual - - - - 105,000 - - 100,262 100 23 218 765 105,100 23 218 101,027 - - 1,070 1,978 - (923) (10,177) 246 - - - - 10,000 617 6,587 14,122 95,000 - - 61,950 60,000 5,000 55,000 60,000 165,000 4,694 52,480 138,295 105,100 23 218 101,027 165,000 4,694 52,480 138,295 (59,900) (4,671) (52,262) (37,269) Starting Fund Balance 500,370 500,370 Net Change (59,900) (52,262) Ending Fund Balance 440,470 448,108 REVENUE TOTALS EXPENSE TOTALS Fund 335 - WEST EVANSTON TIF Interfund Transfers EXPENSE TOTALS Fund 335 - WEST EVANSTON TIF Contingencies Debt Service Miscellaneous REVENUE TOTALS EXPENSE Services and Supplies Capital Outlay REVENUE Property Taxes Other Revenue Interest Income Budget by Organization Report Through 11/30/15 Prior Fiscal Year Activity Included Classification Fund 335 - WEST EVANSTON TIF FUND Run by Ashley King on 01/06/2016 15:19:55 PM Page 23 of 49 2015 Nov-15 YTD 2014 Budget Transactions Transactions Actual - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Fund 340 - DEMPSTER-DODGE TIF Fund 340 - DEMPSTER-DODGE TIF REVENUE TOTALS EXPENSE TOTALS EXPENSE Services and Supplies Debt Service EXPENSE TOTALS REVENUE Property Taxes Other Revenue REVENUE TOTALS Budget by Organization Report Through 11/30/15 Prior Fiscal Year Activity Included Classification Fund 340 - DEMPSTER-DODGE TIF FUND Run by Ashley King on 01/06/2016 15:19:55 PM Page 24 of 49 2015 Nov-15 YTD 2014 Budget Transactions Transactions Actual - - - - 2,900,000 - 2,900,000 - 2,900,000 - 2,900,000 - - - - - 2,900,000 - 2,290,000 - - 2,962 5,064 - 2,900,000 2,962 2,295,064 - 2,900,000 - 2,900,000 - 2,900,000 2,962 2,295,064 - - (2,962) 604,936 - Starting Fund Balance - - Net Change 604,936 - Ending Fund Balance 604,936 - EXPENSE TOTALS Fund 345 - CHICAGO-MAIN TIF Totals EXPENSE TOTALS Fund 345 - CHICAGO-MAIN TIF Totals REVENUE TOTALS EXPENSE Services and Supplies Capital Outlay Debt Service REVENUE Property Taxes Other Revenue REVENUE TOTALS Budget by Organization Report Through 11/30/15 Prior Fiscal Year Activity Included Classification Fund 345 - CHICAGO-MAIN TIF Run by Ashley King on 01/06/2016 15:19:55 PM Page 25 of 49 2015 Nov-15 YTD 2014 Budget Transactions Transactions Actual - 954 87,391 110,620 - 64,081 464,081 487,563 875,000 - - 936,500 10,198,000 - - - 14,946,300 7,795,481 7,945,481 10,048,514 20,000 228 2,813 20,380 26,039,300 7,860,744 8,499,765 11,603,577 - - - 4,472 60,000 79,405 477,786 701,494 17,482,150 1,600,497 6,658,013 7,288,509 - - - 190,364 - - - - 980,000 40,833 449,167 1,547,810 18,522,150 1,720,735 7,584,966 9,732,649 26,039,300 7,860,744 8,499,765 11,603,577 18,522,150 1,720,735 7,584,966 9,732,649 7,517,150 6,140,009 914,799 1,870,927 Starting Fund Balance 8,170,926 8,170,926 Net Change (5,912,500) 914,799 Ending Fund Balance 2,258,426 9,085,725 REVENUE TOTALS EXPENSE TOTALS Fund 415 - CAPITAL IMPROVEMENTS Interfund Transfers EXPENSE TOTALS Fund 415 - CAPITAL IMPROVEMENTS Capital Outlay Debt Service Miscellaneous REVENUE TOTALS EXPENSE Salary and Benefits Services and Supplies Intergovernmental Revenue Other Revenue Interest Income REVENUE Licenses, Permits and Fees Charges for Services Interfund Transfers Budget by Organization Report Through 11/30/15 Prior Fiscal Year Activity Included Classification Fund 415 - CAPITAL IMPROVEMENTS FUND Run by Ashley King on 01/06/2016 15:19:55 PM Page 26 of 49 2015 Nov-15 YTD 2014 Budget Transactions Transactions Actual - - - - - - - - - - - - - - - - - - - - - - - - - - - - 250,000 243,113 243,113 506,435 - - - - - - - - - - - - 51,033 1,256 23,235 32,271 180,167 9,931 91,667 137,960 - - - - 481,200 254,300 358,015 676,665 - - - - - 1,784 1,879 3,251 501,000 24,380 226,538 53,738 - - - 620 - - - 3,084 - - - - 260,698 - - 169,848 761,698 26,164 228,417 230,541 481,200 254,300 358,015 676,665 761,698 26,164 228,417 230,541 (280,498) 228,136 129,598 446,124 Starting Fund Balance 2,518,568 2,518,568 Net Change (280,498) 129,598 Ending Fund Balance 2,238,070 2,648,167 REVENUE TOTALS EXPENSE TOTALS Fund 420 - SPECIAL ASSESSMENT Interfund Transfers EXPENSE TOTALS Fund 420 - SPECIAL ASSESSMENT Insurance and Other Chargebacks Debt Service Miscellaneous EXPENSE Salary and Benefits Services and Supplies Capital Outlay Special Assessment Reappropriation of Surplus REVENUE TOTALS Insurance Library Revenue Interest Income Intergovernmental Revenue Other Revenue Workers Compensation and Liability Fines and Forfeitures Charges for Services Interfund Transfers REVENUE Property Taxes Other Taxes Licenses, Permits and Fees Budget by Organization Report Through 11/30/15 Prior Fiscal Year Activity Included Classification Fund 420 - SPECIAL ASSESSMENT FUND Run by Ashley King on 01/06/2016 15:19:55 PM Page 27 of 49 2015 Nov-15 YTD 2014 Budget Transactions Transactions Actual - - - - - - - (36) - - 150 850 - - - - 6,602,525 970,386 6,057,197 5,988,594 3,711,770 243,775 2,681,521 2,925,296 - - - - 115,236 20,421 140,060 90,966 35,070 1,769 16,847 31,645 10,464,601 1,236,351 8,895,775 9,037,314 1,442,683 99,920 1,104,751 1,358,672 3,318,189 257,967 2,622,662 2,811,302 3,529,850 349,682 1,784,291 (79,159) - - - - - - - - 1,943,217 - - 2,785,161 12,965 968 3,368 9,686 3,917,652 - 256,414 727,892 252,000 - - - 1,242,738 103,562 1,139,179 1,240,883 15,659,294 812,098 6,910,665 8,854,437 10,464,601 1,236,351 8,895,775 9,037,314 15,659,294 812,098 6,910,665 8,854,437 (5,194,693) 424,253 1,985,110 182,877 Starting Fund Balance 12,814,717 12,814,717 Net Change (5,194,693) 1,985,110 Ending Fund Balance 7,620,024 14,799,827 Fund 505 - PARKING SYSTEM FUND Fund 505 - PARKING SYSTEM FUND REVENUE TOTALS EXPENSE TOTALS Miscellaneous Interfund Transfers EXPENSE TOTALS Depreciation Expense Contingencies Debt Service Capital Outlay Insurance and Other Chargebacks Community Sponsored Organizations REVENUE TOTALS EXPENSE Salary and Benefits Services and Supplies Intergovernmental Revenue Other Revenue Interest Income Fines and Forfeitures Charges for Services Interfund Transfers REVENUE Property Taxes Other Taxes Licenses, Permits and Fees Budget by Organization Report Through 11/30/15 Prior Fiscal Year Activity Included Classification Fund 505 - PARKING SYSTEM FUND Run by Ashley King on 01/06/2016 15:19:55 PM Page 28 of 49 2015 Nov-15 YTD 2014 Budget Transactions Transactions Actual - - - - 70,000 7,620 96,173 118,038 15,418,000 1,283,137 14,189,631 14,554,926 - - - - 50,000 10,087 114,226 84,886 12,511,100 5,809,182 6,087,391 293,882 10,000 607 2,781 17,552 28,059,100 7,110,633 20,490,202 15,069,284 5,132,341 397,342 4,403,339 4,767,985 3,339,890 187,343 1,811,674 2,565,308 18,752,100 283,825 561,961 12,663 - - - - - - - - - - - 1,569,014 1,000 - 356 756 1,046,399 - 301,440 438,227 12,480 - 875 770,057 3,791,432 315,953 8,977,695 9,461,523 32,075,642 1,184,463 16,057,340 19,585,533 28,059,100 7,110,633 20,490,202 15,069,284 32,075,642 1,184,463 16,057,340 19,585,533 (4,016,542) 5,926,170 4,432,862 (4,516,249) Starting Fund Balance 7,454,107 7,454,107 Net Change 32,075,642 4,432,862 Ending Fund Balance 39,529,749 11,886,969 EXPENSE TOTALS Fund 510 - WATER FUND Totals EXPENSE TOTALS Fund 510 - WATER FUND Totals REVENUE TOTALS Debt Service Miscellaneous Interfund Transfers Community Sponsored Organizations Depreciation Expense Contingencies Services and Supplies Capital Outlay Insurance and Other Chargebacks Interest Income REVENUE TOTALS EXPENSE Salary and Benefits Interfund Transfers Intergovernmental Revenue Other Revenue REVENUE Other Taxes Licenses, Permits and Fees Charges for Services Budget by Organization Report Through 11/30/15 Prior Fiscal Year Activity Included Detail Listing Classification Fund 510 - WATER FUND Run by Ashley King on 01/06/2016 15:19:55 PM Page 29 of 49 2015 Nov-15 YTD 2014 Budget Transactions Transactions Actual - - - - - - - - - 144 1,042 6,856 - 144 1,042 6,856 - - - - - - - 26,008 - - - - - - - 26,008 - 144 1,042 6,856 - - - 26,008 - 144 1,042 (19,152) REVENUE TOTALS EXPENSE TOTALS Fund 511 - WATER - BOND AND Miscellaneous EXPENSE TOTALS Fund 511 - WATER - BOND AND REVENUE TOTALS EXPENSE Services and Supplies Debt Service REVENUE Interfund Transfers Other Revenue Interest Income Budget by Organization Report Through 11/30/15 Prior Fiscal Year Activity Included Classification Fund 511 - WATER - BOND AND INTEREST Run by Ashley King on 01/06/2016 15:19:55 PM Page 30 of 49 2015 Nov-15 YTD 2014 Budget Transactions Transactions Actual - 67 715 661 - 67 715 661 - - - - - - - - - - - - - - - - - 67 715 661 - - - - - 67 715 661 EXPENSE TOTALS Fund 512 - WATER-BOND RESERVE EXPENSE TOTALS Fund 512 - WATER-BOND RESERVE REVENUE TOTALS Services and Supplies Miscellaneous Interfund Transfers REVENUE Interest Income REVENUE TOTALS EXPENSE Budget by Organization Report Through 11/30/15 Prior Fiscal Year Activity Included Classification Fund 512 - WATER-BOND RESERVE Run by Ashley King on 01/06/2016 15:19:55 PM Page 31 of 49 2015 Nov-15 YTD 2014 Budget Transactions Transactions Actual - - - - - - 5,500,000 5,500,000 - - - - - 484,237 997,243 14,557 - 54 466 473 - 484,290 6,497,709 5,515,030 - 34,923 225,224 277,229 - 970,799 7,272,928 1,045,841 - - - - - - - - - 1,005,723 7,498,152 1,323,070 - 484,290 6,497,709 5,515,030 - 1,005,723 7,498,152 1,323,070 - (521,433) (1,000,443) 4,191,959 REVENUE TOTALS EXPENSE TOTALS Fund 513 - WATER DEPR IMPRV & Interfund Transfers EXPENSE TOTALS Fund 513 - WATER DEPR IMPRV & EXPENSE Services and Supplies Capital Outlay Miscellaneous Other Revenue Interest Income REVENUE TOTALS REVENUE Charges for Services Interfund Transfers Intergovernmental Revenue Budget by Organization Report Through 11/30/15 Prior Fiscal Year Activity Included Classification Fund 513 - WATER DEPR IMPRV & EXTENSION Run by Ashley King on 01/06/2016 15:19:55 PM Page 32 of 49 2015 Nov-15 YTD 2014 Budget Transactions Transactions Actual 13,072,700 1,197,906 12,052,594 12,785,065 - - - - 4,165 - 219,659 - 1,000 90 1,942 3,221 13,077,865 1,197,996 12,274,195 12,788,286 1,121,635 90,477 1,013,817 1,263,185 1,009,800 32,754 903,803 266,642 628,500 60,730 497,481 212,183 - - - - - - - 3,367,923 - - - - 9,619,477 1,024,321 8,480,421 1,735,371 5,000 - 3,306 - 1,005,223 83,769 921,455 800,045 13,389,635 1,292,051 11,820,282 7,645,350 13,077,865 1,197,996 12,274,195 12,788,286 13,389,635 1,292,051 11,820,282 7,645,350 (311,770) (94,055) 453,913 5,142,936 Starting Fund Balance 4,405,937 4,405,937 Net Change (311,770) 453,913 Ending Fund Balance 4,094,167 4,859,850 Fund 515 - SEWER FUND Totals Fund 515 - SEWER FUND Totals REVENUE TOTALS EXPENSE TOTALS Miscellaneous Interfund Transfers EXPENSE TOTALS Depreciation Expense Contingencies Debt Service Services and Supplies Capital Outlay Insurance and Other Chargebacks Interest Income REVENUE TOTALS EXPENSE Salary and Benefits REVENUE Charges for Services Interfund Transfers Other Revenue Budget by Organization Report Through 11/30/15 Prior Fiscal Year Activity Included Classification Fund 515 - SEWER FUND Run by Ashley King on 01/06/2016 15:19:55 PM Page 33 of 49 2015 Nov-15 YTD 2014 Budget Transactions Transactions Actual 175,000 44,115 313,465 125,497 3,616,394 294,340 3,265,708 3,590,758 1,055,967 87,997 967,970 1,055,967 - - - - 235,000 161,128 221,429 254,958 - - - - 5,082,361 587,580 4,768,572 5,027,180 850,669 49,443 714,778 884,329 3,750,546 289,232 3,188,658 3,435,696 25,000 2,378 13,586 20,309 - - - - - - - - - - - - - - - - 60,000 - 12,933 31,274 15,500 - - - 490,105 40,842 449,263 475,202 5,191,820 381,896 4,379,218 4,846,811 5,082,361 587,580 4,768,572 5,027,180 5,191,820 381,896 4,379,218 4,846,811 (109,459) 205,684 389,354 180,369 Starting Fund Balance (1,112,075) (1,112,075) Net Change (109,459) 389,354 Ending Fund Balance (1,221,534) (722,720) Fund 520 - SOLID WASTE FUND Totals Fund 520 - SOLID WASTE FUND Totals REVENUE TOTALS EXPENSE TOTALS Miscellaneous Interfund Transfers EXPENSE TOTALS Depreciation Expense Contingencies Debt Service Capital Outlay Insurance and Other Chargebacks Community Sponsored Organizations REVENUE TOTALS EXPENSE Salary and Benefits Services and Supplies Intergovernmental Revenue Other Revenue Interest Income REVENUE Licenses, Permits and Fees Charges for Services Interfund Transfers Budget by Organization Report Through 11/30/15 Prior Fiscal Year Activity Included Classification Fund 520 - SOLID WASTE FUND Run by Ashley King on 01/06/2016 15:19:55 PM Page 34 of 49 2015 Nov-15 YTD 2014 Budget Transactions Transactions Actual 24,798 - - - - - - - 3,317,088 273,900 3,015,109 3,130,282 - - - - 56,781 - 46,933 50,010 1,000 - - - 3,399,667 273,900 3,062,043 3,180,292 1,262,046 73,613 1,051,811 1,278,713 2,256,021 93,471 1,490,267 2,108,163 - - - - 25,820 2,152 23,668 24,927 - - - 357 450 - - - - - - - - - - - - - - - 3,544,337 169,236 2,565,746 3,412,159 3,399,667 273,900 3,062,043 3,180,292 3,544,337 169,236 2,565,746 3,412,159 (144,670) 104,664 496,297 (231,867) Starting Fund Balance (120,944) (120,944) Net Change (144,670) 496,297 Ending Fund Balance (265,614) 375,353 REVENUE TOTALS EXPENSE TOTALS Fund 600 - FLEET SERVICES FUND Interfund Transfers EXPENSE TOTALS Fund 600 - FLEET SERVICES FUND Contingencies Debt Service Miscellaneous Capital Outlay Insurance and Other Chargebacks Depreciation Expense REVENUE TOTALS EXPENSE Salary and Benefits Services and Supplies Intergovernmental Revenue Other Revenue Interest Income REVENUE Fines and Forfeitures Charges for Services Interfund Transfers Budget by Organization Report Through 11/30/15 Prior Fiscal Year Activity Included Classification Fund 600 - FLEET SERVICES FUND Run by Ashley King on 01/06/2016 15:19:55 PM Page 35 of 49 2015 Nov-15 YTD 2014 Budget Transactions Transactions Actual 1,451,421 120,952 1,330,470 2,524,231 210,217 28,316 80,715 53,210 1,661,638 149,268 1,411,185 2,577,440 60,000 3,341 50,617 90,671 1,455,422 - 1,255,860 62,978 - - - 1,476,384 - - - 6,674 1,515,422 3,341 1,306,477 1,636,707 1,661,638 149,268 1,411,185 2,577,440 1,515,422 3,341 1,306,477 1,636,707 146,216 145,927 104,708 940,734 Starting Fund Balance 2,183,786 2,183,786 Net Change 146,216 104,708 Ending Fund Balance 2,330,002 2,288,494 REVENUE TOTALS EXPENSE TOTALS Fund 601 - EQUIPMENT Miscellaneous EXPENSE TOTALS Fund 601 - EQUIPMENT EXPENSE Services and Supplies Capital Outlay Depreciation Expense REVENUE Interfund Transfers Other Revenue REVENUE TOTALS Budget by Organization Report Through 11/30/15 Prior Fiscal Year Activity Included Classification Fund 601 - EQUIPMENT REPLACEMENT FUND Run by Ashley King on 01/06/2016 15:19:55 PM Page 36 of 49 2015 Nov-15 YTD 2014 Budget Transactions Transactions Actual - - - - 162,411 13,534 148,877 162,411 - - - 336,911 10,152,079 861,293 9,211,382 10,237,720 1,023,094 89,022 955,093 1,016,359 6,524,424 368,282 4,819,063 6,321,506 1,000 15 120 119 17,863,008 1,332,146 15,134,533 18,075,025 453,768 37,707 423,839 407,401 1,395,248 231,755 1,741,825 2,520,329 - - - 7,932 15,360,736 1,117,854 13,405,770 14,787,200 - - - - - - - - - - - - - - - - - - (105,000) 6,426 - - - - 17,209,752 1,387,315 15,466,434 17,729,288 17,863,008 1,332,146 15,134,533 18,075,025 17,209,752 1,387,315 15,466,434 17,729,288 653,256 (55,169) (331,901) 345,737 Starting Fund Balance (3,381,927) (3,381,927) Net Change 653,256 (331,901) Ending Fund Balance (2,728,671) (3,713,828) EXPENSE TOTALS Fund 605 - INSURANCE FUND Totals EXPENSE TOTALS Fund 605 - INSURANCE FUND Totals REVENUE TOTALS Debt Service Miscellaneous Interfund Transfers Community Sponsored Organizations Depreciation Expense Contingencies Services and Supplies Capital Outlay Insurance and Other Chargebacks Interest Income REVENUE TOTALS EXPENSE Salary and Benefits Other Revenue Workers Compensation and Liability Insurance REVENUE Fines and Forfeitures Charges for Services Interfund Transfers Budget by Organization Report Through 11/30/15 Prior Fiscal Year Activity Included Detail Listing Classification Fund 605 - INSURANCE FUND Run by Ashley King on 01/06/2016 15:19:55 PM Page 37 of 49 2015 Nov-15 YTD 2014 Budget Transactions Transactions Actual 6,061,575 46,354 6,090,868 6,130,815 280,000 - 280,000 280,000 - - - - 978,500 72,329 857,874 919,874 850,000 - (26,919) 3,665,995 8,170,075 118,683 7,201,824 10,996,684 7,886,630 689,880 7,433,025 7,971,699 - - - - - - - - - - - - - - - - 7,886,630 689,880 7,433,025 7,971,699 8,170,075 118,683 7,201,824 10,996,684 7,886,630 689,880 7,433,025 7,971,699 283,445 (571,197) (231,202) 3,024,986 Starting Fund Balance 68,241,712 68,241,712 Net Change 283,445 (231,202) Ending Fund Balance 68,525,157 68,010,510 Fund 700 - FIRE PENSION FUND Totals Fund 700 - FIRE PENSION FUND Totals REVENUE TOTALS EXPENSE TOTALS Debt Service Miscellaneous EXPENSE TOTALS EXPENSE Salary and Benefits Services and Supplies Community Sponsored Organizations Other Revenue Interest Income REVENUE TOTALS REVENUE Property Taxes Other Taxes Interfund Transfers Budget by Organization Report Through 11/30/15 Prior Fiscal Year Activity Included Detail Listing Classification Fund 700 - FIRE PENSION FUND Run by Ashley King on 01/06/2016 15:19:55 PM Page 38 of 49 2015 Nov-15 YTD 2014 Budget Transactions Transactions Actual 8,380,207 64,290 8,410,300 8,476,543 325,000 - 325,000 325,000 - - - - 1,500,000 109,272 1,276,886 1,565,053 2,800,000 - 106 9,139,372 13,005,207 173,561 10,012,292 19,505,968 10,542,500 882,936 9,516,972 10,252,264 - - - - - - - 1,698 - - - - 10,542,500 882,936 9,516,972 10,253,962 13,005,207 173,561 10,012,292 19,505,968 10,542,500 882,936 9,516,972 10,253,962 2,462,707 (709,375) 495,320 9,252,006 Starting Fund Balance 99,687,542 99,687,542 Net Change 2,462,707 495,320 Ending Fund Balance 102,150,249 100,182,862 REVENUE TOTALS EXPENSE TOTALS Fund 705 - POLICE PENSION FUND Miscellaneous EXPENSE TOTALS Fund 705 - POLICE PENSION FUND EXPENSE Salary and Benefits Services and Supplies Debt Service Other Revenue Interest Income REVENUE TOTALS REVENUE Property Taxes Other Taxes Interfund Transfers Budget by Organization Report Through 11/30/15 Prior Fiscal Year Activity Included Detail Listing Classification Fund 705 - POLICE PENSION FUND Run by Ashley King on 01/06/2016 15:19:55 PM Page 39 of 49 January February March April May June July August September October November December FY 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,434,566$ FY 2014 Unreserved Fund Balance 17,321,904$ 17,910,959$ 21,166,294$ 20,395,607$ 20,882,214$ 19,058,144$ 19,999,271$ 22,595,599$ 20,438,571$ 19,062,126$ 16,290,405$ FY 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$ FY 2014 Cash Balance 4,173,079$ 6,745,425$ 10,059,258$ 9,101,839$ 8,474,680$ 7,167,254$ 9,635,823$ 12,266,622$ 10,328,206$ 9,083,878$ 6,093,725$ $- $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 City of Evanston General Fund Comparison of Fund and Cash Balances Fiscal Year 2014 vs Fiscal Year 2015 FY 2015 Unreserved Fund Balance FY 2014 Unreserved Fund Balance FY 2015 Cash Balance FY 2014 Cash Balance FY 2015 Unreserved Fund Balance FY 2014 Unreserved Fund Balance FY 2015 Cash Balance FY 2014 Cash Balance