Software Search, Categories and Specials

OzGrid.comMicrosoft Excel Templates, Training and Add-ins, Business Software and more!

 Oil and Gas E&P Company Equity Valuation Model. Discounted Cash Flow Analysis.

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS


The oil and gas E&P company valuationspreadsheet is more complex than the basic firm valuation model and is geared specifically towards E&P companies. The model allows the user to input expected oil and gas prices and vary production growth by year and commodity. In addition to general performance measures, E&P industry-specific ratios are also calculated and included.

Oil and Gas E&P Company Equity Valuation Model

Partial Screenshot of Discounted Cash Flow Analysis

Discounted at WACC


SEC Basis (Discount rate=  10%)

PV of terminal value: 1,237,195     PV of terminal value 710,631
Present value of firm: 2,078,450     Present value of firm 1,471,365
Less long-term debt: (246,230)     Less long-term debt (246,230)
  Value of equity: 1,832,220     Value of equity 1,225,135
  Per share equity value: 55.01     Per share equity value


Back to:The oil and gas E&P company valuation