The Resource Upstream petroleum fiscal and valuation modeling in Excel : a worked examples approach, Ken Kasriel, David Wood

Upstream petroleum fiscal and valuation modeling in Excel : a worked examples approach, Ken Kasriel, David Wood

Upstream petroleum fiscal and valuation modeling in Excel : a worked examples approach
Upstream petroleum fiscal and valuation modeling in Excel
Title remainder
a worked examples approach
Statement of responsibility
Ken Kasriel, David Wood
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="" Wiley will send youraccompanying CD-ROMto you seperately. /i & gt
Member of
Cataloging source
Dewey number
index present
LC call number
Literary form
non fiction
Nature of contents
Series statement
Wiley finance series
Upstream petroleum fiscal and valuation modeling in Excel : a worked examples approach, Ken Kasriel, David Wood
Includes index
  • net
Carrier category
online resource
Carrier category code
Carrier MARC source
Content category
Content type code
Content type MARC source
Introduction -- Introduction to tax and royalty regimes -- Tax consolidation and incremental value -- Royalties -- Bonuses -- Abandonment -- Introduction to production sharing contract-based fiscal regimes -- More realistic psc modeling -- Psc regime variations -- Appendices (available on disk) -- Appendix I: Depreciation -- Appendix II: Tax loss carrybacks -- Appendix III: Time-limited tax loss carryforwards -- Appendix IV: Knowing when to quit an alternative economic limit test method -- Appendix V: Intoduction to probability and crystal ball (on disk) -- Index
Control code
1 online resource
Form of item
Media category
Media MARC source
Media type code
Publisher number
Specific material designation
System control number
  • (OCoLC)825198150
  • pebcs1118537696

Library Locations

    • Deakin University Library - Geelong Waurn Ponds CampusBorrow it
      75 Pigdons Road, Waurn Ponds, Victoria, 3216, AU
      -38.195656 144.304955
Processing Feedback ...