Grant Thornton - Certificate in Financial Modelling and Valuation E-Learning
4.1 /5- Offered byGrant Thornton
Grant Thornton - Certificate in Financial Modelling and Valuation E-Learning at Grant Thornton Overview
Duration | 50 hours |
Total fee | ₹18,000 |
Mode of learning | Online |
Difficulty level | Intermediate |
Credential | Certificate |
Grant Thornton - Certificate in Financial Modelling and Valuation E-Learning at Grant Thornton Highlights
- Earn a Certificate of Completion from Grant Thornton
- 50 hours of study that include 40 hours of course recorded videos, 8 Hours of Advance Excel Program and 2 hours of other content and assessments
- Grant Thornton's Rich experience in Valuation, M&A
- Flexible -learn anytime from anywhere. Accessible on Mobile and Tablets
- Two-way communication and query resolution from 'Ask an expert'. Query resolution within 24 hours
- Grant Thornton presentations as course materials
- Course Delivered by Professionals having industry experience
Grant Thornton - Certificate in Financial Modelling and Valuation E-Learning at Grant Thornton Course details
- Clearing MS Excel doubts and refreshing Excel formulas
- Designing financial models
- Designing revenue and expense models for various industries like consumer goods, modern retail, real estate and auto components and creating basic macros
- Creating dashboards to present models in a summarised manner
- Presenting reports using models
- Valuation techniques
- 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
- 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.
Grant Thornton - Certificate in Financial Modelling and Valuation E-Learning at Grant Thornton Curriculum
Excel refresher
Freezing, sorting and conditional formatting
Creating Hyperlinks thought excel function
COUNT related functions
Lookup based functions (VLOOKUP, HLOOKUP)
Lookup based functions (INDEX and MATCH)
SUMPRODUCT function and related cases
Text related functions
Date related functions
Conditional summation (SUMIFS)
Combining text from a range of cells (TEXTJOIN)
Getting value from a database using DGET function
Data summarization using Pivot Table and Slicer
AGGREGATE function
Financial functions and creating loan amortization
Corporate finance and Investment Banking
Corporate finance essentials (Capital budgeting, Time value of money, project evaluation methods)
NPV Crossover
Evaluation in case of unequal lives
Project evaluation cases
Investment Banking Overview
Financial Modelling overview
What is financial modelling?
Developing an initial financial model using Telecom case study
Capex schedule
Drafting P&L
Valuation - Applying DCF
Building integrated financial model
Working on Historical Statements
Modeling Assumptions for Future Action
Revenue Build-up -projecting the future revenues
Cost Build-up -projecting the future cost
Asset and Depreciation Schedules
Debt and Equity Schedules
Modeling the Financial Statements (P&L, BS and CFS)
Interest income and breaking circularity
Valuation related workings
Cost of equity (CAPM) and post tax cost of debt
Computing WACC
Absolute valuation: Performing valuation using DCF (FCFF and Enterprise Value)
Relative valuation: Comparable analysis
Performing sensitivity analysis
M&A Analysis
M&A evaluation case study
Searching and researching relevant reports
Collecting and projecting numbers
Merger analysis -key drivers and inputs
Projecting both companies' numbers
Synergy benefits
Stock payment and stake dilution
Modeling a financing plan
Pre merger profitability and EPS
Accretion/dilution analysis
Data Visualisation
Data visualisation using charts
Presenting historical & projected data together
Creating profit & loss Bridge
Depicting variance analysis
Dynamic chart for dashboards using form control option buttons and combo box
Flexible chart using Scroll bar form control and Excel's OFFSET function
Project finance model
Project finance case study
Setting up required inputs and assumptions related to project
Incorporating contingency element as part of project cost
Modelling Operating revenue
Operating Cost drivers and computation
Fixed asset schedule
Project Financing - creating debt schedule
Modelling Equity related schedules - Paid up capital and reserves & surplus
Preparing financial statements - PL, BS and CF
Project evaluation (Project IRR)
Sensitivity analysis - evaluating impact of changes in key project variables on project profitability
Grant Thornton - Certificate in Financial Modelling and Valuation E-Learning at Grant Thornton Entry Requirements
- minimum 5 years work experience
- Not mentioned
Other courses offered by Grant Thornton
Student Forum
Anything you would want to ask experts?
Grant Thornton - Certificate in Financial Modelling and Valuation E-Learning