LOE & Cash Flow Model — Monthly Operating Expenses, NOI Margin & Basin Benchmarking
Track monthly LOE by five cost categories, calculate NOI margin, and benchmark your $/BOE against Permian, Eagle Ford, and DJ Basin industry medians.
TITLE
LOE & Cash Flow Model — Monthly Operating Expenses, NOI Margin & Basin Benchmarking
PRICE
$89 USD — one-time purchase
TAGLINE
Track monthly LOE by five cost categories, calculate NOI margin, and benchmark your $/BOE against Permian, Eagle Ford, and DJ Basin industry medians.
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). Calculates total LOE $/BOE, net operating income, and NOI margin % each month. Benchmarks your $/BOE against industry medians for six major US basins. Classifies each month's NOI margin as Strong (>60%), Good (40–60%), Marginal (20–40%), or Weak (<20%).
TABS INCLUDED (11)
• Instructions • Monthly Operations — BOE/d production per month • LOE Breakdown — 5-category LOE with $ and $/BOE per month • Monthly Cash Flow — revenue, royalty, LOE, G&A, severance tax, NOI • Annual Summary — total production, avg LOE $/BOE, total NOI, NOI/BOE • Monthly Inputs — price and cost assumption inputs • LOE by Category — LOE stacked bar chart data • Revenue & NOI — monthly NOI and cumulative NOI • Dollar per BOE Analysis — $/BOE trend with threshold flags • Benchmark Comparison — your $/BOE vs other basin averages (original) • LOE Benchmarking — full basin comparison vs Permian Midland/Delaware, Eagle Ford, DJ Basin, Bakken, Anadarko; NOI margin table
KEY FEATURES
• Basin benchmarks: Permian Midland $9.0, Permian Delaware $10.4, Eagle Ford $9.6, DJ Basin $8.3, Bakken $11.7/BOE (2023-2024 data) • NOI margin: 12-month table with Strong/Good/Marginal/Weak flag • LOE $/BOE threshold flags: green (<$12), yellow ($12–$15), red (>$15) — all adjustable
TECHNICAL SPECS
• Excel 2016+ compatible • 309 formulas across 11 tabs • 12-month dataset pre-loaded (19,200 BOE/d, ~$12.2/BOE total LOE) • MDT color scheme
SHOP COPY
11-tab LOE and cash flow workbook: 5-category monthly LOE, NOI margin analysis, NOI classification (Strong/Good/Marginal/Weak), and $/BOE vs six US basin medians.
SUGGESTED TAGS
LOE, lease operating expense, cash flow, NOI margin, operating costs, basin benchmark, Permian, Eagle Ford, monthly model, Excel template, petroleum engineering
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.
