Spreadsheet: kevin_hyatt__19602__ARC
Sheet: Earnings

[NAME]
Sun Devil Project - Sun Devil Project
EARNINGS ANALYSIS ([NAME])
 | Days | 92
 |  | 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
 |  | 38261 | 38627 | 38993 | 39359 | 39725 | 40091 | 40457 | 40823 | 41189 | 41555 | 41921 | 42287 | 42653 | 43019 | 43385 | 43751 | 44117 | 44483 | 44849 | 45215 | 45581 | 45947 | 46313 | 46679 | 47045 | 47411 | 47777 | 48143 | 48509 | 48875 | TOTAL
REVENUES
TRANSPORTATION |  | 174353.2033063844 | 172465.0926774743 | 168327.2112328257 | 164983.825087321 | 161053.9575028307 | 157865.0045102903 | 154830.4957339613 | 152245.5083559836 | 148859.4418044972 | 145928.6329211262 | 143030.7920277257 | 140558.4445638695 | 137353.2188165457 | 134575.786137129 | 132929.071709414 | 132777.0923446417 | 131943.3303220869 | 131517.4357209631 | 131137.982254856 | 131164.7367555086 | 130524.0134609151 | 130292.4112461576 | 130113.0789380077 | 130343.715002523 | 129917.5434732396 | 129904.6190510532 | 129950.5248692515 | 130413.3464537723 | 130225.939802865 | 130459.1391627688 | 4250044.595245988
AFUDC |  | 87611.9217564 | 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 | 87611.9217564
TOTAL REVENUES |  | 261965.1250627844 | 172465.0926774743 | 168327.2112328257 | 164983.825087321 | 161053.9575028307 | 157865.0045102903 | 154830.4957339613 | 152245.5083559836 | 148859.4418044972 | 145928.6329211262 | 143030.7920277257 | 140558.4445638695 | 137353.2188165457 | 134575.786137129 | 132929.071709414 | 132777.0923446417 | 131943.3303220869 | 131517.4357209631 | 131137.982254856 | 131164.7367555086 | 130524.0134609151 | 130292.4112461576 | 130113.0789380077 | 130343.715002523 | 129917.5434732396 | 129904.6190510532 | 129950.5248692515 | 130413.3464537723 | 130225.939802865 | 130459.1391627688 | 4337656.517002388
EXPENSES
ADMINISTRATIVE & GENERAL |  | 11124.025 | 11457.74575 | 11801.4781225 | 12155.522466175 | 12520.18814016025 | 12895.79378436506 | 13282.66759789601 | 13681.14762583289 | 14091.58205460788 | 14514.32951624612 | 14949.7594017335 | 15398.25218378551 | 15860.19974929907 | 16336.00574177804 | 16826.08591403138 | 17330.86849145233 | 17850.7945461959 | 18386.31838258177 | 18937.90793405923 | 19506.045172081 | 20091.22652724343 | 20693.96332306073 | 21314.78222275255 | 21954.22568943513 | 22612.85246011819 | 23291.23803392173 | 23989.97517493938 | 24709.67443018757 | 25450.96466309319 | 26214.49360298599 | 529230.1137025189
O & M |  | 2692.922 | 2773.70966 | 2856.9209498 | 2942.628578294 | 3030.90743564282 | 3121.834658712105 | 3215.489698473468 | 3311.954389427673 | 3411.313021110503 | 3513.652411743818 | 3619.061984096133 | 3727.633843619017 | 3839.462858927588 | 3954.646744695415 | 4073.286147036278 | 4195.484731447366 | 4321.349273390788 | 4450.989751592511 | 4584.519444140286 | 4722.055027464495 | 4863.71667828843 | 5009.628178637083 | 5159.917023996195 | 5314.714534716081 | 5474.155970757564 | 5638.380649880291 | 5807.532069376701 | 5981.758031458002 | 6161.210772401742 | 6346.047095573795 | 128116.8836147001
LOAN INTEREST EXPENSE |  | 54700.47143999999 | 50286.71774974212 | 47367.32350373003 | 44626.51809189882 | 42047.49315338441 | 39615.54137243074 | 37252.9240800414 | 34890.30678765206 | 32525.58845015471 | 30162.97115776538 | 27798.25282026803 | 25435.6355278787 | 23070.91719038135 | 20708.29989799202 | 18965.49091246576 | 17842.49023380256 | 16719.48955513936 | 15596.48887647616 | 14473.48819781297 | 13350.48751914976 | 12227.48684048657 | 11104.48616182337 | 9981.485483160171 | 8858.484804496973 | 7735.484125833775 | 6612.483447170577 | 5489.482768507379 | 4366.48208984418 | 3243.481411180981 | 2120.480732517783 | 679176.734383188
AD VALOREM |  | 18233.49048 | 18780.4951944 | 19343.910050232 | 19924.22735173897 | 20521.95417229113 | 21137.61279745987 | 21771.74118138366 | 22424.89341682517 | 23097.64021932993 | 23790.56942590983 | 24504.28650868712 | 25239.41510394774 | 25996.59755706617 | 26776.49548377816 | 27579.7903482915 | 28407.18405874025 | 29259.39958050246 | 30137.18156791753 | 31041.29701495506 | 31972.53592540371 | 32931.71200316582 | 33919.66336326079 | 34937.25326415861 | 35985.37086208337 | 37064.93198794587 | 38176.87994758425 | 39322.18634601177 | 40501.85193639213 | 41716.90749448389 | 42968.41471931841 | 867465.8893632654
NET FUEL |  | -20761.76985295006 | -20990.38442431493 | -18558.89943207804 | 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 | -60311.05370934303
BOOK DEPRECIATION |  | 30389.1508 | 30389.1508 | 30389.1508 | 30389.1508 | 30389.1508 | 30389.1508 | 30389.1508 | 30389.1508 | 30389.1508 | 30389.1508 | 30389.1508 | 30389.1508 | 30389.1508 | 30389.1508 | 30389.1508 | 30389.1508 | 30389.1508 | 30389.1508 | 30389.1508 | 30389.1508 | 30389.1508 | 30389.1508 | 30389.1508 | 30389.1508 | 30389.1508 | 30389.1508 | 30389.1508 | 30389.1508 | 30389.1508 | 30389.1508 | 911674.5239999993
TOTAL EXPENSES |  | 96378.28986704993 | 92697.43472982719 | 93199.88399418398 | 110038.0472881068 | 108509.6937014786 | 107159.9334129678 | 105911.9733577945 | 104697.4530197378 | 103515.274545203 | 102370.6733116651 | 101260.5115147848 | 100190.087459231 | 99156.32815567419 | 98164.59866824363 | 97833.80412182493 | 98165.17831544249 | 98540.1837552285 | 98960.12937856797 | 99426.36339096754 | 99940.27444409898 | 100503.2928491842 | 101116.891826782 | 101782.5887940675 | 102501.9466907316 | 103276.5753446554 | 104108.1328785568 | 104998.3271588352 | 105948.9172878819 | 106961.7151411598 | 108038.586950396 | 3055353.09135433
TAXABLE INCOME |  | 165586.8351957345 | 79767.65794764712 | 75127.3272386417 | 54945.77779921416 | 52544.26380135206 | 50705.07109732254 | 48918.52237616671 | 47548.05533624582 | 45344.16725929422 | 43557.95960946106 | 41770.28051294092 | 40368.3571046385 | 38196.89066087149 | 36411.18746888534 | 35095.26758758909 | 34611.91402919922 | 33403.14656685843 | 32557.30634239514 | 31711.61886388843 | 31224.46231140963 | 30020.72061173088 | 29175.5194193756 | 28330.49014394013 | 27841.76831179141 | 26640.96812858419 | 25796.48617249631 | 24952.19771041629 | 24464.42916589045 | 23264.22466170519 | 22420.5522123728 | 1282303.425648059
INCOME TAX |  | 64380.16152410158 | 31013.6654100452 | 29209.50483038389 | 21362.91840833447 | 20429.20976596568 | 19714.131642639 | 19019.52149985362 | 18486.68391473237 | 17629.81223041359 | 16935.33469615846 | 16240.28506343143 | 15695.21724228345 | 14850.95108894683 | 14156.66968790262 | 13645.04003805464 | 13457.11217455266 | 12987.14338519456 | 12658.28070592323 | 12329.47741427982 | 12140.07094667606 | 11672.05617384097 | 11343.44195025323 | 11014.89456796392 | 10824.8795196245 | 10358.00840839353 | 10029.67382386657 | 9701.414469809855 | 9511.770059698209 | 9045.130548470976 | 8717.110700170544 | 498559.5718919654
NET INCOME PER ECONOMIC ANAL. |  | 101206.6736716329 | 48753.99253760192 | 45917.82240825781 | 33582.8593908797 | 32115.05403538638 | 30990.93945468354 | 29899.0008763131 | 29061.37142151344 | 27714.35502888063 | 26622.6249133026 | 25529.99544950949 | 24673.13986235506 | 23345.93957192465 | 22254.51778098272 | 21450.22754953445 | 21154.80185464657 | 20416.00318166387 | 19899.02563647191 | 19382.14144960861 | 19084.39136473357 | 18348.66443788991 | 17832.07746912237 | 17315.59557597621 | 17016.88879216691 | 16282.95972019066 | 15766.81234862975 | 15250.78324060644 | 14952.65910619225 | 14219.09411323421 | 13703.44151220226 | 783743.8537560939
Book Analysis
EXPENSES
ADMINISTRATIVE & GENERAL |  | 11124.025 | 11457.74575 | 11801.4781225 | 12155.522466175 | 12520.18814016025 | 12895.79378436506 | 13282.66759789601 | 13681.14762583289 | 14091.58205460788 | 14514.32951624612 | 14949.7594017335 | 15398.25218378551 | 15860.19974929907 | 16336.00574177804 | 16826.08591403138 | 17330.86849145233 | 17850.7945461959 | 18386.31838258177 | 18937.90793405923 | 19506.045172081 | 20091.22652724343 | 20693.96332306073 | 21314.78222275255 | 21954.22568943513 | 22612.85246011819 | 23291.23803392173 | 23989.97517493938 | 24709.67443018757 | 25450.96466309319 | 26214.49360298599 | 529230.1137025189
O & M |  | 678.7639013698631 | 2773.70966 | 2856.9209498 | 2942.628578294 | 3030.90743564282 | 3121.834658712105 | 3215.489698473468 | 3311.954389427673 | 3411.313021110503 | 3513.652411743818 | 3619.061984096133 | 3727.633843619017 | 3839.462858927588 | 3954.646744695415 | 4073.286147036278 | 4195.484731447366 | 4321.349273390788 | 4450.989751592511 | 4584.519444140286 | 4722.055027464495 | 4863.71667828843 | 5009.628178637083 | 5159.917023996195 | 5314.714534716081 | 5474.155970757564 | 5638.380649880291 | 5807.532069376701 | 5981.758031458002 | 6161.210772401742 | 6346.047095573795 | 126102.72551607
LOAN INTEREST EXPENSE |  | 54700.47143999999 | 50286.71774974212 | 47367.32350373003 | 44626.51809189882 | 42047.49315338441 | 39615.54137243074 | 37252.9240800414 | 34890.30678765206 | 32525.58845015471 | 30162.97115776538 | 27798.25282026803 | 25435.6355278787 | 23070.91719038135 | 20708.29989799202 | 18965.49091246576 | 17842.49023380256 | 16719.48955513936 | 15596.48887647616 | 14473.48819781297 | 13350.48751914976 | 12227.48684048657 | 11104.48616182337 | 9981.485483160171 | 8858.484804496973 | 7735.484125833775 | 6612.483447170577 | 5489.482768507379 | 4366.48208984418 | 3243.481411180981 | 2120.480732517783 | 679176.734383188
AD VALOREM |  | 18233.49048 | 18780.4951944 | 19343.910050232 | 19924.22735173897 | 20521.95417229113 | 21137.61279745987 | 21771.74118138366 | 22424.89341682517 | 23097.64021932993 | 23790.56942590983 | 24504.28650868712 | 25239.41510394774 | 25996.59755706617 | 26776.49548377816 | 27579.7903482915 | 28407.18405874025 | 29259.39958050246 | 30137.18156791753 | 31041.29701495506 | 31972.53592540371 | 32931.71200316582 | 33919.66336326079 | 34937.25326415861 | 35985.37086208337 | 37064.93198794587 | 38176.87994758425 | 39322.18634601177 | 40501.85193639213 | 41716.90749448389 | 42968.41471931841 | 867465.8893632654
NET FUEL |  | -20761.76985295006 | -20990.38442431493 | -18558.89943207804 | 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 | -60311.05370934303
BOOK DEPRECIATION |  | 10940.094288 | 10940.094288 | 10940.094288 | 10940.094288 | 10940.094288 | 10940.094288 | 10940.094288 | 10940.094288 | 10940.094288 | 10940.094288 | 10940.094288 | 10940.094288 | 10940.094288 | 10940.094288 | 10940.094288 | 10940.094288 | 10940.094288 | 10940.094288 | 10940.094288 | 10940.094288 | 10940.094288 | 10940.094288 | 10940.094288 | 10940.094288 | 10940.094288 | 10940.094288 | 10940.094288 | 10940.094288 | 10940.094288 | 10940.094288 | 328202.82864
TOTAL EXPENSES |  | 74915.07525641978 | 73248.3782178272 | 73750.82748218399 | 90588.9907761068 | 89060.63718947861 | 87710.87690096776 | 86462.91684579453 | 85248.39650773781 | 84066.21803320301 | 82921.61679966515 | 81811.45500278479 | 80741.03094723096 | 79707.27164367418 | 78715.54215624364 | 78384.74760982493 | 78716.12180344248 | 79091.12724322849 | 79511.07286656796 | 79977.30687896753 | 80491.21793209898 | 81054.23633718424 | 81667.83531478196 | 82333.53228206752 | 83052.89017873156 | 83827.51883265539 | 84659.07636655684 | 85549.27064683524 | 86499.86077588188 | 87512.65862915982 | 88589.53043839597 | 2469867.237895699
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
TAXABLE INCOME |  | 187050.0498063647 | 99216.71445964712 | 94576.38375064169 | 74394.83431121416 | 71993.32031335207 | 70154.12760932255 | 68367.57888816672 | 66997.11184824581 | 64793.22377129423 | 63007.01612146106 | 61219.33702494093 | 59817.41361663851 | 57645.9471728715 | 55860.24398088534 | 54544.32409958908 | 54060.97054119923 | 52852.20307885844 | 52006.36285439515 | 51160.67537588844 | 50673.51882340963 | 49469.77712373089 | 48624.57593137561 | 47779.54665594014 | 47290.82482379142 | 46090.0246405842 | 45245.54268449632 | 44401.25422241629 | 43913.48567789045 | 42713.28117370518 | 41869.60872437281 | 1867789.279106689
INCOME TAX |  | 72725.05936471457 | 38575.4585819108 | 36771.29800224949 | 28924.71158020006 | 27991.00293783128 | 27275.9248145046 | 26581.31467171922 | 26048.47708659797 | 25191.60540227919 | 24497.12786802406 | 23802.07823529703 | 23257.01041414905 | 22412.74426081244 | 21718.46285976822 | 21206.83320992023 | 21018.90534641826 | 20548.93655706016 | 20220.07387778883 | 19891.27058614543 | 19701.86411854166 | 19233.84934570657 | 18905.23512211884 | 18576.68773982953 | 18386.6726914901 | 17919.80158025914 | 17591.46699573217 | 17263.20764167545 | 17073.56323156381 | 16606.92372033657 | 16278.90387203615 | 726196.4717166808
NET INCOME PER BOOK |  | 114324.9904416501 | 60641.25587773632 | 57805.0857483922 | 45470.1227310141 | 44002.31737552079 | 42878.20279481795 | 41786.2642164475 | 40948.63476164785 | 39601.61836901504 | 38509.888253437 | 37417.2587896439 | 36560.40320248946 | 35233.20291205906 | 34141.78112111712 | 33337.49088966884 | 33042.06519478097 | 32303.26652179828 | 31786.28897660632 | 31269.40478974302 | 30971.65470486796 | 30235.92777802432 | 29719.34080925678 | 29202.85891611061 | 28904.15213230132 | 28170.22306032507 | 27654.07568876415 | 27138.04658074084 | 26839.92244632664 | 26106.35745336861 | 25590.70485233666 | 1141592.807390009
Fuel Volumes(MMBtu/d) |  | 15.61914588989842 | 15.62106469049117 | 15.61952679500981 | 15.62135135019073 | 15.61717185151639 | 15.61821404323971 | 15.62117393548491 | 15.61651918838444 | 15.62631084697068 | 15.61562012614927 | 15.62287665744184 | 15.61654789228437 | 15.61909025836728 | 15.62981470575311 | 15.62264648196486 | 15.62264648196486 | 15.62264648196486 | 15.62264648196486 | 15.62264648196486 | 15.62264648196486 | 15.62264648196486 | 15.62264648196486 | 15.62264648196486 | 15.62264648196486 | 15.62264648196486 | 15.62264648196486 | 15.62264648196486 | 15.62264648196486 | 15.62264648196486 | 15.62264648196486
Fuel Price (AVG) |  | 3.009898321735444 | 3.118051372247479 | 3.196340187391574 | 3.294005660154142 | 3.374592197893298 | 3.473533714659979 | 3.579792000345599 | 3.671983932090848 | 3.770767910186638 | 3.905367008065779 | 3.984640530410684 | 4.087846888493383 | 4.214583579966715 | 4.342927084201502 | 4.439168560564781 | 4.567517669877332 | 4.67159107352535 | 4.802527693658954 | 4.90195815182652 | 5.05844448314716 | 5.169348871532391 | 5.169348871532391 | 5.169348871532391 | 5.169348871532391 | 5.169348871532391 | 5.169348871532391 | 5.169348871532391 | 5.169348871532391 | 5.169348871532391 | 5.169348871532391
Fuel Price (P5) |  | 2.541902333119489 | 2.642573912138536 | 2.708326813430088 | 2.825644655213321 | 2.907542525909076 | 2.970510176903063 | 3.087612161413503 | 3.171809425659186 | 3.242212118602914 | 3.37785669558053 | 3.461238212727634 | 3.561033008621192 | 3.659273921133489 | 3.783685072341586 | 3.878829480741194 | 4.007897296729987 | 4.144178674205929 | 4.230383037505404 | 4.353965017759472 | 4.474377469443391 | 4.544495035716779 | 4.544495035716779 | 4.544495035716779 | 4.544495035716779 | 4.544495035716779 | 4.544495035716779 | 4.544495035716779 | 4.544495035716779 | 4.544495035716779 | 4.544495035716779
Fuel Price (P95) |  | 3.512313217280667 | 3.604770998153709 | 3.709475818341409 | 3.792395587434102 | 3.884421920772966 | 3.998681230973047 | 4.136232032156539 | 4.226919818787995 | 4.311570062180423 | 4.450662666350099 | 4.555964899222159 | 4.666317428750078 | 4.80751528877687 | 4.946053547843531 | 5.036709828425066 | 5.160872037770492 | 5.275324443228739 | 5.394161692897804 | 5.504285312081537 | 5.711891652867675 | 5.797430383414181 | 5.797430383414181 | 5.797430383414181 | 5.797430383414181 | 5.797430383414181 | 5.797430383414181 | 5.797430383414181 | 5.797430383414181 | 5.797430383414181 | 5.797430383414181