Upstream Petroleum Fiscal and Valuation Modeling in Excel: A Worked Examples

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

In the upstream petroleum industry, it is the value of post-tax cashflows which matters most to companies, governments, investors, lenders, analysts, and advisors. Calculating these cashflows and understanding their "behavior," however, is challenging, as the industry's specialized fiscal systems can be complex, jargon-laden, and sometimes seem to be a "world of their own".

Upstream Petroleum Fiscal and Valuation Modeling in Excel: A Worked Examples Approach demystifies fiscal analysis which, unlike disciplines such as Earth sciences and engineering, can be learned from a book. Written in plain English for laymen and for experienced practitioners alike, it is a reader-friendly, clear, practical, step-by-step hands-on guide for both reference and self-paced study.

The book does not catalogue the 100+ different petroleum fiscal regimes in use at the time of writing. Rather, drawing on the authors' combined 48 years' experience, it takes a more timeless, generic  treatment, by covering the most common variants of royalties, taxation, production sharing arrangements, bonuses and abandonment funding , through a dual approach: first, showing  how to model them in Excel , and then providing interactive exercises to prompt (and answer) questions that analyze impacts on cashflows.

In addition to the main text, the book consists of over 120 Excel files (ranging from modular examples to full models) in Excel 2007 and 2003 formats; over 400 pages of supplementary PDF files; VBA features to enhance model functionality; and an introduction to risk modeling with exercises for the included trial version of Oracle's Crystal Ball software. It offers both a wealth of content and models equal to or surpassing what is available from fiscal modeling courses costing several times more; and greater insights into underlying calculations than commercially available "black box" fiscal software.

New US Securities and Exchange Commission (SEC) rules planned for 2013 will force petroleum companies to disclose more fiscal information on an individual country basis. This will make it more important than ever for analysts to understand how to model oil and gas terms and the potential impacts of the disclosed government payments on future oil and gas company profitability.

Due to the heavy use of graphics and cross references used in this particular text, some readers might find that the printed book offers a more optimal reading experience than certain e-formats particularly with the Kindle eMobi format.

本帖隐藏的内容

Ken Kasriel, David Wood-Upstream Petroleum Fiscal and Valuation Modeling in Exce.pdf (17.13 MB, 需要: 12 个论坛币)

2014-10-20 18:38:29 上传

Upstream Petroleum Fiscal and Valuation Modeling in Excel: A Worked Examples Approach
需要: 12 个论坛币  [购买]

Hardcover: 370 pages
Publisher: Wiley; 1 edition (May 13, 2013)
Language: English
ISBN-10: 0470686820
ISBN-13: 978-0470686829
Product Dimensions: 1 x 7 x 10 inches
Shipping Weight: 1.8 pounds
http://www.amazon.com/Upstream-Petroleum-Fiscal-Valuation-Modeling/dp/0470686820/ref=sr_1_1?ie=UTF8&qid=1413799214&sr=8-1&keywords=Upstream+Petroleum+Fiscal+and+Valuation+Modeling+in+Excel%3A+A+Worked+Examples+Approach

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏2 回帖

关键词：Valuation Petroleum upstream Modeling Examples Excel companies sometimes industry complex

In the upstream petroleum industry, it is the value of post-tax cashflows which matters most to companies, governments, investors, lenders, analysts, and advisors. Calculating these cashflows and understanding their "behavior," however, is challenging, as the industry's specialized fiscal systems can be complex, jargon-laden, and sometimes seem to be a "world of their own".

嗯，正在研究Excel，谢谢

不错，原油勘探及开采的财务风险、估值分析。

Upstream Petroleum Fiscal and Valuation Modeling in Excel:

谢谢分享

thanks for sharing

see................