HomeMy WebLinkAbout2011.02 February Monthly Report
To: Wally Bobkiewicz, City Manager
Marty Lyons, Assistant City Manager
Cc: Joellen Earl, Administrative Services Director
Hitesh Desai, Accounting Manager
From: Louis Gergits, Interim Finance Division Manager
Subject: February 2011 Monthly Financial Report
Date: April 7, 2011
Please find attached the unaudited financial statements as of February 28, 2011, which
represents the end of the 2010-11 fiscal year. Be advised, these year-end financial
statements are preliminary, as additional expenditures and revenues may continue to
be posted and applied to FY10-11. A summary by fund for total revenues,
expenditures/expenses, fund balances, and cash balances is as follows:
YTD YTD YTD 2/28/2011 2/28/2011
2/28/2011 2/28/2011 2/28/2011 Unreserved Cash
Fund Name Fund #Revenue Expenses Net Fund Bal Balance*
General 100 87,019,401$ 86,498,556$ 520,845$ 13,696,626$ 10,059,185$
Neighborhood Stabilization 195 3,900,841 3,900,841 - - (5,903)
Motor Fuel 200 2,226,847 1,996,079 230,768 1,025,204 865,277
Emergency 911 205 873,774 1,816,739 (942,965) 1,260,834 1,235,828
SSA#4 210 377,014 378,216 (1,202) 309,096 (69,569)
CDBG 215 2,068,693 1,946,554 122,139 544,938 40,067
CDBG Loan 220 154,384 166,014 (11,630) 1,962,852 52,921
Economic Development 225 1,516,907 1,129,489 387,418 2,395,033 2,396,856
Neighborhood Improvement 235 20,000 5,397 14,603 89,915 69,915
Home 240 746,707 690,702 56,005 2,104,869 26,625
Affordable Housing 250 77,260 187,385 (110,125) 2,115,969 435,015
Washington National TIF 300 4,600,344 4,264,801 335,543 6,279,934 6,738,952
SSA#5 305 404,557 440,976 (36,419) (13,534) 11,668
SW II TIF (Howard Hartrey) 310 1,040,635 847,867 192,768 3,934,784 4,640,268
Southwest TIF 315 437,746 864,619 (426,873) 150,765 150,767
Debt Service 320 9,559,913 10,641,173 (1,081,260) (726,386) 467,344
Howard Ridge TIF 330 424,904 616,294 (191,390) 561,571 562,522
West Evanston TIF 335 444,112 338,723 105,389 1,040,509 1,040,510
Capital Improvement 415 8,405,079 8,088,845 316,234 5,758,008 6,658,881
Special Assessment 420 404,437 509,422 (104,985) 3,728,844 3,729,632
Parking 505 9,265,564 8,725,602 539,962 21,632,199 12,708,430
Water 510 13,410,725 13,139,334 271,391 8,313,500 7,204,818
Sewer 515 13,422,490 16,740,491 (3,318,001) (726,381) 3,114,127
Fleet 600 5,033,483 4,917,549 115,934 1,035,097 348,722
Insurance 605 15,888,881$ 16,434,762$ (545,881)$ (4,674,084)$ 129,098$
*This is net of any interfund receivables/payables
Memorandum
1 of 33
GENERAL FUND
Through February 28, 2011, General Fund revenues were $87,019,401 or 0.2% above
the 100% budget target. Property tax revenue was $15,096,114 or 91.2% of budget.
While the 2009 property tax levy was $16.9M, a delay in property tax disbursements by
Cook County will result in the remaining balance of this revenue being collected and
reported in FY2011. This delay in property tax disbursements, totaling approximately
$1.8M, was completely offset by the City’s sale of the Chiaravalle School property,
which accounted for $1.9M of revenue.
The City’s other major revenue sources in FY10-11 consisted of charges for services,
sales tax (regular), state income tax and home rule sales tax. Charges for services
revenue in FY10-11 was $9,985,600 or 94.9% of budget. Regular sales tax revenue in
FY10-11 was $8,766,678 or 98.4% of budget. State income tax revenue in FY10-11
was $5,806,131 or 101.6% of budget. Home rule sales tax revenue in FY10-11 was
$5,698,767 or 103.2% of budget.
The major revenue sources which did not perform near budgeted levels were the
natural gas distribution tax and interest income. Natural gas distribution tax revenue
was $1,098,213 or 69.4% of budget. The lower than expected natural gas distribution
tax revenue is explained by the relatively moderate winter (temperature not snow)
experienced in the northern Illinois area. Interest income revenue in FY10-11 was
$11,454 or 11.45% of budget. Interest income revenue was lower than expected due to
the struggling economy. The City also uses a compensating balance method to pay
banking fees and as such our fees for banking services (accounts payable and payroll
processing) reduce our investment income substantially.
General Fund expenditures through February 28, 2011 were $86,498,556 or 99.9% of
budget. As the City approached the end of FY10-11, staff carefully controlled spending
to ensure that expenditures for the twelve-month period remained below budgeted
levels. Several steps were implemented to achieve this goal, including requiring City
Manager’s Office approval of all purchases over $1,000, written justification for all
training and travel, and curtailment of all non-essential spending.
Included above are the ending balances as of February 28, 2011 for both unreserved
fund and cash balances. In November 2010, there was a $9.6M difference between the
fund and cash balances in the General Fund. Through February 28, 2011 the City’s
outstanding General Fund receivables have been reduced to approximately $3.6M as a
result of collections of State Income Tax, Sales Tax, Home Rule Sales Tax and other
items. As of February 28, 2011, the General Fund ending fund balance was $13.7M,
which represents approximately 15.9% of the City’s general operating expenditures.
Thus, the City remains above the 8.3% minimum balance per the Fund Reserve Policy.
As stated above, year-end totals for FY10-11 General Fund revenues were
$87,019,401. General Fund expenditures for FY10-11 were $86,498,556. As a result,
staff anticipates the General Fund will post a net surplus of $520,845 and an ending
2 of 33
fund balance of $13,696,626. It should be noted the $1.9M sale of the Chiaravalle
School property in April, 2010 contributed significantly to the General Fund achieving a
projected surplus for FY10-11. If this property sale was excluded, General Fund
revenues for FY10-11 would have closed at approximately $85,119,401, resulting in a
net deficit of $1,379,155. However, with the inclusion of the Chiaravalle School property
sale, General Fund revenue was 0.2% above budget. General Fund expenditures were
approximately 0.1% below budget. The table below summarizes actual FY10-11
General Fund revenues and expenditures compared with budget:
FY10-11 General Fund Budget Actual Variance Variance %
Revenues 86,873,900 87,019,401 145,501 100.2%
Expenses 86,578,760 86,498,556 (80,204) 99.9%
Net Surplus (Deficit) 295,140 520,845
OTHER FUNDS
For FY10-11, the Neighborhood Stabilization Program 2 (NSP 2) Fund performed close
to budget. The fund posted revenues and expenditures of $3,900,841, which were
97.5% of budget, resulting in a net change of $0 and a year-end fund balance of $0.
Through February 28, 2011 there is a negative cash balance in the fund of $5,903. This
negative cash balance is the result of an outstanding receivable, which was paid to the
City on March 10, 2011.
The Motor Fuel Fund revenues of $2,226,847 exceeded budget by 15.3% through
February 28, 2011. Expenditures were $1,996,079 or 76.7% of budget, resulting in a
surplus of $230,768. The year-end fund balance was $1,025,204.
The Emergency 911 (E911) Fund revenues for FY10-11 were $873,774 or 82.7% of
budget. Expenditures were $1,816,739 or 69.6% of budget, resulting in a deficit of
$942,965. The fund had a deficit of $1,556,104 budgeted in FY10-11. The year-end
fund balance for the E911 Fund was $1,260,834.
The Special Service Area (SSA) #4 Fund performed close to budget with revenues of
$377,014 at 99.7% of budget and expenditures of $378,216 at 100% of budget. The
fund shows a deficit of $1,202 and negative cash balance of $69,569 through February
28, 2011. This is the result of a large property tax refund of approximately $134,000
issued by Cook County in December 2010. The year-end fund balance was $309,096.
The Community Development Block Grant (CDBG) Fund performed close to budget.
Revenues for FY10-11 were $2,068,693 or 100.1% of budget and expenditures were
$1,946,554 or 95.2% of budget, resulting in a surplus of $122,139. The year-end fund
balance was $544,938.
The CDBG Loan Fund revenues for FY10-11 were $154,384 or 5,146.1% of budget and
expenditures were $166,014 or 221.4% of budget, resulting in a net deficit of $11,630.
3 of 33
The fund had a deficit of $72,000 budgeted in FY10-11. The year-end fund balance
was $1,962,852.
The Economic Development Fund revenues for FY10-11 were $1,516,907 or 83.9% of
budget and expenditures were $1,129,489 or 64.2% of budget, resulting in a surplus of
$387,418. The year-end fund balance was $2,395,033.
The Neighborhood Improvement Fund revenues for FY10-11 were $20,000 or 50% of
budget and expenditures were $5,397 or 10.8% of budget, resulting in a surplus of
$14,603. The year-end fund balance was $89,915.
The Home Fund revenues for FY10-11 were $746,707 or 127.9% of budget and
expenditures were $690,702 or 119.8% of budget, resulting in a surplus of $56,005.
The year-end fund balance was $2,104,869.
The Affordable Housing Fund revenues for FY10-11 were $77,260 or 42.7% of budget
and expenditures were $187,385 or 58.2% of budget, resulting in a deficit of $110,125.
The fund had a deficit budgeted for FY10-11 of $141,000. The year-end fund balance
was $2,115,969.
The Washington National TIF Fund performed close to budget in FY10-11 with
revenues of $4,600,344 or 97.3% of budget and expenditures of $4,264,801 or 97.8% of
budget, resulting in a surplus of $335,543. The year-end fund balance was $6,279,934.
The SSA #5 Fund revenues for FY10-11 were $404,557 or 93.7% of budget and
expenditures were $440,976 or 100.7% of budget, resulting in a deficit of $36,419
through February 28, 2011. This deficit is the result of the timing of tax receipts and a
$7,000 audit adjustment. The deadline for the first installment of 2011 tax payments
was extended by the county authority from March 1st to April 1st. SSA #5 also has a
negative fund balance of $13,534 through February 28, 2011. It is anticipated that tax
revenue received in April 2011 will return the fund to a positive fund balance.
The Southwest II TIF Fund (Howard-Hartrey) performed close to budget in FY10-11.
The fund posted revenues of $1,040,635 or 82.1% of budget and expenditures of
$847,867 or 103.8% of budget, resulting in a surplus of $192,768. The year-end fund
balance was $3,934,784.
The Southwest TIF Fund revenues for FY10-11 were $437,746 or 66.7% of budget and
expenditures were $864,619 or 100.1% of budget, resulting in a net deficit of $426,873.
Fund revenues were below budget due to lower than expected property tax increment
collections. The year-end fund balance was $150,765.
The Debt Service Fund revenues for FY10-11 were $9,559,913 or 88.7% of budget and
expenditures were $10,641,173 or 96.6% of budget, resulting in a deficit of $1,081,260.
Fund revenues were below budget due to lower than expected property tax receipts.
Through February 28, 2011 there was a negative fund balance of $726,386.
4 of 33
The Howard Ridge TIF Fund revenues were $424,904 or 61.6% of budget and
expenditures were $616,294 or 511.9% of budget, resulting in a net deficit of $191,390.
Fund revenues were below budget due to lower than expected property tax increment
collections. The year-end fund balance was $561,571.
The West Evanston TIF Fund revenues for FY10-11 were $444,112 or 140.8% of
budget and expenditures were $338,723 or 65.8% of budget, resulting in a surplus of
$105,389. The year-end fund balance was $1,040,509.
The Capital Improvement Fund revenues were $8,405,079 or 60.5% of budget and
expenditures were $8,088,845 or 48.6% of budget, resulting in a net surplus of
$316,234. Both revenues and expenditures for the Capital Improvement Fund were
significantly below budget in FY10-11. The year-end fund balance was $5,758,008.
The Special Assessment Fund revenues for FY10-11 were $404,437 or 70.3% of
budget and expenditures were $509,422 or 63.9% of budget, resulting in a net deficit of
$104,985. The fund had a deficit of $222,659 budgeted in FY10-11. The year-end fund
balance was $3,728,844.
The Parking Fund revenues for FY10-11 were $9,265,564 or 76.8% of budget and
expenditures were $8,725,602 or 76.8% of budget, resulting in a surplus of $539,962.
This surplus has been substantially reduced from the $3.1M surplus listed in the
November 2010 financial reports. The reduction in the Parking Fund surplus is the
result of debt service payments made in the final quarter of the fiscal year. The Parking
Fund is also scheduled for major capital improvements for the parking decks in 2011,
which will continue to decrease the surplus. Currently, there is a negative fund balance
of approximately $1.25M in the Sewer Fund. This negative fund balance in the Sewer
Fund is the result of debt service payments. To balance the Sewer Fund at year-end, a
$4M interfund loan from the Parking Fund was approved by the City Council on
February 28, 2011. This interfund loan will also allow deference of the Sewer Fund
bond issuance until spring 2011. The bond issuance for the Sewer Fund will be
combined with the debt issued for the 2011 Capital Improvement Program. By
combining the two issuances, the City will realize savings on the cost of issuing the
debt.
The Water Fund revenues for FY10-11 were $13,410,725 or 76.8% of budget and
expenditures were $13,139,334 or 65.4% of budget, resulting in a surplus of $271,391.
The FY10-11 Water Fund budget includes $3.5M in bond proceeds. However, the
Water Fund debt issuance will be postponed until FY11. There is a current surplus of
$271,391 and a fund balance of approximately $8.3M in the Water Fund. Revenues for
the fund continue to be closer to budget than the Sewer Fund as a result of water sales
to the Village of Skokie and the Northwest Water Commission.
The Sewer Fund revenues for FY10-11 were $13,422,490 or 93.9% of budget and
expenditures were $16,740,491 or 95.6% of budget, resulting in a deficit of $3,318,001.
5 of 33
6 of 33
Revenues Budget Actual
% of
Budget Budget Actual
% of
Budget Budget Actual
% of
Budget Budget Actual
% of
Budget
Property Tax 16,549,600$ 15,096,114$ 91.2%-$ -$ -$ -$ -$ -$
Sales Tax 14,434,000 14,465,445 100.2%
State Income Tax 5,717,000 5,806,131 101.6%
Utility Tax 8,484,000 7,764,533 91.5%
Real Estate Transfer Tax 1,600,000 1,790,188 111.9%
Liquor Tax 2,050,000 2,108,946 102.9%
Other Taxes 5,176,700 5,592,276 108.0%
Licenses, Permits, Fees 8,319,900 8,817,793 106.0%
Charges for Services 10,516,700 9,985,600 94.9% 6,607,000 5,873,670 88.9% 12,465,000 12,865,225 103.2% 14,284,000 13,390,107 93.7%
Intergovernmental Revenues 785,500 793,762 101.1% 3,385,900 3,385,896 100.0%
Interfund Transfers 7,336,200 7,608,746 103.7%
Other Non-Tax Revenue 5,904,300 7,189,867 121.8% 2,078,900 5,998 0.3% 4,990,781 545,500 10.9%4,000 32,383 809.6%
Total Revenues 86,873,900$ 87,019,401$ 100.2% 12,071,800$ 9,265,564$ 76.8% 17,455,781$ 13,410,725$ 76.8% 14,288,000$ 13,422,490$ 93.9%
Expenditures
Legislative 603,194$ 586,327$ 97.2%-$ -$ -$ -$ -$ -$
City Administration 1,952,348 1,874,507 96.0%
Law 1,026,853 957,834 93.3%
Administrative Services 8,770,765 9,298,274 106.0%
Community Development 3,885,366 3,894,206 100.2%
Police 21,776,503 22,382,185 102.8%
Fire 12,329,910 12,781,168 103.7%
Health 2,307,906 2,060,722 89.3%
Public Works- Operating 12,899,123 12,378,337 96.0% 11,357,117 8,725,602 76.8% 12,331,480 10,259,888 83.2% 16,807,580 16,508,978 98.2%
Public Works- Capital Outlay 7,755,581 2,879,446 37.1% 700,000 231,513 33.1%
Library 4,217,872 4,195,852 99.5%
Parks, Recreation & Comm. Services 16,808,920 16,089,144 95.7%
Total Expenditures 86,578,760$ 86,498,556$ 99.9% 11,357,117$ 8,725,602$ 76.8% 20,087,061$ 13,139,334$ 65.4% 17,507,580$ 16,740,491$ 95.6%
City of Evanston
Report of Budget-to-Actual Revenues and Expenditures
As of February 28, 2011
General Fund Parking Fund Water Fund Sewer Fund
7 of 33
2009-2010 2009-2010 2010-2011 2010-2011 2011
Budget Audited Budget YTD Budget
Adopted Actual Adopted Actual Adopted
Tax - Property 15,087,883$ 16,450,938$ 16,549,600$ 15,096,114$ 16,516,200$
Tax - State Use 1,142,000 870,430 1,095,000 1,002,193 677,877
Tax - Sales Tax (ROT)9,176,000 8,546,173 8,914,000 8,766,678 7,300,000
Tax - Sales Tax Home Rule 5,776,000 5,463,561 5,520,000 5,698,767 4,552,968
Tax - Auto Rental 35,000 35,201 35,000 36,445 29,155
Tax - Athletic Contest 575,000 567,744 650,200 646,337 550,167
Tax - State Income 7,050,000 5,912,082 5,717,000 5,806,131 4,635,565
Tax - Foreign Fire 90,000 113,738 - - 90,000
Tax - Electric Utility 2,798,900 2,650,134 2,802,000 2,763,679 2,196,333
Tax - Natural Gas Distribution 1,845,000 1,112,580 1,583,000 1,098,213 1,385,130
Tax - Natural Gas Use 858,700 778,813 869,000 719,763 709,044
Tax - Cigarette 485,000 354,340 485,000 418,495 295,284
Tax - Local Gasoline 401,000 510,739 450,000 558,024 550,378
Tax - Liquor 2,040,000 1,953,005 2,050,000 2,108,946 1,623,754
Tax - Parking 1,800,000 2,629,532 1,785,000 2,330,876 1,800,000
Tax - Personal Property Replacement 719,000 668,740 676,500 599,906 441,166
Tax - Real Estate Transfer 3,000,000 1,640,274 1,600,000 1,790,188 1,500,000
Tax - Telecommunications 3,655,400 3,314,895 3,230,000 3,182,878 2,691,667
License Fees - Vehicles 2,700,000 2,514,920 2,700,000 2,598,829 1,799,820
License Fees - Other 1,299,300 1,136,410 1,163,600 959,830 814,720
Other Fees 1,138,500 1,102,335 1,214,500 1,208,836 1,092,617
Permit Fees - Building 2,500,000 1,480,739 2,200,000 2,702,810 2,500,000
Permit Fees - Other 1,307,300 1,052,222 1,041,800 1,347,488 1,086,400
Fines and Forfeiture Revenue 4,256,500 4,150,610 4,403,500 4,136,255 3,806,864
Charges for Services Revenue 8,806,600 8,650,976 10,516,700 9,985,600 6,404,402
Other Revenue 973,217 1,464,080 1,400,800 3,042,158 1,089,183
Intergovernmental Revenue 945,600 1,129,803 785,500 793,762 802,239
Interfund Transfers In (Other Funds)8,757,300 8,822,296 7,336,200 7,608,746 6,920,549
Interest Income 450,000 17,048 100,000 11,454 12,000
Total Revenue 89,669,200 85,094,358 86,873,900 87,019,401 73,873,482
Legislative 628,000 624,356 603,194 586,327 524,395
City Administration 4,964,500 4,401,775 1,952,348 1,874,507 1,768,239
Law 698,800 685,083 1,026,853 957,834 805,711
Human Resources - - - -
Finance - - - -
Administrative Services (Note 1)7,543,500 6,796,982 8,770,765 9,298,274 8,194,402
Community and Economic Development 3,461,800 3,332,819 3,885,366 3,894,206 2,863,780
Police 20,599,400 21,772,625 21,776,503 22,382,185 20,365,416
Fire 11,877,100 12,427,966 12,329,910 12,781,168 11,221,528
Health 4,084,500 3,940,325 2,307,906 2,060,722 2,243,254
Public Works 14,265,300 12,857,585 12,899,123 12,378,337 6,626,203
Library 5,012,100 4,814,076 4,217,872 4,195,852 3,724,051
Parks, Recreation & Community Services 16,534,200 15,374,250 16,808,920 16,089,144 15,536,503
Total Expenditures 89,669,200 87,027,842 86,578,760 86,498,556 73,873,482
Net Surplus (Deficit) -$ (1,933,484)$ 295,140$ 520,845$ -$
Beginning Unreserved/Undesignated Fund Balance 14,325,341 13,175,781
Adjustment (Note 2)783,924
Ending Unreserved Fund Balance 13,175,781$ 13,696,626$
Note 1: Administrative Services is a new department in FY10/11 and
includes Human Resources, Information Technology and Finance
Note 2: Adjustment reflects reconciliation between budgetary basis and
GAAP basis
City of Evanston
General Fund
As of February 28, 2011
8 of 33
2009-2010 2009-2010 2010-2011 2010-2011
Adopted Audited Budget YTD
Budget Actual Adopted Actual
Grant Proceeds -$ -$ 4,000,000$ 3,900,841$
Investment Earnings - - - -
Total Revenue - - 4,000,000 3,900,841
Development Activities - - 4,000,000 3,900,841
Total Expenditures - - 4,000,000 3,900,841
Net Surplus (Deficit)-$ -$ -$ -$
Beginning Unreserved Fund Balance - -
Ending Unreserved Fund Balance -$ -$
City of Evanston
Neighborhood Stabilization Fund
As of February 28, 2011
9 of 33
2009-2010 2009-2010 2010-2011 2010-2011
Adopted Audited Adopted YTD
Budget Actual Budget Actual
State Allotment 2,100,000$ 1,867,683$ 1,900,000$ 2,223,125$
Investment Earnings 55,000 2,243 30,000 1,614
Miscellaneous Income - - - 2,108
Total Revenue 2,155,000 1,869,926 1,930,000 2,226,847
2008 Asbury Avenue Brick Street Project - - - -
Asbury Ave Bridge Phase II - - - -
Asbury Bridge Construction - - - -
McCormick Blvd. Construction - - -
Ridge Avenue CMAQ Interconnect Project - 204,006 - -
Sheridan Rd./ Isabella St. Project (JT with Wilmette) 130,000 111,123 130,000 -
Sheridan Road Phase I Engineering (Evanston JT)- - - -
Street Resurfacing (2006)- - - -
Street Resurfacing (2007)- - - -
Street Resurfacing (2008) - - - -
Street Resurfacing (2009)1,250,000 1,060,383 - -
Street Resurfacing (2010)- - 1,700,000 1,223,579
Traffic Signal Installation - Central/Ashland &
Central/Asbury - - -
Traffic Signal Installation - Church/Dodge - - -
Transfer to General Fund - Staff Engineering 122,500 122,496 650,000 650,004
Transfer to General Fund - Street Maintenance 650,000 650,004 122,500 122,496
Total Expenditures 2,152,500 2,148,012 2,602,500 1,996,079
Net Surplus (Deficit)2,500$ (278,086)$ (672,500)$ 230,768$
Beginning Unreserved Fund Balance 1,072,522 794,436
Ending Unreserved Fund Balance 794,436$ 1,025,204$
City of Evanston
Motor Fuel Fund
As of February 28, 2011
10 of 33
2009-2010 2009-2010 2010-2011 2010-2011
Adopted Audited Adopted YTD
Budget Actual Budget Actual
Landline Surcharge Revenue 775,000$ 625,072$ 670,000$ 618,314$
Wireless Surcharge Revenue 350,000 437,224 380,000 254,486
Interest 25,000 3,251 6,000 974
Miscellaneous Revenue - - - -
Total Revenue 1,150,000 1,065,547 1,056,000 873,774
Operating Expense 874,500 743,358 848,949 759,737
Interfund Transfers Out 126,000 126,000 143,455 143,472
Capital Replacement 243,000 160,632 1,619,700 913,530
Total Expenditures 1,243,500 1,029,990 2,612,104 1,816,739
Net Surplus (Deficit)(93,500)$ 35,557$ (1,556,104)$ (942,965)$
Beginning Unreserved Fund Balance 2,168,242 2,203,799
Ending Unreserved Fund Balance 2,203,799$ 1,260,834$
City of Evanston
E911 Fund
As of February 28, 2011
11 of 33
2009-2010 2009-2010 2010-2011 2010-2011
Adopted Audited Adopted YTD
Budget Actual Budget Actual
Property Tax Revenue 328,489$ 512,274$ 378,000$ 376,979$
Investment Income - 64 - 35
Total Revenues 328,489 512,338 378,000 377,014
Professional Fees (Evmark)328,489 512,274 378,000 378,216
Total Expenditures 328,489 512,274 378,000 378,216
Net Surplus (Deficit)-$ 64$ -$ (1,202)$
Beginning Unreserved Fund Balance 310,234 310,298
Ending Unreserved Fund Balance 310,298$ 309,096$
City of Evanston
Special Service Area #4 Fund
As of February 28, 2011
12 of 33
2009-2010 2009-2010 2010-2011 2010-2011
Adopted Audited Adopted YTD
Budget Actual Budget Actual
Intergovernmental/Entitlement 1,872,000$ 1,856,460$ 1,955,566$ 2,030,592$
Funds Reallocated from Prior Years 56,048 57,521 67,531
Program Income 124,998 115,041 27,079 37,787
Miscellaneous - 436,814 - 314
Total Revenues 2,053,046 2,465,836 2,050,176 2,068,693
CDBG Administration/Planning 330,000 728,631 344,870 215,684
Development Activities 867,046 881,205 843,063 849,510
Interfund Transfers - General Fund 856,000 856,000 856,000 881,360
Total Expenditures 2,053,046 2,465,836 2,043,933 1,946,554
Transfer In 57,700 - - -
Net Surplus (Deficit)57,700$ -$ 6,243$ 122,139$
Beginning Unreserved Fund Balance 422,799 422,799
Ending Unreserved Fund Balance 422,799$ 544,938$
City of Evanston
CDBG Fund
As of February 28, 2011
13 of 33
2009-2010 2009-2010 2010-2011 2010-2011
Adopted Audited Adopted YTD
Budget Actual Budget Actual
Intergovernmental Revenue -$ -$ -$ 153,981$
Program Income - 12,767 3,000
Interest Income - - - 403
Total Revenues - 12,767 3,000 154,384
Program Expenses - 46,801 20,000 166,014
Transfer to CDBG - - 55,000
Development Activities - - - -
Total Expenditures - 46,801 75,000 166,014
Net Surplus (Deficit)-$ (34,034)$ (72,000)$ (11,630)$
Beginning Unreserved Fund Balance 2,008,516 1,974,482
Ending Unreserved Fund Balance 1,974,482$ 1,962,852$
City of Evanston
CDBG Loan Fund
As of February 28, 2011
14 of 33
2009-2010 2009-2010 2010-2011 2010-2011
Adopted Audited Adopted YTD
Budget Actual Budget Actual
Hotel Tax 1,500,000$ 1,236,341$ 1,500,000$ 1,255,695$
Amusement Tax 300,000 298,412 300,000 260,621
Investment Income - 2,900 8,000 591
Total Revenues 1,800,000 1,537,653 1,808,000 1,516,907
Economic Development Activities 802,700 401,481 1,351,627 722,029
Tax Rebate Agreement 500,000 415,666 -
Transfers to General Fund 690,000 690,000 407,455 407,460
Total Expenditures 1,992,700 1,507,147 1,759,082 1,129,489
Net Surplus (Deficit)(192,700)$ 30,506$ 48,918$ 387,418$
Beginning Unreserved Fund Balance 1,977,110 2,007,615
Ending Unreserved Fund Balance 2,007,615$ 2,395,033$
City of Evanston
Economic Development Fund
As of February 28, 2011
15 of 33
2009-2010 2009-2010 2010-2011 2010-2011
Adopted Audited Adopted YTD
Budget Actual Budget Actual
Taxes -$ 20,000$ 40,000$ 20,000$
Transfers From Other Funds 146,678$
Interest Income - - - -
Total Revenues - 166,678 40,000 20,000
Program Expenses 41,757 50,000 5,397
Transfers to Other Funds - 141,000 - -
Total Expenditures - 182,757 50,000 5,397
Net Surplus (Deficit)-$ (16,079)$ (10,000)$ 14,603$
Beginning Unreserved Fund Balance 91,391 75,312
Ending Unreserved Fund Balance 75,312$ 89,915$
City of Evanston
Neighborhood Improvement Fund
As of February 28, 2011
16 of 33
2009-2010 2009-2010 2010-2011 2010-2011
Adopted Audited Adopted YTD
Budget Actual Budget Actual
Intergovernmental /Entitlement 510,000$ 489,613$ 575,009$ 746,707$
Miscellaneous 9,000 10,268 9,000 -
Total Revenues 519,000 499,881 584,009 746,707
Home Administration/Planning 76,500 63,120 76,500 213,342
Transfers to General Fund - - 34,300 33,003
Development Activities 442,500 1,762,348 465,700 444,357
Total Expenditures 519,000 1,825,468 576,500 690,702
Net Surplus (Deficit)-$ (1,325,587)$ 7,509$ 56,005$
Beginning Unreserved Fund Balance 3,374,451 2,048,864
Ending Unreserved Fund Balance 2,048,864$ 2,104,869$
City of Evanston
Home Fund
As of February 28, 2011
17 of 33
2009-2010 2009-2010 2010-2011 2010-2011
Adopted Audited Adopted YTD
Budget Actual Budget Actual
Interest on Investments 15,000$ 1,201$ 21,000$ 548$
Demolition Taxes 60,000 20,000 10,000 20,000
Developer Contributions 350,000 2,000 150,000 31,550
Rehab Repayments 1,500 - -
Miscellaneous 5,000 162,762 - 25,162
Total Revenues 431,500 185,963 181,000 77,260
Housing - Land 120,000 - 50,000 -
Housing - Buildings 150,000 - - -
Down Payment Assistance - 11,744 200,000 162,065
Transfer to General Fund 24,000 24,000 24,000 24,000
Miscellaneous 112,000 35,931 48,000 1,320
Total Expenditures 406,000 71,675 322,000 187,385
Net Surplus (Deficit)25,500$ 114,288$ (141,000)$ (110,125)$
Beginning Unreserved Fund Balance 2,111,806 2,226,094
Ending Unreserved Fund Balance 2,226,094$ 2,115,969$
City of Evanston
Affordable Housing Fund
As of February 28, 2011
18 of 33
2009-2010 2009-2010 2010-2011 2010-2011
Adopted Audited Adopted YTD
Budget Actual Budget Actual
Net Property Tax Increment 4,689,000$ 5,091,594$ 4,704,000$ 4,572,756$
Interest Income 200,000 34,515 25,000 27,588
Total Revenue 4,889,000 5,126,109 4,729,000 4,600,344
Series 1997 (refunded by 1999) Principal 285,000 301,000 304,002 305,000
Series 1997 (refunded by 1999) Interest 149,328 163,464 111,762 134,366
Other Operating Expense 50,000 - - 35,410
Capital Improvements - (23,926) 153,500
Contractual Services - 43,491 79,000 79,133
Paying Agent Fees on G.O. Bonds 120,000 - -
Transfer to Parking Fund (Sherman)2,600,050 3,125,294 3,385,900 3,385,896
Transfer to General Fund 151,866 151,872 325,000 324,996
Total Expenditures 3,356,244 3,761,195 4,359,164 4,264,801
Net Surplus (Deficit) 1,532,756$ 1,364,914$ 369,836$ 335,543$
Beginning Unreserved Fund Balance 4,579,477 5,944,391
Ending Unreserved Fund Balance 5,944,391$ 6,279,934$
City of Evanston
Washington National TIF Fund
As of February 28, 2011
19 of 33
2009-2010 2009-2010 2010-2011 2010-2011
Adopted Audited Adopted YTD
Budget Actual Budget Actual
Net Property Taxes 440,976$ 430,965$ 431,812$ 404,512$
Interest Income 600 64 100 45
Total Revenue 441,576 431,029 431,912 404,557
Series 1995 Bonds
Principal - - - 315,000
Interest - - - 125,976
Series 2002C Bonds Principal 305,000 315,000 325,000 -
Series 2002C Bonds Interest 128,312 125,976 113,062 -
General Management Support 500 - - -
Total Expenditures 433,812 440,976 438,062 440,976
Net Surplus (Deficit) 7,764$ (9,947)$ (6,150)$ (36,419)$
Beginning Unreserved Fund Balance 32,832 22,885
Ending Unreserved Fund Balance 22,885$ (13,534)$
City of Evanston
Special Service Area #5
As of February 28, 2011
20 of 33
2009-2010 2009-2010 2010-2011 2010-2011
Adopted Audited Adopted YTD
Budget Actual Budget Actual
Net Property Tax Increment 1,322,000$ 1,331,858$ 1,252,000$ 1,039,086$
Interest Income 165,000 5,866 15,000 1,549
Total Revenue 1,487,000 1,337,724 1,267,000 1,040,635
1994 & 1996 Bonds (refunded by 1999
bonds) Principal 505,000 527,913 533,249 535,000
1994 & 1996 Bonds (refunded by 1999
bonds) Interest 197,817 209,030 141,804 170,482
Operating Transfer to General Fund 141,588 141,588 141,600 142,385
Total Expenditures 844,405 878,531 816,653 847,867
Net Surplus (Deficit)642,595$ 459,193$ 450,347$ 192,768$
Beginning Unreserved Fund Balance 3,282,823 3,742,016
Ending Unreserved Fund Balance 3,742,016$ 3,934,784$
City of Evanston
SW II TIF (Howard Hartrey)
As of February 28, 2011
21 of 33
2009-2010 2009-2010 2010-2011 2010-2011
Adopted Audited Adopted YTD
Budget Actual Budget Actual
Net Property Tax Increment 686,000$ 686,437$ 656,000$ 437,734$
Interest Income 10,000 80 500 12
Total Revenue 696,000 686,517 656,500 437,746
Contribution to Other Agencies - - 840,000 840,000
Operating Transfer to General Fund 24,122 24,120 24,100 24,619
Total Expenditures 24,122 24,120 864,100 864,619
Net Surplus (Deficit)671,878$ 662,397$ (207,600)$ (426,873)$
Beginning Unreserved Fund Balance (84,759) 577,638
Ending Unreserved Fund Balance 577,638$ 150,765$
City of Evanston
Southwest TIF
As of February 28, 2011
22 of 33
2009-2010 2009-2010 2010-2011 2010-2011
Adopted Audited Adopted YTD
Budget Actual Budget Actual
Net Property Tax- Current 10,138,162$ 10,109,154$ 10,376,436$ 9,241,549$
Net Property Tax- Prior Year - - - -
Capitalized Interest 300,000 - 68,188 -
Bond Proceeds/Premium/ Discounts - - - -
Misc Revenue - - - -
Interest Income 200,000 2,566 10,000 700
Transfer from Special Assessment Fund 311,606 311,604 317,659 317,664
Total Revenue 10,949,768 10,423,324 10,772,283 9,559,913
Series 1997-Principal - - - -
Series 1997-Interest - - - -
Series 1998- Principal - - - -
Series 1998- Interest - - - -
Series 1999- Principal - - - 550,000
Series 1999- Interest - - - 31,376
Series 2000 - Principal - - - 195,000
Series 2000 - Interest - - - 144,013
Series 2000 D- Principal - - - -
Series 2000 D- Interest - - - -
Series 2002 C- Principal 695,000 1,000,000 675,000 685,000
Series 2002 C- Interest 206,488 334,800 171,737 221,812
Series 2003 - Principal 580,000 575,450 - -
Series 2003 - Interest 4,550 - - -
Series 2003 B- Principal 330,000 330,000 365,000 365,000
Series 2003 B- Interest - 114,873 104,560 104,560
Series 2004- Principal - 150,000 710,000 785,000
Series 2004- Interest 594,725 594,726 559,400 589,850
Series 2004 B- Principal 1,415,000 1,120,000 1,150,000 1,465,000
Series 2004 B- Interest 357,788 214,881 185,824 248,811
Series 2005- Principal 585,000 570,000 510,000 525,000
Series 2005- Interest 781,875 761,450 741,500 761,400
Series 2006- Principal 120,000 120,000 75,000 125,000
Series 2006- Interest 476,898 476,898 457,583 472,158
Series 2006 B Bonds- Interest 604,126 604,126 604,126 604,126
Series 2007 - Principal 1,250,000 1,115,000 1,075,000 1,105,000
Series 2007 - Interest 790,374 685,577 654,625 692,543
Series 2008A - Principal 195,000 195,000 195,000 349,740
Series 2008A - Interest 149,863 149,863 144,012 429,376
Series 2008C - Principal 341,700 324,700 332,340 -
Series 2008C - Interest 439,626 417,755 408,014 -
Series 2008D - Principal 405,614 521,339 550,000 -
Series 2008D - Interest 72,727 31,378 -
Series 2009- Estimated Interest/Principal 300,000 - - -
Series 2010- Estimated Interest/Principal - - 800,000 107,962
Series 2004- Principal SAF - - 75,000 -
Series 2004- Interest SAF - - 30,450 -
Series 2005- Principal SAF - 15,000 15,000 -
Series 2005- Interest SAF - 20,425 19,900 -
Series 2006- Principal SAF - - 50,000 -
Series 2006- Interest SAF - - 14,575 -
Series 2007 - Principal SAF - 30,000 30,000 -
Series 2007 - Interest SAF - 39,119 37,919 -
Series 2008C - Principal SAF - 17,000 17,400 -
Series 2008C - Interest SAF - 21,872 21,362 -
General Management and Support 5,000 - - 49
Transfer out -General Fund 500,000 500,004 - -
Escrow Funding - - - -
Bond Issuance Costs - - 200,000 71,197
Fiscal Agent Fees 200,000 5,150 8,000 12,200
Total Expenditures 11,401,352 11,025,008 11,019,705 10,641,173
Net Surplus (Deficit)(451,584)$ (601,684)$ (247,422)$ (1,081,260)$
Beginning Unreserved Fund Balance 956,558 354,874
Ending Unreserved Fund Balance 354,874$ (726,386)$
City of Evanston
Debt Service Fund
As of February 28, 2011
23 of 33
2009-2010 2009-2010 2010-2011 2010-2011
Adopted Audited Adopted YTD
Budget Actual Budget Actual
Net Property Taxes 725,000$ 729,383$ 689,000$ 424,665$
Interest Income 10,000 424 500 239
Total Revenue 735,000 729,807 689,500 424,904
General Management Support 16,000 - - 495,898
Transfers to General Fund 120,395 120,396 120,400 120,396
Total Expenditures 136,395 120,396 120,400 616,294
Net Surplus (Deficit)598,605$ 609,411$ 569,100$ (191,390)$
Beginning Unreserved Fund Balance 143,550 752,961
Ending Unreserved Fund Balance 752,961$ 561,571$
City of Evanston
Howard Ridge TIF
As of February 28, 2011
24 of 33
2009-2010 2009-2010 2010-2011 2010-2011
Adopted Audited Adopted YTD
Budget Actual Budget Actual
Net Property Taxes 438,482$ 581,350$ 315,000$ 443,052$
Interest Income 5,000 979 500 1,060
Total Revenue 443,482 582,329 315,500 444,112
General Management Support 75,000 30,000 - -
Capital Projects - - 490,000 281,749
Transfers to General Fund - - 25,000 56,974
Total Expenditures 75,000 30,000 515,000 338,723
Net Surplus (Deficit)368,482$ 552,329$ (199,500)$ 105,389$
Beginning Unreserved Fund Balance 382,791 935,120
Ending Unreserved Fund Balance 935,120$ 1,040,509$
City of Evanston
West Evanston TIF
As of February 28, 2011
25 of 33
2009-2010 2009-2010 2010-2011 2010-2011
Adopted Audited Adopted YTD
Budget Actual Budget Actual
Bond Proceeds 7,821,016$ -$ 7,852,243$ 6,572,922$
Installment Loan Proceeds - - 400,000
Grants 1,778,000 260,635 5,129,385 1,783,089
Private Contributions 450,000 - 450,000
Miscellaneous - 350,639 -
Interest Income 500,000 47,597 50,000 49,068
Total Revenue 10,549,016 658,871 13,881,628 8,405,079
Capital Outlay (includes
prior year rollovers)19,875,054 8,160,902 16,331,628 7,430,724
Interfund Transfers Out 300,000 246,678 300,000 658,121
Total Expenditures 20,175,054 8,407,580 16,631,628 8,088,845
Net Surplus (Deficit)(9,626,038)$ (7,748,709)$ (2,750,000)$ 316,234$
Beginning Unreserved Fund Balance 13,190,483 5,441,774
Ending Unreserved Fund Balance 5,441,774$ 5,758,008$
City of Evanston
Capital Improvement Fund
As of February 28, 2011
26 of 33
2009-2010 2009-2010 2010-2011 2010-2011
Adopted Audited Adopted YTD
Budget Actual Budget Actual
Special Assessments Collected 700,000$ 261,397$ 550,000$ 398,432$
Bond Proceeds - - -
Investment Income 150,000 11,532 25,000 6,005
Total Revenue 850,000 272,929 575,000 404,437
Transfer to Debt Service Fund 311,606 311,604 317,659 317,664
Alley Paving Costs 1,700,000 - 480,000 190,932
General Management Support 30,000 110 - 826
Other Costs - 616,174 - -
Total Expenditures 2,041,606 927,888 797,659 509,422
Net Surplus (Deficit)(1,191,606)$ (654,959)$ (222,659)$ (104,985)$
Beginning Unreserved Fund Balance 4,488,788 3,833,829
Ending Unreserved Fund Balance 3,833,829$ 3,728,844$
City of Evanston
Special Assessment Fund
As of February 28, 2011
27 of 33
2009-2010 2009-2010 2010-2011 2010-2011
Adopted Audited Adopted YTD
Budget Actual Budget Actual
Parking Lots & Meters 3,051,500$ 2,750,568$ 2,832,000$ 2,757,467$
Church Street Garage 780,000 682,400 810,000 580,722
Maple Avenue Garage 1,392,500 1,001,896 1,367,000 1,158,851
Sherman Avenue Garage 1,922,000 1,245,712 1,598,000 1,376,630
Washington National TIF Interfund Transfers-In 14,400,050 2,600,052 3,385,900 3,385,896
Downtown II TIF Interfund Transfers-In - 12,852,947 -
Downtown TIF Revenues 9,268,183
Interest Income 255,000 26,203 34,900 5,998
Reserve for Future Repairs (Contra Depreciation) 1,297,800 - 2,044,000 -
Total Revenue 23,098,850 30,427,961 12,071,800 9,265,564
7005 - Parking System Administration 655,200 910,972 661,407 597,418
7015 - Parking Lots and Meters 999,900 904,412 971,743 770,569
7025 - Church Street Self Park 617,100 518,345 800,100 614,253
7030 - Church Street Debt Payments 838,800 1,140,686 159,700 155,124
7036 - Sherman Avenue Garage 16,319,500 2,728,918 5,878,900 4,523,838
7037 - Maple Avenue Garage 1,552,200 1,868,211 1,920,991 1,100,128
7038 - TIF Bond/Transfers - 14,201,058 - -
7050- Interfund Transfers Out 777,500 777,492 964,276 964,272
Total Expenditures 21,760,200 23,050,094 11,357,117 8,725,602
Net Surplus (Deficit) 1,338,650$ 7,377,867$ 714,683$ 539,962$
Further Operating Expense Breakdown:
7015 Parking Meter Activities 999,900 904,104 927,743 770,569
7015 Parking Meter Depreciation - - 44,000 -
SUBTOTAL 999,900 904,104 971,743 770,569
7025- Church Garage Activities 617,100 518,345 584,100 614,253
7025- Church Garage Depreciation - - 216,000 -
SUBTOTAL 617,100 518,345 800,100 614,253
7036 Sherman Garage Activities 1,583,500 1,259,669 1,425,000 2,213,838
7036 Transfer to General Fund 42,000 42,000 - -
7036 Debt Service Payments 13,644,000 13,280,463 3,403,900 2,310,000
7036 Reserve (Depreciation)1,050,000 - 1,050,000 -
SUBTOTAL 16,319,500 14,582,132 5,878,900 4,523,838
7037 Maple Garage Activities 1,304,400 1,114,101 1,186,991 1,100,128
7037 Tax Rebate Agreement - - - -
7037 Debt Service Payments - - - -
7037 Reserve (Depreciation)247,800 - 734,000 -
SUBTOTAL 1,552,200 1,114,101 1,920,991 1,100,128
Beginning Unreserved Fund Balance 13,714,370 21,092,237
Ending Unreserved Fund Balance 21,092,237$ 21,632,199$
City of Evanston
Parking Fund
As of February 28, 2011
28 of 33
2009-2010 2009-2010 2010-2011 2010-2011
Adopted Audited Adopted YTD
Budget Actual Budget Actual
Evanston 5,675,000$ 5,102,756$ 5,675,000$ 5,198,484$
Skokie 2,803,000 2,594,765 2,690,000 2,885,096
Northwest Commission 3,727,000 4,506,067 4,100,000 4,781,645
Investment Earnings 100,000 48,126 12,000 2,773
Debt Proceeds 5,806,000 - 3,500,000 -
Debt Proceeds (zero interest)- - 531,335 -
Property Sales and Rentals 169,700 173,171 184,200 182,091
Grants - 7,535 510,246 52,865
Phosphate Sales 33,500 19,993 60,000 46,140
Fees and Merchandise Sales 70,000 158,370 50,000 52,915
Fees and Outside Work 80,000 74,480 80,000 196,821
Misc Revenue 63,000 57,340 63,000 11,895
Total Revenue 18,527,200 12,742,603 17,455,781 13,410,725
General Support 755,700 785,180 788,521 646,697
Pumping 2,494,100 2,284,009 2,655,827 2,092,489
Filtration 2,387,800 2,214,043 2,492,978 2,188,522
Distribution 1,513,800 1,197,073 1,384,891 1,170,913
Meter Maintenance 349,600 337,999 356,611 301,108
Other Operating Expenses 1,036,600 938,456 239,800 104,867
Debt Service 966,600 616,555 657,560 -
Capital Outlay 6,245,000 13,815 155,000 78,350
Capital Improvements 1,756,043 7,600,581 2,801,096
Interfund Transfers Out -
Insurance Fund - - 468,492 468,492
Interfund Transfers Out -
General Fund 2,778,600 2,693,604 3,286,800 3,286,800
Total Expense 18,527,800 12,836,777 20,087,061 13,139,334
Net Surplus (Deficit)(600)$ (94,174)$ (2,631,280)$ 271,391$
Beginning Unreserved Fund Balance 8,136,283 8,042,109
Ending Unreserved Fund Balance 8,042,109$ 8,313,500$
City of Evanston
Water Fund
As of February 28, 2011
29 of 33
2009-2010 2009-2010 2010-2011 2010-2011
Adopted Audited Adopted YTD
Budget Actual Budget Actual
Operations 14,238,968$ 13,242,839$ 14,184,000$ 13,390,107$
Debt Proceeds 452,400 - -
Investment Earnings 150,000 12,691 4,000 1,619
Miscellaneous 25,000 682,962 100,000 30,764
Total Revenue 14,866,368 13,938,492 14,288,000 13,422,490
Sewer Operations 1,889,600 1,613,823 1,972,921 1,725,154
Other Operating Expenses 315,600 463,837 53,100 21,004
Interfund Transfers Out
(Excludes Fleet)- - 536,203 536,220
Capital Outlay 33,000 - 30,000
Capital Improvement Account 1,575,200 913,313 700,000 231,513
Depreciation - - -
Debt Service 14,054,700 14,091,463 14,215,356 14,226,600
Total Expenses 17,868,100 17,082,436 17,507,580 16,740,491
Net Surplus (Deficit)(3,001,732)$ (3,143,944)$ (3,219,580)$ (3,318,001)$
Beginning Unreserved Fund Balance 5,735,564 2,591,620
Ending Unreserved Fund Balance 2,591,620$ (726,381)$
City of Evanston
Sewer Fund
As of February 28, 2011
30 of 33
2009-2010 2009-2010 2010-2011 2010-2011
Adopted Audited Adopted YTD
Budget Actual Budget Actual
General Fund 4,291,000$ 3,009,527$ 4,047,800$ 4,047,726$
Parking Fund 111,800 78,412 29,700 29,700
Water Fund 331,200 232,290 195,100 195,100
Sewer Fund 258,600 181,371 305,500 305,500
Sale of Surplus Property 150,000 124,317 252,260 91,591
Damage to City Property 35,000 8,820 29,770 -
Miscellaneous Revenue - - - 362,969
Interest Income 25,000 1,068 5,000 897
Total Revenues 5,202,600 3,635,805 4,865,130 5,033,483
General Support 382,900 337,585 287,135 255,555
Major Maintenance 3,536,100 2,926,315 2,914,725 2,828,035
Capital Outlay 2,000,000 35,783 1,700,000 1,833,959
Total Expenditures 5,919,000 3,299,683 4,901,860 4,917,549
Net Surplus (Deficit)(716,400)$ 336,122$ (36,730)$ 115,934$
Beginning Unreserved Fund Balance 583,041 919,163
Ending Unreserved Fund Balance 919,163$ 1,035,097$
City of Evanston
Fleet Fund
As of February 28, 2011
31 of 33
2009-2010 2009-2010 2010-2011 2010-2011
Adopted Audited Adopted YTD
Budget Actual Budget Actual
Charges for Services - General Fund 1,825,000$ 1,824,996$ 10,102,500$ 10,438,142$
Charges for Services - Parking Fund - - 499,176 499,191
Charges for Services - Water Fund 85,000 84,996 966,092 966,056
Charges for Services - Sewer Fund - - 432,203 432,214
Charges for Services - E911 Fund - - 75,355 75,316
Charges for Services - CDBG Fund - - 40,555 40,603
Charges for Services - Economic Dev. Fund - - 44,055 44,064
Charges for Services - Fleet Fund - - 138,500 138,470
Retiree Health Insurance Contributions - - 2,036,000 1,656,915
Employee Health Insurance Contributions - - 1,304,450 1,375,277
Miscellaneous - 44,605 100,000 221,603
Investment Income 250,000 5,513 50,000 1,030
Total Revenues 2,160,000 1,960,110 15,788,886 15,888,881
Claims Payable (CAFR report adjustment)- - - -
General Administration 378,800 228,752 277,587 380,307
Liability Insurance Premiums 718,700 - 470,000 510,658
Liability Legal Fees - 548,277 425,000 479,709
Liability Settlement Payments 920,000 - 400,000 253,788
Health Insurance Premiums - 566,744 12,147,850 12,373,252
Health Insurance Opt Outs - - 78,000 71,420
Workers Comp Insurance Premiums - 293,018 90,000 103,997
Workers Comp Legal Fees - 53,500 170,000 93,435
Workers Comp Medical Payments - 1,206,100 500,000 844,442
Workers Comp Settlement Payments 700,000 1,440,852 1,000,000 1,129,738
Workers Comp TPA Pymts (Non specific)- 143,725 -
Workers Comp TTD Pymts (Non sworn)- - 300,000 194,016
Total Expenditures 2,717,500 4,480,968 15,858,437 16,434,762
Net Surplus (Deficit)(557,500)$ (2,520,858)$ (69,551)$ (545,881)$
Beginning Unreserved Fund Balance (1,607,345) (4,128,203)
Ending Unreserved Fund Balance (4,128,203)$ (4,674,084)$
City of Evanston
Insurance Fund
As of February 28, 2011
32 of 33
March April May June July August September October November December January February
FY 2010-11 Unreserved Fund Balance 19,555,771$ 21,304,315$ 20,904,068$ 19,441,793$ 18,306,613$ 15,075,781$ 13,303,394$ 12,088,788$ 11,194,720$ 17,316,964$ 15,876,431$ 13,696,626$
FY 2009-10 Unreserved Fund Balance 19,735,163$ 19,717,258$ 18,403,111$ 17,914,104$ 14,471,101$ 11,953,462$ 8,306,112$ 6,972,273$ 9,473,117$ 14,502,576$ 10,200,197$ 13,175,781$
FY 2010-11 Cash Balance 12,065,689$ 12,800,603$ 11,889,234$ 9,790,128$ 8,893,548$ 7,871,900$ 5,258,286$ 3,989,279$ 1,607,185$ 8,310,736$ 10,098,061$ 10,059,185$
FY 2009-10 Cash Balance 17,899,354$ 12,465,663$ 11,363,398$ 11,089,411$ 8,844,562$ 7,253,568$ 2,937,994$ 1,456,240$ 2,119,393$ 8,191,510$ 6,993,952$ 5,618,203$
City of Evanston General Fund
Comparison of Fund and Cash Balances
Fiscal Year 2010-11 vs Fiscal Year 2009-10
$-
$5,000,000
$10,000,000
$15,000,000
$20,000,000
$25,000,000
March
April May
June July
Augu
s
t
Septemb
e
r
Octob
e
r
Nove
m
b
e
r
December
Janu
a
r
y
February
FY 2010-11 Unreserved Fund Balance
FY 2009-10 Unreserved Fund Balance
FY 2010-11 Cash Balance
FY 2009-10 Cash Balance
33 of 33