CCI Online Learning
What do you want to learn today?

GST Combo Certified Advanced GST Course + Live Course on GST Exports + GST Books - 3 Volumes By CA Bimal Jain. Call : 011-411-70713

Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

 CCI Online Learning

Live Classes (4th Batch)

Financial Modeling and Valuation Certification Course

Live class in association with Grant Thornton in India

Limited Seats   Starting from November 29th, 2020    Toll-Free: 011-411-70713

Financial Modeling Online Course

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

Buy now
Share on :

Request a call back

Dates and timings of the live batch

29th November , 5th December , 6th December , 12th December , 13th December and 19th December, 2020

Timings - 6 PM to 10 PM

About Financial Modeling Certification Course

CAclubindia in association with Grant Thornton in India offers the best financial modeling course for finance enthusiasts. The program is designed for finance professionals & students to equip them with an understanding of Financial Modeling and Valuation, and thus help them understand, and build business & valuation models. This certification course will help the participants to escalate their career to the next level. At the end of this program, you will become capable of making informed business and financial decisions. 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.

Our training methodology covers a 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.

What skills you will learn in Financial Modeling Certification Course?

  • 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.
  • Manage 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

Click here to know why should Chartered Accountants learn Financial Modeling

Financial Modeling Course Syllabus

The Financial Modeling Course syllabus includes comprehensive coverage of the following topics :

  • 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

  • Applying DCF

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

  • 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

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

Terms and Conditions:

  • The recorded session will be provided
  • The validity of the Recorded Session: January 31, 2021, or 2 times of viewing whichever is earlier.


FAQs on Financial Modeling Course

Is there a need for any certification course from a career point of view? If yes, what would they be?

The skillset is more important than a certification as most of the recruiters will check for either experience/exposure to financial modeling or will opt for a time-based test to check for the skillset. However, keeping a certification will only emphasize the credibility.

What are the pre-requisite skills for learning financial modeling course?

Financial models are usually built on MS-Excel, therefore, good command of MS- Excel is a must. Along with these learners should also hold knowledge on creating balance sheets, P/L accounts, etc.

What formal degrees/diplomas are best suited for financial modeling course?

As a skill financial modeling can be learned by students of various disciplines, from B.Com., CA, CFA, MBA to B.Tech. Having finance or commerce sure helps but it doesn't mean it's a requirement.

Can financial modeling be opted as a freelancing career?

Yes, definitely. Most of the start-ups and even businesses in their early stages opt to outsource finance analysis and forecast. After COVID-19 a lot many of other firms will also opt for freelancers in order to cut the cost of operations.

CAClubIndia Service Rating

Average service rating: 4.6, based on 10689 reviews 5 1 ServiceReview

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


  Request a Callback

GST Live Class    |    x