group 14_section e_cf-pre-classassignment.pdf
DESCRIPTION
Group 14_Section E_CF-Pre-ClassAssignment.pdfTRANSCRIPT
Corporate Finance
Pre-Class Assignment
Submitted To: Dr. Kulbir Singh
Submitted By: Section - E
Group: 14
Unnati Gupta – 2014312
Vaibhav Gupta- 2014313
Vaibhav Jain- 2014314
Task #1. Find the following in India (as 31st
March, 2014):
i. Number of public limited companies : 2678
ii. Number of Private Limited firms: 23302
iii. Number of Public Sector Enterprises (incld. State Govt, and Semi-PSE) :
iv. Number of Foreign companies (registered and operating in India, incld. : 3138
MNC)
Task #2. Find the number of
A. Public Ltd. companies/firms formed/registered since a. Year 1995
b. Year 2000- c. Year 2005 d. Year 2010
B. Private Ltd. companies/firms formed/registered since a. Year 1995- 59,117
b. Year 2000- 31,496 c. Year 2005- 51,448 d. Year 2010- 86,854
Task #3. Find the number of public ltd. Firms registered at *as on 31st
March, 2014
1995 2000 2005 2010 2014*
BSE 2729 1010 2407 2639 2272
NSE
Task #4. Find the number of public ltd. Firms de-listed from
*as on 31st
March, 2014
1995 2000 2005 2010 2014* Total
BSE 91 32 15
NSE
Task #5. Find the number of firms in each of the industry in India.
Industry
1995
2000
2005
2010
At
Present
Total
MANUFACTURING (Non-Financial)
Food & Agro-based Products 209 76 135 86 55 561
Textiles 193 37 179 75 13 499
Chemicals & Chemical Products 1 1 3 7 28 40
Consumer Goods 5 5 5 5 5
Construction Materials 1 0 1 26 20 `
Metals and Metal Products
Machinery
Transport Equipment
Misc. Manufacturing
56
47
63
71
52
MINING
Coal & lignite 5 5 5 5 5
Crude Oil & Natural Gas
1
3
3
4
5
Minerals 13 -7 0 10 0 16
ELECTRICITY
Electricity Generation 12 0 1 5 4 22
Electricity distribution 0 0 0 1 0 1
SERVICES (OTHER THAN FINANCIAL)
Hotel & tourism 17 7 6 7 -2 35
Wholesale & retail trading 100 -31 60 64 -11 182
Transport services 17 0 11 13 -5 36
Communication Services 1 5 5 7 -2 16
Information Technology 16 101 42 24 -55 128
Misc. Services 25 37 46 52 -24 136
CONSTRUCTION & REAL ESTATE
FINANCIAL SERVICES 655 1664 3761 5937 1716 13733
Banking Services 77 149 141 112 97 576
Investment Services 2 NA
Asset Financing Services 265 421 671 1140 1069 3566
Auto Finance services 5 8 12 13 9 47
Housing Finance services 18 34 41 55 30 178
Infrastructure Finance services 4 5 7 11 13 40
Other Asset Financing services 238 374 611 1061 1010 3294
Other Fund based financial services 112 522 1379 2029 506 4548
FEES BASED FINANCIAL SERVICES 11 90 252 438 274 1065
Securities Broking 4 64 137 213 103 521
Other Fee based financial services
Other Financial Services
IRRIGATION
Task #6. Find the following ten statistics for following industries in India.
1. Sales
2. PAT 3. Interest Expense
Industry 1995 2000 2005 2010 2014 1995 2000 2005 2010 2014 1995 2000 2005 2010 2014
MANUFACTURING (Non-
Financial)6
Food & Agro-based Products
413336.30
664770.0
8
1368089.
43
315413
1.43
Textiles
Chemicals & Chemical Products
Consumer Goods
224312.08
327688.2
2
804836.5
5
174790
3.67 10498.35 11508.17 42666.88 84919.35
6201.9
8
12431.
80
11300.
02
28089.
70
Construction Materials
175196.97
263217.3
8
544345.8
3
122090
3.40 11434.20 -1328.58 40390.58 83145.93
12328.
13
22661.
29
16615.
41
30753.
18
Metals and Metal Products
514891.55
915714.3
8
2233659.
00
473119
3.13 31924.49
-
24403.84
176165.3
3
324779.4
5
31563.
53
80994.
38
62743.
98
155893
.69
Machinery
455,870,11
607107.4
5
933007.9
1
225375
7.31 17117.38 4295.57 34527.88
183966.7
4
26484.
12
29638.
08
20140.
90
42889.
37
Transport Equipment
386038.49
789203.4
8
1716553.
10
413932
4.61 23409.79 -5501.55
103686.6
7
250047.0
9
19902.
15
27681.
05
14930.
90
56170.
81
Misc. Manufacturing
106548.19
190689.2
1
327433.1
7
534929
.35 221.00 262.00 875.00 1441.00
6076.7
5
13589.
67
10536.
67
22138.
09
MINING
Coal & lignite
38973.19 240660.5
414894.2
3
782615
.7 N.A. -3125.49 -16860.2 62607 110336.4 N.A.
9876.6
1 6418.2 3509.2
4198.9
6 N.A.
Crude Oil & Natural Gas
143759.7 270942.4 558064
881064
.7 N.A. 21532.4 57714.1 162332.6 241052.4 N.A. 9979.2 5966.1 631.4 2523.6 N.A.
Minerals
29366.1 37762.51
149906.2
6
429292
.67 N.A. 2665.7 2129.53 44373.94 146874.6 N.A. 1137.4
2005.4
3
1660.6
4
6711.0
3 N.A.
ELECTRICITY
Electricity Generation
260933.86
455448.4
7
1102656.
51
222973
9.87 N.A. 29371.89 68287.19 79204.02 164655.9 N.A.
32589.
79
42770.
65
82593.
25
158493
.3 N.A.
Electricity distribution
9700.9 25439.4
560020.3
2
186790
7.5 N.A. 2759.5 7440 829.01 -217360 N.A. 1553.8 5393.2
32898.
44
130715
.1 N.A.
SERVICES (OTHER THAN
FINANCIAL)
Hotel & tourism
26489.3
3630018.
5 82072.77
136183
.56 N.A. 6704.8 2435.17 11303.03 10236.77 N.A. 1439.2
3024.8
3
5184.7
7
10769.
61 N.A.
Wholesale & retail trading
568742.2
878748.8
9
2413985.
88
541471
1.24 N.A. 7601.28 -67.35 20097.29 40738.91 N.A.
23542.
15
38372.
79
50965.
28
101781
.8 N.A.
Transport services
142710.11
281861.1
2
640101.2
9
142113
9.42 8224.8 7206.99 73320.42 -35317.5 9134.9
14441.
17
19463.
13
115229
.25
Communication Services
75034.56
1462791.
1
686294.8
3
172338
1.38 8904.14 4150.7 116198.1 15983.08
9853.9
4 8675.1
17465.
63
95375.
68
Information Technology
14277.5
119173.4
5
529875.7
3
147169
9.47
2441253.3
8 2913.7 28284.12 97791.53 279107.6 480983.7 551.4
2905.3
5
2546.3
2
18371.
91 19498.11
Misc. Services
2541.09 36851.56 31681.39
127062
.63 5094.05 13449.1 11009.46 23362.32 2030.3
8061.8
3
11253.
95
53635.
71
CONSTRUCTION & REAL
ESTATE
32978.
31
20586.
08
13649.
53
99646.
75
3333.7
5
6240.7
9
21309.
11
20334
0.6
4166.1
3
9730.9
9
18644.
83
15425
6.63
FINANCIAL SERVICES
Banking Services 43646
1.18
11662
38.67
18582
49.82
49465
71.93
96393
74.2
21132.
28
74031.
4
21079
2.1
57720
9.8
81942
9
24416
7.13
70698
6.37
88534
3.55
27596
92.5
58289
30.8
Investment Services 19.8 15.1 0.9
Asset Financing Services 20969
1.47
46056
0.38
45247
4.03
10068
14.11
48137.
12
56025.
21
59905.
27
17189
6.2
12086
8.53
29127
4.67
28351
1
56062
4.33
Auto Finance services
4657.1
10882.
87
17471.
9
92088.
8
20469
3.6 844.7 1043.4 2850.1
15623.
1
31429.
5 2032.9
4757.6
7 6901.4
39803.
8
96942.
3
Housing Finance services
15802
32521.
43
67886.
5
22381
9.7
54090
5.4 2697.2
5619.9
7
13736.
8
46059.
2
10317
1
11156.
9
23090.
53
43570.
8
13994
5.1
36277
9.9 Infrastructure Finance
services
8.18 10.04 8.04 27.71 41.62 27.08 0 38.35 16,20
0
43,37
0
55,93
3
139,8
62
Other Asset Financing services 31.84 8.77 -3.13 4.05 74.62 -4.20 -17.82 -73.27 22.12 8.13 -4.96 -2.84
Other Fund based financial
services
71.74 49.89 1.65 6.21 103.7
7
122.8
7
0.46 9.45 19.79 17.07 -6.59 5.03
FEES BASED FINANCIAL
SERVICES
Securities Broking
Other Fee based financial
services
Other Financial Services
IRRIGATION
4. Borrowings 5. Investments 7. Taxes
Industry 1995 2000 2005 2010 2014 1995 2000 2005 2010 2014 1995 2000 2005 2010 2014
MANUFACTURING (Non-Financial)
Food & Agro-based Products
Textiles
Chemicals & Chemical Products
Consumer Goods
50955.20 70876.50 194994.00 591461.40 8849.60 21030.30
68729.
80
112561
.20
14584.
83
28153.
85
46329.
60
87733.
35
Construction Materials
262347.00 10003.60 23382.00
44928.
10
177080
.70
21998.
48
40733.
02
59968.
27
128247
.42
Metals and Metal Products
155823.80 54916.10 93221.80
167352
.60
104788
3.00
64238.
95
158712
.37
249487
.45
498558
.09
Machinery
Transport Equipment
Misc. Manufacturing
MINING
Coal & lignite
Crude Oil & Natural Gas
Minerals
ELECTRICITY
27063
4.77
48088
7.87
16626
76.83
40976
47.37
32131.
39
75727.
19
80033.
33
-
52703.
84
34143.
59
48163.
85
11549
1.69
28920
8.33
Electricity Generation 26093
3.87
45544
8.47
11026
56.51
22297
39.87
29371.
89
68287.
19
79204.
02
16465
5.91
32589.
79
42077.
65
82593.
25
15849
3.26
Electricity distribution
9700.9
0
25439.
40
56002
0.32
18679
07.50
2759.5
0
7440.0
0 829.01
-
21735
9.75
1553.8
0
5393.2
0
32898.
44
13071
5.07
SERVICES (OTHER THAN
FINANCIAL) 91534
5.47
17948
81.88
52060
53.30
11491
663.36
44099.
53
10331
6.23
32677
2.04
25343
2.24
48380.
72 0.00
13566
3.25
42512
1.90
Hotel & tourism 26498.
30
36318.
50
82072.
77
13618
3.56
6704.8
0
2435.1
7
10236.
77
10236.
77
1439.2
0
3024.8
3
5184.7
7
10769.
61
Wholesale & retail trading 56874
2.20
87874
8.89
24139
85.88
54147
11.24
7601.2
8 -67.35
20097.
29
40738.
91
23542.
15
38372.
79
50965.
28
10178
1.80
Transport services 17470
9.08
36771
2.10
80474
9.63
16556
41.96
10060.
78
15452.
47
72690.
66
4806.2
5
10382.
33
18815.
80
26739.
35
12840
1.57
Communication Services 89369. 16755 83837 18635 11064. 21864. 83769. - 10275. 8250.5 28504. 11036
08 3.77 2.14 89.65 30 37 48 12654
9.75
06 0 28 5.02
Information Technology 14,277.
50
2,22,04
1.68
5,29,87
5.73
16,64,5
75.77
3,590.1
6
49,888.
54 98,803.
39
3,04,24
3.78
1,174.1
6
4,352.5
8
2,803.6
3
18,371.
91
Misc. Services 34,108.
82
1,22,50
6.94
5,28,88
8.68
6,75,14
9
4,741.3
1
11,985.
92
6,688.4
3
10,250.
75
1,567.8
2
8,774.4
2
11,253.
95
57,305.
73
CONSTRUCTION & REAL
ESTATE
72,993.
60
1,71,54
4.04
5,31,08
7.94 28,52,0
36.72
2,005.8
1
4,876.9
1
17,740.
83
1,97,71
4
5,636.0
9 9,85.84
18,644.
43
1,54,25
6.63
FINANCIAL SERVICES 9,49,39
5.07
18,85,7
71.64
29,45,8
42.03 74,20,7
71.66
73,761.
01
86,450.
14 4,90,74
8.89 1,101,23
.36 5,40,66
6.85
11,50,7
76.10 13,67,1
47.88
37,86,0
88.80
Banking Services 6,35,95
4.40 13,24,4
69.60
21,41,8
09.50 57,31,0
93.50 11,612.
26
66,041.
40 2,45,27
4.90 7,06,220
.60 3,65,38
9
7,94,22
8.90
10,38,7
58 30,38,4
60.60
Investment Services
Asset Financing Services
Auto Finance services 539,06
9.00
994,52
6.80
1,809.
70
3,464.
00
8,830.
10
54,408
.00
54,676
.40
252.16
669.57
1,876.
10
11,883
.90
15,870
.40
Housing Finance services - 53.40
1.25
-8.53
31.2
2.85
15.02
526.5
1,521.
20
5,700.
20
24,096
.30
42,355
.90
Infrastructure Finance
services
2,505,
474.40
- 16,283
.50
62,557
.90
70,858
.00
215,52
8.00
- 1,427.
10
4,011.
50
8,044.
70
26,361
.50
-
Other Asset Financing services 2,804,
130.60
- 135,55
2.30
389,57
2.80
572,84
2.60
804,02
6.80
- 6,528.
09
7,637.
26
1,8100
.50
3,5615
.95
-
Other Fund based financial
services
- - - 397,56
7.40
557,68
6.30
27,859
.60
212,99
6.80
595,72
6.50
17290
80.30
557,68
6.30
217.84 717.40 5217.2
9
16832.
27
14743.
07
FEES BASED FINANCIAL
SERVICES
Securities Broking - - - 26,32
7.00
- 479.9
0
2456.
10
4484.
90
45554 - 12.48 654 5273.
90
7438.
20
-
Other Fee based financial
services
- - - 66,09
6.40
- 1,497.
20
3,627.
20
45,96
2.50
82,82
3.20
- 3.10 11.20 3,452
5.54
7,587.
60
-
Other Financial Services - - - 382,51
0.40
- 27,778
.70
57,360
.10
277,32
2.60
604,80
3.60
- 604.41
955.63
3,574.
62
11,869
.28
-
IRRIGATION
346.7 753.01 547.7 1471.6 2823 -0.2 -28
-
10250.
9 -623 -310 9.8 4283 347 657
8. D/E Ratio 9. ROI 10. ROE
Industry 1995 2000 2005 2010 2014 1995 2000 2005 2010 2014 1995 2000 2005 2010 2014
MANUFACTURING (Non-
Financial)
Food & Agro-based Products 1.11 1.41 1.13 1.19 1.02 4.97 2.26 7.37 6.23 6.99 17.08 16.2 29.06 22.09 23.42
Textiles 1.68 15.15 14.44 2.03 1.89 1.7 -7.43 -0.77 3.33 0.65 14.66 -64.54 39.53 15.64 3.23
Chemicals & Chemical Products 1.22 1.45 0.91 0.8 0.84 6.24 3.62 8.24 7.66 5.09 16.37 8.5 17.87 18 10.47
Consumer Goods 0.83 0.99 0.96 0.87 0.93 7.3 4.12 8.82 9.48 7.48 16.55 10.36 21.15 18.87 15.66
Construction Materials 1.49 4.91 11.52 0.68 0.68 6.74 -0.48 9.91 7.52 8.53 17.26 -1.79 27.74 12.64 14.31
Metals and Metal Products 1.37 2.25 1.37 0.94 1.1 5.26 -2.11 10.69 5.76 2.66 12.75 -7.65 26.76 11.16 5.39
Machinery 1.23 1.18 0.75 0.5 0.53 3.75 2.78 12.33 13.12 10.81 8.22 -6.09 17.69 15.23 6.67
Transport Equipment 1.37 1.4 0.68 0.63 0.62 7.95 3.29 12.61 10.95 8.35 36.95 22.91 36.73 32.47 24.85
Misc. Manufacturing 1.21 1.89 1.43 0.97 0.99 7.13 -0.74 4.06 2.86 -0.7 23.3 17.12 24.61 14.81 6.63
MINING
Coal & lignite 1.12 1.56 1.01 0.42 0.31 1.55 40.01 82.36 79.81 74.63 -1.98 -11.24 20.28 34.78 38.86
Crude Oil & Natural Gas 0.63 0.27 0.14 0.19 0.11 29.0 35.93 45.48 42.52 38.6 6.92 10.9 28.45 16.86 20.1
Minerals 0.53 0.65 0.21 0.2 0.56 15.41 12.59 47.91 25.76 13.66 5.46 2.36 34.39 19.89 9.72
ELECTRICITY
Electricity Generation 1.05 0.88 0.99 1.02 1.27 15.84 21.7 12.85 10.8 11.16 3.3 5.34 2.98 2.47 2.13
Electricity distribution 0.91 1.23 2.24 2.53 61.26 14.4 20.15 22.7 6.72 -
122.6
4
3.19 4.74 5.31 -4.79 -17.33
SERVICES (OTHER THAN
FINANCIAL)
1.82 1.8 1.06 1.94 2.82 32.52 30.91 32.71 13.55 10.99 3.36 1.66 7.31 -0.97 -2.54
Hotel & tourism 0.59 0.76 1.51 1.04 0.99 32.34 12.74 19.73 11.09 5.74 15.14 4.16 2.68 2.61 -1.27
Wholesale & retail trading 2.27 2.82 3.4 2.05 1.87 7.2 3.01 14.09 7.76 4.88 4.14 -0.3 2.31 0.38 0.48
Transport services
Communication Services 2.20 0.62 0.49 0.62 1.21 6.83 1.21 5.78 0.28 -3.32 32.57 3.15 29.01 0.64 -10.00
Information Technology 0.4 0.19 0.12 0.23 0.14 17.44 9.10 18.20 14.04 16.87 33.06 3.15 29.01 0.64 -10.00
Misc. Services 1.22 0.51 1.03 0.60 0.63 8.81 5.38 2.15 0.79 0.16 24.66 3.95 6.45 1.68 0.33
CONSTRUCTION & REAL
ESTATE
FINANCIAL SERVICES
Banking Services 0.6051
647
1.0846
91
0.5963
27
0.8567
35
0.54 0.71 0.98 1.02 0.79 13.31 14.90 16.84 15.19 11.30
Investment Services
1.7374
29
0.52 0.86
Asset Financing Services 0.7713 0.8040 1.335 0.9553 3.01 1.55 1.11 1.63 1.87 15.97 7.7 6.32 8.53 11.54
391 2 62
Auto Finance services 4.08 1.87 2.30 2.68 2.43 33.83 11.36 17.09 22.22 17.10
Housing Finance services 2.32 2.40 1.70 2.34 2.18 17.69 17.26 17.09 20.59 19.93
Infrastructure Finance
services 5.4509
747
5.2800
96
1.1029
25
6.1537
24
2.46 1.96 2.35 2.98 2.73 13.33 12.46 23.52 18.63 17.84
Other Asset Financing
services
NA NA NA NA NA 16.11 1.4 0.61 0.76 NA 3.15 6.26 2.84 3.18 NA
Other Fund based financial
services
NA NA NA NA NA 9.49 3.38 6.33 4.74 NA 21.39 6.59 12.55 8.26 NA
FEES BASED FINANCIAL
SERVICES
Securities Broking NA NA NA NA NA 16.45 7.94 8.7 5.88 NA 44.72 22.63 29.08 16.58 NA
Other Fee based financial
services
NA NA NA NA NA 16.57 9.12 9.26 5.49 NA 31.85 14.89 17.46 9.85 NA
Other Financial Services NA NA NA NA NA 6.06 0.73 3.18 1.52 NA 21.49 3.79 13.6 3.7 NA
IRRIGATION NA NA NA NA NA NA -0.08 -0.05 -0.09 NA NA 0-.14 -0.1 -0.13 NA
Task #7. Collect the following statistics for the Firms in India
* starting from 31st
March, 2014
Last 05 years* Last 10 years Last 20 years
Public
Ltd.
Private
Ltd.
Public
Sector
Public
Ltd.
Private
Ltd.
Public
Sector
Public
Ltd.
Private
Ltd.
Public
Sector
Sales Revenue
PAT
Taxes Paid
Interest Expense
Dividends Paid
Buyback of Shares (amt.) - - -
Buyback of Shares (number) - - -
Average D/E ratio
Average ROI
Average ROE
Task #8. Collect the following statistics for the Public Ltd. Firms in India
* starting from 31st
March, 2014
Last 05 years* Last 10 years Last 20 years
Equity Issues (IPO/FPO/etc.)
Preference Shares
DEBT:
Debentures/Bonds, etc.
Loans (from Banks/FIs)
Foreign Markets
TOTAL
Task #9. Collect the following statistics for the firms in India
* starting from 31st
March, 2014
Investments** Last 05 years* Last 10 years Last 20 years
Public Ltd.
Private Ltd.
Public Sector
TOTAL
**Projects, Plant & Mach., etc., not financial investment in stock market, etc.
Task #10. Find out number of business groups operating in India (at present). Name at least 20 of them.
Task #11. Find out the following statistics for business groups operating in India.
Ranking by Sales Revenue
Rank
1995 2000 20
05
2010 At Present
Name
of
Group
Amt. (Rs.)
Name
of
Group
Amt. (Rs.)
Name
of
Group
Amt.
(Rs.)
Name
of
Group
Amt. (Rs.)
Name
of
Group
Amt. (Rs.)
1 Reliance 74668.23 Reliance 203627 Indian Oil Corp 499720
2 TCS Infosys 22426 Reliance Industries 443461 3
Infosys TCS 23449
Bharat Petroleum
Corp 265806 4
Wipro Bharti Airtel 36838
Hindustan Petroleum
Corp 235518 5 Bharti Airtel ITC 27061 Tata Motors 233662 6 ITC L&T 39639 State Bank Of India 226945 7
ICICI Bank 34002
Oil and Nature Gas
Corp 181409 8 ICICI Bank Wipro 23929 tata Steel 149149 9 HDFC & HDFC
Bank 31604 Essar Oil 99473 10 JSPL (Jindal Steel
and Power) 8148 Hindalco Industries 88713
Ranking by Profit After Tax
Rank
1995 2000 2005 201
0
At Present
Name
of
Group
Amt. (Rs.)
Name
of
Group
Amt. (Rs.)
Name
of
Group
Amt. (Rs.)
Name
of
Group
Amt. (Rs.)
Name
of
Group
Amt. (Rs.)
1
2
…
…
10
Task #12. Using RBI’s website and other GoI’s websites, collect the following data:
1995 2000 2005 2010 2014*
Tax Collection
Borrowings
Expenditure of the Govt.
TOTAL
Task #13. Using RBI’s website, collect the following data (average):
1995 2000 2005 2010 2014*
Bank Rate - 8 6 - 9
Repo Rate - - 6.25 6.25 8
Reverse Repo Rate - - 5.25 5.25 7
Task #14. Using BSE and NSE websites, collect the following data:
Index Value (yearly) 1995 2000 2005 2010 2014*
BSE Sensex 3,110.49 3,972.12 9,397.93 20,509.09 26,492.51
S&P BSE Mid Cap 4,427.03 7,802.71 9,659.31
S&P BSE Small Cap 5,943.11 9,670.31 10,796.31
CNX Nifty 908.53 1263.55 2836.55 6134.5 7932.9
CNX Midcap
- - 4030.45 8857.2
11503.5
5
CNX Small Cap - - 2187.64 4101.01 5127.5
Task #15. Find out ownership data in public limited firms in India (use Prowess/ Capitaline)
(Percentage) 1995 2000 2005 2010 2014*
Promoters
Banks/FIs/Insurance Cos.
Mutual Funds/UTI
Foreign Institutional Investors (FIIs)
Other Institutions (VC, etc.)
Public
******* END *******