HomeMy WebLinkAbout2018.06 June Monthly Report
To: Wally Bobkiewicz, City Manager
From: Hitesh Desai, CFO/City Treasurer
Ashley King, Budget & Finance Manager
Kate Lewis-Lakin, Senior Management Analyst
Subject: June 2018 Monthly Financial Report
Date: July 17, 2018
Please find attached the unaudited financial statements as of June 30, 2018. A
summary by fund for revenues, expenditures, fund and cash balances is as follows:
Memorandum
YTD
Revenues
YTD
Expenses YTD Net
Fund
Balance
Cash
Balance
58,334,251 56,061,629 2,272,622 15,488,721 9,006,016
520,977 455,792 65,185 709,684 709,685
414,286 233,342 180,944 170,129 170,129
1,189 500,000 (498,811) (496,927) 503,072
3,824,264 3,225,738 598,527 1,640,831 1,582,901
157,860 54,962 102,898 106,987 106,988
- 6,833 (6,833) 301,566 301,565
16,793 24,385 (7,593) (7,593) 97,220
971,459 1,228,995 (257,536) 2,116,194 1,951,575
696,108 485,438 210,670 392,666 82,617
159,977 92,500 67,477 (131,317) (131,317)
15,706 257,658 (241,952) (177,845) (177,845)
21,808 64,946 (43,138) 209,474 209,473
247 - 247 170,418 170,418
102,670 117,279 (14,609) (5,332) (5,332)
99,891 91,117 8,774 1,485,318 1,489,734
2,992,230 3,578,188 (585,958) 4,676,586 4,752,808
6,691,056 2,055,360 4,635,695 4,877,476 4,953,345
346,849 1,015,479 (668,630) (421,252) (418,982)
51,739 23,726 28,013 460,779 469,102
26,404 1,032 25,372 19,363 19,363
31,310 1,032 30,278 91,471 91,472
10,251 - 10,251 12,458 12,458
3,354,479 5,791,422 (2,436,943) 6,321,530 7,449,198
- 1,021,170 (1,021,170) (480,309) (480,309)
132,333 291,507 (159,173) 2,838,527 2,834,990
5,832,048 3,609,400 2,222,648 6,933,349 6,765,698
9,620,377 7,030,488 2,589,890 9,152,685 5,235,746
6,130,593 5,147,247 983,345 5,021,100 2,647,234
2,503,749 2,219,498 284,251 (777,715) (1,269,704)
1,505,238 1,502,766 2,472 343,815 (437,848)
688,073 640,811 47,262 896,781 896,781
8,967,911 9,746,364 (778,453) (5,116,958) (2,306,562)
Grand Totals 114,222,128 106,576,104 7,646,024 56,822,662 47,281,686
Fund Fund Description
100 GENERAL FUND
176 HEALTH AND HUMAN SERVICES
175 GENERAL ASSISTANCE FUND
180 GOOD NEIGHBOR FUND
185 LIBRARY FUND
195 NEIGHBORHOOD STABILIZATION
200 MOTOR FUEL TAX FUND
205 EMERGENCY TELEPHONE (E911)
210 SPECIAL SERVICE AREA (SSA) #4
215 CDBG FUND
220 CDBG LOAN FUND
235 NEIGHBORHOOD IMPROVEMENT
240 HOME FUND
186 LIBRARY DEBT SERVICE FUND
250 AFFORDABLE HOUSING FUND
300 WASHINGTON NATIONAL TIF
330 HOWARD-RIDGE TIF FUND
335 WEST EVANSTON TIF FUND
340 DEMPSTER-DODGE TIF FUND
345 CHICAGO-MAIN TIF
350 SPECIAL SERVICE AREA (SSA) #6
187 LIBRARY CAPITAL IMPROVEMENT
320 DEBT SERVICE FUND
415 CAPITAL IMPROVEMENTS FUND
416 CROWN CONSTRUCTION FUND
420 SPECIAL ASSESSMENT FUND
505 PARKING SYSTEM FUND
510 WATER FUND
515 SEWER FUND
520 SOLID WASTE FUND
600 FLEET SERVICES FUND
601 EQUIPMENT REPLACEMENT FUND
605 INSURANCE FUND
Included above are the ending balances as of June 30, 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 June 30, 2018, the General Fund is reporting a net surplus of $2,272,622. The
fund balance in the General Fund is $15,488,721 with a cash balance of $9,006,016.
The attached supplemental charts show the General Fund Revenues at 50.8% of
budget and expenses at 49.1%. Fund and cash balances have decreased in June
because of three payrolls. The current report includes 12.5 payrolls, with 13.5 remaining
in the fiscal year.
Through June 30, 2018, the Good Neighbor Fund is showing a negative fund balance of
$496,927. 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 June 30, 2018, the Neighborhood Stabilization Fund is showing a negative
fund balance of $7,593. This is due to the timing of grant funding revenues.
Through June 30, 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 June 30, 2018, the CDBG fund is showing a negative fund and cash balance of
$177,845. This is due to a delay in reimbursements and will be repaid with draw-downs
during July.
Through June 30, 2018, the HOME Fund is showing a negative fund balance of $5,332.
This is due to the timing of grant funding revenues.
Through June 30, 2018, the Howard-Ridge TIF Fund is showing a negative fund
balance of $421,252 and a negative cash balance of $418,982. This is due to capital
project spending which will be repaid later in the summer by proceeds from the 2018D
bond issuance.
Through June 30, 2018, the Capital Fund is showing a fund balance of $6,321,530 and
a cash balance of $7,449,198. 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$ 14,612,957$
2018 Unreserved
Fund Balance 16,512,558$ 15,306,742$ 17,933,253$ 17,384,626$ 18,479,429$ 15,488,721$
2017 Cash Balance 6,338,271$ 6,393,110$ 11,561,044$ 10,901,398$ 10,376,936$ 6,169,276$
2018 Cash Balance 8,905,448$ 8,120,225$ 12,288,418$ 11,184,339$ 12,226,888$ 9,006,016$
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
June YTD 2017
2018 2018 %Actuals
Property Taxes - 15,954,204 55.3% 28,294,363
Other Taxes 4,729,763 25,039,004 50.3% 46,951,377
Licenses, Permits and Fees 770,786 5,404,391 43.6% 13,357,911
Fines and Forfeitures 201,525 1,383,246 35.6% 3,467,694
Charges for Services 851,526 5,259,507 52.2% 8,754,025
Interfund Transfers 618,143 3,708,856 47.9% 11,586,943
Intergovernmental Revenue 51,713 679,870 85.7% 1,234,749
Other Revenue 98,513 876,861 67.4% 1,858,106
Interest Income 11,403 28,312 56.5% 38,544
7,333,371 58,334,251 50.8% 115,543,711
CITY COUNCIL 492,806 49,506 280,806 57.0% 498,172
191,784 23,935 101,346 52.8% 251,193
7,540,597 637,644 3,454,615 45.8% 7,539,496
736,346 72,858 347,324 47.2% 772,045
9,075,303 1,071,289 4,474,861 49.3% 9,314,164
3,614,774 317,893 1,560,215 43.2% 2,592,984
38,391,099 3,042,611 19,755,121 51.5% 39,067,047
23,934,390 1,613,935 12,540,038 52.4% 24,355,551
3,697,529 306,833 1,525,889 41.3% 3,071,334
11,955,812 1,694,737 5,414,696 45.3% 12,479,438
14,607,356 1,203,948 6,606,717 45.2% 13,983,314
49.1% 113,924,739
7,333,371 58,334,251 50.8% 115,543,711
10,035,188 56,061,629 49.1% 113,924,739
(2,701,817) 2,272,622 1,618,972
POLICE
CITY CLERK
CITY MANAGER'S OFFICE
LAW
ADMINISTRATIVE SERVICES
COMMUNITY DEVELOPMENT
PUBLIC WORKS AGENCY
PARKS, REC. AND COMMUNITY SERV.
HEALTH
FIRE MGMT & SUPPORT
10,035,188 56,061,629
REVENUE TOTALS 114,840,754
EXPENSE TOTALS 114,237,796
Fund 100 - GENERAL FUND Totals 602,958
Fund 100 - GENERAL FUND Totals
EXPENSE TOTALS 114,237,796
EXPENSE
793,100
1,300,217
50,100
114,840,754 REVENUE TOTALS
June 2018 Financial Report
Through 06/30/18
2018
Organization Budget
Fund 100 - GENERAL FUND
REVENUE
28,849,196
49,742,274
12,397,400
3,882,500
10,077,550
7,748,417
June YTD 2017
2018 2018 %Actuals
150 2,068 0.0% 1,900
237,519 3,597,378 53.9% 6,303,624
347,253 2,083,520 49.4% 4,120,636
- - 0.0% -
14,014 117,589 60.8% 253,523
10,192 31,494 89.8% 62,067
609,129 5,832,048 52.4% 10,741,750
197,736 849,280 45.9% 1,675,404
667,331 1,574,931 45.6% 3,172,070
18,740 162,562 6.6% 280,311
26,637 159,824 50.0% 319,648
- - 0.0% 2,561,771
- - 0.0% 4,246
- 53,131 1.7% 267,734
11,890 89,464 29.4% 267,436
120,035 720,209 50.0% 1,584,683
1,042,370 3,609,400 28.0% 10,133,302
609,129 5,832,048 52.4% 10,741,750
1,042,370 3,609,400 28.0% 10,133,302
(433,241) 2,222,648 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
June 2018 Financial Report
Through 06/30/18
2018
Classification Budget
June YTD 2017
2018 2018 %Actuals
7,400 24,792 35.4% 86,063
1,578,117 9,468,152 51.8% 17,255,947
5,955 37,503 0.1% 294,812
23,996 89,930 359.7% 35,784
1,615,468 9,620,377 21.1% 17,672,605
626,902 2,656,603 47.3% 5,958,873
278,359 1,317,309 28.3% 2,528,863
86,380 515,806 1.8% 11,408
39,041 234,246 50.0% 468,492
- - 0.0% 2,470,280
- - 0.0% -
- 465,369 23.7% 717,388
- - 0.0% (203,530)
306,859 1,841,155 51.1% 6,327,314
1,337,541 7,030,488 15.4% 18,279,088
1,615,468 9,620,377 21.1% 17,672,605
1,337,541 7,030,488 15.4% 18,279,088
277,926 2,589,890 (606,483)
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
June 2018 Financial Report
Through 06/30/18
2018
Classification Budget
June YTD 2017
2018 2018 %Actuals
1,121,974 6,115,767 48.6% 12,477,657
- - 0.0% 14,870
2,973 14,825 296.5% 16,023
1,124,947 6,130,593 41.7% 12,508,550
145,880 630,852 49.5% 1,313,154
9,432 37,497 1.5% 88,677
235,061 293,764 13.5% 7,676
22,499 134,994 50.0% 269,988
- - 0.0% 3,530,787
363,136 3,554,302 47.1% 1,143,643
- - 0.0% 9,265
82,640 495,839 50.0% 1,141,676
858,648 5,147,247 34.7% 7,504,867
1,124,947 6,130,593 41.7% 12,508,550
858,648 5,147,247 34.7% 7,504,867
266,299 983,345 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
June 2018 Financial Report
Through 06/30/18
2018
Classification Budget
June YTD 2017
2018 2018 %Actuals
- 267,563 65.3% -
41,638 56,086 20.4% 199,513
290,629 1,784,029 49.1% 3,611,308
58,831 352,983 50.0% 755,967
14,227 43,088 18.1% 250,687
405,325 2,503,749 47.6% 4,817,475
99,358 446,463 44.9% 890,220
314,882 1,600,479 45.9% 3,482,141
1,827 7,023 2.5% 24,635
- 665 3.1% 1,797
- 3,688 49.2% 3,057
26,864 161,181 50.0% 504,807
442,931 2,219,498 43.4% 4,906,657
405,325 2,503,749 47.6% 4,817,475
442,931 2,219,498 43.4% 4,906,657
(37,606) 284,251 (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
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
June 2018 Financial Report
Through 06/30/18
2018
Classification Budget
June YTD 2017
2018 2018 Actuals
- 15,954,204 28,294,363
4,729,763 25,039,004 46,951,377
770,786 5,404,391 13,357,911
201,525 1,383,246 3,467,694
851,526 5,259,507 8,754,025
618,143 3,708,856 11,586,943
51,713 679,870 1,234,749
98,513 876,861 1,858,106
11,403 28,312 38,544
7,333,371 58,334,251 115,543,711
7,611,251 34,803,555 71,659,904
1,437,854 5,073,513 13,414,590
6,396 55,314 361,427
286,782 11,923,887 20,883,996
751 37,576 124,131
- 106 4,090
52,643 330,618 835,363
639,510 3,837,060 6,641,237
10,035,188 56,061,629 113,924,739
7,333,371 58,334,251 115,543,711
10,035,188 56,061,629 113,924,739
(2,701,817) 2,272,622 1,618,972
Starting Fund Balance 13,216,099 13,216,099
Net Change 602,958 2,272,622
Ending Fund Balance 13,819,057 15,488,721
June 2018 Financial Report
Through 06/30/18
2018
Classification Budget
Fund 100 - GENERAL FUND
REVENUE
Property Taxes 28,849,196
Other Taxes 49,742,274
Licenses, Permits and Fees 12,397,400
Fines and Forfeitures 3,882,500
Charges for Services 10,077,550
Interest Income 50,100
Interfund Transfers 7,748,417
Intergovernmental Revenue 793,100
Other Revenue 1,300,217
REVENUE TOTALS 114,840,754
EXPENSE
Salary and Benefits 70,175,937
Services and Supplies 12,367,791
Capital Outlay 354,000
Insurance and Other Chargebacks 22,287,563
Miscellaneous 1,015,317
Interfund Transfers 7,704,802
Community Sponsored Organizations 123,886
Contingencies 208,500
EXPENSE TOTALS 114,237,796
Fund 100 - GENERAL FUND Totals
REVENUE TOTALS 114,840,754
EXPENSE TOTALS 114,237,796
Fund 100 - GENERAL FUND Totals 602,958
Run by Kate LewisLakin on 07/17/2018 02:10:37 PM Page 1 of 35
June YTD 2017
2018 2018 Actuals
- 506,094 933,020
610 12,911 33,019
1,036 1,973 1,548
1,646 520,977 967,586
43,969 189,742 324,972
49,076 265,930 579,392
- 120 5,110
93,045 455,792 909,475
1,646 520,977 967,586
93,045 455,792 909,475
(91,398) 65,185 58,111
Starting Fund Balance 644,499 644,499
Net Change (312,421) 65,185
Ending Fund Balance 332,078 709,684
June 2018 Financial Report
Through 06/30/18
2018
Classification Budget
Interest Income 1,000
Other Revenue 27,500
Fund 175 - GENERAL ASSISTANCE FUND
REVENUE
Property Taxes 925,000
Miscellaneous 7,000
Services and Supplies 858,200
REVENUE TOTALS 953,500
EXPENSE
Salary and Benefits 400,721
EXPENSE TOTALS 1,265,921
Fund 175 - GENERAL ASSISTANCE FUND
REVENUE TOTALS 953,500
EXPENSE TOTALS 1,265,921
Fund 175 - GENERAL ASSISTANCE FUND (312,421)
Run by Kate LewisLakin on 07/17/2018 02:10:37 PM Page 2 of 35
June YTD 2017
2018 2018 Actuals
69,039 414,236 859,153
- 51 14
69,039 414,286 859,167
(22,593) (22,593) 22,593
- 14,400 121
11,944 239,035 918,074
- 2,500 -
(10,649) 233,342 940,789
69,039 414,286 859,167
(10,649) 233,342 940,789
79,688 180,944 (81,622)
Starting Fund Balance (10,815) (10,815)
Net Change (30,682) 180,944
Ending Fund Balance (41,497) 170,129
June 2018 Financial Report
Through 06/30/18
2018
Classification Budget
Interest Income -
Fund 176 - HEALTH AND HUMAN SERVICES
REVENUE
Interfund Transfers 828,471
Services and Supplies 859,153
Community Sponsored Organizations -
REVENUE TOTALS 828,471
EXPENSE
Salary and Benefits -
Miscellaneous -
EXPENSE TOTALS 859,153
Fund 176 - HEALTH AND HUMAN (30,682)
Fund 176 - HEALTH AND HUMAN
REVENUE TOTALS 828,471
EXPENSE TOTALS 859,153
Run by Kate LewisLakin on 07/17/2018 02:10:37 PM Page 3 of 35
June YTD 2017
2018 2018 Actuals
- - 1,000,000
675 1,189 1,884
675 1,189 1,001,884
83,333 500,000 1,000,000
83,333 500,000 1,000,000
675 1,189 1,001,884
83,333 500,000 1,000,000
(82,658) (498,811) 1,884
Starting Fund Balance 1,884 1,884
Net Change - (498,811)
Ending Fund Balance 1,884 (496,927)
June 2018 Financial Report
Through 06/30/18
2018
Classification Budget
Fund 180 - GOOD NEIGHBOR FUND
REVENUE
Other Revenue 1,000,000
Interest Income -
REVENUE TOTALS 1,000,000
EXPENSE
Interfund Transfers 1,000,000
EXPENSE TOTALS 1,000,000
Fund 180 - GOOD NEIGHBOR FUND Totals
REVENUE TOTALS 1,000,000
EXPENSE TOTALS 1,000,000
Fund 180 - GOOD NEIGHBOR FUND Totals -
Run by Kate LewisLakin on 07/17/2018 02:10:37 PM Page 4 of 35
June YTD 2017
2018 2018 Actuals
- 3,458,789 6,370,507
9,316 60,296 122,862
31 153 338
5,833 35,000 190,200
10,930 105,792 74,206
7,975 43,334 70,807
7,388 113,050 362,608
4,179 7,850 5,169
45,651 3,824,264 7,196,696
555,509 2,385,209 4,739,145
96,196 656,563 1,712,359
- 492 9,904
- - 22
30,579 183,474 343,618
682,284 3,225,738 6,805,048
45,651 3,824,264 7,196,696
682,284 3,225,738 6,805,048
(636,633) 598,527 391,648
Starting Fund Balance 1,042,304 1,042,304
Net Change 216,912 598,527
Ending Fund Balance 1,259,216 1,640,831
Fund 185 - LIBRARY FUND
REVENUE
Property Taxes 6,685,000
June 2018 Financial Report
Through 06/30/18
2018
Classification Budget
Fines and Forfeitures 130,000
Charges for Services -
Interfund Transfers 265,771
Intergovernmental Revenue 152,418
Other Revenue 130,000
Library Revenue 324,620
Interest Income 5,400
REVENUE TOTALS 7,693,209
EXPENSE
Miscellaneous -
Interfund Transfers 366,949
Salary and Benefits 5,074,260
Services and Supplies 2,024,688
Capital Outlay 10,400
EXPENSE TOTALS 7,476,297
Fund 185 - LIBRARY FUND Totals
REVENUE TOTALS 7,693,209
EXPENSE TOTALS 7,476,297
Fund 185 - LIBRARY FUND Totals 216,912
Run by Kate LewisLakin on 07/17/2018 02:10:37 PM Page 5 of 35
June YTD 2017
2018 2018 Actuals
- 157,860 338,897
- - 778,745
- - 7
- 157,860 1,117,649
- - 8,587
- 54,962 1,134,570
- - 112
- 54,962 1,143,269
- 157,860 1,117,649
- 54,962 1,143,269
- 102,898 (25,619)
Starting Fund Balance 4,089 4,089
Net Change 12,386 102,898
Ending Fund Balance 16,475 106,987
June 2018 Financial Report
Through 06/30/18
2018
Classification Budget
Fund 186 - LIBRARY DEBT SERVICE FUND
REVENUE
Property Taxes 345,790
Other Revenue -
Interest Income -
REVENUE TOTALS 345,790
EXPENSE
Interfund Transfers -
EXPENSE TOTALS 333,404
Services and Supplies -
Debt Service 333,404
EXPENSE TOTALS 333,404
Fund 186 - LIBRARY DEBT SERVICE FUND 12,386
Fund 186 - LIBRARY DEBT SERVICE FUND
REVENUE TOTALS 345,790
Run by Kate LewisLakin on 07/17/2018 02:10:37 PM Page 6 of 35
June YTD 2017
2018 2018 Actuals
- - 1,431,106
- - 1,431,106
- - 30,790
- 6,833 1,091,917
- 6,833 1,122,708
- - 1,431,106
- 6,833 1,122,708
- (6,833) 308,399
Starting Fund Balance 308,399 308,399
Net Change - (6,833)
Ending Fund Balance 308,399 301,566
June 2018 Financial Report
Through 06/30/18
2018
Classification Budget
REVENUE TOTALS 10,095,000
EXPENSE
Fund 187 - LIBRARY CAPITAL IMPROVEMENT FD
REVENUE
Other Revenue 10,095,000
EXPENSE TOTALS 10,095,000
Services and Supplies -
Capital Outlay 10,095,000
Fund 187 - LIBRARY CAPITAL -
Fund 187 - LIBRARY CAPITAL
REVENUE TOTALS 10,095,000
EXPENSE TOTALS 10,095,000
Run by Kate LewisLakin on 07/17/2018 02:10:37 PM Page 7 of 35
June YTD 2017
2018 2018 Actuals
- 16,617 37,641
95 175 -
95 16,793 37,641
3,136 13,581 26,454
- 1,860 1,860
- 4,873 2,642
- - (233)
- 1,744 2,400
388 2,327 4,518
3,524 24,385 37,641
95 16,793 37,641
3,524 24,385 37,641
(3,428) (7,593) -
Starting Fund Balance - -
Net Change 326 (7,593)
Ending Fund Balance 326 (7,593)
June 2018 Financial Report
Through 06/30/18
2018
Classification Budget
Interest Income -
REVENUE TOTALS 95,147
Fund 195 - NEIGHBORHOOD STABILIZATION FUND
REVENUE
Intergovernmental Revenue 95,147
Capital Outlay 7,000
Insurance and Other Chargebacks -
EXPENSE
Salary and Benefits 28,067
Services and Supplies 5,100
Miscellaneous 50,000
Interfund Transfers 4,654
EXPENSE TOTALS 94,821
EXPENSE TOTALS 94,821
Fund 195 - NEIGHBORHOOD 326
Fund 195 - NEIGHBORHOOD
REVENUE TOTALS 95,147
Run by Kate LewisLakin on 07/17/2018 02:10:37 PM Page 8 of 35
June YTD 2017
2018 2018 Actuals
156,982 951,301 1,899,884
3,673 20,158 18,158
160,656 971,459 1,918,041
125,000 750,000 -
79,833 478,995 957,990
204,833 1,228,995 957,990
160,656 971,459 1,918,041
204,833 1,228,995 957,990
(44,177) (257,536) 960,051
Starting Fund Balance 2,373,730 2,373,730
Net Change (535,990) (257,536)
Ending Fund Balance 1,837,740 2,116,194
Fund 200 - MOTOR FUEL TAX FUND
REVENUE
Intergovernmental Revenue 1,910,000
June 2018 Financial Report
Through 06/30/18
2018
Classification Budget
EXPENSE
Capital Outlay 1,500,000
Interest Income 12,000
REVENUE TOTALS 1,922,000
Interfund Transfers 957,990
EXPENSE TOTALS 2,457,990
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
Run by Kate LewisLakin on 07/17/2018 02:10:37 PM Page 9 of 35
June YTD 2017
2018 2018 Actuals
133,216 689,695 978,523
- 863 -
1,889 5,550 7,178
135,105 696,108 985,701
64,440 294,458 585,510
102,919 145,573 239,161
- - 51,670
1,454 8,724 17,448
6,114 36,683 72,977
174,927 485,438 966,766
135,105 696,108 985,701
174,927 485,438 966,766
(39,823) 210,670 18,935
Starting Fund Balance 181,996 181,996
Net Change 8,262 210,670
Ending Fund Balance 190,258 392,666
Fund 205 - EMERGENCY TELEPHONE (E911) FUND
REVENUE
Other Taxes 1,050,700
June 2018 Financial Report
Through 06/30/18
2018
Classification Budget
Other Revenue -
Interest Income 1,000
REVENUE TOTALS 1,051,700
Capital Outlay 55,000
Insurance and Other Chargebacks 17,448
EXPENSE
Salary and Benefits 615,224
Services and Supplies 282,400
Interfund Transfers 73,366
EXPENSE TOTALS 1,043,438
Fund 205 - EMERGENCY TELEPHONE 8,262
Fund 205 - EMERGENCY TELEPHONE
REVENUE TOTALS 1,051,700
EXPENSE TOTALS 1,043,438
Run by Kate LewisLakin on 07/17/2018 02:10:37 PM Page 10 of 35
June 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)
June 2018 Financial Report
Through 06/30/18
2018
Classification Budget
Fund 210 - SPECIAL SERVICE AREA (SSA) #4
REVENUE
Property Taxes 370,000
Interest Income -
EXPENSE TOTALS 370,000
REVENUE TOTALS 370,000
EXPENSE
Services and Supplies 370,000
EXPENSE TOTALS 370,000
Fund 210 - SPECIAL SERVICE AREA (SSA) -
Fund 210 - SPECIAL SERVICE AREA (SSA)
REVENUE TOTALS 370,000
Run by Kate LewisLakin on 07/17/2018 02:10:37 PM Page 11 of 35
June YTD 2017
2018 2018 Actuals
- 14,558 1,906,708
435 1,148 262
435 15,706 1,906,970
49,455 211,300 431,440
- 3,440 3,797
- 14,558 645,289
1,454 8,724 392,279
- - 318,412
8 15,158 95,606
746 4,478 20,145
51,663 257,658 1,906,970
435 15,706 1,906,970
51,663 257,658 1,906,970
(51,228) (241,952) -
Starting Fund Balance 64,107 64,107
Net Change (109,388) (241,952)
Ending Fund Balance (45,281) (177,845)
June 2018 Financial Report
Through 06/30/18
2018
Classification Budget
Intergovernmental Revenue 2,330,124
Other Revenue -
Fund 215 - CDBG FUND
REVENUE
REVENUE TOTALS 2,330,124
EXPENSE
Salary and Benefits 502,898
Community Sponsored Organizations 175,500
Services and Supplies 220,840
Capital Outlay -
Insurance and Other Chargebacks 20,648
Miscellaneous 569,970
Interfund Transfers 949,656
EXPENSE TOTALS 2,439,512
EXPENSE TOTALS 2,439,512
Fund 215 - CDBG FUND Totals (109,388)
Fund 215 - CDBG FUND Totals
REVENUE TOTALS 2,330,124
Run by Kate LewisLakin on 07/17/2018 02:10:37 PM Page 12 of 35
June YTD 2017
2018 2018 Actuals
2,465 21,304 51,369
175 504 3,391
2,640 21,808 54,760
105 64,946 13,070
105 64,946 13,070
2,640 21,808 54,760
105 64,946 13,070
2,535 (43,138) 41,690
Starting Fund Balance 252,612 252,612
Net Change - (43,138)
Ending Fund Balance 252,612 209,474
Fund 220 - CDBG LOAN FUND
REVENUE
Other Revenue 293,000
June 2018 Financial Report
Through 06/30/18
2018
Classification Budget
Interest Income -
REVENUE TOTALS 293,000
EXPENSE
EXPENSE TOTALS 293,000
Services and Supplies 293,000
Fund 220 - CDBG LOAN FUND Totals -
Fund 220 - CDBG LOAN FUND Totals
REVENUE TOTALS 293,000
EXPENSE TOTALS 293,000
Run by Kate LewisLakin on 07/17/2018 02:10:37 PM Page 13 of 35
June YTD 2017
2018 2018 Actuals
153 247 256
153 247 256
- - -
- - -
153 247 256
- - -
153 247 256
Starting Fund Balance 170,171 170,171
Net Change (100,000) 247
Ending Fund Balance 70,171 170,418
Fund 235 - NEIGHBORHOOD IMPROVEMENT
REVENUE
June 2018 Financial Report
Through 06/30/18
2018
Classification Budget
Miscellaneous 100,000
EXPENSE TOTALS 100,000
Interest Income -
REVENUE TOTALS -
EXPENSE
EXPENSE TOTALS 100,000
Fund 235 - NEIGHBORHOOD (100,000)
Fund 235 - NEIGHBORHOOD
REVENUE TOTALS -
Run by Kate LewisLakin on 07/17/2018 02:10:37 PM Page 14 of 35
June YTD 2017
2018 2018 Actuals
35,503 83,655 227,450
7,431 18,966 21,820
16 49 5,685
42,949 102,670 254,955
3,632 18,607 43,994
40,000 98,262 231,806
68 410 (27,871)
- - 126
43,700 117,279 248,055
42,949 102,670 254,955
43,700 117,279 248,055
(751) (14,609) 6,900
Starting Fund Balance 9,277 9,277
Net Change 615 (14,609)
Ending Fund Balance 9,892 (5,332)
June 2018 Financial Report
Through 06/30/18
2018
Classification Budget
Fund 240 - HOME FUND
REVENUE
Intergovernmental Revenue 588,936
Other Revenue -
Salary and Benefits 46,801
Services and Supplies 540,200
Interest Income -
REVENUE TOTALS 588,936
EXPENSE
Miscellaneous 500
EXPENSE TOTALS 588,321
Insurance and Other Chargebacks 820
EXPENSE TOTALS 588,321
Fund 240 - HOME FUND Totals 615
Fund 240 - HOME FUND Totals
REVENUE TOTALS 588,936
Run by Kate LewisLakin on 07/17/2018 02:10:37 PM Page 15 of 35
June YTD 2017
2018 2018 Actuals
- 30,000 97,000
417 65,000 333,056
2,072 4,891 5,623
2,489 99,891 435,678
9,140 40,395 44,432
33,918 33,918 209,772
- - 11,532
- 2,398 8,927
155 14,407 85,660
43,213 91,117 360,323
2,489 99,891 435,678
43,213 91,117 360,323
(40,725) 8,774 75,355
Starting Fund Balance 1,476,544 1,476,544
Net Change (38,470) 8,774
Ending Fund Balance 1,438,074 1,485,318
June 2018 Financial Report
Through 06/30/18
2018
Classification Budget
Other Revenue 400,600
Interest Income 230
Fund 250 - AFFORDABLE HOUSING FUND
REVENUE
Other Taxes 50,000
Services and Supplies 279,500
Insurance and Other Chargebacks -
REVENUE TOTALS 450,830
EXPENSE
Salary and Benefits 96,800
EXPENSE TOTALS 489,300
Community Sponsored Organizations 70,000
Miscellaneous 43,000
Fund 250 - AFFORDABLE HOUSING FUND (38,470)
Fund 250 - AFFORDABLE HOUSING FUND
REVENUE TOTALS 450,830
EXPENSE TOTALS 489,300
Run by Kate LewisLakin on 07/17/2018 02:10:37 PM Page 16 of 35
June YTD 2017
2018 2018 Actuals
- 2,974,454 5,249,949
3,146 17,777 45,924
3,146 2,992,230 5,295,873
- - 2,007
- 24,668 98,672
592,253 3,553,520 5,557,325
592,253 3,578,188 5,658,005
3,146 2,992,230 5,295,873
592,253 3,578,188 5,658,005
(589,107) (585,958) (362,132)
Starting Fund Balance 5,262,544 5,262,544
Net Change (3,437,040) (585,958)
Ending Fund Balance 1,825,504 4,676,586
June 2018 Financial Report
Through 06/30/18
2018
Classification Budget
Interest Income 20,000
Fund 300 - WASHINGTON NATIONAL TIF FUND
REVENUE
Property Taxes 5,750,000
Services and Supplies 2,000,000
REVENUE TOTALS 5,770,000
EXPENSE
Miscellaneous 100,000
Interfund Transfers 7,107,040
EXPENSE TOTALS 9,207,040
EXPENSE TOTALS 9,207,040
Fund 300 - WASHINGTON NATIONAL TIF (3,437,040)
Fund 300 - WASHINGTON NATIONAL TIF
REVENUE TOTALS 5,770,000
Run by Kate LewisLakin on 07/17/2018 02:10:37 PM Page 17 of 35
June YTD 2017
2018 2018 Actuals
- 4,880,787 10,797,411
288,930 1,733,577 2,895,561
7,219 43,312 -
- - 8,966,396
11,765 33,380 36,782
307,913 6,691,056 22,696,150
- - 100,625
- 2,055,360 23,099,797
- - (57)
- 2,055,360 23,200,365
307,913 6,691,056 22,696,150
- 2,055,360 23,200,365
307,913 4,635,695 (504,215)
Starting Fund Balance 241,781 241,781
Net Change 128,349 4,635,695
Ending Fund Balance 370,130 4,877,476
June 2018 Financial Report
Through 06/30/18
2018
Classification Budget
Fund 320 - DEBT SERVICE FUND
REVENUE
Property Taxes 10,879,993
Interfund Transfers 3,460,821
Intergovernmental Revenue 83,292
Other Revenue -
Interest Income 1,500
Debt Service 14,177,257
Miscellaneous -
REVENUE TOTALS 14,425,606
EXPENSE
Services and Supplies 120,000
EXPENSE TOTALS 14,297,257
Fund 320 - DEBT SERVICE FUND Totals
REVENUE TOTALS 14,425,606
EXPENSE TOTALS 14,297,257
Fund 320 - DEBT SERVICE FUND Totals 128,349
Run by Kate LewisLakin on 07/17/2018 02:10:37 PM Page 18 of 35
June YTD 2017
2018 2018 Actuals
- 318,714 583,827
10,569 28,074 32,000
- 62 22
10,569 346,849 615,848
1,516 229,038 307,391
130,815 755,815 -
108 626 995
5,000 30,000 60,000
137,439 1,015,479 368,386
10,569 346,849 615,848
137,439 1,015,479 368,386
(126,871) (668,630) 247,462
Starting Fund Balance 247,378 247,378
Net Change (296,100) (668,630)
Ending Fund Balance (48,722) (421,252)
June 2018 Financial Report
Through 06/30/18
2018
Classification Budget
Fund 330 - HOWARD-RIDGE TIF FUND
REVENUE
Property Taxes 605,000
Other Revenue 3,780,000
Interest Income 400
REVENUE TOTALS 4,385,400
EXPENSE
Debt Service 960,000
Services and Supplies 461,500
Capital Outlay 3,200,000
Interfund Transfers 60,000
EXPENSE TOTALS 4,681,500
Fund 330 - HOWARD-RIDGE TIF FUND (296,100)
Fund 330 - HOWARD-RIDGE TIF FUND
REVENUE TOTALS 4,385,400
EXPENSE TOTALS 4,681,500
Run by Kate LewisLakin on 07/17/2018 02:10:37 PM Page 19 of 35
June YTD 2017
2018 2018 Actuals
- 43,175 43,503
1,028 5,141 12,339
769 3,423 3,898
1,798 51,739 59,741
1,032 1,032 2,007
1,323 7,694 12,227
2,500 15,000 30,000
4,855 23,726 44,235
1,798 51,739 59,741
4,855 23,726 44,235
(3,057) 28,013 15,506
Starting Fund Balance 432,766 432,766
Net Change (39,850) 28,013
Ending Fund Balance 392,916 460,779
June 2018 Financial Report
Through 06/30/18
2018
Classification Budget
Fund 335 - WEST EVANSTON TIF FUND
REVENUE
Property Taxes -
Other Revenue -
Debt Service 10,000
Services and Supplies -
Interest Income 150
REVENUE TOTALS 150
EXPENSE
Interfund Transfers 30,000
EXPENSE TOTALS 40,000
Fund 335 - WEST EVANSTON TIF FUND (39,850)
Fund 335 - WEST EVANSTON TIF FUND
REVENUE TOTALS 150
EXPENSE TOTALS 40,000
Run by Kate LewisLakin on 07/17/2018 02:10:37 PM Page 20 of 35
June YTD 2017
2018 2018 Actuals
- 26,401 48,001
- - 2,067,512
- 3 1
- 26,404 2,115,514
1,032 1,032 38,588
- - 2,053,521
1,032 1,032 2,092,108
- 26,404 2,115,514
1,032 1,032 2,092,108
(1,032) 25,372 23,406
Starting Fund Balance (6,009) (6,009)
Net Change 202,334 25,372
Ending Fund Balance 196,325 19,363
June 2018 Financial Report
Through 06/30/18
2018
Classification Budget
Fund 340 - DEMPSTER-DODGE TIF FUND
REVENUE
Property Taxes 275,000
Other Revenue -
Services and Supplies -
Debt Service 72,666
Interest Income -
REVENUE TOTALS 275,000
EXPENSE
EXPENSE TOTALS 72,666
Fund 340 - DEMPSTER-DODGE TIF FUND
REVENUE TOTALS 275,000
EXPENSE TOTALS 72,666
Fund 340 - DEMPSTER-DODGE TIF FUND 202,334
Run by Kate LewisLakin on 07/17/2018 02:10:37 PM Page 21 of 35
June YTD 2017
2018 2018 Actuals
- 31,307 75,430
- - 3,520,189
- 4 9
- 31,310 3,595,628
1,032 1,032 58,113
- - 580,000
- - 3,031,398
1,032 1,032 3,669,511
- 31,310 3,595,628
1,032 1,032 3,669,511
(1,032) 30,278 (73,884)
Starting Fund Balance 61,193 61,193
Net Change 316,001 30,278
Ending Fund Balance 377,194 91,471
June 2018 Financial Report
Through 06/30/18
2018
Classification Budget
Fund 345 - CHICAGO-MAIN TIF
REVENUE
Property Taxes 425,000
Other Revenue -
Interest Income -
REVENUE TOTALS 425,000
EXPENSE
Services and Supplies -
Capital Outlay -
Debt Service 108,999
EXPENSE TOTALS 108,999
Fund 345 - CHICAGO-MAIN TIF Totals
REVENUE TOTALS 425,000
EXPENSE TOTALS 108,999
Fund 345 - CHICAGO-MAIN TIF Totals 316,001
Run by Kate LewisLakin on 07/17/2018 02:10:37 PM Page 22 of 35
June YTD 2017
2018 2018 Actuals
(107,000) 10,233 215,245
- 18 21
(107,000) 10,251 215,266
- - 213,354
- - 78,000
- - 291,354
(107,000) 10,251 215,266
- - 291,354
(107,000) 10,251 (76,088)
Starting Fund Balance 2,207 2,207
Net Change - 10,251
Ending Fund Balance 2,207 12,458
June 2018 Financial Report
Through 06/30/18
2018
Classification Budget
Fund 350 - SPECIAL SERVICE AREA (SSA) #6
REVENUE
Property Taxes 221,000
Interest Income 500
REVENUE TOTALS 221,500
EXPENSE
Services and Supplies 221,500
Interfund Transfers -
EXPENSE TOTALS 221,500
Fund 350 - SPECIAL SERVICE AREA (SSA) -
Fund 350 - SPECIAL SERVICE AREA (SSA)
REVENUE TOTALS 221,500
EXPENSE TOTALS 221,500
Run by Kate LewisLakin on 07/17/2018 02:10:37 PM Page 23 of 35
June YTD 2017
2018 2018 Actuals
- - 359,706
27,239 27,239 33,339
536,667 3,220,000 787,177
- 51,221 530,812
- - 11,246,149
14,228 56,019 56,607
578,133 3,354,479 13,013,790
71,772 306,061 5,392
82,805 381,158 1,672,608
1,608,903 4,854,203 13,582,482
41,667 250,000 500,000
1,805,146 5,791,422 15,760,481
578,133 3,354,479 13,013,790
1,805,146 5,791,422 15,760,481
(1,227,012) (2,436,943) (2,746,691)
Starting Fund Balance 8,758,473 8,758,473
Net Change (7,655,527) (2,436,943)
Ending Fund Balance 1,102,946 6,321,530
June 2018 Financial Report
Through 06/30/18
2018
Classification Budget
Fund 415 - CAPITAL IMPROVEMENTS FUND
REVENUE
Licenses, Permits and Fees -
Charges for Services -
Interfund Transfers 6,450,000
Intergovernmental Revenue 4,190,000
Other Revenue 12,002,000
Interest Income -
REVENUE TOTALS 22,642,000
EXPENSE
Interfund Transfers 500,000
Salary and Benefits 85,527
Services and Supplies -
Capital Outlay 29,712,000
EXPENSE TOTALS 30,297,527
Fund 415 - CAPITAL IMPROVEMENTS
REVENUE TOTALS 22,642,000
EXPENSE TOTALS 30,297,527
Fund 415 - CAPITAL IMPROVEMENTS (7,655,527)
Run by Kate LewisLakin on 07/17/2018 02:10:37 PM Page 24 of 35
June YTD 2017
2018 2018 Actuals
- - 649,512
- - 900,000
- - -
- - 1,549,512
493,444 1,009,400 638,727
- 11,770 369,924
493,444 1,021,170 1,008,651
- - 1,549,512
493,444 1,021,170 1,008,651
(493,444) (1,021,170) 540,861
Starting Fund Balance 540,861 540,861
Net Change 1,866,000 (1,021,170)
Ending Fund Balance 2,406,861 (480,309)
June 2018 Financial Report
Through 06/30/18
2018
Classification Budget
Fund 416 - CROWN CONSTRUCTION FUND
REVENUE
Interfund Transfers -
Other Revenue 11,500,000
Services and Supplies 1,634,000
Capital Outlay 8,000,000
Interest Income -
REVENUE TOTALS 11,500,000
EXPENSE
EXPENSE TOTALS 9,634,000
Fund 416 - CROWN CONSTRUCTION
REVENUE TOTALS 11,500,000
EXPENSE TOTALS 9,634,000
Fund 416 - CROWN CONSTRUCTION 1,866,000
Run by Kate LewisLakin on 07/17/2018 02:10:37 PM Page 25 of 35
June YTD 2017
2018 2018 Actuals
- - -
3,928 20,268 31,207
2,535 112,065 237,012
6,464 132,333 268,219
8,188 34,793 694
- - 5,613
42,786 256,713 263,427
50,973 291,507 269,734
6,464 132,333 268,219
50,973 291,507 269,734
(44,510) (159,173) (1,516)
Starting Fund Balance 2,997,700 2,997,700
Net Change (123,850) (159,173)
Ending Fund Balance 2,873,850 2,838,527
Fund 420 - SPECIAL ASSESSMENT FUND
REVENUE
June 2018 Financial Report
Through 06/30/18
2018
Classification Budget
Interest Income 31,200
Special Assessment 180,167
Other Revenue 250,000
Interfund Transfers 513,427
Services and Supplies -
REVENUE TOTALS 461,367
EXPENSE
Salary and Benefits 71,790
EXPENSE TOTALS 585,217
Fund 420 - SPECIAL ASSESSMENT FUND
REVENUE TOTALS 461,367
EXPENSE TOTALS 585,217
Fund 420 - SPECIAL ASSESSMENT FUND (123,850)
Run by Kate LewisLakin on 07/17/2018 02:10:37 PM Page 26 of 35
June YTD 2017
2018 2018 Actuals
150 2,068 1,900
237,519 3,597,378 6,303,624
347,253 2,083,520 4,120,636
- - -
14,014 117,589 253,523
10,192 31,494 62,067
609,129 5,832,048 10,741,750
197,736 849,280 1,675,404
667,331 1,574,931 3,172,070
18,740 162,562 280,311
26,637 159,824 319,648
- - 2,561,771
- - 4,246
- 53,131 267,734
11,890 89,464 267,436
120,035 720,209 1,584,683
1,042,370 3,609,400 10,133,302
609,129 5,832,048 10,741,750
1,042,370 3,609,400 10,133,302
(433,241) 2,222,648 608,448
Starting Fund Balance 4,710,701 4,710,701
Net Change (1,762,367) 2,222,648
Ending Fund Balance 2,948,334 6,933,349
June 2018 Financial Report
Through 06/30/18
2018
Classification Budget
Licenses, Permits and Fees -
Charges for Services 6,676,575
Fund 505 - PARKING SYSTEM FUND
REVENUE
Interfund Transfers 4,217,040
Intergovernmental Revenue 12,125
Other Revenue 193,316
Interest Income 35,070
REVENUE TOTALS 11,134,126
EXPENSE
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
Contingencies 11,000
Debt Service 3,070,625
Miscellaneous 304,000
Interfund Transfers 1,440,417
EXPENSE TOTALS 12,896,493
Fund 505 - PARKING SYSTEM FUND (1,762,367)
Fund 505 - PARKING SYSTEM FUND
REVENUE TOTALS 11,134,126
EXPENSE TOTALS 12,896,493
Run by Kate LewisLakin on 07/17/2018 02:10:37 PM Page 27 of 35
June YTD 2017
2018 2018 Actuals
7,400 24,792 86,063
1,578,117 9,468,152 17,255,947
5,955 37,503 294,812
23,996 89,930 35,784
1,615,468 9,620,377 17,672,605
626,902 2,656,603 5,958,873
278,359 1,317,309 2,528,863
86,380 515,806 11,408
39,041 234,246 468,492
- - 2,470,280
- - -
- 465,369 717,388
- - (203,530)
306,859 1,841,155 6,327,314
1,337,541 7,030,488 18,279,088
1,615,468 9,620,377 17,672,605
1,337,541 7,030,488 18,279,088
277,926 2,589,890 (606,483)
Starting Fund Balance 6,562,795 6,562,795
Net Change 32,150 2,589,890
Ending Fund Balance 6,594,945 9,152,685
June 2018 Financial Report
Through 06/30/18
2018
Classification Budget
Charges for Services 18,267,000
Fund 510 - WATER FUND
REVENUE
Licenses, Permits and Fees 70,000
Other Revenue 27,333,656
Interest Income 25,000
REVENUE TOTALS 45,695,656
Capital Outlay 29,346,200
Insurance and Other Chargebacks 468,492
EXPENSE
Salary and Benefits 5,614,331
Services and Supplies 4,655,410
Depreciation Expense -
Contingencies 1,000
Debt Service 1,960,760
Miscellaneous 15,000
Interfund Transfers 3,602,313
EXPENSE TOTALS 45,663,506
EXPENSE TOTALS 45,663,506
Fund 510 - WATER FUND Totals 32,150
Fund 510 - WATER FUND Totals
REVENUE TOTALS 45,695,656
Run by Kate LewisLakin on 07/17/2018 02:10:37 PM Page 28 of 35
June YTD 2017
2018 2018 Actuals
1,121,974 6,115,767 12,477,657
- - 14,870
2,973 14,825 16,023
1,124,947 6,130,593 12,508,550
145,880 630,852 1,313,154
9,432 37,497 88,677
235,061 293,764 7,676
22,499 134,994 269,988
- - 3,530,787
363,136 3,554,302 1,143,643
- - 9,265
82,640 495,839 1,141,676
858,648 5,147,247 7,504,867
1,124,947 6,130,593 12,508,550
858,648 5,147,247 7,504,867
266,299 983,345 5,003,683
Starting Fund Balance 4,037,755 4,037,755
Net Change (119,220) 983,345
Ending Fund Balance 3,918,535 5,021,100
Fund 515 - SEWER FUND
REVENUE
Charges for Services 12,589,650
June 2018 Financial Report
Through 06/30/18
2018
Classification Budget
Other Revenue 2,104,000
Interest Income 5,000
REVENUE TOTALS 14,698,650
EXPENSE
Salary and Benefits 1,274,709
Services and Supplies 2,558,630
Debt Service 7,540,066
Miscellaneous 1,500
Capital Outlay 2,181,300
Insurance and Other Chargebacks 269,988
Depreciation Expense -
Interfund Transfers 991,677
EXPENSE TOTALS 14,817,870
Fund 515 - SEWER FUND Totals (119,220)
Fund 515 - SEWER FUND Totals
REVENUE TOTALS 14,698,650
EXPENSE TOTALS 14,817,870
Run by Kate LewisLakin on 07/17/2018 02:10:37 PM Page 29 of 35
June YTD 2017
2018 2018 Actuals
- 267,563 -
41,638 56,086 199,513
290,629 1,784,029 3,611,308
58,831 352,983 755,967
14,227 43,088 250,687
405,325 2,503,749 4,817,475
99,358 446,463 890,220
314,882 1,600,479 3,482,141
1,827 7,023 24,635
- 665 1,797
- 3,688 3,057
26,864 161,181 504,807
442,931 2,219,498 4,906,657
405,325 2,503,749 4,817,475
442,931 2,219,498 4,906,657
(37,606) 284,251 (89,182)
Starting Fund Balance (1,061,966) (1,061,966)
Net Change 151,660 284,251
Ending Fund Balance (910,306) (777,715)
June 2018 Financial Report
Through 06/30/18
2018
Classification Budget
Fund 520 - SOLID WASTE FUND
REVENUE
Property Taxes 410,000
Licenses, Permits and Fees 275,000
Other Revenue 238,000
REVENUE TOTALS 5,261,361
Charges for Services 3,632,394
Interfund Transfers 705,967
Debt Service 21,797
Capital Outlay 275,750
EXPENSE
Salary and Benefits 993,616
Services and Supplies 3,488,676
Miscellaneous 7,500
Interfund Transfers 322,362
EXPENSE TOTALS 5,109,701
EXPENSE TOTALS 5,109,701
Fund 520 - SOLID WASTE FUND Totals 151,660
Fund 520 - SOLID WASTE FUND Totals
REVENUE TOTALS 5,261,361
Run by Kate LewisLakin on 07/17/2018 02:10:37 PM Page 30 of 35
June YTD 2017
2018 2018 Actuals
249,053 1,494,320 2,478,435
3,794 10,894 19,016
- 24 339
252,847 1,505,238 2,497,791
116,121 508,561 1,154,569
131,571 977,484 1,744,972
- - -
2,787 16,721 27,833
250,479 1,502,766 2,927,375
252,847 1,505,238 2,497,791
250,479 1,502,766 2,927,375
2,368 2,472 (429,584)
Starting Fund Balance 341,343 341,343
Net Change (262,450) 2,472
Ending Fund Balance 78,893 343,815
June 2018 Financial Report
Through 06/30/18
2018
Classification Budget
Other Revenue 81,781
Interest Income 1,000
Fund 600 - FLEET SERVICES FUND
REVENUE
Charges for Services 2,988,640
Services and Supplies 2,230,057
REVENUE TOTALS 3,071,421
EXPENSE
Salary and Benefits 1,069,922
Interfund Transfers 33,442
EXPENSE TOTALS 3,333,871
Contingencies 450
EXPENSE TOTALS 3,333,871
Fund 600 - FLEET SERVICES FUND Totals (262,450)
Fund 600 - FLEET SERVICES FUND Totals
REVENUE TOTALS 3,071,421
Run by Kate LewisLakin on 07/17/2018 02:10:37 PM Page 31 of 35
June YTD 2017
2018 2018 Actuals
111,228 667,366 1,400,057
- 19,758 88,015
490 949 2,128
111,718 688,073 1,490,200
3,580 13,284 74,539
- 627,527 -
- - 1,780,829
3,580 640,811 1,855,367
111,718 688,073 1,490,200
3,580 640,811 1,855,367
108,138 47,262 (365,167)
Starting Fund Balance 849,519 849,519
Net Change (53,028) 47,262
Ending Fund Balance 796,491 896,781
Fund 601 - EQUIPMENT REPLACEMENT FUND
REVENUE
Charges for Services 1,334,732
June 2018 Financial Report
Through 06/30/18
2018
Classification Budget
Other Revenue 210,217
Interest Income -
REVENUE TOTALS 1,544,949
Depreciation Expense -
EXPENSE TOTALS 1,597,977
EXPENSE
Services and Supplies 75,000
Capital Outlay 1,522,977
EXPENSE TOTALS 1,597,977
Fund 601 - EQUIPMENT REPLACEMENT (53,028)
Fund 601 - EQUIPMENT REPLACEMENT
REVENUE TOTALS 1,544,949
Run by Kate LewisLakin on 07/17/2018 02:10:37 PM Page 32 of 35
June YTD 2017
2018 2018 Actuals
13,534 86,486 162,411
- - 2,300,000
872,463 5,026,938 10,926,377
169,360 1,032,478 1,032,678
515,848 2,820,217 5,611,626
1,146 1,791 382
1,572,351 8,967,911 20,033,473
15,192 319,992 606,021
81,603 1,172,070 3,594,432
1,317,469 8,249,485 17,164,869
803 4,816 9,632
1,415,067 9,746,364 21,374,954
1,572,351 8,967,911 20,033,473
1,415,067 9,746,364 21,374,954
157,284 (778,453) (1,341,481)
Starting Fund Balance (4,338,505) (4,338,505)
Net Change 653,342 (778,453)
Ending Fund Balance (3,685,163) (5,116,958)
June 2018 Financial Report
Through 06/30/18
2018
Classification Budget
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
Insurance 5,811,177
Interest Income 1,000
REVENUE TOTALS 19,093,273
EXPENSE
Salary and Benefits 729,027
Services and Supplies 2,385,448
Interfund Transfers 9,632
EXPENSE TOTALS 18,439,931
Insurance and Other Chargebacks 15,315,824
EXPENSE TOTALS 18,439,931
Fund 605 - INSURANCE FUND Totals 653,342
Fund 605 - INSURANCE FUND Totals
REVENUE TOTALS 19,093,273
Run by Kate LewisLakin on 07/17/2018 02:10:37 PM Page 33 of 35
June YTD 2017
2018 2018 Actuals
- - -
- - -
103,715 4,529,650 15,225,459
203,122 781,670 2,065,885
306,837 5,311,320 17,291,343
771,059 4,539,531 8,682,009
3,959 25,372 136,256
775,018 4,564,903 8,818,265
306,837 5,311,320 17,291,343
775,018 4,564,903 8,818,265
(468,181) 746,416 8,473,079
Starting Fund Balance 79,073,077 79,073,077
Net Change 4,989,947 746,416
Ending Fund Balance 84,063,024 79,819,493
Fund 700 - FIRE PENSION FUND
REVENUE
Other Taxes 280,000
June 2018 Financial Report
Through 06/30/18
2018
Classification Budget
Interfund Transfers 10,000
Other Revenue 9,394,947
Interest Income 4,100,000
REVENUE TOTALS 13,784,947
EXPENSE
Salary and Benefits 8,795,000
Miscellaneous -
EXPENSE TOTALS 8,795,000
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
Run by Kate LewisLakin on 07/17/2018 02:10:37 PM Page 34 of 35
June YTD 2017
2018 2018 Actuals
- - -
(32,416) 6,295,685 24,497,983
473,649 1,417,844 2,829,084
441,232 7,713,529 27,327,068
1,015,966 5,971,477 11,624,574
- 125,463 264,371
1,015,966 6,096,940 11,888,945
441,232 7,713,529 27,327,068
1,015,966 6,096,940 11,888,945
(574,734) 1,616,588 15,438,122
Starting Fund Balance 121,629,667 121,629,667
Net Change 6,194,704 1,616,588
Ending Fund Balance 127,824,371 123,246,255
Fund 705 - POLICE PENSION FUND
REVENUE
June 2018 Financial Report
Through 06/30/18
2018
Classification Budget
Interfund Transfers 57,000
Other Revenue 12,162,704
Interest Income 6,500,000
Miscellaneous 270,000
REVENUE TOTALS 18,719,704
EXPENSE
Salary and Benefits 12,255,000
EXPENSE TOTALS 12,525,000
Fund 705 - POLICE PENSION FUND Totals
REVENUE TOTALS 18,719,704
EXPENSE TOTALS 12,525,000
Fund 705 - POLICE PENSION FUND Totals 6,194,704
Run by Kate LewisLakin on 07/17/2018 02:10:37 PM Page 35 of 35