Loading...
FY2021 4th Qtr Financial Summary Date: August 19, 2021 To: City Manager, City Council From: Jacklyn Fleagle, Budget & Compliance Officer Re: Quarterly Financial Summary for Period Ending June 30, 2021 Introduction Attached to this memorandum are the City’s quarterly financial reports as of June 30, 2021. The quarterly financial report includes combined summaries of all fund balances, revenues, and expenditures for fiscal year 2021 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 5-7. 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 slightly under or at their revised budget estimates. The General Fund is at 98.1 %, the Road Use Tax Fund is at 101.8%, the Employee Benefits Fund is at 100.6%, and the Debt Service Fund is at 100.7%. Some large accruals are still outstanding such as the final Hotel/Motel Tax receipt (Other City Taxes) in the General Fund. The General Fund has also experienced revenue shortfalls in Intergovernmental revenues due to timing of Capital Improvement Projects and Culture & Recreation charges for services, Library Fines, and Police Services revenues due to the pandemic. In the major enterprise funds, the actual revenues as a percentage of the budget ranged between 43.7% and 112.5%. The Water Fund finished with revenues at 96.8% of budget, the Housing Authority Fund at 93.2% of budget and the Wastewater Fund at 96.3% 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 budget amendments done mid-year to account for impacts of the COVID-19 pandemic. The Transit Fund actual revenues currently stand at 43.7% of budget This difference in the Transit Fund will be made up with the accrual of the Federal Operating grant. In addition, we are expecting receipt of CARES Act funding to make up for the Transit Fund revenue shortfalls. Several funds are below the 100% benchmark due to the timing of grants. These funds include the Community Development Block Grant (CDBG) Fund at 68.3%, the HOME Fund at 37.2%, and the Metro Planning Org of Johnson County at 82.8%. Additionally, both the Governmental Projects and the Enterprise Projects Capital Funds are significantly below budget at 62.4% and 54.1%, respectively. Revenues for these funds are significantly below budget due to the timing of the state and federal grant revenues and private loan repayments and not due to the pandemic. These revenues have not yet been received or earned and will be amended into next year’s budget. 1 The Other Shared Revenues Fund had revenues at 22,948.4% of budget. This is due to the receipt of the first installment of the American Rescue Plan Act funding and various other COVID-19 related grants that were previously unbudgeted in fiscal year 2021. The combined total actual revenues for all budgetary funds through June are $179,112,510 or 97.3% of budget. The budget shortfall of $4,891,058 is primarily due to the timing of the aforementioned grant revenues and other unrecorded accruals in addition to decreased revenues due to the COVID-19 pandemic. Overall, the City’s revenues are slightly less than projected, and most of the anomalies and budget variances can be explained either through timing of accruals or grants or through pandemic related revenue losses. Expenditure Analysis This expenditure analysis pertains to the expenditure reports, Expenditures by Fund and Expenditures by Fund by Department on pages 8-10. The analysis of the City’s expenditures for fiscal year 2021 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, and the COVID-19 pandemic has had a significant impact on some funds. 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 85.6% due to unspent monies within the City Manager’s Department for Black Lives Matter and Economic Development, that will be carried forward to fiscal year 2022, in addition to lower expenditures within Parks and Recreation due to the impact of the COVID-19 pandemic. There are several funds currently above 100% of their budgeted expenditures. The Employee Benefits Fund is at 135.5% primarily due to large worker’s compensation claims. The Other Shared Revenues fund came in over budget at 673.4% primarily due to COVID-19 related grant monies received and spent within the fiscal year. Additionally, the Debt Service fund came in over budget at 100.9% due to interest payments for the 2020 GO Bonds being higher than anticipated. For the City’s enterprise funds; the Airport fund finished at 113.7% primarily due to unbudgeted professional services and minor equipment purchases. Some of the other funds have actual expenditures that are well below the 100% benchmark. Those funds include the HOME Fund (38.0%), the CDBG Fund (65.4%), and the Emergency Levy Fund (16.4%). Also, well below budget are the Governmental Projects Fund (31.6%), and the Enterprise Projects Fund (28.0%). Most 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 2022 budget. The combined total actual expenditures for all budgetary funds through June are $157,664,774 or 70.7% of budget. When the capital project funds, the CDBG, Other Shared Revenues and Emergency Levy funds are removed from the calculation, the actual percentage of expenditures versus budget increases to 98.5%. Overall, the City’s expenditures are expected to finish at or below budget. Conclusion Generally, there are no major immediate concerns to report with the City’s fund balances at year-end, and no funds are presented with a negative fund balance at. This year-end report is preliminary and accruals for revenues and expenditures are still outstanding. The City’s final financial performance will be available for the start of the fiscal year 2022 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 41,640,906$ 58,473,936$ 16,639,310$ 55,282,496$ 11,042,749$ 50,428,907$ 15,483,224$ 34,945,684$ Special Revenue Funds 2100 Community Dev Block Grant (17,210) 1,431,648 - 1,253,229 141,285 19,924 - 19,924 2110 HOME (37,396) 323,187 - 281,357 - 4,434 - 4,434 2200 Road Use Tax Fund 3,547,923 9,156,758 622,374 6,895,226 3,183,187 3,248,642 - 3,248,642 2300 Other Shared Revenue 2,639 9,162,595 - 268,867 - 8,896,367 - 8,896,367 2350 Metro Planning Org of J.C. 434,368 326,231 378,577 759,938 - 379,238 - 379,238 2400 Employee Benefits 3,584,853 14,799,472 - 1,790,332 12,963,004 3,630,989 - 3,630,989 2450 Emergency Levy Fund 2,613 1,039,399 - 147,787 100,000 794,225 - 794,225 2500 Affordable Housing Fund 1,622,344 1,836,537 1,000,000 860,507 - 3,598,374 - 3,598,374 2510 Iowa City Property Manageme 186,172 85,162 - 76,763 - 194,571 - 194,571 26** Tax Increment Financing 783,349 2,679,149 51,716 951,082 1,108,346 1,454,787 1,159,892 294,895 2820 SSMID-Downtown District 4,100 503,091 - 507,191 - - - - Debt Service Fund 5*** Debt Service 9,354,037 11,526,951 1,025,690 14,652,318 - 7,254,361 - 7,254,361 Enterprise Funds 710* Parking 2,171,685 3,816,297 250,000 3,356,514 607,312 2,274,156 303,702 1,970,454 715* Mass Transit 6,914,358 2,367,431 5,076,795 6,824,019 1,250,000 6,284,566 6,031,167 253,399 720* Wastewater 23,423,905 11,455,640 6,315,097 9,720,810 7,515,264 23,958,568 12,201,929 11,756,639 730* Water 13,016,182 9,321,688 2,764,311 9,070,655 3,950,522 12,081,004 5,988,412 6,092,592 7400 Refuse Collection 1,690,269 3,671,293 10,539 3,798,190 550,000 1,023,910 - 1,023,910 750* Landfill 24,875,610 8,286,921 1,382,881 5,615,542 3,277,498 25,652,372 23,535,451 2,116,921 7600 Airport 235,540 398,016 100,000 417,765 52,250 263,541 199,821 63,719 7700 Storm Water 1,088,776 1,614,119 1,001,986 597,005 1,724,419 1,383,458 389,000 994,458 79** Housing Authority 7,828,046 10,234,398 - 11,941,213 50,720 6,070,510 1,252,260 4,818,250 Capital Project Funds Governmental Projects 27,975,543 14,882,303 5,225,999 17,292,800 - 30,791,044 - 30,791,044 Enterprise Projects 10,086,942 1,720,289 6,713,719 5,303,169 950,000 12,267,781 - 12,267,781 - Total Budgetary Funds 180,415,552$ 179,112,510$ 48,558,996$ 157,664,774$ 48,466,555$ 201,955,729$ 66,544,858$ 135,410,870$ Non-Budgetary Funds Internal Service Funds 810* Equipment 17,243,785$ 7,463,623$ 218,257$ 6,663,147$ 299,719$ 17,962,798$ 14,478,070$ 3,484,728$ 8200 Risk Management 4,113,594 1,624,257 - 1,423,612 - 4,314,240 - 4,314,240 830* Information Technology 3,254,738 2,910,525 335,678 2,620,181 335,678 3,545,082 1,241,050 2,304,033 8400 Central Services 756,956 198,909 - 146,775 10,978 798,111 - 798,111 8500 Health Insurance Reserves 12,300,290 10,559,371 - 10,665,253 - 12,194,408 8,627,420 3,566,988 8600 Dental Insurance Reserves 374,616 396,698 - 347,747 - 423,567 - 423,567 Total Non-Budgetary Funds 38,043,980$ 23,153,383$ 553,935$ 21,866,716$ 646,375$ 39,238,207$ 24,346,539$ 14,891,667$ Total All Funds 218,459,532$ 202,265,893$ 49,112,930$ 179,531,490$ 49,112,930$ 241,193,935$ 90,891,398$ 150,302,538$ City of Iowa City Fund Summary Fiscal Year 2021 through June 30, 2021 3 2020 Actual 2021 Budget 2021 Revised 2021 Actual Variance Percent Budgetary Fund Revenues General Fund 10** General Fund 54,093,751$ 59,264,838$ 59,590,311$ 58,473,936$ (1,116,375)$ 98.1% Special Revenue Funds 2100 Community Dev Block Grant 696,930 784,935 2,095,404 1,431,648 (663,756) 68.3% 2110 HOME 890,256 599,082 868,153 323,187 (544,966) 37.2% 2200 Road Use Tax Fund 9,343,122 8,935,700 8,995,478 9,156,758 161,280 101.8% 2300 Other Shared Revenue 12,500 - 39,927 9,162,595 9,122,668 22948.4% 2350 Metro Planning Org of Johnson Co 393,607 377,352 394,167 326,231 (67,936) 82.8% 2400 Employee Benefits 12,798,747 14,712,009 14,712,009 14,799,472 87,463 100.6% 2450 Emergency Levy Fund 2,613 1,001,442 1,001,442 1,039,399 37,957 103.8% 2500 Affordable Housing Fund (26,615) - 8,100 1,836,537 1,828,437 0.0% 2510 Iowa City Property Management 65,497 68,430 68,430 85,162 16,732 124.5% 26** Tax Increment Financing 3,479,948 2,608,203 2,608,203 2,679,149 70,946 102.7% 2820 SSMID-Downtown District 371,277 492,596 492,596 503,091 10,495 102.1% Debt Service Fund 5*** Debt Service 12,084,974 11,450,899 11,450,899 11,526,951 76,052 100.7% Enterprise Funds 710* Parking 4,555,583 5,935,900 3,402,700 3,816,297 413,597 112.2% 715* Mass Transit 5,114,607 4,457,460 5,420,191 2,367,431 (3,052,760) 43.7% 720* Wastewater 12,854,265 11,895,436 11,895,436 11,455,640 (439,796) 96.3% 730* Water 10,398,875 9,985,860 9,625,231 9,321,688 (303,543) 96.8% 7400 Refuse Collection 3,808,883 3,886,220 3,886,070 3,671,293 (214,777) 94.5% 750* Landfill 7,273,518 7,202,311 7,367,451 8,286,921 919,470 112.5% 7600 Airport 444,564 364,820 368,820 398,016 29,196 107.9% 7700 Storm Water 1,749,864 1,714,700 1,714,700 1,614,119 (100,581) 94.1% 79** Housing Authority 10,379,669 10,236,271 10,977,513 10,234,398 (743,115) 93.2% Capital Project Funds Governmental Projects 16,828,142 18,167,000 23,837,857 14,882,303 (8,955,554) 62.4% Enterprise Projects 3,046,134 1,652,776 3,182,480 1,720,289 (1,462,191) 54.1% Total Budgetary Revenues 170,660,713$ 175,794,240$ 184,003,568$ 179,112,510$ (4,891,058)$ 97.3% Non-Budgetary Fund Revenues Internal Service Funds 810* Equipment 7,106,528$ 7,448,587$ 7,520,479$ 7,463,623$ (56,856)$ 99.2% 8200 Risk Management 1,741,050 1,646,580 1,646,580 1,624,257 (22,323) 98.6% 830* Information Technology 2,693,000 2,495,792 2,495,792 2,910,525 414,733 116.6% 8400 Central Services 243,536 255,988 255,988 198,909 (57,079) 77.7% 8500 Health Insurance Reserves 10,272,878 11,196,638 11,196,638 10,559,371 (637,267) 94.3% 8600 Dental Insurance Reserves 411,351 458,475 458,475 396,698 (61,777) 86.5% Total Non-Budgetary Revenues 22,468,344$ 23,502,060$ 23,573,952$ 23,153,383$ (420,569)$ 98.2% Total Revenues - All Funds 193,129,057$ 199,296,300$ 207,577,520$ 202,265,893$ (5,311,627)$ 97.4% City of Iowa City Revenues by Fund Fiscal Year 2021 through June 30, 2021 4 2020 Actual 2021 Budget 2021 Revised 2021 Actual Variance Percent Budgetary Fund Revenues Property Taxes 59,360,168$ 65,849,136$ 65,849,136$ 66,780,996$ 931,860$ 101.4% Other City Taxes: TIF Revenues 3,434,710 2,593,203 2,593,203 2,637,854 44,651 101.7% Gas/Electric Excise Taxes 677,091 633,387 633,387 643,961 10,574 101.7% Mobile Home Taxes 51,220 58,361 58,361 63,002 4,641 108.0% Hotel/Motel Taxes 1,134,864 1,301,820 650,860 559,546 (91,314) 86.0% Utility Franchise Tax 883,652 964,690 964,690 781,585 (183,105) 81.0% Subtotal 6,181,536 5,551,461 4,900,501 4,685,947 (214,554) 95.6% Licenses, Permits, & Fees: General Use Permits 15,063 85,410 14,180 18,029 3,849 127.1% Food & Liquor Licenses 95,476 126,710 126,710 24,651 (102,059) 19.5% Professional License 3,925 6,160 6,160 3,760 (2,400) 61.0% Franchise Fees 438,753 512,750 580,000 582,917 2,917 100.5% Construction Permits & Insp Fees 1,742,746 1,954,820 1,794,820 1,707,958 (86,862) 95.2% Misc Lic & Permits 68,060 49,620 49,620 73,547 23,927 148.2% Subtotal 2,364,024 2,735,470 2,571,490 2,410,862 (160,628) 93.8% Intergovernmental: Fed Intergovernment Revenue 15,404,149 16,820,081 26,737,597 24,373,398 (2,364,199) 91.2% Property Tax Credits 1,519,888 1,923,358 1,923,358 1,593,623 (329,735) 82.9% Road Use Tax 9,163,303 8,820,140 8,820,140 9,015,426 195,286 102.2% State 28E Agreements 2,107,692 1,976,419 2,394,419 2,128,143 (266,276) 88.9% Operating Grants 66,984 69,580 69,580 61,849 (7,731) 88.9% Disaster Assistance - - - 2,700 2,700 0.0% Other State Grants 5,510,294 3,069,046 6,657,595 2,227,974 (4,429,621) 33.5% Local 28E Agreements 1,280,923 2,883,620 2,900,435 1,410,557 (1,489,878) 48.6% Subtotal 35,053,234 35,562,244 49,503,124 40,813,669 (8,689,455) 82.4% Charges For Fees And Services: Building & Development 492,643 428,570 428,570 2,517,466 2,088,896 587.4% Police Services 188,901 100,000 30,000 13,523 (16,477) 45.1% Animal Care Services 13,484 14,920 14,920 11,742 (3,178) 78.7% Fire Services 8,880 9,060 9,060 11,074 2,014 122.2% Transit Fees 968,924 1,220,390 750,390 637,606 (112,784) 85.0% Culture & Recreation 467,105 776,548 568,278 267,221 (301,057) 47.0% Misc Charges For Services 53,024 68,820 51,200 57,336 6,136 112.0% Water Charges 10,051,603 9,748,310 9,448,310 9,215,461 (232,849) 97.5% Wastewater Charges 12,353,935 11,631,416 11,631,416 11,276,574 (354,842) 96.9% Refuse Charges 4,185,695 4,278,720 4,316,840 4,323,153 6,313 100.1% Landfill Charges 5,961,888 6,224,330 6,410,000 7,253,855 843,855 113.2% Storm Water Charges 1,730,056 1,700,000 1,700,000 1,600,076 (99,924) 94.1% Parking Charges 4,795,660 6,378,760 3,775,260 4,154,129 378,869 110.0% Subtotal 41,271,797 42,579,844 39,134,244 41,339,216 2,204,972 105.6% Miscellaneous: Code Enforcement 300,368 269,340 68,100 60,387 (7,713) 88.7% Parking Fines 438,244 585,000 525,000 462,396 (62,604) 88.1% Library Fines & Fees 60,545 100,000 10,000 4,328 (5,672) 43.3% Contributions & Donations 496,111 309,310 544,237 350,499 (193,738) 64.4% Printed Materials 39,128 46,710 46,710 20,086 (26,624) 43.0% Animal Adoption 62,646 35,000 35,000 49,080 14,080 140.2% Misc Merchandise 36,506 62,760 37,450 17,177 (20,273) 45.9% Intra-City Charges 4,667,718 5,090,750 5,090,750 5,025,342 (65,408) 98.7% Other Misc Revenue 913,580 795,155 769,200 901,499 132,299 117.2% Special Assessments 294 570 570 2,134 1,564 374.4% Subtotal 7,015,141$ 7,294,595$ 7,127,017$ 6,892,927$ (234,090)$ 96.7% City of Iowa City Revenues by Type Fiscal Year 2021 through June 30, 2021 5 2020 Actual 2021 Budget 2021 Revised 2021 Actual Variance Percent City of Iowa City Revenues by Type Fiscal Year 2021 through June 30, 2021 Use Of Money And Property: Interest Revenues 3,277,337$ 1,705,802$ 1,209,842$ 983,814$ (226,028)$ 81.3% Rents 1,177,377 1,331,104 1,062,629 1,100,488 37,859 103.6% Royalties & Commissions 100,348 106,603 87,603 120,765 33,162 137.9% Subtotal 4,555,062 3,143,509 2,360,074 2,205,067 (155,007) 93.4% Other Financial Sources: Debt Sales 13,012,385 11,871,140 11,161,140 12,744,378 1,583,238 114.2% Sale Of Assets 901,476 501,700 1,051,700 616,257 (435,443) 58.6% Insurance Recoveries 2,258 - - - - 0.0% Loans 943,633 705,141 345,141 623,191 278,050 180.6% Subtotal 14,859,751 13,077,981 12,557,981 13,983,826 1,425,845 111.4% Total Budgetary Revenues 170,660,713$ 175,794,240$ 184,003,567$ 179,112,510$ (4,891,057) 97.3% Non-Budgetary Fund Revenues Internal Service Funds 22,468,344$ 23,502,060$ 23,573,952$ 23,153,383$ (420,569)$ 98.2% Total Non-Budgetary Revenues 22,468,344$ 23,502,060$ 23,573,952$ 23,153,383$ (420,569)$ 98.2% Total Revenues - All Funds 193,129,057$ 199,296,300$ 207,577,519$ 202,265,893$ (5,311,626)$ 97.4% 6 2020 Actual 2021 Budget 2021 Revised 2021 Actual Variance Percent Budgetary Fund Expenditures General Fund 10** General Fund 57,237,520$ 63,133,164$ 64,561,396$ 55,282,496$ 9,278,900$ 85.6% Special Revenue Funds 2100 Community Dev Block Grant 710,805 734,915 1,916,454 1,253,229 663,225 65.4% 2110 HOME 864,090 471,281 739,827 281,357 458,470 38.0% 2200 Road Use Tax Fund 6,541,337 6,860,459 6,989,155 6,895,226 93,929 98.7% 2300 Other Shared Revenue 1,810 - 39,927 268,867 (228,940) 673.4% 2350 Metro Planning Org of Johnson Co. 666,417 785,929 784,616 759,938 24,678 96.9% 2400 Employee Benefits 1,380,902 1,321,730 1,321,730 1,790,332 (468,602) 135.5% 2450 Emergency Levy Fund - 900,800 900,800 147,787 753,013 16.4% 2500 Affordable Housing Fund 986,779 1,000,000 1,000,000 860,507 139,493 86.1% 2510 Iowa City Property Management 60,567 57,548 57,548 76,763 (19,215) 133.4% 26** Tax Increment Financing 1,545,792 1,240,029 1,159,444 951,082 208,362 82.0% 2820 SSMID-Downtown District 367,177 492,596 496,696 507,191 (10,495) 102.1% Debt Service Fund 5*** Debt Service 13,038,331 14,519,819 14,519,819 14,652,318 (132,499) 100.9% Enterprise Funds 710* Parking 13,153,203 6,937,252 4,271,531 3,356,514 915,017 78.6% 715* Mass Transit 8,285,908 7,988,973 7,916,023 6,824,019 1,092,004 86.2% 720* Wastewater 8,928,996 9,904,664 9,916,375 9,720,810 195,565 98.0% 730* Water 8,512,594 9,048,440 9,325,504 9,070,655 254,849 97.3% 7400 Refuse Collection 3,687,875 3,920,390 3,963,567 3,798,190 165,377 95.8% 750* Landfill 5,337,862 5,456,843 5,550,685 5,615,542 (64,857) 101.2% 7600 Airport 421,723 367,708 367,283 417,765 (50,482) 113.7% 7700 Storm Water 603,911 679,879 679,161 597,005 82,156 87.9% 79** Housing Authority 9,904,793 10,139,876 12,783,432 11,941,213 842,219 93.4% Capital Project Funds Governmental Projects 24,661,959 22,705,470 54,748,115 17,292,800 37,455,315 31.6% Enterprise Projects 5,947,033 6,834,650 18,955,820 5,303,169 13,652,651 28.0% Total Budgetary Expenditures 172,847,385$ 175,502,415$ 222,964,908$ 157,664,774$ 65,300,134$ 70.7% Non-Budgetary Funds Expenditures Internal Service Funds 810* Equipment 5,786,860$ 6,156,284$ 8,585,156$ 6,663,147$ 1,922,009$ 77.6% 8200 Risk Management 1,511,332 1,623,630 1,623,630 1,423,612 200,018 87.7% 830* Information Technology 2,430,267 2,513,842 2,789,022 2,620,181 168,841 93.9% 8400 Central Services 188,400 225,477 251,671 146,775 104,896 58.3% 8500 Health Insurance Reserves 9,129,477 11,070,318 11,070,318 10,665,253 405,065 96.3% 8600 Dental Insurance Reserves 295,202 449,071 449,071 347,747 101,324 77.4% Total Non-Budgetary Expenditures 19,341,538$ 22,038,622$ 24,768,868$ 21,866,716$ 2,902,152$ 88.3% Total Expenditures - All Funds 192,188,923$ 197,541,037$ 247,733,776$ 179,531,490$ 68,202,286$ 72.5% City of Iowa City Expenditures by Fund Fiscal Year 2021 through June 30, 2021 7 2020 Actual 2021 Budget 2021 Revised 2021 Actual Variance Percent Budgetary Funds Expenditures General Fund 10** General Fund City Council 149,211$ 159,554$ 157,929$ 148,836$ 9,093$ 94.2% City Clerk 491,473 524,699 557,494 530,843 26,651 95.2% City Attorney 836,849 867,117 871,776 823,919 47,857 94.5% City Manager 3,727,694 4,286,206 5,571,166 3,742,396 1,828,770 67.2% Finance 4,089,409 4,631,600 4,958,666 3,834,842 1,123,824 77.3% Police 14,503,070 15,667,193 15,805,126 14,476,451 1,328,676 91.6% Fire 8,477,009 9,035,169 9,048,784 8,918,022 130,762 98.6% Parks & Recreation 8,574,238 10,443,623 10,542,308 8,348,278 2,194,030 79.2% Library 6,327,197 7,092,059 6,949,366 6,081,082 868,284 87.5% Senior Center 913,616 1,038,668 1,027,646 926,978 100,668 90.2% Neighborhood & Development Services 6,066,892 5,614,025 5,309,960 4,274,402 1,035,558 80.5% Public Works 2,478,292 3,117,289 3,103,713 2,568,025 535,688 82.7% Transportation & Resource Management 602,569 655,962 657,462 608,423 49,039 92.5% Total General Fund 57,237,520 63,133,164 64,561,396 55,282,496 9,278,900 85.6% Special Revenue Funds 2100 Community Dev Block Grant Neighborhood & Development Services 710,805 734,915 1,916,454 1,253,229 663,225 65.4% 2110 HOME Neighborhood & Development Services 864,090 471,281 739,827 281,357 458,470 38.0% 2200 Road Use Tax Fund Public Works 6,541,337 6,860,459 6,989,155 6,895,226 93,929 98.7% 2300 Other Shared Revenue Neighborhood & Development Services 1,810 - 39,927 268,867 (228,940) 673.4% 2350 Metro Planning Org of Johnson Co Neighborhood & Development Services 666,417 785,929 784,616 759,938 24,678 96.9% 2400 Employee Benefits Finance 1,380,902 1,321,730 1,321,730 1,790,332 (468,602) 135.5% 2450 Emergency Levy Fund City Manager - 900,800 900,800 147,787 753,013 16.4% 2500 Affordable Housing Fund Neighborhood & Development Services 986,779 1,000,000 1,000,000 860,507 139,493 86.1% 2510 Iowa City Property Management Neighborhood & Development Services 60,567 57,548 57,548 76,763 (19,215) 133.4% 26** Tax Increment Financing Finance 1,545,792 1,240,029 1,159,444 951,082 208,362 82.0% 2820 SSMID-Downtown District Finance 367,177 492,596 496,696 507,191 (10,495) 102.1% Total Special Revenue Funds 13,125,677 13,865,287 15,406,197 13,792,278 1,613,919 89.5% Debt Service Fund 5*** Debt Service Finance 13,038,331 14,519,819 14,519,819 14,652,318 (132,499) 100.9% Total Debt Service Fund 13,038,331 14,519,819 14,519,819 14,652,318 (132,499) 100.9% City of Iowa City Expenditures by Fund by Department Fiscal Year 2021 through June 30, 2021 8 2020 Actual 2021 Budget 2021 Revised 2021 Actual Variance Percent City of Iowa City Expenditures by Fund by Department Fiscal Year 2021 through June 30, 2021 Enterprise Funds 710* Parking Transportation & Resource Management 13,153,203$ 6,937,252$ 4,271,531$ 3,356,514$ 915,017$ 78.6% 715* Mass Transit Transportation & Resource Management 8,285,908 7,988,973 7,916,023 6,824,019 1,092,004 86.2% 720* Wastewater Public Works 8,928,996 9,904,664 9,916,375 9,720,810 195,565 98.0% 730* Water Public Works 8,512,594 9,048,440 9,325,504 9,070,655 254,849 97.3% 7400 Refuse Collection Transportation & Resource Management 3,687,875 3,920,390 3,963,567 3,798,190 165,377 95.8% 750* Landfill Transportation & Resource Management 5,337,862 5,456,843 5,550,685 5,615,542 (64,857) 101.2% 7600 Airport Airport Operations 421,723 367,708 367,283 417,765 (50,482) 113.7% 7700 Storm Water Public Works 603,911 679,879 679,161 597,005 82,156 87.9% 79** Housing Authority Neighborhood & Development Services 9,904,793 10,139,876 12,783,432 11,941,213 842,219 93.4% Total Enterprise Funds 58,836,864 54,444,025 54,773,561 51,341,714 3,431,847 93.7% Capital Project Funds Governmental Projects 24,661,959 22,705,470 54,748,115 17,292,800 37,455,315 31.6% Enterprise Projects 5,947,033 6,834,650 18,955,820 5,303,169 13,652,651 28.0% Total Capital Project Funds 30,608,993 29,540,120 73,703,935 22,595,969 51,107,966 30.7% Total Budgetary Expenditures 172,847,385$ 175,502,415$ 222,964,908$ 157,664,774$ 65,300,134$ 70.7% Non-Budgetary Funds Expenditures Internal Service Funds 810* Equipment Public Works 5,786,860$ 6,156,284$ 8,585,156$ 6,663,147$ 1,922,009$ 77.6% 8200 Risk Management Finance 1,511,332 1,623,630 1,623,630 1,423,612 200,018 87.7% 830* Information Technology Finance 2,430,267 2,513,842 2,789,022 2,620,181 168,841 93.9% 8400 Central Services Finance 188,400 225,477 251,671 146,775 104,896 58.3% 8500 Health Insurance Reserves Finance 9,129,477 11,070,318 11,070,318 10,665,253 405,065 96.3% 8600 Dental Insurance Reserves Finance 295,202 449,071 449,071 347,747 101,324 77.4% Total Internal Service Funds 19,341,538 22,038,622 24,768,868 21,866,716 2,902,152 88.3% Total Non-Budgetary Expenditures 19,341,538$ 22,038,622$ 24,768,868$ 21,866,716$ 2,902,152$ 88.3% Total Expenditures - All Funds 192,188,923$ 197,541,037$ 247,733,776$ 179,531,490$ 68,202,286$ 72.5% 9