Questions? 800-646-3575
info@wallstreetprep.com
Key Learning Outcomes
• 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 vol-
ume hedges
• Standard formatting best practices.
• Excel best practices, efficient formula
construction, and appropriate driver se-
lections.
• Learning to use data tables to present
various sensitivities to projected finan-
cial metrics.
• Balancing the balance sheet accounts,
including excess cash and revolver.
• Fixing circularity problems, iteration,
and other common modeling trouble-
shooting.
• Balancing sheet / cash flow statement
crosschecks.
MORNING SESSION (9-11AM)
Introduction to financial modeling
• Overview of financial modeling
• Understanding projections
• Modeling techniques
• Excel best practices foundation and exercises
• Useful Excel shortcuts and functions
• Gathering historical documents/information
MIDDAY SESSION (11AM-3:30PM)
Building the O&G model , step-by-step
• Setting up the core financial statements
• Projecting commodity prices and production levels
• Projecting income statement for each major O&G segment
• Working capital, Depreciation & amortization (PP&E), and Other bal-
ance sheet items.
• Shareholders’ equity & Shares Outstanding
• Debt & Interest
AFTERNOON SESSION (3:30-5PM)
Improving the finished product
• Controlling circular references using automated circuit breakers
• Balancing the model
• Scenario analysis—toggles and data tables
Day 1 Overview
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 out financial statements using step-by-step instruction on
selecting, locating, and developing appropriate projection drivers. At
completion, participants will have developed a complete and comprehensive
three-statement O&G model using v