Tapping into the burgeoning BFSI market
-
FinTech Consulting Services
Leveraging our FinTech Consulting experience, we employ our proven approach in process reviews, tech risk management, and third-party audits for Indian financial services clients.
The Consumer & Retail sector is growing rapidly and is extremely dynamic. Due to constant disruption, managing business has become complicated and cumbersome.
Our healthcare and life sciences advisory team brings together a combined experience of over 50 years to help businesses navigate through changes, new...
At Grant Thornton in India, our automotive team works with a wide variety of clients to help them achieve their goals and increase shareholder wealth. Our...
M&E practice encompasses team of dynamic professionals with deep technical knowledge and extensive experience of working across segments say television, print,...
Tailored service offerings to Not for Profit organisations and CSR compliance services for dynamic businesses
At Grant Thornton, we assist dynamic Indian businesses in the Real Estate & Construction sector throughout their business life cycle by offering robust...
Program Agenda
Our Courses
- ACCA's Diploma in IFRS ACCA's Diploma in IFRS
- Finance for non Finance Finance for non Finance
- Ind AS 115/ IFRS 15 & Ind AS 116/ IFRS 16 workshop Ind AS 115/ IFRS 15 & Ind AS 116/ IFRS 16 workshop
- Online live Workshop on IFRS 15 & IFRS 16 Online live Workshop on IFRS 15 & IFRS 16
- ACCA Diploma in IFRS - Online Live training ACCA Diploma in IFRS - Online Live training
- Workshop on Ind As 115 – One day workshop Workshop on Ind As 115 – One day workshop
- Corporate training
- Workshop on Transfer Pricing Workshop on Transfer Pricing
- Advanced Excel Boot Camp Advanced Excel Boot Camp
- Certification in Financial Modelling & Valuation Certification in Financial Modelling & Valuation
- Workshop on Ind AS 116 – one day Workshop on Ind AS 116 – one day
- Certification in Blockchain Certification in Blockchain
- Masterclass on ESOPs other equity-linked long-term incentives Masterclass on ESOPs other equity-linked long-term incentives
- Workshop on GST Workshop on GST
- Certification in analytics using R and visualisation using Power BI Certification in analytics using R and visualisation using Power BI
Excel Refresher
- Reducing the use of mouse
- Cell freezing and referencing
- Sorting and filtering the data along with advance filters
- Adding, deleting, hiding, unhiding rows and columns
- Changing the width of row/ column
- Simple excel formulas such as sum, product, paste special, concatenate, etc
- Conditional formatting
- V lookup/H lookup
- Match function
- Index function
- Transpose function
- Computation of CAGR
- Pivot Tables
- Usage of IF, Sumif, countif, sumifs, counta, etc
- Sumproduct function
- Trace precedents and dependents
- Calculation of IR
- Combination of multiple functions such as Vlookup+Match, Index+Match, etc
- Offset function
- Data Table
- Goal seek
- Sensitivity analysis
- Scenario Manager
- Developer tab
- Indirect function for summarizing data from different sheets
- Creation of dashboards to present the data in a professional manner
- Different types of charts and where to use them
- Formatting the charts
- Name manager
- Then vs Now interactive chart
Financial Modelling
- What is a good financial model
- Tips to avoid modelling errors
- Model building
- Building assumptions and rationale behind them
- Building dynamic business models from data provided
- Building financial statements
- Fixed assets and depreciation
- Working capital
- Capital structure
- NPV and IRR and which one is better
- Presentation and summarization of model from investor perspective
- XIRR and MIRR functions
- Computation of WACC using CAPM approach
- Computation of FCFF and FCFE
- Using data table and scenario manager, etc to take decisions
- Manufacturing model
- Real estate model
- Infrastructure modelling
- Hospitality Modelling
Valuation
- Different techniques of valuation
- Discount rate
- Enterprise value
- Free cash flow to firm (FCFF)
- Free cash flow to equity (FCFE)
- Beta
- Relative valuation
- Why different companies in same sector trade at different multiples
- How relevance of multiples change as per industry
Comparable company multiple method
- How to select peers
- Computing the multiples
- How to use comparable multiples for computing WACC
- Computing the valuation using the above method
Comparable Transaction multiple method
- Analysing the recent deals in the market and how to use them for creating meaningful transaction comp analysis
- Difference between comparable companies multiple method and comparable transaction multiple method
- Computing the valuation using the above method
Discounted Cash Flow method
- Computing debt free cash flows from the projections
- Terminal value
- Computation of WACC and factoring the risk related to the company
- Different ways to compute terminal value and where to use which way
- Computation of valuation using discounted cash flow method
Case Study: Valuation for
- Financial Industry
- Other Industries