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 attend ?

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

About EY

EY | Assurance | Tax | Transactions | Advisory

EY is a global leader in assurance, tax, transaction and advisory services. The insights and quality services we deliver help build trust and confidence in the capital markets and in economies the world over. We develop outstanding leaders who team to deliver on our promises to all of our stakeholders. In so doing, we play a critical role in building a better working world for our people, for our clients and for our communities.

EY refers to the global organisation, and may refer to one or more, of the member firms of Ernst & Young Global Limited, each of which is a separate legal entity. Ernst & Young Global Limited, a UK company limited by guarantee, does not provide services to clients.

LEARN

  • Advance Excel
  • Cross Check the Balance Sheet/Case Flow Statement
  • Explain the DDM
  • Prepare a Full DCF Model
  • VBA and much more

Key Highlights

  • 56+hrs. of classroom training splitting into 14 weeks
  • Step by step guide to financial modeling projection
  • Live Interaction with the industry faculty
  • Industry Based Live Case Studies
  • Practice Sheets, Assignments & Study Materials
  • Industry Oriented Certificates of completion / excellence

Our Faculty

AIMA has brought together a team of highly skilled individuals on its faculty team that bring with them extensive industry experience. These individuals have had global exposure in the field of Investment Banking, Equity Research, Private Equity, & Credit Research.

WHY CHOOSE US

Free Backup Classes

Free Backup Classes

We understand emergencies can happen anywhere, anytime. That's why we offer free backup classes so that your learning never gets hampered.

Assignments/Practice Sheet After Every Weekend

Assignments/Practice Sheet

Weekly assignments & practice sheets are provided to students to allow them to use the time away from the classes to increase their subject understanding.

Physical Materials for Learning

Physical Materials for Learning

Besides regular assignments, students are also provided with quality physical study material designed to maximise the concept understanding of students.

Limited Batch Size

Limited Batch Size

Max batch size of 15 students. We believe learning happens best when it’s a small & comfortable environment for students.

Live Case Studies Based Training

Live Case Studies Based Training

Practical curriculum designed by industry professionals including case studies & live examples making for a comprehensive

WHAT CAN I BECOME?

Financial Analyst, Financial Manager, Market Research Analyst, Venture Analyst, Equity Research Analyst, Market Data Quantitative Analyst, Private Equity Finance Manager, Business Valuation Consultant

  • Duration – 4 Months
  • Session Commences – January, May and September

Financial Modeling Certification

After successful completion of the training the candidates will be awarded Certificate in Financial & Valuation Modeling, a joint certificate from AIMA and Ernst & Young.

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 Rs. 40,000/- + GST as applicable
  • For online registration ( click here )

Assessment Criteria

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

For further clarification, please contact the undersigned

Prabha Soloman
Manager- Centre for Management Education

All India Management Association (AIMA)

15 Link Road, Lajpat Nagar – Part III,

Near Lajpat Nagar Metro Station, New Delhi – 110024

Contact : 011 - 47673000/49868399. Ext: 705

Mobile : +91 8178348863/7838935604

Email : psoloman@aima.in

Website : www.aima.in

COURES CURRICULUM

  • Creating a template for the financial model
  • Timelines, flags and counters
  • Setting up the inputs sheet and scenario manager
  • Modeling of P& L items- revenues
  • Modeling of P&L- fixed cost and variable cost
  • Modeling for fixed assets and depreciation
  • Depreciation methods- Straight line method and written down value method
  • Revision test-1
  • Introduction to capital structure – equity and debt theory
  • Setting up an equity schedule
  • Debt schedule demo
  • Preparing the debt schedule under various repayment profiles
  • Modeling for working capital
  • Modeling of tax
  • Integrating the financial statements
  • Modeling for DSRA, DSCR and covenants
  • Understanding interest during construction and how to break circularity , build a simple macro
  • Setting up checks, building sensitivities and scenarios
  • Creating a simple dashboard
  • Valuation modeling – DCF method
  • Wrap- up
  • Doubts clearing session
Rs. 40,000/ (Plus GST as applicable)

Payment Schedule

Fee Particulars Fee
First Month ₹ 10,000/-
Second Month ₹ 10,000/-
Third Month ₹ 10,000/-
Fourth Month ₹ 10,000/-

Installment option
Group Discount: 15% discount for 3 or more registrations
Price includes 4 months Course fee + Certification Exam fee + Study material
×

Download Brochure

Please provide a name and email address, and a phone number if you'd like us to call and assist you through the process.

×

*Please note that by filling the form, you are agreeing to our terms & conditions in the disclaimer section.