Wall Street Prep

Oil & Gas Industry Modeling Boot Camp

Master O&G financial and valuation modeling in this 3-day intensive virtual boot camp

What You'll Learn

  • Learn O&G Modeling, Valuation, DCF, NAV and M&A
  • Taught by experienced bankers
  • Includes Excel model templates

This intensive course is designed to equip O&G finance and industry professionals with the practical financial skill set they need on the job. Participants develop O&G financial and valuation models from scratch using step-by-step instruction on selecting, locating, and developing appropriate projection drivers.

Pricing

Full Boot Camp (Recommended)
$1,899
Days 1 and 2 Only
$1,499
Group Rates
discount
available

Agenda

Please Note: Times for this event are in Central Time (CT)

Day 1
9am - 5pm
Oil & Gas Financial Statement Modeling

Participants develop an Oil & Gas (O&G) financial model completely from scratch, inputting historical data as well as macro and company specific assumptions to project financial statements using step-by-step instruction on selecting, locating, and developing appropriate projection drivers.

Day 2
9am - 5pm
Oil & Gas Valuation Overview, DCF & NAV Modeling

Valuation represents the heart of the investment banking and corporate finance skill set. Before building Oil & Gas (O&G) valuation models, participants will learn the conceptual underpinnings of the valuation framework.

Day 3
9am - 5pm
Oil & Gas M&A Modeling

Inputting deal assumptions, Calculating shares outstanding, Allocating purchase price and calculating goodwill, Building pro forma income and cash flow statements, Error-checking a merger model and inserting circuit breaker switches.

Online
Pre-Seminar Excel training

This boot camp assumes proficiency in Excel. Enrollment includes access to our popular Excel Crash Course for those who need an Excel refresher.

Wall Street Prep Virtual Training

WSP virtual training events are not your standard online class. We’ve all been there: You log in only to watch a presenter go back and forth from webcam to screen share.

A WSP Virtual Boot Camp is an engaging learning experience that preserves the opportunity for instructor-trainee interaction, experiential learning and networking with fellow learners. Learners move back and forth between instructor presentations, group breakout rooms and competitions at a lively pace.

Who is this boot camp for?

  • Private Equity, Asset management and Hedge Fund Associates
  • Investment Banking Analysts and Associates
  • Corporate Finance and Business Development Professionals
  • MBAs and Business Undergraduates
  • Anyone seeking to improve their O&G financial and valuation modeling skill set

Boot Camp Details

Overview

This boot camp is an intensive virtual training program where trainees learn financial and valuation modeling in Excel using an intuitive, step-by-step approach. Participants will use real case studies to build financial models from scratch the way it is done at financial institutions. The program is a synthesis of Excel modeling, navigating through various financial reports, and the application of accounting, corporate finance, and valuation courses.

Schedule

Virtual training runs daily from 9am to 5pm. The day will be filled with interactive exercises as learners move back and forth between classroom lecture, small group breakout rooms, competitions  and 1-on-1 interaction.

Virtual Training Setup

Learn about technical details and more at our Virtual Training FAQ.

What’s Included?

Comprehensive training materials (manuals and online exercises), Detailed reusable modifiable Excel model templates, Unlimited e-mail support for content-related questions for 12 months post-seminar

Prerequisites

This seminar presumes knowledge of financial accounting (at least 1 semester or equivalent). Participants without this background must enroll in and complete the Accounting Crash Course prior to attending the seminar.

CPE Credit

CPE logoWall Street Prep is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.learningmarket.org.

Cancellation Policy

Participants may cancel up to 3 weeks prior to the event for a full refund. A 20% cancellation fee will apply up to 1 week prior to the event. No refunds will be granted for cancellations made within 1 week of the event. Wall Street Prep reserves the right to cancel the seminar if enrollment is insufficient. Trainees will be refunded in full in the event of a cancellation.

Why attend a boot camp?

  • Comprehensive training

    Our live courses pulls no punches. Each boot camp is the same intensive training used to prepare incoming analysts at top financial institutions.

  • Learn by doing

    Attendees “learn by doing” by working through practical exercises and building financial models from scratch using real case studies.

  • Networking opportunity

    Boot camps provide an opportunity to network with MBAs and professionals from industries including investment banking, corp dev and FP&A.

  • Experienced instructors

    Our instructor-practitioners are experienced bankers who give real-world context by connecting training to their own experience on the desk.

  • Excel Mastery

    Our training reinforces speed, efficiency and consistency in Excel that investment banking analysts are expected to have on Day 1.

  • Continuing ed & webinars

    Enrollment includes lifetime access to our continuing education online training platform and our popular monthly webinar series.

Syllabus

Oil & Gas Financial Statement Modeling

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 analyze 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 modeling

  • 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 modeling troubleshooting
  • Balancing sheet / cash flow statement crosschecks
Oil & Gas Valuation Overview, DCF & NAV Modeling

Overview of O&G valuation modeling

  • Enterprise value vs. Equity value
  • Relative vs. Intrinsic value
  • Modeling 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 analyze a broad range of scenarios given different assumptions
Oil & Gas M&A Modeling

Building an O&G M&A model

  • Inputting deal assumptions (% cash vs. stock considerations, purchase premium, O&G asset write-ups, advisory fees, financing fees, and severance fees)
  • Calculating shares outstanding using the treasury stock method
  • Appropriate treatment of convertible securities
  • Allocating purchase price and calculating goodwill in O&G transactions
  • Making pro forma balance sheet adjustments
  • Calculating sources & uses of funds
  • Inputting O&G operating & synergy projections
  • Building pro forma income and cash flow statements and making appropriate deal-related adjustments to arrive at accretion/dilution per share on both earnings and cash flow basis.
  • Error-checking a merger model and inserting circuit breaker switches where appropriate
  • Pre-tax synergies required to break-even, and break-even PE analysis

Questions? We're standing by.

To learn more about this boot camp, fill out the form below or call us at: 617-314-7685









X

The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.