Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2016.05 May Monthly Report
To: Wally Bobkiewicz, City Manager Martin Lyons, Assistant City Manager/Chief Financial Officer From: Ashley King, Finance Division Manager Subject: May 2016 Monthly Financial Report Date: June 20, 2016 Please find attached the unaudited financial statements as of May 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 47,370,082 42,097,267 5,272,815 18,375,173 7,101,333 740,502 310,673 429,829 1,025,582 945,914 208,333 (208,333)791,667 791,667 3,426,146 2,511,934 914,212 3,017,103 1,583,794 4,964 21,730 (16,766)105,458 192,005 806,643 1,018,616 (211,973)1,076,104 1,476,057 217,584 610,271 (392,688)209,989 (15,685) 214,291 80,750 133,541 277,799 (57,004) 62,603 317,035 (254,432)221,708 (194,549) 44,406 110,856 (66,450)2,385,219 167,877 1,031,774 819,814 211,960 2,893,237 2,433,255 169,915 169,915 31,079 41,414 (10,334)4,622,674 (5,564) 180,137 18,275 161,863 2,875,377 1,119,022 194,050 41,447 152,604 285,271 38,815 2,699,463 2,692,529 6,934 6,979,481 6,599,641 287,795 287,795 877,222 813,224 743,088 916,719 (173,631)1,132,126 1,180,589 345,023 32,168 312,855 488,877 295,635 4,678 15,123 (10,445)433,045 445,141 - 16,990 (16,990)295,080 295,080 6,701,527 13,488,913 (6,787,386)8,910,036 7,153,525 3,796,141 1,004,245 2,791,896 8,841,734 9,213,199 99,923 150,303 (50,380)2,632,026 2,628,864 4,350,047 2,626,475 1,723,573 12,235,631 12,049,522 12,110,402 14,254,700 (2,144,298)3,880,344 5,049,695 5,158,252 5,397,828 (239,576)4,180,461 2,137,940 1,984,169 1,915,586 68,584 (966,184) (1,648,090) 368,664 216,486 152,178 226,114 187,584 1,416,579 850,229 566,351 839,809 257,732 618,336 8,084 610,252 2,509,681 1,492,870 6,755,491 7,094,151 (338,659)(4,293,277) 2,082,795 Grand Totals 101,763,841 98,888,942 2,874,899 87,534,480 65,981,798 605 INSURANCE FUND 315 340 176 HEALTH AND HUMAN SERVICES 600 FLEET SERVICES FUND 601 EQUIPMENT REPLACEMENT FUND 510 WATER FUND 515 SEWER FUND 520 SOLID WASTE FUND 415 CAPITAL IMPROVEMENTS FUND 420 SPECIAL ASSESSMENT FUND 505 PARKING SYSTEM FUND 335 WEST EVANSTON TIF FUND DEMPSTER-DODGE TIF 345 CHICAGO-MAIN TIF 320 DEBT SERVICE FUND 305 SPECIAL SERVICE AREA (SSA) #5 310 HOWARD-HARTREY TIF SOUTHWEST- TIF 330 HOWARD-RIDGE TIF FUND 250 AFFORDABLE HOUSING FUND 186 LIBRARY DEBT SERVICE FUND 300 WASHINGTON NATIONAL TIF 225 ECONOMIC DEVELOPMENT FUND 235 NEIGHBORHOOD IMPROVEMENT 240 HOME FUND 210 SPECIAL SERVICE AREA (SSA) #4 215 CDBG FUND 220 CDBG LOAN 195 NEIGHBORHOOD STABILIZATION 200 MOTOR FUEL TAX FUND 205 EMERGENCY TELEPHONE (E911) 175 GENERAL ASSISTANCE FUND 180 GOOD NEIGHBOR FUND 185 LIBRARY FUND Fund Fund Description 100 GENERAL FUND NOTE: Negative Cash Balances (as seen above in the CDBG, SSA 4, E911 & 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 May 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 may be used (or easily sold) to support and fund current operations. Wh ile 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 May 31, 2016, the General Fund is reporting a net surplus of $5,272,815. The attached supplemental charts show the General Fund Revenues at 42.24% of budget and expenses lower at 37.69%. The May target is 41.67%. Parks and Recreation seasonal expenses will begin showing up in June, July, and August. Adding these, the City’s expenses will be closer to budgeted amounts. Through May 31, 2016, the E911 Fund is showing a negative cash balance of $15,685 due to the timing of 911 fee receipts. This negative cash balance will impact the completion of the 911 software replacement. Through May 31, 2016, the SSA #4 Fund is showing a negative cash balance of $57,004 due to the timing of payments to the Downtown Evanston group. Through May 31, 2016, the CDBG Fund is showing a negative cash balance of $194,549 which will be reimbursed from May draw-downs. Through May 31, 2016, the Economic Development Fund is showing a fund balance of $2,893,237 and a cash balance of $2,433,255. 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 installme nt billing. The fund will then officially close. Through May 31, 2016, the enterprise funds (Parking, Water, and Sewer) have balances above average. As construction season begins, 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 84% 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 included. The net impact of this refun ding is a savings to the City over the life of the bonds. Through May 31, 2016, the Solid Waste Fund has a negative fund balance of $966,184 and a negative cash balance of $1,648,090. May includes multiple payments to GROOT for debris removal. Fund 100 - GENERAL FUND May 2016 Financial Statement 2016 % 2015 Budget May 2016 YTD 2016 YTD Actual 27,417,407 116,922 15,402,575 56.18%11,397,061 45,986,550 4,941,584 17,615,097 38.30%44,550,869 5,329,777 477,860 1,706,758 32.02%5,324,137 9,276,550 403,632 3,192,518 34.41%6,704,846 125,700 1,747 41,419 32.95%155,619 4,609,825 270,982 1,290,464 27.99%3,548,230 640,000 0.00%640,000 5,374,751 1,233,792 3,059,710 56.93%5,406,379 2,433,216 191,507 1,188,201 48.83%2,239,528 8,842,365 646,242 3,231,209 36.54%7,836,484 765,727 119,697 258,915 33.81%670,245 1,286,843 143,489 377,434 29.33%894,703 50,000 1,868 5,781 11.56%6,572 REVENUE TOTAL 112,138,711 8,549,321 47,370,082 42.24%89,374,673 13 - CITY COUNCIL 424,958 36,614 175,309 41.25% 419,962 14 - CITY CLERK 263,203 15,712 112,426 42.71% 283,764 15 - CITY MANAGER'S OFFICE 6,989,746 963,734 2,300,209 32.91% 1,814,469 17 - LAW 1,130,000 58,056 376,438 33.31% 1,051,325 19 - ADMINISTRATIVE SERVICES 9,634,173 588,107 3,252,795 33.76% 9,763,951 21 - COMMUNITY DEVELOPMENT 2,740,032 152,584 940,688 34.33% 2,425,618 22 - POLICE 37,696,278 1,568,400 15,501,363 41.12% 28,493,534 23 - FIRE MGMT & SUPPORT 22,601,742 1,025,305 9,430,905 41.73% 14,954,025 24 - HEALTH 3,544,226 496,914 1,190,051 33.58% 3,212,848 26 - PUBLIC WORKS - - 18,148,755 30 - PARKS, REC. AND COMMUNITY SERV. 11,820,590 788,624 3,540,782 29.95% 11,180,116 40 - PUBLIC WORKS AGENCY 14,861,248 1,157,411 5,276,300 35.50% - EXPENSE TOTAL 111,706,196 6,851,461 42,097,267 37.69%91,748,366 112,138,711 8,549,321 47,370,082 89,374,673 111,706,196 6,851,461 42,097,267 91,748,366 432,515 1,697,861 5,272,815 (2,373,693) REVENUE TOTALS EXPENSE TOTALS Fund 100 - GENERAL Other Charges for Services Interfund Transfers Intergovernmental Revenue Other Revenue Interest Income Fund 100 - GENERAL License Permit Fee Fines and Forfeitures Parking Charges for Services Parks and Recreation Charges for Classification Fund 100 - GENERAL FUND Property Taxes Other Taxes Fund 505 - PARKING SYSTEM FUND May 2016 Financial Statement 2016 % 2015 Budget May 2016 YTD 2016 YTD Actual 600 3,000 150 6,379,675 549,788 2,712,372 42.52%6,010,558 65,000 0.00% 3,711,770 309,314 1,546,570 41.67%2,925,296 12,125 0.00% 119,216 15,783 79,117 66.36%300,923 35,070 2,051 8,988 25.63%18,260 REVENUE TOTAL 10,322,856 876,936 4,347,047 42.11%9,255,037 23,000 675 11,170 48.57%29,187 1,348,940 72,881 484,789 35.94%1,125,491 113,349 8,378 38,971 34.38%107,452 3,022,411 54,346 959,414 31.74%2,703,537 278,864 19,943 90,350 32.40%243,068 3,474,000 13,485 323,857 9.32%128,726 319,648 79,912 133,187 41.67%319,649 2,873,395 0.00%2,846,227 11,000 861 7.82%6,951 3,917,652 0.00%503,423 252,000 40,634 40,634 16.12%23,687 1,303,783 108,649 543,243 41.67%923,092 EXPENSE TOTAL 16,938,042 398,904 2,626,475 15.51%8,960,489 10,322,856 877,536 4,350,047 9,255,187 16,938,042 398,904 2,626,475 8,960,489 (6,615,186)478,632 1,723,573 294,698 Classification Fund 505 - PARKING SYSTEM FUND Permit Parking Charges for Services Parks and Recreation Charges for Interfund Transfers Intergovernmental Revenue Other Revenue Interest Income Employee Pay Benefits Pensions Services Supplies Capital Outlay Insurance and Other Chargebacks Depreciation Expense Contingencies EXPENSE TOTALS Fund 505 - PARKING Debt Service Miscellaneous Interfund Transfers Fund 505 - PARKING REVENUE TOTALS Fund 510 - WATER FUND May 2016 Financial Statement 2016 % 2015 Budget May 2016 YTD 2016 YTD Actual 70,000 5,288 40,593 57.99%105,483 15,133,000 1,475,980 6,327,681 41.81%15,141,770 39,000 4,117 16,250 41.67%40,911 126,000 (70)-0.06%125,545 500,000 5,697,244 2,354,582 22,348,400 2,019 24,074 0.11%338,396 1,600 937 4,630 289.40%3,448 REVENUE TOTAL 37,718,000 1,988,342 12,110,402 32.11%18,110,135 210,465 11,555 55,103 26.18%157,679 4,534,306 253,041 1,714,220 37.81%4,547,958 360,355 29,826 143,112 39.71%432,229 4,763,760 85,304 588,816 12.36%1,232,260 1,392,190 54,735 286,396 20.57%1,048,119 24,776,106 827,980 4,043,533 16.32%2,352,688 468,492 117,126 195,210 41.67%468,493 2,096,633 1,000 0.00%933 1,053,288 31,089 64,842 6.16%432,628 62,980 6,928 11.00%(286,678) 3,502,313 791,859 7,156,541 204.34%3,692,565 EXPENSE TOTAL 41,125,255 2,202,516 14,254,700 34.66%16,175,506 37,718,000 1,488,295 6,412,926 18,110,135 13,759,949 1,340,943 10,152,561 13,818,570 23,958,051 147,352 (3,739,635)4,291,565 Classification Fund 510 - WATER FUND Fee Water Charges for Services Sewer Charges for Services Other Charges for Services Interfund Transfers Other Revenue Interest Income Employee Pay Benefits Pensions Services Supplies Capital Outlay Insurance and Other Chargebacks Depreciation Expense Contingencies EXPENSE TOTALS Fund 510 - WATER FUND Debt Service Miscellaneous Interfund Transfers Fund 510 - WATER FUND REVENUE TOTALS Fund 515 - SEWER FUND May 2016 Financial Statement 2016 % 2015 Budget May 2016 YTD 2016 YTD Actual 12,869,000 1,007,757 5,156,019 40.07%12,491,290 19,650 0.00%19,650 984,165 0.00%12,521 1,000 525 2,233 223.31%2,706 REVENUE TOTAL 13,873,815 1,008,281 5,158,252 37.18%12,526,166 57,040 1,738 14,278 25.03%60,837 1,025,778 50,864 396,170 38.62%1,000,833 86,092 6,101 33,833 39.30%101,701 903,500 137,555 139,600 15.45%90,234 92,300 5,639 12,263 13.29%18,817 3,048,314 554,863 660,126 21.66%13,609 269,988 88,455 217,284 80.48%269,988 3,443,723 9,222,913 1,024,321 3,701,614 40.13%1,550,407 1,500 5,000 333.33%3,306 773,876 43,532 217,658 28.13%735,235 EXPENSE TOTAL 15,481,301 1,913,067 5,397,828 34.87%7,288,691 13,873,815 1,008,281 5,158,252 12,526,166 15,481,301 1,913,067 5,397,828 7,288,691 (1,607,486)(904,786)(239,576)5,237,476 Classification Fund 515 - SEWER FUND Sewer Charges for Services Other Charges for Services Other Revenue Interest Income Employee Pay Benefits Pensions Services Supplies Capital Outlay Insurance and Other Chargebacks Depreciation Expense EXPENSE TOTALS Fund 515 - SEWER FUND Debt Service Miscellaneous Interfund Transfers Fund 515 - SEWER FUND REVENUE TOTALS Fund 520 - SOLID WASTE FUND May 2016 Financial Statement 2016 % 2015 Budget May 2016 YTD 2016 YTD Actual 275,000 40,031 14.56%213,490 3,632,394 283,436 1,466,118 40.36%3,561,584 1,055,967 87,997 439,986 41.67%1,055,967 238,000 13,776 38,034 15.98%228,469 REVENUE TOTAL 5,201,361 385,209 1,984,169 38.15%5,059,510 25,000 3,305 19,001 76.00%41,358 779,380 41,375 277,468 35.60%823,923 63,718 5,066 23,072 36.21%68,816 3,679,126 850,094 1,370,334 37.25%3,644,097 53,050 7,143 15,055 28.38%73,788 25,750 2,450 2,534 9.84%24,738 68,394 15,000 0.00% 499,493 41,624 208,122 41.67%490,106 EXPENSE TOTAL 5,140,517 951,058 1,915,586 37.26%5,235,220 5,201,361 385,209 1,984,169 5,059,510 5,140,517 951,058 1,915,586 5,235,220 60,844 (565,848)68,584 (175,710) Classification Fund 520 - SOLID WASTE FUND License Other Charges for Services Interfund Transfers Other Revenue Employee Pay Benefits Pensions Services Supplies Capital Outlay Debt Service Miscellaneous Interfund Transfers Fund 520 - SOLID WASTE REVENUE TOTALS EXPENSE TOTALS Fund 520 - SOLID WASTE May-16 YTD 2015 Actual Transactions Transactions Total 116,992.07 15,402,575.08 11,397,060.64 4,941,584.14 17,615,097.33 44,550,869.16 883,239.20 4,940,695.36 12,184,601.82 270,982.48 1,290,464.49 3,548,230.14 1,425,298.25 4,247,910.97 8,285,907.19 646,242 3,231,209 7,836,484 119,697 258,915 670,245 143,489 377,434 894,703 - - - - - - - - - 1,868 5,781 6,572 - - - - - - 89,374,673 3,731,570 26,087,596 68,732,666 960,107 3,112,026 11,506,401 20,158 59,998 155,975 632,637 1,257,900 3,020,991 341,272 359,260 952,678 - - - - 89 30,529 - - - 151,778 617,738 2,047,272 1,078,137 10,602,659 5,301,854 6,915,658 42,097,267 91,748,366 8,549,391 47,370,082 89,374,673 6,915,658 42,097,267 91,748,366 1,633,734 5,272,815 (2,373,693) Starting Fund Balance 13,102,358 13,102,358 Net Change (567,485) 5,272,815 Ending Fund Balance 12,534,873 18,375,173 EXPENSE TOTALS 112,706,196 Fund 100 - GENERAL FUND Totals (567,485) EXPENSE TOTALS 112,706,196 Fund 100 - GENERAL FUND Totals REVENUE TOTALS 112,138,711 Debt Service - Miscellaneous 1,661,899 Interfund Transfers 6,534,528 Community Sponsored Organizations 925,029 Depreciation Expense - Contingencies 213,505 Services and Supplies 11,776,309 Capital Outlay 200,600 Insurance and Other Chargebacks 20,282,973 Reappropriation of Surplus - REVENUE TOTALS 112,138,711 EXPENSE Salary and Benefits 71,111,353 Library Revenue - Interest Income 50,000 Special Assessment - Other Revenue 1,286,843 Workers Compensation and Liability - Insurance - Charges for Services 8,447,967.00 Interfund Transfers 8,842,365 Intergovernmental Revenue 765,727 27,417,407.00 Other Taxes 45,986,550.00 Licenses, Permits and Fees 14,732,027.00 Fines and Forfeitures 4,609,825.00 8,549,391 47,370,082 Budget by Organization Report Through 05/31/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 100 - GENERAL FUND REVENUE Property Taxes May-16 YTD 2015 Actual Transactions Transactions Total 5,673 561,780 1,313,420 - - - - - - - - - - - - - - - - - 3,208 401 34,685 19,534 - - - - - - - - - 46 180 62 - - - - - - 6,120 596,646 1,336,224 19,698 98,762 185,431 46,503 211,674 591,542 - - - - - - - - - - - - - - - - - - 60 238 4,625 - - - 66,261 310,673 781,598 6,120 596,646 1,336,224 66,261 310,673 781,598 (60,141) 285,973 554,625 Starting Fund Balance 739,609 739,609 Net Change 38,167 285,973 Ending Fund Balance 777,776 1,025,582 REVENUE TOTALS 1,026,000 EXPENSE TOTALS 987,833 Fund 175 - GENERAL 38,167 Interfund Transfers - EXPENSE TOTALS 987,833 Fund 175 - GENERAL Contingencies - Debt Service - Miscellaneous 7,000 Insurance and Other Chargebacks - Community Sponsored Organizations - Depreciation Expense - EXPENSE Salary and Benefits 221,933 Services and Supplies 758,900 Capital Outlay - Special Assessment - Reappropriation of Surplus - REVENUE TOTALS 1,026,000 Insurance - Library Revenue - Interest Income 1,000 Intergovernmental Revenue - Other Revenue 25,000 Workers Compensation and Liability - Fines and Forfeitures - Charges for Services - Interfund Transfers - REVENUE Property Taxes 1,000,000 Other Taxes - Licenses, Permits and Fees - Budget by Organization Report Through 05/31/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 175 - GENERAL ASSISTANCE FUND Run by Ashley King on 06/17/2016 01:53:02 PM Page 3 of 43 May-16 YTD 2015 Actual Transactions Transactions Total - - - 368,664 368,664 884,794 - - - - - - 368,664 368,664 884,794 - - - - - - 25,778 216,486 849,388 - - - 25,778 216,486 849,388 368,664 368,664 884,794 25,778 216,486 849,388 342,886 152,178 35,406 Starting Fund Balance 48,295 73,936 Net Change 25,641 152,178 Ending Fund Balance 73,936 226,114 EXPENSE TOTALS 859,153 Fund 176 - HEALTH AND HUMAN 25,641 EXPENSE TOTALS 859,153 Fund 176 - HEALTH AND HUMAN REVENUE TOTALS 884,794 Capital Outlay - Community Sponsored Organizations 859,153 Miscellaneous - Other Revenue - REVENUE TOTALS 884,794 EXPENSE Services and Supplies - REVENUE Charges for Services - Interfund Transfers 884,794 Intergovernmental Revenue - Budget by Organization Report Through 05/31/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 176 - HEALTH AND HUMAN SERVICES Run by Ashley King on 06/17/2016 01:53:02 PM Page 5 of 43 May-16 YTD 2015 Actual Transactions Transactions Total - - - - - - 41,667 208,333 - 41,667 208,333 - - - - 41,667 208,333 - (41,667) (208,333) - Starting Fund Balance 1,000,000 1,000,000 Net Change - (208,333) Ending Fund Balance 1,000,000 791,667 REVENUE TOTALS 1,000,000 EXPENSE TOTALS 1,000,000 Fund 180 - GOOD NEIGHBOR - Interfund Transfers 1,000,000 EXPENSE TOTALS 1,000,000 Fund 180 - GOOD NEIGHBOR REVENUE Other Revenue 1,000,000 REVENUE TOTALS 1,000,000 EXPENSE Budget by Organization Report Through 05/31/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 180 - GOOD NEIGHBOR FUND Run by Ashley King on 06/17/2016 01:53:02 PM Page 6 of 43 May-16 YTD 2015 Actual Transactions Transactions Total 27,375 3,272,874 5,916,852 - - 50,200 10,922 65,684 129,808 - - 171,000 - - 181,283 11,618 15,729 286 7,097 70,298 315,924 498 1,561 2,683 57,510 3,426,146 6,768,037 319,381 1,777,165 5,151,922 149,704 555,390 1,426,649 - 37,599 299,628 6,674 33,370 77,268 - - - - - - - - - 20,833 104,167 250,000 849 4,243 4,200 497,441 2,511,934 7,209,667 57,510 3,426,146 6,768,037 497,441 2,511,934 7,209,667 (439,931) 914,212 (441,629) Starting Fund Balance 2,102,891 2,102,891 Net Change 20,015 914,212 Ending Fund Balance 2,122,906 3,017,103 EXPENSE TOTALS 6,997,142 Fund 185 - LIBRARY FUND Totals 20,015 EXPENSE TOTALS 6,997,142 Fund 185 - LIBRARY FUND Totals REVENUE TOTALS 7,017,157 Debt Service - Miscellaneous 250,000 Interfund Transfers 10,183 Insurance and Other Chargebacks 80,089 Depreciation Expense - Contingencies - EXPENSE Salary and Benefits 4,751,497 Services and Supplies 1,872,573 Capital Outlay 32,800 Library Revenue 333,300 Interest Income 2,000 REVENUE TOTALS 7,017,157 Interfund Transfers 185,800 Intergovernmental Revenue 94,177 Other Revenue 247,500 REVENUE Property Taxes 6,104,180 Other Taxes 50,200 Fines and Forfeitures - Budget by Organization Report Through 05/31/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 185 - LIBRARY FUND Run by Ashley King on 06/17/2016 01:53:02 PM Page 7 of 43 May-16 YTD 2015 Actual Transactions Transactions Total 1,555 194,050 601,811 - - - 1,555 194,050 601,811 - - - - 41,447 - - - 562,740 - - - - 41,447 562,740 1,555 194,050 601,811 - 41,447 562,740 1,555 152,604 39,072 Starting Fund Balance 132,667 132,667 Net Change - 152,604 Ending Fund Balance 132,667 285,271 REVENUE TOTALS 393,409 EXPENSE TOTALS 393,409 Fund 186 - LIBRARY DEBT - Miscellaneous - EXPENSE TOTALS 393,409 Fund 186 - LIBRARY DEBT EXPENSE Services and Supplies - Capital Outlay - Debt Service 393,409 REVENUE Property Taxes 393,409 Interest Income - REVENUE TOTALS 393,409 Budget by Organization Report Through 05/31/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 186 - LIBRARY DEBT SERVICE FUND Run by Ashley King on 06/17/2016 01:53:02 PM Page 8 of 43 May-16 YTD 2015 Actual Transactions Transactions Total - - - - 4,863 130,126 - - - 24 101 - 24 4,964 130,126 1,610 10,297 59,467 - 3,060 4,611 - 4,863 68,352 362 1,810 5,730 - - - - 1,700 179 - - (8,213) 1,972 21,730 130,126 24 4,964 130,126 1,972 21,730 130,126 (1,948) (16,766) - Starting Fund Balance 122,224 122,224 Net Change (303) (16,766) Ending Fund Balance 121,921 105,458 EXPENSE TOTALS 198,954 Fund 195 - NEIGHBORHOOD (303) EXPENSE TOTALS 198,954 Fund 195 - NEIGHBORHOOD REVENUE TOTALS 198,651 Debt Service - Miscellaneous 120,862 Interfund Transfers - Services and Supplies 5,100 Capital Outlay 35,000 Insurance and Other Chargebacks 4,344 Interest Income - REVENUE TOTALS 198,651 EXPENSE Salary and Benefits 33,648 REVENUE Licenses, Permits and Fees - Intergovernmental Revenue 198,651 Other Revenue - Budget by Organization Report Through 05/31/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 195 - NEIGHBORHOOD STABILIZATION FUND Run by Ashley King on 06/17/2016 01:53:02 PM Page 9 of 43 May-16 YTD 2015 Actual Transactions Transactions Total 169,516 804,371 2,465,781 - - - 583 2,272 819 - - - 170,099 806,643 2,466,600 - - - - 106,533 1,583,238 - - - - - - - - - 182,417 912,083 833,000 182,417 1,018,616 2,416,238 170,099 806,643 2,466,600 182,417 1,018,616 2,416,238 (12,317) (211,973) 50,362 Starting Fund Balance 1,288,077 1,288,077 Net Change (478,000) (211,973) Ending Fund Balance 810,077 1,076,104 Fund 200 - MOTOR FUEL TAX (478,000) Fund 200 - MOTOR FUEL TAX REVENUE TOTALS 1,711,000 EXPENSE TOTALS 2,189,000 Miscellaneous - Interfund Transfers 2,189,000 EXPENSE TOTALS 2,189,000 Capital Outlay - Contingencies - Debt Service - Reappropriation of Surplus - REVENUE TOTALS 1,711,000 EXPENSE Services and Supplies - REVENUE Intergovernmental Revenue 1,710,000 Other Revenue - Interest Income 1,000 Budget by Organization Report Through 05/31/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 200 - MOTOR FUEL TAX FUND Run by Ashley King on 06/17/2016 01:53:02 PM Page 10 of 43 May-16 YTD 2015 Actual Transactions Transactions Total 48,825 216,697 977,071 - - - - - 100 191 886 189 49,016 217,584 977,361 32,653 223,349 584,120 84,449 167,373 347,694 16,156 153,027 239,421 5,402 12,469 29,486 - - - - - 2,046 - - - - - 1,500 10,811 54,054 129,729 149,471 610,271 1,333,996 49,016 217,584 977,361 149,471 610,271 1,333,996 (100,455) (392,688) (356,635) Starting Fund Balance 602,677 602,677 Net Change (497,643) (392,688) Ending Fund Balance 105,034 209,989 Fund 205 - EMERGENCY (497,643) Fund 205 - EMERGENCY REVENUE TOTALS 1,019,000 EXPENSE TOTALS 1,516,643 Miscellaneous - Interfund Transfers 129,729 EXPENSE TOTALS 1,516,643 Community Sponsored Organizations - Contingencies 5,000 Debt Service - Services and Supplies 377,600 Capital Outlay 393,615 Insurance and Other Chargebacks 29,926 Interest Income 1,000 REVENUE TOTALS 1,019,000 EXPENSE Salary and Benefits 580,773 REVENUE Other Taxes 1,018,000 Intergovernmental Revenue - Other Revenue - Budget by Organization Report Through 05/31/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 205 - EMERGENCY TELEPHONE (E911) FUND Run by Ashley King on 06/17/2016 01:53:02 PM Page 11 of 43 May-16 YTD 2015 Actual Transactions Transactions Total (305) 214,289 322,055 0 1 3 (305) 214,291 322,058 - 80,750 323,000 - - - - - - - 80,750 323,000 (305) 214,291 322,058 - 80,750 323,000 (305) 133,541 (942) Starting Fund Balance 144,258 144,258 Net Change - 133,541 Ending Fund Balance 144,258 277,799 EXPENSE TOTALS 320,000 Fund 210 - SPECIAL SERVICE - EXPENSE TOTALS 320,000 Fund 210 - SPECIAL SERVICE REVENUE TOTALS 320,000 EXPENSE Services and Supplies 320,000 Debt Service - Miscellaneous - REVENUE Property Taxes 320,000 Interest Income - REVENUE TOTALS 320,000 Budget by Organization Report Through 05/31/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 210 - SPECIAL SERVICE AREA (SSA) #4 Run by Ashley King on 06/17/2016 01:53:02 PM Page 12 of 43 May-16 YTD 2015 Actual Transactions Transactions Total - - - - - - 52,406 52,406 1,442,742 - 10,197 3,318 - - - 52,406 62,603 1,446,060 33,276 184,630 362,786 78 2,439 17,538 2,406 6,729 276,834 - 2,273 20,767 - - 235,459 - - - - - - 50,269 51,203 12,259 - 69,760 449,083 86,030 317,035 1,374,727 52,406 62,603 1,446,060 86,030 317,035 1,374,727 (33,624) (254,432) 71,333 Starting Fund Balance 476,140 476,140 Net Change 375 (254,432) Ending Fund Balance 476,515 221,708 EXPENSE TOTALS 2,594,625 Fund 215 - CDBG FUND Totals 375 EXPENSE TOTALS 2,594,625 Fund 215 - CDBG FUND Totals REVENUE TOTALS 2,595,000 Debt Service - Miscellaneous 1,274,280 Interfund Transfers 837,124 Insurance and Other Chargebacks 26,989 Community Sponsored Organizations - Contingencies - EXPENSE Salary and Benefits 452,432 Services and Supplies 3,800 Capital Outlay - Other Revenue - Interest Income - REVENUE TOTALS 2,595,000 REVENUE Charges for Services - Interfund Transfers - Intergovernmental Revenue 2,595,000 Budget by Organization Report Through 05/31/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 215 - CDBG FUND Run by Ashley King on 06/17/2016 01:53:02 PM Page 13 of 43 May-16 YTD 2015 Actual Transactions Transactions Total - - - 2,500 39,899 14,951 4,386 4,507 375 6,886 44,406 15,326 - - - 52,549 52,976 280,461 57,880 57,880 1,919 - - - 110,429 110,856 282,380 6,886 44,406 15,326 110,429 110,856 282,380 (103,543) (66,450) (267,054) Starting Fund Balance 2,451,669 2,451,669 Net Change - (66,450) Ending Fund Balance 2,451,669 2,385,219 Fund 220 - CDBG LOAN Totals - Fund 220 - CDBG LOAN Totals REVENUE TOTALS 350,000 EXPENSE TOTALS 350,000 Miscellaneous 10,000 Interfund Transfers - EXPENSE TOTALS 350,000 REVENUE TOTALS 350,000 EXPENSE Salary and Benefits - Services and Supplies 340,000 REVENUE Intergovernmental Revenue - Other Revenue 350,000 Interest Income - Budget by Organization Report Through 05/31/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 220 - CDBG LOAN Run by Ashley King on 06/17/2016 01:53:02 PM Page 14 of 43 May-16 YTD 2015 Actual Transactions Transactions Total 25,758 787,748 2,116,843 - - - - - - 1,665 236,228 49,000 7,376 7,798 128 34,798 1,031,774 2,165,971 32,591 219,644 600,779 22,669 96,034 302,867 11,100 40,333 194,941 4,767 12,202 32,230 - - - - - - - - - 96,506 97,436 1,293,041 70,833 354,165 600,000 238,466 819,814 3,023,858 34,798 1,031,774 2,165,971 238,466 819,814 3,023,858 (203,668) 211,960 (857,887) Starting Fund Balance 2,681,277 2,681,277 Net Change (286,099) 211,960 Ending Fund Balance 2,395,178 2,893,237 EXPENSE TOTALS 2,548,699 Fund 225 - ECONOMIC (286,099) EXPENSE TOTALS 2,548,699 Fund 225 - ECONOMIC REVENUE TOTALS 2,262,600 Debt Service - Miscellaneous 16,000 Interfund Transfers 600,000 Insurance and Other Chargebacks 32,770 Community Sponsored Organizations - Contingencies - EXPENSE Salary and Benefits 734,229 Services and Supplies 912,200 Capital Outlay 253,500 Other Revenue 50,000 Interest Income 100 REVENUE TOTALS 2,262,600 REVENUE Other Taxes 2,165,000 Interfund Transfers 47,500 Intergovernmental Revenue - Budget by Organization Report Through 05/31/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 225 - ECONOMIC DEVELOPMENT FUND Run by Ashley King on 06/17/2016 01:53:02 PM Page 15 of 43 May-16 YTD 2015 Actual Transactions Transactions Total .00 .00 .00 .00 .00 .00 .00 .00 .00 $0.00 $0.00 $0.00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 $0.00 $0.00 $0.00 .00 .00 .00 .00 .00 .00 $0.00 $0.00 $0.00 Starting Fund Balance 169,915 169,915 Net Change (80,000) - Ending Fund Balance 89,915 169,915 EXPENSE TOTALS 100,000.00 Fund 235 - NEIGHBORHOOD ($80,000.00) EXPENSE TOTALS $100,000.00 Fund 235 - NEIGHBORHOOD REVENUE TOTALS 20,000.00 Debt Service .00 Miscellaneous 100,000.00 Interfund Transfers .00 REVENUE TOTALS $20,000.00 EXPENSE Services and Supplies .00 Capital Outlay .00 REVENUE Other Taxes 20,000.00 Interfund Transfers .00 Interest Income .00 Budget by Organization Report Through 05/31/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 235 - NEIGHBORHOOD IMPROVEMENT Run by Ashley King on 06/17/2016 01:53:02 PM Page 16 of 43 May-16 YTD 2015 Actual Transactions Transactions Total - 19,788 465,961 2,157 11,285 6,402 1 7 19 2,158 31,079 472,382 3,310 9,181 12,388 8,907 31,891 282,753 - - - 205 342 1,368 - - - - - - - - 45,747 - - 26,990 12,422 41,414 369,246 2,158 31,079 472,382 12,422 41,414 369,246 (10,264) (10,334) 103,136 Starting Fund Balance 4,633,008 4,633,008 Net Change - (10,334) Ending Fund Balance 4,633,008 4,622,674 EXPENSE TOTALS 402,168 Fund 240 - HOME FUND Totals - EXPENSE TOTALS 402,168 Fund 240 - HOME FUND Totals REVENUE TOTALS 402,168 Debt Service - Miscellaneous 500 Interfund Transfers - Capital Outlay - Insurance and Other Chargebacks 820 Community Sponsored Organizations - REVENUE TOTALS 402,168 EXPENSE Salary and Benefits 48,348 Services and Supplies 352,500 REVENUE Intergovernmental Revenue 393,868 Other Revenue 8,300 Interest Income - Budget by Organization Report Through 05/31/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 240 - HOME FUND Run by Ashley King on 06/17/2016 01:53:02 PM Page 17 of 43 May-16 YTD 2015 Actual Transactions Transactions Total - 36,667 100,000 - - - - - - 417 142,971 125,150 107 499 111 524 180,137 225,261 3,310 9,180 - - - 98 - - - - - - - - - 1,725 9,094 142,171 - - - 5,035 18,275 142,270 524 180,137 225,261 5,035 18,275 142,270 (4,511) 161,863 82,992 Starting Fund Balance 2,713,514 2,713,514 Net Change (313,719) 161,863 Ending Fund Balance 2,399,795 2,875,377 REVENUE TOTALS 160,628 EXPENSE TOTALS 474,347 Fund 250 - AFFORDABLE (313,719) Interfund Transfers - EXPENSE TOTALS 474,347 Fund 250 - AFFORDABLE Community Sponsored Organizations - Debt Service - Miscellaneous 76,000 EXPENSE Salary and Benefits 48,347 Services and Supplies 350,000 Capital Outlay - Other Revenue 130,400 Interest Income 228 REVENUE TOTALS 160,628 REVENUE Other Taxes 30,000 Interfund Transfers - Intergovernmental Revenue - Budget by Organization Report Through 05/31/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 250 - AFFORDABLE HOUSING FUND Run by Ashley King on 06/17/2016 01:53:02 PM Page 18 of 43 May-16 YTD 2015 Actual Transactions Transactions Total 9,000 2,695,756 4,921,484 - - - - - - - - - 791 3,707 3,530 9,790 2,699,463 4,925,014 - - - 150 150 1,408 - 4,473 198,823 - - 574,976 - 24,669 110,310 532,647 2,663,237 3,265,296 532,797 2,692,529 4,150,811 9,790 2,699,463 4,925,014 532,797 2,692,529 4,150,811 (523,007) 6,934 774,203 Starting Fund Balance 6,972,547 6,972,547 Net Change (2,640,683) 6,934 Ending Fund Balance 4,331,864 6,979,481 EXPENSE TOTALS 7,787,683 Fund 300 - WASHINGTON (2,640,683) EXPENSE TOTALS 7,787,683 Fund 300 - WASHINGTON REVENUE TOTALS 5,147,000 Debt Service - Miscellaneous 500,000 Interfund Transfers 6,287,683 EXPENSE Salary and Benefits - Services and Supplies 1,000,000 Capital Outlay - Other Revenue - Interest Income 2,000 REVENUE TOTALS 5,147,000 REVENUE Property Taxes 5,145,000 Other Taxes - Interfund Transfers - Budget by Organization Report Through 05/31/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 300 - WASHINGTON NATIONAL TIF FUND Run by Ashley King on 06/17/2016 01:53:02 PM Page 19 of 43 May-16 YTD 2015 Actual Transactions Transactions Total 769 287,793 422,527 - - - - - - - 2 4 769 287,795 422,531 - - - - - 297,150 - - - - - 297,150 769 287,795 422,531 - - 297,150 769 287,795 125,381 Starting Fund Balance 589,427 589,427 Net Change (467,971) 287,795 Ending Fund Balance 121,456 877,222 Fund 305 - SPECIAL SERVICE (467,971) Fund 305 - SPECIAL SERVICE REVENUE TOTALS 300 EXPENSE TOTALS 468,271 Debt Service 416,872 Miscellaneous - EXPENSE TOTALS 468,271 Interest Income 300 REVENUE TOTALS 300 EXPENSE Services and Supplies 51,399 REVENUE Property Taxes - Interfund Transfers - Other Revenue - Budget by Organization Report Through 05/31/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 305 - SPECIAL SERVICE AREA (SSA) #5 Run by Ashley King on 06/17/2016 01:53:02 PM Page 20 of 43 May-16 YTD 2015 Actual Transactions Transactions Total - 742,308 1,248,231 143 780 1,985 143 743,088 1,250,216 150 150 1,158 - 57,190 11,402 - - - - - - 129,192 129,192 2,162,381 146,038 730,188 148,010 275,379 916,719 2,322,950 143 743,088 1,250,216 275,379 916,719 2,322,950 (275,236) (173,631) (1,072,734) Starting Fund Balance 1,305,757 1,305,757 Net Change (650,450) (173,631) Ending Fund Balance 655,307 1,132,126 EXPENSE TOTALS 1,952,450 Fund 310 - HOWARD-HARTREY (650,450) EXPENSE TOTALS 1,952,450 Fund 310 - HOWARD-HARTREY REVENUE TOTALS 1,302,000 Debt Service - Miscellaneous 200,000 Interfund Transfers 1,752,450 EXPENSE Services and Supplies - Capital Outlay - Community Sponsored Organizations - REVENUE Property Taxes 1,300,000 Interest Income 2,000 REVENUE TOTALS 1,302,000 Budget by Organization Report Through 05/31/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 310 - HOWARD-HARTREY TIF Run by Ashley King on 06/17/2016 01:53:02 PM Page 21 of 43 May-16 YTD 2015 Actual Transactions Transactions Total - - - - - - - - - - - - - - - - - - - - 893,387 - - - - - 893,387 - - - - - 893,387 - - (893,387) Starting Fund Balance - - Net Change - - Ending Fund Balance - - Fund 315 - SOUTHWEST TIF - Fund 315 - SOUTHWEST TIF REVENUE TOTALS - EXPENSE TOTALS - Miscellaneous - Interfund Transfers - EXPENSE TOTALS - EXPENSE Services and Supplies - Capital Outlay - Debt Service - REVENUE Property Taxes - Interest Income - REVENUE TOTALS - Budget by Organization Report Through 05/31/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 315 - SOUTHWEST TIF FUND Run by Ashley King on 06/17/2016 01:53:02 PM Page 22 of 43 May-16 YTD 2015 Actual Transactions Transactions Total 41,312 5,530,815 11,156,231 704,389 1,164,835 1,642,654 - - 12,278,473 2,461 5,877 7,668 748,162 6,701,527 25,085,026 750 1,250 171,576 - 13,487,663 13,028,022 - - 3,062 - - - 750 13,488,913 13,202,661 748,162 6,701,527 25,085,026 750 13,488,913 13,202,661 747,412 (6,787,386) 11,882,365 Starting Fund Balance 15,697,422 15,697,422 Net Change (2,751,668) (6,787,386) Ending Fund Balance 12,945,754 8,910,036 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 13,527,784 Debt Service 15,963,682 Miscellaneous - Interfund Transfers - Interest Income 1,500 REVENUE TOTALS 13,527,784 EXPENSE Services and Supplies 315,770 REVENUE Property Taxes 10,879,993 Interfund Transfers 2,646,291 Other Revenue - Budget by Organization Report Through 05/31/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 320 - DEBT SERVICE FUND Run by Ashley King on 06/17/2016 01:53:02 PM Page 23 of 43 May-16 YTD 2015 Actual Transactions Transactions Total 3,211 296,495 540,576 3,852 48,368 64,176 36 160 1,815 7,099 345,023 606,568 452 6,883 587,839 - - (6,275) - - - 58 285 585 - - 350 5,000 25,000 107,500 5,510 32,168 689,999 7,099 345,023 606,568 5,510 32,168 689,999 1,589 312,855 (83,431) Starting Fund Balance 176,022 176,022 Net Change 24,000 312,855 Ending Fund Balance 200,022 488,877 REVENUE TOTALS 1,670,100 EXPENSE TOTALS 1,646,100 Fund 330 - HOWARD-RIDGE TIF 24,000 Interfund Transfers 107,500 EXPENSE TOTALS 1,646,100 Fund 330 - HOWARD-RIDGE TIF Community Sponsored Organizations - Debt Service 600 Miscellaneous - REVENUE TOTALS 1,670,100 EXPENSE Services and Supplies 538,000 Capital Outlay 1,000,000 REVENUE Property Taxes 550,000 Other Revenue 1,120,000 Interest Income 100 Budget by Organization Report Through 05/31/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 330 - HOWARD-RIDGE TIF FUND Run by Ashley King on 06/17/2016 01:53:02 PM Page 24 of 43 May-16 YTD 2015 Actual Transactions Transactions Total - - - 1,028 4,113 - 128 565 257 1,156 4,678 257 150 150 1,158 - (1,028) (11,205) - - - 718 3,501 7,185 - - 1,227 2,500 12,500 60,000 3,368 15,123 58,365 1,156 4,678 257 3,368 15,123 58,365 (2,211) (10,445) (58,107) Starting Fund Balance 443,490 443,490 Net Change (39,850) (10,445) Ending Fund Balance 403,640 433,045 REVENUE TOTALS 150 EXPENSE TOTALS 40,000 Fund 335 - WEST EVANSTON TIF (39,850) Interfund Transfers 30,000 EXPENSE TOTALS 40,000 Fund 335 - WEST EVANSTON TIF Contingencies - Debt Service 10,000 Miscellaneous - REVENUE TOTALS 150 EXPENSE Services and Supplies - Capital Outlay - REVENUE Property Taxes - Other Revenue - Interest Income 150 Budget by Organization Report Through 05/31/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 335 - WEST EVANSTON TIF FUND Run by Ashley King on 06/17/2016 01:53:02 PM Page 25 of 43 May-16 YTD 2015 Actual 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 - EXPENSE TOTALS 40,000 Fund 340 - DEMPSTER-DODGE 10,000 EXPENSE TOTALS 40,000 Fund 340 - DEMPSTER-DODGE REVENUE TOTALS 50,000 EXPENSE Services and Supplies - Capital Outlay - Debt Service 40,000 REVENUE Property Taxes - Other Revenue 50,000 REVENUE TOTALS 50,000 Budget by Organization Report Through 05/31/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 340 - DEMPSTER-DODGE TIF FUND Run by Ashley King on 06/17/2016 01:53:02 PM Page 26 of 43 May-16 YTD 2015 Actual Transactions Transactions Total - - - - - 900,000 - - 900,000 - - - - - 580,000 5,835 16,990 7,930 5,835 16,990 587,930 - - 900,000 5,835 16,990 587,930 (5,835) (16,990) 312,070 Starting Fund Balance 312,070 312,070 Net Change 31,500 (16,990) Ending Fund Balance 343,570 295,080 EXPENSE TOTALS 43,500 Fund 345 - CHICAGO-MAIN TIF 31,500 EXPENSE TOTALS 43,500 Fund 345 - CHICAGO-MAIN TIF REVENUE TOTALS 75,000 EXPENSE Services and Supplies - Capital Outlay - Debt Service 43,500 REVENUE Property Taxes 75,000 Other Revenue - REVENUE TOTALS 75,000 Budget by Organization Report Through 05/31/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 345 - CHICAGO-MAIN TIF Run by Ashley King on 06/17/2016 01:53:02 PM Page 27 of 43 May-16 YTD 2015 Actual Transactions Transactions Total - - - - - - - - - - - - - - - - - - - - - - - - Starting Fund Balance - - Net Change 10,500 - Ending Fund Balance 10,500 - Fund 350 - SPECIAL SERVICE 10,500 Fund 350 - SPECIAL SERVICE REVENUE TOTALS 210,500 EXPENSE TOTALS 200,000 EXPENSE Services and Supplies 200,000 EXPENSE TOTALS 200,000 REVENUE Property Taxes 210,000 Interest Income 500 REVENUE TOTALS 210,500 Budget by Organization Report Through 05/31/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 350 - SPECIAL SERVICE AREA (SSA) #6 Run by Ashley King on 06/17/2016 01:53:02 PM Page 28 of 43 May-16 YTD 2015 Actual Transactions Transactions Total 1,225 25,403 87,391 525,917 2,699,167 - 215,700 824,227 270,268 200,000 243,000 7,945,481 911 4,344 3,815 943,753 3,796,141 8,306,954 - - - 39,149 124,170 643,510 164,618 880,075 9,794,396 - - - - - 32,933 - - 490,000 203,766 1,004,245 10,960,839 943,753 3,796,141 8,306,954 203,766 1,004,245 10,960,839 739,986 2,791,896 (2,653,885) Starting Fund Balance 6,049,838 6,049,838 Net Change (2,209,000) 2,791,896 Ending Fund Balance 3,840,838 8,841,734 EXPENSE TOTALS 22,769,615 Fund 415 - CAPITAL (2,209,000) EXPENSE TOTALS 22,769,615 Fund 415 - CAPITAL REVENUE TOTALS 20,560,615 Debt Service - Miscellaneous - Interfund Transfers 490,000 EXPENSE Salary and Benefits - Services and Supplies 2,256,962 Capital Outlay 20,022,653 Other Revenue 9,248,000 Interest Income - REVENUE TOTALS 20,560,615 REVENUE Charges for Services - Interfund Transfers 6,471,000 Intergovernmental Revenue 4,841,615 Budget by Organization Report Through 05/31/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 415 - CAPITAL IMPROVEMENTS FUND Run by Ashley King on 06/17/2016 01:53:02 PM Page 29 of 43 May-16 YTD 2015 Actual Transactions Transactions Total - - - - - - - - - - - - - - - - - - - - - - - 243,113 - - - - - - - - - 412 11,196 24,832 6,026 88,727 125,218 - - - 6,438 99,923 393,163 - - - - 12 1,879 - - 226,538 - - - - - - - - 534 30,058 150,291 - 30,058 150,303 228,951 6,438 99,923 393,163 30,058 150,303 228,951 (23,620) (50,380) 164,213 Starting Fund Balance 2,682,406 2,682,406 Net Change 98,950 (50,380) Ending Fund Balance 2,781,356 2,632,026 REVENUE TOTALS 481,200 EXPENSE TOTALS 382,250 Fund 420 - SPECIAL 98,950 Interfund Transfers 382,250 EXPENSE TOTALS 382,250 Fund 420 - SPECIAL Insurance and Other Chargebacks - Debt Service - Miscellaneous - EXPENSE Salary and Benefits - Services and Supplies - Capital Outlay - Special Assessment 180,167 Reappropriation of Surplus - REVENUE TOTALS 481,200 Insurance - Library Revenue - Interest Income 51,033 Intergovernmental Revenue - Other Revenue 250,000 Workers Compensation and Liability - Fines and Forfeitures - Charges for Services - Interfund Transfers - REVENUE Property Taxes - Other Taxes - Licenses, Permits and Fees - Budget by Organization Report Through 05/31/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 420 - SPECIAL ASSESSMENT FUND Run by Ashley King on 06/17/2016 01:53:02 PM Page 30 of 43 May-16 YTD 2015 Actual Transactions Transactions Total - - - - - - 600 3,000 150 - - - 549,788 2,712,372 6,010,558 309,314 1,546,570 2,925,296 - - - 15,783 79,117 300,923 2,051 8,988 18,260 877,536 4,350,047 9,255,187 81,934 534,929 1,262,131 74,289 1,049,764 2,946,605 13,485 323,857 128,726 79,912 133,187 319,649 - - - - - 2,846,227 - 861 6,951 - - 503,423 40,634 40,634 23,687 108,649 543,243 923,092 398,904 2,626,475 8,960,489 877,536 4,350,047 9,255,187 398,904 2,626,475 8,960,489 478,632 1,723,573 294,698 Starting Fund Balance 10,512,058 10,512,058 Net Change (6,615,186) 1,723,573 Ending Fund Balance 3,896,872 12,235,631 Fund 505 - PARKING SYSTEM (6,615,186) Fund 505 - PARKING SYSTEM REVENUE TOTALS 10,322,856 EXPENSE TOTALS 16,938,042 Miscellaneous 252,000 Interfund Transfers 1,303,783 EXPENSE TOTALS 16,938,042 Depreciation Expense 2,873,395 Contingencies 11,000 Debt Service 3,917,652 Capital Outlay 3,474,000 Insurance and Other Chargebacks 319,648 Community Sponsored Organizations - REVENUE TOTALS 10,322,856 EXPENSE Salary and Benefits 1,485,289 Services and Supplies 3,301,275 Intergovernmental Revenue 12,125 Other Revenue 119,216 Interest Income 35,070 Fines and Forfeitures - Charges for Services 6,444,675 Interfund Transfers 3,711,770 REVENUE Property Taxes - Other Taxes - Licenses, Permits and Fees - Budget by Organization Report Through 05/31/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 505 - PARKING SYSTEM FUND Run by Ashley King on 06/17/2016 01:53:02 PM Page 31 of 43 May-16 YTD 2015 Actual Transactions Transactions Total 5,288 40,593 105,483 1,480,097 6,343,861 15,308,225 500,000 5,697,244 2,354,582 2,019 24,074 338,396 937 4,630 3,448 1,988,342 12,110,402 18,110,135 294,422 1,912,434 5,137,865 140,039 875,212 2,276,026 827,980 4,043,533 105 117,126 195,210 468,493 2,096,633 933 31,089 64,842 432,628 6,928 (286,678) 791,859 7,156,541 3,692,565 13,818,570 37,718,000 1,988,342 12,110,402 18,110,135 41,125,255 2,828,543 17,236,061 13,818,570 4,291,565 Starting Fund Balance 7,619,979 7,619,979 Net Change (3,407,255)(5,125,659) Ending Fund Balance 4,212,724 2,494,320 2,828,543 17,236,061 (840,201)(5,125,659) EXPENSE TOTALS Fund 510 - WATER FUND Totals (3,407,255) EXPENSE TOTALS 41,125,255 Fund 510 - WATER FUND Totals REVENUE TOTALS Debt Service 1,053,288 Miscellaneous 62,980 Interfund Transfers 3,502,313 Community Sponsored Organizations Depreciation Expense Contingencies 1,000 Services and Supplies 6,155,950 Capital Outlay 24,776,106 Insurance and Other Chargebacks 468,492 Interest Income 1,600 REVENUE TOTALS 37,718,000 EXPENSE Salary and Benefits 5,105,126 Interfund Transfers Intergovernmental Revenue Other Revenue 22,348,400 REVENUE Other Taxes Licenses, Permits and Fees 70,000 Charges for Services 15,298,000 Budget by Organization Report Through 05/31/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 510 - WATER FUND Run by Ashley King on 06/17/2016 01:53:02 PM Page 32 of 43 May-16 YTD 2015 Actual Transactions Transactions Total 1,007,757 5,156,019 12,510,940 - - - - - 12,521 525 2,233 2,706 1,008,281 5,158,252 12,526,166 58,703 444,282 1,163,371 143,194 151,863 109,052 554,863 660,126 13,609 88,455 217,284 269,988 - - 3,443,723 - - - 1,024,321 3,701,614 1,550,407 - 5,000 3,306 43,532 217,658 735,235 1,913,067 5,397,828 7,288,691 1,008,281 5,158,252 12,526,166 1,913,067 5,397,828 7,288,691 (904,786) (239,576) 5,237,476 Starting Fund Balance 4,420,037 4,420,037 Net Change (1,607,486) (239,576) Ending Fund Balance 2,812,551 4,180,461 Fund 515 - SEWER FUND Totals (1,607,486) Fund 515 - SEWER FUND Totals REVENUE TOTALS 13,873,815 EXPENSE TOTALS 15,481,301 Miscellaneous 1,500 Interfund Transfers 773,876 EXPENSE TOTALS 15,481,301 Depreciation Expense - Contingencies - Debt Service 9,222,913 Services and Supplies 995,800 Capital Outlay 3,048,314 Insurance and Other Chargebacks 269,988 Interest Income 1,000 REVENUE TOTALS 13,873,815 EXPENSE Salary and Benefits 1,168,910 REVENUE Charges for Services 12,888,650 Interfund Transfers - Other Revenue 984,165 Budget by Organization Report Through 05/31/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 515 - SEWER FUND Run by Ashley King on 06/17/2016 01:53:02 PM Page 34 of 43 May-16 YTD 2015 Actual Transactions Transactions Total - 40,031 213,490 283,436 1,466,118 3,561,584 87,997 439,986 1,055,967 - - - 13,776 38,034 228,469 - - - 385,209 1,984,169 5,059,510 49,746 319,540 934,097 857,237 1,385,390 3,717,885 2,450 2,534 24,738 - - - - - - - - - - - - - - 68,394 - - - 41,624 208,122 490,106 951,058 1,915,586 5,235,220 385,209 1,984,169 5,059,510 951,058 1,915,586 5,235,220 (565,848) 68,584 (175,710) Starting Fund Balance (1,034,768) (1,034,768) Net Change 60,844 68,584 Ending Fund Balance (973,924) (966,184) Fund 520 - SOLID WASTE FUND 60,844 Fund 520 - SOLID WASTE FUND REVENUE TOTALS 5,201,361 EXPENSE TOTALS 5,140,517 Miscellaneous 15,000 Interfund Transfers 499,493 EXPENSE TOTALS 5,140,517 Depreciation Expense - Contingencies - Debt Service - Capital Outlay 25,750 Insurance and Other Chargebacks - Community Sponsored Organizations - REVENUE TOTALS 5,201,361 EXPENSE Salary and Benefits 868,098 Services and Supplies 3,732,176 Intergovernmental Revenue - Other Revenue 238,000 Interest Income - REVENUE Licenses, Permits and Fees 275,000 Charges for Services 3,632,394 Interfund Transfers 1,055,967 Budget by Organization Report Through 05/31/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 520 - SOLID WASTE FUND Run by Ashley King on 06/17/2016 01:53:02 PM Page 35 of 43 May-16 YTD 2015 Actual Transactions Transactions Total 282,301 1,411,573 3,289,009 - - - - - - 1,514 5,006 46,933 - - - 283,815 1,416,579 3,335,942 54,373 375,299 1,137,603 137,387 463,779 1,686,117 - - - 2,230 11,151 25,820 - - 105 - - - - - - - - - - - - 193,991 850,229 2,849,644 283,815 1,416,579 3,335,942 193,991 850,229 2,849,644 89,824 566,351 486,298 Starting Fund Balance 273,458 273,458 Net Change (244,277) 566,351 Ending Fund Balance 29,181 839,809 EXPENSE TOTALS 3,644,146 Fund 600 - FLEET SERVICES (244,277) EXPENSE TOTALS 3,644,146 Fund 600 - FLEET SERVICES REVENUE TOTALS 3,399,869 Debt Service - Miscellaneous - Interfund Transfers - Insurance and Other Chargebacks 26,762 Depreciation Expense - Contingencies 450 EXPENSE Salary and Benefits 1,236,877 Services and Supplies 2,380,057 Capital Outlay - Other Revenue 81,781 Interest Income 1,000 REVENUE TOTALS 3,399,869 REVENUE Charges for Services 3,317,088 Interfund Transfers - Intergovernmental Revenue - Budget by Organization Report Through 05/31/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 600 - FLEET SERVICES FUND Run by Ashley King on 06/17/2016 01:53:02 PM Page 36 of 43 May-16 YTD 2015 Actual Transactions Transactions Total 121,255 606,385 1,451,422 - - - - 11,951 34,286 121,255 618,336 1,485,708 2,908 3,326 53,400 1,537 4,759 - - - 1,684,835 - - - 4,445 8,084 1,738,234 121,255 618,336 1,485,708 4,445 8,084 1,738,234 116,810 610,252 (252,527) Starting Fund Balance 1,899,429 1,899,429 Net Change 146,216 610,252 Ending Fund Balance 2,045,645 2,509,681 Fund 601 - EQUIPMENT 146,216 Fund 601 - EQUIPMENT REVENUE TOTALS 1,661,638 EXPENSE TOTALS 1,515,422 Depreciation Expense - Miscellaneous - EXPENSE TOTALS 1,515,422 REVENUE TOTALS 1,661,638 EXPENSE Services and Supplies 60,000 Capital Outlay 1,455,422 REVENUE Charges for Services 1,451,421 Interfund Transfers - Other Revenue 210,217 Budget by Organization Report Through 05/31/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 601 - EQUIPMENT REPLACEMENT FUND Run by Ashley King on 06/17/2016 01:53:02 PM Page 37 of 43 May-16 YTD 2015 Actual Transactions Transactions Total 10,069 16,860 162,411 205 342 306,051 (834,243) 4,118,763 10,413,499 18,796 59,014 1,034,405 913,002 2,560,423 5,753,308 22 90 136 107,851 6,755,491 17,669,810 49,388 245,279 516,469 45,638 953,661 1,305,086 - - - 1,146,237 5,890,881 14,301,173 - - - - - - - - - - - - - 4,330 - - - - 1,241,263 7,094,151 16,122,728 107,851 6,755,491 17,669,810 1,241,263 7,094,151 16,122,728 (1,133,411) (338,659) 1,547,082 Starting Fund Balance (3,954,618) (3,954,618) Net Change 565,405 (338,659) Ending Fund Balance (3,389,213) (4,293,277) Fund 605 - INSURANCE FUND 565,405 Fund 605 - INSURANCE FUND REVENUE TOTALS 17,758,038 EXPENSE TOTALS 17,192,633 Miscellaneous - Interfund Transfers - EXPENSE TOTALS 17,192,633 Depreciation Expense - Contingencies - Debt Service - Capital Outlay - Insurance and Other Chargebacks 15,328,062 Community Sponsored Organizations - REVENUE TOTALS 17,758,038 EXPENSE Salary and Benefits 479,323 Services and Supplies 1,385,248 Workers Compensation and Liability 1,023,094 Insurance 6,459,839 Interest Income 1,000 REVENUE Charges for Services 162,411 Interfund Transfers - Other Revenue 10,111,694 Budget by Organization Report Through 05/31/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 605 - INSURANCE FUND Run by Ashley King on 06/17/2016 01:53:02 PM Page 38 of 43 May-16 YTD 2015 Actual Transactions Transactions Total 27,944 3,394,080 7,106,772 - 50,995 280,000 - - - 75,655 364,396 1,009,930 3 45 319,811 103,602 3,809,516 8,716,512 699,339 3,501,599 8,302,220 - - - - - - - - - - - - 699,339 3,501,599 8,302,220 103,602 3,809,516 8,716,512 699,339 3,501,599 8,302,220 (595,737) 307,917 414,293 Starting Fund Balance 68,529,102 68,529,102 Net Change 4,297,865 307,917 Ending Fund Balance 72,826,967 68,837,019 Fund 700 - FIRE PENSION FUND 4,297,865 Fund 700 - FIRE PENSION FUND REVENUE TOTALS 12,460,865 EXPENSE TOTALS 8,163,000 Debt Service - Miscellaneous - EXPENSE TOTALS 8,163,000 EXPENSE Salary and Benefits 8,163,000 Services and Supplies - Community Sponsored Organizations - Other Revenue 1,010,000 Interest Income 4,100,000 REVENUE TOTALS 12,460,865 REVENUE Property Taxes 7,070,865 Other Taxes 280,000 Interfund Transfers - Budget by Organization Report Through 05/31/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 700 - FIRE PENSION FUND Run by Ashley King on 06/17/2016 01:53:02 PM Page 39 of 43 May-16 YTD 2015 Actual Transactions Transactions Total 35,707 4,684,345 9,097,160 - 50,995 325,000 - - - 112,557 556,771 1,454,770 4 49 734,309 148,269 5,292,160 11,611,239 907,519 4,546,014 10,768,296 - - - - - - - - - 907,519 4,546,014 10,768,296 148,269 5,292,160 11,611,239 907,519 4,546,014 10,768,296 (759,250) 746,146 842,942 Starting Fund Balance 102,150,249 102,150,249 Net Change 68,529,102 746,146 Ending Fund Balance 170,679,351 102,896,395 REVENUE TOTALS 17,430,940 EXPENSE TOTALS 11,047,000 Fund 705 - POLICE PENSION 6,383,940 Miscellaneous - EXPENSE TOTALS 11,047,000 Fund 705 - POLICE PENSION EXPENSE Salary and Benefits 11,047,000 Services and Supplies - Debt Service - Other Revenue 1,550,000 Interest Income 6,500,000 REVENUE TOTALS 17,430,940 REVENUE Property Taxes 9,055,940 Other Taxes 325,000 Interfund Transfers - Budget by Organization Report Through 05/31/16 Prior Fiscal Year Activity Included Detail Listing 2016 Classification Budget Fund 705 - POLICE PENSION FUND Run by Ashley King on 06/17/2016 01:53:02 PM Page 41 of 43