Sewer and Water                         2018-2022                   Capital Improvements Program       Schedule for Five Year Period
             Special assessment Bonds = a                                      Abatement District = ad                             Olmsted County = c Electric Utility =  eu Federal Funds =  f Flood Control Reserves =  fr                                              
                     Food & Beverage Tax = fb                                          Local Gov't Aid = ga              General Obligation Bonds = go Lodging Tax =  lt MN State Aid - Streets =  ms Operating Trfs - fr Storm Water =  os                                              
       Operating Trfs-fr General Fund = ot                   Operating Trfs-fr Sewer Utility = ow                               Private Funds = p Project Reserves =  r GO Revenue Bonds =  rb Retained Earnings = re                                              
                                     State Funds = s                          Sn/Sewer Availability Chg = sa                              Sales Tax DMC = sd State DMC Funds =  sm Sales Tax 2013 =  st Storm Water Mgmt Chg =  sw                                              
                                          Tax Levy = t                     Traffic Improvement Dist Chg = td                                Tax Increments = ti Operating Trfs - fr Other Funds = to Water Availability Chg =  wa Water Utility =  wu                                              
 2002-2017
Sort Map # Project Description Proj # Total Budget CIP Bdgt Amts 2018 2019 2020 2021 2022 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 Totals
0                                -  
1 1 Annual - Sanitary sewer main replacement and rehabilitation.  Funding from Sewer Utility Retained Earnings. 2133            5,750,000          2,500,000 ow             500,000 ow             500,000 ow             500,000 ow             500,000 ow             500,000 ow ow  250,000  250,000   250,000    250,000    250,000    250,000        500,000        500,000           2,500,000
1               500,000 rb rb       250,000      250,000               500,000
1               250,000 re re    250,000               250,000
1                                -  
2 2 Annual - Watermain replacement in conjunction with street reconstruction projects.  2144            5,100,000          3,600,000 wu             300,000 wu             300,000 wu             300,000 wu             300,000 wu             300,000 wu wu  400,000  400,000       400,000      400,000    400,000    400,000    300,000    300,000        300,000        300,000           3,600,000
2                                -  
3 3 Annual - Infiltration and inflow rehabilitation to Public sanitary sewer system (pipe lining and manhole rehab).  Revenue Bonds to be repaid by Sewer Utility user rates. 2179          14,000,000          4,750,000 ow          1,000,000 ow          1,000,000 ow          1,000,000 ow          1,000,000 ow          1,000,000 ow ow  500,000  1,000,000    750,000    500,000     1,000,000     1,000,000           4,750,000
3            4,250,000 rb rb  2,500,000       750,000      750,000    250,000           4,250,000
3                                -  
4 4 Annual - Sanitary sewer replacement in conjunction with major streets CIP projects. Funding from Sewer Utility Retained Earnings.            1,600,000             600,000 ow             200,000 ow             200,000 ow             200,000 ow             200,000 ow             200,000 ow ow    200,000        200,000        200,000               600,000
4                                -  
5 5 Sanitary sewer flow monitor upgrades and repair. Funding from Sewer Utility Retained Earnings.                650,000             400,000 ow               50,000 ow               50,000 ow               50,000 ow               50,000 ow               50,000 ow ow    250,000      50,000          50,000          50,000               400,000
5                                -  
6 6 Sanitary sewer and watermain extensions to provide service to properties currently served by private wells and septic systems. Alternative Connection Charge Policy. Funding from Sewer Utility Retained Earnings.                800,000             200,000 a             100,000 re             100,000 re             100,000 re             100,000 re             100,000 re a    100,000        100,000               200,000
6               100,000 re re        100,000               100,000
6                                -  
7 7 Update City of Rochester Sanitary Sewer Master Plan and Sewer Modeling Program.  Current plan was last updated in 1996. 4340            1,500,000             500,000 rb             200,000 re             200,000 re             200,000 re             200,000 re             200,000 re rb        250,000        250,000               500,000
7                                  -  
8 8 Utility Upgrades / Replacements in old residential neighborhood areas.   Includes sanitary sewer and watermain upgrades.            15,000,000              1,200,000 ow          1,200,000 ow          1,200,000 ow          1,200,000 ow          1,200,000 ow
8                1,050,000 wu          1,050,000 wu          1,050,000 wu          1,050,000 wu          1,050,000 wu
8                   750,000 a             750,000 a             750,000 a             750,000 a             750,000 a
8      
9 9 Hadley Valley trunk sanitary sewer extension.  Removes Emerald Hills lift station from service.  7816            1,600,000             250,000 p             150,000 ow p        250,000               250,000
9              1,100,000 sa sa     1,100,000           1,100,000
9               100,000 ow ow        100,000               100,000
9      
10 10 Trunk Sewer capacity replacement program.  Replace undersized sewer trunk lines, size for ultimate sewer service areas.  Revenue bonds to be repaid by Sewer Utility user rates.          29,250,000             250,000 re          5,000,000 rb          6,000,000 rb          8,000,000 rb       10,000,000 rb re        250,000               250,000
10                                  -  
11 11 Upgrade / Replace Zumbro River Siphon at Silver Lake; serving East Zumbro Sewer District.  Revenue bonds to be repaid by Sewer Utility user rates.            3,000,000              3,000,000 rb
11      
12 12 Sewer Upgrade Connection from 7th St NW to Sewer Trunk along Railroad serving West Zumbro Sewer District.  Revenue bonds to be repaid by Sewer Utility user rates.            2,000,000              2,000,000 rb
12      
13 13 Golf Course South Trunkline Upgrade.  Phase I: 9th St S / Broadway to just north of 16th St SW.  Phase 2: 16th St SW to Mayowood Rd / 18th Ave SW area.  Revenue bonds to be repaid by Sewer Utility user rates.            4,500,000              2,000,000 rb          2,500,000 rb                          -  
13                                -  
14 14 Sanitary Sewer and Watermain Extension to Sewer Service Area 6 West of 60th Avenue NW (Phase 1).  Revenue Bonds to be repaid by future SAC charges. 7793            3,100,000                 200,000 rb          2,250,000 rb                          -  
14                     650,000 wa                          -  
14                                -  
15 15 KR 6 Trunkline sewer and watermain - 19th Street to Valley High Drive - Serve portions of section 19, 20, 29 and 30 of Cascade Township, Sewer Service Area 6G (Phase 3A in 2016 and Phase 3B in 2019).  Revenue Bonds to be repaid by future SAC charges. 7773            2,000,000                 200,000 rb          1,800,000 rb rb  1,400,000  (1,400,000)                          -  
15                                -  
16 16 Willow Creek Sewer Extension - To Serve SSA 15E, 15-11 and 15-12 in Rochester Township Phase "A", Phase "B".  Design and Build alternating years.  Revenue Bonds to be repaid by future SAC charges. 7757            2,000,000                 200,000 rb          1,800,000 rb rb  400,000      100,000      (500,000)                          -  
16                                -  
17 17 Prairie Crossing Lift Station and force main upgrades and improvements.   7815                450,000             100,000 sa             350,000 sa sa        100,000               100,000
17                                  -  
18 18 Replace / Upsize sanitary sewer pipe in Willow Creek golf course.                  50,000                   50,000 p
18      
19 19 Golf Course West Trunkline Upgrade.  Phase I: Soldiers Field to Apache Mall.  Phase 2: Apache Mall to Green Meadows.  Revenue Bonds to be repaid by Sewer Utility user rates.            2,500,000              2,500,000 rb                          -  
19      
20 20 Watermain and Sanitary Sewer to Serve Mayowood Farm and Mayowood mansion.  7798            1,300,000             675,000 wa               50,000 wa wa    675,000               675,000
20                 525,000 sa               50,000 sa sa    525,000               525,000
20                                  -  
                                                       
