BUDGET METHODOLOGY 1 CLICK TO EDIT MASTER TITLE STYLE BUDGET - - PowerPoint PPT Presentation

1

BUDGET METHODOLOGY

CLICK TO EDIT MASTER TITLE STYLE BUDGET METHODOLOGY

Member Consumption (Billion Gallons)

• Traditional Method - Budget for full

variable rate to be covered directly by rate

• Proposed Method - Only 90% of

variable is directly covered by rate

• Remaining 10% (if needed) is

available in RWS Contingency or Cap Imp Fund

• Only Exceeded 90% once in previous

11 years

• Rebates and Excess Rates still

calculated using traditional method

• Does not affect contract or Rebate

Policy

FY Minimum Actual Difference

08 91.8 77.5 84% 09 92.8 79.2 85% 10 92.8 74.6 80% 11 92.8 85.9 93% 12 93.6 81.0 86% 13 93.6 78.4 84% 14 93.9 69.0 74% 15 93.9 66.6 71% 16 93.9 80.7 86% 17 95.0 78.7 83% 18 95.0 84.8 89% Average 83%

2

CLICK TO EDIT MASTER TITLE STYLE BUDGET METHODOLOGY

3

116% 110% 88% 94% 90% 91% 104% 75% 84% 85% 80% 93% 87% 84% 74% 71% 86% 83% 89% 10000000 20000000 30000000 40000000 50000000 60000000 70000000 80000000 90000000 100000000 1,000 Gallons Water Year

Member Annual Minimums and Actual Consumption

Minimum Actual Model Conservation plan limits lawn irrigation to twice per week NTMWD began meetings with Member Cities to develop the Model Conservation Plan Lawn Irrigation limited to twice per week during drought

Decade of Abnormal Weather

Drought with Restrictions Above Avg Rain

CLICK TO EDIT MASTER TITLE STYLE BUDGET METHODOLOGY

4

116% 110% 88% 94% 90% 91% 104% 75% 84% 85% 80% 93% 87% 84% 74% 71% 86% 83% 89% $0.619 $0.719 $1.02 $1.70 $2.78

$- $0.40 $0.80 $1.20 $1.60 $2.00 $2.40 $2.80 $3.20 $3.60 $4.00

10,000,000 20,000,000 30,000,000 40,000,000 50,000,000 60,000,000 70,000,000 80,000,000 90,000,000 100,000,000 1,000 Gallons Water Year

Member Annual Minimums, Actual Consumption and Rate History

Minimum Actual Member Rate Cost per 1,000 Gallons NTMWD began meetings with Member Cities to develop the Model Conservation Plan Lawn Irrigation limited to twice per week during drought Model Conservation plan limits lawn irrigation to twice per week Major Capital Projects 2005-2018 2005 Tawakoni plant/pipeline $180M 2006 Wetlands project $243M 2010 Ozone (Wylie plants) $127M 2012 Texoma pipeline $312M 2015 Main Stem project $120M 2016 Wylie plants imp/expan $191M 2017 Reservoir $1.6B

Decade of Abnormal Weather

Drought with Restrictions Above Avg Rain

CLICK TO EDIT MASTER TITLE STYLE BUDGET METHODOLOGY

Member Rate History

FY Rate

@ 100%

Annual Increase

08 1.08

• 09

1.18 9.26% 10 1.25 5.93% 11 1.37 9.60% 12 1.49 8.76% 13 1.7 14.09% 14 1.87 10.00% 15 2.06 10.16% 16 2.29 11.17% 17 2.53 10.48% 18 2.78 9.88%

5

CLICK TO EDIT MASTER TITLE STYLE BUDGET METHODOLOGY

Variable Rate – Propose FY19 Budget Traditional Proposed Difference

Chemical

$31.0 M $27.9 M $3.1 M

Production Power

$19.3 M $17.4 M $1.9 M

Water Purchases

$ 5.1 M $ 4.6 M $0.5 M $55.4 M $49.9 M $5.5 M Impact to Rate: $.05 Reduction

6

CLICK TO EDIT MASTER TITLE STYLE BUDGET METHODOLOGY - CONTINUED

Due to uncertainty planned to issue for rest of NTML $632 M Now that uncertainty has reduced the current plan is to issue the next SWIFT Bond Issue in November 2020 in the amount of $531 M. SWIFT

• Resulted in reducing Nov 18 Bond Issue from $632 M to $531 M
• Resulted in reducing rate by $.04 in FY19
• Saved $3.7 M in FY19

