Project of ITC LTD
Project of ITC LTD
Project of ITC LTD
Of
ITC Limited
A
Project Report
Presented to
(Roll No.42)
1
EXECUTIVE SUMMERY
Our Financial Analysis project is on ITC Limited Main Object of
this project is to
know the financial strengths and
weaknesses of ITC Limited. For that we had
references the five
conclusive years annual reports from 2010 to 2014. In addition to
these annual report of ITC Ltd. I had also used books and various
web based information to cover the current trends of the
company and its competitors, as well as whole industry. To
analyze the firm, we have used various calculation based ratios
and also study some other statements like Balance Sheet, P &L
Account, DU Pont chart etc.
We are analyzing the annual report of ITC Limited For last five
years. The project presents the details of financial position of
company. We are required to prepare this project report to
develop the financial analysis and interpretation skill. The project
enables us interact with the Real Corporation, real economy and
real words problem.
Mere a study of annual report doesnt provide full information of
firm. Comprehensive study of various financial aspects requires
covering other statement also. The purpose of annual report is to
shareholders, investors and creditors only. It doesnt focus on
internal accounting and situation business.
A prospective managers work is to get data, pit them in to logical
order, analyze and derive correct decision from the data. So a
potential manager must have an ability to analyze, interpret and
derived optimal solution of the problem. To prepare various
statements do not mean we are on path but the task is to decision
making and forward.
PREFACE
We had decided to prepare the project report on ITC
Limited Under the subject of managerial Accounting.
By preparing the project report we can understand the
original scenario. Generally we have prepared this project
report purely based on annual report of company.
The following report by our sincere effort including all the possible
aspect
of
TLC
Limited
Company,
we
invite
helpful
recommendations or suggestions that well further enrich our
knowledge regarding the subject.
AKNOWLEDGEMENT
Quality is never as Accident ........... At this moment of us
substantial enhancemant, we hardly inough words to express our
gratitude towards those who were constantly involve with us
during this project. With a sence who provid halp and guidance to
make thi project successfuly.
First of all, our heartfelt thank to Dr.Ashawin Modi, who helped us
in every possible manner .He ensured a proper environment to
work in. He allowed complete freedon to complete our work. He
also ensured that we meet all those people who could make us
understand the systen. We also thanks to all the members for
their selfless co-operation and help for complete this project. The
opportunity to study and work here added a lot of knowledge,
experience and confidence.
From bottom of our heart we thank to all faculty members of S.K.
School of Business Management, Patan for providing
guidance and help to complete this project. We thank for their
active involvement in the project. They always with us when we
needed any type of guidance. Their guidance and inspiration
changed this project into a fruitful and meaning exercise.
At the last but not least,our special thanks also to all those whose
names have noted appeared here but whose contrivutions have
noted gone unnoticed.
CONTENTS
Sub.Poin
Ch.No t
Contents
Page No.
Executive Summary
Preface
Acknowledgement
1.1
1.2
1.3
1.4
1.5
1.6
1.7
1.8
introduction of company
History
Nature of Business
Product Profile
Background
Registrar's Directors
Board of Directors
Auditors
Share pattern
1
2
7
8
8
10
11
12
13
2.1
2.2
2.3
2.4
15
16
17
23
28
3.1
3.2
3.3
3.4
30
31
33
37
40
4.1
5.1
5.2
5.3
5.4
Ratio Analysis
Liquidity Ratio
Profitability Ratio
Assets Turn Over Ratio
Financial Struchar Ratios
45
47
51
57
65
5
5.5
6
6.1
7
8
Valuation Ration
70
75
Du Point Analysis
76
Du Point Chart
Recommendations & Suggestions 79
90
Technical Analysis
LIST OF TABLE
Sr.No Graps
Graphs
Page
6
No.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
1.8
2.1
2.2
2.3
2.4
3.1
3.2
3.3
3.4
4.1
5.1.1
5.1.2
5.1.3
5.2.1
5.2.2
5.2.3
5.2.4
5.2.5
5.3.1
5.3.2
5.3.3
5.3.4
5.3.5
5.3.5
5.4.1
5.4.2
5.4.3
5.4.4
5.5.1
5.5.2
5.5.3
5.5.4
6.1
No.
share Holding Pattern
Statement of balance Sheet
Tread Statement of Balance Sheet
Vertical Statement of Balance Sheet
Horizontal Analysis
Statement of Profit & loss Account
Tread Statement of Profit & Loss Account
Vertical Statement of Profit & loss
Account
Horizontal Statement of Profit & loss
Account
Cash flow statement
Current Ratio
Quick Ratio
Net Working Capital
Gross Profit ratio
Operating Profit Ratio
Net Profit Ratio
Rate of Return On Investment
Rate of Return On Equity
Total Assets Turn Over Ratio
Net Fixed Assets Turn Over
Inventory turn over
Average Age of Inventories
Debtors Turn Over
Average Age Of Debtors
Equity Ratio
Debt Ratio
Dept Equity Ratio
Interest Coverage Ratio
Earning Per Share(EPC)
Dividend Pay Out Ratio
Dividend Yield ratio
P/E ratio
Du Point Chart
14
16
17
23
28
31
33
37
40
42
47
49
50
51
52
53
54
56
58
59
60
60
62
63
66
67
67
69
71
71
73
74
76
Graph No.
1.8
2.1
Graph Name
Share holding pattern
Balance sheet
Page No.
14
16
7
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
2.2
2.2.1
2.2.2
2.2.3
2.2.4
2.2.6
2.3
2.4
3.1
3.2
3.2.1
3.2.2
3.2.3
3.2.4
3.3
3.3.1
3.3.2
3.3.3
3.3.4
3.4
4.1
5.1
5.1.1
5.1.2
5.1.3
5.2.1
5.2.2
5.2.3
5.2.4
5.2.5
5.3.1
5.3.2
5.3.3
5.4.1
5.4.2
5.4.3
5.4.4
5.5.1
5.5.2
5.5.3
5.5.4
6.1
17
18
18
19
20
22
23
28
31
33
33
34
35
36
37
37
38
38
39
40
42
47
47
49
50
51
52
53
54
56
58
59
62
66
67
67
69
71
71
73
74
76
CHAPTER: 1.
Introduction of Company
9
1.1 History
1.1.1
General Information
1.1.2
Milestone
1.2
Nature of Business
1.1 HISTORY
1.1.1 General information
10
ITC Ltd (ITC) was incorporated on August 24, 1910, under the name
Imperial Tobacco Company of India Ltd. to make cigarettes and
tobacco. In 1975, the company entered the hospitality business with
the acquisition of ITC-Welcome group Hotel Chula. the name of the
Company was changed to I.T.C. Limited in 1974. In recognition of the
Company's multi-business portfolio encompassing a wide range of
businesses - Cigarettes & Tobacco, Hotels, Information Technology,
Packaging, Paperboards & Specialty Papers, Agri-Exports, Foods,
Lifestyle Retailing and Greeting Gifting & Stationery - the full stops in
the Company's name were removed effective September 18, 2001.
The Company now stands rechristened 'ITC Limited'.
ITC is one of India's foremost private sector companies with a market
capitalization of nearly US $ 14 billion and a turnover of over $ 5
billion. ITC is rated among the World's Best Big Companies, Asia's
'Fab 50' and the World's Most Reputable Companies by Forbes
magazine, among India's Most Respected Companies by
BusinessWorld and among India's Most Valuable Companies by
Business Today. ITC ranks among India's `10 Most Valuable
(Company) Brands', in a study conducted by Brand Finance and
published by the Economic Times. ITC also ranks among Asia's 50
best performing companies compiled by Business Week.
ITC has a diversified presence in Cigarettes, Hotels, Paperboards &
Specialty Papers, Packaging, Agri-Business, Packaged Foods &
Confectionery, Information Technology, Branded Apparel, Personal
Care, Stationery, Safety Matches and other FMCG products. While ITC
is an outstanding market leader in its traditional businesses of
Cigarettes, Hotels, Paperboards, Packaging and Agri-Exports, it is
rapidly gaining market share even in its nascent businesses of
Packaged Foods & Confectionery, Branded Apparel, Personal Care and
Stationery. As one of India's most valuable and respected
corporations, ITC is widely perceived to be dedicatedly nationoriented.
ITC's Agri-Business is one of India's largest exporters of agricultural
products. ITC is one of the country's biggest foreign exchange earners
( $ 3.2 billion in the last decade). The Company's 'e-Choupal'
initiative is enabling Indian agriculture significantly enhance its
competitiveness by empowering Indian farmers through the power of
the Internet. This transformational strategy, which has already
11
13
paperboards,
Products /
Branded Packaged Foods
Confectionery Foods; Snack
17
Hotels:
Paperboards, Paper & Packaging:
Specialty Papers &
Hoteliering.
Paperboards, Paper including
Packaging including Flexibles.
Agri Business:
spices, coffee and
to a numb countries.
1.4 Background
LISTING DETAILS
Corporate Identity Number (CIN)
L16005WB1910PLC001985
of the Company:
Name of the Company:
ITC Limited
18
Virginia House,
Road,
ccd@itc.
BSE Code
500875
NSE Symbol
ITC
ISIN NO
INE154A01025
Face Value
Listing
BSE,NSE,Kolkata
BSE Group
Indices
BSE100, BSE200, BSE500,
A
SENSEX,
BSEFMC,
GREENEX, CARBONEX ,
NIFTY,
CNX500, CNX100,CNXFMCG,
CNXCONSUMP, CNXDIVOPPT,
CNXLOWVOL, NI15
19
Contact details
Address
House,37 Jawaharlal Nehru
Virginia
Road,
Kolkata,West Bengal-700071 .
Phone No
22889371/22886426
91-033/22880034
(Phone)
Fax
22882358 (Fax)
Email ID
Website
www.itcportal.com
ITC Ltd.
Virginia
Road,
,Kolkata 700071
Registrar Phone
9371 / 2288 6426 / 2288
033-2288
0034
(Phone)
Registrar Fax
2358 (Fax)
033-2288
20
Registrar Email Id
Registrar Website
www.itcportal.com
Committee
Executive Directors:
Y C Deveshwar Chairman
N Anand Member
P V Dhobale Member
K N Grant Member
Executives
A Nayak Member
T V Ramaswamy Member
S Sivakumar Member
K S Suresh Member
R Tandon Member
B B Chatterjee Member & Secretary
Chief Financial Officer:
Rajiv Tandon
Executive Vice President & Company Secretary:
Biswa Behari Chatterjee
General Counsel:
Kannadiputhur Sundararaman Suresh
1.7 Auditors
M/s.
Deloittee Haskins & Sells, Chartered Accountant, the
Statutory Auditors of the company retire at the ensuring Annual
General Meeting and ate eligible for re-appointment. They have
furnished a certificate regarding their eligibility for re22
(A)Institutional
Shareholding
Financial Institutions,
Insurance Companies,
Mutual Funds and Banks
Foreign Institutional
Investors
Sub-Total (A)
(B)Non-Institutional
Shareholding
Foreign Companies
NRIs, Foreign Nationals
and Qualified Foreign
Investment
Bodies Corporate
Public and Others
Sub-Total (B)
Public Shareholding
(A+ B)
Shares underlying
Global Depository
Receipts
Total
2,75,77,23,494
34.68
1,53,21,06,319
19.26
4,28,98,29,813
53.94
2,41,35,09,216
4,24,31,363
30.35
0.53
35,40,95,975
83,25,34,963
3,64,25,71,517
7,93,24,01,330
4.45
10.47
45.80
99.74
2,07,81,620
0.26
7,95,31,82,950
100.00
23
Institutional Shareholding:-
53.94
Interpretation:
As we can see, total Institutional Shareholding has 53.94%
shares out of the companys total share capital and NonInstitutional Shareholding has a 45.80% share and a Shares
24
Chapter:2
Analysis of Balance
Sheet
2.1
2.2
2.3
2.4
Balance Sheet
Trend Analysis
Vertical Analysis
Horizontal Analysis
25
Loan Fund
Secured Loan
Unsecured Loan
Deferred Tax-Net
APPLICATION OF FUNDS
Fixed Assets
Gross Block
Less Depreciation
Net Block
Capital Work in Process
20092010
20102011
20112012
20122013
20132014
381.82
13682.5
6
14064.3
8
773.81
15179.4
6
15953.
27
781.84
18010.0
5
18791.8
9
790.18
21497.6
7
22287.
85
795.32
25466.7
0
26262.0
2
107.71
785.01
14957.1
0
1.94
97.26
801.85
16854.
32
77.32
1.77
872.72
19743.0
7
66.40
1203.72
23557.
97
51.00
0.14
1296.96
27610.1
2
11967.8
6
3825.46
8142.40
12765.8
2
4420.75
8345.07
16072.5
8
4819.66
11252.9
2
2269.26
13522.1
8
18061.1
8
5469.83
9529.83
20448.5
4
6226.91
14221.6
3
2272.94
16494.5
7
1008.99 1333.40
9151.39 9678.4
7
1472.80
11002.
63
26
Investment
Current Assets, Loan and
Advances
Inventories
Sundry Debtors(Debtors)
Cash and Bank
Other Current Assets
Loans and Advances
5726.87
5554.66
6316.59
7060.29
8823.43
4549.07
858.80
1126.28
288.39
1304.54
8127.08
5267.53
907.62
2243.24
347.49
1418.09
10183.
97
5637.83
986.02
2818.93
136.89
1694.02
11273.6
9
6600.20
1163.34
3615.00
641.36
2240.11
14260.
01
7359.54
2165.36
3289.37
1019.69
2263.53
16097.4
9
3386.79 3531.73
4411.07 5258.75
7797.86 8790.4
8
3475.83 5469.53
19743.0 23557.
7
97
3636.97
5994.71
9631.68
3498.30 4457.94
4549.94 4104.84
8048.24 8562.7
8
78.84
1621.19
14957.1 16854.
0
32
6465.81
27610.1
2
20092010
20102011
20112012
20122013
20132014
Shareholders Funds
Share capital
Total Reserve
100.00
100.00
202.66
110.94
113.43
101.04
118.65
117.79
101.07
119.36
118.60
100.65
118.46
117.83
Loan Fund
Secured Loan
Unsecured Loan
Deferred Tax-Net
100.00
100.00
100.00
90.30
102.15
112.68
3985.57
1.82
108.84
117.14
85.88
137.92
119.32
76.81
0.13
107.74
177.20
APPLICATION OF FUNDS
Fixed Assets
Gross Block
Less Depreciation
Net Block
Capital Work in Process
100.00
100.00
100.00
100.00
106.67
115.56
102.50
132.15
125.90
109.02
134.85
170.19
112.37
113.49
84.69
64.90
113.22
113.84
149.23
154.33
SOURCE OF FUND
27
105.76
96.99
139.71
113.72
81.37
111.77
149.91
124.97
100.00
100.00
100.00
100.00
100.00
115.79
105.68
199.17
120.49
108.70
125.30
107.03
108.63
125.66
39.40
119.46
110.70
117.07
117.98
128.24
456.52
132.23
126.49
111.51
186.13
90.99
158.99
101.05
112.86
100.00
100.00
100.00
127.43
90.22
106.39
2056.30
75.97
107.46
91.07
214.40
104.28
119.22
112.73
157.36
102.98
113.99
109.57
118.22
Investment
Current Assets, Loan and
Advances
Inventories
Sundry Debtors(Debtors)
Cash and Bank
Other Current Assets
Loans and Advances
100.00
Tootle
Interpretation:
share capital contribution to the total fund has constant same
from last three year. In only 2011 not same.
company not issuing any more shares to increase share capital
from last three year.
28
Interpretation:
Total Reserve contribution to the total fund has to be constant
increasing from 2009-10 To 2012-13 but 2013-14 decreasing.
company is good in position to expand their business and
Come out companys debts.
WE can see, company has good reserve for surviving in future
situation .
Interpretation:
Secured loan have been increasing in year 2011-12 and then
after it is more decreasing.
It shown to be company used it more in the recession time to
recovers its profit and position.
30
Interpretation:
Hear we can see that from 2009-10 company was decreasing
their Unsecured Loan. And it shown decreasing more in two year.
It shown to be good that the company has decreasing their debts.
But in the current year company decreasing. It is sing not good
credit and financial position but for long run it will good for
company.
Interpretation:
Capital work in Process is increasing or after decreasing and
remain in current year at good level
Capital in process is more it good for company decrease their
capital in compare last four years
31
2.2.6 Investment
Interpretation:
By seeing in the above graph it is Proved to be that the company
invests high in years 2013-14 compared to the all previous years
because of recession time the company need to recover its profit
by outside income .interest achieving it by investing more in the
profitability areas.
32
2009-
2010-
2011-
2012-
2013-
2.552767
91.47869
582
94.0314
574
6332
0
0.720126
5.248410
228
454
100
4.59116
90.0627
7131
94.6538
2576
9289
0.01151
0.57706
0402
4.75753
2735
3973
100
3.960073
91.22213
079
95.1822
516
0824
0.391631
0.008965
089
4.420386
171
495
100
3.354193
91.25433
931
94.6085
983
3376
0.281857
902
0
5.109608
341
100
2.880538
92.23683
006
95.1173
2
7001
0.184714
0.000507
88
4.697408
06
052
100
80.01457
25.57621
502
54.43836
464
6.745893
038
61.1842
255
38.28863
5363
884
30.41411
5.741754
771
7.530069
752
1.928114
332
8.721877
407
54.3359
904
341
23.38889
30.41993
223
435
75.7421
26.2291
2427
49.5129
8041
7.91132
4386
57.4242
4812
32.9568
6867
9176
31.2532
5.38508
9292
13.3095
8215
2.06172
8472
8.41380
6608
60.4234
7261
9973
26.4498
24.3548
3601
2416
81.40871
24.41190
708
56.99680
757
11.49395
951
68.4907
712
31.99396
6663
041
28.55599
4.994258
458
14.27807
745
0.693357
327
8.580327
213
57.1020
173
1098
17.15432
22.34237
301
127
76.66696
23.21859
239
40.45267
651
6.251812
907
46.7044
019
29.96985
9109
733
28.01684
4.938201
525
15.34512
382
2.722475
524
9.508926
663
60.5315
278
7382
14.99165
22.32259
675
401
74.06175
22.55299
707
51.50875
868
8.232271
838
59.7410
356
31.95723
2974
162
26.65522
7.842631
642
11.91363
615
3.693174
891
8.198189
821
58.3028
649
6141
13.17259
21.71200
758
27
33
Provisions
Net Current Assets
53.8088
0.527107
2658
528
100
50.8046
9.61883
6017
9562
100
39.4966
17.60531
9428
67
100
37.3142
23.21732
5076
305
100
34.8846
23.41826
0028
113
100
Interpretation:
share capital contribution to the total fund has to be increased in
year 2011 to compare 2010.But after year 2011 Share capital
decreased to year 2014.
The company should maintain it in a good poison to meet its
future requirements and also to recover its loser in the current
depression situation.
34
Interpretation:
As per the above details we can see here that the reserves are
decreased in year 2011 to compare 2010. Constantly increased in
2012 to 2014.
The Company should maintain it because it will helps to the
company to carry on its business in recession time also.
35
Interpretation:
Secured loan is increased very more in year 2012 to compare last
2 year. And 2013-14 decreased to compare 2012.
It shows that the company not uses it on the basis of changes
occurred in the market like current position of the market is being
a recession period so, they have to increased its loan by securing
or mortgaging the items.
36
Interpretation:
As shown above chart unsecured loan who high in the year 2010
and after decreging year by year constantly it shows company
better position company should reduce their debts or short turn
loans and create more cash show company in good position to
decrease the unsecured loan
2.3.5 Investment
37
Interpretation:
As seen above Graph an investment who high in 2011 and after
decreasing constantly to 2014 its create bed reputation in market
and company have not more investment so in emergency
company loss his business and it not good sign for the company .
2009-
2010-
2011-
2012-
201338
2010
2011
2012
2013
2014
100
100
102.66
10.94
1.03
18.64
1.06
19.36
0.65
18.46
100
13.43
17.79
18.6
17.83
100
100
100
0
-9.7
2.14
38.85
-98.18
8.83
-14.12
0
37.92
-23.19
0
7.74
100
12.68
17.13
19.32
17.2
SOURCE OF FUND
Shareholders Funds
Share capital
Total Reserve
Loan Fund
Secured Loan
Unsecured Loan
Deferred Tax-Net
Interpretation:
Total reserve contribution to the total fund has to be decreasing in
2013-14 but not decreasing more as compare to last year
We can see, company has good reserve for surviving in future
situation.
Secured loan have been decreased for successive years it shown
to be that company used its capital to recover its profit and
potion.
Table 2.4.2
20092010
20102011
20112012
20122013
20132014
100
100
100
100
6.66
15.56
2.48
32.15
25.9
9.02
34.84
70.18
12.37
13.48
-15.31
-35.09
13.21
13.84
49.23
54.32
100
100
5.75
-3
39.71
13.71
-18.63
11.77
49.91
24.97
100
100
100
100
100
15.79
5.68
99.17
20.49
8.7
7.02
8.63
25.66
-60.6
19.45
17.06
17.98
28.24
36.85
32.23
11.5
86.13
-0.9
58.98
1.04
100
25.3
10.7
26.48
12.88
100
100
27.43
-9.78
-24.02
7.46
4.27
19.21
2.97
13.99
100
100
6.39
19.56
-8.93
114.39
12.72
57.35
9.56
18.21
100
12.68
17.13
19.32
17.2
Year End
APPLICATION OF FUNDS
Fixed Assets
Gross Block
Less Depreciation
Net Block
Capital Work in Process
Investment
Current Assets, Loan and
Advances
Inventories
Sundry Debtors(Debtors)
Cash and Bank
Other Current Assets
Loans and Advances
Interpretation:
Here we can see that in compare of year 2010-11 companys
assets increasing more as compare to last five year. Its means
company is performing well to increasing their assets in currents
year
Company investment decreasing in current year as compare to
last year
40
Chapter: 3
PROFIT AND LOSS STATEMENT
3.1
3.2
TREND ANALYSIS
3.3
VERTICAL ANALYSIS
3.4
HORIZONTAL ANALYSIS
2010
26862.98
2011
31423.23
2012
36072.59
2013
43044.21
2014
48175.8
26259.6
8106.41
30604.39
9436.81
34871.86
10073.43
41809.82
12204.24
46712.62
13830.06
18153.19
603.38
18756.5
7
21167.58
818.84
21986.4
2
24798.43
1174.37
25972.8
29605.58
1234.39
30839.9
7
32882.56
1463.18
34345.7
4
6971.4
8126.5
270.55
7660.91
65.59
8936.21
246.35
10263.28
128.41
5161.15
1140.02
68.38
655.99
4745.52
5935.77
1265.41
77.92
655.99
5427.26
2037.21
1387.01
86.47
795.56
5820.97
3375.92
1608.37
2.95
899.92
6019.05
3021.47
12741.2
6
14718.2
6
17101.6
3
20155.7
9
21686.6
3
6015.31
1954.31
4061
858.14
4919.14
7268.16
2280.55
4987.61
61.31
5048.92
8897.53
2679.66
6217.87
70.87
6288.74
10684.18
2989.06
7695.12
331
8026.12
12659.11
3873.9
8785.21
82.77
8867.98
406.1
498.76
1651.62
2143.24
3340.76
1718.18
2166.68
3518.29
4148.46
4771.91
634.15
-0.6
558.62
-0.6
570.75
(0.59
705.03
(0.61
810.99
28.68
61.31
4919.14
548.67
5048.92
548.67
6288.74
430.07
8026.12
Expenditure
Raw Materials etc.
change in inventories of
finished goods,Work-incapital
Employ benefits Expense
Finance costs
Depreciation
Other Expenses
Manufacturing,Selling
etc.Expenses
Profit
Profit Before Taxation
Provision for Taxation
Profit after Taxation
Profit Brought Forward
Available for appropriation
Appropriations
General Reserve
Proposed Dividend
Ordinary Dividend
Income Tax on Proposed
Dividend
Current Year
Earlier Year's proposed
Dividend
Profit Carried Forward
608.71
8867.98
42
Rs.10.73
Rs.10.62
Rs.6.49
Rs.6.41
Rs7.93
Rs7.84
Rs9.45
Rs9.33
Rs11.09
Rs11.96
Table 3.2
Particulars
2010
2011
2012
2013
2014
Total revenue
100
117.2198328
118.1311009
118.739489
15.6220976
4
Total
expenses
100
115.9276241
115.6027769
136.4584744
146.822548
Profit before
tax
100
120.827688
122.417916
146.9997909
174.172142
6
Profit after
tax
100
122.8172864
123.5535657
148.7363687
175.599335
2
100
102.638266
124.5561427
158.9670662
175.641127
2
Profit
available for
appropriation
Interpretation:
44
Interpretation:
Hear we can see that Total expenses is increasing constantly from
the 2009-2010 to the 2013-2014.
Company is performing successively decreasing their expenses
and earning not good profit constantly. It is not good for the
company.
Interpretation:
Profit before Tax has increased in the current year that in compare
to base year, because optimum utilization of assets in generating
sales revenue reduction in total cost, increase in market size of
the company, etc. so it is good condition of the company.
Interpretation:
Profit After Tax has intended to increase throughout analyzes. In
the presently financial year increase in compare of the base year.
We can see that company is performing well and its Profit After
Tax become a more than in compare of base years.
2014
2013
2012
2011
2010
47
Total revenue
15.62
118.73
118.13
117.21
100
Total expenses
146.82
136.45
115.60
115.92
100
174.17
146.99
122.41
120.82
100
175.59
148.73
123.55
122.81
100
175.64
158.96
124.55
10ase
2.63
100
Interpretation:
Hear we can see that Total Revenue is increased after year 2010
but in year 2014 Total Revenue is decrease.
Company is performing is good but not very well.
48
Interpretation:
49
Interpretation:
Hear during the analyzing the data we can see, in compare to
total income, Available profit for appropriation in decreasing in
year 2013 and year 2014 to compare last Three year.
It is not good for the company and their investors.
Particular's
2010
2011
2012
2013
2014
Gross Income
100
16.97
14.79
19.32
11.92
Total Expenses
100
15.51
16.19
17.85
7.59
100
20.82
22.41
20.08
18.48
100
22.81
24.66
23.75
14.16
100
2.63
24.55
27.62
10.48
Proposed Dividend
100
26.1
62.38
17.91
15.03
Interpretation:
Here we can see that total expenditure is decreasing on base of
total income.
Expenses are decreasing more from last 4 year.
So, Company have good potion in financial year.
Here during the analyzing the data we can see , in compare to
total income available profit for appropriation in decreasing in
2009-10 in compare of base year and also in current year.
51
Chapter:4
Analysis of Cash Flow
Statement
PARTICULARS
A. Cash Flow from Operating Activities
PROFIT BEFORE TAX
ADJUSTMENTS FOR :
Depreciation and Amortisation Expense
Finance costs
Interest Income
Dividend Income from Long Term
Investments
Dividend Income from Current Investments
Loss on Sale of Fixed Assets Net
Net gain on sale of Current Investments
Gain on sale of Long Term Investments
Doubtful and Bad Debts
Doubtful and Bad Advances, Loans and
Deposits
Excess of Carrying Cost over Fair Value of
Currentof
Investments
- NetInvestments over
Excess
Cost of Current
Fair Value,
reversed
Net
Foreign
Currency
translations
and
transactions -PROFIT
Net
OPERATING
BEFORE WORKING
CAPITAL CHANGES
ADJUSTMENTS
FOR :
Trade Receivables, Loans and Advances and
Other
Assets
Inventories
Trade Payables, Other Liabilities and
Provisions
CASH GENERATED FROM OPERATIONS
Income Tax Paid
NET CASH FROM OPERATING ACTIVITIES
B. Cash Flow from Investing Activities
Purchase of Fixed Assets
Sale of Fixed Assets
Purchase of Current Investments
Sale/Redemption of Current Investments
Purchase of Long Term Investments from
Subsidiary
Investment in Joint Ventures
Investment in Subsidiaries
Sale of Long Term Investments
Dividend Income from Long Term
Investments
Received
Dividend Income
from Current Investments
Received
Interest Received
Investment in bank deposits
Redemption / Maturity of bank deposits
Investment in deposits with financial
institutions
2010
2011
2012
2013
6015.3
1
608.71
7268.16
8897.53
655.99
68.38
(168.58)
(83.75)
(155.53)
24.44
(54.92)
(63.01)
2.28
2.93
(2.57)
(10.21)
7454.78
77.92
(309.41)
(100.51)
(198.40)
11.62
(76.04)
(137.25)
9.63
2.46
5.74
(12.42)
(1.48)
8820.35
(124.96)
(720.10)
918.71
7528.43
(2195.74
)
5332.69
(399.19)
(368.66)
28106
8333.56
(2317.97
)
6015.59
140.26
-
(1349.91
)
8.06
(68486.9
5)
68939.5
-4
(176.59)
(45.47)
(25.00)
103.58
83.75
155.53
141.00
(2303.56
)
55.93
(49434.6
0)
49150.7
2
(297.16)
(37.88)
(82.30)
164.61
100.51
198.40
283.72
698.51
10684.
18
795.56
86.47
(355.48)
(123.96)
(186.54)
23.73
(146.02)
(121.62)
7.49
0.30
(25.80)
7.36
10645.
67
(421.14)
(962.37)
334.08
9596.2
4
(2886.3
5)
6709.8
9
(2097.6
6)
7.73
(69881.
72)
69376.3
1
(9.97)
(50.43)
134.44
123.96
186.54
263.89
(3397.3
9)
2513.02
(65.93)
(77.65)
(135.68)
30.88
(11.24)
(31.70)
12.50
11.28
(0.27)
(36.93)
9.95
6329.2
3
(290.89)
50.65
531.46
6620.4
5
(1989.8
0)
4630.6
5
(1094.4
7)
2.86
(57866.
98)
55449.2
7
(387.31)
(147.00)
66.47
77.65
133.80
2014
12659.
11
899.92
2.95
(412.77
)
(217.27
)(140.15
)
12.95
(329.44
-)
11.17
0.11
3.31
1.76
12491.
65
(1404.1
0)
(759.34
)
431.29
10759.
50
(3797.2
0)
6962.3
0
(2593.4
7)
20.83
(82231.
94)
81327.
47
(1.96)
(1.24)
(85.42)
217.27
140.15
387.33
(2817.8
0)
3125.9
6
(425.00) (750.00
53)
(811.33)
905.22
(3531.5
6)
720.73
1.85
(10.06)
(61.63)
(33.52)
6.04
(1396.5
3)
(236.74)
(1009.8
6)
89.23
993.70
1082.9
3
(239.61)
207.40
(684.67
)
903.82
1.40
(11.85)
1.94
(15.80)
20.58
(3818.18
)
(633.55)
(3551.6
4)
1096.38
1082.54
2178.92
(410.73)
402.15
2210.19
764.99
0.77
(10.68)
(0.17)
(16.79)
16.83
(3443.47
)
558.03
(3246.5
5)
558.85
2178.92
2737.77
(1179.2
0)
854.70
(3580.
78)
922.31
0.35
(10.03)
(1.77)
(70.14)
15.16
(3518.2
9)
(570.14)
(3232.
55)
(103.4
4)
259.34
155.90
425.00
14.26
(2823.
29)
691.08
(11.27)
0.14
(46.35)
17.36
(4148.4
6)
(676.35
)
(4173.
85)
(34.84
)155.90
121.06
Interpretation:
:
As above detail we see that the net cash from operating
activity is increasing year-by-year so companys cash increase its
good shine for the company. cash from operating activity is
increasing because of a profit before tax is increasing.
:
In investing activity increased in 2012 and then decreased
its create increment in cash. Inventory is decreased so the cash
flow is increased and it makes good shine for company. And an
interest income is raised so the cash is increased.
54
Chapter: 5
55
RATIO ANALYSIS
5.1 Liquidity Ratios
5.2 Profitability Ratios
5.3 Assets Turnover Ratio
5.4 Finance Structure Ratios
5.5
Valuation Ratio
INTRODUCTION:
Ratio Analysis is a widely used tool of Financial Analysis. It is
defined as the systematic Use of Ratio to interpret the financial
statement so that the strength and weakness of a firm as well as
its historical performance and current financial condition can be
determined. The Ratio refers to the numerical or quantitative
56
various
aspects
of
the
business
like
inequality,
it can
Current Ratio =
Where,
The current assets of the firm represent those assets which
can be in the ordinary course of business, converted in to cash
within a short period of time, normally not exceeding one year.
The current liabilities defined as liabilities which are short
maturing obligation.
58
Particulars
Year
2009-10
2010-11
8127.08
10183.97
8048.24
8562.78
1.00
1.18
Current Ratio
2012-13 2013-14
14260.01 16097.4
11273.69
9
8790.48 9631.68
7797.86
1.62
1.67
1.44
2011-12
Interpretation:
Current Ratio should be 2:1.
It is measure of companys Liquidity i.e. how
quickly company can convert assets to cash.
Here, it is 2014-1.67 highest and lovest in 2010 it
is constantaly increasing so it is good for the
company.
Company has higher capacity to convert its assets
into cash more than required.
59
Quick Assets
Quick Liabilities
Where,
Quick Assets = Current Assets Inventories
Quick Liabilities = Current Liabilities-bank overdraft.
Particulars
Year
201011
Quick Liabilities
200920112012201310
12
13
14
3578.0
1
4916.44 5635.86 7659.81 8737.95
8048.2
8790.48 9631.68
4 8562.78 7797.86
Quick Ratio
0.44
Quick Assets
0.57
0.72
0.87
0.90
Interpretation:
60
5.1.3
Particulars
Year
20102009-10
11
10183.9
8127.08
7
8048.24
78.84
8562.78
1621.19
201112
11273.6
9
7797.86
201213
14260.0
1
8790.48
201314
16097.4
9
9631.68
3475.83
5469.53
6465.81
Interpretation:
Here Working Capital has been increasing compared to the
last years that is good for the company.
5.2
Profitability Ratio:
61
It
also
helps
in
ascertaining
whether
the
average
Particulars
Total Sales
Year
20102009-10
11
21337.8
19288.2
7
30604.3
26259.6 9
73.45
Gross Profit
69.72
201112
25945.5
4
34871.8
6
201213
31485.9
41809.8
2
201314
34840.1
7
46712.6
2
74.40
75.31
74.59
Interpretation:
If the ratio is high it indicates Gross Profit is high or the
purchasing is efficient alternating and vice versa.
Here the ratio is increasing from year 2010 to 2013 and
decreasing 0.72 from last yare.
The highest value of the ratio is 75.31% And the lowest
value is 69.72% .This is good for the company
5.2.2
Operating Ratio.
Operating Ratio =
Where,
63
Year
200910
20489.7
4
Operating Profit
Total Sales
Operating Profit
Ratio
26259.6
2010-11
24012.6
3
30604.3
9
201112
32178.6
6
34871.8
6
201213
37638.3
4
41809.8
2
201314
42791.2
3
46712.6
2
78.02
78.46
92.27
90.02
91.60
Interpretation:
This ratio shows that percentage of Operating profit over
Sales.
5.2.3
Particulars
Year
64
200910
Net Profit
201011
201112
Total Sales
4061
26259.
6
4987.61 6217.87
30604.3 34871.
9
86
21.65
22.68
201213
201314
7695.12
41809.
82
8785.21
46712.
62
24.95
25.58
23.94
Interpretation:
It measure a collecting overall profitability of business and
shows efficiency otherwise a operating the expenses over a
sell.
Value of the ratio is highest in year 2013-14 i.e. 25.58%
because of decrease in the value of Net Sale.
In year 2009-10, Net Profit is
constantaly up to 25.58%
It is not good for the company.
5.2.4
firm distributed
To its Investor.
Rate of Return on Total Assets =
and Interest)
Total Assets
Where,
EBIT = Net Profit + Interest + Tax.
Total Assets = Net Fixed Assets + Investments + Net Working
Capital.
Instead of Total Assets, Total Capital Employed is also
shown as denominator.
Total Capital employed = Owners Fund (Capital + Reserves
Miscellaneous
Expenses) + Long term Debt.
It should be noted that the amount of total assets and
total capital employed would be same.
Particulars
EBIT
Year
20102009-10
11
14878.26
7268.16
15233.1
3
8897.53
19838.7
7
201213
10684.1
8
18062.9
2
40.43
47.71
44.85
59.15
6015.31
Total ASSETS
ROI
201112
201314
12659.1
1
25318.0
0
50.00
Interpretation:
The ratio shows the total profit on total investments of the
company.
66
5.2.5
Year
20102009-10
11
201112
201213
4919.14
18938.5
2
5048.92
21002.1
9
6288.74
25080.6
3
8026.12
30313.9
7
25.97
24.04
25.07
26.48
201314
88867.9
8
35130
25.24
Interpretation:
67
5.3
5.3.1
5.3.2
5.3.3
5.3.4
5.3.5
5.3.1
Where
Particulars
Sales
Total Assets
Total Assets Turn
Over Ratio
200910
26259.
6
14878.
26
1.76
Year
20102011201211
12
13
30604.3 34871.8 41809.
9
6
82
15233.1 19838.7 18062.
3
7
92
2.00
1.75
2.31
201314
46712.
62
25318.
00
1.84
69
Interpretation:
This is a measure of the efficiency how the assets are
utilized it indicates how many times the assets Were turned
over in period.
The company turnover ratio has decreased in last year it saw
not performing well in 2010. Increased more in 2013 and
then after decreased in current year.
This is not good for the company.
5.3.2
Year
20102009-10
11
201112
201213
201314
70
Sales
26259.6
30604.3
9
9678.47
34871.8
6
13522.1
8
41809.8
2
11002.6
3
46712.6
2
16494.5
7
Fixed Assets
Net Fixed Assets Turn
Over Ratio
9151.39
2.86
3.16
2.57
3.80
2.83
Interpretation:
A net fixed asset turnover is indicates that the companys
sales over the total fixed assets.
The net fixed asset is high at 3.80 in the year 2012-13.
Assets are almost same but sales and hence ratio has
increased that is good for the company.
Sales
Net Working Assets
Particulars
Year
2009-10
Sales
Net Working Assets
26259.6
Net
1008.99
Working 26.02
Capital
Turnover
2010-11
2011-12
30604.3
34871.86
9
1333.40
2269.26
2012-13
2013-14
41809.82
1472.80
46712.62
2272.94
22.95
28.38
20.55
15.36
Ratio
Interpretation:
71
5.3.4
Particulars
200910
COGS
Average Inventories
Inventory Turn Over
6971.4
4549.0
7
1.53
Year
201011
201112
9266.52 8926.32
201213
10323.9
2
201314
11871.6
5
4908.3
5452.68
6119.01
6979.87
1.88
1.63
1.68
1.70
Interpretation:
The Inventory Turnover Ratio indicates the turnover of the
stock in the company.
72
The high turnover ratio is high profit of the company and the
vice versa.
The ratio is increases for the two consecutive years from
1.63 to 1.70 times. This is good for the company.
5.3.4
Ratio
Particulars
200910
Year
201011
201112
201213
201314
No. of Days
360
360
360
360
360
1.53
1.88
1.63
1.68
1.70
235.29
191.48
220.85
214.28
211.76
Days
Interpretation:
73
Debtors Turn
over
Where,
Average Debtors = (Beginning debtors + closing debtors)/2
Particulars
Credit Sales
Year
2009201010
11
30604.3
26259.6 9
2011-12
34871.8
6
201213
41809.8
2
201314
46712.6
2
Average Debtor
858.80
883.21
946.82
1074.68
1664.35
30.57
34.65
36.83
38.90
28.06
Interpretation:
74
5.3.5
Particulars
200910
Year
201011
201112
201213
201314
360
360
360
360
360
30.57
34.65
36.83
38.90
28.06
Days
11.77
10.38
9.77
9.25
12.83
No. of Days
Interpretation:
High average age of debtors is not good because it indicates
poor collections procedure and idle fund blocking in debtors.
The average age of debtors is compared with the credit
period allowed to the customers.
75
Here, we can see that the Average age has decreased and
then increased in 2013-14 year.
This is not good for the company. It should be less or equal
to Average days in 2012-13.
prime
reinvestment
fund,
of
which
profits,
increases
while
progressively
outside
debt
through
funds
are
is greater than interest on debts and it is (II) bad if ROI is less than
interest on debts. Thus, use of debts is considered as a DoubleEdge weapon. Some popular finance structure ratios are as
under:
Where,
Net Worth = Equity Capital + Reserves Misc. Expenses.
Total Capital Employed = Net Worth + Long Term Debts.
Particulars
Year
Net Worth
Total Capital
Employed
20112010-11
12
21002.1 25080.6
9
3
21909.8 26066.6
1
5
2009-10
18938.52
19797.32
201213
30313.9
7
31477.3
1
201314
35130
37295.3
6
77
Equity Ratio
0.95
0.95
0.96
0.96
0.94
Interpretation:
This ratio suggests the proportion of the Net Worth to total
capital employed. Net Worth is share plus reserves and
surplus. The higher the ratio the higher the net worth in total
capital employed and vice versa.
The ratio decreases year by year because of the capital the
total capital employed increased.
It was the highest value is 0.85 in the year 2008-07.
It is decreased by 0.74 in the year 2010-09.This is not good
for company.
Year
2009-10 2010-11
201112
201213
201314
858.80
19797.3
2
907.62
21909.8
1
986.02
26066.6
5
1163.34
31477.3
1
1165.36
37295.3
0
0.043
0.041
0.037
0.037
0.058
Analysis:
This ratio suggests the proportion of long-term debt to
Total Capital Employed. Long-term debt is a debt, which is
of more than five years and includes interest thereon. The
higher the long-term the higher the total capital employed
and vice-versa.
5.4.3
Particulars
Year
20102009-10
11
201112
201213
201314
79
858.80
18938.5
2
0.045
907.62
21002.1
9
0.043
986.02
25080.6
3
1163.34
30313.9
7
0.039
0.038
1165.36
35130
0.062
Interpretation:
Debt Equity Ratio is debt to Equity. Debt means long term
fund having maturity of five years or more including interest
thereon.
Equity is paid up share capital plus free reserves. The higher
the debt fund used in capital structure, the greater is the
financial risk. This is also known as leverage ratio.
5.4.4
80
Particulars
EBIT
126569
Year
201011
10684.1
8
Interest
Interest Coverage
Ratio
412.17
355.48
309.41
58.67
54.54
110.29
123.88
28.75
30.05
30.71
200910
201112
201213
201314
8897.53
7268.16
6015.31
Interpretation:
A high ratio implies adequate safety for payment of interest.
It decreased but in the year 2010-09 the ratio increased.
It is clearly indicates by the above calculation that interest
expenses decreases and also PBIT increase and so it implies
that the debt of the company decreases.
Thus in general we can conclude that the growth of the
company is very good
5.5.1
5.5.2
5.5.3
5.5.4
Particulars
200910
Year
201011
201112
201213
201314
4061
4987.61
6217.87
7695.12
8785.21
381.82
773.81
781.84
790.18
795.32
EPS
10.64
6.45
7.95
9.74
11.05
Net Profit
Interpretation:
82
Particulars
200910
Year
201011
201112
201213
201314
3.67
4.93
4.40
4.45
5.22
10.62
6.41
7.84
9.33
11.96
0.56
0.48
0.44
0.35
0.77
83
Interpretation:
This ratio indicates the splits of EPS between cash dividend
and reinvest at profit.
If the company has profitable project then it will keep D/P
ratio lower it will reinvest higher proportion of project in
business.
Here the companys ratio is first increased but decreased in
2011-12 to 2013-14 continuously. That means company is
reinvesting their money.
So it is good for the long term investor but not good for the
short term investor. Company may provide higher profits
after long-term. It is good to invest for long term.
84
Particulars
200910
Year
201011
201112
201213
201314
3.67
4.93
4.40
4.45
5.22
222
168
133
159
245
2%
2.67%
3.07%
2.79%
2.13%
Interpretation:
The lowest ratio is 2% in the year 2009-10 and it is high in
the year in the 2009-08 and the value is 2.67%.
Higher ratio is good for the short term investor and lower
ratio is good for the long term investor. It is good in 2010-09
for long term investor.
Particulars
200910
Year
201011
201112
201213
201314
290.22
289.55
308.12
324.84
376.65
10.64
6.45
7.95
9.74
11.05
P/E Ratio
27.27
41.17
38.75
33.35
34.08
Interpretation:
This provides companys future price earning.
From the given chart we can see that the lowest value was
achieved in the year 2009-10 It is
With P/E ratio we can determine the price of its share in
future as below.
86
Chapter: 6
DU-PONT ANALYSIS
6.1 DU-PONT Chart:
ROI (in %)
2010:40.43%
2011:47.71%
2012:44.85%
2013:59.15%
2014:50.00%
Total Assets
Turnover
2010:1.76
2011:2.00
2012:1.75
2013:2.31
2014:1.84
87
EBIT
Total Sales
2010:6015.31
2010:26259.6
2011:7268.16
2011:30604.39
2012:8897.53
2012:34871.86
2013:10684.18
2013:41809.82
2014:12659.11
2014:46712.62
Investment
s
2010:5726.87
2011:5554.66
2012:6316.59
2013:7060.29
Sales + Non-operating
Expenses
Operating Expenses
2010:12741.26
2010:18756.57
2011:14718.26
2011:21986.42
2012:17101.63
2012:25972.8
2013:20155.79
2013:30839.97
2014:21686.63
2014:34345.74
Net Fixed Assets
2010:5325.93
2011:5257.72
2012:8702.52
2013:5532.8
2014:10267.66
Net Working
Capital
2010:78.84
2011:4321.19
2012:3475.83
2013:5469.62
88
Accumulated
Depreciation
2010:9151.39
2010:3825.46
2011:9678.47
2012:13522.18
2013:11002.63
2014:16494.57
2011:4420.75
2012:4819.66
2013:5469.83
2014:6226.91
Total Current
Assets
Current Liability +
Provision
2010:8127.08
2010:8048.24
2011:10183.97
2011:5862.78
2012:11273.69
2012:7797.86
2013:14260.01
2013:8790.48
2014:16097.49
2014:9631.68
Interpretation:
The DU-Pont chart indicates the rate of return on
investments in percentage.
The chart shows the allocation of financial performance of
the company. In the chart profit margin percentage and
89
Chapter: 7
Recommendations and Suggestions
By analyzing the annual report of the company we can conclude
that,
90
CHAPTER: 8
91
Technical Analysis
Of
ITC Limited
Sector
Share
Price
Price
Change
Previous
Close
Beta
Average
Volume
NSE
Code
BSE
Code
BSE
Index
NSE
Index
Futures
and
options
Itc limited
364.10
-7.60 /
-2.04%
371.70
0.46
5919.60
K
ITC
500875
BSE
30
Nifty
50
Yes F&O
list
92
Support1
Support2
Support3
Resistance1
Resistance2
Resistance3
What
is
Pivot
Point
Pivot
Point o
other
Stocks
366.28
360.37
356.63
350.72
370.02
375.93
379.67
Learn
Pivot
Point
Pivot
Point
List
93
94
Name
Value
Stochastic D Fast
78.17
Stochastic K Fast
65.71
Stochastic D Slow
79.95
63.31
Williams %R
-34.29
Rate of Change
3.31
12431200.00
61.85
Aroon Up
0.00
Aroon Down
44.00
Ultimate Oscillator
57.32
7.29
On Balance Volume
1089330000.00
Accumulation Distribution
200774000.00
Value
1.09
Signal Line
-0.42
True
True
368.56
355.54
342.52
19.29
ADX +DI
26.14
ADX DI
13.52
0.07
95
Interpretation:
In technical analysis we should look
price and volume of the company at which level we
should hold the shares and which level we should sell the
share.
In chart ware the price line shown and a volume line
shown in which the current market price which helps us
to decide future movement of share or company price as
ware a price and volume line intersect in increase level
we got profit when sell our shares. And when line
intersects decrease level we should purchase share and
hold the share.
96
Bibliography
Annual Reports of ITC LTD
1. 2009-10
2. 2010-11
3. 2011-12
4. 2012-13
5. 2013-14
Books
Managerial accounting and financial book by R. Narayanswamy
Web Sites
WWW.ITCPORTAL.IN
WWW.BSEINDIA.COM
WWW.GOOGLE.COM
Software
ACEANALYSER SOFTWARE
97