The URL can be used to link to this page

Home My WebLink About2018.01 January Monthly Report To: Wally Bobkiewicz, City Manager From: Ashley King, Interim CFO/City Treasurer Subject: January 2018 Monthly Financial Report Date: March 13, 2018 Please find attached the unaudited financial statements as of January 31, 2018. A summary by fund for revenues, expenditures, fund and cash balances is as follows: YTD Revenues YTD Expenses YTD Net Fund Balance Cash Balance 9,505,979 7,635,865 1,870,114 16,512,558 8,905,448 106,284 69,381 36,903 681,402 681,402 69,049 - 69,049 80,827 80,827 77 83,333 (83,256) (81,372) 918,628 811,742 339,777 471,964 1,456,736 1,481,291 12 1,963 (1,951) (4,393) 93,018 168,412 204,833 (36,421) 2,337,309 2,172,721 74,506 47,165 27,341 212,834 (89,533) - - - (198,794) (198,794) 600 27,564 (26,964) 37,130 (137,479) 2,999 53 2,946 255,557 286,557 12 - 12 170,183 170,183 2,298 2,904 (605) 8,671 7,678 32,132 5,065 27,067 1,503,610 1,513,999 32,050 - 32,050 592,931 23,345 294,329 592,253 (297,925) 4,964,620 3,792,396 - 130,098 (130,098) 143,780 146,049 4,955 3,708 1,247 434,013 442,335 - - - (6,009) (6,009) - - - 61,193 61,193 5,836 - 5,836 8,042 8,042 - - - 308,399 322,066 1,234,287 - 1,234,287 1,430,743 1,445,540 543,422 (33,926) 577,348 10,024,704 13,126,074 - - - 540,681 540,681 46,187 46,997 (810) 2,996,891 2,993,354 795,754 281,781 513,974 5,423,376 5,079,724 1,609,673 690,949 918,724 8,243,711 5,624,576 1,873,531 549,101 1,324,430 5,474,357 2,805,961 437,695 245,420 192,275 (976,740) (1,161,295) 249,067 89,253 159,814 518,050 354,013 107,517 - 107,517 1,184,493 1,213,558 1,255,844 1,467,766 (211,923) (5,559,957) (1,394,051) 19,264,247 12,481,304 6,782,943 58,779,535 51,303,498 Fund Fund Description 100 GENERAL FUND 175 GENERAL ASSISTANCE FUND 176 HEALTH AND HUMAN SERVICES 180 GOOD NEIGHBOR FUND 185 LIBRARY FUND 195 NEIGHBORHOOD STABILIZATION FUND 200 MOTOR FUEL TAX FUND 205 EMERGENCY TELEPHONE (E911) FUND 210 SPECIAL SERVICE AREA (SSA) #4 215 CDBG FUND 220 CDBG LOAN 235 NEIGHBORHOOD IMPROVEMENT 240 HOME FUND 250 AFFORDABLE HOUSING FUND 186 LIBRARY DEBT SERVICE FUND 300 WASHINGTON NATIONAL TIF FUND 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 416 CROWN CONSTRUCTION FUND 187 LIBRARY CAPITAL IMPROVEMENT FD 320 DEBT SERVICE FUND 415 CAPITAL IMPROVEMENTS FUND 420 SPECIAL ASSESSMENT FUND 505 PARKING SYSTEM FUND 510 WATER FUND 601 EQUIPMENT REPLACEMENT FUND 605 INSURANCE FUND 515 SEWER FUND 600 FLEET SERVICES FUND 520 SOLID WASTE FUND Memorandum Included above are the ending balances as of January 31, 2018 for both unreserved fund and cash balances. Of these two amounts, cash balance is the more meaningful metric since this represents liquid cash and/or invested assets which can be used (or easily sold) to support and fund current operations. While ending fund balance is also an important measurement of the City’s financial health, it usually includes illiquid assets or future cash receipts or disbursements such as receivables (including property tax) due to the City and accounts payable/accrued expenses. The fund balances included in this financial report are based on unaudited 2017 year - end balances. These may change slightly during the Audit Process, which will be conducted during April 2018. As of January 31, 2018, the General Fund is reporting a net surplus of $1,870,114. The General Fund balance is $16,512,558 with a cash balance of $8,905,448. The attached supplemental charts show the General Fund Revenues at 8.3% of budget and expenses lower at 6.7%. Expenses are low because there were only 1.5 payrolls charged in January, which balances out by the end of the year. Through January 31, 2018, the Good Neighbor Fund is showing a negative fund balance of $81,372. This is because the revenue from Northwestern University is not received until later in the year, but transfers to other funds from the Good Neighbor Fund are made monthly to cover expenses throughout the year on designated projects. Through January 31, 2018, the Neighborhood Stabilization Fund is showing a negative fund balance of $4,393. This is due to the timing of grant funding revenues. Through January 31, 2018, the E911 Fund is showing negative cash balance of $89,533. This is due to timing of E911 revenues from the state and the e xpenses related to the replacement of Computer Aided Dispatch (CAD) and Police/Fire Records Software. Through January 31, 2018, the SSA #4 Fund is showing a negative fund and cash balance of $198,794. This negative balance has carried through from 2016 and will need to be addressed during 2018. Through January 31, 2018, the CDBG Fund is showing a negative cash balance of $137,479. This is reimbursed with draw-downs in February 2018. Through January 31, 2018, the Dempster-Dodge TIF Fund has a negative fund and cash balance of $6,009. This is due to the issuance costs of the 2017B bonds, which will be covered by the first installment of property taxes in March 2018. Through January 31, 2018, the Capital Fund is showing a fund balance of $10,024,704 and a cash balance of $13,126,074. Bond proceeds from the 2017A General Obligation Bonds were received in October, significantly increasing fund and cash balances. January February March April May June July August September 2017 Unreserved Fund Balance 15,453,984$ 2018 Unreserved Fund Balance 16,512,558$ 2017 Cash Balance 6,338,271$ 2018 Cash Balance 8,905,448$ 2017 v 2018 Fund and Cash Balance-- General Fund $- $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000 $14,000,000 $16,000,000 $18,000,000 2017 Unreserved Fund Balance 2018 Unreserved Fund Balance 2017 Cash Balance 2018 Cash Balance 2018 January YTD % of 2017 Budget 2018 2018 Budget Actual 28,849,196 3,130,691 3,130,691 10.9% 28,294,363 49,742,274 3,856,973 3,856,973 7.8% 47,271,172 12,397,400 787,195 787,195 6.3% 13,221,946 3,897,500 316,461 316,461 8.1% 3,484,050 10,077,550 620,622 620,622 6.2% 8,754,025 7,748,417 618,143 618,143 8.0% 8,590,717 778,100 139,168 139,168 17.9% 1,468,393 1,300,217 34,437 34,437 2.6% 2,073,158 50,100 2,289 2,289 4.6% 38,544 REVENUE TOTAL 114,840,754 9,505,979 9,505,979 8.3% 113,196,368 CITY COUNCIL 492,806 30,795 30,795 6.2% 498,172 CITY CLERK 191,784 9,420 9,420 4.9% 251,193 CITY MANAGER'S OFFICE 7,540,597 481,779 481,779 6.4% 7,205,673 LAW 736,346 40,697 40,697 5.5% 772,045 ADMINISTRATIVE SERVICES 9,075,303 399,944 399,944 4.4% 9,201,875 COMMUNITY DEVELOPMENT 3,614,774 163,824 163,824 4.5% 2,592,984 POLICE 38,391,099 2,886,031 2,886,031 7.5% 39,156,992 FIRE MGMT & SUPPORT 23,934,390 1,920,302 1,920,302 8.0% 24,207,459 HEALTH 3,697,529 195,656 195,656 5.3% 3,062,221 PARKS, REC. AND COMMUNITY SERV. 11,955,812 484,555 484,555 4.1% 12,474,508 PUBLIC WORKS AGENCY 14,607,356 1,022,861 1,022,861 7.0% 13,959,679 EXPENSE TOTAL 114,237,796 7,635,865 7,635,865 6.7% 113,382,802 114,840,754 9,505,979 9,505,979 8.3% 113,196,368 114,237,796 7,635,865 7,635,865 6.7% 113,382,802 602,958 1,870,114 1,870,114 (186,434) REVENUE TOTALS EXPENSE TOTALS Fund 100 - GENERAL FUND Net Gain (Loss) Fund 100 - GENERAL FUND Totals Charges for Services Interfund Transfers Intergovernmental Revenue Other Revenue Interest Income January 2018 Financial Report Through 01/31/18 Summary Listing Classification Fund 100 - GENERAL FUND Property Taxes Other Taxes Licenses, Permits and Fees Fines and Forfeitures 2018 January YTD % of 2017 Budget 2018 2018 Budget Actual - 913 913 - 1,900 6,676,575 413,652 413,652 6.2% 6,303,624 4,217,040 347,253 347,253 8.2% 4,120,636 12,125 - - 0.0% - 193,316 30,579 30,579 15.8% 224,872 35,070 3,358 3,358 9.6% 54,767 REVENUE TOTAL 11,134,126 795,754 795,754 7.1% 10,705,799 1,611,078 82,986 82,986 5.2% 1,266,924 3,451,775 38,734 38,734 1.1% 3,144,371 2,450,000 - - 0.0% 2,341,090 557,598 40,026 40,026 7.2% 552,831 11,000 - - 0.0% 4,246 3,070,625 - - 0.0% 4,330,993 304,000 - - 0.0% 267,436 1,440,417 120,035 120,035 8.3% 1,584,683 EXPENSE TOTAL 12,896,493 281,781 281,781 2.2% 13,492,573 11,134,126 795,754 795,754 7.1% 10,705,799 12,896,493 281,781 281,781 2.2% 13,492,573 (1,762,367) 513,974 513,974 (2,786,775) Insurance and Other Chargebacks Contingencies Debt Service Miscellaneous Interfund Transfers Fund 505 - PARKING SYSTEM FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund 505 - PARKING SYSTEM FUND Net Gain Fund 505 - PARKING SYSTEM FUND Licenses, Permits and Fees Charges for Services Interfund Transfers Intergovernmental Revenue Other Revenue Interest Income Salary and Benefits Services and Supplies Capital Outlay January 2018 Financial Report Through 01/31/18 Summary Listing Classification 2018 January YTD % of 2017 Budget 2018 2018 Budget Actual 70,000 1,345 1,345 1.9% 86,063 18,267,000 1,597,860 1,597,860 8.7% 17,265,193 27,333,656 6,601 6,601 0.0% 1,266,352 25,000 3,868 3,868 15.5% 34,587 REVENUE TOTAL 45,695,656 1,609,673 1,609,673 3.5% 18,652,195 4,921,439 292,866 292,866 6.0% 4,609,432 4,655,410 12,562 12,562 0.3% 3,349,827 29,346,200 - - 0.0% 3,436,079 1,161,384 78,662 78,662 6.8% 1,158,869 1,000 - - 0.0% - 1,960,760 - - 0.0% 1,631,712 15,000 - - 0.0% - 3,602,313 306,859 306,859 8.5% 6,327,314 EXPENSE TOTAL 45,663,506 690,949 690,949 1.5% 20,513,233 45,695,656 1,609,673 1,609,673 3.5% 18,652,195 45,663,506 690,949 690,949 1.5% 20,513,233 32,150 918,724 918,724 (1,861,038) REVENUE TOTALS EXPENSE TOTALS Fund 510 - WATER FUND Net Gain (Loss) Debt Service Miscellaneous Interfund Transfers Fund 510 - WATER FUND Totals Fund 510 - WATER FUND Licenses, Permits and Fees Charges for Services Other Revenue Interest Income Salary and Benefits Services and Supplies Capital Outlay Insurance and Other Chargebacks Contingencies January 2018 Financial Report Through 01/31/18 Summary Listing Classification 2018 January YTD % of 2017 Budget 2018 2018 Budget Actual 12,589,650 1,871,919 1,871,919 14.9% 12,486,512 2,104,000 - - 0.0% - 5,000 1,612 1,612 32.2% 16,023 REVENUE TOTAL 14,698,650 1,873,531 1,873,531 12.7% 12,502,534 1,123,687 69,193 69,193 6.2% 991,635 2,558,630 - - 0.0% 987,884 2,181,300 - - 0.0% 1,227,662 421,010 32,570 32,570 7.7% 437,253 7,540,066 364,699 364,699 4.8% 1,541,842 1,500 - - 0.0% - 991,677 82,640 82,640 8.3% 1,141,676 EXPENSE TOTAL 14,817,870 549,101 549,101 3.7% 6,327,952 14,698,650 1,873,531 1,873,531 12.7% 12,502,534 14,817,870 549,101 549,101 3.7% 6,327,952 (119,220) 1,324,430 1,324,430 6,174,582 Fund 515 - SEWER FUND Net Gain (Loss) Interfund Transfers Fund 515 - SEWER FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund 515 - SEWER FUND Charges for Services Other Revenue Interest Income Salary and Benefits Services and Supplies Capital Outlay Insurance and Other Chargebacks Debt Service Miscellaneous January 2018 Financial Report Through 01/31/18 Summary Listing Classification 2018 January YTD % of 2017 Budget 2018 2018 Budget Actual 410,000 - - 0.0% - 275,000 - - 0.0% 171,138 3,632,394 290,077 290,077 8.0% 3,618,965 705,967 146,828 146,828 20.8% 755,967 238,000 790 790 0.3% 250,687 REVENUE TOTAL 5,261,361 437,695 437,695 8.3% 4,796,757 871,369 44,191 44,191 5.1% 663,863 3,488,676 166,982 166,982 4.8% 3,482,141 275,750 - - 0.0% 24,635 122,247 7,383 7,383 6.0% 116,954 21,797 - - 0.0% 21,046 7,500 - - 0.0% 3,057 322,362 26,864 26,864 8.3% 504,807 EXPENSE TOTAL 5,109,701 245,420 245,420 4.8% 4,816,503 5,261,361 437,695 437,695 8.3% 4,796,757 5,109,701 245,420 245,420 4.8% 4,816,503 151,660 192,275 192,275 (19,746) Charges for Services Interfund Transfers Other Revenue Property Taxes January 2018 Financial Report Through 01/31/18 Summary Listing Classification Fund 520 - SOLID WASTE FUND Licenses, Permits and Fees EXPENSE TOTALS Fund 520 - SOLID WASTE FUND Net Gain Salary and Benefits Services and Supplies Capital Outlay Insurance and Other Chargebacks Debt Service Miscellaneous Interfund Transfers Fund 520 - SOLID WASTE FUND Totals REVENUE TOTALS January YTD 2017 2018 2018 Actual 3,130,691 3,130,691 28,294,363 3,856,973 3,856,973 47,271,172 787,195 787,195 13,221,946 316,461 316,461 3,484,050 620,622 620,622 8,754,025 618,143 618,143 8,590,717 139,168 139,168 1,468,393 34,437 34,437 2,073,158 - - - - - - - - - 2,289 2,289 38,544 - - - - - - 9,505,979 9,505,979 113,196,368 3,913,497 3,913,497 62,232,769 250,774 250,774 13,065,796 4,023 4,023 361,427 2,730,198 2,730,198 30,134,474 - - 174,131 - - - - - 4,090 - - - 9,864 9,864 768,878 727,507 727,507 6,641,237 7,635,865 7,635,865 113,382,802 9,505,979 9,505,979 113,196,368 7,635,865 7,635,865 113,382,802 1,870,114 1,870,114 (186,434) Starting Fund Balance 14,642,444 14,642,444 Net Change 602,958 1,870,114 Ending Fund Balance 15,245,402 16,512,558 REVENUE TOTALS 114,840,754 EXPENSE TOTALS 114,237,796 Fund 100 - GENERAL FUND Totals 602,958 EXPENSE TOTALS 114,237,796 Fund 100 - GENERAL FUND Totals Debt Service - Miscellaneous 965,317 Interfund Transfers 7,704,802 Community Sponsored Organizations 173,886 Depreciation Expense - Contingencies 208,500 Services and Supplies 12,409,791 Capital Outlay 354,000 Insurance and Other Chargebacks 31,279,188 REVENUE TOTALS 114,840,754 EXPENSE Salary and Benefits 61,142,312 Interest Income 50,100 Special Assessment - Reappropriation of Surplus - Workers Compensation and Liability - Insurance - Library Revenue - Interfund Transfers 7,748,417 Intergovernmental Revenue 778,100 Other Revenue 1,300,217 Licenses, Permits and Fees 12,397,400 Fines and Forfeitures 3,897,500 Charges for Services 10,077,550 Fund 100 - GENERAL FUND REVENUE Property Taxes 28,849,196 Other Taxes 49,742,274 Budget by Organization Through 01/31/18 2018 Classification Budget Run by Kate LewisLakin on 03/13/2018 09:51:04 AM Page 1 of 51 January YTD 2017 2018 2018 Actual 101,411 101,411 933,020 - - - - - - - - - - - - - - - - - - 4,771 4,771 33,019 - - - - - - - - - 102 102 1,548 - - - - - - 106,284 106,284 967,586 20,244 20,244 282,139 0.056838 46,297 46,297 579,392 - - - 2,840 2,840 42,833 - - - - - - - - - - - - - - 5,110 - - - 69,381 69,381 909,475 106,284 106,284 967,586 69,381 69,381 909,475 36,903 36,903 58,111 Starting Fund Balance 644,499 644,499 Net Change (312,421) 36,903 Ending Fund Balance 332,078 681,402 REVENUE TOTALS 953,500 EXPENSE TOTALS 1,265,921 Fund 175 - GENERAL ASSISTANCE FUND (312,421) EXPENSE TOTALS 1,265,921 Fund 175 - GENERAL ASSISTANCE FUND Debt Service - Miscellaneous 7,000 Interfund Transfers - Community Sponsored Organizations - Depreciation Expense - Contingencies - Services and Supplies 858,200 Capital Outlay - Insurance and Other Chargebacks 44,541 REVENUE TOTALS 953,500 EXPENSE Salary and Benefits 356,180 Interest Income 1,000 Special Assessment - Reappropriation of Surplus - Workers Compensation and Liability - Insurance - Library Revenue - Interfund Transfers - Intergovernmental Revenue - Other Revenue 27,500 Licenses, Permits and Fees - Fines and Forfeitures - Charges for Services - Fund 175 - GENERAL ASSISTANCE FUND REVENUE Property Taxes 925,000 Other Taxes - Budget by Organization Through 01/31/18 2018 Classification Budget Run by Kate LewisLakin on 03/13/2018 09:51:04 AM Page 3 of 51 January YTD 2017 2018 2018 Actual - - - 69,039 69,039 859,153 - - - - - - 10 10 14 69,049 69,049 859,167 - - 121 - - - - - 918,074 - - - - - 918,196 69,049 69,049 859,167 - - 918,196 69,049 69,049 (59,029) Starting Fund Balance 11,777 11,777 Net Change (30,682) 69,049 Ending Fund Balance (18,905) 80,826 REVENUE TOTALS 828,471 EXPENSE TOTALS 859,153 Fund 176 - HEALTH AND HUMAN (30,682) EXPENSE TOTALS 859,153 Fund 176 - HEALTH AND HUMAN Capital Outlay - Community Sponsored Organizations - Miscellaneous - REVENUE TOTALS 828,471 EXPENSE Services and Supplies 859,153 Intergovernmental Revenue - Other Revenue - Interest Income - Fund 176 - HEALTH AND HUMAN SERVICES REVENUE Charges for Services - Interfund Transfers 828,471 Budget by Organization Through 01/31/18 2018 Classification Budget Run by Kate LewisLakin on 03/13/2018 09:51:04 AM Page 4 of 51 January YTD 2017 2018 2018 Actual - - 1,000,000 77 77 1,884 77 77 1,001,884 83,333 83,333 1,000,000 83,333 83,333 1,000,000 77 77 1,001,884 83,333 83,333 1,000,000 (83,256) (83,256) 1,884 Starting Fund Balance 1,884 1,884 Net Change - (83,256) Ending Fund Balance 1,884 (81,372) REVENUE TOTALS 1,000,000 EXPENSE TOTALS 1,000,000 Fund 180 - GOOD NEIGHBOR FUND Totals - EXPENSE TOTALS 1,000,000 Fund 180 - GOOD NEIGHBOR FUND Totals REVENUE TOTALS 1,000,000 EXPENSE Interfund Transfers 1,000,000 Fund 180 - GOOD NEIGHBOR FUND REVENUE Other Revenue 1,000,000 Interest Income - Budget by Organization Through 01/31/18 2018 Classification Budget Run by Kate LewisLakin on 03/13/2018 09:51:04 AM Page 5 of 51 January YTD 2017 2018 2018 Actual 691,993 691,993 6,370,507 - - - 9,595 9,595 122,862 27 27 338 5,833 5,833 190,200 21,309 21,309 22,092 9,038 9,038 70,651 73,785 73,785 345,788 161 161 5,169 811,742 811,742 7,127,606 259,804 259,804 4,234,540 17,372 17,372 1,700,800 - - 9,904 32,022 32,022 504,605 - - - - - - - - - - - 22 30,579 30,579 343,618 339,777 339,777 6,793,489 811,742 811,742 7,127,606 339,777 339,777 6,793,489 471,964 471,964 334,117 Starting Fund Balance 984,772 984,772 Net Change 221,912 471,964 Ending Fund Balance 1,206,684 1,456,736 REVENUE TOTALS 7,693,209 EXPENSE TOTALS 7,471,297 Fund 185 - LIBRARY FUND Totals 221,912 EXPENSE TOTALS 7,471,297 Fund 185 - LIBRARY FUND Totals Debt Service - Miscellaneous - Interfund Transfers 366,949 Insurance and Other Chargebacks 493,468 Depreciation Expense - Contingencies - Salary and Benefits 4,595,792 Services and Supplies 2,004,688 Capital Outlay 10,400 Interest Income 5,400 REVENUE TOTALS 7,693,209 EXPENSE Intergovernmental Revenue 152,418 Other Revenue 130,000 Library Revenue 324,620 Fines and Forfeitures 130,000 Charges for Services - Interfund Transfers 265,771 Fund 185 - LIBRARY FUND REVENUE Property Taxes 6,685,000 Other Taxes - Budget by Organization Through 01/31/18 2018 Classification Budget Run by Kate LewisLakin on 03/13/2018 09:51:04 AM Page 6 of 51 January YTD 2017 2018 2018 Actual 32,050 32,050 338,897 - - 778,745 - - 7 32,050 32,050 1,117,649 - - 8,587 - - - - - 1,134,570 - - - - - - - - 1,143,157 32,050 32,050 1,117,649 - - 1,143,157 32,050 32,050 (25,507) Starting Fund Balance 560,881 560,881 Net Change 12,386 32,050 Ending Fund Balance 573,267 592,931 EXPENSE TOTALS 333,404 Fund 186 - LIBRARY DEBT SERVICE 12,386 Fund 186 - LIBRARY DEBT SERVICE REVENUE TOTALS 345,790 Miscellaneous - Interfund Transfers - EXPENSE TOTALS 333,404 Services and Supplies - Capital Outlay - Debt Service 333,404 Interest Income - REVENUE TOTALS 345,790 EXPENSE Fund 186 - LIBRARY DEBT SERVICE FUND REVENUE Property Taxes 345,790 Other Revenue - Budget by Organization Through 01/31/18 2018 Classification Budget Run by Kate LewisLakin on 03/13/2018 09:51:04 AM Page 7 of 51 January YTD 2017 2018 2018 Actual - - - - - 1,431,106 - - - - - 1,431,106 - - 30,790 - - 1,091,917 - - - - - - - - 1,122,708 - - 1,431,106 - - 1,122,708 - - 308,399 Starting Fund Balance 308,399 308,399 Net Change - - Ending Fund Balance 308,399 308,399 Fund 187 - LIBRARY CAPITAL - Fund 187 - LIBRARY CAPITAL REVENUE TOTALS 10,095,000 EXPENSE TOTALS 10,095,000 Interfund Transfers - EXPENSE TOTALS 10,095,000 Services and Supplies - Capital Outlay 10,095,000 Debt Service - Interest Income - REVENUE TOTALS 10,095,000 EXPENSE Fund 187 - LIBRARY CAPITAL IMPROVEMENT FD REVENUE Property Taxes - Other Revenue 10,095,000 Budget by Organization Through 01/31/18 2018 Classification Budget Run by Kate LewisLakin on 03/13/2018 09:51:04 AM Page 8 of 51 January YTD 2017 2018 2018 Actual - - - - - 34,999 - - - 12 12 200 12 12 35,199 1,305 1,305 21,969 - - 1,860 - - 2,642 271 271 4,252 - - - - - 2,400 388 388 4,518 1,963 1,963 37,641 12 12 35,199 1,963 1,963 37,641 (1,951) (1,951) (2,442) Starting Fund Balance (2,442) (2,442) Net Change 326 (1,951) Ending Fund Balance (2,116) (4,393) EXPENSE TOTALS 94,821 Fund 195 - NEIGHBORHOOD 326 Fund 195 - NEIGHBORHOOD REVENUE TOTALS 95,147 Miscellaneous 50,000 Interfund Transfers 4,654 EXPENSE TOTALS 94,821 Capital Outlay 7,000 Insurance and Other Chargebacks 4,267 Debt Service - EXPENSE Salary and Benefits 23,800 Services and Supplies 5,100 Other Revenue - Interest Income - REVENUE TOTALS 95,147 Fund 195 - NEIGHBORHOOD STABILIZATION FUND REVENUE Licenses, Permits and Fees - Intergovernmental Revenue 95,147 Budget by Organization Through 01/31/18 2018 Classification Budget Run by Kate LewisLakin on 03/13/2018 09:51:04 AM Page 9 of 51 January YTD 2017 2018 2018 Actual 164,588 164,588 1,899,884 - - - 3,824 3,824 18,158 - - - 168,412 168,412 1,918,041 - - - 125,000 125,000 - - - - - - - - - - 79,833 79,833 957,990 204,833 204,833 957,990 168,412 168,412 1,918,041 204,833 204,833 957,990 (36,421) (36,421) 960,051 Starting Fund Balance 2,373,729 2,373,729 Net Change (535,990) (36,421) Ending Fund Balance 1,837,739 2,337,308 Fund 200 - MOTOR FUEL TAX FUND Totals (535,990) Fund 200 - MOTOR FUEL TAX FUND Totals REVENUE TOTALS 1,922,000 EXPENSE TOTALS 2,457,990 Interfund Transfers 957,990 EXPENSE TOTALS 2,457,990 Contingencies - Debt Service - Miscellaneous - EXPENSE Services and Supplies - Capital Outlay 1,500,000 Interest Income 12,000 Reappropriation of Surplus - REVENUE TOTALS 1,922,000 Fund 200 - MOTOR FUEL TAX FUND REVENUE Intergovernmental Revenue 1,910,000 Other Revenue - Budget by Organization Through 01/31/18 2018 Classification Budget Run by Kate LewisLakin on 03/13/2018 09:51:04 AM Page 10 of 51 January YTD 2017 2018 2018 Actual 73,796 73,796 982,020 - - - - - - 710 710 7,178 74,506 74,506 989,198 31,149 31,149 507,288 3,429 3,429 239,161 - - 51,670 6,473 6,473 95,670 - - - - - - - - - - - - 6,114 6,114 72,977 47,165 47,165 966,766 74,506 74,506 989,198 47,165 47,165 966,766 27,341 27,341 22,432 Starting Fund Balance 185,493 185,493 Net Change 8,262 27,341 Ending Fund Balance 193,755 212,834 Fund 205 - EMERGENCY TELEPHONE 8,262 Fund 205 - EMERGENCY TELEPHONE REVENUE TOTALS 1,051,700 EXPENSE TOTALS 1,043,438 Interfund Transfers 73,366 EXPENSE TOTALS 1,043,438 Contingencies - Debt Service - Miscellaneous - Capital Outlay 55,000 Insurance and Other Chargebacks 97,125 Community Sponsored Organizations - EXPENSE Salary and Benefits 535,547 Services and Supplies 282,400 Other Revenue - Interest Income 1,000 REVENUE TOTALS 1,051,700 Fund 205 - EMERGENCY TELEPHONE (E911) FUND REVENUE Other Taxes 1,050,700 Intergovernmental Revenue - Budget by Organization Through 01/31/18 2018 Classification Budget Run by Kate LewisLakin on 03/13/2018 09:51:04 AM Page 11 of 51 January YTD 2017 2018 2018 Actual - - 322,477 - - 5 - - 322,482 - - 329,000 - - - - - - - - 329,000 - - 322,482 - - 329,000 - - (6,518) Starting Fund Balance (198,794) (198,794) Net Change - - Ending Fund Balance (198,794) (198,794) EXPENSE TOTALS 370,000 Fund 210 - SPECIAL SERVICE AREA - Fund 210 - SPECIAL SERVICE AREA REVENUE TOTALS 370,000 Debt Service - Miscellaneous - EXPENSE TOTALS 370,000 REVENUE TOTALS 370,000 EXPENSE Services and Supplies 370,000 Fund 210 - SPECIAL SERVICE AREA (SSA) #4 REVENUE Property Taxes 370,000 Interest Income - Budget by Organization Through 01/31/18 2018 Classification Budget Run by Kate LewisLakin on 03/13/2018 09:51:04 AM Page 12 of 51 January YTD 2017 2018 2018 Actual - - - - - - - - 1,906,708 600 600 262 - - - 600 600 1,906,970 20,332 20,332 361,255 1,042 1,042 3,797 - - 645,289 5,444 5,444 462,464 - - 318,412 - - - - - - - - 95,606 746 746 20,145 27,564 27,564 1,906,970 600 600 1,906,970 27,564 27,564 1,906,970 (26,964) (26,964) - Starting Fund Balance 64,094 64,094 Net Change (109,388) (26,964) Ending Fund Balance (45,294) 37,130 EXPENSE TOTALS 2,439,512 Fund 215 - CDBG FUND Totals (109,388) Fund 215 - CDBG FUND Totals REVENUE TOTALS 2,330,124 Miscellaneous 569,970 Interfund Transfers 949,656 EXPENSE TOTALS 2,439,512 Community Sponsored Organizations 175,500 Contingencies - Debt Service - Services and Supplies 220,840 Capital Outlay - Insurance and Other Chargebacks 91,176 REVENUE TOTALS 2,330,124 EXPENSE Salary and Benefits 432,370 Intergovernmental Revenue 2,330,124 Other Revenue - Interest Income - Fund 215 - CDBG FUND REVENUE Charges for Services - Interfund Transfers - Budget by Organization Through 01/31/18 2018 Classification Budget Run by Kate LewisLakin on 03/13/2018 09:51:04 AM Page 13 of 51 January YTD 2017 2018 2018 Actual - - - 2,910 2,910 116,742 89 89 257 2,999 2,999 116,999 - - - 53 53 75,309 - - - - - - 53 53 75,309 2,999 2,999 116,999 53 53 75,309 2,946 2,946 41,690 Starting Fund Balance 252,611 252,611 Net Change - 2,946 Ending Fund Balance 252,611 255,557 Fund 220 - CDBG LOAN Totals - Fund 220 - CDBG LOAN Totals REVENUE TOTALS 293,000 EXPENSE TOTALS 293,000 Interfund Transfers - EXPENSE TOTALS 293,000 Salary and Benefits - Services and Supplies 293,000 Miscellaneous - Interest Income - REVENUE TOTALS 293,000 EXPENSE Fund 220 - CDBG LOAN REVENUE Intergovernmental Revenue - Other Revenue 293,000 Budget by Organization Through 01/31/18 2018 Classification Budget Run by Kate LewisLakin on 03/13/2018 09:51:04 AM Page 14 of 51 January YTD 2017 2018 2018 Actual - - - - - - 12 12 256 12 12 256 - - - - - - - - - - - - - - - - - - 12 12 256 - - - 12 12 256 Starting Fund Balance 170,171 170,171 Net Change (100,000) 12 Ending Fund Balance 70,171 170,183 EXPENSE TOTALS 100,000 Fund 235 - NEIGHBORHOOD (100,000) Fund 235 - NEIGHBORHOOD REVENUE TOTALS - Miscellaneous 100,000 Interfund Transfers - EXPENSE TOTALS 100,000 Services and Supplies - Capital Outlay - Debt Service - Interest Income - REVENUE TOTALS - EXPENSE Fund 235 - NEIGHBORHOOD IMPROVEMENT REVENUE Other Taxes - Interfund Transfers - Budget by Organization Through 01/31/18 2018 Classification Budget Run by Kate LewisLakin on 03/13/2018 09:51:04 AM Page 15 of 51 January YTD 2017 2018 2018 Actual - - 377,450 2,282 2,282 27,384 16 16 121 2,298 2,298 404,955 2,392 2,392 39,955 200 200 381,806 - - - 312 312 (23,832) - - - - - - - - 126 - - - 2,904 2,904 398,055 2,298 2,298 404,955 2,904 2,904 398,055 (605) (605) 6,900 Starting Fund Balance 9,277 9,277 Net Change 615 (605) Ending Fund Balance 9,892 8,672 EXPENSE TOTALS 588,321 Fund 240 - HOME FUND Totals 615 Fund 240 - HOME FUND Totals REVENUE TOTALS 588,936 Miscellaneous 500 Interfund Transfers - EXPENSE TOTALS 588,321 Insurance and Other Chargebacks 4,657 Community Sponsored Organizations - Debt Service - Salary and Benefits 42,964 Services and Supplies 540,200 Capital Outlay - Interest Income - REVENUE TOTALS 588,936 EXPENSE Fund 240 - HOME FUND REVENUE Intergovernmental Revenue 588,936 Other Revenue - Budget by Organization Through 01/31/18 2018 Classification Budget Run by Kate LewisLakin on 03/13/2018 09:51:04 AM Page 16 of 51 January YTD 2017 2018 2018 Actual - - 97,000 - - - - - - 31,667 31,667 333,056 465 465 5,623 32,132 32,132 435,678 4,592 4,592 40,348 - - 209,772 - - - 473 473 15,617 - - 8,927 - - - - - 85,660 - - - 5,065 5,065 360,323 32,132 32,132 435,678 5,065 5,065 360,323 27,067 27,067 75,355 Starting Fund Balance 1,476,543 1,476,543 Net Change (38,470) 27,067 Ending Fund Balance 1,438,073 1,503,610 Fund 250 - AFFORDABLE HOUSING (38,470) Fund 250 - AFFORDABLE HOUSING REVENUE TOTALS 450,830 EXPENSE TOTALS 489,300 Interfund Transfers - EXPENSE TOTALS 489,300 Community Sponsored Organizations 70,000 Debt Service - Miscellaneous 43,000 Services and Supplies 279,500 Capital Outlay - Insurance and Other Chargebacks 3,837 REVENUE TOTALS 450,830 EXPENSE Salary and Benefits 92,963 Intergovernmental Revenue - Other Revenue 400,600 Interest Income 230 Fund 250 - AFFORDABLE HOUSING FUND REVENUE Other Taxes 50,000 Interfund Transfers - Budget by Organization Through 01/31/18 2018 Classification Budget Run by Kate LewisLakin on 03/13/2018 09:51:04 AM Page 17 of 51 January YTD 2017 2018 2018 Actual 291,467 291,467 5,249,949 - - - - - - - - - 2,862 2,862 45,924 294,329 294,329 5,295,873 - - - - - 2,007 - - - - - - - - 98,672 592,253 592,253 5,557,325 592,253 592,253 5,658,005 294,329 294,329 5,295,873 592,253 592,253 5,658,005 (297,925) (297,925) (362,132) Starting Fund Balance 5,262,544 5,262,544 Net Change (3,437,040) (297,925) Ending Fund Balance 1,825,504 4,964,620 EXPENSE TOTALS 9,207,040 Fund 300 - WASHINGTON NATIONAL TIF (3,437,040) Fund 300 - WASHINGTON NATIONAL TIF REVENUE TOTALS 5,770,000 Miscellaneous 100,000 Interfund Transfers 7,107,040 EXPENSE TOTALS 9,207,040 Services and Supplies 2,000,000 Capital Outlay - Debt Service - REVENUE TOTALS 5,770,000 EXPENSE Salary and Benefits - Interfund Transfers - Other Revenue - Interest Income 20,000 Fund 300 - WASHINGTON NATIONAL TIF FUND REVENUE Property Taxes 5,750,000 Other Taxes - Budget by Organization Through 01/31/18 2018 Classification Budget Run by Kate LewisLakin on 03/13/2018 09:51:04 AM Page 18 of 51 January YTD 2017 2018 2018 Actual 935,477 935,477 10,797,411 288,930 288,930 2,850,236 7,219 7,219 83,293 - - 8,883,103 2,661 2,661 36,782 1,234,287 1,234,287 22,650,825 - - 100,625 - - 23,099,797 - - (57) - - - - - 23,200,365 1,234,287 1,234,287 22,650,825 - - 23,200,365 1,234,287 1,234,287 (549,540) Starting Fund Balance 196,457 196,457 Net Change 274,759 1,234,287 Ending Fund Balance 471,216 1,430,744 REVENUE TOTALS 14,572,016 EXPENSE TOTALS 14,297,257 Fund 320 - DEBT SERVICE FUND Totals 274,759 EXPENSE TOTALS 14,297,257 Fund 320 - DEBT SERVICE FUND Totals Debt Service 14,177,257 Miscellaneous - Interfund Transfers - REVENUE TOTALS 14,572,016 EXPENSE Services and Supplies 120,000 Intergovernmental Revenue 83,292 Other Revenue - Interest Income 1,500 Fund 320 - DEBT SERVICE FUND REVENUE Property Taxes 10,879,993 Interfund Transfers 3,607,231 Budget by Organization Through 01/31/18 2018 Classification Budget Run by Kate LewisLakin on 03/13/2018 09:51:04 AM Page 19 of 51 January YTD 2017 2018 2018 Actual - - 583,827 - - 58,500 - - 22 - - 642,348 - - 307,391 125,000 125,000 - - - - - - - 98 98 995 - - - 5,000 5,000 60,000 130,098 130,098 368,386 - - 642,348 130,098 130,098 368,386 (130,098) (130,098) 273,962 Starting Fund Balance 273,878 273,878 Net Change (296,100) (130,098) Ending Fund Balance (22,222) 143,780 Fund 330 - HOWARD-RIDGE TIF FUND (296,100) Fund 330 - HOWARD-RIDGE TIF FUND REVENUE TOTALS 4,385,400 EXPENSE TOTALS 4,681,500 Interfund Transfers 60,000 EXPENSE TOTALS 4,681,500 Community Sponsored Organizations - Debt Service 960,000 Miscellaneous - Services and Supplies 461,500 Capital Outlay 3,200,000 Insurance and Other Chargebacks - Interest Income 400 REVENUE TOTALS 4,385,400 EXPENSE Fund 330 - HOWARD-RIDGE TIF FUND REVENUE Property Taxes 605,000 Other Revenue 3,780,000 Budget by Organization Through 01/31/18 2018 Classification Budget Run by Kate LewisLakin on 03/13/2018 09:51:04 AM Page 20 of 51 January YTD 2017 2018 2018 Actual 4,713 4,713 43,503 - - 12,339 241 241 3,898 4,955 4,955 59,741 - - 2,007 - - - - - - - - - 1,208 1,208 12,227 - - - 2,500 2,500 30,000 3,708 3,708 44,235 4,955 4,955 59,741 3,708 3,708 44,235 1,247 1,247 15,506 Starting Fund Balance 432,766 432,766 Net Change (39,850) 1,247 Ending Fund Balance 392,916 434,013 Fund 335 - WEST EVANSTON TIF FUND (39,850) Fund 335 - WEST EVANSTON TIF FUND REVENUE TOTALS 150 EXPENSE TOTALS 40,000 Interfund Transfers 30,000 EXPENSE TOTALS 40,000 Contingencies - Debt Service 10,000 Miscellaneous - Services and Supplies - Capital Outlay - Insurance and Other Chargebacks - Interest Income 150 REVENUE TOTALS 150 EXPENSE Fund 335 - WEST EVANSTON TIF FUND REVENUE Property Taxes - Other Revenue - Budget by Organization Through 01/31/18 2018 Classification Budget Run by Kate LewisLakin on 03/13/2018 09:51:04 AM Page 21 of 51 January YTD 2017 2018 2018 Actual - - 48,001 - - 2,067,512 - - 1 - - 2,115,514 - - 38,588 - - 2,000,000 - - 53,521 - - 2,092,108 - - 2,115,514 - - 2,092,108 - - 23,406 Starting Fund Balance (6,009) (6,009) Net Change 202,334 - Ending Fund Balance 196,325 (6,009) REVENUE TOTALS 275,000 EXPENSE TOTALS 72,666 Fund 340 - DEMPSTER-DODGE TIF FUND 202,334 EXPENSE TOTALS 72,666 Fund 340 - DEMPSTER-DODGE TIF FUND Services and Supplies - Capital Outlay - Debt Service 72,666 Interest Income - REVENUE TOTALS 275,000 EXPENSE Fund 340 - DEMPSTER-DODGE TIF FUND REVENUE Property Taxes 275,000 Other Revenue - Budget by Organization Through 01/31/18 2018 Classification Budget Run by Kate LewisLakin on 03/13/2018 09:51:04 AM Page 22 of 51 January YTD 2017 2018 2018 Actual - - 75,430 - - 3,520,189 - - 9 - - 3,595,628 - - 58,113 - - 3,580,000 - - 31,398 - - 3,669,511 - - 3,595,628 - - 3,669,511 - - (73,884) Starting Fund Balance 61,193 61,193 Net Change 316,001 - Ending Fund Balance 377,194 61,193 REVENUE TOTALS 425,000 EXPENSE TOTALS 108,999 Fund 345 - CHICAGO-MAIN TIF Totals 316,001 EXPENSE TOTALS 108,999 Fund 345 - CHICAGO-MAIN TIF Totals Services and Supplies - Capital Outlay - Debt Service 108,999 Interest Income - REVENUE TOTALS 425,000 EXPENSE Fund 345 - CHICAGO-MAIN TIF REVENUE Property Taxes 425,000 Other Revenue - Budget by Organization Through 01/31/18 2018 Classification Budget Run by Kate LewisLakin on 03/13/2018 09:51:04 AM Page 23 of 51 January YTD 2017 2018 2018 Actual 5,835 5,835 215,245 0 0 21 5,836 5,836 215,266 - - 213,354 - - 78,000 - - 291,354 5,836 5,836 215,266 - - 291,354 5,836 5,836 (76,088) Starting Fund Balance 2,206 2,206 Net Change - 5,836 Ending Fund Balance 2,206 8,042 Fund 350 - SPECIAL SERVICE AREA - Fund 350 - SPECIAL SERVICE AREA REVENUE TOTALS 221,500 EXPENSE TOTALS 221,500 Interfund Transfers - EXPENSE TOTALS 221,500 REVENUE TOTALS 221,500 EXPENSE Services and Supplies 221,500 Fund 350 - SPECIAL SERVICE AREA (SSA) #6 REVENUE Property Taxes 221,000 Interest Income 500 Budget by Organization Through 01/31/18 2018 Classification Budget Run by Kate LewisLakin on 03/13/2018 09:51:04 AM Page 24 of 51 January YTD 2017 2018 2018 Actual - - 359,706 - - 33,339 536,667 536,667 1,436,689 - - 530,812 - - 11,246,149 6,755 6,755 56,607 543,422 543,422 13,663,302 25,023 25,023 4,715 3,000 3,000 1,660,805 (107,002) (107,002) 13,417,249 3,386 3,386 677 - - - - - - 41,667 41,667 500,000 (33,926) (33,926) 15,583,445 543,422 543,422 13,663,302 (33,926) (33,926) 15,583,445 577,348 577,348 (1,920,143) Starting Fund Balance 9,447,356 9,447,356 Net Change (7,655,527) 577,348 Ending Fund Balance 1,791,829 10,024,704 Fund 415 - CAPITAL IMPROVEMENTS (7,655,527) Fund 415 - CAPITAL IMPROVEMENTS REVENUE TOTALS 22,642,000 EXPENSE TOTALS 30,297,527 Interfund Transfers 500,000 EXPENSE TOTALS 30,297,527 Insurance and Other Chargebacks - Debt Service - Miscellaneous - Salary and Benefits 85,527 Services and Supplies - Capital Outlay 29,712,000 Interest Income - REVENUE TOTALS 22,642,000 EXPENSE Interfund Transfers 6,450,000 Intergovernmental Revenue 4,190,000 Other Revenue 12,002,000 Fund 415 - CAPITAL IMPROVEMENTS FUND REVENUE Licenses, Permits and Fees - Charges for Services - Budget by Organization Through 01/31/18 2018 Classification Budget Run by Kate LewisLakin on 03/13/2018 09:51:04 AM Page 25 of 51 January YTD 2017 2018 2018 Actual - - - - - 900,000 - - - - - 900,000 - - 638,727 - - 369,924 - - - - - 1,008,651 - - 900,000 - - 1,008,651 - - (108,651) Starting Fund Balance 540,861 540,861 Net Change 1,866,000 - Ending Fund Balance 2,406,861 540,861 REVENUE TOTALS 11,500,000 EXPENSE TOTALS 9,634,000 Fund 416 - CROWN CONSTRUCTION 1,866,000 EXPENSE TOTALS 9,634,000 Fund 416 - CROWN CONSTRUCTION Services and Supplies 1,634,000 Capital Outlay 8,000,000 Interfund Transfers - Interest Income - REVENUE TOTALS 11,500,000 EXPENSE Fund 416 - CROWN CONSTRUCTION FUND REVENUE Interfund Transfers - Other Revenue 11,500,000 Budget by Organization Through 01/31/18 2018 Classification Budget Run by Kate LewisLakin on 03/13/2018 09:51:04 AM Page 26 of 51 January YTD 2017 2018 2018 Actual - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 6,708 6,708 31,203 39,479 39,479 237,016 - - - 46,187 46,187 268,219 3,798 3,798 612 - - 5,613 - - - 413 413 83 - - - - - - 42,786 42,786 263,427 46,997 46,997 269,734 46,187 46,187 268,219 46,997 46,997 269,734 (810) (810) (1,516) Starting Fund Balance 2,997,700 2,997,700 Net Change (123,850) (810) Ending Fund Balance 2,873,850 2,996,890 REVENUE TOTALS 461,367 EXPENSE TOTALS 585,217 Fund 420 - SPECIAL ASSESSMENT FUND (123,850) EXPENSE TOTALS 585,217 Fund 420 - SPECIAL ASSESSMENT FUND Debt Service - Miscellaneous - Interfund Transfers 513,427 Services and Supplies - Capital Outlay - Insurance and Other Chargebacks - REVENUE TOTALS 461,367 EXPENSE Salary and Benefits 71,790 Interest Income 31,200 Special Assessment 180,167 Reappropriation of Surplus - Workers Compensation and Liability - Insurance - Library Revenue - Interfund Transfers - Intergovernmental Revenue - Other Revenue 250,000 Licenses, Permits and Fees - Fines and Forfeitures - Charges for Services - Fund 420 - SPECIAL ASSESSMENT FUND REVENUE Property Taxes - Other Taxes - Budget by Organization Through 01/31/18 2018 Classification Budget Run by Kate LewisLakin on 03/13/2018 09:51:04 AM Page 27 of 51 January YTD 2017 2018 2018 Actual - - - - - - 913 913 1,900 - - - 413,652 413,652 6,303,624 347,253 347,253 4,120,636 - - - 30,579 30,579 224,872 3,358 3,358 54,767 795,754 795,754 10,705,799 82,986 82,986 1,266,924 38,734 38,734 3,144,371 - - 2,341,090 40,026 40,026 552,831 - - - - - - - - 4,246 - - 4,330,993 - - 267,436 120,035 120,035 1,584,683 281,781 281,781 13,492,573 795,754 795,754 10,705,799 281,781 281,781 13,492,573 513,974 513,974 (2,786,775) Starting Fund Balance 4,909,402 4,909,402 Net Change (1,762,367) 513,974 Ending Fund Balance 3,147,035 5,423,376 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 557,598 Community Sponsored Organizations - Depreciation Expense - Salary and Benefits 1,611,078 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 - Fines and Forfeitures - Charges for Services 6,676,575 Fund 505 - PARKING SYSTEM FUND REVENUE Property Taxes - Other Taxes - Budget by Organization Through 01/31/18 2018 Classification Budget Run by Kate LewisLakin on 03/13/2018 09:51:04 AM Page 28 of 51 January YTD 2017 2018 2018 Actual - - - 1,345 1,345 86,063 1,597,860 1,597,860 17,265,193 - - - - - - 6,601 6,601 1,266,352 3,868 3,868 34,587 1,609,673 1,609,673 18,652,195 292,866 292,866 4,609,432 12,562 12,562 3,349,828 - - 3,436,079 78,662 78,662 1,158,869 - - - - - - - - - - - 1,631,712 - - - 306,859 306,859 6,327,314 690,949 690,949 20,513,234 1,609,673 1,609,673 18,652,195 690,949 690,949 20,513,234 918,724 918,724 (1,861,039) Starting Fund Balance 7,324,987 7,324,987 Net Change 32,150 918,724 Ending Fund Balance 7,357,137 8,243,711 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 1,161,384 Community Sponsored Organizations - EXPENSE Salary and Benefits 4,921,439 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 Interfund Transfers - Intergovernmental Revenue - Fund 510 - WATER FUND REVENUE Other Taxes - Licenses, Permits and Fees 70,000 Budget by Organization Through 01/31/18 2018 Classification Budget Run by Kate LewisLakin on 03/13/2018 09:51:04 AM Page 29 of 51 January YTD 2017 2018 2018 Actual 1,871,919 1,871,919 12,486,512 - - - - - - 1,612 1,612 16,023 1,873,531 1,873,531 12,502,534 69,193 69,193 991,635 - - 987,884 - - 1,227,662 32,570 32,570 437,253 - - - - - - 364,699 364,699 1,541,842 - - - 82,640 82,640 1,141,676 549,101 549,101 6,327,952 1,873,531 1,873,531 12,502,534 549,101 549,101 6,327,952 1,324,430 1,324,430 6,174,582 Starting Fund Balance 4,149,927 4,149,927 Net Change (119,220) 1,324,430 Ending Fund Balance 4,030,707 5,474,357 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 Contingencies - Debt Service 7,540,066 Miscellaneous 1,500 Capital Outlay 2,181,300 Insurance and Other Chargebacks 421,010 Depreciation Expense - EXPENSE Salary and Benefits 1,123,687 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 Interfund Transfers - Budget by Organization Through 01/31/18 2018 Classification Budget Run by Kate LewisLakin on 03/13/2018 09:51:04 AM Page 30 of 51 January YTD 2017 2018 2018 Actual - - - - - 171,138 290,077 290,077 3,618,965 146,828 146,828 755,967 - - - 790 790 250,687 - - - 437,695 437,695 4,796,757 44,191 44,191 663,863 166,982 166,982 3,482,141 - - 24,635 7,383 7,383 116,954 - - - - - - - - - - - 21,046 - - 3,057 26,864 26,864 504,807 245,420 245,420 4,816,503 437,695 437,695 4,796,757 245,420 245,420 4,816,503 192,275 192,275 (19,746) Starting Fund Balance (1,169,015) (1,169,015) Net Change (258,340) 192,275 Ending Fund Balance (1,427,355) (976,740) EXPENSE TOTALS 5,109,701 Fund 520 - SOLID WASTE FUND Totals (258,340) Fund 520 - SOLID WASTE FUND Totals REVENUE TOTALS 4,851,361 Miscellaneous 7,500 Interfund Transfers 322,362 EXPENSE TOTALS 5,109,701 Depreciation Expense - Contingencies - Debt Service 21,797 Capital Outlay 275,750 Insurance and Other Chargebacks 122,247 Community Sponsored Organizations - EXPENSE Salary and Benefits 871,369 Services and Supplies 3,488,676 Other Revenue 238,000 Interest Income - REVENUE TOTALS 4,851,361 Charges for Services 3,632,394 Interfund Transfers 705,967 Intergovernmental Revenue - Fund 520 - SOLID WASTE FUND REVENUE Property Taxes - Licenses, Permits and Fees 275,000 Budget by Organization Through 01/31/18 2018 Classification Budget Run by Kate LewisLakin on 03/13/2018 09:51:04 AM Page 31 of 51 January YTD 2017 2018 2018 Actual 249,053 249,053 2,478,435 - - - - - - - - 19,016 13 13 339 249,067 249,067 2,497,791 52,284 52,284 946,222 24,124 24,124 1,736,789 - - - 10,058 10,058 191,454 - - - - - - - - - - - - 2,787 2,787 27,833 89,253 89,253 2,902,298 249,067 249,067 2,497,791 89,253 89,253 2,902,298 159,814 159,814 (404,508) Starting Fund Balance 358,236 358,236 Net Change (192,655) 159,814 Ending Fund Balance 165,581 518,050 EXPENSE TOTALS 3,333,871 Fund 600 - FLEET SERVICES FUND Totals (192,655) Fund 600 - FLEET SERVICES FUND Totals REVENUE TOTALS 3,141,216 Miscellaneous - Interfund Transfers 33,442 EXPENSE TOTALS 3,333,871 Depreciation Expense - Contingencies 450 Debt Service - Services and Supplies 2,230,057 Capital Outlay - Insurance and Other Chargebacks 185,266 REVENUE TOTALS 3,141,216 EXPENSE Salary and Benefits 884,656 Intergovernmental Revenue - Other Revenue 81,781 Interest Income 1,000 Fund 600 - FLEET SERVICES FUND REVENUE Charges for Services 3,058,435 Interfund Transfers - Budget by Organization Through 01/31/18 2018 Classification Budget Run by Kate LewisLakin on 03/13/2018 09:51:04 AM Page 32 of 51 January YTD 2017 2018 2018 Actual 111,228 111,228 1,400,057 - - - (3,786) (3,786) 115,946 75 75 2,128 107,517 107,517 1,518,131 - - 63,485 - - 1,233,938 - - - - - - - - 1,297,422 107,517 107,517 1,518,131 - - 1,297,422 107,517 107,517 220,709 Starting Fund Balance 1,076,977 1,076,977 Net Change (20,147) 107,517 Ending Fund Balance 1,056,830 1,184,494 EXPENSE TOTALS 1,597,977 Fund 601 - EQUIPMENT REPLACEMENT (20,147) Fund 601 - EQUIPMENT REPLACEMENT REVENUE TOTALS 1,577,830 Depreciation Expense - Miscellaneous - EXPENSE TOTALS 1,597,977 EXPENSE Services and Supplies 75,000 Capital Outlay 1,522,977 Other Revenue 210,217 Interest Income - REVENUE TOTALS 1,577,830 Fund 601 - EQUIPMENT REPLACEMENT FUND REVENUE Charges for Services 1,367,613 Interfund Transfers - Budget by Organization Through 01/31/18 2018 Classification Budget Run by Kate LewisLakin on 03/13/2018 09:51:04 AM Page 33 of 51 January YTD 2017 2018 2018 Actual 15,504 15,504 162,411 68 68 2,300,820 - - - 649,148 649,148 10,917,001 172,229 172,229 1,032,678 418,720 418,720 5,620,181 174 174 382 1,255,844 1,255,844 20,033,473 44,817 44,817 539,795 1,335 1,335 5,224,268 - - - 1,420,812 1,420,812 16,774,833 - - - - - - - - - - - - - - - 803 803 9,632 1,467,766 1,467,766 22,548,528 1,255,844 1,255,844 20,033,473 1,467,766 1,467,766 22,548,528 (211,923) (211,923) (2,515,054) Starting Fund Balance (5,348,035) (5,348,035) Net Change 653,342 (211,923) Ending Fund Balance (4,694,693) (5,559,958) EXPENSE TOTALS 18,439,931 Fund 605 - INSURANCE FUND Totals 653,342 Fund 605 - INSURANCE FUND Totals REVENUE TOTALS 19,093,273 Miscellaneous - Interfund Transfers 9,632 EXPENSE TOTALS 18,439,931 Depreciation Expense - Contingencies - Debt Service - Capital Outlay - Insurance and Other Chargebacks 15,387,920 Community Sponsored Organizations - EXPENSE Salary and Benefits 656,931 Services and Supplies 2,385,448 Insurance 5,815,014 Interest Income 1,000 REVENUE TOTALS 19,093,273 Intergovernmental Revenue - Other Revenue 10,858,534 Workers Compensation and Liability 2,196,415 Fund 605 - INSURANCE FUND REVENUE Charges for Services 162,411 Interfund Transfers 59,899 Budget by Organization Through 01/31/18 2018 Classification Budget Run by Kate LewisLakin on 03/13/2018 09:51:04 AM Page 34 of 51 January YTD 2017 2018 2018 Actual - - - - - - - - - 3,051,663 3,051,663 15,218,533 186,645 186,645 2,072,811 3,238,308 3,238,308 17,291,343 745,989 745,989 8,682,009 - - - - - - - - - 10,324 10,324 133,640 756,313 756,313 8,815,649 3,238,308 3,238,308 17,291,343 756,313 756,313 8,815,649 2,481,995 2,481,995 8,475,695 Starting Fund Balance 79,101,435 79,101,435 Net Change 4,989,947 2,481,995 Ending Fund Balance 84,091,382 81,583,430 Fund 700 - FIRE PENSION FUND Totals 4,989,947 Fund 700 - FIRE PENSION FUND Totals REVENUE TOTALS 13,784,947 EXPENSE TOTALS 8,795,000 Miscellaneous - EXPENSE TOTALS 8,795,000 Services and Supplies - Community Sponsored Organizations - Debt Service - REVENUE TOTALS 13,784,947 EXPENSE Salary and Benefits 8,795,000 Interfund Transfers 10,000 Other Revenue 9,394,947 Interest Income 4,100,000 Fund 700 - FIRE PENSION FUND REVENUE Property Taxes - Other Taxes 280,000 Budget by Organization Through 01/31/18 2018 Classification Budget Run by Kate LewisLakin on 03/13/2018 09:51:04 AM Page 35 of 51 January YTD 2017 2018 2018 Actual - - - - - - - - - 4,281,465 4,281,465 24,497,048 121,428 121,428 2,830,019 4,402,893 4,402,893 27,327,068 983,670 983,670 11,624,574 - - - - - - 60,238 60,238 264,371 1,043,908 1,043,908 11,888,945 4,402,893 4,402,893 27,327,068 1,043,908 1,043,908 11,888,945 3,358,985 3,358,985 15,438,122 Starting Fund Balance #######121,645,511 Net Change 6,194,704 3,358,985 Ending Fund Balance 127,840,215 125,004,496 REVENUE TOTALS 18,719,704 EXPENSE TOTALS 12,525,000 Fund 705 - POLICE PENSION FUND Totals 6,194,704 EXPENSE TOTALS 12,525,000 Fund 705 - POLICE PENSION FUND Totals Services and Supplies - Debt Service - Miscellaneous 270,000 REVENUE TOTALS 18,719,704 EXPENSE Salary and Benefits 12,255,000 Interfund Transfers 57,000 Other Revenue 12,162,704 Interest Income 6,500,000 Fund 705 - POLICE PENSION FUND REVENUE Property Taxes - Other Taxes - Budget by Organization Through 01/31/18 2018 Classification Budget Run by Kate LewisLakin on 03/13/2018 09:51:04 AM Page 36 of 51