COURSE HIGHLIGHTS:

 The #1 Course to Land a Job in Investment banking.

 Certified Investment Banking Course with 100% Placement assistance.

 3/6 months internship with an Investment banking firm.

 Gain hands-on, practical experience during training, similar to a real job within the Investment Bank.

 80% of the Real-time industry used Case study-based learning.

 Our trainer: Investment Banking working professional.

 A guide to over 100+ frequently asked Investment Banking questions and their answers.

 Build 5 financial models from scratch of your chosen Listed/Private companies.

 Be part of our Global Investment Banking alumni network.

 IPOs, Bonds, M&A, Trading, LBOS, Pitch deck, Valuation: Everything is included!

Prepare a company’s Budget from Scratch.

 Dedicated Placement Manager with 1-on-1 mentorship.

MODULE 1: MS EXCEL EXPERT

 Excel Essentials & key board accelerators

 Basic & advance excel functions

 Conditional Formatting, Paste Special

 Using VLOOKUP/HLOOKUP/ Match Index

 Using SUMIF, COUNTIF, AND AVERAGEIF

 DATEDIF, YEAR, YEARFRACE & MONTH

 Index, Search, Choose, offset

 Sensitivity analysis with Data tables

 Pivot table, Charting commonly used

 Dashboards, templates, Macros

MODULE 2: DATA COLLECTION AND MODELING

 Sources for authentic financial data for US, India, China, Germany, and Singapore companies

 Tricks to collect data in the shortest time

 Data collection & Data structuring for model

 Understanding of Financial Reports & its types

 Types of filing 10-K, 10-Q, 8-K, 20-F etc.

 Create Model template for 5 years historical data for`

             Revenue Drivers

             Cost Drivers

             Income statement

             Balance sheet

             Cash flow statement

             Dividend schedule

             Asset Schedule

             Debt Schedule

             Equity Schedule

 What Investment Banker does?

 Skill set requires for an Investment Banker?

 Job roles of BUY SIDE and SELL SIDE Analysts

 Understanding, Reading & Analyzing of

             Income statements & Balance sheet

             Cash flow statements

             Notes to accounts

             GAAP & Non-GAAP/Reported & Adjusted numbers

             Reported/Adjusted /GAAP/Non-GAAP EPS

             Restructuring & Adjusted numbers

             Pro-forma Income statement

             Restating financials for valuation and analysis

 Concepts & treatment of the following points

             Minority/Non-controlling

             Associates

             Subsidiary

             Convertible debt/securities

 5 case studies on live small business

 Make a business plan for startups

 Corporate actions & their treatments

             Rights issue

             Bonus issue

             Takeover

             Merger

             Acquisitions

             Interim/Annual dividend

             Stock splits

             Spin-offs

             Reverse split

MODULE 4: FINANCIAL MODELING & VALUATIONS

 Interlinking of financial statements (IS, BS, CFS)

 Tallying the balance sheet in 30 minutes

 Use best practices in Financial Model building

 Understand & develop forecasting basis for each line of IS, BS & CFS

 Build & Forecast Advanced Schedules including the following points

             Debt Repayment Schedule (DRS)

             Fixed Assets Module (FAM)

             Dividend & Equity Schedule (ES)

RATIOS:

 In depth conceptual understanding of financial ratios we include the following points

             Liquidity ratios

             Leverage ratios

             Efficiency ratios

             Profitability ratios

             Market value ratio