Well Economics & NPV Calculator: DCF Model, Scenario Comparison & Working Interest Sensitivity
Full-cycle well economics: 20-year DCF, NPV10/NPV15, payout period, F&D cost, oil price sensitivity ($30–$120/bbl), and three-scenario side-by-side comparison.
TAGLINE
Full-cycle well economics: 20-year DCF, NPV10/NPV15, payout period, F&D cost, oil price sensitivity ($30–$120/bbl), and three-scenario side-by-side comparison.
WHO IT'S FOR
Reservoir engineers, A&D analysts, and operations engineers evaluating well economics, justifying drilling decisions, or stress-testing projects against price and cost scenarios.
WHAT IT DOES
Builds a 20-year working-interest DCF from a hyperbolic production decline profile. Calculates annual revenue, royalty, LOE, G&A, severance tax, capital, and net cash flow. Outputs NPV10, NPV15, payout period, EUR, and F&D cost. Provides an oil price sensitivity table ($30–$120/bbl in $10 steps), a three-scenario (Low/Base/High) side-by-side comparison, and a working interest sensitivity analysis (WI 25%–100%).
TABS INCLUDED (9)
• Instructions • Assumptions — qi, Di, b, oil price, gas price, royalty, NRI, WI, LOE, G&A, capex • Annual Cash Flow — year-0 capital, then 20 years of revenue, royalty, LOE, G&A, severance tax, NCF and cumulative NCF • NPV Sensitivity — NPV10 across 7 oil prices × 5 discount rates • Payout & Returns — year-by-year discounted NCF and NPV10 running total; NPV10, NPV15, custom discount rate, IRR, payout • F&D & Breakeven — F&D cost = capex/EUR; breakeven oil price for NPV10=0 • Economics Summary — one-page KPI dashboard • Scenario Comparison — Low ($40/bbl) / Base ($72/bbl) / High ($100/bbl) NPV10, payout, IRR; $10-step price table • Working Interest Sens — WI 25%–100%: net capex, NPV10, IRR
KEY FEATURES
• Scenario comparison: NCF, cumulative NCF, NPV10, payout for three price scenarios • WI sensitivity: NRI = WI × (1 − royalty − ORRI); net capex and NPV10 at each WI level • Oil price table: 10 prices from $30 to $120/bbl; green/amber/red NPV10 colour coding • All economic assumptions in clearly labelled yellow cells; formula-driven
TECHNICAL SPECS
• Excel 2016+ compatible • 900+ formulas across 9 tabs • Sample: qi=1,850 BOPD, Di=45%/yr, b=0.80, $72/bbl oil, 75% WI, $6.5MM D&C • MDT color scheme
ABOUT RESERVOIR RISK SOLUTIONS
Built by petroleum engineers for petroleum engineers. All workbooks require only Microsoft Excel (2016+) — no plugins, no subscriptions. www.reservoir-risk-solutions.com
What you get
- Instant workbook access after payment in your Excel Library
- Formula-driven worksheet designed for petroleum workflows
- No recurring fees and no plugin requirements
Licence
Single-user licence: the purchaser may use and modify this workbook for their own work, including work for their employer and clients. It may not be resold, shared publicly or redistributed as a template. Results are engineering estimates for screening and must be checked by a qualified professional before they are relied on.
FAQ
Is this a one-time purchase?
Yes. Each workbook is sold as a one-time purchase with no recurring subscription.
How do I access purchased files?
After checkout, your file appears in Excel Library under your account for download.
Do these templates require macros or plugins?
No. Templates are designed for Excel 2016+ and do not require VBA macros or external add-ins.
