HomeMy WebLinkAbout2014.02 February Monthly Report
To: Wally Bobkiewicz, City Manager
Martin Lyons, Assistant City Manager/Chief Financial Officer
From: Brandon Dieter, Senior Management Analyst
Hitesh Desai, Accounting Manager
Subject: February 2014 Monthly Financial Report
Date: April 11, 2014
Please find attached the unaudited financial statements as of February 28, 2014. A
summary by fund for total revenues, expenditures/expenses, fund balances, and cash
balances is as follows:
YTD YTD YTD 2/28/2014 2/28/2014
2/28/2014 2/28/2014 2/28/2014 Unreserved Cash
Fund Name Fund # Revenue Expenses Net Fund Balance Balance*
General 100 14,053,731$ 13,330,710$ 723,021$ 17,809,459$ 6,745,425$
Neighborhood Stabilization 195 456,712 158,446 298,266 262,663 265,641
Motor Fuel 200 350,673 138,834 211,839 1,524,407 1,686,804
Emergency 911 205 267,285 101,814 165,471 1,306,717 1,120,905
SSA#4 210 35,455 80,000 (44,545) (215,313) (224,747)
CDBG 215 243,048 165,890 77,158 (144,026) (84,764)
CDBG Loan 220 10,042 14,885 (4,843) 2,271,203 109,988
Economic Development 225 455,520 163,417 292,103 3,376,810 3,217,242
Neighborhood Improvement 235 - - - 149,915 149,915
Home 240 5,824 5,936 (112) 3,422,510 10,061
Affordable Housing 250 32,369 2,332 30,037 2,507,347 768,423
Washington National TIF 300 426,528 567,383 (140,855) 4,958,822 4,552,340
SSA#5 305 72,364 - 72,364 514,402 485,942
SW II TIF (Howard Hartrey) 310 18,043 25,554 (7,511) 3,333,903 3,333,905
Southwest TIF 315 11,643 4,917 6,726 339,800 339,800
Debt Service 320 2,013,737 357,113 1,656,624 5,013,406 3,392,217
Howard Ridge TIF 330 15,889 98,695 (82,806) 585,195 294,160
West Evanston TIF 335 12 11,202 (11,190) 531,924 526,449
Dempster-Dodge TIF 340 - - - - -
Capital Improvement 415 422,085 609,029 (186,944) 5,401,660 6,646,067
Special Assessment 420 78,314 28,308 50,006 2,122,099 2,118,074
Parking 505 1,376,847 586,710 790,137 14,077,958 14,082,133
Water 510-513 2,594,069 2,030,450 563,619 9,207,878 8,697,798
Sewer 515 2,897,767 871,293 2,026,474 6,070,277 4,047,803
Solid Waste 520 791,883 437,457 354,426 (738,725) (1,446,524)
Fleet 600 532,218 398,771 133,447 242,890 (291,822)
Equipment Replacement 601 249,556 220,146 29,410 1,575,738 674,229
Insurance 605 2,909,277 3,086,314 (177,037) (6,842,948) 529,277
Library 185 686,342 768,524 - 774,173 134,456
Library Debt Fund 186 - - - - -
Total** 31,007,233$ 24,264,130$ 6,825,285$ 79,440,144$ 61,881,197$
*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.
Memorandum
1 of 38
Included above are the ending balances as of February 28, 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.
Despite having received only approximately 28.9% of the first Property Tax distribution,
and snow removal and associated costs exceeding budget by an estimated $459,539
through February 28, 2014, the General Fund is reporting a surplus of $723,021.
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 February 28, 2014, the Special Service Area (SSA) #4 Fund is showing a
negative fund balance of $166,180 and a negative cash balance of $224,747.
Through February 28, 2014, the Community Development Block Grant (CDBG) Fund is
showing a negative fund balance of $144,026 and a negative cash balance of $84,764.
These negative balances are due to the fact the 2014 Department of Housing and
Urban Development (HUD) budget has not been approved to date. As a result, the City
has not received its 2014 Community Block Grant Funding disbursement from the HUD.
Through February 28, 2014, the Economic Development Fund is showing a fund
balance of $3,376,810 and a cash balance of $3,217,242. These balances include
approximately $1 million of revenue associated with the Gigabit Challenge.
Through February 28, 2014, the Solid Waste Fund is showing a negative fund balance
of $738,725 and a negative cash balance of $1,446,524.
Through February 28, 2014, the Fleet Fund is showing a negative cash balance of
$291,822.
Through February 28, 2014, the Insurance Fund is showing a negative fund balance of
$6,842,948. 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)
448-8158 or by email: bdieter@cityofevanston.org
2 of 38
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 February 28, 2014 year-to-date
financial information and reports which to the best of my knowledge appear accurate
and complete.
3 of 38
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$ 1,774,972$ 14.5% -$ -$ -$ -$ -$ -$ -$ -$
Sales Tax 15,790,000 2,300,000 14.6% - - - - - - - -
State Income Tax 7,076,170 1,197,284 16.9% - - - - - - - -
Utility Tax 8,220,000 1,490,761 18.1% - - - - - - - -
Real Estate Transfer Tax 2,875,000 274,255 9.5% - - - - - - - -
Liquor Tax 2,375,000 572,925 24.1% - - - - - - - -
Other Taxes 5,940,053 671,251 11.3% - - - - - - - -
Licenses, Permits, Fees 12,622,280 2,560,148 20.3% - - - - - - - -
Charges for Services 7,936,754 1,025,663 12.9% 6,434,293 889,298 13.8% 13,913,400 2,561,877 18.4% 12,922,700 2,897,767 22.4% 3,889,033 615,888 15.8%
Intergovernmental Revenues 721,272 105,802 14.7% - - - - - - 25,000 - 0.0%
Interfund Transfers 7,742,893 1,313,455 17.0% 2,925,296 487,549 16.7% - - - - 1,055,967 175,995 16.7%
Other Non-Tax Revenue 5,614,490 767,215 13.7% 2,034,004 - 0.0% 6,413,816 32,192 0.5% 2,195,165 - 0.0% - -
Total Revenues 89,185,298$ 14,053,731$ 15.8% 11,393,593$ 1,376,847$ 12.1% 20,327,216$ 2,594,069$ 12.8% 15,117,865$ 2,897,767$ 19.2% 4,970,000$ 791,883$ 15.9%
Expenditures
Legislative 677,621$ 97,644$ 14.4% -$ -$ -$ -$ -$ -$ -$ -$
City Administration 1,941,115 240,830 12.4% - - - - - - - -
Law Department 1,045,232 137,503 13.2% - - - - - - - -
Administrative Services Department 8,826,606 762,059 8.6% - - - - - - - -
Community Development 2,652,887 348,567 13.1% - - - - - - - -
Police Department 26,876,444 4,217,392 15.7% - - - - - - - -
Fire & Life Safety Services 14,072,488 2,366,749 16.8% - - - - - - - -
Health Department 3,009,286 318,773 10.6% - - - - - - - -
Public Works - Operating 17,884,613 3,113,242 17.4% 10,714,333 586,710 5.5% - - - - 5,309,082 437,457 8.2%
Public Works - Capital Outlay - - 5,180,000 - 0.0% - - - - - -
Parks, Recreation & Comm. Services 10,483,281 1,470,368 14.0% - - - - - - - -
Capital Improvement Transfer 936,500 156,083 16.7%
Transfer to Debt Service Fund 609,000 101,500 16.7% - - - - - - - -
Utilities - Operating - - - - 13,451,635 1,903,119 14.1% 13,006,620 871,293 6.7% - -
Utilities - Capital Outlay - - - - 10,538,100 127,331 1.2% 3,272,500 - 0.0% - -
Total Expenditures 89,015,073$ 13,330,710$ 15.0% 15,894,333$ 586,710$ 3.7% 23,989,735$ 2,030,450$ 8.5% 16,279,120$ 871,293$ 5.4% 5,309,082$ 437,457$ 8.2%
As of February 28, 2014
City of Evanston
Report of Budget-to-Actual Revenues and Expenditures
Parking Fund Water Fund Solid Waste FundSewer FundGeneral Fund
(Target is 16.6% 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$ 1,774,972$
Tax - State Use 1,176,879 1,259,865 1,241,753 162,000
Tax - Sales Tax - Basic 9,291,000 9,717,393 9,690,000 1,400,000
Tax - Sales Tax - Home Rule 5,861,800 5,964,747 6,100,000 900,000
Tax - Auto Rental 40,000 43,598 40,000 6,590
Tax - Athletic Contest 760,000 1,056,355 800,000 -
Tax - State Income 6,322,645 7,182,793 7,076,170 1,197,284
Tax - Electric Utility 3,069,806 3,000,629 3,070,000 512,146
Tax - Natural Gas Utility 1,400,000 1,090,915 1,200,000 253,461
Tax - Natural Gas Use - Home Rule 800,000 760,734 800,000 195,154
Tax - Cigarette 485,000 153,000 300,000 -
Tax - Evanston Motor Fuel 707,667 634,196 610,000 128,230
Tax - Liquor 2,350,000 2,261,874 2,375,000 572,925
Tax - Parking 2,200,000 2,418,852 2,350,000 374,431
Tax - Personal Property Replacement 591,600 529,146 598,300 -
Tax - Real Estate Transfer 2,146,300 3,894,599 2,875,000 274,255
Tax - Telecommunications 3,244,500 2,871,370 3,150,000 530,000
License Fees - Vehicles 2,600,000 2,349,686 2,700,000 311,797
License Fees - Other 1,030,502 1,427,834 937,302 250,905
Permit Fees - Building 3,020,000 3,951,048 6,142,162 1,199,472
Permit Fees - Other 1,209,788 1,746,109 1,486,716 402,520
Other Fees 1,559,350 1,152,472 1,356,100 395,454
Fines and Forfeiture Revenue 4,366,022 3,451,887 4,366,022 626,644
Charges for Services Revenue 7,904,198 7,845,622 7,936,754 1,025,663
Intergovernmental Revenue 786,798 1,425,905 721,272 105,802
Other Revenue 1,418,443 919,287 1,238,468 137,203
Interfund Transfers In (Other Funds)7,693,367 7,521,427 7,742,893 1,313,455
Interest Income 6,000 29,207 10,000 3,368
Total Revenue 84,523,051 86,852,125 89,185,298 14,053,731
Legislative 657,069 657,069 677,621 97,644
City Administration 1,582,580 1,582,580 1,941,115 240,830
Law Department 973,254 973,254 1,045,232 137,503
Administrative Services Department 7,721,650 7,721,650 8,826,606 762,059
Community and Economic Development 2,536,250 2,536,250 2,652,887 348,567
Police Department 26,508,585 26,508,585 26,876,444 4,217,392
Fire & Life Safety Services Department 14,142,078 14,142,078 14,072,488 2,366,749
Health Department 2,917,848 2,917,848 3,009,286 318,773
Public Works Department 10,043,463 10,043,463 17,884,613 3,113,242
Parks, Recreation & Community Services 17,616,397 17,616,397 10,483,281 1,470,368
Transfer to Capital Improvement Fund - - 936,500 156,083
Transfer to Debt Service Fund 1,000,000 1,000,000 609,000 101,500
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 13,330,710
Net Surplus (Deficit)(2,276,123)$ 52,951$ 170,225$ 723,021$
Beginning Unrestricted Fund Balance (Note 1) 17,033,487 17,086,438
Total Ending Fund Balance 17,086,438$ 17,809,459$
Note 1: Unrestricted fund balance includes amounts designated for compensated absences and IMRF.
City of Evanston
General Fund
As of February 28, 2014
5 of 38
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$ 161,939$
Program Income - 347 - 294,773
Investment Income - 510 - -
Total Revenue 4,011,917 2,726,082 458,044 456,712
Development Activities 3,505,000 2,476,794 290,500 129,703
Administration 341,622 176,972 126,635 12,321
Transfer to Debt Service 3,905 3,905 4,046 674
Transfer to Insurance 16,390 16,390 6,863 1,144
Transfer to General Fund 145,000 87,624 30,000 14,604
Total Expenditures 4,011,917 2,761,685 458,044 158,446
Net Surplus (Deficit) -$ (35,603)$ -$ 298,266$
Beginning Fund Balance - (35,603)
Ending Fund Balance (35,603)$ 262,663$
City of Evanston
Neighborhood Stabilization Fund
As of February 28, 2014
6 of 38
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$ 350,637$
Investment Earnings 2,000 482 500 -
Miscellaneous Income - - - 36
Total Revenue 2,127,000 2,118,988 1,750,500 350,673
Street Resurfacing 1,400,000 972,788 1,400,000 -
Transfer to General Fund - Staff Engineering 133,000 133,000 133,000 22,167
Transfer to General Fund - Street Maintenance 700,000 700,000 700,000 116,667
Total Expenditures 2,233,000 1,805,788 2,233,000 138,834
Net Surplus (Deficit)(106,000)$ 313,200$ (482,500)$ 211,839$
Beginning Fund Balance 999,368 1,312,568
Ending Fund Balance 1,312,568$ 1,524,407$
City of Evanston
Motor Fuel Fund
As of February 28, 2014
7 of 38
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$ 129,093$
Wireless Surcharge Revenue 416,160 385,911 428,400 70,000
Interest Income 1,000 215 1,000 14
Grants 32,211 68,178
Miscellaneous Revenue - - - -
Total Revenue 1,034,560 921,216 958,600 267,285
Operating Expense 891,122 781,940 935,767 64,075
Transfer to General Fund 125,950 125,950 125,950 20,992
Transfer to Insurance Fund 98,993 98,993 88,858 14,810
Transfer to Debt Service Fund 11,215 11,215 11,622 1,937
Capital Replacement 120,000 26,680 250,000 -
Total Expenditures 1,247,280 1,044,778 1,412,197 101,814
Net Surplus (Deficit)(212,720)$ (123,561)$ (453,597)$ 165,471$
Beginning Fund Balance 1,264,807 1,141,246
Ending Fund Balance 1,141,246$ 1,306,717$
City of Evanston
E911 Fund
As of February 28, 2014
8 of 38
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$ 35,455$
Investment Income - - - -
Total Revenues 370,000 316,235 370,000 35,455
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)$ -$ (44,545)$
Beginning Fund Balance (117,003) (170,768)
Ending Fund Balance (170,768)$ (215,313)$
City of Evanston
Special Service Area #4 Fund
As of February 28, 2014
9 of 38
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 7,488
Miscellaneous - 125 - -
Total Revenues 1,925,100 1,418,349 1,738,088 243,048
CDBG Administration/Planning 195,522 258,633 300,000 37,383
Development Activities 612,500 288,046 456,288 20,011
Capital Projects 494,800 454,676 410,800 -
Transfers to General Fund 781,278 650,976 571,000 108,496
Total Expenditures 2,084,100 1,652,332 1,738,088 165,890
Net Surplus (Deficit)(159,000)$ (233,983)$ -$ 77,158$
Beginning Fund Balance 12,799 (221,184)
Ending Fund Balance (221,184)$ (144,026)$
City of Evanston
CDBG Fund
As of February 28, 2014
10 of 38
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 10,042
Interest Income - 41 100 -
Total Revenues 9,000 281,869 60,100 10,042
Program Expenses 20,000 150,636 20,000 14,885
Total Expenditures 20,000 150,636 20,000 14,885
Net Surplus (Deficit) (11,000)$ 131,233$ 40,100$ (4,843)$
Beginning Fund Balance 2,144,813 2,276,046
Ending Fund Balance 2,276,046$ 2,271,203$
City of Evanston
CDBG Loan Fund
As of February 28, 2014
11 of 38
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 80,892
Howard-Ridge Loan Repayment 48,500 48,500 45,500 7,583
Grants - 999,000 1,000,000 -
Miscellaneous - - - -
Investment Income 800 917 800 801
Total Revenues 1,949,300 2,455,105 2,846,300 455,520
Economic Development Activities 1,830,209 982,308 1,760,889 74,496
Other Charges - Gigabit Challenge - - 1,000,000 -
Capital Projects 3,500 4,600 - -
Transfer to Debt Service 13,771 13,771 14,271 2,379
Transfer to Insurance 67,416 67,416 66,546 11,091
Transfers to General Fund 452,707 452,707 452,707 75,451
Total Expenditures 2,367,603 1,520,802 3,294,413 163,417
Net Surplus (Deficit)(418,303)$ 934,303$ (448,113)$ 292,103$
Beginning Fund Balance 2,150,404 3,084,707
Ending Fund Balance 3,084,707$ 3,376,810$
City of Evanston
Economic Development Fund
As of February 28, 2014
12 of 38
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 February 28, 2014
13 of 38
FY 2013 FY 2013 FY 2014 FY 2014
Budget Unaudited Budget YTD
Amended Actual Adopted Actual
Intergovernmental /Entitlement 797,400$ 820,182$ 674,500$ 5,824$
Interest Income - - - -
Program Income - 27,384 - -
Total Revenues 797,400 847,566 674,500 5,824
Home Administration/Planning 4,000 - 27,836 2,000
Development Activities 765,000 665,619 650,000 146
Transfers to General Fund 28,400 65,700 22,500 3,790
Total Expenditures 797,400 731,319 700,336 5,936
Net Surplus (Deficit) -$ 116,247$ (25,836)$ (112)$
Beginning Fund Balance 3,306,375 3,422,622
Ending Fund Balance 3,422,622$ 3,422,510$
City of Evanston
Home Fund
As of February 28, 2014
14 of 38
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,111
Interest Income 228 121 150 8
Miscellaneous - - - -
Total Revenues 155,228 315,362 290,150 32,369
Housing - Buildings 227,800 20,188 200,000 -
Down Payment Assistance - - - -
Transfers to General Fund 23,990 23,990 13,990 2,332
Miscellaneous 46,000 30,000 50,000 -
Total Expenditures 297,790 74,178 263,990 2,332
Net Surplus (Deficit)(142,562)$ 241,184$ 26,160$ 30,037$
Beginning Fund Balance 2,236,126 2,477,310
Ending Fund Balance 2,477,310$ 2,507,347$
City of Evanston
Affordable Housing Fund
As of February 28, 2014
15 of 38
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$ 424,667$
Interest Income 25,000 13,071 10,000 1,861
Total Revenue 4,625,000 4,525,480 3,710,000 426,528
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 -
Capital Improvements 2,836,000 2,094,507 722,486 -
Contractual Services 145,000 2,489 250,000 24,668
Transfer to Parking Fund (Sherman) 3,631,350 3,631,350 2,925,296 487,549
Transfer to General Fund 331,000 331,000 331,000 55,166
Total Expenditures 8,696,726 6,717,107 5,988,782 567,383
Net Surplus (Deficit) (4,071,726)$ (2,191,627)$ (2,278,782)$ (140,855)$
Beginning Fund Balance 7,291,304 5,099,677
Ending Fund Balance 5,099,677$ 4,958,822$
City of Evanston
Washington National TIF Fund
As of February 28, 2014
16 of 38
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$ 72,364$
Interest Income - 586 - -
Total Revenue 448,875 427,799 397,800 72,364
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)$ 72,364$
Beginning Fund Balance 433,054 442,038
Ending Fund Balance 442,038$ 514,402$
City of Evanston
Special Service Area #5
As of February 28, 2014
17 of 38
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$ 15,634$
Interest Income 10,000 14,088 10,000 2,409
Total Revenue 1,110,000 1,120,702 1,110,000 18,043
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,487
Operating Transfer to General Fund 144,400 144,400 144,400 24,067
Total Expenditures 3,765,011 2,024,927 3,868,488 25,554
Net Surplus (Deficit)(2,655,011)$ (904,225)$ (2,758,488)$ (7,511)$
Beginning Fund Balance 4,245,639 3,341,414
Ending Fund Balance 3,341,414$ 3,333,903$
City of Evanston
SW II TIF (Howard Hartrey)
As of February 28, 2014
18 of 38
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$ 11,643$
Interest Income 100 - 1,000 -
Total Revenue 465,100 480,769 486,000 11,643
Economic Development Activities - 459 748,439 -
Capital Improvement Projects 580,000 422,675 - -
Operating Transfer to General Fund 29,500 29,500 29,500 4,917
Total Expenditures 609,500 452,634 777,939 4,917
Net Surplus (Deficit)(144,400)$ 28,135$ (291,939)$ 6,726$
Beginning Fund Balance 304,939 333,074
Ending Fund Balance 333,074$ 339,800$
City of Evanston
Southwest TIF
As of February 28, 2014
19 of 38
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$ 1,714,049$
Special Assessment Levy - - 169,848 -
Bond Proceeds/Premium/ Discounts - 24,159,490 - -
Transfer from Other Funds - IMRF 783,004 764,003 141,125 23,521
Miscellaneous Revenue - 33,510 - -
Interest Income 1,500 5,356 1,500 95
Transfer from General Fund - 1,000,000 1,279,306 213,217
Transfer from Sewer Fund 190,210 190,210 207,284 34,547
Transfer from Special Assessment Fund 317,660 317,660 169,848 28,308
Total Revenue 13,090,393 38,334,891 12,848,904 2,013,737
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 750
Total Expenditures 13,824,528 37,874,257 13,933,114 357,113
Net Surplus (Deficit)(734,135)$ 460,634$ (1,084,210)$ 1,656,624$
Beginning Fund Balance 2,896,148 3,356,782
Ending Fund Balance 3,356,782$ 5,013,406$
City of Evanston
Debt Service Fund
As of February 28, 2014
20 of 38
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$ 8,405$
Interest Income 400 344 400 -
Bond Proceeds - - - -
Miscellaneous - 33,014 - 7,484
Total Revenue 500,400 507,574 350,400 15,889
Economic Dev. Projects - - - -
Debt Service - Interest - 544 - 98
Capital Improvements 800,000 215,402 - -
Developer Agreement Payments 610,000 510,237 300,000 81,014
Repayments to Econ. Dev. Fund 48,500 48,500 45,500 7,583
Transfers to General Fund 120,400 120,400 60,000 10,000
Total Expenditures 2,037,736 895,083 405,500 98,695
Net Surplus (Deficit)(1,537,336)$ (387,509)$ (55,100)$ (82,806)$
Beginning Fund Balance 1,055,510 668,001
Ending Fund Balance 668,001$ 585,195$
City of Evanston
Howard Ridge TIF
As of February 28, 2014
21 of 38
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 12
Total Revenue 3,701,000 51,311 40,100 12
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,202
Transfers to General Fund 60,000 60,000 60,000 10,000
Capital Projects 1,285,000 179,000 - -
Total Expenditures 3,635,000 381,044 165,000 11,202
Net Surplus (Deficit)66,000$ (329,733)$ (124,900)$ (11,190)$
Beginning Fund Balance 872,847 543,114
Ending Fund Balance 543,114$ 531,924$
City of Evanston
West Evanston TIF
As of February 28, 2014
22 of 38
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 February 28, 2014
23 of 38
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 264,785
Private Contributions 510,000 - 708,000 -
Parking Fund Loan for Financial System 596,000 - 100,000 -
General Fund Allocation - - 936,500 156,083
Miscellaneous - 53,986 - -
Interest Income 10,000 18,562 10,000 1,217
Total Revenue 11,130,988 9,102,442 15,468,596 422,085
Capital Outlay (includes prior year rollovers) 13,100,351 6,440,749 17,935,016 529,862
Interfund Transfers Out 475,000 475,000 475,000 79,167
Total Expenditures 13,575,351 6,915,749 18,410,016 609,029
Net Surplus (Deficit)(2,444,363)$ 2,186,693$ (2,941,420)$ (186,944)$
Beginning Fund Balance 3,401,911 5,588,604
Ending Fund Balance 5,588,604$ 5,401,660$
City of Evanston
Capital Improvement Fund
As of February 28, 2014
24 of 38
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$ 78,171$
Bond Proceeds 250,000 241,906 250,000 -
Investment Income 10,000 1,982 1,200 143
Total Revenue 560,000 518,414 481,200 78,314
Transfer to Debt Service Fund 317,660 317,660 169,848 28,308
General Management & Support - - 1,000 -
Capital Outlay 361,000 33,976 500,000 -
Total Expenditures 678,660 351,636 670,848 28,308
Net Surplus (Deficit)(118,660)$ 166,778$ (189,648)$ 50,006$
Beginning Fund Balance 1,905,315 2,072,093
Ending Fund Balance 2,072,093$ 2,122,099$
City of Evanston
Special Assessment Fund
As of February 28, 2014
25 of 38
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$ 350,400$
Church Street Garage Operations 716,348 618,913 716,348 90,348
Maple Avenue Garage Operations 1,204,200 1,142,379 1,204,200 205,932
Sherman Avenue Garage Operations 1,417,275 7,419,581 1,417,275 239,623
Washington National TIF Interfund Transfers-In 3,631,350 3,631,350 2,925,296 487,549
Interest Income 15,070 11,892 15,070 2,995
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 1,376,847
7005 - Parking System Administration 784,607 997,485 976,360 114,772
7015 - Parking Lots and Meters 829,052 655,080 972,266 126,519
7025 - Church Street Self Park 607,955 414,444 624,855 11,609
7030 - Church Street Debt Payments 171,250 171,250 171,250 -
7036 - Sherman Avenue Garage 5,750,270 10,671,714 5,047,016 86,329
7037 - Maple Avenue Garage 1,611,920 865,571 1,654,244 40,668
7039 - Parking Debt 27,461 27,461 27,461 -
Transfer to Insurance Fund 490,236 490,236 319,648 53,275
Transfer to General Fund 644,242 644,242 869,242 144,873
Transfer to Fleet 21,991 21,992 21,991 3,665
Transfer to Equipment Replacement 30,000 30,000 30,000 5,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 586,710
Net Surplus (Deficit)(5,120,337)$ (1,130,509)$ (4,500,740)$ 790,137$
Further Operating Expense Breakdown:
7015 Parking Meter Activities 762,846 655,080 935,614 126,519
7015 Parking Meter Depreciation 36,652 - 36,652 -
SUBTOTAL 799,498 655,080 972,266 126,519
7025- Church Garage Activities 494,156 414,444 444,927 11,609
7025- Church Garage Depreciation 179,928 - 179,928 -
SUBTOTAL 674,084 414,444 624,855 11,609
7036 Sherman Garage Activities 1,199,756 7,421,714 468,766 (324,346)
7036 Debt Service Payments 3,250,300 3,250,000 3,703,600 410,675
7036 Reserve (Depreciation)874,650 - 874,650 -
SUBTOTAL 5,324,706 10,671,714 5,047,016 86,329
7037 Maple Garage Activities 1,013,991 865,571 988,046 40,668
7037 Debt Service Payments - - - -
7037 Reserve (Depreciation)666,198 - 666,198 -
SUBTOTAL 1,680,189 865,571 1,654,244 40,668
Beginning Unrestricted Fund Balance 14,418,330 13,287,821
Ending Unrestricted Fund Balance 13,287,821$ 14,077,958$
City of Evanston
Parking Fund
As of February 28, 2014
26 of 38
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$ 965,568$
Skokie 2,856,000 2,772,424 2,913,000 713,578
Northwest Commission 4,517,000 4,898,986 4,653,000 882,731
Cross Connection Control Fees 100,500 94,470 95,000 -
Investment Earnings 2,500 20,164 2,500 4,058
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 992
Fees and Outside Work 80,000 188,610 70,000 14,027
Grants - - - -
Insurance Reimbursements - - - -
Phosphate Sales 66,000 52,795 69,000 11,550
Property Sales and Rentals 213,300 235,936 227,316 -
Misc Revenue - 162,767 - 1,565
Total Revenue 17,560,000 16,646,625 20,327,216 2,594,069
General Support 990,583 944,465 933,989 142,059
Pumping 2,333,247 2,173,144 2,355,718 269,656
Filtration 2,635,539 2,339,158 2,740,856 237,652
Distribution 1,424,324 1,356,808 1,425,352 218,244
Meter Maintenance 309,163 254,560 300,760 36,625
Other Operating Expenses 478,592 379,183 491,700 47,536
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 300
Capital Improvements 8,065,700 4,765,577 10,170,000 127,031
Interfund Transfers Out - General Fund 3,356,300 3,356,300 3,369,559 561,593
Interfund Transfers Out - Insurance Fund 468,492 468,492 468,492 78,082
Total Expense 21,242,179 17,195,021 23,989,735 2,030,450
Net Surplus (Deficit)(3,682,179)$ (548,396)$ (3,662,519)$ 563,619$
Beginning Unrestricted Fund Balance 9,192,655 8,644,259
Ending Unrestricted Fund Balance 8,644,259$ 9,207,878$
City of Evanston
Water Fund
As of February 28, 2014
27 of 38
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$ 2,897,767$
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 -
Total Revenue 20,027,865 18,584,478 15,117,865 2,897,767
Sewer Operations 2,134,549 1,979,122 2,260,545 214,941
Other Operating Expenses 43,300 23,100 129,500 -
Interfund Transfers Out - General Fund 142,200 142,200 145,044 24,174
Interfund Transfers Out - Insurance Fund 269,988 269,988 269,988 44,998
Transfer to Debt Service 190,211 190,210 207,284 34,547
Capital Outlay 20,600 13,714 47,500 -
Capital Improvement Account 4,922,500 4,579,112 3,225,000 -
Debt Service 11,542,740 11,542,807 9,994,259 552,633
Total Expenses 19,266,088 18,740,253 16,279,120 871,293
Net Surplus (Deficit) 761,777$ (155,775)$ (1,161,255)$ 2,026,474$
Beginning Unrestricted Fund Balance 4,199,578 4,043,803
Ending Unrestricted Fund Balance 4,043,803$ 6,070,277$
City of Evanston
Sewer Fund
As of February 28, 2014
28 of 38
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$ 175,995$
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 587,894
Sanitation Service Charge Penalty 30,000 44,099 45,000 19,046
Special Pickup Fees 100,000 74,784 100,000 95
State Recycling Grant - - - -
Trash Cart Sales 15,000 27,738 15,000 76
Investment Income - 20 - -
Yard Waste Fees 350,000 247,627 220,000 8,777
Total Revenue 5,010,000 5,130,397 4,970,000 791,883
Refuse Collection & Disposal 3,259,574 2,942,329 3,372,698 234,261
Residential Recycling Collection 1,254,398 1,207,081 1,186,134 203,196
Yard Waste Collection 750,250 626,253 750,250 -
Total Expense 5,264,222 4,775,663 5,309,082 437,457
Net Surplus (Deficit)(254,222)$ 354,734$ (339,082)$ 354,426
Beginning Unrestricted Fund Balance (1,447,885) (1,093,151)
Ending Unrestricted Fund Balance (1,093,151)$ (738,725)
City of Evanston
Solid Waste
As of February 28, 2014
29 of 38
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$ 417,893$
Library Fund 2,381 2,381 2,381 397
Parking Fund 21,992 21,992 21,992 3,665
Water Fund 122,751 122,751 122,751 20,458
Sewer Fund 177,729 177,729 177,729 29,622
Solid Waste Fund 298,071 298,071 298,071 49,679
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 532,218
General Support 292,007 261,029 293,619 42,167
Major Maintenance 3,217,058 3,299,061 3,284,528 356,604
Total Expenditures 3,509,065 3,560,090 3,578,147 398,771
Net Surplus (Deficit)(342,996)$ 216,540$ (412,078)$ 133,447$
Beginning Fund Balance (107,097) 109,443
Ending Fund Balance 109,443$ 242,890$
City of Evanston
Fleet Maintenance Fund
As of February 28, 2014
30 of 38
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$ 207,098$
Library Fund 1,700 1,700 1,700 283
Parking Fund 30,000 30,000 30,000 5,000
Solid Waste Fund 177,131 177,131 177,131 29,522
Bond Proceeds - - 1,000,000 -
Sale of Surplus Property 210,217 124,667 210,217 7,653
Total Revenues 1,661,638 1,576,088 2,661,638 249,556
Capital Outlay 2,400,000 1,487,556 2,494,000 220,146
Carryover - - 200,000 -
Capital Leases 50,000 42,686 50,000 -
Total Expenditures 2,450,000 1,530,242 2,744,000 220,146
Net Surplus (Deficit)(788,362)$ 45,846$ (82,362)$ 29,410$
Beginning Fund Balance 1,500,482$ 1,546,328$
Ending Fund Balance 1,546,328$ 1,575,738$
City of Evanston
Equipment Replacement Fund
As of February 28, 2014
31 of 38
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$ 20,201$
General Admin Contribution- E911 930 930 930 155
General Admin Contribution- CDBG 930 930 930 155
General Admin Contribution- E.D.930 930 930 155
General Admin Contribution- Parking 17,032 17,032 17,032 2,839
General Admin Contribution- Water Fund 24,962 24,962 24,962 4,160
General Admin Contribution- Sewer Fund 14,385 14,385 14,385 2,398
Liability/Property Contribution- General 909,150 909,150 909,150 151,525
Liability/Property Contribution- E911 6,972 6,972 6,972 1,162
Liability/Property Contribution- CDBG 6,972 6,972 6,972 1,162
Liability/Property Contribution- E.D. 6,972 6,972 6,972 1,162
Liability/Property Contribution- Parking 127,731 127,731 127,731 21,289
Liability/Property Contribution- Water Fund 187,209 187,209 187,209 31,202
Liability/Property Contribution- Sewer Fund 107,887 107,887 107,887 17,981
Workers' Comp Contribution- General 1,244,860 1,244,860 1,244,860 207,477
Workers' Comp Contribution- Library Fund 5,898 5,898 40,000 6,666
Workers' Comp Contribution- E911 9,546 9,546 9,546 1,591
Workers' Comp Contribution- CDBG 9,546 9,546 9,546 1,591
Workers' Comp Contribution- E.D. 9,546 9,546 9,546 1,591
Workers' Comp Contribution- Parking 174,886 174,886 174,886 29,148
Workers' Comp Contribution- Water Fund 256,322 256,322 256,322 42,720
Workers' Comp Contribution- Sewer Fund 147,716 147,716 147,716 24,619
Subrogation Proceeds 83,300 155,102 100,000 19,005
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 589,954
Health Insurance Chargebacks- General 8,232,350 8,262,909 8,780,657 1,463,443
Health Insurance Chargebacks - Library 318,681 - 366,065 61,011
Health Insurance Chargebacks - NSP2 16,390 16,390 6,863 1,144
Health Insurance Chargebacks- E911 81,545 81,545 71,410 11,902
Health Insurance Chargebacks- CDBG 12,586 12,586 31,521 5,253
Health Insurance Chargebacks- E.D. Fund 56,081 49,968 49,098 8,183
Health Insurance Chargebacks- Home Fund - - 2,735 456
Health Insurance Chargebacks- Parking 170,588 170,588 171,325 28,554
Health Insurance Chargebacks- Water 596,392 596,392 616,227 102,705
Health Insurance Chargebacks- Sewer 168,030 168,030 183,218 30,536
Health Insurance Chargebacks - Solid Waste 114,220 114,220 106,846 17,808
Health Insurance Chargebacks- Fleet 183,414 183,414 202,427 33,738
Retiree Health Insurance Contributions 1,684,894 1,688,954 1,970,647 266,142
Employee Health Insurance Contributions 1,760,276 1,808,346 1,706,017 238,448
One Time IPBC Distribution 300,000 300,000 300,000 50,000
Health & Life insurance - Subtotal 13,695,447 13,453,342 14,565,056 2,319,323
Total Revenues 17,211,983 17,520,242 18,091,744 2,909,277
City of Evanston
Insurance Fund
As of February 28, 2014
32 of 38
FY 2013 FY 2013 FY 2014 FY 2014
Budget Unaudited Budget YTD
Amended Actual Adopted Actual
City of Evanston
Insurance Fund
As of February 28, 2014
General Administration & Support 294,093 288,369 409,548 39,596
Auditing 25,000 - - -
Liability/Property Insurance Premiums 470,000 455,514 470,000 485,115
Liability Legal Fees 350,000 571,721 350,000 46,131
Liability Settlement Payments 400,000 471,052 400,000 10,147
Transfer - to ERI Debt Service 8,325 8,325 8,627 1,438
Workers' Comp Insurance Premiums 114,400 111,111 114,400 109,328
Workers' Comp Legal Fees 80,500 38,694 80,500 12,208
Workers' Comp Medical Payments 800,000 494,020 600,000 74,870
Workers' Comp Settlement Payments 1,100,000 899,625 1,100,000 18,807
Workers' Comp TPA Pymts (non specific)145,000 107,155 125,000 11,544
Workers' Comp TTD Pymts (non sworn)- 48,092 - -
Workers' Comp & Liability - Subtotal 3,787,318 3,493,678 3,658,075 809,184
General Administration & Support 94,093 87,437 99,805 12,911
Health Insurance Premiums 13,458,615 13,183,406 14,217,604 2,260,641
Health Insurance Opt Out Payments 84,000 45,133 91,800 3,578
Health & Life Insurance - Subtotal 13,636,708 13,315,976 14,409,209 2,277,130
Total Expenditures 17,424,026 16,809,654 18,067,284 3,086,314
Net Surplus (Deficit)(212,043)$ 710,588$ 24,460$ (177,037)$
Beginning Unrestricted Fund Balance (7,376,499) (6,665,911)
Ending Unrestricted Fund Balance (6,665,911)$ (6,842,948)$
33 of 38
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$ 875,442$
Personal Property Repl Tax 280,000 280,000 280,000 -
Interest on Investment 800,000 1,564,892 850,000 29
Participant Contributions 922,500 941,743 950,000 130,778
Unrealized Gain - 134 - 5,000
Miscellaneous - 150 - -
Total Revenue 8,064,075 8,836,152 8,141,575 1,011,249
Administrative Expenses 154,000 266,237 154,000 5,908
Legal Fees 50,000 - 50,000 -
Retiree Pensions 4,841,000 4,871,953 4,995,500 1,343,330
Widows' Pensions 1,090,000 1,053,398 1,071,200 146,970
Disability Pensions 1,350,000 1,304,970 1,358,125 107,408
QUILDRO 75,000 90,364 90,000 3,620
Reserve for Future Payments - - - -
Total Expenditures 7,560,000 7,586,922 7,718,825 1,607,236
Net Surplus (Deficit)504,075$ 1,249,230$ 422,750$ (595,987)$
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$ 59,117,159$
City of Evanston
Fire Pension Fund
As of February 28, 2014
34 of 38
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$ 1,167,815$
Personal Property Repl Tax 325,000 325,000 325,000 -
Interest Income 2,625,000 3,036,641 2,800,000 99
Participant Contributions 1,383,750 1,705,893 1,423,000 206,874
Miscellaneous - - - -
Unrealized Gain / (Loss) - - - -
Total Revenue 12,403,075 13,145,447 12,617,325 1,374,788
Administrative Expenses 250,000 264,356 250,000 -
Retiree Pensions 7,500,769 7,787,104 8,056,000 877,797
Widow Pensions 868,000 857,302 875,500 178,522
Disability Pensions 700,000 662,888 700,000 217,466
Separation Refunds 150,000 109,252 275,000 -
QUILDRO 18,000 21,085 18,000 17,146
Reserve for Future Payments - - - -
Total Expenditures 9,486,769 9,701,987 10,174,500 1,290,931
Net Surplus (Deficit)2,916,306$ 3,443,460$ 2,442,825$ 83,857$
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$ 84,117,278$
City of Evanston
Police Pension Fund
As of February 28, 2014
35 of 38
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$ 586,839$
Library Fines & Fees 185,000 158,176 164,000 25,933
Library Material Replacement 12,500 12,484 14,000 2,376
Copy Machine Charges 20,000 18,814 21,200 2,935
Meeting Room Fees 10,000 12,397 10,400 6,542
Non-resident Cards 1,690 1,565 1,040 130
North Branch Rental Income 59,660 58,697 60,000 1,897
State Per Capita Grant 76,300 131,976 94,177 8,740
Personal Property Repl. Tax 50,200 50,200 50,200 -
Video Rentals - - - -
Transfer from General Fund - - - 35,590
Book Sales 60,000 56,140 65,000 2,187
Fund for Excellence 245,000 127,432 125,000 13,084
Grants and Donations - - 116,545 -
Transfer from Economic Development - 9,900 - -
Miscellaneous - 5,103 - 89
Transfer from Endowment 131,250 131,250 159,315 -
Total Revenues 5,104,814 4,939,647 5,912,974 686,342
Expenditures
Youth Services 891,720 901,891 1,030,009 136,874
Adult Services 1,535,224 1,538,511 1,514,037 187,247
Circulation 612,892 605,815 573,258 82,322
Neighborhood Services 360,757 325,202 456,528 61,908
Technical Services 503,433 431,115 538,879 65,201
Maintenance 507,517 669,172 660,703 84,872
Administration 669,377 677,112 1,103,015 150,100
Library Grants - 35,570 36,545 -
Total Expenditures 5,080,920 5,184,388 5,912,974 768,524
Net Surplus (Deficit)23,894$ (244,741)$ -$ (82,182)$
Beginning Fund Balance 1,101,096 856,355
Ending Fund Balance 856,355 774,173
City of Evanston
Library Fund
As of February 28, 2014
36 of 38
FY 2013 FY 2013 FY 2014 FY 2014
Budget Unaudited Budget YTD
Amended Actual Adopted Actual
Revenue By Source
Net Property Taxes -$ -$ 748,178$ -$
Library Fines & Fees - - 1,000 -
Total Revenues - - 749,178 -
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$ -$
Beginning Fund Balance - -
Ending Fund Balance - -
City of Evanston
Library Debt Fund
As of February 28, 2014
37 of 38
January February March April May June July August September October November December
FY 2014 Unreserved Fund Balance 17,321,904$ 17,910,959$
FY 2013 Unreserved Fund Balance 17,412,530$ 18,091,096$
FY 2014 Cash Balance 4,173,079$ 6,745,425$
FY 2013 Cash Balance 6,624,063$ 7,811,937$
$-
$2,000,000
$4,000,000
$6,000,000
$8,000,000
$10,000,000
$12,000,000
$14,000,000
$16,000,000
$18,000,000
$20,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
38 of 38