THE OFFICE OF AIMA CENTRE FOR MANAGEMENT EDUCATION AT ANDHRA ASSOCIATION BUILDING, 24-25 INSTITUTIONAL AREA, LODHI ROAD, NEW DELHI HAS RELOCATED TO AIMA’S NEW PREMISES AT 15, LINK ROAD, LAJPAT NAGAR, PART-III, NEW DELHI W.E.F 6TH NOVEMBER 2017                   The office of AIMA Centre for Management Services at Management House, 14 Institutional Area, Lodi Road, New Delhi - 110003 has relocated to AIMA’s new premises at 15, Link Road, Lajpat Nagar, Part-III, New Delhi w.e.f. 13th November 2017

Short Term Courses

Now in collaboration with Moody’s Analytics Knowledge Services

Certification in Financial & Valuation Modeling

Enquiry Form    Online Registration    Online Registration



Admissions open
for
Certificate in Financial & Valuation Modeling
for Online Batch

Batch starts July 2017

CFVM 1 CFVM 2

AIMA and Moody’s Analytics Knowledge Services jointly bring Financial & Valuation Modeling Certificate Programme

In today's world of extensive data where decisions are highly quantitative based financial modeling has become an indispensable tool. It is the most sought after skill required in the field of investment banking, equity research, project management, commercial banks and mostly all other sectors in the financial services industry. Financial modeling is the art of building a model using excel to depict financial statements and investment analysis. It builds a structure that integrates various statements and schedules to enable decision making. A financial model represents the performance of a business, a project or any other investment.

This Financial & Valuation modeling programme involves the fundamental theories and practices of valuation analysis, strategy analysis, prospective analysis, DCF modeling, trading comparables and transaction comparables. Modeling 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.

Learning Objectives

After completing this course, the participants will be able to:

  • 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 modeling 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
  • Perform the Private and Public Transaction Comp
  • Perform Transaction Multiples analysis – EV/EBITDA, EV/EBIT, EV/Sales

Who should do Financial Modeling?

  • Graduates/ Post graduates interested in building career in investment banking, project management, equity research, business planning, equity funds or commercial banks
  • Chartered accountants
  • Professionals wanting to upgrade their skills and move into decision making knowledge oriented roles.
  • Professionals working in infrastructure related projects dealing with project finance.

Eligibility

  • Graduation (10+2+3) in any discipline from a recognised University / 3-year Diploma in any discipline if equivalent to graduation.
  • Students in the final year of a degree course may provisionally register for the programme.
  • Students doing other professional courses like MBA, MFS, CA, CS, ICWA can do this course concurrently.
Duration Four Months Certification
Session Commences (Classroom Training) January, May and September Joint Certification from AIMA & Moody’s Analytics Knowledge Services
Session Commences (ONLINE) March, July, November Joint Certification from AIMA & Moody’s Analytics Knowledge Services

Programme Fee & Study Material

  • Class room training : Rs. 28,000/- payable at the beginning of the Programme + plus GST as applicable
  • Online : Rs. 20,000/- + GST as applicable
  • Study Material will be provided.

Registration Requirements for Students

  • Fill in the registration form (Download form)
  • Attach 2 passport size photographs. (Soft copies in online registration process)
  • Pay fees through a Cheque in favor of AIMA payable at New Delhi or online payment of INR 28,000 + applicable GST

Assessment Criteria

Serial No. Assessment Criteria (per subject) Weightage
Part 1 Assignment 40%
Part 2 Final Examination 60%

Course Outline

Session 1

  • Introduction to Excel and Financial Modeling
  • Exploring Excel as a Tool for Financial Modeling

Session 2

  • Advanced analysis techniques

Session 3

  • Financial Statement Analysis
    Understanding the Financial Statements and its interlinking:

Session 4

  • Introduction to Valuation

Session 5 & 6

  • Making a complete fully integrated DCF Modeling Spreadsheet

Session 7

  • Trading Comparables

Session 8

  • Transaction Comparables

Session 9

  • Investment Banking (IB)

Session 10 & 11

  • Project Finance Modeling

Session 12 & 13

  • Advanced Excel using VBA Programming

Session 14

  • Career Counseling Session & Final Assessment

For Inquiries
Neha Malhotra
Programme Manager
Ph: 011- 47673000 / 49868399 Ext:732
Mob: 9212815742
Email: nmalhotra@aima.in

For Other Queries
Prof. Sarah Nasim
Programme Director

Tel. : 011- 47673000 / 49868399 ext 706.