Equity Research And Financial Modeling


In this Financial Modelling course, candidates will learn to create complex financial models used for financial statement analysis & company valuation. Also, the candidate will learn the fundamental approach of investing used by Institutional Investors like FII's, MF's, Insurance Companies, and many more. The course will be practically delivered by Ex. Sell Side Equity Analyst - Motilal Oswal and CFA Charterholder


By the end of this Financial Modelling course you will be practically trained to build equity valuation models from scratch, forecast company’s financial statements, design professional and good looking advance charts, apply advanced excel functions, analyzing economic indicators from global perspective and  preparing & presenting research report under you his/her name



KPO's, Credit Rating Companies, Financial Research Companies, Investment Advisory and Financial Brokers

Key Course Highlights:

    • Working with worksheet: Adding and Deleting row & column, selecting multiple cells, jumping between cells, editing cell data, moving between worksheet, Fit column width, Hide and Unhide row & column

    • Tabs: Home, Insert, Page Layout, Formulas, Data, Review and View

    • Functions: Mathematical and Statistical Functions, Text Function, Financial Functions, Logical Functions and Date & Time Functions (Including advance functions like Vlookup, Hlookup, Amortization schedule, NPV, IRR, Concatenate, Sum if, PMT and many more..)

    • Some Special Functions: Paste special, What If Analysis, Pivot Table, Hyperlink, Charts, Conditional Formatting, Data validation, Protect sheet & workbook, Absolute & Relative referencing and Freeze Panes

    • Financial Statements Preparation: P&L account, Balance sheet and Cash flow statements

    • Sector specific revenue model and Balance sheet characteristics

    • Analysis: Revenue model, COGS, SG&A, Fixed cost, Tax and Profitability analysis

    • Ratios: Activity, Solvency, Liquidity, Profitability, Valuation ratios, Du point analysis, and Common size statement analysis

    • Valuation methodology of financial elements: Historical, Replacement cost, Realization, Fair & Present value

    • Data Gathering: Directors report, Auditors report, Schedule & Notes to the account ,Qtly results ,Investor presentation, Company updates & filing, and concall script

    • Sector Analysis: Peer comparison, Industry data, and Porters five forces

    • Top to Bottom Approach: Economy - Industry - Company

    • Economic Variables: GDP, Monetary & Fiscal policy, Inflation, Unemployment

    • Report: Understanding & Analyzing economic report

    • Forecasting Approach: Top to Bottom, Bottom to Top and Hybrid Approach

    • Forecasting: Integrated Financial Model,

    • Revenue Build Up: Segmental analysis, geographical analysis, growth assumptions
    • Cost Build Up: COGS and SG&A model, Depreciation & Interest cost forecasting and Tax calculation
    • Asset Schedule: Capex and Capitalization forecast, Gross block, Accumulated depreciation and Capital WIP forecast
    • Debt Schedule: Expected debt equity structure, Net debt schedule

    Basics: Time Value of Money, Opportunity Cost, Risk Free Rate, , Alpha, Cost of equity , CAPM and The Beta

    Cost of Equity Methods:

    • Capital asset pricing model, Risk free rate, Beta, and Equity Risk Premium calculation
    • Dividend discount model: sustainable growth rate calculation
    • Bond yield plus risk premium approach

    Relative Valuation Technique: Price -to-Earning (P/E) Ratio, Price -to-Book value (P/B) Ratio, EV/EBITDA

    Absolute Valuation Technique: Free Cash Flow to Firm (FCFF), Free Cash Flow to Equity (FCFE),Dividend Discount Model (DDM), Gordon Growth Model (GGM), Single and Multi Stage Model

    • Types of report: Initiating coverage report, Result update, Sector report, Thematic report

    • Effective report writing

    • Advance MS Word