Loading...
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