Spreadsheet: mary_fischer__25815__Model from Steve 07_27
Sheet: Company_Sum

Company Summary |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O:\Corporate\Tax\lotus\2001 Current Estimate\2nd CE\Corp Planning Models\[Model from [NAME] 07_27.xls]Company_Sum
2001 CURRENT ESTIMATE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2001-07-31 13:32:05.850000
RESULTS OF OPERATIONS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2001-07-31 13:32:05.850000
(Millions of Dollars) |  |  | TOTAL YEAR 2001
 |  |  | Trans & Distrib Summary |  | Wholesale Summary |  | ENRON ENERGY SERVICES, INC - RETAIL4 |  | ENRON BROADBAND SERVICES |  | ENRON GLOBAL ASSETS & SERVICES |  | ENRON RENEWABLE ENERGY CORP. |  | ENRON CLEAN FUELS |  | Corporate & Other Summary |  | CORP FINANCE (099, 011) |  | Overview |  |  |  |  |  | TOTAL
 |  |  | {SUM} |  | {SUM} |  | EES |  | EBS |  | EGA |  | EREC |  | CFUELS |  | {SUM} |  | FINANCE |  | OVERVIEW
Operating Revenues |  |  | 3718.99979142 |  | 167617.501542 |  | 2429.878 |  | -56.4 |  | 1269.4 |  | 880.3 |  | 144.5 |  | 32.8 |  | 0 |  | 0 |  |  |  |  |  | 176036.97933342
Cost of Sales |  |  | 2439.35416512 |  | 163599.782333 |  | 1501.796 |  | 69.8 |  | 558.5 |  | 729.5 |  | 116.1 |  | 5.1 |  | 0 |  | 0 |  |  |  |  |  | 169019.93249812
GROSS MARGIN |  |  | 1279.6456263 |  | 4017.719208999973 |  | 928.0819999999999 |  | -126.2 |  | 710.9 |  | 150.8 |  | 28.4 |  | 27.7 |  | 0 |  | 0 |  |  |  |  |  | 7017.046835299974
Operating & Processing Expense
 | Operation & maintenance |  | 503.79940491 |  | 1596.673789455164 |  | 661.6129999999998 |  | 319.7 |  | 583.2 |  | 79.6 |  | 46.4 |  | 303.0717776666667 |  | 0 |  | 0 |  |  |  |  |  | 4094.057972031831
 | Compressor fuel expense |  | -18.3 |  | 120.1 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  |  |  | 101.8
 | Lease and well expense |  | 0 |  | 4.2 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  |  |  | 4.2
 | Oil & gas exploration expenses |  | 0 |  | 3.8 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  |  |  | 3.8
 | Transmission/compression & storage |  | 23.9 |  | 8.3 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  |  |  | 32.2
 | Depreciation, depletion & amortization |  | 138.0351437 |  | 235.1246795703368 |  | 38.90199999999999 |  | 79.6 |  | 153 |  | 21.7 |  | 9 |  | 125.9666666666667 |  | 0 |  | 0 |  |  |  |  |  | 801.3284899370035
 | Amortization of fair value adjustment |  | 34.691966 |  | 0.048 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -4 |  | 0 |  | 0 |  |  |  |  |  | 30.739966
 | Taxes other than income |  | 113.10366931 |  | 71.46237299985823 |  | 8.433 |  | 20.2 |  | 12 |  | 0 |  | 2.6 |  | 34.49351166666666 |  | 0 |  | 0 |  |  |  |  |  | 262.2925539765249
 |  | Total | 795.23018392 |  | 2039.708842025359 |  | 708.9479999999999 |  | 419.5 |  | 748.2 |  | 101.3 |  | 58 |  | 459.531956 |  | 0 |  | 0 |  |  |  |  |  | 5330.418981945359
