Year 1
- Gross oil
- 10,000 bbl
- Net revenue
- $560,000
- Net OPEX
- $175,000
- Net cash flow
- $385,000
- Present value at 10%
- $350,000
Calculate NPV, IRR, and payout instantly. Run sensitivity scenarios and generate professional reports for investment decisions.
MCPRun this workflow from Claude or Cursor. Connect Petrolytx in one secure sign-in.Connect AI →Worked example · Three years
Assumed oil price: $70/bbl. Initial capital: $600,000. Synthetic inputs, with no taxes or terminal value.
Built by reservoir engineers, for petroleum engineers
Worked example · Oil well cash flow
A production forecast becomes an economic case when you apply prices, ownership, costs and cash-flow timing. This hypothetical case produces a $178,775 NPV at a 10% annual discount rate.
For year 1, the revenue share uses NRI. Operating costs and capital use WI. Applying 80% to both revenue and costs would overstate this owner’s cash flow.
Revenue = 10,000 × $70 × 80% = $560,000
OPEX = (10,000 × $15 + $25,000) × 100% = $175,000
Year 1 cash flow = $560,000 − $175,000 = $385,000
All figures are USD. The volume assumptions are annual totals, separate from the DCA tutorial. No gas or NGL revenue, taxes, transport, G&A, later capital, abandonment cost, inflation or terminal value is included.
NPV = −$600,000 + $385,000 / 1.10 + $303,000 / 1.10² + $237,400 / 1.10³
$178,775 over this three-year horizon
Undiscounted net cash after the initial capital is $325,400. With the stated year-end payment convention, cumulative cash turns positive at the end of year 2. Monthly payments would change the present value and payout timing. Calculations use unrounded values; displayed dollars are rounded.
Hold volumes, costs and ownership constant and change only the flat oil price. These prices are scenarios, not market quotes or forecasts.
| Assumed oil price | NPV |
|---|---|
| $50/bbl | -$149,399 |
| $70/bbl | $178,775 |
| $90/bbl | $506,950 |
A positive NPV means the modeled cash flows exceed the initial investment after discounting at the chosen rate. It does not establish the well’s market value. Add the actual fiscal terms, decline uncertainty, future costs and production beyond year 3 before evaluating a real investment.
Method reference: NIST’s guide to discounting, NPV and payback. The oil-well inputs and calculations here are Petrolytx’s illustrative example.
Complex Excel models prone to formula errors
Validated calculations with audit-ready documentation
Hours to run sensitivity analysis
Built-in sensitivity analysis on key economic drivers
Disconnected forecasts and economics
Integrated decline + economics in one platform
No standardization across projects
Consistent methodology for all evaluations
Manual report generation
Export saved scenario summaries to CSV or a selected scenario to PDF
Can't compare scenarios easily
Side-by-side scenario comparison dashboard
Everything you need for rigorous economic evaluation
Calculate Net Present Value at any discount rate. Get IRR and payout period for single wells or scenarios.
Monthly cash flow projections with revenue, OPEX, CAPEX, taxes, and net cash flow. Visualize breakeven and payout timing.
Tornado charts show which variables matter most. Run price, cost, and production sensitivities with one click.
Create and compare multiple economic scenarios with different price, cost, and production assumptions.
Use flat prices or custom price decks with escalation. Configure different prices for oil, gas, and NGL streams.
Download saved scenario summaries as CSV for further analysis, or export a PDF report for a selected saved scenario.
NPV (at any discount rate), IRR, payout period, and monthly cash flow projections. Built-in sensitivity analysis on prices, costs, and decline parameters.
Configure working interest, net revenue interest, oil and gas severance taxes, and ad valorem taxes for a scenario. Verify the terms against the well's actual ownership and fiscal requirements before using the results.
Create multiple scenarios with different price, cost, or production assumptions and compare side-by-side. Rank wells by NPV, IRR, or other metrics to optimize capital allocation.
Download saved scenario summaries as CSV, or export a PDF report for the selected saved scenario. Review the saved inputs and results before sharing an evaluation.
Start free. Upgrade when you need more.
Connect production forecasts to prices, ownership, and costs. Review your assumptions and compare economic scenarios in one place.
Start 14-Day TrialPayment method required to start your 14-day trial.