A STUDY ON RATIO ANALYSIS AT AXIS BANK

KLE SOCIETY’S
INSTITUTE OF MANAGEMENT STUDIES AND RESEARCH, HUBLI

(Affiliated to Karnatak University, Dharwad &

Recognized by AICTE, New Delhi)
A PROJECT REPORT ON

“A STUDY ON RATIO ANALYSIS AT AXIS BANK”

SUBMITTED TO
KARNATAK UNIVERSITY, DHARWAD
FOR PARTIAL FULFILLMENT FOR REQUIREMENTS OF THE AWARD OF
MASTER OF BUSINESS ADMINISTRATION IN THE ACADEMIC YEAR
2019-2020

SUBMITTED BY
SOUMYA A LOKUR
MBA II SEMESTER
REG. NO: 19MBA144

INSTITUTE GUIDE
PROF. PRAMOD S G
KLE’S IMSR
Hubli

KLE Society’s Institute of Management Studies and Research, Hubli. Page 1

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

KLE SOCIETY’S
INSTITUTE OF MANAGEMENT STUDIES AND RESEARCH,
HUBLI

(Affiliated to Karnatak University, Dharwad &

Recognized by AICTE, New Delhi)

CERTIFICATE
This is to certify that MISS. SOUMYA A LOKUR, REG.NO: 19MBA144
has successfully completed her Summer In-plant Project on “A STUDY
ON RATIO ANALYSIS AT AXIS BANK” in the partial fulfilment of the
requirement of Master of Business Administration, during the
academic year 2019-2020 from 1stJune 2020 to 30th July 2020.

INSTITUTE GUIDE DIRECTOR

PROF. PRAMOD S G DR. P. B. ROODAGI
KLE’S IMSR KLE’S IMSR
HUBLI. HUBLI.

KLE Society’s Institute of Management Studies and Research, Hubli. Page 2

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

ACKNOWLEDGEMENT
It is a matter of great pleasure to acknowledge those personalities who have inspired,
guided and contributed immensely in bringing out this Project Report.

I express my sincere thanks to our Director Dr. P. B. Roodagi KLE’S IMSR, Hubli for
giving me an opportunity for learning.

I wish to take this opportunity to express my deep sense of gratitude to Prof. Pramod S G
for his valuable guidance in this Endeavour. He has been a constant source of inspiration. I
sincerely thank him for his suggestions and his help in successfully completing my project
report.

I would like to thank to my parents, my teaching and non-teaching faculties, my friends

and all those who have helped me directly or indirectly for the completion of this project
work.

Date: 31/07/2020 SOUMYA A LOKUR

Place: Hubli MBA II Semester

KLE Society’s Institute of Management Studies and Research, Hubli. Page 3

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

DECLARATION

I, SOUMYA A LOKUR, hereby declare that this project report entitled “A STUDY ON
RATIO ANALYSIS AT AXIS BANK” has been prepared by me during the year 2019-
2020, under the guidance of Prof. Pramod S G, Faculty, KLE’s Institute of
Management Studies and Research, Hubli. The project is towards partial fulfillment of
requirement for the award of Master of Business Administration Karnatak University,
Dharwad.

I confirm that this report truly represents my work undertaken as a part of my Summer
In-plant Project (SIP) this work is not a replication of work done previously by any other
person. I also confirm that the contents of the report and the views contained therein
have been collected and presented by me.

SOUMYA A LOKUR
Date: 31/07/2020
Roll No: 19MBA144
Place: Hubli

KLE Society’s Institute of Management Studies and Research, Hubli. Page 4

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

INDEX

Sl. Page
No. Content No.
1 Executive Summary 6

2 Research and methodology 8

3 Industry profile 12

4 Company profile 16

5 Introduction 24

6 Data analysis and interpretation 40

7 Findings 56

8 Suggestions 58

9 Conclusion 58

10 Annexure 59

11 80
Bibliography

KLE Society’s Institute of Management Studies and Research, Hubli. Page 5

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

EXECUTIVE SUMMARY

KLE Society’s Institute of Management Studies and Research, Hubli. Page 6

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

EXECUTIVE SUMMARY

This project is carried out in axis bank, is the third largest private sector Indian bank and
offer range financial product, the bank head office in Mumbai. It has 4800 branches. A
bank was founded in 1993. The project help to study the analysis of ratio in axis bank in
the past 10 years and to calculate the financial management performance.

Financial performance analysis is the process of identifying the financial strength and
weakness of the axis bank of the by properly establishing the relationship between the
item of balance sheet and profit and loss account. it also helps in short term and long
term forecasting and growth can be identified with help of financial performance
analysis. In order to evaluate to financial condition and performance analysis. In order
to evaluate to financial aspects. One of the widely used and powerful tools is ratio or
index

Ratio analysis is technique of interpretation of financial statement. It is technique of

calculating a number of accounting ratio from the data found in the financial statement,
the comparison of these financial ratio with those of the previous year. The project has
emphasized more on need and importance of ratio analysis .Ratio analysis carried out
using financial information for last five years. That is 2010-11 to 2019-20 turnover
ratio, liquidity ratio, Net profit ratio, Quick ratio ,debt equity share ratio ,has been
calculated and interpretation has been made.

KLE Society’s Institute of Management Studies and Research, Hubli. Page 7

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

PROJECT TITLE

“A STUDY ON RATIO ANALYSIS AT AXIS BANK”

OBJECTIVES

• To study and analyse the financial position of the bank through current ratio and
quick ratio analysis.
• To study and analyse the financial position of the bank through debt equity ratio
and interest coverage ratio.
• To determine the feasible solution to improve the overall efficiency of the AXIS
BANK.
• To study the organisation structure of the bank.

Need for the study.

Information for the study is to find out the solvency and operating performance of axis
bank for the last 10 years through analytical study of financial statement and ratio
analysis thereby give suggestion for improvement of profit and loss account overall
efficiency of the AXIS BANK.

Research methodology

Methodology

The quality of the project work depends on the methodology adapted for the study and
also it depends upon the nature of the project work. Use proper way of research
methodology is very essential part of any research. In order to conduct a study
scientifically, Suitable methods and measure are to be followed

KLE Society’s Institute of Management Studies and Research, Hubli. Page 8

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

Research design

The type of research used collection and analysis of the data historical data is Historical
research method. The main focus of this study is to determine the ratio analysis of axis
bank. The data regarding history and profile are collected through the study secondary
sources.

Source of data

• Information for study is collected from the balance sheet and profit and loss
account of the bank and website are also used to collect information.
• Data presentation
• The data collected and represented in the form of table graph.
• Data analysis and Interpretation
• The data collected and represented in the form of table and graph
• Data Analysis and Interpretation
• The data is analysis and interpreted with calculation of ratio.

Findings

Based on the above calculation, table, Graph the following, finding are made in study

1. Current ratio of a bank has a standard position only in the year of 2012 to
2013, because as per rule, the current ratio of 2:1 (or) more indicates highly
solvent position of firm.
2. Bank is having good liquidity position i.e.1.17 in the year of 2014 to 2015.
The quick ratio of 1:1 indicates satisfactory position of the firm.
3. Debt-equity ratio is greater than 1, then the bank assets are financed through
debt or if the ratio is less than 1, its assets are primarily financed through
equity. bank ratio is less than 1, from the year of 2011 to 2015. Hence the bank
assets are financed tough equity And 2016 to 2020 ratio is more than 1.
4. In the years of 2010-11,2012-13,2014-15 the interest expenses has incurred by
bank is greater than the earnings that bank have had to pay, but compare to

KLE Society’s Institute of Management Studies and Research, Hubli. Page 9

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

remaining years. However, the bank is easily able to meet the interest
obligation from profits.
5. Debt turnover ratio increases in the year 2010-11 is at 6.50, which decreases to
6.20 in the year 2014-15. But in the year 2011-12 to 2013-14, it decreases to
4.35, 3.85, 4.49. It indicates that debts are being collected more promptly and
more than increase in 2020 is at 1.53.
6. Net profit margin was less year by year its increasing . In the financial year
2010-11 the ratio0.12 it has been increased to 12.36 in the finacial year
2011-12 and scaled down to 12.15 to in the finacial year 2012-13 and scaled
up to 13.5 in the finacial year 2014-15.and again it came down to 0.14 in the
finacial year 2016-17and also came in down 0.24 in the finacial year 2019-20.
7. The operating ratio was 0.675 in the FY 2010-11 in the FY 2011-12 the ratio
was unchanged that is 1.9 and in the FY 2012-19 it scaled down and 2019-20
net sales has been increased it was 1.1.
8. Assets turnover ratio was 3.3 in the Fy 2010-11and increased to the 0.4 in
the finacial year 2011-12 and increase to 4.4 in the FY 2013-14.and decreased
to 0.1 in the FY 2019-20.
9. Credit turnover ratio was 4.63 in FY 2010-11 and decreased to 4.11 in the FY
2011-12,and increase in the ratio was 4.85 in the FY 2014-15 and decreased to
the 0.9 in the FY 2019-20.
10. Invesment deposit ratio was 1.7 in the FY 2010-11 and it decreased in the
finacial year 2011-14 And increased to 3.5 in the finacial year 2015-16 and
also increased FY 2019-2020.
11. The divdent payout ratio was 0.3 in the FY 2010-11,and increased to 0.4 in the
FY 2011-12 and FY 2012-13,13-14.14-15 Inceased and decreased 2013-
14,15.and in the year 2018-19 the ratio was 0.4 and year 2019-20 decreased
the ratio was 0.11.

12. Cash deposit ratio was 0.8 in the FY 2010-11, and increased to 1.0 in the FY
2011-12 and increased to 1.6 in the FY 2012-13 and increased to1.4 in the
FY2016-17and decreased to 0.9 in the FY 2019-20.
13. The earning Retention ratio was 1.6 in the FY 2010-11 and decreased the ratio
to 0.16 in the year 2015-16 and increased to 1.06 in the FY 2016-17.and
increased to 2.2 in the FY 2019-20.

KLE Society’s Institute of Management Studies and Research, Hubli. Page 10

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

