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