HomeMy WebLinkAbout2014.06 June Monthly Report
To: Wally Bobkiewicz, City Manager
Martin Lyons, Assistant City Manager/Chief Financial Officer
From: Ashley Porta, Budget Manager
Hitesh Desai, Accounting Manager
Subject: June 2014 Monthly Financial Report
Date: August 1, 2014
Please find attached the unaudited financial statements as of June 30, 2014. A
summary by fund for total revenues, expenditures/expenses, fund balances, and cash
balances is as follows:
YTD YTD YTD 6/30/2014 6/30/2014
6/30/2014 6/30/2014 6/30/2014 Unreserved Cash
Fund Name Fund # Revenue Expenses Net Fund Balance Balance*
General 100 43,498,907$ 40,803,444$ 2,695,463$ 19,058,414$ 7,167,254$
General Assistance Fund 175 471,427 262,428 209,000 209,000 209,000
Neighborhood Stabilization 195 1,615,509 717,696 897,813 897,813 736,325
Motor Fuel 200 1,273,506 561,336 712,170 2,024,738 2,187,134
Emergency 911 205 571,196 603,754 (32,557) 1,188,321 922,877
SSA#4 210 183,389 160,000 23,389 (125,946) (156,813)
CDBG 215 343,501 549,928 (206,428) (193,629) (368,352)
CDBG Loan 220 32,688 56,063 (23,375) 2,330,896 91,455
Economic Development 225 825,214 626,711 198,502 3,705,704 3,142,150
Neighborhood Improvement 235 - - - 149,915 149,915
Home 240 393,203 406,894 (13,691) 3,928,838 (3,517)
Affordable Housing 250 97,957 37,370 60,587 2,511,665 798,972
Washington National TIF 300 2,409,778 1,680,315 729,463 5,766,904 5,359,503
SSA#5 305 247,928 31,025 216,903 691,788 630,481
SW II TIF (Howard Hartrey) 310 628,935 1,093,230 (464,296) 2,892,752 2,877,120
Southwest TIF 315 261,365 14,750 246,615 591,332 579,690
Debt Service 320 6,917,315 2,270,917 4,646,399 8,022,090 6,502,491
Howard Ridge TIF 330 276,667 375,860 (99,194) 289,423 277,770
West Evanston TIF 335 49 33,510 (33,461) 504,178 504,179
Dempster-Dodge TIF 340 - - - -
Capital Improvement 415 1,031,921 1,453,054 (421,133) 5,878,866 6,463,194
Special Assessment 420 97,166 85,364 11,802 2,084,217 2,080,220
Parking 505 4,585,872 3,293,674 1,292,198 14,895,017 14,987,982
Water 510-513 7,711,704 7,896,922 (185,218) 8,404,873 8,517,329
Sewer 515 7,670,387 6,252,931 1,417,456 5,992,452 3,030,333
Solid Waste 520 2,393,677 2,220,140 173,538 (1,110,023) (1,572,330)
Fleet 600 1,584,715 1,578,940 5,775 116,341 (491,656)
Equipment Replacement 601 760,222 281,088 479,134 1,068,117 1,068,116
Insurance 605 8,688,287 8,877,102 (188,815) (3,916,477) 871,788
Library 185 2,732,921 2,549,018 342,646 1,166,667 490,387
Library Debt Fund 186 396,370 53,724 342,646 342,646 342,646
Total** 97,305,404$ 84,773,463$ 12,690,685$ 89,024,246$ 67,395,643$
*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 June 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. While ending fund balance is also an
important measurement of the City’s financial health, it usually includes illiquid assets or
future cash receipts or disbursements such as receivables (including property tax) due
to the City and accounts payable/accrued expenses.
As of June 30, 2014, the General Fund is reporting a surplus of $2,695,463. 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 June 30, 2014, the Special Service Area (SSA) #4 Fund is showing a negative
cash balance of $156,813.
Through June 30, 2014, the Community Development Block Grant (CDBG) Fund is
showing a negative fund balance of $193,629 and a negative cash balance of $368,352.
The City received $ 420,158 of CDBG money on 07/22/2014 and $28,595 of HOME
Fund money from HUD on 07/28/2014, which eliminates this negative balance.
Through June 30, 2014, the Economic Development Fund is showing a fund balance of
$3,705,704 and a cash balance of $3,142,150. These balances include approximately
$1 million of revenue associated with the Gigabit Challenge.
Through June 30, 2014, the Solid Waste Fund is showing a negative fund balance of
$1,110,023 and a negative cash balance of $1,572,330.
Though operating at a surplus for the year, through June 30, 2014 the Fleet Fund is
showing a negative cash balance of $491,656.
Through June 30, 2014, the Insurance Fund is showing a negative fund balance of
$3,916,477. This negative balance is primarily for claims/cases being expensed.
These claims/cases have not been settled, and therefore there is no guarantee the City
will actually experience this negative fund balance as estimated. Please note, the City’s
annual liability and property insurance payments, totaling $601,314, were paid in
January, which further reduced the fund balance of the Insurance Fund. These
payments will gradually be reimbursed through FY 2014 from interfund transfers to the
Insurance Fund. Staff will continue to monitor the Insurance Fund and provide regular
updates to the City Council in the future.
If there are any questions on the attached report, please contact me by phone at (847)
859-7884 or by email: aporta@cityofevanston.org. Detailed fund summary reports can
be found at the following link: http://www.cityofevanston.org/city-budget/financial-
reports/.
CERTIFICATION OF ATTACHED FINANCIAL REPORTS
As required per Illinois Statute 65 ILCS 5/3.1-35-45 I, Martin Lyons, Treasurer of the
City of Evanston, hereby affirm that I have reviewed the June 30, 2014 year-to-date
financial information and reports which to the best of my knowledge appear accurate
and complete.
Revenues Budget Actual
% of
Budget Budget Actual
% of
Budget Budget Actual
% of
Budget Budget Actual
% of
Budget Budget Actual
% of
Budget
Property Tax 12,271,386$ 6,591,662$ 53.7%-$ -$ -$ -$ -$ -$ -$ -$
Sales Tax 15,790,000 7,122,980 45.1%- - - - - - - -
State Income Tax 7,076,170 3,882,659 54.9%- - - - - - - -
Utility Tax 8,220,000 4,519,178 55.0%- - - - - - - -
Real Estate Transfer Tax 2,875,000 1,179,923 41.0%- - - - - - - -
Liquor Tax 2,375,000 1,381,024 58.1%- - - - - - - -
Other Taxes 5,940,053 2,643,169 44.5%- - - - - - - -
Licenses, Permits, Fees 12,622,280 4,830,835 38.3%- - - - - - - -
Charges for Services 7,936,754 4,382,246 55.2% 6,434,293 4,585,872 71.3% 13,913,400 7,473,609 53.7% 12,922,700 6,517,583 50.4% 3,889,033 1,863,665 47.9%
Intergovernmental Revenues 721,272 450,121 62.4%- - - 14,181 - - 25,000 2,029 8.1%
Interfund Transfers 7,742,893 3,940,266 50.9% 2,925,296 - 0.0% - - - - 1,055,967 527,984 50.0%
Other Non-Tax Revenue 5,614,490 2,574,843 45.9% 2,034,004 - 0.0% 6,413,816 223,914 3.5% 2,191,000 292,451 13.3%- -
Total Revenues 89,185,298$ 43,498,907$ 48.8% 11,393,593$ 4,585,872$ 40.2% 20,327,216$ 7,711,704$ 37.9% 15,113,700$ 6,810,034$ 45.1% 4,970,000$ 2,393,677$ 48.2%
Expenditures
Legislative 677,621$ 338,149$ 49.9%-$ -$ -$ -$ -$ -$ -$ -$
City Administration 1,941,115 771,509 39.7%- - - - - - - -
Law Department 1,045,232 462,253 44.2%- - - - - - - -
Administrative Services Department 8,826,606 3,223,598 36.5%- - - - - - - -
Community Development 2,652,887 1,135,813 42.8%- - - - - - - -
Police Department 26,876,444 12,861,824 47.9%- - - - - - - -
Fire & Life Safety Services 14,072,488 6,868,361 48.8%- - - - - - - -
Health Department 3,009,286 1,330,307 44.2%- - - - - - - -
Public Works - Operating 17,884,613 8,611,924 48.2% 10,714,333 3,293,674 30.7%- - - - 5,309,082 2,220,140 41.8%
Public Works - Capital Outlay - - 5,180,000 - 0.0% - - - - - -
Parks, Recreation & Comm. Services 10,483,281 4,426,956 42.2%- - - - - - - -
Capital Improvement Transfer 936,500 468,250 50.0%
Transfer to Debt Service Fund 609,000 304,500 50.0%- - - - - - - -
Utilities - Operating - - - - 13,451,635 5,613,592 41.7% 13,006,620 6,138,631 47.2%- -
Utilities - Capital Outlay - - - - 10,538,100 2,283,330 21.7% 3,272,500 114,300 3.5%- -
Total Expenditures 89,015,073$ 40,803,444$ 45.8% 15,894,333$ 3,293,674$ 20.7% 23,989,735$ 7,896,922$ 32.9% 16,279,120$ 6,252,931$ 38.4% 5,309,082$ 2,220,140$ 41.8%
As of June 30, 2014
Report of Budget-to-Actual Revenues and Expenditures
Parking Fund Water Fund Solid Waste FundSewer FundGeneral Fund
(Target is 50% 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$ 6,591,662$
Tax - State Use 1,176,879 1,283,156 1,241,753 534,566
Tax - Sales Tax - Basic 9,291,000 9,717,393 9,690,000 4,415,445
Tax - Sales Tax - Home Rule 5,861,800 5,964,747 6,100,000 2,707,536
Tax - Auto Rental 40,000 43,598 40,000 21,505
Tax - Athletic Contest 760,000 1,056,355 800,000 -
Tax - State Income 6,322,645 7,182,793 7,076,170 3,882,659
Tax - Electric Utility 3,069,806 3,000,629 3,070,000 1,502,774
Tax - Natural Gas Utility 1,400,000 1,090,915 1,200,000 1,016,250
Tax - Natural Gas Use - Home Rule 800,000 760,734 800,000 516,188
Tax - Cigarette 485,000 372,000 300,000 78,000
Tax - Evanston Motor Fuel 707,667 634,196 610,000 376,446
Tax - Liquor 2,350,000 2,261,874 2,375,000 1,381,024
Tax - Parking 2,200,000 2,418,852 2,350,000 1,193,070
Tax - Personal Property Replacement 591,600 721,173 598,300 439,582
Tax - Real Estate Transfer 2,146,300 3,940,899 2,875,000 1,179,923
Tax - Telecommunications 3,244,500 2,837,899 3,150,000 1,483,966
License Fees - Vehicles 2,600,000 2,349,686 2,700,000 450,082.30
License Fees - Other 1,030,502 1,427,835 937,302 541,369
Permit Fees - Building 3,020,000 3,951,048 6,142,162 2,092,740
Permit Fees - Other 1,209,788 1,746,109 1,486,716 1,018,366
Other Fees 1,559,350 1,152,473 1,356,100 728,278
Fines and Forfeiture Revenue 4,366,022 3,448,523 4,366,022 1,663,090
Charges for Services Revenue 7,904,198 7,845,651 7,936,754 4,382,246
Intergovernmental Revenue 786,798 1,425,907 721,272 450,121
Other Revenue 1,418,443 647,935 1,238,468 890,257
Interfund Transfers In (Other Funds)7,693,367 7,521,427 7,742,893 3,940,266
Interest Income 6,000 26,907 10,000 21,496
Total Revenue 84,523,051 86,772,289 89,185,298 43,498,907
Legislative 657,069 421,198 677,621 338,149
City Administration 1,582,580 1,818,451 1,941,115 771,509
Law Department 973,254 973,254 1,045,232 462,253
Administrative Services Department 7,721,650 8,546,089 8,826,606 3,223,598
Community Development 2,536,250 2,536,209 2,652,887 1,135,813
Police Department 26,508,585 26,508,583 26,876,444 12,861,824
Fire & Life Safety Services Department 14,142,078 14,142,077 14,072,488 6,868,361
Health Department 2,917,848 3,601,469 3,009,286 1,330,307
Public Works Department 10,043,463 11,186,023 17,884,613 8,611,924
Parks, Recreation & Community Services 17,616,397 14,744,293 10,483,281 4,426,956
Transfer to Solid Waste Fund - 1,245,967 936,500 468,250
Transfer to Debt Service Fund 1,000,000 1,000,000 609,000 304,500
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 40,803,444
Net Surplus (Deficit)(2,276,123)$ (1,051,324)$ 170,225$ 2,695,463$
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$ 19,058,414$
Note 1: Unrestricted fund balance includes amounts designated for compensated absences and IMRF.
City of Evanston
General Fund
As of June 30, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Property Taxes 5,073$
Misc. Revenue - - 85
Transfers from other Funds - - - 466,269
Total Revenue - - - 471,427
Administration - - - 48,119
Client Payments - - - 169,889
Capital Outlay - - - 1,019
Community Sponsored Org - - - 40,717
Office Supplies - - - 2,683
Total Expenditures - - - 262,427
Net Surplus (Deficit) -$ -$ -$ 209,000$
Beginning Fund Balance - -
Ending Fund Balance -$ 209,000$
City of Evanston
General Assistance Fund
As of June 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$ 774,355$
Program Income - 347 - 840,644
Investment Income - - - 510
Total Revenue 4,011,917 2,885,918 458,044 1,615,509
Development Activities 3,505,000 2,653,385 290,500 614,586
Administration 341,622 128,520 126,635 49,940
Transfer to Debt Service 3,905 - 4,046 5,928
Transfer to Insurance 16,390 16,390 6,863 3,431
Transfer to General Fund 145,000 87,624 30,000 43,811
Total Expenditures 4,011,917 2,885,918 458,044 717,696
Net Surplus (Deficit) -$ 0$ -$ 897,813$
Beginning Fund Balance - 0
Ending Fund Balance 0$ 897,813$
City of Evanston
Neighborhood Stabilization Fund
As of June 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,273,366$
Investment Earnings 2,000 482 500 140
Miscellaneous Income - - - -
Total Revenue 2,127,000 2,118,988 1,750,500 1,273,506
Street Resurfacing 1,400,000 972,788 1,400,000 144,836
Transfer to General Fund - Staff Engineering 133,000 133,000 133,000 66,500
Transfer to General Fund - Street Maintenance 700,000 700,000 700,000 350,000
Total Expenditures 2,233,000 1,805,788 2,233,000 561,336
Net Surplus (Deficit)(106,000)$ 313,200$ (482,500)$ 712,170$
Beginning Fund Balance 999,368 1,312,568
Ending Fund Balance 1,312,568$ 2,024,738$
City of Evanston
Motor Fuel Fund
As of June 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$ 298,354$
Wireless Surcharge Revenue 416,160 454,019 428,400 170,714
Interest Income 1,000 215 1,000 50
Grants 102,078
Miscellaneous Revenue - - - -
Total Revenue 1,034,560 1,004,169 958,600 571,196
Operating Expense 891,122 785,259 935,767 438,318
Transfer to General Fund 125,950 125,950 125,950 62,975
Transfer to Insurance Fund 98,993 98,993 88,858 8,724
Transfer to Debt Service Fund 11,215 11,215 11,622 5,811
Capital Replacement 120,000 26,680 250,000 87,926
Total Expenditures 1,247,280 1,048,097 1,412,197 603,754
Net Surplus (Deficit)(212,720)$ (43,928)$ (453,597)$ (32,557)$
Beginning Fund Balance 1,264,807 1,220,879
Ending Fund Balance 1,220,879$ 1,188,321$
City of Evanston
E911 Fund
As of June 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$ 183,389$
Investment Income - - - -
Total Revenues 370,000 337,668 370,000 183,389
Professional Fees (Evmark)370,000 370,000 370,000 160,000
Total Expenditures 370,000 370,000 370,000 160,000
Net Surplus (Deficit)-$ (32,332)$ -$ 23,389$
Beginning Fund Balance (117,003) (149,335)
Ending Fund Balance (149,335)$ (125,946)$
City of Evanston
Special Service Area #4 Fund
As of June 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$ $ 333,735
Funds Reallocated from Prior Years 33,100 - 168,088 -
Program Income 352,000 14,412 70,000 9,766
Miscellaneous - - - -
Total Revenues 1,925,100 1,680,132 1,738,088 343,501
CDBG Administration/Planning 195,522 239,602 300,000 108,366
Development Activities 612,500 293,045 456,288 59,397
Capital Projects 494,800 493,581 410,800 58,854
Transfers to Debt Service - 2,928 - -
Transfers to General Fund 781,278 650,976 571,000 323,312
Total Expenditures 2,084,100 1,680,132 1,738,088 549,928
Net Surplus (Deficit)(159,000)$ -$ -$ (206,428)$
Beginning Fund Balance 12,799 12,799
Ending Fund Balance 12,799$ (193,629)$
City of Evanston
CDBG Fund
As of June 30, 2014
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Intergovernmental Revenue -$ 205,904$ 50,000$ 7,250$
Program Income 9,000 3,554 10,000 25,388
Interest Income - - 100 50
Total Revenues 9,000 209,458 60,100 32,688
Program Expenses 20,000 - 20,000 56,063
Total Expenditures 20,000 - 20,000 56,063
Net Surplus (Deficit) (11,000)$ 209,458$ 40,100$ (23,375)$
Beginning Fund Balance 2,144,813 2,354,271
Ending Fund Balance 2,354,271$ 2,330,896$
City of Evanston
CDBG Loan Fund
As of June 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$ 617,253$
Amusement Tax 300,000 275,646 300,000 182,805
Howard-Ridge Loan Repayment 48,500 48,500 45,500 22,750
Grants - 999,000 1,000,000 -
Investment Income 800 922 800 2,405
Total Revenues 1,949,300 2,878,349 2,846,300 825,214
Economic Development Activities 1,830,209 983,057 1,760,889 342414
Other Charges - Gigabit Challenge - - 1,000,000 24,718
Capital Projects 3,500 4,600 - 17,367
Transfer to Debt Service 13,771 13,771 14,271 7,136
Transfer to Insurance 67,416 67,416 66,546 8,724
Transfers to General Fund 452,707 452,707 452,707 226,353
Total Expenditures 2,367,603 1,521,551 3,294,413 626,711
Net Surplus (Deficit)(418,303)$ 1,356,798$ (448,113)$ 198,502$
Beginning Fund Balance 2,150,404 3,507,202
Ending Fund Balance 3,507,202$ 3,705,704$
City of Evanston
Economic Development Fund
As of June 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 June 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$ 393,203$
Interest Income - - -
Program Income - 6,693 - -
Total Revenues 797,400 710,628 674,500 393,203
Home Administration/Planning 4,000 - 27,836 9,857
Development Activities 765,000 8,775 650,000 393,246
Transfers to General Fund 28,400 65,700 22,500 3,790
Total Expenditures 797,400 74,475 700,336 406,894
Net Surplus (Deficit) -$ 636,153$ (25,836)$ (13,691)$
Beginning Fund Balance 3,306,375 3,942,528
Ending Fund Balance 3,942,528$ 3,928,838$
City of Evanston
Home Fund
As of June 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 82,500
Rehab Repayments - 11,188 - 3,889
Interest Income 228 198 150 230
Miscellaneous - - - 11,338
Total Revenues 155,228 301,386 155,150 97,957
Housing - Buildings 227,800 30,692 200,000 -
Down Payment Assistance - - - -
Transfers to General Fund 23,990 23,990 13,990 6,995
Miscellaneous 46,000 31,752 50,000 30,375
Total Expenditures 297,790 86,434 263,990 37,370
Net Surplus (Deficit)(142,562)$ 214,952$ (108,840)$ 60,587$
Beginning Fund Balance 2,236,126 2,451,078
Ending Fund Balance 2,451,078$ 2,511,665$
City of Evanston
Affordable Housing Fund
As of June 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$ 2,404,251$
Interest Income 25,000 13,072 10,000 5,527
Total Revenue 4,625,000 4,501,730 3,710,000 2,409,778
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 24,668
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 1,462,648
Transfer to General Fund 331,000 331,000 331,000 165,500
Total Expenditures 8,696,726 6,755,593 5,988,782 1,680,315
Net Surplus (Deficit) (4,071,726)$ (2,253,863)$ (2,278,782)$ 729,463$
Beginning Fund Balance 7,291,304 5,037,441
Ending Fund Balance 5,037,441$ 5,766,904$
City of Evanston
Washington National TIF Fund
As of June 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$ 247,928$
Interest Income - 585 - -
Total Revenue 448,875 460,647 397,800 247,928
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)$ 216,903$
Beginning Fund Balance 433,054 474,885
Ending Fund Balance 474,885$ 691,788$
City of Evanston
Special Service Area #5
As of June 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$ 621,802$
Interest Income 10,000 14,087 10,000 7,133
Total Revenue 1,110,000 1,136,335 1,110,000 628,935
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 - 1,000,000
Capital Projects 1,400,000 150,000 500,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 72,200
Total Expenditures 3,765,011 2,024,926 3,868,488 1,093,230
Net Surplus (Deficit)(2,655,011)$ (888,591)$ (2,758,488)$ (464,296)$
Beginning Fund Balance 4,245,639 3,357,048
Ending Fund Balance 3,357,048$ 2,892,752$
City of Evanston
SW II TIF (Howard Hartrey)
As of June 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$ 261,359$
Interest Income 100 2 1,000 6
Total Revenue 465,100 492,412 486,000 261,365
Economic Development Activities - 459 748,439 -
Capital Improvement Projects 580,000 422,675 - -
Operating Transfer to General Fund 29,500 29,500 29,500 14,750
Total Expenditures 609,500 452,634 777,939 14,750
Net Surplus (Deficit)(144,400)$ 39,778$ (291,939)$ 246,615$
Beginning Fund Balance 304,939 344,717
Ending Fund Balance 344,717$ 591,332$
City of Evanston
Southwest TIF
As of June 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$ 6,016,724$
Special Assessment Levy - - 169,848 -
Bond Proceeds/Premium/ Discounts - 23,281,822 - -
Transfer from Other Funds - IMRF- 783,004 783,004 141,125 70,560
Miscellaneous Revenue - 33,510 -
Interest Income 1,500 5,356 1,500 1,811
Transfer from General Fund - 1,000,000 1,279,306 639,654
Transfer from Sewer Fund 190,210 190,210 207,284 103,642
Transfer from Special Assessment Fund 317,660 317,660 169,848 84,924
Total Revenue 13,090,393 37,476,133 12,848,904 6,917,315
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 301,363
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 24,094
Total Expenditures 13,824,528 36,996,590 13,933,114 2,270,917
Net Surplus (Deficit)(734,135)$ 479,543$ (1,084,210)$ 4,646,399$
Beginning Fund Balance 2,896,148 3,375,691
Ending Fund Balance 3,375,691$ 8,022,090$
City of Evanston
Debt Service Fund
As of June 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$ 255,338$
Interest Income 400 344 400 11
Miscellaneous - 33,014 - 21,318
Total Revenue 500,400 228,239 350,400 276,667
Economic Dev. Projects - - -
Debt Service - Interest - 592 - 286
Capital Improvements 800,000 219,785 - 322,825
Developer Agreement Payments 610,000 505,855 300,000
Repayments to Econ. Dev. Fund 48,500 48,500 45,500 22,750
Transfers to General Fund 120,400 120,400 60,000 30,000
Total Expenditures 2,037,736 895,132 405,500 375,860
Net Surplus (Deficit)(1,537,336)$ (666,893)$ (55,100)$ (99,194)$
Beginning Fund Balance 1,055,510 388,617
Ending Fund Balance 388,617$ 289,423$
City of Evanston
Howard Ridge TIF
As of June 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 - - -
Interest Income 1,000 167 100 49
Total Revenue 3,701,000 46,419 40,100 49
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 3,510
Transfers to General Fund 60,000 60,000 60,000 30,000
Capital Projects 1,285,000 179,000 - -
Total Expenditures 3,635,000 381,627 165,000 33,510
Net Surplus (Deficit)66,000$ (335,208)$ (124,900)$ (33,461)$
Beginning Fund Balance 872,847 537,639
Ending Fund Balance 537,639$ 504,178$
City of Evanston
West Evanston TIF
As of June 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 June 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$
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 468,250
Miscellaneous - 53,986 -
Interest Income 10,000 18,562 10,000 3,602
Total Revenue 11,130,988 9,492,967 15,468,596 1,031,921
Capital Outlay (includes prior year rollovers) 13,100,351 6,119,879 17,935,016 1,215,554
Interfund Transfers Out 475,000 475,000 475,000 237,500
Total Expenditures 13,575,351 6,594,879 18,410,016 1,453,054
Net Surplus (Deficit)(2,444,363)$ 2,898,088$ (2,941,420)$ (421,133)$
Beginning Fund Balance 3,401,911 6,299,999
Ending Fund Balance 6,299,999$ 5,878,866$
City of Evanston
Capital Improvement Fund
As of June 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$ 96,743$
Bond Proceeds 250,000 241,906 250,000 -
Investment Income 10,000 1,982 1,200 422
Total Revenue 560,000 518,736 481,200 97,166
Transfer to Debt Service Fund 317,660 317,660 169,848 84,924
General Management & Support - - 1,000 440
Capital Outlay 361,000 33,976 500,000 -
Total Expenditures 678,660 351,636 670,848 85,364
Net Surplus (Deficit)(118,660)$ 167,100$ (189,648)$ 11,802$
Beginning Fund Balance 1,905,315 2,072,415
Ending Fund Balance 2,072,415$ 2,084,217$
City of Evanston
Special Assessment Fund
As of June 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$ 1,395,726$
Church Street Garage Operations 716,348 618,034 716,348 321,295
Maple Avenue Garage Operations 1,204,200 1,140,191 1,204,200 661,026
Sherman Avenue Garage Operations 1,417,275 1,600,383 1,417,275 2,207,825
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 4,585,872
7005 - Parking System Administration 784,607 804,417 976,360 768,434
7015 - Parking Lots and Meters 829,052 760,432 972,266 539,976
7025 - Church Street Self Park 607,955 414,444 624,855 171,365
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 809,729
7037 - Maple Avenue Garage 1,611,920 861,836 1,654,244 364,462
7039 - Parking Debt 27,461 27,461 27,461 2,218
Transfer to Insurance Fund 490,236 490,236 319,648 159,824
Transfer to General Fund 644,242 644,242 869,242 434,621
Transfer to Fleet 21,991 21,992 21,991 10,996
Transfer to Equipment Replacement 30,000 30,000 30,000 15,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 3,293,674
Net Surplus (Deficit)(5,120,337)$ (1,229,397)$ (4,500,740)$ 1,292,198$
Further Operating Expense Breakdown:
7015 Parking Meter Activities 762,846 760,432 935,614 539,976
7015 Parking Meter Depreciation 36,652 - 36,652 -
SUBTOTAL 799,498 760,432 972,266 539,976
7025- Church Garage Activities 494,156 414,444 444,927 171,365
7025- Church Garage Depreciation 179,928 - 179,928 -
SUBTOTAL 674,084 414,444 624,855 171,365
7036 Sherman Garage Activities 1,199,756 1,884,149 468,766 809,729
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 809,729
7037 Maple Garage Activities 1,013,991 861,836 988,046 364,462
7037 Debt Service Payments - - - -
7037 Reserve (Depreciation)666,198 - 666,198 -
SUBTOTAL 1,680,189 861,836 1,654,244 364,462
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$ 14,895,017$
City of Evanston
Parking Fund
As of June 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$ 3,181,129$
Skokie 2,856,000 2,772,424 2,913,000 1,648,254
Northwest Commission 4,517,000 5,183,425 4,653,000 2,644,121
Cross Connection Control Fees 100,500 94,470 95,000 105
Investment Earnings 2,500 20,164 2,500 8,430
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 94,971 45,000 81,641
Fees and Outside Work 80,000 188,610 70,000 66,397
Grants - 78,792 - 14,181
Insurance Reimbursements - - - -
Phosphate Sales 66,000 48,114 69,000 22,740
Property Sales and Rentals 213,300 235,936 227,316 41,256
Misc Revenue - 92,165 - 3,450
Total Revenue 17,560,000 16,800,482 20,327,216 7,711,704
General Support 990,583 960,028 933,989 432,754
Pumping 2,333,247 2,226,781 2,355,718 869,958
Filtration 2,635,539 2,435,092 2,740,856 1,251,047
Distribution 1,424,324 1,389,136 1,425,352 659,015
Meter Maintenance 309,163 249,474 300,760 128,821
Other Operating Expenses 478,592 994,606 491,700 135,380
Debt Service 864,233 810,068 1,297,703 183,839
Debt Service - IEPA Loan 3382 67,506 67,504 67,506 33,752
Capital Outlay 248,500 1,236,881 368,100 12,430
Capital Improvements 8,065,700 4,198,326 10,170,000 2,270,900
Interfund Transfers Out - General Fund 3,356,300 3,356,300 3,369,559 1,684,779
Interfund Transfers Out - Insurance Fund 468,492 468,492 468,492 234,247
Total Expense 21,242,179 18,392,688 23,989,735 7,896,922
Net Surplus (Deficit)(3,682,179)$ (1,592,206)$ (3,662,519)$ (185,218)$
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$ 8,404,873$
City of Evanston
Water Fund
As of June 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$ 6,517,583$
Debt Proceeds 4,000,000 1,851,827 - -
Debt Proceeds - 2012 IEPA Loan 3,100,000 2,523,969 2,190,000 292,451
Investment Earnings 1,000 1,270 1,000 -
Miscellaneous 18,865 15,881 4,165 860,353
Grant Revenue - 860,353 - -
Total Revenue 20,027,865 18,747,618 15,117,865 7,670,387
Sewer Operations 2,134,549 2,026,860 2,260,545 1,084,591
Other Operating Expenses 43,300 10,900 129,500 2,879
Interfund Transfers Out - General Fund 142,200 142,200 145,044 72,522
Interfund Transfers Out - Insurance Fund 269,988 269,988 269,988 134,994
Transfer to Debt Service 190,211 190,210 207,284 103,642
Capital Outlay 20,600 13,714 47,500 41,040
Depreciation - 4,570,214 - -
Capital Improvement Account 4,922,500 - 3,225,000 73,260
Debt Service 11,542,740 11,711,077 9,994,259 4,740,002
Total Expenses 19,266,088 18,935,163 16,279,120 6,252,931
Net Surplus (Deficit)761,777$ (187,545)$ (1,161,255)$ 1,417,456$
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$ 5,992,452$
City of Evanston
Sewer Fund
As of June 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$ 527,984$
Solid Waste Franchise Fees 175,000 199,980 175,000 41,058
SWANCC Recycling Incentive 140,000 30,467 25,000 2,029
Recycling Service Charge 2,954,033 3,013,668 3,334,033 1,785,735
Sanitation Service Charge Penalty 30,000 44,099 45,000 -
Special Pickup Fees 100,000 86,804 100,000 -
Trash Cart Sales 15,000 27,697 15,000 6,179
Investment Income - 20 - -
Yard Waste Fees 350,000 248,077 220,000 30,694
Total Revenue 5,010,000 4,896,779 4,970,000 2,393,677
Refuse Collection & Disposal 3,259,574 2,882,420 3,372,698 1,409,412
Residential Recycling Collection 1,254,398 1,223,782 1,186,134 594,111
Yard Waste Collection 750,250 626,253 750,250 216,617
Total Expense 5,264,222 4,732,455 5,309,082 2,220,140
Net Surplus (Deficit)(254,222)$ 164,324$ (339,082)$ 173,538
Beginning Unrestricted Fund Balance (1,447,884) (1,283,560)
Ending Unrestricted Fund Balance (1,283,560)$ (1,110,023)
City of Evanston
Solid Waste
As of June 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,253,679$
Library Fund 2,381 2,381 2,381 1,191
Parking Fund 21,992 21,992 21,992 10,996
Water Fund 122,751 122,751 122,751 61,376
Sewer Fund 177,729 177,729 177,729 88,865
Solid Waste Fund 298,071 298,071 298,071 149,036
Damage to City Property 24,789 - 24,789 -
Miscellaneous Revenue 10,000 46,349 10,000 19,574
Interest Income 1,000 - 1,000 -
Total Revenues 3,166,069 3,776,631 3,166,069 1,584,715
General Support 292,007 271,772 293,619 129,023
Major Maintenance 3,217,058 3,287,552 3,284,528 1,449,917
Total Expenditures 3,509,065 3,559,324 3,578,147 1,578,940
Net Surplus (Deficit)(342,996)$ 217,307$ (412,078)$ 5,775$
Beginning Fund Balance (107,097) 110,566
Reclassification from Fund Balance to Capital Assets 356
Ending Fund Balance 110,566$ 116,341$
City of Evanston
Fleet Maintenance Fund
As of June 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$ 621,295$
Library Fund 1,700 1,700 1,700 850
Parking Fund 30,000 30,000 30,000 15,000
Solid Waste Fund 177,131 177,131 177,131 88,566
Bond Proceeds - - 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 760,222
Capital Outlay 2,400,000 1,625,725 2,494,000 256,091
Carryover - - 200,000 -
Depreciation -
Capital Leases 50,000 - 50,000 24,997
Total Expenditures 2,450,000 1,625,725 2,744,000 281,088
Net Surplus (Deficit)(788,362)$ (43,232)$ (82,362)$ 479,134$
Beginning Fund Balance 1,500,482$ 588,983$
Reclassification from Capital Assets to Fund
Balance (868,267)$
Ending Fund Balance 588,983$ 1,068,117$
City of Evanston
Equipment Replacement Fund
As of June 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$ 60,602$
General Admin Contribution- E911 930 930 930 465
General Admin Contribution- CDBG 930 930 930 465
General Admin Contribution- E.D.930 930 930 465
General Admin Contribution- Parking 17,032 17,032 17,032 8,516
General Admin Contribution- Water Fund 24,962 24,962 24,962 12,481
General Admin Contribution- Sewer Fund 14,385 14,385 14,385 7,193
Liability/Property Contribution- General 909,150 909,150 909,150 454,575
Liability/Property Contribution- E911 6,972 6,972 6,972 3,486
Liability/Property Contribution- CDBG 6,972 6,972 6,972 3,486
Liability/Property Contribution- E.D. 6,972 6,972 6,972 3,486
Liability/Property Contribution- Parking 127,731 127,731 127,731 63,866
Liability/Property Contribution- Water Fund 187,209 187,209 187,209 93,605
Liability/Property Contribution- Sewer Fund 107,887 107,887 107,887 53,943
Workers' Comp Contribution- General 1,244,860 1,244,860 1,244,860 622,431
Workers' Comp Contribution- Library Fund 5,898 5,898 40,000 20,000
Workers' Comp Contribution- E911 9,546 9,546 9,546 4,773
Workers' Comp Contribution- CDBG 9,546 9,546 9,546 4,773
Workers' Comp Contribution- E.D. 9,546 9,546 9,546 4,773
Workers' Comp Contribution- Parking 174,886 174,886 174,886 87,443
Workers' Comp Contribution- Water Fund 256,322 256,322 256,322 128,161
Workers' Comp Contribution- Sewer Fund 147,716 147,716 147,716 73,858
Subrogation Proceeds 83,300 155,102 100,000 44,900
Yearend Transfer from General Fund - 874,289 - -
Transfer from General Fund - Casualty Loss Acct - - - -
Investment Income 41,650 212 1,000 -
Workers Comp & Liability - Subtotal 3,516,536 4,421,189 3,526,688 1,757,745
Health Insurance Chargebacks- General 8,232,350 8,262,909 8,780,657 4,390,329
Health Insurance Chargebacks - Library 318,681 318,681 366,065 183,033
Health Insurance Chargebacks - NSP2 16,390 16,390 6,863 3,431
Health Insurance Chargebacks- E911 81,545 81,545 71,410 35,705
Health Insurance Chargebacks- CDBG 12,586 12,586 31,521 15,760
Health Insurance Chargebacks- E.D. Fund 56,081 49,968 49,098 24,549
Health Insurance Chargebacks- Home Fund - - 2,735 1,368
Health Insurance Chargebacks- Parking 170,588 170,588 171,325 85,663
Health Insurance Chargebacks- Water 596,392 596,392 616,227 308,114
Health Insurance Chargebacks- Sewer 168,030 168,030 183,218 91,609
Health Insurance Chargebacks - Solid Waste 114,220 114,220 106,846 53,423
Health Insurance Chargebacks- Fleet 183,414 183,414 202,427 101,213
Retiree Health Insurance Contributions 1,684,894 1,688,954 1,970,647 743,119
Employee Health Insurance Contributions 1,760,276 1,489,664 1,706,017 703,791
SWANNC-Health Insurance Contributions - - - 39,435
One Time IPBC Distribution 300,000 300,000 300,000 150,000
Health & Life insurance - Subtotal 13,695,447 13,453,341 14,565,056 6,930,542
Total Revenues 17,211,983 17,874,530 18,091,744 8,688,287
City of Evanston
Insurance Fund
As of June 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 June 30, 2014
General Administration & Support 294,093 286,369 409,548 130,346
Auditing 25,000 - - -
Liability/Property Insurance Premiums 470,000 455,514 470,000 490,744
Liability Legal Fees 350,000 460,204 350,000 136,058
Liability Settlement Payments 400,000 471,052 400,000 390,988
Transfer - to ERI Debt Service 8,325 8,325 8,627 4,314
Workers' Comp Insurance Premiums 114,400 111,111 114,400 118,531
Workers' Comp Legal Fees 80,500 38,694 80,500 26,904
Workers' Comp Medical Payments 800,000 493,886 600,000 269,811
Workers' Comp Settlement Payments 1,100,000 899,625 1,100,000 363,966
Workers' Comp TPA Pymts (non specific)145,000 154,244 125,000 25,375
Workers' Comp TTD Pymts (non sworn)- - - 49,608
Workers' Comp & Liability - Subtotal 3,787,318 3,379,024 3,658,075 2,006,644
General Administration & Support 94,093 87,437 99,805 76,545
Health Insurance Premiums 13,458,615 13,183,406 14,217,604 6,782,336
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 6,870,458
Total Expenditures 17,424,026 16,695,000 18,067,284 8,877,102
Net Surplus (Deficit)(212,043)$ 1,179,530$ 24,460$ (188,815)$
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,916,477)$
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$ 3,280,016$
Personal Property Repl Tax 280,000 280,000 280,000 214,614
Interest on Investment 800,000 1,564,893 850,000 1,256
Participant Contributions 922,500 975,932 950,000 411,952
Unrealized Gain - 5,233,195 - 5,000
Miscellaneous - 150 - -
Total Revenue 8,064,075 14,103,403 8,141,575 3,912,838
Administrative Expenses 154,000 271,223 154,000 17,186
Legal Fees 50,000 - 50,000
Retiree Pensions 4,841,000 4,871,953 4,995,500 2,625,250
Widows' Pensions 1,090,000 1,053,398 1,071,200 535,549
Disability Pensions 1,350,000 1,304,970 1,358,125 644,586
QUILDRO 75,000 90,364 90,000 48,148
Reserve for Future Payments - - - -
Total Expenditures 7,560,000 7,591,908 7,718,825 3,870,720
Net Surplus (Deficit)504,075$ 6,511,495$ 422,750$ 42,118$
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$ 65,067,059$
City of Evanston
Fire Pension Fund
As of June 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$ 4,376,433$
Personal Property Repl Tax 325,000 325,000 325,000 214,614
Interest Income 2,625,000 3,277,547 2,800,000 1,066,869
Participant Contributions 1,383,750 1,759,216 1,423,000 642,753
Miscellaneous - - - -
Unrealized Gain / (Loss) - 6,375,354 - -
Total Revenue 12,403,075 19,815,032 12,617,325 6,300,668
Administrative Expenses 250,000 264,528 250,000 163,770
Retiree Pensions 7,500,769 7,787,104 8,056,000 4,072,905
Widow Pensions 868,000 857,302 875,500 439,349
Disability Pensions 700,000 662,888 700,000 322,225
Separation Refunds 150,000 109,252 275,000 2,831
QUILDRO 18,000 21,084 18,000 10,859
Reserve for Future Payments - - -
Total Expenditures 9,486,769 9,702,158 10,174,500 5,011,939
Net Surplus (Deficit)2,916,306$ 10,112,874$ 2,442,825$ 1,288,729$
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$ 92,051,872$
City of Evanston
Police Pension Fund
As of June 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$ 2,381,265$
Library Fines & Fees 185,000 169,583 164,000 75,702
Library Material Replacement 12,500 12,484 14,000 6,267
Copy Machine Charges 20,000 18,814 21,200 8,334
Meeting Room Fees 10,000 12,397 10,400 9,852
Non-resident Cards 1,690 1,565 1,040 260
North Branch Rental Income 59,660 58,697 60,000 14,963
State Per Capita Grant 76,300 103,995 94,177 23,126
Personal Property Repl. Tax 50,200 50,200 50,200 -
Video Rentals - - - -
Book Sales 60,000 56,140 65,000 -
Merchandise Sale -
Fund for Excellence 245,000 127,433 125,000 25,309
Grants and Donations - 116,545 28,240
Transfer from Economic Development - 9,900 - -
Miscellaneous - 3,854 - 288
Transfer from Endowment 131,250 131,249 159,315 159,315
Total Revenues 5,104,814 4,921,824 5,912,974 2,732,921
Expenditures
Youth Services 891,720 903,873 1,030,009 462,126
Adult Services 1,535,224 1,538,627 1,514,037 649,533
Circulation 612,892 605,865 573,258 243,842
Neighborhood Services 360,757 325,649 456,528 200,274
Technical Services 503,433 431,115 538,879 207,649
Maintenance 507,517 672,615 660,703 295,824
Administration 669,377 678,430 1,103,015 486,842
Library Grants - 35,569 36,545 2,927
Total Expenditures 5,080,920 5,191,743 5,912,974 2,549,018
Net Surplus (Deficit)23,894$ (269,919)$ -$ 183,903$
Beginning Fund Balance 1,101,096 982,764
Adjustment to GAAP Basis of Accounting 151,587 -
Ending Fund Balance 982,764 1,166,667
City of Evanston
Library Fund
As of June 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$ 396,370$
Library Fines & Fees - - 1,000 -
Total Revenues - - 749,178 396,370
Expenditures
Series 2004 - Principal DSF - - 53,430 -
Series 2004 - Interest DSF - - 8,454 -
Series 2005 - Principal DSF - - 44,918 -
Series 2005 - Interest DSF - - 14,089 -
Series 2007 - Principal DSF - - 200,291 -
Series 2007 - Interest DSF - - 60,496 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$ 342,646$
Beginning Fund Balance - -
Ending Fund Balance - 342,646
City of Evanston
Library Debt Fund
As of June 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,414$
FY 2013 Unreserved Fund Balance 17,412,530$ 18,091,096$ 21,774,085$ 22,459,219$ 23,342,537$ 19,526,063$
FY 2014 Cash Balance 4,173,079$ 6,745,425$ 10,059,258$ 9,101,839$ 8,474,680$ 7,167,254$
FY 2013 Cash Balance 6,624,063$ 7,811,937$ 12,160,633$ 12,969,898$ 12,797,660$ 13,337,226$
$-
$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