Financial Modeling & Equity Research



Introduction

Financial Modeling is used in various business activities by Investment Banks, Equity Research firms, Credit Rating Agencies, Private Equity / Venture Capitalist, Banks, Consultancy Firms, Corporate Finance Teams. Essence of Financial Modeling is in translating Business Strategy & Operations in realistic numbers considering the impact of Economic, Sectoral & Competitive scenarios

Financial Modeling requires expertise in Accounting, Economics, Sector Knowledge, Analytics, Excel, Business Strategy. Equity Research firms provide detailed research & insights into an economy, sector, company which forms basis of investment decisions .

We FINXL Provide best Financial Modeling Equity Research Training Classes in Pune Maharashtra India. Investment banks and research firms don't entertain fresher's due to lack of minimum practical exposure required on job. Hence we are here to help you!!


What you'll Learn

FINXL Financial Modeling & Equity Research program aims to empower participants with Model building and Valuation skills through extensive coverage of Modeling, Revenue Build-up techniques, Forecasting and Valuation, all applied on Listed Indian & US companies !


    Course highlights
  • Certified Financial Modeling course with 100% Job Assistance
  • 3 months Internship with Equity Research firm
  • Real time technical interview preparation by Investment bankers
  • Learn best Financial Modeling practices used in industry
  • Build 5 Financial Models from scratch of your chosen listed company
  • Learn 'reading of any listed Indian company financials in 10 minutes
  • Be part of our vast Equity Research & Investment Banking alumni network
Curriculum
    Course is divided into FIVE Modules Covering
  • Module 1: MS Excel expert
  • Module 2: Data Collection and Modeling
  • Module 3: Conceptual understanding of Financial statements
  • Module 4: Equity Research - Analyzing Company & Industry
  • Module 5: Financial Modeling & Valuations
Pre-Requisites
  • Does basic knowledge of Finance / Accounting needed? Not required as we start from basics
  • Does basic knowledge of Excel needed? Not required as we start from basics
  • Does any Finance degree or Finance background required? Previous finance knowledge will help but not compulsory
Target Audience

Financial Modeling is most important and un-avoidable skill set in finance domain. Anyone who is willing to read, understanding and analyse of financial data, convert numbers in explanation, convert given information into numbers, projection of financial information, valuing the businesses, companies, investment in Shares.

CA, CFA, FRM, MBA, B.E., B.Com, M.Com, any graduate who wants to make career in
Investment Banking
Equity Research
Financial Modeling
Credit Research
Project Finance
Corporate Finance
Credit Ratings

Course structure

Course duration: 4 Months (16 weeks), Intensive 130 hours

Weekday Batch Timing:
Option I: 08:00 AM - 10:30 AM Tuesday - Friday (4 classes per week of 2.5 hours each)
Option II: 10:30 AM – 01:00 PM; Tuesday - Friday (4 classes per week of 2.5 hours each)

Weekend Batch Timing:
Option I: 9:00AM - 1:00 PM; Saturday & Sunday (2 classes per weekend, 4 hours each)
Option II: 2:00 PM - 6:00 PM; Saturday & Sunday (2 classes per weekend, 4 hours each)


This module empowers the participant with a never before seen depth in almost all of Excel's powerful Features with a focus on becoming an Expert, by 'Mastering' each of the mentioned categories. The module offers Tips, Tricks, Data analysis and comprehensive coverage of topics that you may not even be aware of

  • Excel Essentials
  • Introduction to key board accelerators
  • Manipulating and formatting rows/columns, boarder sheets
  • Data Validation
  • Hyperlinking
  • Conditional Formatting
  • Paste Special
  • Freezing & Unfreezing Panes
  • Text to Columns
  • Inserting, Viewing & Editing Comments
  • Removing Duplicates
  • Using VLOOKUP & HLOOKUP
  • Using SUMIF, COUNTIF, AND AVERAGEIF
  • Using the TRANSPOSE and SUMPRODUCT function
  • Working with dates - DATEDIF, YEAR, YEARFRACE & MONTH
  • Pivot table
  • Sensitivity analysis with Data tables
  • Charting commonly used
  • Index, Search, Choose, offset

