HomeMy WebLinkAbout2019-11-04-J01D 2019 State Financial ReportJ1D
/
STATE OF IOWA
2019
FINANCIAL REPORT
FISCAL YEAR ENDED
JUNE 30, 2019
CITY OF WAUKEE, IOWA
DUE: December 1, 2019
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 13,243,702 13,243,702 13,192,452
Less: Uncollected Property Taxes-Levy Year 0 0
Net Current Property Taxes 13,243,702 13,243,702 13,192,452
Delinquent Property Taxes 0 0
TIF Revenues 4,130,854 4,130,854 4,124,530
Other City Taxes 2,513,810 0 2,513,810 2,371,703
Licenses and Permits 2,445,190 0 2,445,190 1,549,050
Use of Money and Property 934,033 610,034 1,544,067 1,374,430
Intergovernmental 6,321,397 0 6,321,397 6,071,242
Charges for Fees and Service 700,716 23,858,461 24,559,177 24,238,285
Special Assessments 105,918 0 105,918 16,500
Miscellaneous 995,677 179,046 1,174,723 382,833
Other Financing Sources 870,807 -1,261,954 -391,147 269,000
Transfers In 7,532,348 31,745 7,564,093 7,569,848
Total Revenues and Other Sources 39,794,452 23,417,332 63,211,784 61,159,873
Expenditures and Other Financing Uses
Public Safety 6,596,414 6,596,414 6,637,750
Public Works 12,873,790 12,873,790 3,381,712
Health and Social Services 800 800 7,500
Culture and Recreation 7,239,295 7,239,295 2,590,314
Community and Economic Development 991,664 991,664 1,237,785
General Government 1,985,538 1,985,538 2,341,558
Debt Service 8,858,854 8,858,854 8,858,227
Capital Projects 188,487 188,487 22,615,000
Total Governmental Activities Expenditures 38,734,842 0 38,734,842 47,669,846
BUSINESS TYPE ACTIVITIES 16,676,598 16,676,598 27,086,042
Total All Expenditures 38,734,842 16,676,598 55,411,440 74,755,888
Other Financing Uses 0 0 0 0
Transfers Out 6,910,996 653,097 7,564,093 7,569,848
Total All Expenditures/and Other Financing Uses 45,645,838 17,329,695 62,975,533 82,325,736
Excess Revenues and Other Sources Over (Under) Expenditures/and Other Financing Uses -5,851,386 6,087,637 236,251 -21,165,863
Beginning Fund Balance July 1, 2018 34,671,584 49,334,853 84,006,437 57,067,238
Ending Fund Balance June 30, 2019 28,820,198 55,422,490 84,242,688 35,901,375
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, 2019 Amount Indebtedness at June 30, 2019 Amount
General Obligation Debt 65,189,875 Other Long-Term Debt 0
Revenue Debt 30,109,286 Short-Term Debt 38,956
TIF Revenue Debt 345,000
General Obligation Debt Limit 92,216,746
CERTIFICATION
The forgoing report is correct to the best of my knowledge and belief
Signature of Preparer
Publication
11/7/2019
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/05/2019
PLEASE PUBLISH THIS PAGE ONLY
/REVENUE P2CITY OF WAUKEEREVENUE AND OTHER FINANCING SOURCES FOR YEAR ENDED JUNE 30, 2019GAAPItem 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 (Sumof (g) and (h)) (i)Section A - Taxes11Taxes levied on property27,598,2711,972,4463,672,98513,243,70213,243,7022Less: Uncollected Property Taxes -Levy Year3003Net Current Property Taxes47,598,2711,972,4463,672,9850013,243,70213,243,7024Delinquent Property Taxes5005Total Property Tax67,598,2711,972,4463,672,9850013,243,70213,243,7026TIF Revenues74,130,8544,130,8544,130,8547Other City TaxesUtility Tax Replacement ExciseTaxes8008Utility Franchise Tax (Chapter364.2, Code of Iowa)9009Parimutuel Wager Tax100010Gaming Wager Tax110011Mobile Home Tax1212,6603,2915,25421,20521,20512Hotel / Motel Tax135,8075,8075,80713Other Local Option Taxes142,486,7982,486,7982,486,79814Total Other City Taxes1518,4672,490,0895,254002,513,81002,513,81015Section B - Licenses and Permits161,432,72310,1421,002,3252,445,1902,445,19016Section C - Use of Money and Property1717Interest1887,09259,561102,06742,701533,268824,689538,8601,363,54918Rents and Royalties19109,344109,34471,174180,51819Other Miscellaneous Use of Moneyand Property200020210021Total Use of Money and Property22196,43659,561102,06742,701533,2680934,033610,0341,544,06722Section D - Intergovernmental2424Federal Grants and Reimbursements2626Federal Grants2738,6582,615,1262,653,7842,653,78427Community Development BlockGrants280028Housing and Urban Development290029Public Assistance Grants300030Payment in Lieu of Taxes310031320032Total Federal Grants andReimbursements3338,658002,615,12602,653,78402,653,78433
/REVENUE P3CITY OF WAUKEEREVENUE AND OTHER FINANCING SOURCES FOR YEAR ENDED JUNE 30, 2019GAAPItem 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 (Sumof (g) and (h)) (i)Section D - Intergovernmental -Continued4141State Shared Revenues4343Road Use Taxes442,332,3412,332,3412,332,34144Other state grants and reimbursements4848State grants4940,74540,74540,74549Iowa Department of Transportation500050Iowa Department of Natural Resources5110,47910,47910,47951Iowa Economic Development Authority5265,95565,95565,95552CEBA grants530053Commercial & Industrial ReplacementClaim54123,50332,08466,69159,683281,961281,96154RISE Grant5580,90980,90980,90955Iowa Cultural Affairs - Great Places5695,00095,00095,00056570057580058590059Total State60174,7272,364,42566,69159,683241,86402,907,39002,907,39060Local Grants and ReimbursementsCounty Contributions631,8351,8351,83563Library Service648,7238,7238,72364Township Contributions6567,85167,85167,85165Fire/EMT Service660066Police Contract Buy Out6715,21615,21615,21667School District68144,303522,295666,598666,59868690069Total Local Grants and Reimbursements70237,928000522,2950760,2230760,22370Total Intergovernmental (Sum oflines 33, 60, and 70)71451,3132,364,42566,69159,6833,379,28506,321,39706,321,39771Section E -Charges for Fees and Service7272Water7305,223,0895,223,08973Sewer7407,666,2057,666,20574Electric750075Gas7607,687,0527,687,05276Parking770077Airport780078Landfill/garbage7901,442,5611,442,56179Hospital800080
/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 (Sumof (g) and (h)) (i)Section E - Charges for Fees andService - Continued8181Transit820082Cable TV830083Internet840084Telephone850085Housing Authority860086Storm Water870984,838984,83887Other:8888Nursing Home890089Police Service Fees9037,8501,10438,95438,95490Prisoner Care910091Fire Service Charges922,3052,3052,30592Ambulance Charges93296,465296,465296,46593Sidewalk Street Repair Charges940094Housing and Urban Renewal Charges950095River Port and Terminal Fees960096Public Scales970097Cemetery Charges980098Library Charges990099Park, Recreation, and Cultural Charges100151,370151,370151,370100Animal Control Charges1010010110200102Copies/Mechanic Fees/UtilityBilling/Golf Course103211,622211,622854,7161,066,338103Total Charges for Service104699,6121,1040000700,71623,858,46124,559,177104Section F - Special Assesments106101,7144,204105,918105,918106Section G - Miscellaneous107107Contributions10827,148500,000283,520810,6681,034811,702108Deposits and Sales/Fuel TaxRefunds10900109Sale of Property and Merchandise11027,39111,18838,579125,743164,322110Fines11149,08049,08049,080111Internal Service Charges1120011211300113Damage Reimbursement1147,7549,67417,42820,82438,252114Patron Rebates11518,87088219,75231,44551,197115Fire Association11610,29810,29810,298116Library Foundation11749,87249,87249,8721171180011811900119Total Miscellaneous120130,243581,91400283,5200995,677179,0461,174,723120
/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 (Sum of(a) through (f)) (g)Proprietary (h)GrandTotal (Sum of(g) and (h)) (i)Total All Revenues (Sum of lines 6, 7, 15,16,22,71, 104, 106, and 120)12110,527,0657,479,6814,299,6123,882,3375,202,602031,391,29724,647,54156,038,838121Section H - Other Financing Sources123123Proceeds of capital asset sales124870,807870,807-1,261,954-391,147124Proceeds of long-term debt (Excluding TIFinternal borrowing)12500125Proceeds of anticipatory warrants or othershort-term debt12600126Regular transfers in and interfund loans1272,604,9311,106,8093,711,74031,7453,743,485127Internal TIF loans and transfers in128336,7113,483,8973,820,6083,820,6081281290012913000130Total Other Financing Sources1313,812,449004,590,706008,403,155-1,230,2097,172,946131Total Revenues Except for Beginning Balances(Sum of lines 121 and 131)13214,339,5147,479,6814,299,6128,473,0435,202,602039,794,45223,417,33263,211,784132Beginning Fund Balance July 1, 20181345,161,667848,4423,655,225588,60124,417,64934,671,58449,334,85384,006,437134Total Revenues and Other Financing Sources(Sum of lines 132 and 134)13619,501,1818,328,1237,954,8379,061,64429,620,251074,466,03672,752,185147,218,221136
/EXPENDITURES P6CITY OF WAUKEEEXPENDITURES AND OTHER FINANCING USES FOR FISCAL YEAR ENDED JUNE 30, 2019GAAPItem 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,283,0264773,283,5033,283,5032Jail3003Emergency Management45,8045,8045,8044Flood control5005Fire Department61,112,53611,9451,124,4811,124,4816Ambulance71,051,193160,0001,211,1931,211,1937Building Inspections8513,012513,012513,0128Miscellaneous Protective Services9009Animal Control105,9025,9025,90210Other Public Safety11452,519452,519452,51911120012130013Total Public Safety146,423,99212,4220160,00006,596,4146,596,41414Section B — Public Works1515Roads, Bridges, Sidewalks161,746,4609,925,73711,672,19711,672,19716Parking Meter and Off-Street170017Street Lighting18307,738307,738307,73818Traffic Control Safety1950,13550,13550,13519Snow Removal200020Highway Engineering210021Street Cleaning220022Airport (if not an enterprise)230023Garbage (if not an enterprise)240024Other Public Works250025Public Works Administration26262,751262,751262,75126Engineering / GIS27580,969580,969580,96927Total Public Works28843,7202,104,33309,925,737012,873,79012,873,79028Section C — Health and SocialServices2929Welfare Assistance300030City Hospital310031Payments to Private Hospitals320032Health Regulation and Inspections330033Water, Air, and Mosquito Control3480080080034Community Mental Health350035Other Health and Social Services360036370037380038Total Health and Social Services39800000080080039Section D — Culture andRecreation4040Library Services411,231,17055,8431,287,0131,287,01341Museum, Band, Theater420042Parks43572,4874,751,6715,324,1585,324,15843Recreation44609,943609,943609,94344Cemetery450045Community Center, Zoo, Marina,and Auditorium4618,18118,18118,18146Other Culture and Recreation470047480048490049Total Culture and Recreation502,431,78155,84304,751,67107,239,2957,239,29550
/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 (Sum of col. (g)) (i)LineSection E — Community andEconomic Development5151Community beautification5233,05133,05133,05152Economic development53243,79223,121266,913266,91353Housing and urban renewal540054Planning and zoning55480,949480,949480,94955Other community and economicdevelopment560056TIF Rebates57210,751210,751210,75157580058Total Community and EconomicDevelopment59757,7920233,872000991,664991,66459Section F — General Government6060Mayor, Council and City Manager61882,486882,486882,48661Clerk, Treasurer, FinancialAdministration62140,391140,391140,39162Elections630063Legal Services and City Attorney64239,629239,629239,62964City Hall and General Buildings65455,485455,485455,48565Tort Liability660066Other General Government670067HR / IT68267,547267,547267,54768690069Total General Government701,985,53800001,985,5381,985,53870Section G — Debt Service718,858,8548,858,8548,858,85471720072730073Total Debt Service740008,858,854008,858,8548,858,85474Section H — Regular Capital Projects— Specify7575Debt Issuance7630430430476Golf Course77188,183188,183188,18377Subtotal Regular Capital Projects78000188,4870188,487188,48778TIF Capital Projects — Specify7979800080810081Subtotal TIF Capital Projects82000000082Total Capital Projects83000188,4870188,487188,48783 Total Governmental ActivitiesExpenditures8412,443,6232,172,598233,8728,858,85415,025,895038,734,84238,734,84284(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 Operation883,657,5983,657,59888Capital Outlay891,558,3501,558,35089Debt Service90206,232206,23290Sewer and Sewage Disposal —Current Operation912,145,5972,145,59791Capital Outlay9217,79317,79392Debt Service93405,248405,24893Electric — Current Operation94094Capital Outlay95095Debt Service96096Gas Utility — Current Operation975,706,5435,706,54397Capital Outlay985,5495,54998Debt Service9941,59641,59699Parking — Current Operation1000100Capital Outlay1010101Debt Service1020102Airport — Current Operation1030103Capital Outlay1040104Debt Service1050105Landfill/Garbage — Current operation1061,297,5021,297,502106Capital Outlay1070107Debt Service1080108Hospital — Current Operation1090109Capital Outlay1100110Debt Service1110111Transit — Current Operation1120112Capital Outlay1130113Debt Service1140114Cable TV, Telephone, Internet —Current Operation1150115Capital Outlay1160116Housing Authority — CurrentOperation1170117Capital Outlay1180118Debt Service1190119Storm Water — Current Operation120759,901759,901120Capital Outlay1210121Debt Service1226,1876,187122Other Business Type — CurrentOperation123848,980848,980123Capital Outlay1245,0005,000124Debt Service12514,52214,522125Internal Service Funds — Specify12612612701271280128Total Business Type Activities12916,676,59816,676,598129
/EXPENDITURES P9CITY OF WAUKEEEXPENDITURES AND OTHER FINANCING USES FOR FISCAL YEAR ENDED JUNE 30, 2019 -- 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 84 and129)13012,443,6232,172,598233,8728,858,85415,025,895038,734,84216,676,59855,411,440130Section J — Other Financing Uses IncludingTransfers Out131131Regular transfers out13214,2452,516,343559,8003,090,388653,0973,743,485132Internal TIF loans/repayments and transfers out1333,820,6083,820,6083,820,60813313400134Total Other Financing Uses13514,2452,516,3433,820,6080559,80006,910,996653,0977,564,093135Total Expenditures and Other Financing Uses (Sum of lines 130 and 135)13612,457,8684,688,9414,054,4808,858,85415,585,695045,645,83817,329,69562,975,533136 137137Ending fund balance June 30, :138138Governmental:139139Nonspendable140843,892843,892843,892140Restricted141373,3873,639,1823,900,357202,79014,034,55622,150,27222,150,272141Committed142543,258543,258543,258142Assigned14300143Unassigned1445,282,7765,282,7765,282,776144Total Governmental1457,043,3133,639,1823,900,357202,79014,034,556028,820,19828,820,198145Proprietary14655,422,49055,422,490146Total Ending Fund Balance June 30,1477,043,3133,639,1823,900,357202,79014,034,556028,820,19855,422,49084,242,688147Total Requirements (Sum of lines 136 and 147)14819,501,1818,328,1237,954,8379,061,64429,620,251074,466,03672,752,185147,218,221148
/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 governmentsCorrectionHealthHighways331,475LibrariesPolice protection434,227Sewerage1,842,733Sanitation88,156All other2,406,713PurposeAmount paid to StateHighwaysAll other1,476,305Part 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 DOLLARSIN THE Amount areas FOR SALARIES AND WAGES PAIDAmountTotal Salaries and Wages Paid8,532,585Part V Debt Outstanding, Issued, and RetiredTransit subsidiesA. Long-Term DebtDebt During the Fiscal YearDebt Outstanding JUNE 30,PurposeLineDebt Outstanding JULY 1, NaNIssuedRetiredGeneral ObligationTIF RevenueRevenueOtherInterest Paid This YearWater Utility1.6,535,000325,0006,210,000209,481Sewer Utility2.20,823,0002,948,0001,027,000880,00021,864,000442,768Electric Utility3.Gas Utility4.1,572,000377,0001,195,00042,444Transit-Bus5.Industrial Revenue6.Mortgage Revenue7.TIF Revenue8.505,000160,000345,00019,045Other Purposes / Miscellaneous9.436,40056,114380,28614,685GO10.70,267,9885,958,11364,309,8752,216,400Parking11.Airport12.Stormwater13.520,00060,000460,0006,252Section 10814.Total Long-Term100,659,3882,948,0007,963,22765,189,875345,00030,109,28602,951,075B. Short-Term Debt AmountOutstanding as of June 1, NaN68,041Outstanding as of JUNE 30,38,956Part VI DEBT LIMITATION FOR GENERAL OBLIGATIONSActual valuation -- January 1, NaNAmount1,844,334,937x.0.5 = $92,216,746.85Part VII CASH AND INVESTMENT ASSETS AS OF JUNE 30,Type of assetAmountBond and interest funds(a)Bond construction funds (b)Pension/retirement funds(c)All other Funds(d)Total (e)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.If you budget on a NON-GAAP CASH BASIS, the amount in the Total below SHOULD EQUAL the followingsummed amounts on the sheet All Funds P1: Ending fund balance, column C PLUS the amounts in the shaded Notearea.2,849,92219,603,77634,385,45756,839,155REMARKS