Certificate Programme Financial & Valuation Modelling 

offered by All India Management Association

People with basic to intermediate skill of working with Excel and at following levels in their organisations are suitable candidates:

• Students in the final year of a degree course may provisionally register for the programme
• Finance managers
• Corporate Finance, Private Equity and M&A professionals
• CA, FRM, MBA Finance, CFA Programme candidates
• Self-employed finance professionals
• Graduates

• Build a financial model from scratch as done at financial institutions
• Work on Excel and use formatting best practices, efficient formula construction, and appropriate driver selections
• Use Advanced Excel functions to present various sensitivities to projected financial metrics
• Fix circularity problems, iteration, and other common modelling troubleshooting
• Cross check the Balance Sheet/ Cash Flow Statement
• Understand and describe valuation and how historical valuation is done
• Understand and explain the techniques, elements and approaches of forecasting
• Provide an overview of Discounted Cash Flow
• Explain the Dividend Discount Model

• This Financial & Valuation modelling programme involves the fundamental theories and practices of valuation analysis, strategy analysis, prospective analysis, DCF modelling, trading comparables and transaction comparables
• Modelling through Excel will build enough confidence in the participants so that they are able to create their own financial model right from scratch, and use it for solving their business problems
• The programme is designed to offer students the intensive instruction and training needed to successfully compete in rapidly developing global financial markets