Financial Modelling Equity Research - Short Term Financial Analyst
3.5 Months
Any graduate/Fresher as well as Experience
Get a Globally Accepted Certification
Our course is thoughfully designed in such a way that learner gets the Real Time Investment banking & Equity Research exposure. Learner is not necessarily be from finance background, as our course ensures that Basic finance & account concepts are covered in detail with real time examples.
It is 80% practical with industry used case studies.
Our assessment & presentation evaluations are similar to top investment banks & equity research firms Our expert trainers are on hand to help answer any questions you might have along the way.
Course Features
EXPERT SUPPORT
Online support from our team for all your queries based on ticket based tracking system
CERTIFICATION
Get 3 certifcations inone course financial modeling, equity research and advance excel. You can show them seperately in resume.
REAL TIME CASE STUDIES
Live case studies for each financial topics to ensure that learner can understand it thoroughly.
RESUME PREPARATION
Our expert will assist you in resume building and job portal updation.
LIFETIME ACCESS
You get lifetime access to the FINXL LMS which includes videos, excel spreadsheets, presentations, ebooks, quizzes and case studies.
FORUM
Our career square forum is ths most dynamic platform to connect with expert across the globe.
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
Course Details
Course duration: Intensive 3.5 Months
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