Spreadsheet: benjamin_rogers__1066__NewCo-7-15-00
Sheet: ENA_Debt

[NAME] DEBT ISSUANCE
('000 $) | 2001
 | 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 less Contract Amortization
Tranche 1
 |  | 2002-01-01 00:00:00 | 2003-01-01 00:00:00 | 2004-01-01 00:00:00 | 2005-01-01 00:00:00 | 2006-01-01 00:00:00 | 2007-01-01 00:00:00 | 2008-01-01 00:00:00 | 2009-01-01 00:00:00 | 2010-01-01 00:00:00 | 2011-01-01 00:00:00 | 2012-01-01 00:00:00 | 2013-01-01 00:00:00 | 2014-01-01 00:00:00 | 2015-01-01 00:00:00 | 2016-01-01 00:00:00 | 2017-01-01 00:00:00 | 2018-01-01 00:00:00 | 2019-01-01 00:00:00 | 2020-01-01 00:00:00 |  | Principal | Check
Beginning Balance | 0
Interest Payment | 0
Ending Balance
 | 2001-06-30 00:00:00 | 2002-06-30 00:00:00 | 2003-06-30 00:00:00 | 2004-06-30 00:00:00 | 2005-06-30 00:00:00 | 2006-06-30 00:00:00 | 2007-06-30 00:00:00 | 2008-06-30 00:00:00 | 2009-06-30 00:00:00 | 2010-06-30 00:00:00 | 2011-06-30 00:00:00 | 2012-06-30 00:00:00 | 2013-06-30 00:00:00 | 2014-06-30 00:00:00 | 2015-06-30 00:00:00 | 2016-06-30 00:00:00 | 2017-06-30 00:00:00 | 2018-06-30 00:00:00 | 2019-06-30 00:00:00 | 2020-06-30 00:00:00
Beginning Balance
Amortization % | 0.155 | 0.165 | 0.25
Principal Payment
Interest Payment
Ending Balance
 | 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
Beginning Balance
Amortization % | 0.155 | 0.1675 | 0.1075
Principal Payment
Interest Payment
Ending Balance
Tranche 2
 |  | 2002-01-01 00:00:00 | 2003-01-01 00:00:00 | 2004-01-01 00:00:00 | 2005-01-01 00:00:00 | 2006-01-01 00:00:00 | 2007-01-01 00:00:00 | 2008-01-01 00:00:00 | 2009-01-01 00:00:00 | 2010-01-01 00:00:00 | 2011-01-01 00:00:00 | 2012-01-01 00:00:00 | 2013-01-01 00:00:00 | 2014-01-01 00:00:00 | 2015-01-01 00:00:00 | 2016-01-01 00:00:00 | 2017-01-01 00:00:00 | 2018-01-01 00:00:00 | 2019-01-01 00:00:00 | 2020-01-01 00:00:00
Beginning Balance | 0
Interest Payment | 0
Ending Balance
 | 2001-06-30 00:00:00 | 2002-06-30 00:00:00 | 2003-06-30 00:00:00 | 2004-06-30 00:00:00 | 2005-06-30 00:00:00 | 2006-06-30 00:00:00 | 2007-06-30 00:00:00 | 2008-06-30 00:00:00 | 2009-06-30 00:00:00 | 2010-06-30 00:00:00 | 2011-06-30 00:00:00 | 2012-06-30 00:00:00 | 2013-06-30 00:00:00 | 2014-06-30 00:00:00 | 2015-06-30 00:00:00 | 2016-06-30 00:00:00 | 2017-06-30 00:00:00 | 2018-06-30 00:00:00 | 2019-06-30 00:00:00 | 2020-06-30 00:00:00
Beginning Balance
Amortization % | 0 | 0 | 0 | 0.0425 | 0.0585 | 0.0665 | 0.0725 | 0.0825 | 0.0905 | 0.12
Principal Payment
Interest Payment
Ending Balance
 | 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
Beginning Balance
Amortization % | 0 | 0 | 0 | 0.0425 | 0.0585 | 0.0665 | 0.0725 | 0.0825 | 0.0905 | 0.05399999999999994
Principal Payment
Interest Payment
Ending Balance
Tranche 3
 |  | 2002-01-01 00:00:00 | 2003-01-01 00:00:00 | 2004-01-01 00:00:00 | 2005-01-01 00:00:00 | 2006-01-01 00:00:00 | 2007-01-01 00:00:00 | 2008-01-01 00:00:00 | 2009-01-01 00:00:00 | 2010-01-01 00:00:00 | 2011-01-01 00:00:00 | 2012-01-01 00:00:00 | 2013-01-01 00:00:00 | 2014-01-01 00:00:00 | 2015-01-01 00:00:00 | 2016-01-01 00:00:00 | 2017-01-01 00:00:00 | 2018-01-01 00:00:00 | 2019-01-01 00:00:00 | 2020-01-01 00:00:00
Beginning Balance | 0
Interest Payment | 0
Ending Balance
 | 2001-06-30 00:00:00 | 2002-06-30 00:00:00 | 2003-06-30 00:00:00 | 2004-06-30 00:00:00 | 2005-06-30 00:00:00 | 2006-06-30 00:00:00 | 2007-06-30 00:00:00 | 2008-06-30 00:00:00 | 2009-06-30 00:00:00 | 2010-06-30 00:00:00 | 2011-06-30 00:00:00 | 2012-06-30 00:00:00 | 2013-06-30 00:00:00 | 2014-06-30 00:00:00 | 2015-06-30 00:00:00 | 2016-06-30 00:00:00 | 2017-06-30 00:00:00 | 2018-06-30 00:00:00 | 2019-06-30 00:00:00 | 2020-06-30 00:00:00
Beginning Balance
Amortization % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.05 | 0.05 | 0.05 | 0.05 | 0.0525 | 0.055 | 0.055 | 0.045 | 0.045 | 0.045
Principal Payment
Interest Payment
Ending Balance
 | 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
Beginning Balance
Amortization % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.015 | 0.05 | 0.05 | 0.05 | 0.05 | 0.0525 | 0.055 | 0.055 | 0.045 | 0.045 | 0.03500000000000009
Principal Payment
Interest Payment
Ending Balance
Total Debt
Beginning Balance
Ending Balance
Principal Payments
Interest Expense
Net Debt Service
ACTUAL DSCR
 | DSCR
 | Fixed Price Period: |  |  | Merchant Price Period:
 | Minimum |  |  | Minimum
 | Average |  |  | Average
Accrued Interest
 | Tranche 1 |  |  |  |  | Tranche 2 |  |  |  |  | Tranche 3
 | Treasury (%) |  |  |  |  | Treasury (%) |  |  |  |  | Treasury (%)
 | Spread (%) |  |  |  |  | Spread (%) |  |  |  |  | Spread (%)
 | All In Coupon Rate (%) |  |  |  |  | All In Coupon Rate (%) |  |  |  |  | All In Coupon Rate (%)
 | Term (years) |  |  |  |  | Term (years) |  |  |  |  | Term (years)
 | Average Life (years) |  |  |  |  | Average Life (years) |  |  |  |  | Average Life (years)
 | Total amount ($ '000) |  |  |  |  | Total amount ($ '000) |  |  |  |  | Total amount ($ '000)
Time Factor
Average Life
Tranche 1
Tranche 2
Tranche 3
Tax Shield
NPV @