14. The credit turnover ratio was 4.63 and decreased to 4.11 in the FY 2011-12,
and increase in the ratio was 4.85 in the FY 2014-15 and decreased to the 0.9
in the FY 2019-20.
15. Capital adquency ratio was 0.5 in the FY 2010-11.and Increse to 1.6 in the FY
2012-13,and decrease to ratio 0.9 in the FY 2019-20.The above table show that
the retained earning Retention ratio was 1.6in the FY 2010-11 and decreased
the ratio to 0.16 in the year 2015-16.and increased to 1.06in the FY 2016-17
and increased to 2.2 in the FY2019-20

Suggestions

1. Current ratio is a below satisfactory level, it shows the current assets are
insufficient, so needs to be improved.
2. Assets turnover ratio is decreasing that will reduce net sales and average total
assets, so needs to be improved.

Conculsion
1. Study on ratio analysis of axis bank the performance in terms of finacial, it
observed the performance of the bank is fuluting in these 10 years
2. Ratio analysis examine past and current finacial data for the purpose of evaluting
performance and estamating future risk and potentional.

Limtation of the study

1. The study is limted to only years of finacial statement
2. The interpretation is made is based on the data availble from the annaual report
of the axis bank.
3. Time avaible is only two months.

KLE Society’s Institute of Management Studies and Research, Hubli. Page 11

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

INDUSTRY PROFILE

KLE Society’s Institute of Management Studies and Research, Hubli. Page 12

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

INDUSTRY PROFILE

The bank was founded in December 1993 as UTI Bank, opening its registered
office in Ahmedabad and corporate office in Mumbai. UTI Bank began its operations in
1993, after the Government of India allowed new private banks to be established. The
bank was promoted in 1993 jointly by the Administrator of the Unit Trust of India
(UTI-I),[11] Life Insurance Corporation of India (LIC), General Insurance Corporation,
National Insurance Company, The New India Assurance Company, The Oriental
Insurance Corporation and United India Insurance Company. The first branch was
inaugurated on 2 April 1994 in Ahmedabad by Dr. Manmohan Singh, the then finance
minister of India.

• In 2001 UTI Bank agreed to merge with Global Trust Bank, but the Reserve
Bank of India (RBI) withheld approval and the merger did not happen. In 2004,
the RBI put Global Trust into moratorium and supervised its merger with
Oriental Bank of Commerce.
• In 2003, UTI Bank became the first Indian bank to launch a travel currency card.
In 2005, it was listed on London Stock Exchange
• UTI Bank opened its first overseas branch in 2006 in Singapore. That same year
it opened an office in Shanghai, China. In 2007, UTI Bank opened a branch in
the Dubai International Financial Centre and branches in Hong Kong. In 2008, it
opened an office in Dubai.
• On 30 July 2007, UTI Bank changed its name to Axis Bank.
• In 2009, Shikha Sharma was appointed as the MD and CEO of Axis Bank.
• Axis Bank opened a branch in Colombo, Sri Lanka in October 2011, as a
Licensed Commercial Bank supervised by the Central Bank of Sri Lanka. Also,
in 2011, Axis Bank opened an office in Abu Dhabi. In 2011, Axis bank
inaugurated Axis House, its new corporate office in World, Mumbai.
• In 2013, Axis Bank's subsidiary, Axis Bank UK commenced banking operations.
Axis Bank UK has a branch in London.
• Bollywood actress Deepika Padukone is the brand ambassador of Axis Bank.
• In 2014, Axis Bank launched its first ‘All Women Branch’ in Patna.
• In 2015, Axis Bank opened an office in Dhaka.

KLE Society’s Institute of Management Studies and Research, Hubli. Page 13

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

• On January 1, 2019, Amitabh Chaudhry took over as MD and CEO.

• As of 31 March 2016, the bank has over 50,001 employees.

Objective of axis bank

• To study about the company profile

• To study the present and past financial system of axis bank
• To offer appropriate suggestion for better performance of organization
• It helps in simplification of accounting
• To determine profitability liquidity ratio.

Service rendered by axis bank

• Mutual fund
• Demat account
• Online trading

Insurance service

• Life Insurance
• Home insurance
• Motor Insurance
• Health Insurance

Investment

• Online Trading
• Mutual Funds
• Fixed insurance
• Depositary services

Loans

• Home Loans
• Personal Loans

KLE Society’s Institute of Management Studies and Research, Hubli. Page 14

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

• Loan against property

Accounts

• Easy Access Account

• Primary savings Account
• Salary Account
• Women saving account.

KLE Society’s Institute of Management Studies and Research, Hubli. Page 15

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

COMPANY PROFILE

KLE Society’s Institute of Management Studies and Research, Hubli. Page 16

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

COMPANY PROFILE

Axis bank is the third largest private sector bank in India . axis bank entire specutrum of
financial service financial service to customer segment covering Large and mid
corporate , SME, Agriculture and Retail Business. Axis Bank Limited provides a suite
of corporate and retail banking products. The Bank operates through four segments:
Treasury, Retail Banking, Corporate/Wholesale Banking and Other Banking Business.
Its Treasury operations include investments in sovereign and corporate debt, equity and
mutual funds, trading operations, derivative trading and foreign exchange operations on
the proprietary account and for customers. Its Retail Banking constitutes lending to
individuals/small businesses and activities include liability products, card services,
Internet banking, mobile banking and financial advisory services among others. Its
Corporate/Wholesale Banking includes corporate relationships not included under
Retail Banking, corporate advisory services, placements and syndication, project
appraisals, capital market related services and cash management services. Its Other
Banking Business includes Para banking activities, such as third-party product
distribution and other banking transactions.

Axis Bank is the third largest private sector bank in India. The Bank offers the entire
spectrum of financial services to customer segments covering Large and Mid-Corporate,
MSME, Agriculture and Retail Businesses.

The Bank has a large footprint of 2589 domestic branches (including extension
counters) and 12,355 ATMs spread across the country as on 31st March 2015. The
overseas operations of the Bank are spread over nine international offices with branches
at Singapore, Hong Kong, Dubai (at the DIFC), Colombo and Shanghai; representative
offices at Dhaka, Dubai, Abu Dhabi and an overseas subsidiary at London, UK. The
international offices focus on corporate lending, trade finance, syndication, and
investment banking and liability businesses.

Axis Bank is one of the first new generation private sector banks to have begun
operations in 1994. The Bank was promoted in 1993, jointly by Specified Undertaking
of Unit Trust of India (SUUTI) (then known as Unit Trust of India), Life Insurance
Corporation of India (LIC), General Insurance Corporation of India (GIC), National

KLE Society’s Institute of Management Studies and Research, Hubli. Page 17

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

Insurance Bank Ltd., The New India Assurance Bank Ltd., The Oriental Insurance Bank
Ltd. and United India Insurance Bank Ltd. The share holding of Unit Trust of India was
subsequently transferred to SUUTI, an entity established in 2003.

With a balance sheet size of Rs. 4, 61,932crores as on 31st March 2015, Axis Bank has
achieved consistent growth and stable asset quality with a 5 year CAGR (2010-11 to
2014-15) of 21% in Total Assets, 18% in Total Deposits, 22% in Total Advances and
24% in Net Profit.

Retail banking

The Bank aims to increase its share in the financial services sector by continuing to
build a strong retail franchise. The segment continues to be one of the key drivers of the
Bank’s growth strategy, encompassing a wide range of products delivered through
multiple channels to customers. The Bank offers a complete suite of products across
deposits, loans, investment solutions, payments and cards and is committed to
developing long-term relationships with its customers by providing high-quality
services.

The Bank pursues an effective customer segmentation strategy, the success of which is
reflected in the fact that Savings Bank deposits grew at a Compounded Annual Growth
Rate (CAGR) of 26.13% over the last five years. During the year, Savings Bank
deposits grew 23.44% to Rs. 63,778 cores from Rs. 51,668 cores last year. On a daily
average basis, Savings Bank deposits grew 20.26% to Rs. 52,243 crores. The Bank has
also maintained its approach in increasing the proportion of Retail Term Deposits. On
the 31st March 2013, retail term deposits grew 24.37% year-on-year to Rs. 59,531
crores, constituting 42.37% of total term deposits, compared to 37.20% last year.
Likewise, the Bank continued to focus on increasing its share of retail loans in total
advances. The retail loans of the Bank grew 43.62% to Rs. 53,960 crores as on 31st
March 2013 from Rs. 37,570 crores last year. Retail loans constituted 27.40% of the
Bank’s total advances as on 31st March 2013, compared to 22.13% last year of which
secured loans accounted for 87%. The distribution of specific portfolios within the
Retail loan segment as on 31st March 2013 was as follows: home loans - 65%, loans
against property - 7%, auto loans - 14%, personal loans and credit cards - 9%.

KLE Society’s Institute of Management Studies and Research, Hubli. Page 18

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

Business banking:

Business Banking offers transactional banking services, leveraging upon the Bank’s
network and technology. Its initiatives focus on procurement of low-cost funds by
offering a range of current account products and cash management solutions across all
business segments covering corporates, institutions, central and state government
ministries and undertakings as well as small and retail business customers. Product
offerings of this business segment aim at providing customized transactional banking
solutions to fulfill customer’s business requirement. Cross-sell of transactional banking
products, product innovation and a customer-centric approach have succeeded in
growing current account balances and realization of transaction banking fees. As on
31st March 2013, balances in current accounts increased by 21.55% and stood at Rs.
48,322 crores compared to Rs. 39,754 crores last year. On a daily average basis, current
accounts balances grew by 4.73% to Rs. 28,698 crores compared to Rs. 27,403 crores
last year.

In the cash management services (CMS) business, the Bank focuses on offering
customized service to its customer to cater to specific corporate requirements and
improve the existing product line to offer enhanced features to customers. The Bank is
also focusing on host-to-host integration for both collections and payments, such as IT
integration between corporates and the Bank for seamless transactions and information
flow. The Bank provides comprehensive structured MIS reports on a periodic basis, for
better accounting and reporting. CMS continued to constitute an important source of fee
income and contributed significantly to generate low cost funds. The Bank is one of the
top CMS providers in the country with the number of locations covered under CMS
increased to 890 from 801 last year. The number of CMS clients has grown to 15,818
from 11,548 last year.

Corporate credit:

In the backdrop of a subdued macro-economic environment, capital expenditure by

corporates remained lackluster during the year. Loans for working capital and the

KLE Society’s Institute of Management Studies and Research, Hubli. Page 19

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

drawdown on committed sanctions in existing projects under implementation

