Financial Modeling for the Oil and Gas Industry OnSite Training training seminars presented by American Management Association Seminars register now on FindaSeminar.com

findaseminar logo balls FindaSeminar.com
event search registration and marketing services since 2002
Advanced Search
 
 

Financial Modeling for the Oil and Gas Industry OnSite Training  

 Email information about this seminar Financial Modeling for the Oil and Gas Industry OnSite Training by American Management Association Seminars to yourself your manager or associates Email this event... View and register for other training seminars like Financial Modeling for the Oil and Gas Industry OnSite Training by American Management Association Seminars on FindaSeminar.com Find similar training.. Find and register for other training seminars by American Management Association Seminars on FindaSeminar.com Other seminars from American Management Association Seminars

By:

training seminars by American Management Association Seminars American Management Association Seminars   

For:

Finance professionals working across all levels in the Oil & Gas industry – treasury, accounting, financial planning & analysis (FP&A), corporate development, business development, M&A, budgeting and forecasting, and controllers – who want to gain new or sharpen their existing O&G financial, valuation, and M&A modeling skill set.

Cost:   

see Registration info for seminar cost, group discount etc.

Seminar Summary:

You'll discover how to develop a comprehensive Oil & Gas (O&G) three-statement forecast model while selecting, locating, and developing appropriate O&G projection drivers and more! (see full course description)

 

 Seminar / Training class dates & locations

 

No seminar dates for this event are currently scheduled.  Please use the seminars search box above or choose one of the following additional training search options to find similar training.

Financial+valuation+Modeling training seminars workshops conferences online training

Providers course catalog

Find seminars by state

Find seminars by city

Request on site training

Use Advanced Search

NEW  Don't miss training you want to attend

Receive a personal Training Alert when training you want to attend comes to your area. Create a personal Training Alert now  it's Free and only takes a minute!


 

 

 

share this page 

print the agenda print agenda for the Financial Modeling for the Oil and Gas Industry OnSite Training seminar

 

 

Training Course Syllabus:


Financial Modeling for the Oil and Gas Industry - OnSite Training

Applying existing financial standards in the oil and gas industry

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

What to Bring: Laptop, Notepad, and Calculator.
 

How You Will Benefit

  • Review Excel settings and formatting best practices for O&G 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
  • Present valuation results using sensitivity analysis and data tables
  • Perform sensitivity and scenario analysis
  • Learn intrinsic valuation, including DCF and NAV valuation
  • Learn how to allocate purchase price and calculate goodwill in O&G transactions
  • Learn to make pro forma balance sheet, income statement, and cash flow adjustments
     

What You Will Cover

  • Understand industry dynamics and factors determining crude oil and natural gas prices
  • Grasp the different business segments – upstream, midstream, and downstream
  • Review O&G 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 O&G financial reports and filings (i.e. 10-K, 10-Q, annual report)
  • Analyze and interpret O&G financial statements, footnotes, and disclosures
  • Understand how to perform O&G reserves and production ratio analysis
  • Understand the interconnectivity of core O&G financial statements and how the cash flow statement, income statement, and balance sheet are linked
  • Build supporting schedules – commodity price schedule, production volume schedule, reserves schedule, E&P unit costs schedule, debt schedule, interest schedule, PP&E 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 O&G company
  • Grasp intrinsic valuation including DCF and NAV valuation
  • Derive unlevered earnings and unlevered free cash flows for an O&G company
  • Derive a weighted average cost of capital (WACC) discount rate by deriving the cost of debt and the cost of equity
  • Learn about various competing terminal value approaches
  • Handle working capital items, deferred taxes, and capital expenditures
  • Derive the cost of capital using CAPM and select the correct discount rates
  • Estimate terminal values using exit multiple and growth in perpetuity approaches
  • Calculate enterprise value
  • Perform sensitivity analysis on EPS accretion/dilution in stock vs. cash deal, interest rate assumptions, and premium paid
  • Build a pro forma O&G income statement and make appropriate deal-related adjustments to arrive at accretion/dilution per share
  • Error-check an O&G merger model and insert circuit breaker switches where appropriate
  • Analyze pro-forma operating metrics including reserves and production
  • Calculate sources and uses of funds
  • Understand pre-tax synergies required to break-even and break-even PE analysis
  • Understand the difference between asset sales (including 338h10 elections) and stock sales
  • Grasp taxation issues, including deferred taxes created by the step-up of asset values
  • Gain insight into legal considerations in acquisitions
     

Who Should Attend

Finance professionals working across all levels in the Oil & Gas industry – treasury, accounting, financial planning & analysis (FP&A), corporate development, business development, M&A, budgeting and forecasting, and controllers – who want to gain new or sharpen their existing O&G financial, valuation, and M&A modeling skill set.

Prerequisites
•Financial Accounting
•Excel, Beginner level
•Access to Wall Street Prep's Excel Crash Course is included in enrollment.

What to Bring: Laptop, Notepad, and Calculator.
 

Credits:

27 CPE

TRAINING CLASS TIME:

9:00 AM–5:00 PM

Available for OnSite Training ONLY.  Submit request for OnSite Training

Seminar Summary:

You'll discover how to develop a comprehensive Oil & Gas (O&G) three-statement forecast model while selecting, locating, and developing appropriate O&G projection drivers and more! (see full course description)

print this agenda print agenda for the Financial Modeling for the Oil and Gas Industry OnSite Training training seminar

 view dates and locations for this seminar

 

 

 

Custom Search