This module empowers the participant with data collection tricks and modeling techniques. Participants learn SEC filling forms types, available information and reading of various reports.

  • Know the different sources for financial data, tricks to collect it in shortest time
  • Deep dive in detailed financial structure to know why such huge data are given in company’s quarterly/annual reports
  • Understanding about different forms available in company filing like 10-K, 10-Q, 8-K etc.
  • Know Sources/Platforms for Quarterly/Annual reports for US, India, China, Germany, South Korea, Hong Kong, Singapore
  • Learn tricks to collect data from available sources in shortest time
  • Create end to end excel template
  • Source and fill in 5 years historical financial data in template for
    • Revenue drivers (Geographical & Segment wise)
    • Cost Drivers
    • Income statement,
    • Balance sheet,
    • Cash flow statement,
    • Fix Assets Module
    • Debt repayment schedule
    • Equity and Dividend schedule
  • Detail discussion over profiles of BUY SIDE and SELL SIDE ANALYSTS
  • Reading, Understanding and Analyzing of Income statement/P&L, Balance sheet, Cash flow statement
  • GAAP and Non-GAAP/Reported and Adjusted structure concepts understanding and application
  • Reported and Adjusted EPS, GAAP & Non-GAAP EPS
  • Pro-forma Income statement
  • Restating financials for valuation and analysis
  • Minority/Non-controlling interest and its treatment
  • Associates and its treatments
  • Subsidiary and its treatment
  • Convertible securities/debt and their treatments
  • Weighted average conceptual understanding and its formula analysis
  • In depth understanding of corporate actions and their impact on Financial statements–
    • Rights issue
    • Bonus issue
    • Takeover, merger, acquisitions
    • Interim or annual dividend
    • Stock splits
    • Spin-offs
    • Reverse split
  • 5 case studies on live small business: Create Financials on live startups follow by one on one discussion.

    That hands-on Financial statements building practice gives students
    • Very detailed and conceptual understandings of Financial statements
    • Set a base how to read financial statements line by line during Balance sheet readings and analysis in Financial Modeling
  • Company’s Business model understandings, Industry trends and Drivers understanding
  • Detail discussion on Macro & Micro economic Factors which impact company’s projections and subsequently valuations
  • Economy/Sector/Industry/Company/Segments/Product value chain understandings
  • Detailed case studies on ‘Top Down’ and ‘Bottom Up’ approaches
  • Forecasting/Projection of Revenue drivers, Cost drivers
  • Forecasting of Income statement, Balance sheet and Cash flow state
    LINKING FINANICAL STATEMETNS & TALLYING BALANCE SHEET
  • Understanding of Interlinking among financial statements (IS, BS, CFS)
  • Learn Tricks to tally balance sheet in 30 minutes and
  • Apply tricks on 5 companies from different sector while tallying balance sheet
  • Understand & use best practices in Financial Model building
  • Understand & develop forecasting basis for each financial line item
  • Forecast Advanced Schedules
    • DRS (Debt Repayment Schedule)
    • FAM (Fixed Assets Module)
    • Dividend Repayment Schedule

    RATIOS:
  • In dept conceptual understanding of Financial ratios
    • 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
  • DUPOND analysis
  • Detail discussion over IRR and NPVfor project evaluation techniques

    VALUATION:

    (In depth conceptual understanding of various types of valuation methods, their usage and limitations)


    DISCOUTNED CASH FLOW(DCF)

    In depth step by step understanding of DCF – Discounted Cash Flow Valuation

  • Application of DCF on your chosen company
  • Understanding, calculation and application of FCFF & FCFE
  • In-depth analysis of risk and cost of equity using Beta and cost of capital using Weighted Average Cost of Capital (WACC)

  • Understanding and application of

  • Cost of Equity, CAPM – Capital Asset Pricing Model
  • Beta, Levered & Un levered Beta
  • Calculate beta using last 5 years price
  • Calculation and detail understanding about Beta, levered Beta, Unlevered Beta
  • Risk Free rate (Rf) of return for listed and non-listed small, Medium, and large companies
  • Market Premium (Rm), Market Rate of Return
  • Cost of Debt
  • Cost of Preference Shares
  • Sensitivity analysis
  • View on the company with supporting points whether it’s a ‘buy’ or a ‘sell’ based on the analysis conducted

    RELATIVE VALUATION (RV)/Trading Comps/Exit Multiple
  • In depth step by step understanding of Relative Valuation (RV), Trading Comp
  • Concept, parameters and tricks to pick right set of competitors
  • Develop understanding to select right ratios for RV as per Industry/Sector preference
  • Enterprise Value (EV)
  • Relative Valuation using price multiples P/E, P/S, EV/EBITDA, P/B
  • Drive model and valuation conclusion

    DDM (DIVIDENT DISCOUNT MODEL) - Gordon Growth Model
  • In depth step by step understanding of DDM
  • Drive model and valuation conclusion

    Merger & Acquisition Model
  • Build end to end Merger & Acquisition valuation Model
  • Pre-merger standalone Financial Statements understandings
  • Analyze and list down business segments performance assumptions
  • Consolidated Financial Model after merging financial statements
  • DCF/RV valuations for merged business/consolidated model
  • View on the company with supporting points whether it’s a ‘buy’ or a ‘sell’ based on the analysis conducted

    EQUITY RESEARCH REPORT
  • Write detail Equity Research Report for your chosen company
  • Company Positives (5 Points) and Negatives (5 points)
  • Economy, Industry and sector research and analysis
  • Revenue and cost drivers research and projections
  • Detail description and analysis of Income statement
    • Revenue
    • Cost of sales
    • SG&A expenses Analysis
    • EBITDA and cash from Operating activities analysis
    • Effective tax rate and current tax rate analysis
    • Reported EPS and Adjusted EPS Analysis
    • Working capital analysis
    • Capital Expenditure (Capex) analysis
    • Debt and dividend analysis
    • Cash flow statement analysis
    • Ratios analysis
    • Valuations analysis (DCF, RV, DDM)
  • Conclusion with analyst call ‘BUY’, ‘SELL’, ‘NUTRAL’
