Loading...
HomeMy WebLinkAbout01(B) - 2027-2031 Capital Improvement Program Presentation Report ITEM: 1B CITY COUNCIL AGENDA REPORT MEETING DATE: June 23, 2026 PREPARED BY: Jason Etter, Accounting Manager Christine Watson, Public Works Supervisor-Administration Nicole Klekner, Finance Director PRESENTED BY: Nick Monserud, Public Works Director Nicole Klekner, Finance Director AGENDA ITEM: 2027-2031 Capital Improvement Program Draft RECOMMENDED ACTION: The Council is asked to provide comments on the draft Capital Improvement Program (CIP) so the CIP process can proceed on schedule. The CIP plans are as follows:  Equipment Replacement Plan  Park Plan  Facilities Management Plan  Pavement Management Plan  Technology Plan Utility Funds (These will be discussed separately at the 7/28 work session):  Water Financial Plan  Sanitary Sewer Financial Plan  Water Quality Financial Plan This work session will also include the financial analysis of the CIP plans. The draft summary documents have been included for City Council review. BACKGROUND: The Capital Improvement Program is one of the City’s long-term financial planning tools. The CIP is updated on an annual basis. The CIP is designed to identify infrastructure improvements and the associated funding sources needed due to ongoing maintenance, repair, and community growth. Such projects include city-initiated improvements, as well as county and state road improvements. As a reminder, the City Council has provided the following direction regarding pavement management in the past: 10-year pavement management plan: Continue to plan for the 10-year projects identified in the pavement management plan to ensure that roads are maintained to maximize their useful life. The average annual pavement management funding level needed beginning in 2027 is $11.2M. This includes the Water/Sewer/Stormwater funding needs. Funding for utility funds is achieved through rates charged and/or debt issuance. The utility rates will be reviewed annually as the 10-year projects in the planning period may change. City of Prior Lake | 4646 Dakota Street SE | Prior Lake MN 55372 Item 1B Page | 2 EQUIPMENT REPLACEMENT PLAN (ERP) An evaluation of the condition of the City’s fleet is completed annually and the ERP is updated. A Vehicle Replacement Rating (VRR) is used as a tool in completing equipment evaluations in an objective and systematic way using data collected through the fleet management system. The ERP also includes a replacement schedule for equipment attachments and emergency sirens to ensure appropriate funding is identified for these items as well. The cost for these items is updated annually based on recent purchases and other industry changes. See Attachments 1 and 2 for more details. Funding Sources: Based on the planned use of funds for equipment replacement, the annual tax levy needs to increase to meet our needs and minimize future debt issuance. Council has directed staff to smooth the levy increase where possible, so an annual increase of approximately $50,000 has been built into the plan. Our goal is to maintain the levy at a level that provides adequate cash flow to cover the next year’s expenditures, to absorb an unplanned equipment failure, or to fund an unexpected equipment need. Our average annual equipment funding need is $1.7 million per year over the next 10 years. The proposed tax levy funding level for 2027 is $1,025,000. We will continue to incrementally increase the property tax levy to get to our annual funding goal. Debt issuance is proposed in this fund in 2027 and 2028, primarily for fire truck replacements. See Attachments 1 and 2 for more details. PARK PLAN The Council adopted the Parks and Trails System Plan on March 12, 2024, and amended the City’s 2040 comprehensive plan on June 11, 2024 to incorporate the information in the Parks and Trails System plan. This plan includes current parks and proposed changes/updates as well as the City’s future needs and location of new parks. The City’s park referendum request was not approved by voters in November 2025 so there will be ongoing park funding discussions as the Council makes decisions on future park impacts. Fund 225 – New Park improvements In accordance with State Statutes, revenues in the Capital Park Fund may only be used for the acquisition and development or improvement of parks, recreational facilities, playgrounds, trails, wetlands, or open space based on the approved park systems plan. Fund 430 – Existing Park replacements/improvements This plan funds capital replacement projects, park amenities, and trail, sidewalk, and boardwalk replacement. The plan proposes a phased increase in the tax levy to cover the capital projects in the plan. See Attachments 3 through 5 for park plan details. FACILITY MANAGEMENT PLAN (FMP) The FMP was developed to plan for major repairs, replacements, and upgrades for all our facilities. The FMP uses standard life expectancy of the facility components and equipment to Item 1B Page | 3 determine the appropriate placement in the plan. City Hall and the Police Station buildings were both built in 2006 and need significant facility component replacement. An evaluation was completed to determine the remaining useful life of some of the major facility components such as HVAC systems, roofing, etc. Based on this evaluation and review by the Facilities Manager, significant facility project costs for City Hall, the Police Station and the Library are included in the FMP including replacement of roofing, HVAC updates, and parking/safety enhancements. The Maintenance Center expansion is slated for 2032 with engineering and project planning costs starting in 2030. Bonding for these major projects has been updated to include bonding each year from 2027-2032. See Attachments 6 and 7 for facilities plan details. PAVEMENT MANAGEMENT PLAN – TRANSPORATION AND STREET OVERLAY PROJECTS The Pavement Management Plan has been updated to identify a combination of mill and overlay, rehabilitation and reconstruction projects based on an average annual cost of $11.2M for streets over the 10-year planning period. Funding for pavement management includes annual gas and electric franchise fee revenue dedicated to pavement management, estimated at an annual average of $1.5M/year for the five- year planning period. Staff recommend review and update of the franchise fees every three years. The Council recently approved updated rates for 2025. The major proposed projects for 2027 – 2031 are noted below. 2027 – Northwood Phase 2 This is proposed to be a full reconstruction with water, sewer, and stormwater improvements. The project area includes Fremont Rd NW as well as numerous side streets adjacent to Fremont Rd NW and Northwood Rd NW. 2027 – Wilds & Jeffers This area was rehabilitated in 2024-2025 and is scheduled for seal coating, which is customary 2-3 years after new pavement is installed to help seal in the oils and prolong the life of the pavement. 2028 – Green Heights This is proposed to be a full reconstruction with water, sewer, and stormwater improvements. The project area includes Green Heights Trl SW, Pershing St SW, and other adjacent cross streets. 2029 – Northwood Phase 3 This is proposed to be a full reconstruction with water, sewer, and stormwater improvements. The project area includes the southern portion of Northwood Rd and Butternut Circle NW. 2029 – Sunset Hills This is proposed to be a full reconstruction with water, sewer, and stormwater improvements. The project area includes Sunset Trl SW and Sunray Cir SW. Item 1B Page | 4 th 2030 – 180 Street Paving th This section of 180 St. from Sunray Blvd. to Fairlawn Ave. is currently gravel. This project includes paving this section of roadway. Also, as part of the Aspen Ridge Development, the Developer has contributed $325,000 towards this project. 2030 - Mill and Overlay Projects Planned overlays for 2030 include Adelmann St SE, Trailhead Ln, and Fish Point Road from Fawn Meadow Curve SE to Oak Point Dr. 2030 – Berens Road Extension This project is an extension of Berens Rd. to CSAH 21 and is identified in Scott County’s Transportation Improvement Plan. The timing for this project will be largely driven by the Shakopee Mdewakanton Sioux Community and development on their reservation. 2031 – Big Woods Trail (County Project) This is a proposed trail rehabilitation from Revere Way to Franklin Trail along CSAH 21. See Attachments 8 through 10 for further details of the Pavement Management Program. TECHNOLOGY PLAN The Technology Plan is used to plan for current and long-range IT capital needs including general equipment, network infrastructure and software needs. While this plan is reflective of the needs of our various departments, the actual request could change as part of the budget review process. See Attachment 11. Significant projects include phone system upgrade in 2028, Council Chambers equipment in 2031 and election equipment in 2031. FINANCIAL IMPACT: CIP Impact on Long Range Financial Plan: The financial plan incorporates the debt and tax levy impacts of the Capital Improvement Program. Approval of the CIP does not obligate the City to complete the proposed projects or purchases. The 2027 projects/proposed purchases will be incorporated into the 2027 budget requests for budgeted funds. Further Council approvals may be necessary to comply with state statutes and the city’s purchasing policy. At the July 28 budget and financial planning work session, staff will include the CIP and debt impacts that are part of the City’s financial plan. Staff will also provide an update on 2027 proposed utility rate changes. Conclusion: The City has been working over the last several years to document its assets and plan for major maintenance or replacements. As these documents have been refined, the financial impacts of our needs are putting pressure on our funding mechanisms given our current funding levels. A much-needed funding source in the plan includes debt issuance for major facilities projects. The City Council is asked to provide Staff with comments and input on these components of the draft CIP so that they can be refined in preparation for the City’s financial planning, public review, and approval process. Item 1B Page | 5 A public hearing before the City Council is scheduled for the proposed CIP on Wednesday, August 12. A public hearing is necessary to preserve the option of the City utilizing Street Improvement Bonds as a future funding mechanism for future transportation projects. ATTACHMENTS: 1. Attach 1 - F410 Projects by Department (10 Year) 2. Attach 2 - F410 Sources and Uses of Funds (10 Year) 3. Attach 3 – F225 Projects by Category (10 Year) 4. Attach 4 - F225 Sources and Uses of Funds (10 Year) 5. Attach 5 - F430 Sources and Uses of Funds (10 Year) 6. Attach 6 - F440 Projects by Category and Dept (10 Year) 7. Attach 7 - F440 Sources and Uses of Funds (10 Year) 8. Attach 8 - Pavement Management Projects and Funding by Dept (10 Year) 9. Attach 9 – F450 Sources and Uses of Funds (10 Year) 10. Attach 10 – F501 Sources and Uses of Funds (10 Year) 11. Attach 11 - Tech Plan 2022-2031 Projects by Department (10 Year) 12. Attach 12 –F502 Trunk Reserve Sources and Uses of Funds (10 Year) CITY OF PRIOR LAKE Trunk Fund F502 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected REVENUE AND OTHER SOURCES Charges for services 580,000 597,000 769,000 792,000 1,019,000 1,050,000 1,082,000 1,114,000 1,147,000 1,119,516 Investment income 186,308 125,207 106,864 74,920 96,816 118,489 146,385 175,597 206,306 238,546 Total Revenues and Other Fund Sources 766,308 722,207 875,864 866,920 1,115,816 1,168,489 1,228,385 1,289,597 1,353,306 1,358,062 EXPENDITURES AND OTHER USES Capital Outlay (1,500,000) (2,000,000) - - - - - - - - Total Expenditures and Other Uses (1,500,000) (2,000,000) - - - - - - - - CHANGE IN FUND BALANCE (733,692) (1,277,793) 875,864 866,920 1,115,816 1,168,489 1,228,385 1,289,597 1,353,306 1,358,062 Beginning Fund Balance 5,008,270 4,274,578 2,996,784 3,872,649 4,739,569 5,855,385 7,023,874 8,252,259 9,541,855 10,895,162 Ending Fund Balance 4,274,578 2,996,784 3,872,649 4,739,569 5,855,385 7,023,874 8,252,259 9,541,855 10,895,162 12,253,224 2027 through 2036 Revolving Equipment Fund (410) Prior Lake, MN Projects By Department Department Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Total Building Inspection 1/2 Ton Pickup 6394 60,000 60,000 Pickup 1/2 Ton 6395 60,000 60,000 Truck 1/2 Ton 6398 60,000 60,000 Truck-1/2 Ton 6397 55,000 55,000 Building Inspection Total 0 0 0 60,000 120,000 0 0 0 0 55,000 235,000 Central Garage Fuel Island Pedestal and Software 9900 20,000 20,000 Plasma Cutter 8921 4,500 4,500 Refurbishing REFUR 20,000 20,000 20,000 20,000 20,000 20,000 20,000 25,000 25,000 25,000 215,000 Welder 8920 10,500 10,500 Central Garage Total 20,000 20,000 20,000 35,000 20,000 40,000 20,000 25,000 25,000 25,000 250,000 Engineering 1/2 Ton Pickup 6396 55,000 55,000 Truck-1 Ton 6399 60,000 60,000 Engineering Total 0 0 60,000 0 0 0 0 0 0 55,000 115,000 Fire 1/2 Ton Crew Cab - Chief 2 Tahoe 9201 45,000 45,000 Chief 1 Tahoe 9200 70,000 70,000 Fire Ladder Truck 9280 1,369,540 1,369,540 Fire Radios FD-RADIOS 67,500 67,500 Fire Truck Heavy Rescue (Refurbish) 9216 0 0 Fire Truck Pumper 9222 300,000 1,000,000 1,300,000 Generator - FS2 GEN-FS2 130,000 130,000 Pressure Washer - FS1 8002 20,000 20,000 Pressure Washer - FS2 8003 20,000 20,000 UTV 9275 47,000 47,000 Fire Total 1,669,540 1,000,000 20,000 87,500 0 0 130,000 45,000 47,000 70,000 3,069,040 Parks Aerator 8262 9,000 9,000 Produced Using Plan-It CIP Software Department Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Total Aerovator 8265 16,000 16,000 Electric Scissor Lift 8551 25,000 25,000 Fertilizer Spreader 8267 8,500 8,500 Forklift 8558 46,500 46,500 Landpride Drop Seeder 8264 16,000 16,000 Mower-16FT 8504 175,000 175,000 Mower-6 FT 8522 50,000 50,000 Mower-6FT 8525 62,000 62,000 Mower-6FT 8526 62,000 62,000 Mower-6FT 8523 68,000 68,000 Mower-6FT 8524 62,000 62,000 Mower Walk Behind 8511 8,500 8,500 Pickup 1/2 Ton 8541 60,000 60,000 Pick-Up 1/2 Ton 8319 60,000 60,000 Scissor Lift Drop Deck Trailer 8552 16,000 16,000 Sidewalk Plow 8513 165,000 165,000 Skid Steer Combo Plane 8279 5,000 5,000 Skid Steer Snow Bucket 8253 3,000 3,000 Skid Steer Snow Bucket 8250 3,000 3,000 Skid Steer - Tracks 8502 87,000 80,000 167,000 Skid Steer U-Blade 8260 2,000 2,000 Skid Steer - Wheels 8501 113,000 80,000 193,000 Sod Cutter 8512 6,000 6,000 Stump Grinder 8272 12,000 12,000 Tiller 8268 9,000 9,000 Top Dresser 8273 20,000 20,000 Tractor 8505 150,000 150,000 Tractor Snow Blower 8270 14,500 14,500 Tractor w Pull Behind Mower 8503 175,000 175,000 Trail Blower 8278 7,500 7,500 Trailer 8531 17,500 17,500 Trailer 8532 22,000 22,000 Trailer-Small 8530 6,000 6,000 Trailer-Small Enclosed (REC) 8529 5,000 5,000 Trailer-Small (IRRIG) 8554 8,000 8,000 Truck-1/2 Ton (Facilities) 8542 55,000 55,000 Truck 1/2 Ton - Sanitation 8508 115,000 115,000 Truck-1 Ton 8544 80,000 80,000 Produced Using Plan-It CIP Software Department Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Total Truck-1 Ton 8543 80,000 80,000 Truck-1 Ton 8545 110,000 110,000 Truck 1 Ton Dump 8546 120,000 120,000 Utility Vehicle 8536 35,000 35,000 Utility Vehicle 8539 35,000 35,000 Utility Vehicle-Field Groomer 8537 35,000 35,000 Utility Vehicle-Striper 8535 80,000 80,000 Utility Vehicle-Water Tank 8538 35,000 35,000 Woodchipper 8510 95,000 95,000 Parks Total 546,500 204,000 273,500 40,500 368,500 77,000 402,000 430,000 147,000 121,000 2,610,000 Police 2007 Siren@1500 Spring Lake Cir., Jordan PD-Siren15 46,600 46,600 Chief 7131 55,000 55,000 Commander 7136 50,000 50,000 CSO Truck 7130 45,000 45,000 Drug Task Force Car 7298 55,000 55,000 Evidence Tech 7139 55,000 55,000 Investigator 7134 55,000 55,000 Investigator 7137 55,000 55,000 Polaris XP 1000 Crew 7138 42,000 42,000 Speed Sign Trailer 7200 15,000 15,000 Squad New 7116 71,000 71,000 Squads-Marked Multiple 3 284,000 308,000 340,000 932,000 Squads-Marked Multiple 2 138,000 300,000 324,000 356,000 1,118,000 Squads-Marked Multiple 1 292,000 316,000 348,000 956,000 SWAT Van 7133 250,000 250,000 Police Total 184,600 660,000 362,000 355,000 405,000 361,000 324,000 395,000 348,000 406,000 3,800,600 Streets Asphalt Roller 8474 58,000 58,000 F350 Super Cab 4X4 8494 65,000 65,000 Generator - MC GEN-MC 130,000 130,000 Hook Truck 8521 180,000 235,000 415,000 Hot Patcher 8429 68,000 68,000 Loader Wheel 8789 360,000 360,000 Loader-Wheel 8488 300,000 300,000 Message Board 8275 16,000 16,000 Produced Using Plan-It CIP Software Department Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Total Pickup 1.5 Ton Dump 8550 150,000 150,000 Pressure Washer - Portable 8001 20,000 20,000 Pressure Washer - Wash Bay 8000 20,000 20,000 Sign Board 8426 25,000 25,000 Skid Steer 8781 110,000 110,000 Skid Steer Asphalt Mill 8258 38,000 38,000 Skid Steer Box Broom 8255 8,000 8,000 Skid Steer Jack Hammer 8280 10,000 10,000 Skid Steer Post Hole Auger 8252 5,000 5,000 Skid Steer Rock Bucket 8251 2,500 2,500 Standby Generator - CH GEN-CH 150,000 150,000 Street Sweeper-Mechanical 8472 350,000 350,000 Street Sweeper-Regenerative 8471 400,000 400,000 Trailer 8482 18,000 18,000 Trailer 8479 25,000 25,000 Trailer 8480 25,000 25,000 Trailer Crash Attenuator 8483 32,000 32,000 Truck 1.5 Ton Dump 8459 150,000 150,000 Truck-1.5 Ton-Dump 8452 145,000 145,000 Truck-1 Ton 8457 75,000 75,000 Truck-1 Ton 8453 65,000 65,000 Truck 1 Ton - Signs 8450 160,000 160,000 Truck 5 Ton Dump 8470 170,000 260,000 430,000 Truck-5 Ton-Dump 8468 185,000 230,000 415,000 Truck-5 Ton-Dump 8469 155,000 233,000 388,000 Truck 5 Ton Dump Single Axle 8518 185,000 250,000 435,000 Truck-5 Ton-Dump-Single Axle 8467 225,000 225,000 Truck-5 Ton-Dump-Single Axle 8466 150,000 150,000 Truck-9 Ton Dump Tandem 8465 180,000 235,000 415,000 Truck-9 Ton-Dump-Tandem 8464 220,000 220,000 Truck 9 Ton Dump Tandem Axle 8519 200,000 250,000 450,000 Streets Total 765,000 851,000 272,000 615,500 810,000 630,000 510,000 543,000 910,000 617,000 6,523,500 GRAND TOTAL 3,185,640 2,735,000 1,007,500 1,193,500 1,723,500 1,108,000 1,386,000 1,438,000 1,477,000 1,349,000 16,603,140 Produced Using Plan-It CIP Software CITY OF PRIOR LAKE Construction Fund F501 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected REVENUE AND OTHER SOURCES Franchise fees 1,302,000 1,478,000 1,488,000 1,499,000 1,702,000 1,716,000 1,734,000 1,752,000 1,771,000 1,789,000 Intergovernmental 140,000 - - 1,250,000 - - - - - - Intergovernmental MSA 1,090,000 1,106,400 1,123,000 1,139,800 1,156,900 1,174,300 1,191,900 1,209,800 1,227,900 1,246,300 Investment income 56,700 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 Other financing sources - - - 325,000 - - - - - - Bonds issued (incl prem/disc) city portion 2,033,000 2,164,000 2,302,000 1,575,000 695,000 3,470,000 5,411,000 11,946,000 7,233,000 4,309,000 Bonds issued (incl prem/disc) assessment portion 862,000 646,000 1,913,000 - - - 1,134,000 2,519,000 1,592,000 1,671,000 Transfers in Water Fund (F601)1,201,000 2,554,000 2,253,000 - - - 1,362,000 3,320,000 1,865,000 1,946,000 Water Quality Fund (F602)589,000 473,000 937,000 - - - 705,000 1,630,000 1,165,000 1,216,000 Sewer Fund (F604)1,059,000 1,533,000 2,120,000 - - - 1,161,000 2,581,000 1,631,000 2,458,000 Other Funds 762,000 - - - - - - - - - Total Revenues and Other Fund Sources 9,094,700 10,004,400 12,186,000 5,838,800 3,603,900 6,410,300 12,748,900 25,007,800 16,534,900 14,685,300 EXPENDITURES AND OTHER USES Capital Outlay (8,472,000) (8,887,000) (13,198,000) (3,104,000) (995,000) (5,371,000) (10,784,000) (22,576,000) (15,431,000) (14,927,000) Cost of issuance of bonds (85,000) (83,000) (121,000) (46,000) (19,000) (99,000) (189,000) (420,000) (255,000) (173,000) Paid to General Fund for engineering (185,000) (185,000) (185,000) (185,000) (185,000) (185,000) (185,000) (185,000) (185,000) (185,000) Transfers out to PIR Fund (F450)- (400,000) - (1,709,000) - - - (4,956,553) - - Total Expenditures and Other Uses (8,742,000) (9,555,000) (13,504,000) (5,044,000) (1,199,000) (5,655,000) (11,158,000) (28,137,553) (15,871,000) (15,285,000) CHANGE IN FUND BALANCE 352,700 449,400 (1,318,000) 794,800 2,404,900 755,300 1,590,900 (3,129,753) 663,900 (599,700) Beginning Fund Balance 550,199 902,899 1,352,299 34,299 829,099 3,233,999 3,989,299 5,580,199 2,450,446 3,114,346 Ending Fund Balance 902,899 1,352,299 34,299 829,099 3,233,999 3,989,299 5,580,199 2,450,446 3,114,346 2,514,646 2027 through 2036 Technology (101) Prior Lake, MN Projects By Department Department Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Total Cable Chambers Cameras and Mics COMM-005 10,000 8,000 18,000 Tricaster / Streaming Replacement COMM-002 30,000 30,000 Cable Total 10,000 8,000 0 0 30,000 0 0 0 0 0 48,000 Elections Tabulators - qty 2 ELEC-002 115,000 115,000 Elections Total 0 0 0 0 115,000 0 0 0 0 0 115,000 Technology Firewall Replacement TECH-NW-001 5,000 5,000 General Equipment Contingency TECH-EQ-001 10,000 25,000 25,000 25,000 85,000 HP DesignJet T1500 - CD/Eng TECH-EQ-009 10,000 10,000 Marco Phone Upgrade TECH-EQ-012 50,000 50,000 Ricoh MP C2504 Fire TECH-EQ-008 11,000 11,000 Ricoh MP C4503 - CD/Eng TECH-EQ-003 11,000 11,000 Ricoh MP C4504 - Admin TECH-EQ-005 13,000 13,000 Technology Total 13,000 66,000 10,000 0 21,000 25,000 25,000 25,000 0 0 185,000 GRAND TOTAL 23,000 74,000 10,000 0 166,000 25,000 25,000 25,000 0 0 348,000 Produced Using Plan-It CIP Software CITY OF PRIOR LAKE Revolving Equip Fund F410 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected REVENUE AND OTHER SOURCES Taxes 1,025,000 1,075,000 1,145,000 1,195,000 1,245,000 1,295,000 1,345,000 1,345,000 1,345,000 1,395,000 Investment income 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 Bonds issued (incl prem/disc) city portion 2,265,000 1,545,000 - - - - - - - - Transfers in Water Fund (F601)- - - - 36,667 5,000 - - - - Water Quality Fund (F602 - 200,000 - - - 5,000 - - 175,000 - Sewer Fund (F604)- - - - 36,667 5,000 - - - - Sale of capital assets - - - - - - - - - - Total Revenues and Other Fund Sources 3,310,000 2,840,000 1,165,000 1,215,000 1,338,334 1,330,000 1,365,000 1,365,000 1,540,000 1,415,000 EXPENDITURES AND OTHER USES Capital Outlay (3,185,640) (2,735,000) (1,007,500) (1,193,500) (1,723,500) (1,108,000) (1,386,000) (1,438,000) (1,477,000) (1,349,000) Cost of issuance of bonds (65,000) (45,000) - - - - - - - - Total Expenditures and Other Uses (3,250,640) (2,780,000) (1,007,500) (1,193,500) (1,723,500) (1,108,000) (1,386,000) (1,438,000) (1,477,000) (1,349,000) CHANGE IN FUND BALANCE 59,360 60,000 157,500 21,500 (385,166) 222,000 (21,000) (73,000) 63,000 66,000 Beginning Fund Balance 383,154 442,514 502,514 660,014 681,514 296,348 518,348 497,348 424,348 487,348 Ending Fund Balance 442,514 502,514 660,014 681,514 296,348 518,348 497,348 424,348 487,348 553,348 PriorLakeMN.gov Rick SteinhausLori OlsonLiam DugganNicole KleknerNick Monserud IMPROVEMENT PROGRAM2031 CAPITAL -2027 PriorLakeMN.gov2 CIP2031 -: Public Hearing and Adopt 2027August 12•debt service): Financial Plan with CIP Impacts (tax levy & July 28•: Capital Plans ReviewJune 23•2031 CIP Schedule-2027 PriorLakeMN.gov3 Water Quality Financial Plan•Sanitary Sewer Financial Plan•Water Financial Plan•Separate discussion at 7/28 work session–Utility Funds 6)Pavement Management Plan5)Technology Plan4)Facilities Management Plan3)Park Plan2)Equipment Replacement Plan1)2031 CIP Schedule-2027 PriorLakeMN.gov4 An incremental tax levy increase to accommodate our replacement needs•additional street maintenance trucks.replacements (ladder truck in 2027 and pumper truck in 2028) and The updated financing plan includes debt issuance of $3.8M for fire truck •The annualized cost of the equipment replacement is $1.7M. •Shifted replacement years whenever possible to smooth the levy impact•Updated vehicle costs and inflationary factors•Reviewed equipment for condition, safety and functionality•Equipment Replacement Plan PriorLakeMN.gov5 Equipment Replacement Plan PriorLakeMN.gov6 capital maintenance and replacement needs.The plan includes a phased increase in the tax levy to accommodate our •in 2025.discussions are ongoing with the failure of the park referendum funding Parks •city’s future needs and location of new parks. plan includes current parks and proposed changes/updates as well as the Council approval of the Park and Trail System Plan on March 12, 2024. This •Park Plan PriorLakeMN.gov7 Capital Park and Revolving Park Funds PriorLakeMN.gov8 Year)-Park Plan (5 PriorLakeMN.gov9 ParkRyanThomasatremodelBathroom•enhancementsParking/safety•updatesHVAC•roofingMembrane•:includerepairsThese.LibraryandStationPoliceHall,CityforrepairsfacilitymajorforCIPyear-fivetheo verM2.11$ofBondsIssue•facility maintenance and replacement needsThe plan includes a phased increase in the tax levy to accommodate our •Plans for major maintenance and replacements•Facilities Management Plan PriorLakeMN.gov10 Facility Management Plan PriorLakeMN.gov11 Technology Plan Pavement ManagementPlan PriorLakeMN.gov13 Pavement Management Plan Map PriorLakeMN.gov.sizesmeterandusagetheironbasedpayindustrialandCommercial.electric)60.5$andgas60.5$(monthper20.11$isfee2026The•.(CCI)IndexConstructionCommercialtheperincreasesinflationaryaddressto”202 5“payforupdatedwereThey.yearsthreeeveryreviewedarefeesfranchiseThe.CIPyear-fivetheforM/year5.1$aboutofrevenuefeefranchiseelectricandgasannualincludesmanagementpavementforFunding•14 Pavement Management Plan PriorLakeMN.gov15 Tax LevyAdopt Preliminary Budgets and –September 22 •2031 CIP-CIP Public Hearing and Adopt 2027–August 12 •debt impacts, and proposed utility ratesBudget Workshop including CIP tax levy, –July 28 •Next Steps –Council Discussion Questions/Discussion 2027 through 2036 Capital Parks / Revolving Parks (225/430) Prior Lake, MN Projects By Category Category Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Total New Park Development Athletic Complex 225-003 0 0 Future Neighborhood Park Development 225-001 550,000 550,000 1,100,000 TH 13 Trail Segment 2 (150th St to Candy Cove) PRK26-000001 1,600,000 1,600,000 New Park Development Total 1,600,000 0 550,000 0 0 0 550,000 0 0 0 2,700,000 Park Replacement Boardwalk Replacement 430-080 1,800,000 1,800,000 Boudins BB Court Maintenance 430-006 20,000 20,000 Crystal Lake Fishing Pier 430-049 80,000 80,000 Eagle Brook BB Court Maintenance 430-072 15,000 20,000 35,000 Eagle Brook Picnic Shelter 430-073 30,000 30,000 Enclave BB Court Maintenance 430-050 15,000 20,000 35,000 Green Oaks BB Court Maintenance 430-075 10,000 10,000 Green Oaks Picnic Shelter 430-017 20,000 20,000 Howard Lake BB Court Maintenance 430-051 15,000 20,000 35,000 Jeffers BB Court Maintenance 430-076 20,000 20,000 Jeffers Picnic Shelter 430-077 30,000 30,000 Knob Hill BB Court Maintenance 430-001 20,000 25,000 45,000 Memorial Backstop, Batters Eye, Cages, Dugouts 430-056 265,000 265,000 Memorial BB Court Maintenance 430-004 22,000 25,000 47,000 Memorial Concession Building 430-057 250,000 250,000 Memorial Drinking Fountain 430-052 12,000 12,000 Memorial Parking Lots (2) 430-039 350,000 350,000 Memorial Windscreen 430-025 7,000 7,000 Misc Playground PLAY 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 2,500,000 Northwood Meadows BB Court Maintenance 430-047 15,000 15,000 Oakland BB Court Maintenance 430-007 22,000 22,000 Ponds Parking Lots (4), Entrance Road 430-069 75,000 2,500,000 2,575,000 Produced Using Plan-It CIP Software Category Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Total Ryan Backstop, Batters Eye, Cages, Dugouts 430-059 250,000 250,000 Ryan BB Court Maintenance 430-036 32,000 32,000 Sand Point BB Court Maintenance 430-027 10,000 10,000 Sand Point Beach Renovation Study 430-030 100,000 100,000 Spring Lake Pickleball Courts 430-060 40,000 50,000 90,000 Timbercrest BB Court Maintenance 430-037 10,000 10,000 Watzls City Docks 430-043 150,000 150,000 Watzls Lighting 430-063 8,500 8,500 Wilds BB Court Maintenance 430-048 20,000 20,000 Wilds North BB Court Maintenance 430-010 15,000 15,000 Willows BB Court Maintenance 430-011 20,000 20,000 Woodridge Ballfield 430-054 20,000 20,000 Park Replacement Total 630,000 4,136,000 327,000 283,500 290,000 282,000 270,000 2,110,000 350,000 250,000 8,928,500 GRAND TOTAL 2,230,000 4,136,000 877,000 283,500 290,000 282,000 820,000 2,110,000 350,000 250,000 11,628,500 Produced Using Plan-It CIP Software CITY OF PRIOR LAKE Capital Park Fund F225 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected REVENUE AND OTHER SOURCES Intergovernmental 850,000 - - - - - - - - - Charges for services 308,800 318,400 410,000 422,000 543,750 560,000 576,250 593,750 611,250 468,750 Lease income 32,000 32,000 32,000 32,000 32,000 32,000 32,000 32,000 32,000 32,000 Investment income 6,191 12,531 6,066 14,999 12,311 23,896 38,457 53,714 55,992 72,839 Total Revenues and Other Fund Sources 1,196,991 362,931 448,066 468,999 588,061 615,896 646,707 679,464 699,242 573,589 EXPENDITURES AND OTHER USES Capital Outlay (1,600,000) - (550,000) - - - (550,000) - - - Other uses (5,600) (5,600) (5,600) (5,600) (5,600) (5,600) (5,600) (5,600) (5,600) - Total Expenditures and Other Uses (1,605,600) (5,600) (555,600) (5,600) (5,600) (5,600) (555,600) (5,600) (5,600) - CHANGE IN FUND BALANCE (408,609) 357,331 (107,534) 463,399 582,461 610,296 91,107 673,864 693,642 573,589 Beginning Fund Balance 1,077,636 669,027 1,026,358 918,824 1,382,223 1,964,683 2,574,979 2,666,086 3,339,950 4,033,592 Ending Fund Balance 669,027 1,026,358 918,824 1,382,223 1,964,683 2,574,979 2,666,086 3,339,950 4,033,592 4,607,181 CITY OF PRIOR LAKE Revolving Park Equip Fund F430 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected REVENUE AND OTHER SOURCES Taxes 655,000 705,000 755,000 805,000 855,000 905,000 955,000 955,000 955,000 955,000 Intergovernmental 283,600 - - - - - - - - - Investment income 5,519 8,912 3,425 6,123 16,908 30,099 44,647 60,974 79,215 51,990 Miscellaneous 200,000 - - - - - - - - - Bonds issued (incl prem/disc) city portion - 3,500,000 - - - - - - - - Total Revenues and Other Fund Sources 1,144,119 4,213,912 758,425 811,123 871,908 935,099 999,647 1,015,974 1,034,215 1,006,990 EXPENDITURES AND OTHER USES Capital Outlay (630,000) (4,136,000) (327,000) (283,500) (290,000) (282,000) (270,000) (2,110,000) (350,000) (250,000) Cost of issuance of bonds - (100,000) - - - - - - - - Total Expenditures and Other Uses (630,000) (4,236,000) (327,000) (283,500) (290,000) (282,000) (270,000) (2,110,000) (350,000) (250,000) CHANGE IN FUND BALANCE 514,119 (22,088) 431,425 527,623 581,908 653,099 729,647 (1,094,026) 684,215 756,990 Beginning Fund Balance 236,761 750,880 728,792 1,160,217 1,687,840 2,269,748 2,922,847 3,652,493 2,558,467 3,242,682 Ending Fund Balance 750,880 728,792 1,160,217 1,687,840 2,269,748 2,922,847 3,652,493 2,558,467 3,242,682 3,999,672 2027 through 2036 Facilities Managment Fund (440) Prior Lake, MN Projects by Category And Department Department Category Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Total Facilities Facil: City Hall Emergency Repairs - All Bldgs 440-208 150,000 150,000 150,000 150,000 150,000 150,000 150,000 150,000 150,000 150,000 1,500,000 Project Development for 2028 Imp 440-189 79,000 111,000 190,000 Lighting Repairs 440-236 35,000 35,000 Roof Safety Ladders 2 440-235 20,000 20,000 Bathroom Remodel - Main Level 440-216 350,000 350,000 Carpet 440-038 250,000 250,000 Air Handler (2) 440-094 250,000 250,000 BAS Upgrade 440-215 210,000 210,000 Chiller 440-095 175,000 175,000 Chiller Primary Pumps 440-213 120,000 120,000 Retaining Wall 440-205 75,000 75,000 Chiller Pipe to AHU Coils 440-238 75,000 75,000 Brick Wallcovering / Cherrywood Paneling 440-088 35,000 35,000 SIdewalk Repairs 440-237 35,000 35,000 Chiller Secondary Pumps 440-214 30,000 30,000 Stairwell Flooring 440-240 20,000 20,000 Epoxy Mechanical Room Floors 440-239 20,000 20,000 Coiling Doors 440-037 16,500 16,500 Greenheck Exhaust (2) 440-093 14,000 14,000 Glass Doors 440-034 12,000 12,000 Miscellaneous 440-096 7,000 7,000 Membrane Roofing 440-017 540,000 540,000 Patio Replacement 440-242 45,000 45,000 Re-Key/New Locksets 440-241 40,000 40,000 Secured Entry Card Reader System 440-190 10,000 10,000 20,000 Emergency Lighting 440-209 35,000 35,000 Produced Using Plan-It CIP Software Department Category Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Total Lighting Fixtures (interior/exterior) 440-097 279,000 279,000 Parking Lot / Sidewalks 440-098 150,000 150,000 Steel Door and Frames 440-099 30,000 30,000 Wall Coverings 440-008 70,000 70,000 Resiliant Flooring 440-089 30,000 30,000 Bell and Gosset Pumps (2) 440-091 70,000 70,000 Facil: City Hall Total 284,000 1,955,500 785,000 185,000 609,000 250,000 150,000 230,000 150,000 150,000 4,748,500 Facil: City Owned Properties Pike Lake House Demolition 440-264 70,000 70,000 Lakeside Eats & Treats Roof 440-265 16,000 16,000 Auto Shop Roof Repairs 440-266 5,000 5,000 Facil: City Owned Properties Total 91,000 0 0 0 0 0 0 0 0 0 91,000 Facil: Fire Station #1 Re-Key/New Locksets 440-267 20,000 20,000 Infrared Heaters 440-071 180,000 180,000 Rooftop Unit 440-072 171,000 171,000 Windows - Aluminum 440-084 70,000 70,000 Trash Enclosure 440-122 3,500 3,500 Membrane Roofing 440-073 290,000 290,000 Epoxy Flooring 440-002 150,000 150,000 Facil: Fire Station #1 Total 0 0 20,000 424,500 290,000 0 0 0 150,000 0 884,500 Facil: Fire Station #2 Dorm Project Development 440-268 75,000 75,000 Make-Up Air Unit 440-125 60,000 60,000 Air Exchanger 440-124 20,000 20,000 Exhaust Fan (2) 440-123 15,000 15,000 Dorm Project 440-269 600,000 600,000 Re-Key/New Locksets 440-270 20,000 20,000 Miscellaneous 440-126 14,000 14,000 Epoxy Flooring 440-059 82,000 82,000 Overhead Doors 14x14 440-056 32,500 32,500 Gas Monitor (2) 440-127 15,000 15,000 Irrigation System 440-055 14,000 14,000 Pressure Washer (2 Stations) 440-057 11,500 11,500 Carpet 440-012 40,000 40,000 Produced Using Plan-It CIP Software Department Category Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Total Forced Air Furnace (3) 440-024 15,000 15,000 Membrane Roofing 440-039 120,000 120,000 Infrared Heaters 440-271 150,000 150,000 AC Units 440-272 65,000 65,000 Facil: Fire Station #2 Total 170,000 600,000 34,000 155,000 55,000 120,000 150,000 65,000 0 0 1,349,000 Facil: Library & Club Prior Project Development for 2029 Imp 440-226 66,760 66,760 78,000 211,520 Light Fixtures 440-065 40,000 63,000 103,000 Membrane Roofing 440-252 360,000 360,000 Restroom Remodel 440-254 250,000 250,000 Building Automation System 440-251 175,000 175,000 Air Handling Unit - McQuay 440-114 125,000 125,000 Air Handling Unit - Trane 440-110 125,000 125,000 Carpet 440-256 120,000 120,000 Metal Roofing Re-Caulk 440-253 100,000 100,000 Condensing Unit 440-064 75,000 75,000 Re-Key/New Locksets 440-255 30,000 30,000 Humidifiers (2) 440-115 30,000 30,000 Wall Coverings 440-113 25,000 25,000 Tile Walls 440-067 20,000 20,000 Secured Entry Card Reader System 440-194 10,000 10,000 20,000 Restroom Exhaust Fan 440-111 5,500 5,500 Facil: Library & Club Prior Total 106,760 66,760 1,591,500 0 0 0 0 10,000 0 0 1,775,020 Facil: Maintenance Ctr. Secured Entry Card Reader System 440-198 10,000 10,000 20,000 Maintenance Center Expansion 440-186 1,000,000 2,000,000 42,000,000 45,000,000 Facil: Maintenance Ctr. Total 0 0 10,000 1,000,000 2,000,000 42,000,000 0 10,000 0 0 45,020,000 Facil: Park Amenities Ryan Park Bathroom Remodel 430-082 750,000 750,000 Lakefront Roof Replacement 440-258 175,000 175,000 Lakefront Paint Exterior 440-259 50,000 50,000 Re-Key/New Locksets 440-262 30,000 30,000 Ponds Doors 440-257 30,000 30,000 Lakefront Flooring 440-261 30,000 30,000 Lakefront Door and Locks 440-260 25,000 25,000 Produced Using Plan-It CIP Software Department Category Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Total Lakefront Upper Restroom Door 440-263 25,000 25,000 HVAC System Replacement 440-197 50,000 50,000 Banquet Tables and Chairs 440-195 20,000 20,000 Facil: Park Amenities Total 1,090,000 25,000 0 0 0 50,000 0 0 20,000 0 1,185,000 Facil: Police Station Epoxy Flooring 440-107 85,000 85,000 Space Needs Study 440-243 75,000 75,000 Gym Flooring 440-244 55,000 55,000 Project Development for 2026 Imp 440-192 49,000 49,000 98,000 Roof Safety Ladders 2 440-245 20,000 20,000 Stairwell Flooring 440-247 15,000 15,000 Dato Closet Split Unit 440-246 14,000 14,000 Locker Room Remodel 440-049 250,000 250,000 Bathroom Remodel - 3 440-222 225,000 225,000 Carpet 440-185 225,000 225,000 VAV Boxes 440-106 208,000 208,000 Building Automation System 440-248 175,000 175,000 Boilers 440-075 150,000 150,000 Front Entry Security Update 440-101 125,000 125,000 Air Handler - McQuay 440-104 85,000 85,000 Greenheck Exhaust (2) 440-103 25,000 25,000 Bell and Gosset Pump 440-102 25,000 25,000 Epoxy Mechanical Room Floors 440-249 20,000 20,000 Overhead Coiling Door (2) 440-047 18,000 18,000 Re-Key/New Locksets 440-250 40,000 40,000 Secured Entry Card Reader System 440-193 10,000 10,000 20,000 Membrane Roofing 440-029 350,000 350,000 Parking / Safety Enhancements 440-087 300,000 300,000 Light Fixtures 440-045 140,000 140,000 Parking Lot / Sidewalks 440-108 87,000 87,000 Steel Doors and Frames 440-109 50,000 50,000 Wall Coverings 440-191 50,000 50,000 Produced Using Plan-It CIP Software Department Category Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Total Irrigation System 440-082 50,000 50,000 Facil: Police Station Total 313,000 1,580,000 50,000 650,000 277,000 50,000 0 60,000 0 0 2,980,000 Facilities Total 2,054,760 4,227,260 2,490,500 2,414,500 3,231,000 42,470,000 300,000 375,000 320,000 150,000 58,033,020 GRAND TOTAL 2,054,760 4,227,260 2,490,500 2,414,500 3,231,000 42,470,000 300,000 375,000 320,000 150,000 58,033,020 Produced Using Plan-It CIP Software CITY OF PRIOR LAKE Facilities Mgmt Fund F440 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected REVENUE AND OTHER SOURCES Taxes 355,000 405,000 455,000 505,000 555,000 605,000 625,000 650,000 650,000 650,000 Investment income 21,400 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 Bonds issued (incl prem/disc) city portion 515,000 3,915,000 2,165,000 2,060,000 2,575,000 32,960,000 - - - - Transfers in Water Fund (F601)- - - - - 5,000,000 - - - - Sewer Fund (F604)- - - - - 5,000,000 - - - - General fund (F101 reserves)230,000 - - - - - - - - - Total Revenues and Other Fund Sources 1,121,400 4,340,000 2,640,000 2,585,000 3,150,000 43,585,000 645,000 670,000 670,000 670,000 EXPENDITURES AND OTHER USES Capital Outlay (2,154,760) (4,227,260) (2,490,500) (2,414,500) (3,231,000) (42,470,000) (300,000) (375,000) (320,000) (150,000) Cost of issuance of bonds (15,000) (115,000) (65,000) (60,000) (75,000) (960,000) - - - - Other uses - - - (10,000) - - - - - - Total Expenditures and Other Uses (2,169,760) (4,342,260) (2,555,500) (2,484,500) (3,306,000) (43,430,000) (300,000) (375,000) (320,000) (150,000) CHANGE IN FUND BALANCE (1,048,360) (2,260) 84,500 100,500 (156,000) 155,000 345,000 295,000 350,000 520,000 Beginning Fund Balance 1,165,085 116,725 114,465 198,965 299,465 143,465 298,465 643,465 938,465 1,288,465 Ending Fund Balance 116,725 114,465 198,965 299,465 143,465 298,465 643,465 938,465 1,288,465 1,808,465 2027 through 2036 Pavement Management Plan Prior Lake, MN Projects & Funding Sources By Department Department Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Total Streets: Transportation Northwood Phase 2 TRN27-000001 4,779,000 0 0 0 0 0 0 0 0 0 4,779,000 Franchise Fees 1,151,000 1,151,000 Utility: Sewer Fund (F604) 1,059,000 1,059,000 Utility: Water Fund (F601) 864,000 864,000 G.O. SA Bonds - Project Assessment 862,000 862,000 Utility: Storm Water Fund (F602) 589,000 589,000 G.O. SA Bonds - Project Levy 254,000 254,000 CR12 & CSAH 17 Intersection TRN27-000004 1,447,000 0 0 0 0 0 0 0 0 0 1,447,000 Storm Trunk Fund 762,000 762,000 City MSA Funds 450,000 450,000 Utility: Water Fund (F601) 135,000 135,000 G.O. SA Bonds - Project Levy 100,000 100,000 Green Heights TRN28-000001 657,000 7,772,000 0 0 0 0 0 0 0 0 8,429,000 G.O. SA Bonds - Project Levy 657,000 1,370,000 2,027,000 Utility: Water Fund (F601) 2,150,000 2,150,000 Franchise Fees 1,600,000 1,600,000 Utility: Sewer Fund (F604) 1,533,000 1,533,000 G.O. SA Bonds - Project Assessment 646,000 646,000 Utility: Storm Water Fund (F602) 473,000 473,000 Wilds Jeffers Sealcoat TRN27-000003 520,000 0 0 0 0 0 0 0 0 0 520,000 G.O. SA Bonds - Project Levy 520,000 520,000 Sunset Hills Area TRN29-000002 356,000 711,000 8,417,000 0 0 0 0 0 0 0 9,484,000 G.O. SA Bonds - Project Levy 356,000 711,000 2,156,000 3,223,000 Franchise Fees 1,400,000 1,400,000 City MSA Funds 1,100,000 1,100,000 G.O. SA Bonds - Project Assessment 1,088,000 1,088,000 Utility: Water Fund (F601) 1,069,000 1,069,000 Utility: Sewer Fund (F604) 936,000 936,000 Utility: Storm Water Fund (F602) 668,000 668,000 Lords Street Bridge Rehab TRN24-000002 300,000 0 0 0 0 0 0 0 0 0 300,000 Franchise Fees 160,000 160,000 Produced Using Plan-It CIP Software Department Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Total Grants/Other Contrib. 140,000 140,000 CSAH 17 Expansion TRN27-000002 211,000 0 0 0 0 0 0 0 0 0 211,000 City MSA Funds 150,000 150,000 G.O. SA Bonds - Project Levy 61,000 61,000 Northwood Phase 3 TRN29-000001 202,000 404,000 4,781,000 0 0 0 0 0 0 0 5,387,000 Utility: Water Fund (F601) 202,000 404,000 578,000 1,184,000 City MSA Funds 1,900,000 1,900,000 Utility: Sewer Fund (F604) 1,184,000 1,184,000 G.O. SA Bonds - Project Assessment 825,000 825,000 Utility: Storm Water Fund (F602) 269,000 269,000 G.O. SA Bonds - Project Levy 25,000 25,000 Berens Road Extension TRN30-000001 0 0 0 2,000,000 0 0 0 0 0 0 2,000,000 SMSC Cost Sharing 1,000,000 1,000,000 G.O. SA Bonds - Project Levy 750,000 750,000 County 250,000 250,000 180th St Paving TRN34-000002 0 0 0 945,000 0 0 0 0 0 0 945,000 G.O. SA Bonds - Project Levy 620,000 620,000 Developer - Upfront Costs 325,000 325,000 Carriage Hills Coachman Recon TRN34-000001 0 0 0 159,000 319,000 3,773,000 0 0 0 0 4,251,000 G.O. SA Bonds - Project Levy 159,000 319,000 1,773,000 2,251,000 City MSA Funds 2,000,000 2,000,000 Raspberry Ridge Neighborhood TRN31-000001 0 0 0 0 308,000 617,000 7,295,000 0 0 0 8,220,000 G.O. SA Bonds - Project Levy 308,000 617,000 2,572,000 3,497,000 Franchise Fees 1,200,000 1,200,000 Utility: Water Fund (F601) 1,067,000 1,067,000 Utility: Sewer Fund (F604) 934,000 934,000 G.O. SA Bonds - Project Assessment 855,000 855,000 Utility: Storm Water Fund (F602) 667,000 667,000 Big Woods Trail (CR82) TRN31-000003 0 0 0 0 216,000 0 0 0 0 0 216,000 City MSA Funds 216,000 216,000 Big Woods Trail (CR21) TRN31-000002 0 0 0 0 103,000 0 0 0 0 0 103,000 City MSA Funds 103,000 103,000 Frost Point Circle TRN25-000002 0 0 0 0 49,000 99,000 1,167,000 0 0 0 1,315,000 G.O. SA Bonds - Project Levy 49,000 99,000 328,000 476,000 Utility: Water Fund (F601) 295,000 295,000 G.O. SA Bonds - Project Assessment 279,000 279,000 Utility: Sewer Fund (F604) 227,000 227,000 Utility: Storm Water Fund (F602) 38,000 38,000 Produced Using Plan-It CIP Software Department Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Total Lords / Windsong Recon TRN32-000001 0 0 0 0 0 498,000 996,000 11,785,000 0 0 13,279,000 G.O. SA Bonds - Project Levy 498,000 996,000 4,533,000 6,027,000 Utility: Water Fund (F601) 2,306,000 2,306,000 Utility: Sewer Fund (F604) 1,694,000 1,694,000 G.O. SA Bonds - Project Assessment 1,256,000 1,256,000 Franchise Fees 1,000,000 1,000,000 Utility: Storm Water Fund (F602) 996,000 996,000 Village Lake/Tower TRN33-000001 0 0 0 0 0 384,000 768,000 9,089,000 0 0 10,241,000 G.O. SA Bonds - Project Levy 384,000 768,000 5,291,000 6,443,000 G.O. SA Bonds - Project Assessment 1,263,000 1,263,000 Utility: Water Fund (F601) 1,014,000 1,014,000 Utility: Sewer Fund (F604) 887,000 887,000 Utility: Storm Water Fund (F602) 634,000 634,000 Blind Lake Area TRN35-000001 0 0 0 0 0 0 558,000 1,117,000 13,216,000 0 14,891,000 G.O. SA Bonds - Project Levy 558,000 1,117,000 5,263,000 6,938,000 Utility: Water Fund (F601) 1,865,000 1,865,000 Franchise Fees 1,700,000 1,700,000 Utility: Sewer Fund (F604) 1,631,000 1,631,000 G.O. SA Bonds - Project Assessment 1,592,000 1,592,000 Utility: Storm Water Fund (F602) 1,165,000 1,165,000 Duluth/Anna Trail TRN36-000001 0 0 0 0 0 0 0 585,000 1,169,000 13,835,000 15,589,000 G.O. SA Bonds - Project Levy 585,000 1,169,000 3,044,000 4,798,000 City MSA Funds 3,500,000 3,500,000 Utility: Sewer Fund (F604) 2,458,000 2,458,000 Utility: Water Fund (F601) 1,946,000 1,946,000 G.O. SA Bonds - Project Assessment 1,671,000 1,671,000 Utility: Storm Water Fund (F602) 1,216,000 1,216,000 Colorado/Pleasant/Lakeside TRN37-000001 0 0 0 0 0 0 0 0 546,000 1,092,000 1,638,000 G.O. SA Bonds - Project Levy 546,000 1,092,000 1,638,000 Highway 13 Project (MnDOT) TRN35-000002 0 0 0 0 0 0 0 0 500,000 0 500,000 City MSA Funds 500,000 500,000 Streets: Transportation Expenditure Total 8,472,000 8,887,000 13,198,000 3,104,000 995,000 5,371,000 10,784,000 22,576,000 15,431,000 14,927,000 103,745,000 G.O. SA Bonds - Project Levy 1,948,000 2,081,000 2,181,000 1,529,000 676,000 3,371,000 5,222,000 11,526,000 6,978,000 4,136,000 39,648,000 Franchise Fees 1,311,000 1,600,000 1,400,000 1,200,000 1,000,000 1,700,000 8,211,000 Utility: Water Fund (F601) 1,201,000 2,554,000 1,647,000 1,362,000 3,320,000 1,865,000 1,946,000 13,895,000 Utility: Sewer Fund (F604) 1,059,000 1,533,000 2,120,000 1,161,000 2,581,000 1,631,000 2,458,000 12,543,000 G.O. SA Bonds - Project Assessment 862,000 646,000 1,913,000 1,134,000 2,519,000 1,592,000 1,671,000 10,337,000 Produced Using Plan-It CIP Software Department Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Total Storm Trunk Fund 762,000 762,000 City MSA Funds 600,000 3,000,000 319,000 2,000,000 500,000 3,500,000 9,919,000 Utility: Storm Water Fund (F602) 589,000 473,000 937,000 705,000 1,630,000 1,165,000 1,216,000 6,715,000 Grants/Other Contrib. 140,000 140,000 SMSC Cost Sharing 1,000,000 1,000,000 Developer - Upfront Costs 325,000 325,000 County 250,000 250,000 Streets: Transportation Sources Total 8,472,000 8,887,000 13,198,000 3,104,000 995,000 5,371,000 10,784,000 22,576,000 15,431,000 14,927,000 103,745,000 Streets: Overlay CR 42 M&O PIR28-000001 0 106,000 0 0 0 0 0 0 0 0 106,000 City MSA Funds 106,000 106,000 Fish Point Mill and Overlay PIR30-000002 0 0 0 1,418,000 0 0 0 0 0 0 1,418,000 Franchise Fees 517,000 517,000 City MSA Funds 500,000 500,000 G.O. SA Bonds - Overlay Assessment 401,000 401,000 Adelmann St Mill and Overlay PIR30-000001 0 0 0 517,000 0 0 0 0 0 0 517,000 Franchise Fees 295,000 295,000 G.O. SA Bonds - Overlay Assessment 222,000 222,000 Cleary Lake Area Mill and Overlay PIR34-000003 0 0 0 459,000 0 0 0 0 0 0 459,000 Construction Fund (F501) 397,000 397,000 G.O. SA Bonds - Overlay Assessment 62,000 62,000 Hickory Shores/Maple Glen Mill and Overlay PIR34-000002 0 0 0 0 0 3,953,000 0 0 0 0 3,953,000 Franchise Fees 3,460,000 3,460,000 G.O. SA Bonds - Overlay Assessment 493,000 493,000 Carriage Hills Coachman Mill and Overlay PIR34-000001 0 0 0 0 0 1,377,000 0 0 0 0 1,377,000 Franchise Fees 1,100,000 1,100,000 G.O. SA Bonds - Overlay Assessment 277,000 277,000 Five Hawks Mill and Overlay PIR36-000001 0 0 0 0 0 0 0 0 0 875,000 875,000 City MSA Funds 775,000 775,000 G.O. SA Bonds - Overlay Assessment 100,000 100,000 Streets: Overlay Expenditure Total 0 106,000 0 2,394,000 0 5,330,000 0 0 0 875,000 8,705,000 City MSA Funds 106,000 500,000 775,000 1,381,000 Franchise Fees 812,000 4,560,000 5,372,000 G.O. SA Bonds - Overlay Assessment 685,000 770,000 100,000 1,555,000 Produced Using Plan-It CIP Software Department Project # 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Total Construction Fund (F501) 397,000 397,000 Streets: Overlay Sources Total 0 106,000 0 2,394,000 0 5,330,000 0 0 0 875,000 8,705,000 EXPENDITURE GRAND TOTAL 8,472,000 8,993,000 13,198,000 5,498,000 995,000 10,701,000 10,784,000 22,576,000 15,431,000 15,802,000 112,450,000 Produced Using Plan-It CIP Software CITY OF PRIOR LAKE PIR Revolving Fund F450 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected REVENUE AND OTHER SOURCES Special assessments 202,839 193,883 184,927 242,398 155,659 346,824 246,437 235,939 225,441 148,903 Intergovernmental MSA - - - - - - - - - - Investment income 36,600 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 Bonds issued (incl prem/disc) assessment portion - - - 710,000 - 795,000 - - - 105,000 Transfers in Construction Fund (F501)- 400,000 - 1,709,000 - 4,560,000 - - - 775,000 Total Revenues and Other Fund Sources 239,439 613,883 204,927 2,681,398 175,659 5,721,824 266,437 255,939 245,441 1,048,903 EXPENDITURES AND OTHER USES Capital Outlay - (106,000) - (2,394,000) - (5,330,000) - - - (875,000) Cost of issuance of bonds - - - (25,000) - (25,000) - - - (5,000) Transfers out to debt service funds (419,908) (418,190) (419,880) (45,070) (203,880) (194,545) (147,415) (146,825) (354,556) (192,105) Total Expenditures and Other Uses (419,908) (524,190) (419,880) (2,464,070) (203,880) (5,549,545) (147,415) (146,825) (354,556) (1,072,105) CHANGE IN FUND BALANCE (180,469) 89,693 (214,953) 217,328 (28,221) 172,279 119,022 109,114 (109,115) (23,202) Beginning Fund Balance 312,934 132,465 222,158 7,205 224,533 196,312 368,591 487,613 596,727 487,612 Ending Fund Balance 132,465 222,158 7,205 224,533 196,312 368,591 487,613 596,727 487,612 464,410