Order

              10-0194
Appendix
Page 1 of 8
Company
Company
Gross
Proposed
Adjustment
Operating
Pro Forma
Adjustments
Pro Forma
Proposed
Revenue
Rates With
To
Statement
Line
Present
(Appendix,
Present
Increase
Conversion
Adjustments
Proposed
per Order
No.
Description
(Co. Sch. C-1/C-2.1)
Pages 2 & 3)
(Cols. b+c)
(Co. Sch. C-1)
Factor
(Cols. d+e+f)
Increase
(Cols. g+h)
(a)
(b)
(c)
(d)
(e)
(f)
(g)
(h)
(i)
1
Operating Revenues
18,272,764$
-$
18,272,764$
4,327,379$
3$
22,600,146$
(1,199,275)$
21,400,871$
2
Other Revenue
184,986
-
184,986
21,748
-
206,734
-
206,734
3
Total Operating Revenue
18,457,750
-
18,457,750
4,349,127
3
22,806,880
(1,199,275)
21,607,605
4
Uncollectible Accounts
241,899
-
241,899
56,998
2
298,899
(15,718)
283,181
5
Salaries & Wages, Employees
2,124,021
(123,199)
2,000,822
-
-
2,000,822
-
2,000,822
6
Salaries & Wages, Officers
123,199
-
123,199
-
-
123,199
-
123,199
7
Employee Pensions & Benefits
972,676
(37,254)
935,422
-
-
935,422
-
935,422
8
Purchased Power & Fuel
767,647
(20,957)
746,690
-
-
746,690
-
746,690
9
Chemicals
724,960
(44,310)
680,650
-
-
680,650
-
680,650
10
Materials & Supplies
267,147
-
267,147
-
-
267,147
-
267,147
11
Contractual Services - Engineering
-
-
-
-
-
-
-
-
12
Contractual Services - Accounting
44,339
-
44,339
-
-
44,339
-
44,339
13
Contractual Services - Legal
14,832
-
14,832
-
-
14,832
-
14,832
14
Contractual Services - Management
750,969
(162,466)
588,503
-
-
588,503
-
588,503
15
Contractual Services - Other
1,509,012
-
1,509,012
-
-
1,509,012
-
1,509,012
16
Lease Expense
6,056
-
6,056
-
-
6,056
-
6,056
17
Transposrtation Expense
264,253
-
264,253
-
-
264,253
-
264,253
18
Insurance Expense
262,254
-
262,254
-
-
262,254
-
262,254
19
Regulatory Commission Exp. Amort.
124,102
(1,625)
122,477
-
-
122,477
-
122,477
20
Miscellaneous Expense
729,881
(29,749)
700,132
-
-
700,132
-
700,132
21
Depreciation
3,465,496
-
3,465,496
-
-
3,465,496
-
3,465,496
22
Amort. Of Utility Plant Acq. Adj.
(50,472)
-
(50,472)
-
-
(50,472)
-
(50,472)
23
Amortization Expense
154,148
-
154,148
-
-
154,148
-
154,148
24
Taxes Other Than Income
975,143
-
975,143
-
-
975,143
-
975,143
25
-
-
-
-
-
-
-
-
26
Total Operating Expense
27
Before Income Taxes
13,471,562
(419,560)
13,052,002
56,998
2
13,109,002
(15,718)
13,093,284
-
-
28
State Income Tax
202,922
30,602
233,524
313,325
(1)
546,848
(86,400)
460,448
29
Federal Income Tax
901,889
136,006
1,037,895
1,392,581
2
2,430,478
(384,005)
2,046,473
30
Deferred Taxes and ITCs Net
(42,520)
-
(42,520)
-
-
(42,520)
-
(42,520)
31
Total Operating Expenses
14,533,853
(252,952)
14,280,901
1,762,904
3
16,043,808
(486,123)
15,557,685
32
NET OPERATING INCOME
3,923,897$
252,952$
4,176,849$
2,586,223$
-$
6,763,072$
(713,152)$
6,049,920$
33
Rate Base (Appendix, Page 4, Column (d))
71,681,513$
34
Overall Rate of Return
8.44%
35
Revenue Change (Col. (i) Line 3 minus Col. (d), Line 3)
3,149,855$
36
Percentage Revenue Change (Col. (i), Line 35 divided by Col. (d), Line 3)
17.07%
Statement of Operating Income with Adjustments
For the Test Year Ending December 31, 2011
Aqua Illinois, Inc. - Kankakee Water Division