Upstream Oil & Gas Company Financial Model

Description
Upstream Oil & Gas Financial Model in Excel. 3 years historical, 20-year forecast.

Build a complete upstream oil and gas valuation model with this fully integrated Upstream Oil & Gas Financial Model in Excel, designed for exploration and production (E&P) companies, investors, asset teams, corporate development professionals, and investment analysts. The model connects reserves, production, pricing, operating costs, capital expenditure, fiscal terms, financial statements, cash flow, DCF valuation, and NAV in one professional Excel workbook.

Tab Highlights

• Cover & Control — Professional model overview, version control, navigation and key model switches.
• Assumptions — Centralized commodity prices, FX, inflation, ownership, tax, production and cost assumptions.
• Timeline — 3 years of monthly historical data plus 20 years of monthly forecast periods.
• Resources & Reserves — 1P, 2P, 3P reserves and 2C/3C resources with automated reserve roll-forwards.
• Production — Field-level oil, gas and condensate production with ramp-up, plateau and decline-curve forecasting.
• Pricing — Brent, Henry Hub and field-specific differentials driving realized commodity prices.
• Revenue — Fully integrated oil, gas and condensate revenue by field and commodity.
• Opex — Fixed and variable operating costs, transportation and G&A with working-interest adjustments.
• Capex — Exploration, appraisal, development and abandonment expenditure by asset.
• DD&A / Depletion — Units-of-production depletion linked directly to 2P reserves and production.
• Working Capital — Receivables, payables, inventory and changes in net working capital.
• Fiscal & Tax — Royalty & Tax vs. PSC toggle, including royalties, production taxes, cost recovery and profit splits.
• Project Economics — Asset-level NPV, IRR, payback and free cash flow analysis.
• Corporate Financials — Integrated P&L, cash flow statement and balance sheet.
• Debt Financing — Revolving credit facility, drawdowns, repayments, cash sweep and interest calculations.
• DCF — Separate Project DCF and Corporate DCF with NPV, enterprise value, equity value and sensitivity analysis.
• Valuation — NAV, enterprise value, equity value, value per share and key valuation multiples.
• Scenarios & Sensitivities — Low / Base / High cases for oil price, gas price, production, Capex, Opex, FX and fiscal terms.
• Checks — Automated balance sheet, reserves, cash, debt, fiscal and model-integrity checks.
• Outputs Dashboard — Executive summary of reserves, production, revenue, EBITDA, FCF, NAV, equity value, cash and debt. 

This 20-Year 3-Statement Upstream Oil and Gas Refinery Financial Model delivers a granular view of performance, enabling data-driven decision-making and strategic planning in a complex and volatile industry.