11-0282
Appendix C
Page 1 of 11
Company
Approved
Rebuttal
Company
Gross
Proposed
Adjustment
Proposed
Operating
$
%
Pro Forma
Pro Forma
Proposed
Revenue
Rates With
To
Used &
Statement
Revenue
Revenue
Line
Present
Adjustments
Present
Increase
Conversion
Adjustments
Proposed
Pro Forma
Useful
per Order
Change
Change
No.
Description
(AIC Ex. 22.6)
(App. C, p. 3)
(Cols. b+c)
(AIC Ex. 22.6)
Factor
(Cols. d+e+f)
Increase
(Cols. g+h)
Allowance
(Cols. i+j)
(Cols. k-b)
(Cols. k/b)
(a)
(b)
(c)
(d)
(e)
(f)
(g)
(h)
(i)
(j)
(k)
(l)
(m)
1
Operating Revenues
158,340$
-$
158,340$
24,249$
25$
182,614$
(9,607)$
173,007$
105
173,112$
14,772$
9.33%
2
Other Revenues
2,732
-
2,732
-
-
2,732
-
2,732
-
2,732
-
3
Total Operating Revenue
161,072
-
161,072
24,249
25
185,346
(9,607)
175,739
105
175,844
14,772$
9.17%
4
Uncollectible Accounts
2,376
97
2,473
347
26
2,846
(148)
2,698
2
2,700
5
Production Expenses
676
-
676
-
-
676
-
676
676
6
Storage,Term., and Proc. Expenses
3,959
-
3,959
-
-
3,959
-
3,959
3,959
7
Transmission Expenses
3,308
-
3,308
-
-
3,308
-
3,308
3,308
8
Distribution Expenses
34,682
-
34,682
-
-
34,682
-
34,682
34,682
9
Cust. Accounts, Service & Sales
15,792
-
15,792
-
-
15,792
-
15,792
15,792
10
Admin. & General Expenses
24,954
(369)
24,585
-
-
24,585
-
24,585
24,585
11
Depreciation & Amort. Expenses
17,845
(311)
17,534
-
-
17,534
-
17,534
17,534
12
Taxes Other Than Income
8,460
-
8,460
-
-
8,460
-
8,460
8,460
13
-
-
-
-
-
-
-
-
-
-
14
-
-
-
-
-
-
-
-
-
-
-
15
Total Operating Expense
16
Before Income Taxes
112,052
(583)
111,469
347
26
111,842
(148)
111,694
2
111,696
-
-
17
State Income Tax
2,803
124
2,927
2,271
-
5,198
(899)
4,299
10
4,309
18
Federal Income Tax
9,182
412
9,594
7,571
-
17,165
(2,996)
14,169
33
14,202
19
-
-
-
-
-
-
-
-
-
-
20
Total Operating Expenses
124,037
(47)
123,990
10,189
26
134,205
(4,043)
130,162
45
130,207
21
NET OPERATING INCOME
37,035$
47$
37,082$
14,060$
(1)$
51,141$
(5,564)$
45,577$
60$
45,637$
22
Rate Base (Appendix C, Page 4)
546,980$
23
Overall Rate of Return (per Order)
8.33%
24
Non-Used and Useful Investment (AIC Ex. 22.6, Schedule 3, Line 2.)
1,706$
25
Rate of Return Excluding Common Equity Return per Order
3.51%
Statement of Operating Income with Adjustments
For the Test Year Ending December 31, 2012
(In Thousands)
Ameren Illinois Company - Gas Zone 3 (Ameren IP)11-0282
Appendix C
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. C, 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
Operating Revenues
-$
-$
-$
-$
-$
-$
-$
-$
2
Other Revenues
-
-
-
-
-
-
-
-
3
Total Operating Revenue
-
-
-
-
-
-
-
-
4
Uncollectible Accounts
-
-
-
-
97
-
-
97
5
Production Expenses
-
-
-
-
-
-
-
-
6
Storage,Term., and Proc. Expenses
-
-
-
-
-
-
-
-
7
Transmission Expenses
-
-
-
-
-
-
-
-
8
Distribution Expenses
-
-
-
-
-
-
-
-
9
Cust. Accounts, Service & Sales
-
-
-
-
-
-
-
-
10
Admin. & General Expenses
-
-
-
-
-
(192)
-
(192)
11
Depreciation & Amort. Expenses
-
(292)
(10)
(7)
-
(2)
-
(311)
12
Taxes Other Than Income
-
-
-
-
-
-
-
-
13
-
-
-
-
-
-
-
-
-
14
-
-
-
-
-
-
-
-
15
Total Operating Expense
16
Before Income Taxes
-
(292)
(10)
(7)
97
(194)
-
(406)
-
17
State Income Tax
69
28
1
1
(9)
18
-
108
18
Federal Income Tax
229
92
3
2
(31)
61
-
356
19
-
-
-
-
-
-
-
-
20
Total Operating Expenses
298
(172)
(6)
(4)
57
(115)
-
58
21
NET OPERATING INCOME
(298)$
172$
6$
4$
(57)$
115$
-$
(58)$
Ameren Illinois Company - Gas Zone 3 (Ameren IP)
Adjustments to Operating Income
For the Test Year Ending December 31, 2012
(In Thousands)
Capital Additions11-0282
Appendix C
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
Operating Revenues
-$
-$
-$
-$
-$
-$
-$
-$
2
Other Revenues
-
-
-
-
-
-
-
-
3
Total Operating Revenue
-
-
-
-
-
-
-
-
4
Uncollectible Accounts
97
-
-
-
-
-
-
97
5
Production Expenses
-
-
-
-
-
-
-
-
6
Storage,Term., and Proc. Expenses
-
-
-
-
-
-
-
-
7
Transmission Expenses
-
-
-
-
-
-
-
-
8
Distribution Expenses
-
-
-
-
-
-
-
-
9
Cust. Accounts, Service & Sales
-
-
-
-
-
-
-
-
10
Admin. & General Expenses
(192)
(142)
(57)
22
-
-
(369)
11
Depreciation & Amort. Expenses
(311)
-
-
-
-
-
-
(311)
12
Taxes Other Than Income
-
-
-
-
-
-
-
-
13
-
-
-
-
-
-
-
-
-
14
-
-
-
-
-
-
-
-
15
Total Operating Expense
16
Before Income Taxes
(406)
(142)
(57)
22
-
-
-
(583)
17
State Income Tax
108
13
5
(2)
-
-
-
124
18
Federal Income Tax
356
45
18
(7)
-
-
-
412
19
-
-
-
-
-
-
-
-
-
20
Total Operating Expenses
58
(84)
(34)
13
-
-
-
(47)
21
NET OPERATING INCOME
(58)$
84$
34$
(13)$
-$
-$
-$
47$
Ameren Illinois Company - Gas Zone 3 (Ameren IP)
Adjustments to Operating Income
For the Test Year Ending December 31, 2012
(In Thousands)11-0282
Appendix C
Page 4 of 11
Company
Rebuttal
Pro Forma
Pro Forma
Line
Rate Base
Adjustments
Rate Base
No.
Description
(AIC Ex. 22.6)
(App. C. p. 5)
(Col. b+c)
(a)
(b)
(c)
(d)
1
Gross Plant in Service
1,060,149$
(640)$
1,059,509$
2
Accumulated Depreciation
(521,876)
19
(521,857)
3
-
-
-
-
4
Net Plant
538,273
(621)
537,652
5
Additions to Rate Base
6
Cash Working Capital
10,166
(157)
10,009
7
Materials & Supplies Inventory
64,162
-
64,162
8
Plant Held for Future Use
-
-
-
9
-
-
-
-
10
-
-
-
-
11
-
-
-
-
12
-
-
-
-
13
-
-
-
-
14
-
-
-
-
15
-
-
-
-
16
Deductions From Rate Base
17
Customer Advances
(5,366)
-
(5,366)
18
Accumulated Deferred Income Taxes
(53,882)
909
(52,973)
19
Customer Deposits
(4,246)
-
(4,246)
20
OPEB Liability
-
(1,966)
(1,966)
21
Budget Payment Plans
(292)
-
(292)
22
Accum. Provision for Injuries & Damages
-
-
-
23
Rate Base
548,815$
(1,835)$
546,980$
Ameren Illinois Company - Gas Zone 3 (Ameren IP)
Rate Base
For the Test Year Ending December 31, 2012
(In Thousands)11-0282
Appendix C
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. C, p. 9)
(Source)
Adjustments
(a)
(b)
(c)
(d)
(e)
(f)
(g)
(h)
(i)
1
Gross Plant in Service
(318)$
(220)$
-$
(102)$
-$
-$
-$
(640)$
2
Accumulated Depreciation
10
7
-
2
-
-
-
19
3
-
-
-
-
-
-
-
-
-
4
Net Plant
(308)
(213)
-
(100)
-
-
-
(621)
-
5
Additions to Rate Base
-
6
Cash Working Capital
-
-
-
-
-
(157)
-
(157)
7
Materials & Supplies Inventory
-
-
-
-
-
-
-
-
8
Plant Held for Future Use
-
-
-
-
-
-
-
-
9
-
-
-
-
-
-
-
-
-
10
-
-
-
-
-
-
-
-
-
11
-
-
-
-
-
-
-
-
-
12
-
-
-
-
-
-
-
-
-
13
-
-
-
-
-
-
-
-
-
14
-
-
-
-
-
-
-
-
-
15
-
-
-
-
-
-
-
-
-
16
Deductions From Rate Base
-
-
-
-
-
-
-
-
17
Customer Advances
-
-
-
-
-
-
-
-
18
Accumulated Deferred Income Taxes
79
18
809
3
-
-
-
909
19
Customer Deposits
-
-
-
-
-
-
-
-
20
OPEB Liability
-
-
(1,966)
-
-
-
-
(1,966)
21
Budget Payment Plans
-
-
-
-
-
-
-
-
22
Accum. Provision for Injuries & Damages
-
-
-
-
-
-
-
-
-
23
Rate Base
(229)$
(195)$
(1,157)$
(97)$
-$
(157)$
-$
(1,835)$
(In Thousands)
Adjustments to Rate Base
Ameren Illinois Company - Gas Zone 3 (Ameren IP)
For the Test Year Ending December 31, 2012
Capital Additions11-0282
Appendix C
Page 6 of 11
Line
No.
Amount
(b)
1
Rate Base
546,980$
(1)
2
Net Non-used and Useful Investment - Hillsboro Storage Field
1,706
(2)
3
Rate Base Plus Net Non-used and Useful Investment
548,686
4
Weighted Cost of Debt
3.42%
(3)
5
Synchronized Interest Per Order
18,782
6
Company Interest Expense
19,505
(4)
7
Increase (Decrease) in Interest Expense
(723)
8
Increase (Decrease) in State Income Tax Expense
9
at
9.500%
69$
10
Increase (Decrease) in Federal Income Tax Expense
11
at
35.000%
229$
(1) Source: Appendix C, Page 4, Column (d), Line 23.
(2) Source: AIC Ex. 22.6, Schedule 3, Line 2.
(2) Source: Order
(4) Source: AIC Ex. 22.6, Schedule 3, Line 5.
Description
(a)
Ameren Illinois Company - Gas Zone 3 (Ameren IP)
Interest Synchronization Adjustment
For the Test Year Ending December 31, 2012
(In Thousands)11-0282
Appendix C
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.5355%
0.015355
3
State Taxable Income
0.984645
1.000000
4
State Income Tax
9.5000%
0.093541
0.095000
5
Federal Taxable Income
0.891104
0.905000
6
Federal Income Tax
35.0000%
0.311886
0.316750
7
Operating Income
0.579218
0.588250
8
Gross Revenue Conversion Factor Per Order
1.726466
1.699958
Ameren Illinois Company - Gas Zone 3 (Ameren IP)
For the Test Year Ending December 31, 2012
Gross Revenue Conversion Factor
(In Thousands)11-0282
Appendix C
Page 8 of 11
Ameren's
Line
Rebuttal
No.
Proposal
Adjustments
Per Order
(b)
(c)
(d)
1
2
Current Revenues
161,072$
161,072$
3
Proposed Increase
24,249
(9,477)
14,772
4
Proposed Revenue Requirement
185,321$
(9,477)$
175,844$
5
Percentage Increase
15.05%
-5.88%
9.17%
6
7
Rate of Return
(9,263)$
8
Provision for Injuiries and Damages
-
9
State Income Tax Regulatory Asset Amortization
(297)
10
Reduce Perquisites and Awards
(211)
11
Charitable Contributions
(145)
12
OPEB Liability
(139)
13
Cash Working Capital
(19)
14
Outside Rate Case Expense
(59)
15
Deferred or Cancelled Projects
(38)
16
Part 280 Adjustment
(30)
17
Gross Revenue Conversion Factor
25
18
Interest Synchronization
470
19
Uncollectibles Expense
98
20
Used and Useful Allowance
105
21
Injuries and Damages Expense
-
22
Merger Costs
22
23
Cost of AIC/AIC Affiliates Technical Experts & Attorneys
-
24
-
25
-
26
-
27
-
28
-
29
-
30
-
31
-
32
-
33
-
34
-
35
-
36
-
37
-
38
-
39
-
40
Rounding
4
41
Effect of Adjustments
(9,477)$
42
43
Column (c), line 3
-
44
Column (f), line 3
25
Column (h), line 3
(9,607)
45
Column (j), line 3
105
46
Total Effect of Adjustments
(9,477)$
Summary
Effect of Each Adjustment
Reconciliation to Appendix C, Page 1
Ameren Illinois Company - Gas Zone 3 (Ameren IP)
Revenue Effect of Adjustments
For the Test Year Ending December 31, 2012
(In Thousands)
Description
(a)11-0282
Appendix C
Page 9 of 11
Line
Description
Amount
Source
(a)
(b)
(c)
1
Cash Working Capital per Order
10,009$
2
Cash Working Capital per Company
10,166
3
Difference -- Adjustment
(157)$
Line 1minus Line 2
Ameren Ex. 22.6, Schedule 2, Page 4, Column (G), Line 32
Ameren Illinois Company - Gas Zone 3 (Ameren IP)
Adjustment to Cash Working Capital
For the Test Year Ending December 31, 2012
(In Thousands)
Apppendix C, Page 10, Column (e), Line 2411-0282
Appendix C
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
401,524$
49.740
0.13627
54,717$
2
Pass Through Taxes
23,679
0.000
0.00000
-
Column (b), Lines 12 + 14 +15 + 17
3
Total Receipts
425,203$
4
Employee Benefits
6,620$
(12.690)
(0.03477)
(230)
5
Payroll
32,967
(11.390)
(0.03121)
(1,029)
6
PGA Purchases
272,767
(39.230)
(0.10748)
(29,317)
7
Other Operations and Maintenance
43,415
(48.870)
(0.13389)
(5,813)
8
FICA
2,400
(13.130)
(0.03597)
(86)
9
Federal Unemployment Tax
21
(76.380)
(0.20926)
(4)
10
State Unemployment Tax
47
(76.380)
(0.20926)
(10)
11
St. Louis Payroll Expense Tax
1
(83.510)
(0.22879)
-
12
ICC Gross Revenue Tax
493
65.000
0.17808
88
13
Invested Capital Tax
4,475
(30.130)
(0.08255)
(369)
14
Municipal Utility Tax
6,685
(15.000)
(0.04110)
(275)
15
Energy Assistance Tax
4,783
(4.000)
(0.01096)
(52)
16
Corporation Franchise Tax
331
(161.970)
(0.44375)
(147)
17
Illinois Public Utility Tax
11,718
1.000
0.00274
32
18
Property/Real Estate Tax
1,185
(375.080)
(1.02762)
(1,218)
19
Interest Expense
18,283
(91.250)
(0.25000)
(4,571)
20
Bank Facility Fees
499
156.590
0.42901
214
21
Federal Income Tax
14,202
(37.880)
(0.10378)
(1,474)
22
State Income Tax
4,309
(37.880)
(0.10378)
(447)
23
Total Outlays
425,201$
24
Cash Working Capital per Order
10,009$
Ameren Illinois Company - Gas Zone 3 (Ameren IP)
Adjustment to Cash Working Capital
For the Test Year Ending December 31, 2012
(In Thousands)
Ameren Ex. 22.6, Schedule 2, Page 4, Column (D), Line 20
Ameren Ex. 22.6, Schedule 2, Page 4, Column (D), Line 21
Ameren Ex. 22.6, Schedule 2, Page 4, Column (D), Line 22
Appendix C, Page 11, Column (b), Line 7
Line 1 + Line 2
Ameren Ex. 22.6, Schedule 2, Page 4, Column (D), Line 14
Ameren Ex. 22.6, Schedule 2, Page 4, Column (D), Line 13
Ameren Ex. 22.6, Schedule 2, Page 4, Column (D), Line 16
Ameren Ex. 22.6, Schedule 2, Page 4, Column (D), Line 19
Apendix C, Page 11, Column (b), Line 17
Ameren Ex. 22.6, Schedule 2, Page 4, Column (D), Line 18
Ameren Ex. 22.6, Schedule 2, Page 4, Column (D), Line 17
Ameren Ex. 22.6, Schedule 2, Page 4, Column (D), Line 12
Ameren Ex. 22.6, Schedule 2, Page 4, Column (D), Line 24
Ameren Ex. 22.6, Schedule 2, Page 4, Column (D), Line 25
Ameren Ex. 22.6, Schedule 2, Page 4, Column (D), Line 26
Appendix C, Page 6, Line 3 less Bank Facility Fees
Sum of Lines 1 through 19
Appendix C, Page 1, Column k, Line 18
Appendix C, Page 1, Column k, Line 17
Sum of Lines 4 through 22
Ameren Ex. 22.6, Schedule 2, Page 4, Column (D), Line 28
Ameren Ex. 40.1, Schedule 2, Page 3, Column (E), Line 2 + Line 1711-0282
Appendix C
Page 11 of 11
Line
Revenues
Amount
Source
(a)
(b)
(c)
1
Total Operating Revenues
175,844$
2
PGA Purchases
272,767
3
Uncollectible Accounts
(2,700)
4
Depreciation & Amortization
(17,534)
5
Return on Equity
(26,853)
6
-
7
Total Revenues for CWC calculation
401,524$
8
Total Rate Base
546,980$
9
Weighted Cost of Capital
4.91%
Per Order
10
Return on Equity
26,853$
Line 8 times Line 9
11
Operating Expense Before Income Taxes
111,696$
12
Employee Benefits Expense
(6,620)
13
Payroll Expense
(32,967)
14
Uncollectible Accounts
(2,700)
15
Depreciation & Amortization
(17,534)
16
Taxes Other Than Income
(8,460)
17
Other Operations & Maintenance for CWC Calculation
43,415$
Appendix C, Page 1, Column i, Line 12
Appendix C, Page 1, Column k, Line 16
Ameren Ex. 22.6, Schedule 2, Page 4, Column (D), Line 12
Ameren Ex. 22.6, Schedule 2, Page 4, Column (D), Line 13
Appendix C, Page 1, Column k, Line 4
Sum of Lines 11 through 16
Sum of Lines 1 through 6
Ameren Illinois Company - Gas Zone 3 (Ameren IP)
Adjustment to Cash Working Capital
For the Test Year Ending December 31, 2012
(In Thousands)
Appendix C, Page 1, Column k, Line 3
Ameren Ex. 22.6, Schedule 2, Page 4, Column (D), Line 2
Appendix C, Page 1, Column k, Line 4
Appendix C, Page 1, Column k, Line 11
Line 10 below
Appendix C, Page 4, Column d, Line 23
Appendix C, Page 1, Column k, Line 11