NON SWIFT

• Reduced from $57 M to $25 M
• Reduced rate by $.01 in FY19
• Saved $1.1 M in FY19

RWS

7

8

RWS Change From 7/12/18 to 8/9/18 Rate Incr/(Decr) 7/12/18 BOD Budgeted Expenses $ 368,181,755 Variable Cost Savings: 10% Reduction Chemicals (3,095,870) $ (0.03) Power (1,935,870) (0.02) Water Purchases (508,515)

• Total Variable Cost Savings: 10% Reduction

(5,540,255) (0.05) Fixed Cost Savings: (3,728,470) (0.04) (Capital, Supplemental, and Personnel Request Reductions) Capital Cost Savings: Capital Improvement 2,400,000 0.02 Debt Service Payment (4,835,000) (0.07) Capital Cost Savings: (2,435,000) (0.05) 8/9/18 BOD Budgeted Expenses $ 356,478,030

• 3.2%

$ (0.14) Customer Premium (983,073) Other RWS Revenue (14,801,833) Fund Balance 88,505 Total Revenue Requirement $ 340,781,629 RWS Projected Flow for WY19 (1,000 Gal) 116,706,037 % Incr in Rate Proposed FY19 Member City Water Rate $ 2.92 5.04% FY19 Cost of Service Member City Water Rate $ 3.06 10.07% Difference $ (0.14)

9

PRELIMINARY ANNUAL MINIMUM FY19 TRADITIONAL METHOD FY19 PROPOSED METHOD INCREASE/ (DECREASE) MEMBER CITY 3.06 2.92 (0.14) Allen 6,011,208 18,394,296 17,552,727 (841,569) Farmersville 280,467 858,229 818,964 (39,265) Forney 1,849,256 5,658,723 5,399,828 (258,896) Frisco 10,352,662 31,679,146 30,229,773 (1,449,373) Garland 13,721,955 41,989,182 40,068,109 (1,921,074) McKinney 11,731,544 35,898,525 34,256,108 (1,642,416) Mesquite 8,297,666 25,390,858 24,229,185 (1,161,673) Plano 26,719,809 81,762,616 78,021,842 (3,740,773) Princeton 521,799 1,596,705 1,523,653 (73,052) Richardson 11,019,311 33,719,092 32,176,388 (1,542,704) Rockwall 3,529,281 10,799,600 10,305,501 (494,099) Royse City 492,064 1,505,716 1,436,827 (68,889) Wylie 1,877,558 5,745,327 5,482,469 (262,858) Total 96,404,580 294,998,015 281,501,374 (13,496,641)

• 5%

CLICK TO EDIT MASTER TITLE STYLE BUDGET METHODOLOGY – FY 17 COMPARISON 100%

City

Flow

Traditional (Mil $) Proposed (Mil $)

Actuals (%) Net Annual Payment After Rebate Net Annual Payment After Rebate Over All Benefit

Allen 92.6% $15.026 $14.804 $0.222 Farmersville 63.4% $ 0.667 $ 0.660 $0.007 Forney 94.8% $ 4.639 $ 4.569 $0.070 Frisco 94.8% $25.652 $25.265 $0.387 Garland 73.9% $33.248 $32.846 $0.402 McKinney 97.9% $27.137 $26.716 $0.421 Mesquite 67.8% $19.897 $19.674 $0.223 Plano 82.3% $65.664 $64.789 $0.875 Princeton 95.7% $ 1.221 $ 1.202 $0.019 Richardson 73.5% $26.680 $26.359 $0.321 Rockwall 75.2% $ 8.088 $ 7.989 $0.099 Royse City 98.1% $ 1.131 $ 1.113 $0.018 Wylie 92.3% $ 4.690 $ 4.622 $0.068 Total $233.740 $230.608 3.132

10

CLICK TO EDIT MASTER TITLE STYLE BUDGET METHODOLOGY - CONTINUED

FY 17 Additional Funding Required to Rebate Using 100% vs. 90% $.544 Source of Funding: Excess Rate Charges and Other Identified Budget Savings

11

Estimated Ongoing Funding Using 100% vs. 90% Rebate (Normal Year) $1-1.5 M Recommendation: Staff Recommends Continuing to Use 100% of Rebates

CLICK TO EDIT MASTER TITLE STYLE BUDGET METHODOLOGY - CONTINUED

RWWS Previously:

