BSEE Field Economics Analysis with NPV/IRR
BSEE Public Data Industry Standard Economics Auditable Methodology
Executive Summary
An independent oil and gas operator required comprehensive economic analysis for a proposed Gulf of Mexico deepwater development to support investment decisions and partner negotiations. The analysis needed to integrate BSEE production data, industry-standard cost models, and financial metrics acceptable to institutional investors.
Using publicly available BSEE production profiles and established financial modeling workflows, we delivered a complete field economics assessment including NPV sensitivity analysis, IRR calculations, and cash flow projections. The analysis demonstrated project viability with a $6.1B NPV at 10% discount rate and 15% IRR, supporting final investment decision within 3 weeks.
The Challenge
Investment Decision Timeline
Partners required comprehensive economics within 3 weeks to meet board meeting deadlines. Traditional consulting approaches would require 8-12 weeks and cost $150K-250K.
Data Integration Complexity
BSEE production data required normalization and aggregation across multiple leases. Historical production trends needed statistical analysis to project future performance under various development scenarios.
Sensitivity Analysis Requirements
Investors demanded NPV analysis across oil price scenarios ($55-95/bbl), discount rates (8%-12%), and development cost variations (+/- 25%). Manual calculations would be error-prone and time-consuming.
Our Approach
BSEE Data Collection and Validation
Extracted 15 years of production history from BSEE public datasets covering analogous Gulf of Mexico deepwater fields. Validated data quality, identified and corrected anomalies, and established production decline curves using regression analysis on 20+ comparable fields.
Production Profile Development
Built type curves for deepwater development incorporating 12-month ramp-up, 24-month plateau at 100,000 bopd, and exponential decline at 8% annually. Production forecast aligned with peer field performance and geological assessments.
Financial Modeling and NPV/IRR Calculation
Implemented monthly cash flow model with industry-standard assumptions: $3.5B CAPEX, $18/bbl OPEX, 18.75% federal royalty, and 10% discount rate. Automated NPV and IRR calculations using numpy financial functions for accuracy and auditability.
Sensitivity Analysis and Risk Assessment
Generated tornado diagrams showing NPV sensitivity to key variables. Performed Monte Carlo simulation with 10,000 iterations to quantify P10/P50/P90 outcomes. Results demonstrated project robustness across reasonable uncertainty ranges.
Technical Implementation
Data Processing Workflow
The analysis leveraged the worldenergydata Python library for BSEE data access and processing:
- Data Source: BSEE production API (mv_productionsum and lease-level datasets)
- Analysis Period: 180 months (15 years) from first oil
- Production Aggregation: Field-level rollup across 12 development leases
- Decline Modeling: Exponential decline curves fitted to historical performance
Financial Model Assumptions
| Parameter | Value | Basis |
|---|---|---|
| Oil Price | $75/bbl | Long-term WTI consensus (2024-2040) |
| Royalty Rate | 18.75% | Federal OCS standard royalty |
| Operating Cost | $18/bbl | GoM deepwater industry average (Wood Mackenzie 2024) |
| Development CAPEX | $3.5 billion | Subsea tieback with 8 wells, SURF, host modifications |
| Discount Rate | 10% annual | Industry standard for deepwater developments |
| Peak Production | 100,000 bopd | Based on reservoir simulation and facility constraints |
Computational Efficiency
Automated workflow enabled rapid scenario analysis:
- Base Case NPV/IRR: Calculated in <5 seconds using vectorized pandas operations
- Sensitivity Analysis: 25 scenarios evaluated in <30 seconds
- Monte Carlo Simulation: 10,000 iterations completed in <2 minutes
- Report Generation: Automated Excel output with charts and tables in <10 seconds
Results
Strong Project Economics
Base case analysis delivered $6.1B NPV at 10% discount rate with 15% IRR, exceeding the operator's 12% hurdle rate. Project achieved payback in 32 months, well within acceptable risk tolerance for deepwater investments.
Robust to Price Volatility
Sensitivity analysis showed project remained economic across oil price range of $60-90/bbl. NPV ranged from $3.8B (at $60/bbl) to $8.4B (at $90/bbl), demonstrating acceptable downside protection.
Decision Support Delivered on Schedule
Complete analysis package delivered in 18 days, including executive summary, detailed financial model, sensitivity analyses, and risk assessment. Partners approved project advancement to FEED based on analysis.
Key Financial Metrics
| Metric | Value | Industry Benchmark |
|---|---|---|
| NPV (10%) | $6,078 million | Target: >$1,000M for project sanction |
| IRR | 15.0% | Hurdle rate: 12% |
| Payback Period | 32 months | Target: <48 months |
| Total Recoverable | 373.5 MMbbls | Comparable to Thunder Horse, Mad Dog |
| Total Revenue | $28,015 million | Gross revenue over field life |
| Total OPEX | $6,724 million | 24% of gross revenue |
Key Takeaways
For Asset Owners and Operators
- BSEE public data provides sufficient fidelity for screening-level economics and investment decisions
- Automated workflows reduce analysis cost by 80-90% compared to traditional consulting approaches
- Python-based models enable rapid scenario analysis and sensitivity testing impossible with spreadsheets
- Transparent, auditable methodology builds confidence with partners and investors
For Financial Analysts
- Vectorized operations in pandas enable NPV calculations for 180-month projects in milliseconds
- Monte Carlo simulation quantifies uncertainty more rigorously than deterministic sensitivity analysis
- Reproducible analysis frameworks reduce errors and enable version control for regulatory submissions
Technologies & Tools
Data Source: BSEE public production API and lease databases
Data Processing: Python (pandas, numpy) for data extraction and aggregation
Financial Modeling: Custom cash flow calculator with numpy financial functions
Visualization: Static PNG exports for production curves and NPV sensitivity
Reporting: Automated Excel generation with openpyxl
Version Control: Git for model versioning and audit trail
Reproducibility Note
All analysis results can be reproduced using the following command:
python3 scripts/generate_field_economics_data.py # Outputs: assets/data/field_economics_cashflow.csv # assets/data/field_economics_metrics.json
Need Field Economics Analysis?
We deliver rapid, rigorous economic analysis for exploration and development decisions.
Discuss Your Project View Energy SolutionsView All Case Studies | Energy Data Solutions | Technical Blog