Course Overview
Oil & Gas Sector Financial Modeling of Noble Energy:
This course is very useful for the people who are into equity research and financial modeling domain – including students and professionals. This course gives a brief idea about valuing the companies in Oil and Gas Sector, the revenue and cost drivers, forecasting the future financials and the stock price recommendation.
This course gives a career prospect to the students who are planning to get a financial analyst job in any brokerage and KPOs. Knowledge about valuation of an oil and gas company and report writing would give the student an edge over the competitors. Also it boosts sector expertise of the seasoned professionals who are already working in the financial service domain. First we go step by step about how to prepare a financial model, starting from data punching to forecasting the future numbers, valuation of the stock and arriving at a target price. The tutorials include the following;
1. Sector overview
2. Explaining the company
3. What is SEC filing, types and how we see those
4. How to build financial models of an Oil and Gas company with steps
5. Punching historicals
6. Projection of P&L with revenue, cost and other line items
7. Projection of balance sheet
8. Projection of cash flow
9. Linking the model and error checks
10. Valuation techniques of Oil and Gas company
11. Valuation and Recommendation
12. Peer comparison
13. Ratio Analysis
Materials included in the course are company financials, which are taken from the company websites. Apart from that, we have explained the steps in Microsoft power point and used Microsoft excel for building the financial model.
Course Objective:
- To study a promising sector like oil and gas Sector and valuation
- To study steps of building financial model
- To enhance the sector expertise
Target Customers:
- Finance Students
- Investment banking Professionals
- Anyone who wants to learn financial modeling and report writing on oil and gas Sector
Pre-Requisites:
- Basic knowledge of financial accounting, ratios
- Concepts of financial management, valuation methodologies
- Basic knowledge on Microsoft excel and word