• Issue for 1 yr

2/2019 – 1/2020

• Est FY19 Cost $0.746 M

Current Plan:

• Only issue for FY19 2/2019 – 9/2019
• Est FY19 Cost $0.70 M

BONDS UEFIS Previously:

• Issue for 1 yr

2/2019 – 1/2020

• Est FY19 Cost $0.9 M

Current Plan:

• Only issue for FY19 2/2019 – 9/2019
• Est FY19 Cost $0.69 M

12

13

BUDGET SUMMARY

CLICK TO EDIT MASTER TITLE STYLE

Personnel Operating Capital $77 0% $146 0% $276 <2%> $84 9% $171 17% $305 9%

ALL SYSTEMS - PRELIMINARY

June

FY18 Amend FY19

July

FY18 Amend FY19

By Category

Personnel Operating Capital $77 0% $144 <1%> $278 <1%> $84 9% $168 15% $306 9% Personnel Operating Capital $77 0% $142 <3%> $278 <1%> $84 9% $158 8% $302 8% August FY18 Amend FY19

14

CLICK TO EDIT MASTER TITLE STYLE

Water Wastewater Solid Waste Interceptor Sewer

$327 <2%> $64 0% $35 <3%> $34 0% $38 <2%> $368 11% $73 14% $37 3% $39 15% $43 12%

ALL SYSTEMS - PRELIMINARY

June

FY18 Amend FY19

July

FY18 Amend FY19

By System

Water Wastewater Solid Waste Interceptor Sewer

$327 <2%> $64 0% $35 <3%> $34 0% $38 <2%> $368 11% $72 13% $37 3% $37 9% $43 12%

August FY18 Amend FY19 Water Wastewater Solid Waste Interceptor Sewer

$325 <2%> $64 0% $35 <3%> $34 0% $38 0% $356 7% $71 11% $37 3% $37 9% $43 13%

15

ALL SYSTEMS - PRELIMINARY Expenditures by System

$0 $50 $100 $150 $200 $250 $300 $350 $400

Water Wastewater Solid Waste Interceptor Sewer FY18 Bdgt $332 $64 $36 $34 $38 FY18 Amnd $325 $64 $35 $34 $38 FY19 Bdgt $356 $71 $37 $37 $43

Millions

2% Decr 3% Incr 9% Incr 7% Incr 13% Incr 3% Decr $556 M Bonds $44 M Bonds $53 M Bonds Sewer Bond Issues $26 M Buffalo Crk Inter $23 M Mustang Crk Inter $ 9 M Muddy Crk WWTP 11% Incr

16

ALL SYSTEMS - PRELIMINARY FY19 Budget Expenditures $544

(Millions)

Personnel $84 Operating $158

Supplies $56 M Services $90 M Other $12 M

(Other includes: Escrow, Capital Outlay, & Special Projects)

Capital Program/Debt Issuance $302

Debt $254 M Cap Imp $48 M 56% 29% 15%

17

18

PERSONNEL

CLICK TO EDIT MASTER TITLE STYLE FY19 BUDGET – PRELIMINARY Personnel Requests

1 2 3 4 5 6 7 8 9 10

5 3 4 5 4 9 3

FY18 Authorized – 793 Requested Mid-Year – 12 Requested FY19 – 21 FY19 Budget – 826

Note: 64 Original Requests Received From Managers *Reestablish 1 Position

19

FY19 PERSONNEL REQUESTS – PRELIMINARY

• Water Ops (3)

Water Operations Technical Support Manager Plant Operations Chemical System Maintenance Coordinator Plant Operations Water Plant Mechanic Plant Operations

• Wastewater Ops (3)

WW Plant Operator II (2) Wilson Creek WWTP Information Systems Assistant Small Plants

• Solid Waste Ops (4)

Transport Driver Parkway Transfer Station Transport Driver Custer Transfer Station Heavy Equipment Operator 121 RDF Scale Operator 121 RDF

20

FY19 PERSONNEL REQUESTS – PRELIMINARY

• Engineering (4)

Construction Inspector I – Electrical Engineering Construction Inspector I – SCADA Engineering Construction Inspector I (2) Engineering

• Maintenance (4)

Heavy Equipment Operator Facilities Services (Reestablish) Control Systems Senior Technician Technical Services Electrician Technical Services Maintenance Shop Assistant – Electrical Technical Services

• Administration (1)

Government Relations Specialist General

• Other Support Services (2)

