COURSE HIGHLIGHTS

 The #1 Course to Land a Job in Equity Research and Valuation

 Certified Financial modeling and equity research Course with 100% Placement assistance

 3/6 months internship with an Equity Research Valuation firm

 Gain hands-on, practical experience during training, similar to a real job within the Equity Research Firms

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

 Our trainers: Equity Research working professionals

 A guide to over 100+ frequently asked Equity Research questions and their answers

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

 Be part of our Global Equity Research alumni network

 Dedicated Placement Manager with 1-on-1 mentorship

MODULE 1: MS EXCEL EXPERT

 Excel Essentials & keyboard shortcuts

 Basic & advance excel functions

 DATEDIF, YEAR, YEARFRACE & MONTH

 Index, Search, Choose, offset

 Using SUMIF, COUNTIF, AND AVERAGEIF

 Sensitivity analysis with Data tables

 Using VLOOKUP/HLOOKUP/ Match Index

 Pivot table, Charting commonly used

 Conditional Formatting, Paste Special

 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 & their types

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

 Create a Model template for 5 years of historical data for

             Revenue Drivers

             Cost Drivers

             Income statement

             Balance sheet

             Cash flow statement

             Dividend schedule

             Asset Schedule

             Debt Schedule

             Equity Schedule

MODULE 3: FINANCE FUNDAMENTALS

 What Research Analyst does?

 Skill set requires for Equity Research Analyst?

 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-off

             Reverse split

MODULE 4: SECTOR/INDUSTRY RESEARCH

(Analyzing Sectors/Industries/Companies)

 Company's Business model understanding

 Economies/Sectors/Industries understanding

 Operational drivers & cost drivers & Projection

 Factors that impact the company's projections & valuations

 Case studies on 'Top Down' and 'Bottom Up' approaches

 Forecasting of IS, BS, CFS, and Schedules

MODULE 5: FINANCIAL MODELING & VALUATION

 Interlinking of financial statements (IS, BS, CFS)

 Tallying the balance sheet in 30 minutes

 Use best practices in Financial Model Building

 Understand & develop a 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 dept conceptual understanding of financial ratios we include the following points

             Liquidity ratios

             Leverage ratios

             Efficiency ratios

             Profitability ratios

             Market value ratio

 Calculation and analysis of ratios on your chosen company

 Compare your company's ratios with competitors

             DuPont analysis

VALUATION:

(Understanding of various Valuation methods)

1. DISCOUNTED CASH FLOW (DCF)

 In-depth step-by-step understanding of DCF

 Product/business/economic life cycle concepts

 Time value of money concepts

 Understanding & calculation of FCFF & FCFE

             Cost of Equity using Capital Asset Pricing Model (CAPM)

             Cost of Debt (Kd)

             Cost of preference shares

 Risk-Free rate of return (Rf) for listed & non-listed SMEs

 In-depth analysis of systematic & un systematic Risk

 Beta: Levered beta & Un-levered beta

 Calculate beta using the last 5 years price

 Cost of capital (WACC)            

 Market Premium (Rm)

 Net present value /company value

 Sensitivity analysis

 Application of DCF on your chosen company

 ’Buy' or a 'Sell' rating based on analysis

2. RELATIVE VALUATION

 Step-by-step understanding of RV & Trading comps

 Criteria to choose competitors

 Criteria to choose Ratios for comparison

 Usage of price multiples P/E, P/S, EV/EBITDA, P/B

 Drive prices using the above ratios     

 Price band and valuation conclusion

3. SUM OF THE PARTS ANALYSIS (SOTP)

 Determine the Business Segments

 Value Each Segment

 Pick any of the below valuation methods to value the segment

             DCF /Comparable companies / Precedent Transactions

 Add up all segment’s valuations 

4.DDM (DIVIDEND DISCOUNT MODEL) / (GORDON GROWTH MODEL)

 In-depth step-by-step understanding of DDM / GGM

 Drive model and valuation conclusion

MODULE 6: EQUITY RESEARCH REPORT

 Introduction of various reports

 Initiating Coverage

             Company Update

             Scenario Road map

             Sector/Industry Reports

 Create two detailed equity research reports for companies located in the USA, India, China, Germany, and Singapore

 5 short reports on your chosen Indian companies

 Economy, Industry, and sector research and analysis

 Conclusion with analyst call 'BUY', 'SELL', 'NEUTRAL'

MODULE 7: PRESENTATION, REAL CASE STUDIES, MOCK INTERVIEWS, SOFT SKILL

 10+ real-time case studies

 Prepare you on 100+ frequently asked Equity Research Interview questions with answers

 Positive attitude and emotional intelligence training

 Placement managers for 1 on 1 mentorship

 Communication and interpersonal skills training

 Conduct regular mock interviews

 Work on individual strengths, and weaknesses and prepare an interview script

 Profile building and marketing

 Interview scheduling & helping candidates in placements