CMA 2016 #69 · Agenda item attachment · Mar 21 2016

Table 4 Water Projections FY16-21 FY16 FY16 FY17 FY18 FY19 FY20 FY21 Budget/Recap Projected Budget Projected Projected Projected Projected Water Expenditures: Operating 11,097,610 11,051,280 11,223,705 11,672,653 12,139,559 12,625,142 13,130,147 Existing Debt 2,866,505 2,866,505 2,745,505 2,624,503 2,503,501 471,501 - Subtotal Operating Budget 13,964,115 13,917,785 13,969,210 14,297,156 14,643,060 13,096,643 13,130,147 Capital 4,900,000 4,900,000 5,000,000 3,500,000 3,500,000 5,000,000 5,000,000 Finance 225,000 225,000 225,000 225,000 225,000 225,000 225,000 Conservation 49,085 49,085 52,805 52,805 52,805 52,805 52,805 Public Works 400,000 400,000 400,000 400,000 400,000 400,000 400,000 Community Development 30,000 30,000 30,000 30,000 30,000 30,000 30,000 Animal Commission 10,000 10,000 10,000 10,000 10,000 10,000 10,000 Total Expenditures 19,578,200 19,531,870 19,687,015 18,514,961 18,860,865 18,814,448 18,847,952 Assumptions: 1) Operating Budget for FY17 is based on City Manager's Submitted Budget and increases 4% for FY18-21. 2) Debt Service decreases according to Debt Service Schedule. 3) Capital as shown. 4) All others remain constant from FY17-21. Financing Plan Beginning Fund Balance 11,687,672 11,687,672 10,190,802 8,340,802 8,340,802 8,340,802 8,340,802 Revenue: Meter Revenue 17,128,200 17,135,000 17,137,015 17,814,961 18,160,865 18,114,448 18,147,952 Miscellaneous Water Charges 600,000 900,000 700,000 700,000 700,000 700,000 700,000 From Fund Balance 1,850,000 - 1,850,000 - - - - Total Revenue 19,578,200 18,035,000 19,687,015 18,514,961 18,860,865 18,814,448 18,847,952 Total Expenditures 19,578,200 19,531,870 19,687,015 18,514,961 18,860,865 18,814,448 18,847,952 From Fund Balance 1,850,000 - 1,850,000 - - - - Ending Fund Balance 9,837,672 10,190,802 8,340,802 8,340,802 8,340,802 8,340,802 8,340,802 Projected Rate Increase 0.0% 4.0% 1.9% -0.3% 0.2% 5

Table 5 Sewer Projections FY16-21 FY16 FY16 FY17 FY18 FY19 FY20 FY21 Budget/Recap Projected Budget Projected Projected Projected Projected Sewer Expenditures: Public Works 3,253,755 3,253,755 3,477,745 3,616,855 3,761,529 3,911,990 4,068,470 Capital 1,000,000 1,000,000 1,000,000 1,000,000 2,000,000 2,250,000 2,250,000 Existing Debt 17,786,084 18,029,779 16,745,994 19,262,682 18,084,993 17,205,454 16,135,213 New Debt - - 3,196,743 3,792,750 6,581,250 9,495,750 12,952,000 Finance 225,000 225,000 225,000 225,000 225,000 225,000 225,000 Community Development 44,500 44,500 44,500 44,500 44,500 44,500 44,500 MWRA 23,516,196 23,259,670 23,898,854 24,233,438 25,420,876 27,225,759 28,587,047 Total Expenditures 45,825,535 45,812,704 48,588,836 52,175,225 56,118,148 60,358,453 64,262,230 Assumptions: 1) The FY17 MWRA assessment is based on the preliminary estimate received from the MWRA and reflects a 2.7 % increase from the revised FY16 assessment. FY18-21 assessments are based on annual rate increases of 1.4%, 4.9%, 7.1% and 5.0% respectively. 2) Public Works allocation increases by 7% in FY17 over the FY16 Budget with increases of 4% estimated in FY18-21. 3) Capital is funded at $1,000,000 in FY16-FY18, $2,000,000 in FY19, $2,250,000 in FY20-FY21. 4) Debt Service increases according to Debt Service schedule. 5) All others remain constant. Financing Plan Revenue: Sewer Service Charge 45,181,361 46,350,000 47,844,595 51,430,918 55,373,774 59,614,013 63,517,723 Non- Metered Sewer Revenues 600,000 2,000,000 700,000 700,000 700,000 700,000 700,000 MWPAT Subsidy (existing) 44,174 44,174 44,241 44,307 44,374 44,440 44,507 Total Revenue 45,825,535 48,394,174 48,588,836 52,175,225 56,118,148 60,358,453 64,262,230 Projected Sewer Service Charge Increase 3.2% 7.5% 7.7% 7.7% 6.5% 6

Table 6 Combined Water and Sewer Projections FY16-21 FY16 FY16 FY17 FY18 FY19 FY20 FY21 Budget / Recap Projected Budget Projected Projected Projected Projected Metered Water Revenue 17,128,200 17,135,000 17,137,015 17,814,961 18,160,865 18,114,448 18,147,952 Metered Sewer Revenue 45,181,361 46,350,000 47,844,595 51,430,918 55,373,774 59,614,013 63,517,723 Total 62,309,561 63,485,000 64,981,610 69,245,879 73,534,639 77,728,461 81,665,675 % Increase - - 2.4% 6.6% 6.2% 5.7% 5.1% 7

Table 7 Water Fund Balances FY11-16 As of 6/30/11 As of 6/30/12 As of 6/30/13 As of 6/30/14 As of 6/30/15 Projected 6/30/16 (Actual) (Actual) (Actual) (Actual) (Actual) (Projected) Water Fund Balance 6,988,537 8,410,762 9,076,357 9,741,315 11,687,672 10,190,802 8