IT Supervisor (Previously Control Systems Senior Technician) Information Technology (Reestablish) Senior Laboratory Technician Laboratory

21

FY19 BUDGET – PRELIMINARY

5.3% 5.0% 4.5% 3.4% 5.3% 6.2% 7.4% 6.2% 12.8% 7.8% 2.9% 3.7% 5.2% 4.1% 4.1% 5.7% 11.6% 3.3% 3.7% 2.6%

0% 2% 4% 6% 8% 10% 12% 14%

Annual Percentage Increase (Personnel) Weighted Average Increase = 5.2%

% Increase

+14 +22 +11 +18 +28 +25 +55 +38 +15 +20 +29 +24 +25 +36 +78 +25 +21 +15 +15 +29

Proposed

Includes 12 Mid- Year Additions 22

23

POSITIONS WHOLLY PAID BY ONE CITY

Title Count

Wastewater Plant Supervisor II 1 Chief Wastewater Plant Operator 1 Wastewater Technician II 1 Lead Wastewater Plant Operator 2 Wastewater Plant Operator III 4 Wastewater Plant Operator II 8

Total 17

Panther Creek WWTP - Frisco

24

POSITIONS WHOLLY PAID BY ONE CITY

Title Count

Wastewater Plant Supervisor II 1 Chief Wastewater Plant Operator 1 Lead Wastewater Plant Operator 2 Wastewater Plant Operator III 4 Wastewater Mechanic 1 Wastewater Plant Operator II 8 Information Systems Assistant

1

Total 18

Stewart Creek WWTP - Frisco

25

REGIONAL WATER SYSTEM

26

REGIONAL WATER SYSTEM Expenditures by Category

$25 $75 $125 $175 $225 $275

Personnel Operating Capital FY18 Bdgt $47 $81 $204 FY18 Amnd $47 $76 $202 FY19 Bdgt $52 $86 $218

Millions

$2.5 M Chemical $2.0 M Water Purchases $1.0 M Power 6% Incr $556 M Bonds 26 Personnel: 12 Mid-Year and 14 New 11% Incr 7% Incr 0% 6% Decr Rebates 1% Decr

CLICK TO EDIT MASTER TITLE STYLE REGIONAL WATER SYSTEM

27

• FY18 Significant Items
• Amended Budget Based on 100 BG
• $1.4 M Legal – PUC, Rate Litigation
• $13 M SWIFT Savings
• Est $5 M Rebates
• FY19 Budget +$25M
• $37 M Increase from FY18 to FY19 for full year FY18 Bonds - $778 M and partial

year FY19 Bonds - $556 M

• $272 M 70 MGD Leonard WTP (CNSTR)
• $ 99 M LBCR Pipeline (CNSTR)
• $ 67 M Leonard WTP to McKinney No. 4 PL (CNSTR)
• $ 32 M Leonard WTP Terminal Storage Reservoir (CNSTR)
• $23 M Decrease Transfer to Cap Imp Fund – Following the COS Projection
• Personnel: $990 K FY19 Personnel Requests, $1.11 M Full Year Funding of FY18

Mid Year Requests, $960 K Merit, $660 K Market Adjustment, $960 K Health Ins Increase.

• $2.5 M Chemicals
• Per Fund Balance Policy – 90 days operating cash

REGIONAL WATER SYSTEM

FY19 Budget Expenditures $356

Variable O & M 14% Fixed O & M 25% Capital Program/Debt Issuance 61%

Variable O & M Fixed O & M Capital Program/Debt Issuance $50

Chem $28 Power $17 Water $ 5

(Millions)

$218

Debt Service $173 Cap Imp $ 45

$88

Personnel $52 Supplies $ 7 Services $27 Other $ 2 (Other includes: Escrow, Capital Outlay & Special Projects)

28

REGIONAL WATER SYSTEM

FY19 Member City Water Rate

FY18 Budget Change FY19 Budget Variable O&M

$.40 $.03 (Chemicals, Power, Wtr Purchases) $.43

Fixed O&M

$.68 $.04

(Personnel)

$.72

Capital

$1.70 $.07

(Cap Imp & $556 M Bonds)

$1.77

Total (per 1,000)

$2.78 $.14 $2.92

29

REGIONAL WATER SYSTEM

Rebates

