NPV & IRR Calculator

The problem

A&D buyers, RBL lenders, and operators need to validate well economics before they bid, lend, or sanction — and the LOI clock starts at the moment a teaser drops. Off-the-shelf NPV/IRR spreadsheets ignore decline-parameter risk, mis-handle royalty/NRI/severance, and silently flip PV10 sign when cash flow turns negative. A 2% NPV error on a $50M development is $1M in mispricing — and the credit committee will absolutely catch it when they redo the math. Without a defensible, citable PV10/IRR/payout/breakeven bridge, you lose the bid or sandbag the credit memo.

What you get

• →NPV at any user-specified discount rate — not just one number, a curve.
• →PV10 on the SEC convention so the output drops into a reserve report or 10-K appendix.
• →IRR + payout period + breakeven oil/gas price — the four numbers every credit memo needs.
• →Decline-parameter sensitivity (qi, Di, b) so you see which assumption is moving the answer.
• →Royalty / NRI / severance-tax handling baked in — no manual deck rebuilds.
• →Downloadable XLSX + one-page PDF credit-memo summary — ready to attach to a bid memo or IC deck.

Who uses this

• →A&D buyers running 5-day diligence screens between teaser and LOI.
• →RBL bankers stress-testing borrowing-base economics before semiannual redetermination.
• →Operators sanctioning AFEs and ranking development inventory before capex commitment.

Pair with