Oil&Gas E&P Co Valuation Model for Excel

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. Calculates a total and per-share equity value.

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.

Download

System Requirements:

Win 3.1x, Win95, Win98, WinME, WinNT 3.x, WinNT 4.x, Windows2000, WinXP, Windows2003, Windows Vista Starter, Windows Vista Home Basic, Windows Vista Home Premium, Windows Vista Business, Windows Vista Enterprise, Windows Vista Ultimate, Windows Vista Home Basic x64, Windows Vista Home Premium x64, Windows Vista Business x64, Windows Vista Enterprise x64, Windows Vista Ultimate x64, Unix, Linux, Mac OS X, Mac OS X 10.1, Mac OS X 10.2, Mac OS X 10.3, Mac OS X 10.4, Mac OS X 10.5, Mac Other, Windows CE, Pocket PC, Windows Mobile 2003, Windows Mobile 2005

Version:

2.0

Last updated:

2010-05-06 01:20:33

Publisher:

The Spreadsheet Store

Homepage:

http://www.spreadsheetstore.com

File name:

File size:

0.13MB

License:

Commercial

Price:

169.95

You may also like...