HomeMy WebLinkAbout2021-11-29-D01C_01 FY2021 Annual Financial ReportAGENDA ITEM:
CITY OF WAUKEE, IOWA
CITY COUNCIL MEETING COMMUNICATION
MEETING DATE: November 29th, 2021
AGENDA ITEM:Consideration of approval of a resolution approving State of Iowa 2021
Financial Report
FORMAT:Consent Agenda
SYNOPSIS INCLUDING PRO & CON: The Office of the Auditor of State recommends that
the FY2021 Financial Report be presented for Council approval,
although not required. The report is required to be published, which will
be published in the Des Moines Register on November 25th. Proof of
publication, will be forwarded to the Auditor’s office to meet the
December 1st requirement.
FISCAL IMPACT INCLUDING COST/BENEFIT ANALYSIS:
COMMISSION/BOARD/COMMITTEE COMMENT:
STAFF REVIEW AND COMMENT:
RECOMMENDATION: Approve the State of Iowa 2021 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: Des Moines Register
DATE OF PUBLICATION: November 25th, 2021
D1C1
THE CITY OF WAUKEE, IOWA
RESOLUTION 2021-
RESOLUTION OF THE CITY OF WAUKEE’S STATE OF IOWA 2021
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 2021 Financial Report for the City of Waukee, Iowa; AND
WHEREAS, the report shows total Revenues in the amount of $110,007,860 and total
Expenditures of $93,031,210 with an Ending Fund Balance of $124,028,179; 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 Thursday,
November 25th, 2021;
NOW, THEREFORE, BE IT RESOLVED that the City of Waukee hereby approves
the State of Iowa 2021 Financial Report and directs the Finance Director to submit it to
the Auditor of State, this 29th day of November 2021.
____________________________
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
2021 FINANCIAL REPORT
FISCAL YEAR ENDED
JUNE 30, 2021
CITY OF WAUKEE, IOWA DUE: December 1, 2021
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 16,418,751 16,418,751 16,295,102
Less: Uncollected Property Taxes-Levy Year 0 0 0
Net Current Property Taxes 16,418,751 16,418,751 16,295,102
Delinquent Property Taxes 0 0 0
TIF Revenues 6,715,401 6,715,401 6,765,615
Other City Taxes 3,644,822 0 3,644,822 3,419,996
Licenses and Permits 2,161,872 0 2,161,872 2,197,280
Use of Money and Property 299,771 157,699 457,470 391,650
Intergovernmental 4,422,105 1,029,887 5,451,992 5,584,944
Charges for Fees and Service 1,130,280 30,655,492 31,785,772 30,264,996
Special Assessments 33,852 0 33,852 0
Miscellaneous 2,463,044 172,062 2,635,106 2,445,568
Other Financing Sources 40,367,985 334,837 40,702,822 22,233,700
Transfers In 10,855,944 334,837 11,190,781 10,785,011
Total Revenues and Other Sources 77,657,883 32,349,977 110,007,860 100,383,862
Expenditures and Other Financing Uses
Public Safety 7,954,215 7,954,215 8,272,700
Public Works 20,829,969 20,829,969 4,058,197
Health and Social Services 79,000 79,000 71,000
Culture and Recreation 13,886,572 13,886,572 2,678,825
Community and Economic Development 845,082 845,082 966,770
General Government 5,160,771 5,160,771 4,643,904
Debt Service 12,055,597 12,055,597 12,082,232
Capital Projects 293,109 293,109 31,035,000
Total Governmental Activities Expenditures 61,104,315 0 61,104,315 63,808,628
BUSINESS TYPE ACTIVITIES 20,736,114 20,736,114 35,410,041
Total All Expenditures 61,104,315 20,736,114 81,840,429 99,218,669
Other Financing Uses 10,577,039 613,742 11,190,781
Transfers Out 10,577,039 613,742 11,190,781 10,785,011
Total All Expenditures/and Other Financing Uses 71,681,354 21,349,856 93,031,210 110,003,680
Excess Revenues and Other Sources Over (Under) Expenditures/and Other Financing Uses 5,976,529 11,000,121 16,976,650 -9,619,818
Beginning Fund Balance July 1, 2020 43,762,041 63,289,488 107,051,529 80,822,274
Ending Fund Balance June 30, 2021 49,738,570 74,289,609 124,028,179 71,202,456
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, 2021 Amount Indebtedness at June 30, 2021 Amount
General Obligation Debt 75,697,459 Other Long-Term Debt 0
Revenue Debt 25,774,625 Short-Term Debt 58,855
TIF Revenue Debt 0
General Obligation Debt Limit 118,834,827
CERTIFICATION
The forgoing report is correct to the best of my knowledge and belief
Signature of Preparer
Publication
11/25/2021
Printed name of Preparer
Linda Burkhart, Finance Director
Phone Number
(515) 978-7919
Signature of Mayor or other City official (Name and Title)
Date Signed
11/19/2021
PLEASE PUBLISH THIS PAGE ONLY
Rebecca Schuett, City Clerk
REVENUE P2CITY OF WAUKEEREVENUE AND OTHER FINANCING SOURCES FOR YEAR ENDED JUNE 30, 2021GAAP / ModifiedItem DescriptionGeneral (a)SpecialRevenue (b)TIF SpecialRevenue (c)DebtService (d)CapitalProjects (e)Permanent (f)Total Governmental (Sum of (a)through (f)) (g)Proprietary (h)Grand Total (Sum of (g)and (h)) (i)Section A - Taxes11Taxes levied on property29,243,9992,428,8054,745,94716,418,75116,418,7512Less: Uncollected Property Taxes - Levy Year3003Net Current Property Taxes49,243,9992,428,8054,745,9470016,418,75116,418,7514Delinquent Property Taxes5005Total Property Tax69,243,9992,428,8054,745,9470016,418,75116,418,7516TIF Revenues76,715,4016,715,4016,715,4017Other City TaxesUtility Tax Replacement Excise Taxes8008Utility Franchise Tax (Chapter 364.2, Code ofIowa)9009Parimutuel Wager Tax100010Gaming Wager Tax110011Mobile Home Tax1214,2803,7606,00124,04124,04112Hotel / Motel Tax1332,35832,35832,35813Other Local Option Taxes143,588,4233,588,4233,588,42314Total Other City Taxes1546,6383,592,1836,001003,644,82203,644,82215Section B - Licenses and Permits162,113,215-13,45662,1132,161,8722,161,87216Section C - Use of Money and Property1717Interest1821,08424,69715,13419,68759,716140,31882,739223,05718Rents and Royalties19159,453159,45374,960234,41319Other Miscellaneous Use of Money and Property200020210021Total Use of Money and Property22180,53724,69715,13419,68759,7160299,771157,699457,47022Section D - Intergovernmental2424Federal Grants and Reimbursements2626Federal Grants27582,21332,94457,000672,15719,487691,64427Community Development Block Grants280028Housing and Urban Development290029Public Assistance Grants300030Payment in Lieu of Taxes310031320032Total Federal Grants and Reimbursements33582,21332,944057,0000672,15719,487691,64433
REVENUE P3CITY OF WAUKEEREVENUE AND OTHER FINANCING SOURCES FOR YEAR ENDED JUNE 30, 2021GAAP / ModifiedItem DescriptionGeneral (a)SpecialRevenue (b)TIF SpecialRevenue (c)DebtService (d)CapitalProjects (e)Permanent (f)Total Governmental (Sum of (a)through (f)) (g)Proprietary (h)Grand Total (Sum of (g)and (h)) (i)Section D - Intergovernmental - Continued4141State Shared Revenues4343Road Use Taxes442,664,6922,664,6922,664,69244Other state grants and reimbursements4848State grants4936,33536,3351,010,4001,046,73549Iowa Department of Transportation500050Iowa Department of Natural Resources510051Iowa Economic Development Authority520052CEBA grants530053Commercial & Industrial Replacement Claim5470,93318,629412,32783,110584,999584,99954550055560056570057580058590059Total State60107,2682,683,321412,32783,110003,286,0261,010,4004,296,42660Local Grants and ReimbursementsCounty Contributions6313,47813,47813,47863Library Service6475,42275,42275,42264Township Contributions650065Fire/EMT Service660066School District67315,02260,000375,022375,02267680068690069Total Local Grants and Reimbursements70403,92200060,0000463,9220463,92270Total Intergovernmental (Sum of lines 33, 60,and 70)711,093,4032,716,265412,32783,110117,00004,422,1051,029,8875,451,99271Section E -Charges for Fees and Service7272Water7307,824,6077,824,60773Sewer7408,068,2358,068,23574Electric750075Gas76010,758,15610,758,15676Parking770077Airport780078Landfill/garbage7901,499,5471,499,54779Hospital800080
REVENUE P4CITY OFREVENUE AND OTHER FINANCING SOURCES FOR YEAR ENDED JUNE 30,GAAP / ModifiedItem DescriptionGeneral (a)SpecialRevenue (b)TIF SpecialRevenue (c)DebtService (d)CapitalProjects (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 -Continued8181Transit820082Cable TV830083Internet840084Telephone850085Housing Authority860086Storm Water8701,335,6751,335,67587Other:8888Nursing Home890089Police Service Fees9025,55825,55825,55890Prisoner Care910091Fire Service Charges923,0503,0503,05092Ambulance Charges93624,452624,452624,45293Sidewalk Street Repair Charges940094Housing and Urban Renewal Charges950095River Port and Terminal Fees960096Public Scales970097Cemetery Charges980098Library Charges990099Park, Recreation, and Cultural Charges100186,075186,075186,075100Animal Control Charges1010010110200102Copies/Mech Fees/Utility Billing/Golf Course103291,145291,1451,169,2721,460,417103Total Charges for Service1041,130,280000001,130,28030,655,49231,785,772104Section F - Special Assesments10629,9413,91133,85233,852106Section G - Miscellaneous107107Contributions10831,3572,000,000296,7632,328,1202,5722,330,692108Deposits and Sales/Fuel Tax Refunds10900109Sale of Property and Merchandise11031,81941,77073,589127,983201,572110Fines11116,84516,84516,845111Internal Service Charges11213513513511211300113Damage Reimbursement / Misc11410,84117,19928,04026,84654,886114Patron Rebates11511,7861,30913,09514,66127,756115Fire Association1163,2203,2203,220116117001171180011811900119Total Miscellaneous120102,7832,063,49800296,76302,463,044172,0622,635,106120
REVENUE P5CITY OFREVENUE AND OTHER FINANCING SOURCES FOR YEAR ENDED JUNE 30,GAAP / ModifiedItem DescriptionGeneral (a)SpecialRevenue (b)TIF SpecialRevenue (c)DebtService (d)CapitalProjects (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)12113,910,85510,811,9927,142,8624,884,686539,503037,289,89832,015,14069,305,038121Section H - Other Financing Sources123123Proceeds of capital asset sales124168,838168,838168,838124Proceeds of long-term debt (Excluding TIF internalborrowing)1252,453,19826,890,00529,343,20329,343,203125Proceeds of anticipatory warrants or other short-termdebt12600126Regular transfers in and interfund loans1272,475,0001,310,2952,000,0005,785,295334,8376,120,132127Internal TIF loans and transfers in1285,070,6495,070,6495,070,6491281290012913000130Total Other Financing Sources1312,643,838008,834,14228,890,005040,367,985334,83740,702,822131Total Revenues Except for Beginning Balances(Sum of lines 121 and 131)13216,554,69310,811,9927,142,86213,718,82829,429,508077,657,88332,349,977110,007,860132Beginning Fund Balance July 1, 20201348,350,3398,301,2633,969,3671,255,97121,885,10143,762,04163,289,488107,051,529134Total Revenues and Other Financing Sources (Sum of lines 132 and 134)13624,905,03219,113,25511,112,22914,974,79951,314,6090121,419,92495,639,465217,059,389136
EXPENDITURES P6CITY OF WAUKEEEXPENDITURES AND OTHER FINANCING USES FOR FISCAL YEAR ENDED JUNE 30, 2021GAAP / ModifiedItem DescriptionLineGeneral (a)SpecialRevenue (b)TIF SpecialRevenue (c)DebtService (d)CapitalProjects (e)Permanent(f)Total Governmental (Sum of cols. (a)through (f)) (g)Proprietary(h)Grand Total (Sum of col. (g)) (i)LineSection A - Public Safety11Police Department/Crime Prevention23,853,3903,853,3903,853,3902Jail3003Emergency Management460,53260,53260,5324Flood control5005Fire Department6942,2278,449950,676950,6766Ambulance71,938,4321,938,4321,938,4327Building Inspections8573,812573,812573,8128Miscellaneous Protective Services9009Animal Control1013,30013,30013,30010Other Public Safety110011Westcom Dispatch12564,073564,073564,07312130013Total Public Safety147,945,7668,4490007,954,2157,954,21514Section B - Public Works1515Roads, Bridges, Sidewalks161,871,10917,147,60919,018,71819,018,71816Parking Meter and Off-Street170017Street Lighting18315,912315,912315,91218Traffic Control Safety19190,788208,458399,246399,24619Snow Removal200020Highway Engineering210021Street Cleaning220022Airport (if not an enterprise)230023Garbage (if not an enterprise)240024Other Public Works2567,34167,34167,34125Public Works / PW Bldg / Mechanic26371,956371,956371,95626Engineering / GIS27656,796656,796656,79627Total Public Works281,028,7522,377,809017,423,408020,829,96920,829,96928Section C - Health and Social Services2929Welfare Assistance300030City Hospital310031Payments to Private Hospitals320032Health Regulation and Inspections330033Water, Air, and Mosquito Control340034Community Mental Health350035Other Health and Social Services3679,00079,00079,00036370037380038Total Health and Social Services3979,000000079,00079,00039Section D - Culture and Recreation4040Library Services411,027,8321,027,8321,027,83241Museum, Band, Theater420042Parks43631,52611,386,77512,018,30112,018,30143Recreation44808,938808,938808,93844Cemetery450045Community Center, Zoo, Marina, and Auditorium4619,61819,61819,61846Other Culture and Recreation4711,88311,88311,88347480048490049Total Culture and Recreation502,499,7970011,386,775013,886,57213,886,57250
EXPENDITURES P7CITY OFEXPENDITURES AND OTHER FINANCING USES FOR FISCAL YEAR ENDED JUNE 30, -- ContinuedGAAP / ModifiedItem descriptionLineGeneral (a)Special Revenue (b)TIF Special Revenue (c)DebtService (d)CapitalProjects (e)Permanent (f)Total Governmental (Sum of cols. (a) through (f)) (g)Proprietary(h)Grand Total (Sumof col. (g)) (i)LineSection E - Community and EconomicDevelopment5151Community beautification5242,01142,01142,01152Economic development53161,11465,263226,377226,37753Housing and urban renewal540054Planning and zoning55442,004442,004442,00455Other community and economic development560056TIF Rebates57134,690134,690134,69057580058Total Community and EconomicDevelopment59645,1290199,953000845,082845,08259Section F - General Government6060Mayor, Council and City Manager614,216,3764,216,3764,216,37661Clerk, Treasurer, Financial Administration62123,018123,018123,01862Elections630063Legal Services and City Attorney6493,47793,47793,47764City Hall and General Buildings65211,563211,563211,56365Tort Liability660066Other General Government670067Human Resources68131,939131,939131,93968Information Technology69384,398384,398384,39869Total General Government705,160,77100005,160,7715,160,77170Section G - Debt Service7112,055,59712,055,59712,055,59771720072730073Total Debt Service7400012,055,5970012,055,59712,055,59774Section H - Regular Capital Projects - Specify7575Debt Issuance76293,109293,109293,10976770077Subtotal Regular Capital Projects78000293,1090293,109293,10978TIF Capital Projects - Specify7979800080810081Subtotal TIF Capital Projects82000000082Total Capital Projects83000293,1090293,109293,10983 Total Governmental Activities Expenditures8417,359,2152,386,258199,95312,055,59729,103,292061,104,31561,104,31584(Sum of lines 14, 28, 39, 50, 59, 70, 74, 83)8585TIF Rebates are expended out of the TIF Special Revenue Fund within the Community and Economic Development program's activity "Other"
EXPENDITURES P8CITY OFEXPENDITURES AND OTHER FINANCING USES FOR FISCAL YEAR ENDED JUNE 30, -- ContinuedGAAP / ModifiedItem descriptionLineGeneral(a)SpecialRevenue (b)TIF SpecialRevenue (c)DebtService (d)CapitalProjects (e)Permanent(f)Total Governmental (Sum of cols.(a) through (f)) (g)Proprietary(h)Grand Total (Sumof col. (g)) (i)LineSection I - Business Type Activities8787Water - Current Operation884,731,7574,731,75788Capital Outlay8937,78137,78189Debt Service90144,778144,77890Sewer and Sewage Disposal - Current Operation913,184,5103,184,51091Capital Outlay9235,71935,71992Debt Service93302,246302,24693Electric - Current Operation94094Capital Outlay95095Debt Service96096Gas Utility - Current Operation979,058,7699,058,76997Capital Outlay9819,77019,77098Debt Service990099Parking - Current Operation1000100Capital Outlay1010101Debt Service1020102Airport - Current Operation1030103Capital Outlay1040104Debt Service1050105Landfill/Garbage - Current operation1061,464,0811,464,081106Capital Outlay1070107Debt Service1080108Hospital - Current Operation1090109Capital Outlay1100110Debt Service1110111Transit - Current Operation1120112Capital Outlay1130113Debt Service1140114Cable TV, Telephone, Internet - Current Operation1150115Capital Outlay1160116Housing Authority - Current Operation1170117Capital Outlay1180118Debt Service1190119Storm Water - Current Operation120732,182732,182120Capital Outlay12110,45310,453121Debt Service1225,9395,939122Other Business Type - Current Operation123564,368564,368123Capital Outlay1240124Debt Service1257,1997,199125Internal Service Funds - Specify126126Utility Billing/Equipment Revolving127436,562436,5621271280128Total Business Type Activities12920,736,11420,736,114129
EXPENDITURES P9CITY OF WAUKEEEXPENDITURES AND OTHER FINANCING USES FOR FISCAL YEAR ENDED JUNE 30, 2021 -- ContinuedGAAP / ModifiedItem descriptionLineGeneral (a)Special Revenue (b)TIF Special Revenue (c)DebtService (d)CapitalProjects (e)Permanent (f)Total Governmental (Sum ofcols. (a) through (f)) (g)Proprietary (h)Grand Total (Sumof col. (g)) (i)LineSubtotal Expenditures (Sum of lines 84 and129)13017,359,2152,386,258199,95312,055,59729,103,292061,104,31520,736,11481,840,429130Section J - Other Financing Uses Including TransfersOut131131Regular transfers out13211,4455,494,9455,506,390613,7426,120,132132Internal TIF loans/repayments and transfers out1335,070,6495,070,6495,070,64913313400134Total Other Financing Uses13511,4455,494,9455,070,64900010,577,039613,74211,190,781135Total Expenditures and Other Financing Uses (Sum of lines 130 and 135)13617,370,6607,881,2035,270,60212,055,59729,103,292071,681,35421,349,85693,031,210136 137137Ending fund balance June 30, :138138Governmental:139139Nonspendable140187,642187,642187,642140Restricted1415,841,6272,919,20222,211,31730,972,14630,972,146141Committed142777,374777,374777,374142Assigned143481,15311,044,41011,525,56311,525,563143Unassigned1446,275,8456,275,8456,275,845144Total Governmental1457,534,37211,232,0525,841,6272,919,20222,211,317049,738,57049,738,570145Proprietary14674,289,60974,289,609146Total Ending Fund Balance June 30,1477,534,37211,232,0525,841,6272,919,20222,211,317049,738,57074,289,609124,028,179147Total Requirements (Sum of lines 136 and 147)14824,905,03219,113,25511,112,22914,974,79951,314,6090121,419,92495,639,465217,059,389148
OTHER P10Part 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.PurposeAmount paid to other local governmentsCorrectionHealth4,748Highways237,712Transit SubsidiesLibraries1,479Police protection599,117Sewerage4,215,336Sanitation22,486All other2,513,064PurposeAmount paid to StateHighwaysAll other3,592,313Part IVWages & 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 PAIDAmountTotal Salaries and Wages Paid10,221,577Part V Debt Outstanding, Issued, and RetiredTransit subsidiesA. Long-Term DebtDebt During the Fiscal YearDebt Outstanding JUNE 30, 2021PurposeLineDebt Outstanding JULY 1, 2020IssuedRetiredGeneral ObligationTIF RevenueRevenueOtherInterest Paid This YearWater Utility1.6,040,000315,0005,725,000210,638Sewer Utility2.21,511,0001,796,37519,714,625360,008Electric Utility3.Gas Utility4.Transit-Bus5.Industrial Revenue6.Mortgage Revenue7.TIF Revenue8.175,000175,0006,825Other Purposes / Miscellaneous9.322,692322,6924,767GO10.75,874,3589,155,0009,331,89975,697,4592,558,905Parking11.Airport12.Stormwater13.400,00065,000335,0006,020Section 10814.Total Long-Term104,323,0509,155,00012,005,96675,697,459025,774,62503,147,163B. Short-Term Debt AmountOutstanding as of July 1, 202016,658Outstanding as of JUNE 30, 202158,855Part VI DEBT LIMITATION FOR GENERAL OBLIGATIONSActual valuation -- January 1, 2019Amount2,376,696,557x.0.5 = $118,834,827.85Part VII CASH AND INVESTMENT ASSETS AS OF JUNE 30, 2021Type of assetCash 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.AmountBond and interestfunds (a)Bond construction funds (b)Pension/retirement funds(c)All other Funds(d)Total (e)5,193,17131,028,72950,615,32886,837,228If you budget on a NON-GAAP CASH BASIS, the amount in the Total above SHOULD EQUAL the abovesummed amounts on the sheet All Funds P1: Ending fund balance, column C PLUS the amounts in the shaded Notearea.