Item 4R - MemoCITY OF
SOUTHLAKE
MEMORANDUM
September 30, 2020
To: Shana Yelverton, City Manager
From: Daniel Cortez, Director of Economic Development & Tourism
Subject: Item 4R: Resolution No. 20-041, Approving a negotiated settlement
between The Atmos Cities Steering Committee and Atmos Energy Corp.,
Mid -Tex Division regarding the 2020 Rate Review Mechanism Filing;
declaring existing rates to be unreasonable; adopting tariffs that reflect
rate adjustments consistent with the negotiated settlement
Action
Requested: Approval of Resolution 20-041, approving a negotiated settlement
between the Atmos Cities Steering Committee (ACSC) and Atmos
Energy Corp., Mid -Tex Division.
Background
Information: The City of Southlake, along with 171 other Mid -Texas cities, are served
by Atmos Energy Corporation Mid -Tex Division and are members of the
Atmos Cities Steering Committee (ACSC). The ACSC undertakes
activities on behalf of its city members and their citizens such as
participation in rate cases, rulemakings, advocacy and legislative efforts
that impact natural gas rates.
Every year, Atmos files an application seeking a rate increase. This year,
that filing was done on March 31, 2020. The City, along with the over 171
ACSC cities served by Atmos worked on a settlement agreement with
Atmos regarding the rate increase.
Resolution 20-041 and the subsequent attachments are the results of
negotiation between the ACSC Executive Committee and Atmos to
resolve issues identified during the review and evaluation of the Atmos
filing. The proposed settlement agreement for Council approval does the
following:
• Approves rates that will increase Atmos' revenues by $90 million
which is $51.2 million less than original requested by Atmos in the
rate request:
o The monthly residential customer charge will increase
$0.70
o The consumption charge will increase to 0.26651 per
Centum cubic feet (Ccf), an increase of 0.09228 Ccf
• Typical residential customer will see a monthly increase of $5.15
(about a 9.9% increase)
• Typical commercial customer will see an increase of $15.48 (about a
6.56% increase)
• Requires Atmos to reimburse Cities for reasonable ratemaking costs
associated with reviewing and processing the rate filing
• Establishes the baseline for Atmos pensions and other post -
employment benefits for future rate cases
The ACSC Executive Committee, ACSC legal counsel and consultants
recommend that all cities adopt the resolution approving the negotiated
settlement agreement resolving the 2020 filing and implement the rate
change. If approved, the proposed rates would go into effect on
December 1, 2020.
Financial
Considerations: None
Strategic Link: This item is specifically linked to the City's Strategy Map through B2:
Collaborate with select partners to implement service solutions
Citizen Input/
Board Review: None required
Legal Review: Lloyd Gosselink Rochelle & Townsend, P.C. prepared the resolution
Alternatives: Deny the resolution which would result in another contested case
hearing on appeal of the 2020 filing and permits Atmos Energy to
implement rates at the original amount requested (subject to refund) until
a resolution is passed
Supporting
Documents: Resolution No. 20-041
New Tariffs (Exhibit A)
Benchmark for pensions for RRM filing (Exhibit B)
Amortization of Regulatory Liability (Exhibit C)
Staff
Recommendation: Approval of Resolution 20-041
Staff Contact: Daniel Cortez (817) 748 — 8039
RESOLUTION NO. 20-041
A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF
SOUTHLAKE, TEXAS, APPROVING A NEGOTIATED SETTLEMENT
BETWEEN THE ATMOS CITIES STEERING COMMITTEE ("ACSC")
AND ATMOS ENERGY CORP., MID-TEX DIVISION REGARDING THE
COMPANY'S 2020 RATE REVIEW MECHANISM FILINGS;
DECLARING EXISTING RATES TO BE UNREASONABLE; ADOPTING
TARIFFS THAT REFLECT RATE ADJUSTMENTS CONSISTENT WITH
THE NEGOTIATED SETTLEMENT; FINDING THE RATES TO BE SET
BY THE ATTACHED SETTLEMENT TARIFFS TO BE JUST AND
REASONABLE AND IN THE PUBLIC INTEREST; APPROVING AN
ATTACHED EXHIBIT ESTABLISHING A BENCHMARK FOR
PENSIONS AND RETIREE MEDICAL BENEFITS; APPROVING AN
ATTACHED EXHIBIT REGARDING AMORTIZATION OF REGULATORY
LIABILITY; REQUIRING THE COMPANY TO REIMBURSE ACSC'S
REASONABLE RATEMAKING EXPENSES; DETERMINING THAT THIS
RESOLUTION WAS PASSED IN ACCORDANCE WITH THE
REQUIREMENTS OF THE TEXAS OPEN MEETINGS ACT; ADOPTING
A SAVINGS CLAUSE; DECLARING AN EFFECTIVE DATE; AND
REQUIRING DELIVERY OF THIS RESOLUTION TO THE COMPANY
AND THE ACSC'S LEGAL COUNSEL.
WHEREAS, the City of Southlake, Texas ("City") is a gas utility customer of Atmos
Energy Corp., Mid -Tex Division ("Atmos Mid -Tex" or "Company"), and a regulatory authority
with an interest in the rates and charges of Atmos Mid -Tex; and
WHEREAS, the City is a member of the Atmos Cities Steering Committee ("ACSC"), a
coalition of similarly -situated cities served by Atmos Mid -Tex ("ACSC Cities") that have joined
together to facilitate the review of, and response to, natural gas issues affecting rates
charged in the Atmos Mid -Tex service area; and
WHEREAS, ACSC and the Company worked collaboratively to develop a new Rate
Review Mechanism ("RRM") tariff that allows for an expedited rate review process by ACSC
Cities as a substitute to the Gas Reliability Infrastructure Program ("GRIP") process instituted
by the Legislature, and that will establish rates for the ACSC Cities based on the system -wide
cost of serving the Atmos Mid -Tex Division; and
WHEREAS, the RRM tariff was adopted by the City in a rate ordinance earlier this
year; and
WHEREAS, on about March 31, 2020, Atmos Mid -Tex filed its 2020 RRM rate request
with ACSC Cities based on a test year ending December 31, 2019; and
WHEREAS, ACSC coordinated its review of the Atmos Mid -Tex 2020 RRM filing
through its Executive Committee, assisted by ACSC's attorneys and consultants, to resolve
issues identified in the Company's RRM filing; and
WHEREAS, the Executive Committee, as well as ACSC's counsel and consultants,
recommend that ACSC Cities approve an increase in base rates for Atmos Mid -Tex of $90.0
million on a system -wide basis; and
WHEREAS, the attached tariffs (Exhibit A) implementing new rates are consistent with
the recommendation of the ACSC Executive Committee, are agreed to by the Company, and
are just, reasonable, and in the public interest; and
WHEREAS, the Exhibit A rate tariffs incorporate the federal income tax rates that
became effective January 1, 2020; and
WHEREAS, the settlement agreement sets a new benchmark for pensions and retiree
medical benefits (Exhibit B) and
WHEREAS, the settlement agreement establishes an amortization schedule for
regulatory liability (Exhibit C); and
WHEREAS, the RRM Tariff contemplates reimbursement of ACSC's reasonable
expenses associated with RRM applications;
NOW, THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF
SOUTHLAKE, TEXAS:
Section 1. That the findings set forth in this Resolution are hereby in all things
approved.
Section 2. That the City Council finds that the settled amount of an increase in
revenues of $90.0 million on a system -wide basis represents a comprehensive settlement of
gas utility rate issues affecting the rates, operations, and services offered by Atmos Mid -Tex
within the municipal limits arising from Atmos Mid-Tex's 2020 RRM filing, is in the public
interest, and is consistent with the City's authority under Section 103.001 of the Texas
Utilities Code.
Section 3. That the existing rates for natural gas service provided by Atmos Mid -Tex
are unreasonable. The new tariffs attached hereto and incorporated herein as Exhibit A, are
just and reasonable, and are designed to allow Atmos Mid -Tex to recover annually an
additional $90.0 million in revenue on a system -wide basis over the amount allowed under
currently approved rates. Such tariffs are hereby adopted.
Section 4. That the ratemaking treatment for pensions and retiree medical benefits in
Atmos Mid-Tex's next RRM filing shall be as set forth on Exhibit B, attached hereto and
incorporated herein.
Section 5. That amortization of regulatory liability shall be consistent with the schedule
found in attached Exhibit C attached hereto and incorporated herein.
Section 6. That Atmos Mid -Tex shall reimburse the reasonable ratemaking expenses
of the ACSC in processing the Company's 2020 RRM filing.
Section 7. That to the extent any resolution or ordinance previously adopted by the
Council is inconsistent with this Resolution, it is hereby repealed.
Section 8. That the meeting at which this Resolution was approved was in all things
conducted in strict compliance with the Texas Open Meetings Act, Texas Government Code,
Chapter 551.
Section 9. That if any one or more sections or clauses of this Resolution is adjudged
to be unconstitutional or invalid, such judgment shall not affect, impair, or invalidate the
remaining provisions of this Resolution, and the remaining provisions of the Resolution shall
be interpreted as if the offending section or clause never existed.
Section 10. That consistent with the City Ordinance that established the RRM
process, this Resolution shall become effective from and after its passage with rates
authorized by attached tariffs to be effective for bills rendered on or after December 1, 2020.
Section 11. That a copy of this Resolution shall be sent to Atmos Mid -Tex, care of
Chris Felan, Vice President of Rates and Regulatory Affairs Mid -Tex Division, Atmos Energy
Corporation, 5420 LJB Freeway, Suite 1862, Dallas, Texas 75240, and to Geoffrey Gay,
General Counsel to ACSC, at Lloyd Gosselink Rochelle & Townsend, P.C., 816 Congress
Avenue, Suite 1900, Austin, Texas 78701.
PASSED AND APPROVED this day of 2020.
Mayor
ATTEST: APPROVED AS TO FORM:
Exhibit A
to 2020 RRM Resolution or Ordinance
Mid -Tex Tariffs
Effective December 1, 2020
MID-TEX DIVISION
ATMOS ENERGY CORPORATION
RRC Tariff No:
RATE SCHEDULE:
R— RESIDENTIAL SALES
APPLICABLE TO:
ALL CUSTOMERS IN THE MID-TEX DIVISION UNDER THE RRM TARIFF
EFFECTIVE DATE:
Bills Rendered on or after 12101/2020
PAGE:
Application
Applicable to Residential Customers for all natural gas provided at one Point of Delivery and measured
through one meter.
Type of Service
Where service of the type desired by Customer is not already available at the Point of Delivery, additional
charges and special contract arrangements between Company and Customer may be required prior to
service being furnished.
Monthly Rate
Customer's monthly bill will be calculated by adding the following Customer and Ccf charges to the
amounts due under the riders listed below:
Charge
Amount
Customer Charge per Bill
$ 20.25 per month
Rider CEE Surcharge
$ 0.05 per month'
Total Customer Charge
$ 20.30 per month
Commodity Charge —All Ccf
$0.26651 per Ccf
Gas Cost Recovery: Plus an amount for gas costs and upstream transportation costs calculated
in accordance with Part (a) and Pan (b), respectively, of Rider GCR.
Weather Normalization Adjustment: Plus or Minus an amount for weather normalization
calculated in accordance with Rider WNA.
Franchise Fee Adjustment: Plus an amount for franchise fees calculated in accordance with Rider
FF. Rider FF is only applicable to customers inside the corporate limits of any incorporated
municipality.
Tax Adjustment: Plus an amount for tax calculated in accordance with Rider TAX.
Surcharges: Plus an amount for surcharges calculated in accordance with the applicable rider(s).
Agreement
An Agreement for Gas Service may be required.
Notice
Service hereunder and the rates for services provided are subject to the orders of regulatory bodies
having jurisdiction and to the Company's Tariff for Gas Service.
'Reference Rider CEE - Conservation and Energy Efficiency as approved in GUD 10170. Surcharge billing effective July 1, 2020.
MID-TEX DIVISION
ATMOS ENERGY CORPORATION
RRC Tariff No:
RATE SCHEDULE:
C— COMMERCIAL SALES
APPLICABLE TO:
ALL CUSTOMERS IN THE MID-TEX DIVISION UNDER THE RRM TARIFF
EFFECTIVE DATE:
Bills Rendered on or after 1210112020
PAGE:
Application
Applicable to Commercial Customers for all natural gas provided at one Point of Delivery and measured
through one meter and to Industrial Customers with an average annual usage of less than 30,000 Ccf.
Type of Service
Where service of the type desired by Customer is not already available at the Point of Delivery, additional
charges and special contract arrangements between Company and Customer may be required prior to
service being furnished.
Monthly Rate
Customer's monthly bill will be calculated by adding the following Customer and Ccf charges to the
amounts due under the riders listed below:
Charge
Amount
Customer Charge per Bill
$ 54.50 per month
Rider CEE Surcharge
$ 0.02 per month'
Total Customer Charge
$ 54.52 per month
Commodity Charge — All Ccf
$ 0.11728 per Ccf
Gas Cost Recovery: Plus an amount for gas costs and upstream transportation costs calculated
in accordance with Part (a) and Part (b), respectively, of Rider GCR.
Weather Normalization Adjustment: Plus or Minus an amount for weather normalization
calculated in accordance with Rider WNA.
Franchise Fee Adjustment: Plus an amount for franchise fees calculated in accordance with Rider
FF. Rider FF is only applicable to customers inside the corporate limits of any incorporated
municipality.
Tax Adjustment: Plus an amount for tax calculated in accordance with Rider TAX.
Surcharges: Plus an amount for surcharges calculated in accordance with the applicable rider(s).
Agreement
An Agreement for Gas Service may be required.
Notice
Service hereunder and the rates for services provided are subject to the orders of regulatory bodies
having jurisdiction and to the Company's Tariff for Gas Service.
' Reference Rider CEE - Conservation and Energy Efficiency as approved in GUD 10170. Surcharge billing effective July 1, 2020.
MID-TEX DIVISION RRC Tariff No:
ATMOS ENERGY CORPORATION
RATE SCHEDULE:
1- INDUSTRIAL SALES
APPLICABLE TO:
ALL CUSTOMERS IN THE MID-TEX DIVISION UNDER THE RRM TARIFF
EFFECTIVE DATE:
Bills Rendered on or after 12101/2020
PAGE:
Application
Applicable to Industrial Customers with a maximum daily usage (MDU) of less than 3,500 MMBtu per day
for all natural gas provided at one Point of Delivery and measured through one meter. Service for
Industrial Customers with an MDU equal to or greater than 3,500 MMBtu per day will be provided at
Company's sole option and will require special contract arrangements between Company and Customer.
Type of Service
Where service of the type desired by Customer is not already available at the Point of Delivery, additional
charges and special contract arrangements between Company and Customer may be required prior to
service being furnished.
Monthly Rate
Customer's monthly bill will be calculated by adding the following Customer and MMBtu charges to the
amounts due under the riders listed below:
Charge
Amount
Customer Charge per Meter
$ 1,014.50 per month
First 0 MMBtu to 1,500 MMBtu
$ 0.4157 per MMBtu
Next 3,500 MMBtu
$ 0.3044 per MMBtu
All MMBtu over 5,000 MMBtu
$ 0.0653 per MMBtu
Gas Cost Recovery: Plus an amount for gas costs and upstream transportation costs calculated
in accordance with Part (a) and Part (b), respectively, of Rider GCR.
Franchise Fee Adjustment: Plus an amount for franchise fees calculated in accordance with Rider
FF. Rider FF is only applicable to customers inside the corporate limits of any incorporated
municipality.
Tax Adjustment: Plus an amount for tax calculated in accordance with Rider TAX.
Surcharges: Plus an amount for surcharges calculated in accordance with the applicable rider(s).
Curtailment Overpull Fee
Upon notification by Company of an event of curtailment or interruption of Customer's deliveries,
Customer will, for each MMBtu delivered in excess of the stated level of curtailment or interruption, pay
Company 200% of the midpoint price for the Katy point listed in Plaits Gas Daily published for the
applicable Gas Day in the table entitled "Daily Price Survey."
Replacement Index
In the event the "midpoint" or "common" price for the Katy point listed in Platts Gas Daily in the table
entitled "Daily Price Survey" is no longer published, Company will calculate the applicable imbalance fees
utilizing a daily price index recognized as authoritative by the natural gas industry and most closely
approximating the applicable index.
MID-TEX DIVISION
ATMOS ENERGY CORPORATION
RRC Tariff No:
RATE SCHEDULE: 1— INDUSTRIAL SALES
APPLICABLE TO: ALL CUSTOMERS IN THE MID•TEX DIVISION UNDER THE RRM TARIFF
EFFECTIVE DATE: Bills Rendered on or aRer 12101/2020 PAGE:
Agreement
An Agreement for Gas Service may be required.
Notice
Service hereunder and the rates for services provided are subject to the orders of regulatory bodies
having jurisdiction and to the Company's Tariff for Gas Service.
Special Conditions
In order to receive service under Rate I, Customer must have the type of meter required by Company.
Customer must pay Company all costs associated with the acquisition and installation of the meter.
MID-TEX DIVISION RRC Tariff No:
ATMOS ENERGY CORPORATION
RATE SCHEDULE:
T—TRANSPORTATION
APPLICABLE TO:
ALL CUSTOMERS IN THE MID-TEX DIVISION UNDER THE RRM TARIFF
EFFECTIVE DATE:
Bills Rendered on or after 1210112020
PAGE:
Application
Applicable, in the event that Company has entered into a Transportation Agreement, to a customer
directly connected to the Atmos Energy Corp., Mid -Tex Division Distribution System (Customer) for the
transportation of all natural gas supplied by Customer or Customers agent at one Point of Delivery for
use in Customers facility.
Type of Service
Where service of the type desired by Customer is not already available at the Point of Delivery, additional
charges and special contract arrangements between Company and Customer may be required prior to
service being furnished.
Monthly Rate
Customers bill will be calculated by adding the following Customer and MMBtu charges to the amounts
and quantities due under the riders listed below:
Charge
Amount
Customer Charge per Meter
$ 1,014.50 per month
First 0 MMBtu to 1,500 MMBtu
$ 0.4157 per MMBtu
Next 3,500 MMBtu
$ 0.3044 per MMBtu
All MMBtu over 5,000 MMStu
$ 0.0653 per MMBtu
Upstream Transportation Cost Recovery: Plus an amount for upstream transportation costs in
accordance with Part (b) of Rider GCR.
Retention Adjustment: Plus a quantity of gas as calculated in accordance with Rider RA.
Franchise Fee Adjustment: Plus an amount for franchise fees calculated in accordance with Rider
FF. Rider FF is only applicable to customers inside the corporate limits of any incorporated
municipality.
Tax Adjustment: Plus an amount for tax calculated in accordance with Rider TAX.
Surcharges: Plus an amount for surcharges calculated in accordance with the applicable rider(s).
Imbalance Fees
All fees charged to Customer under this Rate Schedule will be charged based on the quantities
determined under the applicable Transportation Agreement and quantities will not be aggregated for any
Customer with multiple Transportation Agreements for the purposes of such fees.
Monthly Imbalance Fees
Customer shall pay Company the greater of (i) $0.10 per MMBtu, or (ii) 150% of the difference per MMBtu
between the highest and lowest "midpoint" price for the Katy point listed in Plaits Gas Daily in the table
entitled "Daily Price Survey" during such month, for the MMBtu of Customers monthly Cumulative
Imbalance, as defined in the applicable Transportation Agreement, at the end of each month that exceeds
10% of Customers receipt quantities for the month.
MID-TEX DIVISION
ATMOS ENERGY CORPORATION
RRC Tariff No:
RATE SCHEDULE:
T-TRANSPORTATION
APPLICABLE TO:
ALL CUSTOMERS IN THE MID-TEX DIVISION UNDER THE RRM TARIFF
EFFECTIVE DATE:
Bills Rendered on or after 12101/2020
PAGE:
Curtailment Overpull Fee
Upon notification by Company of an event of curtailment or interruption of Customer's deliveries,
Customer will, for each MMBtu delivered in excess of the stated level of curtailment or interruption, pay
Company 200% of the midpoint price for the Katy point listed in Plafts Gas Daily published for the
applicable Gas Day in the table entitled "Daily Price Survey."
Replacement Index
In the event the "midpoint" or "common' price for the Katy point listed in Plaits Gas Daily in the table
entitled "Daily Price Survey" is no longer published, Company will calculate the applicable imbalance fees
utilizing a daily price index recognized as authoritative by the natural gas industry and most closely
approximating the applicable index.
Agreement
A transportation agreement is required.
Notice
Service hereunder and the rates for services provided are subject to the orders of regulatory bodies
having jurisdiction and to the Company's Tariff for Gas Service.
Special Conditions
In order to receive service under Rate T, customer must have the type of meter required by Company.
Customer must pay Company all costs associated with the acquisition and installation of the meter.
MID-TEX DIVISION
ATMOS ENERGY CORPORATION
RIDER: WNA— WEATHER NORMALIZATION ADJUSTMENT
APPLICABLE TO: ALL CUSTOMERS IN THE MID-TEX DIVISION UNDER THE RRM TARIFF
EFFECTIVE DATE: Bills Rendered on or after 1210112020 PAGE:
Provisions for Adiustment
The Commodity Charge per Ccf (100 cubic feet) for gas service set forth in any Rate Schedules utilized
by the cities of the Mid -Tex Division service area for determining normalized winter period revenues shall
be adjusted by an amount hereinafter described, which amount is referred to as the "Weather
Normalization Adjustment." The Weather Normalization Adjustment shall apply to all temperature
sensitive residential and commercial bills based on meters read during the revenue months of November
through April. The five regional weather stations are Abilene, Austin, Dallas, Waco, and Wichita Falls.
Computation of Weather Normalization Adjustment
The Weather Normalization Adjustment Factor shall be computed to the nearest one -hundredth cent
per Ccf by the following formula:
(HSFi x (NDD-ADD) )
WNAFi = Ri
(BLi + (HSFi x ADD) )
Where
i = any particular Rate Schedule or billing classification within any such
particular Rate Schedule that contains more than one billing classification
WNAFi = Weather Normalization Adjustment Factor for the ith rate schedule or
classification expressed in cents per Ccf
Ri = Commodity Charge rate of temperature sensitive sales for the ith schedule or
classification.
HSFi = heat sensitive factor for the ith schedule or classification divided by the
average bill count in that class
NOD = billing cycle normal heating degree days calculated as the simple ten-year
average of actual heating degree days.
ADD = billing cycle actual heating degree days.
Bli = base load sales for the ith schedule or classification divided by the average
bill count in that class
The Weather Normalization Adjustment for the jth customer in ith rate schedule is computed as:
WNA= WNAF, x qu
Where qu is the relevant sales quantity for the jth customer in ith rate schedule.
MID-TEX DIVISION
ATMOS ENERGY CORPORATION
RIDER:
WNA—WEATHER NORMALIZATION ADJUSTMENT
APPLICABLE TO:
ALL CUSTOMERS IN THE MID-TEX DIVISION UNDER THE RRM TARIFF
EFFECTIVE DATE:
Bills Rendered on or after 12101/2020
PAGE:
Base Use/Heat Use Factors
Residential
Commercial
Base use
Heatuse
Base use
Heat use
Weather Station
Ccf
Ccf/HDD
Ccf
Ccf/HDD
Abilene
10.73
0.1545
94.79
0.7284
Austin
9.53
0.1489
211.76
0,9405
Dallas
15.77
0.1792
199.74
0.9385
Waco
9.99
0.1341
145.27
0.7110
Wichita
11.61
0.1402
120.34
0.5747
Falls
Weather Normalization Adiustment (WNA) Report
On or before June 1 of each year, the company posts on its website at atmosenergy.com/mtx-wna, in
Excel format, a Weather Normalization Adjustment (WNA) Report to show how the company calculated
its WNAs factor during the preceding winter season. Additionally, on or before June 1 of each year, the
company files one hard copy and an Excel version of the WNA Report with the Railroad Commission of
Texas' Gas Services Division, addressed to the Director of that Division.
Exhibit B
to 2020 RRM Resolution or Ordinance
Mid -Tex
2020 Benchmark for Pensions
and Retiree Benefits
NN NN
r
(J N+ 2
o_ WNW.
^^^ H
m m m m
O
C
T Ov
T qm C T
0
N`c m i� m
O
mw'
F vim
Sma
T
n
xm'm v
�6
c
gK`.m
e
Am
o
o
mP
wx
x�_
?
$
�-
^'mmm
m mm�n
so��
v
a-6
m n3
c
N
n
T
_
N
o
J
Nff
m n
Bm
NO
p 3p m O m
6
3
o
o 3.
5
?
�rt'ooW
d
B
o m 3
- ^ C ry
K
m n
o
8 N
c 3
m m
ro g
W
9 0
.mn.
Scan
o n
m 3
w 55
w
q9
.�.y9
N J
� �
� �
N
p p
(J
W
m^
v
5
op
O V
N N
b
fgp�0 O 1gp0
fAil
T y
= 7 9
W
(Q�1N
'
71
N N
W 0 W
A
a
a
m
33n
a
W
az9
_m
W Q m
R� 9
<C
N�
boo
g�
mm
J
WpW
i�s�
VA
J..r
T_y
��
0 OI
q
PP
Wy�y
0w
m
a
EP a a
m
a
OA001
>
�
z
O
N
D
2
m 0 g
wm�
A55w
> mz
a
Amz
'0K
ino
"
3M
Z3
To
MAIX
W 02
�A<
Np O N
°mi
w
a
y$
r
Exhibit C
to 2020 RRM Resolution or Ordinance
Mid -Tex 2020 Schedule for
Amortization for Regulatory Liability
ATMOS ENERGY CORP., MID-TEX DIVISION
RATE BASE ADJUSTMENTS
TEST YEAR ENDING DECEMBER 31, 2019
AMORTIZATION OF REGULATORY LIABILITY
Line
No.
Year Ended
Dec. 31
Beginning of Year
Rate Base
Adjustment
Amount
Annual
Amortization (1)
End of Year
Rate Base
Adjustment
Amount (2)
Corrected Balance
for December 31,
2017 (3)
(a)
(b)
(c)
(d)
(a)
1
2017
$ -
$ 292,268,881
$ 292,268,881
2
2018
292,268,881
12,075,562
280,193,319
3
2019
280,193,319
12,085,165
268,108,155
4
2020
268,108,155
11,171,173
256,936,982
5
2021
256,936,982
11,171,173
245,765,809
6
2022
245,765,809
11,171,173
234,594,635
7
2023
234,594,635
11,171,173
223,423,462
8
2024
223,423,462
11,171,173
212,252,289
9
2025
212,252,289
11,171,173
201,081,116
10
2026
201,081,116
11,171,173
189,909,943
11
2027
189,909,943
11,171,173
178,738,770
12
2028
178,738,770
11,171,173
167,567,597
13
2029
167,567,597
11,171,173
156,396,424
14
2030
156,396,424
11,171,173
145,225,251
15
2031
145,225,251
11,171,173
134,054,077
16
2032
134,054,077
11,171,173
122,882,904
17
2033
122,882,904
11,171,173
111,711,731
18
2034
111,711,731
11,171,173
100,540,558
19
2035
100,540,558
11,171,173
89,369,385
20
2036
89,369,385
11,171,173
78,198,212
21
2037
78,198,212
11,171,173
67,027,039
22
2038
67,027,039
11,171,173
55,855,866
23
2039
55,855,866
11,171,173
44,684,692
24
2040
44,684,692
11,171,173
33,513,519
25
2041
33,513,519
11,171,173
22,342,346
26
2042
22,342,346
11,171,173
11,171,173
27
2043
11,171,173
11,171,173
(0)
28
29
Revenue Related
Tax Factor
7.16%
See WP F-5.1
Revenue Related Taxes on Annual
Amortization' Tax
30
Amortization
$ 799,924
Factor
31
Amortization Including
Revenue
$ 11,971,097
Amortization + Taxes
32
33
Notes:
34
1. The annual amortization
of a 26 year
recovery period is based on the
35
Reverse South
Georgia Method.
36
2. The Regulatory Liability is recorded to FERG Account 253, Sub Account 27909.
37
3. This is the final Mid -Tex liability balance filing the Fiscal Year 2018 tax return.