Certificate Programme Financial & Valuation Modelling 

offered by All India Management Association

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

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

Calculate the Free Cash Flow to Firm (FCFF) & Free Cash Flow to Equity (FCFE)

Calculate the Discount Rate (Cost of Debt, Cost of Equity & Cost of Capital)

Identify the Revenue Drivers and Cost Drivers

Prepare a Full DCF Model

Calculate Equity Value Multiples: P/E, P/CF, P/BV, P/S, PEG, Dividend Yield

Provide an overview of Trading Comparables

Calculate basic EV and perform various CACS Adjustments

Normalise the Earnings and identify the exceptions

Calculate Last Twelve Months (LTM) or Trailing Twelve Months (TTM)

Perform Trading Multiples analysis – EV/EBITDA, EV/EBIT, EV/Sales

Provide an overview of Transaction Comparables

Describe the different kind of Deal Considerations

Practice working on the Transaction Template

The programme is designed to offer students the intensive instruction and training needed to successfully compete in rapidly developing global financial markets

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