Oil&Gas E&P Co Valuation Model for Excel 2.0
his Microsoft Excel workbook accepts input from publicly available 10-K reports in order to calculate the total and per-share value of an oil and gas e&p company. 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. Includes: Income Statement, Balance Sheet, Weighted-Average Cost of Capital Calculator, Oil Industry-Specific Discounted Cash Flow (DCF) Analysis, Oil Industry-Specific Ratio Analysis. Developed by CFA Charterholder.