Spreadsheet: benjamin_rogers__1159__Base
Sheet: IRR

SEMIANNUAL CASH FLOW AND IRR
 |  |  |  | 2 |  | 2
EGC CASH FLOW
('000 $) |  |  | 1999-12-31 00:00:00 | 2000-02-15 00:00:00 | 2000-03-31 00:00:00 | 2000-08-15 00:00:00 | 2001-02-15 00:00:00 | 2001-08-15 00:00:00 | 2002-02-15 00:00:00 | 2002-08-15 00:00:00 | 2003-02-15 00:00:00 | 2003-08-15 00:00:00 | 2004-02-15 00:00:00 | 2004-08-15 00:00:00 | 2005-02-15 00:00:00 | 2005-08-15 00:00:00 | 2006-02-15 00:00:00 | 2006-08-15 00:00:00 | 2007-02-15 00:00:00 | 2007-08-15 00:00:00 | 2008-02-15 00:00:00 | 2008-08-15 00:00:00 | 2009-02-15 00:00:00 | 2009-08-15 00:00:00 | 2010-02-15 00:00:00 | 2010-08-15 00:00:00 | 2011-02-15 00:00:00 | 2011-08-15 00:00:00 | 2012-02-15 00:00:00 | 2012-08-15 00:00:00 | 2013-02-15 00:00:00 | 2013-08-15 00:00:00 | 2014-02-15 00:00:00 | 2014-08-15 00:00:00 | 2015-02-15 00:00:00 | 2015-08-15 00:00:00 | 2016-02-15 00:00:00 | 2016-08-15 00:00:00 | 2017-02-15 00:00:00 | 2017-08-15 00:00:00 | 2018-02-15 00:00:00 | 2018-08-15 00:00:00 | 2019-02-15 00:00:00 | 2019-08-15 00:00:00 | 2020-02-15 00:00:00 | 2020-12-31 00:00:00 | Total
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 | 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 | 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 | 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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Less Interest Payments |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Pre Tax Cash Flow |  |  |  |  | 0
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 | 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 | 0
EGC's Federal Tax Benefit / (Expense) |  |  |  |  | 0
After Tax Cash Flow
Debt Service |  |  | NA |  | 0
DSCR |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NA | NA
EQUITY PARTNER'S CASHFLOW
('000 $) |  |  | 1999-12-31 00:00:00 | 2000-02-15 00:00:00 | 2000-03-31 00:00:00 | 2000-08-15 00:00:00 | 2001-02-15 00:00:00 | 2001-08-15 00:00:00 | 2002-02-15 00:00:00 | 2002-08-15 00:00:00 | 2003-02-15 00:00:00 | 2003-08-15 00:00:00 | 2004-02-15 00:00:00 | 2004-08-15 00:00:00 | 2005-02-15 00:00:00 | 2005-08-15 00:00:00 | 2006-02-15 00:00:00 | 2006-08-15 00:00:00 | 2007-02-15 00:00:00 | 2007-08-15 00:00:00 | 2008-02-15 00:00:00 | 2008-08-15 00:00:00 | 2009-02-15 00:00:00 | 2009-08-15 00:00:00 | 2010-02-15 00:00:00 | 2010-08-15 00:00:00 | 2011-02-15 00:00:00 | 2011-08-15 00:00:00 | 2012-02-15 00:00:00 | 2012-08-15 00:00:00 | 2013-02-15 00:00:00 | 2013-08-15 00:00:00 | 2014-02-15 00:00:00 | 2014-08-15 00:00:00 | 2015-02-15 00:00:00 | 2015-08-15 00:00:00 | 2016-02-15 00:00:00 | 2016-08-15 00:00:00 | 2017-02-15 00:00:00 | 2017-08-15 00:00:00 | 2018-02-15 00:00:00 | 2018-08-15 00:00:00 | 2019-02-15 00:00:00 | 2019-08-15 00:00:00 | 2020-02-15 00:00:00 | 2020-12-31 00:00:00
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 |  | 0
Equity Contributions from Equity Partner |  | 0
Equity Partner's Cashflow Stream |  | 0
Actual IRR
Required Equity Investment from Equity Partner
IRR Calculation
 |  |  | Equity Contr.
 | Days to EOY 2/15 |  |  |  |  |  | Semiannual CF compounded to End of Year
 | Days to EOY 8/15
('000 $) |  |  | 1999-12-31 00:00:00 |  |  |  | 1999-12-31 00:00:00 | 2000-12-31 00:00:00
Equity Partner's Contribution discounted @
Equity Partner's Cashflow with No Residual Value | 0.1323173346284514
IRR | 535000
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
USING XIRR
Required Equity Investment from Equity Partner
 |  |  | 1999-12-31 00:00:00 | 2000-02-15 00:00:00 | 2000-03-31 00:00:00
Equity Partner's Contribution discounted @
Equity Partner's Cashflow with No Residual Value
IRR