HomeMy WebLinkAbout2011.07 July Monthly Report
To: Wally Bobkiewicz, City Manager
Marty Lyons, Assistant City Manager / Treasurer
Cc: Hitesh Desai, Accounting Manager
From: Louis Gergits, Interim Finance Division Manager
Subject: July 2011 Monthly Financial Report
Date: August 26, 2011
Please find attached the unaudited financial statements as of July 31, 2011, which
represents 50% of the 2011 fiscal year. A summary by fund for total revenues,
expenditures/expenses, fund balances, and cash balances is as follows:
YTD YTD YTD 7/31/2011 7/31/2011
7/31/2011 7/31/2011 7/31/2011 Unreserved Cash
Fund Name Fund # Revenue Expenses Net Fund Bal Balance*
General 100 36,497,447$ 34,527,687$ 1,969,760$ 15,666,386$ 10,521,181$
HPRP 190 109,283 109,283 - - -
Neighborhood Stabilization 195 1,736,415 1,736,415 - - (4,633)
Motor Fuel 200 761,871 942,108 (180,237) 844,967 664,249
Emergency 911 205 394,219 460,368 (66,149) 1,194,685 1,214,678
SSA#4 210 201,694 194,000 7,694 316,854 (71,638)
CDBG 215 185,890 459,442 (273,552) 271,386 (357,098)
CDBG Loan 220 128,575 101,394 27,181 1,990,033 83,754
Economic Development 225 749,436 652,472 96,964 2,491,996 2,508,950
Neighborhood Improvement 235 - - - 89,915 89,915
Home 240 38,249 19,470 18,779 2,123,648 38,035
Affordable Housing 250 4,155 21,600 (17,445) 2,098,524 567,570
Washington National TIF 300 2,622,481 2,001,556 620,925 6,900,859 7,359,793
SSA#5 305 235,518 53,853 181,665 168,131 203,095
SW II TIF (Howard Hartrey) 310 571,841 141,329 430,512 4,365,296 5,070,781
Southwest TIF 315 246,753 12,050 234,703 385,468 385,470
Debt Service 320 5,853,532 2,241,781 3,611,751 2,885,365 4,079,094
Howard Ridge TIF 330 205,382 69,649 135,733 697,304 697,958
West Evanston TIF 335 247,017 27,200 219,817 1,260,326 1,260,326
Capital Improvement 415 34,579 2,438,689 (2,404,110) 3,353,898 3,749,981
Special Assessment 420 60,520 129,672 (69,152) 3,659,692 3,690,801
Parking 505 4,302,420 2,338,580 1,963,840 18,662,793 14,536,784
Water 510 6,744,292 6,067,537 676,755 8,990,255 7,603,144
Sewer 515 5,711,616 6,633,218 (921,602) (1,647,983) 902,588
Solid Waste 520 1,301,615 2,064,800 (763,185) (763,185) (5,794)
Fleet 600 1,944,814 1,746,082 198,732 1,233,829 1,136,369
Insurance 605 6,872,799 7,128,744 (255,945) (4,930,029) 264,087
Total**77,762,413$ 72,318,979$ 5,443,434$ 72,310,413$ 66,189,438$
*This is net of any interfund receivables/payables
**This Summary does not include Police and Fire Pension Funds
Memorandum
1 of 33
Included above are the ending balances as of July 31, 2011 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,
future cash receipts, disbursements such as receivables (including property tax) due to
the City and accounts payable/accrued expenses.
General Fund revenues through July 31, 2011 were approximately $36,497,447 or 0.6%
below the 50% budget target. Some major General Fund revenue sources which
performed above the 50% budget target included property tax, state income tax, real
estate transfer tax and charges for services. Property tax revenue was $8,803,578 or
53.3% of budget. State income tax revenue was $2,722,856 or 58.7% of budget. Real
estate transfer tax revenue was $1,133,745 or 75% of budget. Charges for services
revenue was $3,821,577 or 63.2% of budget.
The major General Fund revenue sources which did not perform near the 50% budget
target through July 31, 2011 included building permits, vehicle licenses, local gasoline
tax, athletic contest tax and other non-tax revenues. Some of these revenue sources,
including vehicle licenses and the athletic contest tax, are not collected evenly
throughout the year. Vehicle license revenues were $199,480 or 11.1% of budget.
Athletic contest tax revenues were $154,227 or 28.0% of budget. Conversely, other
revenue sources, such as building permits and local gasoline tax, are highly dependent
on the prevailing economic environment. Building permit revenues were $603,356 or
24.1% of budget. Local gasoline tax revenue was $215,166 or 39.1% of budget. Other
non-tax revenues were $1,964,761 or 36.4% of budget. All other major General Fund
revenue sources performed near the 50% budget target through July 31, 2011.
General Fund expenditures through July 31, 2011 were $34,527,687 or 46.7% of
budget. Throughout FY 2011, staff has carefully monitored and controlled spending
with the goal of maintaining expenditures for the ten-month period below budgeted
levels. Staff will continue to review and limit spending throughout FY 2011 and will
provide regular updates to the City Council and public relative to City budget
performance.
In June, 2011, there was a difference of $7.8M between the fund and cash balances in
the General Fund. Through July, 2011, the City’s outstanding General Fund
receivables have been reduced to $5.1M as a result of collections of State Income Tax,
Sales Tax, Home Rule Sales Tax and other items. Through July 31, 2011, the General
Fund ending fund balance was approximately $15.7M.
Since this financial report is for the fifth month of the fiscal year, many of the year-to-
date tax revenues are estimated due to normal delays between the liability month (when
the tax becomes obligated to the City) and the month of collection. The following
revenues that have a typical delay in collection greater than one month are as follows:
2 of 33
Revenue Description Average Delay Time
Income tax (State distributed) 1 to 2 months
Sales tax (State distributed) 3 months
Use tax (State distributed) 3 months
Telecommunications tax (State distributed) 3 months
Please note, through July 31, 2011, there is a negative cash balance of $4,633 in the
Neighborhood Stabilization Fund. This negative cash balance is the result of a timing
issue related to the collection of an outstanding receivable due from the Federal
Government. The City collected this receivable on August 8, 2011. As a result, staff
anticipates this negative cash balance will be eliminated in future reports.
Through July 31, 2011, the negative cash balance of $71,638 in the SSA #4 Fund is the
result of a timing issue between property tax receipts and the quarterly payment to
Downtown Evanston. Staff anticipates the negative cash balance will be eliminated
when outstanding property tax receipts have been collected.
Through July 31, 2011, the negative cash balance in the CDBG Fund ($357,098) is the
result of outstanding receivables due to the City from the Federal Government. Staff
anticipates that the City will receive approximately $400,000 in reimbursements from the
Federal Government on August 29, 2011.
Through July 31, 2011, there is a negative fund balance in the Sewer Fund totaling
$1,647,983. This negative fund balance is the result of debt service payments. As part
of the proposed 2011 general obligation (G.O.) bond issuance, the City issued $8M in
debt on July 20, 2011 to cover a portion of the existing debt service in the Sewer Fund.
The bond proceeds were received by the City on August 1, 2011.
For the Solid Waste Fund, revenues through July 31, 2011 were $1,301,615 and
expenditures were $2,064,800, resulting in a deficit and negative fund balance of
$763,185 and a negative cash balance of $5,794. Staff anticipates the Solid Waste
Fund will have a deficit in FY 2011.
As of July 31, 2011, the Insurance Fund has a deficit of $255,945 and a negative fund
balance of $4,930,029. This negative fund balance is primarily due to insurance
reserves for potential claims payable. These claims/cases have not been settled, and
therefore there is no guarantee the City will actually experience this negative fund
balance as estimated. It is important to note that it is difficult to budget for many
insurance related expenses due to the highly uncertain nature of insurance.
If there are any questions on the attached report, please contact me by phone at (847)
859-7816 or by email: lgergits@cityofevanston.org.
Detailed fund summary reports can be found at the following link:
http://www.cityofevanston.org/city-budget/financial-reports/
3 of 33
4 of 33
Revenues Budget Actual
% of
Budget Budget Actual
% of
Budget Budget Actual
% of
Budget Budget Actual
% of
Budget Budget Actual
% of
Budget
Property Tax 16,516,200$ 8,803,578$ 53.3%-$ -$ -$ -$ -$ -$ -$ -$
Sales Tax 11,852,968 5,919,694 49.9%
State Income Tax 4,635,565 2,722,856 58.7%
Utility Tax 6,982,341 3,272,457 46.9%
Real Estate Transfer Tax 1,500,000 1,133,745 75.6%
Liquor Tax 1,623,754 897,772 55.3%
Other Taxes 4,433,860 2,037,253 45.9%
Licenses, Permits, Fees 7,293,557 2,297,919 31.5%
Charges for Services 6,048,402 3,821,577 63.2% 4,545,138 2,589,270 57.0% 10,504,299 5,661,672 53.9% 10,931,000 5,676,802 51.9% 2,949,489 1,301,615 44.1%
Intergovernmental Revenues 802,239 369,475 46.1% 2,820,455 1,709,818 60.6%
Interfund Transfers 6,790,549 3,256,360 48.0%
Other Non-Tax Revenue 5,394,047 1,964,761 36.4% 2,936,000 3,332 0.1% 3,205,004 1,082,620 33.8% 4,092,918 34,814 0.9%
Total Revenues 73,873,482$ 36,497,447$ 49.4% 10,301,593$ 4,302,420$ 41.8% 13,709,303$ 6,744,292$ 49.2% 15,023,918$ 5,711,616$ 38.0% 2,949,489$ 1,301,615$ 44.1%
Expenditures
Legislative 523,131$ 262,859$ 50.2%-$ -$ -$ -$ -$ -$ -$ -$
City Administration 1,750,952 569,212 32.5%
Law Department 828,120 388,138 46.9%
Administrative Services Department 8,206,488 3,128,941 38.1%
Community and Econ. Development 2,824,205 1,248,039 44.2%
Police Department 20,263,642 10,277,091 50.7%
Fire & Life Safety Services 11,192,783 5,529,944 49.4%
Health Department 2,135,313 882,360 41.3%
Public Works- Operating 6,862,268 3,036,089 44.2% 10,158,426 2,338,580 23.0% 10,102,142 4,197,401 41.5% 16,368,740 6,397,968 39.1% 3,967,285 2,064,800 52.0%
Public Works- Capital Outlay 3,242,598 - 0.0% 7,785,500 1,870,136 24.0% 687,475 235,250 34.2%
Public Library 3,708,359 1,713,660 46.2%
Parks, Recreation & Comm. Services 15,578,221 7,491,354 48.1%
Total Expenditures 73,873,482$ 34,527,687$ 46.7% 13,401,024$ 2,338,580$ 17.5% 17,887,642$ 6,067,537$ 33.9% 17,056,215$ 6,633,218$ 38.9% 3,967,285$ 2,064,800$ 52.0%
City of Evanston
Report of Budget-to-Actual Revenues and Expenditures
As of July 31, 2011
Parking Fund Water Fund Solid Waste FundSewer FundGeneral Fund
(Target is 50% of FY 2011 Budget)
5 of 33
FY 2010-2011 FY 2010-2011 FY 2011 FY 2011
Budget Unaudited Budget YTD
Adopted Actual Adopted Actual
Tax - Property 16,549,600$ 15,096,114$ 16,516,200$ 8,803,578$
Tax - State Use 1,095,000 1,002,193 677,877 428,993
Tax - Sales Tax (ROT)8,914,000 8,766,678 7,300,000 3,611,034
Tax - Sales Tax Home Rule 5,520,000 5,698,767 4,552,968 2,308,660
Tax - Auto Rental 35,000 36,445 29,155 14,493
Tax - Athletic Contest 650,200 646,337 550,000 154,227
Tax - State Income 5,717,000 5,806,131 4,635,565 2,722,856
Tax - Fire Insurance - - 90,000
Tax - Electric Utility 2,802,000 2,763,679 2,196,333 1,034,208
Tax - Natural Gas Distribution 1,583,000 1,098,213 1,385,130 597,665
Tax - Natural Gas Use 869,000 719,763 709,044 310,084
Tax - Cigarette 485,000 418,495 295,284 125,313
Tax - Local Gasoline 450,000 558,024 550,378 215,166
Tax - Liquor 2,050,000 2,108,946 1,623,754 897,772
Tax - Parking 1,785,000 2,330,876 1,800,000 906,684
Tax - Personal Property Replacement 676,500 599,906 441,166 192,377
Tax - Real Estate Transfer 1,600,000 1,790,188 1,500,000 1,133,745
Tax - Telecommunications 3,230,000 3,182,878 2,691,834 1,330,500
License Fees - Vehicles 2,700,000 2,598,829 1,799,820 199,480
License Fees - Other 1,163,600 959,830 814,720 336,271
Other Fees 1,214,500 1,208,836 1,092,617 538,524
Permit Fees - Building 2,200,000 2,702,810 2,500,000 603,356
Permit Fees - Other 1,041,800 1,347,488 1,086,400 620,288
Fines and Forfeiture Revenue 4,403,500 4,136,255 3,806,864 1,620,635
Charges for Services Revenue 10,516,700 9,985,600 6,048,402 3,821,577
Other Revenue 1,400,800 3,042,158 1,575,183 342,713
Intergovernmental Revenue 785,500 793,762 802,239 369,475
Interfund Transfers In (Other Funds)7,336,200 7,608,746 6,790,549 3,256,360
Interest Income 100,000 11,454 12,000 1,413
Total Revenue 86,873,900 87,019,401 73,873,482 36,497,447
Legislative 603,194 586,327 523,131 262,859
City Administration 1,952,348 1,874,507 1,750,952 569,212
Law Department 1,026,853 957,834 828,120 388,138
Administrative Services Department 8,770,765 9,298,274 8,206,488 3,128,941
Community and Economic Development 3,885,366 3,894,206 2,824,205 1,248,039
Police Department 21,776,503 22,382,185 20,263,642 10,277,091
Fire & Life Safety Services Department 12,329,910 12,781,168 11,192,783 5,529,944
Health Department 2,307,906 2,060,722 2,135,313 882,360
Public Works Department 12,899,123 12,378,337 6,862,268 3,036,089
Library 4,217,872 4,195,852 3,708,359 1,713,660
Parks, Recreation & Community Services 16,808,920 16,089,144 15,578,221 7,491,354
Total Expenditures 86,578,760 86,498,556 73,873,482 34,527,687
Net Surplus (Deficit) 295,140$ 520,845$ -$ 1,969,760$
Beginning Unreserved/Undesignated Fund Balance 13,175,781 13,696,626
Ending Unreserved Fund Balance 13,696,626$ 15,666,386$
City of Evanston
General Fund
As of July 31, 2011
6 of 33
FY 2010-2011 FY 2010-2011 FY 2011 FY 2011
Adopted Unaudited Budget YTD
Budget Actual Adopted Actual
Grant Proceeds -$ -$ 288,460$ 109,283$
Total Revenue - - 288,460 109,283
HPRP Administration - - 27,000 10,800
Program Activities - - 261,460 98,483
Total Expenditures - - 288,460 109,283
Net Surplus (Deficit)-$ -$ -$ -$
Beginning Unreserved Fund Balance - -
Ending Unreserved Fund Balance -$ -$
City of Evanston
Homelessness Prevention & Rapid Re-Housing Program
As of July 31, 2011
7 of 33
FY 2010-2011 FY 2010-2011 FY 2011 FY 2011
Adopted Unaudited Budget YTD
Budget Actual Adopted Actual
Grant Proceeds 4,000,000$ 3,900,841$ 6,887,345$ 1,736,415$
Program Income - - 1,500,000 -
Total Revenue 4,000,000 3,900,841 8,387,345 1,736,415
Development Activities 4,000,000 3,900,841 7,985,000 1,610,103
Administration - - 124,345 57,772
Transfer to General Fund - - 278,000 68,540
Total Expenditures 4,000,000 3,900,841 8,387,345 1,736,415
Net Surplus (Deficit)-$ -$ -$ -$
Beginning Unreserved Fund Balance - -
Ending Unreserved Fund Balance -$ -$
City of Evanston
Neighborhood Stabilization Fund
As of July 31, 2011
8 of 33
FY 2010-2011 FY 2010-2011 FY 2011 FY 2011
Adopted Unaudited Adopted YTD
Budget Actual Budget Actual
State Allotment 1,900,000$ 2,223,125$ 1,900,000$ 761,585$
Investment Earnings 30,000 1,614 2,000 286
Miscellaneous Income - 2,108 - -
Total Revenue 1,930,000 2,226,847 1,902,000 761,871
Sheridan Rd./ Isabella St. Project
(JT with Wilmette)130,000 - - -
Street Resurfacing (2009)- - - -
Street Resurfacing (2010)1,700,000 1,223,579 - -
Street Resurfacing (2011)- 1,200,000 593,362
Transfer to General Fund - Staff Engineering 122,500 650,004 110,606 55,303
Transfer to General Fund - Street Maintenance 650,000 122,496 586,886 293,443
Total Expenditures 2,602,500 1,996,079 1,897,492 942,108
Net Surplus (Deficit)(672,500)$ 230,768$ 4,508$ (180,237)$
Beginning Unreserved Fund Balance 794,436 1,025,204
Ending Unreserved Fund Balance 1,025,204$ 844,967$
City of Evanston
Motor Fuel Fund
As of July 31, 2011
9 of 33
FY 2010-2011 FY 2010-2011 FY 2011 FY 2011
Adopted Unaudited Adopted YTD
Budget Actual Budget Actual
Landline Surcharge Revenue 670,000$ 618,314$ 525,000$ 234,957$
Wireless Surcharge Revenue 380,000 254,486 340,000 159,134
Interest Income 6,000 974 750 128
Miscellaneous Revenue - - - -
Total Revenue 1,056,000 873,774 865,750 394,219
Operating Expense 848,949 759,737 778,737 345,264
Interfund Transfers Out 143,455 143,472 125,868 62,934
Capital Replacement 1,619,700 913,530 229,353 52,170
Total Expenditures 2,612,104 1,816,739 1,133,958 460,368
Net Surplus (Deficit)(1,556,104)$ (942,965)$ (268,208)$ (66,149)$
Beginning Unreserved Fund Balance 2,203,799 1,260,834
Ending Unreserved Fund Balance 1,260,834$ 1,194,685$
City of Evanston
E911 Fund
As of July 31, 2011
10 of 33
FY 2010-2011 FY 2010-2011 FY 2011 FY 2011
Adopted Unaudited Adopted YTD
Budget Actual Budget Actual
Property Tax Revenue 378,000$ 376,979$ 378,000$ 201,678$
Investment Income - 35 - 16
Total Revenues 378,000 377,014 378,000 201,694
Professional Fees (Evmark)378,000 378,216 378,000 194,000
Total Expenditures 378,000 378,216 378,000 194,000
Net Surplus (Deficit)-$ (1,202)$ -$ 7,694$
Beginning Unreserved Fund Balance 310,362 309,160
Ending Unreserved Fund Balance 309,160$ 316,854$
City of Evanston
Special Service Area #4 Fund
As of July 31, 2011
11 of 33
FY 2010-2011 FY 2010-2011 FY 2011 FY 2011
Adopted Unaudited Adopted YTD
Budget Actual Budget Actual
Intergovernmental/Entitlement 1,955,566$ 2,030,592$ 2,095,180$ 173,016$
Funds Reallocated from Prior Years 67,531 25,000 -
Program Income 27,079 37,787 20,000 12,874
Miscellaneous - 314 - -
Total Revenues 2,050,176 2,068,693 2,140,180 185,890
CDBG Administration/Planning 344,870 215,684 308,367 84,091
Development Activities 843,063 849,510 1,016,894 13,486
Transfers to General Fund 856,000 881,360 772,000 361,865
Total Expenditures 2,043,933 1,946,554 2,097,261 459,442
Transfer In - - - -
Net Surplus (Deficit)6,243$ 122,139$ 42,919$ (273,552)$
Beginning Unreserved Fund Balance 422,799 544,938
Ending Unreserved Fund Balance 544,938$ 271,386$
City of Evanston
CDBG Fund
As of July 31, 2011
12 of 33
FY 2010-2011 FY 2010-2011 FY 2011 FY 2011
Adopted Unaudited Adopted YTD
Budget Actual Budget Actual
Intergovernmental Revenue -$ 153,981$ -$ 128,463$
Program Income 3,000 - 9,000
Interest Income - 403 - 112
Total Revenues 3,000 154,384 9,000 128,575
Program Expenses 20,000 166,014 20,000 101,394
Transfer to CDBG 55,000 - -
Development Activities - - - -
Total Expenditures 75,000 166,014 20,000 101,394
Net Surplus (Deficit)(72,000)$ (11,630)$ (11,000)$ 27,181$
Beginning Unreserved Fund Balance 1,974,482 1,962,852
Ending Unreserved Fund Balance 1,962,852$ 1,990,033$
City of Evanston
CDBG Loan Fund
As of July 31, 2011
13 of 33
FY 2010-2011 FY 2010-2011 FY 2011 FY 2011
Adopted Unaudited Adopted YTD
Budget Actual Budget Actual
Hotel Tax 1,500,000$ 1,255,695$ 1,350,000$ 652,065$
Amusement Tax 300,000 260,621 300,000 97,294
Investment Income 8,000 591 8,000 77
Total Revenues 1,808,000 1,516,907 1,658,000 749,436
Economic Development Activities 1,351,627 722,029 1,640,247 463,844
Tax Rebate Agreement - - -
Transfers to General Fund 407,455 407,460 377,256 188,628
Total Expenditures 1,759,082 1,129,489 2,017,503 652,472
Net Surplus (Deficit)48,918$ 387,418$ (359,503)$ 96,964$
Beginning Unreserved Fund Balance 2,007,615 2,395,032
Ending Unreserved Fund Balance 2,395,032$ 2,491,996$
City of Evanston
Economic Development Fund
As of July 31, 2011
14 of 33
FY 2010-2011 FY 2010-2011 FY 2011 FY 2011
Adopted Unaudited Adopted YTD
Budget Actual Budget Actual
Taxes 40,000$ 20,000$ 20,000$ -$
Transfers From Other Funds -$ -$ - -
Interest Income - - - -
Total Revenues 40,000 20,000 20,000 -
Program Expenses 50,000 5,397 50,000 -
Transfers to Other Funds - - - -
Total Expenditures 50,000 5,397 50,000 -
Net Surplus (Deficit)(10,000)$ 14,603$ (30,000)$ -$
Beginning Unreserved Fund Balance 75,312 89,915
Ending Unreserved Fund Balance 89,915$ 89,915$
City of Evanston
Neighborhood Improvement Fund
As of July 31, 2011
15 of 33
FY 2010-2011 FY 2010-2011 FY 2011 FY 2011
Adopted Unaudited Adopted YTD
Budget Actual Budget Actual
Intergovernmental /Entitlement 575,009$ 746,707$ 560,000$ 38,249$
Program Income 9,000 - 10,000 -
Total Revenues 584,009 746,707 570,000 38,249
Home Administration/Planning 76,500 213,342 56,000 6,057
CHDO Operating 25,500 - 28,000
Development Activities 465,700 444,357 429,600 1,913
Transfers to General Fund 34,300 33,003 56,400 11,500
Total Expenditures 576,500 690,702 570,000 19,470
Net Surplus (Deficit)7,509$ 56,005$ -$ 18,779$
Beginning Unreserved Fund Balance 2,048,864 2,104,869
Ending Unreserved Fund Balance 2,104,869$ 2,123,648$
City of Evanston
Home Fund
As of July 31, 2011
16 of 33
FY 2010-2011 FY 2010-2011 FY 2011 FY 2011
Adopted Unaudited Adopted YTD
Budget Actual Budget Actual
Interest Income 21,000$ 548$ 1,000$ 72$
Demolition Taxes 10,000 20,000 8,330
Developer Contributions 150,000 31,550 - 2,000
Rehab Repayments - 20,000 2,083
Miscellaneous - 25,162 - -
Total Revenues 181,000 77,260 29,330 4,155
Housing - Land 50,000 - 41,650 -
Housing - Buildings - - - -
Down Payment Assistance 200,000 162,065 166,600 11,604
Transfers to General Fund 24,000 24,000 19,992 9,996
Miscellaneous 48,000 1,320 39,984 -
Total Expenditures 322,000 187,385 268,226 21,600
Net Surplus (Deficit)(141,000)$ (110,125)$ (238,896)$ (17,445)$
Beginning Unreserved Fund Balance 2,226,094 2,115,969
Ending Unreserved Fund Balance 2,115,969$ 2,098,524$
City of Evanston
Affordable Housing Fund
As of July 31, 2011
17 of 33
FY 2010-2011 FY 2010-2011 FY 2011 FY 2011
Adopted Unaudited Adopted YTD
Budget Actual Budget Actual
Net Property Tax Increment 4,704,000$ 4,572,756$ 4,800,000$ 2,619,808$
Interest Income 25,000 27,588 25,000 2,673
Total Revenue 4,729,000 4,600,344 4,825,000 2,622,481
Series 1997 Principal
(refunded by 1999 & 2008D) 304,002 305,000 325,000 -
Series 1997 Interest
(refunded by 1999 and 2008D) 111,762 134,366 128,200 59,100
Contributions to Other Agencies - - - -
Capital Improvements 153,500 - 773,715 69,054
Contractual Services 79,000 114,543 125,000 1,084
Transfer to Parking Fund (Sherman)3,385,900 3,385,896 3,419,636 1,709,818
Transfer to General Fund 325,000 324,996 325,000 162,500
Total Expenditures 4,359,164 4,264,801 5,096,551 2,001,556
Net Surplus (Deficit) 369,836$ 335,543$ (271,551)$ 620,925$
Beginning Unreserved Fund Balance 5,944,391 6,279,934
Ending Unreserved Fund Balance 6,279,934$ 6,900,859$
City of Evanston
Washington National TIF Fund
As of July 31, 2011
18 of 33
FY 2010-2011 FY 2010-2011 FY 2011 FY 2011
Adopted Unaudited Adopted YTD
Budget Actual Budget Actual
Net Property Taxes 431,812$ 404,512$ 428,756$ 235,497$
Interest Income 100 45 100 21
Total Revenue 431,912 404,557 428,856 235,518
Series 2002C Bonds Principal 325,000 315,000 340,000 -
Series 2002C Bonds Interest 113,062 125,976 88,756 53,853
General Management Support - - - -
Total Expenditures 438,062 440,976 428,756 53,853
Net Surplus (Deficit) (6,150)$ (36,419)$ 100$ 181,665$
Beginning Unreserved Fund Balance 22,885 (13,534)
Ending Unreserved Fund Balance (13,534)$ 168,131$
City of Evanston
Special Service Area #5
As of July 31, 2011
19 of 33
FY 2010-2011 FY 2010-2011 FY 2011 FY 2011
Adopted Unaudited Adopted YTD
Budget Actual Budget Actual
Net Property Tax Increment 1,252,000$ 1,039,086$ 1,300,000$ 571,497$
Interest Income 15,000 1,549 5,000 344
Total Revenue 1,267,000 1,040,635 1,305,000 571,841
1994 & 1996 Bonds Principal
(refunded by 1999 and 2008D bonds)533,249 535,000 570,000 -
1994 & 1996 Bonds Interest
(refunded by 1999 and 2008D bonds)141,804 170,482 141,804 70,529
Other Expenses - - 460,000
Operating Transfer to General Fund 141,600 142,385 141,600 70,800
Total Expenditures 816,653 847,867 1,313,404 141,329
Net Surplus (Deficit)450,347$ 192,768$ (8,404)$ 430,512$
Beginning Unreserved Fund Balance 3,742,016 3,934,784
Ending Unreserved Fund Balance 3,934,784$ 4,365,296$
City of Evanston
SW II TIF (Howard Hartrey)
As of July 31, 2011
20 of 33
FY 2010-2011 FY 2010-2011 FY 2011 FY 2011
Adopted Unaudited Adopted YTD
Budget Actual Budget Actual
Net Property Tax Increment 656,000$ 437,734$ 656,000$ 246,731$
Interest Income 500 12 500 22
Total Revenue 656,500 437,746 656,500 246,753
Contribution to Other Agencies 840,000 840,000 700,000 -
Operating Transfer to General Fund 24,100 24,619 24,100 12,050
Total Expenditures 864,100 864,619 724,100 12,050
Net Surplus (Deficit)(207,600)$ (426,873)$ (67,600)$ 234,703$
Beginning Unreserved Fund Balance 577,638 150,765
Ending Unreserved Fund Balance 150,765$ 385,468$
City of Evanston
Southwest TIF
As of July 31, 2011
21 of 33
FY 2010-2011 FY 2010-2011 FY 2011 FY 2011
Adopted Unaudited Adopted YTD
Budget Actual Budget Actual
Net Property Tax- Current 10,376,436$ 9,241,549$ 10,806,574$ 5,169,724$
Net Property Tax- Prior Year - - - 120,317
Capitalized Interest 68,188 - -
Bond Proceeds/Premium/ Discounts - - -
Transfer from Other Funds - IMRF - - 871,528 435,505
Interest Income 10,000 700 1,000 922
Transfer from Special Assessment Fund 317,659 317,664 317,660 127,064
Total Revenue 10,772,283 9,559,913 11,996,762 5,853,532
Series 1999- Principal - 550,000 - -
Series 1999- Interest - 31,376 - 23,937
Series 2000 - Principal - 195,000 - -
Series 2000 - Interest - 144,013 - 69,081
Series 2000 D- Principal - - - -
Series 2000 D- Interest - - - -
Series 2002 C- Principal 675,000 685,000 - -
Series 2002 C- Interest 171,737 221,812 117,400 63,547
Series 2003 - Principal - - - -
Series 2003 - Interest - - - 46,623
Series 2003 B- Principal 365,000 365,000 - -
Series 2003 B- Interest 104,560 104,560 46,623 -
Series 2004- Principal 710,000 785,000 735,000 -
Series 2004- Interest 559,400 589,850 533,250 279,225
Series 2004 B- Principal 1,150,000 1,465,000 1,210,000 -
Series 2004 B- Interest 185,824 248,811 145,494 126,600
Series 2005- Principal 510,000 525,000 525,000 -
Series 2005- Interest 741,500 761,400 721,500 370,400
Series 2006- Principal 75,000 125,000 75,000 -
Series 2006- Interest 457,583 472,158 454,620 233,610
Series 2006 B Bonds- Interest 604,126 604,126 302,063 302,063
Series 2007 - Principal 1,075,000 1,105,000 1,115,000 -
Series 2007 - Interest 654,625 692,543 626,520 331,620
Series 2008A - Principal 195,000 349,740 195,000 -
Series 2008A - Interest 144,012 429,376 138,162 209,442
Series 2008C - Principal 332,340 - 343,800 -
Series 2008C - Interest 408,014 - 398,044 -
Series 2008D - Principal 550,000 - 520,000 -
Series 2008D - Interest 31,378 - 47,874 -
Series 2010- Estimated Interest/Principal 800,000 107,962 - -
Series 2010 A - Principal DSF - 240,000 -
Series 2010 A - Interest DSF - 190,138 95,069
Series 2010 B - Principal DSF - 695,000 -
Series 2010 B - Interest DSF - 176,528 88,264
Series 2004- Principal SAF 75,000 - 80,000 -
Series 2004- Interest SAF 30,450 - 25,200 -
Series 2005- Principal SAF 15,000 - 20,000 -
Series 2005- Interest SAF 19,900 - 19,300 -
Series 2006- Principal SAF 50,000 - 50,000 -
Series 2006- Interest SAF 14,575 - 12,600 -
Series 2007 - Principal SAF 30,000 - 35,000 -
Series 2007 - Interest SAF 37,919 - 36,720 -
Series 2008C - Principal SAF 17,400 - 18,000 -
Series 2008C - Interest SAF 21,362 - 20,840 -
General Management and Support - 49 5,000 -
Transfer out -General Fund - - - -
Escrow Funding - - - -
Bond Issuance Costs 200,000 71,197 75,000 -
Fiscal Agent Fees 8,000 12,200 8,000 2,300
Total Expenditures 11,019,705 10,641,173 9,957,676 2,241,781
Net Surplus (Deficit)(247,422)$ (1,081,260)$ 2,039,086$ 3,611,751$
Beginning Unreserved Fund Balance 354,874 (726,386)
Ending Unreserved Fund Balance (726,386)$ 2,885,365$
City of Evanston
Debt Service Fund
As of July 31, 2011
22 of 33
FY 2010-2011 FY 2010-2011 FY 2011 FY 2011
Adopted Unaudited Adopted YTD
Budget Actual Budget Actual
Net Property Taxes 689,000$ 424,665$ 689,000$ 192,054$
Interest Income 500 239 400 51
Miscellaneous - - - 13,277
Total Revenue 689,500 424,904 689,400 205,382
General Management Support - 495,898 - 9,449
Transfers to General Fund 120,400 120,396 120,400 60,200
Total Expenditures 120,400 616,294 120,400 69,649
Net Surplus (Deficit)569,100$ (191,390)$ 569,000$ 135,733$
Beginning Unreserved Fund Balance 752,961 561,571
Ending Unreserved Fund Balance 561,571$ 697,304$
City of Evanston
Howard Ridge TIF
As of July 31, 2011
23 of 33
FY 2010-2011 FY 2010-2011 FY 2011 FY 2011
Adopted Unaudited Adopted YTD
Budget Actual Budget Actual
Net Property Taxes 315,000$ 443,052$ 580,000$ 244,874$
Interest Income 500 1,060 1,000 2,143
Total Revenue 315,500 444,112 581,000 247,017
General Management Support - - - -
Capital Projects 490,000 281,749 490,000 2,200
Transfers to General Fund 25,000 56,974 50,000 25,000
Total Expenditures 515,000 338,723 540,000 27,200
Net Surplus (Deficit)(199,500)$ 105,389$ 41,000$ 219,817$
Beginning Unreserved Fund Balance 935,120 1,040,509
Ending Unreserved Fund Balance 1,040,509$ 1,260,326$
City of Evanston
West Evanston TIF
As of July 31, 2011
24 of 33
FY 2010-2011 FY 2010-2011 FY 2011 FY 2011
Adopted Unaudited Adopted YTD
Budget Actual Budget Actual
Bond Proceeds 7,852,243$ 6,572,922$ 5,078,500$ -$
Installment Loan Proceeds 400,000 - -
Grants 5,129,385 1,783,089 4,231,473 24,731
Private Contributions 450,000 575,000
Miscellaneous - 149,000
Interest Income 50,000 49,068 - 9,848
Total Revenue 13,881,628 8,405,079 10,033,973 34,579
Administration 95,680 52,301
Capital Outlay (includes
prior year rollovers)16,331,628 7,430,724 13,014,138 2,235,323
Interfund Transfers Out 300,000 658,121 300,000 151,065
Total Expenditures 16,631,628 8,088,845 13,409,818 2,438,689
Net Surplus (Deficit)(2,750,000)$ 316,234$ (3,375,845)$ (2,404,110)$
Beginning Unreserved Fund Balance 5,441,774 5,758,008
Ending Unreserved Fund Balance 5,758,008$ 3,353,898$
City of Evanston
Capital Improvement Fund
As of July 31, 2011
25 of 33
FY 2010-2011 FY 2010-2011 FY 2011 FY 2011
Adopted Unaudited Adopted YTD
Budget Actual Budget Actual
Special Assessments Collected 550,000$ 398,432$ 550,000$ 56,087$
Bond Proceeds - -
Investment Income 25,000 6,005 25,000 4,433
Total Revenue 575,000 404,437 575,000 60,520
Transfer to Debt Service Fund 317,659 317,664 317,659 127,064
Capital Improvements 480,000 190,932 1,575,000 2,608
General Management Support - 826 -
Other Costs - - - -
Total Expenditures 797,659 509,422 1,892,659 129,672
Net Surplus (Deficit)(222,659)$ (104,985)$ (1,317,659)$ (69,152)$
Beginning Unreserved Fund Balance 3,833,829 3,728,844
Ending Unreserved Fund Balance 3,728,844$ 3,659,692$
City of Evanston
Special Assessment Fund
As of July 31, 2011
26 of 33
FY 2010-2011 FY 2010-2011 FY 2011 FY 2011
Adopted Unaudited Adopted YTD
Budget Actual Budget Actual
Parking Lots & Meters 2,832,000$ 2,757,467$ 2,349,060$ 1,238,956$
Church Street Garage 810,000 580,722 583,333 311,883
Maple Avenue Garage 1,367,000 1,158,851 1,138,711 448,944
Sherman Avenue Garage 1,598,000 1,376,630 1,331,134 589,487
Washington National TIF Interfund Transfers-In 3,385,900 3,385,896 2,820,455 1,709,818
Downtown II TIF Interfund Transfers-In - - - -
Downtown TIF Revenues - - - -
Interest Income 34,900 5,998 34,900 3,332
Reserve for Future Repairs (Contra Depreciation) 2,044,000 - 2,044,000 -
Total Revenue 12,071,800 9,265,564 10,301,593 4,302,420
7005 - Parking System Administration 661,407 597,418 743,677 248,839
7015 - Parking Lots and Meters 971,743 770,569 799,498 355,203
7025 - Church Street Self Park 800,100 614,253 674,084 151,275
7030 - Church Street Debt Payments 159,700 155,124 133,030 27,168
7036 - Sherman Avenue Garage 5,878,900 4,523,838 5,324,706 859,974
7037 - Maple Avenue Garage 1,920,991 1,100,128 1,680,189 294,500
7038 - TIF Bond/Transfers - - -
7050- Interfund Transfers Out 964,276 964,272 803,242 401,621
Capital Improvements - - 3,242,598 -
Total Expenditures 11,357,117 8,725,602 13,401,024 2,338,580
Net Surplus (Deficit)714,683$ 539,962$ (3,099,431)$ 1,963,840$
Further Operating Expense Breakdown:
7015 Parking Meter Activities 927,743 770,569 762,846 355,203
7015 Parking Meter Depreciation 44,000 - 36,652 -
SUBTOTAL 971,743 770,569 799,498 355,203
7025- Church Garage Activities 584,100 614,253 494,156 151,275
7025- Church Garage Depreciation 216,000 - 179,928 -
SUBTOTAL 800,100 614,253 674,084 151,275
7036 Sherman Garage Activities 1,425,000 2,213,838 1,199,756 859,974
7036 Transfer to General Fund - - - -
7036 Debt Service Payments 3,403,900 2,310,000 3,250,300 -
7036 Reserve (Depreciation)1,050,000 - 874,650 -
SUBTOTAL 5,878,900 4,523,838 5,324,706 859,974
7037 Maple Garage Activities 1,186,991 1,100,128 1,013,991 294,500
7037 Tax Rebate Agreement - - - -
7037 Debt Service Payments - - - -
7037 Reserve (Depreciation)734,000 - 666,198 -
SUBTOTAL 1,920,991 1,100,128 1,680,189 294,500
Beginning Unreserved Fund Balance 16,158,991 16,698,953
Ending Unreserved Fund Balance 16,698,953$ 18,662,793$
City of Evanston
Parking Fund
As of July 31, 2011
27 of 33
FY 2010-2011 FY 2010-2011 FY 2011 FY 2011
Adopted Unaudited Adopted YTD
Budget Actual Budget Actual
Evanston 5,675,000$ 5,198,484$ 4,647,499$ 2,337,396$
Skokie 2,690,000 2,885,096 2,286,500 1,276,301
Northwest Commission 4,100,000 4,781,645 3,570,300 2,047,975
Investment Earnings 12,000 2,773 9,996 369
Debt Proceeds 3,500,000 - 2,500,000 642,359
Debt Proceeds (zero interest)531,335 - - -
Fees and Merchandise Sales 50,000 52,915 35,000 35,337
Fees and Outside Work 80,000 196,821 66,640 138,539
Grants 510,246 52,865 350,000 87,500
Phosphate Sales 60,000 46,140 49,980 26,688
Property Sales and Rentals 184,200 182,091 193,388 79,841
Misc Revenue 63,000 11,895 - 71,987
Total Revenue 17,455,781 13,410,725 13,709,303 6,744,292
General Support 788,521 646,697 681,872 267,078
Pumping 2,655,827 2,092,489 2,270,869 790,094
Filtration 2,492,978 2,188,522 2,138,628 896,510
Distribution 1,384,891 1,170,913 1,260,167 499,513
Meter Maintenance 356,611 301,108 320,115 128,128
Other Operating Expenses 239,800 104,867 219,791 51,998
Debt Service 657,560 - 82,542
Capital Outlay 155,000 78,350 115,500 20,136
Capital Improvements 7,600,581 2,801,096 7,670,000 1,850,000
Interfund Transfers Out -
General Fund 3,286,800 3,286,800 2,737,748 172,049
Interfund Transfers Out -
Insurance Fund 468,492 468,492 390,410 1,392,031
Total Expense 20,087,061 13,139,334 17,887,642 6,067,537
Net Surplus (Deficit)(2,631,280)$ 271,391$ (4,178,339)$ 676,755$
Beginning Unreserved Fund Balance 8,042,109 8,313,500
Ending Unreserved Fund Balance 8,313,500$ 8,990,255$
City of Evanston
Water Fund
As of July 31, 2011
28 of 33
FY 2010-2011 FY 2010-2011 FY 2011 FY 2011
Adopted Unaudited Adopted YTD
Budget Actual Budget Actual
Operations 14,284,000$ 13,390,107$ 10,931,000$ 5,676,802$
Debt Proceeds - 4,000,000 -
Investment Earnings 4,000 1,619 3,332 460
Miscellaneous - 30,764 89,586 34,354
Total Revenue 14,288,000 13,422,490 15,023,918 5,711,616
Sewer Operations 1,972,921 1,725,154 1,673,727 657,262
Other Operating Expenses 53,100 21,004 21,000 21,000
Interfund Transfers Out
(Excludes Fleet)536,203 536,220 446,657 223,329
Capital Outlay 30,000 12,000 -
Capital Improvement Account 700,000 231,513 687,475 235,250
Depreciation - -
Debt Service 14,215,356 14,226,600 14,215,356 5,496,377
Total Expenses 17,507,580 16,740,491 17,056,215 6,633,218
Net Surplus (Deficit)(3,219,580)$ (3,318,001)$ (2,032,297)$ (921,602)$
Beginning Unreserved Fund Balance 2,591,620 (726,381)
Ending Unreserved Fund Balance (726,381)$ (1,647,983)$
City of Evanston
Sewer Fund
As of July 31, 2011
29 of 33
FY 2010-2011 FY 2010-2011 FY 2011 FY 2011
Adopted Unaudited Adopted YTD
Budget Actual Budget Actual
Solid Waste Franchise Fees -$ -$ 141,610$ 156,670
SWANCC Recycling Incentive - - 124,950 74,367
Recycling Service Charge - - 1,826,269 937,023
Sanitation Service Charge Penalty - - 16,660 13,195
Special Pickup Fees - - 100,000 24,710
State Recycling Grant - - 45,000 67
Trash Cart Sales - - 15,000 28,744
Yard Waste Fees - - 680,000 66,839
Total Revenue - - 2,949,489 1,301,615
Refuse Collection & Disposal - - 1,975,110 1,402,769
Residential Recycling Collection - - 960,841 628,082
Yard Waste Collection - - 1,031,334 33,949
Total Expense - - 3,967,285 2,064,800
Net Surplus (Deficit)-$ -$ (1,017,796)$ (763,185)
Beginning Unreserved Fund Balance - -
Ending Unreserved Fund Balance -$ (763,185)
City of Evanston
Solid Waste
As of July 31, 2011
30 of 33
FY 2010-2011 FY 2010-2011 FY 2011 FY 2011
Adopted Unaudited Adopted YTD
Budget Actual Budget Actual
General Fund 4,047,800$ 4,047,726$ 2,877,885$ 1,438,944$
Parking Fund 29,700 29,700 24,740 12,370
Water Fund 195,100 195,100 162,518 81,259
Sewer Fund 305,500 305,500 254,482 127,241
Solid Waste Fund - - 396,000 198,000
Sale of Surplus Property 252,260 91,591 350,000 59,670
Damage to City Property 29,770 - 24,798 -
Miscellaneous Revenue - 362,969 - 27,212
Interest Income 5,000 897 4,165 118
Total Revenues 4,865,130 5,033,483 4,094,588 1,944,814
General Support 287,135 255,555 236,857 104,882
Major Maintenance 2,914,725 2,828,035 2,934,771 1,213,576
Capital Outlay 1,700,000 1,833,959 1,933,320 427,624
Total Expenditures 4,901,860 4,917,549 5,104,948 1,746,082
Net Surplus (Deficit)(36,730)$ 115,934$ (1,010,360)$ 198,732$
Beginning Unreserved Fund Balance 919,163 1,035,097
Ending Unreserved Fund Balance 1,035,097$ 1,233,829$
City of Evanston
Fleet Fund
As of July 31, 2011
31 of 33
FY 2010-2011 FY 2010-2011 FY 2011 FY 2011
Adopted Unaudited Adopted YTD
Budget Actual Budget Actual
Charges for Services - General Fund 10,102,500$ 10,438,142$ 10,106,816$ 4,801,115$
Charges for Services - Parking Fund 499,176 499,191 355,946 177,973
Charges for Services - Water Fund 966,092 966,056 913,521 463,875
Charges for Services - Sewer Fund 432,203 432,214 367,581 183,791
Charges for Services - E911 Fund 75,355 75,316 89,376 44,688
Charges for Services - CDBG Fund 40,555 40,603 33,677 16,839
Charges for Services - Economic Dev. Fund 44,055 44,064 51,116 25,558
Charges for Services - Fleet Fund 138,500 138,470 184,760 92,381
Charges for Services - NSP II Fund - - 5,463 2,731
Charges for Services - Solid Waste Fund - - 145,937 72,972
Retiree Health Insurance Contributions 2,036,000 1,656,915 1,695,988 648,548
Employee Health Insurance Contributions 1,304,450 1,375,277 1,200,000 300,041
Subrogation Proceeds 100,000 221,603 83,300 42,152
Investment Income 50,000 1,030 41,650 135
Total Revenues 15,788,886 15,888,881 15,275,131 6,872,799
General Administration 277,587 380,307 250,943 119,959
Liability Insurance Premiums 470,000 510,658 391,510 449,329
Liability Legal Fees 425,000 479,709 175,000 126,494
Liability Settlement Payments 400,000 253,788 300,000 130,786
Health Insurance Premiums 12,147,850 12,373,252 11,138,960 5,259,760
Health Insurance Opt Outs 78,000 71,420 64,974 29,955
Workers Comp Insurance Premiums 90,000 103,997 120,000 -
Workers Comp Legal Fees 170,000 93,435 71,000 21,593
Workers Comp Medical Payments 500,000 844,442 900,000 490,333
Workers Comp Settlement Payments 1,000,000 1,129,738 833,000 367,805
Workers Comp TPA Pymts (Non specific)- 108,750 77,125
Workers Comp TTD Pymts (Non sworn)300,000 194,016 249,900 55,605
Total Expenditures 15,858,437 16,434,762 14,604,037 7,128,744
Net Surplus (Deficit)(69,551)$ (545,881)$ 671,094$ (255,945)$
Beginning Unreserved Fund Balance (4,128,203) (4,674,084)
Ending Unreserved Fund Balance (4,674,084)$ (4,930,029)$
City of Evanston
Insurance Fund
As of July 31, 2011
32 of 33
March April May June July August September October November December
FY 2011 Unreserved Fund Balance 15,222,768$ 20,587,218$ 15,666,386$ 18,933,072$ 15,666,386$
FY 2010-11 Unreserved Fund Balance 19,918,009$ 19,537,624$ 19,137,377$ 17,675,102$ 16,539,922$
FY 2011 Cash Balance 8,500,193$ 12,269,387$ 11,926,354$ 10,788,858$ 10,521,181$
FY 2010-11 Cash Balance 12,065,689$ 12,800,603$ 11,889,234$ 9,790,128$ 8,893,548$
$-
$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 2011 vs Fiscal Year 2010-11
FY 2011 Unreserved Fund Balance
FY 2010-11 Unreserved Fund Balance
FY 2011 Cash Balance
FY 2010-11 Cash Balance
33 of 33