Author: Kasriel Publisher: John Wiley & Sons ISBN: 9781118537695 Release Date: 2013-06-06 Genre: Business & EconomicsPlease contact the authors at ahref="mailto:[email protected]"[email protected]/afor details of how to access the trial version of Crystal Ball, aswell as the Excel and other files which are *not* part of thee-book version download. "This is a book no deal team should be without. It is a must forthose involved in upstream oil and gas transactions, planning,budgeting, investment appraisal and portfolio management. Itsstep–by–step approach cuts through complexity, makingit comprehensive and understandable by a wide range of users with awide range of abilities. It can be used as a textbook, anintroductory primer or as a handbook that you can dip in and out ofor read cover to cover." —Michael Lynch–Bell, Senior Advisor, Oil &Gas, Ernst & Young LLP; ex-officio Chairman, UN Expert Group onResource Classification In the upstream petroleum industry, it is the value ofpost–tax cashflows which matters most to companies,governments, investors, lenders, analysts, and advisors.Calculating these cashflows and understanding their“behavior,” however, is challenging, as theindustry’s specialized fiscal systems can be complex,jargon–laden, and sometimes seem to be a “world oftheir own”. Upstream Petroleum Fiscal and Valuation Modeling in Excel: AWorked Examples Approach demystifies fiscal analysis which,unlike disciplines such as Earth sciences and engineering, can belearned from a book. Written in plain English for laymen and forexperienced practitioners alike, it is a reader–friendly,clear, practical, step–by–step hands–on guide forboth reference and self–paced study. The book does not catalogue the 100+ different petroleum fiscalregimes in use at the time of writing. Rather, drawing on theauthors’ combined 48 years’ experience, it takes a moretimeless, generic treatment, by covering the most commonvariants of royalties, taxation, production sharing arrangements,bonuses and abandonment funding , through a dual approach: first,showing how to model them in Excel , and then providinginteractive exercises to prompt (and answer) questions that analyzeimpacts on cashflows. In addition to the main text, the book consists of over 120Excel files (ranging from modular examples to full models) in Excel2007 and 2003 formats; over 400 pages of supplementary PDF files;VBA features to enhance model functionality; and an introduction torisk modeling with exercises for the included trial version ofOracle’s Crystal Ball software. It offers both a wealth ofcontent and models equal to or surpassing what is available fromfiscal modeling courses costing several times more; and greaterinsights into underlying calculations than commercially available“black box” fiscal software. New US Securities and Exchange Commission (SEC) rules plannedfor 2013 will force petroleum companies to disclose more fiscalinformation on an individual country basis. This will make it moreimportant than ever for analysts to understand how to model oil andgas terms and the potential impacts of the disclosed governmentpayments on future oil and gas company profitability. Due to the heavy use of graphics and cross references used inthis particular text, some readers might find that the printed bookoffers a more optimal reading experience than certain e-formatsparticularly with the Kindle eMobi format.