Ratio Analysis of Mahindra & Mahindra
Ratio Analysis of Mahindra & Mahindra
Prepared by
Shreyans Gautam Barlota
ACADEMIC YEAR
2023-24
Submitted To
Shree Chanakya Education Society’s
Indira Institute of Management-BBA, Pune
Affiliated To
An Autonomous Institute affiliated with SPPU
1
1
Student’s Declaration
titled “A study on A Ratio Analysis of Mahindra and MAHINDRA” is a result of my work and my
indebtedness to other work publications, references, if any, have been duly acknowledged. If I am
found guilty of copying any other report or published information and showing it as my original work,
I understand that I shall be liableand punishable by Institute or University, which may include ‘Fail’
in the examination, ‘Repeat study & re- submission of the report’ or any other punishment that
Institute or University may decide.
Signature:
2
Acknowledgment
I would like to take this opportunity to express my gratitude to all those who havecontributed to the
successful completion of this project report.
First and foremost, I would like to express my deepest appreciation to my supervisor Prof. Sachin
Hadpad sir for his constant support, guidance, and valuable suggestions throughout this project. I
am grateful for the time and effort he invested in reviewing my work and providing insightful
feedback that helped meimprove the quality of this report.
I would also like to extend my appreciation to my friends for their assistance in data collection,
analysis, and research. Without their efforts, this report would nothave been possible.
Signature:
3
Table of Contents
Chapter 1 Introduction
Chapter 9 Bibliography
4
SERIAL NO CONTENT PAGE NO
2. OPERATING RATIO
5. RETURN ON ASSET
7. CURRENT RATIO
8. QUICK RATIO
9. DEBT TO EQUITY
5
CHAPTER 1
INTRODUCTION
6
INTRODUCTION
Ratio analysis is a process of identifying the strength and weakness of the firm by
properly establishing relationship. Analysis of financial statements means
establishing relationship between the items in financial statements for determining
the financial strength and weakness of the business. Therefore, the main purpose
of financial statement analysis is to utilise information about the past performance
of the company in order to predict how it will fare in the future. Another important
purpose of the analysis of financial statements is to identify potential problem
areas and troubleshoot those.
The ultimate aim of any business enterprise is to earn maximum profit. A firm
should earn profits to survive and grow over a long period of time. Profit is an
excess of revenues over associated expenses for an activity over a period of time.
Profit is an excess of revenues over associated expenses for an activity over a
period of time. Management should try to maximise its profit keeping in mind the
welfare of the society. The creditors want to get interest regularly and principle
regularly.
Owners want to get reasonable return on investment. At the end of accounting
period financial statements are prepared by the business enterprise to know the
result of the business operation and the financial position. The financial statement
provides a summarised view of financial position and operation of a firm. Therefore,
much can be learned about a firm from careful examination of its financial
statement
Mahindra and Mahindra Limited has marked its presence with significant
achievements and commands a market leadership status with regard to its
service. It is one of the largest manufactures in Indian automotive industry. Over
the years the company improved with regard to its service. This project is thus
an earnest attempt to analyse profitability of Mahindra and Mahindra Limited
7
ADVANTAGE OF FINANCIAL STATEMENT ANALYSIS
9
Methods or tools or technique of financial statement analysis
10
3. Planning and Forecasting- From a Management and investor point of
view, ratio analysis helps to understand and estimate the company’s future
financials and operations. Ratios formed from past financial statement
analysis helps in estimating future financials, budgeting, and planning for the
future operations of the company.
11
7. Decision Making- Ratios provide important information on the
operational efficiency of the company, and the utilization of resources by the
company. It helps management to forecast and planning for future, new
goals, concentrate on the different markets, etc.
Types of Ratio
12
and liquid liabilities. The ideal level of absolute liquid ratio is
0.5:1 .
Solvency Ratio
a) Debt equity Ratio- this ratio reflects the long term financial
position of a firm and is calculated in the form of relationship
between external equities or outsider’s funds and internal
equities or shareholders fund. Debt equity ratio may also be
called as ‘ratio long term debt to shareholders funs’.
13
Debt Equity Ratio= long term debts/ shareholder funds
Or debt/equity
Profitability ratio
- Profitability ratio is used to evaluate the company’s ability togenerate
income as compared to its expenses and other cost associated with
the generation of income during a particular period. This ratio
represents the final result of the company.
a) Gross profit ratio- This ratio measures the marginal profit of the
company. This ratio is also used to measure the segment revenue. A
high ratio represents the greater profit margin and it’s good for the
company.
14
Net profit ratio = Net Profit / Sales × 100
Net Profit = Gross Profit + Indirect Income – Indirect Expenses
Return on capital employed (ROCE) = net profit before interest and tax /capital employed X 100
15
Chapter 2:
INDUSTRY PROFILE
16
INDUSTRY PROFILE
The India automotive market demand was pegged at 4,266,062 units in 2019. The
market is expected to expand at a compound annual growth rate (CAGR) of 11.3% from
2020 to 2027. According to statistics published in April 2018 by the European
Automobile Manufacturers Association (ACEA), India is ranked fourth in the top ten
global car-
producing countries. The country’s automotive sector is powered by the rising
population, increasing disposable income, and ease of availability of credit and financing.
Additionally, the market is expected to experience elevated demand for commercial
vehicles from the flourishing logistics and passenger transport sector. Government
initiatives and policies are prominent factors influencing market growth and are expected
to upkeep the growth over the coming years
.
In an attempt to promote market growth, the Ministry of Finance had announced a cut in
the corporate tax rate in 2019. This revision in corporate taxes is anticipated to attract
FDI in the country’s manufacturing sector, which is expected to help the automotive
industry marginally. Furthermore, Government initiatives like Make in India and
Automotive Mission Plan 2026 have boosted the Indian automotive sector. The
Automotive Mission Plan 2026 is a collective vision of India's automotive industry and
the government that aims to make the Indian automotive industry the driving factor of the
Make in India initiative. In February 2019, the Indian government approved a fund
requirement of USD
1.39 Billion for the financial years 2020-22 for the FAME-II scheme.
Apart from growing passenger vehicle demand, Light Commercial Vehicles (LCVs) are
anticipated to record substantial growth in the next seven years. LCVs' growth prospects
look favorable, owing to a positive outlook of the country's overall logistics industry. As
retail e-commerce has witnessed a boom over the last few quarters, the hub-n-spoke
business model's proliferation is anticipated to favor sales of LCVs. Vendors are
increasingly focusing on untapped regional markets, including rural and semi-urban
areas, in the country to improve sales. Better credit and financing options are expected
to elevate growth opportunities in these markets over the forecast period.
The increasing adoption of technology in vehicles, industry supply chain and business
models is projected to change the automotive market outlook over the forecasted period.
The advent of automated, electrified, and connected vehicles are aiding the market
growth by making driving easier, safer, and comfortable. Growing awareness of
environmental hazards of emissions from ICE vehicles promotes the users to adopt
alternative fuel vehicles. Government focuses on the shift to electric mobility by providing
tax rebates and
17
subsidies for the adoption of electric vehicles. Thus, the electric mobility trend coupled
with the emergence of technologically advanced vehicles is expected to upkeep the
market growth from 2020 to 2027.
The India automotive market has experienced considerable growth in recent years and
achieved record sales in 2018. However, the market experienced a slump in the year
2019 due to its economic slowdown. Although the market was anticipated to revive in
2020, the spread of the novel coronavirus has further delayed the revival. Growing
preferences for Sports Utility Vehicles (SUVs), rising demand for commercial vehicles in
the logistic sector, and pent-up demand are certain factors expected to drive the market
over the coming years. Additionally, the electrification of vehicles, especially, three-
wheelers, and small passenger cars, is expected to be a major factor influ encing market
growth in the future
18
CHAPTER 3
19
COMPANY PROFILE
Founder
20
J.C Mahindra
K.C. Mahindra
M.G. Muhammad
M.G. Muhammad was an Indian businessman and the founder of Mahindra & Mahindra
company. He was born on 1895 and was a Pakistani politician and financier who served
as the third Governor-General of Pakistan. He did education from Aligarh Muslim
university. After his graduation, he joined
the Indian Civil Service as a chartered accountant at the Indian Railway Accounts Service.
He was very talented. Along with J.C Mahindra, he founded Mahindra & Mahindra
company. on 1956, he died.
Recently, the Chairman of the company is Anand Mahindra and Managing Director and
Chief Executive Officer of Mahindra is Pawan Kumar Goenka.
Networth
21
It is one of the largest vehicle manufacturers by production in India and the largest
manufacturer of tractors in the world. Mahindra & Mahindra is a part ofMahindra Group.
Points Information
22
Company Status Active
Website [Link]
23
CHAPTER 4
OBJECTIVE AND SCOPE OF RESEARCH
➢ To study the trend of profit of Mahindra and Mahindra Limited over the past three years
Research design
Secondary data
Sources of data
The required data for the study are basically secondary in nature and the
data are collected from the audited reports of the company. The sources of
data are from the annual reports of the company from the year 2020-22
Methods of data analysis
The data collected were classified and tabulated for analysis. The analytical
tool used in this study.
• Graph
• Ratio analysis
LIMITATIONS OF STUDY
The study is based on secondary data, obtained from the publish report and
as its finding depends entirely on the accuracy of such data.
DATA ANALYSIS AND INTERPRETATION
This chapter is considered to be the core part of this project work. It is mainly
indented to examine the profitability of the company for the last five years. The
ratio analysis is one of the most powerful tools of financial analysis. It is a process
of computing and interpreting various accounting ratios for arriving at conclusions
about financial position and performance of an enterprise. They are the pointers
or indicators of financial strength, soundness, position or weakness of a concern.
One can draw conclusions about the exact financial position of an enterprise with
the help of financial ratios.
PROFITABILITY RATIOS
10
8
6
4
2
0
RATIO
Net profit ratio shows the relationship between net profit and net sales. Higher the ratio indicates
that operational efficiency of the concern. It can be observed from table that the net profit ratio of
Tata steel shows that there is increase in the net profit margin from the year 2020 to [Link] higher
net profit ratio was observed in the year 2022 that was 8.59% and the lower in the year 2021 and
2020 which is(0.59%) and(2.92%) respectively
15 Chart Title
10
0
RATIO
2020 2021 2022
ANALYSIS
This ratio is used to measure the operational efficiency of the management. It is inferred from
the table that from the 2020 to 2022, the operating profit ratio of the company is11.42% for
2020 and for the year2021 is 13.74% and has dropped to 10.61%2022 .
INVENTORY TURNOVER RATIO
Chart Title
15
10
5
0
RATIO
ANALYSIS:
The Inventory ratio tells us about the average left and the part of inventory sold. In case of
Mahindra and Mahindra the inventory turnover ratio is falling from 13.38% to 8.23 %.
Return on Net Worth/Equity
Chart Title
15
10
5
0
RATIO
ANALYSIS
The return on equity signifies how good the company is at generating returns on the investment it
received from its shareholders. It is inferred from the table that the return on equity of Tata steel is
lower in the year 2020 (3.86%) and (.77%) in the year 2021 and the higher in 2022 that was
(12.66%).
Return on assets (ROA)
Chart Title
8
0
RATIO
ANALYSIS
The return on assets signifies how good the company is at generating returns on the investment it
has made on assets. It is inferred from the table that the return on equity of Tata steel is lower in
the year 2020 (2.63%) and the lower in 2022 that was (.45 %) and 7.35% for the year 2022..
Return on capital employed
Chart Title
14
13
12
11
RATIO
Current Ratio
YEAR CURRENT CURRENT RATIO
ASSETS LIABILITIES
ANALYSIS
The current ratio compares current assets with current liabilities and tell us whether the current
assets are enough to settle current liabilities. It is inferred from the table that the higher current ratio
of Mahindra and Mahindra in the year 2020 was 1.38 in the year 2022 was the same. But in 2021
it fell by 0.04;the ideal ratio is 2:1is usually considered safe. Mahindra and Manidra is condition
which is dissatisfactory.
Chart Title
1.4
1.38
1.36
1.34
1.32
RATIO
Chart Title
1.09
1.08
1.07
1.06
1.05
RATIO
ANALYSIS
A ratio of 1.1 is said to be the ideal quick ratio. To indicate that the company has in its possession
enough assets which may be immediately liquidated to pay off the current liabilities. The table shows
that the highest liquid ratio of Tata steel is 1.08 in the year 2021and 1.07 in the year 2020 and it
is 1.06 for the year2022 that is more than the ideal ratio. Hence the liquid ratio of the company is
satisfactory
LONG TERM FINANCIAL POSITION RATIO OR SOLVENCY RATIO
Chart Title
0.3
0.2
0.1
0
RATIO
ANALYSIS:
The debt equity ratio is a financial ratio indicating the relative proportion of shareholders’ equity and debt
used to finance a company’s assets. In all the years the debt equity ratio of a company is less than
Hence the company is good at maintaining its debt position
PROPRIETARY RATI0
Chart Title
0.7
0.6
0.5
RATIO
ANALYSIS
The high proprietary ratio indicates that a company has a sufficient amount of equity to support the
function of business. The ideal value of the proprietary ratio depends on the risk appetite of the
investors. If the investor agrees to take a large amount of risk, then a lower proprietary ratio is
preferred. It is inferred from the table that the proprietary ratio of Mahindra and Manidra in the year
2020 (0.68) and in the year 2021 (0.58) and in the year 2022 is same as2021 . Hence the proprietary
ratio of the company is satisfactory.
CHAPTER 7 – FINDINGS AND SUGGESTIONS
FINDINGS
The current ratio of the company is not good as it is below the standard level which
is 2:1 whereas Mahindra & Mahindra Limited has a current ratio of 1.38:1 in the
year 2020, 1.34:1 in the year 2021 and 1.38:1 in the year 2022 respectively.
Return on Asset for the year 2022 was 7.35% which is considered as good,
whereas ROA for the year 2020 and 2021 was relatively poor (2.63% for the year
2020 and .45% for the year 2021).
The company’s net profit ratio for the year 2020 and 2021 was relatively low
compared with the year 2022 as it has the net profit ratio of 8.59% (it was 2.92%
for the year 2020 and .59% for the year 2021).
The Operating Profit Ratio of the company was 11.42% in the year 2020, it was
13.74% in the year 2021 while it was 10.61% in the year 2022 all of them are
considered as average compared to the standard ratio of 20%.
The Inventory Turnover Ratio of the company is high for all three years and
higher the inventory turnover ratio the better (it was 13.38% in the year 2020,
11.39% in the year 2021 and 8.23% in the year 2022). A lower inventory turnover
ratio is a sign of weak sales or excessive inventory, also called as overstocking.
The Debt Equity Ratio of the company is .09 in the year 2020, it was .21 in the
year 2021 and .17 in the year 2022 which is relatively poor compared with the
standard ratio of 2 or 2.5.
The company has a good proprietary ratio for all three years (.68 in the year 2020,
in the year 2021 it was .58 and in the year 2022 it was .58)
7.1 SUGGESTIONS
The company should focus more towards the efficiency and proper sales
management to increase their sales margin and earn profit.
Improving the customer satisfaction level by understanding their wants and
needs will also help in retention and expansion of customer base.
Improving management quality with adoption of new methodologies that
reduce operating cost.
Working capital management is to be effectively managed to increase the
liquidity position of the company.
Revise management of capital employed through equity to generate more
Returns.
Provide customized services to look unique and stand out from the market
competition.
CHAPTER 8 – CONCLUSION
The study was conducted with the main objective of analyzing the profitability position
of Mahindra and Mahindra ltd over the last three years from 2020 to 2022. It is found
that ratios are calculated from the financial statements’ which are prepared as desired
by the management and policies adopted on depreciation and stock values and thus
produce only a collection of facts expressed in monetary term and cannot produce
complete and authentic picture of the business and also may not highlight other factors
which affects performance.
Profitability ratios shows that the company profits are very fluctuating every year,
sometimes it is relatively high or close to the average or standard ratio or sometimes it
is very low. The company is becoming inefficient in the utilization and application of
resources to get maximum return. So this is the right time to revise their policies to
overcome the decrease in returns. It is better to change the strategies on sales and in
managing cost of the company.
CHAPTER – 9 BIBLIOGRAPHY
[Link]
[Link]
[Link]