contributed to the growth in corporate credit during the year. The corporate credit
portfolio of the Bank comprising advances to large and mid-corporates including
infrastructure) grew 7.89% to Rs. 98,239 crores from Rs. 91,053 crores last year. This
includes advances at overseas branches amounting to Rs. 29,972 crores (equivalent to
USD 5.52 billion) comprising mainly the portfolio of Indian corporates and their
subsidiaries as also trade finance. The advances at overseas branches accounted for
15.22% of total advances. The Bank’s infrastructure business includes project and bid
advisory services, project lending, debt syndication, project structuring and due
diligence, securitization and structured finance.

International banking:

The international operations of the Bank have generally catered to Indian corporates
who have expanded their business overseas. The overseas network of the Bank currently
spans the major financial hubs in Asia. The Bank now has a foreign network of four
branches at Singapore, Hong Kong, DIFC-Dubai and Colombo (Sri Lanka), and three
representative offices at Shanghai, Dubai and Abu Dhabi, besides strategic alliances
with banks and exchange houses in the Gulf Co-operation Council (GCC) countries.
While branches at Singapore, Hong Kong, DIFC-Dubai and Colombo enable the Bank
to partner with Indian corporates doing business globally and primarily offer corporate
banking, trade finance, treasury and risk management solutions, the Bank also offers
retail liability products from its branches at Hong Kong and Colombo. The
representative offices and strategic alliances with banks and exchange houses in the
GCC countries cater to the large Indian diaspora and promote the Bank’s NRI products.
With management of liquidity being a major challenge in the present global markets, the
Bank consciously restrained its asset growth at the overseas centres to report an asset
size of USD 6.84 billion as at 31st March 2013 vis-à-vis USD 6.35 billion as at 31st
March 2012. Further, interactions are also in progress with China Banking Regulatory
Commission (CBRC) for upgrade of the Shanghai Representative Office into a branch.

KLE Society’s Institute of Management Studies and Research, Hubli. Page 20

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

Information technology:

Technology is one of the key enablers for business and for delivering customised
financial solutions. The Bank continued to focus on introducing innovative banking
services through investments in scalable, robust and function-rich technology platforms
to enable delivery of efficient and seamless services across multiple channels for
customer convenience and cost reduction. The Bank has also focused on improving the
governance process in IT. During the year, the Bank has received certification of ISO
27001:2005 by BSI (ANAB accredited) for complying with the standards of
Information Security Management System for its data centres located in Navi Mumbai
and Bengaluru. The Bank has also successfully completed migration of its data centre to
a co-hosted location during the year. The new premises offer a category IV data center
that complies with the highest benchmarking standards applicable to data centres
promising built-in redundancy of infrastructure. A robust Project Management
framework is used to ensure that investments in IT are based on good gate-keeping
principles and result in appropriate payback in value terms.

SWOT ANALYSIS:
Strengths

• Axis bank has been given the rating as one of top three positions in terms of fastest
growth in private sector banks
• Financial express has given number two position and BT-KPMG has rated AXIS bank
as the best bank with some 26 parameters
• The bank has a network of 1,493 domestic branches and 8,324 ATMs
• The bank has its presence in 971 cities and towns
• The banks financial positions grow at a rate of 20% every year which is a major positive
sign for any bank
Weaknesses
• High bank service charge
• Limited credit period
• High Target for operation staff

KLE Society’s Institute of Management Studies and Research, Hubli. Page 21

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

Opportunities

• Bank insurance service

• Associate professionality guided student

Threats

• Competition
• Net Services
• Decentralized management.
• No proper facilities to uneducated people

COMPANY PROFILE

AXIS BANK

Type public

Industry Banking Financial Service

Founded 1994

Headquarter Mumbai, India

Key people Adarsh Kishore(chairman)

product Investment Banking

Revenue • 13,745,04 crores (2009)

KLE Society’s Institute of Management Studies and Research, Hubli. Page 22

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

BORAD OF DIRECTOR

PERSON DESIGNATION

Dr. Sanjiv Mishra Chairman

Shika sharna Managing Director& CEO

Som mitatal Director

Rohit Bhagat Director

Inreena Vittal Director

K N Prithviraj Director

V. R. Kaundinya Director

S B Mathur Director

Prasad Menon Director

Rabnidranath Bhattacharyya Director

Prof. Samir k barua Director

A k Dasgupta Director

Varadrajan Srinivasan ED Corporate Banking

Somnath Sengupta ED, Corporate Center

KLE Society’s Institute of Management Studies and Research, Hubli. Page 23

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

INTRODUCTION

KLE Society’s Institute of Management Studies and Research, Hubli. Page 24

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

INTRODUCTION

A ‘ratio’ is defined as the indicated quotient of two mathematical expressions

and as the relationship between two or more things. In Financial analysis, a ratio is used
as benchmark for evaluating the financial position and performance of a firm. Ratios
help to summarize large quantities of financial data and to make qualitative judgment
about the firm’s financial performance.

Ratio analysis involves comparison for a useful interpretation of the financial

statements. Single ratio in itself does not indicate favorable or unfavorable condition.
Absolute figures expressed in financial statements by themselves are meaningfulness.
These figures often do not convey much meaning unless expressed in relation to other
figures. Thus, it can be say that the relationship between two figures, expressed in
arithmetical terms is called a ratio.

FOCUS OF THE STUDY

• To know the liquidity position and solvency

• To study the profitability of axis bank

OBJECTIVES OF RATIO ANALYSIS

1 It is helpful in analysis of financial statement.

2 It helps in simplification of accounting data.
3 Helpful in comparative studies.
4 It helps in locating weak spots of the business.
5 Helpful in forecasting.
6 Estimate about trends in business
7 To have effective control.

LIMATIONS OF RATIO ANAYLSIS

1 False accounting data gives false ratio

2 Comparisons not possible of different firms adopt different
3 Accounting policies.
4 Ratio analysis becomes less effective due to price level change.

KLE Society’s Institute of Management Studies and Research, Hubli. Page 25

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

5 Ratios may be misleading in the absence of absolute data.

6 Limited use of a single Ratio.
7 Window-Dressing
8 Lack of proper standards.

ADVANTAGES OR USES OF RATIO ANALYSIS

1. Helpful in analysis of financial statements.

2. Simplification of accounting data.
3. Helpful in comparative study.
4. Helpful in locating the weak spots of the business.
5. Helpful in forecasting
6. Estimate about the trend of the business
7. Fixation of ideal standards
8. Effective control
9. Study of financial soundness.

RATIO

A ratio is a simple arithmetical expression of the relationship of one number to

another. It may be defined as the indicated quotient of two mathematical expressions.
ratio is one number expressed in terms of another and can be worked out by dividing
one number into the other.

TYPES OF RATIO

There are four types of ratio which is used for calculating the firm financial
position:

KLE Society’s Institute of Management Studies and Research, Hubli. Page 26

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

1. LIQUIDITY RATIOS

Liquidity ratios measure the ability of the firm to meet its current obligations. It
is necessary to strike a proper balance between high liquidity and lack of liquidity. A
high degree of liquidity means that a firms fund will be unnecessarily tied up in current
assets. Whereas lack of liquidity, implies failure of a company to meet its obligations
due to lack of sufficient liquidity.

Liquidity ratios are of two types

Current ratio

Quick ratio

Current ratio

Current ratio is calculated by dividing current assets by current liabilities:

Current ratio= Current Assets-Current Liabilities

KLE Society’s Institute of Management Studies and Research, Hubli. Page 27

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

Quick Ratio

Quick ratio establishes a relationship between quick or liquid assets and current
liabilities

Quick Ratio = Current Assets – Inventory-prepaid expenses

Current Liabilities

2. ACTIVITY RATIOS

Activity Ratios are used to evaluate the efficiency with which the firm manages
and utilizes its assets. These ratios are also called turnover ratios as they indicate the
speed with which the firm manages and utilizes its assets.

Activity ratio are of four types

Inventory Turnover ratio

Debtors Turnover Ratio

Current Assets and Net Working Capital Turnover Ratio

Creditors turnover Ratio

Inventory Turnover Ratio

Inventory Turnover = Sales / Average Inventor

• Debtors Turnover Ratio

• Debtors Turnover
• Collection Period

Debtors Turnover = Net credit sales / Average debtor

Collection Period = Debtors x no of Gross Sales

KLE Society’s Institute of Management Studies and Research, Hubli. Page 28

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

Current Assets and net working capital turnover ratio

This ratio shows the efficiency with which the firm is utilizing its current assets.

Current Assets Turnover = Sales / Current Assets

Net working capital turnover ratio = Sales / Net Working Capital

Creditors turnover ratio

Creditors turnover = Net credit purchase / Average Creditors

3. PROFITABILITY RATIO

A company should earn profits to survive and grow over a long period of time. Profit is
the measurement of the efficiency of the business.

Generally there are two types of profitability ratios calculated:

• Profitability in relation to sales.

• Profitability in relation to investment.

Profitability ratio are of four types

Gross profit ratio

Net Profit Ratio

Operating profit ratio

Return on Equity (ROE)

Gross profit ratio:

Gross Profit Ratio = Gross Profit / Net Sales*100

Net Sales = Sales – Sales Return

KLE Society’s Institute of Management Studies and Research, Hubli. Page 29

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

Net Profit Ratio:

Net Profit Ratio = Net profit/net sale*100

Operating profit ratio:

Operating Profit Ratio = Operating net profit /Net sale *100

Operating net profit = net profit + non-operating expenses-non operating income

Return on Equity (ROE):

Equity Shareholder’s Funds = Equity Share Capital + All Reserves + P/L a/c balance -
fictitious assets - debit balance of the P/L a/c.

Rate of return:

Profit before tax, interest and dividends

Return on invest = preference dividend / Net worth *100

Profit before interest, tax and dividend = Profit after interest but before tax + interest
paid - interest income

4. LEVERAGE RATIOS

Long term creditors like the debentures holders; financial institutions etc. are interested
in the firm’s long-term financial strength. These ratios are calculated to assess the
ability of the firm to meet its long-term liability as and when they become due.

Leverage ratio are of two types:

Debt-Equity Ratio

Proprietary Ratio

Debt-Equity Ratio:

KLE Society’s Institute of Management Studies and Research, Hubli. Page 30

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

Debt Long Term Loans

Debt Equity Ratio = OR

Equity Shareholder’s Funds

