Workover Economics and Budget Screening


Description

Which workovers should the budget fund? You enter a shared IPR well and, for each candidate, its permeability, current and target skin, cost and chance of success, with a decline, price deck and costs to value the gain. You read off each candidate's incremental rate, its success, failure and risked NPV, and which jobs the budget funds in order of risked NPV per dollar.

How to use it: Enter the reservoir, fluid and common flowing pressure, and each candidate's permeability, skins, cost and chance of success, on the Candidates sheet. Set the economics deck, the well's age and the incremental decline on the Workover Cash Flows sheet, and the budget on the Programme sheet. Check the input and horizon checks first, then each candidate's uplift against its own IPR base and its post-workover rate against the type curve's initial rate. Read the ranking, the funded jobs and the spend on the Programme sheet and the Summary. Replace every illustrative input with field data before a decision.

Method: Each candidate's productivity index is the pseudo-steady-state vertical-well index for today's skin and for the target skin, J = k h/(141.2 Bo μo (ln(re/rw) − 0.75 + S)), and its rate at the common flowing pressure is Vogel's composite IPR, q = J (Pr − Pb) + J Pb/1.8 (1 − 0.2 (Pwf/Pb) − 0.8 (Pwf/Pb)^2). The uplift is the target-skin rate less today's. The incremental rate then declines exponentially, sampled at mid-month, until the base well's economic life ends, with the nominal decline −ln(1 − D) from the effective. The incremental barrels earn the net operating margin; the workover's WI-adjusted cost falls in month one. Fixed LOE is not incremental. The success NPV discounts the monthly net cash at the month ends. The failure NPV is the negative discounted cost; the risked NPV is Pc × success NPV + (1 − Pc) × failure NPV.

Eligible jobs have positive uplift, cost and risked NPV. They are ranked by risked NPV over the undiscounted WI-adjusted capex, ties in input order. The walk goes down the ranks once, funding each affordable job and skipping an unaffordable one while continuing to the next; the budget counts the same WI-adjusted cost. This is a greedy heuristic for indivisible projects, not an optimal knapsack; shared constraints, interactions between jobs and scheduling are left out.

Example: Three synthetic variations of the IPR reference well (k = 0.5 mD, skins 1, 2 and 3 to −2, Pwf = 2,000 psi) gain about 48.24, 57.61 and 65.22 STB/d. Their success NPVs are about $654,206, $700,044 and −$134,137, and their risked NPVs about $453,919, $460,827 and −$404,937. At the $1,000,000 budget the ranking by risked NPV per dollar funds A, then B, spends $850,000 and leaves $150,000. The economics are the shared decline, price deck and costs of the economics family's well; beside the candidates sit the original IPR reference well, an independent 60 STB/d workover and the full-well NPV and IRR, which is not a workover. These rounded numbers are illustrations; each blueprint gives its own on the same inputs.

Validity

The workover cash flows run for at most 360 months and the full-well reference for at most 400 months. If either requested horizon exceeds its limit, its check and the overall verdict fail; the bounded values shown are invalid previews, and the programme excludes every candidate when the workover horizon is invalid. The IPR geometry, fluid properties, pressures, each candidate's permeability, the skin term, the cost and the chance must pass the input check. Do not decide on an invalid case.

The IPR and the economic type curve are independent examples, not a calibrated well. Both base rates are shown, with separate checks on the IPR uplift against its own base and on the post-workover type-curve rate against its initial rate. No rate is silently scaled or capped. The model ignores a workover's life extension, changing fixed costs and production acceleration. Replace every illustrative input with supported field data before a decision.

References

  • Vogel, J.V. (1968). Inflow Performance Relationships for Solution-Gas Drive Wells. JPT 20(1), 83-92.
  • Petroleum Office blueprints po.bp.ipr.skin.sensitivity, po.bp.econ.workover.decision and po.bp.econ.npv.irr.

Inputs

