20050211UWW Debt 06-04.xls

Sheet1
NvsASD
V2004-06-30
NvsAutoDrillOk
VN
NvsElapsedTime
1.47E-05
NvsEndTime
38203.72
NvsInstSpec
%,LACTUALS,SBAL,FACCOUNT,TUW_SEC_BAL_SHEET,NUNAMORT DEBT DISC
NvsLayoutType
M3
NvsNplSpec
%,XZF.ACCOUNT.PSDetail
NvsPanelEffdt
V1900-01-01
NvsPanelSetid
VUWR
NvsParentRef
NvsReqBU
V800
NvsReqBUOnly
VY
NvsTransLed
VN
NvsTreeASD
V2004-06-30
NvsValTbl.ACCOUNT
GL_ACCOUNT_TBL
NvsValTbl.PROJECT_ID
PROJECT_FS
NvsValTbl.UW_ACTIVITY
UW_ACTIVITY_TBL
United Waterworks Inc.
Cost of Long Term Debt
At June 30, 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
Annual
Cost
Weighted
Line
Description
Issue
Maturity
Amount
Premium and
Proceeds
Interest
Expense
Premium and
Cost
Rate
Embedded
Number
of Debt
Date
Date
Outstanding
Expense
(C.4+/-C.5)
Rate
(C.4xC.7)
Expense
(C.8+C.9)
(C.10/C.6)
Cost Rate
1.00
Medium Term Note 1995
2/95
2/25
10000000.00
115596.00
9884404.00
0.09
884000.00
5616.00
889616.00
0.09
4.03E-03
2.00
Medium Term Note Series A 1997
10/97
10/07
15000000.00
24640.00
14975360.00
0.07
1020000.00
7392.00
1027392.00
0.07
4.66E-03
3.00
Medium Term Note Series A 1998
2/98
2/23
25000000.00
1806523.00
23193477.00
0.07
1742500.00
97212.00
1839712.00
0.08
8.34E-03
4.00
Medium Term Note Series A 1998
12/98
12/17
5000000.00
54432.00
4945568.00
0.07
345000.00
4032.00
349032.00
0.07
1.58E-03
5.00
Medium Term Note Series A 1998
2/98
2/28
15000000.00
189044.00
14810956.00
0.07
1065000.00
8016.00
1073016.00
0.07
4.86E-03
6.00
Medium Term Note Series A 1998
11/98
11/08
5000000.00
411598.00
4588402.00
0.06
322000.00
93192.00
415192.00
0.09
1.88E-03
7.00
Tax Exempt-Delaware 95 TEF
6/95
6/25
25000000.00
844997.00
24155003.00
0.06
1550000.00
40404.00
1590404.00
0.07
7.21E-03
8.00
Tax Exempt-Wilm 92 TEF Series B
12/92
12/07
4650000.00
27552.00
4622448.00
0.06
299925.00
8064.00
307989.00
0.07
1.40E-03
9.00
Tax Exempt-Dauphin 92 TEF Series B
6/92
6/17
4185000.00
53165.00
4131835.00
0.07
280395.00
4116.00
284511.00
0.07
1.29E-03
10.00
Tax Exempt-Boise 2001 TEF
9/01
9/31
26775000.00
3589543.00
23185457.00
0.05
1338750.00
132132.00
1470882.00
0.06
6.67E-03
11.00
Tax Exempt-DE 2002 TEF
3/02
3/33
17000000.00
2149104.16
14850895.84
0.05
875500.00
74964.00
950464.00
0.06
4.31E-03
12.00
Tax Exempt NY (NR) 2002 TEF
3/02
3/34
12000000.00
1583820.32
10416179.68
0.05
618000.00
53388.00
671388.00
0.06
3.04E-03
13.00
Tax Exempt-Dauphin 92 TEF Series A
6/92
6/24
10000000.00
367949.00
9632051.00
0.07
690000.00
18480.00
708480.00
0.07
3.21E-03
14.00
Tax Exempt-Boise 94 TEF
10/94
10/24
19975000.00
961579.00
19013421.00
0.06
1278400.00
47484.00
1325884.00
0.07
6.01E-03
15.00
Tax Exempt-JAX95TEF
8/95
8/25
20000000.00
570816.00
19429184.00
0.06
1270000.00
27072.00
1297072.00
0.07
5.88E-03
16.00
Tax Exempt-Boise 97 $20MTEF Series 1997
8/97
8/27
19850000.00
987504.32
18862495.68
0.05
1052050.00
42780.00
1094830.00
0.06
4.96E-03
17.00
Total Long-Term Debt
234435000.00
13737862.80
220697137.20
14631520.00
664344.00
15295864.00
0.07
Additional Debt Costs
18.00
Premium on Retirement of Prudential Capital
Corp.Debt ($20M @10.05%,$15M @ 9.57%)
and Jacksonville Debt ($12M @ 6.75%)
6763008.00
340992.00
340992.00
1.55E-03
1.55E-03
19.00
Unamortized Costs Associated With Retired
Jacksonville Debt ($12M @ 6.75%)
459142.42
24924.00
24924.00
1.13E-04
1.13E-04
20.00
Totals
20960013.22
14631520.00
1030260.00
15661780.00
0.07