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.
TITLE
Well Economics & NPV Calculator — DCF Model, Scenario Comparison & Working Interest Sensitivity
PRICE
$99 USD — one-time purchase
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 — 20-year annual NCF, cumulative NCF, and NPV10 running total • NPV Sensitivity — NPV10 across 7 oil prices × 5 discount rates • Payout & Returns — year-by-year discounted NCF; NPV10, NPV15, custom disc rate • 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, approximate IRR
KEY FEATURES
• Scenario comparison: NCF, cumulative NCF, NPV10, payout for three price scenarios • WI sensitivity: NRI = WI × (1 − royalty); 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 • 400 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
SHOP COPY
9-tab well economics workbook: 20-year DCF, NPV10/NPV15, payout, F&D cost, $30–$120/bbl price sensitivity, Low/Base/High scenario comparison, and WI 25–100% sensitivity.
SUGGESTED TAGS
well economics, NPV, DCF, F&D cost, payout, IRR, oil price sensitivity, working interest, scenario comparison, Excel template, petroleum engineering, A&D
ABOUT RESERVOIR RISK SOLUTIONS
Built by petroleum engineers for petroleum engineers. All workbooks require only Microsoft Excel (2016+) — no plugins, no subscriptions. reservoirrisksolutions.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
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.
