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
- Category: Business > Investment Tools
- Publisher: The Spreadsheet Store
- License: Free Trial
- Price: $169.95
- Version: 2.0
- Platform: windows