Equity Research on Pharmaceutical Industry – Aurobindo Pharma:
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 Pharmaceutical Industry, the revenue and cost drivers, forecasting the future financials and the stock price recommendation. Furthermore, it gives an idea how to prepare a report on the sector and companies.
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 a pharma sector company 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.
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 Pharmaceutical Industry and valuation of that sector
- 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 Pharmaceutical Industry
Pre-Requisites:
Section 1: Introduction
- Introduction to Pharmaceutical sector
Section 2 Stpes to Financial Modeling
2 Importance of Pharmaceutical Company
3 Forecasting of Key Line Items
4 What is API ?
5 What is Generic ?
Section 3 Punching Income Statement
6 Pharmaceutical Model of Arvinda Pharma Limited
7 Consolidated Balance Sheet
8 Consolidated Statement of Profit and Loss
9 Punching Balance Sheet
10 Punching Cash Flow Statement
11 Punching Cash Flow Statement Continue
Section 4 Forecasting Revenue and PBT Forecast
12 Forecasting Revenue
13 Forecasting Revenue Continue
14 Forecasting Key Cost Items
15 Forecasting Key Cost Items Continue
16 Forecasting FA and Depreciation
17 Forecasting FA and Depreciation Continue
18 PBT Forecast
19 PBT Forecast Continue
20 Profit Before Tax
21 More on Profit Before Tax
22 Forecasting of Balance Sheet Key Items
23 Forecasting Trade Payable
24 Forecasting Investors and Receivable
Section 5 Linking Balance Sheet
25 Linking Balance Sheet and Cash Flow Part 1
26 Linking Balance Sheet and Cash Flow Part 2
27 Linking Balance Sheet and Cash Flow Part 3
28 Linking Balance Sheet and Cash Flow Part 4
29 Ratio Analysis
30 More on Ratio Analysis
31 Leverage Ratio
Section 6 DCF valuation
32 Valuation and Devaluation Ratios
33 Calculate WCC
34 Calculate FCF
35 Relative valuation
36 Valuation Ratios and Recommendation on Stock