Long-term Loans: - Debentures + Mortgage Loans + BMU Loan+ Loan from Financial
Institutions and Public Deposits.

Shareholders’ Funds: - Equity Share Capital + Preference Share Capital + Share

Premium + General Reserves + Capital Reserves + Credit Balance of Profit and Loss
Accounts and Accumulated Losses and Fictitious Assets are deducted.

Proprietary Ratio:

Propriety ratio: Equity Shareholder’s Funds/ Debt + Equity

Classifications of Ratios

The use of ratio analysis is not confined to financial manager only. There are
different parties interested in the ratio analysis for knowing the financial position of a
firm for different purposes. Various accounting ratios can be classified as follows:

1. Traditional Classification

2. Functional Classification

3. Significance ratios\

1. Traditional Classification

It includes the following.

• Balance sheet (or) position statement ratio: They deal with the relationship
between two balance sheet items, e.g. the ratio of current assets to current
liabilities etc., both the items must, however, pertain to the same balance sheet.
• Profit & loss account (or) revenue statement ratios: These ratios deal with the
relationship between two profit & loss account items, e.g. the ratio of gross
profit to sales etc.,

KLE Society’s Institute of Management Studies and Research, Hubli. Page 31

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

• Composite (or) inter statement ratios: These ratios exhibit the relation between a
profit & loss account or income statement item and a balance sheet items, e.g.
stock turnover ratio, or the ratio of total assets to sales.

2. Functional Classification

These include liquidity ratios, long term solvency and leverage ratios, activity
ratios and profitability ratios.

3. Significance ratios

Some ratios are important than others and the firm may classify them as primary
and secondary ratios. The primary ratio is one, which is of the prime importance to a
concern. The other ratios that support the primary ratio are called secondary ratios.

In The View of Functional Classification the Ratios Are:

1. Liquidity ratio

2. Leverage ratio

3. Activity ratio

4. Profitability ratio

1. Liquidity Ratios

Liquidity refers to the ability of a concern to meet its current obligations as & when
there becomes due. The short term obligations of a firm can be met only when there are
sufficient liquid assets. The short term obligations are met by realizing amounts from
current, floating (or)circulating assets The current assets should either be calculated
liquid (or)near liquidity. They should be convertible into cash for paying obligations
of short term nature. The sufficiency (or) insufficiency of current assets should be
assessed by comparing them with short-term current liabilities. If current assets can pay
off current liabilities, then liquidity position will be satisfactory. To measure the
liquidity of a firm the following ratios can be calculated

• Current ratio

KLE Society’s Institute of Management Studies and Research, Hubli. Page 32

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

• Quick (or) Acid-test (or) Liquid ratio

• Absolute liquid ratio (or) Cash position ratio

(a) Current Ratio:

Current ratio may be defined as the relationship between current assets and
current liabilities. This ratio also known as Working capital ratio is a measure of general
liquidity and is most widely used to make the analysis of a short-term financial position
(or) liquidity of a firm.

Current Ratio = Current asset / Current liabilities

(b) Quick Ratio

Quick ratio is a test of liquidity than the current ratio. The term liquidity refers to
the ability of a firm to pay its short-term obligations as &when they become due. Quick
ratio may be defined as the relationship between quick or liquid assets and current
liabilities. An asset is said to be liquid if it is converted into cash within a short period
without loss of value.

Quick Ratio = Quick or liquid asset / Current liabilities

(c) Absolute Liquid Ratio

Although receivable, debtors and bills receivable are generally more liquid than
inventories, yet there may be doubts regarding their realization into cash immediately or
in time. Hence, absolute liquid ratio should also be calculated together with current ratio
and quick ratio so as to exclude even receivables from the current assets and find out the
absolute liquid assets.

Absolute Liquid Ratio = Absolute liquid assets / Current liabilities

/ Current liabilities
KLE Society’s Institute of Management Studies and Research, Hubli. Page 33
 A STUDY ON RATIO ANALYSIS AT AXIS BANK

Absolute liquid assets include cash in hand etc. The acceptable forms for this ratio is
50% (or) 0.5:1 (or) 1:2 i.e., Rs.1 worth absolute liquid assets are considered to pay Rs.2
worth current liabilities in time as all the creditors are nor accepted to demand cash at
the same time and then cash may also be realized from debtors and inventories.

2. Leverage Ratios

The leverage or solvency ratio refers to the ability of a concern to meet its long
term obligations. Accordingly, long term solvency ratios indicate firm’s ability to meet
the fixed interest and costs and repayment schedules associated with its long term
borrowings.

The following ratio serves the purpose of determining the solvency of the
concern.

(a) Debt-to-equity ratio

Debt-to-equity ratio is the key financial ratio and is used as a standard for
judging a bank's financial standing. It is also a measure of a bank's ability to repay its
obligations. When examining the health of a bank, it is critical to pay attention to the
debt/equity ratio. If the ratio is increasing, the bank is being financed by creditors rather
than from its own financial sources which may be a dangerous trend. Lenders and
investors usually prefer low debt-to-equity ratios because their interests are better
protected in the event of a business decline. Thus, companies with high debt-to-equity
ratios may not be able to attract additional lending capital.

Debt-to-equity ratio = Long-time debt/ Shareholders fund

/ Current liabilities

(b) Fixed asset to long term funds ratio

A fixed asset to equity ratio measures the contribution of stockholders and the
contribution of debt sources in the fixed assets of the bank. It is computed by dividing
the fixed assets by the stockholders’ equity.

Other names of this ratio are fixed assets to net worth ratio and fixed assets to
proprietors fund ratio.

KLE Society’s Institute of Management Studies and Research, Hubli. Page 34

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

Fixed asset to long term

funds ratio = Fixed assets/ Long-terms funds

/ Current liabilities
(c) Interest cover ratio

The interest coverage ratio (ICR) is a measure of a bank's ability to meet its
interest payments. Interest coverage ratio is equal to earnings before interest and taxes
(EBIT) for a time period, often one year, divided by interest expenses for the same time
period. The interest coverage ratio is a measure of the number of times a bank could
make the interest payments on its debt with its EBIT. It determines how easily a bank
can pay interest expenses on outstanding debt.

Interest coverage ratio is also known as interest coverage, debt service ratio or
debt service coverage ratio.

Interest cover ratio = PBIDT/ Interest

/ Current liabilities
(d) Debit service

amount of cash flow available to meet annual interest and principal payments on debt,
coverage ratio

In corporate finance, it is the including sinking fund payments.

In government finance, it is the amount of export earnings needed to meet

annual interest and principal payments on a country's external debts.

In personal finance, it is a ratio used by bank loan officers in determining

income property loans. This ratio should ideally be over 1. That would mean the
property is generating enough income to pay its debt obligations.

KLE Society’s Institute of Management Studies and Research, Hubli. Page 35

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

(PAT+Depreciation+ Interest
Loan)/ (Interest on loan+ loan
Debt service coverage ratio =
repayment in a year)

4. Asset management Ratio

Asset management (turnover) ratios compare the assets of a bank to its sales
revenue. Asset management ratios indicate how successfully a bank is utilizing its assets
to generate revenues. Analysis of asset management ratios tells how efficiently and
effectively a bank is using its assets in the generation of revenues. They indicate the
ability of a bank to translate its assets into the sales. Asset management ratios are also
known as asset turnover ratios and asset efficiency ratios

(a) Inventory turnover ratio

Inventory turnover is a measure of the number of times inventory is sold or used

in a given time period such as one year. It is a good indicator of inventory quality
(whether the inventory is obsolete or not), efficient buying practices, and inventory
management. This ratio is important because gross profit is earned each time inventory
is turned over. it is also called as stock turnover.

Inventory turnover ratio = Cost of goods sold/ Average inventory

/ Current liabilities
(b) Debtors turnover ratio

The receivable turnover ratio (debtor’s turnover ratio, accounts receivable

turnover ratio) indicates the velocity of a bank’s debt collection, the number of times
average receivables are turned over during a year. This ratio determines how quickly a
bank collects outstanding cash balances from its customers during an accounting period.
It is an important indicator of a bank’s financial and operational performance and can be
used to determine if a bank is having difficulties collecting sales made on credit.

Debtor’s turnover ratio = Credit sales/ Average debtors

/ Current liabilities

KLE Society’s Institute of Management Studies and Research, Hubli. Page 36

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

(c) Creditor’s turnover ratio

This ratio is similar to the debtor’s turnover ratio. It compares creditors with the
total credit purchases.

It signifies the credit period enjoyed by the firm in paying creditors. Accounts
payable include both sundry creditors and bills payable. Same as debtor’s turnover ratio,
creditor’s turnover ratio can be calculated in two forms, creditors’ turnover ratio and
average payment period.

Creditor’s turnover ratio = Credit purchase/ Average creditors

(d) Fixed asset turnover ratio

/ Current liabilities
Fixed asset turnover ratio compares the sales revenue a bank to its fixed assets. This
ratio tells us how effectively and efficiently a bank is using its fixed assets to generate
revenues. This ratio indicates the productivity of fixed assets in generating revenues. If
a bank has a high fixed asset turnover ratio, it shows that the bank is efficient at
managing its fixed assets. Fixed assets are important because they usually represent the
largest component of total assets.

Fixed asset turnover ratio = Sales/ Fixed assets

(e) Total asset turnover ratio

/ Current liabilities
Asset turnover ratio is the ratio of a bank’s sales to its assets. It is an efficiency
ratio which tells how successfully the bank is using its assets to generate revenue.

Total asset turnover ratio = Sales/ Total assets

(f) Working capital turnover ratio

/ Current liabilities
The working capital turnover ratio measures how well a bank is utilizing its
working capital to support a given level of sales. Working capital is current assets minus
current liabilities. A high turnover ratio indicates that management is being extremely
efficient in using a firm’s short-term assets and liabilities to support sales. Conversely, a
low ratio indicates that a business is investing in too many accounts receivable and

KLE Society’s Institute of Management Studies and Research, Hubli. Page 37

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

inventory assets to support its sales, which could eventually lead to an excessive amount
of bad debts and obsolete inventory.

Sales/ working capital

Working capital turnover ratio = (Or)

/ Current liabilities
Sales/ Net current assets

/ Current liabilities
5. Profitability Ratios

Profitability ratios measure a bank’s ability to generate earnings relative to sales,

