Cohort Based Program

Python's convenience has made it the most popular language for machine learning and artificial intelligence. Python is taught with a focus on management and analytics. There are more that 50 million jobs which require knowledge of Python in the management world. The digital transformation that has taken place during the Covid lockdown has accelerated the process of automation which extensively used tool built using Python. It is not a surprise, therefore, that marketing, finance, and operations roles are asking for management graduates who are trained on Python.

This course is taught by a faculty, who has been a pioneer in bringing Python into the management curriculum in India. For the first-time in 2017, Python for Business Analytics was taught as part of the Post-Graduate Diploma in Management.

USP of this Course

Guaranteed Internship

Learn from faculty who have done AI-ML in Python

Live Project using Python applied to Analytics

One-on-one mentoring from faculty

Career Support

Applications

Machine learning in marketing, operations and finance

Use of Python in automation

Creation of new products in computer vision and natural language processing

Course Content

Module 1:

Different types of objects in Python – list, dictionary etc.

Using conditionals such as IF, ELSE, ELIF

For/While loops for repetitive task

Module 2:

Pandas – panel data

Numpy – numerical python

Matplotlib/Seaborn – data visualization

Module 3:

Reading data from different sources – excel, csv etc.

Pre-processing data such as removing missing values, outliers

Standardizing data

Module 4:

Exploratory data analysis

Regression model to predict customer churn

Stock price prediction using live data

Guest Lectures

Industry veterans’ former students of EdLightened would share their experience in the industry. This will be an opportunity to ask questions and network with experience professionals.

Evaluation

End term live project will be provided and evaluated by CXOs. Our CXOs have been in artificial intelligence and machine learning for many years and have mentored many professionals and students.

Course Delivery

The course is delivered over Zoom. Video recordings can be accessed post the class. A separate WhatsApp group will be formed with students who have enrolled for the class. Excel sheets will be shared prior to each session. You can speak to the course faculty at any time that you wish. It is expected that the course will take about 12 hours to complete. 

Pay the registration fees and you will be registered for the course.

Financial Modelling has been curated after discussions with senior managers in several well-respected companies, which typically hire more than 1000 graduates each year for a variety of roles in the treasury, investment banking, equity trading, algorithmic trading, fixed income securities, forex, management of accounts etc.

The course is taught by faculty who have trained more than 50,000 students over 20 years. The focus is on teaching how to apply the concepts rather than understanding just the theoretical framework. There are more than 10,00,000 jobs in this field but finding skilled talent is difficult.

USP of this Course

Guaranteed Internship

Learn from faculty who have done financial modelling

Live Project in Financial Modelling and Valuation

One-on-one mentoring from faculty

Career Support

Applications

Valuation during mergers and acquisitions

Equity research - is a stock price high or low as compared to the financial projections

Credit risk analysis - model to evaluate how debt causes financial distress

Course Content

Module 1:

• Profit & Loss statement, Balance Sheet and Statement of Cashflow
• Net Present Value, Internal Rate of Return and Payback Period
• Annuity and Perpetuity

Module 2:

• Capital Asset Pricing Model
• Return on debt and credit rating
• Weighted Average Cost of Capital

Module 3:

• Select a company (e.g. Britannia, SRF Chemicals, Dabur)
• Obtain the data from the annual report of the company
• Compute the ratios and create the financial projections
• Free cashflow and Enterprise Value
• Compute the share price

Module 4

• Dividend Discount Model
• Abnormal Earnings Model
• Financial Distress and APV Model

Guest Lectures

Industry veterans’ former students of EdLightened would share their experience in the industry. This will be an opportunity to ask questions and network with experience professionals.

Evaluation

End term live project will be provided and evaluated by CXOs. Our CXOs have been in finance for many years and have mentored many professionals and students.

Course Delivery

The course is delivered over Zoom. Video recordings can be accessed post the class. A separate WhatsApp group will be formed with students who have enrolled for the class. Excel sheets will be shared prior to each session. You can speak to the course faculty at any time that you wish. It is expected that the course will take about 12 hours to complete. 

