11-0282
Appendix B
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.5)
(App. B, p. 3)
(Cols. b+c)
(AIC Ex. 22.5)
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
66,940$
-$
66,940$
14,679$
(34)$
81,585$
(3,988)$
77,597$
10,657$
15.92%
2
Other Revenues
1,313
-
1,313
-
-
1,313
-
1,313
-
3
Total Operating Revenue
68,253
-
68,253
14,679
(34)
82,898
(3,988)
78,910
10,657
15.61%
4
Uncollectible Accounts
1,186
(361)
825
210
(33)
1,002
(48)
954
5
Production Expenses
504
-
504
-
-
504
-
504
6
Storage,Term., and Proc. Expenses
1,946
-
1,946
-
-
1,946
-
1,946
7
Transmission Expenses
1,160
-
1,160
-
-
1,160
-
1,160
8
Distribution Expenses
16,147
-
16,147
-
-
16,147
-
16,147
9
Cust. Accounts, Service & Sales
6,581
-
6,581
-
-
6,581
-
6,581
10
Admin. & General Expenses
17,637
(334)
17,303
-
-
17,303
-
17,303
11
Depreciation & Amort. Expenses
9,904
(129)
9,775
-
-
9,775
-
9,775
12
Taxes Other Than Income
3,289
-
3,289
-
-
3,289
-
3,289
13
-
-
-
-
-
-
-
-
-
14
-
-
-
-
-
-
-
-
-
15
Total Operating Expense
16
Before Income Taxes
58,354
(824)
57,530
210
(33)
57,707
(48)
57,659
-
-
17
State Income Tax
322
104
426
1,375
-
1,801
(374)
1,427
18
Federal Income Tax
1,004
351
1,355
4,583
-
5,938
(1,248)
4,690
19
-
-
-
-
-
-
-
-
-
20
Total Operating Expenses
59,680
(369)
59,311
6,168
(33)
65,446
(1,670)
63,776
21
NET OPERATING INCOME
8,573$
369$
8,942$
8,511$
(1)$
17,452$
(2,318)$
15,134$
22
Rate Base (Appendix B, Page 4)
181,631$
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 2 (Ameren CILCO)11-0282
Appendix B
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. B, 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 Revenues
-
-
-
-
-
-
-
-
3
Total Operating Revenue
-
-
-
-
-
-
-
-
4
Uncollectible Accounts
-
-
-
-
(361)
-
-
(361)
5
Production Expenses
-
-
-
-
-
-
-
-
6
Storage,Term., and Proc. Expenses
-
-
-
-
-
-
-
-
7
Transmission Expenses
-
-
-
-
-
-
-
-
8
Distribution Expenses
-
-
-
-
-
-
-
-
9
Cust. Accounts, Service & Sales
-
-
-
-
-
-
-
-
10
Admin. & General Expenses
-
-
-
-
(220)
-
(220)
11
Depreciation & Amort. Expenses
-
(122)
(4)
(2)
(1)
-
(129)
12
Taxes Other Than Income
-
-
-
-
-
-
-
-
13
-
-
-
-
-
-
-
-
-
14
-
-
-
-
-
-
-
-
15
Total Operating Expense
16
Before Income Taxes
-
(122)
(4)
(2)
(361)
(221)
-
(710)
-
17
State Income Tax
27
12
-
-
34
21
-
94
18
Federal Income Tax
90
39
1
1
114
70
-
315
19
-
-
-
-
-
-
-
-
20
Total Operating Expenses
117
(71)
(3)
(1)
(213)
(130)
-
(301)
21
NET OPERATING INCOME
(117)$
71$
3$
1$
213$
130$
-$
301$
Ameren Illinois Company - Gas Zone 2 (Ameren CILCO)
Adjustments to Operating Income
For the Test Year Ending December 31, 2012
(In Thousands)
Capital Additions11-0282
Appendix B
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 Revenues
-
-
-
-
-
-
-
-
3
Total Operating Revenue
-
-
-
-
-
-
-
-
4
Uncollectible Accounts
(361)
-
-
-
-
-
-
(361)
5
Production Expenses
-
-
-
-
-
-
-
-
6
Storage,Term., and Proc. Expenses
-
-
-
-
-
-
-
-
7
Transmission Expenses
-
-
-
-
-
-
-
-
8
Distribution Expenses
-
-
-
-
-
-
-
-
9
Cust. Accounts, Service & Sales
-
-
-
-
-
-
-
-
10
Admin. & General Expenses
(220)
(65)
(57)
8
-
-
(334)
11
Depreciation & Amort. Expenses
(129)
-
-
-
-
-
-
(129)
12
Taxes Other Than Income
-
-
-
-
-
-
-
-
13
-
-
-
-
-
-
-
-
-
14
-
-
-
-
-
-
-
-
15
Total Operating Expense
16
Before Income Taxes
(710)
(65)
(57)
8
-
-
-
(824)
17
State Income Tax
94
6
5
(1)
-
-
-
104
18
Federal Income Tax
315
21
18
(3)
-
-
-
351
19
-
-
-
-
-
-
-
-
-
20
Total Operating Expenses
(301)
(38)
(34)
4
-
-
-
(369)
21
NET OPERATING INCOME
301$
38$
34$
(4)$
-$
-$
-$
369$
Ameren Illinois Company - Gas Zone 2 (Ameren CILCO)
Adjustments to Operating Income
For the Test Year Ending December 31, 2012
(In Thousands)11-0282
Appendix B
Page 4 of 11
Company
Rebuttal
Pro Forma
Pro Forma
Line
Rate Base
Adjustments
Rate Base
No.
Description
(AIC Ex. 22.5)
(App. B, p. 5)
(Col. b+c)
(a)
(b)
(c)
(d)
1
Gross Plant in Service
566,344$
(245)$
566,099$
2
Accumulated Depreciation
(384,752)
7
(384,745)
3
-
-
-
-
4
Net Plant
181,592
(238)
181,354
5
Additions to Rate Base
6
Cash Working Capital
6,482
(58)
6,424
7
Materials & Supplies Inventory
30,793
-
30,793
8
Plant Held for Future Use
-
-
-
9
-
-
-
-
10
-
-
-
-
11
-
-
-
-
12
-
-
-
-
13
-
-
-
-
14
-
-
-
-
15
-
-
-
-
16
Deductions From Rate Base
-
17
Accumulated Deferred Income Taxes
(29,205)
40
(29,165)
18
Customer Advances
(2,909)
1,138
(1,771)
19
Customer Deposits
(3,018)
-
(3,018)
20
OPEB Liability
-
(2,764)
(2,764)
21
Budget Payment Plans
(222)
-
(222)
22
Accum. Provision for Injuries & Damages
-
-
-
23
Rate Base
183,513$
(1,882)$
181,631$
Ameren Illinois Company - Gas Zone 2 (Ameren CILCO)
Rate Base
For the Test Year Ending December 31, 2012
(In Thousands)11-0282
Appendix B
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. B, p. 9)
(Source)
Adjustments
(a)
(b)
(c)
(d)
(e)
(f)
(q)
(h)
(i)
1
Gross Plant in Service
(133)$
(57)$
-$
(55)$
-$
-$
-$
(245)$
2
Accumulated Depreciation
4
2
-
1
-
-
-
7
3
-
-
-
-
-
-
-
-
-
4
Net Plant
(129)
(55)
-
(54)
-
-
-
(238)
-
-
-
5
Additions to Rate Base
-
6
Cash Working Capital
-
-
-
-
-
(58)
-
(58)
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
33
5
-
2
-
-
-
40
18
Customer Advances
-
-
1,138
-
-
-
-
1,138
19
Customer Deposits
-
-
-
-
-
-
-
-
20
OPEB Liability
-
-
(2,764)
-
-
-
-
(2,764)
21
Budget Payment Plans
-
-
-
-
-
-
-
-
22
Accum. Provision for Injuries & Damages
-
-
-
-
-
-
-
-
-
23
Rate Base
(96)$
(50)$
(1,626)$
(52)$
-$
(58)$
-$
(1,882)$
(In Thousands)
Adjustments to Rate Base
Ameren Illinois Company - Gas Zone 2 (Ameren CILCO)
For the Test Year Ending December 31, 2012
Capital Additions11-0282
Appendix B
Page 6 of 11
Line
No.
Amount
(b)
1
Rate Base
181,631$
(1)
2
Weighted Cost of Debt
3.42%
(2)
3
Synchronized Interest Per Order
6,217
4
Company Interest Expense
6,502
(3)
5
Increase (Decrease) in Interest Expense
(285)
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%
90$
(1) Source: Appendix B, Page 4, Column (d), Line 23.
(2) Source: Order
(3) Source: Ameren Ex. 22.5, Schedule 3, Line 3.
Description
(a)
Ameren Illinois Company - Gas Zone 2 (Ameren CILCO)
Interest Synchronization Adjustment
For the Test Year Ending December 31, 2012
(In Thousands)11-0282
Appendix B
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.2089%
0.012089
3
State Taxable Income
0.987911
1.000000
4
State Income Tax
9.5000%
0.093852
0.095000
5
Federal Taxable Income
0.894059
0.905000
6
Federal Income Tax
35.0000%
0.312921
0.316750
7
Operating Income
0.581138
0.588250
8
Gross Revenue Conversion Factor Per Order
1.720762
1.699958
Ameren Illinois Company - Gas Zone 2 (Ameren CILCO)
For the Test Year Ending December 31, 2012
Gross Revenue Conversion Factor
(In Thousands)11-0282
Appendix B
Page 8 of 11
Ameren's
Line
Rebuttal
No.
Proposal
Adjustments
Per Order
(b)
(c)
(d)
1
2
Current Revenues
68,253$
68,253$
3
Proposed Increase
14,679
(4,022)
10,657
4
Proposed Revenue Requirement
82,932$
(4,022)$
78,910$
5
Percentage Increase
21.51%
-5.89%
15.61%
6
7
Rate of Return
(3,086)$
8
Uncollectibles Expense
(367)$
9
Reduce Perquisites and Awards
(230)$
10
Provision for Injuries and Damages
-$
11
OPEB Liability
(195)$
12
State Income Tax Regulatory Asset Amortization
(122)$
13
Injuries and Damages Expense
-$
14
Charitable Contributions
(65)$
15
Outside Rate Case Expense
(59)$
16
Gross Revenue Conversion Factor
(34)$
17
Cash Working Capital
(7)$
18
Deferred or Cancelled Projects
(16)$
19
Part 280 Adjustment
(8)$
20
Interest Synchronization
156$
21
Merger Costs
7$
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
4$
41
Effect of Adjustments
(4,022)$
42
43
Column (c), line 3
-
44
Column (f), line 3
(34)
45
Column (h), line 3
(3,988)
46
Total Effect of Adjustments
(4,022)$
Summary
Effect of Each Adjustment
Reconciliation to Appendix B, Page 1
Ameren Illinois Company - Gas Zone 2 (Ameren CILCO)
Revenue Effect of Adjustments
For the Test Year Ending December 31, 2012
(In Thousands)
Description
(a)11-0282
Appendix B
Page 9 of 11
Line
Description
Amount
Source
(a)
(b)
(c)
1
Cash Working Capital per Order
6,424$
2
Cash Working Capital per Company
6,482
3
Difference -- Adjustment
(58)$
Line 1 minus Line 2
Ameren Ex. 22.5, Schedule 2, Page 4, Column (G), Line 32
Ameren Illinois Company - Gas Zone 2 (Ameren CILCO)
Adjustment to Cash Working Capital
For the Test Year Ending December 31, 2012
(In Thousands)
Appendix B, Page 10, Column (e), Line 2411-0282
Appendix B
Page 10 of 11
CWC
Column C
Line
Item
Amount
Lag (Lead)
CWC Factor
Requirement
Source
(a)
(b)
(c)
(d)
(e)
(f)
(c/365)
(b*d)
1
Revenues
223,036$
49.740
0.13627
30,394$
2
Pass Through Taxes
9,205
0.000
0.00000
-
Column (b), Lines 12 + 14 +15 + 17
3
Total Receipts
232,241$
4
Employee Benefits
7,584$
(12.690)
(0.03477)
(264)
5
Payroll
15,473
(11.390)
(0.03121)
(483)
6
PGA Purchases
163,772
(39.230)
(0.10748)
(17,602)
7
Other Operations and Maintenance
20,584
(48.870)
(0.13389)
(2,756)
8
FICA
933
(13.130)
(0.03597)
(34)
9
Federal Unemployment Tax
8
(76.380)
(0.20926)
(2)
10
State Unemployment Tax
18
(76.380)
(0.20926)
(4)
11
St. Louis Payroll Expense Tax
-
(83.510)
(0.22879)
-
12
ICC Gross Revenue Tax
192
65.000
0.17808
34
13
Invested Capital Tax
1,740
(30.130)
(0.08255)
(144)
14
Municipal Utility Tax
2,599
(15.000)
(0.04110)
(107)
15
Energy Assistance Tax
1,859
(4.000)
(0.01096)
(20)
Ameren Ex. 40.1, Schedule 2, Page 3, Column (E), Line 2 + Line 17
16
Corporation Franchise Tax
129
(161.970)
(0.44375)
(57)
17
Illinois Public Utility Tax
4,555
1.000
0.00274
12
18
Property/Real Estate Tax
461
(375.080)
(1.02762)
(474)
19
Interest Expense
6,041
(91.250)
(0.25000)
(1,510)
20
Bank Facility Fees
176
156.590
0.42901
76
21
Federal Income Tax
4,690
(37.880)
(0.10378)
(487)
22
State Income Tax
1,427
(37.880)
(0.10378)
(148)
23
Total Outlays
232,241$
24
Cash Working Capital per Order
6,424$
Ameren Illinois Company - Gas Zone 2 (Ameren CILCO)
Adjustment to Cash Working Capital
For the Test Year Ending December 31, 2012
(In Thousands)
Ameren Ex. 22.5, Schedule 2, Page 4, Column (D), Line 20
Ameren Ex. 22.5, Schedule 2, Page 4, Column (D), Line 21
Ameren Ex. 22.5, Schedule 2, Page 4, Column (D), Line 22
Appendix B, Page 11, Column (b), Line 7
Line 1 + Line 2
Ameren Ex. 22.5, Schedule 2, Page 4, Column (D), Line 14
Ameren Ex. 22.5, Schedule 2, Page 4, Column (D), Line 13
Ameren Ex. 22.5, Schedule 2, Page 4, Column (D), Line 16
Ameren Ex. 22.5, Schedule 2, Page 4, Column (D), Line 19
Appendix B, Page 11, Column (b), Line 17
Ameren Ex. 22.5, Schedule 2, Page 4, Column (D), Line 18
Ameren Ex. 22.5, Schedule 2, Page 4, Column (D), Line 17
Ameren Ex. 22.5, Schedule 2, Page 4, Column (D), Line 12
Ameren Ex. 22.5, Schedule 2, Page 4, Column (D), Line 24
Ameren Ex. 22.5, Schedule 2, Page 4, Column (D), Line 25
Ameren Ex. 22.5, Schedule 2, Page 4, Column (D), Line 26
Appendix B, Page 6, Line 3 less Bank Facility Fees
Sum of Lines 1 through 19
Appendix B, Page 1, Column i, Line 18
Appendix B, Page 1, Column i, Line 17
Sum of Lines 4 through 22
Ameren Ex. 22.5, Schedule 2, Page 4, Column (D), Line 2811-0282
Appendix B
Page 11 of 11
Line
Revenues
Amount
Source
(a)
(b)
(c)
1
Total Operating Revenues
78,910$
2
PGA Purchases
163,772
3
Uncollectible Accounts
(954)
4
Depreciation & Amortization
(9,775)
5
Return on Equity
(8,917)
6
-
7
Total Revenues for CWC calculation
223,036$
8
Total Rate Base
181,631$
9
Weighted Cost of Capital
4.91%
Per Order
10
Return on Equity
8,917$
Line 8 times Line 9
11
Operating Expense Before Income Taxes
57,659$
12
Employee Benefits Expense
(7,584)
13
Payroll Expense
(15,473)
14
Uncollectible Accounts
(954)
15
Depreciation & Amortization
(9,775)
16
Taxes Other Than Income
(3,289)
17
Other Operations & Maintenance for CWC Calculation
20,584$
Ameren Illinois Company - Gas Zone 2 (Ameren CILCO)
Adjustment to Cash Working Capital
For the Test Year Ending December 31, 2012
(In Thousands)
Appendix B, Page 1, Column i, Line 3
Sum of Lines 11 through 16
Appendix B, Page 4, Column d, Line 23
Appendix B, Page 1, Column i, Line 4
Appendix B, Page 1, Column i, Line 11
Line 10 below
Sum of Lines 1 through 6
Ameren Ex. 22.5, Schedule 2, Page 4, Column (D), Line 2
Appendix B, Page 1, Column i, Line 11
Appendix B, Page 1, Column i, Line 12
Appendix B, Page 1, Column i, Line 16
Ameren Ex. 22.5, Schedule 2, Page 4, Column (D), Line 12
Ameren Ex. 22.5, Schedule 2, Page 4, Column (D), Line 13
Appendix B, Page 1, Column i, Line 4