Research Companies

Below is the list of firms offering Financial Modeling jobs –

  • Crisil
  • Glob flex
  • SG Analytics
  • DSIJ
  • Tress Vista
  • Wells Fargo
  • KPMG
  • Wipro Analytics
  • Accenture Analytics
  • TCS Analytics
  • HCL Analytics
  • Mckinnsey Knowledge Center
  • IBM Analytics
  • Mu Sigma Analytics
  • Cognizant Analytics
  • Latent View
  • AbsolutData
  • S&P Global
  • Knowcraft Analytics
  • FactSet
  • S&P Global
  • IHSMarkit
  • Wells Fargo
  • Evalueserve
  • Ernst & Young (EY)
  • Cians Analytics
  • Grant thortan
  • Pulsar Knowledge Center Private Limited
  • Goldman Sachs
  • J.P. Morgan
  • Bank of America Merrill Lynch
  • Evercore Partners
  • Citibank
  • Morgan Stanley
  • Credit Suisse
  • Deutsche Bank
  • HSBC
  • Barclays Capital
  • BNP Paribas
  • Nomura
  • RBC
  • Moody’s Analytics
  • Standard & Poor’s
  • Fitch
  • Egan-Jones
  • DBRS
  • A.M Best
  • Japan Credit Rating Agency Limited
  • Rating and Investment Information Inc
  • LACE Financial
  • Realpoint LLC
  • Crisil Limited
  • Credit Information Bureau India Limited
  • Fitch Ratings India Private Ltd.
  • Equifax
  • Credit Analysis & Research Ltd
  • ICRA Limited
  • ONICRA
  • High Mark Credit Information Services
  • SME Rating Agency of India Ltd
  • Brickwork Ratings India Private Ltd
  • Bricks works
  • Care Ratings
