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."/i /'bMichael Lynch'Bell/b, 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"./ iUpstream Petroleum Fiscal and Valuation Modeling in Excel: A Worked Examples Approach/i 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. / /iWhen purchasing this book for an e-reader, please email proof of purchase and delivery address to: a href="mailto:wileydiscrequest@wiley.com"wileydiscrequest@wiley.com/aand Wiley will send youraccompanying CD-ROMto you seperately. /i & gt.

Please contact the authors at upstream.petroleum.in.excel@gmail.com 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.

This book is a guide to how financial steering is designed, measured and implemented with a special focus on the energy industry. The authors offer an overview of and practical insights into the links between financial steering and accounting, and the temporary cycles of investment, divestment, return and loss, market highs and lows that form the framework of the entire energy industry across all value chain stages. The faster and the larger the cash cycles of investments and their returns, the greater not only the value created, but also the potential loss if the financial steering is not properly designed and managed. Value and value generation require an understanding of how value is both defined and measured in both and how the business/project economics model of a company works – financial steering provides this. Further, the book also discusses accounting topics such as impairments, new IFRS standards and the impact of accounting on key performance indicators of financial steering, which are associated with these investment decision valuations. The combination of accounting with the cash flow perspective provides a complete understanding of selected practical topics of financial steering which are explained in detail in a large number of examples and case studies. The book is intended for a wide range of finance/controlling/treasury/accounting professionals and students. It is written in practical and simple terms to outline the financial steering concept and to bring it to life in daily work and in the decision making process for financial steering. All illustrated concepts are in the same manner relevant and applicable to all other asset-intense industry sectors and their financial steering processes.

What affects the supply of oil? How important is the weather in determining grain prices? Why has the price of copper skyrocketed? This unique book analyses the economics of key commodity groups, including energy, agriculture and metals. It examines the supply/demand fundamentals of several major and minor commodities, physical characteristics, production and consumption patterns, trade flows and pricing mechanisms. It also explains the main tools used to hedge price risk, such as futures, options and swaps. This second edition has been fully revised and restructured, and contains four new chapters, including oil refining, electricity and price risk management for energy, metals and agricultural commodities This book is an indispensable reference text for students, academics and those working in the commodity business.

This open access handbook is distinguished by its emphasis on international energy, rather than domestic energy policies or international geopolitic aspects. Addressing key topics such as energy production and distribution, renewables and corporate energy structures, alongside global energy trends, regional case studies and emerging areas such as the digitalization of energy and energy transition, this handbook provides a major new contribution to the field of international energy economics. Written by academics, practitioners and policy-makers, this handbook is a valuable and timely addition to the literature on international energy economics. This book was published open access with the support of Eni.

Written for students and professionals, this revised textbook surveys the mineral industry from geological, environmental and economic perspectives. Thoroughly updated, the text includes a new chapter on technology industry metals as well as separate chapters on mineral economics and environmental geochemistry. Carefully designed figures simplify difficult concepts and show the location of important deposits and trade patterns, emphasising the true global nature of mineral resources. Featuring boxes highlighting special interest topics, the text equips students with the skills they need to contribute to the energy and mineral questions currently facing society, including issues regarding oil pipelines, nuclear power plants, water availability and new mining locations. Technical terms are highlighted when first used, and references are included to allow students to delve more deeply into areas of interest. Multiple choice and short answer questions are provided for instructors online at www.cambridge.org/kesler to complete the teaching package.

This manual introduces key concepts and methodology used by the Fiscal Affairs Department (FAD) in its fiscal analysis of resource industries (FARI) framework. Proper evaluation of fiscal regimes for extractive industries (EI) requires economic and financial analysis at the project level, and FARI is an analytical tool that allows such fiscal regime design and evaluation. The FARI framework has been primarily used in FAD’s advisory work on fiscal regime design: it supports calibration of fiscal parameters, sensitivity analysis, and international comparisons. In parallel to that, FARI has also evolved into a revenue forecasting tool, allowing IMF economists and government officials to estimate the composition and timing of expected revenue streams from the EI sector, analyze revenue management issues (including quantification of fiscal rules), and better integrate the EI sector in the country macroeconomic frameworks. Looking forward, the model presents a useful tool for revenue administration practitioners, allowing them to compare actual, realized revenues with model results in tax gap analysis.

'Dennis Buchanan’s text clearly shows how an understanding of the complementary disciplines of geoscience, conventional engineering and advanced financial engineering is essential to making the right decisions concerning how to appraise a resource or project and how to structure the funding of natural resources assets in order to mitigate technical and financial risk and to maximise value for owners. Crucially, the book also looks at how other sources of capital, such as limited recourse lenders, appraise metals and energy assets. Such an understanding is essential to optimising the capital structure and valuation of natural resources assets … The advanced methodologies revealed in Dennis Buchanan’s book will have great value to those working in the technical and financial functions, or to those spanning both functions, of the natural resources industry. 'Mineral EconomicsGiven the design component it involves, financial engineering should be considered equal to conventional engineering. By adopting this complementary approach, financial models can be used to identify how and why timing is critical in optimizing return on investment and to demonstrate how financial engineering can enhance returns to investors. Metals and Energy Finance capitalizes on this approach, and identifies and examines the investment opportunities offered across the extractive industry's cycle, from exploration through evaluation, pre-production development, development and production. The textbook also addresses the similarities of a range of natural resource projects, whether minerals or petroleum, while at the same time identifying their key differences.This new edition has been comprehensively revised with a new chapter on Quantitative Finance and three additional case studies. Contemporary themes in the revised edition include the current focus on the transition from open pit to underground mining as well as the role of real option valuations applied to marginal projects that may have value in the future.This innovative textbook is clear and concise in its approach. Both authors have extensive experience within the academic environment at a senior level as well as track records of hands-on participation in projects within the natural resources and financial services sectors. Metals and Energy Finance will be invaluable to both professionals and graduate students working in the field of mineral and petroleum business management.

Theses on any subject submitted by the academic libraries in the UK and Ireland.