Spreadsheet: benjamin_rogers__1159__Base
Sheet: Debt

 |  | Tranche 1 |  |  |  |  |  | Tranche 2 |  |  |  |  |  | Tranche 3
 |  | 3 year Treasury (as of April 26) |  |  | 0.0594 |  |  | 8 year Treasury (as of April 26) |  |  | 0.0622 |  |  | 30 year Treasury (as of April 26) |  |  | 0.0631
 |  | Spread |  |  | 0.0225 |  |  | Spread |  |  | 0.035 |  |  | Spread |  |  | 0.04125
 |  | All In Coupon Rate |  |  |  |  |  | All In Coupon Rate |  |  |  |  |  | All In Coupon Rate
 |  | Maturity Tranche 1 |  |  | 3.33 |  |  | Maturity Tranche 2 |  |  | 9.83 |  |  | Maturity Tranche 2 |  |  | 19.83
 |  | Average Life Tranche 1 |  |  |  |  |  | Average Life Tranche 2 |  |  |  |  |  | Average Life Tranche 3
 |  | Total amount ($ '000) |  |  | 83000 |  |  | Total amount ($ '000) |  |  | 215000 |  |  | Total amount ($ '000)
EGC SENIOR DEBT
 | 1
('000 $) | 1999-12-31 00:00:00 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019
Annual Amortization Tranche 1 | 0 | 0.09732410821237938 | 0.2857367875784234 | 0.3040794937317309
Annual Amortization Tranche 2 |  | 0 | 0 | 0 | 0.09350113008394252 | 0.1012 | 0.1193 | 0.1335 | 0.156 | 0.176
Annual Amortization Tranche 3 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.07630644790042608 | 0.08482519508920063 | 0.09344673518848429 | 0.099651055116767 | 0.1064911885555333 | 0.1160566509227743 | 0.1183220860257878 | 0.1155758145526061 | 0.101896046822598
Jan. 31
Beginning Balance
Principal Payment | 0
Interest Payment | 0
Ending Balance
Jul. 31
Beginning Balance
Principal Payment | 0
Interest Payment | 0
Ending Balance
Dec. 31
Beginning Balance
Accrued Principal |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Interest Accrued
Ending Balance
Cash Interest Expense | 0
Accrued Interest Expense
Cash Principal Payments
[NAME]
Jan. 31
Beginning Balance
Principal Payment | 0 |  |  |  | 0
Interest Payment | 0
Ending Balance
Jul. 31
Beginning Balance
Principal Payment | 0
Interest Payment | 0
Ending Balance
Dec. 31
Beginning Balance
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Interest Accrued
Ending Balance
Cash Interest Expense | 0
Accrued Interest Expense
Cash Principal Payments
Accrued Principal
Jan. 31
Beginning Balance
Principal Payment | 0 |  |  |  |  |  |  |  |  |  | 0
Interest Payment | 0
Ending Balance
Jul. 31
Beginning Balance
Principal Payment | 0
Interest Payment | 0
Ending Balance
Dec. 31
Beginning Balance
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Interest Accrued
Ending Balance
Cash Interest Expense | 0
Accrued Interest Expense
Cash Principal Payments
Accrued Principal
EBITDA | 0
Tranche 1 Cash Debt Service
Tranche 2  Cash Debt Service
Tranche 3 Cash Debt Service
Less Retained Cash Flow | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Less Enron Undertaking | 0
Less Capitalized Interest
Net Debt Service | 0
Total Cash Interest Expense
Total Accrued Interest Expense
Cash Principal Payments
Total Accrued Principal
Accrued DS Reserve For 1999 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DSCR Fixed Price PPA Period |  |  |  |  | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA
DSCR Market Price Period | NA | NA | NA | NA
 | Average DSCR (Fixed Price Period) (2000-2002) |  |  |  |  | Average DSCR (Market Price Period) (2003-2019)
 | Minimum DSCR (Fixed Price Period) (2000-2002) |  |  |  |  | Minimum DSCR (Market Price Period) (2003-2019)
Capitalized Interest
 |  | 2000-01-31 00:00:00 | 2000-07-31 00:00:00 | 2001-01-31 00:00:00 | 2001-07-31 00:00:00 | 2002-01-31 00:00:00 | 2002-07-31 00:00:00 | 2003-01-31 00:00:00 | 2003-07-31 00:00:00 | 2004-01-31 00:00:00 | 2004-07-31 00:00:00 | 2005-01-31 00:00:00 | 2005-07-31 00:00:00 | 2006-01-31 00:00:00 | 2006-07-31 00:00:00 | 2007-01-31 00:00:00 | 2007-07-31 00:00:00 | 2008-01-31 00:00:00 | 2008-07-31 00:00:00 | 2009-01-31 00:00:00 | 2009-07-31 00:00:00 | 2010-01-31 00:00:00 | 2010-07-31 00:00:00 | 2011-01-31 00:00:00 | 2011-07-31 00:00:00 | 2012-01-31 00:00:00 | 2012-07-31 00:00:00 | 2013-01-31 00:00:00 | 2013-07-31 00:00:00 | 2014-01-31 00:00:00 | 2014-07-31 00:00:00 | 2015-01-31 00:00:00 | 2015-07-31 00:00:00 | 2016-01-31 00:00:00 | 2016-07-31 00:00:00 | 2017-01-31 00:00:00 | 2017-07-31 00:00:00 | 2018-01-31 00:00:00 | 2018-07-31 00:00:00 | 2019-01-31 00:00:00 | 2019-07-31 00:00:00
 | 0
Tranch 1 Principal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Tranche 2 Principal | 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
Tranche 3 Principal | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Average Life
Tranche 1
Tranche 2
Tranche 3
 | 1999-12-31 00:00:00 | 2000-12-31 00:00:00
Accrual
 | 2000-02-15 00:00:00 | 2000-08-15 00:00:00
Cash
EBITDA
 | 1999-08-01 00:00:00 | 2000-01-31 00:00:00 | 2000-07-31 00:00:00 | 2001-01-31 00:00:00 | 2001-07-31 00:00:00 | 2002-01-31 00:00:00 | 2002-07-31 00:00:00 | 2003-01-31 00:00:00 | 2003-07-31 00:00:00 | 2004-01-31 00:00:00 | 2004-07-31 00:00:00 | 2005-01-31 00:00:00 | 2005-07-31 00:00:00 | 2006-01-31 00:00:00 | 2006-07-31 00:00:00 | 2007-01-31 00:00:00 | 2007-07-31 00:00:00 | 2008-01-31 00:00:00 | 2008-07-31 00:00:00 | 2009-01-31 00:00:00 | 2009-07-31 00:00:00 | 2010-01-31 00:00:00 | 2010-07-31 00:00:00 | 2011-01-31 00:00:00 | 2011-07-31 00:00:00 | 2012-01-31 00:00:00 | 2012-07-31 00:00:00 | 2013-01-31 00:00:00 | 2013-07-31 00:00:00
 | 0
Tranch 1 Principal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Tranche 2 Principal | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Tranche 3 Principal | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Average Life
Tranche 1
Tranche 2
Tranche 3
Coverage |  | 1.596803059088169 | 1.288333600016639 | 1.289578550423721 | 1.003883360207408
 |  |  |  |  | 2.143373723853124 | 2.257160685886551 | 2.250489099577047 | 2.293544526404513 | 2.330996295729845 | 2.35196666928825 | 2.438691169490676 | 2.628091947428949 | 2.810297227121372 | 2.842313758376444 | 2.917746519999707 | 3.000753292478105 | 3.055344398363262 | 3.269711570460253 | 3.636276602292246 | 4.438768392769733 | 5.576356139649929
Debt Service
 |  | 95000 | 210000 | 425000
Jan. 31
Beginning Balance
Principal Payment | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Interest Payment | 0
Ending Balance
Jul. 31
Beginning Balance
Principal Payment | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Interest Payment | 0
Ending Balance
Dec. 31
Beginning Balance
Accrued Principal |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Interest Accrued
Ending Balance
Cash Interest Expense | 0
Accrued Interest Expense
Cash Principal Payments
[NAME]
Jan. 31
Beginning Balance
Principal Payment | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Interest Payment | 0 |  |  |  |  |  |  |  |  |  |  | 0
Ending Balance
Jul. 31
Beginning Balance
Principal Payment | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Interest Payment | 0 |  |  |  |  |  |  |  |  |  |  | 0
Ending Balance
Dec. 31
Beginning Balance
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Interest Accrued
Ending Balance
Cash Interest Expense | 0
Accrued Interest Expense
Cash Principal Payments
Accrued Principal
Jan. 31
Beginning Balance
Principal Payment | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Interest Payment | 0
Ending Balance
Jul. 31
Beginning Balance
Principal Payment | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Interest Payment | 0
Ending Balance
Dec. 31
Beginning Balance
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Interest Accrued
Ending Balance
Cash Interest Expense | 0
Accrued Interest Expense
Cash Principal Payments
Accrued Principal
EBITDA | 0
Tranche 1 Cash Debt Service
Tranche 2  Cash Debt Service
Tranche 3 Cash Debt Service
Less Interest Income | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Less ECT's Undertakings
Less Capitalized Interest | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Net Debt Service | 0
Total Cash Interest Expense
Total Accrued Interest Expense
Cash Principal Payments
Total Accrued Principal
Accrued DS Reserve For 1999 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DSCR Fixed Price PPA Period |  |  |  |  |  | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA
DSCR Market Price Period | NA | NA | NA | NA
 | Average DSCR (Fixed Price Period) (2000-2003) |  |  |  |  | Average DSCR (Market Price Period) (2004-2019)
 | Minimum DSCR (Fixed Price Period) (2000-2003) |  |  |  |  | Minimum DSCR (Market Price Period) (2004-2019)