Spreadsheet: kevin_hyatt__19625__Gila River- Ext Financial Stmts Fin Closing Proforma
Sheet: Income Statement

 |  |  |  | 2003-12-31 00:00:00 | 2004-12-31 00:00:00 | 2005-12-31 00:00:00 | 2006-12-31 00:00:00 | 2007-12-31 00:00:00 | 2008-12-31 00:00:00
Total Revenues |  |  |  | 351316.8662211676 | 529529.5383594915 | 564144.8571468539 | 587335.8197488014 | 595959.2406844745 | 598809.1162300378 | 626717.1063617679 | 658846.6508172738 | 665272.6555691982 | 681638.8175822012 | 698349.3606077876 | 715412.0815407005 | 732834.9427943797 | 750864.2462790686 | 769270.9025868386 | 788063.4028836439 | 807250.4166557046 | 826840.7948926293 | 853411.3238365038 | 880835.6967279895 | 909141.3518423433 | 938356.6091837969 | 968510.698819918 | 999633.7901264959 | 1031757.021972211 | 1064912.533873287 | 1099133.498149305 | 1134454.153112333 | 1170909.837322598 | 1208537.024944959 | 831581.7217554757
Cost of Sales:
Delivered Fuel Cost |  |  |  | 179717.1270044171 | 263850.4761246454 | 277427.9711693378 | 285825.1389680036 | 314074.10955195 | 314613.7690238691 | 330009.3012500553 | 349278.5770189447 | 355799.1795710021 | 367073.5445997898 | 378705.911825396 | 390707.669561284 | 403090.5689500181 | 415866.7355381484 | 429048.6812207714 | 442649.31656758 | 456681.9635426045 | 471160.3686302237 | 485632.0286750353 | 500541.6824535351 | 515902.4317871701 | 531727.7666983127 | 548031.5768218839 | 564828.1631502052 | 582132.2501207524 | 599958.9980567729 | 618324.0159710004 | 637243.3747430126 | 656733.6206810711 | 676811.7894795965 | 464996.6481615887
Variable O&M and Chemical Cost |  |  |  | 3950.639528047084 | 6582.89393813774 | 6900.959414694916 | 7083.270288558134 | 7246.867789453553 | 7219.673486740488 | 7540.148748147647 | 7946.473518474004 | 8056.920926228912 | 8274.457791237091 | 8497.86815160049 | 8727.310591693706 | 8962.947977669433 | 9204.947573066507 | 9453.481157539301 | 9708.725148792862 | 9970.860727810268 | 10240.07396746115 | 10516.5559645826 | 10800.50297562632 | 11092.11655596823 | 11391.60370297937 | 11699.17700295981 | 12015.05478203973 | 12339.4612611548 | 12672.62671520598 | 13014.78763651654 | 13366.18690270249 | 13727.07394907545 | 14097.70494570049 | 9652.222620180026
Start and Stop Cost |  |  |  | 552.2149515594293 | 831.9110703441868 | 846.1462076866432 | 844.3665182420035 | 1002.469692858796 | 1035.152108631655 | 1067.405987841347 | 1100.385537419034 | 1135.678820833386 | 1171.665574925896 | 1208.795039671166 | 1247.10356553639 | 1286.628661106459 | 1327.409030029944 | 1369.484609145054 | 1412.896607823275 | 1457.687548569632 | 1503.901308919729 | 1550.093539702862 | 1597.683806894082 | 1646.713930323185 | 1697.226968922233 | 1749.267257150424 | 1802.880442482594 | 1858.113523992237 | 1915.014892060832 | 1973.634369246141 | 2034.023252343143 | 2096.234355672205 | 2160.322055630076 | 1484.227270316812
Water Usage Cost |  |  |  | 257.4599451996345 | 310.5616033947072 | 325.5669984857363 | 334.1678901050336 | 341.8859397450406 | 340.6029924071165 | 355.7220740703251 | 374.8912834419769 | 380.1018677785151 | 390.3646182085349 | 400.9044629001654 | 411.7288833984697 | 422.8455632502284 | 434.2623934579845 | 445.98747808135 | 458.0291399895465 | 470.3959267692642 | 483.0966167920343 | 496.1402254454192 | 509.5360115324455 | 523.2934838438214 | 537.4224079076045 | 551.9328129211099 | 566.8349988699797 | 582.1395438394691 | 597.8573115231347 | 613.9994589342592 | 630.5774443254843 | 647.6030353222724 | 665.0883172759736 | 303.5754880159249
Water Discharge Cost |  |  |  | 532.5288441801596 | 642.3640445284896 | 673.4011275904641 | 691.1911681709187 | 707.1551428813581 | 704.5015011178634 | 735.7737329088357 | 775.4232282997314 | 786.2007745005137 | 807.4281954120274 | 829.2287566881521 | 851.6179331187321 | 874.6116173129377 | 898.226130980387 | 922.4782365168574 | 947.3851489028126 | 972.9645479231882 | 999.2345907171143 | 1026.213924666476 | 1053.921700632471 | 1082.377586549547 | 1111.601781386385 | 1141.615029483818 | 1172.438635279881 | 1204.094478432437 | 1236.605029350113 | 1269.993365142566 | 1304.283186001415 | 1339.498832023453 | 1375.665300488086 | 627.9139989297951
Power Marketing Manager |  |  |  | 5012.906496977992 | 3859.669973676615 | 4169.562183435876 | 4388.365273735825 | 4088.801288513786 | 4123.431256759072 | 4305.131318531166 | 4490.563503460415 | 4486.71860413282 | 4558.820352039417 | 4630.599785572975 | 4701.999765085038 | 4772.960100375338 | 4846.989984200781 | 4920.461848271769 | 4993.305754058331 | 5065.448165430416 | 5136.811796677734 | 5312.854372606066 | 5494.985546696535 | 5683.416277477327 | 5878.364814364329 | 6080.056948432783 | 6288.726271764278 | 6504.614445660591 | 6727.971478025619 | 6959.056010226981 | 7198.135613759218 | 7445.4870970415 | 7701.396822694021 | 5317.757013246668
Total Cost of Sales |  |  |  |  |  |  |  |  |  | 344013.4831115546 | 363966.3140900399 | 370644.8005644763 | 382276.2811316128 | 394273.3080218289 | 406647.4303001164 | 419410.5628697325 | 432578.5706498841 | 446160.5745503257 | 460169.6583671468 | 474619.3204591072 | 489523.4869107914 | 504533.8867020388 | 519998.312494917 | 535930.349621332 | 552343.9863738726 | 569253.6258728318 | 586674.0982806416 | 604620.673373832 | 623109.0734829386 | 642155.486811067 | 661776.5811421443 | 681989.517950206 | 702811.9669213851 | 482382.3445522779
Gross Profit
Fixed Expenses:
Fixed O&M |  |  |  | 3489.517241666667 | 4764.555614844468 | 4893.198616445268 | 5025.31497908929 | 5160.998483524701 | 5300.345442579867 | 5443.454769529523 | 5590.42804830682 | 5741.369605611103 | 5896.386584962603 | 6055.589022756592 | 6219.08992637102 | 6387.005354383037 | 6559.454498951379 | 6736.559770423066 | 6918.446884224488 | 7105.244950098549 | 7297.086563751209 | 7494.107900972491 | 7696.448814298747 | 7904.252932284813 | 8117.667761456502 | 8336.844791015827 | 8561.939600373253 | 8793.11196958333 | 9030.52599276208 | 9274.350194566654 | 9524.757649819952 | 9781.92610636509 | 10046.03811123695 | 10317.28114024034
Fuel Firm Transportation |  |  |  | 14302.85373406714 | 19354.42067024221 | 16779.6466836436 | 8519.557922066204 | 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
Fuel Pipeline Lateral Operations |  |  |  | 150.4890017969541 | 185.4626458145663 | 190.4701372515595 | 195.6128309573516 | 200.8943773932001 | 206.3185255828164 | 211.8891257735525 | 217.6101321694384 | 223.4856057380132 | 229.5197170929395 | 235.7167494544489 | 242.081101689719 | 248.6172914353413 | 255.3299583040955 | 262.2238671783061 | 269.3039115921203 | 276.5751172051075 | 284.0426453696454 | 291.7117967946258 | 299.5880153080807 | 307.6768917213988 | 315.9841677978766 | 324.5157403284192 | 333.2776653172865 | 342.2761622808532 | 351.5176186624362 | 361.008594366322 | 370.7558264142126 | 380.7662337273963 | 391.046922038036 | 267.7366252865465
Fuel Manager |  |  |  | 324.9620048999998 | 400.4831748387599 | 411.2962205594063 | 422.4012185145103 | 433.806051414402 | 445.5188148025908 | 457.5478228022607 | 469.9016140179217 | 482.5889575964055 | 495.6188594515085 | 509.0005686566992 | 522.74358401043 | 536.8576607787116 | 551.3528176197368 | 566.2393436954696 | 581.5278059752472 | 597.2290567365789 | 613.3542412684665 | 629.914805782715 | 646.9225055388482 | 664.389413188397 | 682.3279273444837 | 700.7507813827847 | 719.6710524801198 | 739.1021708970829 | 759.0579295113041 | 779.5524936081092 | 800.6004109355281 | 822.2166220307872 | 844.4164708256184 | 578.1434490187253
Fixed Fuel Costs
Off-Line Utilities |  |  |  | 567.8178459008358 | 699.7787132881899 | 718.672738546971 | 738.0769024877392 | 758.004978854908 | 778.4711132839905 | 799.4898333426581 | 821.0760588429098 | 843.2451124316683 | 866.0127304673233 | 889.3950741899409 | 913.4087411930693 | 938.0707772052821 | 963.3986881898246 | 989.4104527709497 | 1016.124534995765 | 1043.559897440651 | 1071.736014671548 | 1100.67288706768 | 1130.391055018508 | 1160.911613504007 | 1192.256227068615 | 1224.447145199468 | 1257.507218119853 | 1291.459913009089 | 1326.329330660335 | 1362.140222588163 | 1398.918008598044 | 1436.688794830191 | 1475.479392290606 | 1010.210925872745
Office & Administrative |  |  |  | 521.9250867588333 | 643.220476921586 | 660.5874297984689 | 678.4232904030274 | 696.7407192439091 | 715.5527186634946 | 734.872642067409 | 754.7142034032289 | 775.0914868951161 | 796.0189570412841 | 817.5114688813987 | 839.5842785411965 | 862.2530540618087 | 885.5338865214775 | 909.4433014575573 | 933.9982705969112 | 959.2162239030278 | 985.1150619484094 | 1011.713168621016 | 1039.029424173784 | 1067.083218626476 | 1095.894465529391 | 1125.483616098684 | 1155.871673733348 | 1187.080208924149 | 1219.131374565101 | 1252.047921678358 | 1285.853215563674 | 1320.571252383893 | 1356.226676198258 | 928.5626172850754
Insurance |  |  |  | 1299.8480196 | 4004.831748387599 | 4112.962205594064 | 4224.012185145103 | 4338.06051414402 | 4455.188148025908 | 4575.478228022607 | 4699.016140179217 | 4825.889575964056 | 4956.188594515085 | 5090.005686566992 | 5227.435840104301 | 5368.576607787117 | 5513.528176197368 | 5662.393436954697 | 5815.278059752473 | 5972.29056736579 | 6133.542412684666 | 6299.148057827151 | 6469.225055388484 | 6643.894131883972 | 6823.279273444839 | 7007.50781382785 | 7196.710524801201 | 7391.021708970833 | 7590.579295113045 | 7795.524936081097 | 8006.004109355285 | 8222.166220307878 | 8444.16470825619 | 5781.434490187257
Management Fee |  |  |  | 2039.26656554946 | 2513.192115383153 | 2581.048302498498 | 2650.736606665957 | 2722.306495045937 | 2795.808770412178 | 2871.295607213306 | 2948.820588608065 | 3028.438744500483 | 3110.206590601996 | 3194.182168548249 | 3280.425087099052 | 3368.996564450726 | 3459.959471690895 | 3553.378377426549 | 3649.319593617066 | 3747.851222644726 | 3849.043205656134 | 3952.967372208849 | 4059.697491258488 | 4169.309323522467 | 4281.880675257573 | 4397.491453489527 | 4516.223722733744 | 4638.161763247555 | 4763.392130855238 | 4892.003718388329 | 5024.087818784813 | 5159.738189892002 | 5299.051121019085 | 3628.081399972108
Other LOC Expense |  |  |  | 851.6666666666667 | 1825 | 1825 | 1825 | 1825 | 1825 | 1825 | 1825 | 1825 | 1825 | 1825 | 1825 | 1825 | 1825 | 1825 | 1825 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Debt Service Reserve [NAME] |  |  |  | 0 | 729.1937178454577 | 810.9128888111616 | 709.0440716842372 | 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
Fixed Operating Expenses
Wheeling Charge |  |  |  | 1589.217358553909 | 4352.336605959637 | 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
Tranmission O&M |  |  |  | 1616.117290868924 | 1991.702949266862 | 2045.478928897067 | 2100.706859977288 | 2157.425945196675 | 2215.676445716985 | 2275.499709751343 | 2336.938201914629 | 2400.035533366324 | 2464.836492767214 | 2531.387078071929 | 2599.734529179871 | 2669.927361467727 | 2742.015400227355 | 2816.049816033494 | 2892.083161066398 | 2970.16940641519 | 3050.3639803884 | 3132.723807858887 | 3217.307350671076 | 3304.174649139195 | 3393.387364665953 | 3485.008823511933 | 3579.104061746755 | 3675.739871413917 | 3774.984847942093 | 3876.909438836529 | 3981.585993685115 | 4089.088815514613 | 4199.494213533507 | 0
Other Fixed Plant Costs |  |  |  | 902.6722358333332 | 1112.453263441 | 1142.489501553906 | 1173.336718095862 | 1205.01680948445 | 1237.55226334053 | 1270.966174450724 | 1305.282261160894 | 1340.524882212238 | 1376.719054031968 | 1413.890468490831 | 1452.065511140083 | 1491.271279940865 | 1531.535604499269 | 1572.887065820749 | 1615.355016597909 | 1658.969602046052 | 1703.761781301296 | 1749.76334939643 | 1797.006959830134 | 1845.526147745547 | 1895.355353734677 | 1946.529948285513 | 1999.086256889222 | 2053.061585825231 | 2108.494248642512 | 2165.42359335586 | 2223.890030376468 | 2283.935061196632 | 2345.601307848941 | 2408.932543160862
Other Fixed Expenses
Property Tax |  |  |  | 825.5545227702722 | 10122.12400368631 | 13152.32187951459 | 15669.85039670254 | 18015.74612860654 | 20259.10798878248 | 19243.67592577505 | 18674.04330506356 | 17658.61124205612 | 16643.17917904869 | 15404.84739489328 | 14389.41533188584 | 13151.08354773044 | 12358.55120587097 | 11120.21942171556 | 9658.987916412181 | 8197.756411108801 | 6513.625184657446 | 5052.393679354063 | 3368.262452902708 | 1907.030947599326 | 1238.331784155406 | 1238.331784155406 | 1238.331784155406 | 1238.331784155406 | 1238.331784155406 | 1238.331784155406 | 1238.331784155406 | 1238.331784155406 | 1238.331784155406 | 1238.331784155406
Total Fixed Operating Costs
EBITDA
Major [NAME]) |  |  |  | 10044.13053099682 | 22840.85408648743 | 29659.70128007709 | 30685.13345418876 | 23312.45932648598 | 24459.46670890858 | 25855.10065543285 | 28228.93349502034 | 19872.54081080219 | 21033.38814433226 | 22395.34392514038 | 23936.13807360092 | 21526.9262827485 | 22382.00441148425 | 23280.21965938087 | 888.6784416579328 | 0.01336073050972592 | 11393.35647830766 | 11700.97710322197 | 12016.90348500896 | 12341.3598791042 | 12674.57659584001 | 13016.79016392769 | 13368.24349835374 | 13729.18607280929 | 14099.87409677514 | 14480.57069738806 | 14871.54610621754 | 15273.07785108541 | 15685.45095306472 | 10739.29870713242
Depreciation & Amortization |  |  |  | 26334.36850442462 | 46730.366008522 | 46730.366008522 | 46730.366008522 | 46730.366008522 | 46730.366008522 | 46730.366008522 | 46730.366008522 | 46730.366008522 | 46730.366008522 | 46730.366008522 | 46730.366008522 | 46730.366008522 | 46730.366008522 | 46730.366008522 | 46730.366008522 | 46730.366008522 | 46730.366008522 | 46201.78725224898 | 45144.63172187077 | 45144.63172187077 | 45144.63172187077 | 45144.63172187077 | 45144.63172187077 | 45144.63172187077 | 45144.63172187077 | 45144.63172187077 | 45144.63172187077 | 45144.63172187077 | 45144.63172187077 | 18810.26321744692
Interest Expense |  |  |  | 31230.0625 | 53973.32432779889 | 53700.06906412197 | 51932.34092298809 | 50765.77190962355 | 48638.90998765599 | 46355.72371442384 | 43904.72325010911 | 41273.57425166725 | 38449.03580183992 | 35416.89377595027 | 32161.88931115774 | 28667.64201820295 | 24916.56754921599 | 20889.78910675849 | 16567.04244878036 | 11926.57391144084 | 6945.030936606862 | 1597.344553122584 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Income Taxes: (Partnership - N/A)
State Franchise Tax |  |  |  | 5216.281506871002 | 1966.661142708118 | 3928.195846366268 | 6110.121596205596 | 6235.728075623051 | 6742.12168408637 | 8239.824543842045 | 9621.992619831728 | 10585.68967090668 | 11137.41046595238 | 11702.47607158481 | 12252.2276003664 | 13149.26510519258 | 13787.09192323049 | 14472.81408858797 | 17060.78428409579 | 18092.74465279313 | 18037.95636441562 | 19470.09912791697 | 20694.3632792236 | 24134.40728489947 | 27544.13449709032 | 28516.26967086905 | 29522.69798297203 | 30564.62523098096 | 31643.29933925634 | 32760.01181945804 | 33916.09928130262 | 35112.94499527221 | 36351.98050904855 | 24984.10908167091
Federal |  |  |  | 20995.53306515578 | 26334.59511876484 | 31660.59130969722 | 38072.74928740229 | 36378.86890956802 | 36388.30343405201 | 40534.70347124241 | 44363.0217800294 | 47957.49123075828 | 50173.42724448642 | 52452.55649348777 | 54660.56621050286 | 58275.88235375902 | 60838.39511003081 | 63603.16701192548 | 74015.00686251363 | 78173.38753285124 | 77948.12448580096 | 83717.2392952247 | 88640.1623179031 | 91915.72392307244 | 95064.52024813376 | 98977.36432259314 | 103028.2382788076 | 107221.9954520436 | 111563.658737852 | 116058.4264706638 | 120711.6785045883 | 125528.9825033159 | 130516.1004462656 | 93977.44692761899
Net Income