HomeMy Public PortalAboutFY 11-15 Water and Sewer CIP TOWN OF
WATERTOWN
1630
i
• c� �y7�`ti � YE'
SUBMITTED WATER AND SEWER
ENTERPRISE BUDGETS
CAPITAL IMPROVEMENT PROGRAM
FISCAL YEAR 2011-2015
FY2011 Capital Improvement Plan General Fund Rev.4.12.10
I B D F G H I J K L M
1184ITEM TOTALS IF
FY'11 I IFY'12 I FY'13 I IFY'14
1185 WATER/SEWER ENTERPRISE FUNDS
1186
187 SEWER I I
188 Drain System Rehabilitation 2,860.01 1§WSR SR NNjj SR SR
1891Use of Retained Earnings-System Rehab. 0.01 1 I
1901Sewer Line Replacement 1 0.01 1 I I I
11911Sewer Line Replacement 1 0.01 1 1 I I I 1 I 1
11921`ervice Truck 1 0.0 1 1 I I 1 1
11931SEWER SUBTOTAL 1 2,860.01 1 715.01 1 715.01 715.01 1 715.01 1
11941 1 I I I I I I I I I I
11951 1 I I I I I I I I
1196 ATER I I I I I I I I I I
1197 Cater systemimprovements I 700.01 WR �WR iWR WR
11981Use of Retained Earnings-System Rehab. 1 0.01 I
11991Water Main Replacement 1 0.01 1 1 1 1 1 1 1
1200I1 Craneyy Truck 1 130.01 1 130.01 W EB fI I I I I I
202IWATEhu5U8TDurn
OT�1L ck 35000 GVW 1 830.01 1 305.01 1 175.01 1 176.01 1 175.01
2031 1 1 1 1 1 1 1 1 1 1
2041 1 1 1 1 1 1 1 1 1 1
2061TOTAL WATER&SEWER 1 3,690.0 1 1,020.01 1 890.01 1 890.0 1 890.01
12061 1 I I 1 1 1 I I I I I
12071 1 1 1 I I I I I I I I
12081COSTS BY SOURCE OF FUNDS
209
210 RETAINED EARNINGS 0.0
12111MWRA Bona-Interest Free I 0.01 1 I I I I I I I
2121MWRA Gran 0.01 1
213
214 WATER EQUIPMENT BONDS 130.0 1 130.0
2151 1 3,690.01 1 1,020.01 1 890.01 1 890.01 1 890.01
12161 1 1 1 1 1 I I I I I
12171 I I I I I I I I
12181 I I I I I I I I I I
1219 GENERAL&fTERPRISE FUNDS .0I1220 GENERAL FD 1 89,344 1I 14,527AI 1I 12,164.31I 1 9,085.31I 1I 6,4571
1221 FUND 1 3,690.01 1 1,020.01 1 890.01 1 890.01 1 8901
K A I
I
1 93,034.01 1 15,547.41 1 13,054,31 1 9,975.31 1 7,3471
ENTERPRISE FUND
Page 1 of 1
FY 2011-2015 CIP Revised 3.4.10
Enterprise Fund Debt Projection
1I 3 FY04 May 0 EWER ANENT DEBT FYI-11 FY'12 11 FY 13 FY'14 FY'15
12
124 Prin (1,500,000)-DPW 75,000 75,000 75,000 75,0001 75,000
125 UT Int (5%) 39,544 37,388 35,063 32,0631 29,663
1126 S!T Int(4.5%) _
1127 Subtotal 114,544 112,388 110,063 107,063 104,663
11281
1129IFY06 Bond(June 06)
11301 Prin(472,526)-MWRA 94,5051 0 0 0 0
11311 L!T Int (0%)
11321 S/T Int(0%)
11331Subtotal _ 94,505 0 0 0 0
11341
11351FY08 Bond (June 08)
11361 Prin(294,140)-MWRA 58,828 58,828 58,828 01 01
1137 UT Int (0%)
1138 SfT Int(0%)
11391Subtotal 58,8281 58,828 58,828 0 01
11401 1 1
11411FY10 Bond(May2010) 1 1
11421 Prin (304,920)-MWRA 60.984 60,9841 60.984 60,984 60,9841
11431 UT Int (0%) 1 1 1
11441 S(r Int(0%) 1 1
1145 Subtotal 60,984 60,984 60,984 60,9841 60,984
1146
1471 Prin 289,317 194,812 194,812 135,984 135,984
1481 UT Int 39,544 37,388 35.063 32,063 29,663
1491 1
1501 SEWER PLANNED BOND DEBT FY'11 FY'12 FY'13 FY'14 FY'15
1511 Prin 289,317 194,812 194,812 135,984 135,984
1521 UT Int 1 39,544 37,388 35,063 32,063 29,663
11631 S/T Int 1 0 0 0 0 0
11541 Total Sewer 328,861 232,200 229,875 168,047 165,647
Page 1 of 3
FY 2011-2Of5 CIP Revised 3.4.10
Enterprise Fund Debt Projection
1 A I I J K L I M I
'11 FY
1155 WATER PERMANENT DEBT FY '12 FY'13 FY'14 FY'15
1156 FY04 Bond (Mar 04) 1
1157 Prin(1,500,000)-DPW 76,000 75,000 75,000 75,000 75,000
1158 UT Int 39,544 37,388 35,063 32,063I 29,663�
1159 SIT Int 1
1160 Subtotal 114,544 112,388 110,063 107,063 104,6631
1161 j
1162 WATER PLANNED BOND DEBT FY'11 FY'12 FY'13 FY'14 FY'15 1
163 FY10 Bond(May 10)
164 Prin(80,000) 16,000 16,000 16,000 16,000 16,000)
165 L/Tlnt (5%) 4,000 3,200 2,400 1,600 800
166 SIT Int(4.5%
1167 Subtotal 20,000 19,200 18,400 17,600 16,800
1168
1169 FY10 Bond(May 10)
1170 Prin(1,736,000)-MWRA 173,636 173,636 173,636 173,636 173,636
1171 LITInt (0%) 0 0 0 0 01
172 Saint (0%)
17' ..Subtotal 173,636 173,636 173,636 173,636 173,6361
174
175 FY11 Bond(May 11)
26,0
1176 Prin(130,000) 00 26,000 26,000 _ 26.0001
1177 LIT Int (5%) 6,500 5,200 3,900 2,600I
1178 SIT Int(4.5%)
1179 Subtotal 0 32,500 31,200 29,900 28,6001
180
181 Prin 264,636 290,636 290,636 290,636 290,636
k182 L/T Int 43,544 47,088 42,663 37,563 33,063
183 SIT Int 0 0 0
1184 Total Water 308,180 337,724 333,299 328,199 323,6991
1185
1186 Totals 7,666,778 8,713,566 9,778,713 8,331,871 8,698,6911
1187 1
I188 RECAPS
189 TOTAL PRINCIPAL&INTEREST FY'11 FY'12 FY'13 FY'14 FY'15 1
190 Long Term Principal 5,939,953 6,736,448 7,810,348 6,482,620I 6,999,6201
1191 Long Term Interest 1,726,82� 1,977,118 1,968,365 1,849,2.. 1,699,071
1192 Short Term Interest 0 0 0 0 0
1193 Total 7,666,778 8,713,666 9,778,713 8,331,871 8,698,6911
Il194
I195 DIFFERENCE I 0 0 0 0I 01
Page 2 of 3.
FY 2011-2015 CIP Revised 3.4.10
Enterprise Fund Debt Projection
A I J I K I L M
1196
1197 GENERALFUND FY'11 FY'12 FY-13 FY114 FYI
1198 L/T Prin 5,386,000 6,251,000 7,324,9001 6056,0001 6,573,000
H99 L/Tlnt 1,643,737 1,892,643 1,890,640 1:779,6261 1,636,346
1200 S/T Int 0 0 0 0 0
1201 Total 7,029,737 8,143,643 9,215,54 7,835,62 8,203
1202
1203 SEWER
1204 L/TPrin 269,317 194,8121 194,812 135,984 135,9841
205 LIT Int 39,544 37,388 35,06 32,063 29.66311
206 S/T Int 0 , 0 0 0 0
120 Total 328,861 232,20 229,875 168,047 165,647
1208 1
1209 WATER
1210 UT Prin 264,636 290,636 290,636 290,6361 290,6361
1211 UT Int 43,5441 47,088 42,663 37,5631 33,0631
1212 SIT Int 0J 0 0 0 01
1213 Total 308,180 337,724I 333,299I 328,199 323,6991
12141 I
12151 TOTAL WATER&SEWER
12161 UT Prin 553,953 485,448 485,448 426,620 426,620
12171 UT Int 83,088 84,475 77,725 69,6251 62,725
12181 S/T Int 0 0 0 01 0
12191 Total 637,041 569,923 563,173 496,2451 489,345
12201 1 12211 TOTAL G.F. &WATER/SEWER 7,666,778 8,713,566 9,778,713 8,331,8711 8,698,691
Page 3 of 3