Total Cost            96,150,000       20,650,000            5,500,000         15,350,000         14,350,000         24,950,000         15,350,000  
Sources of Funds
Special Assessment Bonds a            3,950,000             200,000 a             750,000 a             750,000 a             750,000 a             750,000 a             750,000 a
Operating Transfer - fr Sewer Utility ow          23,250,000          8,350,000 ow          3,100,000 ow          2,950,000 ow          2,950,000 ow          2,950,000 ow          2,950,000 ow
Private Funds p                300,000             250,000 p                         -   p                         -   p               50,000 p                         -   p                         -   p
General Obligation Revenue Bonds rb          52,700,000          5,250,000 rb                         -   rb       10,000,000 rb          8,600,000 rb       18,850,000 rb       10,000,000 rb
Retained Earnings re            2,100,000             600,000 re             300,000 re             300,000 re             300,000 re             300,000 re             300,000 re
Sewer Availability Charges sa            2,125,000          1,725,000 sa                         -   sa                         -   sa             350,000 sa               50,000 sa                         -   sa
Water Availability Charges wa            1,375,000             675,000 wa                         -   wa                         -   wa                         -   wa             700,000 wa                         -   wa
Water Utility wu          10,350,000          3,600,000 wu          1,350,000 wu          1,350,000 wu          1,350,000 wu          1,350,000 wu          1,350,000 wu
Total Sources of Funds            96,150,000       20,650,000          5,500,000       15,350,000       14,350,000       24,950,000       15,350,000   20,650,000.00
Total of NEW FUNDING requests         5,500,000       15,350,000       14,350,000       24,950,000       15,350,000
Total adjustments to prior years' funding authorizations                        -                          -                          -                          -                          -  
Total Cost          5,500,000       15,350,000       14,350,000       24,950,000       15,350,000
                (average yearly SAC/SCC revenue from 2003-2012 = $737,791)
*      Revenue bonds repaid with user rates          41,000,000                         -         10,000,000          8,000,000       13,000,000       10,000,000
*      Revenue bonds repaid with future SAC charges             6,450,000                         -               600,000          5,850,000
                   -  
                 -  
                 -                    -                    -                    -                    -                    -  
59652 59653
2002 530357.29 65394.49
2003 805525.05 112485.57
2004 1259561.77 198711.71
2005 1112338.23 269118.42
2006 1291916.73 98228.13
2007 283359.57 55951.59
2008 114208.36 154308.06
2009 324605.83 -71062.3
2010 355623.57 41245.9
2011 310527.12 41749.53
2012 477678.2 141833.79
2013 537050.94 93886.19
2014 381262.72 40674.76
2015 417199.5 62287.86
2016 537987.71 43574.28