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 500 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.
Our software runs on any version of Microsoft Excel from 97-2007.
All recent Microsoft operating systems are supported, including Windows 95, Windows 98, Windows 2000, Windows ME, Windows CE, Windows XP and Vista. Windows Mobile 5.0 and 6.0 are also supported, provided you have Microsoft Excel or Documents-To-Go installed on your mobile device.
It is also fully-compatible with MAC OS and OS X. You must be running Excel 2004 or 2008 for Mac.
