HomeMy WebLinkAbout2018.05 May Monthly Report
YTD Revenues YTD Expenses YTD Net Fund Balance Cash Balance
51,158,188 46,026,440 5,131,747 18,347,846 12,226,888
519,331 362,747 156,584 801,083 801,083
345,247 243,990 101,256 90,441 90,441
514 416,667 (416,153) (414,269) 585,731
3,778,613 2,543,453 1,235,160 2,277,464 2,219,535
157,860 54,962 102,898 106,987 106,987
- 6,833 (6,833) 301,566 301,566
16,697 20,861 (4,164) (4,164) 100,649
810,803 1,024,163 (213,360) 2,160,370 1,995,782
561,003 310,511 250,492 432,488 122,439
159,977 92,500 67,477 (131,317) (131,317)
15,271 205,995 (190,724) (126,617) (126,617)
19,168 64,841 (45,673) 206,939 206,939
94 - 94 170,265 170,265
59,721 73,579 (13,859) (4,582) 692
97,403 47,904 49,499 1,526,043 1,530,459
2,989,084 2,985,935 3,149 5,265,693 5,337,863
6,383,142 2,055,360 4,327,782 4,569,563 4,645,432
336,281 878,040 (541,759) (294,381) (292,112)
49,942 18,871 31,071 463,837 472,159
26,404 - 26,404 20,395 20,395
31,310 - 31,310 92,503 92,503
117,251 - 117,251 119,458 119,458
2,776,346 3,986,276 (1,209,930) 7,548,543 8,676,446
- 527,726 (527,726) 13,135 13,135
125,870 240,533 (114,664) 2,883,036 2,879,500
5,065,177 2,567,030 2,498,146 7,208,847 7,058,016
8,004,910 5,692,946 2,311,963 8,874,758 5,277,947
5,005,645 4,288,599 717,046 4,754,801 2,870,386
2,098,425 1,776,568 321,857 (740,109) (1,228,703)
1,252,391 1,252,287 104 341,447 (431,139)
576,355 637,231 (60,876) 788,643 788,643
7,395,560 8,331,297 (935,737) (5,274,242) (2,463,846)
Grand Totals 99,933,981 86,734,146 13,199,835 62,376,473 54,037,603
605 INSURANCE FUND
520 SOLID WASTE FUND
600 FLEET SERVICES FUND
601 EQUIPMENT REPLACEMENT FUND
505 PARKING SYSTEM FUND
510 WATER FUND
515 SEWER FUND
415 CAPITAL IMPROVEMENTS FUND
416 CROWN CONSTRUCTION FUND
420 SPECIAL ASSESSMENT FUND
340 DEMPSTER-DODGE TIF FUND
345 CHICAGO-MAIN TIF
350 SPECIAL SERVICE AREA (SSA) #6
300 WASHINGTON NATIONAL TIF
330 HOWARD-RIDGE TIF FUND
335 WEST EVANSTON TIF FUND
320 DEBT SERVICE FUND
240 HOME FUND
186 LIBRARY DEBT SERVICE FUND
250 AFFORDABLE HOUSING FUND
187 LIBRARY CAPITAL IMPROVEMENT
215 CDBG FUND
220 CDBG LOAN FUND
235 NEIGHBORHOOD IMPROVEMENT
200 MOTOR FUEL TAX FUND
205 EMERGENCY TELEPHONE (E911)
210 SPECIAL SERVICE AREA (SSA) #4
180 GOOD NEIGHBOR FUND
185 LIBRARY FUND
195 NEIGHBORHOOD STABILIZATION
Fund Fund Description
100 GENERAL FUND
176 HEALTH AND HUMAN SERVICES
175 GENERAL ASSISTANCE FUND
To: Wally Bobkiewicz, City Manager
From: Hitesh Desai, CFO/City Treasurer
Ashley King, Budget & Finance Manager
Kate Lewis-Lakin, Senior Management Analyst
Subject: May 2018 Monthly Financial Report
Date: June 28, 2018
Please find attached the unaudited financial statements as of May 31, 2018. A
summary by fund for revenues, expenditures, fund and cash balances is as follows:
Memorandum
Included above are the ending balances as of May 31, 2018 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 can 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.
The fund balances included in this financial report have been updated to reflect audited
2017 actuals. These numbers are slightly different than those presented in the January-
April financial reports, as these were based on unaudited numbers.
As of May 31, 2018, the General Fund is reporting a net surplus of $5,131,747. The
fund balance in the General Fund is $18,347,846 with a cash balance of $12,226,888.
The attached supplemental charts show the General Fund Revenues at 44.5% of
budget and expenses at 40.3%. Year-end payroll accruals, as well as three payrolls in
the months of June and November, will increase personnel expenses.
Through May 31, 2018, the Good Neighbor Fund is showing a negative fund balance of
$414,269. This is because the revenue to this fund from Northwestern University is not
received until later in the year. Transfers to other funds from the Good Neighbor Fund
are made monthly to cover expenses throughout the year on designated projects.
Through May 31, 2018, the Neighborhood Stabilization Fund is showing a negative fund
balance of $4,164. This is due to the timing of grant funding revenues.
Through May 31, 2018, the SSA #4 Fund is showing a negative fund and cash balance
of $131,317. This is due to the timing of payments to the Downtown Evanston group.
Through May 31, 2018, the CDBG fund is showing a negative fund and cash balance of
$126,617. This is due to a delay in reimbursements and will be repaid with draw-downs
during June.
Through May 31, 2018, the HOME Fund is showing a negative fund balance of $4,582.
This is due to the timing of grant funding revenues.
Through May 31, 2018, the Howard-Ridge TIF Fund is showing a negative fund balance
of $294,381 and a negative cash balance of $292,112. This is due to money spent on
capital projects, which will be repaid later in the summer by proceeds from the 2018D
bond issuance.
Through May 31, 2018, the Capital Fund is showing a fund balance of $7,548,543 and a
cash balance of $8,676,446. The fund continues to spend down balances from the
2017A General Obligation Bonds that were received in October 2017.
January February March April May June July August
2017 Unreserved
Fund Balance 15,453,984$ 17,244,431$ 19,450,955$ 18,292,843$ 17,839,404$
2018 Unreserved
Fund Balance 16,512,558$ 15,306,742$ 17,933,253$ 17,384,626$ 18,479,429$
2017 Cash Balance 6,338,271$ 6,393,110$ 11,561,044$ 10,901,398$ 10,376,936$
2018 Cash Balance 8,905,448$ 8,120,225$ 12,288,418$ 11,184,339$ 12,226,888$
2017 v 2018 Fund and Cash Balance-- General Fund
$-
$5,000,000
$10,000,000
$15,000,000
$20,000,000
$25,000,000
2017 Unreserved Fund Balance
2018 Unreserved Fund Balance
2017 Cash Balance
2018 Cash Balance
2018 May YTD 2017
Budget 2018 2018 %Actual
28,849,196 163,937 15,954,204 55.3% 28,294,363
49,742,274 4,121,763 20,309,240 40.8% 46,951,377
12,397,400 1,902,237 4,633,605 37.4% 13,357,911
3,882,500 385,811 1,339,029 34.5% 3,467,694
10,077,550 1,612,094 4,407,981 43.7% 8,754,025
7,748,417 618,143 3,090,713 39.9% 11,586,943
793,100 177,591 628,158 79.2% 1,234,749
1,300,217 64,585 778,349 59.9% 1,858,106
50,100 5,729 16,908 33.7% 38,544
114,840,754 9,051,890 51,158,188 44.5% 115,543,711
CITY COUNCIL 492,806 67,552 231,300 46.9% 498,172
CITY CLERK 191,784 28,186 77,412 40.4% 251,193
CITY MANAGER'S OFFICE 7,540,597 541,754 2,816,972 37.4% 7,539,496
LAW 736,346 45,053 274,465 37.3% 772,045
ADMINISTRATIVE SERVICES 9,075,303 819,665 3,403,572 37.5% 9,314,164
COMMUNITY DEVELOPMENT 3,614,774 234,587 1,242,322 34.4% 2,592,984
POLICE 38,391,099 2,359,107 16,712,510 43.5% 39,067,047
FIRE MGMT & SUPPORT 23,934,390 1,796,300 10,926,104 45.7% 24,355,551
HEALTH 3,697,529 295,899 1,219,056 33.0% 3,071,334
PARKS, REC. AND COMMUNITY SERV. 11,955,812 928,809 3,719,959 31.1% 12,479,438
PUBLIC WORKS AGENCY 14,607,356 1,063,116 5,402,769 37.0% 13,983,314
114,237,796 8,180,028 46,026,440 40.3% 113,924,739
REVENUE TOTALS 114,840,754 9,051,890 51,158,188 44.5% 115,543,711
EXPENSE TOTALS 114,237,796 8,180,028 46,026,440 40.3% 113,924,739
602,958 871,862 5,131,747 1,618,972
REVENUE TOTALS
EXPENSE
EXPENSE TOTALS
Fund 100 - GENERAL FUND Totals
Fund 100 - GENERAL FUND Net Gain
Fund 100 - GENERAL FUND
REVENUE
May 2018 Financial Report
Through 05/31/18
Organization
Licenses, Permits and Fees
Other Taxes
Property Taxes
Interest Income
Other Revenue
Intergovernmental Revenue
Interfund Transfers
Charges for Services
Fines and Forfeitures
May YTD 2017
2018 2018 %Actuals
105 1,918 0.0% 1,900
398,638 3,202,116 48.0% 6,303,624
347,253 1,736,267 41.2% 4,120,636
- - 0.0% -
24,294 103,575 53.6% 253,523
8,267 21,302 60.7% 62,067
778,557 5,065,177 45.5% 10,741,750
145,535 651,544 35.2% 1,675,404
461,834 907,600 26.3% 3,172,070
- 143,821 5.9% 280,311
26,637 133,187 41.7% 319,648
- - 0.0% 2,561,771
- - 0.0% 4,246
53,131 53,131 1.7% 267,734
38,471 77,574 25.5% 267,436
120,035 600,174 41.7% 1,584,683
845,642 2,567,030 19.9% 10,133,302
5,065,177 45.5% 10,741,750
2,567,030 19.9% 10,133,302
(67,085) 2,498,146 608,448 Fund 505 - PARKING SYSTEM FUND (1,762,367)
Fund 505 - PARKING SYSTEM FUND
REVENUE TOTALS 11,134,126
EXPENSE TOTALS 12,896,493
Interfund Transfers 1,440,417
EXPENSE TOTALS 12,896,493
Contingencies 11,000
Debt Service 3,070,625
Miscellaneous 304,000
Insurance and Other Chargebacks 319,648
Depreciation Expense -
Salary and Benefits 1,849,028
Services and Supplies 3,451,775
Capital Outlay 2,450,000
Interest Income 35,070
REVENUE TOTALS 11,134,126
EXPENSE
Interfund Transfers 4,217,040
Intergovernmental Revenue 12,125
Other Revenue 193,316
Licenses, Permits and Fees -
Charges for Services 6,676,575
Fund 505 - PARKING SYSTEM FUND
REVENUE
May 2018 Financial Report
Through 05/31/18
2018
Classification Budget
May YTD 2017
2018 2018 %Actuals
4,370 17,392 24.8% 86,063
1,770,928 7,890,035 43.2% 17,255,947
(232) 31,548 0.1% 294,812
20,590 65,935 263.7% 35,784
1,795,656 8,004,910 17.5% 17,672,605
448,928 2,029,701 36.2% 5,958,873
431,574 1,038,950 22.3% 2,528,863
283,632 429,426 1.5% 11,408
39,041 195,205 41.7% 468,492
- - 0.0% 2,470,280
- - 0.0% -
431,617 465,369 23.7% 717,388
- - 0.0% (203,530)
306,859 1,534,295 42.6% 6,327,314
12.5% 18,279,088
1,795,656 8,004,910 17.5% 17,672,605
1,941,652 5,692,946 12.5% 18,279,088
(145,995) 2,311,963 (606,483)
1,941,652 5,692,946
EXPENSE TOTALS 45,663,506
Fund 510 - WATER FUND Totals 32,150
Fund 510 - WATER FUND Totals
REVENUE TOTALS 45,695,656
Miscellaneous 15,000
Interfund Transfers 3,602,313
EXPENSE TOTALS 45,663,506
Depreciation Expense -
Contingencies 1,000
Debt Service 1,960,760
Capital Outlay 29,346,200
Insurance and Other Chargebacks 468,492
EXPENSE
Salary and Benefits 5,614,331
Services and Supplies 4,655,410
Other Revenue 27,333,656
Interest Income 25,000
REVENUE TOTALS 45,695,656
Charges for Services 18,267,000
Fund 510 - WATER FUND
REVENUE
Licenses, Permits and Fees 70,000
May 2018 Financial Report
Through 05/31/18
2018
Classification Budget
May YTD 2017
2018 2018 %Actuals
269,240 4,993,793 39.7% 12,477,657
- - 0.0% 14,870
2,402 11,852 237.0% 16,023
271,642 5,005,645 34.1% 12,508,550
105,875 484,973 38.0% 1,313,154
12,430 28,064 1.1% 88,677
- 58,703 2.7% 7,676
22,499 112,495 41.7% 269,988
- - 0.0% 3,530,787
1,077,396 3,191,166 42.3% 1,143,643
- - 0.0% 9,265
82,640 413,199 41.7% 1,141,676
1,300,840 4,288,599 28.9% 7,504,867
271,642 5,005,645 34.1% 12,508,550
1,300,840 4,288,599 28.9% 7,504,867
717,046 5,003,683 Fund 515 - SEWER FUND Totals (119,220)
Fund 515 - SEWER FUND Totals
REVENUE TOTALS 14,698,650
EXPENSE TOTALS 14,817,870
Interfund Transfers 991,677
EXPENSE TOTALS 14,817,870
Debt Service 7,540,066
Miscellaneous 1,500
Capital Outlay 2,181,300
Insurance and Other Chargebacks 269,988
Depreciation Expense -
EXPENSE
Salary and Benefits 1,274,709
Services and Supplies 2,558,630
Other Revenue 2,104,000
Interest Income 5,000
REVENUE TOTALS 14,698,650
Fund 515 - SEWER FUND
REVENUE
Charges for Services 12,589,650
May 2018 Financial Report
Through 05/31/18
2018
Classification Budget
May YTD 2017
2018 2018 %Actuals
6,648 267,563 65.3% -
- 14,448 5.3% 199,513
290,631 1,493,400 41.1% 3,611,308
58,831 294,153 41.7% 755,967
8,048 28,861 12.1% 250,687
- - 0.0% -
364,158 2,098,425 39.9% 4,817,475
81,933 347,104 34.9% 890,220
515,316 1,285,597 36.9% 3,482,141
1,260 5,196 1.9% 24,635
665 665 3.1% 1,797
- 3,688 49.2% 3,057
26,864 134,318 41.7% 504,807
626,037 1,776,568 34.8% 4,906,657
364,158 2,098,425 39.9% 4,817,475
1,776,568 34.8% 4,906,657
321,857 (89,182)
EXPENSE TOTALS 5,109,701
Fund 520 - SOLID WASTE FUND Totals 151,660
Fund 520 - SOLID WASTE FUND Totals
REVENUE TOTALS 5,261,361
Miscellaneous 7,500
Interfund Transfers 322,362
EXPENSE TOTALS 5,109,701
Debt Service 21,797
Capital Outlay 275,750
EXPENSE
Salary and Benefits 993,616
Services and Supplies 3,488,676
Other Revenue 238,000
Interest Income -
REVENUE TOTALS 5,261,361
Charges for Services 3,632,394
Interfund Transfers 705,967
Fund 520 - SOLID WASTE FUND
REVENUE
Property Taxes 410,000
Licenses, Permits and Fees 275,000
May 2018 Financial Report
Through 05/31/18
2018
Classification Budget
May YTD 2017
2018 2018 Actuals
163,937 15,954,204 28,294,363
4,121,763 20,309,240 46,951,377
1,902,237 4,633,605 13,357,911
385,811 1,339,029 3,467,694
1,612,094 4,407,981 8,754,025
618,143 3,090,713 11,586,943
177,591 628,158 1,234,749
64,585 778,349 1,858,106
5,729 16,908 38,544
9,051,890 51,158,188 115,543,711
5,915,592 27,192,303 71,659,904
931,354 3,635,659 13,414,590
19,855 48,917 361,427
534,722 11,637,105 20,883,996
- 36,825 124,131
- 106 4,090
138,995 277,975 835,363
3,197,550 6,641,237
46,026,440 113,924,739
9,051,890 51,158,188 115,543,711
8,180,028 46,026,440 113,924,739
871,862 5,131,747 1,618,972
Starting Fund Balance 13,216,099 13,216,099
Net Change 602,958 5,131,747
Ending Fund Balance 13,819,057 18,347,846
REVENUE TOTALS 114,840,754
EXPENSE TOTALS 114,237,796
Fund 100 - GENERAL FUND Totals 602,958
EXPENSE TOTALS 114,237,796
Fund 100 - GENERAL FUND Totals
Miscellaneous 1,015,317
Interfund Transfers 7,704,802
Community Sponsored Organizations 123,886
Contingencies 208,500
Services and Supplies 12,367,791
Capital Outlay 354,000
Insurance and Other Chargebacks 22,287,563
REVENUE TOTALS 114,840,754
EXPENSE
Salary and Benefits 70,175,937
Interest Income 50,100
Interfund Transfers 7,748,417
Intergovernmental Revenue 793,100
Other Revenue 1,300,217
Licenses, Permits and Fees 12,397,400
Fines and Forfeitures 3,882,500
Charges for Services 10,077,550
Fund 100 - GENERAL FUND
REVENUE
Property Taxes 28,849,196
Other Taxes 49,742,274
May 2018 Financial Report
Through 05/31/18
2018
Classification Budget
Run by Kate LewisLakin on 06/27/2018 09:36:53 AM Page 1 of 35
May YTD 2017
2018 2018 Actuals
6,241 506,094 933,020
2,464 12,301 33,019
327 937 1,548
9,032 519,331 967,586
31,012 145,774 324,972
42,825 216,853 579,392
60 120 5,110
73,897 362,747 909,475
9,032 519,331 967,586
73,897 362,747 909,475
(64,865) 156,584 58,111
Starting Fund Balance 644,499 644,499
Net Change (312,421) 156,584
Ending Fund Balance 332,078 801,083
REVENUE TOTALS 953,500
EXPENSE TOTALS 1,265,921
Fund 175 - GENERAL ASSISTANCE FUND (312,421)
EXPENSE TOTALS 1,265,921
Fund 175 - GENERAL ASSISTANCE FUND
Miscellaneous 7,000
Services and Supplies 858,200
REVENUE TOTALS 953,500
EXPENSE
Salary and Benefits 400,721
Interest Income 1,000
Other Revenue 27,500
Fund 175 - GENERAL ASSISTANCE FUND
REVENUE
Property Taxes 925,000
May 2018 Financial Report
Through 05/31/18
2018
Classification Budget
Run by Kate LewisLakin on 06/27/2018 09:36:53 AM Page 2 of 35
May YTD 2017
2018 2018 Actuals
69,039 345,196 859,153
24 51 14
69,063 345,247 859,167
- - 22,593
- 14,400 121
11,944 227,090 918,074
- 2,500 -
11,944 243,990 940,789
69,063 345,247 859,167
11,944 243,990 940,789
57,119 101,256 (81,622)
Starting Fund Balance (10,815) (10,815)
Net Change (30,682) 101,256
Ending Fund Balance (41,497) 90,441
Fund 176 - HEALTH AND HUMAN (30,682)
Fund 176 - HEALTH AND HUMAN
REVENUE TOTALS 828,471
EXPENSE TOTALS 859,153
Miscellaneous -
EXPENSE TOTALS 859,153
Services and Supplies 859,153
Community Sponsored Organizations -
REVENUE TOTALS 828,471
EXPENSE
Salary and Benefits -
Interest Income -
Fund 176 - HEALTH AND HUMAN SERVICES
REVENUE
Interfund Transfers 828,471
May 2018 Financial Report
Through 05/31/18
2018
Classification Budget
Run by Kate LewisLakin on 06/27/2018 09:36:53 AM Page 3 of 35
May YTD 2017
2018 2018 Actuals
- - 1,000,000
110 514 1,884
110 514 1,001,884
83,333 416,667 1,000,000
83,333 416,667 1,000,000
110 514 1,001,884
83,333 416,667 1,000,000
(83,223) (416,153) 1,884
Starting Fund Balance 1,884 1,884
Net Change - (416,153)
Ending Fund Balance 1,884 (414,269)
REVENUE TOTALS 1,000,000
EXPENSE TOTALS 1,000,000
Fund 180 - GOOD NEIGHBOR FUND Totals -
EXPENSE TOTALS 1,000,000
Fund 180 - GOOD NEIGHBOR FUND Totals
REVENUE TOTALS 1,000,000
EXPENSE
Interfund Transfers 1,000,000
Fund 180 - GOOD NEIGHBOR FUND
REVENUE
Other Revenue 1,000,000
Interest Income -
May 2018 Financial Report
Through 05/31/18
2018
Classification Budget
Run by Kate LewisLakin on 06/27/2018 09:36:53 AM Page 4 of 35
May YTD 2017
2018 2018 Actuals
38,862 3,458,789 6,370,507
7,803 50,981 122,862
17 122 338
5,833 29,167 190,200
- 94,861 74,206
14,055 35,359 70,807
14,764 105,662 362,608
1,432 3,671 5,169
82,766 3,778,613 7,196,696
379,555 1,829,700 4,739,145
116,349 560,366 1,712,359
492 492 9,904
- - 22
30,579 152,895 343,618
526,976 2,543,453 6,805,048
3,778,613 7,196,696
2,543,453 6,805,048
1,235,160 391,648
Starting Fund Balance 1,042,304 1,042,304
Net Change 221,912 1,235,160
Ending Fund Balance 1,264,216 2,277,464
REVENUE TOTALS 7,693,209
EXPENSE TOTALS 7,471,297
Fund 185 - LIBRARY FUND Totals 221,912
EXPENSE TOTALS 7,471,297
Fund 185 - LIBRARY FUND Totals
Miscellaneous -
Interfund Transfers 366,949
Salary and Benefits 5,089,260
Services and Supplies 2,004,688
Capital Outlay 10,400
Interest Income 5,400
REVENUE TOTALS 7,693,209
EXPENSE
Intergovernmental Revenue 152,418
Other Revenue 130,000
Library Revenue 324,620
Fines and Forfeitures 130,000
Charges for Services -
Interfund Transfers 265,771
Fund 185 - LIBRARY FUND
REVENUE
Property Taxes 6,685,000
May 2018 Financial Report
Through 05/31/18
2018
Classification Budget
Run by Kate LewisLakin on 06/27/2018 09:36:53 AM Page 5 of 35
May YTD 2017
2018 2018 Actuals
865 157,860 338,897
- - 778,745
- - 7
865 157,860 1,117,649
- - 8,587
54,962 54,962 1,134,570
- - 112
54,962 54,962 1,143,269
865 157,860 1,117,649
54,962 54,962 1,143,269
(54,097) 102,898 (25,619)
Starting Fund Balance 4,089 4,089
Net Change 12,386 102,898
Ending Fund Balance 16,475 106,987
EXPENSE TOTALS 333,404
Fund 186 - LIBRARY DEBT SERVICE FUND 12,386
Fund 186 - LIBRARY DEBT SERVICE FUND
REVENUE TOTALS 345,790
Interfund Transfers -
EXPENSE TOTALS 333,404
Services and Supplies -
Debt Service 333,404
Interest Income -
REVENUE TOTALS 345,790
EXPENSE
Fund 186 - LIBRARY DEBT SERVICE FUND
REVENUE
Property Taxes 345,790
Other Revenue -
May 2018 Financial Report
Through 05/31/18
2018
Classification Budget
Run by Kate LewisLakin on 06/27/2018 09:36:53 AM Page 6 of 35
May YTD 2017
2018 2018 Actuals
- - 1,431,106
- - 1,431,106
- - 30,790
6,833 6,833 1,091,917
6,833 6,833 1,122,708
- - 1,431,106
6,833 6,833 1,122,708
(6,833) (6,833) 308,399
Starting Fund Balance 308,399 308,399
Net Change - (6,833)
Ending Fund Balance 308,399 301,566
Fund 187 - LIBRARY CAPITAL -
Fund 187 - LIBRARY CAPITAL
REVENUE TOTALS 10,095,000
EXPENSE TOTALS 10,095,000
EXPENSE TOTALS 10,095,000
Services and Supplies -
Capital Outlay 10,095,000
REVENUE TOTALS 10,095,000
EXPENSE
Fund 187 - LIBRARY CAPITAL IMPROVEMENT FD
REVENUE
Other Revenue 10,095,000
May 2018 Financial Report
Through 05/31/18
2018
Classification Budget
Run by Kate LewisLakin on 06/27/2018 09:36:53 AM Page 7 of 35
May YTD 2017
2018 2018 Actuals
10,000 16,617 37,641
27 80 -
10,027 16,697 37,641
2,472 10,445 26,454
- 1,860 1,860
- 4,873 2,642
- - (233)
- 1,744 2,400
388 1,939 4,518
2,860 20,861 37,641
10,027 16,697 37,641
2,860 20,861 37,641
7,167 (4,164) -
Starting Fund Balance - -
Net Change 326 (4,164)
Ending Fund Balance 326 (4,164)
EXPENSE TOTALS 94,821
Fund 195 - NEIGHBORHOOD 326
Fund 195 - NEIGHBORHOOD
REVENUE TOTALS 95,147
Miscellaneous 50,000
Interfund Transfers 4,654
EXPENSE TOTALS 94,821
Capital Outlay 7,000
Insurance and Other Chargebacks -
EXPENSE
Salary and Benefits 28,067
Services and Supplies 5,100
Interest Income -
REVENUE TOTALS 95,147
Fund 195 - NEIGHBORHOOD STABILIZATION FUND
REVENUE
Intergovernmental Revenue 95,147
May 2018 Financial
Report
Through 05/31/18
2018
Classification Budget
Run by Kate LewisLakin on 06/27/2018 09:36:53 AM Page 8 of 35
May YTD 2017
2018 2018 Actuals
170,518 794,319 1,899,884
3,460 16,484 18,158
173,978 810,803 1,918,041
125,000 625,000 -
79,833 399,163 957,990
204,833 1,024,163 957,990
173,978 810,803 1,918,041
204,833 1,024,163 957,990
(30,854) (213,360) 960,051
Starting Fund Balance 2,373,730 2,373,730
Net Change (535,990) (213,360)
Ending Fund Balance 1,837,740 2,160,370
Fund 200 - MOTOR FUEL TAX FUND Totals (535,990)
Fund 200 - MOTOR FUEL TAX FUND Totals
REVENUE TOTALS 1,922,000
EXPENSE TOTALS 2,457,990
Interfund Transfers 957,990
EXPENSE TOTALS 2,457,990
EXPENSE
Capital Outlay 1,500,000
Interest Income 12,000
REVENUE TOTALS 1,922,000
Fund 200 - MOTOR FUEL TAX FUND
REVENUE
Intergovernmental Revenue 1,910,000
May 2018 Financial Report
Through 05/31/18
2018
Classification Budget
Run by Kate LewisLakin on 06/27/2018 09:36:53 AM Page 9 of 35
May YTD 2017
2018 2018 Actuals
238,959 556,479 978,523
- 863 -
664 3,661 7,178
239,623 561,003 985,701
48,416 230,018 585,510
4,055 42,654 239,161
- - 51,670
1,454 7,270 17,448
6,114 30,569 72,977
60,039 310,511 966,766
239,623 561,003 985,701
60,039 310,511 966,766
179,585 250,492 18,935
Starting Fund Balance 181,996 181,996
Net Change 8,262 250,492
Ending Fund Balance 190,258 432,488
Fund 205 - EMERGENCY TELEPHONE 8,262
Fund 205 - EMERGENCY TELEPHONE
REVENUE TOTALS 1,051,700
EXPENSE TOTALS 1,043,438
Interfund Transfers 73,366
EXPENSE TOTALS 1,043,438
Capital Outlay 55,000
Insurance and Other Chargebacks 17,448
EXPENSE
Salary and Benefits 615,224
Services and Supplies 282,400
Other Revenue -
Interest Income 1,000
REVENUE TOTALS 1,051,700
Fund 205 - EMERGENCY TELEPHONE (E911) FUND
REVENUE
Other Taxes 1,050,700
May 2018 Financial Report
Through 05/31/18
2018
Classification Budget
Run by Kate LewisLakin on 06/27/2018 09:36:53 AM Page 10 of 35
May YTD 2017
2018 2018 Actuals
- 159,953 322,477
- 24 5
- 159,977 322,482
- 92,500 329,000
- 92,500 329,000
- 159,977 322,482
- 92,500 329,000
- 67,477 (6,518)
Starting Fund Balance (198,794) (198,794)
Net Change - 67,477
Ending Fund Balance (198,794) (131,317)
EXPENSE TOTALS 370,000
Fund 210 - SPECIAL SERVICE AREA (SSA) -
Fund 210 - SPECIAL SERVICE AREA (SSA)
REVENUE TOTALS 370,000
EXPENSE TOTALS 370,000
REVENUE TOTALS 370,000
EXPENSE
Services and Supplies 370,000
Fund 210 - SPECIAL SERVICE AREA (SSA) #4
REVENUE
Property Taxes 370,000
Interest Income -
May 2018 Financial Report
Through 05/31/18
2018
Classification Budget
Run by Kate LewisLakin on 06/27/2018 09:36:53 AM Page 11 of 35
May YTD 2017
2018 2018 Actuals
3,664 14,558 1,906,708
- 713 262
3,664 15,271 1,906,970
37,285 161,846 431,440
95 3,440 3,797
- 14,558 645,289
1,454 7,270 392,279
- - 318,412
10,600 15,150 95,606
746 3,731 20,145
50,180 205,995 1,906,970
3,664 15,271 1,906,970
50,180 205,995 1,906,970
(46,517) (190,724) -
Starting Fund Balance 64,107 64,107
Net Change (109,388) (190,724)
Ending Fund Balance (45,281) (126,617)
EXPENSE TOTALS 2,439,512
Fund 215 - CDBG FUND Totals (109,388)
Fund 215 - CDBG FUND Totals
REVENUE TOTALS 2,330,124
Miscellaneous 569,970
Interfund Transfers 949,656
EXPENSE TOTALS 2,439,512
Community Sponsored Organizations 175,500
Services and Supplies 220,840
Capital Outlay -
Insurance and Other Chargebacks 20,648
REVENUE TOTALS 2,330,124
EXPENSE
Salary and Benefits 502,898
Intergovernmental Revenue 2,330,124
Other Revenue -
Fund 215 - CDBG FUND
REVENUE
May 2018 Financial Report
Through 05/31/18
2018
Classification Budget
Run by Kate LewisLakin on 06/27/2018 09:36:53 AM Page 12 of 35
May YTD 2017
2018 2018 Actuals
7,128 18,840 51,369
82 329 3,391
7,210 19,168 54,760
23,169 64,841 13,070
23,169 64,841 13,070
7,210 19,168 54,760
23,169 64,841 13,070
(15,959) (45,673) 41,690
Starting Fund Balance 252,612 252,612
Net Change - (45,673)
Ending Fund Balance 252,612 206,939
Fund 220 - CDBG LOAN FUND Totals -
Fund 220 - CDBG LOAN FUND Totals
REVENUE TOTALS 293,000
EXPENSE TOTALS 293,000
EXPENSE TOTALS 293,000
Services and Supplies 293,000
Interest Income -
REVENUE TOTALS 293,000
EXPENSE
Fund 220 - CDBG LOAN FUND
REVENUE
Other Revenue 293,000
May 2018 Financial Report
Through 05/31/18
2018
Classification Budget
Run by Kate LewisLakin on 06/27/2018 09:36:53 AM Page 13 of 35
May YTD 2017
2018 2018 Actuals
25 94 256
25 94 256
- - -
- - -
25 94 256
- - -
25 94 256
Starting Fund Balance 170,171 170,171
Net Change (100,000) 94
Ending Fund Balance 70,171 170,265
EXPENSE TOTALS 100,000
Fund 235 - NEIGHBORHOOD (100,000)
Fund 235 - NEIGHBORHOOD
REVENUE TOTALS -
Miscellaneous 100,000
EXPENSE TOTALS 100,000
Interest Income -
REVENUE TOTALS -
EXPENSE
Fund 235 - NEIGHBORHOOD IMPROVEMENT
REVENUE
May 2018 Financial
Report
Through 05/31/18
2018
Classification Budget
Run by Kate LewisLakin on 06/27/2018 09:36:53 AM Page 14 of 35
May YTD 2017
2018 2018 Actuals
7,984 48,152 227,450
2,407 11,535 21,820
8 34 5,685
10,400 59,721 254,955
2,570 14,975 43,994
17,005 58,262 231,806
- - -
68 342 (27,871)
- - -
- - -
- - 126
- - -
19,643 73,579 248,055
10,400 59,721 254,955
19,643 73,579 248,055
(13,859) 6,900
Starting Fund Balance 9,277 9,277
Net Change 615 (13,859)
Ending Fund Balance 9,892 (4,582)
EXPENSE TOTALS 588,321
Fund 240 - HOME FUND Totals 615
Fund 240 - HOME FUND Totals
REVENUE TOTALS 588,936
Miscellaneous 500
Interfund Transfers -
EXPENSE TOTALS 588,321
Insurance and Other Chargebacks 820
Community Sponsored Organizations -
Debt Service -
Salary and Benefits 46,801
Services and Supplies 540,200
Capital Outlay -
Interest Income -
REVENUE TOTALS 588,936
EXPENSE
Fund 240 - HOME FUND
REVENUE
Intergovernmental Revenue 588,936
Other Revenue -
May 2018 Financial Report
Through 05/31/18
2018
Classification Budget
Run by Kate LewisLakin on 06/27/2018 09:36:53 AM Page 15 of 35
May YTD 2017
2018 2018 Actuals
20,000 30,000 97,000
417 64,583 333,056
540 2,819 5,623
20,957 97,403 435,678
6,408 31,254 44,432
- - 209,772
- - 11,532
- 2,398 8,927
12,022 14,252 85,660
18,429 47,904 360,323
20,957 97,403 435,678
18,429 47,904 360,323
2,527 49,499 75,355
Starting Fund Balance 1,476,544 1,476,544
Net Change (38,470) 49,499
Ending Fund Balance 1,438,074 1,526,043
Fund 250 - AFFORDABLE HOUSING FUND (38,470)
Fund 250 - AFFORDABLE HOUSING FUND
REVENUE TOTALS 450,830
EXPENSE TOTALS 489,300
EXPENSE TOTALS 489,300
Community Sponsored Organizations 70,000
Miscellaneous 43,000
Services and Supplies 279,500
Insurance and Other Chargebacks -
REVENUE TOTALS 450,830
EXPENSE
Salary and Benefits 96,800
Other Revenue 400,600
Interest Income 230
Fund 250 - AFFORDABLE HOUSING FUND
REVENUE
Other Taxes 50,000
May 2018 Financial Report
Through 05/31/18
2018
Classification Budget
Run by Kate LewisLakin on 06/27/2018 09:36:53 AM Page 16 of 35
May YTD 2017
2018 2018 Actuals
- 2,974,454 5,249,949
2,978 14,631 45,924
2,978 2,989,084 5,295,873
- - 2,007
- 24,668 98,672
592,253 2,961,267 5,557,325
592,253 2,985,935 5,658,005
2,978 2,989,084 5,295,873
592,253 2,985,935 5,658,005
(589,275) 3,149 (362,132)
Starting Fund Balance 5,262,544 5,262,544
Net Change (3,437,040) 3,149
Ending Fund Balance 1,825,504 5,265,693
EXPENSE TOTALS 9,207,040
Fund 300 - WASHINGTON NATIONAL TIF (3,437,040)
Fund 300 - WASHINGTON NATIONAL TIF
REVENUE TOTALS 5,770,000
Miscellaneous 100,000
Interfund Transfers 7,107,040
EXPENSE TOTALS 9,207,040
Services and Supplies 2,000,000
REVENUE TOTALS 5,770,000
EXPENSE
Interest Income 20,000
Fund 300 - WASHINGTON NATIONAL TIF FUND
REVENUE
Property Taxes 5,750,000
May 2018 Financial Report
Through 05/31/18
2018
Classification Budget
Run by Kate LewisLakin on 06/27/2018 09:36:53 AM Page 17 of 35
May YTD 2017
2018 2018 Actuals
54,797 4,880,787 10,797,411
288,930 1,444,648 2,895,561
7,219 36,093 -
- - 8,966,396
10,535 21,615 36,782
361,481 6,383,142 22,696,150
- - 100,625
2,055,360 2,055,360 23,099,797
- - (57)
2,055,360 2,055,360 23,200,365
361,481 6,383,142 22,696,150
2,055,360 2,055,360 23,200,365
(1,693,880) 4,327,782 (504,215)
Starting Fund Balance 241,781 241,781
Net Change 274,759 4,327,782
Ending Fund Balance 516,540 4,569,563
REVENUE TOTALS 14,572,016
EXPENSE TOTALS 14,297,257
Fund 320 - DEBT SERVICE FUND Totals 274,759
EXPENSE TOTALS 14,297,257
Fund 320 - DEBT SERVICE FUND Totals
Debt Service 14,177,257
Miscellaneous -
REVENUE TOTALS 14,572,016
EXPENSE
Services and Supplies 120,000
Intergovernmental Revenue 83,292
Other Revenue -
Interest Income 1,500
Fund 320 - DEBT SERVICE FUND
REVENUE
Property Taxes 10,879,993
Interfund Transfers 3,607,231
May 2018 Financial Report
Through 05/31/18
2018
Classification Budget
Run by Kate LewisLakin on 06/27/2018 09:36:53 AM Page 18 of 35
May YTD 2017
2018 2018 Actuals
- 318,714 583,827
8,246 17,505 32,000
- 62 22
8,246 336,281 615,848
328 227,522 307,391
125,000 625,000 -
104 518 995
5,000 25,000 60,000
130,432 878,040 368,386
8,246 336,281 615,848
130,432 878,040 368,386
(122,186) (541,759) 247,462
Starting Fund Balance 247,378 247,378
Net Change (296,100) (541,759)
Ending Fund Balance (48,722) (294,381)
Fund 330 - HOWARD-RIDGE TIF FUND (296,100)
Fund 330 - HOWARD-RIDGE TIF FUND
REVENUE TOTALS 4,385,400
EXPENSE TOTALS 4,681,500
Interfund Transfers 60,000
EXPENSE TOTALS 4,681,500
Debt Service 960,000
Services and Supplies 461,500
Capital Outlay 3,200,000
Interest Income 400
REVENUE TOTALS 4,385,400
EXPENSE
Fund 330 - HOWARD-RIDGE TIF FUND
REVENUE
Property Taxes 605,000
Other Revenue 3,780,000
May 2018 Financial Report
Through 05/31/18
2018
Classification Budget
Run by Kate LewisLakin on 06/27/2018 09:36:53 AM Page 19 of 35
May YTD 2017
2018 2018 Actuals
1,255 43,175 43,503
1,028 4,113 12,339
618 2,653 3,898
2,901 49,942 59,741
- - 2,007
1,281 6,371 12,227
2,500 12,500 30,000
3,781 18,871 44,235
2,901 49,942 59,741
3,781 18,871 44,235
(880) 31,071 15,506
Starting Fund Balance 432,766 432,766
Net Change (39,850) 31,071
Ending Fund Balance 392,916 463,837
Fund 335 - WEST EVANSTON TIF FUND (39,850)
Fund 335 - WEST EVANSTON TIF FUND
REVENUE TOTALS 150
EXPENSE TOTALS 40,000
Interfund Transfers 30,000
EXPENSE TOTALS 40,000
Debt Service 10,000
Services and Supplies -
Interest Income 150
REVENUE TOTALS 150
EXPENSE
Fund 335 - WEST EVANSTON TIF FUND
REVENUE
Property Taxes -
Other Revenue -
May 2018 Financial
Report
Through 05/31/18
2018
Classification Budget
Run by Kate LewisLakin on 06/27/2018 09:36:53 AM Page 20 of 35
May YTD 2017
2018 2018 Actuals
- 26,401 48,001
- - 2,067,512
- 3 1
- 26,404 2,115,514
- - 38,588
- - 2,053,521
- - 2,092,108
- 26,404 2,115,514
- - 2,092,108
- 26,404 23,406
Starting Fund Balance (6,009) (6,009)
Net Change 202,334 26,404
Ending Fund Balance 196,325 20,395
REVENUE TOTALS 275,000
EXPENSE TOTALS 72,666
Fund 340 - DEMPSTER-DODGE TIF FUND 202,334
EXPENSE TOTALS 72,666
Fund 340 - DEMPSTER-DODGE TIF FUND
Services and Supplies -
Debt Service 72,666
Interest Income -
REVENUE TOTALS 275,000
EXPENSE
Fund 340 - DEMPSTER-DODGE TIF FUND
REVENUE
Property Taxes 275,000
Other Revenue -
May 2018 Financial Report
Through 05/31/18
2018
Classification Budget
Run by Kate LewisLakin on 06/27/2018 09:36:53 AM Page 21 of 35
May YTD 2017
2018 2018 Actuals
- 31,307 75,430
- - 3,520,189
- 4 9
- 31,310 3,595,628
- - 58,113
- - 580,000
- - 3,031,398
- - 3,669,511
- 31,310 3,595,628
- - 3,669,511
- 31,310 (73,884)
Starting Fund Balance 61,193 61,193
Net Change 316,001 31,310
Ending Fund Balance 377,194 92,503
REVENUE TOTALS 425,000
EXPENSE TOTALS 108,999
Fund 345 - CHICAGO-MAIN TIF Totals 316,001
EXPENSE TOTALS 108,999
Fund 345 - CHICAGO-MAIN TIF Totals
Services and Supplies -
Capital Outlay -
Debt Service 108,999
Interest Income -
REVENUE TOTALS 425,000
EXPENSE
Fund 345 - CHICAGO-MAIN TIF
REVENUE
Property Taxes 425,000
Other Revenue -
May 2018 Financial Report
Through 05/31/18
2018
Classification Budget
Run by Kate LewisLakin on 06/27/2018 09:36:53 AM Page 22 of 35
May YTD 2017
2018 2018 Actuals
1,706 117,233 215,245
1 18 21
1,707 117,251 215,266
- - 213,354
- - 78,000
- - 291,354
1,707 117,251 215,266
- - 291,354
1,707 117,251 (76,088)
Starting Fund Balance 2,207 2,207
Net Change - 117,251
Ending Fund Balance 2,207 119,458
Fund 350 - SPECIAL SERVICE AREA (SSA) -
Fund 350 - SPECIAL SERVICE AREA (SSA)
REVENUE TOTALS 221,500
EXPENSE TOTALS 221,500
Interfund Transfers -
EXPENSE TOTALS 221,500
REVENUE TOTALS 221,500
EXPENSE
Services and Supplies 221,500
Fund 350 - SPECIAL SERVICE AREA (SSA) #6
REVENUE
Property Taxes 221,000
Interest Income 500
May 2018 Financial Report
Through 05/31/18
2018
Classification Budget
Run by Kate LewisLakin on 06/27/2018 09:36:53 AM Page 23 of 35
May YTD 2017
2018 2018 Actuals
- - 359,706
- - 33,339
536,667 2,683,333 787,177
51,221 51,221 530,812
- - 11,246,149
7,826 41,791 56,607
595,714 2,776,346 13,013,790
51,938 234,289 5,392
144,047 298,353 1,672,608
1,088,145 3,245,300 13,582,482
41,667 208,333 500,000
1,325,797 3,986,276 15,760,481
595,714 2,776,346 13,013,790
1,325,797 3,986,276 15,760,481
(730,083) (1,209,930) (2,746,691)
Starting Fund Balance 8,758,473 8,758,473
Net Change (7,655,527) (1,209,930)
Ending Fund Balance 1,102,946 7,548,543
REVENUE TOTALS 22,642,000
EXPENSE TOTALS 30,297,527
Fund 415 - CAPITAL IMPROVEMENTS (7,655,527)
EXPENSE TOTALS 30,297,527
Fund 415 - CAPITAL IMPROVEMENTS
Interfund Transfers 500,000
Salary and Benefits 85,527
Services and Supplies -
Capital Outlay 29,712,000
Interest Income -
REVENUE TOTALS 22,642,000
EXPENSE
Interfund Transfers 6,450,000
Intergovernmental Revenue 4,190,000
Other Revenue 12,002,000
Fund 415 - CAPITAL IMPROVEMENTS FUND
REVENUE
Licenses, Permits and Fees -
Charges for Services -
May 2018 Financial Report
Through 05/31/18
2018
Classification Budget
Run by Kate LewisLakin on 06/27/2018 09:36:53 AM Page 24 of 35
May YTD 2017
2018 2018 Actuals
- - 649,512
- - 900,000
- - 1,549,512
194,030 515,956 638,727
- 11,770 369,924
194,030 527,726 1,008,651
- - 1,549,512
194,030 527,726 1,008,651
(194,030) (527,726) 540,861
Starting Fund Balance 540,861 540,861
Net Change 1,866,000 (527,726)
Ending Fund Balance 2,406,861 13,135
REVENUE TOTALS 11,500,000
EXPENSE TOTALS 9,634,000
Fund 416 - CROWN CONSTRUCTION FUND 1,866,000
EXPENSE TOTALS 9,634,000
Fund 416 - CROWN CONSTRUCTION FUND
Services and Supplies 1,634,000
Capital Outlay 8,000,000
REVENUE TOTALS 11,500,000
EXPENSE
Fund 416 - CROWN CONSTRUCTION FUND
REVENUE
Interfund Transfers -
Other Revenue 11,500,000
May 2018 Financial Report
Through 05/31/18
2018
Classification Budget
Run by Kate LewisLakin on 06/27/2018 09:36:53 AM Page 25 of 35
May YTD 2017
2018 2018 Actuals
- - -
189 16,340 31,207
4,822 109,529 237,012
5,011 125,870 268,219
5,720 26,605 694
- - 5,613
42,786 213,928 263,427
48,505 240,533 269,734
5,011 125,870 268,219
48,505 240,533 269,734
(43,494) (114,664) (1,516)
Starting Fund Balance 2,997,700 2,997,700
Net Change (123,850) (114,664)
Ending Fund Balance 2,873,850 2,883,036
REVENUE TOTALS 461,367
EXPENSE TOTALS 585,217
Fund 420 - SPECIAL ASSESSMENT FUND (123,850)
EXPENSE TOTALS 585,217
Fund 420 - SPECIAL ASSESSMENT FUND
Interfund Transfers 513,427
Services and Supplies -
REVENUE TOTALS 461,367
EXPENSE
Salary and Benefits 71,790
Interest Income 31,200
Special Assessment 180,167
Other Revenue 250,000
Fund 420 - SPECIAL ASSESSMENT FUND
REVENUE
May 2018 Financial Report
Through 05/31/18
2018
Classification Budget
Run by Kate LewisLakin on 06/27/2018 09:36:53 AM Page 26 of 35
May YTD 2017
2018 2018 Actuals
105 1,918 1,900
398,638 3,202,116 6,303,624
347,253 1,736,267 4,120,636
- - -
24,294 103,575 253,523
8,267 21,302 62,067
778,557 5,065,177 10,741,750
145,535 651,544 1,675,404
461,834 907,600 3,172,070
- 143,821 280,311
26,637 133,187 319,648
- - 2,561,771
- - 4,246
53,131 53,131 267,734
38,471 77,574 267,436
120,035 600,174 1,584,683
845,642 2,567,030 10,133,302
5,065,177 10,741,750
2,567,030 10,133,302
(67,085) 2,498,146 608,448
Starting Fund Balance 4,710,701 4,710,701
Net Change (1,762,367) 2,498,146
Ending Fund Balance 2,948,334 7,208,847
Fund 505 - PARKING SYSTEM FUND Totals (1,762,367)
Fund 505 - PARKING SYSTEM FUND Totals
REVENUE TOTALS 11,134,126
EXPENSE TOTALS 12,896,493
Interfund Transfers 1,440,417
EXPENSE TOTALS 12,896,493
Contingencies 11,000
Debt Service 3,070,625
Miscellaneous 304,000
Insurance and Other Chargebacks 319,648
Depreciation Expense -
Salary and Benefits 1,849,028
Services and Supplies 3,451,775
Capital Outlay 2,450,000
Interest Income 35,070
REVENUE TOTALS 11,134,126
EXPENSE
Interfund Transfers 4,217,040
Intergovernmental Revenue 12,125
Other Revenue 193,316
Licenses, Permits and Fees -
Charges for Services 6,676,575
Fund 505 - PARKING SYSTEM FUND
REVENUE
May 2018 Financial Report
Through 05/31/18
2018
Classification Budget
Run by Kate LewisLakin on 06/27/2018 09:36:53 AM Page 27 of 35
May YTD 2017
2018 2018 Actuals
4,370 17,392 86,063
1,770,928 7,890,035 17,255,947
(232) 31,548 294,812
20,590 65,935 35,784
1,795,656 8,004,910 17,672,605
448,928 2,029,701 5,958,873
431,574 1,038,950 2,528,863
283,632 429,426 11,408
39,041 195,205 468,492
- - 2,470,280
- - -
431,617 465,369 717,388
- - (203,530)
306,859 1,534,295 6,327,314
18,279,088
1,795,656 8,004,910 17,672,605
1,941,652 5,692,946 18,279,088
(145,995) 2,311,963 (606,483)
Starting Fund Balance 6,562,795 6,562,795
Net Change 32,150 2,311,963
Ending Fund Balance 6,594,945 8,874,758
1,941,652 5,692,946
EXPENSE TOTALS 45,663,506
Fund 510 - WATER FUND Totals 32,150
Fund 510 - WATER FUND Totals
REVENUE TOTALS 45,695,656
Miscellaneous 15,000
Interfund Transfers 3,602,313
EXPENSE TOTALS 45,663,506
Depreciation Expense -
Contingencies 1,000
Debt Service 1,960,760
Capital Outlay 29,346,200
Insurance and Other Chargebacks 468,492
EXPENSE
Salary and Benefits 5,614,331
Services and Supplies 4,655,410
Other Revenue 27,333,656
Interest Income 25,000
REVENUE TOTALS 45,695,656
Charges for Services 18,267,000
Fund 510 - WATER FUND
REVENUE
Licenses, Permits and Fees 70,000
May 2018 Financial Report
Through 05/31/18
2018
Classification Budget
Run by Kate LewisLakin on 06/27/2018 09:36:53 AM Page 28 of 35
May YTD 2017
2018 2018 Actuals
269,240 4,993,793 12,477,657
- - 14,870
2,402 11,852 16,023
271,642 5,005,645 12,508,550
105,875 484,973 1,313,154
12,430 28,064 88,677
- 58,703 7,676
22,499 112,495 269,988
- - 3,530,787
1,077,396 3,191,166 1,143,643
- - 9,265
82,640 413,199 1,141,676
1,300,840 4,288,599 7,504,867
271,642 5,005,645 12,508,550
1,300,840 4,288,599 7,504,867
717,046 5,003,683
Starting Fund Balance 4,037,755 4,037,755
Net Change (119,220) 717,046
Ending Fund Balance 3,918,535 4,754,801
Fund 515 - SEWER FUND Totals (119,220)
Fund 515 - SEWER FUND Totals
REVENUE TOTALS 14,698,650
EXPENSE TOTALS 14,817,870
Interfund Transfers 991,677
EXPENSE TOTALS 14,817,870
Debt Service 7,540,066
Miscellaneous 1,500
Capital Outlay 2,181,300
Insurance and Other Chargebacks 269,988
Depreciation Expense -
EXPENSE
Salary and Benefits 1,274,709
Services and Supplies 2,558,630
Other Revenue 2,104,000
Interest Income 5,000
REVENUE TOTALS 14,698,650
Fund 515 - SEWER FUND
REVENUE
Charges for Services 12,589,650
May 2018 Financial Report
Through 05/31/18
2018
Classification Budget
Run by Kate LewisLakin on 06/27/2018 09:36:53 AM Page 29 of 35
May YTD 2017
2018 2018 Actuals
6,648 267,563 -
- 14,448 199,513
290,631 1,493,400 3,611,308
58,831 294,153 755,967
8,048 28,861 250,687
- - -
364,158 2,098,425 4,817,475
81,933 347,104 890,220
515,316 1,285,597 3,482,141
1,260 5,196 24,635
665 665 1,797
- 3,688 3,057
26,864 134,318 504,807
626,037 1,776,568 4,906,657
364,158 2,098,425 4,817,475
1,776,568 4,906,657
321,857 (89,182)
Starting Fund Balance (1,061,966) (1,061,966)
Net Change 151,660 321,857
Ending Fund Balance (910,306) (740,109)
EXPENSE TOTALS 5,109,701
Fund 520 - SOLID WASTE FUND Totals 151,660
Fund 520 - SOLID WASTE FUND Totals
REVENUE TOTALS 5,261,361
Miscellaneous 7,500
Interfund Transfers 322,362
EXPENSE TOTALS 5,109,701
Debt Service 21,797
Capital Outlay 275,750
EXPENSE
Salary and Benefits 993,616
Services and Supplies 3,488,676
Other Revenue 238,000
Interest Income -
REVENUE TOTALS 5,261,361
Charges for Services 3,632,394
Interfund Transfers 705,967
Fund 520 - SOLID WASTE FUND
REVENUE
Property Taxes 410,000
Licenses, Permits and Fees 275,000
May 2018 Financial Report
Through 05/31/18
2018
Classification Budget
Run by Kate LewisLakin on 06/27/2018 09:36:53 AM Page 30 of 35
May YTD 2017
2018 2018 Actuals
249,053 1,245,267 2,478,435
647 7,100 19,016
- 24 339
249,700 1,252,391 2,497,791
84,282 392,440 1,154,569
231,464 845,913 1,744,972
- - -
2,787 13,934 27,833
318,533 1,252,287 2,927,375
249,700 1,252,391 2,497,791
318,533 1,252,287 2,927,375
(68,833) 104 (429,584)
Starting Fund Balance 341,343 341,343
Net Change (192,655) 104
Ending Fund Balance 148,688 341,447
EXPENSE TOTALS 3,333,871
Fund 600 - FLEET SERVICES FUND Totals (192,655)
Fund 600 - FLEET SERVICES FUND Totals
REVENUE TOTALS 3,141,216
Interfund Transfers 33,442
EXPENSE TOTALS 3,333,871
Contingencies 450
Services and Supplies 2,230,057
REVENUE TOTALS 3,141,216
EXPENSE
Salary and Benefits 1,069,922
Other Revenue 81,781
Interest Income 1,000
Fund 600 - FLEET SERVICES FUND
REVENUE
Charges for Services 3,058,435
May 2018 Financial Report
Through 05/31/18
2018
Classification Budget
Run by Kate LewisLakin on 06/27/2018 09:36:53 AM Page 31 of 35
May YTD 2017
2018 2018 Actuals
111,228 556,138 1,400,057
19,758 19,758 88,015
125 459 2,128
131,111 576,355 1,490,200
5,994 9,704 74,539
300,055 627,527 -
- - 1,780,829
306,049 637,231 1,855,367
131,111 576,355 1,490,200
306,049 637,231 1,855,367
(174,938) (60,876) (365,167)
Starting Fund Balance 849,519 849,519
Net Change (20,147) (60,876)
Ending Fund Balance 829,372 788,643
EXPENSE TOTALS 1,597,977
Fund 601 - EQUIPMENT REPLACEMENT (20,147)
Fund 601 - EQUIPMENT REPLACEMENT
REVENUE TOTALS 1,577,830
Depreciation Expense -
EXPENSE TOTALS 1,597,977
EXPENSE
Services and Supplies 75,000
Capital Outlay 1,522,977
Other Revenue 210,217
Interest Income -
REVENUE TOTALS 1,577,830
Fund 601 - EQUIPMENT REPLACEMENT FUND
REVENUE
Charges for Services 1,367,613
May 2018 Financial Report
Through 05/31/18
2018
Classification Budget
Run by Kate LewisLakin on 06/27/2018 09:36:53 AM Page 32 of 35
May YTD 2017
2018 2018 Actuals
13,534 72,952 162,411
- - 2,300,000
877,006 4,154,475 10,926,377
174,221 863,118 1,032,678
474,199 2,304,369 5,611,626
32 645 382
1,538,993 7,395,560 20,033,473
53,246 304,800 606,021
836,683 1,090,467 3,594,432
1,380,092 6,932,016 17,164,869
803 4,013 9,632
2,270,823 8,331,297 21,374,954
1,538,993 7,395,560 20,033,473
2,270,823 8,331,297 21,374,954
(731,830) (935,737) (1,341,481)
Starting Fund Balance (4,338,505) (4,338,505)
Net Change 653,342 (935,737)
Ending Fund Balance (3,685,163) (5,274,242)
EXPENSE TOTALS 18,439,931
Fund 605 - INSURANCE FUND Totals 653,342
Fund 605 - INSURANCE FUND Totals
REVENUE TOTALS 19,093,273
Interfund Transfers 9,632
EXPENSE TOTALS 18,439,931
Insurance and Other Chargebacks 15,315,824
EXPENSE
Salary and Benefits 729,027
Services and Supplies 2,385,448
Insurance 5,811,177
Interest Income 1,000
REVENUE TOTALS 19,093,273
Other Revenue 10,867,028
Workers Compensation and Liability 2,196,415
Fund 605 - INSURANCE FUND
REVENUE
Charges for Services 162,411
Interfund Transfers 55,242
May 2018 Financial Report
Through 05/31/18
2018
Classification Budget
Run by Kate LewisLakin on 06/27/2018 09:36:53 AM Page 33 of 35
May YTD 2017
2018 2018 Actuals
- - -
- - -
1,217,420 4,425,935 15,225,459
83,329 578,548 2,065,885
1,300,749 5,004,482 17,291,343
776,307 3,768,473 8,682,009
- 21,413 136,256
776,307 3,789,885 8,818,265
1,300,749 5,004,482 17,291,343
776,307 3,789,885 8,818,265
524,442 1,214,597 8,473,079
Starting Fund Balance 79,073,077 79,073,077
Net Change 4,989,947 1,214,597
Ending Fund Balance 84,063,024 80,287,674
Fund 700 - FIRE PENSION FUND Totals 4,989,947
Fund 700 - FIRE PENSION FUND Totals
REVENUE TOTALS 13,784,947
EXPENSE TOTALS 8,795,000
Miscellaneous -
EXPENSE TOTALS 8,795,000
REVENUE TOTALS 13,784,947
EXPENSE
Salary and Benefits 8,795,000
Interfund Transfers 10,000
Other Revenue 9,394,947
Interest Income 4,100,000
Fund 700 - FIRE PENSION FUND
REVENUE
Other Taxes 280,000
May 2018 Financial Report
Through 05/31/18
2018
Classification Budget
Run by Kate LewisLakin on 06/27/2018 09:36:53 AM Page 34 of 35
May YTD 2017
2018 2018 Actuals
- - -
2,274,714 6,328,102 24,497,983
228,303 944,195 2,829,084
2,503,017 7,272,296 27,327,068
998,648 4,955,512 11,624,574
16,646 125,463 264,371
1,015,294 5,080,974 11,888,945
2,503,017 7,272,296 27,327,068
1,015,294 5,080,974 11,888,945
1,487,723 2,191,322 15,438,122
Starting Fund Balance 121,629,667 121,629,667
Net Change 6,194,704 2,191,322
Ending Fund Balance 127,824,371 123,820,989
REVENUE TOTALS 18,719,704
EXPENSE TOTALS 12,525,000
Fund 705 - POLICE PENSION FUND Totals 6,194,704
EXPENSE TOTALS 12,525,000
Fund 705 - POLICE PENSION FUND Totals
Miscellaneous 270,000
REVENUE TOTALS 18,719,704
EXPENSE
Salary and Benefits 12,255,000
Interfund Transfers 57,000
Other Revenue 12,162,704
Interest Income 6,500,000
Fund 705 - POLICE PENSION FUND
REVENUE
May 2018 Financial Report
Through 05/31/18
2018
Classification Budget
Run by Kate LewisLakin on 06/27/2018 09:36:53 AM Page 35 of 35