Net Revenue Interest & Royalty Burden Calculator: WI/ORRI/NRI Split & Burden Stack
Calculate NRI from working interest and the burden stack (lessor royalty and ORRIs), and split revenue across a full deck that totals 100%, without a full DCF model.
TAGLINE
Calculate NRI from working interest and the burden stack (lessor royalty and ORRIs), and split revenue across a full deck that totals 100%, without a full DCF model.
WHO IT'S FOR
Landmen, division order analysts, and A&D teams calculating net revenue interest and burden stacks.
WHAT IT DOES
Adds the lessor royalty and ORRIs as fractions of gross (8/8ths) production, calculates NRI for the subject working interest, and shows the burden layers in a stacked chart that closes to 100% (including the other WI owners' share). Splits revenue across a deck of the lessor royalty, the ORRIs and four WI owners, with a check that decimals sum to 1.0000. A crossplot compares each owner's WI with its NRI against a 1:1 line. Inputs are validated as 0–1 decimals.
TABS INCLUDED (7)
• Instructions & Legend • Burden Input — subject WI, lessor royalty, two ORRIs • NRI Calculation — NRI, lease NRI (8/8ths), burdens borne by this WI • Burden Stack Visual — burden layers to 100%, with the Burden Stack Chart • Multi-Party Split — revenue deck for lessor royalty, ORRIs and WI owners, totalling 100%, with chart • WI vs NRI Crossplot — WI vs NRI by owner with 1:1 line • Summary — subject WI and NRI, total burdens, WI total and revenue deck checks
KEY FORMULAS
NRI = WI × (1 − royalty − ΣORRI) (burdens add); lease NRI = 1 − burdens; owner revenue = decimal × gross revenue
TECHNICAL SPECS
• Excel 2016+; 60+ formulas; sample 4-owner split plus royalty and ORRIs • Professional colour scheme throughout • Yellow cells = inputs; white cells = formulas
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.
