HomeMy WebLinkAbout2020-11-02-J01E 2020 State Financial ReportJ1E
STATE OF IOWA
2020
FINANCIAL REPORT
FISCAL YEAR ENDED
JUNE 30, 2020
CITY OF WAUKEE, IOWA
DUE: December 1, 2020
16202501300000
CITY OF WAUKEE
230 W Hickman Road
WAUKEE IA 50263
POPULATION: 13790
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 15,127,777 15,127,777 15,115,776
Less: Uncollected Property Taxes-Levy Year 0 0 0
Net Current Property Taxes 15,127,777 15,127,777 15,115,776
Delinquent Property Taxes 0 0 0
TIF Revenues 5,198,895 5,198,895 5,263,083
Other City Taxes 3,221,529 0 3,221,529 2,462,405
Licenses and Permits 2,275,860 0 2,275,860 1,713,280
Use of Money and Property 645,934 468,662 1,114,596 762,680
Intergovernmental 4,085,766 0 4,085,766 3,944,500
Charges for Fees and Service 940,892 24,359,221 25,300,113 24,417,860
Special Assessments 188,956 0 188,956 12,750
Miscellaneous 1,705,239 269,119 1,974,358 1,439,050
Other Financing Sources 26,883,034 16,500 26,899,534 18,567,800
Transfers In 8,587,149 16,500 8,603,649 13,851,703
Total Revenues and Other Sources 60,273,882 25,113,502 85,387,384 87,550,887
Expenditures and Other Financing Uses
Public Safety 7,346,345 7,346,345 7,789,985
Public Works 12,918,600 12,918,600 3,098,940
Health and Social Services 0 0 2,000
Culture and Recreation 4,066,240 4,066,240 2,535,919
Community and Economic Development 863,111 863,111 905,470
General Government 2,559,307 2,559,307 2,575,476
Debt Service 9,332,098 9,332,098 9,333,055
Capital Projects 260,692 260,692 26,670,000
Total Governmental Activities Expenditures 37,346,393 0 37,346,393 52,910,845
BUSINESS TYPE ACTIVITIES 16,628,501 16,628,501 23,588,144
Total All Expenditures 37,346,393 16,628,501 53,974,894 76,498,989
Other Financing Uses 7,985,646 618,003 8,603,649 0
Transfers Out 7,985,646 618,003 8,603,649 13,851,703
Total All Expenditures/and Other Financing Uses 45,332,039 17,246,504 62,578,543 90,350,692
Excess Revenues and Other Sources Over (Under) Expenditures/and Other Financing Uses 14,941,843 7,866,998 22,808,841 -2,799,805
Beginning Fund Balance July 1, 2019 28,820,198 55,422,490 84,242,688 65,955,806
Ending Fund Balance June 30, 2020 43,762,041 63,289,488 107,051,529 63,156,001
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, 2020 Amount Indebtedness at June 30, 2020 Amount
General Obligation Debt 75,874,358 Other Long-Term Debt 0
Revenue Debt 27,828,692 Short-Term Debt 25,030
TIF Revenue Debt 175,000
General Obligation Debt Limit 104,866,528
CERTIFICATION
The forgoing report is correct to the best of my knowledge and belief
Signature of Preparer
Publication
11/5/2020
Printed name of Preparer Phone Number
Signature of Mayor or other City official (Name and Title)
Date Signed
PLEASE PUBLISH THIS PAGE ONLY
Linda Burkhart, Finance Director
10/28/2020Rebecca Schuett, City Clerk
REVENUE P2CITY OF WAUKEEREVENUE AND OTHER FINANCING SOURCES FOR YEAR ENDED JUNE 30, 2020GAAPItem 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 property28,640,5622,242,6234,244,59215,127,77715,127,7772Less: Uncollected Property Taxes -Levy Year3003Net Current Property Taxes48,640,5622,242,6234,244,5920015,127,77715,127,7774Delinquent Property Taxes5005Total Property Tax68,640,5622,242,6234,244,5920015,127,77715,127,7776TIF Revenues75,198,8955,198,8955,198,8957Other City TaxesUtility Tax Replacement ExciseTaxes8008Utility Franchise Tax (Chapter364.2, Code of Iowa)9009Parimutuel Wager Tax100010Gaming Wager Tax110011Mobile Home Tax1212,2093,1745,06720,45020,45012Hotel / Motel Tax139,4129,4129,41213Other Local Option Taxes143,191,6673,191,6673,191,66714Total Other City Taxes1521,6213,194,8415,067003,221,52903,221,52915Section B - Licenses and Permits161,917,25569,969288,6362,275,8602,275,86016Section C - Use of Money andProperty1717Interest1883,49368,96264,83119,909289,663526,858395,623922,48118Rents and Royalties19119,076119,07673,039192,11519Other Miscellaneous Use ofMoney and Property200020210021Total Use of Money andProperty22202,56968,96264,83119,909289,6630645,934468,6621,114,59622Section D - Intergovernmental2424Federal Grants and Reimbursements2626Federal Grants2794,693953,2291,047,9221,047,92227Community Development BlockGrants280028Housing and Urban Development290029Public Assistance Grants300030Payment in Lieu of Taxes310031320032Total Federal Grants andReimbursements3394,69300953,22901,047,92201,047,92233
REVENUE P3CITY OF WAUKEEREVENUE AND OTHER FINANCING SOURCES FOR YEAR ENDED JUNE 30, 2020GAAPItem 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,423,0872,423,0872,423,08744Other state grants and reimbursements4848State grants4955,66755,66755,66749Iowa Department of Transportation500050Iowa Department of NaturalResources510051Iowa Economic DevelopmentAuthority520052CEBA grants530053Commercial & IndustrialReplacement Claim54148,25438,54668,65470,313325,767325,76754550055560056570057580058590059Total State60203,9212,461,63368,65470,313002,804,52102,804,52160Local Grants and ReimbursementsCounty Contributions630063Library Service649,8439,8439,84364Township Contributions6568,91968,91968,91965Fire/EMT Service660066Other Cities676,8506,8506,85067Schools68147,711147,711147,71168690069Total Local Grants andReimbursements70233,32300000233,3230233,32370Total Intergovernmental (Sum oflines 33, 60, and 70)71531,9372,461,63368,65470,313953,22904,085,76604,085,76671Section E -Charges for Fees and Service7272Water7306,212,1006,212,10073Sewer7407,009,2647,009,26474Electric750075Gas7607,797,0317,797,03176Parking770077Airport780078Landfill/garbage7901,384,7181,384,71879Hospital800080
REVENUE P4CITY OFREVENUE AND OTHER FINANCING SOURCES FOR YEAR ENDED JUNE 30,GAAPItem 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 andService - Continued8181Transit820082Cable TV830083Internet840084Telephone850085Housing Authority860086Storm Water8701,093,6711,093,67187Other:8888Nursing Home890089Police Service Fees9025,2101,52526,73526,73590Prisoner Care910091Fire Service Charges924,4614,4614,46192Ambulance Charges93494,181494,181494,18193Sidewalk Street Repair Charges940094Housing and Urban RenewalCharges950095River Port and Terminal Fees960096Public Scales970097Cemetery Charges980098Library Charges990099Park, Recreation, and CulturalCharges100106,327106,327106,327100Animal Control Charges1010010110200102Copies/Mechanic Fees/UtilityBilling/Golf Course103309,188309,188862,4371,171,625103Total Charges for Service104939,3671,5250000940,89224,359,22125,300,113104Section F - Special Assesments10613,476175,480188,956188,956106Section G - Miscellaneous107107Contributions10829,7331,500,0001,529,7331,4501,531,183108Deposits and Sales/Fuel TaxRefunds10900109Sale of Property and Merchandise11024,20544,37968,584224,464293,048110Fines11133,27333,27333,273111Internal Service Charges11213513513511211300113Damage Reimbursement11412,7315,70618,43711,53229,969114Patron Rebates11533,4135,64039,05331,67370,726115Fire Association11616,02416,02416,024116117001171180011811900119Total Miscellaneous120133,4901,571,74900001,705,239269,1191,974,358120
REVENUE P5CITY OFREVENUE AND OTHER FINANCING SOURCES FOR YEAR ENDED JUNE 30,GAAPItem DescriptionGeneral (a)SpecialRevenue (b)TIF SpecialRevenue (c)DebtService (d)CapitalProjects (e)Permanent (f)Total Governmental (Sumof (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)12112,386,8019,611,3025,332,3804,353,3571,707,008033,390,84825,097,00258,487,850121Section H - Other Financing Sources123123Proceeds of capital asset sales124304,389304,389304,389124Proceeds of long-term debt (Excluding TIFinternal borrowing)12517,991,49617,991,49617,991,496125Proceeds of anticipatory warrants or other short-term debt12600126Regular transfers in and interfund loans1272,325,0001,141,3733,466,37316,5003,482,873127Internal TIF loans and transfers in128230,2274,890,5495,120,7765,120,7761281290012913000130Total Other Financing Sources1312,859,616006,031,92217,991,496026,883,03416,50026,899,534131Total Revenues Except for BeginningBalances (Sum of lines 121 and 131)13215,246,4179,611,3025,332,38010,385,27919,698,504060,273,88225,113,50285,387,384132Beginning Fund Balance July 1, 20191347,043,3133,639,1823,900,357202,79014,034,55628,820,19855,422,49084,242,688134Total Revenues and Other FinancingSources (Sum of lines 132 and 134)13622,289,73013,250,4849,232,73710,588,06933,733,060089,094,08080,535,992169,630,072136
EXPENDITURES P6CITY OF WAUKEEEXPENDITURES AND OTHER FINANCING USES FOR FISCAL YEAR ENDED JUNE 30, 2020GAAPItem 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/CrimePrevention23,619,5783,619,5783,619,5782Jail3003Emergency Management419,13319,13319,1334Flood control5005Fire Department61,334,90814,1091,349,0171,349,0176Ambulance71,234,5001,234,5001,234,5007Building Inspections8523,499523,499523,4998Miscellaneous Protective Services9009Animal Control1013,23913,23913,23910Other Public Safety110011Dispatch Services12587,379587,379587,37912130013Total Public Safety147,332,23614,1090007,346,3457,346,34514Section B — Public Works1515Roads, Bridges, Sidewalks161,824,7979,898,66211,723,45911,723,45916Parking Meter and Off-Street170017Street Lighting18216,245216,245216,24518Traffic Control Safety1945,70045,70045,70019Snow Removal200020Highway Engineering210021Street Cleaning220022Airport (if not an enterprise)230023Garbage (if not an enterprise)240024Other Public Works250025Public Works/Building/Mechanic26325,526325,526325,52626Engineering/GIS27607,670607,670607,67027Total Public Works28933,1962,086,74209,898,662012,918,60012,918,60028Section C — Health and SocialServices2929Welfare Assistance300030City Hospital310031Payments to Private Hospitals320032Health Regulation and Inspections330033Water, Air, and Mosquito Control340034Community Mental Health350035Other Health and Social Services360036370037380038Total Health and SocialServices39000000039Section D — Culture andRecreation4040Library Services411,089,5811,089,5811,089,58141Museum, Band, Theater420042Parks43557,6511,688,6052,246,2562,246,25643Recreation44687,103687,103687,10344Cemetery450045Community Center, Zoo, Marina,and Auditorium4643,30043,30043,30046Other Culture and Recreation470047480048490049Total Culture andRecreation502,377,635001,688,60504,066,2404,066,24050
EXPENDITURES P7CITY OFEXPENDITURES AND OTHER FINANCING USES FOR FISCAL YEAR ENDED JUNE 30, -- ContinuedGAAPItem 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 andEconomic Development5151Community beautification5232,17932,17932,17952Economic development53243,763132,594376,357376,35753Housing and urban renewal540054Planning and zoning55444,575444,575444,57555Other community and economicdevelopment560056TIF Rebates5710,00010,00010,00057580058Total Community and EconomicDevelopment59720,5170142,594000863,111863,11159Section F — General Government6060Mayor, Council and City Manager611,399,6681,399,6681,399,66861Clerk, Treasurer, FinancialAdministration62168,437168,437168,43762Elections635,1965,1965,19663Legal Services and City Attorney64-35,159-35,159-35,15964City Hall and General Buildings65629,597629,597629,59765Tort Liability660066Other General Government670067Human Resources6868,12968,12968,12968Information Technology69323,439323,439323,43969Total General Government702,559,30700002,559,3072,559,30770Section G — Debt Service719,332,0989,332,0989,332,09871720072730073Total Debt Service740009,332,098009,332,0989,332,09874Section H — Regular CapitalProjects — Specify7575Debt Issuance76260,692260,692260,69276770077Subtotal Regular CapitalProjects78000260,6920260,692260,69278TIF Capital Projects — Specify7979800080810081Subtotal TIF Capital Projects82000000082Total Capital Projects83000260,6920260,692260,69283 Total Governmental ActivitiesExpenditures8413,922,8912,100,851142,5949,332,09811,847,959037,346,39337,346,39384(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, -- ContinuedGAAPItem 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 I — Business TypeActivities8787Water — Current Operation884,246,7984,246,79888Capital Outlay8971,25371,25389Debt Service90284,918284,91890Sewer and Sewage Disposal —Current Operation912,751,4372,751,43791Capital Outlay9226,81626,81692Debt Service93395,577395,57793Electric — Current Operation94094Capital Outlay95095Debt Service96096Gas Utility — Current Operation975,747,9765,747,97697Capital Outlay9831,20331,20398Debt Service9930,60530,60599Parking — Current Operation1000100Capital Outlay1010101Debt Service1020102Airport — Current Operation1030103Capital Outlay1040104Debt Service1050105Landfill/Garbage — Currentoperation1061,324,0511,324,051106Capital Outlay1070107Debt Service1080108Hospital — Current Operation1090109Capital Outlay1100110Debt Service1110111Transit — Current Operation1120112Capital Outlay1130113Debt Service1140114Cable TV, Telephone, Internet —Current Operation1150115Capital Outlay1160116Housing Authority — CurrentOperation1170117Capital Outlay1180118Debt Service1190119Storm Water — Current Operation120596,959596,959120Capital Outlay12122,82122,821121Debt Service1226,3586,358122Other Business Type — CurrentOperation1231,076,5321,076,532123Capital Outlay124688688124Debt Service12514,50914,509125Internal Service Funds — Specify12612612701271280128Total Business TypeActivities12916,628,50116,628,501129
EXPENDITURES P9CITY OF WAUKEEEXPENDITURES AND OTHER FINANCING USES FOR FISCAL YEAR ENDED JUNE 30, 2020 -- ContinuedGAAPItem 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 (Sum of col.(g)) (i)LineSubtotal Expenditures (Sum of lines 84and 129)13013,922,8912,100,851142,5949,332,09811,847,959037,346,39316,628,50153,974,894130Section J — Other Financing Uses IncludingTransfers Out131131Regular transfers out13216,5002,848,3702,864,870618,0033,482,873132Internal TIF loans/repayments and transfersout1335,120,7765,120,7765,120,77613313400134Total Other Financing Uses13516,5002,848,3705,120,7760007,985,646618,0038,603,649135Total Expenditures and Other FinancingUses (Sum of lines 130 and 135)13613,939,3914,949,2215,263,3709,332,09811,847,959045,332,03917,246,50462,578,543136 137137Ending fund balance June 30, :138138Governmental:139139Nonspendable140768,291125,752894,043894,043140Restricted141189,2743,969,3671,255,97121,885,10127,299,71327,299,713141Committed142664,574664,574664,574142Assigned143435,0367,986,2378,421,2738,421,273143Unassigned1446,482,4386,482,4386,482,438144Total Governmental1458,350,3398,301,2633,969,3671,255,97121,885,101043,762,04143,762,041145Proprietary14663,289,48863,289,488146Total Ending Fund Balance June 30,1478,350,3398,301,2633,969,3671,255,97121,885,101043,762,04163,289,488107,051,529147Total Requirements (Sum of lines 136 and147)14822,289,73013,250,4849,232,73710,588,06933,733,060089,094,08080,535,992169,630,072148
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 governmentsCorrectionHealthHighways23,188Transit SubsidiesLibrariesPolice protection587,379Sewerage2,001,594Sanitation22,456All other1,909,673PurposeAmount paid to StateHighwaysAll other1,684,841Part 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 ownedand 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 PAIDAmountTotal Salaries and Wages Paid9,389,773Part V Debt Outstanding, Issued, and RetiredTransit subsidiesA. Long-Term DebtDebt During the Fiscal YearDebt Outstanding JUNE 30, 2020PurposeLineDebt Outstanding JULY 1, 2019IssuedRetiredGeneral ObligationTIF RevenueRevenueOtherInterest Paid This YearWater Utility1.6,210,0002,040,0002,210,0006,040,000267,827Sewer Utility2.22,744,0001,233,000445,00021,066,000410,227Electric Utility3.Gas Utility4.1,195,0001,195,000032,265Transit-Bus5.Industrial Revenue6.Mortgage Revenue7.TIF Revenue8.345,000170,000175,00013,285Other Purposes / Miscellaneous9.380,28657,594322,69213,154GO10.64,309,87517,580,0006,460,51775,429,3582,240,494Parking11.Airport12.Stormwater13.460,00060,000400,0006,438Section 10814.Total Long-Term95,644,16119,620,00011,386,11175,874,358175,00027,828,69202,983,690B. Short-Term Debt AmountOutstanding as of July 1, 201938,956Outstanding as of JUNE 30, 202025,030Part VI DEBT LIMITATION FOR GENERAL OBLIGATIONSActual valuation -- January 1, 2018Amount2,097,330,572x.0.5 = $104,866,528.6Part VII CASH AND INVESTMENT ASSETS AS OF JUNE 30, 2020Type 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)3,702,73127,759,79644,924,06076,386,587If 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 shadedNote area.REMARKS-