Spreadsheet: benjamin_rogers__1169__Base
Sheet: CF

ANNUAL CASH FLOW AND IRR
EGC CASH FLOW
 |  |  | 3 Months |  |  | 11 Months
('000 $) |  |  | 1999 | 2000 | 2000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  | 1999-12-31 00:00:00 | 2000-01-31 00:00:00 | 2000-03-31 00:00:00 | 2000-12-31 00:00:00 | 2001-12-31 00:00:00 | 2002-12-31 00:00:00 | 2003-12-31 00:00:00 | 2004-12-31 00:00:00 | 2005-12-31 00:00:00 | 2006-12-31 00:00:00 | 2007-12-31 00:00:00 | 2008-12-31 00:00:00 | 2009-12-31 00:00:00 | 2010-12-31 00:00:00 | 2011-12-31 00:00:00 | 2012-12-31 00:00:00 | 2013-12-31 00:00:00 | 2014-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-12-31 00:00:00 | 2017-12-31 00:00:00 | 2018-12-31 00:00:00 | 2019-12-31 00:00:00 | 2020-12-31 00:00:00
EBITDA |  |  |  |  | 0
Enron's Undertaking |  |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Retained Cash Flow |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Plus Capitalized Interest |  |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Less Principal Payments |  |  | 0 |  | 0
Less Interest Payments |  |  | 0 |  | 0
Pre Tax Cash Flow
Repayment of Enron's Undertaking |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Net Pre Tax Cash Flow
EGC's State Tax Benefit / (Expense) |  |  |  | 0 | 0
EGC's Federal Tax Benefit / (Expense) |  |  |  |  | 0
After Tax Cash Flow
Equity Partner Net Income |  |  | 0
Equity Partner Distributable Cash |  | 0.5
EQUITY PARTNER'S CASHFLOW
('000 $) |  |  | 1999 | 2000 | 2000
Pre Tax Cash Flow
Equity Partner's State Taxes Benefit (Expense)
Equity Partner's Federal Taxes Benefit (Expense)
After Tax Cash Flow
50% Equity on 12/99, 50% on 3/00
Distributable After Tax Cash to Equity Partner
Equity Contributions from Equity Partner |  |  |  | 0
Equity Partner's Cashflow Stream
Actual IRR
Required Equity Investment from Equity Partner
Equity Partner's Cashflow with 5x EBITDA Residual Value
CF
5x EBITDA Terminal Value |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Net CF
Equity Partner's After-Tax IRR w/ 5x EBITDA Residual (20 yr.)
Equity Partner's Cashflow with 50% Project Price Residual Value
CF
50% Total Cost Terminal Value |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Net CF
Equity Partner's After-Tax IRR w/ 50% Total Cost Residual (20 yrs)
IRR Calculation
('000 $) |  |  | 1999-12-31 00:00:00 | 2000-12-31 00:00:00 | 2001-12-31 00:00:00 | 2002-12-31 00:00:00 | 2003-12-31 00:00:00 | 2004-12-31 00:00:00 | 2005-12-31 00:00:00 | 2006-12-31 00:00:00 | 2007-12-31 00:00:00 | 2008-12-31 00:00:00 | 2009-12-31 00:00:00 | 2010-12-31 00:00:00 | 2011-12-31 00:00:00 | 2012-12-31 00:00:00 | 2013-12-31 00:00:00 | 2014-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-12-31 00:00:00 | 2017-12-31 00:00:00 | 2018-12-31 00:00:00 | 2019-12-31 00:00:00 | 2020-12-31 00:00:00
Equity Partner's Contribution discounted @
Equity Partner's Cashflow with No Residual Value
IRR
Equity Partner's Contribution discounted @
Equity Partner's Cashflow with 5x EBITDA Residual Value
IRR
Equity Partner's Contribution discounted @
Equity Partner's Cashflow with 50% Project Price Residual Value
IRR