11-0282

              11-0282
Appendix A
Page 1 of 11
Company
Approved
Rebuttal
Company
Gross
Proposed
Adjustment
Operating
$
%
Pro Forma
Pro Forma
Proposed
Revenue
Rates With
To
Statement
Revenue
Revenue
Line
Present
Adjustments
Present
Increase
Conversion
Adjustments
Proposed
per Order
Change
Change
No.
Description
(AIC Ex. 22.4)
(App. A, p. 3)
(Cols. b+c)
(AIC Ex. 22.4)
Factor
(Cols. d+e+f)
Increase
(Cols. g+h)
(Cols. i-b)
(Cols. j/b)
(a)
(b)
(c)
(d)
(e)
(f)
(g)
(h)
(i)
(j)
(k)
1
Gas Service Revenues
69,430$
-$
69,430$
10,732$
(36)$
80,126$
(3,905)$
76,221$
6,791$
9.78%
2
Other Miscellaneous Revenues
1,096
-
1,096
-
-
1,096
-
1,096
-
3
Total Operating Revenue
70,526
-
70,526
10,732
(36)
81,222
(3,905)
77,317
6,791$
9.63%
4
Uncollectible Accounts
733
53
786
154
(35)
905
(44)
861
5
Production Expenses
580
-
580
-
-
580
-
580
6
Storage,Term., and Proc. Expenses
1,617
-
1,617
-
-
1,617
-
1,617
7
Transmission Expenses
1,551
-
1,551
-
-
1,551
-
1,551
8
Distribution Expenses
18,489
-
18,489
-
-
18,489
-
18,489
9
Cust. Accounts, Service & Sales
7,287
-
7,287
-
-
7,287
-
7,287
10
Admin. & General Expenses
9,758
(202)
9,556
-
-
9,556
-
9,556
11
Depreciation & Amort. Expenses
7,706
(112)
7,594
-
-
7,594
-
7,594
12
Taxes Other Than Income
3,567
-
3,567
-
-
3,567
-
3,567
13
-
-
-
-
-
-
-
-
-
14
-
-
-
-
-
-
-
-
-
15
Total Operating Expense
16
Before Income Taxes
51,288
(261)
51,027
154
(35)
51,146
(44)
51,102
-
-
17
State Income Tax
1,071
52
1,123
1,005
-
2,128
(367)
1,761
18
Federal Income Tax
3,517
173
3,690
3,351
(1)
7,040
(1,223)
5,817
19
-
-
-
-
-
-
-
-
-
20
Total Operating Expenses
55,876
(36)
55,840
4,510
(36)
60,314
(1,634)
58,680
21
NET OPERATING INCOME
14,650$
36$
14,686$
6,222$
-$
20,908$
(2,271)$
18,637$
22
Rate Base (Appendix A, Page 4)
223,665$
23
Overall Rate of Return (per Order)
8.33%
Statement of Operating Income with Adjustments
For the Test Year Ending December 31, 2012
(In Thousands)
Ameren Illinois Company - Gas Zone 1 (Ameren CIPS)11-0282
Appendix A
Page 2 of 11
State Inc. Tax
Deferred or
Reduce
Reg Asset
Cancelled
Part 280
Uncollectibles
Perquisites
Subtotal
Interest
Amortization
Projects
Adjustment
Expense
& Awards
Operating
Line
Synchronization
(St. Ex. 20.0
(St. Ex. 20.0
(St. Ex. 20.0
(St. Ex. 21.0
(St. Ex. 21.0
Statement
No.
Description
(App. A, p. 6)
Sch 20.01)
Sch 20.03)
Sch 20.04)
Sch 21.02)
Sch 21.03)
(Source)
Adjustments
(a)
(b)
(c)
(d)
(e)
(f)
(g)
(h)
(i)
1
Gas Service Revenues
-$
-$
-$
-$
-$
-$
-$
-$
2
Other Miscellaneous Revenues
-
-
-
-
-
-
-
-
3
Total Operating Revenue
-
-
-
-
-
-
-
-
4
Uncollectible Accounts
-
-
-
-
53
-
-
53
5
Production Expenses
-
-
-
-
-
-
-
-
6
Storage,Term., and Proc. Expenses
-
-
-
-
-
-
-
-
7
Transmission Expenses
-
-
-
-
-
-
-
-
8
Distribution Expenses
-
-
-
-
-
-
-
-
9
Cust. Accounts, Service & Sales
-
-
-
-
-
-
-
-
10
Admin. & General Expenses
-
-
-
-
-
(71)
-
(71)
11
Depreciation & Amort. Expenses
-
(105)
(6)
0
-
(1)
-
(112)
12
Taxes Other Than Income
-
-
-
-
-
-
-
-
13
-
-
-
-
-
-
-
-
-
14
-
-
-
-
-
-
-
-
15
Total Operating Expense
16
Before Income Taxes
-
(105)
(6)
-
53
(72)
-
(130)
-
17
State Income Tax
27
10
1
-
(5)
7
-
40
18
Federal Income Tax
91
33
2
-
(17)
23
-
132
19
-
-
-
-
-
-
-
-
20
Total Operating Expenses
118
(62)
(3)
-
31
(42)
-
42
21
NET OPERATING INCOME
(118)$
62$
3$
-$
(31)$
42$
-$
(42)$
Ameren Illinois Company - Gas Zone 1 (Ameren CIPS)
Adjustments to Operating Income
For the Test Year Ending December 31, 2012
(In Thousands)
Capital Additions11-0282
Appendix A
Page 3 of 11
Outside
Subtotal
Rate Case
Total
Operating
Charitable
Expense
Merger
Operating
Line
Statement
Contributions
(St. Ex. 22.0
Costs
Statement
No.
Description
Adjustments
(Per Order)
Sch 22.04)
(AIC Ex. 40.9)
(Source)
(Source)
(Source)
Adjustments
(a)
(i)
(j)
(k)
(l)
(m)
(n)
(o)
(p)
1
Gas Service Revenues
-$
-$
-$
-$
-$
-$
-$
-$
2
Other Miscellaneous Revenues
-
-
-
-
-
-
-
-
3
Total Operating Revenue
-
-
-
-
-
-
-
-
4
Uncollectible Accounts
53
-
-
-
-
-
-
53
5
Production Expenses
-
-
-
-
-
-
-
-
6
Storage,Term., and Proc. Expenses
-
-
-
-
-
-
-
-
7
Transmission Expenses
-
-
-
-
-
-
-
-
8
Distribution Expenses
-
-
-
-
-
-
-
-
9
Cust. Accounts, Service & Sales
-
-
-
-
-
-
-
-
10
Admin. & General Expenses
(71)
(86)
(57)
12
-
-
(202)
11
Depreciation & Amort. Expenses
(112)
-
-
-
-
-
-
(112)
12
Taxes Other Than Income
-
-
-
-
-
-
-
-
13
-
-
-
-
-
-
-
-
-
14
-
-
-
-
-
-
-
-
15
Total Operating Expense
16
Before Income Taxes
(130)
(86)
(57)
12
-
-
-
(261)
17
State Income Tax
40
8
5
(1)
-
-
-
52
18
Federal Income Tax
132
27
18
(4)
-
-
-
173
19
-
-
-
-
-
-
-
-
-
20
Total Operating Expenses
42
(51)
(34)
7
-
-
-
(36)
21
NET OPERATING INCOME
(42)$
51$
34$
(7)$
-$
-$
-$
36$
Ameren Illinois Company - Gas Zone 1 (Ameren CIPS)
Adjustments to Operating Income
For the Test Year Ending December 31, 2012
(In Thousands)11-0282
Appendix A
Page 4 of 11
Company
Rebuttal
Pro Forma
Pro Forma
Line
Rate Base
Adjustments
Rate Base
No.
Description
(AIC Ex. 22.4)
(App. A, p. 5)
(Col. b+c)
(a)
(b)
(c)
(d)
1
Gross Plant in Service
424,961$
(229)$
424,732$
2
Accumulated Depreciation
(204,650)
7
(204,643)
3
-
-
-
-
4
Net Plant
220,311
(222)
220,089
5
Additions to Rate Base
6
Cash Working Capital
5,122
(68)
5,054
7
Materials & Supplies Inventory
24,176
-
24,176
8
Plant Held for Future Use
-
-
-
9
-
-
-
-
10
-
-
-
-
11
-
-
-
-
12
-
-
-
-
13
-
-
-
-
14
-
-
-
-
15
-
-
-
-
16
Deductions From Rate Base
-
17
Accumulated Deferred Income Taxes
(21,231)
48
(21,183)
18
Customer Advances
(2,115)
196
(1,919)
19
Customer Deposits
(1,916)
-
(1,916)
20
OPEB Liability
(159)
(477)
(636)
21
Budget Payment Plans
-
-
-
22
Accum. Provision for Injuries & Damages
-
-
-
23
Rate Base
224,188$
(523)$
223,665$
Ameren Illinois Company - Gas Zone 1 (Ameren CIPS)
Rate Base
For the Test Year Ending December 31, 2012
(In Thousands)11-0282
Appendix A
Page 5 of 11
Deferred or
Reduce
Cancelled
Part 280
OPEB
Perquisites
Cash
Projects
Adjustment
Liability
& Awards
Working
Total
Line
(St. Ex. 20.0
(St. Ex. 20.0
(St. Ex. 21.0
(St. Ex. 21.0
Capital
Rate Base
No.
Description
Sch 20.03)
Sch 20.04)
Sch 21.01)
Sch 21.03)
(Source)
(App. A, p. 9)
(Source)
Adjustments
(a)
(b)
(c)
(d)
(e)
(f)
(q)
(h)
(i)
1
Gross Plant in Service
(189)$
0
-$
(40)$
-$
-$
-$
(229)$
2
Accumulated Depreciation
6
0
-
1
-
-
-
7
3
-
-
-
-
-
-
-
-
-
4
Net Plant
(183)
-
-
(39)
-
-
-
(222)
-
5
Additions to Rate Base
-
6
Cash Working Capital
-
-
-
-
-
(68)
-
(68)
7
Materials & Supplies Inventory
-
-
-
-
-
-
-
-
8
Plant Held for Future Use
-
-
-
-
-
-
-
-
9
-
-
-
-
-
-
-
-
-
10
-
-
-
-
-
-
-
-
-
11
-
-
-
-
-
-
-
-
-
12
-
-
-
-
-
-
-
-
-
13
-
-
-
-
-
-
-
-
-
14
-
-
-
-
-
-
-
-
-
15
-
-
-
-
-
-
-
-
-
16
Deductions From Rate Base
-
-
-
-
-
-
-
-
17
Accumulated Deferred Income Taxes
47
0
-
1
-
-
-
48
18
Customer Advances
-
-
196
-
-
-
-
196
19
Customer Deposits
-
-
-
-
-
-
-
-
20
OPEB Liability
-
-
(477)
-
-
-
-
(477)
21
Budget Payment Plans
-
-
-
-
-
-
-
-
22
Accum. Provision for Injuries & Damages
-
-
-
-
-
-
-
-
-
23
Rate Base
(136)$
-$
(281)$
(38)$
-$
(68)$
-$
(523)$
(In Thousands)
Adjustments to Rate Base
Ameren Illinois Company - Gas Zone 1 (Ameren CIPS)
For the Test Year Ending December 31, 2012
Capital Additions11-0282
Appendix A
Page 6 of 11
Line
No.
Amount
(b)
1
Rate Base
223,665$
(1)
2
Weighted Cost of Debt
3.42%
(2)
3
Synchronized Interest Per Order
7,656
4
Company Interest Expense
7,943
(3)
5
Increase (Decrease) in Interest Expense
(287)
6
Increase (Decrease) in State Income Tax Expense
7
at
9.500%
27$
8
Increase (Decrease) in Federal Income Tax Expense
9
at
35.000%
91$
(1) Source: Appendix A, Page 4, Column (d), Line 23.
(2) Source: Order
(3) Source: Ameren Ex. 22.4, Schedule 3, Line 5.
Description
(a)
Ameren Illinois Company - Gas Zone 1 (Ameren CIPS)
Interest Synchronization Adjustment
For the Test Year Ending December 31, 2012
(In Thousands)11-0282
Appendix A
Page 7 of 11
Per Order
Per Order
Line
With
Without
No.
Description
Rate
Bad Debts
Bad Debts
(a)
(b)
(c)
(d)
1
Revenues
1.000000
2
Uncollectibles
1.1154%
0.011154
3
State Taxable Income
0.988846
1.000000
4
State Income Tax
9.5000%
0.093940
0.095000
5
Federal Taxable Income
0.894906
0.905000
6
Federal Income Tax
35.0000%
0.313217
0.316750
7
Operating Income
0.581689
0.588250
8
Gross Revenue Conversion Factor Per Order
1.719132
1.699958
Ameren Illinois Company - Gas Zone 1 (Ameren CIPS)
For the Test Year Ending December 31, 2012
Gross Revenue Conversion Factor
(In Thousands)11-0282
Appendix A
Page 8 of 11
Ameren's
Line
Rebuttal
No.
Proposal
Adjustments
Per Order
(b)
(c)
(d)
1
2
Current Revenues
70,526$
70,526$
3
Proposed Increase
10,732
(3,941)
6,791
4
Proposed Revenue Requirement
81,258$
(3,941)$
77,317$
5
Percentage Increase
15.22%
-5.59%
9.63%
6
7
Rate of Return
(3,767)$
8
State Income Tax Regulatory Asset Amortization
(107)
9
Charitable Contributions
(88)
10
Reduce Perquisites and Awards
(77)
11
Provision for Injuries and Damages
-
12
Outside Rate Case Expense
(58)
13
Gross Revenue Conversion Factor
(36)
14
OPEB Liability
(34)
15
Cash Working Capital
(8)
16
Deferred or Cancelled Projects
(21)
17
Part 280 Adjustment
-
18
Interest Synchronization
191
19
Uncollectibles Expense
53
20
Injuries and Damages Expense
-
21
Merger Costs
12
22
Cost of AIC/AIC Affiliates Technical Experts & Attorneys
-
23
-
24
-
25
-
26
-
27
-
28
-
29
-
30
-
31
-
32
-
33
-
34
-
35
-
36
-
37
-
38
-
39
-
40
Rounding
(1)
41
Effect of Adjustments
(3,941)$
42
43
Column (c), line 3
-
44
Column (f), line 3
(36)
45
Column (h), line 3
(3,905)
46
Total Effect of Adjustments
(3,941)$
Summary
Effect of Each Adjustment
Reconciliation to Appendix A, Page 1
Ameren Illinois Company - Gas Zone 1 (Ameren CIPS)
Revenue Effect of Adjustments
For the Test Year Ending December 31, 2012
(In Thousands)
Description
(a)11-0282
Appendix A
Page 9 of 11
Line
Description
Amount
Source
(a)
(b)
(c)
1
Cash Working Capital per Order
5,054$
2
Cash Working Capital per Company
5,122
3
Difference -- Adjustment
(68)$
Line 1 minus Line 2
Ameren Ex. 22.4, Schedule 2, Page 4, Column (G), Line 32
Ameren Illinois Company - Gas Zone 1 (Ameren CIPS)
Adjustment to Cash Working Capital
For the Test Year Ending December 31, 2012
(In Thousands)
Appendix A, Page 10, Column (e), Line 2411-0282
Appendix A
Page 10 of 11
CWC
Line
Item
Amount
Lag (Lead)
CWC Factor
Requirement
Source
(a)
(b)
(c)
(d)
(e)
(f)
(c/365)
(b*d)
1
Revenues
184,572$
49.740
0.13627
25,152$
2
Pass through taxes
9,982
0.000
0.00000
-
Column (b), Lines 12 + 14 +15 + 17
3
Total Receipts
194,554$
4
Employee Benefits
2,444$
(12.690)
(0.03477)
(85)
5
Payroll
18,814
(11.390)
(0.03121)
(587)
6
PGA Purchases
126,691
(39.230)
(0.10748)
(13,617)
7
Other Operations and Maintenance
17,822
(48.870)
(0.13389)
(2,386)
8
FICA
1,012
(13.130)
(0.03597)
(36)
9
Federal Unemployment Tax
9
(76.380)
(0.20926)
(2)
10
State Unemployment Tax
20
(76.380)
(0.20926)
(4)
11
St. Louis Payroll Expense Tax
1
(83.510)
(0.22879)
-
12
ICC Gross Revenue Tax
208
65.000
0.17808
37
13
Invested Capital Tax
1,887
(30.130)
(0.08255)
(156)
14
Municipal Utility Tax
2,818
(15.000)
(0.04110)
(116)
15
Energy Assistance Tax
2,016
(4.000)
(0.01096)
(22)
16
Corporation Franchise Tax
140
(161.970)
(0.44375)
(62)
17
Illinois Public Utility Tax
4,940
1.000
0.00274
14
18
Property/Real Estate Tax
500
(375.080)
(1.02762)
(514)
19
Interest Expense
7,451
(91.250)
(0.25000)
(1,863)
20
Bank Facility Fees
205
156.590
0.42901
88
21
Federal Income Tax
5,817
(37.880)
(0.10378)
(604)
22
State Income Tax
1,761
(37.880)
(0.10378)
(183)
23
Total Outlays
194,556$
24
Cash Working Capital per Order
5,054$
Ameren Illinois Company - Gas Zone 1 (Ameren CIPS)
Adjustment to Cash Working Capital
For the Test Year Ending December 31, 2012
(In Thousands)
Ameren Ex. 22.4, Schedule 2, Page 4, Column (D), Line 20
Ameren Ex. 22.4, Schedule 2, Page 4, Column (D), Line 17
Ameren Ex. 22.4, Schedule 2, Page 4, Column (D), Line 18
Ameren Ex. 22.4, Schedule 2, Page 4, Column (D), Line 19
Appendix A, Page 11, Column (b), Line 7
Line 1 + Line 2
Ameren Ex. 22.4, Schedule 2, Page 4, Column (D), Line 12
Ameren Ex. 22.4, Schedule 2, Page 4, Column (D), Line 16
Ameren Ex. 22.4, Schedule 2, Page 4, Column (D), Line 13
Appendix A, Page 11, Column (b), Line 17
Ameren Ex. 22.4, Schedule 2, Page 4, Column (D), Line 14
Ameren Ex. 22.4, Schedule 2, Page 4, Column (D), Line 21
Ameren Ex. 22.4, Schedule 2, Page 4, Column (D), Line 22
Ameren Ex. 22.4, Schedule 2, Page 4, Column (D), Line 24
Ameren Ex. 22.4, Schedule 2, Page 4, Column (D), Line 25
Ameren Ex. 22.4, Schedule 2, Page 4, Column (D), Line 26
Ameren Ex. 40.1, Schedule 2, Page 3, Column (E), Line 2 + Line 17
Appendix A, Page 6, Line 3 less Bank Facility Fees
Appendix A, Page 1,Column i, Line 18
Appendix A, Page 1,Column i, Line 17
Sum of Lines 4 through 22
Ameren Ex. 22.4, Schedule 2, Page 4, Column (D), Line 28
Sum of Lines 1 through 1911-0282
Appendix A
Page 11 of 11
Line
Revenues
Amount
Source
(a)
(b)
(c)
1
Total Operating Revenues
77,317$
2
PGA Purchases
126,691
3
Uncollectible Accounts
(861)
4
Depreciation & Amortization
(7,594)
5
Return on Equity
(10,981)
6
-
7
Total Revenues for CWC calculation
184,572$
8
Total Rate Base
223,665$
9
Weighted Cost of Capital
4.91%
Per Order
10
Return on Equity
10,981$
Line 8 times Line 9
11
Operating Expense Before Income Taxes
51,102$
12
Employee Benefits Expense
(2,444)
13
Payroll Expense
(18,814)
14
Uncollectible Accounts
(861)
15
Depreciation & Amortization
(7,594)
16
Taxes Other Than Income
(3,567)
17
Other Operations & Maintenance for CWC Calculation
17,822$
Sum of Lines 1 through 6
Appendix A, Page 1, Column i, Line 3
Ameren Ex. 22.4, Schedule 2, Page 4, Column (D), Line 2
Appendix A, Page 1, Column i, Line 4
Appendix A, Page 1, Column i, Line 11
Line 10 below
Ameren Illinois Company - Gas Zone 1 (Ameren CIPS)
Adjustment to Cash Working Capital
For the Test Year Ending December 31, 2012
(In Thousands)
Appendix A, Page 1, Column i, Line 11
Appendix A, Page 1, Column i, Line 12
Sum of Lines 11 through 16
Appendix A, Page 4, Column d, Line 23
Appendix A, Page 1, Column i, Line 16
Ameren Ex. 22.4, Schedule 2, Page 4, Column (D), Line 12
Ameren Ex. 22.4, Schedule 2, Page 4, Column (D), Line 13
Appendix A, Page 1, Column i, Line 4