Spreadsheet: tracy_geaccone__40281__EMNNG01CE
Sheet: Fuel-Depr-OtherTax

PRINT: PRINT
 |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
 |  |  |  |  | 0
FUEL EXPENSE
Fuel / UAF Net Retained |  | 83 | 48 | 31 | 35 | 44 | 37 | 40 | 0 | 0 | 0 | 0 | 0
Fuel Used |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Hyperion Entry / Reversal |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL FUEL EXPENSE
DEPRECIATION & AMORTIZATION
Depreciation - Plant |  | 2636 | 2579 | 2650 | 2625 | 2564 | 2776 | 2779 | 2780 | 2879 | 3080 | 3571 | 3573
- Rate Case Impact |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
- Lucent Phone System (1/99 - 12/08) |  | 96 | 96 | 96 | 96 | 96 | 95 | 96 | 96 | 96 | 96 | 96 | 95
- Other |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
- Other |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
- Other |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Amortization - Plant |  | 539 | 654 |  | 471 | 520
- TBPL Monetization Goodwill (FVA $21,764 over 63 Yrs.) |  | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28
- IMP (Straight Line Impact, [NAME] in [NAME]. Amort.) |  | 491 | 491 | 491 | 491 | 491 | 491 | 492 | 492 | 492 | 492 | 0 | 0
- Pipe Recoating | Link D.T. | 23 | -23 |  |  | 28 | 27 | 23 | 22 | 23 | 22 | 23 | 22
- Black Marlin Fair Value Amortization |  | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26
- Other |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
Hyperion Entry / Reversal |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL DEPRECIATION & AMORTIZATION
TAXES OTHER THAN INCOME
Ad Valorem - NNG Accrual |  | 2284 | 2284 | 2284 | 2284 | 2284 | 2284 | 2284 | 2284 | 2284 | 2284 | 2284 | 2284
- Black Marlin Ad Valorem Taxes
- Other |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
- Other |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Payroll Taxes (FICA / FUTA / SUTA / Medical)
Commercial |  |  |  |  |  |  |  | 33 | 33 | 34 | 33 | 33 | 34
Market Services |  |  |  |  |  |  |  | 33 | 33 | 34 | 33 | 33 | 34
Operations |  |  |  |  |  |  |  | 266 | 267 | 267 | 266 | 267 | 267
Finance, Accounting and Administration |  |  |  |  |  |  |  | 33 | 33 | 34 | 33 | 33 | 34
Other (Variable Pay Only) |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FI/CO Reconciliation Adjustment |  | -93 | -46 | 0 | 10 | 14 | -13 | 0 | 0 | 0 | 0 | 0
Information Technology |  |  |  |  |  |  |  | 33 | 33 | 34 | 33 | 33 | 34
Legal |  |  |  |  |  |  |  | 2 | 2 | 1 | 2 | 1 | 1
HR / Communications |  |  |  |  |  |  |  | 4 | 3 | 3 | 4 | 4 | 3
Executive |  |  |  |  |  |  |  | 5 | 5 | 4 | 5 | 5 | 4
Pre Functional Payroll Taxes (From Plan) |  |  |  | 0
Miscellaneous - Franchise Taxes |  | 3 | 3 | 3 | 18 | 3 | 3 | 15 | 15 | 15 | 15 | 15 | 15
- Other |  | 76 | 63 | 5 | 11 | 11 | 25 | 0 | 0 | 0 | 0 | 0 | 0
- Other |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Hyperion Entry / Reversal |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL TAXES OTHER THAN INCOME
 |  | 2907 | 3202 | 2707 | 2710 | 2704 | 2721
PAYROLL TAX PERCENTAGE USED IN PLAN |  | 0.1 | 0.1 | 0.085 | 0.085 | 0.08 | 0.08 | 0.08 | 0.08 | 0.077 | 0.077 | 0.077 | 0.077