2017-2021 Capital Improvement Plan (C.I.P.)CITY OF HOPKINS
MEMORANDUM
Date: July 14, 2016
To: Mayor & City Council
From: Christine Harkess, Finance Director
Subject: 2017-2021 Capital Improvement Plan (C.I.P.)
Attached is a proposed CIP which has undergone several staff revisions. At the work session we
will review the 2017-2021 documents and incorporate any changes from the work session
discussion.
Included in this packet are the following –
1. Summary of changes in the 2017-2021 CIP
2. The cash flow statements by fund
3. Project reports summarized by year, department and funding source for the years 2017-
2021
4. Map of the street projects for the next 5 years (page 16 of the PDF)
Individual project sheets providing a description of the project, justification, and funding source
are not included but can be provided if you are interested in reviewing them. Please let me know
if you’d like to review the individual project sheets and I will email them to you. There are a
total of 74 individual project sheets.
Not all funds are balanced as we are working with Ehlers to update our Financial Management
Plan. We will discuss the changes and our options to balance all funds.
The presentation on Tuesday will be put up on the SMART board for ease of discussion. There
are a lot of components and this will ensure we are all at the same point for the discussion and
will allow staff to highlight items of interest easier.
FINANCE DEPARTMENT
SUMMARY OF CHANGES – 2017-2021 CIP
Arts Center Fund
1. Four projects were moved from the CIP to operations as they are not actual CIP items but
maintenance type projects.
2. 2017 projects added:
a. Paint theater - $15,000
b. Jaycee Studio Curtains - $30,000
c. Lighting Improvements - $12,200
d. Door Handles and Locks change out - $10,000
3. 2019 projects added:
a. Theater curtains - $80,000
Capital Improvement Fund
1. Two items were removed and placed in the operations budget.
a. Fire Classroom tables & chairs
2. 2017 project added/moved:
a. City Hall lobby upgrade (engineering) - $11,500
b. PW lunchroom upgrades - $25,000
c. Activity Center – Historical Society area renovations - $100,000 moved to 2019
3. 2018 projects adjusted
a. City Hall lobby upgrade – increased from $150,000 to $225,000
4. 2019 projects added
a. Activity Center – bathroom improvements - $15,000
b. Activity Center – Raspberry Room enhancements – $25,000
Park Dedication Fund
1. No additions
2. Items moved between years
a. Interlachen Park hockey boards - $50,000 moved from 2018 to 2017
b. Maetzold Field play equipment – $100,000 moved from 2020 to 2018
Communications Fund
1. 2017 and 2018 – funding contribution to City Hall lobby upgrades - $3,500 and $35,000
MSA Fund
1. No changes from prior CIP.
PIR Fund/Special Assessments
1. Bonds are projected to be sold each year we have a street project.
2. Pedestrian bike improvements – added $25,000 to the years 2019-2021
3. Residential street improvements
4. Blake Road Corridor improvements – project decreased in scope by $440,000. Project
now totals $3,170,400 over the years 2017-2019
5. Light Rail Transit project added at a total cost of $1,325,000 for years 2018-2019
6. There was no change to the special assessments portion.
Water Fund
1. Projects adjusted
a. 2017 – Eight Avenue Artery project increased by $35,000 to $200,000
2. Project added
a. Light Rail Transit Stations - $350,000
Sanitary Sewer Fund
1. Projects added
a. 2017 – Lift Station #7 reconstruction $700,000
b. 2018 – Light Rail Transit Stations - $150,000
Storm Sewer Fund
1. Projects added
a. 2017 – Westbrooke Way/Smetana Rd Drainage Improvements - $100,000
b. 2018-2019 – Blake Road Corridor Improvements - $200,000 ($100,000 each
year)
Refuse Fund
1. No changes
Pavilion Fund
1. One project was moved out of the CIP to operations
2. No other project changes
CAPITAL IMPROVEMENT PLAN
City of Hopkins, MN
PROJECTS BY YEAR
2017 2021thru
Project Name Department Project # Priority Project Cost
2017
09-CIP-CH030City Hall Lobby Upgrade n/a 15,000City Hall Administration
14-CIP-AC004Activity Center - Dishwasher 4 15,000Comm Svcs - Activity Center
17-CIP-AC037Activity Center - Room/Gym Enhancements 1 100,000Comm Svcs - Activity Center
08-CIP-AR013Arts Center - Replace Rooftop HVAC Units n/a 320,000Comm Svcs - Arts Center
14-CIP-AR003Arts Center - Paint Theatre 2 15,000Comm Svcs - Arts Center
16-CIP-AR002Arts Center - Jaycee Studio Curtain System 2 30,000Comm Svcs - Arts Center
17-CIP-AR003Arts Center - Lighting Improvements 2 12,200Comm Svcs - Arts Center
17-CIP-AR006Arts Center - Door Handles and Locks 1 10,000Comm Svcs - Arts Center
13 CIP-CM001Technology Improvement - Council Chambers & Studio n/a 23,000Comm Svcs - Communications
09-CIP-PV026Pavilion Roof Replacement 1 140,000Pavilion
16-CIP-PV327Pavilion - Refrigeration System - Engineering Fees n/a 200,000Pavilion
16-CIP-B006PW - Public Works Lunchroom 1 25,000Public Works: Bldg/Equip Serv
08-CIP-P014Hilltop Park - Play Equipment n/a 120,000Public Works: Parks
13-CIP-P043Burnes Park - 2-5 Play Equipment n/a 100,000Public Works: Parks
14-CIP-P002Burnes Park Warming House & Splash Pad n/a 1,200,000Public Works: Parks
16-CIP-P003Interlachen Park - Portable Hockey Boards n/a 50,000Public Works: Parks
01-CIP-S101Residential Street Improvements and Utilities n/a 6,600,000Public Works: Streets/Traffic
01-CIP-S103Citywide Concrete Alleys n/a 80,000Public Works: Streets/Traffic
13-CIP-S040Pedestrian & Bicycle Access Improvements n/a 25,000Public Works: Streets/Traffic
15-CIP-S001Blake Road Corridor Improvements n/a 2,648,800Public Works: Streets/Traffic
16-CIP-S041Street Overlay Improvements n/a 275,000Public Works: Streets/Traffic
16-CIP-S042Street Sign Management n/a 20,000Public Works: Streets/Traffic
01-CIP-S503Eighth Avenue Artery Project n/a 5,313,000Public Works: Transportation
16-CIP-S045Westbrook Way/Smetana Rd Drainage Improvements n/a 100,000Public Works: Transportation
01-CIP-U002Storm Drainage System Maintenance - Alley Repairs n/a 21,000Public Works: Utilities
16-CIP-U015Reconstruct Lift Station No. 7 n/a 700,000Public Works: Utilities
16-CIP-R003Shady Oak Beach Improvements 3 50,000Recreation
18,208,000Total for 2017
2018
09-CIP-CH030City Hall Lobby Upgrade n/a 260,000City Hall Administration
08-CIP-AC018Activity Center - Replace Gymnasium Roof n/a 105,000Comm Svcs - Activity Center
08-CIP-AC024Activity Center - Raspberry Room Roof Replacement n/a 80,000Comm Svcs - Activity Center
09-CIP-AC031Activity Center - Lower Roof Replacement n/a 80,000Comm Svcs - Activity Center
09-CIP-AR027Arts Center - Replace Lobby Carpet n/a 52,000Comm Svcs - Arts Center
14-CIP-AR004Arts Center - Remodel Administrative Offices 2 50,000Comm Svcs - Arts Center
13 CIP-CM001Technology Improvement - Council Chambers & Studio n/a 15,000Comm Svcs - Communications
08-CIP-FD019Fire - Replace Carpet and Apparatus Floor Finish n/a 28,000Fire
07-CIP-PV313Pavilion Restroom/Lobby Floor Improvement n/a 35,000Pavilion
07-CIP-PV314Pavilion Overhead Door Improvement n/a 65,000Pavilion
10-CIP-PV317Pavilion - Skate Tile Replacement n/a 75,000Pavilion
10-CIP-PV318Pavilion - Refrigeration Equip & Arena Floor Repl n/a 2,400,000Pavilion
13-CIP-PV324Pavilion Entry and Lobby Door Replacement 3 25,000Pavilion
13-CIP-PV325Pavilion - Paint Exterior Building 1 28,000Pavilion
Wednesday, July 13, 2016
Project Name Department Project # Priority Project Cost
14-CIP-PV010Pavilion Painting the Arena Ceiling and Bar Joist 1 48,000Pavilion
08-CIP-PD016Replace Carpet - Police Station n/a 40,000Police
08-CIP-P010Park Valley - Play Equipment n/a 120,000Public Works: Parks
08-CIP-P011Burnes Park - Resurface Tennis Courts n/a 20,000Public Works: Parks
13-CIP-P044Oakes Park - Tennis Courts n/a 20,000Public Works: Parks
13-CIP-P055Elmo Park - 2-5 Play Equipment n/a 50,000Public Works: Parks
13-CIP-P062Maetzold Field - Play Equipment n/a 100,000Public Works: Parks
16-CIP-P002Cottageville Park - Phase III Improvements n/a 450,000Public Works: Parks
01-CIP-S101Residential Street Improvements and Utilities n/a 3,450,000Public Works: Streets/Traffic
13-CIP-S040Pedestrian & Bicycle Access Improvements n/a 25,000Public Works: Streets/Traffic
15-CIP-S001Blake Road Corridor Improvements n/a 7,949,900Public Works: Streets/Traffic
16-CIP-S041Street Overlay Improvements n/a 300,000Public Works: Streets/Traffic
16-CIP-S042Street Sign Management n/a 20,000Public Works: Streets/Traffic
01-CIP-S502Light Rail Transit Stations (3)n/a 1,500,000Public Works: Transportation
01-CIP-U002Storm Drainage System Maintenance - Alley Repairs n/a 21,000Public Works: Utilities
17,411,900Total for 2018
2019
09-CIP-CH029City Hall Roof Replacement n/a 115,000City Hall Administration
16-CIP-AC035Activity Center - Former Historical Society Area 1 100,000Comm Svcs - Activity Center
17-CIP-AC039Activity Center - Bathroom Improvements 1 15,000Comm Svcs - Activity Center
17-CIP-AC041Activity Center - Raspberry Room Enhancements 4 25,000Comm Svcs - Activity Center
17-CIP-AR004Arts Center - Theater Curtains 3 80,000Comm Svcs - Arts Center
13-CIP-PV321Pavilion Mezzanine Rooftop Unit Replacement 1 30,000Pavilion
13-CIP-PV322Pavilion HHS Team Room Rooftop Unit Repl 1 11,000Pavilion
08-CIP-B023Public Works - Replace Overhead Doors n/a 90,000Public Works: Bldg/Equip Serv
13-CIP-P050Pavilion Addion/Warming House n/a 600,000Public Works: Parks
13-CIP-P056Harley Hopkins Park - Warming House n/a 30,000Public Works: Parks
13-CIP-P057Harley Hopkins Park - Lighting n/a 50,000Public Works: Parks
01-CIP-S101Residential Street Improvements and Utilities n/a 5,575,000Public Works: Streets/Traffic
13-CIP-S040Pedestrian & Bicycle Access Improvements n/a 25,000Public Works: Streets/Traffic
15-CIP-S001Blake Road Corridor Improvements n/a 7,449,900Public Works: Streets/Traffic
16-CIP-S041Street Overlay Improvements n/a 325,000Public Works: Streets/Traffic
16-CIP-S042Street Sign Management n/a 20,000Public Works: Streets/Traffic
01-CIP-S502Light Rail Transit Stations (3)n/a 3,181,000Public Works: Transportation
01-CIP-U002Storm Drainage System Maintenance - Alley Repairs n/a 22,000Public Works: Utilities
08-CIP-U001Lift Station # 4 n/a 160,000Public Works: Utilities
16-CIP-R003Shady Oak Beach Improvements 3 35,000Recreation
17,938,900Total for 2019
2020
08-CIP-CH010City Hall - Replace Carpeting n/a 58,000City Hall Administration
09-CIP-AR028Art Center - Various Rooms and Hallway (Carpet) n/a 21,500Comm Svcs - Arts Center
16-CIP-AR006Arts Center - Seal Floors in Restroom & Kitchen 1 15,000Comm Svcs - Arts Center
08-CIP-B021Public Works - Replace Wash Bay Roof n/a 50,000Public Works: Bldg/Equip Serv
09-CIP-B034Public Works Garage Roof Replacement n/a 50,000Public Works: Bldg/Equip Serv
05-CIP-P202Central Park Tennis Courts n/a 20,000Public Works: Parks
13-CIP-P059Interlachen Park - Lighting n/a 50,000Public Works: Parks
13-CIP-P063Maetzold Field - Pavilion n/a 80,000Public Works: Parks
01-CIP-S101Residential Street Improvements and Utilities n/a 6,660,000Public Works: Streets/Traffic
13-CIP-S040Pedestrian & Bicycle Access Improvements n/a 25,000Public Works: Streets/Traffic
16-CIP-S041Street Overlay Improvements n/a 350,000Public Works: Streets/Traffic
16-CIP-S042Street Sign Management n/a 20,000Public Works: Streets/Traffic
7,399,500Total for 2020
Wednesday, July 13, 2016
Project Name Department Project # Priority Project Cost
2021
02-CIP-0031Activity Center Refrigerator/Freezer n/a 1Comm Svcs - Activity Center
08-CIP-AR006Arts Center-Replace Office Carpet - Stages Theatre n/a 20,225Comm Svcs - Arts Center
08-CIP-B123Fire Station - Replace Boilers n/a 45,000Fire
13-CIP-P058Hilltop - Picnic Shelter n/a 40,000Public Works: Parks
01-CIP-S101Residential Street Improvements and Utilities n/a 6,660,000Public Works: Streets/Traffic
01-CIP-S104County Road 3 n/a 2,300,000Public Works: Streets/Traffic
13-CIP-S040Pedestrian & Bicycle Access Improvements n/a 25,000Public Works: Streets/Traffic
16-CIP-S041Street Overlay Improvements n/a 375,000Public Works: Streets/Traffic
16-CIP-S042Street Sign Management n/a 20,000Public Works: Streets/Traffic
9,485,226Total for 2021
GRAND TOTAL 70,443,526
Wednesday, July 13, 2016
CAPITAL IMPROVEMENT PLAN
City of Hopkins, MN
PROJECTS BY DEPARTMENT
2017 2021thru
Total2017 2018 2019 2020 2021Department Project# Priority
City Hall Administration
08-CIP-CH010 58,00058,000City Hall - Replace Carpeting n/a
09-CIP-CH029 115,000115,000City Hall Roof Replacement n/a
09-CIP-CH030 275,00015,000 260,000City Hall Lobby Upgrade n/a
448,00015,000 260,000 115,000 58,000City Hall Administration Total
Comm Svcs - Activity Center
02-CIP-0031 11Activity Center Refrigerator/Freezer n/a
08-CIP-AC018 105,000105,000Activity Center - Replace Gymnasium Roof n/a
08-CIP-AC024 80,00080,000Activity Center - Raspberry Room Roof Replacement n/a
09-CIP-AC031 80,00080,000Activity Center - Lower Roof Replacement n/a
14-CIP-AC004 15,00015,000Activity Center - Dishwasher 4
16-CIP-AC035 100,000100,000Activity Center - Former Historical Society Area 1
17-CIP-AC037 100,000100,000Activity Center - Room/Gym Enhancements 1
17-CIP-AC039 15,00015,000Activity Center - Bathroom Improvements 1
17-CIP-AC041 25,00025,000Activity Center - Raspberry Room Enhancements 4
520,001115,000 265,000 140,000 1Comm Svcs - Activity Center Total
Comm Svcs - Arts Center
08-CIP-AR006 20,22520,225Arts Center-Replace Office Carpet - Stages Theatre n/a
08-CIP-AR013 320,000320,000Arts Center - Replace Rooftop HVAC Units n/a
09-CIP-AR027 52,00052,000Arts Center - Replace Lobby Carpet n/a
09-CIP-AR028 21,50021,500Art Center - Various Rooms and Hallway (Carpet) n/a
14-CIP-AR003 15,00015,000Arts Center - Paint Theatre 2
14-CIP-AR004 50,00050,000Arts Center - Remodel Administrative Offices 2
16-CIP-AR002 30,00030,000Arts Center - Jaycee Studio Curtain System 2
16-CIP-AR006 15,00015,000Arts Center - Seal Floors in Restroom & Kitchen 1
17-CIP-AR003 12,20012,200Arts Center - Lighting Improvements 2
17-CIP-AR004 80,00080,000Arts Center - Theater Curtains 3
17-CIP-AR006 10,00010,000Arts Center - Door Handles and Locks 1
625,925387,200 102,000 80,000 36,500 20,225Comm Svcs - Arts Center Total
Comm Svcs - Communications
13 CIP-CM001 38,00023,000 15,000Technology Improvement - Council Chambers & Studio n/a
38,00023,000 15,000Comm Svcs - Communications Total
Fire
08-CIP-B123 45,00045,000Fire Station - Replace Boilers n/a
08-CIP-FD019 28,00028,000Fire - Replace Carpet and Apparatus Floor Finish n/a
73,00028,000 45,000Fire Total
Pavilion
Wednesday, July 13, 2016
Total2017 2018 2019 2020 2021Department Project# Priority
07-CIP-PV313 35,00035,000Pavilion Restroom/Lobby Floor Improvement n/a
07-CIP-PV314 65,00065,000Pavilion Overhead Door Improvement n/a
09-CIP-PV026 140,000140,000Pavilion Roof Replacement 1
10-CIP-PV317 75,00075,000Pavilion - Skate Tile Replacement n/a
10-CIP-PV318 2,400,0002,400,000Pavilion - Refrigeration Equip & Arena Floor Repl n/a
13-CIP-PV321 30,00030,000Pavilion Mezzanine Rooftop Unit Replacement 1
13-CIP-PV322 11,00011,000Pavilion HHS Team Room Rooftop Unit Repl 1
13-CIP-PV324 25,00025,000Pavilion Entry and Lobby Door Replacement 3
13-CIP-PV325 28,00028,000Pavilion - Paint Exterior Building 1
14-CIP-PV010 48,00048,000Pavilion Painting the Arena Ceiling and Bar Joist 1
16-CIP-PV327 200,000200,000Pavilion - Refrigeration System - Engineering Fees n/a
3,057,000340,000 2,676,000 41,000Pavilion Total
Police
08-CIP-PD016 40,00040,000Replace Carpet - Police Station n/a
40,00040,000Police Total
Public Works: Bldg/Equip Serv
08-CIP-B021 50,00050,000Public Works - Replace Wash Bay Roof n/a
08-CIP-B023 90,00090,000Public Works - Replace Overhead Doors n/a
09-CIP-B034 50,00050,000Public Works Garage Roof Replacement n/a
16-CIP-B006 25,00025,000PW - Public Works Lunchroom 1
215,00025,000 90,000 100,000Public Works: Bldg/Equip Serv Total
Public Works: Parks
05-CIP-P202 20,00020,000Central Park Tennis Courts n/a
08-CIP-P010 120,000120,000Park Valley - Play Equipment n/a
08-CIP-P011 20,00020,000Burnes Park - Resurface Tennis Courts n/a
08-CIP-P014 120,000120,000Hilltop Park - Play Equipment n/a
13-CIP-P043 100,000100,000Burnes Park - 2-5 Play Equipment n/a
13-CIP-P044 20,00020,000Oakes Park - Tennis Courts n/a
13-CIP-P050 600,000600,000Pavilion Addion/Warming House n/a
13-CIP-P055 50,00050,000Elmo Park - 2-5 Play Equipment n/a
13-CIP-P056 30,00030,000Harley Hopkins Park - Warming House n/a
13-CIP-P057 50,00050,000Harley Hopkins Park - Lighting n/a
13-CIP-P058 40,00040,000Hilltop - Picnic Shelter n/a
13-CIP-P059 50,00050,000Interlachen Park - Lighting n/a
13-CIP-P062 100,000100,000Maetzold Field - Play Equipment n/a
13-CIP-P063 80,00080,000Maetzold Field - Pavilion n/a
14-CIP-P002 1,200,0001,200,000Burnes Park Warming House & Splash Pad n/a
16-CIP-P002 450,000450,000Cottageville Park - Phase III Improvements n/a
16-CIP-P003 50,00050,000Interlachen Park - Portable Hockey Boards n/a
3,100,0001,470,000 760,000 680,000 150,000 40,000Public Works: Parks Total
Public Works: Streets/Traffic
01-CIP-S101 28,945,0006,600,000 3,450,000 5,575,000 6,660,000 6,660,000Residential Street Improvements and Utilities n/a
01-CIP-S103 80,00080,000Citywide Concrete Alleys n/a
01-CIP-S104 2,300,0002,300,000County Road 3 n/a
13-CIP-S040 125,00025,000 25,000 25,000 25,000 25,000Pedestrian & Bicycle Access Improvements n/a
15-CIP-S001 18,048,6002,648,800 7,949,900 7,449,900Blake Road Corridor Improvements n/a
16-CIP-S041 1,625,000275,000 300,000 325,000 350,000 375,000Street Overlay Improvements n/a
16-CIP-S042 100,00020,000 20,000 20,000 20,000 20,000Street Sign Management n/a
Wednesday, July 13, 2016
Total2017 2018 2019 2020 2021Department Project# Priority
51,223,6009,648,800 11,744,900 13,394,900 7,055,000 9,380,000Public Works: Streets/Traffic Total
Public Works: Transportation
01-CIP-S502 4,681,0001,500,000 3,181,000Light Rail Transit Stations (3) n/a
01-CIP-S503 5,313,0005,313,000Eighth Avenue Artery Project n/a
16-CIP-S045 100,000100,000Westbrook Way/Smetana Rd Drainage Improvements n/a
10,094,0005,413,000 1,500,000 3,181,000Public Works: Transportation Total
Public Works: Utilities
01-CIP-U002 64,00021,000 21,000 22,000Storm Drainage System Maintenance - Alley Repairs n/a
08-CIP-U001 160,000160,000Lift Station # 4 n/a
16-CIP-U015 700,000700,000Reconstruct Lift Station No. 7 n/a
924,000721,000 21,000 182,000Public Works: Utilities Total
Recreation
16-CIP-R003 85,00050,000 35,000Shady Oak Beach Improvements 3
85,00050,000 35,000Recreation Total
GRAND TOTAL 70,443,52618,208,000 17,411,900 17,938,900 7,399,500 9,485,226
Wednesday, July 13, 2016
CAPITAL IMPORIVEMENT PLAN
City of Hopkins, MN
PROJECTS BY FUNDING SOURCE
2017 2021thru
TotalSourceProject# Priority 2017 2018 2019 2020 2021
AC - Arts Center Fund
08-CIP-AR006 20,22520,225Arts Center-Replace Office Carpet - Stages Theatre n/a
08-CIP-AR013 320,000320,000Arts Center - Replace Rooftop HVAC Units n/a
09-CIP-AR027 52,00052,000Arts Center - Replace Lobby Carpet n/a
09-CIP-AR028 21,50021,500Art Center - Various Rooms and Hallway (Carpet) n/a
14-CIP-AR003 15,00015,000Arts Center - Paint Theatre 2
14-CIP-AR004 50,00050,000Arts Center - Remodel Administrative Offices 2
16-CIP-AR002 30,00030,000Arts Center - Jaycee Studio Curtain System 2
16-CIP-AR006 15,00015,000Arts Center - Seal Floors in Restroom & Kitchen 1
17-CIP-AR003 12,20012,200Arts Center - Lighting Improvements 2
17-CIP-AR004 80,00080,000Arts Center - Theater Curtains 3
17-CIP-AR006 10,00010,000Arts Center - Door Handles and Locks 1
625,925387,200 102,000 80,000 36,500 20,225AC - Arts Center Fund Total
CI - Capital Improvement Fund
02-CIP-0031 11Activity Center Refrigerator/Freezer n/a
08-CIP-AC018 105,000105,000Activity Center - Replace Gymnasium Roof n/a
08-CIP-AC024 80,00080,000Activity Center - Raspberry Room Roof Replacement n/a
08-CIP-B021 10,00010,000Public Works - Replace Wash Bay Roof n/a
08-CIP-B023 18,00018,000Public Works - Replace Overhead Doors n/a
08-CIP-B123 45,00045,000Fire Station - Replace Boilers n/a
08-CIP-CH010 58,00058,000City Hall - Replace Carpeting n/a
08-CIP-FD019 28,00028,000Fire - Replace Carpet and Apparatus Floor Finish n/a
08-CIP-PD016 40,00040,000Replace Carpet - Police Station n/a
09-CIP-AC031 80,00080,000Activity Center - Lower Roof Replacement n/a
09-CIP-B034 50,00050,000Public Works Garage Roof Replacement n/a
09-CIP-CH029 115,000115,000City Hall Roof Replacement n/a
09-CIP-CH030 236,50011,500 225,000City Hall Lobby Upgrade n/a
14-CIP-AC004 15,00015,000Activity Center - Dishwasher 4
16-CIP-AC035 100,000100,000Activity Center - Former Historical Society Area 1
16-CIP-B006 25,00025,000PW - Public Works Lunchroom 1
17-CIP-AC037 100,000100,000Activity Center - Room/Gym Enhancements 1
17-CIP-AC039 15,00015,000Activity Center - Bathroom Improvements 1
17-CIP-AC041 25,00025,000Activity Center - Raspberry Room Enhancements 4
1,145,501151,500 558,000 273,000 118,000 45,001CI - Capital Improvement Fund Total
CT - Cable Franchise Fees
09-CIP-CH030 38,5003,500 35,000City Hall Lobby Upgrade n/a
13 CIP-CM001 38,00023,000 15,000Technology Improvement - Council Chambers & Studio n/a
76,50026,500 50,000CT - Cable Franchise Fees Total
Thursday, July 14, 2016
TotalSourceProject# Priority 2017 2018 2019 2020 2021
GU - Other Governmental Units
01-CIP-S104 1,600,0001,600,000County Road 3 n/a
01-CIP-S502 1,904,0001,904,000Light Rail Transit Stations (3) n/a
01-CIP-S503 2,745,0002,745,000Eighth Avenue Artery Project n/a
15-CIP-S001 12,928,2001,269,000 5,954,600 5,704,600Blake Road Corridor Improvements n/a
16-CIP-R003 57,00033,500 23,500Shady Oak Beach Improvements 3
19,234,2004,047,500 5,954,600 7,632,100 1,600,000GU - Other Governmental Units Total
MS - Municipal State Aid Streets
01-CIP-S104 700,000700,000County Road 3 n/a
700,000700,000MS - Municipal State Aid Streets Total
PA - Pavilion Fund
07-CIP-PV313 35,00035,000Pavilion Restroom/Lobby Floor Improvement n/a
07-CIP-PV314 65,00065,000Pavilion Overhead Door Improvement n/a
09-CIP-PV026 140,000140,000Pavilion Roof Replacement 1
10-CIP-PV317 75,00075,000Pavilion - Skate Tile Replacement n/a
10-CIP-PV318 2,400,0002,400,000Pavilion - Refrigeration Equip & Arena Floor Repl n/a
13-CIP-PV321 30,00030,000Pavilion Mezzanine Rooftop Unit Replacement 1
13-CIP-PV322 11,00011,000Pavilion HHS Team Room Rooftop Unit Repl 1
13-CIP-PV324 25,00025,000Pavilion Entry and Lobby Door Replacement 3
13-CIP-PV325 28,00028,000Pavilion - Paint Exterior Building 1
14-CIP-PV010 48,00048,000Pavilion Painting the Arena Ceiling and Bar Joist 1
16-CIP-PV327 200,000200,000Pavilion - Refrigeration System - Engineering Fees n/a
3,057,000340,000 2,676,000 41,000PA - Pavilion Fund Total
PDF- Park Dedication Fund
05-CIP-P202 20,00020,000Central Park Tennis Courts n/a
08-CIP-P010 120,000120,000Park Valley - Play Equipment n/a
08-CIP-P011 20,00020,000Burnes Park - Resurface Tennis Courts n/a
08-CIP-P014 120,000120,000Hilltop Park - Play Equipment n/a
13-CIP-P043 100,000100,000Burnes Park - 2-5 Play Equipment n/a
13-CIP-P044 20,00020,000Oakes Park - Tennis Courts n/a
13-CIP-P050 600,000600,000Pavilion Addion/Warming House n/a
13-CIP-P055 50,00050,000Elmo Park - 2-5 Play Equipment n/a
13-CIP-P056 30,00030,000Harley Hopkins Park - Warming House n/a
13-CIP-P057 50,00050,000Harley Hopkins Park - Lighting n/a
13-CIP-P058 40,00040,000Hilltop - Picnic Shelter n/a
13-CIP-P059 50,00050,000Interlachen Park - Lighting n/a
13-CIP-P062 100,000100,000Maetzold Field - Play Equipment n/a
13-CIP-P063 80,00080,000Maetzold Field - Pavilion n/a
14-CIP-P002 1,200,0001,200,000Burnes Park Warming House & Splash Pad n/a
16-CIP-P002 450,000450,000Cottageville Park - Phase III Improvements n/a
16-CIP-P003 50,00050,000Interlachen Park - Portable Hockey Boards n/a
16-CIP-R003 28,00016,500 11,500Shady Oak Beach Improvements 3
3,128,0001,486,500 760,000 691,500 150,000 40,000PDF- Park Dedication Fund Total
PI - PIR/General Obligation Bonds
01-CIP-S101 8,475,0002,000,000 1,000,000 1,825,000 1,825,000 1,825,000Residential Street Improvements and Utilities n/a
Thursday, July 14, 2016
TotalSourceProject# Priority 2017 2018 2019 2020 2021
01-CIP-S103 16,00016,000Citywide Concrete Alleys n/a
01-CIP-S502 1,325,0001,000,000 325,000Light Rail Transit Stations (3) n/a
01-CIP-S503 1,963,0001,963,000Eighth Avenue Artery Project n/a
13-CIP-S040 125,00025,000 25,000 25,000 25,000 25,000Pedestrian & Bicycle Access Improvements n/a
15-CIP-S001 3,170,4001,379,800 1,020,300 770,300Blake Road Corridor Improvements n/a
16-CIP-S041 1,625,000275,000 300,000 325,000 350,000 375,000Street Overlay Improvements n/a
16-CIP-S042 100,00020,000 20,000 20,000 20,000 20,000Street Sign Management n/a
16,799,4005,678,800 3,365,300 3,290,300 2,220,000 2,245,000PI - PIR/General Obligation Bonds Total
RF - Refuse Fund
08-CIP-B021 10,00010,000Public Works - Replace Wash Bay Roof n/a
08-CIP-B023 18,00018,000Public Works - Replace Overhead Doors n/a
28,00018,000 10,000RF - Refuse Fund Total
SA - Special Assessment
01-CIP-S101 8,170,0002,000,000 900,000 1,500,000 1,885,000 1,885,000Residential Street Improvements and Utilities n/a
01-CIP-S103 64,00064,000Citywide Concrete Alleys n/a
8,234,0002,064,000 900,000 1,500,000 1,885,000 1,885,000SA - Special Assessment Total
SF - Sanitary Sewer Fund
01-CIP-S101 3,000,000500,000 500,000 500,000 750,000 750,000Residential Street Improvements and Utilities n/a
01-CIP-S502 150,000150,000Light Rail Transit Stations (3) n/a
01-CIP-S503 100,000100,000Eighth Avenue Artery Project n/a
08-CIP-B021 10,00010,000Public Works - Replace Wash Bay Roof n/a
08-CIP-B023 18,00018,000Public Works - Replace Overhead Doors n/a
08-CIP-U001 160,000160,000Lift Station # 4 n/a
15-CIP-S001 750,000375,000 375,000Blake Road Corridor Improvements n/a
16-CIP-U015 700,000700,000Reconstruct Lift Station No. 7 n/a
4,888,0001,300,000 1,025,000 1,053,000 760,000 750,000SF - Sanitary Sewer Fund Total
SU - Storm Sewer Fund
01-CIP-S101 2,850,000600,000 350,000 500,000 700,000 700,000Residential Street Improvements and Utilities n/a
01-CIP-S502 952,000952,000Light Rail Transit Stations (3) n/a
01-CIP-S503 305,000305,000Eighth Avenue Artery Project n/a
01-CIP-U002 64,00021,000 21,000 22,000Storm Drainage System Maintenance - Alley Repairs n/a
08-CIP-B021 10,00010,000Public Works - Replace Wash Bay Roof n/a
08-CIP-B023 18,00018,000Public Works - Replace Overhead Doors n/a
15-CIP-S001 200,000100,000 100,000Blake Road Corridor Improvements n/a
16-CIP-S045 100,000100,000Westbrook Way/Smetana Rd Drainage Improvements n/a
4,499,0001,026,000 471,000 1,592,000 710,000 700,000SU - Storm Sewer Fund Total
WF - Water Fund
01-CIP-S101 6,450,0001,500,000 700,000 1,250,000 1,500,000 1,500,000Residential Street Improvements and Utilities n/a
01-CIP-S502 350,000350,000Light Rail Transit Stations (3) n/a
01-CIP-S503 200,000200,000Eighth Avenue Artery Project n/a
08-CIP-B021 10,00010,000Public Works - Replace Wash Bay Roof n/a
08-CIP-B023 18,00018,000Public Works - Replace Overhead Doors n/a
15-CIP-S001 1,000,000500,000 500,000Blake Road Corridor Improvements n/a
Thursday, July 14, 2016
TotalSourceProject# Priority 2017 2018 2019 2020 2021
8,028,0001,700,000 1,550,000 1,768,000 1,510,000 1,500,000WF - Water Fund Total
70,443,52618,208,000 17,411,900 17,938,900 7,399,500 9,485,226GRAND TOTAL
Thursday, July 14, 2016
PARK CAPITAL IMPROVEMENTS FUND (301)7/13/2016
Actual Projected Projected Projected Projected Projected Projected
2015 2016 2017 2018 2019 2020 2021
Working Capital Beginning Year 141,306 258,547 1,595,722 1,666,394 1,350,686 794,006 769,126
Revenues:
Taxes (from matured Park Bonds)
Interest 8,743 4,266 47,872 49,992 40,521 23,820 23,074
Dedication fees 0 0 0 0
Moline Apts 180,000
Village Apts 120,000
Cold Storage Site Redevelopment 300,000
Joint Rec refunds 6,000 6,000 6,000 6,000 6,000 6,000
Franchise Fees (gas/elec) 2014 incr 87,148 85,300 85,300 85,300 85,300 85,300 85,300
Franchise Fees (gas/elec) 2012 incr 206,227 210,000 210,000 210,000 210,000 210,000 210,000
Transfer in Franchise Fees 316,970
Bond Proceeds (1)1,504,382 1,150,000 1,200,000
Hennepin County Grant
Cottageville Park Donations 34,689
BWSR Grant 425,250
CDBG Funds 180,000
PIR Funding (Transfer In) 225,000
Water Funding (Transfer In) 37,500
Sewer Funding (Transfer In) 37,500
Storm Sewer Funding (Transfer In) 265,000
Met Council - easement/grant
Grants - Private Foundations
Donations - general 989
Donations - benches
T-in - Storm Sewer for Cottageville Park
Total Revenues 2,372,489 2,592,475 1,669,172 651,292 341,821 325,120 324,374
Expenditures:
C.I.P. Projects 101,269 858,300 1,486,500 310,000 691,500 150,000 40,000
Cottageville Property Acquisition
Cottageville Park Playground 338,835
Cottageville Park House Demo 12,107
Cottageville Park Improvements 1,796,036 450,000
Cottageville Park Pavilion 380,000
Bond Payment Contribution (2015 Bonds) 10,000 10,000 10,000 10,000 10,000 10,000
Bond Payment Contribution (2016 Bonds) 95,000 90,000 90,000 90,000 90,000
Bond Payment Contribution (2017 Bonds) 100,000 100,000 100,000 100,000
Skate Park commitment 7,000 7,000 7,000 7,000 7,000
Total Expenditures 2,255,248 1,255,300 1,598,500 967,000 898,500 350,000 240,000
Working Capital Year End 258,547 1,595,722 1,666,394 1,350,686 794,006 769,126 853,500
FACILITIES & BUILDINGS 7/14/2016
CAPITAL IMPROVEMENTS FUND (305)
Actual Projected Projected Projected Projected Projected Projected
2015 2016 2017 2018 2019 2020 2021
Working Capital Beginning Year 255,974 67,621 (265,588) (108,416) (631,958) (908,118) (1,030,658)
Revenues:
Interest 1,991 338 (1,328) (542) (3,160) (4,541) (5,153)
Transfers from General Fund 125,000
Transfers from Enterprise Funds 400,000
Transfer from Real Estate Fund 128,697
Tax Levy (red per FMP)52,311 125,000 310,000 35,000 0 0 50,000
Total Revenues 182,999 650,338 308,672 34,458 (3,160) (4,541) 44,847
Expenditures:
C.I.P. Projects 371,352 983,547 151,500 558,000 273,000 118,000 45,000
Transfer to General Fund
Total Expenditures 371,352 983,547 151,500 558,000 273,000 118,000 45,000
Working Capital Year End 67,621 (265,588) (108,416) (631,958) (908,118) (1,030,658) (1,030,812)
2016 Projects
2016 - T-In from General Fund 28,000 Fire Dept - Repl carpet
is to offset the cost of the PW 845,000 Public Works Garage Upgrade (total project $400K from Ent Funds)
Garage project 67,000 Activity Center - Multi-purpose Gym Improvements
17,547 Activity Center Lounge/Computer Lab/Library - tables and chairs
6,000 Activity Center - Harmony Hill Sound System
20,000 PW - garage openers
remove yellow items and put in 983,547
General Fund???
2017 Projects
15,000 Activity Center - dishwasher
11,500 City Hall Lobby Upgrade
25,000 PW Lunchroom
100,000 Activity Center Room/Gym Enhancements
151,500
2018 Projects
225,000 City Hall Lobby Upgrade
40,000 Police Dept - replace carpet
28,000 Fire Dept - Repl apparatus floor finish
105,000 Activity Ctr - replace gymnasium roof
80,000 Activity Center - Raspberry Room roof replacement
80,000 Activity Center - lower roof repl
558,000
2019 Projects
18,000 PW - overhead door repl
115,000 City Hall - roof repl
100,000 Activity Center - Former Historical Society Area
15,000 Activity Ctr - bathroom improvements
25,000 Activity Center - Raspberry Room Improvements
273,000
2020 Projects
58,000 City Hall - Replace carpeting
10,000 PW - repl wash bay roof
50,000 PW - garage roof repl
118,000
2021 Projects
45,000 Fire - Replace boilers
45,000
7/11/2016
MUNICIPAL STATE AID FUND (302)
Actual Projected Projected Projected Projected Projected Projected
2015 2016 2017 2018 2019 2020 2021
Working Capital Beginning Bal 513,074 422,235 424,346 426,467 428,600 830,743 1,234,897
Revenues:
State MSA Funds, projects 600,766 0 0 0 400,000 400,000 400,000
State MSA Advance
Interest Earnings 18,630 2,111 2,122 2,132 2,143 4,154 6,174
Hennepin County -SOR Land Reimb
Shady Oak Rd - Land Sale proceeds
Bond issue
Total Revenues 619,396 2,111 2,122 2,132 402,143 404,154 406,174
Transfer Out for Projects
CIP State Aid Projects
Highway 7 & 5th Ave Traffic Signal
Shady Oak Rd - Co Rd 61 542,662
Shady Oak Rd ROW Purchase
Shady Oak Rd Land Acqusition
Mainstreet Rehabilitation 109,935
ARTery - 8th Ave S
County Road 3 - EB 700,000
Sixth St S (11th - 12th Ave)
Landscape - Excelsior Blvd Median 25,424
Misc Expenses 32,214
Total Expenditures 710,235 0 0000700,000
Working Capital Ending Balance 422,235 424,346 426,467 428,600 830,743 1,234,897 941,071
includes cash, interest rcvbl, & A/P
Cash Flow Analysis P.I.R. FUND (501)7/13/2016
Actual Projected Projected Projected Projected Projected Projected
2015 2016 2017 2018 2019 2020 2021
Working Capital Beginning Year 2,785,317 442,413 422,657 314,757 146,049 (59,387) (282,700)
Revenues:
Property Taxes 1,260
Special Assessment Revenues - from levy 53,803 55,000
Special Assessment Revenues - Prepaid
County Grant 122,929
State Gas Tax 120,554
Interest 43,183 4,424 1,902 1,416 657 (267) (1,272)
Bond Proceeds 5,361,851 3,800,000 7,700,000 4,300,000 4,800,000 4,100,000 4,100,000
Total Revenues 5,703,580 3,859,424 7,701,902 4,301,416 4,800,657 4,099,733 4,098,728
Expenditures:
C.I.P. Projects 6,338,523 2,505,000 5,678,800 3,365,300 3,290,300 2,220,000 2,245,000
C.I.P. Projects - Special Assm 1,310,000 2,064,000 900,000 1,500,000 1,885,000 1,885,000
Transfers for SA Debt collected thru Assm
Debt Service Transfers - 2010A - Imprv 61,358 64,180 67,002 69,824 80,794 83,045 69,238
Debt Service Transfers (prepaids to DS funds)
Debt Fund - Zion Special Assessments 22,482
Transfer Out - Bond Proceeds to Enterprise Funds 1,399,121
Transfer for Cottageville Park 225,000
Total Expenditures 8,046,484 3,879,180 7,809,802 4,470,124 5,006,094 4,323,045 4,334,238
Working Capital Year End 442,413 422,657 314,757 146,049 (59,387) (282,700) (518,210)
Total Projects Scheduled (CIP & SA) 6,338,523 3,815,000 7,742,800 4,265,300 4,790,300 4,105,000 4,130,000
WATER FUND - WORKING CAPITAL PROJECTION 7/11/2016
Actual Projected Projected Projected Projected Projected Projected
2015 2016 2017 2018 2019 2020 2021
Working Capital Beginning Year 73,581 (176,360) (100,308) (394,340)(928,938) (1,157,362) (1,420,016)
Revenues:
Operating Revenues 1,347,992 1,401,911 1,457,988 1,516,307 1,576,959 1,640,038 1,648,000
Other 166,245 165,235 172,272 179,661 187,418 195,564 204,116
Interest 2,555 0 0 0 0 0 (35,500)
Grants/Other Govt Funding
Gain on Sale of Asset
Trsansfer In - Bond Proceeds 496,275
Bond Issuance 2,200,000 1,600,000 1,100,000 1,700,000 1,500,000 1,500,000
Total Revenues 2,013,066 3,767,146 3,230,260 2,795,968 3,464,377 3,335,602 3,316,616
Expenditures:
Operation Expense 1,396,476 1,111,244 1,150,027 1,190,249 1,231,969 1,275,245 1,320,140
Other Exp - bond issuance-fiscal fee
Other Exp - int on current bonds 50,003 0 0 0
Other Exp - int on refunded bonds
Other Exp - int on 2009 bonds 21,350 19,725 17,887 15,963 13,900 11,600
Other Exp - int on 2012 bonds 12,529 11,629 10,729 9,829 8,929 7,979
Other Exp - int on 2013 bonds 16,431 15,431 14,381 13,281 12,181 11,081
Other Exp -est interest on Future Bonds 13,000 153,000 258,000 328,000 438,000
Equipment Replacement Items 35,000 222,000 0 0
Capital Improvements 376,710 2,270,000 1,700,000 1,550,000 1,768,000 1,510,000 1,500,000
Principal Bond payment
Principal Bond payment - refunded 180,000
Principal Bond pymnt - 2009 debt 50,000 50,000 50,000 55,000 55,000 55,000 60,000
Principal Bond pymnt - 2012 debt 40,000 45,000 45,000 45,000 45,000 45,000 50,000
Principal Bond pymnt - 2013 debt 50,000 50,000 50,000 55,000 55,000 55,000 55,000
Transfer for 2014A Debt Payment 17,800 17,800 17,800 17,800 17,800 17,800 17,800
Principal Bond pymnt - Future Debt 3,740 44,680 71,520 89,960 112,200
Transfer Out - Cottageville Park 37,500
Capital Lease (PW Facility) (1) 45,000 45,000 45,000 45,000 45,000 45,000 45,000
Total Expenditures 2,243,489 3,691,094 3,524,292 3,330,566 3,692,802 3,598,255 3,078,600
Change in available funds (230,423) 76,052 (294,032) (534,598) (228,425) (262,653) 238,016
Inventory change (16,182)
Bond Premium/Discount Exp (3,335)
Working Capital Ending Year (176,360) (100,308)(394,340) (928,938) (1,157,362) (1,420,016) (1,182,000)
(1) Capital Lease moved to Storm Sewer - back to water fund in 2014
Rate History (water/sprinkler)
1984 $0.85
1993 $1.05
1997 $1.10
2000 $1.20
2005 $1.40
Per Utility Master Plan (10/07)
2008 $1.65
2009 $1.86
2010 $1.90
2011 $1.94/2.40 - not incr, left at $1.90
2012 $1.96 / 2.40
2013 $2.02 / 2.40
2014 $2.10 / 2.50
2015 $2.18 / 2.60
2016 $2.25 / 2.70
2017 $2.35 / 2.85
2018 $2.45 / 3.00
projected rate
increases
SEWER FUND - WORKING CAPITAL PROJECTION 7/11/2016
Actual Projected Projected Projected Projected Projected Projected
2015 2016 2017 2018 2019 2020 2021
Working Capital Beginning Year 116,280 385,285 575,986 (363,272) (242,072) (57,025) 132,039
Revenues:
Operating Revenues 2,172,278 2,496,600 2,593,500 2,696,100 2,804,400 2,912,700 3,026,700
Grants/Other Govt Funding
Other 150 20,000 20,000 20,000 20,000 20,000 0
Interest 2,270 963 1,440 (908) (605) (143) 330
Transfer In - Bond Proceeds 297,004
Bond Issuance 0 650,000 575,000 850,000 1,000,000 740,000 750,000
Total Revenues 2,471,701 3,167,563 3,189,940 3,565,192 3,823,795 3,672,557 3,777,030
Expenditures:
Operation Expense 519,685 589,319 609,053 629,484 650,634 672,533 695,207
MWCC Charges (3% inflation) 1,321,360 1,361,001 1,401,831 1,443,886 1,487,203 1,531,819 1,577,774
Other - Bond Issuance-fiscal fees
Interest Expense 39,084 26,575 24,463 22,187 19,825 17,200 14,300
Interest Expense - 2012 Debt 2,749 2,549 2,349 2,149 1,949 1,749
Interest Expense - 2013 Debt 9,318 8,719 8,119 7,519 6,919 6,319
Interest Expense - Future Debt 19,500 35,450 58,500 84,352 100,406
Equipment Replacement Items 33,600 531,000 0
Capital Improvements 106,249 762,000 1,300,000 1,025,000 1,053,000 760,000 750,000
Principal Bond payment (2009) 60,000 65,000 65,000 65,000 70,000 70,000 75,000
Principal Bond payment (2012) 10,000 10,000 10,000 10,000 10,000 10,000 10,000
Principal Bond payment (2013) 30,000 30,000 30,000 30,000 30,000 30,000 30,000
Transfer for 2014A Debt Payment 17,800 17,800 17,800 17,800 17,800 17,800 17,800
Principal Bond payments Future Deb 0 0 43,333 81,667 138,266 204,867
Transfer Out - Cottageville Park 37,500
Capital Lease (PW Facility) (1) 50,000 50,000 50,000 50,000 50,000 50,000 50,000
Total Expenditures 2,191,680 2,976,862 4,129,198 3,443,992 3,638,748 3,483,493 3,228,148
Change in available funds 280,021 190,701 (939,258) 121,200 185,047 189,065 548,882
Inventory change (9,424)
Bond Premium/Discount Exp (1,592)
Working Capital Ending Year 385,285 575,986 (363,272) (242,072) (57,025) 132,039 680,921
(1) Capital Lease moved to Storm Sewer - back in fund in 2014
Rate History
1983 $1.50
1989 $1.75
1991 $2.00
1993 $2.50
1999 $2.25 Rate DECREASE
2006 $2.50 rate increase
Per Utility Master Plan (10/07)
2008 $2.70
2009 $3.10
2010 $3.40
2011 $3.70 - act 3.60
2012 $3.75
2013 $3.90
2014 $4.10
2015 $4.30
2016 $4.55
2017 $4.80
2018 $5.10
projected rate
increases
STORM SEWER FUND - WORKING CAPITAL PROJECTION
Projected Projected Projected Projected Projected Projected Projected
2015 2016 2017 2018 2019 2020 2021
Working Capital Beginning Year 508,676 755,174 1,171,790 1,459,343 1,684,310 898,580 1,137,846
Revenues:
Operating Revenues 799,306 799,306 799,306 799,306 799,306 799,306 799,306
Other 6,236 5,000 5,000 5,000 5,000 5,000 5,000
Interest 8,149 1,888 2,929 3,648 4,211 2,246 2,845
Transfer In - PY Cottageville Park Exp 282,119
Transfer In - Bond Proceeds 605,843
Bond Issuance 500,000 900,000 350,000 500,000 700,000 700,000
Total Revenues 1,701,653 1,306,194 1,707,235 1,157,954 1,308,517 1,506,552 1,507,151
Expenditures:
Operation Expense 135,296 138,002 140,762 143,577 146,449 149,378 152,365
Other - Bond Issuance-fiscal fees
Bond Interest - existing 27,901
Bond Interest - 2009 refunded bonds
Bond Interest - 2010 bonds 13,623 12,485 11,173 9,629 7,805 5,765
Bond Interest - 2012 bonds 5,281 4,881 4,481 4,081 3,681 3,281
Bond Interest - 2013 bonds 7,338 6,888 6,388 5,888 5,388 4,888
Interest Expense - Future Debt 15,000 41,000 48,700 60,200 76,700
C a p i t a l O u t l a y ( p e r E R P ) 000000
Cottageville Property purchase
Cottageville Park Storm Water Mgmt
Capital Improvements 752,892 561,000 1,026,000 471,000 1,592,000 710,000 700,000
2009 Principal Bond payment 125,000
2010 Principal Bond payment 70,000 70,000 70,000 70,000 75,000 80,000 80,000
2012 Principal Bond payment 20,000 20,000 20,000 20,000 20,000 20,000 20,000
2013 Principal Bond payment 20,000 20,000 25,000 25,000 25,000 25,000 25,000
Transfer for 2014A Debt Payment 14,334 14,334 14,334 14,334 14,334 14,334 14,334
Principal Bond payments Future Debt 0 0 33,333 93,333 116,667 150,001
Transfer Out - Cottageville Park 265,000
Capital Lease - PW Facility (1) 25,000 25,000 25,000 25,000 25,000 25,000 25,000
Total Expenditures 1,455,424 889,578 1,419,683 932,986 2,094,247 1,267,287 1,030,633
Change in available funds 246,229 416,616 287,552 224,968 (785,731) 239,266 476,517
Inventory change 413
Bond Premium/Discount Exp (net) (144)
Working Capital Ending Year 755,174 1,171,790 1,459,343 1,684,310 898,580 1,137,846 1,614,363
(1) In 2012 this includes Water, Sewer & Storm Sewer transfers; in 2014 transfer returned to normal level
Rate History (per month)
1989 $4.75 per quarter
1991 $6.00 per quarter
1992 $2.50
1993 $3.00
1998 $3.20
1999 $4.00
2006 $4.50
2009 $5.00
7/11/2016
PAVILION - ICE ARENA - WORKING CAPITAL PROJECTIONS 7/11/2016
Projected Projected Projected Projected Projected Projected Projected
2015 2016 2017 2018 2019 2020 2021
Working Capital Beginning Year (45,591) 20,731 (54,646) (269,645) 498,042 316,406 189,101
Revenues:
Operating Revenues 392,306 356,000 460,449 483,471 507,645 533,027 559,679
Leases
Levy per FMP 64,160 65,000 65,000 65,000 65,000 65,000 65,000
Other 5,925 31,100 20,000 20,000 20,000 20,000 10,000
Interest
Bond Proceeds 3,300,000
Transfer In
Total Revenues 462,391 452,100 545,449 3,868,471 592,645 618,027 634,679
Expenditures:
Operation Expense 373,218 379,852 391,248 402,985 415,075 427,527 440,353
Capital Outlay - ERP - - - - - - -
Capital Improvements - 125,000 347,000 2,676,000 41,000 - -
Equip Certif - principal 20,000 20,000 20,000 20,000 20,000 20,000 20,000
Equip Certif - interest 2,550 2,625 2,200 1,800 1,400 1,000 600
Payment on Interfund Loan - -
Bond Repayment 296,806 296,806 296,806
Total Expenditures 395,768 527,477 760,448 3,100,785 774,281 745,333 757,759
Change in available funds 66,623 (75,377) (214,999) 767,686 (181,636) (127,305) (123,080)
Bond Premium/Discount Exp (net) (301)
Working Capital Ending Year 20,731 (54,646) (269,645) 498,042 316,406 189,101 66,021
Pavilion Projects
CIP 2015 60,000 Evaporator Condenser Replacement
CIP 2016 95,000 Indoor Turf Replacement
CIP 2016 30,000 Exterior Sign
125,000
CIP 2017 140,000 Roof Replacement
CIP 2017 7,000 Desiccant Repl of Dehumidification System
CIP 2017 200,000 Refrigerations System - Engineering
347,000
CIP 2018 35,000 Skate Tile Lobby Improvement
CIP 2018 65,000 Overhead Door Replacement
CIP 2018 75,000 Skate Tile Replacement
CIP 2018 2,400,000 Refrigeration Equipment & Area Floor Replacement
CIP 2018 25,000 Entry & Lobby Door Replacement
CIP 2018 28,000 Paint Pavilion Exterior
CIP 2018 48,000 Painting the Arena Ceiling and Bar Joist
2,676,000
CIP 2019 30,000 Mezzanine Rooftop Unit Replacement
CIP 2019 11,000 HHS Team Room Rooftop Unit Replacement
41,000