Introduction

{{checkValue1}} + {{checkValue2}} Please enter correct answer

I agree to the elearnmarkets Terms Of Use and Privacy policy

Request a Call

Would you like to register yourself to get free financial courses, webinars, regular updates or to participate in quizzes, games and more?Yes

{{successmsgsignup}}

In today's world of extensive data where decisions are highly quantitative based, financial modeling has become an indispensable tool. It is the most sought after skill required in the field of investment banking, equity research , project management, commercial banks and mostly all other sectors in the financial services industry. NSE Academy Certified Equity Valuation & Financial Modeling Training Program , listed under Online NSE Academy Courses is a course designed, keeping in mind the need to provide practical exposure to people who believe in the concept of long term investment and value creation. It is a science of building models to depict financials statements and investment analysis using MS Excel, hence arriving at optimal business solution. The Equity Valuation & Financial Modelling Course is designed to help participants understand the essence of the subject and simultaneously use this knowledge on “real-world” problems to construct consistent and realistic financial models.

Objective

The Equity Valuation & Financial Modeling Training program is designed to offer students the intensive instruction and training needed to successfully compete in rapidly developing global financial markets. This program involves the fundamental theories and practices of valuation analysis, strategy analysis, prospective analysis, DCF modeling, trading comparables and transaction comparables. Modeling through Excel will  make the participants confident enough to create their own financial model right from scratch. Learn Financial Modeling and be an expert in deriving company valuation.

 

Benefits

Students enrolling for Equity Valuation & Financial Modeling Training programme will be given a “Certificate of Participation” from NSE Academy facilitated by Elearnmarkets.com, after successful completion of the course. Participants will also be given free access to all webinars conducted by Kredent Academy for further knowledge enhancement. An email query support, Question & Answer community platform can also be availed by the student for any kind of doubt clearance related to content while pursuing the course of Equity Valuation & Financial Modeling.

Topics Covered

Understanding Financial Modelling and Financial statement

• What is financial modelling & Valuation
• Understanding IS and BS
• Understanding Cash Flow Statement
• Sources of financial information

Building a Financial model

• Understanding & Forecasting Business Drivers
• Understanding & Forecasting Revenue Drivers
• Understanding & Forecasting Cost Drivers
• Understanding & Forecasting Working Capital Drivers
• Depreciation Schedule (SLM)
• Loan Amortisation Schedule
• Preparation of  Cash Flow Statements
• Dividend, Bonus Shares
• Best Practices & Pitfalls
• Practical Case Studies

Basic Case Study-Building Financial Model:

• MTL Case Study
• Interest Income Calculations
• Cash Overdraft and Carry Forward Losses
• Deferred Tax Liabilities and Minority Interest

Financial Statement Analysis:

• Steps of Financial Statement Analysis
• Financial Ratios
• Profitability Ratios
• Activity Ratios
• Solvency Ratios
• Cash Flow Ratios

Methods of Valuation:

• DCF Valuation
• WACC
• Terminal Value
• Sensitivity Analysis
• Relative Valuation
• Fundamnetal Multiples

Financial Modelling Case Study:

• Manali Trance Limited Case Study

 

 

Intended Participants

MBA Finance, CFA, CA, Commerce students, candidates looking to make career as an Equity Research Analyst as well as working professionals to improve their job prospects in Equity Research field.

 

Summary

• 59 Videos
• 10+ Hours of content
• 8 PDFs
• 21 Worksheets
• 1 Word Document

FAQs

Frequently Asked Questions