OPERATING INCOME |  |  | 484.4154423799996 |  | 1978.010366974614 |  | 219.134 |  | -545.7 |  | -37.3 |  | 49.49999999999994 |  | -29.6 |  | -431.831956 |  | 0 |  | 0 |  |  |  |  |  | 1686.627853354616
Other Income (Deductions)
 | Equity earnings |  | 65 |  | 147.004124 |  | -46.198 |  | 2.7 |  | 138.8 |  | 3.5 |  | 0 |  | -101.7 |  | 0 |  | 0 |  |  |  |  |  | 209.106124
 | Minority interest - EREC / EES |  | 0 |  | 0 |  | 0 |  | 0 |  | 5.8 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  |  |  | 5.8
 | Dividend and Interest income |  | 0.5246165 |  | 202.3496766867684 |  | 2.694 |  | 0 |  | 32.7 |  | 0.7 |  | 0 |  | 17.6 |  | 0 |  | 0 |  |  |  |  |  | 256.5682931867684
 | Gain (Loss) on sale of assets |  | 2.733000000000001 |  | -18.028764 |  | 50.005 |  | -32.4 |  | 0.1000000000000014 |  | 0 |  | -1 |  | 0 |  | 0 |  | 0 |  |  |  |  |  | 1.409235999999993
 | Other |  | 35.23165844 |  | 40.54125855453223 |  | -0.634 |  | -0.9 |  | -21.2 |  | -0.7 |  | 0 |  | -5.8 |  | 0 |  | 969.5 |  |  |  |  |  | 1016.038916994532
 |  | Total | 103.48927494 |  | 371.8662952413006 |  | 5.866999999999997 |  | -30.6 |  | 156.2 |  | 3.5 |  | -1 |  | -89.9 |  | 0 |  | 969.5 |  |  |  |  |  | 1488.922570181301
INCOME BEFORE INTEREST & TAXES |  |  | 587.9047173199996 |  | 2349.876662215915 |  | 225.001 |  | -576.3 |  | 118.9 |  | 52.99999999999994 |  | -30.6 |  | -521.7319560000001 |  | 0 |  | 969.5 |  |  |  |  |  | 3175.550423535916
Interest Expense
 | Interest expense - Third Party |  | 113.7173250275181 |  | 51.896438 |  | 0.649 |  | 2.3 |  | 69.6 |  | 8 |  | 0 |  | 514.393326 |  | 123.7 |  | -3.462968009999935 |  |  |  |  |  | 880.7931210175182
 | Interco interest expense/(income)  - Capital Charge |  | 117 |  | 138.6232702503707 |  | 38.032 |  | 6.5 |  | 60.8 |  | 19.4 |  | 5.5 |  | -385.8552702503708 |  | 0 |  | 0 |  |  |  |  |  | -5.684341886080801e-14
 | Interco interest expense/(income)  - Other |  | -75.037543 |  | -45.90902402535886 |  | -0.918 |  | 0 |  | 68.4 |  | 0 |  | 0 |  | 53.46456702535883 |  | 0 |  | 0 |  |  |  |  |  | -2.842170943040401e-14
 | Capitalized interest/AFUDC |  | -4.454511971830831 |  | -0.842908 |  | -1.732 |  | -7.8 |  | -0.1 |  | -4.6 |  | -0.3 |  | -17.4 |  | 0 |  | 2.02784965 |  |  |  |  |  | -35.20157032183084
 |  | Total | 151.2252700556872 |  | 143.7677762250119 |  | 36.031 |  | 1 |  | 198.7 |  | 22.8 |  | 5.2 |  | 164.602622774988 |  | 123.7 |  | -1.435118359999934 |  |  |  |  |  | 845.5915506956874
