Deposite Scheme Projec T From Net Nice
Deposite Scheme Projec T From Net Nice
Deposite Scheme Projec T From Net Nice
43
CHAPTER 4
DATA REDUCTION ,PRESENTATION& ANALYSIS
4.1 RETURN OF INVESTMENT
A performance measure used to evaluate the efficiency of an
investment or compare the efficiency of a number of different investments. Return
on investment is a popular metric because it is versatile and simple to use. If an
investment does not have a positive ROI or if there are alternative investment
opportunities with a higher ROI, the investment should not be undertaken.
EBIT
Return of Investment = __________________
Capital Employed
TABLE 4.1.1
RETURN ON INVESTMENT
(RS.IN CRORES)
YEARS EBIT CAPITAL
EMLOYED
ROI
2007 0.18 1.66 0.11
2008 0.25 1.52 0.16
2009 0.27 1.57 0.17
44
2010 0.17 2.17 0.08
2011 0.21 3.52 0.06
Source: Secondary data
INTERPRETATION:
The above table shows that the performance of return on investment
is based on deposits. The return on investment has been increased up to 2009. In
2010, the earning before in tax started to decrease, so the return on investment also
started to decrease in the year. The highest rate of return on investment is 0.17
Crores in the year 2009.
CHART 4.1.1
RETURN ON INVESTMENT
0.11
0.16
0.17
0.08
0.06
0
0.02
0.04
0.06
0.08
0.1
0.12
0.14
0.16
0.18
2007 2008 2009 2010 2011
R
s
.
I
n
C
r
o
r
e
s
Years
45
4.2 PERCENTAGE ANALYSIS
Percentage analysis consists of reducing a series of related amounts to a
series of percentages of a given base. Two approaches are often used. The first,
called horizontal analysis, indicates the proportionate change in financial statement
items over a period of time, such analysis is most helpful in evaluating trends.
Vertical analysis (common-size analysis) is proportional expression of each item on
the financial statements in a given period to a base amount. It analyzes the
composition of each of the financial statements from different years
(a) To detect trends not evident from the comparison of absolute amounts and
(b) To make intercompany comparisons of different sized enterprises.
100
PERCENTAGE = __________________ CURRENT YEAR
BASE YEAR
TABLE 4.2.1
DEMAND DEPOSITS
YEARS AMOUNTS (Rs) PERCENTAGE
2007 10,806,889 100
2008 11,192,915 103.57
2009 11,570,171 107.06
2010 17,064,834 157.91
46
2011 18,560,921 171.75
Source: Secondary data
INTERPRETATION:
The percentage analysis about demand deposits will be presented in the
above table. The year 2007 was taken as the base year for find out the percentage of
deposits increased for remaining years (i.e., 2008 to 2011). The percentage of
deposits increased compare to previous years because of increasing customers year
by year.
CHART 4.2.1
DEMAND DEPOSITS
100
103.57
107.06
157.91
171.75
0
20
40
60
80
100
120
140
160
180
200
2007 2008 2009 2010 2011
P
e
r
c
e
n
t
a
g
e
Years
47
TABLE 4.2.2
SAVINGS BANK DEPOSITS
YEARS AMOUNTS (Rs) PERCENTAGE
2007 21,998,110 100
2008 26,483,683 120.39
2009 28,994,262 131.80
2010 38,136,801 173.36
2011 49,465,383 224.86
Source: Secondary data
48
CHAPTER 5
DATA INTERPRETATION
The above table shows the performance of savings bank deposits for the last five
years with the help of percentage analysis. The year 2007 was taken as the base year
for find out the percentage of deposits increased for remaining years (i.e., 2008 to
2011). The percentage of deposits increased compare to previous years because of
increasing customers year by year.
CHART 5.1
SAVINGS BANK DEPOSITS
TABLE 5.2
TERM DEPOSITS
100
120.39
131.8
173.36
224.86
0
50
100
150
200
250
2007 2008 2009 2010 2011
P
e
r
c
e
n
t
a
g
e
Years
49
YEARS AMOUNTS (Rs) PERCENTAGE
2007 107,569,355 100
2008 132,485,325 123.16
2009 162,768,420 151.31
2010 182,104,853 169.29
2011 205,338,159 190.89
Source: Secondary data
INTERPRETATION:
The above table shows the performance of term deposits for the
last five years with the help of percentage analysis. The year 2007 was taken as the
base year for find out the percentage of deposits increased for remaining years (i.e.,
2008 to 2011). The percentage of deposits increased compare to previous years
because of increasing customers year by year.
CHART 5.3
TERM DEPOSITS
100
123.16
151.31
169.29
190.89
0
50
100
150
200
250
2007 2008 2009 2010 2011
P
e
r
c
e
n
t
a
g
e
Years
50
5.3 RATIO ANALYSIS
Ratio analysis is the process of determining and presenting the
relationship of items and group of items in the statements. According to Batty J.
Management Accounting Ratio can assist management in its basic functions of
forecasting, planning coordination, control and communication.
5.3.1 CURRENT RATIO
Current Assets
Current Ratio = __________________
Current Liabilities
TABLE
5.3.1 CURRENT RATIO
(RS.IN CRORES)
Years Current Assets Current Liabilities Current Ratio
2007 10.71 4.22 2.53
2008 12.83 4.71 2.72
2009 13.27 5.01 2.65
2010 16.24 6.99 2.32
2011 19.33 8.73 2.21
51
Source: Secondary data
INTERPRETATION:
The current ratio of the company this shows that the current ratio is
more than the standard level 2:1 so they should maintain this for future
CHART 5.3.1
CURRENT RATIO
5.3.2 RATIO OF CURRENT LIABILITIES TO PROPRIETORS
FUND:
This ratio explains the relationship between current liabilities and
shareholders fund of a business.
2.53
2.72
2.65
2.32
2.21
0
0.5
1
1.5
2
2.5
3
2007 2008 2009 2010 2011
R
s
.
I
n
C
r
o
r
e
s
Years
52
Current Liabilities
Ratio of Current Liabilities to Proprietors fund = __________________
Shareholders fund
TABLE 4.3.2
RATIO OF CURRENT LIABILITIES TO PROPRIETORS FUND
(RS.IN CRORES)
Years Shareholders fund Current Liabilities Ratio of Current
Liabilities to
Proprietors fund
2007 1.24 4.22 3.40
2008 1.38 4.71 3.41
2009 1.57 5.01 3.19
2010 1.83 6.99 3.82
2011 2.43 8.73 3.59
Source: Secondary data
INTERPRETATION:
The above table reveals that ratio of current liabilities to
Proprietors fund does not have same level of ratio. In 2008, the ratio has been
increased when compare to the previous year. But in 2009, the ratio has decreased.
Then again the ratio has started to increase in 2010 and decrease in 2011.
CHART 5.3.2
53
RATIO OF CURRENT LIABLITIES TO PROPRIETORS FUND
5.3.3 INTEREST COVERAGE RATIO
This ratio is also termed as Debt Service Ratio. This ratio is calculated
as follows:
EBIT
Interest Coverage Ratio = ______________________________________
Fixed Interest Charges
3.4
3.41
3.19
3.82
3.59
2.8
2.9
3
3.1
3.2
3.3
3.4
3.5
3.6
3.7
3.8
3.9
2007 2008 2009 2010 2011
R
s
.
I
n
C
r
o
r
e
s
Years
54
TABLE 5.3.3
INTEREST COVERAGE RATIO
(RS.IN CRORES)
Years EBIT Fixed Interest
Charges
Interest Coverage
Ratio
2007 0.18 0.83 0.22
2008 0.26 1.10 0.24
2009 0.28 1.44 0.19
2010 0.17 1.71 0.10
2011 0.21 1.76 0.12
Source: Secondary data
INTERPRETATION:
The above table reveals that ratio of current liabilities to
Proprietors fund does not have same level of ratio. In 2008, the ratio has been
increased when compare to the previous year. But in 2009, the ratio has decreased.
Then again the ratio has started to increase in 2010 and decrease in 2011.
CHART 5.3.3
INTEREST COVERAGE RATIO
55
5.3.4 DEBT EQUITY RATIO
This ratio expresses the relationship between outsiders fund and
shareholders fund.
Outsiders fund
Debt Equity Ratio = ________________________________________
Shareholders fund
Outsiders Funds: - These refer to long term liabilities which mature after one year.
These include Debentures, Mortgage Loan, Bank Loan, and Loan from Financial
institutions and Public Deposits etc.
Shareholders Funds: - These include Equity Share Capital, Preference Share
Capital, Share Premium, General Reserve, Capital Reserve, Other Reserve and
Credit Balance of Profit & Loss Account.
0.22
0.24
0.19
0.1
0.12
0
0.05
0.1
0.15
0.2
0.25
0.3
2007 2008 2009 2010 2011
R
s
.
I
n
C
r
o
r
e
s
Years
56
TABLE 5.3.4
DEBT EQUITY RATIO
(RS.IN CRORES)
Years Outsiders fund Shareholders
fund
Debt Equity
Ratio
2007 0.94 1.24 0.76
2008 0.94 1.38 0.68
2009 0.96 1.57 0.61
2010 1.47 1.83 0.80
2011 1.93 2.43 0.79
Source: Secondary data
INTERPRETATION:
The above table reveals that interest coverage ratio during the year 2007
was 0.76 and it is gradually decreasing to 0.68 and 0.61 in the next years. But in
2010, the ratio is increasing to 0.80. And again the ratio is decreasing to 0.79.
CHART 5.3.4
DEBT EQUITY RATIO
57
5.3.5 WORKING CAPITAL RATIO
This ratio shows the difference between the current assets and current
liabilities.
Working Capital Ratio = Current Assets Current Liabilities
TABLE 5.3.5
WORKING CAPITAL
(RS.IN CRORES)
Years Current Assets Current Liabilities Working Capital
2007 10.71 4.22 6.49
0.76
0.68
0.61
0.8
0.79
0
0.1
0.2
0.3
0.4
0.5
0.6
0.7
0.8
0.9
2007 2008 2009 2010 2011
R
s
.
I
n
C
r
o
r
e
s
Years
58
2008 12.83 4.71 8.12
2009 13.27 5.01 8.26
2010 16.24 6.99 9.25
2011 19.33 8.73 10.6
Source: Secondary data
INTERPRETATION:
The above table reveals that working capital has been increasing every
year. It shows this ratio have more value in the future.
CHART 5.3.5
WORKING CAPITAL
59
5.4 CASH FLOW STATEMENT
TABLE 5.4.1
CASH FLOW STATEMENT FOR THE YEAR ENDED 31
st
MARCH 2007
Particulars
Rs
March 31,
2007
Rs
6.49
8.12
8.26
9.25
10.6
0
2
4
6
8
10
12
2007 2008 2009 2010 2011
R
s
.
I
n
C
r
o
r
e
s
Years
60
A.CASH FLOW FROM OPERATING ACTIVITIES
Net profit before tax and extra ordinary items
Adjustments for :
Depreciation on Fixed Assets including
Least Adjustment charges
Provisions and Contingencies
Amortisation of premium on Held to Maturity Investments
Rights Issue Expenses
Operating profit before working capital changes Adjustment
for :
Advances & Other Assets
Investments
Deposits, Borrowings & Other Liabilities
Cash generated from operations
Direct taxes paid
Net cash flow from operating activities (A)
166,081
837,800
107,220
0
-16,552,492
4,509,462
9,484,091
2,730,376
1,111,101
3,841,477
-2,558,939
1,282,538
1,212,431
70,107
Source: Secondary data
INTERPRETATION:
The above table shows the performance of cash inflow and outflow of
March 31
st
2007, the total amount of deposits was 9,484,091. It evaluates the cash
inflow and outflow is based on deposits.
TABLE 5.4.2
CASH FLOW STATEMENT FOR THE YEAR ENDED 31
st
MARCH 2008
61
Particulars
Rs
March 31,
2008
Rs
A.CASH FLOW FROM OPERATING ACTIVITIES
Net profit before tax and extra ordinary items
Adjustments for :
Depreciation on Fixed Assets including
Least Adjustment charges
Provisions and Contingencies
Amortisation of premium on Held to Maturity Investments
Rights Issue Expenses
Operating profit before working capital changes Adjustment
for :
Advances & Other Assets
Investments
Deposits, Borrowings & Other Liabilities
Cash generated from operations
Direct taxes paid
Net cash flow from operating activities (A)
174,558
577,000
103,505
0
-12,493,493
-8,994,232
27,882,669
3,435,443
855,063
4,290,506
6,394,944
10,685,450
1,662,277
9,023,173
Source: Secondary data
INTERPREATION:
The above table shows the performance of cash inflow and outflow
of March 31
st
2008, the amount of deposits has been increased when compare to
March 31
st
2007.
TABLE 4.4.3
62
CASH FLOW STATEMENT FOR THE YEAR ENDED 31
st
MARCH 2009
Particulars
Rs
March 31,
2009
Rs
A.CASH FLOW FROM OPERATING ACTIVITIES
Net profit before tax and extra ordinary items
Adjustments for :
Depreciation on Fixed Assets including
Least Adjustment charges
Provisions and Contingencies
Amortisation of premium on Held to Maturity Investments
Rights Issue Expenses
Operating profit before working capital changes Adjustment
for :
Advances & Other Assets
Investments
Deposits, Borrowings & Other Liabilities
Cash generated from operations
Direct taxes paid
Net cash flow from operating activities (A)
198,281
805,000
119,484
0
-9,192,728
-26,504,345
31,663,643
4,061,484
1,122,765
5,184,249
-4,033,430
1,150,819
1,681,016
-530,197
Source: Secondary data
INTERPRETATION:
63
The above table shows the performance of cash inflow and outflow
of March31st 2009, the amount of deposits has been increased when compare to
March 31
st
2008.
TABLE 5.4.4
CASH FLOW STATEMENT FOR THE YEAR ENDED 31
st
MARCH 2010
Particulars
Rs
March 31,
2010
Rs
A.CASH FLOW FROM OPERATING ACTIVITIES
Net profit before tax and extra ordinary items
Adjustments for :
Depreciation on Fixed Assets including
Least Adjustment charges
Provisions and Contingencies
Amortisation of premium on Held to Maturity Investments
Rights Issue Expenses
Operating profit before working capital changes Adjustment
for :
Advances & Other Assets
Investments
Deposits, Borrowings & Other Liabilities
Cash generated from operations
Direct taxes paid
Net cash flow from operating activities (A)
221,451
710,830
288,649
0
-26,628,891
-10,412,005
37,932,753
1,930,483
1,220,930
3,151,413
891,857
4,043,270
1,025,830
3,017,440
64
Source: Secondary data
INTERPRETATION:
The above table shows the performance of cash inflow and outflow
of March31st 2010, the amount of deposits has been increased when compare to
March 31
st
2009.
TABLE 5.4.5
CASH FLOW STATEMENT FOR THE YEAR ENDED 31
st
MARCH 2011
Particulars
Rs
March 31,
2011
Rs
A.CASH FLOW FROM OPERATING ACTIVITIES
Net profit before tax and extra ordinary items
Adjustments for :
Depreciation on Fixed Assets including
Least Adjustment charges
Provisions and Contingencies
Amortisation of premium on Held to Maturity Investments
Rights Issue Expenses
Operating profit before working capital changes Adjustment
for :
Advances & Other Assets
Investments
Deposits, Borrowings & Other Liabilities
Cash generated from operations
Direct taxes paid
Net cash flow from operating activities (A)
229,918
1,203,520
71,445
0
-27,235,702
-15,603,686
34,360,220
2,354,458
1,504,883
3,859,341
8,479,168
-4,619,827
1,274,120
-5,893,947
65
Source: Secondary data
INTERPRETATION:
The above table shows the performance of cash inflow and outflow
of March31st 2011, the amount of deposits has been decreased when compare to
March 31
st
2010.
TABLE 5.4.6
NET CASH FLOW FROM OPERATING ACTIVITIES
(RS.IN
LAKHS)
Years Net Operating activities
2007 0.7
2008 90.23
2009 -5.3
2010 30.17
2011 -58.93
Source: Secondary data
INTERPRETATION:
The above table shows the deposits are one of the main factors of net
cash flow from operating activities. The cash inflow is based on the deposits. If the
amount of deposits increased, the net cash flow also increased.
CHART 5.4.1
NET OPERATING ACTIVITIES
66
5.5 CORRELATION
The correlation is one of the most common and most useful statistics. A
correlation is a single number that describes the degree of relationship between two
variables.
x x y y
x x
y y
TABLE 5.5.1
CORRELATION:
(RS.CRORES)
Years Deposits(x) Loans(y)
2007 14 10
2008 17 11
2009 20 12
0.7
90.23
-5.3
30.17
-58.93
-80
-60
-40
-20
0
20
40
60
80
100
2007 2008 2009 2010 2011
R
s
.
I
n
L
a
k
h
s
Years
67
2010 24 14
2011 27 17
Source: Secondary data
RESULT:
r = 0.98
INTERPRETATION:
The above calculation shows the positive correlation. So there is
significant relationship between two variables.
68
CHAPTER 6
SUMMRY , CONCLUSION ,FINDINGS AND SUGGESTIONS
6.1 FINDINGS
The deposits of Indian bank have been increasing every year
The highest net cash flow from operating activities is 90.23 lakhs in the year
2008 and the lowest net cash flow from operating activities -58.93 lakhs in
the year 2011
The percentage analysis helps to identify the percentage of demand deposits,
savings bank deposits and term deposits have been increasing every year
The percentage of savings bank deposits has been doubled in the year 2011
The current ratio of the bank from the year, 2007-2011 is to be above 2:1and
it is satisfactory
The highest ratio of current liabilities to proprietors fund is 3.82 crores in
the year 2010
The lowest interest coverage ratio is 0.10 crores in the year 2010
The highest debt equity ratio is 0.80 crores in the year 2010
The working capital of the bank have been increasing every year, so the bank
shall use the capital effectively
The result of correlation shows positive correlation.
69
6.2 SUGGESTIONS
The deposit schemes are showing an unconstructive sign. So the bank keeps
in control for the future period
The percentage analysis are essentially concerned with the identification of
significant accounting data relationships, which give the decision-maker
insights into the financial performance of a company
Ratio analysis has a major significance in analysing the financial
performance of a company over a period of time.
The bank shall improve their level of cash and bank balances because it is
playing a vital role for additional improvement
The result of correlation shows positive correlation. So there is a good
relationship between deposits and loans in the bank
6.3 CONCLUSION
The study is made on the topic deposit schemes by using financial tools & with five
years data at Karnataka bank Ltd. This tools used for the study helped in
determining the position of the concern consequently for the past five years. The
analysis of financial statements is a process of evaluating the relationship between
component parts of financial statements to obtain a better understanding of the
firms position and performance. The banks overall financial position is
satisfactory. The bank deposit schemes have been increasing year by year, so the
bank gets more growth in every year.
70
6.4 BIBLIOGRAPHY
Web sites
www.indianbank.com
www.wikipedia.org
www.google.com
Books referred
Basic Financial Management MY Khan & PK Jain
Financial Management Prasanna Chandra
Financial Accounting Jon Ben Hoyle & CJ Skender
Annual reports
Annual report 2006 2007
Annual report 2007 2008
Annual report 2008 2009
Annual report 2009 2010
Annual report 2010 2011
71
APPENDIX
INDIAN BANK (P) LTD
MARCH-11 MARCH-10 MARCH-09 MARCH-08 MARCH-07
CAPITAL AND
LIABILITIES
Capital
Reserves and
Surplus
Deposits
Borrowings
Other Liabilities
and Provision
1,882,004
22,408,866
273,364,463
10,863,339
8,411,403
1,339,861
16,987,632
237,306,488
3,416,403
11,301,159
1,215,847
14,454,423
203,332,853
39,728
9,535,209
1,213,533
12,582,500
170,161,923
1,421,955
8,018,267
1,213,533
11,172,744
140,374,354
4,207,383
5,257,148
TOTAL 316,930,075 316,930,075 270,351,543 228,578,060 193,398,178 162,225,1 316,930,075 270,351,543 228,578,060 193,398,178 162,225,16 270,351,543 228,578,060 193,398,178 162,225,162
ASSETS
Cash & balances
with RBI
Balances with
Banks and Money
at Call & Short
Notice
Investments
Advances
Fixed Assets
Other Assets
19,398,055
462,519
115,063,393
173,480,709
1,455,268
7,070,131
17,430,979
624,503
99,920,463
144,356,833
1,480,758
6,538,007
13,649,830
957,539
89,614,883
118,100,450
1,384,876
4,870,482
14,822,059
5,020,429
59,637,087
108,419,746
1,197,731
4,301,126
8,268,237
3,346,911
50,481,644
95,526,799
1,068,216
3,533,355
TOTAL 316,930,075 270,351,543 228,578,060 193,398,178 162,225,162
72
Contingent
Liabilities
90,358,016
9,628,992
101,192,384
10,322,427
100,427,447
9,289,287
69,590,090
7,646,757
34,279,000
6,728,849