Spreadsheet: tracy_geaccone__40554__CorpCharge_Model_Hyp_Actual
Sheet: EBS-ECI4

Enron Broadband Services |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O:\Corporate\GPGFin\Cfp\0103Plan\[capcharge.xls]Capital Charge Template
CAPITAL CHARGE CALCULATION |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2001-03-05 14:25:06.610000
2001
(Millions of Dollars)
ECI4
PY_R |  |  |  | ACTUAL |  | ACTUAL |  | ACTUAL |  | ACTUAL |  | ACTUAL |  | ACTUAL |  | ACTUAL |  | ACTUAL |  | ACTUAL |  | ACTUAL |  | ACTUAL |  | ACTUAL
2000-12-31 00:00:00 |  |  |  | 2001-01-31 00:00:00 |  | 2001-02-28 00:00:00 |  | 2001-03-01 00:00:00 |  | 2001-04-01 00:00:00 |  | 2001-05-01 00:00:00 |  | 2001-06-01 00:00:00 |  | 2001-07-01 00:00:00 |  | 2001-08-01 00:00:00 |  | 2001-09-01 00:00:00 |  | 2001-10-01 00:00:00 |  | 2001-11-01 00:00:00 |  | 2001-12-01 00:00:00
Theoretical Debt at 12/31/00:
 | Equity (A)  [(DR) / CR] |  |  | 3318.3
 | Third Party Debt (B)  [(DR) / CR] |  |  | 117.6
 | Company Obligated Preferred Stock of Subs (G) |  |  | 0
 | Net Intercompany balance (C)  [(DR) / CR] |  |  | -184.0000000000011
 |  | [NAME] |  | -2177.2
 |  | 51 |  | -1926.4
 |  | 52 |  | 0
 |  | 37 |  | -2445.1
 |  | 38 |  | 0
 |  | 486 |  | 3294.1
 |  | 516 |  | 93
 |  | 517 |  | 0
 |  | 660 |  | 804.6
 |  | 661 |  | 0
 |  | 878 |  | 2177.7
 | Adjustment for Net PRM |  |  | -587
 | Adjustment for EGF allocation |  | 204.5 | 204.5
 | Adjustment for Off B/S Items |  | 19 | 19
 |  | Total Capital
 | Theoretical [NAME] |  | 0.5 | 0.5
 |  |  |  | JAN |  | FEB |  | MAR |  | APR |  | MAY |  | JUN |  | JUL |  | AUG |  | SEP |  | OCT |  | NOV |  | DEC |  | TOTAL
Theoretical Debt Balance - Beginning of Month |  |  |  | 93.8
Increase/(Decrease) In Cash Required (D) (turned in to R. Maldonado)
Changes in other I/C accounts (factored in for cap charge purposes)
Total
 | Theoretical Debt % |  |  | 0.1
Theoretical Debt Portion of Monthly Cash Flow
Total Theoretical Debt Balance
Interest Rate (7.5% annual) |  |  |  | 0.00625 |  | 0.00625 |  | 0.00625 |  | 0.00625 |  | 0.00625 |  | 0.00625 |  | 0.00625 |  | 0.00625 |  | 0.00625 |  | 0.00625 |  | 0.00625 |  | 0.00625
Total Capital Charge
Adjustments
 | Third Party Interest (Expense) (E)
 | Intercompany Interest Income/(Expense) (F)
Total Capital Charge booked by Corporate
 | (A) | Hyperion line TOT_SHARE-EQU less line 0948 (CTA)
 | (B) | Hyperion line TOT_OTH_LT_DEBT and TOT_NP_OTHER and 0775
 | (C) | Hyperion lines: 0051, 0052, 0037, 0038, TOT_INV_CONSUB, 0486, 0516, 0517, 0660
 |  | 0661, 0878, 0186
 | (D) | Cash is defined as the change in all intercompany accounts; this includes all accounts in note (C) and 0901, 0915, 920, 0936, 0941, 1505, and 1506
 | (E) | Hyperion lines TOT_INT_EXP_OTH, 1730, and 1735
 | (F) | Hyperion lines 1605, 1681, 1713, 1751, 1736, 1738
 | (G) | Hyperion line 875
 |  | NOTE: For purposes of Actual Cash Flow reporting to Corp (R. Maldonado), only the following accounts are considered: 0051, 0052, 0037, 0038, 0486, 0516, 0517, 0660, 0661
 |  |  |  |  |  | Jan |  |  |  | Feb |  |  |  | Mar |  |  |  | Apr |  |  |  | May |  |  |  | Jun |  |  |  | Jul |  |  |  | Aug |  |  |  | Sep |  |  |  | Oct |  |  |  | Nov |  |  |  | Dec
 |  | 2000-12-01 00:00:00 |  | 2001-01-01 00:00:00 |  | Change |  | 2001-02-01 00:00:00 |  | Change |  | 2001-03-01 00:00:00 |  | Change |  | 2001-04-01 00:00:00 |  | Change |  | 2001-05-01 00:00:00 |  | Change |  | 2001-06-01 00:00:00 |  | Change |  | 2001-07-01 00:00:00 |  | Change |  | 2001-08-01 00:00:00 |  | Change |  | 2001-09-01 00:00:00 |  | Change |  | 2001-10-01 00:00:00 |  | Change |  | 2001-11-01 00:00:00 |  | Change |  | 2001-12-01 00:00:00 |  | Change
[NAME]
0051
0052
0037
0038
0486
0516
0517
0660
0661
0878
0901
0915
0916
0920
0921
0186
1505 |  | 0
1506 |  | 0
0936
0941
0930 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
0931 |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
Total
YTD Total - Cash per Raul
YTD Total - Cash per Cap Charge
THIRD PARTY INTEREST
 |  |  |  |  |  | Jan |  |  |  | Feb |  |  |  | Mar |  |  |  | Apr |  |  |  | May |  |  |  | Jun |  |  |  | Jul |  |  |  | Aug |  |  |  | Sep |  |  |  | Oct |  |  |  | Nov |  |  |  | Dec
 |  | 2000-12-01 00:00:00 |  | 2001-01-01 00:00:00 |  | Change |  | 2001-02-01 00:00:00 |  | Change |  | 2001-03-01 00:00:00 |  | Change |  | 2001-04-01 00:00:00 |  | Change |  | 2001-05-01 00:00:00 |  | Change |  | 2001-06-01 00:00:00 |  | Change |  | 2001-07-01 00:00:00 |  | Change |  | 2001-08-01 00:00:00 |  | Change |  | 2001-09-01 00:00:00 |  | Change |  | 2001-10-01 00:00:00 |  | Change |  | 2001-11-01 00:00:00 |  | Change |  | 2001-12-01 00:00:00 |  | Change
tot_int_exp_oth
1730
1735
Total
INTERCOMPANY INTEREST
1605
1681
1713
1751
1736
1738
Total