Pay the registration fees and you will be registered for the course.

The Financial Analyst programme is unique because it provides a holistic foundation to professional and students pursuing a career in Finance. Post this course students can expect roles in the treasury, investment banking, equity trading, algorithmic trading, fixed income securities, forex, management of accounts etc.

The banking sector is wide and everyday new financial products are launched. More than 10,00,000 jobs are available. However, finding people with relevant skills and knowledge is challenging. The course is taught by faculty who have trained more than 50,000 students over 20 years. The focus is on teaching how to apply the concepts rather than understanding just the theoretical framework.

USP of this Course

Guaranteed Internship

Learn from faculty who have done financial modelling

Live Project in Financial Modelling and Valuation

One-on-one mentoring from faculty

Career Support

Applications

Valuation of a company for both buy and sell side mergers and acquisitions

Investing through Private Equity

Portfolio Management of stocks, bonds, commodities etc. for giving superior risk-adjusted returns to investors

Designing credit rating models and managing financial ratings

Financial risk management and hedging strategies

Course Content

Module 1: Mergers and Acquisition

• Trading Multiples
• Precedent Comparables
• Discounted Cashflow Analysis
• Leverage Buyout Models (Private Equity Investing)

Module 2: Portfolio Management

• Selection of Asset Class
• Portfolio Construction
• Performance Measures
• Technical Analysis – RSI, Bollinger Bands, MFI, MACD etc.
• Mutual Funds
• ETFs and Index Funds
• Alternative Investment Fund

Module 3: Bond and Credit Rating Models

• Duration and Convexity
• Bond Portfolio Management
• Z-Altman Score
• KMV Model
• M-Score
• Logistic Regression

• Basel Norms and Internal Rating Model

Module 4: Derivatives

• Futures and Forward
• Call and put options
• Put-Call Parity
• Black Scholes Pricing
• Trading Strategies

Module 5: Digital Assets

• Blockchain
• Crypto-currency
• Non-Fungible Tokens

Guest Lectures

Industry veterans’ former students of EdLightened would share their experience in the industry. This will be an opportunity to ask questions and network with experience professionals.

Evaluation

End term project will be provided and evaluated by CXOs. Our CXOs have been in finance for many years and have mentored many professionals and students.

Course Delivery

The course is delivered over Zoom. Video recordings can be accessed post the class. A separate WhatsApp group will be formed with students who have enrolled for the class. Excel sheets will be shared prior to each session. You can speak to the course faculty at any time that you wish. It is expected that the course will take about 20 hours to complete.

Registration is processed on payment.

Fortune Business estimates that the global data visualization market size stands at USD 8.85 billion in 2019 and is projected to reach USD 19.20 billion by 2027, exhibiting a CAGR of 10.2% during the forecast period.

Microsoft wants to seize this large market and has created a data visualization and business intelligence tool which is better known as Power BI. This is a business intelligence platform that provides nontechnical business users with tools for aggregating, analyzing, visualizing and sharing data. Power BI's user interface is fairly intuitive for users familiar with Excel and its deep integration with other Microsoft products makes it a very versatile self-service tool that requires little upfront training.

More more that 10 million jobs require knowledge of Power BI in the management world. The digital transformation that has taken place during the Covid lockdown has accelerated the process of automation. It is not a surprise, therefore, that marketing, finance, and operations roles are asking for management graduates who are trained on Power BI.

USP of this Course

Guaranteed Internship

Learn from faculty who have experience in Data Visualization using Power BI

Live Project using Power BI

One-on-one mentoring from faculty

Career Support

Applications

Data visualization in marketing, operations and finance

Use Power BI to generate Business Intelligence

Create a storyboard for managers, venture capitalists, investors etc.

Course Content

Module 1:

Connecting to excel and different data sources

Data Types

Basic formatting and charting

Basic reporting with different charts (Bar, Line, Scatter)

Report Formatting – colour, size, font

Module 2:

Query Editor and M query

