Show as: Mobile

Financial & Valuation Modeling for the Oil & Gas Industry 3 Day Program

Wall Street Prep
Training overview
3 days
Classroom / Public

Financial & Valuation Modeling for the Oil & Gas Industry 3 Day Program

Financial & Valuation Modeling for the Oil & Gas Industry: Public Classroom CourseFinancial & Valuation Modeling for the Oil & Gas Industry: Public Classroom Course

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.

Who should attend?


This public training boot camp is suitable for the following professionals:

  • Finance Professionals in the Energy Sector
  • Investment Banking Analysts and Associates
  • Private Equity, Asset management and Hedge Fund Associates
  • Corporate Finance and Business Development Professionals
  • MBA’s and Business Suitability and application Undergraduates
  • Anyone seeking to improve their O&G financial and valuation modeling skill set


All course participants must have a fundamental understanding of accounting, corporate finance, and Microsoft Excel.

Live seminar agenda

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: 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: M&A Modeling

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.


Each day's session will be held from 8am to 5pm.

Pre-Seminar Excel online training

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

Instructor profile


If you attend a Boot Camp, you'll be taught by one of the following instructors

Arkady Libman

Arkady co-authored many of Wall Street Prep’s training materials and has conducted corporate training for many of Wall Street Prep’s clients, including Enogex, Rosetta Resources, Hess Corporation, Silicon Valley Bank, RBC Capital Markets, Stifel Nicolaus, and FBR Capital Markets. In addition, Arkady conducts training programs at top business schools across the world, including Wharton, MIT Sloan, Wharton, Tuck, INSEAD, London Business School, and University of Michigan. Prior to joining Wall Street Prep, Arkady was an Associate within the Energy & Natural Resources of the Equity Research Group at FBR Capital Markets. Prior to joining FBRC in October 2001, Arkady was an Investment Banking Analyst within J.P. Morgan Chase’s Global Oil & Gas Group.

Haseeb Chowdhry

Prior to joining Wall Street Prep, Haseeb was an Assistant Vice President in Barclays Wealth's Business Assessment & Strategic Analytics team, focusing on streamlining operations and increasing profitability for specific business lines. Prior to Barclays, he spent two years as an Investment Banking Analyst at Jefferies focusing on maritime, offshore and logistics companies, developing an expertise in unique LBO and capital raising structures. Immediately after graduation, Haseeb helped establish a financing subsidiary for Edible Arrangements International, Inc. Haseeb graduated from the Leonard N. Stern School of Business at NYU with a BS in Finance and Accounting. He currently holds both Series 79 and 63 licenses.

Jeff Schmidt

Jeff’s diverse background includes equity research and corporate development, as well as restructuring and investment banking. Most recently, as an Associate at Tudor Pickering Holt & Co, he covered 20 diverse oil and gas companies with a combined market cap of over $300 billion. Prior to TPH, he covered more than 30 oil & gas companies while at Raymond James. He has been an instructor at Wall Street Prep since 2010, where he has conducted seminars for a variety of financial institutions, consulting firms, and corporations. Jeff has also taught at many of the top MBA programs, including Harvard Business School, The Wharton School, Columbia Business School, MIT Sloan School of Management and more. Jeff holds a BS from Texas A&M University, an MBA from the University of Houston, is a CFA charterholder and holds FINRA Series 7, 63, 79 and 86/87 licenses.

Certificate and Course Credits

CPE Credit

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.

Learning Tools

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.



Earlybird price(s) of $1,799/Full Program (Recommended) $1,499/Days 1 & 2 Only in effect until 3 weeks before the seminar and will subsequently increase to $1,799/Full Program (Recommended) $1,699/Days 1 & 2 Only .

Provider: Wall Street Prep

Wall Street Prep

Wall Street Prep

Wall Street Prep was established in 2004 from a group of investment bankers seeking to enhance the competitive profile of students pursuing careers in the financial services industry. Since then, the company has grown to include self-study training courses, live...

Read more and show all training delivered by this supplier

Request information - obligation free

Fill out your details to find out more about Financial & Valuation Modeling for the Oil & Gas Industry 3 Day Program.

  Contact the provider

  Get more information

  Register your interest

Contact Wall Street Prep

Wall Street Prep

Request Information

Have a question about this course? Fill out this form and the provider will get in touch with you shortly

Training reviews

No reviews available

Need help with your search? offers a free consultancy service to help compare training for you and your team

Request a free quote

Request a free training quote