Minority Interest
 | Structured Transactions |  | 0 |  | 0 |  | 0 |  | 0 |  | 12.6 |  | 0 |  | 0 |  | 54.5 |  | 0 |  | 0 |  |  |  |  |  | 67.1
 | Other |  | 0 |  | 49.92838099999999 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 20 |  | 0 |  | 0 |  |  |  |  |  | 69.928381
 |  | Total | 0 |  | 49.92838099999999 |  | 0 |  | 0 |  | 12.6 |  | 0 |  | 0 |  | 74.5 |  | 0 |  | 0 |  |  |  |  |  | 137.028381
Perpetual Preferred Dividends |  |  | 2.325 |  | 0 |  | 0 |  | 0 |  | 7.8 |  | 0 |  | 0 |  | 35.713878 |  | 31.2 |  | 0 |  |  |  |  |  | 77.038878
INCOME BEFORE INCOME TAXES |  |  | 434.3544472643123 |  | 2156.180504990903 |  | 188.97 |  | -577.3 |  | -100.2 |  | 30.19999999999994 |  | -35.8 |  | -796.5484567749882 |  | -154.9 |  | 970.9351183599999 |  |  |  |  |  | 2115.891613840229
Income Taxes
 | Payable currently |  | 134.2886719924489 |  | 786.3101908352419 |  | -69.434 |  | -221.5 |  | -30.7 |  | 12.4 |  | -53 |  | -510.40038641 |  | -55.5 |  | 151.7 |  |  |  |  |  | 144.1644764176907
 | Payment deferred |  | 21.15407195528558 |  | -100.9939506460158 |  | 145.186 |  | 41.1 |  | -2.799999999999989 |  | -1.6 |  | 40.5 |  | 221.12869741 |  | 0 |  | 0 |  |  |  |  |  | 363.6748187192698
 |  | Total | 155.4427439477345 |  | 685.316240189226 |  | 75.75200000000001 |  | -180.4 |  | -33.5 |  | 10.8 |  | -12.5 |  | -289.271689 |  | -55.5 |  | 151.7 |  |  |  |  |  | 507.8392951369605
NET INCOME |  |  | 278.9117033165779 |  | 1470.864264801677 |  | 113.218 |  | -396.9 |  | -66.69999999999993 |  | 19.39999999999994 |  | -23.3 |  | -507.2767677749882 |  | -99.4 |  | 819.2351183599999 |  |  |  |  |  | 1608.052318703268
Company Summary |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O:\Corporate\Tax\lotus\2001 Current Estimate\2nd CE\Corp Planning Models\[Model from [NAME] 07_27.xls]Company_Sum
2001 CURRENT ESTIMATE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2001-07-31 13:32:05.850000
Cash Flow Statement |  |  | TOTAL YEAR 2001
 |  |  | Trans & Distrib Summary |  | Wholesale Summary |  | ENRON ENERGY SERVICES, INC - RETAIL4 |  | ENRON BROADBAND SERVICES |  | ENRON GLOBAL ASSETS & SERVICES |  | ENRON RENEWABLE ENERGY CORP. |  | ENRON CLEAN FUELS |  | Corporate & Other Summary |  | CORP FINANCE (099, 011) |  | Overview |  |  |  |  |  | TOTAL
