Loading...
HomeMy WebLinkAboutFY2025 3rd Qtr Financial Summary Date: May 5, 2025 To: City Manager, City Council From: Angie Ogden, Budget Management Analyst Re: Quarterly Financial Summary for Period Ending March 31, 2025 Introduction Attached to this memorandum are the City’s quarterly financial reports as of March 31, 2025. The quarterly financial report includes combined summaries of all fund balances, revenues, and expenditures for Fiscal Year 2025 through the end of the third quarter, which is 75% of the way through the fiscal year. The March quarterly report also incorporates the budget amendments that were approved during the Fiscal Year 2026 budget process. Some of the highlights of the City’s financial activity are discussed below. 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 75% of budget since we have completed three-fourths of the fiscal year; however, due to accruals and timing differences, many of these percentages may be above or below 75%. Funds with budget anomalies on page 4 worth noting; the Home Fund revenues are at 33.0%. This is due to timing of grant reimbursements. Additionally, the MPOJC Fund is at 52.8% of budget which is primarily due to timing of federal grant receipts. The Transit fund has revenues at 36.7% due to the timing of receipt for the federal operating grant. Finally, the Governmental Projects fund has revenues at only 13.2% of budget and the Enterprise Projects fund is at 7.5% of budget due to the timing of the bond issuance. The Governmental Projects fund should come up closer to budget after the bond sale this spring. Debt issuance for the Enterprise Projects fund will be delayed until fiscal year 2026 so this will remain under budget for the fiscal year. On page 5, a few examples of revenues that are below the 75% mark include property tax revenue which is at 58.4% of budget and reflects the timing of the property tax receipts. The second half property taxes are due in April and should increase this percentage substantially. Other revenues affected by the timing of property tax receipts include TIF Revenues which are at 55.6% and Property Tax Credits which are at 22.1% of budget. Under Charges for Fees & Services, Police Services fees are at 118.5% of budget. This is due to timing of when police forfeiture and abandonments take place. In addition, under Intergovernmental on page 5, Operating Grants are at 121.5% and Local 28E Agreements are at 89.1% of budget. Iowa City School reimbursements came in higher than expected as well as the timing of receipts of grants. Finally, on page 6, Interest Revenues are 470.3%. Again, due to the increase in interest earned. Under Other Financing Sources, Debt Sales revenue is at 2.9% of budget. We are currently preparing to sell the general obligation bonds which will bring this revenue source up to approximately 32% of budget. 1 As of March 31, the combined total actual revenue for all budgetary funds is $121,941,302 or 51.1% of budget. Overall, the City’s revenues are not substantially different than projected, and the anomalies and budget variances can be explained. 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 2025 through March is similar to the analysis for the City’s revenues. We generally expect the actual expenditure levels to be around 75% of budget at this time of year. Some funds have expenditure activity through the third quarter that differs significantly from the 75% mark. The following funds have a significant expenditure variance above or below 75%: HOME Fund expenditures are at 33.1%, due to the timing of the payout of loans and grants to applicants. Employee Benefits Fund expenditures are at 86.5%, due to higher than expected claims for work related injuries. Iowa City Property Management Fund expenditures are at 42.5% of budget resulting from lower R&M cost as well as timing of contracted improvements. TIF Fund expenditures are at 8.3% due to timing of the TIF rebate payments. Debt Service Fund expenditures are at 8.8%, because the general obligation bond principal payments are not due until June 1. Housing Authority expenditures are at 86.3% of budget due to increased landlord rents and utility reimbursements. Governmental Projects expenditures are at 18.1% and Enterprise Projects expenditures are at 11.5% because many of the capital projects are scheduled for construction this spring. Overall, the combined total actual expenditures for all budgetary funds through March are $205,705,153 or 39.0% of budget. The City’s expenditures through the third quarter have a few major anomalies; however, these can be readily explained. Conclusion Generally, there are no major concerns to report with the City’s fund balances at the end of March. The Community Development Block Grant (CDBG) Fund is presented (on page 3) with negative fund balance of $20,326. This negative fund balances should be reversed following the next receipt of CDBG/HOME funds. The other fund balances appear to be near expectations. 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 66,253,379$ 41,007,803$ 10,326,090$ 50,939,101$ 5,084,951$ 61,563,221$ 25,756,182$ 35,807,039$ Special Revenue Funds 2100 Community Dev Block Grant 332 889,789 - 790,022 120,425 (20,326) - (20,326) 2110 HOME (526) 1,009,230 - 969,361 - 39,343 - 39,343 2200 Road Use Tax Fund 6,740,530 6,921,944 522,825 5,558,508 3,037,928 5,588,863 - 5,588,863 2300 Other Shared Revenue 3,545,052 661,541 - 3,039,949 - 1,166,644 - 1,166,644 2350 Metro Planning Org of J.C. 633,511 247,109 295,950 714,397 - 462,173 - 462,173 2400 Employee Benefits 3,577,051 9,010,447 - 992,047 10,668,150 927,301 - 927,301 2450 Emergency Levy Fund 1,192,635 8,852 - 250 - 1,201,237 - 1,201,237 2500 Affordable Housing Fund 7,372,091 273,652 772,500 678,632 - 7,739,611 - 7,739,611 2510 Peninsula Apartments 408,086 204,141 - 127,990 - 484,237 - 484,237 26** Tax Increment Financing 867,240 2,496,490 - 229,630 1,584,838 1,549,262 141 1,549,121 2820 SSMID-Downtown District - 387,645 - 367,747 - 19,898 - 19,898 Debt Service Fund 5*** Debt Service 7,487,853 7,276,420 1,542,059 1,208,883 - 15,097,449 - 15,097,449 Enterprise Funds 710* Parking 2,115,697 5,458,179 1,125,000 3,646,341 2,331,180 2,721,355 328,285 2,393,070 715* Mass Transit 13,531,551 4,687,874 3,185,400 6,552,033 168,750 14,684,042 11,226,411 3,457,631 720* Wastewater 22,125,720 9,678,526 1,125,960 6,212,460 1,842,460 24,875,286 2,207,464 22,667,822 730* Water 15,771,221 8,971,304 1,776,643 7,807,945 3,792,998 14,918,225 5,569,713 9,348,513 7400 Refuse Collection 2,790,929 3,653,665 3,193 3,233,565 200,000 3,014,222 - 3,014,222 750* Landfill 22,508,794 6,163,346 1,439,052 4,427,645 (140,854) 25,824,401 18,612,667 7,211,735 7600 Airport 195,212 295,059 75,000 317,157 81,214 166,900 113,885 53,015 7700 Storm Water 1,677,134 1,374,879 825,431 415,035 1,871,461 1,590,948 378,215 1,212,733 79** Housing Authority 7,129,228 10,571,699 - 10,949,891 23,025 6,728,011 - 6,728,011 Capital Project Funds Governmental Projects 31,810,109 2,752,675 4,131,695 13,376,965 - 25,317,514 - 25,317,514 Enterprise Projects 21,723,840 3,219,872 3,719,727 8,884,723 - 19,778,715 - 19,778,715 Total Budgetary Funds 239,456,669$ 127,222,141$ 30,866,526$ 131,440,277$ 30,666,526$ 235,438,533$ 64,192,962$ 171,245,571$ Non-Budgetary Funds Internal Service Funds 810* Equipment 23,192,318$ 6,566,139$ -$ 5,049,803$ -$ 24,708,655$ 19,798,288$ 4,910,367$ 8200 Risk Management 4,021,093 1,686,183 - 1,008,176 - 4,699,100 4,699,100 830* Information Technology 4,070,589 2,495,943 75,000 2,493,416 75,000 4,073,116 1,734,893 2,338,223 8400 Central Services 933,947 140,018 - 121,638 200,000 752,326 - 752,326 8500 Health Insurance Reserves 19,414,739 10,713,414 - 7,765,996 - 22,362,156 9,523,167 12,838,989 8600 Dental Insurance Reserves 597,941 349,839 - 292,150 - 655,630 - 655,630 Total Non-Budgetary Funds 52,230,627$ 21,951,535$ 75,000$ 16,731,179$ 275,000$ 57,250,983$ 31,056,348$ 26,194,635$ Total All Funds 291,687,296$ 149,173,676$ 30,941,526$ 148,171,456$ 30,941,526$ 292,689,516$ 95,249,310$ 197,440,206$ City of Iowa City Fund Summary Fiscal Year 2025 through March 31, 2025 3 2024 Actual 2025 Budget 2025 Revised 2025 Actual Variance Percent Budgetary Fund Revenues General Fund 10** General Fund 63,144,267$ 62,533,285$ 62,533,285$ 41,007,803$ (21,525,482)$ 65.6% Special Revenue Funds 2100 Community Dev Block Grant 928,673 886,567 1,244,400 889,789 (354,611) 71.5% 2110 HOME 455,291 721,492 3,061,650 1,009,230 (2,052,420) 33.0% 2200 Road Use Tax Fund 11,039,422 10,649,900 10,649,900 6,921,944 (3,727,956) 65.0% 2300 Other Shared Revenue 653,948 30,000 962,728 661,541 (301,187) 68.7% 2350 Metro Planning Org of Johnson Co 574,367 468,000 468,000 247,109 (220,891) 52.8% 2400 Employee Benefits 14,864,849 15,335,900 15,335,900 9,010,447 (6,325,453) 58.8% 2450 Emergency Levy Fund 874,504 9,200 9,200 8,852 (348) 96.2% 2500 Affordable Housing Fund 372,575 - - 273,652 273,652 0.0% 2510 Iowa City Property Management 252,224 226,575 226,575 204,141 (22,434) 90.1% 26** Tax Increment Financing 4,417,348 4,388,100 4,388,100 2,496,490 (1,891,610) 56.9% 2820 SSMIDs 661,438 677,000 677,000 387,645 (289,355) 57.3% Debt Service Fund 5*** Debt Service 11,716,728 11,988,600 11,988,600 7,276,420 (4,712,181) 60.7% Enterprise Funds 710* Parking 5,601,351 8,963,815 6,972,967 5,458,179 (1,514,788) 78.3% 715* Mass Transit 7,198,324 7,928,300 12,768,200 4,687,874 (8,080,326) 36.7% 720* Wastewater 13,901,646 13,353,500 13,353,500 9,678,526 (3,674,974) 72.5% 730* Water 12,734,762 12,250,200 12,250,200 8,971,304 (3,278,896) 73.2% 7400 Refuse Collection 5,167,200 5,142,300 5,142,300 3,653,665 (1,488,635) 71.1% 750* Landfill 8,795,022 7,964,900 7,964,900 6,163,346 (1,801,554) 77.4% 7600 Airport 450,040 440,500 440,500 295,059 (145,441) 67.0% 7700 Storm Water 1,950,216 1,916,800 1,916,800 1,374,879 (541,921) 71.7% 79** Housing Authority 14,147,197 12,892,728 12,892,728 10,571,699 (2,321,029) 82.0% Capital Project Funds Governmental Projects 14,097,960 16,535,200 20,877,390 2,752,675 (18,124,715) 13.2% Enterprise Projects 2,335,250 28,650,000 43,038,620 3,219,872 (39,818,748) 7.5% Total Budgetary Revenues 196,334,603$ 223,952,862$ 249,163,443$ 127,222,141$ (121,941,302)$ 51.1% Non-Budgetary Fund Revenues Internal Service Funds 810* Equipment 8,814,965$ 8,654,600$ 8,809,400$ 6,566,139$ (2,243,261)$ 74.5% 8200 Risk Management 1,803,542 1,126,200$ 1,126,200$ 1,686,183$ 559,983 149.7% 830* Information Technology 3,020,650 2,768,201$ 2,768,201$ 2,495,943$ (272,258) 90.2% 8400 Central Services 226,162 143,800$ 143,800$ 140,018$ (3,782) 97.4% 8500 Health Insurance Reserves 13,615,421 14,353,600$ 14,353,600$ 10,713,414$ (3,640,186) 74.6% 8600 Dental Insurance Reserves 467,770 463,100$ 463,100$ 349,839$ (113,261) 75.5% Total Non-Budgetary Revenues 27,948,510$ 27,509,501$ 27,664,301$ 21,951,535$ (5,712,766)$ 79.3% Total Revenues - All Funds 224,283,113$ 251,462,363$ 276,827,744$ 149,173,676$ (127,654,068)$ 53.9% City of Iowa City Revenues by Fund Fiscal Year 2025 through March 31, 2025 4 2024 Actual 2025 Budget 2025 Revised 2025 Actual Variance Percent Budgetary Fund Revenues Property Taxes 66,225,551$ 68,821,500$ 68,821,500$ 40,160,616$ (28,660,884)$ 58.4% Other City Taxes: TIF Revenues 4,304,866 4,388,100 4,388,100 2,441,017 (1,947,083) 55.6% Gas/Electric Excise Taxes 748,119 656,400 656,400 373,311 (283,089) 56.9% Mobile Home Taxes 47,992 52,800 52,800 35,682 (17,118) 67.6% Hotel/Motel Taxes 2,043,186 1,750,400 1,750,400 1,335,163 (415,237) 76.3% Utility Franchise Tax 982,969 1,116,700 1,116,700 510,326 (606,374) 45.7% Subtotal 8,127,132 7,964,400 7,964,400 4,695,499 (3,268,901) 59.0% Licenses, Permits, & Fees: General Use Permits 99,282 107,080 107,080 72,102 (34,978) 67.3% Food & Liquor Licenses 126,923 116,700 116,700 74,029 (42,671) 63.4% Professional License 2,275 2,000 2,000 1,825 (175) 91.3% Franchise Fees 593,710 470,000 470,000 206,275 (263,725) 43.9% Construction Permits & Insp Fees 2,166,574 1,836,100 1,836,100 1,377,067 (459,033) 75.0% Misc Lic & Permits 55,391 61,000 61,000 43,732 (17,268) 71.7% Subtotal 3,044,155 2,592,880 2,592,880 1,775,030 (817,850) 68.5% Intergovernmental: Fed Intergovernmental Revenue 21,891,003 48,997,706 37,775,830 16,589,138 (21,186,692) 43.9% Property Tax Credits 1,674,917 1,404,500 1,404,500 310,924 (1,093,576) 22.1% Road Use Tax 10,580,120 10,500,000 10,500,000 6,887,313 (3,612,687) 65.6% State 28E Agreements 2,408,480 2,508,500 2,961,900 2,566,419 (395,481) 86.6% Operating Grants 68,697 54,000 54,000 65,627 11,627 121.5% Disaster Assistance 71,309 - - - - 0.0% Other State Grants 1,037,961 685,800 2,896,970 543,242 (2,353,728) 18.8% Local 28E Agreements 1,428,012 1,418,105 1,418,105 1,263,008 (155,097) 89.1% Subtotal 39,160,500 65,568,611 57,011,305 28,225,671 (28,785,634) 49.5% Charges For Fees And Services: Building & Development 663,935 478,850 478,850 272,540 (206,310) 56.9% Police Services 100,897 80,000 80,000 94,825 14,825 118.5% Animal Care Services 10,204 12,800 12,800 9,689 (3,111) 75.7% Fire Services 13,380 9,100 9,100 7,080 (2,020) 77.8% Transit Fees 64,504 - - - - #DIV/0! Culture & Recreation 659,725 644,100 644,100 478,595 (165,505) 74.3% Misc Charges For Services 75,150 67,500 67,500 41,877 (25,623) 62.0% Water Charges 11,003,126 11,084,600 11,084,600 7,674,456 (3,410,144) 69.2% Wastewater Charges 12,794,159 13,207,400 13,207,400 8,893,053 (4,314,347) 67.3% Refuse Charges 5,563,940 5,759,100 5,759,100 3,915,983 (1,843,117) 68.0% Landfill Charges 7,144,380 6,900,000 6,900,000 5,056,565 (1,843,435) 73.3% Storm Water Charges 1,885,926 1,900,000 1,900,000 1,323,718 (576,282) 69.7% Parking Charges 5,723,759 9,372,135 7,268,287 5,640,168 (1,628,119) 77.6% Subtotal 45,703,085 49,515,585 47,411,737 33,408,550 (14,003,187) 70.5% Miscellaneous: Code Enforcement 149,237 161,700 161,700 128,334 (33,366) 79.4% Parking Fines 684,633 817,000 817,000 701,669 (115,331) 85.9% Library Fines & Fees 780 1,000 1,000 359 (641) 35.9% Contributions & Donations 582,187 322,800 592,800 287,262 (305,538) 48.5% Printed Materials 21,173 17,300 17,300 16,146 (1,154) 93.3% Animal Adoption 61,514 60,500 60,500 48,362 (12,138) 79.9% Misc Merchandise 22,319 21,400 21,400 13,844 (7,556) 64.7% Intra-City Charges 6,215,701 6,782,100 6,782,100 4,951,043 (1,831,057) 73.0% Other Misc Revenue 1,317,856 866,801 3,316,961 1,497,881 (1,819,080) 45.2% Special Assessments 753 2,000 2,000 20 (1,980) 1.0% Subtotal 9,056,152$ 9,052,601$ 11,772,761$ 7,644,920$ (4,127,841)$ 64.9% City of Iowa City Revenues by Type Fiscal Year 2025 through March 31, 2025 5 2024 Actual 2025 Budget 2025 Revised 2025 Actual Variance Percent City of Iowa City Revenues by Type Fiscal Year 2025 through March 31, 2025 Use Of Money And Property: Interest Revenues 10,128,915$ 1,642,310$ 1,642,310$ 7,724,038$ 6,081,728$ 470.3% Rents 1,603,520 1,529,075 1,529,075 1,106,108 (422,967) 72.3% Royalties & Commissions 107,306 121,000 121,000 95,091 (25,909) 78.6% Subtotal 11,839,741 3,292,385 3,292,385 8,925,236 5,632,851 271.1% Other Financial Sources: Debt Sales 11,616,402 16,350,000 49,501,575 1,438,502 (48,063,073) 2.9% Sale Of Assets 1,042,543 420,900 420,900 114,602 (306,298) 27.2% Loans 519,342 374,000 374,000 833,515 459,515 222.9% Subtotal 13,178,287 17,144,900 50,296,475 2,386,620 (47,909,855) 4.7% Total Budgetary Revenues 196,334,604$ 223,952,862$ 249,163,443$ 127,222,141$ (121,941,302) 51.1% Non-Budgetary Fund Revenues Internal Service Funds 27,948,510$ 27,509,501$ 27,664,301$ 21,951,535$ (5,712,766)$ 79.3% Total Non-Budgetary Revenues 27,948,510$ 27,509,501$ 27,664,301$ 21,951,535$ (5,712,766)$ 79.3% Total Revenues - All Funds 224,283,113$ 251,462,363$ 276,827,744$ 149,173,676$ (127,654,068)$ 53.9% 6 2024 Actual 2025 Budget 2025 Revised 2025 Actual Variance Percent Budgetary Fund Expenditures General Fund 10** General Fund 71,436,486$ 71,092,899$ 80,786,898$ 50,939,101$ 29,847,797$ 63.1% Special Revenue Funds 2100 Community Dev Block Grant 928,736 801,106 1,038,519 790,022 248,497 76.1% 2110 HOME 455,862 588,371 2,928,529 969,361 1,959,168 33.1% 2200 Road Use Tax Fund 7,448,448 7,965,300 7,985,200 5,558,508 2,426,692 69.6% 2300 Other Shared Revenue 970,786 123,700 4,452,679 3,039,949 1,412,730 68.3% 2350 Metro Planning Org of Johnson Co. 902,800 862,600 980,710 714,397 266,313 72.8% 2400 Employee Benefits 1,739,908 1,146,925 1,146,925 992,047 154,878 86.5% 2450 Emergency Levy Fund 514,078 125,000 179,773 250 179,523 0.1% 2500 Affordable Housing Fund 1,400,194 1,030,000 1,030,000 678,632 351,368 65.9% 2510 Iowa City Property Management 189,624 172,775 301,275 127,990 173,285 42.5% 26** Tax Increment Financing 2,161,320 2,727,000 2,761,800 229,630 2,532,170 8.3% 2820 SSMIDs 661,438 677,000 677,000 367,747 309,253 54.3% Debt Service Fund 5*** Debt Service 13,189,955 13,787,740 13,787,740 1,208,883 12,578,857 8.8% Enterprise Funds 710* Parking 4,141,962 5,162,374 5,208,907 3,646,341 1,562,566 70.0% 715* Mass Transit 9,882,655 11,955,550 17,631,700 6,552,033 11,079,667 37.2% 720* Wastewater 8,271,541 12,714,600 8,890,100 6,212,460 2,677,640 69.9% 730* Water 10,590,605 10,356,952 11,192,877 7,807,945 3,384,932 69.8% 7400 Refuse Collection 4,368,350 4,731,500 4,855,200 3,233,565 1,621,635 66.6% 750* Landfill 6,085,972 6,079,450 6,213,503 4,427,645 1,785,858 71.3% 7600 Airport 489,950 436,550 415,250 317,157 98,093 76.4% 7700 Storm Water 623,916 681,900 681,900 415,035 266,865 60.9% 79** Housing Authority 13,129,901 12,469,766 12,693,767 10,949,891 1,743,876 86.3% Capital Project Funds Governmental Projects 20,533,547 41,047,794 74,005,769 13,376,965 60,628,804 18.1% Enterprise Projects 14,032,510 34,970,500 77,299,409 8,884,723 68,414,686 11.5% Total Budgetary Expenditures 194,150,542$ 241,707,352$ 337,145,430$ 131,440,277$ 205,705,153$ 39.0% Non-Budgetary Funds Expenditures Internal Service Funds 810* Equipment 6,700,574$ 7,894,700$ 10,023,892$ 5,049,803$ 4,974,089$ 50.4% 8200 Risk Management 2,043,847 1,320,700 1,570,700 1,008,176 562,524 64.2% 830* Information Technology 3,231,658 3,175,188 3,476,791 2,493,416 983,375 71.7% 8400 Central Services 170,690 218,900 237,452 121,638 115,814 51.2% 8500 Health Insurance Reserves 10,601,094 12,258,500 12,258,500 7,765,996 4,492,504 63.4% 8600 Dental Insurance Reserves 399,145 410,200 410,200 292,150 118,050 71.2% Total Non-Budgetary Expenditures 23,147,008$ 25,278,188$ 27,977,535$ 16,731,179$ 11,246,356$ 59.8% Total Expenditures - All Funds 217,297,550$ 266,985,540$ 365,122,965$ 148,171,456$ 216,951,509$ 40.6% City of Iowa City Expenditures by Fund Fiscal Year 2025 through March 31, 2025 7 2024 Actual 2025 Budget 2025 Revised 2025 Actual Variance Percent Budgetary Funds Expenditures General Fund 10** General Fund City Council 181,634$ 192,500$ 192,500$ 135,057$ 57,443$ 70.2% City Clerk 633,423 636,705 756,705 407,603 349,102 53.9% City Attorney 942,326 965,048 1,015,048 688,318 326,730 67.8% City Manager 9,910,047 6,156,340 6,988,387 3,886,431 3,101,956 55.6% Finance 4,577,205 5,529,700 5,529,700 3,611,936 1,917,764 65.3% Police 16,522,474 17,809,695 18,174,154 11,949,886 6,224,268 65.8% Fire 9,879,949 11,178,075 11,180,088 7,551,187 3,628,901 67.5% Parks & Recreation 10,243,118 10,639,040 10,720,210 7,118,154 3,602,056 66.4% Library 7,561,093 7,887,900 7,887,900 5,605,730 2,282,170 71.1% Senior Center 1,067,416 1,147,250 1,170,750 784,701 386,049 67.0% Neighborhood & Development Services 6,013,348 4,868,346 13,066,156 6,512,740 6,553,416 49.8% Public Works 3,264,174 3,668,600 3,691,600 2,385,636 1,305,964 64.6% Transportation & Resource Management 640,280 413,700 413,700 301,722 111,978 72.9% Total General Fund 71,436,486 71,092,899 80,786,898 50,939,101 29,847,797 63.1% Special Revenue Funds 2100 Community Dev Block Grant Neighborhood & Development Services 928,736 801,106 1,038,519 790,022 248,497 76.1% 2110 HOME Neighborhood & Development Services 455,862 588,371 2,928,529 969,361 1,959,168 33.1% 2200 Road Use Tax Fund Public Works 7,448,448 7,965,300 7,985,200 5,558,508 2,426,692 69.6% 2300 Other Shared Revenue Neighborhood & Development Services 970,786 123,700 4,452,679 3,039,949 1,412,730 68.3% 2350 Metro Planning Org of Johnson Co Neighborhood & Development Services 902,800 862,600 980,710 714,397 266,313 72.8% 2400 Employee Benefits Finance 1,739,908 1,146,925 1,146,925 992,047 154,878 86.5% 2450 Emergency Levy Fund City Manager 514,078 125,000 179,773 250 179,523 0.1% 2500 Affordable Housing Fund Neighborhood & Development Services 1,400,194 1,030,000 1,030,000 678,632 351,368 65.9% 2510 Iowa City Property Management Neighborhood & Development Services 189,624 172,775 301,275 127,990 173,285 42.5% 26** Tax Increment Financing Finance 2,161,320 2,727,000 2,761,800 229,630 2,532,170 8.3% 2820 SSMIDs Finance 661,438 677,000 677,000 367,747 309,253 54.3% Total Special Revenue Funds 17,373,193 16,219,777 23,482,410 13,468,533 10,013,877 57.4% Debt Service Fund 5*** Debt Service Finance 13,189,955 13,787,740 13,787,740 1,208,883 12,578,857 8.8% Total Debt Service Fund 13,189,955 13,787,740 13,787,740 1,208,883 12,578,857 8.8% City of Iowa City Expenditures by Fund by Department Fiscal Year 2025 through March 31, 2025 8 2024 Actual 2025 Budget 2025 Revised 2025 Actual Variance Percent City of Iowa City Expenditures by Fund by Department Fiscal Year 2025 through March 31, 2025 Enterprise Funds 710* Parking Transportation & Resource Management 4,141,962$ 5,162,374$ 5,208,907$ 3,646,341$ 1,562,566$ 70.0% 715* Mass Transit Transportation & Resource Management 9,882,655 11,955,550 17,631,700 6,552,033 11,079,667 37.2% 720* Wastewater Public Works 8,271,541 12,714,600 8,890,100 6,212,460 2,677,640 69.9% 730* Water Public Works 10,590,605 10,356,952 11,192,877 7,807,945 3,384,932 69.8% 7400 Refuse Collection Transportation & Resource Management 4,368,350 4,731,500 4,855,200 3,233,565 1,621,635 66.6% 750* Landfill Transportation & Resource Management 6,085,972 6,079,450 6,213,503 4,427,645 1,785,858 71.3% 7600 Airport Airport Operations 489,950 436,550 415,250 317,157 98,093 76.4% 7700 Storm Water Public Works 623,916 681,900 681,900 415,035 266,865 60.9% 79** Housing Authority Neighborhood & Development Services 13,129,901 12,469,766 12,693,767 10,949,891 1,743,876 86.3% Total Enterprise Funds 57,584,852 64,588,642 67,783,204 43,562,073 24,221,131 64.3% Capital Project Funds Governmental Projects 20,533,547 41,047,794 74,005,769 13,376,965 60,628,804 18.1% Enterprise Projects 14,032,510 34,970,500 77,299,409 8,884,723 68,414,686 11.5% Total Capital Project Funds 34,566,057 76,018,294 151,305,178 22,261,688 129,043,490 14.7% Total Budgetary Expenditures 194,150,542$ 241,707,352$ 337,145,430$ 131,440,277$ 205,705,153$ 39.0% Non-Budgetary Funds Expenditures Internal Service Funds 810* Equipment Public Works 6,700,574$ 7,894,700$ 10,023,892$ 5,049,803$ 4,974,089$ 50.4% 8200 Risk Management Finance 2,043,847 1,320,700 1,570,700 1,008,176 562,524 64.2% 830* Information Technology Finance 3,231,658 3,175,188 3,476,791 2,493,416 983,375 71.7% 8400 Central Services Finance 170,690 218,900 237,452 121,638 115,814 51.2% 8500 Health Insurance Reserves Finance 10,601,094 12,258,500 12,258,500 7,765,996 4,492,504 63.4% 8600 Dental Insurance Reserves Finance 399,145 410,200 410,200 292,150 118,050 71.2% Total Internal Service Funds 23,147,008 25,278,188 27,977,535 16,731,179 11,246,356 59.8% Total Non-Budgetary Expenditures 23,147,008$ 25,278,188$ 27,977,535$ 16,731,179$ 11,246,356$ 59.8% Total Expenditures - All Funds 217,297,550$ 266,985,540$ 365,122,965$ 148,171,456$ 216,951,509$ 40.6% 9