200505021st staff response UWI CHall.xls

Dec 31 Consolodated COC
UWI Dec 31, 2004
United Waterworks Inc.
Cost of Long Term Debt
At December 31, 2004
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
Unamortized
Annual
Amortization of
Embedded
[a]
Net Discount,
Net
Stated
Interest
Net Discount
Cost
Weighted
Line
Description
Issue
Maturity
Amount
Premium and
Proceeds
Interest
Expense
Rate
Number
of Debt
Date
Outstanding
(C.4+/-C.5)
(C.4xC.7)
(C.8+C.9)
Cost Rate
Medium Term Note Series A 1997
10/97
10/07
Medium Term Note Series A 1998
2/98
2/23
12/98
12/17
2/28
11/98
11/08
Tax Exempt-Delaware 95 TEF
6/95
6/25
Tax Exempt-Wilm 92 TEF Series B
12/92
12/07
Tax Exempt-Dauphin 92 TEF Series B
6/92
6/17
Tax Exempt-Boise 2001 TEF
9/01
9/31
Tax Exempt-DE 2002 TEF
3/02
3/33
Tax Exempt NY (NR) 2002 TEF
3/34
Tax Exempt-Dauphin 92 TEF Series A
6/24
Tax Exempt-Boise 05 TEF
5/05
5/35
Tax Exempt-JAX95TEF
8/95
8/25
Tax Exempt-Boise 97 $20MTEF Series 1997
8/97
8/27
Total Long-Term Debt
Additional Debt Costs
Unamortized Costs Associated With Retired
Medium Term Note ($10M@8.84%)
Premium on Retirement of Medium Term Note
Premium on Retirement of Prudential Capital
Corp.Debt ($20M @10.05%,$15M @ 9.57%)
and Jacksonville Debt ($12M @ 6.75%)
Jacksonville Debt ($12M @ 6.75%)
Totals
UNITED WATERWORKS, INC
CONSOLIDATED CAPITAL STRUCTURE
ITEM
AMOUNT
PERCENTAGE
COST
WEIGHTED
Long-term Debt
Minority Interest (Preferred Stock)
Common Equity
Total
COMMON EQUITY
Common Stock
Paid in Captial
Retained Earnings
(C.10/C.4)
?12?/?31?/?2004
224435000.00
0.53
0.06
0.03
554200.00
1.32E-03
0.05
6.59E-05
195233257.00
0.46
0.10
0.05
$420,222,457.00
1.00
0.08
1164.00
52383174.00
142848919.00
195233257.00
1.00
15000000.00
20944.00
14979056.00
0.07
1020000.00
7392.00
1027392.00
0.07
4.58E-03
2.00
25000000.00
1757917.00
23242083.00
0.07
1742500.00
97212.00
1839712.00
0.07
8.20E-03
3.00
5000000.00
52416.00
4947584.00
0.07
345000.00
4032.00
349032.00
0.07
1.56E-03
4.00
15000000.00
185036.00
14814964.00
0.07
1065000.00
8016.00
1073016.00
0.07
4.78E-03
5.00
5000000.00
365002.00
4634998.00
0.06
322000.00
93192.00
415192.00
0.08
1.85E-03
6.00
25000000.00
824795.00
24175205.00
0.06
1550000.00
40404.00
1590404.00
0.06
7.09E-03
7.00
4650000.00
23520.00
4626480.00
0.06
299925.00
8064.00
307989.00
0.07
1.37E-03
8.00
4185000.00
51107.00
4133893.00
0.07
280395.00
4116.00
284511.00
0.07
1.27E-03
9.00
26775000.00
3523477.00
23251523.00
0.05
1338750.00
132132.00
1470882.00
0.05
6.55E-03
10.00
17000000.00
2111622.16
14888377.84
0.05
875500.00
74964.00
950464.00
0.06
4.24E-03
11.00
12000000.00
1557126.32
10442873.68
0.05
618000.00
53388.00
671388.00
0.06
2.99E-03
12.00
10000000.00
358709.00
9641291.00
0.07
690000.00
18480.00
708480.00
0.07
3.16E-03
13.00
1.00
19975000.00
2170697.00
17804303.00
0.05
938825.00
72356.57
1011181.57
0.05
4.51E-03
14.00
1.00
20000000.00
557280.00
19442720.00
0.06
1270000.00
27072.00
1297072.00
0.06
5.78E-03
15.00
19850000.00
966114.32
18883885.68
0.05
1052050.00
42780.00
1094830.00
0.06
4.88E-03
16.00
224435000.00
14525762.80
209909237.20
13407945.00
683600.57
14091545.57
0.06
0.06
17.00
1.00
112788.00
5616.00
5616.00
2.68E-05
2.68E-05
442000.00
22100.00
22100.00
1.05E-04
1.05E-04
18.00
1.00
6592511.68
340992.00
340992.00
1.62E-03
1.62E-03
19.00
1.00
446680.42
24924.00
24924.00
1.19E-04
1.19E-04
20.00
1.00
22119742.90
13407945.00
1077232.57
14485177.57
0.06
0.06