background
Wharton & Wall Street Prep Private Equity Certificate: Now Accepting Enrollment for May 1-June 25 →
Wall Street Prep
  Wed, Oct 11 - Fri, Oct 13, 2023 (ET)

Financial Modeling for the Oil & Gas Sector

3-Day Virtual Boot Camp

Learn Oil & Gas Modeling the Way It's Done on the Job

  • Build a "Job-Ready" O&G Model From Scratch

    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.

  • Taught by Experienced O&G Professionals

    This is NOT an academic exercise. This seminar is taught by experienced energy-focused investment banking professionals with a specific focus on the modeling skills needed to succeed on the job.

Agenda

This event is in Eastern Time (ET).
Each day runs from 9a-5p.

Day 1
Day 1
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
Day 2
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
Day 3
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
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.

View Full Syllabus

Wall Street Prep training is used at ...

clients clients

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

Revisit what you learn

This virtual seminar will be recorded and available for you to review any time from your Wall Street Prep learning dashboard.

Overview

This boot camp is an intensive 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.

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 to most boot camps includes access to our continuing education online training platform and webinar series.

Earn 9.5 CPE Credits with WSP Online Courses

Wall 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 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.nasbaregistry.org.

Questions? We're Standing By.

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

I agree to the Terms and Privacy Policy
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.