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 (3rd Batch)

Financial Modeling and Valuation Certification Course

Live class in association with Grant Thornton in India

Limited Seats      Toll-Free: 011-411-70713


GT

Course Fees Rs: 9999/-

inclusive of all taxes

36 hours of learning

Language: English

Study Material - E-notes will be available

Query session with the faculty


Register now
Share on :

Request a call back

GST Certification Course 10th batch - August 2020 (Weekend)
Register Now click here

Dates and timings of the live batch

5th,6th,12th,13th,19th and 20th September 2020

Timings - 6 PM to 10 PM

About this live course

The program is designed for professional & students to equip them understanding of Financial Modelling and Valuation, 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 theoretical understanding of concepts through case studies to help our participants relate the scenarios to their job roles. our faculty ensures that conceptual knowledge is imparted with perfect blend of industry practices. Our approach involves focusing on concepts through case studies to help our participants relate the scenarios to their job roles

This programme 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 Outcome:

Participants will be able to:

  • Understand, refresh their excel skills along with Interpreting financial statement 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.

Deliverables: - (Pictorial)

36 hours of learning

  • include 24 hours of training hours
  • 8 Hours of Advance Excel Program
  • 4 hours of other content and assessments
  • Two-way communication and query resolution from “Ask an expert”
  • Course material- GT Presentation
  • Quiz & Final assessment
  • Case Studies
  • Certificate of completion on successfully

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

Testimonials
  • “The Program is a complete package that provides professional insights to the world of Financial Modelling and Valuations. The trainers are experts in their field. They were able to impart practical knowledge through real life case studies and examples. The training was not only for how to do valuations but also on how to make it presentable. The hands on experience from working on real Financial Statements and support from trainers enhanced my skills to a new level. I recommend this program for anyone who wants to make meaningful financial models and valuations.”

    Kumar Arijit - Doon Business School, Dehradun
  • “Really appreciated the modelling best practises and the emphasis on creating a fully linked financial model for scenario analysis during the workshop.”

    Satish Babu - Comviva Technologies Limited
  • “The session was really good. The Instructor was able to explain concepts in detail. The pace of the session was also very good. The Instructor ensured that every one, irrespective of their proficiency levels, was able to grasp. The content was also very good.”

    Balakrishnan Vijayan – Seasoned Finance professional

Program Coverage

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

Basic Business Model
  • Understanding Business Model

Financial Statements
  • Creating Historical Statements
  • Assumptions
  • Forecast

Valuation
  • Applying DCF

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

Modelling
  • 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
  • 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

Valuation
  • 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


Experienced Faculty


Rupinder Monga

Rupinder Monga

  • Rupinder Monga is a core finance and analytics professional with a diverse experience of 14+ years in management consulting, equity research and analytics.
  • He is a Master in Financial Management from Rotterdam school of Management, Amsterdam and B.Tech from the Indian Institute of Technology, Delhi.
  • He also holds a charter form FRM.
  • He has designed & delivered multiple training programs for corporates across sectors specializing in finance and analytics.
  • He has developed course content for
  • Financial Modelling,
  • Business Analytics,
  • Data Science
  • He is an active speaker and delivered various training sessions to more than 2000 participants from various Industries and different functions/ domains.
  • He has also trained students on courses like CFA, FRM, and various other finance based programs both skill and exam based.


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

088803-20003,
1800-3000-0505 (Toll Free)


  Request a Callback


GST Live Class    |    x