Spreadsheet: kevin_hyatt__19605__sundevilrateanal
Sheet: Sheet1

 |  | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
Equity Percentage
INVESTMENT | 1 | 842999.618
CONSTRUCTION & ROW |  | 742092.5637254
AFUDC |  | 81012.2632898
OVERHEAD |  | 19894.7909848
CONTINGENCY |  | 0
REIMBURSEMENT |  | 0
CAPITAL REQUIREMENTS |  | 337199.8472
Capital Cost for future project |  | 0
TAX DEPRECIATION CALC:
BALANCE |  |  | 842999.618 | 800849.6371 | 720764.67339 | 648688.206051 | 583777.235465 | 525357.3619376001 | 472838.4857362001 | 423101.5082742001 | 373364.5308122001 | 323543.2533884001 | 273806.2759264001 | 223984.9985026001 | 174248.0210406001 | 124426.7436168001 | 74689.76615480009 | 24868.48873100009 | 9.458744898438454e-11 | 9.458744898438454e-11 | 9.458744898438454e-11 | 9.458744898438454e-11
PREMATURE DEPR EXP |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9.458744898438454e-11
NORMAL  DEPRECIATION EXP |  |  | 42149.9809 | 80084.96371 | 72076.46733900001 | 64910.970586 | 58419.8735274 | 52518.8762014 | 49736.977462 | 49736.977462 | 49821.2774238 | 49736.977462 | 49821.2774238 | 49736.977462 | 49821.2774238 | 49736.977462 | 49821.2774238 | 24868.488731 | 0 | 0 | 0 | 0
DEPRECIATION EXP |  |  | 42149.9809 | 80084.96371 | 72076.46733900001 | 64910.970586 | 58419.8735274 | 52518.8762014 | 49736.977462 | 49736.977462 | 49821.2774238 | 49736.977462 | 49821.2774238 | 49736.977462 | 49821.2774238 | 49736.977462 | 49821.2774238 | 24868.488731 | 0 | 0 | 0 | 0
LOAD FACTOR |  |  | 0.908126025937521 | 0.8986569070508079 | 0.8961404321220501 | 0.9005536107475564 | 0.9000216335309562 | 0.8955118645439285 | 0.9006675031410439 | 0.9054908059880229 | 0.8775439239400953 | 0.9010914777917424 | 0.9010914777917424 | 0.9010914777917424 | 0.9010914777917424 | 0.9010914777917424 | 0.9010914777917424 | 0.9010914777917424 | 0.9010914777917424 | 0.9010914777917424 | 0.9010914777917424 | 0.9010914777917424
COMPRESSOR VOLUMES USED (MMMBTU/D) |  |  | 2.41
GAS PRICE | 1.03 |  | 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.728512626483665 | 4.722242001450496 | 3.744708242214207 | 4.208739899830173 | 4.884545437386734 | 4.333782602972815 | 4.531561165873355
FUEL EXPENSE
EXPENSES: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
ADMINSTRATIVE AND GENERAL |  |  | 10712.02407407407 | 11033.3847962963 | 11364.38634018518 | 11705.31793039074 | 12056.47746830246 | 12418.17179235154 | 12790.71694612208 | 13174.43845450575 | 13569.67160814092 | 13976.76175638515 | 14396.0646090767 | 14827.946547349 | 15272.78494376947 | 15730.96849208256 | 16202.89754684504 | 16688.98447325039 | 17189.6540074479 | 17705.34362767134 | 18236.50393650148 | 18783.59905459653
O&M | 1.03 |  | 726.272 | 748.0601600000001 | 770.5019648000001 | 793.6170237440001 | 817.4255344563202 | 841.9483004900098 | 867.2067495047102 | 893.2229519898515 | 920.019640549547 | 947.6202297660335 | 976.0488366590146 | 1005.330301758785 | 1035.490210811549 | 1066.554917135895 | 1098.551564649972 | 1131.508111589471 | 1165.453354937155 | 1200.41695558527 | 1236.429464252828 | 1273.522348180413
DEPRECIATION | 30
INTEREST EXPENSE | 0.075
NET FUEL EXPENSE
AD VALOREM | 0.02 |  | 16859.99236 | 17365.7921308 | 17886.765894724 | 18423.36887156572 | 18976.06993771269 | 19545.35203584408 | 20131.7125969194 | 20735.66397482698 | 21357.73389407179 | 21998.46591089394 | 22658.41988822076 | 23338.17248486739 | 24038.31765941341 | 24759.46718919581 | 25502.25120487169 | 26267.31874101784 | 27055.33830324838 | 27866.99845234583 | 28703.0084059162 | 29564.09865809369
Return on Equity(Capped at 40% Equity) | 0.15
Income Tax Expense | 0.3888
Total Cost
 | MMBTU/d | Levelized
Rate Requirement to Recover Cost | 400
 | 500
 | 600
 | 700
 | 750
 |  |  | 1 | 0.9082652134423251 | 0.8249456979494325 | 0.7492694804263692 | 0.6805354045652763 | 0.6181066344825398 | 0.5614047542984013 | 0.5099044089903736 | 0.4631284368668244 | 0.4206434485620567 | 0.3820558115913321 | 0.347008003261882 | 0.3151752981488484 | 0.2862627594449123 | 0.2600025063078222 | 0.2361512318872137 | 0.2144879490347081 | 0.1948119428108158 | 0.1769409108181796 | 0.1607092741309533