CASH FLOW FROM OPERATING ACTIVITIES
Net Income (excluding changes in accounting principle) |  |  | 274.1117033165784 |  | 1470.864264801703 |  | 113.2180000000001 |  | -396.9 |  | -66.7 |  | 19.4 |  | -23.3 |  | -507.2767677749881 |  | -99.4 |  | 1.435118359999934 |  |  |  |  |  | 785.4523187032933
Items not affecting cash:
 | Depreciation, depletion & amortization |  | 172.8271097 |  | 235.1251465703367 |  | 38.90199999999999 |  | 79.6 |  | 153 |  | 21.7 |  | 9 |  | 125.9676666666667 |  | 0 |  | 0 |  |  |  |  |  | 836.1219229370034
 | Deferred income taxes |  | 20.46705017028559 |  | -96.43595064601585 |  | 145.186 |  | 41.1 |  | -2.799999999999989 |  | -1.6 |  | 40.5 |  | 221.12769741 |  | 0 |  | 0 |  |  |  |  |  | 367.5447969342698
 | Equity Earnings |  | -64.9 |  | -147.004124 |  | 46.198 |  | -2.7 |  | -138.8 |  | -3.5 |  | 0 |  | 101.7 |  | 0 |  | 0 |  |  |  |  |  | -209.006124
 | Net (gain)/loss on sale of assets |  | -2.832999999999998 |  | 17.954 |  | -50.005 |  | 32.4 |  | 0 |  | 0 |  | 1 |  | 0 |  | 0 |  | 0 |  |  |  |  |  | -1.483999999999995
 | Unrealized (gain)/loss on price risk mgmt activities |  | 28.7 |  | 360.0108862973149 |  | -229.007 |  | -29.4 |  | 60.6 |  | 0 |  | 0 |  | 87.19700000000002 |  | 0 |  | 0 |  |  |  |  |  | 278.1008862973149
 | Merchant Activities
 |  | Realized (Gains) / Losses on Sales | 0 |  | -12.475 |  | -33.893 |  | 0.1 |  | -1.2 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  |  |  | -47.468
 |  | Proceeds from Sales | 0 |  | 352.2 |  | 88.425 |  | 90.8 |  | 38.7 |  | 0 |  | 0 |  | 2 |  | 0 |  | 0 |  |  |  |  |  | 572.125
 |  | Additions | 0 |  | -239.064064 |  | -77.57900000000001 |  | -11.5 |  | -59 |  | 0 |  | 0 |  | -6 |  | 0 |  | 0 |  |  |  |  |  | -393.143064
 |  | Unrealized (Gains)/ Losses | 0 |  | 39.43800000000001 |  | 0 |  | 7.6 |  | 0 |  | 0 |  | 0 |  | -3.2 |  | 0 |  | 0 |  |  |  |  |  | 43.83800000000001
 | Equity/Partnership Distributions |  | 25.7 |  | 13.5 |  | 0 |  | 0 |  | 64 |  | 8.2 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  |  |  | 111.4
 | Oil & gas exploration expenses |  | 0 |  | 3.8 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  |  |  | 3.8
 | Dividends on Pref Securities of Subsidiary Companies |  | 2.325 |  | 0 |  | 0 |  | 0 |  | 7.8 |  | 0 |  | 0 |  | 31.194898 |  | 31.2 |  | 0 |  |  |  |  |  | 72.519898
 | Income Attributable to Minority Interest |  | 0 |  | 23.322 |  | 0 |  | 0 |  | 12.6 |  | 0 |  | 0 |  | 54.499 |  | 0 |  | 0 |  |  |  |  |  | 90.42099999999999
 | Other (Including transfers & reclaesses; see detail) |  | -42 |  | -76.05634944300908 |  | -6.4 |  | 55.8 |  | 13.6 |  | 10.1 |  | 1.9 |  | -57.50599999999994 |  | 0 |  | 0 |  |  |  |  |  | -100.562349443009
 |  | FUNDS FLOW FROM OPERATIONS | 414.397863186864 |  | 1945.178809580329 |  | 35.045 |  | -133.1 |  | 81.8 |  | 54.3 |  | 29.1 |  | 49.70349430167866 |  | -68.2 |  | 1.435118359999934 |  |  |  |  |  | 2409.660285428873
