Certificate in Financial Modeling (CIFM)

About

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.

 

Who should do Financial Modeling?

This Financial Modeling Certification is suitable for people in Investment banking, Investment management, Corporate Finance, Equity research, Credit Research, Business planning & strategy, Private equity funds, Hedge Funds, Portfolio Management or commercial banking. It is also ideal for all finance specialist and generalists or graduates who want a career in any of the profiles related to:

  • Investment Banking Analyst
  • Equity Analyst
  • Fixed Income Analyst
  • Investment Advisor
  • Portfolio Manager
  • Corporate Strategy and Finance

The evolution of financial markets the world over along with other investment classes, have created a need for finance professionals with a new level of sophistication and a deep understanding of analysis using tools such as excel & technology. The FM certification is a credential designed specifically for financial professionals who want to attain an advanced level of competency in Financial Modeling

Careers after Certificate in Financial Modeling

After successful completion of the program one would be able to add desired value in a career in the following fields

  • Investment Banking
  • Private Equity
  • Hedge Funds
  • Equity Research (Buy-Side and Sell-Side)
  • Asset Management
  • Corporate Finance and Strategy
  • Private Wealth Management

In addition, the course will benefit Fresher’s, Entrepreneurs, Advisors, and Accountants who are involved with financial markets…

Reference Book – Certificate in Financial Modeling

The Suggested/Recommended reference books are available on leading bookstores and online portals. Students can buy the recommended reference book directly from the Market for the said course. The reference book fees are not included in your Exam Fees.

  • Financial Modeling (MIT Press) – by Simon Benninga
  • Financial Analysis and Modeling Using Excel and VBA by Chandan Sengupta
  • Financial Modeling in Practice:A Concise Guide for Intermediate and Advanced Level
    by Michael Rees
  • Financial Modeling and Valuation: A Practical Guide to Investment Banking and Private
    Equity by Paul Pignataro
  • Financial Modeling for Business Owners and Entrepreneurs:Developing Excel Models
    to Raise Capital, Increase Cash Flow, Improve Operations, Plan Projects, and Make
    Decisions by Tom Y. Sawyer
  • Financial Modeling: A Backward Stochastic Differential Equations Perspective
    (Springer Finance) by Stephane Crepey
  • Building Financial Models (McGraw-Hill Finance & Investing) by John Tjia
  • The Oxford Guide to Financial Modeling: Applications for Capital Markets, Corporate
    Finance, Risk Management and Financial Institutions by Thomas S. Y. Ho & Sang Bin
    Lee
  • The Mathematics of Financial Modeling and Investment Management by Sergio M.
    Focardi & Frank J. Fabozzi
  • The Handbook of Financial Modeling: A Practical Approach to Creating and
    Implementing Valuation Projection Models by Jack Avon

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.

Eligibility

A graduate from any stream (Undergraduate Students can register for exams but would be awarded the final certificate after graduation). Schedule exam after paying exam fees on any working day on any of the above centres.

Training Calendar: 

You can find the upcoming training schedule for CIFM program here

Exam Details

AIWMI is offering the CIFM examination on an external, remote-proctored platform.  Candidates can schedule an exam by paying the exam fee. Once the exam fee payment is done and exam registration is confirmed, the exam platform sends out the exam link by email to the candidates. Candidates can appear for the exam anytime any day within the next 1 year through this exam link from any place. Candidates need a good internet connection and a functional camera on their PC/ Laptop to appear for this exam.

CIFM EXAM STRUCTURE

AIWMI offers the FM examination across 5000+ Pearson VUE computer testing centers in 180 countries worldwide. Candidates can schedule exam after paying exam fees on any working day on any of the above centres.

Sr. No. Name of Module Type of Questions Test Duration No. of Questions Maximum Marks Pass Marks (%) Negative Marking
1 Certificate in Financial Modeling (CIFM) 1 Mark MCQ – 40

2 Mark MCQ-30

2 Hrs 70 100 50 Negative marking will be applicable from 1st January 2022

CIFM FEE STRUCTURE

Registration Fee for CIFM Program is as given below:

Fee Regular Mode Self Study Mode Exam Mode
Registration
Fee
17700 5900
Exam
Fee
2360 2360 2360
Total 20060 8260 2360
Inclusions 1. Session notes
2. Live online tutorials
3. Past tutorial session recordings
4. Guest sessions by Thought Leaders
5. Mock test
6. Instructional PPTs
7. Refresher tutorials (3 sessions)
8. Exqualifi Membership- 1 Year
9. Complimentary pass to all AIWMI virtual conferences for 1 year
1. All tutorial session recordings
2. Session notes
3. MockTest
4. Refresher sessions (3 sessions)
1. Exam fee for one attempt

Disclaimer: The Association of International Wealth Management of India (AIWMI) is an independent entity/brand and has no relation, whatsoever, with AIWM