Spreadsheet: dan_hyvl__4805__PEAK2001 1-18 10yr for RFP
Sheet: Seller's's PP Calc

Seller's Prepay Calculation
 |  |  |  |  | Texas Gas Transmission |  |  |  |  |  | Tennessee Gas Pipeline |  |  |  |  |  |  | Totals
 |  |  |  |  | 1 | 2 | 3 | 4 | 5 |  | 6 | 7 | 8 | 9 | 10 |  |  | 11 | 12 | 13 | 14 | 15 | 16
 |  |  |  |  | Monthly | Monthly | Physical Premium |  |  |  | Monthly | Monthly | Physical Premium |  |  |  |  | Monthly | Monthly |  |  | Discount | Cash Flow
 |  |  |  |  | Contract | Prices | Margin |  | Cash Flow |  | Contract | Prices | Margin |  | Cash Flow |  |  | Contract | Prices | Cash Flow |  | Factor | Discounted
Month | Normal | PV | PV |  | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME] | (Average) | (Total)
of Flow | Pay Date | Days | Period |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (Total) |  |  | Ten Year UST | 0.051
 |  |  |  |  | MMBtu | $/MMBtu | $/MMBtu | $ | $ |  | MMBtu | $/MMBtu | $/MMBtu | $ | $ |  |  | MMBtu | $/MMBtu | $ | Swap Spread | 0.0088 | $
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Additional Spread | 0.015
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Discount Rate
2001-04-26 00:00:00
2001-05-01 00:00:00 | 2001-06-25 00:00:00
2001-06-01 00:00:00 | 2001-07-25 00:00:00
2001-07-01 00:00:00 | 2001-08-25 00:00:00
2001-08-01 00:00:00 | 2001-09-25 00:00:00
2001-09-01 00:00:00 | 2001-10-25 00:00:00
2001-10-01 00:00:00 | 2001-11-25 00:00:00
2001-11-01 00:00:00 | 2001-12-25 00:00:00
2001-12-01 00:00:00 | 2002-01-25 00:00:00
2002-01-01 00:00:00 | 2002-02-25 00:00:00
2002-02-01 00:00:00 | 2002-03-25 00:00:00
2002-03-01 00:00:00 | 2002-04-25 00:00:00
2002-04-01 00:00:00 | 2002-05-25 00:00:00
2002-05-01 00:00:00 | 2002-06-25 00:00:00
2002-06-01 00:00:00 | 2002-07-25 00:00:00
2002-07-01 00:00:00 | 2002-08-25 00:00:00
2002-08-01 00:00:00 | 2002-09-25 00:00:00
2002-09-01 00:00:00 | 2002-10-25 00:00:00
2002-10-01 00:00:00 | 2002-11-25 00:00:00
2002-11-01 00:00:00 | 2002-12-25 00:00:00
2002-12-01 00:00:00 | 2003-01-25 00:00:00
2003-01-01 00:00:00 | 2003-02-25 00:00:00
2003-02-01 00:00:00 | 2003-03-25 00:00:00
2003-03-01 00:00:00 | 2003-04-25 00:00:00
2003-04-01 00:00:00 | 2003-05-25 00:00:00
2003-05-01 00:00:00 | 2003-06-25 00:00:00
2003-06-01 00:00:00 | 2003-07-25 00:00:00
2003-07-01 00:00:00 | 2003-08-25 00:00:00
2003-08-01 00:00:00 | 2003-09-25 00:00:00
2003-09-01 00:00:00 | 2003-10-25 00:00:00
2003-10-01 00:00:00 | 2003-11-25 00:00:00
2003-11-01 00:00:00 | 2003-12-25 00:00:00
2003-12-01 00:00:00 | 2004-01-25 00:00:00
2004-01-01 00:00:00 | 2004-02-25 00:00:00
2004-02-01 00:00:00 | 2004-03-25 00:00:00
2004-03-01 00:00:00 | 2004-04-25 00:00:00
2004-04-01 00:00:00 | 2004-05-25 00:00:00
2004-05-01 00:00:00 | 2004-06-25 00:00:00
2004-06-01 00:00:00 | 2004-07-25 00:00:00
2004-07-01 00:00:00 | 2004-08-25 00:00:00
2004-08-01 00:00:00 | 2004-09-25 00:00:00
2004-09-01 00:00:00 | 2004-10-25 00:00:00
2004-10-01 00:00:00 | 2004-11-25 00:00:00
2004-11-01 00:00:00 | 2004-12-25 00:00:00
2004-12-01 00:00:00 | 2005-01-25 00:00:00
2005-01-01 00:00:00 | 2005-02-25 00:00:00
2005-02-01 00:00:00 | 2005-03-25 00:00:00
2005-03-01 00:00:00 | 2005-04-25 00:00:00
2005-04-01 00:00:00 | 2005-05-25 00:00:00
2005-05-01 00:00:00 | 2005-06-25 00:00:00
2005-06-01 00:00:00 | 2005-07-25 00:00:00
2005-07-01 00:00:00 | 2005-08-25 00:00:00
2005-08-01 00:00:00 | 2005-09-25 00:00:00
2005-09-01 00:00:00 | 2005-10-25 00:00:00
2005-10-01 00:00:00 | 2005-11-25 00:00:00
2005-11-01 00:00:00 | 2005-12-25 00:00:00
2005-12-01 00:00:00 | 2006-01-25 00:00:00
2006-01-01 00:00:00 | 2006-02-25 00:00:00
2006-02-01 00:00:00 | 2006-03-25 00:00:00
2006-03-01 00:00:00 | 2006-04-25 00:00:00
2006-04-01 00:00:00 | 2006-05-25 00:00:00
2006-05-01 00:00:00 | 2006-06-25 00:00:00
2006-06-01 00:00:00 | 2006-07-25 00:00:00
2006-07-01 00:00:00 | 2006-08-25 00:00:00
2006-08-01 00:00:00 | 2006-09-25 00:00:00
2006-09-01 00:00:00 | 2006-10-25 00:00:00
2006-10-01 00:00:00 | 2006-11-25 00:00:00
2006-11-01 00:00:00 | 2006-12-25 00:00:00
2006-12-01 00:00:00 | 2007-01-25 00:00:00
2007-01-01 00:00:00 | 2007-02-25 00:00:00
2007-02-01 00:00:00 | 2007-03-25 00:00:00
2007-03-01 00:00:00 | 2007-04-25 00:00:00
2007-04-01 00:00:00 | 2007-05-25 00:00:00
2007-05-01 00:00:00 | 2007-06-25 00:00:00
2007-06-01 00:00:00 | 2007-07-25 00:00:00
2007-07-01 00:00:00 | 2007-08-25 00:00:00
2007-08-01 00:00:00 | 2007-09-25 00:00:00
2007-09-01 00:00:00 | 2007-10-25 00:00:00
2007-10-01 00:00:00 | 2007-11-25 00:00:00
2007-11-01 00:00:00 | 2007-12-25 00:00:00
2007-12-01 00:00:00 | 2008-01-25 00:00:00
2008-01-01 00:00:00 | 2008-02-25 00:00:00
2008-02-01 00:00:00 | 2008-03-25 00:00:00
2008-03-01 00:00:00 | 2008-04-25 00:00:00
2008-04-01 00:00:00 | 2008-05-25 00:00:00
2008-05-01 00:00:00 | 2008-06-25 00:00:00
2008-06-01 00:00:00 | 2008-07-25 00:00:00
2008-07-01 00:00:00 | 2008-08-25 00:00:00
2008-08-01 00:00:00 | 2008-09-25 00:00:00
2008-09-01 00:00:00 | 2008-10-25 00:00:00
2008-10-01 00:00:00 | 2008-11-25 00:00:00
2008-11-01 00:00:00 | 2008-12-25 00:00:00
2008-12-01 00:00:00 | 2009-01-25 00:00:00
2009-01-01 00:00:00 | 2009-02-25 00:00:00
2009-02-01 00:00:00 | 2009-03-25 00:00:00
2009-03-01 00:00:00 | 2009-04-25 00:00:00
2009-04-01 00:00:00 | 2009-05-25 00:00:00
2009-05-01 00:00:00 | 2009-06-25 00:00:00
2009-06-01 00:00:00 | 2009-07-25 00:00:00
2009-07-01 00:00:00 | 2009-08-25 00:00:00
2009-08-01 00:00:00 | 2009-09-25 00:00:00
2009-09-01 00:00:00 | 2009-10-25 00:00:00
2009-10-01 00:00:00 | 2009-11-25 00:00:00
2009-11-01 00:00:00 | 2009-12-25 00:00:00
2009-12-01 00:00:00 | 2010-01-25 00:00:00
2010-01-01 00:00:00 | 2010-02-25 00:00:00
2010-02-01 00:00:00 | 2010-03-25 00:00:00
2010-03-01 00:00:00 | 2010-04-25 00:00:00
2010-04-01 00:00:00 | 2010-05-25 00:00:00
2010-05-01 00:00:00 | 2010-06-25 00:00:00
2010-06-01 00:00:00 | 2010-07-25 00:00:00
2010-07-01 00:00:00 | 2010-08-25 00:00:00
2010-08-01 00:00:00 | 2010-09-25 00:00:00
2010-09-01 00:00:00 | 2010-10-25 00:00:00
2010-10-01 00:00:00 | 2010-11-25 00:00:00
2010-11-01 00:00:00 | 2010-12-25 00:00:00
2010-12-01 00:00:00 | 2011-01-25 00:00:00
2011-01-01 00:00:00 | 2011-02-25 00:00:00
2011-02-01 00:00:00 | 2011-03-25 00:00:00
2011-03-01 00:00:00 | 2011-04-25 00:00:00
2011-04-01 00:00:00 | 2011-05-25 00:00:00
Total