Oil and Gas Exploration and Production (E & P) Company Equity Valuation Spreadsheet. This MS Excel equity valuation model is an Equity Valuation Spreadsheet with added complexity to be geared specifically towards Oil Exploration and Production 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. The oil company valuation model includes:
- Income Statement: Oil and gas production revenues, Other revenues, Total revenues, Depreciation, depletion and amortization, Production costs, Selling, general and administrative expenses, Exploration costs, Dry hole and impairment, Operating Income, Amortization of goodwill, Interest expense, net, Income before taxes and extraordinary items, Provision for income taxes, Income before extraordinary items, Extraordinary items, Net income, Shares outstanding, Earnings per share (EPS), before extraordinary items, Earnings per share (EPS), Dividends, Exercise of Stock Options, Shares issued, Foreign currency adjustment, Common Size Statement (% Of Revenues)
- Balance Sheet: Assets, Operating cash, Accounts receivable, Other current assets, Total current assets, Oil and gas reserves, on the basis of, successful efforts accounting:, Proved properties, Unproved and properties under development, Other property and equipment, Accumulated depreciation, depletion and amortization, Net property, plant and equipment, Other assets, Goodwill, Discontinued operations, Total Assets, Liabilities and Shareholders' Equity, Short-term debt and current portion of long-term debt, Accounts payable, Accrued liabilities, Total current liabilities, Long-term debt, Other long-term liabilities, Deferred income taxes, Total liabilities, Total shareholders' equity, Total liabilities and equity, Common-Size Balance Sheet Data
- WACC Calculation: Expected return on stock market, Risk free rate of return, Beta, Total Debt, Total Equity, Debt (percent of total capitalization), Equity (percent of total capitalization), Cost of debt, Cost of equity, Weighted average cost of capital (WACC)
- DCF Valuation: Cash flow, Discounted cash flow (at WACC), Discounted cash flow SEC Basis (at 10%), WACC, Perpetual future growth rate, PV of terminal value, Present value of firm, Less long-term debt, Value of equity, Per share equity value
- Performance Ratios: Ending share price, Price/Earnings ratio, Price/Book ratio, Price/Sales ratio, Price/EBIT ratio, Asset turnover ratio, Equity capital turnover ratio, Sales per share, Cash flow per share, Reserves, Proved reserves oil, condens, ngl (MBbls), Proved reserves nat. gas (MMcf), Proved reserves (BOE), Yearly production (BOE), Reserve production ratio (reserves/production), Reserves per share (BOE), E&P Operating Data, Sale price oil (barrel), Sale price natural gas (McF), Lifting costs/BOE production, Reserve Replacement, New reserves oil, condens, ngl, New reserves natural gas, Total new reserves (BOE)
Get It (Pricing is available on the next page)(Updated on 2023-06-01) |