Financial Modeling Course Weekend Batch

About this course

It is a science of building models to understand financial statements and plan long term investments. This programme ensures that participants will be able to use the knowledge gained in this course to "real world" problems and develop realistic financial models. This course covers the fundamental theories and practices of valuation analysis, strategy analysis, prospective analysis, DCF modeling, and other models. Be ready to become an expert in company valuation!!

Course Content:

• Introduction to Financial Modeling, Steps in financial Modeling, Advanced Excel Functions for Modeling.
• Understanding Income Statement, Balance Sheet, Cash Flow Statement
• Forecasting Financial statements (along with practical case studies)
• Financial Statement Analysis (FSA) (along with practical case studies)
• Financial ratios (along with practical case studies)
• Time value of money, Cost of capital, Leverage
• Equity Valuation - Dividend Discount Models, Free Cash Flows to Firm and Equity (FCFF and FCFE), Relative Valuation (along with extensive practical case studies)
• Valuation under Mergers & Acquisitions, IPO valuation (along with case studies)
• Other models - Tax model, Loan amortization , Budgets (along with case studies)
• A extensive financial model will be prepared at the end by all the participants which will cover all the major modules covered above and it will give holistic view to all the participants (USP of the course)