Wall Street Prep – Oil & Gas Modeling Course
Wall Street Prep – Oil & Gas Modeling Course course is now available at an affordable price. You can check out directly using multiple payment gateway options. If you have any questions or need an alternative payment method, feel free to contact us.
Description
About Course:
What You Will Learn
Industry Accounting & Financial Statement Analysi
Financial Statement Modeling
Net Asset Value (NAV) and DCF modeling
Accretion/dilution (M&A) modeling
Leveraged buyout (LBO) modeling
Excel mechanics and functionality for the O&G industry
Comparable company analysis
Comparable transaction analysis
Financial & valuation modeling best practices
Introduction to O&G accounting & financial statement analysis
Participants will understand dynamics of the O&G industry and the factors determining crude oil and natural gas prices
Learn the different business segments – upstream, midstream, and downstream – that make up the O&G industry
Learn O&G terminology, units, and key terms
Distinguish between full-cost and successful efforts accounting methods and their impact on financial statements and on financial statement analysis
Learn the structure and layout of the O&G financial reports and filings (i.e., 10-K, 10-Q, annual report)
Learn how to analyse and interpret O&G financial statements, footnotes, and disclosures
Understand how to perform O&G reserves and production ratio analysis
Introduction to O&G financial modelling
Building comprehensive O&G financial models from scratch the way it is done at major financial institutions.
Forecasting crude oil and natural gas prices
Understanding the role of price and volume hedges
Standard formatting best practices.
Excel best practices, efficient formula construction, and appropriate driver selections
Learning to use data tables to present various sensitivities to projected financial metrics
Balancing the balance sheet accounts, including excess cash and revolver
Fixing circularity problems, iteration, and other common modelling troubleshooting
Balancing sheet / cash flow statement crosschecks
Overview of O&G valuation modelling
Relative vs. Intrinsic value
Modelling techniques
Calculating and interpreting multiples
Useful Excel shortcuts and functions
The “football field”
Building an O&G Net Asset Valuation (NAV) model
Project cash flows for each major project and field to derive the value of E&P segment
Learn how to value in-ground versus producing reserves
Understanding proper valuation methodology and drivers for each major O&G business segment
Estimating the weighted average cost of capital (WACC) and common pitfalls to avoid
Using data tables to analyse a broad range of scenarios given different assumptions
Building an O&G trading comps model
Set O&G evaluation benchmarks & select comparable companies
Gather appropriate financial history and projections
Normalizing operating results and calculating LTM operating results
Exclude nonrecurring charges, normalize for stock option expense
Calculate shares outstanding using the treasury stock method
Input financial data & calculate and interpret financial and market ratios
Presenting trading comps by structuring output schedule
Selecting key valuation multiples using the VLOOKUP function and generating multiple tables
Building an O&G transaction comps model
Similarly, to trading comps, trainees set O&G evaluation benchmarks, select precedent O&G transactions, gather appropriate financial details, input financial data, and calculate and interpret financial and market ratios
Calculating purchase premiums
Understanding pricing structures (fixed vs. floating, collars, and walk-away rights)
Best practices for incorporating synergy assumptions and appropriately calculating unaffected pre-deal share prices
Building an O&G M&A modelling
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.
Delivery Policy
When will I receive my course?
You will receive a link to download/view your course immediately or within 1 to 24 hrs. It may takes few minutes, also few hours but never more than 24 hrs. Due to different time zone reasons.
How is my course delivered?
We share courses through Google Drive, so once your order is complete, you’ll receive an email with a google drive folder access link to view the course in your email.
To avoid any delay in delivery, please provide a Google mail and enter your email address correctly in the Checkout Page.
In case you submit a wrong email address, please contact us to resend the course to the correct email.
Where can I find my course?
Once your order is complete, a link to download/view the course will be sent to your email.
