Loading...
HomeMy WebLinkAbout2016.06 June Monthly Report To: Wally Bobkiewicz, City Manager Martin Lyons, Assistant City Manager/Chief Financial Officer From: Ashley King, Finance Division Manager Subject: June 2016 Monthly Financial Report Date: July 27, 2016 Please find attached the unaudited financial statements as of June 30, 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 57,359,180 49,240,284 8,118,897 21,225,995 12,919,440 682,398 383,765 298,634 1,038,242 814,719 250,000 (250,000)750,000 750,000 3,432,577 3,040,463 392,114 2,495,005 1,061,696 4,982 24,129 (19,148)103,076 189,624 975,682 1,201,033 (225,352)1,062,725 1,462,679 365,341 714,926 (349,585)253,092 27,418 214,595 161,500 53,095 197,353 (137,449) 62,603 468,344 (405,741)70,399 (345,858) 68,465 121,020 (52,555)2,399,114 159,335 1,073,505 981,963 91,542 2,772,819 2,312,836 169,915 169,915 43,516 59,931 (16,415)4,616,593 (11,645) 180,694 98,952 81,741 2,795,255 1,038,901 194,050 72,675 121,376 254,043 7,587 2,702,129 3,249,911 (547,782)6,424,765 5,973,566 287,860 17,250 270,610 860,037 796,039 743,946 1,062,822 (318,875)986,882 1,023,311 371,847 342,691 29,155 205,177 2,803 5,842 18,432 (12,590)430,900 437,995 - 600,584 (600,584)(288,514) (288,513) 6,947,732 15,491,452 (8,543,720)7,153,702 5,397,192 4,254,590 1,820,342 2,434,248 8,484,086 8,855,550 101,675 180,361 (78,686)2,603,720 2,600,558 5,329,425 3,231,017 2,098,408 12,610,466 12,422,472 7,791,402 10,481,628 (2,690,226)4,929,754 4,220,443 6,505,175 6,207,174 298,001 4,718,038 1,902,483 2,429,040 2,327,370 101,670 (933,098) (1,652,367) 442,397 222,930 219,467 293,403 254,872 1,698,880 1,105,077 593,804 867,262 285,185 759,077 12,589 746,488 2,645,917 1,629,106 8,212,962 8,349,652 (136,690)(4,091,308) 2,284,765 113,241,568 111,540,267 1,701,301 88,104,815 66,564,658 605 INSURANCE FUND TOTAL 600 FLEET SERVICES FUND 601 EQUIPMENT REPLACEMENT FUND 520 SOLID WASTE FUND 176 HEALTH AND HUMAN SERVICES 510 WATER FUND 515 SEWER FUND 420 SPECIAL ASSESSMENT FUND 505 PARKING SYSTEM FUND 320 DEBT SERVICE FUND 415 CAPITAL IMPROVEMENTS FUND 340 DEMPSTER-DODGE TIF FUND 345 CHICAGO-MAIN TIF 330 HOWARD-RIDGE TIF FUND 335 WEST EVANSTON TIF FUND 310 HOWARD-HARTREY TIF 315 SOUTHWEST TIF FUND 300 WASHINGTON NATIONAL TIF FUND 305 SPECIAL SERVICE AREA (SSA) #5 250 AFFORDABLE HOUSING FUND 186 LIBRARY DEBT SERVICE FUND 235 NEIGHBORHOOD IMPROV 240 HOME FUND 220 CDBG LOAN 225 ECONOMIC DEVELOPMENT FUND 210 SPECIAL SERVICE AREA (SSA) #4 215 CDBG FUND 200 MOTOR FUEL TAX FUND 205 EMERGENCY TELEPHONE (E911) 185 LIBRARY FUND 195 NSP2 175 GENERAL ASSISTANCE FUND 180 GOOD NEIGHBOR FUND Fund Fund Description 100 GENERAL FUND NOTE: Negative Cash Balances (as seen above in the CDBG, SSA 4, HOME, Chicago-Main & 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 unaudited fund balance + YTD Net without other balance sheet adjustments. Memorandum Included above are the ending balances as of June 30, 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 June 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 June 30, 2016, the General Fund is reporting a net surplus of $8,118,897. The attached supplemental charts show the General Fund Revenues at 51.15% of budget and expenses lower at 43.68%. The June target is 50%. Building permits received over $4 million in June (reflected in this report), which includes a $2.9 million permit from Northwestern. Parks and Recreation seasonal expenses will continue to show up in reports through September. Adding these, the City’s expenses will be closer to budgeted amounts. Through June 30, 2016, the SSA #4 Fund is showing a negative cash balance of $137,449 due to the timing of payments to the Downtown Evanston group. Through June 30, 2016, the CDBG Fund is showing a negative cash balance of $345,858 which will be reimbursed from June draw-downs. Through June 30, 2016, the Economic Development Fund is showing a fund balance of $2,772,819 and a cash balance of $2,312,836. 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 June 30, 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. The Debt Service Fund made a $13 million payment in January in connection with the refinancing of the 2006B bonds. This refinancing was not finalized when the budget was passed in November, thus showing expenses to be at 95% of budget for these bond payments. A budget amendment reflecting the new total bond payments will be presented to Council in August for consideration. An equivalent amount of revenues from bond proceeds will also be includ ed. The net impact of this refunding is a savings to the City over the life of the bonds. Through June 30, 2016, the Solid Waste Fund has a negative fund balance of $966,184 and a negative cash balance of $1,652,367. Through June 30, 2016, the Insurance Fund is showing a negative fund balance of $4,091,308 with a cash balance of $2,284,765. This negative balance is primarily for claims/cases being reserved/expensed and will be adjusted as a part of the 2015 audit Fund   100 - GENERAL FUND 2016 Budget June Actual YTD Actual % 2015 Actual 27,417,407 73,307 15,332,026 55.92% 25,915,970 45,986,550 3,341,819 20,956,916 45.57% 44,978,985 5,329,777 116,121 1,822,879 34.20% 5,324,137 9,276,550 4,713,127 7,905,645 85.22% 6,704,846 125,700 652 42,071 33.47% 155,619 4,609,825 296,129 1,586,594 34.42% 3,548,230 640,000 - - 0.00% 640,000 5,374,751 694,365 3,754,075 69.85% 5,406,379 2,433,216 122,898 1,311,099 53.88% 2,239,528 8,842,365 646,242 3,877,451 43.85% 7,836,484 765,727 66,177 325,092 42.46% 670,245 1,286,843 57,510 434,943 33.80% 894,703 50,000 4,608 10,389 20.78% 6,572 112,138,711 10,132,955 57,359,180 51.15% 104,321,698 CITY COUNCIL 424,958 30,491 205,800 48.43% 419,962 CITY CLERK 263,203 25,248 137,674 52.31% 283,764 CITY MANAGER'S OFFICE 6,989,746 517,535 2,817,743 40.31% 1,814,469 LAW 1,130,000 81,249 457,687 40.50% 1,051,325 ADMINISTRATIVE SERVICES 9,634,173 704,005 3,956,800 41.07% 24,887,860 COMMUNITY DEVELOPMENT 2,740,032 195,735 1,136,423 41.47% 2,425,618 POLICE 37,696,278 2,078,696 17,579,513 46.63% 28,493,534 FIRE MGMT & SUPPORT 22,601,742 1,198,494 10,629,399 47.03% 14,954,025 HEALTH 3,544,226 265,295 1,455,346 41.06% 3,212,848 PARKS, REC. AND COMMUNITY SERV. 11,820,590 888,715 4,429,497 37.47% 11,180,116 PUBLIC WORKS AGENCY 14,861,248 1,152,815 6,434,401 43.30% - 111,706,196 7,138,277 49,240,284 44.08% 88,723,520 112,138,711 10,125,196 57,359,180 104,321,698 111,706,196 7,130,518 49,240,284 106,872,275 432,515 2,994,678 8,118,897 (2,550,577)Fund   100 - GENERAL FUND Net Gain (Loss) Interest Income REVENUE TOTAL EXPENSE TOTAL Fund   100 - GENERAL FUND Totals REVENUE TOTALS EXPENSE TOTALS Parking Charges for Services Parks and Recreation Charges for Services Other Charges for Services Interfund Transfers Intergovernmental Revenue Other Revenue Property Taxes Other Taxes License Permit Fee Fines and Forfeitures Income Statement Through 06/30/16 Summary Listing Classification Fund   505 - PARKING SYSTEM FUND 2016 Budget June Actual YTD Actual % 2015 Actual - - 3,000 150 6,379,675 632,385 3,364,818 52.74% 6,010,558 65,000 1,500 1,500 2.31% - 3,711,770 309,314 1,855,884 50.00% 2,925,296 12,125 - - 0.00% - 119,216 13,392 92,570 77.65% 337,295 35,070 2,666 11,654 33.23% 18,260 10,322,856 959,258 5,329,425 51.63% 9,291,559 23,000 733 11,903 51.75% 29,187 1,348,940 102,016 586,805 43.50% 1,125,491 113,349 8,252 47,222 41.66% (33,034) 3,022,411 128,354 1,087,767 35.99% 2,616,554 278,864 18,286 108,636 38.96% 243,068 3,474,000 10,511 334,368 9.62% 128,726 319,648 26,637 159,824 50.00% 319,649 2,873,395 - - 0.00% 2,846,227 11,000 1,125 1,986 18.05% 6,951 3,917,652 199,979 199,979 5.10% 503,423 252,000 - 40,634 16.12% 23,687 1,303,783 108,649 651,892 50.00% 923,092 16,938,042 604,542 3,231,017 19.08% 8,733,020 10,322,856 959,258 5,329,425 9,291,559 16,938,042 604,542 3,231,017 8,733,020 (6,615,186) 354,716 2,098,408 558,538 EXPENSE TOTALS Fund   505 - PARKING SYSTEM FUND Net Miscellaneous Interfund Transfers EXPENSE TOTAL Fund   505 - PARKING SYSTEM FUND Totals REVENUE TOTALS Supplies Capital Outlay Insurance and Other Chargebacks Depreciation Expense Contingencies Debt Service Interest Income REVENUE TOTAL Employee Pay Benefits Pensions Services Permit Parking Charges for Services Parks and Recreation Charges for Services Interfund Transfers Intergovernmental Revenue Other Revenue Income Statement Through 06/30/16 Summary Listing Classification Fund   510 - WATER FUND 2016 Budget June Actual YTD Actual % 2015 Actual 70,000 9,233 49,827 28.82% 105,483 15,133,000 1,346,733 7,674,413 49.29% 15,141,770 39,000 4,327 20,577 47.24% 40,911 126,000 350 280 99.78% 125,545 - - - 2,354,582 22,348,400 16,296 40,369 99.82% 350,065 1,600 1,305 5,936 -254.81% 3,448 37,718,000 1,378,244 7,791,402 20.66% 18,121,804 210,465 18,810 73,913 64.88% 157,679 4,534,306 360,664 2,074,884 54.24% 4,547,958 360,355 31,081 174,193 51.66% (114,870) 2,098,760 192,360 621,149 70.40% 1,250,874 1,392,190 134,571 580,994 69.85% 1,048,119 27,441,106 546,710 4,590,243 -0.09% 105 468,492 39,042 234,252 50.00% 468,493 - - - 2,096,633 1,000 658 658 34.20% 933 1,053,288 308,676 373,518 64.54% 432,628 62,980 - 6,928 89.00% (286,678) 3,502,313 291,859 1,750,897 3,692,565 41,125,255 1,924,431 10,481,628 25.49% 13,294,439 37,718,000 1,378,244 7,791,402 20.66% 18,121,804 13,759,949 1,924,431 10,481,628 87.42% 13,294,439 23,958,051 (546,188) (2,690,226)-17.69% 4,827,365 REVENUE TOTALS EXPENSE TOTALS Fund   510 - WATER FUND Net Gain Debt Service Miscellaneous Interfund Transfers EXPENSE TOTAL Fund   510 - WATER FUND Totals Services Supplies Capital Outlay Insurance and Other Chargebacks Depreciation Expense Contingencies Other Revenue Interest Income REVENUE TOTAL Employee Pay Benefits Pensions Fee Water Charges for Services Sewer Charges for Services Other Charges for Services Interfund Transfers Income Statement Through 06/30/16 Summary Listing Classification Fund   515 - SEWER FUND 2016 Budget June Actual YTD Actual % 2015 Actual 12,869,000 1,346,721 6,502,740 50.53% 12,491,290 19,650 - - 0.00% 19,650 984,165 - - 0.00% 2,962 1,000 202 2,435 243.50% 2,706 13,873,815 1,346,923 6,505,175 46.89% 12,516,607 57,040 1,925 16,204 28.41% 60,837 1,025,778 89,584 485,755 47.35% 1,000,833 86,092 5,979 39,812 46.24% (27,099) 903,500 56,953 196,552 21.75% 90,109 92,300 2,738 15,002 16.25% 18,817 3,048,314 - 660,126 21.66% 13,609 269,988 43,457 260,741 96.57% 269,988 - - - 3,443,723 9,222,913 565,178 4,266,793 46.26% 1,550,407 1,500 - 5,000 333.33% 3,306 773,876 43,532 261,190 33.75% 735,235 15,481,301 809,346 6,207,174 40.09% 7,159,766 13,873,815 1,346,923 6,505,175 12,516,607 15,481,301 809,346 6,207,174 7,159,766 (1,607,486) 537,577 298,001 5,356,842 Fund   515 - SEWER FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund   515 - SEWER FUND Net Gain Depreciation Expense Debt Service Miscellaneous Interfund Transfers EXPENSE TOTAL Benefits Pensions Services Supplies Capital Outlay Insurance and Other Chargebacks Sewer Charges for Services Other Charges for Services Other Revenue Interest Income REVENUE TOTAL Employee Pay Income Statement Through 06/30/16 Summary Listing Classification Fund   520 - SOLID WASTE FUND 2016 Budget June Actual YTD Actual % 2015 Actual 275,000 41,903 81,934 29.79% 213,490 3,632,394 306,005 1,772,122 48.79% 3,561,584 1,055,967 87,997 527,984 50.00% 1,055,967 238,000 8,966 47,000 19.75% 228,469 5,201,361 444,871 2,429,040 46.70% 5,059,510 25,000 2,160 21,161 84.64% 41,358 779,380 61,955 339,423 43.55% 823,923 63,718 4,995 28,067 44.05% (15,981) 3,679,126 292,740 1,663,074 45.20% 3,644,097 53,050 7,036 22,091 41.64% 73,788 25,750 130 2,664 10.35% 24,738 - 1,144 1,144 68,394 15,000 - - 0.00% - 499,493 41,624 249,747 50.00% 490,106 5,140,517 411,784 2,327,370 45.28% 5,150,423 5,201,361 444,871 2,429,040 5,059,510 5,140,517 411,784 2,327,370 5,150,423 60,844 33,086 101,670 (90,913) EXPENSE TOTALS Fund   520 - SOLID WASTE FUND Net Gain Miscellaneous Interfund Transfers EXPENSE TOTAL Fund   520 - SOLID WASTE FUND Totals REVENUE TOTALS Benefits Pensions Services Supplies Capital Outlay Debt Service License Other Charges for Services Interfund Transfers Other Revenue REVENUE TOTAL Employee Pay Income Statement Through 06/30/16 Summary Listing Classification June 2016 YTD 2016 2015 Transactions Transactions Total 73,307 15,332,026 25,915,970 3,341,819 20,956,916 44,978,985 4,829,900 9,770,595 12,184,602 296,129 1,586,594 3,548,230 817,263 5,065,174 8,285,907 646,242 3,877,451 7,836,484 66,177 325,092 670,245 57,510 434,943 894,703 - - - - - - - - - 4,608 10,389 6,572 - - - - - - 10,132,955 57,359,180 104,321,698 5,273,145 31,360,741 68,732,666 891,661 4,003,687 11,506,401 7,126 67,124 155,975 253,221 1,511,122 3,020,991 73,812 433,072 952,678 - - - - 89 30,529 - - - 126,706 744,444 17,171,181 512,606 11,115,265 5,301,854 7,138,277 49,235,544 106,872,275 10,125,196 57,359,180 104,321,698 7,138,277 49,235,544 106,872,275 2,986,919 8,123,637 (2,550,577) Starting Fund Balance 13,102,358 13,102,358 Net Change (567,485) 8,123,637 Ending Fund Balance 12,534,873 21,225,995 Budget by Organization Report Through 06/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 100 - GENERAL FUND Fines and Forfeitures Charges for Services Interfund Transfers REVENUE Property Taxes 27,417,407 Other Taxes 45,986,550 Licenses, Permits and Fees 14,732,027 Insurance Library Revenue Interest Income Intergovernmental Revenue Other Revenue Workers Compensation and Liability 11,834,924 Capital Outlay 200,600 Special Assessment Reappropriation of Surplus REVENUE TOTALS Contingencies Debt Service Miscellaneous Insurance and Other Chargebacks Community Sponsored Organizations Depreciation Expense REVENUE TOTALS EXPENSE TOTALS Fund 100 - GENERAL FUND Totals Interfund Transfers EXPENSE TOTALS Fund 100 - GENERAL FUND Totals (567,485) 112,706,196 112,138,711 112,706,196 6,534,528 1,679,285 - 213,505 - 925,029 20,282,973 112,138,711 - - 50,000 - EXPENSE Salary and Benefits 71,035,352 Services and Supplies 4,609,825 - - 1,286,843 765,727 8,842,365 8,447,967 Run by Ashley King on 07/26/2016 11:18:49 AM Page 1 of 52 June 2016 YTD 2016 2015 Transactions Transactions Total (58,134) 647,503 1,313,420 - - - - - - - - - - - - - - - - - 3,208 - 34,685 19,534 - - - - - - - - - 30 211 62 - - - - - - (58,103) 682,398 1,336,224 25,017 123,778 185,431 48,075 259,749 591,542 - - - - - - - - - - - - - - - - - - - 238 4,625 - - - 73,092 383,765 781,598 (58,103) 682,398 1,336,224 73,092 383,765 781,598 (131,195) 298,634 554,625 Starting Fund Balance 739,609 739,609 Net Change 38,167 298,634 Ending Fund Balance 777,776 1,038,242 Budget by Organization Report Through 06/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 175 - GENERAL ASSISTANCE FUND Fines and Forfeitures Charges for Services Interfund Transfers REVENUE Property Taxes 1,000,000 Other Taxes - Licenses, Permits and Fees - Insurance Library Revenue Interest Income Intergovernmental Revenue Other Revenue Workers Compensation and Liability 758,900 Capital Outlay - Special Assessment Reappropriation of Surplus REVENUE TOTALS Contingencies Debt Service Miscellaneous Insurance and Other Chargebacks Community Sponsored Organizations Depreciation Expense REVENUE TOTALS EXPENSE TOTALS Fund 175 - GENERAL ASSISTANCE Interfund Transfers EXPENSE TOTALS Fund 175 - GENERAL ASSISTANCE 38,167 987,833 1,026,000 987,833 - 7,000 - - - - - 1,026,000 - - 1,000 - EXPENSE Salary and Benefits 221,933 Services and Supplies - - - 25,000 - - - Run by Ashley King on 07/26/2016 11:18:49 AM Page 2 of 52 June 2016 YTD 2016 2015 Transactions Transactions Total - - - 73,733 442,397 884,794 - - - - - - 73,733 442,397 884,794 - - - - - - 6,444 222,930 849,388 - - - 6,444 222,930 849,388 73,733 442,397 884,794 6,444 222,930 849,388 67,288 219,467 35,406 Starting Fund Balance 48,295 73,936 Net Change 25,641 219,467 Ending Fund Balance 73,936 293,403 Budget by Organization Report Through 06/30/16 Prior Fiscal Year Activity Included Detail Listing 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 - Fund 176 - HEALTH AND HUMAN 25,641 884,794 EXPENSE TOTALS Fund 176 - HEALTH AND HUMAN REVENUE TOTALS 859,153 - 859,153 - EXPENSE TOTALS 859,153 Capital Outlay Community Sponsored Organizations Miscellaneous Run by Ashley King on 07/26/2016 11:18:49 AM Page 3 of 52 June 2016 YTD 2016 2015 Transactions Transactions Total - - - - - - 41,667 250,000 - 41,667 250,000 - - - - 41,667 250,000 - (41,667) (250,000) - Starting Fund Balance 1,000,000 1,000,000 Net Change - (250,000) Ending Fund Balance 1,000,000 750,000 Budget by Organization Report Through 06/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 180 - GOOD NEIGHBOR FUND REVENUE Other Revenue 1,000,000 REVENUE TOTALS 1,000,000 EXPENSE REVENUE TOTALS EXPENSE TOTALS Fund 180 - GOOD NEIGHBOR Interfund Transfers EXPENSE TOTALS Fund 180 - GOOD NEIGHBOR 1,000,000 - 1,000,000 1,000,000 1,000,000 Run by Ashley King on 07/26/2016 11:18:49 AM Page 4 of 52 June 2016 YTD 2016 2015 Transactions Transactions Total 5,646 3,278,519 5,916,852 - - 46,059 (242) 65,442 129,808 - - 171,000 - - 181,283 (117) 15,612 286 (130) 70,168 315,924 1,274 2,835 2,683 6,431 3,432,577 6,763,897 346,926 2,124,091 4,872,876 153,247 708,636 1,425,484 - 37,599 299,628 6,674 40,045 77,268 - - - - - - - - - 20,833 125,000 250,000 849 5,091 4,200 528,529 3,040,463 6,929,456 6,431 3,432,577 6,763,897 528,529 3,040,463 6,929,456 (522,098) 392,114 (165,560) Starting Fund Balance 2,102,891 2,102,891 Net Change 20,015 392,114 Ending Fund Balance 2,122,906 2,495,005 Budget by Organization Report Through 06/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 185 - LIBRARY FUND REVENUE Property Taxes 6,104,180 Other Taxes 50,200 Fines and Forfeitures 160,000 Library Revenue Interest Income REVENUE TOTALS Interfund Transfers Intergovernmental Revenue Other Revenue Insurance and Other Chargebacks Depreciation Expense Contingencies EXPENSE Salary and Benefits 4,751,497 Services and Supplies 1,872,573 Capital Outlay 32,800 EXPENSE TOTALS Fund 185 - LIBRARY FUND Totals REVENUE TOTALS Debt Service Miscellaneous Interfund Transfers EXPENSE TOTALS 6,997,142 Fund 185 - LIBRARY FUND Totals 20,015 7,017,157 6,997,142 10,183 250,000 - - 94,177 185,800 - 80,089 7,017,157 2,000 333,300 87,500 Run by Ashley King on 07/26/2016 11:18:49 AM Page 5 of 52 June 2016 YTD 2016 2015 Transactions Transactions Total - 194,050 601,811 - - - - 194,050 601,811 - - - - 41,447 - 31,228 31,228 562,740 - - - 31,228 72,675 562,740 - 194,050 601,811 31,228 72,675 562,740 (31,228) 121,376 39,072 Starting Fund Balance 132,667 132,667 Net Change - 121,376 Ending Fund Balance 132,667 254,043 Budget by Organization Report Through 06/30/16 Prior Fiscal Year Activity Included Detail Listing 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 REVENUE TOTALS EXPENSE TOTALS Fund 186 - LIBRARY DEBT Miscellaneous EXPENSE TOTALS Fund 186 - LIBRARY DEBT - - 393,409 393,409 393,409 Run by Ashley King on 07/26/2016 11:18:49 AM Page 6 of 52 June 2016 YTD 2016 2015 Transactions Transactions Total - - - - 4,863 130,126 - - - 18 119 - 18 4,982 130,126 2,032 12,329 59,467 - 3,060 4,611 - 4,863 68,352 362 2,172 5,730 - - - 5 1,705 179 - - (8,213) 2,399 24,129 130,126 18 4,982 130,126 2,399 24,129 130,126 (2,382) (19,148) - Starting Fund Balance 122,224 122,224 Net Change (303) (19,148) Ending Fund Balance 121,921 103,076 Budget by Organization Report Through 06/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 195 - NEIGHBORHOOD STABILIZATION FUND REVENUE Licenses, Permits and Fees - Intergovernmental Revenue 198,651 Other Revenue - Services and Supplies Capital Outlay Insurance and Other Chargebacks Interest Income - REVENUE TOTALS 198,651 EXPENSE Salary and Benefits 33,648 EXPENSE TOTALS Fund 195 - NEIGHBORHOOD REVENUE TOTALS Debt Service Miscellaneous Interfund Transfers EXPENSE TOTALS 198,954 Fund 195 - NEIGHBORHOOD (303) 198,651 35,000 5,100 198,954 - 120,862 - 4,344 Run by Ashley King on 07/26/2016 11:18:49 AM Page 7 of 52 June 2016 YTD 2016 2015 Transactions Transactions Total 168,355 972,726 2,465,781 - - - 684 2,956 819 - - - 169,038 975,682 2,466,600 - - - - 106,533 1,583,238 - - - - - - - - - 182,417 1,094,500 833,000 182,417 1,201,033 2,416,238 169,038 975,682 2,466,600 182,417 1,201,033 2,416,238 (13,378) (225,352) 50,362 Starting Fund Balance 1,288,077 1,288,077 Net Change (478,000) (225,352) Ending Fund Balance 810,077 1,062,725 Budget by Organization Report Through 06/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 200 - MOTOR FUEL TAX FUND REVENUE Intergovernmental Revenue 1,710,000 Other Revenue - Interest Income 1,000 Capital Outlay Contingencies Debt Service Reappropriation of Surplus - REVENUE TOTALS 1,711,000 EXPENSE Services and Supplies - REVENUE TOTALS 1,711,000 EXPENSE TOTALS 2,189,000 Miscellaneous Interfund Transfers EXPENSE TOTALS - - Fund 200 - MOTOR FUEL TAX (478,000) 2,189,000 2,189,000 - - Fund 200 - MOTOR FUEL TAX Run by Ashley King on 07/26/2016 11:18:49 AM Page 8 of 52 June 2016 YTD 2016 2015 Transactions Transactions Total 147,510 364,207 977,071 - - - - - 100 248 1,135 189 147,758 365,341 977,361 44,988 268,337 584,120 39,963 207,336 347,694 6,400 159,427 239,421 2,494 14,963 29,486 - - - - - 2,046 - - - - - 1,500 10,811 64,865 129,729 104,655 714,926 1,333,996 147,758 365,341 977,361 104,655 714,926 1,333,996 43,103 (349,585) (356,635) Starting Fund Balance 602,677 602,677 Net Change (497,643) (349,585) Ending Fund Balance 105,034 253,092 Budget by Organization Report Through 06/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 205 - EMERGENCY TELEPHONE (E911) FUND REVENUE Other Taxes 1,018,000 Intergovernmental Revenue - Other Revenue - Services and Supplies Capital Outlay Insurance and Other Chargebacks Interest Income 1,000 REVENUE TOTALS 1,019,000 EXPENSE Salary and Benefits 580,773 EXPENSE TOTALS 1,516,643 Miscellaneous Interfund Transfers EXPENSE TOTALS Community Sponsored Organizations Contingencies Debt Service - Fund 205 - EMERGENCY REVENUE TOTALS 1,019,000 5,000 - 29,926 393,615 377,600 Fund 205 - EMERGENCY (497,643) 1,516,643 129,729 - Run by Ashley King on 07/26/2016 11:18:49 AM Page 9 of 52 June 2016 YTD 2016 2015 Transactions Transactions Total 305 214,594 322,055 - 1 3 305 214,595 322,058 80,750 161,500 323,000 - - - - - - 80,750 161,500 323,000 305 214,595 322,058 80,750 161,500 323,000 (80,445) 53,095 (942) Starting Fund Balance 144,258 144,258 Net Change - 53,095 Ending Fund Balance 144,258 197,353 Budget by Organization Report Through 06/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 210 - SPECIAL SERVICE AREA (SSA) #4 REVENUE Property Taxes 320,000 Interest Income - REVENUE TOTALS 320,000 REVENUE TOTALS EXPENSE Services and Supplies 320,000 Debt Service - Miscellaneous - 320,000 EXPENSE TOTALS 320,000 Fund 210 - SPECIAL SERVICE - 320,000 EXPENSE TOTALS Fund 210 - SPECIAL SERVICE Run by Ashley King on 07/26/2016 11:18:49 AM Page 10 of 52 June 2016 YTD 2016 2015 Transactions Transactions Total - - - - - - - 52,406 1,502,924 - 10,197 3,318 - - - - 62,603 1,506,242 37,490 222,120 362,786 6 2,445 17,538 176,526 183,255 276,834 - 2,273 20,767 - - 235,459 - - - - - - 6,871 58,074 72,442 (69,583) 177 449,083 151,309 468,344 1,434,909 - 62,603 1,506,242 151,309 468,344 1,434,909 (151,309) (405,741) 71,333 Starting Fund Balance 476,140 476,140 Net Change 375 (405,741) Ending Fund Balance 476,515 70,399 Budget by Organization Report Through 06/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 215 - CDBG FUND Other Revenue Interest Income REVENUE TOTALS REVENUE Charges for Services - Interfund Transfers - Intergovernmental Revenue 2,595,000 EXPENSE Salary and Benefits 452,432 Services and Supplies 3,800 Capital Outlay - Debt Service Miscellaneous Interfund Transfers Insurance and Other Chargebacks Community Sponsored Organizations Contingencies - EXPENSE TOTALS 2,594,625 Fund 215 - CDBG FUND Totals 375 2,595,000 EXPENSE TOTALS Fund 215 - CDBG FUND Totals REVENUE TOTALS - 26,989 2,595,000 - - 2,594,625 837,124 1,274,280 - Run by Ashley King on 07/26/2016 11:18:49 AM Page 11 of 52 June 2016 YTD 2016 2015 Transactions Transactions Total - - - 24,045 63,944 14,951 14 4,521 375 24,059 68,465 15,326 - - - 10,164 63,140 280,461 - 57,880 1,919 - - - 10,164 121,020 282,380 24,059 68,465 15,326 10,164 121,020 282,380 13,895 (52,555) (267,054) Starting Fund Balance 2,451,669 2,451,669 Net Change - (52,555) Ending Fund Balance 2,451,669 2,399,114 Budget by Organization Report Through 06/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 220 - CDBG LOAN Services and Supplies 340,000 REVENUE Intergovernmental Revenue - Other Revenue 350,000 Interest Income - EXPENSE TOTALS 350,000 Miscellaneous Interfund Transfers EXPENSE TOTALS REVENUE TOTALS 350,000 EXPENSE Salary and Benefits - Fund 220 - CDBG LOAN Totals - 350,000 - 10,000 Fund 220 - CDBG LOAN Totals REVENUE TOTALS 350,000 Run by Ashley King on 07/26/2016 11:18:49 AM Page 12 of 52 June 2016 YTD 2016 2015 Transactions Transactions Total 40,748 828,496 2,116,843 - - - - - - 833 237,061 49,000 151 7,948 128 41,731 1,073,505 2,165,971 48,539 268,183 600,779 30,611 126,645 302,867 9,726 50,059 194,941 2,440 14,642 32,230 - - - - - - - - - - 97,436 1,293,041 70,833 424,998 600,000 162,149 981,963 3,023,858 41,731 1,073,505 2,165,971 162,149 981,963 3,023,858 (120,418) 91,542 (857,887) Starting Fund Balance 2,681,277 2,681,277 Net Change (286,099) 91,542 Ending Fund Balance 2,395,178 2,772,819 Budget by Organization Report Through 06/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 225 - ECONOMIC DEVELOPMENT FUND Other Revenue Interest Income REVENUE TOTALS REVENUE Other Taxes 2,165,000 Interfund Transfers 47,500 Intergovernmental Revenue - EXPENSE Salary and Benefits 734,229 Services and Supplies 912,200 Capital Outlay 253,500 Debt Service Miscellaneous Interfund Transfers Insurance and Other Chargebacks Community Sponsored Organizations Contingencies - EXPENSE TOTALS 2,548,699 Fund 225 - ECONOMIC (286,099) 2,262,600 EXPENSE TOTALS Fund 225 - ECONOMIC REVENUE TOTALS - 32,770 2,262,600 100 50,000 2,548,699 600,000 16,000 - Run by Ashley King on 07/26/2016 11:18:49 AM Page 13 of 52 June 2016 YTD 2016 2015 Transactions Transactions Total - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Starting Fund Balance 169,915 169,915 Net Change (80,000) - Ending Fund Balance 89,915 169,915 Budget by Organization Report Through 06/30/16 Prior Fiscal Year Activity Included Detail Listing 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 - Fund 235 - NEIGHBORHOOD (80,000) 20,000 EXPENSE TOTALS Fund 235 - NEIGHBORHOOD REVENUE TOTALS 100,000 - 100,000 - EXPENSE TOTALS 100,000 Debt Service Miscellaneous Interfund Transfers Run by Ashley King on 07/26/2016 11:18:49 AM Page 14 of 52 June 2016 YTD 2016 2015 Transactions Transactions Total 10,153 29,941 465,961 2,282 13,567 6,402 1 8 19 12,437 43,516 472,382 3,310 12,491 12,388 15,139 47,030 282,753 - - - 68 410 1,368 - - - - - - - - 45,747 - - 26,990 18,517 59,931 369,246 12,437 43,516 472,382 18,517 59,931 369,246 (6,081) (16,415) 103,136 Starting Fund Balance 4,633,008 4,633,008 Net Change - (16,415) Ending Fund Balance 4,633,008 4,616,593 Budget by Organization Report Through 06/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 240 - HOME FUND REVENUE Intergovernmental Revenue 393,868 Other Revenue 8,300 Interest Income - Capital Outlay Insurance and Other Chargebacks Community Sponsored Organizations REVENUE TOTALS 402,168 EXPENSE Salary and Benefits 48,348 Services and Supplies 352,500 EXPENSE TOTALS Fund 240 - HOME FUND Totals REVENUE TOTALS Debt Service Miscellaneous Interfund Transfers EXPENSE TOTALS 402,168 Fund 240 - HOME FUND Totals - 402,168 820 - 402,168 - 500 - - Run by Ashley King on 07/26/2016 11:18:49 AM Page 15 of 52 June 2016 YTD 2016 2015 Transactions Transactions Total - 36,667 100,000 - - - - - - 417 143,388 125,150 140 639 111 556 180,694 225,261 3,310 12,491 - - - 98 - - - - - - - - - 77,367 86,462 142,171 - - - 80,678 98,952 142,270 556 180,694 225,261 80,678 98,952 142,270 (80,121) 81,741 82,992 Starting Fund Balance 2,713,514 2,713,514 Net Change (313,719) 81,741 Ending Fund Balance 2,399,795 2,795,255 Budget by Organization Report Through 06/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 250 - AFFORDABLE HOUSING FUND Other Revenue Interest Income REVENUE TOTALS REVENUE Other Taxes 30,000 Interfund Transfers - Intergovernmental Revenue - Community Sponsored Organizations Debt Service Miscellaneous EXPENSE Salary and Benefits 48,347 Services and Supplies 350,000 Capital Outlay - REVENUE TOTALS EXPENSE TOTALS Fund 250 - AFFORDABLE Interfund Transfers EXPENSE TOTALS Fund 250 - AFFORDABLE (313,719) 474,347 160,628 474,347 130,400 - 76,000 - - 160,628 228 Run by Ashley King on 07/26/2016 11:18:49 AM Page 16 of 52 June 2016 YTD 2016 2015 Transactions Transactions Total 1,464 2,697,220 4,921,484 - - - - - - - - - 1,202 4,909 3,530 2,666 2,702,129 4,925,014 - - - 66 216 1,408 - 4,473 198,823 - - 574,976 24,669 49,338 110,310 532,647 3,195,884 3,265,296 557,382 3,249,911 4,150,811 2,666 2,702,129 4,925,014 557,382 3,249,911 4,150,811 (554,716) (547,782) 774,203 Starting Fund Balance 6,972,547 6,972,547 Net Change (2,640,683) (547,782) Ending Fund Balance 4,331,864 6,424,765 Budget by Organization Report Through 06/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 300 - WASHINGTON NATIONAL TIF FUND REVENUE Property Taxes 5,145,000 Other Taxes - Interfund Transfers - - Services and Supplies 1,000,000 Capital Outlay - Other Revenue Interest Income REVENUE TOTALS EXPENSE TOTALS Fund 300 - WASHINGTON REVENUE TOTALS Debt Service Miscellaneous Interfund Transfers EXPENSE TOTALS 7,787,683 Fund 300 - WASHINGTON (2,640,683) 5,147,000 2,000 - 7,787,683 6,287,683 500,000 - 5,147,000 EXPENSE Salary and Benefits Run by Ashley King on 07/26/2016 11:18:49 AM Page 17 of 52 June 2016 YTD 2016 2015 Transactions Transactions Total 31 287,825 422,527 - - - - - - 33 35 4 65 287,860 422,531 - - - 17,250 17,250 297,150 - - - 17,250 17,250 297,150 65 287,860 422,531 17,250 17,250 297,150 (17,185) 270,610 125,381 Starting Fund Balance 589,427 589,427 Net Change (467,971) 270,610 Ending Fund Balance 121,456 860,037 Budget by Organization Report Through 06/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 305 - SPECIAL SERVICE AREA (SSA) #5 Services and Supplies 51,399 REVENUE Property Taxes - Interfund Transfers - Other Revenue - EXPENSE TOTALS 468,271 Debt Service Miscellaneous EXPENSE TOTALS Interest Income 300 REVENUE TOTALS 300 EXPENSE Fund 305 - SPECIAL SERVICE (467,971) 468,271 - 416,872 Fund 305 - SPECIAL SERVICE REVENUE TOTALS 300 Run by Ashley King on 07/26/2016 11:18:49 AM Page 18 of 52 June 2016 YTD 2016 2015 Transactions Transactions Total 679 742,988 1,248,231 179 959 1,985 858 743,946 1,250,216 66 216 1,158 - 57,190 11,402 - - - - - - - 129,192 2,162,381 146,038 876,225 148,010 146,103 1,062,822 2,322,950 858 743,946 1,250,216 146,103 1,062,822 2,322,950 (145,245) (318,875) (1,072,734) Starting Fund Balance 1,305,757 1,305,757 Net Change (650,450) (318,875) Ending Fund Balance 655,307 986,882 Budget by Organization Report Through 06/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 310 - HOWARD-HARTREY TIF REVENUE Property Taxes 1,300,000 Interest Income 2,000 REVENUE TOTALS 1,302,000 EXPENSE Services and Supplies - Capital Outlay - Community Sponsored Organizations - Fund 310 - HOWARD-HARTREY (650,450) 1,302,000 EXPENSE TOTALS Fund 310 - HOWARD-HARTREY REVENUE TOTALS 1,952,450 1,752,450 200,000 - EXPENSE TOTALS 1,952,450 Debt Service Miscellaneous Interfund Transfers Run by Ashley King on 07/26/2016 11:18:49 AM Page 19 of 52 June 2016 YTD 2016 2015 Transactions Transactions Total - - - - - - - - - - - - - - - - - - - - 893,387 - - - - - 893,387 - - - - - 893,387 - - (893,387) Starting Fund Balance - - Net Change - - Ending Fund Balance - - Budget by Organization Report Through 06/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 315 - SOUTHWEST TIF FUND Debt Service - REVENUE Property Taxes - Interest Income - REVENUE TOTALS - EXPENSE TOTALS - Miscellaneous Interfund Transfers EXPENSE TOTALS EXPENSE Services and Supplies - Capital Outlay - Fund 315 - SOUTHWEST TIF FUND - - - - Fund 315 - SOUTHWEST TIF FUND REVENUE TOTALS - Run by Ashley King on 07/26/2016 11:18:49 AM Page 20 of 52 June 2016 YTD 2016 2015 Transactions Transactions Total 9,243 5,540,058 11,156,231 232,861 1,397,696 1,642,654 - - 12,278,473 4,101 9,978 7,668 246,205 6,947,732 25,085,026 750 2,000 171,576 2,001,789 15,489,452 13,028,022 - - 3,062 - - - 2,002,539 15,491,452 13,202,661 246,205 6,947,732 25,085,026 2,002,539 15,491,452 13,202,661 (1,756,334) (8,543,720) 11,882,365 Starting Fund Balance 15,697,422 15,697,422 Net Change (2,751,668) (8,543,720) Ending Fund Balance 12,945,754 7,153,702 Budget by Organization Report Through 06/30/16 Prior Fiscal Year Activity Included Detail Listing 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 Fund 320 - DEBT SERVICE FUND (2,751,668) 13,527,784 EXPENSE TOTALS Fund 320 - DEBT SERVICE FUND REVENUE TOTALS 16,279,452 - - 15,963,682 EXPENSE TOTALS 16,279,452 Debt Service Miscellaneous Interfund Transfers Run by Ashley King on 07/26/2016 11:18:49 AM Page 21 of 52 June 2016 YTD 2016 2015 Transactions Transactions Total 5,184 301,679 540,576 21,602 69,970 64,176 37 198 1,815 26,823 371,847 606,568 305,463 312,346 587,839 - - (6,275) - - - 60 345 585 - - 350 5,000 30,000 107,500 310,523 342,691 689,999 26,823 371,847 606,568 310,523 342,691 689,999 (283,700) 29,155 (83,431) Starting Fund Balance 176,022 176,022 Net Change 24,000 29,155 Ending Fund Balance 200,022 205,177 Budget by Organization Report Through 06/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 330 - HOWARD-RIDGE TIF FUND REVENUE Property Taxes 550,000 Other Revenue 1,120,000 Interest Income 100 Community Sponsored Organizations Debt Service Miscellaneous REVENUE TOTALS 1,670,100 EXPENSE Services and Supplies 538,000 Capital Outlay 1,000,000 REVENUE TOTALS EXPENSE TOTALS Fund 330 - HOWARD-RIDGE TIF Interfund Transfers EXPENSE TOTALS Fund 330 - HOWARD-RIDGE TIF 107,500 - 600 - 24,000 1,646,100 1,670,100 1,646,100 Run by Ashley King on 07/26/2016 11:18:49 AM Page 23 of 52 June 2016 YTD 2016 2015 Transactions Transactions Total - - - 1,028 5,141 - 136 701 257 1,164 5,842 257 66 216 1,158 - (1,028) (11,205) - - - 743 4,245 7,185 - - 1,227 2,500 15,000 60,000 3,309 18,432 58,365 1,164 5,842 257 3,309 18,432 58,365 (2,145) (12,590) (58,107) Starting Fund Balance 443,490 443,490 Net Change (39,850) (12,590) Ending Fund Balance 403,640 430,900 Budget by Organization Report Through 06/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 335 - WEST EVANSTON TIF FUND REVENUE Property Taxes - Other Revenue - Interest Income 150 Contingencies Debt Service Miscellaneous REVENUE TOTALS 150 EXPENSE Services and Supplies - Capital Outlay - REVENUE TOTALS EXPENSE TOTALS Fund 335 - WEST EVANSTON TIF Interfund Transfers EXPENSE TOTALS Fund 335 - WEST EVANSTON TIF 30,000 - 10,000 - (39,850) 40,000 150 40,000 Run by Ashley King on 07/26/2016 11:18:49 AM Page 24 of 52 June 2016 YTD 2016 2015 Transactions Transactions Total - - - - - 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 06/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 340 - DEMPSTER-DODGE TIF FUND REVENUE Property Taxes - Other Revenue 50,000 REVENUE TOTALS 50,000 REVENUE TOTALS EXPENSE Services and Supplies - Capital Outlay - Debt Service 40,000 40,000 EXPENSE TOTALS 40,000 Fund 340 - DEMPSTER-DODGE 10,000 50,000 EXPENSE TOTALS Fund 340 - DEMPSTER-DODGE Run by Ashley King on 07/26/2016 11:18:49 AM Page 25 of 52 June 2016 YTD 2016 2015 Transactions Transactions Total - - - - - 900,000 - - 900,000 - - - 580,000 580,000 580,000 3,593 20,584 7,930 583,593 600,584 587,930 - - 900,000 583,593 600,584 587,930 (583,593) (600,584) 312,070 Starting Fund Balance 312,070 312,070 Net Change 31,500 (600,584) Ending Fund Balance 343,570 (288,514) Budget by Organization Report Through 06/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 345 - CHICAGO-MAIN TIF REVENUE Property Taxes 75,000 Other Revenue - REVENUE TOTALS 75,000 REVENUE TOTALS EXPENSE Services and Supplies - Capital Outlay - Debt Service 43,500 43,500 EXPENSE TOTALS 43,500 Fund 345 - CHICAGO-MAIN TIF 31,500 75,000 EXPENSE TOTALS Fund 345 - CHICAGO-MAIN TIF Run by Ashley King on 07/26/2016 11:18:49 AM Page 26 of 52 June 2016 YTD 2016 2015 Transactions Transactions Total - - - - - - - - - - - - - - - - - - - - - - - - Starting Fund Balance - - Net Change 10,500 - Ending Fund Balance 10,500 - REVENUE TOTALS 210,500 Budget by Organization Report Through 06/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 350 - SPECIAL SERVICE AREA (SSA) #6 EXPENSE Services and Supplies 200,000 EXPENSE TOTALS 200,000 REVENUE Property Taxes 210,000 Interest Income 500 Fund 350 - SPECIAL SERVICE 10,500 200,000 210,500 Fund 350 - SPECIAL SERVICE REVENUE TOTALS EXPENSE TOTALS Run by Ashley King on 07/26/2016 11:18:49 AM Page 27 of 52 June 2016 YTD 2016 2015 Transactions Transactions Total - 25,403 87,391 456,333 3,155,500 - - 824,227 270,268 1,200 244,200 7,945,481 916 5,260 3,815 458,449 4,254,590 8,306,954 - - - 143,078 267,248 643,510 673,019 1,553,094 9,794,396 - - - - - 32,933 - - 490,000 816,098 1,820,342 10,960,839 458,449 4,254,590 8,306,954 816,098 1,820,342 10,960,839 (357,649) 2,434,248 (2,653,885) Starting Fund Balance 6,049,838 6,049,838 Net Change (2,209,000) 2,434,248 Ending Fund Balance 3,840,838 8,484,086 Budget by Organization Report Through 06/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 415 - CAPITAL IMPROVEMENTS FUND REVENUE Charges for Services - Interfund Transfers 6,471,000 Intergovernmental Revenue 4,841,615 - Services and Supplies 2,256,962 Capital Outlay 20,022,653 Other Revenue Interest Income REVENUE TOTALS EXPENSE TOTALS Fund 415 - CAPITAL REVENUE TOTALS Debt Service Miscellaneous Interfund Transfers EXPENSE TOTALS 22,769,615 Fund 415 - CAPITAL (2,209,000) 20,560,615 - 9,248,000 22,769,615 490,000 - - 20,560,615 EXPENSE Salary and Benefits Run by Ashley King on 07/26/2016 11:18:49 AM Page 28 of 52 June 2016 YTD 2016 2015 Transactions Transactions Total - - - - - - - - - - - - - - - - - - - - - - - 243,113 - - - - - - - - - 659 11,855 24,832 1,093 89,820 125,218 - - - 1,752 101,675 393,163 - - - - 12 1,879 - - 226,538 - - - - - - - - 534 30,058 180,349 - 30,058 180,361 228,951 1,752 101,675 393,163 30,058 180,361 228,951 (28,306) (78,686) 164,213 Starting Fund Balance 2,682,406 2,682,406 Net Change 98,950 (78,686) Ending Fund Balance 2,781,356 2,603,720 Budget by Organization Report Through 06/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 420 - SPECIAL ASSESSMENT FUND REVENUE Property Taxes - Other Taxes - Licenses, Permits and Fees - Intergovernmental Revenue Other Revenue Workers Compensation and Liability Fines and Forfeitures Charges for Services Interfund Transfers Special Assessment Reappropriation of Surplus REVENUE TOTALS Insurance Library Revenue Interest Income Insurance and Other Chargebacks Debt Service Miscellaneous EXPENSE Salary and Benefits - Services and Supplies - Capital Outlay - REVENUE TOTALS EXPENSE TOTALS Fund 420 - SPECIAL ASSESSMENT Interfund Transfers EXPENSE TOTALS Fund 420 - SPECIAL ASSESSMENT 98,950 382,250 481,200 382,250 382,250 - - - 481,200 - - - - - 180,167 51,033 - - - 250,000 Run by Ashley King on 07/26/2016 11:18:49 AM Page 29 of 52 June 2016 YTD 2016 2015 Transactions Transactions Total - - - - - - - 3,000 150 - - - 633,885 3,366,318 6,010,558 309,314 1,855,884 2,925,296 - - - 13,392 92,570 337,295 2,666 11,654 18,260 959,258 5,329,425 9,291,559 111,001 645,931 1,121,645 146,640 1,196,404 2,859,622 10,511 334,368 128,726 26,637 159,824 319,649 - - - - - 2,846,227 1,125 1,986 6,951 199,979 199,979 503,423 - 40,634 23,687 108,649 651,892 923,092 604,542 3,231,017 8,733,020 959,258 5,329,425 9,291,559 604,542 3,231,017 8,733,020 354,716 2,098,408 558,538 Starting Fund Balance 10,512,058 10,512,058 Net Change (6,615,186) 2,098,408 Ending Fund Balance 3,896,872 12,610,466 Budget by Organization Report Through 06/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 505 - PARKING SYSTEM FUND REVENUE Property Taxes - Other Taxes - Licenses, Permits and Fees - Intergovernmental Revenue Other Revenue Interest Income Fines and Forfeitures Charges for Services Interfund Transfers REVENUE TOTALS 10,322,856 EXPENSE Salary and Benefits 1,485,289 Services and Supplies 3,301,275 Depreciation Expense Contingencies Debt Service Capital Outlay Insurance and Other Chargebacks Community Sponsored Organizations REVENUE TOTALS 10,322,856 EXPENSE TOTALS 16,938,042 Miscellaneous Interfund Transfers EXPENSE TOTALS 35,070 Fund 505 - PARKING SYSTEM (6,615,186) 16,938,042 1,303,783 252,000 3,917,652 Fund 505 - PARKING SYSTEM 119,216 12,125 3,711,770 6,444,675 - 11,000 2,873,395 - 319,648 3,474,000 Run by Ashley King on 07/26/2016 11:18:49 AM Page 30 of 52 June 2016 YTD 2016 2015 Transactions Transactions Total - - - 9,233 49,827 105,483 1,351,409 7,695,270 15,308,225 - - 2,354,582 - - - 16,296 40,369 350,065 1,305 5,936 3,448 1,378,244 7,791,402 18,121,804 410,555 2,322,989 4,590,767 326,931 1,202,143 2,298,993 546,710 4,590,243 105 39,042 234,252 468,493 - - - - - 2,096,633 658 658 933 308,676 373,518 432,628 - 6,928 (286,678) 291,859 1,750,897 3,692,565 13,294,439 1,378,244 7,791,402 18,121,804 1,924,431 10,481,627 13,294,439 (546,186) (2,690,225) 4,827,365 Starting Fund Balance 7,619,979 7,619,979 Net Change (3,407,255) (2,690,225) Ending Fund Balance 4,212,724 4,929,754 1,924,431 10,481,627 Budget by Organization Report Through 06/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 510 - WATER FUND Interfund Transfers Intergovernmental Revenue Other Revenue REVENUE Other Taxes - Licenses, Permits and Fees 70,000 Charges for Services 15,298,000 Interest Income 1,600 REVENUE TOTALS 37,718,000 EXPENSE Salary and Benefits 5,105,126 Community Sponsored Organizations Depreciation Expense Contingencies Services and Supplies Capital Outlay Insurance and Other Chargebacks EXPENSE TOTALS Fund 510 - WATER FUND Totals REVENUE TOTALS Debt Service Miscellaneous Interfund Transfers EXPENSE TOTALS 41,125,255 Fund 510 - WATER FUND Totals (3,407,255) 37,718,000 41,125,255 3,502,313 62,980 1,053,288 1,000 - - - - 468,492 27,441,106 3,490,950 22,348,400 Run by Ashley King on 07/26/2016 11:18:49 AM Page 31 of 52 June 2016 YTD 2016 2015 Transactions Transactions Total 1,346,721 6,502,740 12,510,940 - - - - - 2,962 202 2,435 2,706 1,346,923 6,505,175 12,516,607 97,488 541,770 1,034,571 59,691 211,554 108,927 - 660,126 13,609 43,457 260,741 269,988 - - 3,443,723 - - - 565,178 4,266,793 1,550,407 - 5,000 3,306 43,532 261,190 735,235 809,346 6,207,174 7,159,766 1,346,923 6,505,175 12,516,607 809,346 6,207,174 7,159,766 537,577 298,001 5,356,842 Starting Fund Balance 4,420,037 4,420,037 Net Change (1,607,486) 298,001 Ending Fund Balance 2,812,551 4,718,038 Budget by Organization Report Through 06/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 515 - SEWER FUND REVENUE Charges for Services 12,888,650 Interfund Transfers - Other Revenue 984,165 Services and Supplies Capital Outlay Insurance and Other Chargebacks Interest Income 1,000 REVENUE TOTALS 13,873,815 EXPENSE Salary and Benefits 1,168,910 EXPENSE TOTALS 15,481,301 Miscellaneous Interfund Transfers EXPENSE TOTALS Depreciation Expense Contingencies Debt Service 9,222,913 Fund 515 - SEWER FUND Totals REVENUE TOTALS 13,873,815 - - 269,988 3,048,314 995,800 Fund 515 - SEWER FUND Totals (1,607,486) 15,481,301 773,876 1,500 Run by Ashley King on 07/26/2016 11:18:49 AM Page 32 of 52 June 2016 YTD 2016 2015 Transactions Transactions Total 41,903 81,934 213,490 306,005 1,772,122 3,561,584 87,997 527,984 1,055,967 - - - 8,966 47,000 228,469 - - - 444,871 2,429,040 5,059,510 69,111 388,651 849,300 299,776 1,685,165 3,717,885 130 2,664 24,738 - - - - - - - - - - - - 1,144 1,144 68,394 - - - 41,624 249,747 490,106 411,784 2,327,370 5,150,423 444,871 2,429,040 5,059,510 411,784 2,327,370 5,150,423 33,086 101,670 (90,913) Starting Fund Balance (1,034,768) (1,034,768) Net Change 60,844 101,670 Ending Fund Balance (973,924) (933,098) Budget by Organization Report Through 06/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 520 - SOLID WASTE FUND Intergovernmental Revenue Other Revenue Interest Income REVENUE Licenses, Permits and Fees 275,000 Charges for Services 3,632,394 Interfund Transfers 1,055,967 REVENUE TOTALS 5,201,361 EXPENSE Salary and Benefits 868,098 Services and Supplies 3,732,176 Depreciation Expense Contingencies Debt Service Capital Outlay Insurance and Other Chargebacks Community Sponsored Organizations 5,201,361 EXPENSE TOTALS 5,140,517 Miscellaneous Interfund Transfers EXPENSE TOTALS Fund 520 - SOLID WASTE FUND 60,844 5,140,517 499,493 15,000 - Fund 520 - SOLID WASTE FUND REVENUE TOTALS 238,000 - - - - - 25,750 - Run by Ashley King on 07/26/2016 11:18:49 AM Page 33 of 52 June 2016 YTD 2016 2015 Transactions Transactions Total 282,301 1,693,874 3,289,009 - - - - - - - 5,006 46,933 - - - 282,301 1,698,880 3,335,942 87,109 462,408 1,137,603 165,509 629,288 1,686,117 - - - 2,230 13,381 25,820 - - 105 - - - - - - - - - - - - 254,848 1,105,077 2,849,644 282,301 1,698,880 3,335,942 254,848 1,105,077 2,849,644 27,453 593,804 486,298 Starting Fund Balance 273,458 273,458 Net Change (244,277) 593,804 Ending Fund Balance 29,181 867,262 Budget by Organization Report Through 06/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 600 - FLEET SERVICES FUND Other Revenue Interest Income REVENUE TOTALS REVENUE Charges for Services 3,317,088 Interfund Transfers - Intergovernmental Revenue - EXPENSE Salary and Benefits 1,236,877 Services and Supplies 2,380,057 Capital Outlay - Debt Service Miscellaneous Interfund Transfers Insurance and Other Chargebacks Depreciation Expense Contingencies 450 EXPENSE TOTALS 3,644,146 Fund 600 - FLEET SERVICES FUND (244,277) 3,399,869 EXPENSE TOTALS Fund 600 - FLEET SERVICES FUND REVENUE TOTALS - 26,762 3,399,869 1,000 81,781 3,644,146 - - - Run by Ashley King on 07/26/2016 11:18:49 AM Page 34 of 52 June 2016 YTD 2016 2015 Transactions Transactions Total 121,255 727,640 1,451,422 - - - 19,486 31,437 34,286 140,741 759,077 1,485,708 2,565 5,891 53,400 1,940 6,698 - - - 1,684,835 - - - 4,505 12,589 1,738,234 140,741 759,077 1,485,708 4,505 12,589 1,738,234 136,236 746,488 (252,527) Starting Fund Balance 1,899,429 1,899,429 Net Change 146,216 746,488 Ending Fund Balance 2,045,645 2,645,917 Budget by Organization Report Through 06/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 601 - EQUIPMENT REPLACEMENT FUND Capital Outlay 1,455,422 REVENUE Charges for Services 1,451,421 Interfund Transfers - Other Revenue 210,217 EXPENSE TOTALS 1,515,422 Depreciation Expense Miscellaneous EXPENSE TOTALS REVENUE TOTALS 1,661,638 EXPENSE Services and Supplies 60,000 Fund 601 - EQUIPMENT 146,216 1,515,422 - - Fund 601 - EQUIPMENT REVENUE TOTALS 1,661,638 Run by Ashley King on 07/26/2016 11:18:49 AM Page 35 of 52 June 2016 YTD 2016 2015 Transactions Transactions Total 3,356 20,216 162,411 68 410 306,051 830,130 4,787,149 10,413,499 3,179 62,193 1,034,405 620,724 3,342,891 5,753,308 13 103 136 1,457,471 8,212,962 17,669,810 48,703 293,982 516,469 34,598 988,260 1,305,086 - - - 1,172,200 7,063,081 14,270,966 - - - - - - - - - - - - - 4,330 - - - - 1,255,501 8,349,652 16,092,521 1,457,471 8,212,962 17,669,810 1,255,501 8,349,652 16,092,521 201,970 (136,690) 1,577,289 Starting Fund Balance (3,954,618) (3,954,618) Net Change 565,405 (136,690) Ending Fund Balance (3,389,213) (4,091,308) Budget by Organization Report Through 06/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 605 - INSURANCE FUND Workers Compensation and Liability Insurance Interest Income REVENUE Charges for Services 162,411 Interfund Transfers - Other Revenue 10,111,694 REVENUE TOTALS 17,758,038 EXPENSE Salary and Benefits 479,323 Services and Supplies 1,385,248 Depreciation Expense Contingencies Debt Service Capital Outlay Insurance and Other Chargebacks Community Sponsored Organizations 17,758,038 EXPENSE TOTALS 17,192,633 Miscellaneous Interfund Transfers EXPENSE TOTALS Fund 605 - INSURANCE FUND 565,405 17,192,633 - - - Fund 605 - INSURANCE FUND REVENUE TOTALS 6,459,839 1,023,094 - - - 15,328,062 - 1,000 Run by Ashley King on 07/26/2016 11:18:49 AM Page 36 of 52 June 2016 YTD 2016 2015 Transactions Transactions Total 1,573 3,395,653 - - 50,995 280,000 - - - 75,763 440,159 7,061,335 - 45 417,897 77,336 3,886,851 7,759,232 691,339 4,192,938 8,302,220 - - - - - - - - - - - - 691,339 4,192,938 8,302,220 77,336 3,886,851 7,759,232 691,339 4,192,938 8,302,220 (614,003) (306,086) (542,988) Starting Fund Balance 68,529,102 68,529,102 Net Change 4,297,865 (306,086) Ending Fund Balance 72,826,967 68,223,016 Budget by Organization Report Through 06/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 700 - FIRE PENSION FUND Other Revenue Interest Income REVENUE TOTALS REVENUE Property Taxes 7,070,865 Other Taxes 280,000 Interfund Transfers - EXPENSE Salary and Benefits 8,163,000 Services and Supplies - Community Sponsored Organizations - REVENUE TOTALS 12,460,865 EXPENSE TOTALS 8,163,000 Debt Service Miscellaneous EXPENSE TOTALS 4,100,000 1,010,000 Fund 700 - FIRE PENSION FUND 4,297,865 8,163,000 - - 12,460,865 Fund 700 - FIRE PENSION FUND Run by Ashley King on 07/26/2016 11:18:49 AM Page 37 of 52 June 2016 YTD 2016 2015 Transactions Transactions Total 6,186 4,690,530 57,836 - 50,995 325,000 - - - 112,875 669,646 9,876,197 1,145 1,194 702,639 120,206 5,412,366 10,961,673 907,519 5,453,532 10,768,296 - - - - - - - - - 907,519 5,453,532 10,768,296 120,206 5,412,366 10,961,673 907,519 5,453,532 10,768,296 (787,312) (41,166) 193,377 Starting Fund Balance 102,150,249 102,150,249 Net Change 68,529,102 (41,166) Ending Fund Balance 170,679,351 102,109,083 Budget by Organization Report Through 06/30/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 705 - POLICE PENSION FUND Other Revenue Interest Income REVENUE TOTALS REVENUE Property Taxes 9,055,940 Other Taxes 325,000 Interfund Transfers - EXPENSE Salary and Benefits 11,047,000 Services and Supplies - Debt Service - REVENUE TOTALS EXPENSE TOTALS Fund 705 - POLICE PENSION Miscellaneous EXPENSE TOTALS Fund 705 - POLICE PENSION - 17,430,940 6,500,000 1,550,000 6,383,940 11,047,000 17,430,940 11,047,000 Run by Ashley King on 07/26/2016 11:18:49 AM Page 38 of 52 - 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