HomeMy WebLinkAbout2012.09 September Monthly Report
To: Wally Bobkiewicz, City Manager
Martin Lyons, Assistant City Manager/Chief Financial Officer
From: Louis Gergits, Finance Manager
Hitesh Desai, Accounting Manager
Subject: September 2012 Monthly Financial Report
Date: October 26, 2012
Please find attached the unaudited financial statements as of September 30, 2012. A
summary by fund for total revenues, expenditures/expenses, fund balances, and cash
balances is as follows:
YTD YTD YTD 09/30/212 09/30/212
09/30/212 09/30/212 09/30/212 Unreserved Cash
Fund Name Fund # Revenue Expenses Net Fund Balance Balance*
General 100 63,193,748$ 59,888,685$ 3,305,063$ 21,698,232$ 11,745,631$
Library 185 4,846,631 3,293,153 1,553,478 1,553,478 1,550,796
HPRP 190 83,648 83,648 - - -
Neighborhood Stabilization 195 6,522,632 6,372,152 150,480 150,480 150,482
Motor Fuel 200 1,373,125 1,433,933 (60,808) 1,139,436 979,436
Emergency 911 205 775,948 804,017 (28,069) 1,282,689 1,142,066
SSA#4 210 357,743 298,500 59,243 (1,788) (30,666)
CDBG 215 1,689,244 1,197,576 491,668 914,467 132,054
CDBG Loan 220 215,647 139,896 75,751 2,077,831 101,411
Economic Development 225 1,177,822 1,468,370 (290,548) 1,897,061 1,676,004
Neighborhood Improvement 235 - - - 109,915 109,915
Home 240 447,489 353,297 94,192 2,814,810 3,300
Affordable Housing 250 36,579 89,433 (52,854) 2,205,663 526,731
Washington National TIF 300 4,634,333 3,753,167 881,166 9,075,514 8,494,123
SSA#5 305 423,533 423,231 302 448,471 394,815
SW II TIF (Howard Hartrey) 310 1,141,572 1,163,409 (21,837) 4,979,036 4,979,036
Southwest TIF 315 455,021 22,360 432,661 318,578 310,779
Debt Service 320 16,509,520 7,159,294 9,350,226 11,979,246 10,418,067
Howard Ridge TIF 330 492,653 397,111 95,542 1,196,295 1,186,806
West Evanston TIF 335 263,099 425,052 (161,953) 1,333,640 1,258,932
Capital Improvement 415 5,183,719 2,907,569 2,276,150 8,022,810 8,325,626
Special Assessment 420 199,616 422,597 (222,981) 2,721,908 2,721,908
Parking 505 8,165,084 6,007,187 2,157,897 17,354,338 16,880,624
Water 510-513 15,882,523 13,686,880 2,195,643 10,442,631 10,396,810
Sewer 515 14,930,955 10,138,296 4,792,659 8,305,930 6,448,183
Solid Waste 520 3,480,946 3,308,300 172,646 (1,399,065) (1,720,756)
Fleet 600 2,418,039 3,856,966 (1,438,927) 200,684 (302,468)
Equipment Replacement 601 2,766,457 1,500,503 1,265,954 1,265,954 1,265,954
Insurance 605 12,123,474 12,362,253 (238,779) (6,363,551) 1,094,321
Total** 169,790,800$ 142,956,835$ 26,833,965$ 105,724,693$ 90,239,920$
*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.
The City manages these funds as a trustee and are not available for use by the City.
Memorandum
1
Beginning in 2012 the General Fund balance calculation includes both the undesignated
and designated (IMRF and Compensated absence reserve of $5.4 million) fund
balances.
The budget target through September 30, 2012 was 75% of the Fiscal Year 2012
budgeted amount. General Fund Revenues were approximately $63.2M or 76.4% of
the budgeted amount. General Fund Expenditures were $59.9M or 70.9% of the
budgeted amount. The net surplus for the General Fund through September 30, 2012
was approximately $3.3M. Barring external circumstances such as reductions in federal
or state funds, or a withholding of property taxes by the County, the overall FY 2012
General Fund budget appears stable.
Included above are the ending balances as of September 30, 2012 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. There is typically a one to
three month delay in collection of income tax, sales tax, use tax and
telecommunications tax.
Through September 30, 2012, the Library Fund revenues are $4.3M after excluding the
one-time transfer of assets from the General Fund totaling $521,920. Additionally,
when excluding the one-time General Fund transfer of assets, year-to-date Library Fund
surplus is approximately $1M. Staff anticipates that Library Fund revenues will not
increase significantly for the remainder of FY 2012. As a result, staff anticipates the
Library will spend down most of the remaining fund balance by year-end.
Through September 30, 2012, the Special Service Area (SSA) #4 Fund is showing a
negative fund balance of $1,788 and a negative cash balance of $30,666.
Through September 30, 2012, the Debt Service Fund is showing a positive cash
balance of approximately $10.4M. Staff anticipates this balance will be significantly
reduced on December 1, 2012 due to a scheduled debt service payment of
approximately $9.5M. Additionally, the Debt Service Fund balance will be further
reduced due to a scheduled payment of $337,063 on January 1, 2013.
Through September 30, 2012, the Solid Waste Fund is showing a negative fund
balance of $1,399,065 and a negative cash balance of $1,720,756.
Through September 30, 2012, there is a negative cash balance of $302,468 in the Fleet
Fund.
If there are any questions on the attached report, please contact me by phone at (847)
859-7816 or by email: lgergits@cityofevanston.org.
2
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 September 30, 2012 year-to-
date financial information and reports which to the best of my knowledge appear
accurate and complete.
3
Revenues Budget Actual
% of
Budget Budget Actual
% of
Budget Budget Actual
% of
Budget Budget Actual
% of
Budget Budget Actual
% of
Budget
Property Tax 12,296,386$ 12,279,568$ 99.9% -$ -$ -$ -$ -$ -$ -$ -$
Sales Tax 15,206,475 10,620,191 69.8% - - - - - - - -
State Income Tax 5,853,839 5,002,740 85.5% - - - - - - - -
Utility Tax 8,672,006 6,187,672 71.4% - - - - - - - -
Real Estate Transfer Tax 1,725,000 1,512,462 87.7% - - - - - - - -
Liquor Tax 2,070,063 1,639,467 79.2% - - - - - - - -
Other Taxes 5,860,547 3,712,221 63.3% - - - - - - - -
Licenses, Permits, Fees 8,652,861 6,873,714 79.4% - - - - - - - -
Charges for Services 7,853,023 6,123,096 78.0% 6,171,637 4,832,539 78.3% 12,905,000 10,809,605 83.8% 12,908,000 10,882,631 84.3% 3,624,033 2,495,349 68.9%
Intergovernmental Revenues 669,897 426,705 63.7% - - 262,500 262,500 100.0% - - 140,000 51,122 36.5%
Interfund Transfers 7,890,068 5,758,166 73.0% 3,876,726 3,332,545 86.0% - - - - 1,245,967 934,475 75.0%
Other Non-Tax Revenue 5,950,622 3,057,746 51.4% 2,034,004 - 0.0% 5,600,557 4,810,418 85.9% 9,092,236 4,048,324 44.5% - -
Total Revenues 82,700,787$ 63,193,748$ 76.4% 12,082,367$ 8,165,084$ 67.6% 18,768,057$ 15,882,523$ 84.6% 22,000,236$ 14,930,955$ 67.9% 5,010,000$ 3,480,946$ 69.5%
Expenditures
Legislative 616,033$ 469,860$ 76.3% -$ -$ -$ -$ -$ -$ -$ -$
City Administration 1,856,258 1,080,626 58.2% - - - - - - - -
Law Department 999,107 679,885 68.0% - - - - - - - -
Administrative Services Department 8,643,197 5,813,515 67.3% - - - - - - - -
Community and Econ. Development 3,148,339 2,210,960 70.2% - - - - - - - -
Police Department 24,752,938 18,127,879 73.2% - - - - - - - -
Fire & Life Safety Services 13,314,621 9,824,880 73.8% - - - - - - - -
Health Department 2,413,969 1,672,234 69.3% - - - - - - - -
Public Works - Operating 9,559,460 6,544,115 68.5% 11,731,140 4,295,349 36.6% - - - - 5,187,861 3,308,300 63.8%
Public Works - Capital Outlay - - 3,520,000 1,711,838 48.6% - - - - - -
Parks, Recreation & Comm. Services 17,392,621 12,848,064 73.9% - - - - - - - -
Capital Improvement Transfer 1,250,000 450,000 36.0%
Equipment Replacement Transfer 500,000 166,667 33.3%
Utilities - Operating - - - - 12,664,258 9,260,988 73.1% 16,690,143 9,697,250 58.1% - -
Utilities - Capital Outlay - - - - 7,999,500 4,425,892 55.3% 4,771,000 441,046 9.2% - -
Total Expenditures 84,446,543$ 59,888,685$ 70.9% 15,251,140$ 6,007,187$ 39.4% 20,663,758$ 13,686,880$ 66.2% 21,461,143$ 10,138,296$ 47.2% 5,187,861$ 3,308,300$ 63.8%
As of September 30, 2012
City of Evanston
Report of Budget-to-Actual Revenues and Expenditures
Parking Fund Water Fund Solid Waste FundSewer FundGeneral Fund
(Target is 75% of FY 2012 Budget)
4
FY 2011 FY 2011 FY 2012 FY 2012
Budget Audited Budget YTD
Adopted Actual Amended Actual
Tax - Property 16,516,200$ 16,235,517$ 12,296,386$ 12,279,568$
Tax - State Use 677,877 921,494 1,091,215 792,162
Tax - Sales Tax - Basic 7,300,000 7,671,007 9,209,455 6,500,401
Tax - Sales Tax - Home Rule 4,552,968 4,902,429 5,997,020 4,119,790
Tax - Auto Rental 29,155 34,004 36,445 28,591
Tax - Athletic Contest 550,000 718,538 700,000 190,795
Tax - State Income 4,635,565 4,924,177 5,853,839 5,002,740
Tax - Fire Insurance 90,000 - - -
Tax - Electric Utility 2,196,333 2,358,266 3,069,806 2,239,961
Tax - Natural Gas Utility 1,385,130 871,281 1,583,000 741,385
Tax - Natural Gas Use - Home Rule 709,044 539,228 869,000 527,836
Tax - Cigarette 295,284 301,219 485,000 142,495
Tax - Evanston Motor Fuel 550,378 481,751 761,587 480,728
Tax - Liquor 1,623,754 1,857,121 2,070,063 1,639,467
Tax - Parking 1,800,000 1,942,347 2,160,000 1,667,449
Tax - Personal Property Replacement 441,166 438,324 626,300 410,001
Tax - Real Estate Transfer 1,500,000 1,989,587 1,725,000 1,512,462
Tax - Telecommunications 2,691,834 2,607,013 3,150,200 2,678,490
License Fees - Vehicles 1,799,820 2,056,523 2,598,341 688,283
License Fees - Other 814,720 900,475 1,045,382 647,958
Permit Fees - Building 2,500,000 1,834,961 2,500,000 3,041,990
Permit Fees - Other 1,086,400 1,142,828 1,184,788 1,513,863
Other Fees 1,092,617 847,241 1,324,350 981,620
Fines and Forfeiture Revenue 3,806,864 3,279,785 4,721,639 2,230,430
Charges for Services Revenue 6,048,402 6,184,831 7,853,023 6,123,096
Intergovernmental Revenue 802,239 795,336 669,897 426,705
Other Revenue 1,575,183 809,498 1,216,983 822,109
Interfund Transfers In (Other Funds)6,790,549 6,557,462 7,890,068 5,758,166
Interest Income 12,000 767,335 12,000 5,207
Total Revenue 73,873,482 73,969,578 82,700,787 63,193,748
Legislative 523,131 516,342 616,033 469,860
City Administration 1,675,952 1,363,079 1,856,258 1,080,626
Law Department 828,120 821,667 999,107 679,885
Administrative Services Department 8,206,488 7,297,540 8,643,197 5,813,515
Community and Economic Development 2,824,205 2,616,811 3,148,339 2,210,960
Police Department 20,263,642 20,444,887 24,752,938 18,127,879
Fire & Life Safety Services Department 11,192,783 11,019,489 13,314,621 9,824,880
Health Department 2,135,313 1,991,209 2,413,969 1,672,234
Public Works Department 6,862,268 6,426,231 9,559,460 6,544,115
Library (Note 1)3,708,359 3,695,279 -
Parks, Recreation & Community Services 15,653,221 15,436,525 17,392,621 12,848,064
Transfer to Capital Improvement Fund - - 1,250,000 450,000
Transfer to Equipment Replacement Fund - - 500,000 166,667
Total Expenditures 73,873,482 71,629,059 84,446,543 59,888,685
Net Surplus (Deficit)-$ 2,340,519$ (1,745,756)$ 3,305,063$
Beginning Unrestricted Fund Balance (Note 2) 22,003,752 18,393,169
Adjustment to GAAP Basis of Accounting (5,951,102) -
Total Ending Fund Balance 18,393,169$ 21,698,232$
Audited FY 2011 Ending Fund Balance Composition
Restricted for Fund Activities -
Committed -
Assigned / Unassigned 18,393,169
Total Ending Fund Balance 18,393,169
Note 1: The Library is budgeted as a separate fund in FY 2012.
Note 2: Unrestricted fund balance includes amounts designated for compensated absences and IMRF.
City of Evanston
General Fund
As of September 30, 2012
5
FY 2011 FY 2011 FY 2012 FY 2012
Budget Audited Budget YTD
Adopted Actual Adopted Actual
Revenue By Source
Library Fines & Fees -$ -$ 150,000$ 113,300$
Library Material Replacement - - 12,500 8,950
Copy Machine Charges - - 20,000 15,775
Meeting Room Fees - - 10,000 5,281
Non-resident Cards - - 2,460 866
North Branch Rental Income - - 47,325 39,893
State Per Capita Grant - - 75,900 76,385
Personal Property Repl. Tax - - 50,200 -
Video Rentals - - 28,000 25,016
Transfer from General Fund - - - 521,920
Allocation - Property Taxes - - 4,253,214 4,039,245
Total Revenues - - 4,649,599 4,846,631
Expenditures
Youth Services - - 800,390 604,183
Adult Services - - 1,579,231 1,090,667
Circulation - - 589,769 445,735
North Branch - - 203,336 138,140
Technical Services - - 473,306 341,037
Maintenance - - 491,375 315,358
Administration - - 512,192 358,033
Total Expenditures - - 4,649,599 3,293,153
Net Surplus (Deficit)- - - 1,553,478$
Beginning Fund Balance - -
Ending Fund Balance - 1,553,478
Audited FY 2011 Ending Fund Balance Composition
Restricted for Fund Activities -
Committed -
Assigned / Unassigned -
Total Ending Fund Balance -
*The Library is budgeted as a separate fund in FY 2012. In prior fiscal years, the Library
was a department in the General Fund.
City of Evanston
Library Fund*
As of September 30, 2012
6
FY 2011 FY 2011 FY 2012 FY 2012
Budget Audited Budget YTD
Adopted Actual Adopted Actual
Grant Proceeds 288,460$ 195,943$ 80,000$ 83,648$
Total Revenue 288,460 195,943 80,000 83,648
HPRP Administration 27,000 18,522 - -
Program Activities 261,460 177,421 80,000 83,648
Total Expenditures 288,460 195,943 80,000 83,648
Net Surplus (Deficit) -$ -$ -$ -$
Beginning Fund Balance - -
Ending Fund Balance -$ -$
Audited FY 2011 Ending Fund Balance Composition
Restricted for Fund Activities -
Committed -
Assigned / Unassigned -
Total Ending Fund Balance -
City of Evanston
Homelessness Prevention & Rapid Re-Housing Program
As of September 30, 2012
7
FY 2011 FY 2011 FY 2012 FY 2012
Adopted Audited Budget YTD
Budget Actual Adopted Actual
Grant Proceeds 6,887,345$ 5,409,752$ 5,699,363$ 6,353,684$
Program Income 1,500,000 - 1,750,000 168,948
Total Revenue 8,387,345 5,409,752 7,449,363 6,522,632
Development Activities 7,985,000 5,083,230 6,771,363 6,022,396
Administration 124,345 324,612 338,749 242,843
Transfer to Debt Service - 1,910 3,616 2,712
Transfer to Insurance - - 15,635 11,726
Transfer to General Fund 278,000 - 320,000 92,475
Total Expenditures 8,387,345 5,409,752 7,449,363 6,372,152
Net Surplus (Deficit) -$ -$ -$ 150,480$
Beginning Fund Balance - -
Ending Fund Balance -$ 150,480$
Audited FY 2011 Ending Fund Balance Composition
Restricted for Fund Activities -
Committed -
Assigned / Unassigned -
Total Ending Fund Balance -
City of Evanston
Neighborhood Stabilization Fund
As of September 30, 2012
8
FY 2011 FY 2011 FY 2012 FY 2012
Adopted Audited Adopted YTD
Budget Actual Budget Actual
State Allotment 1,900,000$ 2,195,972$ 1,900,000$ 1,372,401$
Investment Earnings 2,000 615 2,000 724
Miscellaneous Income - - - -
Total Revenue 1,902,000 2,196,587 1,902,000 1,373,125
Street Resurfacing (2012) 1,200,000 980,941 1,400,000 806,191
Transfer to General Fund - Staff Engineering 110,606 110,606 132,727 99,545
Transfer to General Fund - Street Maintenance 586,886 586,886 704,263 528,197
Total Expenditures 1,897,492 1,678,433 2,236,990 1,433,933
Net Surplus (Deficit)4,508$ 518,154$ (334,990)$ (60,808)$
Beginning Fund Balance 682,090 1,200,244
Ending Fund Balance 1,200,244$ 1,139,436$
Audited FY 2011 Ending Fund Balance Composition
Restricted for Fund Activities 1,200,244
Committed -
Assigned / Unassigned -
Total Ending Fund Balance 1,200,244
City of Evanston
Motor Fuel Fund
As of September 30, 2012
9
FY 2011 FY 2011 FY 2012 FY 2012
Adopted Audited Adopted YTD
Budget Actual Budget Actual
Landline Surcharge Revenue 525,000$ 511,586$ 617,400$ 441,207$
Wireless Surcharge Revenue 340,000 383,844 416,160 334,227
Interest Income 750 296 1,000 514
Miscellaneous Revenue - - - -
Total Revenue 865,750 895,726 1,034,560 775,948
Operating Expense 778,737 689,786 847,415 592,889
Transfer to General Fund 125,868 125,868 125,950 94,462
Transfer to Insurance Fund - 95,095 71,321
Transfer to Debt Service Fund - 10,385 7,789
Capital Replacement 229,353 164,146 188,000 37,556
Total Expenditures 1,133,958 979,800 1,266,845 804,017
Net Surplus (Deficit)(268,208)$ (84,074)$ (232,285)$ (28,069)$
Beginning Fund Balance 1,394,832 1,310,758
Ending Fund Balance 1,310,758$ 1,282,689$
Audited FY 2011 Ending Fund Balance Composition
Restricted for Fund Activities 1,310,758
Committed -
Assigned / Unassigned -
Total Ending Fund Balance 1,310,758
City of Evanston
E911 Fund
As of September 30, 2012
10
FY 2011 FY 2011 FY 2012 FY 2012
Adopted Audited Adopted YTD
Budget Actual Budget Actual
Property Tax Revenue 378,000$ 214,614$ 398,000$ 357,737$
Investment Income - 30 - 6
Total Revenues 378,000 214,644 398,000 357,743
Professional Fees (Evmark)378,000 388,000 398,000 298,500
Total Expenditures 378,000 388,000 398,000 298,500
Net Surplus (Deficit)-$ (173,356)$ -$ 59,243$
Beginning Fund Balance 112,325 (61,031)
Ending Fund Balance (61,031)$ (1,788)$
Audited FY 2011 Ending Fund Balance Composition
Restricted for Fund Activities -
Committed -
Assigned / Unassigned (61,031)
Total Ending Fund Balance (61,031)
City of Evanston
Special Service Area #4 Fund
As of September 30, 2012
11
FY 2011 FY 2011 FY 2012 FY 2012
Adopted Audited Adopted YTD
Budget Actual Budget Actual
Intergovernmental/Entitlement 2,095,180$ 1,754,755$ 1,490,500$ $ 1,606,127
Funds Reallocated from Prior Years 25,000 65,693 -
Program Income 20,000 - 140,000 83,117
Miscellaneous - 5,302 - -
Total Revenues 2,140,180 1,760,057 1,696,193 1,689,244
CDBG Administration/Planning 308,367 337,872 232,382 121,596
Development Activities 1,016,894 1,418,095 432,000 342,150
Capital Projects - - 255,000 152,665
Transfers to Debt Service - 4,090 - 2,033
Transfers to General Fund 772,000 - 776,811 579,132
Total Expenditures 2,097,261 1,760,057 1,696,193 1,197,576
Net Surplus (Deficit)42,919$ -$ -$ 491,668$
Beginning Fund Balance 422,799 422,799
Ending Fund Balance 422,799$ 914,467$
Audited FY 2011 Ending Fund Balance Composition
Restricted for Fund Activities 422,799
Committed -
Assigned / Unassigned -
Total Ending Fund Balance 422,799
City of Evanston
CDBG Fund
As of September 30, 2012
12
FY 2011 FY 2011 FY 2012 FY 2012
Adopted Audited Adopted YTD
Budget Actual Budget Actual
Intergovernmental Revenue -$ 4,800$ -$ 133,549$
Program Income 9,000 - 9,000 81,939
Interest Income - 1,018 - 159
Total Revenues 9,000 5,818 9,000 215,647
Program Expenses 20,000 8,460 20,000 139,896
Transfer to CDBG - - - -
Development Activities - - - -
Total Expenditures 20,000 8,460 20,000 139,896
Net Surplus (Deficit) (11,000)$ (2,642)$ (11,000)$ 75,751$
Beginning Fund Balance 2,004,722 2,002,080
Ending Fund Balance 2,002,080$ 2,077,831$
Audited FY 2011 Ending Fund Balance Composition
Restricted for Fund Activities 2,002,080
Committed -
Assigned / Unassigned -
Total Ending Fund Balance 2,002,080
City of Evanston
CDBG Loan Fund
As of September 30, 2012
13
FY 2011 FY 2011 FY 2012 FY 2012
Adopted Audited Amended YTD
Budget Actual Budget Actual
Hotel Tax 1,350,000$ 1,440,739$ 1,600,000$ 931,579$
Amusement Tax 300,000 241,767 300,000 197,431
Howard-Ridge Loan Repayment - - 48,500 48,500
Miscellaneous - - - -
Investment Income 8,000 179 8,000 312
Total Revenues 1,658,000 1,682,685 1,956,500 1,177,822
Economic Development Activities 1,640,247 1,541,021 1,802,825 1,019,469
Capital Projects - - 160,000 43,307
Tax Rebate Agreement - - - -
Transfer to Debt Service - - 12,752 9,564
Transfer to Insurance - - 75,334 56,500
Transfers to General Fund 377,256 377,256 452,707 339,530
Total Expenditures 2,017,503 1,918,277 2,503,618 1,468,370
Net Surplus (Deficit)(359,503)$ (235,592)$ (547,118)$ (290,548)$
Beginning Fund Balance 2,423,201 2,187,609
Ending Fund Balance 2,187,609$ 1,897,061$
Audited FY 2011 Ending Fund Balance Composition
Restricted for Fund Activities -
Committed 805,575
Assigned / Unassigned 1,382,034
Total Ending Fund Balance 2,187,609
City of Evanston
Economic Development Fund
As of September 30, 2012
14
FY 2011 FY 2011 FY 2012 FY 2012
Adopted Audited Adopted YTD
Budget Actual Budget Actual
Taxes 20,000$ 20,000$ 20,000$ -$
Transfers From Other Funds - - - -
Interest Income - - - -
Total Revenues 20,000 20,000 20,000 -
Program Expenses 50,000 - 50,000 -
Transfers to Other Funds - - - -
Total Expenditures 50,000 - 50,000 -
Net Surplus (Deficit)(30,000)$ 20,000$ (30,000)$ -$
Beginning Fund Balance 89,915 109,915
Ending Fund Balance 109,915$ 109,915$
Audited FY 2011 Ending Fund Balance Composition
Restricted for Fund Activities 109,915
Committed -
Assigned / Unassigned -
Total Ending Fund Balance 109,915
City of Evanston
Neighborhood Improvement Fund
As of September 30, 2012
15
FY 2011 FY 2011 FY 2012 FY 2012
Adopted Audited Adopted YTD
Budget Actual Budget Actual
Intergovernmental /Entitlement 560,000$ 175,068$ 500,000$ 426,951$
Interest Income - 6,030 - -
Program Income 10,000 - 10,000 20,538
Total Revenues 570,000 181,098 510,000 447,489
Home Administration/Planning 56,000 - - -
CHDO Operating 28,000 - - -
Development Activities 429,600 97,011 604,000 316,712
Transfers to General Fund 56,400 - 59,958 36,585
Total Expenditures 570,000 97,011 663,958 353,297
Net Surplus (Deficit) -$ 84,087$ (153,958)$ 94,192$
Beginning Fund Balance 2,636,531 2,720,618
Ending Fund Balance 2,720,618$ 2,814,810$
Audited FY 2011 Ending Fund Balance Composition
Restricted for Fund Activities 2,720,618
Committed -
Assigned / Unassigned -
Total Ending Fund Balance 2,720,618
City of Evanston
Home Fund
As of September 30, 2012
16
FY 2011 FY 2011 FY 2012 FY 2012
Adopted Audited Adopted YTD
Budget Actual Budget Actual
Demolition Taxes 8,330 20,000 - 30,000
Developer Contributions - 2,000 125,000 -
Rehab Repayments 20,000 - - 6,250
Interest Income 1,000 245 125 329
Miscellaneous -$ 11,357$ -$ -$
Total Revenues 29,330 33,602 125,125 36,579
Housing - Land 41,650 - - 43,190
Housing - Buildings - - - -
Down Payment Assistance 166,600 47,152 166,600 28,250
Transfers to General Fund 19,992 19,992 23,990 17,993
Miscellaneous 39,984 7,094 40,000 -
Total Expenditures 268,226 74,238 230,590 89,433
Net Surplus (Deficit)(238,896)$ (40,636)$ (105,465)$ (52,854)$
Beginning Fund Balance 2,299,153 2,258,517
Ending Fund Balance 2,258,517$ 2,205,663$
Audited FY 2011 Ending Fund Balance Composition
Restricted for Fund Activities 2,258,517
Committed -
Assigned / Unassigned -
Total Ending Fund Balance 2,258,517
City of Evanston
Affordable Housing Fund
As of September 30, 2012
17
FY 2011 FY 2011 FY 2012 FY 2012
Adopted Audited Amended YTD
Budget Actual Budget Actual
Net Property Tax Increment 4,800,000$ 3,326,012$ 5,073,000$ 4,621,336$
Interest Income 25,000 6,708 25,000 12,997
Total Revenue 4,825,000 3,332,720 5,098,000 4,634,333
Series 1997 Principal
(refunded by 1999 & 2008D) 325,000 325,000 405,000 -
Series 1997 Interest
(refunded by 1999 and 2008D) 128,200 118,200 100,650 50,325
Contributions to Other Agencies - - 800,000 -
Economic Development Projects 500,000 126,547
Capital Improvements 773,715 - 2,536,000 425,000
Contractual Services 125,000 113,212 35,000 -
Transfer to Parking Fund (Sherman) 3,419,636 3,419,636 3,876,726 2,907,545
Transfer to General Fund 325,000 325,000 325,000 243,750
Total Expenditures 5,096,551 4,301,048 8,578,376 3,753,167
Net Surplus (Deficit) (271,551)$ (968,328)$ (3,480,376)$ 881,166$
Beginning Fund Balance 9,162,676 8,194,348
Ending Fund Balance 8,194,348$ 9,075,514$
Audited FY 2011 Ending Fund Balance Composition
Restricted for Fund Activities 8,194,348
Committed -
Assigned / Unassigned -
Total Ending Fund Balance 8,194,348
City of Evanston
Washington National TIF Fund
As of September 30, 2012
18
FY 2011 FY 2011 FY 2012 FY 2012
Adopted Audited Adopted YTD
Budget Actual Budget Actual
Net Property Taxes 428,756$ 263,566$ 428,756$ 423,524$
Interest Income 100 34 - 9
Total Revenue 428,856 263,600 428,756 423,533
Series 2002C Bonds Principal 340,000 - 325,000 325,000
Series 2002C Bonds Interest 88,756 53,853 98,232 98,231
General Management Support - - - -
Total Expenditures 428,756 53,853 423,232 423,231
Net Surplus (Deficit)100$ 209,747$ 5,524$ 302$
Beginning Fund Balance 238,422 448,169
Ending Fund Balance 448,169$ 448,471$
Audited FY 2011 Ending Fund Balance Composition
Restricted for Fund Activities 448,169
Committed -
Assigned / Unassigned -
Total Ending Fund Balance 448,169
City of Evanston
Special Service Area #5
As of September 30, 2012
19
FY 2011 FY 2011 FY 2012 FY 2012
Adopted Audited Amended YTD
Budget Actual Budget Actual
Net Property Tax Increment 1,300,000$ 641,140$ 1,073,000$ 1,131,880$
Interest Income 5,000 1,826 5,000 9,692
Total Revenue 1,305,000 642,966 1,078,000 1,141,572
1994 & 1996 Bonds Principal (refunded by
1999 and 2008D bonds)570,000 570,000 605,000 -
1994 & 1996 Bonds Interest (refunded by
1999 and 2008D bonds)141,804 141,058 109,603 54,801
Surplus Distribution - - 1,300,000 1,000,000
Capital Projects - - 1,500,000 -
Other Expenses 460,000 1,200 - 2,408
Operating Transfer to General Fund 141,600 141,600 141,600 106,200
Total Expenditures 1,313,404 853,858 3,656,203 1,163,409
Net Surplus (Deficit)(8,404)$ (210,892)$ (2,578,203)$ (21,837)$
Beginning Fund Balance 5,211,765 5,000,873
Ending Fund Balance 5,000,873$ 4,979,036$
Audited FY 2011 Ending Fund Balance Composition
Restricted for Fund Activities 5,000,873
Committed -
Assigned / Unassigned -
Total Ending Fund Balance 5,000,873
City of Evanston
SW II TIF (Howard Hartrey)
As of September 30, 2012
20
FY 2011 FY 2011 FY 2012 FY 2012
Adopted Audited Adopted YTD
Budget Actual Budget Actual
Net Property Tax Increment 656,000$ 212,489$ 470,000$ 455,014$
Interest Income 500 31 500 7
Total Revenue 656,500 212,520 470,500 455,021
Economic Development Activities 700,000 700,000 - 670
Capital Improvement Projects - - 580,000 -
Operating Transfer to General Fund 24,100 24,100 28,920 21,690
Total Expenditures 724,100 724,100 608,920 22,360
Net Surplus (Deficit)(67,600)$ (511,580)$ (138,420)$ 432,661$
Beginning Fund Balance 397,497 (114,083)
Ending Fund Balance (114,083)$ 318,578$
Audited FY 2011 Ending Fund Balance Composition
Restricted for Fund Activities -
Committed -
Assigned / Unassigned (114,083)
Total Ending Fund Balance (114,083)
City of Evanston
Southwest TIF
As of September 30, 2012
21
FY 2011 FY 2011 FY 2012 FY 2012
Adopted Audited Adopted YTD
Budget Actual Budget Actual
Net Property Tax- Current 10,806,574$ 9,115,344$ 11,863,898$ 12,022,283$
Bond Proceeds/Premium/ Discounts - 152,637 - 3,572,986
Transfer from Other Funds - IMRF 871,528 727,560 755,846 566,884
Miscellaneous Revenue - - - 18,431
Interest Income 1,000 1,637 1,500 2,726
Transfer from Sewer Fund - - - 87,965
Transfer from Special Assessment Fund 317,660 317,660 317,660 238,245
Total Revenue 11,996,762 10,314,838 12,938,904 16,509,520
Series 2002 C- Principal - - 660,000 4,195,000
Series 2002 C- Interest 117,400 63,547 96,044 134,155
Series 2003 B- Principal - 2,780,000 - -
Series 2003 B- Interest 46,623 59,832 - -
Series 2004- Principal 735,000 815,000 760,000 -
Series 2004- Interest 533,250 558,450 506,250 253,125
Series 2004 B- Principal 1,210,000 1,535,000 1,630,000 -
Series 2004 B- Interest 145,494 253,200 195,640 97,819
Series 2005- Principal 525,000 545,000 730,000 -
Series 2005- Interest 721,500 740,800 700,500 350,250
Series 2006- Principal 75,000 125,000 80,000 -
Series 2006- Interest 454,620 467,220 451,582 225,791
Series 2006 B Bonds- Principal 302,063 - 35,000 -
Series 2006 B Bonds- Interest - 302,063 604,126 604,126
Series 2007 - Principal 1,115,000 1,150,000 1,150,000 -
Series 2007 - Interest 626,520 663,239 598,958 299,478
Series 2008A - Principal 195,000 195,000 195,000 -
Series 2008A - Interest 138,162 138,163 132,313 66,156
Series 2008C - Principal 343,800 361,800 351,440 -
Series 2008C - Interest 398,044 418,884 387,730 193,865
Series 2008D - Principal 520,000 520,000 425,000 -
Series 2008D - Interest 47,874 47,874 93,554 46,777
Series 2010 A - Principal DSF 240,000 240,000 300,000 -
Series 2010 A - Interest DSF 190,138 190,138 185,337 92,669
Series 2010 B - Principal DSF 695,000 580,534 613,946 -
Series 2010 B - Interest DSF 176,528 147,453 141,648 70,824
Series 2011 A - Principal DSF - - 1,081,678 -
Series 2011 A - Interest DSF - - 630,961 394,350
Series 2004- Principal SAF 80,000 - 85,000 -
Series 2004- Interest SAF 25,200 - 19,600 9,800
Series 2005- Principal SAF 20,000 - 20,000 -
Series 2005- Interest SAF 19,300 - 18,500 9,250
Series 2006- Principal SAF 50,000 - 50,000 -
Series 2006- Interest SAF 12,600 - 10,576 5,288
Series 2007 - Principal SAF 35,000 - 35,000 -
Series 2007 - Interest SAF 36,720 - 35,320 17,660
Series 2008C - Principal SAF 18,000 - 18,400 -
Series 2008C - Interest SAF 20,840 - 20,300 10,150
General Management and Support 5,000 17,529 5,000 59
Bond Issuance Costs 75,000 - 60,000 23,686
Net of Transfers - - - -
Fiscal Agent Fees 8,000 79,156 8,000 59,016
Total Expenditures 9,957,676 12,994,882 13,122,403 7,159,294
Net Surplus (Deficit)2,039,086$ (2,680,044)$ (183,499)$ 9,350,226$
Beginning Fund Balance 5,309,064 2,629,020
Ending Fund Balance 2,629,020$ 11,979,246$
Audited FY 2011 Ending Fund Balance Composition
Restricted for Fund Activities 2,629,020
Committed -
Assigned / Unassigned -
Total Ending Fund Balance 2,629,020
City of Evanston
Debt Service Fund
As of September 30, 2012
22
FY 2011 FY 2011 FY 2012 FY 2012
Adopted Audited Amended YTD
Budget Actual Budget Actual
Net Property Taxes 689,000$ 479,036$ 862,000$ 480,889$
Interest Income 400 100 400 113
Miscellaneous - 17,618 - 11,651
Total Revenue 689,400 496,754 862,400 492,653
General Management Support - - - -
Economic Dev. Projects 27,551 300,000 241,952
Capital Improvements - 900,000 16,359
Developer Agreement Payments - 668,836 -
Repayments to Econ. Dev. Fund - 48,500 48,500
Transfers to General Fund 120,400 120,400 120,400 90,300
Total Expenditures 120,400 147,951 2,037,736 397,111
Net Surplus (Deficit)569,000$ 348,803$ (1,175,336)$ 95,542$
Beginning Fund Balance 751,950 1,100,753
Ending Fund Balance 1,100,753$ 1,196,295$
Audited FY 2011 Ending Fund Balance Composition
Restricted for Fund Activities 1,100,753
Committed -
Assigned / Unassigned -
Total Ending Fund Balance 1,100,753
City of Evanston
Howard Ridge TIF
As of September 30, 2012
23
FY 2011 FY 2011 FY 2012 FY 2012
Adopted Audited Adopted YTD
Budget Actual Budget Actual
Net Property Taxes 580,000$ 352,740$ 605,000$ 262,638$
Bond Proceeds - - 2,270,000 -
Interest Income 1,000 2,285 1,000 461
Total Revenue 581,000 355,025 2,876,000 263,099
General Management Support - - - -
Economic Development Projects - - 1,200,000 -
Other Charges - - 490,000 305,052
Transfers to General Fund 50,000 50,000 60,000 45,000
Capital Projects 490,000 63,875 2,270,000 75,000
Total Expenditures 540,000 113,875 4,020,000 425,052
Net Surplus (Deficit)41,000$ 241,150$ (1,144,000)$ (161,953)$
Beginning Fund Balance 1,254,443 1,495,593
Ending Fund Balance 1,495,593$ 1,333,640$
Audited FY 2011 Ending Fund Balance Composition
Restricted for Fund Activities 1,495,593
Committed -
Assigned / Unassigned -
Total Ending Fund Balance 1,495,593
City of Evanston
West Evanston TIF
As of September 30, 2012
24
FY 2011 FY 2011 FY 2012 FY 2012
Adopted Audited Amended YTD
Budget Actual Budget Actual
Bond Proceeds 5,078,500$ 5,177,539$ 3,900,000$ 4,349,650$
Grants 4,231,473 216,225 3,168,000 360,609
Private Contributions 575,000 - 1,301,200 -
General Fund Allocation - - 1,250,000 450,000
Miscellaneous 149,000 547,000 - 10,154
Interest Income - 17,546 - 13,306
Total Revenue 10,033,973 5,958,310 9,619,200 5,183,719
Administration 95,680 723,428 - 44,374
Capital Outlay (includes prior year
rollovers)13,014,138 5,091,436 14,175,358 2,506,945
Interfund Transfers Out 300,000 302,130 475,000 356,250
Total Expenditures 13,409,818 6,116,994 14,650,358 2,907,569
Net Surplus (Deficit)(3,375,845)$ (158,684)$ (5,031,158)$ 2,276,150$
Beginning Fund Balance 5,905,344 5,746,660
Ending Fund Balance 5,746,660$ 8,022,810$
Audited FY 2011 Ending Fund Balance Composition
Restricted for Fund Activities -
Committed / Assigned 5,746,660
Unassigned -
Total Ending Fund Balance 5,746,660
City of Evanston
Capital Improvement Fund
As of September 30, 2012
25
FY 2011 FY 2011 FY 2012 FY 2012
Adopted Audited Adopted YTD
Budget Actual Budget Actual
Special Assessments Collected 550,000$ 235,028$ 300,000$ 195,262$
Bond Proceeds - - - -
Investment Income 25,000 7,687 10,000 4,354
Total Revenue 575,000 242,715 310,000 199,616
Transfer to Debt Service Fund 317,659 317,659 317,660 238,245
Capital Outlay 1,575,000 740,122 1,155,000 184,352
Total Expenditures 1,892,659 1,057,781 1,472,660 422,597
Net Surplus (Deficit)(1,317,659)$ (815,066)$ (1,162,660)$ (222,981)$
Beginning Fund Balance 3,759,955 2,944,889
Ending Fund Balance 2,944,889$ 2,721,908$
Audited FY 2011 Ending Fund Balance Composition
Restricted for Fund Activities -
Committed -
Assigned / Unassigned 2,944,889
Total Ending Fund Balance 2,944,889
City of Evanston
Special Assessment Fund
As of September 30, 2012
26
FY 2011 FY 2011 FY 2012 FY 2012
Adopted Audited Adopted YTD
Budget Actual Budget Actual
Parking Lots & Meters Operations 2,349,060$ 2,317,592$ 2,870,000$ 2,388,732$
Church Street Garage Operations 583,333 539,895 767,092 427,702
Maple Avenue Garage Operations 1,138,711 898,492 1,151,800 882,641
Sherman Avenue Garage Operations 1,331,134 1,162,225 1,356,275 1,114,521
Washington National TIF Interfund Transfers-In 2,820,455 3,419,636 3,876,726 3,332,545
Interest Income 34,900 7,432 15,070 10,743
Miscellaneous Revenue - 128,966 11,400 8,200
Reserve for Future Repairs (Contra Depreciation) 2,044,000 - 2,034,004 -
Total Revenue 10,301,593 8,474,238 12,082,367 8,165,084
7005 - Parking System Administration 743,677 811,324 655,747 666,298
7015 - Parking Lots and Meters 799,498 701,477 1,584,510 517,380
7025 - Church Street Self Park 674,084 360,574 608,255 292,586
7030 - Church Street Debt Payments 133,030 169,336 173,126 24,063
7035 - Church / Chicago Garage Debt Payments - (124,573) - -
7036 - Sherman Avenue Garage 5,324,706 2,617,785 5,772,432 1,257,366
7037 - Maple Avenue Garage 1,680,189 1,446,950 1,736,960 635,089
Transfer to Insurance Fund - - 503,877 377,908
Transfer to General Fund - - 644,242 483,181
Transfer to Fleet - - 21,991 16,494
Transfer to Equipment Replacement - - 30,000 22,500
7039 - Parking Debt - 3,000 - 2,484
7050- Interfund Transfers Out 803,242 803,241 - -
Capital Outlay - - 120,000 -
Capital Improvements 3,242,598 - 3,400,000 1,711,838
Total Expenditures 13,401,024 6,789,114 15,251,140 6,007,187
Net Surplus (Deficit) (3,099,431)$ 1,685,124$ (3,168,773)$ 2,157,897$
Further Operating Expense Breakdown:
7015 Parking Meter Activities 762,846 701,477 1,547,858 517,380
7015 Parking Meter Depreciation 36,652 - 36,652 -
SUBTOTAL 799,498 701,477 1,584,510 517,380
7025- Church Garage Activities 494,156 360,574 428,327 292,586
7025- Church Garage Depreciation 179,928 - 179,928 -
SUBTOTAL 674,084 360,574 608,255 292,586
7036 Sherman Garage Activities 1,199,756 (632,215) 1,194,182 1,257,366
7036 Debt Service Payments 3,250,300 3,250,000 3,703,600 -
7036 Reserve (Depreciation)874,650 - 874,650 -
SUBTOTAL 5,324,706 2,617,785 5,772,432 1,257,366
7037 Maple Garage Activities 1,013,991 1,446,950 1,070,762 635,089
7037 Debt Service Payments - - - -
7037 Reserve (Depreciation)666,198 - 666,198 -
SUBTOTAL 1,680,189 1,446,950 1,736,960 635,089
Beginning Unrestricted Fund Balance 22,046,297 15,196,441
Reclassification from Fund Balance to Capital Assets (8,534,980)
Ending Unrestricted Fund Balance 15,196,441$ 17,354,338$
City of Evanston
Parking Fund
As of September 30, 2012
27
FY 2011 FY 2011 FY 2012 FY 2012
Adopted Audited Adopted YTD
Budget Actual Budget Actual
Evanston 4,647,499$ 4,751,615$ 5,600,000$ 4,785,433$
Skokie 2,286,500 2,304,066 2,800,000 2,340,618
Northwest Commission 3,570,300 3,710,581 4,414,000 3,584,749
Cross Connection Control Fees 80,000 91,480 91,000 98,805
Investment Earnings 9,996 6,569 2,500 -
Debt Proceeds 3,340,000 - 4,800,000 4,448,704
Debt Proceeds (zero interest)- - - -
Fees and Merchandise Sales 35,000 61,526 35,000 52,100
Fees and Outside Work 66,640 94,184 80,000 137,828
Grants 350,000 580,995 262,500 262,500
Insurance Reimbursements - - 420,000 -
Phosphate Sales 49,980 43,655 60,000 38,847
Property Sales and Rentals 193,388 657,329 203,057 118,200
Misc Revenue - 73,102 - 14,739
Total Revenue 14,629,303 12,375,102 18,768,057 15,882,523
General Support 681,872 2,011,130 832,838 643,354
Pumping 2,270,869 1,978,311 2,368,467 1,636,016
Filtration 2,138,628 1,923,780 2,563,022 2,189,264
Distribution 1,260,167 988,315 1,464,106 840,380
Meter Maintenance 320,115 269,115 313,840 211,628
Other Operating Expenses 219,791 162,344 285,530 126,042
Debt Service 82,542 100,087 944,157 745,709
Debt Service - IEPA Loan 3382 - - 67,506 -
Capital Outlay 115,500 37,736 162,500 35,105
Capital Improvements 7,670,000 - 7,837,000 4,390,787
Depreciation - - - -
Interfund Transfers Out - General Fund 2,737,748 2,737,748 3,356,300 2,517,225
Interfund Transfers Out - Insurance Fund 390,410 390,410 468,492 351,370
Total Expense 17,887,642 10,598,976 20,663,758 13,686,880
Net Surplus (Deficit)(3,258,339)$ 1,776,126$ (1,895,701)$ 2,195,643$
Beginning Unrestricted Fund Balance 6,133,887 8,246,988
Reclassification to Fund Balance from Capital Assets 336,975
Ending Unrestricted Fund Balance 8,246,988$ 10,442,631$
City of Evanston
Water Fund
As of September 30, 2012
28
FY 2011 FY 2011 FY 2012 FY 2012
Adopted Audited Adopted YTD
Budget Actual Budget Actual
Operations 10,931,000$ 11,339,113$ 12,908,000$ 10,882,631$
Debt Proceeds 8,687,475 8,099,352 5,000,000 4,045,823
Debt Proceeds - 2012 IEPA Loan - - 4,000,000 -
Investment Earnings 3,332 2,094 1,000 2,501
Miscellaneous 89,586 37,488 91,236 -
Total Revenue 19,711,393 19,478,047 22,000,236 14,930,955
Sewer Operations 1,673,727 4,252,569 1,869,650 1,325,055
Other Operating Expenses 21,000 23,305 48,100 23,152
Interfund Transfers Out - General Fund 446,657 446,658 142,200 106,650
Interfund Transfers Out - Insurance Fund - - 269,988 202,491
Capital Outlay 12,000 10,973 18,000 14,885
Capital Improvement Account 687,475 24,218 4,753,000 426,161
Depreciation - - - -
Debt Service 14,215,356 2,362,727 14,242,990 7,951,937
Transfer to Debt Service - - 117,215 87,965
Total Expenses 17,056,215 7,120,450 21,461,143 10,138,296
Net Surplus (Deficit) 2,655,178$ 12,357,597$ 539,093$ 4,792,659$
Beginning Unrestricted Fund Balance (889,063) 3,513,271
Reclassification from Fund Balance to Capital Assets (7,955,263)
Ending Unrestricted Fund Balance 3,513,271$ 8,305,930$
City of Evanston
Sewer Fund
As of September 30, 2012
29
FY 2011 FY 2011 FY 2012 FY 2012
Adopted Audited Adopted YTD
Budget Actual Budget Actual
Property Tax Transfer from General Fund -$ -$ 1,245,967$ 934,475$
Solid Waste Franchise Fees 141,610 148,773 175,000 129,387
SWANCC Recycling Incentive 124,950 283,870 140,000 51,122
Recycling Service Charge 1,826,269 1,943,468 2,954,033 2,206,590
Sanitation Service Charge Penalty 16,660 34,887 30,000 32,929
Special Pickup Fees 100,000 69,897 100,000 43,628
State Recycling Grant 45,000 139,774 - 1,500
Trash Cart Sales 15,000 39,058 15,000 28,475
Yard Waste Fees 680,000 240,454 350,000 52,840
Total Revenue 2,949,489 2,900,181 5,010,000 3,480,946
Refuse Collection & Disposal 1,975,110 2,979,100 3,077,218 2,080,525
Residential Recycling Collection 960,841 814,397 1,360,393 830,009
Yard Waste Collection 1,031,334 678,395 750,250 397,766
Total Expense 3,967,285 4,471,892 5,187,861 3,308,300
Net Surplus (Deficit)(1,017,796)$ (1,571,711)$ (177,861)$ 172,646
Beginning Unrestricted Fund Balance - (1,571,711)
Ending Unrestricted Fund Balance (1,571,711)$ (1,399,065)
City of Evanston
Solid Waste
As of September 30, 2012
30
FY 2011 FY 2011 FY 2012 FY 2012
Adopted Audited Adopted YTD
Budget Actual Budget Actual
General Fund 2,877,885$ 2,877,887$ 2,457,356$ 1,843,017$
Library Fund - - 2,381 1,786
Parking Fund 24,740 24,740 21,992 16,494
Water Fund 162,518 162,518 122,751 92,063
Sewer Fund 254,482 254,484 177,729 133,297
Solid Waste Fund 396,000 395,999 298,071 223,553
Sale of Surplus Property 350,000 85,109 75,000 76,115
Damage to City Property 24,798 - 24,789 -
Miscellaneous Revenue - 302,718 20,000 31,305
Interest Income 4,165 273 4,165 409
Total Revenues 4,094,588 4,103,728 3,204,234 2,418,039
General Support 236,857 1,304,541 284,571 173,586
Major Maintenance 2,934,771 2,517,585 3,211,873 2,202,001
Transfer to Equipment Repl. Fund - - 2,222,069 1,481,379
Capital Outlay 1,933,320 35,219 - -
Total Expenditures 5,104,948 3,857,345 5,718,513 3,856,966
Net Surplus (Deficit)(1,010,360)$ 246,383$ (2,514,279)$ (1,438,927)$
Beginning Fund Balance 2,393,958 1,639,611
Reclassification from Fund Balance to Capital Assets (1,000,730)
Ending Fund Balance 1,639,611$ 200,684$
City of Evanston
Fleet Maintenance Fund
As of September 30, 2012
31
FY 2011 FY 2011 FY 2012 FY 2012
Adopted Audited Amended YTD
Budget Actual Budget Actual
General Fund -$ -$ 1,742,590$ 1,098,610$
Library Fund - - 1,700 1,275
Parking Fund - - 30,000 22,500
Water Fund - - 72,275 -
Sewer Fund - - 127,650 -
Solid Waste Fund - - 177,131 132,848
Miscellaneous Revenue - - - 10,904
Sale of Surplus Property - - 210,217 18,941
Transfer from Fleet Fund - - 2,222,069 1,481,379
Total Revenues - - 4,583,632 2,766,457
Capital Outlay - - 3,500,000 1,468,742
Capital Leases - - 50,000 31,761
Total Expenditures - - 3,550,000 1,500,503
Net Surplus (Deficit)-$ -$ 1,033,632$ 1,265,954$
Beginning Fund Balance -$ -$
Ending Fund Balance -$ 1,265,954$
City of Evanston
Equipment Replacement Fund
As of September 30, 2012
32
FY 2011 FY 2011 FY 2012 FY 2012
Adopted Audited Adopted YTD
Budget Actual Budget Actual
General Admin Contribution- General 105,624 98,582$ 121,207$ 90,905$
General Admin Contribution- E911 775 775 930 698
General Admin Contribution- CDBG 775 775 930 698
General Admin Contribution- E.D. 775 775 930 698
General Admin Contribution- Parking 14,193 14,193 17,032 12,774
General Admin Contribution- Water Fund 20,793 20,793 24,962 18,722
General Admin Contribution- Sewer Fund 11,992 11,992 14,385 10,789
Liability/Property Contribution- General 792,266 739,448 909,150 681,863
Liability/Property Contribution- E911 5,810 5,810 6,972 5,229
Liability/Property Contribution- CDBG 5,810 5,810 6,972 5,229
Liability/Property Contribution- E.D. 5,810 5,810 6,972 5,229
Liability/Property Contribution- Parking 106,442 106,442 127,731 95,798
Liability/Property Contribution- Water Fund 155,945 155,945 187,209 140,407
Liability/Property Contribution- Sewer Fund 89,942 89,942 107,887 80,915
Workers' Comp Contribution- General 1,084,816 1,013,938 1,244,860 933,645
Workers' Comp Contribution- Library Fund - - 5,898 4,424
Workers' Comp Contribution- E911 7,955 7,955 9,546 7,160
Workers' Comp Contribution- CDBG 7,955 7,955 9,546 7,160
Workers' Comp Contribution- E.D. 7,955 7,955 9,546 7,160
Workers' Comp Contribution- Parking 145,738 145,738 174,886 131,165
Workers' Comp Contribution- Water Fund 213,516 213,516 256,322 192,242
Workers' Comp Contribution- Sewer Fund 123,146 123,146 147,716 110,787
Subrogation Proceeds 83,300 77,363 83,300 80,724
Transfer from General Fund - Veolia Liability - - - 200,000
Investment Income 41,650 823 41,650 544
Workers Comp & Liability - Subtotal 3,032,983 2,855,481 3,516,536 2,824,965
Health Insurance Chargebacks- General 8,124,110 7,947,664 7,602,935 5,702,202
Health Insurance Chargebacks - Library - - 308,920 231,690
Health Insurance Chargebacks - NSP2 5,463 5,463 15,635 11,726
Health Insurance Chargebacks- E911 74,836 74,836 77,647 58,235
Health Insurance Chargebacks- CDBG 19,137 19,138 10,780 8,085
Health Insurance Chargebacks- E.D. Fund 36,576 36,576 57,886 43,414
Health Insurance Chargebacks- Parking 89,573 89,573 184,229 138,171
Health Insurance Chargebacks- Water 523,267 537,497 561,211 420,908
Health Insurance Chargebacks- Sewer 142,501 142,502 140,199 105,150
Health Insurance Chargebacks - Solid Waste 145,937 145,944 158,577 118,933
Health Insurance Chargebacks- Fleet 184,760 184,761 196,271 147,203
Retiree Health Insurance Contributions 1,695,988 1,429,614 1,903,503 1,136,956
Employee Health Insurance Contributions 1,200,000 1,244,736 1,209,056 1,050,836
One Time IPBC Distribution - - 200,000 125,000
Health & Life insurance - Subtotal 12,242,148 11,858,304 12,626,849 9,298,509
Total Revenues 15,275,131 14,713,785 16,143,385 12,123,474
City of Evanston
Insurance Fund
As of September 30, 2012
33
FY 2011 FY 2011 FY 2012 FY 2012
Adopted Audited Adopted YTD
Budget Actual Budget Actual
City of Evanston
Insurance Fund
As of September 30, 2012
General Administration & Support 251,843 241,733 354,104 295,043
Liability/Property Insurance Premiums 391,510 372,834 470,000 417,853
Liability Legal Fees 175,000 512,429 350,000 331,841
Liability Settlement Payments 300,000 250,290 400,000 182,644
Workers' Comp Insurance Premiums 120,000 81,437 114,400 108,284
Workers' Comp Legal Fees 71,000 56,692 60,000 51,247
Workers' Comp Medical Payments 900,000 781,652 850,000 384,556
Workers' Comp Settlement Payments 833,000 652,848 700,000 639,158
Workers' Comp TPA Pymts (non specific) 108,750 125,458 145,000 74,042
Workers' Comp TTD Pymts (non sworn)249,000 85,822 140,000 2,403
Workers' Comp & Liability - Subtotal 3,400,103 3,161,195 3,583,504 2,487,071
General Administration & Support - 2,556 98,878 8,138
Health Insurance Premiums 11,138,960 12,679,229 13,005,609 9,829,294
Health Insurance Opt Out Payments 64,974 58,080 78,000 37,750
Health & Life Insurance - Subtotal 11,203,934 12,739,865 13,182,487 9,875,182
Total Expenditures 14,604,037 15,901,060 16,765,991 12,362,253
Net Surplus (Deficit)671,094$ (1,187,275)$ (622,605)$ (238,779)$
Beginning Unrestricted Fund Balance (4,937,497) (6,124,772)
Ending Unrestricted Fund Balance (6,124,772)$ (6,363,551)$
34
FY 2011 FY 2011 FY 2012 FY 2012
Adopted Audited Adopted YTD
Budget Actual Budget Actual
Property Taxes 6,913,759$ 4,132,019$ 6,119,393$ 6,162,763$
Personal Property Repl Tax 235,000 235,000 282,000 182,067
Interest on Investment 625,000 835,335 600,000 544,550
Participant Contributions 750,000 742,350 900,000 648,142
Unrealized Gain - 443,976 - -
Miscellaneous - 134 - 50
Total Revenue 8,523,759 6,388,814 7,901,393 7,537,572
Administrative Expenses 170,000 245,164 154,000 186,626
Legal Fees - - 50,000 -
Retiree Pensions 3,500,000 3,794,695 4,700,000 3,568,752
Widows' Pensions 750,000 866,915 1,070,000 816,785
Disability Pensions 720,000 885,842 1,060,000 944,205
QUILDRO 18,000 61,399 75,000 57,333
Reserve for Future Payments - - - -
Total Expenditures 5,158,000 5,854,015 7,109,000 5,573,701
Net Surplus (Deficit)3,365,759$ 534,799$ 792,393$ 1,963,871$
Beg Net Assets held in Trust 54,358,822 54,893,621 54,893,621
End Net Assets held in Trust 54,893,621$ 55,686,014$ 56,857,492$
City of Evanston
Fire Pension Fund
As of September 30, 2012
35
FY 2011 FY 2011 FY 2012 FY 2012
Adopted Audited Adopted YTD
Budget Actual Budget Actual
Property Taxes 8,561,091$ 5,095,397$ 8,196,751$ 8,244,227$
Personal Property Repl Tax 270,833 270,833 325,000 209,917
Interest Income 1,420,000 2,268,478 1,600,000 1,719,923
Participant Contributions 1,153,600 1,149,735 1,385,000 1,268,008
Miscellaneous - 69 - 125
Unrealized Gain / (Loss) - (1,208,517) - -
Total Revenue 11,405,524 7,575,995 11,506,751 11,442,200
Administrative Expenses 155,000 255,788 186,000 199,679
Retiree Pensions 5,750,000 5,802,426 7,250,000 5,447,558
Widow Pensions 512,500 675,909 818,000 650,951
Disability Pensions 437,500 571,045 625,000 487,241
Separation Refunds - 128,188 - 116,538
QUILDRO 12,000 11,889 12,000 12,768
Reserve for Future Payments - - - -
Total Expenditures 6,867,000 7,445,245 8,891,000 6,914,735
Net Surplus (Deficit)4,538,524$ 130,750$ 2,615,751$ 4,527,465$
Beg Net Assets held in Trust 72,465,514 72,596,264 72,596,264
End Net Assets held in Trust 72,596,264$ 75,212,015$ 77,123,729$
City of Evanston
Police Pension Fund
As of September 30, 2012
36
January February March April May June July August September October November December
FY 2012 Unreserved Fund Balance 14,685,117$ 16,337,797$ 19,881,970$ 19,002,485$ 19,669,892$ 22,717,923$ 22,741,824$ 23,492,360$ 21,698,232$
FY 2011 Unreserved Fund Balance 15,876,431$ 13,696,626$ 15,222,768$ 20,587,218$ 19,833,681$ 17,675,102$ 15,666,386$ 13,995,827$ 13,049,413$
FY 2012 Cash Balance 8,894,526$ 8,902,327$ 13,603,167$ 13,093,141$ 12,607,881$ 12,330,661$ 12,686,783$ 13,735,774$ 11,745,631$
FY 2011 Cash Balance 10,098,061$ 10,059,185$ 8,500,193$ 12,269,387$ 11,926,354$ 10,788,858$ 10,521,181$ 6,868,731$ 3,819,631$
$-
$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 2012 vs Fiscal Year 2011
FY 2012 Unreserved Fund Balance
FY 2011 Unreserved Fund Balance
FY 2012 Cash Balance
FY 2011 Cash Balance
37