Spreadsheet: kevin_hyatt__19604__Base Model 111601
Sheet: Pipeline Co IS

 |  |  |  |  | Warning Flags:
Income Statement
INCOME STATEMENT ($000)
 |  |  |  |  |  | Projected Fiscal Year Ending December 31,
 |  |  | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011
 |  |  |  |  | Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
OPERATING REVENUE
TOTAL OPERATING REVENUE
OPERATING EXPENSES
TOTAL OPERATING EXPENSES
OTHER INCOME
Other Net Income
Other Income 2
Other Income 3
TOTAL OTHER INCOME
EBITDA
DEPRECIATION AND AMORTIZATION |  |  | 56000 | 58000 | 65000
EBIT
INTEREST EXPENSES
Interest on Long Term Debt |  |  | 25000 | 64000 | 82000
Other Interest |  |  | 52000 | 14000 | 3000 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other Interest 3 |  |  | 0 | 0 | 0 | 0
Other Interest 4 |  |  | 0 | 0 | 0 | 0
TOTAL INTEREST EXPENSES
NET INCOME BEFORE INCOME TAXES
TAXES
Income Taxes |  |  | 57000 | 47000 | 43000
General Taxes |  |  | 26000 | 29000 | 23000
Deferred Taxes |  |  | 0 | 0 | 0 | 0
Taxes 4 |  |  | 0 | 0 | 0 | 0
TOTAL TAXES
NET INCOME
OPERATING STATISTICS
 |  |  |  |  |  | Projected Fiscal Year Ending December 31,
 |  |  | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011
 |  |  |  |  | Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
GROWTH
Revenue Growth
EBITDA Growth
EBIT Growth
Net Income Growth
MARGINS
EBITDA Margin (%)
EBIT Margin (%)
Revenue per Expense
REVENUE PROJECTIONS ($000)
 |  |  |  |  |  | Projected Fiscal Year Ending December 31,
 |  |  | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011
 |  |  |  |  | Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
OPERATING REVENUE | 1=On, 0=Off
Transportation & Storage of NatGas | 1 |  | 468000 | 441000 | 425000
LNG Terminalling Revenue | 1 |  | 0 | 0 | 0
Other | 1 |  | 28000 | 30000 | 58000
Revenue 4 | 0 |  | 0 | 0 | 0 | 0
Revenue 5 | 0 |  | 0 | 0 | 0 | 0
Revenue 6 | 0 |  | 0 | 0 | 0 | 0
TOTAL OPERATING REVENUE
GROWTH RATES
Transportation & Storage of NatGas |  |  |  |  |  |  | 1.01 | 1.01 | 1.01 | 1.01 | 1.01 | 1.01 | 1.01 | 1.01 | 1.01 | 1.01
LNG Terminalling Revenue |  |  |  |  |  |  | 1.02 | 1.02 | 1.02 | 1.02 | 1.02 | 1.02 | 1.02 | 1.02 | 1.02 | 1.02
Other |  |  |  |  |  |  | 1.03 | 1.03 | 1.03 | 1.03 | 1.03 | 1.03 | 1.03 | 1.03 | 1.03 | 1.03
Revenue 4 |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Revenue 5 |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Revenue 6 |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
EXPENSE PROJECTIONS ($000)
 |  |  |  |  |  | Projected Fiscal Year Ending December 31,
 |  |  | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011
 |  |  |  |  | Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
OPERATING EXPENSES | 1=On, 0=Off
Operation and Maintenance | 1 |  | 213000 | 191000 | 211000
Expense 2 | 0 |  | 0 | 0 | 0 | 0
Expense 3 | 0 |  | 0 | 0 | 0 | 0
Expense 4 | 0 |  | 0 | 0 | 0 | 0
Expense 5 | 0 |  | 0 | 0 | 0 | 0
TOTAL OPERATING EXPENSES
GROWTH RATES
Operation and Maintenance |  |  |  |  |  |  | 1.025 | 1.025 | 1.025 | 1.025 | 1.025 | 1.025 | 1.025 | 1.025 | 1.025 | 1.025
Expense 2 |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Expense 3 |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Expense 4 |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Expense 5 |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
OTHER INCOME PROJECTIONS ($000'S)
 |  |  |  |  |  | Projected Fiscal Year Ending December 31,
 |  |  | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011
 |  |  |  |  | Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
OTHER INCOME | 1=On, 0=Off
Other Net Income | 1 |  | 24000 | 6000 | 8000
Other Income 2 | 0 |  | 0 | 0 | 0 | 0
Other Income 3 | 0 |  | 0 | 0 | 0 | 0
TOTAL OTHER INCOME
GROWTH RATES
Other Net Income |  |  |  |  |  |  | 1.01 | 1.01 | 1.01 | 1.01 | 1.01 | 1.01 | 1.01 | 1.01 | 1.01 | 1.01
Other Income 2 |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Other Income 3 |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
DEPRECIATION PROJECTIONS ($000'S)
 |  |  |  |  |  | Projected Fiscal Year Ending December 31,
 |  |  | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011
 |  |  |  |  | Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
Book Depreciation
Depreciable Portion of Existing PP&E Book Value
Depreciable Portion of Existing Intangible Assets
Capital Expenditures
Total Book Depreciation
Tax Depreciation |  |  |  |  |  |  | 0.045 | 0.045 | 0.045 | 0.045 | 0.045 | 0.045 | 0.045 | 0.045 | 0.045 | 0.045
Depreciable Portion based on Purchase Price
Other Depreciable Item |  |  |  |  |  |  | 0
Capital Expenditures
Total Tax Depreciation
TAX PROJECTIONS ($000'S)
 |  |  |  |  |  | Projected Fiscal Year Ending December 31,
 |  |  | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011
 |  |  |  |  | Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
Current Income Taxes
Deferred Taxes
Total Taxes