Loading...
FY2019 4th Qtr Financial SummaryDate: August 27, 2019 To: City Manager, City Council From: Jacklyn Fleagle, Budget & Compliance Officer Re: Quarterly Financial Summary for Period Ending June 30, 2019 Introduction Attached to this memorandum are the City’s quarterly financial reports as of June 30, 2019. The quarterly financial report includes combined summaries of all fund balances, revenues, and expenditures for fiscal year 2019 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 100.4%, the Road Use Tax Fund is at 102.4%, the Employee Benefits Fund is at 99.2%, and the Debt Service Fund is at 101.2%. 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 96.7% and 108.2%. The Water Fund finished with revenues at 96.7% of budget, the Housing Authority Fund at 108.2% of budget and the Wastewater Fund at 99.8% of budget. Some large accruals have yet to be made within the major enterprise funds for unbilled services and receivables at year end. The major enterprise funds will finish the year with revenues close to or 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 57.5%, the HOME Fund at 69.7%, the Other Shared Revenue Fund at 6.8%, and the Metro Planning Org of Johnson County at 87.3%. Additionally, both the Governmental Projects and the Enterprise Projects Capital Funds are significantly below budget at 52.7% and 41.8%, respectively. 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 $167,095,475 or 92.2% of budget. The budget shortfall of $14,108,830 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. 1 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 2019 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 91.6% and the Debt Service Fund is at 99.1%; however, the Road Use Tax Fund is at 102.3% primarily due to vehicle chargebacks. The same is true for most of the City’s enterprise funds; however, the Airport fund finished at 111.3% primarily due to non-contracted improvements and minor equipment purchases. Additionally, the Health Insurance Fund is at 111.6% 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 (78.0%), the CDBG Fund (69.1%), and the Other Shared Revenues Fund (39.1%). Also, well below budget are the Governmental Projects Fund (47.5%), and the Enterprise Projects Fund (36.8%). 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 2020 budget. The combined total actual expenditures for all budgetary funds through June are $179,796,315 or 74.6% of budget. When the capital project funds and the HOME, CDBG, and Other Shared Revenues funds are removed from the calculation, the actual percentage of expenditures versus budget increases to 91.8%. 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. Four funds, the Community Development Block Grant (CDBG), HOME, Other Shared Revenue and SSMID funds, are presented (on page 3) with negative fund balances at -$58,211, -$8,342, -$11,623 and -$4,118, respectively. These negative fund balances should be reversed following the next receipt of CDBG funds and FEMA funds for Hazard Mitigation. The SSMID fund negative balance will reverse once accrual entries have been made. 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 2021 budget process in October. Additional information is available from the Finance Department upon request. 2 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 36,401,765$ 55,598,361$ 14,070,366$ 55,389,965$ 11,961,397$ 38,719,131$ 8,997,721$ 29,721,410$ Special Revenue Funds 2100 Community Dev Block Grant (25,935) 700,724 2,700 628,016 107,684 (58,211) - (58,211) 2110 HOME 191,819 705,761 - 799,452 106,470 (8,342) - (8,342) 2200 Road Use Tax Fund 3,893,384 8,955,769 451,026 6,678,035 3,283,213 3,338,931 - 3,338,931 2300 Other Shared Revenue 3,968 3,279 - 18,870 - (11,623) - (11,623) 2350 Metro Planning Org of J.C. 262,063 319,278 333,028 618,626 - 295,743 - 295,743 2400 Employee Benefits 2,847,078 12,802,124 - 806,781 10,931,231 3,911,190 - 3,911,190 2500 Affordable Housing Fund 1,208,851 422,309 1,000,000 995,422 - 1,635,738 - 1,635,738 2510 Peninsula Apartments 166,019 70,805 - 55,633 - 181,192 - 181,192 26** Tax Increment Financing 1,525,592 2,582,885 175,780 377,472 2,903,769 1,003,017 945,388 57,629 2820 SSMID-Downtown District - 393,612 - 397,730 - (4,118) - (4,118) Debt Service Fund 5*** Debt Service 8,135,315 12,768,447 1,958,773 13,678,214 - 9,184,319 2,230,153 6,954,166 Enterprise Funds 710* Parking 12,222,373 6,490,304 1,021,221 6,505,764 1,705,581 11,522,552 3,790,663 7,731,889 715* Mass Transit 6,159,101 4,843,853 6,563,749 7,415,953 3,235,099 6,915,651 3,777,476 3,138,175 720* Wastewater 20,759,108 12,614,948 4,207,127 12,616,015 4,991,683 19,973,485 6,245,068 13,728,418 730* Water 11,938,239 9,530,987 1,827,668 8,319,678 2,967,542 12,009,674 3,634,174 8,375,500 7400 Refuse Collection 1,281,369 3,491,493 5,499 3,440,787 - 1,337,575 - 1,337,575 750* Landfill 26,940,545 6,990,254 1,737,246 6,064,100 4,822,894 24,781,052 22,387,426 2,393,626 7600 Airport 216,770 367,258 100,000 397,817 43,264 242,946 100,000 142,946 7700 Storm Water 795,950 1,497,221 1,036 451,277 1,009,000 833,930 - 833,930 79** Housing Authority 7,017,559 10,293,528 106,470 10,002,676 47,949 7,366,931 3,268,537 4,098,394 Capital Project Funds Governmental Projects 41,854,944 14,137,644 12,693,808 38,582,511 - 30,103,885 - 30,103,885 Enterprise Projects 9,623,259 1,514,631 3,539,218 5,555,520 1,275,000 7,846,588 - 7,846,588 Total Budgetary Funds 193,419,135$ 167,095,475$ 49,794,715$ 179,796,315$ 49,391,774$ 181,121,236$ 55,376,606$ 125,744,630$ Non-Budgetary Funds Internal Service Funds 810* Equipment 13,604,405$ 7,300,114$ (258,485)$ 5,051,384$ (135,285)$ 15,729,935$ 13,803,862$ 1,926,073$ 8200 Risk Management 3,563,234 1,671,941 - 1,351,299 - 3,883,876 - 3,883,876 830* Information Technology 2,799,530 2,444,853 (504,734) 2,071,747 (324,993) 2,992,895 708,924 2,283,971 8400 Central Services 725,692 252,275 - 176,149 100,000 701,819 - 701,819 8500 Health Insurance Reserves 11,374,744 8,887,214 - 9,351,135 - 10,910,823 7,589,740 3,321,083 8600 Dental Insurance Reserves 190,915 411,909 - 344,357 - 258,467 - 258,467 Total Non-Budgetary Funds 32,258,521$ 20,968,305$ (763,219)$ 18,346,071$ (360,278)$ 34,477,814$ 22,102,526$ 12,375,288$ Total All Funds 225,677,656$ 188,063,780$ 49,031,496$ 198,142,386$ 49,031,496$ 215,599,050$ 77,479,132$ 138,119,918$ City of Iowa City Fund Summary Fiscal Year 2019 through June 30, 2019 3 2018 Actual 2019 Budget 2019 Revised 2019 Actual Variance Percent Budgetary Fund Revenues General Fund 10** General Fund 51,880,377$ 53,148,922$ 55,383,255$ 55,598,361$ 215,106$ 100.4% Special Revenue Funds 2100 Community Dev Block Grant 658,178 906,507 1,218,413 700,724 (517,689) 57.5% 2110 HOME 666,926 534,166 1,012,382 705,761 (306,621) 69.7% 2200 Road Use Tax Fund 8,539,943 8,744,810 8,744,810 8,955,769 210,959 102.4% 2300 Other Shared Revenue 270,089 - 48,260 3,279 (44,981) 6.8% 2350 Metro Planning Org of Johnson Co 320,459 365,748 365,748 319,278 (46,470) 87.3% 2400 Employee Benefits 11,668,231 12,908,880 12,908,880 12,802,124 (106,756) 99.2% 2500 Affordable Housing Fund 415,749 - 404,360 422,309 17,949 104.4% 2510 Peninsula Apartments 73,278 77,510 77,510 70,805 (6,705) 91.4% 26** Tax Increment Financing 2,473,728 2,631,772 2,631,772 2,582,885 (48,887) 98.1% 2820 SSMID-Downtown District 354,385 400,124 400,124 393,612 (6,512) 98.4% Debt Service Fund 5*** Debt Service 13,288,394 12,611,282 12,611,282 12,768,447 157,165 101.2% Enterprise Funds 710* Parking 8,486,558 6,003,966 6,045,966 6,490,304 444,338 107.3% 715* Mass Transit 8,276,309 4,524,070 4,524,070 4,843,853 319,783 107.1% 720* Wastewater 13,115,285 12,636,588 12,636,588 12,614,948 (21,640) 99.8% 730* Water 9,827,060 9,856,522 9,856,522 9,530,987 (325,535) 96.7% 7400 Refuse Collection 3,521,446 3,490,210 3,490,210 3,491,493 1,283 100.0% 750* Landfill 7,028,785 6,929,796 7,019,796 6,990,254 (29,542) 99.6% 7600 Airport 385,582 361,500 361,500 367,258 5,758 101.6% 7700 Storm Water 1,589,311 1,529,350 1,529,350 1,497,221 (32,129) 97.9% 79** Housing Authority 9,620,510 8,921,473 9,511,135 10,293,528 782,393 108.2% Capital Project Funds Governmental Projects 12,981,814 14,023,000 26,801,555 14,137,644 (12,663,911) 52.7% Enterprise Projects 1,919,909 3,056,708 3,620,817 1,514,631 (2,106,186) 41.8% Total Budgetary Revenues 167,362,305$ 163,662,904$ 181,204,305$ 167,095,475$ (14,108,830)$ 92.2% Non-Budgetary Fund Revenues Internal Service Funds 810* Equipment 6,910,467$ 6,559,773$ 6,619,773$ 7,300,114$ 680,341$ 110.3% 8200 Risk Management 1,707,274 1,596,490 1,596,490 1,671,941 75,451 104.7% 830* Information Technology 2,294,690 2,348,876 2,348,876 2,444,853 95,977 104.1% 8400 Central Services 228,890 213,912 213,912 252,275 38,363 117.9% 8500 Health Insurance Reserves 8,401,738 8,700,966 8,700,966 8,887,214 186,248 102.1% 8600 Dental Insurance Reserves 407,695 424,330 424,330 411,909 (12,421) 97.1% Total Non-Budgetary Revenues 19,950,754$ 19,844,347$ 19,904,347$ 20,968,305$ 1,063,958$ 105.3% Total Revenues - All Funds 187,313,059$ 183,507,251$ 201,108,652$ 188,063,780$ (13,044,872)$ 93.5% City of Iowa City Revenues by Fund Fiscal Year 2019 through June 30, 2019 4 2018 Actual 2019 Budget 2019 Revised 2019 Actual Variance Percent Budgetary Fund Revenues Property Taxes 56,525,799$ 59,173,825$ 59,173,825$ 58,901,749$ (272,076)$ 99.5% Other City Taxes: TIF Revenues 2,459,216 2,621,772 2,621,772 2,549,074 (72,698) 97.2% Gas/Electric Excise Taxes 684,299 676,411 676,411 667,713 (8,698) 98.7% Mobile Home Taxes 61,182 65,150 65,150 56,442 (8,708) 86.6% Hotel/Motel Taxes 1,045,696 1,251,720 1,251,720 942,515 (309,205) 75.3% Utility Franchise Tax 976,060 939,400 939,400 964,690 25,290 102.7% Subtotal 5,226,452 5,554,453 5,554,453 5,180,433 (374,020) 93.3% Licenses, Permits, & Fees: General Use Permits 71,654 100,920 100,920 86,756 (14,165) 86.0% Food & Liquor Licenses 110,377 111,440 111,440 126,709 15,269 113.7% Professional License 7,605 12,020 12,020 6,150 (5,870) 51.2% Franchise Fees 662,448 512,750 512,750 441,076 (71,674) 86.0% Construction Permits & Insp Fees 1,850,539 1,777,650 1,777,650 2,141,423 363,773 120.5% Misc Lic & Permits 40,881 38,680 38,680 58,608 19,928 151.5% Subtotal 2,743,504 2,553,460 2,553,460 2,860,722 307,262 112.0% Intergovernmental: Fed Intergovernment Revenue 13,152,242 11,664,896 15,373,782 13,180,178 (2,193,604) 85.7% Property Tax Credits 1,554,683 1,727,320 1,727,320 1,559,040 (168,280) 90.3% Road Use Tax 8,426,502 8,672,280 8,672,280 8,820,138 147,858 101.7% State 28E Agreements 2,003,939 1,724,430 1,774,430 2,060,750 286,320 116.1% Operating Grants 73,825 82,690 82,690 69,584 (13,106) 84.2% Disaster Assistance 110,085 - - - - 0.0% Other State Grants 5,483,837 3,094,020 9,131,736 2,179,249 (6,952,487) 23.9% Local 28E Agreements 1,151,557 5,182,453 5,182,453 1,266,621 (3,915,832) 24.4% Subtotal 31,956,672 32,148,089 41,944,691 29,135,560 (12,809,131) 69.5% Charges For Fees And Services: Building & Development 908,376 411,120 888,930 1,217,279 328,349 136.9% Police Services 127,496 56,530 126,530 143,643 17,113 113.5% Animal Care Services 10,775 11,540 11,540 14,922 3,382 129.3% Fire Services 7,632 10,370 10,370 9,060 (1,310) 87.4% Transit Fees 1,226,643 1,261,820 1,261,820 1,220,379 (41,441) 96.7% Culture & Recreation 774,778 790,848 790,848 767,966 (22,882) 97.1% Misc Charges For Services 69,449 79,217 79,217 69,454 (9,763) 87.7% Water Charges 9,475,186 9,743,172 9,743,172 9,112,342 (630,830) 93.5% Wastewater Charges 12,621,036 12,276,650 12,276,650 12,026,097 (250,553) 98.0% Refuse Charges 4,010,218 3,909,630 3,909,630 3,827,862 (81,768) 97.9% Landfill Charges 5,933,293 6,168,980 6,168,980 5,775,786 (393,194) 93.6% Storm Water Charges 1,551,384 1,522,290 1,522,290 1,470,213 (52,077) 96.6% Parking Charges 6,331,040 6,477,470 6,477,470 7,138,739 661,269 110.2% Subtotal 43,047,304 42,719,637 43,267,447 42,793,742 (473,705) 98.9% Miscellaneous: Code Enforcement 232,315 222,633 222,633 278,070 55,437 124.9% Parking Fines 475,356 578,720 578,720 602,260 23,540 104.1% Library Fines & Fees 143,285 154,420 154,420 135,183 (19,237) 87.5% Contributions & Donations 890,423 369,620 768,950 396,459 (372,491) 51.6% Printed Materials 42,374 41,900 41,900 51,279 9,379 122.4% Animal Adoption 12,955 12,020 12,020 45,839 33,819 381.4% Misc Merchandise 55,901 54,770 54,770 57,232 2,462 104.5% Intra-City Charges 3,962,198 4,277,635 4,277,635 4,428,621 150,986 103.5% Other Misc Revenue 908,993 933,261 1,168,897 838,620 (330,277) 71.7% Special Assessments 808 1,090 1,090 94 (996) 8.6% Subtotal 6,724,608$ 6,646,069$ 7,281,035$ 6,833,657$ (447,378)$ 93.9% City of Iowa City Revenues by Type Fiscal Year 2019 through June 30, 2019 5 2018 Actual 2019 Budget 2019 Revised 2019 Actual Variance Percent City of Iowa City Revenues by Type Fiscal Year 2019 through June 30, 2019 Use Of Money And Property: Interest Revenues 2,879,005$ 1,071,871$ 1,373,872$ 4,198,581$ 2,824,709$ 305.6% Rents 1,385,468 1,367,800 1,367,800 1,305,363 (62,437) 95.4% Royalties & Commissions 108,843 136,080 136,080 106,717 (29,363) 78.4% Subtotal 4,373,315 2,575,751 2,877,752 5,610,661 2,732,909 195.0% Other Financial Sources: Debt Sales 12,174,462 10,623,000 14,162,000 12,565,848 (1,596,152) 88.7% Sale Of Assets 3,633,506 703,393 2,920,018 1,586,827 (1,333,191) 54.3% Insurance Recoveries - - 316,898 279,874 (37,024) 0.0% Loans 956,682 965,226 1,152,726 1,346,402 193,676 116.8% Subtotal 16,764,651 12,291,619 18,551,642 15,778,950 (2,772,692) 85.1% Total Budgetary Revenues 167,362,305$ 163,662,903$ 181,204,305$ 167,095,475$ (14,108,830) 92.2% Non-Budgetary Fund Revenues Internal Service Funds 19,950,754$ 19,844,347$ 19,904,347$ 20,968,305$ 1,063,958$ 105.3% Total Non-Budgetary Revenues 19,950,754$ 19,844,347$ 19,904,347$ 20,968,305$ 1,063,958$ 105.3% Total Revenues - All Funds 187,313,059$ 183,507,250$ 201,108,652$ 188,063,780$ (13,044,872)$ 93.5% 6 2018 Actual 2019 Budget 2019 Revised 2019 Actual Variance Percent Budgetary Fund Expenditures General Fund 10** General Fund 52,714,597$ 58,159,421$ 60,448,795$ 55,389,965$ 5,058,830$ 91.6% Special Revenue Funds 2100 Community Dev Block Grant 592,163 596,507 908,413 628,016 280,397 69.1% 2110 HOME 558,825 546,166 1,024,382 799,452 224,930 78.0% 2200 Road Use Tax Fund 6,059,424 6,165,809 6,526,485 6,678,035 (151,550) 102.3% 2300 Other Shared Revenue 333,421 - 48,260 18,870 29,390 39.1% 2350 Metro Planning Org of Johnson Co. 591,338 708,554 708,554 618,626 89,928 87.3% 2400 Employee Benefits 967,457 1,283,417 1,283,417 806,781 476,636 62.9% 2500 Affordable Housing Fund 325,000 750,000 1,000,000 995,422 4,578 99.5% 2510 Peninsula Apartments 50,641 59,878 61,118 55,633 5,485 91.0% 26** Tax Increment Financing 392,130 505,193 620,193 377,472 242,721 60.9% 2820 SSMID-Downtown District 354,385 400,124 400,124 397,730 2,394 99.4% Debt Service Fund 5*** Debt Service 13,469,600 13,722,450 13,806,387 13,678,214 128,173 99.1% Enterprise Funds 720* Wastewater 15,738,755 13,284,732 13,284,732 12,616,015 668,717 95.0% 730* Water 14,382,141 8,388,774 8,440,774 8,319,678 121,096 98.6% 7400 Refuse Collection 3,106,776 3,433,507 3,498,007 3,440,787 57,220 98.4% 750* Landfill 4,940,648 5,035,196 6,078,392 6,064,100 14,292 99.8% 7600 Airport 468,122 357,309 357,309 397,817 (40,508) 111.3% 7700 Storm Water 497,954 537,865 537,865 451,277 86,588 83.9% 79** Housing Authority 9,342,128 10,952,156 11,429,619 10,002,676 1,426,943 87.5% Capital Project Funds Governmental Projects 32,499,396 23,580,970 81,247,520 38,582,511 42,665,009 47.5% Enterprise Projects 9,353,681 5,040,308 15,088,368 5,555,520 9,532,848 36.8% Total Budgetary Expenditures 185,175,387$ 167,570,307$ 241,145,254$ 179,796,315$ 61,348,939$ 74.6% Non-Budgetary Funds Expenditures Internal Service Funds 810* Equipment 5,041,436$ 4,468,094$ 6,263,801$ 5,051,384$ 1,212,417$ 80.6% 8200 Risk Management 1,947,564 1,440,328 1,440,328 1,351,299 89,029 93.8% 830* Information Technology 2,034,623 2,160,935 2,320,754 2,071,747 249,007 89.3% 8400 Central Services 188,468 193,387 193,387 176,149 17,238 91.1% 8500 Health Insurance Reserves 7,848,190 8,381,923 8,381,923 9,351,135 (969,212) 111.6% 8600 Dental Insurance Reserves 364,128 409,442 409,442 344,357 65,085 84.1% Total Non-Budgetary Expenditures 17,424,410$ 17,054,109$ 19,009,635$ 18,346,071$ 663,564$ 96.5% Total Expenditures - All Funds 202,599,797$ 184,624,416$ 260,154,889$ 198,142,386$ 62,012,503$ 76.2% City of Iowa City Expenditures by Fund Fiscal Year 2019 through June 30, 2019 7 2018 Actual 2019 Budget 2019 Revised 2019 Actual Variance Percent Budgetary Funds Expenditures General Fund 10** General Fund City Council 109,461$ 120,391$ 120,391$ 110,580$ 9,811$ 91.9% City Clerk 491,517 533,577 570,242 540,893 29,349 94.9% City Attorney 765,417 780,796 780,796 751,266 29,530 96.2% City Manager 3,056,803 4,248,266 4,398,266 3,865,351 532,915 87.9% Finance 3,805,542 4,345,045 4,745,145 3,949,174 795,971 83.2% Police 13,809,546 14,419,896 14,906,648 14,073,224 833,424 94.4% Fire 8,030,716 8,262,751 8,353,847 8,291,495 62,352 99.3% Parks & Recreation 7,993,287 8,826,119 8,891,119 8,188,661 702,458 92.1% Library 6,400,495 6,671,933 6,677,933 6,403,794 274,139 95.9% Senior Center 888,544 974,355 986,855 865,825 121,030 87.7% Neighborhood & Development Services 4,965,448 5,824,548 6,865,809 5,618,506 1,247,303 81.8% Public Works 1,909,621 2,554,182 2,554,182 2,105,423 448,759 82.4% Transportation & Resource Management 488,203 597,562 597,562 625,773 (28,211) 104.7% Total General Fund 52,714,597 58,159,421 60,448,795 55,389,965 5,058,830 91.6% Special Revenue Funds 2100 Community Dev Block Grant Neighborhood & Development Services 592,163 596,507 908,413 628,016 280,397 69.1% 2110 HOME Neighborhood & Development Services 558,825 546,166 1,024,382 799,452 224,930 78.0% 2200 Road Use Tax Fund Public Works 6,059,424 6,165,809 6,526,485 6,678,035 (151,550) 102.3% 2300 Other Shared Revenue Neighborhood & Development Services 333,421 - 48,260 18,870 29,390 39.1% 2350 Metro Planning Org of Johnson Co Neighborhood & Development Services 591,338 708,554 708,554 618,626 89,928 87.3% 2400 Employee Benefits Finance 967,457 1,283,417 1,283,417 806,781 476,636 62.9% 2500 Affordable Housing Fund Neighborhood & Development Services 325,000 750,000 1,000,000 995,422 4,578 99.5% 2510 Peninsula Apartments Neighborhood & Development Services 50,641 59,878 61,118 55,633 5,485 91.0% 26** Tax Increment Financing Finance 392,130 505,193 620,193 377,472 242,721 60.9% 2820 SSMID-Downtown District Finance 354,385 400,124 400,124 397,730 2,394 99.4% Total Special Revenue Funds 10,224,785 11,015,648 12,580,946 11,376,037 1,204,909 90.4% Debt Service Fund 5*** Debt Service Finance 13,469,600 13,722,450 13,806,387 13,678,214 128,173 99.1% Total Debt Service Fund 13,469,600 13,722,450 13,806,387 13,678,214 128,173 99.1% City of Iowa City Expenditures by Fund by Department Fiscal Year 2019 through June 30, 2019 8 2018 Actual 2019 Budget 2019 Revised 2019 Actual Variance Percent City of Iowa City Expenditures by Fund by Department Fiscal Year 2019 through June 30, 2019 Enterprise Funds 710* Parking Transportation & Resource Management 6,516,098$ 6,612,092$ 6,801,661$ 6,505,764$ 295,897$ 95.6% 715* Mass Transit Transportation & Resource Management 11,920,706 7,449,879 7,544,879 7,415,953 128,926 98.3% 720* Wastewater Public Works 15,738,755 13,284,732 13,284,732 12,616,015 668,717 95.0% 730* Water Public Works 14,382,141 8,388,774 8,440,774 8,319,678 121,096 98.6% 7400 Refuse Collection Transportation & Resource Management 3,106,776 3,433,507 3,498,007 3,440,787 57,220 98.4% 750* Landfill Transportation & Resource Management 4,940,648 5,035,196 6,078,392 6,064,100 14,292 99.8% 7600 Airport Airport Operations 468,122 357,309 357,309 397,817 (40,508) 111.3% 7700 Storm Water Public Works 497,954 537,865 537,865 451,277 86,588 83.9% 79** Housing Authority Neighborhood & Development Services 9,342,128 10,952,156 11,429,619 10,002,676 1,426,943 87.5% Total Enterprise Funds 66,913,328 56,051,510 57,973,238 55,214,068 2,759,170 95.2% Capital Project Funds Governmental Projects 32,499,396 23,580,970 81,247,520 38,582,511 42,665,009 47.5% Enterprise Projects 9,353,681 5,040,308 15,088,368 5,555,520 9,532,848 36.8% Total Capital Project Funds 41,853,076 28,621,278 96,335,888 44,138,031 52,197,857 45.8% Total Budgetary Expenditures 185,175,387$ 167,570,307$ 241,145,254$ 179,796,315$ 61,348,939$ 74.6% Non-Budgetary Funds Expenditures Internal Service Funds 810* Equipment Public Works 5,041,436$ 4,468,094$ 6,263,801$ 5,051,384$ 1,212,417$ 80.6% 8200 Risk Management Finance 1,947,564 1,440,328 1,440,328 1,351,299 89,029 93.8% 830* Information Technology Finance 2,034,623 2,160,935 2,320,754 2,071,747 249,007 89.3% 8400 Central Services Finance 188,468 193,387 193,387 176,149 17,238 91.1% 8500 Health Insurance Reserves Finance 7,848,190 8,381,923 8,381,923 9,351,135 (969,212) 111.6% 8600 Dental Insurance Reserves Finance 364,128 409,442 409,442 344,357 65,085 84.1% Total Internal Service Funds 17,424,410 17,054,109 19,009,635 18,346,071 663,564 96.5% Total Non-Budgetary Expenditures 17,424,410$ 17,054,109$ 19,009,635$ 18,346,071$ 663,564$ 96.5% Total Expenditures - All Funds 202,599,797$ 184,624,416$ 260,154,889$ 198,142,386$ 62,012,503$ 76.2% 9