HomeMy WebLinkAbout2014.09 September Monthly Report
To: Wally Bobkiewicz, City Manager
Martin Lyons, Assistant City Manager/Chief Financial Officer
From: Ashley Porta, Budget Manager
Andrew Villamin, Interim Accounting Manager
Subject: September 2014 Monthly Financial Report
Date: October 31, 2014
Please find attached the unaudited financial statements as of September 30, 2014. A
summary by fund for total revenues, expenditures/expenses, fund balances, and cash
balances is as follows:
YTD YTD YTD 9/31/2014 9/31/2014
9/31/2014 9/31/2014 9/31/2014 Unreserved Cash
Fund Name Fund #Revenue Expenses Net Fund Balance Balance*
General 100 70,160,789$ 66,085,169$ 4,075,620$ 20,438,571$ 10,328,206$
General Assistance Fund 175 875,636 502,671 372,965 372,965 372,965
Neighborhood Stabilization 195 1,383,717 897,725 485,991 485,991 454,187
Motor Fuel 200 1,691,447 1,484,868 206,579 1,519,147 2,003,939
Emergency 911 205 661,811 917,452 (255,641) 965,238 699,793
SSA#4 210 311,063 240,000 71,063 (78,272) (109,139)
CDBG 215 1,045,231 916,739 128,492 141,291 (33,431)
CDBG Loan 220 199,611 182,666 16,945 2,371,216 131,776
Economic Development 225 1,375,433 1,502,200 (126,768) 3,380,434 2,817,333
Neighborhood Improvement 235 - - - 149,915 149,915
Home 240 530,228 591,953 (61,725) 3,880,803 (51,551)
Affordable Housing 250 131,304 55,792 75,512 2,526,590 813,897
Washington National TIF 300 4,934,683 2,519,057 2,415,626 7,453,067 7,045,667
SSA#5 305 428,530 31,025 397,505 872,390 811,083
SW II TIF (Howard Hartrey)310 1,151,922 1,129,330 22,592 3,379,640 3,364,006
Southwest TIF 315 607,668 22,125 585,543 930,260 918,617
Debt Service 320 12,496,300 2,609,206 9,887,094 13,262,785 11,743,188
Howard Ridge TIF 330 480,517 803,551 (323,034) 65,583 53,930
West Evanston TIF 335 100,724 49,228 51,496 589,135 589,136
Dempster-Dodge TIF 340 - - - - -
Capital Improvement 415 9,838,320 3,786,008 6,052,311 12,352,310 12,936,638
Special Assessment 420 615,932 132,225 483,707 2,556,122 2,552,126
Parking 505 7,103,763 4,699,968 2,403,795 16,006,614 15,348,942
Water 510-513 14,757,372 10,945,700 3,811,672 12,401,763 11,192,012
Sewer 515 11,088,766 10,923,164 165,602 4,740,598 4,259,962
Solid Waste 520 3,680,760 3,267,710 413,051 (870,509) (1,279,425)
Fleet 600 2,388,860 2,323,372 65,487 176,053 (413,021)
Equipment Replacement 601 2,195,887 1,396,949 798,938 1,387,921 1,387,920
Insurance 605 13,489,668 12,926,258 563,410 (3,164,252) 1,624,013
Library 185 5,575,258 4,108,055 1,467,203 2,449,967 1,768,846
Library Debt Fund 186 739,506 53,724 685,782 685,782 685,782
Total**169,301,199$ 135,050,167$ 34,251,032$ 110,743,337$ 92,167,310$
*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
Included above are the ending balances as of September 30, 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. W hile ending fund balance is also
an important measurement of the City’s financial health, it usually includes illiquid
assets or future cash receipts or disbursements such as receivables (including property
tax) due to the City and accounts payable/accrued expenses.
As of September 30, 2014, the General Fund is reporting a surplus of $4,075,620 due to
several factors:
Timing of payroll; the City will have 3 pay dates in December 2014
(December 4, 18 and 31)
Receipt of the Kellog building permit
Receipt of second installment property taxes
Through September 30, 2014, the Special Service Area (SSA) #4 Fund is showing a
negative cash balance of $109,139.
Through September 30, 2014, the Community Development Block Grant (CDBG) Fund
is showing a fund balance of $141,291 with a negative cash balance of $33,431. The
City expects HUD reimbursements to eliminate this negative balance in the next month.
Through September 30, 2014, the Economic Development Fund is showing a fund
balance of $3,380,434 and a cash balance of $2,817,333. These balances include
approximately $1 million of revenue associated with the Gigabit Challenge.
Through September 30, 2014, the Solid Waste Fund is operating at a $413,051 surplus
for the year; this fund will also have three pay periods in December, thus reducing the
surplus. There is still a balance of $870,509 and a negative cash balance of $1,279,425
which is a $100,000 improvement over last month.
Though operating at a surplus for the year, through September 30, 2014 the Fleet Fund
is showing a negative cash balance of $413,021.
Through September 30, 2014, the Insurance Fund is showing a negative fund balance
of $3,164,252. This negative balance is primarily for claims/cases being reserved and
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 in surance payments, totaling
$601,314, were paid in January, which further reduced the fund balance of the
Insurance Fund. These payments will gradually be reimbursed through FY 2014 from
interfund transfers to the Insurance Fund. Staff will continue to monitor the Insurance
Fund and provide regular updates to the City Council in the future. The Insurance
Fund’s cash balance of $1,624,013 includes a transfer from the IPBC Health Insurance
Pool of $500,000.
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
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$ 12,099,016$ 98.6%-$ -$ -$ -$ -$ -$ -$ -$
Sales Tax 15,790,000 11,270,030 71.4%- - - - - - - -
State Income Tax 7,076,170 5,377,426 76.0%- - - - - - - -
Utility Tax 8,220,000 6,189,164 75.3%- - - - - - - -
Real Estate Transfer Tax 2,875,000 2,030,175 70.6%- - - - - - - -
Liquor Tax 2,375,000 2,015,098 84.8%- - - - - - - -
Other Taxes 5,940,053 4,165,054 70.1%- - - - - - - -
Licenses, Permits, Fees 12,622,280 10,409,485 82.5%- - - - - - - -
Charges for Services 7,936,754 5,847,372 73.7%6,434,293 7,103,763 110.4%13,913,400 11,444,453 82.3%12,922,700 9,982,155 77.2%3,889,033 2,867,933 73.7%
Intergovernmental Revenues 721,272 900,730 124.9%- - - 14,181 - - 25,000 20,852 83.4%
Interfund Transfers 7,742,893 5,900,974 76.2%2,925,296 - 0.0%- - - - 1,055,967 791,975 75.0%
Other Non-Tax Revenue 5,614,490 3,956,265 70.5%2,034,004 - 0.0%6,413,816 3,298,738 51.4%2,191,000 1,106,611 50.5%- -
Total Revenues 89,185,298$ 70,160,789$ 78.7%11,393,593$ 7,103,763$ 62.3%20,327,216$ 14,757,372$ 72.6%15,113,700$ 11,088,766$ 73.4%4,970,000$ 3,680,760$ 74.1%
Expenditures
Legislative 677,621$ 516,985$ 76.3%-$ -$ -$ -$ -$ -$ -$ -$
City Administration 1,941,115 1,225,855 63.2%- - - - - - - -
Law Department 1,045,232 751,262 71.9%- - - - - - - -
Administrative Services Department 8,826,606 5,747,690 65.1%- - - - - - - -
Community Development 2,652,887 1,878,446 70.8%- - - - - - - -
Police Department 26,876,444 20,390,171 75.9%- - - - - - - -
Fire & Life Safety Services 14,072,488 10,717,354 76.2%- - - - - - - -
Health Department 3,009,286 2,295,145 76.3%- - - - - - - -
Public Works - Operating 17,884,613 13,332,100 74.5%10,714,333 4,699,968 43.9%- - - - 5,309,082 3,267,710 61.5%
Public Works - Capital Outlay - - 5,180,000 - 0.0%- - - - - -
Parks, Recreation & Comm. Services 10,483,281 9,230,161 88.0%- - - - - - - -
Capital Improvement Transfer 936,500 - 0.0%
Transfer to Debt Service Fund 609,000 - 0.0%- - - - - - - -
Utilities - Operating - - - - 13,451,635 6,291,231 46.8%13,006,620 9,136,365 70.2%- -
Utilities - Capital Outlay - - - - 10,538,100 4,654,469 44.2%3,272,500 1,786,799 54.6%- -
Total Expenditures 89,015,073$ 66,085,169$ 74.2%15,894,333$ 4,699,968$ 29.6%23,989,735$ 10,945,700$ 45.6%16,279,120$ 10,923,164$ 67.1%5,309,082$ 3,267,710$ 61.5%
As of September 30, 2014
Report of Budget-to-Actual Revenues and Expenditures
Parking Fund Water Fund Solid Waste FundSewer FundGeneral Fund
(Target is 75% of FY 2014 Budget)
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Tax - Property 12,481,386$ 11,941,575$ 12,271,386$ 12,099,016$
Tax - State Use 1,176,879 1,283,156 1,241,753 879,826
Tax - Sales Tax - Basic 9,291,000 9,717,393 9,690,000 6,955,554
Tax - Sales Tax - Home Rule 5,861,800 5,964,747 6,100,000 4,314,476
Tax - Auto Rental 40,000 43,598 40,000 33,763
Tax - Athletic Contest 760,000 1,056,355 800,000 188,657
Tax - State Income 6,322,645 7,182,793 7,076,170 5,377,426
Tax - Electric Utility 3,069,806 3,000,629 3,070,000 2,226,067
Tax - Natural Gas Utility 1,400,000 1,090,915 1,200,000 1,228,881
Tax - Natural Gas Use - Home Rule 800,000 760,734 800,000 628,897
Tax - Cigarette 485,000 372,000 300,000 132,000
Tax - Evanston Motor Fuel 707,667 634,196 610,000 548,359
Tax - Liquor 2,350,000 2,261,874 2,375,000 2,015,098
Tax - Parking 2,200,000 2,418,852 2,350,000 1,801,147
Tax - Personal Property Replacement 591,600 721,173 598,300 581,302
Tax - Real Estate Transfer 2,146,300 3,940,899 2,875,000 2,030,175
Tax - Telecommunications 3,244,500 2,837,899 3,150,000 2,105,319
License Fees - Vehicles 2,600,000 2,349,686 2,700,000 534,018
License Fees - Other 1,030,502 1,427,835 937,302 749,811
Permit Fees - Building 3,020,000 3,951,048 6,142,162 6,048,546
Permit Fees - Other 1,209,788 1,746,109 1,486,716 1,945,441
Other Fees 1,559,350 1,152,473 1,356,100 1,131,669
Fines and Forfeiture Revenue 4,366,022 3,448,523 4,366,022 2,376,596
Charges for Services Revenue 7,904,198 7,845,651 7,936,754 5,847,372
Intergovernmental Revenue 786,798 1,425,907 721,272 900,730
Other Revenue 1,418,443 647,935 1,238,468 1,568,964
Interfund Transfers In (Other Funds)7,693,367 7,521,427 7,742,893 5,900,974
Interest Income 6,000 26,907 10,000 10,705
Total Revenue 84,523,051 86,772,289 89,185,298 70,160,789
Legislative 657,069 421,198 677,621 516,985
City Administration 1,582,580 1,818,451 1,941,115 1,225,855
Law Department 973,254 973,254 1,045,232 751,262
Administrative Services Department 7,721,650 8,546,089 8,826,606 5,747,690
Community Development 2,536,250 2,536,209 2,652,887 1,878,446
Police Department 26,508,585 26,508,583 26,876,444 20,390,171
Fire & Life Safety Services Department 14,142,078 14,142,077 14,072,488 10,717,354
Health Department 2,917,848 3,601,469 3,009,286 2,295,145
Public Works Department 10,043,463 11,186,023 17,884,613 13,332,100
Parks, Recreation & Community Services 17,616,397 14,744,293 10,483,281 9,230,161
Transfer to Solid Waste Fund - 1,245,967 936,500 -
Transfer to Debt Service Fund 1,000,000 1,000,000 609,000 -
Transfer to Fleet Maintenance Fund 600,000 600,000 - -
Transfer to Insurance Fund 500,000 500,000 - -
Total Expenditures 86,799,174 87,823,613 89,015,073 66,085,169
Net Surplus (Deficit)(2,276,123)$ (1,051,324)$ 170,225$ 4,075,620$
Beginning Unrestricted Fund Balance (Note 1) 17,033,487 16,362,951
Adjustment to GAAP Basis of Accounting 380,788 -
Total Ending Fund Balance 16,362,951$ 20,438,571$
Note 1: Unrestricted fund balance includes amounts designated for compensated absences and IMRF.
City of Evanston
General Fund
As of September 30, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Property Taxes 407,251$
Misc. Revenue - - 2,117
Transfers from other Funds - - - 466,269
Total Revenue - - - 875,636
Administration - - - 98,775
Client Payments - - - 403,896
Capital Outlay - - - -
Community Sponsored Org - - - -
Total Expenditures - - - 502,671
Net Surplus (Deficit) -$ -$ -$ 372,965$
Beginning Fund Balance - -
Ending Fund Balance -$ 372,965$
City of Evanston
General Assistance Fund
As of September 30, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Grant Proceeds 4,011,917$ 2,885,571$ 458,044$ 782,855$
Program Income - 347 - 600,135
Investment Income - - - 727
Total Revenue 4,011,917 2,885,918 458,044 1,383,717
Development Activities 3,505,000 2,653,385 290,500 567,694
Administration 341,622 128,520 126,635 252,114
Transfer to Debt Service 3,905 - 4,046 6,940
Transfer to Insurance 16,390 16,390 6,863 5,260
Transfer to General Fund 145,000 87,624 30,000 65,718
Total Expenditures 4,011,917 2,885,918 458,044 897,725
Net Surplus (Deficit) -$ 0$ -$ 485,991$
Beginning Fund Balance - -
Ending Fund Balance 0$ 485,991$
City of Evanston
Neighborhood Stabilization Fund
As of September 30, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
State Allotment 2,125,000$ 2,118,506$ 1,750,000$ 1,368,848$
Grant Revenue -$ -$ -$ 322,396$
Investment Earnings 2,000 482 500 202
Miscellaneous Income - - - -
Total Revenue 2,127,000 2,118,988 1,750,500 1,691,447
Street Resurfacing 1,400,000 972,788 1,400,000 860,118
Transfer to General Fund - Staff Engineering 133,000 133,000 133,000 624,750
Transfer to General Fund - Street Maintenance 700,000 700,000 700,000 -
Total Expenditures 2,233,000 1,805,788 2,233,000 1,484,868
Net Surplus (Deficit)(106,000)$ 313,200$ (482,500)$ 206,579$
Beginning Fund Balance 999,368 1,312,568
Ending Fund Balance 1,312,568$ 1,519,147$
City of Evanston
Motor Fuel Fund
As of September 30, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Landline Surcharge Revenue 617,400$ 549,934$ 529,200$ 388,510$
Wireless Surcharge Revenue 416,160 454,019 428,400 170,714
Interest Income 1,000 215 1,000 74
Grants 102,078
Miscellaneous Revenue - - - 435
Total Revenue 1,034,560 1,004,169 958,600 661,811
Operating Expense 891,122 785,259 935,767 636,089
Transfer to General Fund 125,950 125,950 125,950 94,462
Transfer to Insurance Fund 98,993 98,993 88,858 13,086
Transfer to Debt Service Fund 11,215 11,215 11,622 8,717
Capital Replacement 120,000 26,680 250,000 165,097
Total Expenditures 1,247,280 1,048,097 1,412,197 917,452
Net Surplus (Deficit)(212,720)$ (43,928)$ (453,597)$ (255,641)$
Beginning Fund Balance 1,264,807 1,220,879
Ending Fund Balance 1,220,879$ 965,238$
City of Evanston
E911 Fund
As of September 30, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Property Tax Revenue 370,000$ 337,668$ 370,000$ 311,060$
Investment Income - - - 4
Total Revenues 370,000 337,668 370,000 311,063
Professional Fees (Evmark)370,000 370,000 370,000 240,000
Total Expenditures 370,000 370,000 370,000 240,000
Net Surplus (Deficit)-$ (32,332)$ -$ 71,063$
Beginning Fund Balance (117,003) (149,335)
Ending Fund Balance (149,335)$ (78,272)$
City of Evanston
Special Service Area #4 Fund
As of September 30, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Intergovernmental/Entitlement 1,540,000$ $ 1,665,720 1,500,000$ $ 1,031,929
Funds Reallocated from Prior Years 33,100 - 168,088 -
Program Income 352,000 14,412 70,000 13,196
Miscellaneous - - - 106
Total Revenues 1,925,100 1,680,132 1,738,088 1,045,231
CDBG Administration/Planning 195,522 239,602 300,000 275,100
Development Activities 612,500 293,045 456,288 152,724
Capital Projects 494,800 493,581 410,800 583
Transfers to Debt Service - 2,928 - 2,276
Transfers to General Fund 781,278 650,976 571,000 486,056
Total Expenditures 2,084,100 1,680,132 1,738,088 916,739
Net Surplus (Deficit)(159,000)$ -$ -$ 128,492$
Beginning Fund Balance 12,799 12,799
Ending Fund Balance 12,799$ 141,291$
City of Evanston
CDBG Fund
As of September 30, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Intergovernmental Revenue -$ 205,904$ 50,000$ 162,278$
Program Income 9,000 3,554 10,000 37,283
Interest Income - - 100 50
Total Revenues 9,000 209,458 60,100 199,611
Program Expenses 20,000 - 20,000 182,666
Total Expenditures 20,000 - 20,000 182,666
Net Surplus (Deficit) (11,000)$ 209,458$ 40,100$ 16,945$
Beginning Fund Balance 2,144,813 2,354,271
Ending Fund Balance 2,354,271$ 2,371,216$
City of Evanston
CDBG Loan Fund
As of September 30, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Hotel Tax 1,600,000$ 1,554,281$ 1,500,000$ 1,113,440$
Amusement Tax 300,000 275,646 300,000 225,052
Howard-Ridge Loan Repayment 48,500 48,500 45,500 34,125
Grants - 999,000 1,000,000 -
Investment Income 800 922 800 2,816
Total Revenues 1,949,300 2,878,349 2,846,300 1,375,433
Economic Development Activities 1,830,209 983,057 1,760,889 1,114,163
Other Charges - Gigabit Challenge - - 1,000,000 24,718
Capital Projects 3,500 4,600 - -
Transfer to Debt Service 13,771 13,771 14,271 10,703
Transfer to Insurance 67,416 67,416 66,546 13,086
Transfers to General Fund 452,707 452,707 452,707 339,530
Total Expenditures 2,367,603 1,521,551 3,294,413 1,502,200
Net Surplus (Deficit)(418,303)$ 1,356,798$ (448,113)$ (126,768)$
Beginning Fund Balance 2,150,404 3,507,202
Ending Fund Balance 3,507,202$ 3,380,434$
City of Evanston
Economic Development Fund
As of September 30, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited 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 September 30, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Intergovernmental /Entitlement 797,400$ 703,935$ 674,500$ 509,631$
Interest Income - - - 59
Program Income - 6,693 - 20,538
Total Revenues 797,400 710,628 674,500 530,228
Home Administration/Planning 4,000 - 27,836 15,721
Development Activities 765,000 8,775 650,000 576,231
Transfers to General Fund 28,400 65,700 22,500 -
Total Expenditures 797,400 74,475 700,336 591,953
Net Surplus (Deficit) -$ 636,153$ (25,836)$ (61,725)$
Beginning Fund Balance 3,306,375 3,942,528
Ending Fund Balance 3,942,528$ 3,880,803$
City of Evanston
Home Fund
As of September 30, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Developer Contributions 155,000 290,000 155,000 125,088
Rehab Repayments - 11,188 - -
Interest Income 228 198 150 244
Miscellaneous - - - 5,972
Total Revenues 155,228 301,386 155,150 131,304
Housing - Buildings 227,800 30,692 200,000 393
Down Payment Assistance - - - 14,906
Transfers to General Fund 23,990 23,990 13,990 10,492
Miscellaneous 46,000 31,752 50,000 30,000
Total Expenditures 297,790 86,434 263,990 55,792
Net Surplus (Deficit)(142,562)$ 214,952$ (108,840)$ 75,512$
Beginning Fund Balance 2,236,126 2,451,078
Ending Fund Balance 2,451,078$ 2,526,590$
City of Evanston
Affordable Housing Fund
As of September 30, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Net Property Tax Increment 4,600,000$ 4,488,658$ 3,700,000$ 4,924,133$
Interest Income 25,000 13,072 10,000 10,550
Total Revenue 4,625,000 4,501,730 3,710,000 4,934,683
Series 1997 Principal
(refunded by 1999 & 2008D) 425,000 425,000 455,000 -
Series 1997 Interest
(refunded by 1999 and 2008D) 78,376 78,375 55,000 27,500
Contributions to Other Agencies - - - -
Economic Development Projects 1,250,000 128,999 1,250,000 49,335
Capital Improvements 2,836,000 2,158,380 722,486 -
Contractual Services 145,000 2,489 250,000 -
Transfer to Parking Fund (Sherman) 3,631,350 3,631,350 2,925,296 2,193,972
Transfer to General Fund 331,000 331,000 331,000 248,250
Total Expenditures 8,696,726 6,755,593 5,988,782 2,519,057
Net Surplus (Deficit) (4,071,726)$ (2,253,863)$ (2,278,782)$ 2,415,626$
Beginning Fund Balance 7,291,304 5,037,441
Ending Fund Balance 5,037,441$ 7,453,067$
City of Evanston
Washington National TIF Fund
As of September 30, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Net Property Taxes 448,875$ 460,062$ 397,800$ 428,525$
Interest Income - 585 - 5
Total Revenue 448,875 460,647 397,800 428,530
Series 2012A Bonds Principal 340,000 340,000 390,000 -
Series 2012A Bonds Interest 78,816 78,816 46,605 31,025
General Management Support - - - -
Total Expenditures 418,816 418,816 436,605 31,025
Net Surplus (Deficit)30,059$ 41,831$ (38,805)$ 397,505$
Beginning Fund Balance 433,054 474,885
Ending Fund Balance 474,885$ 872,390$
City of Evanston
Special Service Area #5
As of September 30, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Net Property Tax Increment 1,100,000$ 1,122,248$ 1,100,000$ 1,140,311$
Interest Income 10,000 14,087 10,000 11,610
Total Revenue 1,110,000 1,136,335 1,110,000 1,151,922
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 19,544
Surplus Distribution 1,000,000 1,000,000 -
Capital Projects 1,400,000 150,000 500,000 1,000,000
Other Expenses 500,000 9,915 - 1,486
Economic Development - - 2,500,000
Operating Transfer to General Fund 144,400 144,400 144,400 108,300
Total Expenditures 3,765,011 2,024,926 3,868,488 1,129,330
Net Surplus (Deficit)(2,655,011)$ (888,591)$ (2,758,488)$ 22,592$
Beginning Fund Balance 4,245,639 3,357,048
Ending Fund Balance 3,357,048$ 3,379,640$
City of Evanston
SW II TIF (Howard Hartrey)
As of September 30, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Net Property Tax Increment 465,000$ 492,410$ 485,000$ 607,662$
Interest Income 100 2 1,000 6
Total Revenue 465,100 492,412 486,000 607,668
Economic Development Activities - 459 748,439 -
Capital Improvement Projects 580,000 422,675 - -
Operating Transfer to General Fund 29,500 29,500 29,500 22,125
Total Expenditures 609,500 452,634 777,939 22,125
Net Surplus (Deficit)(144,400)$ 39,778$ (291,939)$ 585,543$
Beginning Fund Balance 304,939 344,717
Ending Fund Balance 344,717$ 930,260$
City of Evanston
Southwest TIF
As of September 30, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Net Property Tax- Current 11,798,019$ 11,864,571$ 10,879,993$ 11,139,758
Special Assessment Levy - - 169,848
Bond Proceeds/Premium/ Discounts - 23,281,822 -
Transfer from Other Funds - IMRF- 783,004 783,004 141,125 608,574
Miscellaneous Revenue - 33,510 -
Interest Income 1,500 5,356 1,500 8,369
Transfer from General Fund - 1,000,000 1,279,306 456,750
Transfer from Sewer Fund 190,210 190,210 207,284 155,463
Transfer from Special Assessment Fund 317,660 317,660 169,848 127,386
Total Revenue 13,090,393 37,476,133 12,848,904 12,496,300
Series 2004- Principal 775,000 9,786,794 - -
Series 2004- Interest 478,400 478,400 - -
Series 2004 B- Principal 595,000 2,830,000 - -
Series 2004 B- Interest 130,439 130,439 - -
Series 2005- Principal 1,095,000 12,465,536 - -
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 225,613
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 601,626
Series 2007 - Principal 965,000 965,000 1,909,709 -
Series 2007 - Interest 684,458 684,456 569,684 300,839
Series 2008A - Principal 300,000 300,000 300,000 -
Series 2008A - Interest 125,975 125,975 116,225 58,113
Series 2008C - Principal 362,900 362,900 378,180 -
Series 2008C - Interest 376,308 376,308 364,514 191,799
Series 2008D - Principal 1,410,000 1,410,000 565,600 -
Series 2008D - Interest 36,690 36,690 15,362 7,681
Series 2010 A - Principal DSF 305,000 305,000 305,000 -
Series 2010 A - Interest DSF 179,338 179,338 173,238 86,619
Series 2010 B - Principal DSF 647,358 647,358 684,946 -
Series 2010 B - Interest DSF 135,508 135,509 126,446 63,223
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 213,445
Series 2012 A - Interest DSF 955,000 995,000 1,025,000 113,944
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 315,413
Series 2013 B - Principal DSF 586,498 -
Series 2013 B - Interest DSF 95,000 95,000 - 313,772
-
Series 2004- Interest SAF 13,650 13,650 - -
Series 2005- Principal SAF 20,000 350,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 143,063 75,000 -
Net of Transfers - - - -
Fiscal Agent Fees 10,000 126,610 10,000 62,120
Total Expenditures 13,824,528 36,996,590 13,933,114 2,609,206
Net Surplus (Deficit)(734,135)$ 479,543$ (1,084,210)$ 9,887,094$
Beginning Fund Balance 2,896,148 3,375,691
Ending Fund Balance 3,375,691$ 13,262,785$
City of Evanston
Debt Service Fund
As of September 30, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Net Property Tax Increment 500,000$ 194,881$ 350,000$ 441,462$
Interest Income 400 344 400 127
Miscellaneous - 33,014 - 38,928
Total Revenue 500,400 228,239 350,400 480,517
Economic Dev. Projects - - -
Debt Service - Interest - 592 - 429
Capital Improvements 800,000 219,785 - 179,910
Developer Agreement Payments 610,000 505,855 300,000 544,086
Repayments to Econ. Dev. Fund 48,500 48,500 45,500 34,125
Transfers to General Fund 120,400 120,400 60,000 45,000
Total Expenditures 2,037,736 895,132 405,500 803,551
Net Surplus (Deficit)(1,537,336)$ (666,893)$ (55,100)$ (323,034)$
Beginning Fund Balance 1,055,510 388,617
Ending Fund Balance 388,617$ 65,583$
City of Evanston
Howard Ridge TIF
As of September 30, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Net Property Tax Increment 300,000$ 46,252$ 40,000$ -$
Bond Proceeds 3,400,000 - - -
Loan Proceeds - - - 100,262
Interest Income 1,000 167 100 463
Total Revenue 3,701,000 46,419 40,100 100,724
Economic Development Projects 650,000 - 75,000 -
Other Charges 1,600,000 135,353 20,000 -
Debt Service - Interest 40,000 7,274 10,000 4,228
Transfers to General Fund 60,000 60,000 60,000 45,000
Capital Projects 1,285,000 179,000 - -
Total Expenditures 3,635,000 381,627 165,000 49,228
Net Surplus (Deficit)66,000$ (335,208)$ (124,900)$ 51,496$
Beginning Fund Balance 872,847 537,639
Ending Fund Balance 537,639$ 589,135$
City of Evanston
West Evanston TIF
As of September 30, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited 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 September 30, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Bond Proceeds 8,339,988$ 8,538,259$ 8,331,458$ 8,469,966$
Grants 1,675,000 882,160 5,382,638 487,563
Reimbursements - - -
Private Contributions 510,000 - 708,000 72,505
Parking Fund Loan for Financial System 596,000 - 100,000
General Fund Allocation - - 936,500 702,375
Miscellaneous - 53,986 - 93,046
Interest Income 10,000 18,562 10,000 12,864
Total Revenue 11,130,988 9,492,967 15,468,596 9,838,320
Capital Outlay (includes prior year rollovers) 13,100,351 6,119,879 17,935,016 3,429,758
Interfund Transfers Out 475,000 475,000 475,000 356,250
Total Expenditures 13,575,351 6,594,879 18,410,016 3,786,008
Net Surplus (Deficit)(2,444,363)$ 2,898,088$ (2,941,420)$ 6,052,311$
Beginning Fund Balance 3,401,911 6,299,999
Ending Fund Balance 6,299,999$ 12,352,310$
City of Evanston
Capital Improvement Fund
As of September 30, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Special Assessments Collected 300,000$ 274,848$ 230,000$ 119,874$
Bond Proceeds 250,000 241,906 250,000 493,949
Investment Income 10,000 1,982 1,200 2,110
Total Revenue 560,000 518,736 481,200 615,932
Transfer to Debt Service Fund 317,660 317,660 169,848 130,636
General Management & Support - - 1,000 620
Capital Outlay 361,000 33,976 500,000 970
Total Expenditures 678,660 351,636 670,848 132,225
Net Surplus (Deficit)(118,660)$ 167,100$ (189,648)$ 483,707$
Beginning Fund Balance 1,905,315 2,072,415
Ending Fund Balance 2,072,415$ 2,556,122$
City of Evanston
Special Assessment Fund
As of September 30, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Parking Lots & Meters Operations 3,070,000$ 2,443,331$ 3,070,000$ 2,294,819
Church Street Garage Operations 716,348 618,034 716,348 503,575
Maple Avenue Garage Operations 1,204,200 1,140,191 1,204,200 983,310
Sherman Avenue Garage Operations 1,417,275 1,600,383 1,417,275 3,322,059
Washington National TIF Interfund Transfers-In 3,631,350 3,631,350 2,925,296 -
Interest Income 15,070 11,892 15,070 -
Miscellaneous Revenue 11,400 20,481 11,400 -
Reserve for Future Repairs (Contra Depreciation) 2,034,004 432,655 2,034,004 -
Total Revenue 12,099,647 9,898,317 11,393,593 7,103,763
7005 - Parking System Administration 784,607 804,417 976,360 1,239,991
7015 - Parking Lots and Meters 829,052 760,432 972,266 778,382
7025 - Church Street Self Park 607,955 414,444 624,855 247,433
7030 - Church Street Debt Payments 171,250 41,846 171,250 17,050
7036 - Sherman Avenue Garage 5,750,270 5,134,149 5,047,016 1,007,276
7037 - Maple Avenue Garage 1,611,920 861,836 1,654,244 515,950
7039 - Parking Debt 27,461 27,461 27,461 2,218
Transfer to Insurance Fund 490,236 490,236 319,648 239,737
Transfer to General Fund 644,242 644,242 869,242 651,931
Transfer to Fleet 21,991 21,992 21,991 -
Transfer to Equipment Replacement 30,000 30,000 30,000 -
Loans to Other Funds 2,796,000 - - -
Capital Outlay - - - -
Capital Improvements 3,455,000 1,896,659 5,180,000 -
Total Expenditures 17,219,984 11,127,714 15,894,333 4,699,968
Net Surplus (Deficit)(5,120,337)$ (1,229,397)$ (4,500,740)$ 2,403,795$
Further Operating Expense Breakdown:
7015 Parking Meter Activities 762,846 760,432 935,614 778,382
7015 Parking Meter Depreciation 36,652 - 36,652 -
SUBTOTAL 799,498 760,432 972,266 778,382
7025- Church Garage Activities 494,156 414,444 444,927 247,433
7025- Church Garage Depreciation 179,928 - 179,928 -
SUBTOTAL 674,084 414,444 624,855 247,433
7036 Sherman Garage Activities 1,199,756 1,884,149 468,766 1,007,276
7036 Debt Service Payments 3,250,300 3,250,000 3,703,600 -
7036 Reserve (Depreciation)874,650 - 874,650 -
SUBTOTAL 5,324,706 5,134,149 5,047,016 1,007,276
7037 Maple Garage Activities 1,013,991 861,836 988,046 515,950
7037 Debt Service Payments - - - -
7037 Reserve (Depreciation)666,198 - 666,198 -
SUBTOTAL 1,680,189 861,836 1,654,244 515,950
Beginning Unrestricted Fund Balance 14,418,330 13,602,819
Reclassification to Fund Balance to Capital Assets 413,886
Ending Unrestricted Fund Balance 13,602,819$ 16,006,614$
City of Evanston
Parking Fund
As of September 30, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Evanston 5,684,000$ 5,947,632$ 6,252,400$ 4,901,929$
Skokie 2,856,000 2,772,424 2,913,000 2,406,511
Northwest Commission 4,517,000 5,183,425 4,653,000 4,019,184
Cross Connection Control Fees 100,500 94,470 95,000 116,830
Investment Earnings 2,500 20,164 2,500 21,143
Debt Proceeds 2,630,700 2,043,779 4,000,000 2,700,000
Debt Proceeds (zero interest)1,370,000 - 2,000,000 197,048
Fees and Merchandise Sales 40,000 94,971 45,000 148,870
Fees and Outside Work 80,000 188,610 70,000 92,974
Grants - 78,792 - 14,181
Insurance Reimbursements - - - -
Phosphate Sales 66,000 48,114 69,000 34,499
Property Sales and Rentals 213,300 235,936 227,316 84,575
Misc Revenue - 92,165 - 19,629
Total Revenue 17,560,000 16,800,482 20,327,216 14,757,372
General Support 990,583 960,028 933,989 696,156
Pumping 2,333,247 2,226,781 2,355,718 1,250,341
Filtration 2,635,539 2,435,092 2,740,856 1,752,015
Distribution 1,424,324 1,389,136 1,425,352 1,039,131
Meter Maintenance 309,163 249,474 300,760 205,618
Other Operating Expenses 478,592 994,606 491,700 447,857
Debt Service 864,233 810,068 1,297,703 514,991
Debt Service - IEPA Loan 3382 67,506 67,504 67,506 33,752
Capital Improvements 8,314,200 5,435,207 10,538,100 2,127,300
Interfund Transfers Out - General Fund 3,356,300 3,356,300 3,369,559 2,527,169
Interfund Transfers Out - Insurance Fund 468,492 468,492 468,492 351,370
Total Expense 21,242,179 18,392,688 23,989,735 10,945,700
Net Surplus (Deficit)(3,682,179)$ (1,592,206)$ (3,662,519)$ 3,811,672$
Beginning Unrestricted Fund Balance 9,192,655 8,590,091
Reclassification to Fund Balance from Capital Assets 989,642
Ending Unrestricted Fund Balance 8,590,091$ 12,401,763$
City of Evanston
Water Fund
As of September 30, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Operations 12,908,000$ 13,494,318$ 12,922,700$ 9,982,155$
Debt Proceeds 4,000,000 1,851,827 - -
Debt Proceeds - 2012 IEPA Loan 3,100,000 2,523,969 2,190,000 1,104,656
Investment Earnings 1,000 1,270 1,000 1,955
Miscellaneous 18,865 15,881 4,165 -
Grant Revenue - 860,353 - -
Total Revenue 20,027,865 18,747,618 15,117,865 11,088,766
Sewer Operations 2,134,549 2,026,860 2,260,545 1,502,128
Other Operating Expenses 43,300 10,900 129,500 23,879
Interfund Transfers Out - General Fund 142,200 142,200 145,044 108,783
Interfund Transfers Out - Insurance Fund 269,988 269,988 269,988 202,491
Transfer to Debt Service 190,211 190,210 207,284 155,463
Capital Outlay 20,600 13,714 47,500 41,040
Depreciation - 4,570,214 -
Capital Improvement Account 4,922,500 - 3,225,000 1,745,759
Debt Service 11,542,740 11,711,077 9,994,259 7,143,621
Total Expenses 19,266,088 18,935,163 16,279,120 10,923,164
Net Surplus (Deficit)761,777$ (187,545)$ (1,161,255)$ 165,602$
Beginning Unrestricted Fund Balance 4,199,578 4,574,996
Reclassification to Fund Balance to Capital Assets 562,963
Ending Unrestricted Fund Balance 4,574,996$ 4,740,598$
City of Evanston
Sewer Fund
As of September 30, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Transfer from General Fund 1,245,967$ 1,245,967$ 1,055,967$ 791,975$
Solid Waste Franchise Fees 175,000 199,980 175,000 125,497
SWANCC Recycling Incentive 140,000 30,467 25,000 20,852
Recycling Service Charge 2,954,033 3,013,668 3,334,033 2,567,531
Sanitation Service Charge Penalty 30,000 44,099 45,000 43,689
Special Pickup Fees 100,000 86,804 100,000 57,715
Trash Cart Sales 15,000 27,697 15,000 14,679
Investment Income - 20 -
Yard Waste Fees 350,000 248,077 220,000 58,822
Total Revenue 5,010,000 4,896,779 4,970,000 3,680,760
Refuse Collection & Disposal 3,259,574 2,882,420 3,372,698 1,957,989
Residential Recycling Collection 1,254,398 1,223,782 1,186,134 933,080
Yard Waste Collection 750,250 626,253 750,250 376,641
Total Expense 5,264,222 4,732,455 5,309,082 3,267,710
Net Surplus (Deficit)(254,222)$ 164,324$ (339,082)$ 413,051
Beginning Unrestricted Fund Balance (1,447,884) (1,283,560)
Ending Unrestricted Fund Balance (1,283,560)$ (870,509)
City of Evanston
Solid Waste
As of September 30, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
General Fund 2,507,356$ 3,107,358$ 2,507,356$ 1,880,519$
Library Fund 2,381 2,381 2,381 1,786
Parking Fund 21,992 21,992 21,992 16,494
Water Fund 122,751 122,751 122,751 92,063
Sewer Fund 177,729 177,729 177,729 133,297
Solid Waste Fund 298,071 298,071 298,071 223,553
Damage to City Property 24,789 - 24,789
Miscellaneous Revenue 10,000 46,349 10,000 41,148
Interest Income 1,000 - 1,000 -
Total Revenues 3,166,069 3,776,631 3,166,069 2,388,860
General Support 292,007 271,772 293,619 197,298
Major Maintenance 3,217,058 3,287,552 3,284,528 2,126,075
Total Expenditures 3,509,065 3,559,324 3,578,147 2,323,372
Net Surplus (Deficit)(342,996)$ 217,307$ (412,078)$ 65,487$
Beginning Fund Balance (107,097) 110,566
Reclassification from Fund Balance to Capital Assets 356
Ending Fund Balance 110,566$ 176,053$
City of Evanston
Fleet Maintenance Fund
As of September 30, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
General Fund 1,242,590$ 1,242,590$ 1,242,590$ 931,942$
Library Fund 1,700 1,700 1,700 1,275
Parking Fund 30,000 30,000 30,000 22,500
Solid Waste Fund 177,131 177,131 177,131 132,848
Bond Premiums - - - 72,810
Bond Proceeds - - 1,000,000 1,000,000
Sale of Surplus Property 210,217 131,072 210,217 34,511
Total Revenues 1,661,638 1,582,493 2,661,638 2,195,887
Capital Outlay 2,400,000 1,625,725 2,494,000 1,349,450
Carryover - - 200,000 -
Settlement Costs - - - 15,290
Bond Costs - 7,212
Capital Leases 50,000 - 50,000 24,997
Total Expenditures 2,450,000 1,625,725 2,744,000 1,396,949
Net Surplus (Deficit)(788,362)$ (43,232)$ (82,362)$ 798,938$
Beginning Fund Balance 1,500,482$ 588,983$
Reclassification from Capital Assets to Fund
Balance (868,267)$
Ending Fund Balance 588,983$ 1,387,921$
City of Evanston
Equipment Replacement Fund
As of September 30, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
General Admin Contribution- General 121,204$ 121,204.00$ 121,204$ 90,903$
General Admin Contribution- E911 930 930 930 698
General Admin Contribution- CDBG 930 930 930 698
General Admin Contribution- E.D.930 930 930 698
General Admin Contribution- Parking 17,032 17,032 17,032 12,774
General Admin Contribution- Water Fund 24,962 24,962 24,962 18,722
General Admin Contribution- Sewer Fund 14,385 14,385 14,385 10,789
Liability/Property Contribution- General 909,150 909,150 909,150 681,863
Liability/Property Contribution- E911 6,972 6,972 6,972 5,229
Liability/Property Contribution- CDBG 6,972 6,972 6,972 5,229
Liability/Property Contribution- E.D. 6,972 6,972 6,972 5,229
Liability/Property Contribution- Parking 127,731 127,731 127,731 95,798
Liability/Property Contribution- Water Fund 187,209 187,209 187,209 140,407
Liability/Property Contribution- Sewer Fund 107,887 107,887 107,887 80,915
Workers' Comp Contribution- General 1,244,860 1,244,860 1,244,860 933,647
Workers' Comp Contribution- Library Fund 5,898 5,898 40,000 30,000
Workers' Comp Contribution- E911 9,546 9,546 9,546 7,160
Workers' Comp Contribution- CDBG 9,546 9,546 9,546 7,160
Workers' Comp Contribution- E.D. 9,546 9,546 9,546 7,160
Workers' Comp Contribution- Parking 174,886 174,886 174,886 131,164
Workers' Comp Contribution- Water Fund 256,322 256,322 256,322 192,242
Workers' Comp Contribution- Sewer Fund 147,716 147,716 147,716 110,787
Subrogation Proceeds 83,300 155,102 100,000 54,068
Yearend Transfer from General Fund - 874,289 -
Transfer from General Fund - Casualty Loss Acct - - -
Investment Income 41,650 212 1,000 219
Workers Comp & Liability - Subtotal 3,516,536 4,421,189 3,526,688 2,623,554
Health Insurance Chargebacks- General 8,232,350 8,262,909 8,780,657 6,585,494
Health Insurance Chargebacks - Library 318,681 318,681 366,065 274,549
Health Insurance Chargebacks - NSP2 16,390 16,390 6,863 5,147
Health Insurance Chargebacks- E911 81,545 81,545 71,410 53,557
Health Insurance Chargebacks- CDBG 12,586 12,586 31,521 23,640
Health Insurance Chargebacks- E.D. Fund 56,081 49,968 49,098 36,824
Health Insurance Chargebacks- Home Fund - - 2,735 2,051
Health Insurance Chargebacks- Parking 170,588 170,588 171,325 128494
Health Insurance Chargebacks- Water 596,392 596,392 616,227 462,171
Health Insurance Chargebacks- Sewer 168,030 168,030 183,218 137,414
Health Insurance Chargebacks - Solid Waste 114,220 114,220 106,846 80,134
Health Insurance Chargebacks- Fleet 183,414 183,414 202,427 151,820
Retiree Health Insurance Contributions 1,684,894 1,688,954 1,970,647 1,141,007
Employee Health Insurance Contributions 1,760,276 1,489,664 1,706,017 1,000,083
SWANNC-Health Insurance Contributions - - - 57,428
One Time IPBC Distribution 300,000 300,000 300,000 726,300
Health & Life insurance - Subtotal 13,695,447 13,453,341 14,565,056 10,866,113
Total Revenues 17,211,983 17,874,530 18,091,744 13,489,668
City of Evanston
Insurance Fund
As of September 30, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
City of Evanston
Insurance Fund
As of September 30, 2014
General Administration & Support 294,093 286,369 409,548 290,142
Auditing 25,000 - - -
Liability/Property Insurance Premiums 470,000 455,514 470,000 490,744
Liability Legal Fees 350,000 460,204 350,000 359,690
Liability Settlement Payments 400,000 471,052 400,000 420,989
Transfer - to ERI Debt Service 8,325 8,325 8,627 6,470
Workers' Comp Insurance Premiums 114,400 111,111 114,400 118,531
Workers' Comp Legal Fees 80,500 38,694 80,500 35,036
Workers' Comp Medical Payments 800,000 493,886 600,000 478,728
Workers' Comp Settlement Payments 1,100,000 899,625 1,100,000 498,966
Workers' Comp TPA Pymts (non specific)145,000 154,244 125,000 -
Workers' Comp TTD Pymts (non sworn)- - - 85,414
Workers' Comp & Liability - Subtotal 3,787,318 3,379,024 3,658,075 2,784,710
General Administration & Support 94,093 87,437 99,805 72,867
Health Insurance Premiums 13,458,615 13,183,406 14,217,604 10,057,104
Health Insurance Opt Out Payments 84,000 45,133 91,800 11,578
Health & Life Insurance - Subtotal 13,636,708 13,315,976 14,409,209 10,141,548
Total Expenditures 17,424,026 16,695,000 18,067,284 12,926,258
Net Surplus (Deficit)(212,043)$ 1,179,530$ 24,460$ 563,410$
Beginning Unrestricted Fund Balance (7,376,499) (3,727,662)
Adjustment to GAAP Basis of Accounting 2,469,307
Ending Unrestricted Fund Balance (3,727,662)$ (3,164,252)$
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Property Taxes 6,061,575$ 6,049,233$ 6,061,575$ 6,082,542$
Personal Property Repl Tax 280,000 280,000 280,000 279,696
Interest on Investment 800,000 1,564,893 850,000 327,247
Participant Contributions 922,500 975,932 950,000 661,799
Unrealized Gain - 5,233,195 - 5,000
Miscellaneous - 150 - -
Total Revenue 8,064,075 14,103,403 8,141,575 7,356,284
Administrative Expenses 154,000 271,223 154,000 141,125
Legal Fees 50,000 - 50,000
Retiree Pensions 4,841,000 4,871,953 4,995,500 3,953,771
Widows' Pensions 1,090,000 1,053,398 1,071,200 808,907
Disability Pensions 1,350,000 1,304,970 1,358,125 955,620
QUILDRO 75,000 90,364 90,000 71,400
Reserve for Future Payments - - - -
Total Expenditures 7,560,000 7,591,908 7,718,825 5,930,822
Net Surplus (Deficit)504,075$ 6,511,495$ 422,750$ 1,425,462$
Beg Net Assets held in Trust 58,463,916 58,463,916 65,024,941 65,024,941
Property Tax Adjustment for GAAP Basis 49,530
End Net Assets held in Trust 58,967,991$ 65,024,941$ 65,447,691$ 66,450,402$
City of Evanston
Fire Pension Fund
As of September 30, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Property Taxes 8,069,325$ 8,077,915$ 8,069,325$ 8,100,226$
Personal Property Repl Tax 325,000 325,000 325,000 279,696
Interest Income 2,625,000 3,277,547 2,800,000 1,067,060
Participant Contributions 1,383,750 1,759,216 1,423,000 1,034,315
Miscellaneous - - - 104,993
Unrealized Gain / (Loss) - 6,375,354 - -
Total Revenue 12,403,075 19,815,032 12,617,325 10,586,291
Administrative Expenses 250,000 264,528 250,000 163,770
Retiree Pensions 7,500,769 7,787,104 8,056,000 6,128,955
Widow Pensions 868,000 857,302 875,500 669,798
Disability Pensions 700,000 662,888 700,000 483,338
Separation Refunds 150,000 109,252 275,000 2,831
QUILDRO 18,000 21,084 18,000 16,288
Reserve for Future Payments - - - -
Total Expenditures 9,486,769 9,702,158 10,174,500 7,464,981
Net Surplus (Deficit)2,916,306$ 10,112,874$ 2,442,825$ 3,121,311$
Beg Net Assets held in Trust 80,589,961 80,589,961 90,763,143 90,763,143
Property Tax Adjustment for GAAP Basis 60,308
End Net Assets held in Trust 83,506,267$ 90,763,143$ 93,205,968$ 93,884,454$
City of Evanston
Police Pension Fund
As of September 30, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Revenue By Source
Allocation - Property Taxes 4,253,214$ 4,165,513$ 5,032,097$ 5,145,230$
Library Fines & Fees 185,000 169,583 164,000 89,214
Library Material Replacement 12,500 12,484 14,000 7,275
Copy Machine Charges 20,000 18,814 21,200 9,906
Meeting Room Fees 10,000 12,397 10,400 10,182
Non-resident Cards 1,690 1,565 1,040 260
North Branch Rental Income 59,660 58,697 60,000 16,578
State Per Capita Grant 76,300 103,995 94,177 4,000
Personal Property Repl. Tax 50,200 50,200 50,200 -
Video Rentals - - -
Book Sales 60,000 56,140 65,000 24,853
Merchandise Sale -
Fund for Excellence 245,000 127,433 125,000 28,704
Grants and Donations - 116,545 68,840
Transfer from Economic Development - 9,900 - 9,900
Miscellaneous - 3,854 - 2,366
Transfer from Endowment 131,250 131,249 159,315 157,951
Total Revenues 5,104,814 4,921,824 5,912,974 5,575,258
Expenditures
Youth Services 891,720 903,873 1,030,009 713,403
Adult Services 1,535,224 1,538,627 1,514,037 1,068,867
Circulation 612,892 605,865 573,258 388,765
Neighborhood Services 360,757 325,649 456,528 313,722
Technical Services 503,433 431,115 538,879 340,887
Maintenance 507,517 672,615 660,703 479,481
Administration 669,377 678,430 1,103,015 782,875
Library Grants - 35,569 36,545 20,056
Total Expenditures 5,080,920 5,191,743 5,912,974 4,108,055
Net Surplus (Deficit)23,894$ (269,919)$ -$ 1,467,203$
Beginning Fund Balance 1,101,096 982,764
Adjustment to GAAP Basis of Accounting 151,587 -
Ending Fund Balance 982,764 2,449,967
City of Evanston
Library Fund
As of September 30, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Revenue By Source
Net Property Taxes -$ -$ 748,178$ 739,506$
Investment Income - - 1,000 -
Total Revenues - - 749,178 739,506
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 30,248
Series 2008 - Principal DSF - - 344,400 -
Series 2008 - Interest DSF - - 22,100 11,050
Series 2013B - Interest DSF - - - 12,426
Total Expenditures - - 748,178 53,724
Net Surplus (Deficit)-$ -$ 1,000$ 685,782$
Beginning Fund Balance - -
Ending Fund Balance - 685,782
City of Evanston
Library Debt Fund
As of September 30, 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$ 20,395,607$ 20,882,214$ 19,058,144$ 19,999,271$ 22,595,599$ 20,438,571$
FY 2013 Unreserved Fund Balance 17,412,530$ 18,091,096$ 21,774,085$ 22,459,219$ 23,342,537$ 19,526,063$ 20,250,620$ 21,816,228$ 20,501,689$
FY 2014 Cash Balance 4,173,079$ 6,745,425$ 10,059,258$ 9,101,839$ 8,474,680$ 7,167,254$ 9,635,823$ 12,266,622$ 10,328,206$
FY 2013 Cash Balance 6,624,063$ 7,811,937$ 12,160,633$ 12,969,898$ 12,797,660$ 13,337,226$ 14,279,322$ 14,279,322$ 11,977,938$
$-
$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