Loading...
HomeMy WebLinkAbout2015.05 May Monthly ReportMay Actual Tax - Property 12,031,386$ 12,192,095$ 11,627,072$ 76,096$ 6,494,412$ Tax - State Use 1,241,753 1,368,626 1,260,000 132,981 549,113$ Tax - Sales Tax - Basic 9,690,000 9,693,509 10,225,000 811,904 3,841,880$ Tax - Sales Tax - Home Rule 6,100,000 5,944,171 6,180,000 481,490 2,316,409$ Tax - Auto Rental 40,000 49,018 43,000 3,149 14,631$ Tax - Athletic Contest 800,000 1,032,080 900,000 -$ Tax - State Income 7,076,170 7,053,978 7,500,000 1,335,205 4,029,498$ Tax - Electric Utility 3,070,000 2,941,483 3,070,000 214,423 1,267,688$ Tax - Natural Gas Utility 1,200,000 1,453,340 1,150,000 81,069 694,066$ Tax - Natural Gas Use - Home Rule 800,000 809,579 800,000 59,936 456,329$ Tax - Cigarette 300,000 222,000 300,000 81,000$ Tax - Evanston Motor Fuel 610,000 722,276 640,000 62,389 329,942$ Tax - Liquor 2,375,000 2,665,447 2,450,000 190,348 1,040,833$ Tax - Parking 2,350,000 2,565,189 2,500,000 182,150 988,008$ Tax - Personal Property Replacement 552,000 793,445 646,300 155,316 482,521$ Tax - Real Estate Transfer 2,875,000 2,543,056 2,875,000 237,750 1,149,422$ Tax - Telecommunications 3,150,000 2,620,715 3,150,000 193,654 1,033,967$ License Fees - Vehicles 2,700,000 2,462,002 2,850,000 26,769.86 511,141$ License Fees - Other 937,302 1,172,225 999,677 119,977 569,974$ Permit Fees - Building 6,142,162 7,113,065 6,700,000 (139,887.99)1,888,294$ Permit Fees - Other 1,486,716 2,287,055 1,439,082 78,831 819,009$ Other Fees 1,356,100 1,475,902 1,478,100 $275,418.23 688,991$ Fines and Forfeiture Revenue 4,366,022 3,064,932 4,063,774 $279,602.90 1,208,659$ Charges for Services Revenue 7,936,754 7,888,847 8,130,667 $769,067.45 3,866,610$ Intergovernmental Revenue 721,272 1,005,587 725,727 $6,377.08 383,693$ Other Revenue 1,238,468 1,750,657 1,718,343 $103,213.65 440,191$ Interfund Transfers In (Other Funds)7,742,893 7,781,104 7,892,893 $636,903.52 3,184,518$ Interest Income 10,000 13,037 120,000 $1,002.53 2,231$ Total Revenue 89,185,298 90,684,420 91,434,635 6,375,134 38,333,027 Legislative 639,028 706,237 677,023 49596 242,228 City Administration 1,662,057 1,792,690 1,903,126 128835 671,121 Law Department 959,802 1,052,372 1,129,534 86434 414,329 Administrative Services Department 8,510,814 7,601,123 8,956,805 671992 2,841,275 Community Development 2,707,545 2,606,953 2,427,257 179565 907,211 Police Department 27,994,019 27,973,626 27,820,569 2156275 11,239,473 Fire Department 14,238,555 14,679,164 14,462,599 1160165 5,646,009 Health & Human Services Department 3,117,681 3,009,986 3,658,702 549210 1,301,532 Public Works Department 18,604,977 18,459,022 18,048,955 1321007 6,829,407 Parks, Recreation & Community Services 10,654,760 11,330,293 10,836,161 824011 3,412,849 Transfer to Solid Waste Fund - - - 0 Transfer to Debt Service Fund 609,000 609,000 1,414,583 191615 958,074 Transfer to Fleet Maintenance Fund 936,500 936,500 - 0 Transfer to Insurance Fund - - - - - Total Expenditures 90,634,538 90,756,966 91,335,314 7,318,704 34,463,509 Net Surplus (Deficit)(1,449,240)$ (72,546)$ 99,321$ (943,570)$ 3,869,518$ Beginning Unrestricted Fund Balance (Note 1) 16,362,951 16,290,405 Total Ending Fund Balance 16,290,405$ 20,159,923$ Note 1: Unrestricted fund balance includes amounts designated for compensated absences and IMRF. City of Evanston General Fund As of May 31, 2015 FY 2014 Unaudited Actual FY 2015 Budget Adopted FY 2014 Budget Amended FY 2015 YTD Actual May Actual Property Taxes 414,363$ 1,348,553$ 5,325$ Misc. Revenue - 26,877 26,000 5 2,521$ Transfers from other Funds - 466,269 - - -$ Total Revenue - 907,508 1,374,553 5 7,846$ Administration - 118,293 219,119 11,524 56,126$ Client Payments - 630,525 1,151,250 49,961 280,664$ Capital Outlay - - - - -$ Community Sponsored Org - - - - 81$ Total Expenditures - 748,818 1,370,369 61,485 336,872$ Net Surplus (Deficit) -$ 158,690$ 4,184$ (61,480)$ (329,026)$ Beginning Fund Balance - 158,690 Ending Fund Balance 158,690$ (170,336)$ City of Evanston General Assistance Fund As of May 31, 2015 FY 2014 Budget Amended FY 2014 Unaudited Actual FY 2015 Budget Adopted FY 2015 YTD Actual May Actual Program Income 458,044$ 1,357,581$ 500,000$ -$ Investment Income - 336 - 20 52 Total Revenue 458,044 1,357,917 500,000 20 52 Development Activities 290,500 1,000,368 314,994 5,240 8,300 Administration 126,635 93,459 56,911 20,910 Transfer to Debt Service 4,046 7,951 4,191 349 1,746 Transfer to Insurance 6,863 - - 128 641 Transfer to General Fund 30,000 44,604 7,500 - - Total Expenditures 458,044 1,146,382 383,596 5,718 31,598 Net Surplus (Deficit) -$ 211,535$ 116,404$ (5,698)$ (31,546)$ Beginning Fund Balance - 211,535 Ending Fund Balance 211,535$ 179,989$ City of Evanston Neighborhood Stabilization Fund As of May 31, 2015 FY 2014 Budget Amended FY 2014 Unaudited Actual FY 2015 Budget Adopted FY 2015 YTD Actual May Actual State Allotment 1,750,000$ 1,844,046$ 1,750,000$ 173,239$ 739,558$ Grant Revenue -$ 322,396$ -$ - Investment Earnings 500 277 1,000 61 209 Miscellaneous Income - - - - - Total Revenue 1,750,500 2,166,719 1,751,000 173,300 739,767 Street Resurfacing 1,400,000 893,829 1,700,000 1,215 Transfer to General Fund - Staff Engineering 133,000 180,250 283,220 22,908 115,926 Transfer to General Fund - Street Maintenance 700,000 652,750 549,780 46,509 231,158 Total Expenditures 2,233,000 1,726,829 2,533,000 69,417 348,298 Net Surplus (Deficit)(482,500)$ 439,890$ (782,000)$ 103,883$ 391,468$ Beginning Fund Balance 1,312,568 1,752,458 Ending Fund Balance 1,752,458$ 2,143,927$ City of Evanston Motor Fuel Fund As of May 31, 2015 FY 2014 Budget Amended FY 2014 Unaudited Actual FY 2015 Budget Adopted FY 2015 YTD Actual May Actual Landline Surcharge Revenue 529,200$ 525,633$ 529,995$ 97,569$ 305,945 Wireless Surcharge Revenue 428,400 417,597 508,244 78,402 113,897 Interest Income 1,000 99 1,000 17 70 Grants - - Miscellaneous Revenue - 1,751 - - 100 Total Revenue 958,600 945,080 1,039,239 175,988 420,012 Operating Expense 935,767 785,907 976,758 53,883 312,427 Transfer to General Fund 125,950 125,950 129,729 10,811 54,054 Transfer to Insurance Fund 88,858 88,858 17,448 7,270 7,270 Transfer to Debt Service Fund 11,622 11,622 12,038 1,003 5,016 Capital Replacement 250,000 238,052 40,000 79,258 73,546 Total Expenditures 1,412,197 1,250,389 1,175,973 152,225 452,312 Net Surplus (Deficit)(453,597)$ (305,309)$ (136,734)$ 23,763$ (32,300)$ Beginning Fund Balance 1,220,879 915,570 Ending Fund Balance 915,570$ 883,270$ City of Evanston E911 Fund As of May 31, 2015 FY 2014 Budget Amended FY 2014 Unaudited Actual FY 2015 Budget Adopted FY 2015 YTD Actual May Actual Property Tax Revenue 370,000$ 310,595$ 320,000$ 799$ 175,456$ Investment Income - 4 - - - Total Revenues 370,000 310,599 320,000 799 175,456 - Professional Fees (Evmark)370,000 320,000 320,000 80,750 161,500 Total Expenditures 370,000 320,000 320,000 80,750 161,500 Net Surplus (Deficit)-$ (9,401)$ -$ (79,951)$ 13,956$ Beginning Fund Balance (149,335) (158,736) Ending Fund Balance (158,736)$ (144,780)$ City of Evanston Special Service Area #4 Fund As of May 31, 2015 FY 2014 Budget Amended FY 2014 Unaudited Actual FY 2015 Budget Adopted FY 2015 YTD Actual May Actual Intergovernmental/Entitlement 1,500,000$ $ 1,082,768 1,400,000$ -$ $ 406,762 Funds Reallocated from Prior Years 168,088 - 590,111 - - Program Income 70,000 416,446 - - 3,043 Miscellaneous - 143 - - - Total Revenues 1,738,088 1,499,358 1,990,111 - 409,805 CDBG Administration/Planning 271,848 551,722 430,821 32,902 178,704 Development Activities 597,205 263,496 378,352 - Capital Projects 295,000 184,564 827,211 81,607 Transfers to Debt Service 3,035 3,035 6,227 518 2,594 Transfers to General Fund 571,000 579,401 347,500 28,958 144,792 Total Expenditures 1,738,088 1,582,218 1,990,111 62,378 407,697 Net Surplus (Deficit)-$ (82,860)$ -$ (62,378)$ 2,109$ Beginning Fund Balance 12,799 (70,061) Ending Fund Balance (70,061)$ (67,953)$ City of Evanston CDBG Fund As of May 31, 2015 FY 2014 Budget Amended FY 2014 Unaudited Actual FY 2015 Budget Adopted FY 2015 YTD Actual May Actual Intergovernmental Revenue 50,000$ -$ 187,000$ 41,965$ 41,965$ Program Income 10,000 45,276 50,000 5,956 50,482 Interest Income 100 283 100 46 93 Total Revenues 60,100 45,559 237,100 47,967 92,540 - Program Expenses 20,000 39,503 237,100 300 2,361 Total Expenditures 20,000 39,503 237,100 300 2,361 Net Surplus (Deficit) 40,100$ 6,056$ -$ 47,667$ 90,179$ Beginning Fund Balance 2,354,271 2,360,327 Ending Fund Balance 2,360,327$ 2,450,506$ City of Evanston CDBG Loan Fund As of May 31, 2015 FY 2014 Budget Amended FY 2014 Unaudited Actual FY 2015 Budget Adopted FY 2015 YTD Actual May Actual Hotel Tax 1,500,000$ 1,605,130$ 1,500,000$ 285$ 657,918$ Amusement Tax 300,000 283,028 300,000 16,815 130,474 Howard-Ridge Loan Repayment 45,500 45,500 47,500 - Grants 1,000,000 - - Miscellaneous - - 65,500 3,958 21,292 Investment Income 800 2,831 3,700 10 42 Total Revenues 2,846,300 1,936,489 1,916,700 21,067 809,726 Economic Development Activities 1,610,495 1,366,337 1,584,510 81,723 283,852 Other Charges - Gigabit Challenge 1,000,000 33,718 916,000 289,078 Capital Projects 150,500 - 253,500 64,089 107,277 Transfer to Debt Service 14,271 14,271 14,782 1,232 6,159 Transfer to Insurance 66,440 66,546 17,448 1,454 7,270 Transfers to General Fund 452,707 452,707 466,288 50,000 250,000 Total Expenditures 3,294,413 1,933,579 3,252,528 198,498 943,636 Net Surplus (Deficit)(448,113)$ 2,910$ (1,335,828)$ (177,431)$ (133,910)$ Beginning Fund Balance 3,507,202 3,510,112 Ending Fund Balance 3,510,112$ 3,376,201$ City of Evanston Economic Development Fund As of May 31, 2015 FY 2014 Budget Amended FY 2014 Unaudited Actual FY 2015 Budget Adopted FY 2015 YTD Actual May Actual Taxes 20,000$ 20,000$ 20,000$ -$ -$ Interest Income - - - - - Total Revenues 20,000 20,000 20,000 - - Program Expenses 50,000 - 50,000 - - Transfers to Other Funds - - - - - Total Expenditures 50,000 - 50,000 - - Net Surplus (Deficit)(30,000)$ 20,000$ (30,000)$ -$ Beginning Fund Balance 149,915 169,915 Ending Fund Balance 169,915$ 169,915$ City of Evanston Neighborhood Improvement Fund As of May 31, 2015 FY 2014 Budget Amended FY 2014 Unaudited Actual FY 2015 Budget Adopted FY 2015 YTD Actual May Actual Intergovernmental /Entitlement 674,500$ 874,444$ 216,000$ 20,241$ 161,261$ Interest Income - 63 7 10 Program Income - 27,384 225,200 2,282 17,534 Total Revenues 674,500 901,891 441,200 22,530 178,805 Home Administration/Planning 27,836 23,381 41,171 2,183 8,413 Development Activities 650,000 923,434 400,029 40,275 128,892 Transfers to General Fund 22,500 9,468 - - - Total Expenditures 700,336 956,283 441,200 42,458 137,304 Net Surplus (Deficit) (25,836)$ (54,392)$ -$ (19,927)$ 41,501$ Beginning Fund Balance 3,942,528 3,888,136 Ending Fund Balance 3,888,136$ 3,929,637$ City of Evanston Home Fund As of May 31, 2015 FY 2014 Budget Amended FY 2014 Unaudited Actual FY 2015 Budget Adopted FY 2015 YTD Actual May Actual Developer Contributions 155,000 179,125 374,772 31,676 73,620 Rehab Repayments - 8,333 30,000 20,000 52,083 Interest Income 250 258 228 30 Miscellaneous - 11,338 - - - Total Revenues 155,250 199,054 405,000 51,676 125,734 Housing - Buildings 200,000 - - Down Payment Assistance - 48,949 350,000 75 Transfers to General Fund 13,990 13,990 - Miscellaneous 50,000 30,000 55,000 5,477 6,254 Total Expenditures 263,990 92,939 405,000 5,477 6,329 Net Surplus (Deficit)(108,740)$ 106,115$ -$ 46,199$ 119,404$ Beginning Fund Balance 2,451,078 2,557,193 Ending Fund Balance 2,557,193$ 2,676,597$ City of Evanston Affordable Housing Fund As of May 31, 2015 FY 2014 Budget Amended FY 2014 Unaudited Actual FY 2015 Budget Adopted FY 2015 YTD Actual May Actual Net Property Tax Increment 3,700,000$ 4,969,568$ 4,900,000$ 19,612$ 2,690,556$ Interest Income 10,000 13,420 10,000 168 672 Total Revenue 3,710,000 4,982,987 4,910,000 19,780 2,691,227 Series 1997 Principal (refunded by 1999 & 2008D) 455,000 455,000 545,000 - Series 1997 Interest (refunded by 1999 and 2008D) 55,000 55,000 30,000 - Contributions to Other Agencies - - - Economic Development Projects 1,250,000 74,003 1,800,000 - Capital Improvements 722,486 246 148 Contractual Services 250,000 36,977 500,000 24,668 49,335 Transfer to Parking Fund (Sherman) 2,925,296 2,925,296 2,925,296 243,775 1,218,873 Transfer to General Fund 331,000 331,000 340,000 28,333 141,667 Total Expenditures 5,988,782 3,877,522 6,140,296 296,776 1,410,023 Net Surplus (Deficit) (2,278,782)$ 1,105,466$ (1,230,296)$ (276,995)$ 1,281,205$ Beginning Fund Balance 5,037,441 6,142,907 Ending Fund Balance 6,142,907$ 7,424,112$ City of Evanston Washington National TIF Fund As of May 31, 2015 FY 2014 Budget Amended FY 2014 Unaudited Actual FY 2015 Budget Adopted FY 2015 YTD Actual May Actual Net Property Taxes 397,800$ 428,515$ 425,000$ 2,638$ 234,124$ Interest Income - 5 300 - 1 Total Revenue 397,800 428,520 425,300 2,638 234,125 Series 2012A Bonds Principal 390,000 380,000 390,000 - - Series 2012A Bonds Interest 46,605 62,050 35,175 - - General Management Support - - - - - Total Expenditures 436,605 442,050 425,175 - - Net Surplus (Deficit)(38,805)$ (13,530)$ 125$ 2,638$ 234,125$ Beginning Fund Balance 474,885 461,355 Ending Fund Balance 461,355$ 695,480$ City of Evanston Special Service Area #5 As of May 31, 2015 FY 2014 Budget Amended FY 2014 Unaudited Actual FY 2015 Budget Adopted FY 2015 YTD Actual May Actual Net Property Tax Increment 1,100,000$ 1,140,311$ 1,150,000$ 1,906$ 633,562$ Interest Income 10,000 13,819 5,000 128 521 Total Revenue 1,110,000 1,154,130 1,155,000 2,034 634,083 1994 & 1996 Bonds Principal (refunded by 1999 and 2008D bonds)685,000 685,000 - - 1994 & 1996 Bonds Interest (refunded by 1999 and 2008D bonds)39,088 39,088 - - Surplus Distribution - 1,000,000 1,000,000 - Capital Projects 500,000 217,435 - - Other Expenses - 3,709 - - Economic Development 2,500,000 - 2,500,000 256,864 468,920 Operating Transfer to General Fund 144,400 144,400 148,010 12,334 61,671 Total Expenditures 3,868,488 2,089,632 3,648,010 269,198 530,590 Net Surplus (Deficit)(2,758,488)$ (935,502)$ (2,493,010)$ (267,164)$ 103,492$ Beginning Fund Balance 3,357,048 2,421,546 Ending Fund Balance 2,421,546$ 2,525,039$ City of Evanston SW II TIF (Howard Hartrey) As of May 31, 2015 FY 2014 Budget Amended FY 2014 Unaudited Actual FY 2015 Budget Adopted FY 2015 YTD Actual May Actual Net Property Tax Increment 485,000$ 607,662$ -$ -$ -$ Interest Income 1,000 6 - - - Total Revenue 486,000 607,668 - - - Economic Development Activities 748,439 2,223 - - - Contributions to Other Agencies 15,354 861,217 - - Capital Improvement Projects - - - - - Operating Transfer to General Fund 29,500 29,500 - - - Total Expenditures 777,939 47,077 861,217 - - Net Surplus (Deficit)(291,939)$ 560,591$ (861,217)$ -$ -$ Beginning Fund Balance 344,717 905,308 Ending Fund Balance 905,308$ 905,308$ City of Evanston Southwest TIF As of May 31, 2015 FY 2014 Budget Amended FY 2014 Unaudited Actual FY 2015 Budget Adopted FY 2015 YTD Actual May Actual Net Property Tax- Current 10,879,993$ 11,237,317$ 10,879,993$ 76,617$ 6,075,945 Special Assessment Levy 169,848 - - Bond Proceeds/Premium/ Discounts - - - Transfer from Other Funds - IMRF- 141,125 811,431 - 70,041 350,203 Miscellaneous Revenue - - 260,698 - Interest Income 1,500 11,934 1,500 896 1,682 Transfer from General Fund 1,279,306 609,000 2,108,890 117,882 589,410 Transfer from Sewer Fund 207,284 207,284 228,070 19,006 95,029 Transfer from Special Assessment Fund 169,848 169,848 146,178 - - Total Revenue 12,848,904 13,046,814 13,625,329 284,441 7,112,269 Series 2004- Principal - - - Series 2004- Interest - - - Series 2004 B- Principal - - - Series 2004 B- Interest - - - Series 2005- Principal - - - Series 2005- Interest - - - Series 2006- Principal 185,000 235,000 290,000 - Series 2006- Interest 444,776 451,225 436,912 - Series 2006 B Bonds- Principal 1,130,000 55,000 1,880,000 1,130,000 Series 2006 B Bonds- Interest 600,526 601,626 555,326 300,263 Series 2007 - Principal 1,909,709 1,949,709 1,268,711 - Series 2007 - Interest 569,684 601,677 497,052 - Series 2008A - Principal 300,000 300,000 305,000 - Series 2008A - Interest 116,225 116,225 104,975 - Series 2008C - Principal 378,180 397,980 389,640 - Series 2008C - Interest 364,514 383,598 350,332 - Series 2008D - Principal 565,600 565,600 191,320 - Series 2008D - Interest 15,362 15,362 7,299 - Series 2010 A - Principal DSF 305,000 305,000 - - Series 2010 A - Interest DSF 173,238 173,238 167,137 - Series 2010 B - Principal DSF 684,946 684,946 726,711 - Series 2010 B - Interest DSF 126,446 126,446 113,774 - Series 2011 A - Principal DSF 1,250,432 1,250,431 542,634 - Series 2011 A - Interest DSF 426,890 426,890 401,881 - Series 2012 A - Interest DSF 1,025,000 1,148,944 280,000 - Series 2012 A - Principal DSF 243,332 113,944 237,893 - Series 2013 A - Principal DSF 505,055 20,000 430,000 - Series 2013 A - Interest DSF 1,601,006 513,925 390,173 - Series 2013 B - Principal DSF 586,498 1,721,006 2,573,702 - Series 2013 B - Interest DSF - 609,653 547,159 - Series 2014A-- Principal DSF 250,000 - Series 2014A-- Interest DSF - 425,500 - Series 2004- Interest SAF - - - Series 2005- Principal SAF - - - Series 2005- Interest SAF - - - Series 2006- Principal SAF 50,000 - 50,000 - Series 2006- Interest SAF 6,450 - 4,326 - Series 2007 - Principal SAF 40,000 - 40,000 - Series 2007 - Interest SAF 31,994 - 30,394 - Series 2008C - Principal SAF 19,800 - 20,400 - Series 2008C - Interest SAF 19,084 - 18,342 - Series 2013 A - Principal SAF 20,000 - 20,000 - Series 2013 A - Interest SAF 8,867 - 6,450 - Series 2013 B - Principal SAF 120,000 - 20,000 - Series 2013 B - Interest SAF 23,500 - 15,500 - Series 2014A-- Principal SAF 25,000 - Series 2014A-- Interest SAF 10,286 - General Management and Support 1,000 - - - Bond Issuance Costs 75,000 36,250 75,000 0 - Net of Transfers - - 1,000 - Fiscal Agent Fees 10,000 42,870 25,000 0 500 Total Expenditures 13,933,114 12,846,544 13,724,829 - 1,430,763 Net Surplus (Deficit)(1,084,210)$ 200,270$ (99,500)$ 284,441$ 5,681,506$ Beginning Fund Balance 3,375,691 3,575,961 Ending Fund Balance 3,575,961$ 9,257,466$ City of Evanston Debt Service Fund As of May 31, 2015 FY 2014 Budget Amended FY 2014 Unaudited Actual FY 2015 Budget Adopted FY 2015 YTD Actual May Actual Net Property Tax Increment 350,000$ 444,587$ 545,000$ 1,995$ 287,695$ Interest Income 400 211 - 5 21 Bond Proceeds - 200,000 - Miscellaneous - 61,932 100,500 3,207 25,162 Total Revenue 350,400 506,730 845,500 5,207 312,878 Economic Dev. Projects - - 490,000 239 298,193 Debt Service - Interest - 572 600 191 Capital Improvements - 176,792 200,000 3,094 Developer Agreement Payments 300,000 544,086 3,712 Repayments to Econ. Dev. Fund 45,500 45,500 47,500 3,958 19,792 Transfers to General Fund 60,000 60,000 60,000 5,000 25,000 Total Expenditures 405,000 826,950 798,100 9,197 349,982 Net Surplus (Deficit)(54,600)$ (320,220)$ 47,400$ (3,990)$ (37,104)$ Beginning Fund Balance 388,617 68,397 Ending Fund Balance 68,397$ 31,293$ City of Evanston Howard Ridge TIF As of May 31, 2015 FY 2014 Budget Amended FY 2014 Unaudited Actual FY 2015 Budget Adopted FY 2015 YTD Actual May Actual Net Property Tax Increment 40,000$ -$ -$ Bond Proceeds - - - Loan Proceeds - 100,262 105,000 - Interest Income 100 765 100 17 70 Total Revenue 40,100 101,027 105,100 17 70 Economic Development Projects 75,000 - - Other Charges 20,000 64,173 95,000 (1,028) (4,113) Debt Service - Interest 10,000 7,027 10,000 587 2,940 Transfers to General Fund 60,000 60,000 60,000 5,000 25,000 Capital Projects - - - - - Total Expenditures 165,000 131,200 165,000 4,559 23,827 Net Surplus (Deficit)(124,900)$ (30,173)$ (59,900)$ (4,542)$ (23,758)$ Beginning Fund Balance 537,639 507,466 Ending Fund Balance 507,466$ 483,708$ City of Evanston West Evanston TIF As of May 31, 2015 FY 2014 Budget Amended FY 2014 Unaudited Actual FY 2015 Budget Adopted FY 2015 YTD Actual May Actual Net Property Tax Increment -$ -$ -$ -$ -$ Bond Proceeds - - - - - Interest Income - - - - - Total Revenue - - - - - Economic Development Projects - - - - - Total Expenditures - - - - - Net Surplus (Deficit)-$ -$ -$ -$ -$ Beginning Fund Balance - - Ending Fund Balance -$ -$ City of Evanston Dempster-Dodge TIF As of May 31, 2015 FY 2014 Budget Amended FY 2014 Unaudited Actual FY 2015 Budget Adopted FY 2015 YTD Actual May Actual Bond Proceeds 8,331,458$ 8,469,966$ 7,360,650$ -$ Grants 5,382,638 487,563 4,774,000 - Reimbursements - - 146 Private Contributions 708,000 500,000 - Parking Fund Loan for Financial System 100,000 - - General Fund Allocation 936,500 936,500 250,000 - Miscellaneous - 110,110 375,000 254 Interest Income 10,000 20,380 10,000 242 825 Total Revenue 15,468,596 10,524,520 12,769,650 242 1,225 Capital Outlay (includes prior year rollovers) 17,935,016 3,211,003 17,482,150 94,012 1,566,098 Interfund Transfers Out 475,000 475,000 550,000 40,833 204,167 Total Expenditures 18,410,016 3,686,003 18,032,150 134,845 1,770,265 Net Surplus (Deficit)(2,941,420)$ 6,838,517$ (5,262,500)$ (134,603)$ (1,769,040)$ Beginning Fund Balance 6,299,999 13,138,516 Ending Fund Balance 13,138,516$ 11,369,476$ City of Evanston Capital Improvement Fund As of May 31, 2015 FY 2014 Budget Amended FY 2014 Unaudited Actual FY 2015 Budget Adopted FY 2015 YTD Actual May Actual Special Assessments Collected 230,000$ 111,780$ 230,000$ 3,114$ 66,415$ Bond Proceeds 250,000 506,435 250,000 21,122 Investment Income 1,200 2,849 1,200 229 599 Total Revenue 481,200 621,064 481,200 3,343 88,136 Transfer to Debt Service Fund 169,848 169,848 501,000 - Transfer to Other Funds 260,698 - General Management & Support 1,000 3,871 95 Capital Outlay 500,000 1,050 - 650 650 Total Expenditures 670,848 174,769 761,698 650 745 Net Surplus (Deficit)(189,648)$ 446,295$ (280,498)$ 2,693$ 87,391$ Beginning Fund Balance 2,072,415 2,518,710 Ending Fund Balance 2,518,710$ 2,606,101$ City of Evanston Special Assessment Fund As of May 31, 2015 FY 2014 Budget Amended FY 2014 Unaudited Actual FY 2015 Budget Adopted FY 2015 YTD Actual May Actual Parking Lots & Meters Operations 3,070,000$ 3,098,797 3,070,000$ $40,219.23 $997,653.15 Church Street Garage Operations 716,348 647,461 716,348 $65,318.89 $275,051.42 Maple Avenue Garage Operations 1,204,200 1,264,678 1,204,200 $83,034.40 $449,768.80 Sherman Avenue Garage Operations 1,417,275 1,447,655 1,417,275 $118,353.76 $631,979.59 Washington National TIF Interfund Transfers-In 2,925,296 2,925,296 2,925,296 243,774.67 1,218,873.35 Interest Income 15,070 31,645 15,070 Miscellaneous Revenue 11,400 5,700 11,400 - Reserve for Future Repairs (Contra Depreciation) 2,034,004 - 2,034,004 - - Total Revenue 11,393,593 9,421,233 11,393,593 550,701 3,573,326 7005 - Parking System Administration 976,363 926,727 1,172,138 75,835 457,179 7015 - Parking Lots and Meters 972,266 901,467 1,213,609 98,036 337,526 7025 - Church Street Self Park 624,855 417,314 629,856 146,088 172,022 7030 - Church Street Debt Payments 171,250 174,100 176,400 - 7036 - Sherman Avenue Garage 5,047,016 3,270,463 5,778,052 365,421 483,602 7037 - Maple Avenue Garage 1,654,244 912,940 1,658,921 296,988 340,696 7039 - Parking Debt 27,461 774,243 29,482 - Transfer to Insurance Fund 319,648 319,649 319,648 26,637 133,187 Transfer to General Fund 869,242 869,242 870,000 72,500 362,500 Transfer to Fleet 21,991 21,992 24,188 1,924 4,601 Transfer to Equipment Replacement 30,000 30,000 30,000 2,500 6,250 Loans to Other Funds - - - DIVVY Expenses - - 252,000 - Capital Outlay - - - Capital Improvements 5,180,000 980,659 3,505,000 - - Total Expenditures 15,894,336 9,598,796 15,659,294 1,085,931 2,297,563 Net Surplus (Deficit)(4,500,743)$ (177,562)$ (4,265,701)$ (535,230)$ 1,275,764$ Further Operating Expense Breakdown: 7015 Parking Meter Activities 762,846 901,467 1,176,957 61,384 300,874 7015 Parking Meter Depreciation 36,652 - 36,652 36,657 36,654 SUBTOTAL 799,498 901,467 1,213,609 98,041 337,528 7025- Church Garage Activities 494,156 417,314 449,928 (33,840) (7,906) 7025- Church Garage Depreciation 179,928 - 179,928 179,933 179,930 SUBTOTAL 674,084 417,314 629,856 146,093 172,024 7036 Sherman Garage Activities 1,199,756 20,463 1,199,802 (4,212,829) (4,094,648) 7036 Debt Service Payments 3,250,300 3,250,000 3,703,600 3,703,600 3,703,600 7036 Reserve (Depreciation)874,650 - 874,650 874,650 874,650 SUBTOTAL 5,324,706 3,270,463 5,778,052 365,421 483,602 7037 Maple Garage Activities 1,013,991 912,940 992,723 (369,210) (325,502) 7037 Debt Service Payments - - - - - 7037 Reserve (Depreciation)666,198 - 666,198 666,198 666,198 SUBTOTAL 1,680,189 912,940 1,658,921 296,988 340,696 Beginning Unrestricted Fund Balance 13,602,819 13,425,257 Ending Unrestricted Fund Balance 13,425,257$ 14,701,020$ City of Evanston Parking Fund As of May 31, 2015 FY 2014 Budget Amended FY 2014 Unaudited Actual FY 2015 Budget Adopted FY 2015 YTD Actual May Actual Evanston 6,252,400$ 6,411,278$ 6,983,000$ 384,553$ 2,741,866$ Skokie 2,913,000 2,805,425 2,970,000 233,280 1,115,324 Northwest Commission 4,653,000 5,074,770 5,300,000 440,446 2,103,182 Cross Connection Control Fees 95,000 116,865 120,000 (35) Investment Earnings 2,500 25,542 10,000 171 1,079 Debt Proceeds 4,000,000 2,897,048 6,100,000 - Debt Proceeds (zero interest)2,000,000 6,190,000 - Fees and Merchandise Sales 45,000 107,862 70,000 5,759 46,833 Fees and Outside Work 70,000 118,038 70,000 5,813 39,019 Water Meter Impact Fees - 14,181 50,000 802 45,199 Grants - - - Insurance Reimbursements - 44,518 - - Phosphate Sales 69,000 180,403 45,000 3,304 16,028 Property Sales and Rentals 227,316 104,700 146,100 - Misc Revenue - - 5,000 3,361 4,065 Total Revenue 20,327,216 17,900,630 28,059,100 1,077,490 6,112,560 General Support 933,989 1,006,754 983,266 79,810 384,682 Pumping 2,355,718 2,036,923 2,426,701 229,679 749,408 Filtration 2,740,856 2,330,548 2,633,653 169,812 884,568 Distribution 1,425,352 1,451,081 1,724,142 112,299 554,639 Meter Maintenance 300,761 273,492 193,336 13,033 94,559 Other Operating Expenses 859,801 425,774 997,000 20,528 106,405 Debt Service 1,297,704 1,102,833 978,894 - Debt Service - IEPA Loan 3382 67,504 67,506 67,505 33,752 Capital Improvements 10,170,000 6,090,603 18,402,600 75,776 261,089 Interfund Transfers Out - General Fund 3,369,559 3,369,559 3,194,053 266,171 1,330,855 Interfund Transfers Out - Insurance Fund 468,492 468,493 468,492 39,041 195,205 Total Expense 23,989,736 18,623,567 32,069,642 1,006,149 4,595,163 Net Surplus (Deficit)(3,662,520)$ (722,936)$ (4,010,542)$ 71,341$ 1,517,397$ Beginning Unrestricted Fund Balance 8,590,091 7,867,155 Reclassification to Fund Balance from Capital Assets - Ending Unrestricted Fund Balance 7,867,155$ 9,384,551$ City of Evanston Water Fund As of May 31, 2015 FY 2014 Budget Amended FY 2014 Unaudited Actual FY 2015 Budget Adopted FY 2015 YTD Actual May Actual Operations 12,922,700$ 13,053,859$ 13,072,700$ 689,796$ 5,022,009$ Debt Proceeds - - - - Debt Proceeds - 2012 IEPA Loan 2,190,000 1,612,079 - - Investment Earnings 1,000 3,221 1,000 305 722 Miscellaneous 4,165 - 4,165 (77) Grant Revenue - - - - - Total Revenue 15,117,865 14,669,159 13,077,865 690,100 5,022,654 Sewer Operations 2,260,545 2,004,711 1,779,750 $173,546.52 591,116 Public Education - Other Operating Expenses 129,500 - 103,300 $3,305.66 37,886 Interfund Transfers Out - General Fund 145,044 145,044 320,550 26,712.50 133,563 Interfund Transfers Out - Insurance Fund 269,988 269,988 269,988 22,499.00 112,495 Transfer to Debt Service 207,284 207,284 228,070 19,005.83 95,029 Capital Outlay 47,500 - 13,500 (64,960) Depreciation - - - Capital Improvement Account 3,225,000 2,086,176 1,055,000 - Debt Service 9,994,260 9,910,255 9,619,477 1,407,719 4,012,177 Total Expenses 16,279,121 14,623,458 13,389,635 1,652,789 4,917,305 Net Surplus (Deficit)(1,161,256)$ 45,701$ (311,770)$ (962,688)$ 105,349$ Beginning Unrestricted Fund Balance 4,574,996 - 4,620,697 Ending Unrestricted Fund Balance 4,620,697$ 4,726,046$ City of Evanston Sewer Fund As of May 31, 2015 FY 2014 Budget Amended FY 2014 Unaudited Actual FY 2015 Budget Adopted FY 2015 YTD Actual May Actual Transfer from General Fund 1,055,967$ 1,055,967$ 1,055,967$ 87,997$ 439,986$ Solid Waste Franchise Fees 175,000 125,497 175,000 147,846 SWANCC Recycling Incentive 25,000 20,852 4,000 24,416 Recycling Service Charge 3,334,033 3,410,124 3,467,394 270,184 1,413,235 Sanitation Service Charge Penalty 45,000 54,319 45,000 11,762 21,463 Special Pickup Fees 100,000 74,140 100,000 8,523 Trash Cart Sales 15,000 17,991 15,000 5,010 12,954 Investment Income - - - Yard Waste Fees 220,000 236,842 220,000 4,397 17,055 Total Revenue 4,970,000 4,995,732 5,082,361 379,350 2,085,477 Refuse Collection & Disposal 3,372,698 2,894,995 3,209,621 197,518 667,181 Residential Recycling Collection 1,186,134 1,283,871 1,281,949 255,739 632,510 Yard Waste Collection 750,250 675,857 700,250 140,905 707,467 Total Expense 5,309,082 4,854,723 5,191,820 594,162 2,007,159 Net Surplus (Deficit)(339,082)$ 141,009$ (109,459)$ (214,811)$ 78,319 Beginning Unrestricted Fund Balance (1,283,560) (1,142,551) Ending Unrestricted Fund Balance (1,142,551)$ (1,064,232) City of Evanston Solid Waste As of May 31, 2015 FY 2014 Budget Amended FY 2014 Unaudited Actual FY 2015 Budget Adopted FY 2015 YTD Actual May Actual General Fund 2,507,356$ 2,507,358$ 2,631,999$ $ 219,394 1,096,969$ Library Fund 2,381 2,381 2,500 208.34 1,042 Parking Fund 21,992 21,992 24,188 1,924.30 9,622 Water Fund 122,751 122,751 135,023 10,740.71 53,704 Sewer Fund 177,729 177,729 195,501 15,551.29 77,756 Solid Waste Fund 29,071 298,071 327,877 26,081.21 130,406 Damage to City Property 24,798 - 24,798 - Miscellaneous Revenue 10,000 50,010 56,781 5,703 16,193 Interest Income 1,000 - 1,000 - - Total Revenues 2,897,078 3,180,292 3,399,667 279,603 1,385,691 General Support 293,619 272,014 288,995 18,433 100,096 Major Maintenance 3,284,528 3,132,678 3,255,342 196,183 1,000,628 Total Expenditures 3,578,147 3,404,691 3,544,337 214,617 1,100,724 Net Surplus (Deficit)(681,069)$ (224,399)$ (144,670)$ 64,986$ 284,967$ Beginning Fund Balance 110,566 (113,833) Reclassification from Fund Balance to Capital Assets - Ending Fund Balance (113,833)$ 171,133$ City of Evanston Fleet Maintenance Fund As of May 31, 2015 FY 2014 Budget Amended FY 2014 Unaudited Actual FY 2015 Budget Adopted FY 2015 YTD Actual May Actual General Fund 1,242,590$ 1,242,590$ 1,242,590$ 103,549$ 517,746$ Library Fund 1,700 1,700 1,700 142 708 Parking Fund 30,000 30,000 30,000 2,500 12,500 Solid Waste Fund 177,131 177,131 177,131 14,761 73,805 Bond Premiums - 72,810 - - Bond Proceeds 1,000,000 1,000,000 1,000,000 - Sale of Surplus Property 210,217 53,210 210,217 4,666 45,035 Total Revenues 2,661,638 2,577,440 2,661,638 125,618 649,794 Capital Outlay 2,494,000 1,847,648 1,515,422 243,892 Carryover 200,000 - - - Settlement Costs - 15,290 - - Bond Costs 7,212 - Capital Leases 50,000 29,509 - 2,997 2,997 Total Expenditures 2,744,000 1,899,659 1,515,422 2,997 246,889 Net Surplus (Deficit)(82,362)$ 677,781$ 1,146,216$ 122,621$ 402,905$ Beginning Fund Balance 588,983$ 1,266,764$ Reclassification from Capital Assets to Fund Balance -$ Ending Fund Balance 1,266,764$ 1,669,669$ City of Evanston Equipment Replacement Fund As of May 31, 2015 FY 2014 Budget Amended FY 2014 Unaudited Actual FY 2015 Budget Adopted FY 2015 YTD Actual May Actual General Admin Contribution- General 121,204 121,204 121,204 10,100$ 50,502 General Admin Contribution- E911 930 930 930 78 388 General Admin Contribution- CDBG 930 930 930 78 388 General Admin Contribution- E.D.930 930 930 78 388 General Admin Contribution- Parking 17,032 17,032 17,032 1,419 7,097 General Admin Contribution- Water Fund 24,962 24,962 24,962 2,080 10,401 General Admin Contribution- Sewer Fund 14,385 14,385 14,385 1,199 5,994 Liability/Property Contribution- General 909,150 909,150 909,150 75,763 378,813 Liability/Property Contribution- E911 6,972 6,972 6,972 581 2,905 Liability/Property Contribution- CDBG 6,972 6,972 6,972 581 2,905 Liability/Property Contribution- E.D.6,972 6,972 6,972 581 2,905 Liability/Property Contribution- Parking 127,731 127,731 127,731 10,644 53,221 Liability/Property Contribution- Water Fund 187,209 187,209 187,209 15,601 78,004 Liability/Property Contribution- Sewer Fund 107,887 107,887 107,887 8,991 44,953 Workers' Comp Contribution- General 1,244,860 1,244,862 1,244,860 103,739 518,692 Workers' Comp Contribution- Library Fund 40,000 40,000 40,000 - - Workers' Comp Contribution- E911 9,546 9,546 9,546 796 3,978 Workers' Comp Contribution- CDBG 9,546 9,546 9,546 796 3,978 Workers' Comp Contribution- E.D.9,546 9,546 9,546 796 3,978 Workers' Comp Contribution- Parking 174,886 174,886 174,886 14,574 72,869 Workers' Comp Contribution- Water Fund 256,322 256,322 256,322 21,360 106,801 Workers' Comp Contribution- Sewer Fund 147,716 147,716 147,716 12,310 61,548 Subrogation Proceeds 100,000 93,265 100,000 2,875 27,497 Yearend Transfer from General Fund - - Transfer from General Fund - Casualty Loss Acct - - Investment Income 1,000 283.54 1,000 9 75 Workers Comp & Liability - Subtotal 3,526,688 3,519,238 3,526,688 285,025 1,438,276 Health Insurance Chargebacks- General 8,780,657 8,872,974 8,646,184 870,070 3,919,932 Health Insurance Chargebacks - Library 366,065 366,066 448,539 - Health Insurance Chargebacks - NSP2 6,863 6,863 5,608 - Health Insurance Chargebacks- E911 71,410 71,410 76,210 - Health Insurance Chargebacks- CDBG 31,521 31,521 40,860 - Health Insurance Chargebacks- E.D. Fund 49,098 49,098 76,165 - Health Insurance Chargebacks- Home Fund 2,735 2,735 - - Health Insurance Chargebacks- Parking 171,325 171,326 169,672 - Health Insurance Chargebacks- Water 616,227 616,227 674,154 - Health Insurance Chargebacks- Sewer 183,218 183,218 133,241 - Health Insurance Chargebacks - Solid Waste 106,846 106,846 126,389 - Health Insurance Chargebacks- Fleet 202,427 202,427 185,634 - Legal Settlements 75,000 75,000 Retiree Health Insurance Contributions 1,970,647 1,515,464 1,970,647 182,629 666,494 Employee Health Insurance Contributions 1,706,017 1,247,797 1,706,017 95,500.56 441,940 SWANNC-Health Insurance Contributions - 69,956 77,000 6,930 34,652 One Time IPBC Distribution 300,000 800,000 - 25,000 125,000 Health & Life insurance - Subtotal 14,565,056 14,313,927 14,336,320 1,255,130 5,263,018 Total Revenues 18,091,744 17,833,166 17,863,008 1,540,155 6,701,294 City of Evanston Insurance Fund As of May 31, 2015 FY 2014 Budget Amended FY 2014 Unaudited Actual FY 2015 Budget Adopted FY 2015 YTD Actual May Actual City of Evanston Insurance Fund As of May 31, 2015 FY 2014 Budget Amended FY 2014 Unaudited Actual FY 2015 Budget Adopted FY 2015 YTD Actual General Administration & Support 501,548 381,664 530,892 (72,423) 39,844 Auditing - - - Liability/Property Insurance Premiums 470,000 490,916 490,000 601,724 Liability Legal Fees 350,000 732,752 350,000 355,783 Liability Settlement Payments 400,000 1,049,237 400,000 17,040 Transfer - to ERI Debt Service 8,627 8,627 8,936 2,979 Workers' Comp Insurance Premiums 114,400 118,755 120,000 .00 1,735 Workers' Comp Legal Fees 8,500 47,774 70,000 2,088.00 17,671 Workers' Comp Medical Payments 600,000 590,413 650,000 16,682.25 185,940 Workers' Comp Settlement Payments 1,100,000 502,782 900,000 74,131.91 144,375 Workers' Comp TPA Pymts (non specific)125,000 107,025 - - Workers' Comp TTD Pymts (non sworn)- 102,847 50,000 5,892.45 42,209 Workers' Comp & Liability - Subtotal 3,678,075 4,132,792 3,569,828 26,372 1,409,300 General Administration & Support 99,805 99,104 98,124 10722 63,543 Health Insurance Premiums 14,197,604 13,329,951 13,450,000 1095534 5,471,164 Health Insurance Opt Out Payments 91,800 11,578 91,800 - - Health & Life Insurance - Subtotal 14,389,209 13,440,632 13,639,924 1,106,256 5,534,707 Total Expenditures 18,067,284 17,573,424 17,209,752 1,132,628 6,944,007 Net Surplus (Deficit)24,460$ 259,742$ 653,256$ 407,527$ (242,713)$ Beginning Unrestricted Fund Balance (3,727,663) (3,467,921) Adjustment to GAAP Basis of Accounting - Ending Unrestricted Fund Balance (3,467,921)$ (3,710,634)$ May Actual Property Taxes 6,061,575 6,130,815$ 6,061,575 40,338$ 3,284,215$ Personal Property Repl Tax 280,000 280,000 280,000 77,658 241,261 Interest on Investment 850,000 1,179,581 850,000 10 35 Participant Contributions 950,000 919,874 978,500 73,895 360,794 Unrealized Gain - 5,000 - - Miscellaneous - - - - - Total Revenue 8,141,575 8,515,270 8,170,075 191,901 3,886,305 Administrative Expenses 204,000 239,016 150,000 2,712 23,959 Legal Fees - - - - Retiree Pensions 4,995,500 5,294,497 5,150,000 461,442 2,308,269 Widows' Pensions 1,071,200 1,071,910 1,103,130 89,753 445,742 Disability Pensions 1,358,125 1,266,624 1,390,500 106,878 534,590 QUILDRO 90,000 94,651 93,000 7,902 39,512 Reserve for Future Payments - - - - - Total Expenditures 7,718,825 7,966,699 7,886,630 668,687 3,352,073 Net Surplus (Deficit)422,750$ 548,571$ 283,445$ (476,787)$ 534,232$ Beg Net Assets held in Trust 58,463,916 65,024,941 65,573,512 65,573,512 End Net Assets held in Trust 58,886,666$ 65,573,512$ 65,856,957$ 66,107,744$ City of Evanston Fire Pension Fund As of May 31, 2015 FY 2014 Budget Amended FY 2014 Unaudited Actual FY 2015 Budget Adopted FY 2015 YTD Actual May Actual Property Taxes 8,069,325$ 8,165,661$ 8,069,325$ 53,862$ 4,372,391$ Personal Property Repl Tax 325,000 325,000 325,000 77,658 241,261 Interest Income 2,800,000 2,629,077 2,800,000 12 32 Participant Contributions 1,423,000 1,565,052 1,423,000 111,454 563,243 Miscellaneous - - - - Unrealized Gain / (Loss) - - - - - Total Revenue 12,617,325 12,684,791 12,617,325 242,986 5,176,927 Administrative Expenses 250,000 366,885 250,000 - Retiree Pensions 8,056,000 8,198,627 8,394,500 716,809 3,580,562 Widow Pensions 875,500 911,335 902,000 81,719 409,593 Disability Pensions 700,000 644,450 700,000 54,254 271,271 Separation Refunds 275,000 114,915 275,000 - QUILDRO 18,000 21,717 21,000 1,864 9,320 Reserve for Future Payments - - - - - Total Expenditures 10,174,500 10,257,931 10,542,500 854,646 4,270,746 Net Surplus (Deficit)2,442,825$ 2,426,860$ 2,074,825$ (611,660)$ 906,180$ Beg Net Assets held in Trust 80,589,961 90,763,143 93,190,003 93,190,003 End Net Assets held in Trust 83,032,786$ 93,190,003$ 95,264,828$ 94,096,184$ City of Evanston Police Pension Fund As of May 31, 2015 FY 2014 Budget Amended FY 2014 Unaudited Actual FY 2015 Budget Adopted FY 2015 YTD Actual May Actual Revenue By Source Allocation - Property Taxes 5,032,097 5,205,279$ 5,813,505 35,823 2,756,131 Library Fines & Fees 164,000 150,039 156,000 9,868 63,846 Library Material Replacement 14,000 12,124 12,000 795 4,191 Copy Machine Charges 21,200 16,541 17,500 875 6,352 Meeting Room Fees 10,400 15,322 12,500 195 4,375 Non-resident Cards 1,040 260 1,300 - North Branch Rental Income 60,000 23,978 22,360 2,063 8,567 State Per Capita Grant 94,177 97,108 94,177 14,085 19,085 Personal Property Repl. Tax 50,200 50,200 50,200 - Video Rentals - - - - Book Sales - 59,148 - 1,128 21,589 Merchandise Sale - - - 163 Fund for Excellence 65,000 128,402 57,000 260 2,635 Grants and Donations 125,000 94,962 135,000 32,975 Transfer from Economic Development 116,544 9,900 89,150 - Miscellaneous - 3,151 307 739 Transfer from Endowment 159,315 199,315 171,000 - - Total Revenues 5,912,973 6,065,728 6,631,692 65,399 2,920,647 Expenditures Youth Services 1,030,009 921,614 1,069,764 $73,117.76 357,515 Adult Services 1,514,037 1,556,433 1,640,492 $106,424.73 549,135 Circulation 573,258 533,548 653,666 $48,234.67 231,048 Neighborhood Services 456,527 438,372 527,618 $35,483.11 171,462 Technical Services 538,878 506,203 658,530 $35,480.02 207,672 Maintenance 660,702 725,939 469,204 $57,180.82 300,203 Administration 1,103,016 1,078,051 1,298,268 $93,176.61 444,668 Library Grants 36,546 30,885 14,150 $6,937.05 11,433 Total Expenditures 5,912,973 5,791,044 6,331,692 456,035 2,273,137 Net Surplus (Deficit)-$ 274,685$ 300,000$ (390,636)$ 647,510$ Beginning Fund Balance 1,001,265 1,275,950 Ending Fund Balance 1,275,950 1,923,460 City of Evanston Library Fund As of May 31, 2015 FY 2014 Budget Amended FY 2014 Unaudited Actual FY 2015 Budget Adopted FY 2015 YTD Actual May Actual Revenue By Source Net Property Taxes 748,178$ 746,112$ 605,138$ 323,840$ Investment Income 1,000 - 1,000 - - Total Revenues 749,178 746,112 606,138 - 323,840 Expenditures Miscellaneouse - - - 2,805 63,990 Principal on Bonds 643,039 641,811 52,100 - Interest on Bonds 105,139 106,710 85,038 - Total Expenditures 748,178 748,521 137,138 2,805 63,990 Net Surplus (Deficit)1,000$ (2,409)$ 469,000$ (2,805)$ 259,850$ Beginning Fund Balance - (2,409) Ending Fund Balance (2,409) 257,441 City of Evanston Library Debt Fund As of May 31, 2015 FY 2014 Budget Amended FY 2014 Unaudited Actual FY 2015 Budget Adopted FY 2015 YTD Actual 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$ FY 2014 Unreserved Fund Balance 17,321,904$ 17,910,959$ 21,166,294$ 20,395,607$ 20,882,214$ FY 2015 Cash Balance 5,232,590$ 6,567,371$ 10,786,783$ 8,666,475$ 8,237,917$ FY 2014 Cash Balance 4,173,079$ 6,745,425$ 10,059,258$ 9,101,839$ 8,474,680$ $- $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