Spreadsheet: kevin_hyatt__19604__Base Model 111601
Sheet: Pipeline Co BS

 |  |  |  |  | Warning Flags:
Balance Sheet
BALANCE SHEET ($000)
 |  |  |  |  |  | Projected Fiscal Year Ending December 31,
 |  |  | 1998 | 1999 | 2000 | 2001 | Transaction Adjustments |  | 2001PF | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011
 |  |  |  |  | Year | 1 | Additions | Subtractions | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
CURRENT ASSETS
Cash and Equivalents |  |  |  | 0 | 0 | 0 | 310000
Accounts Receivable |  |  |  | 112000 | 140000 | 171000 | 0 | 0
Gas Imbalances - Receivable |  |  |  | 22000 | 71000 | 58000 | 0 | 0
Inventory |  |  |  | 34000 | 21000 | 20000 | 0 | 0
Deferred Income Taxes |  |  |  | 11000 | 12000 | 8000 | 0 | 0
Note Receivables |  |  |  | 85000 | 162000 | 310000 | 0 | -310000
Other Current Assets |  |  |  | 8000 | 21000 | 20000 | 0 | 0
Current Assets 8 |  |  |  | 0 | 0 | 0 | 0 | 0
Current Assets 9 |  |  |  | 0 | 0 | 0 | 0 | 0
Current Assets 10 |  |  |  | 0 | 0 | 0 | 0 | 0
TOTAL CURRENT ASSETS
NON-CURRENT ASSETS
Property, Plant & Equipment @ Cost |  |  |  | 1492000 | 1679000 | 1642000 | 0 | 0
Less Accumulated Depreciation & Amortization |  |  |  | 37000 | 99000 | 120000 | 0 | 0
Construction work-in-progress |  |  |  | 45000 | 20000 | 32000 | 0 | 0
Net Property, Plant & Equipment
Intangible Assets |  |  |  | 774000 | 753000 | 723000 | 0 | 0
Debt Issuance Cost |  |  |  | 11000 | 11000 | 10000 | 0 | 0
Other Non-Current Assets |  |  |  | 1000 | 8000 | 73000 | 0 | 0
Invesments |  |  |  | 2000 | 7000 | 63000 | 0 | 0
Non-Current Assets 9 |  |  |  | 0 | 0 | 0
Non-Current Assets 10 |  |  |  | 0 | 0 | 0
TOTAL NON-CURRENT ASSETS
TOTAL ASSETS
CURRENT LIABILITIES
Accounts Payable |  |  |  | 28000 | 32000 | 42000 | 0 | 0
Gas Imbalances - Payable |  |  |  | 30000 | 56000 | 89000 | 0 | 0
Accrued Taxes |  |  |  | 8000 | 3000 | 6000 | 0 | -6000
Accrued Interest |  |  |  | 29000 | 31000 | 31000 | 0 | -31000
Accrued Liabilities |  |  |  | 30000 | 45000 | 23000 | 0 | -23000
Other Current Liabilities |  |  |  | 79000 | 104000 | 91000 | 0 | 0
Current Liabilities 7 |  |  |  | 0 | 0
Current Liabilities 8 |  |  |  | 0 | 0
Current Liabilities 9 |  |  |  | 0 | 0
Current Liabilities 10 |  |  |  | 0 | 0
TOTAL CURRENT LIABILITIES
NON-CURRENT LIABILITIES
Long-term Debt |  |  |  |  |  |  | 0 | 0
Deferred Income Taxes |  |  |  | 45000 | 134000 | 166000 | 0 | 0
Other |  |  |  | 89000 | 86000 | 89000 | 0 | 0
Non-Current Liabilities 4 |  |  |  | 0 | 0
Non-Current Liabilities 5 |  |  |  | 0 | 0
Non-Current Liabilities 6 |  |  |  | 0 | 0
Non-Current Liabilities 7 |  |  |  | 0 | 0
Non-Current Liabilities 8 |  |  |  | 0 | 0
Non-Current Liabilities 9 |  |  |  | 0 | 0
Non-Current Liabilities 10 |  |  |  | 0 | 0
TOTAL NON-CURRENT LIABILITIES
COMMON EQUITY
Common Stock |  |  |  | 1000 | 1000 | 1000 | 0 | 0
Paid-in Capital |  |  |  | 1127000 | 1127000 | 1277000 | 0 | 0
[NAME] |  |  |  | 0 | -6000 | 3000 | 0 | 0
Common Equity 4 |  |  |  | 0 | 0
Common Equity 5 |  |  |  | 0 | 0
Common Equity 6 |  |  |  | 0 | 0
Common Equity 7 |  |  |  | 0 | 0
Common Equity 8 |  |  |  | 0 | 0
Common Equity 9 |  |  |  | 0 | 0
Common Equity 10 |  |  |  | 0 | 0
TOTAL COMMON EQUITY
TOTAL LIABILITIES & EQUITY
Balance Sheet Check
BALANCE SHEET ASSUMPTIONS
 |  |  |  |  |  | Projected Fiscal Year Ending December 31,
 |  |  | 1998 | 1999 | 2000 | 2001 |  |  | 2001PF | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011
 |  |  |  |  | Year | 1 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
ASSET ASSUMPTIONS
Days Sales in A/R |  |  |  |  |  |  |  |  |  | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120
% of Trans. Revenue as Receivable Gas Imbalance |  |  |  |  |  |  |  |  |  | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4
Days in Receivable Gas Imbalance |  |  |  |  |  |  |  |  |  | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120
Days O&M in Inventory |  |  |  |  |  |  |  |  |  | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45
LIABILITY ASSUMPTIONS
Days Cogs in A/P |  |  |  |  |  |  |  |  |  | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60
% of Trans. Revenue as Payable Gas Imbalance |  |  |  |  |  |  |  |  |  | 0.55 | 0.55 | 0.55 | 0.55 | 0.55 | 0.55 | 0.55 | 0.55 | 0.55 | 0.55
Days in Payable Gas Imbalance |  |  |  |  |  |  |  |  |  | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120
 |  |  |  |  |  | Projected Fiscal Year Ending December 31,
 |  |  | 1998 | 1999 | 2000 | 2001 |  |  | 2001PF | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011
 |  |  |  |  | Year | 1 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
PIPELINE CO DEBT
Term | 10
Interest Rate | 0.075
[NAME]
[NAME]
End Balance |  |  |  | 1094000 | 1193000 | 1192000
Interest Payment