HomeMy WebLinkAboutFY2021 1st Qtr Financial Summary
Date: October 19, 2020
To: City Manager, City Council
From: Jacklyn Fleagle, Budget & Compliance Officer
Re: Quarterly Financial Summary for Period Ending September 30, 2020
Introduction
Attached to this memorandum are the City’s quarterly financial reports as of September 30,
2020. The quarterly financial report includes combined summaries of all fund balances,
revenues, and expenditures for fiscal year 2021 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, and the
Employee Benefits fund, their actual revenues are at 9.5%, 7.1%, and 6.8%, 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.9%,
the Wastewater fund is at 19.9%, and the Landfill is at 29.3%. The Water and Wastewater
funds’ revenues are under the 25% benchmark due to the accrual of revenues back to last fiscal
year and due to COVID-19 related revenue disruption.
Other funds with budget anomalies worth noting: the CDBG fund has actual revenues at 3.3%
due to the timing of receipt of federal monies; and the Transit fund has actual revenues at 8.0%
due to lower than normal ridership levels during the COVID-19 pandemic. Transit fund revenues
for the same period in fiscal year 2020 were at 17.4% of budgeted amounts. Additionally, the
Governmental Projects fund (page 4) has revenues at 0.3% due to the interest receivable
accrual as well as the timing of the Bond Issuance that does not take place until the Spring.
In addition, on page 5, Animal Adoption revenues are at 51.5% due to a larger amount of
adoptions so far this year. Culture and Recreation fees are at 7.0% due to program cancelations
with the ongoing COVID-19 pandemic. The COVID-19 pandemic has also had an impact on
Rent revenues, which are at 14.7%. Comparatively, Culture and Recreation fees were at 24.8%
and Rent revenues were at 26.7% for the same period in fiscal year 2020.
The combined total actual revenues for all budgetary funds through September are $22,196,713
or 11.6% 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 2021
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 the 25%
mark. The following funds have a significant expenditure variance above 25%:
• Affordable Housing fund is at 55.6% due to payments made to the Housing Trust Fund
of Johnson County.
• Wastewater fund is at 42.0% due bond principal and interest payments paid in July.
• Water fund is at 36.1% due to bond principal and interest payments paid in July.
• Governmental Projects expenditures are at 8.7% and Enterprise Projects expenditures
are at 7.8% because many of the capital projects are scheduled for construction next
Spring.
• Housing Authority fund is at 49.2% due to the purchase of affordable housing units
within the Chauncy and Augusta Place buildings.
Overall, the combined total actual expenditures for all budgetary funds through September are
$39,171,465 or 17.8% of budget. Some expenditures may be lower due to budget cuts or
revisions due to the COVID-19 pandemic. 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
other than the Parking Fund. The Parking Fund saw a large decrease in fund balance as a
result of a steep decline in revenues due to the COVID-19 pandemic and the payoff of the
Harrison Street Parking Ramp Lease Purchase Agreement. Two funds are presented (on page
3) with negative fund balances, the CDBG fund at -$7,902 and the Tax Increment Financing
fund at -$449.838. 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$ 5,826,964$ 3,787,670$ 13,148,484$ 1,373,219$ 36,733,837$ 11,518,543$ 25,215,293$
Special Revenue Funds
2100 Community Dev Block Grant (17,210) 69,980 - 60,340 332 (7,902) - (7,902)
2110 HOME (37,396) 113,424 - 17,684 - 58,343 - 58,343
2200 Road Use Tax Fund 3,547,923 1,738,558 176,572 1,474,475 659,804 3,328,775 - 3,328,775
2300 Other Shared Revenue 2,639 - - - - 2,639 - 2,639
2350 Metro Planning Org of J.C. 434,368 56,957 94,644 161,350 - 424,619 - 424,619
2400 Employee Benefits 3,584,853 996,501 - 587,463 3,911,801 82,090 - 82,090
2450 Emergency Levy Fund 2,613 71,516 - 9,614 25,000 39,515 - 39,515
2500 Affordable Housing Fund 1,622,344 2,825 250,000 556,383 - 1,318,786 - 1,318,786
2510 Peninsula Apartments 186,172 16,827 - 12,270 - 190,729 - 190,729
26** Tax Increment Financing 783,349 85,941 - - - 869,289 1,319,128 (449,838)
2820 SSMID-Downtown District 4,100 14,138 - - - 18,238 - 18,238
Debt Service Fund
5*** Debt Service 9,354,037 816,710 - 375 - 10,170,372 2,025,364 8,145,007
Enterprise Funds
710* Parking 2,171,685 1,176,726 250,000 669,757 455,851 2,472,802 112,500 2,360,302
715* Mass Transit 6,914,358 713,259 1,020,022 1,380,043 - 7,267,597 4,997,537 2,270,059
720* Wastewater 23,423,905 2,369,305 1,215,595 4,161,666 1,402,688 21,444,452 10,122,255 11,322,197
730* Water 13,016,182 2,082,311 690,370 3,276,292 690,016 11,822,555 5,155,983 6,666,572
7400 Refuse Collection 1,690,269 707,112 1,195 886,475 - 1,512,100 - 1,512,100
750* Landfill 24,875,610 2,090,591 114,259 1,072,366 - 26,008,093 22,904,691 3,103,402
7600 Airport 235,540 92,312 25,000 83,962 - 268,891 177,071 91,820
7700 Storm Water 1,088,776 313,229 250,225 139,188 312,303 1,200,739 300,000 900,739
79** Housing Authority 7,828,046 2,751,088 - 5,154,380 12,680 5,412,073 1,259,796 4,152,278
Capital Project Funds
Governmental Projects 27,827,791 78,308 583,140 5,026,363 - 23,462,875 - 23,462,875
Enterprise Projects 10,086,942 12,133 385,000 1,292,536 - 9,191,539 - 9,191,539
Total Budgetary Funds 180,267,800$ 22,196,713$ 8,843,693$ 39,171,465$ 8,843,693$ 163,293,047$ 59,892,869$ 103,400,179$
Non-Budgetary Funds
Internal Service Funds
810* Equipment 17,243,785$ 1,806,662$ -$ 1,316,797$ -$ 17,733,651$ 14,244,319$ 3,489,331$
8200 Risk Management 4,113,594 7,553 - 204,720 - 3,916,427 - 3,916,427
830* Information Technology 3,254,738 493,385 - 523,217 - 3,224,906 751,199 2,473,707
8400 Central Services 756,956 47,140 - 32,963 - 771,133 - 771,133
8500 Health Insurance Reserves 12,300,290 2,669,651 - 2,534,597 - 12,435,344 8,627,420 3,807,924
8600 Dental Insurance Reserves 374,616 100,327 - 89,860 - 385,083 - 385,083
Total Non-Budgetary Funds 38,043,980$ 5,124,718$ -$ 4,702,154$ -$ 38,466,544$ 23,622,939$ 14,843,605$
Total All Funds 218,311,780$ 27,321,431$ 8,843,693$ 43,873,620$ 8,843,693$ 201,759,591$ 83,515,807$ 118,243,784$
City of Iowa City
Fund Summary
Fiscal Year 2021 through September 30, 2020
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$ 61,070,420$ 5,826,964$ (55,243,456)$ 9.5%
Special Revenue Funds
2100 Community Dev Block Grant 696,930 784,935 2,095,404 69,980 (2,025,424) 3.3%
2110 HOME 890,256 599,082 868,153 113,424 (754,729) 13.1%
2200 Road Use Tax Fund 9,343,122 8,935,700 8,935,700 1,738,558 (7,197,142) 19.5%
2300 Other Shared Revenue 12,500 - 39,927 - (39,927) 0.0%
2350 Metro Planning Org of Johnson Co 393,607 377,352 377,352 56,957 (320,395) 15.1%
2400 Employee Benefits 12,798,747 14,712,009 14,712,009 996,501 (13,715,508) 6.8%
2450 Emergency Levy Fund 2,613 1,001,442 1,001,442 71,516 (929,926) 7.1%
2500 Affordable Housing Fund (26,615) - - 2,825 2,825 0.0%
2510 Peninsula Apartments 65,497 68,430 68,430 16,827 (51,603) 24.6%
26** Tax Increment Financing 3,479,948 2,608,203 2,608,203 85,941 (2,522,262) 3.3%
2820 SSMID-Downtown District 371,277 492,596 492,596 14,138 (478,458) 2.9%
Debt Service Fund
5*** Debt Service 12,084,974 11,450,899 11,450,899 816,710 (10,634,189) 7.1%
Enterprise Funds
710* Parking 4,555,583 5,935,900 5,141,800 1,176,726 (3,965,074) 22.9%
715* Mass Transit 5,114,607 4,457,460 8,867,330 713,259 (8,154,071) 8.0%
720* Wastewater 12,854,265 11,895,436 11,895,436 2,369,305 (9,526,131) 19.9%
730* Water 10,398,875 9,985,860 9,985,860 2,082,311 (7,903,549) 20.9%
7400 Refuse Collection 3,808,883 3,886,220 3,886,220 707,112 (3,179,108) 18.2%
750* Landfill 7,273,518 7,202,311 7,136,351 2,090,591 (5,045,760) 29.3%
7600 Airport 444,564 364,820 414,820 92,312 (322,508) 22.3%
7700 Storm Water 1,749,864 1,714,700 1,714,700 313,229 (1,401,471) 18.3%
79** Housing Authority 10,379,669 10,236,271 10,581,385 2,751,088 (7,830,297) 26.0%
Capital Project Funds
Governmental Projects 16,828,142 18,167,000 25,661,307 78,308 (25,582,999) 0.3%
Enterprise Projects 3,046,134 1,652,776 2,627,161 12,133 (2,615,028) 0.5%
Total Budgetary Revenues 170,660,713$ 175,794,240$ 191,632,905$ 22,196,713$ (169,436,192)$ 11.6%
Non-Budgetary Fund Revenues
Internal Service Funds
810* Equipment 7,106,528$ 7,448,587$ 7,448,587$ 1,806,662$ (5,641,925)$ 24.3%
8200 Risk Management 1,741,050 1,646,580 1,646,580 7,553 (1,639,027) 0.5%
830* Information Technology 2,693,000 2,495,792 2,495,792 493,385 (2,002,407) 19.8%
8400 Central Services 243,536 255,988 255,988 47,140 (208,848) 18.4%
8500 Health Insurance Reserves 10,272,878 11,196,638 11,196,638 2,669,651 (8,526,987) 23.8%
8600 Dental Insurance Reserves 411,351 458,475 458,475 100,327 (358,148) 21.9%
Total Non-Budgetary Revenues 22,468,344$ 23,502,060$ 23,502,060$ 5,124,718$ (18,377,342)$ 21.8%
Total Revenues - All Funds 193,129,057$ 199,296,300$ 215,134,965$ 27,321,431$ (187,813,534)$ 12.7%
City of Iowa City
Revenues by Fund
Fiscal Year 2021 through September 30, 2020
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$ 4,708,538$ (61,140,598)$ 7.2%
Other City Taxes:
TIF Revenues 3,434,710 2,593,203 2,593,203 82,365 (2,510,838) 3.2%
Gas/Electric Excise Taxes 677,091 633,387 633,387 - (633,387) 0.0%
Mobile Home Taxes 51,220 58,361 58,361 13,076 (45,285) 22.4%
Hotel/Motel Taxes 1,134,864 1,301,820 1,301,820 - (1,301,820) 0.0%
Utility Franchise Tax 883,652 964,690 964,690 1,893 (962,797) 0.2%
Subtotal 6,181,536 5,551,461 5,551,461 97,334 (5,454,127) 1.8%
Licenses, Permits, & Fees:
General Use Permits 15,063 85,410 85,410 2,132 (83,278) 2.5%
Food & Liquor Licenses 95,476 126,710 126,710 5,704 (121,006) 4.5%
Professional License 3,925 6,160 6,160 175 (5,985) 2.8%
Franchise Fees 438,753 512,750 512,750 143,150 (369,600) 27.9%
Construction Permits & Insp Fees 1,742,746 1,954,820 1,794,820 477,482 (1,317,338) 26.6%
Misc Lic & Permits 68,060 49,620 49,620 26,293 (23,327) 53.0%
Subtotal 2,364,024 2,735,470 2,575,470 654,936 (1,920,534) 25.4%
Intergovernmental:
Fed Intergovernment Revenue 15,404,149 16,820,081 30,534,533 2,745,160 (27,789,373) 9.0%
Property Tax Credits 1,519,888 1,923,358 1,923,358 - (1,923,358) 0.0%
Road Use Tax 9,163,303 8,820,140 8,820,140 1,681,845 (7,138,295) 19.1%
State 28E Agreements 2,107,692 1,976,419 2,014,419 2,891 (2,011,528) 0.1%
Operating Grants 66,984 69,580 69,580 21,460 (48,120) 30.8%
Other State Grants 5,510,294 3,069,046 6,479,392 99,363 (6,380,029) 1.5%
Local 28E Agreements 1,280,923 2,883,620 2,883,620 531,539 (2,352,081) 18.4%
Subtotal 35,053,234 35,562,244 52,725,042 5,082,257 (47,642,785) 9.6%
Charges For Fees And Services:
Building & Development 492,643 428,570 428,570 119,310 (309,260) 27.8%
Police Services 188,901 100,000 100,000 5,164 (94,836) 5.2%
Animal Care Services 13,484 14,920 14,920 2,540 (12,380) 17.0%
Fire Services 8,880 9,060 9,060 (120) (9,180) -1.3%
Transit Fees 968,924 1,220,390 750,390 120,199 (630,191) 16.0%
Culture & Recreation 467,105 776,548 591,548 41,641 (549,907) 7.0%
Misc Charges For Services 53,024 68,820 68,820 16,090 (52,730) 23.4%
Water Charges 10,051,603 9,748,310 9,748,310 2,065,032 (7,683,278) 21.2%
Wastewater Charges 12,353,935 11,631,416 11,631,416 2,303,656 (9,327,760) 19.8%
Refuse Charges 4,185,695 4,278,720 4,278,720 923,142 (3,355,578) 21.6%
Landfill Charges 5,961,888 6,224,330 6,224,330 1,782,615 (4,441,715) 28.6%
Storm Water Charges 1,730,056 1,700,000 1,700,000 310,416 (1,389,584) 18.3%
Parking Charges 4,795,660 6,378,760 5,354,660 1,562,814 (3,791,846) 29.2%
Subtotal 41,271,797 42,579,844 40,900,744 9,252,499 (31,648,245) 22.6%
Miscellaneous:
Code Enforcement 300,368 269,340 269,340 10,759 (258,581) 4.0%
Parking Fines 438,244 585,000 585,000 105,085 (479,916) 18.0%
Library Fines & Fees 60,545 100,000 50,000 1,649 (48,351) 3.3%
Contributions & Donations 496,111 309,310 544,237 52,661 (491,576) 9.7%
Printed Materials 39,128 46,710 46,710 3,372 (43,338) 7.2%
Animal Adoption 62,646 35,000 35,000 18,010 (16,990) 51.5%
Misc Merchandise 36,506 62,760 62,760 1,536 (61,224) 2.4%
Intra-City Charges 4,667,718 5,090,750 5,090,750 1,271,555 (3,819,195) 25.0%
Other Misc Revenue 913,580 795,155 795,155 113,372 (681,783) 14.3%
Special Assessments 294 570 570 14 (556) 2.5%
Subtotal 7,015,141$ 7,294,595$ 7,479,522$ 1,578,012$ (5,901,510)$ 21.1%
City of Iowa City
Revenues by Type
Fiscal Year 2021 through September 30, 2020
5
2020
Actual
2021
Budget
2021
Revised
2021
Actual Variance Percent
City of Iowa City
Revenues by Type
Fiscal Year 2021 through September 30, 2020
Use Of Money And Property:
Interest Revenues 3,277,337$ 1,705,802$ 1,639,842$ 335,797$ (1,304,045)$ 20.5%
Rents 1,177,377 1,331,104 1,196,104 176,065 (1,020,039) 14.7%
Royalties & Commissions 100,348 106,603 87,603 24,254 (63,349) 27.7%
Subtotal 4,555,062 3,143,509 2,923,549 536,116 (2,387,433) 18.3%
Other Financial Sources:
Debt Sales 13,012,385 11,871,140 11,871,140 - (11,871,140) 0.0%
Sale Of Assets 901,476 501,700 1,051,700 62,232 (989,469) 5.9%
Insurance Recoveries 2,258 - - - - 0.0%
Loans 943,633 705,141 705,141 224,790 (480,351) 31.9%
Subtotal 14,859,751 13,077,981 13,627,981 287,021 (13,340,960) 2.1%
Total Budgetary Revenues 170,660,713$ 175,794,240$ 191,632,905$ 22,196,713$ (169,436,192) 11.6%
Non-Budgetary Fund Revenues
Internal Service Funds 22,468,344$ 23,502,060$ 23,502,060$ 5,124,718$ (18,377,342)$ 21.8%
Total Non-Budgetary Revenues 22,468,344$ 23,502,060$ 23,502,060$ 5,124,718$ (18,377,342)$ 21.8%
Total Revenues - All Funds 193,129,057$ 199,296,300$ 215,134,965$ 27,321,431$ (187,813,534)$ 12.7%
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$ 63,586,483$ 13,148,484$ 50,437,999$ 20.7%
Special Revenue Funds
2100 Community Dev Block Grant 710,805 734,915 1,916,454 60,340 1,856,114 3.1%
2110 HOME 864,090 471,281 739,827 17,684 722,143 2.4%
2200 Road Use Tax Fund 6,541,337 6,860,459 6,918,828 1,474,475 5,444,353 21.3%
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 161,350 623,266 20.6%
2400 Employee Benefits 1,380,902 1,321,730 1,321,730 587,463 734,267 44.4%
2450 Emergency Levy Fund - 900,800 900,800 9,614 891,186 1.1%
2500 Affordable Housing Fund 986,779 1,000,000 1,000,000 556,383 443,617 55.6%
2510 Peninsula Apartments 60,567 57,548 57,548 12,270 45,278 21.3%
26** Tax Increment Financing 1,545,792 1,240,029 1,240,029 - 1,240,029 0.0%
2820 SSMID-Downtown District 367,177 492,596 492,596 - 492,596 0.0%
Debt Service Fund
5*** Debt Service 13,038,331 14,519,819 14,519,819 375 14,519,444 0.0%
Enterprise Funds
720* Wastewater 8,928,996 9,904,664 9,916,480 4,161,666 5,754,814 42.0%
730* Water 8,512,594 9,048,440 9,087,438 3,276,292 5,811,146 36.1%
7400 Refuse Collection 3,687,875 3,920,390 3,920,077 886,475 3,033,602 22.6%
750* Landfill 5,337,862 5,456,843 5,470,086 1,072,366 4,397,720 19.6%
7600 Airport 421,723 367,708 367,283 83,962 283,321 22.9%
7700 Storm Water 603,911 679,879 679,161 139,188 539,973 20.5%
79** Housing Authority 9,904,793 10,139,876 10,483,388 5,154,380 5,329,008 49.2%
Capital Project Funds
Governmental Projects 24,661,959 22,705,470 57,625,115 5,026,363 52,598,752 8.7%
Enterprise Projects 5,947,033 6,834,650 16,560,490 1,292,536 15,267,954 7.8%
Total Budgetary Expenditures 172,847,385$ 175,502,415$ 219,845,720$ 39,171,465$ 180,674,255$ 17.8%
Non-Budgetary Funds Expenditures
Internal Service Funds
810* Equipment 5,786,860$ 6,156,284$ 8,406,224$ 1,316,797$ 7,089,427$ 15.7%
8200 Risk Management 1,511,332 1,623,630 1,623,630 204,720 1,418,910 12.6%
830* Information Technology 2,430,267 2,513,842 2,513,842 523,217 1,990,625 20.8%
8400 Central Services 188,400 225,477 251,671 32,963 218,708 13.1%
8500 Health Insurance Reserves 9,129,477 11,070,318 11,070,318 2,534,597 8,535,721 22.9%
8600 Dental Insurance Reserves 295,202 449,071 449,071 89,860 359,211 20.0%
Total Non-Budgetary Expenditures 19,341,538$ 22,038,622$ 24,314,756$ 4,702,154$ 19,612,602$ 19.3%
Total Expenditures - All Funds 192,188,923$ 197,541,037$ 244,160,476$ 43,873,620$ 200,286,856$ 18.0%
City of Iowa City
Expenditures by Fund
Fiscal Year 2021 through September 30, 2020
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$ 38,368$ 119,561$ 24.3%
City Clerk 491,473 524,699 523,494 117,674 405,820 22.5%
City Attorney 836,849 867,117 871,776 190,901 680,875 21.9%
City Manager 3,727,694 4,286,206 4,541,791 993,829 3,547,962 21.9%
Finance 4,089,409 4,631,600 4,908,111 1,665,812 3,242,299 33.9%
Police 14,503,070 15,667,193 15,757,905 3,193,469 12,564,436 20.3%
Fire 8,477,009 9,035,169 9,048,784 2,062,188 6,986,596 22.8%
Parks & Recreation 8,574,238 10,443,623 10,340,271 1,778,651 8,561,620 17.2%
Library 6,327,197 7,092,059 6,949,366 1,279,810 5,669,556 18.4%
Senior Center 913,616 1,038,668 1,036,718 197,000 839,718 19.0%
Neighborhood & Development Services 6,066,892 5,614,025 5,709,960 912,046 4,797,914 16.0%
Public Works 2,478,292 3,117,289 3,084,416 586,115 2,498,301 19.0%
Transportation & Resource Management 602,569 655,962 655,962 132,622 523,340 20.2%
Total General Fund 57,237,520 63,133,164 63,586,483 13,148,484 50,437,999 20.7%
Special Revenue Funds
2100 Community Dev Block Grant
Neighborhood & Development Services 710,805 734,915 1,916,454 60,340 1,856,114 3.1%
2110 HOME
Neighborhood & Development Services 864,090 471,281 739,827 17,684 722,143 2.4%
2200 Road Use Tax Fund
Public Works 6,541,337 6,860,459 6,918,828 1,474,475 5,444,353 21.3%
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 161,350 623,266 20.6%
2400 Employee Benefits
Finance 1,380,902 1,321,730 1,321,730 587,463 734,267 44.4%
2450 Emergency Levy Fund
City Manager - 900,800 900,800 9,614
2500 Affordable Housing Fund
Neighborhood & Development Services 986,779 1,000,000 1,000,000 556,383 443,617 55.6%
2510 Peninsula Apartments
Neighborhood & Development Services 60,567 57,548 57,548 12,270 45,278 21.3%
26** Tax Increment Financing
Finance 1,545,792 1,240,029 1,240,029 - 1,240,029 0.0%
2820 SSMID-Downtown District
Finance 367,177 492,596 492,596 - 492,596 0.0%
Total Special Revenue Funds 13,125,677 13,865,287 15,412,355 2,879,578 12,532,777 18.7%
Debt Service Fund
5*** Debt Service
Finance 13,038,331 14,519,819 14,519,819 375 14,519,444 0.0%
Total Debt Service Fund 13,038,331 14,519,819 14,519,819 375 14,519,444 0.0%
City of Iowa City
Expenditures by Fund by Department
Fiscal Year 2021 through September 30, 2020
8
2020
Actual
2021
Budget
2021
Revised
2021
Actual Variance Percent
City of Iowa City
Expenditures by Fund by Department
Fiscal Year 2021 through September 30, 2020
Enterprise Funds
710* Parking
Transportation & Resource Management 13,153,203$ 6,937,252$ 4,393,602$ 669,757$ 3,723,845$ 15.2%
715* Mass Transit
Transportation & Resource Management 8,285,908 7,988,973 7,823,943 1,380,043 6,443,900 17.6%
720* Wastewater
Public Works 8,928,996 9,904,664 9,916,480 4,161,666 5,754,814 42.0%
730* Water
Public Works 8,512,594 9,048,440 9,087,438 3,276,292 5,811,146 36.1%
7400 Refuse Collection
Transportation & Resource Management 3,687,875 3,920,390 3,920,077 886,475 3,033,602 22.6%
750* Landfill
Transportation & Resource Management 5,337,862 5,456,843 5,470,086 1,072,366 4,397,720 19.6%
7600 Airport
Airport Operations 421,723 367,708 367,283 83,962 283,321 22.9%
7700 Storm Water
Public Works 603,911 679,879 679,161 139,188 539,973 20.5%
79** Housing Authority
Neighborhood & Development Services 9,904,793 10,139,876 10,483,388 5,154,380 5,329,008 49.2%
Total Enterprise Funds 58,836,864 54,444,025 52,141,458 16,824,129 35,317,329 32.3%
Capital Project Funds
Governmental Projects 24,661,959 22,705,470 57,625,115 5,026,363 52,598,752 8.7%
Enterprise Projects 5,947,033 6,834,650 16,560,490 1,292,536 15,267,954 7.8%
Total Capital Project Funds 30,608,993 29,540,120 74,185,605 6,318,899 67,866,706 8.5%
Total Budgetary Expenditures 172,847,385$ 175,502,415$ 219,845,720$ 39,171,465$ 180,674,255$ 17.8%
Non-Budgetary Funds Expenditures
Internal Service Funds
810* Equipment
Public Works 5,786,860$ 6,156,284$ 8,406,224$ 1,316,797$ 7,089,427$ 15.7%
8200 Risk Management
Finance 1,511,332 1,623,630 1,623,630 204,720 1,418,910 12.6%
830* Information Technology
Finance 2,430,267 2,513,842 2,513,842 523,217 1,990,625 20.8%
8400 Central Services
Finance 188,400 225,477 251,671 32,963 218,708 13.1%
8500 Health Insurance Reserves
Finance 9,129,477 11,070,318 11,070,318 2,534,597 8,535,721 22.9%
8600 Dental Insurance Reserves
Finance 295,202 449,071 449,071 89,860 359,211 20.0%
Total Internal Service Funds 19,341,538 22,038,622 24,314,756 4,702,154 19,612,602 19.3%
Total Non-Budgetary Expenditures 19,341,538$ 22,038,622$ 24,314,756$ 4,702,154$ 19,612,602$ 19.3%
Total Expenditures - All Funds 192,188,923$ 197,541,037$ 244,160,476$ 43,873,620$ 200,286,856$ 18.0%
9