Certificate In Financial Modeling (CIFM)

The Certificate in Financial Modeling (CIFM) certification is a comprehensive global certification exam designed to assess a candidate’s expert level understanding of Financial Modeling with Excel on investment management including equity, fixed income, alternative investments, investment banking, financial advisory, financial engineering and corporate finance decision making. 

This program tests a candidate on his capability to develop a disciplined and systematic approach to take financial and investment decisions with the help of excel tools.

Course Outline

Finance skills required:

• Basics of Time Value of Money
• Preparing loan amortization schedule and related calculations
• Capital budgeting and its techniques.(NPV, IRR, Payback Period)
• Fundamental analysis of securities (DDM & FCF).
• Mergers and Acquisitions, post-merger calculations.
• Financial statement analysis using ratios(Profitability, Activity, Solvency,
  Liquidity)
• Dividend and its payout policies (Constant Dividend, Constant Pay-out,
  Residual Approach, Share Repurchase).
• Relative valuation (Justified and trailing ratios, EV/EBITDA approach).
•  Risk and return calculations using standard deviation.
•  Concept of capital structure and cost of capital.

Excel skills required:

• Navigation, use of Spreadsheet, Basic mathematical Calculations
• Basic excel functions: SUM, AVG, MAX, MIN, Count, etc.
• Mathematical functions: Sumif, AverageIf, Round, etc.
• Logical functions: If, And, OR.
• Finance functions: NPV, IRR, PMT, Cumipmt, Nper.