HomeMy WebLinkAbout2014.03 March Monthly Report
To: Wally Bobkiewicz, City Manager
Martin Lyons, Assistant City Manager/Chief Financial Officer
From: Ashley Porta, Management Analyst
Hitesh Desai, Accounting Manager
Subject: March 2014 Monthly Financial Report
Date: April 30, 2014
Please find attached the unaudited financial statements as of March 31, 2014. A
summary by fund for total revenues, expenditures/expenses, fund balances, and cash
balances is as follows:
YTD YTD YTD 3/31/2014 3/31/2014
3/31/2014 3/31/2014 3/31/2014 Unreserved Cash
Fund Name Fund #Revenue Expenses Net Fund Balance Balance*
General 100 24,022,234$ 19,891,628$ 4,130,606$ 21,217,044$ 10,059,258$
Neighborhood Stabilization 195 909,978 365,645 544,333 508,730 511,709
Motor Fuel 200 501,906 208,185 293,721 1,606,289 1,768,685
Emergency 911 205 343,163 156,598 186,565 1,327,811 1,141,998
SSA#4 210 183,388 80,000 103,388 (67,380) (76,814)
CDBG 215 244,706 270,216 (25,510) (246,694) (187,433)
CDBG Loan 220 13,813 14,050 (237) 2,275,809 114,593
Economic Development 225 484,171 249,111 235,060 3,319,767 3,162,425
Neighborhood Improvement 235 - - - 149,915 149,915
Home 240 28,921 122,590 (93,669) 3,328,953 (83,496)
Affordable Housing 250 44,613 3,497 41,116 2,518,426 779,501
Washington National TIF 300 2,386,065 901,897 1,484,168 6,583,845 6,177,364
SSA#5 305 247,889 - 247,889 689,927 661,467
SW II TIF (Howard Hartrey)310 625,406 37,586 587,820 3,929,234 3,929,235
Southwest TIF 315 261,359 7,375 253,984 587,058 587,059
Debt Service 320 6,334,777 357,363 5,977,414 9,334,196 7,814,506
Howard Ridge TIF 330 262,825 347,954 (85,129) 582,872 291,837
West Evanston TIF 335 31 16,742 (16,711) 526,403 520,928
Dempster-Dodge TIF 340 - - - - -
Capital Improvement 415 916,374 675,852 240,522 5,829,126 7,088,350
Special Assessment 420 81,667 42,462 39,205 2,111,298 2,107,273
Parking 505 2,216,147 1,247,744 968,403 14,256,224 14,237,696
Water 510-513 3,888,904 3,165,205 723,699 9,367,958 9,003,627
Sewer 515 4,051,356 3,178,504 872,852 4,916,655 3,200,355
Solid Waste 520 1,181,606 1,007,376 174,230 (918,921) (1,475,741)
Fleet 600 793,075 823,592 (30,517) 78,926 (416,498)
Equipment Replacement 601 384,544 325,978 58,566 1,604,894 793,044
Insurance 605 4,253,676 4,575,499 (321,823) (6,987,734) 815,406
Library 185 2,358,963 1,251,177 388,105 1,964,141 1,324,269
Library Debt Fund 186 388,105 - 388,105 388,105 388,105
Total**57,021,557$ 39,323,826$ 16,978,050$ 90,394,772$ 74,388,623$
*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.
City of Evanston
Fund Financial Performance Summary
As of March 31, 2014
Memorandum
Included above are the ending balances as of March 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 balan ce 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 March 31, 2014, the General Fund is reporting a surplus of $4,130,606. 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 actu al
expenses incurred each month along with this anticipated higher expense in December
2014.
Through March 31, 2014, the Special Service Area (SSA) #4 Fund is showing a
negative cash balance of $76,814.
Through March 31, 2014, the Community Development Block Grant (CDBG) Fund is
showing a negative fund balance of $246,694 and a negative cash balance of $187,433.
Through March 31, 2014, the Economic Development Fund is showing a fund balance
of $3,319,767 and a cash balance of $3,162,425. These balances include
approximately $1 million of revenue associated with the Gigabit Challenge.
Through March 31, 2014, the Solid Waste Fund is showing a negative fund balance of
$918,921 and a negative cash balance of $1,475,741.
Through March 31, 2014, the Fleet Fund is showing a negative cash balance of
$416,498.
Through March 31, 2014, the HOME fund is showing a negative cash balance of
$83,496; however, on April 10, 2014, the City received $80,697 from HUD which will
greatly help this fund.
Through March 31, 2014, the Insurance Fund is showing a negative fund balance of
$6,987,734. 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 $594,443, 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: aporta@cityofevanston.org. Detailed fund summary reports can
be found at the following link: http://www.cityofevanston.org/city-budget/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 March 31, 2014 year-to-date
financial information and reports which to the best of my knowledge appear accurate
and complete.
Revenues Budget Actual
% of
Budget Budget Actual
% of
Budget Budget Actual
% of
Budget Budget Actual
% of
Budget Budget Actual
% of
Budget
Property Tax 12,271,386$ 6,502,014$ 53.0% -$ -$ -$ -$ -$ -$ -$ -$
Sales Tax 15,790,000 3,464,157 21.9% - - - - - - - -
State Income Tax 7,076,170 1,612,108 22.8% - - - - - - - -
Utility Tax 8,220,000 2,342,562 28.5% - - - - - - - -
Real Estate Transfer Tax 2,875,000 391,820 13.6% - - - - - - - -
Liquor Tax 2,375,000 752,775 31.7% - - - - - - - -
Other Taxes 5,940,053 1,140,872 19.2% - - - - - - - -
Licenses, Permits, Fees 12,622,280 2,838,103 22.5% - - - - - - - -
Charges for Services 7,936,754 1,733,147 21.8% 6,434,293 1,484,823 23.1% 13,913,400 3,841,163 27.6% 12,922,700 3,191,003 24.7% 3,889,033 917,614 23.6%
Intergovernmental Revenues 721,272 160,699 22.3% - - - - - - 25,000 - 0.0%
Interfund Transfers 7,742,893 1,970,148 25.4% 2,925,296 731,324 25.0% - - - - 1,055,967 263,992 25.0%
Other Non-Tax Revenue 5,614,490 1,113,829 19.8% 2,034,004 - 0.0% 6,413,816 47,741 0.7% 2,191,000 860,353 39.3% - -
Total Revenues 89,185,298$ 24,022,234$ 26.9% 11,393,593$ 2,216,147$ 19.5% 20,327,216$ 3,888,904$ 19.1% 15,113,700$ 4,051,356$ 26.8% 4,970,000$ 1,181,606$ 23.8%
Expenditures
Legislative 677,621$ 154,227$ 22.8% -$ -$ -$ -$ -$ -$ -$ -$
City Administration 1,941,115 368,573 19.0% - - - - - - - -
Law Department 1,045,232 215,211 20.6% - - - - - - - -
Administrative Services Department 8,826,606 1,579,645 17.9% - - - - - - - -
Community Development 2,652,887 544,944 20.5% - - - - - - - -
Police Department 26,876,444 6,290,616 23.4% - - - - - - - -
Fire & Life Safety Services 14,072,488 3,456,619 24.6% - - - - - - - -
Health Department 3,009,286 498,614 16.6% - - - - - - - -
Public Works - Operating 17,884,613 4,432,284 24.8% 10,714,333 1,247,744 11.6% - - - - 5,309,082 1,007,376 19.0%
Public Works - Capital Outlay - - 5,180,000 - 0.0% - - - - - -
Parks, Recreation & Comm. Services 10,483,281 1,964,520 18.7% - - - - - - - -
Capital Improvement Transfer 936,500 234,125 25.0%
Transfer to Debt Service Fund 609,000 152,250 25.0% - - - - - - - -
Utilities - Operating - - - - 13,451,635 2,702,251 20.1% 13,006,620 3,130,316 24.1% - -
Utilities - Capital Outlay - - - - 10,538,100 462,954 4.4% 3,272,500 48,188 1.5% - -
Total Expenditures 89,015,073$ 19,891,628$ 22.3% 15,894,333$ 1,247,744$ 7.9% 23,989,735$ 3,165,205$ 13.2% 16,279,120$ 3,178,504$ 19.5% 5,309,082$ 1,007,376$ 19.0%
As of March 31, 2014
City of Evanston
Report of Budget-to-Actual Revenues and Expenditures
Parking Fund Water Fund Solid Waste FundSewer FundGeneral Fund
(Target is 25% of FY 2014 Budget)
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,502,014$
Tax - State Use 1,176,879 1,259,865 1,241,753 243,000
Tax - Sales Tax - Basic 9,291,000 9,717,393 9,690,000 2,131,720
Tax - Sales Tax - Home Rule 5,861,800 5,964,747 6,100,000 1,332,437
Tax - Auto Rental 40,000 43,598 40,000 10,805
Tax - Athletic Contest 760,000 1,056,355 800,000 -
Tax - State Income 6,322,645 7,182,793 7,076,170 1,612,108
Tax - Electric Utility 3,069,806 3,000,629 3,070,000 802,936
Tax - Natural Gas Utility 1,400,000 1,090,915 1,200,000 444,543
Tax - Natural Gas Use - Home Rule 800,000 760,734 800,000 300,083
Tax - Cigarette 485,000 153,000 300,000 -
Tax - Evanston Motor Fuel 707,667 634,196 610,000 189,015
Tax - Liquor 2,350,000 2,261,874 2,375,000 752,775
Tax - Parking 2,200,000 2,418,852 2,350,000 543,524
Tax - Personal Property Replacement 591,600 529,146 598,300 154,528
Tax - Real Estate Transfer 2,146,300 3,894,599 2,875,000 391,820
Tax - Telecommunications 3,244,500 2,871,370 3,150,000 795,000
License Fees - Vehicles 2,600,000 2,349,686 2,700,000 352,101
License Fees - Other 1,030,502 1,427,834 937,302 320,461
Permit Fees - Building 3,020,000 3,951,048 6,142,162 1,281,103
Permit Fees - Other 1,209,788 1,746,109 1,486,716 484,671
Other Fees 1,559,350 1,152,472 1,356,100 399,767
Fines and Forfeiture Revenue 4,366,022 3,451,887 4,366,022 888,824
Charges for Services Revenue 7,904,198 7,845,622 7,936,754 1,733,147
Intergovernmental Revenue 786,798 1,425,905 721,272 160,699
Other Revenue 1,418,443 919,287 1,238,468 215,004
Interfund Transfers In (Other Funds)7,693,367 7,521,427 7,742,893 1,970,148
Interest Income 6,000 29,207 10,000 10,001
Total Revenue 84,523,051 86,852,125 89,185,298 24,022,234
Legislative 657,069 657,069 677,621 154,227
City Administration 1,582,580 1,582,580 1,941,115 368,573
Law Department 973,254 973,254 1,045,232 215,211
Administrative Services Department 7,721,650 7,721,650 8,826,606 1,579,645
Community and Economic Development 2,536,250 2,536,250 2,652,887 544,944
Police Department 26,508,585 26,508,585 26,876,444 6,290,616
Fire & Life Safety Services Department 14,142,078 14,142,078 14,072,488 3,456,619
Health Department 2,917,848 2,917,848 3,009,286 498,614
Public Works Department 10,043,463 10,043,463 17,884,613 4,432,284
Parks, Recreation & Community Services 17,616,397 17,616,397 10,483,281 1,964,520
Transfer to Capital Improvement Fund - - 936,500 234,125
Transfer to Debt Service Fund 1,000,000 1,000,000 609,000 152,250
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 19,891,628
Net Surplus (Deficit)(2,276,123)$ 52,951$ 170,225$ 4,130,606$
Beginning Unrestricted Fund Balance (Note 1)17,033,487 17,086,438
Total Ending Fund Balance 17,086,438$ 21,217,044$
Note 1: Unrestricted fund balance includes amounts designated for compensated absences and IMRF.
City of Evanston
General Fund
As of March 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$ 381,738$
Program Income - 347 - 528,240
Investment Income - 510 - -
Total Revenue 4,011,917 2,726,082 458,044 909,978
Development Activities 3,505,000 2,476,794 290,500 320,758
Administration 341,622 176,972 126,635 20,253
Transfer to Debt Service 3,905 3,905 4,046 1,012
Transfer to Insurance 16,390 16,390 6,863 1,716
Transfer to General Fund 145,000 87,624 30,000 21,906
Total Expenditures 4,011,917 2,761,685 458,044 365,645
Net Surplus (Deficit) -$ (35,603)$ -$ 544,333$
Beginning Fund Balance - (35,603)
Ending Fund Balance (35,603)$ 508,730$
City of Evanston
Neighborhood Stabilization Fund
As of March 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$ 501,906$
Investment Earnings 2,000 482 500 -
Miscellaneous Income - - - -
Total Revenue 2,127,000 2,118,988 1,750,500 501,906
Street Resurfacing 1,400,000 972,788 1,400,000 -
Transfer to General Fund - Staff Engineering 133,000 133,000 133,000 33,185
Transfer to General Fund - Street Maintenance 700,000 700,000 700,000 175,000
Total Expenditures 2,233,000 1,805,788 2,233,000 208,185
Net Surplus (Deficit)(106,000)$ 313,200$ (482,500)$ 293,721$
Beginning Fund Balance 999,368 1,312,568
Ending Fund Balance 1,312,568$ 1,606,289$
City of Evanston
Motor Fuel Fund
As of March 31, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Unaudited Budget YTD
Amended Actual Adopted Actual
Landline Surcharge Revenue 617,400$ 502,880$ 529,200$ 171,055$
Wireless Surcharge Revenue 416,160 385,911 428,400 70,000
Interest Income 1,000 215 1,000 30
Grants 32,211 102,078
Miscellaneous Revenue - - - -
Total Revenue 1,034,560 921,216 958,600 343,163
Operating Expense 891,122 781,940 935,767 99,991
Transfer to General Fund 125,950 125,950 125,950 31,487
Transfer to Insurance Fund 98,993 98,993 88,858 22,214
Transfer to Debt Service Fund 11,215 11,215 11,622 2,906
Capital Replacement 120,000 26,680 250,000 -
Total Expenditures 1,247,280 1,044,778 1,412,197 156,598
Net Surplus (Deficit)(212,720)$ (123,561)$ (453,597)$ 186,565$
Beginning Fund Balance 1,264,807 1,141,246
Ending Fund Balance 1,141,246$ 1,327,811$
City of Evanston
E911 Fund
As of March 31, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Unaudited Budget YTD
Amended Actual Adopted Actual
Property Tax Revenue 370,000$ 316,235$ 370,000$ 183,388$
Investment Income - - - -
Total Revenues 370,000 316,235 370,000 183,388
Professional Fees (Evmark)370,000 370,000 370,000 80,000
Total Expenditures 370,000 370,000 370,000 80,000
Net Surplus (Deficit)-$ (53,765)$ -$ 103,388$
Beginning Fund Balance (117,003) (170,768)
Ending Fund Balance (170,768)$ (67,380)$
City of Evanston
Special Service Area #4 Fund
As of March 31, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Unaudited Budget YTD
Amended Actual Adopted Actual
Intergovernmental/Entitlement 1,540,000$ $ 1,403,936 1,500,000$ $ 235,560
Funds Reallocated from Prior Years 33,100 - 168,088 -
Program Income 352,000 14,288 70,000 9,146
Miscellaneous - 125 - -
Total Revenues 1,925,100 1,418,349 1,738,088 244,706
CDBG Administration/Planning 195,522 258,633 300,000 57,461
Development Activities 612,500 288,046 456,288 30,220
Capital Projects 494,800 454,676 410,800 19,791
Transfers to General Fund 781,278 650,976 571,000 162,744
Total Expenditures 2,084,100 1,652,332 1,738,088 270,216
Net Surplus (Deficit)(159,000)$ (233,983)$ -$ (25,510)$
Beginning Fund Balance 12,799 (221,184)
Ending Fund Balance (221,184)$ (246,694)$
City of Evanston
CDBG Fund
As of March 31, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Unaudited Budget YTD
Amended Actual Adopted Actual
Intergovernmental Revenue -$ 205,825$ 50,000$ -$
Program Income 9,000 76,003 10,000 13,763
Interest Income - 41 100 50
Total Revenues 9,000 281,869 60,100 13,813
Program Expenses 20,000 150,636 20,000 14,050
Total Expenditures 20,000 150,636 20,000 14,050
Net Surplus (Deficit) (11,000)$ 131,233$ 40,100$ (237)$
Beginning Fund Balance 2,144,813 2,276,046
Ending Fund Balance 2,276,046$ 2,275,809$
City of Evanston
CDBG Loan Fund
As of March 31, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Unaudited Budget YTD
Amended Actual Adopted Actual
Hotel Tax 1,600,000$ 1,188,037$ 1,500,000$ 366,244$
Amusement Tax 300,000 218,651 300,000 105,347
Howard-Ridge Loan Repayment 48,500 48,500 45,500 11,375
Grants - 999,000 1,000,000 -
Investment Income 800 917 800 1,205
Total Revenues 1,949,300 2,455,105 2,846,300 484,171
Economic Development Activities 1,830,209 982,308 1,760,889 115,730
Other Charges - Gigabit Challenge - - 1,000,000 -
Capital Projects 3,500 4,600 -
Transfer to Debt Service 13,771 13,771 14,271 3,568
Transfer to Insurance 67,416 67,416 66,546 16,637
Transfers to General Fund 452,707 452,707 452,707 113,176
Total Expenditures 2,367,603 1,520,802 3,294,413 249,111
Net Surplus (Deficit)(418,303)$ 934,303$ (448,113)$ 235,060$
Beginning Fund Balance 2,150,404 3,084,707
Ending Fund Balance 3,084,707$ 3,319,767$
City of Evanston
Economic Development Fund
As of March 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
Neighborhood Improvement Fund
As of March 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$ 22,075$
Interest Income - - -
Program Income - 27,384 - 6,846
Total Revenues 797,400 847,566 674,500 28,921
Home Administration/Planning 4,000 - 27,836 3,857
Development Activities 765,000 665,619 650,000 113,048
Transfers to General Fund 28,400 65,700 22,500 5,685
Total Expenditures 797,400 731,319 700,336 122,590
Net Surplus (Deficit) -$ 116,247$ (25,836)$ (93,669)$
Beginning Fund Balance 3,306,375 3,422,622
Ending Fund Balance 3,422,622$ 3,328,953$
City of Evanston
Home Fund
As of March 31, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Unaudited Budget YTD
Amended Actual Adopted Actual
Developer Contributions 155,000 290,000 290,000 31,250
Rehab Repayments - 25,241 - 1,806
Interest Income 228 121 150 219
Miscellaneous - - - 11,338
Total Revenues 155,228 315,362 290,150 44,613
Housing - Buildings 227,800 20,188 200,000
Down Payment Assistance - - -
Transfers to General Fund 23,990 23,990 13,990 3,497
Miscellaneous 46,000 30,000 50,000 -
Total Expenditures 297,790 74,178 263,990 3,497
Net Surplus (Deficit)(142,562)$ 241,184$ 26,160$ 41,116$
Beginning Fund Balance 2,236,126 2,477,310
Ending Fund Balance 2,477,310$ 2,518,426$
City of Evanston
Affordable Housing Fund
As of March 31, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Unaudited Budget YTD
Amended Actual Adopted Actual
Net Property Tax Increment 4,600,000$ 4,512,409$ 3,700,000$ 2,383,266$
Interest Income 25,000 13,071 10,000 2,799
Total Revenue 4,625,000 4,525,480 3,710,000 2,386,065
Series 1997 Principal
(refunded by 1999 & 2008D) 425,000 425,000 455,000
Series 1997 Interest
(refunded by 1999 and 2008D) 78,376 78,376 55,000
Contributions to Other Agencies - - -
Economic Development Projects 1,250,000 154,385 1,250,000 24,668
Capital Improvements 2,836,000 2,094,507 722,486 63,155
Contractual Services 145,000 2,489 250,000
Transfer to Parking Fund (Sherman) 3,631,350 3,631,350 2,925,296 731,324
Transfer to General Fund 331,000 331,000 331,000 82,750
Total Expenditures 8,696,726 6,717,107 5,988,782 901,897
Net Surplus (Deficit) (4,071,726)$ (2,191,627)$ (2,278,782)$ 1,484,168$
Beginning Fund Balance 7,291,304 5,099,677
Ending Fund Balance 5,099,677$ 6,583,845$
City of Evanston
Washington National TIF Fund
As of March 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,889$
Interest Income - 586 - -
Total Revenue 448,875 427,799 397,800 247,889
Series 2002C Bonds Principal 340,000 340,000 390,000 -
Series 2002C Bonds Interest 78,816 78,815 46,605 -
General Management Support - - - -
Total Expenditures 418,816 418,815 436,605 -
Net Surplus (Deficit)30,059$ 8,984$ (38,805)$ 247,889$
Beginning Fund Balance 433,054 442,038
Ending Fund Balance 442,038$ 689,927$
City of Evanston
Special Service Area #5
As of March 31, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Unaudited Budget YTD
Amended Actual Adopted Actual
Net Property Tax Increment 1,100,000$ 1,106,614$ 1,100,000$ 621,802$
Interest Income 10,000 14,088 10,000 3,604
Total Revenue 1,110,000 1,120,702 1,110,000 625,406
1994 & 1996 Bonds Principal (refunded by
1999 and 2008D bonds)645,000 645,000 685,000
1994 & 1996 Bonds Interest (refunded by
1999 and 2008D bonds)75,611 75,611 39,088
Surplus Distribution 1,000,000 1,000,000 -
Capital Projects 1,400,000 150,000 500,000
Other Expenses 500,000 9,916 -
Economic Development - - 2,500,000 1,486
Operating Transfer to General Fund 144,400 144,400 144,400 36,100
Total Expenditures 3,765,011 2,024,927 3,868,488 37,586
Net Surplus (Deficit)(2,655,011)$ (904,225)$ (2,758,488)$ 587,820$
Beginning Fund Balance 4,245,639 3,341,414
Ending Fund Balance 3,341,414$ 3,929,234$
City of Evanston
SW II TIF (Howard Hartrey)
As of March 31, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Unaudited Budget YTD
Amended Actual Adopted Actual
Net Property Tax Increment 465,000$ 480,769$ 485,000$ 261,359$
Interest Income 100 - 1,000 -
Total Revenue 465,100 480,769 486,000 261,359
Economic Development Activities - 459 748,439 -
Capital Improvement Projects 580,000 422,675 - -
Operating Transfer to General Fund 29,500 29,500 29,500 7,375
Total Expenditures 609,500 452,634 777,939 7,375
Net Surplus (Deficit)(144,400)$ 28,135$ (291,939)$ 253,984$
Beginning Fund Balance 304,939 333,074
Ending Fund Balance 333,074$ 587,058$
City of Evanston
Southwest TIF
As of March 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$ 5,883,699$
Special Assessment Levy - - 169,848
Bond Proceeds/Premium/ Discounts - 24,159,490 - -
Transfer from Other Funds - IMRF- 783,004 764,003 141,125 35,281
Miscellaneous Revenue - 33,510 - -
Interest Income 1,500 5,356 1,500 1,687
Transfer from General Fund - 1,000,000 1,279,306 319,827
Transfer from Sewer Fund 190,210 190,210 207,284 51,821
Transfer from Special Assessment Fund 317,660 317,660 169,848 42,462
Total Revenue 13,090,393 38,334,891 12,848,904 6,334,777
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 1,000
Total Expenditures 13,824,528 37,874,257 13,933,114 357,363
Net Surplus (Deficit)(734,135)$ 460,634$ (1,084,210)$ 5,977,414$
Beginning Fund Balance 2,896,148 3,356,782
Ending Fund Balance 3,356,782$ 9,334,196$
City of Evanston
Debt Service Fund
As of March 31, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Unaudited Budget YTD
Amended Actual Adopted Actual
Net Property Tax Increment 500,000$ 474,216$ 350,000$ 255,338$
Interest Income 400 344 400 6
Miscellaneous - 33,014 - 7,481
Total Revenue 500,400 507,574 350,400 262,825
Economic Dev. Projects - - -
Debt Service - Interest - 544 - 142
Capital Improvements 800,000 215,402 -
Developer Agreement Payments 610,000 510,237 300,000 321,437
Repayments to Econ. Dev. Fund 48,500 48,500 45,500 11,375
Transfers to General Fund 120,400 120,400 60,000 15,000
Total Expenditures 2,037,736 895,083 405,500 347,954
Net Surplus (Deficit)(1,537,336)$ (387,509)$ (55,100)$ (85,129)$
Beginning Fund Balance 1,055,510 668,001
Ending Fund Balance 668,001$ 582,872$
City of Evanston
Howard Ridge TIF
As of March 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 31
Total Revenue 3,701,000 51,311 40,100 31
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 1,742
Transfers to General Fund 60,000 60,000 60,000 15,000
Capital Projects 1,285,000 179,000 - -
Total Expenditures 3,635,000 381,044 165,000 16,742
Net Surplus (Deficit)66,000$ (329,733)$ (124,900)$ (16,711)$
Beginning Fund Balance 872,847 543,114
Ending Fund Balance 543,114$ 526,403$
City of Evanston
West Evanston TIF
As of March 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 750,000 - - -
Economic Development Projects 650,000 - - -
Total Expenditures 650,000 - - -
Net Surplus (Deficit)100,000$ -$ -$ -$
Beginning Fund Balance - -
Ending Fund Balance -$ -$
City of Evanston
Dempster-Dodge TIF
As of March 31, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Unaudited Budget YTD
Amended Actual Adopted Actual
Bond Proceeds 8,339,988$ 8,538,259$ 8,331,458$
Grants 1,675,000 491,635 5,382,638 680,429
Private Contributions 510,000 - 708,000
Parking Fund Loan for Financial System 596,000 - 100,000
General Fund Allocation - - 936,500 234,125
Miscellaneous - 53,986 -
Interest Income 10,000 18,562 10,000 1,820
Total Revenue 11,130,988 9,102,442 15,468,596 916,374
Capital Outlay (includes prior year rollovers) 13,100,351 6,440,749 17,935,016 557,102
Interfund Transfers Out 475,000 475,000 475,000 118,750
Total Expenditures 13,575,351 6,915,749 18,410,016 675,852
Net Surplus (Deficit)(2,444,363)$ 2,186,693$ (2,941,420)$ 240,522$
Beginning Fund Balance 3,401,911 5,588,604
Ending Fund Balance 5,588,604$ 5,829,126$
City of Evanston
Capital Improvement Fund
As of March 31, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Unaudited Budget YTD
Amended Actual Adopted Actual
Special Assessments Collected 300,000$ 274,526$ 230,000$ 81,454$
Bond Proceeds 250,000 241,906 250,000
Investment Income 10,000 1,982 1,200 213
Total Revenue 560,000 518,414 481,200 81,667
Transfer to Debt Service Fund 317,660 317,660 169,848 42,462
General Management & Support - - 1,000 -
Capital Outlay 361,000 33,976 500,000 -
Total Expenditures 678,660 351,636 670,848 42,462
Net Surplus (Deficit)(118,660)$ 166,778$ (189,648)$ 39,205$
Beginning Fund Balance 1,905,315 2,072,093
Ending Fund Balance 2,072,093$ 2,111,298$
City of Evanston
Special Assessment Fund
As of March 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$ 628,483$
Church Street Garage Operations 716,348 618,913 716,348 150,173
Maple Avenue Garage Operations 1,204,200 1,142,379 1,204,200 331,112
Sherman Avenue Garage Operations 1,417,275 7,419,581 1,417,275 370,579
Washington National TIF Interfund Transfers-In 3,631,350 3,631,350 2,925,296 731,324
Interest Income 15,070 11,892 15,070 4,476
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 2,216,147
7005 - Parking System Administration 784,607 997,485 976,360 453,307
7015 - Parking Lots and Meters 829,052 655,080 972,266 152,408
7025 - Church Street Self Park 607,955 414,444 624,855 39,296
7030 - Church Street Debt Payments 171,250 171,250 171,250
7036 - Sherman Avenue Garage 5,750,270 10,671,714 5,047,016 149,890
7037 - Maple Avenue Garage 1,611,920 865,571 1,654,244 99,520
7039 - Parking Debt 27,461 27,461 27,461
Transfer to Insurance Fund 490,236 490,236 319,648 123,015
Transfer to General Fund 644,242 644,242 869,242 217,310
Transfer to Fleet 21,991 21,992 21,991 5,498
Transfer to Equipment Replacement 30,000 30,000 30,000 7,500
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 1,247,744
Net Surplus (Deficit)(5,120,337)$ (1,130,509)$ (4,500,740)$ 968,403$
Further Operating Expense Breakdown:
7015 Parking Meter Activities 762,846 655,080 935,614 152,408
7015 Parking Meter Depreciation 36,652 - 36,652 -
SUBTOTAL 799,498 655,080 972,266 152,408
7025- Church Garage Activities 494,156 414,444 444,927 39,296
7025- Church Garage Depreciation 179,928 - 179,928 -
SUBTOTAL 674,084 414,444 624,855 39,296
7036 Sherman Garage Activities 1,199,756 7,421,714 468,766 149,890
7036 Debt Service Payments 3,250,300 3,250,000 3,703,600
7036 Reserve (Depreciation)874,650 - 874,650 -
SUBTOTAL 5,324,706 10,671,714 5,047,016 149,890
7037 Maple Garage Activities 1,013,991 865,571 988,046 99,520
7037 Debt Service Payments - - - -
7037 Reserve (Depreciation)666,198 - 666,198 -
SUBTOTAL 1,680,189 865,571 1,654,244 99,520
Beginning Unrestricted Fund Balance 14,418,330 13,287,821
Ending Unrestricted Fund Balance 13,287,821$ 14,256,224$
City of Evanston
Parking Fund
As of March 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$ 1,579,858$
Skokie 2,856,000 2,772,424 2,913,000 947,407
Northwest Commission 4,517,000 4,898,986 4,653,000 1,313,898
Cross Connection Control Fees 100,500 94,470 95,000
Investment Earnings 2,500 20,164 2,500 5,469
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 6,073
Fees and Outside Work 80,000 188,610 70,000 19,300
Grants - - -
Insurance Reimbursements - - -
Phosphate Sales 66,000 52,795 69,000 15,281
Property Sales and Rentals 213,300 235,936 227,316
Misc Revenue - 162,767 - 1,618
Total Revenue 17,560,000 16,646,625 20,327,216 3,888,904
General Support 990,583 944,465 933,989 209,328
Pumping 2,333,247 2,173,144 2,355,718 385,117
Filtration 2,635,539 2,339,158 2,740,856 382,247
Distribution 1,424,324 1,356,808 1,425,352 327,226
Meter Maintenance 309,163 254,560 300,760 54,537
Other Operating Expenses 478,592 379,183 491,700 72,611
Debt Service 864,233 814,233 1,297,703 311,672
Debt Service - IEPA Loan 3382 67,506 67,504 67,506 -
Capital Outlay 248,500 275,597 368,100 8,848
Capital Improvements 8,065,700 4,765,577 10,170,000 454,106
Interfund Transfers Out - General Fund 3,356,300 3,356,300 3,369,559 842,390
Interfund Transfers Out - Insurance Fund 468,492 468,492 468,492 117,123
Total Expense 21,242,179 17,195,021 23,989,735 3,165,205
Net Surplus (Deficit)(3,682,179)$ (548,396)$ (3,662,519)$ 723,699$
Beginning Unrestricted Fund Balance 9,192,655 8,644,259
Ending Unrestricted Fund Balance 8,644,259$ 9,367,958$
City of Evanston
Water Fund
As of March 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$ 3,191,003$
Debt Proceeds 4,000,000 2,300,529 - -
Debt Proceeds - 2012 IEPA Loan 3,100,000 2,523,969 2,190,000 -
Investment Earnings 1,000 1,271 1,000 -
Miscellaneous 18,865 - 4,165
Grant Revenue 860,353
Total Revenue 20,027,865 18,584,478 15,117,865 4,051,356
Sewer Operations 2,134,549 1,979,122 2,260,545 658,209
Other Operating Expenses 43,300 23,100 129,500 2,100
Interfund Transfers Out - General Fund 142,200 142,200 145,044 36,261
Interfund Transfers Out - Insurance Fund 269,988 269,988 269,988 67,497
Transfer to Debt Service 190,211 190,210 207,284 51,821
Capital Outlay 20,600 13,714 47,500 37,061
Capital Improvement Account 4,922,500 4,579,112 3,225,000 11,127
Debt Service 11,542,740 11,542,807 9,994,259 2,314,428
Total Expenses 19,266,088 18,740,253 16,279,120 3,178,504
Net Surplus (Deficit)761,777$ (155,775)$ (1,161,255)$ 872,852$
Beginning Unrestricted Fund Balance 4,199,578 4,043,803
Ending Unrestricted Fund Balance 4,043,803$ 4,916,655$
City of Evanston
Sewer Fund
As of March 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$ 263,992$
Solid Waste Franchise Fees 175,000 199,980 175,000 -
SWANCC Recycling Incentive 140,000 30,467 25,000 -
Recycling Service Charge 2,954,033 3,259,715 3,334,033 880,034
Sanitation Service Charge Penalty 30,000 44,099 45,000 19,044
Special Pickup Fees 100,000 74,784 100,000 3,062
Trash Cart Sales 15,000 27,738 15,000 646
Investment Income - 20 - -
Yard Waste Fees 350,000 247,627 220,000 14,828
Total Revenue 5,010,000 5,130,397 4,970,000 1,181,606
Refuse Collection & Disposal 3,259,574 2,942,329 3,372,698 794,449
Residential Recycling Collection 1,254,398 1,207,081 1,186,134 212,927
Yard Waste Collection 750,250 626,253 750,250 -
Total Expense 5,264,222 4,775,663 5,309,082 1,007,376
Net Surplus (Deficit)(254,222)$ 354,734$ (339,082)$ 174,230
Beginning Unrestricted Fund Balance (1,447,885) (1,093,151)
Ending Unrestricted Fund Balance (1,093,151)$ (918,921)
City of Evanston
Solid Waste
As of March 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$ 626,840$
Library Fund 2,381 2,381 2,381 595
Parking Fund 21,992 21,992 21,992 5,498
Water Fund 122,751 122,751 122,751 30,688
Sewer Fund 177,729 177,729 177,729 44,432
Solid Waste Fund 298,071 298,071 298,071 74,518
Damage to City Property 24,789 - 24,789 -
Miscellaneous Revenue 10,000 46,348 10,000 10,504
Interest Income 1,000 - 1,000 -
Total Revenues 3,166,069 3,776,630 3,166,069 793,075
General Support 292,007 261,029 293,619 66,713
Major Maintenance 3,217,058 3,299,061 3,284,528 756,879
Total Expenditures 3,509,065 3,560,090 3,578,147 823,592
Net Surplus (Deficit)(342,996)$ 216,540$ (412,078)$ (30,517)$
Beginning Fund Balance (107,097) 109,443
Ending Fund Balance 109,443$ 78,926$
City of Evanston
Fleet Maintenance Fund
As of March 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$ 310,647$
Library Fund 1,700 1,700 1,700 425
Parking Fund 30,000 30,000 30,000 7,500
Solid Waste Fund 177,131 177,131 177,131 44,283
Bond Proceeds - - 1,000,000 -
Sale of Surplus Property 210,217 124,667 210,217 21,689
Total Revenues 1,661,638 1,576,088 2,661,638 384,544
Capital Outlay 2,400,000 1,487,556 2,494,000 325,978
Carryover - - 200,000 -
Capital Leases 50,000 42,686 50,000 -
Total Expenditures 2,450,000 1,530,242 2,744,000 325,978
Net Surplus (Deficit)(788,362)$ 45,846$ (82,362)$ 58,566$
Beginning Fund Balance 1,500,482$ 1,546,328$
Ending Fund Balance 1,546,328$ 1,604,894$
City of Evanston
Equipment Replacement Fund
As of March 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$ 30,301$
General Admin Contribution- E911 930 930 930 233
General Admin Contribution- CDBG 930 930 930 233
General Admin Contribution- E.D.930 930 930 233
General Admin Contribution- Parking 17,032 17,032 17,032 4,258
General Admin Contribution- Water Fund 24,962 24,962 24,962 6,241
General Admin Contribution- Sewer Fund 14,385 14,385 14,385 3,596
Liability/Property Contribution- General 909,150 909,150 909,150 227,288
Liability/Property Contribution- E911 6,972 6,972 6,972 1,743
Liability/Property Contribution- CDBG 6,972 6,972 6,972 1,743
Liability/Property Contribution- E.D. 6,972 6,972 6,972 1,743
Liability/Property Contribution- Parking 127,731 127,731 127,731 31,933
Liability/Property Contribution- Water Fund 187,209 187,209 187,209 46,802
Liability/Property Contribution- Sewer Fund 107,887 107,887 107,887 26,971
Workers' Comp Contribution- General 1,244,860 1,244,860 1,244,860 311,216
Workers' Comp Contribution- Library Fund 5,898 5,898 40,000 10,000
Workers' Comp Contribution- E911 9,546 9,546 9,546 2,387
Workers' Comp Contribution- CDBG 9,546 9,546 9,546 2,387
Workers' Comp Contribution- E.D. 9,546 9,546 9,546 2,387
Workers' Comp Contribution- Parking 174,886 174,886 174,886 43,722
Workers' Comp Contribution- Water Fund 256,322 256,322 256,322 64,081
Workers' Comp Contribution- Sewer Fund 147,716 147,716 147,716 36,929
Subrogation Proceeds 83,300 155,102 100,000 28,179
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 884,606
Health Insurance Chargebacks- General 8,232,350 8,262,909 8,780,657 2,195,165
Health Insurance Chargebacks - Library 318,681 - 366,065 91,516
Health Insurance Chargebacks - NSP2 16,390 16,390 6,863 1,715
Health Insurance Chargebacks- E911 81,545 81,545 71,410 17,852
Health Insurance Chargebacks- CDBG 12,586 12,586 31,521 7,880
Health Insurance Chargebacks- E.D. Fund 56,081 49,968 49,098 12,275
Health Insurance Chargebacks- Home Fund - - 2,735 684
Health Insurance Chargebacks- Parking 170,588 170,588 171,325 42,832
Health Insurance Chargebacks- Water 596,392 596,392 616,227 154,057
Health Insurance Chargebacks- Sewer 168,030 168,030 183,218 45,805
Health Insurance Chargebacks - Solid Waste 114,220 114,220 106,846 26,711
Health Insurance Chargebacks- Fleet 183,414 183,414 202,427 50,607
Retiree Health Insurance Contributions 1,684,894 1,688,954 1,970,647 345,576
Employee Health Insurance Contributions 1,760,276 1,808,346 1,706,017 301,395
One Time IPBC Distribution 300,000 300,000 300,000 75,000
Health & Life insurance - Subtotal 13,695,447 13,453,342 14,565,056 3,369,070
Total Revenues 17,211,983 17,520,242 18,091,744 4,253,676
City of Evanston
Insurance Fund
As of March 31, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Unaudited Budget YTD
Amended Actual Adopted Actual
City of Evanston
Insurance Fund
As of March 31, 2014
General Administration & Support 294,093 288,369 409,548 62,102
Auditing 25,000 - -
Liability/Property Insurance Premiums 470,000 455,514 470,000 485,115
Liability Legal Fees 350,000 571,721 350,000 56,364
Liability Settlement Payments 400,000 471,052 400,000 10,147
Transfer - to ERI Debt Service 8,325 8,325 8,627 2,157
Workers' Comp Insurance Premiums 114,400 111,111 114,400 118,530
Workers' Comp Legal Fees 80,500 38,694 80,500 17,478
Workers' Comp Medical Payments 800,000 494,020 600,000 136,800
Workers' Comp Settlement Payments 1,100,000 899,625 1,100,000 216,942
Workers' Comp TPA Pymts (non specific)145,000 107,155 125,000 23,375
Workers' Comp TTD Pymts (non sworn)- 48,092 - 28,166
Workers' Comp & Liability - Subtotal 3,787,318 3,493,678 3,658,075 1,157,176
General Administration & Support 94,093 87,437 99,805 19,894
Health Insurance Premiums 13,458,615 13,183,406 14,217,604 3,392,976
Health Insurance Opt Out Payments 84,000 45,133 91,800 5,453
Health & Life Insurance - Subtotal 13,636,708 13,315,976 14,409,209 3,418,323
Total Expenditures 17,424,026 16,809,654 18,067,284 4,575,499
Net Surplus (Deficit)(212,043)$ 710,588$ 24,460$ (321,823)$
Beginning Unrestricted Fund Balance (7,376,499) (6,665,911)
Ending Unrestricted Fund Balance (6,665,911)$ (6,987,734)$
FY 2013 FY 2013 FY 2014 FY 2014
Budget Unaudited Bud et YTD
Amended Actual Adopted Actual
Property Taxes 6,061,575$ 6,049,233$ 6,061,575$ 3,214,200$
Personal Property Repl Tax 280,000 280,000 280,000 77,264
Interest on Investment 800,000 1,564,892 850,000 1,244
Participant Contributions 922,500 941,743 950,000 199,666
Unrealized Gain - 134 - 5,000
Miscellaneous - 150 - -
Total Revenue 8,064,075 8,836,152 8,141,575 3,497,374
Administrative Expenses 154,000 266,237 154,000 6,324
Le al Fees 50,000 - 50,000 -
Retiree Pensions 4,841,000 4,871,953 4,995,500 2,017,623
Widows' Pensions 1,090,000 1,053,398 1,071,200 219,955
Disabilit Pensions 1,350,000 1,304,970 1,358,125 161,113
QUILDRO 75,000 90,364 90,000 5,429
Reserve for Future Payments - - - -
Total Expenditures 7,560,000 7,586,922 7,718,825 2,410,444
e urp us e c 504,075$ 1,249,230$ 422,750$ 1,086,930$
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,800,076$
City of Evanston
Fire Pension Fund
As of March 31, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Unaudited Bud et YTD
Amended Actual Adopted Actual
Property Taxes 8,069,325$ 8,077,913$ 8,069,325$ 4,286,707$
Personal Property Repl Tax 325,000 325,000 325,000 77,264
Interest Income 2,625,000 3,036,641 2,800,000 1,641
Participant Contributions 1,383,750 1,705,893 1,423,000 314,321
Miscellaneous - - - -
Unrealized Gain / (Loss) - - - -
Total Revenue 12,403,075 13,145,447 12,617,325 4,679,933
Administrative Ex enses 250,000 264,356 250,000 -
Retiree Pensions 7,500,769 7,787,104 8,056,000 1,311,789
Widow Pensions 868,000 857,302 875,500 267,051
Disabilit Pensions 700,000 662,888 700,000 326,199
Se aration Refunds 150,000 109,252 275,000 -
QUILDRO 18,000 21,085 18,000 24,897
Reserve for Future Payments - - - -
Total Expenditures 9,486,769 9,701,987 10,174,500 1,929,936
e urp us e c 2,916,306$ 3,443,460$ 2,442,825$ 2,749,997$
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$ 86,783,418$
City of Evanston
Police Pension Fund
As of March 31, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Unaudited Bud et YTD
Amended Actual Adopted Actual
Revenue By Source
Allocation - Property Taxes 4,253,214$ 4,165,513$ 5,032,097$ 2,215,420$
Library Fines & Fees 185,000 158,176 164,000 37,581
Library Material Replacement 12,500 12,484 14,000 3,326
Copy Machine Charges 20,000 18,814 21,200 3,994
Meeting Room Fees 10,000 12,397 10,400 6,992
Non-resident Cards 1,690 1,565 1,040 130
North Branch Rental Income 59,660 58,697 60,000 3,793
State Per Capita Grant 76,300 131,976 94,177 -
Personal Property Repl. Tax 50,200 50,200 50,200 -
Video Rentals - - - -
Transfer from General Fund - - - 56,689
Book Sales 60,000 56,140 65,000 3,327
Fund for Excellence 245,000 127,432 125,000 13,329
Grants and Donations - - 116,545 14,240
Transfer from Economic Development - 9,900 - -
Miscellaneous - 5,103 - 142
Transfer from Endowment 131,250 131,250 159,315 -
Total Revenues 5,104,814 4,939,647 5,912,974 2,358,963
Expenditures
Youth Services 891,720 901,891 1,030,009 222,639
Adult Services 1,535,224 1,538,511 1,514,037 329,763
Circulation 612,892 605,815 573,258 124,449
Neighborhood Services 360,757 325,202 456,528 92,933
Technical Services 503,433 431,115 538,879 104,668
Maintenance 507,517 669,172 660,703 148,431
Administration 669,377 677,112 1,103,015 227,898
Library Grants - 35,570 36,545 396
Total Expenditures 5,080,920 5,184,388 5,912,974 1,251,177
Net Surplus (Deficit)23,894$ (244,741)$ -$ 1,107,786$
Beginning Fund Balance 1,101,096 856,355
Ending Fund Balance 856,355 1,964,141
City of Evanston
Library Fund
As of March 31, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Unaudited Bud et YTD
Amended Actual Adopted Actual
Revenue By Source
Net Property Taxes -$ -$ 748,178$ 388,105$
Library Fines & Fees - - 1,000 -
Total Revenues - - 749,178 388,105
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$ 388,105$
Beginning Fund Balance - -
Ending Fund Balance - 388,105
City of Evanston
Library Debt Fund
As of March 31, 2014
January February March April May June July August September October November December
FY 2014 Unreserved Fund Balance 17,321,904$ 17,910,959$ 21,166,294$
FY 2013 Unreserved Fund Balance 17,412,530$ 18,091,096$ 21,774,085$
FY 2014 Cash Balance 4,173,079$ 6,745,425$ 10,059,258$
FY 2013 Cash Balance 6,624,063$ 7,811,937$ 12,160,633$
$-
$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 2013
FY 2014 Unreserved Fund Balance
FY 2013 Unreserved Fund Balance
FY 2014 Cash Balance
FY 2013 Cash Balance