Input Unit Default Name
Net pay ft 50 WEC_h
Oil formation volume factor rb/STB 1.467 WEC_Bo
Oil viscosity cp 0.302 WEC_Uo
Drainage radius ft 1,490 WEC_re
Wellbore radius ft 0.354 WEC_rw
Reservoir pressure psi 4,000 WEC_Pr
Bubble point psi 2,620 WEC_Pb
Common flowing pressure psi 2,000 WEC_Pwf
Permeability (candidates A, B, C) mD 0.5, 0.5, 0.5 WEC_A_k, WEC_B_k, WEC_C_k
Current skin — 1, 2, 3 WEC_A_Skin, WEC_B_Skin, WEC_C_Skin
Target skin — −2, −2, −2 WEC_A_Target, WEC_B_Target, WEC_C_Target
Workover cost $ 350,000, 500,000, 1,500,000 WEC_A_Cost, WEC_B_Cost, WEC_C_Cost
Chance of success % 80 % each WEC_A_Pc, WEC_B_Pc, WEC_C_Pc
Economics deck: the shared well's life cap, type curve, prices, interests, Texas taxes, operating costs and discount rate various the economics family's well (800 STB/d, $70/STB oil, 10 %) WEV_*
Months the well has produced before the workover months 36 WEV_Age
Decline of the incremental rate, effective (exponential) %/yr 50 % WEV_UpDecl
Incremental oil rate the workover adds at the start (60 STB/d reference) STB/d 60 WEV_Reference_Uplift
Workover cost, paid in the first month (reference) $ 350,000 WEV_Reference_Cost
Chance the workover succeeds (reference) % 80 % WEV_Reference_Pc
Longest acceptable payout, from the workover months 12 WEV_PayoutMax
Full-well reference: the same well's inputs various the economics family's well WEN_*
Available budget $ 1,000,000 WEP_Budget

Sheets

  • Guide — what the workbook screens, how success, failure and risk are valued, and the limits of the greedy programme.
  • Candidates — the shared IPR inputs, candidates A, B and C with their permeability, skins, cost and chance, each one's productivity index and IPR rate before and after treatment, the skin-derived uplift, the original IPR reference and the candidate checks.
  • Workover Cash Flows — the economics deck, the base decline and remaining life, each candidate's and the 60 STB/d reference's incremental rate, success, failure and risked NPV, payout, PV/I, break-even chance and uplift, the monthly incremental cash flows and a chart of their first 60 months.
  • Well Reference — the independent full-well NPV, IRR, payout, PV/I, EUR and net cash from a monthly cash flow, with its horizon check.
  • Programme — the budget, each candidate's eligibility, risked NPV per dollar and rank, the greedy walk funding or skipping each rank, and the spend, headroom and funded NPVs.
  • Summary — the programme's spend, headroom, NPVs and selected candidates, and every check under one verdict.
  • Test Cases — the worked example and other cases, with expected and computed results.

The add-in supplies the IPR functions; Excel 365 supplies dynamic arrays.

Functions used

PO.IPR.VW.PSS.PIPO.IPR.VW.PSS.Rate.ByVogelPO.ECON.NPV.MonthlyPO.ECON.IRR.MonthlyPO.ECON.Payout

Names (266)

