Loading...
HomeMy WebLinkAbout2024-11-18 I01H_01 2024 State Financial ReportAGENDA ITEM: CITY OF WAUKEE, IOWA CITY COUNCIL MEETING COMMUNICATION MEETING DATE: November 18th, 2024 AGENDA ITEM:Consideration of approval of a resolution approving State of Iowa 2024 Financial Report FORMAT:Consent Agenda SYNOPSIS INCLUDING PRO & CON: The Office of the Auditor of State recommends that the FY2024 Financial Report be presented for Council approval, although not required. The report is required to be published, and forwarded to the Auditor’s office by December 1st. FISCAL IMPACT INCLUDING COST/BENEFIT ANALYSIS: COMMISSION/BOARD/COMMITTEE COMMENT: STAFF REVIEW AND COMMENT: RECOMMENDATION: Approve the State of Iowa 2024 Financial Report as presented. ATTACHMENTS: I. Proposed Resolution II. State Annual Finance Report PREPARED BY:Rachel Downing REVIEWED BY: PUBLIC NOTICE INFORMATION – NAME OF PUBLICATION: DATE OF PUBLICATION: I1H1 THE CITY OF WAUKEE, IOWA RESOLUTION 2024- RESOLUTION OF THE CITY OF WAUKEE’S STATE OF IOWA 2024 FINANCIAL REPORT, AND DIRECTING THE FINANCE DIRECTOR FOR THE CITY OF WAUKEE TO FILE THE REPORT WITH THE AUDITOR OF STATE WHEREAS, The Waukee Finance Director has submitted to the City Council of the City of Waukee, the State of Iowa 2024 Financial Report for the City of Waukee, Iowa; AND WHEREAS, the report shows total Revenues in the amount of $177,834,024 and total Expenditures of $109,437,843 with an Ending Fund Balance of $257,479,986; AND WHEREAS, the report is required to be published and submitted to the Auditor of State by December 1st of each year; AND WHEREAS, the report will be published in the Dallas County News on Thursday, November 21st, 2024; NOW, THEREFORE, BE IT RESOLVED that the City of Waukee hereby approves the State of Iowa 2024 Financial Report and directs the Finance Director to submit it to the Auditor of State, this 18th day of November 2024. ____________________________ Courtney Clarke, Mayor Attest: ___________________________________ Rebecca D. Schuett, City Clerk RESULTS OF VOTE: AYE NAY ABSENT ABSTAIN R. Charles Bottenberg Chris Crone Rob Grove Anna Bergman Pierce Ben Sinclair STATE OF IOWA 2024 FINANCIAL REPORT FISCAL YEAR ENDED JUNE 30, 2024 CITY OF WAUKEE, IOWA DUE: December 1, 2024 16202501300000 CITY OF WAUKEE 230 W Hickman Road WAUKEE IA 50263 POPULATION: 23940 NOTE - The information supplied in this report will be shared by the Iowa State Auditor's Office, the U.S. Census Bureau, various public interest groups, and State and federal agencies. ALL FUNDS Governmental (a)Proprietary (b)Total Actual (c)Budget (d) Revenues and Other Financing Sources Taxes Levied on Property 23,290,169 23,290,169 23,236,917 Less: Uncollected Property Taxes-Levy Year 0 0 0 Net Current Property Taxes 23,290,169 23,290,169 23,236,917 Delinquent Property Taxes 1,632 1,632 0 TIF Revenues 7,815,523 7,815,523 7,622,600 Other City Taxes 5,867,554 0 5,867,554 6,389,554 Licenses and Permits 3,172,659 23,752,283 26,924,942 3,163,700 Use of Money and Property 5,430,373 2,007,859 7,438,232 6,718,700 Intergovernmental 4,926,977 0 4,926,977 4,392,245 Charges for Fees and Service 1,789,473 35,360,509 37,149,982 33,498,700 Special Assessments 21,631 0 21,631 0 Miscellaneous 1,257,430 266,974 1,524,404 1,266,350 Other Financing Sources 40,425,209 0 40,425,209 46,565,000 Transfers In 22,447,769 0 22,447,769 9,409,983 Total Revenues and Other Sources 116,446,399 61,387,625 177,834,024 142,263,749 Expenditures and Other Financing Uses Public Safety 21,106,162 21,106,162 12,917,030 Public Works 15,378,056 15,378,056 4,856,520 Health and Social Services 50,000 50,000 67,000 Culture and Recreation 8,038,628 8,038,628 4,797,550 Community and Economic Development 3,954,483 3,954,483 2,884,300 General Government 1,991,306 1,991,306 2,331,570 Debt Service 10,833,895 10,833,895 11,042,770 Capital Projects 292,152 292,152 46,515,950 Total Governmental Activities Expenditures 61,644,682 0 61,644,682 85,412,690 BUSINESS TYPE ACTIVITIES 25,345,392 25,345,392 47,845,482 Total All Expenditures 61,644,682 25,345,392 86,990,074 133,258,172 Other Financing Uses 0 0 0 Transfers Out 22,081,930 365,839 22,447,769 9,409,983 Total All Expenditures/and Other Financing Uses 83,726,612 25,711,231 109,437,843 142,668,155 Excess Revenues and Other Sources Over (Under) Expenditures/and Other Financing Uses 32,719,787 35,676,394 68,396,181 -404,406 Beginning Fund Balance July 1, 2023 58,333,845 130,749,960 189,083,805 125,996,138 Ending Fund Balance June 30, 2024 91,053,632 166,426,354 257,479,986 125,591,732 NOTE - These balances do not include the following, which were not budgeted and are not available for city operations: Non-budgeted Internal Service Funds Pension Trust Funds Private Purpose Trust Funds Agency Funds Indebtedness at June 30, 2024 Amount Indebtedness at June 30, 2024 Amount General Obligation Debt 140,418,790 Other Long-Term Debt 0 Revenue Debt 32,842,000 Short-Term Debt 55,087 TIF Revenue Debt 0 General Obligation Debt Limit 170,809,280 CERTIFICATION The forgoing report is correct to the best of my knowledge and belief Signature of Preparer Publication Printed name of Preparer Phone Number Signature of Mayor or Mayor Pro Tem (Name and Title) Date Signed PLEASE PUBLISH THIS PAGE ONLY 11/12/24, 2:08 PM Local Government Property Valuation System https://dom-localgov.iowa.gov/afr?id=8469 1/11 REVENUE P2 CITY OF WAUKEE REVENUE AND OTHER FINANCING SOURCES FOR YEAR ENDED JUNE 30, 2024 GAAP / Modified Item Description General (a) Special Revenue (b) TIF Special Revenue (c) Debt Service (d) Capital Projects (e) Permanent (f) Total Governmental (Sum of (a) through (f)) (g) Proprietary (h) Grand Total (Sum of (g) and (h)) (i) Section A - Taxes 1 1 Taxes levied on property 2 13,827,343 2,776,200 6,686,626 23,290,169 23,290,169 2 Less: Uncollected Property Taxes - Levy Year 3 0 0 3 Net Current Property Taxes 4 13,827,343 2,776,200 6,686,626 0 0 23,290,169 23,290,169 4 Delinquent Property Taxes 5 1,578 318 -264 1,632 1,632 5 Total Property Tax 6 13,828,921 2,776,518 6,686,362 0 0 23,291,801 23,291,801 6 TIF Revenues 7 7,815,523 7,815,523 7,815,523 7 Other City Taxes Utility Tax Replacement Excise Taxes 8 0 0 8 Utility Franchise Tax (Chapter 364.2, Code of Iowa)9 0 0 9 Parimutuel Wager Tax 10 0 0 10 Gaming Wager Tax 11 0 0 11 Mobile Home Tax 12 13,553 4,227 5,555 23,335 23,335 12 Hotel / Motel Tax 13 158,131 158,131 158,131 13 Other Local Option Taxes 14 5,686,088 5,686,088 5,686,088 14 Total Other City Taxes 15 171,684 5,690,315 5,555 0 0 5,867,554 0 5,867,554 15 Section B - Licenses and Permits 16 2,728,557 444,102 3,172,659 23,752,283 26,924,942 16 Section C - Use of Money and Property 17 17 Interest 18 669,814 1,313,603 517,229 500,934 2,068,052 5,069,632 1,916,723 6,986,355 18 Rents and Royalties 19 360,741 360,741 91,136 451,877 19 Other Miscellaneous Use of Money and Property 20 0 0 20 21 0 0 21 Total Use of Money and Property 22 1,030,555 1,313,603 517,229 500,934 2,068,052 0 5,430,373 2,007,859 7,438,232 22 Section D - Intergovernmental 24 24 Federal Grants and Reimbursements 26 26 Federal Grants 27 33,636 125,000 158,636 158,636 27 Community Development Block Grants 28 0 0 28 Housing and Urban Development 29 0 0 29 Public Assistance Grants 30 0 0 30 Payment in Lieu of Taxes 31 0 0 31 32 0 0 32 Total Federal Grants and Reimbursements 33 33,636 0 0 125,000 0 158,636 0 158,636 33 11/12/24, 2:08 PM Local Government Property Valuation System https://dom-localgov.iowa.gov/afr?id=8469 2/11 REVENUE P3 CITY OF WAUKEE REVENUE AND OTHER FINANCING SOURCES FOR YEAR ENDED JUNE 30, 2024 GAAP / Modified Item Description General (a) Special Revenue (b) TIF Special Revenue (c) Debt Service (d) Capital Projects (e) Permanent (f) Total Governmental (Sum of (a) through (f)) (g) Proprietary (h) Grand Total (Sum of (g) and (h)) (i) Section D - Intergovernmental - Continued 41 41 State Shared Revenues 43 43 Road Use Taxes 44 3,384,937 3,384,937 3,384,937 44 Other state grants and reimbursements 48 48 State grants 49 130,351 130,351 130,351 49 Iowa Department of Transportation 50 63,869 63,869 63,869 50 Iowa Department of Natural Resources 51 0 0 51 Iowa Economic Development Authority 52 0 0 52 CEBA grants 53 0 0 53 C&I Replacement and Tier I Business Tax Replacement 54 340,451 68,510 13,864 157,307 580,132 580,132 54 55 0 0 55 56 0 0 56 57 0 0 57 58 0 0 58 59 0 0 59 Total State 60 470,802 3,453,447 13,864 157,307 63,869 0 4,159,289 0 4,159,289 60 Local Grants and Reimbursements County Contributions 63 118,904 118,904 118,904 63 Library Service 64 18,725 18,725 18,725 64 Township Contributions 65 87,872 87,872 87,872 65 Fire/EMT Service 66 1,555 1,555 1,555 66 School District 67 327,209 327,209 327,209 67 Contract Buyout 68 4,787 4,787 4,787 68 Local Art Grant 69 50,000 50,000 50,000 69 Total Local Grants and Reimbursements 70 559,052 0 0 0 50,000 0 609,052 0 609,052 70 Total Intergovernmental (Sum of lines 33, 60, and 70)71 1,063,490 3,453,447 13,864 157,307 238,869 0 4,926,977 0 4,926,977 71 Section E -Charges for Fees and Service 72 72 Water 73 0 10,220,733 10,220,733 73 Sewer 74 0 9,556,435 9,556,435 74 Electric 75 0 0 75 Gas 76 0 10,549,442 10,549,442 76 Parking 77 0 0 77 Airport 78 0 0 78 Landfill/garbage 79 0 1,713,643 1,713,643 79 Hospital 80 0 0 80 11/12/24, 2:08 PM Local Government Property Valuation System https://dom-localgov.iowa.gov/afr?id=8469 3/11 REVENUE P4 CITY OF REVENUE AND OTHER FINANCING SOURCES FOR YEAR ENDED JUNE 30, GAAP / Modified Item Description General (a) Special Revenue (b) TIF Special Revenue (c) Debt Service (d) Capital Projects (e) Permanent (f) Total Governmental (Sum of (a) through (f)) (g) Proprietary (h) Grand Total (Sum of (g) and (h)) (i) Section E - Charges for Fees and Service - Continued 81 81 Transit 82 0 0 82 Cable TV 83 0 0 83 Internet 84 0 0 84 Telephone 85 0 0 85 Housing Authority 86 0 0 86 Storm Water 87 0 1,719,293 1,719,293 87 Other:88 88 Nursing Home 89 0 0 89 Police Service Fees 90 97,568 97,568 97,568 90 Prisoner Care 91 0 0 91 Fire Service Charges 92 1,915 1,915 1,915 92 Ambulance Charges 93 1,032,655 1,032,655 1,032,655 93 Sidewalk Street Repair Charges 94 0 0 94 Housing and Urban Renewal Charges 95 0 0 95 River Port and Terminal Fees 96 0 0 96 Public Scales 97 0 0 97 Cemetery Charges 98 0 0 98 Library Charges 99 0 0 99 Park, Recreation, and Cultural Charges 100 331,611 331,611 331,611 100 Animal Control Charges 101 3,500 3,500 3,500 101 Admin fees/Copies/Mechanic fees 102 322,224 322,224 322,224 102 Utility Billing/Golf Course 103 0 1,600,963 1,600,963 103 Total Charges for Service 104 1,789,473 0 0 0 0 0 1,789,473 35,360,509 37,149,982 104 Section F - Special Assesments 106 21,631 21,631 21,631 106 Section G - Miscellaneous 107 107 Contributions 108 35,907 500,000 535,907 3,698 539,605 108 Deposits and Sales/Fuel Tax Refunds 109 0 129,178 129,178 109 Sale of Property and Merchandise 110 447,098 32,539 479,637 112,989 592,626 110 Fines 111 17,567 17,567 17,567 111 Internal Service Charges 112 180 180 180 112 Damage Reimbursements/Misc 113 83,421 2,391 85,812 19,075 104,887 113 Wellness Reimbursement 114 76,202 76,202 76,202 114 Patronage Rebate 115 39,501 14,030 53,531 2,034 55,565 115 Fire Association 116 8,594 8,594 8,594 116 117 0 0 117 118 0 0 118 119 0 0 119 Total Miscellaneous 120 699,876 557,554 0 0 0 0 1,257,430 266,974 1,524,404 120 11/12/24, 2:08 PM Local Government Property Valuation System https://dom-localgov.iowa.gov/afr?id=8469 4/11 REVENUE P5 CITY OF REVENUE AND OTHER FINANCING SOURCES FOR YEAR ENDED JUNE 30, GAAP / Modified Item Description General (a) Special Revenue (b) TIF Special Revenue (c) Debt Service (d) Capital Projects (e) Permanent (f) Total Governmental (Sum of (a) through (f)) (g) Proprietary (h) Grand Total (Sum of (g) and (h)) (i) Total All Revenues (Sum of lines 6, 7, 15,16,22, 71, 104, 106, and 120)121 21,312,556 14,235,539 8,346,616 7,371,789 2,306,921 0 53,573,421 61,387,625 114,961,046 121 Section H - Other Financing Sources 123 123 Proceeds of capital asset sales 124 174,318 174,318 174,318 124 Proceeds of long-term debt (Excluding TIF internal borrowing)125 40,250,891 40,250,891 40,250,891 125 Proceeds of anticipatory warrants or other short-term debt 126 0 0 126 Regular transfers in and interfund loans 127 2,910,000 1,565,408 12,811,180 17,286,588 17,286,588 127 Internal TIF loans and transfers in 128 402,547 4,758,634 5,161,181 5,161,181 128 129 0 0 129 130 0 0 130 Total Other Financing Sources 131 3,486,865 0 0 6,324,042 53,062,071 0 62,872,978 0 62,872,978 131 Total Revenues Except for Beginning Balances (Sum of lines 121 and 131)132 24,799,421 14,235,539 8,346,616 13,695,831 55,368,992 0 116,446,399 61,387,625 177,834,024 132 Beginning Fund Balance July 1, 2023 134 12,634,247 20,877,766 4,108,002 7,704,258 13,009,572 58,333,845 130,749,960 189,083,805 134 Total Revenues and Other Financing Sources (Sum of lines 132 and 134)136 37,433,668 35,113,305 12,454,618 21,400,089 68,378,564 0 174,780,244 192,137,585 366,917,829 136 11/12/24, 2:08 PM Local Government Property Valuation System https://dom-localgov.iowa.gov/afr?id=8469 5/11 EXPENDITURES P6 CITY OF WAUKEE EXPENDITURES AND OTHER FINANCING USES FOR FISCAL YEAR ENDED JUNE 30, 2024 GAAP / Modified Item Description Line General (a) Special Revenue (b) TIF Special Revenue (c) Debt Service (d) Capital Projects (e) Permanent (f) Total Governmental (Sum of cols. (a) through (f)) (g) Proprietary (h) Grand Total (Sum of col. (g)) (i)Line Section A - Public Safety 1 1 Police Department/Crime Prevention 2 5,743,441 4,226,473 9,969,914 9,969,914 2 Jail 3 0 0 3 Emergency Management 4 11,526 11,526 11,526 4 Flood control 5 0 0 5 Fire Department 6 1,447,527 8,885 4,226,473 5,682,885 5,682,885 6 Ambulance 7 3,303,479 3,303,479 3,303,479 7 Building Inspections 8 1,186,351 1,186,351 1,186,351 8 Miscellaneous Protective Services 9 0 0 9 Animal Control 10 14,046 14,046 14,046 10 Other Public Safety 11 11,600 11,600 11,600 11 Westcom Dispatch 12 926,361 926,361 926,361 12 13 0 0 13 Total Public Safety 14 12,632,731 8,885 0 8,464,546 0 21,106,162 21,106,162 14 Section B - Public Works 15 15 Roads, Bridges, Sidewalks 16 3,116,814 9,451,182 12,567,996 12,567,996 16 Parking Meter and Off-Street 17 0 0 17 Street Lighting 18 314,272 314,272 314,272 18 Traffic Control Safety 19 162,002 624,994 786,996 786,996 19 Snow Removal 20 0 0 20 Highway Engineering 21 0 0 21 Street Cleaning 22 0 0 22 Airport (if not an enterprise)23 0 0 23 Garbage (if not an enterprise)24 0 0 24 Other Public Works 25 0 0 25 Public Works/PW Building/Mechanic 26 386,514 565,437 951,951 951,951 26 Engineering/GIS 27 756,841 756,841 756,841 27 Total Public Works 28 1,143,355 3,593,088 0 10,641,613 0 15,378,056 15,378,056 28 Section C - Health and Social Services 29 29 Welfare Assistance 30 0 0 30 City Hospital 31 0 0 31 Payments to Private Hospitals 32 0 0 32 Health Regulation and Inspections 33 0 0 33 Water, Air, and Mosquito Control 34 0 0 34 Community Mental Health 35 0 0 35 Other Health and Social Services 36 50,000 50,000 50,000 36 37 0 0 37 38 0 0 38 Total Health and Social Services 39 50,000 0 0 0 0 50,000 50,000 39 Section D - Culture and Recreation 40 40 Library Services 41 1,532,605 1,532,605 1,532,605 41 Museum, Band, Theater 42 0 0 42 Parks 43 1,100,539 1,867,505 2,968,044 2,968,044 43 Recreation 44 2,059,720 557,186 2,616,906 2,616,906 44 Cemetery 45 0 0 45 Community Center, Zoo, Marina, and Auditorium 46 36,440 36,440 36,440 46 Other Culture and Recreation 47 56,935 827,698 884,633 884,633 47 48 0 0 48 49 0 0 49 Total Culture and Recreation 50 4,786,239 0 0 3,252,389 0 8,038,628 8,038,628 50 11/12/24, 2:08 PM Local Government Property Valuation System https://dom-localgov.iowa.gov/afr?id=8469 6/11 EXPENDITURES P7 CITY OF EXPENDITURES AND OTHER FINANCING USES FOR FISCAL YEAR ENDED JUNE 30, -- Continued GAAP / Modified Item description Line General (a) Special Revenue (b) TIF Special Revenue (c) Debt Service (d) Capital Projects (e) Permanent (f) Total Governmental (Sum of cols. (a) through (f)) (g) Proprietary (h) Grand Total (Sum of col. (g)) (i)Line Section E - Community and EconomicDevelopment 51 51 Community beautification 52 0 0 52 Economic development 53 262,382 82,211 344,593 344,593 53 Housing and urban renewal 54 0 0 54 Planning and zoning 55 490,388 490,388 490,388 55 Other community and economic development 56 2,100,000 2,100,000 2,100,000 56 TIF Rebates 57 1,019,502 1,019,502 1,019,502 57 58 0 0 58 Total Community and Economic Development 59 752,770 0 1,101,713 0 2,100,000 0 3,954,483 3,954,483 59 Section F - General Government 60 60 Mayor, Council and City Manager 61 872,064 872,064 872,064 61 Clerk, Treasurer, Financial Administration 62 196,373 196,373 196,373 62 Elections 63 0 0 63 Legal Services and City Attorney 64 59,185 59,185 59,185 64 City Hall and General Buildings 65 190,724 124,066 314,790 314,790 65 Tort Liability 66 0 0 66 Other General Government 67 0 0 67 Human Resources 68 173,409 173,409 173,409 68 Information Technology 69 375,485 375,485 375,485 69 Total General Government 70 1,867,240 0 0 124,066 0 1,991,306 1,991,306 70 Section G - Debt Service 71 10,833,895 10,833,895 10,833,895 71 72 0 0 72 73 0 0 73 Total Debt Service 74 0 0 0 10,833,895 0 0 10,833,895 10,833,895 74 Section H - Regular Capital Projects - Specify 75 75 Debt Issuance 76 258,652 258,652 258,652 76 77 0 0 77 Subtotal Regular Capital Projects 78 0 0 0 258,652 0 258,652 258,652 78 TIF Capital Projects - Specify 79 79 Debt Issuance 80 33,500 33,500 33,500 80 81 0 0 81 Subtotal TIF Capital Projects 82 0 0 0 33,500 0 33,500 33,500 82 Total Capital Projects 83 0 0 0 292,152 0 292,152 292,152 83 Total Governmental Activities Expenditures 84 21,232,335 3,601,973 1,101,713 10,833,895 24,874,766 0 61,644,682 61,644,682 84 (Sum of lines 14, 28, 39, 50, 59, 70, 74, 83)85 85 TIF Rebates are expended out of the TIF Special Revenue Fund within the Community and Economic Development program's activity "Other" 11/12/24, 2:08 PM Local Government Property Valuation System https://dom-localgov.iowa.gov/afr?id=8469 7/11 EXPENDITURES P8 CITY OF EXPENDITURES AND OTHER FINANCING USES FOR FISCAL YEAR ENDED JUNE 30, -- Continued GAAP / Modified Item description Line General (a) Special Revenue (b) TIF Special Revenue (c) Debt Service (d) Capital Projects (e) Permanent (f) Total Governmental (Sum of cols. (a) through (f)) (g) Proprietary (h) Grand Total (Sum of col. (g)) (i)Line Section I - Business Type Activities 87 87 Water - Current Operation 88 7,087,446 7,087,446 88 Capital Outlay 89 12,339 12,339 89 Debt Service 90 145,418 145,418 90 Sewer and Sewage Disposal - Current Operation 91 3,964,013 3,964,013 91 Capital Outlay 92 21,155 21,155 92 Debt Service 93 389,747 389,747 93 Electric - Current Operation 94 0 94 Capital Outlay 95 0 95 Debt Service 96 0 96 Gas Utility - Current Operation 97 8,954,836 8,954,836 97 Capital Outlay 98 9,925 9,925 98 Debt Service 99 558 558 99 Parking - Current Operation 100 0 100 Capital Outlay 101 0 101 Debt Service 102 0 102 Airport - Current Operation 103 0 103 Capital Outlay 104 0 104 Debt Service 105 0 105 Landfill/Garbage - Current operation 106 2,010,883 2,010,883 106 Capital Outlay 107 0 107 Debt Service 108 68 68 108 Hospital - Current Operation 109 0 109 Capital Outlay 110 0 110 Debt Service 111 0 111 Transit - Current Operation 112 0 112 Capital Outlay 113 0 113 Debt Service 114 0 114 Cable TV, Telephone, Internet - Current Operation 115 0 115 Capital Outlay 116 0 116 Housing Authority - Current Operation 117 0 117 Capital Outlay 118 0 118 Debt Service 119 0 119 Storm Water - Current Operation 120 1,419,273 1,419,273 120 Capital Outlay 121 609 609 121 Debt Service 122 114,330 114,330 122 Other Business Type - Current Operation 123 738,269 738,269 123 Capital Outlay 124 0 124 Debt Service 125 1,093 1,093 125 Internal Service Funds - Specify 126 126 Utility Billing 127 475,430 475,430 127 128 0 128 Total Business Type Activities 129 25,345,392 25,345,392 129 11/12/24, 2:08 PM Local Government Property Valuation System https://dom-localgov.iowa.gov/afr?id=8469 8/11 EXPENDITURES P9 CITY OF WAUKEE EXPENDITURES AND OTHER FINANCING USES FOR FISCAL YEAR ENDED JUNE 30, 2024 -- Continued GAAP / Modified Item description Line General (a) Special Revenue (b) TIF Special Revenue (c) Debt Service (d) Capital Projects (e) Permanent (f) Total Governmental (Sum of cols. (a) through (f)) (g) Proprietary (h) Grand Total (Sum of col. (g)) (i) Line Subtotal Expenditures (Sum of lines 84 and 129)130 21,232,335 3,601,973 1,101,713 10,833,895 24,874,766 0 61,644,682 25,345,392 86,990,074 130 Section J - Other Financing Uses Including Transfers Out 131 131 Regular transfers out 132 16,920,749 16,920,749 365,839 17,286,588 132 Internal TIF loans/repayments and transfers out 133 5,161,181 5,161,181 5,161,181 133 134 0 0 134 Total Other Financing Uses 135 0 16,920,749 5,161,181 0 0 0 22,081,930 365,839 22,447,769 135 Total Expenditures and Other Financing Uses (Sum of lines 130 and 135)136 21,232,335 20,522,722 6,262,894 10,833,895 24,874,766 0 83,726,612 25,711,231 109,437,843 136 137 137 Ending fund balance June 30, :138 138 Governmental:139 139 Nonspendable 140 161,160 212,342 373,502 373,502 140 Restricted 141 190,818 14,378,241 6,191,724 10,566,194 43,503,798 74,830,775 74,830,775 141 Committed 142 1,622,351 1,622,351 1,622,351 142 Assigned 143 0 0 143 Unassigned 144 14,227,004 14,227,004 14,227,004 144 Total Governmental 145 16,201,333 14,590,583 6,191,724 10,566,194 43,503,798 0 91,053,632 91,053,632 145 Proprietary 146 166,426,354 166,426,354 146 Total Ending Fund Balance June 30,147 16,201,333 14,590,583 6,191,724 10,566,194 43,503,798 0 91,053,632 166,426,354 257,479,986 147 Total Requirements (Sum of lines 136 and 147)148 37,433,668 35,113,305 12,454,618 21,400,089 68,378,564 0 174,780,244 192,137,585 366,917,829 148 11/12/24, 2:08 PM Local Government Property Valuation System https://dom-localgov.iowa.gov/afr?id=8469 9/11 OTHER P10 Part III Intergovernmental Expenditures Please report below expenditures made to the State or to other local governments on a reimbursement or cost sharing basis. Include these expenditures in part II. Enter amount. Purpose Amount paid to other local governments Correction Health Highways 211,998 Transit Subsidies Libraries Police protection 938,613 Sewerage 1,734,783 Sanitation 29,925 All other 4,819,545 Purpose Amount paid to State Highways All other 4,922,105 Part IV Wages & Salaries Report here the total salaries and wages paid to all employees of your government before deductions of social security, retirement, etc. Include also salaries and wages paid to employees of any utility owned and operated by your government, as well as salaries and wages of municipal employees charged to construction projects. YOU ARE REQUIRED TO ENTER SALARY DOLLARS IN THE Amount areas FOR SALARIES AND WAGES PAID Amount Total Salaries and Wages Paid 15,308,015 Part V Debt Outstanding, Issued, and Retired Transit subsidies A. Long-Term Debt Debt During the Fiscal Year Debt Outstanding JUNE 30, 2024 Purpose Line Debt Outstanding JULY 1, 2023 Issued Retired General Obligation TIF Revenue Revenue Other Interest Paid This Year Water Utility 1.5,055,000 345,000 4,710,000 171,588 Sewer Utility 2.15,692,000 13,200,000 900,000 27,992,000 361,521 Electric Utility 3. Gas Utility 4. Transit-Bus 5. Industrial Revenue 6. Mortgage Revenue 7. TIF Revenue 8. Other Purposes / Miscellaneous 9. GO 10.108,167,173 38,305,000 6,053,382 140,418,790 4,799,361 Parking 11. Airport 12. Stormwater 13.205,000 65,000 140,000 3,900 Section 108 14. Total Long-Term 129,119,173 51,505,000 7,363,382 140,418,790 0 32,842,000 0 5,336,370 B. Short-Term Debt Amount Outstanding as of July 1, 2023 31,584 Outstanding as of JUNE 30, 2024 55,087 Part VI DEBT LIMITATION FOR GENERAL OBLIGATIONS Actual valuation -- January 1, 2022 Amount 3,416,185,614 x.05 = $170,809,280.7 Part VII CASH AND INVESTMENT ASSETS AS OF JUNE 30, 2024 Type of asset Cash and investments - Include cash on hand, CD's, time, checking and savings deposits, Federal securities, Federal agency securities, State and local government securities, and allother securities. Exclude value of real property. Amount Bond and interest funds (a)Bond construction funds (b)Pension/retirement funds (c)All other Funds (d)Total (e) 12,380,737 47,372,069 68,450,803 128,203,609 If you budget on a NON-GAAP CASH BASIS, the amount in the Total above SHOULD EQUAL the above summed amounts on the sheet All Funds P1: Ending fund balance, column C PLUS the amounts in the shaded Note area. 11/12/24, 2:08 PM Local Government Property Valuation System https://dom-localgov.iowa.gov/afr?id=8469 10/11 Notes & Remarks REMARKS - 11/12/24, 2:08 PM Local Government Property Valuation System https://dom-localgov.iowa.gov/afr?id=8469 11/11