Financial Modeling for Analysts and Investment Bankers

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 is to study a promising sector like consumer goods Industry and valuation of that sector, to study steps of building financial model and to enhance the sector expertise.