The URL can be used to link to this page

Home My WebLink About2016.07 July Monthly Report To: Wally Bobkiewicz, City Manager Martin Lyons, Assistant City Manager/Chief Financial Officer From: Ashley King, Finance Division Manager Subject: July 2016 Monthly Financial Report Date: September 9, 2016 Please find attached the unaudited financial statements as of July 31, 2015. A summary by fund for revenues, expenditures, fund and cash balances is as follows: YTD Revenues YTD Expenses YTD Net Fund Balance Cash Balance 100 GENERAL FUND 68,181,915 63,297,715 4,884,200 15,790,000 10,046,315 175 GENERAL ASSISTANCE 604,291 457,132 147,159 660,398 662,141 180 GOOD NEIGHBOR FUND 291,667 (291,667)750,000 708,333 185 LIBRARY FUND 4,489,966 3,692,154 797,813 973,366 1,467,395 195 NSP2 4,999 27,008 (22,009)(22,009)186,762 200 MOTOR FUEL TAX FUND 1,082,484 1,383,450 (300,966)1,711,844 1,387,065 205 E911 454,632 802,105 (347,472)216,510 29,531 210 SSA #4 224,556 161,500 63,056 (127,488)(127,488) 215 CDBG FUND 87,603 549,053 (461,450)(401,568)(401,567) 220 CDBG LOAN 71,498 121,375 (49,877)108,488 162,013 225 ECONOMIC DEVELOPMENT 1,662,682 1,233,616 429,066 3,057,045 2,650,361 235 NEIGHBORHOOD IMP 169,915 169,915 240 HOME FUND 116,705 133,118 (16,413)(11,575)(11,644) 250 AFFORDABLE HOUSING 181,491 105,828 75,662 1,069,542 1,032,822 186 LIBRARY DEBT SERVICE 253,044 72,675 180,370 217,034 66,581 300 WASHINGTON NATIONAL 3,418,740 3,782,558 (363,818)6,611,259 6,157,531 305 SSA #5 287,860 17,250 270,610 796,039 796,039 310 HOWARD-HARTREY TIF 744,165 1,228,128 (483,963)943,190 858,224 315 SOUTHWEST TIF FUND 330 HOWARD-RIDGE TIF FUND 392,335 351,239 41,096 17,475 14,744 335 WEST EVANSTON TIF 7,041 21,661 (14,619)430,144 435,966 340 DEMPSTER-DODGE TIF 345 CHICAGO-MAIN TIF 580,000 604,104 (24,104)287,966 287,966 320 DEBT SERVICE FUND 8,719,283 4,161,702 4,557,582 7,035,816 7,168,493 415 CAPITAL IMPROVEMENTS 4,822,365 2,112,505 2,709,860 7,700,985 9,267,893 420 SPECIAL ASSESSMENT 109,459 188,694 (79,235)2,611,879 2,600,009 505 PARKING SYSTEM FUND 6,307,941 4,287,127 2,020,814 12,624,660 12,348,270 510-WATER 17,504,053 18,447,150 (943,097)8,591,731 5,045,992 515 SEWER FUND 7,963,399 6,748,820 1,214,579 5,293,418 2,837,259 520 SOLID WASTE FUND 2,813,602 2,585,306 228,296 (1,046,633)(1,549,014) 176 HEALTH AND HUMAN 516,130 423,754 92,376 18,643 127,782 600 FLEET SERVICES FUND 1,984,752 1,447,314 537,438 620,597 228,258 601 EQUIPMENT 880,332 18,301 862,032 2,018,465 1,744,650 605 INSURANCE FUND 9,592,827 9,775,749 (182,922)(828,438)2,238,533 144,060,152 128,529,754 15,530,398 77,888,697 68,637,128 Fund NOTE: Negative Cash Balances (as seen above in the CDBG, SSA 4, HOME & Solid Waste Fund) reflect internal account balances and not external bank balances, due to transaction timing at month end. Also note that monthly fund balance is calculated as ending 2015 audited fund balance + YTD Net without other balance sheet adjustments. Memorandum Included above are the ending balances as of July 31, 2016 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 July 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. As of July 31, 2016, the General Fund is reporting a net surplus of $4,884,200. The attached supplemental charts show the General Fund Revenues at 60.80% of budget and expenses lower at 56.67%. The July target is 58.3%. Due to timing, there were 3 payrolls in July. Also, the General Fund revenues include the $2.9 million permit from Northwestern which was received in June. There will also be 3 payrolls in December. Parks and Recreation seasonal expenses will continue to show up in reports through September. Through July 31, 2016, the SSA #4 Fund is showing a negative cash balance of $127,488 due to the timing of payments to the Downtown Evanston group and receipt of property taxes. Through July 31, 2016, the CDBG Fund is showing a negative cash balance of $401,567 which will be reimbursed from July draw-downs. Through July 31, 2016, the Economic Development Fund is showing a fund balance of $3,057,045 and a cash balance of $2,650,361. Special Service Area #5 received 2016 property taxes in error for the first installment. This is due to the first property tax installment always being 55% of the previous year’s tax amount. This money will be refunded to the County during the second installment billing. The fund will then officially close. Through July 31, 2016, the enterprise funds (Parking, Water, and Sewer) have balances above average. As construction season continues, the balances in all three of these funds will be reduced. Through July 31, 2016, the Solid Waste Fund has a negative fund balance of $1,046,633 and a negative cash balance of $1,549,014. Through July 31, 2016, the Insurance Fund is showing a negative fund balance of $828,438 with a cash balance of $2,238,533. If there are any questions on the attached report, please contact me by phone at (847) 859-7884 or by email: aking@cityofevanston.org. Detailed fund summary reports can be found at the following link: http://www.cityofevanston.org/city-budget/financial- reports/. Fund 100 - GENERAL FUND 2016 Budget July Actual YTD Actual %2015 Actual 27,417,407 641,829 19,590,083 71.45%25,915,970 45,986,550 3,721,991 24,691,992 53.69%44,978,985 5,329,777 64,460 1,888,445 35.43%5,324,137 9,276,550 595,985 9,032,209 97.37%6,704,846 125,700 703 42,774 34.03%155,619 4,609,825 324,055 1,936,619 42.01%3,548,230 640,000 0.00%640,000 5,374,751 354,565 4,108,640 76.44%5,406,379 2,433,216 141,830 1,455,424 59.81%2,239,528 8,842,365 646,242 4,523,692 51.16%7,836,484 765,727 84,743 410,102 53.56%670,245 1,286,843 45,839 488,704 37.98%894,703 50,000 2,843 13,232 26.46%6,572 112,138,711 6,625,084 68,181,915 60.80%104,321,698 424,958 40,306 246,107 57.91%419,962 263,203 32,332 170,006 64.59%283,764 6,989,746 688,190 3,505,934 50.16%1,814,469 1,130,000 122,382 580,069 51.33%1,051,325 9,634,173 871,698 4,828,498 50.12%24,887,860 2,740,032 259,534 1,395,957 50.95%2,425,618 37,696,278 3,001,933 22,429,921 59.50%28,493,534 22,601,742 1,697,144 14,094,295 62.36%14,954,025 3,544,226 341,202 1,796,548 50.69%3,212,848 11,820,590 2,057,025 6,486,522 54.87%11,180,116 14,861,248 1,334,208 7,768,599 52.27% 111,706,196 10,445,954 63,302,455 56.67%88,723,520 112,138,711 6,625,084 56,479,505 50%104,321,698 111,706,196 10,445,954 51,595,305 46%106,872,275 432,515 (3,820,870)4,884,200 (861%)(2,550,577)Fund 100 - GENERAL FUND PUBLIC WORKS AGENCY EXPENSES Fund 100 - GENERAL FUND REVENUE TOTALS EXPENSE TOTALS ADMINISTRATIVE SERVICES COMMUNITY DEVELOPMENT POLICE FIRE MGMT & SUPPORT HEALTH PARKS, REC. AND COMMUNITY Interest Income REVENUES CITY COUNCIL CITY CLERK CITY MANAGER'S OFFICE LAW Parking Charges for Services Parks and Recreation Charges for Other Charges for Services Interfund Transfers Intergovernmental Revenue Other Revenue Property Taxes Other Taxes License Permit Fee Fines and Forfeitures Income Statement Through 07/31/16 Summary Listing Classification Fund 505 - PARKING SYSTEM FUND 2016 Budget July Actual YTD Actual %2015 Actual 3,000 +++150 6,379,675 486,306 3,851,214 60.37%6,010,558 65,000 167,000 168,500 259.23% 3,711,770 309,314 2,165,198 58.33%2,925,296 12,125 0.00% 119,216 12,467 105,065 88.13%153,545 35,070 3,310 14,964 42.67%18,260 10,322,856 978,397 6,307,941 61.11%9,107,809 23,000 4,209 16,112 70.05%29,187 1,348,940 145,953 732,758 54.32%1,125,491 113,349 12,808 60,031 52.96%(33,034) 3,022,411 622,455 1,710,222 56.58%2,616,554 278,864 5,639 114,275 40.98%243,068 3,474,000 108,204 442,571 12.74%128,726 319,648 26,637 186,462 58.33%319,649 2,873,395 0.00%2,846,227 11,000 988 2,973 27.03%6,951 3,917,652 199,979 5.10%503,423 252,000 20,569 61,203 24.29%23,687 1,303,783 108,649 760,540 58.33%923,092 16,938,042 1,056,110 4,287,127 25.31%8,733,020 10,322,856 978,397 6,307,941 61%9,107,809 16,938,042 1,056,110 4,287,127 25%8,733,020 (6,615,186)(77,713)2,020,814 (31%)374,789 EXPENSE TOTALS Fund 505 - PARKING Miscellaneous Interfund Transfers EXPENSES Fund 505 - PARKING SYSTEM REVENUE TOTALS Supplies Capital Outlay Insurance and Other Chargebacks Depreciation Expense Contingencies Debt Service Interest Income REVENUES Employee Pay Benefits Pensions Services Permit Parking Charges for Services Parks and Recreation Charges for Interfund Transfers Intergovernmental Revenue Other Revenue Income Statement Through 07/31/16 Summary Listing Classification Fund 510 - WATER FUND 2016 Budget July Actual YTD Actual %2015 Actual 70,000 9,850 59,677 85.25%105,483 15,133,000 2,826,029 10,500,442 69.39%15,141,770 39,000 4,733 25,310 64.90%40,911 126,000 134,050 134,330 106.61%125,545 500,000 6,697,244 #DIV/0!2,354,582 22,348,400 38,973 79,342 0.36%350,065 1,600 1,772 7,707 481.71%3,448 37,718,000 3,515,407 17,504,053 46.41%18,121,804 210,465 30,813 104,725 49.76%157,679 4,534,306 505,664 2,580,548 56.91%4,547,958 360,355 46,297 220,490 61.19%(114,870) 2,098,760 25,126 807,494 38.47%1,250,874 1,392,190 47,117 466,892 33.54%1,048,119 24,776,106 278,486 4,868,729 19.65%105 468,492 39,042 273,293 58.33%468,493 #DIV/0!2,096,633 1,000 658 65.80%933 1,053,288 373,518 35.46%432,628 62,980 3,615 10,543 16.74%(286,678) 3,502,313 791,859 8,740,260 249.56%3,692,565 38,460,255 1,768,019 18,447,150 47.96%13,294,439 37,718,000 3,015,384 17,504,053 29%18,121,804 13,759,949 1,489,533 18,447,150 98%13,294,439 23,958,051 1,525,851 (943,097)(11%)4,827,365 Income Statement Through 07/31/16 Summary Listing Classification Fee Water Charges for Services Sewer Charges for Services Other Charges for Services Interfund Transfers Other Revenue Interest Income REVENUES Employee Pay Benefits Pensions Services Supplies Capital Outlay Insurance and Other Chargebacks Depreciation Expense Contingencies Debt Service EXPENSE TOTALS Fund 510 - WATER FUND Net Miscellaneous Interfund Transfers EXPENSES Fund 510 - WATER FUND REVENUE TOTALS Fund 515 - SEWER FUND 2016 Budget July Actual YTD Actual %2015 Actual 12,869,000 903,145 7,405,885 57.55%12,491,290 19,650 0.00%19,650 984,165 554,863 554,863 56.38%2,962 1,000 216 2,651 265.14%2,706 13,873,815 1,458,224 7,963,399 57.40%12,516,607 57,040 4,989 21,192 37.15%60,837 1,025,778 101,743 587,497 57.27%1,000,833 86,092 9,154 48,966 56.88%(27,099) 903,500 9,020 205,572 22.75%90,109 92,300 2,498 17,499 18.96%18,817 3,048,314 2,975 663,101 21.75%13,609 269,988 22,499 283,240 104.91%269,988 #DIV/0!3,443,723 9,222,913 345,238 4,612,030 50.01%1,550,407 1,500 5,000 333.33%3,306 773,876 43,532 304,722 39.38%735,235 15,481,301 541,646 6,748,820 43.59%7,159,766 13,873,815 1,458,224 7,963,399 57%12,516,607 15,481,301 541,646 6,748,820 44%7,159,766 (1,607,486)916,578 1,214,579 (76%)5,356,842 Fund 515 - SEWER FUND REVENUE TOTALS EXPENSE TOTALS Fund 515 - SEWER FUND Depreciation Expense Debt Service Miscellaneous Interfund Transfers EXPENSES Benefits Pensions Services Supplies Capital Outlay Insurance and Other Chargebacks Sewer Charges for Services Other Charges for Services Other Revenue Interest Income REVENUES Employee Pay Income Statement Through 07/31/16 Summary Listing Classification Fund 520 - SOLID WASTE FUND 2016 Budget July Actual YTD Actual %2015 Actual 275,000 81,934 29.79%213,490 3,632,394 293,474 2,065,597 56.87%3,561,584 1,055,967 87,997 615,981 58.33%1,055,967 238,000 2,925 50,090 21.05%228,469 5,201,361 384,397 2,813,602 54.09%5,059,510 25,000 6,554 27,715 110.86%41,358 779,380 87,208 426,631 54.74%823,923 63,718 7,839 35,906 56.35%(15,981) 3,679,126 94,243 1,757,317 47.76%3,644,097 53,050 8,235 30,326 57.17%73,788 25,750 2,664 10.35%24,738 1,144 #DIV/0!68,419 15,000 12,232 12,232 81.55% 499,493 41,624 291,371 58.33%490,106 5,140,517 257,935 2,585,306 50.29%5,150,448 5,201,361 384,397 2,813,602 54%5,059,510 5,140,517 257,935 2,585,306 50%5,150,448 60,844 126,462 228,296 375%(90,938) EXPENSE TOTALS Fund 520 - SOLID WASTE Miscellaneous Interfund Transfers EXPENSES Fund 520 - SOLID WASTE REVENUE TOTALS Benefits Pensions Services Supplies Capital Outlay Debt Service License Other Charges for Services Interfund Transfers Other Revenue REVENUES Employee Pay Income Statement Through 07/31/16 Summary Listing Classification July 2016 YTD Actual Actual 2015 Actual 641,829 19,590,083 25,915,970 3,721,991 24,691,992 44,978,985 661,148 10,963,428 12,184,602 324,055 1,936,619 3,548,230 496,394 5,564,063 8,285,907 - 3,877,451 7,836,484 84,743 410,102 670,245 45,839 488,704 894,703 - - - - - - - - - 2,843 13,232 6,572 - - - - - - 5,978,843 67,535,674 104,321,698 7,804,791 39,165,532 68,732,666 1,608,784 5,612,461 11,506,401 18,364 85,488 155,975 30,869 1,541,991 3,020,991 - 433,072 952,678 - - - 50,000 50,089 30,529 - - - 85,941 830,385 17,171,181 - 14,731,493 5,301,854 9,598,749 62,450,510 106,872,275 5,978,843 67,535,674 104,321,698 9,598,749 62,450,510 106,872,275 (3,619,906) 5,085,164 (2,550,577) Starting Fund Balance 10,704,836 10,704,836 Net Change (567,485) 5,085,164 Ending Fund Balance 10,137,351 15,790,000 Budget by Organization Report Through 07/31/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 100 - GENERAL FUND REVENUE Property Taxes 27,417,407 Other Taxes 45,986,550 Licenses, Permits and Fees 14,732,027 Fines and Forfeitures 4,609,825 Charges for Services 8,447,967 Interfund Transfers 8,842,365 Intergovernmental Revenue 765,727 Other Revenue 1,286,843 Workers Compensation and Liability - Insurance - Library Revenue - Interest Income 50,000 Special Assessment - Reappropriation of Surplus - REVENUE TOTALS 112,138,711 EXPENSE Salary and Benefits 71,035,352 Services and Supplies 11,834,924 Capital Outlay 200,600 Insurance and Other Chargebacks 20,282,973 Community Sponsored Organizations 925,029 Depreciation Expense - Contingencies 213,505 Debt Service - Miscellaneous 1,679,285 Interfund Transfers 6,534,528 EXPENSE TOTALS 112,706,196 Fund 100 - GENERAL FUND Totals REVENUE TOTALS 112,138,711 EXPENSE TOTALS 112,706,196 Fund 100 - GENERAL FUND Totals (567,485) Run by Ashley King on 08/27/2016 01:50:21 PM Page 1 of 122 July 2016 YTD Actual Actual 2015 Actual (79,479) 568,023 1,313,420 - - - - - - - - - - - - - - - - - 3,208 - 36,035 19,534 - - - - - - - - - 22 233 62 - - - - - - (79,457) 604,291 1,336,224 25,226 149,005 185,431 45,244 303,889 592,645 - - - - - - - - - - - - - - - - - - 4,000 4,238 4,625 - - - 74,470 457,132 782,701 (79,457) 604,291 1,336,224 74,470 457,132 782,701 (153,928) 147,159 553,522 Starting Fund Balance 513,239 513,239 Net Change 38,167 147,159 Ending Fund Balance 551,406 660,398 Budget by Organization Report Through 07/31/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 175 - GENERAL ASSISTANCE FUND REVENUE Property Taxes 1,000,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 1,026,000 EXPENSE Salary and Benefits 221,933 Services and Supplies 758,900 Capital Outlay - Insurance and Other Chargebacks - Community Sponsored Organizations - Depreciation Expense - Contingencies - Debt Service - Miscellaneous 7,000 Interfund Transfers - EXPENSE TOTALS 987,833 Fund 175 - GENERAL ASSISTANCE REVENUE TOTALS 1,026,000 EXPENSE TOTALS 987,833 Fund 175 - GENERAL ASSISTANCE 38,167 Run by Ashley King on 08/27/2016 01:50:21 PM Page 4 of 122 July 2016 YTD Actual Actual 2015 Actual - - - - 442,397 884,794 - - - - - - - 442,397 884,794 - - - - - - 200,824 423,754 849,388 - - - 200,824 423,754 849,388 - 442,397 884,794 200,824 423,754 849,388 (200,824) 18,643 35,406 Starting Fund Balance - - Net Change 25,641 18,643 Ending Fund Balance 25,641 18,643 Budget by Organization Report Through 07/31/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 176 - HEALTH AND HUMAN SERVICES REVENUE Charges for Services - Interfund Transfers 884,794 Intergovernmental Revenue - Other Revenue - REVENUE TOTALS 884,794 EXPENSE Services and Supplies - 884,794 Capital Outlay - Community Sponsored Organizations 859,153 Miscellaneous - EXPENSE TOTALS 859,153 Fund 176 - HEALTH AND HUMAN 25,641 EXPENSE TOTALS 859,153 Fund 176 - HEALTH AND HUMAN REVENUE TOTALS Run by Ashley King on 08/27/2016 01:50:21 PM Page 7 of 122 July 2016 YTD Actual Actual 2015 Actual - 1,000,000 - - 1,000,000 - - 250,000 - - 250,000 - - 1,000,000 - - 250,000 - - 750,000 - Starting Fund Balance - - Net Change - 750,000 Ending Fund Balance - 750,000 Budget by Organization Report Through 07/31/16 Prior Fiscal Year Activity Included 2016 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 Fund 180 - GOOD NEIGHBOR REVENUE TOTALS 1,000,000 EXPENSE TOTALS 1,000,000 Fund 180 - GOOD NEIGHBOR - Run by Ashley King on 08/27/2016 01:50:21 PM Page 10 of 122 July 2016 YTD Actual Actual 2015 Actual 943,486 4,222,005 5,916,852 - - 46,059 16,484 81,927 129,808 - - 171,000 57,418 57,418 181,283 10,962 26,574 286 28,866 99,034 315,924 174 3,009 2,683 1,057,390 4,489,966 6,763,897 510,591 2,634,683 4,872,876 119,418 828,054 1,425,484 - 37,599 299,628 - 40,045 77,268 - - - - - - - - - - 125,000 250,000 - 5,091 4,200 630,009 3,670,472 6,929,456 1,057,390 4,489,966 6,763,897 630,009 3,670,472 6,929,456 427,381 819,495 (165,560) Starting Fund Balance 153,871 153,871 Net Change 20,015 819,495 Ending Fund Balance 173,886 973,366 Budget by Organization Report Through 07/31/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 185 - LIBRARY FUND REVENUE Property Taxes 6,104,180 Other Taxes 50,200 Fines and Forfeitures 160,000 Interfund Transfers 185,800 Intergovernmental Revenue 94,177 Other Revenue 87,500 Library Revenue 333,300 Interest Income 2,000 REVENUE TOTALS 7,017,157 EXPENSE Salary and Benefits 4,751,497 Services and Supplies 1,872,573 Capital Outlay 32,800 Insurance and Other Chargebacks 80,089 Depreciation Expense - Contingencies - 7,017,157 Debt Service - Miscellaneous 250,000 Interfund Transfers 10,183 EXPENSE TOTALS 6,997,142 Fund 185 - LIBRARY FUND Totals 20,015 EXPENSE TOTALS 6,997,142 Fund 185 - LIBRARY FUND Totals REVENUE TOTALS Run by Ashley King on 08/27/2016 01:50:21 PM Page 13 of 122 July 2016 YTD Actual Actual 2015 Actual 58,994 253,044 601,811 - - - 58,994 253,044 601,811 - - - - 41,447 - - 31,228 562,740 - - - - 72,675 562,740 58,994 253,044 601,811 - 72,675 562,740 58,994 180,370 39,072 Starting Fund Balance 36,664 36,664 Net Change - 180,370 Ending Fund Balance 36,664 217,034 Budget by Organization Report Through 07/31/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 186 - LIBRARY DEBT SERVICE FUND REVENUE Property Taxes 393,409 Interest Income - REVENUE TOTALS 393,409 EXPENSE Services and Supplies - Capital Outlay - Debt Service 393,409 Miscellaneous - EXPENSE TOTALS 393,409 Fund 186 - LIBRARY DEBT REVENUE TOTALS 393,409 EXPENSE TOTALS 393,409 Fund 186 - LIBRARY DEBT - Run by Ashley King on 08/27/2016 01:50:21 PM Page 16 of 122 July 2016 YTD Actual Actual 2015 Actual - - - - 4,863 130,126 - - - 17 136 - 17 4,999 130,126 2,878 15,207 59,467 - 3,060 4,611 - 4,863 68,352 - 2,172 5,730 - - - - 1,705 179 - - (8,213) 2,878 27,008 130,126 17 4,999 130,126 2,878 27,008 130,126 (2,861) (22,009) - Starting Fund Balance - - Net Change (303) (22,009) Ending Fund Balance (303) (22,009) Budget by Organization Report Through 07/31/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 195 - NEIGHBORHOOD STABILIZATION FUND REVENUE Licenses, Permits and Fees - Intergovernmental Revenue 198,651 Other Revenue - Interest Income - REVENUE TOTALS 198,651 EXPENSE Salary and Benefits 33,648 Services and Supplies 5,100 Capital Outlay 35,000 Insurance and Other Chargebacks 4,344 198,651 Debt Service - Miscellaneous 120,862 Interfund Transfers - EXPENSE TOTALS 198,954 Fund 195 - NEIGHBORHOOD (303) EXPENSE TOTALS 198,954 Fund 195 - NEIGHBORHOOD REVENUE TOTALS Run by Ashley King on 08/27/2016 01:50:21 PM Page 19 of 122 July 2016 YTD Actual Actual 2015 Actual 106,170 1,078,896 2,465,781 - - - 632 3,588 819 - - - 106,803 1,082,484 2,466,600 - - - - 106,533 1,583,238 - - - - - - - - - - 1,094,500 833,000 - 1,201,033 2,416,238 106,803 1,082,484 2,466,600 - 1,201,033 2,416,238 106,803 (118,549) 50,362 Starting Fund Balance 1,830,393 1,830,393 Net Change (478,000) (118,549) Ending Fund Balance 1,352,393 1,711,844 Budget by Organization Report Through 07/31/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 200 - MOTOR FUEL TAX FUND REVENUE Intergovernmental Revenue 1,710,000 Other Revenue - Interest Income 1,000 Reappropriation of Surplus - REVENUE TOTALS 1,711,000 EXPENSE Services and Supplies - Capital Outlay - Contingencies - Debt Service - Miscellaneous - Interfund Transfers 2,189,000 EXPENSE TOTALS 2,189,000 Fund 200 - MOTOR FUEL TAX (478,000) Fund 200 - MOTOR FUEL TAX REVENUE TOTALS 1,711,000 EXPENSE TOTALS 2,189,000 Run by Ashley King on 08/27/2016 01:50:21 PM Page 22 of 122 July 2016 YTD Actual Actual 2015 Actual 89,109 453,315 977,071 - - - - - 100 183 1,317 189 89,291 454,632 977,361 64,876 333,213 584,120 4,364 211,700 347,694 5,673 165,100 239,421 - 14,963 29,486 - - - - - 2,046 - - - - - 1,500 - 64,865 129,729 74,914 789,840 1,333,996 89,291 454,632 977,361 74,914 789,840 1,333,996 14,377 (335,208) (356,635) Starting Fund Balance 551,718 551,718 Net Change (497,643) (335,208) Ending Fund Balance 54,075 216,510 Budget by Organization Report Through 07/31/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 205 - EMERGENCY TELEPHONE (E911) FUND REVENUE Other Taxes 1,018,000 Intergovernmental Revenue - Other Revenue - Interest Income 1,000 REVENUE TOTALS 1,019,000 EXPENSE Salary and Benefits 580,773 Services and Supplies 377,600 Capital Outlay 393,615 Insurance and Other Chargebacks 29,926 Community Sponsored Organizations - Contingencies 5,000 Debt Service - Miscellaneous - Interfund Transfers 129,729 EXPENSE TOTALS 1,516,643 Fund 205 - EMERGENCY (497,643) Fund 205 - EMERGENCY REVENUE TOTALS 1,019,000 EXPENSE TOTALS 1,516,643 Run by Ashley King on 08/27/2016 01:50:21 PM Page 25 of 122 July 2016 YTD Actual Actual 2015 Actual 9,961 224,555 322,055 - 1 3 9,961 224,556 322,058 - 161,500 323,000 - - - - - - - 161,500 323,000 9,961 224,556 322,058 - 161,500 323,000 9,961 63,056 (942) Starting Fund Balance (190,544) (190,544) Net Change - 63,056 Ending Fund Balance (190,544) (127,488) Budget by Organization Report Through 07/31/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 210 - SPECIAL SERVICE AREA (SSA) #4 REVENUE Property Taxes 320,000 Interest Income - REVENUE TOTALS 320,000 320,000 EXPENSE Services and Supplies 320,000 Debt Service - Miscellaneous - EXPENSE TOTALS 320,000 Fund 210 - SPECIAL SERVICE AREA - EXPENSE TOTALS 320,000 Fund 210 - SPECIAL SERVICE AREA REVENUE TOTALS Run by Ashley King on 08/27/2016 01:50:21 PM Page 28 of 122 July 2016 YTD Actual Actual 2015 Actual - - - - - - 25,000 77,406 1,502,924 - 10,197 3,318 - - - 25,000 87,603 1,506,242 53,601 275,721 362,786 2,087 4,531 17,538 - 183,255 276,834 - 2,273 20,767 - - 235,459 - - - - - - 25,021 83,095 72,442 - 177 449,083 80,708 549,053 1,434,909 25,000 87,603 1,506,242 80,708 549,053 1,434,909 (55,708) (461,450) 71,333 Starting Fund Balance 59,882 59,882 Net Change 375 (461,450) Ending Fund Balance 60,257 (401,568) Budget by Organization Report Through 07/31/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 215 - CDBG FUND REVENUE Charges for Services - Interfund Transfers - Intergovernmental Revenue 2,595,000 Other Revenue - Interest Income - REVENUE TOTALS 2,595,000 EXPENSE Salary and Benefits 452,432 Services and Supplies 3,800 Capital Outlay - Insurance and Other Chargebacks 26,989 Community Sponsored Organizations - Contingencies - 2,595,000 Debt Service - Miscellaneous 1,274,280 Interfund Transfers 837,124 EXPENSE TOTALS 2,594,625 Fund 215 - CDBG FUND Totals 375 EXPENSE TOTALS 2,594,625 Fund 215 - CDBG FUND Totals REVENUE TOTALS Run by Ashley King on 08/27/2016 01:50:21 PM Page 31 of 122 July 2016 YTD Actual Actual 2015 Actual - - - 3,017 66,961 14,951 16 4,537 375 3,033 71,498 15,326 - - - 355 63,495 280,461 - 57,880 1,919 - - - 355 121,375 282,380 3,033 71,498 15,326 355 121,375 282,380 2,678 (49,877) (267,054) Starting Fund Balance 158,365 158,365 Net Change - (49,877) Ending Fund Balance 158,365 108,488 Budget by Organization Report Through 07/31/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 220 - CDBG LOAN REVENUE Intergovernmental Revenue - Other Revenue 350,000 Interest Income - REVENUE TOTALS 350,000 EXPENSE Salary and Benefits - Services and Supplies 340,000 Miscellaneous 10,000 Interfund Transfers - EXPENSE TOTALS 350,000 Fund 220 - CDBG LOAN Totals - Fund 220 - CDBG LOAN Totals REVENUE TOTALS 350,000 EXPENSE TOTALS 350,000 Run by Ashley King on 08/27/2016 01:50:21 PM Page 34 of 122 July 2016 YTD Actual Actual 2015 Actual 589,066 1,417,562 2,116,843 - - - - - - - 237,061 49,000 111 8,059 128 589,177 1,662,682 2,165,971 65,269 333,452 600,779 11,302 137,948 302,867 103,085 153,144 194,941 - 14,642 32,230 - - - - - - - - - - 97,436 1,293,041 - 424,998 600,000 179,656 1,161,619 3,023,858 589,177 1,662,682 2,165,971 179,656 1,161,619 3,023,858 409,521 501,063 (857,887) Starting Fund Balance 2,555,982 2,555,982 Net Change (286,099) 501,063 Ending Fund Balance 2,269,883 3,057,045 Budget by Organization Report Through 07/31/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 225 - ECONOMIC DEVELOPMENT FUND REVENUE Other Taxes 2,165,000 Interfund Transfers 47,500 Intergovernmental Revenue - Other Revenue 50,000 Interest Income 100 REVENUE TOTALS 2,262,600 EXPENSE Salary and Benefits 734,229 Services and Supplies 912,200 Capital Outlay 253,500 Insurance and Other Chargebacks 32,770 Community Sponsored Organizations - Contingencies - 2,262,600 Debt Service - Miscellaneous 16,000 Interfund Transfers 600,000 EXPENSE TOTALS 2,548,699 Fund 225 - ECONOMIC (286,099) EXPENSE TOTALS 2,548,699 Fund 225 - ECONOMIC REVENUE TOTALS Run by Ashley King on 08/27/2016 01:50:21 PM Page 37 of 122 July 2016 YTD Actual Actual 2015 Actual - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Starting Fund Balance 169,915 169,915 Net Change (80,000) - Ending Fund Balance 89,915 169,915 Budget by Organization Report Through 07/31/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 235 - NEIGHBORHOOD IMPROVEMENT REVENUE Other Taxes 20,000 Interfund Transfers - Interest Income - REVENUE TOTALS 20,000 EXPENSE Services and Supplies - Capital Outlay - 20,000 Debt Service - Miscellaneous 100,000 Interfund Transfers - EXPENSE TOTALS 100,000 Fund 235 - NEIGHBORHOOD (80,000) EXPENSE TOTALS 100,000 Fund 235 - NEIGHBORHOOD REVENUE TOTALS Run by Ashley King on 08/27/2016 01:50:21 PM Page 40 of 122 July 2016 YTD Actual Actual 2015 Actual 70,907 100,848 465,961 2,282 15,849 6,402 0 8 19 73,189 116,705 472,382 4,819 17,310 12,388 68,300 115,330 282,753 - - - - 410 1,368 - - - - - - - - 45,747 - - 26,990 73,119 133,050 369,246 73,189 116,705 472,382 73,119 133,050 369,246 70 (16,345) 103,136 Starting Fund Balance 4,770 4,770 Net Change - (16,345) Ending Fund Balance 4,770 (11,575) Budget by Organization Report Through 07/31/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 240 - HOME FUND REVENUE Intergovernmental Revenue 393,868 Other Revenue 8,300 Interest Income - REVENUE TOTALS 402,168 EXPENSE Salary and Benefits 48,348 Services and Supplies 352,500 Capital Outlay - Insurance and Other Chargebacks 820 Community Sponsored Organizations - 402,168 Debt Service - Miscellaneous 500 Interfund Transfers - EXPENSE TOTALS 402,168 Fund 240 - HOME FUND Totals - EXPENSE TOTALS 402,168 Fund 240 - HOME FUND Totals REVENUE TOTALS Run by Ashley King on 08/27/2016 01:50:21 PM Page 43 of 122 July 2016 YTD Actual Actual 2015 Actual - 36,667 100,000 - - - - - - 694 144,082 125,150 103 741 111 797 181,491 225,261 4,819 17,310 - - - 98 - - - - - - - - - 2,057 88,519 142,171 - - - 6,876 105,828 142,270 797 181,491 225,261 6,876 105,828 142,270 (6,079) 75,662 82,992 Starting Fund Balance 993,880 993,880 Net Change (313,719) 75,662 Ending Fund Balance 680,161 1,069,542 Budget by Organization Report Through 07/31/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 250 - AFFORDABLE HOUSING FUND REVENUE Other Taxes 30,000 Interfund Transfers - Intergovernmental Revenue - Other Revenue 130,400 Interest Income 228 REVENUE TOTALS 160,628 EXPENSE Salary and Benefits 48,347 Services and Supplies 350,000 Capital Outlay - Community Sponsored Organizations - Debt Service - Miscellaneous 76,000 Interfund Transfers - EXPENSE TOTALS 474,347 Fund 250 - AFFORDABLE HOUSING REVENUE TOTALS 160,628 EXPENSE TOTALS 474,347 Fund 250 - AFFORDABLE HOUSING (313,719) Run by Ashley King on 08/27/2016 01:50:21 PM Page 46 of 122 July 2016 YTD Actual Actual 2015 Actual 715,031 3,412,250 4,921,484 - - - - - - - - - 1,581 6,490 3,530 716,612 3,418,740 4,925,014 - - - - 216 1,408 - 4,473 198,823 - - 574,976 - 49,338 110,310 - 3,195,884 3,265,296 - 3,249,911 4,150,811 716,612 3,418,740 4,925,014 - 3,249,911 4,150,811 716,612 168,829 774,203 Starting Fund Balance 6,442,430 6,442,430 Net Change (2,640,683) 168,829 Ending Fund Balance 3,801,747 6,611,259 Budget by Organization Report Through 07/31/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 300 - WASHINGTON NATIONAL TIF FUND REVENUE Property Taxes 5,145,000 Other Taxes - Interfund Transfers - Other Revenue - Interest Income 2,000 REVENUE TOTALS 5,147,000 EXPENSE Salary and Benefits - Services and Supplies 1,000,000 Capital Outlay - 5,147,000 Debt Service - Miscellaneous 500,000 Interfund Transfers 6,287,683 EXPENSE TOTALS 7,787,683 Fund 300 - WASHINGTON (2,640,683) EXPENSE TOTALS 7,787,683 Fund 300 - WASHINGTON REVENUE TOTALS Run by Ashley King on 08/27/2016 01:50:21 PM Page 49 of 122 July 2016 YTD Actual Actual 2015 Actual - 287,825 422,527 - - - - - - - 35 4 - 287,860 422,531 - - - - 17,250 297,150 - - - - 17,250 297,150 - 287,860 422,531 - 17,250 297,150 - 270,610 125,381 Starting Fund Balance 525,429 525,429 Net Change (467,971) 270,610 Ending Fund Balance 57,458 796,039 Budget by Organization Report Through 07/31/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 305 - SPECIAL SERVICE AREA (SSA) #5 REVENUE Property Taxes - Interfund Transfers - Other Revenue - Interest Income 300 REVENUE TOTALS 300 EXPENSE Services and Supplies 51,399 Debt Service 416,872 Miscellaneous - EXPENSE TOTALS 468,271 Fund 305 - SPECIAL SERVICE AREA (467,971) Fund 305 - SPECIAL SERVICE AREA REVENUE TOTALS 300 EXPENSE TOTALS 468,271 Run by Ashley King on 08/27/2016 01:50:21 PM Page 52 of 122 July 2016 YTD Actual Actual 2015 Actual - 742,988 1,248,231 - - - 219 1,177 1,985 219 744,165 1,250,216 - 216 1,158 19,269 76,458 11,402 - - - - - - - 129,192 2,162,381 - 876,225 148,010 19,269 1,082,091 2,322,950 219 744,165 1,250,216 19,269 1,082,091 2,322,950 (19,050) (337,925) (1,072,734) Starting Fund Balance 1,281,115 1,281,115 Net Change (650,450) (337,925) Ending Fund Balance 630,665 943,190 Budget by Organization Report Through 07/31/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 310 - HOWARD-HARTREY TIF REVENUE Property Taxes 1,300,000 Other Revenue - Interest Income 2,000 REVENUE TOTALS 1,302,000 EXPENSE Services and Supplies - Capital Outlay - Community Sponsored Organizations - Debt Service - Miscellaneous 200,000 Interfund Transfers 1,752,450 EXPENSE TOTALS 1,952,450 Fund 310 - HOWARD-HARTREY TIF REVENUE TOTALS 1,302,000 EXPENSE TOTALS 1,952,450 Fund 310 - HOWARD-HARTREY TIF (650,450) Run by Ashley King on 08/27/2016 01:50:21 PM Page 55 of 122 July 2016 YTD Actual Actual 2015 Actual - - - - - - - - - - - - - - - - - - - - 893,387 - - - - - 893,387 - - - - - 893,387 - - (893,387) Starting Fund Balance - - Net Change - - Ending Fund Balance - - Budget by Organization Report Through 07/31/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 315 - SOUTHWEST TIF FUND REVENUE Property Taxes - Interest Income - REVENUE TOTALS - EXPENSE Services and Supplies - Capital Outlay - Debt Service - Miscellaneous - Interfund Transfers - EXPENSE TOTALS - Fund 315 - SOUTHWEST TIF FUND - Fund 315 - SOUTHWEST TIF FUND REVENUE TOTALS - EXPENSE TOTALS - Run by Ashley King on 08/27/2016 01:50:21 PM Page 58 of 122 July 2016 YTD Actual Actual 2015 Actual 1,651,338 7,191,396 11,156,231 - 1,397,696 1,642,654 - - 12,278,473 2,332 12,310 7,668 1,653,670 8,601,402 25,085,026 250 2,250 171,576 - 4,159,452 24,358,022 - - 3,062 - - - 250 4,161,702 24,532,661 1,653,670 8,601,402 25,085,026 250 4,161,702 24,532,661 1,653,420 4,439,700 552,365 Starting Fund Balance 2,596,116 2,596,116 Net Change (2,751,668) 4,439,700 Ending Fund Balance (155,552) 7,035,816 Budget by Organization Report Through 07/31/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 320 - DEBT SERVICE FUND REVENUE Property Taxes 10,879,993 Interfund Transfers 2,646,291 Other Revenue - Interest Income 1,500 REVENUE TOTALS 13,527,784 EXPENSE Services and Supplies 315,770 13,527,784 Debt Service 15,963,682 Miscellaneous - Interfund Transfers - EXPENSE TOTALS 16,279,452 Fund 320 - DEBT SERVICE FUND (2,751,668) EXPENSE TOTALS 16,279,452 Fund 320 - DEBT SERVICE FUND REVENUE TOTALS Run by Ashley King on 08/27/2016 01:50:21 PM Page 61 of 122 July 2016 YTD Actual Actual 2015 Actual 7,594 309,273 540,576 12,852 82,822 64,176 42 240 1,815 20,488 392,335 606,568 3,512 315,858 587,839 - - (6,275) - - - - - - 36 381 585 - - 350 - 30,000 107,500 3,548 346,239 689,999 20,488 392,335 606,568 3,548 346,239 689,999 16,941 46,096 (83,431) Starting Fund Balance (28,621) (28,621) Net Change 24,000 46,096 Ending Fund Balance (4,621) 17,475 Budget by Organization Report Through 07/31/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 330 - HOWARD-RIDGE TIF FUND REVENUE Property Taxes 550,000 Other Revenue 1,120,000 Interest Income 100 REVENUE TOTALS 1,670,100 EXPENSE Services and Supplies 538,000 Capital Outlay 1,000,000 Insurance and Other Chargebacks - Community Sponsored Organizations - Debt Service 600 Miscellaneous - Interfund Transfers 107,500 EXPENSE TOTALS 1,646,100 Fund 330 - HOWARD-RIDGE TIF 24,000 Fund 330 - HOWARD-RIDGE TIF REVENUE TOTALS 1,670,100 EXPENSE TOTALS 1,646,100 Run by Ashley King on 08/27/2016 01:50:21 PM Page 64 of 122 July 2016 YTD Actual Actual 2015 Actual - - - 1,028 6,170 - 171 872 257 1,199 7,041 257 291 507 1,158 - (1,028) (11,205) - - - - - - 437 4,682 7,185 - - 1,227 - 15,000 60,000 728 19,161 58,365 1,199 7,041 257 728 19,161 58,365 471 (12,119) (58,107) Starting Fund Balance 442,263 442,263 Net Change (39,850) (12,119) Ending Fund Balance 402,413 430,144 Budget by Organization Report Through 07/31/16 Prior Fiscal Year Activity Included 2016 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 (39,850) Fund 335 - WEST EVANSTON TIF REVENUE TOTALS 150 EXPENSE TOTALS 40,000 Run by Ashley King on 08/27/2016 01:50:21 PM Page 67 of 122 July 2016 YTD Actual Actual 2015 Actual - - - - - 2,000,000 - - 2,000,000 - - - - - 2,000,000 - - - - - 2,000,000 - - 2,000,000 - - 2,000,000 - - - Starting Fund Balance - - Net Change 10,000 - Ending Fund Balance 10,000 - Budget by Organization Report Through 07/31/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 340 - DEMPSTER-DODGE TIF FUND REVENUE Property Taxes - Other Revenue 50,000 REVENUE TOTALS 50,000 50,000 EXPENSE Services and Supplies - Capital Outlay - Debt Service 40,000 EXPENSE TOTALS 40,000 Fund 340 - DEMPSTER-DODGE TIF 10,000 EXPENSE TOTALS 40,000 Fund 340 - DEMPSTER-DODGE TIF REVENUE TOTALS Run by Ashley King on 08/27/2016 01:50:21 PM Page 70 of 122 July 2016 YTD Actual Actual 2015 Actual - - - 580,000 580,000 900,000 580,000 580,000 900,000 1,408 1,408 - - 580,000 580,000 2,112 22,696 7,930 3,520 604,104 587,930 580,000 580,000 900,000 3,520 604,104 587,930 576,480 (24,104) 312,070 Starting Fund Balance 312,070 312,070 Net Change 31,500 (24,104) Ending Fund Balance 343,570 287,966 Budget by Organization Report Through 07/31/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 345 - CHICAGO-MAIN TIF REVENUE Property Taxes 75,000 Other Revenue - REVENUE TOTALS 75,000 75,000 EXPENSE Services and Supplies - Capital Outlay - Debt Service 43,500 EXPENSE TOTALS 43,500 Fund 345 - CHICAGO-MAIN TIF 31,500 EXPENSE TOTALS 43,500 Fund 345 - CHICAGO-MAIN TIF REVENUE TOTALS Run by Ashley King on 08/27/2016 01:50:21 PM Page 73 of 122 July 2016 YTD Actual Actual 2015 Actual 162,780 162,780 - - - - 162,780 162,780 - - - - - - - 162,780 162,780 - - - - 162,780 162,780 - Starting Fund Balance - - Net Change 10,500 162,780 Ending Fund Balance 10,500 162,780 Budget by Organization Report Through 07/31/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 350 - SPECIAL SERVICE AREA (SSA) #6 REVENUE Property Taxes 210,000 Interest Income 500 REVENUE TOTALS 210,500 EXPENSE Services and Supplies 200,000 EXPENSE TOTALS 200,000 Fund 350 - SPECIAL SERVICE AREA 10,500 Fund 350 - SPECIAL SERVICE AREA REVENUE TOTALS 210,500 EXPENSE TOTALS 200,000 Run by Ashley King on 08/27/2016 01:50:21 PM Page 76 of 122 July 2016 YTD Actual Actual 2015 Actual 40,816 66,219 87,391 - 3,155,500 - - 824,227 270,268 - 244,200 7,945,481 1,042 6,302 3,815 41,858 4,296,448 8,306,954 - - - 56,726 323,974 643,510 235,437 1,788,531 9,794,396 - - - - - 32,933 - - 490,000 292,162 2,112,505 10,960,839 41,858 4,296,448 8,306,954 292,162 2,112,505 10,960,839 (250,304) 2,183,944 (2,653,885) Starting Fund Balance 5,517,041 5,517,041 Net Change (2,209,000) 2,183,944 Ending Fund Balance 3,308,041 7,700,985 Budget by Organization Report Through 07/31/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 415 - CAPITAL IMPROVEMENTS FUND REVENUE Charges for Services - Interfund Transfers 6,471,000 Intergovernmental Revenue 4,841,615 Other Revenue 9,248,000 Interest Income - REVENUE TOTALS 20,560,615 EXPENSE Salary and Benefits - Services and Supplies 2,256,962 Capital Outlay 20,022,653 20,560,615 Debt Service - Miscellaneous - Interfund Transfers 490,000 EXPENSE TOTALS 22,769,615 Fund 415 - CAPITAL (2,209,000) EXPENSE TOTALS 22,769,615 Fund 415 - CAPITAL REVENUE TOTALS Run by Ashley King on 08/27/2016 01:50:21 PM Page 79 of 122 July 2016 YTD Actual Actual 2015 Actual - - - - - - - - - - - - - - - - - - - - - - - 243,113 - - - - - - - - - 856 12,711 24,832 6,928 96,748 125,218 - - - 7,784 109,459 393,163 - - - - 12 1,879 - - 226,538 - - - - - - - - 534 - 180,349 - - 180,361 228,951 7,784 109,459 393,163 - 180,361 228,951 7,784 (70,902) 164,213 Starting Fund Balance 2,682,781 2,682,781 Net Change 98,950 (70,902) Ending Fund Balance 2,781,731 2,611,879 Budget by Organization Report Through 07/31/16 Prior Fiscal Year Activity Included 2016 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 382,250 EXPENSE TOTALS 382,250 Fund 420 - SPECIAL ASSESSMENT REVENUE TOTALS 481,200 EXPENSE TOTALS 382,250 Fund 420 - SPECIAL ASSESSMENT 98,950 Run by Ashley King on 08/27/2016 01:50:21 PM Page 82 of 122 July 2016 YTD Actual Actual 2015 Actual - - - - - - - 3,000 150 - - - 653,306 4,019,714 6,010,558 - 1,855,884 2,925,296 - - - 12,467 105,065 153,545 3,310 14,964 18,260 669,083 5,998,627 9,107,809 162,970 808,900 1,121,645 628,094 1,824,498 2,859,622 108,204 442,571 128,726 - 159,824 319,649 - - - - - 2,846,227 988 2,973 6,951 - 199,979 503,423 20,569 61,203 23,687 - 651,892 923,092 920,824 4,151,841 8,733,020 669,083 5,998,627 9,107,809 920,824 4,151,841 8,733,020 (251,741) 1,846,786 374,789 Starting Fund Balance 10,777,874 10,777,874 Net Change (6,615,186) 1,846,786 Ending Fund Balance 4,162,688 12,624,660 Budget by Organization Report Through 07/31/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 505 - PARKING SYSTEM FUND REVENUE Property Taxes - Other Taxes - Licenses, Permits and Fees - Fines and Forfeitures - Charges for Services 6,444,675 Interfund Transfers 3,711,770 Intergovernmental Revenue 12,125 Other Revenue 119,216 Interest Income 35,070 REVENUE TOTALS 10,322,856 EXPENSE Salary and Benefits 1,485,289 Services and Supplies 3,301,275 Capital Outlay 3,474,000 Insurance and Other Chargebacks 319,648 Community Sponsored Organizations - Depreciation Expense 2,873,395 Contingencies 11,000 Debt Service 3,917,652 Miscellaneous 252,000 Interfund Transfers 1,303,783 EXPENSE TOTALS 16,938,042 Fund 505 - PARKING SYSTEM (6,615,186) Fund 505 - PARKING SYSTEM REVENUE TOTALS 10,322,856 EXPENSE TOTALS 16,938,042 Run by Ashley King on 08/27/2016 01:50:21 PM Page 85 of 122 July 2016 YTD Actual Actual 2015 Actual - - - 9,850 59,677 105,483 2,964,812 10,660,082 15,308,225 500,000 6,697,244 2,354,582 - - - 38,973 79,342 350,065 1,772 7,707 3,448 3,515,407 17,504,052 18,121,804 582,774 2,905,763 4,590,767 72,243 1,274,386 2,298,993 278,486 4,868,729 105 - 234,252 468,493 - - - - - 2,096,633 - 658 933 - 373,518 432,628 3,615 10,543 (286,678) 500,000 8,448,400 3,692,565 13,294,439 3,515,407 17,504,052 18,121,804 13,294,439 1,525,340 (631,473) 4,827,365 Starting Fund Balance 9,223,203 9,223,203 Net Change (3,407,255) (631,473) Ending Fund Balance 5,815,948 8,591,731 1,990,068 18,135,525 1,990,068 18,135,525 Budget by Organization Report Through 07/31/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 510 - WATER FUND REVENUE Other Taxes - Licenses, Permits and Fees 70,000 Charges for Services 15,298,000 Interfund Transfers - Intergovernmental Revenue - Other Revenue 22,348,400 Interest Income 1,600 REVENUE TOTALS 37,718,000 EXPENSE Salary and Benefits 5,105,126 Services and Supplies 6,155,950 Capital Outlay 24,776,106 Insurance and Other Chargebacks 468,492 Community Sponsored Organizations - Depreciation Expense - Contingencies 1,000 37,718,000 Debt Service 1,053,288 Miscellaneous 62,980 Interfund Transfers 3,502,313 EXPENSE TOTALS 41,125,255 Fund 510 - WATER FUND Totals (3,407,255) EXPENSE TOTALS 41,125,255 Fund 510 - WATER FUND Totals REVENUE TOTALS Run by Ashley King on 08/27/2016 01:50:21 PM Page 88 of 122 July 2016 YTD Actual Actual 2015 Actual 903,145 7,405,885 12,510,940 - - - 554,863 554,863 2,962 216 2,651 2,706 1,458,224 7,963,399 12,516,607 115,886 657,656 1,034,571 11,518 223,072 108,927 2,975 663,101 13,609 - 260,741 269,988 - - 3,443,723 - - - 345,238 4,612,030 1,550,407 - 5,000 3,306 - 261,190 735,235 475,616 6,682,789 7,159,766 1,458,224 7,963,399 12,516,607 475,616 6,682,789 7,159,766 982,609 1,280,610 5,356,842 Starting Fund Balance 4,012,808 4,012,808 Net Change (1,607,486) 1,280,610 Ending Fund Balance 2,405,322 5,293,418 Budget by Organization Report Through 07/31/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 515 - SEWER FUND REVENUE Charges for Services 12,888,650 Interfund Transfers - Other Revenue 984,165 Interest Income 1,000 REVENUE TOTALS 13,873,815 EXPENSE Salary and Benefits 1,168,910 Services and Supplies 995,800 Capital Outlay 3,048,314 Insurance and Other Chargebacks 269,988 Depreciation Expense - Contingencies - Debt Service 9,222,913 Miscellaneous 1,500 Interfund Transfers 773,876 EXPENSE TOTALS 15,481,301 Fund 515 - SEWER FUND Totals (1,607,486) Fund 515 - SEWER FUND Totals REVENUE TOTALS 13,873,815 EXPENSE TOTALS 15,481,301 Run by Ashley King on 08/27/2016 01:50:21 PM Page 91 of 122 July 2016 YTD Actual Actual 2015 Actual - 81,934 213,490 293,474 2,065,597 3,561,584 - 527,984 1,055,967 - - - 2,925 50,090 228,469 - - - 296,400 2,725,605 5,059,510 101,601 490,251 849,300 102,478 1,787,643 3,717,885 - 2,664 24,738 - - - - - - - - - - - - - 1,144 68,419 12,232 12,232 - - 249,747 490,106 216,311 2,543,681 5,150,448 296,400 2,725,605 5,059,510 216,311 2,543,681 5,150,448 80,089 181,924 (90,938) Starting Fund Balance (1,228,557) (1,228,557) Net Change 60,844 181,924 Ending Fund Balance (1,167,713) (1,046,633) Budget by Organization Report Through 07/31/16 Prior Fiscal Year Activity Included 2016 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 868,098 Services and Supplies 3,732,176 Capital Outlay 25,750 Insurance and Other Chargebacks - Community Sponsored Organizations - Depreciation Expense - Contingencies - Debt Service - Miscellaneous 15,000 Interfund Transfers 499,493 EXPENSE TOTALS 5,140,517 Fund 520 - SOLID WASTE FUND 60,844 Fund 520 - SOLID WASTE FUND REVENUE TOTALS 5,201,361 EXPENSE TOTALS 5,140,517 Run by Ashley King on 08/27/2016 01:50:21 PM Page 94 of 122 July 2016 YTD Actual Actual 2015 Actual - 1,693,874 3,289,009 - - - - - - 3,571 8,577 46,933 - - - 3,571 1,702,451 3,335,942 114,665 577,073 1,137,603 227,572 856,860 1,686,117 - - - - 13,381 25,820 - - 105 - - - - - - - - - - - - 342,238 1,447,314 2,849,644 3,571 1,702,451 3,335,942 342,238 1,447,314 2,849,644 (338,667) 255,137 486,298 Starting Fund Balance 365,460 365,460 Net Change (244,277) 255,137 Ending Fund Balance 121,183 620,597 Budget by Organization Report Through 07/31/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 600 - FLEET SERVICES FUND REVENUE Charges for Services 3,317,088 Interfund Transfers - Intergovernmental Revenue - Other Revenue 81,781 Interest Income 1,000 REVENUE TOTALS 3,399,869 EXPENSE Salary and Benefits 1,236,877 Services and Supplies 2,380,057 Capital Outlay - Insurance and Other Chargebacks 26,762 Depreciation Expense - Contingencies 450 3,399,869 Debt Service - Miscellaneous - Interfund Transfers - EXPENSE TOTALS 3,644,146 Fund 600 - FLEET SERVICES FUND (244,277) EXPENSE TOTALS 3,644,146 Fund 600 - FLEET SERVICES FUND REVENUE TOTALS Run by Ashley King on 08/27/2016 01:50:21 PM Page 97 of 122 July 2016 YTD Actual Actual 2015 Actual - 727,640 1,451,422 - - - - 31,437 34,286 - 759,077 1,485,708 5,215 11,106 53,400 496 7,195 - - - 1,684,835 - - - 5,712 18,301 1,738,234 - 759,077 1,485,708 5,712 18,301 1,738,234 (5,712) 740,776 (252,527) Starting Fund Balance 1,277,689 1,277,689 Net Change 146,216 740,776 Ending Fund Balance 1,423,905 2,018,465 Budget by Organization Report Through 07/31/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 601 - EQUIPMENT REPLACEMENT FUND REVENUE Charges for Services 1,451,421 Interfund Transfers - Other Revenue 210,217 REVENUE TOTALS 1,661,638 EXPENSE Services and Supplies 60,000 Capital Outlay 1,455,422 Depreciation Expense - Miscellaneous - EXPENSE TOTALS 1,515,422 Fund 601 - EQUIPMENT 146,216 Fund 601 - EQUIPMENT REVENUE TOTALS 1,661,638 EXPENSE TOTALS 1,515,422 Run by Ashley King on 08/27/2016 01:50:21 PM Page 100 of 122 July 2016 YTD Actual Actual 2015 Actual - 20,216 162,411 - 410 306,051 856,180 5,643,329 10,413,499 13,084 75,277 1,034,405 229,564 3,572,455 5,753,308 17 120 136 1,098,845 9,311,807 17,669,810 65,161 359,143 516,469 124,360 1,112,619 1,305,086 - - - 1,236,577 8,299,657 14,270,966 - - - - - - - - - - - - - 4,330 - - - - 1,426,097 9,775,749 16,092,521 1,098,845 9,311,807 17,669,810 1,426,097 9,775,749 16,092,521 (327,252) (463,942) 1,577,289 Starting Fund Balance (364,496) (364,496) Net Change 565,405 (463,942) Ending Fund Balance 200,909 (828,438) Budget by Organization Report Through 07/31/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 605 - INSURANCE FUND REVENUE Charges for Services 162,411 Interfund Transfers - Other Revenue 10,111,694 Workers Compensation and Liability 1,023,094 Insurance 6,459,839 Interest Income 1,000 REVENUE TOTALS 17,758,038 EXPENSE Salary and Benefits 479,323 Services and Supplies 1,385,248 Capital Outlay - Insurance and Other Chargebacks 15,328,062 Community Sponsored Organizations - Depreciation Expense - Contingencies - Debt Service - Miscellaneous - Interfund Transfers - EXPENSE TOTALS 17,192,633 Fund 605 - INSURANCE FUND 565,405 Fund 605 - INSURANCE FUND REVENUE TOTALS 17,758,038 EXPENSE TOTALS 17,192,633 Run by Ashley King on 08/27/2016 01:50:21 PM Page 103 of 122 July 2016 YTD Actual Actual 2015 Actual 1,500,348 4,896,001 - 216,409 267,404 280,000 - - - 113,362 553,521 6,273,004 - 45 1,206,228 1,830,120 5,716,971 7,759,232 703,518 4,896,456 8,302,220 - - - - - - - - - - - - 703,518 4,896,456 8,302,220 1,830,120 5,716,971 7,759,232 703,518 4,896,456 8,302,220 1,126,601 820,515 (542,988) Starting Fund Balance 66,741,084 66,741,084 Net Change 4,297,865 820,515 Ending Fund Balance 71,038,949 67,561,599 Budget by Organization Report Through 07/31/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 700 - FIRE PENSION FUND REVENUE Property Taxes 7,070,865 Other Taxes 280,000 Interfund Transfers - Other Revenue 1,010,000 Interest Income 4,100,000 REVENUE TOTALS 12,460,865 EXPENSE Salary and Benefits 8,163,000 Services and Supplies - Community Sponsored Organizations - Debt Service - Miscellaneous - EXPENSE TOTALS 8,163,000 Fund 700 - FIRE PENSION FUND 4,297,865 Fund 700 - FIRE PENSION FUND REVENUE TOTALS 12,460,865 EXPENSE TOTALS 8,163,000 Run by Ashley King on 08/27/2016 01:50:21 PM Page 106 of 122 July 2016 YTD Actual Actual 2015 Actual 1,581,071 6,271,601 57,836 216,409 267,404 325,000 - - - 170,882 840,528 7,676,438 2 1,196 2,902,399 1,968,363 7,380,729 10,961,673 906,507 6,360,040 10,768,296 - - - - - - - - - 906,507 6,360,040 10,768,296 1,968,363 7,380,729 10,961,673 906,507 6,360,040 10,768,296 1,061,856 1,020,689 193,377 Starting Fund Balance 98,558,837 98,558,837 Net Change 6,383,940 1,020,689 Ending Fund Balance 104,942,777 99,579,526 Budget by Organization Report Through 07/31/16 Prior Fiscal Year Activity Included 2016 Classification Budget Fund 705 - POLICE PENSION FUND REVENUE Property Taxes 9,055,940 Other Taxes 325,000 Interfund Transfers - Other Revenue 1,550,000 Interest Income 6,500,000 REVENUE TOTALS 17,430,940 EXPENSE Salary and Benefits 11,047,000 Services and Supplies - Debt Service - Miscellaneous - EXPENSE TOTALS 11,047,000 Fund 705 - POLICE PENSION FUND REVENUE TOTALS 17,430,940 EXPENSE TOTALS 11,047,000 Fund 705 - POLICE PENSION FUND 6,383,940 Run by Ashley King on 08/27/2016 01:50:21 PM Page 109 of 122 GENERAL FUND Jan Feb Mar Apr May Jun Jul 2015 Unreserved Fund Balance17,350,271 17,704,926 21,823,492 21,070,998 20,159,923 19,573,881 13,460,405 2016 Unreserved Fund Balance11,859,782 14,097,256 17,193,730 16,597,583 18,375,173 21,225,995 15,790,000 2015 Cash Balance 5,232,590 6,567,371 10,786,783 8,666,475 8,237,917 7,501,885 6,692,927 2016 Cash Balance 3,656,830 2,587,845 8,182,090 7,808,208 7,101,333 12,919,440 10,046,315 2015 v 2016 Cash and Fund Balance Comparison Chart - 5,000,000 10,000,000 15,000,000 20,000,000 25,000,000 Jan Feb Mar Apr May Jun 2015 v 2016 Fund and Cash Balance 2015 Unreserved Fund Balance 2016 Unreserved Fund Balance 2015 Cash Balance 2016 Cash Balance