assets and equity. These ratios assess the ability of a bank to generate earnings, profits
and cash flows relative to relative to some metric, often the amount of money invested.
They highlight how effectively the profitability of a bank is being managed.

(a) Gross profit margin

Gross profit margin (gross margin) is the ratio of gross profit (gross sales less
cost of sales) to sales revenue. It is the percentage by which gross profits exceed
production costs. Gross margins reveal how much a bank earns taking into
consideration the costs that it incurs for producing its products or services. Gross margin
is a good indication of how profitable a bank is at the most fundamental level, how
efficiently a bank uses its resources, materials, and labor. It is usually expressed as a
percentage, and indicates the profitability of a business before overhead costs; it is a
measure of how well a bank controls its costs.

Gross profit margin = (Sales- cost of goods sold/ sales) *100

/ Current liabilities

KLE Society’s Institute of Management Studies and Research, Hubli. Page 38

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

(b) Net Profit margin

Net profit margin (or profit margin, net margin, return on revenue) is a ratio of
profitability calculated as after-tax net income (net profits) divided by sales (revenue).
Net profit margin is displayed as a percentage. It shows the amount of each sales dollar
left over after all expenses have been paid.

Net profit margin = (PBIT/ sales) *100

/ Current liabilities
(c) Return on capital employed

Return on capital employed (ROCE) is a measure of the returns that a business is

achieving from the capital employed, usually expressed in percentage terms. Capital
employed equals a bank's Equity plus Non-current liabilities (or Total Assets − Current
Liabilities), in other words all the long-term funds used by the bank. ROCE indicates
the efficiency and profitability of a bank's capital investments.

(PBIT/ Capital employed) *100

Return on capital Employed = (Or)

/ Current liabilities
PBIT/ Average net worth + loan
funds

/ Current liabilities

KLE Society’s Institute of Management Studies and Research, Hubli. Page 39

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

ANALYSIS AND
INTERPRETATION

KLE Society’s Institute of Management Studies and Research, Hubli. Page 40

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

1. CURRENT RATIO

Year Current Current Ratio

assets lablities(Rs in
(Rs in Cr) Cr)
2010-11 5,699.28 4,973.51 1.15
2011-12 9,587.39 4,370.12 2.19
2013-14 8,711.54 7,811.18 1.12
2014-15 7,604.87 1,225.16 0.62
2015-16 8,67.98 4,587.57 0.18
2016-17 1,056.29 5,065.73 0.2
2017-18 1,247.58 7,206.25 0.17
2018-2019 1,320.37 7,990.89 0.16
2019-20 6,618.2 5,67,404 1.17

CURRENT RATIO
2.5

1.5

1 CURRENT RATIO

0.5

Interpretation

From above table the current ratio of a bank has a standard position only in the year of
2012 to 2013, because as per rule, the current ratio of 2:1 (or) more indicates highly
solvent position of firm.

KLE Society’s Institute of Management Studies and Research, Hubli. Page 41

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

2.OUICK RATIO

Year Quick Current lablities minus Quick ratio

assets(Rs in BOD(Rs in Cr)
Cr)
2010-11 3,727.56 4,382.64 0.85
2011-12 7,757.65 2,735.56 2.84
2012-13 7,100.4 7,640.17 0.93
2013-14 5,925.21 92,149 0.64
2014-15 6,618.12 5,674.04 1.17
2015-16 815.43 7,206.25 0.13
2016-17 1,021.26 5,065.73 0.2
2017-18 815.43 7,206.25 0.113
2018-19 1,320.37 7,990.89 0.165
2019-20 6,618 8,67,404 0.076

Quick ratio
3
2.5
2
1.5
Quick ratio
1
0.5
0

Interpretation

From the above table the bank is having good liquidity position i.e.1.17 in the
year of 2014 to 2015. The quick ratio of 1:1 indicates satisfactory position of the firm.

KLE Society’s Institute of Management Studies and Research, Hubli. Page 42

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

3.DEBT EQUITY RATIO

Year Longtime Shareholder Debt

Debt(Rs in fund equity
lakh) (Rs in lakh) Ratio

2010-11 166.9 3.707.84 0.045

2011-12 500 2,832.68 0.177
2012-13 166.9 2,849.88 0.059
2013-14 289.83 2,338.69 0.124
2014-15 1733.74 3,184.15 0.544
2015-16 1424.08 781.19 1.82
2016-17 1981.63 792.42 2.5
2017-18 1340.4 811.72 1.66
2018-19 779.67 829.7 1.1
2019-20 6745.2 272.49 0.93

Debt Equity Ratio

2.5

1.5

1 Debt Equity Ratio

0.5

Interpretation

If the debt-equity ratio is greater than 1, then the bank assets are financed through debt
or if the ratio is less than 1, its assets are primarily financed through equity.

KLE Society’s Institute of Management Studies and Research, Hubli. Page 43

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

From the above table bank ratio is less than 1, from the year of 2011 to 2015.
Hence the bank assets are financed through equity and 2016 to 2020 ratio is more than
1.

4. INTERST COVERAGE RATIO

Year EBIT(Rs in Interst(Rs In Interst coverage

lakh) lakh) ratio
2010-11 1,772.58 286.9 6.18
2011-12 3,34.09 428.1 0.78
2012-13 1,487.56 704.44 2.11
2013-14 594.85 734.97 0.81
2014-15 2,516.04 637.54 3.95
2015-16 498.56 468.19 1.06
2016-17 520.1 504.63 1.03
2017-18 554.55 517.57 1.07
2018-19 415.83 392.7 1.05
2019-20 327.7 493.233 0.66

Interst coverage ratio

7
6
5
4
3
Interst coverage ratio
2
1
0

Interpretation

In the years of 2010-11,2012-13,2014-15 the interest expenses has incurred by

bank is greater than the earnings that bank have had to pay, but compare to remaining
years. However, the bank is easily able to meet the interest obligation from profits.

KLE Society’s Institute of Management Studies and Research, Hubli. Page 44

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

5. DEBT TURNOVER RATIO

Year Credit Sales(Rs Aveage Debt

in lakh) debtor(Rs in turnover
lakh) ratio
2010-11 19,104.87 2937.7 6.5
2011-12 19,625.18 4,513.68 4.35
2012-13 22,356.35 5813.3 3.85
2013-14 24,978.27 5,358.805 4.49
2014-15 30,664.18 4,946.355 6.2
2015-16 62.25 401.02 0.1555
2016-17 169.86 454.83 0.377
2017-18 202.33 458.59 0.461
2018-19 29.36 446.83 0.06707
2019-20 16113.8 49456 1.53

Debt turnover ratio

7
6
5
4
3 Debt turnover ratio
2
1
0

Interpretation

From the above table ratio increases in the year 2010-11 is at 6.50, which
decreases to 6.20 in the year 2014-15. But in the year 2011-12 to 2013-14, it decreases
to 4.35, 3.85, 4.49. It indicates that debts are being collected more promptly and more
than increase in 2020is at 1.53.

KLE Society’s Institute of Management Studies and Research, Hubli. Page 45

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

6. NET PROFIT MARGIN RATIO

Year Net profit(Rs Revenue(Rs in Net profit

in lakh) lakh ) Margin ratio
2010-11 2,478.14 1982.631 0.12
2011-12 3,388.49 27,414.87 12.36
2012-13 3,339.91 27,482.09 12.15
2013-14 4,242.21 33,733.68 12.15
2014-15 5,234.76 38,502.21 13.5
2015-16 6,310.12 44,565.57 14.1
2016-17 7,448.9 51,36,423 0.14
2017-18 8,223.66 56,233.47 14.6
2018-19 3,679.28 56,.747.40 6.4
2019-20 18,787.5 7,791.87 0.24

Net profit Margin ratio

16
14
12
10
8
6 Net profit Margin ratio
4
2
0

Interpretation

The above table show that net profit margin was less year by year its increasing . In the
financial year 2010-11 the ratio0.12 it has been increased to 12.36 in the finacial year
2011-12 and scaled down to 12.15 to in the finacial year 2012-13 and scaled up to 13.5
in the finacial year 2014-15.and again it came down to 0.14 in the finacial year 2016-
17and also came in down 0.24 in the finacial year 2019-20.

KLE Society’s Institute of Management Studies and Research, Hubli. Page 46

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

7. OPERATING PROFIT RATIO

Year Operating Net sale(Rs in Operating

profit(Rs in lakh) lakh) profit ratio
2010-11 13,385.144 19,82,631 0.675
2011-12 5,240.55 ,7,448.7, 1.9
2012-13 3,388.49 27,482.09 0.12
2013-14 4,242.21 33,733.68 0.12
2014-15 1,1589.72 38,502.21 0.3
2015-16 16,408.62 4,44,565.6 0.36
2016-17 16,10,361 51,36,423 0.3
2017-18 16,08,463 5,6747 0.1
2018-19 5.8998 5,6747 0.1
2019-20 9,151 77,791 1.1

operating profit ratio

2
1.8
1.6
1.4
1.2
1
0.8 operating profit ratio
0.6
0.4
0.2
0

Interpretation

The above table show that in the FY 2010-11 the operating ratio was 0.675 and the FY
2011-12 the ratio was unchanged that is 1.9 and in the FY 2012-19 it scaled down and
2019-20 net sales has been increased it was 1.1.

KLE Society’s Institute of Management Studies and Research, Hubli. Page 47

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

8.TOTAL ASSETS TURNOVER RATIO

