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

Grant Thornton | Certification in Financial Modelling and Valuation (Live Online)

70 Hours of learning

Course Snapshot
  • FeeINR 30000 + taxes (Special price for iimjobs)
  • Work Experience3 - 30 Years
  • Duration70 Hours
  • Delivery MethodOnline
Course Detail

Program Overview
The Certificate in Financial Modelling and Valuation 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

70 hours of study
● 70 hours of instructor led session through CISCO WEBEX
● 30 hours of recorded VBA & additional Case studies
● Case studies covering industries like Telecom, IT, Manufacturing, Energy Sector, Hotel & Banking
● Complimentary access to recorded videos through GT LMS
● Assessment tests
● Post training support - Query management through LMS
● Certificate of completion

Course Schedule

15th, 16th, 22nd, 23rd, 29th, 30th April & 06th, 07th May 2023

Study Center(s)

Online Live

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
-String Function
-Offset function
-Data table
-Goal seek
-Linking multiple sheets and files etc.
-Learning Custom formatting peculiar to creating financial models
-Learning referencing (usage of $) and its significance in the financial model
Session 2 : Basic Business Model
● Understanding Business Models
Session 3: Financial Statements
● Working on historical statements
● Assumptions
● Forecast
Session 4 : Valuation
● Applying DCF
Session 5 : Financial Model - Data:
● Data Collection
● Data Structuring
● Preliminary Scrutiny of the Data and Information
Session 6 : 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 Modelling - Debt Infusion
● Modelling 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 7 : Valuation
● Cost of Equity - CAPM
● Net cost of Debt
● Absolute Valuation: Performing Valuation using DCF (FCFF and Enterprise Value)
● Relative Valuation: Comparable Analysis
● Performing Sensitivity/Scenario Analysis
Session 8 : Project Valuation - Introduction
● Introduction and context
● Understanding an integrated financial Model
Session 9 : Project Valuation - Creating a Model for NPV & IRR
● Understanding basics
● Building flexibility for cash flow at unpredictable time
● Building flexibility in Model
Session 10 : Modelling Delays
● Date arithmetic and creating flexible template
● Lookup revenues and costs
● Quarterly to Yearly Revenue consolidation using SumIf
Session 11 :Project Valuation - Circular Logic and looping
● Interest During Construction
● Interest and Cash
Session 12 : Project Valuation - Creating EPC Schedule
● Finding out different cost involved in the project
● Calculating complete project cost
Session 13 : Project Valuation - CAPEX Schedule
● Finding out the total capex required for the project
● Converting monthly items to annual
Session 14 :Project Valuation - P&L
● Working on different sources of revenue
● Calculating expenses
● Using DCF
● Calculating IRR
Session 15 : Project Valuation - Asset Schedule
● When, what is required?
Session 16 : Project Valuation - Valuation
● Using DCF
● Calculating IRR
Session 17 : Project Valuation - GANTT Chart
● Tracking progress of the project
Session 18 : Visualization - Interactive Excel Dashboard
● Introduction
● Dashboard design tips
● Data Sources
● Possible data sources
● Format data in table
● Building dashboard
● Pivot for the line chart
● Bar Chart
● Pie Pivot
● Sparklines Pivots
● Map Pivots
● Interactivity with slicers
● Dynamic titles
● Design and Layout
Session 19 : M&A - Introduction
● Meaning and Categories of M&A
● Merger Motivations
● Forms of Payment in a Merger Deal
Session 20 : M&A - Evaluation
● Evaluating a Merger Bid
● Case: Estimating fair acquisition price of the target company in M&A
● Identifying assumptions for estimating future cash flows
● Calculating FCFF, discount and terminal rate and NPV
● Comparable Companies
● Defining comparative value metric
● Estimating takeover premium and calculating takeover price
● Comparable transactions and defining comparative value metric
● Calculating the valuation of the company
Session 21 : M&A - Valuation
● Case: Live Case
● Why this case
● Finding out rationale for the transaction
● Searching and researching relevant reports
● Understanding the usage of 10K and 10Q
● Collecting and projecting numbers
● Merger Analysis - Key Drivers and Inputs
● Projecting both companies' numbers
● Find out the impact of deal announcement on share price
● Creating high level merger accounting for goodwill - Pooling method
● Accretion/Dilution Analysis and Modelling a Financing Plan
● Performing Sensitivity Analysis on Acquirer's EPS, Contribution Analysis