HomeMy WebLinkAboutFY2022 3rd Qtr Financial Summary
Date: April 12, 2022
To: City Manager, City Council
From: Jacklyn Fleagle, Assistant Finance Director
Re: Quarterly Financial Summary for Period Ending March 31, 2022
Introduction
Attached to this memorandum are the City’s quarterly financial reports as of March 31, 2022.
The quarterly financial report includes combined summaries of all fund balances, revenues, and
expenditures for Fiscal Year 2022 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 2023 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 CDBG Fund and Home Fund
revenues are at 37.3% and 8.4%, respectively. Additionally, the Other Shared Revenue Fund is
at 3.8% of budget. These funds’ revenues are below budget primarily due to the timing of the
grant and federal awards activity. These percentages could change quickly depending on when
the Federal funds are received.
The Transit fund has actual revenues at 17.7% due to the timing of receipt for the federal
operating grant. Finally, the Governmental Projects fund has revenues at only 14.4% of budget
due to the timing of the Bond issuance. This fund should come up closer to budget after the
bond sale this spring.
On page 5, a few examples of revenues that are below the 75% mark include property tax
revenue which is at 60.5% 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.7% and Property Tax Credits which are at 50.3% of budget.
Within Licenses, Permits & Fees, General Use Permits are at 126.1% and Food & Liquor
Licenses are at 118.7% of budget. General Use Permits are high due to the timing and increase
in number of sidewalk café fees paid. Food & Liquor Licenses are up due to higher-than-
expected receipts.
Under Charges for Fees & Services, Building & Development fees are at 160.5% of budget.
Building & Development fees includes construction from last summer and fall and is a good
indicator of the amount of construction activity underway.
1
In addition, under Intergovernmental on page 5, State 28E Agreements are at 103.9% of budget
primarily due to the timing of the receipt of the Fire Contract with the University of Iowa. Other
State Grants are at 41.9% and Local 28E Agreements are at 19.5% of budget due to the timing
of receipts of grants for major road projects.
Finally, on page 6, under Other Financing Sources, Debt Sales revenue is at 0% of budget. We
are currently preparing to sell the 2022 general obligation bonds which will bring this revenue
source up to 100% of budget.
As of March 31, the combined total actual revenue for all budgetary funds is $109,609,422 or
53.5% 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 2022 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%:
• CDBG Fund and HOME Fund expenditures are at 42.7% and 4.0%, respectively, due to
the timing of the payout of loans and grants to applicants.
• Other Shared Revenue Fund expenditures are at 2.3% of budget primarily because of
American Rescue Plan Act funds budgeted but not yet spent.
• Iowa City Property Management Fund expenditures are at 197.4% of budget resulting
from the addition of the South District units previously unbudgeted. Revenues for the
fund mirror the higher expenditures.
• Debt Service Fund expenditures are at 7.5%, because the general obligation bond
principal payments are not due until June 1.
• The Airport Fund expenditures are at 83.7% of budget due to an increase in liability
insurance and maintenance repairs.
• Governmental Projects expenditures are at 21.4% and Enterprise Projects expenditures
are at 15.1% 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
$114,721,892 or 45.1% 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. One fund, the Community Development Block Grant (CDBG) Fund, is presented (on
page 3) with negative fund balance at -$26,699. This negative fund balance should be reversed
following the next receipt of CDBG 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 50,838,356$ 38,139,139$ 9,551,110$ 43,816,367$ 4,502,094$ 50,210,144$ 15,625,084$ 34,585,060$
Special Revenue Funds
2100 Community Dev Block Grant 19,924 451,083 - 467,265 30,441 (26,699) - (26,699)
2110 HOME 4,434 242,589 - 110,539 - 136,484 - 136,484
2200 Road Use Tax Fund 4,405,316 6,386,092 473,489 4,951,810 2,497,549 3,815,538 - 3,815,538
2300 Other Shared Revenue 8,813,343 381,959 - 435,375 - 8,759,928 - 8,759,928
2350 Metro Planning Org of J.C.438,463 253,263 293,036 552,784 - 431,978 - 431,978
2400 Employee Benefits 3,630,989 9,168,474 - 912,514 9,863,309 2,023,640 - 2,023,640
2450 Emergency Levy Fund 794,225 631,787 - 177,810 75,000 1,173,202 - 1,173,202
2500 Affordable Housing Fund 3,598,374 246,866 750,000 647,678 - 3,947,562 - 3,947,562
2510 Peninsula Apartments 194,571 172,852 - 142,497 - 224,927 - 224,927
26** Tax Increment Financing 1,421,524 2,239,555 - 945,756 - 2,715,323 959,892 1,755,431
2820 SSMID-Downtown District - 240,442 - 221,851 - 18,592 - 18,592
Debt Service Fund
5*** Debt Service 7,245,357 6,805,603 - 984,431 - 13,066,529 - 13,066,529
Enterprise Funds
710* Parking 2,272,962 3,485,468 667,500 3,151,724 1,099,096 2,175,111 746,202 1,428,909
715* Mass Transit 8,519,509 2,009,943 3,106,584 9,709,027 (27,425) 3,954,434 2,128,130 1,826,304
720* Wastewater 24,842,383 8,557,302 3,943,750 7,921,145 4,189,438 25,232,853 12,217,968 13,014,884
730* Water 12,833,162 7,620,027 2,384,558 7,431,746 2,382,986 13,023,015 6,926,998 6,096,017
7400 Refuse Collection 1,268,644 2,776,196 5,309 2,906,312 (6,125) 1,149,961 - 1,149,961
750* Landfill 25,728,087 5,489,363 1,029,036 3,863,402 682,639 27,700,445 24,651,139 3,049,306
7600 Airport 263,541 362,728 75,000 311,399 (17,540) 407,410 292,362 115,048
7700 Storm Water 1,487,988 1,208,002 1,126,001 421,544 1,305,000 2,095,447 1,334,000 761,447
79** Housing Authority 5,925,597 8,727,460 9,485,180 38,877 5,129,001 1,291,160 3,837,841
Capital Project Funds
Governmental Projects 29,917,442 3,158,973 2,610,554 11,555,329 - 24,131,640 - 24,131,640
Enterprise Projects 12,179,641 854,253 1,026,410 3,598,407 425,000 10,036,897 - 10,036,897
Total Budgetary Funds 206,643,834$ 109,609,422$ 27,042,338$ 114,721,892$ 27,040,338$ 201,533,363$ 66,172,935$ 135,360,428$
Non-Budgetary Funds
Internal Service Funds
810* Equipment 18,029,196$ 5,660,955$ -$ 3,170,898$ -$ 20,519,253$ 16,453,104$ 4,066,148$
8200 Risk Management 4,314,361 1,262,909 - 1,299,140 - 4,278,130 - 4,278,130
830* Information Technology 3,545,082 1,656,535 - 1,997,533 - 3,204,084 1,406,057 1,798,028
8400 Central Services 798,111 182,212 - 161,776 - 818,547 - 818,547
8500 Health Insurance Reserves 12,309,571 8,567,507 - 7,165,353 - 13,711,725 9,697,868 4,013,857
8600 Dental Insurance Reserves 423,567 299,654 - 258,375 - 464,846 - 464,846
Total Non-Budgetary Funds 39,419,888$ 17,629,773$ -$ 14,053,076$ -$ 42,996,585$ 27,557,029$ 15,439,556$
Total All Funds 246,063,722$ 127,239,195$ 27,042,338$ 128,774,968$ 27,040,338$ 244,529,948$ 93,729,964$ 150,799,984$
City of Iowa City
Fund Summary
Fiscal Year 2022 through March 31, 2022
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$ 38,139,139$ (21,267,693)$ 64.2%
Special Revenue Funds
2100 Community Dev Block Grant 1,431,648 826,573 1,210,198 451,083 (759,115) 37.3%
2110 HOME 323,187 665,356 2,884,958 242,589 (2,642,369) 8.4%
2200 Road Use Tax Fund 10,241,077 9,293,500 9,293,500 6,386,092 (2,907,408) 68.7%
2300 Other Shared Revenue 9,162,595 - 10,021,499 381,959 (9,639,540) 3.8%
2350 Metro Planning Org of Johnson Co 385,456 394,296 394,296 253,263 (141,033) 64.2%
2400 Employee Benefits 14,799,472 14,901,826 14,901,826 9,168,474 (5,733,352) 61.5%
2450 Emergency Levy Fund 1,039,399 1,046,152 1,046,152 631,787 (414,365) 60.4%
2500 Affordable Housing Fund 1,836,537 - - 246,866 246,866 0.0%
2510 Iowa City Property Management 85,162 127,933 127,933 172,852 44,919 135.1%
26** Tax Increment Financing 2,679,150 4,125,528 3,983,340 2,239,555 (1,743,785) 56.2%
2820 SSMID-Downtown District 503,091 470,394 470,394 240,442 (229,952) 51.1%
Debt Service Fund
5*** Debt Service 11,517,947 11,220,220 11,220,220 6,805,603 (4,414,617) 60.7%
Enterprise Funds
710* Parking 3,817,435 5,977,526 5,977,526 3,485,468 (2,492,058) 58.3%
715* Mass Transit 4,614,597 11,360,399 11,360,399 2,009,943 (9,350,456) 17.7%
720* Wastewater 12,340,861 12,630,210 12,630,210 8,557,302 (4,072,908) 67.8%
730* Water 10,045,311 10,815,680 10,828,954 7,620,027 (3,208,927) 70.4%
7400 Refuse Collection 3,915,932 3,936,670 3,956,436 2,776,196 (1,180,240) 70.2%
750* Landfill 8,365,111 7,329,338 7,329,338 5,489,363 (1,839,975) 74.9%
7600 Airport 398,016 373,100 373,100 362,728 (10,372) 97.2%
7700 Storm Water 1,714,836 1,744,660 1,744,660 1,208,002 (536,658) 69.2%
79** Housing Authority 10,236,325 10,656,382 11,930,650 8,727,460 (3,203,190) 73.2%
Capital Project Funds
Governmental Projects 15,049,424 13,150,000 21,902,030 3,158,973 (18,743,057) 14.4%
Enterprise Projects 1,733,157 292,500 2,047,942 854,253 (1,193,689) 41.7%
Total Budgetary Revenues 185,257,551$ 180,192,383$ 205,042,393$ 109,609,422$ (95,432,971)$ 53.5%
Non-Budgetary Fund Revenues
Internal Service Funds
810* Equipment 7,496,050$ 7,629,691$ 7,726,205$ 5,660,955$ (2,065,250)$ 73.3%
8200 Risk Management 1,624,378 1,689,680 1,689,680 1,262,909 (426,771) 74.7%
830* Information Technology 2,910,525 2,833,011 2,833,011 1,656,535 (1,176,476) 58.5%
8400 Central Services 198,909 236,009 236,009 182,212 (53,797) 77.2%
8500 Health Insurance Reserves 10,559,371 11,118,580 11,118,580 8,567,507 (2,551,073) 77.1%
8600 Dental Insurance Reserves 396,698 441,458 441,458 299,654 (141,804) 67.9%
Total Non-Budgetary Revenues 23,185,931$ 23,948,429$ 24,044,943$ 17,629,773$ (6,415,170)$ 73.3%
Total Revenues - All Funds 208,443,482$ 204,140,812$ 229,087,336$ 127,239,195$ (101,848,141)$ 55.5%
City of Iowa City
Revenues by Fund
Fiscal Year 2022 through March 31, 2022
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$ 40,512,800$ (26,398,837)$ 60.5%
Other City Taxes:
TIF Revenues 2,637,854 4,125,528 3,983,340 2,217,076 (1,766,264) 55.7%
Gas/Electric Excise Taxes 643,961 636,270 636,270 342,634 (293,636) 53.9%
Mobile Home Taxes 63,002 51,710 51,710 45,042 (6,668) 87.1%
Hotel/Motel Taxes 938,048 1,134,862 1,134,862 928,614 (206,248) 81.8%
Utility Franchise Tax 993,852 883,660 883,660 562,397 (321,263) 63.6%
Subtotal 5,276,717 6,832,030 6,689,842 4,095,763 (2,594,079) 61.2%
Licenses, Permits, & Fees:
General Use Permits 18,029 63,210 63,210 79,703 16,493 126.1%
Food & Liquor Licenses 24,651 95,480 95,480 113,373 17,893 118.7%
Professional License 3,760 5,050 5,050 2,165 (2,885) 42.9%
Franchise Fees 441,264 581,900 581,900 272,691 (309,209) 46.9%
Construction Permits & Insp Fees 1,707,958 1,774,840 1,774,840 1,370,240 (404,600) 77.2%
Misc Lic & Permits 73,547 54,990 54,990 53,955 (1,035) 98.1%
Subtotal 2,269,210 2,575,470 2,575,470 1,892,127 (683,343) 73.5%
Intergovernmental:
Fed Intergovernmental Revenue 26,721,430 20,789,970 42,627,648 11,613,371 (31,014,276) 27.2%
Property Tax Credits 1,593,623 1,544,912 1,544,912 777,309 (767,603) 50.3%
Road Use Tax 10,076,978 9,163,300 9,163,300 6,247,386 (2,915,914) 68.2%
State 28E Agreements 2,128,143 1,964,420 2,014,420 2,093,406 78,986 103.9%
Operating Grants 61,849 66,980 66,980 58,765 (8,215) 87.7%
Disaster Assistance 2,700 - 27,043 - (27,043) 0.0%
Other State Grants 2,257,948 1,532,465 4,310,043 1,805,911 (2,504,132) 41.9%
Local 28E Agreements 1,343,940 1,313,480 2,913,480 1,121,036 (1,792,444) 38.5%
Subtotal 44,186,611 36,375,527 62,667,825 23,717,183 (38,950,641) 37.8%
Charges For Fees And Services:
Building & Development 2,678,588 413,910 413,910 664,122 250,212 160.5%
Police Services 13,523 98,710 98,710 36,170 (62,540) 36.6%
Animal Care Services 11,742 13,480 13,480 10,955 (2,525) 81.3%
Fire Services 11,734 8,880 8,880 10,080 1,200 113.5%
Transit Fees 668,695 1,220,390 1,220,390 672,460 (547,930) 55.1%
Culture & Recreation 267,221 696,126 696,126 367,382 (328,744) 52.8%
Misc Charges For Services 57,336 61,234 61,234 48,312 (12,922) 78.9%
Water Charges 9,937,678 9,851,600 9,851,600 7,168,126 (2,683,474) 72.8%
Wastewater Charges 12,152,455 12,353,930 12,353,930 8,469,106 (3,884,824) 68.6%
Refuse Charges 4,640,676 4,334,880 4,334,880 3,134,278 (1,200,602) 72.3%
Landfill Charges 7,258,589 6,450,049 6,450,049 4,827,931 (1,622,118) 74.9%
Storm Water Charges 1,700,792 1,730,060 1,730,060 1,196,958 (533,102) 69.2%
Parking Charges 4,154,129 6,435,076 6,435,076 3,762,601 (2,672,475) 58.5%
Subtotal 43,553,158 43,668,325 43,668,325 30,368,480 (13,299,845) 69.5%
Miscellaneous:
Code Enforcement 67,546 306,900 306,900 73,883 (233,017) 24.1%
Parking Fines 505,391 488,220 488,220 725,421 237,201 148.6%
Library Fines & Fees 4,328 50,000 50,000 2,390 (47,610) 4.8%
Contributions & Donations 400,403 355,050 550,050 230,935 (319,115) 42.0%
Printed Materials 20,871 38,175 38,175 16,234 (21,941) 42.5%
Animal Adoption 49,080 45,000 45,000 49,230 4,230 109.4%
Misc Merchandise 17,176 41,330 41,330 18,228 (23,102) 44.1%
Intra-City Charges 5,025,342 5,812,165 5,812,165 4,204,134 (1,608,031) 72.3%
Other Misc Revenue 938,489 824,129 840,529 1,123,521 282,992 133.7%
Special Assessments 2,134 290 290 323 33 111.4%
Subtotal 7,030,759$ 7,961,259$ 8,172,659$ 6,444,299$ (1,728,360)$ 78.9%
City of Iowa City
Revenues by Type
Fiscal Year 2022 through March 31, 2022
5
2021
Actual
2022
Budget
2022
Revised
2022
Actual Variance Percent
City of Iowa City
Revenues by Type
Fiscal Year 2022 through March 31, 2022
Use Of Money And Property:
Interest Revenues 981,957$ 1,484,392$ 1,484,392$ 520,704$ (963,688)$ 35.1%
Rents 1,084,618 1,264,564 1,264,564 1,093,532 (171,032) 86.5%
Royalties & Commissions 120,765 108,354 108,354 93,168 (15,186) 86.0%
Subtotal 2,187,340 2,857,310 2,857,310 1,707,404 (1,149,906) 59.8%
Other Financial Sources:
Debt Sales 12,744,378 12,150,000 10,100,000 - (10,100,000) 0.0%
Sale Of Assets 616,257 521,242 1,059,742 259,380 (800,362) 24.5%
Loans 612,124 339,583 339,583 611,985 272,402 180.2%
Subtotal 13,972,759 13,010,825 11,499,325 871,365 (10,627,960) 7.6%
Total Budgetary Revenues 185,257,550$ 180,192,383$ 205,042,393$ 109,609,422$ (95,432,971) 53.5%
Non-Budgetary Fund Revenues
Internal Service Funds 23,185,931$ 23,948,429$ 24,044,943$ 17,629,773$ (6,415,170)$ 73.3%
Total Non-Budgetary Revenues 23,185,931$ 23,948,429$ 24,044,943$ 17,629,773$ (6,415,170)$ 73.3%
Total Revenues - All Funds 208,443,481$ 204,140,812$ 229,087,336$ 127,239,195$ (101,848,141)$ 55.5%
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,507,478$ 43,816,367$ 23,691,111$ 64.9%
Special Revenue Funds
2100 Community Dev Block Grant 1,253,229 798,093 1,093,741 467,265 626,476 42.7%
2110 HOME 281,357 522,164 2,741,766 110,539 2,631,227 4.0%
2200 Road Use Tax Fund 6,893,442 6,715,409 6,855,409 4,951,810 1,903,598 72.2%
2300 Other Shared Revenue 351,891 - 18,875,573 435,375 18,440,198 2.3%
2350 Metro Planning Org of Johnson Co.759,938 813,751 813,751 552,784 260,967 67.9%
2400 Employee Benefits 1,790,332 1,426,486 1,426,486 912,514 513,972 64.0%
2450 Emergency Levy Fund 147,787 946,142 1,082,204 177,810 904,394 16.4%
2500 Affordable Housing Fund 860,507 1,000,000 1,000,000 647,678 352,322 64.8%
2510 Iowa City Property Management 76,763 72,187 72,187 142,497 (70,310) 197.4%
26** Tax Increment Financing 984,345 2,489,511 2,611,853 945,756 1,666,097 36.2%
2820 SSMID-Downtown District 507,191 470,394 470,394 221,851 248,543 47.2%
Debt Service Fund
5*** Debt Service 14,652,318 13,084,764 13,191,264 984,431 12,206,833 7.5%
Enterprise Funds
710* Parking 3,359,425 3,876,340 4,493,285 3,151,724 1,341,561 70.1%
715* Mass Transit 6,858,026 12,222,896 12,278,896 9,709,027 2,569,869 79.1%
720* Wastewater 9,722,217 10,036,454 10,038,067 7,921,145 2,116,922 78.9%
730* Water 9,063,101 9,272,922 9,425,148 7,431,746 1,993,402 78.9%
7400 Refuse Collection 3,798,095 4,033,627 4,093,888 2,906,312 1,187,576 71.0%
750* Landfill 5,617,439 5,731,930 5,734,127 3,863,402 1,870,725 67.4%
7600 Airport 417,765 372,257 372,257 311,399 60,858 83.7%
7700 Storm Water 597,005 648,988 648,988 421,544 227,444 65.0%
79** Housing Authority 11,967,304 10,390,103 11,317,990 9,485,180 1,832,810 83.8%
Capital Project Funds
Governmental Projects 17,905,672 18,165,470 54,094,592 11,555,329 42,539,263 21.4%
Enterprise Projects 5,316,333 6,638,000 23,864,580 3,598,407 20,266,173 15.1%
Total Budgetary Expenditures 158,790,354$ 173,254,898$ 254,103,924$ 114,721,892$ 139,382,032$ 45.1%
Non-Budgetary Funds Expenditures
Internal Service Funds
810* Equipment 6,650,876$ 5,419,368$ 6,367,391$ 3,170,898$ 3,196,493$ 49.8%
8200 Risk Management 1,423,612 1,710,211 1,710,211 1,299,140 411,071 76.0%
830* Information Technology 2,620,181 2,559,874 2,692,385 1,997,533 694,852 74.2%
8400 Central Services 146,775 207,587 239,587 161,776 77,811 67.5%
8500 Health Insurance Reserves 10,550,091 11,078,100 11,078,100 7,165,353 3,912,747 64.7%
8600 Dental Insurance Reserves 347,747 398,636 398,636 258,375 140,261 64.8%
Total Non-Budgetary Expenditures 21,739,282$ 21,373,776$ 22,486,310$ 14,053,076$ 8,433,234$ 62.5%
Total Expenditures - All Funds 180,529,636$ 194,628,674$ 276,590,234$ 128,774,968$ 147,815,266$ 46.6%
City of Iowa City
Expenditures by Fund
Fiscal Year 2022 through March 31, 2022
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$ 119,332$ 33,095$ 78.3%
City Clerk 530,843 625,557 625,947 412,759 213,187 65.9%
City Attorney 823,919 871,284 872,818 607,049 265,768 69.6%
City Manager 4,078,706 4,391,026 5,789,138 2,827,197 2,961,941 48.8%
Finance 3,853,885 4,696,984 4,809,584 3,277,134 1,532,450 68.1%
Police 14,471,307 16,146,156 16,399,742 10,629,390 5,770,352 64.8%
Fire 8,899,332 9,194,319 9,194,319 6,665,710 2,528,609 72.5%
Parks & Recreation 8,340,197 10,351,897 10,648,198 6,431,111 4,217,088 60.4%
Library 6,083,482 7,104,248 7,129,720 4,923,749 2,205,970 69.1%
Senior Center 927,263 1,059,527 1,075,527 719,393 356,134 66.9%
Neighborhood & Development Services 4,274,656 5,147,115 7,018,588 4,686,294 2,332,294 66.8%
Public Works 2,568,025 3,148,619 3,148,619 2,040,776 1,107,844 64.8%
Transportation & Resource Management 608,423 637,850 642,850 476,473 166,377 74.1%
Total General Fund 55,608,874 63,527,010 67,507,478 43,816,367 23,691,111 64.9%
Special Revenue Funds
2100 Community Dev Block Grant
Neighborhood & Development Services 1,253,229 798,093 1,093,741 467,265 626,476 42.7%
2110 HOME
Neighborhood & Development Services 281,357 522,164 2,741,766 110,539 2,631,227 4.0%
2200 Road Use Tax Fund
Public Works 6,893,442 6,715,409 6,855,409 4,951,810 1,903,598 72.2%
2300 Other Shared Revenue
Neighborhood & Development Services 351,891 - 18,875,573 435,375 18,440,198 2.3%
2350 Metro Planning Org of Johnson Co
Neighborhood & Development Services 759,938 813,751 813,751 552,784 260,967 67.9%
2400 Employee Benefits
Finance 1,790,332 1,426,486 1,426,486 912,514 513,972 64.0%
2450 Emergency Levy Fund
City Manager 147,787 946,142 1,082,204 177,810 904,394 16.4%
2500 Affordable Housing Fund
Neighborhood & Development Services 860,507 1,000,000 1,000,000 647,678 352,322 64.8%
2510 Iowa City Property Management
Neighborhood & Development Services 76,763 72,187 72,187 142,497 (70,310) 197.4%
26** Tax Increment Financing
Finance 984,345 2,489,511 2,611,853 945,756 1,666,097 36.2%
2820 SSMID-Downtown District
Finance 507,191 470,394 470,394 221,851 248,543 47.2%
Total Special Revenue Funds 13,906,781 15,254,137 37,043,364 9,565,879 27,477,485 25.8%
Debt Service Fund
5*** Debt Service
Finance 14,652,318 13,084,764 13,191,264 984,431 12,206,833 7.5%
Total Debt Service Fund 14,652,318 13,084,764 13,191,264 984,431 12,206,833 7.5%
City of Iowa City
Expenditures by Fund by Department
Fiscal Year 2022 through March 31, 2022
8
2021
Actual
2022
Budget
2022
Revised
2022
Actual Variance Percent
City of Iowa City
Expenditures by Fund by Department
Fiscal Year 2022 through March 31, 2022
Enterprise Funds
710* Parking
Transportation & Resource Management 3,359,425$ 3,876,340$ 4,493,285$ 3,151,724$ 1,341,561$ 70.1%
715* Mass Transit
Transportation & Resource Management 6,858,026 12,222,896 12,278,896 9,709,027 2,569,869 79.1%
720* Wastewater
Public Works 9,722,217 10,036,454 10,038,067 7,921,145 2,116,922 78.9%
730* Water
Public Works 9,063,101 9,272,922 9,425,148 7,431,746 1,993,402 78.9%
7400 Refuse Collection
Transportation & Resource Management 3,798,095 4,033,627 4,093,888 2,906,312 1,187,576 71.0%
750* Landfill
Transportation & Resource Management 5,617,439 5,731,930 5,734,127 3,863,402 1,870,725 67.4%
7600 Airport
Airport Operations 417,765 372,257 372,257 311,399 60,858 83.7%
7700 Storm Water
Public Works 597,005 648,988 648,988 421,544 227,444 65.0%
79** Housing Authority
Neighborhood & Development Services 11,967,304 10,390,103 11,317,990 9,485,180 1,832,810 83.8%
Total Enterprise Funds 51,400,377 56,585,517 58,402,646 45,201,479 13,201,167 77.4%
Capital Project Funds
Governmental Projects 17,905,672 18,165,470 54,094,592 11,555,329 42,539,263 21.4%
Enterprise Projects 5,316,333 6,638,000 23,864,580 3,598,407 20,266,173 15.1%
Total Capital Project Funds 23,222,004 24,803,470 77,959,172 15,153,736 62,805,436 19.4%
Total Budgetary Expenditures 158,790,354$ 173,254,898$ 254,103,924$ 114,721,892$ 139,382,032$ 45.1%
Non-Budgetary Funds Expenditures
Internal Service Funds
810* Equipment
Public Works 6,650,876$ 5,419,368$ 6,367,391$ 3,170,898$ 3,196,493$ 49.8%
8200 Risk Management
Finance 1,423,612 1,710,211 1,710,211 1,299,140 411,071 76.0%
830* Information Technology
Finance 2,620,181 2,559,874 2,692,385 1,997,533 694,852 74.2%
8400 Central Services
Finance 146,775 207,587 239,587 161,776 77,811 67.5%
8500 Health Insurance Reserves
Finance 10,550,091 11,078,100 11,078,100 7,165,353 3,912,747 64.7%
8600 Dental Insurance Reserves
Finance 347,747 398,636 398,636 258,375 140,261 64.8%
Total Internal Service Funds 21,739,282 21,373,776 22,486,310 14,053,076 8,433,234 62.5%
Total Non-Budgetary Expenditures 21,739,282$ 21,373,776$ 22,486,310$ 14,053,076$ 8,433,234$ 62.5%
Total Expenditures - All Funds 180,529,636$ 194,628,674$ 276,590,234$ 128,774,968$ 147,815,266$ 46.6%
9