Home > Courses & Certification > Financial Market > Financial Modeling for Stock Markets

Financial Modeling for Stock Markets I AM INTERESTED Back

Financial Modeling is applied in several areas of Banking, Stock Markets, Equity Research, Big Data Analytics etc. This module provides in depth knowledge of Equity Research and usage of Big data in the process of decision making with respect to stock markets. Financial Modeling helps in company’s end to end valuations by forecasting and assumptions techniques. Reading the annual report, analyzing the data and excel proficiency is extremely important for an analyst day to day job, hence the course provides thorough understanding of clarity and concepts of predictive modeling techniques related to stock markets. Faculties of NIFM are having experties in value claculation by using financial modeling. It is totally based on advance use of excel to find valuations through different models in financial modeling. 

Program Highlights:

•Job upgradation course with class room training course.
•Program endorsed by leading banks, financial institutions and stock brokers.
•Be a Financial Modeling Expert in 3 months
•Faculty from top notch banks, financial institutions and stock brokers having more than 10 yrs of experience.
•Live Assignments case studies of on company valuations with live examples
•Get certifiy from NIFM.
•Live & Desk Cases on companies
•Understanding Analyst Presentations
•Online mock test with 500 question answers for NSE NCFM certification courses bank.

•Regular Course 
•Program Fee – Rs 30000 + GST
•Program duration – 3 Months


•    Students seeking career in financial modeling, Equity research, company valuation and investment banking.
•    Working Professionals
•    Traders & Investors


What You Will Get:

•Certification from NIFM.
•Learn financial modeling through excel and advanced excel.
•Learn to calculate the value of a company & share.

Classes on alternate days in weekdays and weekends for 2-3 hours


Module 1: Overview of Financial Jargons

• Basics Of Finance & Markets
• Macro & Micro Trends & Impact
• Understanding Basic Excel.
• Forecasting Techniques.
• Overview of NSE, BSE & MCX
• Data Mining Techniques.
• Annual Report Analysis.
• Financial Statements Analysis.
• Cash Flows Analysis.
• Balance Sheet Analysis.
• Financial Ratios and there uses.
• Du-point Analysis.
• Quarterly Results Analysis.
• Earning Per share, PE& ROI Analysis.
• IPO Valuation.

Module 2: Excel Shortcut

•Understanding and crafting a financial model template.
•Familiarizing with excel shortcut keys.
•Text, Rounding, left, right,Date functions, Concatinate etc.
•Index, Index Match, Nested If, Sum If , Count If, Hyperlink.
•Vlook up, Hlook up, Sum Total, Paste Special.
•Conditional Formating, Basic Charting, Goal Seek & Scenario Manager.
•Solver,Basic Macros & Form Control Techniques.
•Bar, Pie, area, surface , radar charts etc.


Module 3: Economics on ExcelRegression, Anova.
Understanding Dependent and independent variables
Understanding R, Significance error & Intercept.
Correlation, Covariance & Standard Deviation.
Beta Analysis.
PV FV & Bond Valuation
Forecasting with Excel.
Basic Black & Scholes.
Report writing technique and Software knowledge.
Module 4: Discounted Cash flow ApproachForecasting Techniques.
Revenue Builders.
Building the asset and depreciation schedule.
Building P&L & Balance sheet.
Building Assumptions & Debt Schedule.
Building Capex Schedule.
Decoding Ke,Kd&Kp with WACC.
CAPM and its understanding.
Module 5: Risk & Return Models
Stock Portfolio model.
Descriptive Statistics Models.
Understanding Standard Deviation & Variance.
Understanding CAL, SML & CML equations.
Markowitz Modern portfolio model.
Skewness, Kurtosis & Range.
Net Asset Value Analysis.
Relative & Comps Techniques.
Dividend Discount Model.
Sessions will be include a Mid term and a End term examination.

Career Opportunity

Candidate can get job as Group Manager - Acquisitions, Manager - Financial Modeling & Audit, Project Manager - Financial Model, Conversion, Equity Research Analyst, VP/AVP - Debt Markets Advisory, Research Analyst - Economic Data, Business Analyst, Equity Research - India, Market Risk/Risk Management, Venture Analyst, Market Data Quantitative Analyst

Minimum Criteria student pursuing 2nd Year or above in Bachelors Degree.

Design & Developed by www.appitsolutions.com