Spreadsheet: kevin_hyatt__19602__ARC
Sheet: Revenues

Transwestern Pipeline Company
Sun Devil Project - Sun Devil Project
REVENUES
 |  | Year
Customers |  | 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 | Total
Mainline | Vol(MMbtu/d) | 810 | 810 | 810 | 810 | 810 | 810 | 810 | 810 | 810 | 810 | 810 | 810 | 810 | 810 | 810 | 810 | 810 | 810 | 810 | 810 | 810 | 810 | 810 | 810 | 810 | 810 | 810 | 810 | 810 | 810
 | COS Rate | 0.2564071474611339 | 0.2535001591003748 | 0.2470515276685074 | 0.2411463658657402 | 0.2357396082156038 | 0.230792050382645 | 0.2260900228632856 | 0.221443171043143 | 0.2168473331727822 | 0.2123158482221321 | 0.2078388382273487 | 0.2034297459885434 | 0.1990788004869599 | 0.1947995546761506 | 0.1923041890372377 | 0.1915947393447354 | 0.1909572814249703 | 0.1903939750311246 | 0.1899070447089757 | 0.1894987817406747 | 0.1891715461468369 | 0.1889277687486963 | 0.1887699532921237 | 0.1887006786353662 | 0.1887226010024183 | 0.1888384563039942 | 0.1890510625281297 | 0.1893633222025015 | 0.1897782249306167 | 0.1902988500040877
 | Rate Adder | 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
 | Distribution | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Revenues ($000's) | 75806.77314688424 | 74947.3220380258 | 73040.78415519423 | 71490.25162455734 | 69696.41516894326 | 68233.669695629 | 66843.51525953037 | 65649.04248745018 | 64110.91405253306 | 62771.18052687337 | 61447.55252191565 | 60308.78249576357 | 58857.64736396971 | 57592.48834000392 | 56854.73348885932 | 56800.17642614026 | 56456.52025329248 | 56289.97871795198 | 56146.01776820868 | 56178.80883484042 | 55928.56761831234 | 55856.49483055205 | 55809.83669081636 | 55942.20318824067 | 55795.83698636497 | 55830.08960627588 | 55892.94663644154 | 56138.65050015358 | 56107.93220073683 | 56261.85500370853 | 1829086.987628169
[NAME] | 0.045 | 33.10119364542264 | 32.75604426200194 | 32.66431875084872 | 32.82517911174843 | 32.80578854220335 | 32.64140746262619 | 32.82933048949105 | 33.00513987826343 | 31.98647602761647 | 32.84478436550901 | 32.08927058457441 | 32.76440531301256 | 32.92615304961734 | 33.32304898031565 | 32.02992944870361 | 32.02992944870361 | 32.02992944870361 | 32.02992944870361 | 32.02992944870361 | 32.02992944870361 | 32.02992944870361 | 32.02992944870361 | 32.02992944870361 | 32.02992944870361 | 32.02992944870361 | 32.02992944870361 | 32.02992944870361 | 32.02992944870361 | 32.02992944870361 | 32.02992944870361 | 971.0414116425084
San Juan | Vol(MMbtu/d) | 780 | 780 | 780 | 780 | 780 | 780 | 780 | 780 | 780 | 780 | 780 | 780 | 780 | 780 | 780 | 780 | 780 | 780 | 780 | 780 | 780 | 780 | 780 | 780 | 780 | 780 | 780 | 780 | 780 | 780 | 23400
 | Rate | 0.1485615369808247 | 0.1468613463006168 | 0.1431367920473811 | 0.139721474335679 | 0.1365896126708446 | 0.1337187736564273 | 0.1309868588909298 | 0.1282850875221902 | 0.1256110408577121 | 0.1229722963172536 | 0.120363167285905 | 0.1177912879075699 | 0.1152510299932085 | 0.1127500878653701 | 0.1112665016611903 | 0.1108013835579455 | 0.1103755957504599 | 0.1099903181476063 | 0.1096467660555238 | 0.1093461912395353 | 0.1090898830179238 | 0.1088791693885205 | 0.1087154181890917 | 0.1086000382925366 | 0.1085344808379414 | 0.108520240498565 | 0.1085588567878638 | 0.1086519154046982 | 0.1088010496188943 | 0.1090079416983728 | 3.571386142778582
 | Distribution | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 30
 | Revenues ($000's) | 42295.4695784408 | 41811.42529178559 | 40751.0446958894 | 39887.68649334964 | 38887.06272738947 | 38069.73485998484 | 37291.95872624771 | 36622.82678583486 | 35761.46333219063 | 35010.2127615221 | 34267.39372629715 | 33627.05687185307 | 32811.96823906645 | 32099.95001527088 | 31677.57302294087 | 31631.57897812227 | 31423.93211015593 | 31314.24357662352 | 31216.43429600762 | 31216.15067506254 | 31057.8896952029 | 30997.89952491178 | 30951.2795584344 | 31003.13893175335 | 30899.76669456192 | 30895.71246994145 | 30906.70652750484 | 31017.94880973325 | 30975.65882649921 | 31034.56100152673 | 1017415.728804105
[NAME] | 0.0025 | 1.770845750578166 | 1.752380968749075 | 1.747473842637998 | 1.756079540957735 | 1.755042185385365 | 1.746248135860661 | 1.756301631125036 | 1.765707071676645 | 1.711210651683186 | 1.757128381693898 | 1.716709948969001 | 1.752828267774335 | 1.761481438868417 | 1.782714554502484 | 1.713535320301016 | 1.713535320301016 | 1.713535320301016 | 1.713535320301016 | 1.713535320301016 | 1.713535320301016 | 1.713535320301016 | 1.713535320301016 | 1.713535320301016 | 1.713535320301016 | 1.713535320301016 | 0 | 0 | 0 | 0 | 0 | 43.38104089377315
Phoenix | Vol(MMbtu/d) | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500
 | Rate | 0.3082244415400515 | 0.3052402484803449 | 0.2988240130506413 | 0.2929283440951584 | 0.2875094772958791 | 0.282529314820145 | 0.2777809410859353 | 0.273079994987424 | 0.2684222707932798 | 0.2638204911382505 | 0.2592649083808927 | 0.2547683344057532 | 0.2503211134986822 | 0.245936152229338 | 0.243269946288295 | 0.2423242455758425 | 0.2414404271706219 | 0.24062034754185 | 0.2398659188528202 | 0.2391791106317249 | 0.2385619514926021 | 0.2380165309079109 | 0.2375450010342844 | 0.2371495785930544 | 0.2368325468071928 | 0.2365962573963608 | 0.236443132631809 | 0.2363756674529262 | 0.2363964316472821 | 0.2365080720960741
 | Distribution | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 30
 | Revenues ($000's) | 56250.96058105941 | 55706.34534766294 | 54535.38238174204 | 53605.88696941398 | 52470.47960649794 | 51561.59995467646 | 50695.02174818318 | 49973.63908269859 | 48987.06441977356 | 48147.23963273071 | 47315.84577951292 | 46622.60519625284 | 45683.6032135095 | 44883.34778185417 | 44396.76519761383 | 44345.33694037918 | 44062.8779586385 | 43913.21342638761 | 43775.53019063968 | 43769.77724560566 | 43537.55614739989 | 43438.01689069374 | 43351.9626887569 | 43398.37288252896 | 43221.9397923127 | 43178.81697483584 | 43150.87170530515 | 43256.74714388549 | 43142.34877562898 | 43162.72315753352 | 1403541.878813714
[NAME] | 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 | 0 | 0
[NAME] to Bloomfield | Vol(MMbtu/d) |  | 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
 | Rate |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 | Distribution | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 25
 | Revenues ($000's) | 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 | 0
[NAME] | 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 | 0 | 0
 | Vol(MMbtu/d) | 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 | 0
 | Rate | 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 | 0
 | Commodity Rate | 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 | 0
 | Revenues ($000's) | 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 | 0
[NAME] | 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 | 0 | 0
 | Vol(MMbtu/d) | 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 | 0
 | Rate | 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 | 0
 | Commodity Rate | 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 | 0
 | Revenues ($000's) | 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 | 0
[NAME] | 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 | 0 | 0
 | Vol(MMbtu/d) | 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 | 0
 | Rate | 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 | 0
 | Commodity Rate | 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 | 0
 | Revenues ($000's) | 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 | 0
[NAME] | 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 | 0 | 0
 | Vol(MMbtu/d) | 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 | 0
 | Rate | 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 | 0
 | Commodity Rate | 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 | 0
 | Revenues ($000's) | 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 | 0
[NAME] | 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 | 0 | 0
Total Project | Vol(MMbtu/d) | 669.7765186685727 | 669.6512595480599 | 669.3210263480661 | 670.841554502383 | 668.7145212933729 | 668.4389973620058 | 668.1702953575492 | 669.726162776169 | 667.6166458887566 | 667.3321830928071 | 667.0421335561606 | 668.5741962172607 | 666.4474620139416 | 666.1431737195362 | 665.9878818934241 | 667.8157762941939 | 666.0028658933895 | 666.0233842381557 | 666.0530259411801 | 667.9170210249774 | 666.1409501972945 | 666.1998417120125 | 666.2690702870833 | 668.1745178042659 | 666.4395939881366 | 666.5413685078536 | 666.6544343482585 | 668.6057644622072 | 666.915137617359 | 667.0630533505862 | 20026.59981790502
 | Composite Rate | 0.7131931259820101 | 0.7056017538813364 | 0.6890123327665298 | 0.6737961842965776 | 0.6598386981823275 | 0.6470401388592173 | 0.6348578228401507 | 0.6228082535527573 | 0.610880644823774 | 0.5991086356776362 | 0.5874669138941464 | 0.5759893683018665 | 0.5646509439788506 | 0.5534857947708587 | 0.5468406369867229 | 0.5447203684785233 | 0.5427733043460522 | 0.5410046407205809 | 0.5394197296173197 | 0.538024083611935 | 0.5368233806573628 | 0.5358234690451276 | 0.5350303725154998 | 0.5344502955209572 | 0.5340896286475525 | 0.5339549541989199 | 0.5340530519478025 | 0.5343909050601259 | 0.534975706196793 | 0.5358148637985345
 | Revenues ($000's) | 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
[NAME] |  | 34.87203939600081 | 34.50842523075102 | 34.41179259348672 | 34.58125865270616 | 34.56083072758872 | 34.38765559848685 | 34.58563212061608 | 34.77084694994007 | 33.69768667929966 | 34.6019127472029 | 33.80598053354341 | 34.51723358078689 | 34.68763448848576 | 35.10576353481813 | 33.74346476900462 | 33.74346476900462 | 33.74346476900462 | 33.74346476900462 | 33.74346476900462 | 33.74346476900462 | 33.74346476900462 | 33.74346476900462 | 33.74346476900462 | 33.74346476900462 | 33.74346476900462 | 32.02992944870361 | 32.02992944870361 | 32.02992944870361 | 32.02992944870361 | 32.02992944870361 | 1014.422452536282
Fuel Retainage Revenues |  | 29191.57094169314 | 36708.96158169471 | 36708.96158169471 | 36708.96158169471 | 36708.96158169471 | 36708.96158169471 | 36708.96158169471 | 36708.96158169471 | 36708.96158169471 | 36708.96158169471 | 36708.96158169471 | 36708.96158169471 | 36708.96158169471 | 36708.96158169471 | 36708.96158169471 | 36708.96158169471 | 36708.96158169471 | 36708.96158169471 | 36708.96158169471 | 36708.96158169471 | 36708.96158169471 | 36708.96158169471 | 36708.96158169471 | 36708.96158169471 | 36708.96158169471 | 36708.96158169471 | 36708.96158169471 | 36708.96158169471 | 36708.96158169471 | 36708.96158169471 | 1093751.456810839