Loading...
FY2021 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