$1.80 $0.50 $6.90 $6.50 $6.70 $7.50 $2.90 $4.90 $5.40 $11.10 $13.90 $4.44 $6.50 $4.90 $0 $1 $2 $3 $4 $5 $6 $7 $8 $9 $10 $11 $12 $13 $14 $15 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 Est 2018 REBATE AMOUNT $ M REBATE YEAR

REBATE AMOUNT

30

31

REGIONAL WASTEWATER SYSTEM

32

REGIONAL WASTEWATER SYSTEM Expenditures by Category

$5 $10 $15 $20 $25 $30 $35 $40

Personnel Operating Capital FY18 Bdgt $12 $26 $27 FY18 Amnd $12 $26 $27 FY19 Bdgt $12 $29 $29

Millions

$1.40 M Other Services $0.60 M Res for Maint & Prev Maint 12% Incr $44 M Bonds $0.75 M Cap Impr 2 Personnel 0% 0% 0% 7% Incr 0%

• FY18 Significant Items

– 6.5% Estimated Increase in Amended Flows to Members – $ .3 M Decrease in FY18 Budget

• FY19 Budget +$6 M

– $2 M Increase from FY18 to FY19 for 2019 Bonds - $44 M – $12 M Wilson Creek Electrical Imp Phase II (CNSTR & INSP) – $12 M Floyd Branch Optimization Process Imp (CNSTR & INSP) – $10 M New WWTP Phase I (EN) – $11 M Rowlett Solids Building Imp (CNSTR & INSP) – $750 K Transfer to Capital Improvement Fund – $600 K Reserve for Maintenance and Preventative Maintenance – Personnel: $120 K New Personnel Requests, $80 K Full Year FY18 Mid Year Personnel Requests, $220 K Merit, $140 K Market Adjustment, $220 K Health Insurance

33

REGIONAL WASTEWATER SYSTEM

34

SEWER SYSTEM

35

SEWER SYSTEM Expenditures by Category

$0 $5 $10 $15 $20 $25

Personnel Operating Capital FY18 Bdgt $6 $14 $19 FY18 Amnd $6 $14 $18 FY19 Bdgt $6 $16 $21

Millions

$1 M Other Services $.9 M Stewart Crk Expansion $.5 M Preventative Maint Escrow 14% Incr $57 M Bonds 1 New Personnel 0% 11% Incr 0% 0% 5% Decr

• FY18 Significant Items

– <$300 K> S. Rockwall Plant II Rehab Project Postponed

• FY19 Budget +$4 M

– $2.3 M Increase from FY18 to FY19 for 2019 Bonds – Buffalo Creek Interceptor System $25.8 M – Muddy Creek Wastewater Treatment Plant $8.7 M – Mustang Creek Wastewater Treatment Plant $22.7 M – $500 K Prev. Maint. Escrow – $900 K Stewart Creek WWTP Expansion Begins Operations – <$60 K> Murphy WWTP/ Interc Turn Over to Murphy – Personnel: $40 K New Personnel Requests,$112 K Merit, $76 K Market Adjustment

36

SEWER SYSTEM

37

UPPER EAST FORK INTERCEPTOR SYSTEM

38

UPPER EAST FORK INTERCEPTOR SYSTEM Expenditures by Category

$0 $5 $10 $15 $20 $25 $30

Personnel Operating Capital FY18 Bdgt $2 $9 $23 FY18 Amnd $2 $9 $23 FY19 Bdgt $2 $10 $25

Millions

$1.2 M Pipeline Maintenance $0.2 M Odor & Corrosion 11% Incr $53 M Bonds 0% 9% Incr 0% 0% 0%

• FY18 Significant Items

– 4% Estimated Increase in Amended Flows to Members – $ 90 K Increase in FY18 Budget

• FY19 Budget +$3 M

– $1.5 M Increase from FY18 to FY19 for 2019 Bonds - $53 M – $29 M McKinney LS Improvements (CNSTR & INSP) – $11 M N. McKinney Parallel Interceptor (CNSTR & INSP) – $ 7 M Wilson Creek LS Improvements (CNSTR & INSP) – $.35 M Transfer to Capital Improvement Fund Increase – $1.2 M CMOM for Pipeline Maintenance Condition Assessments – $ 200 K Odor and Corrosion Control – Personnel: $37 K Merit, $25 K Market Adjustment, $36 K Health Insurance

39

UPPER EAST FORK INTERCEPTOR SYSTEM

40

REGIONAL SOLID WASTE SYSTEM

41

REGIONAL SOLID WASTE SYSTEM Expenditures by Category

