Want to know about financial modeling?

Financial Modeling is a core skill that is almost mandatory for anyone who wants to build a career in finance.  It teaches you to work with historical information on companies and analyze the company/industry performance on relevant financial parameters. This analysis is then used as an input to build financial models. These models project the future financial performance of the project/companies and help us to take financial decisions like valuation of companies using DCF technique, price targets for stocks, projecting the combined Company after merger & acquisition, Merger & acquisition EPS accretion/dilution analysis, etc.  

Working knowledge of determining value of stock using Discounted cashflow technique, multiples approach and other common approaches to stock valuation. Helps in deciding Buy/Sell decision for stock. Performing scenario analysis to determine tradable price range of stock.

Working knowledge of merging financial statements of two companies, accounting for synergies and analyzing likely effect of deal on EPS. Performing sensitivity analysis of synergy on change in EPS.

Working knowledge of projecting the performance of target between period of entry and exit, determining likely exit multiple, performing sensitivity analysis of change in exit multiple and NPV of transaction, determining sponsor IRR and equity IRR.

1. No prior knowledge is required for Module 1
2. Knowledge of Module 1 is required for Module 2 & Module 3.
3. Students have to use 2 laptops - one to watch the class and other to practice.