HomeMy WebLinkAbout20050211Exhibit 1 Rate Base.xlsWork Capital
EXH 1 P 9 of 9
EXH 1 Page 8 of 9
EXH 1 P 7 of 9
EXH 1 P 6 of 9
EXH 1 P 5 of 9
EXH 1 P 4 of 9
EXH 1 P 3 of 9
EXH 1 P 2 of 9
Exh 1 Summary P 1 of 9
UNITED WATER IDAHO
CASE UWI-W-04-4
(A)
(B)
(C)
(D)
(E)
Per Books July 31, 2004
Adjustments
Test Year Adjusted
Pro Forma Year May 31, 2005
Line No.
Description
Utility Plant In Service
Customer Advances for Construction
Accumulated Deferred Income Taxes
Pre-1971 Investment Tax Credits
Deferred Charges
Working Capital
Net Utility Plant
Total Rate Base
Contributions in Aid of Construction (net)
Accumulated Depreciation, Amortization of UPAA and Amortization of PHFU
Utility Plant Acquisition Adjustments (gross)
Exhibit No. 1
J. Healy
Rate Base Summary
United Water Idaho
Pro Forma
Plant Account Number
Plant Account Description
Per Asset Mgt Matrix
Less: Plant Held For Future Use GL Account 105000
Per General Ledger
Pro Forma- Reclass PHFU to Plant in Service
Pro Forma Additions August 1, 2004 through May 31, 2005
Pro Forma Retirements August 1, 2004 through May 31, 2005
Carriage Hill Transaction Impact
Pro Forma Utility Plant in Service May 31, 2005
Plant In Service
River Intake
Additions
Retirements
Other
Utility Plant
07/31/2004
05/31/2005
301-10
Organization
303-20
Land & Land Rights, Water Rights - Source of Supply
303-30
Land & Land Rights - Water Treatment
303-40
Land & Land Rights - Trans. & Distrib.
303-50
Land & Land Rights - General Plant
304-20
Structures and Improvements - Source of Supply
304-30
Structures and Improvements - Water Treatment
304-40
Structures and Improvements - Trans. & Distrib.
304-50
Structures and Improvements - General Plant
305-20
Collecting & Impounding Reservoirs - Source of Supply
306-20
Lake, River & Other Intakes
307-20
Wells & Springs
308-20
Infiltration Galleries & Tunnels
309-20
Supply Mains
310-20
Power Generation Equipment
311-20
Power Electric Pumping Equipment - Source of Supply
Power Diesel Pumping Equipment - Source of Supply
311-30
Power Pumping Equipment - Water Treatment
311-40
Power Pumping Equipment - Trans. & Distrib.
320-30
Water Treatment Equipment
Water Treatment Equipment - Membranes
330-40
Distribution Reservoirs & Standpipes
331-10
Trans. & Distrib. Mains & Accessories - Intangible
331-20
Trans. & Distrib. Mains & Accessories - SOS
331-40
Trans. & Distrib. Mains & Accessories
333-40
Services
334-40
Meters and Meter Installations
335-40
Hydrants
336-40
Backflow Prevention Devices
339-10
Other Plant & Misc. Equipment - Intangible
339-20
Other Plant & Misc. Equipment - Source of Supply
339-30
Other Plant & Misc. Equipment - Water Treatment
339-40
Other Plant & Misc. Equipment - Trans. & Distrib.
339-50
Other Plant & Misc. Equipment - General Plant
340-50
Office Furniture and Equipment
AM / FM System - Mapping
340-5A
Computer Hardware & Software
IFMS / WAN / PeopleSoft
Customer Information System
341-50
Transportation Equipment
342-50
Stores Equipment
343-50
Tools, Shop and Garage Equipment
Confined Space Monitor, Generator, Trench Shield
344-50
Laboratory Equipment
345-50
Power Operated Equipment
346-50
Communications Equipment
347-50
Miscellaneous Equipment
348-50
Other Tangible Property
Master Plan
Rounding
Total Plant In Service
United Water Idaho
Case UWI-W-04-4
Plant In Service at July 31, 2004 and the
Pro Forma Year Ended May 31, 2005
(1)
(2)
(3)
(4)
(5)
(6)
(7)
(8)
(9)
(10)
(11)
Exhibit No 1
At July 31, 2004:
Accumulated Depreciation
Accumulated Reserve for Depreciation CIAC
Amortization of Plant Held for Future Use
Accumulated Depreciation And Amortization at July 31, 2004
From August 1 2004 to May 31, 2005:
Depreciation Expense on July 31, 2004 PIS , ten months
Depreciation Expense on PIS adds prior to May 31, 2005 , two and one half month convention
Reverse Carriage Hill Accumulated Depr on Refunded Advances
Reverse Carriage Amort Reserve For Depr of CIAC
Journal
Date
DeptID
Act
Proj
Amount
Line Descr
Ledger
DEPR_ADJ
2004-09-15
1403
SC_EXCEPT
Depreciation
ACTUALS
AM00189416
1404
Amortiz.of Other Util.Plant
S292
X00009
Amort.of Util.Plt.Acq Adj
S294
X00011
S295
X00010
S296
X00020
S298
X00027
S299
X00014
Depreciation Expense:
Aug 2003 Depr Exp
September Depr Exp
September Depr Exp Adj
Oct
Nov
Dec
Jan
Feb
Mar
Apr
May
Amortization of CIAC: Per Depr Schedule
Balance of Accumulated Depreciation and Accumulated Amortization of CIAC, Accumulated Depreciation of Plant Held For Future Use and UPAA Amortization
Case No. UWI-W-04-4
Test Year Ended July 31, 2004 and Pro Forma Year Ended May 31, 2005
Line No. 1
Amortization of UPAA
Total Accumulated Depreciation, CIAC Reserve, UPAA & PHFU Accumulated Amortization
Utility Plant Retirements August 1, 2004 to May 31, 2005
Amortization of Contributed Plant August 1, 2004 to May 31, 2005
Cost of Removal on Plant Retirements
Salvage on Plant Retirements
Accumulated CIAC Reserve
Transfer in From PHFU for CWTP RWPS
Amortization of Plant Held for Future Use Aug I, 2004 to May 31, 2005
Record UPAA Amortization Aug 1 2004 to May 31, 2005
Change August 1, 2004 to May 31, 2005
(F)
(G)
Balance of Accumulated Depreciation, CIAC Reserve, PHFU Reserve and UPAA Reserve
Reclass of Advances in CWIP
Plant Account
Balance as of July 31, 2004
Reclass of Danskin Well #2 Advance
Micron/Arrowhead Reclass
Reclass of Belmont Source of Supply Acquisition
Reclass of Advance Refunds July 2004
Restated Advances at July 31, 2004
Advances in CWIP
Total Per GL July 31, 2004
Pro Forma Refunds Aug 1, 2004 to May 31, 2005
Advances for Construction as of July 31, 2004 and Pro Forma Year Ended May 31, 2005
Line No
30110 - Organization Intangible Plant
30320 - Source of Supply Land & Land Rights
30340 - Water Treatment Plant Land & Land Rights
30420 - Source of Supply & Pumping Plant Structures & Improvements
30520 - Source of Supply & Pumping Plant Collecting and Impounding Plant
30720 - Source of Supply & Pumping Plant Wells & Springs
30920 - Source of Supply & Pumping Plant Supply Mains
31120 - Source of Supply & Pumping Plant Power Generation Equipment
31140 - Trans & Dist Plant Pumping Equipment
32030 - Water Treatment Plant Treatment Equipment
33040 - Trans & Dist Plant Reservoirs
33140 - Trans & Dist Plant Mains
33340 - Trans & Dist Plant Services
33350 - Trans & Dist Plant Hydrants
34650 - General Plant Communication Equipment
Advances for Construction at May 31, 2005
Gross Balance in General Ledger Account 271000
Accumulated Amortization in General Ledger Account 272000
Balance at July 31, 2004
Amortization Of Contributions
Reverse Carriage Hill CIAC Amort
Balance in CIAC associated with CWIP
Net Contributions in Aid of Construction at May 31, 2005
Test Year Ended July 31, 2004 and the Pro Forma Year Ended May 31, 2005
Contributions in Aid of Construction (net) as of July 31, 2004 and Pro Forma Year Ended May 31, 2005
Contributions in Aid of Construction at July 31, 2004:
From August 1, 2004 through May 31, 2005:
Change
United Water Idaho Inc
Test Year Ended July 31, 2004
Pro Forma through May 31, 2005
Acquistion Description
Company Project ID
IPUC Order Month
Amortzation Period
Amortization Through July 2004 Account 115000
Net Unamortized Balance at July, 2004
Monthly Amortization Amount
Pro Forma Months August through May 2005
Pro Forma Amortization
Consolidated Net UPAA At May 31, 2005
Warm Springs Mesa
August 1996
20 Years
Redwood Creek
May 1995
Island Woods
Aprip 1995
Raintree
September 2000
40 Years
South County Water
January 1999
Barber Water
Summary of Gross and Net Utility Plant Acquisition Adjustments
UPAA Account 114000
Page 5 of 10
Accumulated Deferred Federal Income Taxes as of July 31, 2004 and Pro Forma Year Ended May 31, 2005
Account & Description
282001 Accumulated Deferred FIT ACRS
282002 Accumulated Deferred FIT MACRS
282010 Deferred FIT ADR
283300 Deferred FIT
283991 Deferred FIT AFUDC Equity
253108 Deferred Advances and Contributions Gross UP
Pro Forma Tax Depreciation
Pro Forma Book Depreciation
Excess Tax Over Book Depreciation
Deferred Federal FIT at July 31, 2004
Federal Income Tax Rate
Incremental Deferred Federal Income Tax
Total Deferred FIT (Line 7 plus line 12)
Pro Forma Balance at May 31, 2005
Pre-1971 Investment Tax Credit
for the Test Year Ended July 31, 2004
and the Pro Forma Year ending May, 31, 2005
Year
Book Life
Book Balance at July 31, 2004
Annual Expense
Ten Months Expense
Balance at May 31, 2005
1962
50 Years
1963
1964
1965
1966
1967
1968
1969
Case No UWI-W-04-4
Deferred Debits Balance for the Test Year ended July 31, 2004
and the Pro Forma Year ending May 31, 2005
Account Number
Debit
Credit
186001
Deferred Rate Case Expense
186006
Deferred Power Expense
186024/186324
Deferred Relocation Cost
186320
Deferred Rents ( Lakewood Well Lease)
183000
Deferred Terra Grande Cost
186601
Deferred Tank Painting
Total
Interim Activity
Working Capital for the Test Year Ended July 31, 2004 and Pro Forma Year Ended May 31, 2005
Investor Supplied Capital
Plant & Rate Base Investments
Cash -Other
Inventory, Supplies & Cash
Working Capital Requirement
Page 10 of 10
Reverse Carriage Hill CIAC
Page 1 of 9
Page 2 of 9
Page 3 of 9
Page 4 of 9
Page 5 of 9
Page 6 of 9
Page 7 of 9
Page 8 of 9
Page 9 of 9
1.00
$129,951,342.00
$0.00
$129,951,342.00
2.00
-125795454.00
0.00
($125,795,454.00)
3.00
-2024300.00
-2024300.00
0.00
($2,024,300.00)
4.00
-86462.00
-86462.00
0.00
($86,462.00)
5.00
$2,045,126.00
$0.00
$2,045,126.00
1.00
12169.03
232831.00
245000.03
2.00
1363240.00
186760.00
1550000.00
3.00
157215.00
-21390.00
135825.00
4.00
19458.00
-460.00
18998.00
5.00
3300.25
1406.60
4706.85
6.00
79742.00
-2580.00
-2580.00
77162.00
7.00
1635124.28
420997.60
-24430.00
2031691.88
1.00
1364.00
182.00
151.67
12.00
10.00
1212.33
2.00
1131.00
134.00
111.67
12.00
10.00
1019.33
3.00
905.00
99.00
82.50
12.00
10.00
822.50
4.00
1841.00
176.00
146.67
12.00
10.00
1694.33
5.00
1540.00
136.00
113.33
12.00
10.00
1426.67
6.00
1554.00
124.00
103.33
12.00
10.00
1450.67
7.00
3468.00
258.00
215.00
12.00
10.00
3253.00
8.00
2525.00
176.00
146.67
12.00
10.00
2378.33
14328.00
1285.00
1070.83
13257.17
1.00
$1,901,480.00
2.00
6727567.00
3.00
425492.00
4.00
-798998.00
-798998.00
5.00
555087.00
6.00
2333656.00
7.00
$11,144,284.00
8.00
$13,648,001.00
9.00
6386509.00
10.00
$7,261,492.00
11.00
0.35
12.00
$2,541,522.20
0.35
13.00
$13,685,806.20
62302.18
24660.18
37642.00
-259.59
-259.59
10.00
($2,595.90)
$35,046.10
-110249.00
-110249.00
-51450.00
-58799.00
-58799.00
459.37
10.00
$4,593.70
($54,205.30)
-179675.00
-179675.00
-83099.00
-96576.00
-96576.00
748.65
10.00
$7,486.50
($89,089.50)
-227594.00
-227594.00
-22353.00
-205241.00
-205241.00
474.00
10.00
$4,740.00
($200,501.00)
1009011.00
140844.00
868167.00
868167.00
-2102.00
-2102.00
10.00
($21,020.00)
$847,147.00
46966.00
5382.00
41584.00
-97.85
-97.85
10.00
($978.50)
$40,605.50
$600,761.18
$13,984.18
$586,777.00
($777.42)
($7,774.20)
$579,002.80
1.00
2.00
$52,963,858.00
52963858.00
3.00
-8293501.00
-8293501.00
4.00
$44,670,357.00
5.00
6.00
-951458.00
-951458.00
7.00
-177438.00
-177438.00
8.00
12862.00
9.00
-544626.00
-544626.00
10.00
$43,009,697.00
11.00
($1,660,660.00)
1.00
$6,986.00
$6,986.00
$6,986.00
2.00
$347,574.48
$31,680.30
$379,254.78
($10,260.00)
($74,187.00)
-74187.00
$294,807.78
3.00
$50,865.25
($1,419.00)
-1419.00
$49,446.25
($6,467.00)
$42,979.25
4.00
$85,383.07
$40,096.70
$125,479.77
($11,660.00)
-11660.00
($33,134.00)
-33134.00
$80,685.77
5.00
$521,273.35
($521,273.35)
-521273.35
$0.00
$0.00
6.00
$369,144.85
$72,641.73
$141,414.87
$583,201.45
($14,510.00)
-14510.00
($142,743.00)
-142743.00
$425,948.45
7.00
$374,272.75
$14,036.15
($9,414.00)
$378,894.90
($14,600.00)
-14600.00
$364,294.90
8.00
$528,615.60
$1,167.29
$80,864.71
($6,705.00)
$603,942.60
($29,110.00)
-29110.00
($75,844.00)
-75844.00
$498,988.60
9.00
$0.00
$129,574.00
$129,574.00
$129,574.00
10.00
$3,384.00
$3,384.00
$3,384.00
11.00
$653,719.81
$337,198.35
95846.00
241352.35
($8,253.00)
$982,665.16
($127,851.00)
-127851.00
$854,814.16
12.00
$3,137,123.72
$15,585.00
($10,327.00)
$3,142,381.72
($121,246.00)
-121246.00
$3,021,135.72
13.00
$606,560.14
($3,820.00)
$602,740.14
($39,090.00)
-39090.00
$563,650.14
14.00
$6,986.00
$6,986.00
$6,986.00
15.00
$33,587.18
$38,916.00
$4,896.65
$77,399.83
($1,280.00)
-1280.00
($4,998.00)
-4998.00
$71,121.83
$0.00
$0.00
16.00
$346,860.40
($87,845.17)
-87845.17
($298,953.23)
-298953.23
$39,938.00
$0.00
$0.00
17.00
$0.44
$0.44
$0.44
18.00
$7,072,337.04
$0.00
$0.00
$0.00
$0.00
$7,072,337.04
($376,074.00)
($330,906.00)
$6,365,357.04
1.00
2.00
46699677.00
46699677.00
3.00
8293501.00
8293501.00
4.00
280656.00
280656.00
5.00
13985.00
13985.00
6.00
46699677.00
8293501.00
280656.00
13985.00
55287819.00
7.00
8.00
4429910.00
4429910.00
9.00
258547.00
258547.00
258547.00
10.00
-707092.00
-707092.00
11.00
951460.00
951460.00
12.00
42600.00
42600.00
13.00
323256.00
-323256.00
-323256.00
0.00
14.00
-94365.00
-94365.00
-94365.00
15.00
19350.00
19350.00
16.00
7774.00
7774.00
17.00
-2410.00
-2410.00
-2410.00
18.00
-12862.00
-12862.00
-12862.00
19.00
50926873.00
9232099.00
0.00
21759.00
60180731.00
20.00
4227196.00
938598.00
-280656.00
7774.00
4892912.00
244440.00
414839.22
659279.22
4259.45
4259.45
259.59
-748.65
-459.37
2102.00
97.85
-474.00
777.42
408631.00
414839.00
244440.00
415000.00
416500.00
418000.00
419500.00
421000.00
422500.00
424000.00
425500.00
4429910.00
?8?/?1?/?2004
95146.00
?9?/?1?/?2004
95146.00
?10?/?1?/?2004
95146.00
?11?/?1?/?2004
95146.00
?12?/?1?/?2004
95146.00
?1?/?1?/?2005
95146.00
?2?/?1?/?2005
95146.00
?3?/?1?/?2005
95146.00
?4?/?1?/?2005
95146.00
?5?/?1?/?2005
95146.00
951460.00
1.00
116926.00
116926.00
-9878.00
-9878.00
107048.00
2.00
6256619.00
6256619.00
190589.00
-78171.00
-78171.00
6369037.00
3.00
889034.00
889034.00
889034.00
4.00
411626.00
411626.00
411626.00
5.00
213383.00
213383.00
213383.00
6.00
4319530.00
-659755.00
-659755.00
3659775.00
659755.00
684073.00
-6800.00
-6800.00
-36314.00
-36314.00
4960489.00
7.00
8002050.00
8002050.00
5462862.00
13464912.00
8.00
35388.00
35388.00
8575.00
-3000.00
-3000.00
40963.00
9.00
3193688.00
3193688.00
94158.00
-12500.00
-12500.00
3275346.00
10.00
83217.00
83217.00
83217.00
11.00
1272275.00
-736742.00
-736742.00
535533.00
736742.00
1272275.00
12.00
9205941.00
9205941.00
241011.00
-152319.00
-152319.00
9294633.00
13.00
34652.00
34652.00
34652.00
14.00
592825.00
592825.00
1620842.00
2213667.00
15.00
381125.00
381125.00
93408.00
474533.00
16.00
10246641.00
10246641.00
1713043.00
-87040.00
-87040.00
-80584.00
-80584.00
11792060.00
17.00
0.00
0.00
0.00
18.00
357998.00
357998.00
5185627.00
5543625.00
19.00
961390.00
961390.00
13848.00
-19270.00
-19270.00
955968.00
20.00
13978190.00
13978190.00
8426386.00
-89457.00
-89457.00
22315119.00
21.00
0.00
0.00
500000.00
500000.00
22.00
8848528.00
8848528.00
226967.00
9075495.00
23.00
145.00
145.00
145.00
24.00
144.00
144.00
144.00
25.00
100756125.00
-1159161.00
-1159161.00
99596964.00
1159161.00
1159161.00
2756958.00
-68631.00
-68631.00
-128055.00
-128055.00
103316397.00
26.00
36824786.00
36824786.00
658231.00
96538.00
383901.00
177792.00
-115000.00
-115000.00
-28743.00
-28743.00
37339274.00
27.00
11575448.00
11575448.00
98173.00
12562.00
85611.00
-115000.00
-115000.00
-3000.00
-3000.00
11555621.00
28.00
1078405.00
1078405.00
-10763.00
-10763.00
1067642.00
29.00
0.00
0.00
0.00
30.00
0.00
0.00
0.00
31.00
37157.00
37157.00
8637.00
45794.00
32.00
43525.00
43525.00
43525.00
33.00
88441.00
88441.00
88441.00
34.00
15798.00
15798.00
15798.00
35.00
684579.00
684579.00
14000.00
-1134.00
-1134.00
697445.00
36.00
552910.00
552910.00
552910.00
37.00
1723563.00
627978.00
1095585.00
1723563.00
236965.00
-167750.00
-167750.00
1792778.00
38.00
2870105.00
2870105.00
1197379.00
4067484.00
39.00
1795069.00
1795069.00
1795069.00
40.00
134111.00
134111.00
2000.00
136111.00
41.00
24448.00
24448.00
24448.00
42.00
455945.00
455945.00
8000.00
463945.00
43.00
62533.00
62533.00
62533.00
44.00
116643.00
116643.00
116643.00
45.00
58817.00
58817.00
58817.00
46.00
62882.00
62882.00
21300.00
-14910.00
-14910.00
69272.00
47.00
1300447.00
1300447.00
12653.00
-6600.00
-6600.00
-7518.00
-7518.00
1298982.00
48.00
107621.00
107621.00
107621.00
49.00
0.00
0.00
0.00
50.00
268381.00
268381.00
367617.00
635998.00
51.00
52.00
2.00
2.00
-1.00
-1.00
1.00
53.00
54.00
230039056.00
-2555658.00
227483398.00
2555658.00
29843301.00
-707092.00
-535345.00
258639920.00
1.00
$227,483,399.00
$227,483,399.00
$31,156,521.00
$258,639,920.00
2.00
-55287819.00
-54993178.00
13985.00
280656.00
-55287819.00
-4892912.00
-5165794.00
7774.00
280656.00
-60180731.00
3.00
$172,195,580.00
$0.00
$172,195,580.00
$26,263,609.00
$198,459,189.00
4.00
($7,072,337.00)
-7072337.00
-7072337.00
706980.00
-6365357.00
5.00
-44670359.00
-44670359.00
-44670359.00
1660660.00
1660660.00
-43009699.00
6.00
600762.00
600762.00
600762.00
7.00
-11144388.00
-11144388.00
-11144388.00
-2541522.00
-2541522.00
-13685910.00
8.00
-14328.00
-14328.00
-14328.00
1071.00
-13257.00
9.00
1635124.00
1635124.00
396568.00
2031692.00
10.00
2045126.00
2045126.00
2045126.00
11.00
$113,575,180.00
$0.00
$113,575,180.00
$26,487,366.00
140062546.00