Working Capital Changes:
 | Receivables |  | -49.35068909449323 |  | -799.0830000000008 |  | -23.394 |  | 0.5 |  | -97.2 |  | 0.2000000000000135 |  | 0 |  | 240.003 |  | 0 |  | 0 |  |  |  |  |  | -728.3246890944939
 | Inventories |  | -8.400000000000006 |  | -208.371 |  | 17.859 |  | -13.1 |  | -1.2 |  | 7.3 |  | 14.4 |  | -0.002 |  | 0 |  | 0 |  |  |  |  |  | -191.5139999999999
 | Prepayments |  | -36.1 |  | 431.473 |  | -7.799 |  | -1.2 |  | -4.8 |  | 15.6 |  | 0 |  | -5.1 |  | 0 |  | 0 |  |  |  |  |  | 392.0740000000001
 | Broker net settlements |  | 0 |  | 315.564 |  | -0.508 |  | -0.3 |  | -2.6 |  | 0 |  | 0 |  | -0.001 |  | 0 |  | 0 |  |  |  |  |  | 312.155
 | Payables |  | -175.5 |  | 351.3615580884144 |  | -36.894 |  | -26.2 |  | -69.6 |  | -11.4 |  | 5.4 |  | 5.038999999999999 |  | 0 |  | 0 |  |  |  |  |  | 42.20655808841435
 | Accrued Taxes |  | -1.666342615235756 |  | 171.3158708352417 |  | -93.665 |  | -22.3 |  | 15.4 |  | -28.8 |  | -0.8 |  | 154.3130000000001 |  | 0 |  | 0 |  |  |  |  |  | 193.7975282200061
 | Accrued Interest |  | 1.770325821917809 |  | -3.954 |  | 0 |  | 0 |  | -1.8 |  | 0 |  | 0 |  | 20.402 |  | 100.1319658507931 |  | 0 |  |  |  |  |  | 116.550291672711
 | Customer Deposits |  | 0 |  | -2684.425 |  | 0.602 |  | 0 |  | 0 |  | 4.8 |  | 0 |  | 41.501 |  | 0 |  | 0 |  |  |  |  |  | -2637.521999999999
 | Other Changes in Working Capital |  | -22.53732256042068 |  | 358.3819999999999 |  | -12.333 |  | -24.4 |  | -96.2 |  | -23.2 |  | -10.1 |  | -74.6 |  | 0 |  | 0 |  |  |  |  |  | 95.01167743957927
 | TOTAL WORKING CAPITAL CHANGES |  | -291.7840284482319 |  | -2067.736571076344 |  | -156.132 |  | -87 |  | -258 |  | -35.5 |  | 8.9 |  | 381.555 |  | 100.1319658507931 |  | 0 |  |  |  |  |  | -2405.565633673782
CASH FROM OPERATING ACTIVITIES |  |  | 122.613834738632 |  | -122.557761496015 |  | -121.087 |  | -220.1 |  | -176.2 |  | 18.8 |  | 38 |  | 431.2584943016788 |  | 31.93196585079315 |  | 1.435118359999934 |  |  |  |  |  | 4.094651755090581
CASH FLOWS FROM INVESTING
 | Proceeds from Sale of Investments |  | 57.3 |  | 1263.118 |  | 50 |  | 1 |  | 4.100000000000009 |  | 0 |  | 61.9 |  | 38.6 |  | 0 |  | 0 |  |  |  |  |  | 1476.018
 | Capital Expenditures |  | -402.6527380952381 |  | -698.5279414223496 |  | -67.654 |  | -150 |  | -125.1 |  | -31.6 |  | -14.4 |  | -206.2 |  | 0 |  | 0 |  |  |  |  |  | -1696.134679517588
 | Property Transfers - Intercompany |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 40.3 |  | 0 |  | 0 |  |  |  |  |  | 40.3
 | Equity Investments |  | -6 |  | -54.656 |  | 0 |  | -15 |  | -146.6 |  | -2.4 |  | 0 |  | -328.9 |  | 0 |  | 0 |  |  |  |  |  | -553.556
 | Cash paid for Business Acquisitions |  | 0 |  | -219.956 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  |  |  | -219.956
 | Other Investing Activity |  | -21.80035432183074 |  | -1295.456 |  | -6.064 |  | 18.4 |  | -34.3 |  | 22.9 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  |  |  | -1316.320354321831
 | CASH FLOWS FROM INVESTING |  | -373.1530924170688 |  | -1005.47794142235 |  | -23.718 |  | -145.6 |  | -301.9 |  | -11.1 |  | 47.5 |  | -456.2 |  | 0 |  | 0 |  |  |  |  |  | -2269.649033839419
