Equity Valuation and Financial Modeling

Introduction
A financial model is designed to represent in mathematical terms the relationships among the variables of a financial problem so that it can be used to measure business performance. This hands-on course is designed to help the participants understand the essence of the subject and simultaneously use this knowledge on “real-world” problems to construct consistent and realistic financial models using MS excel as an analytical tool.

Course Highlight

• Open platform to interact with the faculty Mr. Sunil Teluja*, FRM MBA
• Discussions closest to the real world with live case studies
• Balanced exposure of theoretical and practical aspects in detail
• Periodic evaluation of performances and individual monitoring & enhancement programs

Course Content

• Cost of Capital
  • Advanced Concepts of Capital Allocation and Beta
  • Beta Calculation from Raw Data
• Discounted Cash Flow
  • Advanced Concepts of Free Cash Flows (FCFF/FCFE)
  • Terminal Value Calculation
• Mergers & Acquisitions
  • Modeling for Mergers & Acquisitions
• Leveraged Buyout (LBO)/Private Equity
  • Modeling for Private Equity, LBO Transactions

• Financial Institutions Group (FIG)
  • Forecasting P&L for Financial Institutions
  • Forecasting Balance Sheet for Financial Institutions
  • Valuation Modeling for Financial Institutions
• Sector Specific Modeling
  • Modeling for a Particular Sector Chosen by Candidate
• Practical Modeling
  • Creation and Presentation of a Model of a Company Allocated to Candidate