Loading...
Section XII. Enterprise Funds - Sewer_2Town and County of Nantucket 16 Broad Street Nantucket, MA 02554 FY2017 BUDGET PROJECTION •ENTERPRISE FUNDS •SEWER FY 2017 Budget Department of Public Works Sewer Enterprise Fund FY2016 DPW Sewer Enterprise Fund Review Mission: The mission of the Nantucket Sewer Enterprise Fund is to provide for public health and safety by maintenance of the municipal sewer system including the wastewater treatment plants, pump stations and sewer mains Goals: Continue to meet state mandated discharge limits for treated effluent. Implement the Comprehensive Wastewater Management Plan (CWMP). Initiatives and Accomplishments: •Comprehensive Wastewater Management Plan 20 year capital plan proposed. •Extensive Capital plan itemized and presented to financial Committees •Department being run proactively instead of waiting until things are broken to fix them. SEWER ENTERPRISE FUND FY 2017 Sewer Enterprise Fund Overview •Priority: Develop a funding plan for the CWMP Capital Plan that is supported by all. •Significant Changes Year-to-Year Implementation of recommended 20 year Capital Plan from CWMP. •Key Issues An equitable Financing plan for the proposed CWMP- 20 year Capital Plan will be the biggest issue for the Sewer Enterprise Fund. Design and program repairs for long-standing maintenance issues. SEWER ENTERPRISE FUND FY2017 Budget DPW- Sewer Enterprise SEWER ENTERPRISE FUND FY 2013 ACTUAL FY2014 ACTUAL FY2015 ACTUAL COMPOUND ANNUAL GROWTH RATE FY2016 BUDGET FY2017 PROPOSED BUDGET FY 2017 INCREASE OR (DECREASE) $ FY 2017 INCREASE OR (DECREASE) % SUMMARY Payroll-Salary $ 861,412 $ 779,824 $ 827,022 -2.0% $ 875,410 $ 977,370 $ 126,960 14.5% Contractual Obligations $ - $ - $ - 0.0% $ - $ - $ - 100.0% Medicare P/R Tax Expense $ 18,951 $ 11,155 $ 11,973 -20.5% $ 12,600 $ 14,200 $ 1,600 12.7% Medical Insurance $ 167,535 $ 169,696 $ 201,108 9.6% $ 214,900 $ 245,278 $ 30,378 14.1% Barnstable County Retirement $ 229,213 $ 141,587 $ 124,806 -26.2% $ 138,955 $ 130,422 $ (8,533) -6.1% Utilities $ 475,515 $ 451,632 $ 576,985 10.2% $ 542,000 $ 612,300 $ 55,300 10.2% Repairs & Maintenance $ 168,078 $ 103,140 $ 174,364 1.9% $ 165,100 $ 170,500 $ 5,400 3.3% Professional Services $ 100,130 $ 98,586 $ 168,542 29.7% $ 190,900 $ 190,900 $ (10,000) -5.2% Sludge Disposal Costs $ 215,578 $ 201,468 $ 222,667 1.6% $ 210,000 $ 230,000 $ 20,000 9.5% Sewer Supplies and Chemicals $ 122,870 $ 113,032 $ 119,286 -1.5% $ 113,470 $ 123,520 $ 10,050 8.9% General Insurance $ 114,946 $ 120,750 $ 123,219 3.5% $ 128,850 $ 141,510 $ 12,660 9.8% Other Supplies $ 8,793 $ 12,503 $ 3,203 -39.6% $ 13,300 $ 3,600 $ (9,700) -72.9% Travel $ 17,375 $ 14,851 $ 14,136 -9.8% $ 14,945 $ 13,300 $ (1,645) -11.0% Debt Service $ 3,137,615 $ 3,155,500 $ 3,156,080 0.3% $ 3,895,932 $ 3,821,895 $ (74,036) -1.9% Indirect Costs $ 79,235 $ 192,316 $ 76,000 -2.1% $ 82,000 $ 82,000 $ - 0.0% Other $ 93,081 $ 164,700 $ 94,938 1.0% $ 194,742 $ 114,180 $ (80,563) -41.4% TOTAL SEWER $ 5,810,329 $ 5,730,741 $ 5,894,330 0.7% $ 6,793,104 $ 6,870,975 $ 77,871 1% Appendix Department of Public Works Sewer Enterprise Fund Town & County of Nantucket Organization Chart – DPW DPW Director Town Engineer Assistant Town Engineer (unfunded FY 2019) Engineering Tech. (proposed FY 2017) Central Fleet Mgr (unfunded FY2020) Maint Tech (2) Public Facilities Mgr Facility Foreman LiUNA Equipment Operator Laborer Laborer (unfunded FY 2018) Seasonal (3) Operations Manager Working Foreman (3) Sr. Equipment Operator (2) Equipment Operator (5) (+2 unfunded FY 2018) Laborer (5) (+2 unfunded FY 2019) Seasonal (7) Parks Division Working Foreman (1) Laborer(1) Seasonal (3) Solid Waste/ Landfill Operations WON Operations Administration contracted Procuremt/Off Mgr (proposed FY2017) Office Admin (2) (+1 unfunded FY 2020) Deputy DPW Director (Unfunded-FY 2018) FY 2017 Budget Detail SEWER ENTERPRISE FUND TOWN OF NANTUCKET SEWER - ENTERPRISE FUND Actual BUDGET PROJECTED BUDGETFY2015FY2016FY2017 REVENUE 6,779,613 6,475,875 6,804,820 EXPENSES 5,685,332 6,793,104 6,870,975 NET EARNINGS 1,094,281 (317,229) (66,155) Transfer from Retained Earnings - 317,229 66,155 NET EARNINGS 1,094,281 - - NET SOURCES/USES: Ending FB 1,094,281 - - TOTAL Certified Retained Earnings as of July 1, 2015 3,872,311 SEWER ENTERPRISEWASTE WATER TREATMENT DEPT ACCOUNT ACCOUNT NAME6644041710P&I (1,394)$ (393)$ (3,256)$ 52.8%-$ (3,300)$ 3,300$ 0.0% 66440 42460 SEWER FEE INCOME (5,504,396)$ (5,753,902)$ (5,957,651)$ 4.0%(5,753,905)$ (5,960,000)$ 206,095$ 3.6% 66440 42461 DPW SEWER PERMITS (153,025)$ (193,750)$ (230,018)$ 22.6%(193,750)$ (230,020)$ 36,270$ 18.7% 66440 42462 SEWER LIENS COLLECTED (24,713)$ (3,676)$ (13,454)$ -26.2%(3,675)$ (13,500)$ 9,825$ 267.3% 66440 42463 SEWER PRIVILEGE FEE (425,495)$ (306,579)$ (393,608)$ -3.8%(306,580)$ (395,000)$ 88,420$ 28.8%66440 42464 SEWER PRIVELEGE INT FEE (32,613)$ (38,508)$ (37,454)$ 7.2%(38,510)$ (37,500)$ (1,010)$ -2.6%66440 43275 SEPTIC DISPOSAL FEES (128,040)$ (173,304)$ (165,399)$ 13.7%(173,305)$ (165,500)$ (7,805)$ -4.5%66440 48201 INTEREST ON INVESTMENTS (7,892)$ (6,151)$ -$ -100.0%(6,150)$ -$ (6,150)$ -100.0%66440 49000 REFUNDS -$ -$ 21,228$ 100.0%-$ -$ -$ 0.0% 66440 51100 SALARY, PERMANENT 523,220$ 497,582$ 552,164$ 2.7%608,100$ 705,300$ 97,200$ 16.0% 66440 51300 OVERTIME 56,443$ 73,827$ 89,684$ 26.1%75,000$ 75,000$ 15,000$ 20.0% 66440 51700 LONGEVITY PAY 1,210$ 7,246$ 7,236$ 144.5%8,300$ 10,260$ 1,960$ 23.6% 66440 51701 INS PREM: MEDICAL BLUE CROSS 145,291$ 152,874$ 166,738$ 7.1%182,200$ 206,378$ 24,178$ 13.3%66440 51770 BARNSTABLE COUNTY RETIREMT FND 229,213$ 141,587$ 124,806$ -26.2%138,955$ 130,422$ (8,533)$ -6.1%66440 51900 CONTRACTUAL OBLIGATIONS -$ -$ -$ 0.0%-$ -$ -$ 0.0%66440 51960 COMPENSATION/UNEMPLOYMENT -$ 10,467$ 1,180$ 100.0%-$ -$ -$ 0.0%66440 51961 MEDICARE P/R TAX 15,310$ 8,390$ 9,412$ -21.6%10,000$ 11,500$ 1,500$ 15.0%66440 51999 FINCOM TRANSFER SALARIES -$ -$ -$ 0.0%-$ -$ -$ 0.0% 66440 52101 UTILITY: ELECTRICITY 286,164$ 269,765$ 387,047$ 16.3%330,000$ 400,000$ 55,000$ 16.7% 66440 52103 UTILITY: FUEL OIL 57,597$ 65,751$ 54,527$ -2.7%69,700$ 60,000$ (9,700)$ -13.9% 66440 52107 UTILITY: LANDFILL -$ -$ -$ 0.0%-$ -$ -$ 0.0%66440 52401 REP&MAINT: OFFICE EQUIP -$ -$ -$ 0.0%-$ -$ -$ 0.0%66440 52403 REP&MAINT VEHICLE 236$ 100$ 21,880$ 863.3%-$ -$ -$ 0.0%66440 52404 REP&MAINT: BUILDING 37,812$ 10,370$ 12,226$ -43.1%10,500$ 12,500$ 2,000$ 19.0%66440 52405 REP&MAINT: EQUIPMENT 87,048$ 52,765$ 104,922$ 9.8%55,000$ 85,000$ 30,000$ 54.5%66440 52407 REP&MAINT: SEWER -$ -$ 4,898$ 100.0%-$ -$ -$ 0.0% 66440 52700 RENTALS/LEASES -$ -$ -$ 0.0%-$ -$ -$ 0.0% 66440 52901 SLUDGE DISPOSAL COSTS 215,578$ 201,468$ 222,667$ 1.6%210,000$ 230,000$ 20,000$ 9.5% 66440 53100 PROFESSIONAL SERVICES 46,155$ 7,856$ 86,729$ 37.1%100,000$ 100,000$ -$ 0.0% 66440 53103 GENERAL: ADVERTISING -$ 383$ -$ 0.0%400$ -$ (400)$ -100.0%66440 53115 LAB TESTING 4,646$ 4,317$ 9,776$ 45.1%4,400$ 10,000$ 5,600$ 127.3%66440 53154 PRIVILEGE RECORDING FEE -$ -$ -$ 0.0%-$ -$ -$ 0.0%66440 53401 COMM: TELEPHONE 17,903$ 16,274$ 15,374$ -7.3%18,000$ 18,000$ -$ 0.0%66440 53402 COMM: POSTAGE 6,148$ 1,185$ -$ -100.0%1,200$ -$ (1,200)$ -100.0% 66440 53803 OTHER LICENSES & TAXES 450$ 315$ 817$ 34.7%320$ 900$ 580$ 181.3% 66440 53804 OTHER: FREIGHT 1,205$ 191$ 6,987$ 140.8%200$ 7,500$ 7,300$ 3650.0% 66440 54201 OFFICE SUPPLIES 1,705$ 747$ 1,089$ -20.1%1,000$ 1,100$ 100$ 10.0% 66440 54303 BLDG&EXPENDABLE SUP/EQ 6,628$ 6,868$ 2,114$ -43.5%7,000$ 2,500$ (4,500)$ -64.3%66440 54701 SAFETY: UNIFORMS 2,737$ 1,388$ 4,157$ 23.2%1,400$ 3,000$ 1,600$ 114.3%66440 54702 SAFETY: PROTECTIVE CLOTHING -$ 1,914$ -$ 0.0%2,000$ -$ (2,000)$ 100.0%66440 55001 MEDICAL SUPPLIES 460$ 160$ -$ -100.0%500$ -$ (500)$ -100.0%66440 55101 BOOKS/SUBSCRIPTIONS 200$ -$ 159$ -10.8%-$ 200$ 200$ 100.0%66440 55302 DPW: SEWER SUPPLIES, PIPES 7,080$ 3,427$ 1,417$ -55.3%3,500$ 3,500$ -$ 0.0% 66440 55306 CHEMICALS 109,378$ 101,635$ 114,776$ 2.4%102,000$ 115,000$ 13,000$ 12.7% 66440 57101 IN-STATE MISC TRAVEL 9,179$ 9,033$ 9,192$ 0.1%9,000$ 9,000$ -$ 0.0% 66440 57102 IN-STATE:MILEAGE/CAR ALLW 12$ 79$ 265$ 365.9%100$ 300$ 200$ 200.0%66440 57103 IN-STATE SEMINARS, PROF GA 8,184$ 5,394$ 3,894$ -31.0%5,500$ 4,000$ (1,500)$ -27.3%66440 57404 INS PREM: BLANKET INS, BLDG 79,511$ 82,637$ 84,371$ 3.0%87,500$ 98,000$ 10,500$ 12.0%66440 57406 INS PREM: CLAIM DEDUCTIBLE -$ -$ -$ 0.0%-$ -$ -$ 0.0% FY2016 BUDGET SEWER ENTERPRISE FUND OPERATIONS BUDGET FISCAL YEAR 2017 FY 2017 INCREASE OR (DECREASE) $ FY 2017 INCREASE OR (DECREASE) % FY 2015 ACTUAL COMPOUND ANNUAL GROWTH RATE FY 2014 ACTUAL FY 2013 ACTUAL FY2017 PROPOSED BUDGET 66440 57502 INS: WORKMANS' COMP 27,204$ -$ -$ -100.0%-$ -$ -$ 0.0% 66440 57999 MWPAT ADMIN FEE 58,919$ 53,939$ 53,830$ -4.4%60,000$ 60,000$ -$ 0.0% 66440 57899 CONTINGENCY / UNALLOCATED EXP -$ -$ -$ 0.0%12,972$ 12,930$ (43)$ -0.3%66440 58501 ADD EQ:NEW EQUIP- PUMP STATION -$ -$ 470$ 100.0%100,000$ -$ (100,000)$ 0.0%66440 59101 DEBT SERVICE: PRINCIPAL 563,200$ 588,200$ 580,900$ 1.6%737,875$ 779,818$ 41,943 5.7%66440 59102 DEBT SERVICE INTEREST 223,510$ 217,683$ 199,263$ -5.6%224,880$ 258,266$ 33,386 14.8%66440 59103 BOND ISSUE EXPENSE 3,500$ 2,375$ 17,500$ 123.6%4,000$ 18,000$ 14,000$ 350.0% 66440 59108 DEBT SERVICE SHORT TERM INTEREST -$ -$ -$ 0.0%50,000$ 50,000$ -$ 100.0% 66440 59113 WATER POLLUTION ABATMT PRN 1,518,602$ 1,550,334$ 1,586,078$ 2.2%1,866,875$ 1,815,217$ (51,658)$ 0.0% 66440 59114 WATER POLL ABATEMENT INT 828,803$ 792,098$ 756,479$ -4.5%1,007,502$ 884,595$ (122,907)$ 0.0% 66440 59250 INTEREST: GENERAL -$ 4,811$ 15,859$ 100.0%4,800$ 16,000$ 11,200$ 0.0%66440 59501 OTHER FIN: GENERAL -$ -$ -$ 0.0%-$ -$ -$ 0.0%66440 59991 TRANSFER TO GF- INDIRECT COSTS 74,200$ 192,316$ 76,000$ 1.2%82,000$ 82,000$ -$ 0.0%66440 59993 TRANS TO CAPITAL PROJECT FUND -$ 90,000$ -$ 0.0%-$ -$ -$ 0.0%TOTAL REVENUE (6,277,568)$ (6,476,263)$ (6,779,613)$ 3.9%(6,475,875)$ (6,804,820)$ 328,945$ 5.1% TOTAL EXPENSE 5,254,642$ 5,227,749$ 5,386,883$ 1.3%6,192,679$ 6,276,185$ 83,506$ 1% SEWER COLLECT & DISPOSAL DEPT ACCOUNT ACCOUNT NAME6644549102BOND PROCEEDS -$ -$ -$ 0.0%-$ -$ -$ 0.0% 66445 51100 SALARY, PERMANENT 144,327$ 99,732$ 69,027$ -30.8%67,300$ 68,600$ 1,300$ 1.9% 66445 51300 OVERTIME 21,042$ 18,101$ 25,458$ 10.0%15,000$ 15,000$ 10,000$ 66.7% 66445 51700 LONGEVITY 5,867$ 7,074$ 3,593$ -21.7%3,400$ 3,400$ -$ 0.0% 66445 51701 INS:MED BLUE CROSS 14,763$ 10,047$ 25,381$ 31.1%20,200$ 28,700$ 8,500$ 42.1%66445 51961 MEDICARE P/R TAX 2,463$ 1,811$ 1,422$ -24.0%1,200$ 1,300$ 100$ 8.3%66445 51999 FINCOM TRANSFER SALARIES -$ -$ -$ 0.0%-$ -$ -$ 0.0%66445 52101 UTILITY:ELECTRICTY 38,166$ 37,372$ 49,379$ 13.7%45,000$ 55,000$ 10,000$ 22.2%66445 52103 UTILITY:FUEL 1,860$ 472$ -$ -100.0%700$ 700$ -$ 0.0% 66445 52105 UTILITY:WATER 4,752$ 3,697$ 3,255$ -17.2%3,800$ 3,800$ -$ 0.0% 66445 52404 REP&MAINT:BUILDING 2,255$ 746$ 1,000$ -33.4%1,500$ 1,500$ -$ 0.0% 66445 52405 REP&MAINT:EQUIPMENT 2,638$ 10,952$ 8,010$ 74.2%11,000$ 8,000$ (3,000)$ -27.3% 66445 52407 REP&MAINT:SEWERS 23,761$ 9,019$ 2,367$ -68.4%9,200$ 3,500$ (5,700)$ -62.0%66445 53100 PROFESSIONAL SERVICES 53,975$ 90,343$ 80,000$ 21.7%90,500$ 90,500$ (10,000)$ -11.0%66445 53401 COMM:TELEPHONE -$ -$ -$ 0.0%-$ -$ -$ 0.0%66445 53402 COMM:POSTAGE 17,175$ 9,191$ 17,175$ 0.0%10,000$ 18,000$ 8,000$ 80.0%66445 53803 OTHER: LICENSE -$ 110$ -$ 0.0%-$ -$ -$ 0.0%66445 54201 OFFICE SUPPLIES -$ 4,728$ -$ 0.0%4,800$ -$ (4,800)$ 100.0% 66445 54701 SAFETY:UNIFORMS 224$ 196$ -$ -100.0%200$ -$ (200)$ -100.0% 66445 54702 SAFETY:PROTECTIVE CLOTHING -$ -$ -$ 0.0%-$ -$ -$ 0.0% 66445 55302 DPW:SEWER 442$ 762$ 520$ 8.5%770$ 520$ (250)$ -32.5%66445 57101 IN-STATE:MISC TRAVEL -$ 345$ -$ 0.0%345$ -$ (345)$ 100.0%66445 57502 INS: WORKMANS COMP 84$ -$ 108$ 13.6%-$ -$ -$ 0.0%66445 57404 INS PREM:BLANKET INS, BLDG 9,029$ 11,318$ 11,755$ 14.1%11,350$ 13,165$ 1,815$ 16.0%66445 59991 TRANSFER TO GENERAL FUND 5,035$ -$ -$ -100.0%-$ -$ -$ 0.0%TOTAL REVENUE -$ 0.0%-$ -$ 0.0% TOTAL EXPENSE 347,859$ 316,016$ 298,449$ -7.4%296,265$ 311,685$ 15,420$ 5% FY 2015 ACTUAL FY 2017 INCREASE OR (DECREASE) $ FY 2017 INCREASE OR (DECREASE) % COMPOUND ANNUAL GROWTH RATE FY2014 ACTUAL FY2016 BUDGET FY 2013 ACTUAL FY2017 PROPOSED BUDGET SCONSET WATER TREATMENT DEPT ACCOUNT ACCOUNT NAME6644649902BOND ANTICIPATION NOTES -$ -$ -$ 0.0%-$ -$ -$ 0.0%66446 51100 SALARY, PERMANENT 68,246$ 64,327$ 73,473$ 3.8%75,400$ 76,900$ 1,500$ 2.0% 66446 51300 OVERTIME 8,724$ -$ 2,852$ -42.8%20,610$ 20,610$ -$ 0.0% 66446 51700 LONGEVITY PAY 4,997$ 1,468$ 2,248$ -32.9%2,300$ 2,300$ -$ 0.0% 66446 51701 INS:MED BLUE CROSS 7,482$ 6,776$ 8,989$ 9.6%12,500$ 10,200$ (2,300)$ -18.4% 66446 51961 MEDICARE P/R TAX 1,179$ 954$ 1,139$ -1.7%1,400$ 1,400$ -$ 0.0%66446 52101 UTILITY:ELECTRICITY 52,893$ 40,089$ 51,739$ -1.1%55,000$ 55,000$ -$ 0.0%66446 52103 UTILITY:FUEL 14,681$ 16,439$ 14,381$ -1.0%18,000$ 18,000$ -$ 0.0%66446 52105 UTILITY:WATER 1,500$ 1,773$ 1,283$ -7.5%1,800$ 1,800$ -$ 0.0%66446 52403 REP&MAINT VEHICLE -$ -$ -$ 0.0%-$ -$ -$ 0.0% 66446 52404 REP&MAINT:BUILDING -$ 9,370$ 5,967$ 100.0%10,000$ 10,000$ -$ 0.0% 66446 52405 REP&MAINT:EQUIPMENT 14,328$ 9,819$ 13,095$ -4.4%67,900$ 50,000$ (17,900)$ -26.4% 66446 53100 PROFESSIONAL SERVICES -$ 387$ 1,813$ 100.0%400$ 400$ -$ 100.0% 66446 53115 LAB TESTING 1,155$ 1,203$ 1,569$ 16.5%1,200$ 1,200$ -$ 0.0%66446 53401 COMM:TELEPHONE -$ -$ -$ 0.0%-$ -$ -$ 0.0%66446 53402 COMM: POSTAGE -$ 117$ -$ 0.0%200$ 200$ -$ 100.0%66446 53804 OTHER:FREIGHT -$ -$ -$ 0.0%-$ -$ -$ 0.0%66446 54201 OFFICE SUPPLIES -$ -$ -$ 0.0%-$ -$ -$ 0.0%66446 54701 SAFETY: UNIFORMS 221$ 250$ -$ -100.0%250$ 250$ -$ 0.0% 66446 55302 DPW:SEWER 1,038$ 2,005$ 1,077$ 1.9%2,000$ 2,000$ (500)$ -25.0% 66446 55306 CHEMICALS 4,932$ 5,203$ 1,495$ -44.9%5,200$ 2,500$ (2,200)$ -42.3% 66446 57101 IN STATE: MISC TRAVEL -$ -$ 784$ 100.0%-$ -$ -$ 0.0%66446 57404 INS PREM: BLANKET INS, BLDG 26,407$ 26,795$ 27,093$ 1.3%30,000$ 30,345$ 345$ 1.1%66446 57502 INS: WORKMAN'S COMP 47$ -$ -$ -100.0%-$ -$ -$ 0.0%TOTAL REVENUE -$ -$ -$ -$ 0.0% TOTAL EXPENSE 207,828$ 186,976$ -100.0%304,160$ 283,105$ (21,055)$ -7% SEWER ENTERPRISE GRAND TOTAL TOTAL REVENUE (6,277,568)$ (6,476,263)$ (6,779,613)$ 3.9%(6,475,875)$ (6,804,820)$ 328,945$ 5.1% TOTAL EXPENSE 6,262,692$ 5,730,741$ 5,685,332$ -4.7%6,793,104$ 6,870,975$ 77,871$ 1.1% VARIANCE (Excess) / Deficit (14,876)$ (745,522)$ (1,094,281)$ 757.7%317,229$ 66,155$ (251,074)$ -79.1% SOURCE: RETAINED EARNINGS* $ 14,876 $ - $ 1,094,281 757.7% $ (317,229) $ (66,155) $ 251,074 REMAINING VARIANCE $ - $ (745,522) $ - $ - $ - $ - FY 2015 ACTUAL FY 2017 INCREASE OR (DECREASE) % FY 2017 INCREASE OR (DECREASE) $ COMPOUND ANNUAL GROWTH RATE FY2014 ACTUAL FY2016 BUDGET FY 2013 ACTUAL FY2017 PROPOSED BUDGET SUMMARY Payroll-Salary 861,412$ 779,824$ 827,022$ -2.0%875,410$ 977,370$ 126,960$ 14.5% Contractual Obligations -$ -$ -$ 0.0%-$ -$ -$ 100.0% Medicare P/R Tax Expense 18,951$ 11,155$ 11,973$ -20.5%12,600$ 14,200$ 1,600$ 12.7% Medical Insurance 167,535$ 169,696$ 201,108$ 9.6%214,900$ 245,278$ 30,378$ 14.1% Barnstable County Retirement 229,213$ 141,587$ 124,806$ -26.2%138,955$ 130,422$ (8,533)$ -6.1%Utilities 475,515$ 451,632$ 576,985$ 10.2%542,000$ 612,300$ 55,300$ 10.2%Repairs & Maintenance 168,078$ 103,140$ 174,364$ 1.9%165,100$ 170,500$ 5,400$ 3.3%Professional Services 100,130$ 98,586$ 168,542$ 29.7%190,900$ 190,900$ (10,000)$ -5.2%Sludge Disposal Costs 215,578$ 201,468$ 222,667$ 1.6%210,000$ 230,000$ 20,000$ 9.5% Sewer Supplies and Chemicals 122,870$ 113,032$ 119,286$ -1.5%113,470$ 123,520$ 10,050$ 8.9% General Insurance 114,946$ 120,750$ 123,219$ 3.5%128,850$ 141,510$ 12,660$ 9.8% Other Supplies 8,793$ 12,503$ 3,203$ -39.6%13,300$ 3,600$ (9,700)$ -72.9% Travel 17,375$ 14,851$ 14,136$ -9.8%14,945$ 13,300$ (1,645)$ -11.0%Debt Service 3,137,615$ 3,155,500$ 3,156,080$ 0.3%3,895,932$ 3,821,895$ (74,036)$ -1.9%Indirect Costs 79,235$ 192,316$ 76,000$ -2.1%82,000$ 82,000$ -$ 0.0%Other 93,081$ 164,700$ 94,938$ 1.0%194,742$ 114,180$ (80,563)$ -41.4% TOTAL SEWER 5,810,329$ 5,730,741$ 5,894,330$ 0.7%6,793,104$ 6,870,975$ 77,871$ 1% FY2017 PROPOSED BUDGET FY2016 BUDGET FY2014 ACTUAL FY 2017 INCREASE OR (DECREASE) $ FY 2017 INCREASE OR (DECREASE) % FY 2013 ACTUAL COMPOUND ANNUAL GROWTH RATE FY2015 ACTUAL Sewer Enterprise FundNumber of Positions in Department ORG: 66440 ORG: 66445 ORG: 66446Full-time 7 2 1Part-time 0 0 0 Seasonal 0 0 0Temporary000Vacancies100New Positions Requested 1 0 0 TOTAL OF ALL POSITIONS 9 2 1 Name Position Avg Hours Per Week Job Code Class & Step as of 6/30/16 (e.g., B -Step 3) Yearly Salary as of 6/30/16 53 Week Adjustment FY17 Anniversary Date FY 2017 Projected Salary LongevityPay EducationPay CertificationPay HolidayPay Other Total byEmployee ORG: 66440TBD Sewer Manager 40.00 NON UNION 125,000 125,000 INGLIS, R ASSISTANT CHIEF 40.00 PW10 M6 Step 7 76,646 76,852 11/05/16 76,900 3,800 0 0 0 0 80,700ALLEN, P.MAINT TECH SEWER 40.00 PW43 M3 Step 2 57,312 57,467 08/03/16 57,500 0 0 0 0 0 57,500LEVEILLE, W SW LAB TECH 40.00 PW42 M4 Step 7 71,932 72,126 12/23/16 72,100 2,200 0 0 0 0 74,300 GRAY, D CHIEF PLANT MANAGER 40.00 PW47 NON UNION 96,300 96,559 12/08/16 97,600 0 0 0 0 0 97,600 FRAZIER, P.MAINT TECH SEWER 40.00 PW41 M3 Step 6 64,508 64,681 01/19/17 64,700 0 0 0 0 0 64,700HARDY, J.MAINT TECH SEWER 40.00 PW51 M3 Step 7 68,387 68,571 10/21/16 68,600 0 0 0 0 0 68,600MOONEY, S.MAINT TECH SEWER 40.00 PW43 M3 Step 7 68,387 68,571 12/20/17 68,600 2,060 0 0 0 0 70,660 GARY, A.MAINT TECH SEWER 40.00 PW44 M5 Step 7 74,081 74,280 07/05/16 74,300 2,200 0 0 0 0 76,500 ORG: 66445BUTLER, P SEWER COLLECTIONS 40.00 PW26 M3 Step 7 68,387 68,571 07/01/16 68,600 3,400 0 0 0 0 72,000 ORG: 66446MANNING, K ASSISTANT CHIEF 40.00 PW31 M6 Step 7 76,646 76,852 05/18/17 76,900 2,300 0 0 0 0 79,200850,800 15,960 0 0 0 0 866,760 org:66440 org: 66445 org:66446705,300 68,600 76,90000010,260 3,400 2,300 0 0 0 0 0 0000000 0 0 0 75,000 15,000 20,610 790,560 87,000 99,810 11,500 1,300 1,400 206,378 28,700 10,2001,008,438 117,000 111,410 Total Longevity (enter on Munis 51700) Total Personnel Services Total Education (enter on Munis 516xx) Total Cerfification Pay (enter on Munis 51551)Total Holiday Pay (enter on Munis 518xx)Total Other Pay (enter on Munis line where appropriate) Shift Differential (enter on Munis 513xx) Overtime (enter on Munis 514xx) Salary Subtotal Medicare (enter on Munis 51961) Insurance:Medical BSBC (enter Munis 51701) FY 2017 Personnel Spreadsheet ORG: 66440; 66445; 66446 Total Prorated Salary (enter on Munis 51100)Total Seasonal Salary (enter on Munis 51xxx) EXISTING DEBT AS OF 06/30/2015 SEWER ENTERPRISE Original TOTAL TOTAL TOTAL ************************** Issue Principal PRINCIPAL INTEREST P & I Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments Date Amount 6/30/2015 6/30/2015 6/30/2015 FY2015 FY2016 FY2017 FY2018 FY2019 FY2020 FY2021 FY2022 FY2023 FY2024 FY2025 FY2026 FY2027 Sewer Enterprise Fund - Budget TOTAL DEBT 56,200,717 52,424,230 48,686,334 45,138,251 41,696,548 38,286,630 34,901,342 31,685,205 28,497,567 25,483,444 22,658,383 20,363,189 MWPAT 94-10 8/1/2001 223,207 0 0 0 23,008 MWPAT 98-143 8/25/2004 849,513 365,000 56,609 421,609 75,321 72,307 74,100 70,791 67,794 69,911 66,706 MWPAT 98-144 8/25/2004 189,405 90,000 13,494 103,494 14,979 19,180 18,396 17,568 16,823 16,133 15,394 MWPAT 98-145 8/25/2004 208,754 90,000 13,494 103,494 20,034 19,180 18,396 17,568 16,823 16,133 15,394 MWPAT CW 02 50A 11/23/2004 5,648,263 2,776,951 490,156 3,267,107 432,423 426,714 418,916 416,378 421,687 403,974 404,747 395,092 379,599 MWPAT CW 02 50 10/26/2006 4,015,365 2,772,127 730,245 3,502,372 320,826 320,130 311,702 310,247 304,298 302,721 296,406 298,564 304,183 533,491 520,630 MWPAT CW 01 40 12/14/2006 1,656,115 985,000 204,104 1,189,104 145,329 140,104 139,867 138,533 132,626 132,803 132,321 126,923 125,928 120,000 SEWER CONSTRUCTION 2/15/2008 250,000 145,000 38,131 183,131 21,006 20,556 20,088 19,600 14,075 13,713 13,313 12,913 12,513 12,113 11,700 11,275 10,850 SEWER CONSTRUCTION 2/15/2008 870,000 555,000 153,831 708,831 67,875 66,525 65,119 63,656 62,081 60,450 58,650 56,850 50,050 48,450 46,800 45,100 43,400 SEWER 2 2/15/2008 1,435,075 910,000 259,875 1,169,875 112,688 105,438 103,250 100,975 98,525 95,988 93,188 90,388 87,588 84,788 81,900 78,925 75,950 66%% WWTF 2/15/2008 398,013 171,600 49,005 220,605 20,279 19,883 19,470 19,041 18,579 18,101 17,573 17,045 16,517 15,989 15,444 14,883 14,322 MWPAT CW 04 20 12/9/2008 3,125,318 2,205,771 275,197 2,480,968 206,747 206,747 206,748 206,747 206,748 206,747 206,748 206,747 206,747 206,747 206,747 206,747 206,748 66% MWPAT CW0521 12/15/2009 39,123,696 22,391,970 6,787,471 29,179,441 1,268,672 1,268,672 1,268,671 1,268,672 1,268,671 1,268,673 1,268,671 1,268,671 1,268,671 1,268,671 1,268,671 1,268,671 1,268,672 MWPAT CW 07 17 7/8/2010 4,006,000 3,327,615 560,652 3,888,267 243,017 243,017 243,017 243,017 243,017 243,017 243,017 243,017 243,017 243,016 243,017 243,017 243,017 SEWER CURRENT REFUNDING 05/2001 6/7/2012 371,100 240,400 33,806 274,206 52,123 50,606 48,600 46,600 44,600 42,800 41,000 SEWER ADVANCED REFUNDING 12/01/2003 6/7/2012 545,000 485,000 101,050 586,050 83,400 81,600 79,200 71,325 68,575 66,100 63,625 56,000 53,500 46,125 SEWER IMPROVEMENTS 6/7/2012 2,000,000 1,700,000 543,500 2,243,500 170,500 167,500 163,500 158,500 153,500 149,000 144,500 139,500 134,500 129,500 124,500 120,500 117,500 WASTEWATER MANAGEMENT 6/7/2012 750,000 300,000 13,500 313,500 164,250 159,750 153,750 SEWER EQUIPMENT 6/6/2013 275,000 165,000 4,950 169,950 59,125 57,750 56,650 55,550 SEWER EQUIPMENT 6/5/2014 97,000 70,000 2,700 72,700 28,918 26,400 25,900 20,400 CW 12 09 PERM FINANCING 1/7/2015 4,999,200 4,999,200 1,123,314 6,122,514 0 304,429 302,558 302,915 303,281 303,655 304,037 304,428 304,827 305,234 305,651 306,076 306,511 TOTAL SEWER FUND - BUDGET 44,745,634 11,455,083 56,200,717 3,530,519 3,776,487 3,737,895 3,548,084 3,441,703 3,409,918 3,385,288 3,216,136 3,187,638 3,014,123 2,825,061 2,295,194 2,286,969 PAID FROM FUND 25 MWPAT T5 97 1148 A COMM SEPTIC 5/22/2013 478,449 382,759 0 382,759 47,845 47,845 47,845 47,845 47,845 47,845 47,845 47,845 47,845 0 T5 97 1148 B COMM SEPTIC PERM FINANCING 1/7/2015 256,000 256,000 0 256,000 12,800 12,800 12,800 12,800 12,800 12,800 12,800 12,800 12,800 12,800 12,800 12,800 12,800 TOTAL PAID FROM FUND 25 734,449 638,759 0 638,759 60,645 60,645 60,645 60,645 60,645 60,645 60,645 60,645 60,645 12,800 12,800 12,800 12,800 TOTAL SEWER DEBT 734,449 45,384,393 11,455,083 56,839,476 3,591,164 3,837,132 3,798,540 3,608,729 3,502,348 3,470,563 3,445,933 3,276,781 3,248,283 3,026,923 2,837,861 2,307,994 2,299,769 EXISTING DEBT AS OF 06/30/2015 ************************** Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments FY2028 FY2029 FY2030 FY2031 FY2032 FY2033 FY2034 FY2035 FY2036 FY2037 FY2038 FY2039 FY2040 18,076,220 16,004,216 14,073,681 12,145,812 10,220,715 8,541,526 6,963,531 5,385,029 3,806,012 2,537,331 1,268,660 (11)(11) 10,425 41,700 72,975 13,761 1,268,671 1,268,672 1,268,671 1,268,671 1,268,671 1,268,671 1,268,672 1,268,671 1,268,681 1,268,671 1,268,671 243,017 243,017 243,014 243,017 114,500 111,438 108,313 105,063 101,688 306,955 307,409 307,872 308,346 308,830 309,324 309,830 310,346 2,072,004 1,930,535 1,927,869 1,925,097 1,679,189 1,577,995 1,578,502 1,579,017 1,268,681 1,268,671 1,268,671 0 0 12,800 12,800 12,800 12,800 12,800 12,800 12,800 12,800 12,800 12,800 12,800 12,800 12,800 12,800 12,800 12,800 0 0 0 0 0 2,084,804 1,943,335 1,940,669 1,937,897 1,691,989 1,590,795 1,591,302 1,591,817 1,268,681 1,268,671 1,268,671 0 0 EXISTING DEBT AS OF 06/30/2013 Original TOTAL TOTAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL Issue Maturity Principal PRINCIPAL DUE PRINCIPAL DUE Payments Payments Payments Payments Payments Payments Payments Payments Payments Purpose Date Date Amount 6/30/2014 6/30/2015 FY2015 FY2016 FY2017 FY2018 FY2019 FY2020 FY2021 FY2022 FY2023 Sewer Enterprise Fund - Budget TOTAL DEBT 47,068,160 44,745,635 42,202,679 39,607,644 37,120,406 34,665,930 32,150,478 29,580,821 27,104,590 MWPAT 94-10 8/1/2001 2/1/2015 223,207 22,259 0 22,259 -------- MWPAT 98-143 8/25/2004 849,513 420,000 365,000 55,000 55,000 60,000 60,000 60,000 65,000 65,000 -- MWPAT 98-144 8/25/2004 189,405 100,000 90,000 10,000 15,000 15,000 15,000 15,000 15,000 15,000 -- MWPAT 98-145 8/25/2004 208,754 105,000 90,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 -- MWPAT CW 02 50A 11/23/2004 5,648,263 3,083,455 2,776,951 306,504 315,775 324,363 332,434 344,413 354,859 367,377 367,389 370,341 MWPAT CW 02 50 10/26/2006 4,015,365 2,954,804 2,772,127 182,677 191,811 196,378 205,512 210,079 219,213 223,780 237,480 255,748 MWPAT CW 01 40 12/14/2006 1,656,115 1,080,000 985,000 95,000 95,000 100,000 105,000 105,000 110,000 115,000 115,000 120,000 SEWER CONSTRUCTION 2/15/2008 250,000 160,000 145,000 15,000 15,000 15,000 15,000 10,000 10,000 10,000 10,000 10,000 SEWER CONSTRUCTION 2/15/2008 870,000 600,000 555,000 45,000 45,000 45,000 45,000 45,000 45,000 45,000 45,000 40,000 SEWER 2 2/15/2008 1,435,075 985,000 910,000 75,000 70,000 70,000 70,000 70,000 70,000 70,000 70,000 70,000 66%% WWTF 2/15/2008 398,013 184,800 171,600 13,200 13,200 13,200 13,200 13,200 13,200 13,200 13,200 13,200 MWPAT CW 04 20 12/9/2008 3,125,318 2,366,793 2,205,771 161,021 164,275 167,594 170,979 174,433 177,957 181,552 185,220 188,962 66% MWPAT CW0521 12/15/2009 39,123,696 23,111,416 22,391,970 719,446 737,025 755,034 773,484 792,384 811,747 831,580 851,900 872,716 MWPAT CW 07 17 7/8/2010 4,006,000 3,502,333 3,327,615 174,718 178,247 181,848 185,522 189,270 193,093 196,994 200,974 205,034 SEWER CURRENT REFUNDING 05/2001 6/7/2012 371,100 281,100 240,400 40,700 40,400 40,000 40,000 40,000 40,000 40,000 -- SEWER ADVANCED REFUNDING 12/01/2003 6/7/2012 545,000 545,000 485,000 60,000 60,000 60,000 55,000 55,000 55,000 55,000 50,000 50,000 SEWER IMPROVEMENTS 6/7/2012 2,000,000 1,800,000 1,700,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 WASTEWATER MANAGEMENT 6/7/2012 750,000 450,000 300,000 150,000 150,000 150,000 ------ SEWER EQUIPMENT 6/6/2013 275,000 220,000 165,000 55,000 55,000 55,000 55,000 ----- SEWER EQUIPMENT 6/5/2014 97,000 97,000 70,000 27,000 25,000 25,000 20,000 CW 12 09 PERM FINANCING 1/7/2015 4,999,200 4,999,200 4,999,200 0 202,223 206,618 211,108 215,696 220,384 225,174 230,068 235,068 TOTAL SEWER FUND - BUDGET 71,036,024 47,068,160 44,745,635 2,322,526 2,542,956 2,595,035 2,487,238 2,454,475 2,515,452 2,569,657 2,476,231 2,531,068 PAID FROM FUND 25 MWPAT T5 97 1148 A COMM SEPTIC 5/22/2013 478,449 430,604 382,759 47,845 47,845 47,845 47,845 47,845 47,845 47,845 47,845 47,845 T5 97 1148 B COMM SEPTIC PERM FINANCING 1/7/2015 256,000 256,000 0 12,800 12,800 12,800 12,800 12,800 12,800 12,800 12,800 TOTAL PAID FROM FUND 25 478,449 686,604 638,759 47,845 60,645 60,645 60,645 60,645 60,645 60,645 60,645 60,645 TOTAL SEWER DEBT 71,514,473 47,754,764 45,384,394 2,370,371 2,603,601 2,655,680 2,547,883 2,515,120 2,576,097 2,630,302 2,536,876 2,591,713 EXISTING DEBT AS OF 06/30/2013 PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments FY2024 FY2025 FY2026 FY2027 FY2028 FY2029 FY2030 FY2031 FY2032 FY2033 FY2034 FY2035 FY2036 FY2037 FY2038 FY2039 FY2040 24,573,522 22,127,653 19,802,464 17,961,908 16,084,524 14,378,299 12,770,947 11,128,465 9,450,028 7,980,266 6,577,805 5,141,862 3,671,637 2,477,172 1,253,530 (11)(11) - - - - - 511,496 520,630 120,000 10,000 10,000 10,000 10,000 10,000 40,000 40,000 40,000 40,000 40,000 70,000 70,000 70,000 70,000 70,000 13,200 13,200 13,200 13,200 13,200 192,779 196,674 200,647 204,701 894,041 915,887 938,266 961,193 984,679 1,008,740 1,033,388 1,058,639 1,084,507 1,111,007 1,138,154 1,165,965 1,194,465 1,223,641 1,253,541 209,176 213,402 217,713 222,111 226,598 231,176 235,846 240,611 - 45,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 - - 240,177 245,397 250,730 256,180 261,747 267,436 273,248 279,187 285,255 291,454 297,789 304,261 2,445,869 2,325,189 1,840,556 1,877,384 1,706,224 1,607,352 1,642,482 1,678,437 1,469,762 1,402,461 1,435,943 1,470,226 1,194,465 1,223,641 1,253,541 0 0 12,800 12,800 12,800 12,800 12,800 12,800 12,800 12,800 12,800 12,800 12,800 12,800 12,800 12,800 12,800 12,800 12,800 12,800 12,800 12,800 12,800 12,800 12,800 12,800 0 0 0 0 0 2,458,669 2,337,989 1,853,356 1,890,184 1,719,024 1,620,152 1,655,282 1,691,237 1,482,562 1,415,261 1,448,743 1,483,026 1,194,465 1,223,641 1,253,541 0 0 EXISTING DEBT AS OF 06/30/2013 TOTAL INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST Issue INTEREST Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments Purpose Date 6/30/2014 FY2015 FY2016 FY2017 FY2018 FY2019 FY2020 FY2021 FY2022 FY2023 FY2024 FY2025 FY2026 Sewer Enterprise Fund - Budget TOTAL DEBT 12,663,076 11,455,083 10,221,552 9,078,691 8,017,846 7,030,618 6,136,152 5,320,521 4,580,616 3,924,046 3,355,792 2,855,920 MWPAT 94-10 8/1/2001 749 749 MWPAT 98-143 8/25/2004 76,930 20,321 17,307 14,100 10,791 7,794 4,911 1,706 MWPAT 98-144 8/25/2004 18,473 4,979 4,180 3,396 2,568 1,823 1,133 394 MWPAT 98-145 8/25/2004 18,528 5,034 4,180 3,396 2,568 1,823 1,133 394 MWPAT CW 02 50A 11/23/2004 616,074 125,918 110,939 94,553 83,944 77,274 49,115 37,369 27,703 9,258 MWPAT CW 02 50 10/26/2006 868,394 138,149 128,319 115,324 104,735 94,219 83,509 72,626 61,084 48,435 21,995 MWPAT CW 01 40 12/14/2006 254,433 50,329 45,104 39,867 33,533 27,626 22,803 17,321 11,923 5,928 0 SEWER CONSTRUCTION 2/15/2008 44,138 6,006 5,556 5,088 4,600 4,075 3,713 3,313 2,913 2,513 2,113 1,700 1,275 SEWER CONSTRUCTION 2/15/2008 176,706 22,875 21,525 20,119 18,656 17,081 15,450 13,650 11,850 10,050 8,450 6,800 5,100 SEWER 2 2/15/2008 297,563 37,688 35,438 33,250 30,975 28,525 25,988 23,188 20,388 17,588 14,788 11,900 8,925 66%% WWTF 2/15/2008 56,084 7,079 6,683 6,270 5,841 5,379 4,901 4,373 3,845 3,317 2,789 2,244 1,683 MWPAT CW 04 20 12/9/2008 320,923 45,726 42,473 39,154 35,768 32,314 28,790 25,195 21,527 17,786 13,968 10,074 6,100 66% MWPAT CW0521 12/15/2009 7,336,696 549,226 531,646 513,637 495,188 476,288 456,926 437,091 416,772 395,955 374,631 352,785 330,405 MWPAT CW 07 17 7/8/2010 628,951 68,299 64,770 61,169 57,495 53,747 49,924 46,023 42,043 37,983 33,840 29,615 25,304 SEWER CURRENT REFUNDING 05/2001 6/7/2012 45,229 11,423 10,206 8,600 6,600 4,600 2,800 1,000 SEWER ADVANCED REFUNDING 12/01/2003 6/7/2012 124,450 23,400 21,600 19,200 16,325 13,575 11,100 8,625 6,000 3,500 1,125 SEWER IMPROVEMENTS 6/7/2012 614,000 70,500 67,500 63,500 58,500 53,500 49,000 44,500 39,500 34,500 29,500 24,500 20,500 WASTEWATER MANAGEMENT 6/7/2012 27,750 14,250 9,750 3,750 SEWER EQUIPMENT 6/6/2013 9,075 4,125 2,750 1,650 550 SEWER EQUIPMENT 6/5/2014 4,618 1,918 1,400 900 400 CW 12 09 PERM FINANCING 1/7/2015 1,123,314 0 102,206 95,940 91,807 87,585 83,271 78,863 74,360 69,759 65,057 60,254 55,346 TOTAL SEWER FUND - BUDGET 12,663,076 1,207,994 1,233,531 1,142,861 1,060,845 987,228 894,466 815,630 739,906 656,570 568,254 499,871 454,639 PAID FROM FUND 25 MWPAT T5 97 1148 A COMM SEPTIC 5/22/2013 0 0 0 0 0 0 0 0 0 0 T5 97 1148 B COMM SEPTIC PERM FINANCING 1/7/2015 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL PAID FROM FUND 25 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL SEWER DEBT 12,663,076 1,207,994 1,233,531 1,142,861 1,060,845 987,228 894,466 815,630 739,906 656,570 568,254 499,871 454,639 EXISTING DEBT AS OF 06/30/2013 INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments FY2027 FY2028 FY2029 FY2030 FY2031 FY2032 FY2033 FY2034 FY2035 FY2036 FY2037 FY2038 FY2039 FY2040 2,401,282 1,991,697 1,625,918 1,302,735 1,017,348 770,688 561,261 385,726 243,168 134,376 60,160 15,130 0 0 850 425 3,400 1,700 5,950 2,975 1,122 561 2,047 307,479 283,992 259,931 235,283 210,032 184,164 157,665 130,517 102,707 74,216 45,030 15,130 20,906 16,419 11,841 7,168 2,406 17,500 14,500 11,438 8,313 5,063 1,688 50,331 45,208 39,973 34,624 29,159 23,575 17,870 12,041 6,085 409,585 365,779 323,183 285,387 246,660 209,427 175,535 142,558 108,792 74,216 45,030 15,130 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 409,585 365,779 323,183 285,387 246,660 209,427 175,535 142,558 108,792 74,216 45,030 15,130 0 0