Spreadsheet: kevin_hyatt__19602__ARC
Sheet: Inputs

[NAME] |  |  | PROJECT DESCRIPTION:
Sun Devil Project - Sun Devil Project
ASSUMPTIONS
PROJECT CONTRACT TERM | 30
PROJECT LIFE (1-15) | 30
TAX LIFE | 15
INSERVICE DATE | 2004-09-30 00:00:00
INVESTMENT(000'S) | Equity
CONSTRUCTION & ROW | 802547.0834771999
AFUDC | 87611.9217564
OVERHEAD | 21515.5187664
CONTINGENCY | 0
REIMBURSEMENT (000'S) | 0
TOTAL INVESTMENT | 911674.524
CAPITAL REQUIREMENTS | 911674.524 |  |  |  |  | Incremental
 |  | Design Rated HP | Site Rated HP | Required HP | BTU/bhphr | Fuel
HP INSTALLED | 0 | 152500 | 97690 | 97690 | 8300 | 19.459848
HP INSTALLED |  | 0 | 12000 | 12000 | 7300 | 2.1024
Incremental HP & Fuel |  |  | 85690 | 85690 |  | 17.357448
FUEL USAGE(MMBTU/day)
KW/BHPHR | 0.829 |  | 0 | 0
FUEL USAGE(Kw/day) |  |  |  | 0
[NAME] OF PIPE | 489.62
BTU FACTOR | 1
O & M ESCALATORS | 1.03
Economic Analysis DEPRECIATION | 0.03333333333333333
BOOK DEPRECIATION | 0.012
INCOME TAX RATE | 0.3888
AD VALOREM RATE | 0.02
Capital Average | 191742.2731724732
 |  | YEAR
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
LOAD FACTOR |  | 0.908126025937521 | 0.8986569070508079 | 0.8961404321220501 | 0.9005536107475564 | 0.9000216335309562 | 0.8955118645439285 | 0.9006675031410439 | 0.9054908059880229 | 0.8775439239400953 | 0.9010914777917424 | 0.8803640763943598 | 0.8988862911663256 | 0.9033238148043167 | 0.9142125920525557 | 0.8787360616928287 | 0.8787360616928287 | 0.8787360616928287 | 0.8787360616928287 | 0.8787360616928287 | 0.8787360616928287 | 0.8787360616928287 | 0.8787360616928287 | 0.8787360616928287 | 0.8787360616928287 | 0.8787360616928287 | 0.8787360616928287 | 0.8787360616928287 | 0.8787360616928287 | 0.8787360616928287 | 0.8787360616928287
COMPRESSOR [NAME] (MMMBTU/D) (100%) |  | 15.76275027265717 | 15.59839053397523 | 15.55471095125601 | 15.63131246976295 | 15.62207870288863 | 15.54380062220428 | 15.63328935106051 | 15.7170095794152 | 15.23192302750616 | 15.64064846901332 | 15.28087367708313 | 15.60237205683236 | 15.67939614262756 | 15.86839752749745 | 15.25261549655807 | 15.25261549655807 | 15.25261549655807 | 15.25261549655807 | 15.25261549655807 | 15.25261549655807 | 15.25261549655807 | 15.25261549655807 | 15.25261549655807 | 15.25261549655807 | 15.25261549655807 | 15.25261549655807 | 15.25261549655807 | 15.25261549655807 | 15.25261549655807 | 15.25261549655807
Unaccounted For Gas |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
GAS PRICE |  | 2.293439330615752 | 2.914433122102406 | 2.976644545687122 | 3.041131518504033 | 2.696403440288524 | 2.978191711610904 | 3.484672035263864 | 3.43222530284295 | 3.125883058202048 | 3.350319025732492 | 4.057012853084715 | 3.894749183816807 | 3.419618585851675 | 3.838458820591722 | 3.926628267512712 | 3.926628267512712 | 3.926628267512712 | 3.926628267512712 | 3.926628267512712 | 3.926628267512712 | 3.926628267512712 | 3.926628267512712 | 3.926628267512712 | 3.926628267512712 | 3.926628267512712 | 3.926628267512712 | 3.926628267512712 | 3.926628267512712 | 3.926628267512712 | 3.926628267512712
ELECTRIC RATE |  | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04 | 0.04
EXPENSES:
ADMINISTRATIVE AND GENERAL EXPENSES |  | 11124.025 | 11457.74575 | 11801.4781225 | 12155.522466175 | 12520.18814016025
O&M (CALCULATED =1,INPUT =2) |  | 2692.922 | 2773.70966 | 2856.9209498 | 2942.628578294 | 3030.90743564282 | 14297.08862373682
FUEL EXPENSE |  | 13195.08267340494 | 16593.07009865271 | 16899.80861217052 | 17350.96011499415 | 15375.05076700835 | 79413.97226623066
AD VALOREM |  | 18233.49048 | 18780.4951944 | 19343.910050232 | 19924.22735173897 | 20521.95417229113 | 96804.07724866211
Tax Depreciation Code | 15
TAX DEPRECIATION 3Yrs | 0.33333 | 0.4445 | 0.1481 | 0.0741 | 0
TAX DEPRECIATION 5Yrs | 0.2 | 0.32 | 0.192 | 0.1152 | 0.1152 | 0.0576
TAX DEPRECIATION 7Yrs | 0.1429 | 0.2449 | 0.1749 | 0.1249 | 0.0893 | 0.0892 | 0.0893 | 0.0446
TAX DEPRECIATION 15Yrs | 0.05 | 0.095 | 0.0855 | 0.077 | 0.0693 | 0.0623 | 0.059 | 0.059 | 0.0591 | 0.059 | 0.0591 | 0.059 | 0.0591 | 0.059 | 0.0591 | 0.0295