Our Topic

Pick any 30 listed large cap company from

BSE and collect the profit for the financial
year 2017-18, Do some statistical analysis
to derive meaning information from the
data set.

Submitted To
Name Roll No.
Submitted To Akber Alam : GM18015
Mr. Anand Sir Akarshi Agarwal : GM18012
Aditi Agarwal : GM18010
Aadil Siddiqui : GM18009
Akash Srivastava : GM18014
Raunak Ranjn : GM18296
 Market Cap
It means Market Capitalization

 Market Cap:
Market capitalization is the aggregate valuation of the company based
on its current share price and the total number of outstanding stocks. It is calculated by
multiplying the current market price of the company's share with the total outstanding
shares of the company.

 Description:
Market capitalization is one of the most important characteristics that
helps the investor determine the returns and the risk in the share. It also helps the
investors choose the stock that can meet their risk and diversification criterion.
 How to compute Market Cap.
Market Cap = Market price of 1 share * No. of outstanding shares
Suppose
XYZ Pvt. Ltd is a company

It’s Price of one share = Rs 1,000

And It’s outstanding shares = 1,00,000

Market Capitalization =
1000 * 1,00,000 = 10,00,00,000
 Types of Stock Market Capitalization

The Company whose Market The Company whose The Company whose Market
Cap. Is more than 75,000 crores Market Cap. Is more than Cap. Is less than 13,000 crores
is called a Large Cap. 13,000 to 75,000 crores is called Mid Cap.
is called Mid Cap.
 Data Analysis

Name of Company Industry Type Market Cap. Net Profit in Crore (2016-17) Net Profit in Crore (2017-18) Growth Rate

HDFC Banking 5,50,915.33 14,549.64 17,486.73 20.2%

-
SBI Banking 2,59,170.02 10,484.00 6,547.45 -162.5%

Kotak Mahendra Banking 2,36,196.74 3,411.50 4,084.30 19.7%

ICICI Banking 2,11,139.74 90,801.09 6,777.42 -92.5%

Axis Bank Banking 1,63,442.48 3,679.28 275.68 -92.5%

-
Bank of Barodra Banking 35,595.42 1,383.14 2,431.81 -275.8%
 Cont…
Data Analysis

Name of Company Industry Type Market Cap. Net Profit in Crore (2016-17) Net Profit in Crore (2017-18) Growth Rate

Nestle FMCG 99,708.31 926.53 1,225.19 32.2%

Britannia FMCG 73,840.20 1,251.16 1,445.20 15.5%

Dabour India FMCG 82,555.20 998.33 1,072.03 7.4%

Marico FMCG 44,663.91 842.70 718.23 -14.8%

Havells India FMCG 41,159.29 539.04 712.52 32.2%

 Cont…
Data Analysis
Name of Company Industry Type Market Cap. Net Profit in Crore (2016-17) Net Profit in Crore (2017-18) Growth Rate

Relaince IT 7,94,079.81 31,425.00 33,612.00 7.0%

TCS IT 7,89,949.92 23,653.00 25,241.00 6.7%

ITC IT 3,75,441.05 10,200.90 11,223.25 10.0%

HUL IT 3,52,869.55 4,490.00 5,237.00 16.6%

Infosys IT 3,21,163.52 13,818.00 16,155.00 16.9%

Wipro IT 1,49,361.42 8,161.70 7,722.80 -5.4%

Tech Mahendra IT 7,45,571.59 3,047.30 3,999.30 31.2%

 Cont…
Data Analysis
Name of Company Industry Type Market Cap. Net Profit in Crore (2016-17) Net Profit in Crore (2017-18) Growth Rate
Tata Steel Other 74,055.49 3,444.51 4,169.55 21.0%

Cipla Other 53,648.31 974.94 1,468.52 50.6%

Bhartiya Airtel Other 1,53,360.26 -9,925.60 7,920.00 -179.8%

NTPC Other 14,295.63 9,835.26 10,343.41 5.2%

Vedanta Other 87,359.98 11,069.00 7,256.00 -34.4%

Ambuja Cement Other 45,481.20 932.24 1,249.57 34.0%

HPCL Other 3,846.28 6,208.80 2,357.07 -62.0%

DLF Other 37,328.11 596.56 361.20 -39.5%

