Oil and Gas Investor Super Pack for Excel - Business Valuation Software at The Spreadsheet Store
  Microsoft Excel templates at The Spreadsheet Store

Excel Templates, Open Office Templates, Downloadable Spreadsheet Templates

You are Here: Excel TemplatesExcel Templates Value Packages → Oil and Gas Investor Super Pack for Excel

  Home| Excel Templates| Custom Spreadsheet Design| Support and FAQs    


 





Oil and Gas Investor Super Pack for Excel


Oil and Gas Investor Super Pack for Excel

Oil and Gas Investor Super Pack for Excel

E-mail this product to a friend E-mail this product to a friend



The Oil and Gas Investor Super Pack for Excel contains four of our best-selling products: the Oil and Gas E&P Company Equity Valuation Model for Excel, the Real Estate Valuation Tool for Excel, the Loan Calculator for Excel and the Fed Valuation Model for Excel. It is an excellent resource for professional and amateur investors.

The Oil and Gas E&P Company Equity Valuation Model for Excel is an "out-of-the-box" professional valuation model tailored to analyzing and valuing exploration and production companies. It was developed by a CFA charterholder in order to provide oil and gas investors a way to value the equity of E&P companies directly (based on discounted cash flows) rather than valuing the assets and somehow extrapolating an approximate equity value from thin air. It is designed to accept information from publicly-available 10-K reports in order to calculate the total and per-share value of an oil and gas E&P business. The model includes a basic and common-size income statement and balance sheet, an easy-to-use cost of equity and WACC calculator, a detailed oil industry-specific ratio analysis and a comprehensive oil industry-specific discounted cash flow (DCF) analysis. The DCF analysis calculates the per-share value based on both the weighted -average cost of capital and the SEC basis. Cells requiring user input are clearly highlighted, making valuations very easy to perform.

The Real Estate Valuation Tool for Excel calculates and analyzes expected cash flows from one or more real estate investments. It can be used to evaluate a single real estate investment or to compare one property to another. Rather than relying on subjective market factors as you might if you were looking to pay the lowest price for your primary residence, the Real Estate Valuation Tool for Excel values the discounted cash flows generated by the property. This is an excellent way to compare one investment property to another.

The Loan Calculator for Excel is a Microsoft Excel spreadsheet designed for quick and easy analysis of the effect of a loan's terms on the borrower's payment obligations. The spreadsheet is fully-customizable and easy-to-use. Simply enter the principal amount, interest rate, payment frequency and the term (length) of the loan and a payment table is automatically generated. The table automatically calculates and shows the breakdown of each payment between principal and interest and displays a running total of the balance that will be owed after each payment. It can accommodate loans with up to 1,000 payment periods and users may enter extra payments in any payment period.

The Fed Valuation Model for Excel contains the "Fed Valuation Model," long used by the Federal Reserve Board of Governors to measure stock market over- or under-valuation. The spreadsheet is pre-loaded with data from 1988 through the most recent quarter-end and contains room for additional data and/or estimates through 2025. This is a great way to recognize trends in the value of the stock market.

Date and number fields in all of the included spreadsheets may be re-formatted by the user (using Excel's built-in formatting capabilities) to accommodate non-US conventions.

The Oil and Gas Investor Super Pack for Excel is an excellent resource for both professional and amateur investors interested in valuing oil and gas E&P companies.

These spreadsheets were developed by a CFA charterholder. 
  • Save time by using pre-designed templates as a basis for your analyses and valuations.
  • Value the equity of an exploration and production company, rather than just the assets. This is valuable if you are deciding whether to buy stock in the company. If the assets aren't generating cash flow, the equity may be worthless.
  • Reduce formula errors caused when practitioners try to build models from scratch. The models are pre-constructed by a financial professional and calculations are already done for you.
  • Save money by spending your time on running your business or analyzing the results of the valuations rather than spending countless hours building models from scratch.
  • Date and number fields in all of the included spreadsheets may be re-formatted by the user (using Excel's built-in formatting capabilities) to accommodate non-US conventions.
  • Excellent resource for both professional and amateur investors interested in valuing oil and gas E&P companies.
  • Spreadsheets were developed by a financial professional (CFA charterholder).
Click the thumbnails below for partial screenshots of the Oil and Gas Investor Super Pack for Excel. If the expanded image is blurry, click on it to zoom in.
Oil Industry-specific DCF analysis
Oil Industry-specific DCF Analysis
Oil Industry-specific ratio analysis
Oil Industry-specific Ratio Analysis
Income Statement Template
Income Statement
Common-size Income Statement
Common-size Income Statement
Balance Sheet Template
Balance Sheet
Common-size Balance Sheet
Common-size Balance Sheet
Cost of equity and WACC calculation
Cost of Equity and WACC Calculation
Excel Loan Calculator
Loan Calculator
Real Estate Input Area
Real Estate Input Area
Real Estate valuation and comparison
Real Estate Valuation and Comparison
Fed Model performance table
Fed Model Performance Table
Fed Model stock market valuation
Fed Model Stock Market Valuation

The Oil and Gas Investor Super Pack for Excel requires Excel 2003 or 2007 to run.

It is fully compatible with Microsoft Windows 7, Windows Vista and Windows XP.

You may also use the software on a Mac if you are running Windows 7, Windows Vista or Windows XP and Excel 2003, 2007 or 2010 on Parallels or VMWare Fusion. It will not work with Excel for Mac.

oil gas investor super pack

Regular Price: $264.80 (USD)
 Value Package Price: $219.95 (USD) 


 

Transactions are conducted in US dollars. You may view our prices in your local currency for informational purposes.







 


instant downloads

McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams



 
Copyright © 2003 - 2012 The Spreadsheet Store - All Rights Reserved
   Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.