Oil & Gas Modeling

 

OilGasModeling1 Oil & Gas Modeling

 

Oil & Gas Modeling teaches you how to value and model natural resource companies and how they’re different from normal companies.

Everything is based on a case study of Exxon Mobil’s $41 billion acquisition of XTO Energy – one of the largest energy M&A deals ever – and the entire program is integrated with real SEC filings and equity research from banks like JP Morgan, Credit Suisse, and Deutsche Bank.

You’ll start with a crash-course on oil & gas accounting, production, and reserves, and then you’ll get to create operating models for both Exxon Mobil and XTO based on their energy production levels.

After that, we’ll jump into a full valuation of XTO including the Net Asset Value (NAV) model, before completing a detailed 3-statement merger model between Exxon Mobil and XTO and concluding with a hypothetical leveraged buyout model.

 

What do you get when you sign up for the course?

 

Prerequisites: Excel & Financial Modeling Fundamentals or equivalent (this is an advanced course).

✓Lessons cover the 3 financial statements for oil & gas companies, production and reserves, operating models, valuation via public comps, precedent transactions, DCF and Net Asset Value (NAV), oil & gas merger models, and LBO modeling.

54 videos total (21 hours of footage).

6 quick reference guide PDFs on key topics – from accounting through valuation, merger models, and LBO models.

✓Overview and Operating Model lessons teach you how to project and work with production and reserves, successful efforts vs. full cost accounting, and how to link revenue and expenses to hedging, price realization and unit of production assumptions; complex debt schedule and alternative operating model for Exxon Mobil are also covered.

✓Valuation course covers public comps and precedent transactions for energy companies, the key metrics and multiples to use, how a DCF is different, and how to create a full Net Asset Value (NAV) model based on data in filings and equity research.

✓Merger Model lessons teach you how to use the actual Exxon Mobil – XTO Merger Agreement to make assumptions, how to combine the 3 statements for oil & gas companies, and how acquisition effects, synergies, contribution analyses, and accretion / dilution differ for energy companies.

✓LBO Modeling course covers the key differences when modeling oil & gas companies, how to modify XTO’s debt schedules to support refinancing and 7 new debt tranches, and how to analyze returns based on commodity prices.

✓You receive instant access when you sign up because everything is delivered online – no shipping charges or physical products to worry about.

✓Free lifetime updates and support.

 

Full Course Price: $247

 

Here’s a bonus for you!!

 

If you enroll to this program through this page, you will get :

PowerPoint Pro Program to create M& A Pitch Books ($ 47) absolutely FREE!!!

Click on Sign Up Now to register.

 

 

button 01 Oil & Gas Modeling