LOE & Cash Flow Model: Monthly Operating Expenses, NOI Margin & Basin Benchmarking
Track monthly LOE by five cost categories, split fixed and variable cost, calculate NOI and NOI margin, and compare your $/BOE with an illustrative seven-basin benchmark table.
TAGLINE
Track monthly LOE by five cost categories, split fixed and variable cost, calculate NOI and NOI margin, and compare your $/BOE with an illustrative seven-basin benchmark table.
WHO IT'S FOR
Production engineers, lease operators, and operations analysts who need to monitor LOE performance, benchmark operating costs against basin peers, and calculate monthly net operating income margin.
WHAT IT DOES
Tracks 12 months of lease operating expenses across five categories (fuel, chemicals, water disposal, workovers, other), with every input on one tab (Monthly Operations). Converts monthly oil and gas to BOE (oil + gas/6), calculates LOE $/BOE, the working-interest owner's cash flow (revenue, royalty burden, net revenue, LOE, G&A, severance tax, NOI) and NOI margin each month, and splits LOE into fixed ($/month) and variable ($/BOE) cost. Compares your production-weighted $/BOE with an illustrative table of seven basins (replace it with your own peer data). Classifies each month's NOI margin as Strong (>60%), Good (40–60%), Marginal (20–40%), or Weak (<20%).
TABS INCLUDED (11)
• Instructions • Monthly Operations — all inputs: monthly oil and gas volumes, LOE $/BOE by category, prices, WI/NRI, severance rate, LOE target and ceiling, oil differential, G&A • LOE Breakdown — 5-category LOE with $ and $/BOE per month and an OK/WATCH/HIGH flag • Monthly Cash Flow — revenue, royalty, net revenue, LOE, G&A, severance tax, NOI • Annual Summary — total production, weighted LOE $/BOE, NOI, NOI margin, flagged months, fixed/variable LOE split • Monthly Inputs — daily rates and revenue derived from Monthly Operations (no entry needed) • LOE by Category — LOE stacked bar chart data • Revenue & NOI — monthly NOI and cumulative NOI • Dollar per BOE Analysis — annual cost and $/BOE by category vs benchmark, with flags • Benchmark Comparison — your weighted $/BOE vs basin averages, target and ceiling • LOE Benchmarking — illustrative table for Permian Midland/Delaware, Eagle Ford, DJ Basin, Bakken, Anadarko and Haynesville; 12-month NOI margin table
KEY FEATURES
• BOE = oil + gas/6; LOE $/BOE production-weighted over the year • Fixed/variable split: choose fixed or variable per category; variable cost reported in $/BOE, fixed in $/month • NOI margin: 12-month table with Strong/Good/Marginal/Weak flag • LOE $/BOE flags: OK below the target ($12), WATCH up to the ceiling ($15), HIGH above; both adjustable • Basin table: illustrative values for seven basins, for replacement with your own peer data
TECHNICAL SPECS
• Excel 2016+ compatible • 800+ formulas across 11 tabs • 12-month dataset pre-loaded (about 19,200 BOE per month, ~640 BOE/d; ~$12.35/BOE weighted LOE) • 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.
