f

Nigerian Seminars and Trainings

Search conferences, training, seminars, courses and workshops in Nigeria and around the world

business logo

Financial and Valuation Modeling for the Oil and Gas Industry

By: Budding Heights Development Company

Lagos State, Nigeria

28 Apr - 04 May, 2016  7 days

Follow Event

  

NGN 150,000

Using various supporting schedules, modeling best practices, and dynamic scenario analysis, you'll discover how to develop a comprehensive Oil and Gas (Oil and Gas) three-statement forecast model while selecting, locating, and developing appropriate Oil and Gas projection drivers. In addition, you will delve into the intuition and mechanics of complex Oil and Gas valuation methodologies and will build discounted cash flow (DCF) and net asset value (NAV) models from scratch utilizing case studies, Oil and Gas industry best practices, and sensitivity analyses. 
Finally, you will build an Oil and Gas merger model to reflect the pro forma impact of various Oil and Gas acquisition scenarios.

Learning Objectives

  • Review Excel settings and formatting best practices for Oil and Gas financial modeling 
  • Understand financial model architecture, set up, and modeling best practices 
  • Efficiently check models for errors, accuracy, and integrity 
  • Deal with circularities in the model 
  • Balance the model and insert automated checks 
  • Calculate free cash flows using the unlevered valuation approach 
  • Discount the cash flows using WACC 
  • Use the enterprise value to determine implied share prices 

Course Features

  • Understand industry dynamics and factors determining crude oil and natural gas prices 
  • Grasp the different business segments – upstream, midstream, and downstream 
  • Review Oil and Gas terminology, units, and key terms 
  • Distinguish between full-cost and successful efforts accounting methods and their impact on financial statements and financial statement analysis 
  • Learn the structure and layout of Oil and Gas financial reports and filings (i.e. 10-K, 10-Q, annual report) 
  • Analyze and interpret Oil and Gas financial statements, footnotes, and disclosures 
  • Understand how to perform Oil and Gas reserves and production ratio analysis 
  • Understand the interconnectivity of core Oil and Gas financial statements and how the cash flow statement, income statement, and balance sheet are linked 

Course Outline

  • Build supporting schedules – commodity price schedule, production volume schedule, reserves schedule, EandP unit costs schedule, debt schedule, interest schedule, PPandE and capital expenditures schedule 
  • Analyze key input assumptions at various sensitivities 
  • Learn market-based valuation, including comparable company analysis and comparable transaction analysis using appropriate equity and enterprise value multiples (EV/DACF, EV/reserves, P/E, etc.) 
  • Identify and analyze financial statement elements that are key to the value of an Oil and Gas company 
  • Calculate enterprise value 
  • Perform sensitivity analysis on EPS accretion/dilution in stock vs. cash deal, interest rate assumptions, and premium paid 
  • Grasp taxation issues, including deferred taxes created by the step-up of asset values 
  • Gain insight into legal considerations in acquisitions
Best Western Starfire Hotel, 128 Joel Ogunnaike Street, GRA Ikeja, Lagos Apr 28 - 04 May, 2016
NGN 150,000.00
(Convert Currency)

+234 810 495 1079, +234 701 881 7970