Course Overview
Equity Research of Walgreen Co.:
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 a company, 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. 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;
- Major financial statements
- Financial ratios with condensed balance sheets and common size statement of income
- Evaluating operating performance using operating efficiency ratios and operating profitability ratios
- Risk analysis
- Analysis of growth potential
- Comparative analysis of ratios
- Specific uses of financial ratios
- Company analysis
- Estimating intrinsic value
- Estimating company earnings per share
- Walgreen Co.’s competitive strategies
- Estimating company earnings multipliers
- Additional measures of relative value
- Analysis of growth companies
- Measures of value added
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 steps of building financial model
- To enhance the sector expertise
Target Customers:
- Finance Students
- Investment banking Professionals
- Anyone who wants to learn financial modeling
Pre-Requisites:
- Basic knowledge of financial accounting, ratios
- Concepts of financial management, valuation methodologies
- Basic knowledge on Microsoft excel and word