Placement Assistance

    Finxl placement assistance is very unique and different. We ensure that every student gets focused attention for every different company as per clients selection process. Our dedicated placement team works to provide seamless guidance on every call student gets.

  • Job Description of an Equity Analyst
  • Job Expectations
  • Interview preparation packs focusing on mock interviews & written test
  • Frequently asked interview questions & their best answers
  • Mock interviews recording and feedback
  • Resume building and placement assistance
  • 5 companies’ specific selection mock interviews
  • Access to FINXL alumni network (JobConnect)
  • Access to our placement groups and start getting calls
  • One on one company specific preparation

  • Note: FinXL does not guarantee placements. Placements are at the discretion of management and candidates should not enroll with a sole view to seek employment opportunities through us

Course Fee
  • Financial Modeling & Equity Research course fee– INR 30,000
  • Placement Assistance – if student OPTs Finxl placement services, he will have to pay placement charges after his final job offer.
FAQ's

Investment banks and research firms don't entertain fresher's due to lack of minimum practical exposure required on job? Hence, we are here to help you!!

Financial Modeling & Equity Research program aims to empower participants with Model building and Valuation skills through extensive coverage of Modeling, Revenue Build-up techniques, Forecasting and Valuation, Ratios Analysis and Research report writing, all applied on Listed, Private and startups companies!
Students build 6 end to end Financial Models on their own chosen US listed company, Indian listed company) and Indian Start up.

  • We take10 students in one batch. So that we can pay attention to everyone and ensure completion of Models and research reports without compromising on quality
  • We provide rigorous and in-depth training with real-time hands-on job experience in Financial Modeling, Equity Research, Valuations&Equity Research report writing
  • 120 questions QUESTIONNAIRE ensures selection in IB, Equity Research, Financial Modeling
  • 3/6 MonthsInternship with Equity Research firm
  • We make you a Domain Specialist in Financial Modeling
    Since every student gets an understanding of 31 different Financial Models in a batch (3 unique Financial Models prepared by every single student). After completing these models, you can attempt interviews like an experience professional in Financial Modeling & Equity Research. So even being from different vertical and domain, you can apply for jobs which are specifically for Financial Modeling & Equity Research experience.
  • Real time technical interview preparation by Investment bankers
  • Learn best financial modeling practices used in industry
  • Learn 'reading of any listed Indian company financials in 10 minutes
  • Be part of our vast equity research & investment banking alumni network (JobConnect)

Call us on between 10am to 7pm. for a consultation or enrolment.

Training will be conducted at our institute in Pune, India. However, we also provide training on-site for groups of over 10.

Yes, every student needs to carry a laptop.

We do provide placement assistance. It depends on prevailing market conditions & candidate profile. We regularly send and arrange interviews for our candidates in companies like –

Financial Modeling & Equity Research

    MUMBAI:
  • JP Morgan
  • Morgan
  • Transparent
  • Tres vista
  • First global
  • Evalueserve
  • Ernst & Young (EY)
  • Crisil
  • KPMG
  • OAknorth
  • Aseteya investment manager LLP (Valuations)
  • Keynote capital
  • Analah Capital (Female)
  • Morning star
  • Indian Brokerage firms

    PUNE:
  • Crisil
  • Glob flex
  • SG Analytics
  • DSIJ
  • Tress Vista
  • Wells Fargo
  • KPMG (Hinjewadi)
  • Multi Act Trade and Investment
  • ALCOR fund
  • CES ltd
  • CRIF Baner
  • IGEN Shivaji
  • Cap Matric - Purnartha Investment Advisors PVT LTD
  • Niveza

    GURGAON:
  • Evalueserve
  • Moodys Analytics
  • Ernst & Young (EY)
  • Cians
  • S&P Global
  • Cians
  • S&P Global
  • Grant thortan
  • Pulsar Knowledge Center Private Limited

    BANGALORE:
  • Goldman Sachs
  • Moodys
  • Wells Fargo

    HYDERABAD:
  • FactSet
  • S&P Global
  • IHSMarkit

    NOIDA:
  • Tourch Financial Services, Noida

    AHMEDABAD:
  • S&P Global
  • Knowcraft Analytics

    RATING AGENCIES
  • Care Ratings
  • Icra, India Ratings
  • Bricks works

Note: FinXL does not guarantee placements. Placements are at the discretion of management and candidates should not enroll with a sole view to seek employment opportunities through us

Brochure