Spreadsheet: gerald_nemec__11493__CASH_Wildhorse_121900
Sheet: Gas Plant - D&G

Gas Plant Model
Gas Price
 | Gas - NW Index | $/MMBTU | Buy back % of NW Index
 | From Plant | $/MMBTU | 0.75
 | Into Plant | $/MMBTU
Dakota Production (MMcfd) |  | Include?
 |  | 0
 |  | 0
 |  | 1
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
Wasatch |  | 0
Inlet
 | Gas | MMCF/D
 | Gas | BBTU/D
GPM's |  | MGal/D | 0.9744
by |  | MGal/D | 0.3547
Component |  | MGal/D | 0.08828
 |  | MGal/D | 0.12558
 |  | MGal/D | 0.05839
 |  | MGal/D | 0.05053
 |  | MGal/D | 0.15988
Recovery
 | C2 | MGal/D | 0.25
 | [NAME] | MGal/D | 0.65
 | IC4 | MGal/D | 0.85
 | NC4 | MGal/D | 0.9
 | IC5 | MGal/D | 0.95
 | NC5 | MGal/D | 0.95
 | C6+ | MGal/D | 0.996068
 | Total NGL's | MGal/D
 |  | MBarrels/D
Shrink | C2 | BBTU/D | 0.06632
 | [NAME] | BBTU/D | 0.091523
 | IC4 | BBTU/D | 0.099635
 | NC4 | BBTU/D | 0.10371
 | IC5 | BBTU/D | 0.1096
 | NC5 | BBTU/D | 0.11094
 | C6+ | BBTU/D | 0.122324
 | Total | BBTU/D
 | Value | M$/D
Fuel | Gas | BBTU/D | 0.02
 | Value | $/D
Residue | Total Residue | BBTU/D
 | Value | $/D
 | Total Residue | BBTU/Yr
NGL Prices | C2 |  |  | 0.4246917063060012 | 0.3189517358768665 | 0.2643730666659201 | 0.2620352457287541 | 0.2636522504182943 | 0.2653010242275564 | 0.2685856741973306 | 0.2738692193786249 | 0.2797637012643036 | 0.2856698191566503
$/Gal | [NAME] |  |  | 0.5519261435119047 | 0.4473639063745639 | 0.4327667895225924 | 0.4317322018478471 | 0.4326539742362721 | 0.4336217625612922 | 0.4035215334007034 | 0.4060041011862567 | 0.4105174127118009 | 0.4174434117281025
 | IC4 |  |  | 0.5990795522274376 | 0.5018746271888695 | 0.4687591648933884 | 0.4629751387910974 | 0.4600140218635309 | 0.457119303147645 | 0.4576436043019481 | 0.4623456437298336 | 0.4683245553208717 | 0.4743277864410799
 | NC4 |  |  | 0.6007462188941042 | 0.5018746271888695 | 0.4687591648933884 | 0.4629751387910974 | 0.4600140218635309 | 0.457119303147645 | 0.4576436043019481 | 0.4623456437298336 | 0.4683245553208717 | 0.4743277864410799
 | IC5 |  |  | 0.6389195987492385 | 0.5311718500132762 | 0.5040243965125973 | 0.4930037857607101 | 0.4854968427856787 | 0.4780725454936595 | 0.4749038934253246 | 0.4769352614226225 | 0.4805559489116709 | 0.4842069068560209
 | NC5 |  |  | 0.6389195987492385 | 0.5311718500132762 | 0.5040243965125973 | 0.4930037857607101 | 0.4854968427856787 | 0.4780725454936595 | 0.4749038934253246 | 0.4769352614226225 | 0.4805559489116709 | 0.4842069068560209
 | C6+ |  |  | 0.6389195987492385 | 0.5311718500132762 | 0.5040243965125973 | 0.4930037857607101 | 0.4854968427856787 | 0.4780725454936595 | 0.4749038934253246 | 0.4769352614226225 | 0.4805559489116709 | 0.4842069068560209
T&F | C2 |  |  | -0.13 | -0.13 | -0.13 | -0.13 | -0.13 | -0.13 | -0.13 | -0.13 | -0.13 | -0.13
 | [NAME] |  |  | -0.13 | -0.13 | -0.13 | -0.13 | -0.13 | -0.13 | -0.13 | -0.13 | -0.13 | -0.13
 | IC4 |  |  | -0.13 | -0.13 | -0.13 | -0.13 | -0.13 | -0.13 | -0.13 | -0.13 | -0.13 | -0.13
 | NC4 |  |  | -0.13 | -0.13 | -0.13 | -0.13 | -0.13 | -0.13 | -0.13 | -0.13 | -0.13 | -0.13
 | IC5 |  |  | -0.13 | -0.13 | -0.13 | -0.13 | -0.13 | -0.13 | -0.13 | -0.13 | -0.13 | -0.13
 | NC5 |  |  | -0.13 | -0.13 | -0.13 | -0.13 | -0.13 | -0.13 | -0.13 | -0.13 | -0.13 | -0.13
 | C6+ |  |  | -0.13 | -0.13 | -0.13 | -0.13 | -0.13 | -0.13 | -0.13 | -0.13 | -0.13 | -0.13
Liquids Revenue
 | C2
 | [NAME]
 | IC4
 | NC4
 | IC5
 | NC5
 | C6+
 | Total
Plant Margin | Liquids Rev |  | M$/D
 | Cost of Gas Shrink M/U |  | M$/D
 | Gross Margin |  | M$/D