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. Income Statement.

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.

Back to: Excel Templates | Financial Software | Software Categories | Search All Software

Oil and Gas E&P Company Equity Valuation Model

Screenshot of Income Statement

    Current Year   Oil and Gas Revenues
1994 1995 1996   1994 1995 1996
Oil and gas production revenues 173,556 157,459 204,142

     Oil production (Bbls per day)

 11,100 11,786 11,968
Other revenues 52 100 (165)

     Avg oil price

 16.08 17.80 22.12
Total revenues 173,608 157,559 203,977

     Oil revenues

 65,141 76,557 96,908
     

 

      
Depreciation, depletion and amortization 63,308 68,489 61,857

     Natural gas production (Mcf per day)

 144,800 121,000 107,700
Production costs 29,768 35,071 37,628

     Avg. natural gas price

 1.88 1.63 2.40
Selling, general and administrative expenses 15,984 16,400 18,028

     Natural gas revenues

 99,093 72,032 94,589
Exploration costs 5,257 7,468 16,777

 

      
Dry hole and impairment 7,088 6,703 8,579

     Natural gas liquids production (Bbls per day)

 2,222 1,998 2,173
Operating Income 52,203 23,428 61,108

     Avg natural gas liquids price

 11.33 11.10 14.92
     

     Natural gas liquids revenues

 9,189 8,097 11,867
Amortization of goodwill 0 0 0

 

      
Interest expense, net 9,312 9,307 8,727

     Other net oil and gas revenues

 133 773 778
Income before taxes and extraordinary items 42,891 14,121 52,381        
             
Provision for income taxes (15,517) (4,891) (18,800)        
Income before extraordinary items 27,374 9,230 33,581        
Extraordinary items (307) 0 (821)        
Net income 27,067 9,230 32,760        
             
Shares outstanding 32,810 32,991 33,306        
             
Earnings per share (EPS)              
before extraordinary items 0.83 0.28 1.01        
             
Earnings per share (EPS) 0.82 0.28 0.98        
             
Dividends (1,966) (3,946) (3,979)        
Exercise of Stock Options 5,133 2,387 5,198        
Shares issued 0 0 1,572        
Foreign currency adjustment 0 0 23        
             
             
COMMON-SIZE STATEMENT (% of Revenues)        
             
1994 1995 1996        
Oil and gas production revenues 99.97% 99.94% 100.08%        
Other revenues 0.03% 0.06% -0.08%        
Total revenues 100.00% 100.00% 100.00%        
             
Depreciation, depletion and amortization 36.47% 43.47% 30.33%        
Production costs 17.15% 22.26% 18.45%        
Selling, general and administrative expenses 9.21% 10.41% 8.84%        
Exploration costs 3.03% 4.74% 8.22%        
Dry hole and impairment 4.08% 4.25% 4.21%        
Operating Income 30.07% 14.87% 29.96%        
             
Amortization of goodwill 0.00% 0.00% 0.00%        
Interest expense, net 5.36% 5.91% 4.28%        
Income before taxes and extraordinary items 24.71% 8.96% 25.68%        
             
Provision for income taxes -8.94% -3.10% -9.22%        
Income before extraordinary items 15.77% 5.86% 16.46%        
Extraordinary items -0.18% 0.00% -0.40%        
Net income 15.59% 5.86% 16.06%        

 

 

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