Upstream Petroleum Fiscal and Valuation Modeling in Excel

Upstream Petroleum Fiscal and Valuation Modeling in Excel

4.11 - 1251 ratings - Source

Please contact the authors at for details of how to access the trial version of Crystal Ball, as well as the Excel and other files which are *not* part of the e-book version download. qThis is a book no deal team should be without. It is a must for those involved in upstream oil and gas transactions, planning, budgeting, investment appraisal and portfolio management. Its stepa€“bya€“step approach cuts through complexity, making it comprehensive and understandable by a wide range of users with a wide range of abilities. It can be used as a textbook, an introductory primer or as a handbook that you can dip in and out of or read cover to cover.q a€”Michael Lyncha€“Bell, Senior Advisor, Oil a Gas, Ernst a Young LLP; ex-officio Chairman, UN Expert Group on Resource Classification In the upstream petroleum industry, it is the value of posta€“tax cashflows which matters most to companies, governments, investors, lenders, analysts, and advisors. Calculating these cashflows and understanding their a€œbehavior, a€ however, is challenging, as the industrya€™s specialized fiscal systems can be complex, jargona€“laden, and sometimes seem to be a a€œworld of their owna€. 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 readera€“friendly, clear, practical, stepa€“bya€“step handsa€“on guide for both reference and selfa€“paced study. The book does not catalogue the 100+ different petroleum fiscal regimes in use at the time of writing. Rather, drawing on the authorsa€™ combined 48 yearsa€™ 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 Oraclea€™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 a€œblack boxa€ 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.While we do not detail it here, be aware that the methodology would be the same as that used to model a time-limited tax ... timeframe, one always must know the total cumulative amount of such costs, as at the start of the first timeline period.

Title:Upstream Petroleum Fiscal and Valuation Modeling in Excel
Author:Kasriel, David Wood
Publisher:John Wiley & Sons - 2013-06-06


You Must CONTINUE and create a free account to access unlimited downloads & streaming