Certificate in Investment Banking & Equity Research

Certificate in Investment Banking & Equity Research

One Level up from Financial Modeling

Key Highlights

  • 110+ Hr of Industry Led Interactive Classes
  • 100% Placement : Interview Prep & Soft Skills
  • 2000+ Successful Placements : 200+ Company Tie-ups

Learn . . .

  • Financial Modelling & Valuation
  • Pitch Book & Company Profiling
  • Equity & Industry Research & IPO Case Studies
  • Real Time Industry Based Case Studies

Attend a Free DEMO CLASS to Decide

    About Investment Banking

    Special segment of banking operation that helps organisations raise capital and provide financial consultancy services to them.
    Investment Banks provide various types of financial services, such as:
      • Financial Modelling & Valuation
      • Mergers and Acquisitions Advisory: This involves helping organizations in M&A.
      • Leveraged finance: : It involves lending money to firms to purchase assets and settle acquisitions.
      • Restructuring: It involves improving structures of companies to make a business more efficient and help it make maximum profit.
      • New Issues or IPOs : Where these banks help new firms go public

    How Investment Banking Is Different From Financial Modeling

    Though financial modeling is an integral part of Investment banking, but having knowledge of pitch books is equally important.  Financial models, pitch books, industry research,reporting writing etc. are the tools that Investment bankers used to get the deals (M&A, fund raising, restructuring, etc.) done. This course will train you on all aspects of investment banking analysis be it quantitative (financial statement analysis, ratio analysis, DCF models, M&A models, etc.) or qualitative (industry research, pitch books, report writing,case studies, company profiles, etc.)

    Key Features

    Live Interactive Online Classes Fee : Rs.37,999

    fancy

    Exposure to Investment Banking

    Get insights into the functioning of the Investment Banking industry & meet industry professionals & get insights on the know-how of the job.

    fancy

    100% Real Life
    Examples

    Practical curriculum designed by industry professionals including case studies & live examples making for a comprehensive learning experience.

    fancy

    Mock Interview & Soft Skills Training

    Our training goes far beyond just technical expertise as we help our students with soft skills training & mock interviews to make them completely ready for their future jobs.

    fancy

    Industry Accepted Certificate

    A certificate of merit is issued to all students on course completion along with special recognition to the top-performing students of every batch.

    fancy

    100% Placement
    Support

    We have dedicated placement support individuals on our team who will help fix your interviews to get you 1 step closer to your dream job.

    fancy

    Personal
    Attention

    Each student gets personalized attention from our faculty to ensure maximum learning for everyone & maintain strong student engagement within every batch.

    Upcoming Batch Details

    Check out details of some of our upcoming batches

    Total Duration 3.5 Month
    Days Saturday & Sunday
    Upcoming Batch Date 8 & 15 Oct 2023
    Timing 10:30pm-2:30pm 

     

    Top Job options

    You can work as a Security Analyst, Financial Analyst, Financial Advisor or Debt Market Analyst in

    Investment Banks

    Equity Research Companies

    Consulting and Advisory Services

    Credit Rating Agencies

    Financial KPO’s

    Asset Management Companies

    Project Finance Companies

    Different Research Houses

    Role Of An Investment Banker

    Investment bankers are responsible for a wide range of duties including raising capital, providing advisory services for mergers and acquisitions (M&A) and other corporate transactions, completing valuation work, and marketing the value of the banks’ expertise to client companies.

    As the role of an IB Analyst involves performing most of the analytical analysis required for corporate transactions, their work generally entails quite a lot of presentations and models, which have been briefly explained below:

    • Presentations, known as Pitch Books in the IB world, are simply the marketing document used by bankers for their client meetings. Around 50-60 pages long (or even more!), the pitch books contain data on the investment bank’s credentials, industry landscape, company profiles & valuation, sector transactions, advisory recommendations, etc.
    • Financial Modelling involves (but is not limited to!) Discounted Cash Flow (DCF) analysis, Relative Valuation analysis (Comparable Companies analysis and Precedent Transactions analysis), M&A and Accretion/Dilution models, LBO models, Football field analysis, etc.
    • IB Analysts and Associates typically spend a lot of time in creating and analyzing the alternatives for their client: by creating models and then by presenting them properly through pitch books. Some examples can be evaluating exit options for the client- selling a company versus going for an IPO; or creating a financial model to show the accretion/dilution impact on the earnings in different scenarios for debt and equity in the transaction.

    Recent Placement

    The success stories from some of our most recent batches.

    Detailed Course Curriculum

    Day 1. Introduction to MS Excel

    • Introduction to Excel:
      • Keyboard Accelerators and Shortcuts
      • Create and Customize the Excel List
      • Data entry with Auto Fill Feature
      • Working with Advance Cut, Copy, Paste Command
      • Use of Find and Replace
      • Working with Summarizing and Filtering on Data
      • Manipulating worksheet data
      • Defining valid sets of values for ranges of cells
      • Sorting worksheet data
      • Sorting data by using custom lists
      • Organizing data into levels
      • Looking up information in a worksheet
      • Using Paste Special
      • Customize Excel Format
      • Basics and Rules for performing Calculation on data
    • Examples of common functions:
      • Mathematical Functions (SUM, PRODUCT, POWER, SQRT, ABS ETC.)
    • PRACTICE SHEETS:
      • Create and Customize the Excel List
      • Data entry with Auto Fill Feature
      • Working with Summarizing and Filtering on Data
      • Organizing data into levels
      • Using Paste Special
      • Customize Excel Format

    Day 2. Excel Tools for Data Analysis

    • Revision and Solutions of Day 1 Practice sheet
    • Basics and Rules for performing Calculation on data
    • Understanding cell Referencing
    • Naming Groups of Data
    • Using basic formulas to calculate values
      • Mathematical Functions (SUM, PRODUCT, POWER, SQRT, ABS ETC.)
      • Text Functions (LOWER, TEXT, SEARCH, LEN, REPLACE, TRIM, LEFT, RIGHT ETC.)
      • Statistical Functions (COUNT, MIN, MAX, AVERAGE, COUNTA, AVERAGEA ETC.)
      • Date & Time Functions (TODAY, NOW, EOMONTH, NETWORKDAYS, YEARFRAC ETC.)
      • Array Functions (SUMPRODUCT)
    • Finding and Correcting Errors in Calculations
    • Combine data from multiple sources
    • Sensitivity Analysis and Data Tables
    • Link to data in other worksheets and workbooks using Hyperlink
    • PRACTICE SHEETS:
      • Mathematical Functions
      • Text Functions
      • Statistical Functions
      • Date & Time Functions
      • Array Functions

    Day 3. Excel Tools for Financial Modeling

    • Revision and Solutions of Day 2 Practice sheet
    • Working with Data Validation
    • Create Drop down List
    • Restrict user to make a wrong entry
    • Advance Calculation on data with Formula and Functions:
      • Statistical Functions (SUMIF, COUNTIF, SUMIFS, COUNTIFS, AVERAGEIF ETC.)
      • Informative Functions (ISBLANK, ISNUMBER, ISTEXT, ISERR ETC.)
      • Database Functions (DSUM, DAVERAGE, DCOUNT, DMIN ETC.)
      • Logical functions (IF, Nested IF, IFNA, IFERROR, AND, OR, TRUE, FALSE ETC.)
      • Lookup & Reference Functions (LOOKUP, HLOOPKUP, VLOOKUP, INDIRECT, INDEX, MATCH ETC.)
      • Financial Function (PV, FV, NPV, PMT, CUMIPMT ETC.)
    • Working with Array Functions
    • Formula Editing Tips and Tricks
    • Conditional Formatting
    • PRACTICE SHEETS:
      • Conditional Formatting
      • Working with Data Validation
      • Create Drop down List
      • Statistical Functions
      • Database Functions
      • Logical functions
      • Lookup & Reference Functions
      • Restrict user to make a wrong entry

    Day 4. Analyzing and Presenting Data Dynamically

    • Revision and Solutions of Day 3 Practice sheet
    • Create dynamic worksheets by using PivotTable
    • Analyzing data dynamically by using PivotTables
    • Creating dynamic Dashboard with using PivotTable & Pivot Charts
    • Convert Table into Dynamic Table using Offset Function
    • Concept of Data Table
    • Protect your workbook and sheet
    • Implementing simple business modelling case in Excel
    • Introduction to Charts & Graphs
    • Charts basics and its elements:
      • Create and Customize charts with Examples (Column and Stacked Column Chart, Bar Chart, Stacked Chart , Line Chart, Pie, Pie of Pie Chart)
      • Combo Chart (Combination of multiple charts)
      • Dynamic Chart
      • Many More
    • Design a dynamic Dashboard using offset function, charts and graphs
    • PRACTICE SHEETS:
      • Create dynamic worksheets by using PivotTable
      • Analyzing data dynamically by using PivotTables
      • Creating dynamic Dashboard with using PivotTable & Pivot Charts
      • Protect your workbook and sheet
      • Introduction to Charts & Graphs

    Day 5. Automating Excel Tasks using Macros and VBA

    • Revision and Solutions of Day 4 Practice sheet
    • Introduction to Macros & Advanced Application Building in Excel
    • Key Concepts in Macros
    • Recording macros
    • Run macros
    • Set macros setting
    • Personal Macro workbook
    • Assigning Shortcuts to Macro Programs
    • Understand Excel VBA Objects
    • Assigning a Macro to a Button.

    Day 6 & 7. Introduction to Financial Statements and Ratio Analysis

    • Understanding Income Statement, Balance Sheet, Cash Flow Statement
    • How Financial Statements are inter-related
    • Different Measures of Profitability
    • Reading the Annual Reports
    • Ratio Analysis including liquidity, asset management, debt management and profitability
    • DuPont Analysis
    • Investment Decision Analysis
    • Case Studies based on Live Companies

    Day 8. Valuation and Its Techniques

    • Market Capitalization
    • Enterprise Value
    • Key Trading Multiples
    • Determine Valuation
    • Discussion on Valuation Multiples
    • Methods of Consolidation
    • Non controlling interest
    • Investment in Joint Ventures and Equity Method Accounting
    • Relative Approach V/s Fundament Approach of Valuation
    • Understanding the concept of Implied Valuation
    • Estimating Target Price

    Day 9 & 10. Preparing Models as per Relative Approach of Valuation

    • Introduction to Comparable Companies Analysis
    • Select the Universe of Comparable Companies
    • Locate the Necessary Financial Information
    • Spread Key Statistics, Ratios, and Trading Multiples
    • Determine Valuation using Comparable Companies
    • Introduction to Precedent Transactions Analysis
    • Select the Universe of Comparable Acquisitions
    • Locate the Necessary Deal-Related and Financial Information
    • Spread Key Statistics, Ratios, and Transaction Multiples
    • Benchmark the Comparable Acquisitions
    • Determine Valuation using Comparable Acquisitions
    • Normalization of EBIT, EBITDA and Net Income
    • Adjustments of Options, Warrants and Restricted Stock Units
    • Case Studies based on Live Companies

    Day 11 & 12. Understanding Forecasting and Its Techniques

    • Understand the Business Model and Operating Model
    • Modelling the Historical Statement
    • Modelling Assumptions for Future Action
    • Revenue Schedule
    • Operating Cost Schedule
    • Capex / Depreciation Schedule
    • Income Tax Schedule
    • Working Capital Schedule
    • Debt Schedule
    • Equity Schedule
    • Assets Schedule
    • Modeling the Future Financial Statement
    • Case Studies based on Live Companies

    Day 13 & 14. Preparing Models as per Fundamental Analysis (DCF)

    • Introduction to Discounted Cash Flows (DCF)
    • Free Cash Flow to Firm (FCFF)
    • Free Cash Flow to Equity (FCFE)
    • Present Value on FCFF and FCFE
    • Understanding Cost of Capital (WACC)
    • Cost of Debt (Kd)
    • Cost of Equity (Ke)
    • Capital Asset Pricing Model
    • Beta Model
    • Levered, Unlevered and Re-levered Beta
    • Terminal Value
    • Exit Multiple Method
    • Perpetuity Growth Method
    • Computing Valuation using DCF
    • Football Field Model
    • Estimating Target Price
    • Case Studies based on Live Companies

    Day 15. Mergers and Acquisitions

    • Merger v/s Acquisitions
    • Types of mergers
    • Case Studies on different types of Mergers
    • Motives behind M&A
    • Synergies
    • Bootstrapping
    • Accretion / Dilution Modeling

    Day 17 & 18. Introduction to Equity Research Report Writing

    • Equity research reports writing
    • Creating earning notes
    • Analyzing performance with past period
    • Analysis of change in performance metrics
    • How to form expectation on a stock

    Day 19 & 20. Introduction to Case Study Analysis

    • Situation-based analysis
    • IPO Case study
    • M&A case study
    • Practice exercise

    Day 21 & 22. Industry Research & Analysis

    • Industry thematic – Introduction and usage
    • Deciding layout/ framework
    • Identifying industry drivers
    • Data collection / Data presentation
    • Sourcing of data
    • Practice session

    Day 23 & 24. Introduction to Pitch Books

    • What is a Pitch-book / Deal-book
    • Pitch book – Investment Banks Perspective
    • Capabilities and Qualifications of the Investment Bank
    • Market Updates
    • Transaction Section
    • Financial Model
    • Types of Pitch book
    • Main Pitch Book
    • Deal Book
    • Management Presentations

    Our Certifications

    On successful course completion, the candidates would receive 1-2 certificates depending upon their performance.

    And an Additional Certification from Financial Modeling Institue, Canada which is based on an Online Test.

    Certification Of Completion

    This certificate is awarded to all the candidates on successful completion of the course.

    Certificate Of Excellence

    Awarded to only top 20% of the students based on various parameters such as 100% attendance, scores, active participation and overall performance.

    Student speak

    Hear it directly from the students about their training experience at Career Bulls

    I am raw html block.
    Click edit button to change this html