jobseeker Logo
Now Apply on the Go!
Download iimjobs Jobseeker App and get a seamless experience for your job-hunting

Certification in Financial Modelling and Valuation (E-learning)

Special 50 hour programme to upskill participants on financial modelling and valuation techniques

Course Snapshot
  • FeeINR 15,000 + GST (Special price for iimjobs)
  • Work Experience5 - 30 Years
  • Duration50 Hours
  • Delivery MethodOnline
Course Detail

Program Overview
The Certificate in Financial Modelling and Valuation E-Learning aims to provide working professionals and students practical exposure to financial modelling and valuation, help them understand and build business as well as valuation models. The programme will ensure
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 the scenarios to their job roles.
This programme will help you create financial models that can be understood and easily implemented to gain insights into the opportunities and risks being faced by businesses. It will also help you gauge the performance of a financial asset or portfolio of a business project or any other investment

Program Objectives
The programme will focus on:
- Clearing MS Excel doubts and refreshing Excel formulas
- Designing financial models
- Designing revenue and expense model for various industries like consumer goods, modern retail, real estate and auto components creating basic Macros
- Creating dashboards to present models in a summarised manner
- Presenting reports using models
- Use financial models in business valuation
- Valuation techniques
- Plan and take decisions by analysing models

Deliverables
- 40 hours of live sessions (5 days)
- Complimentary access to recorded videos through GT LMS
- GT Course Material - Handouts
- Assessment tests
- Post training support - Query management
- Certificate of completion

Desired Candidate Profile

- Investment bankers
- Equity researchers
- Professionals working in corporate finance or M&A domain
- Chartered Accountants
- MBA finance and commerce graduates
- Professionals working in the finance domain

Course Modules

Session 1: Excel
● Understanding and creating a financial model template
● Refreshing important Excel functions to be used in financial modelling and valuation
Session 2
● Basic Business Models
● Financial Statements
● Valuation
● Financial model - data
● Business Model
Session 3: 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 modelling – equity infusion
● Modelling paid up capital and share premium account
● Cash flow statement projection
Session 4
● Valuation
● Project Valuation : Introduction
Session 5
● Project Valuation - creating a model for NPV and IRR
● Modelling Delays
● Project Valuation - circular logic and looping
● Project Valuation - creating epc schedule
Session 6
● Project Valuation - CAPEX Schedule
● Project Valuation - P&L
● Project Valuation - Asset Schedule
● Project Valuation – GANTT Chart
Session 7
● Visualisation - Interactive Excel dashboard
● M&A Introduction
● M&A evaluation
Session 8
● M&A Valuation