Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2017.09 September Monthly Report
To: Wally Bobkiewicz, City Manager Martin Lyons, Assistant City Manager/Chief Financial Officer From: Ashley King, Finance & Budget Manager Subject: September 2017 Monthly Financial Report Date: November 1, 2017 Please find attached the unaudited financial statements as of September 30, 2017. A summary by fund for revenues, expenditures, fund and cash balances is as follows: YTD Revenues YTD Expenses YTD Net Fund Balance Cash Balance 87,484,657 87,354,657 130,001 14,723,355 8,595,629 644,365 509,204 135,161 205,967 205,967 949,293 671,492 277,801 864,189 864,189 1,000,000 750,000 250,000 250,000 1,250,000 6,655,851 4,788,069 1,867,783 2,518,438 2,518,400 131 30,962 (30,831)(30,831) 101,579 1,447,647 643,493 804,154 2,217,832 2,041,131 754,104 707,091 47,012 210,073 (115,398) 321,688 246,750 74,938 (117,338) (117,338) 128,654 647,015 (518,361)(454,255) (454,254) 71,321 25,345 45,976 256,897 256,897 - - - 169,915 169,915 273,090 323,498 (50,408)(48,031) (48,031) 152,136 302,722 (150,586)1,250,602 1,250,602 5,256,862 3,334,186 1,922,676 7,547,352 7,626,271 (44,005) 599,668 (643,672)- - 675,807 351,930 323,877 323,793 326,062 53,953 32,007 21,947 439,207 447,529 48,003 46,935 1,068 (28,347) (28,347) 595,433 602,194 (6,761)128,316 128,316 214,101 116,356 97,745 176,039 176,040 13,026,080 1,982,953 11,043,127 11,789,124 11,803,921 338,904 38,227 300,677 330,386 317,480 2,043,482 6,885,041 (4,841,560)6,663,604 7,528,218 - 850,739 (850,739)(850,739) (850,739) 210,865 197,570 13,295 3,012,511 3,008,974 7,017,436 6,645,095 372,341 8,125,005 7,746,262 13,454,536 11,478,378 1,976,158 9,512,235 7,139,598 9,701,233 8,924,815 776,418 5,388,516 3,083,449 3,670,652 3,536,905 133,748 (839,035) (1,485,479) 2,569,382 2,160,211 409,171 1,171,915 464,220 1,220,613 534,554 686,059 1,571,392 1,571,392 13,079,524 14,077,728 (998,204) (3,995,229)(404,861) 173,015,799 159,395,788 13,620,011 72,482,859 65,117,594 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 235 NEIGHBORHOOD IMPROVEMENT 240 HOME FUND 250 AFFORDABLE HOUSING FUND 300 WASHINGTON NATIONAL TIF 310 HOWARD-HARTREY 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 320 DEBT SERVICE FUND 186 LIBRARY DEBT SERVICE FUND 415 CAPITAL IMPROVEMENTS FUND 187 LIBRARY CAPITAL IMPROVEMENT 420 SPECIAL ASSESSMENT FUND 505 PARKING SYSTEM FUND 510 WATER FUND 515 SEWER FUND 605 INSURANCE FUND 520 SOLID WASTE FUND 600 FLEET SERVICES FUND 601 EQUIPMENT REPLACEMENT FUND Memorandum Included above are the ending balances as of September 30, 2017 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. During the 2016 Audit Process, a number of changes were made to the methodology behind Evanston’s financial reporting. As a result, 2017 fund balances since April look significantly different than those presented previously. In most instances, they are more closely aligned with cash. As of September 30, 2017, the General Fund is reporting a net surplus of $130,001. The General Fund balance is $14,723,355 with a cash balance of $8,595,629. The attached supplemental charts show the General Fund Revenues at 73.65% of budget and expenses slightly lower at 73.60%. As of September 30, property tax revenues received are at 98% of budget. Through September 30, 2017, the Neighborhood Stabilization Fund is showing a negative fund balance of $30,831. This is due to the timing of grant funding revenues. Through September 30, 2017, the E911 Fund is showing negative cash balance of $115,398. This is due to timing of E911 revenues from the state and the expenses related to the replacement of Computer Aided Dispatch (CAD) and Police/Fire Records Software. Staff will monitor the fund for the remainder of the year to ensure a positive ending balance. Through September 30, 2017, the SSA #4 Fund is showing a negative fund and cash balance of $117,338. This is due to the timing of payments to the Downtown Evanston group. Through September 30, 2017, the CDBG Fund is showing a negative fund and cash balance of $454,254. This is reimbursed with draw-downs in October. Through September 30, 2017, the Home Fund is showing a negative fund and cash balance of $48,031. This is reimbursed with draw-downs in October. Through September 30, 2017, the Dempster-Dodge TIF Fund is showing a negative fund and cash balance of $28,347. This is due to the payment of interest on the Line of Credit. This negative balance was mitigated by the first receipt of TIF increment property taxes in August and will be move closer to balance with September receipts. Through September 30, 2017, the Capital Fund is showing a fund balance of $6,663,604 and a cash balance of $7,528,218. Bond proceeds from the 2017A General Obligation Bonds were received in October and will increase revenue received in this fund. Through September 30, 2017, the Library Capital Improvements Fund is showing a negative fund and cash balance of $850,739. The 2017A General Obligation Bonds included $1.4 million in bonds for Library Capital Projects as noted in the September 11, 2017 Council Jan Feb Mar Apr May Jun Jul Aug Sept 2016 Unreserved Fund Balance 11,859,782 14,097,256 17,193,730 16,597,583 18,375,173 21,225,995 15,790,000 17,674,579 15,983,833 2017 Unreserved Fund Balance 15,453,984 17,244,431 19,734,012 18,292,843 17,839,404 14,612,957 13,603,487 16,910,096 14,723,355 2016 Cash Balance 3,656,830 2,587,845 8,182,090 7,808,208 7,101,333 12,919,440 10,046,315 10,473,240 9,442,294 2017 Cash Balance 6,338,271 6,393,110 11,561,044 10,901,398 10,376,936 6,169,276 7,179,518 10,652,102 8,595,629 2016 v 2017 Fund and Cash Balance-- General Fund - 5,000,000 10,000,000 15,000,000 20,000,000 25,000,000 2016 Unreserved Fund Balance 2017 Unreserved Fund Balance 2016 Cash Balance 2017 Cash Balance 2017 September YTD 2016 Budget 2017 Actual %Actual 28,639,628 62,673 28,030,940 97.87% 27,302,687 49,402,274 3,090,978 34,014,975 68.85% 44,156,868 5,496,150 98,835 2,356,241 42.87% 6,851,422 11,648,000 566,367 6,090,377 52.29% 11,012,646 115,500 50,450 147,908 128.06% 70,395 3,810,000 338,878 2,435,355 63.92% 3,611,901 640,000 53,333 502,214 78.47% 687,835 5,650,895 314,047 4,805,670 85.04% 5,401,563 2,642,500 182,154 1,902,305 71.99% 2,687,897 7,455,774 606,476 5,458,287 73.21% 8,099,626 1,089,965 76,606 1,074,497 98.58% 1,238,785 2,138,046 206,067 634,964 29.70% 1,338,382 50,100 7,478 30,925 61.73% 30,285 REVENUE TOTAL 118,778,832 5,654,341 87,484,657 73.65% 112,490,292 CITY COUNCIL 498,189.26 40,532.83 357,288.50 71.72%433,601.01 CITY CLERK 275,488.00 19,691.04 197,185.43 71.58%294,664.86 CITY MANAGER'S OFFICE 9,878,454.00 806,952.23 5,232,516.47 52.97%7,471,733.90 LAW 854,050.00 62,579.28 555,271.73 65.02%1,052,130.01 ADMINISTRATIVE SERVICES 9,700,879.00 735,345.68 6,475,655.46 66.75%9,164,946.70 COMMUNITY DEVELOPMENT 2,804,668.00 226,693.36 1,783,724.54 63.60%2,510,408.43 POLICE 38,223,842.00 1,869,228.18 30,599,585.20 80.05%37,817,627.43 FIRE MGMT & SUPPORT 24,294,001.00 974,501.37 19,553,609.90 80.49%23,235,713.69 HEALTH 3,582,312.00 259,459.54 2,259,524.65 63.07%3,097,350.98 PARKS, REC. AND COMMUNITY SERV.12,361,460.00 1,157,847.80 9,389,957.56 75.96%11,997,475.88 PUBLIC WORKS AGENCY 16,212,848.00 1,688,250.97 10,950,337.54 67.54%14,488,136.71 EXPENSE TOTAL 118,686,191 7,841,082 87,354,657 73.60% 11,562,594 118,778,832 5,654,341 87,484,657 73.65% 112,490,292 118,686,191 7,841,082 87,354,657 73.60% 111,562,594 92,641 (2,186,741) 130,001 927,698 REVENUE TOTALS EXPENSE TOTALS Fund 100 - GENERAL FUND Net Gain (Loss) Fund 100 - GENERAL FUND Totals Intergovernmental Revenue Other Revenue Interest Income Parking Charges for Services Parks and Recreation Charges for Services Other Charges for Services Interfund Transfers Fee Fines and Forfeitures Property Taxes Other Taxes License Classification September 2017 Financial Report Through 09/30/17 Summary Listing Fund 100 - GENERAL FUND Permit Fund 505 - PARKING SYSTEM FUND 2017 September YTD 2016 Budget 2017 Actual %Actual - 50 1,900 - 3,350 6,737,875 905,918 4,690,235 69.61% 6,340,992 65,000 - 61,000 93.85% 168,500 4,120,636 - 2,060,318 50.00% 3,711,768 12,125 - - 0.00% - 203,216 26,902 163,637 80.52% 195,895 35,070 6,691 40,347 115.05% 38,159 REVENUE TOTAL 11,173,922 939,560 7,017,436 62.80% 10,458,663 26,000 906 22,174 85.29% 26,465 1,117,119 90,780 771,508 69.06% 1,206,649 104,802 8,477 72,710 69.38% 229,588 3,222,411 210,799 2,167,749 67.27% 2,846,933 278,864 11,030 155,944 55.92% 237,610 3,020,000 659,603 1,789,086 59.24% (24,598) 524,102 48,017 405,406 77.35% 504,784 - - - - 2,836,672 11,000 169 2,527 22.98% 5,910 4,331,771 - 141,632 3.27% 390,235 304,000 11,938 160,346 52.75% 255,626 1,584,683 106,224 956,012 60.33% 1,303,783 EXPENSE TOTAL 14,524,752 1,147,943 6,645,095 45.75% 9,819,656 11,173,922 939,560 7,017,436 62.80% 10,458,663 14,524,752 1,147,943 6,645,095 45.75% 9,819,656 (3,350,830) (208,383) 372,341 639,007 REVENUE TOTALS EXPENSE TOTALS Fund 505 - PARKING SYSTEM FUND Net Gain (Loss) Debt Service Miscellaneous Interfund Transfers Fund 505 - PARKING SYSTEM FUND Totals Capital Outlay Insurance and Other Chargebacks Depreciation Expense Contingencies Pensions Services Supplies Interest Income Employee Pay Benefits Parking Charges for Services Parks and Recreation Charges for Services Interfund Transfers Intergovernmental Revenue September 2017 Financial Report Through 09/30/17 Summary Listing Permit Classification Other Revenue Fund 510-513 - WATER FUND 2017 September YTD 2016 Budget 2017 Actual %Actual 70,000 6,123 70,257 100.37% 90,592 17,324,000 1,485,953 12,485,262 72.07% 15,851,052 36,000 4,641 37,119 103.11% 51,737 135,000 428 140,164 103.82% 168,482 6,828,400 57,825 698,022 10.22% 306,143 1,600 3,661 23,711 1481.91% 16,536 REVENUE TOTAL 24,395,000 1,558,632 13,454,536 55.15% 16,484,543 183,365 19,489 126,352 68.91% 193,328 4,037,387 298,576 2,894,321 71.69% 3,898,385 368,658 29,037 274,110 74.35% 888,372 2,250,760 303,855 1,320,708 58.68% 1,743,992 1,360,390 72,412 583,348 42.88% 876,885 14,982,119 385,553 2,370,203 15.82% 36,713 1,174,064 97,268 860,832 73.32% 1,110,835 - - - - 1,973,593 1,000 - - - 1,000 1,438,470 - 421,769 29.32% 633,708 62,980 - - - 238,468 3,502,313 291,859 2,626,735 75.00% 3,502,313 EXPENSE TOTAL 29,361,507 1,498,050 11,478,378 39.09% 15,097,592 24,395,000 1,558,632 13,454,536 55.15% 16,484,543 29,361,507 1,498,050 11,478,378 39.09% 15,097,592 (4,966,507) 60,582 1,976,158 1,386,951 Services Supplies EXPENSE TOTALS Fund 510 - WATER FUND Net Gain (Loss) Miscellaneous Interfund Transfers Fund 510 - WATER FUND Totals REVENUE TOTALS Capital Outlay Insurance and Other Chargebacks Depreciation Expense Contingencies Debt Service Employee Pay Benefits Pensions Water Charges for Services Sewer Charges for Services Other Charges for Services Other Revenue September 2017 Financial Report Through 09/30/17 Summary Listing Fee Classification Interest Income Fund 515 - SEWER FUND 2017 September YTD 2016 Budget 2017 Actual %Actual 12,501,500 891,872 9,659,018 77.26% 13,027,160 19,650 21,750 21,750 - 21,600 604,165 - 11,989 1.98% 3,087 1,000 2,299 8,476 847.61% 4,450 REVENUE TOTAL 13,126,315 915,922 9,701,233 73.91% 13,056,297 57,040 2,985 26,269 46.05% 37,763 859,043 65,285 616,845 71.81% 862,355 73,398 6,310 58,859 80.19% 204,330 908,500 6,075 318,773 35.09% 109,493 92,300 7,282 41,853 45.34% 48,058 2,819,700 39,736 779,671 27.65% 15,370 432,953 36,798 323,046 74.61% 414,270 - - - - 3,461,103 8,370,946 1,588,322 6,015,742 71.86% 1,336,366 1,500 - - - 5,000 991,677 82,640 743,757 75.00% 773,873 EXPENSE TOTAL 14,607,057 1,835,431 8,924,815 61.10% 7,267,980 13,126,315 915,922 9,701,233 73.91% 13,056,297 14,607,057 1,835,431 8,924,815 61.10% 7,267,980 (1,480,742) (919,510) 776,418 5,788,316 EXPENSE TOTALS Fund 515 - SEWER FUND Net Gain (Loss) Miscellaneous Interfund Transfers Fund 515 - SEWER FUND Totals REVENUE TOTALS Insurance and Other Chargebacks Depreciation Expense Debt Service Pensions Services Supplies Employee Pay Benefits Sewer Charges for Services Other Charges for Services Capital Outlay Classification September 2017 Financial Report Through 09/30/17 Summary Listing Other Revenue Interest Income Fund 520 - SOLID WASTE FUND 2017 September YTD 2016 Budget 2017 Actual %Actual 275,000 - 127,255 46.27% 170,144 3,632,394 299,383 2,687,904 74.00% 3,586,453 1,055,967 87,997 791,975 75.00% 1,055,967 238,000 1,554 63,518 26.69% 274,808 REVENUE TOTAL 5,201,361 388,933 3,670,652 70.57% 5,087,372 45,000 3,892 27,323 60.72% 43,025 644,768 39,785 397,720 61.68% 620,226 60,473 3,640 38,365 63.44% 151,916 3,679,126 517,243 2,555,921 69.47% 3,438,311 53,050 5,964 26,949 50.80% 54,768 25,750 126 23,112 89.76% 6,034 149,325 8,788 85,374 57.17% 138,618 21,046 - 920 4.37% 2,251 15,000 - 2,615 17.43% 12,232 504,807 42,067 378,605 75.00% 499,493 EXPENSE TOTAL 5,198,345 621,505 3,536,905 68.04% 4,966,872 5,201,361 388,933 3,670,652 70.57% 5,087,372 5,198,345 621,505 3,536,905 68.04% 4,966,872 3,016 (232,572) 133,748 120,500 REVENUE TOTALS EXPENSE TOTALS Fund 520 - SOLID WASTE FUND Net Gain (Loss) Debt Service Miscellaneous Interfund Transfers Fund 520 - SOLID WASTE FUND Totals Services Supplies Capital Outlay Insurance and Other Chargebacks Benefits Pensions Other Charges for Services Interfund Transfers Other Revenue September 2017 Financial Report Through 09/30/17 Summary Listing License Classification Employee Pay September YTD 2016 2017 2017 Actuals 62,673 28,030,940 27,302,687 3,090,978 34,014,975 44,156,868 715,652 8,594,526 17,934,463 338,878 2,435,355 3,611,901 549,534 7,210,189 8,777,295 606,476 5,458,287 8,099,626 76,606 1,074,497 1,238,785 206,067 634,964 1,338,382 - - - - - - - - - 7,478 30,925 30,285 - - - - - - 5,654,341 87,484,657 112,490,292 4,577,891 44,336,177 61,447,382 2,001,022 9,785,173 11,768,857 10,577 214,440 159,648 495,568 26,245,262 28,043,325 15,982 101,833 94,695 - - - 828 2,809 51,836 - - - 57,746 535,744 2,166,129 681,469 6,133,219 7,830,722 7,841,082 87,354,657 111,562,594 5,654,341 87,484,657 112,490,292 7,841,082 87,354,657 111,562,594 (2,186,741) 130,001 927,698 Starting Fund Balance 14,593,354 14,593,354 Net Change 92,641 130,001 Ending Fund Balance 14,685,995 14,723,355 Budget by Organization Report Through 09/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 100 - GENERAL FUND REVENUE Property Taxes 28,639,628 Other Taxes 49,402,274 Licenses, Permits and Fees 17,259,650 Fines and Forfeitures 3,810,000 Charges for Services 8,933,395 Interfund Transfers 7,455,774 Intergovernmental Revenue 1,089,965 Other Revenue 2,138,046 Workers Compensation and Liability - Insurance - Library Revenue - Interest Income 50,100 Special Assessment - Reappropriation of Surplus - REVENUE TOTALS 118,778,832 EXPENSE Salary and Benefits 62,620,910 Services and Supplies 13,716,790 Capital Outlay 499,000 Insurance and Other Chargebacks 30,321,297 Community Sponsored Organizations 204,568 Depreciation Expense - Contingencies 213,519 Debt Service - Miscellaneous 1,200,481 Interfund Transfers 9,909,626 EXPENSE TOTALS 118,686,191 Fund 100 - GENERAL FUND Totals REVENUE TOTALS 118,778,832 EXPENSE TOTALS 118,686,191 Fund 100 - GENERAL FUND Totals 92,641 Run by Kate LewisLakin on 10/27/2017 02:00:29 PM Page 1 of 35 September YTD 2016 2017 2017 Actuals 1,506 920,895 827,615 - - - - - - - - - - - - - - - - - - - 27,489 49,590 - - - - - - - - - 206 909 802 - - - - - - 1,712 949,293 878,006 21,269 197,737 246,916 53,141 438,393 529,013 - - - 3,577 31,206 26,205 - - - - - - - - - - - - - 4,156 2,723 - - - 77,988 671,492 804,857 1,712 949,293 878,006 77,988 671,492 804,857 (76,276) 277,801 73,149 Starting Fund Balance 586,388 586,388 Net Change (252,971) 277,801 Ending Fund Balance 333,417 864,189 Budget by Organization Report Through 09/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 175 - GENERAL ASSISTANCE FUND REVENUE Property Taxes 900,000 Other Taxes - Licenses, Permits and Fees - Fines and Forfeitures - Charges for Services - Interfund Transfers - Intergovernmental Revenue - Other Revenue 25,000 Workers Compensation and Liability - Insurance - Library Revenue - Interest Income 1,000 Special Assessment - Reappropriation of Surplus - REVENUE TOTALS 926,000 EXPENSE Salary and Benefits 282,103 Services and Supplies 858,900 Capital Outlay - Insurance and Other Chargebacks 30,968 Community Sponsored Organizations - Depreciation Expense - Contingencies - Debt Service - Miscellaneous 7,000 Interfund Transfers - EXPENSE TOTALS 1,178,971 Fund 175 - GENERAL ASSISTANCE FUND REVENUE TOTALS 926,000 EXPENSE TOTALS 1,178,971 Fund 175 - GENERAL ASSISTANCE FUND (252,971) Run by Kate LewisLakin on 10/27/2017 02:00:29 PM Page 2 of 35 September YTD 2016 2017 2017 Actuals - - - 71,596 644,365 884,794 - - - - - - 71,596 644,365 884,794 - 121 61 - - - 25,871 509,082 849,333 - - - 25,871 509,204 849,394 71,596 644,365 884,794 25,871 509,204 849,394 45,725 135,161 35,400 Starting Fund Balance 70,806 70,806 Net Change - 135,161 Ending Fund Balance 70,806 205,967 Budget by Organization Report Through 09/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 176 - HEALTH AND HUMAN SERVICES REVENUE Charges for Services - Interfund Transfers 859,153 Intergovernmental Revenue - Other Revenue - REVENUE TOTALS 859,153 EXPENSE Services and Supplies 767,055 Capital Outlay - Community Sponsored Organizations 92,098 Miscellaneous - EXPENSE TOTALS 859,153 EXPENSE TOTALS 859,153 Fund 176 - HEALTH AND HUMAN SERVICES - Fund 176 - HEALTH AND HUMAN SERVICES REVENUE TOTALS 859,153 Run by Kate LewisLakin on 10/27/2017 02:00:29 PM Page 3 of 35 September YTD 2016 2017 2017 Actuals - 1,000,000 1,000,000 - 1,000,000 1,000,000 83,333 750,000 1,000,000 83,333 750,000 1,000,000 - 1,000,000 1,000,000 83,333 750,000 1,000,000 (83,333) 250,000 (0) Starting Fund Balance - - Net Change - 250,000 Ending Fund Balance - 250,000 Budget by Organization Report Through 09/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 180 - GOOD NEIGHBOR FUND REVENUE Other Revenue 1,000,000 REVENUE TOTALS 1,000,000 EXPENSE Interfund Transfers 1,000,000 EXPENSE TOTALS 1,000,000 EXPENSE TOTALS 1,000,000 Fund 180 - GOOD NEIGHBOR FUND Totals - Fund 180 - GOOD NEIGHBOR FUND Totals REVENUE TOTALS 1,000,000 Run by Kate LewisLakin on 10/27/2017 02:00:29 PM Page 4 of 35 September YTD 2016 2017 2017 Actuals 335,032 6,305,637 6,136,248 0.988909 - - 4,141 24,796 110,631 152,537 53 274 - - - 235,800 - 22,092 75,418 12,230 60,927 67,943 36,137 153,156 339,027 619 3,134 4,717 408,868 6,655,851 7,015,830 302,194 3,018,936 4,246,657 0.676765 160,097 1,147,085 1,733,725 - 314 57,842 41,677 363,999 406,708 - - - - - - - - - - 22 - 28,635 257,713 340,272 532,602 4,788,069 6,785,204 408,868 6,655,851 7,015,830 532,602 4,788,069 6,785,204 (123,734) 1,867,783 230,626 Starting Fund Balance 650,655 650,655 Net Change - 1,867,783 Ending Fund Balance 650,655 2,518,438 Budget by Organization Report Through 09/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 185 - LIBRARY FUND REVENUE Property Taxes 6,376,358 Other Taxes 46,100 Fines and Forfeitures 164,000 Charges for Services - Interfund Transfers 190,200 Intergovernmental Revenue 57,418 Other Revenue 24,849 Library Revenue 386,020 Interest Income 5,400 REVENUE TOTALS 7,250,345 EXPENSE Salary and Benefits 4,460,836 Services and Supplies 1,940,058 Capital Outlay 5,400 Insurance and Other Chargebacks 500,433 Depreciation Expense - Contingencies - Debt Service - Miscellaneous - Interfund Transfers 343,618 EXPENSE TOTALS 7,250,345 Fund 185 - LIBRARY FUND Totals REVENUE TOTALS 7,250,345 EXPENSE TOTALS 7,250,345 Fund 185 - LIBRARY FUND Totals - Run by Kate LewisLakin on 10/27/2017 02:00:29 PM Page 5 of 35 September YTD 2016 2017 2017 Actuals 14,725 338,897 364,827 - - 676,150 - 7 1 14,725 338,904 1,040,978 - - 12,349 - - - - 38,227 385,696 - - - - - 650,000 - 38,227 1,048,044 14,725 338,904 1,040,978 - 38,227 1,048,044 14,725 300,677 (7,066) Starting Fund Balance 29,709 29,709 Net Change - 300,677 Ending Fund Balance 29,709 330,386 Budget by Organization Report Through 09/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 186 - LIBRARY DEBT SERVICE FUND REVENUE Property Taxes 345,955 Other Revenue - Interest Income - REVENUE TOTALS 345,955 EXPENSE Services and Supplies - Capital Outlay - Debt Service 345,955 Miscellaneous - Interfund Transfers - EXPENSE TOTALS 345,955 EXPENSE TOTALS 345,955 Fund 186 - LIBRARY DEBT SERVICE FUND - Fund 186 - LIBRARY DEBT SERVICE FUND REVENUE TOTALS 345,955 Run by Kate LewisLakin on 10/27/2017 02:00:29 PM Page 6 of 35 September YTD 2016 2017 2017 Actuals - - - - - - - - - - - - - - - 352,232 850,739 - - - - 352,232 850,739 - - - - 352,232 850,739 - (352,232) (850,739) - Starting Fund Balance - - Net Change - (850,739) Ending Fund Balance - (850,739) Budget by Organization Report Through 09/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 187 - LIBRARY CAPITAL IMPROVEMENT FD REVENUE Property Taxes - Other Revenue 3,774,500 Interest Income - REVENUE TOTALS 3,774,500 EXPENSE Services and Supplies - Capital Outlay 3,774,500 Debt Service - EXPENSE TOTALS 3,774,500 Fund 187 - LIBRARY CAPITAL IMPROVEMENT REVENUE TOTALS 3,774,500 EXPENSE TOTALS 3,774,500 Fund 187 - LIBRARY CAPITAL IMPROVEMENT - Run by Kate LewisLakin on 10/27/2017 02:00:29 PM Page 7 of 35 September YTD 2016 2017 2017 Actuals - - - - - 91,447 - - - 22 131 - 22 131 91,447 1,669 15,747 22,569 - 1,860 6,060 - 2,642 39,316 4,426 7,324 4,173 - - - - - 1,705 377 3,389 17,623 6,471 30,962 91,447 22 131 91,447 6,471 30,962 91,447 (6,450) (30,831) - Starting Fund Balance - - Net Change (303) (30,831) Ending Fund Balance (303) (30,831) Budget by Organization Report Through 09/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 195 - NEIGHBORHOOD STABILIZATION FUND REVENUE Licenses, Permits and Fees - Intergovernmental Revenue 139,500 Other Revenue - Interest Income - REVENUE TOTALS 139,500 EXPENSE Salary and Benefits 28,297 Services and Supplies 5,100 Capital Outlay 7,000 Insurance and Other Chargebacks 3,984 Debt Service - Miscellaneous 50,000 Interfund Transfers 4,518 EXPENSE TOTALS 98,899 EXPENSE TOTALS 98,899 Fund 195 - NEIGHBORHOOD STABILIZATION 40,601 Fund 195 - NEIGHBORHOOD STABILIZATION REVENUE TOTALS 139,500 Run by Kate LewisLakin on 10/27/2017 02:00:29 PM Page 8 of 35 September YTD 2016 2017 2017 Actuals 162,627 1,435,927 1,896,461 - - - 1,845 11,719 6,613 - - - 164,472 1,447,647 1,903,074 - - - - - 130,789 - - - - - - - - - 71,499 643,493 2,189,000 71,499 643,493 2,319,789 164,472 1,447,647 1,903,074 71,499 643,493 2,319,789 92,973 804,154 (416,715) Starting Fund Balance 1,413,678 1,413,678 Net Change (327,990) 804,154 Ending Fund Balance 1,085,688 2,217,832 Budget by Organization Report Through 09/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 200 - MOTOR FUEL TAX FUND REVENUE Intergovernmental Revenue 1,920,000 Other Revenue - Interest Income 1,000 Reappropriation of Surplus - REVENUE TOTALS 1,921,000 EXPENSE Services and Supplies - Capital Outlay 1,391,000 Contingencies - Debt Service - Miscellaneous - Interfund Transfers 857,990 EXPENSE TOTALS 2,248,990 Fund 200 - MOTOR FUEL TAX FUND Totals (327,990) Fund 200 - MOTOR FUEL TAX FUND Totals REVENUE TOTALS 1,921,000 EXPENSE TOTALS 2,248,990 Run by Kate LewisLakin on 10/27/2017 02:00:29 PM Page 9 of 35 September YTD 2016 2017 2017 Actuals 88,594 749,281 1,038,331 - - - - - - 660 4,823 2,472 89,253 754,104 1,040,803 40,520 350,163 509,028 24,731 200,603 263,105 - 32,321 423,493 8,265 69,272 91,628 - - - - - - - - - - - - 6,081 54,733 142,207 79,597 707,091 1,429,460 89,253 754,104 1,040,803 79,597 707,091 1,429,460 9,656 47,012 (388,657) Starting Fund Balance 163,061 163,061 Net Change (8,718) 47,012 Ending Fund Balance 154,343 210,073 Budget by Organization Report Through 09/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 205 - EMERGENCY TELEPHONE (E911) FUND REVENUE Other Taxes 1,020,700 Intergovernmental Revenue - Other Revenue - Interest Income 1,000 REVENUE TOTALS 1,021,700 EXPENSE Salary and Benefits 517,524 Services and Supplies 282,400 Capital Outlay 55,000 Insurance and Other Chargebacks 102,517 Community Sponsored Organizations - Contingencies - Debt Service - Miscellaneous - Interfund Transfers 72,977 EXPENSE TOTALS 1,030,418 Fund 205 - EMERGENCY TELEPHONE (E911) (8,718) Fund 205 - EMERGENCY TELEPHONE (E911) REVENUE TOTALS 1,021,700 EXPENSE TOTALS 1,030,418 Run by Kate LewisLakin on 10/27/2017 02:00:29 PM Page 10 of 35 September YTD 2016 2017 2017 Actuals - 321,687 321,266 - 1 2 - 321,688 321,268 82,250 246,750 323,000 - - - - - - 82,250 246,750 323,000 - 321,688 321,268 82,250 246,750 323,000 (82,250) 74,938 (1,732) Starting Fund Balance (192,276) (192,276) Net Change - 74,938 Ending Fund Balance (192,276) (117,338) Budget by Organization Report Through 09/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 210 - SPECIAL SERVICE AREA (SSA) #4 REVENUE Property Taxes 320,000 Interest Income - REVENUE TOTALS 320,000 EXPENSE Services and Supplies 320,000 Debt Service - Miscellaneous - EXPENSE TOTALS 320,000 EXPENSE TOTALS 320,000 Fund 210 - SPECIAL SERVICE AREA (SSA) #4 - Fund 210 - SPECIAL SERVICE AREA (SSA) #4 REVENUE TOTALS 320,000 Run by Kate LewisLakin on 10/27/2017 02:00:29 PM Page 11 of 35 September YTD 2016 2017 2017 Actuals - - - - - - 33,356 128,654 2,016,478 - - 10,197 - - - 33,356 128,654 2,026,675 25,757 263,435 414,848 - 3,348 6,219 33,356 104,514 608,829 178,500 236,968 405,247 - 25,000 507,815 - - - - - - 122 7,182 61,555 730 6,568 17,938 238,465 647,015 2,022,452 33,356 128,654 2,026,675 238,465 647,015 2,022,452 (205,109) (518,361) 4,224 Starting Fund Balance 64,106 64,106 Net Change (9,484) (518,361) Ending Fund Balance 54,622 (454,255) Budget by Organization Report Through 09/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 215 - CDBG FUND REVENUE Charges for Services - Interfund Transfers - Intergovernmental Revenue 2,272,494 Other Revenue - Interest Income - REVENUE TOTALS 2,272,494 EXPENSE Salary and Benefits 393,090 Services and Supplies 220,840 Capital Outlay - Insurance and Other Chargebacks 93,120 Community Sponsored Organizations 175,500 Contingencies - Debt Service - Miscellaneous 569,970 Interfund Transfers 829,458 EXPENSE TOTALS 2,281,978 EXPENSE TOTALS 2,281,978 Fund 215 - CDBG FUND Totals (9,484) Fund 215 - CDBG FUND Totals REVENUE TOTALS 2,272,494 Run by Kate LewisLakin on 10/27/2017 02:00:29 PM Page 12 of 35 September YTD 2016 2017 2017 Actuals - - - 3,668 71,106 208,541 2 215 4,656 3,670 71,321 213,197 - - - 645 25,345 160,641 - - - - - - 645 25,345 160,641 3,670 71,321 213,197 645 25,345 160,641 3,025 45,976 52,555 Starting Fund Balance 210,921 210,921 Net Change - 45,976 Ending Fund Balance 210,921 256,897 Budget by Organization Report Through 09/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 220 - CDBG LOAN REVENUE Intergovernmental Revenue - Other Revenue 293,000 Interest Income - REVENUE TOTALS 293,000 EXPENSE Salary and Benefits - Services and Supplies 293,000 Miscellaneous - Interfund Transfers - EXPENSE TOTALS 293,000 Fund 220 - CDBG LOAN Totals - Fund 220 - CDBG LOAN Totals REVENUE TOTALS 293,000 EXPENSE TOTALS 293,000 Run by Kate LewisLakin on 10/27/2017 02:00:29 PM Page 13 of 35 September YTD 2016 2017 2017 Actuals - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Starting Fund Balance 169,915 169,915 Net Change (100,000) - Ending Fund Balance 69,915 169,915 Budget by Organization Report Through 09/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 235 - NEIGHBORHOOD IMPROVEMENT REVENUE Other Taxes - Interfund Transfers - Interest Income - REVENUE TOTALS - EXPENSE Services and Supplies - Capital Outlay - Debt Service - Miscellaneous 100,000 Interfund Transfers - EXPENSE TOTALS 100,000 EXPENSE TOTALS 100,000 Fund 235 - NEIGHBORHOOD IMPROVEMENT (100,000) Fund 235 - NEIGHBORHOOD IMPROVEMENT REVENUE TOTALS - Run by Kate LewisLakin on 10/27/2017 02:00:29 PM Page 14 of 35 September YTD 2016 2017 2017 Actuals - 252,509 178,211 2,282 20,538 27,259 29 43 14 2,311 273,090 205,484 3,059 28,547 31,964 30,892 298,481 180,110 - - - (6,812) (3,656) (4,297) - - - - - - - 126 100 - - - 27,140 323,498 207,876 2,311 273,090 205,484 27,140 323,498 207,876 (24,829) (50,408) (2,392) Starting Fund Balance 2,377 2,377 Net Change (831) (50,408) Ending Fund Balance 1,546 (48,031) Budget by Organization Report Through 09/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 240 - HOME FUND REVENUE Intergovernmental Revenue 585,861 Other Revenue - Interest Income - REVENUE TOTALS 585,861 EXPENSE Salary and Benefits 41,005 Services and Supplies 540,200 Capital Outlay - Insurance and Other Chargebacks 4,987 Community Sponsored Organizations - Debt Service - Miscellaneous 500 Interfund Transfers - EXPENSE TOTALS 586,692 EXPENSE TOTALS 586,692 Fund 240 - HOME FUND Totals (831) Fund 240 - HOME FUND Totals REVENUE TOTALS 585,861 Run by Kate LewisLakin on 10/27/2017 02:00:29 PM Page 15 of 35 September YTD 2016 2017 2017 Actuals - 50,000 106,780 - - - - - - 1,250 99,167 448,343 372 2,969 1,392 1,622 152,136 556,515 3,059 28,546 34,138 (1,100) 210,650 201 - - - 1,657 4,267 3,178 3,238 3,238 735 - - - 10,026 56,021 110,956 - - - 16,881 302,722 149,207 1,622 152,136 556,515 16,881 302,722 149,207 (15,259) (150,586) 407,308 Starting Fund Balance 1,401,188 1,401,188 Net Change (1,071,422) (150,586) Ending Fund Balance 329,766 1,250,602 Budget by Organization Report Through 09/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 250 - AFFORDABLE HOUSING FUND REVENUE Other Taxes 50,000 Interfund Transfers - Intergovernmental Revenue - Other Revenue 585,600 Interest Income 230 REVENUE TOTALS 635,830 EXPENSE Salary and Benefits 63,452 Services and Supplies 1,077,500 Capital Outlay - Insurance and Other Chargebacks 8,800 Community Sponsored Organizations 455,000 Debt Service - Miscellaneous 102,500 Interfund Transfers - EXPENSE TOTALS 1,707,252 Fund 250 - AFFORDABLE HOUSING FUND (1,071,422) Fund 250 - AFFORDABLE HOUSING FUND REVENUE TOTALS 635,830 EXPENSE TOTALS 1,707,252 Run by Kate LewisLakin on 10/27/2017 02:00:29 PM Page 16 of 35 September YTD 2016 2017 2017 Actuals - 5,226,085 4,729,649 - - - - - - - - - 7,946 30,778 14,012 7,946 5,256,862 4,743,661 - - - 675 675 2,750 - - 4,473 - - - 24,668 74,004 1,098,676 965,856 3,259,507 4,455,515 991,199 3,334,186 5,561,415 7,946 5,256,862 4,743,661 991,199 3,334,186 5,561,415 (983,252) 1,922,676 (817,754) Starting Fund Balance 5,624,676 5,624,676 Net Change (5,385,636) 1,922,676 Ending Fund Balance 239,040 7,547,352 Budget by Organization Report Through 09/30/17 Prior Fiscal Year Activity Included Detail Listing 2017 Classification Budget Fund 300 - WASHINGTON NATIONAL TIF FUND REVENUE Property Taxes 5,145,000 Other Taxes - Interfund Transfers - Other Revenue - Interest Income 10,000 REVENUE TOTALS 5,155,000 EXPENSE Salary and Benefits - Services and Supplies 500,000 Capital Outlay - Debt Service - Miscellaneous 100,000 Interfund Transfers 9,940,636 EXPENSE TOTALS 10,540,636 EXPENSE TOTALS 10,540,636 Fund 300 - WASHINGTON NATIONAL TIF (5,385,636) Fund 300 - WASHINGTON NATIONAL TIF REVENUE TOTALS 5,155,000 Run by Kate LewisLakin on 10/27/2017 02:00:29 PM Page 17 of 35 September YTD 2016 2017 2017 Actuals - - 1,233,675 - (45,325) - - 1,320 2,319 - (44,005) 1,235,994 - - 2,488 - - - - - - - - - - 599,668 129,192 - - 1,741,757 - 599,668 1,873,437 - (44,005) 1,235,994 - 599,668 1,873,437 - (643,672) (637,443) Starting Fund Balance 643,672 643,672 Net Change (513,865) (643,672) Ending Fund Balance 129,807 (0) - Budget by Organization Report Through 09/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 310 - HOWARD-HARTREY TIF REVENUE Property Taxes - Other Revenue Interest Income - REVENUE TOTALS - EXPENSE 513,865 Services and Supplies - Capital Outlay - Community Sponsored Organizations - Debt Service - Miscellaneous - Interfund Transfers EXPENSE TOTALS 513,865 Fund 310 - HOWARD-HARTREY TIF Totals REVENUE TOTALS - EXPENSE TOTALS 513,865 Fund 310 - HOWARD-HARTREY TIF Totals (513,865) Run by Kate LewisLakin on 10/27/2017 02:00:29 PM Page 18 of 35 September YTD 2016 2017 2017 Actuals (321,402) 10,695,727 10,438,928 250,020 2,250,177 2,999,879 6,941 62,470 - - - 8,291,285 4,359 17,706 24,264 (60,082) 13,026,080 21,754,356 - 1,775 149,553 - 1,981,235 23,454,863 - (57) 57 - - - - 1,982,953 23,604,473 (60,082) 13,026,080 21,754,356 - 1,982,953 23,604,473 (60,082) 11,043,127 (1,850,118) Starting Fund Balance 745,997 745,997 Net Change (305,500) 11,043,127 Ending Fund Balance 440,497 11,789,124 Budget by Organization Report Through 09/30/17 Prior Fiscal Year Activity Included Detail Listing 2017 Classification Budget Fund 320 - DEBT SERVICE FUND REVENUE Property Taxes 10,879,993 Interfund Transfers 3,160,852 Intergovernmental Revenue 83,292 Other Revenue - Interest Income 1,500 REVENUE TOTALS 14,125,637 EXPENSE Services and Supplies 120,250 Debt Service 14,310,887 Miscellaneous - Interfund Transfers - EXPENSE TOTALS 14,431,137 Fund 320 - DEBT SERVICE FUND Totals REVENUE TOTALS 14,125,637 EXPENSE TOTALS 14,431,137 Fund 320 - DEBT SERVICE FUND Totals (305,500) Run by Kate LewisLakin on 10/27/2017 02:00:29 PM Page 19 of 35 September YTD 2016 2017 2017 Actuals 2,291 582,285 533,105 6,500 93,500 282,307 20 22 374 8,810 675,807 815,787 150 306,212 679,056 - - - - - - - - - 94 718 693 - - - 5,000 45,000 107,500 5,244 351,930 787,249 8,810 675,807 815,787 5,244 351,930 787,249 3,566 323,877 28,537 Starting Fund Balance (84) (84) Net Change (13,200) 323,877 Ending Fund Balance (13,284) 323,793 Budget by Organization Report Through 09/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 330 - HOWARD-RIDGE TIF FUND REVENUE Property Taxes 555,000 Other Revenue 1,030,000 Interest Income 400 REVENUE TOTALS 1,585,400 EXPENSE Services and Supplies 538,000 Capital Outlay 1,000,000 Insurance and Other Chargebacks - Community Sponsored Organizations - Debt Service 600 Miscellaneous - Interfund Transfers 60,000 EXPENSE TOTALS 1,598,600 Fund 330 - HOWARD-RIDGE TIF FUND Totals (13,200) Fund 330 - HOWARD-RIDGE TIF FUND Totals REVENUE TOTALS 1,585,400 EXPENSE TOTALS 1,598,600 Run by Kate LewisLakin on 10/27/2017 02:00:29 PM Page 20 of 35 September YTD 2016 2017 2017 Actuals 32 42,125 - 1,028 9,254 11,311 435 2,574 1,684 1,495 53,953 12,995 675 675 507 - - (1,028) - - - - - - 1,153 8,832 8,519 - - - 2,500 22,500 30,000 4,328 32,007 37,998 1,495 53,953 12,995 4,328 32,007 37,998 (2,833) 21,947 (25,003) Starting Fund Balance 417,260 417,260 Net Change (39,850) 21,947 Ending Fund Balance 377,410 439,207 Budget by Organization Report Through 09/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 335 - WEST EVANSTON TIF FUND REVENUE Property Taxes - Other Revenue - Interest Income 150 REVENUE TOTALS 150 EXPENSE Services and Supplies - Capital Outlay - Insurance and Other Chargebacks - Contingencies - Debt Service 10,000 Miscellaneous - Interfund Transfers 30,000 EXPENSE TOTALS 40,000 Fund 335 - WEST EVANSTON TIF FUND Totals (39,850) Fund 335 - WEST EVANSTON TIF FUND Totals REVENUE TOTALS 150 EXPENSE TOTALS 40,000 Run by Kate LewisLakin on 10/27/2017 02:00:29 PM Page 21 of 35 September YTD 2016 2017 2017 Actuals - 48,001 - - - - - 1 - - 48,002 - - - 971 - - - 3,843 46,935 28,444 3,843 46,935 29,415 - 48,003 - 3,843 46,935 29,415 (3,843) 1,068 (29,415) Starting Fund Balance (29,415) (29,415) Net Change - 1,068 Ending Fund Balance (29,415) (28,347) Budget by Organization Report Through 09/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 340 - DEMPSTER-DODGE TIF FUND REVENUE Property Taxes - Other Revenue 50,000 Interest Income - REVENUE TOTALS 50,000 EXPENSE Services and Supplies - Capital Outlay - Debt Service 40,000 EXPENSE TOTALS 40,000 Fund 340 - DEMPSTER-DODGE TIF FUND 10,000 Fund 340 - DEMPSTER-DODGE TIF FUND REVENUE TOTALS 50,000 EXPENSE TOTALS 40,000 Run by Kate LewisLakin on 10/27/2017 02:00:29 PM Page 22 of 35 September YTD 2016 2017 2017 Actuals - 75,430 - - 520,000 1,580,000 1 3 - 1 595,433 1,580,000 675 675 437 - 580,000 1,740,000 5,765 21,519 16,556 6,440 602,194 1,756,993 1 595,433 1,580,000 6,440 602,194 1,756,993 (6,439) (6,761) (176,993) Starting Fund Balance 135,077 135,077 Net Change (60,000) (6,761) Ending Fund Balance 75,077 128,316 Budget by Organization Report Through 09/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 345 - CHICAGO-MAIN TIF REVENUE Property Taxes - Other Revenue - Interest Income - REVENUE TOTALS - EXPENSE Services and Supplies - Capital Outlay - Debt Service 60,000 EXPENSE TOTALS 60,000 Fund 345 - CHICAGO-MAIN TIF Totals REVENUE TOTALS - EXPENSE TOTALS 60,000 Fund 345 - CHICAGO-MAIN TIF Totals (60,000) Run by Kate LewisLakin on 10/27/2017 02:00:29 PM Page 23 of 35 September YTD 2016 2017 2017 Actuals 86 214,095 223,296 - 6 2 86 214,101 223,298 - 116,356 145,003 - - - - 116,356 145,003 86 214,101 223,298 - 116,356 145,003 86 97,745 78,294 Starting Fund Balance 78,294 78,294 Net Change 500 97,745 Ending Fund Balance 78,794 176,039 Budget by Organization Report Through 09/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 350 - SPECIAL SERVICE AREA (SSA) #6 REVENUE Property Taxes 220,000 Interest Income 500 REVENUE TOTALS 220,500 EXPENSE Services and Supplies 220,000 Interfund Transfers - EXPENSE TOTALS 220,000 Fund 350 - SPECIAL SERVICE AREA (SSA) #6 500 Fund 350 - SPECIAL SERVICE AREA (SSA) #6 REVENUE TOTALS 220,500 EXPENSE TOTALS 220,000 Run by Kate LewisLakin on 10/27/2017 02:00:29 PM Page 24 of 35 September YTD 2016 2017 2017 Actuals - 359,706 - - 33,339 96,586 978,356 1,311,689 4,864,054 264,973 277,046 2,177,914 4,385 28,596 9,591,988 4,605 33,106 16,690 1,252,320 2,043,482 16,747,233 - - - 103,267 1,018,954 1,320,475 1,392,351 5,491,087 8,948,635 - - - - - - 41,667 375,000 490,000 1,537,285 6,885,041 10,759,111 1,252,320 2,043,482 16,747,233 1,537,285 6,885,041 10,759,111 (284,965) (4,841,560) 5,988,122 Starting Fund Balance 11,505,164 11,505,164 Net Change (8,583,512) (4,841,560) Ending Fund Balance 2,921,652 6,663,604 Budget by Organization Report Through 09/30/17 Prior Fiscal Year Activity Included Detail Listing 2017 Classification Budget Fund 415 - CAPITAL IMPROVEMENTS FUND REVENUE Licenses, Permits and Fees - Charges for Services - Interfund Transfers 7,710,000 Intergovernmental Revenue 1,920,000 Other Revenue 12,295,000 Interest Income - REVENUE TOTALS 21,925,000 EXPENSE Salary and Benefits - Services and Supplies - Capital Outlay 30,008,512 Debt Service - Miscellaneous - Interfund Transfers 500,000 EXPENSE TOTALS 30,508,512 Fund 415 - CAPITAL IMPROVEMENTS FUND REVENUE TOTALS 21,925,000 EXPENSE TOTALS 30,508,512 Fund 415 - CAPITAL IMPROVEMENTS FUND (8,583,512) Run by Kate LewisLakin on 10/27/2017 02:00:29 PM Page 25 of 35 September YTD 2016 2017 2017 Actuals - - - - - - - - - - - - - - - - - - - - - - - 513,349 - - - - - - - - - 790 21,866 29,661 65 188,999 142,874 - - - 855 210,865 685,884 - - - - - 8,751 - - - - - - - - - - - - 21,952 197,570 360,698 21,952 197,570 369,449 855 210,865 685,884 21,952 197,570 369,449 (21,097) 13,295 316,435 Starting Fund Balance 2,999,216 2,999,216 Net Change (32,227) 13,295 Ending Fund Balance 2,966,989 3,012,511 Budget by Organization Report Through 09/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 420 - SPECIAL ASSESSMENT FUND REVENUE Property Taxes - Other Taxes - Licenses, Permits and Fees - Fines and Forfeitures - Charges for Services - Interfund Transfers - Intergovernmental Revenue - Other Revenue 250,000 Workers Compensation and Liability - Insurance - Library Revenue - Interest Income 51,033 Special Assessment 180,167 Reappropriation of Surplus - REVENUE TOTALS 481,200 EXPENSE Salary and Benefits - Services and Supplies - Capital Outlay - Insurance and Other Chargebacks - Debt Service - Miscellaneous - Interfund Transfers 513,427 EXPENSE TOTALS 513,427 Fund 420 - SPECIAL ASSESSMENT FUND REVENUE TOTALS 481,200 EXPENSE TOTALS 513,427 Fund 420 - SPECIAL ASSESSMENT FUND (32,227) Run by Kate LewisLakin on 10/27/2017 02:00:29 PM Page 26 of 35 September YTD 2016 2017 2017 Actuals - - - - - - 50 1,900 3,350 - - - 905,918 4,751,235 6,509,492 - 2,060,318 3,711,768 - - - 26,902 163,637 195,895 6,691 40,347 38,159 939,560 7,017,436 10,458,663 100,164 866,392 1,462,702 221,829 2,323,693 3,084,543 659,603 1,789,086 (24,598) 48,017 405,406 504,784 - - - - - 2,836,672 169 2,527 5,910 - 141,632 390,235 11,938 160,346 255,626 106,224 956,012 1,303,783 1,147,943 6,645,095 9,819,656 939,560 7,017,436 10,458,663 1,147,943 6,645,095 9,819,656 (208,383) 372,341 639,007 Starting Fund Balance 7,752,664 7,752,664 Net Change (3,350,830) 372,341 Ending Fund Balance 4,401,834 8,125,005 Budget by Organization Report Through 09/30/17 Prior Fiscal Year Activity Included Detail Listing 2017 Classification Budget Fund 505 - PARKING SYSTEM FUND REVENUE Property Taxes - Other Taxes - Licenses, Permits and Fees - Fines and Forfeitures - Charges for Services 6,802,875 Interfund Transfers 4,120,636 Intergovernmental Revenue 12,125 Other Revenue 203,216 Interest Income 35,070 REVENUE TOTALS 11,173,922 EXPENSE Salary and Benefits 1,247,921 Services and Supplies 3,501,275 Capital Outlay 3,020,000 Insurance and Other Chargebacks 524,102 Community Sponsored Organizations - Depreciation Expense - Contingencies 11,000 Debt Service 4,331,771 Miscellaneous 304,000 Interfund Transfers 1,584,683 EXPENSE TOTALS 14,524,752 Fund 505 - PARKING SYSTEM FUND Totals (3,350,830) Fund 505 - PARKING SYSTEM FUND Totals REVENUE TOTALS 11,173,922 EXPENSE TOTALS 14,524,752 Run by Kate LewisLakin on 10/27/2017 02:00:29 PM Page 27 of 35 September YTD 2016 2017 2017 Actuals - - - 6,123 70,257 90,592 1,491,023 12,662,545 16,071,271 - - - - - - 57,825 698,022 306,143 3,661 23,711 16,537 16,484,543 347,102 3,294,783 4,980,085 376,268 1,904,057 2,620,878 385,553 2,370,203 36,713 97,268 860,832 1,110,835 - - - - - 1,973,593 - - 1,000 - 421,769 633,708 - - 238,468 291,859 2,626,735 3,502,313 15,097,592 1,386,951 Starting Fund Balance 7,536,078 7,536,078 Net Change (4,966,507) 1,976,157 Ending Fund Balance 2,569,571 9,512,235 60,582 1,976,157 1,558,632 13,454,535 1,498,050 11,478,378 1,558,632 13,454,535 EXPENSE Salary and Benefits 4,589,411 16,484,543 EXPENSE TOTALS 29,361,507 Fund 510 - WATER FUND Totals (4,966,507) 1,498,050 11,478,378 15,097,592 Fund 510 - WATER FUND Totals REVENUE TOTALS 24,395,000 Miscellaneous 62,980 Interfund Transfers 3,502,313 EXPENSE TOTALS Capital Outlay 14,982,119 Insurance and Other Chargebacks 1,174,064 Community Sponsored Organizations - 29,361,507 Depreciation Expense - Contingencies 1,000 Debt Service 1,438,470 Licenses, Permits and Fees 70,000 Charges for Services 17,495,000 Interfund Transfers - Intergovernmental Revenue - Services and Supplies 3,611,150 Other Revenue 6,828,400 Interest Income 1,600 REVENUE TOTALS 24,395,000 Budget by Organization Report Through 09/30/17 Prior Fiscal Year Activity Included Detail Listing 2017 Classification Budget Fund 510-513 - WATER FUND REVENUE Other Taxes - Run by Kate LewisLakin on 10/27/2017 02:00:29 PM Page 28 of 35 September YTD 2016 2017 2017 Actuals 913,622 9,680,768 13,048,760 - - - - 11,989 3,087 2,299 8,476 4,450 915,922 9,701,233 13,056,297 74,579 701,972 1,104,448 13,357 360,626 157,551 39,736 779,671 15,370 36,798 323,046 414,270 - - 3,461,103 - - - 1,588,322 6,015,742 1,336,366 - - 5,000 82,640 743,757 773,873 1,835,431 8,924,815 7,267,980 915,922 9,701,233 13,056,297 1,835,431 8,924,815 7,267,980 (919,510) 776,418 5,788,316 Starting Fund Balance 4,612,098 4,612,098 Net Change (1,480,742) 776,418 Ending Fund Balance 3,131,356 5,388,516 Budget by Organization Report Through 09/30/17 Prior Fiscal Year Activity Included Detail Listing 2017 Classification Budget Fund 515 - SEWER FUND REVENUE Charges for Services 12,521,150 Interfund Transfers - Other Revenue 604,165 Interest Income 1,000 REVENUE TOTALS 13,126,315 EXPENSE Salary and Benefits 989,481 Services and Supplies 1,000,800 Capital Outlay 2,819,700 Insurance and Other Chargebacks 432,953 Depreciation Expense - Contingencies - Debt Service 8,370,946 Miscellaneous 1,500 Interfund Transfers 991,677 EXPENSE TOTALS 14,607,057 Fund 515 - SEWER FUND Totals (1,480,742) Fund 515 - SEWER FUND Totals REVENUE TOTALS 13,126,315 EXPENSE TOTALS 14,607,057 Run by Kate LewisLakin on 10/27/2017 02:00:29 PM Page 29 of 35 September YTD 2016 2017 2017 Actuals - 127,255 170,144 299,383 2,687,904 3,586,453 87,997 791,975 1,055,967 - - - 1,554 63,518 274,808 - - - 388,933 3,670,652 5,087,372 47,317 463,409 815,166 523,207 2,582,870 3,493,078 126 23,112 6,034 8,788 85,374 138,618 - - - - - - - - - - 920 2,251 - 2,615 12,232 42,067 378,605 499,493 621,505 3,536,905 4,966,872 388,933 3,670,652 5,087,372 621,505 3,536,905 4,966,872 (232,572) 133,748 120,500 Starting Fund Balance (972,783) (972,783) Net Change 3,016 133,748 Ending Fund Balance (969,767) (839,035) Budget by Organization Report Through 09/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 520 - SOLID WASTE FUND REVENUE Licenses, Permits and Fees 275,000 Charges for Services 3,632,394 Interfund Transfers 1,055,967 Intergovernmental Revenue - Other Revenue 238,000 Interest Income - REVENUE TOTALS 5,201,361 EXPENSE Salary and Benefits 750,241 Services and Supplies 3,732,176 Capital Outlay 25,750 Insurance and Other Chargebacks 149,325 Community Sponsored Organizations - Depreciation Expense - Contingencies - Debt Service 21,046 Miscellaneous 15,000 Interfund Transfers 504,807 EXPENSE TOTALS 5,198,345 Fund 520 - SOLID WASTE FUND Totals 3,016 Fund 520 - SOLID WASTE FUND Totals REVENUE TOTALS 5,201,361 EXPENSE TOTALS 5,198,345 Run by Kate LewisLakin on 10/27/2017 02:00:29 PM Page 30 of 35 September YTD 2016 2017 2017 Actuals 283,620 2,552,576 3,387,680 - - - - - - 1,773 16,806 14,415 - - - 285,392 2,569,382 3,402,094 72,303 681,723 897,673 173,080 1,318,298 1,912,423 - - - 16,150 139,316 167,952 - - 44 - - - - - - - - - 2,319 20,875 26,762 263,852 2,160,211 3,004,854 285,392 2,569,382 3,402,094 263,852 2,160,211 3,004,854 21,540 409,171 397,241 Starting Fund Balance 762,744 762,744 Net Change (248,021) 409,171 Ending Fund Balance 514,723 1,171,915 Budget by Organization Report Through 09/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 600 - FLEET SERVICES FUND REVENUE Charges for Services 3,388,435 Interfund Transfers - Intergovernmental Revenue - Other Revenue 81,781 Interest Income 1,000 REVENUE TOTALS 3,471,216 EXPENSE Salary and Benefits 1,071,267 Services and Supplies 2,380,057 Capital Outlay - Insurance and Other Chargebacks 239,630 Depreciation Expense - Contingencies 450 Debt Service - Miscellaneous - Interfund Transfers 27,833 EXPENSE TOTALS 3,719,237 EXPENSE TOTALS 3,719,237 Fund 600 - FLEET SERVICES FUND Totals (248,021) Fund 600 - FLEET SERVICES FUND Totals REVENUE TOTALS 3,471,216 Run by Kate LewisLakin on 10/27/2017 02:00:29 PM Page 31 of 35 September YTD 2016 2017 2017 Actuals 129,171 1,162,543 1,455,172 - - - 3,275 58,071 63,430 132,446 1,220,613 1,518,602 3,570 54,490 102,765 202,647 480,063 - - - 1,624,064 - - - 206,217 534,554 1,726,829 132,446 1,220,613 1,518,602 206,217 534,554 1,726,829 (73,770) 686,059 (208,226) Starting Fund Balance 885,333 885,333 Net Change 229,853 686,059 Ending Fund Balance 1,115,186 1,571,392 Budget by Organization Report Through 09/30/17 Prior Fiscal Year Activity Included 2017 Classification Budget Fund 601 - EQUIPMENT REPLACEMENT FUND REVENUE Charges for Services 1,550,058 Interfund Transfers - Other Revenue 210,217 REVENUE TOTALS 1,760,275 EXPENSE Services and Supplies 75,000 Capital Outlay 1,455,422 Depreciation Expense - Miscellaneous - EXPENSE TOTALS 1,530,422 Fund 601 - EQUIPMENT REPLACEMENT FUND 229,853 Fund 601 - EQUIPMENT REPLACEMENT FUND REVENUE TOTALS 1,760,275 EXPENSE TOTALS 1,530,422 Run by Kate LewisLakin on 10/27/2017 02:00:29 PM Page 32 of 35 September YTD 2016 2017 2017 Actuals 13,534 121,808 441,246 68 615 - - - - 917,492 7,951,440 9,995,502 91,510 804,829 89,822 441,365 4,200,622 6,546,063 43 209 218 1,464,012 13,079,524 17,072,851 22,925 388,179 448,109 498,479 1,215,899 4,704,399 - - - 1,568,630 12,466,425 14,539,279 - - - - - - - - - - - - - - 4,330 803 7,224 9,262 2,090,837 14,077,728 19,705,379 1,464,012 13,079,524 17,072,851 2,090,837 14,077,728 19,705,379 (626,825) (998,204) (2,632,528) Starting Fund Balance (2,997,025) (2,997,025) Net Change (224,815) (998,204) Ending Fund Balance (3,221,840) (3,995,229) Budget by Organization Report Through 09/30/17 Prior Fiscal Year Activity Included Detail Listing 2017 Classification Budget Fund 605 - INSURANCE FUND REVENUE Charges for Services 162,411 Interfund Transfers 4,987 Intergovernmental Revenue - Other Revenue 11,237,646 Workers Compensation and Liability 1,030,815 Insurance 6,413,937 Interest Income 1,000 REVENUE TOTALS 18,850,796 EXPENSE Salary and Benefits 534,441 Services and Supplies 2,385,248 Capital Outlay - Insurance and Other Chargebacks 16,146,290 Community Sponsored Organizations - Depreciation Expense - Contingencies - Debt Service - Miscellaneous - Interfund Transfers 9,632 EXPENSE TOTALS 19,075,611 EXPENSE TOTALS 19,075,611 Fund 605 - INSURANCE FUND Totals (224,815) Fund 605 - INSURANCE FUND Totals REVENUE TOTALS 18,850,796 Run by Kate LewisLakin on 10/27/2017 02:00:29 PM Page 33 of 35 September YTD 2016 2017 2017 Actuals - - - 256,978 256,978 - - - - 398,114 13,735,622 10,902,978 234,433 1,070,678 1,559,737 889,525 15,063,279 12,462,715 726,209 6,483,703 8,429,695 - - - - - - - - - - 88,046 174,111 726,209 6,571,749 8,603,806 889,525 15,063,279 12,462,715 726,209 6,571,749 8,603,806 163,317 8,491,529 3,858,910 Starting Fund Balance 70,599,998 70,599,998 Net Change 4,636,709 8,491,529 Ending Fund Balance 75,236,707 79,091,527 Budget by Organization Report Through 09/30/17 Prior Fiscal Year Activity Included Detail Listing 2017 Classification Budget Fund 700 - FIRE PENSION FUND REVENUE Property Taxes 7,868,709 Other Taxes 280,000 Interfund Transfers 43,000 Other Revenue 1,050,000 Interest Income 4,100,000 REVENUE TOTALS 13,341,709 EXPENSE Salary and Benefits 8,705,000 Services and Supplies - Community Sponsored Organizations - Debt Service - Miscellaneous - EXPENSE TOTALS 8,705,000 Fund 700 - FIRE PENSION FUND Totals 4,636,709 Fund 700 - FIRE PENSION FUND Totals REVENUE TOTALS 13,341,709 EXPENSE TOTALS 8,705,000 Run by Kate LewisLakin on 10/27/2017 02:00:29 PM Page 34 of 35 September YTD 2016 2017 2017 Actuals - - - 256,978 256,978 - - - - 1,339,663 19,662,461 16,286,867 322,158 2,086,331 2,713,348 1,918,799 22,005,770 19,000,215 977,567 8,595,456 11,094,711 - - - - - - - 164,118 272,795 977,567 8,759,574 11,367,506 1,918,799 22,005,770 19,000,215 977,567 8,759,574 11,367,506 941,232 13,246,196 7,632,708 Starting Fund Balance 106,191,545 106,191,545 Net Change 6,627,200 13,246,196 Ending Fund Balance 112,818,745 119,437,741 Budget by Organization Report Through 09/30/17 Prior Fiscal Year Activity Included Detail Listing 2017 Classification Budget Fund 705 - POLICE PENSION FUND REVENUE Property Taxes 9,912,200 Other Taxes 325,000 Interfund Transfers 57,000 Other Revenue 1,650,000 Interest Income 6,500,000 REVENUE TOTALS 18,444,200 EXPENSE Salary and Benefits 11,817,000 Services and Supplies - Debt Service - Miscellaneous - EXPENSE TOTALS 11,817,000 Fund 705 - POLICE PENSION FUND Totals REVENUE TOTALS 18,444,200 EXPENSE TOTALS 11,817,000 Fund 705 - POLICE PENSION FUND Totals 6,627,200 Run by Kate LewisLakin on 10/27/2017 02:00:29 PM Page 35 of 35