CASH FLOWS FROM FINANCING
 | Third party debt increase/(decrease) |  | 125.8473536586332 |  | -1237.334997300013 |  | -0.243 |  | 7 |  | 53.1 |  | -6.699999999999989 |  | 0 |  | 2942.6 |  | 353 |  | 0 |  |  |  |  |  | 2237.269356358619
 | Stock (purchases) isssuances |  | 1.499999999999865 |  | 6.7 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 39.1 |  | 0 |  | 0 |  |  |  |  |  | 47.29999999999987
 | Dividends to Corp |  | 0 |  | -165.6 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 245.6 |  | 0 |  | 0 |  |  |  |  |  | 80
 | Dividends on Preferred Stock of Subs |  | -2.3625 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -8.7 |  | -31.4 |  | 0 |  |  |  |  |  | -42.4625
 | [NAME] to Outside |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -250.9 |  | -251 |  | 0 |  |  |  |  |  | -501.9
 | Other Financing Activity |  | 0.8 |  | 7.361000000000002 |  | -0.004000000000000004 |  | 0 |  | -15.3 |  | 12.8 |  | -1 |  | -0.4 |  | 0 |  | 0 |  |  |  |  |  | 4.257
 | CASH FLOWS FROM FINANCING |  | 125.784853658633 |  | -1388.873997300013 |  | -0.247 |  | 7 |  | 37.8 |  | 6.100000000000012 |  | -1 |  | 2967.3 |  | 70.6 |  | 0 |  |  |  |  |  | 1824.463856358619
NET CASH FLOW (After Financing Activities) |  |  | -124.7544040198038 |  | -2516.909700218378 |  | -145.052 |  | -358.7 |  | -440.3 |  | 13.80000000000005 |  | 84.5 |  | 2942.358494301678 |  | 102.5319658507932 |  | 1.435118359999934 |  |  |  |  |  | -441.0905257257095
CASH FLOWS FROM INTERCOMPANY ACTIVITY
 | Accounts Receivable/Payable - Intercompany |  | -8.999999999999977 |  | 2416.826675316667 |  | 155.1379999999999 |  | 41.9 |  | -73 |  | -9.4 |  | 25.8 |  | -2028.598008649999 |  | 0 |  | 0 |  |  |  |  |  | 519.6666666666681
 | Other Investing Activities-Intercompany |  | 5.3 |  | 1572.24 |  | 0 |  | 0 |  | 18.8 |  | -12.7 |  | 0 |  | -2631.04 |  | 0 |  | 0 |  |  |  |  |  | -1047.4
 | Other Financing Activities-Intercompany |  | 132.4 |  | -1784.563999999998 |  | 0.077 |  | 317.8 |  | 367.6 |  | -39.6 |  | -110.3 |  | 225.9189658507921 |  | -102.5319658507931 |  | 0 |  |  |  |  |  | -993.2
(INCREASE)/DECREASE IN CASH AND NOTE FROM CORPORATE |  |  | 128.7 |  | 2204.502675316669 |  | 155.215 |  | 359.7 |  | 313.4 |  | -61.7 |  | -84.5 |  | -4433.719042799206 |  | -102.5319658507931 |  | 0 |  |  |  |  |  | -1520.933333333331
 |  | Increase/(Decrease) in Restricted/Retained Cash | 3.945595980196231 |  | -312.4070249017095 |  | 10.16299999999995 |  | 1 |  | -126.9 |  | -47.89999999999993 |  | 0 |  | -1491.360548497528 |  | 0 |  | 1.435118359999934 |  |  |  |  |  | -1962.023859059041