Updated Online video classes available for CA,CS,CMA for Nov20 batch. Call: 1800-3000-0505

CCI Online Learning
What do you want to learn today?

Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

 CCI Online Learning

Live Classes (2nd Batch)

Financial Modeling and Valuation Certification Course

Live class in association with Grant Thornton in India

Limited Seats   Starting from 4th July 2020    Toll-Free: 011-411-70713


Course Fees Rs: 9999/-
Register now
Share on :

Request a call back

If you have any question
please call us at : 011-411-70713

About this live course

Financial Modeling Course - Joint Certificate by CAclubindia and Grant Thornton in India

Timing And Duration (Evening Batches)

Category Financial Modeling and Valuation Course
Time 6PM to 10PM (On July 4th,5th,11th,12th,18th and 19th)
Language English
Reference Study Material E-notes will be available
Duration of the Course 36 hours of learning

  • Financial Modeling and Valuation Live Class - 24 Hours live session
  • 8 Hours of Advance Excel Program by GT (Will be provided once the participant has registered for the Live Program)
  • 4 hours of other content and assessment in PDF Format

Query session with the faculty

Content Coverage

The program is designed for professionals & students to equip them with an understanding of Financial Modelling and Valuation to help them understand and build business & valuation models. This course will help the participants to make informed business and financial decisions.

Our training methodology covers a theoretical understanding of concepts through case studies to help our participants relate to the scenarios of their job roles. Our faculty ensures that conceptual knowledge is imparted with a perfect blend of industry practices. Our approach involves focusing on concepts through case studies to help our participants relate to the scenarios of their job roles.

This program will help you to create financial models that can be understood and easily implemented to gain insights into the opportunities and risks being faced by businesses.

Learning Outcomes

Participants will be able to:

  • Understand, refresh their excel skills along with Interpreting financial statements peculiar to creating and working around a financial model.
  • Build a financial modelling template
  • Understand the importance of managing data and the respective assumptions to build a financial model.
  • Build up flexible cash flow models & learn the application of the Discounted Cash Flows to build a financial model.


  • Include 24 training hours ( 6 live sessions with 4 hours/session)
  • Recorded Version of classes can be shared with participants
  • 8 Hours of Advance Excel Program (Recording, of Advanced Excel GT Course, will be provided)
  • 4 hours of other content and assessment in PDF Format

Who Should Attend

  • Investment bankers
  • Equity researchers
  • Professionals working in corporate finance
  • Chartered Accountants
  • MBA finance and commerce graduates
  • Professionals working in the finance domain

Program Coverage

Session 1

  • Understanding and Creating a Financial Model Template
  • Refreshing important Excel functions to be used in financial modelling and valuation

Session 2

Basic Business Model
  • Understanding Business Model

Financial Statements
  • Creating Historical Statements
  • Assumptions
  • Forecast

Session 3

  • Applying DCF

Financial Model - Data
  • Data Collection
  • Data Structuring
  • Public and Private data sources
  • Preliminary Scrutiny of the Data and Information

Session 4

  • Working on Historical Statements
  • Modelling Assumptions for Future Action
  • Revenue Build-up – projecting the future revenues
  • Cost Build-up – projecting the future cost
  • Asset Schedule

Session 5

Modelling (Continued)
  • Depreciation Schedule – Book and Income Tax Depreciation
  • Working Capital and Term Loan Modeling – Debt Infusion
  • Modeling Impact of Accumulated Losses, Current Tax and Deferred Tax on Tax Payable
  • Equity Modeling – Equity Infusion
  • Modeling Paid Up Capital and Share Premium Account
  • Cash Flow Statement Projection

Session 6

  • Cost of Equity - CAPM
  • Net cost of Debt
  • WACC
  • Absolute Valuation: Performing Valuation using Discounted Cash Flow (DCF) (FCFF and Enterprise Value)
  • Relative Valuation: Comparable Analysis
  • Performing Sensitivity/Scenario Analysis

Over view of Merger and Acquisition

Register for evening batch

Experienced Faculty

Harsh Kedia

Investment professional with 12 years of experience in investment banking (Private Equity, M&A and capital markets), corporate strategy and research. Currently working with a leading investment bank in India covering financial services, consumers and fintech sectors.


  • Corporate strategy, creating business plan; strong financial modeling and project management skills
  • Instrumental in developing business relationship with private equity funds, and other Investment Banks in India
  • Due Diligence – financial and legal, financial and business analysis, and valuation
  • Strong Excel and PowerPoint skills including macro programming

Terms and Conditions:

  • The recorded session will be provided
  • Validity will be 2.5 times viewing or 30 September 2020

Other recommended certification course

Live GST Certification Course Recording
Excel for Beginners to Advanced Learners
Transfer Pricing
Course Pack

CCI Learning App

CCI Learning App for
your Android mobile

CCI Learning App

Speak to the Counselor

1800-3000-0505 (Toll Free)

  Request a Callback

GST Live Class

FM by Grant Thornton    |    x