{"product_id":"upstream-petroleum-fiscal-and-valuation-modeling-in-excel-a-worked-examples-approach-multiple-component-retail-product-parts-enclosed-9780470686829","title":"Upstream Petroleum Fiscal and Valuation Modeling in Excel; A Worked Examples Approach (Multiple-component retail product, part(s) enclosed) 9780470686829","description":"\u003cfont face=\"Georgia\"\u003e\r\n\u003cp\u003e\u003cfont size=\"6\"\u003eUpstream Petroleum Fiscal and Valuation Modeling in Excel\u003c\/font\u003e\u003cbr\u003e\r\n\u003cfont size=\"5\"\u003eA Worked Examples Approach\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\r\n\r\n\r\n\u003cp\u003e\u003cfont size=\"4\"\u003eKen Kasriel (Author), David Wood (Author)\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e9780470686829, Wiley\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003eMultiple-component retail product, part(s) enclosed, published 15 March 2013\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e384 pages\u003cbr\u003e24.6 x 17.5 x 2.5 cm, 0.794 kg\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\r\n\r\n\r\n\r\n\u003cp align=\"justify\"\u003e\u003cstrong\u003e\u003cfont size=\"3\"\u003e\u003cp\u003e\u003cb\u003ePlease contact the authors at \u003ca href=\"mailto:upstream.petroleum.in.excel@gmail.com\"\u003eupstream.petroleum.in.excel@gmail.com\u003c\/a\u003e 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.\u003cbr\u003e\u003c\/b\u003e\u003cbr\u003e\"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.\"\u003cbr\u003e—\u003cb\u003eMichael Lynch-Bell\u003c\/b\u003e, Senior Advisor, Oil \u0026amp; Gas, Ernst \u0026amp; Young LLP; ex-officio Chairman, UN Expert Group on Resource Classification\u003c\/p\u003e \u003cp\u003eIn 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”.\u003c\/p\u003e \u003cp\u003e\u003ci\u003eUpstream Petroleum Fiscal and Valuation Modeling in Excel: A Worked Examples Approach\u003c\/i\u003e 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.\u003c\/p\u003e \u003cp\u003eThe 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.\u003c\/p\u003e \u003cp\u003eIn 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.\u003c\/p\u003e \u003cp\u003eNew 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.\u003cbr\u003e\u003cbr\u003e\u003c\/p\u003e \u003cp\u003eDue 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.\u003c\/p\u003e\u003c\/font\u003e\u003c\/strong\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e\u003cp\u003eIntroduction xi\u003c\/p\u003e \u003cp\u003eAcknowledgements xvi\u003c\/p\u003e \u003cp\u003e\u003cb\u003e1 Introduction to Tax and Royalty Regimes 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e1.1 Introduction 3\u003c\/p\u003e \u003cp\u003e1.2 Inflation and Discounting: Time Value of Money Basics in the Context of Upstream Petroleum Modeling 5\u003c\/p\u003e \u003cp\u003e1.3 Introducing Basic Components of Upstream Petroleum Cashflow Under a Simple Tax and Royalty Regime 16\u003c\/p\u003e \u003cp\u003e1.4 Another (Important) Multiplier – Introduction to Modeling Commercial Behavior with the Economic Limit Test 20\u003c\/p\u003e \u003cp\u003e1.5 Chapter Model Housekeeping Notes 25\u003c\/p\u003e \u003cp\u003e1.6 Chapter Model Assumptions 27\u003c\/p\u003e \u003cp\u003e1.6.1 Assumptions: General Remarks 27\u003c\/p\u003e \u003cp\u003e1.6.2 Assumptions: Time and the Time Value of Money 28\u003c\/p\u003e \u003cp\u003e1.6.3 Assumptions: Commodity Prices 29\u003c\/p\u003e \u003cp\u003e1.6.4 Assumptions: Production Profile 34\u003c\/p\u003e \u003cp\u003e1.6.5 Assumptions: Capex 34\u003c\/p\u003e \u003cp\u003e1.6.6 Assumptions: Opex 36\u003c\/p\u003e \u003cp\u003e1.6.7 Assumptions: Abandonment 37\u003c\/p\u003e \u003cp\u003e1.6.8 Assumptions: Royalty 38\u003c\/p\u003e \u003cp\u003e1.6.9 Assumptions: Rentals 39\u003c\/p\u003e \u003cp\u003e1.6.10 Assumptions: Bonuses 40\u003c\/p\u003e \u003cp\u003e1.6.11 Assumptions: Income Tax and Related Items 42\u003c\/p\u003e \u003cp\u003e1.7 Pre-ELT Calculations 45\u003c\/p\u003e \u003cp\u003e1.7.1 Pre-ELT Calculations: Opex and Capex Timing\/Inflation 45\u003c\/p\u003e \u003cp\u003e1.7.2 Pre-ELT Calculations: Bonus and Rentals 47\u003c\/p\u003e \u003cp\u003e1.7.3 Pre-ELT Calculations: GOCF 48\u003c\/p\u003e \u003cp\u003e1.8 ELT Calculation and Role in Economic Modeling 49\u003c\/p\u003e \u003cp\u003e1.9 Post-ELT Calculations 60\u003c\/p\u003e \u003cp\u003e1.9.1 Post-ELT Calculations: Abandonment 60\u003c\/p\u003e \u003cp\u003e1.9.2 Post-ELT Calculations: Depreciation 62\u003c\/p\u003e \u003cp\u003e1.9.3 Income Tax: Basic Concepts and Calculations 63\u003c\/p\u003e \u003cp\u003e1.9.4 Returning to Main Model – Post-ELT Calculations: Income Tax 74\u003c\/p\u003e \u003cp\u003e1.9.5 Post-ELT Calculations: NCF and Discounting 80\u003c\/p\u003e \u003cp\u003e1.9.6 Post-ELT Calculations: Financial Metrics 83\u003c\/p\u003e \u003cp\u003e1.9.7 Post-ELT Calculations: Volumetric Outcomes 86\u003c\/p\u003e \u003cp\u003e1.10 Multivariable Sensitivity Analysis Using a Two-Way Data Table 89\u003c\/p\u003e \u003cp\u003e1.11 The ELT – Questions to Consider 89\u003c\/p\u003e \u003cp\u003e1.12 Review Exercise: Key Calculations 89\u003c\/p\u003e \u003cp\u003e\u003cb\u003e2 Tax Consolidation and Incremental Value 91\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e2.1 Tom and Carmen Mix Love and Money: A Romantic Introduction to Fiscal Consolidation 93\u003c\/p\u003e \u003cp\u003e2.2 Petroleum Tax and Royalty Regimes: “Ringfencing” vs. Consolidation 95\u003c\/p\u003e \u003cp\u003e2.3 Ringfencing, Consolidation and Incremental Value 96\u003c\/p\u003e \u003cp\u003e2.4 Ringfenced vs. Consolidated Incremental Value Model: Assumptions 99\u003c\/p\u003e \u003cp\u003e2.5 Ringfenced vs. Consolidated Incremental Value Model: Calculations 102\u003c\/p\u003e \u003cp\u003e2.6 Model Results and Analysis 105\u003c\/p\u003e \u003cp\u003e2.7 Exercise – Try Modeling Scenario 2 Yourself 107\u003c\/p\u003e \u003cp\u003e2.8 Income Tax Consolidation and Incremental Value (Interactive Analysis) 108\u003c\/p\u003e \u003cp\u003e\u003cb\u003e3 Royalties 109\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e3.1 Introduction 111\u003c\/p\u003e \u003cp\u003e3.2 Royalty Based on Commodity Prices 113\u003c\/p\u003e \u003cp\u003e3.3 Royalty Based on Length of Production 119\u003c\/p\u003e \u003cp\u003e3.4 Royalty Based on Period-End Cumulative Production 122\u003c\/p\u003e \u003cp\u003e3.5 Royalty Based on Cumulative Production Throughout the Period 125\u003c\/p\u003e \u003cp\u003e3.6 Royalty Rates Based on the Production Rate 143\u003c\/p\u003e \u003cp\u003e3.7 Royalty Based on Price and Production Rates (Version 1) 154\u003c\/p\u003e \u003cp\u003e3.8 Royalty Based on Price and Production Rates (Version 2 – Based on Canada’s New Royalty Framework) 160\u003c\/p\u003e \u003cp\u003e3.9 Royalty Based on a Measure of Cumulative Profitability: The “R-factor” 160\u003c\/p\u003e \u003cp\u003e3.10 Royalty Based on a Measure of Cumulative Profitability and Commodity Prices – Canadian Oil Sands 166\u003c\/p\u003e \u003cp\u003e\u003cb\u003e4 Bonuses 167\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e4.1 Introduction 169\u003c\/p\u003e \u003cp\u003e4.2 Commerciality Bonuses 170\u003c\/p\u003e \u003cp\u003e4.3 Bonuses Payable at First Commercial Production 173\u003c\/p\u003e \u003cp\u003e4.4 Cumulative Production Bonuses 173\u003c\/p\u003e \u003cp\u003e4.5 Bonuses Based on the Cumulative Value of Production 178\u003c\/p\u003e \u003cp\u003e4.6 Bonuses Based on the Production Rate for a Specified Period 178\u003c\/p\u003e \u003cp\u003e\u003cb\u003e5 Abandonment 189\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e5.1 Introduction 191\u003c\/p\u003e \u003cp\u003e5.2 Lumpsum Abandonment Payments 192\u003c\/p\u003e \u003cp\u003e5.3 Equal Abandonment Contributions Made Over the Production Period 194\u003c\/p\u003e \u003cp\u003e5.4 Unequal Abandonment Contributions, Based on Annual Production as a Percentage of Ultimate Production 199\u003c\/p\u003e \u003cp\u003e5.5 Equal Abandonment Contributions, Starting when Depletion Reaches a Specified Threshold 200\u003c\/p\u003e \u003cp\u003e5.6 Equal Abandonment Contributions Starting from a Specified Number of Periods Before Economic Production Ends 203\u003c\/p\u003e \u003cp\u003e5.7 Equal Abandonment Contributions Starting when the Producer Chooses 204\u003c\/p\u003e \u003cp\u003e5.8 Multiple Methods, Using Whichever One Makes Abandonment Contributions Start Earlier 206\u003c\/p\u003e \u003cp\u003e5.9 Abandonment Contributions which Earn Interest (Single Rate) 206\u003c\/p\u003e \u003cp\u003e5.10 Abandonment Contributions which Earn Interest (Variable Rates) 211\u003c\/p\u003e \u003cp\u003e\u003cb\u003e6 Introduction to Production Sharing Contract-Based Fiscal Regimes 213\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e6.1 Overview: PSCs as a Specialized Revenue Sharing Framework 215\u003c\/p\u003e \u003cp\u003e6.2 Looking Ahead: Road Map for This and the Next Chapters 217\u003c\/p\u003e \u003cp\u003e6.3 Simple Example of PSC Revenue Distribution 218\u003c\/p\u003e \u003cp\u003e6.4 Simplistic (Single-Year) Model Revenue Distribution Calculations, Including Cost Oil Determination 220\u003c\/p\u003e \u003cp\u003e6.5 Introducing “Entitlement Volumes” 229\u003c\/p\u003e \u003cp\u003e6.6 Simplistic, Multi-Period PSC Model: The Calculation of Cost Oil 234\u003c\/p\u003e \u003cp\u003e6.7 Topic in Depth: Contractor Entitlement 242\u003c\/p\u003e \u003cp\u003e\u003cb\u003e7 More Realistic PSC Modeling 243\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e7.1 Introducing a More Realistic PSC Model 245\u003c\/p\u003e \u003cp\u003e7.2 Arriving at Our “Core” PSC Model 261\u003c\/p\u003e \u003cp\u003e7.3 “Uplifts” to Cost Oil 265\u003c\/p\u003e \u003cp\u003e\u003cb\u003e8 PSC Regime Variations 273\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e8.1 PSCs with Explicit Income Tax Provisions 275\u003c\/p\u003e \u003cp\u003e8.2 Profit Oil Sharing Based on Commodity Prices 288\u003c\/p\u003e \u003cp\u003e8.3 Profit Oil Sharing Based on the Production Rate 308\u003c\/p\u003e \u003cp\u003e8.4 Profit Oil Sharing Based on Cumulative Production 318\u003c\/p\u003e \u003cp\u003e8.5 Introduction to Profit Sharing Based on a Measure of Cumulative Profitability: The “R-factor” 327\u003c\/p\u003e \u003cp\u003e8.6 R-factors and the “Gold Plating” Effect 341\u003c\/p\u003e \u003cp\u003e\u003cb\u003eAppendices (Available on Disk)\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAppendix I: Depreciation\u003c\/p\u003e \u003cp\u003eAppendix II: Tax Loss Carrybacks\u003c\/p\u003e \u003cp\u003eAppendix III: Time-Limited Tax Loss Carryforwards\u003c\/p\u003e \u003cp\u003eAppendix IV: Knowing when to Quit: An Alternative Economic Limit Test Method\u003c\/p\u003e \u003cp\u003eAppendix V: Introduction to Probability and Crystal Ball\u003c\/p\u003e \u003cp\u003eIndex 345\u003c\/p\u003e\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003eSubject Areas: Finance \u0026amp; accounting [\u003ca title=\"See our other books on Finance \u0026amp; accounting\" href=\"https:\/\/freshlyprintedbooks.co.uk\/search?q=%22Finance%20\u0026amp;%20accounting%20%5BKF%5D%22\"\u003eKF\u003c\/a\u003e]\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\r\n\u003c\/font\u003e","brand":"Wiley","offers":[{"title":"Brand New","offer_id":52165307695384,"sku":"9780470686829","price":101.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0730\/2037\/5320\/files\/9780470686829_260808.jpg?v=1781098171","url":"https:\/\/freshlyprintedbooks.co.uk\/products\/upstream-petroleum-fiscal-and-valuation-modeling-in-excel-a-worked-examples-approach-multiple-component-retail-product-parts-enclosed-9780470686829","provider":"Freshly Printed Books","version":"1.0","type":"link"}