Trainees develop an Oil & Gas (O&G) financial model completely from scratch, inputting historical data as well as macro– and company-specific assumptions to project out financial statements using step-by-step instruction on selecting, locating, and developing appropriate projection drivers. At completion, trainees will have developed a comprehensive O&G model using various supporting schedules. Trainees build O&G models using Excel templates and the exact way they would on the job.
Oil & Gas NAV Modeling Guide Sample
Oil & Gas Modeling Industry Primer Sample
Sample Oil & Gas Modeling Template
What You Will Learn
- Industry Accounting & Financial Statement Analysis
- Financial Statement Modeling
- Net Asset Value (NAV) and DCF modeling
- Accretion/dilution (M&A) modeling
- Leveraged buyout (LBO) modeling
- Comparable company analysis
- Comparable transaction analysis
- Financial & valuation modeling best practices
- Excel mechanics and functionality for the O&G industry
Oil & Gas Modeling Highlights
Intuitive, Self-Paced and Comprehensive
Wall Street Prep’s Oil & Gas Financial & Valuation Modeling Self Study Program is intuitive and self-paced. You should expect to spend approximately 100 hours to complete it. The program uses approximately 700 pages of tutorial guidance and Excel model templates to teach students how to build, analyze, and interpret Oil & Gas financial and valuation models in a step-by-step fashion, at their own pace.
Real World “On the Job” Investment Banking Training
The Oil & Gas Financial & Valuation Modeling Self Study Program bridges the gap between academics and the real world to equip O&G finance and industry professionals with the practical financial skill set they need on the job. The program utilizes a case study format, as students follow their tutorial guide alongside the Excel model templates, and are directed to the appropriate external documents (SEC filings, research reports, etc.) in order to build complex O&G Financial & Valuation models the way they would on the job.
Upon enrollment, students gain 24-month free access to Wall Street Prep’s Online Support Center, where they receive answers to questions, free downloads, and important updates.
Boost Add-In for Excel
Free Access to Boost, an all-in-one suite of time-saving tools designed for people who build financial models in Excel. Key features include: Attach common number formats to keyboard shortcuts and cycle rapidly through the different font and color schemes; Easily understand long formulas with the powerful ‘Precedents’ and ‘Dependents’ Tool; and much more!
The course is self-paced and anyone is welcome to enroll. It does not assume a prior background in Oil & Gas Modeling. However, those who select this course should possess knowledge in:
- Accounting: The program assumes a basic introductory knowledge of accounting (e.g. interaction of balance sheet, cash flow, and income statement). Students with no prior background in Accounting should enroll in the Accounting Crash Course.
- Corporate Finance: Although general exposure to corporate finance is helpful, it is not required.
- Excel: Basic introductory Excel knowledge is highly recommended. Students with limited or no experience using Excel should enroll in the Excel Crash Course.