SAIL Other 32,073.53 -2,833.24 -481.71 -83.0%

Hindustan Aron Other 31,049.53 2,070.40 2,615.00 26.3%

ABB India Other 3,066.08 376.25 419.95 11.6%

 Data Analysis as Bar Chart

30 Companies Net profit of the year 2016-17

 Data Analysis as Bar Chart

30 Companies Net profit of the year 2017-18

 Data Analysis of Banking Industry as Bar Chart

Net profit for the year 2016-17 Net profit for the year 2017-18
100,000.00 120.0% 20,000.00 160.0%
144.3% 145.7%
90,000.00 98.9% 100.0% 133.3%
96.1% 140.0%
93.2% 100.0% 15,000.00
80,000.00 123.5%
84.7%
120.0%
70,000.00
73.0% 80.0% 100.0%
10,000.00
60,000.00 89.0% 100.0%

50,000.00 60.0%
5,000.00 80.0%
40,000.00
40.0% 60.0%
30,000.00
-
20,000.00 HDFC ICICI Kotak Axis Bank Bank of SBI 40.0%
20.0%
Mahendra Barodra
10,000.00 -5,000.00
20.0%
- 0.0%
ICICI HDFC SBI Axis Bank Kotak Bank of -10,000.00 0.0%
Mahendra Barodra
 Data Analysis of FMCG Industry as Bar Chart

Net profit for the year 2016-17 Net profit for the year 2017-18
1,600.00 120.0%
1,400.00 120.0%

100.0% 100.0%
1,400.00
1,200.00 100.0%
100.0%
88.2% 86.2%
1,200.00
1,000.00
80.0% 72.3% 80.0%
69.7% 1,000.00
800.00
49.4% 60.0% Net Profit in Crore 800.00 51.6% 60.0% Net Profit in Crore
600.00 (2016-17) (2017-18)
600.00
40.0% Percentage 40.0% Percentage
400.00 27.5% 27.9%
400.00
20.0% 20.0%
200.00
200.00

- 0.0%
- 0.0%
 Data Analysis of IT Industry as Bar Chart

Net profit for the year 2016-17 Net profit for the year 2017-18
35,000.00 120.0% 40,000.00 120.0%
100.0% 100.0%
30,000.00 96.8% 35,000.00 96.1%
92.0% 100.0% 91.0% 100.0%
83.4% 30,000.00 83.6%
25,000.00
72.7% 80.0% 72.7% 80.0%
25,000.00
20,000.00 58.1% 57.0%
60.0% 20,000.00 60.0%
Net Profit in Crore Net Profit in Crore
15,000.00
(2016-17) (2017-18)
33.2% 40.0% 15,000.00
32.6% 40.0%
10,000.00 Percentage Percentage
10,000.00
5,000.00 20.0% 20.0%
5,000.00

- 0.0%
- 0.0%
 Data Analysis of Other Industry as Bar Chart

Net profit for the year 2016-17 Net profit for the year 2017-18
15,000.00 180.0%
12,000.00 120.0%
156.1%
154.4%
151.8% 160.0% 101.3%
99.2%100.3% 100.0%
147.7% 10,000.00 95.9%
10,000.00 143.4% 143.6% 92.0% 100.0%
134.3% 85.7%
140.0%
8,000.00 78.8%
119.2% 80.0%
5,000.00 120.0% 67.7%
100.0% 6,000.00
91.9% 100.0% 60.0%
48.5%
- 4,000.00
80.0%
40.0%
2,000.00 27.5%
-5,000.00 48.7% 60.0%
20.0%
-
40.0%
-10,000.00
-2,000.00 0.0%
20.0%

-15,000.00 0.0%
 Data Analysis of Industry wise as Table

Industry Type Market Cap. Net Profit in Crore (2016-17) Net Profit in Crore (2017-18) Growth Rate

Banking 1456459.73 124308.65 19644.87 -84%

FMCG 341926.91 4557.76 5173.17 14%

IT 3528436.86 94795.9 103190.35 9%

Others 535564.4 22749.12 37678.56 66%

Growth Rate Analysis of Industry wise as Pie Chart

Growth Rate

66%

Banking

FMCG
-84%
IT

Others

9%

14%

16
Thank You