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

Upskill yourself in financial modelling and valuation techniques in just 40 hours!

Course Snapshot
  • FeeINR 27,500 + GST
  • Work Experience5 - 30 Years
  • Duration8 Days
  • Delivery MethodOnline
Course Detail

About Grant Thornton in India
- One of the largest fully integrated Assurance, Tax & Advisory firms in India
- More than 53000 employees globally
- Base in over 135+ countries with over 700 offices
- Ranked among top 5 in all major markets including India
- Ranked No.1 in Training & Development in India amongst Accounting Firms: Universum 2017 & 2018

Program Overview
Grant Thornton in India has designed a 40-hour programme to upskill participants on financial modelling and valuation techniques. 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. This programme will also help you to gauge the performance of a financial asset or portfolio of a business project or any other investment.
Financial modelling can also be used by investors or financial analysts to achieve a multitude of goals, from cash flow forecasting and management and board reporting to strategic planning and options analysis.

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

Module 1: Excel refresher
- Understanding and Creating a Financial Model Template
- Refreshing important Excel functions to be used in financial modelling and valuation

Module 2: Financial Modelling
- Working on Historical Statements
- Modelling Assumptions for Future Action
- Projection of future revenue and costs
- Asset Schedule & Depreciation Schedule
- Working Capital and Term Loan Modelling
- Equity Modelling

Module 3: Basic Business Model
- Understanding business and operating model

Module 4: Valuation
- Applying DCF

Module 5: Financial Model
- Data Collection & Structuring
- Public & Private Data Sources
- Preliminary Scrutiny of Data and Information

Module 6: Valuation
- Cost of Equity - CAPM
- Net Cost of Debt
- WACC
- Absolute & Relative Variation
- Sensitivity & Scenario Analysis

Module 7: Project Valuation
- Creating a model for NPV & IRR
- Circular logic and looping
- Creating EPC Schedule
- CAPEX Schedule
- P&L and Asset Schedule
- GANTT Chart

Module 8: Modelling Delays
- Date Artithmetic and creating flexible template

Module 9: Visualisation- Interactive Excel Dashboards

Module 10: Mergers & Acquisition
- Introduction
- Evaluation
- Valuation