Upstream Petroleum Fiscal and Valuation Modeling in Excel PDF Download
Are you looking for read ebook online? Search for your book and save it on your Kindle device, PC, phones or tablets. Download Upstream Petroleum Fiscal and Valuation Modeling in Excel PDF full book. Access full book title Upstream Petroleum Fiscal and Valuation Modeling in Excel by Ken Kasriel. Download full books in PDF and EPUB format.
Author: Ken Kasriel Publisher: John Wiley & Sons ISBN: 1118537696 Category : Business & Economics Languages : en Pages : 389
Book Description
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.
Author: Ken Kasriel Publisher: John Wiley & Sons ISBN: 1118537696 Category : Business & Economics Languages : en Pages : 389
Book Description
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.
Author: Michael Tamvakis Publisher: CRC Press ISBN: 1317663365 Category : Law Languages : en Pages : 445
Book Description
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.
Author: Martin Schwarzbichler Publisher: Springer ISBN: 3319757628 Category : Business & Economics Languages : en Pages : 480
Book Description
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.
Author: Manfred Hafner Publisher: Springer Nature ISBN: 3030868842 Category : Business & Economics Languages : en Pages : 808
Book Description
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.
Author: Stephen E. Kesler Publisher: Cambridge University Press ISBN: 1107074916 Category : Business & Economics Languages : en Pages : 447
Book Description
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.
Author: Amr Rezk Publisher: ISBN: 9781412056618 Category : Business & Economics Languages : en Pages : 0
Book Description
In order to prioritize exploration activities, oil and gas companies need to follow a framework. This important procedural envelope is critical to the success of any oil and gas venture. Decision makers need to consider a multitude of variables before they decide whether or not to pursue any petroleum project. Before a decision to drill a well can be made, some important questions need to be answered; some of these questions revolve around the need for assurance that a well will bring wealth to the organization or parties that drill it. A decision maker therefore has to start by asking whether a venture is worth pursuing from an economic perspective. The answer to this question forms the heart of petroleum investment; and supporting this process by building petroleum economic models is what this book is all about. This book offers a basic understanding of the methods required to build economic models for valuing upstream petroleum projects. The book offers an overview of the fundamentals of some of the major petroleum contracts, simple commercial concepts and how to use them for creating valuation models.
Author: Ms.Oana Luca Publisher: International Monetary Fund ISBN: 149838630X Category : Business & Economics Languages : en Pages : 52
Book Description
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.
Author: International Monetary Fund. Fiscal Affairs Dept. Publisher: International Monetary Fund ISBN: 1498340067 Category : Business & Economics Languages : en Pages : 82
Book Description
Better designed and implemented fiscal regimes for oil, gas, and mining can make a substantial contribution to the revenue needs of many developing countries while ensuring an attractive return for investors, according to a new policy paper from the International Monetary Fund. Revenues from extractive industries (EIs) have major macroeconomic implications. The EIs account for over half of government revenues in many petroleum-rich countries, and for over 20 percent in mining countries. About one-third of IMF member countries find (or could find) resource revenues “macro-critical” – especially with large numbers of recent new discoveries and planned oil, gas, and mining developments. IMF policy advice and technical assistance in the field has massively expanded in recent years – driven by demand from member countries and supported by increased donor finance. The paper sets out the analytical framework underpinning, and key elements of, the country-specific advice given. Also available in Arabic: ????? ??????? ?????? ???????? ???????????: ??????? ???????? Also available in French: Régimes fiscaux des industries extractives: conception et application Also available in Spanish: Regímenes fiscales de las industrias extractivas: Diseño y aplicación
Author: Darren Smith Publisher: John Wiley & Sons ISBN: 0470971673 Category : Business & Economics Languages : en Pages : 357
Book Description
This book is an introduction to the modelling of cash collateralised debt obligations (“CDOs”). It is intended that the reader have a basic understanding of CDOs and a basic working knowledge of Microsoft Office Excel. There will be written explanations of concepts along with understandable mathematical explanations and examples provided in Excel.
Author: Robert Clews Publisher: Academic Press ISBN: 0128005297 Category : Business & Economics Languages : en Pages : 416
Book Description
This overview of project finance for the oil and gas industry covers financial markets, sources and providers of finance, financial structures, and capital raising processes. About US$300 billion of project finance debt is raised annually across several capital intensive sectors—including oil and gas, energy, infrastructure, and mining—and the oil and gas industry represents around 30% of the global project finance market. With over 25 year’s project finance experience in international banking and industry, author Robert Clews explores project finance techniques and their effectiveness in the petroleum industry. He highlights the petroleum industry players, risks, economics, and commercial/legal arrangements. With petroleum industry projects representing amongst the largest industrial activities in the world, this book ties together concepts and tools through real examples and aims to ensure that project finance will continue to play a central role in bringing together investors and lenders to finance these ventures. Combines the theory and practice of raising long-term funding for capital intensive projects with insights about the appeal of project finance to the international oil and gas industry Includes case studies and examples covering projects in the Arctic, East Africa, Latin America, North America, and Australia Emphasizes the full downstream value chain of the industry instead of limiting itself to upstream and pipeline project financing Highlights petroleum industry players, risks, economics, and commercial and legal arrangements