Spreadsheet: gerald_nemec__11416__Equity valuation - for condor
Sheet: volumes

Fort  Union Gas Gathering and Lost Creek Gas Gathering
[NAME]
Fort Union Gas Gathering Volumes
Firm Capacity
Incremental Rate
ECT Fixed Gathering Fee / Day
CMS Fixed Gathering Fee / Day
WGW Fixed Gathering Fee / Day
For the period beginning | 1999-11-30 00:00:00
Ending | 1999-12-31 00:00:00 | 2000-01-31 00:00:00 | 2000-02-29 00:00:00 | 2000-03-31 00:00:00 | 2000-04-30 00:00:00 | 2000-05-31 00:00:00 | 2000-06-30 00:00:00 | 2000-07-31 00:00:00 | 2000-08-31 00:00:00 | 2000-09-30 00:00:00 | 2000-10-31 00:00:00 | 2000-11-30 00:00:00 | 2000-12-31 00:00:00 | 2001-01-31 00:00:00 | 2001-02-28 00:00:00 | 2001-03-31 00:00:00 | 2001-04-30 00:00:00 | 2001-05-31 00:00:00 | 2001-06-30 00:00:00 | 2001-07-31 00:00:00 | 2001-08-31 00:00:00 | 2001-09-30 00:00:00 | 2001-10-31 00:00:00 | 2001-11-30 00:00:00 | 2001-12-31 00:00:00 | 2002-01-31 00:00:00 | 2002-02-28 00:00:00 | 2002-03-31 00:00:00 | 2002-04-30 00:00:00 | 2002-05-31 00:00:00 | 2002-06-30 00:00:00 | 2002-07-31 00:00:00 | 2002-08-31 00:00:00 | 2002-09-30 00:00:00 | 2002-10-31 00:00:00 | 2002-11-30 00:00:00 | 2002-12-31 00:00:00 | 2003-01-31 00:00:00 | 2003-02-28 00:00:00 | 2003-03-31 00:00:00 | 2003-04-30 00:00:00 | 2003-05-31 00:00:00 | 2003-06-30 00:00:00 | 2003-07-31 00:00:00 | 2003-08-31 00:00:00 | 2003-09-30 00:00:00 | 2003-10-31 00:00:00 | 2003-11-30 00:00:00 | 2003-12-31 00:00:00 | 2004-01-31 00:00:00 | 2004-02-29 00:00:00 | 2004-03-31 00:00:00 | 2004-04-30 00:00:00 | 2004-05-31 00:00:00 | 2004-06-30 00:00:00 | 2004-07-31 00:00:00 | 2004-08-31 00:00:00 | 2004-09-30 00:00:00 | 2004-10-31 00:00:00 | 2004-11-30 00:00:00 | 2004-12-31 00:00:00 | 2005-01-31 00:00:00 | 2005-02-28 00:00:00 | 2005-03-31 00:00:00 | 2005-04-30 00:00:00 | 2005-05-31 00:00:00 | 2005-06-30 00:00:00 | 2005-07-31 00:00:00 | 2005-08-31 00:00:00 | 2005-09-30 00:00:00 | 2005-10-31 00:00:00 | 2005-11-30 00:00:00 | 2005-12-31 00:00:00
Throughput Volumes (Mcfd)
Existing Volume | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000
ECT Volume | 0 | 15632 | 23968.66666666667 | 38795.1875 | 43838.72916666667 | 50896.125 | 66321.9375 | 72789.74784418535 | 80059.5617745041 | 87632.6498055582 | 98723.81770393162 | 109416.5860741591 | 116810.408152057 | 120967.9495029849 | 127030.3794354516 | 131061.794902348 | 133743.1118412103 | 135452.5262094057 | 141817.5297100901 | 143788.9968910655 | 145407.6832485632 | 145709.5253588825 | 145591.9105733817 | 145841.941097507 | 144622.4481146047 | 143024.2646151869 | 140952.5222863804 | 138811.1482111731 | 136668.1250240313 | 135588.0574163269 | 138937.722883069 | 137615.079082585 | 136405.6356829159 | 138351.063718328 | 137998.9730879556 | 137788.925688839 | 137714.9227799861 | 138070.4762455509 | 137952.3470649523 | 137237.6843901384 | 136670.3356529133 | 137995.1619540186 | 138952.6342657627 | 137593.4877854166 | 136358.0435087219 | 138241.0303318233 | 137791.5743244048 | 137047.8822858753 | 136426.584188806 | 135922.427726235 | 135530.391399892 | 133813.4744097585 | 132264.8280816002 | 131431.2306926242 | 132643.1234479025 | 131556.2623033627 | 131164.2037944476 | 132798.2915065539 | 132115.1431580792 | 131554.9716015733 | 131112.4063830901 | 130782.315834377 | 130559.7963403638 | 129694.2246872111 | 128961.1968502896 | 128909.038208571 | 127123.7313225106 | 125488.3527183515 | 124550.4145243243 | 122641.0611632313 | 120862.5558255461 | 119209.1008904598 | 117675.1589335453
Bighorn Volume | 0 | 1576.981299759304 | 2405.73174412146 | 3446.039177930014 | 4757.691446028516 | 6630.429642658772 | 9273.5112247732 | 12390.29650064804 | 15723.23783095725 | 19155.05905850771 | 22674.26252082951 | 26806.06037307909 | 29887.43391501578 | 33145.76104887989 | 36595.81896500654 | 40259.40836743202 | 44433.96676356238 | 49290.48324962977 | 53979.25148017445 | 58382.81845642914 | 62446.4577515409 | 66288.34360122491 | 69914.14061286495 | 73302.47944918518 | 76382.29972105756 | 79439.85298908922 | 82686.12296823348 | 86256.53650421105 | 90500.80459429293 | 95893.37287778118 | 102016.8099053656 | 108010.4519206306 | 113608.4447602695 | 118919.619193533 | 124021.6047517877 | 128841.544058082 | 133399.1565232365 | 137803.6568280255 | 142285.4887690362 | 146960.5303821914 | 152129.3812662159 | 157911.3342395934 | 163553.65132843 | 168393.7421924258 | 172390.5605207036 | 175830.7900277032 | 178873.8671606197 | 181520.2671415588 | 183695.0311185317 | 185591.9480628884 | 187454.7050106531 | 189404.8219371879 | 191664.7073589319 | 194213.1053730185 | 196337.2775285128 | 197621.5074810404 | 198059.4861898132 | 197852.1766002598 | 197190.9808818183 | 196198.8410706526 | 194875.7577713692 | 193522.0608331819 | 192377.8672843234 | 191584.5870590808 | 191381.3846907357 | 191996.4285583412 | 193022.4759415483 | 193809.556266704 | 194120.3217128539 | 194043.481622724 | 193753.5573607065 | 193316.5467095195 | 192804.4210477518
WGR / Barrett Volume | 0 | 2706.283898469288 | 6235.96543305561 | 13010.62586708002 | 21328.47269908932 | 33611.45208292966 | 50925.7099786863 | 71326.34067041271 | 69217.20039453865 | 58212.29113593409 | 43601.91977523887 | 28777.35355276184 | 18302.15793292722 | 43386.28944813524 | 66373.80159954182 | 91178.79673022003 | 116822.9213952273 | 142756.9905409646 | 229203.2188097354 | 245555.457379778 | 262600.4044544413 | 281183.9492217107 | 293571.7847648694 | 290747.0054408126 | 286949.776601199 | 282695.3542697187 | 278026.717846951 | 272973.7597908624 | 267346.8782761084 | 261418.3332898952 | 255542.5753790626 | 249804.0151457362 | 244056.4174680839 | 238331.6735704729 | 232676.2850223236 | 227139.8404367514 | 221776.3426544655 | 216618.0429320249 | 211735.078521375 | 207116.4224738452 | 202682.7397333404 | 198426.6222738111 | 194340.9587544483 | 190418.922637687 | 186653.9607830752 | 183039.7824979484 | 179570.3490266152 | 176239.8634604932 | 172708.1456677187 | 169204.9729274636 | 165725.2172939193 | 162263.9561912125 | 158816.4641885113 | 155378.205104532 | 151944.8244282519 | 148512.1420431692 | 145076.1452429467 | 141632.9820267764 | 138161.0963670609 | 134774.2931413029 | 131268.3956385016 | 127781.204342927 | 124309.5792424288 | 120850.5060797138 | 117455.0549953143 | 114118.2871340556 | 110835.4614377769 | 107602.0267237267 | 104413.6140802116 | 101266.0295667926 | 98144.53222911629 | 95115.67003825419 | 92175.73303414941
Other Third Party Volume | 0 | 3074.90796357295 | 5209.339275334237 | 7741.755473745397 | 10672.15655880643 | 14000.54253051734 | 17726.91338887812 | 8493.61498475389 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6831.254957974656 | 28744.93764885876 | 53409.11192677496 | 78931.43721691414 | 105152.8187166168 | 124274.1157817835 | 129137.0676092002 | 133980.0544003415 | 138809.4543746942 | 143631.3903093957 | 148451.7397694865 | 153276.1449284488 | 158110.0219954418 | 162983.5718796578 | 167737.4893232213 | 172711.1808898153 | 177674.1267128448 | 182630.7418907003 | 183517.5433475304 | 180666.8815325769 | 178152.7556513589 | 178593.8473844705 | 179597.4351874993 | 177888.3971425252 | 178764.2094883602 | 180191.9871120727 | 182170.2390249436 | 184280.6512834129 | 186289.6862955356 | 189517.7474618411 | 192254.0003709565 | 193977.4588298253 | 194074.7745953327 | 197310.0881724277 | 200700.1647727925 | 202716.5498664099 | 207532.7795930416 | 212471.8941864711 | 217743.440207039 | 222914.4189895141 | 227752.7571328841 | 232870.6821739943 | 237202.3634636604 | 239976.2460990321 | 244018.3312981642 | 248100.0642912178 | 251915.6496826102 | 257049.427647252 | 262239.354584631 | 267358.6823617665 | 270253.8173865565
Total Volume on Fort Union
Total Volume > 300MMcfd
Incremental Rate
Incremental Revenue / Day
# Days in Month
ECT Demand Revenue
Other Demand Revenue
Incremental Revenue
Total Revenue per Month
Lost Creek Gas Gathering Volumes
For the period beginning
Ending | 2000-10-31 00:00:00 | 2000-11-30 00:00:00 | 2000-12-31 00:00:00 | 2001-01-31 00:00:00 | 2001-02-28 00:00:00 | 2001-03-31 00:00:00 | 2001-04-30 00:00:00 | 2001-05-31 00:00:00 | 2001-06-30 00:00:00 | 2001-07-31 00:00:00 | 2001-08-31 00:00:00 | 2001-09-30 00:00:00 | 2001-10-31 00:00:00 | 2001-11-30 00:00:00 | 2001-12-31 00:00:00 | 2002-01-31 00:00:00 | 2002-02-28 00:00:00 | 2002-03-31 00:00:00 | 2002-04-30 00:00:00 | 2002-05-31 00:00:00 | 2002-06-30 00:00:00 | 2002-07-31 00:00:00 | 2002-08-31 00:00:00 | 2002-09-30 00:00:00 | 2002-10-31 00:00:00 | 2002-11-30 00:00:00 | 2002-12-31 00:00:00 | 2003-01-31 00:00:00 | 2003-02-28 00:00:00 | 2003-03-31 00:00:00 | 2003-04-30 00:00:00 | 2003-05-31 00:00:00 | 2003-06-30 00:00:00 | 2003-07-31 00:00:00 | 2003-08-31 00:00:00 | 2003-09-30 00:00:00 | 2003-10-31 00:00:00 | 2003-11-30 00:00:00 | 2003-12-31 00:00:00 | 2004-01-31 00:00:00 | 2004-02-29 00:00:00 | 2004-03-31 00:00:00 | 2004-04-30 00:00:00 | 2004-05-31 00:00:00 | 2004-06-30 00:00:00 | 2004-07-31 00:00:00 | 2004-08-31 00:00:00 | 2004-09-30 00:00:00 | 2004-10-31 00:00:00 | 2004-11-30 00:00:00 | 2004-12-31 00:00:00 | 2005-01-31 00:00:00 | 2005-02-28 00:00:00 | 2005-03-31 00:00:00 | 2005-04-30 00:00:00 | 2005-05-31 00:00:00 | 2005-06-30 00:00:00 | 2005-07-31 00:00:00 | 2005-08-31 00:00:00 | 2005-09-30 00:00:00 | 2005-10-31 00:00:00 | 2005-11-30 00:00:00 | 2005-12-31 00:00:00
Pre-expansion Total Capacity
Incremental expansion Capacity |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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
BR's Demand Volume (Mcfd) | 111000 | 111000 | 111000 | 111000 | 111000 | 111000 | 111000 | 111000 | 111000 | 111000 | 111000 | 111000 | 148000 | 148000 | 148000 | 148000 | 148000 | 148000 | 148000 | 148000 | 148000 | 148000 | 148000 | 148000 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750
EMS' Demand Volume including NCOC's portion (Mcfd) | 60000 | 60000 | 60000 | 60000 | 60000 | 60000 | 60000 | 60000 | 60000 | 60000 | 60000 | 60000 | 80000 | 80000 | 80000 | 80000 | 80000 | 80000 | 80000 | 80000 | 80000 | 80000 | 80000 | 80000 | 96250 | 96250 | 96250 | 96250 | 96250 | 96250 | 96250 | 96250 | 96250 | 96250 | 96250 | 96250 | 96250 | 96250 | 96250 | 96250 | 96250 | 96250 | 96250 | 96250 | 96250 | 96250 | 96250 | 96250 | 96250 | 96250 | 96250 | 96250 | 96250 | 96250 | 96250 | 96250 | 96250 | 96250 | 96250 | 96250 | 96250 | 96250 | 96250
NCOC Demand Volume through EMS (Mcfd) | 22500 | 22500 | 22500 | 22500 | 22500 | 22500 | 22500 | 22500 | 22500 | 22500 | 22500 | 22500 | 22500 | 22500 | 22500 | 22500 | 22500 | 22500 | 22500 | 22500 | 22500 | 22500 | 22500 | 22500 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500
Available Volumes (Mcfd - not capacity constrained)
BR | 111000 | 111000 | 111000 | 111000 | 111000 | 111000 | 111000 | 111000 | 111000 | 111000 | 111000 | 111000 | 148000 | 148000 | 148000 | 148000 | 148000 | 148000 | 148000 | 148000 | 148000 | 148000 | 148000 | 148000 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750 | 178750
EMS - NCOC | 22500 | 22500 | 22500 | 22500 | 22500 | 22500 | 22500 | 22500 | 22500 | 22500 | 22500 | 22500 | 22500 | 22500 | 22500 | 22500 | 22500 | 22500 | 22500 | 22500 | 22500 | 22500 | 22500 | 22500 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500
EMS - 3rd Party