Financial Modelling Courses in Delhi - Ibinstitute.in

1
IB
IB Institute
Investment
Banking
Institute
www.ibinstitute.in
2
IB
Financial Modeling Course
IB Institutes offers Financial Modeling course
training in Delhi, India. Investment Banking
Institute in Delhi is the best Institute
for Investment Banking Courses and  Financial
Modelling Courses. IB Institute is the well-known
brand for its practical approach to training in
corporate settings. Practical quality training
to Finance professionals bridges the gap between
academics and on job requirements.
Our training programs open up job opportunities
in finance profiles like Investment Banking,
Equity Research and project financing. We offer
the programs in the classroom, Live virtual
training and online self-study (Video Based).
3
IB
Institute
Banking
Investment
Index
gt Financial Modeling gt What is Financial
Modeling ? gt Financial Modelling Illustration gt
Why Financial Modeling ? gt Financial Modeling
Course gt Key features gt Study Options gt
Details of the course delivery
Call Now - 9896999313, 9312222566
4
IB
Investment
Banking
Institute
What is Financial Modeling?
Financial Modeling is a valuation weapon which
teaches you to work with historical information
of companies and analyze the company performance
on relevant financial parameters. This analysis
is then used to give us an estimate of the
valuation of companies/projects. Some of the use
cases of Financial Modeling are gt Valuation
of a security eg doing equity valuation of Tata
Motors gt Viability of a project eg Is building
bullet train between Mumbai and Pune is
financially viable project? gt Benefits of a
merger eg How much price Amazon should pay to
acquire Snapdeal gt Financial /Credit Analysis
of a company eg Shall a Bank give loan to DLF

projects gt Project report eg how to get
funding for startups
Call Now - 9896999313, 9312222566
5
IB
Institute
Investment
Banking
Financial Modeling
In Financial Modeling you learn to gather
historical information on companies and analyze
company / industry performance on various
financial parameters
Analysis is then used to build a companies
financial model, which in turn is key
to projecting a future financial performance
Based on this model companies / investors can
arrive at a suitable valuation for the companies.
Such research analysis is used in the areas of
investment banking / equity search/financial
KPOs that are assisting investment bankers /
equity research firms, financial
Preparing a Financial Model Research
Call Now - 9896999313, 9312222566
6
IB
Investment
Banking
Institute
Syllabus
Topic Detail
Basic Excel for Financial Modeling Formatting of Excel Sheets, Use of Excel Formula Function, Advanced Modeling Techniques, Data Filter and Sort, Charts and Graphs, Table formula and Scenario building, Lookups Vlookup Match offset, pivot tables
Financial Statement Analysis (Based on CFA Level I Syllabus) Introduction to Financial Statement Analysis Financial Reporting Mechanics, Understanding Income Statement, Balance Sheet, Cash Flow Statement, Financial Analysis Techniques, Inventories, Long Lived Assets, Non Current Liabilities, Financial Statement Application
Financial Ratios (Based on CFA Level I Syllabus) Ratio analysis of industries Du point Analysis Peer to peer analysis Preparation of Financial Analysis report on an industry
Call Now - 9896999313, 9312222566
7
IB
Investment
Banking
Institute
Syllabus
Topic Detail
Financial Management Corporate Finance Time value of money Long term financing Cost of capital Measure Of Leverage
Project Finance Project evaluation stage of project construction development phase funding during investment phase costs during investment phase life of project decision making, cash flow waterfall resolve circular reference problem in interest during construction.
Equity Research Modeling Prepare an Income Statement, Balance sheet, Cash Flow Statement, Geographic Revenue Sheet, Segment Revenue Sheet, Cost Statement, Debt Sheet, Analyze Revenue Drivers Forecast Geographic Segment Revenues, Cost Statement, Debt, Income Statement, Balance Sheet, and Cash Flow Statement. Cash Flow Statement Projection, Valuation- Discounted Cash Flow Method (DCF), Valuation Relative Valuation (Football Field Chart) Valuation Assumptions for Valuation Model, Prepare Valuation Model, Prepare Presentation Sheet, Prepare Company Overview , Sector Overview
Call Now - 9896999313, 9312222566
8
IB
Investment
Banking
Institute
Additional Training
Investment Banking M A SQL
VBA Macros

• Understanding Macros and VBA
• Recording Macros
• Understanding basics of coding
• Understanding objects and
• Control statements in VBA code
• Application of macros to Financial modeling
• Developing solution to circular reference
  problem
• Developing sensitivity table
• Developing scenario analysis
• Developing simulation
• Examples will be based on project
• Models

• Introduction to Databases
• Terminologies - Records, Fields, Tables
• Database normalisation
• Primary Key
• How data is accessed
• Introduction to SQL - Table creation
• SQL Syntax, SQL data Types, SQL Operators
• Table creation in SQL Create, Insert, Drop ,
  delete and updating
• Introduction to SQL - Table access
  Manipulation
• Select with Where Clause (In between, logical
  operators, wild cards, order, group by)
• SQL constraints, Concepts of Join - Inner, Outer
• Case study

• Introduction to Investment Banking
• Merger and Acquisitions
• Types of MA Merger ,Acquisition,
• Consolidation ,Spin-off
• Drivers for MA
• Accounting for Mergers Purchase
• Method Pooling Method
• Differentiate between financing and
• Operating synergies
• MA Regulatory Environment
• Developing MA Models Integration of
• Financial Statements between (Target and
  Acquirer),
• Valuation -DCF, Relative and Transaction
• Comps
• Developing Merger Model
• Developing Synergies

Call Now - 9896999313, 9312222566
9
IB
Investment
Banking
Institute
Course Resources

• FM Book

Study Material
Financial Modelling Training

• Theory
• Hands-on Training

Classroom Training

• Study Material

Online Resources

• Videos on creating models
• References
• Sample Models

Call Now - 9896999313, 9312222566
10
IB
Investment
Banking
Institute
Syllabus
Attend the program with 80 Attendance Certific
ation of Participation
Complete 4 assessments with 60 score get
Certification of Completion from NSDC
Fill the "NSE India- Exam request form"
Schedule the exam directly
certification
Call Now - 9896999313, 9312222566
11
IB
Investment
Banking
Institute
Key Features of training program
gt 3 Months weekend classroom program and Live
Virtual classroom program gt Comprehensive course
content making you Job ready gt Practical
hands-on training methodology gt Study resources
for reference and practice gt Exam preparation
via rigorous internal assessments gt Placement
Assistance Interview grooming
Call Now - 9896999313, 9312222566
12
IB
Investment
Banking
Institute
Corporate Clients
Trained Certified employees of following
Organizations gt State Owned Banks gt Foreign
Banks gt Security Houses gt Mutual Fund
Companies gt Insurance Companies gt IT/ITES
Call Now - 9896999313, 9312222566
13
IB
Investment
Banking
Institute
Call Now - 9896999313, 9312222566