The URL can be used to link to this page

Home My WebLink About2014.05 May Monthly Reportcity off Memorandum Evanston To: Wally Bobkiewicz, City Manager Martin Lyons, Assistant City Manager/Chief Financial Officer From: Ashley Porta, Budget Manager Hitesh Desai, Accounting Manager Subject: May 2014 Monthly Financial Report Date: July 11, 2014 Please find attached the unaudited financial statements as of May 31, 2014. A summary by fund for total revenues, expenditures/expenses, fund balances, and cash balances is as follows: Fund Name Fund # General 100 $ General Assistance Fund 175 Neighborhood Stabilization 195 Motor Fuel 200 Emergency 911 205 SSA#4 210 CDBG 215 CDBG Loan 220 Economic Development 225 Neighborhood Improvement 235 Home 240 Affordable Housing 250 Washington National TIF 300 SSA#5 305 SW II TIF (Howard Hartrey) 310 Southwest TIF 315 Debt Service 320 Howard Ridge TIF 330 West Evanston TIF 335 Dempster -Dodge TIF 340 Capital Improvement 415 Special Assessment 420 Parking 505 Water 510-513 Sewer 515 Solid Waste 520 Fleet 600 Equipment Replacement 601 Insurance 605 Library 185 Library Debt Fund 186 Total** $ YTD 5/31/2014 Revenue 37,407,246 1,256,940 758,275 498,378 183,388 347,501 22,098 792,234 325,893 97,538 2,407,234 247,928 627,754 261,365 6,716,734 272,172 42 YTD YTD 5/31/2014 5/31/2014 Expenses Net $ 33,611,469 $ 3,795,777 430,554 826,386 347,083 411,192 440,619 57,759 160,000 23,388 472,243 (124,742) 20,786 1,312 554,839 237,395 335,812 6,204 1,381,458 61,653 12,292 380,458 367,020 27,915 (9,919) 91,333 1,025,777 247,928 566,102 249,074 6,336,277 (94, 849) (27,873) 5/31/2014 Unreserved Fund Balance $ 20,882,214 367,776 790,783 1,723,760 1,199,005 (147, 380) (345, 926) 2,277,358 3,322,102 149,915 3,412,703 2,568,643 6,125,454 689,966 3,907,516 582,148 9,693,059 573,152 515,241 5/31/2014 Cash Balance* 8,474,680 367,776 668,574 1,886,157 1,013,193 (156,813) (290,666) 116,143 3,201,063 149,915 254 829,719 5,655,817 661,506 3,907,516 582,148 8,192, 370 282,116 509,767 880,777 1,225,537 (344,760) 5,243,844 6,539,567 90,978 70,770 20,208 2,092,301 2,088,627 3,775,954 2,509,425 1,266,529 14, 554, 350 14, 965,162 6,391,225 5,919,542 471,682 9,115,941 9,060,085 6,520,147 5,127,215 1,392,932 5,436,735 3,544,720 2,000,887 1,777,478 223,409 (869,742) (1,481,987) 1,322,950 1,317,995 4,955 114,398 (492,475) 631,214 250,826 380,387 1,926,715 969,369 7,297,014 7,156,435 140,579 (6,525,332) 890,973 2,484,214 2,120,165 396,370 1,220,403 670,532 396,370 - 396,370 396,370 396,370 83,618,079 $ 66,085,793 $17,564,607 $ 90,597,103 $ 73,202,178 *This is net of any interfund receivables/payables **This summary does not include the Police or Fire Pension Funds even though detailed reports are included. Included above are the ending balances as of May 31, 2014 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 May 31, 2014, the General Fund is reporting a surplus of $3,795,777, However, due to the timing of payroll, the City will have 3 pay dates in December 2014 (December 4, 18 and 31), which will reduce this surplus. Staff will continue to report on the actual expenses incurred each month along with this anticipated higher expense in December 2014. Through May 31, 2014, the Special Service Area (SSA) #4 Fund is showing a negative cash balance of $156,813. Through May 31, 2014, the Community Development Block Grant (CDBG) Fund is showing a negative fund balance of $345,926 and a negative cash balance of $290,666. During the month of June, the City received only $7,250 from HUD which will have a little impact on the negative cash balance. But, the City has now received the approval from HUD to draw an additional $315,000. Through May 31, 2014, the Economic Development Fund is showing a fund balance of $3,322,102 and a cash balance of $3,201,063. These balances include approximately $1 million of revenue associated with the Gigabit Challenge. Through May 31, 2014, the Solid Waste Fund is showing a negative fund balance of $869,742 and a negative cash balance of $1,481,987. Though operating at a surplus for the year, through May 31, 2014 the Fleet Fund is showing a negative cash balance of $492,475. Through May 31, 2014, the Insurance Fund is showing a negative fund balance of $6,525,332. This negative balance is primarily for claims/cases being expensed. These claims/cases have not been settled, and therefore there is no guarantee the City will actually experience this negative fund balance as estimated. Please note, the City's annual liability and property insurance payments, totaling $601,314, were paid in January, which further reduced the fund balance of the Insurance Fund. These payments will gradually be reimbursed through FY 2014 from interfund transfers to the Insurance Fund. Staff will continue to monitor the Insurance Fund and provide regular updates to the City Council in the future. If there are any questions on the attached report, please contact me by phone at (847) 859-7884 or by email: aoorta(cr citvofevanston.oro. Detailed fund summary reports can be found at the following link: htta://www.citvofevanston.oro/city-budoet/financial- reports/. CERTIFICATION OF ATTACHED FINANCIAL REPORTS As required per Illinois Statute 65 ILCS 5/3.1-35-45 I, Martin Lyons, Treasurer of the City of Evanston, hereby affirm that I have reviewed the May 31, 2014 year-to-date financial information and reports which to the best of my knowledge appear accurate and complete. Martin Lyons, Treasu2� Report of Budget -to -Actual Revenues and Expenditures As of May 31, 2014 (Target is 41.66% of FY 2014 Budget) General Fund Panting Fund Water Fund Sewer Fund Solid Waste Fund % of % of % of % of % of Revenues Budqet Actual Budget Budqet Actual Budget Budget Actual Budget Budget Actual Budget Budget Actual Budget Property Tax $ 12,271,386 $ 6,590,403 53.7% $ $ $ $ $ $ $ $ Sales Tax 15,790,000 5,818,679 35.9% State Income Tax 7,076,170 3,463,327 48.9% Utility Tax 8,220,000 3,878,827 47.2% Real Estate Transfer Tax 2,875,000 901,919 31.4% Liquor Tax 2,375,000 1,127,663 47.5% Other Taxes 5,940,053 2,110,089 35.5% Licenses, Permits, Fees 12,622,280 4,410,805 34.9% - _ Charges for Services 7,936,754 3,603,063 45.4% 6,434,293 2,557,081 39.7% 13,913,400 6,201,048 44.6% 12,922,700 5,367,343 41.5% 3,889,033 1,558,872 40.1% Intergovernmental Revenues 721,272 400,936 55.6% - - - - - - 25,000 2,029 8.1% Interfund Transfers 7,742,893 3,276,023 42.3% 2,925,296 1,218,873 41.7% - - - - 1,055,967 439,986 41.7% Other Non -Tax Revenue 5,614,490 1,825,513 32.5% 2,034,004 - 0.0% 6,413,816 190,177 3.0% 2,191,000 292,451 13.3% - - Total Revenues $ 89,185,298 $ 37,407,246 41.9% $ 11,393,593 $ 3,775,954 33.1% $ 20,327,216 $ 6,391,225 31.4% $ 15,113,700 $ 5,659,794 37.4% $ 4,970,000 $ 2,000,887 40.3% Expenditures Legislative $ 677,621 $ 263,270 38.9% $ - $ $ _ $ _ $ $ $ $ City Administration 1,941,115 626,834 32.3% Law Department 1,045,232 372,358 35.6% Administrative Services Department 8,826,606 2,716,611 30.8% Community Development 2,652,887 907,908 34.2% Police Department 26,876,444 10,676,556 39.7% Fire & Life Safety Services 14,072,488 5,729,717 40.7% Health Department 3,009,286 992,055 33.0% - _ PublicWorks- Operating 17,884,613 7,101,845 39.7% 10,714,333 2,509,425 23.4% 5,309,082 1,777,478 33.5% Public Works -Capital Outlay - - 5,180,000 - 0.0% Parks, Recreation & Comm. Services 10,483,281 3,556,328 33.9% - Capital lmprovementTransfer 936,500 390,208 41.7% Transfer to Debt Service Fund 609,000 277,779 45.6% _ _ Utilities -Operating - - 13,451,635 5,888,411 43.8% 13,006,620 5,019,574 38.6% Utilities - Capital Outlay - - - - 10,538,100 31.132 0.3% 3,272,500 107,640 3.3% - - Total Expenditures $ 89,015,073 $ 33,611,469 37.8% $ 15,894,333 $ 2,509,425 15.8% $ 23,989,735 $ 5,919,542 24.7% $ 16,279,120 $ 5,127,215 31.5% $ 5,309,082 $ 1,777,478 33.5% City of Evanston General Fund As of May 31, 2014 FY 2013 FY 2013 FY 2014 FY 2014 Budget Unaudited Budget YTD Amended Actual Adopted Actual Tax -Property $ 12,481,386 $ 12,191,575 $ 12,271,386 $ 6,590,403 Tax - State Use 1,176,879 1,259,865 1,241,753 419,274 Tax - Sales Tax - Basic 9,291,000 9,717,393 9,690,000 3,601,181 Tax - Sales Tax - Home Rule 5,861,800 5,964,747 6,100,000 2,217,498 Tax - Auto Rental 40,000 43,598 40,000 14,997 Tax - Athletic Contest 760,000 1,056,355 800,000 - Tax - State Income 6,322,645 7,182,793 7,076,170 3,463,327 Tax - Electric Utility 3,069,806 3,000,629 3,070,000 1,288,021 Tax - Natural Gas Utility 1,400,000 1,090,915 1,200,000 874,594 Tax - Natural Gas Use - Home Rule 800,000 760,734 800,000 466,783 Tax - Cigarette 485,000 153,000 300,000 60,000 Tax - Evanston Motor Fuel 707,667 634,196 610,000 312,878 Tax -Liquor 2,350,000 2,261,874 2,375,000 1,127,663 Tax - Parking 2,200,000 2,418,852 2,350,000 990,362 Tax - Personal Property Replacement 591,600 529,146 598,300 312,579 Tax - Real Estate Transfer 2,146,300 3,894,599 2,875,000 901,919 Tax -Telecommunications 3,244,500 2,871,370 3,150,000 1,249,428 License Fees - Vehicles 2,600,000 2,349,686 2,700,000 424,596 License Fees - Other 1,030,502 1,427,834 937,302 455,884 Permit Fees - Building 3,020,000 3,951,048 6,142,162 1,959,138 Permit Fees - Other 1,209,788 1,746,109 1,486,716 844,518 Other Fees 1,559,350 1,152,472 1,356,100 726,669 Fines and Forfeiture Revenue 4,366,022 3,451,887 4,366,022 1,406,545 Charges for Services Revenue 7,904,198 7,845,622 7,936,754 3,603,063 Intergovernmental Revenue 786,798 1,425,905 721,272 400,936 Other Revenue 1,418,443 919,287 1,238,468 401,147 Interfund Transfers In (Other Funds) 7,693,367 7,521,427 7,742,893 3,276,023 Interest Income 6,000 29,207 10,000 17,822 Total Revenue 84,523,051 86,852,125 89,185,298 37,407,246 Legislative 657,069 657,069 677,621 263,270 City Administration 1,582,580 1,582,580 1,941,115 626,834 Law Department 973,254 973,254 1,045,232 372,358 Administrative Services Department 7,721,650 7,721,650 8,826,606 2,716,611 Community and Economic Development 2,536,250 2,536,250 2,652,887 907,908 Police Department 26,508,585 26,508,585 26,876,444 10,676,556 Fire & Life Safety Services Department 14,142,078 14,142,078 14,072,488 5,729,717 Health Department 2,917,848 2,917,848 3,009,286 992,055 Public Works Department 10,043,463 10,043,463 17,884,613 7,101,845 Parks, Recreation & Community Services 17,616,397 17,616,397 10,483,281 3,556,328 Transfer to Capital Improvement Fund - - 936,500 390,208 Transfer to Debt Service Fund 1,000,000 1,000,000 609,000 277,779 Transfer to Fleet Maintenance Fund 600,000 600,000 - - Transfer to Insurance Fund 500,000 500,000 - - Total Expenditures 86,799,174 86,799,174 89,015,073 33,611,469 Net Surplus (Deficit) $ (2,276,123) $ 52,951 $ 170,225 $ 3,795,777 Beginning Unrestricted Fund Balance (Note 1) Total Ending Fund Balance 17,033,487 $ 17,086,438 17,086,438 $ 20,882,214 Note 1: Unrestricted fund balance includes amounts designated for compensated absences and IMRF. City of Evanston General Assistance Fund As of May 31, 2014 FY 2013 FY 2013 FY 2014 FY 2014 Budget Unaudited Budget YTD Amended Actual Adopted Actual Property Taxes $ 5,073 Misc. Revenue - - 85 Transfers from other Fun - - - 466,269 Total Revenue - - - 471,427 Administration - - - 13,987 Client Payments - - - 86,651 Utilities-- Come Ed - - - 1,327 Office Supplies - - - 1,687 Total Expenditures - - - 103,652 Net Surplus (Deficit) $ - $ - $ - $ 367,775 Beginning Fund Balance _ _ Ending Fund Balance $ - $ 367,775 City of Evanston Neighborhood Stabilization Fund As of May 31, 2014 FY 2013 FY 2013 FY 2014 FY 2014 Budget Unaudited Budget YTD Amended Actual Adopted Actual Grant Proceeds $ 4,011,917 $ 2,725,225 $ 458,044 $ 403,995 Program Income - 347 - 852,434 Investment Income - 510 - 510 Total Revenue 4,011,917 2,726,082 458,044 1,256,940 Development Activities 3,505,000 2,476,794 290,500 304,738 Administration 341,622 176,972 126,635 80,855 Transfer to Debt Service 3,905 3,905 4,046 5,591 Transfer to Insurance 16,390 16,390 6,863 2,859 Transfer to General Fund 145,000 87,624 30,000 36,510 Total Expenditures 4,011,917 2,761,685 458,044 430,554 Net Surplus (Deficit) $ - $ (35,603) $ - $ 826,386 Beginning Fund Balance - (35,603) Ending Fund Balance $ (35,603) $ 790,783 Landline Surcharge Revenue Wireless Surcharge Revenue Interest Income Grants Miscellaneous Revenue Total Revenue City of Evanston E911 Fund As of May 31,2014 FY 2013 Budget Amended $ 617,400 $ 416,160 1,000 1,034,560 FY 2013 Unaudited Actual 502,880 $ 385,911 215 32,211 921,216 FY 2014 Budget Adopted 529,200 $ 428,400 1,000 958,600 FY 2014 YTD Actual 255,878 140,377 45 102,078 498,378 Operating Expense 891,122 781,940 935,767 346,273 Transfer to General Fund 125,950 125,950 125,950 52,479 Transfer to Insurance Fund 98,993 98,993 88,858 37,024 Transfer to Debt Service Fund 11,215 11,215 11,622 4,843 Capital Replacement 120,000 26,680 250,000 - Total Expenditures 1,247,280 1,044,778 1,412,197 440,619 Net Surplus (Deficit) $ (212,720) $ (123,561) $ (453,597) $ 57,759 Beginning Fund Balance 1,264,807 1,141,246 Ending Fund Balance $ 1,141,246 $ 1,199,005 City of Evanston Motor Fuel Fund As of May 31, 2014 FY 2013 FY 2013 FY 2014 FY 2014 Budget Unaudited Budget YTD Amended Actual Adopted Actual State Allotment $ 2,125,000 $ 2,118,506 $ 1,750,000 $ 758,166 Investment Earnings 2,000 482 500 109 Miscellaneous Income - - - - Total Revenue 2,127,000 2,118,988 1,750,500 758,275 Street Resurfacing 1,400,000 972,788 1,400,000 - Transfer to General Fund - Staff Engineering 133,000 133,000 133,000 55,417 Transfer to General Fund - Street Maintenance 700,000 700,000 700,000 291,667 Total Expenditures 2,233,000 1,805,788 2,233,000 347,083 Net Surplus (Deficit) $ (106,000) $ 313,200 $ (482,500) $ 411,192 Beginning Fund Balance 999,368 1,312,568 Ending Fund Balance $ 1,312,568 $ 1,723,760 Property Tax Revenue Investment Income Total Revenues Professional Fees (Evmark) Total Expenditures Net Surplus (Deficit) Beginning Fund Balance Ending Fund Balance City of Evanston Special Service Area #4 Fund As of May 31, 2014 FY 2013 Budget Amended $ 370,000 $ 370,000 370,000 370,000 FY 2013 Unaudited Actual 316,235 $ 316,235 370,000 370,000 FY 2014 Budget Adopted 370,000 $ 370,000 370,000 370,000 $ - $ (53,765) $ - $ (117,003) $ (170,768) $ FY 2014 YTD Actual 183,388 183,388 160,000 160,000 23,388 (170,768) (147,380) City of Evanston CDBG Fund As of May 31, 2014 FY 2013 FY 2013 FY 2014 FY 2014 Budget Unaudited Budget YTD Amended Actual Adoated Actual Intergovernmental/Entitlement $ 1,540,000 $ 1,403,936 $ 1,500,000 $ 337,735 Funds Reallocated from Prior Years 33,100 - 168,088 - Program Income 352,000 14,288 70,000 9,766 Miscellaneous - 125 - - Total Revenues 1,925,100 1,418,349 1,738,088 347,501 CDBG Administration/Planning 195,522 258,633 300,000 133,652 Development Activities 612,500 288,046 456,288 31,803 Capital Projects 494,800 454,676 410,800 35,548 Transfers to General Fund 781,278 650,976 571,000 271,240 Total Expenditures 2,084,100 1,652,332 1,738,088 472,243 Net Surplus (Deficit) $ (169,000) $ (233,983) $ - $ (124,742) Beginning Fund Balance 12,799 (221,184) Ending Fund Balance $ (221,184) $ (345,926) Intergovernmental Revenue Program Income Interest Income Total Revenues Program Expenses Total Expenditures Net Surplus (Deficit) Beginning Fund Balance Ending Fund Balance City of Evanston CDBG Loan Fund As of May 31, 2014 FY 2013 FY 2013 FY 2014 FY 2014 Budget Unaudited Budget YTD Amended Actual Adopted Actual $ - $ 205,825 $ 50,000 $ - 9,000 76,003 10,000 22,048 - 41 100 50 9,000 281,869 60,100 22,098 20,000 150,636 20,000 20,786 20,000 150,636 20,000 20,786 $ (11,000) $ 131,233 $ 40,100 $ 1,312 2,144,813 2,276,046 $ 2,276,046 $ 2,277,358 City of Evanston Economic Development Fund As of May 31, 2014 Hotel Tax Amusement Tax Howard -Ridge Loan Repayment Grants Investment Income Total Revenues Economic Development Activities Other Charges - Gigabit Challenge Capital Projects Transfer to Debt Service Transfer to Insurance Transfers to General Fund Total Expenditures Net Surplus (Deficit) FY 2013 FY 2013 FY 2014 Budget Unaudited Budget Amended Actual Adopted $ 1,600,000 $ 1,188,037 $ 1,500,000 $ 300,000 218,651 300,000 48,500 48,500 45,500 - 999,000 1,000,000 800 917 800 1,949,300 2,455,105 2,846,300 1,830,209 982,308 1,760,889 - - 1,000,000 3,500 4,600 - 13,771 13,771 14,271 67,416 67,416 66,546 452,707 452,707 452,707 2,367,603 1,520,802 3,294,413 FY 2014 YTD Actual 617,253 154,016 18,958 2,007 792,234 332537.47 5,946 27,728 188,628 554,839 $ (418,303) $ 934,303 $ (448.113) $ 237,395 Beginning Fund Balance 2,150,404 3,084,707 Ending Fund Balance $ 3,084,707 $ 3,322,102 City of Evanston Neighborhood Improvement Fund As of May 31, 2014 FY 2013 FY 2013 FY 2014 FY 2014 Budget Unaudited Budget YTD Amended Actual Adopted Actual Taxes $ 20,000 $ 20,000 $ 20,000 $ - Interest Income - - - Total Revenues 20,000 20,000 20,000 - Program Expenses - - 50,000 - Transfers to Other Funds - - - - Total Expenditures - - 50,000 - Net Surplus (Deficit) $ 20,000 $ 20,000 $ (30,000) $ - Beginning Fund Balance 129,915 149,915 Ending Fund Balance $ 149,915 $ 149,915 City of Evanston Home Fund As of May 31, 2014 FY 2013 FY 2013 FY 2014 FY 2014 Budget Unaudited Budget YTD Amended Actual Adopted Actual Intergovernmental /Entitlement $ 797,400 $ 820,182 $ 674,500 $ 325,893 Interest Income - - - - Program Income - 27,384 - - Total Revenues 797,400 847,666 674,500 325,893 Home Administration/Planning 4,000 - 27,836 8,223 Development Activities 765,000 665,619 650,000 325,694 Transfers to General Fund 28,400 65,700 22,500 1,895 Total Expenditures 797,400 731,319 700,336 335,812 Net Surplus (Deficit) $ - $ 116,247 $ (25,836) $ (9,919) Beginning Fund Balance 3,306,375 3,422,622 Ending Fund Balance $ 3,422,622 $ 3,412,703 City of Evanston Affordable Housing Fund As of May 31, 2014 FY 2013 FY 2013 FY 2014 FY 2014 Budget Unaudited Budget YTD Amended Actual Adopted Actual Developer Contributions 155,000 290,000 155,000 62,500 Rehab Repayments - 25,241 - 3,472 Interest Income 228 121 150 227 Miscellaneous - - - 31,338 Total Revenues 155,228 315,362 155,150 97,538 Housing - Buildings 227,800 20,188 200,000 - Down Payment Assistance - - - - Transfers to General Fund 23,990 23,990 13,990 5,829 Miscellaneous 46,000 30,000 50,000 375 Total Expenditures 297,790 74,178 263,990 6,204 Net Surplus (Deficit) $ (142,562) $ 241,184 $ (108,840) $ 91,333 Beginning Fund Balance 2,236,126 2,477,310 Ending Fund Balance $ 2,477,310 $ 2,568,643 City of Evanston Washington National TIF Fund As of May 31, 2014 Net Property Tax Increment Interest Income Total Revenue Series 1997 Principal (refunded by 1999 & 2008D) Series 1997 Interest (refunded by 1999 and 2008D) Contributions to Other Agencies Economic Development Projects Capital Improvements Contractual Services Transfer to Parking Fund (Sherman) Transfer to General Fund Total Expenditures Net Surplus (Deficit) FY 2013 FY 2013 FY 2014 FY 2014 Budget Unaudited Budget YTD Amended Actual Adopted Actual $ 4,600,000 $ 4,512,409 $ 3,700,000 $ 2,402,630 25,000 13,071 10,000 4,605 4,625,000 4,525,480 3,710,000 2,407,234 425,000 425,000 455,000 - 78,376 78,376 55,000 - 1,250,000 154,385 1,250,000 24,668 2,836,000 2,094,507 722,486 - 145,000 2,489 250,000 - 3,631,350 3,631,350 2,925,296 1,218,873 331,000 331,000 331,000 137,917 8,696,726 6,717,107 5,988,782 1,381,458 $ (4,071,726) $ (2,191,627) $ (2,278,782) $ 1,025,777 Beginning Fund Balance 7,291,304 5,099,677 Ending Fund Balance $ 5,099,677 $ 6,125,454 City of Evanston Special Service Area #5 As of May 31, 2014 FY 2013 FY 2013 FY 2014 FY 2014 Budget Unaudited Budget YTD Amended Actual Adopted Actual Net Property Taxes $ 448,875 $ 427,213 $ 397,800 $ 247,928 Interest Income - 586 - - Total Revenue 448,875 427,799 397,800 247,928 Series 2002C Bonds Principal 340,000 340,000 390,000 - Series 2012A Bonds Interest 78,816 78,815 46,605 - General Management Support - - - - Total Expenditures 418,816 418,816 436,606 - Net Surplus (Deficit) $ 30,069 $ 8,984 $ (38,806) $ 247,928 Beginning Fund Balance 433,054 442,038 Ending Fund Balance $ 442,038 $ 689,966 City of Evanston SW II TIF (Howard Hartrey) As of May 31, 2014 Net Property Tax Increment Interest Income Total Revenue 1994 & 1996 Bonds Principal (refunded by 1999 and 2008D bonds) 1994 & 1996 Bonds Interest (refunded by 1999 and 2008D bonds) Surplus Distribution Capital Projects Other Expenses Economic Development Operating Transfer to General Fund Total Expenditures Net Surplus (Deficit) FY 2013 FY 2013 FY 2014 FY 2014 Budget Unaudited Budget YTD Amended Actual Adopted Actual $ 1,100,000 $ 1,106,614 $ 1,100,000 $ 621,802 10,000 14,088 10,000 5,952 1,110,000 1,120,702 1,110,000 627,754 645,000 645,000 685,000 - 75,611 75,611 39,088 - 1,000,000 1,000,000 - - 1,400,000 150,000 500,000 - 500,000 9,916 - 1,486 - - 2,500,000 - 144,400 144,400 144,400 60,167 3,765,011 2,024,927 3,868,488 61,653 $ (2,655,011) $ (904,225) $ (2,758,488) $ 566,102 Beginning Fund Balance 4,245,639 3,341,414 Ending Fund Balance $ 3,341,414 $ 3,907,516 Net Property Tax Increment Interest Income Total Revenue Economic Development Activities Capital Improvement Projects Operating Transfer to General Fund Total Expenditures Net Surplus (Deficit) City of Evanston Southwest TI F As of May 31,2O14 FY 2013 FY 2013 FY 2014 FY 2014 Budget Unaudited Budget YTD Amended Actual Adopted Actual $ 465,000 $ 480,769 $ 485,000 $ 261,359 100 - 1,000 6 465,100 480,769 486,000 261,365 - 459 748,439 - 580,000 422,675 - - 29,500 29,500 29,500 12,292 609,500 452,634 777,939 12,292 $ (144,400) $ 28,135 $ (291,939) $ 249,074 Beginning Fund Balance 304,939 333,074 Ending Fund Balance $ 333,074 $ 582,148 City of Evanston Debt Service Fund As of May 31, 2014 FY 2013 FY 2013 FY 2014 FY 2014 Budget Unaudited Budget YTD Amended Actual Adopted Actual Net Property Tax- Current $ 11,798,019 $ 11,864,662 $ 10,879,993 $ 6,016,724 Special Assessment Levy - - 169,848 - Bond Proceeds/Premium/ Discounts - 24,159,490 - - Transfer from Other Funds - IMRF- 783,004 764,003 141,125 338,096 Miscellaneous Revenue - 33,510 - - Interest Income 1,500 5,356 1,500 1,775 Transfer from General Fund - 1,000,000 1,279,306 203,000 Transfer from Sewer Fund 190,210 190,210 207,284 86,368 Transfer from Special Assessment Fund 317,660 317,660 169,848 70,770 Total Revenue 13,090,393 38,334,891 12,848,904 6,716,734 Series 2004- Principal 775,000 10,100,000 - - Series 2004- Interest 478,400 478,400 Series 2004 B- Principal 595,000 2,830,000 - Series 2004 B- Interest 130,439 130,438 - Series 2005- Principal 1,095,000 13,360,000 - Series 2005- Interest 664,000 664,000 - Series 2006- Principal 85,000 85,000 185,000 Series 2006- Interest 448,302 448,302 444,776 - Series 2006 B Bonds- Principal 35,000 35,000 1,130,000 55,000 Series 2006 B Bonds- Interest 603,426 603,426 600,526 301,363 Series 2007 - Principal 965,000 965,000 1,909,709 - Series 2007 - Interest 684,458 684,456 569,684 Series 2008A - Principal 300,000 300,000 300,000 Series 2008A - Interest 125,975 125,975 116,225 Series 2008C - Principal 362,900 362,900 378,180 Series 2008C - Interest 376,308 376,308 364,514 Series 2008D - Principal 1,410,000 1,410,000 565,600 Series 2008D - Interest 36,690 36,690 15,362 Series 2010 A - Principal DSF 305,000 305,000 305,000 Series 2010 A - Interest DSF 179,338 179,338 173,238 Series 2010 B - Principal DSF 647,358 647,358 684,946 Series 2010 B - Interest DSF 135,508 135,509 126,446 Series 2011 A - Principal DSF 1,234,836 1,234,836 1,250,432 Series 2011 A - Interest DSF 451,586 451,586 426,890 Series 2012 A - Interest DSF 955,000 995,000 1,025,000 Series 2012 A - Principal DSF 357,706 347,766 243,332 Series 2013 A - Principal DSF 505,055 Series 2013 A - Interest DSF 1,601,006 - Series 2013 B - Principal DSF 586,498 Series 2013 B - Interest DSF 95,000 95,000 - Series 2004- Interest SAF 13,650 13,650 Series 2005- Principal SAF 20,000 20,000 Series 2005- Interest SAF 17,500 17,500 - - Series 2006- Principal SAF 50,000 50,000 50,000 - Series 2006- Interest SAF 8,526 8,526 6,450 - Series 2007 - Principal SAF 35,000 35,000 40,000 - Series 2007 - Interest SAF 33,920 33,920 31,994 - Series 2008C - Principal SAF 19,000 19,000 19,800 - Series 2008C - Interest SAF 19,702 19,702 19,084 - Series 2013 A - Principal SAF 20,000 - Series 2013 A - Interest SAF 8,867 - Series 2013 B - Principal SAF 120,000 - Series 2013 B - Interest SAF 23,500 - General Management and Support 5,000 - 1,000 - Bond Issuance Costs 60,000 160,061 75,000 - Net of Transfers - - - - Fiscal Agent Fees 10,000 109,610 10,000 24,095 Total Expenditures 13,824,528 37,874,257 13,933,114 380,458 Net Surplus (Deficit) $ (734,135) $ 460,634 $ (1,084,210) $ 6,336,277 Beginning Fund Balance 2,896,148 3,356,782 Ending Fund Balance $ 3,356,782 $ 9,693,059 Net Property Tax Increment Interest Income Miscellaneous Total Revenue City of Evanston Howard Ridge TIF As of May 31, 2014 FY 2013 Budget Amended $ 500,000 $ 400 500,400 FY 2013 Unaudited Actual 474,216 $ 344 33,014 507,574 FY 2014 Budget Adopted 350,000 $ 400 350,400 FY 2014 YTD Actual 255,338 9 16,825 272,172 Economic Dev. Projects - - - 80,889 Debt Service - Interest - 544 - 237 Capital Improvements 800,000 215,402 - 1,514 Developer Agreement Payments 610,000 510,237 300,000 240,423 Repayments to Econ. Dev. Fund 48,500 48,500 45,500 18,958 Transfers to General Fund 120,400 120,400 60,000 25,000 Total Expenditures 2,037,736 895,083 405,500 367,020 Net Surplus (Deficit) $ (1,637,336) $ (387,509) $ (55,100) $ (94,849) Beginning Fund Balance 1,055,510 668,001 Ending Fund Balance $ 668,001 $ 573,152 City of Evanston West Evanston TIF As of May 31, 2014 FY 2013 FY 2013 FY 2014 FY 2014 Budget Unaudited Budget YTD Amended Actual Adopted Actual Net Property Tax Increment $ 300,000 $ 51,144 $ 40,000 $ - Bond Proceeds 3,400,000 - - - Interest Income 1,000 167 100 42 Total Revenue 3,701,000 61,311 40,100 42 Economic Development Projects 650,000 - 75,000 - Other Charges 1,600,000 135,353 20,000 - Debt Service - Interest 40,000 6,691 10,000 2,915 Transfers to General Fund 60,000 60,000 60,000 25,000 Capital Projects 1,285,000 179,000 - - Total Expenditures 3,636,000 381,044 166,000 27,916 Net Surplus (Deficit) $ 66,000 $ (329,733) $ (124,900) $ (27,873) Beginning Fund Balance 872,847 543,114 Ending Fund Balance $ 543,114 $ 515,241 City of Evanston Dempster -Dodge TIF As of May 31, 2014 FY 2013 FY 2013 FY 2014 FY 2014 Budget Unaudited Budget YTD Amended Actual Adopted Actual Net Property Tax Increment $ 100,000 $ - $ - $ _ Bond Proceeds 650,000 Interest Income - Total Revenue 760,000 Economic Development Projects 650,000 Total Expenditures 660,000 Net Surplus (Deficit) $ 100,000 $ - $ _ $ _ Beginning Fund Balance Ending Fund Balance $ - $ _ City of Evanston Capital Improvement Fund As of May 31, 2014 Bond Proceeds Grants Private Contributions Parking Fund Loan for Financial System General Fund Allocation Miscellaneous Interest Income Total Revenue Capital Outlay (includes prior year rollovers) Interfund Transfers Out Total Expenditures Net Surplus (Deficit) FY 2013 FY 2013 FY 2014 FY 2014 Budget Unaudited Budget YTD Amended Actual Adopted Actual $ 8,339,988 $ 8,538,259 $ 8,331,458 $ - 1,675,000 491,635 5,382,638 487,563 510,000 - 708,000 - 596,000 - 100,000 - - - 936,500 390,208 - 53,986 - - 10,000 18,562 10,000 3,006 11,130,988 9,102,442 15,468,596 880,777 13,100,351 6,440,749 17,935,016 1,027,621 475,000 475,000 475,000 197,917 13,575,351 6,915,749 18,410, 016 1,225,537 $ (2,444,363) $ 2,186,693 $ (2,941,420) $ (344,760) Beginning Fund Balance 3,401,911 5,588,604 Ending Fund Balance $ 5,588,604 $ 5,243,844 Special Assessments Collected Bond Proceeds Investment Income Total Revenue Transfer to Debt Service Fund General Management & Support Capital Outlay Total Expenditures Net Surplus (Deficit) City of Evanston Special Assessment Fund As of May 31, 2014 FY 2013 FY 2013 FY 2014 FY 2014 Budget Unaudited Budget YTD Amended Actual Adopted Actual $ 300,000 $ 274,526 $ 230,000 $ 90,626 250,000 241,906 250,000 - 10,000 1,982 1,200 352 560,000 618,414 481,200 90,978 317,660 317,660 169,848 70,770 - - 1,000 - 361,000 33,976 500,000 - 678,660 351,636 670,848 70,770 $ (118,660) $ 166,778 $ (189,648) $ 20,208 Beginning Fund Balance 1,905,315 2,072,093 Ending Fund Balance $ 2,072,093 $ 2,092,301 City of Evanston Parking Fund As of May 31, 2014 FY 2013 FY 2013 FY 2014 FY 2014 Budget Unaudited Budget YTD Amended Actual Adopted Actual Parking Lots & Meters Operations $ 3,070,000 $ 2,876,089 $ 3,070,000 $ 1,100,081 Church Street Garage Operations 716,348 618,913 716,348 264,035 Maple Avenue Garage Operations 1,204,200 1,142,379 1,204,200 555,904 Sherman Avenue Garage Operations 1,417,275 7,419,581 1,417,275 637,062 Washington National TIF Interfund Transfers -In 3,631,350 3,631,350 2,925,296 1,218,873 Interest Income 15,070 11,892 15,070 - Miscellaneous Revenue 11,400 21,891 11,400 Reserve for Future Repairs (Contra Depreciation) 2,034,004 - 2,034,004 - Total Revenue 12,099,647 15,722,095 11,393,593 3,776,964 7005 - Parking System Administration 784,607 997,485 976,360 714,280 7015 - Parking Lots and Meters 829,052 655,080 972,266 436,380 7025 - Church Street Self Park 607,955 414,444 624,855 135,874 7030 - Church Street Debt Payments 171,250 171,250 171,250 - 7036 - Sherman Avenue Garage 5,750,270 10,671,714 5,047,016 444,900 7037 - Maple Avenue Garage 1,611,920 865,571 1,654,244 282,620 7039 - Parking Debt 27,461 27,461 27,461 - Transfer to Insurance Fund 490,236 490,236 319,648 133,187 Transfer to General Fund 644,242 644,242 869,242 362,184 Transfer to Fleet 21,991 21,992 21,991 - Transfer to Equipment Replacement 30,000 30,000 30,000 Loans to Other Funds 2,796,000 - - Capital Outlay - - - Capital Improvements 3,455,000 1,863,129 5,180,000 - Total Expenditures 17,219,984 16,852,604 15,894,333 2,509,426 Net Surplus (Deficit) $ (5,120,3 7 $ (1,130,509) $ (4,5009740) $ 1,266,529 Beginning Unrestricted Fund Balance 14,418,330 13,287,821 Ending Unrestricted Fund Balance $ 13,287,821 $ 14,554,350 City of Evanston Water Fund As of May 31, 2014 FY 2013 FY 2013 FY 2014 FY 2014 Budget Unaudited Budget YTD Amended Actual Adopted Actual Evanston $ 5,684,000 $ 6,081,164 $ 6,252,400 $ 2,631,089 Skokie 2,856,000 2,772,424 2,913,000 1,380,906 Northwest Commission 4,517,000 4,898,986 4,653,000 2,189,054 Cross Connection Control Fees 100,500 94,470 95,000 - Investment Earnings 2,500 20,164 2,500 7,034 Debt Proceeds 2,630,700 2,043,779 4,000,000 - Debt Proceeds (zero interest) 1,370,000 - 2,000,000 - Fees and Merchandise Sales 40,000 95,530 45,000 41,777 Fees and Outside Work 80,000 188,610 70,000 56,241 Grants - - - - Insurance Reimbursements - - - - Phosphate Sales 66,000 52,795 69,000 18,891 Property Sales and Rentals 213,300 235,936 227,316 41,256 Misc Revenue - 162,767 - 24,977 Total Revenue 17.560.000 16.646.625 20.327.216 6.391.225 General Support 990,583 944,465 933,989 360,157 Pumping 2,333,247 2,173,144 2,355,718 728,756 Filtration 2,635,539 2,339,158 2,740,856 895,476 Distribution 1,424,324 1,356,808 1,425,352 552,042 Meter Maintenance 309,163 254,560 300,760 94,197 Other Operating Expenses 478,592 379,183 491,700 124,841 Debt Service 864,233 814,233 1,297,703 1,500,000 Debt Service - IEPA Loan 3382 67,506 67,504 67,506 33,752 Capital Outlay 248,500 275,597 368,100 20,101 Capital Improvements 8,065,700 4,765,577 10,170,000 11,030 Interfund Transfers Out - General Fund 3,356,300 3,356,300 3,369,559 1,403,983 Interfund Transfers Out - Insurance Fund 468,492 468,492 468,492 195,205 Total Expense 21.242.179 17.195.021 23.989.735 5.919.542 Net Surplus (Deficit) $ (3,682,179) $ (548,396) $ (3,662,519) $ 471,682 Beginning Unrestricted Fund Balance 9,192,655 8,644,259 Ending Unrestricted Fund Balance $ 8,644,259 $ 9,115,941 City of Evanston Sewer Fund As of May 31, 2014 FY 2013 FY 2013 FY 2014 FY 2014 Budget Unaudited Budget YTD Amended Actual Adopted Actual Operations $ 12,908,000 $ 13,758,709 $ 12,922,700 $ 5,367,343 Debt Proceeds 4,000,000 2,300,529 - Debt Proceeds - 2012 [EPA Loan 3,100,000 2,523,969 2,190,000 292,451 Investment Earnings 1,000 1,271 1,000 - Miscellaneous 18,865 - 4,165 860,353 Grant Revenue - - - - Total Revenue 20,027,865 18,584,478 15,117,865 6,520,147 Sewer Operations 2,134,549 1,979,122 2,260,545 874,439 Other Operating Expenses 43,300 23,100 129,500 2,879 Interfund Transfers Out - General Fund 142,200 142,200 145,044 60,435 Interfund Transfers Out - Insurance Fund 269,988 269,988 269,988 112,495 Transfer to Debt Service 190,211 190,210 207,284 86,368 Capital Outlay 20,600 13,714 47,500 41,040 Capital Improvement Account 4,922,500 4,579,112 3,225,000 66,600 Debt Service 11,542,740 11,542,807 9,994,259 3,882,958 Total Expenses 19,266,088 18,740,253 16,279,120 5,127,215 Net Surplus (Deficit) $ 761,777 $ (155,775) $ (1,161,255) $ 1,392,932 Beginning Unrestricted Fund Balance 4,199,578 4,043,803 Ending Unrestricted Fund Balance $ 4,043,803 $ 5,436,735 City of Evanston Solid Waste As of May 31, 2014 FY 2013 FY 2013 FY 2014 FY 2014 Budget Unaudited Budget YTD Amended Actual Adopted Actual Transfer from General Fund $ 1,245,967 $ 1,245,967 $ 1,055,967 $ 439,986 Solid Waste Franchise Fees 175,000 199,980 175,000 41,058 SWANCC Recycling Incentive 140,000 30,467 25,000 2,029 Recycling Service Charge 2,954,033 3,259,715 3,334,033 1,446,793 Sanitation Service Charge Penalty 30,000 44,099 45,000 31,215 Special Pickup Fees 100,000 74,784 100,000 13,717 Trash Cart Sales 15,000 27,738 15,000 3,832 Investment Income - 20 - Yard Waste Fees 350,000 247,627 220,000 22,257 Total Revenue 6.010.000 5.130.397 4.970.000 2.000.887 Refuse Collection & Disposal 3,259,574 2,942,329 3,372,698 1,145,287 Residential Recycling Collection 1,254,398 1,207,081 1,186,134 489,043 Yard Waste Collection 750,250 626,253 750,250 143,148 Total Expense 5.264,222 4.776.663 5.309.082 1.777.478 Net Surplus (Deficit) $ (264,222) $ 354,734 $ (339,082) 223,409 Beginning Unrestricted Fund Balance (1,447,885) (1,093,151) Ending Unrestricted Fund Balance $ (1,093,151) (869,742) City of Evanston Fleet Maintenance Fund As of May 31, 2014 FY 2013 FY 2013 FY 2014 FY 2014 Budget Unaudited Budget YTD Amended Actual Adopted Actual General Fund $ 2,507,356 $ 3,107,358 $ 2,507,356 $ 1,044,733 Library Fund 2,381 2,381 2,381 992 Parking Fund 21,992 21,992 21,992 9,163 Water Fund 122,751 122,751 122,751 51,146 Sewer Fund 177,729 177,729 177,729 74,054 Solid Waste Fund 298,071 298,071 298,071 124,196 Damage to City Property 24,789 - 24,789 - Miscellaneous Revenue 10,000 46,348 10,000 18,666 Interest Income 1,000 - 1,000 - Total Revenues 3,166,069 3,776,630 3,166,069 1,322,950 General Support 292,007 261,029 293,619 108,917 Major Maintenance 3,217,058 3,299,061 3,284,528 1,209,078 Total Expenditures 3,509,065 3,560,090 3,578,147 1,317,995 Net Surplus (Deficit) $ (342,996) $ 216,540 $ (412,078) $ 4,955 Beginning Fund Balance (107,097) 109,443 Ending Fund Balance $ 109,443 $ 114,398 City of Evanston Equipment Replacement Fund As of May 31, 2014 FY 2013 FY 2013 FY 2014 FY 2014 Budget Unaudited Budget YTD Amended Actual Adopted Actual General Fund $ 1,242,590 $ 1,242,590 $ 1,242,590 $ 517,746 Library Fund 1,700 1,700 1,700 708 Parking Fund 30,000 30,000 30,000 12,500 Solid Waste Fund 177,131 177,131 177,131 73,805 Bond Proceeds - - 1,000,000 - Sale of Surplus Property 210,217 124,667 210,217 26,455 Total Revenues 1,661,638 1,576,088 2,661,638 631,214 Capital Outlay 2,400,000 1,487,556 2,494,000 250,826 Carryover - - 200,000 - Capital Leases 50,000 42,686 50,000 - Total Expenditures 2,450,000 1,530,242 2,744,000 250,826 Net Surplus (Deficit) $ (788,362) $ 45,846 $ (82,362) $ 380,387 Beginning Fund Balance $ 1,500,482 $ 1,546,328 Ending Fund Balance $ 1,546,328 $ 1,926,715 City of Evanston Insurance Fund As of May 31, 2014 FY 2013 FY 2013 FY 2014 FY 2014 Budget Unaudited Budget YTD Amended Actual Adopted Actual General Admin Contribution- General $ 121,204 $ 121,204 $ 121,204 $ 50,502 General Admin Contribution- E911 930 930 930 388 General Admin Contribution- CDBG 930 930 930 388 General Admin Contribution- E.D. 930 930 930 388 General Admin Contribution- Parking 17,032 17,032 17,032 7,097 General Admin Contribution- Water Fund 24,962 24,962 24,962 10,401 General Admin Contribution- Sewer Fund 14,385 14,385 14,385 5,994 Liability/Property Contribution- General 909,150 909,150 909,150 378,813 Liability/Property Contribution- E911 6,972 6,972 6,972 2,905 Liability/Property Contribution- CDBG 6,972 6,972 6,972 2,905 Liability/Property Contribution- E.D. 6,972 6,972 6,972 2,905 Liability/Property Contribution- Parking 127,731 127,731 127,731 53,221 Liability/Property Contribution- Water Fund 187,209 187,209 187,209 78,004 Liability/Property Contribution- Sewer Fund 107,887 107,887 107,887 44,953 Workers' Comp Contribution- General 1,244,860 1,244,860 1,244,860 518,693 Workers' Comp Contribution- Library Fund 5,898 5,898 40,000 16,667 Workers' Comp Contribution- E911 9,546 9,546 9,546 3,978 Workers' Comp Contribution- CDBG 9,546 9,546 9,546 3,978 Workers' Comp Contribution- E.D. 9,546 9,546 9,546 3,978 Workers' Comp Contribution- Parking 174,886 174,886 174,886 72,869 Workers' Comp Contribution- Water Fund 256,322 256,322 256,322 106,801 Workers' Comp Contribution- Sewer Fund 147,716 147,716 147,716 61,548 Subrogation Proceeds 83,300 155,102 100,000 39,113 Yearend Transfer from General Fund - 520,000 - - Transfer from General Fund - Casualty Loss Acct - - - - Investment Income 41,650 212 1,000 - Workers Comp & Liability - Subtotal 3,516,536 4,066,900 3,526,688 1,466,484 Health Insurance Chargebacks- General 8,232,350 8,262,909 8,780,657 3,658,608 Health Insurance Chargebacks - Library 318,681 - 366,065 152,527 Health Insurance Chargebacks - NSP2 16,390 16,390 6,863 2,859 Health Insurance Chargebacks- E911 81,545 81,545 71,410 29,754 Health Insurance Chargebacks- CDBG 12,586 12,586 31,521 13,134 Health Insurance Chargebacks- E.D. Fund 56,081 49,968 49,098 20,458 Health Insurance Chargebacks- Home Fund - - 2,735 1,140 Health Insurance Chargebacks- Parking 170,588 170,588 171,325 71,386 Health Insurance Chargebacks- Water 596,392 596,392 616,227 256,761 Health Insurance Chargebacks- Sewer 168,030 168,030 183,218 76,341 Health Insurance Chargebacks - Solid Waste 114,220 114,220 106,846 44,519 Health Insurance Chargebacks- Fleet 183,414 183,414 202,427 84,345 Retiree Health Insurance Contributions 1,684,894 1,688,954 1,970,647 663,783 Employee Health Insurance Contributions 1,760,276 1,808,346 1,706,017 603,899 SWANNC-Health Insurance Contributions - - - 26,016 One Time IPBC Distribution 300,000 300,000 300,000 125,000 Health & Life insurance - Subtotal 13,695,447 13,453,342 14,565,056 5,830,529 Total Revenues 17,211,983 17,520,242 18,091,744 7,297,014 City of Evanston Insurance Fund As of May 31, 2014 FY 2013 FY 2013 FY 2014 FY 2014 Budget Unaudited Budget YTD Amended Actual Adopted Actual General Administration & Support 294,093 288,369 409,548 110,009 Auditing 25,000 - - - Liability/Property Insurance Premiums 470,000 455,614 470,000 485,115 Liability Legal Fees 350,000 571,721 350,000 61,078 Liability Settlement Payments 400,000 471,052 400,000 85,147 Transfer - to ERI Debt Service 8,325 8,325 8,627 3,595 Workers' Comp Insurance Premiums 114,400 111,111 114,400 118,531 Workers' Comp Legal Fees 80,500 38,694 80,500 22,721 Workers' Comp Medical Payments 800,000 494,020 600,000 190,418 Workers' Comp Settlement Payments 1,100,000 899,625 1,100,000 316,712 Workers' Comp TPA Pymts (non specific) 145,000 107,155 125,000 25,375 Workers' Comp TTD Pymts (non sworn) - 48,092 - 40,773 Workers' Comp & Liability - Subtotal 3,787,318 3,493,678 3,658,075 1,459,474 General Administration & Support 94,093 87,437 99,805 33,655 Health Insurance Premiums 13,458,615 13,183,406 14,217,604 5,653,853 Health Insurance Opt Out Payments 84,000 45,133 91,800 9,453 Health & Life Insurance - Subtotal 13,636,708 13,315,976 14,409,209 5,696,961 Total Expenditures 17,424,026 16,809,654 18,067,284 7,156,435 Net Surplus (Deficit) $ (212,043) $ 710,588 $ 24,460 $ 140,579 Beginning Unrestricted Fund Balance (7,376,499) (6,665,911) Ending Unrestricted Fund Balance $ (6,665,911) $ (6,525,332) City of Evanston Fire Pension Fund As of May 31, 2014 FY 2013 FY 2013 FY 2014 FY 2014 Budget Unaudited Budget YTD Amended Actual Adopted Actual Property Taxes $ 6,061,575 $ 6,049,233 $ 6,061,575 $ 3,280,016 Personal Property Rep[ Tax 280,000 280,000 280,000 156,290 Interest on Investment 800,000 1,564,892 850,000 1,252 Participant Contributions 922,500 941,743 950,000 341,062 Unrealized Gain - 134 - 5,000 Miscellaneous - 150 - - Total Revenue 8,064,075 8,836,152 8,141,575 3,783,620 Administrative Expenses 154,000 266,237 154,000 11,519 Legal Fees 50,000 - 50,000 - Retiree Pensions 4,841,000 4,871,953 4,995,500 2,188,514 Widows' Pensions 1,090,000 1,053,398 1,071,200 444,430 Disability Pensions 1,350,000 1,304,970 1,358,125 540,908 QUILDRO 75,000 90,364 90,000 40,398 Reserve for Future Payments Total Expenditures 7,560,000 7,586,922 7,718,825 3,225,769 Net Surplus (Deficit) $ 504,075 $ 1,249,230 $ 422,750 $ 557,851 Beg Net Assets held in Trust 58,463,916 58,463,916 59,713,146 59,713,146 End Net Assets held in Trust $ 58,967,991 $ 59,713,146 $ 60,135,896 $ 60,270,997 City of Evanston Police Pension Fund As of May 31, 2014 FY 2013 FY 2013 FY 2014 FY 2014 Budget Unaudited Budget YTD Amended Actual Adopted Actual Property Taxes $ 8,069,325 $ 8,077,913 $ 8,069,325 $ 4,376,433 Personal Property Repl Tax 325,000 325,000 325,000 156,289 Interest Income 2,625,000 3,036,641 2,800,000 1,046,739 Participant Contributions 1,383,750 1,705,893 1,423,000 535,775 Miscellaneous - - - - Unrealized Gain / (Loss) - - - - Total Revenue 12,403,075 13,145,447 12,617,325 6,115,235 Administrative Expenses 250,000 264,356 250,000 158,103 Retiree Pensions 7,500,769 7,787,104 8,056,000 3,390,742 Widow Pensions 868,000 857,302 875,500 364,434 Disability Pensions 700,000 662,888 700,000 268,521 Separation Refunds 150,000 109,252 275,000 2,831 QUILDRO 18,000 21,085 18,000 9,049 Reserve for Future Payments Total Expenditures 9,486,769 9,701,987 10,174,500 4,193,680 Net Surplus (Deficit) $ 2,916,306 $ 3,443,460 $ 2,442,825 $ 1,921,555 Beg Net Assets held in Trust 80,589,961 80,589,961 84,033,421 84,033,421 End Net Assets held in Trust $ 83,506,267 $ 84,033,421 $ 86,476,246 $ 85,954,976 City of Evanston Library Fund As of May 31, 2014 FY 2013 FY 2013 FY 2014 FY 2014 Budget Unaudited Budget YTD Amended Actual Adopted Actual Revenue By Source Allocation - Property Taxes $ 4,253,214 $ 4,165,513 $ 5,032,097 $ 2,330,299 Library Fines & Fees 185,000 158,176 164,000 62,623 Library Material Replacement 12,500 12,484 14,000 4,966 Copy Machine Charges 20,000 18,814 21,200 6,320 Meeting Room Fees 10,000 12,397 10,400 8,867 Non-resident Cards 1,690 1,565 1,040 260 North Branch Rental Income 59,660 58,697 60,000 13,067 State Per Capita Grant 76,300 131,976 94,177 - Personal Property Repl. Tax 50,200 50,200 50,200 - Video Rentals - - - - Book Sales 60,000 56,140 65,000 21,718 Fund for Excellence 245,000 127,432 125,000 20,614 Grants and Donations - - 116,545 15,240 Transfer from Economic Development - 9,900 - - Miscellaneous - 5,103 - 240 Transfer from Endowment 131,250 131,250 159,315 - Total Revenues 5,104,814 4,939,647 5,912,974 2,484,214 Expenditures Youth Services 891,720 901,891 1,030,009 387,882 Adult Services 1,535,224 1,538,511 1,514,037 542,840 Circulation 612,892 605,815 573,258 204,375 Neighborhood Services 360,757 325,202 456,528 169,817 Technical Services 503,433 431,115 538,879 175,484 Maintenance 507,517 669,172 660,703 241,492 Administration 669,377 677,112 1,103,015 396,415 Library Grants - 35,570 36,545 1,860 Total Expenditures 5,080,920 5,184,388 5,912,974 2,120,165 Net Surplus (Deficit) $ 23,894 $ (244,741) $ - $ 364,048 Beginning Fund Balance 1,101,096 856,355 Ending Fund Balance 856,355 1,220,403 City of Evanston Library Debt Fund As of May 31, 2014 FY 2013 FY 2013 FY 2014 FY 2014 Budget Unaudited Budget YTD Amended Actual Adopted Actual Revenue By Source Net Property Taxes $ - $ - $ 748,178 $ 396,370 Library Fines & Fees - - 1,000 - Total Revenues - - 749,178 396,370 Expenditures Series 2004 - Principal DSF - - 53,430 - Series 2004 - Interest DSF - - 8,454 - Series 2005 - Principal DSF - - 44,918 - Series 2005 - Interest DSF - - 14,089 - Series 2007 - Principal DSF - - 200,291 - Series 2007 - Interest DSF - - 60,496 - Series 2008 - Principal DSF - - 344,400 - Series 2008 - Interest DSF - - 22,100 - Total Expenditures - - 748,178 - Net Surplus (Deficit) $ - $ - $ 1,000 $ 396,370 Beginning Fund Balance - - Ending Fund Balance - 396,370 City of Evanston General Fund Comparison of Fund and Cash Balances Fiscal Year 2014 vs Fiscal Year 2013 $25,000,000 $20,000,000 --*—FY 2014 Umccrvcd Fund Balance • • A• - FY 2013 Umeservcd Fund Balance $15,0OO,0OU —*--FY 2014 ('avh Balance --*—FY 2013 Cnvh Balance $5,000,000 �r I I I 0 �ooe, January February March April May June JUIV August September October November December FY 2014 Unreserved Fund Balance $ 17,321,904 $ 17,910,959 $ 21,166.294 $ 20,395,607 $ 20,882,214 FY 2013 Unreserved Fund Balance $ 17,412,530 $ 18,091,096 $ 21,774,085 $ 22,459,219 $ 23,342,537 FY 2014 Cash Balance $ 4,173,079 $ 6,745,425 $ 10,059,258 $ 9,101,839 $ 8,474,680 FY 2013 Cash Balance $ 6,624,063 $ 7,811,937 $ 12,160,633 $ 12,969,898 $ 12,797,660