Home > Excel Business Solutions > Business Finance > Business Valuation > Oil Company Valuation Share

Oil Company Valuation

Excel oil company valuation for business valuation


Excel Oil Company Valuation

Rate this solution:
(1.6/5 from 7 votes)
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

Price: USD 169.95
(Updated on 2016-05-01)

Related Excel Solutions for Oil Company Valuation

Investment and Business ValuationBusiness Valuation  Equity Valuation ModelBusiness Valuation

Latest Reviews for Excel Oil Company Valuation:

Share your opinion with others: Create Review
Reviewed by ebenezer on
This will help professionals who digest investment data in the oil and gas company.


Browse Main Excel Solution Categories

Business Finance Financial Markets Operations Management Excel Productivity

Additional Excel business solutions are categorized as and the . Further solutions proposed for specific user requirements can be either found in the Excel Help Forum or proposed as a project to the Excel freelance community.