Loading...
HomeMy WebLinkAbout2016.08 August Monthly Report To: Wally Bobkiewicz, City Manager Martin Lyons, Assistant City Manager/Chief Financial Officer From: Ashley King, Finance Division Manager Subject: August 2016 Monthly Financial Report Date: September 30, 2016 Please find attached the unaudited financial statements as of August 31, 2016. A summary by fund for revenues, expenditures, fund and cash balances is as follows: YTD Revenues YTD Expenses YTD Net Fund Balance Cash Balance 81,911,649 74,941,359 6,970,290 17,674,579 10,473,240 589,863 438,754 151,109 151,109 186,514 843,668 528,691 314,977 828,216 829,959 333,333 (333,333)(333,333)666,667 6,298,623 4,158,077 2,140,546 2,294,417 2,810,129 36,422 64,176 (27,754)(27,754)149,605 1,253,509 1,615,866 (362,358)1,468,035 1,325,673 537,754 862,938 (325,184)226,534 51,819 318,364 161,500 156,864 (33,680)(33,680) 614,846 674,785 (59,939)(57)(56) 74,330 121,732 (47,402)110,963 164,488 1,734,631 1,450,779 283,852 2,839,834 2,505,146 169,915 169,915 142,130 143,412 (1,282)3,488 3,488 223,851 111,549 112,302 1,106,182 1,041,337 360,944 72,675 288,270 324,934 174,481 4,687,755 2,761,872 1,925,882 8,368,312 8,447,231 287,860 17,250 270,610 796,039 796,039 1,235,080 1,604,222 (369,142)911,973 973,044 616,151 356,552 259,599 259,599 233,247 8,241 24,911 (16,671)425,592 433,914 580,000 608,506 (28,506)283,564 283,564 12,099,577 4,162,227 7,937,350 10,533,466 10,548,262 219,528 219,528 219,528 219,528 4,510,206 2,755,469 1,754,738 7,271,779 7,996,635 144,881 240,477 (95,597)2,587,184 2,583,647 7,398,972 4,967,772 2,431,200 13,209,074 12,752,840 18,185,418 20,313,308 (2,127,890)7,095,313 4,524,011 9,474,772 7,238,707 2,236,066 6,248,874 3,714,612 3,219,328 3,016,884 202,443 (1,026,114)(1,544,614) 2,267,053 1,663,174 603,879 969,339 295,260 1,001,588 22,102 979,485 2,257,174 1,862,103 10,953,264 11,519,759 (566,495)(930,991)1,854,960 171,830,254 146,952,816 24,877,438 86,283,089 76,493,008 601 EQUIPMENT REPLACEMENT FUND 605 INSURANCE FUND 515 SEWER FUND 520 SOLID WASTE FUND 600 FLEET SERVICES FUND 505 PARKING SYSTEM FUND 510 WATER FUND 415 CAPITAL IMPROVEMENTS FUND 420 SPECIAL ASSESSMENT FUND 320 DEBT SERVICE FUND 350 SSA #6 335 WEST EVANSTON TIF FUND 345 CHICAGO-MAIN TIF 315 SOUTHWEST TIF FUND 330 HOWARD-RIDGE TIF FUND 300 WASHINGTON NATIONAL TIF 305 SPECIAL SERVICE AREA (SSA) #5 310 HOWARD-HARTREY TIF 250 AFFORDABLE HOUSING FUND 186 LIBRARY DEBT SERVICE FUND 235 NEIGHBORHOOD IMPROV 240 HOME FUND 215 CDBG FUND 220 CDBG LOAN 225 ECONOMIC DEVELOPMENT FUND 200 MOTOR FUEL TAX FUND 205 EMERGENCY TELEPHONE (E911) 210 SPECIAL SERVICE AREA (SSA) #4 185 LIBRARY FUND 195 NSP2 176 HEALTH AND HUMAN SERVICES 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, & Solid Waste Fund) reflect internal account balances and not external bank balances, due to transaction timing at month end. Also note that monthly fund balance is calculated as ending 2015 audited fund balance + YTD Net without other balance sheet adjustments. Memorandum Included above are the ending balances as of August 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 August be used (or easily sold) to support and fund current operat ions. 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 August 31, 2016, the General Fund is reporting a net surplus of $6,970,290. The attached supplemental charts show the General Fund Revenues at 73.0% of budget and expenses lower at 67.01%. The August target is 66.7%. General Fund revenues include the $2.9 million permit from Northwestern as well as pension property taxes. General Fund Expenses are just above budget year -to-date due to the pension payments being totally paid for the year as of August 31, 2016. The net surplus is anticipated to be mitigated by the 3 payrolls in December. Parks and Recreation seasonal expenses will continue to show up in reports through September. Through August 31, 2016, the SSA #4 Fund is showing a negative cash balance of $33,680 due to the timing of payments to the Downtown Evanston group and receipt of property taxes. Through August 31, 2016, the CDBG Fund is showing a negative cash balance of $56 which will be reimbursed from August draw-downs. Through August 31, 2016, the Economic Development Fund is showing a fund balance of $2,839,834 and a cash balance of $2,505,146. 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 th e 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 August 31, 2016, the enterprise funds (Parking, Water, and Sewer) have balances above average. As construction season continues, the balances in all three of these funds will be reduced. Through August 31, 2016, the Solid Waste Fund has a negative fund balance of $1,026,114 and a negative cash balance of $1,544,614. Through August 31, 2016, the Insurance Fund is showing a negative fund balance of $930,991 with a cash balance of $1,854,960. If there are any questions on the attached report, please contact me by phone at (847) 859-7884 or by email: aking@cityofevanston.org. Detailed fund summary reports can be found at the following link: http://www.cityofevanston.org/city-budget/financial- reports/. Fund   100 - GENERAL FUND 2016 Budget Aug Actual YTD Actual % 2015 Actual 27,417,407 2,948,260 26,719,635 97.46% 25,915,970 45,986,550 3,815,831 28,507,823 61.99% 44,978,985 5,329,777 439,332 2,327,777 43.67% 5,324,137 9,276,550 565,142 9,597,351 103.46% 6,704,846 125,700 1,330 44,104 35.09% 155,619 4,609,825 297,186 2,233,804 48.46% 3,548,230 640,000 6,695 6,695 1.05% 640,000 5,374,751 494,452 4,603,092 85.64% 5,406,379 2,433,216 190,626 1,646,050 67.65% 2,239,528 8,842,365 646,242 5,169,934 58.47% 7,836,484 765,727 66,052 476,154 62.18% 670,245 1,286,843 74,555 563,259 43.77% 894,703 50,000 2,739 15,971 31.94% 6,572 112,138,711 9,548,441 81,911,649 73.04% 104,321,698 424,958 32,849 278,956 65.64% 419,962 263,203 20,853 190,859 72.51% 283,764 6,989,746 441,431 3,947,365 56.47% 1,814,469 1,130,000 79,390 659,459 58.36% 1,051,325 9,634,173 658,644 5,487,142 56.95% 9,763,951 2,782,897 193,612 1,589,569 57.12% 2,425,618 37,696,278 2,169,323 26,979,255 71.57% 37,239,961 22,601,742 1,178,406 17,073,983 75.54% 21,331,507 3,610,779 233,326 2,029,874 56.22% 3,212,848 - 5,286 - #DIV/0! 18,148,755 11,845,590 1,313,542 7,800,064 65.85% 11,180,116 14,861,248 1,136,235 8,904,834 59.92% - 111,840,614 7,462,897 74,941,359 67.01% 106,872,275 112,138,711 9,548,441 81,911,649 59% 104,321,698 111,840,614 7,462,897 74,941,359 53% 106,872,275 298,097 2,085,544 6,970,290 2,338% (2,550,577) REVENUE TOTALS EXPENSE TOTALS Fund   100 - GENERAL FUND Net Gain   24 - HEALTH   26 - PUBLIC WORKS   30 - PARKS, REC. AND COMMUNITY   40 - PUBLIC WORKS AGENCY EXPENSE TOTAL Fund   100 - GENERAL FUND Totals   15 - CITY MANAGER'S OFFICE   17 - LAW   19 - ADMINISTRATIVE SERVICES   21 - COMMUNITY DEVELOPMENT   22 - POLICE   23 - FIRE MGMT & SUPPORT Interest Income REVENUE TOTAL EXPENSE   13 - CITY COUNCIL   14 - CITY CLERK 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 08/31/16 Summary Listing Classification Fund   505 - PARKING SYSTEM FUND 2016 Budget Aug Actual YTD Actual % 2015 Actual - - 3,000 +++ 150 6,379,675 768,932 4,620,146 72.42% 6,010,558 65,000 - 168,500 259.23% - 3,711,770 309,314 2,474,512 66.67% 2,925,296 12,125 - - 0.00% - 119,216 9,577 114,643 96.16% 153,545 35,070 3,207 18,171 51.81% 18,260 10,322,856 1,091,031 7,398,972 71.68% 9,107,809 23,000 343 16,455 71.54% 29,187 1,160,688 77,551 709,065 61.09% 966,953 113,349 7,523 67,553 59.60% (33,034) 3,022,411 232,094 1,942,316 64.26% 2,616,554 278,864 12,829 127,104 45.58% 243,068 3,474,000 93,415 535,986 15.43% 128,726 507,900 42,154 329,860 64.95% 478,187 2,873,395 - - 0.00% 2,846,227 11,000 438 3,411 31.01% 6,951 3,917,652 - 199,979 5.10% 503,423 252,000 105,649 166,852 66.21% 23,687 1,303,783 108,649 869,189 66.67% 923,092 16,938,042 680,645 4,967,772 29.33% 8,733,020 10,322,856 1,091,031 7,398,972 72% 9,107,809 16,938,042 680,645 4,967,772 29% 8,733,020 (6,615,186) 410,386 2,431,200 374,789 EXPENSE TOTALS Fund   505 - PARKING SYSTEM FUND Net Miscellaneous Interfund Transfers EXPENSE TOTAL Fund   505 - PARKING SYSTEM FUND 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 08/31/16 Summary Listing Classification Fund   510 - WATER FUND 2016 Budget Aug Actual YTD Actual % 2015 Actual 70,000 5,525 65,202 93 105,483 15,133,000 372,799 10,873,242 72 15,141,770 39,000 4,612 29,922 77 40,911 126,000 - 134,330 107 125,545 - 300,000 6,997,244 +++ 2,354,582 22,348,400 (3,353) 75,989 0 350,065 1,600 1,781 9,489 574 3,448 37,718,000 681,365 18,185,419 ### 18,121,804 210,465 14,466 119,191 57 157,679 3,888,603 295,774 2,508,448 65 3,884,943 360,355 29,796 250,286 69 (114,870) 2,098,760 137,049 944,543 35 1,250,874 1,392,190 67,948 534,840 38 1,048,119 75,800 638,101 5,506,830 144 105 1,114,195 91,165 732,333 66 1,131,508 - - - +++ 2,096,633 1,000 - 658 66 933 1,053,288 - 373,518 35 432,628 62,980 - 10,543 17 (286,678) 3,502,313 591,859 9,332,119 266 3,692,565 13,759,949 1,866,158 20,313,308 ### 13,294,439 37,718,000 681,365 18,185,419 30% 18,121,804 13,759,949 1,866,158 20,313,308 107% 13,294,439 23,958,051 (1,184,793) (2,127,890)(15%) 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 Interest Income REVENUE TOTAL Employee Pay Benefits Pensions Fee Water Charges for Services Sewer Charges for Services Other Charges for Services Interfund Transfers Other Revenue Income Statement Through 08/31/16 Summary Listing Classification Fund   515 - SEWER FUND 2016 Budget Aug Actual YTD Actual % 2015 Actual 12,869,000 1,511,204 8,917,089 69.29% 12,491,290 19,650 - - 0.00% 19,650 984,165 - 554,863 56.38% 2,962 1,000 169 2,820 #### 2,706 13,873,815 1,511,373 9,474,772 68.29% 12,516,607 57,040 3,745 24,938 43.72% 60,837 881,327 60,221 566,872 64.32% 858,361 86,092 6,169 55,135 64.04% (27,099) 903,500 28,332 233,904 25.89% 90,109 92,300 6,502 24,001 26.00% 18,817 3,048,314 60,043 723,144 23.72% 13,609 414,439 34,033 272,372 65.72% 412,461 - - - #DIV/0! 3,443,723 9,222,913 205,395 4,817,425 52.23% 1,550,407 1,500 - 5,000 #### 3,306 773,876 85,447 515,915 66.67% 735,235 15,481,301 489,887 7,238,707 46.76% 7,159,766 13,873,815 1,511,373 9,474,772 68% 12,516,607 15,481,301 489,887 7,238,707 47% 7,159,766 (1,607,486) 1,021,487 2,236,066 5,356,842 Fund   515 - SEWER FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund   515 - SEWER FUND Net Gain Insurance and Other Chargebacks Depreciation Expense Debt Service Miscellaneous Interfund Transfers EXPENSE TOTAL Employee Pay Benefits Pensions Services Supplies Capital Outlay Sewer Charges for Services Other Charges for Services Other Revenue Interest Income REVENUE TOTAL Income Statement Through 08/31/16 Summary Listing Classification Fund   520 - SOLID WASTE FUND 2016 Budget Aug Actual YTD Actual % 2015 Actual 275,000 - 81,934 29.79% 213,490 3,632,394 305,793 2,371,390 65.28% 3,561,584 1,055,967 87,997 703,978 66.67% 1,055,967 238,000 11,935 62,025 26.06% 228,469 5,201,361 405,726 3,219,328 61.89% 5,059,510 25,000 658 28,373 113.49% 41,358 649,690 50,493 399,255 61.45% 574,692 63,718 4,890 40,796 64.03% (15,981) 3,679,126 315,898 2,073,215 56.35% 3,644,097 53,050 6,210 36,537 68.87% 73,788 25,750 - 2,664 10.35% 24,738 129,690 11,805 89,673 69.14% 249,232 - - 1,144 #DIV/0! 68,419 15,000 - 12,232 81.55% - 499,493 41,624 332,995 66.67% 490,106 5,140,517 431,579 3,016,884 58.69% 5,150,448 5,201,361 405,726 3,219,328 62% 5,059,510 5,140,517 431,579 3,016,884 59% 5,150,448 60,844 (25,853) 202,443 (90,938) Fund   520 - SOLID WASTE FUND Totals REVENUE TOTALS EXPENSE TOTALS Fund   520 - SOLID WASTE FUND Net Gain Insurance and Other Chargebacks Debt Service Miscellaneous Interfund Transfers EXPENSE TOTAL Employee Pay Benefits Pensions Services Supplies Capital Outlay License Other Charges for Services Interfund Transfers Other Revenue REVENUE TOTAL Income Statement Through 08/31/16 Summary Listing Classification August YTD 2016 2015 2016 Actual Actual 2,948,260 26,719,635 25,915,970 3,815,831 28,507,823 44,978,985 1,005,804 11,969,232 12,184,602 297,186 2,233,804 3,548,230 691,773 6,255,837 8,285,907 646,242 5,169,934 7,836,484 66,052 476,154 670,245 74,555 563,259 894,703 - - - - - - - - - 2,739 15,971 6,572 - - - - - - 9,548,441 81,911,649 104,321,698 4,644,862 39,045,996 60,215,578 1,090,477 6,702,938 11,506,401 4,485 89,972 155,975 897,602 7,034,495 10,846,854 74,362 571,639 952,678 - - - 695 50,784 30,529 - - - 125,683 1,044,065 17,171,181 624,731 20,402,015 5,993,080 7,462,897 74,941,905 106,872,275 9,548,441 81,911,649 104,321,698 7,462,897 74,941,905 106,872,275 2,085,544 6,969,743 (2,550,577) Starting Fund Balance 10,704,836 10,704,836 Net Change (567,485) 6,969,743 Ending Fund Balance 10,137,351 17,674,579 Monthly Financial Report Through 08/31/16 Prior Fiscal Year Activity Included2016 Classification Budget Fund 100 - GENERAL FUND REVENUE Property Taxes 27,417,407 Other Taxes 45,986,550 Licenses, Permits and Fees 14,732,027 Fines and Forfeitures 4,609,825 Charges for Services 8,447,967 Interfund Transfers 8,842,365 Intergovernmental Revenue 765,727 Other Revenue 1,286,843 Workers Compensation and Liability - Insurance - Library Revenue - Interest Income 50,000 Special Assessment - Reappropriation of Surplus - REVENUE TOTALS 112,138,711 EXPENSE Salary and Benefits 62,388,836 Services and Supplies 11,834,924 Capital Outlay 200,600 Insurance and Other Chargebacks 28,210,185 Community Sponsored Organizations 925,029 Depreciation Expense - Contingencies 213,505 Debt Service - Miscellaneous 1,679,285 Interfund Transfers 7,253,832 EXPENSE TOTALS 112,706,196 Fund 100 - GENERAL FUND Totals REVENUE TOTALS 112,138,711 EXPENSE TOTALS 112,706,196 Fund 100 - GENERAL FUND Totals (567,485) Run by Ashley King on 09/28/2016 02:51:28 PM Page 1 of 49 August YTD 2016 2015 2016 Actual Actual 238,988 807,012 1,313,420 - - - - - - - - - - - - - - - - - 3,208 300 36,335 19,534 - - - - - - - - - 88 321 62 - - - - - - 239,377 843,668 1,336,224 21,037 157,790 166,822 48,049 351,939 592,645 - - - 2,449 14,701 18,609 - - - - - - - - - - - - 24 4,261 4,625 - - - 71,559 528,691 782,701 239,377 843,668 1,336,224 71,559 528,691 782,701 167,817 314,977 553,522 Starting Fund Balance 513,239 513,239 Net Change 38,167 314,977 Ending Fund Balance 551,406 828,216 Monthly Financial Report Through 08/31/16 Prior Fiscal Year Activity Included2016 Classification Budget Fund 175 - GENERAL ASSISTANCE FUND REVENUE Property Taxes 1,000,000 Other Taxes - Licenses, Permits and Fees - Fines and Forfeitures - Charges for Services - Interfund Transfers - Intergovernmental Revenue - Other Revenue 25,000 Workers Compensation and Liability - Insurance - Library Revenue - Interest Income 1,000 Special Assessment - Reappropriation of Surplus - REVENUE TOTALS 1,026,000 EXPENSE Salary and Benefits 200,704 Services and Supplies 758,900 Capital Outlay - Insurance and Other Chargebacks 21,229 Community Sponsored Organizations - Depreciation Expense - Contingencies - Debt Service - Miscellaneous 7,000 Interfund Transfers - EXPENSE TOTALS 987,833 Fund 175 - GENERAL ASSISTANCE REVENUE TOTALS 1,026,000 EXPENSE TOTALS 987,833 Fund 175 - GENERAL ASSISTANCE 38,167 Run by Ashley King on 09/28/2016 02:51:28 PM Page 3 of 49 August YTD 2016 2015 2016 Actual Actual - - - 73,733 589,863 884,794 - - - - - - 73,733 589,863 884,794 - - - - - - 15,000 438,754 849,388 - - - 15,000 438,754 849,388 73,733 589,863 884,794 15,000 438,754 849,388 58,733 151,109 35,406 Starting Fund Balance - - Net Change 25,641 151,109 Ending Fund Balance 25,641 151,109 Monthly Financial Report Through 08/31/16 Prior Fiscal Year Activity Included2016 Classification Budget Fund 176 - HEALTH AND HUMAN SERVICES REVENUE Charges for Services - Interfund Transfers 884,794 Intergovernmental Revenue - Other Revenue - REVENUE TOTALS 884,794 EXPENSE Services and Supplies - 884,794 Capital Outlay - Community Sponsored Organizations 859,153 Miscellaneous - EXPENSE TOTALS 859,153 Fund 176 - HEALTH AND HUMAN 25,641 EXPENSE TOTALS 859,153 Fund 176 - HEALTH AND HUMAN REVENUE TOTALS Run by Ashley King on 09/28/2016 02:51:28 PM Page 4 of 49 August YTD 2016 2015 2016 Actual Actual - - - - - - 41,667 333,333 - 41,667 333,333 - - - - 41,667 333,333 - (41,667) (333,333) - Starting Fund Balance - - Net Change - (333,333) Ending Fund Balance - (333,333) Monthly Financial Report Through 08/31/16 Prior Fiscal Year Activity Included2016 Classification Budget Fund 180 - GOOD NEIGHBOR FUND REVENUE Other Revenue 1,000,000 REVENUE TOTALS 1,000,000 EXPENSE Interfund Transfers 1,000,000 EXPENSE TOTALS 1,000,000 Fund 180 - GOOD NEIGHBOR FUND REVENUE TOTALS 1,000,000 EXPENSE TOTALS 1,000,000 Fund 180 - GOOD NEIGHBOR FUND - Run by Ashley King on 09/28/2016 02:51:28 PM Page 5 of 49 August YTD 2016 2015 2016 Actual Actual 1,775,294 5,997,300 5,916,852 - - 46,059 13,741 95,668 129,808 - - 171,000 3,000 60,418 181,283 3,749 30,322 286 12,707 111,741 315,924 165 3,174 2,683 1,808,657 6,298,623 6,763,897 316,030 2,722,904 4,062,199 81,316 909,370 1,425,484 - 37,599 299,628 33,547 261,355 810,678 - - - - - - - - - 20,833 166,667 250,000 14,197 60,181 81,468 465,923 4,158,077 6,929,456 1,808,657 6,298,623 6,763,897 465,923 4,158,077 6,929,456 1,342,734 2,140,546 (165,560) Starting Fund Balance 153,871 153,871 Net Change 20,015 2,140,546 Ending Fund Balance 173,886 2,294,417 Monthly Financial Report Through 08/31/16 Prior Fiscal Year Activity Included2016 Classification Budget Fund 185 - LIBRARY FUND REVENUE Property Taxes 6,104,180 Other Taxes 50,200 Fines and Forfeitures 160,000 Interfund Transfers 185,800 Intergovernmental Revenue 94,177 Other Revenue 87,500 Library Revenue 333,300 Interest Income 2,000 REVENUE TOTALS 7,017,157 EXPENSE Salary and Benefits 4,289,180 Services and Supplies 1,872,573 Capital Outlay 32,800 Insurance and Other Chargebacks 462,317 Depreciation Expense - Contingencies - 7,017,157 Debt Service - Miscellaneous 250,000 Interfund Transfers 90,272 EXPENSE TOTALS 6,997,142 Fund 185 - LIBRARY FUND Totals 20,015 EXPENSE TOTALS 6,997,142 Fund 185 - LIBRARY FUND Totals REVENUE TOTALS Run by Ashley King on 09/28/2016 02:51:28 PM Page 6 of 49 August YTD 2016 2015 2016 Actual Actual 107,900 360,944 601,811 - - - - - - 107,900 360,944 601,811 - - - - 41,447 - - 31,228 562,740 - - - - 72,675 562,740 107,900 360,944 601,811 - 72,675 562,740 107,900 288,270 39,072 Starting Fund Balance 36,664 36,664 Net Change - 288,270 Ending Fund Balance 36,664 324,934 Monthly Financial Report Through 08/31/16 Prior Fiscal Year Activity Included2016 Classification Budget Fund 186 - LIBRARY DEBT SERVICE FUND REVENUE Property Taxes 393,409 Other Revenue - Interest Income - REVENUE TOTALS 393,409 EXPENSE Services and Supplies - Capital Outlay - Debt Service 393,409 Miscellaneous - EXPENSE TOTALS 393,409 Fund 186 - LIBRARY DEBT SERVICE - Fund 186 - LIBRARY DEBT SERVICE REVENUE TOTALS 393,409 EXPENSE TOTALS 393,409 Run by Ashley King on 09/28/2016 02:51:28 PM Page 7 of 49 August YTD 2016 2015 2016 Actual Actual - - - 31,412 36,275 130,126 - - - 11 147 - 31,423 36,422 130,126 1,688 14,536 54,159 3,000 6,060 4,611 31,412 36,275 68,352 344 2,704 6,847 - - - - 1,705 179 724 2,896 (4,022) 37,168 64,176 130,126 31,423 36,422 130,126 37,168 64,176 130,126 (5,745) (27,754) - Starting Fund Balance - - Net Change (303) (27,754) Ending Fund Balance (303) (27,754) Monthly Financial Report Through 08/31/16 Prior Fiscal Year Activity Included2016 Classification Budget Fund 195 - NEIGHBORHOOD STABILIZATION FUND REVENUE Licenses, Permits and Fees - Intergovernmental Revenue 198,651 Other Revenue - Interest Income - REVENUE TOTALS 198,651 EXPENSE Salary and Benefits 28,590 Services and Supplies 5,100 Capital Outlay 35,000 Insurance and Other Chargebacks 5,058 198,651 Debt Service - Miscellaneous 120,862 Interfund Transfers 4,344 EXPENSE TOTALS 198,954 Fund 195 - NEIGHBORHOOD (303) EXPENSE TOTALS 198,954 Fund 195 - NEIGHBORHOOD REVENUE TOTALS Run by Ashley King on 09/28/2016 02:51:28 PM Page 8 of 49 August YTD 2016 2015 2016 Actual Actual 170,414 1,249,310 2,465,781 - - - 610 4,198 819 - - - 171,024 1,253,509 2,466,600 - - - 50,000 156,533 1,583,238 - - - - - - - - - 182,417 1,459,333 833,000 232,417 1,615,866 2,416,238 171,024 1,253,509 2,466,600 232,417 1,615,866 2,416,238 (61,392) (362,358) 50,362 Starting Fund Balance 1,830,393 1,830,393 Net Change (478,000) (362,358) Ending Fund Balance 1,352,393 1,468,035 Monthly Financial Report Through 08/31/16 Prior Fiscal Year Activity Included2016 Classification Budget Fund 200 - MOTOR FUEL TAX FUND REVENUE Intergovernmental Revenue 1,710,000 Other Revenue - Interest Income 1,000 Reappropriation of Surplus - REVENUE TOTALS 1,711,000 EXPENSE Services and Supplies - Capital Outlay - Contingencies - Debt Service - Miscellaneous - Interfund Transfers 2,189,000 EXPENSE TOTALS 2,189,000 Fund 200 - MOTOR FUEL TAX FUND (478,000) Fund 200 - MOTOR FUEL TAX FUND REVENUE TOTALS 1,711,000 EXPENSE TOTALS 2,189,000 Run by Ashley King on 09/28/2016 02:51:28 PM Page 9 of 49 August YTD 2016 2015 2016 Actual Actual 82,877 536,192 977,071 - - - - - 100 245 1,562 189 83,121 537,754 977,361 39,664 328,713 505,437 387 212,087 347,694 - 165,100 239,421 7,891 62,233 96,132 - - - - - 2,046 - - - - - 1,500 12,890 94,805 141,767 60,833 862,938 1,333,996 83,121 537,754 977,361 60,833 862,938 1,333,996 22,288 (325,184) (356,635) Starting Fund Balance 551,718 551,718 Net Change (497,643) (325,184) Ending Fund Balance 54,075 226,534 Monthly Financial Report Through 08/31/16 Prior Fiscal Year Activity Included2016 Classification Budget Fund 205 - EMERGENCY TELEPHONE (E911) FUND REVENUE Other Taxes 1,018,000 Intergovernmental Revenue - Other Revenue - Interest Income 1,000 REVENUE TOTALS 1,019,000 EXPENSE Salary and Benefits 503,275 Services and Supplies 377,600 Capital Outlay 393,615 Insurance and Other Chargebacks 94,946 Community Sponsored Organizations - Contingencies 5,000 Debt Service - Miscellaneous - Interfund Transfers 142,207 EXPENSE TOTALS 1,516,643 Fund 205 - EMERGENCY TELEPHONE (497,643) Fund 205 - EMERGENCY TELEPHONE REVENUE TOTALS 1,019,000 EXPENSE TOTALS 1,516,643 Run by Ashley King on 09/28/2016 02:51:28 PM Page 10 of 49 August YTD 2016 2015 2016 Actual Actual 93,808 318,363 322,055 - 1 3 93,808 318,364 322,058 - 161,500 323,000 - - - - - - - 161,500 323,000 93,808 318,364 322,058 - 161,500 323,000 93,808 156,864 (942) Starting Fund Balance (190,544) (190,544) Net Change - 156,864 Ending Fund Balance (190,544) (33,680) Monthly Financial Report Through 08/31/16 Prior Fiscal Year Activity Included2016 Classification Budget Fund 210 - SPECIAL SERVICE AREA (SSA) #4 REVENUE Property Taxes 320,000 Interest Income - REVENUE TOTALS 320,000 320,000 EXPENSE Services and Supplies 320,000 Debt Service - Miscellaneous - EXPENSE TOTALS 320,000 Fund 210 - SPECIAL SERVICE AREA - EXPENSE TOTALS 320,000 Fund 210 - SPECIAL SERVICE AREA REVENUE TOTALS Run by Ashley King on 09/28/2016 02:51:28 PM Page 11 of 49 August YTD 2016 2015 2016 Actual Actual - - - - - - 527,243 604,649 1,502,924 - 10,197 3,318 - - - 527,243 614,846 1,506,242 32,005 268,745 318,743 - 4,531 28,988 1,990 185,245 276,834 5,685 46,410 58,583 85,692 85,692 235,459 - - - - - - 360 83,455 72,442 - 705 455,310 125,732 674,785 1,446,359 527,243 614,846 1,506,242 125,732 674,785 1,446,359 401,511 (59,939) 59,883 Starting Fund Balance 59,882 59,882 Net Change 375 (59,939) Ending Fund Balance 60,257 (57) Monthly Financial Report Through 08/31/16 Prior Fiscal Year Activity Included2016 Classification Budget Fund 215 - CDBG FUND REVENUE Charges for Services - Interfund Transfers - Intergovernmental Revenue 2,595,000 Other Revenue - Interest Income - REVENUE TOTALS 2,595,000 EXPENSE Salary and Benefits 385,285 Services and Supplies 3,800 Capital Outlay - Insurance and Other Chargebacks 87,795 Community Sponsored Organizations - Contingencies - 2,595,000 Debt Service - Miscellaneous 1,274,280 Interfund Transfers 843,465 EXPENSE TOTALS 2,594,625 Fund 215 - CDBG FUND Totals 375 EXPENSE TOTALS 2,594,625 Fund 215 - CDBG FUND Totals REVENUE TOTALS Run by Ashley King on 09/28/2016 02:51:28 PM Page 12 of 49 August YTD 2016 2015 2016 Actual Actual - - - 2,823 69,783 397,708 10 4,547 375 2,832 74,330 398,083 - - - 358 63,852 280,461 - 57,880 1,919 - - - 358 121,732 282,380 2,832 74,330 398,083 358 121,732 282,380 2,475 (47,402) 115,703 Starting Fund Balance 158,365 158,365 Net Change - (47,402) Ending Fund Balance 158,365 110,963 Monthly Financial Report Through 08/31/16 Prior Fiscal Year Activity Included2016 Classification Budget Fund 220 - CDBG LOAN REVENUE Intergovernmental Revenue - Other Revenue 350,000 Interest Income - REVENUE TOTALS 350,000 EXPENSE Salary and Benefits - Services and Supplies 340,000 Miscellaneous 10,000 Interfund Transfers - EXPENSE TOTALS 350,000 Fund 220 - CDBG LOAN Totals - Fund 220 - CDBG LOAN Totals REVENUE TOTALS 350,000 EXPENSE TOTALS 350,000 Run by Ashley King on 09/28/2016 02:51:28 PM Page 13 of 49 August YTD 2016 2015 2016 Actual Actual 70,134 1,487,697 2,116,843 - - - - - - 1,665 238,726 49,000 149 8,208 128 71,948 1,734,631 2,165,971 43,279 343,353 537,286 43,659 181,607 302,867 50,000 203,144 194,941 6,307 47,830 80,941 - - - - - - - - - 530 97,966 1,419,643 73,387 576,879 614,782 217,163 1,450,779 3,150,460 71,948 1,734,631 2,165,971 217,163 1,450,779 3,150,460 (145,214) 283,852 (984,489) Starting Fund Balance 2,555,982 2,555,982 Net Change (286,099) 283,852 Ending Fund Balance 2,269,883 2,839,834 Monthly Financial Report Through 08/31/16 Prior Fiscal Year Activity Included2016 Classification Budget Fund 225 - ECONOMIC DEVELOPMENT FUND REVENUE Other Taxes 2,165,000 Interfund Transfers 47,500 Intergovernmental Revenue - Other Revenue 50,000 Interest Income 100 REVENUE TOTALS 2,262,600 EXPENSE Salary and Benefits 646,806 Services and Supplies 912,200 Capital Outlay 253,500 Insurance and Other Chargebacks 104,871 Community Sponsored Organizations - Contingencies - 2,262,600 Debt Service - Miscellaneous 16,000 Interfund Transfers 615,322 EXPENSE TOTALS 2,548,699 Fund 225 - ECONOMIC (286,099) EXPENSE TOTALS 2,548,699 Fund 225 - ECONOMIC REVENUE TOTALS Run by Ashley King on 09/28/2016 02:51:28 PM Page 14 of 49 August YTD 2016 2015 2016 Actual Actual - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Starting Fund Balance 169,915 169,915 Net Change (80,000) - Ending Fund Balance 89,915 169,915 Monthly Financial Report Through 08/31/16 Prior Fiscal Year Activity Included2016 Classification Budget Fund 235 - NEIGHBORHOOD IMPROVEMENT REVENUE Other Taxes 20,000 Interfund Transfers - Interest Income - REVENUE TOTALS 20,000 EXPENSE Services and Supplies - Capital Outlay - 20,000 Debt Service - Miscellaneous 100,000 Interfund Transfers - EXPENSE TOTALS 100,000 Fund 235 - NEIGHBORHOOD (80,000) EXPENSE TOTALS 100,000 Fund 235 - NEIGHBORHOOD REVENUE TOTALS Run by Ashley King on 09/28/2016 02:51:28 PM Page 15 of 49 August YTD 2016 2015 2016 Actual Actual 23,143 123,991 465,961 2,282 18,131 6,402 0 8 19 25,425 142,130 472,382 3,001 18,764 12,388 6,915 122,245 282,753 - - - 378 2,403 1,368 - - - - - - - - 193,931 - - 26,990 10,293 143,412 517,430 25,425 142,130 472,382 10,293 143,412 517,430 15,132 (1,282) (45,048) Starting Fund Balance 4,770 4,770 Net Change - (1,282) Ending Fund Balance 4,770 3,488 Monthly Financial Report Through 08/31/16 Prior Fiscal Year Activity Included2016 Classification Budget Fund 240 - HOME FUND REVENUE Intergovernmental Revenue 393,868 Other Revenue 8,300 Interest Income - REVENUE TOTALS 402,168 EXPENSE Salary and Benefits 48,348 Services and Supplies 352,500 Capital Outlay - Insurance and Other Chargebacks 820 Community Sponsored Organizations - 402,168 Debt Service - Miscellaneous 500 Interfund Transfers - EXPENSE TOTALS 402,168 Fund 240 - HOME FUND Totals - EXPENSE TOTALS 402,168 Fund 240 - HOME FUND Totals REVENUE TOTALS Run by Ashley King on 09/28/2016 02:51:28 PM Page 16 of 49 August YTD 2016 2015 2016 Actual Actual 10,000 46,667 100,000 - - - - - - 32,222 176,305 125,150 138 879 111 42,360 223,851 225,261 3,001 18,764 - - - 98 - - - 309 1,856 - 735 735 - - - - 1,675 90,194 214,752 - - - 5,720 111,549 214,851 42,360 223,851 225,261 5,720 111,549 214,851 36,640 112,302 10,411 Starting Fund Balance 993,880 993,880 Net Change (313,719) 112,302 Ending Fund Balance 680,161 1,106,182 Monthly Financial Report Through 08/31/16 Prior Fiscal Year Activity Included2016 Classification Budget Fund 250 - AFFORDABLE HOUSING FUND REVENUE Other Taxes 30,000 Interfund Transfers - Intergovernmental Revenue - Other Revenue 130,400 Interest Income 228 REVENUE TOTALS 160,628 EXPENSE Salary and Benefits 48,347 Services and Supplies 350,000 Capital Outlay - Insurance and Other Chargebacks - Community Sponsored Organizations - Debt Service - Miscellaneous 76,000 Interfund Transfers - EXPENSE TOTALS 474,347 Fund 250 - AFFORDABLE HOUSING (313,719) Fund 250 - AFFORDABLE HOUSING REVENUE TOTALS 160,628 EXPENSE TOTALS 474,347 Run by Ashley King on 09/28/2016 02:51:28 PM Page 17 of 49 August YTD 2016 2015 2016 Actual Actual 1,267,415 4,679,665 4,921,484 - - - - - - - - - 1,600 8,090 3,530 1,269,014 4,687,755 4,925,014 - - - - 216 1,408 - 4,473 198,823 - - 574,976 - 49,338 110,310 (1,020,686) 2,707,845 3,265,296 (1,020,686) 2,761,872 4,150,811 1,269,014 4,687,755 4,925,014 (1,020,686) 2,761,872 4,150,811 2,289,700 1,925,882 774,203 Starting Fund Balance 6,442,430 6,442,430 Net Change (2,640,683) 1,925,882 Ending Fund Balance 3,801,747 8,368,312 Monthly Financial Report Through 08/31/16 Prior Fiscal Year Activity Included2016 Classification Budget Fund 300 - WASHINGTON NATIONAL TIF FUND REVENUE Property Taxes 5,145,000 Other Taxes - Interfund Transfers - Other Revenue - Interest Income 2,000 REVENUE TOTALS 5,147,000 EXPENSE Salary and Benefits - Services and Supplies 1,000,000 Capital Outlay - 5,147,000 Debt Service - Miscellaneous 500,000 Interfund Transfers 6,287,683 EXPENSE TOTALS 7,787,683 Fund 300 - WASHINGTON (2,640,683) EXPENSE TOTALS 7,787,683 Fund 300 - WASHINGTON REVENUE TOTALS Run by Ashley King on 09/28/2016 02:51:28 PM Page 18 of 49 August YTD 2016 2015 2016 Actual Actual - 287,825 422,527 - - - - - - - 35 4 - 287,860 422,531 - - - - 17,250 297,150 - - - - 17,250 297,150 - 287,860 422,531 - 17,250 297,150 - 270,610 125,381 Starting Fund Balance 525,429 525,429 Net Change (467,971) 270,610 Ending Fund Balance 57,458 796,039 Monthly Financial Report Through 08/31/16 Prior Fiscal Year Activity Included2016 Classification Budget Fund 305 - SPECIAL SERVICE AREA (SSA) #5 REVENUE Property Taxes - Interfund Transfers - Other Revenue - Interest Income 300 REVENUE TOTALS 300 EXPENSE Services and Supplies 51,399 Debt Service 416,872 Miscellaneous - EXPENSE TOTALS 468,271 Fund 305 - SPECIAL SERVICE AREA (467,971) Fund 305 - SPECIAL SERVICE AREA REVENUE TOTALS 300 EXPENSE TOTALS 468,271 Run by Ashley King on 09/28/2016 02:51:28 PM Page 19 of 49 August YTD 2016 2015 2016 Actual Actual 490,688 1,233,675 1,248,231 - - - 227 1,404 1,985 490,915 1,235,080 1,250,216 - 216 1,158 230,057 306,515 11,402 - - - - - - - 129,192 2,162,381 146,038 1,168,300 148,010 376,094 1,604,222 2,322,950 490,915 1,235,080 1,250,216 376,094 1,604,222 2,322,950 114,821 (369,142) (1,072,734) Starting Fund Balance 1,281,115 1,281,115 Net Change (650,450) (369,142) Ending Fund Balance 630,665 911,973 Monthly Financial Report Through 08/31/16 Prior Fiscal Year Activity Included2016 Classification Budget Fund 310 - HOWARD-HARTREY TIF REVENUE Property Taxes 1,300,000 Other Revenue - Interest Income 2,000 REVENUE TOTALS 1,302,000 EXPENSE Services and Supplies - Capital Outlay - Community Sponsored Organizations - Debt Service - Miscellaneous 200,000 Interfund Transfers 1,752,450 EXPENSE TOTALS 1,952,450 Fund 310 - HOWARD-HARTREY TIF REVENUE TOTALS 1,302,000 EXPENSE TOTALS 1,952,450 Fund 310 - HOWARD-HARTREY TIF (650,450) Run by Ashley King on 09/28/2016 02:51:28 PM Page 20 of 49 August YTD 2016 2015 2016 Actual Actual - - - - - - - - - - - - - - - - - - - - 893,387 - - - - - 893,387 - - - - - 893,387 - - (893,387) Starting Fund Balance - - Net Change - - Ending Fund Balance - - Monthly Financial Report Through 08/31/16 Prior Fiscal Year Activity Included2016 Classification Budget Fund 315 - SOUTHWEST TIF FUND REVENUE Property Taxes - Interest Income - REVENUE TOTALS - EXPENSE Services and Supplies - Capital Outlay - Debt Service - Miscellaneous - Interfund Transfers - EXPENSE TOTALS - Fund 315 - SOUTHWEST TIF FUND - Fund 315 - SOUTHWEST TIF FUND REVENUE TOTALS - EXPENSE TOTALS - Run by Ashley King on 09/28/2016 02:51:28 PM Page 21 of 49 August YTD 2016 2015 2016 Actual Actual 3,030,014 10,221,410 11,156,231 347,841 1,863,418 1,642,654 - - 12,278,473 2,439 14,749 7,668 3,380,293 12,099,577 25,085,026 525 2,775 171,576 - 4,159,452 24,358,022 - - 3,062 - - - 525 4,162,227 24,532,661 3,380,293 12,099,577 25,085,026 525 4,162,227 24,532,661 3,379,768 7,937,350 552,365 Starting Fund Balance 2,596,116 2,596,116 Net Change (2,751,668) 7,937,350 Ending Fund Balance (155,552) 10,533,466 Monthly Financial Report Through 08/31/16 Prior Fiscal Year Activity Included2016 Classification Budget Fund 320 - DEBT SERVICE FUND REVENUE Property Taxes 10,879,993 Interfund Transfers 2,646,291 Other Revenue - Interest Income 1,500 REVENUE TOTALS 13,527,784 EXPENSE Services and Supplies 315,770 13,527,784 Debt Service 15,963,682 Miscellaneous - Interfund Transfers - EXPENSE TOTALS 16,279,452 Fund 320 - DEBT SERVICE FUND (2,751,668) EXPENSE TOTALS 16,279,452 Fund 320 - DEBT SERVICE FUND REVENUE TOTALS Run by Ashley King on 09/28/2016 02:51:28 PM Page 22 of 49 August YTD 2016 2015 2016 Actual Actual 219,631 528,905 540,576 4,139 86,961 64,176 46 285 1,815 223,816 616,151 606,568 252 316,110 587,839 - - (6,275) - - - - - - 61 442 585 - - 350 5,000 40,000 107,500 5,313 356,552 689,999 223,816 616,151 606,568 5,313 356,552 689,999 218,503 259,599 (83,431) Starting Fund Balance (28,621) (28,621) Net Change 24,000 259,599 Ending Fund Balance (4,621) 230,978 Monthly Financial Report Through 08/31/16 Prior Fiscal Year Activity Included2016 Classification Budget Fund 330 - HOWARD-RIDGE TIF FUND REVENUE Property Taxes 550,000 Other Revenue 1,120,000 Interest Income 100 REVENUE TOTALS 1,670,100 EXPENSE Services and Supplies 538,000 Capital Outlay 1,000,000 Insurance and Other Chargebacks - Community Sponsored Organizations - Debt Service 600 Miscellaneous - Interfund Transfers 107,500 EXPENSE TOTALS 1,646,100 Fund 330 - HOWARD-RIDGE TIF 24,000 Fund 330 - HOWARD-RIDGE TIF REVENUE TOTALS 1,670,100 EXPENSE TOTALS 1,646,100 Run by Ashley King on 09/28/2016 02:51:28 PM Page 23 of 49 August YTD 2016 2015 2016 Actual Actual - - - 1,028 7,198 - 171 1,043 257 1,199 8,241 257 - 507 1,158 - (1,028) (11,205) - - - - - - 751 5,433 7,185 - - 1,227 2,500 20,000 60,000 3,251 24,911 58,365 1,199 8,241 257 3,251 24,911 58,365 (2,052) (16,671) (58,107) Starting Fund Balance 442,263 442,263 Net Change (39,850) (16,671) Ending Fund Balance 402,413 425,592 Monthly Financial Report Through 08/31/16 Prior Fiscal Year Activity Included2016 Classification Budget Fund 335 - WEST EVANSTON TIF FUND REVENUE Property Taxes - Other Revenue - Interest Income 150 REVENUE TOTALS 150 EXPENSE Services and Supplies - Capital Outlay - Insurance and Other Chargebacks - Contingencies - Debt Service 10,000 Miscellaneous - Interfund Transfers 30,000 EXPENSE TOTALS 40,000 Fund 335 - WEST EVANSTON TIF (39,850) Fund 335 - WEST EVANSTON TIF REVENUE TOTALS 150 EXPENSE TOTALS 40,000 Run by Ashley King on 09/28/2016 02:51:28 PM Page 24 of 49 August YTD 2016 2015 2016 Actual Actual - - - - - 2,000,000 - - 2,000,000 - - - - - 2,000,000 - - - - - 2,000,000 - - 2,000,000 - - 2,000,000 - - - Starting Fund Balance - - Net Change 10,000 - Ending Fund Balance 10,000 - Monthly Financial Report Through 08/31/16 Prior Fiscal Year Activity Included2016 Classification Budget Fund 340 - DEMPSTER-DODGE TIF FUND REVENUE Property Taxes - Other Revenue 50,000 REVENUE TOTALS 50,000 50,000 EXPENSE Services and Supplies - Capital Outlay - Debt Service 40,000 EXPENSE TOTALS 40,000 Fund 340 - DEMPSTER-DODGE TIF 10,000 EXPENSE TOTALS 40,000 Fund 340 - DEMPSTER-DODGE TIF REVENUE TOTALS Run by Ashley King on 09/28/2016 02:51:28 PM Page 25 of 49 August YTD 2016 2015 2016 Actual Actual - - - - 580,000 900,000 - 580,000 900,000 - 1,408 - - 580,000 580,000 4,402 27,098 7,930 4,402 608,506 587,930 - 580,000 900,000 4,402 608,506 587,930 (4,402) (28,506) 312,070 Starting Fund Balance 312,070 312,070 Net Change 31,500 (28,506) Ending Fund Balance 343,570 283,564 Monthly Financial Report Through 08/31/16 Prior Fiscal Year Activity Included2016 Classification Budget Fund 345 - CHICAGO-MAIN TIF REVENUE Property Taxes 75,000 Other Revenue - REVENUE TOTALS 75,000 75,000 EXPENSE Services and Supplies - Capital Outlay - Debt Service 43,500 EXPENSE TOTALS 43,500 Fund 345 - CHICAGO-MAIN TIF Totals 31,500 EXPENSE TOTALS 43,500 Fund 345 - CHICAGO-MAIN TIF Totals REVENUE TOTALS Run by Ashley King on 09/28/2016 02:51:28 PM Page 26 of 49 August YTD 2016 2015 2016 Actual Actual 56,747 219,528 - 1 1 - 56,748 219,528 - - - - - - - - - - 56,748 219,528 - - - - 56,748 219,528 - Starting Fund Balance - - Net Change 10,500 219,528 Ending Fund Balance 10,500 219,528 Monthly Financial Report Through 08/31/16 Prior Fiscal Year Activity Included2016 Classification Budget Fund 350 - SPECIAL SERVICE AREA (SSA) #6 REVENUE Property Taxes 210,000 Interest Income 500 REVENUE TOTALS 210,500 EXPENSE Services and Supplies 200,000 Interfund Transfers - EXPENSE TOTALS 200,000 Fund 350 - SPECIAL SERVICE AREA 10,500 Fund 350 - SPECIAL SERVICE AREA REVENUE TOTALS 210,500 EXPENSE TOTALS 200,000 Run by Ashley King on 09/28/2016 02:51:28 PM Page 27 of 49 August YTD 2016 2015 2016 Actual Actual 10,467 76,686 87,391 (1,027,417) 2,654,000 - 703,687 1,527,914 270,268 53 244,253 7,945,481 1,052 7,354 3,815 (312,159) 4,510,206 8,306,954 - - - 56,146 380,120 643,510 586,818 2,375,349 9,794,396 - - - - - 32,933 - - 490,000 642,964 2,755,469 10,960,839 (312,159) 4,510,206 8,306,954 642,964 2,755,469 10,960,839 (955,122) 1,754,738 (2,653,885) Starting Fund Balance 5,517,041 5,517,041 Net Change (2,209,000) 1,754,738 Ending Fund Balance 3,308,041 7,271,779 Monthly Financial Report Through 08/31/16 Prior Fiscal Year Activity Included2016 Classification Budget Fund 415 - CAPITAL IMPROVEMENTS FUND REVENUE Charges for Services - Interfund Transfers 6,471,000 Intergovernmental Revenue 4,841,615 Other Revenue 9,248,000 Interest Income - REVENUE TOTALS 20,560,615 EXPENSE Salary and Benefits - Services and Supplies 2,256,962 Capital Outlay 20,022,653 20,560,615 Debt Service - Miscellaneous - Interfund Transfers 490,000 EXPENSE TOTALS 22,769,615 Fund 415 - CAPITAL (2,209,000) EXPENSE TOTALS 22,769,615 Fund 415 - CAPITAL REVENUE TOTALS Run by Ashley King on 09/28/2016 02:51:28 PM Page 28 of 49 August YTD 2016 2015 2016 Actual Actual - - - - - - - - - - - - - - - - - - - - - - - 243,113 - - - - - - - - - 11,276 23,987 24,832 24,145 120,894 125,218 - - - 35,421 144,881 393,163 - - - - 12 1,879 - - 226,538 - - - - - - - - 534 51,783 240,465 - 51,783 240,477 228,951 35,421 144,881 393,163 51,783 240,477 228,951 (16,362) (95,597) 164,213 Starting Fund Balance 2,682,781 2,682,781 Net Change 98,950 (95,597) Ending Fund Balance 2,781,731 2,587,184 Monthly Financial Report Through 08/31/16 Prior Fiscal Year Activity Included2016 Classification Budget Fund 420 - SPECIAL ASSESSMENT FUND REVENUE Property Taxes - Other Taxes - Licenses, Permits and Fees - Fines and Forfeitures - Charges for Services - Interfund Transfers - Intergovernmental Revenue - Other Revenue 250,000 Workers Compensation and Liability - Insurance - Library Revenue - Interest Income 51,033 Special Assessment 180,167 Reappropriation of Surplus - REVENUE TOTALS 481,200 EXPENSE Salary and Benefits - Services and Supplies - Capital Outlay - Insurance and Other Chargebacks - Debt Service - Miscellaneous - Interfund Transfers 382,250 EXPENSE TOTALS 382,250 Fund 420 - SPECIAL ASSESSMENT REVENUE TOTALS 481,200 EXPENSE TOTALS 382,250 Fund 420 - SPECIAL ASSESSMENT 98,950 Run by Ashley King on 09/28/2016 02:51:28 PM Page 29 of 49 August YTD 2016 2015 2016 Actual Actual - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Monthly Financial Report Through 08/31/16 Prior Fiscal Year Activity Included2016 Classification Budget Fund 495 - SHERMAN PLAZA GARAGE FUND REVENUE Other Taxes - Charges for Services - Interfund Transfers - Other Revenue - Interest Income - REVENUE TOTALS - EXPENSE Salary and Benefits - Services and Supplies - Insurance and Other Chargebacks - Depreciation Expense - Contingencies - Debt Service - Miscellaneous - Interfund Transfers - EXPENSE TOTALS - Fund 495 - SHERMAN PLAZA - Fund 495 - SHERMAN PLAZA REVENUE TOTALS - EXPENSE TOTALS - Run by Ashley King on 09/28/2016 02:51:28 PM Page 30 of 49 August YTD 2016 2015 2016 Actual Actual - - - - - - - 3,000 150 - - - 768,932 4,788,646 6,010,558 309,314 2,474,512 2,925,296 - - - 9,577 114,643 153,545 3,207 18,171 18,260 1,091,031 7,398,972 9,107,809 85,417 793,073 963,107 244,923 2,069,421 2,859,622 93,415 535,986 128,726 42,154 329,860 478,187 - - - - - 2,846,227 438 3,411 6,951 - 199,979 503,423 105,649 166,852 23,687 108,649 869,189 923,092 680,645 4,967,772 8,733,020 1,091,031 7,398,972 9,107,809 680,645 4,967,772 8,733,020 410,386 2,431,200 374,789 Starting Fund Balance 10,777,874 10,777,874 Net Change (6,615,186) 2,431,200 Ending Fund Balance 4,162,688 13,209,074 Monthly Financial Report Through 08/31/16 Prior Fiscal Year Activity Included2016 Classification Budget Fund 505 - PARKING SYSTEM FUND REVENUE Property Taxes - Other Taxes - Licenses, Permits and Fees - Fines and Forfeitures - Charges for Services 6,444,675 Interfund Transfers 3,711,770 Intergovernmental Revenue 12,125 Other Revenue 119,216 Interest Income 35,070 REVENUE TOTALS 10,322,856 EXPENSE Salary and Benefits 1,297,037 Services and Supplies 3,301,275 Capital Outlay 3,474,000 Insurance and Other Chargebacks 507,900 Community Sponsored Organizations - Depreciation Expense 2,873,395 Contingencies 11,000 Debt Service 3,917,652 Miscellaneous 252,000 Interfund Transfers 1,303,783 EXPENSE TOTALS 16,938,042 Fund 505 - PARKING SYSTEM FUND (6,615,186) Fund 505 - PARKING SYSTEM FUND REVENUE TOTALS 10,322,856 EXPENSE TOTALS 16,938,042 Run by Ashley King on 09/28/2016 02:51:28 PM Page 31 of 49 August YTD 2016 2015 2016 Actual Actual - - - 5,525 65,202 105,483 377,412 11,037,494 15,308,225 300,000 6,997,244 2,354,582 - - - (3,353) 75,989 350,065 1,781 9,489 3,448 681,365 18,185,418 18,121,804 340,036 2,877,925 3,927,752 204,997 1,479,382 2,298,993 638,101 5,506,830 105 91,165 732,333 1,131,508 - - - - - 2,096,633 - 658 933 - 373,518 432,628 - 10,543 (286,678) 591,859 9,332,119 3,692,565 1,866,158 20,313,308 13,294,439 681,365 18,185,418 18,121,804 1,866,158 20,313,308 13,294,439 (1,184,793) (2,127,890) 4,827,365 Starting Fund Balance 9,223,203 9,223,203 Net Change 23,958,051 (2,127,890) Ending Fund Balance 33,181,254 7,095,313 Monthly Financial Report Through 08/31/16 Prior Fiscal Year Activity Included2016 Classification Budget Fund 510 - WATER FUND REVENUE Other Taxes - Licenses, Permits and Fees 70,000 Charges for Services 15,298,000 Interfund Transfers - Intergovernmental Revenue - Other Revenue 22,348,400 Interest Income 1,600 REVENUE TOTALS 37,718,000 EXPENSE Salary and Benefits 4,459,423 Services and Supplies 3,490,950 Capital Outlay 75,800 Insurance and Other Chargebacks 1,114,195 Community Sponsored Organizations - Depreciation Expense - Contingencies 1,000 37,718,000 Debt Service 1,053,288 Miscellaneous 62,980 Interfund Transfers 3,502,313 EXPENSE TOTALS 13,759,949 Fund 510 - WATER FUND Totals 23,958,051 EXPENSE TOTALS 13,759,949 Fund 510 - WATER FUND Totals REVENUE TOTALS Run by Ashley King on 09/28/2016 02:51:28 PM Page 32 of 49 August YTD 2016 2015 2016 Actual Actual 1,511,204 8,917,089 12,510,940 - - - - 554,863 2,962 169 2,820 2,706 1,511,373 9,474,772 12,516,607 70,135 646,945 892,099 34,834 257,905 108,927 60,043 723,144 13,609 34,033 272,372 412,461 - - 3,443,723 - - - 205,395 4,817,425 1,550,407 - 5,000 3,306 85,447 515,915 735,235 489,887 7,238,707 7,159,766 1,511,373 9,474,772 12,516,607 489,887 7,238,707 7,159,766 1,021,487 2,236,066 5,356,842 Starting Fund Balance 4,012,808 4,012,808 Net Change (1,607,486) 2,236,066 Ending Fund Balance 2,405,322 6,248,874 Monthly Financial Report Through 08/31/16 Prior Fiscal Year Activity Included2016 Classification Budget Fund 515 - SEWER FUND REVENUE Charges for Services 12,888,650 Interfund Transfers - Other Revenue 984,165 Interest Income 1,000 REVENUE TOTALS 13,873,815 EXPENSE Salary and Benefits 1,024,459 Services and Supplies 995,800 Capital Outlay 3,048,314 Insurance and Other Chargebacks 414,439 Depreciation Expense - Contingencies - Debt Service 9,222,913 Miscellaneous 1,500 Interfund Transfers 773,876 EXPENSE TOTALS 15,481,301 Fund 515 - SEWER FUND Totals (1,607,486) Fund 515 - SEWER FUND Totals REVENUE TOTALS 13,873,815 EXPENSE TOTALS 15,481,301 Run by Ashley King on 09/28/2016 02:51:28 PM Page 33 of 49 August YTD 2016 2015 2016 Actual Actual - 81,934 213,490 305,793 2,371,390 3,561,584 87,997 703,978 1,055,967 - - - 11,935 62,025 228,469 - - - 405,726 3,219,328 5,059,510 56,041 468,424 600,068 322,108 2,109,752 3,717,885 - 2,664 24,738 11,805 89,673 249,232 - - - - - - - - - - 1,144 68,419 - 12,232 - 41,624 332,995 490,106 431,579 3,016,884 5,150,448 405,726 3,219,328 5,059,510 431,579 3,016,884 5,150,448 (25,853) 202,443 (90,938) Starting Fund Balance (1,228,557) (1,228,557) Net Change 60,844 202,443 Ending Fund Balance (1,167,713) (1,026,114) Monthly Financial Report Through 08/31/16 Prior Fiscal Year Activity Included2016 Classification Budget Fund 520 - SOLID WASTE FUND REVENUE Licenses, Permits and Fees 275,000 Charges for Services 3,632,394 Interfund Transfers 1,055,967 Intergovernmental Revenue - Other Revenue 238,000 Interest Income - REVENUE TOTALS 5,201,361 EXPENSE Salary and Benefits 738,408 Services and Supplies 3,732,176 Capital Outlay 25,750 Insurance and Other Chargebacks 129,690 Community Sponsored Organizations - Depreciation Expense - Contingencies - Debt Service - Miscellaneous 15,000 Interfund Transfers 499,493 EXPENSE TOTALS 5,140,517 Fund 520 - SOLID WASTE FUND 60,844 Fund 520 - SOLID WASTE FUND REVENUE TOTALS 5,201,361 EXPENSE TOTALS 5,140,517 Run by Ashley King on 09/28/2016 02:51:28 PM Page 34 of 49 August YTD 2016 2015 2016 Actual Actual 282,301 2,258,476 3,289,009 - - - - - - - 8,577 46,933 - - - 282,301 2,267,053 3,335,942 64,108 540,520 961,887 134,816 991,676 1,686,117 - - - 12,476 113,136 175,716 - - - - - - - - - - - - 4,460 17,841 25,820 215,859 1,663,174 2,849,539 282,301 2,267,053 3,335,942 215,859 1,663,174 2,849,539 66,441 603,879 486,403 Starting Fund Balance 365,460 365,460 Net Change (244,277) 603,879 Ending Fund Balance 121,183 969,339 Monthly Financial Report Through 08/31/16 Prior Fiscal Year Activity Included2016 Classification Budget Fund 600 - FLEET SERVICES FUND REVENUE Charges for Services 3,317,088 Interfund Transfers - Intergovernmental Revenue - Other Revenue 81,781 Interest Income 1,000 REVENUE TOTALS 3,399,869 EXPENSE Salary and Benefits 1,052,741 Services and Supplies 2,380,057 Capital Outlay - Insurance and Other Chargebacks 184,136 Depreciation Expense - Contingencies 450 3,399,869 Debt Service - Miscellaneous - Interfund Transfers 26,762 EXPENSE TOTALS 3,644,146 Fund 600 - FLEET SERVICES FUND (244,277) EXPENSE TOTALS 3,644,146 Fund 600 - FLEET SERVICES FUND REVENUE TOTALS Run by Ashley King on 09/28/2016 02:51:28 PM Page 35 of 49 August YTD 2016 2015 2016 Actual Actual 121,255 970,151 1,451,422 - - - - 31,437 34,286 121,255 1,001,588 1,485,708 2,565 13,671 53,400 1,237 8,431 - - - 1,684,835 - - - 3,802 22,102 1,738,234 121,255 1,001,588 1,485,708 3,802 22,102 1,738,234 117,454 979,485 (252,527) Starting Fund Balance 1,277,689 1,277,689 Net Change 146,216 979,485 Ending Fund Balance 1,423,905 2,257,174 Monthly Financial Report Through 08/31/16 Prior Fiscal Year Activity Included2016 Classification Budget Fund 601 - EQUIPMENT REPLACEMENT FUND REVENUE Charges for Services 1,451,421 Interfund Transfers - Other Revenue 210,217 REVENUE TOTALS 1,661,638 EXPENSE Services and Supplies 60,000 Capital Outlay 1,455,422 Depreciation Expense - Miscellaneous - EXPENSE TOTALS 1,515,422 Fund 601 - EQUIPMENT 146,216 Fund 601 - EQUIPMENT REVENUE TOTALS 1,661,638 EXPENSE TOTALS 1,515,422 Run by Ashley King on 09/28/2016 02:51:28 PM Page 36 of 49 August YTD 2016 2015 2016 Actual Actual 3,356 26,929 162,411 68 547 306,051 824,746 6,436,775 10,413,499 291 75,858 1,034,405 531,968 4,413,028 5,753,308 8 128 136 1,360,437 10,953,264 17,669,810 45,321 371,233 460,086 397,709 1,510,328 1,305,086 - - - 1,299,436 9,627,693 14,318,413 - - - - - - - - - - - - - 4,330 - 1,544 6,175 8,936 1,744,010 11,519,759 16,092,521 1,360,437 10,953,264 17,669,810 1,744,010 11,519,759 16,092,521 (383,573) (566,495) 1,577,289 Starting Fund Balance (364,496) (364,496) Net Change 565,405 (566,495) Ending Fund Balance 200,909 (930,991) Monthly Financial Report Through 08/31/16 Prior Fiscal Year Activity Included2016 Classification Budget Fund 605 - INSURANCE FUND REVENUE Charges for Services 162,411 Interfund Transfers - Other Revenue 10,111,694 Workers Compensation and Liability 1,023,094 Insurance 6,459,839 Interest Income 1,000 REVENUE TOTALS 17,758,038 EXPENSE Salary and Benefits 419,515 Services and Supplies 1,385,248 Capital Outlay - Insurance and Other Chargebacks 15,378,608 Community Sponsored Organizations - Depreciation Expense - Contingencies - Debt Service - Miscellaneous - Interfund Transfers 9,262 EXPENSE TOTALS 17,192,633 Fund 605 - INSURANCE FUND Totals 565,405 Fund 605 - INSURANCE FUND Totals REVENUE TOTALS 17,758,038 EXPENSE TOTALS 17,192,633 Run by Ashley King on 09/28/2016 02:51:28 PM Page 37 of 49 August YTD 2016 2015 2016 Actual Actual 2,068,686 6,964,687 - - 267,404 280,000 - - - 75,703 629,224 6,273,004 23 68 1,206,228 2,144,412 7,861,383 7,759,232 689,528 5,585,984 8,302,220 - - - - - - - - - - - - 689,528 5,585,984 8,302,220 2,144,412 7,861,383 7,759,232 689,528 5,585,984 8,302,220 1,454,884 2,275,399 (542,988) Starting Fund Balance 66,741,084 66,741,084 Net Change 4,297,865 2,275,399 Ending Fund Balance 71,038,949 69,016,483 Monthly Financial Report Through 08/31/16 Prior Fiscal Year Activity Included2016 Classification Budget Fund 700 - FIRE PENSION FUND REVENUE Property Taxes 7,070,865 Other Taxes 280,000 Interfund Transfers - Other Revenue 1,010,000 Interest Income 4,100,000 REVENUE TOTALS 12,460,865 EXPENSE Salary and Benefits 8,163,000 Services and Supplies - Community Sponsored Organizations - Debt Service - Miscellaneous - EXPENSE TOTALS 8,163,000 Fund 700 - FIRE PENSION FUND 4,297,865 Fund 700 - FIRE PENSION FUND REVENUE TOTALS 12,460,865 EXPENSE TOTALS 8,163,000 Run by Ashley King on 09/28/2016 02:51:28 PM Page 38 of 49 A August YTD 2016 2015 B 2016 Actual Actual 2,647,414 8,919,015 57,836 - 267,404 325,000 - - - 113,872 954,400 7,676,438 30 1,226 2,902,399 2,761,316 10,142,045 10,961,673 940,922 7,300,961 10,768,296 - - - - - - - - - 940,922 7,300,961 10,768,296 2,761,316 10,142,045 10,961,673 940,922 7,300,961 10,768,296 1,820,394 2,841,084 193,377 Starting Fund Balance 98,558,837 98,558,837 Net Change 6,383,940 2,841,084 Ending Fund Balance 104,942,777 101,399,921 Monthly Financial Report Through 08/31/16 Prior Fiscal Year Activity Included2016 Classification Budget Fund 705 - POLICE PENSION FUND REVENUE Property Taxes 9,055,940 Other Taxes 325,000 Interfund Transfers - Other Revenue 1,550,000 Interest Income 6,500,000 REVENUE TOTALS 17,430,940 EXPENSE Salary and Benefits 11,047,000 Services and Supplies - Debt Service - Miscellaneous - EXPENSE TOTALS 11,047,000 Fund 705 - POLICE PENSION FUND REVENUE TOTALS 17,430,940 EXPENSE TOTALS 11,047,000 Fund 705 - POLICE PENSION FUND 6,383,940 Run by Ashley King on 09/28/2016 02:51:28 PM Page 39 of 49 Jan Feb Mar Apr May Jun Jul Aug 2015 Unreserved Fund Balance 17,350,271 17,704,926 21,823,492 21,070,998 20,159,923 19,573,881 13,460,405 13,534,424 2016 Unreserved Fund Balance 11,859,782 14,097,256 17,193,730 16,597,583 18,375,173 21,225,995 15,790,000 17,674,579 2015 Cash Balance 5,232,590 6,567,371 10,786,783 8,666,475 8,237,917 7,501,885 6,692,927 9,614,255 2016 Cash Balance 3,656,830 2,587,845 8,182,090 7,808,208 7,101,333 12,919,440 10,046,315 10,473,240 2015 v 2016 Fund and Cash Balance-- General Fund - 5,000,000 10,000,000 15,000,000 20,000,000 25,000,000 Jan Feb Mar Apr May Jun Jul Aug 2015 Unreserved Fund Balance 2016 Unreserved Fund Balance 2015 Cash Balance 2016 Cash Balance