Course description
Financial & 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?
Suitability
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
Prerequisites
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.
Duration
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.
Costs
Pricing
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 .
Certification / 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.
Continuing studies
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.
Contact this provider
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...