Upstream Petroleum Fiscal And Valuation Modeling In Excel

Author: Kasriel
Publisher: John Wiley & Sons
ISBN: 9781118537695
Size: 15.36 MB
Format: PDF, ePub, Docs
View: 90

Please contact the authors at [email protected] 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. "This 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 step–by–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." —Michael Lynch–Bell, Senior Advisor, Oil & Gas, Ernst & Young LLP; ex-officio Chairman, UN Expert Group on Resource Classification 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.

International Petroleum Fiscal Systems And Production Sharing Contracts

Author: Daniel Johnston
Publisher: PennWell Books
ISBN: 9780878144266
Size: 15.91 MB
Format: PDF, ePub, Mobi
View: 62

Daniel Johnston covers everything including historical development of contracts, terminology of accounting and negotiations, threshold field size analysis, arithmetic behind contract terms, and more. Contents Petroleum fiscal systems Concessionary systems Production-sharing contracts Risk service contracts Threshold field size analysis Global market for exploration acreage Production-sharing contract outline Accounting principles Double taxation Commentary Appendices Glossary.

Introduction To Oil Company Financial Analysis

Author: David C. Johnston
Publisher: PennWell Books
ISBN: 159370044X
Size: 12.42 MB
Format: PDF
View: 24

This title is written by David Johnston and Daniel Johnston. There has always been a bit of magic in the stock market, especially when it comes to oil companies. When the oil industry and the stock market get together, the affair is usually dynamic and not always pleasant. Basic principles are widely understood in the financial industry, but the terminology and analytical techniques can vary greatly. This book is written for the nonfinancial shareholders, managers, and oil company employees interested in the forces that influence stock values. The bottom line in any company is expressed in the language of finance. This book explains financial concepts in a nontechnical, practical way so that nonfinancial professionals and others may understand and appreciate this aspect of the business. The value information found in this book includes: abbreviations and expanded definitions of key terms; energy conversion factors; reporting systems & statements; and stock tables explained.

Hydrocarbon Exploration And Production

Author: Frank Jahn
Publisher: Elsevier
ISBN: 0080568831
Size: 15.44 MB
Format: PDF, ePub, Docs
View: 71

Hydrocarbon Exploration and Production, Second Edition is a comprehensive and current introduction to the upstream industry, drawing together the many inter-disciplinary links within the industry. It presents all the major stages in the life of an oil or gas field, from gaining access to opportunity, through exploration, appraisal, development planning, production, and finally to decommissioning. It also explains the fiscal and commercial environment in which oil and gas field development takes place. The book is written for industry professionals who wish to be better informed about the basic technical and commercial methods, concepts and techniques used in the upstream oil and gas business. The authors are the founders of TRACS International, a company which has provided training and consultancy in Exploration and Production related issues for many clients world-wide since 1992. Clearly written in a concise and straightforward manner Features detailed technical illustrations to maximize learning Presents major advances in the industry, including technical methods for field evaluation and development and techniques used for managing risk within the business Developed from TRACS International course materials, discussions with clients, and material available in the public domain

Valuing Oil And Gas Companies

Author: Nick Antill
Publisher: Woodhead Publishing
ISBN: 1855734516
Size: 15.67 MB
Format: PDF, ePub, Docs
View: 39

Analysing the oil and gas industry, this book gives information on energy industry accounts, their reserves and depletion, taxation and stocks, and surveys the structure and conduct of the trade from portfolio construction to dollar exposure.

Casing And Liners For Drilling And Completion

Author: Ted G. Byrom
Publisher: Elsevier
ISBN: 9780128006603
Size: 17.74 MB
Format: PDF, ePub
View: 15

Once thought of as niche technology, operators today are utilizing more opportunities with casing and liners as formations and environments grow in difficulty, especially with the unconventional oil and gas boom. Casing and liners for Drilling and Completions, 2nd Edition provides the engineer and well designer with up-to-date information on critical properties, mechanics, design basics and newest applications for today’s type of well. Renovated and simplified to cover operational considerations, pressure loads, and selection steps, this handbook gives you the knowledge to execute the essential and fundamental features of casing and liners. Bonus features include: Additional glossary added to explain oil field terminology New appendix on useful every day formulas such as axial stress, shear stress in tubes and principal stress components Listing section of acronyms, notations, symbols and constants for quick reference Concise step-by-step basic casing design procedure with examples Thorough coverage and tips on important field practice for installation topics Advanced methods for critical and horizontal well casing design including hydraulic fracturing Exhaustive appendices on foundational topics: units & nomenclature, solid mechanics, hydrostatics, borehole environment & rock mechanics, and a summary of useful formulas