Loading...
FY2022 1st Qtr Financial SummaryDate: October 21, 2021 To: City Manager, City Council From: Jacklyn Fleagle, Budget & Compliance Officer Re: Quarterly Financial Summary for Period Ending September 30, 2021 Introduction Attached to this memorandum are the City’s quarterly financial reports as of September 30, 2021. The quarterly financial report includes combined summaries of all fund balances, revenues, and expenditures for fiscal year 2022 through the end of the first quarter, which is 25% of the way through the fiscal year. Below are some of the highlights from this quarter’s financial activity. 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 25% of budget since we have completed one-fourth of the fiscal year; however, due to accruals back to the previous year and impacts from the COVID-19 pandemic, many of these percentages are below 25%. For the property tax supported funds, such as the General fund, Debt Service fund, the Employee Benefits fund, and the Emergency Levy Fund, their actual revenues are at 14.6%, 11.8%, 11.5% and 11.7%, respectively. These funds have received a lower percentage of their revenue, because the City’s property tax receipts are due twice during the year, October and April, and the City will receive the majority of its property tax revenue at that time. This is not the same for the City’s enterprise funds. The City’s enterprise funds are primarily supported by service charges which cause their actual revenues to be closer to the 25% mark. For instance, on page 4, the Water fund is at 20.3%, the Wastewater fund is at 18.6%, and the Landfill is at 27.9%. The Water and Wastewater funds’ revenues are under the 25% benchmark due to the accrual of revenues back to last fiscal year. Other funds with budget anomalies worth noting: the CDBG fund has actual revenues at 4.2% due to the timing of receipt of federal monies; and the Transit fund has actual revenues at 5.6% due to lower than normal ridership levels during the COVID-19 pandemic and the timing of federal grant receipts. Additionally, the Governmental Projects fund (page 4) has revenues at 0.2% due to the timing of grant receipts related to projects as well as the timing of the Bond Issuance that does not take place until the spring. In addition, on page 5, Culture and Recreation fees and Rents have returned to pre-pandemic levels at 23.3% and 28.8%, respectively, as programing has started back up. Parking Charges are still lagging behind normal levels but are starting to recover from initial COVID-19 impacts. The combined total actual revenues for all budgetary funds through September are $27,052,413 or 13,9% of budget. Overall, the City’s revenues are not substantially different than projected, and the anomalies and budget variances can be explained; however, the COVID-19 pandemic has impacted several funds and revenue streams, and will require monitoring and evaluation moving through the rest of the fiscal year. 1 Expenditure Analysis This expenditure analysis pertains to the reports, Expenditures by Fund and Expenditures by Fund by Department on pages 7-9. The analysis of the City’s expenditures for fiscal year 2022 through September is similar to the analysis for the City’s revenues. We generally expect the actual expenditure levels to be around 25% of budget at this time of year. Some of the funds have expenditure activity through the first quarter significantly above or below the 25% mark. The following funds have a significant expenditure variance from 25%: •Affordable Housing fund is at 52% due to payments made to the Housing Trust Fund of Johnson County. •Wastewater fund is at 45.7% due bond principal and interest payments paid in July. •Water fund is at 38.9% due to bond principal and interest payments paid in July. •Governmental Projects expenditures are at 7.4% and Enterprise Projects expenditures are at 5.9% because many of the capital projects are scheduled for construction next Spring. •Risk Management fund is at 46.4% due to the timing of insurance and liability entries. Overall, the combined total actual expenditures for all budgetary funds through September are $40,723,792 or 17.8% of budget. Overall, the City’s expenditures through the first quarter have a few major anomalies; however, these can be explained and are not unusual. Conclusion Generally, there are no major concerns to report with the City’s fund balances at September 30. One fund is presented (on page 3) with a negative fund balance, the CDBG fund at -$68,015. This negative fund balance should reverse following the receipt of grant proceeds. The other fund balances appear healthy. 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 50,650,417$ 8,686,682$ 3,183,703$ 15,923,563$ 1,600,953$ 44,996,286$ 15,516,681$ 29,479,605$ Special Revenue Funds 2100 Community Dev Block Grant 19,924 50,388 - 138,327 - (68,015) - (68,015) 2110 HOME 4,434 67,445 - 18,367 - 53,512 - 53,512 2200 Road Use Tax Fund 4,334,745 1,895,629 157,830 1,461,135 820,850 4,106,219 - 4,106,219 2300 Other Shared Revenue 8,813,343 36,227 - 9,263 - 8,840,307 - 8,840,307 2350 Metro Planning Org of J.C.438,463 51,447 97,679 176,558 - 411,030 - 411,030 2400 Employee Benefits 3,630,989 1,706,495 - 349,317 3,287,770 1,700,397 - 1,700,397 2450 Emergency Levy Fund 794,225 122,899 - 39,842 25,000 852,283 - 852,283 2500 Affordable Housing Fund 3,598,374 3,750 250,000 519,677 - 3,332,447 - 3,332,447 2510 Peninsula Apartments 194,571 53,456 - 40,989 - 207,039 - 207,039 26** Tax Increment Financing 1,421,524 204,263 - 212,182 - 1,413,605 1,159,892 253,713 2820 SSMID-Downtown District - 29,314 - -- 29,314 - 29,314 Debt Service Fund 5*** Debt Service 7,245,357 1,319,443 - 5,175 - 8,559,625 - 8,559,625 Enterprise Funds 710* Parking 2,272,962 1,059,975 222,500 971,560 366,365 2,217,511 451,202 1,766,309 715* Mass Transit 8,497,724 640,846 1,035,528 1,709,184 - 8,464,915 6,221,175 2,243,740 720* Wastewater 24,842,383 2,351,087 1,172,909 4,585,400 1,359,813 22,421,166 10,410,468 12,010,698 730* Water 12,812,181 2,200,254 794,846 3,638,402 794,329 11,374,551 4,999,873 6,374,677 7400 Refuse Collection 1,268,644 777,980 1,748 979,008 - 1,069,364 - 1,069,364 750* Landfill 25,728,087 2,047,912 115,466 1,272,661 - 26,618,804 23,650,615 2,968,189 7600 Airport 263,541 96,312 25,000 99,991 - 284,862 224,821 60,041 7700 Storm Water 1,484,174 333,758 375,329 123,895 435,000 1,634,366 704,000 930,366 79** Housing Authority 6,046,347 2,843,182 - 3,237,546 12,959 5,639,024 1,285,853 4,353,171 Capital Project Funds Governmental Projects 30,345,294 43,841 948,000 3,978,021 - 27,359,114 - 27,359,114 Enterprise Projects 12,267,485 429,828 322,500 1,233,729 - 11,786,085 - 11,786,085 Total Budgetary Funds 206,975,189$ 27,052,413$ 8,703,038$ 40,723,792$ 8,703,038$ 193,303,810$ 64,624,581$ 128,679,229$ Non-Budgetary Funds Internal Service Funds 810* Equipment 18,007,496$ 1,871,503$ -$ 876,705$ -$ 19,002,294$ 15,160,600$ 3,841,693$ 8200 Risk Management 4,314,361 1,039,215 - 793,762 - 4,559,815 - 4,559,815 830* Information Technology 3,545,082 605,400 - 685,841 - 3,464,641 1,307,028 2,157,613 8400 Central Services 798,111 58,187 - 61,629 - 794,669 - 794,669 8500 Health Insurance Reserves 12,309,571 2,853,074 - 2,371,744 - 12,790,901 9,697,868 3,093,033 8600 Dental Insurance Reserves 423,567 98,464 - 78,674 - 443,358 - 443,358 Total Non-Budgetary Funds 39,398,188$ 6,525,843$ -$ 4,868,355$ -$ 41,055,677$ 26,165,497$ 14,890,180$ Total All Funds 246,373,377$ 33,578,256$ 8,703,038$ 45,592,147$ 8,703,038$ 234,359,487$ 90,790,077$ 143,569,409$ City of Iowa City Fund Summary Fiscal Year 2023 through September 30, 2021 3 2021 Actual 2022 Budget 2022 Revised 2022 Actual Variance Percent Budgetary Fund Revenues General Fund 10** General Fund 59,021,824$ 58,854,140$ 59,406,832$ 8,686,682$ (50,720,150)$ 14.6% Special Revenue Funds 2100 Community Dev Block Grant 1,431,648 826,573 1,210,198 50,388 (1,159,810) 4.2% 2110 HOME 323,187 665,356 1,094,976 67,445 (1,027,530) 6.2% 2200 Road Use Tax Fund 10,241,077 9,293,500 9,293,500 1,895,629 (7,397,871) 20.4% 2300 Other Shared Revenue 9,162,595 - 351,659 36,227 (315,432) 10.3% 2350 Metro Planning Org of Johnson Co 385,456 394,296 394,296 51,447 (342,849) 13.0% 2400 Employee Benefits 14,799,472 14,901,826 14,901,826 1,706,495 (13,195,331) 11.5% 2450 Emergency Levy Fund 1,039,399 1,046,152 1,046,152 122,899 (923,253) 11.7% 2500 Affordable Housing Fund 1,836,537 - - 3,750 3,750 0.0% 2510 Peninsula Apartments 85,162 127,933 127,933 53,456 (74,477) 41.8% 26** Tax Increment Financing 2,679,150 4,125,528 4,125,528 204,263 (3,921,265) 5.0% 2820 SSMID-Downtown District 503,091 470,394 470,394 29,314 (441,080) 6.2% Debt Service Fund 5*** Debt Service 11,517,947 11,220,220 11,220,220 1,319,443 (9,900,777) 11.8% Enterprise Funds 710* Parking 3,817,435 5,977,526 5,977,526 1,059,975 (4,917,551) 17.7% 715* Mass Transit 4,614,597 11,360,399 11,360,399 640,846 (10,719,553) 5.6% 720* Wastewater 12,340,861 12,630,210 12,630,210 2,351,087 (10,279,123) 18.6% 730* Water 10,045,311 10,815,680 10,828,954 2,200,254 (8,628,700) 20.3% 7400 Refuse Collection 3,915,932 3,936,670 3,940,036 777,980 (3,162,056) 19.7% 750* Landfill 8,365,111 7,329,338 7,329,338 2,047,912 (5,281,426) 27.9% 7600 Airport 398,016 373,100 373,100 96,312 (276,788) 25.8% 7700 Storm Water 1,714,836 1,744,660 1,744,660 333,758 (1,410,902) 19.1% 79** Housing Authority 10,236,325 10,656,382 10,656,382 2,843,182 (7,813,200) 26.7% Capital Project Funds Governmental Projects 15,049,424 13,150,000 24,952,030 43,841 (24,908,189) 0.2% Enterprise Projects 1,733,157 292,500 1,057,393 429,828 (627,565) 40.6% Total Budgetary Revenues 185,257,551$ 180,192,383$ 194,493,541$ 27,052,413$ (167,441,128)$ 13.9% Non-Budgetary Fund Revenues Internal Service Funds 810* Equipment 7,496,050$ 7,629,691$ 7,629,691$ 1,871,503$ (5,758,188)$ 24.5% 8200 Risk Management 1,624,378 1,689,680 1,689,680 1,039,215 (650,465) 61.5% 830* Information Technology 2,910,525 2,833,011 2,833,011 605,400 (2,227,611) 21.4% 8400 Central Services 198,909 236,009 236,009 58,187 (177,822) 24.7% 8500 Health Insurance Reserves 10,559,371 11,118,580 11,118,580 2,853,074 (8,265,506) 25.7% 8600 Dental Insurance Reserves 396,698 441,458 441,458 98,464 (342,994) 22.3% Total Non-Budgetary Revenues 23,185,931$ 23,948,429$ 23,948,429$ 6,525,843$ (17,422,586)$ 27.2% Total Revenues - All Funds 208,443,482$ 204,140,812$ 218,441,970$ 33,578,256$ (184,863,714)$ 15.4% City of Iowa City Revenues by Fund Fiscal Year 2023 through September 30, 2021 4 2021 Actual 2022 Budget 2022 Revised 2022 Actual Variance Percent Budgetary Fund Revenues Property Taxes 66,780,996$ 66,911,637$ 66,911,637$ 8,031,553$ (58,880,084)$ 12.0% Other City Taxes: TIF Revenues 2,637,854 4,125,528 4,125,528 204,263 (3,921,265) 5.0% Gas/Electric Excise Taxes 643,961 636,270 636,270 - (636,270) 0.0% Mobile Home Taxes 63,002 51,710 51,710 12,561 (39,149) 24.3% Hotel/Motel Taxes 938,048 1,134,862 1,134,862 1 (1,134,861) 0.0% Utility Franchise Tax 993,852 883,660 883,660 2,144 (881,516) 0.2% Subtotal 5,276,717 6,832,030 6,832,030 218,968 (6,613,062) 3.2% Licenses, Permits, & Fees: General Use Permits 18,029 63,210 63,210 3,392 (59,818) 5.4% Food & Liquor Licenses 24,651 95,480 95,480 54,516 (40,964) 57.1% Professional License 3,760 5,050 5,050 590 (4,460) 11.7% Franchise Fees 441,264 581,900 581,900 283,305 (298,595) 48.7% Construction Permits & Insp Fees 1,707,958 1,774,840 1,774,840 519,822 (1,255,018) 29.3% Misc Lic & Permits 73,547 54,990 54,990 23,518 (31,472) 42.8% Subtotal 2,269,210 2,575,470 2,575,470 885,144 (1,690,326) 34.4% Intergovernmental: Fed Intergovernment Revenue 26,721,430 20,789,970 29,068,050 2,820,137 (26,247,913) 9.7% Property Tax Credits 1,593,623 1,544,912 1,544,912 - (1,544,912) 0.0% Road Use Tax 10,076,978 9,163,300 9,163,300 1,875,494 (7,287,806) 20.5% State 28E Agreements 2,128,143 1,964,420 2,014,420 - (2,014,420) 0.0% Operating Grants 61,849 66,980 66,980 - (66,980) 0.0% Disaster Assistance 2,700 - - - - 0.0% Other State Grants 2,257,948 1,532,465 5,172,043 619,725 (4,552,318) 12.0% Local 28E Agreements 1,343,940 1,313,480 2,913,480 515,244 (2,398,236) 17.7% Subtotal 44,186,611 36,375,527 49,943,185 5,830,601 (44,112,585) 11.7% Charges For Fees And Services: Building & Development 2,678,588 413,910 413,910 65,037 (348,873) 15.7% Police Services 13,523 98,710 98,710 7,777 (90,933) 7.9% Animal Care Services 11,742 13,480 13,480 4,286 (9,194) 31.8% Fire Services 11,734 8,880 8,880 1,860 (7,020) 20.9% Transit Fees 668,695 1,220,390 1,220,390 164,759 (1,055,631) 13.5% Culture & Recreation 267,221 696,126 696,126 162,071 (534,055) 23.3% Misc Charges For Services 57,336 61,234 61,234 19,161 (42,073) 31.3% Water Charges 9,937,678 9,851,600 9,851,600 2,138,603 (7,712,997) 21.7% Wastewater Charges 12,152,455 12,353,930 12,353,930 2,323,614 (10,030,316) 18.8% Refuse Charges 4,640,676 4,334,880 4,334,880 857,759 (3,477,121) 19.8% Landfill Charges 7,258,589 6,450,049 6,450,049 1,879,270 (4,570,779) 29.1% Storm Water Charges 1,700,792 1,730,060 1,730,060 331,473 (1,398,587) 19.2% Parking Charges 4,154,129 6,435,076 6,435,076 1,232,338 (5,202,738) 19.2% Subtotal 43,553,158 43,668,325 43,668,325 9,188,007 (34,480,318) 21.0% Miscellaneous: Code Enforcement 67,546 306,900 306,900 16,562 (290,338) 5.4% Parking Fines 505,391 488,220 488,220 357,631 (130,589) 73.3% Library Fines & Fees 4,328 50,000 50,000 1,083 (48,917) 2.2% Contributions & Donations 400,403 355,050 550,050 37,230 (512,820) 6.8% Printed Materials 20,871 38,175 38,175 4,181 (33,994) 11.0% Animal Adoption 49,080 45,000 45,000 19,205 (25,795) 42.7% Misc Merchandise 17,176 41,330 41,330 3,810 (37,520) 9.2% Intra-City Charges 5,025,342 5,812,165 5,812,165 1,369,891 (4,442,274) 23.6% Other Misc Revenue 938,489 824,129 824,129 135,661 (688,469) 16.5% Special Assessments 2,134 290 290 183 (107) 63.1% Subtotal 7,030,759$ 7,961,259$ 8,156,259$ 1,945,436$ (6,210,823)$ 23.9% City of Iowa City Revenues by Type Fiscal Year 2023 through September 30, 2021 5 2021 Actual 2022 Budget 2022 Revised 2022 Actual Variance Percent City of Iowa City Revenues by Type Fiscal Year 2023 through September 30, 2021 Use Of Money And Property: Interest Revenues 981,957$ 1,484,392$ 1,484,392$ 150,681$ (1,333,711)$ 10.2% Rents 1,084,618 1,264,564 1,264,564 364,614 (899,950) 28.8% Royalties & Commissions 120,765 108,354 108,354 33,492 (74,862) 30.9% Subtotal 2,187,340 2,857,310 2,857,310 548,786 (2,308,524) 19.2% Other Financial Sources: Debt Sales 12,744,378 12,150,000 12,150,000 - (12,150,000) 0.0% Sale Of Assets 616,257 521,242 1,059,742 174,654 (885,088) 16.5% Insurance Recoveries - - - - - 0.0% Loans 612,124 339,583 339,583 229,263 (110,320) 67.5% Subtotal 13,972,759 13,010,825 13,549,325 403,918 (13,145,407) 3.0% Total Budgetary Revenues 185,257,550$ 180,192,383$ 194,493,541$ 27,052,413$ (167,441,128) 13.9% Non-Budgetary Fund Revenues Internal Service Funds 23,185,931$ 23,948,429$ 23,948,429$ 6,525,843$ (17,422,586)$ 27.2% Total Non-Budgetary Revenues 23,185,931$ 23,948,429$ 23,948,429$ 6,525,843$ (17,422,586)$ 27.2% Total Revenues - All Funds 208,443,481$ 204,140,812$ 218,441,970$ 33,578,256$ (184,863,714)$ 15.4% 6 2021 Actual 2022 Budget 2022 Revised 2022 Actual Variance Percent Budgetary Fund Expenditures General Fund 10** General Fund 55,608,874$ 63,527,010$ 67,402,066$ 15,923,563$ 51,478,503$ 23.6% Special Revenue Funds 2100 Community Dev Block Grant 1,253,229 798,093 1,093,741 138,327 955,414 12.6% 2110 HOME 281,357 522,164 951,785 18,367 933,417 1.9% 2200 Road Use Tax Fund 6,893,442 6,715,409 6,775,409 1,461,135 5,314,274 21.6% 2300 Other Shared Revenue 351,891 - 351,659 9,263 342,396 2.6% 2350 Metro Planning Org of Johnson Co.759,938 813,751 813,751 176,558 637,193 21.7% 2400 Employee Benefits 1,790,332 1,426,486 1,426,486 349,317 1,077,169 24.5% 2450 Emergency Levy Fund 147,787 946,142 1,082,204 39,842 1,042,362 3.7% 2500 Affordable Housing Fund 860,507 1,000,000 1,000,000 519,677 480,323 52.0% 2510 Peninsula Apartments 76,763 72,187 72,187 40,989 31,198 56.8% 26** Tax Increment Financing 984,345 2,489,511 2,489,511 212,182 2,277,329 8.5% 2820 SSMID-Downtown District 507,191 470,394 470,394 - 470,394 0.0% Debt Service Fund 5*** Debt Service 14,652,318 13,084,764 13,084,764 5,175 13,079,589 0.0% Enterprise Funds 710* Parking 3,359,425 3,876,340 3,883,285 971,560 2,911,725 25.0% 715* Mass Transit 6,858,026 12,222,896 12,278,896 1,709,184 10,569,713 13.9% 720* Wastewater 9,722,217 10,036,454 10,036,454 4,585,400 5,451,054 45.7% 730* Water 9,063,101 9,272,922 9,349,669 3,638,402 5,711,267 38.9% 7400 Refuse Collection 3,798,095 4,033,627 4,047,092 979,008 3,068,085 24.2% 750* Landfill 5,617,439 5,731,930 5,741,874 1,272,661 4,469,213 22.2% 7600 Airport 417,765 372,257 372,257 99,991 272,267 26.9% 7700 Storm Water 597,005 648,988 648,988 123,895 525,092 19.1% 79** Housing Authority 11,967,304 10,390,103 10,390,103 3,237,546 7,152,556 31.2% Capital Project Funds Governmental Projects 17,905,672 18,165,470 54,034,592 3,978,021 50,056,571 7.4% Enterprise Projects 5,316,333 6,638,000 20,868,380 1,233,729 19,634,651 5.9% Total Budgetary Expenditures 158,790,354$ 173,254,898$ 228,665,547$ 40,723,792$ 187,941,755$ 17.8% Non-Budgetary Funds Expenditures Internal Service Funds 810* Equipment 6,650,876$ 5,419,368$ 6,333,191$ 876,705$ 5,456,486$ 13.8% 8200 Risk Management 1,423,612 1,710,211 1,710,211 793,762 916,449 46.4% 830* Information Technology 2,620,181 2,559,874 2,692,385 685,841 2,006,544 25.5% 8400 Central Services 146,775 207,587 239,587 61,629 177,958 25.7% 8500 Health Insurance Reserves 10,550,091 11,078,100 11,078,100 2,371,744 8,706,356 21.4% 8600 Dental Insurance Reserves 347,747 398,636 398,636 78,674 319,962 19.7% Total Non-Budgetary Expenditures 21,739,282$ 21,373,776$ 22,452,110$ 4,868,355$ 17,583,755$ 21.7% Total Expenditures - All Funds 180,529,636$ 194,628,674$ 251,117,657$ 45,592,147$ 205,525,510$ 18.2% City of Iowa City Expenditures by Fund Fiscal Year 2023 through September 30, 2021 7 2021 Actual 2022 Budget 2022 Revised 2022 Actual Variance Percent Budgetary Funds Expenditures General Fund 10** General Fund City Council 148,836$ 152,427$ 152,427$ 48,833$ 103,594$ 32.0% City Clerk 530,843 625,557 625,557 124,027 501,530 19.8% City Attorney 823,919 871,284 871,284 175,153 696,131 20.1% City Manager 4,078,706 4,391,026 5,753,526 993,313 4,760,214 17.3% Finance 3,853,885 4,696,984 4,809,584 1,746,243 3,063,341 36.3% Police 14,471,307 16,146,156 16,356,466 3,281,396 13,075,071 20.1% Fire 8,899,332 9,194,319 9,194,319 2,176,567 7,017,753 23.7% Parks & Recreation 8,340,197 10,351,897 10,628,598 2,268,812 8,359,787 21.3% Library 6,083,482 7,104,248 7,129,720 1,623,599 5,506,120 22.8% Senior Center 927,263 1,059,527 1,075,527 217,765 857,762 20.2% Neighborhood & Development Services 4,274,656 5,147,115 7,018,588 2,502,958 4,515,631 35.7% Public Works 2,568,025 3,148,619 3,148,619 624,386 2,524,233 19.8% Transportation & Resource Management 608,423 637,850 637,850 140,511 497,339 22.0% Total General Fund 55,608,874 63,527,010 67,402,066 15,923,563 51,478,503 23.6% Special Revenue Funds 2100 Community Dev Block Grant Neighborhood & Development Services 1,253,229 798,093 1,093,741 138,327 955,414 12.6% 2110 HOME Neighborhood & Development Services 281,357 522,164 951,785 18,367 933,417 1.9% 2200 Road Use Tax Fund Public Works 6,893,442 6,715,409 6,775,409 1,461,135 5,314,274 21.6% 2300 Other Shared Revenue Neighborhood & Development Services 351,891 - 351,659 9,263 342,396 2.6% 2350 Metro Planning Org of Johnson Co Neighborhood & Development Services 759,938 813,751 813,751 176,558 637,193 21.7% 2400 Employee Benefits Finance 1,790,332 1,426,486 1,426,486 349,317 1,077,169 24.5% 2450 Emergency Levy Fund City Manager 147,787 946,142 1,082,204 39,842 1,042,362 3.7% 2500 Affordable Housing Fund Neighborhood & Development Services 860,507 1,000,000 1,000,000 519,677 480,323 52.0% 2510 Iowa City Property Management Neighborhood & Development Services 76,763 72,187 72,187 40,989 31,198 56.8% 26** Tax Increment Financing Finance 984,345 2,489,511 2,489,511 212,182 2,277,329 8.5% 2820 SSMID-Downtown District Finance 507,191 470,394 470,394 - 470,394 0.0% Total Special Revenue Funds 13,906,781 15,254,137 16,527,127 2,965,658 13,561,469 17.9% Debt Service Fund 5*** Debt Service Finance 14,652,318 13,084,764 13,084,764 5,175 13,079,589 0.0% Total Debt Service Fund 14,652,318 13,084,764 13,084,764 5,175 13,079,589 0.0% City of Iowa City Expenditures by Fund by Department Fiscal Year 2023 through September 30, 2021 8 2021 Actual 2022 Budget 2022 Revised 2022 Actual Variance Percent City of Iowa City Expenditures by Fund by Department Fiscal Year 2023 through September 30, 2021 Enterprise Funds 710* Parking Transportation & Resource Management 3,359,425$ 3,876,340$ 3,883,285$ 971,560$ 2,911,725$ 25.0% 715* Mass Transit Transportation & Resource Management 6,858,026 12,222,896 12,278,896 1,709,184 10,569,713 13.9% 720* Wastewater Public Works 9,722,217 10,036,454 10,036,454 4,585,400 5,451,054 45.7% 730* Water Public Works 9,063,101 9,272,922 9,349,669 3,638,402 5,711,267 38.9% 7400 Refuse Collection Transportation & Resource Management 3,798,095 4,033,627 4,047,092 979,008 3,068,085 24.2% 750* Landfill Transportation & Resource Management 5,617,439 5,731,930 5,741,874 1,272,661 4,469,213 22.2% 7600 Airport Airport Operations 417,765 372,257 372,257 99,991 272,267 26.9% 7700 Storm Water Public Works 597,005 648,988 648,988 123,895 525,092 19.1% 79** Housing Authority Neighborhood & Development Services 11,967,304 10,390,103 10,390,103 3,237,546 7,152,556 31.2% Total Enterprise Funds 51,400,377 56,585,517 56,748,618 16,617,647 40,130,971 29.3% Capital Project Funds Governmental Projects 17,905,672 18,165,470 54,034,592 3,978,021 50,056,571 7.4% Enterprise Projects 5,316,333 6,638,000 20,868,380 1,233,729 19,634,651 5.9% Total Capital Project Funds 23,222,004 24,803,470 74,902,972 5,211,749 69,691,223 7.0% Total Budgetary Expenditures 158,790,354$ 173,254,898$ 228,665,547$ 40,723,792$ 187,941,755$ 17.8% Non-Budgetary Funds Expenditures Internal Service Funds 810* Equipment Public Works 6,650,876$ 5,419,368$ 6,333,191$ 876,705$ 5,456,486$ 13.8% 8200 Risk Management Finance 1,423,612 1,710,211 1,710,211 793,762 916,449 46.4% 830* Information Technology Finance 2,620,181 2,559,874 2,692,385 685,841 2,006,544 25.5% 8400 Central Services Finance 146,775 207,587 239,587 61,629 177,958 25.7% 8500 Health Insurance Reserves Finance 10,550,091 11,078,100 11,078,100 2,371,744 8,706,356 21.4% 8600 Dental Insurance Reserves Finance 347,747 398,636 398,636 78,674 319,962 19.7% Total Internal Service Funds 21,739,282 21,373,776 22,452,110 4,868,355 17,583,755 21.7% Total Non-Budgetary Expenditures 21,739,282$ 21,373,776$ 22,452,110$ 4,868,355$ 17,583,755$ 21.7% Total Expenditures - All Funds 180,529,636$ 194,628,674$ 251,117,657$ 45,592,147$ 205,525,510$ 18.2% 9