Course Overview
Financial Modeling on Consumer Goods & Services (CG&S) Sector:
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 Consumer Goods 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. Since real estate is a booming sector from past ten years, and real estate prices have shoot up multi fold in past couple of years, knowledge about valuation of a real estate 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.
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 consumer goods 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
Pre-Requisites:
- Basic knowledge of financial accounting, ratios
- Concepts of financial management, valuation methodologies
- Basic knowledge on Microsoft excel and word