HomeMy WebLinkAboutFY2021 3rd Qtr Financial Summary
Date: April 15, 2021
To: City Manager, City Council
From: Jacklyn Fleagle, Budget & Compliance Officer
Re: Quarterly Financial Summary for Period Ending March 31, 2021
Introduction
Attached to this memorandum are the City’s quarterly financial reports as of March 31, 2021. The
quarterly financial report includes combined summaries of all fund balances, revenues, and
expenditures for Fiscal Year 2021 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 2022 budget process. The COVID-19 pandemic
continues to impact the City’s operations, and those revenues and expenditures impacted will be
highlighted below. Some of the highlights of the City’s financial activity through March 31 are also
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 include the Risk Management fund which
has actual revenues at 98.1% due to the timing of the entries made for loss reserve payments to
intra-city charges. Also worth noting are the CDBG Fund and Home Funds whose revenues are
at 34.1% and 25.7%, respectively. These funds’ revenues are below budget primarily due to the
timing of the grant activity. These percentages could change quickly depending on when the
Federal funds are received.
Several enterprise funds worth highlighting are the Parking Fund and the Transit Fund. The
Parking Fund has actual revenues at 77.4% of budget. The Parking Fund revenues are on track
with the amended budget amounts, which were reduced due to the impact of the COVID-19
pandemic. Compared to the original budget amounts, actual revenues are only at 44.4% of
budget. The revenue shortfall is related to lower revenues from hourly and on-street parking fees,
as demand for parking has not returned to pre-pandemic levels. The Transit Fund has actual
revenues at 43.8% due to the timing of receipt for the federal operating grant and decreased
ridership during the COVID-19 pandemic. While ridership levels have increased from this time
last year, levels are still down 60% from fiscal year 2019 levels at this time.
Finally, the Governmental Projects revenues are at only 6.3% of budget due to the timing of the
annual General Obligation Bond issuance. This fund’s revenues will be closer to budget after the
bond sale this spring.
On page 5, an example of a revenue type that is below the 75% mark is property tax revenue
which is at 57.9% of budget and reflects the timing of the property tax receipts. The second half
property taxes are due in April which should increase this percentage substantially. Other
revenues affected by the timing of property tax receipts include TIF Revenues which are at 56.0%
and Property Tax Credits which are at 41.6% of budget.
1
Under Charges for Fees & Services, Building & Development fees are well over the 75% mark at
559.6% of budget. Building & Development fee revenues are very high due to an Affordable
Housing fee-in-lieu-of payment received from the Tailwinds project that was more than $1.8
million. Culture and Recreation fees are also at 23.1% of budget due to program cancelations
with the ongoing COVID-19 pandemic.
In addition, under Intergovernmental on page 5, Other State Grants are at 15.6% of budget due
to the timing of receipts of grants for major road projects. Federal Intergovernmental revenues
are also at 46.2% of budget primarily due to the timing of receipts of grants for road projects, as
well as the timing of the receipt of the federal transit operating grant.
Finally, on page 6, under Other Financing Sources, Debt Sales revenue is at 0% of budget. We
are currently preparing to sell the 2021 general obligation bonds which will bring this revenue
source up near 100% of budget.
As of March 31, the combined total actual revenue for all budgetary funds is $102,939,218 or
56.4% of budget. In total, actual revenues as a percentage of budgeted revenues is slightly lower
in fiscal year 2021 than it was in fiscal year 2020. The impact of COVID-19 on the City’s revenues
is the main cause of this decrease in comparing year over year since fiscal year 2020 only saw
revenue impacts in the fourth quarter.
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 2021 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%:
• Employee Benefit Fund expenditures are at 110.7% primarily due to a high experience in
worker’s comp expenditures.
• Debt Service Fund expenditures are at 6.6%, because the general obligation bond
principal payments are not due until June 1.
• Governmental Projects expenditures are at 26.4% and Enterprise Projects expenditures
are at 17.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
$107,381,893 or 48.5% of budget. In reaction to the COVID-19 pandemic, the City has delayed
or cut capital outlay expenditures, left vacant positions unfilled and reduced various operating
expenditures such as travel and training. Additionally, some expenditures have naturally been
lower due to program closures.
Conclusion
Generally, there are no major concerns to report with the City’s fund balances at the end of March,
other than the Parking fund which will be continued to be monitored as demand for parking
continues to be low.
Three funds are presented (on page 3) with negative fund balances, the CDBG fund at -$252,367,
the HOME fund at -$26,553 and the SSMID fund at -$1,939. These negative fund balances
should reverse following the receipt of grant proceeds and property tax revenues. 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 41,640,906$ 36,627,081$ 9,636,186$ 39,561,116$ 4,887,865$ 43,455,193$ 11,582,728$ 31,872,465$
Special Revenue Funds
2100 Community Dev Block Grant (17,210) 713,545 - 807,418 141,285 (252,367) - (252,367)
2110 HOME (37,396) 222,721 - 211,877 - (26,553) - (26,553)
2200 Road Use Tax Fund 3,547,923 5,748,727 474,053 5,293,972 2,360,813 2,115,918 - 2,115,918
2300 Other Shared Revenue 2,639 - - - - 2,639 - 2,639
2350 Metro Planning Org of J.C.434,368 245,307 283,933 555,326 - 408,282 - 408,282
2400 Employee Benefits 3,584,853 8,553,750 - 1,462,573 9,952,916 723,114 - 723,114
2450 Emergency Levy Fund 2,613 591,162 - 25,994 75,000 492,781 - 492,781
2500 Affordable Housing Fund 1,622,344 1,831,820 750,000 772,139 - 3,432,025 - 3,432,025
2510 Iowa City Property Management 186,172 57,501 - 51,213 - 192,459 - 192,459
26** Tax Increment Financing 783,349 1,475,624 51,716 42,081 - 2,268,609 1,319,614 948,995
2820 SSMID-Downtown District 4,100 285,585 - 291,624 - (1,939) - (1,939)
Debt Service Fund
5*** Debt Service 9,354,037 6,577,127 - 954,784 - 14,976,380 1,801,017 13,175,364
Enterprise Funds
710* Parking 2,171,685 2,633,876 250,000 2,548,680 501,062 2,005,819 106,250 1,899,569
715* Mass Transit 6,914,358 1,950,778 3,060,066 4,788,281 - 7,136,921 5,074,737 2,062,184
720* Wastewater 23,423,905 8,380,912 3,898,545 7,756,955 4,458,063 23,488,344 12,327,255 11,161,089
730* Water 13,016,182 6,909,212 2,072,636 7,240,371 2,177,260 12,580,400 6,379,392 6,201,008
7400 Refuse Collection 1,690,269 2,667,881 8,738 2,821,364 - 1,545,524 - 1,545,524
750* Landfill 24,875,610 5,934,972 833,435 3,955,266 1,884,011 25,804,740 23,765,795 2,038,945
7600 Airport 235,540 283,784 75,000 306,996 46,000 241,328 181,071 60,257
7700 Storm Water 1,088,776 1,178,664 751,647 468,464 932,303 1,618,321 680,000 938,321
79** Housing Authority 7,828,046 7,956,104 - 9,971,554 38,040 5,774,555 1,278,376 4,496,180
Capital Project Funds
Governmental Projects 27,975,543 1,510,357 3,904,216 14,167,156 - 19,222,959 - 19,222,959
Enterprise Projects 10,086,942 602,727 1,396,886 3,326,689 8,759,866 - 8,759,866 -
Total Budgetary Funds 180,415,552$ 102,939,218$ 27,447,057$ 107,381,893$ 27,454,616$ 175,965,318$ 64,496,235$ 111,469,083$
Non-Budgetary Funds
Internal Service Funds
810* Equipment 17,243,785$ 5,548,576$ -$ 5,579,913$ (18,537)$ 17,230,985$ 13,998,005$ 3,232,980$
8200 Risk Management 4,113,594 1,615,711 - 1,088,188 - 4,641,117 - 4,641,117
830* Information Technology 3,254,738 2,375,813 - 1,845,261 - 3,785,290 853,658 2,931,632
8400 Central Services 756,956 145,130 - 96,909 10,978 794,198 - 794,198
8500 Health Insurance Reserves 12,300,290 7,939,829 - 8,130,000 - 12,110,120 8,627,420 3,482,700
8600 Dental Insurance Reserves 374,616 298,665 - 261,912 - 411,369 - 411,369
Total Non-Budgetary Funds 38,043,980$ 17,923,724$ -$ 17,002,183$ (7,559)$ 38,973,080$ 23,479,082$ 15,493,998$
Total All Funds 218,459,532$ 120,862,942$ 27,447,057$ 124,384,075$ 27,447,057$ 214,938,398$ 87,975,317$ 126,963,081$
City of Iowa City
Fund Summary
Fiscal Year 2021 through March 31, 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,440,679$ 36,627,081$ (22,813,598)$ 61.6%
Special Revenue Funds
2100 Community Dev Block Grant 696,930 784,935 2,095,404 713,545 (1,381,859) 34.1%
2110 HOME 890,256 599,082 868,153 222,721 (645,432) 25.7%
2200 Road Use Tax Fund 9,343,122 8,935,700 8,935,700 5,748,727 (3,186,973) 64.3%
2300 Other Shared Revenue 12,500 - 39,927 - (39,927) 0.0%
2350 Metro Planning Org of Johnson Co 393,607 377,352 394,167 245,307 (148,860) 62.2%
2400 Employee Benefits 12,798,747 14,712,009 14,712,009 8,553,750 (6,158,259) 58.1%
2450 Emergency Levy Fund 2,613 1,001,442 1,001,442 591,162 (410,280) 59.0%
2500 Affordable Housing Fund (26,615) - - 1,831,820 1,831,820 0.0%
2510 Iowa City Property Management 65,497 68,430 68,430 57,501 (10,929) 84.0%
26** Tax Increment Financing 3,479,948 2,608,203 2,608,203 1,475,624 (1,132,579) 56.6%
2820 SSMID-Downtown District 371,277 492,596 492,596 285,585 (207,011) 58.0%
Debt Service Fund
5*** Debt Service 12,084,974 11,450,899 11,450,899 6,577,127 (4,873,772) 57.4%
Enterprise Funds
710* Parking 4,555,583 5,935,900 3,402,700 2,633,876 (768,824) 77.4%
715* Mass Transit 5,114,607 4,457,460 4,450,305 1,950,778 (2,499,527) 43.8%
720* Wastewater 12,854,265 11,895,436 11,895,436 8,380,912 (3,514,524) 70.5%
730* Water 10,398,875 9,985,860 9,550,860 6,909,212 (2,641,648) 72.3%
7400 Refuse Collection 3,808,883 3,886,220 3,873,320 2,667,881 (1,205,439) 68.9%
750* Landfill 7,273,518 7,202,311 7,347,301 5,934,972 (1,412,329) 80.8%
7600 Airport 444,564 364,820 345,820 283,784 (62,036) 82.1%
7700 Storm Water 1,749,864 1,714,700 1,714,700 1,178,664 (536,036) 68.7%
79** Housing Authority 10,379,669 10,236,271 10,977,513 7,956,104 (3,021,409) 72.5%
Capital Project Funds
Governmental Projects 16,828,142 18,167,000 23,801,307 1,510,357 (22,290,950) 6.3%
Enterprise Projects 3,046,134 1,652,776 3,182,480 602,727 (2,579,753) 18.9%
Total Budgetary Revenues 170,660,713$ 175,794,240$ 182,649,351$ 102,939,218$ (79,710,133)$ 56.4%
Non-Budgetary Fund Revenues
Internal Service Funds
810* Equipment 7,106,528$ 7,448,587$ 7,508,587$ 5,548,576$ (1,960,011)$ 73.9%
8200 Risk Management 1,741,050 1,646,580 1,646,580 1,615,711 (30,869) 98.1%
830* Information Technology 2,693,000 2,495,792 2,495,792 2,375,813 (119,979) 95.2%
8400 Central Services 243,536 255,988 255,988 145,130 (110,858) 56.7%
8500 Health Insurance Reserves 10,272,878 11,196,638 11,196,638 7,939,829 (3,256,809) 70.9%
8600 Dental Insurance Reserves 411,351 458,475 458,475 298,665 (159,810) 65.1%
Total Non-Budgetary Revenues 22,468,344$ 23,502,060$ 23,562,060$ 17,923,724$ (5,638,336)$ 76.1%
Total Revenues - All Funds 193,129,057$ 199,296,300$ 206,211,411$ 120,862,942$ (85,348,469)$ 58.6%
City of Iowa City
Revenues by Fund
Fiscal Year 2021 through March 31, 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$ 38,118,270$ (27,730,866)$ 57.9%
Other City Taxes:
TIF Revenues 3,434,710 2,593,203 2,593,203 1,451,650 (1,141,553) 56.0%
Gas/Electric Excise Taxes 677,091 633,387 633,387 322,255 (311,132) 50.9%
Mobile Home Taxes 51,220 58,361 58,361 45,736 (12,625) 78.4%
Hotel/Motel Taxes 1,134,864 1,301,820 650,860 396,180 (254,680) 60.9%
Utility Franchise Tax 883,652 964,690 964,690 487,677 (477,013) 50.6%
Subtotal 6,181,536 5,551,461 4,900,501 2,703,499 (2,197,002) 55.2%
Licenses, Permits, & Fees:
General Use Permits 15,063 85,410 14,180 10,703 (3,477) 75.5%
Food & Liquor Licenses 95,476 126,710 126,710 17,606 (109,104) 13.9%
Professional License 3,925 6,160 6,160 2,805 (3,355) 45.5%
Franchise Fees 438,753 512,750 580,000 443,713 (136,287) 76.5%
Construction Permits & Insp Fees 1,742,746 1,954,820 1,794,820 1,270,669 (524,151) 70.8%
Misc Lic & Permits 68,060 49,620 49,620 54,879 5,259 110.6%
Subtotal 2,364,024 2,735,470 2,571,490 1,800,375 (771,115) 70.0%
Intergovernmental:
Fed Intergovernment Revenue 15,404,149 16,820,081 25,383,381 11,739,798 (13,643,583) 46.2%
Property Tax Credits 1,519,888 1,923,358 1,923,358 800,261 (1,123,097) 41.6%
Road Use Tax 9,163,303 8,820,140 8,820,140 5,618,011 (3,202,129) 63.7%
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 1,038,655 (5,618,940) 15.6%
Local 28E Agreements 1,280,923 2,883,620 2,900,435 1,134,596 (1,765,839) 39.1%
Subtotal 35,053,234 35,562,244 48,148,908 22,524,013 (25,624,895) 46.8%
Charges For Fees And Services:
Building & Development 492,643 428,570 428,570 2,398,465 1,969,895 559.6%
Police Services 188,901 100,000 30,000 9,648 (20,352) 32.2%
Animal Care Services 13,484 14,920 14,920 8,222 (6,698) 55.1%
Fire Services 8,880 9,060 9,060 9,934 874 109.6%
Transit Fees 968,924 1,220,390 750,390 464,029 (286,361) 61.8%
Culture & Recreation 467,105 776,548 568,278 131,517 (436,761) 23.1%
Misc Charges For Services 53,024 68,820 51,200 41,442 (9,759) 80.9%
Water Charges 10,051,603 9,748,310 9,448,310 6,824,210 (2,624,100) 72.2%
Wastewater Charges 12,353,935 11,631,416 11,631,416 8,244,099 (3,387,317) 70.9%
Refuse Charges 4,185,695 4,278,720 4,316,840 3,151,008 (1,165,832) 73.0%
Landfill Charges 5,961,888 6,224,330 6,410,000 5,172,704 (1,237,296) 80.7%
Storm Water Charges 1,730,056 1,700,000 1,700,000 1,168,928 (531,072) 68.8%
Parking Charges 4,795,660 6,378,760 3,775,260 3,038,197 (737,063) 80.5%
Subtotal 41,271,797 42,579,844 39,134,244 30,662,402 (8,471,842) 78.4%
Miscellaneous:
Code Enforcement 300,368 269,340 68,100 40,378 (27,722) 59.3%
Parking Fines 438,244 585,000 525,000 361,781 (163,219) 68.9%
Library Fines & Fees 60,545 100,000 10,000 3,239 (6,761) 32.4%
Contributions & Donations 496,111 309,310 544,237 239,349 (304,889) 44.0%
Printed Materials 39,128 46,710 46,710 13,850 (32,860) 29.7%
Animal Adoption 62,646 35,000 35,000 41,335 6,335 118.1%
Misc Merchandise 36,506 62,760 37,450 14,047 (23,403) 37.5%
Intra-City Charges 4,667,718 5,090,750 5,090,750 3,758,210 (1,332,540) 73.8%
Other Misc Revenue 913,580 795,155 769,200 433,981 (335,219) 56.4%
Special Assessments 294 570 570 884 314 155.1%
Subtotal 7,015,141$ 7,294,595$ 7,127,017$ 4,907,053$ (2,219,964)$ 68.9%
City of Iowa City
Revenues by Type
Fiscal Year 2021 through March 31, 2021
5
2020
Actual
2021
Budget
2021
Revised
2021
Actual Variance Percent
City of Iowa City
Revenues by Type
Fiscal Year 2021 through March 31, 2021
Use Of Money And Property:
Interest Revenues 3,277,337$ 1,705,802$ 1,209,842$ 782,524$ (427,318)$ 64.7%
Rents 1,177,377 1,331,104 1,062,629 713,098 (349,531) 67.1%
Royalties & Commissions 100,348 106,603 87,603 62,706 (24,897) 71.6%
Subtotal 4,555,062 3,143,509 2,360,074 1,558,328 (801,746) 66.0%
Other Financial Sources:
Debt Sales 13,012,385 11,871,140 11,161,140 - (11,161,140) 0.0%
Sale Of Assets 901,476 501,700 1,051,700 173,985 (877,715) 16.5%
Insurance Recoveries 2,258 - - - - 0.0%
Loans 943,633 705,141 345,141 491,293 146,152 142.3%
Subtotal 14,859,751 13,077,981 12,557,981 665,278 (11,892,703) 5.3%
Total Budgetary Revenues 170,660,713$ 175,794,240$ 182,649,351$ 102,939,218$ (79,710,133) 56.4%
Non-Budgetary Fund Revenues
Internal Service Funds 22,468,344$ 23,502,060$ 23,562,060$ 17,923,724$ (5,638,336)$ 76.1%
Total Non-Budgetary Revenues 22,468,344$ 23,502,060$ 23,562,060$ 17,923,724$ (5,638,336)$ 76.1%
Total Revenues - All Funds 193,129,057$ 199,296,300$ 206,211,411$ 120,862,942$ (85,348,469)$ 58.6%
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,291,804$ 39,561,116$ 24,730,688$ 61.5%
Special Revenue Funds
2100 Community Dev Block Grant 710,805 734,915 1,916,454 807,418 1,109,036 42.1%
2110 HOME 864,090 471,281 739,827 211,877 527,950 28.6%
2200 Road Use Tax Fund 6,541,337 6,860,459 6,918,828 5,293,972 1,624,856 76.5%
2300 Other Shared Revenue 1,810 - 39,927 - 39,927 0.0%
2350 Metro Planning Org of Johnson Co.666,417 785,929 784,616 555,326 229,290 70.8%
2400 Employee Benefits 1,380,902 1,321,730 1,321,730 1,462,573 (140,843) 110.7%
2450 Emergency Levy Fund - 900,800 900,800 25,994 874,806 2.9%
2500 Affordable Housing Fund 986,779 1,000,000 1,000,000 772,139 227,861 77.2%
2510 Iowa City Property Management 60,567 57,548 57,548 51,213 6,335 89.0%
26** Tax Increment Financing 1,545,792 1,240,029 1,159,444 42,081 1,117,363 3.6%
2820 SSMID-Downtown District 367,177 492,596 496,696 291,624 205,072 58.7%
Debt Service Fund
5*** Debt Service 13,038,331 14,519,819 14,519,819 954,784 13,565,035 6.6%
Enterprise Funds
710* Parking 13,153,203 6,937,252 4,271,531 2,548,680 1,722,851 59.7%
715* Mass Transit 8,285,908 7,988,973 7,916,023 4,788,281 3,127,742 60.5%
720* Wastewater 8,928,996 9,904,664 9,916,480 7,756,955 2,159,525 78.2%
730* Water 8,512,594 9,048,440 9,238,009 7,240,371 1,997,638 78.4%
7400 Refuse Collection 3,687,875 3,920,390 3,948,567 2,821,364 1,127,203 71.5%
750* Landfill 5,337,862 5,456,843 5,526,979 3,955,266 1,571,713 71.6%
7600 Airport 421,723 367,708 367,283 306,996 60,287 83.6%
7700 Storm Water 603,911 679,879 679,161 468,464 210,697 69.0%
79** Housing Authority 9,904,793 10,139,876 12,783,432 9,971,554 2,811,878 78.0%
Capital Project Funds
Governmental Projects 24,661,959 22,705,470 53,755,115 14,167,156 39,587,959 26.4%
Enterprise Projects 5,947,033 6,834,650 18,955,820 3,326,689 15,629,131 17.5%
Total Budgetary Expenditures 172,847,385$ 175,502,415$ 221,505,893$ 107,381,893$ 114,124,000$ 48.5%
Non-Budgetary Funds Expenditures
Internal Service Funds
810* Equipment 5,786,860$ 6,156,284$ 8,571,165$ 5,579,913$ 2,991,252$ 65.1%
8200 Risk Management 1,511,332 1,623,630 1,623,630 1,088,188 535,442 67.0%
830* Information Technology 2,430,267 2,513,842 2,513,842 1,845,261 668,581 73.4%
8400 Central Services 188,400 225,477 251,671 96,909 154,762 38.5%
8500 Health Insurance Reserves 9,129,477 11,070,318 11,070,318 8,130,000 2,940,318 73.4%
8600 Dental Insurance Reserves 295,202 449,071 449,071 261,912 187,159 58.3%
Total Non-Budgetary Expenditures 19,341,538$ 22,038,622$ 24,479,697$ 17,002,183$ 7,477,514$ 69.5%
Total Expenditures - All Funds 192,188,923$ 197,541,037$ 245,985,590$ 124,384,075$ 121,601,515$ 50.6%
City of Iowa City
Expenditures by Fund
Fiscal Year 2021 through March 31, 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$ 117,139$ 40,790$ 74.2%
City Clerk 491,473 524,699 557,494 380,368 177,126 68.2%
City Attorney 836,849 867,117 871,776 609,215 262,561 69.9%
City Manager 3,727,694 4,286,206 5,546,166 2,682,645 2,863,521 48.4%
Finance 4,089,409 4,631,600 4,908,111 2,919,343 1,988,768 59.5%
Police 14,503,070 15,667,193 15,777,126 10,461,398 5,315,728 66.3%
Fire 8,477,009 9,035,169 9,048,784 6,431,895 2,616,889 71.1%
Parks & Recreation 8,574,238 10,443,623 10,376,271 5,730,688 4,645,583 55.2%
Library 6,327,197 7,092,059 6,949,366 4,238,810 2,710,556 61.0%
Senior Center 913,616 1,038,668 1,027,646 657,879 369,767 64.0%
Neighborhood & Development Services 6,066,892 5,614,025 5,309,960 2,995,694 2,314,266 56.4%
Public Works 2,478,292 3,117,289 3,103,713 1,898,650 1,205,063 61.2%
Transportation & Resource Management 602,569 655,962 657,462 437,391 220,071 66.5%
Total General Fund 57,237,520 63,133,164 64,291,804 39,561,116 24,730,688 61.5%
Special Revenue Funds
2100 Community Dev Block Grant
Neighborhood & Development Services 710,805 734,915 1,916,454 807,418 1,109,036 42.1%
2110 HOME
Neighborhood & Development Services 864,090 471,281 739,827 211,877 527,950 28.6%
2200 Road Use Tax Fund
Public Works 6,541,337 6,860,459 6,918,828 5,293,972 1,624,856 76.5%
2300 Other Shared Revenue
Neighborhood & Development Services 1,810 - 39,927 - 39,927 0.0%
2350 Metro Planning Org of Johnson Co
Neighborhood & Development Services 666,417 785,929 784,616 555,326 229,290 70.8%
2400 Employee Benefits
Finance 1,380,902 1,321,730 1,321,730 1,462,573 (140,843) 110.7%
2450 Emergency Levy Fund
City Manager - 900,800 900,800 25,994 874,806 2.9%
2500 Affordable Housing Fund
Neighborhood & Development Services 986,779 1,000,000 1,000,000 772,139 227,861 77.2%
2510 Iowa City Property Management
Neighborhood & Development Services 60,567 57,548 57,548 51,213 6,335 89.0%
26** Tax Increment Financing
Finance 1,545,792 1,240,029 1,159,444 42,081 1,117,363 3.6%
2820 SSMID-Downtown District
Finance 367,177 492,596 496,696 291,624 205,072 58.7%
Total Special Revenue Funds 13,125,677 13,865,287 15,335,870 9,514,217 5,821,653 62.0%
Debt Service Fund
5*** Debt Service
Finance 13,038,331 14,519,819 14,519,819 954,784 13,565,035 6.6%
Total Debt Service Fund 13,038,331 14,519,819 14,519,819 954,784 13,565,035 6.6%
City of Iowa City
Expenditures by Fund by Department
Fiscal Year 2021 through March 31, 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 March 31, 2021
Enterprise Funds
710* Parking
Transportation & Resource Management 13,153,203$ 6,937,252$ 4,271,531$ 2,548,680$ 1,722,851$ 59.7%
715* Mass Transit
Transportation & Resource Management 8,285,908 7,988,973 7,916,023 4,788,281 3,127,742 60.5%
720* Wastewater
Public Works 8,928,996 9,904,664 9,916,480 7,756,955 2,159,525 78.2%
730* Water
Public Works 8,512,594 9,048,440 9,238,009 7,240,371 1,997,638 78.4%
7400 Refuse Collection
Transportation & Resource Management 3,687,875 3,920,390 3,948,567 2,821,364 1,127,203 71.5%
750* Landfill
Transportation & Resource Management 5,337,862 5,456,843 5,526,979 3,955,266 1,571,713 71.6%
7600 Airport
Airport Operations 421,723 367,708 367,283 306,996 60,287 83.6%
7700 Storm Water
Public Works 603,911 679,879 679,161 468,464 210,697 69.0%
79** Housing Authority
Neighborhood & Development Services 9,904,793 10,139,876 12,783,432 9,971,554 2,811,878 78.0%
Total Enterprise Funds 58,836,864 54,444,025 54,647,465 39,857,931 14,789,534 72.9%
Capital Project Funds
Governmental Projects 24,661,959 22,705,470 53,755,115 14,167,156 39,587,959 26.4%
Enterprise Projects 5,947,033 6,834,650 18,955,820 3,326,689 15,629,131 17.5%
Total Capital Project Funds 30,608,993 29,540,120 72,710,935 17,493,845 55,217,090 24.1%
Total Budgetary Expenditures 172,847,385$ 175,502,415$ 221,505,893$ 107,381,893$ 114,124,000$ 48.5%
Non-Budgetary Funds Expenditures
Internal Service Funds
810* Equipment
Public Works 5,786,860$ 6,156,284$ 8,571,165$ 5,579,913$ 2,991,252$ 65.1%
8200 Risk Management
Finance 1,511,332 1,623,630 1,623,630 1,088,188 535,442 67.0%
830* Information Technology
Finance 2,430,267 2,513,842 2,513,842 1,845,261 668,581 73.4%
8400 Central Services
Finance 188,400 225,477 251,671 96,909 154,762 38.5%
8500 Health Insurance Reserves
Finance 9,129,477 11,070,318 11,070,318 8,130,000 2,940,318 73.4%
8600 Dental Insurance Reserves
Finance 295,202 449,071 449,071 261,912 187,159 58.3%
Total Internal Service Funds 19,341,538 22,038,622 24,479,697 17,002,183 7,477,514 69.5%
Total Non-Budgetary Expenditures 19,341,538$ 22,038,622$ 24,479,697$ 17,002,183$ 7,477,514$ 69.5%
Total Expenditures - All Funds 192,188,923$ 197,541,037$ 245,985,590$ 124,384,075$ 121,601,515$ 50.6%
9