Loading...
HomeMy WebLinkAbout2022-11-21 I01F_01 FY22 Annual Financial ReportAGENDA ITEM: CITY OF WAUKEE, IOWA CITY COUNCIL MEETING COMMUNICATION MEETING DATE: November 21st, 2022 AGENDA ITEM:Consideration of approval of a resolution approving State of Iowa 2022 Financial Report FORMAT:Consent Agenda SYNOPSIS INCLUDING PRO & CON: The Office of the Auditor of State recommends that the FY2022 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 2022 Financial Report as presented. ATTACHMENTS: I. Proposed Resolution II. State Annual Finance Report PREPARED BY:Linda Burkhart REVIEWED BY: PUBLIC NOTICE INFORMATION – NAME OF PUBLICATION: DATE OF PUBLICATION: I1F1 THE CITY OF WAUKEE, IOWA RESOLUTION 2022- RESOLUTION OF THE CITY OF WAUKEE’S STATE OF IOWA 2022 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 2022 Financial Report for the City of Waukee, Iowa; AND WHEREAS, the report shows total Revenues in the amount of $119,548,447 and total Expenditures of $105,413,791 with an Ending Fund Balance of $138,162,835; 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 Des Moines Register on Wednesday, November 30th, 2022; NOW, THEREFORE, BE IT RESOLVED that the City of Waukee hereby approves the State of Iowa 2022 Financial Report and directs the Finance Director to submit it to the Auditor of State, this 21st day of November 2022. ____________________________ Courtney Clarke, Mayor Attest: ___________________________________ Rebecca D. Schuett, City Clerk RESULTS OF VOTE: AYE NAY ABSENT ABSTAIN Anna Bergman Pierce R. Charles Bottenberg Chris Crone Larry R. Lyon Ben Sinclair STATE OF IOWA 2022 FINANCIAL REPORT FISCAL YEAR ENDED JUNE 30, 2022 CITY OF WAUKEE, IOWA DUE: December 1, 2022 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 17,628,065 17,628,065 17,483,278 Less: Uncollected Property Taxes-Levy Year 0 0 0 Net Current Property Taxes 17,628,065 17,628,065 17,483,278 Delinquent Property Taxes 0 0 0 TIF Revenues 8,290,500 8,290,500 8,747,646 Other City Taxes 5,100,510 0 5,100,510 3,339,696 Licenses and Permits 3,962,254 0 3,962,254 2,584,130 Use of Money and Property 476,239 244,772 721,011 432,200 Intergovernmental 6,649,779 1,799,283 8,449,062 5,955,289 Charges for Fees and Service 1,308,692 32,696,709 34,005,401 33,163,200 Special Assessments 106,807 0 106,807 0 Miscellaneous 3,175,477 396,482 3,571,959 565,730 Other Financing Sources 21,882,096 0 21,882,096 21,373,400 Transfers In 15,272,282 558,500 15,830,782 15,573,132 Total Revenues and Other Sources 83,852,701 35,695,746 119,548,447 109,217,701 Expenditures and Other Financing Uses Public Safety 9,348,218 9,348,218 9,390,490 Public Works 24,635,046 24,635,046 4,253,906 Health and Social Services 35,000 35,000 51,000 Culture and Recreation 15,330,617 15,330,617 3,293,535 Community and Economic Development 2,036,363 2,036,363 2,266,700 General Government 2,620,436 2,620,436 2,739,725 Debt Service 14,797,659 14,797,659 14,973,500 Capital Projects 132,075 132,075 44,945,000 Total Governmental Activities Expenditures 68,935,414 0 68,935,414 81,913,856 BUSINESS TYPE ACTIVITIES 20,647,595 20,647,595 33,871,668 Total All Expenditures 68,935,414 20,647,595 89,583,009 115,785,524 Other Financing Uses 0 0 0 Transfers Out 14,765,893 1,064,889 15,830,782 15,573,132 Total All Expenditures/and Other Financing Uses 83,701,307 21,712,484 105,413,791 131,358,656 Excess Revenues and Other Sources Over (Under) Expenditures/and Other Financing Uses 151,394 13,983,262 14,134,656 -22,140,955 Beginning Fund Balance July 1, 2021 49,738,570 74,289,609 124,028,179 104,299,557 Ending Fund Balance June 30, 2022 49,889,964 88,272,871 138,162,835 82,158,602 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, 2022 Amount Indebtedness at June 30, 2022 Amount General Obligation Debt 101,540,037 Other Long-Term Debt 0 Revenue Debt 22,240,508 Short-Term Debt 45,220 TIF Revenue Debt 0 General Obligation Debt Limit 127,379,973 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 other City official (Name and Title) Date Signed PLEASE PUBLISH THIS PAGE ONLY REVENUE P2 CITY OF WAUKEE REVENUE AND OTHER FINANCING SOURCES FOR YEAR ENDED JUNE 30, 2022 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 9,821,636 2,580,582 5,225,847 17,628,065 17,628,065 2 Less: Uncollected Property Taxes - Levy Year 3 0 0 3 Net Current Property Taxes 4 9,821,636 2,580,582 5,225,847 0 0 17,628,065 17,628,065 4 Delinquent Property Taxes 5 0 0 5 Total Property Tax 6 9,821,636 2,580,582 5,225,847 0 0 17,628,065 17,628,065 6 TIF Revenues 7 8,290,500 8,290,500 8,290,500 7 Other City Taxes Utility Tax Replacement Excise Taxes 8 0 0 8 Utility Franchise Tax (Chapter 364.2, Code ofIowa)9 0 0 9 Parimutuel Wager Tax 10 0 0 10 Gaming Wager Tax 11 0 0 11 Mobile Home Tax 12 12,740 3,155 5,354 21,249 21,249 12 Hotel / Motel Tax 13 128,358 128,358 128,358 13 Other Local Option Taxes 14 4,950,903 4,950,903 4,950,903 14 Total Other City Taxes 15 141,098 4,954,058 5,354 0 0 5,100,510 0 5,100,510 15 Section B - Licenses and Permits 16 2,854,799 45,161 1,062,294 3,962,254 3,962,254 16 Section C - Use of Money and Property 17 17 Interest 18 34,821 64,566 46,530 18,018 104,426 268,361 167,833 436,194 18 Rents and Royalties 19 207,878 207,878 76,939 284,817 19 Other Miscellaneous Use of Money and Property 20 0 0 20 21 0 0 21 Total Use of Money and Property 22 242,699 64,566 46,530 18,018 104,426 0 476,239 244,772 721,011 22 Section D - Intergovernmental 24 24 Federal Grants and Reimbursements 26 26 Federal Grants 27 13,187 4,423 160,000 177,610 1,799,283 1,976,893 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 13,187 4,423 0 160,000 0 177,610 1,799,283 1,976,893 33 REVENUE P3 CITY OF WAUKEE REVENUE AND OTHER FINANCING SOURCES FOR YEAR ENDED JUNE 30, 2022 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,132,454 3,132,454 3,132,454 44 Other state grants and reimbursements 48 48 State grants 49 32,990 32,990 32,990 49 Iowa Department of Transportation 50 1,774,434 1,774,434 1,774,434 50 Iowa Department of Natural Resources 51 1,574 1,574 1,574 51 Iowa Economic Development Authority 52 0 0 52 CEBA grants 53 0 0 53 Commercial & Industrial Replacement Claim 54 32,548 8,539 516,389 47,078 604,554 604,554 54 55 0 0 55 56 0 0 56 57 0 0 57 58 0 0 58 59 0 0 59 Total State 60 67,112 3,140,993 516,389 47,078 1,774,434 0 5,546,006 0 5,546,006 60 Local Grants and Reimbursements County Contributions 63 190,340 500 190,840 190,840 63 Library Service 64 12,203 12,203 12,203 64 Township Contributions 65 78,078 78,078 78,078 65 Fire/EMT Service 66 0 0 66 School District 67 630,870 630,870 630,870 67 Fire/PD Grants 68 14,172 14,172 14,172 68 69 0 0 69 Total Local Grants and Reimbursements 70 925,663 0 0 0 500 0 926,163 0 926,163 70 Total Intergovernmental (Sum of lines 33, 60, and 70)71 1,005,962 3,145,416 516,389 47,078 1,934,934 0 6,649,779 1,799,283 8,449,062 71 Section E -Charges for Fees and Service 72 72 Water 73 0 8,130,084 8,130,084 73 Sewer 74 0 8,999,757 8,999,757 74 Electric 75 0 0 75 Gas 76 0 11,380,169 11,380,169 76 Parking 77 0 0 77 Airport 78 0 0 78 Landfill/garbage 79 0 1,596,284 1,596,284 79 Hospital 80 0 0 80 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,394,238 1,394,238 87 Other:88 88 Nursing Home 89 0 0 89 Police Service Fees 90 58,344 58,344 58,344 90 Prisoner Care 91 0 0 91 Fire Service Charges 92 2,160 2,160 2,160 92 Ambulance Charges 93 711,567 711,567 711,567 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 241,851 241,851 241,851 100 Animal Control Charges 101 0 0 101 Copies/Mech Fees/Utility Billing/Golf Course 102 294,770 294,770 1,196,177 1,490,947 102 103 0 0 103 Total Charges for Service 104 1,308,692 0 0 0 0 0 1,308,692 32,696,709 34,005,401 104 Section F - Special Assesments 106 15,750 91,057 106,807 106,807 106 Section G - Miscellaneous 107 107 Contributions 108 52,068 500,000 2,317,000 2,869,068 2,514 2,871,582 108 Deposits and Sales/Fuel Tax Refunds 109 0 0 109 Sale of Property and Merchandise 110 78,604 51,174 129,778 192,931 322,709 110 Fines 111 4,515 4,515 4,515 111 Internal Service Charges 112 180 180 180 112 Damage Reimbursement / Misc 113 10,580 60,560 71,140 201,037 272,177 113 Patron Rebates 114 11,430 11,430 11,430 114 Fire Association 115 9,925 9,925 9,925 115 Wellness Reimbursement 116 79,441 79,441 79,441 116 117 0 0 117 118 0 0 118 119 0 0 119 Total Miscellaneous 120 236,818 621,659 0 0 2,317,000 0 3,175,477 396,482 3,571,959 120 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 15,611,704 11,411,442 8,853,419 5,312,047 5,509,711 0 46,698,323 35,137,246 81,835,569 121 Section H - Other Financing Sources 123 123 Proceeds of capital asset sales 124 166,835 166,835 166,835 124 Proceeds of long-term debt (Excluding TIF internal borrowing)125 21,715,261 21,715,261 21,715,261 125 Proceeds of anticipatory warrants or other short-term debt 126 0 0 126 Regular transfers in and interfund loans 127 2,630,000 0 1,558,799 800,000 4,988,799 558,500 5,547,299 127 Internal TIF loans and transfers in 128 504,570 9,778,913 10,283,483 10,283,483 128 129 0 0 129 130 0 0 130 Total Other Financing Sources 131 3,301,405 0 0 11,337,712 22,515,261 0 37,154,378 558,500 37,712,878 131 Total Revenues Except for Beginning Balances (Sum of lines 121 and 131)132 18,913,109 11,411,442 8,853,419 16,649,759 28,024,972 0 83,852,701 35,695,746 119,548,447 132 Beginning Fund Balance July 1, 2021 134 7,534,372 11,232,052 5,841,627 2,919,202 22,211,317 49,738,570 74,289,609 124,028,179 134 Total Revenues and Other Financing Sources (Sum of lines 132 and 134)136 26,447,481 22,643,494 14,695,046 19,568,961 50,236,289 0 133,591,271 109,985,355 243,576,626 136 EXPENDITURES P6 CITY OF WAUKEE EXPENDITURES AND OTHER FINANCING USES FOR FISCAL YEAR ENDED JUNE 30, 2022 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 4,372,113 4,372,113 4,372,113 2 Jail 3 0 0 3 Emergency Management 4 34,358 34,358 34,358 4 Flood control 5 0 0 5 Fire Department 6 1,080,117 11,632 1,091,749 1,091,749 6 Ambulance 7 2,386,532 2,386,532 2,386,532 7 Building Inspections 8 831,542 831,542 831,542 8 Miscellaneous Protective Services 9 0 0 9 Animal Control 10 7,983 7,983 7,983 10 Other Public Safety 11 0 0 0 11 Westcom Dispatch 12 623,941 623,941 623,941 12 13 0 0 13 Total Public Safety 14 9,336,586 11,632 0 0 0 9,348,218 9,348,218 14 Section B - Public Works 15 15 Roads, Bridges, Sidewalks 16 2,938,254 18,589,239 21,527,493 21,527,493 16 Parking Meter and Off-Street 17 0 0 17 Street Lighting 18 252,682 252,682 252,682 18 Traffic Control Safety 19 271,431 516,010 787,441 787,441 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 Bldg / Mechanic 26 333,337 1,011,468 1,344,805 1,344,805 26 Engineering / GIS 27 722,625 722,625 722,625 27 Total Public Works 28 1,055,962 3,462,367 0 20,116,717 0 24,635,046 24,635,046 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 35,000 35,000 35,000 36 37 0 0 37 38 0 0 38 Total Health and Social Services 39 35,000 0 0 0 0 35,000 35,000 39 Section D - Culture and Recreation 40 40 Library Services 41 1,183,565 1,183,565 1,183,565 41 Museum, Band, Theater 42 0 0 42 Parks 43 917,423 12,040,587 12,958,010 12,958,010 43 Recreation 44 1,098,274 1,098,274 1,098,274 44 Cemetery 45 0 0 45 Community Center, Zoo, Marina, and Auditorium 46 54,094 54,094 54,094 46 Other Culture and Recreation 47 36,674 36,674 36,674 47 48 0 0 48 49 0 0 49 Total Culture and Recreation 50 3,290,030 0 0 12,040,587 0 15,330,617 15,330,617 50 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 Economic Development 51 51 Community beautification 52 18,354 18,354 18,354 52 Economic development 53 208,680 52,152 260,832 260,832 53 Housing and urban renewal 54 0 0 54 Planning and zoning 55 380,692 380,692 380,692 55 Other community and economic development 56 0 0 56 TIF Rebates 57 1,376,485 1,376,485 1,376,485 57 58 0 0 58 Total Community and EconomicDevelopment 59 607,726 0 1,428,637 0 0 0 2,036,363 2,036,363 59 Section F - General Government 60 60 Mayor, Council and City Manager 61 1,732,723 1,732,723 1,732,723 61 Clerk, Treasurer, Financial Administration 62 164,218 164,218 164,218 62 Elections 63 0 0 63 Legal Services and City Attorney 64 107,510 107,510 107,510 64 City Hall and General Buildings 65 146,888 146,888 146,888 65 Tort Liability 66 0 0 66 Other General Government 67 0 0 67 Human Resources 68 158,597 158,597 158,597 68 Information Technology 69 310,500 310,500 310,500 69 Total General Government 70 2,620,436 0 0 0 0 2,620,436 2,620,436 70 Section G - Debt Service 71 14,797,659 14,797,659 14,797,659 71 72 0 0 72 73 0 0 73 Total Debt Service 74 0 0 0 14,797,659 0 0 14,797,659 14,797,659 74 Section H - Regular Capital Projects - Specify 75 75 Debt Issuance 76 20,143 20,143 20,143 76 77 0 0 77 Subtotal Regular Capital Projects 78 0 0 0 20,143 0 20,143 20,143 78 TIF Capital Projects - Specify 79 79 Debt Issuance 80 0 111,932 111,932 111,932 80 81 0 0 81 Subtotal TIF Capital Projects 82 0 0 0 111,932 0 111,932 111,932 82 Total Capital Projects 83 0 0 0 132,075 0 132,075 132,075 83 Total Governmental Activities Expenditures 84 16,945,740 3,473,999 1,428,637 14,797,659 32,289,379 0 68,935,414 68,935,414 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" 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 4,911,161 4,911,161 88 Capital Outlay 89 15,347 15,347 89 Debt Service 90 164,093 164,093 90 Sewer and Sewage Disposal - Current Operation 91 3,356,390 3,356,390 91 Capital Outlay 92 10,423 10,423 92 Debt Service 93 304,650 304,650 93 Electric - Current Operation 94 0 94 Capital Outlay 95 0 95 Debt Service 96 0 96 Gas Utility - Current Operation 97 8,335,879 8,335,879 97 Capital Outlay 98 15,780 15,780 98 Debt Service 99 0 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 1,636,665 1,636,665 106 Capital Outlay 107 0 107 Debt Service 108 0 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 851,488 851,488 120 Capital Outlay 121 26,176 26,176 121 Debt Service 122 5,282 5,282 122 Other Business Type - Current Operation 123 602,172 602,172 123 Capital Outlay 124 0 124 Debt Service 125 1,910 1,910 125 Internal Service Funds - Specify 126 126 Utility Billing / Equipment Revolving 127 410,179 410,179 127 128 0 128 Total Business Type Activities 129 20,647,595 20,647,595 129 EXPENDITURES P9 CITY OF WAUKEE EXPENDITURES AND OTHER FINANCING USES FOR FISCAL YEAR ENDED JUNE 30, 2022 -- 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 16,945,740 3,473,999 1,428,637 14,797,659 32,289,379 0 68,935,414 20,647,595 89,583,009 130 Section J - Other Financing Uses Including TransfersOut 131 131 Regular transfers out 132 3,500 3,747,969 730,941 4,482,410 1,064,889 5,547,299 132 Internal TIF loans/repayments and transfers out 133 10,283,483 10,283,483 10,283,483 133 134 0 0 134 Total Other Financing Uses 135 3,500 3,747,969 10,283,483 0 730,941 0 14,765,893 1,064,889 15,830,782 135 Total Expenditures and Other Financing Uses (Sum of lines 130 and 135)136 16,949,240 7,221,968 11,712,120 14,797,659 33,020,320 0 83,701,307 21,712,484 105,413,791 136 137 137 Ending fund balance June 30, :138 138 Governmental:139 139 Nonspendable 140 0 0 140 Restricted 141 0 0 141 Committed 142 0 0 142 Assigned 143 0 0 143 Unassigned 144 0 0 144 Total Governmental 145 0 0 0 0 0 0 0 0 145 Proprietary 146 88,272,871 88,272,871 146 Total Ending Fund Balance June 30,147 9,498,241 15,421,526 2,982,926 4,771,302 17,215,969 0 49,889,964 88,272,871 138,162,835 147 Total Requirements (Sum of lines 136 and 147)148 26,447,481 22,643,494 14,695,046 19,568,961 50,236,289 0 133,591,271 109,985,355 243,576,626 148 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 727,405 Transit Subsidies Libraries Police protection 624,181 Sewerage 1,491,149 Sanitation 22,461 All other 2,653,123 Purpose Amount paid to State Highways All other 3,935,462 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 andoperated 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 11,708,864 Part V Debt Outstanding, Issued, and Retired Transit subsidies A. Long-Term Debt Debt During the Fiscal Year Debt Outstanding JUNE 30, 2022 Purpose Line Debt Outstanding JULY 1, 2021 Issued Retired General Obligation TIF Revenue Revenue Other Interest Paid This Year Water Utility 1.5,725,000 330,000 5,395,000 198,187 Sewer Utility 2.17,474,508 899,000 16,575,508 332,249 Electric Utility 3. Gas Utility 4. Transit-Bus 5. Industrial Revenue 6. Mortgage Revenue 7. TIF Revenue 8. Other Purposes / Miscellaneous 9. GO 10.75,697,459 37,065,000 11,222,422 101,540,037 3,594,068 Parking 11. Airport 12. Stormwater 13.335,000 65,000 270,000 5,711 Section 108 14. Total Long-Term 99,231,967 37,065,000 12,516,422 101,540,037 0 22,240,508 0 4,130,215 B. Short-Term Debt Amount Outstanding as of July 1, 2021 58,855 Outstanding as of JUNE 30, 2022 45,220 Part VI DEBT LIMITATION FOR GENERAL OBLIGATIONS Actual valuation -- January 1, 2020 Amount 2,547,599,476 x.0.5 = $127,379,973.8 Part VII CASH AND INVESTMENT ASSETS AS OF JUNE 30, 2022 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 all other securities. Exclude value of realproperty. Amount Bond and interest funds (a) Bond construction funds (b) Pension/retirement funds (c) All other Funds (d)Total (e) 7,055,415.8 23,387,475.21 0 60,240,549.96 90,683,440.97 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. Notes & Remarks REMARKS -