NameRefers toComment
PO.ECON.IRR.MonthlyLAMBDA =LAMBDA(cash,LET(cash_col,cash,grid_step,0.0025,rates,SEQUENCE(1,201,-0.05,grid_step),periods,SEQUENCE(ROWS(cash_col)),npv_grid,MMULT(TRANSPOSE(cash_col),(1+rates)^(-periods)),first_pos,IFERROR(XMATCH(TRUE,npv_grid>0),0),crossing,IF(first_pos=0,0,IFERROR(XMATCH(1,(SEQUENCE(1,201)>first_pos)*(npv_grid<=0)),0)),IF(crossing=0,"n/a",LET(r_lo,INDEX(rates,1,crossing-1),v_lo,INDEX(npv_grid,1,crossing-1),v_hi,INDEX(npv_grid,1,crossing),r_interp,r_lo+grid_step*v_lo/(v_lo-v_hi),r_refined,IFERROR(IRR(cash_col,r_lo),r_interp),(1+IF(AND(r_refined>=r_lo,r_refined<=r_lo+grid_step),r_refined,r_interp))^12-1)))) Annualised IRR of monthly cash flows: the first rate, scanning up from -5 %/month, at which NPV falls through zero; "n/a" when it never does
PO.ECON.NPV.MonthlyLAMBDA =LAMBDA(cash,annual_rate,NPV((1+annual_rate)^(1/12)-1,cash)) NPV of end-of-month cash flows at an annual discount rate, in the units of cash.
PO.ECON.PayoutLAMBDA =LAMBDA(cash,LET(cumulative,SCAN(0,cash,LAMBDA(running,flow,running+flow)),trough,MATCH(MIN(cumulative),cumulative,0),IFERROR(MATCH(1,(SEQUENCE(ROWS(cumulative))>trough)*(cumulative>=0),0),"none"))) Month in which cumulative cash flow climbs back to zero after its low point; "none" if it never does
WEC_A_After Candidates!$B$24 IPR rate after treatment, STB/d
WEC_A_Base Candidates!$B$23 IPR base rate, STB/d
WEC_A_Cost Candidates!$B$19 Workover cost, $
WEC_A_J Candidates!$B$21 Current productivity index, STB/d/psi
WEC_A_JTarget Candidates!$B$22 Target productivity index, STB/d/psi
WEC_A_Pc Candidates!$B$20 Chance of success, %
WEC_A_RateCheck Candidates!$B$31 A: IPR uplift against its own base verdict
WEC_A_RateCheckNote Candidates!$C$31 A: IPR uplift against its own base comment
WEC_A_Skin Candidates!$B$17 Current skin
WEC_A_Target Candidates!$B$18 Target skin
WEC_A_Uplift Candidates!$B$25 Skin-derived uplift, STB/d
WEC_A_k Candidates!$B$16 Permeability, mD
WEC_B_After Candidates!$C$24 IPR rate after treatment, STB/d
WEC_B_Base Candidates!$C$23 IPR base rate, STB/d
WEC_B_Cost Candidates!$C$19 Workover cost, $
WEC_B_J Candidates!$C$21 Current productivity index, STB/d/psi
WEC_B_JTarget Candidates!$C$22 Target productivity index, STB/d/psi
WEC_B_Pc Candidates!$C$20 Chance of success, %
WEC_B_RateCheck Candidates!$B$32 B: IPR uplift against its own base verdict
WEC_B_RateCheckNote Candidates!$C$32 B: IPR uplift against its own base comment
WEC_B_Skin Candidates!$C$17 Current skin
WEC_B_Target Candidates!$C$18 Target skin
WEC_B_Uplift Candidates!$C$25 Skin-derived uplift, STB/d
WEC_B_k Candidates!$C$16 Permeability, mD
WEC_Bo Candidates!$B$5 Oil formation volume factor, bbl/STB
WEC_C_After Candidates!$D$24 IPR rate after treatment, STB/d
WEC_C_Base Candidates!$D$23 IPR base rate, STB/d
WEC_C_Cost Candidates!$D$19 Workover cost, $
WEC_C_J Candidates!$D$21 Current productivity index, STB/d/psi
WEC_C_JTarget Candidates!$D$22 Target productivity index, STB/d/psi
WEC_C_Pc Candidates!$D$20 Chance of success, %
WEC_C_RateCheck Candidates!$B$33 C: IPR uplift against its own base verdict
WEC_C_RateCheckNote Candidates!$C$33 C: IPR uplift against its own base comment
WEC_C_Skin Candidates!$D$17 Current skin
WEC_C_Target Candidates!$D$18 Target skin
WEC_C_Uplift Candidates!$D$25 Skin-derived uplift, STB/d
WEC_C_k Candidates!$D$16 Permeability, mD
WEC_InputCheck Candidates!$B$34 Candidate input check verdict
WEC_InputCheckNote Candidates!$C$34 Candidate input check comment
WEC_Inputs Candidates!$B$4:$B$11 Shared IPR inputs
WEC_Pb Candidates!$B$10 Bubble point, psi
WEC_Pr Candidates!$B$9 Reservoir pressure, psi
WEC_Pwf Candidates!$B$11 Common flowing pressure, psi
WEC_RefJ Candidates!$B$27 Reference today's PI, STB/d/psi
WEC_RefJTarget Candidates!$B$28 Reference stimulated PI, STB/d/psi
WEC_RefUplift Candidates!$B$29 Reference uplift, not a candidate, STB/d
WEC_Results Candidates!$B$21:$D$25 Candidate IPR results
WEC_Uo Candidates!$B$6 Oil viscosity, cp
WEC_h Candidates!$B$4 Net pay, ft
WEC_re Candidates!$B$7 Drainage radius, ft
WEC_rw Candidates!$B$8 Wellbore radius, ft
WEN_AdVal 'Well Reference'!$B$21 Ad valorem tax, as a share of net revenue, %
WEN_DC 'Well Reference'!$B$22 Drilling and completion of the well, $MM
WEN_Days 'Well Reference'!$B$34 Days per month, days/month
WEN_Dei 'Well Reference'!$B$8 Initial decline, effective secant, %/yr
WEN_Di 'Well Reference'!$B$38 Initial nominal decline, from the effective secant, 1/yr
WEN_Disc 'Well Reference'!$B$31 Discount rate, end-of-month cash flows, %/yr
WEN_Dt 'Well Reference'!$B$39 Terminal nominal decline, from the effective, 1/yr
WEN_Dterm 'Well Reference'!$B$9 Terminal decline, effective (exponential tail), %/yr
WEN_EUR 'Well Reference'!$B$56 Oil EUR, MSTB
WEN_Esc 'Well Reference'!$B$16 Escalation of prices and operating costs, %/yr
WEN_GOR 'Well Reference'!$B$10 Gas-oil ratio, constant over life, scf/STB
WEN_Gas 'Well Reference'!$B$14 Gas price (Henry Hub, 1 MMBtu per Mscf), $/MMBtu
WEN_GasDiff 'Well Reference'!$B$15 Gas differential, deducted (Waha basis), $/MMBtu
WEN_Gath 'Well Reference'!$B$25 Gas gathering and processing, $/Mscf
WEN_HorizonCheck 'Well Reference'!$B$49 Full-well reference horizon verdict
WEN_HorizonCheckNote 'Well Reference'!$C$49 Full-well reference horizon comment
WEN_Hurdle 'Well Reference'!$B$32 IRR hurdle, %/yr
WEN_IP 'Well Reference'!$B$6 Initial oil rate of the type curve, STB/d
WEN_IRR 'Well Reference'!$B$52 IRR, %/yr
WEN_LOE 'Well Reference'!$B$23 Fixed LOE, $/well-month
WEN_LOEVar 'Well Reference'!$B$24 Variable LOE per barrel of oil, $/STB
WEN_Life 'Well Reference'!$B$46 Producing life, to the economic limit or the cap, months
WEN_LifeCap 'Well Reference'!$B$5 Longest producing life of the well, months
WEN_Margin 'Well Reference'!$B$43 Operating margin per barrel of oil, net of royalty and taxes, $/STB
WEN_MoYr 'Well Reference'!$B$35 Months per year, months/year
WEN_N 'Well Reference'!$B$48 Bounded months (preview only if horizon check fails), months
WEN_NPV 'Well Reference'!$B$51 NPV, $MM
WEN_NRI 'Well Reference'!$B$18 Net revenue interest (25 % royalty at 100 % WI), %
WEN_NetCash 'Well Reference'!$B$57 Net cash, $MM
WEN_Oil 'Well Reference'!$B$12 Oil price (WTI), $/STB
WEN_OilDiff 'Well Reference'!$B$13 Oil differential, deducted (quality and transport), $/STB
WEN_Online 'Well Reference'!$B$4 Month the well comes online (month 1 starts the evaluation), months
WEN_PA 'Well Reference'!$B$26 Plugging and abandonment, the month after the last production, $
WEN_PVI 'Well Reference'!$B$55 PV/I
WEN_Payout 'Well Reference'!$B$53 Payout, months
WEN_PayoutMax 'Well Reference'!$B$33 Longest acceptable payout, from month 1, months
WEN_PerMM 'Well Reference'!$B$36 Dollars per million, $/MM
WEN_Phase1 'Well Reference'!$B$30 D&C share spent the month before online, %
WEN_Phase2 'Well Reference'!$B$29 D&C share spent two months before online, %
WEN_Phase3 'Well Reference'!$B$28 D&C share spent three months before online, %
WEN_Phase4 'Well Reference'!$B$27 D&C share spent four months before online, %
WEN_PvCapital 'Well Reference'!$B$54 Discounted capital, $MM
WEN_QLimit 'Well Reference'!$B$44 Economic-limit oil rate, fixed LOE over the margin, STB/d
WEN_Qi 'Well Reference'!$B$42 Initial oil rate, IP × type-curve factor, STB/d
WEN_Qs 'Well Reference'!$B$41 Rate at the switch over the initial rate
WEN_RequestedN 'Well Reference'!$B$47 Requested months through plugging, months
WEN_SevGas 'Well Reference'!$B$20 Gas severance tax (Texas, of the gas's value), %
WEN_SevOil 'Well Reference'!$B$19 Oil severance tax (Texas, of the oil's value), %
WEN_TC 'Well Reference'!$B$11 Type-curve factor (scales the initial rate)
WEN_TLimit 'Well Reference'!$B$45 Time the decline takes to reach the limit, years
WEN_Ts 'Well Reference'!$B$40 Time the hyperbolic switches to the terminal decline, years
WEN_WI 'Well Reference'!$B$17 Working interest (scales costs and capital), %
WEN_b 'Well Reference'!$B$7 Arps hyperbolic exponent b
WEP_A_Eligible Programme!$B$9 Eligible (1=yes)
WEP_A_Rank Programme!$B$11 Rank (zero excluded)
WEP_A_Ratio Programme!$B$10 Risked NPV / cost
WEP_B_Eligible Programme!$C$9 Eligible (1=yes)
WEP_B_Rank Programme!$C$11 Rank (zero excluded)
WEP_B_Ratio Programme!$C$10 Risked NPV / cost
WEP_Budget Programme!$B$4 Available budget, $
WEP_BudgetCheck Programme!$B$5 Budget check verdict
WEP_BudgetCheckNote Programme!$C$5 Budget check comment
WEP_C_Eligible Programme!$D$9 Eligible (1=yes)
WEP_C_Rank Programme!$D$11 Rank (zero excluded)
WEP_C_Ratio Programme!$D$10 Risked NPV / cost
WEP_ENPV Programme!$B$25 Risked NPV, $MM
WEP_Headroom Programme!$B$23 Headroom, $
WEP_NPV Programme!$B$24 Success NPV, $MM
WEP_R1_Cost Programme!$B$15 Cost, $
WEP_R1_Decision Programme!$B$18 Decision
WEP_R1_ENPV Programme!$B$20 Risked NPV funded, $MM
WEP_R1_Funded Programme!$B$16 Funded (1=yes)
WEP_R1_Index Programme!$B$14 Candidate index (A=1, B=2, C=3)
WEP_R1_NPV Programme!$B$19 Success NPV funded, $MM
WEP_R1_Remaining Programme!$B$17 Budget remaining, $
WEP_R2_Cost Programme!$C$15 Cost, $
WEP_R2_Decision Programme!$C$18 Decision
WEP_R2_ENPV Programme!$C$20 Risked NPV funded, $MM
WEP_R2_Funded Programme!$C$16 Funded (1=yes)
WEP_R2_Index Programme!$C$14 Candidate index (A=1, B=2, C=3)
WEP_R2_NPV Programme!$C$19 Success NPV funded, $MM
WEP_R2_Remaining Programme!$C$17 Budget remaining, $
WEP_R3_Cost Programme!$D$15 Cost, $
WEP_R3_Decision Programme!$D$18 Decision
WEP_R3_ENPV Programme!$D$20 Risked NPV funded, $MM
WEP_R3_Funded Programme!$D$16 Funded (1=yes)
WEP_R3_Index Programme!$D$14 Candidate index (A=1, B=2, C=3)
WEP_R3_NPV Programme!$D$19 Success NPV funded, $MM
WEP_R3_Remaining Programme!$D$17 Budget remaining, $
WEP_Spend Programme!$B$22 Spend, $
WEV_A_AfterNow 'Workover Cash Flows'!$B$53 After-workover type-curve rate, STB/d
WEV_A_BaseDifference 'Workover Cash Flows'!$B$51 IPR base less type-curve base, STB/d
WEV_A_Capex 'Workover Cash Flows'!$B$64 WI-adjusted undiscounted cost, $
WEV_A_ENPV 'Workover Cash Flows'!$B$61 Risked NPV, $MM
WEV_A_IncEUR 'Workover Cash Flows'!$B$58 Incremental oil over horizon, MSTB
WEV_A_IncNow 'Workover Cash Flows'!$B$52 Incremental first-month rate, STB/d
WEV_A_IprBase 'Workover Cash Flows'!$B$50 Candidate IPR base at common pressure, STB/d
WEV_A_NPV 'Workover Cash Flows'!$B$54 Success NPV, $MM
WEV_A_NetCash 'Workover Cash Flows'!$B$59 Incremental net cash, $MM
WEV_A_NpvFail 'Workover Cash Flows'!$B$60 Failure NPV, $MM
WEV_A_PVI 'Workover Cash Flows'!$B$57 PV/I
WEV_A_Payout 'Workover Cash Flows'!$B$55 Payout month, months
WEV_A_PcMin 'Workover Cash Flows'!$B$62 Break-even chance, %
WEV_A_PvCost 'Workover Cash Flows'!$B$56 Discounted cost, $MM
WEV_A_RateCheck 'Workover Cash Flows'!$B$67 A: type-curve rate check verdict
WEV_A_RateCheckNote 'Workover Cash Flows'!$C$67 A: type-curve rate check comment
WEV_A_UpliftMin 'Workover Cash Flows'!$B$63 Break-even uplift, STB/d
WEV_AdVal 'Workover Cash Flows'!$B$20 Ad valorem tax, as a share of net revenue, %
WEV_Age 'Workover Cash Flows'!$B$25 Months the well has produced before the workover, months
WEV_B_AfterNow 'Workover Cash Flows'!$C$53 After-workover type-curve rate, STB/d
WEV_B_BaseDifference 'Workover Cash Flows'!$C$51 IPR base less type-curve base, STB/d
WEV_B_Capex 'Workover Cash Flows'!$C$64 WI-adjusted undiscounted cost, $
WEV_B_ENPV 'Workover Cash Flows'!$C$61 Risked NPV, $MM
WEV_B_IncEUR 'Workover Cash Flows'!$C$58 Incremental oil over horizon, MSTB
WEV_B_IncNow 'Workover Cash Flows'!$C$52 Incremental first-month rate, STB/d
WEV_B_IprBase 'Workover Cash Flows'!$C$50 Candidate IPR base at common pressure, STB/d
WEV_B_NPV 'Workover Cash Flows'!$C$54 Success NPV, $MM
WEV_B_NetCash 'Workover Cash Flows'!$C$59 Incremental net cash, $MM
WEV_B_NpvFail 'Workover Cash Flows'!$C$60 Failure NPV, $MM
WEV_B_PVI 'Workover Cash Flows'!$C$57 PV/I
WEV_B_Payout 'Workover Cash Flows'!$C$55 Payout month, months
WEV_B_PcMin 'Workover Cash Flows'!$C$62 Break-even chance, %
WEV_B_PvCost 'Workover Cash Flows'!$C$56 Discounted cost, $MM
WEV_B_RateCheck 'Workover Cash Flows'!$B$68 B: type-curve rate check verdict
WEV_B_RateCheckNote 'Workover Cash Flows'!$C$68 B: type-curve rate check comment
WEV_B_UpliftMin 'Workover Cash Flows'!$C$63 Break-even uplift, STB/d
WEV_BaseNow 'Workover Cash Flows'!$B$47 Type-curve base rate, first month, STB/d
WEV_C_AfterNow 'Workover Cash Flows'!$D$53 After-workover type-curve rate, STB/d
WEV_C_BaseDifference 'Workover Cash Flows'!$D$51 IPR base less type-curve base, STB/d
WEV_C_Capex 'Workover Cash Flows'!$D$64 WI-adjusted undiscounted cost, $
WEV_C_ENPV 'Workover Cash Flows'!$D$61 Risked NPV, $MM
WEV_C_IncEUR 'Workover Cash Flows'!$D$58 Incremental oil over horizon, MSTB
WEV_C_IncNow 'Workover Cash Flows'!$D$52 Incremental first-month rate, STB/d
WEV_C_IprBase 'Workover Cash Flows'!$D$50 Candidate IPR base at common pressure, STB/d
WEV_C_NPV 'Workover Cash Flows'!$D$54 Success NPV, $MM
WEV_C_NetCash 'Workover Cash Flows'!$D$59 Incremental net cash, $MM
WEV_C_NpvFail 'Workover Cash Flows'!$D$60 Failure NPV, $MM
WEV_C_PVI 'Workover Cash Flows'!$D$57 PV/I
WEV_C_Payout 'Workover Cash Flows'!$D$55 Payout month, months
WEV_C_PcMin 'Workover Cash Flows'!$D$62 Break-even chance, %
WEV_C_PvCost 'Workover Cash Flows'!$D$56 Discounted cost, $MM
WEV_C_RateCheck 'Workover Cash Flows'!$B$69 C: type-curve rate check verdict
WEV_C_RateCheckNote 'Workover Cash Flows'!$C$69 C: type-curve rate check comment
WEV_C_UpliftMin 'Workover Cash Flows'!$D$63 Break-even uplift, STB/d
WEV_CashFlowCurve 'Workover Cash Flows'!$A$160:$D$219 Incremental monthly cash flow: first 60 months
WEV_Days 'Workover Cash Flows'!$B$31 Days per month, days/month
WEV_Dei 'Workover Cash Flows'!$B$7 Initial decline, effective secant, %/yr
WEV_Di 'Workover Cash Flows'!$B$35 Initial nominal decline, from the effective secant, 1/yr
WEV_Disc 'Workover Cash Flows'!$B$24 Discount rate, end-of-month cash flows, %/yr
WEV_Dt 'Workover Cash Flows'!$B$36 Terminal nominal decline, from the effective, 1/yr
WEV_Dterm 'Workover Cash Flows'!$B$8 Terminal decline, effective (exponential tail), %/yr
WEV_Dw 'Workover Cash Flows'!$B$46 Nominal incremental decline, 1/yr
WEV_Esc 'Workover Cash Flows'!$B$15 Escalation of prices and operating costs, %/yr
WEV_GOR 'Workover Cash Flows'!$B$9 Gas-oil ratio, constant over life, scf/STB
WEV_Gas 'Workover Cash Flows'!$B$13 Gas price (Henry Hub, 1 MMBtu per Mscf), $/MMBtu
WEV_GasDiff 'Workover Cash Flows'!$B$14 Gas differential, deducted (Waha basis), $/MMBtu
WEV_Gath 'Workover Cash Flows'!$B$23 Gas gathering and processing, $/Mscf
WEV_HorizonCheck 'Workover Cash Flows'!$B$66 Workover horizon verdict
WEV_HorizonCheckNote 'Workover Cash Flows'!$C$66 Workover horizon comment
WEV_IP 'Workover Cash Flows'!$B$5 Initial oil rate of the type curve, STB/d
WEV_LOE 'Workover Cash Flows'!$B$21 Fixed LOE, $/well-month
WEV_LOEVar 'Workover Cash Flows'!$B$22 Variable LOE per barrel of oil, $/STB
WEV_Life 'Workover Cash Flows'!$B$43 Producing life, to the economic limit or the cap, months
WEV_LifeCap 'Workover Cash Flows'!$B$4 Longest producing life of the well, months
WEV_Margin 'Workover Cash Flows'!$B$40 Operating margin per barrel of oil, net of royalty and taxes, $/STB
WEV_MoYr 'Workover Cash Flows'!$B$32 Months per year, months/year
WEV_N 'Workover Cash Flows'!$B$45 Bounded months (preview only if horizon check fails), months
WEV_NRI 'Workover Cash Flows'!$B$17 Net revenue interest (25 % royalty at 100 % WI), %
WEV_Oil 'Workover Cash Flows'!$B$11 Oil price (WTI), $/STB
WEV_OilDiff 'Workover Cash Flows'!$B$12 Oil differential, deducted (quality and transport), $/STB
WEV_PayoutMax 'Workover Cash Flows'!$B$30 Longest acceptable payout, from the workover, months
WEV_PerMM 'Workover Cash Flows'!$B$33 Dollars per million, $/MM
WEV_QLimit 'Workover Cash Flows'!$B$41 Economic-limit oil rate, fixed LOE over the margin, STB/d
WEV_Qi 'Workover Cash Flows'!$B$39 Initial oil rate, IP × type-curve factor, STB/d
WEV_Qs 'Workover Cash Flows'!$B$38 Rate at the switch over the initial rate
WEV_Reference_AfterNow 'Workover Cash Flows'!$E$53 After-workover type-curve rate, STB/d
WEV_Reference_Capex 'Workover Cash Flows'!$E$64 WI-adjusted undiscounted cost, $
WEV_Reference_Cost 'Workover Cash Flows'!$B$28 Workover cost, paid in the first month, $
WEV_Reference_ENPV 'Workover Cash Flows'!$E$61 Risked NPV, $MM
WEV_Reference_IncEUR 'Workover Cash Flows'!$E$58 Incremental oil over horizon, MSTB
WEV_Reference_IncNow 'Workover Cash Flows'!$E$52 Incremental first-month rate, STB/d
WEV_Reference_NPV 'Workover Cash Flows'!$E$54 Success NPV, $MM
WEV_Reference_NetCash 'Workover Cash Flows'!$E$59 Incremental net cash, $MM
WEV_Reference_NpvFail 'Workover Cash Flows'!$E$60 Failure NPV, $MM
WEV_Reference_PVI 'Workover Cash Flows'!$E$57 PV/I
WEV_Reference_Payout 'Workover Cash Flows'!$E$55 Payout month, months
WEV_Reference_Pc 'Workover Cash Flows'!$B$29 Chance the workover succeeds, %
WEV_Reference_PcMin 'Workover Cash Flows'!$E$62 Break-even chance, %
WEV_Reference_PvCost 'Workover Cash Flows'!$E$56 Discounted cost, $MM
WEV_Reference_RateCheck 'Workover Cash Flows'!$B$70 Reference: type-curve rate check verdict
WEV_Reference_RateCheckNote 'Workover Cash Flows'!$C$70 Reference: type-curve rate check comment
WEV_Reference_Uplift 'Workover Cash Flows'!$B$27 Incremental oil rate the workover adds at the start, STB/d
WEV_Reference_UpliftMin 'Workover Cash Flows'!$E$63 Break-even uplift, STB/d
WEV_RequestedN 'Workover Cash Flows'!$B$44 Requested months in incremental cash flow, months
WEV_SevGas 'Workover Cash Flows'!$B$19 Gas severance tax (Texas, of the gas's value), %
WEV_SevOil 'Workover Cash Flows'!$B$18 Oil severance tax (Texas, of the oil's value), %
WEV_TC 'Workover Cash Flows'!$B$10 Type-curve factor (scales the initial rate)
WEV_TLimit 'Workover Cash Flows'!$B$42 Time the decline takes to reach the limit, years
WEV_Ts 'Workover Cash Flows'!$B$37 Time the hyperbolic switches to the terminal decline, years
WEV_UpDecl 'Workover Cash Flows'!$B$26 Decline of the incremental rate, effective (exponential), %/yr
WEV_WI 'Workover Cash Flows'!$B$16 Working interest (scales costs and capital), %
WEV_b 'Workover Cash Flows'!$B$6 Arps hyperbolic exponent b
WEZ_Checks Summary!$B$15:$B$25 Every named check
WEZ_ENPV Summary!$B$10 Risked NPV, $MM
WEZ_First Summary!$B$11 First selected candidate index
WEZ_Headroom Summary!$B$8 Headroom, $
WEZ_NPV Summary!$B$9 Success NPV, $MM
WEZ_Overall Summary!$B$4 Overall verdict
WEZ_OverallNote Summary!$C$4 Overall comment
WEZ_Second Summary!$B$12 Second selected candidate index
WEZ_Spend Summary!$B$7 Spend, $
WEZ_Third Summary!$B$13 Third selected candidate index

Details

Opens inNeeds the Petroleum Office add-in: its PO functions show #NAME? without it once Excel recalculates. Needs Microsoft 365 or Excel 2024: it uses functions Excel 2016 doesn't have, such as named LAMBDAs, which show #NAME? there.
FileWorkoverEconomics.xlsx, 100 KB
CategoryEconomics
For agents and tools Descriptor (.md)
Tags:
economicsworkoverskinNPVrisk

Need a workbook we don't have? Suggest a Workbook