Spreadsheet: tracy_geaccone__40395__NNG3rdCEEM
Sheet: Source

PRINT: PAGE1
 |  |  |  |  |  | SCHEDULE OF LINKED DATA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rounding
FILE NAME |  |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC |  |  |  |  | Check #
Transport | Rate Case Impact (Higher Rates)
Sales | Total Gas Sales Revenue (w/o [NAME])
Transport | "   Transport        "         "           "
OtherRev | "    Liquids          "         "           "
OtherRev | "     Other           "         "           "
TC&S | SBA Expense (Both Demand & Commodity)
 | Blank (Was Total Producers & Pipelines) | No Link | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Blank (Was All Liquids Only (NO TRANSPORT)) | No Link | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
OtherInc | Stranded 858 (All) Carrying Charges
OtherInc | Stranded 858 R.A. Carrying Charges
IntDeduct | Reverse Auction 1 Carrying Charges
 | Blank (Formerly PGA Carrying Charges) | No Link | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
OtherInc | GSR Carrying Charges
TC&S | SBA Tracker Adjustment
TC&S | Carlton Resolution Tracker / Discount Adj. (Surch./Costs-Net)
RegAmort | Order 528 Tracker Adjustment (Surcharge / Costs - Net)
OtherInc | Order 528 Carrying Charges
TC&S | Stranded 858 (ANR Buyout) [NAME]. (Surc. / Costs - Net)
TC&S | Stranded 858 (Normal) Tracker Adjust. (Surc. / Costs - Net)
DeferredTax | Regulatory Commission Expense
TC&S | Stranded 858 R.A. Tracker Adjust. (Surcharge / Costs - Net)
RegAmort | FAS 106 Deferral / Amortization
RegAmort | Severance & Relocation Amortization
RegAmort | Uncollectible Accounts Amortization
RegAmort | IMP Amortization
RegAmort | ACA Amortization
TC&S | Total 858 & 858 R.A. Expense Only
OtherInc | AFUDC Equity Gross-Up / Amortization
 | Blank | No Link | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FuelDeprTax | Depreciation - PP&E
FuelDeprTax | Amortization - PP&E
FuelDeprTax | Total Depreciation &  Amortization Per Income Statement
FuelDeprTax | Payroll Taxes Only
FuelDeprTax | Total Taxes Other Than Income (Including Payroll)
DeferredTax | PRA (Gain) / Loss on Fuel / UAF Deferral
OtherInc | Total Partnership Income
DeferredTax | Reserve Issues - Rate Case Only
DeferredTax | Other Reserve Issues - Building / Reserve
DeferredTax | - All Remaining Other Reserve Items
IntDeduct | Amortized Loss on Reacquired Debt
IntDeduct | Amortized (Gain) on Reacquired Debt
DeferredTax | ACA Payment
DeferredTax | Kansas Ad Valorem Tax Issue
DeferredTax | Payable Currently (w/o Non-Cash Adjustments)
DeferredTax | Deferred Taxes - Current
DeferredTax | - Noncurrent
DeferredTax | Total Deferred Taxes
IncomeState | Total Income Taxes (w/o Capital Costs Component)
IncomeState | Net Income Before Capital Costs
RegAmort | South Georgia Adjustment
Trackers | GSR R.A. (Expense)
RegAmort | 2223 Dodge Street Amortization
RegAmort | Fuel / UAF Amortization (Pre PRA)
FuelDeprTax | Pipe Recoating
RegAmort | Equivalent Unit Risk Data (SLA Cash Component Only)
Trackers | GSR R.A. Assumed Collections
IntDeduct | GSR R.A. Carrying Charges
OtherInc/Ded. | Carlton Resolution Carrying Charges
IntDeduct | Reverse Auction 2 Carrying Charges
Trackers | [NAME]
Transport | Reverse Auction 1 - Direct Bill Revenue
Trackers | - Expense Payment (Annual)
Transport | Reverse Auction 2 - Direct Bill Revenue
TC&S | - Expense Payment (Annual)
Transport | Reverse Auction 3 - Direct Bill Revenue
TC&S | - Expense Payment (Annual)
IntDeduct | Reverse Auction 3 Carrying Charges
 | CONTROL TOTAL