Day 1: Oil & Gas Financial Statement Modeling in Excel (including Excel Best Practices)
Day 2: Oil & Gas Financial Modeling in Excel
Day 3: Oil & Gas Trading & Transaction Comps Modeling
Day 4: Oil & Gas M&A (Accretion/Dilution) 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. At completion, participants will have developed a comprehensive O&G model using various supporting schedules.
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.
Trading comparables or "comps" analysis is the quickest, most widely used valuation methodology, and fundamental part of the core valuation skill set of investment bankers and finance professionals. Participants will learn how to select O&G comparables and build dynamic comps models in Excel from scratch, using real case studies, industry best practices, and sensitivity analyses
Participants build an Oil & Gas (O&G) merger model in Excel to reflect the pro forma impact of various acquisition scenarios.
Registration deadline is October 1, 2018.
Cancellation Policy: A full refund will be given to cancellations received by October 1, 2018. A cancellation fee of 50% applies for cancellations received after October 1, 2018. The cancellation fee will only apply if the spot cannot be filled. Substitutions from the same company are accepted.
INCLUDED IN COST:
Course notes and materials
Morning refreshments, lunch, and afternoon refreshments each day
Participants are required to bring a laptop loaded with Excel