Wall Street Prep – Oil & Gas Modeling Course

Original price was: $624.80.Current price is: $80.07.

Product Delivery : Instant Delivery. After Payment, You will get the Download link immediately on Email  !



Join us on Telegram:


About Course:

What You Will Learn

  • Industry Accounting & Financial Statement Analysi
  • Financial Statement Modeling
  • Net Asset Value (NAV) and DCF modeling
  • Accretion/dilution (M&A) modeling
  • Leveraged buyout (LBO) modeling
  • Excel mechanics and functionality for the O&G industry
  • Comparable company analysis
  • Comparable transaction analysis
  • Financial & valuation modeling best practices

Introduction to O&G accounting & financial statement analysis

  • Participants will understand dynamics of the O&G industry and the factors determining crude oil and natural gas prices
  • Learn the different business segments – upstream, midstream, and downstream – that make up the O&G industry
  • Learn O&G terminology, units, and key terms
  • Distinguish between full-cost and successful efforts accounting methods and their impact on financial statements and on financial statement analysis
  • Learn the structure and layout of the O&G financial reports and filings (i.e., 10-K, 10-Q, annual report)
  • Learn how to analyse and interpret O&G financial statements, footnotes, and disclosures
  • Understand how to perform O&G reserves and production ratio analysis

Introduction to O&G financial modelling

  • Building comprehensive O&G financial models from scratch the way it is done at major financial institutions.
  • Forecasting crude oil and natural gas prices
  • Understanding the role of price and volume hedges
  • Standard formatting best practices.
  • Excel best practices, efficient formula construction, and appropriate driver selections
  • Learning to use data tables to present various sensitivities to projected financial metrics
  • Balancing the balance sheet accounts, including excess cash and revolver
  • Fixing circularity problems, iteration, and other common modelling troubleshooting
  • Balancing sheet / cash flow statement crosschecks

Overview of O&G valuation modelling

  • Relative vs. Intrinsic value
  • Modelling techniques
  • Calculating and interpreting multiples
  • Useful Excel shortcuts and functions
  • The “football field”

Building an O&G Net Asset Valuation (NAV) model

  • Project cash flows for each major project and field to derive the value of E&P segment
  • Learn how to value in-ground versus producing reserves
  • Understanding proper valuation methodology and drivers for each major O&G business segment
  • Estimating the weighted average cost of capital (WACC) and common pitfalls to avoid
  • Using data tables to analyse a broad range of scenarios given different assumptions

Building an O&G trading comps model

  • Set O&G evaluation benchmarks & select comparable companies
  • Gather appropriate financial history and projections
  • Normalizing operating results and calculating LTM operating results
  • Exclude nonrecurring charges, normalize for stock option expense
  • Calculate shares outstanding using the treasury stock method
  • Input financial data & calculate and interpret financial and market ratios
  • Presenting trading comps by structuring output schedule
  • Selecting key valuation multiples using the VLOOKUP function and generating multiple tables

Building an O&G transaction comps model

  • Similarly, to trading comps, trainees set O&G evaluation benchmarks, select precedent O&G transactions, gather appropriate financial details, input financial data, and calculate and interpret financial and market ratios
  • Calculating purchase premiums
  • Understanding pricing structures (fixed vs. floating, collars, and walk-away rights)
  • Best practices for incorporating synergy assumptions and appropriately calculating unaffected pre-deal share prices

Building an O&G M&A modelling

  • Participants will build an O&G merger model in Excel to reflect the pro forma impact of various acquisition scenarios.
  • Topics covered include a quick test of accretion-dilution in all-stock deals, pricing structures (exchange ratios/collars/” walk-away” rights), purchase accounting, the step-by-step allocation of purchase price, and the derivation of important O&G metrics and ratios.


There are no reviews yet

Be the first to review “Wall Street Prep – Oil & Gas Modeling Course”

Your email address will not be published. Required fields are marked *