Sip Report (Final)
Sip Report (Final)
Sip Report (Final)
Submitted By
SHRISHTI DUBEY
Roll No. 80
MMS-Batch: 2020-22
Declaration
I hereby declare that this project report titled “'Fundamental Performance of the IT
Sector'', submitted in partial fulfillment of the requirement of Master of Management
Studies to Chetana’s R.K. Institute of Management and Research, is my original work
and not submitted for award of any degree or diploma fellowship or for similar title or
prize. References of work and related sources of information have been duly
acknowledged in the report.
The project has been carried out under the guidance of Dr. Jayashree A. Bhakay
I further declare that I have no objection and grant the rights to Chetana’s R.K. Institute
of Management and Research to publish any chapter/project or use it for future reference
if they deem fit.
Place : Mumbai
Date :
Name : Shrishti Dubey
Class : MMS Batch 2020-22
Roll No. : 80
Signature :
Certificate
This is to certify that the project titled “ Fundamental Performance of the IT Sector '',
submitted by Shrishti Dubey to Chetana’s R. K. Institute of Management & Research
in partial fulfillment of the requirement of Master Of Management Studies, has been done
under the guidance of the undersigned during the period May to June, 2021.
Date:
Place: Mumbai
I express heartiest gratitude to Mr. Dakshath Deviah and Mr. Rahil Hassan to guide
me throughout the internship and help me to gain insightful knowledge for the
subject. With the help of both of them I got enabled to have practical exposure and
understand how things work in real-time basis.
I would also like to express special thanks to our director, Dr. Jayashree Bhakay, who
also is my project mentor for her valuable guidance and support throughout the
project. I sincerely acknowledge her for extending her valuable guidance and critical
reviews on the project and above all, the moral support she provided during all the
stages of this project.
Shrishti Dubey
Executive Summary
The project titled " Fundamental Performance of the IT Sector ''is basically
comprising of Fundamental and technical analysis of Nifty IT stocks focusing upon
7 companies ,wherein more emphasis have been led upon Fundamental part. In
fundamental analysis various ratios have been used. Out of these ratios a 5-Point
Analysis has been made upon the 7 companies considering sector specific ratios. For
the determination of analysis various ratios such as EPS, P/E ratio, Dividend payout
ratio and Return on equity etc have been used. A comparison has been made after the
analysis. Technical Analysis is considered by using technical indicators like RSI,
VWAP, Bollinger Band, MACD. These indicators provide buy or sell signals and
how the stock reacted after these signals.
A brief overview upon the IT Sector in India apart from IT companies has also been
made.
KEYWORDS: EPS, P/E ratio, Dividend payout ratio, RSI, Bollinger Band
TABLE OF CONTENTS
CHAPTERS PARTICULARS PAGE NO
1 INTRODUCTION 1-7
1.1 Introduction to the Task 1
2.4 Limitations 16
5 ANNEXURES 41
Bibliology/ Webliology 41
Chapter 1
Introduction
1
1.2 Introduction to the Sector/Industry
Figure 1
Financial markets in India are divided broadly into two categories that is money markets (dealing in
short-term funds) and capital markets (dealing in long-term funds).Structurally, money market has both
organised and unorganised sectors.
Unorganised sector is comprises of indigenous money lenders and bankers who generally are not in
formal lines of business.
2
Figure 2
▪ The Indian financial services sector is comprising of the capital markets which includes asset
management, depository companies, wealth management, broking, investment banking,) and
non-banking financial companies (NBFCs). Payments banks have also been allowed by the
market regulator with new entities which will be created recently thus an addition to the types of
existing entities operating inside the sector.
▪ With adoption of technologies such as, mobile phones, cloud computing and Interconnectivity
companies booming in the financial services industry are being able to speed up investment in
the information technology (IT) to get better experience to the users.
▪ Rise in financial inclusion, an increase in the financial assets penetration, enlarged
participation in equity capital markets coupled with adoption with the technology has led to
growth of the Financial Sectors
▪ An increase in the participation and inclination of domestic individual investors towards
Indian mutual fund industry has many factors including rising awareness upon advantages
of investing in equity markets and growing awareness of ways of investing, such as SIP etc. The
Mutual fund industry AUM in India has grown at a CAGR of 15.5% over the past five years,
with the equity AUM growing at a CAGR of 17.3%.
▪ During the last five years, the Indian equity markets also seen a healthy relation between the
domestic institutional investors (largely Mutual Funds) and Foreign Portfolio Investors (FPIs),
which has significantly reduced the degree of trust on FPI inflows, which has led to more
stability to the Indian markets.
3
▪ The Equity market of India has been experiencing expansion in many respects and market
capitalization, which has widened the area for brokerage firms. Last year there were 1942 and
5461, respectively listed companies on NSE and BSE.
It aims to meet any particular investment goals that benefit the clients whose money has been
provided to these companies. These clients are individual or institutional investors including
retirement plans,mutual funds, governments, , insurance companies, educational institutions.
4
1.3 Introduction to the Organization
Objectives: -
1. To promote financial literacy among the people.
2. To build a community of likeminded people having financial goals to chat together, create
and share ideas.
3. To make it easy to understand for a layman on how the financial market functions.
5
SWOT Analysis of AFM Advisory
Figure 3
6
1.4 Introduction to the Project
The I.T sector is broadly divided into two major categories first is services and products. Services
are further classifies into ITeS and Others. An easy way of identifying the ITES is by refering to
the classification provided by the GATS of the World Trade Organization. According to this
classification, the sub-category of Computer and Related Services are including the following
services: (i) consultancy services that are related to the installation of computer hardware; (ii) data
processing services; (iii) software implementation services; (iv) database services; and (v) other
related services. India has more than approximately 5000 ITES companies, having maturity of
more than 25 years. Other services however include services such as AMC or Annual
Maintenance Contract, etc. The product includes reselling of electronic items such as laptops
,providing storage solutions, networking solutions.
Further following table represents the growth rate of Export and import Indian Services Sector
inclusive of IT sector.
Figure 4
7
Figure 5
IT Enabled Services
2017- 2018- 2019- 2020-
Parameter NAME Units 18 19 20 21
USD
Indian ITeS Exports billion 28.4 30.8 33 32.5
IT Services exports employee base thousands 1188 1244 1287 1283
Operating Margin for ITeS companies per cent 15.6 15.3 15.9 14.8
rupees
Domestic ITeS market billion 265 286 306 279.4
Domestic ITeS employee base thousands 212 218 225 219
8
Source: Crisil Report
Figure 6
IT Services
2017- 2018- 2019- 2020-
Parameter NAME Units 18 19 20 21
USD
Indian IT Service Exports billion 69 74 78.1 82.7
IT Services exports employee base thousands 1970 2071 2142 2339
Operating Margin for tier 1
companies per cent 23.3 23.6 22.4 24.4
Operating Margin for mid-tier
companies per cent 16.6 17.7 15.7 18.2
rupees
Domestic IT services market billion 1097 1166 1232 1171
Domestic IT services employee
base thousands 597 614 633 636
Source: Crisil Report
Figure 7
Figure 8
9
Figure 9
Our study will be confined to the following 7 companies of the Nifty -IT Sector
The entire focus of the research is Fundamental Analysis on the IT Sector companies of India with
Fundamental analysis:-
Fundamental analysis is a method used by experienced investors to identify the intrinsic value of a stock.
The current price of a stock may not be as the current actual value of the stock. The stock may be
overvalued or undervalued in the market. the underlying health of the company is studied by Fundamental
analysts in order to find the intrinsic value.
various qualitative and quantitative factors such as the company’s revenues, profit margins, return on
equity, future growth potential and other metrics are use to this. The main purpose of this method is to
identification of the fundamentally strong companies in order to invest in them for the long term.
10
Importance of Fundamental Analysis
In the crux of investment, fundamental analysis helps in better decision making. it helps one to have
fair value determination. Evaluation of the health and performance of any organisation through crucial
numbers and major economic indicators can be made through stock fundamental analysis.
the business model of a firm can be understood using Fundamental analysis of stocks and the working of
management, essential for making prudent investment decision. this enables a company to gauge it
strength and their by beat its competitors.
Following different tools are used to determine and evaluate the actual worth of a stock by the Investors .
• Financial reports which comprises balance sheets, income statement, cash flow statement
• Earnings including quarterly earnings and projected future earnings
• Financial ratios for e.g. Earnings per share, price to earnings ratio, return on equity
Technical analysis:-
Technical analysis is a method used by traders to forecast future price movements of stocks by analysing
past trading activity. technical analysts use Chart patterns and statistical numbers .
Fundamental analysis has a believe that the market value of a stock may not always match the true value
of the stock. hence the intrinsic value of a stock is calculated by fundamental analysts thus benefitting in
investing in undervalued stocks.
On the contrary, technical analysts have the belief that the fundamental elements that a stock’s value has,
are already represented in the stock price. In addition, stock prices move in trends that are identifiable over
a period of time.
Hence the past price patterns of stocks are evaluated in order to find out how the stock price moves in the
future.
Now that you know the meaning of technical analysis let’s see the various tools that are used in it. They
are:
• Charts
Volume charts ,one of the most widely used technical analysis tools show the number of shares bought
and sold in the market during a day. One can either use a bar chart or candlestick chart to make technical
analysis. If used together with trend lines, charts facilitate technical analysis to a great extent.
• Momentum Indicators
These are statistical figures calculated based upon prices of the stock and volume data. During technical
analysis, momentum indicators behave as supporting tools to charts. One of the objectives of technical
analysis is to verify views about a stock and momentum indicators .
• Moving Averages
Another technical analysis tool, with moving averages you can eliminate sharp and frequent fluctuations
in a stock chart. Note that sometimes there could be sharp movement in stock
prices within a short period. This makes it difficult to predict the trend. Moving averages help remove its
impact and make the trend more prominent.
Sentimental Analysis:-
Sentiment analysis is the process that helps in analyzing the sentiments of people using various platforms like
social media and similar websites, where in people can freely express their emotions and opinions about
anything they think or wish to do.
And classification of these kinds of sentiments can be done at the , sentence level, , phrase level and document
level.
12
Any news present on social media spreads very fast. Such news if comes in favor or against
the stocks, it builds a huge pool of investors into one basket, being a deciding factor for the stock prices to
go up or down.
A relation between currency of one country with the other currencies is shown by the exchange rate.
Fundamentally, it can be described as the rate at which a person exchange one currency with any other. For
example, let us take the US dollar and Indian rupee. If one wants to buy one US dollar then he/she will have
to pay INR 71 in India. So, the exchange rate for USD-INR becomes 71 per dollar.
This exchange rate being a very close link with trends in stock market. The rate at which one currency is
exchanged for the other does not remain stable. It fluctuates, and fluctuates very fast. So such kind of
changes in the value of exchange rate strengthens or weakens a particular currency against the other.
Besides the exchange rate fluctuations, the following are the important factors among others. These also
affect the trend in the stock market in India.
1. Any development or change inside the organization– Internal developments are the ones that occur within
the companies. This consist of various restructuring patterns including financial reports, mergers and
acquisitions, development and improvement of a new invention ,suspension of dividends,. Furthermore, if
any company executive is hired or fired out of allegations of being fraudulent,it has deep effect upon the
company..
2.World happenings and events – This factor comes into the picture when any war or civil unrest, terrorism
natural disaster. These influence might affect can be directly or indirectly and they forming a chain reaction.
3. Interest rates and Inflation– The most predictable influence of stock market comprise of periodic
adjustments of interest rates and any fluctuations in the same. The central bank in any economy is
13
responsible to perform these adjustments. In India, the RBI does this and regularly fights against inflation.
In case of high interest rates, investors are willing to sell their stocks holdings. High inflation is a result of
High-interest rate having a negative impact on the stock market. They will prefer to invest in securities such
as bonds that government-backed. They also try to take advantage of the higher interest rates and so they do
this.. They also get satisfaction by knowing that their investment is secure & safe.
4.Sentiments– Any new company or famous but old company is launching new product or services brings in
excitement or hype in the stock market. The organizations create hype mainly in order to promote their
stocks.This helps to increase the value of their own shares and profits. Hype could be through , internal blogs.
positive financial reports, press releases and news reports. These hypes will create high expectations for the
performance of the company.
14
Chapter 2
Summer Internship Task Details
• Dr. AS AMBILY (2017) in his research paper titled, “A study on Fundamental Analysis of
Selected IT Companies Listed At NSE” has focused on the understanding of Fundamental
Sector and tools to measured the same.
• VALARMATHI A (2016) in his research paper titled, “A Study on the Technical Analysis of
NSE towards IT stocks with Reference t Indian Stock Market” has thrown light on technical
analysis and various indicators used for the same to analyze IT stocks.
• RAKESH MOHAN AND PARTHA RAY(January 2017) in their research paper titled 'Indian
Financial Sector-Sector, Trends and Turns ' published by IMF have provided all the necessary
details on the sector analysis.
• 'How sentimental Analysis is used for Stock Prediction' an article written by VIKRAM
SINGH BISEN explains how analytics is used to analyze a stock sentimentally.
• 'Chapter 9 -Services in the Economic Survey' on the website of Government of India 'Analysis
of Financial sector of India' on businessmapsofindia
15
2.3 Research Methodology
• The main focus of the study is Fundamental analysis and technical analysis of
companies under Indian IT Sector
• Tools like relative strength index (RSI), Bollinger band, Volume Weighted Average
Price (VWAP), MACD etc have been used for Technical Analysis.
• Fundamental Analysis is done using Liquidity, Efficiency and Profitability ratios
• A 5-Point Analysis has also been made on all the companies whose data was
available. This analysis is made considering sector Specific.
• Study on the effect of Foreign Exchange Fluctuations on the IT stocks has also been
considered as a short part.
• Due to Covid-19 and Bull run going on in the market ,major focus is done on
Fundamental Analysis.
• All the data has been collected from the Annual Reports of all the companies being
studied.
• Major Data Collection Source is Secondary.
2.4 Limitations
16
Chapter 3
PRIMARY DATA PRESENTATION, TABULATION,
ANALYSIS/INTERPRETATIONS
17
Operating Profit Margin
18
The current ratio is a kind of liquidity ratio indicating the capacity of a particular company to repay
its short-term loans that are due for the next year.. It answers the question: “How many rupees in
current assets can cover each rupee of current liabilities?
Current Ratio
2017 2018 2019 2020 2021
TCS 2.2 3.3 4.92 4.85 6.4
Infosys 2.74 2.88 3 3.78 4.05
HCL Techn. 2.77 1.69 2.93 3.29 3.06
Tech Mahindra 3.36 3.16 2.28 2.85 2.8
Wipro Ltd 2.5 2.77 2.94 2.84 3.5
MindTree 2.87 2.46 3.23 2.57 2.7
L & t Infotech 1.46 1.18 1.3 1.32 1.44
19
• EARNING PER SHARE
Earnings per share (EPS) are a company's net profit divided by the numberof
common shares it has outstanding. EPS shows the earning capability of the
company.
20
• PRICE TO EARNING RATIO
It is the ratio for valuing a company that measures its current share price
comparative to its per-share earnings. By comparing this ratio of particular company
with sector specific P/E we get an idea whether the stock is at an undervalued or
overvalued rate.
21
• DIVIDEND PAYOUT RATIO
It is the ratio that indicates the total amount of dividends paid out to
shareholders with respect to the net income of the company. The Dividend Payout
Ratio shows what a company‘s pay out to investors in the form of dividends.
22
• R
E
T
U
R
N
O
N
• RETURN ON EQUITY
It is calculated by,
ROE
2017 2017 2019 2020 2021
TCS 30 30 35 35 38
Infosys 21 25 24 25 25
HCL Techn. 26 24 24 22 19
Tech Mahindra 21 17 20 21 18
Wipro Ltd 16 17 16 18 20
MindTree 16 21 23 20 26
23
L & t Infotech 31 29 31 28 27
Return on Capital Employed (ROCE) is a profitability ratio that measures the efficiency of a
company in utilization of its capital to generate profits. The return on capital employed metric is
considered to be one of the best profitability ratios and is commonly used by investors to determine
and evaluate whether a company is suitable to invest in or not.
24
Wipro Ltd 19 17 19 20 22
MindTree 22 27 31 25 36
L & t Infotech 47 42 47 37 37
Pledging of shares is one of the options that is available with the promoters of companies to secure
loans to meet working capital requirements, personal needs and helps to fund other ventures or
acquisitions. A promoter shareholding in a company can be used as collateral to avail a loan.
Pledged
%
TCS 0.47
Infosys 0
Wipro 0
HCL
Tech 0
Tech
Mahindra 0
25
Institutional Investor Ownership Percentage
Institutional Ownership Percentage is the percentage of shares outstanding that is owned by financial
institutions. These institutions can be banks, funds, large holdings companies, etc.
Institutional Holdings as a % of
Free Float
(FII+DII as a
% of Free-
Float)
TCS 84.54
Infosys 64.1
Wipro 57
HCL
Tech 87.5
Tech
Mahindra 82.1
EV/EBITDA
TCS 25.39
Infosys 20.54
Wipro 19.59
HCL Tech 16.03
Tech
Mahindra 15.05
EV/EBITDA is a ratio that helps to compare a company’s Enterprise Value (EV) with its Earnings
Before Interest, Taxes, Depreciation & Amortization (EBITDA). The EV/EBITDA ratio is
commonly used valuation metric helping in comparison of the relative value of different businesses.
26
5-points Analysis
Employee attrition can be defined as the unpredictable, uncontrollable reduction of the workforce due
to , retirement, sickness, resignations or death. This however can be considered as normal. The
employee attrition rate measures the quantum of people who move out of a company and are not
replaced.
27
Employee cost as % of Net Sales
2020 2021
TCS 55.8 54.1
Infosys 54.4 54.9
HCL Techn. 48.9 55.3
Tech Mahindra 51.5 48.3
Wipro Ltd 52.8 53
28
Employee utilization calculates the amount of working time for an employee that can be used for
billable work. Employee utilization rate is the percentage of total working hours that can be billed in
comparison to administrative tasks
EMPLOYEE
UTILIZATION
RATE
2019 2020 2021
Infosys 84.3 84 84.7
Tech Mahindra 81 80 87
MindTree 71.29 76.6 80.4
29
L & t Infotech 80.6 79.5 80.5
Employe
Metrics-Net
Addition(2021)
Employe Net Addition as a % Total
Net Addition Base Base
30
TCS 19388 488649 3.96
Infosys 10307 259619 3.96
Wipro 7404 197712 3.74
HCL Tech 9294 168977 5.5
Tech
Mahindra -847 121054 -0.7
Clients Metrics(2021
50 Mn $ 100 Mn $
TCS 101 48
Infosys 59 23
Wipro 41 13
Technical analysis is basically a tool that predicts the probable future price movement of a
any currency pair or stock that is based upon market data.
The collective actions of buying and selling of all the participants in the market accurately
reflects all relevant information that is any which way related to a traded security, and thus
allowing a fair market value to the security to be continually allotted,is the theory behind the
validity of technical analysis is the notion.
TCS:
During the period of 2018 to Oct,2019,the stock seems to be overbought a a few times as it crossed
80 however after that it reversed back an remained consolidated till March 2020.Heavy downtrend
can be seen after that due to Covid-19 circumstances.
32
HCL:
The stock of HCL saw huge fluctuations in prices with an overbought and oversold situation arising
many times from the period of 2017 to 2020.
Infosys
Tech -Mahindra
33
Wipro
34
MACD can be calculated by using short cycle 12, long cycle 26 and
signal period 9. MACD is made up of 3 parameters first is signal line second is MACD line
and third is histogram.
Signal line is simple and slow line shows 9 days simple moving average. MACD line is the
average difference of 26 and 12 days moving average. And histogram is the numbers which
is shown in the MACD graph. IT basically has two types of values that is positive and
negative, if value is positive it shows positive strength and if the value is negative then the
strength is negative.
HCL:
TCS
35
Tech Mahindra
Wipro
Infosys
Bollinger bands helps to determine whether prices are high or low. They are used
in pairs with a moving average. Further, the pair of bands is not intended to be
used on its own.
It is the sum of the price multiplied by volume and divided by total volume. We need to use
less than 1day candle for vwap .
TCS
37
TECH MAHINDRA
Mind tree
38
39
Chapter 4
Results & Findings, Conclusions
• Attrition rate: Lesser the better, TCS has lowest attrition rate followed by HCL Tech.
• Free cash flow as% of Net profit-Highest is Tech Mahindra.
• Even though TCS is an established company having market cap much higher than HCL,HCL
seems to be working much more efficiently. However concluding the Fundamental analysis,
TCS has performed very well since the last few years even after considering Covid-19
situations.
• Employee Metric:
Net addition-Highest done by TCS. However highest % has been employed by HCL. Gross
Utilization- TCS and HCL have not provided, so highest is Tech Mahindra
40
• Technical analysis is an important tool that helps us analyze the stock leading to
decide whether to we buy or sell . Different indicators like RSI, Bollinger band,
VWAP and MACD have been used in this project. From the RSI analysis we
conclude that the RSI TCS has remained sideways for a period of over 1 year from
2018-2020 January. However a strong movement has been noticed after March
2020,with a great bounce back., And the other stocks are observed to be in neutral
condition neither in overbought nor in oversold zone.
41
BIBLIOLOGY/ WEBLIOLOGY
• https://groww.in/blog/it-sector-performance-over-the-year-revival-sector-funds/
• https://www.dfat.gov.au/geo/india/ies/chapter-10.html
• https://statisticstimes.com/economy/country/india-gdp-sectorwise.php
• https://www-crisilresearch-com-cimr.knimbus.com/#/industry/itenableservice/dashboard
• https://www-crisilresearch-com-cimr.knimbus.com/#/industry/itenableservice/ourview
• https://www.equitymaster.com/research-it/sector-info/software/Software-Sector-
Analysis-Report.asp
• https://www1.nseindia.com/products/content/equities/indices/sectoral_indices.htm
• https://www.edelweiss.in/investology/technical-analysis-2c8d50/what-is-technical-
analysis-in-stock-market-670e0f
• https://www2.deloitte.com/in/en/pages/industries/articles/india-services-sector.html
• https://shodhganga.inflibnet.ac.in/bitstream/10603/201913/11/11_chapter%204.pdf
• rbidocs.rbi.org.in
• https://www.edelweiss.in/investology/technical-analysis-2c8d50/what-is-technical-
analysis-in-stock-market-670e0f
• www.indiabudget.gov.in
• https://business.mapsofindia.com/sectors/financial/analysis.html
• https://www.investindia.gov.in/sector/it-bpm
42
43
44