Year Net sale(Rs Avg total Total assets turn

in (Rs in aseets(Rs in lakh) over ratio
lakh)
2010-11 1,98,263 5,699.28 3.3
2011-12 2,744.87 9,587.39 0.4
2012-13 2,748.209 8,711.54 0.3
2013-14 3,3733.68 7604.87 4.4
2014-15 3,850.2 867.9 4.4
2015-16 4,445.6 1056.2 4.2
2016-17 1,364.2 1247.5 1
2017-18 567.4 1320.3 0.4
2018-19 567.4 915.16 0.6
2019-20 7777.9 6618.1 0.1

Total assets turn over ratio

4.5
4
3.5
3
2.5
2
1.5 Total assets turn over ratio
1
0.5
0

Interpretation

In the above table show that the assets turnover ratio was 3.3 in the Fy 2010-11and
increased to the 0.4 in the finacial year 2011-12 and increase to 4.4 in the Fy 2013-14
and decreased to 0.1 in the FY 2019-20.

KLE Society’s Institute of Management Studies and Research, Hubli. Page 48

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

9. CREDIT DEPOSIT RATIO

year Total Total Credit deposit turn

advance(Rs in deposit(Rs in over ratio
Cr) Cr)
2010-11 1,04,343,118 1,892,3780 0.5
2011-12 1424,0783 2,20,104 3.1
2012-13 37,570.3 25,26,1359 0.13
2013-14 196,,965.96 2,80,944.6 0.7
2014-15 2,3066.16 32,2441.9 0.7
2015-16 2,81,083 4,14,378.7 0.6
2016-17 33,87,773 4,53,62,272 0.6
2017-18 3,773,06,935 54,847 0.6
2018-19 4,396,501 45,362,272 0.9
2019-20 5,74,1424 640,109 0.8

Credit deposit turn over ratio

3.5
3
2.5
2
1.5 Credit deposit turn over ratio
1
0.5
0

Interpretation

In the above table show that the credit deposit was 1.7 in the finacial year 2010-11,but
year to year descreasing it is increased to 3.5 in the finacial year 2015-16.and agin it
decreased in the FY 2017-20.

KLE Society’s Institute of Management Studies and Research, Hubli. Page 49

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

10. INVESTEMENT DEPOSIT RATIO

year Investment(Rs in Aggregate Invesement

Cr) deposit(Rs in Cr) deposit ratio
2010-11 7,19,962 4,13,0021 1.7
2011-12 1,13,737.54 1,17,37411 0.9
2012-13 55,974.84 2,52,613.59 0.2
2013-14 113,548.43 2,80,944.56 0.4
2014-15 1,32,342 3,2441.94 0.4
2015-16 128,3601 357.967 3.5
2016-17 1,25,45,137 3,583,02,192 0.3
2017-18 1,03,48,900 45,3,62,272 0.2
2018-19 1992297 4,5565,77,462 0.14
2019-20 9151648 6,35,203,738 1.4

invesement Deposit ratio

3.5
3
2.5
2
1.5 invesement turn over ratio
1
0.5
0

Interpretation

The above table show that invesment deposit ratio was1.7 in the FY 1.7 and it decreased
in the finacial year2011-14 And increased to 3.5 in the finacial year 2015-16 and also
increased FY 2019-2020.

KLE Society’s Institute of Management Studies and Research, Hubli. Page 50

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

11. DIVDENT PAYOUT RATIO

Year Net income Divedend(Rs in Divdend

(Rs in Cr) Cr) payout ratio
2010-11 3945 151.97 0.3
2011-12 4632.1 184.68 0.4
2012-13 6551.11 214.28 0.3
2013-14 7405.22 286.34 0.4
2014-15 8365.04 275.56 0.3
2015-16 9371.46 299.58 0.3
2016-17 11691.31 335.39 0.2
2017-18 1096709 34460 0.3
2018-19 13130 131.1 0.4
2019-20 15537 182.6 0.1

Divdend payout ratio

0.4
0.35
0.3
0.25
0.2
0.15 Divdent payout ratio
0.1
0.05
0

Interpretation

In the above table show that the divdent payout ratio was 0.3 in the FY 2010-11,And
increased to 0.4 in the FY2011-12and FY 2012-13,13-14.14-15 Increased and decreased
2013-14,15.and in the year 2018-19 the ratio was 0.4 and year 2019-20 decreased the
ratio was 0.11.

KLE Society’s Institute of Management Studies and Research, Hubli. Page 51

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

12 CASH DEPOSIT RATIO

year Cash in hand(Rs Total deposit(Rs in Cash Deposit

in Cr) Cr) Ratio
2010-11 190,07,011 9,23,780 0.2
2011-12 22,082.8 22,010 1.0
2012-13 4,05,388.42 2,56,213 1.5
2013-14 4,05,388.4 280.944 0.14
2014-15 4,16,413 3224419 0.12
2015-16 4,12,048 41,4378.7 0.9
2016-17 6,35,791.54 45,3622.7 1.4
2017-18 52,580.3 5,4847.1 0.9
2018-19 421,32,147 45,36227 0.9
2019-20 5,71,424.1 6,40,1093.7 0.8

Cash Deposit Ratio

1.6
1.4
1.2
1
0.8
0.6 Cash Deposit Ratio
0.4
0.2
0

Interpretation

In the above the table show that the cash deposit ratio was 0.2 in the FY 2010-11 and
the ratio was increase 1.0 in the FY 2011-12.and increase to 1.5 and decrease to 0.12 in
the FY in 2014-15 and increase to 1.4. and decrease to 0.8 in the FY 2019-20.

KLE Society’s Institute of Management Studies and Research, Hubli. Page 52

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

13. EARNING RETENTION RATIO

year Retained Net inome(Rs Retained earning per

earning (Rs in Cr) ratio
in Cr)
2010-11 6483 3,945 1.6
2011-12 8295 4632 1.7
2012-13 11964 6551.1 0.1
2013-14 32.56 7405.2 0.17
2014-15 31.18 8365.04 0.3
2015-16 1540 9371.46 0.16
2016-17 1140 11,691.31 1.06
2017-18 151.13 10,96,709 0.1
2018-19 18.2 13,130 0.1
2019-20 6.8 15,537 2.2

Earning Retention Ratio

2.5

1.5
Retained earning per ratio
1

0.5

0
1 2 3 4 5 6 7 8 9 10

Interpretation

The above table show that the retained earning Retention ratio was 1.6 in the FY 2010-
11 and decreased the ratio to0.16 in the year 2015-16 and increased to 1.06 in the FY
2016-17 and increased to 2.2 in the FY2019-20.

KLE Society’s Institute of Management Studies and Research, Hubli. Page 53

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

14.CREDIT TURNOVER RATIO

year Credit turn over ratio

2010-11 4.63
2011-12 4.11
2012-13 2.99
2013-14 2.5
2014-15 4.8
2015-16 5.3
2016-17 0.37
2017-18 0.52
2018-19 0.46
2019-20 2.2

Credit turn over ratio

6

3
Credit turn over ratio
2

Interpretation

The above table show that the credit turnover ratio was 4.63 and decrease to4.11in the
FY 2011-12,And increase the ratio was 4.85 in the FY 2014-15 and decreased to the 0.9
in the FY 2019-20.

KLE Society’s Institute of Management Studies and Research, Hubli. Page 54

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

15. CAPITAL ADQUENCY RATIO

year Capital adquency ratio

2010-11 12.65
2011-12 13.66
2012-13 17
2013-14 16.07
2014-15 15.8
2015-16 12.65
2016-17 13.66
2017-18 17.07
2018-19 16.07
2019-20 14.06

Capital adquency ratio

18
16
14
12
10
8
6 Capital adquency ratio
4
2
0

Interpretation

In the above table show that capital adquency ratio was 0.5 in the FY 2010-11.and
increase to 1.6 in the FY 2012-13,and decrease to ratio 0.9 in the FY 2019-20.

KLE Society’s Institute of Management Studies and Research, Hubli. Page 55

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

FINDINGS & SUGGESTION

KLE Society’s Institute of Management Studies and Research, Hubli. Page 56

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

Findings

1. Current ratio of a bank has a standard position only in the year of 2012 to 2013,
because as per rule, the current ratio of 2:1 (or) more indicates highly solvent
position of firm.
2. Bank is having good liquidity position i.e.1.17 in the year of 2014 to 2015. The
quick ratio of 1:1 indicates satisfactory position of the firm.
3. Debt-equity ratio is greater than 1, then the bank assets are financed through
debt or if the ratio is less than 1, its assets are primarily financed through equity.
bank ratio is less than 1, from the year of 2011 to 2015. Hence the bank assets
are financed tough equity and 2016 to 2020 ratio is more than 1.
4. In the years of 2010-11,2012-13,2014-15 the interest expenses has incurred by
bank is greater than the earnings that bank have had to pay, but compare to
remaining years. However, the bank is easily able to meet the interest obligation
from profits.
5. Debt turnover ratio increases in the year 2010-11 is at 6.50, which decreases to
6.20 in the year 2014-15. But in the year 2011-12 to 2013-14, it decreases to
4.35, 3.85, 4.49. It indicates that debts are being collected more promptly and
more than increase in 2020is at 1.53.
6. Net profit margin was less year by year its increasing. In the financial year 2010-
11 the ratio 0.12 it has been increased to 12.36 in the financial year 2011-12
and scaled down to 12.15 to in the financial year 2012-13 and scaled up to 13.5
in the financial year 2014-15.and again it came down to 0.14 in the financial
year 2016-17 and also came in down 0.24 in the financial year 2019-20.
7. The operating ratio was 0.675 in the FY 2010-11 in the FY 2011-12 the ratio
was unchanged that is 1.9 and in the FY 2012-19 it scaled down and 2019-20 net
sales has been increased it was 1.1.
8. Assets turnover ratio was 3.3 in the FY 2010-11and increased to the 0.4 in the
financial year 2011-12 and increase to 4.4 in the FY 2013-14.and decreased to
0.1 in the FY 2019-20.
9. Credit turnover ratio was 4.63 in FY 2010-11 and decreased to 4.11 in the FY
2011-12 and increase in the ratio was 4.85 in the FY 2014-15 and decreased to
the 0.9 in the FY 2019-20.

KLE Society’s Institute of Management Studies and Research, Hubli. Page 57

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

10. Investment deposit ratio was 1.7 in the FY 2010-11 and it decreased in the
financial year 2011-14 And increased to 3.5 in the financial year 2015-16 and
also increased FY 2019-2020.
11. The divident payout ratio was 0.3 in the FY 2010-11 and increased to 0.4 in the
FY2011-12 and FY 2012-13,13-14.14-15 Increased and decreased 2013-14,
15.and in the year 2018-19 the ratio was 0.4 and year 2019-20. decreased the
ratio was 0.11.
12. Cash deposit ratio was 0.8 in the FY 2010-11 and increased to 1.0 in the FY
2011-12 and increased to 1.6 in the FY 2012-13 and increased to1.4 in the
FY2016-17and decreased to 0.9 in the FY 2019-20.
13. The earning Retention ratio was 1.6 in the FY 2010-11 and decreased the ratio to
0.16 in the year 2015-16 and increased to 1.06 in the FY 2016-17.and increased
to 2.2 in the FY 2019-20.
14. The credit turnover ratio was 4.63 and decreased to 4.11 in the FY 2011-12 and
increase in the ratio was 4.85 in the FY 2014-15 and decreased to the 0.9 in the
FY 2019-20.
15. Capital adequacy ratio was 0.5 in the FY 2010-11.and Increase to 1.6 in the FY
2012-13,and decrease to ratio 0.9 in the FY 2019-20.The above table show that
the retained earnings Retention ratio was 1.6in the FY 2010-11 and decreased
the ratio to0.16 in the year 2015-16.and increased to 1.06in the FY 2016-17 and
increased to 2.2 in the FY2019-20

Suggestions

1. Current ratio is a below satisfactory level, it shows the current assets are
insufficient, so needs to be improved.
2. Assets turnover ratio is decreasing that will reduce net sales and average total
assets, so needs to be improved.

Conculsion

1. Study on ratio analysis of axis bank the performance in terms of finacial, it

observed the performance of the bank is fuluting in these 10 years.
2. Ratio analysis examine past and current finacial data for the purpose of evaluting
performance and estamating future risk and potentional.

KLE Society’s Institute of Management Studies and Research, Hubli. Page 58

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

ANNEXURE

KLE Society’s Institute of Management Studies and Research, Hubli. Page 59

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

BLANCE SHEET 2010 to 2011(Rs in Crores)

SOURCES OF FUND 2010-11

Share holder 776.9
Reserve 0.94293

Minority
LOANS
a secured loan 1950.36
b. unsecured loans 688.87
TOTAL 2639.37
3.Defered tax
Net deferred tax 362.444
TOTAL 6,710.41
2. APPLICATION OF FUNDS
Fixed
A.Gross 8,114
less: Deprecation 281418
Net block 5299.91
Capital working in progress 246.95
Investment
Current assets
Interest accrued deprecation 0.3
Inventories 985.86
Sundry debt 30129
cash bank balance 2542.74
other current assets loans and advance 46.32
TOTAL 5,699
less: current lability
Current 3,639.70
provision 133.74
TOTAL 4973.51
Net current assets 725.77
TOTAL 6710.01

KLE Society’s Institute of Management Studies and Research, Hubli. Page 60

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

PROFIT AND LOSS ACCUNT 2010 to 2011(Rs in Crores)

INCOME 2010
Interst earned 116,390,540
Other Income 39,642,116
Totak 156,032,656
EXPENDITURE
Interst expended 66,326,317
Operating expenses 37,623,901
provision and contigncies 27,301,025
TOTAL 131,251,243
Less: Share in losses of Associate ,
CONSOLIDATED NET PROFIT ATTRIBUTABLE TO GROUP 24,781,413
Balance in Profit &Loss Account brought forward from previous year 23,289,541
AMOUNT AVALIBLE FOR APPOPRATION 48,070,953
APPROPRATION
Transfer to statutory Reserve 6,286,333
Transfer to investement reserve 148,750
Transfer to capital reseve 2,239,176
transfer to Gernal reserve 5,622
proposed divdend (includeds tax on divdend 5,674,734
Balnce in Profit &Loss account carried forward 33,716,338
TOTAL 48,070,953
EARNING PER EQUITY SHARE
Face value rs 10% share
Basic 82
Dilluted 80

KLE Society’s Institute of Management Studies and Research, Hubli. Page 61

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

BALANCE SHEET 2011-2012(Rs in Crores)

SOURCE OF FUND CAPITAL 2011-12

Share holder 716.9
Reserve 2055.75
Minority
LOANS
a secured loan 913498
b. unsecured loans 1065.05
TOTAL 162200
3.Defered tax 442.9
Net deferred tax 125.26
TOTAL 14,161.10
2. APPLICATION OF FUNDS
Fixed
a. Gross 11,495
less: Deprecation 350127
Net block 799369
Capital working in progress 31259.85
Investment
Current assets
Interest accrued deprecation 0.6
Inventories 91487
Sundry debt 60144.2
cash bank balance 991.04
other current assets loans and advance 78.75
TOTAL 958,739
less: current lability
Current 3,629.26
provision 740.26
TOTAL 4370.2
Net current assets 5217.27
TOTAL 13477.3

KLE Society’s Institute of Management Studies and Research, Hubli. Page 62

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

PROFIT AND LOSS ACCOUNT 2011-12(Rs in Crores)

INCOME 2011-12
Interest earned 151,548,566
Other Income 46,714,492
Total 198,263,058
EXPENDITURE
Interest expended 85,886,082
Operating expenses 48,064,739
provision and contingencies 30,325,512
TOTAL 164,816,333
Less: Share in losses of Associate 47,659
CONSOLIDATED NET PROFIT ATTRIBUTABLE TO GROUP 33,399,066

Balance in Profit &Loss Account brought forward from previous 33,716,338

year
AMOUNT AVALIBLE FOR APPOPRATION 67,115,404
APPROPRATION
Transfer to statutory Reserve 8,471,227
Transfer to investment reserve 149,372
Transfer to Capital reserve 47,630
transfer to General reserve 3,396,591
proposed dividend (includes tax on dividend 6,704,806
Balance in Profit &Loss account carried forward 48,644,522
TOTAL 67,115,404
EARNING PER EQUITY SHARE
Face value Rs 10% share

KLE Society’s Institute of Management Studies and Research, Hubli. Page 63

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

BALANCE SHEET 2012-2013(Rs in Crores)

SOURCE OF FUNF 2012-13

Share holder 776.9
Reserve 4136.97
Minority
LOANS
a secured loan 334862
b. unsecured loans 207365
TOTAL 542227
3.Defered tax
Net deferred tax 125.26
TOTAL 14,161.10
2. APPLICATION OF FUNDS
Fixed
a. Gross 179,706
less: Deprecation 375139
Net block 142192
Capital working in progress 2422976
Investment
Current assets
Interest accrued deprecation 0.9
Inventories 14104.41
Sundry debt 714741
cash bank balance 640.15
other current assets loans and advance 184.9
TOTAL 113,002
less: current lability
Current 11,115.70
provision 475.08
TOTAL 11590.7
Net current assets 290.54
TOTAL 14.161.1

KLE Society’s Institute of Management Studies and Research, Hubli. Page 64

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

PROFIT AND LOSS ACCOUNT 2012-13(Rs in Crores)

INCOME 2012-13
Interst earned 2,19,948,991
Other Income 54,871,922
Total 274,820,913
EXPENDITURE
Interst expended 139,691,770
Operating expenses 60,998,947
provision and contigncies 31,945,090
TOTAL 2,32,635,807
Less: Share in losses of Associate 12,683
CONSOLIDATED NET PROFIT ATTRIBUTABLE TO GROUP
Balance in Profit &Loss Account brought forward from previous 42,197,789
year
AMOUNT AVALIBLE FOR APPOPRATION
APPROPRATION
Transfer to statutory Reserve 10,605,513
Transfer to investement reserve -
Transfer to capital reseve 519,407
transfer to Gernal reserve 10,781
proposed divdend (includeds tax on divdend 7,702,550
Balnce in Profit &Loss account carried forward 72,004,480
TOTAL 90,842,311
EARNING PER EQUITY SHARE
Face value rs 10% share
Basic
Dilluted

KLE Society’s Institute of Management Studies and Research, Hubli. Page 65

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

BALANCE SHEET 2013-14(Rs in Crores)

CAPITAL AND LABLITIES 2013-14

Capital 4,698,446

Reserve &surplus 378,262,043

Minority investment 129.421

Deposit 2,805,410,738

Borrowing 527,392,236

Other liabilities and provision 146,607,709

TOTAL 3,863,500,593

Cash 170,413,647

Balance with banks and Money 115,407,921

investment 1,130,927,767

advance 2,323,817,273

fixed Assets 24,472,596

other assets 98,461,389

TOTAL 3,863,500,593

Contingent liabilities 5,748,541,620

Bills for collection 366,015,787

KLE Society’s Institute of Management Studies and Research, Hubli. Page 66

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

PROFIT AND LOSS ACCOUNT 2013-14(Rs. in Crores)

INCOME 2013-14

Interest earned 272,019,572

Other Income 68,328,045

Total 340,347,797

EXPENDITURE

Interest expended 175,133,879

Operating expenses 71,405,164

provision and contingencies 41,470,830

TOTAL 288,009,873
Less: Share in losses of Associate 12,193

CONSOLIDATED NET PROFIT ATTRIBUTABLE TO GROUP

Balance in Profit &Loss Account brought forward from previous 72,004,480

year
AMOUNT AVALIBLE FOR APPOPRATION

APPROPRATION

Transfer to investment reserve 534,571

Transfer to capital reserve 1,414,579

transfer to General reserve 1,41,678

proposed dividend (includes tax on dividend 9,874,798

Balance in Profit &Loss account carried forward 100,454,029

TOTAL 125,475,422

EARNING PER EQUITY SHARE

Face value Rs 10% share

Basic 121

Diluted 120

KLE Society’s Institute of Management Studies and Research, Hubli. Page 67

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

BALANCE SHEET 2014-15(Rs in Crores)

CAPITAL AND LABLITIES 2014-15

Capital 4,698,446

Reserve &surplus 378,262,043

Minority investment 129.421

Deposit 2,805,410,738

Borrowing 527,392,236

Other liabilities and provision 146,607,709

TOTAL 3,863,500,593

Cash 170,413,647

Balance with banks and Money 115,407,921

investment 1,130,927,767

advance 2,323,817,273

fixed Assets 24,472,596

other assets 98,461,389

TOTAL 3,863,500,593

Contingent liabilities 5,748,541,620

Bills for collection 366,015,787

KLE Society’s Institute of Management Studies and Research, Hubli. Page 68

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

PROFIT AND LOSS ACCOUNT 2014-15(Rs in Crores)

INCOME 2014-15
Interest earned 307,359,589
Other Income 77,662,50O
Total 385,002,089
EXPENDITURE
Interest expended 187,029,665
Operating expenses 82,095,228
provision and contingencies 52,805,544
TOTAL 321,930,437
Less: Share in losses of Associate 13,594
CONSOLIDATED NET PROFIT ATTRIBUTABLE TO GROUP
Balance in Profit &Loss Account brought forward from previous year 100,454,029
AMOUNT AVALIBLE FOR APPOPRATION
APPROPRATION .
Transfer to statutory Reserve 15,544,167
Transfer to investment reserve 500
Transfer to capital reserve 389
transfer to General reserve 17,797
proposed dividend (includes tax on dividend 11,014,430
Balance in Profit &Loss account carried forward 136,012,379
TOTAL 163,555,191
EARNING PER EQUITY SHARE
Face value rs 10% share
Basic 135
Diluted 134

KLE Society’s Institute of Management Studies and Research, Hubli. Page 69

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

BALANCE SHE 2015-16(Rs in Crores)

CAPITAL AND LABLITIES 2015-16
Total share capital 1086.75
Equity share capital 736.75
share application money 0.02
preference share capital 350
reserve 11813.2
Revulation Reserve 0
Net worth 12899.97
Deposit 99818.78
Borrowing 33544.5
Total Debt 146263.25
another Labilities Provision 21396.17
Total liabilities 21396.17
ASSETS
CASH 6344.9
Balance with bank 6585.07
Advances 91405.15
investment 50487.35
Gross Block 5525.65
Accumulated Deprecation 1487.61
Net Fixed Assets 4038.04
capital Work in progress 96.3
other assets 8702.59
contingent liabilities 97507.79
bills for collection 9803.67
Book Value 170.35
EPS 27.22
NO of equity share 736716094

KLE Society’s Institute of Management Studies and Research, Hubli. Page 70

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

PROFIT AND LOSS ACCOUNT 2015-16(Rs in Crores)

PARTICULERS 2015-16
INCOME
Interest Earned 9409.9
other income 3416.14
Total income 12826.04
EXPENDITURE
Interest expended 6570.89
Operating Expenses 3299.15
Total expenses 9870.04
Operating profit 2956
other provision 428.8
Provision for Tax 522
Net profit 2005.2
Extraordinary items 0
PBIT 53.09
Total 2058.29
preference dividend 0
Equity dividend 632.96
Corporate dividend tax 90.1
per share data
EPS 27.22
Equity dividend 632.96
Book value 170.35
Appropriation
Transfer to other reserve 547
proposed dividend 723.06
balance sheet 188.22
Total 2058.29

KLE Society’s Institute of Management Studies and Research, Hubli. Page 71

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

BALANCE SHEET 2016-17(Rs in crores)

CAPITAL AND LABLITIES 2016-17
Total share capital 1239.83
Equity share capital 889.83
share application money -
preference share capital 350
reserve 21316.16
Revulation Reserve 0
Net worth 22555.99
Deposit 165083.17
Borrowing 38521.991
Total Debt 22161.17
another Labilities PROVISION 25227.88
Total liabilities 251388.95
ASSETS
CASH
Balance with bank 6585.07
Advances 91405.15
investment 50487.35
Gross Block 5525.65
Accumulated Deprecation 1487.61
Net Fixed Assets 4038.04
capital Work in progress 96.3
other assets 8702.59
contingent liabilities 9507.79
bills for collection 15025.21
Book Value 249.55
EPS 28.55
NO of equity share 889823901
Gross Block 5525.65
Accumulated Deprecation 1487.61
Net Fixed Assets 4038.04
capital Work in progress 96.3
other assets 8702.59
contingent liabilities 9507.79
bills for collection 15025.21
Book Value 249.55
EPS 28.55
NO of equity share 889823901

KLE Society’s Institute of Management Studies and Research, Hubli. Page 72

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

PROFIT AND LOSS ACCOUNT 2016-17(Rs in Crores)

2016-17
INCOME
Interest Earned 13784.49
other income 4983.14
Total income 18767.6
EXPENDITURE
Interest expended 9597.45
Operating Expenses 4479.51
Total expenses 14076.96
Operating profit 4690.67
other provision 1594..07
Provision for Tax 556.53
Net profit 2540..07
Extraordinary items 0
PBIT 188.22
Total 2728.29
preference dividend 0
Equity dividend 759.33
Corporate dividend tax 106.5
per share data
EPS 28.55
Equity dividend 85
Book value 249.55
Appropriation 248.69
Transfer to other reserve 1320.34
proposed dividend 865.83
balance sheet 293.44
Total 2728.3

KLE Society’s Institute of Management Studies and Research, Hubli. Page 73

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

BALACE SHEET 2017-18(Rs in Crores)

CAPITAL AND LABLITIES 2017-18

Total share capital 1249.34
Equity share capital 889.83
share application money -
preference share capital 350
reserve 23413.92
Revulation Reserve -
Net worth 24663.26
Deposit 230510.19
Borrowing 5126.03
Total Debt 306429.48
other Labilities and PROVISION 38228.64
Total liabilities 344658.12
ASSETS
CASH 18706.88
Balance with bank 18404.45
Advances 195865.6
investment 91257.84
Gross Block 6298.56
Accumulated Deprecation 2375.14
Net Fixed Assets 3923.42
capital Work in progress 189.66
other assets 16300.26
contingent labilities 177054.18
bills for collection 22717.23
Book Value 270.37
EPS 34.59
NO of equity share 899266672

KLE Society’s Institute of Management Studies and Research, Hubli. Page 74

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

PROFIT AND LOSS ACCOUNT 2017-18(Rs in crores)

2017-18
INCOME
Interest Earned 22994.29
other income 5929.17
Total income 28923.46
EXPENDITURE
Interest expended 16358.5
Operating Expenses 6690.56
Total expenses 23049.06
Operating profit 5874.4
other provision 2226.36
Provision for Tax 537.82
Net profit 3110.22
Extraordinary items 0
PBIT 293.44
Total 3403.66
preference dividend 0
Equity dividend 901.17
Corporate dividend tax 153.1
per share data
EPS
Equity dividend 1351.12
Book value 270.37
Appropriation
Transfer to other reserve 1351.12
transfer to other reserve 0
balance sheet 998.27
Total 3403.66

KLE Society’s Institute of Management Studies and Research, Hubli. Page 75

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

BALANCE SHEET 2018-19(Rs in Crores)

CAPITAL AND LABLITIES 2018-19

Total share capital 146.28
Equity share capital 1112.68
share application money 0
preference share capital 350
reserve 45537.53
Revulation Reserve 0
Net worth 46820.21
Deposit 24443.92
Borrowing 65648.43
Total Debt 356899.69
other Labilities and 4289.39
Total labilities 42895.39
ASSETS 399795.08
CASH 29377.53
Balance with bank 8663.6
Advances 225616.08
investment 111454.34
Gross Block 7036
Accumulated Deprecation 2927.11
Net Fixed Assets 4108.89
Capital Work in progress 0
other assets 20574.63
contingent labilities 371737.36
bills for collection 29377.75
Book Value 417.64
EPS 37.37
NO of equity share 112687495

KLE Society’s Institute of Management Studies and Research, Hubli. Page 76

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

PROFIT AND LOSS ACCOUNT 2018-19(Rs in Crores)

2018--19
INCOME
Interest Earned 30788.34
Other Income 8810.77
Total Income 39599.11
EXPENDITURE 48419.73
Interest Expended 23484.24
Operating Expenses 8154.18
Total Expenses 31638.42
Operating Profit 7960.69
Other provision 2904.59
Provision For tax 898.37
Total labilities 0
Extraordinary Items 0
Profit 998.27
Total 5156.00
Preference dividend 0
Equity dividend 1227.70
Transfer to statutory Reserve 1342.31
Transfer to other Reserve 0.01
Proposed Dividend 1377.37
Balance sheet 2436.32
TOTAL 5156.01

KLE Society’s Institute of Management Studies and Research, Hubli. Page 77

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

BALANCE SHEET 2019-20(Rs in Crores)

CAPITAL AND LABLITIES 2019-20

Total share capital 1463.29
Equity share capital 1113.29
share application money 0
preference share capital 350
reserve 48419.73
Revulation Reserve 0
Net worth 4988.02
Deposit 218347.82
Borrowing 67323.69
Total Debt 33554.53
another Labilities PROVISION 43746.43
Total labilities 379300.96
ASSETS
CASH 17536.33
Balance with bank 12430.23
Advances 218310.85
investment 103058.31
Gross Block 7443.71
Accumulated Deprecation 3642.09
Net Fixed Assets 3801.62
capital Work in progress 0
other assets 24163.52
contingent labilities 24163.62
bills for collection 803,991.92
Book Value 36678.71
EPS 33.78
NO of equity share 1113250642

KLE Society’s Institute of Management Studies and Research, Hubli. Page 78

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

PROFIT AND LOSS ACCOUNT 2019-20(Rs in Crores)

2019-20
INCOME
Interest Earned 31092.55
Other income 7603.72
Total Income 38696.27
EXPENDITURE
Interest expended 22725.93
Operating Expenses 7045.11
Total Expenses 29777.04
Operating profit 8925.23
Other provision 3808.26
Provision For tax 1358.84
NET PROFIT 3758.13
Extraordinary items 0.58
Profit 2436.32
Preference Dividend 0
Equity Dividend 1224.58
Corporate Dividend Tax 151.21
Appropriation
Transfer to Statutory Reserve 2008.42
Transfer to other Reserve 0.01
Proposed Dividend 1375.79
Balance Sheet 2809.65
TOTAL 6193.87

KLE Society’s Institute of Management Studies and Research, Hubli. Page 79

 A STUDY ON RATIO ANALYSIS AT AXIS BANK

BIBLIOGRAPHY
➢ M Y Khan and P K Jain - Financial Management Fourth Edition-2006, Tata
McGraw-Hill Publishing Bank Limited, New Delhi.
➢ Murthy - Management Accounting First Edition-2000, S. Viswanathan (Printers
&Publishers), PVT, LTD.
➢ S.M. Maheswari - Management Accounting, Sultan Chand & Sons Educational
Publishers, New Delhi.

Websites:

http://www.axisbank.com

REPORTS: ANNUAL REPORTS OF AXIS BANK

• Annual Report of Axis bank For the year 2010-11

• Annual Report of Axis bank For the year2011-12
• Annual Report of Axis Bank For the Year 2012-13
• Annual Report of Axis bank For the year 2013-14
• Annual Report of Axis bank For the year2014-15
• Annual Report of Axis bank For the year 2015-16
• Annual Report of Axis bank For the year2016-17
• Annual Report of Axis bank For the year 2017-18
• Annual Report of Axis bank For the year2018-19
• Annual Report of Axis bank For the year2019-20

KLE Society’s Institute of Management Studies and Research, Hubli. Page 80