$0 $5 $10 $15 $20 $25

Personnel Operating Capital FY18 Bdgt $11 $17 $8 FY18 Amnd $11 $16 $8 FY19 Bdgt $11 $17 $9

Millions

0% $300 K Incr in Capital Improvement Transfer 4 New Personnel 0% 13% Incr 0% 6% Decr 0%

42

REGIONAL SOLID WASTE SYSTEM

• FY18 Significant Items

– <$.6 M> Fuel Savings

• FY19 Budget +$1.4 M

– Personnel: $160 K FY19 Personnel Requests, $174 K Merit, $130 K Overtime Increase, $120 K Market Adjustment, $13 K Health Insurance Increase – $300 K Increase in Transfer to Capital Improvement

43

BOND SUMMARY

BOND SUMMARY

$- $100 $200 $300 $400 $500 $600 $9 $531 $23 $44 $26 $53 $25 Millions

$711 M Bonds

44

CLICK TO EDIT MASTER TITLE STYLE BOND SUMMARY - CONTINUED

$44 M Increase to Debt Service for Full Year of FY18 Bonds and the Following FY19 Bonds:

• $556 M – RWS Leonard WTP< NTML PL, Treated Wtr PL
• $ 44 M – RWWS S. Mesquite Solids Impr, Floyd Branch Optimization
• $ 26 M – Buffalo Crk Interc Parallel Interc Phase I
• $ 53 M – UEFIS McKinney LS Impr, N. McKinney Parallel Inter, WC LS Improv
• $ 23 M – Mustang Creek Interceptor LS Phase I
• $ 9 M – Muddy Creek WWTP Aeration Basin, Odor Control, Backup Power Impr
• $711 M – Total

45

CLICK TO EDIT MASTER TITLE STYLE REGIONAL WATER SYSTEM BONDS

46

FY19 Contracts

Current Cost $M

70 MGD Leonard WTP Site Phase I - Construction $ 272.60 Lower Bois d'Arc Creek Reservoir Pipeline - Construction $ 98.83 Leonard WTP Terminal Storage Reservoir Phase I (210MG) - Construction $ 32.24 Treated Water Pipeline from Leonard WTP to McKinney No. 4 - Construction $ 67.25 Other $ 58.04 Estimated Issuance Cost $ 26.99 $ 555.95

47

REGIONAL WASTEWATER SYSTEM BONDS

FY19 Contracts

Current Cost $M

Floyd Branch Regional WWTP Optimization Process Improvements $ 12.49 Wilson Creek Regional WWTP Maintenance Facility and Solids Operations Facility $ 4.34 Wilson Creek Regional WWTP Step Feed and Plant Drain Improvements $ 4.20 South Mesquite Regional WWTP Solids Handling Improvements $ 20.34 Other $ 0.82 Estimated Issuance Cost $ 2.17

$ 44.36

48

UEFIS BONDS

FY19 Contracts

Current Cost $M

McKinney Lift Station Improvements - Construction $ 29.42 Wilson Creek Lift Station Improvements - Construction $ 7.25 North McKinney Parallel Interceptor - Construction $ 10.97 North McKinney Transfer Force Main - Design $ 1.55 Other $ 1.23 Estimated Issuance Cost $ 2.93

$ 53.34

49

SEWER SYSTEM BONDS

Buffalo Creek Interceptor

Current Cost $ M

Parallel Phase I - Design $ 1.48 Parallel Phase I – Construction $ 18.28 Parallel Phase I – Property $ .47 Parallel Phase I – Inspection $ .34 Lift Station Expansion - Design $ 2.78 Force Main Parallel – Design & Property $ .75 Estimated Issuance Cost $ 1.70 $ 25.83

50

SEWER SYSTEM BONDS - CONTINUED

Muddy Creek WWTP

Current Cost $ M Aeration Basin, Odor Control & Backup Power Improvements - Construction $ 7.50 Design $ .70 Inspection $ .20 Other $ .28 Estimated Issuance Cost $ .10 $ 8.78

51

SEWER SYSTEM BONDS – CONTINUED

Forney Mustang Creek Interceptor

Current Cost $ M Lift Station – Phase I – Design* $ 1.36 Lift Station – Phase I – Construction $ 17.91 Lift Station – Phase I – Other & Inspection $ 1.25 Other $ 0.60 Estimated Issuance Cost $ 1.58

$ 22.70

* Includes $1.361 M Reimbursement for City FY17 Contribution