Oil&Gas E&P Co Valuation Model for Excel 2.0

License: Free Trial ‎File size: 139.78 KB
‎Users Rating: 3.9/5 - ‎7 ‎votes

This 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.

VERSION HISTORY

  • Version 2.0 posted on 2007-06-03

Program Details