2025 Budget Presentation

2025 BUDGET PACKET 12/3/2024 CITY OF WAUPACA 5 33 36 Executive Summary Tax Information General Obligation Debt Utilities Tax Incremental Districts42 Contents 19 14 General Fund Summary Other Funds24 Capital Improvement Plans48 4 Resolution Notice of Public Hearing3 Significant Changes: The 2025 budget imposes a decrease ($53,376) in the tax levy from 2024 to 2025 which is in compliance with the State’s Levy Limit. There is a minor increase (1.7%) in the Debt Service Levy to ensure the City sticks to the current financial plan by increasing at a rate close to our natural growth number. There are no personnel changes taking effect in 2025. The 2025 budget and services continue to be maintained when compared to 2024, apart from a slight increase of subsidy to the Youth Program and Library Fund in order to support operational expenses. An increase in Intergovernmental Revenues (State Aids) and other revenue sources allowed for a tiered wage increase for City Employees. This will be applied with a 3% increase in January and a 1% increase in July, while other employee benefit costs remain the same or with a slight change with the exception of costs associated with health insurance which rose again by 8%. Stephanie Reif, Finance Director/Treasurer Posted: November 12, 2024 Published: November 14, 2024 WNAXLP CITY OF WAUPACA NOTICE OF PUBLIC HEARING 2025 ANNUAL PROPERTY TAX LEVY AND BUDGET PLEASE TAKE NOTICE that a public hearing is being held before the Common Council of the City of Waupaca on Tuesday, December 3, 2024, at 6:00 p.m. or as soon thereafter as the matter can be heard in Council Chambers of the City Hall of the City of Waupaca, 111 S Main St, Waupaca, Wisconsin. The purpose of the public hearing is to solicit public comment on the City’s 2025 Annual Property T ax Levy and Budget. A copy of the proposed 2025 Annual Budget is available for public inspection in the office of the City Clerk in the City Hall during normal business hours. The City has met the requirements of Wisconsin Statute 65.90(3)(a) by posting this notice in four public places. PLEASE TAKE FURTHER NOTICE that at such time and place, any interested party may appear in person, by attorney or agent, and be heard on these matters. A summary of the proposed budget and tax levy is listed below. The City may elect to change the proposed budget and tax levy prior to the public hearing. The schedules below summarize the 2025 budget as it is proposed. 2021 2022 2023 12/31/2024 2024 2025 DOLLAR % CHANGE AMENDED GENERAL FUND ACTUAL ACTUAL ACTUAL ESTIM ATED BUDGET BUDGET CHANGE 2024-2025 REVEN UES TAXES 3,388,901 $ 3,406,881 $ 3,703,464 $ 4,248,098$ 4,243,071 $ 4,195,475 $ (47,596) (1.12%) INTERGOVERNM ENTAL REVENUES 1,559,482 1,642,550 1,720,976 1,973,495 1,962,148 2,192,929 230,781 11.69% LICENSES & PERMITS 479,772 326,055 416,925 504,019 307,133 382,983 75,850 15.05% FINES & FORFEITURES 70,505 54,970 58,390 56,973 55,600 67,600 12,000 21.06% PUBLIC CHARGES FOR SERVICES 126,189 147,768 179,702 176,911 131,614 155,325 23,711 13.40% TRANSFERS IN 563,060 582,785 482,593 497,076 520,000 510,000 (10,000) (2.01%) INTEREST 33,699 24,419 361,745 250,320 75,000 75,000 - 0.00% OTHER SOURCES 331,860 377,532 424,463 457,818 431,228 577,500 146,272 31.95% TOTAL REVEN UES 6,553,468 6,562,960 7,348,258 8,164,710 7,725,794 8,156,812 431,018 5.58% EXPEN D ITURES General Government 1,273,349 $ 1,267,620 $ 1,192,279 $ 1,257,574$ 1,248,089 $ 1,309,025 $ 60,936 4.85% Public Safety 2,087,536 2,230,777 2,224,753 2,324,138 2,295,830 2,533,003 237,173 10.20% Public Works 915,767 939,495 993,153 1,028,327 1,082,073 1,108,528 26,455 2.57% Health and Social Services 185,341 173,384 196,792 198,824 197,944 214,295 16,351 8.22% Park & Recreation 565,654 629,552 662,903 717,588 676,811 737,058 60,247 8.40% Other Financing Uses 1,595,699 1,511,219 1,683,752 2,201,342 2,201,342 2,254,903 53,561 2.43% TOTAL EXPEN D ITURES 6,623,346 6,752,047 6,953,632 7,727,793 7,702,089 8,156,812 454,723 5.88% REVENUES LESS EXPENDITURES (69,878)$ (189,087)$ 394,626 $ 436,917$ 23,705 $ 0 $ BEGINNING FUND BALANCE 2,233,456 $ 2,163,578 $ 1,974,491 $ 1,974,491$ 2,411,407 $ ENDING FUND BALANCE 2,163,578 $ 1,974,491 $ 2,369,117 $ 2,411,407$ 2,435,112 $ 43.0% 37.7% 45.0% 43.6% 44.3% 2021 2022 2023 12/31/2024 2024 2025 DOLLAR % CHANGE OTHER FUNDS ACTUAL ACTUAL ACTUAL ESTIMATED BUDGET BUDGET CHANGE 2024-2025 REVENUES Special Rev enue Fund s Hotel/Motel 304,992 381,618 318,993 275,880 275,500 275,500 - 0.00% Airport 237,109 296,405 354,252 330,276 289,950 327,000 37,050 10.46% Transit 530,068 544,590 574,833 544,691 566,487 598,524 32,037 5.57% Refuse/Recycling 296,207 309,855 287,040 287,040 325,000 37,960 12.25% Library 796,680 791,322 864,887 853,870 852,656 877,782 25,126 2.91% Adult Recreation Program s 10,874 15,591 19,838 29,889 19,875 29,875 10,000 50.41% Youth Program s 271,164 298,370 318,255 306,418 304,337 348,410 44,073 13.85% Inland Lakes 10,000 10,000 10,000 10,000 10,000 10,000 - 0.00% Deb t Serv ice 1,390,673 2,313,966 1,165,500 1,662,122 1,662,122 1,691,209 29,087 2.50% Capital Project Fund 278,509 9,068,114 1,500,000 1,402,000 1,402,000 2,131,900 729,900 48.66% TIF Dis tricts#4 - #12 2,654,734 3,506,728 1,473,020 2,918,354 2,906,943 3,012,303 105,360 7.15% TOTAL REVENUES 6,484,803$ 17,522,911$ 6,909,433$ 8,620,540$ 8,576,910$ 9,627,503$ 1,050,593$ 15.21% EXPENDITURES Special Rev enue Fund s Hotel/Motel 370,387 232,459 390,450 275,550 275,500 275,500 - 0.00% Airport 245,373 284,162 351,123 328,846 289,950 327,450 37,500 10.68% Transit 513,250 532,329 574,833 582,000 582,300 623,300 41,000 7.13% Refuse/Recycling 302,858 298,778 288,462 287,040 325,000 37,960 12.71% Library 775,638 788,718 851,683 851,137 885,314 917,481 32,167 3.78% Adult Recreation Program s 10,354 17,124 12,074 23,344 20,117 21,677 1,560 12.92% Youth Program s 269,977 298,428 336,331 307,096 304,338 348,410 44,072 13.10% Inland Lakes 11,687 7,286 8,600 10,200 10,200 10,000 (200) (2.33%) Deb t Serv ice 1,234,226 1,417,313 1,959,208 1,662,122 1,662,122 1,732,847 70,725 3.61% Capital Project Fund 1,664,444 2,744,877 12,096,430 1,177,000 1,177,000 2,131,900 954,900 7.89% TIF Dis tricts#4 - #12 2,448,852 4,560,648 1,114,170 3,174,015 3,173,539 3,307,759 134,220 12.05% TOTAL EXPENDITURES 7,544,189$ 11,186,202$ 17,993,680$ 8,679,772$ 8,667,420$ 10,021,324$ 1,353,904$ 7.52% Dollar Amt Percent Taxing Fund 2021 2022 2023 2024 2025 Inc / (Dec) Change General 1,702,644$ 1,747,551$ 1,955,466$ 1,977,996$ 1,871,059$ (106,937)$ (5.47%) Library 346,554$ 346,554 346,554 367,522 373,035 5,513$ 1.59% Transit 10,000 10,000 10,000 10,000 10,000 -$ 0.00% Airport 83,250 83,890 60,000 60,000 50,000 (10,000)$ (16.67%) Youth Program 102,323$ 102,323$ 101,698$ 101,698$ 130,659$ 28,961$ 28.48% Debt Serv ice 1,070,034 1,051,569 1,165,500 1,662,122 1,691,209 29,087$ 2.50% Total Tax Lev y 3,314,805$ 3,341,887$ 3,639,218$ 4,179,338$ 4,125,962$ (53,376)$ (1.47%) 427392 CITY OF WAUPACA WAUPACA COUNTY, WISCONSIN RESOLUTION NO. 1569 A RESOLUTION DESIGNATING APPROPRIATIONS AND LEVYING A TAX FOR THE 2025 BUDGET OF THE CITY OF WAUPACA WHEREAS, the City Council annually adopts the City’s budget for municipal operations for the next fiscal year (January 1 to December 31) in accordance with Section 3.03 of the Municipal Code; and WHEREAS, the City properly advertised and the City Council conducted a public hearing to consider the Proposed 2025 Budget (January 1 to December 31, 2025) on December 3, 2024; NOW, THEREFORE, BE IT RESOLVED by the City of Waupaca, Wisconsin City Council as follows: I. The City hereby adopts the City’s 2025 City Budget commencing on January 1, 2025 and ending December 31, 2025 containing the following revenues and expenditures below. A copy of the complete detail of the Adopted 2025 City Budget shall be on file in the City Hall. BE IT FURTHER RESOLVED, the City Council shall adopt a Resolution setting the amount of municipal taxes to be levied and assessed on taxable property in the City for the current year; and WHEREAS, in support of the City’s Adopted 2025 Budget, the amount of City tax revenue required is as follows: Taxing Fund 2025 Tax Levy General $ 1,871,059 Library $ 373,035 Transit $ 10,000 Airport $ 50,000 Youth Program $ 130,659 Debt Service $ 1,691,209 Total Tax Levy $ 4,125,962 NOW, THEREFORE, BE IT RESOLVED by the City of Waupaca, Wisconsin City Council as follows: I. The City Council hereby sets the City’s tax levy for municipal operations, as identified herein, to be levied and assessed on the taxable property in the City of Waupaca for the year 2025 at $4,125,962. PASSED AND APPROVED, this 3rd day of December 2024, by the City Council, City of Waupaca, County of Waupaca, Wisconsin. Mayor Brian Smith Alderperson Paul Mayou Council President ADOPTED: December 3, 2024 APPROVED: December 3, 2024 ATTEST: Barb Nowak, City Clerk Aaron Jenson, City Administrator 111 S. Main Street • Waupaca, WI 54981 aaron.jenson@waupacawi.gov www.cityofwaupaca.org 715.258.4411 To: Members of City Council From : Mayor Brian Smith Aaron Jenson, City Administrator Stephanie Reif, Finance Director Date: Re: 12/3/24 Summary of 2025 Proposed Budget _____ _______________________________________________________________________________ The City’s proposed 2025 budget, as summarized in this memo, and further detailed in the attachments, is balanced, supports our missions, conserves financial resources, reduces debt, and protects our bond rating. This budget focuses on the requirement to operate with state and local constraints while meeting the needs of our citizens and positioning the City for a sound financial future. The proposed 2025 budget provides for all operational and capital departmental requirements. Notable highlights of property values: • The equalized property value continues to grow. The City’s total equalized value is $647,283,200 up from $608,889,800 ($38,393,400 or 6% increase). Additionally, net new construction came in at 1.22% or $7,411,900. This measures the net new construction that occurred in 2023 which is less than the increase in 2022 when net new construction was $9,144,100 or 1.7%. • The City’s total assessed value has decreased from $626,478,400 in 2023 to $612,315,400. This is a result of the impacts that Act 12 had on personal property values. 2024 is the first year that personal property is removed from our assessment roles resulting in a decrease of ($19,266,600). Real estate values increased by $5,103,600 totaling a net decrease of ($14,163,000). Decreases in total assessment result in a 1.95% increase to the mill rate for 2025 even though the total levy is less in 2025 than 2024. Notable Changes in the Proposed 2025 Budget: • The City will continue to provide the same level of services with no eliminations or reductions. • State sales tax grew at a rate of 2.3% which means our County and Municipal Aid payments received from the State will also grow by that amount in 2025. That number has been confirmed as an increase of $28,585 when compared to 2024. Aaron Jenson, City Administrator 111 S. Main Street • Waupaca, WI 54981 aaron.jenson@waupacawi.gov www.cityofwaupaca.org 715.258.4411 • General Transportation Aids have increased substantially from $559,792 to $644,429 or an increase of $84,637. This number is calculated in part by our reported spending on transportation aid eligible projects within the City. • Net New Construction of 1.22%. In the past, this would have meant that the General Fund supporting tax levy would increase by $30,918. However, this year, the way the City will receive that additional $30,918 is different. The General Fund levy will actually be reduced by $105,763. To offset that reduction and to realize the 1.22% additional revenue, personal property aid was increased to $136,681. That along with other minor state aid adjustments provide a revenue net increase of $30,918 (1.22%) to support General Fund expenses. • Debt Service Levy will increase by $29,070 (1.7%). In 2023, this number was increased by $496,622 from the year prior. With that substantial lift happening last year our debt service levy can now increase at a rate closer to our natural growth number year over year. • Budgeted revenues from TID’s to the General Fund will increase by $15,000. This increase is all supported by the growing revenues in TID 11. • Budgeted revenues from building permit fees increased by $75,000 based on historical trends and planned developments for 2025 and beyond. • Notable increased personnel expenses… o Insurance Premiums (8%): $28,069 o Additions or expansions to the health ins. plan: $42,762 o COLA (3% lift on January 1; and 1% lift on July 1): $95,870 • Over the past few years, the City has held a healthy General Fund balance and the same is true today. The City has a policy that our General Fund balance remains between 20% - 25% of annual expenditures. Per the 2023 audited financials, our General Fund balance sits at 30.7%. This is up from the end of 2022 when unassigned General Fund balance was at 24.7% of annual General Fund expenditures. Having a healthy fund balance is a key factor in achieving an A+ credit rating. The proposed 2025 budget currently results in a balanced budget with a small surplus of $5,189. The 2024 budget is currently trending towards a similar surplus to 2023. Revenues: • Property Tax Levy The property tax levy’s that City Council has control in setting to support City operations and City debt are the General Fund Levy and the Debt Service Levy. General Fund levy is consistently driven by State levy limit laws and the Debt Service Levy is set to ensure the City can meet debt obligations tied to past general fund capital projects. In 2025, the net impact to those two levies is a reduction of $53,376. Aaron Jenson, City Administrator 111 S. Main Street • Waupaca, WI 54981 aaron.jenson@waupacawi.gov www.cityofwaupaca.org 715.258.4411 General Fund Levy: The proposed 2025 budget complies with the state-mandated property tax levy limit laws as outlined in the detail above. General Fund Levy will be reduced from $2,517,216 to $2,434,753. Debt Service Levy: The proposed 2024 budget increases the Debt Service Levy from $1,662,122 to $1,691,209 (1.7%). This levy increase is being proposed to ensure the City sticks to current financial planning to meet future debt obligations by increasing by incremental amounts that aim to stay close to natural growth rates to mitigate the chances for one-time large increases to property taxes. • State Shared Revenue County and Municipal Aid Payment: In 2025 the County and Municipal Aid payment is set to grow with the 2024 state sales tax trends which were approximately 2.3%. This equates to an increase of $28,585 when compared to 2024. Transportation Aids: General Transportation Aids will increase substantially in 2025 from $559,792 to $644,429 or an increase of $84,637. This number is calculated in part from our reported spending on transportation aid eligible projects within the City. Personal Property Aid: As noted in the “Notable Changes Section in the Proposed 2025 Budget” section of this memo, personal property aid has increased by $106,756 which offsets the decrease in general fund levy. • Rental Revenues Rental revenues are budged to increase by $25,000. This is from increased rents from the Water Utility to the General Fund in the amount of $25,000 for a full year in the Public Works Facility. • Building Permit Revenues In 2024 the City was very conservative in budgeting for building permit revenues. Based on recent historical trends and planned developments we are increasing our budgeted amount from $200,000 in 2024 to $275,000 in 2025. Personnel Services (Salaries, Wages, and Benefits) Though current municipal funding in the State of Wisconsin is not equipped for large cost-of- living adjustments, this budget aims to do as much for our employees as possible while staying financially responsible/sustainable with an eye on the future. Aaron Jenson, City Administrator 111 S. Main Street • Waupaca, WI 54981 aaron.jenson@waupacawi.gov www.cityofwaupaca.org 715.258.4411 • Wage Adjustments for Full-Time Non-Represented Employees: For all full-time employees we are budgeting COLA of 3% on January 1st and an additional 1% on July 1st. This is for both represented and non-represented employees. • Health Insurance After last year’s 15% increase, health insurance premiums are increasing by another 8%. The City currently covers 90% of premium costs and employees are responsible for 10%. We are recommending committing to the same coverage in 2025. This means that the City’s premium contributions per employee will increase by the following annual amounts in 2025. o Single Plan: $609.81 o Single + 1 Plan: $1,219.62 o Family Plan: $1,709.31 Based on their 10% contribution, employee annual contributions will increase by the following amounts: o Single Plan: $67.76 o Single + 1 Plan: $135.51 o Family Plan: $189.92 • Staff Positions There are no new full-time positions within the proposed 2025 budget. • WRS Costs: Both the employer and employee share of Wisconsin Retirement System contribution rates increased by 0.05% from 6.9% to 6.95%. Contracted Ambulance/EMS Services: Contracted ambulance services through Gold Cross are increasing from $84,183 to $86,036 which is an increase of $1,853.32 or 2.2%. In 2025, Gold Cross will be changing operations within our consortium. The village of Greenville, and the township of Ellington will be added to the consortium in 2025. The additions of these municipalities will result in a fourth ambulance being added to the consortium. Additional revenue produced from ambulance runs in these areas is expected to offset the vast majority of cost associated with that fourth ambulance. Gold Cross has communicated that municipalities within the consortium can expect to see increased service levels due to the additional Aaron Jenson, City Administrator 111 S. Main Street • Waupaca, WI 54981 aaron.jenson@waupacawi.gov www.cityofwaupaca.org 715.258.4411 ambulance. Gold Cross has offered to attend a City Council meeting to educate City Council members on the impacts of these consortium changes. Contracted Fire Services: Contracted fire services will decrease by ($3,174) or approximately (2.68%). Dues to the Waupaca Area Fire District are determined by the real property improvement values within each participating municipality/township. Due to high value developments around the Chain O’ Lakes both Farmington and Dayton realized substantial increases to their real property values that outpaced the other partners within the district leading to the reduction in fire dues for the City of Waupaca in 2025. Expenditures tied to Services, Materials, and Supplies: Total budgeted general and special revenue fund contractual services, materials, and supplies remained mostly flat. Department heads submitted expense worksheets that reflected minor increases for operational supporting expenses that were near flat when compared to 2024. Property insurance premiums and costs related to cybersecurity initiatives are examples of some of the more substantial cost increases from 2024 to 2025. Transit Local Share Funding: We have budgeted $10,000 for this service as we have in the past. If expenditures should exceed that in 2025, we do have a current fund balance of $41,146 within the Transit Fund to help absorb overruns. Airport Fund: The 2025 budget has been prepared with a transfer of $50,000 from the General Fund to the Airport Fund. This is a decrease in subsidy of $10,000 compared to 2024 and a decrease of $33,000 when compared to 2021. We expect the airport to sustain its recent increase in air traffic and fuel sales in 2025. Our airport managers are currently working with the BOA and Westwood to work towards the 2025 construction of a 7-9 unit t-hanger building. Assuming this gets constructed in 2025, we project reducing the subsidy from the General Fund by an additional $24,000 in 2026. Aaron Jenson, City Administrator 111 S. Main Street • Waupaca, WI 54981 aaron.jenson@waupacawi.gov www.cityofwaupaca.org 715.258.4411 Library Fund & Youth Program Fund: Transfers from the General Fund to the Library Fund are proposed to increase by $5,513. This increase from the General Fund to the Library Fund will go towards allowing staff to receive the same increase as other full-time City staff. This additional support is non-precedent setting and is being proposed with the expectation that the Library staffing levels will continue to move towards standard staffing levels when compared to similar libraries. Funds budgeted as transfers from the General Fund to the Youth Program Fund will increase by $9,523 as a result of the funding formula. The funding formula within the agreement is a per- capita equation using the population of each municipality and multiplying it by $16.86. Because of population increases within the City outpaced the other townships within the agreement, the City will realize an increase for 2025. Laura is currently working with the Parks and Recreation Board and the township representatives on the board to add a CPI factor to that equation so contributions keep pace with inflation. This year, the CPI factor is 3.2%. Capital projects to be funded by General Obligation Bonds in 2025 and 2026 ($2,131,900): • T Hanger Storage Building (Airport) • Cemetery Mower Replacement (Parks) • South Park Lift Station Replacement (Parks) • Replace Irrigation Controller at Swan Park (Parks) • Rec Center Boiler Replacement (Parks) • 2 Patrol Squads (PD) • Professional Planning Services (Community and Econ Development) • Pedestrian Footbridge Planning and Design (Pubic Works) • Fulton Street Planning and Design (Public Works) • Elm Street Reconstruction (Public Works) • Seal Coat Roads Maintenance Program (Public Works) • Replace Plow Truck (Public Works) • Replace Mower (Public Works) • Annual Computer Replacements (IT) • Update Adobe Acrobat Program (IT) • General Government Server Replacement (IT) Capital projects to be funded by Sewer Revenue Bonds in 2025 and 2026 ($3,593,800): • Bowlby Lift Station Design and Reconstruction • Activate Sludge Slide Gates • Elm Street Project Sewer Aaron Jenson, City Administrator 111 S. Main Street • Waupaca, WI 54981 aaron.jenson@waupacawi.gov www.cityofwaupaca.org 715.258.4411 • Mower (1/3 PW share) Capital projects to be funded by Water Reserve Funds in 2024 ($847,000): • Leak Location • Cross Connection Control • Elm Street Project Water • Bowlby Lift Station (Water Main Loop) • 660 Hillcrest Re-Alignment • Mower (1/3 PW Share) Capital projects to be supported through Capital Fund Reserves in 2025 ($90,000): • Partial funding for plow truck (Public Works) • Patrol Squad (PD) Capital projects supported through donations in 2025 ($200,000 - $500,000) • Lakemen Field Concession and Bathrooms (Parks) • Eco-Park Playground (Parks) Capital projects funded through Room Tax Funds in 2025 ($25,000) • Wayfinding Signage Implementation (Community and Economic Development) Capital Projects to be funded through Bureau of Aeronautics ($1,880,000): • T-Hanger Project (Airport) • Airport Master Plan Project (Airport) Water Utility: Staff is recommending a simplified rate case application be submitted to go into effect in January of 2025. When going through a simplified rate case, the utility must set the rate of increase that the PSC predetermines based off inflationary data. As of today, this number is set at 4.1%. A 4.1% increase would result in approximately $59,911 in additional revenue. The Simplified Rate Case (SRC) is a simple and convenient way for municipal utilities that meet specific criteria to increase water rates. This process provides an inflationary type increase that helps utilities maintain revenue continuity. Customers may benefit from a utility using the SRC process to provide smaller, more frequent rate increases. We have confirmed through the PSC that our Water Utility is eligible for a simplified rate case at this time. Aaron Jenson, City Administrator 111 S. Main Street • Waupaca, WI 54981 aaron.jenson@waupacawi.gov www.cityofwaupaca.org 715.258.4411 Sewer Rates: Staff is recommending a sewer rate increase of 3% which would increase revenues by approximately $60,000. Sewer rates have not been increased since 2014. Projected costs for the Bowlby Lift Station project are substantially more than what was projected earlier this year. The impacts of that increase can be seen in our attached sewer revenue financing plan in years 2028-2030 where our debt service coverage projections get to their lowest coverage ratio of 1.26. Anything under 1.10 can negatively impact the Sewer Utility’s ability to borrow at favorable rates. In the future, the City may want to consider smaller incremental increases to mitigate the need for larger increases in any given year. Example of residential utility bill illustrating proposed rate impacts: General Fund Balance: Over the past few years, the City has held a healthy General Fund balance and the same is true today. The City has a policy that our General Fund balance remains between 20% - 25% of annual expenditures. Per the 2023 audited financials, our unassigned General Fund balance sits at 30.7%. This is up from the end of 2022 when unassigned General Fund balance was at 24.7% of annual General Fund expenditures. Having a healthy fund balance is a key factor in achieving an A+ credit rating helping the City borrow at favorable rates. The proposed 2025 budget currently results in a budgeted surplus of $5,189. Total Levy/Mill Rate: This budget is based off a total tax levy of $4,125,962 which is a decrease in total levy of $53,376 when compared to 2024. This results in local mill rate of $7.71 which compares to a 2024 local mill rate of $7.54. This 1.95% increase is a result of a reduction in assessed value through the removal of personal property values form the 2024 assessment roll. Aaron Jenson, City Administrator 111 S. Main Street • Waupaca, WI 54981 aaron.jenson@waupacawi.gov www.cityofwaupaca.org 715.258.4411 The total mill rate, which includes the apportionments from the County, School District and Fox Valley Technical College will be finalized on Wednesday, November 20th when the school levy credit will be released. In Conclusion: For 2025, the City is positioned to continue to provide high-quality services at levels that are equal to past years. This budget is balanced and able to provide employees a competitive COLA in 2025. This budget also continues to cover 90% of the employee health insurance premiums even with the 8% increase, covers all operational needs and funds priority capital projects within the general fund supported departments and the utilities while aligning with long range financial plans for each fund. These accomplishments are a result of the collective efforts of the Mayor, current and past City Councils, the Finance Department, and all the current and past staff who continue to do a magnificent job of delivering services in an efficient and effective manner. TAX INFORMAITON CITY OF WAUPACA TAX RATE CALCULATION WORKSHEET 2024 TAXING BODY APPORTIONED LEVY CALCULATED RATE TAX RATE Waupaca County 2,808,686.08$ 0.00458699 4.59 $ City of Waupaca 4,720,816.97$ 0.00770978 7.71$ Inland Lakes District 11,442.03$ 0.00001869 0.02$ Waupaca School District 3,204,246.67$ 0.00523300 5.23$ Fox Valley Technical College 462,934.36$ 0.00075604 0.76$ GROSS LEVY 11,208,126.11$ 0.01830450 18.31$ School Levy Credit (623,889.30)$ (0.00101890) (1.02)$ NET TAX LEVY 10,584,236.81 0.01728560 17.29$ RE PP TOTAL TOTAL ASSESSED VAL-WITH TIF 612,315,400 612,315,400 EQUALIZED TAX VALUES 647,283,200 - 647,283,200 TIF INCREMENT-INCLUDED IN ABOVE 1,412,299.87$ FIRST DOLLAR CREDIT 45.05$ LOTTERY CREDIT 145.04$ FMV 94.6665526% SPECIAL CHARGES & ASSESSMENTS WATER MAINS & LATERALS SEWER MAINS & LATERALS STREET IMPROVEMENTS -$ WEED CUTTING SNOW REMOVAL OTHER TOTAL SPECIAL CHARGES -$ SANITARY DISTRICT DELQ WATER & SEWER -$ TOTAL SPEC CHRGS & ASSESSMTS -$ TOTAL 10,584,236.81 Waupaca County, 25.1% City of Waupaca, 42.1% Inland Lakes District, 0.1% Waupaca School District, 28.6% Fox Valley Technical College 4% 2024 Tax Levy Allocation 11/21/2024 CITY OF WAUPACA RATE SUMMARY Taxing Bodies 2021 Rate* 2022 Rate* 2023 Rate* 2024 Rate* Increase % inc Waupaca County 6.87$ 7.08$ 4.67$ 4.59$ (0.08)$ (1.13%) City of Waupaca 9.90$ 9.67$ 7.56$ 7.71$ 0.15$ 1.55% Inland Lakes District 0.03$ 0.03$ 0.02$ 0.02$ - $ 0.00% Waupaca School District 8.16$ 7.22$ 4.87$ 5.23$ 0.36$ 4.99% Fox Valley Technical College 1.04$ 1.03$ 0.72$ 0.76$ 0.04$ 3.88% Gross Mill Rate 26.00$ 25.03$ 17.84$ 18.31$ 0.47$ 1.88% School Tax Credit (1.40)$ (1.21)$ (0.98)$ (1.02)$ (0.04)$ 3.31% Net Mill Rate 24.60$ 23.82$ 16.86$ 17.29$ 0.43$ 1.81% Lottery Credit (Maximum Value) 189.28$ 157.40$ 167.81$ 145.04$ First Dollar Credit 53.37$ 47.95$ 45.08$ 45.05$ Assessed Value Ratio 87.56% 78.11% 102.89% 94.67% TAX RATE SUMMARY 11/21/2024 GENERAL FUND 2025 BUDGET WORKSHEET GENERAL FUND SUMMARY Actual Actual Actual Actual Estimate Budget Budget % Prior Year Prior Year Prior Year Current YTD YTD Amended Request Increase Increase Category 2021 2022 2023 ACTUAL 12/31/2024 2024 2025 (Decrease) (Decrease)2 TAXES 3,840,810 3,832,476 4,132,054 4,669,069 4,675,174 4,693,071 4,620,475 (72,596) (1.55%) INTERGOVERNMENTAL REVENUES 1,560,384 1,642,550 1,720,976 969,505 1,976,504 1,962,148 2,192,929 230,781 11.76% LICENSES & PERMITS 472,492 319,627 408,135 477,001 497,719 302,133 377,983 75,850 25.10% FINES & FORFEITURES 70,505 54,970 58,390 61,375 56,973 55,600 67,600 12,000 21.58% PUBLIC CHARGES FOR SERVICES 133,527 154,196 188,492 214,862 185,247 132,600 160,325 27,725 20.91% INTERGOVERNMENTAL CHARGES 145,341 164,429 184,961 153,486 180,317 193,873 304,645 110,772 57.14% MISCELLANEOUS REVENUE 136,151 152,902 523,508 342,387 454,283 236,855 272,355 35,500 14.99% OTHER SOURCES 629,974 680,506 578,242 491,201 560,500 592,000 607,000 15,000 2.53% TOTAL REVENUES 6,989,184 7,001,658 7,794,759 7,378,885 8,586,716 8,168,280 8,603,312 435,032 5.33% MAYOR-COUNCIL 83,340 91,894 76,299 63,341 80,970 81,408 81,408 - 0.00% ADMINISTRATION 163,804 157,711 165,064 166,075 221,712 215,112 208,449 (6,663) (3.10%) CLERK-ELECTIONS 164,905 183,031 117,945 111,416 138,445 159,377 174,004 14,627 9.18% IT-COMMUNICATIONS 84,318 111,971 104,349 83,314 137,291 142,445 159,148 16,703 11.73% FINANCE DEPARTMENT 134,870 118,074 85,541 116,418 171,077 174,000 172,767 (1,233) (0.71%) LEGAL SERVICES 25,877 12,768 27,590 37,338 39,000 32,000 37,000 5,000 15.63% COMMUNITY DEVELOPMENT 363,532 354,881 409,442 300,101 397,860 402,832 423,818 20,986 5.21% CITY HALL/LIBRARY BUILDING 136,583 162,494 150,916 129,084 168,077 163,707 174,176 10,469 6.39% OTHER GENERAL GOVERNMENT 310,576 191,507 200,434 208,712 231,873 211,093 228,843 17,750 8.41% H UMANE SOCIETY - CEMETERY 80,822 75,164 77,012 66,203 79,451 81,017 82,896 1,879 2.32% POLICE STATION 86,036 111,021 77,910 71,276 91,182 91,319 90,531 (788) (0.86%) POLICE DEPARTMENT 1,771,124 1,865,561 1,918,809 1,616,008 1,970,808 1,969,606 2,100,755 131,149 6.66% FIRE-EMS DEPARTMENT 228,499 203,561 228,034 234,154 262,148 234,905 341,717 106,812 45.47% PUBLIC WORKS 917,132 939,523 993,153 992,636 1,234,081 1,312,827 1,338,564 25,737 1.96% RECREATION ADMIN & PROGRAMS 198,355 203,071 234,759 231,782 243,788 242,694 261,975 19,281 7.94% RECREATION & YOUTH CENTERS 119,862 131,976 126,915 101,552 112,783 113,591 117,111 3,520 3.10% PARKS & BEACHES 261,025 264,207 305,882 311,291 338,804 291,533 318,558 27,025 9.27% HISTORICAL SOC-CIVIC PROMO 25,713 26,059 24,980 29,704 29,430 28,500 31,500 3,000 10.53% OTHER USES - TRANSFERS TO OTHER FUNDS 1,595,699 1,510,446 1,683,752 2,201,342 2,201,342 2,201,342 2,254,903 53,561 2.43% CONTINGENCY 5,189 0.00% TOTAL EXPENDITURES 6,752,072 6,714,920 6,979,753 7,071,747 8,150,122 8,149,308 8, 603,312 448,815 5.51% REVENUES OVER(UNDER) EXPENDITURES (69,878) (189,087) 394,626 436,594 18,972 - BEGINNING FUND BALANCE 2,233,456 2,163,578 1,974,491 2,369,117 2,369,117 2,805,711 % fund bal to Expend ENDING FUND BALANCE 2,163,578 1,974,491 2,369,117 2,805,711 2,388,089 2,805,711 32.61% 11/15/2024 GEN FUND SUMMARY 2025 BUDGET WORKSHEET REVENUES FUND Actual Actual Actual Actual 12/31/2024 Budget Budget % 12/31/2021 12/31/2022 12/31/2023 10/31/2024 12/31/2024 Prior Year Prior Year Prior Year Current YTD YTD Amended Request Increase Increase Acct No Account Description 2021 2022 2023 Actual Estimated 2024 2025 (Decrease) (Decrease)5 TAXES 100-41110-000-000 TAXES: GENERAL PROPERTY TAXES 3,318,265 3,341,887 3,639,218 4,172,484 4,179,338 4,179,338 4,125,962 (53,376) (1.28%) 100-41140-000-000 TAXES: MOBILE HOME PARKING FEE 11,410 11,522 11,445 11,242 10,500 10,500 11,500 1,000 9.52% 100-41325-000-000 TAXES: PAYMENT IN LIEU OF TAX 59,220 53,460 52,789 58,247 58,247 53,220 58,000 4,780 8.98% 100-41330-000-000 TAXES: STATE IN LIEU OF TAX 7 13 13 13 13 13 13 0 0.00% 100-41310-000-000 TAXES: WATER TAX EQUIVALENT 201,901 175,587 177,076 177,076 177,076 200,000 175,000 (25,000) (12.50%) 100-41320-000-000 TAXES: SEWER TAX EQUIVALENT 250,008 250,008 250,008 250,008 250,000 250,000 250,000 0 0.00% 100-41810-000-000 TAXES: INTEREST PROPERTY TAXES 0 0 1,50 6000 0 0 . 0 0 % TAXES 3,840,810 3,832,476 4,132,054 4,66 9,069 4,675,174 4,693,071 4,620,475 (72,596) (1.55%) INTERGOVERNMENTAL REVENUES 100-43410-000-000 STATE AID: SHARED REVENUE 889,276 910,136 957,095 177,171 1,181,140 1,181,140 1,209,725 28,585 2.42% 100-43415-000-000 STATE AID: EXPEND RESTRAINT 109, 309 110,419 120,057 99,930 99,930 99,930 99,930 0 0.00% 100-43420-000-000 STATE AID: COMPUTER AID 34,757 34,757 36,021 36,021 36,020 36,020 36,020 0 0.00% 100-43425-000-000 STATE AID: 2% FIRE DUES 19,362 19,303 21,918 25,115 25,115 21,918 26,000 4,082 18.62% 100-43430-000-000 STATE AID: CABLE FRANCHISE FEE (Video Serv. Prov. Aid) 14,343 14,343 14,343 14,343 14,343 14,343 14,343 0 0.00% 100-43440-000-000 STATE AID: PERSONAL PROPERTY AID 21,022 33,639 29,925 29,925 29,925 29,925 136,681 106,756 356.75% 100-43510-000-000 STATE AID: GEN ADMIN GRANTS 0 210 0 0 0 0 0.00% 100-43520-000-000 STATE AID: POLICE TRAINING 2,400 2,400 2,400 0 2,400 2,400 4,800 2,400 100.00% 100-43523-000-000 STATE AID: POLICE OTHER 809 0 6,772 2,369 3,000 15,000 15,000 0 0.00% 100-43524-000-000 STATE AID: EMS DVA 180 0 344 0 0 0 #DIV/0! 100-43530-000-000 STATE AID: GEN TRANSPORTATION 437,054 478,068 487,253 534,272 534,272 534,193 614,413 80,220 15.02% 100-43535-000-000 STATE AID: CONNECTING STREETS 24,408 24,448 21,066 29,973 29,973 25,599 30,017 4,418 17.26% 100-43540-000-000 STATE AID: WI DISASTER FUND 90 20000000 0 . 0 0 % 100-43610-000-000 STATE AID: MUNICIPAL SERVICES 6,522 7,331 21,055 7,694 7,69 4000 # D I V / 0 ! 100-43720-000-000 OTHER GOVERNMENTS POLICE 41 7,496 2,727 12,691 12,691 1,680 6,000 4,320 0.00% 100-43755-000-000 COUNTY AID: LIBRARY 0 0 0 0000 0 . 0 0 % INTERGOVERNMENTAL REVENUES 1,560, 384 1,642,550 1,720,976 969,505 1,976,504 1,962,148 2,192,929 230,781 11.76% LICENSES & PERMITS 100-44110-000-000 LICENSES: LIQUOR & MALT BEV 15,070 16,070 16,596 16,332 16,332 15,000 15,000 0 0.00% 100-44115-000-000 LICENSES: OPERATORS 5,700 6,465 5,185 5,060 5,300 6,000 6,000 0 0.00% 100-44120-100-000 LICENSES: AMUSEMENT DEVICE 6,760 8,233 7,482 7,140 7,640 6,750 7,000 250 3.70% 100-44120-110-000 LICENSES: CIGARETTE 1,600 1,800 1,900 1,600 1,800 1,800 1,800 0 0.00% 100-44130-000-000 LICENSES: GARBAGE PICKUP 750 350 320 190 200 350 350 0 0.00% 100-44140-000-000 LICENSES: MOVIES IN THE PARK 0 0 0 1,850 1,400 0 0 #DIV/0! 100-44155-000-000 LICENSES: MOBILE HOME PARK 182 364 182 0 182 182 182 0 0.00% 100-44220-000-000 LICENSES: DOG: CITY SHARE 1,420 1,521 1,590 1,092 1,500 1,500 1,500 0 0.00% 100-44225-000-000 LICENSES: CATS 310 325 330 255 290 290 290 0 0.00% 100-44240-000-000 LICENSES: OTHER MISC. 2,659 1,957 3,623 1,969 2,300 2,300 3,000 700 30.43% 100-44305-000-000 PERMITS: OTHER DANCE/PARADE 380 195 275 140 275 350 250 (100) (28.57%) 100-44310-000-000 PERMITS: BUILDING 365,937 209,404 302,316 398,306 390,000 200,000 275,000 75,000 37.50% 100-44325-000-000 PERMITS: STREET EXCAVATION 13, 500 12,300 10,100 15,700 14,500 11,611 11,611 0 0.00% 100-44920-000-000 PERMITS: CABLE FRANCHISE 58,180 60,642 58,237 27,368 56,000 56,000 56,000 0 0.00% LICENSES & PERMITS 472,492 319,627 408,135 477,001 497,719 302,133 377,983 75,850 25.10% 11/15/2024 2025 BUDGET WORKSHEET REVENUES FUND Actual Actual Actual Actual 12/31/2024 Budget Budget % 12/31/2021 12/31/2022 12/31/2023 10/31/2024 12/31/2024 Prior Year Prior Year Prior Year Current YTD YTD Amended Request Increase Increase Acct No Account Description 2021 2022 2023 Actual Estimated 2024 2025 (Decrease) (Decrease)5 FINES & FORFEITURES 100-45110-000-000 COURT: TRAFFIC FINES/PENALTIES 47,982 26,654 37,405 33,866 31,000 35,000 40,000 5,000 14.29% 100-45130-000-000 POLICE: PARKING VIOLATIONS 21,234 19,387 20,196 22,116 20,600 20,600 25,600 5,000 24.27% 100-45215-000-000 RESTITUTION/OTHER POLICE RE V 1,288 8,929 789 5,393 5,373 0 2,000 2,000 0.00% FINES & FORFEITURES 70,505 54,970 58,390 61,375 56,973 55, 600 67,600 12,000 21.58% PUBLIC CHARGES FOR SERVICES 100-46110-000-000 FEES: WEIGHTS & MEASURE 10,360 10,088 9,897 12,128 12,062 11,000 15,625 4,625 42.05% 100-46115-000-000 FEES: LICENSE PUBLICATIONS 102 137 184 211 215 100 100 0 0.00% 100-46120-000-000 FEES: SPECIAL ASSESSMENT LTRS 14,250 8,600 7,700 6,225 7, 500 7,500 7,500 0 0.00% 100-46125-000-000 FEES: COPIES/BACKGROUND CHEC KS 4,388 4,261 4,635 3,994 4,400 4,400 4,400 0 0.00% 100-46135-000-000 FEES: CLERK/TREASURER 2,590 4,038 3,440 275 500 0 0 0.00% 100-46150-000-000 FEES: NON CITY EVENTS 3,170 3,279 2,000 2,000 2,000 0 3,000 3,000 0.00% 100-46210-000-000 FEES: POLICE DEPARTMENT 3,876 2,576 4,279 2,179 3,500 3,500 3,500 0 0.00% 100-46310-000-000 FEES: SNOW & ICE CONTROL 5,715 2,325 8,400 3,425 4, 000 3,500 3,500 0 0.00% 100-46315-000-000 FEES: MACHINERY & EQUIPMENT 9,666 20,952 23,159 59,496 52, 476 15,000 20,000 5,000 33.33% 100-46320-000-000 FEES: OTHER PUBLIC WORKS 0 0 0 1,550 1,550 0 0 0.00% 100-46330-000-000 FEES: PARKING PERMITS 7,280 6,428 8,790 7,990 6,100 5,000 5,000 0 0.00% 100-46420-000-000 FEES: REFUSE BAG TAGS 720 380 140 135 140 0 100 100 0.00% 100-46440-000-000 FEES: WEED CONTROL 0 1,200 270 1,800 1,800 500 500 0 0.00% 100-46540-100-000 FEES: CEMETERY BURIALS 15,080 20,105 15,980 13,600 13,000 15,000 15,000 0 0.00% 100-46540-120-000 FEES: CEMETERY 0 0 1,300 0 0 0 0 0.00% 100-46715-000-000 FEES: PARK BEER PERMITS 619 694 834 775 800 600 600 0 0.00% 100-46720-000-000 FEES: PARK SHELTER HOUSES 9,252 10,718 11,157 9,669 10, 000 10,000 10,000 0 0.00% 100-46725-000-000 FEES: CONCESSIONS SWAN PARK 29,793 36,054 47,912 40,148 23,000 30,000 30,000 0 0.00% 100-46727-000-000 FEES: CONCESSIONS SOUTH PARK 0 0 200 3,171 3,171 0 3,500 3,500 0.00% 100-46745-000-000 FEES: CONCESSIONS REC CENT ER 1,863 3,019 3,536 2,276 3,000 3,000 3,500 500 16.67% 100-46750-100-000 FEES: SENIOR MEMBERSHIP 7,361 9,532 17,831 13,975 15,000 11,000 18,000 7,000 63.64% 100-46750-110-000 FEES: SENIOR TRAVEL 6,498 7,885 9,932 16,533 16,533 8,000 12,000 4,000 50.00% 100-46750-120-000 FEES: SENIOR PROGRAMS 593 1,894 6,739 4,437 4,500 4,500 4,500 0 0.00% 100-46750-150-000 FEES: HISTORICAL CONSERV COMM 351 30 177 00000 # DIV/0! PUBLIC CHARGES FOR SERVICES 133,527 154,196 188,492 214,862 185,247 132,600 160,325 27,725 20.91% INTERGOVERNMENTAL CHARGES FOR SERVICES 100-47220-000-000 INTERGOVT CHRG:SCHOOL LIAISON 127,020 147,264 164,059 92,442 136,354 136,354 143,346 6,992 5.13% 100-47225-000-000 INTERGOVT CHRG:CROSSING GUAR DS 5,908 6,960 7,697 4,734 6,963 6,963 6,963 0 0.00% 100-47230-000-000 INTERGOVT CHRG: FIRE DEPT 4,675 4,982 5,174 20,829 6,000 5,000 111,221 106,221 2124.42% 100-47240-000-000 INTERGOVT CHRG: RECYLING DI ST 7,738 5,223 8,032 8,475 6,000 5,223 5,223 0 0.00% 100-47250-000-000 INTERGOVT CHRG:SCHOOL LIFE GRD & GRANT WRITER 0 0 0 27,005 25,000 40,333 37,892 (2,441) (6.05%) INTERGOVERNMENTAL CHARGES FOR SERVICES 145,341 164,429 184,961 153,486 180, 317 193,873 304,645 110,772 57.14% 11/15/2024 2025 BUDGET WORKSHEET REVENUES FUND Actual Actual Actual Actual 12/31/2024 Budget Budget % 12/31/2021 12/31/2022 12/31/2023 10/31/2024 12/31/2024 Prior Year Prior Year Prior Year Current YTD YTD Amended Request Increase Increase Acct No Account Description 2021 2022 2023 Actual Estimated 2024 2025 (Decrease) (Decrease)5 MISCELLANEOUS REVENUE 100-48101-000-000 INTEREST: INTEREST LEASES 0 0 2,344 0 0 0 #DIV/0! 100-48110-000-000 INTEREST: INTEREST GENERAL 33,643 24,394 357,557 212,700 250,000 75,000 75,000 0 0.00% 100-48114-000-000 INTEREST: TAX SPEC CHRGS 56 0 55 36 36 0 0 0.00% 100-48120-000-000 INTEREST: CEMETERY 0 25 284 0 284 0 0 0.00% 100-48211-000-000 RENT: CITY PROPERTY 7,450 7,450 7,450 0 7,450 3,750 3,750 0 0.00% 100-48214-000-000 RENT: CITY PROPERTY: FIRE 14,105 14,105 13,708 14,105 14,105 14,105 14,105 0 0.00% 100-48220-000-000 RENT: 219 W FULTON 19,200 19,200 22,255 21,530 22,255 25,000 25,000 0 0.00% 100-48225-000-000 RENT: WATER PAYMENT TO PUBLIC WORKS FACILITY 0 0 0 0 25,000 25,000 50,000 25,000 100.00% 100-48230-000-000 RENT: 415 SCHOOL ST 0 0 0 0 0 0 0.00% 100-48250-000-000 RENT: REC CENTER 8,593 14, 884 14,877 20,202 20,202 15,000 15,000 0 0.00% 100-48260-000-000 RENT: UTILITY & STORAGE 33,000 33,000 33,000 0 36,000 36,000 36,000 0 0.00% 100-48405-000-000 INSURANCE DIVIDENDS 14,311 11,034 8,941 6,354 6,400 10,000 7,500 (2,500) (25.00%) 100-48420-000-000 INSURANCE CLAIMS POLICE 0 0 10,936 18,145 18,145 0 0 0 0.00% 100-48425-000-000 INSURANCE CLAIMS POLICE WC 0 0 12,219 0 0 0 0.00% 100-48430-000-000 INSURANCE CLAIMS STREET S 2,000 6,248 2,084 19,423 19,423 0 0 0 0.00% 100-48450-000-000 INSURANCE CLAIMS PARKS & REC 0 1,094 0 00000 0 .00% 100-48150-000-000 REBATES 0 20,931 22,013 14,633 20,000 23,000 20,000 (3,000) (13.04%) 100-48900-000-000 OTHER: REVENUE MISCELLANEOUS 3,794 538 15,786 14,982 14,982 10,000 26,000 16,000 160.00% MISCELLANEOUS REVENUE 136,151 152,902 523,508 342,387 454,283 236, 855 272,355 35,500 14.99% OTHER SOURCES (USES) 100-49920-100-000 TRANSFER IN: HOTEL/MOTEL TAX FU ND 72,323 77,589 76,233 44,701 75,500 75,500 75,500 0 0.00% 100-49964-000-000 TRANSFER IN: TIF DISTRICTS 111,151 156,417 55,509 0 70,000 70,000 85,000 15,000 21.43% 100-49965-000-000 TRANSFER IN: WATER UTILITY 216,500 216,500 216,500 216,500 200,000 216,500 216,500 0 0.00% 100-49966-000-000 TRANSFER IN: SEWER UTILITY 215,000 215,000 215,000 215,000 200,000 215,000 215,000 0 0.00% 100-49967-000-000 TRANSFER IN: WAUPACA ONLINE 15,000 15,000 15,000 15,000 15,000 15,000 15,000 0 0.00% OTHER SOURCES (USES) 629,974 680,506 578,242 491,201 560,500 592, 000 607,000 15,000 2.53% TOTAL GENERAL FUND REVENUES 6,989,184 7,001,658 7,794,759 7,378,885 8, 586,716 8,168,280 8, 603,312 435,032 5.33% 11/15/2024 OTHER FUNDS 2025 BUDGET WORKSHEET ROOM TAX FUND Actual Actual Actual 12/31/2024 Budget Budget Increase Increase Prior Year Prior Year Prior Year Current YTD YTD Amended Request (Decrease) (Decrease) Account Description 2021 2022 2023 Actual Estimated 2024 2025 Budget % TAXES 327,260 381,618 318,993 179,237 275,880 275,500 275,500 - 0.00% - TOTAL REVENUES 327,260 381,618 318,993 179,237 275,880 275,500 275,500 - 0.00% - HOTEL/MOTEL TAX 322,365 244,513 314,217 78,586 200,000 200,000 200,000 - 0.00% TRANSFERS TO OTHER FUNDS 72,323 77,589 76,233 44,701 75,550 75,500 75,500 - 0.00% - TOTAL EXPENDITURES 394,688 322,102 390,450 123,287 275,550 275,500 275,500 - 0.00% EXCESS REVENUES OVER (UNDER) EXPENDITURES (67,429) 59,517 (71,457) 55,949 330 - - BEGINNING FUND BALANCE 102,082 34,654 94,170 22,713 94,170 94,170 94,499 ENDING FUND BALANCE 34,654 94,170 22,713 78,662 94,499 94,170 94,499 10/9/2024 ROOM TAX SUMMARY 2025 BUDGET WORKSHEET AIRPORT FUND Actual Actual Actual 12/31/2024 Budget Budget Increase Increase Prior Year Prior Year Prior Year Current YTD YTD Amended Request (Decrease) (Decrease) Account Description 2021 2022 2023 Actual Estimated 2024 2025 Budget % REVENUES INTERGOVERNMENTAL 75,000 - - - TAXES 83,250 - 60,000 60,000 60,000 60,000 50,000 (10,000) (16.67%) PUBLIC CHARGES FOR SERVICES 126,189 188,556 252,731 209,824 240,800 203,950 246,000 42,050 20.62% MISCELLANEOUS 27,670 32,84 9 41,521 27,32 6 29,47 6 26,00 0 31,00 0 5,00 0 19.23% TOTAL REVENUES 237,109 296,405 354,252 297,150 330,276 289,950 327,000 37,050 12.78% EXPENDITURES MUNICIPAL AIRPORT 245,373 284,16 2 351,12 3 268,06 3 328,84 6 289,95 0 327,45 0 37,50 0 12.93% TOTAL EXPENDITURES 245,373 284,162 351,123 268,063 328,846 289,950 327,450 37,500 12.93% REVENUES OVER (UNDER) EXPENDITURES (8,264) 12,243 3,129 29,087 1,430 - (450) BEGINNING FUND BALANCE - (8,264) 3,979 7,109 7,109 7,109 8,539 ENDING FUND BALANCE (8,264) 3,979 7,109 36,196 8,539 7,109 8,089 10/8/2024 AIRPORT FUND SUMMARY 2025 BUDGET WORKSHEET TRANSIT FUND Actual Actual Actual 12/31/2024 Budget Budget Increase Increase Prior Year Prior Year Prior Year Current YTD YTD Current Request (Decrease) (Decrease) Account Description 2021 2022 2023 Actual Estimated 2024 2025 Budget % TAXES 10,000 10,000 10,000 10,000 10,000 10,000 10,000 - 0.00% INTERGOVERNMENTAL REVENUES 328,319 304,259 382,606 125,324 371,691 371,905 375,524 3,619 0.97% MISCELLANEOUS REVENUES 191,749 230,331 197,991 107,973 163,000 184,582 213,000 28,418 15.40% TOTAL REVENUES 530,068 544,590 590,597 243,297 544,691 566,487 598,524 32,037 5.66% - TRANSIT 516,533 532,744 574,833 391,968 582,000 582,300 623,300 41,000 7.04% TOTAL EXPENDITURES 516,533 532,744 574,833 391,968 582,000 582,300 623,300 41,000 7.04% REVENUES OVER (UNDER) EXPENDITURES 13,535 11,846 15,764 (148,670) (37,309) (15,813) (24,776) BEGINNING FUND BALANCE - 13,535 25,381 - 41,146 41,146 3,837 ENDING FUND BALANCE 13,535 25,381 41,146 - 3,837 25,333 (20,939) 10/7/2024 TRANSIT FUND SUMMARY 2025 BUDGET WORKSHEET REFUSE/RECYCLING FUND Actual Actual 12/31/2024 Budget Budget Increase Increase Prior Year Prior Year Current YTD YTD Current Request (Decrease) (Decrease) Account Description 2022 2023 Actual Estimated 2024 2025 Budget % - PUBLIC CHARGES FOR SERVICES 295,288 308,545 243,785 287,040 287,040 325,000 OTHER FINANCING SOURCES 918 1,310 844 - - TOTAL REVENUES 296,207 309,855 244,629 287,040 287,040 325,000 37,960 - SANITATION 302,858 298,778 243,575 288,462 287,040 325,000 37,960 TOTAL EXPENDITURES 302,858 298,778 243,575 288,462 287,040 325,000 37,960 - REVENUES OVER (UNDER) EXPENDITURES (6,651) 11,077 1,054 (1,422) - - BEGINNING FUND BALANCE - (6,651) 4,426 4,426 3,004 ENDING FUND BALANCE (6,651) 4,426 3,004 4,426 3,004 10/7/2024 REFUSE FUND SUMMARY 2025 BUDGET WORKSHEET LIBRARY FUND Actual Actual Actual 12/31/2024 Budget Budget Increase Increase Prior Year Prior Year Prior Year Current YTD YTD Current Request (Decrease) (Decrease) Account Description 2021 2022 2023 Actual Estimated 2024 2025 Budget % REVENUES INTERGOVERNMENTAL 405,999 394,166 424,712 407,934 408,915 407,934 425,547 17,613 4.32% PUBLIC CHARGES FOR SERVICE 7,498 8,961 8,809 11,853 14,439 14,100 16,100 2,000 14.18% MISCELLANEOUS 383,183 388,195 431,366 383,836 430,516 430,622 436,135 5,513 1.28% TOTAL REVENUES 796,680 791,322 864,887 803,623 853,870 852,656 877,782 25,126 2.95% EXPENDITURES LIBRARY FULL-TIME 466,234 483,522 529,670 386,535 521,570 552,383 605,727 53,344 9.66% LIBRARY: PART-TIME 134,625 134,032 113,264 95,859 132,467 137,682 120,081 (17,601) (12.78%) LIBRARY: OPERATING EXPENSES 67,525 71,700 64,081 53,341 69,714 67,885 61,809 (6,076) (8.95%) LIBRARY: DONATION EXPENSES 37,602 37,049 78,986 32,467 61,500 61,500 61,500 - 0.00% LIBRARY: PROGRAMS 5,693 5,433 5,574 2,368 5,500 5,500 5,500 - 0.00% LIBRARY: BOOKS 46,738 41,926 44,548 25,225 43,947 43,925 43,775 (150) (0.34%) LIBRARY: A/V 17,221 15,952 15,560 14,167 16,439 16,439 19,089 2,650 16.12% TOTAL EXPENDITURES 775,638 789,615 851,683 609,962 851,137 885,314 917,481 32,167 3.63% REVENUES OVER(UNDER) EXPENDITURES 21,042 1,707 13,204 193,661 2,733 (32,658) (39,699) BEGINNING FUND BALANCE 28,321 45,657 44,531 57,735 57,735 60,468 ENDING FUND BALANCE 49,363 44,531 57,735 60,468 20,769 11/6/2024 LIBRARY FUND SUMMARY 2025 BUDGET WORKSHEET ADULT RECREATION PROGRAM FUND Actual Actual Actual 12/31/2024 Budget Budget Increase Increase Prior Year Prior Year Prior Year Current YTD YTD Current Request (Decrease) (Decrease) Account Description 2021 2022 2023 Actual Estimated 2024 2025 Budget % PUBLIC CHARGES FOR SERVICES 10,874 15,591 19,838 23,573 29,889 19,875 29,875 10,000 50.31% MISCELLANEOUS REVENUE - - - 1 - - - - 0.00% TOTAL REVENUES 10,874 15,591 19,838 23,574 29,889 19,875 29,875 10,000 50.31% ADULT VOLLEYBALL 2,649 4,760 4,530 2,940 4,777 6,200 6,200 - 0.00% ADULT BASKETBALL 1,069 4,774 3,801 3,552 4,837 3,977 5,477 1,500 37.72% ADULT SOFTBALL 6,001 7,590 3,600 4,022 7,724 7,000 7,000 - 0.00% ADULT KICKBALL 31 - 143 3,179 3,206 200 200 - 0.00% ADULT TENNIS/OTHER 604 - - - - - - CAPITAL OUTLAY PARKS: SWAN PARK - - - - - - - - 100.00% TRANSFERS OUT: GENERAL FUND - - - - 2,800 2,800 2,800 - 100.00% ADULT PROGRAMS 10,354 17,124 12,074 13,693 23,344 20,177 21,677 1,500 7.43% TOTAL EXPENDITURES 10,354 17,124 12,074 13,693 23,344 20,177 21,677 1,500 7.43% REVENUES OVER (UNDER) EXPENDITURES 520 (1,533) 7,764 9,881 6,545 (302) 8,198 BEGINNING FUND BALANCE 27,418 27,938 26,456 34,220 34,220 34,220 33,918 ENDING FUND BALANCE 27,938 26,456 34,220 40,765 33,918 42,116 10/8/2024 ADULT REC PROG SUMMARY 2025 BUDGET WORKSHEET YOUTH PROGRAM FUND Actual Actual Actual 12/31/2024 Budget Budget Increase Increase Prior Year Prior Year Prior Year Current YTD YTD Amended Request (Decrease) (Decrease) Account Description 2021 2022 2023 Actual Estimated 2024 2025 Budget % REVENUES TAXES 85,861 102,323 101,698 101,698 101,698 101,698 130,659 28,961 28.48% INTERGOVERNMENTAL CHARGES FOR SERVICE 115,844 130,405 133,423 97,840 131,139 131,139 132,751 1,612 1.23% PUBLIC CHARGES FOR SERVICES 69,459 65,642 78,668 73,441 73,581 71,500 85,000 13,500 18.88% MISCELLANEOUS - - 4,467 - - - - - 0.00% TOTAL REVENUES 271,164 298,370 318,255 272,979 306,418 304,337 348,410 44,073 14.48% EXPENDITURES YOUTH PROGRAMS 73,216 124,407 95,246 101,176 104,680 95,220 104,898 9,678 10.16% YOUTH CENTER 54,299 50,880 53,367 37,433 52,517 60,623 59,064 (1,560) (2.57%) RECREATION ADMINISTRATION 91,849 80,906 112,794 59,488 93,998 90,912 119,136 28,224 31.05% BEACHES 17,543 11,735 31,186 8,524 17,000 20,383 20,383 - 0.00% PARKS 34,56 9 32,77 4 43,73 9 33,41 7 38,90 0 37,20 0 44,93 0 7,73 0 20.78% TOTAL EXPENDITURES 271,477 300,701 336,331 240,038 307,096 304,338 348,410 44,072 14.48% REVENUES OVER (UNDER) EXPENDITURES (677) (20,041) (18,075) 32,940 (677) (1) (0) BEGINNING FUND BALANCE 38,164 37,487 17,446 (629) (629) - - ENDING FUND BALANCE 37,487 17,446 (629) - (1,306) (1) (0) 10/9/2024 YOUTH PROG FUND SUMMARY 2025 BUDGET WORKSHEET INLAND LAKES FUND Actual Actual Actual 12/31/2024 Budget Budget Increase Increase Prior Year Prior Year Prior Year Current YTD YTD Current Request (Decrease) (Decrease) Account Description 2021 2022 2023 Actual Estimated 2024 2025 Budget % TAXES 10,000 10,000 10,194 10,000 10,000 10,000 10,000 - 0.00% INTERGOVERNMENTAL REVENUES - - 15,412 - - - - - 0.00% MISCELLANEOUS REVENUES 25 (147) - - - - - - 0.00% TOTAL REVENUES 10,025 9,853 25,606 10,000 10,000 10,000 10,000 - 0.00% INLAND LAKES 11,687 7,286 4,831 4,428 10,200 10,200 10,000 (200) (1.96%) TOTAL EXPENDITURES 11,687 7,286 4,831 4,428 10,200 10,200 10,000 (200) (1.96%) REVENUES OVER (UNDER) EXPENDITURES (1,662) 2,566 20,775 5,572 (200) (200) - BEGINNING FUND BALANCE 14,265 12,603 15,169 35,944 35,944 35,944 35,744 ENDING FUND BALANCE 12,603 15,169 35,944 41,516 35,744 35,744 35,744 10/7/2024 INLAND LAKES FUND SUMMARY GENERAL OBLIGATION DEBT 2024 BUDGET WORKSHEET DEBT SERVICE FUND Actual Actual Actual Actual Budget Budget Budget Budget Budget Budget Budget Budget Budget 12/31/2021 12/31/2022 12/31/2023 10/31/2024 Prior Year Prior Year Prior Year Actual Request Request Request Request Request Request Request Request Request Acct No Account Description 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 REVENUES 300-49210-000-000 TRANSFER IN: GEN FUND 1,070,034 1,051,569 1,165,500 1,662,122 1,691,209 1,720,805 1,750,919 1,781,560 1,812,738 1,844,461 1,876,739 1,909,582 1,942,999 300-49220-000-000 TRANSFER IN: TIF #3 - 838,493 - 300-49215-000-000 TRANSFER IN: TIF #6 320,639 320,000 - 300-49230-000-000 TRANSFER IN: TIF #8 - - 232,817 232,293 241,290 250,558 245,104 229,936 119,815 95,733 300-49235-000-000 TRANSFER IN: TIF #10 - - - - 300-49211-000-000 DEBT ISSUANCE 103,903 300-49212-000-000 DEBT ISSUANCE - PREMIUM TOTAL REVENUES 1,390,673 2,313,965 1,165,500 1,662,122 1,691,209 1,953,622 1,983,212 2,022,850 2,063,296 2,089,565 2,106,675 2,029,397 2,038,732 EXPENDITURES 300-58100-400-111 PRINCIPAL: SUB 99 GO 2011 - - 300-58100-410-116 PRINCIPAL: CAPITAL 2016A-2016B 93,752 96,565 - - - 300-58100-410-117 PRINCIPAL: CAPITAL 2017 153,082 157,675 - - - 300-58100-400-118 PRINCIPAL: GO 2018 585,000 300,000 570,000 470,000 485,000 300-58100-400-119 PRINCIPAL: GO 2019 130,000 135,000 140,000 145,000 150,000 155,000 160,000 165,000 170,000 300-58100-400-120 PRINCIPAL: GO 2020 70,000 365,000 405,000 260,000 180,000 515,000 535,000 545,000 555,000 570,000 300-58100-400-121 PRINCIPAL: GO 2022A (PW Gargage) - 25,000 25,000 2 5,000 25,000 25,000 25,000 25,000 100,000 100,000 100,000 100,000 300-58100-400-122 PRINCIPAL: GO 2022B - 310,000 165,000 175,000 175,000 180,000 260,000 230,000 300-58100-400-123 PRINCIPAL: GO 2023 - - 175,000 110,000 110,000 115,000 120,000 125,000 125,000 135,000 140,000 145,000 300-58100-400-124 PRINCIPAL: GO 2024 - - - 225,000 75,000 75,000 75,000 75,000 75,000 100,000 105,000 110,000 300-58100-400-128 PRINCIPAL: GO 2025A (PW NAN) - - 10,000 10,000 10,000 15,000 15,000 200,000 210,000 220,000 300-58100-400-125 PRINCIPAL: GO 2025 & 2026 - - 120,000 280,000 150,000 155,000 150,000 210,000 220,000 225,000 300-58100-400-127 PRINCIPAL: GO 2027 & 2028 270,000 405,000 420,000 435,000 455,000 PRINCIPAL: GO 2029 & 2030 120,000 485,000 150,000 160,000 PRINCIPAL: GO 2031 & 2032 245,000 295,000 PRINCIPAL: GO 2033 & 2034 300-58100-440-118 PRINCIPAL: LINE OF CREDIT FSB - - - - PRINCIPAL 1,031,834 1,054,240 1,450,000 1,240,000 1,350,000 1,185,000 1,380,000 1,350,000 1,620,000 1,560,000 1,650,000 1, 605,000 1,710,000 300-58200-400-111 INTEREST: SUB 99 GO 2011 - - - 300-58200-410-116 INTEREST: CAPITAL 2016A-2016B 5,710 2,897 300-58200-410-117 INTEREST: CAPITAL 2017 9,323 4,730 300-58200-400-118 INTEREST: GO 2018 63,525 27,375 37,200 21,600 7,275 300-58200-400-119 INTEREST: GO 2019 44,250 39,600 34,100 28,400 22,500 17,175 12,450 7,575 2,550 300-58200-400-120 INTEREST: GO 2020 78,721 95,725 83,879 74,200 67,600 57,175 41,425 27,950 16,950 5,700 300-58200-400-121 INTEREST: GO 2022A - 287,413 203,625 202,875 202,125 201,375 200,500 199,500 197,000 193,500 190,500 187,500 300-58200-400-122 INTEREST: GO 2022B - 65,276 37,975 32,875 27,625 22,300 14,400 4,600 300-58200-400-123 INTEREST: GO 2023 - - 62,194 38,100 34,250 30,875 27,350 23,675 19,300 14,100 8,600 2,900 300-58200-400-124 INTEREST: GO 2024 - 61,721 35,075 31,325 27,575 23,825 20,075 15,700 11,100 6,800 300-58200-400-127 INTEREST: GO 2025A (PW NAN) 125,044 87,750 87,300 86,738 86,063 81,225 72,000 62,305 300-58200-400-125 INTEREST: GO 2025 & 2026 124,800 78,300 68,625 61,763 5 4,900 46,800 37,125 27,133 300-58200-400-128 INTEREST: GO 2027 & 2028 226,667 154,600 141,100 124,600 107,500 89,700 INTEREST: GO 2029 & 2030 110,933 65,500 52,800 46,600 INTEREST: GO 2031 & 2032 108,433 64,300 INTEREST: GO 2033 & 2034 300-58210-210-000 DEBT SERVICING: MISC 865 192,746 1,340 - - 300-49212-000-000 DEBT ISSUANCE - PREMIUM (5,873) (50,099) INTEREST 202,394 363,073 509,208 427,994 432,946 623,269 505,800 687,942 574,201 635,071 541,425 588,058 487,238 TOTAL EXPENDITURES 1,234,228 1,417,313 1,959,208 1,662,122 1,732,847 1,808,269 1,885,800 2,037,942 2,194,200 2,195,071 2,191,425 2,193,058 2,197,238 EXCESS REVENUES OVER (UNDER) EXPENDITURES 156,445 896,652 (793,708) (0) (41,638) 145,353 97,412 (15,092) (130,904) (105,506) (84,750) (163,661) (158,506) BEGINNING FUND BALANCE 441,473 597,918 1,567,367 773,660 773,660 732,022 877,375 974,787 959,695 828,791 723,285 638,535 474,874 ENDING FUND BALANCE 597,918 1,567,367 773,660 773,660 732,022 877,375 974,787 959,695 828,791 723,285 638,535 474,874 316,368 10/9/2024 DEBT SERVICE (PAYOFF) (PW NAN) City of Waupaca 2025 Financing Discussion November 6, 2024 Page | 2 Hypothetical General Obligation Debt Capacity Based on 3.75% of Equalized Valuation (Statutory Limit is 5% of Equalized Valuation) $0 $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 $30,000,000 $35,000,000 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 $9,513,120 $7,762,217 $9,316,775 $7,071,877 $8,802,605 $8,809,044 $10,761,280 $10,809,399 $12,818,490 $12,938,642 $15,019,947 $15,207,496 $17,351,383 $17,596,704 $19,793,555 $20,092,033 $22,352,238 $22,719,272 $25,048,236 $24,794,235 $26,482,373 $26,257,759 61% 68% 63% 72% 66% 66% 59% 60% 53% 53% 47% 47% 40% 40% 34% 34% 27% 27% 21% 23% 19% 21% Outstanding as of December 31 Existing Principal Outstanding 2025 G.O. Promissory Notes Hypothetical Future CIP Remaining Debt Capacity Notes: Future capacity based on the 2024 Equalized Valuation (TID-IN) of $647,283,200 with annual growth of 1.50% each year. Hypothetical Future CIP assumes $4,000,000 borrowing in 2027 and then $2,000,000 borrowings every-other-year thereafter amortized over 10 years at planning interest rates of 4.00%. Rates are subject to change. UTILITIES 2025 BUDGET WORKSHEET WATER UTILITY FUND Actual Actual Actual 12/31/2024 Budget Budget Increase Increase Prior Year Prior Year Prior Year Current YTD YTD Current Request (Decrease) (Decrease) Account Description 2021 2022 2023 Actual Estimated 2024 2025 Budget % REVENUES WATER SALES REVENUES 1,276,786 1,265,194 1,329,691 957,515 1,389,385 1,490,087 1,549,998 59,911 4.02% MISCELLANEOUS REVENUE 62,943 333,340 82,818 334,292 367,323 357,000 1,071,50 0 714,500 200.14% TOTAL REVENUES 1,339,729 1,598,534 1,412,509 1,291,806 1,756,708 1,847,087 2,621,498 774,411 41.93% EXPENDITURES DEPRECIATION & TAXES 434,240 414,069 402,887 201,289 450,000 450,000 405,000 (45,000) (10.00%) MAINTENANCE-WELLHEADS & WELLS 9,364 - 209 - 395 11,074 7,074 (4,000) (36.12%) MAINTENANCE-SUPPLY 13,543 13,072 33,675 25,361 30,932 20,085 39,455 19,370 96.44% FUEL FOR POWER 107,728 104,726 101,370 76,254 102,000 102,500 102,500 - 0.00% PUMPING 2,966 13,598 14,318 9,927 11,372 11,373 11,857 484 4.25% MAINTENANCE OPERATIONS MISCELLANEOUS 25,575 27,374 55,277 49,550 55,825 40,905 68,193 27,288 66.71% MAINTENANCE-STRUCTURES 9,952 13,168 20,866 6,359 9,647 10,922 79,258 68,336 625.67% MAINTENANCE-POWER PROD 5,580 454 2,874 160 1,000 1,000 1,000 - 0.00% MAINTENANCE-PUMPING EQUIPMENT 4,233 4,012 4,988 5,494 7,762 7,836 8,140 304 3.88% CHEMICALS 18,475 15,804 13,236 9,976 15,000 20,000 18,000 (2,000) (10.00%) LABOR EXPENSE 13,762 9,722 3,662 2,519 3,700 3,637 3,859 222 6.10% MAINTENANCE-WATER TREATMENT 4,336 10,621 19,143 14,560 19,630 23,052 20,766 (2,286) (9.92%) OPERATIONS-STORAGE FACILITY 25,850 12,348 3,117 848 2,503 10,771 8,311 (2,460) (22.84%) OPERATIONS-METER EXPENSE 118,503 132,795 113,216 38,046 115,250 120,412 118,611 (1,801) (1.50%) CUSTOMER INSTALLATION 3,393 4,428 5,849 5,425 5,606 4,848 5,075 227 4.68% OPERATIONS-MISCELLANEOUS 18,635 20,469 6,810 7,632 11,086 13,550 14,050 500 3.69% TRANSMISSION & DISTRIBUTION 44,811 48,853 39,132 73,783 77,782 58,937 49,241 (9,696) (16.45%) MAINTENANCE-SERVICES 62,185 60,393 75,245 43,177 66,325 62,300 54,029 (8,271) (13.28%) MAINTENANCE-HYDRANTS 26,176 12,299 14,395 6,359 10,355 25,039 20,704 (4,335) (17.31%) METER READING 3,279 2,162 361 219 1,175 6,017 2,303 (3,714) (61.72%) RECORDS & COLLECTION 100,947 101,493 48,868 26,204 125,855 117,478 156,198 38,720 32.96% ADMINSTRATION & GENERAL 167,356 134,758 133,847 56,110 151,635 151,721 158,372 6,651 4.38% OFFICE SUPPLIES & EXPENSE 1,806 3,344 1,671 1,416 2,500 3,350 3,350 - 0.00% OUTSIDE SERVICES 14,532 12,085 15,012 14,075 15,000 15,000 15,000 - 0.00% PROPERTY INSURANCE & INJURY - DAMAGES 13,047 13,049 13,239 13,304 13,300 13,300 13,300 - 0.00% FRINGE BENEFITS 58,427 61,009 71,660 48,032 65,646 69,401 70,822 1,421 2.05% MISCELLANEOUS GENERAL EXPENSES 39,056 35,622 54,222 41,498 45,369 47,320 46,747 (573) (1.21%) TRANSPORTATION EXPENSES 10,274 21,115 11,438 6,488 11,500 9,500 9,500 - 0.00% CAPITAL OUTLAY - 15,880 19,296 127,474 245,400 355,000 496,000 141,000 39.72% DEBT SERVICE - LONG TERM DEBT 66,208 57,290 57,884 21,680 78,639 60,535 58,427 (2,108) (3.48%) TOTAL EXPENDITURES 1,424,240 1,376,011 1,357,764 933,220 1,752,189 1,846,863 2,065,143 218,280 11.82% NET INCOME (84,512) 222,523 54,745 358,586 4,519 225 556,355 9/26/2024 FUND 610 WATER-SUMMARY City of Waupaca 2025 Financing Discussion November 6, 2024 Page | 4 Water Utility Coverage Analysis EXISTING DEBT WAT ER SERVICE YEAR DEBT COVERAGE (A) YEAR DUE SERVICE (2023 Net Revenues) DUE 2024 $461,166 1.12 2024 2025 $273,000 1.90 2025 2026 $271,834 1.91 2026 2027 $270,468 1.92 2027 2028 $273,575 1.90 2028 2029 $133,954 3.87 2029 2030 $132,033 3.93 2030 2031 $11,072 46.84 2031 2032 $11,071 46.84 2032 $1,838,172 2023 Audit Operating Revenues & Investment Income $1,412,510 Less: Operation and Maintenance Expenses ($893,908) 2023 Net Revenues Available for Debt Service: $518,602 (A) City Covenants require coverage of at least 1.10x annual debt service. 2025 BUDGET WORKSHEET SEWER UTILITY FUND Actual Actual Actual Actual 12/31/2024 Budget Budget Increase Increase Prior Year Prior Year Prior Year Current YTD YTD Current Request (Decrease) (Decrease) Account Descriptio 2021 2022 2023 Actual Estimated 2024 2025 Budget % REVENUES CUSTOMER SERVICE REVENUES 2,201,047 2,177,855 2,149,701 1,406,349 2,095,800 2,084,800 2,167,304 82,504 3.96% MISC REVENUES 72,512 77,918 158,526 177,186 1,701,595 1,646,395 1,367,395 (279,000) (16.95%) TOTAL REVENUES 2,273,559 2,255,773 2,308,227 1,583,534 3,797,395 3,731,195 3,534,699 (196,496) (5.27%) EXPENSES OPERATION PLANT 132,277 156,023 186,251 152,480 183,952 182,452 208,438 25,986 14.24% PROCESS CONTROL 64,039 65,544 69,476 44,825 129,466 75,490 78,638 3,148 4.17% SLUDGE DISPOSAL 53,776 80,138 64,440 27,832 63,200 63,250 65,250 2,000 3.16% COLLECTION SYSTEM 5,388 2,988 2,989 2,990 6,500 6,500 6,500 - 0.00% LIFT STATIONS 26,322 26,458 28,701 20,688 28,936 31,920 31,920 - 0.00% TRANSPORATION EQUIPMENT 5,625 9,854 8,767 4,899 7,000 8,640 10,640 2,000 23.15% MAINTENANCE OF BLDG & GROUNDS 25,649 30,939 17,983 12,384 26,374 26,119 27,002 883 3.38% MAINTENANCE OF PLANT EQUIPMENT 116,851 119,826 121,418 94,159 122,192 122,610 128,232 5,622 4.59% MAINTENANCE OF COLLECTION SYSTEM 88,414 77,409 38,539 35,757 46,170 52,684 53,084 400 0.76% MAINTENANCE OF LIFT STATIONS 44,380 36,384 50,428 20,008 39,158 39,158 42,937 3,779 9.65% MAINTENANCE OF METERS 53,253 56,921 35,104 13,874 28,905 29,969 30,806 837 2.79% ACCOUNTING & COLLECTION 116,298 125,809 144,577 56,008 144,812 142,762 146,680 3,918 2.74% METER READING 3,181 2,162 365 219 705 1,228 1,316 88 7.18% GENERAL SUPERVISION & ENGINEERING 180,059 135,204 131,593 29,125 116,453 114,084 117,510 3,426 3.00% TAXES 250,008 255,841 256,101 - 250,000 250,000 256,000 6,000 2.40% PROP & LIAB: INS & BOND 34,960 34,966 35,510 35,695 35,700 34,960 36,000 1,040 2.97% OTHER GENERAL EXPENSE 34,345 20,225 23,553 26,575 13,701 27,101 27,410 309 1.14% FRINGE BENEFITS 43,813 50,968 60,447 44,197 52,203 47,330 49,141 1,811 3.83% DEPRECIATION 715,654 729,941 739,670 528,619 705,000 705,000 740,000 35,000 4.96% DEBT SERVICE COSTS 88,249 73,285 137,870 112,270 140,902 75,402 75,402 - 0.00% SEWER CAPITAL OUTLAY 7,473 374 245,824 616,716 1,550,374 1,697,541 1,261,000 (436,541) (25.72%) TOTAL SEWER FUND EXPENSES 2,090,016 2,091,259 2,399,606 1,879,323 3,691,703 3,734,200 3,393,908 (340,292) (9.11%) NET REVENUES OVER(UNDER) EXPENSES 183,543 164,514 (91,379) (295,788) 105,692 (3,005) 140,791 9/26/2024 FUND 620-SEWER UTILITY SUMMARY City of Waupaca 2025 Financing Discussion November 6, 2024 Page | 3 Sewer System Long-Term Capital Improvement Plan (Revenue Bonds) * SEWER UTILITY SUPPORTED SEWER UTILITY SUPPORTED * 202 5 + 2026 Projects: $3,593,800 2027 + 2028 Projects: $1,115,000 * $3,995,000 $1,140,000 * SEWERAGE SYSTEM REVENUE BONDS, SERIES 2025 SEWERAGE SYSTEM REVENUE BONDS, SERIES 2027 EXIS TING * Dated: April 1, 2025 Dated: April 1, 2027 COMBINED DEBT SEWER * (First Interest: November 1, 2025) (First Interest: November 1, 2027) SEWER SERVICE LEVY YEAR DEBT * PRINCIPAL INTEREST TOTAL PRINCIPAL INTEREST TOTAL DEBT COVERAGE (B) YEAR YEAR DUE SERV ICE * (5/1) (5/1 & 11/1) (5/1) (5/1 & 11/1) SERVICE (2023 Net Revenues) DUE (A) * AVG= AVG= * 4.75% 4.75% * 2023 2024 $683,470 * $683,470 1.75 2024 2024 2025 $515,880 * $110,695 $110,695 $626,575 1.90 2025 2025 2026 $521,904 * $190,000 $185,250 $375,250 $897,154 1.33 2026 2026 2027 $513,001 * $195,000 $176,106 $371,106 $31,588 $31,588 $915,695 1.30 2027 2027 2028 $515,484 * $205,000 $166,606 $371,606 $55,000 $52,844 $107,844 $994,934 1.20 2028 2028 2029 $516,650 * $215,000 $156,631 $371,631 $55,000 $50,231 $105,231 $993,513 1.20 2029 2029 2030 $517,575 * $225,000 $146,181 $371,181 $60,000 $47,500 $107,500 $996,256 1.20 2030 2030 2031 $285,300 * $240,000 $135,138 $375,138 $60,000 $44,650 $104,650 $765,088 1.56 2031 2031 2032 $285,400 * $250,000 $123,500 $373,500 $65,000 $41,681 $106,681 $765,581 1.56 2032 2032 2033 $285,600 * $260,000 $111,388 $371,388 $65,000 $38,594 $103,594 $760,581 1.57 2033 2033 2034 $143,300 * $275,000 $98,681 $373,681 $70,000 $35,388 $105,388 $622,369 1.92 2034 2034 2035 $143,600 * $285,000 $85,381 $370,381 $75,000 $31,944 $106,944 $620,925 1.92 2035 2035 2036 $143,700 * $300,000 $71,488 $371,488 $80,000 $28,263 $108,263 $623,450 1.91 2036 2036 2037 $143,600 * $315,000 $56,881 $371,881 $80,000 $24,463 $104,463 $619,944 1.93 2037 2037 2038 $143,300 * $330,000 $41,563 $371,563 $85,000 $20,544 $105,544 $620,406 1.92 2038 2038 2039 $142,800 * $345,000 $25,531 $370,531 $90,000 $16,388 $106,388 $619,719 1.93 2039 2039 2040 * $365,000 $8,669 $373,669 $95,000 $11,994 $106,994 $480,663 2.48 2040 2040 2041 * $100,000 $7,363 $107,363 $107,363 11.12 2041 2041 2042 * $105,000 $2,494 $107,494 $107,494 11.10 2042 * $5,500,565 * $3,995,000 $1,699,689 $5,694,689 $1,140,000 $485,925 $1,625,925 $12,821,178 (A) Net of bid premium of $40,811 from the 2024 Sewerage System Revenue Bonds. 2023 Audit (B) City Covenants require coverage of at least 1.10x annual debt service. Operating Revenues $2,231,832 (C) Net of depreciation, debt service, tax equivalents, and capital expenditures. Less: Operating Expenses (C) ($1,038,402) 2023 Net Revenues Available for Debt Service: $1,193,430 2025 BUDGET WORKSHEET FUND 650 WAUPACA ONLINE UTILITY Actual Actual Actual 12/31/2024 Budget Budget Increase Increase Prior Year Prior Year Prior Year Current YTD YTD Current Request (Decrease) (Decrease) Account Description 2021 2022 2023 Actual Estimated 2024 2025 Budget % REVENUES SERVICE REVENUES 235,674 275,592 309,357 214,852 361,035 288,800 311,200 22,400 7.76% MISCELLANEOUS 12,774 7,260 21,784 17,481 12,060 2,952 2,952 - 0.00% TOTAL REVENUES 248,448 282,852 331,142 232,333 373,095 291,752 314,152 22,400 7.68% EXPENSES OPERATION EXPENSE 93,261 88,419 108,978 90,534 112,750 133,149 134,149 1,000 0.75% ADMINISTRATION EXPENSE 41,962 47,918 53,898 30,162 68,944 55,330 59,097 3,767 6.81% SUPPLIES & SERVICES 69,178 105,522 97,476 80,008 85,410 90,828 100,280 9,452 10.41% GRANT EXPENSES - - 13,568 - 13,568 - - - 0.00% TOTAL EXPENSES 204,402 241,859 273,919 200,704 280,672 279,307 293,526 14,219 5.09% NET REVENUES 51,098 46,221 53,604 31,628 92,423 12,445 20,626 8,181 9/26/2024 FUND 650 ONLINE SUMMARY TAX INCREMENTAL DISTRICTS 2025 BUDGET WORKSHEET TIF DISTRICTS TIF #4 FUND Actual Actual Actual Current Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget 12/31/2021 12/31/2022 12/31/2023 12/31/2024 12/31/2024 12/31/2024 Prior Year Prior Year Prior Year Year YTD Amended Request Projection Projection Projection Projection Projection Projection Projection Projec tion Projection Projection Acct No Account Description 2021 2022 2023 Column1 Estimated 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 REVENUES 404-41111-000-000 GENERAL PROPERTY TAXES 693,753 680,569 666,830 741,695 791,486 791,486 689,895 697,284 704,746 712,282 719,894 727,583 735,348 743,190 751,111 759,112 767,192 TAXES 693,753 680,569 666,830 741,695 791,486 791,486 689,895 697,284 704,746 712,282 719,894 727,583 735,348 743,190 751,111 759,112 767,192 404-41490-000-000 COMPUTER AID 1,698 5,882 5,882 5,882 5,882 INTERGOVERNMENTAL 1,698 5,882 5,882 5,882 5,882 - - - - - - - - - - - - MISCELLANEOUS - - - - - - - - - 190,000 - - - - - TOTAL REVENUES 695,451 686,451 672,712 747,577 797,368 791,486 689,895 697,284 704,746 712,282 909,894 727,583 735,348 743,190 751,111 759,112 767,192 EXPENDITURES 404-51440-211-211 TIF 4: BTTL LLC - - - - - 404-51440-210-000 TI F 4: PROFESSIONAL SERVICES 1,086 2,717 2,725 3,670 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 CONSERVATION & DEVELOPMENT 1,086 2,717 2,725 3,670 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 404-58100-420-000 PRINCIPAL: TIF 4 94,379 70,000 70,000 - - 404-58200-420-000 INTEREST: TIF 4 4,602 2,345 802 - - - 404-51440-293-000 TIF 4: BORROWING EXPENSE - - - - - - DEBT SERVICE 98,981 72,345 70,802 - - - - - - - - - - - - - 404-59210-000-000 TRANSFER TO GENERAL FUND 10,250 8,250 8,250 - 8,250 8,250 8,250 8,250 8,250 404-59230-000-000 TRANSFER TO TIF #8 294,966 272,235 193,298 - 1,500,000 1,500,000 1,500,000 1,400,000 740,000 700,000 900,000 735,000 730,000 740,000 745,000 800,000 832,072 404-59235-000-000 TRA NSFER TO TIF #10 213,820 287,237 113,016 - - OTHER FINANCING USES 519,035 567,722 314,564 - 1,508,250 1,508,250 1,508,250 1,408,250 748,250 700,000 900,000 735,000 730,000 740,000 745,000 800,000 832,072 TOTAL EXPENDITURES 619,102 642,785 388,091 3,670 1,513,250 1,513,250 1,513,250 1,413,250 753,250 705,000 905,000 740,000 735,000 745,000 750,000 805,000 837,072 EXCESS REVENUES OVER (UNDER) EXPENDITURES 76,722 43,293 284,621 (715,882) (721,764) (823,355) (715,966) (48,504) 7,282 4,894 (12,417) 348 (1,810) 1,111 (45,888) (69,880) BEGINNING FUND BALANCE 2,021,313 2,098,035 2,141,328 2,098,035 2,425,949 1,704,185 880,830 164,864 116,360 123,642 128,536 116,119 116,467 114,657 115,768 69,880 ENDING FUND BALANCE 2,098,035 2,141,328 2,425,949 1,382,153 1,704,185 880,830 164,864 116,360 123,642 128,536 116,119 116,467 114,657 115,768 69,880 0 8/26/2024 TIF #4 2025 BUDGET WORKSHEET TIF DISTRICTS TIF #8 FUND Actual Actual Actual Current Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget 12/31/2021 12/31/2022 12/31/2023 12/31/2024 12/31/2024 Prior Year Prior Year Prior Year Year YTD Amended Request Projection Projection Projection Projection Projection Projection Projection Projec tion Projection Projection Acct No Account Description 2021 2022 2023 Actual Estimated 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 REVENUES 408-41111-000-000 GENERAL PROPERTY TAXES 250,805 286,810 348,687 448,047 476,950 476,950 415,723 420,166 424,654 429,187 433,766 438,390 443,060 447,777 452,541 457,353 462,213 TAXES 250,805 286,810 348,687 448,047 476,950 476,950 415,723 420,166 424,654 429,187 433,766 438,390 443,060 447,777 452,541 457,353 462,213 408-41490-000-000 COMPUTER AID 4,002 4,255 4,255 4,255 INTERGOVERNMENTAL 4,002 4,255 4,255 4,255 - - - - - - - - - - - - - 408-49310-000-000 DEBT PROCEEDS 408-49440-000-000 TRANFERS FROM TIF 4 294,966 272,235 193,298 - 1,500,000 1,500,000 1,500,000 1,400,000 740,000 700,000 900,000 735,000 730,000 740,000 745,000 800,000 832,072 OTHER FINANCING SOURCES 294,966 272,235 193,298 - 1,500,000 1,500,000 1,500,000 1,400,000 740,000 700,000 900,000 735,000 730,000 740,000 745,000 800,000 832,072 TOTAL REVENUES 549,773 563,301 546,240 452,302 1,976,950 1, 976,950 1,915,723 1,820,166 1,164,654 1,129,187 1,333,766 1,173,390 1,173,060 1,187,777 1,197,541 1,257,353 1,294,285 EXPENDITURES 408-51478-211-703 TIF 8 - PREMIER WAUPACA LLC - - - - 66,005 66,005 408-51478-210-000 TIF 8: PROF SERVICES 1,511 8,186 2,336 2,675 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 3,600 CONSERVATION & DEVELOPMENT 1,511 8,186 2,336 2,675 68,505 68,505 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 3,600 408-58100-420-000 PRINCIPAL: BONDS: TIF: PRINCIP 460,000 460,000 470,000 485,000 507,275 507,275 507,500 - - - - - - - 408-58200-420-000 INTEREST: BONDS: TIF: INTEREST 51,128 58,106 36,896 22,275 - - - 408-51478-293-000 TIF 8: BORROWING EXPENSE - - - - - - - - DEBT SERVICE 511,128 518,106 506,896 507,275 507,275 507,275 507,500 - - - - - - - - - 408-59210-000-000 TRANSFER TO GENERAL FUND 37,134 37,009 37,009 - 37,009 37,009 37,009 37,009 37,009 408-59230-000-000 TRANSFER TO WATER 1,000,000 1,000,000 1,000,000 942,888 - - - 408-59250-000-000 TRANSFER TO SEWER 500,000 500,000 500,000 500,000 500,000 500,000 259,997 408-59225-000-000 TRANSFER TO DEBT SERVICE 232,817 232,293 241,290 250,558 245,104 229,936 119,815 95,733 OTHER FINANCING USES 37,134 37,009 37,009 - 1,037,009 1,037,009 1,037,009 1,212,714 769,302 741,290 750,558 745,104 729,936 619,815 355,730 - TOTAL EXPENDITURES 549,773 563,301 546,241 509,950 1,612,789 1,612,789 1,547,009 1,215,214 771,802 743,790 753,058 747,604 732,436 622,315 358, 230 2,500 3,600 EXCESS REVENUES OVER (UNDER) EXPENDITURES - - (0) 364,161 364,161 368,714 604,952 392,852 385,397 580,708 425,786 440,624 565,462 839,311 1,254,853 1,290,684 BEGINNING FUND BALANCE (0) (0) (7,513,503) (0) (7,513,503) (7,149,342) (6,780,628) (6,175,676) (5,782,824) (5,397,426) (4,816,719) (4,390,933) (3,950,309) (3,384,847) (2,545,536) (1,290,684) ENDING FUND BALANCE (0) (0) (7,513,503) (7,513,503) (7,149,342) (6,780,628) (6,175,676) (5,782,824) (5,397,427) (4,816,718) (4,390,933) (3,950,309) (3,384,847) (2,545,536) (1,290,683) (0) 8/26/2024 TIF #8 2025 BUDGET WORKSHEET TIF DISTRICTS TIF #10 FUND Actual Actual Actual Current Budget Budget Budget Budget Budget Budget 12/31/2021 12/31/2022 12/31/2023 12/31/2024 12/31/2024 EXPENDITURE PERIOD END DATE: 2023 Prior Year Prior Year Prior Year Year YTD Amended Request Projection Projection Projection Projection Acct No Account Description 2021 2022 2023 Actual Estimated 2024 2025 2026 2027 2028 2029 REVENUES 410-41111-000-000 GENERAL PROPERTY TAXES 61,000 59,269 57,606 62,063 71,459 71,459 61,627 80,499 99,561 100,604 101,657 TAXES 61,000 59,269 57,606 62,063 71,459 71,459 61,627 80,499 99,561 100,604 101,657 410-41490-000-000 COMPUTER AID 1,904 1,304 1,304 1,304 30 30 30 30 30 30 30 INTERGOVERNMENTAL 1,904 1,304 1,304 1,304 30 30 30 30 30 30 30 410-47961-000-000 OTHER REVENUES GENERAL GO - 118,000 - - - 100,000 410-48111-000-000 INTEREST - - - - - MISCELLANEOUS - 118,000 - - - - 100,000 - - - - 410-49310-000-000 SALE OF PROPERTY - 108,098 - - 410-49404-000-000 TRANSFER FROM TIF #4 213,820 287,237 113,016 - 410-49409-000-000 TRANSFER FROM TIF #9 - - - - - OTHER FINANCING SOURCES 213,820 395,335 113,016 - - - - - - - - TOTAL REVENUES 276,723 573,908 171,926 63,367 71,489 71,489 161,657 80,529 99,591 100,634 101,687 410-51480-211-600 TIF 10: BUSINESS IMPRVMT GRANTS 264,845 561,127 158,953 81,098 410-51480-299-000 TIF 10: MISCELLANEOUS 53 6 - - - - 410-51480-210-000 TIF 10: PROF SERVICES 1,576 2,525 2,723 2,326 5,000 5,000 5,000 5,000 5,000 5,000 5,000 410-51480-501-000 C/O LAND & IMPROVEMENTS - - - - 200,000 CONSERVATION & DEVELOPMENT 266,473 563,657 161,676 83,424 5,000 5,000 205,000 5,000 5,000 5,000 5,000 410-58100-420-000 PRINCIPAL: BONDS: TIF: PRINCIP - - - - - 410-58200-420-000 INTEREST: BONDS: TIF: INTEREST - - - - - 410-51480-293-000 TIF 10: BORROWING EXPENSE DEBT SERVICE - - - - - - - - - - - 410-59210-000-000 TRANSFER TO GENERAL FUND 10,250 10,250 10,250 - 10,500 10,500 10,500 10,500 10,500 10,500 110,500 410-59225-000-000 TRANSFER TO DEBT SERVICE - - - - 410-59240-000-000 TRA NSFER TO TIF #4 - - - - 190,000 OTHER FINANCING USES 10,250 10,250 10,250 - 10,500 10,500 10,500 10,500 10,500 10,500 300,500 TOTAL EXPENDITURES 276,723 573,907 171,926 83,424 15,500 15,500 215,500 15,500 15,500 15,500 305,500 EXCESS REVENUES OVER (UNDER) EXPENDITURES - - - 55,989 55,989 (53,843) 65,029 84,091 85,134 (203,813) BEGINNING FUND BALANCE - - - - - - 55,989 2,147 67,176 151,267 236,401 ENDING FUND BALANCE - - - - - 55,989 2,147 67,176 151,267 236,401 32,587 8/26/2024 TIF #10 2025 BUDGET WORKSHEET TIF DISTRICTS TIF #11 FUND Actual Actual Current Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget 12/31/2022 12/31/2023 12/31/2024 Prior Year Prior Year Year YTD Amended Request Projection Projection Projection Projection Projection Projection Projection Projection Projec tion Projection Projection Projection Projection Projection Projection Projection Projection Projection Acct No Account Description 2022 2023 Actual Estimated2 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 REVENUES 411-41111-000-000 GENERAL PROPERTY TAXES - - 60,790 64,871 64,871 55,945 165,734 280,920 380,398 480,870 544,514 582,998 590,912 598,906 606,979 615,133 623,368 631,686 640,087 648,572 657,142 665,797 674,539 683,369 TAXES - - 60,790 64,871 64,871 55,945 165,734 280,920 380,398 480,870 544,514 582,998 590,912 598,906 606,979 615,133 623,368 631,686 640,087 648,572 657,142 665,797 674,539 683,369 411-41490-000-000 COMPUTER AID - - - INTERGOVERNMENTAL - - - - - - - - - - - - - - - - - - - - - - - - 411-48611-000-000 SALES:CITY PROPERTY - 7,277 - OTHER FINANCING SOURCES - 7,277 - - - - - - - - - - - - - - - - - - - - - - TOTAL REVENUES - 7,277 60,790 64,871 64,871 55,945 165,734 280,920 380,398 480,870 544,514 582,998 590,912 598,906 606,979 615,133 623,368 631,686 640,087 648,572 657,142 665,797 674,539 683,369 EXPENDITURES 411-51479-131-000 TIF 11: ADMIN CHARGE TIF - - - 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 411-51479-299-000 TIF 11: MISCELLANEOUS - - - - - 411-51479-211-500 TIF 11: HDG DEVELOPMENT - - 86,674 177,475 268,276 359,078 413,558 443,275 443,275 443,275 443,275 443,275 443,275 443,275 443,275 443,275 443,275 443,275 581,283 - 411-51479-210-000 TIF 11: PROF SERVICES 8,922 5,912 11,420 411-51479-211-000 TIF 11: CONTRACT SERVICES - - - CONSERVATION & DEVELOPMENT 8,922 5,912 11,420 30,000 30,000 30,000 116,674 207,475 298, 276 389,078 443,558 473,275 473,275 473,275 473,275 473,275 473,275 473,275 473,275 473,275 473,275 473,275 611,283 - TRANSFER TO DEBT SERVICE OTHER FINANCING USES - - - - - - - - - - - - - - - - - - - - - - - - TOTAL EXPENDITURES 8,922 5,912 11,420 30,000 30,000 30,000 116,674 207,475 298,276 389,078 443,558 473,275 473,275 473,275 473,275 473,275 473,275 473,275 473,275 473,275 473,275 473,275 611,283 - EXCESS REVENUES OVER (UNDER) EXPENDITURES (8,922) 1,365 34,871 34,871 25,945 49,060 73,445 82,122 91,792 100,956 109,723 117,637 125,631 133,704 141,858 150,093 158,411 166,812 175,297 183,867 192,522 63,256 683,369 BEGINNING FUND BALANCE (8,922) (7,556) (7,556) 27,315 53,260 102,320 175,765 257,887 349, 679 450,635 560,358 677,995 803,626 937,330 1,079,188 1,229,281 1,387,692 1,554,504 1,729,801 1,913,668 2,106,190 2,169,446 ENDING FUND BALANCE (8,922) (7,556) 27,315 27,315 53,260 102,320 175,765 257,887 349,679 450,635 560,358 677,995 803,626 937,330 1,079,188 1,229,281 1,387,692 1,554,504 1,729,801 1,913,668 2,106,190 2,169,446 2,852,812 8/26/2024 TIF #11 2025 BUDGET WORKSHEET TIF DISTRICTS TIF #12 FUND Churchill Street Actual Actual Current Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget 12/31/2022 12/31/2023 12/31/2024 EXPENDITURE PERIOD END DATE: 2023 Prior Year Prior Year Year YTD Amended Request Projection Projection Projection Projection Projection Pro jection Projection Projection Projection Projection Projection Projection Projection Projection Projection Projection Projection Projection Acct No Account Description 2022 2023 Actual Estimated 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 REVENUES 412-41111-000-000 GENERAL PROPERTY TAXES - - 2,011 2,147 2,147 2,008 2,166 2,326 2,487 2,650 2,814 2,980 3,148 3,318 3,489 3,662 3,836 4,013 4,191 4,371 4,553 4,736 4,921 5,109 TAXES - - 2,011 2,147 2,147 2,008 2,166 2,326 2,487 2,650 2,814 2,980 3,148 3,318 3,489 3,662 3,836 4,013 4,191 4,371 4,553 4,736 4,921 5,109 412-41490-000-000 COMPUTER AID - - - INTERGOVERNMENTAL - - - - - - - - - - - 412-48611-000-000 SALES:CITY PROPERTY - - - OTHER FINANCING SOURCES - - - - - - - - - - - TOTAL REVENUES - - 2,011 2,147 2,147 2,008 2,166 2,326 2,487 2,650 2,814 2,980 3,148 3,318 3,489 3,662 3,836 4,013 4 ,191 4,371 4,553 4,736 4,921 5,109 EXPENDITURES 412-51479-131-000 TIF 12: ADMIN CHARGE TIF - - - 412-51479-299-000 TIF 12: MISCELLANEOUS - - - - - 412-51479-210-000 TIF 12: PROF SERVICES 7,750 2,000 2,476 2,176 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 412-51479-211-000 TIF 12: CONTRACT SERVICES - - - CONSERVATION & DEVELOPMENT 7,750 2,000 2,476 2,176 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 - 412-59210-000-000 TRANSFER TO GENERAL FUND - - - - TRANSFER TO DEBT SERVICE OTHER FINANCING USES - - - - - - - - - - - TOTAL EXPENDITURES 7,750 2,000 2,476 2,176 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2 ,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 - EXCESS REVENUES OVER (UNDER) EXPENDITURES (7,750) (2,000) (29) 147 8 166 326 487 650 814 980 1,148 1,318 1,489 1,662 1,836 2,013 2,191 2,371 2,553 2,736 2,921 5,109 BEGINNING FUND BALANCE (7,750) (9,750) (9,750) (9,603) (9,596) (9,430) (9,104) (8,617) (7,968) (7,154) (6,173) (5,025) (3,707) (2,219) (557) 1,280 3,292 5,483 7,854 10,407 13,143 16,064 ENDING FUND BALANCE (7,750) (9,750) (9,779) (9,603) (9,596) (9,430) (9,104) (8,617) (7,968) (7,154) (6,173) (5,025) (3,707) (2,219) (557) 1,280 3,292 5,483 7,854 10,407 13,143 16,064 21,173 8/26/2024 TIF #12 2025-2026 CAPITAL IMPROVEMENT PLANS Introduction The City of Waupaca is committed to providing an annual Capital Improvement Plan (CIP) to aid in the decision making process for the annual budget and ensure the adequate maintenance, acquisition and construction of capital projects. This document serves as a tool for determinin g the scheduling of capital improvements and related financing. The CIP document also shares the City’s intentions for improvements for the next five years with residents, developers, intergovernmental partners and the business community. A primary responsibility of the City Council is to preserve, maintain and improve the community’s investment in buildings, vehicles, roads, utilities, parks and equipment. The CIP is a short and long range plan for the physical development and infrastructure investment in the City of Waupaca. Goals of the CIP The annual CIP is prepared with the guidance of the following two major goals: 1) Address the City’s immediate and long-term capital needs, particularly those related to the following: a. Maintaining the City’s investment in existing infrastructure and assets. b. Expand and improve the tax base in a way that will benefit both new and existing residents and landowners and potential investors. c. Providing City services and programs in the most efficient and effective manner possible. d. Manage current and future debt service within Debt Service Policy. 2) Provide a financial plan for the implementation of the CIP that evaluates all available funding resources, prioritizes projects and maintains the City’s strong financial condition. City of Waupaca Mission Statement “The city of Waupaca’s mission is to lead creatively, plan wisely and spend prudently to provide the services that ensure a safe and vibrant community.” 3) As elected officials and employees of the City of Waupaca we are dedicated to serving our community by providing quality public services, implementing innovative policies and being responsive to everyone who lives, works and visits our community. Our purpose is to make Waupaca the best place to raise a family, own a business and enjoy a high quality of life. To accomplish this purpose effectively, we share a commitment to work together to hold ourselves accountable, to maintain the highest integrity and to lead by example. Relationship of the CIP to the Operating Budget The City coordinates development of the annual CIP with the development of the operating budget. The inclusion of a projec t within the first year of the CIP shows the strong intent to include that project within the budget document for that year. Inclusion of projects in the remaining four years also shows intent, but is more subject to change. Approval of the annual capi tal improvement budget (year one of the CIP) takes place at the same time as approval of the annual operating budget. Therefore, CIP projects are not considered final and approved for funding until they are included and approved in the annual operating budget. Future operating costs associated with new capital improvements or major equipment purchases are also projected and included in the operating budget as necessary. CIP Development Process The annual CIP development process is initiated by the City Administrator and Finance Director/Clerk-Treasurer. Each Department Director will develop their annual capital improvement budget for his or her respective department and prioritize projects. A review of financial and borro wing impacts of the requests are then reviewed with the Finance Director/Clerk-Treasurer and the City’s Financial Advisor as necessary. A special meeting of the City Council is typically planned for late August or September to allow necessary time to review the draft plan prior to full initiation of the annual operating budget development process. The final CIP, associated budget and financing plans will then be completed and presented to the City Council for their final approval in November. CIP Development Software The City of Waupaca utilizes software called PlanIt! to assist in the CIP process. This software allows for greater efficiency in the planning process over previously utilized spreadsheets. PlanIt! is an Microsoft Access based software product which offers the City flexibility in prioritizing projects, planning beyond five years, moving projects and offers a variety of reporting functions. An annual renewal fee is required for the use of the software. Definition of Capital Expenditure Capital improvement expenditures shall include any amounts expended for equipment or other assets with a useful life of five years or more and/or which involve amounts more than $5,000. Project expenditures should include all costs related to a project including, but not limited to, pl anning, engineering, legal, construction inspection, land acquisition, etc. Expenditures not meeting these criteria, or which have a useful life of less than the payback period of the funds to be borrowed, shall be included in the City’s annual operating budget as applicable. Departments The CIP includes projects for the following departments and utilities: Airport Buildings & Grounds Cemetery Information Technology Parks & Recreation Police Department Public Library Public Works Department Transit Wastewater Treatment Utility Water Utility Waupaca Online Utility Project Worksheets & Details The CIP software used by the City includes a number of standard data entry fields to describe and categorize each project in the CIP. These fields allow for a comprehensive variety of summary reports and analysis features not available through standard spreadsheets. It is however important that users of the software and readers of the resulting CIP document understand how these fields are used and defined. The following is a brief descript ion of each of those fields as used by the City in the PlanIt! software:  Project Number: Unique number assigned to each project. Number reflects the department responsible, the year added to the CIP, and then a sequential numbering schema.  Project Name: Brief name of the project.  Department: Department the project is assigned.  Contact: Individual responsible for details regarding the project.  Type: Basic codes that can be assigned including equipment, i m provement, maintenance, vehicle or unassigned.  Useful Life: Estimated useful life of the project or purchase once implemented.  Category: One of the codes used to categorize projects such as vehicles, public safety equipment, software, parks improvements, buildings, etc.  Priority: Identification of the priority of the project. (See next section for a further description of project prioritization.)  Custom Fields: A total of four custom fields are available for use. The four fields currently used by the City include the following: o Created: When was the project first created and included in the CIP. o Updated: On what date was an update last provided to the projects details. o Map-Other Info Available: Indication if the project has a GIS map or documentation available to further geographically display or present the project.  Total Project Cost: Total cost of a project for all years entered within the CIP. This may include costs already entered for years beyond the five year planning period.  Description: A detailed description of what the project is. May include details such as location, quantities, who will complete the project, general type of project (new, replacement, repair), staff involvement, who provided cost estimates, etc.  Justification: An explanation on why the project is needed. Should also help further explain the projects priority and year proposed.  Budget Impact/Other: An explanation of any known direct costs or savings to the operating budget should the project be implemented.  Status (not shown): Projects are assigned to one of three codes including active, pending or completed. The status of a project is currently not shown on project detail worksheets as all projects are active. Pending projects are provided in a separate section of the CIP document. These projects are not officially included within the five-year plan. Project Prioritization Because capital project requests and needs typically exceed available financing, they have to be prioritized. The City uses the following project prioritization categories for all project requests. Prioritization categories are assigned to projects by Department Directors with review by the City Administrator and/or Finance Director.  Mandatory (1): Project is mandated or must co mply by Federal or State law, regulation, court order, municipal ag reement or contract. Project is an immediate health and safety issue that must be addressed. Project has been confirmed for receiving grant funding and the City Council pre-approved the application for funding. Project is identified as vital to the economic stability of the City.  High Priority (2): Project is a likely health and safety issue or may significantly affect City operations or services that must, at a minimum, be addressed within the next two to three years. Project must also be identified as a requirement or planned project under a City plan, policy or code. Projects that have actively submitted for grant funding or have received private funding and projects that demonstrate a high ROI (payback <3 years) shall be given greater priority as well as.  Essential (3): Project is highly desired, but is likely not a health or safety issue. The project should be addressed at least within the next five years. Project may be identified as a priority under a City plan, policy or code. Project may be eligible for grant or private funding and may demonstrate a moderate ROI (payback <5 years).  Acceptable (4): Project is currently more desirable than necessary and could be deferred several years before becoming essential or high priority. Project is adequately planned, but not absolutely required. Project may have limited opportunities for grant or private fundin g. Project may demonstrate a ROI over the life of the asset.  Deferrable (5): Project is desirable, but not essential and can be easily deferred beyond five years. Project is also not clearly identified in any City plan, policy or code.  Future Consideration: Project is clearly a long-term request which is known as not necessary within the five year planning period. Project may be included for illustrative purposes only or submission of additional information is necessary and/or project is on hold indefinitely. There are other factors that may come into consideration when prioritizing projects. For example, there may be a specific dedicated funding source that must be used only for a particular type of project for a specific timeframe. One project may be an integral part of another project that needs to be completed even if its individual priority is not as high. Finally, a project may take advantage of opportunities that exist currently that may not be available in the future. Capital Improvement Plan Financing The financing of capital projects includes a variety of funding options. The use of the following listed revenue sources are evaluated as part of the CIP process and are listed within project worksheets. Additional details on project financing may also be provided in worksheet text as necessary, particularly if projects involve several funding sources or grants.  General Fund Operations  Federal/State Grants  Private Donations  WI DOT Funding  State Trust Fund Loan  Safe Drinking Water Loan Fund  Clean Water Loan Fund  Utility Operating Funds  Reserve Funds  Utility Retained Earnings  General Obligation Debt  Bureau of Aeronautics While the majority of projects within the CIP iden tify the use of general obligation debt for project financing, some projects utilize other funding sources. For example, the departments have opportunities to sell equipment and build reserve funds, collect donations through fundraisers, and apply for grants, and other supporting funds. These funds are supported utilizing various funding mechanisms and sources and are evaluated during the development of the CIP. Capital Improvement Plan City of Waupaca, Wisconsin PROJECTS BY DEPARTMENT 2025 2029thru Total2025 2026 2027 2028 2029Department Project # Airport AIR-17-06 1,640,0001,640,000T HANGAR/STORAGE BUILDING AIR-17-07 15,00015,000Update Terminal Bathrooms 1,655,0001,640,000 15,000Airport Total Cemetery CEM-25-01 18,00018,000CEMETERY MOWER REPLACEMENT 18,00018,000Cemetery Total City Hall/Library Building CHLIB-24-01 450,000450,000ELEVATOR REPLACEMENT 450,000450,000City Hall/Library Building Total Community Development COMDEV-22-06 25,00025,000WAYFINDING IMPLEMENTATION COMDEV-25-02 10,00010,000PROFESSIONAL PLANNING SERVICES COMDEV-25-03 25,00025,000WAYFINDING AND ENTRY SIGNAGE COMDEV-28-01 70,00070,000HOUSING STUDY UPDATE 130,00060,000 70,000Community Development Total IT/Community Media ITCM-17-03 55,00011,000 11,000 11,000 11,000 11,000ANNUAL COMPUTER REPLACEMENT ITCM-23-02 12,00012,000MEETING/AGENDA MGMT SOFTWARE ITCM-25-1 9,9009,900Adobe Acrobat Pro Upgrade ITCM-26 20,00020,000SECURITY CAMERA UPGRADES (PLACEHOLDER) ITCM-26-1 12,00012,000GENERAL GOVT SERVER REPLACEMENT ITCM-27-1 11,00011,000POLICE SERVER REPLACEMENT ITCM-28-1 9,0009,000VIDEO DVR SERVER ITCM-29-1 32,00032,000Microsoft Office Upgrade 160,90032,900 43,000 22,000 20,000 43,000IT/Community Media Total Parks and Recreation PARKS-23-01 200,000200,000ECO PARK PLAYGROUND PARKS-24-01 25,00025,000BRAINARDS BRIDGE PARK SHELTER RENOVATION PARKS-25-01 250,000250,000LAKEMEN FIELD CONCESSION/BATHROOM UPGRADE PARKS-25-03 25,00025,000SOUTH PARK LIFT STATION REPLACEMENTS PARKS-25-05 15,00015,000PARKS AND RECREATION CORP (2026-2030) PARKS-25-06 10,00010,000REPLACE SWAN PARK IRRIGATION CONTROLLER PARKS-26-01 90,00090,000POEHLMAN PARK PLAYGROUND REPLACEMENT PARKS-26-02 35,00035,000BALL MACHINE REPLACEMENT PARKS-27-01 200,000200,000RIVERSIDE PARK PLAYGROUND REPLACEMENT PARKS-29-01 250,000250,000ROTARY RIVERVIEW PARK PLAYGROUND Total2025 2026 2027 2028 2029Department Project # REPLACEMENT PARKS-29-02 75,00075,000BRAINARDS BRIDGE SHELTER ROOF REPLACEMENT 1,175,000500,000 125,000 200,000 25,000 325,000Parks and Recreation Total Police Building PDBLDG-17-03 60,00060,000POLICE BUILDING ROOF REPAIRS PDBLDG-21-01 500,0000 500,000POLICE GARAGE PDBLDG-23-01 30,00030,000ELEVATOR MOTHER BOARD REPLACEMENT 590,00030,000 500,000 60,000Police Building Total Police Department POLICE 20-02 75,00075,000TASERS - AXON POLICE 20-03 35,00035,000PORTABLE RADIOS POLICE 21-01 5,1005,100INTERVIEW ROOM CAMERAS POLICE-17-01 50,00050,000CAPTAIN SQUAD POLICE-17-02 322,000170,000 70,000 82,000PATROL SQUAD 487,100170,000 70,000 137,100 110,000Police Department Total Rec Center Building RECCTR-17-04 205,000205,000REC CENTER BOILER REPLACEMENT RECCTR-21-01 400,000400,000REC CENTER ROOF REPLACEMENT 605,000205,000 400,000Rec Center Building Total Street Department STR-17-03 305,000305,000REPLACE PLOW TRUCK STR-17-05 135,00065,000 70,000REPLACE PICKUP TRUCK STR-24-01 18,00018,000REPLACE MOWER 458,000323,000 65,000 70,000Street Department Total Street Rehabilitation Program ENG-17-07 1,445,00025,000 50,000 70,000 1,300,000REPLACE PEDESTRIAN BRIDGE - RIVERVIEW ENG-18-05 6,100,000150,000 450,000 5,500,000FULTON ST - Hillcrest to Main - PROJECT ENG-20-01 1,225,0001,225,000ELM ST RECONSTRUCTION ENG-20-02 60,00030,000 30,000SEAL COAT ROADS ENG-24-01 215,00015,000 200,000ROYALTON STREET - RIVER NORTH UPGRADE ENG-24-02 150,000150,000JEFFERSON RECONSTRUCTION 9,195,0001,415,000 730,000 5,570, 000 1,330,000 150,000Street Rehabilitation Program Total Wastewater Treatment WWTP-17-08 50,00050,000PLANT DCS (Distributed Control System) REPLACEMENT WWTP-1903 110,000110,000RAS PUMP REPLACEMENT WWTP-21-01 3,282,800700,000 2,582,800BOWLBY LIFT-STATION RECONSTRUCT WWTP-23-01 250,000250,000SLUDGE MIXING WWTP-23-03 150,000150,000BUILDING HEAT BOIL REPLACEMENT WWTP-24-01 220,000220,000ACTIVATED SLUDGE TANK SLIDE GATES WWTP-24-02 430,000430,000SCADA RADIO UPGRADE 4,492,800920,000 2,582,800 15 0,000 680,000 160,000Wastewater Treatment Total Water Department Total2025 2026 2027 2028 2029Department Project # WATER-17-09 85,00015,000 15,000 15,000 20,000 20,000LEAK LOCATION WATER-17-12 120,00020,000 20,000 25,000 25,000 30,000CROSS CONNECTION CONTROL PROGRAM WATER-17-15 66,00066,000NEW PICKUP-WATER WATER-20-02 70,00070,000METER VAULT IMPROVEMENTS WATER-24-01 90,00090,000660 HILLCREST RE-ALIGNMENT 431,000125,000 101,000 40,000 115,000 50,000Water Department Total GRAND TOTAL 19,847,8005,390,900 3,651,800 6,167, 100 3,220,000 1,418,000 Capital Improvement Plan City of Waupaca, Wisconsin PROJECTS BY FUNDING SOURCE 2025 2029thru TotalSource Project # 2025 2026 2027 2028 2029 Bureau of Aeronautics GA Funding AIR-17-06 1,480,0001,480,000T HANGAR/STORAGE BUILDING 1,480,0001,480,000Bureau of Aeronautics GA Funding Total General Fund PARKS-25-05 15,00015,000PARKS AND RECREATION CORP (2026-2030) 15,00015,000General Fund Total GO Bonds/STFLP Long term AIR-17-06 110,000110,000T HANGAR/STORAGE BUILDING AIR-17-07 15,00015,000Update Terminal Bathrooms CEM-25-01 35,00017,000 18,000CEMETERY MOWER REPLACEMENT CHLIB-24-01 450,000450,000ELEVATOR REPLACEMENT COMDEV-25-02 10,00010,000PROFESSIONAL PLANNING SERVICES COMDEV-25-03 25,00025,000WAYFINDING AND ENTRY SIGNAGE COMDEV-28-01 70,00070,000HOUSING STUDY UPDATE ENG-17-07 472,10025,000 50,000 70,000 327,100REPLACE PEDESTRIAN BRIDGE - RIVERVIEW ENG-18-05 3,022,807150,000 450,000 2,422,807FULTON ST - Hillcrest to Main - PROJECT ENG-20-01 525,000525,000ELM ST RECONSTRUCTION ENG-20-02 60,00030,000 30,000SEAL COAT ROADS ENG-24-02 50,00050,000JEFFERSON RECONSTRUCTION ITCM-17-03 55,00011,000 11,000 11,000 11,000 11,000ANNUAL COMPUTER REPLACEMENT ITCM-25-1 9,9009,900Adobe Acrobat Pro Upgrade ITCM-26 20,00020,000SECURITY CAMERA UPGRADES (PLACEHOLDER) ITCM-26-1 12,00012,000GENERAL GOVT SERVER REPLACEMENT ITCM-27-1 11,00011,000POLICE SERVER REPLACEMENT ITCM-28-1 9,0009,000VIDEO DVR SERVER ITCM-29-1 32,00032,000Microsoft Office Upgrade LIB-27-1 50,00025,000 25,000Restroom Updates PARKS-24-01 25,00025,000BRAINARDS BRIDGE PARK SHELTER RENOVATION PARKS-25-03 25,00025,000SOUTH PARK LIFT STATION REPLACEMENTS PARKS-25-06 10,00010,000REPLACE SWAN PARK IRRIGATION CONTROLLER PARKS-29-01 125,000125,000ROTARY RIVERVIEW PARK PLAYGROUND REPLACEMENT PARKS-29-02 75,00075,000BRAINARDS BRIDGE SHELTER ROOF REPLACEMENT PDB LDG-17-03 60,00060,000POLICE BUILDING ROOF REPAIRS PDBLDG-21-01 500,0000 500,000POLICE GARAGE PDBLDG-23-01 30,00030,000ELEVATOR MOTHER BOARD REPLACEMENT POLICE 20-02 75,00075,000TASERS - AXON POLICE 20-03 35,00035,000PORTABLE RADIOS POLICE-17-01 50,00050,000CAPTAIN SQUAD POLICE-17-02 252,000170,000 82,000PATROL SQUAD TotalSource Project # 2025 2026 2027 2028 2029 RECCTR-17-04 205,000205,000REC CENTER BOILER REPLACEMENT RECCTR-21-01 400,000400,000REC CENTER ROOF REPLACEMENT STR-17-03 285,000285,000REPLACE PLOW TRUCK STR-17-05 135,00065,000 70,000REPLACE PICKUP TRUCK STR-24-01 6,0006,000REPLACE MOWER 7,336,8071,558,900 573,000 2,719, 807 1,407,100 1,078,000GO Bonds/STFLP Long term Total Library Donations LIB-27-1 25,00025,000Restroom Updates 25,00025,000Library Donations Total Operating Funds POLICE 21-01 5,1005,100INTERVIEW ROOM CAMERAS 5,1005,100Operating Funds Total Parks Equipment Reserve Fund PARKS-26-02 35,00035,000BALL MACHINE REPLACEMENT 35,00035,000Parks Equipment Reserve Fund Total Police Equipment Reserve Funds POLICE-17-02 70,00070,000PATROL SQUAD 70,00070,000Police Equipment Reserve Funds Total Private Donations PARKS-23-01 200,000200,000ECO PARK PLAYGROUND PARKS-25-01 250,000250,000LAKEMEN FIELD CONCESSION/BATHROOM UPGRADE PARKS-26-01 90,00090,000POEHLMAN PARK PLAYGROUND REPLACEMENT PARKS-27-01 200,000200,000RIVERSIDE PARK PLAYGROUND REPLACEMENT PARKS-29-01 125,000125,000ROTARY RIVERVIEW PARK PLAYGROUND REPLACEMENT 865,000450,000 90,000 200,000 125,000 Private Donations Total Revenue Bonds - Water ENG-18-05 500,000500,000FULTON ST - Hillcrest to Main - PROJECT ENG-20-01 350,000350,000ELM ST RECONSTRUCTION ENG-24-02 50,00050,000JEFFERSON RECONSTRUCTION STR-24-01 6,0006,000REPLACE MOWER WATER-17-15 66,00066,000NEW PICKUP-WATER WATER-20-02 70,00070,000METER VAULT IMPROVEMENTS WATER-24-01 75,00075,000660 HILLCREST RE-ALIGNMENT WWTP-21-01 280,00030,000 250,000BOWLBY LIFT-STATION RECONSTRUCT WWTP-24-02 215,000215,000SCADA RADIO UPGRADE 1,612,000461,000 316,000 500,000 285,000 50,000Revenue Bonds - Water Total TotalSource Project # 2025 2026 2027 2028 2029 Revenue Bonds - WWTP ENG-18-05 500,000500,000FULTON ST - Hillcrest to Main - PROJECT ENG-20-01 350,000350,000ELM ST RECONSTRUCTION ENG-24-02 50,00050,000JEFFERSON RECONSTRUCTION STR-24-01 6,0006,000REPLACE MOWER WATER-24-01 15,00015,000660 HILLCREST RE-ALIGNMENT WWTP-1903 110,000110,000RAS PUMP REPLACEMENT WWTP-21-01 3,002,800670,000 2,332,800BOWLBY LIFT-STATION RECONSTRUCT WWTP-23-01 250,000250,000SLUDGE MIXING WWTP-24-01 220,000220,000ACTIVATED SLUDGE TANK SLIDE GATES WWTP-24-02 215,000215,000SCADA RADIO UPGRADE 4,718,8001,261,000 2,332,800 500,000 465,000 160,000Revenue Bonds - WWTP Total Room Tax Fund COMDEV-22-06 25,00025,000WAYFINDING IMPLEMENTATION 25,00025,000Room Tax Fund Total Streets Equipment Reserve Funds STR-17-03 20,00020,000REPLACE PLOW TRUCK 20,00020,000Streets Equipment Reserve Funds Total Wastewater Reserve Funds WWTP-17-08 50,00050,000PLANT DCS (Distributed Control System) REPLACEMENT WWTP-23-03 150,000150,000BUILDING HEAT BOIL REPLACEMENT 200,000150,000 50,000Wastewater Reserve Funds Total Water Utility Operating Budget WATER-17-09 85,00015,000 15,000 15,000 20,000 20,000LEAK LOCATION WATER-17-12 120,00020,000 20,000 25,000 25,000 30,000CROSS CONNECTION CONTROL PROGRAM 205,00035,000 35,000 40,000 45,000 50,000Water Utility Operating Budget Total WIS-DOT Funding ENG-17-07 972,900972,900REPLACE PEDESTRIAN BRIDGE - RIVERVIEW ENG-18-05 2,077,1932,077,193FULTON ST - Hillcrest to Main - PROJECT ENG-24-01 235,00015,000 220,000ROYALTON STREET - RIVER NORTH UPGRADE 3,285,09315,000 220,000 2,077,193 972,900WIS-DOT Funding Total 19,897,8005,320,900 3,671,800 6,217, 100 3,175,000 1,513,000GRAND TOTAL