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