Loading...
FY2018 4th Qtr Financial Summary Date: August 21, 2018 To: City Manager, City Council From: Jacklyn Budding, Budget & Compliance Officer Re: Quarterly Financial Summary for Period Ending June 30, 2018 Introduction Attached to this memorandum are the City’s quarterly financial reports as of June 30, 2018. The quarterly financial report includes combined summaries of all fund balances, revenues, and expenditures for fiscal year 2018 through the end of the fiscal year. This report represents the entire fiscal year’s activities, but the totals presented are still preliminary and unaudited. Accruals will continue to be posted through August and September and until the annual financial audit is completed by Bohnsack & Frommelt. Revenue Analysis This revenue analysis pertains to the revenue reports, Revenues by Fund and Revenues by Type, on pages 4-6. In these two reports, the actual revenues would ideally be near 100% of budget since we have completed the fiscal year; however, not all of the accrued revenues have been received and posted yet. For the major governmental funds, their actual revenues appear to have finished the year very close to their revised budget estimates. The General Fund is at 97.1%, the Road Use Tax Fund is at 86.3%, the Employee Benefits Fund is at 101.5%, and the Debt Service Fund is at 100.5%. Some large accruals are still outstanding such as the final Hotel/Motel Tax receipt (Other City Taxes) in the General Fund, but overall, these funds appear to have received revenues in line with what we were anticipating. In the major enterprise funds, the actual revenues as a percentage of the budget ranged between 102.1% and 109.5%. The Wastewater Fund finished with revenues at 104.2% of budget, the Landfill Fund at 109.5% of budget and the Water Fund at 105.6% of budget. The major enterprise funds finished the year with revenues higher than 100% of budget primarily due to conservative revenue budgeting for charges for fees and services and interest income. Several funds are below the 100% benchmark due to the timing of grants. These funds include the Community Development Block Grant (CDBG) Fund at 72.9%, the HOME Fund at 57.7%, the Other Shared Revenue Fund at 71.7%, and the Metro Planning Org of Johnson County at 87.7%. Revenues for these funds are significantly below budget due to the timing of the state and federal grant revenues and private loan repayments. These revenues have not yet been received or earned and will be amended into next year’s budget. The combined total actual revenues for all budgetary funds through June are $165,488,374 or 97.5% of budget. The budget shortfall of $4,286,103 is primarily due to the timing of the aforementioned grant revenues and other unrecorded accruals. Overall, the City’s revenues are not substantially different than projected, and most of the anomalies and budget variances can be explained. 11 Expenditure Analysis This expenditure analysis pertains to the expenditure reports, Expenditures by Fund and Expenditures by Fund by Department on pages 7-9. The analysis of the City’s expenditures for fiscal year 2018 through June is similar to the analysis for the City’s revenues. We generally expect the actual expenditure levels to be around 100% of budget at this time of year. Also, similar to the revenues, not all accruals have been recorded and posted yet. For the majority of the City’s funds, their actual expenditures are currently at or below 100% of their budgeted expenditures. The General Fund is at 92.0%, the Road Use Tax Fund is at 93.1%, and the Debt Service Fund is at 99.3%. The same is true for most of the City’s enterprise funds; however, the Airport fund finished at 120.3% primarily due to unplanned strategic plan expenditures and major repairs needed during the year, and the Housing Authority Funds finished at 109.6% of budget primarily due to landlord rent payments. Note the Housing Authority Funds expenditures were largely offset by an increase in the fund’s revenues (106.5% of budget). Additionally, the Risk Management Fund is at 132.3% of budgeted expenditures due to several large claims during the year. Some of the other funds have actual expenditures that well are below the 100% benchmark. Those funds include the HOME Fund (50.2%), the CDBG Fund (78.5%), and the Affordable Housing Fund (50.0%). Also well below budget are the Governmental Projects Fund (41.4%), and the Enterprise Projects Fund (48.4%). All of these funds contain a great deal of grant and project activity which does not always occur evenly throughout the fiscal year. Unexpended appropriations will be carried forward into the next fiscal year and amended into the fiscal year 2019 budget. The combined total actual expenditures for all budgetary funds through June are $185,241,616 or 74.8% of budget. When the capital project funds and the HOME, CDBG, and Affordable Housing funds are removed from the calculation, the actual percentage of expenditures versus budget increases to 97.4%. Overall, the City’s expenditures are expected to finish at or below budget and in compliance with State law. Conclusion Generally, there are no major concerns to report with the City’s fund balances at year-end; most of the City’s fund balances finished the year near expectations or had explainable variances. Two funds, the Community Development Block Grant (CDBG) and Other Shared Revenue fund, are presented (on page 3) with negative fund balances at -$43,095 and -$16,165, respectively. These negative fund balances should be reversed following the next receipt of CDBG funds and FEMA funds for Hazard Mitigation. This year-end report is preliminary and accruals for revenues and expenditure are still outstanding. The City’s final financial performance will be available for the start of the fiscal year 2020 budget process in October. Additional information is available from the Finance Department upon request. 22 Beginning Ending Restricted, Unassigned Fund Year-to-Date Transfers Year-to-Date Transfers Fund Committed, Fund Balance Revenues In Expenditures Out Balance Assigned Balance Budgetary Funds General Fund 10** General Fund 40,724,250$ 51,254,454$ 10,195,430$ 53,385,236$ 13,683,695$ 35,105,204$ 6,713,082$ 28,392,121$ Special Revenue Funds 2100 Community Dev Block Grant (90,569) 641,018 - 592,163 1,380 (43,095) - (43,095) 2110 HOME 113,005 653,951 - 558,825 29,287 178,844 - 178,844 2200 Road Use Tax Fund 5,714,241 7,245,572 441,583 6,059,055 4,742,959 2,599,382 - 2,599,382 2300 Other Shared Revenue 82,485 249,786 (15,185) 333,251 - (16,165) - (16,165) 2350 Metro Planning Org of J.C. 256,738 268,959 276,205 591,338 - 210,563 - 210,563 2400 Employee Benefits 2,520,948 11,668,231 - 1,051,619 10,374,643 2,762,916 - 2,762,916 2500 Affordable Housing Fund 468,102 415,749 650,000 325,000 - 1,208,851 - 1,208,851 2510 Peninsula Apartments 143,381 73,278 - 50,641 - 166,019 - 166,019 26** Tax Increment Financing 482,246 2,473,728 59,834 344,348 1,098,086 1,573,375 574,270 999,104 2820 SSMID-Downtown District - 354,385 - 354,385 - - - - Debt Service Fund 5*** Debt Service 7,232,185 13,288,394 1,084,336 13,469,600 - 8,135,315 1,610,297 6,525,017 Enterprise Funds 710* Parking 11,082,223 8,779,326 3,100,821 6,512,108 3,931,131 12,519,131 5,500,000 7,019,131 715* Mass Transit 6,427,042 8,480,979 3,376,455 11,965,119 - 6,319,357 351,620 5,967,737 720* Wastewater 25,193,871 13,115,285 6,184,314 15,755,953 7,995,607 20,741,910 9,990,706 10,751,204 730* Water 18,111,079 9,827,060 1,816,711 14,277,918 3,434,470 12,042,461 3,599,800 8,442,661 7400 Refuse Collection 1,351,518 3,521,446 1,324 3,106,440 486,141 1,281,706 - 1,281,706 750* Landfill 26,735,286 6,848,404 1,067,314 4,798,723 2,950,192 26,902,088 24,255,563 2,646,526 7600 Airport 308,219 385,582 109,687 489,619 118,597 195,273 100,000 95,273 7700 Storm Water 1,031,911 1,589,311 250 497,954 1,327,568 795,950 - 795,950 79** Housing Authority 6,756,668 9,620,510 29,287 9,310,382 46,779 7,049,304 3,150,222 3,899,082 Capital Project Funds Governmental Projects 43,433,631 12,829,564 19,215,427 32,115,760 24,878 43,337,985 - 43,337,985 Enterprise Projects 13,294,586 1,903,401 5,081,790 9,296,178 976,988 10,006,611 - 10,006,611 Total Budgetary Funds 211,373,048$ 165,488,374$ 52,675,581$ 185,241,616$ 51,222,401$ 193,072,986$ 55,845,561$ 137,227,425$ Non-Budgetary Funds Capital Project Funds Internal Service Projects -$ -$ -$ -$ -$ -$ -$ -$ Internal Service Funds 810* Equipment 13,165,375 6,910,467 78,088 5,044,114 1,508,088 13,601,728 12,637,846 963,882 8200 Risk Management 3,803,525 1,707,274 - 1,947,564 - 3,563,234 - 3,563,234 830* Information Technology 2,539,463 2,294,690 282,494 2,034,623 282,494 2,799,530 322,244 2,477,286 8400 Central Services 708,450 228,890 - 188,468 23,180 725,692 - 725,692 8500 Health Insurance Reserves 10,821,196 8,401,738 - 7,898,767 - 11,324,166 4,844,311 6,479,855 8600 Dental Insurance Reserves 147,348 407,695 - 364,128 - 190,915 - 190,915 Total Non-Budgetary Funds 31,185,356$ 19,950,754$ 360,582$ 17,477,664$ 1,813,762$ 32,205,266$ 17,804,401$ 14,400,865$ Total All Funds 242,558,405$ 185,439,128$ 53,036,163$ 202,719,280$ 53,036,163$ 225,278,252$ 73,649,962$ 151,628,290$ City of Iowa City Fund Summary Fiscal Year 2018 through June 30, 2018 33 2017 Actual 2018 Budget 2018 Revised 2018 Actual Variance Percent Budgetary Fund Revenues General Fund 10** General Fund 51,151,026$ 51,270,355$ 52,789,380$ 51,254,454$ (1,534,926)$ 97.1% Special Revenue Funds 2100 Community Dev Block Grant 1,020,981 693,031 879,069 641,018 (238,051) 72.9% 2110 HOME 305,087 486,444 1,134,122 653,951 (480,171) 57.7% 2200 Road Use Tax Fund 8,803,148 8,393,630 8,393,630 7,245,572 (1,148,058) 86.3% 2300 Other Shared Revenue 577,060 - 348,153 249,786 (98,367) 71.7% 2350 Metro Planning Org of Johnson Co 295,966 306,820 306,820 268,959 (37,861) 87.7% 2400 Employee Benefits 11,145,984 11,496,472 11,496,472 11,668,231 171,759 101.5% 2500 Affordable Housing Fund 3,926 - 404,360 415,749 11,389 102.8% 2510 Peninsula Apartments 77,516 74,155 74,155 73,278 (877) 98.8% 26** Tax Increment Financing 2,230,731 2,333,912 2,454,719 2,473,728 19,009 100.8% 2820 SSMID-Downtown District 318,343 355,350 355,350 354,385 (965) 99.7% Debt Service Fund 5*** Debt Service 14,353,841 13,223,418 13,223,418 13,288,394 64,976 100.5% Enterprise Funds 710* Parking 5,527,930 5,922,530 8,601,699 8,779,326 177,627 102.1% 715* Mass Transit 4,812,638 4,193,204 8,040,687 8,480,979 440,292 105.5% 720* Wastewater 17,883,190 12,589,340 12,589,340 13,115,285 525,945 104.2% 730* Water 14,934,666 9,268,096 9,309,236 9,827,060 517,824 105.6% 7400 Refuse Collection 3,159,783 3,411,689 3,411,689 3,521,446 109,757 103.2% 750* Landfill 7,089,948 6,234,063 6,255,063 6,848,404 593,341 109.5% 7600 Airport 348,499 359,500 359,500 385,582 26,082 107.3% 7700 Storm Water 1,688,423 1,483,550 1,483,550 1,589,311 105,761 107.1% 79** Housing Authority 9,103,051 8,769,397 9,034,397 9,620,510 586,113 106.5% Capital Project Funds Governmental Projects 34,506,605 16,997,084 16,748,987 12,829,564 (3,919,423) 76.6% Enterprise Projects 4,492,040 3,529,110 2,080,681 1,903,401 (177,280) 91.5% Total Budgetary Revenues 193,830,381$ 161,391,150$ 169,774,477$ 165,488,374$ (4,286,103)$ 97.5% Non-Budgetary Fund Revenues Capital Project Funds Internal Service Projects 174$ -$ -$ -$ -$ 0.0% Internal Service Funds 810* Equipment 6,099,982 6,106,291 6,139,844 6,910,467 770,623 112.6% 8200 Risk Management 1,625,495 1,600,954 1,600,954 1,707,274 106,320 106.6% 830* Information Technology 2,147,457 2,270,295 2,270,295 2,294,690 24,395 101.1% 8400 Central Services 241,819 239,151 205,948 228,890 22,942 111.1% 8500 Health Insurance Reserves 8,136,943 8,746,421 8,746,421 8,401,738 (344,683) 96.1% 8600 Dental Insurance Reserves 384,243 396,674 396,674 407,695 11,021 102.8% Total Non-Budgetary Revenues 18,636,114$ 19,359,786$ 19,360,136$ 19,950,754$ 590,618$ 103.1% Total Revenues - All Funds 212,466,494$ 180,750,936$ 189,134,613$ 185,439,128$ (3,695,485)$ 98.0% City of Iowa City Revenues by Fund Fiscal Year 2018 through June 30, 2018 4 2017 Actual 2018 Budget 2018 Revised 2018 Actual Variance Percent Budgetary Fund Revenues Property Taxes 55,357,358$ 56,458,399$ 56,458,399$ 56,525,799$ 67,400$ 100.1% Other City Taxes: TIF Revenues 2,226,302 2,333,912 2,454,719 2,459,216 4,497 100.2% Gas/Electric Excise Taxes 726,457 681,149 681,149 684,299 3,150 100.5% Mobile Home Taxes 65,153 65,480 65,480 61,182 (4,298) 93.4% Hotel/Motel Taxes 1,136,712 1,078,760 1,136,260 781,258 (355,002) 68.8% Utility Franchise Tax 939,387 895,000 895,000 978,214 83,214 109.3% Subtotal 5,094,011 5,054,301 5,232,608 4,964,169 (268,439) 94.9% Licenses, Permits, & Fees: General Use Permits 104,296 82,510 82,510 71,654 (10,857) 86.8% Food & Liquor Licenses 111,438 92,740 92,740 110,377 17,637 119.0% Professional License 12,015 18,710 18,710 7,605 (11,105) 40.6% Franchise Fees 685,659 692,140 692,140 361,370 (330,770) 52.2% Construction Permits & Insp Fees 2,578,024 1,639,240 1,639,240 1,846,793 207,553 112.7% Misc Lic & Permits 39,951 36,320 36,320 40,881 4,561 112.6% Subtotal 3,531,383 2,561,660 2,561,660 2,438,679 (122,981) 95.2% Intergovernmental: Fed Intergovernment Revenue 12,147,485 14,280,110 15,692,449 11,897,504 (3,794,945) 75.8% Property Tax Credits 1,590,863 1,603,881 1,603,881 1,554,683 (49,198) 96.9% Road Use Tax 8,672,279 8,320,120 8,320,120 7,132,132 (1,187,988) 85.7% State 28E Agreements 1,813,044 1,687,575 1,687,575 2,003,939 316,364 118.7% Operating Grants 139,474 81,850 81,850 73,825 (8,025) 90.2% Disaster Assistance 217,718 - 34,815 110,085 75,270 316.2% Other State Grants 12,999,581 2,295,514 6,798,270 6,457,307 (340,963) 95.0% Local 28E Agreements 1,418,467 1,005,860 1,005,860 1,331,068 325,208 132.3% Subtotal 38,998,911 29,274,910 35,224,820 30,560,544 (4,664,276) 86.8% Charges For Fees And Services: Building & Development 969,936 445,620 829,980 908,376 78,396 109.4% Police Services 143,562 37,237 37,237 127,496 90,259 342.4% Animal Care Services 11,545 10,400 10,400 10,775 375 103.6% Fire Services 10,370 8,660 8,660 7,632 (1,029) 88.1% Transit Fees 1,260,923 1,299,190 1,299,190 1,135,863 (163,327) 87.4% Culture & Recreation 780,147 820,454 820,454 774,778 (45,676) 94.4% Misc Charges For Services 72,138 68,628 68,628 69,449 821 101.2% Water Charges 9,279,458 9,102,056 9,143,196 9,475,186 331,990 103.6% Wastewater Charges 12,276,259 12,214,720 12,214,720 12,621,036 406,316 103.3% Refuse Charges 3,588,837 3,772,349 3,772,349 4,007,077 234,728 106.2% Landfill Charges 6,273,574 5,686,860 5,686,860 5,756,484 69,624 101.2% Storm Water Charges 1,522,294 1,477,710 1,477,710 1,551,384 73,674 105.0% Parking Charges 5,910,725 6,319,394 6,319,394 6,922,415 603,021 109.5% Subtotal 42,099,767 41,263,278 41,688,778 43,367,951 1,679,173 104.0% Miscellaneous: Code Enforcement 238,295 253,180 253,180 204,181 (48,999) 80.6% Parking Fines 578,713 549,580 549,580 475,356 (74,224) 86.5% Library Fines & Fees 154,425 155,520 155,520 143,285 (12,235) 92.1% Contributions & Donations 705,917 377,972 796,072 707,404 (88,669) 88.9% Printed Materials 43,411 48,400 48,400 42,374 (6,026) 87.6% Animal Adoption 12,015 14,190 14,190 12,955 (1,235) 91.3% Misc Merchandise 55,052 54,930 54,930 55,901 971 101.8% Intra-City Charges 3,795,296 4,226,884 4,226,884 3,962,198 (264,686) 93.7% Other Misc Revenue 2,118,650 779,349 956,349 877,141 (79,208) 91.7% Special Assessments 1,087 1,000 1,000 808 (192) 80.8% Subtotal 7,702,861$ 6,461,005$ 7,056,105$ 6,481,603$ (574,502)$ 91.9% City of Iowa City Revenues by Type Fiscal Year 2018 through June 30, 2018 55 2017 Actual 2018 Budget 2018 Revised 2018 Actual Variance Percent City of Iowa City Revenues by Type Fiscal Year 2018 through June 30, 2018 Use Of Money And Property: Interest Revenues 1,551,921$ 1,022,383$ 1,022,763$ 2,879,005$ 1,856,242$ 281.5% Rents 1,370,376 1,307,630 1,317,630 1,402,131 84,501 106.4% Royalties & Commissions 140,491 94,950 98,950 108,843 9,893 110.0% Subtotal 3,062,788 2,424,963 2,439,343 4,389,979 1,950,636 180.0% Other Financial Sources: Debt Sales 33,795,498 14,671,084 11,753,500 12,174,462 420,962 103.6% Sale Of Assets 3,081,294 1,956,508 5,829,222 3,628,506 (2,200,716) 62.2% Insurance Recoveries - - 265,000 - (265,000) 0.0% Loans 1,106,510 1,265,042 1,265,042 956,682 (308,360) 75.6% Subtotal 37,983,302 17,892,634 19,112,764 16,759,651 (2,353,113) 87.7% Total Budgetary Revenues 193,830,381$ 161,391,150$ 169,774,477$ 165,488,374$ (4,286,103) 97.5% Non-Budgetary Fund Revenues Capital Project Funds 174$ -$ -$ -$ -$ 0.0% Internal Service Funds 18,635,940 19,359,786 19,360,136 19,950,754 590,618 103.1% Total Non-Budgetary Revenues 18,636,114$ 19,359,786$ 19,360,136$ 19,950,754$ 590,618$ 103.1% Total Revenues - All Funds 212,466,494$ 180,750,936$ 189,134,613$ 185,439,128$ (3,695,485)$ 98.0% 66 2017 Actual 2018 Budget 2018 Revised 2018 Actual Variance Percent Budgetary Fund Expenditures General Fund 10** General Fund 51,413,370$ 56,552,008$ 57,996,141$ 53,385,236$ 4,610,905$ 92.0% Special Revenue Funds 2100 Community Dev Block Grant 1,390,132 568,686 754,724 592,163 162,561 78.5% 2110 HOME 192,082 465,444 1,113,122 558,825 554,297 50.2% 2200 Road Use Tax Fund 5,262,429 6,221,226 6,511,226 6,059,055 452,171 93.1% 2300 Other Shared Revenue 652,152 - 375,158 333,251 41,907 88.8% 2350 Metro Planning Org of Johnson Co. 609,907 633,977 633,977 591,338 42,639 93.3% 2400 Employee Benefits 868,301 1,243,475 1,243,475 1,051,619 191,856 84.6% 2500 Affordable Housing Fund 500,000 650,000 650,000 325,000 325,000 50.0% 2510 Peninsula Apartments 59,023 53,557 53,557 50,641 2,916 94.6% 26** Tax Increment Financing - 332,365 332,373 344,348 (11,975) 103.6% 2820 SSMID-Downtown District 318,343 355,350 355,350 354,385 965 99.7% Debt Service Fund 5*** Debt Service 15,218,289 14,256,417 13,564,492 13,469,600 94,892 99.3% Enterprise Funds 720* Wastewater 21,260,750 10,601,444 15,906,007 15,755,953 150,054 99.1% 730* Water 12,372,374 8,465,881 14,350,660 14,277,918 72,742 99.5% 7400 Refuse Collection 3,053,376 3,427,206 3,427,206 3,106,440 320,766 90.6% 750* Landfill 4,973,964 4,902,903 5,087,330 4,798,723 288,607 94.3% 7600 Airport 665,802 369,187 406,937 489,619 (82,682) 120.3% 7700 Storm Water 747,069 518,983 518,983 497,954 21,029 95.9% 79** Housing Authority 8,651,207 8,201,363 8,496,390 9,310,382 (813,992) 109.6% Capital Project Funds Governmental Projects 32,902,808 32,530,291 77,562,677 32,115,760 45,446,917 41.4% Enterprise Projects 3,657,836 8,825,015 19,187,686 9,296,178 9,891,509 48.4% Total Budgetary Expenditures 175,931,866$ 173,318,414$ 247,645,310$ 185,241,616$ 62,403,694$ 74.8% Non-Budgetary Funds Expenditures Capital Project Funds Internal Service Projects 61,633$ -$ -$ -$ -$ 0.0% Internal Service Funds 810* Equipment 4,683,979 4,543,387 5,537,501 5,044,114 493,387 91.1% 8200 Risk Management 1,236,127 1,472,081 1,472,081 1,947,564 (475,483) 132.3% 830* Information Technology 1,624,715 2,217,207 2,217,207 2,034,623 182,584 91.8% 8400 Central Services 201,065 262,163 228,960 188,468 40,492 82.3% 8500 Health Insurance Reserves 7,218,542 8,341,355 8,341,355 7,898,767 442,588 94.7% 8600 Dental Insurance Reserves 374,002 399,386 399,386 364,128 35,258 91.2% Total Non-Budgetary Expenditures 15,400,061$ 17,235,579$ 18,196,490$ 17,477,664$ 718,826$ 96.0% Total Expenditures - All Funds 191,331,927$ 190,553,993$ 265,841,800$ 202,719,280$ 63,122,520$ 76.3% City of Iowa City Expenditures by Fund Fiscal Year 2018 through June 30, 2018 7 2017 Actual 2018 Budget 2018 Revised 2018 Actual Variance Percent Budgetary Funds Expenditures General Fund 10** General Fund City Council 110,152$ 108,590$ 113,859$ 109,461$ 4,398$ 96.1% City Clerk 500,977 595,728 617,503 491,517 125,986 79.6% City Attorney 733,337 762,815 762,815 765,417 (2,602) 100.3% City Manager 2,148,884 4,087,474 3,738,272 3,001,583 736,689 80.3% Finance 3,655,228 4,349,981 4,544,193 4,529,935 14,258 99.7% Police 13,114,628 13,827,954 13,966,854 13,804,183 162,671 98.8% Fire 7,716,864 8,169,242 8,209,242 8,030,580 178,662 97.8% Parks & Recreation 7,812,840 8,139,582 8,358,215 7,990,780 367,435 95.6% Library 6,269,424 6,526,560 6,561,560 6,406,350 155,210 97.6% Senior Center 899,254 949,924 972,055 888,508 83,547 91.4% Neighborhood & Development Services 6,074,193 5,788,055 6,888,970 4,969,099 1,919,871 72.1% Public Works 1,757,925 2,384,366 2,400,866 1,909,621 491,245 79.5% Transportation & Resource Management 619,664 861,737 861,737 488,203 373,535 56.7% Total General Fund 51,413,370 56,552,008 57,996,141 53,385,236 4,610,905 92.0% Special Revenue Funds 2100 Community Dev Block Grant Neighborhood & Development Services 1,390,132 568,686 754,724 592,163 162,561 78.5% 2110 HOME Neighborhood & Development Services 192,082 465,444 1,113,122 558,825 554,297 50.2% 2200 Road Use Tax Fund Public Works 5,262,429 6,221,226 6,511,226 6,059,055 452,171 93.1% 2300 Other Shared Revenue Neighborhood & Development Services 652,152 - 375,158 333,251 41,907 88.8% 2350 Metro Planning Org of Johnson Co Neighborhood & Development Services 609,907 633,977 633,977 591,338 42,639 93.3% 2400 Employee Benefits Finance 868,301 1,243,475 1,243,475 1,051,619 191,856 84.6% 2500 Affordable Housing Fund Neighborhood & Development Services 500,000 650,000 650,000 325,000 325,000 50.0% 2510 Peninsula Apartments Neighborhood & Development Services 59,023 53,557 53,557 50,641 2,916 94.6% 26** Tax Increment Financing Finance - 332,365 332,373 344,348 (11,975) 103.6% 2820 SSMID-Downtown District Finance 318,343 355,350 355,350 354,385 965 99.7% Total Special Revenue Funds 9,852,369 10,524,080 12,022,962 10,260,625 1,762,337 85.3% Debt Service Fund 5*** Debt Service Finance 15,218,289 14,256,417 13,564,492 13,469,600 94,892 99.3% Total Debt Service Fund 15,218,289 14,256,417 13,564,492 13,469,600 94,892 99.3% City of Iowa City Expenditures by Fund by Department Fiscal Year 2018 through June 30, 2018 88 2017 Actual 2018 Budget 2018 Revised 2018 Actual Variance Percent City of Iowa City Expenditures by Fund by Department Fiscal Year 2018 through June 30, 2018 Enterprise Funds 710* Parking Transportation & Resource Management 4,235,036$ 6,941,622$ 7,055,622$ 6,512,108$ 543,514$ 92.3% 715* Mass Transit Transportation & Resource Management 6,927,616 7,202,014 12,062,217 11,965,119 97,098 99.2% 720* Wastewater Public Works 21,260,750 10,601,444 15,906,007 15,755,953 150,054 99.1% 730* Water Public Works 12,372,374 8,465,881 14,350,660 14,277,918 72,742 99.5% 7400 Refuse Collection Transportation & Resource Management 3,053,376 3,427,206 3,427,206 3,106,440 320,766 90.6% 750* Landfill Transportation & Resource Management 4,973,964 4,902,903 5,087,330 4,798,723 288,607 94.3% 7600 Airport Airport Operations 665,802 369,187 406,937 489,619 (82,682) 120.3% 7700 Storm Water Public Works 747,069 518,983 518,983 497,954 21,029 95.9% 79** Housing Authority Neighborhood & Development Services 8,651,207 8,201,363 8,496,390 9,310,382 (813,992) 109.6% Total Enterprise Funds 62,887,194 50,630,603 67,311,352 66,714,217 597,135 99.1% Capital Project Funds Governmental Projects 32,902,808 32,530,291 77,562,677 32,115,760 45,446,917 41.4% Enterprise Projects 3,657,836 8,825,015 19,187,686 9,296,178 9,891,509 48.4% Total Capital Project Funds 36,560,644 41,355,306 96,750,363 41,411,937 55,338,426 42.8% Total Budgetary Expenditures 175,931,866$ 173,318,414$ 247,645,310$ 185,241,616$ 62,403,694$ 74.8% Non-Budgetary Funds Expenditures Capital Project Funds Internal Service Projects 61,633$ -$ -$ -$ -$ 0.0% Total Capital Project Funds 61,633 - - - - 0.0% Internal Service Funds 810* Equipment Public Works 4,683,979 4,543,387 5,537,501 5,044,114 493,387 91.1% 8200 Risk Management Finance 1,236,127 1,472,081 1,472,081 1,947,564 (475,483) 132.3% 830* Information Technology Finance 1,624,715 2,217,207 2,217,207 2,034,623 182,584 91.8% 8400 Central Services Finance 201,065 262,163 228,960 188,468 40,492 82.3% 8500 Health Insurance Reserves Finance 7,218,542 8,341,355 8,341,355 7,898,767 442,588 94.7% 8600 Dental Insurance Reserves Finance 374,002 399,386 399,386 364,128 35,258 91.2% Total Internal Service Funds 15,338,429 17,235,579 18,196,490 17,477,664 718,826 96.0% Total Non-Budgetary Expenditures 15,400,061$ 17,235,579$ 18,196,490$ 17,477,664$ 718,826$ 96.0% Total Expenditures - All Funds 191,331,927$ 190,553,993$ 265,841,800$ 202,719,280$ 63,122,520$ 76.3% 99