Clean up and transformation in Power Bi desktop

Transform, Combine, Manage Rows & Columns, Pivot Columns,

Data Type Transformations, Data Quality, Distribution and Profiling

Merge and Append Query

Create calculated & conditional columns

Module 3:

DAX functions

Working with basic functions of DAX – MIN, AVG, MAX, DIVIDE

Creating measures using DAX functions

Advanced DAX functions CALCULATE/CALENDAR/FILTER/SUMMARIZE

Time Intelligence functions

Module 4:

Introduction to relationships (Star Schema and Snowflake Schema)

Working with AI charts in Power Bi

Advanced filters – Drill through, Report, Page visual levels, Row Level Security

Guest Lectures

Industry veterans’ former students of EdLightened would share their experience in the industry. This will be an opportunity to ask questions and network with experience professionals.

Evaluation

Live Project will be provided and evaluated by CXOs. Our CXOs have been in data visualization and power BI for many years and have mentored many professionals and students.

Course Delivery

The course is delivered over Zoom. Video recordings can be accessed post the class. A separate WhatsApp group will be formed with students who have enrolled for the class. Excel sheets will be shared prior to each session. You can speak to the course faculty at any time that you wish. It is expected that the course will take about 12 hours to complete. 

Pay the registration fees and you will get registered.

A career in Investment Banking is highly rewarding. This course has been curated after discussions with investment bankers who have advised companies on a broad range of transactions involving mergers, acquisitions, IPO, joint-ventures, carve-out etc

The course is taught by faculty who have trained more than 50,000 students over 20 years. The focus is on teaching how to apply the concepts rather than understanding just the theoretical framework. There are more than many jobs in this field but finding skilled people is difficult. Most people have a high-level view of banking instead of the industry knowledge to close a deal.

USP of this Course

Guaranteed Internship

Learn from faculty who have done Investment Banking

Live online classes saving you the hassle of travelling

One-on-one mentoring from faculty

Career Support

Applications

Mergers and Acquisition - create the football field highlighting the valuation using different techniques

Equity research - is a stock price high or low as compared to the financial projections?

IPO Analysis - identify the intrinsic value of a private company and price its share

Course Content

Module 1:

• Profit & Loss statement, Balance Sheet and Statement of Cashflow
• Net Present Value, Internal Rate of Return and Payback Period
• Annuity and Perpetuity

Module 2:

• Capital Asset Pricing Model
• Return on debt and credit rating
• Weighted Average Cost of Capital
• Enterprise value ratios – EV/EBITDA etc.
• Conversion of Options (ESOPS) to stocks
• Purchase of company using Cash and /or Stock

Module 3:

• Discounted Cashflow Method
  • • Forecast the Free Cash flow
    • Determine Enterprise Value
    • Compute the perpetuity and exit multiples
    • Conduct a sensitivity analysis
    • Compute the share price

Module 4

• Precedent Comparable and Trading Comparable
  • • Identify companies which can be compared
    • Select the ratios based on industry – GMV, ARPU etc.
    • Determine the valuation range based on multiples

Module 5

• Leverage Buyout Model
  • • Debt Structure and Equity Sponsor
    • Prepare Debt Repayment Schedule
    • Establish cashflows, income statement and balance sheet
    • Create transaction sheet with entry and exit multiples
    • Conduct sensitivity analysis and compute the IRR

Module 6

• Football Field – comparing valuation using all 4 models
• Buy Side M&A
• Sell Side M&A
• Due Diligence and Regulations

Guest Lectures

Industry veterans’ would share their experience in the industry. This will be an opportunity to ask questions and network with professionals.

Evaluation

Complete all models in Excel and submit it to EdLightened for evaluation.

Course Delivery

The course is delivered over Zoom. Video recordings can be accessed post the class. A separate WhatsApp group will be formed with students who have enrolled for the class. Excel sheets will be shared prior to each session. You can speak to the course faculty at any time that you wish. It is expected that the course will take about 12 hours to complete. 

Pay the registration fees and you will be registered for the course.