全部版块 我的主页
› 论坛 › 金融投资论坛 六区 › 金融学（理论版）
Upstream Petroleum Fiscal and Valuation Modeling in Excel: A Worked Examples
大家开心
7670 33
2014-10-20
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.
51sQODNnVuL.jpg

本帖隐藏的内容



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
二维码

扫码加我 拉你入群

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

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

全部回复
rmatrix
2014-10-20 19:09:42
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".
二维码

扫码加我 拉你入群

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

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

research
2014-10-20 20:30:08
提示: 作者被禁止或删除 内容自动屏蔽
二维码

扫码加我 拉你入群

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

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

云游天外
2014-10-20 23:01:41
嗯，正在研究Excel，谢谢
二维码

扫码加我 拉你入群

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

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

jojoan719
2014-10-21 09:11:26
二维码

扫码加我 拉你入群

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

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

phoennie
2014-10-21 09:14:20
不错，原油勘探及开采的财务风险、估值分析。
二维码

扫码加我 拉你入群

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

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

点击查看更多内容…
相关推荐
栏目导航
热门文章
推荐文章

说点什么

分享

微信QQ空间QQ微博
扫码加好友，拉您进群
各岗位、行业、专业交流群