3- Financial Modelling &

Cours Valuation Data Analytics

using R
e
Business Intelligence using Power BI and Tableau
Series

Online Self-Paced Course

FINANCIAL MODELLING &
VALUATION THEMED TRACK
Duration of 135 Hours
access anytime and anywhere

Price
1-Year of Access Rs30,000/- +Taxes
Get LMS access for one year

Completion Certificate
Jointly issued by NSE Academy &
Grant Thornton Enroll Now!
 Financial Course
Modelling & Valuation
Content
Module 1: Excel Refresher
Module 5: M&A Analysis
1.Freezing, sorting and conditional formatting
1.M&A evaluation case study
2.Creating Hyperlinks through Excel function
2.Searching and researching relevant reports
3.COUNT related functions
3.Collecting and projecting numbers
4.Lookup based functions (VLOOKUP, HLOOKUP)
4.Merger analysis – key drivers and inputs
5.Lookup based functions (INDEX and MATCH)
5.Projecting both companies' numbers
6.SUMPRODUCT function and related cases
6.Synergy benefits
7.Text related functions
7.Stock payment and stake dilution
8.Date related functions
8.Modeling a financing plan
9.Conditional summation (SUMIFS)
9.Pre-merger profitability and EPS
10.Combining text from a range of cells (TEXTJOIN)
10.Accretion/dilution analysis
11.Getting value from a database using DGET function
12.Data summarization using Pivot Table and Slicer
Module 6: Data Visualization
13.AGGREGATE function
1.Data visualization using charts
14.Financial functions and creating loan amortization
2.Presenting historical & projected data together
3.Creating profit & loss Bridge
Module 2: Corporate Finance and Investment
4.Depicting variance analysis
Banking
5.Dynamic chart for dashboards using form control
1.Corporate finance essentials (Capital budgeting, Time
option buttons and combo box
value of money, project evaluation methods)
6.Flexible chart using Scroll bar form control
2.NPV Crossover
and Excel's OFFSET function
3.Evaluation in case of unequal lives
4.Project evaluation cases
Module 7: Project Finance Model
5.Investment Banking Overview
1.Project finance case study
2.Setting up required inputs and assumptions related
Module 3: Financial Modelling Overview
to the project
1. What is financial modelling?
3.Incorporating contingency element as part of project cost
2. Developing an initial financial model using Telecom
4.Modelling Operating revenue
case study
5.Operating Cost drivers and computation
3. Capex schedule
6.Fixed asset schedule
4. Drafting P&L
7.Project Financing - creating a debt schedule
5. Valuation - Applying DCF
8.Modelling Equity related schedules - Paid up
capital and reserves & surplus
Module 4: Building Integrated Financial Model
9.Preparing financial statements - PL, BS and CF
1. Working on Historical Statements
10.Project evaluation (Project IRR)
2. Modeling Assumptions for Future Action
11.Sensitivity analysis - evaluating the impact of
3. Revenue Build-up – projecting the future revenues
changes in key project variables on project
4. Cost Build-up – projecting the future cost
profitability
5. Asset and Depreciation Schedules
6. Debt and Equity Schedules
7. Modeling the Financial Statements (P&L, BS and CFS)
8. Interest income and breaking
circularity 9.Valuation related
workings
10.Cost of equity (CAPM) and post-tax cost of debt
11.Computing WACC
12.Absolute valuation: Performing valuation using DCF
(FCFF and Enterprise Value)
13.Relative valuation: Comparable analysis
14.Performing sensitivity analysis
 Data Course
Analytics using R
Content
Module 1: Introduction and Programming
1.Introduction to Data Analytics
2.Introduction to R
a.R programming
b.R programming - Case Study
c.Customer Churn

Module 2: Statistics and Visualization

1.Data Visualization: Various graphs, charts
2.Data Visualization: Advance
3.Descriptive Statistics: Basic statistical techniques including data properties:
Hypothesis testing DPLYR package.
4.Linear Regression Model
5.Multinomial Linear Regression - Case Study
6.Logistic Regression
7.Multinomial Logistic Regression
a.Multinomial Logistic Regression - Case Study

Module 3: Advance Methods

1.Introduction to Artificial intelligence, ML and Deep learning
2.Neural Networks
3.Support Vector Machines (SVM)
4.Support Vector Machines (SVM) - Case Study
5.Decision Tree
6.Random Forest
7.K-nearest Neighbors
8.K-nearest Neighbors - Case Study
9.Clustering (K Means)
10. Principle Component Analysis
11. Principle Component Analysis - Case Study
Business Intelligence
Course (Power BI &
Tableau) Content
Module 1: Introduction

Module 2: Power BI

Module 3: Tableau

Module 4: Software Support

a.Support Material

b.Final Assessment

c.Power BI and Tableau Instructions

d.Software Download Instructions

 ADVANCED
E-LEARNING
COURSES
CO-CERTIFIED BY
GRANT THORNTON & NSE ACADEMY

Get ready with specialized skills sets in advance

analytics and technologies.

Courses designed by professionals at Grant Thornton

In-course exercises files to help apply

knowledge in real-world situations.

Joint certificate will be awarded by Grant Thornton & NSE

Academy upon completion.
About Grant Thornton Bharat LLP
Grant Thornton Bharat (GT) is truly a global organization with 62,000+ people in
more than 130 countries. No matter, how big the organization or the international
challenges you face, GT has the resources to match and provide solutions. The
organization has member firms in over 130 countries worldwide. It is ranked one
of the top six firms in 88 markets around the world and established in all major
business centres and emerging markets.
The organization serves India region with 13 offices in all major cities with
more than 15,000 people.
The organization serves India region
with 13 offices in all major cities
with more than 15,000 people.

About NSE Academy

NSE Academy Limited is a wholly owned subsidiary of the National Stock
Exchange of India Limited (NSE). NSE Academy Limited enables the next
generation of BFSI and FinTech professionals with industry aligned skills –
through capacity building programs and certification courses, powered by an
online examination and certification system. The courses are well- researched
and carefully crafted with input from the industry professionals.
NSE Academy Limited works
closely with reputed universities
and institutions across India in
building a competent workforce
for the future of BFSI and
FinTech.
NSE Academy Limited also
promotes financial literacy as an
essential life skill among
youngsters – a contribution
towards financial inclusion and
wellbeing.
 Contact Details
Counsellor:+919372500961 |Counsellor:+91
8097423875 [email protected]

Price: Rs. 30,000/-+Taxes

(Rs. 31,240/- inclusive of GST)
REGISTER & PAY NOW

Disclaimer

It is clarified that NSE Academy does not, in any manner whatsoever, assure, warrant, guarantee, or promise any
job/placement/advancement to any Participant. Under no circumstances, NSE Academy shall be held
responsible/liable for failure on the part of the Participants to pass / successfully clear the interview process or
the requirements to successfully secure a job. The information here can be used only by NSE Academy Ltd. It may
not be reproduced in whole, or in part, nor may any of the information contained therein be disclosed without the
prior consent of the authorized representatives of "NSE Academy Ltd." except within the organization.
Any form of reproduction, dissemination, copying, disclosure, modification, distribution, and or publication of this
material is strictly prohibited.
All the courses are administered by the NSE Academy Ltd and Grant Thornton Bharat LLP. The participants need
to complete certificate criteria
independently to be eligible for the respective certificates.
The Course Content/Outline mentioned herein is indicative and may be modified by NSE Academy in the best
interest of the participants.
The fee paid is non-transferable and non-refundable.